Wanting An Excel Sheet For US Cents

Click on and read RULES,top of page.
John1

What specifically are you looking for? Just date/mm, or varieties too?

During my roll hunting days, I tracked my nickel collection with a spreadsheet; took 60 seconds to make a simple one:

1. Open a new book
2. Write "Date" in A1
3. P in B1
4. D in C1
5. S in D1
6. Put 1859 in A2
7. Click and hold the little black box at the bottom right corner of A2. Drag it ALLLLLLL the way down to fill on the rest of the dates
8. You now have a spreadsheet!


E: Come to think of it, maybe we could have a sticky here with links to download free-to-use spreadsheets? I don't have easy access to the one I made (its on the backup drive; my computer bricked itself a few years ago) but I would happily share it - I had it tricked out to automatically calculate total count, face value, and melt value for silver.

I could post that for you, but they are on competing links.

I don't want to be dealt with 'swiftly'. I like it here.

Thanks guys I appreciate all the info

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?

Regards,

Michael

yep. that's exactly what I did.

I found a few templates and inventory sheets, and combined them together and then added a bunch of my own fields as well.
I don't collect anything that is later then the 1980s, so I'm not worried about keeping it updated with "new additions" of coins/proof sets/special releases that come-out every year, so once I have the old data entered I can just tweak as I need to..

Good luck..

Michael

Michael