Bolt Stress MIL-HDBK-5

Calculates the allowable pre-load after a user input shear load or the allowable shear load after a user input pre-load for coarse and fine thread bolts from 1/4" diameter to 1" diameter. Allowable loads are plotted by diameter and thread count. This spreadsheet uses an interaction equation from MIL-HDBK-5. All equations are worked by hand and documented. I use this every day for quickly sizing bolts because of how easy it is to use and understand.  

Calculation Reference
Bolted Joint
Bolt Strength
MIL-HDBK-5