The simplified reinforced concrete section analysis spreadsheet presented here has been revised to allow the input of a pre-tension stress to either or both layers of reinforcement. The spreadsheet (including full open source code) can be downloaded from RC Design Functions3.
Note 26 Oct 2009: The version of Estress originally uploaded gave incorrect output for total force and bending moment when the neutral axis depth was below the bottom reinforcement. A corrected version has now been uploaded and is dated 26 Oct 2009.
Note that this spreadsheet is intended for the analysis of rectangular beams or slabs with two layers of reinforcement. For more complex sections refer to Reinforced Concrete Section Analysis – 5; Ultimate Limit State and Reinforced Concrete Section Analysis – 3.
In addition to the provision for prestressed reinforcement the revision also provides additional output data on section curvature, including analysis of tension stiffening effects and shrinkage according to the Eurocode EC2, and analysis of shrinkage curvature using a fictitious pre-compression stress applied to the reinforcement. More details on these revisions will be given in a later post.
Typical Input and Output:
Estress input, including pre-stress
EStress Output
Filed under: Beam Bending, Concrete, Excel, Newton, UDFs, VBA | Tagged: Beam Bending, Curvature, EC2, Excel, Prestressed concrete, Reinforced Concrete, UDF, ULS, Ultimate capacity, VBA
[...] factors, using Excel based User Defined Functions (UDFs) presented in previous posts (see RC Design Functions for rectangular sections with two layers of reinforcement, or Beam Design Functions for beams with [...]