Re-bar Schedule
 

This Excel calculation can be downloaded by ExcelCalcs subscribers.Please login or Subscribe.

Description:
Calculation Preview



This file calculate the cut-length of reinforcing bars of different bar sizes and shapes. It takes into account the effects of bending and rolling and compute the total lengths per bar size for material take-off purpose. The file includes a shape table and a sample showing how the re-bar list looks like when filled with data.
A) Purpose
"The purpose of this file is to populate the reinforcing bar list required for a project, and where, from given re-bar sizes and shapes, the cut-to-lengths are determined as well as the lenghts and weights, by re-bar sizes, are computed for material take-off. The cut-to-lengths are taking into account the bending and rolling radii as well as the streching effects on the steel of bending and rolling. The standard hooks and bends are automatically added, when applicable."
B) Calculation Tables
Hereunder are the images of the tables which served as the basis for the re-bar calculation. These tables are hidden and cannot be displayed. The tables are extracted from the CAC Concrete Design Handbook, Third Edition.
C) Programs / Macros
Various VBA macros are used for the selection of the re-bar sizes and shapes as well as for entering the dimensions and for displaying various warning or calculation messages. To activate the macros, there are the following buttons to click, and of which their particularities are explained hereunder. 
C1) Steps 1 to 5 - Entering the re-bar size, shape and dimensions
When clicking on this button, a window is displayed asking you to select a bar size. Once done, a second window is displayed to ask you to select a shape size number. The available shapes are illustrated on the Shape Table & Images tab. Then a series of windows are displayed prompting you for the necessary dimensions to perform the calculations. The dimension windows are tailored to the specific re-bar shape calculated. Once all the dimensions are entered, the remaining (calculated) dimensions are automatically added in the table as well as the cut-to-length (rounded to the next 5 mm) and the total weights and lengths. IT IS IMPORTANT THAT THE QUANTITIES (in the blue column) BE ENTERED for the computations of the lengths and weights be exact on the right side of the table and on the summary table at the bottom of the page.
C2) Step 5Bis - Changing manually one or several dimensions on a re-bar already calculated
This button is set for a manual change of one or several dimensions on a re-bar which has been already calculated. This is to avoid recalculating the re-bar again, but more importantly, avoiding the superposition of two images of the re-bar shape in the column H of the table. The process is to change the dimensions first and to click on the button for the finalization of the calculation.
C3) Step 5Bis - Changing manually the re-bar size on a re-bar already calculated
This button is set for a manual change the re-bar size on a re-bar which has been already calculated. This is to avoid recalculating the re-bar again, but more importantly, avoiding the superposition of two images of the re-bar shape in the column H of the table. The process is to click on the button and to select the new re-bar size from the displayed window. Then the calculation with the different re-bar, but the same shape and dimensions are finalized.
C4) Replacing the formulae by their values
This button is set for the replacement of the formulae in the table by their values. This is foreseen for transferring the file to a third party, or for any other reasons where we want to disconnect the results from the hidden calculation tables; a sort of PDF version. Since that it is a risky procedure, two (2) warnings windows pop up asking you to confirm the action.
C5) Inserting a line in the table
This button is set for inserting a line underneath the one where the pointer is. This action will make sure that all the formulae are copied as well in the new line. If the pointer is on the last line, a warning window will prompt you to shift the pointer up by at least one row and the inserting action is NOT done. The reason is that adding a line under the last one would jump outside of the pre-determined range and the total computation at the bottom of the page would not take these outside line in consideration.
C6) Deleting a line in a table
This button is set for deleting a line where the pointer is. The macro makes sure that the line to be deleted is within the pre-determined range. A warning window asks you for your confirmation. If the line to be deleted is the one in which a re-bar shape as been calculated, then the re-bar image has to be deleted manually. There is no other consequence.
C7) Screen display
This button is set for changing the size ratio of the screen display for the Re-bar List sheet only. By default, the sheet is set to display columns A to AB, but you can override this ratio for another one of your choice.

Calculation Reference
Re-bar Schedule
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Reinforced Concrete Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |
Structural Design
| Find on Amazon.com | Find on Amazon.co.uk | Find on Amazon.fr | Find on Amazon.de | Find on Amazon.ca |

Version History
Subscribe to this topic and get notified by mail about new posts Favorite to this topic Discuss this item in the forum. Check the version history to see how this calculation has changed over time. Use the Subscribe button to receive an automatic email should this calculation be updated to a higher version. Use the Favourite button so you can easily find this calculation in the future.

Submitted On:
12 Sep 2017
Submitted By:
PtitNounours
File Date:
12 Sep 2017
File Author:
Bernard Barnéoud
File Version:
2.0
File Size:
1,206.48 Kb
File Type:
xlsm
Downloads:
38
Rating:
stars/0.gifTotal Votes:0
HTML Link:
Copy code below to your web page to create link to this page:
HTML Window:
Copy code below to your web page to create a dynamic window to this download:
Like This?:
View the profile of the person who submitted this calculation and see all their other calculations hosted at ExcelCalcs.
Need Help?:
Use the comment feature below to raise any questions relating to this download. The question will be automatically emailed the author and all users subscribing to this comment thread.

Comments  

 
#2 JohnDoyle[Admin] 2017-09-12 19:32
Thank you for your update Bernard. I think you may have encountered some difficulties as the file name included "," which is not a URL friendly character for us. It may be useful to refer to our instructions on upgrading calculations in the future Thank you for your support once again.
 
 
#1 JohnDoyle[Admin] 2017-08-03 06:54
Another utility spreadsheet your free lifetime XLC Pro subscription is assured.
 

Please sign in or register to add a comment.

We have 13 guests and 35 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative