From Taking Off To Billing

The process of preparing a BQ from taking off done using Excel spreadsheet

1. In the taking off list tab, copy all the items and paste it to a new sheet.

2. Name the new sheet as BQ

3. In the BQ sheet, arrange all the items, and description in accordance with the final arrangement of the BQ. The sequence should follow SMM arrangement of descriptions, from dimensions to smaller dimensions if there are many of the items appeared.

4. Format the BQ to show the layout. To help prepare this task, change the spreadsheet to layout mode.

5. Format the header and footer

6. Link the quantities for each item to the take off quantities.

7. Preview the output

8. After all correction done, the BQ can be printed for tender docment preparation.

For the rates preparation,

Create another sheet for built up rate computation. Name the sheet as BURate.

Create a sheet for material price list

Create a sheet for Labour price list

Create a sheet for Machine and equipment list

The format for each of the sheet should include:

Item, Description, Quantity, Unit and Rate.

ALL THE ABOVE WILL BE PRESENTED IN CLASS.

Bar Bending Schedule Software

This software can be accessed from this website.

In this program, all calculations are done automatically, besides it generates a real dimensional shape of the bar. Dimensions demonstrated in the shapes are linked to bar bending data. Any changes in the bar bending data will be reflected in the cutting length, weight of steel and dimension within the demonstrated shape picture.

More than 480 shape codes are used in this program to identify different bend profiles.
Any shape code can be easily found through popup window in the program. So, the Bar Bending Scheduler doesn’t have to worry about remembering shape codes. A Civil Engineer who has a minimum knowledge of MS Excel can handle this program without any training.
All the shape codes used in this program are made exclusively for this program and are not complying with any standard shape codes.

Limitations of Program
1) This program doesn’t have any interface with software like CAD. So, program can't assign BBS directly from computer aided drawings.
2) User cannot add new shape code in addition to the built in shape codes.

You may download the software from the website or from here.

FOLLOW THE INSTRUCTIONS GIVEN TO USE THE SOFTWARE.