CYPE Mentor

Solutions for professionals

Share

Generating and updating the bill of quantities

After creating the price database and the mapping file, you must update the estimate by clicking on the "Update measurement" button in the "Update" block of the top toolbar.

To do this, you must select the option "Delete current budget data", activate and select the mapping and price bank created, and click accept. A pop-up window will then appear to link the items in the "Installation" tab and the work units in the price bank.

Mapping window

The pop-up window is divided into four panels:

  1. "Chapter Structure" panel
    Displays the chapter structure defined in the mapping file.
  2. Classification Panel
    Displays a table with the items modelled in the Installation tab, with the following columns: Unit, Reference, Import, Chapter Code, Concept Code, Concept Unit (check box), Concept Unit (text field), "Concept reference", "Detail line", "Factor", "Mapped to a unit price", "Unit price code" and another column which, if applicable, displays an incident icon(*).
  3. "Assign codes" panel
    Displays the reference price bank. The following tools are included at the top of this panel:
    • Assign. Replace the values of "Chapter code" and "Item code" in the mapping file with those of the work unit selected in the price database.
    • Chapters. Captures the chapter structure from the price database and assigns it to the mapping file.
    • Search. Allows you to locate concepts in the price database by text, summary, code or keyword.
    • Synchronise. Activating this option allows you to locate any of the work units selected in the "Classification" panel in the price database.
    • Selection of the reference price bank. Using a drop-down list, you can select a price bank from among those available.
  4. Incidents Panel
    Displays incidents detected in the mapping file.

Mapping by code assignment

One way to map the elements of the model is by assigning codes, one by one, from the reference price bank to the mapping file. The process is as follows:

  1. Assign chapter structure
    Using the "Chapters" button in the "Assign codes" panel, the mapping file is automatically assigned the same chapter structure as the reference price database. It is also possible to create the structure manually using the tools in the "Chapter structure" panel, defining a code and a reference.
  1. Assign price bank codes
    Select a work unit in the price bank and the corresponding item in the "Classification" panel, then click the "Assign" button in the "Assign codes" panel. This process must be repeated for each item you wish to link.

  2. Once the assignments have been completed, you must accept the pop-up window to apply the changes.

Mapping at unit prices

Another way to map the elements of the model is by assigning unit prices.

When editing an item in the "Classification" panel, you can activate the "Resource code" option and indicate the unit price code to which the quantity of the model item will be mapped.

In this case, it is not necessary to indicate the "Chapter code" or "Concept code", as the programme automatically establishes the correspondence with the relevant chapter.

If the resource specified in the mapping file is a cost breakdown in the associated cost database, only the unit components of this breakdown shall be assigned to the concept.