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

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
45o90o180o
0.250.51
what is the meaning of above bend and their value
 
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
 
  • Like
Reactions: sari1433
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.
 
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