Spreadsheet: 238671d1369668811-conditional-format-cells-when-blank-problem-test3
Sheet: Variations

 | Contractor To Populate |  |  | Scheme Name and Number: |  | MFS C4 1B Internals
 | Client To Populate
 | Contractor / Client To Populate
 | Automatically Populated |  |  |  |  |  |  |  |  |  | Nr of Variations Raised
 | Late Response |  |  |  |  | Nett Value of Variations To Date |  |  |  |  | Number of Variations Approved
 | Needs Populating |  |  |  |  |  |  |  |  |  | Outstanding Variations
Submission Date | VO Nr Issue Date | Scheme | Client Job Nr | MFS Job Nr | Address | Description | Rate Reference | Rate Origin | Quant | Unit | Rate | Nett Total | 18% Discount | RPIX @13% | 12.5% Uplift | Total | VO Nr Required By: | Client Response |  | Follow On Actions | Open / Closed | Variation Number
2013-04-03 00:00:00 |  | MFS C4 1B |  |  | 10 Maycock Avenue | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -6927.379999999999 |  |  |  |  |  |  |  |  |  |  | V1_22663MS
 |  | MFS C4 1B |  |  | 11 Great Park Road | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -5472.26 |  |  |  |  |  |  |  |  |  |  | V1_22662MS
 |  | MFS C4 1B |  |  | 11 St Marys View | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -2065.619999999999 |  |  |  |  |  |  |  |  |  |  | V1_22673MS
 |  | MFS C4 1B |  |  | 13 Elmtree Road | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -3547.409999999999 |  |  |  |  |  |  |  |  |  |  | V1_22670MS
 |  | MFS C4 1B |  |  | 15 Wilcox Green | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -3205.03 |  |  |  |  |  |  |  |  |  |  | V1_22664MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | Remove of AIB panel in bathroom and carry out scarps to kitchen and bathroom ceiling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V1_22144MS
2013-04-18 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | Install new DP switch to mains |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V2_22146MS
2013-04-18 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | 2 mts of chipboard to kitchen floor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2013-04-18 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | Over board kitchen & bathroom floor - 8 m2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V4_22148MS
2013-04-18 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | Rough and skim kitchen celing - 8 m2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V5_22150MS
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | Coving Trunking to allow new kitchen wire - 18 lin meter
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 16 Wagon Road | Renew panel to bathroom where AIB removed in bathroom |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-08 00:00:00 |  | Closed | V8_22449
 |  | MFS C4 1B |  |  | 16 Wagon Road |  |  | Tendered Rates | 1 |  | 2765.099999999999 |  |  |  |  |  |  |  |  |  |  | V1_22144MS/V2_22146MS/V3_22174MS/V4_22148MS/V5_22150MS/V8_22449MS
 |  | MFS C4 1B |  |  | 173 Church Street | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -2065.619999999999 |  |  |  |  |  |  |  |  |  |  | V1_22659MS
 |  | MFS C4 1B |  |  | 25 Plowmans Way | Omitted; work already carried out |  | Tendered Rates | 1 |  | -1307.62 |  |  |  |  |  |  |  |  |  |  | V1_22669MS
 |  | MFS C4 1B |  |  | 32 Caine Gardens | Omitted; work already carried out |  | Tendered Rates | 1 |  | -2633.04 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | MFS C4 1B |  |  | 32 Highfield Road | Omitted; work already carried out |  | Tendered Rates | 1 |  | -6791.109999999999 |  |  |  |  |  |  |  |  |  |  | V1_22665MS
2013-04-17 00:00:00 |  | MFS C4 1B | BAC649 |  | 38 Wagon Road | Install new DP switch to mains |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V1_22145MS
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 38 Wagon Road | Carry out work to scrap kitchen and bathroom ceiling to remove textured coating and floor tiles to kitchen
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 38 Wagon Road | Coving Trunking to allow new kitchen wire - 18 lin meter
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 38 Wagon Road | Core vent and extra fuse spur for dryer
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 38 Wagon Road | Move heating controls in to tile [NAME]
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 38 Wagon Road | Over board kitchen & bathroom floor - 17 m2
2013-05-08 00:00:00 |  | MFS C4 1B | BAC648 |  | 38 Wagon Road | Extra plasterng to wall and ceiling  - 4m2 |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-08 00:00:00 |  | Closed | V2_22450MS
 |  | MFS C4 1B |  |  | 38 Wagon Road |  |  | Tendered Rates | 1 |  | 1622.82 |  |  |  |  |  |  |  |  |  |  | V1_22145MS/V2_22450MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC641 |  | 39 Fenton Way | 2.5 Mts of chipboard flooring to kitchen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V1_22140MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC641 |  | 39 Fenton Way | Over board floor kitchen & bathroom floor - 17.5 m2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V2_22141MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC641 |  | 39 Fenton Way | Extra plastering to Kitchen - 2M2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V3_22142MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC641 |  | 39 Fenton Way | Relocate socket for boiler into the new tile line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V4_22143MS
