Using Frame4Buckle with the Alglib solver

The Frame4Buckle spreadsheet carries out a buckling analysis of a column or strut, which may be divided into any number of segments with varying cross section details, allowing the analysis of stepped or tapered members.  The spreadsheet includes a VBA solver which works well for up to about 20 segments, but becomes very slow for 50 or more segments.  Also included is the option to call a much faster external compiled solver, using the ALGLIB library, but this requires the installation of two additional interface files (ALMatrixLib.tlb and ALMatrixLib.dll), and the AlgLib dll file (Alglibnet2.dll).  These files are now included in the download zip file:, and detailed step by step installation instructions are given at: Frame4; now with added Alglib.  The Alglib solver has been tested on systems with 32 bit and 64 bit windows, but not with 64 bit Excel.

Note that if you have already installed the Alglib files to run the Frame4 spreadsheet it is not necessary to change anything.  Also if the Alglib files are not installed, or are not working, the spreadsheet should automatically switch to the VBA solver.

Finally, for those with Python and Pyxll installed, I will soon be posting versions of the Frame4 and Frame4Buckle spreadsheets using Python solvers.

In case of any problems with installing the files or running the spreadsheet, please leave a comment here.

This entry was posted in AlgLib, Computing - general, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA and tagged , , , , , . Bookmark the permalink.

5 Responses to Using Frame4Buckle with the Alglib solver

  1. Dave says:

    I’m trying to run the Frame4Buckle without Alglib, but am getting errors. It usually shows the VBA debugging and the error: “Compile error: Can’t find project or library”. LCase was highlighted one time, UCase another time…
    Any ideas? I’m running Windows 7 64-bit with Excel 2013


  2. Dave says:

    Doug, I downloaded the updated file and it seems to be working now! I’m going to work with it now so I apply it correctly to my situation. Thanks!


  3. Pingback: Column buckling under multiple loads | Newton Excel Bach, not (just) an Excel Blog

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.