My Free Metal Detecting Computer Log - tell me what you think

[treasurefiend]

I made this program using Microsoft excel. And yes this is me in the video. I made it so you just enter the amount of coins / rings it the corresponding spot, and it will keep a running tally for you, please see the video and see for yourself. If you want me to send it to you, Send me a PM with your email address. and let me know if you want a 30 hunt, 60 hunt, 90 hunt, or a 120 hunt log book. You need to have Microsoft excel though. I am giving this away for free because I think people will really like it.

Hunting Log

I just added a section for platinum jewelry and gold coins. keep the feedback coming, thanks for your interest...

 

[SNOWY]

Hey Treasurefiend, that's great!

I'm not familiar with using XL, and our coins are not the same Down-under !

Impressive.

 

[Andrus(ut)]

the face value cell so it is automatic. For me it would be easier to just enter the coins and not have to calculate face. Very nice though.

 

[C. Nyal de Kaye]

Hello Tresurefiend,
I like the idea but, as Snowy points out, we have different coins, and differing treasures here. One similarity is that we also have pull tabs by the million. As you have "protected" it, and necessarily so, we could not adapt it to suit detecting in Oz. Thanks for offering it, and I just might steal a few of your ideas!

 

[treasurefiend]

I am getting emails left and right, a lot of them on what to add more sections. So I added the following suggestions to the hunt log: A comments / areas hunted section, which detector used section, relics section, relics estimated values section, rings estimated values section, a grand total for coin value/ ring value/ relic values (all 3 combined) section, and a major finds list. Thanks for the feedback.
I will be sending you this updated log.

 

[MJP (IL)]

I keep the Locations in one table with a small keyword. That way I can describe each location and sub-locations within down to as much detail as I want.

I keep each find in another table. I use the location keyword to identify where I found it. Then when I pull reports, I can pull only as much location detail as necessary.

Each find entry contains the date recovered, the type (coin, token, ring, key, etc.), the country of origin, category (Indian cent, Large cent, Barber Dime, Half Dime, etc.), denomination (.01, .02, .03, .05, .10, .25, .50, etc.), item date, mint mark, estimated grade, and a large comments field for freeform notes and comments about the find, such as depth, part of a multiple find, or a further description of a sub-type.

The powerful MS Access query capability allows me to extract data just about any way I want. I can go back over the years and sub-total by location or date or type or category or any of the fields, separate or in combination. Helps me analyze many things about my detecting history.

I recommend a database approach for this reason. MS Access is easy to learn and is a part of the MS Office suite.

Mike

 

[DukeOBass]

My entries just consist of Date Found, Location, Item Found, Face Value and Sold for. I also list everything I purchased for the hobby and then subtract the finds value from it so That I know when I break even.

 

[mj-air23]

nice spreadsheet. many thanks for offering it...