Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
- Automating chart scale limits - update
Recent Comments
Category Archives: Concrete
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
Composite Concrete Beam Analysis
Composite concrete beams are widely used in both building and bridge structures; typically precast pretensioned beams are combined with an in-situ reinforced concrete slab to provide structures that are both efficient in use of materials and fast and easy to … Continue reading
Posted in Concrete, Newton
Tagged Composite section analysis, Prestressed concrete, Reinforced Concrete
4 Comments