1 Introduction
This excel add-in addressed the issue by streamlining the daily design process with calculation using user’s excel spreadsheets. It offers tools to expedite data processing, transitioning seamlessly from structural analysis results to the preparation of design reports. This enhanced process is divided into three main functions:-
- Importing structural analysis result data from structural analysis software (SAP2000 and GSA);
- Extracting relevant design data from the imported information based on user specifications;
- Performing bulk design calculations using your own spreadsheets and exporting the results in PDF format.
2 Feature
-
Versatile Tool for Diverse Applications. This add-in is designed to automate repetitive calculations and support the design of a broad spectrum of structural elements across various structural analysis software platforms.
-
Comprehensive Force Extraction Methods. Users can extract forces using multiple methods tailored to the specific requirements of different projects and structural elements.
-
Simple Automation Setup. Easily configure the automation process with your own design spreadsheets and summary tables in just a few minutes.
-
User-Friendly Interface. All macros are triggered by buttons on the ribbon and Userform is provided to meet your needs without requiring any coding expertise.
-
High performance. Capable of completing up to 50 calculations per second, ensuring rapid results.
-
Open sourced. The add-in’s code is open for review, allowing anyone to examine the macro’s underlying logic.
3 Application Areas
- Steel member and connection design
- Extract useful loading from models
- RC design
- Whenever repetitive calculation is required.
4 Advantages of Using the Add-in
- Time Saving in Design. Allowing for quick and comprehensive design process.
- Streamlined team workflow. Enable the entire team to adopt the same tool for a wide range of design tasks, reducing the time required for training and familiarization of new tools.
- Spreadsheet Reusability. Utilize template spreadsheets within the workbook to simplify updates and maintenance.