Metric excel grid file for logging finds - free resource

Please only post topics here related to metal detecting tips and tricks & D.I.Y
User avatar
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Metric excel grid file for logging finds - free resource

Post by 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

grid.gif
grida.gif

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
You do not have the required permissions to view the files attached to this post.


Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

HalfPint
Posts: 83
Joined: Tue Jun 07, 2011 3:56 pm
Location: Lancashire

Re: Metric Excel Grid File - Logging Finds

Post by 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.

Broadsword
Posts: 735
Joined: Thu Dec 09, 2010 3:59 pm
Location: Surrey UK
Contact:

Re: Metric Excel Grid File - Logging Finds

Post by Broadsword » Fri Jul 08, 2011 4:14 pm

Great - really good, downloaded, thanks. :)
http://www.lostrings.co.uk
"Only once a find is recorded is it truly discovered, and through recording finds with the PAS metal-detecting can make a truly positive contribution to archaeology" British Museum.
RINGS returned 2014=19 Not found = 8

User avatar
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Re: Metric Excel Grid File - Logging Finds

Post by 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

test.jpg
Dave
You do not have the required permissions to view the files attached to this post.
Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

User avatar
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Dave8472 » Fri Dec 16, 2011 3:42 pm

Updated, now with this grid :)


Metric Grid Download

gridb.gif
You do not have the required permissions to view the files attached to this post.
Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

Grifftron
Posts: 742
Joined: Tue May 10, 2011 5:11 pm
Location: Bristol
Contact:

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Grifftron » Fri Dec 16, 2011 5:51 pm

dam it !! i paid a tenner for a metal one last month !
ETRAC
Garrett Ace 250
Pro Pointer
Cider
http://griffsmetaldetecting.weebly.com/index.html" onclick="window.open(this.href);return false;
http://www.somersetmetaldetecting.co.uk" onclick="window.open(this.href);return false;

User avatar
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Dave8472 » Fri Dec 16, 2011 6: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
Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

fishy
Posts: 1959
Joined: Tue Oct 18, 2011 7:34 pm
Been thanked: 1 time

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by fishy » Fri Jan 27, 2012 6:17 pm

Just been searching for this and found it :D

Bump
CTX3030

Beany_bot
Posts: 1773
Joined: Mon Nov 22, 2010 4:20 pm
Location: Scotchland
Been thanked: 2 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Beany_bot » Fri Jan 27, 2012 6: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

fishy
Posts: 1959
Joined: Tue Oct 18, 2011 7:34 pm
Been thanked: 1 time

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by fishy » Fri Jan 27, 2012 6: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 :)
CTX3030

Beany_bot
Posts: 1773
Joined: Mon Nov 22, 2010 4:20 pm
Location: Scotchland
Been thanked: 2 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Beany_bot » Mon Feb 06, 2012 10: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

User avatar
Danzigman
Posts: 12452
Joined: Sun Aug 07, 2011 8:31 am
Location: Denmark - island of Fyn (Funen)
Has thanked: 248 times
Been thanked: 298 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Danzigman » Mon Feb 06, 2012 12:26 pm

And the fast fix it this - http://www.jasonquinlan.com/wp/wp-conte ... scales.pdf" onclick="window.open(this.href);return false;
XP DEUS. GPP VII. GARMIN etrex 20.
http://s1222.photobucket.com/user/Danzigman/library/

User avatar
Danzigman
Posts: 12452
Joined: Sun Aug 07, 2011 8:31 am
Location: Denmark - island of Fyn (Funen)
Has thanked: 248 times
Been thanked: 298 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Danzigman » Mon Feb 06, 2012 12:28 pm

Hi Beany like the lamination, but dont it gives a lot of reflex to photo. ??
XP DEUS. GPP VII. GARMIN etrex 20.
http://s1222.photobucket.com/user/Danzigman/library/

Beany_bot
Posts: 1773
Joined: Mon Nov 22, 2010 4:20 pm
Location: Scotchland
Been thanked: 2 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Beany_bot » Mon Feb 06, 2012 1: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
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by Dave8472 » Mon Feb 06, 2012 6:52 pm

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

