Guide to Bar Bending Schedule Program in Microsoft Excel
Introduction
A bar bending schedule is a detailed document that outlines the reinforcement requirements for a concrete structure. It is an essential tool for construction professionals, including engineers, architects, and contractors. In this guide, we will explore how to create a bar bending schedule program in Microsoft Excel.
What is a Bar Bending Schedule?
A bar bending schedule is a table that lists the reinforcement bars required for a concrete structure, including their shape, size, and quantity. It helps to ensure that the correct amount and type of reinforcement are used in the construction process.
Benefits of Using Microsoft Excel for Bar Bending Schedule
Microsoft Excel is a popular software for creating bar bending schedules due to its flexibility and ease of use. Some benefits of using Excel include: bar bending schedule program in microsoft excel crack
Creating a Bar Bending Schedule Program in Microsoft Excel
To create a bar bending schedule program in Excel, follow these steps:
Enter Data: Starting from row 2, enter the details of each bar type. Guide to Bar Bending Schedule Program in Microsoft
Total Weight: To calculate the total weight, you need the weight per meter of each bar size. This can be looked up or calculated if you know the diameter and density of steel (approximately 7850 kg/m³ for steel). The formula for the weight of a steel bar per meter is:
For simplicity, use known weights per meter for common bar sizes:
Then, calculate the total weight:
Drag Down Formulas: Drag the formulas down to apply them to all rows of data.