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.
How to use the Excel Sheet for Slab Steel Quantity Calculation
1- Data Required
i) Length, Width, and Thickness of the slab.
ii) The diameter of the main steel bar and Distribution steel bars.
iii) The spacing of main steel bar and Distribution steel bars.
iv) Cover Details: Side Cover, Top and 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 fixed 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 =______
Sample Calculation for Steel Quantity of Slab
Sample Calculation for slab having Size Length 35 feet and Width 14 feet
