Download Bar Bending Schedule Excel Sheet

0 views

Skip to first unread message

Message has been deleted

Vannina Keasley

unread,

Jul 11, 2024, 11:31:54 AM7/11/24

to gotatama

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 https://shoxet.com/2yNLfG

Definition of BBS

According to About Civil, "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 Civil Lead, 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 Civil Planets, 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 Structville, 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 Civil Planets:

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 (L_d) = (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 Civil Engineering Downloads. 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 Civil Engineering Downloads 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 Civil Engineering Downloads. 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 Civil Engineering Downloads and find the BBS excel sheet under Civil Engineering Spreadsheets category.