{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["uk_postcode_map","data","control"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"uk_postcode_map","index":0,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"UK by Postcodes",null,null,null,"Measure",null,null,"Colors",null,null,null,"www.cs-analytics.de"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"control!D14","v":"0%  to 2%"}]
[null,null,{"$f":"control!D15","v":"2% to 4%"}]
[null,null,{"$f":"control!D16","v":"4% to 6%"}]
[null,null,{"$f":"control!D17","v":"6% to 8%"}]
[null,null,{"$f":"control!D18","v":"8% to 10%"}]
[null,null,{"$f":"control!D19","v":"10% to 12%"}]
[null,null,{"$f":"control!D20","v":"12% to 14%"}]
[null,null,{"$f":"control!D21","v":"14% to 16%"}]
[null,null,{"$f":"control!D22","v":"16% to 18%"}]
[null,null,{"$f":"control!D23","v":"18% or more"}]

{"sheet":"data","index":1,"n_rows":169,"n_cols":13,"rows_kept":169,"cut":false,"hidden":false,"merged":[[150,12,168,12],[129,12,149,12]]}
[]
[null,"Data",null,null,null,null,null,"Source: none (Dummy data)",null,"Selection / Shape Definition"]
[]
[null,"The source data",null,null,null,null,null,null,null,"Calculation of selected data, shape name definition and shape index"]
[null,"No.","Postal Area","Code","Measure 1","Measure 2","Measure 3","Selection",null,"Selection","Shape Names","Shape Index"]
[null,1,"Aberdeen","AB",7.0599999999999996E-2,3.5200000000000002E-2,0.1027,{"$f":"INDEX(E6:G6,,control!$C$10)","v":7.0599999999999996E-2},null,{"$f":"H6","v":7.0599999999999996E-2},"S_AB",114]
[null,{"$f":"B6+1","v":2},"St Albans","AL",0.1056,0.16969999999999999,1.5900000000000001E-2,{"$f":"INDEX(E7:G7,,control!$C$10)","v":0.1056},null,0.1056,"S_AL",47]
[null,3,"Birmingham","B",2.3099999999999999E-2,0.14219999999999999,7.2400000000000006E-2,{"$f":"INDEX(E8:G8,,control!$C$10)","v":2.3099999999999999E-2},null,2.3099999999999999E-2,"S_B",59]
[null,4,"Bath","BA",3.2500000000000001E-2,0.127,2.0500000000000001E-2,{"$f":"INDEX(E9:G9,,control!$C$10)","v":3.2500000000000001E-2},null,3.2500000000000001E-2,"S_BA",17]
[null,5,"Blackburn","BB",9.4100000000000003E-2,0.1192,0.15210000000000001,{"$f":"INDEX(E10:G10,,control!$C$10)","v":9.4100000000000003E-2},null,9.4100000000000003E-2,"S_BB",90]
[null,6,"Bradford","BD",5.3900000000000003E-2,8.5400000000000004E-2,4.3200000000000002E-2,{"$f":"INDEX(E11:G11,,control!$C$10)","v":5.3900000000000003E-2},null,5.3900000000000003E-2,"S_BD",91]
[null,7,"Bournemouth","BH",0.13639999999999999,0.1406,0.1149,{"$f":"INDEX(E12:G12,,control!$C$10)","v":0.13639999999999999},null,0.13639999999999999,"S_BH",11]
[null,8,"Bolton","BL",0.1145,7.4300000000000005E-2,0.1668,{"$f":"INDEX(E13:G13,,control!$C$10)","v":0.1145},null,0.1145,"S_BL",85]
[null,9,"Brighton","BN",9.6100000000000005E-2,0.1051,9.6000000000000002E-2,{"$f":"INDEX(E14:G14,,control!$C$10)","v":9.6100000000000005E-2},null,9.6100000000000005E-2,"S_BN",13]
[null,10,"Bromley","BR",0.14019999999999999,0.1022,8.6900000000000005E-2,{"$f":"INDEX(E15:G15,,control!$C$10)","v":0.14019999999999999},null,0.14019999999999999,"S_BR",28]
[null,11,"Bristol","BS",0.16889999999999999,0.18390000000000001,3.0000000000000001E-3,{"$f":"INDEX(E16:G16,,control!$C$10)","v":0.16889999999999999},null,0.16889999999999999,"S_BS",18]
[null,12,"Carlisle","CA",9.4000000000000004E-3,0.16289999999999999,9.1200000000000003E-2,{"$f":"INDEX(E17:G17,,control!$C$10)","v":9.4000000000000004E-3},null,9.4000000000000004E-3,"S_CA",100]
[null,13,"Cambridge","CB",0.1971,2.6499999999999999E-2,0.12180000000000001,{"$f":"INDEX(E18:G18,,control!$C$10)","v":0.1971},null,0.1971,"S_CB",55]
[null,14,"Cardiff","CF",0.10340000000000001,9.4600000000000004E-2,0.193,{"$f":"INDEX(E19:G19,,control!$C$10)","v":0.10340000000000001},null,0.10340000000000001,"S_CF",68]
[null,15,"Chester","CH",9.3399999999999997E-2,7.3400000000000007E-2,0.12089999999999999,{"$f":"INDEX(E20:G20,,control!$C$10)","v":9.3399999999999997E-2},null,9.3399999999999997E-2,"S_CH",78]
[null,16,"Chelmsford","CM",0.18770000000000001,0.15010000000000001,9.8500000000000004E-2,{"$f":"INDEX(E21:G21,,control!$C$10)","v":0.18770000000000001},null,0.18770000000000001,"S_CM",49]
[null,17,"Colchester","CO",1.01E-2,1.66E-2,0.12180000000000001,{"$f":"INDEX(E22:G22,,control!$C$10)","v":1.01E-2},null,1.01E-2,"S_CO",53]
[null,18,"Croydon","CR",0.1142,0.16020000000000001,9.9199999999999997E-2,{"$f":"INDEX(E23:G23,,control!$C$10)","v":0.1142},null,0.1142,"S_CR",26]
[null,19,"Canterbury","CT",0.1134,0.1168,0.1067,{"$f":"INDEX(E24:G24,,control!$C$10)","v":0.1134},null,0.1134,"S_CT",15]
[null,20,"Coventry","CV",9.9400000000000002E-2,0.17580000000000001,1.8700000000000001E-2,{"$f":"INDEX(E25:G25,,control!$C$10)","v":9.9400000000000002E-2},null,9.9400000000000002E-2,"S_CV",58]
[null,21,"Crewe","CW",1.1999999999999999E-3,4.5999999999999999E-3,3.27E-2,{"$f":"INDEX(E26:G26,,control!$C$10)","v":1.1999999999999999E-3},null,1.1999999999999999E-3,"S_CW",76]
[null,22,"Dartford","DA",6.9699999999999998E-2,1.46E-2,0.18149999999999999,{"$f":"INDEX(E27:G27,,control!$C$10)","v":6.9699999999999998E-2},null,6.9699999999999998E-2,"S_DA",29]
[null,23,"Dundee","DD",0.16789999999999999,0.18060000000000001,0.19869999999999999,{"$f":"INDEX(E28:G28,,control!$C$10)","v":0.16789999999999999},null,0.16789999999999999,"S_DD",113]
[null,24,"Derby","DE",6.25E-2,0.1845,0.1605,{"$f":"INDEX(E29:G29,,control!$C$10)","v":6.25E-2},null,6.25E-2,"S_DE",66]
[null,25,"Dumfries","DG",0.13009999999999999,8.2100000000000006E-2,6.7799999999999999E-2,{"$f":"INDEX(E30:G30,,control!$C$10)","v":0.13009999999999999},null,0.13009999999999999,"S_DG",104]
[null,26,"Durham","DH",8.3400000000000002E-2,0.11849999999999999,5.8500000000000003E-2,{"$f":"INDEX(E31:G31,,control!$C$10)","v":8.3400000000000002E-2},null,8.3400000000000002E-2,"S_DH",101]
[null,27,"Darlington","DL",0.1138,6.4600000000000005E-2,6.88E-2,{"$f":"INDEX(E32:G32,,control!$C$10)","v":0.1138},null,0.1138,"S_DL",97]
[null,28,"Doncaster","DN",1.4E-3,0.14330000000000001,0.13930000000000001,{"$f":"INDEX(E33:G33,,control!$C$10)","v":1.4E-3},null,1.4E-3,"S_DN",64]
[null,29,"Dorchester","DT",0.1273,8.4199999999999997E-2,0.11899999999999999,{"$f":"INDEX(E34:G34,,control!$C$10)","v":0.1273},null,0.1273,"S_DT",10]
[null,30,"Dudley","DY",0.14929999999999999,6.5100000000000005E-2,0.19339999999999999,{"$f":"INDEX(E35:G35,,control!$C$10)","v":0.14929999999999999},null,0.14929999999999999,"S_DY",72]
[null,31,"London E","E",4.1599999999999998E-2,0.15720000000000001,3.4299999999999997E-2,{"$f":"INDEX(E36:G36,,control!$C$10)","v":4.1599999999999998E-2},null,4.1599999999999998E-2,"S_E",121]
[null,32,"London EC","EC",0.13469999999999999,0.19009999999999999,9.7799999999999998E-2,{"$f":"INDEX(E37:G37,,control!$C$10)","v":0.13469999999999999},null,0.13469999999999999,"S_EC",123]
[null,33,"Edinburgh","EH",0.12280000000000001,0.13550000000000001,9.1700000000000004E-2,{"$f":"INDEX(E38:G38,,control!$C$10)","v":0.12280000000000001},null,{"$f":"H38","v":0.12280000000000001},"S_EH",108]
[null,{"$f":"B38+1","v":34},"Enfield","EN",3.5499999999999997E-2,7.6799999999999993E-2,2.8500000000000001E-2,{"$f":"INDEX(E39:G39,,control!$C$10)","v":3.5499999999999997E-2},null,3.5499999999999997E-2,"S_EN",37]
[null,35,"Exeter","EX",0.16900000000000001,4.8999999999999998E-3,0.18609999999999999,{"$f":"INDEX(E40:G40,,control!$C$10)","v":0.16900000000000001},null,0.16900000000000001,"S_EX",8]
[null,36,"Falkirk and Stirling","FK",0.17879999999999999,0.1208,9.9000000000000008E-3,{"$f":"INDEX(E41:G41,,control!$C$10)","v":0.17879999999999999},null,0.17879999999999999,"S_FK",109]
[null,37,"Fylde","FY",9.4299999999999995E-2,0.1799,2.8899999999999999E-2,{"$f":"INDEX(E42:G42,,control!$C$10)","v":9.4299999999999995E-2},null,9.4299999999999995E-2,"S_FY",98]
[null,38,"Glasgow","G",7.8700000000000006E-2,0.1043,0.1789,{"$f":"INDEX(E43:G43,,control!$C$10)","v":7.8700000000000006E-2},null,7.8700000000000006E-2,"S_G",111]
[null,39,"Gloucester","GL",9.5200000000000007E-2,0.18240000000000001,6.6199999999999995E-2,{"$f":"INDEX(E44:G44,,control!$C$10)","v":9.5200000000000007E-2},null,9.5200000000000007E-2,"S_GL",41]
[null,40,"Guildford","GU",9.6699999999999994E-2,1.44E-2,0.1419,{"$f":"INDEX(E45:G45,,control!$C$10)","v":9.6699999999999994E-2},null,9.6699999999999994E-2,"S_GU",21]
[null,41,"Harrow","HA",8.2799999999999999E-2,0.02,2.0199999999999999E-2,{"$f":"INDEX(E46:G46,,control!$C$10)","v":8.2799999999999999E-2},null,8.2799999999999999E-2,"S_HA",34]
[null,42,"Huddersfield","HD",6.25E-2,0.16520000000000001,5.7099999999999998E-2,{"$f":"INDEX(E47:G47,,control!$C$10)","v":6.25E-2},null,6.25E-2,"S_HD",86]
[null,43,"Harrogate","HG",7.85E-2,4.1999999999999997E-3,7.6499999999999999E-2,{"$f":"INDEX(E48:G48,,control!$C$10)","v":7.85E-2},null,7.85E-2,"S_HG",95]
[null,44,"Hemel Hempstead","HP",0.10879999999999999,0.14560000000000001,5.3199999999999997E-2,{"$f":"INDEX(E49:G49,,control!$C$10)","v":0.10879999999999999},null,0.10879999999999999,"S_HP",39]
[null,45,"Hereford","HR",5.96E-2,0.15340000000000001,3.39E-2,{"$f":"INDEX(E50:G50,,control!$C$10)","v":5.96E-2},null,5.96E-2,"S_HR",42]
[null,46,"Outer Hebrides","HS",0.1016,1.3899999999999999E-2,0.19359999999999999,{"$f":"INDEX(E51:G51,,control!$C$10)","v":0.1016},null,0.1016,"S_HS",118]
[null,47,"Hull","HU",7.1999999999999998E-3,0.12859999999999999,0.19409999999999999,{"$f":"INDEX(E52:G52,,control!$C$10)","v":7.1999999999999998E-3},null,7.1999999999999998E-3,"S_HU",93]
[null,48,"Halifax","HX",8.5599999999999996E-2,4.4900000000000002E-2,0.1351,{"$f":"INDEX(E53:G53,,control!$C$10)","v":8.5599999999999996E-2},null,8.5599999999999996E-2,"S_HX",87]
[null,49,"Ilford","IG",0.1138,7.6999999999999999E-2,0.1595,{"$f":"INDEX(E54:G54,,control!$C$10)","v":0.1138},null,0.1138,"S_IG",50]
[null,50,"Ipswich","IP",7.1099999999999997E-2,7.8700000000000006E-2,0.12620000000000001,{"$f":"INDEX(E55:G55,,control!$C$10)","v":7.1099999999999997E-2},null,7.1099999999999997E-2,"S_IP",54]
[null,51,"Inverness","IV",0.19139999999999999,0.17249999999999999,0.1938,{"$f":"INDEX(E56:G56,,control!$C$10)","v":0.19139999999999999},null,0.19139999999999999,"S_IV",1]
[null,52,"Kilmarnock","KA",9.1499999999999998E-2,0.16309999999999999,8.6E-3,{"$f":"INDEX(E57:G57,,control!$C$10)","v":9.1499999999999998E-2},null,9.1499999999999998E-2,"S_KA",106]
[null,53,"Kingston upon Thames","KT",0.18410000000000001,0.13320000000000001,0.14749999999999999,{"$f":"INDEX(E58:G58,,control!$C$10)","v":0.18410000000000001},null,0.18410000000000001,"S_KT",25]
[null,54,"Kirkwall","KW",0.1613,3.8899999999999997E-2,4.4999999999999997E-3,{"$f":"INDEX(E59:G59,,control!$C$10)","v":0.1613},null,0.1613,"S_KW",117]
[null,55,"Kirkcaldy","KY",8.8200000000000001E-2,0.10580000000000001,4.3700000000000003E-2,{"$f":"INDEX(E60:G60,,control!$C$10)","v":8.8200000000000001E-2},null,8.8200000000000001E-2,"S_KY",110]
[null,56,"Liverpool","L",9.1899999999999996E-2,0.1958,5.7500000000000002E-2,{"$f":"INDEX(E61:G61,,control!$C$10)","v":9.1899999999999996E-2},null,9.1899999999999996E-2,"S_L",81]
[null,57,"Lancaster","LA",0.1116,2.8400000000000002E-2,0.15740000000000001,{"$f":"INDEX(E62:G62,,control!$C$10)","v":0.1116},null,0.1116,"S_LA",99]
[null,58,"Llandrindod Wells","LD",3.7000000000000002E-3,0.17299999999999999,0.10299999999999999,{"$f":"INDEX(E63:G63,,control!$C$10)","v":3.7000000000000002E-3},null,3.7000000000000002E-3,"S_LD",70]
[null,59,"Leicester","LE",0.16650000000000001,0.18920000000000001,9.4799999999999995E-2,{"$f":"INDEX(E64:G64,,control!$C$10)","v":0.16650000000000001},null,0.16650000000000001,"S_LE",60]
[null,60,"Llandudno","LL",8.6400000000000005E-2,0.1173,0.18809999999999999,{"$f":"INDEX(E65:G65,,control!$C$10)","v":8.6400000000000005E-2},null,8.6400000000000005E-2,"S_LL",77]
[null,61,"Lincoln","LN",0.1091,1.8599999999999998E-2,1.49E-2,{"$f":"INDEX(E66:G66,,control!$C$10)","v":0.1091},null,0.1091,"S_LN",63]
[null,62,"Leeds","LS",1.54E-2,0.1255,0.13300000000000001,{"$f":"INDEX(E67:G67,,control!$C$10)","v":1.54E-2},null,1.54E-2,"S_LS",92]
[null,63,"Luton","LU",0.17399999999999999,6.7599999999999993E-2,2.8899999999999999E-2,{"$f":"INDEX(E68:G68,,control!$C$10)","v":0.17399999999999999},null,0.17399999999999999,"S_LU",46]
[null,64,"Manchester","M",8.0799999999999997E-2,8.6099999999999996E-2,0.1246,{"$f":"INDEX(E69:G69,,control!$C$10)","v":8.0799999999999997E-2},null,8.0799999999999997E-2,"S_M",82]
[null,65,"Medway","ME",7.7899999999999997E-2,1.2699999999999999E-2,8.1900000000000001E-2,{"$f":"INDEX(E70:G70,,control!$C$10)","v":7.7899999999999997E-2},null,{"$f":"H70","v":7.7899999999999997E-2},"S_ME",16]
[null,{"$f":"B70+1","v":66},"Milton Keynes","MK",0.12870000000000001,0.16200000000000001,8.1299999999999997E-2,{"$f":"INDEX(E71:G71,,control!$C$10)","v":0.12870000000000001},null,0.12870000000000001,"S_MK",45]
[null,67,"Motherwell","ML",0.11609999999999999,7.6399999999999996E-2,0.1474,{"$f":"INDEX(E72:G72,,control!$C$10)","v":0.11609999999999999},null,0.11609999999999999,"S_ML",107]
[null,68,"London N","N",7.1099999999999997E-2,0.19839999999999999,5.1799999999999999E-2,{"$f":"INDEX(E73:G73,,control!$C$10)","v":7.1099999999999997E-2},null,7.1099999999999997E-2,"S_N",122]
[null,69,"Newcastle upon Tyne","NE",0.14130000000000001,7.0000000000000001E-3,0.1464,{"$f":"INDEX(E74:G74,,control!$C$10)","v":0.14130000000000001},null,0.14130000000000001,"S_NE",103]
[null,70,"Nottingham","NG",1.52E-2,0.16159999999999999,0.1764,{"$f":"INDEX(E75:G75,,control!$C$10)","v":1.52E-2},null,1.52E-2,"S_NG",62]
[null,71,"Northampton","NN",0.14369999999999999,5.1200000000000002E-2,0.19209999999999999,{"$f":"INDEX(E76:G76,,control!$C$10)","v":0.14369999999999999},null,0.14369999999999999,"S_NN",44]
[null,72,"Newport","NP",0.19539999999999999,0.12809999999999999,0.1032,{"$f":"INDEX(E77:G77,,control!$C$10)","v":0.19539999999999999},null,0.19539999999999999,"S_NP",67]
[null,73,"Norwich","NR",5.7500000000000002E-2,0.1812,0.1893,{"$f":"INDEX(E78:G78,,control!$C$10)","v":5.7500000000000002E-2},null,5.7500000000000002E-2,"S_NR",56]
[null,74,"London NW","NW",0.108,7.6300000000000007E-2,7.6600000000000001E-2,{"$f":"INDEX(E79:G79,,control!$C$10)","v":0.108},null,0.108,"S_NW",33]
[null,75,"Oldham","OL",0.12859999999999999,0.15329999999999999,0.16370000000000001,{"$f":"INDEX(E80:G80,,control!$C$10)","v":0.12859999999999999},null,0.12859999999999999,"S_OL",83]
[null,76,"Oxford","OX",0.1575,0.12690000000000001,9.74E-2,{"$f":"INDEX(E81:G81,,control!$C$10)","v":0.1575},null,0.1575,"S_OX",40]
[null,77,"Paisley","PA",3.8399999999999997E-2,0.111,9.5699999999999993E-2,{"$f":"INDEX(E82:G82,,control!$C$10)","v":3.8399999999999997E-2},null,3.8399999999999997E-2,"S_PA",112]
[null,78,"Peterborough","PE",0.17430000000000001,4.87E-2,0.1585,{"$f":"INDEX(E83:G83,,control!$C$10)","v":0.17430000000000001},null,0.17430000000000001,"S_PE",57]
[null,79,"Perth","PH",0.12820000000000001,6.6199999999999995E-2,0.1192,{"$f":"INDEX(E84:G84,,control!$C$10)","v":0.12820000000000001},null,0.12820000000000001,"S_PH",115]
[null,80,"Plymouth","PL",4.5699999999999998E-2,0.1837,6.9000000000000006E-2,{"$f":"INDEX(E85:G85,,control!$C$10)","v":4.5699999999999998E-2},null,4.5699999999999998E-2,"S_PL",120]
[null,81,"Portsmouth","PO",9.8299999999999998E-2,1.5800000000000002E-2,0.1216,{"$f":"INDEX(E86:G86,,control!$C$10)","v":9.8299999999999998E-2},null,9.8299999999999998E-2,"S_PO",12]
[null,82,"Preston","PR",0.19450000000000001,0.19939999999999999,5.5199999999999999E-2,{"$f":"INDEX(E87:G87,,control!$C$10)","v":0.19450000000000001},null,0.19450000000000001,"S_PR",89]
[null,83,"Reading","RG",0.18260000000000001,0.1545,0.1061,{"$f":"INDEX(E88:G88,,control!$C$10)","v":0.18260000000000001},null,0.18260000000000001,"S_RG",23]
[null,84,"Redhill","RH",0.13639999999999999,0.10100000000000001,7.4999999999999997E-3,{"$f":"INDEX(E89:G89,,control!$C$10)","v":0.13639999999999999},null,0.13639999999999999,"S_RH",22]
[null,85,"Romford","RM",9.1800000000000007E-2,0.13519999999999999,2.3599999999999999E-2,{"$f":"INDEX(E90:G90,,control!$C$10)","v":9.1800000000000007E-2},null,9.1800000000000007E-2,"S_RM",51]
[null,86,"Sheffield","S",0.13819999999999999,4.8099999999999997E-2,6.8099999999999994E-2,{"$f":"INDEX(E91:G91,,control!$C$10)","v":0.13819999999999999},null,0.13819999999999999,"S_S",65]
[null,87,"Swansea","SA",0.1691,0.14560000000000001,7.9899999999999999E-2,{"$f":"INDEX(E92:G92,,control!$C$10)","v":0.1691},null,0.1691,"S_SA",69]
[null,88,"London SE","SE",0.15079999999999999,9.8199999999999996E-2,0.16059999999999999,{"$f":"INDEX(E93:G93,,control!$C$10)","v":0.15079999999999999},null,0.15079999999999999,"S_SE",30]
[null,89,"Stevenage","SG",6.5799999999999997E-2,0.16250000000000001,0.15909999999999999,{"$f":"INDEX(E94:G94,,control!$C$10)","v":6.5799999999999997E-2},null,6.5799999999999997E-2,"S_SG",48]
[null,90,"Stockport","SK",9.5399999999999999E-2,0.15909999999999999,0.13689999999999999,{"$f":"INDEX(E95:G95,,control!$C$10)","v":9.5399999999999999E-2},null,9.5399999999999999E-2,"S_SK",79]
[null,91,"Slough","SL",8.8000000000000005E-3,0.14019999999999999,0.16439999999999999,{"$f":"INDEX(E96:G96,,control!$C$10)","v":8.8000000000000005E-3},null,8.8000000000000005E-3,"S_SL",38]
[null,92,"Sutton","SM",7.8200000000000006E-2,7.1199999999999999E-2,0.10100000000000001,{"$f":"INDEX(E97:G97,,control!$C$10)","v":7.8200000000000006E-2},null,7.8200000000000006E-2,"S_SM",27]
[null,93,"Swindon","SN",0.1179,9.1999999999999998E-3,0.14169999999999999,{"$f":"INDEX(E98:G98,,control!$C$10)","v":0.1179},null,0.1179,"S_SN",20]
[null,94,"Southampton","SO",1.2500000000000001E-2,0.1827,7.6499999999999999E-2,{"$f":"INDEX(E99:G99,,control!$C$10)","v":1.2500000000000001E-2},null,1.2500000000000001E-2,"S_SO",2]
[null,95,"Salisbury","SP",0.18990000000000001,5.96E-2,6.88E-2,{"$f":"INDEX(E100:G100,,control!$C$10)","v":0.18990000000000001},null,0.18990000000000001,"S_SP",19]
[null,96,"Sunderland","SR",0.1215,6.54E-2,0.16700000000000001,{"$f":"INDEX(E101:G101,,control!$C$10)","v":0.1215},null,0.1215,"S_SR",102]
[null,97,"Southend-on-Sea","SS",0.11559999999999999,5.28E-2,6.7000000000000002E-3,{"$f":"INDEX(E102:G102,,control!$C$10)","v":0.11559999999999999},null,{"$f":"H102","v":0.11559999999999999},"S_SS",52]
[null,{"$f":"B102+1","v":98},"Stoke-on-Trent","ST",9.3700000000000006E-2,0.1767,2.3E-3,{"$f":"INDEX(E103:G103,,control!$C$10)","v":9.3700000000000006E-2},null,9.3700000000000006E-2,"S_ST",75]
[null,99,"London SW","SW",0.1996,0.16950000000000001,4.87E-2,{"$f":"INDEX(E104:G104,,control!$C$10)","v":0.1996},null,0.1996,"S_SW",31]
[null,100,"Shrewsbury","SY",0.1188,0.17979999999999999,0.19869999999999999,{"$f":"INDEX(E105:G105,,control!$C$10)","v":0.1188},null,0.1188,"S_SY",71]
[null,101,"Taunton","TA",3.2399999999999998E-2,4.1799999999999997E-2,0.1055,{"$f":"INDEX(E106:G106,,control!$C$10)","v":3.2399999999999998E-2},null,3.2399999999999998E-2,"S_TA",9]
[null,102,"Tweeddale","TD",2.6700000000000002E-2,4.8500000000000001E-2,0.17699999999999999,{"$f":"INDEX(E107:G107,,control!$C$10)","v":2.6700000000000002E-2},null,2.6700000000000002E-2,"S_TD",105]
[null,103,"Telford","TF",9.5200000000000007E-2,0.17630000000000001,1.0200000000000001E-2,{"$f":"INDEX(E108:G108,,control!$C$10)","v":9.5200000000000007E-2},null,9.5200000000000007E-2,"S_TF",74]
[null,104,"Tonbridge","TN",0.19689999999999999,0.1739,1.44E-2,{"$f":"INDEX(E109:G109,,control!$C$10)","v":0.19689999999999999},null,0.19689999999999999,"S_TN",14]
[null,105,"Torquay","TQ",6.0900000000000003E-2,0.15579999999999999,9.7000000000000003E-2,{"$f":"INDEX(E110:G110,,control!$C$10)","v":6.0900000000000003E-2},null,6.0900000000000003E-2,"S_TQ",7]
[null,106,"Truro","TR",4.53E-2,2.2800000000000001E-2,5.3199999999999997E-2,{"$f":"INDEX(E111:G111,,control!$C$10)","v":4.53E-2},null,4.53E-2,"S_TR",6]
[null,107,"Teesside","TS",4.7E-2,0.1966,0.17960000000000001,{"$f":"INDEX(E112:G112,,control!$C$10)","v":4.7E-2},null,4.7E-2,"S_TS",96]
[null,108,"Twickenham","TW",3.1699999999999999E-2,0.16470000000000001,0.1027,{"$f":"INDEX(E113:G113,,control!$C$10)","v":3.1699999999999999E-2},null,3.1699999999999999E-2,"S_TW",24]
[null,109,"Uxbridge","UB",0.12509999999999999,0.15329999999999999,0.11070000000000001,{"$f":"INDEX(E114:G114,,control!$C$10)","v":0.12509999999999999},null,0.12509999999999999,"S_UB",35]
[null,110,"London W","W",1.0699999999999999E-2,7.6499999999999999E-2,0.15029999999999999,{"$f":"INDEX(E115:G115,,control!$C$10)","v":1.0699999999999999E-2},null,1.0699999999999999E-2,"S_W",32]
[null,111,"Warrington","WA",2.1700000000000001E-2,8.1600000000000006E-2,0.12759999999999999,{"$f":"INDEX(E116:G116,,control!$C$10)","v":2.1700000000000001E-2},null,2.1700000000000001E-2,"S_WA",80]
[null,112,"London WC","WC",0.17680000000000001,1.32E-2,0.15989999999999999,{"$f":"INDEX(E117:G117,,control!$C$10)","v":0.17680000000000001},null,0.17680000000000001,"S_WC",124]
[null,113,"Watford","WD",0.19070000000000001,0.13569999999999999,2.0299999999999999E-2,{"$f":"INDEX(E118:G118,,control!$C$10)","v":0.19070000000000001},null,0.19070000000000001,"S_WD",36]
[null,114,"Wakefield","WF",0.121,7.7600000000000002E-2,5.3699999999999998E-2,{"$f":"INDEX(E119:G119,,control!$C$10)","v":0.121},null,0.121,"S_WF",88]
[null,115,"Wigan","WN",0.17330000000000001,0.14199999999999999,0.1658,{"$f":"INDEX(E120:G120,,control!$C$10)","v":0.17330000000000001},null,0.17330000000000001,"S_WN",84]
[null,116,"Worcester","WR",0.18729999999999999,0.1288,5.9200000000000003E-2,{"$f":"INDEX(E121:G121,,control!$C$10)","v":0.18729999999999999},null,0.18729999999999999,"S_WR",43]
[null,117,"Walsall","WS",9.4299999999999995E-2,9.4799999999999995E-2,3.3E-3,{"$f":"INDEX(E122:G122,,control!$C$10)","v":9.4299999999999995E-2},null,9.4299999999999995E-2,"S_WS",61]
[null,118,"Wolverhampton","WV",0.16389999999999999,7.0000000000000007E-2,9.8699999999999996E-2,{"$f":"INDEX(E123:G123,,control!$C$10)","v":0.16389999999999999},null,0.16389999999999999,"S_WV",73]
[null,119,"York","YO",0.17879999999999999,0.1323,5.11E-2,{"$f":"INDEX(E124:G124,,control!$C$10)","v":0.17879999999999999},null,0.17879999999999999,"S_YO",94]
[null,120,"Lerwick","ZE",3.2399999999999998E-2,0.1212,0.11409999999999999,{"$f":"INDEX(E125:G125,,control!$C$10)","v":3.2399999999999998E-2},null,3.2399999999999998E-2,"S_ZE",4]
[null,121,null,"BT",6.7000000000000004E-2,4.9700000000000001E-2,5.6399999999999999E-2,{"$f":"INDEX(E126:G126,,control!$C$10)","v":6.7000000000000004E-2},null,6.7000000000000004E-2,"S_BT",3]
[null,122,null,"GY",7.2400000000000006E-2,6.7599999999999993E-2,0.127,{"$f":"INDEX(E127:G127,,control!$C$10)","v":7.2400000000000006E-2},null,7.2400000000000006E-2,"S_GY",119]
[null,123,null,"IM",0.13100000000000001,2.1399999999999999E-2,2.8E-3,{"$f":"INDEX(E128:G128,,control!$C$10)","v":0.13100000000000001},null,0.13100000000000001,"S_IM",5]
[null,124,null,"JE",1.6999999999999999E-3,7.9000000000000008E-3,5.3100000000000001E-2,{"$f":"INDEX(E129:G129,,control!$C$10)","v":1.6999999999999999E-3},null,1.6999999999999999E-3,"S_JE",116]
[null,125,"London WC","WC",{"$f":"INDEX(E$6:E$129,MATCH($D130,$D$6:$D$129,0),1)","v":0.17680000000000001},1.32E-2,0.15989999999999999,{"$f":"INDEX(E130:G130,,control!$C$10)","v":0.17680000000000001},null,0.17680000000000001,"S_WC_M",145,"Magnifier Shapes London Area (values are calculated by formulas)"]
[null,126,"London EC","EC",0.13469999999999999,0.19009999999999999,9.7799999999999998E-2,{"$f":"INDEX(E131:G131,,control!$C$10)","v":0.13469999999999999},null,0.13469999999999999,"S_EC_M",144]
[null,127,"London N","N",7.1099999999999997E-2,0.19839999999999999,5.1799999999999999E-2,{"$f":"INDEX(E132:G132,,control!$C$10)","v":7.1099999999999997E-2},null,7.1099999999999997E-2,"S_N_M",143]
[null,128,"London E","E",4.1599999999999998E-2,0.15720000000000001,3.4299999999999997E-2,{"$f":"INDEX(E133:G133,,control!$C$10)","v":4.1599999999999998E-2},null,4.1599999999999998E-2,"S_E_M",142]
[null,129,"Romford","RM",9.1800000000000007E-2,0.13519999999999999,2.3599999999999999E-2,{"$f":"INDEX(E134:G134,,control!$C$10)","v":9.1800000000000007E-2},null,{"$f":"H134","v":9.1800000000000007E-2},"S_RM_M",141]
[null,{"$f":"B134+1","v":130},"Ilford","IG",0.1138,7.6999999999999999E-2,0.1595,{"$f":"INDEX(E135:G135,,control!$C$10)","v":0.1138},null,0.1138,"S_IG_M",140]
[null,131,"Enfield","EN",3.5499999999999997E-2,7.6799999999999993E-2,2.8500000000000001E-2,{"$f":"INDEX(E136:G136,,control!$C$10)","v":3.5499999999999997E-2},null,3.5499999999999997E-2,"S_EN_M",138]
[null,132,"Watford","WD",0.19070000000000001,0.13569999999999999,2.0299999999999999E-2,{"$f":"INDEX(E137:G137,,control!$C$10)","v":0.19070000000000001},null,0.19070000000000001,"S_WD_M",137]
[null,133,"Uxbridge","UB",0.12509999999999999,0.15329999999999999,0.11070000000000001,{"$f":"INDEX(E138:G138,,control!$C$10)","v":0.12509999999999999},null,0.12509999999999999,"S_UB_M",136]
[null,134,"Harrow","HA",8.2799999999999999E-2,0.02,2.0199999999999999E-2,{"$f":"INDEX(E139:G139,,control!$C$10)","v":8.2799999999999999E-2},null,8.2799999999999999E-2,"S_HA_M",135]
[null,135,"London NW","NW",0.108,7.6300000000000007E-2,7.6600000000000001E-2,{"$f":"INDEX(E140:G140,,control!$C$10)","v":0.108},null,0.108,"S_NW_M",134]
[null,136,"London W","W",1.0699999999999999E-2,7.6499999999999999E-2,0.15029999999999999,{"$f":"INDEX(E141:G141,,control!$C$10)","v":1.0699999999999999E-2},null,1.0699999999999999E-2,"S_W_M",133]
[null,137,"London SW","SW",0.1996,0.16950000000000001,4.87E-2,{"$f":"INDEX(E142:G142,,control!$C$10)","v":0.1996},null,0.1996,"S_SW_M",132]
[null,138,"London SE","SE",0.15079999999999999,9.8199999999999996E-2,0.16059999999999999,{"$f":"INDEX(E143:G143,,control!$C$10)","v":0.15079999999999999},null,0.15079999999999999,"S_SE_M",131]
[null,139,"Dartford","DA",6.9699999999999998E-2,1.46E-2,0.18149999999999999,{"$f":"INDEX(E144:G144,,control!$C$10)","v":6.9699999999999998E-2},null,6.9699999999999998E-2,"S_DA_M",130]
[null,140,"Bromley","BR",0.14019999999999999,0.1022,8.6900000000000005E-2,{"$f":"INDEX(E145:G145,,control!$C$10)","v":0.14019999999999999},null,0.14019999999999999,"S_BR_M",129]
[null,141,"Sutton","SM",7.8200000000000006E-2,7.1199999999999999E-2,0.10100000000000001,{"$f":"INDEX(E146:G146,,control!$C$10)","v":7.8200000000000006E-2},null,7.8200000000000006E-2,"S_SM_M",128]
[null,142,"Croydon","CR",0.1142,0.16020000000000001,9.9199999999999997E-2,{"$f":"INDEX(E147:G147,,control!$C$10)","v":0.1142},null,0.1142,"S_CR_M",127]
[null,143,"Kingston upon Thames","KT",0.18410000000000001,0.13320000000000001,0.14749999999999999,{"$f":"INDEX(E148:G148,,control!$C$10)","v":0.18410000000000001},null,0.18410000000000001,"S_KT_M",126]
[null,144,"Twickenham","TW",3.1699999999999999E-2,0.16470000000000001,0.1027,{"$f":"INDEX(E149:G149,,control!$C$10)","v":3.1699999999999999E-2},null,3.1699999999999999E-2,"S_TW_M",125]
[null,145,"Slough","SL",{"$f":"INDEX(E$6:E$129,MATCH($D150,$D$6:$D$129,0),1)","v":8.8000000000000005E-3},0.14019999999999999,0.16439999999999999,{"$f":"INDEX(E150:G150,,control!$C$10)","v":8.8000000000000005E-3},null,8.8000000000000005E-3,"S_SL_M",139]
[null,146,"Harrogate","HG",7.85E-2,4.1999999999999997E-3,7.6499999999999999E-2,{"$f":"INDEX(E151:G151,,control!$C$10)","v":7.85E-2},null,7.85E-2,"S_HG_M",163,"Magnifier Shapes Manchester Area (values are calculated by formulas)"]
[null,147,"Fylde","FY",9.4299999999999995E-2,0.1799,2.8899999999999999E-2,{"$f":"INDEX(E152:G152,,control!$C$10)","v":9.4299999999999995E-2},null,9.4299999999999995E-2,"S_FY_M",164]
[null,148,"Leeds","LS",1.54E-2,0.1255,0.13300000000000001,{"$f":"INDEX(E153:G153,,control!$C$10)","v":1.54E-2},null,1.54E-2,"S_LS_M",162]
[null,149,"Bradford","BD",5.3900000000000003E-2,8.5400000000000004E-2,4.3200000000000002E-2,{"$f":"INDEX(E154:G154,,control!$C$10)","v":5.3900000000000003E-2},null,5.3900000000000003E-2,"S_BD_M",161]
[null,150,"Blackburn","BB",9.4100000000000003E-2,0.1192,0.15210000000000001,{"$f":"INDEX(E155:G155,,control!$C$10)","v":9.4100000000000003E-2},null,9.4100000000000003E-2,"S_BB_M",160]
[null,151,"Preston","PR",0.19450000000000001,0.19939999999999999,5.5199999999999999E-2,{"$f":"INDEX(E156:G156,,control!$C$10)","v":0.19450000000000001},null,0.19450000000000001,"S_PR_M",159]
[null,152,"Wakefield","WF",0.121,7.7600000000000002E-2,5.3699999999999998E-2,{"$f":"INDEX(E157:G157,,control!$C$10)","v":0.121},null,0.121,"S_WF_M",158]
[null,153,"Halifax","HX",8.5599999999999996E-2,4.4900000000000002E-2,0.1351,{"$f":"INDEX(E158:G158,,control!$C$10)","v":8.5599999999999996E-2},null,8.5599999999999996E-2,"S_HX_M",157]
[null,154,"Huddersfield","HD",6.25E-2,0.16520000000000001,5.7099999999999998E-2,{"$f":"INDEX(E159:G159,,control!$C$10)","v":6.25E-2},null,6.25E-2,"S_HD_M",156]
[null,155,"Bolton","BL",0.1145,7.4300000000000005E-2,0.1668,{"$f":"INDEX(E160:G160,,control!$C$10)","v":0.1145},null,0.1145,"S_BL_M",155]
[null,156,"Wigan","WN",0.17330000000000001,0.14199999999999999,0.1658,{"$f":"INDEX(E161:G161,,control!$C$10)","v":0.17330000000000001},null,0.17330000000000001,"S_WN_M",154]
[null,157,"Oldham","OL",0.12859999999999999,0.15329999999999999,0.16370000000000001,{"$f":"INDEX(E162:G162,,control!$C$10)","v":0.12859999999999999},null,0.12859999999999999,"S_OL_M",153]
[null,158,"Manchester","M",8.0799999999999997E-2,8.6099999999999996E-2,0.1246,{"$f":"INDEX(E163:G163,,control!$C$10)","v":8.0799999999999997E-2},null,8.0799999999999997E-2,"S_M_M",152]
[null,159,"Liverpool","L",9.1899999999999996E-2,0.1958,5.7500000000000002E-2,{"$f":"INDEX(E164:G164,,control!$C$10)","v":9.1899999999999996E-2},null,9.1899999999999996E-2,"S_L_M",151]
[null,160,"Warrington","WA",2.1700000000000001E-2,8.1600000000000006E-2,0.12759999999999999,{"$f":"INDEX(E165:G165,,control!$C$10)","v":2.1700000000000001E-2},null,2.1700000000000001E-2,"S_WA_M",150]
[null,161,"Stockport","SK",9.5399999999999999E-2,0.15909999999999999,0.13689999999999999,{"$f":"INDEX(E166:G166,,control!$C$10)","v":9.5399999999999999E-2},null,9.5399999999999999E-2,"S_SK_M",149]
[null,162,"Chester","CH",9.3399999999999997E-2,7.3400000000000007E-2,0.12089999999999999,{"$f":"INDEX(E167:G167,,control!$C$10)","v":9.3399999999999997E-2},null,9.3399999999999997E-2,"S_CH_M",148]
[null,163,"Crewe","CW",1.1999999999999999E-3,4.5999999999999999E-3,3.27E-2,{"$f":"INDEX(E168:G168,,control!$C$10)","v":1.1999999999999999E-3},null,1.1999999999999999E-3,"S_CW_M",147]
[null,164,"Sheffield","S",0.13819999999999999,4.8099999999999997E-2,6.8099999999999994E-2,{"$f":"INDEX(E169:G169,,control!$C$10)","v":0.13819999999999999},null,0.13819999999999999,"S_S_M",146]

