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
- Direct Filtering of the works on the working sheet.
- Estimate breakdown of the works by pivot table.
- 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,
|Estimate breakdown by work
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).