SPREADSHEET SOLUTIONS FOR STRUCTURAL ENGINEERING

WeldGroup - eccentrically loaded weld group shear capacity

WeldGroup computes available strength of eccentrically loaded weld group under combined action of in faying plane forces and forces normal to the weld group. The forces in the weld elements are calculated using Instantaneous Center of Rotation Method per AISC Steel Design Manual, 13th Edition. Spreadsheet provides design summary, detailed results, and fundamental theory and formulas.

• irregular weld patterns
• LRFD and elastic methods by AISC Manual 13th Edition
• allows multiple in-plane and normal to faying plane forces
• SI and US units

Design worksheet

Theory worksheet

Troubleshooting

1. Make sure the macro security level of Excel is medium. From main Excel menu choose Tools--Macro--Security, select Medium security level option and click Ok button.
2. Make sure Solver Add-in is installed. From main menu choose Tools--Add-Ins, select check box next to Solver Add-In and click Ok button. Excel will install Solver.
3. The Solver VBA automation library is not referenced properly if you receive Excel warning message after executing Calculate button from Weldgroup menu. Solution:
   Open VBA editor by simultaneously pressing ALT-F11 keys. In the project window (left upper corner) you will see a list of open excel workbooks and add-ins. If SOLVER.XLA is listed then the problem lies somewhere else. If not, then Solver automation library reference is invalid (thank Microsoft for changing library names).
   In the project window click on Weldgroup071.xls and type VBA password (provided with your licensed copy of Weldgroup) and click Ok. From the main VBA menu choose Tools--References. Within available references find SOLVER and select check box next to it. If SOLVER is marked as MISSING, unselect check box, scroll down the list of references and select one containing word Solver (It may say Microsoft Solver). Click Ok and SAVE FILE.
4. Contact us if you still having trouble.