Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Frame Analysis with Excel 1 - Single beam
- Cubic Splines
- About Newton Excel Bach
- Taming Symbols in Excel
- Downloads
- Writing Arrays to the worksheet - VBA function
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
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