Verify the Table 7 value (LRPF page [7-63]) for a bolted connection consisting of 3 bolts horizontal, and 2 bolts deep. The bolts are spaced 6″ horizontally, and 3″ vertically. The load is directed downwards at an angle of 30 degrees clockwise from vertical, as shown on all Table 7 figures, and is 9 inches to the right, and level with the elastic centroid of the bolts. Use 1″ diameter A325 bolts with the threads in the shear plane, with slip permitted (LRFD page [7-22]).
Use the Excel spreadsheet Design Aids to solve this problem. Look for the tab labeled Plastic Bolts X&Y Loads.
Note that you may have to load Excel’s Solver, if it is not already installed on your computer. Click on Excel’s Help and search for Solver installation.