Tag Archives: Excel. VBA

3D Frame with zero stiffness hinges

The previous version of 3DFrame allowed for spring releases at beam ends, but if the release stiffness was entered as zero it was treated as a rigid connection for that freedom.  Effectively zero stiffness releases could be modelled by entering … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton | Tagged , , , , , | 3 Comments

3DFrame with spring releases

Following the previous post I have added similar functionality to the 3DFrame spreadsheet.  The new file can be downloaded from: 3DFrame.zip As before, see Installing C# dll files, reminder for details of installing the supplied dll files, which provide much better … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA | Tagged , , , , | 8 Comments

Frame analysis with spring releases; 2D

I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release.  The new file can be downloaded from: Frame4.zip See Installing C# dll files, reminder for details of installing the … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA | Tagged , , , , | 1 Comment

xlSciPy 1.01

The xlSciPy spreadsheet, introduced here, has been updated with many new functions.  The new version, including full open source code (VBA and Python) can be downloaded from: xlSciPy.zip The spreadsheet requires Python to be installed, including NumPy and SciPy.  It … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA | Tagged , , , , , , | Leave a comment

Using the AlgLib ODE (Runge-Kutta) Solver with Excel

Or to be more correct, the AlgLib Cash-Karp Solver, Cash-Karp being a refinement of the Runge-Kutta method of solving ordinary differential equations. Solution of differential equations is an iterative process requiring the repeated application of the solver routine followed by evaluation of … Continue reading

Posted in AlgLib, Beam Bending, Differential Equations, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , , , | 8 Comments