Tracking Spreadsheets

[hokiemojo]

When I had just started CRHing, there were a few posts on here about tracking spreadsheets used to keep up with your finds. While everyone has their own purposes and needs from tracking software, none of the posted sheets had what I was looking for.

Since it's been a while, I wanted to see if any of the new members had any cool spreadsheets to share.

Thanks all!

 

Amazon Forum Fav 👍

Diving for Pleasure and Treasure - Grab it through Amazon!

[maverick]

Hey Hokie, I guess I'm just old fashioned but, I have a composition book that I just write what I found that day in and keep a running total going so I know exactly what I have and when I found it , works fine for me, then again, I'm a pretty simple guy though, others may like all that info on their comp but if you comp crashes or something all that info could be lost. Just the way I do it, I'm sure everyone will have a different way. HH, Maverick.

 

[InCladWeTrust]

I use numbers on Mac I just enter the date amount searched and what I found and it keeps a running tally at the bottom of total $ searched found and averages as well as total ounces found and total silver value

 

[hokiemojo]

hmmm, so no one uses spreadsheets to keep track of dump locations, current ag value, account balances, etc? I figured there would be some tech junkies who'd take it too far. I'm in the process of building something, but it's not ready for primetime (or even infomercial hours) yet. hopefully I'll have something soon.

 

[FormerTeller]

Google spreadsheets.

 

[Mr. Silver Stash]

i have a spreadsheet that tracks pickup & dump banks, sorted by town, with address, phone numbers and a column for order dates & details, even contact teller names. I use it to highlight which banks I already called to order & which I already picked up from weekly.

I use another spreadsheet to track total finds by coin type, silver content by type, total silver by type, then columns that track sales, and the final columns track totals "on hand" by subtracting the two using formulas. Makes tracking my progress easy. I used to track finds by the week & subtotal the oz & $ searched, now I just reconcile my stacks to the sheets "on hand" totals, and make changes. I also estimate total $ searched every so often.

I am an Business Manager for a non-profit (for another week or so until I switch jobs), so I guess nerd is in my blood. Happy Hunting, Jonathan

[TABLE="width: 1086"]
[TR]
[TD][/TD]
[TD]JJ Silver Stash[/TD]
[TD][/TD]
[TD][/TD]
[TD]12/15/2012[/TD]
[TD]Spot Silver/oz[/TD]
[TD] $ 32.41[/TD]
[TD][/TD]
[TD="colspan: 2"]Sold[/TD]
[TD="colspan: 3"]On hand[/TD]
[TD]On Hand Face Value[/TD]
[TD] Total Face Value [/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Coin Type[/TD]
[TD]Silver %[/TD]
[TD]# found[/TD]
[TD] oz silver/coin[/TD]
[TD]Total Silver (oz)[/TD]
[TD] Total $ [/TD]
[TD] $ Per Coin [/TD]
[TD]#[/TD]
[TD]oz[/TD]
[TD]#[/TD]
[TD]oz[/TD]
[TD] $ melt [/TD]
[TD]Boxes[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Half Dollars 1965-1969[/TD]
[TD]40%[/TD]
[TD]711[/TD]
[TD]0.1479[/TD]
[TD]105.1569[/TD]
[TD] $ 3,408.14[/TD]
[TD] $ 4.79[/TD]
[TD]697[/TD]
[TD]103.0863[/TD]
[TD]14[/TD]
[TD]2.0706[/TD]
[TD] $ 67.11[/TD]
[TD] $ 7.00[/TD]
[TD] $ 355.50[/TD]
[TD] $ 180,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Half Dollars 1970 & 1976 [/TD]
[TD]40%[/TD]
[TD]7[/TD]
[TD]0.1479[/TD]
[TD]1.0353[/TD]
[TD] $ 33.55[/TD]
[TD] $ 4.79[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]7[/TD]
[TD]1.0353[/TD]
[TD] $ 33.55[/TD]
[TD] $ 3.50[/TD]
[TD] $ 3.50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Kennedy Halves 1964[/TD]
[TD]90%[/TD]
[TD]91[/TD]
[TD]0.36169[/TD]
[TD]32.91379[/TD]
[TD] $ 1,066.74[/TD]
[TD] $ 11.72[/TD]
[TD]21[/TD]
[TD]7.59549[/TD]
[TD]70[/TD]
[TD]25.3183[/TD]
[TD] $ 820.57[/TD]
[TD] $ 35.00[/TD]
[TD] $ 45.50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]90% Silver Proofs[/TD]
[TD]90%[/TD]
[TD]5[/TD]
[TD]0.36169[/TD]
[TD]1.80845[/TD]
[TD] $ 58.61[/TD]
[TD] $ 11.72[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]1.80845[/TD]
[TD] $ 58.61[/TD]
[TD] $ 2.50[/TD]
[TD] $ 2.50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Half Dollars 1918-1963 [/TD]
[TD]90%[/TD]
[TD]55[/TD]
[TD]0.36169[/TD]
[TD]19.89295[/TD]
[TD] $ 644.73[/TD]
[TD] $ 11.72[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]55[/TD]
[TD]19.89295[/TD]
[TD] $ 644.73[/TD]
[TD] $ 27.50[/TD]
[TD] $ 27.50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Pre-1965 Dimes[/TD]
[TD]90%[/TD]
[TD]500[/TD]
[TD]0.07234[/TD]
[TD]36.17[/TD]
[TD] $ 1,172.27[/TD]
[TD] $ 2.34[/TD]
[TD]166[/TD]
[TD]12.00844[/TD]
[TD]334[/TD]
[TD]24.16156[/TD]
[TD] $ 783.08[/TD]
[TD] $ 33.40[/TD]
[TD] $ 50.00[/TD]
[TD] $ 85,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mercury Dimes[/TD]
[TD]90%[/TD]
[TD]86[/TD]
[TD]0.07234[/TD]
[TD]6.22124[/TD]
[TD] $ 201.63[/TD]
[TD] $ 2.34[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]86[/TD]
[TD]6.22124[/TD]
[TD] $ 201.63[/TD]
[TD] $ 8.60[/TD]
[TD] $ 8.60[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Barber Dimes[/TD]
[TD]90%[/TD]
[TD]4[/TD]
[TD]0.07234[/TD]
[TD]0.28936[/TD]
[TD] $ 9.38[/TD]
[TD] $ 2.34[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]0.28936[/TD]
[TD] $ 9.38[/TD]
[TD] $ 0.40[/TD]
[TD] $ 0.40[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Pre-1967 Canadian Dimes[/TD]
[TD]80%[/TD]
[TD]18[/TD]
[TD]0.0599[/TD]
[TD]1.0782[/TD]
[TD] $ 34.94[/TD]
[TD] $ 1.94[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]18[/TD]
[TD]1.0782[/TD]
[TD] $ 34.94[/TD]
[TD] $ 1.80[/TD]
[TD] $ 1.80[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1967-1968 Canadian Dimes[/TD]
[TD]50%[/TD]
[TD]5[/TD]
[TD]0.0375[/TD]
[TD]0.1875[/TD]
[TD] $ 6.08[/TD]
[TD] $ 1.22[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0.1875[/TD]
[TD] $ 6.08[/TD]
[TD] $ 0.50[/TD]
[TD] $ 0.50[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]War Nickels[/TD]
[TD]35%[/TD]
[TD]44[/TD]
[TD]0.056[/TD]
[TD]2.464[/TD]
[TD] $ 79.86[/TD]
[TD] $ 1.81[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]44[/TD]
[TD]2.464[/TD]
[TD] $ 79.86[/TD]
[TD] $ 2.20[/TD]
[TD] $ 2.20[/TD]
[TD] $ 1,200[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Pre 1968 US Quarter[/TD]
[TD]90%[/TD]
[TD]72[/TD]
[TD]0.18084[/TD]
[TD]13.02048[/TD]
[TD] $ 421.99[/TD]
[TD] $ 5.86[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]72[/TD]
[TD]13.02048[/TD]
[TD] $ 421.99[/TD]
[TD] $ 18.00[/TD]
[TD] $ 18.00[/TD]
[TD] $ 22,500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Pre 1968 Canada Quarter[/TD]
[TD]80%[/TD]
[TD]1[/TD]
[TD]0.15[/TD]
[TD]0.15[/TD]
[TD] $ 4.86[/TD]
[TD] $ 4.86[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0.15[/TD]
[TD] $ 4.86[/TD]
[TD] $ 0.25[/TD]
[TD] $ 0.25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1968 50% Canadian quarters[/TD]
[TD]50%[/TD]
[TD]1[/TD]
[TD]0.0937[/TD]
[TD]0.0937[/TD]
[TD] $ 3.04[/TD]
[TD] $ 3.04[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]0.0937[/TD]
[TD] $ 3.04[/TD]
[TD] $ 0.25[/TD]
[TD] $ 0.25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]American Silver Eagles[/TD]
[TD]90%[/TD]
[TD]4[/TD]
[TD]1[/TD]
[TD]4[/TD]
[TD] $ 129.64[/TD]
[TD] $ 32.41[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]4[/TD]
[TD]4[/TD]
[TD] $ 129.64[/TD]
[TD] $ 4.00[/TD]
[TD] $ 4.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Morgan Silver Dollars [/TD]
[TD]90%[/TD]
[TD]2[/TD]
[TD]0.7734[/TD]
[TD]1.5468[/TD]
[TD] $ 50.13[/TD]
[TD] $ 25.07[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2[/TD]
[TD]1.5468[/TD]
[TD] $ 50.13[/TD]
[TD] $ 2.00[/TD]
[TD] $ 2.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Peace Silver Dollars[/TD]
[TD]90%[/TD]
[TD]6[/TD]
[TD]0.7734[/TD]
[TD]4.6404[/TD]
[TD] $ 150.40[/TD]
[TD] $ 25.07[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]6[/TD]
[TD]4.6404[/TD]
[TD] $ 150.40[/TD]
[TD] $ 6.00[/TD]
[TD] $ 6.00[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]1 oz silver rounds[/TD]
[TD]100%[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD] $ 97.23[/TD]
[TD] $ 32.41[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]3[/TD]
[TD] $ 97.23[/TD]
[TD] $ - [/TD]
[TD] $ - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD]5 oz ATB rounds[/TD]
[TD]100%[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD]5[/TD]
[TD] $ 162.05[/TD]
[TD] $ 162.05[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]1[/TD]
[TD]5[/TD]
[TD] $ 162.05[/TD]
[TD] $ - [/TD]
[TD] $ - [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD]1616[/TD]
[TD]Total[/TD]
[TD]238.66907[/TD]
[TD] $ 7,735.26[/TD]
[TD] [/TD]
[TD]884[/TD]
[TD]122.69023[/TD]
[TD]732[/TD]
[TD]115.97884[/TD]
[TD] $ 3,758.87[/TD]
[TD] $ 152.90[/TD]
[TD] $ 528.50[/TD]
[TD] $ 288,700[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Melt $[/TD]
[TD] $ 3,976.39[/TD]
[TD][/TD]
[TD] Cash [/TD]
[TD] $ 1,450.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Rec'd $[/TD]
[TD] $ 2,817.00[/TD]
[TD][/TD]
[TD]Total Profit[/TD]
[TD] $ 5,208.87[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$ for buys[/TD]
[TD]($400)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]250+100+50+72[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[/TABLE]

 

[hokiemojo]

Now that is what I'm talking about. That is pretty sweet. My vision is to create something similar, but the objective would be to track the entire process from beginning to end. IT would have a link to routes, differentiate between bought and found, consolidate it all to track the basis and the current value, and much much more. MY only issue is that I don't know if I'll have the discipline to keep up with it (plus I do low volume). This was more about the concept. I love the results sheet you posted. thats fanatastic.

 

[Mr. Silver Stash]

I would have uploaded the excel file if Tnet supported those files. I have a few relatively small purchases mixed in there (e.g. I did not find the 5 oz ATB CRHing haha) but I used selling some 40% to upgrade to some of my purchases. Also, one error on the sheet is I didn't log the $850 I received for selling my last batch of 40%'s, so my total cash received this year is about $3650. I like keeping results like this because I have really detailed results to analyze, and can see where I am getting the most ROI and what I have on hand at my finger tips.

Find out how much info you can really keep up with, and start logging it. My weekly finds & tracking boxes searched got way too tedious, but I track that which I have the discipline to actually do. I hope you post the results of your spreadsheets some time soon! - Jonathan

 

[bigscores]

Pm me your email and ill send you a clean copy of my spreadsheet.

 

[Eldar11]

I remember a thread a while ago about spreadsheets, a user made a template for half dollars. Here's the thread:

http://www.treasurenet.com/forums/c...-half-dollar-crh-spreadsheet-google-docs.html

I really liked it, and I've added things and edited it, and modified it for use for dimes and nickels. The best part about it is that it auto-updates the price of silver from APMEX continuously so you always know what everything is worth.