Bar Bending Schedule In Excel As Per Is Code Upd Guide

Cutting length = Horizontal length + (2 × crank length) – (2 × bend deduction)

| Column | Header | Description | |--------|--------|-------------| | A | Bar Mark Ref. | Unique ID (e.g., B1, C2) | | B | Member | Beam/Column/Slab/Footing | | C | Bar Shape Code | As per IS 2502 (00, 01, 11, 13, 51, etc.) | | D | Diameter (mm) | 8, 10, 12, 16, 20, 25, 32 | | E | No. of Bars | Quantity | | F | Cutting Length (m) | Calculated via formula | | G | Total Length (m) | =E × F | | H | Weight per m (kg/m) | Standard density: (d^2)/162 | | I | Total Weight (kg) | =G × H | | J | Shape Code Ref. | Sketch or description | | K-R | Parameters (a,b,c,d, etc.) | For shape calculations | | S | Remarks | Lap, bent-up, extra top | bar bending schedule in excel as per is code

Use data validation to restrict Shape Codes per IS 2502: Cutting length = Horizontal length + (2 ×

The Indian Standards (IS) code provides guidelines for preparing a bar bending schedule. According to IS 2505:1985 (Reaffirmed 2002), the BBS should include the following information: | Sketch or description | | K-R | Parameters (a,b,c,d, etc