Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Retrieving unique values from a range or array ...
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Beam actions and deflections by Macaulay's Method
Recent Comments
Benata on Ana Vidović 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…
Tag Archives: Section Analysis
ULS Design Functions update
The ULS Design Functions spreadsheet has been updated with further changes related to the new Australian Standard for concrete structures; AS 3600-2018, and with some other fixes. The new version can be downloaded from: ULS Design Functions.zip The changes in … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, Eurocode 2, Excel, Non-rectangular sections, Reinforced Concrete, Section Analysis, UDF, VBA
13 Comments
Using Beam Design Functions
“Beam Design Functions” is an Excel spreadsheet providing a User Defined Function (UDF) that will calculate the stresses, strains, forces and moments in a reinforced or prestressed concrete section subject to any specified bending moment and axial load, using an … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Beam Bending, elastic analysis, Excel, Prestressed concrete, Reinforced Concrete, Section Analysis, UDF, VBA
12 Comments
ULS design of reinforced concrete, AS, ACI and European codes
The previous post in this series compared the results of current and previous Australian Standards, and the ACI 318 code, for the ultimate bending capacity of a rectangular reinforced concrete section, subject to combined bending and axial load. I have now extended … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs
Tagged ACI 318, AS 3600, BS 5400, BS 8110, Concrete, EC 2, Reinforced Concrete, Section Analysis, Ultimate capacity
1 Comment
ULS design of reinforced concrete to AS 3600 and ACI 318
Following on from the previous post I have modified my RC Design Functions spreadsheet to incorporate the US ACI 318 design code requirements, as well as the recent revision to the Australian code, AS 3600. The revised spreadsheet will be uploaded … Continue reading
Posted in Beam Bending, Concrete, Newton
Tagged ACI 318, AS 3600, Concrete, Reinforced Concrete, Section Analysis, Ultimate capacity
3 Comments
Reinforced Concrete Section Analysis 7 – rectangular sections
Previous post The spreadsheets presented in earlier posts in this series have been simplified for use with rectangular sections with two layers of reinforcement. The functions EStress (for elastic analysis of stresses, strains and crack widths) and UMom (for the … Continue reading
Posted in Beam Bending, Concrete, Newton, UDFs
Tagged Beam Bending, Reinforced Concrete, Section Analysis, UDF, Ultimate capacity, VBA
3 Comments