Spreadsheet: 238680d1369669524-conditional-format-cells-when-blank-problem-test-jhren-
Sheet: MFS C4 1B

Asset | Number | Sub Number | Name | Street |  | Address Line 2 | Address Line 3 | PostCode | Asset Status | Final Cost | Final Cost (Incl. 13% RPIX) | Client Job Number | Contractor Job Number | [NAME] (Full) | [NAME] (Part) | Refusal Reason | Sold / RTB | No Access | Addition | No Works Required | Omission Reason | Variation Value | Variation Order Number | Start Date | Completion Date | Final Cost | Invoice Date | QA Inspection Date - WIP | QA Officer | QA Final Inspection Date | QA Officer | QA Agreed [NAME] | QA Officer | Survey Date | Number of Bedrooms | Dwelling Type | Style | Non Trad Property Type | Name | Contact Number | Warning Code | Occupational Therapist Visit Req | Access Code | TOTAL COST OF PROPERTY | K Type | Kitchen All Checks | [NAME] | KITCHEN REQUIRED? | TOTAL COST OF KITCHEN | Bathroom - Bath | Bathroom - Wash Hand Basin | Bathroom - WC | Full Bathroom Required | Meets DH Standard | BATHROOM REQUIRED? | TOTAL COST OF BATHROOM | Solid Fuel Present | Central Heating Present | [NAME] | Primary Heating Fuel | Boiler Required | Carcassing Required | Full Central Heating Required | CENTRAL HEATING REQUIRED? | TOTAL COST OF HEATING | Fire Required | TOTAL COST OF FIRE | Gas Supply Present | Existing Gas Meter | Gas [NAME] | [NAME] | Mains Cut-out Present | [NAME] | [NAME] | [NAME] | [NAME] | Damp Rising | Damp Rising Loc | Damp Condensation | Damp Condensation Loc | [NAME]. Required | Sheltered | RTB | Structural Survey | [NAME]? | Date | Nature of Survey
125355 | 10 |  |  | MAYCOCK AVENUE |  | KIMBERWORTH PARK | ROTHERHAM | S61 3BQ | Active | 6927.379999999999 |  |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] | -7827.939399999999 | V1_22663MS |  |  |  |  |  |  |  |  |  |  | 2012-02-14 08:21:05 | 3 | HOUS | END OF TERRACE |  | Mr [NAME] & Mrs [NAME] | NONE |  | N |  |  | K2 | Fail | NO | YES | 2072.37 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Baxi | MAINS GAS | Yes | No | Yes | YES | 3547.41 | Yes | 267 | YES | YES | KITCHEN | KITCHEN |  | No |  | No |  | No |  | No |  | Yes |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom, central heating and fire plus full management
1333 | 11 |  |  | ESKDALE ROAD |  | WINGFIELD | ROTHERHAM | S61 4BH |  | 3814.41 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2013-05-13 00:00:00 | 2013-05-17 00:00:00 |  | 2003-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Miss [NAME] | 07754 692 199 |  |  |  |  |  |  |  | No |  |  |  |  |  |  | No |  |  |  |  |  |  |  |  | YES | 3547.41 | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to central heating and fire only
142054 | 11 |  |  | GREAT PARK ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3PH | Active | 5472.26 |  |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] | -6183.6538 | V1_22662MS |  |  |  |  |  |  |  |  |  |  | 2012-02-13 11:41:56 | 1 | BUNG | SEMI-DETACHED |  | Mrs [NAME] | NONE |  | N |  |  | K1 | Fail | NO | YES | 1798.62 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | PARTIAL | 0 | MAINS GAS | Yes | No | Yes | YES | 2366.04 | Yes | 267 | YES | YES | EXTERNAL | EXTERNAL |  | No |  | No |  | No |  | No |  | Yes |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom, central heating and fire plus full management
39201 | 11 |  |  | ST MARYS VIEW |  |  |  |  |  | 2065.62 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -2334.150599999999 | V1_22673MS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr Stephen Pickering & Mrs Dorothy Pickering | 324216 |  |  |  |  |  |  |  | Yes | 1798.62 |  |  |  |  |  | No |  |  |  |  |  |  |  |  | No |  | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen and fire plus full management
36300 | 122 |  |  | BRIERY WALK |  | MUNSBROUGH | ROTHERHAM | S61 4QX | Active | 2976.72 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 2 | FLAT | FLAT |  | Mr [NAME] | [PHONE] |  | N |  |  | K3 | Fail |  | Yes | 1936.1 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | GLOWWORM | GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | EXTERNAL |  | No |  | No |  | No |  | Yes |  | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom plus full management
410542 | 13 |  |  | [NAME] WAY |  | MASBROUGH | ROTHERHAM | [NAME] 1JP | Active | 1040.62 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-26 12:09:54 | 1 | FLAT | FLAT |  | Mr [NAME] | NONE |  | N |  |  | K1 | Pass |  | No |  | Pass | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL |  |  | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | HALL |  | No |  | No |  | No |  | No |  | Yes |  |  | No | 2012-10-12 00:00:00 | no survey required
155659 | 13 |  |  | ELMTREE ROAD |  | THORPE HESLEY | ROTHERHAM | S61 2TJ | Active | 3547.41 |  |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] | -4008.5733 | V1_22670MS |  |  |  |  |  |  |  |  |  |  | 2011-05-15 13:12:18 | 3 | HOUS | SEMI-DETACHED | TRADITIONAL | Ms [NAME] | NONE |  | N |  |  | K3 | Pass | YES | NO |  | Pass | Pass | Pass | No | YES | NO |  | No | FULL | Alpha | MAINS GAS | Yes | No | Yes | YES | 3547.41 | No |  | YES | YES | HALL | HALL |  | No |  | No |  | No |  | No |  | No |  |  |  | Yes | TBA | specific R&D to central heating only
7375 | 14 |  |  | SWALE ROAD |  | WINGFIELD | ROTHERHAM | S61 4BU | Active | 2839.24 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-04 09:48:37 | 1 | FLAT | FLAT |  | Mr [NAME] | NONE |  | N | USE SIDE DOOR - KNOCK LOUDLY |  | K1 | Fail |  | Yes | 1798.62 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | BROAG REMEHA | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | HALL |  | No |  | No |  | No |  | No |  | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom plus full management
30066 | 15 |  |  | WILCOX GREEN |  | ROCKINGHAM | ROTHERHAM | S61 4DP | Active | 3205.03 |  |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] | -3621.6839 | V1_22664MS |  |  |  |  |  |  |  |  |  |  | 2012-08-16 11:46:48 | 1 | FLAT | FLAT |  | Mr [NAME] | 01709 308429 |  | N | USE SIDE DOOR |  | K4 | Fail | NO | YES | 1897.43 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Remeha | MAINS GAS | No | No | No | NO |  | Yes | 267 | YES | YES | EXTERNAL | HALL |  | No |  | No |  | No |  | No |  | No |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom and fire plus full management
123503 | 16 |  |  | [NAME] ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3HQ | Active | 2938.05 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2013-05-08 00:00:00 |  |  |  |  |  |  |  |  |  | 2011-11-28 11:46:19 | 2 | FLAT | FLAT |  | Mr [NAME] | [PHONE] |  | N |  |  | K4 | Fail |  | Yes | 1897.43 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | Worcester | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | KITCHEN |  | No |  | No |  | No |  | No | on single glazed windows | Yes |  |  | Yes | TBA | specific R&D to kitchen and bathroom only
40835 | 16 |  |  | WAGON ROAD |  | MUNSBROUGH | ROTHERHAM | S61 4QF | Active | 2976.72 |  |  |  |  |  |  |  |  |  |  |  | 3124.563 | V1_22144MS/V2_22146MS/V3_22174MS/V4_22148MS/V5_22150MS/V8_22449MS | 2013-04-15 00:00:00 | 2013-05-03 00:00:00 |  | 2001-05-01 00:00:00 |  |  |  |  |  |  | 2011-08-30 00:00:00 | 1 | FLAT | FLAT |  | Mr [NAME] | 548003 |  | N |  |  | K3 | Fail |  | Yes | 1936.1 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | district heating | COMMUNITY HEATING WITH NO CHP | No | No | No | No |  | No |  | YES | No |  |  | EXTERNAL |  | No |  | No |  | No |  | Yes | bathroom and kitchen due to no fan | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom plus full management
6456 | 160 |  |  | ROBINETS ROAD |  | WINGFIELD | ROTHERHAM | S61 4AN | Active | 2839.24 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-29 00:00:00 | 1 | FLAT | FLAT |  | Mr [NAME] | 07581 371827 |  | N |  |  | K1 | Fail |  | Yes | 1798.62 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No |  | REMEHA | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | KITCHEN |  | No |  | No |  | No |  | No |  | Yes |  |  | No | 2012-10-08 00:00:00 | no survey required
135972 | 17 |  |  | WELLFIELD LODGE |  | KIMBERWORTH PARK | ROTHERHAM | S61 3LN | Active | 2938.05 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2012-06-22 12:00:32 | 2 | FLAT | FLAT |  | Miss [NAME] | Miss [NAME] |  | N |  |  | K4 | Fail |  | Yes | 1897.43 | Pass | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | alpha | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | KITCHEN | OTHER |  | No |  | No |  | No |  | No |  | Yes |  |  | Yes | TBA | specific R&D to kitchen and bathroom only
13494 | 173 |  |  | CHURCH STREET |  |  |  |  |  | 2065.62 |  |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] | -2334.150599999999 | V1_22659MS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 01709 551955 |  |  |  |  |  |  |  | Yes | 1798.62 |  |  |  |  |  | REFUSED |  |  |  |  |  |  |  |  | REFUSED |  | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen and fire plus full management
407090 | 24 |  |  | HARTINGTON ROAD |  | [NAME] | ROTHERHAM | S61 1DE | Active | 2938.05 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-11-14 17:54:15 | 2 | HOUS | MID TERRACE |  | [NAME] | NONE |  | N |  |  | K4 | Fail |  | Yes | 1897.43 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | Remeha | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | KITCHEN |  | No |  | No |  | No |  | No |  | Yes |  |  | Yes | TBA | specific R&D to kitchen and bathroom only
139485 | 25 |  |  | BYRLEY ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3PP | Active | 6927.379999999999 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2013-05-30 00:00:00 |  |  |  |  |  |  |  |  |  | 2012-03-02 12:59:58 | 3 | HOUS | SEMI-DETACHED |  | [NAME] | 01709 561238 |  | N |  |  | K2 | Fail | NO | YES | 2072.37 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | [NAME] | MAINS GAS | Yes | No | Yes | YES | 3547.41 | Yes | 267 | YES | YES | UTILITY ROOM/CUPBOARD | UTILITY ROOM/CUPBOARD |  | No |  | No |  | No |  | No |  | Yes |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom, central heating and fire plus full management
21750 | 25 |  |  | PLOWMANS WAY |  |  |  |  |  | 1307.62 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -1477.6106 | V1_22669MS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miss [NAME] | 01709 368936 |  |  |  |  |  |  |  | No |  |  |  |  |  |  | Yes | 1040.62 |  |  |  |  |  |  |  | REFUSED |  | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to bathroom and fire plus full management
123917 | 299 |  |  | KIMBERWORTH PARK ROAD |  | KIMBERWORTH | ROTHERHAM | S61 3LU | Active | 5750.51 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-13 16:18:45 | 3 | HOUS | SEMI-DETACHED |  | Mr [NAME] & Mrs [NAME] | 559046 |  | Y |  |  | K3 | Fail | NO | YES | 1936.1 | Pass | Pass | Pass | No | YES | NO |  | No | FULL | [NAME] | MAINS GAS | Yes | Yes | Yes | YES | 3547.41 | Yes | 267 | YES | YES | HALL | HALL |  | No |  | No |  | No |  | No |  | Yes |  |  |  | Yes | TBA | specific R&D to central heating and fire only
144624 | 3 |  |  | KENT ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3QB | Active | 5691.07 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-06-14 12:46:25 | 2 | HOUS | SEMI-DETACHED | TRADITIONAL | [NAME] | [PHONE] |  | N |  |  | K4 | Fail | NO | YES | 1897.43 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Alpha | MAINS GAS | Yes | Yes | Yes | YES | 2486.04 | Yes | 267 | YES | YES | HALL | KITCHEN |  | No |  | No |  | Yes |  | No |  | No |  |  |  | Yes | TBA | specific R&D to central heating and fire only
35470 | 30 |  |  | BRIERY WALK |  | MUNSBROUGH | ROTHERHAM | S61 4QX | Active | 1798.62 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-14 09:00:40 | 1 | FLAT | FLAT |  | Miss [NAME] | NONE |  | Y |  |  | K1 | Fail |  | Yes | 1798.62 | Fail | Fail | Fail | Refused |  | Refused |  | No |  | GLOWWORM | GAS | No | Yes | No | No |  | No |  | YES | YES | YES | EXTERNAL | EXTERNAL |  | No |  | No |  | No |  | Yes |  | No |  |  | No | 2013-02-26 00:00:00 | no survey required
157920 | 32 |  |  | CAINE GARDENS |  | KIMBERWORTH | ROTHERHAM | S61 2JB | Active | 2633.04 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -2975.3352 | [NAME] |  |  |  |  |  |  |  |  |  |  | 2011-01-25 10:44:45 | 1 | BUNG | SEMI-DETACHED |  | Mrs [NAME] | 01709 511810 |  | N | USE BACK DOOR - KNOCK LOUDLY |  | K1 | Pass | YES | NO |  | Pass | Pass | Pass | No | YES | NO |  | No | FULL | Alpha | MAINS GAS | Yes | Yes | Yes | YES | 2366.04 | Yes | 267 | YES | YES | EXTERNAL | KITCHEN |  | No |  | No |  | No |  | No |  | Yes |  |  |  | Yes | TBA | specific R&D to central heating and fire plus full management
32235 | 32 |  |  | HIGHFIELD ROAD |  | GREASBROUGH | ROTHERHAM | S61 4PB | Active | 6791.11 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -7673.954299999999 | V1_22665MS |  |  |  |  |  |  |  |  |  |  | 2011-02-01 16:42:00 | 3 | HOUS | SEMI-DETACHED |  | Miss [NAME] | 441827 | W1 | N | USE BACK DOOR |  | K3 | Fail | NO | YES | 1936.1 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Alpha | MAINS GAS | Yes | Yes | Yes | YES | 3547.41 | Yes | 267 | YES | YES | under sink | HALL |  | No |  | No |  | No |  | No |  | No |  |  |  | Yes | TBA | specific R&D to central heating and fire only
131548 | 35 |  |  | SHEARMAN AVENUE |  | KIMBERWORTH PARK | ROTHERHAM | S61 3AG | Active | 1040.62 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2012-09-13 12:19:04 | 2 | HOUS | SEMI-DETACHED |  | Mrs Janice Hodgson | [PHONE] |  | N |  |  | K4 | Pass |  | No |  | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | reMEHA | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | KITCHEN | KITCHEN |  | No |  | No |  | No |  | No |  | Yes |  |  | No | 2012-07-10 00:00:00 | no survey required
41856 | 35 |  |  | WOODSIDE WALK |  | MUNSBROUGH | ROTHERHAM | S61 4QY | Active | 2839.23 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 1 | FLAT | FLAT |  | EMPTY 11/03/2013 | NONE |  | N | KNOCK LOUDLY |  | K1 | Fail |  | Yes | 1798.61 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | boulter buderus | GAS | No | No | No | No |  | No |  | YES | YES | YES | KITCHEN | EXTERNAL |  | No |  | No |  | No |  | No |  | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom only
41070 | 38 |  |  | WAGON ROAD |  | MUNSBROUGH | ROTHERHAM | S61 4QF | Active | 2839.24 |  |  |  |  |  |  |  |  |  |  |  | 1833.7866 | V1_22145MS/V2_22450MS | 2013-04-16 00:00:00 | 2013-04-29 00:00:00 |  | 2001-05-01 00:00:00 |  |  |  |  |  |  | 2011-09-21 18:10:53 | 1 | FLAT | FLAT |  | Miss [NAME] | [PHONE] |  | N |  |  | K1 | Fail |  | Yes | 1798.62 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL |  | COMMUNITY HEATING WITH NO CHP | No | No | No | No |  | No |  | YES | No |  | N/A | EXTERNAL |  | No |  | No |  | No |  | Yes |  | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom plus full management
37785 | 39 |  |  | FENTON WAY |  | MUNSBROUGH | ROTHERHAM | S61 4QG | Active | 2976.72 |  |  |  |  |  |  |  |  |  |  |  | 674.723 | V1_22140MS/V2_22141MS/V3_22142MS/V4_22143MS/V6_22151MS/V7_22152MS | 2013-04-09 00:00:00 | 2013-04-26 00:00:00 |  | April |  |  | 2013-04-30 00:00:00 | AS/DW |  |  | 2011-09-02 00:00:00 | 3 | HOUS | MID TERRACE |  | Miss [NAME] | 320166 |  | N |  |  | K3 | Fail |  | Yes | 1936.1 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | ALPHA | GAS | No | No | No | No |  | No |  | YES | YES | YES | KITCHEN | EXTERNAL |  | No |  | No |  | No |  | No |  | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom plus full management
151691 | 4 |  |  | STUBBS WALK |  | KIMBERWORTH PARK | ROTHERHAM | S61 3ED | Active | 2839.24 |  |  |  |  |  |  |  |  |  |  |  | 841.4318999999999 | V1_22451MS | 2013-05-01 00:00:00 | 2013-05-17 00:00:00 |  |  |  |  |  |  |  |  | 2011-01-19 13:17:00 | 1 | BUNG | MID TERRACE | TRADITIONAL | Mr [NAME] | [PHONE] |  | N | USE BACK DOOR - KNOCK LOUDLY |  | K1 | Fail |  | Yes | 1798.62 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | Worcester | MAINS GAS | Yes | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | KITCHEN |  | No |  | No |  | No |  | No |  | No |  |  | Yes | TBA | specific R&D to kitchen and bathroom only
35607 | 42 |  |  | BRIERY WALK |  | MUNSBROUGH | ROTHERHAM | S61 4QX | Active | 2938.05 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 2 | FLAT | FLAT |  | Mr [NAME] & Miss [NAME] | [PHONE] |  | N |  |  | K4 | Fail |  | Yes | 1897.43 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | buderus | GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | EXTERNAL |  | No |  | No |  | No |  | No |  | Yes |  |  | No | 2011-04-12 00:00:00 | no survey required
4086 | 46 |  |  | ORCHARD FLATTS CRES |  |  |  |  |  | 1040.62 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2013-05-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr [NAME] | 07845 081997 |  |  |  |  |  |  |  | No |  |  |  |  |  |  | Yes | 1040.62 |  |  |  |  |  |  |  | No |  | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to bathroom plus full management
8662 | 55 |  |  | TEESDALE ROAD |  |  |  |  |  | 5691.09 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr Gerald Ellis & Mrs Evelyn Ellis | 07932 318912 |  |  |  |  |  |  |  | Yes | 1897.43 |  |  |  |  |  | Yes | 1040.62 |  |  |  |  |  |  |  | YES | 2486.04 | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom, central heating and fire only
36959 | 58 |  |  | ELM GROVE |  | MUNSBROUGH | ROTHERHAM | S61 4QD | Active | 2938.05 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-09-02 00:00:00 | 1 | FLAT | FLAT |  | Mr [NAME] | NONE | W1 | N |  |  | K4 | Fail |  | Yes | 1897.43 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | GLOWWORM | GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | EXTERNAL |  | No |  | No |  | No |  | No |  | Yes |  |  | Yes | TBA | specific R&D to kitchen and bathroom plus full management
39850 | 58 |  |  | ST MARYS VIEW |  | MUNSBROUGH | ROTHERHAM | S61 4NJ | Active | 3814.41 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -4310.283299999999 | V1_22666MS |  |  |  |  |  |  |  |  |  |  | 2011-06-09 13:49:27 | 3 | HOUS | MID TERRACE | TRADITIONAL | Miss [NAME] | [PHONE] |  | N |  |  | K3 | Pass | YES | NO |  | Pass | Pass | Pass | No | YES | NO |  | No | FULL | [NAME] | MAINS GAS | Yes | No | Yes | YES | 3547.41 | Yes | 267 | YES | YES | EXTERNAL | EXTERNAL |  | No |  | Yes | bedroom | No |  | No |  | No |  |  |  | Yes | TBA | specific R&D to central heating and fire plus full management
119772 | 6 |  |  | BINDERS ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3LW | Active | 6791.11 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -7673.954299999999 | V1_22668MS |  |  |  |  |  |  |  |  |  |  | 2011-06-14 12:41:13 | 3 | HOUS | SEMI-DETACHED | TRADITIONAL | Ms [NAME] | [PHONE] |  | N | USE BACK DOOR - KNOCK LOUDLY |  | K3 | Fail | NO | YES | 1936.1 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Alpha | MAINS GAS | Yes | Yes | Yes | YES | 3547.41 | Yes | 267 | YES | YES | KITCHEN | KITCHEN |  | No |  | No |  | No |  | No |  | No |  |  |  | Yes | TBA | specific R&D to central heating and fire only
38066 | 67 |  |  | MUNSBROUGH RISE |  |  |  |  |  | 2065.62 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr Stanley Sands & Mrs Ann E. Sands | [PHONE] |  |  |  |  |  |  |  | Yes | 1798.62 |  |  |  |  |  | No |  |  |  |  |  |  |  |  | No |  | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen and fire plus full management
39123 | 7 |  |  | ST MARYS VIEW |  |  |  |  |  | 2065.62 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -2334.150599999999 | V1_22671MS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr Alfred Groocock & Mrs [NAME] | 553986 |  |  |  |  |  |  |  | Yes | 1798.62 |  |  |  |  |  | No |  |  |  |  |  |  |  |  | No |  | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen and fire plus full management
133182 | 76 |  |  | SIMMONITE ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3EL | Active | 3379.97 |  |  |  | 1 |  | [NAME] |  |  |  |  | [NAME] | -3819.366099999999 | V1_22660MS |  |  |  |  |  |  |  |  |  |  | 2012-02-21 09:55:21 | 3 | HOUS | SEMI-DETACHED |  | Mr [NAME] | 01709 552785 |  | N |  |  | K2 | Fail | NO | YES | 2072.37 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | NONE | Remeha | MAINS GAS | No | No | No | NO |  | Yes | 267 | YES | YES | UTILITY ROOM/CUPBOARD | HALL |  | Yes |  | No |  | No |  | No | toilet | Yes |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom and fire plus full management
163266 | 77 |  |  | WINTERHILL ROAD |  | RICHMOND PARK | ROTHERHAM | S61 2EP | Active | 2633.04 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2010-05-26 11:57:43 | 1 | BUNG | SEMI-DETACHED | TRADITIONAL | Miss [NAME] | 01709 555995 |  | N |  |  | K1 | Pass | YES | NO |  | Pass | Pass | Pass | No | YES | NO |  | No | FULL | Alpha | MAINS GAS | Yes | Yes | Yes | YES | 2366.04 | Yes | 267 | YES | YES | KITCHEN | KITCHEN |  | No |  | No |  | No |  | No |  | No | SHELTERED |  |  | Yes | TBA | specific R&D to central heating and fire only
117449 | 8 |  |  | ABDY ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3LZ | Active | 2976.72 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 2011-01-11 17:38:00 | 3 | HOUS | MID TERRACE | TRADITIONAL | Mr [NAME] | [PHONE] |  | N | KNOCK LOUDLY |  | K3 | Fail |  | Yes | 1936.1 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | WORCESTER BOSCH | MAINS GAS | No | No | No | No |  | No |  | YES | YES | YES | KITCHEN | KITCHEN |  | No |  | No |  | No |  | No |  | No |  |  | No | 2011-08-10 00:00:00 | no survey required
128515 | 8 |  |  | REMOUNT ROAD |  | KIMBERWORTH PARK | ROTHERHAM | S61 3AE | Active | 5691.07 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -6430.909099999999 | V1_22661MS |  |  |  |  |  |  |  |  |  |  | 2011-02-04 12:29:00 | 2 | FLAT | FLAT |  | Miss [NAME] | [PHONE] |  | N |  |  | K4 | Fail | NO | YES | 1897.43 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Alpha | MAINS GAS | Yes | Yes | Yes | YES | 2486.04 | Yes | 267 | YES | YES | KITCHEN | KITCHEN |  | No |  | No |  | No |  | No |  | Yes |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom, central heating and fire only
169521 | 8 |  |  | THUNDERCLIFFE ROAD |  |  |  |  |  | 6524.13 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr [NAME] | 07540 591898 |  |  |  |  |  |  |  | Yes | 1936.1 |  |  |  |  |  | Yes | 1040.62 |  |  |  |  |  |  |  | YES | 3547.41 | No |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom and central heating only
5896 | 84 |  |  | ROBINETS ROAD |  | WINGFIELD | ROTHERHAM | S61 4AE | Active | 5691.07 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2013-04-29 00:00:00 | 2013-05-17 00:00:00 |  | 2003-05-01 00:00:00 |  |  |  |  |  |  | 2012-08-16 11:22:44 | 2 | FLAT | FLAT |  | Mr [NAME] | 07816 910318 |  | N |  |  | K4 | Fail | NO | YES | 1897.43 | Fail | Fail | Fail | Yes | NO | YES | 1040.6 | No | FULL | Ferroli | MAINS GAS | Yes | Yes | Yes | YES | 2486.04 | Yes | 267 | YES | YES | EXTERNAL | HALL |  | No |  | No |  | No |  | No |  | No |  |  |  | Yes | TBA | specific R&D to kitchen, bathroom, central heating and fire plus full management
123008 | 9 |  |  | HAMPSTEAD GREEN |  | KIMBERWORTH PARK | ROTHERHAM | S61 3QG | Active | 2839.24 |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2013-05-09 00:00:00 |  |  |  |  |  |  |  |  |  | 2012-08-07 10:08:05 | 1 | FLAT | FLAT |  | Mr [NAME] | 07923 255625 |  | N |  |  | K1 | Fail |  | Yes | 1798.62 | Pass | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL |  |  | No | No | No | No |  | No |  | YES | YES | NO | None | EXTERNAL |  | No |  | No |  | No |  | No |  | Yes |  |  | No | 2012-07-06 00:00:00 | no survey required
39165 | 9 |  |  | ST MARYS VIEW |  |  |  |  |  | 2065.62 |  |  |  |  |  |  |  |  |  | 1 | Work completed | -2334.150599999999 | V1_22672MS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr [NAME] | 553424 |  |  |  |  |  |  |  | Yes | 1798.62 |  |  |  |  |  | No |  |  |  |  |  |  |  |  | No |  | Yes | 267 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes | TBA | specific R&D to kitchen and fire plus full management
42380 | 98 |  |  | WOODSIDE WALK |  | MUNSBROUGH | ROTHERHAM | S61 4QZ | Active | 2839.23 |  |  |  |  |  |  |  |  |  |  |  | 2373.1243 | V1_22132MS/V2_22133MS/V3_22134MS/V4_22135MS/V5_22136MS/V6_22137MS/V7_22138MS/V8-22139MS | 2013-04-03 00:00:00 | 2013-04-19 00:00:00 |  | April |  |  | 2013-04-23 00:00:00 | AS/SF |  |  | 2011-10-05 15:28:47 | 1 | FLAT | FLAT |  | Mr [NAME] | 01709 740560 |  | Y |  |  | K1 | Fail |  | Yes | 1798.61 | Fail | Fail | Fail | Yes |  | Yes | 1040.62 | No | FULL | ALPHA | GAS | No | No | No | No |  | No |  | YES | YES | YES | EXTERNAL | EXTERNAL |  | No |  | No |  | No |  | No |  | Yes |  |  | Yes | TBA | specific R&D to kitchen and bathroom only