How to Prepare Bar Bending Schedule and its Usage with Excel sheet

[Sang15512]

Great Information

 

[Prabhupada Sahoo]

Bar Bending Schedule
Just like any other schedules, bar bending schedule is most important part of any project.
It helps in doing reconciliation of steel and controlling the wastage at site.
If bar bending schedule (BBS) is not prepared at site, then contractor and its workmen tend to cut and and bend bars without quantifying it and leads to more wastage due to over doing it.

I have created a Bar bending Schedule format in excel sheet, which can be used for followings;
Taking approval from Client or Engineer Incharge - Its a Certificate which allow workmen to do work accordingly.
Ordering the required reinforcement steel Quantity.
Issuing Steel bars to contractor as per BBS and avoiding overdoing and wastage.
Reconciliation of done work and identifying the issues in cutting and bending of steel.
It does a great help to fitter to do cutting and bending as all dimensions and cutting length already provided to them in BBS.
It increases productivity of reinforcement workmen and hence reduce the delays in construction activities.


View attachment 954

Above picture shows what it consist of.

Engineer who going to use this sheet for doing BBS should aware of following;
Should be able to read the structural and architectural drawings.
Should know where the lapping of bar is to be done.
Should know how to calculate number of bar as per spacing in any given member.
Basic knowledge of using excel sheet.

If you knows above you can use this program and can successfully make a BBS.

Once you enter the desired data like, member details, shape of bar, bar mark (you can put any, it helps you to tagging the lot and keep it properly till its shifted to actual work position),Diameter of bar, Dimensions of bar and number of bends according to angle of bend, number of members and number of bar per member, this excel program does rest calculation automatically and gives you total steel required as per diameter in Meter, Kg and metric ton along with the cutting length of each shape bar.
View attachment 955

To make your work easy, we have added some basic shape on another sheet in that excel, from where you can simply copy and paste shape of bar to increase productivity. If you do not find your desired shape of bar you can create new in that list and use it as ready reference.
View attachment 956

If you have any difficulties in using it, you can always reply here for further help.

You can download the BBS format Sheet from the below attachment.

Sir very good format , I have a query
Bar Bending Schedule

45o	90o	180o
0.25	0.5	1

what is the meaning of above bend and their value

 

[Waiswa Alex]

Bar Bending Schedule
Just like any other schedules, bar bending schedule is most important part of any project.
It helps in doing reconciliation of steel and controlling the wastage at site.
If bar bending schedule (BBS) is not prepared at site, then contractor and its workmen tend to cut and and bend bars without quantifying it and leads to more wastage due to over doing it.

I have created a Bar bending Schedule format in excel sheet, which can be used for followings;
Taking approval from Client or Engineer Incharge - Its a Certificate which allow workmen to do work accordingly.
Ordering the required reinforcement steel Quantity.
Issuing Steel bars to contractor as per BBS and avoiding overdoing and wastage.
Reconciliation of done work and identifying the issues in cutting and bending of steel.
It does a great help to fitter to do cutting and bending as all dimensions and cutting length already provided to them in BBS.
It increases productivity of reinforcement workmen and hence reduce the delays in construction activities.


View attachment 954

Above picture shows what it consist of.

Engineer who going to use this sheet for doing BBS should aware of following;
Should be able to read the structural and architectural drawings.
Should know where the lapping of bar is to be done.
Should know how to calculate number of bar as per spacing in any given member.
Basic knowledge of using excel sheet.

If you knows above you can use this program and can successfully make a BBS.

Once you enter the desired data like, member details, shape of bar, bar mark (you can put any, it helps you to tagging the lot and keep it properly till its shifted to actual work position),Diameter of bar, Dimensions of bar and number of bends according to angle of bend, number of members and number of bar per member, this excel program does rest calculation automatically and gives you total steel required as per diameter in Meter, Kg and metric ton along with the cutting length of each shape bar.
View attachment 955

