Structural Steel Design in Microsoft Excel using Custom Functions

摘要

Microsoft Excel offers users the ability to create custom functions that can be used in spreadsheets in the same manner as built-in functions. The key to this process is the use of a programming language included in Excel called Visual Basic for Applications (VBA). This paper discusses methods for creating useful custom functions, strategies for getting the most out of the functions, and examples of custom functions for structural steel design.