About Our Spreadsheets

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.

Efficient Problem-Solving

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.

Easy to Use

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.

Reliable and Affordable

Historically, out 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.

Working with Our Spreadsheets

Basic familiarity with Microsoft Excel is expected from the user. To prevent accidental corruption of the underlying formulas and logic, our files are protected. Only designated input cells (which are clearly highlighted) can be modified by the user. 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 easily change settings and execute analysis routines from any point in the workbook.

VBA Macros

Our spreadsheets use VBA macros to automate repetitive tasks and manage complex workflows, while powerful native Excel functions handle core calculations. In certain specialized cases, such as with GoBeam, the entire computational engine is written in VBA for maximum efficiency and control.

Enabling VBA macros in Microsoft Excel requires you to adjust your security settings in the Trust Center. By default, Excel usually disables macros with a notification for security reasons.

Here is the step-by-step process to change the macro security level:

Adjusting Macro Security Settings

1. Open Excel Options: Click the File tab in the ribbon, then click Options at the bottom of the left-hand menu.
2. Go to Trust Center: In the Excel Options dialog box, select Trust Center from the list on the left side.
3. Open Settings: Click the Trust Center Settings... button on the right.
4. Select Macro Settings: In the Trust Center dialog box, click Macro Settings in the left navigation pane.
5. Choose a Security Level: Select the option that best fits your needs. The most common choices are:
   • Disable all macros with notification (Default): This is generally recommended. It blocks macros but gives you the choice to Enable Content on a case-by-case basis when opening a file.
   • Enable all macros (not recommended): This allows all macros to run without any warning, which makes your computer vulnerable to potentially malicious code. Only use this option if you understand the risks and are the sole user of the files.
6. Confirm and Exit: Click OK to close the Trust Center dialog box, then click OK again to close the Excel Options dialog box.

Alternative: Trusted Locations

A safer way to enable macros for files you know you can trust is to save them in a Trusted Location. Excel allows macros to run automatically for any file stored in a folder designated as trusted, bypassing the security warning without lowering the overall security level for all other files.

Utilizing the Solver Add-in

Our BoltGroup and WeldGroup spreadsheets require the use of 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:

1. Go to the File tab, then select Options.
2. In the Excel Options dialog box, click Add-ins.
3. In the Manage box near the bottom of the dialog box, select Excel Add-ins and click Go.
4. In the Add-ins dialog box, check the box next to Solver Add-in and click OK.

Once activated, you should find the Solver button in the Data tab, within the Analyze group.