{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Summary 2007-08","Summary 2008-09","Summary 2009-10","Summary 2010-11","% changes","ALL YEARS","CHARTS"],"not_rendered":{"charts":2,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Summary 2007-08","index":0,"n_rows":52,"n_cols":25,"rows_kept":52,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["SUMMARY OF RAPE DATA TO END MARCH 2008",{"$nulls":22},"POPULATION DATA - MID YEAR ESTIMATES"]
[]
[null,"Rate of offences per 1,000","Number of offences (police recorded crimes)","% No crimed by police","% resulting in a sanction detection","Number of prosecutions","% discontinuanced by CPS","Of those that go to court, % resulting in a conviction",null,"Number of offences (police recorded crimes) to March 2007","Difference in number of offences from March 2007 to March 2008",{"$nulls":12},"Police force area"]
["Avon & Somerset",0.2450466036412774,383,0.18683651804670912,25.326370757180154,94,0.19148936170212766,0.6973684210526315,null,430,-47,{"$nulls":12},"Avon & Somerset",1595236]
["Bedfordshire",0.1944324108595618,114,0.16176470588235295,18.421052631578945,26,0.2692307692307692,0.8421052631578947,null,149,-35,{"$nulls":12},"Bedfordshire",599357]
["Cambridgeshire",0.284396720135022,214,0.0815450643776824,19.158878504672895,22,0.2727272727272727,0.6875,null,209,5,{"$nulls":12},"Cambridgeshire",770407]
["Cheshire",0.1492604595018307,149,0.14857142857142858,29.53020134228188,36,0.16666666666666666,0.6666666666666666,null,170,-21,{"$nulls":12},"Cheshire",1002882]
["Cleveland",0.2551987764836125,142,0.22826086956521738,28.87323943661972,39,0.15384615384615385,0.8181818181818182,null,140,2,{"$nulls":12},"Cleveland",558533]
["Cumbria",0.1630638284165898,81,0.1,24.691358024691358,24,0.3333333333333333,0.75,null,73,8,{"$nulls":12},"Cumbria",495888]
["Derbyshire",0.2372036216450828,235,0.15162454873646208,28.085106382978726,57,0.21052631578947367,0.8444444444444444,null,284,-49,{"$nulls":12},"Derbyshire",1001261]
["Devon & Cornwall",0.24451156685688288,402,0.12987012987012986,16.666666666666664,59,0.13559322033898305,0.803921568627451,null,389,13,{"$nulls":12},"Devon & Cornwall",1667833]
["Dorset",0.29908394859174187,210,0.17647058823529413,18.095238095238095,29,0.1724137931034483,0.6666666666666666,null,132,78,{"$nulls":12},"Dorset",711040]
["Durham",0.21439350923650788,128,0.058823529411764705,41.40625,58,0.08620689655172414,0.7735849056603774,null,83,45,{"$nulls":12},"Durham",605081]
["Dyfed-Powys",0.1418708974832902,71,0.14457831325301204,19.718309859154928,19,0.21052631578947367,0.8,null,102,-31,{"$nulls":12},"Dyfed-Powys",506738]
["Essex",0.17766978869299863,296,0.0975609756097561,18.91891891891892,45,0.24444444444444444,0.7647058823529411,null,355,-59,{"$nulls":12},"Essex",1705764]
["Gloucestershire",0.24336863616906698,141,0.06622516556291391,29.078014184397162,36,0.19444444444444445,0.7586206896551724,null,160,-19,{"$nulls":12},"Gloucestershire",586162]
["Greater Manchester",0.3069539557320715,784,0.21442885771543085,37.5,269,0.19330855018587362,0.7695852534562212,null,837,-53,{"$nulls":12},"Greater Manchester",2579974]
["Gwent",0.3178582459971411,177,0.12807881773399016,20.33898305084746,51,0.13725490196078433,0.75,null,145,32,{"$nulls":12},"Gwent",559266]
["Hampshire",0.3257724914423125,595,0.2119205298013245,20.672268907563023,117,0.2564102564102564,0.735632183908046,null,662,-67,{"$nulls":12},"Hampshire",1857247]
["Hertfordshire",0.1623525258560556,172,0.22869955156950672,21.511627906976745,62,0.1774193548387097,0.6274509803921569,null,199,-27,{"$nulls":12},"Hertfordshire",1083871]
["Humberside",0.28565346815294707,259,0.10380622837370242,22.393822393822393,80,0.2,0.78125,null,291,-32,{"$nulls":12},"Humberside",914846]
["Kent",0.24783573153255725,404,0.07126436781609195,25.742574257425744,95,0.24210526315789474,0.6805555555555556,null,395,9,{"$nulls":12},"Kent",1655155]
["Lancashire",0.17829487899789984,258,0.19122257053291536,29.844961240310074,134,0.16417910447761194,0.7589285714285714,null,288,-30,{"$nulls":12},"Lancashire",1445143]
["Leicestershire",0.35497618658293506,343,0.11139896373056994,12.244897959183673,40,0.175,0.8484848484848485,null,298,45,{"$nulls":12},"Leicestershire",983401]
["Lincolnshire",0.23633212541358123,162,0.17766497461928935,16.666666666666664,17,0.23529411764705882,0.8461538461538461,null,155,7,{"$nulls":12},"Lincolnshire",695604]
["London",0.25269765011061984,1907,0.19433882551753273,33.29837441006817,851,0.3207990599294947,0.6695501730103807,null,2312,-405,{"$nulls":12},"London, City of",11330]
["Merseyside",0.1843863144052177,250,0.08424908424908426,20.8,61,0.21311475409836064,0.75,null,298,-48,{"$nulls":12},"Merseyside",1350231]
["Norfolk",0.16978092240409787,141,0.10191082802547771,20.56737588652482,31,0.12903225806451613,0.8148148148148148,null,165,-24,{"$nulls":12},"Metropolitan Police",7657000]
["Northamptonshire",0.22900050319847415,152,0.10059171597633136,21.052631578947366,30,0.06666666666666667,0.7857142857142857,null,162,-10,{"$nulls":12},"Norfolk",847347]
["Northumbria",0.1822394440482027,255,0.1326530612244898,29.01960784313726,80,0.2625,0.847457627118644,null,345,-90,{"$nulls":12},"Northamptonshire",679244]
["North Wales",0.22727475289441082,153,0.18617021276595744,16.99346405228758,20,0.15,0.8235294117647058,null,106,47,{"$nulls":12},"Northumbria",1407034]
["North Yorkshire",0.16620969736950605,129,0.0851063829787234,24.8062015503876,42,0.2619047619047619,0.6451612903225806,null,135,-6,{"$nulls":12},"North Wales",677971]
["Nottinghamshire",0.21771396549896255,230,0.17266187050359713,24.782608695652176,80,0.2125,0.7936507936507936,null,255,-25,{"$nulls":12},"North Yorkshire",788378]
["South Wales",0.21438577258054692,264,0.06713780918727916,41.66666666666667,88,0.1590909090909091,0.7297297297297297,null,273,-9,{"$nulls":12},"Nottinghamshire",1069895]
["South Yorkshire",0.18170149923066814,235,0.05622489959839357,33.191489361702125,68,0.25,0.8235294117647058,null,267,-32,{"$nulls":12},"South Wales",1246102]
["Staffordshire",0.22915275718860686,243,0.13523131672597866,21.39917695473251,68,0.20588235294117646,0.7037037037037037,null,285,-42,{"$nulls":12},"South Yorkshire",1307202]
["Suffolk",0.2433710033470671,170,0.19047619047619047,17.647058823529413,31,0.22580645161290322,0.75,null,175,-5,{"$nulls":12},"Staffordshire",1066216]
["Surrey",0.13713125128560547,148,0.20855614973262032,24.324324324324326,28,0.21428571428571427,0.7272727272727273,null,138,10,{"$nulls":12},"Suffolk",710612]
["Sussex",0.20172240907476655,309,0.16260162601626016,20.06472491909385,71,0.22535211267605634,0.8545454545454545,null,440,-131,{"$nulls":12},"Surrey",1100724]
["Thames Valley",0.1743430951556267,376,0.2,18.882978723404257,100,0.15,0.6470588235294118,null,437,-61,{"$nulls":12},"Sussex",1553519]
["Warwickshire",0.20387165612377106,107,0.144,21.49532710280374,23,0.17391304347826086,0.8421052631578947,null,110,-3,{"$nulls":12},"Thames Valley",2201863]
["West Mercia",0.20471037728717129,241,0.20462046204620463,21.991701244813278,48,0.125,0.7857142857142857,null,220,21,{"$nulls":12},"Warwickshire",533222]
["West Midlands",0.318118278453122,827,0.09814612868047982,24.78839177750907,213,0.27230046948356806,0.8451612903225807,null,912,-85,{"$nulls":12},"West Mercia",1186690]
["West Yorkshire",0.2884409811048119,626,0.1329639889196676,23.80191693290735,132,0.09090909090909091,0.8333333333333334,null,617,9,{"$nulls":12},"West Midlands",2622301]
["Wiltshire",0.215666859245103,137,0.20348837209302326,21.897810218978105,29,0.2413793103448276,0.7272727272727273,null,157,-20,{"$nulls":12},"West Yorkshire",2207040]
[{"$nulls":23},"Wiltshire",650113]
["TOTAL:",null,12620,null,null,0,null,null,null,13755,-1135,{"$nulls":12},"london",7668330]
[{"$nulls":23},"England ",51464646]
["National Average",0.23489637263603186,null,0.15534435446087946,25.618066561014263]
[{"$nulls":23},"Wales",2990077]
[]
[{"$nulls":23},"ENGLAND AND WALES",54454723]

{"sheet":"Summary 2008-09","index":1,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["SUMMARY OF RAPE DATA TO END MARCH 2009"]
[]
[null,"Rate of offences per 1,000","Number of offences (police recorded crimes)","% No crimed by police","% resulting in a sanction detection","Number of prosecutions","% discontinuanced by CPS","Of those that go to court, % resulting in a conviction",null,"Number of offences (police recorded crimes) to March 2008","Difference in number of offences from March 2008 to March 2009"]
["Avon & Somerset",0.2137449377863107,338,0.25055432372505543,20.710059171597635,78,0.2948717948717949,0.6727272727272727,null,430,-92]
["Bedfordshire",0.2770134571110537,164,0.08888888888888889,16.463414634146343,23,0.21739130434782608,0.5,null,149,15]
["Cambridgeshire",0.25758360296378846,196,0.10909090909090909,22.95918367346939,50,0.14,0.6744186046511628,null,209,-13]
["Cheshire",0.15085894688466286,151,0.11695906432748537,25.165562913907287,49,0.12244897959183673,0.7906976744186046,null,170,-19]
["Cleveland",0.2441884057190361,136,0.26881720430107525,35.294117647058826,41,0.17073170731707318,0.7647058823529411,null,140,-4]
["Cumbria",0.15097530044084786,75,0.15730337078651685,21.333333333333336,24,0.16666666666666666,0.45,null,73,2]
["Derbyshire",0.25799405107880663,257,0.1076388888888889,23.346303501945524,71,0.22535211267605634,0.6909090909090909,null,284,-27]
["Devon & Cornwall",0.25954036665646973,431,0.14653465346534653,18.561484918793504,49,0.12244897959183673,0.813953488372093,null,389,42]
["Dorset",0.23545003383713062,167,0.14358974358974358,10.778443113772456,32,0.125,0.7857142857142857,null,132,35]
["Durham",0.20117479429461632,121,0.1357142857142857,42.14876033057851,76,0.15789473684210525,0.828125,null,83,38]
["Dyfed-Powys",0.15281021962996114,77,0.10465116279069768,31.16883116883117,13,0.15384615384615385,0.5454545454545454,null,102,-25]
["Essex",0.2038090303443719,343,0.10909090909090909,18.367346938775512,76,0.2236842105263158,0.847457627118644,null,355,-12]
["Gloucestershire",0.24804854224437745,145,0.07643312101910828,23.448275862068964,44,0.2727272727272727,0.78125,null,160,-15]
["Greater Manchester",0.3250873915985568,834,0.13485477178423236,30.575539568345324,294,0.20068027210884354,0.7617021276595745,null,837,-3]
["Gwent",0.2761167938178526,154,0.09941520467836257,36.36363636363637,46,0.2608695652173913,0.7941176470588235,null,145,9]
["Hampshire",0.3193699504379116,588,0.10229007633587786,20.408163265306122,131,0.22137404580152673,0.7058823529411765,null,662,-74]
["Hertfordshire",0.1233684060988854,132,0.2542372881355932,16.666666666666664,46,0.1956521739130435,0.6756756756756757,null,199,-67]
["Humberside",0.2526692307100774,230,0.06504065040650407,26.956521739130434,55,0.16363636363636364,0.8478260869565217,null,291,-61]
["Kent",0.21376552540642854,351,0.10230179028132992,21.937321937321936,104,0.22115384615384615,0.8395061728395061,null,395,-44]
["Lancashire",0.17338492974111075,251,0.16611295681063123,35.85657370517929,119,0.12605042016806722,0.7403846153846154,null,288,-37]
["Leicestershire",0.32097099365646464,313,0.15405405405405406,16.93290734824281,48,0.2916666666666667,0.6176470588235294,null,298,15]
["Lincolnshire",0.21978498666107565,152,0.16022099447513813,25,21,0.19047619047619047,0.7647058823529411,null,155,-3]
["London",0.28623138887599064,2176,0.20786312340735347,33.685661764705884,724,0.3218232044198895,0.6924643584521385,null,2312,-136]
["Merseyside",0.1648362208007049,223,0.09716599190283401,26.905829596412556,59,0.11864406779661017,0.7115384615384616,null,298,-75]
["Norfolk",0.16825615029928115,141,0.1402439024390244,36.17021276595745,43,0.13953488372093023,0.7837837837837838,null,165,-24]
["Northamptonshire",0.2617185989727545,176,0.15789473684210525,18.75,30,0.03333333333333333,0.5517241379310345,null,162,14]
["Northumbria",0.1861598364075859,261,0.16613418530351437,31.800766283524908,72,0.2777777777777778,0.8076923076923077,null,345,-84]
["North Wales",0.25590466737570505,173,0.15196078431372548,17.91907514450867,34,0.11764705882352941,0.7666666666666667,null,106,67]
["North Yorkshire",0.21747056152178224,170,0.1099476439790576,30.58823529411765,34,0.08823529411764706,0.6129032258064516,null,135,35]
["Nottinghamshire",0.28352600856606486,301,0.13505747126436782,18.6046511627907,42,0.16666666666666666,0.8285714285714286,null,255,46]
["South Wales",0.23980873436701394,297,0.051118210862619806,39.05723905723906,99,0.20202020202020202,0.6582278481012658,null,273,24]
["South Yorkshire",0.15534542054004835,202,0.019417475728155338,37.12871287128713,76,0.15789473684210525,0.859375,null,267,-65]
["Staffordshire",0.22589149490285254,240,0.10112359550561797,23.75,78,0.23076923076923078,0.8333333333333334,null,285,-45]
["Suffolk",0.26105178330999473,184,0.22362869198312235,15.217391304347828,25,0.16,0.5714285714285714,null,175,9]
["Surrey",0.16956624953369281,185,0.21610169491525424,12.432432432432433,32,0.21875,0.76,null,138,47]
["Sussex",0.23983411257813245,370,0.1590909090909091,18.37837837837838,75,0.18666666666666668,0.7213114754098361,null,440,-70]
["Thames Valley",0.2019604855130072,440,0.12350597609561753,18.181818181818183,88,0.26136363636363635,0.7076923076923077,null,437,3]
["Warwickshire",0.19084330064433233,101,0.12173913043478261,28.71287128712871,24,0.125,0.7619047619047619,null,110,-9]
["West Mercia",0.23187954450056192,274,0.14641744548286603,22.26277372262774,49,0.14285714285714285,0.8095238095238095,null,220,54]
["West Midlands",0.29327956029562885,764,0.12685714285714286,29.973821989528798,220,0.2727272727272727,0.79375,null,912,-148]
["West Yorkshire",0.30327542021230197,664,0.11584553928095873,21.686746987951807,162,0.20987654320987653,0.828125,null,617,47]
["Wiltshire",0.2084947611801426,134,0.2342857142857143,34.32835820895522,39,0.23076923076923078,0.9333333333333333,null,157,-23]
[]
["TOTAL:",null,13082,null,null,0,null,null,null,13755,-673]
[]
["National Average",0.24189047036047578,null,0.14886141834743005,26.00519798195994]

{"sheet":"Summary 2009-10","index":2,"n_rows":52,"n_cols":25,"rows_kept":52,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["SUMMARY OF RAPE DATA TO END MARCH 2010",{"$nulls":22},"POPULATION DATA - MID YEAR ESTIMATES"]
[]
[null,"Rate of offences per 1,000","Number of offences (police recorded crimes)","% No crimed by police","% resulting in a sanction detection","Number of prosecutions","% discontinuanced by CPS","Of those that go to court, % resulting in a conviction",null,"Number of offences (police recorded crimes) to March 2009","Difference in number of offences from March 2009 to March 2010",{"$nulls":12},"Police force area"]
["Avon & Somerset",0.22880627067092268,365,0.21841541755888652,27.945205479452056,90,0.24444444444444444,0.75,null,338,27,{"$nulls":12},"Avon & Somerset",1595236]
["Bedfordshire",0.24359438531626393,146,0.1978021978021978,19.17808219178082,28,0,0.7142857142857143,null,164,-18,{"$nulls":12},"Bedfordshire",599357]
["Cambridgeshire",0.25570899537517183,197,0.12053571428571429,27.411167512690355,45,0.1111111111111111,0.8,null,196,1,{"$nulls":12},"Cambridgeshire",770407]
["Cheshire",0.16652008910320457,167,0.10215053763440861,17.365269461077844,35,0.08571428571428572,0.71875,null,151,16,{"$nulls":12},"Cheshire",1002882]
["Cleveland",0.2739318894317793,153,0.2193877551020408,30.718954248366014,36,0.1388888888888889,0.7096774193548387,null,136,17,{"$nulls":12},"Cleveland",558533]
["Cumbria",0.22585745168263802,112,0.06666666666666667,21.428571428571427,30,0.03333333333333333,0.6896551724137931,null,75,37,{"$nulls":12},"Cumbria",495888]
["Derbyshire",0.30661336055234345,307,0.08358208955223881,23.778501628664493,74,0.10810810810810811,0.8636363636363636,null,257,50,{"$nulls":12},"Derbyshire",1001261]
["Devon & Cornwall",0.2871990181271146,479,0.12431444241316271,18.997912317327767,70,0.18571428571428572,0.7543859649122807,null,431,48,{"$nulls":12},"Devon & Cornwall",1667833]
["Dorset",0.3319081908190819,236,0.09578544061302682,13.983050847457626,30,0.16666666666666666,0.76,null,167,69,{"$nulls":12},"Dorset",711040]
["Durham",0.20658391190600928,125,0.0234375,48.8,62,0.08064516129032258,0.8245614035087719,null,121,4,{"$nulls":12},"Durham",605081]
["Dyfed-Powys",0.2545694224628901,129,0.06521739130434782,28.68217054263566,33,0.21212121212121213,0.8076923076923077,null,77,52,{"$nulls":12},"Dyfed-Powys",506738]
["Essex",0.2550176929516627,435,0.029017857142857144,16.7816091954023,59,0.22033898305084745,0.7391304347826086,null,343,92,{"$nulls":12},"Essex",1705764]
["Gloucestershire",0.24737188695275367,145,0.03333333333333333,21.379310344827587,34,0.35294117647058826,0.8181818181818182,null,145,0,{"$nulls":12},"Gloucestershire",586162]
["Greater Manchester",0.3379879022036656,872,0.11740890688259109,31.536697247706424,259,0.22393822393822393,0.8059701492537313,null,834,38,{"$nulls":12},"Greater Manchester",2579974]
["Gwent",0.3307907149728394,185,0.19913419913419914,32.432432432432435,69,0.2463768115942029,0.7307692307692307,null,154,31,{"$nulls":12},"Gwent",559266]
["Hampshire",0.3090595919659582,574,0.11145510835913312,20.209059233449477,123,0.13821138211382114,0.6886792452830188,null,588,-14,{"$nulls":12},"Hampshire",1857247]
["Hertfordshire",0.17252975676994772,187,0.15765765765765766,16.0427807486631,27,0.14814814814814814,0.6956521739130435,null,132,55,{"$nulls":12},"Hertfordshire",1083871]
["Humberside",0.31699324257853234,290,0.0880503144654088,31.379310344827587,76,0.15789473684210525,0.78125,null,230,60,{"$nulls":12},"Humberside",914846]
["Kent",0.20541882784391793,340,0.13705583756345177,29.117647058823533,92,0.13043478260869565,0.7375,null,351,-11,{"$nulls":12},"Kent",1655155]
["Lancashire",0.17645312609201996,255,0.1326530612244898,36.86274509803922,123,0.12195121951219512,0.8333333333333334,null,251,4,{"$nulls":12},"Lancashire",1445143]
["Leicestershire",0.2715067403836279,267,0.19090909090909092,18.352059925093634,48,0.3125,0.9090909090909091,null,313,-46,{"$nulls":12},"Leicestershire",983401]
["Lincolnshire",0.22714072949551756,158,0.1366120218579235,13.291139240506327,24,0.125,0.8095238095238095,null,152,6,{"$nulls":12},"Lincolnshire",695604]
["London",0.37348418756104657,2864,0.13238412602241745,23.952513966480446,894,0.27293064876957496,0.6261538461538462,null,2176,688,{"$nulls":12},"London, City of",11330]
["Merseyside",0.24736508049363404,334,0.037463976945244955,21.856287425149702,77,0.15584415584415584,0.7846153846153846,null,223,111,{"$nulls":12},"Merseyside",1350231]
["Norfolk",0.1970857275708771,167,0.12105263157894737,23.952095808383234,60,0.05,0.7894736842105263,null,141,26,{"$nulls":12},"Metropolitan Police",7657000]
["Northamptonshire",0.2723616255719594,185,0.11057692307692307,36.21621621621622,34,0.14705882352941177,0.7931034482758621,null,176,9,{"$nulls":12},"Norfolk",847347]
["Northumbria",0.23880019956873821,336,0.16,29.166666666666668,72,0.25,0.8518518518518519,null,261,75,{"$nulls":12},"Northamptonshire",679244]
["North Wales",0.26549808177635914,180,0.16279069767441862,18.88888888888889,29,0.034482758620689655,0.8571428571428571,null,173,7,{"$nulls":12},"Northumbria",1407034]
["North Yorkshire",0.19153248822265462,151,0.09036144578313253,29.13907284768212,57,0.07017543859649122,0.7735849056603774,null,170,-19,{"$nulls":12},"North Wales",677971]
["Nottinghamshire",0.3224615499651835,345,0.11538461538461539,25.507246376811594,86,0.23255813953488372,0.7727272727272727,null,301,44,{"$nulls":12},"North Yorkshire",788378]
["South Wales",0.19581061582438677,244,0.08270676691729323,43.85245901639344,132,0.11363636363636363,0.6239316239316239,null,297,-53,{"$nulls":12},"Nottinghamshire",1069895]
["South Yorkshire",0.21037299514535626,275,0.028268551236749116,28,72,0.1527777777777778,0.8032786885245902,null,202,73,{"$nulls":12},"South Wales",1246102]
["Staffordshire",0.27011412321705924,288,0.12727272727272726,21.52777777777778,69,0.17391304347826086,0.7543859649122807,null,240,48,{"$nulls":12},"South Yorkshire",1307202]
["Suffolk",0.34618047542118624,246,0.16040955631399317,19.10569105691057,31,0.12903225806451613,0.8888888888888888,null,184,62,{"$nulls":12},"Staffordshire",1066216]
["Surrey",0.18533256293130704,204,0.2,21.07843137254902,28,0.17857142857142858,0.6521739130434783,null,185,19,{"$nulls":12},"Suffolk",710612]
["Sussex",0.2954582467288781,459,0.09467455621301775,20.697167755991288,76,0.11842105263157894,0.6865671641791045,null,370,89,{"$nulls":12},"Surrey",1100724]
["Thames Valley",0.271134035132976,597,0.13352685050798258,23.953098827470686,105,0.13333333333333333,0.7362637362637363,null,440,157,{"$nulls":12},"Sussex",1553519]
["Warwickshire",0.2212961955808275,118,0.08527131782945736,25.423728813559322,24,0,0.8333333333333334,null,101,17,{"$nulls":12},"Thames Valley",2201863]
["West Mercia",0.2637588586741272,313,0.13774104683195593,29.073482428115017,56,0.05357142857142857,0.660377358490566,null,274,39,{"$nulls":12},"Warwickshire",533222]
["West Midlands",0.3405406168094357,893,0.07747933884297521,26.651735722284435,256,0.25,0.796875,null,764,129,{"$nulls":12},"West Mercia",1186690]
["West Yorkshire",0.3013085399449036,665,0.13860103626943004,23.458646616541355,150,0.22666666666666666,0.7586206896551724,null,664,1,{"$nulls":12},"West Midlands",2622301]
["Wiltshire",0.24611106069252575,160,0.22705314009661837,28.75,44,0.22727272727272727,0.7941176470588235,null,134,26,{"$nulls":12},"West Yorkshire",2207040]
[{"$nulls":23},"Wiltshire",650113]
["TOTAL:",null,15148,null,null,0,null,null,null,13082,2066,{"$nulls":12},"london",7668330]
[{"$nulls":23},"England ",51464646]
["National Average",0.27817605462798883,null,0.12271963861701511,24.973593873778714]
[{"$nulls":23},"Wales",2990077]
[]
[{"$nulls":23},"ENGLAND AND WALES",54454723]

{"sheet":"Summary 2010-11","index":3,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["SUMMARY OF RAPE DATA TO END MARCH 2011"]
[]
[null,"Rate of offences per 1,000","Number of offences (police recorded crimes)","% No crimed by police","% resulting in a sanction detection","Number of prosecutions","% discontinuanced by CPS","Of those that go to court, % resulting in a conviction",null,"Number of offences (police recorded crimes) to March 2010","Difference in number of offences from March 2010 to March 2011",null,"Dedicated Investigators","Dedicated SOLOs","Part-time SOLOs","Comments"]
["Avon & Somerset",0.228806270670923,365,14.519906323185012,33.6986301369863,104,13.461538461538462,71.11111111111111,null,365,0]
["Bedfordshire",0.18353001633417146,110,24.65753424657534,11.818181818181818,23,4.3478260869565215,63.63636363636363,null,146,-36]
["Cambridgeshire",0.2790732690642738,215,13.306451612903224,20.930232558139537,48,6.25,77.77777777777779,null,197,18]
["Cheshire",0.16951146794936992,170,14.14141414141414,25.882352941176475,42,14.285714285714285,77.77777777777779,null,170,0]
["Cleveland",0.3401768561571116,190,17.391304347826086,32.631578947368425,60,10,77.77777777777779,null,149,41]
["Cumbria",0.2661891394831091,132,7.6923076923076925,16.666666666666664,25,8,82.6086956521739,null,112,20,{"$nulls":4},"SOLOs attached to CID"]
["Derbyshire",0.315602025845409,316,12.70718232044199,24.050632911392405,88,15.909090909090908,63.51351351351351,null,307,9]
["Devon & Cornwall",0.33996209452625054,567,10,20.634920634920633,84,13.095238095238097,84.93150684931507,null,479,88]
["Dorset",0.32065706570657065,228,8.064516129032258,17.105263157894736,37,5.405405405405405,80,null,236,-8]
["Durham",0.26112206464919574,158,10.734463276836157,60.75949367088608,68,25,76.47058823529412,null,120,38]
["Dyfed-Powys",0.23680876508175822,120,6.25,39.166666666666664,36,22.22222222222222,57.14285714285714,null,129,-9]
["Essex",0.2632251589317162,449,4.670912951167728,17.59465478841871,86,13.953488372093023,74.32432432432432,null,435,14]
["Gloucestershire",0.27978613420863174,164,2.380952380952381,21.951219512195124,34,8.823529411764707,80.64516129032258,null,145,19]
["Greater Manchester",0.3263598780452826,842,7.166482910694598,32.779097387173394,318,15.723270440251572,73.88059701492537,null,840,2]
["Gwent",0.3361548887291557,188,22.31404958677686,26.595744680851062,57,17.543859649122805,72.3404255319149,null,185,3]
["Hampshire",0.31336704272506566,582,11.818181818181818,17.18213058419244,112,23.214285714285715,56.97674418604651,null,574,8]
["Hertfordshire",0.17898808991106874,194,13.392857142857142,17.525773195876287,26,11.538461538461538,78.26086956521739,null,187,7]
["Humberside",0.4164635359393821,381,4.75,33.33333333333333,107,11.214953271028037,80,null,290,91]
["Kent",0.18366859901338545,304,29.953917050691242,34.53947368421053,112,16.964285714285715,66.66666666666666,null,330,-26]
["Lancashire",0.29547248957369615,427,10.855949895615867,26.229508196721312,135,22.22222222222222,75.23809523809524,null,255,172]
["Leicestershire",0.2379497275272244,234,7.5098814229249005,22.64957264957265,47,21.27659574468085,86.48648648648648,null,267,-33,{"$nulls":4},"Solace Team"]
["Lincolnshire",0.2717063156623596,189,17.82608695652174,11.11111111111111,17,0,94.11764705882352,null,158,31]
["London",0.43268873405291636,3318,9.615908471806048,18.565400843881857,861,22.99651567944251,67.57164404223228,null,2846,472]
["Merseyside",0.27032411491070785,365,14.719626168224298,26.301369863013697,100,12,61.36363636363637,null,334,31]
["Norfolk",0.24311173580599213,206,14.87603305785124,22.815533980582526,36,19.444444444444446,72.41379310344827,null,167,39]
["Northamptonshire",0.3754173757883765,255,6.934306569343065,31.372549019607842,50,18,68.29268292682927,null,185,70]
["Northumbria",0.25088235252310886,353,21.555555555555557,34.56090651558073,92,17.391304347826086,81.57894736842105,null,336,17]
["North Wales",0.2787729858651771,189,16,25.925925925925924,50,8,73.91304347826086,null,180,9]
["North Yorkshire",0.24480642534418767,193,6.310679611650485,17.616580310880828,37,10.81081081081081,69.6969696969697,null,151,42]
["Nottinghamshire",0.2775973343178536,297,14.16184971098266,22.22222222222222,91,36.26373626373626,68.96551724137932,null,345,-48]
["South Wales",0.18858809310955282,235,6.374501992031872,49.787234042553195,135,28.888888888888886,62.5,null,244,-9]
["South Yorkshire",0.2256728493377458,295,3.908794788273615,25.08474576271186,104,15.384615384615385,71.5909090909091,null,275,20]
["Staffordshire",0.21759193259151993,232,22.666666666666664,35.3448275862069,77,18.181818181818183,80.95238095238095,null,288,-56]
["Suffolk",0.2927054426325477,208,14.049586776859504,20.192307692307693,42,9.523809523809524,84.21052631578947,null,246,-38]
["Surrey",0.1789731122424877,197,25.660377358490567,21.31979695431472,72,8.333333333333332,54.54545454545454,null,204,-7,{"$nulls":4},"Civilian SOLOs led by DI"]
["Sussex",0.2851590485858235,443,9.775967413441954,22.799097065462753,115,20,69.56521739130434,null,459,-16]
["Thames Valley",0.22980539661186916,506,11.538461538461538,25.296442687747035,153,14.37908496732026,58.778625954198475,null,588,-82]
["Warwickshire",0.24005011046055866,128,12.925170068027212,32.8125,26,11.538461538461538,86.95652173913044,null,118,10]
["West Mercia",0.29493802088161186,350,7.651715039577836,21.428571428571427,81,17.28395061728395,71.64179104477611,null,314,36]
["West Midlands",0.335964482972792,881,8.229166666666666,18.615209988649262,212,20.28301886792453,68.63905325443787,null,893,-12]
["West Yorkshire",0.27095113817601857,598,12.445095168374817,27.759197324414714,160,26.25,83.89830508474576,null,665,-67,{"$nulls":4},"Topaz"]
["Wiltshire",0.25534022546849544,166,19.024390243902438,26.506024096385545,48,16.666666666666664,65,null,160,6]
[]
["TOTAL:",null,15940,null,null,4208,null,null,null,15074,866]
[]
["National Average",0.29,null,0.117,0.242,null,0.184,0.711]

{"sheet":"% changes","index":4,"n_rows":160,"n_cols":5,"rows_kept":160,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[null,"Values"]
["Row Labels","Sum of CONVICTION % change between 07/08 and 08/09","Sum of CONVICTION % change between 08/09 and 09/10","Sum of DETECTION % change between 07/08 and 08/09","Sum of DETECTION % change between 08/09 and 09/10"]
["Avon & Somerset",-3.533447684391073,11.486486486486486,-18.22729213688768,34.93542074363992]
["Bedfordshire",-40.62499999999999,42.85714285714286,-10.627177700348414,16.489091831557566]
["Cambridgeshire",-1.902748414376325,18.620689655172423,19.83573917371829,19.390862944162425]
["Cheshire",18.6046511627907,-9.099264705882348,-14.780252859723056,-30.99590293098015]
["Cleveland",-6.535947712418312,-7.196029776674926,22.238163558106173,-12.962962962962965]
["Cumbria",-40,53.25670498084292,-13.59999999999999,0.4464285714285531]
["Derbyshire",-18.18181818181818,25,-16.873010258224276,1.851248642779585]
["Devon & Cornwall",1.247872943845714,-7.31829573934837,11.368909512761038,2.3512526096033444]
["Dorset",17.85714285714286,-3.2727272727272694,-40.43491963441537,29.731638418079083]
["Durham",7.050304878048773,-0.4303210857331997,1.7932324964914994,15.78039215686274]
["Dyfed-Powys",-31.818181818181827,48.07692307692309,58.0705009276438,-7.97803617571059]
["Essex",10.821382007822688,-12.782608695652176,-2.9154518950437245,-8.633461047254153]
["Gloucestershire",2.9829545454545507,4.727272727272734,-19.36080740117746,-8.823529411764696]
["Greater Manchester",-1.024334310103199,5.811723505378138,-18.465227817745802,3.143550998381012]
["Gwent",5.882352941176464,-7.977207977207977,78.78787878787878,-10.81081081081081]
["Hampshire",-4.044117647058816,-2.437106918239006,-1.2775842044134633,-0.9756097560975628]
["Hertfordshire",7.68581081081081,2.9565217391304346,-22.522522522522536,-3.7433155080213756]
["Humberside",8.521739130434781,-7.852564102564101,20.374812593703144,16.4071190211346]
["Kent",23.35600907029477,-12.150735294117638,-14.781941705018637,32.73109243697481]
["Lancashire",-2.4434389140271406,12.554112554112553,20.14280540176957,2.8061002178649246]
["Leicestershire",-27.205882352941174,47.186147186147174,38.28541001064963,8.38103314253411]
["Lincolnshire",-9.625668449197866,5.860805860805869,50.00000000000002,-46.83544303797469]
["London",3.4223253708878616,-9.57601809954751,1.163081866604913,-28.894037665673334]
["Merseyside",-5.128205128205124,10.270270270270265,29.354949982752665,-18.767465069860272]
["Norfolk",-3.8083538083538047,0.7259528130671536,75.86206896551727,-33.77949982388165]
["North Wales",-6.904761904761894,11.80124223602483,5.446865273454872,5.412186379928314]
["North Yorkshire",-4.999999999999996,26.216484607745787,23.30882352941176,-4.737646459500771]
["Northamptonshire",-29.780564263322884,43.75000000000001,-10.937499999999991,93.15315315315316]
["Northumbria",-4.692307692307686,5.4673721340388,9.583721652687169,-8.28313253012049]
["Nottinghamshire",4.400000000000013,-6.739811912225714,-24.92860057119543,37.101449275362306]
["South Wales",-9.798406000937652,-5.210387902695588,-6.26262626262627,12.277416619559059]
["South Yorkshire",4.3526785714285765,-6.527570789865872,11.862147753236869,-24.586666666666666]
["Staffordshire",18.42105263157895,-9.473684210526317,10.985576923076922,-9.356725146198826]
["Suffolk",-23.809523809523814,55.55555555555556,-13.768115942028981,25.55168408826944]
["Surrey",4.499999999999998,-14.187643020594965,-48.888888888888886,69.54390451832906]
["Sussex",-15.591210324380878,-4.816824966078703,-8.404533565823888,12.616942201717297]
["Thames Valley",9.370629370629372,4.037267080745343,-3.7131882202304736,31.742043551088763]
["Warwickshire",-9.523809523809524,9.37500000000001,33.5772707705553,-11.455289304500283]
["West Mercia",3.030303030303034,-18.42397336293008,1.2326125877978285,30.592363693500236]
["West Midlands",-6.083015267175583,0.39370078740158043,20.918784318733245,-11.08329217543534]
["West Yorkshire",-0.6250000000000043,-8.39297332465843,-8.88655292310181,8.170426065162916]
["Wiltshire",28.333333333333332,-14.915966386554627,56.76616915422883,-16.249999999999996]
["Grand Total",-127.8452005513095,277.2056605704392,281.3033307313634,211.65397479765863]
{"$rows_empty":16}
["Row Labels","Sum of CONVICTION % change between 07/08 and 08/09","Sum of CONVICTION % change between 08/09 and 09/10"]
["Suffolk",-23.809523809523814,55.55555555555556]
["Cumbria",-40,53.25670498084292]
["Dyfed-Powys",-31.818181818181827,48.07692307692309]
["Leicestershire",-27.205882352941174,47.186147186147174]
["Northamptonshire",-29.780564263322884,43.75000000000001]
["Bedfordshire",-40.62499999999999,42.85714285714286]
["North Yorkshire",-4.999999999999996,26.216484607745787]
["Derbyshire",-18.18181818181818,25]
["Cambridgeshire",-1.902748414376325,18.620689655172423]
["Lancashire",-2.4434389140271406,12.554112554112553]
["North Wales",-6.904761904761894,11.80124223602483]
["Avon & Somerset",-3.533447684391073,11.486486486486486]
["Merseyside",-5.128205128205124,10.270270270270265]
["Warwickshire",-9.523809523809524,9.37500000000001]
["Lincolnshire",-9.625668449197866,5.860805860805869]
["Greater Manchester",-1.024334310103199,5.811723505378138]
["Northumbria",-4.692307692307686,5.4673721340388]
["Gloucestershire",2.9829545454545507,4.727272727272734]
["Thames Valley",9.370629370629372,4.037267080745343]
["Hertfordshire",7.68581081081081,2.9565217391304346]
["Norfolk",-3.8083538083538047,0.7259528130671536]
["West Midlands",-6.083015267175583,0.39370078740158043]
["Durham",7.050304878048773,-0.4303210857331997]
["Hampshire",-4.044117647058816,-2.437106918239006]
["Dorset",17.85714285714286,-3.2727272727272694]
["Sussex",-15.591210324380878,-4.816824966078703]
["South Wales",-9.798406000937652,-5.210387902695588]
["South Yorkshire",4.3526785714285765,-6.527570789865872]
["Nottinghamshire",4.400000000000013,-6.739811912225714]
["Cleveland",-6.535947712418312,-7.196029776674926]
["Devon & Cornwall",1.247872943845714,-7.31829573934837]
["Humberside",8.521739130434781,-7.852564102564101]
["Gwent",5.882352941176464,-7.977207977207977]
["West Yorkshire",-0.6250000000000043,-8.39297332465843]
["Cheshire",18.6046511627907,-9.099264705882348]
["Staffordshire",18.42105263157895,-9.473684210526317]
["London",3.4223253708878616,-9.57601809954751]
["Kent",23.35600907029477,-12.150735294117638]
["Essex",10.821382007822688,-12.782608695652176]
["Surrey",4.499999999999998,-14.187643020594965]
["Wiltshire",28.333333333333332,-14.915966386554627]
["West Mercia",3.030303030303034,-18.42397336293008]
{"$rows_empty":11}
["Row Labels","Sum of DETECTION % change between 07/08 and 08/09","Sum of DETECTION % change between 08/09 and 09/10"]
["Northamptonshire",-10.937499999999991,93.15315315315316]
["Surrey",-48.888888888888886,69.54390451832906]
["Nottinghamshire",-24.92860057119543,37.101449275362306]
["Avon & Somerset",-18.22729213688768,34.93542074363992]
["Kent",-14.781941705018637,32.73109243697481]
["Thames Valley",-3.7131882202304736,31.742043551088763]
["West Mercia",1.2326125877978285,30.592363693500236]
["Dorset",-40.43491963441537,29.731638418079083]
["Suffolk",-13.768115942028981,25.55168408826944]
["Cambridgeshire",19.83573917371829,19.390862944162425]
["Bedfordshire",-10.627177700348414,16.489091831557566]
["Humberside",20.374812593703144,16.4071190211346]
["Durham",1.7932324964914994,15.78039215686274]
["Sussex",-8.404533565823888,12.616942201717297]
["South Wales",-6.26262626262627,12.277416619559059]
["Leicestershire",38.28541001064963,8.38103314253411]
["West Yorkshire",-8.88655292310181,8.170426065162916]
["North Wales",5.446865273454872,5.412186379928314]
["Greater Manchester",-18.465227817745802,3.143550998381012]
["Lancashire",20.14280540176957,2.8061002178649246]
["Devon & Cornwall",11.368909512761038,2.3512526096033444]
["Derbyshire",-16.873010258224276,1.851248642779585]
["Cumbria",-13.59999999999999,0.4464285714285531]
["Hampshire",-1.2775842044134633,-0.9756097560975628]
["Hertfordshire",-22.522522522522536,-3.7433155080213756]
["North Yorkshire",23.30882352941176,-4.737646459500771]
["Dyfed-Powys",58.0705009276438,-7.97803617571059]
["Northumbria",9.583721652687169,-8.28313253012049]
["Essex",-2.9154518950437245,-8.633461047254153]
["Gloucestershire",-19.36080740117746,-8.823529411764696]
["Staffordshire",10.985576923076922,-9.356725146198826]
["Gwent",78.78787878787878,-10.81081081081081]
["West Midlands",20.918784318733245,-11.08329217543534]
["Warwickshire",33.5772707705553,-11.455289304500283]
["Cleveland",22.238163558106173,-12.962962962962965]
["Wiltshire",56.76616915422883,-16.249999999999996]
["Merseyside",29.354949982752665,-18.767465069860272]
["South Yorkshire",11.862147753236869,-24.586666666666666]
["London",1.163081866604913,-28.894037665673334]
["Cheshire",-14.780252859723056,-30.99590293098015]
["Norfolk",75.86206896551727,-33.77949982388165]
["Lincolnshire",50.00000000000002,-46.83544303797469]

{"sheet":"ALL YEARS","index":5,"n_rows":49,"n_cols":40,"rows_kept":49,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
["Police Force","Rate of offences per 1,000 2007/08","Rate of offences per 1,000 2008/09","Rate of offences per 1,000 2009/10","Rate of offences per 1,000 2010/11","RATE OF OFFENCE % change over 2 years","RATE OF OFFENCE % change between 07/08 and 08/09","RATE OF OFFENCE % change between 08/09 and 09/10",null,"Number of offences (police recorded crimes) 2007/08","Number of offences (police recorded crimes) 2008/09","Number of offences (police recorded crimes) 2009/10","Number of offences (police recorded crimes) 2010/11","% No crimed by police 2007/08","% No crimed by police 2008/09","% No crimed by police 2009/10","% No crimed by police 2010/11","% resulting in a sanction detection 2007/08","% resulting in a sanction detection 2008/09","% resulting in a sanction detection 2009/10","% resulting in a sanction detection 2010/11","DETECTION % change over 2 years","DETECTION % change between 07/08 and 08/09","DETECTION % change between 08/09 and 09/10","Number of prosecutions 2007/08","Number of prosecutions 2008/09","Number of prosecutions 2009/10","Number of prosecutions 2010/11","% discontinuanced by CPS 2007/08","% discontinuanced by CPS 2008/09","% discontinuanced by CPS 2009/10","% discontinuanced by CPS 2010/11","Of those that go to court, % resulting in a conviction 2007/08","Of those that go to court, % resulting in a conviction 2008/09","Of those that go to court, % resulting in a conviction 2009/10","Of those that go to court, % resulting in a conviction 2010/11","CONVICTION % change over 2 years","CONVICTION % change between 07/08 and 08/09","CONVICTION % change between 08/09 and 09/10","CONVICTION % change between 09/10 and 10/11"]
["Lincolnshire",0.23633212541358123,0.21978498666107565,0.22714072949551756,0.2717063156623596,-3.8891859927966745,-7.0016459774768585,3.3467904001036204,null,162,152,158,189,0.17766497461928935,0.16022099447513813,0.1366120218579235,17.82608695652174,16.666666666666664,25,13.291139240506327,11.11111111111111,-20.253164556962027,50.00000000000002,-46.83544303797469,17,21,24,17,0.23529411764705882,0.19047619047619047,0.125,0,0.8461538461538461,0.7647058823529411,0.8095238095238095,94.11764705882352,-4.329004329004327,-9.625668449197866,5.860805860805869]
["Warwickshire",0.20387165612377106,0.19084330064433233,0.2212961955808275,0.24005011046055866,8.546818026767756,-6.3904692428304894,15.957015432912216,null,107,101,118,128,0.144,0.12173913043478261,0.08527131782945736,12.925170068027212,21.49532710280374,28.71287128712871,25.423728813559322,32.8125,18.275607958732497,33.5772707705553,-11.455289304500283,23,24,24,26,0.17391304347826086,0.125,0,11.538461538461538,0.8421052631578947,0.7619047619047619,0.8333333333333334,86.95652173913044,-1.0416666666666567,-9.523809523809524,9.37500000000001]
["Leicestershire",0.35497618658293506,0.32097099365646464,0.2715067403836279,0.2379497275272244,-23.514097382925645,-9.57957018294961,-15.410817254651482,null,343,313,267,234,0.11139896373056994,0.15405405405405406,0.19090909090909092,7.5098814229249005,12.244897959183673,16.93290734824281,18.352059925093634,22.64957264957265,49.87515605493135,38.28541001064963,8.38103314253411,40,48,48,47,0.175,0.2916666666666667,0.3125,21.27659574468085,0.8484848484848485,0.6176470588235294,0.9090909090909091,86.48648648648648,7.142857142857137,-27.205882352941174,47.186147186147174]
["Devon & Cornwall",0.24451156685688288,0.25954036665646973,0.2871990181271146,0.33996209452625054,17.45825435539313,6.146457606393518,10.656782151831573,null,402,431,479,567,0.12987012987012986,0.14653465346534653,0.12431444241316271,10,16.666666666666664,18.561484918793504,18.997912317327767,20.634920634920633,13.987473903966618,11.368909512761038,2.3512526096033444,59,49,70,84,0.13559322033898305,0.12244897959183673,0.18571428571428572,13.095238095238097,0.803921568627451,0.813953488372093,0.7543859649122807,84.93150684931507,-6.161745827984597,1.247872943845714,-7.31829573934837]
["Suffolk",0.2433710033470671,0.26105178330999473,0.34618047542118624,0.2927054426325477,42.24392826597521,7.264949283096551,32.60988721540453,null,170,184,246,208,0.19047619047619047,0.22362869198312235,0.16040955631399317,14.049586776859504,17.647058823529413,15.217391304347828,19.10569105691057,20.192307692307693,8.265582655826549,-13.768115942028981,25.55168408826944,31,25,31,42,0.22580645161290322,0.16,0.12903225806451613,9.523809523809524,0.75,0.5714285714285714,0.8888888888888888,84.21052631578947,18.518518518518512,-23.809523809523814,55.55555555555556]
["West Yorkshire",0.2884409811048119,0.30327542021230197,0.3013085399449036,0.27095113817601857,4.461071651748379,5.142972073756607,-0.6485458880978583,null,626,664,665,598,0.1329639889196676,0.11584553928095873,0.13860103626943004,12.445095168374817,23.80191693290735,21.686746987951807,23.458646616541355,27.759197324414714,-1.442196094262503,-8.88655292310181,8.170426065162916,132,162,150,160,0.09090909090909091,0.20987654320987653,0.22666666666666666,26.25,0.8333333333333334,0.828125,0.7586206896551724,83.89830508474576,-8.965517241379318,-0.6250000000000043,-8.39297332465843]
["Cumbria",0.1630638284165898,0.15097530044084786,0.22585745168263802,0.2661891394831091,38.50861584435834,-7.413371863721116,49.59894169651213,null,81,75,112,132,0.1,0.15730337078651685,0.06666666666666667,7.6923076923076925,24.691358024691358,21.333333333333336,21.428571428571427,16.666666666666664,-13.21428571428572,-13.59999999999999,0.4464285714285531,24,24,30,25,0.3333333333333333,0.16666666666666666,0.03333333333333333,8,0.75,0.45,0.6896551724137931,82.6086956521739,-8.045977011494248,-40,53.25670498084292]
["North Yorkshire",0.16620969736950605,0.21747056152178224,0.19153248822265462,0.25088235252310886,15.23544730176162,30.84107904866497,-11.927165275898556,null,129,170,151,353,0.0851063829787234,0.1099476439790576,0.09036144578313253,21.555555555555557,24.8062015503876,30.58823529411765,29.13907284768212,34.56090651558073,17.466887417218537,23.30882352941176,-4.737646459500771,42,34,57,92,0.2619047619047619,0.08823529411764706,0.07017543859649122,17.391304347826086,0.6451612903225806,0.6129032258064516,0.7735849056603774,81.57894736842105,19.9056603773585,-4.999999999999996,26.216484607745787]
["Staffordshire",0.22915275718860686,0.22589149490285254,0.27011412321705924,0.21759193259151993,17.875135578115103,-1.423182651505303,19.5769337545113,null,243,240,288,232,0.13523131672597866,0.10112359550561797,0.12727272727272726,22.666666666666664,21.39917695473251,23.75,21.52777777777778,35.3448275862069,0.6009615384615408,10.985576923076922,-9.356725146198826,68,78,69,77,0.20588235294117646,0.23076923076923078,0.17391304347826086,18.181818181818183,0.7037037037037037,0.8333333333333334,0.7543859649122807,80.95238095238095,7.202216066481994,18.42105263157895,-9.473684210526317]
["Gloucestershire",0.24336863616906698,0.24804854224437745,0.24737188695275367,0.27978613420863174,1.644932907831906,1.9229700872627467,-0.2727914808534283,null,141,145,145,164,0.06622516556291391,0.07643312101910828,0.03333333333333333,2.380952380952381,29.078014184397162,23.448275862068964,21.379310344827587,21.951219512195124,-26.476030277544147,-19.36080740117746,-8.823529411764696,36,44,34,34,0.19444444444444445,0.2727272727272727,0.35294117647058826,8.823529411764707,0.7586206896551724,0.78125,0.8181818181818182,80.64516129032258,7.8512396694215,2.9829545454545507,4.727272727272734]
["Humberside",0.28565346815294707,0.2526692307100774,0.31699324257853234,0.4164635359393821,10.971256406663006,-11.546941003779079,25.45779384679523,null,259,230,290,381,0.10380622837370242,0.06504065040650407,0.0880503144654088,4.75,22.393822393822393,26.956521739130434,31.379310344827587,33.33333333333333,40.124851367419744,20.374812593703144,16.4071190211346,80,55,76,107,0.2,0.16363636363636364,0.15789473684210525,11.214953271028037,0.78125,0.8478260869565217,0.78125,80,0,8.521739130434781,-7.852564102564101]
["Dorset",0.29908394859174187,0.23545003383713062,0.3319081908190819,0.32065706570657065,10.974926064034973,-21.27627211498179,40.9675698108733,null,210,167,236,228,0.17647058823529413,0.14358974358974358,0.09578544061302682,8.064516129032258,18.095238095238095,10.778443113772456,13.983050847457626,17.105263157894736,-22.725245316681537,-40.43491963441537,29.731638418079083,29,32,30,37,0.1724137931034483,0.125,0.16666666666666666,5.405405405405405,0.6666666666666666,0.7857142857142857,0.76,80,14.000000000000007,17.85714285714286,-3.2727272727272694]
["Hertfordshire",0.1623525258560556,0.1233684060988854,0.17252975676994772,0.17898808991106874,6.268600294469954,-24.012019247384035,39.84922252432869,null,172,132,187,194,0.22869955156950672,0.2542372881355932,0.15765765765765766,13.392857142857142,21.511627906976745,16.666666666666664,16.0427807486631,17.525773195876287,-25.422748952160717,-22.522522522522536,-3.7433155080213756,62,46,27,26,0.1774193548387097,0.1956521739130435,0.14814814814814814,11.538461538461538,0.6274509803921569,0.6756756756756757,0.6956521739130435,78.26086956521739,10.869565217391303,7.68581081081081,2.9565217391304346]
["Cleveland",0.2551987764836125,0.2441884057190361,0.2739318894317793,0.3401768561571116,7.340596693405291,-4.314429291663716,12.180547076000877,null,142,136,153,190,0.22826086956521738,0.26881720430107525,0.2193877551020408,17.391304347826086,28.87323943661972,35.294117647058826,30.718954248366014,32.631578947368425,6.392475689462775,22.238163558106173,-12.962962962962965,39,41,36,60,0.15384615384615385,0.17073170731707318,0.1388888888888889,10,0.8181818181818182,0.7647058823529411,0.7096774193548387,77.77777777777779,-13.261648745519713,-6.535947712418312,-7.196029776674926]
["Cambridgeshire",0.284396720135022,0.25758360296378846,0.25570899537517183,0.2790732690642738,-10.087220677590862,-9.42806835412995,-0.7277666617933609,null,214,196,197,215,0.0815450643776824,0.10909090909090909,0.12053571428571429,13.306451612903224,19.158878504672895,22.95918367346939,27.411167512690355,20.930232558139537,43.072923115017964,19.83573917371829,19.390862944162425,22,50,45,48,0.2727272727272727,0.14,0.1111111111111111,6.25,0.6875,0.6744186046511628,0.8,77.77777777777779,16.36363636363637,-1.902748414376325,18.620689655172423]
["Cheshire",0.1492604595018307,0.15085894688466286,0.16652008910320457,0.16951146794936992,11.56343056893924,1.070938270032968,10.381314825507308,null,149,151,167,170,0.14857142857142858,0.11695906432748537,0.10215053763440861,14.14141414141414,29.53020134228188,25.165562913907287,17.365269461077844,25.882352941176475,-41.19488296135003,-14.780252859723056,-30.99590293098015,36,49,35,42,0.16666666666666666,0.12244897959183673,0.08571428571428572,14.285714285714285,0.6666666666666666,0.7906976744186046,0.71875,77.77777777777779,7.812500000000005,18.6046511627907,-9.099264705882348]
["Durham",0.21439350923650788,0.20117479429461632,0.20658391190600928,0.26112206464919574,-3.64264634610904,-6.1656320608612045,2.688765076340237,null,128,121,125,158,0.058823529411764705,0.1357142857142857,0.0234375,10.734463276836157,41.40625,42.14876033057851,48.8,60.75949367088608,17.856603773584897,1.7932324964914994,15.78039215686274,58,76,62,68,0.08620689655172414,0.15789473684210525,0.08064516129032258,25,0.7735849056603774,0.828125,0.8245614035087719,76.47058823529412,6.589644843816854,7.050304878048773,-0.4303210857331997]
["Lancashire",0.17829487899789984,0.17338492974111075,0.17645312609201996,0.29547248957369615,-1.032981382433069,-2.7538363885633093,1.7695865237483344,null,258,251,255,427,0.19122257053291536,0.16611295681063123,0.1326530612244898,10.855949895615867,29.844961240310074,35.85657370517929,36.86274509803922,26.229508196721312,23.51413292589766,20.14280540176957,2.8061002178649246,134,119,123,135,0.16417910447761194,0.12605042016806722,0.12195121951219512,22.22222222222222,0.7589285714285714,0.7403846153846154,0.8333333333333334,75.23809523809524,9.80392156862746,-2.4434389140271406,12.554112554112553]
["Essex",0.17766978869299863,0.2038090303443719,0.2550176929516627,0.2632251589317162,43.53464076681941,14.71226022367827,25.125806506593257,null,296,343,435,449,0.0975609756097561,0.10909090909090909,0.029017857142857144,4.670912951167728,18.91891891891892,18.367346938775512,16.7816091954023,17.59465478841871,-11.297208538587844,-2.9154518950437245,-8.633461047254153,45,76,59,86,0.24444444444444444,0.2236842105263158,0.22033898305084745,13.953488372093023,0.7647058823529411,0.847457627118644,0.7391304347826086,74.32432432432432,-3.3444816053511706,10.821382007822688,-12.782608695652176]
["Northamptonshire",0.22900050319847415,0.2617185989727545,0.2723616255719594,0.2787729858651771,18.934946328875224,14.287346672737952,4.066591614420521,null,152,176,185,189,0.10059171597633136,0.15789473684210525,0.11057692307692307,16,21.052631578947366,18.75,36.21621621621622,25.925925925925924,72.02702702702705,-10.937499999999991,93.15315315315316,30,30,34,50,0.06666666666666667,0.03333333333333333,0.14705882352941177,8,0.7857142857142857,0.5517241379310345,0.7931034482758621,73.91304347826086,0.9404388714733601,-29.780564263322884,43.75000000000001]
["Greater Manchester",0.3069539557320715,0.3250873915985568,0.3379879022036656,0.3263598780452826,10.110293707595165,5.907542655131408,3.9683208080365433,null,784,834,872,842,0.21442885771543085,0.13485477178423236,0.11740890688259109,7.166482910694598,37.5,30.575539568345324,31.536697247706424,32.779097387173394,-15.902140672782869,-18.465227817745802,3.143550998381012,269,294,259,318,0.19330855018587362,0.20068027210884354,0.22393822393822393,15.723270440251572,0.7695852534562212,0.7617021276595745,0.8059701492537313,73.88059701492537,4.727857717401019,-1.024334310103199,5.811723505378138]
["Norfolk",0.16978092240409787,0.16825615029928115,0.1970857275708771,0.24311173580599213,16.082375322352597,-0.8980821185478,17.13433786540113,null,141,141,167,206,0.10191082802547771,0.1402439024390244,0.12105263157894737,14.87603305785124,20.56737588652482,36.17021276595745,23.952095808383234,22.815533980582526,16.456741689035727,75.86206896551727,-33.77949982388165,31,43,60,36,0.12903225806451613,0.13953488372093023,0.05,19.444444444444446,0.8148148148148148,0.7837837837837838,0.7894736842105263,72.41379310344827,-3.1100478468899455,-3.8083538083538047,0.7259528130671536]
["Gwent",0.3178582459971411,0.2761167938178526,0.3307907149728394,0.3361548887291557,4.068627804551168,-13.132096683017599,19.801012607387385,null,177,154,185,188,0.12807881773399016,0.09941520467836257,0.19913419913419914,22.31404958677686,20.33898305084746,36.36363636363637,32.432432432432435,26.595744680851062,59.45945945945945,78.78787878787878,-10.81081081081081,51,46,69,57,0.13725490196078433,0.2608695652173913,0.2463768115942029,17.543859649122805,0.75,0.7941176470588235,0.7307692307692307,72.3404255319149,-2.56410256410257,5.882352941176464,-7.977207977207977]
["West Mercia",0.20471037728717129,0.23187954450056192,0.2637588586741272,0.29493802088161186,28.844889140193246,13.272002901580926,13.748221837432501,null,241,274,313,350,0.20462046204620463,0.14641744548286603,0.13774104683195593,7.651715039577836,21.991701244813278,22.26277372262774,29.073482428115017,21.428571428571427,32.20206160708904,1.2326125877978285,30.592363693500236,48,49,56,81,0.125,0.14285714285714285,0.05357142857142857,17.28395061728395,0.7857142857142857,0.8095238095238095,0.660377358490566,71.64179104477611,-15.951972555746144,3.030303030303034,-18.42397336293008]
["South Yorkshire",0.18170149923066814,0.15534542054004835,0.21037299514535626,0.2256728493377458,15.779449281422803,-14.505152022527357,35.42272080760932,null,235,202,275,295,0.05622489959839357,0.019417475728155338,0.028268551236749116,3.908794788273615,33.191489361702125,37.12871287128713,28,25.08474576271186,-15.641025641025635,11.862147753236869,-24.586666666666666,68,76,72,104,0.25,0.15789473684210525,0.1527777777777778,15.384615384615385,0.8235294117647058,0.859375,0.8032786885245902,71.5909090909091,-2.4590163934426177,4.3526785714285765,-6.527570789865872]
["Avon & Somerset",0.2450466036412774,0.2137449377863107,0.22880627067092268,0.228806270670923,-6.627446668931947,-12.773760333682915,7.046404485924897,null,383,338,365,365,0.18683651804670912,0.25055432372505543,0.21841541755888652,14.519906323185012,25.326370757180154,20.710059171597635,27.945205479452056,33.6986301369863,10.34034740855813,-18.22729213688768,34.93542074363992,94,78,90,104,0.19148936170212766,0.2948717948717949,0.24444444444444444,13.461538461538462,0.6973684210526315,0.6727272727272727,0.75,71.11111111111111,7.547169811320763,-3.533447684391073,11.486486486486486]
["Northumbria",0.1822394440482027,0.1861598364075859,0.23880019956873821,0.24480642534418767,31.036505744373923,2.151231518433661,28.276971110943265,null,255,261,336,193,0.1326530612244898,0.16613418530351437,0.16,6.310679611650485,29.01960784313726,31.800766283524908,29.166666666666668,17.616580310880828,0.5067567567567488,9.583721652687169,-8.28313253012049,80,72,72,37,0.2625,0.2777777777777778,0.25,10.81081081081081,0.847457627118644,0.8076923076923077,0.8518518518518519,69.6969696969697,0.5185185185185239,-4.692307692307686,5.4673721340388]
["Sussex",0.20172240907476655,0.23983411257813245,0.2954582467288781,0.2851590485858235,46.46773657128457,18.893143145658225,23.192753338049272,null,309,370,459,443,0.16260162601626016,0.1590909090909091,0.09467455621301775,9.775967413441954,20.06472491909385,18.37837837837838,20.697167755991288,22.799097065462753,3.1520134935694792,-8.404533565823888,12.616942201717297,71,75,76,115,0.22535211267605634,0.18666666666666668,0.11842105263157894,20,0.8545454545454545,0.7213114754098361,0.6865671641791045,69.56521739130434,-19.657033979040964,-15.591210324380878,-4.816824966078703]
["Nottinghamshire",0.21771396549896255,0.28352600856606486,0.3224615499651835,0.2775973343178536,48.11247832731249,30.22867316585436,13.732617193052402,null,230,301,345,297,0.17266187050359713,0.13505747126436782,0.11538461538461539,14.16184971098266,24.782608695652176,18.6046511627907,25.507246376811594,22.22222222222222,2.9239766081871257,-24.92860057119543,37.101449275362306,80,42,86,91,0.2125,0.16666666666666666,0.23255813953488372,36.26373626373626,0.7936507936507936,0.8285714285714286,0.7727272727272727,68.96551724137932,-2.6363636363636336,4.400000000000013,-6.739811912225714]
["West Midlands",0.318118278453122,0.29327956029562885,0.3405406168094357,0.335964482972792,7.048428171227466,-7.808013509400846,16.114677908739093,null,827,764,893,881,0.09814612868047982,0.12685714285714286,0.07747933884297521,8.229166666666666,24.78839177750907,29.973821989528798,26.651735722284435,18.615209988649262,7.5170021577035495,20.918784318733245,-11.08329217543534,213,220,256,212,0.27230046948356806,0.2727272727272727,0.25,20.28301886792453,0.8451612903225807,0.79375,0.796875,68.63905325443787,-5.713263358778631,-6.083015267175583,0.39370078740158043]
["North Wales",0.22727475289441082,0.25590466737570505,0.26549808177635914,0.3754173757883765,16.81811481264988,12.597050097595025,3.748823536137216,null,153,173,180,255,0.18617021276595744,0.15196078431372548,0.16279069767441862,6.934306569343065,16.99346405228758,17.91907514450867,18.88888888888889,31.372549019607842,11.153846153846155,5.446865273454872,5.412186379928314,20,34,29,50,0.15,0.11764705882352941,0.034482758620689655,18,0.8235294117647058,0.7666666666666667,0.8571428571428571,68.29268292682927,4.081632653061224,-6.904761904761894,11.80124223602483]
["London",0.25269765011061984,0.28623138887599064,0.37348418756104657,0.43268873405291636,47.798836830319445,13.270300990409375,30.48330898567455,null,1907,2176,2864,3318,0.19433882551753273,0.20786312340735347,0.13238412602241745,9.615908471806048,33.29837441006817,33.685661764705884,23.952513966480446,18.565400843881857,-28.067017111687857,1.163081866604913,-28.894037665673334,851,724,894,861,0.3207990599294947,0.3218232044198895,0.27293064876957496,22.99651567944251,0.6695501730103807,0.6924643584521385,0.6261538461538462,67.57164404223228,-6.481415225601276,3.4223253708878616,-9.57601809954751]
["Kent",0.24783573153255725,0.21376552540642854,0.20541882784391793,0.18366859901338545,-17.11492665982555,-13.747092041751468,-3.904604143554571,null,404,351,340,304,0.07126436781609195,0.10230179028132992,0.13705583756345177,29.953917050691242,25.742574257425744,21.937321937321936,29.117647058823533,34.53947368421053,13.110859728506794,-14.781941705018637,32.73109243697481,95,104,92,112,0.24210526315789474,0.22115384615384615,0.13043478260869565,16.964285714285715,0.6805555555555556,0.8395061728395061,0.7375,66.66666666666666,8.367346938775514,23.35600907029477,-12.150735294117638]
["Wiltshire",0.215666859245103,0.2084947611801426,0.24611106069252575,0.25534022546849544,14.116309549824363,-3.3255448194798456,18.041843977020655,null,137,134,160,166,0.20348837209302326,0.2342857142857143,0.22705314009661837,19.024390243902438,21.897810218978105,34.32835820895522,28.75,26.506024096385545,31.29166666666665,56.76616915422883,-16.249999999999996,29,39,44,48,0.2413793103448276,0.23076923076923078,0.22727272727272727,16.666666666666664,0.7272727272727273,0.9333333333333333,0.7941176470588235,65,9.191176470588227,28.333333333333332,-14.915966386554627]
["Bedfordshire",0.1944324108595618,0.2770134571110537,0.24359438531626393,0.18353001633417146,25.28486595386184,42.472880877427386,-12.064060765608284,null,114,164,146,110,0.16176470588235295,0.08888888888888889,0.1978021978021978,24.65753424657534,18.421052631578945,16.463414634146343,19.17808219178082,11.818181818181818,4.109589041095895,-10.627177700348414,16.489091831557566,26,23,28,23,0.2692307692307692,0.21739130434782608,0,4.3478260869565215,0.8421052631578947,0.5,0.7142857142857143,63.63636363636363,-15.178571428571422,-40.62499999999999,42.85714285714286]
["Derbyshire",0.2372036216450828,0.25799405107880663,0.30661336055234345,0.315602025845409,29.261669120345623,8.764802699695549,18.84512812223163,null,235,257,307,316,0.15162454873646208,0.1076388888888889,0.08358208955223881,12.70718232044199,28.085106382978726,23.346303501945524,23.778501628664493,24.050632911392405,-15.33412298884613,-16.873010258224276,1.851248642779585,57,71,74,88,0.21052631578947367,0.22535211267605634,0.10810810810810811,15.909090909090908,0.8444444444444444,0.6909090909090909,0.8636363636363636,63.51351351351351,2.2727272727272743,-18.18181818181818,25]
["South Wales",0.21438577258054692,0.23980873436701394,0.19581061582438677,0.18858809310955282,-8.664360760778223,11.858511635568242,-18.34717098973155,null,264,297,244,235,0.06713780918727916,0.051118210862619806,0.08270676691729323,6.374501992031872,41.66666666666667,39.05723905723906,43.85245901639344,49.787234042553195,5.245901639344242,-6.26262626262627,12.277416619559059,88,99,132,135,0.1590909090909091,0.20202020202020202,0.11363636363636363,28.888888888888886,0.7297297297297297,0.6582278481012658,0.6239316239316239,62.5,-14.498258942703385,-9.798406000937652,-5.210387902695588]
["Merseyside",0.1843863144052177,0.1648362208007049,0.24736508049363404,0.27032411491070785,34.15587880888529,-10.602789945434026,50.06718747374741,null,250,223,334,365,0.08424908424908426,0.09716599190283401,0.037463976945244955,14.719626168224298,20.8,26.905829596412556,21.856287425149702,26.301369863013697,5.078304928604334,29.354949982752665,-18.767465069860272,61,59,77,100,0.21311475409836064,0.11864406779661017,0.15584415584415584,12,0.75,0.7115384615384616,0.7846153846153846,61.36363636363637,4.615384615384613,-5.128205128205124,10.270270270270265]
["Thames Valley",0.1743430951556267,0.2019604855130072,0.271134035132976,0.22980539661186916,55.5175069542899,15.840828300500181,34.251031554147126,null,376,440,597,506,0.2,0.12350597609561753,0.13352685050798258,11.538461538461538,18.882978723404257,18.181818181818183,23.953098827470686,25.296442687747035,26.850213508858833,-3.7131882202304736,31.742043551088763,100,88,105,153,0.15,0.26136363636363635,0.13333333333333333,14.37908496732026,0.6470588235294118,0.7076923076923077,0.7362637362637363,58.778625954198475,13.78621378621379,9.370629370629372,4.037267080745343]
["Dyfed-Powys",0.1418708974832902,0.15281021962996114,0.2545694224628901,0.23680876508175822,79.43738073051502,7.710758401284787,66.59188310791309,null,71,77,129,120,0.14457831325301204,0.10465116279069768,0.06521739130434782,6.25,19.718309859154928,31.16883116883117,28.68217054263566,39.166666666666664,45.45957918050943,58.0705009276438,-7.97803617571059,19,13,33,36,0.21052631578947367,0.15384615384615385,0.21212121212121213,22.22222222222222,0.8,0.5454545454545454,0.8076923076923077,57.14285714285714,0.9615384615384581,-31.818181818181827,48.07692307692309]
["Hampshire",0.3257724914423125,0.3193699504379116,0.3090595919659582,0.31336704272506566,-5.130236565512407,-1.9653412036278894,-3.228343323414146,null,595,588,574,582,0.2119205298013245,0.10229007633587786,0.11145510835913312,11.818181818181818,20.672268907563023,20.408163265306122,20.209059233449477,17.18213058419244,-2.240729724370407,-1.2775842044134633,-0.9756097560975628,117,131,123,112,0.2564102564102564,0.22137404580152673,0.13821138211382114,23.214285714285715,0.735632183908046,0.7058823529411765,0.6886792452830188,56.97674418604651,-6.382665094339628,-4.044117647058816,-2.437106918239006]
["Surrey",0.13713125128560547,0.16956624953369281,0.18533256293130704,0.1789731122424877,35.14976432710581,23.652521175158284,9.298025663109012,null,148,185,204,197,0.20855614973262032,0.21610169491525424,0.2,25.660377358490567,24.324324324324326,12.432432432432433,21.07843137254902,21.31979695431472,-13.344226579520704,-48.888888888888886,69.54390451832906,28,32,28,72,0.21428571428571427,0.21875,0.17857142857142858,8.333333333333332,0.7272727272727273,0.76,0.6521739130434783,54.54545454545454,-10.32608695652174,4.499999999999998,-14.187643020594965]
[]
["TOTAL:",{"$nulls":8},12620,13082,15148,{"$nulls":12},0,0,0]
[]
["National Average",0.23489637263603186,0.24189047036047578,0.27817605462798883,{"$nulls":9},0.15534435446087946,0.14886141834743005,0.12271963861701511,null,25.618066561014263,26.00519798195994,24.973593873778714]

{"sheet":"CHARTS","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}