Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Coin Software
>
Reply to Thread
Message:
<p>[QUOTE="Ed Zak, post: 25227, member: 824"]My excel spreadsheet...</p><p><br /></p><p>My columns are labeled (2 rows) as such:</p><p><br /></p><p>Description - Number Minted - Grade - Cost - Date Acquired - 2005 <span style="color: red"><b>Red</b> </span> Book Values for EF-40, MS60, MS63, MS/PR65</p><p><br /></p><p>So an entry would look like this:</p><p><br /></p><p>1931-S Lincoln 1c - 866,000 - PCGSMS64Rd - $195 - 2/03 - 75.00 - 90.00 - 100.00 - n/a</p><p><br /></p><p>or...</p><p><br /></p><p>1878 8TF Morgan $1 - 750,000 - MS63 - $130 - 7/03 - $24 - $110 - $150 - $1,200</p><p><br /></p><p>For my Lincolns with mintages less than 20 million, I bold the description with a <b><span style="color: blue">blue font</span> </b>. For mintages less than 10 million, I bold with a <b><span style="color: red">red font</span> </b>. Also, for key date coins, I list in either Blue (semi-key) or Red (key).</p><p><br /></p><p>Also, recently I started adding a hyperlink to pictures I have of some of my nicer coins. I can either pull out my collection or show it on my notebook computer.</p><p><br /></p><p>Now I know what many of your are thinking...why do I put Red Book values for the various grades? I look at it this way...it's once per year that I am updating my collection. Red Book's are well received in our hobby and I am just looking for a "gauge" of the values. If Iwant something more current, I go to Grey Sheets. But at least I can reference these values if somebody asks. It doesn't take long and I get a kick out of how the values change from year to year. </p><p><br /></p><p>I break out my collection by denominations with cents listed first and by oldest first to the next higher denominations. The excel spreadsheet atomatically dates any changes and I keep it current.[/QUOTE]</p><p><br /></p>
[QUOTE="Ed Zak, post: 25227, member: 824"]My excel spreadsheet... My columns are labeled (2 rows) as such: Description - Number Minted - Grade - Cost - Date Acquired - 2005 [COLOR=red][B]Red[/B] [/COLOR] Book Values for EF-40, MS60, MS63, MS/PR65 So an entry would look like this: 1931-S Lincoln 1c - 866,000 - PCGSMS64Rd - $195 - 2/03 - 75.00 - 90.00 - 100.00 - n/a or... 1878 8TF Morgan $1 - 750,000 - MS63 - $130 - 7/03 - $24 - $110 - $150 - $1,200 For my Lincolns with mintages less than 20 million, I bold the description with a [B][COLOR=blue]blue font[/COLOR] [/B]. For mintages less than 10 million, I bold with a [B][COLOR=red]red font[/COLOR] [/B]. Also, for key date coins, I list in either Blue (semi-key) or Red (key). Also, recently I started adding a hyperlink to pictures I have of some of my nicer coins. I can either pull out my collection or show it on my notebook computer. Now I know what many of your are thinking...why do I put Red Book values for the various grades? I look at it this way...it's once per year that I am updating my collection. Red Book's are well received in our hobby and I am just looking for a "gauge" of the values. If Iwant something more current, I go to Grey Sheets. But at least I can reference these values if somebody asks. It doesn't take long and I get a kick out of how the values change from year to year. I break out my collection by denominations with cents listed first and by oldest first to the next higher denominations. The excel spreadsheet atomatically dates any changes and I keep it current.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Coin Chat
>
Coin Software
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...