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)


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
  • 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
Support Moments 19.2
Total RHS 3217.536
Support Moment, M 167.58
Span Moment
Maximum Span Moment 136.71
Shear 1 134.75
Shear 2 174.93
Maximum Shear, V 174.93
Concrete Characteristics Stress (kN/m2) 25
Steel Characteristics Stress (kN/m2) 410
Stirrup Characteristics Stress (kN/m2) 250
Maximum lever arm 0.95
Maximum k-Value 0.156
Moment, M 167580000
k-Value 0.1862
Lever arm factor 0.707632153
Used Lever arm 0.707632153
Area of Steel (mm2) 1520.012553
Moment, M 136.71
K-value 0.1519
Lever arm factor 0.784995127
Used Lever arm 0.784995127
Area of Steel (mm2) 1117.80454
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


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 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.


About the Author


  1. Sikiru Yusuff Olatunji 11 months ago
  2. Nsuhoridem Akpan 10 months ago

Leave a Reply

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