Recent Comments
Tag Archives: VBA
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
Daniel’s XL Toolbox
I downloaded this yesterday: Daniel’s XL Toolbox “Daniel’s XL Toolbox is a free, open source add-in for Excel® that helps you to analyze and present data.” See the link for a full description. I’ve only had a brief look, but … Continue reading
Reinforced Concrete Section Analysis – with prestress
The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement. The spreadsheet (including full open source code) can be downloaded from RC Design Functions5. Note … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, Curvature, EC2, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS, Ultimate capacity, VBA
3 Comments
