| Author |
 Replies: 12 / Views: 1,308 |
|
|
Valued Member
United States
346 Posts |
How do you guys keep track of what you find when roll searching? Do you write everything down- the amount of coins searched, what was found... or do you you make a spreadsheet and track all the finds?
Ultimately I want a format that will let me know where and when I got certain finds, which theoretically should help me assess where I should look for or order my coins from.
|
|
|
|
Valued Member
United States
271 Posts |
I keep a word document for each of the roll types that I search. I keep spreadsheets for my sets, and working on a spreadsheet system for my albums / binders. I guess a spreadsheet would work for roll-hunting finds as well, as it will be an organized way to keep track of when/where you found certain things. I mainly work with two branches of the same bank, one is my pick up point (much better results from them), and the other is my dump, so I pretty much know where all my finds come from...
|
|
Valued Member
United States
67 Posts |
For my cent roll hunting I print out a spread sheet with dates '59-'08, and spots for total wheats, canadian, damaged, etc. As I get the years sorted out, I write down the total. Then when I'm finished, I can easily see what I found.
|
|
Pillar of the Community
United States
6326 Posts |
I post my finds up here and then people can always remind me later ! Ha Ha...   Edited by eaglefoot
08/12/2008 09:12 am
|
|
Moderator
 United States
187862 Posts |
I do not regularly roll-search anymore, but if I did, I would use a spreadsheet.
|
|
Pillar of the Community
United States
1807 Posts |
I move them from one pile to the other and then I start all over again when the starting pile is empty.
Just kidding. I am new at this so that is a very good question. Thanks
Edited by rockdude
08/12/2008 10:55 am
|
|
Pillar of the Community
United States
533 Posts |
I kept track of the last box that I went through, but that was a bit time consuming. Anything that I keep, I write FIR (found in roll) and the date on the back lower left of the 2x2 and . Any silver that I find that doesn't go into a 2x2 I just put into a tube with the rest of my FIR silver.
I only have am planning on having the coins that I bought in a spreadsheet. Well, at least until I finish my Kennedy set, then I will put them in a spread sheet with FIR in the cost box.
|
|
Valued Member
 United States
346 Posts |
I figure spreadsheets are the best way, but I can't for the life of me think of a good format/layout for the spreadsheet that will serve as an adequate list/log of my finds.
|
|
Valued Member
United States
429 Posts |
The first step is to figure out what you want the list to show: every coin I searched, Wheaties, varieties...This list will be what you would put on the left side column. I would then have spaces along the top for dates you searched and the quantity. This is something that I personally have been thinking about for awhile but also not sure what I want it to display yet. There is NO way I want to document every single coin one day and then I NEED to the next. I am thinking of setting up a few different types of lists and go from there. Personally, I mainly collect cents and there are spreadsheets that others have made and put on the net for others as well, but it just does not always do what you want so you will always adjust it to your own needs. For the list I am talking about go to: http://www.lincolncentresource.com/...cklists.html and pick the one that best suits you. |
|
Valued Member
United States
369 Posts |
I use a bar chart in Word. One for each denomination, a different colored bar for P,D,S mints. Actually, I'm only doing nickels at the moment, so I keep track of the nickels I find dated 1938-1970. Then I use a text box below the chart for total # of rolls searched and stuff like that. My charts look like the one that gave me the idea in the first place, which can be found here: http://life-of-coins.blogspot.com/2...results.htmlIt works great for me. |
|
Valued Member
United States
369 Posts |
I use a bar chart in Word. One for each denomination, a different colored bar for P,D,S mints. Actually, I'm only doing nickels at the moment, so I keep track of the nickels I find dated 1938-1970. Then I use a text box below the chart for total # of rolls searched and stuff like that. My charts look like the one that gave me the idea in the first place, which can be found here: http://life-of-coins.blogspot.com/2...results.htmlIt works great for me. |
|
Valued Member
United States
369 Posts |
Sorry, I didn't mean to do that.
|
|
Valued Member
United States
346 Posts |
That's a very interesting way to do it. I like it. Any way you could post a template of sorts for it?
|
| |
Replies: 12 / Views: 1,308 |
|
Posted 08/12/2008 12:11 am
