Bar Bending Schedule to IS 2502 Spreadsheet – main features

This video shows main features of BBS to IS 2502 spreadsheet which can be downloaded from https://www.yourspreadsheets.co.uk/bar-bending-schedule-to-is-2502.html

SUBJECTS COVERED IN THE VIDEO:

- adding new sheet;
- using ‘clear sheet’ button to clear all data on a sheet;
- inserting new bars and using shape code pop-up quick selection window;
- look at the customizable settings like hook and bend lengths etc;
- sorting bars from all sheets by user specified sorting order;
- optimizing bars for cutting;
- generating tags;
- generating a delivery note;
- custom printing where user can specify which sheets to print and on which printer.

SPREADSHEET DESCRIPTION:

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 and when sorting, optimizing, tagging etc rebar.

This spreadsheet is characterised by its 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 Flash 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 use. 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;

This spreadsheet covers a wide range of bar shapes, from IS to BS