TNT_Tear-Out

Update: I just have noticed the "Results" sheet was PW protected (some 4 years later!). The sheet is now unprotected. Enjoy!
Optimize bolt tapping depth, tension and tear out strength.
1.Fill in correct values in the yellow input boxes of the Input Sheet
2.Fill in and drag associated engagement lengths in yellow column of the DATA Sheet
3.Review results on the Results Report Sheet. Pay Attention to the Solution Cell and Recommendations Cell
4.If solution is found, Print Applicable Results. If no solution, refer to Failure Report Sheet and take appropriate action 5."SAVE AS" project title so original program is not overwritten.

Calculation Reference
Machinerys Handbook