Please reply to this topic to comment on or discuss Repository item:
PRYING9.xls

This morning while using the "Prying Action" worksheet of the "PRYING9.xls" workbook, a problem was discovered. For situations where fatigue needs to be considered ( > 20,000 cycles), the allowable bolt tension stress is be reduced. The program did in fact do that for "N" and "X" type bearing bolts. However, it was not reducing the allowable bolt tension stress for fatigue when using slip critical (SC) bolts.

This has been corrected and the workbook is now version 2.0. I will continue to provide updates for any of the AISC 9th Edition spreadsheet workbooks as long as people appear to still be using them.

Tried to use the spreadsheet with 1/2" bolts and got a lot of #NUM errors.

In the stored example that I have, maybe you first tried changing the bolt size to 1/2" without paying any attention to the loads?

For bolts, you will get #NUM errors first originating in the calculation of the allowable bolt tension stress, Ft, for interaction with shear. Since you are taking the square root of a quantity, if that quantity becomes less than 1, then you are trying to take the square root of a negative number....and you know what happens from there, and so on. If your shear load is too great, then there will be no calculated capacity for tension.

Alex