Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- XLDennis, the MSDN Library, and VBA rant
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Linking Excel to C
- Biaxial bending update
- Daily Download 4: Continuous Beam Analysis
Recent Comments
Category Archives: UDFs
Daily Download 4: Continuous Beam Analysis
Today’s download files contain several alternative functions for analysing continuous beams. The most flexible is the ConBeamU spreadsheet, which in addition to the continuous beam function also contains functions for single span beams and cantilevers, and for fixed end moments and … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beams, Cubic splines, Excel, Macaulay's Method, UDF, VBA
15 Comments
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