{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Front Sheet","Index","Dementia population profile","Pop profilfe backing data","Recorded prevalence","QoF Monthly Extracts","Estimated prevalence","Assessments and care plans","ass and care plans raw","Dementia diagnosis rates","diagnosis rate backing data2","Social care support","Hospital activity","Dementia prescribing","End of life","2017-26 dementia projection","End of life 2"],"not_rendered":{"charts":26,"images":56,"macros":1,"external_links":4,"defined_names":16,"comments":2,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Front Sheet","index":0,"n_rows":22,"n_cols":8,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,0,1,12],[2,0,2,12]]}
["Dementia in Lancashire"]
[]
["Data Explorer"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Further information about the data domains can be found here : ",null,null,null,null,null,"Using data to improve dementia care in England"]
[]
[]
["Updated : January 2018"]

{"sheet":"Index","index":1,"n_rows":38,"n_cols":18,"rows_kept":38,"cut":false,"hidden":false,"merged":[[25,1,26,2],[25,3,26,16],[25,17,26,20],[13,1,14,2],[13,3,14,16],[13,17,14,20],[19,3,20,15],[19,17,20,20],[37,1,39,2],[37,3,39,16],[37,17,39,20],[28,1,29,2],[28,3,29,16],[28,17,29,20],[31,1,32,2],[31,3,32,16],[31,17,32,20],[34,1,35,2],[34,3,35,16],[34,17,35,20],[10,1,11,2],[10,3,11,16],[10,17,11,20],[22,1,23,2],[22,3,23,16],[22,17,23,20],[19,1,20,2],[16,1,17,2],[16,3,16,16],[16,17,17,20],[17,3,17,16],[7,1,8,2],[7,3,8,16],[7,17,8,20],[0,0,1,21],[2,0,3,21],[5,1,6,2],[5,3,6,16],[5,17,6,20]]}
["Dementia data tool"]
[]
["Index"]
[]
[]
[null,"Worksheet",null,"Description",null,null,null,null,null,null,null,null,null,null,null,null,null,"Time frame"]
[]
[null,"Population profile",null,"Dementia population profile, looking at the gender, age and ethnicity of dementia patients in Lancashre - Inclues Morecambe Bay CCG",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01"]
[]
[]
[null,"Recorded prevalence",null,"Recorded dementia prevalence as per QoF - Inclues Morecambe Bay CCG",null,null,null,null,null,null,null,null,null,null,null,null,null,"April 2016 to March 2017"]
[]
[]
[null,"QOF monthly extracts",null,"Monthly recorded dementia prevalence, extracted from GP systems by the Office for National Statistics (ONS)  - Inclues Morecambe Bay CCG",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01"]
[]
[]
[null,"Estimated prevalence",null,"CCG and district breakdown of estimated dementia prevalence.",null,null,null,null,null,null,null,null,null,null,null,null,null,2017]
[null,null,null,"Uses the NHS England methodology that combines the Alzheimer's Society 2014 (Delphi) aged 30-64 estimates with the CFAS II 65+ estimates, applying them to the 2017 projected population estimates for the district estimates - Inclues Morecambe Bay CCG"]
[]
[null,"Assessments and care plans",null,"Details of the numbers of patients reciging and declining assessments and care plans - Inclues Morecambe Bay CCG",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01"]
[]
[]
[null,"Dementia diagnosis rates",null,"The dementia diagnosis rates have been calculated using the monthly HSCIC QoF extracts and the CFAS  II estimated aged 65+ dementia prevalence. - Inclues Morecambe Bay CCG",null,null,null,null,null,null,null,null,null,null,null,null,null,"April 2015 to March 2017"]
[]
[]
[null,"Social care support",null,"Total number of individuals who received social care support, who were recorded as having dementia",null,null,null,null,null,null,null,null,null,null,null,null,null,"April 2016 to March 2017"]
[]
[]
[null,"Hospital activity",null,"Detailed breakdown of hospital activity, relating to patients with a recorded dementia diagnoses. Provided by the NHS Midlands and Lancashire Commissioning Support Unit. ",null,null,null,null,null,null,null,null,null,null,null,null,null,"January 2016 to December 2016"]
[]
[]
[null,"Dementia prescribing",null,"CCG breakdown of dementia prescribing figures",null,null,null,null,null,null,null,null,null,null,null,null,null,"April 2016 - March 2017"]
[]
[]
[null,"End of life",null,"End of life analysis of patients, with a recorded dementia diagnoses ",null,null,null,null,null,null,null,null,null,null,null,null,null,"January 2016 to December 2016"]
[]
[]
[null,"Dementia prevalence projections",null,"Dementia projections based on the NHS England estimated prevalence methodology and the ONS population projections",null,null,null,null,null,null,null,null,null,null,null,null,null,"2017 and 2026"]

{"sheet":"Dementia population profile","index":2,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,9],[36,10,36,18],[19,10,19,17],[4,6,5,9],[0,0,1,18],[2,0,2,18],[3,0,3,18],[19,0,19,9]]}
["Dementia in Lancashire"]
[]
["Dementia population profile"]
[{"$f":"B5","v":"NHS Morecambe Bay CCG"}]
[null,"NHS Morecambe Bay CCG",null,null,null,null,"<< Select geography"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Source : Estimated 30+ dementia prevalence by gender calculated using the GP practice list size April 2017",null,null,null,null,null,null,null,null,null,"Source : April 2017 QoF CCG level dementia prevalence by ethnicity"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Source : GP Practice list size April 2017 & Estimated dementia prevalence by age band",null,null,null,null,null,null,null,null,null,"Source : April 2017 QoF CCG level dementia prevalence"]

{"sheet":"Pop profilfe backing data","index":3,"n_rows":86,"n_cols":14,"rows_kept":86,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"England"]
[null,null,null,null,null,null,null,null,null,null,null,"Lancashire-14"]
[null,null,null,null,null,null,null,null,null,null,null,"Lancashire-12"]
["CCG_NAME","Not defined","White","Asian / Asian British","Mixed Or Multiple ethnic groups","Other","Black / African / Caribbean /Black British","Grand Total",null,null,null,"NHS Blackburn with Darwen CCG"]
["NHS Blackburn with Darwen CCG",617,285,96,2,3,0,1003,null,null,null,"NHS Blackpool CCG"]
["NHS Blackpool CCG",1086,696,5,1,6,0,1794,null,null,null,"NHS Chorley and South Ribble CCG"]
["NHS Chorley and South Ribble CCG",1129,255,7,2,0,0,1393,null,null,null,"NHS East Lancashire CCG"]
["NHS East Lancashire CCG",2144,684,85,5,7,0,2925,null,null,null,"NHS Fylde & Wyre CCG"]
["NHS Fylde & Wyre CCG",1505,496,1,2,1,0,2005,null,null,null,"NHS Greater Preston CCG"]
["NHS Greater Preston CCG",1053,395,37,3,3,0,1491,null,null,null,"NHS Morecambe Bay CCG"]
["NHS Morecambe Bay CCG",3179,594,7,1,0,0,3781,null,null,null,"NHS West Lancashire CCG"]
["NHS West Lancashire CCG",771,285,2,1,0,0,1059]
["Lancashire-14",{"$f":"SUM(B5:B12)","v":11484},3690,240,17,20,0,15451]
["Lancashire-12",{"$f":"SUM(B7:B12)","v":9781},2709,139,14,11,0,12654]
["England",333637,94990,9652,1863,1853,10,{"$f":"SUM(B15:G15)","v":442005}]
["April 2017 CCG level dementia prevalence by ethnicity"]
[]
[]
[]
[null,"F.count","Females","M.count","Males"]
["England",424427.35644700006,{"$f":"B21/SUM(B21,D21)","v":0.62989064121184279},249383.82390399999,{"$f":"D21/SUM(B21,D21)","v":0.37010935878815721}]
["Lancashire-14",13918.461762000001,0.62734825868998101,8267.7188310000001,0.37265174131001899]
["Lancashire-12",11473.516222,0.62785895119960866,6800.5184160000008,0.37214104880039139]
["NHS Blackburn with Darwen CCG",996.32225599999992,0.62421020956463336,599.81032999999991,0.37578979043536676]
["NHS Blackpool CCG",1448.6232840000002,0.62548139980102169,867.39008499999989,0.37451860019897831]
["NHS Chorley and South Ribble CCG",1358.758004,0.619680448489207,833.917281,0.38031955151079283]
["NHS East Lancashire CCG",2706.1582880000001,0.62831355732829375,1600.8604869999999,0.3716864426717062]
["NHS Fylde & Wyre CCG",1720.5704600000004,0.63853543188917838,973.987076,0.36146456811082173]
["NHS Greater Preston CCG",1449.7661539999999,0.62445726728908058,871.87574200000006,0.37554273271091937]
["NHS Morecambe Bay CCG",3303.3515149999998,0.62862396059332726,1951.5412700000002,0.37137603940667274]
["NHS West Lancashire CCG",934.91180099999997,0.62192770353534421,568.33655999999996,0.37807229646465584]
["Estimated dementia 30+ prevalence by gender calculated using the GP practice list size April 2017"]
[]
[]
[]
["All persons - dementia estimate calculated using the GP practice list size April 2017","30-34","35-39","40-44","45-49","50-54","55-59","60-64","65-69","70-74","75-79","80-84","85-89","90+"]
["England",5.7681957250625649E-4,4.6499025860150965E-4,7.6673751351361528E-4,1.816510228225072E-3,3.6038242772033816E-3,7.4469184918928349E-3,4.0815164250723589E-2,6.6427277114464056E-2,0.10488404921269738,0.15541546215580629,0.20275683898393071,0.20291262891894679,0.21211277902148848]
["Lancashire-14",4.5706898298662009E-4,3.648288611945132E-4,6.4240205475010032E-4,1.6701516894571328E-3,3.4184186720236532E-3,7.292486839805469E-3,4.0899243391460303E-2,6.8850967546976366E-2,0.10955423308718941,0.16213624444826497,0.20399955643685674,0.1991031751266697,0.20161122286236499]
["Lancashire-12",4.3460282074135354E-4,3.4943449142432341E-4,6.2241717416624273E-4,1.6194776679726681E-3,3.3407902638561255E-3,7.1556136666221853E-3,4.0470865610712323E-2,6.9027120993684091E-2,0.11023865500456757,0.16205529094499463,0.20361447669923147,0.19879610999782985,0.20227514466419716]
["NHS Blackburn with Darwen CCG",7.3300489587272929E-4,5.8376165499825227E-4,9.5421897488909507E-4,2.2897609083710551E-3,4.2039721880598223E-3,8.8331841124381395E-3,4.8148255774035066E-2,7.2967622503009297E-2,0.10804553551041908,0.1605731267239475,0.20017071438951256,0.19724238622868395,0.1952544561357637]
["NHS Blackpool CCG",4.4416626163266325E-4,3.3541257161888172E-4,5.8519308141351224E-4,1.6429671999876956E-3,3.4895480778202714E-3,7.3106508047967996E-3,3.9283451994615845E-2,6.462397929275511E-2,0.10519369329253642,0.16385224933474898,0.20967668257013417,0.20280841479028613,0.2007535907276535]
["NHS Chorley and South Ribble CCG",4.9115799652021876E-4,4.0424727093140919E-4,7.3873774702577538E-4,1.8701702108162356E-3,3.7607200922137448E-3,7.7455271723008449E-3,4.3783500756702336E-2,7.5838862752539302E-2,0.12017967357168435,0.17088987255128385,0.19800241420607789,0.18345032789476626,0.19284478777713771]
["NHS East Lancashire CCG",5.3711908882960455E-4,4.2891106273387438E-4,7.3630001763807021E-4,1.8790881634826403E-3,3.6847355047807981E-3,7.941064524382065E-3,4.4742781507842395E-2,7.4742650732930682E-2,0.11355302253122869,0.1583206472091592,0.19772168278973892,0.19408227446141094,0.20162972240584207]
["NHS Fylde & Wyre CCG",2.7442650235545013E-4,2.2315203589699857E-4,4.1537840073792352E-4,1.1497754115872773E-3,2.5316880077189789E-3,5.7121088692165889E-3,3.3581023522817069E-2,5.9751553956055518E-2,0.10380368437603106,0.15731117051196639,0.20777140310430545,0.21655614779197646,0.21091848750933478]
["NHS Greater Preston CCG",5.7715231720646036E-4,4.5462308455860152E-4,7.8176828352687501E-4,1.9216051397446009E-3,3.8767942702563982E-3,7.9360602648256146E-3,4.3181078086471612E-2,6.7292031673432548E-2,0.10389629874253441,0.1602452129421772,0.20727959847258026,0.20053135705473157,0.20202641966795382]
["NHS Morecambe Bay CCG",3.5894148123899352E-4,2.9007880129375464E-4,5.2142072390540695E-4,1.4077954208917319E-3,3.0288751171923299E-3,6.640290568744686E-3,3.790181991315357E-2,6.6697840344234538E-2,0.10841420050019154,0.16243528363443099,0.20366238547338886,0.2005352046397651,0.20810586338156847]
["NHS West Lancashire CCG",3.8983378608852513E-4,3.1316581625063887E-4,6.0452153055765077E-4,1.6252923092327255E-3,3.4556718202867886E-3,7.228267318895816E-3,4.0544198537795721E-2,7.0164054547736845E-2,0.11394989972651633,0.16984019848201254,0.21540485817300023,0.19409168010395059,0.18238835784767568]
[]
["April 2017 list size","30-34","35-39","40-44","45-49","50-54","55-59","60-64","65-69","70-74","75-79","80-84","85-89","90+"]
["England",0.11406249498018436,0.10894434158012606,0.10207200981039696,0.111609976732893,0.11115701556744212,9.7516750694499513E-2,8.2496976366782243E-2,8.020015170878371E-2,6.9624569490487259E-2,4.9277088504502735E-2,3.695137751570212E-2,2.3022457214162486E-2,1.3064789834037437E-2]
["Lancashire-14",9.7551934362008666E-2,9.2250785396360863E-2,9.2020762243645832E-2,0.11075083980568352,0.11374291019984588,0.10296721019958047,8.9197670396285664E-2,8.9911626874135758E-2,7.8352963450205731E-2,5.5503702045702062E-2,4.0116922537933912E-2,2.4324948399613914E-2,1.3307724088997728E-2]
["Lancashire-12",9.4629483922861288E-2,9.0074057189947154E-2,9.0706359625571761E-2,0.10962502383462387,0.11345828886029952,0.10325049477391626,9.0049948604880012E-2,9.1929322395341351E-2,8.0449252524278439E-2,5.6597095134668367E-2,4.0846518172393917E-2,2.4780337914695059E-2,1.3603817046522994E-2]
["NHS Blackburn with Darwen CCG",0.12342002386333874,0.1165714396577648,0.10932513313996915,0.11959800944833004,0.11022728375061841,9.8004598057951045E-2,8.2832946928322673E-2,7.5450832791719616E-2,6.099702193293044E-2,4.3390534208969121E-2,3.104174144169488E-2,1.8954863367834935E-2,1.0185571410556132E-2]
["NHS Blackpool CCG",9.7553532817186303E-2,8.7710120666806168E-2,8.6925437678733342E-2,0.11175629490130431,0.11916718978865871,0.10517367650136011,8.8137336960312479E-2,8.6855688079793547E-2,7.7273836925437683E-2,5.7691637023087119E-2,4.246878705447444E-2,2.5528353211969033E-2,1.3758108390876753E-2]
["NHS Chorley and South Ribble CCG",9.6696359219289693E-2,9.4209125915153125E-2,9.6778991554975297E-2,0.1145449437273794,0.11556958468988085,0.10092713480639244,8.8143912475830047E-2,9.1457469136822622E-2,7.927746285676511E-2,5.4025021071245599E-2,3.5912013088961969E-2,2.0674610388537244E-2,1.178337106876663E-2]
["NHS East Lancashire CCG",0.1047742816917835,9.8867867942918547E-2,9.6335357675422159E-2,0.11380051483267938,0.11204275277201577,0.10249169020068477,8.9187680670448771E-2,8.946259132448621E-2,7.421754596422829E-2,4.9567223985538034E-2,3.5550945942568662E-2,2.1634635410158365E-2,1.2066911587067537E-2]
["NHS Fylde & Wyre CCG",7.5461072786146693E-2,7.2570275470458495E-2,7.5564315547421282E-2,9.8474822844807353E-2,0.10873339903327232,0.10491341686611291,9.4363883804965035E-2,0.10031442113660895,9.5790511051668303E-2,6.9191421465108635E-2,5.2663193955605613E-2,3.4117039748463092E-2,1.7842226289361302E-2]
["NHS Greater Preston CCG",0.11099600076175967,0.10385831270234241,0.1021215006665397,0.11478194629594363,0.11615311369262997,0.1009026852028185,8.4852409064940015E-2,7.9108741192153872E-2,6.6989144924776228E-2,4.9407731860597978E-2,3.6678727861359742E-2,2.2098647876594935E-2,1.2051037897543325E-2]
["NHS Morecambe Bay CCG",8.5732910456180811E-2,8.2114218617459142E-2,8.3300948966416363E-2,0.10460359445579638,0.1128647419906148,0.10505488627863928,9.2473037402899139E-2,9.7299352730524466E-2,8.6698173521705876E-2,6.2240663900414939E-2,4.4803249301124469E-2,2.7420156865694718E-2,1.5394065512529616E-2]
["NHS West Lancashire CCG",8.5709671775962532E-2,8.1309128100230124E-2,8.8024330834757566E-2,0.11117092142270789,0.11851861820237118,0.1054381030561574,9.1132971779999725E-2,9.3999380963274967E-2,8.4148622643286819E-2,5.9965818406922444E-2,4.366900375459231E-2,2.4478865278768386E-2,1.2434563780968659E-2]
["CCG name","Early onset (<65)","DEMENTIA_REGISTER_65_PLUS","Early onset (<65)"," 65+"]
["England",37390.432351000003,636420.74800000002,{"$f":"B62/SUM(B62:C62)","v":5.549096459266626E-2},{"$f":"C62/SUM(B62:C62)","v":0.94450903540733366}]
["Lancashire-14",{"$f":"SUM(B64:B66)","v":565},{"$f":"SUM(C64:C66)","v":14876},{"$f":"B63/SUM(B63:C63)","v":3.6590894372126155E-2},{"$f":"C63/SUM(B63:C63)","v":0.96340910562787385}]
["Lancashire-12",{"$f":"SUM(B67:B72)","v":445},{"$f":"SUM(C67:C72)","v":12196},3.5202911162091607E-2,0.96479708883790838]
["NHS Blackburn with Darwen CCG",54,953,5.3624627606752732E-2,0.94637537239324732]
["NHS Blackpool CCG",66,1727,3.6809815950920248E-2,0.96319018404907975]
["NHS Chorley and South Ribble CCG",48,1407,3.2989690721649485E-2,0.96701030927835052]
["NHS East Lancashire CCG",121,2716,4.2650687345787801E-2,0.95734931265421219]
["NHS Fylde & Wyre CCG",56,1959,2.7791563275434243E-2,0.97220843672456581]
["NHS Greater Preston CCG",60,1440,0.04,0.96]
["NHS Morecambe Bay CCG",122,3642,3.2412327311370885E-2,0.96758767268862911]
["NHS West Lancashire CCG",38,1032,{"$f":"B72/SUM(B72:C72)","v":3.5514018691588788E-2},{"$f":"C72/SUM(B72:C72)","v":0.96448598130841123}]
["QoF dementia register April 2017"]
[]
[null,"Females","Males"]
[{"$f":"'Dementia population profile'!$B$5","v":"NHS Morecambe Bay CCG"},{"$f":"SUM(IF($A$21:$A$31=$A$76,IF($C$20:$E$20=$B$75,$C$21:$C$31)))","v":0.62862396059332726},{"$f":"SUM(IF($A$21:$A$31=$A$76,IF($B$20:$E$20=C$75,$E$21:$E$31)))","v":0.37137603940667274}]
[]
[null,"Not defined","White","Asian / Asian British","Mixed Or Multiple ethnic groups","Other","Black / African / Caribbean /Black British"]
[{"$f":"'Dementia population profile'!$B$5","v":"NHS Morecambe Bay CCG"},{"$f":"SUM(IF($A$5:$A$15=$A$79,IF($B$4:$G$4=B78,$B$5:$G$15)))","v":3179},{"$f":"SUM(IF($A$5:$A$15=$A$79,IF($B$4:$G$4=C78,$B$5:$G$15)))","v":594},{"$f":"SUM(IF($A$5:$A$15=$A$79,IF($B$4:$G$4=D78,$B$5:$G$15)))","v":7},{"$f":"SUM(IF($A$5:$A$15=$A$79,IF($B$4:$G$4=E78,$B$5:$G$15)))","v":1},{"$f":"SUM(IF($A$5:$A$15=$A$79,IF($B$4:$G$4=F78,$B$5:$G$15)))","v":0},{"$f":"SUM(IF($A$5:$A$15=$A$79,IF($B$4:$G$4=G78,$B$5:$G$15)))","v":0}]
[]
[null,"30-34","35-39","40-44","45-49","50-54","55-59","60-64","65-69","70-74","75-79","80-84","85-89","90+"]
["Estimated prevalence",{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=B81,$B$37:$N$47)))","v":3.5894148123899352E-4},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=C81,$B$37:$N$47)))","v":2.9007880129375464E-4},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=D81,$B$37:$N$47)))","v":5.2142072390540695E-4},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=E81,$B$37:$N$47)))","v":1.4077954208917319E-3},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=F81,$B$37:$N$47)))","v":3.0288751171923299E-3},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=G81,$B$37:$N$47)))","v":6.640290568744686E-3},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=H81,$B$37:$N$47)))","v":3.790181991315357E-2},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=I81,$B$37:$N$47)))","v":6.6697840344234538E-2},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=J81,$B$37:$N$47)))","v":0.10841420050019154},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=K81,$B$37:$N$47)))","v":0.16243528363443099},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=L81,$B$37:$N$47)))","v":0.20366238547338886},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=M81,$B$37:$N$47)))","v":0.2005352046397651},{"$f":"SUM(IF($A$37:$A$47=$A$79,IF($B$36:$N$36=N81,$B$37:$N$47)))","v":0.20810586338156847}]
["% of total registered population",{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=B81,$B$50:$N$60)))","v":8.5732910456180811E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=C81,$B$50:$N$60)))","v":8.2114218617459142E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=D81,$B$50:$N$60)))","v":8.3300948966416363E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=E81,$B$50:$N$60)))","v":0.10460359445579638},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=F81,$B$50:$N$60)))","v":0.1128647419906148},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=G81,$B$50:$N$60)))","v":0.10505488627863928},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=H81,$B$50:$N$60)))","v":9.2473037402899139E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=I81,$B$50:$N$60)))","v":9.7299352730524466E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=J81,$B$50:$N$60)))","v":8.6698173521705876E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=K81,$B$50:$N$60)))","v":6.2240663900414939E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=L81,$B$50:$N$60)))","v":4.4803249301124469E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=M81,$B$50:$N$60)))","v":2.7420156865694718E-2},{"$f":"SUM(IF($A$50:$A$60=$A$79,IF($B$49:$N$49=N81,$B$50:$N$60)))","v":1.5394065512529616E-2}]
[]
[null,"Early onset (<65)"," 65+"]
[{"$f":"'Dementia population profile'!$B$5","v":"NHS Morecambe Bay CCG"},{"$f":"SUM(IF($A$62:$A$72=$A$86,IF($D$61:$E$61=B85,$D$62:$E$72)))","v":3.2412327311370885E-2},{"$f":"SUM(IF($A$62:$A$72=$A$86,IF($D$61:$E$61=C85,$D$62:$E$72)))","v":0.96758767268862911}]

