Search

Bending Schedule Spreadsheet

$5.99


 

Note: Free download for all subscribers and customers of this site.

Bending schedule tool for civil and structural engineers. Very simple and easy to use spreadsheet to South Africa standard SANS 282 .
No need to spend hours making bending schedule in Excel, this spreadsheet will do the hard work for you.

Program features:
  • Shape code dropdown list
  • Shape code dialog box for easy selection
  • Bar size dropdown list
  • Automatic weight calculation
  • Automatic bar length calculation
  • Bar weight summary per sheet
  • Option to set max bar length
  • Print option to chose whether to print Active sheet or all schedules
  • Export schedule as PDF
System requirements:
  • Microsoft Windows Excel 2010 and above.
How this spreadsheet works

Once you have completed the company and project information, it is time to add your bar details on the spreadsheet.
Step 1: Select the bar type or type of steel from the dropdown list
Bending Schedule-Select bar Type
Step 2: Select the bar size from the dropdown list
Bending schedule- Select bar size
Step 3: Enter the bar mark, number of set and number per set.

Bending Schedule-Enter Bar Mark
Step 4: Select the bar shape from the dropdown list or from dialog box

Bending Schedule - Select bar shape from dropdown listBending Schedule-Select the bar shape from Form dialog
Step 5: Enter the required bending dimensions depending on the bar shape Bending Schedule-Enter bending dimensions

To download this spreadsheet, you will be required to pay a symbolic amount of $5.99 to support  Civilconstructiontools.

Payment guide to support and encourage Civilconstructiontools.

  • Pay with PayPal (default)

 Payment-Method-With-PayPal-account

  • Pay with credit or debit card (Second and third option)

Payment method with credit or debit card

Note: This spreadsheet can further be customized  to include more shape codes as per your requirements.

Short video tutorial

 

  • Version 1.0.0
  • Download 173
  • File Size 251 KB
  • File Count 2
  • Create Date February 21, 2021
  • Last Updated September 17, 2022
Bending Schedule - Master Copy.zip
Bending Schedule - Master Copy.zip
Sharing is caring:

17 thoughts on “Bending Schedule Spreadsheet”

  1. Jemaneh Wubishet

    Its very nice work and keep up!. I recommend its more better if you ADD summary of total length and weight corresponding to each bar diameter, probably put it @ the bottom of the table.
    I’d like to develop my own layout and would you mind sharing me some tricks regarding to coding bar shapes in excel vba?
    Thank you!

  2. Asking questions are really good thing if you are not understanding something fully,
    except this paragraph presents pleasant understanding yet.

  3. Hi Rodrigue,
    very handy, it makes me remember myself ten years ago starting to VBA in order to create a workbook like this one. What it puzzled me a bit about yours was that numbering of the shapes (until I saw that South Africa standard SANS 282 reference).
    I would trigger the “shapes userform” from a Worksheet_DoubleClick procedure if Target.Column = 9 (“I”) (and Target intersects data range, if you want). That way you will not lost any functionality at all, as the Dropdown already makes the DoubleClick useless (it makes it not so a normal cell to be edited), and makes more usable this app, as you’ll not force users to select cell and then click the “Bar shape” button. The “Shapes Userform” could be automatically closed whenever it losts focus or when a “shape button” is clicked.
    I don’t know if shapes are being created as groups or as isolated shapes, but that will be a feature you should implement if not, just to ease the erasing of a line.
    Kind regards

Leave a Reply

Your email address will not be published. Required fields are marked *