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

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

 

[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.