How do I create a bar bending schedule in Excel?

How do I create a bar bending schedule in Excel?

Step by Step Preparation of Bar Bending Schedule:

1. Step 1: Identification of Members (Steel Bars)
2. Step 2: Count the Number of bars.
3. Step 3: Calculate the length of Reinforcement bars.
4. Step 4: Calculate the unit weight of Reinforcement Bar.
5. Step 5: Calculate the Weight of particular Shape of Bar.

How is bar bending schedule calculated?

1. Hook Length = 9D [D is Diameter of the Bar]
2. Bend Length = 16D [D is Diameter of the Bar]
3. Rectangular Stirrups | Length of Stirrups = 2A + 2B + (2 x 10d)
4. Triangular Stirrups | Length of Stirrups = 3H + (2 x 10d)
5. Circular Stirrups | Length of Stirrups = (3.142 x Dia of Steel Ring) + (2 x 10d)

How do you schedule a bar bending slab?

Steps to calculate the Reinforcement required for Slab:-

1. Deduct the cover for finding length of bar.
2. Evaluate the length of the distribution bar.
3. Calculate the Value of ‘D’ (Depth of slab- Top cover- Bottom cover)
4. Find out the No. of Bars.
5. Compute the Total wt of steel required for slab reinforcement.

Is code a bar bending schedule?

Bar Bending Schedule Formulas As Per IS:2502-1963 | Unit Weight of Steel Bars.

How do I calculate steel in Excel?

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. (
5. Enter Spacing of Main bent bar and Distribution steel bars in mm only.

What is bar schedule?

Bar bending schedule or schedule of bars is a tabular representation of reinforcement bar. It is generally represented for each type of R.C.C work. Bar bending schedule generally describes the particulars of bars, shape of bending with sketches and total length and weight of the bars along with their numbers.

How do I calculate column steel in Excel?

How is rebar schedule calculated?

Bar Bending Schedule for Reinforced Concrete Beam

1. Length of B1 = clear distance between walls + 2 x width of walls – 2 x bar cover + 2 x bend length.
2. Length of bar B2: A + B + C = 4000 + 2 x 230 – 2 x 40 + (1.414xH – H)
3. B2 = 4000 + 2 x 230 – 2 x 40 + (1.414×334 – 334) = 4518.3 = 4520mm.

How do you calculate bars for a slab?

Weight of bar in kg/meter should be calculated as (d2 ÷ 162) where’d’ is the diameter of bar in mm. ‘L’ for column main steel in footing should be considered as minimum 30cm/as specified. For bent up bar add 0.42d in a straight length of the bar where’d’ is the clear depth of beam/slab.

What is the formula for straight bar in bar bending schedule?

Bar Bending Schedule :-

S.No.	Particulars
1.	Standard Length of the Steel Bar (Bars are sold at standard Length)
2.	Weight of Bar for length = 1m
Ex:	If length of bar is 12m with 10mm Dia then , Weight of bar = D2/162 Therefore for length 1m = 1m x D2/162 = 1 x 102/162 = 0.61 Kgs For length 12m = 12 x 102/162 = 7.40Kgs