top of page

Market Research Group

Public·36 members

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


About

Welcome to the group! You can connect with other members, ge...
Group Page: Groups_SingleGroup
bottom of page