Category Archives: Concrete

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 , , , , , , | 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 , , , , , , | 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 , , , , , , | 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 , , | 4 Comments

LatPilePY 1.02

Following some discussion at Eng-Tips and elsewhere I have updated the LatPilePY spreadsheet, previously presented at Lateral pile analysis with PY curves …  This spreadsheet provides User Defined Functions (UDFs) to carry out the analysis of vertical piles under lateral loading, … Continue reading

Posted in Concrete, Excel, Geotechnical Engineering, Newton, UDFs, VBA | Tagged , , , , , , | 3 Comments