Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- 3DFrame - 3D Frame analysis for Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads by category
- Calling Add-in functions from VBA
- About Newton Excel Bach
- Beam actions and deflections by Macaulay's Method
Recent Comments
Tag Archives: Prestressed concrete
ULS Design Functions – Python version
I have now converted my ULS Design Functions spreadsheet (last presented here) to Python. The new spreadsheet and open source Python code can be downloaded from: py_ULS Design Functions The spreadsheet has the same functionality as the VBA version, providing … Continue reading
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