top of page  Public·6 members

# Bar Bending Schedule Excel Sheet - How to Use BBS Software for Faster and Accurate Reinforcement Calculation

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.

### 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."

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:

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 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

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

• 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 :

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:

• 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 accordin