Lost Items - National Search Service


MDF Youtube MDF Facebook Metal Detecting Top Sites

Metric Excel Grid File - Logging Finds

Please only post topics here related to metal detecting tips and tricks & D.I.Y

Moderator: Forum Staff

Metric Excel Grid File - Logging Finds

Postby Dave8472 » Fri Jul 08, 2011 2:59 pm

Hi all, after reading Augusts’ “The Searcher” magazine there is a great article about recording your finds, one section shows details of taking pictures with reference to scale, I liked the idea of a metric printable scale, so whipped one up on the computer, you can download it here if you have Microsoft Excel

Metric Grid Download

Image Image


There are two spread sheets, one that does “mm” and one for “cm”. Only problem is printing scale is a bit tricky, there is a small error on the scale, more noticeable on the “mm” width page. Depending on your PC etc, you may need to alter the column width as apparently this is font linked ! Height should not be an issue. My Excel is set not to print grid lines, if yours is you might want to alter the file or your settings.

Anyway hope it is of some use to you, if not it’s free and nothing lost :)

Dave
Image
User avatar
Dave8472
Moderator
 
Posts: 10910
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 124 times
Been thanked: 160 times

Re: Metric Excel Grid File - Logging Finds

Postby HalfPint » Fri Jul 08, 2011 4:02 pm

Thanks Dave funny enough I was looking at ways of achieving this morning
Don't judge life on the breaths you take, but on the moments that take your breath away.
User avatar
HalfPint
 
Posts: 83
Joined: Tue Jun 07, 2011 3:56 pm
Location: Lancashire
Has thanked: 0 time
Been thanked: 0 time

Re: Metric Excel Grid File - Logging Finds

Postby Broadsword » Fri Jul 08, 2011 4:14 pm

Great - really good, downloaded, thanks. :)
Detectors:CTX3030
http://www.lostrings.co.uk
ProPointer x2
2012 Finds: 12 Roman, other coins 74
RINGS returned=412 happy people
Minelab Treasure Tracking OUT NOW
S-D-G SOUTHERN DETECTORIST GROUP
http://detectorists.info/
User avatar
Broadsword
 
Posts: 797
Joined: Thu Dec 09, 2010 4:59 pm
Location: Surrey UK
Has thanked: 61 times
Been thanked: 23 times

Re: Metric Excel Grid File - Logging Finds

Postby Dave8472 » Fri Jul 08, 2011 5:59 pm

Glad it is of some use ;) , just been doing some tests with copying as a picture around a find

Image

Dave
Image
User avatar
Dave8472
Moderator
 
Posts: 10910
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 124 times
Been thanked: 160 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Dave8472 » Fri Dec 16, 2011 4:42 pm

Updated, now with this grid :)


Metric Grid Download

Image
Image
User avatar
Dave8472
Moderator
 
Posts: 10910
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 124 times
Been thanked: 160 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Grifftron » Fri Dec 16, 2011 6:51 pm

dam it !! i paid a tenner for a metal one last month !
User avatar
Grifftron
 
Posts: 856
Joined: Tue May 10, 2011 5:11 pm
Location: Bristol
Has thanked: 10 times
Been thanked: 4 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Dave8472 » Fri Dec 16, 2011 7:00 pm

Grifftron wrote:dam it !! i paid a tenner for a metal one last month !


I have seen those, very nice, but couldn't justify that amount of money on one lol

Dave
Image
User avatar
Dave8472
Moderator
 
Posts: 10910
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 124 times
Been thanked: 160 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby fishy » Fri Jan 27, 2012 7:17 pm

Just been searching for this and found it :D

Bump
User avatar
fishy
 
Posts: 1764
Joined: Tue Oct 18, 2011 7:34 pm
Location: NORFOLK
Has thanked: 28 times
Been thanked: 43 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Beany_bot » Fri Jan 27, 2012 7:43 pm

As good and professional as this is, I still find myself scratching my head when someone uses one to show a find. I personally find it much easier gauging the size when its sitting next to a 20p or similar.

Nice though, if its the preferred method I will do it with my finds. :)
Image
User avatar
Beany_bot
 