{"sheet":"Recorded prevalence","index":4,"n_rows":462,"n_cols":16,"rows_kept":462,"cut":false,"hidden":false,"merged":[[0,0,1,12],[2,0,2,12]],"read":"row_number_cap"}
["Dementia in Lancashire"]
[]
["Recorded prevalence"]
[]
["Recorded dementia prevalence as per QoF 2016/17"]
[]
["GP Taxonomy's Explained"]
[]
["CCG","Registered Population 2016/17","Dementia Register","Recorded Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["NHS Blackburn With Darwen CCG",173797,1104,{"$f":"C10/B10","v":6.352238531159916E-3},"8/8",1.6550718632621687E-2,1700.8511510000003,{"$f":"(C10-G10)/ABS(C10)","v":-0.54062604257246405},{"$f":"D10-$D$423","v":-1.2378479701612962E-3},{"$f":"(D10-$D$423)/ABS($D$423)","v":-0.16308746546509359},"Significantly below",-9.4086656591484477E-5,-1.4595394096819319E-2,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["P81005 : LITTLE HARWOOD HEALTH CENTRE",11504,90,{"$f":"C12/B12","v":7.82336578581363E-3},{"$f":"RANK(D12,$D$12:$D$38) & \" out of \" & COUNTA($D$12:$D$38)","v":"7 out of 27"},null,null,null,{"$f":"D12-$D$423","v":2.3327928449241777E-4},{"$f":"(D12-$D$423)/ABS($D$423)","v":3.0734733319812715E-2},"",-1.2240461324116853E-3,-0.13529240665454156]
["P81022 : WITTON MEDICAL CENTRE",10214,119,{"$f":"C13/B13","v":1.1650675543371843E-2},{"$f":"RANK(D13,$D$12:$D$38) & \" out of \" & COUNTA($D$12:$D$38)","v":"2 out of 27"},null,null,null,4.0605890420506311E-3,0.53498587155018607,"Significantly above",-3.9397780562933256E-4,-3.2709767082006048E-2]
["P81051 : DARWEN HEALTHCARE",12398,91,7.3398935312147121E-3,"8 out of 27",null,null,null,-2.5019297010650011E-4,-3.2963125000347336E-2,"",2.7591171893799876E-4,3.9058950924602216E-2]
["P81058 : ST GEORGES SURGERY",8943,73,8.1628089008162815E-3,"6 out of 27",null,null,null,5.7272239949506931E-4,7.5456636679354719E-2,"",-4.0470309370051021E-4,-4.7236945096723555E-2]
["P81061 : DR A CALOW'S PRACTICE",4931,59,1.1965118637193267E-2,"1 out of 27",null,null,null,4.375032135872055E-3,0.57641400201572013,"Significantly above",2.3823675890798715E-3,0.24860998445210578]
["P81125 : DR IJ MOODIE'S PRACTICE",9685,95,9.80898296334538E-3,"3 out of 27",null,null,null,2.2188964620241678E-3,0.29234139316303215,"Significantly above",1.1186649999469552E-3,0.12872543958213142]
["P81140 : DARWEN HEALTHLINK",13415,87,6.4852776742452475E-3,"11 out of 27",null,null,null,-1.1048088270759647E-3,-0.14555945138222728,"",1.4421932141064388E-4,2.2743730365795235E-2]
["P81155 : DR TL PHILLIPS' PRACTICE",4349,40,9.1975166704989647E-3,"4 out of 27",null,null,null,1.6074301691777525E-3,0.21178021737933367,"",-5.1352075252329883E-4,-5.2880112613496774E-2]
["P81167 : STEPPING STONE PRACTICE",5198,35,6.7333589842247018E-3,"10 out of 27",null,null,null,-8.5672751709651041E-4,-0.11287453930167715,"",-4.0536376321886371E-4,-5.6783794182793799E-2]
["P81204 : DR DC MATHUR & PTNR",4805,34,7.0759625390218522E-3,"9 out of 27",null,null,null,-5.1412396229936E-4,-6.7736245457791028E-2,"",2.0954556024532257E-4,3.051745341027334E-2]
["P81214 : LIMEFIELD SURGERY",4182,37,8.8474414155906272E-3,"5 out of 27",null,null,null,1.257354914269415E-3,0.1656575210375463,"",-2.117920338867256E-4,-2.3378582202111631E-2]
["P81607 : THE MONTAGUE PRACTICE",6174,37,5.9928733398121152E-3,"13 out of 27",null,null,null,-1.597213161509097E-3,-0.21043411840313928,"",5.1695129117304301E-4,9.4404428438041893E-2]
["P81622 : SHIFA SURGERY",5530,22,3.9783001808318267E-3,"20 out of 27",null,null,null,-3.6117863204893855E-3,-0.47585575208670933,"Significantly below",-2.496409956387613E-4,-5.9045522446733112E-2]
["P81633 : SPRING-FENISCO HEALTHLINK",3126,19,6.0780550223928347E-3,"12 out of 27",null,null,null,-1.5120314789283775E-3,-0.19921136322559393,"",-3.323478140259805E-5,-5.4382597568777549E-3]
["P81643 : DR Z BUX'S PRACTICE",6082,12,1.9730351857941467E-3,"27 out of 27",null,null,null,-5.6170513155270659E-3,-0.74005102768582431,"Significantly below",1.7853955533957046E-5,9.131611565021569E-3]
["P81683 : DR A ALAM'S PRACTICE",8346,20,2.3963575365444525E-3,"25 out of 27",null,null,null,-5.1937289647767601E-3,-0.68427796756633585,"Significantly below",5.7154001829627741E-4,0.31320393002636004]
["P81694 : FAMILY PRACTICE",3488,9,2.5802752293577983E-3,"24 out of 27",null,null,null,-5.0098112719634139E-3,-0.66004666364360298,"Significantly below",-3.1665069149664458E-5,-1.2123197903014393E-2]
["P81704 : DR I TIMSON'S PRACTICE",4963,29,5.8432399758210759E-3,"14 out of 27",null,null,null,-1.7468465255001363E-3,-0.2301484344343192,"",-9.7311928640827442E-4,-0.14276232354719037]
["P81707 : DR N NAGPAL'S PRACTICE",5506,18,3.2691609153650564E-3,"21 out of 27",null,null,null,-4.3209255859561558E-3,-0.56928542055535325,"Significantly below",-2.312075444728212E-4,-6.6052344810445973E-2]
["P81709 : ROMAN ROAD HEALTH CENTRE",4483,14,3.1229087664510374E-3,"22 out of 27",null,null,null,-4.4671777348701744E-3,-0.58855425878118373,"Significantly below",-9.4029665115618602E-4,-0.23141745359010579]
["P81712 : DARWEN HEALTH CENTRE",3333,15,4.5004500450045006E-3,"18 out of 27",null,null,null,-3.0896364563167116E-3,-0.407062087603204,"Significantly below",-4.2137971758959315E-4,-8.5614443797320874E-2]
["P81721 : DR P JAGADESHAM'S PRACTICE",1366,3,2.1961932650073207E-3,"26 out of 27",null,null,null,-5.3938932363138915E-3,-0.710649771300363,"Significantly below",-5.491739278547245E-4,-0.20003660322108341]
["P81724 : PRINGLE STREET SURGERY",1844,8,4.3383947939262474E-3,"19 out of 27",null,null,null,-3.2516917073949648E-3,-0.42841299724699322,"",4.6885361095222846E-4,0.12116516888751161]
["P81734 : THE CORNERSTONE PRACTICE",17830,81,4.5429052159282109E-3,"17 out of 27",null,null,null,-3.0471812853930013E-3,-0.40146858469433466,"Significantly below",-3.4068365403203908E-4,-6.9760920319816372E-2]
["P81771 : DR RC RAUTRAY'S PRACTICE",4838,24,4.9607275733774287E-3,"16 out of 27",null,null,null,-2.6293589279437835E-3,-0.3464201531149993,"Significantly below",-6.0284135305982683E-4,-0.10835515134812368]
["Y02657 : BENTHAM ROAD HEALTH CENTRE",5394,28,5.1909529106414533E-3,"15 out of 27",null,null,null,-2.3991335906797589E-3,-0.31608777979831187,"Significantly below",-1.5452323269649938E-4,-2.8907290679630313E-2]
["Y03362 : THE WATERSIDE SURGERY",1870,5,2.6737967914438501E-3,"23 out of 27",null,null,null,-4.9162897098773625E-3,-0.64772512263484483,"Significantly below",5.3132223332922777E-4,0.24799465240641708]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
["NHS Blackpool CCG",172699,1792,{"$f":"C61/B61","v":1.037643530072554E-2},"2/8",2.1773130758021311E-2,2495.2225580000004,{"$f":"(C61-G61)/ABS(C61)","v":-0.39242330245535734},{"$f":"D61-$D$423","v":2.7863487994043276E-3},{"$f":"(D61-$D$423)/ABS($D$423)","v":0.36710369492090844},"Significantly above",4.1305933685813548E-4,4.1457768767946955E-2,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16",null,null,"G"]
["P81004 : ELIZABETH STREET SURGERY",4678,28,{"$f":"C63/B63","v":5.9854638734501923E-3},{"$f":"RANK(D63,$D$63:$D$83) & \"/\" & COUNTA($D$63:$D$83)","v":"15/21"},null,null,null,{"$f":"D63-$D$423","v":-1.6046226278710199E-3},{"$f":"(D63-$D$423)/ABS($D$423)","v":-0.21141032155453063},"",7.5861879713825381E-4,0.14513894826849072,null,null,"G"]
["P81016 : WATERLOO MEDICAL CENTRE",11518,116,1.0071192915436707E-2,"9/21",null,null,null,2.4811064141154948E-3,0.32688776520315105,"Significantly above",8.0863502444988855E-4,8.7301481293493743E-2,null,null,"G"]
["P81042 : ADELAIDE STREET SURGERY",10862,79,7.2730620511876265E-3,"11/21",null,null,null,-3.1702445013358574E-4,-4.1768226235419197E-2,"",-3.3714676551770996E-4,-4.4301907298211277E-2,null,null,"G"]
["P81043 : SOUTH KING STREET MEDICAL CENTRE",5967,36,6.0331825037707393E-3,"14/21",null,null,null,-1.5569039975504729E-3,-0.2051233536375984,"",-2.6453830767106763E-3,-0.30481800848060564,null,null,"G"]
["P81054 : MARTON MEDICAL PRACTICE",8897,58,6.5190513656288637E-3,"13/21",null,null,null,-1.0710351356923485E-3,-0.14110974038384314,"",4.7227441183536698E-4,7.8103494712018717E-2,null,null,"G"]
["P81063 : ST PAULS MEDICAL CENTRE",11155,128,1.1474675033617212E-2,"6/21",null,null,null,3.8845885322959994E-3,0.51179766286191941,"Significantly above",-2.7631169045885633E-4,-2.3513913933094124E-2,null,null,"G"]
["P81066 : LAYTON MEDICAL CENTRE",6557,37,5.6428244624065881E-3,"18/21",null,null,null,-1.9472620389146241E-3,-0.2565533394877203,"",-1.4204107855651359E-4,-2.4553911849931376E-2,null,null,"G"]
["P81072 : GLENROYD MEDICAL CENTRE",15668,210,1.3403114628542252E-2,"5/21",null,null,null,5.8130281272210397E-3,0.76587113021823416,"Significantly above",2.2367814458145677E-3,0.20031476843933582,null,null,"G"]
["P81073 : CLEVELEYS GROUP PRACTICE",11258,279,2.4782376976372356E-2,"1/21",null,null,null,1.7192290475051143E-2,2.2650980950030632,"Significantly above",3.3317316391609404E-3,0.15532081141546045,null,null,"G"]
["P81074 : HIGHFIELD SURGERY",13587,137,1.0083167733863252E-2,"8/21",null,null,null,2.4930812325420397E-3,0.3284654571602138,"Significantly above",2.5444763557605152E-4,2.5888175981366359E-2,null,null,"G"]
["P81081 : ARNOLD MEDICAL CENTRE",4540,36,7.9295154185022032E-3,"10/21",null,null,null,3.39428917180991E-4,4.4720032785121266E-2,"",-5.7540848481024004E-4,-6.7655923950846131E-2,null,null,"G"]
["P81092 : THE CRESCENT SURGERY",8635,117,1.3549507817023741E-2,"4/21",null,null,null,5.9594213157025287E-3,0.78515855052049377,"Significantly above",-4.7737704562967817E-4,-3.4033005211349138E-2,null,null,"G"]
["P81115 : BLOOMFIELD MEDICAL CENTRE",12372,70,5.6579372777238925E-3,"17/21",null,null,null,-1.9321492235973197E-3,-0.25456221391692824,"Significantly below",-7.7481126028780371E-4,-0.12044793228110402,null,null,"G"]
["P81159 : STONYHILL MEDICAL PRACTICE",8563,122,1.4247343220833819E-2,"3/21",null,null,null,6.6572567195126069E-3,0.87709892612604257,"Significantly above",1.7738200389086599E-3,0.14220681783628106,null,null,"G"]
["P81172 : NEWTON DRIVE HEALTH CENTRE",8871,53,5.9745237290046221E-3,"16/21",null,null,null,-1.6155627723165901E-3,-0.21285169438258283,"",-1.3523493506455786E-3,-0.18457387427682076,null,null,"G"]
["P81681 : NORTH SHORE SURGERY",12936,196,1.5151515151515152E-2,"2/21",null,null,null,7.5614286501939397E-3,0.99622430506921311,"Significantly above",8.6241749619029272E-4,6.0354930520676454E-2,null,null,"G"]
["P81684 : HARROWSIDE MEDICAL CENTRE",4539,49,1.0795329367702137E-2,"7/21",null,null,null,3.205242866380925E-3,0.42229332509227474,"Significantly above",-2.9606371126858141E-4,-2.6693104207975299E-2,null,null,"G"]
["P81713 : THE SURGERY DINMORE",2160,5,2.3148148148148147E-3,"20/21",null,null,null,-5.2752716865063975E-3,-0.69502128672553687,"Significantly below",1.8624946785866315E-4,8.7499999999999953E-2,null,null,"G"]
["P81714 : ABBEY DALE MEDICAL CENTRE",3962,27,6.8147400302877338E-3,"12/21",null,null,null,-7.7534647103347839E-4,-0.10215252104156036,"",1.6291505106370788E-3,0.31416881426180299,null,null,"G"]
["P81754 : VICARAGE LANE SURGERY",2016,5,2.48015873015873E-3,"19/21",null,null,null,-5.1099277711624822E-3,-0.67323709292021816,"Significantly below",-1.2327125569699827E-3,-0.33201058201058203,null,null,"G"]
["P81760 : GORTON MEDICAL CENTRE",3958,4,1.0106114199090451E-3,"21/21",null,null,null,-6.5794750814121674E-3,-0.86685113275940573,"Significantly below",-5.5719626234859796E-4,-0.35539834933468073,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
[null,null,null,null,null,null,null,null,null,null,null,null,"G"]
["NHS Chorley And South Ribble CCG",181931,1452,{"$f":"C106/B106","v":7.981047759865004E-3},"5/8",1.9259500796693724E-2,2320.7313270000004,{"$f":"(C106-G106)/ABS(C106)","v":-0.59829981198347137},{"$f":"D106-$D$423","v":3.9096125854379184E-4},{"$f":"(D106-$D$423)/ABS($D$423)","v":5.1509460198607346E-2},"No significant difference",1.1053575942002875E-4,1.4044290817900968E-2,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["P81010 : WITHNELL HEALTH CENTRE",5272,21,4.4876589379207179E-3,{"$f":"RANK(D108,$D$108:$D$138) & \"/\" & COUNTA($D$108:$D$138)","v":"30/31"},null,null,null,{"$f":"D108-$D$423","v":-3.1024275634004943E-3},{"$f":"(D108-$D$423)/ABS($D$423)","v":-0.40874732624726379},"Significantly below",-1.1390596296798504E-3,-0.22236975214972188]
["P81033 : COPPULL MEDICAL PRACTICE",8005,92,1.1737688185761675E-2,{"$f":"RANK(D109,$D$108:$D$138) & \"/\" & COUNTA($D$108:$D$138)","v":"4/31"},null,null,null,4.1476016844404625E-3,0.54644985715491989,"Significantly above",1.1222592557279115E-3,0.10821590164683653]
["P81038 : THE CHORLEY SURGERY",8680,62,7.4654721911160881E-3,"19/31",null,null,null,-1.2461431020512406E-4,-1.6418035576199606E-2,"",4.6533271288970966E-5,6.5573770491802359E-3]
["P81044 : LIBRARY HOUSE SURGERY",16492,178,8.84580430172675E-3,"14/31",null,null,null,1.2557178004055378E-3,0.16544182996952064,"Significantly above",8.2254300885642798E-4,8.2497099725606454E-2]
["P81057 : WORDEN MEDICAL CENTRE",12514,78,5.3066958014671454E-3,"26/31",null,null,null,-2.2833906998540668E-3,-0.30083856085916744,"",7.4637779732501189E-4,0.13603546636462827]
["P81062 : REGENT HOUSE SURGERY",8225,78,9.4271211022480053E-3,"11/31",null,null,null,1.8370346009267931E-3,0.24203078589513033,"Significantly above",-7.3196723402037603E-4,-7.1654363873208948E-2]
["P81076 : SANDY LANE SURGERY",11577,85,8.0130966741340688E-3,"18/31",null,null,null,4.2301017281285661E-4,5.573193042519646E-2,"",-7.5114649516297774E-4,-9.2811014794814808E-2]
["P81082 : THE RYAN MEDICAL CENTRE",10422,77,8.2336045955002397E-3,"17/31",null,null,null,6.4351809417902747E-4,8.478402638323157E-2,"",2.7651611386917546E-4,3.8881852491524323E-2]
["P81083 : ROSLEA SURGERY",8490,89,9.9710144927536229E-3,"9/31",null,null,null,2.3809279914324107E-3,0.31368917745772207,"Significantly above",1.0180928527327281E-3,0.10756590905786034]
["P81117 : CENTRAL PARK SURGERY",4330,24,5.6179775280898875E-3,"25/31",null,null,null,-1.9721089732313247E-3,-0.25982694306422438,"",-2.6717489650863926E-4,-4.5986143187066987E-2]
["P81127 : THE SURGERY CHORLEY",3819,26,1.0693857249440438E-2,"7/31",null,null,null,3.1037707481192259E-3,0.40892429191405794,"",-1.4563978714517891E-3,-0.17622414244566648]
["P81143 : WHITTLE SURGERY",9511,60,6.8034798126254742E-3,"20/31",null,null,null,-7.8660668869573805E-4,-0.10363606377329333,"",-6.6875853991845736E-4,-9.5848531659697672E-2]
["P81154 : GRANVILLE HOUSE MED CTRE",8302,78,8.785654110001203E-3,"15/31",null,null,null,1.1955676086799908E-3,0.15751699384083137,"",2.86752222849046E-4,3.1481570705853931E-2]
["P81171 : THE EUXTON MEDICAL CENTRE",4249,15,4.7125353440150798E-3,"27/31",null,null,null,-2.8775511573061324E-3,-0.37911967891343989,"Significantly below",-2.3417860099361927E-5,-6.5897858319604466E-3]
["P81173 : CROSTON MEDICAL CENTRE",3942,34,8.9820359281437123E-3,"12/31",null,null,null,1.3919494268225001E-3,0.1833904562985155,"",1.122942658533712E-4,1.3191273465246017E-2]
["P81180 : CLAYTON BROOK SURGERY",3393,45,1.1562407352505188E-2,"5/31",null,null,null,3.9723208511839763E-3,0.5233564664240008,"Significantly above",1.1860162588921922E-3,9.8207931681438834E-2]
["P81181 : KINGSFOLD MEDICAL CENTRE",4164,52,1.2133468149646108E-2,"3/31",null,null,null,4.5433816483248955E-3,0.59859418565704425,"Significantly above",2.1048031927083516E-3,0.20271259320250673]
["P81186 : MOSS SIDE MEDICAL CENTRE",4420,28,5.7763401109057304E-3,"23/31",null,null,null,-1.8137463904154818E-3,-0.23896254543340997,"",1.9760437395350966E-3,0.45334603477018354]
["P81642 : MEDICARE UNIT SURGERY",2689,12,5.7020669992872419E-3,"24/31",null,null,null,-1.8880195020339703E-3,-0.24874808761472234,"",-1.3981803494633547E-3,-0.2385645221271849]
["P81655 : CROSTON VILLAGE SURGERY",3309,21,8.5578446909667198E-3,"16/31",null,null,null,9.6775818964550762E-4,0.12750291969360944,"",-1.71362679403219E-4,-2.6291931097008173E-2]
["P81687 : NEW LONGTON SURGERY",1681,13,1.1056511056511056E-2,"6/31",null,null,null,3.4664245551898438E-3,0.45670422261807431,"",-2.6260448986975262E-3,-0.2534905693389789]
["P81689 : EAVES LANE SURGERY",2062,13,8.9418777943368107E-3,"13/31",null,null,null,1.3517912930155985E-3,0.17809958987691263,"",1.4193608303793917E-3,0.29054316197866148]
["P81692 : BEECHES MEDICAL CENTRE",1810,18,1.2377850162866449E-2,"2/31",null,null,null,4.7877636615452366E-3,0.63079171241484888,"",-1.1185553182313651E-3,-0.10110497237569062]
["P81701 : PRESTON ROAD SURGERY",3243,48,1.2805241215008934E-2,"1/31",null,null,null,5.2151547136877223E-3,0.68710082721454047,"Significantly above",2.534934063630364E-3,0.20666049953746543]
["P81733 : ECCLESTON HEALTH CENTRE",4682,23,4.6598322460391422E-3,"28/31",null,null,null,-2.93025425528207E-3,-0.38606335445215262,"Significantly below",5.0714424160765593E-4,0.11512174284493788]
["P81740 : ADLINGTON MEDICAL CENTRE",1799,7,4.608294930875576E-3,"29/31",null,null,null,-2.9817915704456362E-3,-0.39285343716788912,"",-1.6706846777439699E-3,-0.30038910505836575]
["P81741 : STATION SURGERY",2669,13,5.7971014492753624E-3,"22/31",null,null,null,-1.7929850520458498E-3,-0.23622722240830107,"",-7.1169583703950198E-4,-0.1274884476083428]
["P81769 : LOSTOCK HALL VILLAGE SURGERY",1435,5,1.011904761904762E-2,"8/31",null,null,null,2.5289611177264073E-3,0.33319266088551019,"",-1.6289007719462569E-3,-0.31856645097063219]
["Y00347 : DR R BAGHDJIAN SURGERY",5272,35,4.3763676148796497E-3,"31/31",null,null,null,-3.2137188864415625E-3,-0.42341004755112449,"",1.046868334087279E-3,0.18720893726126306]
["Y02466 : BUCKSHAW VILLAGE HEALTH CENTRE",10049,79,6.0653492467227545E-3,"21/31",null,null,null,-1.5247372545984577E-3,-0.20088535938728044,"",-8.7842610262705255E-4,-0.1005075131853915]
["Y03656 : LEYLAND SURGERY",5424,43,9.7847358121330719E-3,"10/31",null,null,null,2.1946493108118597E-3,0.28914681149283811,"",-1.3205988165762902E-3,-0.14279325927320652]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS East Lancashire CCG",378849,2981,{"$f":"C153/B153","v":7.8685703274919555E-3},"6/8",1.9187523444288482E-2,4593.032612,{"$f":"(C153-G153)/ABS(C153)","v":-0.54076907480711167},{"$f":"D153-$D$423","v":2.7848382617074331E-4},{"$f":"(D153-$D$423)/ABS($D$423)","v":3.6690468036466702E-2},"No significant difference",1.489277981755327E-5,1.8962810386789126E-3,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["P81003 : ST JAMES' MEDICAL CENTRE",10654,71,7.401239707651032E-3,{"$f":"RANK(D155,$D$155:$D$211) & \"/\" & COUNTA($D$155:$D$211)","v":"26/57"},null,null,null,{"$f":"D155-$D$423","v":-1.8884679367018025E-4},{"$f":"(D155-$D$423)/ABS($D$423)","v":-2.4880716924281107E-2},"",-7.3707601326394694E-4,-9.958818284212502E-2]
["P81008 : YORKSHIRE STREET MEDICAL CENTRE",5895,50,8.5786375105130364E-3,"18/57",null,null,null,9.8855100919182422E-4,0.13024239038906163,"",-9.6873303557990301E-5,-1.1292388032397105E-2]
["P81017 : WHALLEY MEDICAL CENTRE",12603,66,4.6665057526751952E-3,"49/57",null,null,null,-2.923580748646017E-3,-0.38518411458645524,"Significantly below",5.7034261676065356E-4,0.12222048937445108]
["P81020 : ST. NICHOLAS GROUP PRACTICE",8989,78,8.9671205579541675E-3,"16/57",null,null,null,1.3770340566329553E-3,0.18142534428207821,"",-2.8984833634998486E-4,-3.2323457064807576E-2]
["P81025 : THE RICHMOND HILL PRACTICE",10466,130,1.1601150527325023E-2,"5/57",null,null,null,4.011064026003811E-3,0.52846091086124014,"Significantly above",8.2002279581657768E-4,7.0684609589809141E-2]
["P81027 : IRWELL MEDICAL PRACTICE",14234,93,6.9274368483661043E-3,"32/57",null,null,null,-6.6264965295510792E-4,-8.7304624636327918E-2,"",-3.937850287791993E-4,-5.6844261073571087E-2]
["P81028 : MANCHESTER ROAD SURGERY",4720,40,6.9974554707379136E-3,"30/57",null,null,null,-5.9263103058329863E-4,-7.8079614834447392E-2,"",1.4771208004485271E-3,0.21109399075500768]
["P81032 : REEDYFORD HLTH CARE GROUP",11341,107,8.4465662871832537E-3,"21/57",null,null,null,8.5647978586204151E-4,0.11284190051232662,"Significantly above",9.8822782268360131E-4,0.11699758092032375]
["P81035 : COLNE ROAD SURGERY",4305,26,6.5581184984170055E-3,"37/57",null,null,null,-1.0319680029042067E-3,-0.13596261422377351,"",-5.1862953209877091E-4,-7.9082061756578101E-2]
["P81036 : PEEL HOUSE MEDICAL PRACTICE",14937,169,1.1518395555254421E-2,"6/57",null,null,null,3.9283090539332091E-3,0.51755787674480458,"Significantly above",-2.0420930634232337E-4,-1.7728971484155004E-2]
["P81047 : PARKSIDE SURGERY",10092,104,9.1352009744214372E-3,"15/57",null,null,null,1.545114473100225E-3,0.20357007431091409,"Significantly above",1.1699912570490353E-3,0.12807504293830105]
["P81053 : BRIERCLIFFE SURGERY",7630,54,7.8175895765472316E-3,"23/57",null,null,null,2.2750307522601942E-4,2.9973713104115188E-2,"",-7.4026323316584222E-4,-9.4692005242463975E-2]
["P81065 : THE PENDLE MEDICAL PARTNERSHIP",11660,99,8.644109656705359E-3,"17/57",null,null,null,1.0540231553841468E-3,0.13886839829831613,"",-1.535436189695101E-4,-1.7762803234501325E-2]
["P81069 : PENDLESIDE MEDICAL PRACT",10190,115,1.2143290831815421E-2,"3/57",null,null,null,4.5532043304942092E-3,0.59988833193160962,"Significantly above",-8.5771673956811997E-4,-7.0632973503434685E-2]
["P81070 : PENDLE VIEW MEDICAL CTRE",7249,77,1.0057683774589557E-2,"9/57",null,null,null,2.4675972732683448E-3,0.32510792503337194,"Significantly above",5.6447100538009436E-4,5.6123359814335562E-2]
["P81078 : BARNOLDSWICK MED CTR",11608,83,7.168149235685292E-3,"27/57",null,null,null,-4.2193726563592021E-4,-5.5590574041873342E-2,"",-1.7908022728710046E-5,-2.4982770503100436E-3]
["P81088 : WHITWORTH MEDICAL CENTRE",7201,34,5.07399577167019E-3,"47/57",null,null,null,-2.5160907296510222E-3,-0.33149697690705426,"Significantly below",-3.5242932256589893E-4,-6.9457945655695921E-2]
["P81095 : THURSBY SURGERY",7700,103,1.0506960861570791E-2,"8/57",null,null,null,2.9168743602495792E-3,0.38430054252238582,"Significantly above",2.8696625150525859E-3,0.27312012987012985]
["P81099 : DR THM MACKENZIE & PARTNERS",10214,95,1.0030787565796008E-2,"10/57",null,null,null,2.4407010644747961E-3,0.32156432789665063,"Significantly above",-7.2982809839831908E-4,-7.2758803195769051E-2]
["P81100 : THE CASTLE MEDICAL GROUP",14524,106,8.4610583258200988E-3,"20/57",null,null,null,8.709718244988866E-4,0.1147512382562802,"",-1.162793385032437E-3,-0.13742883458018612]
["P81104 : OXFORD ROAD MEDICAL CTRE",4515,48,9.2802172928927121E-3,"13/57",null,null,null,1.6901307915714999E-3,0.22267609088213916,"Significantly above",1.3510119429876871E-3,0.14557977473462441]
["P81118 : ILEX VIEW MEDICAL PRACTICE",7562,100,1.4092140921409214E-2,"1/57",null,null,null,6.5020544200880019E-3,0.85665089837331687,"Significantly above",-8.6812611051262541E-4,-6.1603564380607455E-2]
["P81123 : ELMS FEDERATED PRACTICE",19623,125,6.7560854446100348E-3,"35/57",null,null,null,-8.3400105671117743E-4,-0.10988030987077713,"Significantly below",-3.8600951330493381E-4,-5.713508457961998E-2]
["P81130 : PADIHAM GROUP PRACTICE",12843,108,7.7325626806217292E-3,"25/57",null,null,null,1.4247617930051703E-4,1.8771351192864019E-2,"",6.7668749457098359E-4,8.7511414070629318E-2]
["P81132 : DR DM DOHERTY & PARTNERS",9014,60,5.9210526315789476E-3,"40/57",null,null,null,-1.6690338697422646E-3,-0.2198965544663733,"",7.3525977134982975E-4,0.12417720582797125]
["P81134 : KIDDROW MEDICAL PRACTICE",4080,33,6.9084628670120895E-3,"33/57",null,null,null,-6.8162363430912271E-4,-8.9804461937353669E-2,"",1.1797724271055583E-3,0.17077205882352958]
["P81137 : BURNLEY WOOD MEDICAL CENTRE",5878,64,1.0973936899862825E-2,"7/57",null,null,null,3.3838503985416128E-3,0.44582501107893613,"Significantly above",-8.5879737562723213E-5,-7.8257910854031536E-3]
["P81146 : MYRTLE HOUSE",4925,58,1.3002364066193853E-2,"2/57",null,null,null,5.4122775648726409E-3,0.71307192137145226,"Significantly above",-1.225714320000959E-3,-9.4268574065528313E-2]
["P81147 : BLACKBURN RD MEDICAL CENTRE",3741,19,5.100671140939597E-3,"46/57",null,null,null,-2.4894153603816152E-3,-0.32798247555522336,"",-2.181522006282615E-5,-4.2769313017909164E-3]
["P81160 : OSWALD MEDICAL CENTRE",8976,66,8.5743683548645255E-3,"19/57",null,null,null,9.8428185354331333E-4,0.12967992569939468,"",-1.2214271783939374E-3,-0.14245098039215692]
["P81165 : IGHTENHILL MEDICAL CENTRE",2239,17,6.7506750675067504E-3,"36/57",null,null,null,-8.3941143381446176E-4,-0.11059313140480609,"",8.4200023396712158E-4,0.12472830132499628]
["P81166 : DR BELLO'S SURGERY",2475,17,8.1135902636916835E-3,"22/57",null,null,null,5.2350376237047126E-4,6.8972041659781422E-2,"",-1.2449033950048148E-3,-0.15343434343434342]
["P81170 : DR MALIK & PARTNER",5742,15,3.1049873859887445E-3,{"$f":"RANK(D187,$D$155:$D$211) & \"/\" & COUNTA($D$155:$D$211)","v":"54/57"},null,null,null,{"$f":"D187-$D$423","v":-4.4850991153324677E-3},{"$f":"(D187-$D$423)/ABS($D$423)","v":-0.59091541506829248},"Significantly below",-4.9265718745164933E-4,-0.15866640543364682]
["P81182 : RICHMOND MEDICAL CENTRE",6039,26,4.8875855327468231E-3,"48/57",null,null,null,-2.7025009685743891E-3,-0.35605667578412481,"Significantly below",-5.8223696510317346E-4,-0.11912568306010929]
["P81197 : ROSEGROVE SURGERY",4470,30,7.8142442509488725E-3,"24/57",null,null,null,2.241577496276603E-4,2.9532963766439418E-2,"",-1.1028348549757183E-3,-0.14113135186960693]
["P81212 : DR MOUJAES",4994,40,9.2406588991562882E-3,"14/57",null,null,null,1.650572397835076E-3,0.21746424069709344,"",-1.2310473653156795E-3,-0.1332207344465533]
["P81215 : ROSEHILL SURGERY",6302,37,6.2356416147029865E-3,"38/57",null,null,null,-1.3544448866182257E-3,-0.17844920296790509,"",-3.6448959946972729E-4,-5.8452621557066264E-2]
["P81218 : THE CLAYTON MEDICAL CTR.",6600,79,1.16243961352657E-2,"4/57",null,null,null,4.0343096339444879E-3,0.5315235384000212,"Significantly above",3.4530083443127038E-4,2.9704840613931624E-2]
["P81620 : SLAIDBURN HEALTH CENTRE",1053,8,5.6980056980056983E-3,"41/57",null,null,null,-1.8920808033155139E-3,-0.24928316732439848,"",1.8993352326685661E-3,0.33333333333333331]
["P81659 : THE ROYLE",3918,23,9.9038741625400526E-3,"11/57",null,null,null,2.3137876612188404E-3,0.30484338496222374,"",4.4678829222195501E-4,8.2379250832543327E-2]
["P81686 : ROSSENDALE VALLEY MEDICAL PRACTICE",2589,9,5.4235537190082646E-3,"43/57",null,null,null,-2.1665327823129476E-3,-0.28544243625363397,"Significantly below",-8.6129377748372449E-4,-0.19856736542715686]
["P81699 : HIGHER HEYS SURGERY",2292,18,4.3375394321766561E-3,"51/57",null,null,null,-3.2525470691445561E-3,-0.42852569184532779,"",2.5295344634553114E-3,0.47513089005235604]
["P81711 : DILL HALL SURGERY",2578,20,5.3238686779059448E-3,"44/57",null,null,null,-2.2662178234152675E-3,-0.29857602057905203,"",7.9739505615065206E-4,0.11455908973364369]
["P81726 : KING STREET MEDICAL CTR",2081,14,6.9605568445475635E-3,"31/57",null,null,null,-6.2952965677364869E-4,-8.2941038506486847E-2,"",-1.4531739465727372E-4,-2.1143680922633325E-2]
["P81730 : GREAT HARWOOD MEDICAL GROUP",8354,49,6.8728522336769758E-3,"34/57",null,null,null,-7.1723426764423639E-4,-9.449619151499615E-2,"",3.9707516799137015E-4,7.2612963329204472E-2]
["P81731 : DR JEHANGIR (SH)",2742,10,5.4683785068949118E-3,"42/57",null,null,null,-2.1217079944263004E-3,-0.27953673440440674,"Significantly below",1.07910800873133E-3,0.42023549025737222]
["P81732 : HARAMBEE SURGERY",4125,25,2.5678650036683784E-3,"56/57",null,null,null,-5.0222214976528342E-3,-0.66168172085767563,"",-1.0229308226377106E-3,-0.14440961337513059]
["P81736 : WHITEFIELD HEALTHCARE",3700,19,7.0835368832437712E-3,"28/57",null,null,null,-5.0654961807744103E-4,-6.6738319515761188E-2,"",5.2559066658849733E-4,0.11402225755166931]
["P81738 : RISHTON & GREAT HARWOOD SURGERY",1080,6,4.6095444685466374E-3,"50/57",null,null,null,-2.9805420327745748E-3,-0.39268880957493035,"",3.875968992248062E-4,7.4999999999999997E-2]
["P81749 : ABBEY SURGERY",1494,5,5.1679586563307496E-3,"45/57",null,null,null,-2.4221278449904626E-3,-0.31911729129422189,"",-7.3491243887113117E-4,-0.18005354752342712]
["P81755 : CABIN SURGERY",4489,31,4.0816326530612249E-3,"52/57",null,null,null,-3.5084538482599873E-3,-0.46224161577727318,"",-1.6918059508917293E-4,-2.3912619737135286E-2]
["P81756 : DANESHOUSE MEDICAL CENTRE",3293,6,7.0749502542560251E-3,"29/57",null,null,null,-5.1513624706518713E-4,-6.7869614789701924E-2,"Significantly below",-2.4957205626973604E-4,-0.12047199687649117]
["P81757 : BARROWFORD SURGERY",3260,29,2.0716188221367266E-3,"57/57",null,null,null,-5.5184676791844856E-3,-0.72706255432317957,"",2.938005193798875E-3,0.49314417177914116]
["P81778 : DR A K JHA (SH)",2832,28,5.9577003276735183E-3,"39/57",null,null,null,-1.6323861736476939E-3,-0.21506819103623431,"",4.1664437297251299E-4,4.3994559531282756E-2]
["P81780 : RIVERSIDE FAMILY PRACTICE",4463,14,9.470361276745002E-3,"12/57",null,null,null,1.8802747754237898E-3,0.24772771365602866,"Significantly below",1.0942322325019653E-4,3.6143332356641841E-2]
["Y02605 : AVHAC REGISTERED PATIENTS",2564,12,3.0274802049371215E-3,"55/57",null,null,null,-4.5626062963840912E-3,-0.60112704849804743,"",1.2385046071058904E-3,0.35985439417576703]
["Y02606 : FAIRMORE MEDICAL PRACTICE",5712,13,3.4416826003824093E-3,"53/57",null,null,null,-4.1484039009388029E-3,-0.54655554982366628,"Significantly below",-5.5809773302033369E-4,-0.19692877150860344]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS  Fylde & Wyre CCG",151112,1982,{"$f":"C228/B228","v":1.311609931706284E-2},"1/8",2.7159174269379173E-2,2892.9680840000001,{"$f":"(C228-G228)/ABS(C228)","v":-0.4596206276488396},{"$f":"D228-$D$423","v":5.5260128157416282E-3},{"$f":"(D228-$D$423)/ABS($D$423)","v":0.7280566321318882},"Significantly above",9.2924322770160037E-4,7.6249626719790506E-2,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["P81031 : POPLAR HOUSE SURGERY",7426,101,{"$f":"C230/B230","v":1.3600861836789657E-2},{"$f":"RANK(D230,$D$230:$D$248) & \"/\" & COUNTA($D$230:$D$248)","v":"8/19"},null,null,null,{"$f":"D230-$D$423","v":6.010775335468445E-3},{"$f":"(D230-$D$423)/ABS($D$423)","v":0.79192448392019577},"Significantly above",-8.7154692135962136E-5,-6.3672258103857626E-3]
["P81037 : ANSDELL MEDICAL CENTRE",9145,148,{"$f":"C231/B231","v":1.6183706943685074E-2},"6/19",null,null,null,8.5936204423638606E-3,1.1322164037087012,"Significantly above",6.1407309852239828E-4,3.9440432872683416E-2]
["P81077 : HOLLAND HOUSE SURGERY",10859,195,1.7957454645915829E-2,"5/19",null,null,null,1.0367368144594616E-2,1.3659090898094455,"Significantly above",3.5602783501699625E-3,0.24729004334148269]
["P81079 : THE THORNTON PRACTICE",12766,133,1.0418298605671315E-2,"13/19",null,null,null,2.8282121043501024E-3,0.3726192190112449,"Significantly above",2.9064800961687773E-4,2.8698463366233166E-2]
["P81086 : BROADWAY MEDICAL CENTRE",10261,107,1.0427833544488842E-2,"12/19",null,null,null,2.8377470431676299E-3,0.37387545486782808,"Significantly above",6.0228712379503842E-4,6.129807931358891E-2]
["P81087 : THE OVER-WYRE MED.CTR.",11208,230,2.0521056388294077E-2,"2/19",null,null,null,1.2930969886972864E-2,1.7036656808485595,"Significantly above",1.4528786584865581E-3,7.6193891155912991E-2]
["P81089 : THE MOUNT VIEW PRACTICE",11679,105,8.9904957616234269E-3,"15/19",null,null,null,1.4004092603022147E-3,0.18450504616231242,"",-1.6193622166556041E-3,-0.15262807664068961]
["P81128 : KIRKHAM HEALTH CENTRE",8808,67,7.6067211625794736E-3,"17/19",null,null,null,1.6634661258261435E-5,2.1916299972820899E-3,"",8.3833754436219744E-4,0.12386081990178432]
["P81129 : ASH TREE HOUSE SURGERY",10699,67,6.2622675016356672E-3,"18/19",null,null,null,-1.327818999685545E-3,-0.17494122095372833,"",3.1983481825590895E-4,5.382220300962718E-2]
["P81133 : THE VILLAGE PRACTICE",8908,79,8.8684328693309378E-3,"16/19",null,null,null,1.2783463680097256E-3,0.16842316194778584,"",7.1565198927733137E-4,8.7780108383414046E-2]
["P81149 : LOCKWOOD GP SURGERY",6666,139,2.0852085208520853E-2,"1/19",null,null,null,1.326199870719964E-2,1.7472789941051545,"Significantly above",1.7780965913850276E-3,9.3221015649952138E-2]
["P81150 : CLIFTON MEDICAL PRACTICE",5856,120,{"$f":"C241/B241","v":2.0491803278688523E-2},"3/19",null,null,null,1.290171677736731E-2,1.6998115601345911,"Significantly above",4.9441000984765081E-3,0.31799552906110268]
["P81157 : FERNBANK SURGERY",10361,149,1.4380851269182511E-2,"7/19",null,null,null,6.7907647678612992E-3,0.89468871885441958,"Significantly above",2.4113191690736981E-3,0.20145475603442989]
["P81191 : QUEENSWAY MEDICAL CENTRE",9142,124,1.3563771603587836E-2,"9/19",null,null,null,5.9736851022666243E-3,0.78703781587031718,"Significantly above",1.3581116338319491E-3,0.11126900447801934]
["P81210 : PARK MEDICAL PRACTICE",6483,120,1.8509949097639981E-2,"4/19",null,null,null,1.0919862596318768E-2,1.4387006781039897,"Significantly above",3.6286218264475548E-4,1.9995616064687315E-2]
["P81668 : FLEETWOOD SURGERY",4546,46,1.0118785745710514E-2,"14/19",null,null,null,2.5286992443893019E-3,0.33315815886276517,"",-4.6789268393218619E-4,-4.4196363103094417E-2]
["P81690 : BELLE VUE SURGERY",1897,5,2.635740643120717E-3,"19/19",null,null,null,-4.9543458582004957E-3,-0.652739050778682,"Significantly below",-3.4773515626867206E-3,-0.56883675979616943]
["P81737 : THE OLD LINKS SURGERY",1974,21,1.0638297872340425E-2,"11/19",null,null,null,3.0482113710192131E-3,0.4016042993039155,"",-1.5197568389057753E-3,-0.12500000000000003]
["P81742 : BEECHWOOD SURGERY",2428,26,1.070840197693575E-2,"10/19",null,null,null,3.1183154756145382E-3,0.41084057145748348,"",2.9532999361194237E-3,0.38082025492066252]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS Greater Preston CCG",151112,1496,{"$f":"C265/B265","v":9.8999417650484402E-3},"7/8",1.8977077157313921E-2,2486.5853970000003,{"$f":"(C265-G265)/ABS(C265)","v":-0.66215601403743329},{"$f":"D265-$D$423","v":2.309855263727228E-3},{"$f":"(D265-$D$423)/ABS($D$423)","v":0.30432528843052709},"Significantly below",5.9100027072702885E-5,8.3707502879038151E-3,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["P81015 : LYTHAM ROAD SURGERY",11110,104,9.4400146641004483E-3,{"$f":"RANK(D267,$D$267:$D$296) & \"/\" & COUNTA($D$267:$D$296)","v":"4/30"},null,null,null,{"$f":"D267-$D$423","v":1.8499281627792361E-3},{"$f":"(D267-$D$423)/ABS($D$423)","v":0.24372952303734849},"Significantly above",-7.9078570491088185E-5,-8.3769542002744002E-3]
["P81018 : ST FILLAN'S MEDICAL CTRE",8895,66,6.7689530685920577E-3,"14/30",null,null,null,-8.2113343272915452E-4,-0.10818499006384436,"",6.5094575096949405E-4,9.6166385609893254E-2]
["P81040 : LONGTON HEALTH CENTRE",10690,88,9.1533180778032037E-3,"7/30",null,null,null,1.5632315764819915E-3,0.20595701725005092,"",-9.2132556143276374E-4,-0.10065481758652944]
["P81046 : PARK VIEW SURGERY",5835,19,3.4843205574912892E-3,"27/30",null,null,null,-4.105765943829923E-3,-0.54093796468791611,"Significantly below",-2.2810804678006363E-4,-6.546700942587827E-2]
["P81055 : BERRY LANE MEDICAL CENTRE",10237,97,9.3665021653741558E-3,"5/30",null,null,null,1.7764156640529436E-3,0.23404419221621803,"Significantly above",1.0893009016946058E-4,1.1629751239705098E-2]
["P81059 : GREAT ECCLESTON HLTH CTR",7431,60,8.6044635654745905E-3,"10/30",null,null,null,1.0143770641533783E-3,0.13364499389786991,"",-5.3018015812699229E-4,-6.1616875252321381E-2]
["P81067 : THE HEALTHCARE CENTRE",13414,120,8.9885998246126871E-3,"8/30",null,null,null,1.3985133232914749E-3,0.18425525493655898,"",-4.2722383133636174E-5,-4.7529519577290845E-3]
["P81071 : THE NEW HALL LANE PRACTICE",6896,42,6.1419797171832595E-3,"19/30",null,null,null,-1.4481067841379527E-3,-0.19078923328289865,"",-5.149247820414142E-5,-8.3836939513300957E-3]
["P81093 : THE GEOFFREY STREET SURGERY",1782,8,3.7817396002160996E-3,"26/30",null,null,null,-3.8083469011051126E-3,-0.50175276664398893,"",7.075982224550568E-4,0.18710918710918714]
["P81103 : DR D C PATEL & PARTNERS",9632,130,1.3232920925228618E-2,"1/30",null,null,null,5.6428344239074059E-3,0.74344797294802289,"Significantly above",2.6375681563516919E-4,1.9931866677470711E-2]
["P81107 : STONEBRIDGE SURGERY",7564,84,9.7834594312548925E-3,"3/30",null,null,null,2.1933729299336803E-3,0.28897864728575601,"Significantly above",1.3217758939698572E-3,0.13510312004230565]
["P81119 : DOCLANDS MEDICAL CENTRE",6810,63,9.3085106382978719E-3,"6/30",null,null,null,1.7184241369766597E-3,0.22640376189092604,"",-5.7409316711968736E-5,-6.1674008810572133E-3]
["P81152 : THE SURGERY",8703,97,6.4374047094697615E-3,"17/30",null,null,null,-1.1526817918514507E-3,-0.15186675298770344,"Significantly above",4.7081772737544141E-3,0.73137816965716596]
["P81163 : THE ST PAULS SURGERY",1992,11,5.9317844784972816E-3,"21/30",null,null,null,-1.6583020228239306E-3,-0.21848262500503371,"",-4.0969612508362681E-4,-6.9067938420348085E-2]
["P81169 : FISHERGATE HILL SURGERY",6255,36,6.0290043995437506E-3,"20/30",null,null,null,-1.5610821017774616E-3,-0.20567382222926217,"",-2.7360871609051311E-4,-4.5382072720202137E-2]
["P81179 : LOSTOCK HALL MEDICAL CTR.",3806,20,7.534246575342466E-3,"12/30",null,null,null,-5.5839925978746173E-5,-7.3569551505145662E-3,"",-1.5036523809218091E-3,-0.22248271959254615]
["P81184 : RIBBLETON MEDICAL CENTRE",8284,41,6.7585131271120352E-3,"15/30",null,null,null,-8.3157337420917705E-4,-0.10956046074895516,"Significantly below",4.3490258818295029E-4,9.6336800344525964E-2]
["P81185 : RIVERSIDE MEDICAL CENTRE",11399,80,4.5143972669594926E-3,"24/30",null,null,null,-3.0756892343617196E-3,-0.40522452989519053,"",4.3227961412325034E-4,6.5637336608474331E-2]
["P81196 : ISSA MEDICAL CENTRE - PATEL",11693,32,6.5858798735511067E-3,"16/30",null,null,null,-1.0042066277701055E-3,-0.13230503072597427,"Significantly below",4.0630451601345041E-4,0.17435151866007947]
["P81213 : ST.MARY'S HEALTH CENTRE",17475,68,2.3303755489827013E-3,"30/30",null,null,null,-5.2597109523385109E-3,-0.69297114748599364,"Significantly below",-6.4721549469383931E-4,-0.14260594912955427]
["P81647 : DR JHA & DR YERRA SURGERY",1955,9,4.5384887421902626E-3,"23/30",null,null,null,-3.0515977591309496E-3,-0.40205045866074857,"",-1.31676389374489E-3,-0.22241339223436415]
["P81664 : THE PARK MEDICAL PRACTICE",15719,100,5.9203444564047362E-3,"22/30",null,null,null,-1.669742044916476E-3,-0.21998985711504379,"",-9.9016366078431579E-4,-0.13468148434551713]
["P81667 : ST WALBURGE'S MEDICAL PRACTICE",1705,12,7.3518915060670946E-3,"13/30",null,null,null,-2.3819499525411757E-4,-3.1382382165559615E-2,"",3.0944611953244395E-3,0.7846669459572686]
["P81685 : DR SZ SHAHID",2465,12,3.9436619718309857E-3,"25/30",null,null,null,-3.6464245294902265E-3,-0.48041936397635132,"",2.4201737420583395E-3,0.98864097363083181]
["P81735 : DR A HUSSAIN",3053,17,2.4479804161566705E-3,"29/30",null,null,null,-5.1421060851645417E-3,-0.67747661166568407,"",-6.2152770112244415E-4,-0.10041125304800376]
["P81748 : BRIARWOOD MEDICAL CENTRE",5925,59,8.0361627322953297E-3,"11/30",null,null,null,4.4607623097411755E-4,5.8770902136157301E-2,"Significantly above",-1.6701010695711893E-3,-0.14362869198312228]
["P81750 : FRENCHWOOD SURGERY",2006,5,8.8397790055248626E-3,"9/30",null,null,null,1.2496925042036503E-3,0.16464799234977301,"Significantly below",-4.6837648557628269E-5,-1.8444666001994011E-2]
["P81763 : DR HP CHAKRABARTI",1921,2,6.1898211829436037E-3,"18/30",null,null,null,-1.4002653183776085E-3,-0.18448608169799688,"Significantly below",-5.7177881143893471E-4,-0.35450286309213952]
["P81770 : AVENHAM LANE PRACTICE",3356,4,1.1627906976744186E-2,"2/30",null,null,null,4.0378204754229737E-3,0.53198609458800072,"Significantly below",-6.6362200390599662E-5,-5.2741358760429083E-2]
["P81785 : MEDICOM LTD",2122,10,2.5393600812595226E-3,"28/30",null,null,null,-5.0507264200616896E-3,-0.66543726730683583,"",-4.5906785297598722E-4,-8.8767029389084082E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS Morecambe Bay CCG",360784,3767,{"$f":"C318/B318","v":1.044115038360903E-2},"3/8",2.2241960932344061E-2,2224.3295450000001,{"$f":"(C318-G318)/ABS(C318)","v":0.40952228696575521},{"$f":"D318-$D$423","v":2.8510638822878175E-3},{"$f":"(D318-$D$423)/ABS($D$423)","v":0.37562995913044345},"Significantly above",6.7174209750973241E-5,6.4752616186114983E-3,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["A82003 : ULVERSTON HEALTH CENTRE (MURRAY)",11055,102,{"$f":"C320/B320","v":9.2265943012211672E-3},{"$f":"RANK(D320,$D$320:$D$361) & \"/\" & COUNTA($D$320:$D$361)","v":"26/42"},null,null,null,{"$f":"D320-$D$423","v":1.636507799899955E-3},{"$f":"(D320-$D$423)/ABS($D$423)","v":0.21561121860931187},"Significantly above",-2.510637905094211E-5,-2.7137042062415368E-3]
["A82005 : AMBLESIDE HEALTH CENTRE",6332,51,8.0543272267845859E-3,{"$f":"RANK(D321,$D$320:$D$361) & \"/\" & COUNTA($D$320:$D$361)","v":"30/42"},null,null,null,4.6424072546337371E-4,6.1164088891814732E-2,"",3.2413706925459376E-5,4.0406452706347046E-3]
["A82007 : DUKE STREET SURGERY",9535,101,1.059255374934452E-2,"16/42",null,null,null,3.0024672480233076E-3,0.39557747431477441,"Significantly above",4.3867538652655677E-4,4.3202741932868008E-2]
["A82008 : NORWOOD MEDICAL CENTRE",10954,119,1.0863611466131094E-2,"14/42",null,null,null,3.273524964809882E-3,0.4312895464682856,"Significantly above",-1.5666965495895902E-3,-0.12603843344896842]
["A82009 : BRIDGEGATE MEDICAL CENTRE",8947,100,1.1176930814798256E-2,"13/42",null,null,null,3.5868443134770443E-3,0.4725696226061033,"Significantly above",-2.5358072888666955E-4,-2.2184547727154575E-2]
["A82010 : ABBEY ROAD SURGERY",6665,57,8.5521380345086277E-3,"28/42",null,null,null,9.6205153318741545E-4,0.12675106311633608,"",6.3105000581336473E-4,7.9667086582966479E-2]
["A82025 : CAPTAIN FRENCH SURGERY",9760,101,1.0348360655737705E-2,"19/42",null,null,null,2.7582741544164924E-3,0.36340483786796862,"Significantly above",1.0280129753523232E-3,0.11029770675999251]
["A82026 : THE JAMES COCHRANE PRACT.",17022,221,1.2983198214075902E-2,"7/42",null,null,null,5.3931117127546902E-3,0.71054680494298805,"Significantly above",8.9369983803837087E-4,7.392364928968137E-2]
["A82027 : STATION HOUSE SURGERY",10366,123,1.1865714836967007E-2,"12/42",null,null,null,4.2756283356457951E-3,0.56331747140187838,"Significantly above",1.0682153105415482E-3,9.8931730251733907E-2]
["A82030 : LUNESDALE SURGERY",5981,60,1.0031767262999498E-2,"23/42",null,null,null,2.4416807616782854E-3,0.32169340379101874,"Significantly above",-1.1798315297388041E-4,-1.1624241793000348E-2]
["A82033 : WATERLOO HOUSE SURGERY",8365,82,9.8027495517035261E-3,"25/42",null,null,null,2.2126630503823139E-3,0.29152013616671613,"Significantly above",-5.433082435158821E-4,-5.2513551950862672E-2]
["A82034 : STONELEIGH SURGERY",6593,144,2.1841346883057788E-2,"2/42",null,null,null,1.4251260381736575E-2,1.8776150152249051,"Significantly above",-6.458248646029445E-4,-2.8719701697041005E-2]
["A82039 : DALTON SURGERY",8543,108,1.2641929064731359E-2,"9/42",null,null,null,5.0518425634101466E-3,0.66558432009052448,"Significantly above",9.7152944195639732E-4,8.3247315718344636E-2]
["A82046 : WINDERMERE HEALTH CENTRE",5783,44,7.6085076949680098E-3,"34/42",null,null,null,1.8421193646797618E-5,2.4270070760841825E-3,"",2.9015955069200319E-4,3.9648230033843004E-2]
["A82053 : NUTWOOD MEDICAL PRACTICE",4788,90,1.8796992481203006E-2,"3/42",null,null,null,1.1206905979881793E-2,1.4765188747099258,"Significantly above",9.0561867928607223E-4,5.0617615467239391E-2]
["A82062 : ATKINSON HEALTH CENTRE",4721,33,6.9900444821012495E-3,"36/42",null,null,null,-6.0004201921996271E-4,-7.9056018546760032E-2,"",-1.8520607810566447E-3,-0.20945925500045387]
["A82065 : PENINSULA MEDICAL PRACTICE",2945,51,1.731748726655348E-2,"4/42",null,null,null,9.7274007652322671E-3,1.2815928729585639,"Significantly above",-3.2628096295328896E-3,-0.15854045478582762]
["A82068 : ULVERSTON COMMUNITY HEALTH CENTRE",4258,46,1.0803193987787695E-2,"15/42",null,null,null,3.2131074864664823E-3,0.4233294951127598,"Significantly above",-1.8056914497257236E-4,-1.6439643024894198E-2]
["A82070 : ST.MARY'S SURGERY",6115,46,7.5224856909239576E-3,"35/42",null,null,null,-6.7600810397254636E-5,-8.9064611299867671E-3,"",-9.4083989818988245E-4,-0.11116669071553395]
["A82071 : BURNETT EDGAR MEDICAL CTR",4263,33,7.7410274454609426E-3,"33/42",null,null,null,1.5094094413973039E-4,1.9886590767240399E-2,"",4.2674173117522845E-4,5.8343596059113267E-2]
["A82072 : RISEDALE SURGERY",6868,88,1.28130460104834E-2,"8/42",null,null,null,5.2229595091621882E-3,0.68812911529440723,"Significantly above",7.1627181693501366E-4,5.9211803533294464E-2]
["A82074 : ARNSIDE SURGERY",2276,55,2.4165202108963092E-2,"1/42",null,null,null,1.6575115607641879E-2,2.1837848099302475,"Significantly above",1.4775930339194637E-3,6.5127754495065596E-2]
["A82077 : LIVERPOOL HOUSE SURGERY",5262,27,5.1311288483466364E-3,"40/42",null,null,null,-2.4589576529745758E-3,-0.32396964811225054,"Significantly below",5.1166477697530029E-5,1.0072215887495264E-2]
["A82608 : SEDBERGH MEDICAL PRACTICE",4170,34,8.1534772182254196E-3,"29/42",null,null,null,5.6339071690420742E-4,7.4227179994080114E-2,"",4.3891598389562188E-4,5.6894484412469984E-2]
["A82613 : WRAYSDALE HOUSE SURGERY",969,5,5.1599587203302374E-3,"39/42",null,null,null,-2.4301277809909748E-3,-0.32017128929531441,"",1.0531825396320853E-3,0.25644994840041274]
["A82621 : ASKAM SURGERY",1640,13,7.926829268292683E-3,"31/42",null,null,null,3.3674276697147083E-4,4.4366130334990747E-2,"",-5.3749963134456027E-4,-6.3501742160278762E-2]
["A82629 : THE FAMILY PRACTICE",3586,28,7.8081427774679309E-3,"32/42",null,null,null,2.1805627614671867E-4,2.8729089728919615E-2,"",3.0345234594823106E-4,4.0435025097601787E-2]
["A82647 : CARTMEL SURGERY",2512,37,1.4729299363057325E-2,"5/42",null,null,null,7.1392128617361128E-3,0.94059703542158379,"Significantly above",-1.413084742902939E-3,-8.7538788175730797E-2]
["A82650 : HAVERTHWAITE SURGERY",2745,24,8.7431693989071038E-3,"27/42",null,null,null,1.1530828975858916E-3,0.15191959899075902,"",1.7604424602815985E-3,0.25211389128559103]
["A82651 : DUDDON VALLEY MEDICAL PRACTICE",3353,13,3.8771249627199524E-3,"41/42",null,null,null,-3.7129615386012598E-3,-0.48918566843143907,"Significantly below",-1.1778854446544158E-3,-0.23301345590428235]
["B82061 : BENTHAM MEDICAL PRACTICE",7211,74,1.0262099570101234E-2,"20/42",null,null,null,2.6720130687800216E-3,0.35203987046984275,"Significantly above",-5.292673363735869E-4,-4.9045439837285716E-2]
["P81002 : DALTON SQUARE PRACTICE",13069,89,6.8100084168643358E-3,"37/42",null,null,null,-7.8007808445687641E-4,-0.10277591491494696,"",9.3901788426973415E-6,1.3807831161875409E-3]
["P81006 : WINDSOR SURGERY",10976,112,1.020408163265306E-2,"21/42",null,null,null,2.6139951313318482E-3,0.34439596055681687,"Significantly above",2.2239665096807949E-4,2.2280471821756222E-2]
["P81013 : QUEEN SQUARE MEDICAL PRACTICE",14040,141,1.0042735042735043E-2,"22/42",null,null,null,2.4526485414138313E-3,0.32313841759074774,"Significantly above",-5.8620499538253497E-4,-5.5151783082817527E-2]
["P81029 : ASH TREES SURGERY",15061,213,1.414248721864418E-2,"6/42",null,null,null,6.5524007173229674E-3,0.8632840635192216,"Significantly above",2.1213895993771152E-4,1.5228546766957148E-2]
["P81056 : ROSEBANK SURGERY",11004,115,1.0450745183569612E-2,"18/42",null,null,null,2.8606586822483996E-3,0.37689408174076044,"Significantly above",1.0636662216701089E-3,0.11331173690850396]
["P81064 : KING STREET SURGERY",19916,43,2.1590680859610366E-3,"42/42",null,null,null,-5.4310184153601761E-3,-0.71554104349335079,"Significantly below",-4.7597802734594642E-4,-0.18063366137778666]
["P81085 : YORK BRIDGE SURGERY",6752,82,1.2144549763033176E-2,"11/42",null,null,null,4.5544632617119636E-3,0.60005419713189889,"Significantly above",-2.5810382796769005E-4,-2.0810371431720497E-2]
["P81091 : OWEN ROAD SURGERY",8970,58,6.4659977703455966E-3,"38/42",null,null,null,-1.1240887309756156E-3,-0.1480995942246435,"",-6.5064851009474615E-4,-9.142628205128206E-2]
["P81113 : PARK VIEW SURGERY",6055,60,9.9091659785301399E-3,"24/42",null,null,null,2.3190794772089277E-3,0.30554058597424993,"Significantly above",2.3443703774615396E-4,2.4231897263589534E-2]
["P81190 : LANDSCAPE SURGERY",7242,76,1.0494338580502624E-2,"17/42",null,null,null,2.9042520791814118E-3,0.38263754684164225,"Significantly above",8.8564898295353557E-4,9.2171671689700557E-2]
["Y01008 : BAY MEDICAL GROUP",54116,668,1.2343853943380886E-2,"10/42",null,null,null,4.7537674420596735E-3,0.6263126831600907,"Significantly above",-7.0646052202791992E-4,-5.4133601446958682E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS West Lancashire CCG",113228,1075,{"$f":"C381/B381","v":9.4941180626700108E-3},"4/8",2.1706084230355221E-2,1613.1961800000001,{"$f":"(C381-G381)/ABS(C381)","v":-0.50064760930232566},{"$f":"D381-$D$423","v":1.9040315613487986E-3},{"$f":"(D381-$D$423)/ABS($D$423)","v":0.25085768930530139},"Significantly above",-1.2480292072320452E-4,-1.2974731878832678E-2,null,null,"G"]
["Practice","Registered Population 2016/17","Dementia Register","Prevalence","Local rank","30+ Estimated Prevalence (2017)","30+ Estimated actuals (2017)","Dementia Gap (%)","% Point difference from national level","% difference from national level ","Significance","% Point Difference from 2015/16 prevalence level","Percentage change from 2015/16"]
["P81014 : ORMSKIRK MEDICAL PRACTICE",8781,128,{"$f":"C383/B383","v":1.4576927457009453E-2},{"$f":"RANK(D383,$D$383:$D$401) & \"/\" & COUNTA($D$383:$D$401)","v":"2/19"},null,null,null,{"$f":"D383-$D$423","v":6.9868409556882406E-3},{"$f":"(D383-$D$423)/ABS($D$423)","v":0.92052191427225971},"Significantly above",-8.2923500797654238E-4,-5.3824890517750114E-2]
["P81039 : MANOR PRIMARY CARE",5266,22,{"$f":"C384/B384","v":4.1777440182301558E-3},"19/19",null,null,null,-3.4123424830910564E-3,-0.44957886612979542,"Significantly below",-7.9452601428084066E-4,-0.15979140494901983]
["P81041 : PARKGATE SURGERY",6558,119,1.8145776151265631E-2,"1/19",null,null,null,1.0555689649944418E-2,1.3907205995751144,"Significantly above",4.4385128772779208E-3,0.32380737048371222]
["P81045 : THE ELMS PRACTICE",6175,58,9.3927125506072882E-3,"9/19",null,null,null,1.802626049286076E-3,0.23749743154736003,"",1.3983226487840061E-3,0.17491299097947305]
["P81084 : HALL GREEN SURGERY",7102,83,1.168684877499296E-2,"5/19",null,null,null,4.0967622736717479E-3,0.53975172390441417,"Significantly above",-1.5283909269612084E-3,-0.11565366663271356]
["P81096 : PARBOLD SURGERY",6943,60,8.6417974938787275E-3,"10/19",null,null,null,1.0517109925575153E-3,0.13856376898661737,"",-8.6281080105214854E-4,-9.0778154583426043E-2]
["P81112 : BEACON PRIMARY CARE",12463,152,1.2196100457353767E-2,"4/19",null,null,null,4.6060139560325552E-3,0.60684604256233221,"Significantly above",-1.8367919273441224E-3,-0.1308918986186372]
["P81136 : DR A BISARYA",2477,20,8.0742834073475982E-3,"12/19",null,null,null,4.8419690602638597E-4,6.3793331728446229E-2,"",-2.0308095595076969E-3,-0.20096891400888167]
["P81138 : BURSCOUGH FAMILY PRACTICE",2738,31,1.1322132943754566E-2,"7/19",null,null,null,3.732046442433354E-3,0.49170011985814838,"Significantly above",-5.9552686122918246E-4,-4.9970117537685037E-2]
["P81177 : VIRAN MEDICAL CENTRE",2337,19,8.130081300813009E-3,"11/19",null,null,null,5.3999479949179679E-4,7.1144749061529067E-2,"",2.3430554084459196E-4,2.967479674796757E-2]
["P81201 : ASHURST PRIMARY CARE",5037,23,4.5662100456621002E-3,"18/19",null,null,null,-3.023876455659112E-3,-0.39839815463667555,"Significantly below",-2.8227480282274828E-4,-5.8219178082191833E-2]
["P81208 : SKELMERSDALE PRACTICE",15333,85,5.5435987738863884E-3,"15/19",null,null,null,-2.0464877274348238E-3,-0.26962640374106278,"Significantly below",4.6800482140258674E-4,9.2206907365701127E-2]
["P81646 : LATHOM HOUSE SURGERY",4415,50,1.1325028312570781E-2,"6/19",null,null,null,3.7349418112495687E-3,0.4920815870279508,"Significantly above",-9.3376850922263603E-4,-7.6171301539365036E-2]
["P81674 : STANLEY COURT SURGERY",5404,41,7.5869726128793488E-3,"14/19",null,null,null,-3.1138884418633814E-6,-4.1025730620083766E-4,"",2.1674248647948783E-3,0.39992725694887565]
["P81695 : AUGHTON SURGERY",5919,64,1.081263726980909E-2,"8/19",null,null,null,3.2225507684878777E-3,0.42457365511274819,"Significantly above",1.7186084434535655E-3,0.18898207563108266]
["P81710 : TARLETON GROUP PRACTICE",8250,45,5.454545454545455E-3,"16/19",null,null,null,-2.1355410467757572E-3,-0.28135925017508323,"Significantly below",-2.7897068654889837E-4,-4.8656126482213298E-2]
["P81727 : COUNTY ROAD SURGERY",2005,16,7.9800498753117202E-3,"13/19",null,null,null,3.8996337399050795E-4,5.1377988106278728E-2,"",-1.216465129528551E-3,-0.13227457671610454]
["P81758 : MATTHEW RYDER CLINIC",2899,14,4.8292514660227661E-3,"17/19",null,null,null,-2.7608350352984461E-3,-0.36374223598345889,"",-1.3279379580989287E-3,-0.21567274719477308]
["P81772 : NORTH MEOLS MEDICAL CENTRE",3126,45,1.4395393474088292E-2,"3/19",null,null,null,6.8053069727670801E-3,0.89660466604464584,"Significantly above",3.4347229389496726E-3,0.31336795754770252]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["England national prevalence",57549410,436805,{"$f":"C423/B423","v":7.5900865013212122E-3}]
["Combined Lancashire total",{"$f":"B381+B318+B265+B228+B153+B106+B61+B10","v":1683512},{"$f":"C381+C318+C265+C228+C153+C106+C61+C10","v":15649},{"$f":"C424/B424","v":9.295449037488298E-3}]
[]
[]
[]
[]
[]
["CCG","Recorded Prevalence","England","L1","U1","L2","U2"]
["NHS Blackburn With Darwen CCG",6.352238531159916E-3,7.5900865013212122E-3,5.9894805121611192E-3,6.7368183955731943E-3,{"$f":"B431-D431","v":3.6275801899879681E-4},{"$f":"E431-B431","v":3.8457986441327828E-4}]
["NHS Blackpool CCG",1.037643530072554E-2,7.5900865013212122E-3,9.9092795337318747E-3,1.0865372628989955E-2,4.6715576699366511E-4,4.889373282644157E-4]
["NHS Chorley And South Ribble CCG",7.981047759865004E-3,7.5900865013212122E-3,7.5824393739142449E-3,8.4004335904094025E-3,3.9860838595075915E-4,4.1938583054439843E-4]
["NHS East Lancashire CCG",7.8685703274919555E-3,7.5900865013212122E-3,7.5921671754530492E-3,8.1549536217632758E-3,2.7640315203890636E-4,2.8638329427132028E-4]
["NHS  Fylde & Wyre CCG",1.311609931706284E-2,7.5900865013212122E-3,1.2554717165579599E-2,1.3702235252621623E-2,5.6138215148324178E-4,5.86135935558783E-4]
["NHS Greater Preston CCG",7.119402274782278E-3,7.5900865013212122E-3,6.7688233360329855E-3,7.4880019236326766E-3,3.5057893874929254E-4,3.6859964885039859E-4]
["NHS Morecambe Bay CCG",1.044115038360903E-2,7.5900865013212122E-3,1.0114643607575287E-2,1.0778082234686896E-2,3.2650677603374319E-4,3.3693185107786655E-4]
["NHS West Lancashire CCG",9.4589178356713419E-3,7.5900865013212122E-3,8.9456812332915862E-3,1.0075836310463869E-2,5.132366023797557E-4,6.169184747925275E-4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"<< Select CCG"]
["CCG","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17"]
["England",5.5972977189269199E-3,5.8767321272016598E-3,6.3740581812444796E-3,6.8956349153904799E-3,7.4730546493578598E-3,9.1242673374561396E-3,9.5177707819510005E-3,9.6454199059954199E-3]
["West Lancashire",{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=B$451,$B$455:$I$462)))","v":5.1188406360183798E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=C$451,$B$455:$I$462)))","v":5.8386766940284997E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=D$451,$B$455:$I$462)))","v":5.9803159108584303E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=E$451,$B$455:$I$462)))","v":6.6805398019059202E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=F$451,$B$455:$I$462)))","v":7.2445643435227703E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=G$451,$B$455:$I$462)))","v":8.9277751021208992E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=H$451,$B$455:$I$462)))","v":9.4589178356713401E-3},{"$f":"SUM(IF(CCG=$A$453,IF($B$454:$I$454=I$451,$B$455:$I$462)))","v":9.4941180626700108E-3}]
["CCG","2009/10","2010/11","2011/12","2012/13","2013/14","2014/15","2015/16","2016/17"]
["Blackburn With Darwen",4.2965864936899897E-3,4.25240756608817E-3,4.6129886126096298E-3,4.9095104061557702E-3,5.0259269321175004E-3,6.5681252056210898E-3,6.4463251877513996E-3,6.3522385311599204E-3]
["Blackpool",5.5818735999412401E-3,6.1014301752330699E-3,6.5494836988049697E-3,7.0551330578416697E-3,7.6247662628773196E-3,1.02336628130348E-2,9.9250958144519608E-3,1.03764353007255E-2]
["Chorley And South Ribble",4.5056261041748202E-3,4.7863833001847303E-3,5.4658041304874302E-3,6.0134701731879396E-3,6.6582208006908204E-3,8.2430111764871493E-3,7.8705120004449805E-3,7.9810477598650006E-3]
["East Lancashire",4.8003137682889399E-3,5.0959973412187803E-3,5.5693320866701899E-3,5.9718775398147801E-3,6.2512109534778601E-3,8.0409337132227796E-3,7.8724220214760506E-3,7.8685703274919607E-3]
["Fylde & Wyre",6.0147660422700498E-3,6.5638152519447704E-3,7.5409014804951697E-3,8.2790660736975896E-3,9.2333222701626305E-3,1.1605069338464599E-2,1.2148969027751101E-2,1.31160993170628E-2]
["Greater Preston",4.1346392577917201E-3,4.8254728611179598E-3,5.2102962237129697E-3,5.5416238048058997E-3,6.0128260764742798E-3,7.0173103163019297E-3,7.0944749946897602E-3,7.1194022747822798E-3]
["Morecambe Bay",6.5831047959114802E-3,6.94568011829745E-3,7.2519851887097499E-3,7.7570926903643804E-3,8.4944018521790707E-3,9.6479490697431603E-3,9.8472488132736995E-3,1.0441150383609E-2]
["West Lancashire",5.1188406360183798E-3,5.8386766940284997E-3,5.9803159108584303E-3,6.6805398019059202E-3,7.2445643435227703E-3,8.9277751021208992E-3,9.4589178356713401E-3,9.4941180626700108E-3]

