AN Bolt Length And Grip SpreadSheets new

[mike mcs repair]

Hi

If anyone needs I made Spreedsheets (not just charts) of AN bolts up to 4 inch as i was doing another app.... would be nice to include in the wiki, but i did not see where to add these...

one spreadsheet has the normal grip and length from under head in fractional(this is what I found online and converted numbers to a spread sheet)
https://spreadsheets.google.com/ccc?key=0ArKTbkPTTq9TdFEwdkZSY2kxNzM0UzZ4SXI5MGxJbGc&hl=en

one has just grip in fractional
https://spreadsheets.google.com/ccc?key=0ArKTbkPTTq9TdFN2bzVQSG03cjFtemhWaG5MdGNNSGc&hl=en

one has just grip in decimals
https://spreadsheets.google.com/ccc?key=0ArKTbkPTTq9TdGNRT25lbUMwT3NJVU9Xak8ySFg3aHc&hl=en

you should be able to save a copy if you want to be able to edit them, add formulas ect.

 

[Bushwhacker Air]

Nice job, Mike. A real time saver.

Thanks!

 

[wirsig]

Thanks Mike!

 

[Roger Peterson]

Thanks, Printed out a couple, now have to laminate them.

 

[mike mcs repair]

I should probably mention that after testing these with real bolts from my bin adjustable parallels and a micrometer, they all seem to give you a hair long of a bolt, so I fudge each one by subtracting almost a thin washer thickness from grip shown in spreadsheet in my app...

so you might want to consider that when using these spreadsheets,

but they are the same as spruce and many sources I could compare to on the web...

also updated some of them to go to 6" length I think(weeks ago)....