Spreadsheet: 787435d1657799220-conditional-formating-or-list-required-to-highlight-values-not-pulled-through-that-should-pricing-review-examples
Sheet: Input Template

 |  |  |  |  |  |  |  |  | main rate | Main rate variable | Main rate variable | Main rate variable | Main rate variable | TMA extra cost | Wash out hydrant | fire hydrant | sluice valves | air valves | non return valve | Pressure reducing valve (install only) | mains branch | Add metres of main/service/comm pipe | Add excavation vol (less than 1.5m depth) | Add excavation volume(1.5m depth or greater) | Add reinstatement | Installation of an additional repair clamp | Materials suitable for use in contaminated ground
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | rate | m | m3 | m3 | m2 | rate | m
Unique Id | [NAME] no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error |  | A1 | A2 | A3 | A4 | A5 | TM | V1 (a-d) | V2 (a-d) | V3 (a-d) | V4 (a-d) | V5 (a-d) | V6 (a-d) | V7 (a-d) | X1 (a-d) | X3 | X4 | X5 | X6 (a-c) | X8 (a-d)
 |  |  |  |  |  |  |  |  | A1 | A2 | A3 | A4 | A5 | TM | V1a | [NAME] | [NAME] | V4a | V5a | V6a | V7a | [NAME] | X3 | X4 | X5 | X6a | X8a | V7 | X8
Unique Id | [NAME] no. | Service Product | Job as promoted | Job as delivered | Description | Final Entry | Error | Blank |  |  |  |  |  | Single
 | 25881828 | 3ML6 | Yes | 3ML6 | Excavate and [NAME] for NAV |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 25856965 | 3ML4 | Yes | 3ML4 | Self Lay Mains Connection |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 25331047 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 26361582 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 26018126 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 26018193 | 3ML4 | Yes | 3ML4 | Self Lay Mains Connection |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 26018193 | 3ML4 | Yes | 3ML4 | Self Lay Mains Connection |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 25951073 | 3SM4 | YES | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 25885266 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  | 0 |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 25885266 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 1
 | 25985365 | 3SL2 | Yes | 3SL2 | [NAME] |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 26060838 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 2
 | 25980807 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 2
 | 25980807 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 2
 | 25980940 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 2
 | 26048346 | 3ML2 | Yes | 3ML2 | Lay Main Only |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  |  |  |  | 2
 | 25988031 | 3ML2 | Yes | 3ML2 | Lay Main Only |  |  |  |  | 1 |  |  |  |  | 1 |  | 2 |  |  |  | 1 | 5 |  |  |  |  | 5
 | 25948491 | 3ML2 | Yes | 3ML2 | Lay Main Only |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 |  |  |  |  | 6
 | 25945198 | 3ML2 | Yes | 3ML2 | Lay Main Only |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 |  |  |  |  | 6