Recent Comments
Category Archives: UDFs
Good practice, best practice, or just practice?
Browsing the ‘net this morning I found the “Golden Rules” listed below at Ozgrid.com The rules are described as things that “should not be optional”, which seemed to me in some cases to be going way too far, since for many … Continue reading
Perfect Anniversaries
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 Anniversaries, Perefect numbers, UDF, VBA
Leave a comment
Distributing Silverfrost Fortran Applications
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 dll, Excel, Fortran, Silverfrost, UDF, VBA
2 Comments
Cubic Spline Update
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
Reinforced Concrete Moment-Curvature – 2; Shrinkage and Creep
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
Newton Excel Bach, not (just) an Excel Blog 