{"sheet":"QoF Monthly Extracts","index":5,"n_rows":69,"n_cols":16,"rows_kept":69,"cut":false,"hidden":false,"merged":[[58,1,58,9],[0,0,2,15],[6,0,10,9],[45,1,46,9],[48,4,48,5],[48,7,48,8],[13,1,14,8],[26,1,26,8]]}
["Monthly dementia prevalence by Clinical Commissioning Group (CCG)"]
[]
[]
[]
["Source : HSCIC QoF Dementia registers"]
[]
["In 2015 the Office for National Statistics (ONS) began publishing monthly extracts of the GP dementia registers.  Which are used to calculate dementia diagnosis rates in conjunction with the latest dementia prevalence estimates. In order to support the 2009 national dementia strategy which called for two-thirds (67.70%) of the estimated number of people with dementia to receive a diagnosis and appropriate post-diagnosis support by March 2015, so that they can access the right care at the right time.  One key difference between this extract and the full year Quality and Outcomes Framework(QoF) figures, is that due to a number of reasons not all practices are included in each monthly extract. In such cases we have used the latest available figures to produce a more complete picture."]
[]
[]
[]
[]
["Click here for further details"]
[]
[null,"QoF all age dementia prevalence October 2017"]
[]
[null,{"$f":"B14","v":"QoF all age dementia prevalence October 2017"}]
[null,"CCG","Registered Population","Extract practice count","Dementia Register","Recorded Prevalence","% Point difference from England","% difference from England","Significance of difference",null,null,{"$f":"B26","v":"England"},"L1 ","U1","L2","U2"]
[null,"NHS Blackburn with Darwen CCG",168352,"25 / 25",1183,{"$f":"E18/C18","v":7.0269435468542103E-3},{"$f":"F18-$F$26","v":-7.8103945226751063E-4},{"$f":"(F18-$F$26)/ABS($F$26)","v":-0.10003088535865994},"Low",null,null,{"$f":"$F$26","v":7.8079829991217209E-3},6.6390214359329279E-3,7.4373624797410059E-3,{"$f":"F18-M18","v":3.8792211092128232E-4},{"$f":"N18-F18","v":4.1041893288679566E-4}]
[null,"NHS Blackpool CCG",173245,"20 / 20",1857,1.0718924067072642E-2,{"$f":"F19-$F$26","v":2.9109410679509212E-3},0.37281601000903275,"High",null,null,{"$f":"$F$26","v":7.8079829991217209E-3},1.0244755841288833E-2,1.1214790020692493E-2,4.7416822578380882E-4,4.9586595361985134E-4]
[null,"NHS Chorley and South Ribble CCG",182893,"30 / 30",1512,8.2671288676985991E-3,4.5914586857687817E-4,5.880467063369952E-2,"High",null,null,{"$f":"$F$26","v":7.8079829991217209E-3},7.8623555712719739E-3,8.6925583062452301E-3,4.047732964266252E-4,4.2542943854663104E-4]
[null,"NHS East Lancashire CCG",370168,"56 / 57",3040,8.2124873030623938E-3,4.0450430394067295E-4,5.180650418759538E-2,"High",null,null,7.8079829991217209E-3,7.9268138784156072E-3,8.5083677789592801E-3,2.8567342464678666E-4,2.9588047589688624E-4]
[null,"NHS Fylde & Wyre CCG",151735,"19 / 19",2092,1.3787194780373678E-2,5.9792117812519571E-3,0.76578186478179155,"High",null,null,7.8079829991217209E-3,1.3212665444376659E-2,1.4386342288638113E-2,5.7452933599701911E-4,5.9914750826443527E-4]
[null,"NHS Greater Preston CCG",215288,"30 / 30",1539,7.148563784326112E-3,-6.5941921479560888E-4,-8.4454489062000204E-2,"Low",null,null,7.8079829991217209E-3,6.8013836484312569E-3,7.5133318463041282E-3,3.4718013589485515E-4,3.6476806197801616E-4]
[null,"NHS Morecambe Bay",353245,"36 / 42",3817,1.0805531571572139E-2,2.9975485724504179E-3,0.38390818381489772,"High",null,null,7.8079829991217209E-3,1.0469874860401166E-2,1.1151827923615073E-2,3.3565671117097295E-4,3.4629635204293414E-4]
[null,"NHS West Lancashire CCG",111104,"17 / 18",1100,9.900633640552995E-3,2.0926506414312741E-3,0.26801424153544717,"High",null,null,7.8079829991217209E-3,9.3351661484295662E-3,1.0499990667549908E-2,5.6546749212342887E-4,5.993570269969134E-4]
[null,"England",58146643,7216,454008,7.8079829991217209E-3,null,null,null,null,null,null,7.7853923438767347E-3,7.8306386877080233E-3,2.2590655244986158E-5,2.2655688586302458E-5]
[null,"Extract practice count, refers to the number of practices for whom NHS digital was able to extract recorded dementia prevalence data for. 99.1% of pratices from England wehere included in the October 2017 extract."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"QoF Dementia prevalence October 2017 - age split"]
[]
[null,{"$f":"B46","v":"QoF Dementia prevalence October 2017 - age split"}]
[null,"CCG","Registered 65 + Population","Registered 0-64 Population","Recorded 65+ Prevalence",null,"Significance from England","Recorded 0-64 Prevalence",null,"Significance from England"]
[null,"NHS Blackburn with Darwen CCG",24188,144164,1127,{"$f":"E50/C50","v":4.6593352075409294E-2},"High",56,{"$f":"H50/D50","v":3.8844649149579646E-4},"-"]
[null,"NHS Blackpool CCG",35028,138217,1790,{"$f":"E51/C51","v":5.1101975562407219E-2},"High",67,{"$f":"H51/D51","v":4.8474500242372503E-4},"High"]
[null,"NHS Chorley and South Ribble CCG",35943,146950,1468,4.0842444982333137E-2,"Low",44,2.9942157196325282E-4,"-"]
[null,"NHS East Lancashire CCG",66127,304041,2908,4.3975985603460006E-2,"-",132,4.3415197292470426E-4,"High"]
[null,"NHS Fylde & Wyre CCG",39859,111876,2037,{"$f":"E54/C54","v":5.1105145638375274E-2},"High",55,{"$f":"H54/D54","v":4.9161571740140872E-4},"High"]
[null,"NHS Greater Preston CCG",35286,180002,1474,4.1772941109788582E-2,"-",65,3.6110709881001323E-4,"-"]
[null,"NHS Morecambe Bay",78492,274753,3692,4.703664067675687E-2,"High",125,4.549540860336375E-4,"High"]
[null,"NHS West Lancashire CCG",23304,87800,1060,4.5485753518709232E-2,"-",40,4.5558086560364467E-4,"High"]
[null,"England",10096396,48050247,439509,{"$f":"E58/C58","v":4.3531275912711824E-2},"-",14499,3.0174662785812528E-4,"-"]
[]
[]
[]
[null,null,"Proportion of dementia patients aged 65+","Proportion of dementia patients aged 0-64"]
[null,{"$f":"B58","v":"England"},{"$f":"E58/(E58+H58)","v":0.96806443939313847},{"$f":"H58/(H58+E58)","v":3.1935560606861556E-2}]
[null,"NHS Chorley and South Ribble CCG",{"$f":"E52/(E52+H52)","v":0.97089947089947093},{"$f":"H52/(H52+E52)","v":2.9100529100529099E-2}]
[null,"NHS East Lancashire CCG",{"$f":"E53/(E53+H53)","v":0.95657894736842108},{"$f":"H53/(H53+E53)","v":4.3421052631578951E-2}]
[null,"NHS  Fylde & Wyre CCG",{"$f":"E55/(E55+H55)","v":0.95776478232618578},{"$f":"H55/(H55+E55)","v":4.2235217673814163E-2}]
[null,"NHS Greater Preston CCG",{"$f":"E56/(E56+H56)","v":0.96725176840450611},{"$f":"H56/(H56+E56)","v":3.2748231595493844E-2}]
[null,"NHS Lancashire North CCG",{"$f":"E57/(E57+H57)","v":0.96363636363636362},{"$f":"H57/(H57+E57)","v":3.6363636363636362E-2}]
[null,"NHS West Lancashire CCG",{"$f":"E54/(E54+H54)","v":0.97370936902485661},{"$f":"H54/(H54+E54)","v":2.6290630975143402E-2}]

