The previous post in this series included Excel User Defined Functions using closed form solutions to find the ultimate bending and axial load capacity of reinforced or prestressed concrete sections of any complex shape defined by rectangular or horizontal layers. The paper ultimate-moment-capacity1 provides the derivation of the solutions used in these functions. An extract from the paper is shown below.
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Cubic Splines
- Downloads by category
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Frame Analysis with Excel - 4, 2D frame analysis
- Writing an array to a worksheet range - correction
- Retrieving unique values from a range or array ...
dougaj4 on The Conjugate Beam Method William Harvey on The Conjugate Beam Method dougaj4 on ConbeamU 4.10 dougaj4 on ConbeamU 4.10 Jérémie on ConbeamU 4.10 Francisco Rossier on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Alan Elston on Worksheetfunction.Transpose… Alan on Worksheetfunction.Transpose… Francisco Rossier on Using LINEST for non-linear cu… dougaj4 on Worksheetfunction.Transpose… dougaj4 on Worksheetfunction.Transpose… Francisco Rossier on Using LINEST for non-linear cu… 3D Frame analyses wi… on ConBeamU 4.05 and ConBeampy… 3D Frame analyses wi… on 3DFrame with spring relea…