I have a spreadsheet of all the main US coins
that I have developed and have been slowing enhancing.. it has one tab for each type of coin (Cents, Dimes, Quarters, etc.) and then a row of data for each coin and space for you to enter information about each coin including if you own it and if you do the condition and purchase info...
There are, however, some limits to my spreadsheet..
- I don't collect "moderns", so for many of the modern coin sets, I think I only have coin data entered up into 2008 or so.. you can go to the RedBook
and just enter more rows like it is laid-out in the spreadsheet (coin date, mint mark, proof or not proof, population, etc).
- No fields are currently "protected", so you must be careful to enter data only in the "data entry" fields.. if you overwrite something in the coin information fields, then there it is gone.. although you can always "undo" in excel if you realize you made a mistake.
- There are some "calculations" that I use for some of the cells, so if you start inserting rows or moving rows around, you can "break" the calculations and they won't work. For example, I have a row that says "Is Proof?" this is calculated by looking to see if a Coin has a value in the "Proof Population" column or not.
- It is set-up to only store one entry per coin.. so it is great for someone that is just creating a personal collection of coins, but if you start wanting to create multiple versions of coins (such as having three different 1909-S Liberty Wheat Coins in different conditions), then this won't work unless you either create extra "rows" of that coin (you must now how to duplicate rows and then reduplicate the calculations).
- It only has a few of the major "Variations" of some of the coins. I don't really collect varieties and errors.. so if you want to collect these, you will need to know how to enter them yourself manually.
- It makes use of "autofilters" to help find coins.. For example, I have a column called "Am Collecting?" and a column call "Own this Coin?". I use these to create "wish lists" of coins for when I go to shows. I collect a series, collect "Am Collecting=YES" and "Own this Coin=NO" and get my "Want list". But you must know how to turn autofilters on and off for the various columns and clear them.
- If you sort the spreadsheet and aren't careful (such as sort it when you have filters set on or don't include all the columns in your sort), you will "break" the spreadsheet and its calculations, and it can be VERY difficult to reset it.
- So, this works well for someone that is pretty familiar with Excel and some of its "dos" and "donts", but if you aren't careful, you can definitely "break it". And if you start sorting or inserting rows without rebuilding the filters, you will definitely mess things up.
- If interested, you can PM me and I can Email you a "blank" copy that contains some "test data" for the "cents" sheet to show how I use it, but it is "use at your own risk".
PS: Do you think there is a market for something like this if I cleaned it up a bit.. maybe added in some "protection" for some of the columns and some "macros" for some of the key functionality.. and sold it at a fairly low price? Only issue is that I can't offer "support". just an "an is" template for people to use as a starting point? Would probably sell very cheap.. probably a few dollars at most? Thoughts?