Spreadsheet: 781376d1653291376-change-in-lookup-to-different-sheet-not-working-northfields-review-test-etaf
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
 |  |  |  |  |  |  |  |  | rate | rate | rate | rate | rate | Lookup | rate | rate | rate | rate | rate | rate | 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)
 |  |  |  |  |  |  |  |  | A1 | A2 | A3 | A4 | A5 | TM | V1a | [NAME] | [NAME] | V4a | V5a | V6a | V7a | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Single
25770880-6 | 25770880 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 2
25770832-7 | 25770832 | 3SL6 | Yes | 3SL6 | Manifold Installation No Exc |  |  |  | 1
25942414-8 | 25942414 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  | 0 |  |  |  |  |  | 1 |  |  |  |  |  |  | 3
25904092-9 | 25904092 | 3HW2 | Yes | 3HW2 | [NAME] |  |  |  | 1
25762507-10 | 25762507 | 3SM2 | Yes | 3SM2 | Inst LrgeDiaMtrd ComPipe Shrt |  |  |  | 1
25770831-11 | 25770831 | 3SM4 | Yes | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
25904092-12 | 25904092 | 3HW2 | Yes | 3HW2 | [NAME] |  |  |  | 1
26123859-13 | 26123859 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 71
26123859-14 | 26123859 | 3ML1 | No | 3TH1 | [NAME] (Permit) |  |  |  | 1
23494103-15 | 23494103 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  |  | 0 |  |  |  |  | 2 |  | 1 |  |  |  | 1 | 60
25981916-16 | 25981916 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 4
25981916-17 | 25981916 | 3SM1 | No | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 6
26164701-18 | 26164701 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 2
25880278-19 | 25880278 | 3LD0 | Yes | 3LD0 | Lead Renewal (Short Side) |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3
26100240-20 | 26100240 | 3DC1 | Yes | 3DC1 | Disconnect Cust Supply Rech |  |  |  | 1
26161186-21 | 26161186 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 4
26161188-22 | 26161188 | 3SFA | Yes | 3SFA | New Supplies Disconnection |  |  |  | 1
26078818-23 | 26078818 | 3DC1 | Yes | 3DC1 | Disconnect Cust Supply Rech |  |  |  | 1
26137612-24 | 26137612 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
26137809-25 | 26137809 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 12
26166744-26 | 26166744 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3
26094786-27 | 26094786 | 3ML2 | Yes | 3ML2 | Lay Main Only |  |  |  | 1 |  |  |  |  |  | 3 |  | 5 |  |  |  | 1 | 105
26094786-28 | 26094786 | 3ML2 | Yes | 3ML2 | Lay Main Only |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  | 135
26054664-29 | 26054664 | 3ML1 | Yes | 3ML1 | Excavate and [NAME] |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 64
26164333-30 | 26164333 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 7
26185749-31 | 26185749 | 3SM1 | Yes | 3SM1 | Inst Meter MSM Com Pipe LongS |  |  |  | 1
26146302-32 | 26146302 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
26146302-33 | 26146302 | 3SM4 | Yes | 3SM4 | Inst MSMChmMtrFerLaidSer [NAME] |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 3
26146303-34 | 26146303 | 3SM0 | Yes | 3SM0 | Inst Mtrd MSM Com Pipe ShortS |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  | 1
25981539-35 | 25981539 | 3ME1 | Yes | 3ME1 | 15mm [NAME] (NoExc) |  |  |  | 1