{"sheet":"Estimated prevalence","index":6,"n_rows":141,"n_cols":21,"rows_kept":141,"cut":false,"hidden":false,"merged":[[0,0,1,13],[2,0,2,13],[9,6,10,6],[9,9,10,9],[9,12,10,12],[8,4,8,12],[4,0,6,12],[21,0,22,12],[9,7,10,7],[9,4,10,4],[9,10,10,10],[7,0,7,12],[8,0,10,0],[8,1,10,1],[8,2,10,2],[8,3,10,3],[88,1,88,2],[78,0,78,12],[79,0,80,3],[79,4,79,12],[80,4,81,4],[80,6,81,6],[80,7,81,7],[80,9,81,9],[80,10,81,10],[80,12,81,12],[81,1,81,2],[75,0,77,12],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[84,1,84,2],[85,1,85,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[82,1,82,2],[83,1,83,2],[86,1,86,2],[87,1,87,2]]}
["Dementia in Lancashire"]
[]
["Estimated prevalence 2017"]
[]
["These estimates have been calculated using the latest NHS England methodology that combines the Alzheimer's Society 2014 (Delphi) aged 30-64 estimates with the CFAS II 65+ estimates, and applying them to the April 2017 registered population figures. "]
[]
[]
["Clinical Commissioning Group estimates (CCGs)"]
["Geography","ONS Code","NHS Code","Area","Estimated prevalence"]
[null,null,null,null,"30 - 64\n(AS-2014)","Population","%","65+ Only\n(CFAS II)","Population","%","Estimated cases Age 30+","Population","%",null,null,null,"L C.I","U C.I","L2","U2"]
[null,null,null,null,null,"30-64",null,null,"65+",null,null,"30+"]
["National","E92000001","ENG","ENGLAND",37390.432351000003,26960430,{"$f":"E12/F12","v":1.3868633531067568E-3},636420.74800000002,10080273,{"$f":"H12/I12","v":6.3135269054717072E-2},{"$f":"H12+E12","v":673811.18035100005},{"$f":"I12+F12","v":37040703},{"$f":"K12/L12","v":1.8191101296079613E-2},null,null,{"$f":"$M$12","v":1.8191101296079613E-2},1.8148113298954448E-2,1.8234189229151022E-2,{"$f":"M12-Q12","v":4.2987997125164962E-5},{"$f":"R12-M12","v":4.3087933071409013E-5}]
["CCG","E38000014","00Q","NHS Blackburn with Darwen CCG",104.93958600000002,78344,{"$f":"E13/F13","v":1.3394718931890128E-3},1491.193,24743,{"$f":"H13/I13","v":6.0267267510002831E-2},{"$f":"H13+E13","v":1596.1325859999999},{"$f":"I13+F13","v":103087},{"$f":"K13/L13","v":1.5483354700398692E-2},null,null,{"$f":"$M$12","v":1.8191101296079613E-2},1.4747521419957088E-2,1.6255296925427827E-2,{"$f":"M13-Q13","v":7.3583328044160394E-4},{"$f":"R13-M13","v":7.7194222502913537E-4},{"$f":"IF(Q13>$R$12,\"High\",IF(R13<$Q$12,\"Low\",\"No diff\"))","v":"Low"}]
["CCG","E38000015","00R","NHS Blackpool CCG",122.96036900000001,79877,{"$f":"E14/F14","v":1.5393713960213831E-3},2193.0529999999999,34819,{"$f":"H14/I14","v":6.2984376346247734E-2},{"$f":"H14+E14","v":2316.0133689999998},{"$f":"I14+F14","v":114696},{"$f":"K14/L14","v":2.019262545337239E-2},null,null,1.8191101296079613E-2,1.9394519365271545E-2,2.1022870387486341E-2,7.9810608810084588E-4,8.302449341139502E-4,{"$f":"IF(Q14>$R$12,\"High\",IF(R14<$Q$12,\"Low\",\"No diff\"))","v":"High"}]
["CCG","E38000034","00X","NHS Chorley and South Ribble CCG",128.91628500000002,85544,1.5070172659683908E-3,2063.759,35474,5.8176664599424929E-2,2192.6752850000003,121018,1.8118588019963973E-2,null,null,1.8191101296079613E-2,1.7382264651805545E-2,1.8885503016513865E-2,7.3632336815842789E-4,7.669149965498917E-4,"No diff"]
["CCG","E38000050","01A","NHS East Lancashire CCG",258.20577500000002,172256,1.498965348086569E-3,4048.8130000000001,67822,5.9697634985697856E-2,4307.0187750000005,240078,1.794008103616325E-2,null,null,1.8191101296079613E-2,1.7416793157946649E-2,1.8478795431575441E-2,5.2328787821660089E-4,5.3871439541219174E-4,"No diff"]
["CCG","E38000060","02M","NHS Fylde & Wyre CCG",118.25753600000002,67132,1.761567300244295E-3,2576.3000000000002,39413,6.5366757161342715E-2,2694.5575360000003,106545,2.5290323675442303E-2,null,null,1.8191101296079613E-2,2.4364550606606167E-2,2.6250326636380845E-2,9.2577306883613597E-4,9.6000296093854201E-4,"High"]
["CCG","E38000065","01E","NHS Greater Preston CCG",136.34789599999999,96312,1.4156895921588171E-3,2185.2939999999999,34963,6.2503046077281688E-2,2321.6418960000001,131275,1.7685331525423731E-2,null,null,1.8191101296079613E-2,1.6986316572523853E-2,1.8412573295638158E-2,6.9901495289987833E-4,7.2724177021442696E-4,"No diff"]
["CCG","E38000093","01K","NHS Morecambe Bay CCG",263.52878500000003,159417,1.6530783103433136E-3,4991.3639999999996,79896,6.2473265244818256E-2,5254.892785,239313,2.1958242072098046E-2,null,null,1.8191101296079613E-2,2.1378729032461928E-2,2.2553101944129735E-2,5.7951303963611756E-4,5.9485987203168958E-4,"High"]
["CCG","E38000200","02G","NHS West Lancashire CCG",81.417361,50627,1.6081806348391175E-3,1421.8309999999999,23682,6.0038468034794353E-2,1503.2483609999999,74309,2.0229694397717636E-2,null,null,1.8191101296079613E-2,1.9241975980826654E-2,2.1267014413368222E-2,9.8771841689098208E-4,1.0373200156505863E-3,"High"]
[]
[]
[]
[null,"Significantly below England prevalence"]
[null,"Significantly above England prevalence"]
[]
["Cognitive Function & Ageing Study (CFAS II)"]
["Alzheimer's Society; Dementia UK: Update 2014"]
[]
[]
[null,null,null,null,"30-64","65+"]
[null,null,"ENG","ENGLAND",{"$f":"E12/K12","v":5.549096459266626E-2},{"$f":"H12/K12","v":0.94450903540733366}]
[null,null,"00Q","NHS Blackburn with Darwen CCG",{"$f":"E13/K13","v":6.5746158508664151E-2},{"$f":"H13/K13","v":0.93425384149133583}]
[null,null,"00R","NHS Blackpool CCG",{"$f":"E14/K14","v":5.3091389991885674E-2},{"$f":"H14/K14","v":0.94690861000811433}]
[null,null,"00X","NHS Chorley and South Ribble CCG",5.8794061246510564E-2,0.94120593875348935]
[null,null,"01A","NHS East Lancashire CCG",5.9949999869689442E-2,0.94005000013031048]
[null,null,"02M","NHS Fylde & Wyre CCG",4.3887552750330287E-2,0.95611244724966971]
[null,null,"01E","NHS Greater Preston CCG",5.8729081446590156E-2,0.94127091855340972]
[null,null,"01K","NHS Morecambe Bay CCG",5.0149222026420477E-2,0.94985077797357942]
[null,null,"02G","NHS West Lancashire CCG",5.4160951119107861E-2,0.9458390488808921]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["These estimates have been calculated using the latest NHS England methodology that combines the Alzheimer's Society 2014 (Delphi) aged 30-64 estimates with the CFAS II 65+ estimates, and applying them to the April 2017 projected estimated resident population figures. "]
[]
[]
["District estimates"]
["Estimated dementia prevalence using the 2014-based ONS Population projection for 2017",null,null,null,"Estimated prevalence"]
[null,null,null,null,"30 - 64\n(AS-2014)","Population","%","65+ Only\n(CFAS II)","Population","%","Estimated cases Age 30+","Population","%"]
["Geography","ONS Code",null,"Area",null,"30-64",null,null,"65+",null,null,"30+",null,null,null,null,"L C.I","U C.I","L2","U2"]
["National","E92000001",null,"ENGLAND",36094,25011610,1.4235725225382014E-3,644001,10063227,6.4109720538224904E-2,{"$f":"H83+E83","v":680095},{"$f":"I83+F83","v":35074837},{"$f":"K83/L83","v":1.9389826387503955E-2},null,{"$f":"$M$83","v":1.9389826387503955E-2},{"$f":"M83","v":1.9389826387503955E-2},1.9344245324780802E-2,1.9435512724785532E-2,{"$f":"P83-Q83","v":4.558106272315246E-5},{"$f":"R83-P83","v":4.5686337281577311E-5}]
["Area Team","E39000004",null,"Lancashire (Area team)",{"$f":"SUM(E85:E98)","v":1029},{"$f":"SUM(F85:F98)","v":661753},1.5408405156011342E-3,{"$f":"SUM(H85:H98)","v":18315},{"$f":"SUM(I85:I98)","v":294477},6.2357831472933681E-2,{"$f":"H84+E84","v":19344},{"$f":"I84+F84","v":956230},{"$f":"K84/L84","v":2.0229442707298453E-2},null,{"$f":"$M$83","v":1.9389826387503955E-2},{"$f":"M84","v":2.0229442707298453E-2},1.994918742277426E-2,2.0513552736884606E-2,{"$f":"P84-Q84","v":2.8025528452419249E-4},{"$f":"R84-P84","v":2.8411002958615358E-4},{"$f":"IF($Q$83>R84,\"Low\",IF($R$83<Q84,\"High\",\"No diff\"))","v":"High"}]
["District","E06000008",null,"Blackburn with Darwen ",91,65792,1.3679926812927145E-3,1251,21416,5.9724411727099781E-2,1342,87208,{"$f":"K85/L85","v":1.5388496468213926E-2},null,1.9389826387503955E-2,{"$f":"M85","v":1.5388496468213926E-2},1.4592622131591255E-2,1.6227062602274016E-2,7.9587433662267094E-4,8.3856613406009008E-4,{"$f":"IF($Q$83>R85,\"Low\",IF($R$83<Q85,\"High\",\"No diff\"))","v":"Low"}]
["District","E06000009",null,"Blackpool ",98,62985,1.5238030837020453E-3,1835,28652,6.4263086242872289E-2,1933,91637,2.1094099544943637E-2,null,1.9389826387503955E-2,{"$f":"M86","v":2.1094099544943637E-2},2.0183590576724815E-2,2.2044758674734516E-2,9.1050896821882193E-4,9.5065912979087897E-4,"High"]
["District","E07000117",null,"Burnley",59,39179,{"$f":"E87/F87","v":1.5059087776615023E-3},984,16108,{"$f":"H87/I87","v":6.1087658306431585E-2},1043,55287,1.8865194349485411E-2,null,1.9389826387503955E-2,1.8865194349485411E-2,1.776412078860945E-2,2.0033123812508775E-2,1.1010735608759613E-3,1.1679294630233643E-3,"No diff"]
["District","E07000118",null,"Chorley",81,54728,{"$f":"E88/F88","v":1.4800467767870195E-3},1316,22618,{"$f":"H88/I88","v":5.8183747457776991E-2},1397,77346,1.8061696791042848E-2,null,1.9389826387503955E-2,1.8061696791042848E-2,1.714681452063363E-2,1.9024448484607329E-2,9.1488227040921813E-4,9.6275169356448143E-4,"Low"]
["District","E07000119",null,"Fylde",64,35366,1.8096476842164792E-3,1419,21035,6.7458996909912056E-2,1483,56401,2.6293860037942589E-2,null,1.9389826387503955E-2,2.6293860037942589E-2,2.5005250237552509E-2,2.7646993470797899E-2,1.2886098003900802E-3,1.35313343285531E-3,"High"]
["District","E07000120",null,"Hyndburn",53,35658,1.486342475741769E-3,880,14756,5.9636757928978046E-2,933,50414,1.8506763994128615E-2,null,1.9389826387503955E-2,1.8506763994128615E-2,1.7366451583113188E-2,1.9720448702927555E-2,1.1403124110154275E-3,1.2136847087989393E-3,"No diff"]
["District","E07000121",null,"Lancaster",94,59334,1.5842518623386255E-3,1829,28474,6.4234038069818075E-2,1923,87808,2.1900054664723032E-2,null,1.9389826387503955E-2,2.1900054664723032E-2,2.0952720733297361E-2,2.2889218973958122E-2,9.4733393142567082E-4,9.8916430923508963E-4,"High"]
["District","E07000122",null,"Pendle",62,40761,1.5210617992689091E-3,1010,16739,6.0338132504928609E-2,1072,57500,1.8643478260869564E-2,null,1.9389826387503955E-2,1.8643478260869564E-2,1.7569621722450364E-2,1.9781647415956564E-2,1.0738565384191996E-3,1.1381691550870002E-3,"No diff"]
["District","E07000123",null,"Preston",83,60564,1.3704510930585827E-3,1332,21013,6.3389330414505313E-2,1415,81577,1.7345575345992129E-2,null,1.9389826387503955E-2,1.7345575345992129E-2,1.6472136454707839E-2,1.8264468465592272E-2,8.7343889128429011E-4,9.1889311960014278E-4,"Low"]
["District","E07000124",null,"Ribble Valley",46,27071,1.6992353440951572E-3,875,13770,6.3543936092955694E-2,921,40841,2.2550868000293822E-2,null,1.9389826387503955E-2,2.2550868000293822E-2,2.1155252073243085E-2,2.4036292143709021E-2,1.3956159270507376E-3,1.4854241434151989E-3,"High"]
["District","E07000125",null,"Rossendale",51,33196,1.5363296782744909E-3,753,12741,5.9100541558747353E-2,804,45937,1.7502231316803448E-2,null,1.9389826387503955E-2,1.7502231316803448E-2,1.6342782276858227E-2,1.8742370881807278E-2,1.1594490399452206E-3,1.2401395650038297E-3,"Low"]
["District","E07000126",null,"South Ribble",79,50588,1.5616351703961414E-3,1403,23067,6.0822820479472843E-2,1482,73655,2.012083361618356E-2,null,1.9389826387503955E-2,2.012083361618356E-2,1.9131535295721539E-2,2.1160185291275193E-2,9.8929832046202107E-4,1.0393516750916328E-3,"No diff"]
["District","E07000127",null,"West Lancashire",82,48598,1.6873122350714021E-3,1489,24466,6.085996893648328E-2,1571,73064,2.150169714223147E-2,null,1.9389826387503955E-2,2.150169714223147E-2,2.0474829853310936E-2,2.2578877441349138E-2,1.0268672889205341E-3,1.0771802991176686E-3,"High"]
["District","E07000128",null,"Wyre",86,47933,1.7941710303965952E-3,1939,29622,6.545810546215651E-2,2025,77555,2.6110502224227967E-2,null,1.9389826387503955E-2,2.6110502224227967E-2,2.501146473389209E-2,2.7256482834317166E-2,1.0990374903358767E-3,1.1459806100891992E-3,"High"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Area","30-64","65+"]
[null,null,null,"ENGLAND",{"$f":"E83/K83","v":5.3071997294495625E-2},{"$f":"H83/K83","v":0.94692800270550437}]
[null,null,null,"Lancashire (Area team)",{"$f":"E84/K84","v":5.3194789081885858E-2},{"$f":"H84/K84","v":0.94680521091811409}]
[null,null,null,"Blackburn with Darwen ",6.7809239940387483E-2,0.93219076005961254]
[null,null,null,"Blackpool ",5.0698396275219867E-2,0.94930160372478012]
[null,null,null,"Burnley",5.6567593480345159E-2,0.94343240651965488]
[null,null,null,"Chorley",5.7981388690050109E-2,0.9420186113099499]
[null,null,null,"Fylde",4.315576534052596E-2,0.95684423465947399]
[null,null,null,"Hyndburn",5.6806002143622719E-2,0.94319399785637725]
[null,null,null,"Lancaster",4.8881955278211126E-2,0.95111804472178885]
[null,null,null,"Pendle",5.7835820895522388E-2,0.94216417910447758]
[null,null,null,"Preston",5.8657243816254416E-2,0.94134275618374563]
[null,null,null,"Ribble Valley",4.9945711183496201E-2,0.95005428881650378]
[null,null,null,"Rossendale",6.3432835820895525E-2,0.93656716417910446]
[null,null,null,"South Ribble",5.3306342780026994E-2,0.94669365721997301]
[null,null,null,"West Lancashire",5.2196053469127944E-2,0.94780394653087208]
[null,null,null,"Wyre",4.2469135802469138E-2,0.95753086419753086]

{"sheet":"Assessments and care plans","index":7,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,0,2,4],[0,0,1,4],[17,0,17,1],[11,0,11,1],[3,0,3,4]]}
["Dementia in Lancashire"]
[]
["Recorded dementia assessments and care plans, Lancashire, October 2017"]
[{"$f":"A6","v":"NHS Chorley and South Ribble "}]
[]
["NHS Chorley and South Ribble "]
[]
["Assessments for dementia at a GP practice","Number of patients"]
["Recorded of receiving an assessment",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A9,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":800}]
["Recorded as being ‘at risk of dementia’ and declined an assessment",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A10,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":37}]
[]
["Memory assessments and clinics"]
["Record of an initial memory assessment",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A13,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":209}]
["Record of declining an initial memory assessment",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A14,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":3}]
["Record of a referral to a memory clinic",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A15,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":49}]
["Record of declining a referral to a memory clinic",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A16,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":10}]
[]
["Care plans and reviews by a GP practice within the 12 month period"]
["Record of receiving a dementia care plan or dementia care plan review",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A19,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":1060}]
["Record of declining a dementia care plan or declining a dementia care plan review",{"$f":"SUM(IF('ass and care plans raw'!$A$7:$A$14='Assessments and care plans'!$A20,IF('ass and care plans raw'!$B$6:$J$6='Assessments and care plans'!$A$6,'ass and care plans raw'!$B$7:$J$14)))","v":10}]
[]
[]
["Source: NHS Digital"]

{"sheet":"ass and care plans raw","index":8,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
["MEASURE","NHS Blackburn with Darwen","NHS Blackpool","NHS Chorley and South Ribble ","NHS East Lancashire ","NHS Fylde & Wyre ","NHS Greater Preston ","NHS Morecambe Bay","NHS West Lancashire ","LANCASHIRE AND SOUTH CUMBRIA"]
["Record of a referral to a memory clinic",51,79,49,525,165,58,146,37,{"$f":"SUM(B7:I7)","v":1110}]
["Record of an initial memory assessment",534,306,209,2789,495,446,486,885,{"$f":"SUM(B8:I8)","v":6150}]
["Record of declining a dementia care plan or declining a dementia care plan review",5,43,10,17,22,3,9,1,110]
["Record of declining a referral to a memory clinic",3,17,10,53,9,10,93,12,207]
["Record of declining an initial memory assessment",21,15,3,114,13,29,24,14,233]
["Record of receiving a dementia care plan or dementia care plan review",836,1168,1060,2190,1441,1000,2374,717,10786]
["Recorded as being ‘at risk of dementia’ and declined an assessment",74,404,37,645,49,159,445,4,1817]
["Recorded of receiving an assessment",1170,764,800,5027,1016,1206,1683,1511,13177]
[]
[]
["LANCASHIRE AND SOUTH CUMBRIA"]
["NHS Blackburn with Darwen"]
["NHS Blackpool"]
["NHS Chorley and South Ribble "]
["NHS East Lancashire "]
["NHS Fylde & Wyre "]
["NHS Greater Preston "]
["NHS Morecambe Bay"]
["NHS West Lancashire "]
[]
["ASS_Received_GP_Mem_Clinic","Record of a referral to a memory clinic"]
["ASS_Received_GP_Mem_Ass","Record of an initial memory assessment"]
["DIAG_Declined_Care_Plan","Record of declining a dementia care plan or declining a dementia care plan review"]
["ASS_Declined_GP_Mem_Clinic","Record of declining a referral to a memory clinic"]
["ASS_Declined_GP_Mem_Ass","Record of declining an initial memory assessment"]
["DIAG_Received_Care_Plan","Record of receiving a dementia care plan or dementia care plan review"]
["ASS_Declined_GP","Recorded as being ‘at risk of dementia’ and declined an assessment"]
["ASS_Received_GP","Recorded of receiving an assessment"]

{"sheet":"Dementia diagnosis rates","index":9,"n_rows":91,"n_cols":12,"rows_kept":91,"cut":false,"hidden":false,"merged":[[29,0,29,16],[0,0,1,16],[2,0,2,16],[3,0,3,16],[5,0,8,16],[27,0,27,16],[28,0,28,16]]}
["Dementia in Lancashire"]
[]
["CCG diagnosis rates"]
[{"$f":"A13","v":"October : 2017"}]
[{"$f":"D14 & \" : \" &A4","v":"Dementia diagnosis rate (%) : October : 2017"}]
["The dementia diagnosis rates have been calculated using the monthly HSCIC QoF extracts and the CFAS  II estimated aged 65+ dementia prevalence.  These rates are influenced not only by a patient receiving a dementia diagnosis but also by patients registering or leaving a CCG and patients who have died and been removed from the dementia register.  Users should note that due to the way in which the monthly extracts are taken, not all practices are included within each extract. "]
[]
[]
[]
[]
[null,"<< Select month"]
["*Data available for months May 2016 to October 2017"]
["October : 2017",{"$f":"VLOOKUP(A13,'diagnosis rate backing data2'!A2:B14,2,FALSE)","v":{"$error":"#N/A"}},null,"rate",66.7]
["CCG","Dementia register (65+)","Estimated dementia 65+ prevalence (CFAS II)*","Dementia diagnosis rate (%)","Above or below target (66.7%)","Significance","Target",null,"Lower C.I","Upper C.I","L C.I","U C.I"]
["ENGLAND",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A15,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":439509},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A15,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":643033.30000000005},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A15,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":68.599999999999994},{"$f":"IF(D15>$E$13,\"p\",\"q\")","v":"p"},{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A15,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"In line"},{"$f":"$E$13","v":66.7},null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A15,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":61.7},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A15,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":74.3},{"$f":"D15-I15","v":6.8999999999999915},{"$f":"J15-D15","v":5.7000000000000028}]
["LANCASHIRE AND SOUTH CUMBRIA",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A16,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":15556},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A16,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":20944.5},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A16,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":74.3},{"$f":"IF(D16>$E$13,\"p\",\"q\")","v":"p"},{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A16,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"Above"},{"$f":"$E$13","v":66.7},null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A16,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":66.8},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A16,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":80.599999999999994},{"$f":"D16-I16","v":7.5},{"$f":"J16-D16","v":6.2999999999999972}]
["NHS Blackburn with Darwen",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A17,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":1127},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A17,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":1466.1},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A17,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":76.900000000000006},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A17,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"Above"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A17,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":67.900000000000006},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A17,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":84.7},{"$f":"D17-I17","v":9},{"$f":"J17-D17","v":7.7999999999999972}]
["NHS Blackpool",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A18,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":1790},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A18,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":2216},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A18,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":80.8},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A18,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"Above"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A18,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":71.900000000000006},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A18,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":88.4},{"$f":"D18-I18","v":8.8999999999999915},{"$f":"J18-D18","v":7.6000000000000085}]
["NHS Chorley and South Ribble ",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A19,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":1468},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A19,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":2104.1999999999998},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A19,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":69.8},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A19,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"In line"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A19,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":61.8},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A19,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":76.7},8,6.9000000000000057]
["NHS East Lancashire ",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A20,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":2908},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A20,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":3967.2},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A20,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":73.3},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A20,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"In line"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A20,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":65.400000000000006},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A20,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":80},7.8999999999999915,6.7000000000000028]
["NHS Fylde & Wyre ",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A21,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":2037},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A21,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":2631.7},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A21,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":77.400000000000006},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A21,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"Above"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A21,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":69.2},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A21,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":84.7},8.2000000000000028,7.2999999999999972]
["NHS Greater Preston ",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A22,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":1474},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A22,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":2212},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A22,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":66.599999999999994},"q",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A22,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"In line"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A22,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":59.2},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A22,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":73.099999999999994},7.3999999999999915,6.5]
["NHS Morecambe Bay",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A23,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":3692},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A23,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":4932.3},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A23,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":74.900000000000006},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A23,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"Above"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A23,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":67},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A23,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":81.5},7.9000000000000057,6.5999999999999943]
["NHS West Lancashire ",{"$f":"SUM(IF('diagnosis rate backing data2'!$A$27:$A$36='Dementia diagnosis rates'!A24,IF('diagnosis rate backing data2'!$B$26:$S$26='Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$B$27:$S$36)))","v":1060},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$41:$A$50='Dementia diagnosis rates'!$A24,IF('diagnosis rate backing data2'!$B$40:$S$40=$A$13,'diagnosis rate backing data2'!$B$41:$S$50)))","v":1415},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65=A24,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!D$13,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":74.900000000000006},"p",{"$f":"INDEX('diagnosis rate backing data2'!$A$70:$S$80,MATCH('Dementia diagnosis rates'!A24,'diagnosis rate backing data2'!$A$70:$A$80,0),MATCH('Dementia diagnosis rates'!$A$13,'diagnosis rate backing data2'!$A$70:$S$70,0))","v":"In line"},66.7,null,{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A24,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!I$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":66.099999999999994},{"$f":"SUM(IF('diagnosis rate backing data2'!$A$56:$A$65='Dementia diagnosis rates'!A24,IF('diagnosis rate backing data2'!$B$54:$BC$54='Dementia diagnosis rates'!$A$13,IF('diagnosis rate backing data2'!$B$55:$BC$55='Dementia diagnosis rates'!J$14,'diagnosis rate backing data2'!$B$56:$BC$65))))","v":82.6},8.8000000000000114,7.6999999999999886]
["*  CFAS estimate is based on the GP registered populations"]
[]
[]
[]
["CCG Dementia diagnosis rate trend lines"]
["May 2016 - October 2017"]
["NHS Blackburn with Darwen",{"$f":"A29 & \" : \" & A31","v":"CCG Dementia diagnosis rate trend lines : NHS Blackburn with Darwen"}]
[]
[null,"<< Select CCG"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NHS East Lancashire "]

{"sheet":"diagnosis rate backing data2","index":10,"n_rows":100,"n_cols":55,"rows_kept":100,"cut":false,"hidden":true,"merged":[]}
[]
["May : 2016",2016]
["June : 2016",2016]
["July : 2016",2016]
["August : 2016",2016]
["September : 2016",2016]
["October : 2016",2016]
["November : 2016",2016]
["December : 2016",2016]
["January : 2017",2017]
["February : 2017",2017]
["March : 2017",2017]
["April : 2017",2017]
["May : 2017",2017]
["June : 2017",2017]
["July : 2017",2017]
["August : 2017",2017]
["September : 2017",2017]
["October : 2017",2017]
[]
[]
[]
[]
[]
["65+"]
["Diagnosed patients","May : 2016","June : 2016","July : 2016","August : 2016","September : 2016","October : 2016","November : 2016","December : 2016","January : 2017","February : 2017","March : 2017","April : 2017","May : 2017","June : 2017","July : 2017","August : 2017","September : 2017","October : 2017"]
["ENGLAND",421791,424390,427028,429332,428912,430121,431786,431019,429421,428937,431226,432175,432478,431935,433793,434127,436777,439509]
["LANCASHIRE AND SOUTH CUMBRIA",14847,14994,15064,15215,14976,14991,15020,14926,14869,14901,14937,15066,15079,15069,15215,15282,15401,15556]
["NHS Blackburn with Darwen",1051,1056,1056,1045,1040,1045,1047,1035,1030,1036,1043,1042,1046,1057,997,977,1014,1127]
["NHS Blackpool",1650,1663,1673,1696,1718,1734,1736,1741,1710,1715,1720,1726,1727,1742,1757,1774,1783,1790]
["NHS Chorley and South Ribble ",1368,1386,1395,1396,1324,1319,1314,1307,1389,1393,1398,1408,1407,1422,1431,1435,1465,1468]
["NHS East Lancashire ",2851,2903,2856,2861,2794,2776,2785,2776,2741,2748,2786,2808,2801,2818,2829,2853,2865,2908]
["NHS Fylde & Wyre ",1817,1825,1854,1859,1881,1894,1920,1904,1872,1890,1909,1949,1959,1977,1993,2037,2034,2037]
["NHS Greater Preston ",1450,1470,1504,1519,1502,1506,1525,1500,1456,1447,1428,1431,1440,1443,1461,1475,1477,1474]
["NHS Morecambe Bay",3628,3656,3678,3788,3670,3663,3640,3617,3621,3625,3617,3663,3646,3656,3682,3697,3707,3692]
["NHS West Lancashire ",1032,1035,1048,1051,1047,1054,1053,1046,1050,1047,1036,1039,1053,1070,1065,1034,1056,1060]
[]
[]
[]
["Estimated prev patients","May : 2016","June : 2016","July : 2016","August : 2016","September : 2016","October : 2016","November : 2016","December : 2016","January : 2017","February : 2017","March : 2017","April : 2017","May : 2017","June : 2017","July : 2017","August : 2017","September : 2017","October : 2017"]
["ENGLAND",626483.19999999995,627819.69999999995,630057.19999999995,631381.4,629814.9,631012.1,631299.9,632442.30000000005,633253.5,633296,634707.30000000005,636161.19999999995,638289.6,639997.6,639473.4,641022,642495.9,643033.30000000005]
["LANCASHIRE AND SOUTH CUMBRIA",20811.8,20855.2,20924.400000000001,20951,20690.8,20706.3,20590.7,20707.400000000001,20761.900000000001,20771.099999999999,20791.599999999999,20762.599999999999,20901.400000000001,20938.2,18255.699999999997,20850.8,20949.400000000001,20944.5]
["NHS Blackburn with Darwen",1484.8,1485.9,1493.9,1494,1494.1,1492.6,1491.8,1492,1486.8,1486.6,1491.2,1492.9,1497.8,1505.4,1344.5,1345.4,1351.1,1466.1]
["NHS Blackpool",2197.3000000000002,2197.1,2204.1,2207.1999999999998,2209.6999999999998,2211.6,2213.9,2212.1,2200.4,2197.8000000000002,2192.9,2197.9,2203,2207.6999999999998,2213.1999999999998,2217.6,2217.1,2216]
["NHS Chorley and South Ribble ",2022.3,2029.8,2036.1,2040.2,1929,1933.2,1931,1931.9,2051,2059.6999999999998,2063.8000000000002,2067.1,2074.1999999999998,2078.5,2088.1,2097.6,2104.1999999999998,2104.1999999999998]
["NHS East Lancashire ",4016.8,4027.4,4040.7,4046.3,3909.6,3907,3909.7,3909.6,3896,3900.3,3906.5,3916.3,3927,3932.3,2165.8000000000002,3954.4,3967.2,3967.2]
["NHS Fylde & Wyre ",2570.6,2574.5,2576.5,2576.5,2584.1,2586.9,2590.6,2591.6999999999998,2582.9,2579.6,2576.3000000000002,2585.9,2592.8000000000002,2597.5,1405.6,2620.8000000000002,2631.7,2631.7]
["NHS Greater Preston ",2175.1999999999998,2182.5,2185.9,2189.5,2153.1,2151.8000000000002,2156.6999999999998,2160.3000000000002,2143,2142.6999999999998,2147.8000000000002,2154.6999999999998,2156.8000000000002,2159.6,2609,2169.6999999999998,2212,2212]
["NHS Morecambe Bay",4942.7,4953.5,4976.1000000000004,4981.8,4992.2,4999.3999999999996,4876,4987.8999999999996,4979.3,4981.2,4991.3999999999996,4921.2,5017,5018.3,5023.8999999999996,5036.6000000000004,5051,4932.3]
["NHS West Lancashire ",1402.2,1404.5,1411,1415.6,1418.9,1423.8,1421,1421.9,1422.4,1423.3,1421.8,1426.6,1432.7,1438.9,1405.6,1408.8,1415,1415]
[]
[]
[]
[null,"May : 2016","May : 2016","May : 2016","June : 2016","June : 2016","June : 2016","July : 2016","July : 2016","July : 2016","August : 2016","August : 2016","August : 2016","September : 2016","September : 2016","September : 2016","October : 2016","October : 2016","October : 2016","November : 2016","November : 2016","November : 2016","December : 2016","December : 2016","December : 2016","January : 2017","January : 2017","January : 2017","February : 2017","February : 2017","February : 2017","March : 2017","March : 2017","March : 2017","April : 2017","April : 2017","April : 2017","May : 2017","May : 2017","May : 2017","June : 2017","June : 2017","June : 2017","July : 2017","July : 2017","July : 2017","August : 2017","August : 2017","August : 2017","September : 2017","September : 2017","September : 2017","October : 2017","October : 2017","October : 2017"]
["Diagnosis rate","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I","Rate","Lower C.I","Upper C.I"]
["ENGLAND",67.3,60.6,73,67.599999999999994,60.8,73.3,67.8,61,73.5,68,61.2,73.7,68.099999999999994,61.3,73.8,68.2,61.4,73.900000000000006,68.400000000000006,61.6,74.099999999999994,68.2,61.3,73.8,67.8,61.1,73.5,67.7,61,73.400000000000006,67.900000000000006,61.2,73.599999999999994,67.900000000000006,61.2,73.599999999999994,67.8,61,73.400000000000006,68,61.2,73.7,68,61.3,73.7,68.2,61.4,73.900000000000006,68.2,61.4,73.900000000000006,68.599999999999994,61.7,74.3]
["LANCASHIRE AND SOUTH CUMBRIA",71.3,64.099999999999994,77.400000000000006,71.900000000000006,64.599999999999994,78,72,64.7,78.099999999999994,72.599999999999994,65.3,78.900000000000006,72.400000000000006,65,78.599999999999994,72.400000000000006,65,78.5,72.900000000000006,65.599999999999994,79.2,72.099999999999994,64.7,78.3,71.599999999999994,64.3,77.8,71.7,64.5,77.900000000000006,71.8,64.599999999999994,78,72.599999999999994,65.2,78.8,72.099999999999994,64.8,78.400000000000006,72.5,65.2,78.7,73.2,65.8,79.400000000000006,73.599999999999994,66.2,79.900000000000006,73.900000000000006,66.3,80.099999999999994,74.3,66.8,80.599999999999994]
["NHS Blackburn with Darwen",70.8,62.4,78.099999999999994,71.099999999999994,62.7,78.400000000000006,70.7,62.3,77.900000000000006,69.900000000000006,61.7,77.2,69.599999999999994,61.4,76.8,70,61.8,77.2,70.2,62,77.400000000000006,69.400000000000006,61.2,76.599999999999994,69.3,61.1,76.400000000000006,69.7,61.5,76.900000000000006,69.900000000000006,61.7,77.2,69.8,61.6,77,69.8,61.6,77,70.2,61.9,77.400000000000006,74.2,65.400000000000006,81.8,74,65.3,81.7,75.099999999999994,66.2,82.7,76.900000000000006,67.900000000000006,84.7]
["NHS Blackpool",75.099999999999994,66.8,82.4,75.7,67.3,83,75.900000000000006,67.5,83.2,76.8,68.400000000000006,84.2,77.7,69.3,85.2,78.400000000000006,69.8,85.9,78.400000000000006,69.900000000000006,85.9,78.7,70.099999999999994,86.2,77.7,69.099999999999994,85.1,78,69.5,85.4,78.400000000000006,69.900000000000006,85.9,78.5,69.900000000000006,86.1,78.400000000000006,69.8,85.9,78.900000000000006,70.2,86.5,79.400000000000006,70.7,87,80,71.3,87.7,80.400000000000006,71.599999999999994,88,80.8,71.900000000000006,88.4]
["NHS Chorley and South Ribble ",67.599999999999994,59.8,74.400000000000006,68.3,60.4,75.099999999999994,68.5,60.6,75.3,68.400000000000006,60.6,75.3,68.599999999999994,60.6,75.5,68.2,60.3,75.099999999999994,68,60.2,74.900000000000006,67.7,59.8,74.5,67.7,59.9,74.400000000000006,67.599999999999994,59.9,74.3,67.7,60,74.5,68.099999999999994,60.3,74.8,67.8,60.1,74.599999999999994,68.400000000000006,60.6,75.2,69.099999999999994,61.2,75.900000000000006,69,61.1,75.8,69.599999999999994,61.6,76.5,69.8,61.8,76.7]
["NHS East Lancashire ",71,63.3,77.5,72.099999999999994,64.3,78.7,70.7,63.1,77.2,70.7,63,77.2,71.5,63.6,78,71.099999999999994,63.4,77.599999999999994,71.2,63.6,77.900000000000006,71,63.4,77.5,70.400000000000006,62.8,76.8,70.5,62.8,76.900000000000006,71.3,63.6,77.900000000000006,71.7,64,78.400000000000006,71.3,63.7,77.900000000000006,71.7,63.9,78.2,67.5,59.9,74,72.099999999999994,64.400000000000006,78.8,72.2,64.5,78.8,73.3,65.400000000000006,80]
["NHS Fylde & Wyre ",70.7,63.1,77.400000000000006,70.900000000000006,63.2,77.599999999999994,72,64.2,78.8,72.2,64.400000000000006,79,72.8,64.900000000000006,79.7,73.2,65.3,80.099999999999994,74.099999999999994,66.099999999999994,81.099999999999994,73.5,65.599999999999994,80.400000000000006,72.5,64.7,79.3,73.3,65.400000000000006,80.2,74.099999999999994,66.099999999999994,81,75.400000000000006,67.3,82.4,75.599999999999994,67.400000000000006,82.6,76.099999999999994,68,83.2,75.8,66.900000000000006,83.5,77.7,69.400000000000006,85,77.3,69.099999999999994,84.5,77.400000000000006,69.2,84.7]
["NHS Greater Preston ",66.7,59.2,73.2,67.400000000000006,59.8,73.900000000000006,68.8,61.1,75.599999999999994,69.400000000000006,61.6,76.099999999999994,69.8,61.9,76.599999999999994,70,62.2,76.900000000000006,70.7,62.8,77.599999999999994,69.400000000000006,61.7,76.2,67.900000000000006,60.4,74.599999999999994,67.5,60,74.099999999999994,66.5,59,73,66.400000000000006,58.9,72.900000000000006,66.8,59.3,73.3,66.8,59.3,73.400000000000006,76.400000000000006,68.2,83.5,68,60.4,74.599999999999994,66.8,59.4,73.3,66.599999999999994,59.2,73.099999999999994]
["NHS Morecambe Bay",73.400000000000006,65.7,79.900000000000006,73.8,66,80.5,73.900000000000006,66.099999999999994,80.599999999999994,76,68.099999999999994,82.8,73.5,65.8,80.2,73.3,65.5,79.900000000000006,74.7,66.8,81.400000000000006,72.5,64.900000000000006,79,72.7,65.099999999999994,79.2,72.8,65.2,79.3,72.5,64.900000000000006,79,74.400000000000006,66.7,81.099999999999994,72.7,65.099999999999994,79.2,72.900000000000006,65.2,79.3,73.3,65.7,79.900000000000006,73.400000000000006,65.7,80,74.8,67,81.5,74.900000000000006,67,81.5]
["NHS West Lancashire ",73.599999999999994,64.900000000000006,81.2,73.7,65,81.3,74.3,65.5,82,74.2,65.5,81.900000000000006,73.8,65.099999999999994,81.400000000000006,74,65.3,81.7,74.099999999999994,65.3,81.7,73.599999999999994,64.900000000000006,81.3,73.8,65.099999999999994,81.5,73.599999999999994,64.900000000000006,81.2,72.900000000000006,64.3,80.400000000000006,72.8,64.2,80.3,73.5,64.900000000000006,81,74.400000000000006,65.7,82,75.8,66.900000000000006,83.5,75.5,66.599999999999994,83.2,74.599999999999994,65.900000000000006,82.3,74.900000000000006,66.099999999999994,82.6]
[]
[]
[]
["Target",66.7]
["Significance from target","May : 2016","June : 2016","July : 2016","August : 2016","September : 2016","October : 2016","November : 2016","December : 2016","January : 2017","February : 2017","March : 2017","April : 2017","May : 2017","June : 2017","July : 2017","August : 2017","September : 2017","October : 2017"]
["ENGLAND",{"$f":"IF(C56>$B$69,\"Above\",IF(D56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(F56>$B$69,\"Above\",IF(G56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(I56>$B$69,\"Above\",IF(J56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(L56>$B$69,\"Above\",IF(M56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(O56>$B$69,\"Above\",IF(P56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(R56>$B$69,\"Above\",IF(S56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(U56>$B$69,\"Above\",IF(V56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(X56>$B$69,\"Above\",IF(Y56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AA56>$B$69,\"Above\",IF(AB56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AD56>$B$69,\"Above\",IF(AE56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AG56>$B$69,\"Above\",IF(AH56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AJ56>$B$69,\"Above\",IF(AK56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AM56>$B$69,\"Above\",IF(AN56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AP56>$B$69,\"Above\",IF(AQ56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AS56>$B$69,\"Above\",IF(AT56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AV56>$B$69,\"Above\",IF(AW56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AY56>$B$69,\"Above\",IF(AZ56<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(BB56>$B$69,\"Above\",IF(BC56<$B$69,\"Below\",\"In line\"))","v":"In line"}]
["LANCASHIRE AND SOUTH CUMBRIA",{"$f":"IF(C57>$B$69,\"Above\",IF(D57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(F57>$B$69,\"Above\",IF(G57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(I57>$B$69,\"Above\",IF(J57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(L57>$B$69,\"Above\",IF(M57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(O57>$B$69,\"Above\",IF(P57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(R57>$B$69,\"Above\",IF(S57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(U57>$B$69,\"Above\",IF(V57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(X57>$B$69,\"Above\",IF(Y57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AA57>$B$69,\"Above\",IF(AB57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AD57>$B$69,\"Above\",IF(AE57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AG57>$B$69,\"Above\",IF(AH57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AJ57>$B$69,\"Above\",IF(AK57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AM57>$B$69,\"Above\",IF(AN57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AP57>$B$69,\"Above\",IF(AQ57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AS57>$B$69,\"Above\",IF(AT57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AV57>$B$69,\"Above\",IF(AW57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(AY57>$B$69,\"Above\",IF(AZ57<$B$69,\"Below\",\"In line\"))","v":"In line"},{"$f":"IF(BB57>$B$69,\"Above\",IF(BC57<$B$69,\"Below\",\"In line\"))","v":"Above"}]
["NHS Blackburn with Darwen","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","Above"]
["NHS Blackpool","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above","Above"]
["NHS Chorley and South Ribble ","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line"]
["NHS East Lancashire ","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line"]
["NHS Fylde & Wyre ","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","Above","Above","Above","Above","Above","Above","Above"]
["NHS Greater Preston ","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","Above","In line","In line","In line"]
["NHS Morecambe Bay","In line","In line","In line","Above","In line","In line","Above","In line","In line","In line","In line","In line","In line","In line","In line","In line","Above","Above"]
["NHS West Lancashire ","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","In line","Above","In line","In line","In line"]
[]
[]
[]
[]
["Diagnosis rate trend chart data","May : 2016","June : 2016","July : 2016","August : 2016","September : 2016","October : 2016","November : 2016","December : 2016","January : 2017","February : 2017","March : 2017","April : 2017","May : 2017","June : 2017","July : 2017","August : 2017","September : 2017","October : 2017"]
["Target",66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7,66.7]
["ENGLAND",67.3,67.599999999999994,67.8,68,68.099999999999994,68.2,68.400000000000006,68.2,67.8,67.7,67.900000000000006,67.900000000000006,67.8,68,68,68.2,68.2,68.599999999999994]
["LANCASHIRE AND SOUTH CUMBRIA",71.3,71.900000000000006,72,72.599999999999994,72.400000000000006,72.400000000000006,72.900000000000006,72.099999999999994,71.599999999999994,71.7,71.8,72.599999999999994,72.099999999999994,72.5,73.2,73.599999999999994,73.900000000000006,74.3]
["NHS Blackburn with Darwen",70.8,71.099999999999994,70.7,69.900000000000006,69.599999999999994,70,70.2,69.400000000000006,69.3,69.7,69.900000000000006,69.8,69.8,70.2,74.2,74,75.099999999999994,76.900000000000006]
["NHS Blackpool",75.099999999999994,75.7,75.900000000000006,76.8,77.7,78.400000000000006,78.400000000000006,78.7,77.7,78,78.400000000000006,78.5,78.400000000000006,78.900000000000006,79.400000000000006,80,80.400000000000006,80.8]
["NHS Chorley and South Ribble ",67.599999999999994,68.3,68.5,68.400000000000006,68.599999999999994,68.2,68,67.7,67.7,67.599999999999994,67.7,68.099999999999994,67.8,68.400000000000006,69.099999999999994,69,69.599999999999994,69.8]
["NHS East Lancashire ",71,72.099999999999994,70.7,70.7,71.5,71.099999999999994,71.2,71,70.400000000000006,70.5,71.3,71.7,71.3,71.7,67.5,72.099999999999994,72.2,73.3]
["NHS Fylde & Wyre ",70.7,70.900000000000006,72,72.2,72.8,73.2,74.099999999999994,73.5,72.5,73.3,74.099999999999994,75.400000000000006,75.599999999999994,76.099999999999994,75.8,77.7,77.3,77.400000000000006]
["NHS Greater Preston ",66.7,67.400000000000006,68.8,69.400000000000006,69.8,70,70.7,69.400000000000006,67.900000000000006,67.5,66.5,66.400000000000006,66.8,66.8,76.400000000000006,68,66.8,66.599999999999994]
["NHS Morecambe Bay",73.400000000000006,73.8,73.900000000000006,76,73.5,73.3,74.7,72.5,72.7,72.8,72.5,74.400000000000006,72.7,72.900000000000006,73.3,73.400000000000006,74.8,74.900000000000006]
["NHS West Lancashire ",73.599999999999994,73.7,74.3,74.2,73.8,74,74.099999999999994,73.599999999999994,73.8,73.599999999999994,72.900000000000006,72.8,73.5,74.400000000000006,75.8,75.5,74.599999999999994,74.900000000000006]
[]
[]
[null,"May : 2016","June : 2016","July : 2016","August : 2016","September : 2016","October : 2016","November : 2016","December : 2016","January : 2017","February : 2017","March : 2017","April : 2017","May : 2017","June : 2017","July : 2017","August : 2017","September : 2017","October : 2017"]
["NHS Blackburn with Darwen",{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=B99,$B$87:$S$96)))","v":70.8},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=C99,$B$87:$S$96)))","v":71.099999999999994},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=D99,$B$87:$S$96)))","v":70.7},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=E99,$B$87:$S$96)))","v":69.900000000000006},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=F99,$B$87:$S$96)))","v":69.599999999999994},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=G99,$B$87:$S$96)))","v":70},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=H99,$B$87:$S$96)))","v":70.2},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=I99,$B$87:$S$96)))","v":69.400000000000006},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=J99,$B$87:$S$96)))","v":69.3},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=K99,$B$87:$S$96)))","v":69.7},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=L99,$B$87:$S$96)))","v":69.900000000000006},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=M99,$B$87:$S$96)))","v":69.8},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=N99,$B$87:$S$96)))","v":69.8},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=O99,$B$87:$S$96)))","v":70.2},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=P99,$B$87:$S$96)))","v":74.2},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=Q99,$B$87:$S$96)))","v":74},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=R99,$B$87:$S$96)))","v":75.099999999999994},{"$f":"SUM(IF($A$87:$A$96=$A$100,IF($B$85:$S$85=S99,$B$87:$S$96)))","v":76.900000000000006}]

