We initially developed these spreadsheets from a passion for computational problem-solving in engineering. Our primary goal was to create efficient tools that tackle complex tasks far exceeding the capability of manual calculation.
Our spreadsheets use effectived algorithms to tackle challenging engineering problems. They solve non-linear systems (WeldGroup, BoltGroup), perform matrix computations and manage large datasets (GoBeam, SmartComb), and run iterative routines for equation solving and optimization (ShortCol, PSLoss, Travelling Salesman). SectProp uses a recursive function to calculate the shear center of general shape thin-walled section.
Importantly, the spreadsheets are excellent tools for implementing design code requirements (e.g., design for shear and torsion in ShortCol and ShearLRFd). They instantly recalculate numerous formulas as you change input variables, allowing rapidly check and optimize design.
We make these spreadsheets productive for engineers by emphasizing intuitive input and a minimal learning curve. A streamlined output presents results clearly using tables and graphs.
Historically, our spreadsheets are favored by small companies and individual engineers, delivering reliable, professional-grade tools that are accessible and affordable without the high cost of proprietary software.
Basic familiarity with Microsoft Excel is expected. To prevent accidental corruption of the formulas and framework, the worksheets are protected, leaving only the highlighted input cells accessible for modification. Licensed versions include the necessary passwords to unprotect the worksheets if deeper access is desired. Spreadsheets that utilize VBA macros feature either on-screen command buttons or a dedicated toolbar, which can be found in the Excel ribbon under the Add-Ins tab. This interface allows users to change settings and execute analysis routines from any point in the workbook.
We use VBA macros to automate repetitive tasks and manage complex workflows, while worksheet functions handle core calculations. In certain cases, such as with GoBeam, the entire code is written in VBA.
Enabling VBA macros in Microsoft Excel requires you to adjust your security settings in the Trust Center. Here's how to do it:
Open File/Options, go to Trust Center, then open Trust Center Settings. Select Macro Settings and choose your preferred level. The recommended choice is Disable all macros with notification, which blocks macros but lets you enable them when needed.
BoltGroup and WeldGroup spreadsheets use the Microsoft Solver Add-in to locate the Instantaneous Center of Rotation. Solver is a standard component of Excel but must be activated before it can be used. To activate the Solver Add-in:
Open the File tab and choose Options, then select Add-ins. In the Manage dropdown at the bottom, choose Excel Add-ins and click Go. In the dialog that appears, enable Solver Add-in and confirm. After activation, the Solver command appears on the Data tab in the Analyze group.