Could anyone recommend a reliable resource/text book/software package that would allow me to analyze a bolted joint to determine the amount of pretension required to prevent separation for a given load?
VDI 2230 Systematic Calculation of Bolted Joints is the most comprehensive source for this type of information. Software such as SR1 from Hexagon has been created based on VDI 2230. Perform a keyword search of Eng-Tips for a sampling of problems that have been previously discussed on this subject. The following are links to the Beuth and Hexagon websites from which you can obtain VDI 2230 and SR1, respectively.
I use most of the times:FED-STD-H28/2B (1994)
"Federal Standard
Screw-thread standards for Federal Services
Section 2"
Appendix B is a Design method of Unified Screw Threads.
This public document can be dowloaded from: