Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Downloads
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 3: ULS design of reinforced concrete sections
- Linking Excel to C - 2
- Buckling of columns with varying cross section
Recent Comments
Category Archives: UDFs
Daily Download 3: ULS design of reinforced concrete sections
Today’s downloads provide a spreadsheet providing Ultimate Limit State (ULS) analysis of reinforced or prestressed concrete sections, and an iterative method for finding the depth of the Neutral Axis in a circular reinforced concrete section. The ULS analysis spreadsheet is described at: … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Brents method, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS Analysis, VBA
23 Comments
Daily Download 2: SLS design of reinforced concrete sections …
… and prestressed concrete sections. Today’s download installment covers spreadsheets for design of reinforced and prestressed concrete beams and columns at the Serviceability Limit State (SLS). The spreadsheets cover design of rectangular and circular sections, sections made up of any … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged Composite section analysis, crack width, creep, Excel, flexural stiffness, Prestressed concrete, Reinforced Concrete, shrinkage, tension stiffening, UDF, VBA
15 Comments
Daily Download 1: Buckling of columns, rings and arches
One of the disadvantages of the blog format is that valuable resources tend to get lost somewhere in the archives. To help make them a bit more visible, for the next month or so I plan to post links to … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, VBA
Tagged buckling, Downloads, Excel, Rings and Arches, stepped columns, UDF, VBA
Leave a comment
Tanh-Sinh Quadrature V3.0
I have received from Graeme Dennes another update to his Tanh-Sinh Quadrature spreadsheet, offering fast and convenient numerical integration functions. The spreadsheet can be downloaded from: Tanh-Sinh Quadrature (including, as usual, full open source code). Here is Graeme’s description of the changes: Tanh-Sinh Quadrature … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, Tanh-Sinh Quadrature, UDF, VBA
5 Comments
Continuous Beam Spreadsheet – with Units
The spreadsheet previously known as Macaulay has been updated to include “unit aware” versions of all the included functions, and has been renamed “ConBeamU”, to make it more obvious what it does. The new spreadsheet (including full opens source code) can be … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged Continuouse beam, Excel, Macaulay's Method, UDF, unit aware, VBA
21 Comments