Download Bar Bending Schedule Excel Sheet
If you are looking for a simple and effective way to prepare and manage the bar bending schedule (BBS) for your reinforced concrete structures, then you have come to the right place. In this article, we will explain what is BBS, how to prepare it, and how to use a free BBS excel sheet that you can download from the link below.
What is Bar Bending Schedule (BBS)?
Bar bending schedule, or BBS, is a list of reinforcement bars for any structural element that gives the mark, type, size, location, length, number, and bending details of each bar or fabric. It is a tabular representation of each reinforcement bar used in reinforced concrete work. It is also called scheduling.
download bar bending schedule excel sheet
Download File: https://jinyurl.com/2vxsvi
Definition of BBS
According to , "Bar bending schedule is a document showing the list of structural members, bar mark, type of reinforcement, size of rebar, number of rebars for each member, cutting length, total length, shape, and location/spacing/position of all reinforcements in the working drawing."
Advantages of BBS
According to , some of the advantages of BBS in construction are:
It provides better estimation of reinforcement used in each structural concrete member.
It helps engineer in the procurement of reinforcement steel and better stock management.
It provides exact estimated quantity required and reduces wastage of steel.
It improves the quality control at the site as reinforcement is provided as per BBS.
It makes cutting and bending of reinforcement easy at a factory and can be directly transported to the site.
It helps in auditing reinforcement and provides a check on theft.
It helps in the fast preparation of bills for construction works.
How to Prepare BBS?
To prepare a bar bending schedule, you need to have some data and follow some steps. You also need to know some formulas and rules for calculating the length and weight of bars.
Data Required for BBS
According to , the data required for preparing BBS are:
Nos. of different dia of steel used.
Cutting length of each steel used.
Unit weight of different dia. of steel.
Details drawing with various sections.
Steps for BBS Calculation
According to , the steps for preparing BBS are:
Identification of members (steel bars) from the structural drawing.
Counting the number of bars for each member and noting down their mark, type, size, location, etc.
Finding the cutting length of each bar using standard formulas and rules.
Finding the total length and weight of each bar by multiplying the cutting length by the number of bars and unit weight respectively.
Finding the total length and weight of all bars by adding up the values from step 4.
BBS Formulas and Rules
The following are some common formulas and rules for calculating the cutting length and bend deduction of bars according to :
How to download bar bending schedule excel sheet for free
Download bar bending schedule excel sheet sample for slab
Download bar bending schedule excel sheet format as per Indian standard
Download bar bending schedule excel sheet with formulas and calculations
Download bar bending schedule excel sheet for footing and column
Download bar bending schedule excel sheet for beam and lintel
Download bar bending schedule excel sheet for staircase and landing
Download bar bending schedule excel sheet for retaining wall and foundation
Download bar bending schedule excel sheet for circular and curved structures
Download bar bending schedule excel sheet for reinforcement detailing and estimation
Benefits of download bar bending schedule excel sheet for construction project
Steps to download bar bending schedule excel sheet from online sources
Download bar bending schedule excel sheet software and tools
Download bar bending schedule excel sheet pdf and convert to xls
Download bar bending schedule excel sheet template and customize
Tips to download bar bending schedule excel sheet for accurate results
Download bar bending schedule excel sheet tutorial and guide
Download bar bending schedule excel sheet best practices and standards
Download bar bending schedule excel sheet examples and case studies
Download bar bending schedule excel sheet checklist and quality control
Download bar bending schedule excel sheet for different types of steel bars
Download bar bending schedule excel sheet for different types of concrete elements
Download bar bending schedule excel sheet for different types of loads and stresses
Download bar bending schedule excel sheet for different types of design codes and specifications
Download bar bending schedule excel sheet for different types of units and measurements
Download bar bending schedule excel sheet for different types of shapes and bends
Download bar bending schedule excel sheet for different types of cutting and splicing methods
Download bar bending schedule excel sheet for different types of wastage and optimization techniques
Download bar bending schedule excel sheet for different types of cost and budget analysis
Download bar bending schedule excel sheet for different types of billing and payment methods
Compare download bar bending schedule excel sheet with other formats and methods
Review download bar bending schedule excel sheet by experts and professionals
Test download bar bending schedule excel sheet by users and clients
Update download bar bending schedule excel sheet by latest changes and developments
Troubleshoot download bar bending schedule excel sheet by common errors and issues
Learn download bar bending schedule excel sheet by online courses and videos
Teach download bar bending schedule excel sheet by training programs and workshops
Share download bar bending schedule excel sheet by social media and blogs
Recommend download bar bending schedule excel sheet by ratings and reviews
Improve download bar bending schedule excel sheet by feedback and suggestions
Weight of bar (kg = Length of bar (m) x No. of bars x Unit weight of bar (kg/m)
Cutting length of straight bar = Clear span + Development length Bend deduction
Unit weight of bar (kg/m) = (D/162.2) x Density of steel (7850 kg/m)
Cutting length of bent up bar = Straight length + Bent up length Bend deduction
Development length (Ld) = (diameter of bar x characteristic strength of steel) / (4 x bond stress)
Bent up length = Height of bent up bar x Sin(θ)
Bond stress = Permissible bond stress for plain bars or deformed bars as per IS code
Bend deduction = 2 x (diameter of bar) x No. of bends
For more details and examples, you can refer to the sources mentioned above.
How to Use BBS Excel Sheet?
Now that you have learned how to prepare BBS, you might be wondering how to use a BBS excel sheet to make your work easier and faster. A BBS excel sheet is a spreadsheet that contains all the data and formulas for calculating the BBS for various structural elements. You can download a free BBS excel sheet from . Here are some features and instructions for using it.
Features of BBS Excel Sheet
The BBS excel sheet has the following features:
It covers different types of structural elements such as beams, columns, slabs, footings, etc.
It has separate sheets for each element with predefined data and formulas.
It allows you to enter the dimensions, reinforcement details, and other parameters for each element.
It automatically calculates the cutting length, total length, weight, and cost of each bar and element.
It generates a summary sheet that shows the total quantity and cost of reinforcement for the whole project.
It is easy to use, edit, and customize as per your requirements.
Instructions for Using BBS Excel Sheet
The following are some general instructions for using the BBS excel sheet:
Download the BBS excel sheet from and save it on your computer.
Open the BBS excel sheet and enable macros if prompted.
Select the sheet that corresponds to the structural element you want to calculate the BBS for.
Enter the dimensions, reinforcement details, and other parameters for the element in the yellow cells. Do not change the values in the green cells as they contain formulas.
The BBS excel sheet will automatically calculate the cutting length, total length, weight, and cost of each bar and element in the green cells.
You can change the unit weight, unit cost, development length, bond stress, and other constants in the constants sheet if needed.
You can also add or delete rows or columns as per your needs. Just make sure to copy and paste the formulas accordingly.
You can view the summary sheet that shows the total quantity and cost of reinforcement for the whole project.
You can print or save the BBS excel sheet as a PDF file for future reference.
Conclusion
In this article, we have explained what is BBS, how to prepare it, and how to use a free BBS excel sheet that you can download from . We hope that this article has helped you understand the importance and benefits of B BS in construction and how to use a simple and effective tool to calculate it. If you have any questions or feedback, please feel free to leave a comment below. Thank you for reading and happy engineering!
FAQs
Here are some frequently asked questions about BBS and BBS excel sheet:
What is the difference between BBS and bar schedule?
BBS and bar schedule are two terms that are often used interchangeably, but they have some differences. BBS is a list of reinforcement bars for any structural element that gives the mark, type, size, location, length, number, and bending details of each bar or fabric. Bar schedule is a list of reinforcement bars for the whole project that gives the mark, type, size, number, length, and weight of each bar or fabric.
What are the units used in BBS?
The units used in BBS depend on the system of measurement used in the project. The most common units are millimeters (mm) for diameter and length, kilograms (kg) for weight, and rupees (Rs) for cost. However, you can also use other units such as meters (m), tons (t), dollars ($), etc. as per your preference.
How to convert BBS excel sheet to PDF?
To convert BBS excel sheet to PDF, you can follow these steps:
Open the BBS excel sheet and select the sheet or range that you want to convert.
Click on File > Save As > Browse and choose a location to save the file.
In the Save As dialog box, select PDF from the Save as type drop-down list.
Click on Options and choose the settings that you want for the PDF file.
Click on Save to create the PDF file.
How to edit BBS excel sheet?
To edit BBS excel sheet, you can follow these steps:
Open the BBS excel sheet and select the sheet or cell that you want to edit.
Make the changes that you want in the yellow cells. Do not change the values in the green cells as they contain formulas.
If you want to add or delete rows or columns, right-click on the row or column header and choose Insert or Delete from the menu.
If you want to copy and paste formulas, select the cell with the formula and drag it to the destination cell or range.
If you want to change the unit weight, unit cost, development length, bond stress, and other constants, go to the constants sheet and enter the new values in the yellow cells.
How to download BBS excel sheet?
To download BBS excel sheet, you can follow these steps:
Go to and find the BBS excel sheet under Civil Engineering Spreadsheets category.
Click on Download Now button and enter your name and email address.
You will receive an email with a link to download the BBS excel sheet.
Click on the link and save the file on your computer.
44f88ac181
Comments