Recent Comments
Tag Archives: UDF
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 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
Three UDFs
This post is in response to recent discussions at Daily-Dose-of-Excel where many and various worksheet formulas have been suggested to carry out tasks that are (it seems to me) better done with a simple User Defined Function (UDF): Adding Every … Continue reading
LatPile – Analysis of Lateral Loads on Piles
This post presents an Excel User Defined Function (UDF) to carry out the analysis of vertical piles subject to horizontal loads, using the same approach as employed in the DOS program COM624. A spreadsheet including the UDF and an on-spreadsheet … Continue reading
Posted in Beam Bending, Excel, Geotechnical Engineering, Newton, UDFs, VBA
Tagged COM624, Excel, Laterally loaded pile, LPile, UDF, VBA
11 Comments
Evaluating Polynomial Functions
A polynomial function is a function of the form: a + b*x + c*x^2 + d*x^3 … and the derivative (the slope of the line at point x) of this function is given by: b + 2c*x + 3d*x^2 … … Continue reading
Newton Excel Bach, not (just) an Excel Blog 