To make your work easy, we have added some basic shape on another sheet in that excel, from where you can simply copy and paste shape of bar to increase productivity. If you do not find your desired shape of bar you can create new in that list and use it as ready reference.
View attachment 956

If you have any difficulties in using it, you can always reply here for further help.

You can download the BBS format Sheet from the below attachment.

Thanks so much

 

[sari1433]

Thanks so much

Very useful
Thanks

 

[McGregor]

Thankyou for sahring

 

[Yogeshrj]

I have doubt about bend deduction like why have u considered. 25 for 45° and 1 for 180° shouldnt it be 1d for 45° 2d for 90° and 3d for 135*° bend please help me understanding it better and thankyou for such informative post.

 

[itzsfz]

For dimensions of bends follow structural drawings provided by structural consultant.

In absense of dimensions on drawing you can follow IS 2502, refer fig 1A and 1B in it.

please share BBS of colulmn, beam and slab as well also explain percentage of bar for lapping

 

[abhiraj]

Its a problem of how excel sheets works.

You need to delete shape by selecting them.

why 135 degree bend is not shown?

 

[Haziq]

Thanks for the sheet. Very helpful for all the Civil Engineer s

 

[Ghosh]

Pl send me BBS EXCEL SHEET format to my mail

 

[surja80]

Thank you very much sir

 

[Muzzi_wani]

Thanks for the valuable information sir, but a question arises regarding bent elongation and please will you clear it like for 45 degree we are taking 1d, for 90 degree 2d, for 135 3d and for 180 4d. If we consider these with 0.25,0.5 and 1, there is much difference in deducting. Hope to get the response from you soon. Thank you

 

[Muzzi_wani]

I have doubt about bend deduction like why have u considered. 25 for 45° and 1 for 180° shouldnt it be 1d for 45° 2d for 90° and 3d for 135*° bend please help me understanding it better and thankyou for such informative post.

Same is the doubt which I encountered. Have you got the reply back.

 

[Rajesh183]

Bar Bending Schedule
Just like any other schedules, bar bending schedule is most important part of any project.
It helps in doing reconciliation of steel and controlling the wastage at site.
If bar bending schedule (BBS) is not prepared at site, then contractor and its workmen tend to cut and and bend bars without quantifying it and leads to more wastage due to over doing it.

I have created a Bar bending Schedule format in excel sheet, which can be used for followings;
Taking approval from Client or Engineer Incharge - Its a Certificate which allow workmen to do work accordingly.
Ordering the required reinforcement steel Quantity.
Issuing Steel bars to contractor as per BBS and avoiding overdoing and wastage.
Reconciliation of done work and identifying the issues in cutting and bending of steel.
It does a great help to fitter to do cutting and bending as all dimensions and cutting length already provided to them in BBS.
It increases productivity of reinforcement workmen and hence reduce the delays in construction activities.


View attachment 954

Above picture shows what it consist of.

Engineer who going to use this sheet for doing BBS should aware of following;
Should be able to read the structural and architectural drawings.
Should know where the lapping of bar is to be done.
Should know how to calculate number of bar as per spacing in any given member.
Basic knowledge of using excel sheet.

If you knows above you can use this program and can successfully make a BBS.

Once you enter the desired data like, member details, shape of bar, bar mark (you can put any, it helps you to tagging the lot and keep it properly till its shifted to actual work position),Diameter of bar, Dimensions of bar and number of bends according to angle of bend, number of members and number of bar per member, this excel program does rest calculation automatically and gives you total steel required as per diameter in Meter, Kg and metric ton along with the cutting length of each shape bar.
View attachment 955

To make your work easy, we have added some basic shape on another sheet in that excel, from where you can simply copy and paste shape of bar to increase productivity. If you do not find your desired shape of bar you can create new in that list and use it as ready reference.
View attachment 956

If you have any difficulties in using it, you can always reply here for further help.

You can download the BBS format Sheet from the below attachment.

Sir how to calculate bend deduction for 45° is 0.25D, 90° is 0.5D & 180° is 1D. What is the value for 135° bend. Please clear the value calculation.