Do you want to develop Beam Design Excel Template? MS Excel is one of the great tool one could ever imagine himself learning. Its application is almost everywhere. If you talk of Accounting, Engineering, Banking, etc.
I want to help those who may want to develop their own Excel design sheet(reinforced concrete design spreadsheet excel). This excel sheets help you simplify the calculations required to design a simply supported reinforced concrete beam. All you need to do is, enter the inputs and then check the final values calculated by the sheet.
In Nigeria, we use BS or Eurocode. But in this short article, I will use BS 8110 to develop a very simple RCC Beam Design Excel Template to design 2 Span Beams.
See also: How to Calculate Area of Objects in AutoCAD (with Perimeter)
Requirement
Before you proceed, make sure you
- Have the basics of MS Excel.
- You are ready to learn.
- have the basic understanding of BS code.
- Have a good PC with MS Excel installed in it.
In Excel, some of the functions we will be using include the following:
- SUM
- MAX
- POWER
- SQRT
The above functions are just the simplest one you could talk of. This makes the design as simple as ABC. Yes. I mean ABC. Let me tell you that you do not need attend Harvard to know how to do this. If you have a good brain that can grab A-Z, then you can go ahead and follow this short tutorial.
In the subsequent tutorial, we will learn how to use the above Excel Functions.
When Designing a Beam template (concrete beam design calculator), bear in mind
RCC Beam Design Excel Template to BS 8110
The beam we will be developing will look like the below:
Beam Span 1 (m) | 3.6 |
Beam Span 2 (m) | 6 |
Beam Depth (mm) | 450 |
Beam Effective Depth (mm) | 400 |
Beam flange Width (mm) | 225 |
Beam Rip width (mm) | 225 |
Slab load on Beam (kN/m) | 24 |
Beam Self load (kN/m) | 5 |
Wall load on beam (kN/m) | 20 |
Other UDL (kN/m) | 0 |
Total Load on Beam (kN/m) | 49 |
ANALYSIS | |
Support Moments | 19.2 |
Total RHS | 3217.536 |
Support Moment, M | 167.58 |
Span Moment | |
Maximum Span Moment | 136.71 |
SHEAR | |
Shear 1 | 134.75 |
Shear 2 | 174.93 |
Maximum Shear, V | 174.93 |
DESIGN | |
Concrete Characteristics Stress (kN/m^{2}) | 25 |
Steel Characteristics Stress (kN/m2) | 410 |
Stirrup Characteristics Stress (kN/m2) | 250 |
Maximum lever arm | 0.95 |
Maximum k-Value | 0.156 |
SUPPORT REINFORCEMENT | |
Moment, M | 167580000 |
k-Value | 0.1862 |
Lever arm factor | 0.707632153 |
Used Lever arm | 0.707632153 |
Area of Steel (mm2) | 1520.012553 |
PROVIDE ————- TOP | |
SPAN REINFORCEMENT | |
Moment, M | 136.71 |
K-value | 0.1519 |
Lever arm factor | 0.784995127 |
Used Lever arm | 0.784995127 |
Area of Steel (mm2) | 1117.80454 |
PROVIDE —————-BTM | |
SHEAR | |
Max Shear Force, V | 174.93 |
Shear Stress, v (N/mm2) | 1.943666667 |
Percent Steel | 1.046666667 |
Permissible Shear Stress | 0.57 |
Stirrup Spacing | 120.6422389 |
PROVIDE ———@——– AS LINKS | |
END |
RCC Beam Design Excel Template Guide
Starting from the top of the template we will see how to develop this simple 2 span beam calculator.
#1. Beam Span 1 and 2, Beam Depth (which will require a dynamic input and could be changed anytime). This does not involve any formula to achieve this using Cells A1 and A2 respectively.
#2. The Beam Effective Depth: This will require you to use a simple SUBTRACT function. Effective depth is got by subtracting (25 + 25) from the beam depth. Where 25 is the cover.
#3. Using normal text, type the following into the cells Beam flange Width, Beam Rip width, Slab load on Beam, Beam Self load, Wall load on beam, Other UDL,
#4. Using =SUM(B7:B10) in cell B11 to get the value of the Total Load on Beam.
#5. In Cell B12, type in Analysis. This is optional. But it will be necessary you use as a guide.
#6. For the Support Moment, use this formula: =PRODUCT(2,SUM(B1,B2)).
#7. Total RHS: Use =PRODUCT(B11/4,POWER(B1,3)+POWER(B2,3)).
#8. Support Moment, M: =B14/B13
#9. Maximum Span Moment: =0.125*MAX(B1,B2)^2*B11-B15/2
#10. Shear 1: =B11*B1/2+B15/B1, and Shear 2: =B11*B2/2+B15/B2.
#11. Maximum Shear, V: =MAX(B19,B20).
Concrete Characteristics Stress (kN/m^{2}) | 25 |
Steel Characteristics Stress (kN/m2) | 410 |
Stirrup Characteristics Stress (kN/m2) | 250 |
Maximum lever arm | 0.95 |
Maximum k-Value | 0.156 |
The above parameters does not require the use of any of the Excel Formula.
#13. Moment, M: =B15*1000000
#14. k-Value: =B31/(B24*B6*B4^2)
#15. Lever arm factor: =0.5+SQRT(0.25-B32/0.9)
#16. Used Lever arm: =MIN(B27,B33)
#17. Area of Steel: =B31/(0.95*B25*B34*B4)
#18. For the span reinforcement, Moment, M:
#19. K-value: =(B17*1000000)/(B24*B5*POWER(B4,2))
#20. Lever arm factor: =0.5+SQRT(0.25-B41/0.9)
#21. Used Lever arm: =MIN(B27,B42)
#22. Area of Steel, =(B40*1000000)/(0.95*B25*B43*B4).
#23. Max Shear Force, V: =B21
#24. Shear Stress, v: =(B49*10^3)/(B6*B4)
#25: Percent Steel: =(100*942)/(B6*B4)
#26. This doesn’t involve any formula
Permissible Shear Stress | 0.57 |
#27. Stirrup Spacing: =(157*0.95*B26)/(B6*(B50-B52)).
After you have successfully implemented the above, you can go ahead to Save your work.
God bless you, I believe. Just continue doing the great work.
Thank you very much. I appreciate
I love this. Keep it up.
Thank you.