To establish the assessments of works or statistics related to the operation in particular within the subcontracts or to carry out the orders of materials in the suppliers you must incorporate filters in the column B of the working sheet.

From that, the synthesis can be established in various manners

1. Direct Filtering of the works on the working sheet.
2. Estimate breakdown of the works by pivot table.
3. Creation of a graph of the cost breakdown.

Each procedure is done automatically starting from a call procedure placed on the customized menu bar.

The presentation is done in an almost instantaneous way on a new working sheet according to the data elements and filters introduces into the estimate.

In the below table, displays only the works related to the sheaths (gaines) with the total of the materials costs, hours, cost price, etc.

Estimate breakdown of the works by pivot table (the sheet was drawn up with Excel 2000).

This sheet can be if required to use like document of substitution (Estimate given to the customer, situation of work, after having dissimulated the columns of all the confidential elements related to the study.

The table attached was drawn up with Excel 9 (2000), the presentation in Excel 8 (97) is slightly different.

The graph of synthesis makes it possible to evaluate the cost breakdown visually (very practical).

Last update: