Category Archives: Excel

Perfect Anniversaries

Posted on 13/01/2010 by dougaj4

The young author of  The Math Less Travelled has just celebrated his 28 birthday, noting that 28 is a perfect number.  He laments that since the next perfect number is 496, it is most unlikely that he will see another perfect … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , | Leave a comment

Frame4.xls – Update2

Posted on 31/12/2009 by dougaj4

It was recently pointed out to me that the Frame4 spreadsheet was giving an overflow error with a fairly small analysis.  The problem turned out to be that the analysis did not have any restraint specified in the X direction, … Continue reading →

Posted in Excel, Finite Element Analysis, Frame Analysis, Newton, VBA | Tagged , , , | 12 Comments

Distributing Silverfrost Fortran Applications

Posted on 28/12/2009 by dougaj4

Earlier posts have included User Defined Functions (UDFs) linked to Fortran dll files compiled with Silverfrost Personal Fortran: Solving simultaneous equations – Fortran dll Trigonometric Functions – dll Linking Excel to Fortran – 2 Transferring these files to a new computer it came to my … Continue reading →

Posted in Excel, Link to dll, UDFs, VBA | Tagged , , , , , | 2 Comments

Cubic Spline Update

Posted on 16/12/2009 by dougaj4

The previous post in this series presented a User Defined Function (UDF) to fit  a cubic spline to a series of points defined by XY coordinates.  Each segment of the resulting spline is defined by a separate cubic curve, which may be … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 1 Comment

Reinforced Concrete Moment-Curvature – 2; Shrinkage and Creep

Posted on 08/12/2009 by dougaj4

The previous post in this series provided an Excel User Defined Function (UDF) to find  the short term curvature of a reinforced concrete section subject to combined bending and axial load.  In this post UDFs will be presented to determine the strain … Continue reading →

Posted in Concrete, Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 4 Comments