{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Outside London","LA Price Caps "],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":2,"defined_names":16,"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":"Outside London","index":0,"n_rows":53,"n_cols":526,"rows_kept":53,"cut":false,"hidden":false,"merged":[[77,24,79,24],[77,23,79,23],[68,16,74,21],[77,16,79,22],[5,6,5,9],[8,9,8,13],[14,10,23,10],[10,8,10,13],[30,11,30,12],[15,11,15,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[22,11,22,12],[4,1,8,1],[4,12,4,13],[39,1,39,2],[10,1,12,1],[8,4,8,7],[38,1,38,2],[29,1,31,1],[29,10,32,10],[37,1,37,11],[33,1,34,1],[4,3,4,5],[14,1,26,1],[23,11,23,12],[11,11,11,13],[1,6,2,9],[7,4,7,13],[5,3,5,5],[6,6,6,9],[4,6,4,9],[6,3,6,5],[5,12,6,13],[2,10,2,13]]}
[]
[null,null,null,null,null,null,"Complete all grey boxes"]
[null,null,null,null,null,null,null,null,null,null,"OUTSIDE LONDON version"]
[]
[null,"APPLICANT",null,"Forename",null,null,"Surname",null,null,null,"DoB","Age Next","Number of children"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(K6<>\"\",DATEDIF(K6,TODAY(),\"y\")+1,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(K7<>\"\",MONTH(TODAY())>MONTH(K7),DAY(TODAY()>DAY(K7))),YEAR(TODAY())-YEAR(K7)+1,IF(K7<>\"\",YEAR(TODAY())-YEAR(K7),\"\"))","v":""}]
[null,null,null,"Address:"]
[null,null,null,"Home:",null,null,null,null,"Mobile:"]
[]
[null,"PROPERTY",null,"Proposed purchase property:"]
[null,null,null,"Full market value",null,null,null,null,null,null,"Local Authority","Warwick"]
[null,null,null,"Number of bedrooms"]
[]
[null,"GROSS INCOME CALCULATION",null,"App 1 basic employment income(annual, gross):",null,null,null,null,null,null,"Additional household Income (monthly):","Universal Credit "]
[null,null,null,"Bonuses and Commissions (annual, gross)",null,null,null,null,null,null,null,"Working tax credits"]
[null,null,null,"Overtime (monthly, gross)"]
[null,null,null,"Student loan MONTHLY payment ",null,null,null,null,null,null,null,"Child tax credits"]
[null,null,null,"Other gross salary MONTHLY deductions (childcare vouchers, pension etc.)",null,null,null,null,null,null,null,"Child benefit"]
[null,null,null,"App 2 basic employment income(annual, gross):",null,null,null,null,null,null,null,"Guaranteed maintenance income"]
[null,null,null,"Bonuses and Commissions (annual, gross)",null,null,null,null,null,null,null,"Disability allowance"]
[null,null,null,"Overtime (monthly, gross)"]
[null,null,null,"Student loan MONTHLY payment ",null,null,null,null,null,null,null,"Other income"]
[null,null,null,"Other gross salary MONTHLY deductions (childcare vouchers, pension etc.)",null,null,null,null,null,null,null,"Additional allowable monthly income",null,{"$f":"N16+N20+N21+N23","v":0}]
[null,null,null,"Gross annual household income (from employment):",null,null,null,null,{"$f":"SUM(I15,(I16*0.5),(I17*12*0.5),I20,(I21*0.5),(I22*12*0.5))","v":0}]
[null,null,null,"Net monthly employment income (for sustainability):",null,null,null,null,{"$f":"IF(I15-I19*12+0.5*I16+(I17*0.5*12)<G47,(I15-I19*12+0.5*I16+0.5*12*I17)/12,IF(I15<F47,((I15-I19*12+(0.5*I16)+(0.5*12*I17)-G47)*(1-I47)+G47-(K47*(I15-I19*12+(0.5*I16)+(0.5*12*I17)-L47)))/12,(((I15-I19*12+(0.5*I16)+(0.5*12*I17)-F47)*(1-J47))+((F47-G47)*(1-I47))+G47-(K47*(F47-L47))-(M47*(I15-I19*12+(0.5*I16)+(0.5*12*I17)-F47)))/12))+IF(I20-I24*12+0.5*I21+(0.5*12*I22)<G47,(I20-I24*12+0.5*I21+0.5*12*I22)/12,IF(I20<F47,((I20-I24*12+(0.5*I21)+(0.5*12*I22)-G47)*(1-I47)+G47-(K47*(I20-I24*12+(0.5*I21)+(0.5*12*I22)-L47)))/12,(((I20-I24*12+(0.5*I21)+(0.5*12*I22)-F47)*(1-J47))+((F47-G47)*(1-I47))+G47-(K47*(F47-L47))-(M47*(I20-I24*12+(0.5*I21)+(0.5*12*I22)-F47)))/12))-I18-I23","v":0}]
[null,null,null,"Total gross annual income (from all sources - for IMS)",null,null,null,null,{"$f":"I25+(12*N24)","v":0}]
[]
[]
[null,"DEBT",null,"Monthly loan/HP payments:",null,null,null,null,null,null,"MORTGAGE AND DEPOSIT",{"$f":"\"Mortgage term required (max \"&H48&\"):\"","v":"Mortgage term required (max 40):"},null,25]
[null,null,null,"Outstanding credit card balances:",null,null,null,null,null,null,null,"Mortgage interest rate (assumed follow-on/variable mortgage rate after initial mortgage product expiry):",null,4.8000000000000001E-2]
[null,null,null,"Total monthly debt outgoings",null,null,null,null,{"$f":"I30+(I31*0.03)","v":0},null,null,{"$f":"\"Lender deposit requirement (£\"&N32*I12&\")\"","v":"Lender deposit requirement (£0)"},null,0.05]
[null,null,null,null,null,null,null,null,null,null,null,"Actual applicant cash contribution"]
[null,0.8,null,"Monthly service charge"]
[null,null,null,"Monthly equity payment",null,null,null,null,{"$f":"($F$49*((100%-B40)*I12))/12","v":0}]
[]
[]
[null,"If you have any queries about this form, please contact your Local Homebuy agent"]
[null,"Total equity to purchase",null,"Applicants' equity value","Equity loan £","Equity loan %","Customer cash contribution","Sufficient deposit for lender?","Mortgage requirement (Min 25%)","Mortgage %",{"$f":"\"Income multiple\n(max \"&F50&\")\"","v":"Income multiple\n(max 4.5)"},{"$f":"\"IMS Income multiple\n(max \"&F50&\")\"","v":"IMS Income multiple\n(max 4.5)"},"Mortgage (pcm)","Equity Rent + Service Charge",{"$f":"\"Debt to household income ratio (max \"&F52*100&\"%)\"","v":"Debt to household income ratio (max 45%)"}]
[null,0.80000000000000016,null,{"$f":"B40*I12","v":0},{"$f":"I12-D40","v":0},{"$f":"100%-B40","v":0.19999999999999984},{"$f":"N33","v":0},{"$f":"IF(G40>=($I$12*$N$32),\"YES\",\"NO\")","v":"YES"},{"$f":"D40-G40","v":0},{"$f":"I40/I12","v":{"$error":"#DIV/0!"}},{"$f":"I40/($I$25+(12*$N$24)-(12*$I$32))","v":{"$error":"#DIV/0!"}},{"$f":"I40/($I$25+(12*$N$24))","v":{"$error":"#DIV/0!"}},{"$f":"(I40*(1+$N$31/12)*(1/(1+$N$31/12)-1))/((1/(1+$N$31/12))^($N$30*12)-1)","v":0},{"$f":"$I$34+$I$35","v":0},{"$f":"IF($I$25>0,(M40+N40)/(I26+$N$24-$I$32),0)","v":0}]
[null,0.8]
[]
[]
[]
[]
[null,null,null,null,null,"upper tax","tax free","lower tax","lower tax","upper tax","NI","NI free","Upper NI rate"]
[null,"Upper tax band",null,null,null,50270,12570,37700,0.2,0.4,0.12,9568,0.02]
[null,"higher age",null,null,null,{"$f":"IF(L6=\"\",0,IF(L7=\"\",L6,IF(L6>L7,L6,L7)))","v":0},"max mortg",{"$f":"IF(F48<36,40,75-F48)","v":40}]
[null,"Annual equity payment rate %",null,null,null,1.7500000000000002E-2]
[null,"Max income ratio",null,null,null,4.5,{"$f":"F50+0.00000001","v":4.5000000099999999}]
[null,"Equity %",null,null,null,0.6,{"$f":"F51+1%","v":0.61},0.62,0.63,0.64,0.65,0.66,0.67,0.68,0.69000000000000006,0.70000000000000007,0.71000000000000008,0.72000000000000008,0.73000000000000009,0.7400000000000001,0.75000000000000011,0.76000000000000012,0.77000000000000013,0.78000000000000014,0.79000000000000015,0.80000000000000016,0.81000000000000016,0.82000000000000017,0.83000000000000018,0.84000000000000019,0.8500000000000002,0.86000000000000021,0.87000000000000022,0.88000000000000023,0.89000000000000024,0.90000000000000024,0.91000000000000025,0.92000000000000026,0.93000000000000027,0.94000000000000028,0.95000000000000029]
[null,"Max debt to income ratio",null,null,null,0.45]
[null,"Mortgage Interest Rate",null,null,null,4.8000000000000001E-2,4.8099999999999997E-2,4.82E-2,4.8300000000000003E-2,4.8399999999999999E-2,4.8500000000000001E-2,4.8599999999999997E-2,4.87E-2,4.8800000000000003E-2,4.8899999999999999E-2,4.9000000000000002E-2,4.9099999999999998E-2,4.9200000000000001E-2,4.9299999999999997E-2,4.9399999999999999E-2,4.9500000000000002E-2,4.9599999999999998E-2,4.9700000000000001E-2,4.9799999999999997E-2,4.99E-2,0.05,5.0099999999999999E-2,5.0200000000000002E-2,5.0299999999999997E-2,5.04E-2,5.0500000000000003E-2,5.0599999999999999E-2,5.0700000000000002E-2,5.0799999999999998E-2,5.0900000000000001E-2,5.0999999999999997E-2,5.11E-2,5.1200000000000002E-2,5.1299999999999998E-2,5.1400000000000001E-2,5.1499999999999997E-2,5.16E-2,5.1700000000000003E-2,5.1799999999999999E-2,5.1900000000000002E-2,5.1999999999999998E-2,5.21E-2,5.2200000000000003E-2,5.2299999999999999E-2,5.2400000000000002E-2,5.2499999999999998E-2,5.2600000000000001E-2,5.2699999999999997E-2,5.28E-2,5.2900000000000003E-2,5.2999999999999999E-2,5.3100000000000001E-2,5.3199999999999997E-2,5.33E-2,5.3400000000000003E-2,5.3499999999999999E-2,5.3600000000000002E-2,5.3699999999999998E-2,5.3800000000000001E-2,5.3900000000000003E-2,5.3999999999999999E-2,5.4100000000000002E-2,5.4199999999999998E-2,5.4300000000000001E-2,5.4399999999999997E-2,5.45E-2,5.4600000000000003E-2,5.4699999999999999E-2,5.4800000000000001E-2,5.4899999999999997E-2,5.5E-2,5.5100000000000003E-2,5.5199999999999999E-2,5.5300000000000002E-2,5.5399999999999998E-2,5.5500000000000001E-2,5.5599999999999997E-2,5.57E-2,5.5800000000000002E-2,5.5899999999999998E-2,5.6000000000000001E-2,5.6099999999999997E-2,5.62E-2,5.6300000000000003E-2,5.6399999999999999E-2,5.6500000000000002E-2,5.6599999999999998E-2,5.67E-2,5.6800000000000003E-2,5.6899999999999999E-2,5.7000000000000002E-2,5.7099999999999998E-2,5.7200000000000001E-2,5.7299999999999997E-2,5.74E-2,5.7500000000000002E-2,5.7599999999999998E-2,5.7700000000000001E-2,5.7799999999999997E-2,5.79E-2,5.8000000000000003E-2,5.8099999999999999E-2,5.8200000000000002E-2,5.8299999999999998E-2,5.8400000000000001E-2,5.8500000000000003E-2,5.8599999999999999E-2,5.8700000000000002E-2,5.8799999999999998E-2,5.8900000000000001E-2,5.8999999999999997E-2,5.91E-2,5.9200000000000003E-2,5.9299999999999999E-2,5.9400000000000001E-2,5.9499999999999997E-2,5.96E-2,5.9700000000000003E-2,5.9799999999999999E-2,5.9900000000000002E-2,0.06,6.0100000000000001E-2,6.0199999999999997E-2,6.0299999999999999E-2,6.0400000000000002E-2,6.0499999999999998E-2,6.0600000000000001E-2,6.0699999999999997E-2,6.08E-2,6.0900000000000003E-2,6.0999999999999999E-2,6.1100000000000002E-2,6.1199999999999997E-2,6.13E-2,6.1400000000000003E-2,6.1499999999999999E-2,6.1600000000000002E-2,6.1699999999999998E-2,6.1800000000000001E-2,6.1899999999999997E-2,6.2E-2,6.2100000000000002E-2,6.2199999999999998E-2,6.2300000000000001E-2,6.2399999999999997E-2,6.25E-2,6.2600000000000003E-2,6.2700000000000006E-2,6.2799999999999995E-2,6.2899999999999998E-2,6.3E-2,6.3100000000000003E-2,6.3200000000000006E-2,6.3299999999999995E-2,6.3399999999999998E-2,6.3500000000000001E-2,6.3600000000000004E-2,6.3700000000000007E-2,6.3799999999999996E-2,6.3899999999999998E-2,6.4000000000000001E-2,6.4100000000000004E-2,6.4199999999999993E-2,6.4299999999999996E-2,6.4399999999999999E-2,6.4500000000000002E-2,6.4600000000000005E-2,6.4699999999999994E-2,6.4799999999999996E-2,6.4899999999999999E-2,6.5000000000000002E-2,6.5100000000000005E-2,6.5199999999999994E-2,6.5299999999999997E-2,6.54E-2,6.5500000000000003E-2,6.5600000000000006E-2,6.5699999999999995E-2,6.5799999999999997E-2,6.59E-2,6.6000000000000003E-2,6.6100000000000006E-2,6.6199999999999995E-2,6.6299999999999998E-2,6.6400000000000001E-2,6.6500000000000004E-2,6.6600000000000006E-2,6.6699999999999995E-2,6.6799999999999998E-2,6.6900000000000001E-2,6.7000000000000004E-2,6.7100000000000007E-2,6.7199999999999996E-2,6.7299999999999999E-2,6.7400000000000002E-2,6.7500000000000004E-2,6.7599999999999993E-2,6.7699999999999996E-2,6.7799999999999999E-2,6.7900000000000002E-2,6.8000000000000005E-2,6.8099999999999994E-2,6.8199999999999997E-2,6.83E-2,6.8400000000000002E-2,6.8500000000000005E-2,6.8599999999999994E-2,6.8699999999999997E-2,6.88E-2,6.8900000000000003E-2,6.9000000000000006E-2,6.9099999999999995E-2,6.9199999999999998E-2,6.93E-2,6.9400000000000003E-2,6.9500000000000006E-2,6.9599999999999995E-2,6.9699999999999998E-2,6.9800000000000001E-2,6.9900000000000004E-2,7.0000000000000007E-2,7.0099999999999996E-2,7.0199999999999999E-2,7.0300000000000001E-2,7.0400000000000004E-2,7.0499999999999993E-2,7.0599999999999996E-2,7.0699999999999999E-2,7.0800000000000002E-2,7.0900000000000005E-2,7.0999999999999994E-2,7.1099999999999997E-2,7.1199999999999999E-2,7.1300000000000002E-2,7.1400000000000005E-2,7.1499999999999994E-2,7.1599999999999997E-2,7.17E-2,7.1800000000000003E-2,7.1900000000000006E-2,7.1999999999999995E-2,7.2099999999999997E-2,7.22E-2,7.2300000000000003E-2,7.2400000000000006E-2,7.2499999999999995E-2,7.2599999999999998E-2,7.2700000000000001E-2,7.2800000000000004E-2,7.2900000000000006E-2,7.2999999999999995E-2,7.3099999999999998E-2,7.3200000000000001E-2,7.3300000000000004E-2,7.3400000000000007E-2,7.3499999999999996E-2,7.3599999999999999E-2,7.3700000000000002E-2,7.3800000000000004E-2,7.3899999999999993E-2,7.3999999999999996E-2,7.4099999999999999E-2,7.4200000000000002E-2,7.4300000000000005E-2,7.4399999999999994E-2,7.4499999999999997E-2,7.46E-2,7.4700000000000003E-2,7.4800000000000005E-2,7.4899999999999994E-2,7.4999999999999997E-2,7.51E-2,7.5200000000000003E-2,7.5300000000000006E-2,7.5399999999999995E-2,7.5499999999999998E-2,7.5600000000000001E-2,7.5700000000000003E-2,7.5800000000000006E-2,7.5899999999999995E-2,7.5999999999999998E-2,7.6100000000000001E-2,7.6200000000000004E-2,7.6300000000000007E-2,7.6399999999999996E-2,7.6499999999999999E-2,7.6600000000000001E-2,7.6700000000000004E-2,7.6799999999999993E-2,7.6899999999999996E-2,7.6999999999999999E-2,7.7100000000000002E-2,7.7200000000000005E-2,7.7299999999999994E-2,7.7399999999999997E-2,7.7499999999999999E-2,7.7600000000000002E-2,7.7700000000000005E-2,7.7799999999999994E-2,7.7899999999999997E-2,7.8E-2,7.8100000000000003E-2,7.8200000000000006E-2,7.8299999999999995E-2,7.8399999999999997E-2,7.85E-2,7.8600000000000003E-2,7.8700000000000006E-2,7.8799999999999995E-2,7.8899999999999998E-2,7.9000000000000001E-2,7.9100000000000004E-2,7.9200000000000007E-2,7.9299999999999995E-2,7.9399999999999998E-2,7.9500000000000001E-2,7.9600000000000004E-2,7.9699999999999993E-2,7.9799999999999996E-2,7.9899999999999999E-2,0.08,8.0100000000000005E-2,8.0199999999999994E-2,8.0299999999999996E-2,8.0399999999999999E-2,8.0500000000000002E-2,8.0600000000000005E-2,8.0699999999999994E-2,8.0799999999999997E-2,8.09E-2,8.1000000000000003E-2,8.1100000000000005E-2,8.1199999999999994E-2,8.1299999999999997E-2,8.14E-2,8.1500000000000003E-2,8.1600000000000006E-2,8.1699999999999995E-2,8.1799999999999998E-2,8.1900000000000001E-2,8.2000000000000003E-2,8.2100000000000006E-2,8.2199999999999995E-2,8.2299999999999998E-2,8.2400000000000001E-2,8.2500000000000004E-2,8.2600000000000007E-2,8.2699999999999996E-2,8.2799999999999999E-2,8.2900000000000001E-2,8.3000000000000004E-2,8.3099999999999993E-2,8.3199999999999996E-2,8.3299999999999999E-2,8.3400000000000002E-2,8.3500000000000005E-2,8.3599999999999994E-2,8.3699999999999997E-2,8.3799999999999999E-2,8.3900000000000002E-2,8.4000000000000005E-2,8.4099999999999994E-2,8.4199999999999997E-2,8.43E-2,8.4400000000000003E-2,8.4500000000000006E-2,8.4599999999999995E-2,8.4699999999999998E-2,8.48E-2,8.4900000000000003E-2,8.5000000000000006E-2,8.5099999999999995E-2,8.5199999999999998E-2,8.5300000000000001E-2,8.5400000000000004E-2,8.5500000000000007E-2,8.5599999999999996E-2,8.5699999999999998E-2,8.5800000000000001E-2,8.5900000000000004E-2,8.5999999999999993E-2,8.6099999999999996E-2,8.6199999999999999E-2,8.6300000000000002E-2,8.6400000000000005E-2,8.6499999999999994E-2,8.6599999999999996E-2,8.6699999999999999E-2,8.6800000000000002E-2,8.6900000000000005E-2,8.6999999999999994E-2,8.7099999999999997E-2,8.72E-2,8.7300000000000003E-2,8.7400000000000005E-2,8.7499999999999994E-2,8.7599999999999997E-2,8.77E-2,8.7800000000000003E-2,8.7900000000000006E-2,8.7999999999999995E-2,8.8099999999999998E-2,8.8200000000000001E-2,8.8300000000000003E-2,8.8400000000000006E-2,8.8499999999999995E-2,8.8599999999999998E-2,8.8700000000000001E-2,8.8800000000000004E-2,8.8900000000000007E-2,8.8999999999999996E-2,8.9099999999999999E-2,8.9200000000000002E-2,8.9300000000000004E-2,8.9399999999999993E-2,8.9499999999999996E-2,8.9599999999999999E-2,8.9700000000000002E-2,8.9800000000000005E-2,8.9899999999999994E-2,0.09,9.01E-2,9.0200000000000002E-2,9.0300000000000005E-2,9.0399999999999994E-2,9.0499999999999997E-2,9.06E-2,9.0700000000000003E-2,9.0800000000000006E-2,9.0899999999999995E-2,9.0999999999999998E-2,9.11E-2,9.1200000000000003E-2,9.1300000000000006E-2,9.1399999999999995E-2,9.1499999999999998E-2,9.1600000000000001E-2,9.1700000000000004E-2,9.1800000000000007E-2,9.1899999999999996E-2,9.1999999999999998E-2,9.2100000000000001E-2,9.2200000000000004E-2,9.2299999999999993E-2,9.2399999999999996E-2,9.2499999999999999E-2,9.2600000000000002E-2,9.2700000000000005E-2,9.2799999999999994E-2,9.2899999999999996E-2,9.2999999999999999E-2,9.3100000000000002E-2,9.3200000000000005E-2,9.3299999999999994E-2,9.3399999999999997E-2,9.35E-2,9.3600000000000003E-2,9.3700000000000006E-2,9.3799999999999994E-2,9.3899999999999997E-2,9.4E-2,9.4100000000000003E-2,9.4200000000000006E-2,9.4299999999999995E-2,9.4399999999999998E-2,9.4500000000000001E-2,9.4600000000000004E-2,9.4700000000000006E-2,9.4799999999999995E-2,9.4899999999999998E-2,9.5000000000000001E-2,9.5100000000000004E-2,9.5200000000000007E-2,9.5299999999999996E-2,9.5399999999999999E-2,9.5500000000000002E-2,9.5600000000000004E-2,9.5699999999999993E-2,9.5799999999999996E-2,9.5899999999999999E-2,9.6000000000000002E-2,9.6100000000000005E-2,9.6199999999999994E-2,9.6299999999999997E-2,9.64E-2,9.6500000000000002E-2,9.6600000000000005E-2,9.6699999999999994E-2,9.6799999999999997E-2,9.69E-2,9.7000000000000003E-2,9.7100000000000006E-2,9.7199999999999995E-2,9.7299999999999998E-2,9.74E-2,9.7500000000000003E-2,9.7600000000000006E-2,9.7699999999999995E-2,9.7799999999999998E-2,9.7900000000000001E-2,9.8000000000000004E-2,9.8100000000000007E-2,9.8199999999999996E-2,9.8299999999999998E-2,9.8400000000000001E-2,9.8500000000000004E-2,9.8599999999999993E-2,9.8699999999999996E-2,9.8799999999999999E-2,9.8900000000000002E-2,9.9000000000000005E-2,9.9099999999999994E-2,9.9199999999999997E-2,9.9299999999999999E-2,9.9400000000000002E-2,9.9500000000000005E-2,9.9599999999999994E-2,9.9699999999999997E-2,9.98E-2,9.9900000000000003E-2,0.1]

{"sheet":"LA Price Caps ","index":1,"n_rows":282,"n_cols":5,"rows_kept":282,"cut":false,"hidden":true,"merged":[]}
["Local Authority","Region name","Price Cap","LA Selected",{"$f":"VLOOKUP('[2]Outside London'!$L$12,$A$2:$C$282,3,FALSE)","v":255600}]
["Hartlepool","North East",186100]
["Middlesbrough","North East",186100]
["Redcar and Cleveland","North East",186100]
["Stockton-on-Tees","North East",186100]
["Darlington","North East",186100]
["Halton","North West",224400]
["Warrington","North West",224400]
["Blackburn with Darwen","North West",224400]
["Blackpool","North West",224400]
["Kingston Upon Hull","Yorkshire and The Humber",228100]
["East Riding of Yorkshire","Yorkshire and The Humber",228100]
["North East Lincolnshire","Yorkshire and The Humber",228100]
["North Lincolnshire","Yorkshire and The Humber",228100]
["York","Yorkshire and The Humber",228100]
["Derby","East Midlands",261900]
["Leicester","East Midlands",261900]
["Rutland","East Midlands",261900]
["Nottingham","East Midlands",261900]
["Herefordshire","West Midlands",255600]
["Telford and Wrekin","West Midlands",255600]
["Stoke-on-Trent","West Midlands",255600]
["Bath and North East Somerset","South West",349000]
["Bristol","South West",349000]
["North Somerset","South West",349000]
["South Gloucestershire","South West",349000]
["Plymouth","South West",349000]
["Torbay","South West",349000]
["Swindon","South West",349000]
["Peterborough","East of England",407400]
["Luton","East of England",407400]
["Southend-on-Sea","East of England",407400]
["Thurrock","East of England",407400]
["Medway Towns","South East",437600]
["Bracknell Forest","South East",437600]
["West Berkshire","South East",437600]
["Reading","South East",437600]
["Slough","South East",437600]
["Windsor and Maidenhead","South East",437600]
["Wokingham","South East",437600]
["Milton Keynes","South East",437600]
["Brighton and Hove","South East",437600]
["Portsmouth","South East",437600]
["Southampton","South East",437600]
["Isle of Wight","South East",437600]
["County Durham","North East",186100]
["Cheshire East","North West",224400]
["Cheshire West and Chester","North West",224400]
["Shropshire","West Midlands",255600]
["Cornwall","South West",349000]
["Isles of Scilly","South West",349000]
["Wiltshire","South West",349000]
["Bedford","East of England",407400]
["Central Bedfordshire","East of England",407400]
["Northumberland","North East",186100]
["Bournemouth, Christchurch and Poole","South West",349000]
["Dorset","South West",349000]
["Buckinghamshire","South East",437600]
["Cambridge","East of England",407400]
["East Cambridgeshire","East of England",407400]
["Fenland","East of England",407400]
["Huntingdonshire","East of England",407400]
["South Cambridgeshire","East of England",407400]
["Allerdale","North West",224400]
["Barrow-in-Furness","North West",224400]
["Carlisle","North West",224400]
["Copeland","North West",224400]
["Eden","North West",224400]
["South Lakeland","North West",224400]
["Amber Valley","East Midlands",261900]
["Bolsover","East Midlands",261900]
["Chesterfield","East Midlands",261900]
["Derbyshire Dales","East Midlands",261900]
["Erewash","East Midlands",261900]
["High Peak","East Midlands",261900]
["North East Derbyshire","East Midlands",261900]
["South Derbyshire","East Midlands",261900]
["East Devon","South West",349000]
["Exeter","South West",349000]
["Mid Devon","South West",349000]
["North Devon","South West",349000]
["South Hams","South West",349000]
["Teignbridge","South West",349000]
["Torridge","South West",349000]
["West Devon","South West",349000]
["Eastbourne","South East",437600]
["Hastings","South East",437600]
["Lewes","South East",437600]
["Rother","South East",437600]
["Wealden","South East",437600]
["Basildon","East of England",407400]
["Braintree","East of England",407400]
["Brentwood","East of England",407400]
["Castle Point","East of England",407400]
["Chelmsford","East of England",407400]
["Colchester","East of England",407400]
["Epping Forest","East of England",407400]
["Harlow","East of England",407400]
["Maldon","East of England",407400]
["Rochford","East of England",407400]
["Tendring","East of England",407400]
["Uttlesford","East of England",407400]
["Cheltenham","South West",349000]
["Cotswold","South West",349000]
["Forest of Dean","South West",349000]
["Gloucester","South West",349000]
["Stroud","South West",349000]
["Tewkesbury","South West",349000]
["Basingstoke and Deane","South East",437600]
["East Hampshire","South East",437600]
["Eastleigh","South East",437600]
["Fareham","South East",437600]
["Gosport","South East",437600]
["Hart","South East",437600]
["Havant","South East",437600]
["New Forest","South East",437600]
["Rushmoor","South East",437600]
["Test Valley","South East",437600]
["Winchester","South East",437600]
["Broxbourne","East of England",407400]
["Dacorum","East of England",407400]
["Hertsmere","East of England",407400]
["North Hertfordshire","East of England",407400]
["Three Rivers","East of England",407400]
["Watford","East of England",407400]
["Ashford","South East",437600]
["Canterbury","South East",437600]
["Dartford","South East",437600]
["Dover","South East",437600]
["Gravesham","South East",437600]
["Maidstone","South East",437600]
["Sevenoaks","South East",437600]
["Folkestone and Hythe","South East",437600]
["Swale","South East",437600]
["Thanet","South East",437600]
["Tonbridge and Malling","South East",437600]
["Tunbridge Wells","South East",437600]
["Burnley","North West",224400]
["Chorley","North West",224400]
["Fylde","North West",224400]
["Hyndburn","North West",224400]
["Lancaster","North West",224400]
["Pendle","North West",224400]
["Preston","North West",224400]
["Ribble Valley","North West",224400]
["Rossendale","North West",224400]
["South Ribble","North West",224400]
["West Lancashire","North West",224400]
["Wyre","North West",224400]
["Blaby","East Midlands",261900]
["Charnwood","East Midlands",261900]
["Harborough","East Midlands",261900]
["Hinckley and Bosworth","East Midlands",261900]
["Melton","East Midlands",261900]
["North West Leicestershire","East Midlands",261900]
["Oadby and Wigston","East Midlands",261900]
["Boston","East Midlands",261900]
["East Lindsey","East Midlands",261900]
["Lincoln","East Midlands",261900]
["North Kesteven","East Midlands",261900]
["South Holland","East Midlands",261900]
["South Kesteven","East Midlands",261900]
["West Lindsey","East Midlands",261900]
["Breckland","East of England",407400]
["Broadland","East of England",407400]
["Great Yarmouth","East of England",407400]
["Kings Lynn and West Norfolk","East of England",407400]
["North Norfolk","East of England",407400]
["Norwich","East of England",407400]
["South Norfolk","East of England",407400]
["Corby","East Midlands",261900]
["Daventry","East Midlands",261900]
["East Northamptonshire","East Midlands",261900]
["Kettering","East Midlands",261900]
["Northampton","East Midlands",261900]
["South Northamptonshire","East Midlands",261900]
["Wellingborough","East Midlands",261900]
["Craven","Yorkshire and The Humber",228100]
["Hambleton","Yorkshire and The Humber",228100]
["Harrogate","Yorkshire and The Humber",228100]
["Richmondshire","Yorkshire and The Humber",228100]
["Ryedale","Yorkshire and The Humber",228100]
["Scarborough","Yorkshire and The Humber",228100]
["Selby","Yorkshire and The Humber",228100]
["Ashfield","East Midlands",261900]
["Bassetlaw","East Midlands",261900]
["Broxtowe","East Midlands",261900]
["Gedling","East Midlands",261900]
["Mansfield","East Midlands",261900]
["Newark and Sherwood","East Midlands",261900]
["Rushcliffe","East Midlands",261900]
["Cherwell","South East",437600]
["Oxford","South East",437600]
["South Oxfordshire","South East",437600]
["Vale of White Horse","South East",437600]
["West Oxfordshire","South East",437600]
["Mendip","South West",349000]
["Sedgemoor","South West",349000]
["South Somerset","South West",349000]
["Cannock Chase","West Midlands",255600]
["East Staffordshire","West Midlands",255600]
["Lichfield","West Midlands",255600]
["Newcastle-under-Lyme","West Midlands",255600]
["South Staffordshire","West Midlands",255600]
["Stafford","West Midlands",255600]
["Staffordshire Moorlands","West Midlands",255600]
["Tamworth","West Midlands",255600]
["Babergh","East of England",407400]
["Ipswich","East of England",407400]
["Mid Suffolk","East of England",407400]
["Elmbridge","South East",437600]
["Epsom and Ewell","South East",437600]
["Guildford","South East",437600]
["Mole Valley","South East",437600]
["Reigate and Banstead","South East",437600]
["Runnymede","South East",437600]
["Spelthorne","South East",437600]
["Surrey Heath","South East",437600]
["Tandridge","South East",437600]
["Waverley","South East",437600]
["Woking","South East",437600]
["North Warwickshire","West Midlands",255600]
["Nuneaton and Bedworth","West Midlands",255600]
["Rugby","West Midlands",255600]
["Stratford-on-Avon","West Midlands",255600]
["Warwick","West Midlands",255600]
["Adur","South East",437600]
["Arun","South East",437600]
["Chichester","South East",437600]
["Crawley","South East",437600]
["Horsham","South East",437600]
["Mid Sussex","South East",437600]
["Worthing","South East",437600]
["Bromsgrove","West Midlands",255600]
["Malvern Hills","West Midlands",255600]
["Redditch","West Midlands",255600]
["Worcester","West Midlands",255600]
["Wychavon","West Midlands",255600]
["Wyre Forest","West Midlands",255600]
["St. Albans","East of England",407400]
["Welwyn Hatfield","East of England",407400]
["East Hertfordshire","East of England",407400]
["Stevenage","East of England",407400]
["East Suffolk","East of England",407400]
["West Suffolk","East of England",407400]
["Somerset West and Taunton","South West",349000]
["Bolton","North West",224400]
["Bury","North West",224400]
["Manchester","North West",224400]
["Oldham","North West",224400]
["Rochdale","North West",224400]
["Salford","North West",224400]
["Stockport","North West",224400]
["Tameside","North West",224400]
["Trafford","North West",224400]
["Wigan","North West",224400]
["Knowsley","North West",224400]
["Liverpool","North West",224400]
["St. Helens","North West",224400]
["Sefton","North West",224400]
["Wirral","North West",224400]
["Barnsley","Yorkshire and The Humber",228100]
["Doncaster","Yorkshire and The Humber",228100]
["Rotherham","Yorkshire and The Humber",228100]
["Sheffield","Yorkshire and The Humber",228100]
["Newcastle upon Tyne","North East",186100]
["North Tyneside","North East",186100]
["South Tyneside","North East",186100]
["Sunderland","North East",186100]
["Birmingham","West Midlands",255600]
["Coventry","West Midlands",255600]
["Dudley","West Midlands",255600]
["Sandwell","West Midlands",255600]
["Solihull","West Midlands",255600]
["Walsall","West Midlands",255600]
["Wolverhampton","West Midlands",255600]
["Bradford","Yorkshire and The Humber",228100]
["Calderdale","Yorkshire and The Humber",228100]
["Kirklees","Yorkshire and The Humber",228100]
["Leeds","Yorkshire and The Humber",228100]
["Wakefield","Yorkshire and The Humber",228100]
["Gateshead","North East",186100]