Bar Bending Schedule Spreadsheet to IS 2502: 1999
(Indian Standard)
English version
Hebrew version
IS2502 Shapes
BS8666 Shapes
Additional Shapes
General options
Optimized BBS
Generated tags
Delivery note
Sorted BBS
Rebar weights
Project data
Sorting order
Stock lengths and weights
Editable bends and hooks
Printing options
|
Essential tool for everyone who is involved in detailing reinforcement in accordance with Indian Standard. Whether you are a designer, detailer, contractor or a manufacturer/supplier this spreadsheet will help you save a lot of time when preparing bar lists (bar schedules).
Includes rebar sorting and rebar optimization. Also it is possible to generate rebar tags and a delivery note. This spreadsheet is characterised by it's simple and user friendly interface that allows quick input of information in a clear format. It also includes a shape code pop-up window to speed up input process. Above video shows the bar input process in action. There are multiple features that make the spreadsheet easily adjustable to user's requirements. For example: steel grades, bend and hook lengths are fully editable to suit user's bending method (machine or manual bending) and to allow user to adjust the spreadsheet to materials that s/he uses. Sorting and optimization are based on four (user-defined) levels of priority, and for example user may choose to sort by material-diameter-length-bar mark or by material-weight-length or by any other order. Furthermore, the spreadsheet allows user to change bar stock length per bar diameter to reflect what is currently available in stock; or to change weight limits for grouping rebar and assigning individual tags. - Optimization uses a very advanced algorithm to ensure that minimum waste and off cuts are achieved to make the cutting as economical as possible. Optimized sheet shows bar lengths to be cut, and associated bar marks. This makes it very easy to reference between optimized cut lengths and how each length should be bent; - Sorting and optimization is done based on user-defined order, so gives full control over sorted bar list; - Tags are clear and easy to read. This will ensure a good communication between parties, from production, through delivery to site, to installation; - Delivery note gives a summary of all rebar delivered to site. This makes it easy to check whether everything was delivered as required; TECHNICAL ADVICE: if bar shape diagrams are offset on your computer then in the spreadsheet click 'Actions and Settings' button in the top-right corner, then click 'Settings' button and at the bottom you have two boxes to adjust diagrams' locations. Try different values (typically +/- 1-50) to find the correct offset. This spreadsheet covers a wide range of bar shapes, from IS to BS shapes, as well as other shapes.
This video covers the following subjects (in order):
1. adding new sheet; 2. using 'clear sheet' button to clear all data on a sheet; 3. inserting new bars and using shape code pop-up quick selection window; 4. look at customizable settings like hook and bend lengths etc; 5. sorting bars from all sheets by user-specified sorting order; 6. optimizing bars for cutting; 7. generating tags; 8. generating a delivery note; 9. custom printing where user can specify which sheets to print and on which printer. Please note that this video is based on spreadsheet version 3.1 and not all features of the current version 3.2 are shown. Especially the extra bar shapes are not covered.
- English version - for use in India;
- Hebrew ( עִבְרִית ) version - for use in Israel; Contact me if you require this spreadsheet in a different language.
- A clear and easy to read schedule;
- Very fast input of bars and bend lengths (bar shape diagrams are shown instantaneously); - Bar shape diagrams automatically shown based on bar shape code; - Bar dimensions shown on bar shape diagrams; - Window pop-up with shape codes for easier use (can be disabled); - Optimisation, tagging, sorting, delivery note; - Four user-defined priority levels for sorting; - Optimized sheet gives cut lengths and associated bar marks; - Editable stock bar lengths per bar diameter; - Editable maximum rebar group weight per each tag; - Editable steel grades. By default the following are selected: fe415, fe500, fe550; - Editable bend and hook lengths; - 109 bar shapes (32 from IS 2502, 34 from BS 8666, plus 43 additional bar shapes); - Automatically inputs minimum hook and bend allowances - steel grade dependant; - Highlights lengths that have to be entered - bar shape code dependant; - Gives total weights and lengths per each bar size - on a separate summary sheet; - Compatible with older versions of Excel, like Excel 2007; - Schedule in accordance with Indian Standard (IS 2502: 1999). (Note: macros must be unblocked for the spreadsheet to function properly. Follow instructions in this guide)
If you require an additional bar shape to be added to the spreadsheet then please contact me before purchase.
|
To run the Single-User or the Company Licensed version of this spreadsheet you require:
- Microsoft Windows Excel version 2007 and above; Contact me if you want to use this spreadsheet on MAC. |
| Download Section: |
|
FREE Lite version: Bar Bending Schedule (3.3).
The restriction in this free lite version is that you can not change the company name nor the logo (shown in top left corner) - currently set to a made up company. Also input of bar mark designation is not possible, and number of bars is present to 1. Hebrew version is 3.2. Contact YourSpreadsheets if you would like to test out the latest version of this spreadsheet in Hebrew. |
English Version
Hebrew Version
|
|
FULL version: Bar Bending Schedule (3.3).
(English and Hebrew versions) Single-User or Company License, which one is the best for me? Fully working version where you change the company information and logo in the top left corner. Also you can input bar mark designation and schedule number of bars. By purchasing this spreadsheet you agree to the disclaimer and terms & conditions. Two types of licenses are available for this spreadsheet. The single-user license is offered for a nominal price of £20 - a great product that you can have for a great value. Note: English and Hebrew version of the spreadsheet use the same Activation Key (only one purchase is required to use both versions). Information for Customers living in India: to purchase a license you must be a business (i.e. B2B sale) and reverse charge mechanism will apply. Purchases by individuals unfortunately will not be accepted (i.e. B2C sales). After purchase fill in this Activation Key Request Form. |
|