Bar Bending Schedule Excel Free Download
If you are a civil engineer or a contractor working on reinforced concrete structures, you must have heard of the term bar bending schedule or BBS. But what is it exactly and how can you prepare it using Excel? In this article, we will answer these questions and provide you with some examples of free BBS Excel sheets that you can download and use for your projects.
What is a bar bending schedule (BBS)?
A bar bending schedule is a document that lists the details of reinforcement bars for any structural element, such as beams, columns, slabs, footings, etc. It includes information such as the bar mark, type, size, shape, length, number, weight, and bending details of each bar. It also shows the location, spacing, and orientation of the bars in the structure.
bar bending schedule excel free download
A BBS is essential for planning, estimating, procuring, fabricating, placing, and auditing the reinforcement steel for any concrete construction work. It helps to reduce wastage, save time and cost, improve quality control, and avoid errors and mistakes at the site.
How to prepare a BBS using Excel?
Preparing a BBS using Excel is not a difficult task if you follow some simple steps. Here are the basic steps to create a BBS using Excel:
bar bending schedule software free download
bar bending schedule spreadsheet to BS 8666
bar bending schedule format in excel free download
bar bending schedule pdf free download
bar bending schedule for slab excel sheet
bar bending schedule calculation excel
bar bending schedule xls software download
bar bending schedule for footing excel sheet
bar bending schedule example excel
bar bending schedule template excel free
bar bending schedule for beam excel sheet
bar bending schedule formula excel
bar bending schedule for column excel sheet
bar bending schedule generator excel
bar bending schedule in excel as per IS code
bar bending schedule of staircase excel sheet
bar bending schedule optimization excel
bar bending schedule program in excel
bar bending schedule for retaining wall excel sheet
bar bending schedule sample excel
bar bending schedule for raft foundation excel sheet
bar bending schedule tutorial excel
bar bending schedule for circular column excel sheet
bar bending schedule video excel
bar bending schedule worksheet excel
Collect the structural drawings and specifications of the project.
Identify the different structural elements and their reinforcement details.
Create a table in Excel with columns for bar mark, type, size, shape code, length, number, weight, and bending details.
Fill in the table with the data from the drawings and specifications. Use formulas to calculate the length, weight, and bending details of each bar.
Format the table with appropriate headings, borders, colors, fonts, etc.
Add a summary sheet that shows the total weight and length of each bar size and type.
Save and print the BBS Excel sheet or export it to PDF or other formats.
Some of the advantages of using Excel to prepare a BBS are:
It is easy to use and edit.
It allows for automation and accuracy of calculations.
It provides a clear and organized presentation of data.
It enables data analysis and visualization using charts and graphs.
It facilitates data sharing and collaboration among different stakeholders.
Examples of BBS Excel sheets
There are many sources and links where you can download free BBS Excel sheets for different types of structures and standards. Here are some examples:
[Bar Bending Schedule (BBS) Excel Sheet (Sample Excel Sheet)](^1^)
This is a sample BBS Excel sheet that shows how to prepare a BBS for a slab. It includes a shape code pop-up window, an automatic calculation of minimum bend lengths, a summary sheet with total weights and lengths per each bar size, and an option to export to PDF or editable Excel file. It follows the British Standard (BS 8666:2020).
[Bar Bending Schedule Spreadsheet to BS 8666](^2^)
This is another BBS spreadsheet that follows the British Standard (BS 8666:2020). It has features such as a clear and easy to read schedule, an import or draw shape code 99 option for bars not covered by BS 8666:2020, an automatic calculation of minimum bend lengths and extra dimensions introduced in revision 2020 of BS 8666, a custom printing window, and an option to export to editable Excel file.
[Bar Bending Schedule Spreadsheet Free Download](^3^)
This is a free BBS spreadsheet that has features such as optimization, sorting, tagging, and grouping of bars, a summary sheet with total weights and lengths per each bar size, and an option to export to PDF or editable Excel file. It follows the Indian Standard (IS 2502:1963).
[Bar Bending Schedule Program in Microsoft Excel]
This is a BBS program that runs in Microsoft Excel. It has features such as a user-friendly interface, a database of standard shapes and sizes of bars, an automatic calculation of bar lengths and weights, a graphical representation of bars and bending details, a summary sheet with total weights and lengths per each bar size, and an option to export to PDF or editable Excel file. It follows the American Standard (ACI 318-14).
Conclusion
A bar bending schedule is a vital document for any reinforced concrete structure project. It helps to plan, estimate, procure, fabricate, place, and audit the reinforcement steel for the construction work. Preparing a BBS using Excel is a convenient and efficient way to create a clear and organized BBS that can be easily edited, calculated, analyzed, visualized, shared, and printed.
If you are looking for free BBS Excel sheets that you can download and use for your projects, you can check out the examples we have provided in this article. They cover different types of structures and standards and have various features and benefits that can suit your needs. You can also customize them according to your preferences and requirements.
We hope you found this article helpful and informative. If you have any questions or feedback, please feel free to leave a comment below. And if you liked this article, please share it with your friends and colleagues who might be interested in learning more about bar bending schedules.
FAQs
What is the difference between bar bending schedule and bar bending shape code?
A bar bending schedule is a document that lists the details of reinforcement bars for any structural element. A bar bending shape code is a number that represents the shape of a bar according to a standard. For example, shape code 00 means a straight bar, shape code 11 means a bar with one bend at one end, shape code 12 means a bar with one bend at both ends, etc.
How do I calculate the weight of reinforcement bars?
The weight of reinforcement bars can be calculated by multiplying the length of the bar by the unit weight of the bar. The unit weight of the bar depends on the size and type of the bar. For example, the unit weight of a 10 mm diameter mild steel bar is 0.617 kg/m, while the unit weight of a 10 mm diameter high yield steel bar is 0.785 kg/m.
How do I calculate the minimum bend length of reinforcement bars?
The minimum bend length of reinforcement bars depends on the size and type of the bar and the standard followed. For example, according to BS 8666:2020, the minimum bend length for a 10 mm diameter mild steel bar is 5d (where d is the nominal bar size), while the minimum bend length for a 10 mm diameter high yield steel bar is 7d.
What are the advantages of using Excel for preparing BBS?
Some of the advantages of using Excel for preparing BBS are:
It is easy to use and edit.
It allows for automation and accuracy of calculations.
It provides a clear and organized presentation of data.
It enables data analysis and visualization using charts and graphs.
It facilitates data sharing and collaboration among different stakeholders.
Where can I download free BBS Excel sheets?
You can download free BBS Excel sheets from various sources and links on the internet. Some examples are:
[Bar Bending Schedule (BBS) Excel Sheet (Sample Excel Sheet)]
[Bar Bending Schedule Spreadsheet to BS 8666]
[Bar Bending Schedule Spreadsheet Free Download]
[Bar Bending Schedule Program in Microsoft Excel]
44f88ac181