RCC Beam Design Excel Template to BS 8110 – How to Develop

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 Moments19.2
Total RHS3217.536
Support Moment, M167.58
Span Moment
Maximum Span Moment136.71
SHEAR
Shear 1134.75
Shear 2174.93
Maximum Shear, V174.93
DESIGN
Concrete Characteristics Stress (kN/m2)25
Steel Characteristics Stress (kN/m2)410
Stirrup Characteristics Stress (kN/m2)250
Maximum lever arm0.95
Maximum k-Value0.156
SUPPORT REINFORCEMENT
Moment, M167580000
k-Value0.1862
Lever arm factor0.707632153
Used Lever arm0.707632153
Area of Steel (mm2)1520.012553
PROVIDE ————- TOP
SPAN REINFORCEMENT
Moment, M136.71
K-value0.1519
Lever arm factor0.784995127
Used Lever arm0.784995127
Area of Steel (mm2)1117.80454
PROVIDE —————-BTM
SHEAR
Max Shear Force, V174.93
Shear Stress, v (N/mm2)1.943666667
Percent Steel1.046666667
Permissible Shear Stress0.57
Stirrup Spacing120.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/m2)25
Steel Characteristics Stress (kN/m2)410
Stirrup Characteristics Stress (kN/m2)250
Maximum lever arm0.95
Maximum k-Value0.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 Stress0.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.

 

About the Author

4 Comments

  1. Sikiru Yusuff Olatunji 1 month ago
  2. Nsuhoridem Akpan 2 weeks ago

Leave a Reply

Your email address will not be published. Required fields are marked *