The download files include full open-source VBA code, and dll files for compiled solvers for much better performance with large models. See https://newtonexcelbach.wordpress.com/2012/11/16/frame4-now-with-added-alglib/ for instructions on installing and linking to the dll files. The VBA code does not require any special installation.
Changes common to both spreadsheets are:
- The check for a reference to the compiled solver dll files previously caused the VBA solver to crash if the dll files were not found. This has now been fixed so that the VBA solver will run if the compiled solver files are not installed.
- A check has been added that the resultant reaction forces are equal to the total resultant applied loads.
In addition the following changes have been made to individual spreadsheets:
- The three solvers available in 3DFrame (compiled Alglib sparse solver, compiled skyline solver, and VBA solver) are now also available in Frame4.
- Calculation of shear deflections is now supported.
- Member end releases are now supported.
- The plot functions have been updated for easier use and better performance
- Specified support displacements may now be input.
- Members may now be specified as truss elements, transferring axial load only.
Note that specified support displacements are modelled by adding a virtual large stiffness in the direction of the displacement, and this solution method is not compatible with the iterative solution method used in the Alglib sparse solver. For this reason models with specified support displacements should be solved with the compiled solver or the VBA solver.
Examples of input and output using the new features in 3DFrame are shown in the screenshots below:
Support reactions without specified deflections or truss members:
Change Property Number 3 to truss element (set I1, I2 and J to zero).
Add support displacements
Equilibrium check for Alglib sparse solver used with specified support displacements:
Correct results with compiled solver option: