{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["List","Data","Life","Calcs","Map"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":7,"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":"List","index":0,"n_rows":16,"n_cols":19,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Population","Income","Unemployment","Category",null,{"$f":"Map!B1","v":"Population"},"Selection","Red","Green","Blue",null,"Selection","Red","Green","Blue",null,null,"DropDownDash","Match"]
[0,0,0,1,null,"Population","0 to 3.0m",224,243,248,null,{"$f":"INDEX($G$2:$G$25,MATCH($F$1,$F$2:$F$25,0),1)","v":"0 to 3.0m"},{"$f":"INDEX(H$2:H$16,MATCH($L2,$G$2:$G$16,0),1)","v":224},{"$f":"INDEX(I$2:I$25,MATCH($L2,$G$2:$G$25,0),1)","v":243},248,null,null,"Population",1]
[3000000,14000,5.5,2,null,null,"3m to 5m",116,173,209,null,{"$f":"INDEX($G$2:$G$25,MATCH($F$1,$F$2:$F$25,0)+ROW(A1),1)","v":"3m to 5m"},{"$f":"INDEX(H$2:H$25,MATCH($L3,$G$2:$G$25,0),1)","v":116},173,209,null,null,"Income",2]
[5000000,16000,6.5,3,null,null,"5m to 6m",14,17,136,null,{"$f":"INDEX($G$2:$G$25,MATCH($F$1,$F$2:$F$25,0)+ROW(A2),1)","v":"5m to 6m"},{"$f":"INDEX(H$2:H$25,MATCH($L4,$G$2:$G$25,0),1)","v":14},17,136,null,null,"Unemployment",3]
[6000000,18000,8,4,null,null,"6m to 8m",247,174,97,null,{"$f":"INDEX($G$2:$G$25,MATCH($F$1,$F$2:$F$25,0)+ROW(A3),1)","v":"6m to 8m"},{"$f":"INDEX(H$2:H$25,MATCH($L5,$G$2:$G$25,0),1)","v":247},{"$f":"INDEX(I$2:I$25,MATCH($L5,$G$2:$G$25,0),1)","v":174},{"$f":"INDEX(J$2:J$25,MATCH($L5,$G$2:$G$25,0),1)","v":97}]
[8000000,19000,9,5,null,null,"8m +",215,48,39,null,{"$f":"INDEX($G$2:$G$25,MATCH($F$1,$F$2:$F$25,0)+ROW(A4),1)","v":"8m +"},{"$f":"INDEX(H$2:H$25,MATCH($L6,$G$2:$G$25,0),1)","v":215},{"$f":"INDEX(I$2:I$25,MATCH($L6,$G$2:$G$25,0),1)","v":48},{"$f":"INDEX(J$2:J$25,MATCH($L6,$G$2:$G$25,0),1)","v":39}]
[null,null,null,null,null,"Income","0 to 14K",253,219,199]
[null,null,null,null,null,null,"14K to 16K",214,96,77]
[null,null,null,null,null,null,"16K to 18K",103,0,31]
[null,null,null,null,null,null,"18K to 19K",178,171,210]
[null,null,null,null,null,null,"19K +",84,39,136]
[null,null,null,null,null,"Unemployment","0 to 6%",253,224,239]
[null,null,null,null,null,null,"6% to 7%",222,119,174]
[null,null,null,null,null,null,"7% to 8%",142,1,82]
[null,null,null,null,null,null,"8% to 9%",171,213,233]
[null,null,null,null,null,null,"9% +",54,96,146]

{"sheet":"Data","index":1,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Shape","Area name","0 to 9","10 to 19","20 to 30","30 to 59","60 to 74","75 and Over","All Ages","Income per Head","2011 Unemployment","Population","Income","Unemployment",null,{"$f":"INDEX($L$1:$N$11,ROW(A1),MATCH(Map!$B$1,$L$1:$N$1,0))","v":"Population"},"Chosen","Desc"]
["NorthEast","North East",286142,314485,348321,1029877,407818,210243,{"$f":"SUM(C2:H2)","v":2596886},13329,9.8000000000000007,{"$f":"VLOOKUP(I2,List!$A$2:$E$6,4,1)","v":1},{"$f":"VLOOKUP(J2,List!$B$2:$D$6,3,1)","v":1},{"$f":"VLOOKUP(K2,List!$C$2:$D$6,2,1)","v":5},null,{"$f":"INDEX($L$1:$N$11,ROW(A2),MATCH(Map!$B$1,$L$1:$N$1,0))","v":1},{"$f":"INDEX($I$1:$K$11,ROW(A2),MATCH(Map!$B$1,$L$1:$N$1,0))","v":2596886},{"$f":"B2&\" \"&Q2","v":"North East 2596886"}]
["NorthWest","North West",824257,869244,956222,2791655,1067386,543413,{"$f":"SUM(C3:H3)","v":7052177},14176,8.6,{"$f":"VLOOKUP(I3,List!$A$2:$E$6,4,1)","v":4},{"$f":"VLOOKUP(J3,List!$B$2:$D$6,3,1)","v":2},{"$f":"VLOOKUP(K3,List!$C$2:$D$6,2,1)","v":4},null,{"$f":"INDEX($L$1:$N$11,ROW(A3),MATCH(Map!$B$1,$L$1:$N$1,0))","v":4},{"$f":"INDEX($I$1:$K$11,ROW(A3),MATCH(Map!$B$1,$L$1:$N$1,0))","v":7052177},{"$f":"B3&\" \"&Q3","v":"North West 7052177"}]
["YorkshireAndHumber","Yorkshire And The Humber",625922,654741,729983,2073187,789178,410722,5283733,13594,8.6999999999999993,{"$f":"VLOOKUP(I4,List!$A$2:$E$6,4,1)","v":3},{"$f":"VLOOKUP(J4,List!$B$2:$D$6,3,1)","v":1},{"$f":"VLOOKUP(K4,List!$C$2:$D$6,2,1)","v":4},null,{"$f":"INDEX($L$1:$N$11,ROW(A4),MATCH(Map!$B$1,$L$1:$N$1,0))","v":3},{"$f":"INDEX($I$1:$K$11,ROW(A4),MATCH(Map!$B$1,$L$1:$N$1,0))","v":5283733},"Yorkshire And The Humber 5283733"]
["EastMidlands","East Midlands",517738,560452,586257,1804426,706114,358235,4533222,14267,7.9,{"$f":"VLOOKUP(I5,List!$A$2:$E$6,4,1)","v":2},{"$f":"VLOOKUP(J5,List!$B$2:$D$6,3,1)","v":2},{"$f":"VLOOKUP(K5,List!$C$2:$D$6,2,1)","v":3},null,{"$f":"INDEX($L$1:$N$11,ROW(A5),MATCH(Map!$B$1,$L$1:$N$1,0))","v":2},{"$f":"INDEX($I$1:$K$11,ROW(A5),MATCH(Map!$B$1,$L$1:$N$1,0))","v":4533222},"East Midlands 4533222"]
["WestMidlands","West Midlands",681861,710070,744195,2184481,840954,440286,5601847,14021,8.5,{"$f":"VLOOKUP(I6,List!$A$2:$E$6,4,1)","v":3},{"$f":"VLOOKUP(J6,List!$B$2:$D$6,3,1)","v":2},{"$f":"VLOOKUP(K6,List!$C$2:$D$6,2,1)","v":4},null,{"$f":"INDEX($L$1:$N$11,ROW(A6),MATCH(Map!$B$1,$L$1:$N$1,0))","v":3},{"$f":"INDEX($I$1:$K$11,ROW(A6),MATCH(Map!$B$1,$L$1:$N$1,0))","v":5601847},"West Midlands 5601847"]
["East","East",689781,704150,715617,2340669,903959,492789,5846965,16392,6.5,{"$f":"VLOOKUP(I7,List!$A$2:$E$6,4,1)","v":3},{"$f":"VLOOKUP(J7,List!$B$2:$D$6,3,1)","v":3},{"$f":"VLOOKUP(K7,List!$C$2:$D$6,2,1)","v":3},null,{"$f":"INDEX($L$1:$N$11,ROW(A7),MATCH(Map!$B$1,$L$1:$N$1,0))","v":3},{"$f":"INDEX($I$1:$K$11,ROW(A7),MATCH(Map!$B$1,$L$1:$N$1,0))","v":5846965},"East 5846965"]
["London","London",1074304,928524,1462938,3460836,815648,431691,8173941,20238,9.3000000000000007,{"$f":"VLOOKUP(I8,List!$A$2:$E$6,4,1)","v":5},{"$f":"VLOOKUP(J8,List!$B$2:$D$6,3,1)","v":5},{"$f":"VLOOKUP(K8,List!$C$2:$D$6,2,1)","v":5},null,{"$f":"INDEX($L$1:$N$11,ROW(A8),MATCH(Map!$B$1,$L$1:$N$1,0))","v":5},{"$f":"INDEX($I$1:$K$11,ROW(A8),MATCH(Map!$B$1,$L$1:$N$1,0))","v":8173941},"London 8173941"]
["SouthEast","South East",1022293,1054559,1062344,3478135,1299094,718325,8634750,17610,5.7,{"$f":"VLOOKUP(I9,List!$A$2:$E$6,4,1)","v":5},{"$f":"VLOOKUP(J9,List!$B$2:$D$6,3,1)","v":3},{"$f":"VLOOKUP(K9,List!$C$2:$D$6,2,1)","v":2},null,{"$f":"INDEX($L$1:$N$11,ROW(A9),MATCH(Map!$B$1,$L$1:$N$1,0))","v":5},{"$f":"INDEX($I$1:$K$11,ROW(A9),MATCH(Map!$B$1,$L$1:$N$1,0))","v":8634750},"South East 8634750"]
["SouthWest","South West",568783,624969,640325,2057907,894409,502542,{"$f":"SUM(C10:H10)","v":5288935},15653,6.4,{"$f":"VLOOKUP(I10,List!$A$2:$E$6,4,1)","v":3},{"$f":"VLOOKUP(J10,List!$B$2:$D$6,3,1)","v":2},{"$f":"VLOOKUP(K10,List!$C$2:$D$6,2,1)","v":2},null,{"$f":"INDEX($L$1:$N$11,ROW(A10),MATCH(Map!$B$1,$L$1:$N$1,0))","v":3},{"$f":"INDEX($I$1:$K$11,ROW(A10),MATCH(Map!$B$1,$L$1:$N$1,0))","v":5288935},"South West 5288935"]
[]
[]
[]
["Shape","Region","House Price","Income /House $","Weekly Spend"]
["NorthEast","North East",140.21254852634644,{"$f":"C15/(J2/1000)","v":10.519359931453705},408.7]
["NorthWest","North West",158.34820493715958,11.170161183490377,447.5]
["YorkshireAndHumber","Yorkshire And The Humber",158.53383936229167,11.662044972950691,422.7]
["EastMidlands","East Midlands",165.69349066263575,11.613758369849005,453.9]
["WestMidlands","West Midlands",176.05002006167732,12.556167182203644,440.6]
["East","East",243.45761679371569,14.852221619919209,511.3]
["London","London",475.08191670848015,23.474746353813625,571.6]
["SouthEast","South East",292.20859264006691,16.593332915392782,561.29999999999995]
["SouthWest","South West",292.20859264006691,18.667897057437354,502.3]

{"sheet":"Life","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Region","2001-2003","2002-2004","2003-2005","2004-2006","2005-2007","2006-2008","2007-2009","2008-2010","2009-2011","2010-2012"]
["All Regions",{"$f":"AVERAGE(B3:B11)","v":76.122222222222206},76.40000000000002,76.766666666666666,77.155555555555551,77.500000000000014,77.766666666666666,78.055555555555557,78.37777777777778,78.788888888888877,79.077777777777769]
["North East",74.7,74.900000000000006,75.3,75.7,76.2,76.400000000000006,76.7,77.099999999999994,77.5,77.8]
["North West",74.8,75.099999999999994,75.400000000000006,75.8,76.099999999999994,76.400000000000006,76.599999999999994,77,77.400000000000006,77.7]
["Yorkshire and The Humber",75.599999999999994,75.8,76.2,76.5,76.8,77.099999999999994,77.400000000000006,77.7,78.099999999999994,78.3]
["East Midlands",76.3,76.5,76.900000000000006,77.3,77.599999999999994,77.8,78.099999999999994,78.3,78.7,79.099999999999994]
["West Midlands",75.599999999999994,75.900000000000006,76.2,76.599999999999994,76.900000000000006,77.2,77.5,77.900000000000006,78.400000000000006,78.7]
["East ",77.3,77.599999999999994,77.900000000000006,78.3,78.599999999999994,78.900000000000006,79.2,79.5,79.900000000000006,80.099999999999994]
["London",76,76.400000000000006,76.8,77.3,77.7,78.099999999999994,78.5,78.8,79.3,79.7]
["South East",77.400000000000006,77.7,78.099999999999994,78.5,78.900000000000006,79.099999999999994,79.400000000000006,79.7,80,80.3]
["South West",77.400000000000006,77.7,78.099999999999994,78.400000000000006,78.7,78.900000000000006,79.099999999999994,79.400000000000006,79.8,80]
[]
[]
[]
[null,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011]
[{"$f":"Map!B3","v":"London"},{"$f":"VLOOKUP($A16,$A$2:$K$11,COLUMN(),0)","v":76},76.400000000000006,76.8,77.3,77.7,78.099999999999994,78.5,78.8,79.3,79.7]

{"sheet":"Calcs","index":3,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Region","Result","0 to 9","10 to 19","20 to 30","30 to 59","60 to 74","75 and Over"]
[{"$f":"INDEX(Region,MATCH(B2,Data!$Q$2:$Q$11,0))","v":"South East"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A1))","v":8634750},{"$f":"VLOOKUP($A2,Data!$B$2:$I$11,COLUMN()-1,0)","v":1022293},{"$f":"VLOOKUP($A2,Data!$B$2:$I$11,COLUMN()-1,0)","v":1054559},{"$f":"VLOOKUP($A2,Data!$B$2:$I$11,COLUMN()-1,0)","v":1062344},{"$f":"VLOOKUP($A2,Data!$B$2:$I$11,COLUMN()-1,0)","v":3478135},{"$f":"VLOOKUP($A2,Data!$B$2:$I$11,COLUMN()-1,0)","v":1299094},{"$f":"VLOOKUP($A2,Data!$B$2:$I$11,COLUMN()-1,0)","v":718325}]
[{"$f":"INDEX(Region,MATCH(B3,Data!$Q$2:$Q$11,0))","v":"London"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A2))","v":8173941},{"$f":"VLOOKUP($A3,Data!$B$2:$I$11,COLUMN()-1,0)","v":1074304},{"$f":"VLOOKUP($A3,Data!$B$2:$I$11,COLUMN()-1,0)","v":928524},{"$f":"VLOOKUP($A3,Data!$B$2:$I$11,COLUMN()-1,0)","v":1462938},{"$f":"VLOOKUP($A3,Data!$B$2:$I$11,COLUMN()-1,0)","v":3460836},{"$f":"VLOOKUP($A3,Data!$B$2:$I$11,COLUMN()-1,0)","v":815648},{"$f":"VLOOKUP($A3,Data!$B$2:$I$11,COLUMN()-1,0)","v":431691}]
[{"$f":"INDEX(Region,MATCH(B4,Data!$Q$2:$Q$11,0))","v":"North West"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A3))","v":7052177},{"$f":"VLOOKUP($A4,Data!$B$2:$I$11,COLUMN()-1,0)","v":824257},{"$f":"VLOOKUP($A4,Data!$B$2:$I$11,COLUMN()-1,0)","v":869244},{"$f":"VLOOKUP($A4,Data!$B$2:$I$11,COLUMN()-1,0)","v":956222},{"$f":"VLOOKUP($A4,Data!$B$2:$I$11,COLUMN()-1,0)","v":2791655},{"$f":"VLOOKUP($A4,Data!$B$2:$I$11,COLUMN()-1,0)","v":1067386},{"$f":"VLOOKUP($A4,Data!$B$2:$I$11,COLUMN()-1,0)","v":543413}]
[{"$f":"INDEX(Region,MATCH(B5,Data!$Q$2:$Q$11,0))","v":"East"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A4))","v":5846965},{"$f":"VLOOKUP($A5,Data!$B$2:$I$11,COLUMN()-1,0)","v":689781},{"$f":"VLOOKUP($A5,Data!$B$2:$I$11,COLUMN()-1,0)","v":704150},{"$f":"VLOOKUP($A5,Data!$B$2:$I$11,COLUMN()-1,0)","v":715617},{"$f":"VLOOKUP($A5,Data!$B$2:$I$11,COLUMN()-1,0)","v":2340669},{"$f":"VLOOKUP($A5,Data!$B$2:$I$11,COLUMN()-1,0)","v":903959},{"$f":"VLOOKUP($A5,Data!$B$2:$I$11,COLUMN()-1,0)","v":492789}]
[{"$f":"INDEX(Region,MATCH(B6,Data!$Q$2:$Q$11,0))","v":"West Midlands"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A5))","v":5601847},{"$f":"VLOOKUP($A6,Data!$B$2:$I$11,COLUMN()-1,0)","v":681861},{"$f":"VLOOKUP($A6,Data!$B$2:$I$11,COLUMN()-1,0)","v":710070},{"$f":"VLOOKUP($A6,Data!$B$2:$I$11,COLUMN()-1,0)","v":744195},{"$f":"VLOOKUP($A6,Data!$B$2:$I$11,COLUMN()-1,0)","v":2184481},{"$f":"VLOOKUP($A6,Data!$B$2:$I$11,COLUMN()-1,0)","v":840954},{"$f":"VLOOKUP($A6,Data!$B$2:$I$11,COLUMN()-1,0)","v":440286}]
[{"$f":"INDEX(Region,MATCH(B7,Data!$Q$2:$Q$11,0))","v":"South West"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A6))","v":5288935},{"$f":"VLOOKUP($A7,Data!$B$2:$I$11,COLUMN()-1,0)","v":568783},{"$f":"VLOOKUP($A7,Data!$B$2:$I$11,COLUMN()-1,0)","v":624969},{"$f":"VLOOKUP($A7,Data!$B$2:$I$11,COLUMN()-1,0)","v":640325},{"$f":"VLOOKUP($A7,Data!$B$2:$I$11,COLUMN()-1,0)","v":2057907},{"$f":"VLOOKUP($A7,Data!$B$2:$I$11,COLUMN()-1,0)","v":894409},{"$f":"VLOOKUP($A7,Data!$B$2:$I$11,COLUMN()-1,0)","v":502542}]
[{"$f":"INDEX(Region,MATCH(B8,Data!$Q$2:$Q$11,0))","v":"Yorkshire And The Humber"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A7))","v":5283733},{"$f":"VLOOKUP($A8,Data!$B$2:$I$11,COLUMN()-1,0)","v":625922},{"$f":"VLOOKUP($A8,Data!$B$2:$I$11,COLUMN()-1,0)","v":654741},{"$f":"VLOOKUP($A8,Data!$B$2:$I$11,COLUMN()-1,0)","v":729983},{"$f":"VLOOKUP($A8,Data!$B$2:$I$11,COLUMN()-1,0)","v":2073187},{"$f":"VLOOKUP($A8,Data!$B$2:$I$11,COLUMN()-1,0)","v":789178},{"$f":"VLOOKUP($A8,Data!$B$2:$I$11,COLUMN()-1,0)","v":410722}]
[{"$f":"INDEX(Region,MATCH(B9,Data!$Q$2:$Q$11,0))","v":"East Midlands"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A8))","v":4533222},{"$f":"VLOOKUP($A9,Data!$B$2:$I$11,COLUMN()-1,0)","v":517738},{"$f":"VLOOKUP($A9,Data!$B$2:$I$11,COLUMN()-1,0)","v":560452},{"$f":"VLOOKUP($A9,Data!$B$2:$I$11,COLUMN()-1,0)","v":586257},{"$f":"VLOOKUP($A9,Data!$B$2:$I$11,COLUMN()-1,0)","v":1804426},{"$f":"VLOOKUP($A9,Data!$B$2:$I$11,COLUMN()-1,0)","v":706114},{"$f":"VLOOKUP($A9,Data!$B$2:$I$11,COLUMN()-1,0)","v":358235}]
[{"$f":"INDEX(Region,MATCH(B10,Data!$Q$2:$Q$11,0))","v":"North East"},{"$f":"LARGE(Data!$Q$2:$Q$11,ROW(A9))","v":2596886},{"$f":"VLOOKUP($A10,Data!$B$2:$I$11,COLUMN()-1,0)","v":286142},{"$f":"VLOOKUP($A10,Data!$B$2:$I$11,COLUMN()-1,0)","v":314485},{"$f":"VLOOKUP($A10,Data!$B$2:$I$11,COLUMN()-1,0)","v":348321},{"$f":"VLOOKUP($A10,Data!$B$2:$I$11,COLUMN()-1,0)","v":1029877},{"$f":"VLOOKUP($A10,Data!$B$2:$I$11,COLUMN()-1,0)","v":407818},{"$f":"VLOOKUP($A10,Data!$B$2:$I$11,COLUMN()-1,0)","v":210243}]
[]
[]
["Friendly Name","Region","Income","House","Multiple","Wkly Spend","Annual"]
["North East","North East",{"$f":"Data!J2/1000","v":13.329000000000001},{"$f":"Data!C15","v":140.21254852634644},{"$f":"D14/C14","v":10.519359931453705},{"$f":"Data!E15","v":408.7},{"$f":"F14*52","v":21252.399999999998}]
["North West","North West",{"$f":"Data!J3/1000","v":14.176},{"$f":"Data!C16","v":158.34820493715958},{"$f":"D15/C15","v":11.170161183490377},{"$f":"Data!E16","v":447.5},{"$f":"F15*52","v":23270}]
["Yorkshire & H","Yorkshire And The Humber",{"$f":"Data!J4/1000","v":13.593999999999999},{"$f":"Data!C17","v":158.53383936229167},11.662044972950691,{"$f":"Data!E17","v":422.7},21980.399999999998]
["East Midlands","East Midlands",{"$f":"Data!J5/1000","v":14.266999999999999},{"$f":"Data!C18","v":165.69349066263575},11.613758369849005,{"$f":"Data!E18","v":453.9},23602.799999999999]
["West Midlands","West Midlands",{"$f":"Data!J6/1000","v":14.021000000000001},{"$f":"Data!C19","v":176.05002006167732},12.556167182203644,{"$f":"Data!E19","v":440.6},22911.200000000001]
["East","East",{"$f":"Data!J7/1000","v":16.391999999999999},{"$f":"Data!C20","v":243.45761679371569},14.852221619919209,{"$f":"Data!E20","v":511.3},26587.600000000002]
["London","London",{"$f":"Data!J8/1000","v":20.238},{"$f":"Data!C21","v":475.08191670848015},23.474746353813625,{"$f":"Data!E21","v":571.6},29723.200000000001]
["South East","South East",{"$f":"Data!J9/1000","v":17.61},{"$f":"Data!C22","v":292.20859264006691},16.593332915392782,{"$f":"Data!E22","v":561.29999999999995},29187.599999999999]
["South West","South West",{"$f":"Data!J10/1000","v":15.653},{"$f":"Data!C23","v":292.20859264006691},18.667897057437354,{"$f":"Data!E23","v":502.3},26119.600000000002]

{"sheet":"Map","index":4,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[null,"Population"]
[null,{"$f":"B1&\" Metrics\"","v":"Population Metrics"}]
[null,"London"]
[]
[]
[null,{"$f":"B1","v":"Population"}]
[null,"0 to 3.0m",null,null,null,null,"Regions","Result %","Unemployment","0 to 9","10 to 19","20 to 30","30 to 59","60 to 74","75 and Over"]
[null,"3m to 5m",null,null,null,null,{"$f":"Calcs!A2","v":"South East"},{"$f":"Calcs!B2","v":8634750},{"$f":"REPT(\"|\",H8*100/MAX($H$8:$H$15))","v":"||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"Calcs!C2","v":1022293},{"$f":"Calcs!D2","v":1054559},{"$f":"Calcs!E2","v":1062344},{"$f":"Calcs!F2","v":3478135},{"$f":"Calcs!G2","v":1299094},{"$f":"Calcs!H2","v":718325}]
[null,"5m to 6m",null,null,null,null,{"$f":"Calcs!A3","v":"London"},{"$f":"Calcs!B3","v":8173941},{"$f":"REPT(\"|\",H9*100/MAX($H$8:$H$15))","v":"||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||"},{"$f":"Calcs!C3","v":1074304},{"$f":"Calcs!D3","v":928524},{"$f":"Calcs!E3","v":1462938},{"$f":"Calcs!F3","v":3460836},{"$f":"Calcs!G3","v":815648},{"$f":"Calcs!H3","v":431691}]
[null,"6m to 8m",null,null,null,null,{"$f":"Calcs!A4","v":"North West"},{"$f":"Calcs!B4","v":7052177},"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",{"$f":"Calcs!C4","v":824257},{"$f":"Calcs!D4","v":869244},{"$f":"Calcs!E4","v":956222},{"$f":"Calcs!F4","v":2791655},{"$f":"Calcs!G4","v":1067386},{"$f":"Calcs!H4","v":543413}]
[null,"8m +",null,null,null,null,{"$f":"Calcs!A5","v":"East"},{"$f":"Calcs!B5","v":5846965},"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",{"$f":"Calcs!C5","v":689781},{"$f":"Calcs!D5","v":704150},{"$f":"Calcs!E5","v":715617},{"$f":"Calcs!F5","v":2340669},{"$f":"Calcs!G5","v":903959},{"$f":"Calcs!H5","v":492789}]
[null,null,null,null,null,null,{"$f":"Calcs!A6","v":"West Midlands"},{"$f":"Calcs!B6","v":5601847},"||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",{"$f":"Calcs!C6","v":681861},{"$f":"Calcs!D6","v":710070},{"$f":"Calcs!E6","v":744195},{"$f":"Calcs!F6","v":2184481},{"$f":"Calcs!G6","v":840954},{"$f":"Calcs!H6","v":440286}]
[null,null,null,null,null,null,{"$f":"Calcs!A7","v":"South West"},{"$f":"Calcs!B7","v":5288935},"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",{"$f":"Calcs!C7","v":568783},{"$f":"Calcs!D7","v":624969},{"$f":"Calcs!E7","v":640325},{"$f":"Calcs!F7","v":2057907},{"$f":"Calcs!G7","v":894409},{"$f":"Calcs!H7","v":502542}]
[null,null,null,null,null,null,{"$f":"Calcs!A8","v":"Yorkshire And The Humber"},{"$f":"Calcs!B8","v":5283733},"|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||",{"$f":"Calcs!C8","v":625922},{"$f":"Calcs!D8","v":654741},{"$f":"Calcs!E8","v":729983},{"$f":"Calcs!F8","v":2073187},{"$f":"Calcs!G8","v":789178},{"$f":"Calcs!H8","v":410722}]
[null,null,null,null,null,null,{"$f":"Calcs!A9","v":"East Midlands"},{"$f":"Calcs!B9","v":4533222},"||||||||||||||||||||||||||||||||||||||||||||||||||||",{"$f":"Calcs!C9","v":517738},{"$f":"Calcs!D9","v":560452},{"$f":"Calcs!E9","v":586257},{"$f":"Calcs!F9","v":1804426},{"$f":"Calcs!G9","v":706114},{"$f":"Calcs!H9","v":358235}]
[]
[null,null,null,null,null,null,"Region","Avg House $","Multiple of Income"]
[null,null,null,null,null,null,{"$f":"Calcs!A14","v":"North East"},{"$f":"Calcs!D14","v":140.21254852634644},{"$f":"Calcs!E14","v":10.519359931453705}]
[null,null,null,null,null,null,{"$f":"Calcs!A15","v":"North West"},{"$f":"Calcs!D15","v":158.34820493715958},{"$f":"Calcs!E15","v":11.170161183490377}]
[null,null,null,null,null,null,{"$f":"Calcs!A16","v":"Yorkshire & H"},{"$f":"Calcs!D16","v":158.53383936229167},{"$f":"Calcs!E16","v":11.662044972950691}]
[null,null,null,null,null,null,{"$f":"Calcs!A17","v":"East Midlands"},{"$f":"Calcs!D17","v":165.69349066263575},{"$f":"Calcs!E17","v":11.613758369849005}]
[null,null,null,null,null,null,{"$f":"Calcs!A18","v":"West Midlands"},{"$f":"Calcs!D18","v":176.05002006167732},{"$f":"Calcs!E18","v":12.556167182203644}]
[null,null,null,null,null,null,{"$f":"Calcs!A19","v":"East"},{"$f":"Calcs!D19","v":243.45761679371569},{"$f":"Calcs!E19","v":14.852221619919209}]
[null,null,null,null,null,null,{"$f":"Calcs!A20","v":"London"},{"$f":"Calcs!D20","v":475.08191670848015},{"$f":"Calcs!E20","v":23.474746353813625}]
[null,null,null,null,null,null,{"$f":"Calcs!A21","v":"South East"},{"$f":"Calcs!D21","v":292.20859264006691},{"$f":"Calcs!E21","v":16.593332915392782}]
[null,null,null,null,null,null,{"$f":"Calcs!A22","v":"South West"},{"$f":"Calcs!D22","v":292.20859264006691},{"$f":"Calcs!E22","v":18.667897057437354}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Annual Spend (£)","Region","Weekly Spend (£)"]
[]
[null,null,null,null,null,null,"North East"]
[null,null,null,null,null,null,"North West"]
[null,null,null,null,null,null,"Yorkshire & H"]
[null,null,null,null,null,null,"East Midlands"]
[null,null,null,null,null,null,"West Midlands"]
[null,null,null,null,null,null,"East"]
[null,null,null,null,null,null,"London"]
[null,null,null,null,null,null,"South East"]
[null,null,null,null,null,null,"South West"]