Complete Bar Bending Schedule Excel Sheet Free Download
If you are a civil engineer, a contractor, or a site supervisor, you might have heard of the term Bar Bending Schedule or BBS. But what is it exactly and how can it help you in your construction project? In this article, we will explain what is BBS, how to prepare it, and where to download a free BBS excel sheet that you can use for your work.
complete bar bending schedule excel sheet free download
What is Bar Bending Schedule (BBS)?
Definition and purpose of BBS
A Bar Bending Schedule is a detailed list of bent reinforcement bars given in any structural concrete element. It contains information such as bar mark, diameter, length, shape, and weight. It is based on the structural drawing given by the structural engineer for various structural elements like footing, column, beam, slab, etc.
The purpose of BBS is to provide a clear and accurate description of the reinforcement bars used in the concrete structure. It helps in estimating the required quantities of different diameters of bars, cutting and bending them into desired shapes, transporting them to the site, and placing them in the correct position. It also helps in checking and verifying the reinforcement work done by the contractor and billing them accordingly.
Advantages of BBS in construction
Some of the advantages of using BBS in construction are:
It provides better estimation of reinforcement used in each structural concrete member. You can also calculate the overall reinforcement required for the construction project.
It helps in procurement of reinforcement steel and better stock management. You can avoid wastage and excess inventory by ordering only the required amount of steel.
It makes cutting and bending of reinforcement easy at a factory and can be directly transported to the site. This will not only reduce the wastage of reinforcement steel but also help in reducing labor cost and time.
It helps in quality control and inspection of reinforcement work. You can easily compare the actual work done with the BBS data and identify any errors or deviations.
It makes billing and payment easy and fast. You can use the BBS data to calculate the exact amount of steel used and pay accordingly.
How to Prepare Bar Bending Schedule (BBS)?
Step 1: Identification of members (steel bars)
The first step in preparing BBS is to identify the different types of steel bars or members used in the structural drawing. Each type of bar is usually tagged with a number or bar mark in the drawing. For example, #5, #6, #9, etc. You also need to note down the diameter of each bar. For example, #5@12" means a bar with number 5 and diameter 12 mm.
Step 2: Count the number of bars
The next step is to count the number of each type of bar used in each structural element. For example, if you are preparing BBS for a slab, you need to count how many bars are used along the length and width of the slab. You also need to check the spacing between bars (center to center or c/c) given in the drawing. For example, if the spacing is 150 mm c/c, it means there are 6 bars per meter.
Step 3: Calculate the cutting length of bars
The cutting length of a bar is the actual length of the bar after bending it into a desired shape The cutting length of a bar is the actual length of the bar after bending it into a desired shape. It is different from the development length or the theoretical length of the bar. To calculate the cutting length of a bar, you need to apply some standard formulas depending on the shape and bend of the bar. For example, for a 90-degree bend, the formula is L = A + B - K, where L is the cutting length, A and B are the clear lengths of the bar, and K is the deduction for the bend. You can find the value of K in standard tables or charts based on the diameter and angle of the bend.
Step 4: Calculate the weight of bars
The weight of a bar is the product of its density, cross-sectional area, and length. The density of steel is 7850 kg/m3. The cross-sectional area of a bar is calculated by using the formula A = pi * d2 / 4, where A is the area and d is the diameter. The length of a bar is the cutting length calculated in step 3. Therefore, the weight of a bar can be calculated by using the formula W = D * A * L, where W is the weight, D is the density, A is the area, and L is the length.
Step 5: Fill the BBS excel sheet
The final step is to fill the BBS excel sheet with all the information collected in steps 1 to 4. The BBS excel sheet usually has columns for bar mark, diameter, number, shape, cutting length, weight, total weight, and remarks. You need to enter the data for each type of bar used in each structural element. You also need to calculate the total weight of bars for each element and for the whole project.
Where to Download Bar Bending Schedule Excel Sheet?
Features of BBS excel sheet
A good BBS excel sheet should have the following features:
Bar bending schedule (BBS) excel sheet (sample excel sheet) - Civiconcepts
Bar bending schedule (BBS) BBS step by step preparation Excel sheet - The Civil Engineerings
Bar bending schedule (BBS) BBS step by step preparation Sample excel sheet - Civil Digital
How to prepare bar bending schedule (BBS) in excel sheet - YouTube
Bar bending schedule (BBS) for steel in excel sheet - Civil Engineering Notes
Bar bending schedule (BBS) formulas and reinforcement calculation excel sheet - Civil Engineering Blog
Bar bending schedule (BBS) for slab in excel sheet - Civil Engineering Portal
Bar bending schedule (BBS) for footing in excel sheet - Civil Engineering Projects
Bar bending schedule (BBS) format Indian standard in excel sheet - Civil Engineering Forum
Bar bending schedule (BBS) software free download for excel sheet - Civil Engineering Software
Bar bending schedule (BBS) pdf free download with excel sheet - Civil Engineering Books
Bar bending schedule (BBS) for column in excel sheet - Civil Engineering Design
Bar bending schedule (BBS) for beam in excel sheet - Civil Engineering Construction
Bar bending schedule (BBS) calculation in excel sheet - Civil Engineering Calculators
Bar bending schedule (BBS) example in excel sheet - Civil Engineering Examples
Bar bending schedule (BBS) of RCC structure in excel sheet - Civil Engineering Structures
Bar bending schedule (BBS) of staircase in excel sheet - Civil Engineering Stairs
Bar bending schedule (BBS) of retaining wall in excel sheet - Civil Engineering Walls
Bar bending schedule (BBS) of circular slab in excel sheet - Civil Engineering Slabs
Bar bending schedule (BBS) of pile foundation in excel sheet - Civil Engineering Foundations
Bar bending schedule (BBS) of cantilever beam in excel sheet - Civil Engineering Beams
Bar bending schedule (BBS) of flat slab in excel sheet - Civil Engineering Flat Slabs
Bar bending schedule (BBS) of raft foundation in excel sheet - Civil Engineering Rafts
Bar bending schedule (BBS) of lintel in excel sheet - Civil Engineering Lintels
Bar bending schedule (BBS) of isolated footing in excel sheet - Civil Engineering Footings
Bar bending schedule (BBS) of one way slab in excel sheet - Civil Engineering One Way Slabs
Bar bending schedule (BBS) of two way slab in excel sheet - Civil Engineering Two Way Slabs
Bar bending schedule (BBS) of continuous beam in excel sheet - Civil Engineering Continuous Beams
Bar bending schedule (BBS) of simply supported beam in excel sheet - Civil Engineering Simply Supported Beams
Bar bending schedule (BBS) of fixed beam in excel sheet - Civil Engineering Fixed Beams
Bar bending schedule (BBS) of T beam in excel sheet - Civil Engineering T Beams
Bar bending schedule (BBS) of L beam in excel sheet - Civil Engineering L Beams
Bar bending schedule (BBS) of inverted beam in excel sheet - Civil Engineering Inverted Beams
Bar bending schedule (BBS) of dog legged staircase in excel sheet - Civil Engineering Dog Legged Stairs
Bar bending schedule (BBS) of open well staircase in excel sheet - Civil Engineering Open Well Stairs
Bar bending schedule (BBS) of box culvert in excel sheet - Civil Engineering Culverts
Bar bending schedule (BBS) of bridge deck slab in excel sheet - Civil Engineering Bridges
Bar bending schedule (BBS) of water tank in excel sheet - Civil Engineering Tanks
Bar bending schedule (BBS) of dome roof slab in excel sheet - Civil Engineering Roofs
Bar bending schedule (BBS) of arch bridge in excel sheet - Civil Engineering Arches
Bar bending schedule (BBS) of portal frame in excel sheet - Civil Engineering Frames
Bar bending schedule (BBS) of truss bridge in excel sheet - Civil Engineering Trusses
Bar bending schedule (BBS) of shell roof slab in excel sheet - Civil Engineering Shells
It should be easy to use and edit.
It should have formulas and functions to calculate cutting length and weight automatically.
It should have charts and graphs to visualize the data and compare different elements.
It should have options to print and export the data in different formats.
It should have validation and error checking features to avoid mistakes and discrepancies.
Sources of BBS excel sheet
There are many sources where you can download a free BBS excel sheet for your construction project. Some of them are:
: This website provides a free BBS excel sheet that can be used for any type of structural element. It also has a video tutorial on how to use it.
: This website provides a free BBS excel sheet that can be used for beams, columns, slabs, and footings. It also has a guide on how to prepare BBS manually.
: This website provides a free BBS excel sheet that can be used for any type of structural element. It also has a forum where you can ask questions and get answers from experts.
Conclusion
A Bar Bending Schedule is an essential tool for any construction project that involves reinforced concrete structures. It helps in estimating, procuring, cutting, bending, placing, inspecting, billing, and paying for reinforcement steel bars. It also helps in improving quality, efficiency, accuracy, and safety in construction work. To prepare a BBS, you need to follow some simple steps and use some standard formulas. You can also use a free BBS excel sheet that can make your work easier and faster.
FAQs
What are the units used in BBS?
The units used in BBS are usually millimeters (mm) for diameter and length, kilograms (kg) for weight, and meters (m) for spacing.
What are the types of bends in reinforcement bars?
The types of bends in reinforcement bars are usually 90-degree bend, 135-degree bend, U-bend or stirrup, L-bend or hook, Z-bend or crank, etc.
What are the factors that affect the cutting length of bars?
The factors that affect the cutting length of bars are clear cover (the distance between reinforcement bars and concrete surface), development length (the extra length of bars provided at joints or supports), lap length (the overlapping length of two bars), bend deduction (the reduction in length The factors that affect the cutting length of bars are clear cover (the distance between reinforcement bars and concrete surface), development length (the extra length of bars provided at joints or supports), lap length (the overlapping length of two bars), bend deduction (the reduction in length due to bending), and wastage (the loss of material due to cutting, transportation, etc.).
What are the tools used for cutting and bending reinforcement bars?
The tools used for cutting and bending reinforcement bars are usually manual or electric cutters, benders, shears, pliers, etc. You can also use machines or robots for automated cutting and bending.
What are the codes and standards followed for BBS?
The codes and standards followed for BBS vary depending on the country and region. Some of the common codes and standards are IS 2502:1963 (Indian Standard), BS 8666:2005 (British Standard), ACI 315-99 (American Concrete Institute), etc.
44f88ac181
Comments