Stringtyer
Sr. Member
- Jul 29, 2017
- 361
- 894
- Detector(s) used
- Equinox 600
Tesoro Cutlass
Bounty Hunter Tracker II
- Primary Interest:
- All Treasure Hunting
Since I'm trying to learn as much about my EQ-600 as I can, I've decided to invoke my inner nerd and make a spreadsheet in Google Sheets that I can use to track what I dig. Here's an example from two recent hunts.
I have each entry indexed in order to keep things in their original form after sorting. I use two fields for numbers in order to have a value that will sort individually that way I can easily see what numbers correspond to what finds. The depths are approximate based on the length of my digging tool blade. Looks like I'm going to have to etch depth marks on the blade so I can get a little better estimate.
The biggest problem I see with the sheet so far is the inability to logically sort the find by name. Unless I use the exact same spelling each time I enter an item, the sort would be meaningless. I'm way overthinking this thing but I'm considering creating a database with a drop-down list of items commonly found or, at least, create an alpha-numeric code for each item found (for example, 1=nickel, 2=zinc penny, etc.)
If any of y'all want to weigh in on a different/better way to do what I am doing, feel free to let me know.
I apparently have too much time on my hands but at least this project keeps my mind working.
I have each entry indexed in order to keep things in their original form after sorting. I use two fields for numbers in order to have a value that will sort individually that way I can easily see what numbers correspond to what finds. The depths are approximate based on the length of my digging tool blade. Looks like I'm going to have to etch depth marks on the blade so I can get a little better estimate.
The biggest problem I see with the sheet so far is the inability to logically sort the find by name. Unless I use the exact same spelling each time I enter an item, the sort would be meaningless. I'm way overthinking this thing but I'm considering creating a database with a drop-down list of items commonly found or, at least, create an alpha-numeric code for each item found (for example, 1=nickel, 2=zinc penny, etc.)
If any of y'all want to weigh in on a different/better way to do what I am doing, feel free to let me know.
I apparently have too much time on my hands but at least this project keeps my mind working.
Upvote
0