{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Pre and post summary","EVERY EPC","Top-floor flat","Mid-floor flat","Ground-Floor Flat","Mid-Terrace","Semi-Detached","Detached"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pre and post summary","index":0,"n_rows":11,"n_cols":34,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,null,null,"Pre retro per house",null,null,null,null,"Pre retro village",null,null,null,null,"Post retro house",null,null,null,null,"Post retro village",null,null,null,null,null,null,null,null,null,null,null,null,"pre percentages"]
["House types","Number of houses",null,"Total demand (kWh)","Heating (kWh)","Water (kWh)","Electrical (kWh)",null,"Total demand (MWh)","Heating (MWh)","Water (MWh)","Electrical (MWh)",null,"Total demand per (kWh)","Heating (kWh)","Water (kWh)","Electrical (kWh)",null,"Total demand (MWh)","Heating (MWh)","Water (MWh)","Electrical (MWh)",null,null,"Pre Retro","25% Retrofit","50% Retrofit","75% Retrofit","Demand all houses retro (MWh)",null,null,"Heating (kWh)","Water (kWh)","Electrical (kWh)"]
["Semidetached",{"$f":"48%*475","v":228},null,37150,18500,3500,{"$f":"D3-E3-F3","v":15150},null,{"$f":"D3*$B3/1000","v":8470.2000000000007},{"$f":"E3*$B3/1000","v":4218},{"$f":"F3*$B3/1000","v":798},3454.2,null,{"$f":"O3+P3+Q3","v":10423.484848484848},{"$f":"E3/11","v":1681.8181818181818},{"$f":"F3/3","v":1166.6666666666667},{"$f":"G3/2","v":7575},null,{"$f":"N3*$B3/1000","v":2376.5545454545454},{"$f":"O3*$B3/1000","v":383.45454545454544},{"$f":"P3*$B3/1000","v":266},{"$f":"Q3*$B3/1000","v":1727.1},null,null,{"$f":"B3*D3/1000","v":8470.2000000000007},{"$f":"$AC3*25%+75%*$B3*$D3/1000","v":6946.7886363636362},{"$f":"$AC3*50%+50%*$B3*$D3/1000","v":5423.3772727272735},{"$f":"$AC3*75%+25%*$B3*$D3/1000","v":3899.965909090909},{"$f":"N3*B3/1000","v":2376.5545454545454},null,null,{"$f":"E3*100/$D3","v":49.798115746971739},{"$f":"F3*100/$D3","v":9.4212651413189779},{"$f":"G3*100/$D3","v":40.780619111709285}]
["Detached ",{"$f":"33","v":33},null,62500,{"$f":"AF$4*$D4","v":31250},6250,25000,null,{"$f":"D4*$B4/1000","v":2062.5},{"$f":"E4*$B4/1000","v":1031.25},{"$f":"F4*$B4/1000","v":206.25},{"$f":"G4*$B4/1000","v":825},null,{"$f":"O4+P4+Q4","v":17424.242424242424},{"$f":"E4/11","v":2840.909090909091},{"$f":"F4/3","v":2083.3333333333335},{"$f":"G4/2","v":12500},null,{"$f":"N4*$B4/1000","v":575},{"$f":"O4*$B4/1000","v":93.75},68.75,412.5,null,null,{"$f":"B4*D4/1000","v":2062.5},{"$f":"$AC4*25%+75%*$B4*$D4/1000","v":1690.625},{"$f":"$AC4*50%+50%*$B4*$D4/1000","v":1318.75},{"$f":"$AC4*75%+25%*$B4*$D4/1000","v":946.875},{"$f":"N4*B4/1000","v":575},null,null,0.5,0.1,0.4]
["Mid-terrace",75,null,36000,18000,3600,14400,null,2700,1350,270,1080,null,10036.363636363636,{"$f":"E5/11","v":1636.3636363636363},1200,7200,null,752.72727272727275,122.72727272727272,90,540,null,null,{"$f":"B5*D5/1000","v":2700},{"$f":"$AC5*25%+75%*$B5*$D5/1000","v":2213.181818181818},{"$f":"$AC5*50%+50%*$B5*$D5/1000","v":1726.3636363636365},{"$f":"$AC5*75%+25%*$B5*$D5/1000","v":1239.5454545454545},{"$f":"N5*B5/1000","v":752.72727272727275}]
["Ground/mid-floor flat",82,null,30240,15120,3024,12096,null,2479.6799999999998,1239.8399999999999,247.96799999999999,991.87199999999996,null,8430.545454545454,{"$f":"E6/11","v":1374.5454545454545},1008,6048,null,691.30472727272718,112.71272727272726,82.656000000000006,495.93599999999998,null,null,{"$f":"B6*D6/1000","v":2479.6799999999998},{"$f":"$AC6*25%+75%*$B6*$D6/1000","v":2032.5861818181818},{"$f":"$AC6*50%+50%*$B6*$D6/1000","v":1585.4923636363635},{"$f":"$AC6*75%+25%*$B6*$D6/1000","v":1138.3985454545455},{"$f":"N6*B6/1000","v":691.30472727272718}]
["Top-floor flat",57,null,30500,15250,3050,12200,null,1738.5,869.25,173.85,695.4,null,8503.0303030303039,{"$f":"E7/11","v":1386.3636363636363},1016.6666666666666,6100,null,484.67272727272729,79.022727272727266,57.95,347.7,null,null,{"$f":"B7*D7/1000","v":1738.5},{"$f":"$AC7*25%+75%*$B7*$D7/1000","v":1425.0431818181819},{"$f":"$AC7*50%+50%*$B7*$D7/1000","v":1111.5863636363636},{"$f":"$AC7*75%+25%*$B7*$D7/1000","v":798.12954545454545},{"$f":"N7*B7/1000","v":484.67272727272729}]
[null,null,null,null,null,null,null,"Total (MWh/year)",{"$f":"SUM(I3:I7)","v":17450.88},{"$f":"SUM(J3:J7)","v":8708.34},1696.068,7046.4719999999998,null,null,null,null,null,"Total",{"$f":"SUM(S3:S7)","v":4880.2592727272731},{"$f":"SUM(T3:T7)","v":791.66727272727269},{"$f":"SUM(U3:U7)","v":565.35599999999999},{"$f":"SUM(V3:V7)","v":3523.2359999999999},null,"Total",{"$f":"SUM(Y3:Y7)","v":17450.88},14308.224818181818,11165.569636363636,8022.9144545454546,{"$f":"SUM(AC3:AC7)","v":4880.2592727272731}]
[null,null,null,null,null,null,null,"Average",{"$f":"I8/475","v":36.738694736842106},{"$f":"J8/475","v":18.333347368421052},{"$f":"K8/475","v":3.5706694736842106},{"$f":"L8/475","v":14.834677894736842},null,null,null,null,null,"Average",{"$f":"S8/475","v":10.27423004784689},{"$f":"T8/475","v":1.6666679425837321},{"$f":"U8/475","v":1.1902231578947369},{"$f":"V8/475","v":7.417338947368421}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S8/475","v":10.27423004784689}]

{"sheet":"EVERY EPC","index":1,"n_rows":337,"n_cols":52,"rows_kept":337,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy usage (kWh/year)","Emmissions (kgCO2/year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Post retrofit values"]
["PH50 4QT","GREYMARES",2018,"Detached",102,78,80,87,89,86,19,{"$f":"J2*E2","v":8772},{"$f":"K2*E2","v":1938},"Boilers + Radiators + Oil","HP Glazing","Boiler",0.19,0.08,null,null,null,"No.","%",null,"Energy","Area",null,"Ave energy","Ave floor area","Ave energy dem house kWh/year","Yearly demand of all houses","Average housing demand kW",null,null,null,null,"Heating demand kWh/m2","Ave heating demand per house kWh/year","Average Electrical heating demand house kWh/year","Electrical demand per house appliances kWh/year","Hot water","Ave housing elec demand kWh/year","Total housing demand (kWh)","Average power for housing (kW)",null,null,null,null,null,"ave mpg","ave gallons per year","Ave kWh of petrol per year"]
["PH50 4RA","TIGH NA SITH",2013,"Detached",196,76,88,68,82,122,30,{"$f":"J3*E3","v":23912},{"$f":"K3*E3","v":5880},"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","300mm Loft Insulation",null,1,"End-Terrace/Semi-Detached",{"$f":"COUNTIF(D:D,\"Semi-Detached\")+COUNTIF(D:D,\"End-Terrace\")","v":162},{"$f":"(V3/V8)*100","v":48.214285714285715},{"$f":"W3*475/100","v":229.01785714285714},null,null,null,{"$f":"AVERAGE(J2:J337)","v":471.22023809523807},{"$f":"AVERAGE(E2:E337)","v":81.18154761904762},{"$f":"AVERAGE(L2:L337)","v":36735.297619047618},{"$f":"SUM(L2:L337)*475/COUNT(L2:L337)","v":17449266.369047619},{"$f":"AE3/(365*24)","v":1991.925384594477},null,null,null,null,40,{"$f":"AK3*AC3","v":3247.2619047619046},{"$f":"AL3/3","v":1082.4206349206349},3000,{"$f":"4*365","v":1460},{"$f":"AM3+AN3+AO3","v":5542.4206349206352},{"$f":"AP3*475","v":2632649.8015873018},{"$f":"AQ3/(365*24)","v":300.53079926795681},null,10000,{"$f":"AT3/365","v":27.397260273972602},{"$f":"140/AU3","v":5.1100000000000003},null,40,{"$f":"AT3/AX3","v":250},{"$f":"45.5*10^6*4.5*0.71/1000","v":145372.5}]
["PH50 4RT",4,2017,"Detached",133,79,89,91,99,149,11,19817,1463,"Boilers + Radiators + Wood","HP Glazing","Boiler",0.15,0.14000000000000001,null,2,"Top Flat",{"$f":"COUNTIF(D:D,\"Top-Floor Flat\")","v":40},{"$f":"(V4/V8)*100","v":11.904761904761903},{"$f":"W4*475/100","v":56.547619047619037},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ev yearly"]
["PH50 4RT",1,2018,"Detached",138,76,103,79,103,153,25,21114,3450,"ASHP + Electric","HP Glazing","Electric Immersion",0.14000000000000001,0.14000000000000001,null,3,"Ground/Mid Flat",{"$f":"COUNTIF(D:D,\"Ground-Floor Flat\")+COUNTIF(D:D,\"Mid-Floor Flat\")","v":58},{"$f":"(V5/V8)*100","v":17.261904761904763},81.99404761904762]
["PH50 4QU",3,2012,"Semi-Detached",136,70,72,60,62,159,40,21624,5440,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,4,"Mid-terrace",{"$f":"COUNTIF(D:D,\"Mid-Terrrace\")","v":53},{"$f":"(V6/V8)*100","v":15.773809523809524},74.925595238095241,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,930000,{"$f":"(AQ3+AQ6)/(8760)","v":406.69518282960064}]
["PH50 4SE","Levenside",2013,"Semi-Detached",170,67,82,56,73,175,43,29750,7310,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation",null,5,"Detached",{"$f":"COUNTIF(D:D,\"Detached\")","v":23},{"$f":"(V7/V8)*100","v":6.8452380952380958},32.514880952380956]
["PH50 4RT",8,2017,"Semi-Detached",91,74,89,77,90,181,31,16471,2821,"ASHP + Electric","HP Glazing","Electric Immersion",0.17,0.14000000000000001,null,null,null,{"$f":"SUM(V3:V7)","v":336},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR6*8760","v":3562649.8015873018}]
["PH50 4RT",7,2017,"Semi-Detached",92,74,89,77,90,181,31,16652,2852,"ASHP + Electric","HP Glazing","Electric Immersion",0.17,0.14000000000000001,null,null,"NO WALL INSULATION",{"$f":"COUNTIF(Q:Q,\"Cavity wall no insulation\")+COUNTIF(Q:Q,\"solid Brick no insulation\") +COUNTIF(Q:Q,\"Timber frame, no insulation\")+COUNTIF(Q:Q,\"Granite, no insulation\")+COUNT(Q:Q,\"Sandstone, no insulation\")","v":86},{"$f":"(V9/V8)*100","v":25.595238095238095}]
["PH50 4QL","LOCHSIDE COTTAGE",2014,"Detached",127,68,86,59,78,183,43,23241,5461,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","300mm Loft Insulation",null,null,"NO ROOF INSULATION ",{"$f":"COUNTIF(R:R,\"no insulation\")","v":31},{"$f":"(V10/V8)*100","v":9.2261904761904763}]
["PH50 4RA",19,2010,"Semi-Detached",97,68,71,56,60,201,44,19497,4268,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,"SINGLE GLAZING",{"$f":"COUNTIF(O:O, \"Single Glazing\")","v":5},{"$f":"(V11/V8)*100","v":1.4880952380952379}]
["PH50 4RA","THE STEADINGS",2009,"Semi-Detached",149,61,63,56,57,209,42,31141,6258,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill ","200mm Loft Insulation",null,null,"HP GLAZING",{"$f":"COUNTIF(O:O,\"HP Glazing\")","v":5},{"$f":"(V12/V8)*100","v":1.4880952380952379}]
["PH50 4RA","TIGH AN T SAOIR ",2013,"Detached",118,64,84,63,76,210,52,24780,6136,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","100mm Loft insulation",null,null,"HEAT PUMP ",{"$f":"COUNTIF(N:N,\"ASHP + Electric\")","v":30},{"$f":"(V13/V8)*100","v":8.9285714285714288}]
["PH50 4QX",19,2018,"Mid-terrrace",92,69,83,63,77,210,54,19320,4968,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","270mm Loft Insulation"]
["PH50 4QX",23,2014,"Semi-Detached",116,64,79,53,70,210,51,24360,5916,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4QX","Eakie House",2017,"Detached",85,58,72,70,82,217,47,18445,3995,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","400mm loft Insulation"]
["PH50 4QP",15,2018,"Mid-terrrace",69,71,88,65,83,219,57,15111,3933,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4QR",1,2014,"Semi-Detached",82,65,84,54,74,223,56,18286,4592,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QT",5,2014,"Semi-Detached",94,64,84,63,85,223,42,20962,3948,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",6,2018,"Semi-Detached",98,66,82,59,75,228,60,22344,5880,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4QS","Police House",2016,"Detached",129,66,98,70,99,229,39,29541,5031,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QW","THE OLD POLICE HOUSE ",2016,"Detached",129,66,98,70,99,229,39,29541,5031,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4SE","Allengrange",2018,"Semi-Detached",175,63,74,54,67,230,60,40250,10500,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RD",14,2014,"Semi-Detached",77,69,84,67,83,231,41,17787,3157,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RH",8,2018,"Semi-Detached",94,66,83,59,76,231,60,21714,5640,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4QX",24,2018,"Semi-Detached",193,61,74,55,69,231,57,44583,11001,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","50mm loft Insulation"]
["PH50 4QH",11,2012,"Mid-terrrace",69,66,67,52,54,235,60,16215,4140,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4SE","The Moorings ",2016,"Semi-Detached",173,62,75,53,68,235,62,40655,10726,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RH",1,2018,"Semi-Detached",112,64,80,56,73,236,62,26432,6944,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4QS",7,2015,"End-terrace",110,65,79,58,72,237,61,26070,6710,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QW",6,2014,"Semi-Detached",71,65,85,54,76,238,59,16898,4189,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","25mm Loft insulation"]
["PH50 4QX",9,2018,"End-terrace",88,70,86,73,87,239,40,21032,3520,"GSHP + Electric","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4QT",1,2010,"Semi-Detached",97,61,63,55,56,240,49,23280,4753,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4SE","Tigh Na Cheo Garbhein",2011,"Detached",452,22,36,43,55,243,50,109836,22600,"Boilers + Radiators + Oil","Double Glazing","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4RA",18,2014,"Semi-Detached",82,63,83,46,70,246,68,20172,5576,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4RQ",41,2017,"Semi-Detached",130,63,75,55,67,246,63,31980,8190,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill ","300mm Loft Insulation"]
["PH50 4RD",13,2014,"Semi-Detached",77,68,83,65,80,247,44,19019,3388,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RZ",15,2014,"Top-floor Flat",58,71,71,65,65,249,48,14442,2784,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",16,2014,"Semi-Detached",96,64,82,91,104,250,10,24000,960,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","100mm Loft insulation"]
["PH50 4QT","TIGH-AN-RUDHA",2011,"Detached",161,52,55,40,42,251,62,40411,9982,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QX",26,2010,"Semi-Detached",97,62,63,51,52,251,54,24347,5238,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QR",6,2018,"Semi-Detached",71,50,71,66,83,255,55,18105,3905,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity Fill","350mm Loft Insulation"]
["PH50 4RD",1,2014,"Semi-Detached",76,67,83,64,79,256,45,19456,3420,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RR",12,2014,"End-terrace",99,57,82,47,75,260,61,25740,6039,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RH",5,2019,"Semi-Detached",98,62,83,53,76,261,69,25578,6762,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4RH",6,2019,"Semi-Detached",98,62,83,53,76,261,69,25578,6762,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4QP",3,2015,"Semi-Detached",86,47,95,63,103,261,56,22446,4816,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","75mm loft Insulation"]
["PH50 4QJ",10,2013,"Semi-Detached",87,61,75,57,71,262,51,22794,4437,"Boilers + Radiators ","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RD",4,2014,"Semi-Detached",76,66,82,62,78,263,47,19988,3572,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill ","250mm Loft insulation"]
["PH50 4RA",22,2018,"Semi-Detached",98,64,82,55,76,263,67,25774,6566,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4RS",7,2012,"Top-floor Flat",56,72,75,54,56,267,65,14952,3640,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",14,2018,"Semi-Detached",98,69,85,67,84,267,45,26166,4410,"ASHP + Electric","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RD",3,2014,"Semi-Detached",75,66,82,62,78,268,47,20100,3525,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RN",4,2013,"Semi-Detached",102,73,83,57,70,270,48,27540,4896,"Electric Storage","Double Glazed","Boiler","Timber Insulated","300mm Loft Insulation"]
["PH50 4RR",16,2014,"End-terrace",72,58,79,62,81,274,49,19728,3528,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RN",6,2014,"Semi-Detached",103,70,81,56,69,277,49,28531,5047,"Electric Storage","Double Glazed","Boiler","Timber Insulated","200mm Loft Insulation"]
["PH50 4RP",16,2014,"Mid-terrrace",59,61,87,64,89,277,49,16343,2891,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QH",5,2016,"Semi-Detached",91,60,76,53,69,282,69,25662,6279,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QH",3,2015,"Semi-Detached",89,59,103,51,95,283,74,25187,6586,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","100mm Loft insulation"]
["PH50 4RU",20,2013,"Ground-floor Flat",56,62,76,51,69,283,70,15848,3920,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4QR",18,2019,"Semi-Detached",70,45,69,62,82,284,62,19880,4340,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4QW",7,2014,"Semi-Detached",107,51,88,40,79,284,71,30388,7597,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","No insulation"]
["PH50 4QH",8,2018,"Semi-Detached",92,45,65,60,77,285,59,26220,5428,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",4,2011,"End-terrace",69,45,48,45,48,288,70,19872,4830,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4QP",11,2011,"End-terrace",85,53,57,41,45,288,72,24480,6120,"Boliers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","No insulation"]
["PH50 4RQ",31,2015,"Semi-Detached",76,59,80,51,73,293,77,22268,5852,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QL","SCHOOL LODGE ",2013,"Detached",124,68,83,51,68,298,53,{"$f":"J67*E67","v":36952},{"$f":"K67*E67","v":6572},"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",7,2010,"Semi-Detached",84,57,62,45,50,300,65,25200,5460,"Boilers + Radiators + Coal","Double Glazed","Boiler","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4SB",3,2016,"End-terrace",133,51,94,43,85,302,80,40166,10640,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick internal insulation","200mm Loft Insulation"]
["PH50 4RR",11,2013,"Mid-terrrace",73,61,84,53,77,304,59,22192,4307,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","100mm Loft insulation"]
["PH50 4SE","Argus",2014,"Detached",285,34,50,90,97,306,9,87210,2565,"Boilers + Radiators + Wood","Single Glazing","Boiler","Timber frame, no insulation","300mm Loft Insulation"]
["PH50 4QW",1,2018,"Semi-Detached",69,61,81,52,73,311,80,21459,5520,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QJ",8,2016,"Semi-Detached",78,59,80,51,72,315,80,24570,6240,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RU",8,2013,"Top-floor Flat",78,51,52,54,54,318,57,24804,4446,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4QR",11,2017,"Semi-Detached",68,58,84,50,77,318,83,21624,5644,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RZ",20,2010,"Top-floor Flat",56,74,75,62,62,320,51,17920,2856,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",5,2010,"Semi-Detached",84,54,55,43,44,320,69,26880,5796,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4QY",8,2017,"Semi-Detached",60,62,84,66,85,325,55,19500,3300,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RG",5,2014,"Semi-Detached",44,65,90,64,89,325,57,14300,2508,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RG",7,2013,"Semi-Detached",44,61,86,64,87,325,57,14300,2508,"ASHP + Electric","Double Glazed","Boiler","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4QR",3,2014,"Semi-Detached",66,55,73,40,54,325,84,21450,5544,"Boilers + Radiators","Double Glazed","Boiler","Cavity wall no insulation","No insulation"]
["PH50 4GZ",3,2017,"Semi-Detached",59,61,83,66,85,326,55,19234,3245,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RG",8,2014,"Semi-Detached",43,67,88,63,85,326,58,14018,2494,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill ","250mm Loft insulation"]
["PH50 4QY",5,2017,"Semi-Detached",59,62,83,66,85,327,55,19293,3245,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RF",11,2017,"Semi-Detached",85,57,74,62,77,328,56,27880,4760,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",36,2017,"Semi-Detached",94,59,76,87,98,329,19,30926,1786,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RF",14,2017,"Semi-Detached",84,57,74,62,77,330,56,27720,4704,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4RZ",16,2010,"Top-floor Flat",60,72,72,59,59,332,53,19920,3180,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",14,2016,"Semi-Detached",92,60,79,52,70,334,71,30728,6532,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4QH","THE OLD SURGERY",2018,"Detached",101,62,74,59,73,335,57,33835,5757,"ASHP + Electric","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RH",3,2018,"Semi-Detached",90,51,67,43,56,335,88,30150,7920,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4RR",8,2016,"End-terrace",72,57,77,50,70,336,82,24192,5904,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4SE","Garbhein Cottage",2014,"Detached",85,30,46,41,55,336,75,28560,6375,"Boilers + Radiators + Oil","Double Glazed","Boiler","Granite, internal insulation","200mm Loft Insulation"]
["PH50 4QH",15,2015,"Mid-terrrace",85,50,108,43,100,338,88,28730,7480,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","75mm loft Insulation"]
["PH50 4RY",4,2013,"Top-floor Flat",58,66,67,54,56,341,63,19778,3654,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","250mm Loft insulation"]
["PH50 4RR",5,2017,"End-terrace",72,55,79,46,70,342,88,24624,6336,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no Insulation","270mm Loft Insulation"]
["PH50 4RQ",23,2018,"Semi-Detached",98,58,77,52,71,346,72,33908,7056,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","200mm Loft Insulation"]
["PH50 4RS",13,2010,"Mid-terrrace",55,42,42,61,61,350,53,19250,2915,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RU",46,2018,"Mid-floor Flat",81,57,76,61,60,351,59,28431,4779,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RQ",11,2017,"Mid-terrrace",92,57,73,90,100,352,14,32384,1288,"Boilers + Radiators + Wood","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4SD",17,2015,"Ground-floor Flat",59,54,71,46,65,354,92,20886,5428,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RS",11,2014,"Mid-terrrace",62,50,64,54,67,356,63,22072,3906,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",15,2012,"End-terrace",91,52,56,45,49,357,63,32487,5733,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","75mm loft Insulation"]
["PH50 4RQ",47,2017,"Mid-terrrace",94,49,98,43,90,359,89,33746,8366,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RH",11,2018,"End-terrace",98,57,77,51,69,361,76,35378,7448,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RZ",9,2010,"Top-floor Flat",57,55,59,38,42,362,91,20634,5187,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RY",10,2010,"Top-floor Flat",57,55,59,38,42,362,91,20634,5187,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RU",50,2017,"Top-floor Flat",72,60,72,51,66,364,78,26208,5616,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RZ",11,2014,"Top-floor Flat",54,69,71,54,55,365,65,19710,3510,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4SE","Garbhein House",2009,"Detached",320,28,31,27,28,366,76,117120,24320,"Boilers + Radiators + Oil","Single Glazing","Electric Immersion","Cavity wall no Insulation","No insulation"]
["PH50 4QR",13,2014,"Semi-Detached",72,52,83,41,73,367,102,26424,7344,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4QX",22,2018,"Semi-Detached",103,44,76,37,68,367,97,37801,9991,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall, no insulation","200mm Loft Insulation"]
["PH50 4RX",10,2018,"Ground-floor Flat",52,58,74,51,59,368,88,19136,4576,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RZ",8,2009,"Top-floor Flat",53,69,69,60,60,369,56,19557,2968,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RB",8,2015,"Top-floor Flat",51,78,80,66,69,375,63,19125,3213,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RS",41,2018,"Mid-terrrace",63,59,82,63,84,376,64,23688,4032,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",23,2010,"Mid-terrrace",63,35,35,56,56,376,100,23688,6300,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4SE","Ossian",2014,"Detached",108,37,81,26,67,379,101,40932,10908,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no Insulation","No insulation"]
["PH50 4RQ",55,2010,"Semi-Detached",100,40,44,28,31,380,94,38000,9400,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RY",1,2010,"Top-floor Flat",58,63,64,57,57,381,57,22098,3306,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4QR",16,2014,"Semi-Detached",100,57,79,43,63,381,68,38100,6800,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RQ",12,2018,"Semi-Detached",91,45,62,41,53,381,93,34671,8463,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RB",26,2015,"Top-floor Flat",53,78,79,64,67,382,65,20246,3445,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RQ",18,2011,"Semi-Detached",79,59,61,43,45,386,70,30494,5530,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",37,2013,"End-terrace",62,55,81,46,70,388,76,24056,4712,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4QX",17,2010,"End-terrace",97,55,56,48,48,388,59,37636,5723,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",20,2010,"End-terrace",97,56,56,48,48,388,58,37636,5626,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",39,2010,"Semi-Detached",90,41,45,28,32,389,97,35010,8730,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",1,2017,"End-terrace",73,56,76,86,98,390,23,28470,1679,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RU",36,2010,"Top-floor Flat",78,52,61,48,59,391,62,30498,4836,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",39,2017,"Mid-terrrace",62,56,78,60,80,392,66,{"$f":"J131*E131","v":24304},{"$f":"K131*E131","v":4092},"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","350mm Loft Insulation"]
["PH50 4RU",28,2014,"Mid-floor Flat",80,41,42,44,45,392,71,31360,5680,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RS",19,2014,"Mid-terrrace",59,56,75,50,69,394,70,23246,4130,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QR",14,2015,"Semi-Detached",72,46,81,39,73,400,106,28800,7632,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RQ",3,2017,"Semi-Detached",91,51,69,84,95,400,23,36400,2093,"Boilers + Radiators + Wood","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4RS",43,2010,"Mid-terrrace",59,42,42,54,54,400,61,23600,3599,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4SD",1,2009,"Ground-floor Flat",44,67,69,60,60,402,59,17688,2596,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RS",29,2010,"Mid-terrrace",64,40,40,63,63,403,61,25792,3904,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QJ",21,2014,"Semi-Detached",79,37,61,44,64,405,72,31995,5688,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QR",10,2015,"Semi-Detached",85,42,100,40,91,405,93,34425,7905,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RP","Flat 2 FF",2013,"Mid-floor Flat",58,68,80,49,69,407,72,23606,4176,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RQ",10,2018,"Semi-Detached",91,42,63,37,54,409,101,37219,9191,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","270mm Loft Insulation"]
["PH50 4RH",10,2017,"Semi-Detached",90,42,83,38,72,410,100,36900,9000,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no Insulation","No insulation"]
["PH50 4RX",2,2010,"Ground-floor Flat",57,49,53,32,36,411,104,23427,5928,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RZ",22,2010,"Ground-floor Flat",60,65,66,50,50,411,66,24660,3960,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",52,2014,"Ground-floor Flat",62,50,58,44,50,411,79,25482,4898,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no isulation","n/a"]
["PH50 4RQ",32,2010,"Semi-Detached",105,56,57,40,40,412,69,43260,7245,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4SA",8,2010,"Ground-floor Flat",57,48,53,32,36,412,105,23484,5985,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill ","n/a"]
["PH50 4QS",9,2011,"Mid-terrrace",90,51,53,42,44,413,69,37170,6210,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4QT",4,2015,"Semi-Detached",85,41,103,40,94,413,95,35105,8075,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity Fill","50mm loft insulation"]
["PH50 4QP",4,2015,"Semi-Detached",79,42,79,36,71,414,109,32706,8611,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","No insulation"]
["PH50 4QJ",14,2017,"Semi-Detached",103,38,75,35,69,416,103,42848,10609,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4RP",11,2017,"End-terrace",61,51,74,57,77,417,70,25437,4270,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RS",31,2017,"Mid-terrrace",60,53,76,58,79,419,71,25140,4260,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4RF",15,2009,"Semi-Detached",70,36,38,85,86,422,19,29540,1330,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RP","Flat 1 FF",2013,"Mid-floor Flat",58,62,75,48,67,422,75,24476,4350,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RS",9,2014,"End-terrace",61,41,57,47,61,425,75,25925,4575,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill ","300mm Loft Insulation"]
["PH50 4RS",21,2014,"Mid-terrrace",59,41,68,47,71,426,75,25134,4425,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4SD",8,2017,"Mid-floor Flat",56,54,80,59,68,426,72,23856,4032,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RZ",1,2013,"Top-floor Flat",58,50,69,43,64,427,82,24766,4756,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RD",12,2014,"End-terrace",75,33,57,88,104,430,14,32250,1050,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4QJ",1,2017,"Semi-Detached",85,42,62,32,44,431,123,36635,10455,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RG",6,2014,"Semi-Detached",46,59,84,63,86,432,73,19872,3358,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4SD",14,2009,"Top-floor Flat",61,51,51,51,51,432,64,26352,3904,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QS",10,2010,"End-terrace",102,45,49,40,43,433,70,44166,7140,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","75mm loft Insulation"]
["PH50 4RU",6,2017,"Ground-floor Flat",56,52,55,57,60,435,74,24360,4144,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4QY",3,2017,"Semi-Detached",58,51,79,56,81,438,74,25404,4292,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4SD",5,2017,"Mid-floor Flat",57,74,81,57,70,441,75,25137,4275,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RP",18,2017,"Mid-terrrace",60,49,69,55,73,444,75,26640,4500,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RY",6,2010,"Top-floor Flat",57,64,64,48,48,444,72,25308,4104,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RU",12,2014,"Ground-floor Flat",57,40,51,45,54,445,80,25365,4560,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4QW",16,2015,"End-terrace",107,35,51,32,43,445,110,47615,11770,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RZ",7,2011,"Top-floor Flat",58,66,74,40,50,446,85,25868,4930,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","50mm loft insulation"]
["PH50 4RS",53,2010,"End-terrace",67,33,33,47,47,448,67,30016,4489,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",7,2015,"Semi-Detached",98,34,87,29,75,453,121,44394,11858,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber frame, no insulation","75mm loft Insulation"]
["PH50 4QY",7,2010,"Semi-Detached",58,42,47,27,31,454,126,26332,7308,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",20,2010,"Semi-Detached",84,43,43,43,43,456,68,38304,5712,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP",4,2010,"Mid-terrrace",64,59,59,45,45,458,74,29312,4736,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RB",24,2015,"Ground-floor Flat",53,74,79,57,67,459,78,24327,4134,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RF",8,2016,"Mid-terrrace",83,55,85,51,68,460,78,38180,6474,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RR",9,2013,"Semi-Detached",72,47,71,37,60,464,89,33408,6408,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RU",16,2013,"Ground-floor Flat",50,41,52,46,55,464,83,23200,4150,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RD",10,2014,"End-terrace",75,63,79,39,57,465,82,34875,6150,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4SA",7,2010,"Ground-floor Flat",57,30,30,49,49,465,70,26505,3990,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",6,2015,"Ground-floor Flat",51,74,79,58,68,466,79,23766,4029,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",20,2013,"Top-floor Flat",60,65,77,42,61,468,83,28080,4980,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4QP",23,2015,"Semi-Detached",85,33,103,33,94,469,111,39865,9435,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","200mm Loft insulation"]
["PH50 4RB",13,2015,"Ground-floor Flat",52,74,79,56,67,471,80,24492,4160,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RD",8,2011,"Mid-terrrace",74,43,56,37,47,472,92,34928,6808,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4SD",3,2013,"Top-floor Flat",56,37,38,43,44,476,85,26656,4760,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RP",19,2010,"Mid-terrrace",64,45,45,46,46,478,"72 kg/m2",30592,{"$error":"#VALUE!"},"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",53,2015,"Semi-Detached",85,32,103,32,94,478,113,40630,9605,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","75mm loft Insulation"]
["PH50 4RQ",45,2015,"Semi-Detached",85,32,103,32,93,479,118,40715,10030,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","50mm loft insulation"]
["PH50 4RY",8,2010,"Top-floor Flat",57,49,50,45,45,483,77,27531,4389,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RU",38,2013,"Ground-floor Flat",81,28,35,36,42,483,86,{"$f":"J195*E195","v":39123},{"$f":"K195*E195","v":6966},"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RZ",13,2017,"Top-floor Flat",59,72,74,53,56,485,82,28615,4838,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4RA",21,2018,"Mid-terrrace",83,32,74,29,65,485,128,40255,10624,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","25mm Loft insulation"]
["PH50 4RP",8,2013,"Mid-terrrace",64,34,60,39,60,486,88,31104,5632,"Electric Storage ","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4SB",2,2016,"Mid-terrrace",109,31,83,22,63,489,140,53301,15260,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","150mm Loft insulation"]
["PH50 4RX",9,2015,"Ground-floor Flat",56,52,65,44,58,489,105,27384,5880,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4QW",4,2013,"Semi-Detached",70,55,80,38,59,491,87,34370,6090,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RS",15,2010,"End-terrace",63,23,23,45,45,491,73,30933,4599,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP",5,2010,"Mid-terrrace",64,43,44,44,44,494,74,31616,4736,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RU",10,2017,"Ground-floor Flat",60,48,76,48,57,494,91,29640,5460,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RP",12,2013,"Mid-terrrace",58,65,87,40,63,496,89,28768,5162,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RX",6,2009,"Ground-floor Flat",55,53,55,47,47,496,75,27280,4125,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RS",33,2013,"Mid-terrrace",58,64,87,40,63,501,90,29058,5220,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RS",17,2010,"End-terrace",63,30,30,44,44,503,75,31689,4725,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4SA",2,2010,"Ground-floor Flat",57,48,48,45,45,503,75,28671,4275,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4QH",2,2015,"Semi-Detached",49,40,119,35,110,505,133,24745,6517,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","50mm loft insulation"]
["PH50 4RQ",13,2009,"End-terrace",172,35,41,31,35,506,76,87032,13072,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","50mm loft insulation"]
["PH50 4RP",14,2013,"Mid-terrrace",60,64,85,39,60,507,91,30420,5460,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RX",3,2010,"Ground-floor Flat",57,54,54,45,45,507,76,28899,4332,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RQ",37,2015,"Semi-Detached",94,60,75,48,65,508,86,47752,8084,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RZ",24,2010,"End-terrace",76,44,44,38,38,508,82,38608,6232,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RX",5,2010,"Ground-floor Flat",57,53,54,45,45,508,77,28956,4389,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",4,2010,"Ground-floor Flat",57,53,54,45,45,508,77,28956,4389,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SE","Tigh-Na-Fleasgach",2019,"Semi-Detached",144,32,87,86,112,510,18,73440,2592,"Boilers + Radiators + Wood","Double Glazed","Boiler","Sandstone, no insulation","300mm Loft Insulation"]
["PH50 4RX",8,2010,"Ground-floor Flat",57,58,59,42,42,510,82,29070,4674,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",5,2010,"Ground-floor Flat",57,58,59,42,42,510,82,29070,4674,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",6,2010,"Ground-floor Flat",57,58,59,42,42,510,82,29070,4674,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4QP",7,2014,"Mid-terrrace",70,60,90,36,74,516,91,36120,6370,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","50mm loft insulation"]
["PH50 4SD",6,2017,"Top-floor Flat",50,71,76,53,63,520,88,26000,4400,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4GZ",5,2017,"Semi-Detached",60,47,80,42,73,521,108,31260,6480,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no Insulation","300mm Loft Insulation"]
["PH50 4RS",47,2017,"Mid-terrrace",63,44,66,88,101,521,20,32823,1260,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RR",7,2018,"Mid-terrrace",70,69,87,48,69,526,89,36820,6230,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RQ",34,2012,"Semi-Detached",93,42,43,29,30,526,94,48918,8742,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RP",7,2017,"Mid-terrrace",60,45,68,88,102,526,20,31560,1200,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4QH",4,2014,"Semi-Detached",92,22,54,30,55,529,95,48668,8740,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RZ",6,2010,"Ground-floor Flat",46,61,62,45,45,531,86,24426,3956,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RZ",14,2010,"Ground-floor Flat",46,61,62,45,45,531,86,24426,3956,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4QS",8,2016,"Mid-terrrace",89,63,83,44,64,537,92,47793,8188,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RU",54,2014,"Ground-floor Flat",69,39,47,32,39,540,100,37260,6900,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RZ",10,2013,"Ground-floor Flat",47,66,74,41,52,542,97,25474,4559,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RQ",21,2018,"Semi-Detached",98,58,85,42,68,543,92,53214,9016,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RU",44,2016,"Ground-floor Flat",81,37,50,41,51,544,97,44064,7857,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RS",5,2013,"Ground-floor Flat",46,35,47,39,49,546,102,25116,4692,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",27,2015,"Semi-Detached",92,65,77,43,54,549,93,50508,8556,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RX",4,2010,"Ground-floor Flat",57,44,45,39,39,549,88,31293,5016,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RZ",12,2015,"Top-floor Flat",54,43,44,49,50,551,95,29754,5130,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",11,2018,"Mid-terrrace",97,57,84,42,67,553,93,53641,9021,"Electric Storage ","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4GZ",7,2010,"Semi-Detached",64,38,40,39,40,555,84,35520,5376,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QP",1,2017,"Semi-Detached",111,36,78,7,112,556,205,61716,22755,"Boilers + Radiators + Coal","Double Glazed","Boiler","Solid Brick no insulation","No insulation"]
["PH50 4RB",13,2015,"Ground-floor Flat",54,68,76,49,61,559,95,30186,5130,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SB",1,2016,"Semi-Detached",112,23,90,17,74,561,159,62832,17808,"Boilers + Radiators + Oil","Double Glazed","Oil range cooker","Cavity wall no Insulation","250mm Loft insulation"]
["PH50 4RU",22,2009,"End-terrace",87,43,43,33,33,570,88,49590,7656,"Electric Storage ","Double Glazed","Electric Immersion","Solid Brick no insulation","n/a"]
["PH50 4QU",2,2016,"Semi-Detached",132,54,93,32,62,573,108,75636,14256,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RP","Flat 3 SF",2013,"Top-floor Flat",58,55,75,35,59,580,103,33640,5974,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RQ",9,2018,"End-terrace",91,28,46,38,54,581,101,52871,9191,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","300mm Loft Insulation"]
["PH50 4RR",13,2014,"End-terrace",75,19,58,30,61,583,103,43725,7725,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","200mm Loft Insulation"]
["PH50 4RB",7,2014,"Top-floor Flat",50,60,70,36,47,584,103,29200,5150,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","250mm Loft insulation"]
["PH50 4SB","Burnside",2017,"Detached",181,16,65,15,55,585,153,105885,27693,"Boilers + Radiators + Oil","Double Glazing","Boiler","Cavity wall no Insulation","No insulation"]
["PH50 4QY",6,2010,"Semi-Detached",64,51,51,35,35,586,94,37504,6016,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",10,2010,"Mid-terrrace",90,37,38,32,32,588,89,52920,8010,"Electric Storage ","Double Glazed","Electric Immersion","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4RB",9,2015,"Ground-floor Flat",51,68,75,48,59,590,100,30090,5100,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",1,2014,"Ground-floor Flat",51,52,59,36,42,590,105,30090,5355,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",1,2015,"Ground-floor Flat",62,37,48,44,53,593,102,36766,6324,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RH",16,2018,"Semi-Detached",98,55,83,39,64,594,100,58212,9800,"Electric Storage ","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4SD",7,2009,"Ground-floor Flat",59,45,56,38,38,594,90,{"$f":"J259*E259","v":35046},{"$f":"K259*E259","v":5310},"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",2,2012,"Mid-floor Flat",57,44,58,32,43,598,105,34086,5985,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",60,2019,"Ground-floor Flat",66,33,73,41,54,602,102,39732,6732,"Electric storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RQ",4,2018,"Mid-terrrace",98,56,83,37,62,604,106,59192,10388,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","200mm Loft Insulation"]
["PH50 4RR",2,2015,"Mid-terrrace",76,32,55,41,59,604,102,45904,7752,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",6,2015,"Mid-terrrace",76,32,55,41,59,604,102,45904,7752,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP","Flat 4 SF",2013,"Top-floor Flat",58,55,70,32,48,605,107,35090,6206,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4QS",2,2016,"Mid-terrrace",84,58,84,40,64,605,102,50820,8568,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",35,2018,"End-terrace",62,36,60,81,96,612,32,37944,1984,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QY",4,2013,"Semi-Detached",59,46,84,32,69,613,108,36167,6372,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4QT","FIRWOOD COTTAGE",2018,"Detached",98,55,84,35,61,620,111,60760,10878,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","250mm Loft insulation"]
["PH50 4RB",25,2014,"Top-floor Flat",53,56,69,33,46,624,110,33072,5830,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","250mm Loft insulation"]
["PH50 4RY",7,2014,"Top-floor Flat",56,53,70,32,49,625,111,35000,6216,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","250mm Loft insulation"]
["PH50 4RU",64,2017,"Top-floor Flat",64,64,75,39,56,636,110,40704,7040,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RB",22,2014,"Top-floor Flat",57,53,69,30,46,639,113,36423,6441,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","200mm Loft Insulation"]
["PH50 4RB",18,2015,"End-terrace",52,66,83,45,60,641,108,33332,5616,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","400mm Loft Insulation"]
["PH50 4QL","MAMORE LODGE ",2016,"Detached",112,43,64,32,49,645,109,72240,12208,"Electric Storage ","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4QH",10,2016,"Semi-Detached",70,58,85,40,66,646,109,45220,7630,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4QP",20,2014,"Semi-Detached",92,38,92,23,58,648,115,59616,10580,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RR",15,2015,"Mid-terrrace",70,57,75,39,56,649,113,45430,7910,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4SD",4,2017,"Ground-floor Flat",43,67,76,46,61,657,111,28251,4773,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4QX",25,2017,"Semi-Detached",94,54,79,34,58,665,112,62510,10528,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4QP",16,2009,"Semi-Detached",78,26,26,29,29,666,100,51948,7800,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RB",2,2015,"Mid-terrrace",50,65,87,44,67,667,113,33350,5650,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RA",17,2014,"Semi-Detached",95,21,91,32,58,667,113,63365,10735,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4QS",3,2018,"Mid-terrrace",90,47,82,34,61,670,113,60300,10170,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RB",4,2018,"End-terrace",52,64,87,41,67,673,114,34996,5928,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RZ",2,2013,"Ground-floor Flat",49,21,28,31,36,680,121,33320,5929,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4QH",17,2016,"Semi-Detached",91,24,54,33,57,687,121,62517,11011,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RP",6,2015,"Mid-terrrace",61,32,54,37,56,687,123,41907,7503,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RD",2,2012,"Semi-Detached",76,10,59,23,62,690,122,52440,9272,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4QR",12,2017,"Semi-Detached",74,55,83,37,62,690,117,51060,8658,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",5,2014,"Ground-floor Flat",50,52,70,30,46,692,123,34600,6150,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RZ",18,2018,"Ground-floor Flat",42,38,72,40,49,695,127,29190,5334,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",13,2009,"Ground-floor Flat",59,37,38,31,31,696,105,41064,6195,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",1,2018,"End-terrace",41,66,91,44,73,699,118,28659,4838,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4QF",3,2015,"Mid-terrrace",63,29,52,38,55,700,122,44100,7686,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP",3,2015,"Mid-terrrace",63,29,52,38,55,700,122,44100,7686,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",27,2018,"Semi-Detached",98,46,76,31,53,705,119,69090,11662,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","200mm Loft Insulation"]
["PH50 4QW",5,2016,"Semi-Detached",70,54,83,36,62,707,119,49490,8330,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RY",5,2014,"Top-floor Flat",57,42,73,26,53,708,125,40356,7125,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","25mm Loft insulation"]
["PH50 4SD",15,2017,"Ground-floor Flat",59,56,73,35,52,709,128,41831,7552,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",19,2014,"Ground-floor Flat",57,47,70,26,47,709,126,40413,7182,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RB",17,2018,"Detached",51,63,86,40,66,712,120,36312,6120,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4QJ",9,2015,"Semi-Detached",76,44,67,34,49,712,124,54112,9424,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",3,2018,"End-terrace",41,65,90,44,72,714,121,29274,4961,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",29,2009,"End-terrace",77,31,32,26,26,718,109,55286,8393,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4RU",26,2015,"Ground-floor Flat",86,41,75,30,58,736,124,63296,10664,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4RB",23,2014,"Ground-floor Flat",53,47,68,26,45,742,131,39326,6943,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4QP",12,2017,"Semi-Detached",81,52,104,31,79,747,126,60507,10206,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",10,2014,"Ground-floor Flat",52,47,68,26,45,748,132,38896,6864,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RB",20,2014,"Ground-floor Flat",57,45,69,24,46,749,133,42693,7581,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4QT","GORTENNAMBEITH",2018,"Semi-Detached",120,42,73,27,48,750,127,90000,15240,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","270mm Loft Insulation"]
["PH50 4QW",2,2014,"Semi-Detached",75,39,81,16,53,751,146,56325,10950,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","75mm loft Insulation"]
["PH50 4QS",6,2015,"Semi-Detached",144,9,96,23,74,759,128,109296,18432,"Electric Storage ","Double Glazed","Electric Immersion","Solid Brick no insulation","50mm loft insulation"]
["PH50 4RS",49,2018,"Mid-terrrace",53,58,88,37,69,770,130,40810,6890,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RU",42,2017,"Top-floor Flat",77,47,59,27,35,799,135,61523,10395,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","No insulation"]
["PH50 4RU",32,2015,"Ground-floor Flat",59,21,57,32,62,803,136,47377,8024,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no isulation","n/a"]
["PH50 4QH",14,2017,"Mid-terrrace",71,17,64,28,66,815,142,57865,10082,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No Insulation"]
["PH50 4RD",6,2015,"Semi-Detached",76,51,80,28,58,817,138,62092,10488,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RP",15,2017,"Mid-terrrace",60,55,84,31,60,824,145,49440,8700,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4QP",5,2015,"End-terrace",82,13,86,26,62,829,140,67978,11480,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RU",48,2017,"Top-floor Flat",80,45,57,25,33,830,140,66400,11200,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",21,2014,"Top-floor Flat",57,40,57,20,32,834,148,47538,8436,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4QJ",20,2016,"Semi-Detached",76,18,45,28,50,835,147,{"$f":"J323*E323","v":63460},{"$f":"K323*E323","v":11172},"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QP",24,2010,"Semi-Detached",78,1,1,19,19,846,127,65988,9906,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","No insulation"]
["PH50 4QW",8,2017,"Semi-Detached",85,10,87,24,71,855,145,72675,12325,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","100mm Loft insulation"]
["PH50 4RB",12,2014,"Top-floor Flat",52,40,57,20,32,855,151,44460,7852,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",11,2014,"Top-floor Flat",52,29,64,19,41,869,154,45188,8008,"Electric Storage ","Single Glazing","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",16,2014,"Top-floor Flat",52,38,57,18,32,894,158,46488,8216,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",15,2014,"Top-floor Flat",52,36,60,18,37,896,159,46592,8268,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4QR",7,2015,"Semi-Detached",112,3,78,18,80,926,157,103712,17584,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","50mm loft insulation"]
["PH50 4SE","Edenmhor",2015,"Detached",271,25,52,11,29,970,158,262870,42818,"Electric Storage ","Single Glazing","Solid fuel range cooker","Granite, no insulation","100mm Loft insulation"]
["PH50 4QJ",2,2010,"Semi-Detached",83,1,12,1,4,994,251,82502,20833,"Electric Storage","Single Glazing","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RP",9,2015,"Mid-terrrace",65,41,70,23,41,1023,173,66495,11245,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4SE","Inverleven ",2018,"Detached",199,23,72,7,46,1030,182,204970,36218,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm lof Insulation"]
["PH50 4QP",21,2016,"Semi-Detached",70,25,87,16,71,1090,184,76300,12880,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QW",10,2015,"Mid-terrrace",67,35,83,19,62,1093,185,73231,12395,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QR",15,2015,"Semi-Detached",70,1,65,11,69,1263,214,88410,14980,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","No insulation"]

{"sheet":"Top-floor flat","index":2,"n_rows":41,"n_cols":34,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy usage (kWh/year)","Emmissions (kgCO2/year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,"Floor Area (m^2)","Energy Efficiency Rating - Current","Environmental Impact Rating - Current","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)",null,null,null,null,"Wall Insulation",null,null,"Roof insulation"]
["PH50 4RZ",15,2014,"Top-floor Flat",58,71,71,65,65,249,48,{"$f":"J2*E2","v":14442},{"$f":"K2*E2","v":2784},"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,{"$f":"AVERAGE(E2:E41)","v":58.6},{"$f":"AVERAGE(F2:F41)","v":56.65},{"$f":"AVERAGE(H2:H41)","v":42.524999999999999},{"$f":"AVERAGE(J2:J54)","v":522.20000000000005},{"$f":"AVERAGE(K2:K54)","v":92.625},{"$f":"AVERAGE(L2:L41)","v":30528.25},null,null,"Cavity fill",{"$f":"COUNTIF(Q2:Q41,\"cavity fill\")","v":19},null,400,{"$f":"COUNTIF(R2:R41,\"400mm loft insulation\")","v":0}]
["PH50 4RS",7,2012,"Top-floor Flat",56,72,75,54,56,267,65,{"$f":"J3*E3","v":14952},{"$f":"K3*E3","v":3640},"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,"Timber frame no insulation",{"$f":"COUNTIF(Q2:Q41,\"timber frame no insulation\")","v":0},null,300,{"$f":"COUNTIF(R$2:R$41,\"300mm loft insulation\")","v":11}]
["PH50 4RU",8,2013,"Top-floor Flat",78,51,52,54,54,318,57,24804,4446,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,"Cavity wall no insulation",{"$f":"COUNTIF(Q2:Q41,\"cavity wall no insulation\")","v":21},null,270,{"$f":"COUNTIF(R$2:R$41,\"270mm loft insulation\")","v":2}]
["PH50 4RZ",20,2010,"Top-floor Flat",56,74,75,62,62,320,51,17920,2856,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,"Timber insulated",{"$f":"COUNTIF(Q2:Q41,\"Timber insulated\")","v":0},null,250,{"$f":"COUNTIF(R$2:R$41,\"250mm loft insulation\")","v":8}]
["PH50 4RZ",16,2010,"Top-floor Flat",60,72,72,59,59,332,53,19920,3180,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,{"$f":"COUNTIF(R$2:R$41,\"200mm loft insulation\")","v":3}]
["PH50 4RY",4,2013,"Top-floor Flat",58,66,67,54,56,341,63,19778,3654,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","250mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,{"$f":"COUNTIF(R$2:R$41,\"150mm loft insulation\")","v":1}]
["PH50 4RZ",9,2010,"Top-floor Flat",57,55,59,38,42,362,91,20634,5187,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,{"$f":"COUNTIF(R$2:R$41,\"100mm loft insulation\")","v":6}]
["PH50 4RY",10,2010,"Top-floor Flat",57,55,59,38,42,362,91,20634,5187,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity wall no insulation","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"COUNTIF(R$2:R$41,\"50mm loft insulation\")","v":6}]
["PH50 4RU",50,2017,"Top-floor Flat",72,60,72,51,66,364,78,26208,5616,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R$2:R$41,\"no insulation\")","v":2}]
["PH50 4RZ",11,2014,"Top-floor Flat",54,69,71,54,55,365,65,19710,3510,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(AH2:AH10)","v":39}]
["PH50 4RZ",8,2009,"Top-floor Flat",53,69,69,60,60,369,56,19557,2968,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"average",{"$f":"(AG2*AH2+AG3*AH3+AG4*AH4+AG5*AH5+AG6*AH6+AG7*AH7+AG8*AH8+AG9*AH9+AG10*AH10)/AH11","v":192.05128205128204}]
["PH50 4RB",8,2015,"Top-floor Flat",51,78,80,66,69,375,63,19125,3213,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RY",1,2010,"Top-floor Flat",58,63,64,57,57,381,57,22098,3306,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4RB",26,2015,"Top-floor Flat",53,78,79,64,67,382,65,20246,3445,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RU",36,2010,"Top-floor Flat",78,52,61,48,59,391,62,30498,4836,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RZ",1,2013,"Top-floor Flat",58,50,69,43,64,427,82,24766,4756,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4SD",14,2009,"Top-floor Flat",61,51,51,51,51,432,64,26352,3904,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RY",6,2010,"Top-floor Flat",57,64,64,48,48,444,72,25308,4104,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RZ",7,2011,"Top-floor Flat",58,66,74,40,50,446,85,25868,4930,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","50mm loft insulation"]
["PH50 4SD",20,2013,"Top-floor Flat",60,65,77,42,61,468,83,28080,4980,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4SD",3,2013,"Top-floor Flat",56,37,38,43,44,476,85,26656,4760,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RY",8,2010,"Top-floor Flat",57,49,50,45,45,483,77,27531,4389,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RZ",13,2017,"Top-floor Flat",59,72,74,53,56,485,82,28615,4838,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4SD",6,2017,"Top-floor Flat",50,71,76,53,63,520,88,26000,4400,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RZ",12,2015,"Top-floor Flat",54,43,44,49,50,551,95,29754,5130,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP","Flat 3 SF",2013,"Top-floor Flat",58,55,75,35,59,580,103,33640,5974,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RB",7,2014,"Top-floor Flat",50,60,70,36,47,584,103,29200,5150,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","250mm Loft insulation"]
["PH50 4RP","Flat 4 SF",2013,"Top-floor Flat",58,55,70,32,48,605,107,35090,6206,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RB",25,2014,"Top-floor Flat",53,56,69,33,46,624,110,33072,5830,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","250mm Loft insulation"]
["PH50 4RY",7,2014,"Top-floor Flat",56,53,70,32,49,625,111,35000,6216,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","250mm Loft insulation"]
["PH50 4RU",64,2017,"Top-floor Flat",64,64,75,39,56,636,110,40704,7040,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RB",22,2014,"Top-floor Flat",57,53,69,30,46,639,113,36423,6441,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","200mm Loft Insulation"]
["PH50 4RY",5,2014,"Top-floor Flat",57,42,73,26,53,708,125,40356,7125,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","25mm Loft insulation"]
["PH50 4RU",42,2017,"Top-floor Flat",77,47,59,27,35,799,135,61523,10395,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","No insulation"]
["PH50 4RU",48,2017,"Top-floor Flat",80,45,57,25,33,830,140,66400,11200,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",21,2014,"Top-floor Flat",57,40,57,20,32,834,148,47538,8436,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",12,2014,"Top-floor Flat",52,40,57,20,32,855,151,44460,7852,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",11,2014,"Top-floor Flat",52,29,64,19,41,869,154,45188,8008,"Electric Storage ","Single Glazing","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",16,2014,"Top-floor Flat",52,38,57,18,32,894,158,46488,8216,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]
["PH50 4RB",15,2014,"Top-floor Flat",52,36,60,18,37,896,159,46592,8268,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm loft Insulation"]

{"sheet":"Mid-floor flat","index":3,"n_rows":8,"n_cols":27,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,"Floor Area (m^2)","Energy Efficiency Rating - Current","Environmental Impact Rating - Current","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)",null,null,"Wall Insulation"]
["PH50 4RU",46,2018,"Mid-floor Flat",81,57,76,61,60,351,59,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a",null,null,null,{"$f":"AVERAGE(E2:E24)","v":63.857142857142854},{"$f":"AVERAGE(F2:F24)","v":57.142857142857146},{"$f":"AVERAGE(H2:H24)","v":50},{"$f":"AVERAGE(J2:J24)","v":433.85714285714283},{"$f":"AVERAGE(K2:K24)","v":75.571428571428569},null,"Cavity fill",{"$f":"COUNTIF(O2:O24,\"cavity fill\")","v":4}]
["PH50 4RU",28,2014,"Mid-floor Flat",80,41,42,44,45,392,71,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a",null,null,null,null,null,null,null,null,null,"Timber frame no insulation",{"$f":"COUNTIF(O2:O24,\"timber frame no insulation\")","v":0}]
["PH50 4RP","Flat 2 FF",2013,"Mid-floor Flat",58,68,80,49,69,407,72,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a",null,null,null,null,null,null,null,null,null,"Cavity wall no insulation",{"$f":"COUNTIF(O2:O24,\"cavity wall no insulation\")","v":3}]
["PH50 4RP","Flat 1 FF",2013,"Mid-floor Flat",58,62,75,48,67,422,75,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a",null,null,null,null,null,null,null,null,null,"Timber insulated",{"$f":"COUNTIF(O2:O24,\"Timber insulated\")","v":0}]
["PH50 4SD",8,2017,"Mid-floor Flat",56,54,80,59,68,426,72,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",5,2017,"Mid-floor Flat",57,74,81,57,70,441,75,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",2,2012,"Mid-floor Flat",57,44,58,32,43,598,105,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]

{"sheet":"Ground-Floor Flat","index":4,"n_rows":59,"n_cols":31,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy usage (kWh/year)","Emmissions (kgCO2/year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,"Floor Area (m^2)","Energy Efficiency Rating - Current","Environmental Impact Rating - Current","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)",null,null,null,null,"Wall Insulation"]
["PH50 4RU",20,2013,"Ground-floor Flat",56,62,76,51,69,283,70,{"$f":"J2*E2","v":15848},{"$f":"K2*E2","v":3920},"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a",null,null,null,{"$f":"AVERAGE(E2:E59)","v":57.275862068965516},{"$f":"AVERAGE(F2:F59)","v":51.137931034482762},{"$f":"AVERAGE(H2:H59)","v":42.758620689655174},{"$f":"AVERAGE(J2:J59)","v":529.98275862068965},{"$f":"AVERAGE(K2:K59)","v":92.948275862068968},{"$f":"AVERAGE(L2:L59)","v":30240.051724137931},null,null,"Cavity fill",{"$f":"COUNTIF(Q2:Q52,\"cavity fill\")","v":38}]
["PH50 4SD",17,2015,"Ground-floor Flat",59,54,71,46,65,354,92,{"$f":"J3*E3","v":20886},{"$f":"K3*E3","v":5428},"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a",null,null,null,null,null,null,null,null,null,null,null,"Timber frame no insulation",{"$f":"COUNTIF(Q2:Q52,\"timber frame no insulation\")","v":0}]
["PH50 4RX",10,2018,"Ground-floor Flat",52,58,74,51,59,368,88,{"$f":"J4*E4","v":19136},4576,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","n/a",null,null,null,null,null,null,null,null,null,null,null,"Cavity wall no insulation",{"$f":"COUNTIF(Q2:Q52,\"cavity wall no insulation\")","v":13}]
["PH50 4SD",1,2009,"Ground-floor Flat",44,67,69,60,60,402,59,17688,2596,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a",null,null,null,null,null,null,null,null,null,null,null,"Timber insulated",{"$f":"COUNTIF(Q2:Q52,\"Timber insulated\")","v":0}]
["PH50 4RX",2,2010,"Ground-floor Flat",57,49,53,32,36,411,104,23427,5928,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RZ",22,2010,"Ground-floor Flat",60,65,66,50,50,411,66,24660,3960,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",52,2014,"Ground-floor Flat",62,50,58,44,50,411,79,25482,4898,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","n/a"]
["PH50 4SA",8,2010,"Ground-floor Flat",57,48,53,32,36,412,105,23484,5985,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",6,2017,"Ground-floor Flat",56,52,55,57,60,435,74,24360,4144,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RU",12,2014,"Ground-floor Flat",57,40,51,45,54,445,80,25365,4560,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",24,2015,"Ground-floor Flat",53,74,79,57,67,459,78,24327,4134,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",16,2013,"Ground-floor Flat",50,41,52,46,55,464,83,23200,4150,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",7,2010,"Ground-floor Flat",57,30,30,49,49,465,70,26505,3990,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",6,2015,"Ground-floor Flat",51,74,79,58,68,466,79,23766,4029,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",13,2015,"Ground-floor Flat",52,74,79,56,67,471,80,24492,4160,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",38,2013,"Ground-floor Flat",81,28,35,36,42,483,86,39123,6966,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RX",9,2015,"Ground-floor Flat",56,52,65,44,58,489,105,27384,5880,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RU",10,2017,"Ground-floor Flat",60,48,76,48,57,494,91,29640,5460,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",6,2009,"Ground-floor Flat",55,53,55,47,47,496,75,27280,4125,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",2,2010,"Ground-floor Flat",57,48,48,45,45,503,75,28671,4275,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",3,2010,"Ground-floor Flat",57,54,54,45,45,507,76,28899,4332,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",5,2010,"Ground-floor Flat",57,53,54,45,45,508,77,28956,4389,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",4,2010,"Ground-floor Flat",57,53,54,45,45,508,77,28956,4389,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",8,2010,"Ground-floor Flat",57,58,59,42,42,510,82,29070,4674,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",5,2010,"Ground-floor Flat",57,58,59,42,42,510,82,29070,4674,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",6,2010,"Ground-floor Flat",57,58,59,42,42,510,82,29070,4674,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RZ",6,2010,"Ground-floor Flat",46,61,62,45,45,531,86,24426,3956,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RZ",14,2010,"Ground-floor Flat",46,61,62,45,45,531,86,24426,3956,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",54,2014,"Ground-floor Flat",69,39,47,32,39,540,100,37260,6900,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RZ",10,2013,"Ground-floor Flat",47,66,74,41,52,542,97,25474,4559,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",44,2016,"Ground-floor Flat",81,37,50,41,51,544,97,44064,7857,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RS",5,2013,"Ground-floor Flat",46,35,47,39,49,546,102,25116,4692,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",4,2010,"Ground-floor Flat",57,44,45,39,39,549,88,31293,5016,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",13,2015,"Ground-floor Flat",54,68,76,49,61,559,95,30186,5130,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",9,2015,"Ground-floor Flat",51,68,75,48,59,590,100,30090,5100,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SA",1,2014,"Ground-floor Flat",51,52,59,36,42,590,105,30090,5355,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RX",1,2015,"Ground-floor Flat",62,37,48,44,53,593,102,36766,6324,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",7,2009,"Ground-floor Flat",59,45,56,38,38,594,90,35046,5310,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",60,2019,"Ground-floor Flat",66,33,73,41,54,602,102,39732,6732,"Electric storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4SD",4,2017,"Ground-floor Flat",43,67,76,46,61,657,111,28251,4773,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RZ",2,2013,"Ground-floor Flat",49,21,28,31,36,680,121,33320,5929,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RB",5,2014,"Ground-floor Flat",50,52,70,30,46,692,123,34600,6150,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RZ",18,2018,"Ground-floor Flat",42,38,72,40,49,695,127,29190,5334,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",13,2009,"Ground-floor Flat",59,37,38,31,31,696,105,41064,6195,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",15,2017,"Ground-floor Flat",59,56,73,35,52,709,128,41831,7552,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RB",19,2014,"Ground-floor Flat",57,47,70,26,47,709,126,40413,7182,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RU",26,2015,"Ground-floor Flat",86,41,75,30,58,736,124,63296,10664,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RB",23,2014,"Ground-floor Flat",53,47,68,26,45,742,131,39326,6943,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RB",10,2014,"Ground-floor Flat",52,47,68,26,45,748,132,38896,6864,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RB",20,2014,"Ground-floor Flat",57,45,69,24,46,749,133,42693,7581,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","n/a"]
["PH50 4RU",32,2015,"Ground-floor Flat",59,21,57,32,62,803,136,47377,8024,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RU",46,2018,"Mid-floor Flat",81,57,76,61,60,351,59,28431,4779,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4RU",28,2014,"Mid-floor Flat",80,41,42,44,45,392,71,31360,5680,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RP","Flat 2 FF",2013,"Mid-floor Flat",58,68,80,49,69,407,72,{"$f":"J55*E55","v":23606},{"$f":"K55*E55","v":4176},"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4RP","Flat 1 FF",2013,"Mid-floor Flat",58,62,75,48,67,422,75,24476,4350,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no insulation","n/a"]
["PH50 4SD",8,2017,"Mid-floor Flat",56,54,80,59,68,426,72,23856,4032,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",5,2017,"Mid-floor Flat",57,74,81,57,70,441,75,25137,4275,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]
["PH50 4SD",2,2012,"Mid-floor Flat",57,44,58,32,43,598,105,34086,5985,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","n/a"]

{"sheet":"Mid-Terrace","index":5,"n_rows":54,"n_cols":32,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy usage (kWh/year)","Emmissions (kgCO2/year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,"Floor Area (m^2)","Energy Efficiency Rating - Current","Environmental Impact Rating - Current","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)",null,null,"Wall Insulation",null,null,"Roof insulation"]
["PH50 4QX",19,2018,"Mid-terrrace",92,69,83,63,77,210,54,{"$f":"J2*E2","v":19320},{"$f":"K2*E2","v":4968},"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","270mm Loft Insulation",null,null,null,{"$f":"AVERAGE(E2:E54)","v":70.867924528301884},{"$f":"AVERAGE(F2:F54)","v":49.264150943396224},{"$f":"AVERAGE(H2:H54)","v":46.660377358490564},{"$f":"AVERAGE(J2:J54)","v":512.28301886792451},{"$f":"AVERAGE(K2:K54)","v":89.019230769230774},{"$f":"AVERAGE(L2:L54)","v":36072.150943396227},"Cavity fill",{"$f":"COUNTIF(Q2:Q54,\"cavity fill\")","v":44},null,400,{"$f":"COUNTIF(R2:R54,\"400mm loft insulation\")","v":0}]
["PH50 4QP",15,2018,"Mid-terrrace",69,71,88,65,83,219,57,{"$f":"J3*E3","v":15111},{"$f":"K3*E3","v":3933},"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation",null,null,null,null,null,null,null,null,null,"solid brick no insulation",{"$f":"COUNTIF(Q2:Q54,\"solid brick no insulation\")","v":2},null,300,{"$f":"COUNTIF(R$2:R$54,\"300mm loft insulation\")","v":22}]
["PH50 4QH",11,2012,"Mid-terrrace",69,66,67,52,54,235,60,16215,4140,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation",null,null,null,null,null,null,null,null,null,"Cavity wall no insulation",{"$f":"COUNTIF(Q2:Q54,\"cavity wall no insulation\")","v":4},null,270,{"$f":"COUNTIF(R$2:R$54,\"270mm loft insulation\")","v":4}]
["PH50 4RP",16,2014,"Mid-terrrace",59,61,87,64,89,277,49,16343,2891,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,"Timber insulated",{"$f":"COUNTIF(Q2:Q54,\"Timber insulated\")","v":3},null,250,{"$f":"COUNTIF(R$2:R$54,\"250mm loft insulation\")","v":4}]
["PH50 4RR",11,2013,"Mid-terrrace",73,61,84,53,77,304,59,22192,4307,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","100mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,200,{"$f":"COUNTIF(R$2:R$54,\"200mm loft insulation\")","v":4}]
["PH50 4QH",15,2015,"Mid-terrrace",85,50,108,43,100,338,88,28730,7480,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","75mm loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,150,{"$f":"COUNTIF(R$2:R$54,\"150mm loft insulation\")","v":8}]
["PH50 4RS",13,2010,"Mid-terrrace",55,42,42,61,61,350,53,19250,2915,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,100,{"$f":"COUNTIF(R$2:R$54,\"100mm loft insulation\")","v":2}]
["PH50 4RQ",11,2017,"Mid-terrrace",92,57,73,90,100,352,14,32384,1288,"Boilers + Radiators + Wood","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"COUNTIF(R$2:R$54,\"50mm loft insulation\")","v":1}]
["PH50 4RS",11,2014,"Mid-terrrace",62,50,64,54,67,356,63,22072,3906,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R$2:R$54,\"no insulation\")","v":4}]
["PH50 4RQ",47,2017,"Mid-terrrace",94,49,98,43,90,359,89,33746,8366,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(AF2:AF10)","v":49}]
["PH50 4RS",41,2018,"Mid-terrrace",63,59,82,63,84,376,64,23688,4032,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,"average",{"$f":"(AE2*AF2+AE3*AF3+AE4*AF4+AE5*AF5+AE6*AF6+AE7*AF7+AE8*AF8+AE9*AF9+AE10*AF10)/AF11","v":223.0612244897959}]
["PH50 4RS",23,2010,"Mid-terrrace",63,35,35,56,56,376,100,23688,6300,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",39,2017,"Mid-terrrace",62,56,78,60,80,392,66,24304,4092,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","350mm Loft Insulation"]
["PH50 4RS",19,2014,"Mid-terrrace",59,56,75,50,69,394,70,23246,4130,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RS",43,2010,"Mid-terrrace",59,42,42,54,54,400,61,23600,3599,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",29,2010,"Mid-terrrace",64,40,40,63,63,403,61,25792,3904,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QS",9,2011,"Mid-terrrace",90,51,53,42,44,413,69,37170,6210,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RS",31,2017,"Mid-terrrace",60,53,76,58,79,419,71,25140,4260,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4RS",21,2014,"Mid-terrrace",59,41,68,47,71,426,75,25134,4425,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RP",18,2017,"Mid-terrrace",60,49,69,55,73,444,75,26640,4500,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RP",4,2010,"Mid-terrrace",64,59,59,45,45,458,74,29312,4736,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RF",8,2016,"Mid-terrrace",83,55,85,51,68,460,78,38180,6474,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RD",8,2011,"Mid-terrrace",74,43,56,37,47,472,92,34928,6808,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RP",19,2010,"Mid-terrrace",64,45,45,46,46,478,"72 kg/m2",30592,{"$error":"#VALUE!"},"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RA",21,2018,"Mid-terrrace",83,32,74,29,65,485,128,40255,10624,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","25mm Loft insulation"]
["PH50 4RP",8,2013,"Mid-terrrace",64,34,60,39,60,486,88,31104,5632,"Electric Storage ","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4SB",2,2016,"Mid-terrrace",109,31,83,22,63,489,140,53301,15260,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","150mm Loft insulation"]
["PH50 4RP",5,2010,"Mid-terrrace",64,43,44,44,44,494,74,31616,4736,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP",12,2013,"Mid-terrrace",58,65,87,40,63,496,89,28768,5162,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RS",33,2013,"Mid-terrrace",58,64,87,40,63,501,90,29058,5220,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RP",14,2013,"Mid-terrrace",60,64,85,39,60,507,91,30420,5460,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QP",7,2014,"Mid-terrrace",70,60,90,36,74,516,91,36120,6370,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","50mm loft insulation"]
["PH50 4RS",47,2017,"Mid-terrrace",63,44,66,88,101,521,20,32823,1260,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RR",7,2018,"Mid-terrrace",70,69,87,48,69,526,89,36820,6230,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RP",7,2017,"Mid-terrrace",60,45,68,88,102,526,20,31560,1200,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4QS",8,2016,"Mid-terrrace",89,63,83,44,64,537,92,47793,8188,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4QX",11,2018,"Mid-terrrace",97,57,84,42,67,553,93,53641,9021,"Electric Storage ","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4QX",10,2010,"Mid-terrrace",90,37,38,32,32,588,89,52920,8010,"Electric Storage ","Double Glazed","Electric Immersion","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4RQ",4,2018,"Mid-terrrace",98,56,83,37,62,604,106,59192,10388,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","200mm Loft Insulation"]
["PH50 4RR",2,2015,"Mid-terrrace",76,32,55,41,59,604,102,45904,7752,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",6,2015,"Mid-terrrace",76,32,55,41,59,604,102,45904,7752,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QS",2,2016,"Mid-terrrace",84,58,84,40,64,605,102,50820,8568,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",15,2015,"Mid-terrrace",70,57,75,39,56,649,113,45430,7910,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RB",2,2015,"Mid-terrrace",50,65,87,44,67,667,113,33350,5650,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QS",3,2018,"Mid-terrrace",90,47,82,34,61,670,113,60300,10170,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RP",6,2015,"Mid-terrrace",61,32,54,37,56,687,123,41907,7503,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QF",3,2015,"Mid-terrrace",63,29,52,38,55,700,122,44100,7686,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RP",3,2015,"Mid-terrrace",63,29,52,38,55,700,122,44100,7686,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",49,2018,"Mid-terrrace",53,58,88,37,69,770,130,40810,6890,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QH",14,2017,"Mid-terrrace",71,17,64,28,66,815,142,57865,10082,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No Insulation"]
["PH50 4RP",15,2017,"Mid-terrrace",60,55,84,31,60,824,145,49440,8700,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RP",9,2015,"Mid-terrrace",65,41,70,23,41,1023,173,66495,11245,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","100mm Loft insulation"]
["PH50 4QW",10,2015,"Mid-terrrace",67,35,83,19,62,1093,185,73231,12395,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]

{"sheet":"Semi-Detached","index":6,"n_rows":163,"n_cols":48,"rows_kept":163,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy usage (kWh/year)","Emmissions (kgCO2/year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,null,"Pre",null,null,null,null,null,null,null,null,null,null,"Post"]
["PH50 4QU",3,2012,"Semi-Detached",136,70,72,60,62,159,40,{"$f":"J2*E2","v":21624},{"$f":"K2*E2","v":5440},"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,"Average Floor area","Energy Efficiency Rating - Current",null,"Ave Environmental Impact Rating - Current","Average Energy Usuage (kWh/m^2 per year)","Ave tot energy usage (kWh/year)","heating (kWh/year)","water heating (kWh/year)","Electrical (kWh/year)",null,null,"heating (kWh/year)","water (kWh/year)","electrical","total",null,"heating factor reduction","water reduction",null,null,null,"Roof ins","Ave Roof ins","Median roof ins",null,"Wall ins"]
["PH50 4SE","Levenside",2013,"Semi-Detached",170,67,82,56,73,175,43,{"$f":"J3*E3","v":29750},{"$f":"K3*E3","v":7310},"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation",null,null,null,null,{"$f":"AVERAGE(E2:E163)","v":87.345679012345684},{"$f":"AVERAGE(F2:F163)","v":49.271604938271608},null,46.222222222222221,{"$f":"AVERAGE(J2:J163)","v":437.64197530864197},{"$f":"AVERAGE(L2:L163)","v":37155.104938271608},18500,3500,{"$f":"AB3-AC3-AD3","v":15155.104938271608},null,null,1700,{"$f":"AD3/3","v":1166.6666666666667},{"$f":"AE3/2","v":7577.5524691358041},{"$f":"AH3+AI3+AJ3","v":10444.219135802472},null,{"$f":"AC3/AH3","v":10.882352941176471},{"$f":"AD3/AI3","v":3},null,null,400,{"$f":"COUNTIF(R2:R163,\"400mm loft insulation\")","v":1},{"$f":"(AQ3*AR3+AQ4*AR4+AQ5*AR5+AQ6*AR6+AQ7*AR7+AQ8*AR8+AQ9*AR9+AQ10*AR10+AQ11*AR11+AQ12*AR12)/SUM(AR3:AR12)","v":188.35443037974684},200,"Cavity fill",{"$f":"COUNTIF(Q2:Q163,\"cavity fill\")","v":92}]
["PH50 4RT",8,2017,"Semi-Detached",91,74,89,77,90,181,31,16471,2821,"ASHP + Electric","HP Glazing","Electric Immersion","Cavity fill","150mm Loft insulation",null,null,null,null,null,null,null,null,null,{"$f":"AB3/W3","v":425.38},null,null,null,null,null,null,null,null,null,null,null,null,null,null,300,{"$f":"COUNTIF(R2:R163,\"300mm loft insulation\")","v":41},null,null,"solid brick",{"$f":"COUNTIF(Q2:Q163,\"Solid Brick no insulation\")","v":12}]
["PH50 4RT",7,2017,"Semi-Detached",92,74,89,77,90,181,31,16652,2852,"ASHP + Electric","HP Glazing","Electric Immersion","Cavity Fill","150mm Loft insulation",null,null,null,null,null,null,null,null,null,null,{"$f":"AC3/AB3*100","v":49.791273717932846},{"$f":"AD3/AB3*100","v":9.4199707033927016},{"$f":"AE3/AB3*100","v":40.788755578674454},null,null,{"$f":"AH3/AK3*100","v":16.276946872671893},{"$f":"AI3/AK3*100","v":11.17045373614738},{"$f":"AJ3/AK3*100","v":72.552599391180721},null,null,null,null,null,null,270,{"$f":"COUNTIF(R2:R163,\"270mm loft insulation\")","v":13},null,null,"timber insulated",{"$f":"COUNTIF(Q2:Q163,\"timber insulated\")","v":19}]
["PH50 4RA",19,2010,"Semi-Detached",97,68,71,56,60,201,44,19497,4268,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,250,{"$f":"COUNTIF(R2:R163,\"250mm loft insulation\")","v":13},null,null,"cavity wall no insulation",{"$f":"COUNTIF(Q2:Q163,\"cavity wall no insulation\")","v":31}]
["PH50 4RA","THE STEADINGS",2009,"Semi-Detached",149,61,63,56,57,209,42,31141,6258,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill ","200mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,{"$f":"COUNTIF(R2:R163,\"200mm loft insulation\")","v":32},null,null,null,{"$f":"SUM(AV3:AV6)","v":154}]
["PH50 4QX",23,2014,"Semi-Detached",116,64,79,53,70,210,51,24360,5916,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,{"$f":"COUNTIF(R2:R163,\"150mm loft insulation\")","v":16}]
["PH50 4QR",1,2014,"Semi-Detached",82,65,84,54,74,223,56,18286,4592,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,{"$f":"COUNTIF(R2:R163,\"100mm loft insulation\")","v":7}]
["PH50 4QT",5,2014,"Semi-Detached",94,64,84,63,85,223,42,20962,3948,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,75,{"$f":"COUNTIF(R2:R163,\"75mm loft insulation\")","v":6}]
["PH50 4RQ",6,2018,"Semi-Detached",98,66,82,59,75,228,60,22344,5880,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"COUNTIF(R2:R163,\"50mm loft insulation\")","v":7}]
["PH50 4SE","Allengrange",2018,"Semi-Detached",175,63,74,54,67,230,60,40250,10500,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R2:R163,\"No insulation\")","v":22}]
["PH50 4RD",14,2014,"Semi-Detached",77,69,84,67,83,231,41,17787,3157,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(AR3:AR12)","v":158}]
["PH50 4RH",8,2018,"Semi-Detached",94,66,83,59,76,231,60,21714,5640,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4QX",24,2018,"Semi-Detached",193,61,74,55,69,231,57,44583,11001,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","50mm loft Insulation"]
["PH50 4SE","The Moorings ",2016,"Semi-Detached",173,62,75,53,68,235,62,40655,10726,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RH",1,2018,"Semi-Detached",112,64,80,56,73,236,62,26432,6944,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4QS",7,2015,"End-terrace",110,65,79,58,72,237,61,26070,6710,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QW",6,2014,"Semi-Detached",71,65,85,54,76,238,59,16898,4189,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","25mm Loft insulation"]
["PH50 4QX",9,2018,"End-terrace",88,70,86,73,87,239,40,21032,3520,"GSHP + Electric","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4QT",1,2010,"Semi-Detached",97,61,63,55,56,240,49,23280,4753,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RA",18,2014,"Semi-Detached",82,63,83,46,70,246,68,20172,5576,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4RQ",41,2017,"Semi-Detached",130,63,75,55,67,246,63,31980,8190,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill ","300mm Loft Insulation"]
["PH50 4RD",13,2014,"Semi-Detached",77,68,83,65,80,247,44,19019,3388,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QX",16,2014,"Semi-Detached",96,64,82,91,104,250,10,24000,960,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","100mm Loft insulation"]
["PH50 4QX",26,2010,"Semi-Detached",97,62,63,51,52,251,54,24347,5238,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QR",6,2018,"Semi-Detached",71,50,71,66,83,255,55,18105,3905,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity Fill","350mm Loft Insulation"]
["PH50 4RD",1,2014,"Semi-Detached",76,67,83,64,79,256,45,19456,3420,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RR",12,2014,"End-terrace",99,57,82,47,75,260,61,25740,6039,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RH",5,2019,"Semi-Detached",98,62,83,53,76,261,69,25578,6762,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4RH",6,2019,"Semi-Detached",98,62,83,53,76,261,69,25578,6762,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4QP",3,2015,"Semi-Detached",86,47,95,63,103,261,56,22446,4816,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","75mm loft Insulation"]
["PH50 4QJ",10,2013,"Semi-Detached",87,61,75,57,71,262,51,22794,4437,"Boilers + Radiators ","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RD",4,2014,"Semi-Detached",76,66,82,62,78,263,47,19988,3572,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill ","250mm Loft insulation"]
["PH50 4RA",22,2018,"Semi-Detached",98,64,82,55,76,263,67,25774,6566,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","270mm Loft Insulation"]
["PH50 4RQ",14,2018,"Semi-Detached",98,69,85,67,84,267,45,26166,4410,"ASHP + Electric","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RD",3,2014,"Semi-Detached",75,66,82,62,78,268,47,20100,3525,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RN",4,2013,"Semi-Detached",102,73,83,57,70,270,48,27540,4896,"Electric Storage","Double Glazed","Boiler","Timber Insulated","300mm Loft Insulation"]
["PH50 4RR",16,2014,"End-terrace",72,58,79,62,81,274,49,19728,3528,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RN",6,2014,"Semi-Detached",103,70,81,56,69,277,49,28531,5047,"Electric Storage","Double Glazed","Boiler","Timber Insulated","200mm Loft Insulation"]
["PH50 4QH",5,2016,"Semi-Detached",91,60,76,53,69,282,69,25662,6279,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QH",3,2015,"Semi-Detached",89,59,103,51,95,283,74,25187,6586,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","100mm Loft insulation"]
["PH50 4QR",18,2019,"Semi-Detached",70,45,69,62,82,284,62,19880,4340,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4QW",7,2014,"Semi-Detached",107,51,88,40,79,284,71,30388,7597,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","No insulation"]
["PH50 4QH",8,2018,"Semi-Detached",92,45,65,60,77,285,59,26220,5428,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",4,2011,"End-terrace",69,45,48,45,48,288,70,19872,4830,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4QP",11,2011,"End-terrace",85,53,57,41,45,288,72,24480,6120,"Boliers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","No insulation"]
["PH50 4RQ",31,2015,"Semi-Detached",76,59,80,51,73,293,77,22268,5852,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",7,2010,"Semi-Detached",84,57,62,45,50,300,65,25200,5460,"Boilers + Radiators + Coal","Double Glazed","Boiler","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4SB",3,2016,"End-terrace",133,51,94,43,85,302,80,40166,10640,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick internal insulation","200mm Loft Insulation"]
["PH50 4QW",1,2018,"Semi-Detached",69,61,81,52,73,311,80,21459,5520,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QJ",8,2016,"Semi-Detached",78,59,80,51,72,315,80,24570,6240,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4QR",11,2017,"Semi-Detached",68,58,84,50,77,318,83,21624,5644,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RQ",5,2010,"Semi-Detached",84,54,55,43,44,320,69,26880,5796,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4QY",8,2017,"Semi-Detached",60,62,84,66,85,325,55,{"$f":"J55*E55","v":19500},{"$f":"K55*E55","v":3300},"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RG",5,2014,"Semi-Detached",44,65,90,64,89,325,57,14300,2508,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RG",7,2013,"Semi-Detached",44,61,86,64,87,325,57,14300,2508,"ASHP + Electric","Double Glazed","Boiler","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4QR",3,2014,"Semi-Detached",66,55,73,40,54,325,84,21450,5544,"Boilers + Radiators","Double Glazed","Boiler","Cavity wall no insulation","No insulation"]
["PH50 4GZ",3,2017,"Semi-Detached",59,61,83,66,85,326,55,19234,3245,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RG",8,2014,"Semi-Detached",43,67,88,63,85,326,58,14018,2494,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill ","250mm Loft insulation"]
["PH50 4QY",5,2017,"Semi-Detached",59,62,83,66,85,327,55,19293,3245,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RF",11,2017,"Semi-Detached",85,57,74,62,77,328,56,27880,4760,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",36,2017,"Semi-Detached",94,59,76,87,98,329,19,30926,1786,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RF",14,2017,"Semi-Detached",84,57,74,62,77,330,56,27720,4704,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4QX",14,2016,"Semi-Detached",92,60,79,52,70,334,71,30728,6532,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4RH",3,2018,"Semi-Detached",90,51,67,43,56,335,88,30150,7920,"Boilers + Radiators + Oil","Double Glazed","Boiler","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4RR",8,2016,"End-terrace",72,57,77,50,70,336,82,24192,5904,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4RR",5,2017,"End-terrace",72,55,79,46,70,342,88,24624,6336,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no Insulation","270mm Loft Insulation"]
["PH50 4RQ",23,2018,"Semi-Detached",98,58,77,52,71,346,72,33908,7056,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","200mm Loft Insulation"]
["PH50 4RQ",15,2012,"End-terrace",91,52,56,45,49,357,63,32487,5733,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","75mm loft Insulation"]
["PH50 4RH",11,2018,"End-terrace",98,57,77,51,69,361,76,35378,7448,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4QR",13,2014,"Semi-Detached",72,52,83,41,73,367,102,26424,7344,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4QX",22,2018,"Semi-Detached",103,44,76,37,68,367,97,37801,9991,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4RQ",55,2010,"Semi-Detached",100,40,44,28,31,380,94,38000,9400,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QR",16,2014,"Semi-Detached",100,57,79,43,63,381,68,38100,6800,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4RQ",12,2018,"Semi-Detached",91,45,62,41,53,381,93,34671,8463,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RQ",18,2011,"Semi-Detached",79,59,61,43,45,386,70,30494,5530,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",37,2013,"End-terrace",62,55,81,46,70,388,76,24056,4712,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","250mm Loft insulation"]
["PH50 4QX",17,2010,"End-terrace",97,55,56,48,48,388,59,37636,5723,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",20,2010,"End-terrace",97,56,56,48,48,388,58,37636,5626,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",39,2010,"Semi-Detached",90,41,45,28,32,389,97,35010,8730,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",1,2017,"End-terrace",73,56,76,86,98,390,23,28470,1679,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation"]
["PH50 4QR",14,2015,"Semi-Detached",72,46,81,39,73,400,106,28800,7632,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RQ",3,2017,"Semi-Detached",91,51,69,84,95,400,23,36400,2093,"Boilers + Radiators + Wood","Double Glazed","Boiler","Timber Insulated","150mm Loft insulation"]
["PH50 4QJ",21,2014,"Semi-Detached",79,37,61,44,64,405,72,31995,5688,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QR",10,2015,"Semi-Detached",85,42,100,40,91,405,93,34425,7905,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RQ",10,2018,"Semi-Detached",91,42,63,37,54,409,101,37219,9191,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","270mm Loft Insulation"]
["PH50 4RH",10,2017,"Semi-Detached",90,42,83,38,72,410,100,36900,9000,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no Insulation","No insulation"]
["PH50 4RQ",32,2010,"Semi-Detached",105,56,57,40,40,412,69,43260,7245,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4QT",4,2015,"Semi-Detached",85,41,103,40,94,413,95,35105,8075,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity Fill","50mm loft insulation"]
["PH50 4QP",4,2015,"Semi-Detached",79,42,79,36,71,414,109,32706,8611,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","No insulation"]
["PH50 4QJ",14,2017,"Semi-Detached",103,38,75,35,69,416,103,42848,10609,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4RP",11,2017,"End-terrace",61,51,74,57,77,417,70,25437,4270,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","n/a"]
["PH50 4RF",15,2009,"Semi-Detached",70,36,38,85,86,422,19,29540,1330,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4RS",9,2014,"End-terrace",61,41,57,47,61,425,75,25925,4575,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill ","300mm Loft Insulation"]
["PH50 4RD",12,2014,"End-terrace",75,33,57,88,104,430,14,32250,1050,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no insulation","200mm Loft Insulation",null,null,null,null,null,{"$f":"491*70","v":34370}]
["PH50 4QJ",1,2017,"Semi-Detached",85,42,62,32,44,431,123,36635,10455,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation",null,null,null,null,null,11500]
["PH50 4RG",6,2014,"Semi-Detached",46,59,84,63,86,432,73,19872,3358,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,{"$f":"X96-X97","v":22870}]
["PH50 4QS",10,2010,"End-terrace",102,45,49,40,43,433,70,44166,7140,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","75mm loft Insulation"]
["PH50 4QY",3,2017,"Semi-Detached",58,51,79,56,81,438,74,25404,4292,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","150mm Loft insulation"]
["PH50 4QW",16,2015,"End-terrace",107,35,51,32,43,445,110,47615,11770,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","No insulation"]
["PH50 4RS",53,2010,"End-terrace",67,33,33,47,47,448,67,30016,4489,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QX",7,2015,"Semi-Detached",98,34,87,29,75,453,121,44394,11858,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber frame no insulation","75mm loft Insulation"]
["PH50 4QY",7,2010,"Semi-Detached",58,42,47,27,31,454,126,26332,7308,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4RQ",20,2010,"Semi-Detached",84,43,43,43,43,456,68,38304,5712,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RR",9,2013,"Semi-Detached",72,47,71,37,60,464,89,33408,6408,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RD",10,2014,"End-terrace",75,63,79,39,57,465,82,34875,6150,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QP",23,2015,"Semi-Detached",85,33,103,33,94,469,111,39865,9435,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","200mm Loft insulation"]
["PH50 4RQ",53,2015,"Semi-Detached",85,32,103,32,94,478,113,40630,9605,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","75mm loft Insulation"]
["PH50 4RQ",45,2015,"Semi-Detached",85,32,103,32,93,479,118,40715,10030,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","50mm loft insulation"]
["PH50 4QW",4,2013,"Semi-Detached",70,55,80,38,59,491,87,34370,6090,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RS",15,2010,"End-terrace",63,23,23,45,45,491,73,30933,4599,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RS",17,2010,"End-terrace",63,30,30,44,44,503,75,31689,4725,"Boilers + Radiators + Coal","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QH",2,2015,"Semi-Detached",49,40,119,35,110,505,133,24745,6517,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","50mm loft insulation"]
["PH50 4RQ",13,2009,"End-terrace",172,35,41,31,35,506,76,87032,13072,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","50mm loft insulation"]
["PH50 4RQ",37,2015,"Semi-Detached",94,60,75,48,65,508,86,47752,8084,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RZ",24,2010,"End-terrace",76,44,44,38,38,508,82,38608,6232,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4SE","Tigh-Na-Fleasgach",2019,"Semi-Detached",144,32,87,86,112,510,18,73440,2592,"Boilers + Radiators + Wood","Double Glazed","Boiler","Sandstone no insulation","300mm Loft Insulation"]
["PH50 4GZ",5,2017,"Semi-Detached",60,47,80,42,73,521,108,{"$f":"J119*E119","v":31260},{"$f":"K119*E119","v":6480},"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity wall no Insulation","300mm Loft Insulation"]
["PH50 4RQ",34,2012,"Semi-Detached",93,42,43,29,30,526,94,48918,8742,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4QH",4,2014,"Semi-Detached",92,22,54,30,55,529,95,48668,8740,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RQ",21,2018,"Semi-Detached",98,58,85,42,68,543,92,53214,9016,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RB",27,2015,"Semi-Detached",92,65,77,43,54,549,93,50508,8556,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4GZ",7,2010,"Semi-Detached",64,38,40,39,40,555,84,35520,5376,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QP",1,2017,"Semi-Detached",111,36,78,7,112,556,205,61716,22755,"Boilers + Radiators + Coal","Double Glazed","Boiler","Solid Brick no insulation","No insulation"]
["PH50 4SB",1,2016,"Semi-Detached",112,23,90,17,74,561,159,62832,17808,"Boilers + Radiators + Oil","Double Glazed","Oil range cooker","Cavity wall no Insulation","250mm Loft insulation"]
["PH50 4RU",22,2009,"End-terrace",87,43,43,33,33,570,88,49590,7656,"Electric Storage ","Double Glazed","Electric Immersion","Solid Brick no insulation","n/a"]
["PH50 4QU",2,2016,"Semi-Detached",132,54,93,32,62,573,108,75636,14256,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4RQ",9,2018,"End-terrace",91,28,46,38,54,581,101,52871,9191,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","300mm Loft Insulation"]
["PH50 4RR",13,2014,"End-terrace",75,19,58,30,61,583,103,43725,7725,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","200mm Loft Insulation"]
["PH50 4QY",6,2010,"Semi-Detached",64,51,51,35,35,586,94,37504,6016,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4RH",16,2018,"Semi-Detached",98,55,83,39,64,594,100,58212,9800,"Electric Storage ","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RS",35,2018,"End-terrace",62,36,60,81,96,612,32,37944,1984,"Boilers + Radiators + Wood","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation"]
["PH50 4QY",4,2013,"Semi-Detached",59,46,84,32,69,613,108,36167,6372,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","200mm Loft Insulation"]
["PH50 4RB",18,2015,"End-terrace",52,66,83,45,60,641,108,33332,5616,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","400mm Loft Insulation"]
["PH50 4QH",10,2016,"Semi-Detached",70,58,85,40,66,646,109,45220,7630,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","250mm Loft insulation"]
["PH50 4QP",20,2014,"Semi-Detached",92,38,92,23,58,648,115,59616,10580,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4QX",25,2017,"Semi-Detached",94,54,79,34,58,665,112,62510,10528,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4QP",16,2009,"Semi-Detached",78,26,26,29,29,666,100,51948,7800,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","150mm Loft insulation"]
["PH50 4RA",17,2014,"Semi-Detached",95,21,91,32,58,667,113,63365,10735,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","300mm Loft Insulation"]
["PH50 4RB",4,2018,"End-terrace",52,64,87,41,67,673,114,34996,5928,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4QH",17,2016,"Semi-Detached",91,24,54,33,57,687,121,62517,11011,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","150mm Loft insulation"]
["PH50 4RD",2,2012,"Semi-Detached",76,10,59,23,62,690,122,52440,9272,"Boilers + Radiators + Oil","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4QR",12,2017,"Semi-Detached",74,55,83,37,62,690,117,51060,8658,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",1,2018,"End-terrace",41,66,91,44,73,699,118,28659,4838,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",27,2018,"Semi-Detached",98,46,76,31,53,705,119,69090,11662,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","200mm Loft Insulation"]
["PH50 4QW",5,2016,"Semi-Detached",70,54,83,36,62,707,119,49490,8330,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4QJ",9,2015,"Semi-Detached",76,44,67,34,49,712,124,54112,9424,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4RB",3,2018,"End-terrace",41,65,90,44,72,714,121,29274,4961,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4RQ",29,2009,"End-terrace",77,31,32,26,26,718,109,55286,8393,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","300mm Loft Insulation"]
["PH50 4QP",12,2017,"Semi-Detached",81,52,104,31,79,747,126,60507,10206,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QT","GORTENNAMBEITH",2018,"Semi-Detached",120,42,73,27,48,750,127,90000,15240,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","270mm Loft Insulation"]
["PH50 4QW",2,2014,"Semi-Detached",75,39,81,16,53,751,146,56325,10950,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","75mm loft Insulation"]
["PH50 4QS",6,2015,"Semi-Detached",144,9,96,23,74,759,128,109296,18432,"Electric Storage ","Double Glazed","Electric Immersion","Solid Brick no insulation","50mm loft insulation"]
["PH50 4RD",6,2015,"Semi-Detached",76,51,80,28,58,817,138,62092,10488,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4QP",5,2015,"End-terrace",82,13,86,26,62,829,140,67978,11480,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QJ",20,2016,"Semi-Detached",76,18,45,28,50,835,147,63460,11172,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QP",24,2010,"Semi-Detached",78,1,1,19,19,846,127,65988,9906,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","No insulation"]
["PH50 4QW",8,2017,"Semi-Detached",85,10,87,24,71,855,145,72675,12325,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","100mm Loft insulation"]
["PH50 4QR",7,2015,"Semi-Detached",112,3,78,18,80,926,157,103712,17584,"Electric Storage","Double Glazed","Electric Immersion","Solid Brick no insulation","50mm loft insulation"]
["PH50 4QJ",2,2010,"Semi-Detached",83,1,12,1,4,994,251,82502,20833,"Electric Storage","Single Glazing","Electric Immersion","Cavity wall no insulation","100mm Loft insulation"]
["PH50 4QP",21,2016,"Semi-Detached",70,25,87,16,71,1090,184,76300,12880,"Electric Storage","Double Glazed","Electric Immersion","Cavity Fill","No insulation"]
["PH50 4QR",15,2015,"Semi-Detached",70,1,65,11,69,1263,214,88410,14980,"Electric Storage","Double Glazed","Electric Immersion","Cavity wall no insulation","No insulation"]

{"sheet":"Detached","index":7,"n_rows":26,"n_cols":34,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Postcode","House No.","Assessment Year ","Dwelling Type","Floor Area (m^2)","Energy Efficiency Rating - Current","Energy Efficiency Rating - Potential","Environmental Impact Rating - Current","Environmental Impact Rating - Potential","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy usage (kWh/year)","Emmissions (kgCO2/year)","Main Heating Type","Windows","Hot Water","Wall Insulation","Pitch Roof Insulation",null,null,null,"Floor Area (m^2)","Energy Efficiency Rating - Current","Environmental Impact Rating - Current","Energy Usuage (kWh/m^2 per year)","Emissions (kg/m^2 per year)","Energy per house",null,null,null,"Wall Insulation",null,null,"Roof insulation"]
["PH50 4QT","GREYMARES",2018,"Detached",102,78,80,87,89,86,19,{"$f":"J2*E2","v":8772},{"$f":"K2*E2","v":1938},"Boilers + Radiators + Oil","HP Glazing","Boiler","Cavity Fill",0.08,null,null,null,{"$f":"AVERAGE(E2:E24)","v":161.08695652173913},{"$f":"AVERAGE(F2:F24)","v":51.695652173913047},{"$f":"AVERAGE(H2:H24)","v":51.043478260869563},{"$f":"AVERAGE(J2:J24)","v":376.26086956521738},{"$f":"AVERAGE(K2:K24)","v":70.478260869565219},{"$f":"AVERAGE(L2:L24)","v":62480.695652173912},null,null,"Cavity fill",{"$f":"COUNTIF(Q2:Q24,\"cavity fill\")","v":12},null,400,{"$f":"COUNTIF(R2:R24,\"400mm loft insulation\")","v":1}]
["PH50 4RA","TIGH NA SITH",2013,"Detached",196,76,88,68,82,122,30,{"$f":"J3*E3","v":23912},{"$f":"K3*E3","v":5880},"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,"Timber frame no insulation",{"$f":"COUNTIF(Q2:Q24,\"timber frame no insulation\")","v":1},null,300,{"$f":"COUNTIF(R$2:R$24,\"300mm loft insulation\")","v":6}]
["PH50 4RT",4,2017,"Detached",133,79,89,91,99,149,11,19817,1463,"Boilers + Radiators + Wood","HP Glazing","Boiler","Cavity Fill",0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,"Cavity wall no insulation",{"$f":"COUNTIF(Q2:Q24,\"cavity wall no insulation\")","v":5},null,270,{"$f":"COUNTIF(R$2:R$24,\"270mm loft insulation\")","v":2}]
["PH50 4RT",1,2018,"Detached",138,76,103,79,103,153,25,21114,3450,"ASHP + Electric","HP Glazing","Electric Immersion","Cavity Fill",0.14000000000000001,null,null,null,null,null,null,null,null,null,null,null,"Timber insulated",{"$f":"COUNTIF(Q2:Q24,\"Timber insulated\")","v":5},null,250,{"$f":"COUNTIF(R$2:R$24,\"250mm loft insulation\")","v":1}]
["PH50 4QL","LOCHSIDE COTTAGE",2014,"Detached",127,68,86,59,78,183,43,23241,5461,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,200,{"$f":"COUNTIF(R$2:R$24,\"200mm loft insulation\")","v":3}]
["PH50 4RA","TIGH AN T SAOIR ",2013,"Detached",118,64,84,63,76,210,52,24780,6136,"Boilers + Radiators + Oil","Double Glazed","Boiler","Timber Insulated","100mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,150,{"$f":"COUNTIF(R$2:R$24,\"150mm loft insulation\")","v":0}]
["PH50 4QX","Eakie House",2017,"Detached",85,58,72,70,82,217,47,18445,3995,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","400mm loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,100,{"$f":"COUNTIF(R$2:R$24,\"100mm loft insulation\")","v":3}]
["PH50 4QS","Police House",2016,"Detached",129,66,98,70,99,229,39,29541,5031,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,50,{"$f":"COUNTIF(R$2:R$24,\"50mm loft insulation\")","v":0}]
["PH50 4QW","THE OLD POLICE HOUSE ",2016,"Detached",129,66,98,70,99,229,39,29541,5031,"ASHP + Electric","Double Glazed","Boiler","Cavity Fill","300mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"COUNTIF(R$2:R$24,\"no insulation\")","v":3}]
["PH50 4SE","Tigh Na Cheo Garbhein",2011,"Detached",452,22,36,43,55,243,50,109836,22600,"Boilers + Radiators + Oil","Double Glazing","Electric Immersion","Cavity Fill","100mm Loft insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"sum",{"$f":"SUM(AH2:AH10)","v":19}]
["PH50 4QT","TIGH-AN-RUDHA",2011,"Detached",161,52,55,40,42,251,62,40411,9982,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity Fill","200mm Loft Insulation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"average",{"$f":"(AG2*AH2+AG3*AH3+AG4*AH4+AG5*AH5+AG6*AH6+AG7*AH7+AG8*AH8+AG9*AH9+AG10*AH10)/AH11","v":204.73684210526315}]
["PH50 4QL","SCHOOL LODGE ",2013,"Detached",124,68,83,51,68,298,53,36952,6572,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","300mm Loft Insulation"]
["PH50 4SE","Argus",2014,"Detached",285,34,50,90,97,306,9,87210,2565,"Boilers + Radiators + Wood","Single Glazing","Boiler","Timber frame no insulation","300mm Loft Insulation"]
["PH50 4QH","THE OLD SURGERY",2018,"Detached",101,62,74,59,73,335,57,33835,5757,"ASHP + Electric","Double Glazed","Electric Immersion","Cavity Fill","270mm Loft Insulation"]
["PH50 4SE","Garbhein Cottage",2014,"Detached",85,30,46,41,55,336,75,28560,6375,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity fill","200mm Loft Insulation"]
["PH50 4SE","Garbhein House",2009,"Detached",320,28,31,27,28,366,76,117120,24320,"Boilers + Radiators + Oil","Single Glazing","Electric Immersion","Cavity wall no Insulation","No insulation"]
["PH50 4SE","Ossian",2014,"Detached",108,37,81,26,67,379,101,40932,10908,"Boilers + Radiators + Oil","Double Glazed","Boiler","Cavity wall no Insulation","No insulation"]
["PH50 4SB","Burnside",2017,"Detached",181,16,65,15,55,585,153,105885,27693,"Boilers + Radiators + Oil","Double Glazing","Boiler","Cavity wall no Insulation","No insulation"]
["PH50 4QT","FIRWOOD COTTAGE",2018,"Detached",98,55,84,35,61,620,111,60760,10878,"Electric Storage","Double Glazed","Electric Immersion","Timber Insulated","250mm Loft insulation"]
["PH50 4QL","MAMORE LODGE ",2016,"Detached",112,43,64,32,49,645,109,72240,12208,"Electric Storage ","Double Glazed","Electric Immersion","Timber Insulated","270mm Loft Insulation"]
["PH50 4RB",17,2018,"Detached",51,63,86,40,66,712,120,36312,6120,"Electric Storage ","Double Glazed","Electric Immersion","Cavity Fill","200mm Loft Insulation"]
["PH50 4SE","Edenmhor",2015,"Detached",271,25,52,11,29,970,158,{"$f":"J23*E23","v":262870},42818,"Electric Storage ","Single Glazing","Solid fuel range cooker","cavity wall no insulation","100mm Loft insulation"]
["PH50 4SE","Inverleven ",2018,"Detached",199,23,72,7,46,1030,182,204970,36218,"Electric Storage ","Double Glazed","Electric Immersion","Cavity wall no Insulation","50mm lof Insulation"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"STDEV(J2:J24)","v":261.1069473312881},null,{"$f":"STDEV(L2:L24)","v":63070.559746737606}]