|
Disclaimer: The Engineering Tools provided have been checked, but, that being said, WikiEngineer is not able to guarantee the complete accuracy of all these works. Therefore it is important for everyone to do their due diligence to make sure that all works are complete and accurate. If any mistakes are found they will be added to the Addendum portion you will find under each spreadsheet. Also, if a new version is uploaded the version will change (all versions will start at v1.0 and update accordingly). It is up to you to do your own research and make certain that you have reviewed the spreadsheet you're using and that you are using the most up-to-date spreadsheet available |
What does the Concrete T-Beam Spreadsheet solve?
Fig. 1: Concrete Beam/Slab Variables
This spreadsheet will find the flexural capacity of a concrete t-beam. It is solved using LRFD loads.
| How to Understand this Spreadsheet | |||||||||||||
Where to download?
How to use this Spreadsheet:
This spreadsheet works in Microsoft Excel 2003 and later. A complete walkthrough of how this spreadsheet works can be found here.
The top portion of the spreadsheet allows you to change your inputs:
Fig. 2: Spreadsheet Inputs
where:
b = width of the beam
cov = rebar cover
d = distance to rebar
t = thickness of the slab
fy = the strength of the rebar (psi)
fc' = the strength of the concrete (psi)
β1 = Strength Reduction Ratio
ø = Strength Reduction Factor
As = Steel area in member (in2)
L = total length of the t-beam
s = t-beam spacing (on center)
The bottom portion of the spreadsheet calculates øMn (the factored capacity of the beam using LRFD). It also checks to see if the beam is tensioned controlled (this will determine what your ø factor should be.
Fig. 3: Spreadsheet Results
where:
Notes:
The following notes must be considered when using this spreadsheet:
- This spreadsheet was created using:
- ACI 318-05 (Chapter 9)
- Wright & Macgregor, Reinforced Concrete 5th ed., 2009
- Leet & Bernal, Reinforced Concrete 3rd ed., 1997
- This spreadsheet solves for flexural only (shear is not considered)
- A wonderful example of a T-Beam design is available in the CERM (Chapter 50, Page 22)
Addendum
- V1.0: This is the original version of the column stability factor spreadsheet