| Author |
 Replies: 9 / Views: 2,583 |
|
|
Valued Member
United States
254 Posts |
Hello, I am new to the forum and am glad that I stumbled upon it! I started working on a 1909-1958 Lincoln Cent collection back in 2014 and searched 392 boxes or 980,000 pennies by hand and got quite a head start on my collection. I am now getting into nickels and just completed my 4th box and would like to keep track of my find rates. http://goccf.com/t/198187I came across the above post and was curious if anyone has the above excel sheet for me to use? I would like to contribute my numbers to this community and keep track for my curiosity as well. Thank you! |
|
|
|
Moderator
 United States
15400 Posts |
 to the CCF Amazing that you found that old thread of mine. At this point I have stopped CRH for nickels but do recall hours of fun doing so when I was in pursuit of my bank roll set. My nickel searching ended in 2019 at 390,400 nickels. I, of course, still have the Excel spreadsheet that I developed to keep track of my searching finds. I have declined to share it with anyone however. Primary reason is that without an understanding of the math behind my calculations the spreadsheet I developed would be of little use to you. I am willing to offer advise and tips you or anyone who wishes to develop your own Excel tracking method. Suggest you give a thorough read to the thread and pay particular attention to the mathematical description of 'circulation obsolescence' that I discussed. Once you understand how the math works, putting the formulas into an Excel spreadsheet is no big deal. Send along any questions you have and I'll do my best to help. Best of wishes in your searching. I look forward to reading your CCF updates.  . |
|
Pillar of the Community
Canada
9157 Posts |
I have an excel sheet for you to look at but I have to go out right now so later today.
|
|
Valued Member
 United States
254 Posts |
Hi nickelsearcher, That is an incredible amount of coins! I am averaging a box per night right now. I do have a degree in finance and accounting, so the math I am sure would not be too hard to understand :) I would love to use your spreadsheet, but if not no worries. With this being the year 2023 I would like to compare your numbers that you had obtained nearly a decade ago. So far in my first 4 boxes I did find a 1938 plain, a dateless Buffalo nickel, a 1981 S proof, and maybe about 50 coins from the 40's and 50's. No silver :( Thank you for the replies! |
|
Bedrock of the Community
United States
19134 Posts |
Taking this much further, would be interesting to have a master Excel spreadsheet tracking 'found coin' info tied to geographic location--perhaps to the zip code level, or by county where the boxes/rolls/change were obtained. Then, show this information spatially on a map. Something like a 'heat map' indicating the amount of coins found (and presumably searched) geographically--not just how many, but also a 'catalog' of key varieties/errors/mints/etc. Compare Spokane metro area finds (cents, nickels, dimes, quarters, halves) with Baxley, GA, or metro New York, or Winnemucca, NV. Visualizing data in a spatial manner often reveals unanticipated conditions/trends in an interesting way.
Anyway, this won't go anywhere (lots of wok, many variables), but is fun to think about.
|
|
Moderator
United States
187950 Posts |
to the Community! |
|
Pillar of the Community
Canada
9157 Posts |
@nickelguy88 I just saw you do not have email - not enough post , so I will not be able to send you my spread sheet but it sounds like it's not what you want.
|
|
Pillar of the Community
United States
2910 Posts |
Quote:
Taking this much further, would be interesting to have a master Excel spreadsheet tracking 'found coin' info tied to geographic location--perhaps to the zip code level, or by county where the boxes/rolls/change were obtained. Then, show this information spatially on a map. Something like a 'heat map' indicating the amount of coins found (and presumably searched) geographically--not just how many, but also a 'catalog' of key varieties/errors/mints/etc. Compare Spokane metro area finds (cents, nickels, dimes, quarters, halves) with Baxley, GA, or metro New York, or Winnemucca, NV. Visualizing data in a spatial manner often reveals unanticipated conditions/trends in an interesting way.
Anyway, this won't go anywhere (lots of wok, many variables), but is fun to think about. The geographic distribution of coins has actually been something I've always had an interest and curiosity about - something I've always wanted to study more in depth... The data for 1955-P nickels and both 2009 nickels is of particular interest to me as the former was largely hoarded and doesn't show up as often here near Los Angeles as it should, based on the mintage... my 2009-P find rate seems to be pretty similar to most people's, or maybe slightly better than average, but I seem to have much better luck than the rest of the country when it comes to the 2009-Ds. This is 7 years worth of searching, 1,508,960 nickels total through this Monday - the equivalent of 754.48 boxes.  CRH Nickeloholic. 1,600,000 nickels searched in eight years! Have found FOUR complete Jefferson sets!
|
|
Valued Member
United States
254 Posts |
John, thank you for the info! 1.5 million nickels wow!
I'm at 8,000 as of last night, I'm going to try to average a box per night or until my Jefferson set is complete, whichever comes first.
I've only found the usual suspects so far, no silver, and a buffalo.
When I first started on this nearly a decade ago before life got busy I recall finding at least one silver per box.
Fun stuff! I'm excited to share this quest with you all and love the feedback!
|
|
Valued Member
Canada
333 Posts |
Cool information John! Thank you!
|
| |
Replies: 9 / Views: 2,583 |
|
Posted 04/19/2023 08:36 am
