Bar Bending Schedule In Excel As Per Is Code -

| Mistake | IS Code Violation | Fix in Excel | |---------|------------------|---------------| | Using 0.006167 instead of d²/162 | Slight weight variation | Use =ROUND(D2^2/162,3) | | No deduction for 90° bend | Overestimation of steel | Subtract 2d per bend | | Adding hook and lap both | Double counting | Separate columns | | Incorrect shape code | Rejection by engineer | Dropdown validation |

=R2 + (2 * 9 * D2)

Deduction per 45° bend = 0.5d. Total bends = 2 (for two cranks). bar bending schedule in excel as per is code

Now formulas become readable:

Ld = (0.87 × fy × φ) / (4 × τbd) (Usually simplified in BBS as 40d to 50d for Fe500 bars). | Mistake | IS Code Violation | Fix

Also, a pivot table can group by and Diameter .

=K6*L6/1000

(Column N) - in kg