It can be used for any structural model created by SAP2000. We have already created the spreadsheet for you. xlOptimizer will pick the optimum section for each one of these groups.
Also, the frame members are grouped into meaningful Groups e.g., corner columns, exterior columns, interior columns, beams, x-braces, etc.
It is assumed that the structural model is complete and checked for errors (nodes, members, connectivity, supports, loads, design options, etc). Optimization with xlOptimizer allows for the selection of the optimum frame sections for each member group in the model. This process is possible since SAP2000 exposes a full API (Application Programming Interface) which can be used by VBA. The purpose of this example is to demonstrate the use of the well-known CSi SAP2000 structural analysis program within Microsoft Excel and the optimization of a structure using xlOptimizer.