Dave
Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

biro
Posts: 853
Joined: Mon Feb 13, 2012 8:14 pm
Location: leigh-on-sea, essex

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by 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
Danzigman
Posts: 12452
Joined: Sun Aug 07, 2011 8:31 am
Location: Denmark - island of Fyn (Funen)
Has thanked: 248 times
Been thanked: 298 times

Re: Metric Excel Grid File - Logging Finds - UPDATED

Post by 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.
XP DEUS. GPP VII. GARMIN etrex 20.
http://s1222.photobucket.com/user/Danzigman/library/

User avatar
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Re: Metric Excel Grid File - Logging Finds

Post by Dave8472 » Sun Jul 07, 2013 10:00 pm

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

Dave &*(
Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

ed5727
Posts: 4
Joined: Thu Jul 18, 2013 9:13 pm

Re: Metric Excel Grid File - Logging Finds

Post by ed5727 » Thu Aug 22, 2013 10:15 am

Great stuff this Dave, very informative, thanks mate!

Emrys
Posts: 506
Joined: Fri Aug 31, 2012 9:48 pm

Re: Metric Excel Grid File - Logging Finds

Post by Emrys » Mon Apr 20, 2015 10:30 pm

just found this
thanks will come in useful
Xp Deus 11"coil /AT pro /pro pointer and a lot of enthusiasm
first roman bronze 25/8/1, first hammy 27/4/15 Henry 3rd penny 1216-1272

User avatar
vladorado
Posts: 128
Joined: Tue May 16, 2017 10:40 pm
Location: KIDDERMINSTER
Has thanked: 47 times
Been thanked: 60 times

Re: Metric Excel Grid File - Logging Finds

Post by vladorado » Sat Jul 01, 2017 3:03 pm

This is still very useful for the newbies like me.
Thanks Oxgirl36 for showing me this thred!
Minelab CTX 3030 with 6", 11" and 17" coils.
Minelab Equinox 800 with 6", 11" coils.
Minelab Pro-find 35, Garrett Pro Pointer AT, Nokta Waterproof Pointer.
ALL THE GEAR, NO IDEA!

User avatar
f8met
Posts: 2563
Joined: Wed May 08, 2013 12:14 am
Location: Cambs and Suffolk
Has thanked: 149 times
Been thanked: 704 times

Re: Metric Excel Grid File - Logging Finds

Post by f8met » Wed Feb 28, 2018 9:20 am

Here is another one. I print it out, paste onto cardboard and use as my scale.

https://destinysagent.wordpress.com/200 ... ic-rulers/

Just click on the picture for the pdf.
Dave
Deus, 9" and 11" black coil
2019 16 Hammered

Wormdigger
Posts: 89
Joined: Sat Apr 15, 2017 8:31 pm
Location: Isle of Axholme
Has thanked: 24 times
Been thanked: 30 times

Re: Metric Excel Grid File - Logging Finds - a free resource

Post by Wormdigger » Wed Feb 28, 2018 9:53 am

As promised, here is scale from the PAS website Linky and also a good general guide on taking photographs. Another linky
Nokta Impact, Deteknix wireless headphones, Nokta Pointer and worm digging equiment. Ibanez RG 1570Z when it is raining.

User avatar
bazzerhut
Posts: 392
Joined: Mon Apr 25, 2016 1:17 am
Location: Norfolk
Has thanked: 140 times
Been thanked: 223 times

Re: Metric excel grid file for logging finds - free resource

Post by bazzerhut » Fri Apr 27, 2018 11:44 pm

Can anyone help me with tweaking the column and row dimensions in this Excel file?

I've been using this scale for a while now, and have only belatedly realised (having been stupid enough not to check when I first printed it) that it's a bit out of whack on my printer. The rows are a tad too high, and the columns a tad too wide.

The available height and width adjustments in the menu options don't seem to offer sufficient granularity to put things perfectly right, but then I'm not especially adept with Excel.

Any experts here?

Barry
Equinox 800 / XP Deus

"We have left undug those things which we ought to have dug; And we have dug those things which we ought not to have dug; And there is no wealth in us."

jph
Posts: 63
Joined: Fri Feb 05, 2016 3:51 pm
Location: Cheshire
Has thanked: 75 times
Been thanked: 22 times

Re: Metric excel grid file for logging finds - free resource

Post by jph » Sat Apr 28, 2018 2:14 am

Hi Dave,

Thanks for the link. I've been looking for one of these for a while. Luckily I managed to get a laminator last year, which should keep the grid clean.
Now all I've got to do is find something worthy of photographing.

John
Minelab Equinox 800
Deteknix Xpointer
Garrett Pro-Pointer

Onwards and Downwards

User avatar
bazzerhut
Posts: 392
Joined: Mon Apr 25, 2016 1:17 am
Location: Norfolk
Has thanked: 140 times
Been thanked: 223 times

Re: Metric excel grid file for logging finds - free resource

Post by bazzerhut » Sat Apr 28, 2018 4:00 am

bazzerhut wrote:
Fri Apr 27, 2018 11:44 pm
Can anyone help me with tweaking the column and row dimensions in this Excel file?

Never mind, I found another solution.

Barry
Equinox 800 / XP Deus

"We have left undug those things which we ought to have dug; And we have dug those things which we ought not to have dug; And there is no wealth in us."

User avatar
Easylife
Posts: 4519
Joined: Mon Apr 24, 2017 9:23 pm
Has thanked: 1090 times
Been thanked: 2359 times

Re: Metric excel grid file for logging finds - free resource

Post by Easylife » Sat Apr 28, 2018 7:24 am

I originally also had this problem but just resized image by percentage in MS Paint to correct it. Don't forget to save to file for future reprints. :)
Nox 800, 15" coil & Garrett carrot.
White's TDI SL

User avatar
Dave8472
Moderator
Posts: 11094
Joined: Sun Jun 13, 2010 8:52 pm
Location: Kent
Has thanked: 283 times
Been thanked: 222 times

Re: Metric excel grid file for logging finds - free resource

Post by Dave8472 » Sat Apr 28, 2018 8:45 am

bazzerhut wrote:
Fri Apr 27, 2018 11:44 pm
Can anyone help me with tweaking the column and row dimensions in this Excel file?
Hi, another solution is to scale the printer output, different again for every printer, but my driver allows a print output of say 99% or 101% etc. But as said on other posts, it isn’t possible to resize cells in excel to an exact size, there are tiny gaps in the numbers allowed.

Dave ):=
Minelab CTX3030 : 17", 11", 6" Coils
Minelab Equinox 800 : 15", 11" Coils
XP Deus V3.2 - WS5 : 9" Coil
Garrett Pro Pointer AT
Garmin eTrex 20 GPS

