well i got bored last night. so i pulled out the album. and had the wife show me how to use excel. and made a list of the wheats and grades. i based these from dealer grades of coins i have purchased, and opinions from people on others.
Right on Jon, looks good !! Organization is scary for me, I'm not used to it, but once you get started, it's like a snowball downhill....gets easier
Nice set. I have a dumb suggestion for your excel program. When you type the Philadelphia dates, type them 1909-. The dash makes excel treat them as words (like the 1909-S) rather than numbers. That way, all of your dates will line up.
Nice set! :thumb: Now you have to take pics of every one of them. Lol, just joking, are you planning on finishing it? :thumb: Phoenix
LOL the set or the list? just kidding, yes i plan on completing both the set and the list. and upgrading all the lower grades eventually. Arizona Jack has some very nice ones that i would love to buy off his website for my set. but alas, i am a little short. so my plans are on hold till my wallet gets fatter.
remember this is the internet, so tread lightly with what you share - a sad fact, but one that warrants repeating. i'd hate to read about the collection down the road. -da baron
well you talked me into it. i bought a camera. i could have used the money to upgrade a few coins. but oh well Arizona Jack has a lawaway program. so i guess i still can i just have to figure out what i want from his nice selection. i guess i will see how good it is when it gets here. it looks nice. http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&rd=1&item=200210461872&ssPageName=STRK:MEWN:IT&ih=010
John, thats a way better camera than I use, so you should be able to really step it up a notch for sure. Now, I took GDJMSP's advise and went to a Reveal bulb, adjusted the white balance, and bingo...good coin pics with no real fancy setup. GOOD LUCK !! I have smacked my puter screen twice now Jon, bugs are my pet peeve. Nice one !!
Back to your Excel Work sheet. My suggestion is to enter a date and mint mark for all coins in the collection regardless of if you have them or not. Now leave the grade column empty to indicate you do not have that coin. This way you have a list of all the possible coins you should, could or just eventually want. Example is list the 09S VDB but no other entry. Next suggestion is to add a column for the grade number. Note for example you have a VG for Very Good but you possibly may think it is a -8 or -7. Regardless you could use this column for possilbe later upgrades. Another example is a MS-60 could later be upgraded to a MS-62 so now all you have to do is change the 0 in -60 to 2 in -62. You could also use this new column to add RB, R, Br, etc. My next suggestion is something you will not like. You should change all the grades to capitals to match everyone elses abbreviations for those grades. ef becomes EF. Then naturally change Condition to Grade. Adding columns is free so don't worry about adding columns. What you could do is save your Excel Spread sheet as it presently is, put on a disc, flash drive, etc. Now you can try all kinds of other things with the one on your computer and if you make a mess of it, so what. You still have the original. Another suggestion is why bother with a - for the P coins? If no mint mark just leave the date as 1939, no dash required. Slowly this list will get bigger so have your wife show you how to make each line smaller in hight. Of course you then will have to make the letters smaller in height also. OR you could just end up with several pages for each collection. Mine is 3 pages long. Now if you really get going with Excel you could add another column for values. You could enter a value for each coin based on numerous sources and note at the bottom that this is an estimate only. Next have your wife show you how to use the ADDITION formulae per column so that as you enter a value Excel will automatically add up everything in that column. It is =SUM(E4:E72) type nominclature. Of course you must enter the column number you are using, not the E in my example. Same with the 4 and 72. Those are the line numebers and they are what you have used. I further suggest you save the original without the grades and values. Then you could use this format for addtional sets with different grades and values.
i think this is the final draft. if anyone wants to use this pm me, and i will email it to you. or just copy from here.
