# How to Calculate Steel Quantity For Slab Excel Sheet

In this article, you will learn about how to calculate steel quantity for the slab in Excel Sheet.

As we think that calculating steel quantity for the slab is a too difficult task, it required good skills in civil engineering. but I am sharing with you an excel sheet, which will make slab steel quantity calculation too easy for anyone who wants to know the exact quantity of steel required for his/her slab.

Post Contents

## How to use the Steel Quantity Calculation Excel Sheet:

### 1) Data Required:

i) Length, Width, and Thickness of slab.

ii) The diameter of main steel bar and Distribution steel bars.

iii) The spacing of main steel bar and Distribution steel bars.

iv) Cover Details: Side Cover, Top & Bottom Cover for Slab.

### 2) Assumption:

i) Bent up bar has bent up angle 45Â°.

ii) All Bent ups are provided at Effective Span/4 Distance as per IS.

iii) Standard Hooks length is taken as 9D (D = Diameter of steel bars)

iv) The supporting wall has a fix width of 300 mm or 0.3 m.

### Steps to Calculate Steel Quantity:

1. Enter Length and Width of your slab in ft in Excel Sheet. (Convert Inches to feet)
2. Enter the Thickness of the slab in mm only.
3. Enter Main and distribution steel diameter in Excel Sheet.
4. Enter Cover Details. (If Don’t have cover details let it be, they are standard cover)
5. Enter Spacing of Main bent bar and Distribution steel bars in mm only.

As you Enter these data correctly in excel sheet on right-hand side you can see the following quantity of slab:

No. of bent up bars =______

No. of Distribution bars = ______

Length of Main Bars = ______

Length of Distribution Steel = ______

Weight of Main Steel bars = ______

Weight of Distribution Steel bars = _______

Total Steel Required For Slab = ________

Cost of Total Steel at rate of 45 rs./ kg =______

How to calculate steel quantity for slab

## Sample Slab Reinforcement Calculation Excel:

Sample Calculation for slab having Size Length 35 feet & Width 14 feet

## FAQs

You May Also Like

### 5 thoughts on “How to Calculate Steel Quantity For Slab Excel Sheet”

1. Thank u for your free supplying.
If you don’t mind can you tell me how can i install CSiBridge softwarw after unintalling one version?

Scroll to Top