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

### 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/m2) 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/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.

1. • 2. • 