Our Services
Total Downloads
Popular
- The ExcelCalcs Calculation Repository
- Help and Tutorials
- Alex's Excel Gold.
- Name Equations
- Show Equations
- ExcelCalcs Training and Seminars
- Division Line Position Functions
- Controlling the Appearance of Equations
- Site Searches
- ExcelCalcs Site Rules
- Format Units
- Projectiles
- Latest Uploads
- Redraw all Worksheet Equations
- A Handy Drawing Tool
Beam Design Functions.zip
Download
- Description:
-
Elastic Analysis of Reinforced and Prestressed Sections
The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis:
For a cross section with any applied axial load at eccentricity e, measured from the compression face, and depth of the neutral axis X below the compression face:
INA = QNA(X + e)
Where QNA and INA are the first and second moments of area about the neutral axis.
To illustrate this relationship the value of INA has been plotted for a range of neutral axis positions for a typical precast bridge beam, shown below, and compared with the value QNA(X + e) for 5 different values of e.

The intersection of the INA and QNA(X + e) lines gives the depth of the neutral axis for the corresponding value of load eccentricity, e. This is illustrated in the second graph, where the value of (INA - QNA(X + e)) is plotted against the depth of the neutral axis, X, for a load eccentricity of 1 metre above the compression face. The intersection of this line with the X axis gives the depth of the neutral axis for the specified load eccentricity.Note: Another calculation file ULS Design Functions.zip contains User Defined Functions (UDF’s) that will find the ultimate bending capacity of any reinforced or prestressed concrete section
Forum Link
Discuss this document in the Forum (subscribe to this topic to be notified of changes). - Submitted On:
- 20 Aug 2008
- Submitted By:
- Doug Jenkins (DougJenkins)
- File Date:
- 19 Aug 2008
- File Author:
- Doug Jenkins
- File Version:
- 1.03
- File Size:
- 304.15 Kb
- File Type:
- zip
- File HomePage:
- Click to visit site
- Downloads:
- 118
- Rating:
- Be the first to comment! Please sign in or register.



