# 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

## 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

| | 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

| | 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 | | 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 | | 8 Comments