Bar Bending Schedule Excel Sheet - A Must-Have for Civil Engineers and Contractors
Download Excel Sheet for Bar Bending Schedule
Bar bending schedule (BBS) is a document that shows the list of reinforcement bars for any structural element, such as slab, beam, column, footing, etc. It includes the mark, shape, size, location, length, and bending details of each bar. It is essential for planning, estimating, fabricating, placing, and inspecting reinforcement on any construction site.
Using an excel sheet for bar bending schedule can make your work easier and faster. You can input the data in a simple and clear format, and generate the schedule automatically. You can also export, print, or share the schedule with others. You can customize the excel sheet according to your preferences and standards.
download excel sheet for bar bending schedule
In this article, we will show you how to download excel sheet for bar bending schedule from different sources. We will also explain the basics of bar bending schedule, such as data required, guidelines and formulas, shape codes and bend deductions. We will also show you how to use the excel sheet for different structural elements and scenarios. By the end of this article, you will be able to prepare a bar bending schedule using an excel sheet easily and efficiently.
Bar Bending Schedule Basics
Before you start using an excel sheet for bar bending schedule, you need to know some basic information about bar bending schedule. Here are some of them:
Data Required for Preparing Bar Bending Schedule
To prepare a bar bending schedule, you need to have the following data:
The number of different diameters of steel bars used
The cutting length of each steel bar used
The unit weight of different diameters of steel bars
The detailed drawing with various sections of each structural element
Guidelines and Formulas to Follow for Bar Bending Schedule
To prepare a bar bending schedule, you need to follow some guidelines and formulas that are based on standards and codes. Here are some of them:
download bar bending schedule excel sheet for slab
download bar bending schedule excel sheet for footing
download bar bending schedule excel sheet for beam
download bar bending schedule excel sheet for column
download bar bending schedule excel sheet for staircase
download bar bending schedule excel sheet for retaining wall
download bar bending schedule excel sheet for circular slab
download bar bending schedule excel sheet for raft foundation
download bar bending schedule excel sheet for pile cap
download bar bending schedule excel sheet for bridge deck
download bar bending schedule excel sheet for cantilever beam
download bar bending schedule excel sheet for flat slab
download bar bending schedule excel sheet for dome
download bar bending schedule excel sheet for arch
download bar bending schedule excel sheet for lintel
download bar bending schedule excel sheet for roof truss
download bar bending schedule excel sheet for shear wall
download bar bending schedule excel sheet for culvert
download bar bending schedule excel sheet for tunnel lining
download bar bending schedule excel sheet for water tank
download bar bending schedule excel sheet with formulas free
download bar bending schedule excel sheet with optimization feature
download bar bending schedule excel sheet with shape code pop-up window
download bar bending schedule excel sheet with editable bend and hook lengths
download bar bending schedule excel sheet with editable steel grades
download bar bending schedule excel sheet with improved printing option
download bar bending schedule excel sheet with sorting and tagging function
download bar bending schedule excel sheet with delivery note generator
download bar bending schedule excel sheet with cutting length calculator
download bar bending schedule excel sheet with unit weight data
download sample bar bending schedule excel sheet free
download civiconcepts bar bending schedule excel sheet free [^1^]
download constructionfeeds bar bending schedule spreadsheet free [^2^]
download thecivilengineerings bar bending schedule step by step preparation [^3^]
how to prepare a bar bending schedule in excel sheet free tutorial [^4^]
how to read a bar bending schedule in excel sheet free guide [^5^]
how to use a bar bending schedule software in excel sheet free demo
how to check a bar bending schedule in excel sheet free tips
how to optimize a bar bending schedule in excel sheet free tricks
how to print a bar bending schedule in excel sheet free advice
benefits of using a bar bending schedule in excel sheet free article
advantages of downloading a bar bending schedule in excel sheet free blog post
disadvantages of downloading a bar bending schedule in excel sheet free review
best practices of downloading a bar bending schedule in excel sheet free ebook
mistakes to avoid when downloading a bar bending schedule in excel sheet free webinar
testimonials of downloading a bar bending schedule in excel sheet free case study
alternatives of downloading a bar bending
The concrete cover to each face of each structural element
The lap length for tension and compression bars of each structural element
The development length for dowel bars
The hook length for each bent bar
The bend deduction for each angle of bend
The crank length for each inclined bar
The extra bars length for each curved or circular bar
Shape Codes and Bend Deductions for Different Types of Bars
To prepare a bar bending schedule, you need to know the shape codes and bend deductions for different types of bars. Shape codes are numbers that represent the shape of each bent bar. Bend deductions are lengths that are subtracted from the total length of each bent bar due to bending. Here are some examples:
Shape CodeShape DescriptionBend Deduction (per 90 bend)
00Straight Bar0d
11Bottom Bar with One Bend at End1d
12Top Bar with One Bend at End2d
13Bottom Bar with Two Bends at End2d
21Stirrup with Two Bends2d
22Stirrup with Four Bends4d
23Stirrup with Six Bends6d
31Tie with Two Bends and One Hook at End10d + 2d
32Tie with Two Bends and Two Hooks at Ends20d + 4d
33Tie with Four Bends and Two Hooks at Ends20d + 8d
41Cranked Bar with One Bend at End and One Crank in Middle1d + 2d + 0.42a (a is the crank length)
42Cranked Bar with Two Bends at Ends and One Crank in Middle2d + 4d + 0.42a (a is the crank length)
51Circular Bar with One Bend at End and One Circular Bend in Middle(π/4) x d x (r/d - 1) (r is the radius of the circular bend)
52Circular Bar with Two Bends at Ends and One Circular Bend in Middle(π/4) x d x (r/d - 1) x 2 (r is the radius of the circular bend)
Note: d is the diameter of the bar.
Bar Bending Schedule Excel Sheet Features
To use an excel sheet for bar bending schedule, you need to know some of the features and functions of the excel sheet. Here are some of them:
How to Use the Excel Sheet for Bar Bending Schedule
To use the excel sheet for bar bending schedule, you need to follow these steps:
Download the excel sheet from a reliable source, such as [this one].
Open the excel sheet and enable macros if prompted.
Select the structural element that you want to prepare the bar bending schedule for, such as slab, beam, column, footing, etc.
Input the data required for the bar bending schedule, such as number of bars, diameter of bars, cutting length of bars, concrete cover, lap length, development length, hook length, etc.
Select the shape code for each bar from the drop-down list.
The excel sheet will automatically calculate the total length, weight, and cost of each bar and the total reinforcement for the structural element.
The excel sheet will also generate a graphical representation of each bar with its shape code, mark, length, and bending details.
You can also add notes or comments to each bar or structural element if needed.
You can also change the unit of measurement, currency, or decimal places if needed.
You can also insert or delete rows or columns if needed.
You can also copy or paste data from or to other excel sheets if needed.
You can also use formulas or functions to perform calculations or operations if needed.
You can also use filters or sorts to organize or analyze data if needed.
You can also use charts or graphs to visualize data if needed.
You can also use conditional formatting or data validation to highlight or restrict data if needed.
You can also use macros or VBA codes to automate tasks or customize features if needed.
You can also use pivot tables or slicers to summarize or manipulate data if needed.
How to Export, Print, or Share the Schedule
To export, print, or share the schedule, you need to follow these steps:
Select the range of cells that