Recent Comments
Category Archives: UDFs
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
Reinforced Concrete Moment-Curvature – 1
The flexural curvature of any beam composed of material with linear elastic behaviour, subject to a bending moment, M, is given by: C = M / EI where E is the elastic modulus of the beam, and I is its … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged cracked, Curvature, deflections, Reinforced Concrete, tension stiffening
5 Comments
Newton Excel Bach, not (just) an Excel Blog 