Keeping track of your finds

[Ghondi]

Do you keep track of your CRH finds?
How do you do such? *spread sheet, notepad, etc.*
What do you keep track of?

I kept track of the stuff I got from CRH...but not the stuff I got in change etc.

 

Amazon Forum Fav 👍

A History of Mining on the Kenai Peninsula, Alaska - Grab it through Amazon!

[Immy]

I use a variety of things.

- TNet of course for my year totals

- A small notebook for war nickels, buffalos and foreign coins

- Large index cards for halves and pre-1960 nickels

- Two hand-held manual calculators (remember those?) to track total wheaties and Canadian pennies

- Coin Prices magazine. A red hi-liter turns their price lists into instant checklists

 

[Joe88]

Hi,
I use a map program (Street Atlas USA). I map all the banks I go to and label when I go, what I find, etc.
Its very easy to check when the last time I was there and what I found. I also keep a chart of all of the coins I find.
Joe

 

[GMan00001]

I use multiple Excel spreadsheets.

1) Overall US and Canadian collection totals
* Tracks how many of each date/mintmark/variety of each denomination (currency included) I have in my collection
* Also tracks how many I am looking for of each date/mintmark/variety of each denomination.
* Gives percent complete for each series.

2) Foreign coin collection totals
* Very basic for now, just how many of each I have by country/denomination/year

3) 2008 Trip Report
* Tracks which bank I went to on which day
* What I did at each bank (cashed in or purchased)
* Results of every purchase including how many of each error I searched for or other categories that I track.

4) Total Found in 2008
* Tracks how many of each date/mintmark/variety that I found (only for ones I keep)

5) 2008 TNet Group Tracking List
* Use this to keep track of the tracking list thread.

6) 2008 Personal Tracking List
* Similar to #5, except only tracks what I personally found.

7) Lifetime Personal Tracking List
* Also similar to #5, except it is what I personally found over my lifetime (at least what I can verify that I found)

#4, #5, #6, and #7 are essentially the same spreadsheet with different data.

If anyone wants a blank copy of any of these spreadsheets, just pm me a non-TNet email address that can handle the size. Note: Zipped up these files will likely be over 1 MB total, but I think they will be under 2 MB unless the size changes drastically with the improvements I made for 2008.

** Update ** Just cleaned up the files a bit and zipped up the three main ones and it turns out it is only 682 KB.

 

[Silver_Fox]

I use an Excel spreadsheet.

 

[vegasmtl]

Just got Gman's tracking excel sheets. They ROCK! Very detailed, and I plan to copy a version for MD'ing as well as CRH. Thanks Gman!

HH
vegasmtl

 

[GMan00001]

Just got Gman's tracking excel sheets. They ROCK! Very detailed, and I plan to copy a version for MD'ing as well as CRH. Thanks Gman!

HH
vegasmtl

No problem.

 

[Ghondi]

I just got it as well.

Thank you Gman.

Much better than my notepad file...

 

[GMan00001]

I forgot to mention to those of whom I have sent out the spreadsheets, if you find errors let me know about them so I can fix them in my own copy.

Thanx.

 

[goldencoin]

excel- i'm gonna use my stats to create an average at the end of the CRH'ing season

HH
-GC

 

[cyberdan]

I also use an excel spreadsheet.
Keeps track of:
*coin in(deposit)/cash out(ATM) at all banks
*coins purchased/silver found
*current value of all silver
*cents purchased/copper found (with percentage found)

In 2007 I had 385 rows of entries, last night I copied it and made a new one for 2008 but I wanted to carry over all the 2007 totals. Major rewrite of some formulas so everything balances.

 

[MrMorph]

I just got Gman's spreadsheet, it is truly amazing.... I am glad someone took the time to do this so that I don't have to procrastinate about it anymore. Thanks again!!!!