Message:

<p>[QUOTE=&quot;kaparthy, post: 52372, member: 57463&quot;]<b>One Man&#039;s Trash is Another Man&#039;s Treasure</b></p><p><br /></p><p>Can we assume that you are asking about keeping track of mainstream U.S. coins such as Lincoln cents and Franklin halves?&nbsp; You want to note the usual basic information (Date, Mint, Grade, Variety. Price Paid. Current &quot;Trends&quot; Price.)&nbsp; The field for &quot;Variety&quot; can get complicated.&nbsp; Excel lets you append &quot;Notes&quot; to fields.&nbsp; The most recent versions allow the inclusion of scans.&nbsp; Older versions of Excel at least support a link to a scan by filename.</p><p>Other information might include date of purchase, place, dealer&#039;s name and contact information, etc.</p><p><br /></p><p>As long as you are grading the coin and have the spreadsheet for a tool, you might as well take a nod from ancients and early US copper and grade both sides sepately.&nbsp; Usually, this is not a big deal.&nbsp; We give one grade to a coin with US numismatics.&nbsp; But, really, the two sides are not equal in importance.&nbsp; A bad bag mark on the reverese usually does not detract as much as the same mark in the same place on the obverse.&nbsp; An old coin from an old collection will have &quot;cabinet friction&quot; on one side, but not the other.&nbsp; </p><p><br /></p><p>Basically, just start.&nbsp; With Excel, you can add, change, delete, copy, import, export, etc.&nbsp; It would be some kind of minor miracle if you took an existing collection and created the one perfect spreadsheet for it.</p><p><br /></p><p>In fact, you might find that rather than having <u>one</u> collection, you have <u>several.</u>&nbsp; Using the same spreadsheet for Bust Halves and Lincoln Cents might be like trying to play football and baseball in the same park.&nbsp; The lines have to be different and that&#039;s just that.&nbsp; And that&#039;s assuming that you never collect Conders, Civil War Tokens, obsolete currency, stocks, checks, ancients, medieval, or a hundred other things that are all under &quot;numismatics.&quot;[/QUOTE]</p><p><br /></p>

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