Posts: 1512
Joined: Mon Nov 22, 2010 5:20 pm
Location: Scotchland
Has thanked: 0 time
Been thanked: 0 time

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby fishy » Fri Jan 27, 2012 7:45 pm

Just took some picture of some mystery objects and thought I would try it out.

Let us know what you think when I put up my next thread :)
User avatar
fishy
 
Posts: 1764
Joined: Tue Oct 18, 2011 7:34 pm
Location: NORFOLK
Has thanked: 28 times
Been thanked: 43 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Beany_bot » Mon Feb 06, 2012 11:41 am

Quick update:

I found my paper printout of the grid kept getting wet and or dirty, so if you have the facilities i suggest laminating it.

should last for ever now and is wipe clean.

Image
Image
User avatar
Beany_bot
 
Posts: 1512
Joined: Mon Nov 22, 2010 5:20 pm
Location: Scotchland
Has thanked: 0 time
Been thanked: 0 time

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Danzigman » Mon Feb 06, 2012 1:26 pm

User avatar
Danzigman
 
Posts: 5150
Joined: Sun Aug 07, 2011 8:31 am
Location: Denmark - Laesoe
Has thanked: 176 times
Been thanked: 304 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Danzigman » Mon Feb 06, 2012 1:28 pm

Hi Beany like the lamination, but dont it gives a lot of reflex to photo. ??
User avatar
Danzigman
 
Posts: 5150
Joined: Sun Aug 07, 2011 8:31 am
Location: Denmark - Laesoe
Has thanked: 176 times
Been thanked: 304 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Beany_bot » Mon Feb 06, 2012 2:13 pm

Danzigman wrote:Hi Beany like the lamination, but dont it gives a lot of reflex to photo. ??


I think it will be OK because I use ambient light and no flash. We shall see. :)
Image
User avatar
Beany_bot
 
Posts: 1512
Joined: Mon Nov 22, 2010 5:20 pm
Location: Scotchland
Has thanked: 0 time
Been thanked: 0 time

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Dave8472 » Mon Feb 06, 2012 7:52 pm

Looks good Beany, my only problem was I couldn't get the grid lines any finer

Dave
Image
User avatar
Dave8472
Moderator
 
Posts: 10910
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 124 times
Been thanked: 160 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby biro » Fri Jul 20, 2012 4:43 pm

These metric grids are great, but the problem I keep seeing, when people use them, is they do not line up the object along side the start of the grid. When people do this you have to work out how big it is by counting along the line as the may lay the object inbetween the centimetre. So you have to start at say 7 mill and then jump to every 7 mill to get a measure. If the members use these grids please start at the corner tight against, both up and the side measure scale.
Regards Biro.
User avatar
biro
 
Posts: 843
Joined: Mon Feb 13, 2012 9:14 pm
Location: leigh-on-sea, essex
Has thanked: 1 time
Been thanked: 21 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Danzigman » Fri Jul 20, 2012 4:51 pm

biro wrote:These metric grids are great, but the problem I keep seeing, when people use them, is they do not line up the object along side the start of the grid. When people do this you have to work out how big it is by counting along the line as the may lay the object inbetween the centimetre. So you have to start at say 7 mill and then jump to every 7 mill to get a measure. If the members use these grids please start at the corner tight against, both up and the side measure scale.
Regards Biro.

Ohh I see what you mean... I never start with 0.0 I try to start so you can crop out the grid for the closeups.. Sometimes I do several shots so some is the Grid shots, and some are the Show shots.. I also have the grids in 5 colours.. White, Yellow, Light Blue, Light green, and Black..
If start at 2.0 X 2.0 ( 20 mm marks on both axes) you can still crop out the grid.
User avatar
Danzigman
 
Posts: 5150
Joined: Sun Aug 07, 2011 8:31 am
Location: Denmark - Laesoe
Has thanked: 176 times
Been thanked: 304 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Postby Dave8472 » Mon Feb 04, 2013 11:34 pm

Just a bump in case anyone needs a grid for you finds ::g

Dave ';
Image
User avatar
Dave8472
Moderator
 
Posts: 10910
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 124 times
Been thanked: 160 times


Return to Metal Detecting Tips & DIY

Who is online

Users browsing this forum: No registered users and 6 guests