Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Contour plots with Excel and Matplotlib
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Brent's Method; Update and Examples
Recent Comments
mindOnion on Drawing a Buckyball in Ex… dougaj4 on Drawing a Buckyball in Ex… mindOnion on Drawing a Buckyball in Ex… mindOnion on Drawing in Excel 7 – Cre… Veronica Davenport on Asymmetric Catenary Function py_UMom spreadsheet… on More on combined shear and ben… Skip on xlwings – dataframes and… dougaj4 on xlwings – dataframes and… More on combined she… on RC Design Functions 9.03; comp… skip on xlwings – dataframes and… skip on mpmath for Excel dougaj4 on mpmath for Excel skip on mpmath for Excel dougaj4 on Composite Beam Spreadsheet Upd… metroxx on Composite Beam Spreadsheet Upd…
Tag Archives: Prestressed concrete
Composite Beam Spreadsheet Update 1.01
Following a comment here, I have modified the Composite Beam spreadsheet to correct the stage 1 stresses forces in the reinforcement as listed in Columns 6 and 7, when the tensile face is the top. The output has also been … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, Composite beam design, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
3 Comments
Faster Biaxial Bending
The spreadsheet to calculate ultimate moment capacity of a reinforced or prestressed concrete section under combined axial load and biaxial bending, last presented here, has been updated to use the QuadBrent solver, rather than the Excel Goal Seek function, for … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Brents method, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, ultimate moment capacity, VBA
1 Comment
Reinforced Concrete – ULS capacity under combined axial load and biaxial bending
I have modified the ULS Design Functions spreadsheet, last presented here, to analyse sections subject to bi-axial bending, and non-symmetrical sections. The new version makes use of the routines for splitting any section defined by XY coordinates into trapezoidal layers, described … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
13 Comments
Concrete ULS spreadsheet update
The ULS Design Functions spreadsheet has been updated with the addition of provision for the Eurocode 2 rectangular stress block. The new spreadsheet can be downloaded from: ULS Design Functions.zip (including full open-source code). For more details see: ULS Analysis … Continue reading
Posted in Concrete, Excel, Newton, UDFs, VBA
Tagged Concrete section, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS design, VBA
10 Comments
Bridges Over the Tiber -3
See Bridges Over the Tiber -1 for location map. The final installment of Bridges Over the Tiber brings us to the six bridges built in the 20 th Century, which can be grouped in three pairs: two copies of the ancient … Continue reading