Bolt formula

anyone aware of a download spread sheet for calculating bolt/nut tensile and shear loads.
Googling brings up web based calculators but it would be nice to have an
excel spread.
thanks
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Google "bolt strength", there are several good references out there.
http://euler9.tripod.com/bolt-database / http://www.boltdepot.com/fastener-information/Materials-and-Grades/Bolt-Grade-Chart.aspx http://www.mechanicsupport.com/articleBoltTensileStrength.html http://www.derose.net/steve/resources/engtables/bolts.html
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

http://www.boltdepot.com/fastener-information/Materials-and-Grades/Bolt-Grade-Chart.aspx
done that, I want a spread sheet.
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

MITCalc
http://www.mitcalc.com/en/download.htm
Add pictures here
<% if( /^image/.test(type) ){ %>
<% } %>
<%-name%>
Add image file
Upload

Polytechforum.com is a website by engineers for engineers. It is not affiliated with any of manufacturers or vendors discussed here. All logos and trade names are the property of their respective owners.