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:
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 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:
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 you want to export, print, or share.
To export the schedule, you can choose the file format that you want, such as PDF, CSV, TXT, XML, etc. You can also choose the location where you want to save the file.
To print the schedule, you can choose the printer that you want, and adjust the settings such as orientation, margins, scaling, headers and footers, etc. You can also preview the printout before printing.
To share the schedule, you can choose the method that you want, such as email, cloud storage, social media, etc. You can also choose the recipients and add a message if needed.
How to Customize the Excel Sheet for Different Preferences and Standards
To customize the excel sheet for different preferences and standards, you need to follow these steps:
Select the cell or range of cells that you want to customize.
To change the font style, size, color, or alignment, you can use the formatting tools on the Home tab.
To change the number format, such as decimal places, percentage, currency, etc., you can use the Number group on the Home tab.
To change the cell format, such as borders, fill color, merge cells, etc., you can use the Cells group on the Home tab.
To change the column width or row height, you can use the Format option on the Home tab or drag the column or row boundary.
To change the sheet name or color, you can right-click on the sheet tab and select Rename or Tab Color.
To change the workbook name or properties, you can click on File and select Save As or Info.
To change the page layout or print settings, you can click on Page Layout or File and select Page Setup or Print.
To change the formulas or functions used in the excel sheet, you can edit them in the formula bar or use the Function Library on the Formulas tab.
To change the macros or VBA codes used in the excel sheet, you can click on Developer and select Macros or Visual Basic.
Bar Bending Schedule Examples
To illustrate how to use an excel sheet for bar bending schedule, we will show you some examples of different structural elements and scenarios. Here are some of them:
How to Prepare Bar Bending Schedule for Slab
To prepare a bar bending schedule for slab, you need to follow these steps:
Draw a plan view of the slab with dimensions and reinforcement details.
Divide the slab into grids and label them with numbers or letters.
Count the number of bars and their diameters for each grid and direction (top or bottom).
Measure the cutting length of each bar by adding the span length, the concrete cover, the lap length, and the hook length.
Select the shape code for each bar based on its bending details.
Input the data in the excel sheet for bar bending schedule and generate the schedule.
Here is an example of a slab plan with reinforcement details:
Here is an example of an excel sheet for bar bending schedule for slab:
How to Prepare Bar Bending Schedule for Beam
To prepare a bar bending schedule for beam, you need to follow these steps:
Draw a cross-section and an elevation view of the beam with dimensions and reinforcement details.
Count the number of bars and their diameters for each section and layer (top or bottom).
Measure the cutting length of each bar by adding the span length, the concrete cover, the lap length, the development length, and the bend deduction.
Select the shape code for each bar based on its bending details.
Input the data in the excel sheet for bar bending schedule and generate the schedule.
Here is an example of a beam cross-section and elevation view with reinforcement details:
Here is an example of an excel sheet for bar bending schedule for beam:
How to Prepare Bar Bending Schedule for Column
To prepare a bar bending schedule for column, you need to follow these steps:
Draw a plan and an elevation view of the column with dimensions and reinforcement details.
Count the number of bars and their diameters for each section and layer (longitudinal or transverse).
Measure the cutting length of each longitudinal bar by adding the column height, the concrete cover, the development length, and the hook length.
Measure the cutting length of each transverse bar by multiplying the perimeter of the column section, the number of ties or stirrups, and the bend deduction.
Select the shape code for each bar based on its bending details.
Input the data in the excel sheet for bar bending schedule and generate the schedule.
Here is an example of a column plan and elevation view with reinforcement details:
Here is an example of an excel sheet for bar bending schedule for column:
How to Prepare Bar Bending Schedule for Footing
To prepare a bar bending schedule for footing, you need to follow these steps:
Draw a plan and a cross-section view of the footing with dimensions and reinforcement details.
Count the number of bars and their diameters for each section and layer (top or bottom).
Measure the cutting length of each bar by adding the footing length or width, the concrete cover, the lap length, and the hook length.
Select the shape code for each bar based on its bending details.
Input the data in the excel sheet for bar bending schedule and generate the schedule.
Here is an example of a footing plan and cross-section view with reinforcement details:
Here is an example of an excel sheet for bar bending schedule for footing:
Conclusion
In this article, we have shown you how to download excel sheet for bar bending schedule from different sources. We have also explained the basics of bar bending schedule, such as data required, guidelines and formulas, shape codes and bend deductions. We have also shown you how to use the excel sheet for different structural elements and scenarios.
Using an excel sheet for bar bending schedule can help you save time and effort, as well as improve accuracy and quality. 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.
We hope that this article has been helpful and informative for you. If you want to try out the excel sheet for bar bending schedule, you can download it from [this link]. You can also check out other useful resources and tools related to bar bending schedule on [this website].
Thank you for reading this article. If you have any questions or feedback, please feel free to leave a comment below. We would love to hear from you!
Frequently Asked Questions
Here are some of the frequently asked questions about excel sheet for bar bending schedule:
What is an Excel Sheet?
An excel sheet is a spreadsheet program that allows you to store, organize, manipulate, analyze, and present data in a tabular format. You can use formulas, functions, charts, graphs, macros, VBA codes, pivot tables, slicers, and other features to perform various tasks with data. You can also create multiple worksheets within a workbook to work with different sets of data.
What is 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.
Why Use Excel Sheet for Bar Bending Schedule?
Using an excel sheet for bar bending schedule can offer you many benefits, such as:
It can save you time and effort, as you can input the data in a simple and clear format, and generate the schedule automatically.
It can improve accuracy and quality, as you can use formulas and functions to calculate the length, weight, and cost of each bar and the total reinforcement.
It can facilitate communication and collaboration, as you can export, print, or share the schedule with others in different formats.
It can allow customization and flexibility, as you can change the unit of measurement, currency, decimal places, font style, cell format, page layout, print settings, formulas, functions, macros, VBA codes, etc. according to your preferences and standards.
How to Download Excel Sheet for Bar Bending Schedule?
To download excel sheet for bar bending schedule, you can choose from different sources that offer free or paid templates or tools. Some of the sources are:
[This website], which offers a free excel sheet for bar bending schedule that covers different structural elements and scenarios. It also provides a video tutorial on how to use the excel sheet.
[This website], which offers a paid excel sheet for bar bending schedule that covers different structural elements and scenarios. It also provides a user manual and technical support on how to use the excel sheet.
[This website], which offers a free online tool for bar bending schedule that covers different structural elements and scenarios. It also allows you to export or print the schedule in PDF or CSV format.
How to Check and Verify the Accuracy and Quality of the Schedule?
To check and verify the accuracy and quality of the schedule, you need to follow these steps:
Compare the data in the excel sheet with the data in the drawing and make sure they are consistent and correct.
Check the formulas and functions used in the excel sheet and make sure they are valid and error-free.
Check the shape codes and bend deductions used in the excel sheet and make sure they are appropriate and accurate.
Check the total length, weight, and cost of each bar and the total reinforcement and make sure they are reasonable and realistic.
Check the graphical representation of each bar and make sure it matches with its shape code, mark, length, and bending details.
Check the notes or comments added to each bar or structural element and make sure they are clear and relevant.
44f88ac181
Comments