User avatar
bazzerhut
Posts: 392
Joined: Mon Apr 25, 2016 1:17 am
Location: Norfolk
Has thanked: 140 times
Been thanked: 223 times

Re: Metric excel grid file for logging finds - free resource

Post by bazzerhut » Sat Apr 28, 2018 12:24 pm

Easylife wrote:
Sat Apr 28, 2018 7:24 am
I originally also had this problem but just resized image by percentage in MS Paint to correct it.
Thanks for that. In the end, I did a similar thing with an equivalent scale downloaded in PDF format, enlarging/reducing the image elements within Acrobat until they printed just right.

Barry
Equinox 800 / XP Deus

"We have left undug those things which we ought to have dug; And we have dug those things which we ought not to have dug; And there is no wealth in us."

User avatar
bazzerhut
Posts: 392
Joined: Mon Apr 25, 2016 1:17 am
Location: Norfolk
Has thanked: 140 times
Been thanked: 223 times

Re: Metric excel grid file for logging finds - free resource

Post by bazzerhut » Sat Apr 28, 2018 12:26 pm

Dave8472 wrote:
Sat Apr 28, 2018 8:45 am
Hi, another solution is to scale the printer output, different again for every printer
Many thanks, Dave - good thinking.

Barry
Equinox 800 / XP Deus

"We have left undug those things which we ought to have dug; And we have dug those things which we ought not to have dug; And there is no wealth in us."

Post Reply

Return to “Tips & DIY Forum”