{"sheet":"control","index":2,"n_rows":52,"n_cols":28,"rows_kept":52,"cut":false,"hidden":false,"merged":[[6,5,7,9],[4,5,4,9]]}
[]
[null,"Control"]
[]
[null,"Metrics",{"$f":"data!$E$5","v":"Measure 1"}]
[null,null,{"$f":"data!$F$5","v":"Measure 2"},null,null,"Select a color scale here"]
[null,null,{"$f":"data!$G$5","v":"Measure 3"}]
[null,null,null,null,null,"Recreate the shape index after you inserted a new map or added new shapes"]
[]
[]
[null,"Selection",1]
[]
[null,null,null,null,null,1,{"$f":"F12+1","v":2},{"$f":"G12+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,{"$f":"AA12+1","v":23}]
[null,"Threshold","RGB","Legend",null,{"$f":"$C$26","v":"Green Yellow Red"},{"$f":"$C$27","v":"Green to Pink"},{"$f":"$C$28","v":"Green to Purple"},{"$f":"$C$29","v":"Green to Brown"},{"$f":"$C$30","v":"Blue to Red"},{"$f":"$C$31","v":"Blue to Red Brown"},{"$f":"$C$32","v":"Brown to Purple"},{"$f":"$C$33","v":"Brown Blue Green"},{"$f":"$C$34","v":"Purple to Green"},{"$f":"$C$35","v":"Pink to Green"},{"$f":"$C$36","v":"Red to Blue"},{"$f":"$C$37","v":"Red to Black"},{"$f":"$C$38","v":"Red Yellow Blue"},{"$f":"$C$39","v":"Spectral"},{"$f":"$C$40","v":"Red Yellow Green"},{"$f":"$C$41","v":"Light"},{"$f":"$C$42","v":"Pairwise"},{"$f":"$C$43","v":"Light to Dark Blue"},{"$f":"$C$44","v":"Light to Dark Red"},{"$f":"$C$45","v":"Light to Dark Brown"},{"$f":"$C$46","v":"Light to Dark Green"},{"$f":"$C$47","v":"Light to Dark Yellow"},{"$f":"$C$48","v":"Light Grey to Black"}]
[null,0.02,3631104,{"$f":"\"0%  to \"&TEXT(B14,\"0%\")","v":"0%  to 2%"}]
[null,0.04,5281818,{"$f":"TEXT(B14,\"0%\")&\" to \"&TEXT(B15,\"0%\")","v":"2% to 4%"}]
[null,0.06,6536550,{"$f":"TEXT(B15,\"0%\")&\" to \"&TEXT(B16,\"0%\")","v":"4% to 6%"}]
[null,0.08,7002534,"6% to 8%"]
[null,0.1,9170905,"8% to 10%"]
[null,0.12,9167102,"10% to 12%"]
[null,0.14000000000000001,6401789,"12% to 14%"]
[null,0.16,4419060,"14% to 16%"]
[null,0.18,2568407,"16% to 18%"]
[null,1,2490533,{"$f":"TEXT(B22,\"0%\")&\" or more\"","v":"18% or more"}]
[null,null,null,null,null,{"$f":"IF(F$12=myColorScaleSelection,\"▲\",\"\")","v":"▲"},"","","","","","","","","","","","","","","","","","","","","",""]
[null,null,null,null,null,{"$f":"IF(F$12=myColorScaleSelection,\"Current Selection\",\"\")","v":"Current Selection"},"","","","","","","","","","","","","","","","","","","","","",""]
[null,"Color Scales","Green Yellow Red"]
[null,null,"Green to Pink"]
[null,null,"Green to Purple"]
[null,null,"Green to Brown"]
[null,null,"Blue to Red"]
[null,null,"Blue to Red Brown"]
[null,null,"Brown to Purple"]
[null,null,"Brown Blue Green"]
[null,null,"Purple to Green"]
[null,null,"Pink to Green"]
[null,null,"Red to Blue"]
[null,null,"Red to Black"]
[null,null,"Red Yellow Blue"]
[null,null,"Spectral"]
[null,null,"Red Yellow Green"]
[null,null,"Light"]
[null,null,"Pairwise"]
[null,null,"Light to Dark Blue"]
[null,null,"Light to Dark Red"]
[null,null,"Light to Dark Brown"]
[null,null,"Light to Dark Green"]
[null,null,"Light to Dark Yellow"]
[null,null,"Light Grey to Black"]
[]
[null,"Selection",1]
[]
[null,"Show Status Bar",true]