Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...
- Latex Maths Text in Excel
- Automatic download of csv files
- Cubic Splines
- 3D Matplotlib Plots in Excel
- About Newton Excel Bach
- Contour plots with Excel and Matplotlib
Recent Comments
Category Archives: Concrete
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
ULS Analysis of Concrete Beams; now with added units
The spreadsheet for Ultimate Limit State Analysis of reinforced or prestressed concrete beams, previously presented here, has been combined with the Units4Excel spreadsheet to allow the program to work with any selected units, SI or non-SI. Provision for the American … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Concrete section, Excel, UDF, ULS Analysis, unit aware, VBA
10 Comments
Composite Beam Spreadsheet 3
The Composite Beam Analysis spreadsheet, previously discussed at: https://newtonexcelbach.wordpress.com/2012/04/27/composite-beam-spreadsheet-2/ has now been updated with a VBA User Defined Function (UDF) in place of the previous macro that used the Excel Goal-Seek command. This has two main advantages: The UDF is much faster … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Brents method, composite concrete beam, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
5 Comments
Composite Beam Spreadsheet – 2
The previous post on this topic presented a spreadsheet performing elastic analysis of composite reinforced or prestressed composite beams, available for download from: Composite Design Functions-GS.zip. This post will look in more detail at how the spreadsheet works, and a preview … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
4 Comments
Composite Beam Spreadsheet
As promised in the previous post, a spreadsheet for designing reinforced or prestressed concrete composite beams has now been uploaded to my web site. It can be downloaded from: Composite Design Functions-GS.zip . As usual, the spreadsheet includes full open-source code. … Continue reading
Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged composite concrete beam, Excel, Goal Seek, Prestressed concrete, Reinforced Concrete, UDF, VBA
3 Comments