Welcome to the ultimate resource for structural engineers and design professionals seeking to enhance their steel structure design capabilities. The AISC plugin for Excel, created by SkyCiv, revolutionizes the way we approach design by seamlessly integrating advanced modeling, analysis, design, and rendering capabilities within the familiar environment of Excel. This powerful tool not only simplifies the design process with detailed calculation reporting and support for multiple connection types, but it also facilitates faster modeling, easy collaboration, and is fully integrated with SkyCiv software. Navigate through our page to discover what AISC is, explore the synergy between AISC standards and Excel plugins, delve into common use cases, and find answers to frequently asked questions, unlocking the full potential of your projects.
AISC stands for the American Institute of Steel Construction, an organization that provides company-level certification for structural steel fabrication and erection. This certification is tailored for firms involved in the creation or erection of steel structures, including buildings, bridges, and bridge and highway components. AISC's certification process is not merely an award; it is a rigorous evaluation that includes the review of quality manuals, procedure documentation, and an on-site audit of the firm's quality management system. It ensures that the quality system adheres to standards covering management responsibility and inspection procedures.
Additionally, AISC is also referenced in the context of design and analysis software, specifically AISC 360 software, which is a tool for steel design and analysis. This software aligns with AISC's design specifications, such as AISC 360-10 and AISC 360-16, and provides engineers with the necessary tools for designing steel members and connections, along with a library of steel sections and load combinations. It is part of the SkyCiv Structural Design and Analysis Software suite, which is cloud-based and supports real-time collaboration. The software facilitates the optimization of steel sections, ensuring they meet AISC design requirements, and assists in detailed design calculation reporting.
The AISC Excel plugin includes a Shapes Database, consistent with the AISC Steel Construction Manual, 16th Edition. The database contains v16.0, which offers dimensions and properties for new shapes added to the Manual. Users can access both U.S. customary and metric units, ensuring versatility for different project needs. Along with a comprehensive glossary and a list of new shapes, the plugin follows the EDI Naming Convention, facilitating standardized electronic interchange in the steel industry.
The Historic Shapes Database v16.0H is a valuable resource within the AISC Excel plugin that provides historical data dating back to 1873. It includes information on shapes published in the AISC Manual since the 5th Edition and earlier, allowing users to reference and analyze historical steel shapes.
With the inclusion of a \"Readme\" file, users can easily understand how to navigate and utilize the Shapes Database effectively. The AISC Excel plugin is designed to operate swiftly, with updates available through the extension manager to address any issues and enhance functionality.
AISC Excel plugins offer comprehensive steel design and analysis capabilities in accordance with AISC 360-10 and AISC 360-16 specifications. These plugins are integrated with SkyCiv Structural Design and Analysis Software, allowing for direct loading of design codes within the program and the ability to handle both library and custom-built steel sections.
Users can benefit from features like the optimizer, which filters sections based on specific criteria, and the capacity to calculate the lightest section that meets AISC design requirements. The plugins support designing with various shapes, perform checks for bending, shear, and axial loads, and provide full calculation reports for design transparency.
The AISC Excel plugins enhance modeling workflows, provide easy collaboration and file sharing for teams, and all SkyCiv software is accessible with one account. A 14-day free trial is available for users to experience the plugins' capabilities firsthand.
While AISC plugins can be directly used in Excel, users have developed workarounds for efficiency, such as utilizing entire rows from the shapes database spreadsheet. Writing a wrapper as a user-defined function using excel_IO is one method to streamline the process. Additionally, creating a simple Index(Array, Match(), Match()) lookup in Excel can be employed to work with excel_IO effectively.
Proper implementation of SMath units is necessary when interacting with excel_IO. Users should be aware of potential data sharing issues due to user settings and are advised to define the absolute path to address working directory identification problems. It is also recommended to test for bugs and use the AISC plugin at their own risk.
Updates to enhance the plugin's performance and compatibility may be necessary, with users encouraged to redownload it if issues arise. Furthermore, there is interest in functionalities such as a drop-down selection in SMath for instant access to section properties, and a function to automatically retrieve properties by inputting a shape's name, both bypassing the need for direct interaction with the Excel sheet.
The AISC plugin for Excel is a VBA library used for creating steel shape objects within Microsoft Excel, based on the AISC Steel Manual. It allows for the calculation of section properties for built-up cross-sections and the creation of material objects to add to the steel cross-sections.
The VBA editor add-in Rubberduck is recommended for use with the AISC plugin as it helps in module organization and is necessary for running unit tests.
Yes, updates to the AISC shapes database are regularly published to reflect changes in shape properties, and the plugin is designed to use these updates for accuracy and repeatability.
Yes, the plugin closes Excel files automatically after processing, which is a feature appreciated by some users.
The latest version of the AISC Shapes Database included in the plugin is version 16.0, which is compatible with Microsoft Excel and includes dimensions and properties consistent with the 16th Edition AISC Steel Construction Manual.