Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 2DFrame-py
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Biaxial bending update
- Using VBA Evaluate as an Array Function
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- XLDennis, the MSDN Library, and VBA rant
- Cubic Splines
- Automatic download of csv files
Recent Comments
Tag Archives: UDF
Tension Stiffening
Tension Stiffening in reinforced concrete is the increase in stiffness of a cracked member due to the development of tensile stresses in the concrete between the cracks. The main application of tension stiffening theory in design applications is in the … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Excel, moment curvature, Reinforced Concrete, tension stiffening, UDF, VBA
3 Comments
Hello World (again)
Over at Daily Dose of Excel Dick has been asking for suggestions for excellent training, to which Jan Karel Pietersen replied that training should be relevant to the task at hand, and that “hello world” examples are useless. John Walkenbach responded … 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