{"sheet":"Social care support","index":11,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[2,0,4,18],[0,0,0,20],[1,0,1,20]]}
["Dementia in Lancashire"]
["Social care support"]
["Between April 1st 2016 and March 31st 2017 a total of 3,423 individuals received social care support from Lancashire county council, that were also recorded as having dementia diagnosis"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Primary Support Reason (clients recorded as having dementia)","1 Nursing","2 Residential","3 Direct payments only","4 Part direct payment","5 Managed personal budget","6 CASSR support only","Total","% of total"]
[null,null,null,null,null,null,null,null,null,null,null,"Physical Support - Access and Mobility Only",78,164,28,23,137,23,453,{"$f":"S46/$S$56","v":0.13234005258545137}]
[null,null,null,null,null,null,null,null,null,null,null,"Physical Support - Personal Care Support",316,712,56,46,453,83,1666,{"$f":"S47/$S$56","v":0.48670756646216767}]
[null,null,null,null,null,null,null,null,null,null,null,"Sensory Support - Support for Visual Impairment",2,9,0,0,3,1,15,4.3821209465381246E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Sensory Support - Support for Hearing Impairment",2,9,0,0,4,0,15,4.3821209465381246E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Sensory Support - Support for Dual Impairment",1,1,0,0,0,0,2,5.842827928717499E-4]
[null,null,null,null,null,null,null,null,null,null,null,"Support with Memory and Cognition",211,473,30,30,205,51,1000,0.29214139643587494]
[null,null,null,null,null,null,null,null,null,null,null,"Learning Disability Support",6,6,1,2,36,3,54,1.5775635407537247E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Mental Health Support",53,77,8,2,29,12,181,5.2877592754893371E-2]
[null,null,null,null,null,null,null,null,null,null,null,"Social Support - Substance Misuse Support",2,2,0,0,1,0,5,1.4607069821793749E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Social Support - Support for Social Isolation / Other",5,10,1,0,13,3,32,9.3485246859479985E-3]
[null,null,null,null,null,null,null,null,null,null,null,"Total",676,1463,124,103,881,176,3423,"-"]
[]
[]
[]
[]
["Source :  Lancashire county council LAS data extract - April 28th 2017"]

{"sheet":"Hospital activity","index":12,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[10,5,12,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Double click to view"]
[]
[null,null,null,null,null,"All data is for January 2016 to December 2016 (12 months data) unless otherwise stated."]

{"sheet":"Dementia prescribing","index":13,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,0,1,18],[0,0,0,18],[47,0,47,18],[49,5,49,8],[49,1,49,4],[2,0,2,18]]}
["Dementia in Lancashire"]
["Drugs for dementia"]
["April 2016 - March 2017"]
[]
["CCG Name","Dementia register1","Time frame","Chapter Name","Section","Section Name","Items","Items prescribed per patient1","Actual Cost","Actual cost per item","Cost per registered dementia patient2","NIC","NIC per item","NIC per registered dementia patient2","Total prescribing cost for this period","% of total cost relating to dementia drugs","Total prescribing NIC for this period","% of total NIC relating to dementia drugs"]
["NHS Blackburn with Darwen",1104,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",6388,{"$f":"G6/B6","v":5.7862318840579707},66392.84,{"$f":"I6/G6","v":10.393368816530995},{"$f":"I6/B6","v":60.138442028985502},71548.19,{"$f":"L6/G6","v":11.200405447714465},{"$f":"L6/B6","v":64.80814311594203},26632797.759999998,{"$f":"I6/O6","v":2.4928976894690318E-3},28608496.73,{"$f":"L6/Q6","v":2.5009419640344729E-3}]
["NHS Blackpool",1792,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",12985,{"$f":"G7/B7","v":7.24609375},105440.18,8.1201524836349623,58.839386160714284,113146.97999999998,8.7136680785521747,63.140055803571421,32464862.25,{"$f":"I7/O7","v":3.2478246538686605E-3},34863157.310000002,{"$f":"L7/Q7","v":3.2454599276223722E-3}]
["NHS Chorley and South Ribble ",1452,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",9794,6.7451790633608812,80581.05,8.2275934245456401,55.496590909090912,86577.62,8.8398631815397177,59.626460055096416,28241879.600000001,2.8532467081263243E-3,30368285.379999999,2.8509222340560077E-3]
["NHS East Lancashire ",2981,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",18903,6.3411606843341159,207176.38999999998,10.959974078188646,69.498956725930896,223247.16999999998,11.810144950536952,74.890026836632003,63345735.799999997,3.2705656881800715E-3,68127247.600000009,3.2769145659716915E-3]
["NHS Fylde & Wyre ",1982,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",15288,7.7134207870837539,115954.03,7.5846435112506541,58.503546922300707,124357.81,8.1343413134484557,62.743597376387484,28061319.149999999,4.1321660389582937E-3,30157000.209999997,4.123679713964495E-3]
["NHS Greater Preston ",1496,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",13723,9.1731283422459899,100573.72,7.328843547329301,67.228422459893054,107860.12,7.8598061648327624,72.099010695187161,32949243.620000001,3.0523832704600338E-3,35396308.420000002,3.0472138145077217E-3]
["NHS Lancashire North",1578,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",8300,5.2598225602027879,107684.87999999999,12.974081927710841,68.241368821292767,115883.28000000001,13.961840963855423,73.436806083650197,25026456.460000001,4.3028416816465265E-3,26908298.449999999,4.3066000704329198E-3]
["NHS West Lancashire ",1075,"April 2016 - March 2017","Central Nervous System",11,"Drugs for Dementia",7652,7.1181395348837206,101546.69,13.270607684265551,94.462037209302324,109284.19,14.281781233664402,101.65971162790697,18913169.759999998,5.3690994840412207E-3,20334064.939999998,5.3744389192454311E-3]
["1 Based on the August 2017 QoF dementia register extract, except Lancashire North which comes from QOF 2015/16"]
["2 : Cost per item / total dementia register"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Actual Cost"]
["The actual cost is the basic price of the drug less an approximation of discount based on the National Average Discount Percentage (NADP) plus the container cost. "]
["The calculation for the discount amount is the basic price multiplied by the NADP."]
["This cost includes any Out of Pocket Expenses which have been claimed for that particular item."]
[]
["Net ingredient Cost (NIC)"]
["The net ingredient cost is the basic price of the drug as stated in Part II Clause 8 of the Drug Tariff. "]
["The NIC does not include out of pocket expenses, except in the Prescribing Cost Analysis (PCA) reports available through the Health and Social Care Information Centre."]
["This is the cost that is charged back to the Clinical Commissioning Group (CCG) or Area Team (AT)."]
[]
["Drugs for dementia - Items prescribed and NIC per registered patient April 2016 - March 2017"]
[]
[null,"Items prescribed per patient",null,null,null,"NIC per registered dementia patient"]
["CCG Name","April to June 2016","July to September 2016","October to December 2016","January - March 2017","April to June 2016","July to September 2016","October to December 2016","January - March 2017"]
["NHS Blackburn with Darwen",1.5580933465739821,1.6107249255213505,1.6097318768619662,1.5650446871896724,17.486027805362465,20.369612711022842,17.464160873882822,15.73103277060576]
["NHS Blackpool",1.7679866146123815,1.7685443390964863,1.8516452872281093,1.8538761851645287,16.374054656999441,15.991795872838818,16.298828778583378,14.44016174010039]
["NHS Chorley and South Ribble ",1.6529209621993126,1.7113402061855669,1.7030927835051546,1.663917525773196,15.015257731958764,16.029044673539516,14.873553264604812,13.585663230240549]
["NHS East Lancashire ",1.662671836446951,1.6711314769122312,1.6831159675713783,1.6461050405357773,19.58354599929503,21.417835741980966,19.191660204441309,18.498241099753262]
["NHS Fylde & Wyre ",1.9121588089330024,1.8942928039702234,1.8650124069478908,1.9156327543424319,16.034526054590572,15.582605459057072,15.343389578163771,14.75551364764268]
["NHS Greater Preston ",2.23,2.2946666666666666,2.3559999999999999,2.2679999999999998,16.200726666666668,18.747173333333333,19.90502,17.053826666666669]
["NHS Lancashire North",1.3485424588086186,1.349809885931559,1.2775665399239544,1.2839036755386566,17.884974651457544,18.90374524714829,19.418916349809887,17.229169835234476]
["NHS West Lancashire ",1.8392523364485982,1.8056074766355139,1.811214953271028,1.6953271028037382,25.625121495327104,29.001691588785047,26.196635514018691,21.311308411214952]

{"sheet":"End of life","index":14,"n_rows":9,"n_cols":6,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,1,16],[2,0,2,16],[3,0,3,16]]}
["Dementia in Lancashire"]
[]
["End of life analysis"]
["January 1st - December 31st 2016"]
[]
["Mortality amongst patients registered to the six Lancashire county CCGs, with a recorded dementia diagnoses"]
["Due to data confidentially rules, we do not have access to data relating to patients registered with the Blackburn with Darwen or Blackpool CCGs"]
[]
["Total deaths with a recorded dementia diagnosis  :",null,null,null,null,1964]

{"sheet":"2017-26 dementia projection","index":15,"n_rows":35,"n_cols":19,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,0,37,3],[0,14,1,18],[0,0,0,12],[3,17,4,17],[3,18,4,18],[26,0,27,0],[1,0,1,12],[3,14,4,14],[23,0,23,7],[26,2,27,2],[26,1,27,1],[26,7,27,7],[26,8,27,8],[26,9,27,9],[26,10,27,10],[26,3,27,3],[26,4,27,4],[26,5,27,5],[26,6,27,6],[3,0,4,0],[3,11,3,12],[23,14,23,18],[25,1,25,4],[25,5,25,8],[25,9,25,10],[3,1,3,5],[3,6,3,10]]}
["Dementia in Lancashire",null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-based Subnational Population Projections"]
["District level estimated 65+ dementia prevalence 2017 to 2026 projection"]
[]
["People aged 65 and over predicted to have dementia, by age and gender, projected to 2026",2017,null,null,null,null,2026,null,null,null,null,"Difference",null,null,"Area",2017,2026,"% change in 65+ population between 2016 and 2026","Change rank"]
[null,"2017 estimated 65+ dementia count","Estimated 2017 65+ population","65+ Dementia Prevalence","Rank","Significance","2026 estimated 65+ dementia count","Estimated 2026 65+ population","65+ Dementia Prevalence","Rank","Significance","2016 - 2026 Change actual","2016 - 2026 % change",null,null,"65+","65+"]
["England",644001,10063227,{"$f":"B6/C6","v":6.399547580512692E-2},null,null,822645,11994067,{"$f":"G6/H6","v":6.8587660882668072E-2},null,null,{"$f":"G6-B6","v":178644},{"$f":"(G6-B6)/ABS(B6)","v":0.27739708478713543},null,"England",10063227,11994067,{"$f":"(Q6-P6)/P6","v":0.19187085812533097}]
["Lancashire-12",{"$f":"SUM(B11:B22)","v":15229},{"$f":"SUM(C11:C22)","v":244406},6.2310254249077351E-2,null,"Low",{"$f":"SUM(G11:G22)","v":19326},{"$f":"SUM(H11:H22)","v":284204},{"$f":"G7/H7","v":6.8000450380712452E-2},null,"-",4097,0.26902620001313282,null,"Lancashire-12",{"$f":"C7","v":244406},{"$f":"H7","v":284204},0.16283560960041898]
["Lancashire-14",{"$f":"SUM(B9:B22)","v":18315},{"$f":"SUM(C9:C22)","v":294476},{"$f":"B8/C8","v":6.2195221342316524E-2},null,"Low",{"$f":"SUM(G9:G22)","v":22950},{"$f":"SUM(H9:H22)","v":340169},6.7466465198180905E-2,null,"Low",{"$f":"G8-B8","v":4635},{"$f":"(G8-B8)/ABS(B8)","v":0.25307125307125306},null,"Lancashire-14",{"$f":"C8","v":294476},{"$f":"H8","v":340169},0.15516714435132234]
["Blackburn with Darwen",1251,21417,{"$f":"B9/C9","v":5.8411542232805716E-2},{"$f":"RANK(D9,$D$9:$D$22)","v":13},"Low",1511,24955,{"$f":"G9/H9","v":6.0548988178721702E-2},{"$f":"RANK(I9,$I$9:$I$22)","v":14},"Low",{"$f":"G9-B9","v":260},{"$f":"(G9-B9)/ABS(B9)","v":0.20783373301358912},null,"Blackburn with Darwen",21417,24955,0.16519587243778308,{"$f":"RANK(R9,$R$9:$R$22)& \"/\" & COUNTA($O$9:$O$22)","v":"6/14"}]
["Blackpool",1835,28653,{"$f":"B10/C10","v":6.4042159634244228E-2},{"$f":"RANK(D10,$D$9:$D$22)","v":4},"-",2113,31010,{"$f":"G10/H10","v":6.8139309900032252E-2},{"$f":"RANK(I10,$I$9:$I$22)","v":6},"-",{"$f":"G10-B10","v":278},{"$f":"(G10-B10)/ABS(B10)","v":0.15149863760217983},null,"Blackpool",28653,31010,8.2260147279516985E-2,{"$f":"RANK(R10,$R$9:$R$22)& \"/\" & COUNTA($O$9:$O$22)","v":"14/14"}]
["Burnley",984,16108,6.1087658306431585E-2,7,"-",1206,18338,6.5765077980150508E-2,11,"-",222,0.22560975609756098,null,"Burnley",16108,18338,0.13844052644648622,"11/14"]
["Chorley",1316,22617,{"$f":"B12/C12","v":5.8186320024760138E-2},14,"Low",1846,27732,6.6565700274051634E-2,8,"-",530,0.40273556231003038,null,"Chorley",22617,27732,{"$f":"(Q12-P12)/P12","v":0.22615731529380553},"1/14"]
["Fylde",1419,21034,6.746220405058477E-2,1,"High",1795,25031,7.1711078262953934E-2,1,"-",376,0.26497533474277662,null,"Fylde",21034,25031,0.19002567272035753,"3/14"]
["Hyndburn",880,14756,5.9636757928978046E-2,11,"Low",1106,16753,6.6018026622097534E-2,9,"-",226,0.25681818181818183,null,"Hyndburn",14756,16753,0.13533477907291949,"13/14"]
["Lancaster",1829,28474,6.4234038069818075E-2,3,"-",2242,32606,6.876035085567074E-2,5,"-",413,0.22580645161290322,null,"Lancaster",28474,32606,0.14511484160988972,"9/14"]
["Pendle",1010,16740,6.0334528076463563E-2,10,"-",1250,19365,6.454944487477407E-2,12,"Low",240,0.23762376237623761,null,"Pendle",16740,19365,0.15681003584229392,"7/14"]
["Preston",1332,21013,6.3389330414505313E-2,6,"-",1586,24045,6.5959658972759405E-2,10,"-",254,0.1906906906906907,null,"Preston",21013,24045,0.14429162899157663,"10/14"]
["Ribble Valley",875,13770,6.3543936092955694E-2,5,"-",1154,16314,7.0736790486698536E-2,2,"-",279,0.31885714285714284,null,"Ribble Valley",13770,16314,0.18474945533769063,"4/14"]
["Rossendale",753,12740,5.910518053375196E-2,12,"Low",983,15315,6.4185439111981712E-2,13,"Low",230,0.3054448871181939,null,"Rossendale",12740,15315,0.2021193092621664,"2/14"]
["South Ribble",1403,23067,6.0822820479472843E-2,9,"-",1830,26891,6.8052508274143761E-2,7,"-",427,0.30434782608695654,null,"South Ribble",23067,26891,0.16577795118567651,"5/14"]
["West Lancashire",1489,24466,6.085996893648328E-2,8,"Low",1956,28169,6.9438034719017355E-2,4,"-",467,0.31363331094694424,null,"West Lancashire",24466,28169,0.15135289789912532,"8/14"]
["Wyre",1939,29621,6.5460315316836035E-2,2,"-",2372,33645,7.0500817357705456E-2,3,"-",433,0.22331098504383703,null,"Wyre",29621,33645,0.13584956618615171,"12/14"]
[]
["This colour highlights the districst that will see the largest increases in their 65+ demenia population",null,null,null,null,null,null,null,null,null,null,null,null,null,"Highlights the districts that will see the largest increase in their 65+ population"]
[]
[null,2017,null,null,null,2026,null,null,null,"Difference"]
["Lancashire localities (based on districts)","Estimated 65+ dementia count","Estimated 65+ population","65+ Dementia Prevalence","Significance","Estimated 65+ dementia count","Estimated 65+ population","65+ Dementia Prevalence","Significance","2016 - 2026 Change actual","2016 - 2026 % change"]
[]
["Central Lancashire",{"$f":"SUM(B12,B17,B20,B21)","v":5540},{"$f":"SUM(C12,C17,C20,C21)","v":91163},{"$f":"SUM(B12,B17,B20,B21)/SUM(C12,C17,C20,C21)","v":6.0770268639689345E-2},"Low",{"$f":"SUM(G12,G17,G20,G21)","v":7218},{"$f":"SUM(H12,H17,H20,H21)","v":106837},{"$f":"F29/G29","v":6.7560863745706079E-2},"-",{"$f":"F29-B29","v":1678},{"$f":"(F29-B29)/ABS(B29)","v":0.30288808664259925}]
["East Lancashire",{"$f":"SUM(B11,B14,B16,B18,B19)","v":4502},{"$f":"SUM(C11,C14,C16,C18,C19)","v":74114},{"$f":"SUM(B11,B14,B16,B18,B19)/SUM(C11,C14,C16,C18,C19)","v":6.0744258844482826E-2},"Low",{"$f":"SUM(G11,G14,G16,G18,G19)","v":5699},{"$f":"SUM(H11,H14,H16,H18,H19)","v":86085},{"$f":"F30/G30","v":6.6202009641633267E-2},"Low",{"$f":"F30-B30","v":1197},{"$f":"(F30-B30)/ABS(B30)","v":0.26588183029764551}]
["North Lancashire",{"$f":"SUM(B13,B22,B15)","v":5187},{"$f":"SUM(C13,C22,C15)","v":79129},{"$f":"SUM(B15,B22,B13)/SUM(C13,C15,C22)","v":6.5551188565506957E-2},"-",{"$f":"SUM(G13,G15,G22)","v":6409},{"$f":"SUM(H13,H15,H22)","v":91282},{"$f":"F31/G31","v":7.0210994500558704E-2},"-",{"$f":"F31-B31","v":1222},{"$f":"(F31-B31)/ABS(B31)","v":0.23558897243107768}]
["Fylde Coast vanguard area",{"$f":"SUM(B10,B22,B13)","v":5193},{"$f":"SUM(C10,C22,C13)","v":79308},{"$f":"SUM(B10,B13,B22)/SUM(C10,C13,C22)","v":6.5478892419428059E-2},"-",{"$f":"SUM(G13,G10,G22)","v":6280},{"$f":"SUM(H13,H10,H22)","v":89686},{"$f":"F32/G32","v":7.0022077024284729E-2},"-",{"$f":"F32-B32","v":1087},{"$f":"(F32-B32)/ABS(B32)","v":0.20932023878297709}]
["Pennine Lancashire",{"$f":"B9+B30","v":5753},{"$f":"C9+C30","v":95531},{"$f":"SUM(B9,B11,B14,B16,B18,B19)/SUM(C9,C11,C14,C16,C18,C19)","v":6.0221289424375331E-2},"Low",{"$f":"F30+G9","v":7210},{"$f":"G30+H9","v":111040},{"$f":"F33/G33","v":6.4931556195965412E-2},"Low",{"$f":"F33-B33","v":1457},{"$f":"(F33-B33)/ABS(B33)","v":0.25325916912915003}]
[]
["Source : NHS England dementia prevalence estimates combined with the ONS 2014-based population projections.  Showing the total number of people living with dementia in 2017 and 2026, should the current estimated prevalence levels remain the same."]

{"sheet":"End of life 2","index":16,"n_rows":60,"n_cols":34,"rows_kept":60,"cut":false,"hidden":true,"merged":[[0,0,1,13],[2,0,2,13],[3,0,3,13]]}
["Dementia in Lancashire"]
[]
["End of life analysis"]
["January 1st - December 31st 2016"]
[]
["Mortality amongst patients registered to the six Lancashire county CCGs, with a recorded dementia diagnoses"]
["Due to data confidentually rules, we do have access to data relating to patients registered with the Blackburn with Darwen or Blackpool CCGs"]
[]
["Total deaths",1964]
[]
[]
[]
[]
[]
[]
[]
["Registered CCG","Count","%",null,null,null,null,null,null,null,null,null,"IMD Quintile|2015 (1 = most deprived, 5 = least)","Total","%"]
["NHS WEST LANCASHIRE CCG",227,{"$f":"B18/$B$24","v":0.11558044806517312},null,null,null,null,null,null,null,null,null,"Quintile 1",351,{"$f":"N18/$N$24","v":0.17871690427698575}]
["NHS CHORLEY AND SOUTH RIBBLE CCG",252,0.12830957230142567,null,null,null,null,null,null,null,null,null,"Quintile 2",467,0.23778004073319756]
["NHS GREATER PRESTON CCG",295,0.15020366598778004,null,null,null,null,null,null,null,null,null,"Quintile 3",362,0.18431771894093688]
["NHS LANCASHIRE NORTH CCG",320,0.16293279022403259,null,null,null,null,null,null,null,null,null,"Quintile 4",441,0.22454175152749492]
["NHS FYLDE & WYRE CCG",332,0.1690427698574338,null,null,null,null,null,null,null,null,null,"Quintile 5",302,0.15376782077393075]
["NHS EAST LANCASHIRE CCG",538,0.27393075356415481,null,null,null,null,null,null,null,null,null,"(blank)",41,2.0875763747454174E-2]
["Grand Total",{"$f":"SUM(B18:B23)","v":1964},null,null,null,null,null,null,null,null,null,null,"Grand Total",1964]
[]
["Area","Count","%"]
["Other",59,{"$f":"B27/$B$40","v":3.004073319755601E-2}]
["Ribble Valley",82,4.1751527494908347E-2]
["Rossendale",98,4.9898167006109981E-2]
["Pendle",113,5.7535641547861505E-2,null,null,null,null,null,null,null,null,null,"Grouping","Total","%"]
["Hyndburn",113,5.7535641547861505E-2,null,null,null,null,null,null,null,null,null,"Care home",1238,{"$f":"N31/$N$36","v":0.63034623217922603}]
["Burnley",127,6.4663951120162932E-2,null,null,null,null,null,null,null,null,null,"Home",164,{"$f":"N32/$N$36","v":8.3503054989816694E-2}]
["South Ribble",137,6.9755600814663948E-2,null,null,null,null,null,null,null,null,null,"Hospice",7,{"$f":"N33/$N$36","v":3.564154786150713E-3}]
["Fylde",182,9.2668024439918534E-2,null,null,null,null,null,null,null,null,null,"Hospital",548,{"$f":"N34/$N$36","v":0.27902240325865579},null,null,null,null,null,null,null,null,null,null,null,null,null,"Registered CCG","No","Yes","Grand Total","No (%)","Yes (%)"]
["Chorley",184,9.368635437881874E-2,null,null,null,null,null,null,null,null,null,"Other places",7,{"$f":"N35/$N$36","v":3.564154786150713E-3},null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",931,1033,1964,{"$f":"AE35/AF35","v":0.52596741344195519},{"$f":"AD35/AF35","v":0.47403258655804481}]
["Wyre",185,9.4195519348268836E-2,null,null,null,null,null,null,null,null,null,"Grand Total",1964,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS CHORLEY AND SOUTH RIBBLE CCG",114,138,252,0.54761904761904767,0.45238095238095238]
["Preston",189,9.6232179226069248E-2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS EAST LANCASHIRE CCG",241,297,538,0.55204460966542745,0.44795539033457249]
["West Lancashire",209,0.10641547861507128,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS FYLDE & WYRE CCG",146,186,332,0.56024096385542166,0.43975903614457829]
["Lancaster",286,0.14562118126272913,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS GREATER PRESTON CCG",113,182,295,0.61694915254237293,0.38305084745762713]
[null,1964,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS LANCASHIRE NORTH CCG",164,156,320,0.48749999999999999,0.51249999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NHS WEST LANCASHIRE CCG",153,74,227,0.32599118942731276,0.67400881057268724]
[]
[null,null,null,null,null,null,null,null,"ICD10 Chapter","Total","%"]
["DSR Age Groups","Female","Male","Female","Male",null,null,null,"Mental and behavioural disorders",1042,{"$f":"J44/$J$60","v":0.53054989816700615}]
["<65",5,7,{"$f":"B45/$B$52","v":3.927729772191673E-3},{"$f":"C45/$C$52","v":1.0130246020260492E-2},null,null,null,"Diseases of the nervous system",475,{"$f":"J45/$J$60","v":0.24185336048879838}]
["65-69",7,13,5.4988216810683424E-3,{"$f":"C46/$C$52","v":1.8813314037626629E-2},null,null,null,"Diseases of the circulatory system",174,8.8594704684317724E-2]
["70-74",36,40,2.8279654359780047E-2,5.7887120115774238E-2,null,null,null,"Neoplasms",98,4.9898167006109981E-2]
["75-79",104,93,8.1696779261586805E-2,0.1345875542691751,null,null,null,"Diseases of the respiratory system",69,3.5132382892057029E-2]
["80-84",214,168,0.16810683424980361,0.24312590448625182,null,null,null,"Diseases of the digestive system",35,1.7820773930753563E-2]
["85-89",360,211,0.28279654359780049,0.30535455861070909,null,null,null,"Certain infectious and parasitic diseases",23,1.1710794297352342E-2]
["90+",547,159,0.42969363707776903,0.23010130246020261,null,null,null,"External causes of morbidity and mortality",14,7.1283095723014261E-3]
["Grand Total",{"$f":"SUM(B45:B51)","v":1273},{"$f":"SUM(C45:C51)","v":691},{"$f":"B52/SUM(B52:C52)","v":0.64816700610997968},{"$f":"C52/SUM(B52:C52)","v":0.35183299389002037},null,null,null,"Diseases of the genitourinary system",11,5.6008146639511197E-3]
[null,null,null,null,null,null,null,null,"Endocrine, nutritional and metabolic diseases",8,4.0733197556008143E-3]
[null,null,null,null,null,null,null,null,"Diseases of the musculoskeletal system and connective tissue",6,3.0549898167006109E-3]
[null,null,null,null,null,null,null,null,"Congenital malformations, deformations and chromosomal abnormalities",5,2.5458248472505093E-3]
[null,null,null,null,null,null,null,null,"Diseases of the skin and subcutaneous tissue",3,1.5274949083503055E-3]
[null,null,null,null,null,null,null,null,"Diseases of the blood and blood-forming organs and certain disorders involving the immune mechanism",1,5.0916496945010179E-4]
[]
[]
[null,null,null,null,null,null,null,null,"Grand Total",1964]