2013-04-18 00:00:00 |  | MFS C4 1B | BAC641 |  | 39 Fenton Way | Extra vinyl flooring to kitchen/dinning room  - 8 m2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V6_22151MS
2013-04-18 00:00:00 |  | MFS C4 1B | BAC641 |  | 39 Fenton Way | 3 lin meter of gas pipework |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V7_22152MS
 |  | MFS C4 1B |  |  | 39 Fenton Way |  |  | Tendered Rates | 1 |  | 597.0999999999999 |  |  |  |  |  |  |  |  |  |  | V1_22140MS/V2_22141MS/V3_22142MS/V4_22143MS/V6_22151MS/V7_22152MS
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | Sure Stop Tap System
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | Remove old pantry unit out of kitchen as per [NAME] - site visit with LL & DW
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | 9 lm of extra gas pipe work
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | New Rad to kitchen to allow new kitchen layout as per [NAME] on 30/4/2013 - Site Vist
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | 9 lm of extra pipe work to re-locate rad as per site meeting
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | [NAME] tiles to fuse board
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | Extra plastering to Property - 4LM
2013-05-08 00:00:00 |  | MFS C4 1B | [NAME] |  | 4 Stubbs Walk | Make good to concreter floor where old pantry was remove as per [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-08 00:00:00 |  | Closed | V1_22451MS
 |  | MFS C4 1B |  |  | 4 Stubbs Walk |  |  | Tendered Rates | 1 |  | 744.6299999999999 |  |  |  |  |  |  |  |  |  |  | V1_22451MS
 |  | MFS C4 1B |  |  | 58 St Marys View | Omitted; work already carried out |  | Tendered Rates | 1 |  | -3814.409999999999 |  |  |  |  |  |  |  |  |  |  | V1_22666MS
 |  | MFS C4 1B |  |  | 6 Binders Road | Omitted; work already carried out |  | Tendered Rates | 1 |  | -6791.109999999999 |  |  |  |  |  |  |  |  |  |  | V1_22668MS
 |  | MFS C4 1B |  |  | 7 St Marys View | Omitted; work already carried out |  | Tendered Rates | 1 |  | -2065.619999999999 |  |  |  |  |  |  |  |  |  |  | V1_22671MS
 |  | MFS C4 1B |  |  | 76 Simmonite Road | Omitted; tenant Refusal |  | Tendered Rates | 1 |  | -3379.969999999999 |  |  |  |  |  |  |  |  |  |  | V1_22660MS
 |  | MFS C4 1B |  |  | 8 Remount Road | Omitted; work already carried out |  | Tendered Rates | 1 |  | -5691.069999999999 |  |  |  |  |  |  |  |  |  |  | V1_22661MS
 |  | MFS C4 1B |  |  | 9 St Marys View | Omitted; work already carried out |  | Tendered Rates | 1 |  | -2065.619999999999 |  |  |  |  |  |  |  |  |  |  | V1_22672MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | 2.5 Mts of chipboard flooring to kitchen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V1_22132MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | Over board floor kitchen & bathroom floor - 17 m2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V2_22133MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | Relocate socket for boiler into the new tile line |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V3_22134MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | Extra 5 lin of gas pipe work for new cooker loaction |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V4_22135MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | New Tail to meter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V5_22136MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | Coving Trunking to allow new kitchen wire - 18 lin meter |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | Carry out work to scrap kitchen ceiling to remove textured coating |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V7_22138MS
2013-04-11 00:00:00 |  | MFS C4 1B | BAC651 |  | 98 Woodside Walk | Install new DP switch to mains |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V8_22139MS
 |  | MFS C4 1B |  |  | 98 Woodside Walk |  |  | Tendered Rates | 1 |  | 2100.11 |  |  |  |  |  |  |  |  |  |  | V1_22132MS/V2_22133MS/V3_22134MS/V4_22135MS/V5_22136MS/V6_22137MS/V7_22138MS/V8-22139MS