Parametric BOQ calculator for isolated sloped footings, excavation, binding and neck column
We present a worksheet to generate bill of quantities for isolated sloped footings with neck columns and associated works, with a minimum input about the footing and column geometry. The bill of quantities (BOQ) would cover excavation, blinding, reinforcement, shuttering, waterproofing and backfilling works. This is an ordinary excel worksheet where grey coloured cells are permitted for editing – you can change the values in these cells. accordingly, the BOQ values will be recalculated. After making necessary changes in values, you can select the cells (entire range or BOQ range) and copy them to an Excel sheet on your desktop for further calculations.
Following assumptions are used in the calculations:
Please let us know if any of the above assumptions do not fit your requirement.
The concept of parametric quantity survey evolved as part of our development efforts for our construction management software Baevr. The idea is to generate the Bill of Quantities of items associated with common components of works. We will frequently publish worksheets for parametric quantity surveys for different items of works.
The original Excel worksheets can be provided to interested users on request. If you find any bugs in calculations, please report to support@adeptalgorithms.com. Users are requested to validate the calculations with one or more samples, before putting the sheet to commercial use.
The construction industry is very vast. Although our assumptions may be valid for most of the common cases, there are particular cases that are not covered in these sheets. We welcome you to offer your suggestions on work elements not covered here or on a better set of assumptions in calculations.