Bar Bending Schedule In Excel As Per Is Code [2021]
Where R2 = straight length.
Ld = (0.87 × fy × φ) / (4 × τbd) (Usually simplified in BBS as 40d to 50d for Fe500 bars). bar bending schedule in excel as per is code
=CONCATENATE("IS 2502:1963 Compliant | Total Steel: ", ROUND(SUM(N6:N100),2), " kg") Where R2 = straight length
Cutting length = Horizontal length + (2 × crank length) – (2 × bend deduction) bar bending schedule in excel as per is code
=(2*(K2+L2)) + (24*D2)
Use data validation to restrict Shape Codes per IS 2502:
(Column M) - in meters
