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

BruneiShiva

Junior Member
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.
Dear D. Deshmukh,
Excellent stuff!
Thanks for Sharing!

Best Regards
Shiva
 

Er.Ambily

Apprentice
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,
have a doubt, We have to provide lap length for half of the number of main bars in columns, right?
 

Dnyan Deshmukh

Staff member
Sir,
have a doubt, We have to provide lap length for half of the number of main bars in columns, right?

No, All column main reinforcement bars need to be lapped or welded or coupled with coupler.

At any given location, there should not be more than 50% of column reinforcement bar lapped at same level.

TO know the location of reinforcement lapping, you can search forum, there are many informative post on lapping zones of reinforcement bars for columns and beams.
 

Dnyan Deshmukh

Staff member
Thanks a lot but what do i do when the structural didn't dimension his work properly?

You can raise an RFI (Request for Information) to structural consultant who did detailing and designing of structure when there are no details about how you tie reinforcement.

For dimensions, you need to refer architectural drawing, for detailing of reinforcement bars, you need to refer structural drawing.

Before starting work you need to overlap both drawing and need to check for any variation or abnormality observed in drawing for location and sizes of structural member and accordingly need to raise RFI to both agencies to clear the differences and then work need to be executed.

For example: column on structural drawing shown in center of room which does not indicate in architectural drawing (its a common sense, such big mistake wont happen but to make sense what mistake can be, i gave simplest example).
 
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 a lot Sir God Bless you
I am Fan of your Explanation!!?
 

Sumu

Newbie
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.
Thank you for sharing such a valuable content sir...you are doing a great job sir.
 
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.

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.
Stirrups:
Assume column size 200 x 1000 mm | So Stirrup Width = 200-(2x40mm cc) = 120 mm & Length = 1000 - (2x40mm cc) = 920 mm
Would pls advice how will get the value of "a,b,c,d,e,f) also advice the value of 5 for 90 degree | Thanks in Advance
 

Attachments

  • C4M Bar Bending Schedule BBS Format..xlsx
    26 KB · Views: 130