{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["Disease prevalence","Sources","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Disease prevalence","index":0,"n_rows":160,"n_cols":10,"rows_kept":160,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,4,2,6],[2,7,2,9]],"flags":["formulas_cached_only"]}
["How many people have these diseases? What the GPs think and how they differ from the epidemiologists (2007-8)*"]
[]
[null,"Coronary Heart Disease",null,null,"Hypertension",null,null,"Chronic Obstructive Pulmonary Disease"]
["Primary Care Trust","% patients on GP lists diagnosed with CHD","% total population estimated to have CHD by ERPHO","proportion of expected true prevalence of CHD sufferers diagnosed on GP lists","% patients on GP lists diagnosed with hypertension","% total population estimated to have hypertension by ERPHO","proportion of expected true prevalence of hypertension sufferers diagnosed on GP lists","% patients on GP lists diagnosed with COPD","% total population estimated to have COPD by ERPHO","proportion of expected true prevalence of COPD sufferers diagnosed on GP lists"]
["HARINGEY PCT",0.01764905656243267,0.041008237126046516,0.430378328826596,0.10175687173850329,0.2125669997211905,0.478704934782778,0.006920124598760586,0.03547650846612268,0.19506216642961835]
["HEART OF BIRMINGHAM PCT",0.022869868939660972,0.046637202912156825,0.490378228358535,0.10196430288076393,0.20512602908146416,0.49708124969488693,0.006661966866408178,0.032773587373109925,0.20327243369989423]
["BRENT PCT",0.020692561555173995,0.03742157730883541,0.552958026980022,0.10746919749764372,0.22121443867278004,0.4858145704341295,0.006552027540725934,0.030744836484269553,0.21310985160315446]
["WESTMINSTER PCT",0.019336296943671796,0.03516162597545627,0.5499261313219427,0.07701325221220347,0.21064251588066252,0.3656111487760362,0.007395020126219548,0.03226401997173087,0.22920330859883323]
["CITY AND HACKNEY PRIMARY CARE TEAM",0.01671789994720663,0.03863705646696091,0.43269082781972124,0.08964388813796667,0.20314891413420802,0.4412718055620246,0.008315891552686657,0.034083771731555516,0.24398389996807834]
["KENSINGTON AND CHELSEA PCT",0.01930149555353951,0.03973147129675992,0.48579866095000457,0.08348046219286284,0.22898944924895437,0.3645602994664788,0.008224729599791394,0.032842579432330724,0.2504288561359114]
["ENFIELD PCT",0.02567366061222331,0.04143670389954535,0.6195874236151541,0.12377543395106172,0.23216711265603615,0.5331307803893803,0.008813804540320682,0.03504620692251621,0.2514909690457274]
["LAMBETH PCT",0.013932955120048452,0.0271046422664879,0.5140431289615328,0.08507854130433574,0.1920383284501534,0.44302896193152,0.007959704171273941,0.03141888151043267,0.2533414236477805]
["CROYDON PRIMARY CARE TRUST",0.023829202956102684,0.034715412072508174,0.6864156734286183,0.11599337703770511,0.22603356653099138,0.5131688130125633,0.007874863704282042,0.03091383040261067,0.2547359418655868]
["REDBRIDGE PCT",0.028468898612098427,0.035641280472264066,0.7987619477996262,0.11301647159002354,0.22068220587147094,0.5121231734281569,0.007112472867303533,0.027646858229898336,0.25726152346713455]
["HOUNSLOW PCT",0.0238277174187092,0.037481948635148116,0.6357118102543134,0.10951906256181902,0.20853910935985712,0.5251727740566489,0.007858530927935021,0.029943943715621212,0.2624414139489371]
["EALING PCT",0.027099288783069077,0.038296304392612,0.7076215110797214,0.11813282554693447,0.21625894946649776,0.5462563553478987,0.007970871052550874,0.02993594203758728,0.26626424658835607]
["NEWHAM PRIMARY CARE TEAM",0.01894342514154357,0.03821814243902492,0.49566577370333553,0.09830512597529753,0.1925572237445439,0.5105242174955433,0.008270644684590451,0.030999795029621267,0.26679675387168184]
["WALTHAM FOREST PCT",0.022231002238904254,0.0344903470973332,0.6445572199133699,0.10717013790897631,0.2092016855090637,0.5122814266443046,0.008598144907903896,0.03182315740601733,0.2701851610198209]
["BRIGHTON AND HOVE CITY TEACHING PCT",0.024448986544029976,0.04410152129160231,0.5543796637392979,0.09348662919434508,0.23233164288649624,0.4023844020248986,0.010383239652529382,0.03753880305326156,0.276600179227804]
["CAMDEN PRIMARY CARE TRUST",0.020618744727902788,0.04127307982469826,0.49956884282631864,0.08787816610810933,0.20184202911729263,0.43538090898324433,0.009538791236349544,0.03303695147153835,0.2887309758155895]
["LEWISHAM PCT",0.019222819346837536,0.030799682610484474,0.6241239427673169,0.10313834918010197,0.2055733403202406,0.5017107228954583,0.009942124844977264,0.03262299363820653,0.30475820077203186]
["SOUTHWARK PCT",0.016018869178127698,0.039544941736102464,0.40508010569410724,0.09763470865723207,0.20849316978332158,0.468287324513795,0.011128828649259185,0.03610199759843549,0.30826074426810834]
["BARNET PRIMARY CARE TRUST",0.027768059215201774,0.03687488957633781,0.7530343693020904,0.1137427156336442,0.22746047004131406,0.5000548693713017,0.00907197445961755,0.02895570317602068,0.31330527200356156]
["WANDSWORTH PCT",0.01606407378340725,0.025509120216514053,0.6297384483298533,0.08546111587669508,0.18479153159912115,0.4624731184223895,0.00829515796389918,0.02615500288350548,0.31715377745687345]
["HAMMERSMITH & FULHAM PCT",0.018101531261719515,0.031949398145492726,0.5665687716334399,0.08582777399231992,0.19934122736096593,0.43055706603483224,0.00987740398582302,0.030958338719991898,0.3190547165712258]
["HARROW PCT",0.029387033483538518,0.03616804947340023,0.8125136387338553,0.12857420064250447,0.21691202649191227,0.5927481418246694,0.007740238459714107,0.024163190093343424,0.32033181172739356]
["BARKING & DAGENHAM PCT",0.025134739227771482,0.0385440600230228,0.6521040910780603,0.11065476354992952,0.21244858633897304,0.5208543180107301,0.011674635858599817,0.03563871721745347,0.32758294265659926]
["ISLINGTON PRIMARY CARE TRUST",0.019545956559087006,0.04030867489878956,0.48490694889287855,0.09050926494048349,0.201850147222482,0.4483983102609429,0.011775677997300282,0.03516071442599772,0.3349100889882199]
["SUTTON & MERTON PCT",0.023861332278324515,0.03461765738826768,0.689282120124379,0.10822412343603185,0.22086984281178895,0.4899904942127091,0.010251718510459423,0.03007989432121388,0.3408163074306211]
["KINGSTON",0.023703520266159902,0.031127072743505672,0.7615081720495348,0.10069285556626273,0.19828428866107534,0.5078206460340167,0.008667423944700759,0.025409089318984692,0.3411150960937744]
["RICHMOND & TWICKENHAM",0.019762180471456045,0.032898011158239884,0.6007104920841472,0.09551040396671955,0.208180440890116,0.45878663508611195,0.008794527396177134,0.02576730360591952,0.3413056923098763]
["DUDLEY PRIMARY CARE TRUST",0.03897191282064293,0.053419559643254864,0.7295438801986419,0.1592526577525182,0.26544762657940835,0.5999400326334353,0.014107020526222312,0.04131603550715114,0.3414417756461801]
["NOTTINGHAM CITY PCT",0.03040085180238677,0.051017833008332465,0.59588677154166,0.10421962222810333,0.21788470418063124,0.47832463788602136,0.014537263277100426,0.04245764136929771,0.34239450916867753]
["LEICESTER CITY PCT",0.02945727122710984,0.04066100529090039,0.7244599836222482,0.11027601177146877,0.2111203725547124,0.5223371408313069,0.011605592877632208,0.033599248637270096,0.3454122740339693]
["BIRMINGHAM EAST AND NORTH PCT",0.035792367790516616,0.059258359652740164,0.6040053757860229,0.12682352994818086,0.23667154476560198,0.5358630251633592,0.013872392229636536,0.03959118678480937,0.3503909166713637]
["GREENWICH PCT",0.023492001073833625,0.03709289430347686,0.6333288764590049,0.1062906232394233,0.21489346137595086,0.49462009015467645,0.011891573052825809,0.03374408467025936,0.35240467089351957]
["HULL TEACHING PCT",0.03905525303951906,0.060189815724956526,0.64886812775746,0.12158076234041197,0.2440228471110618,0.4982351602720096,0.017829956876712717,0.04893919866133213,0.3643287459629071]
["WOLVERHAMPTON CITY PRIMARY CARE TRUST",0.039491097671698755,0.05091901649101338,0.7755667802159627,0.14977763415047013,0.25389430751921477,0.5899211983676905,0.014484557499653756,0.03900468252833552,0.37135432365412124]
["BEXLEY CARE TRUST",0.03078515701363095,0.041302031162355146,0.7453666598772549,0.13255966873411648,0.24513896116048045,0.540753163457098,0.013253301107181575,0.03554105344043761,0.3729011895888922]
["HILLINGDON PCT",0.02646158003783443,0.036297425174967736,0.7290208578233662,0.1205522025042789,0.22246485195024673,0.541893253911588,0.011376602708464703,0.029968623955689076,0.37961711973448925]
["BOURNEMOUTH AND POOLE PRIMARY CARE TRUST",0.039750185136691416,0.049181662253391954,0.8082318351074018,0.1302855469486939,0.27005904044571344,0.4824335698359395,0.013771917227708276,0.03615875355536307,0.3808736716165268]
["SANDWELL PRIMARY CARE TRUST",0.037635190843396865,0.06589708462839508,0.5711207264422719,0.15030736214171395,0.25844497778081427,0.5815836060439479,0.01715044376545904,0.04472974750312312,0.3834236659677447]
["HAVERING PCT",0.032645554571494685,0.04490815256119413,0.7269404931990955,0.1291460213355036,0.25944153020647187,0.4977846886453571,0.014457715968116428,0.037454083634401385,0.3860117393137097]
["BROMLEY PCT",0.0303059493253951,0.03936028051237343,0.7699627373302895,0.13256871896537795,0.23254137427845184,0.5700865894369244,0.011643226917077355,0.029962779863343218,0.38858967593063026]
["STOKE-ON-TRENT PCT",0.04285940559843336,0.06837744473440001,0.6268061897444849,0.15749913604423454,0.2669473964613537,0.5900006448163128,0.01870104250662366,0.04735978933472659,0.39487174181560625]
["SOUTH EAST ESSEX PCT",0.035130404731247525,0.04741697430100795,0.7408824634873582,0.14866529545213847,0.2671363163806194,0.5565147317533501,0.015214349815777885,0.037438162789375354,0.40638612266773927]
["PORTSMOUTH CITY PRIMARY CARE TRUST",0.03302124769574076,0.04228140954912685,0.7809873901524809,0.1120452119918502,0.2231679692927327,0.5020667273486674,0.015164451343746967,0.037141341581739123,0.40829034972723516]
["COVENTRY PRIMARY CARE TRUST",0.0282656201732206,0.04542127269592954,0.6222991672303723,0.12927187853963823,0.2326867714358449,0.5555617869547876,0.015008066084688168,0.03673968051221147,0.40849745766569234]
["TOWER HAMLETS PRIMARY CARE TEAM",0.01924955825797734,0.03634901679739819,0.5295757617123552,0.08054879950109137,0.17668433972641326,0.4558909953525994,0.011977964868516787,0.029183626447044995,0.4104344225434541]
["LUTON",0.026341087289586732,0.040106072503749035,0.6567855101524693,0.1118482320779468,0.21652755371877921,0.5165542682997869,0.010113855982696294,0.024191231751938668,0.41807941350013217]
["WALSALL TEACHING PCT",0.03961083826632556,0.05145996862344997,0.7697408165203421,0.14298892644395061,0.25447237231891306,0.5619035384507369,0.016836286904072753,0.039687504522088864,0.4242213539705472]
["SOUTH BIRMINGHAM PCT",0.031916834800923825,0.044198283640297535,0.7221283763115143,0.12326456772552148,0.23180243376473275,0.5317656321530624,0.015470958391333136,0.03607788663883699,0.4288210821827634]
["NEWCASTLE UPON TYNE PCT",0.038687819227560774,0.062106330977226176,0.6229287516879276,0.1234358764214316,0.24705495374823075,0.49962923045543495,0.019303663159127165,0.04496303526149849,0.42932295488638306]
["BRISTOL PCT",0.027447821699799962,0.04053355100322789,0.6771630173140802,0.11101940200747049,0.21906172767491303,0.5067950626785112,0.015140115774752607,0.034440187483106316,0.43960607886293224]
["LEEDS PCT",0.036898695507026374,0.044073445330597746,0.8372092363155839,0.11405841558588804,0.23042506892735387,0.4949913484537017,0.01631781505300487,0.037015462009694654,0.44083780579940085]
["SHEFFIELD PCT",0.041480275076320405,0.04716293375726431,0.8795100680082559,0.12424710951036559,0.24234251245427302,0.5126921737836214,0.01689631545528575,0.03787685453299315,0.4460854963700321]
["TRAFFORD PCT",0.03908441028817174,0.041414101763066084,0.9437464202840201,0.12721079237415658,0.24533117645720567,0.5185268102129963,0.01447619213775717,0.03241656880366361,0.4465676865875182]
["BURY PRIMARY CARE TRUST",0.0399300313401289,0.047959913956061,0.8325709544998607,0.12525639557281634,0.2476933651438265,0.5056913635941944,0.017013212831752444,0.037564793962235055,0.4529031318222138]
["ASHTON LEIGH AND WIGAN PCT",0.046234678226920685,0.04903702026290544,0.9428525220137689,0.14529857651696645,0.2533636756652904,0.5734783257127796,0.01837662090732783,0.03997474301577833,0.4597057922317209]
["NORTH TYNESIDE PRIMARY CARE TRUST",0.04857537282596446,0.05295266065452467,0.917335828370955,0.1441812854513354,0.2653984761142572,0.543263426234835,0.019866834454002478,0.04296826575812613,0.46236063065322286]
["MID ESSEX PCT",0.03170081322357852,0.03917522179734241,0.8092057113950802,0.11818794132423495,0.2322659000465566,0.5088475807277123,0.009904433807575733,0.020832699895794695,0.47542727813090846]
["HEYWOOD MIDDLETON & ROCHDALE PCT",0.041243302738940994,0.04643437961675816,0.8882061756685189,0.11060827958847662,0.24005634643939583,0.46075965592686624,0.018270219133472206,0.03825796355849306,0.47755336233562584]
["MANCHESTER PCT",0.03187629889382082,0.04758222568454672,0.6699202997596072,0.1037220589823303,0.20981620919574648,0.49434721645153534,0.01894656277410567,0.03944363060522646,0.48034530501852846]
["SOUTHAMPTON CITY PRIMARY CARE TRUST",0.029048130673767148,0.04097399421311241,0.7089406642340772,0.10382507279550303,0.21723155076286288,0.4779465617719679,0.01710499680789773,0.03540000022904892,0.4831919970966984]
["NORTH TEES PCT",0.0416339067626925,0.04768108460408062,0.8731744906475849,0.12748057992892411,0.24658977669512339,0.5169743110905101,0.019105575997735637,0.039427077791069035,0.4845800670031753]
["HASTINGS & ROTHER PCT",0.041423228433585625,0.06508732323681674,0.6364254416005007,0.15949630416500685,0.3043208714729113,0.524105702619231,0.015967335015270215,0.03275344187182074,0.4875009801338659]
["BOLTON PCT",0.03698716600042079,0.04841302375128964,0.7639920652433017,0.1241812188793043,0.24628179387855031,0.5042241122400715,0.01904761904761905,0.03836342875654633,0.4965046051669395]
["BERKSHIRE WEST PRIMARY CARE TRUST",0.024023597215956958,0.03352976732644413,0.7164856523477906,0.11376346345171078,0.20798364664518673,0.54698273295394,0.008916929807757667,0.017903682898053514,0.49805003018273486]
["STOCKPORT PRIMARY CARE TRUST",0.04249884122160993,0.04432423289614056,0.9588172980047315,0.13792724588419084,0.2573560785530371,0.5359393361123436,0.017325024463099345,0.034548425597633894,0.5014707374765546]
["SEFTON PCT",0.04610514334495269,0.05753952021966247,0.8012778550975402,0.15025965711033648,0.2807001819619277,0.5353030270949974,0.02199260155082877,0.0428596476965866,0.5131307122848863]
["LIVERPOOL PCT",0.04178626800246571,0.06094658503592439,0.685621154619823,0.1263737290087981,0.24781206243141557,0.5099579405815778,0.02394102227231123,0.04645912421290556,0.5153136800986192]
["MIDDLESBROUGH PCT",0.04258811220819983,0.06325749024646429,0.6732501090743201,0.12043418557509972,0.25033944070469055,0.48108354495034694,0.024285620872294515,0.04666895975825883,0.5203805912557711]
["WORCESTERSHIRE PCT",0.03472414481915129,0.04691563340343796,0.7401401686416689,0.13519234341105102,0.26771516975134835,0.5049857411390493,0.013224157084832959,0.025161019823892423,0.5255811241909818]
["HEREFORDSHIRE PRIMARY CARE TRUST",0.03692019574838084,0.052672386620286754,0.7009402481519802,0.14665522200051279,0.2899706602811582,0.5057588304220659,0.013850647106691786,0.02633942309489099,0.5258523338492699]
["ISLE OF WIGHT NHS PRIMARY CARE TRUST",0.04346833836125434,0.05593410343513529,0.7771348013410632,0.1572277255967536,0.30129337616206664,0.5218426226276556,0.014991049587425205,0.028216496585824005,0.5312867081789566]
["PETERBOROUGH PCT",0.030732860520094562,0.04473328241698147,0.6870244895873744,0.12224757255796678,0.2341528696308861,0.5220844517117189,0.014072384051691103,0.02630733669219022,0.5349224140909988]
["WARWICKSHIRE PCT",0.03362401599492412,0.045136151483592186,0.7449464540003387,0.13895036999328628,0.25977154500546873,0.5348944973567489,0.013102852969168455,0.02438298444682388,0.537376915354397]
["BLACKPOOL PCT",0.04964506375706586,0.05638993103082723,0.8803888007936366,0.13803733403444196,0.275041614734394,0.5018779945999945,0.024569475483107665,0.0454569450840828,0.540499926637413]
["EAST SUSSEX DOWNS & WEALD PCT",0.04038885431630618,0.05494995534373886,0.7350115948894613,0.14910056356540907,0.29625964352280565,0.5032766589214218,0.015019686985652056,0.02765098340201388,0.5431881668468305]
["WIRRAL PCT",0.043706200022625645,0.05549730975210896,0.7875372737498282,0.14077617876642592,0.2724647100632607,0.5166767422237566,0.022521449708545947,0.04126560288575735,0.5457681006356782]
["OXFORDSHIRE PRIMARY CARE TRUST",0.026862690491377166,0.036157359578819055,0.7429383894257949,0.11044681813145514,0.2171951380414296,0.5085142288516035,0.010464486028885516,0.019109207683049943,0.5476148567984647]
["KIRKLEES PCT",0.0405698336172835,0.04682009178326726,0.8665047861307803,0.1219149116129578,0.24166857216107712,0.5044715186702017,0.014228924251761095,0.025953300233903444,0.5482510556855308]
["DEVON PRIMARY CARE TRUST",0.03931233677510853,0.0525485170287351,0.7481150562938126,0.14172078116456263,0.2872954349347006,0.49329284051023764,0.014246049009708014,0.025966018155974227,0.5486420337586609]
["SALFORD PCT",0.04488826263650345,0.06314134219343952,0.7109171436201654,0.13603089639055238,0.25211533621471705,0.539558197581047,0.025131240924829667,0.04558973710859653,0.5512477701936748]
["WEST ESSEX PCT",0.031243672943107103,0.04293334319129651,0.7277251343762311,0.12795839860192024,0.25144558250672233,0.5088910185904709,0.013305911646757528,0.02388199322164104,0.5571524756442929]
["CORNWALL & ISLES OF SCILLY PCT",0.04217759141277306,0.06145065316782813,0.6863652254042226,0.14482640247458603,0.2935237682482292,0.49340604796306736,0.016556914740471145,0.02961477233917923,0.5590762120621461]
["TAMESIDE AND GLOSSOP PRIMARY CARE TRUST",0.04336118966399094,0.04769151458864752,0.9092013545384997,0.1351602690101492,0.246929649158319,0.5473634675740828,0.022669727058684284,0.04048203442885481,0.5599947576381127]
["NORTH EAST ESSEX PCT",0.03940967253996157,0.04890813082694983,0.8057897914644014,0.14298427952816573,0.27089573542226314,0.5278203413032201,0.014626108121876896,0.026035069813003384,0.5617848627612203]
["TORBAY CARE TRUST",0.04404854189104829,0.06534549920603615,0.6740868525950353,0.1561558883454185,0.30432935653495047,0.513114771849113,0.018124318280041983,0.03214812577808013,0.5637752696737259]
["DERBY CITY PCT",0.03533042682523721,0.04773953665098559,0.740066395774451,0.13218116847192599,0.24108051802088057,0.5482863964166422,0.014972112136005094,0.02630332351785603,0.5692098994958286]
["BERKSHIRE EAST PRIMARY CARE TRUST",0.02687838753796093,0.032584020842343776,0.8248947442063924,0.10489397473532881,0.20222313535727035,0.5187041262613756,0.009757074180297223,0.017121701107872013,0.5698659332285173]
["MEDWAY PCT",0.028736501079913608,0.037589094735144914,0.7644903736680219,0.13037077033837294,0.2294548625803626,0.5681761060640536,0.013765298776097912,0.024149884058471426,0.5699944042285887]
["NORTHAMPTONSHIRE PCT",0.031020476943101526,0.03984233364161932,0.7785808236568131,0.12567985310524357,0.23968546809657104,0.5243532455401353,0.01356510319821495,0.023739714923393107,0.5714096922388863]
["HAMPSHIRE PRIMARY CARE TRUST",0.03384646412932603,0.041540397065703505,0.8147843188834195,0.13157635487086403,0.24040986954160667,0.5473001383917505,0.011908668148268815,0.02073136147188018,0.5744276932521589]
["SOUTH STAFFORDSHIRE PRIMARY CARE TRUST",0.037535037826133884,0.044741862693268276,0.8389243443765092,0.13276596858125014,0.2604099679163697,0.5098344339256926,0.01426370686299842,0.024778320221186097,0.5756526970219146]
["HALTON & ST HELENS PCT",0.04746479139016612,0.0488948148084412,0.9707530660689158,0.14409898038130342,0.25164687431196164,0.5726237640554469,0.023260641208697894,0.04018822617373912,0.5787924330907019]
["BEDFORDSHIRE PCT",0.03041249926022371,0.03663602574497123,0.8301255019288826,0.1231555897496597,0.22183790136630094,0.5551602723932372,0.011585488548263006,0.019976661799055016,0.5799511782699875]
["BATH AND NORTH EAST SOMERSET PCT",0.030672482621495398,0.03987754067700211,0.769166856851446,0.12079409362043188,0.2307079333047163,0.5235801469422747,0.011976140199448204,0.020461734352102065,0.5852944815607909]
["NORTH LINCOLNSHIRE PCT",0.04617434129227876,0.05482681452587858,0.8421853739192562,0.15398479742966853,0.27263426561103177,0.5648035366521359,0.01727619610230691,0.02951549861490748,0.5853262493617902]
["NORTH YORKSHIRE AND YORK PCT",0.04089138053274053,0.047318992695738527,0.8641642225072796,0.13482301170148636,0.2688412008780246,0.501496836277921,0.014403482010497088,0.02452187296444815,0.5873728336893058]
["PLYMOUTH PRIMARY CARE TRUST",0.03615377739373985,0.04804702491346432,0.7524665150205461,0.1324657717920832,0.24581157164576942,0.5388915212786445,0.01626119213980305,0.027672038799574472,0.5876398286942669]
["GREAT YARMOUTH AND WAVENEY TEACHING PCT",0.042927012299140935,0.06289224809274029,0.6825485429593992,0.1507048337063651,0.2953091364310805,0.510329058991159,0.01986884988416382,0.03352948363864873,0.5925784631309208]
["WEST HERTFORDSHIRE PCT",0.027432105106084688,0.037266255293790705,0.7361111249258098,0.11880652124122901,0.22323032413714983,0.5322149743788206,0.011356301576174843,0.019114398747324086,0.5941228770151437]
["MILTON KEYNES PCT",0.02327446862541972,0.03249857051941617,0.7161689961567529,0.10524703425869568,0.2136763298878397,0.49255354729248974,0.012012108850666914,0.020210637626807332,0.594345862435042]
["WEST KENT PCT",0.03008728003616751,0.039441923705142316,0.7628248627296246,0.1287272549262396,0.23184138288861045,0.5552384708992499,0.012554963962070186,0.02108673291368236,0.5953963572006814]
["LEICESTERSHIRE COUNTY & RUTLAND PCT",0.033902778048513514,0.0408341694849146,0.8302551141890677,0.13568758462574243,0.23726044546286512,0.5718929860433883,0.01267343122804229,0.02110821326361025,0.6004028417644804]
["BUCKINGHAMSHIRE PCT",0.0295712391904182,0.03199333023727914,0.9242938753515981,0.11969733170964808,0.22801458972521318,0.5249547051085578,0.009996454611317497,0.01658066956068877,0.6028981263228455]
["WESTERN CHESHIRE PCT",0.03723443174072605,0.04679608161785602,0.7956741345309235,0.1344467592681734,0.26655157990381917,0.5043930308598671,0.015187982085574883,0.025174940578457126,0.603297633940461]
["WEST SUSSEX PCT",0.039772117317381055,0.04638938863605744,0.8573537717732945,0.13823747527507443,0.2583325249217843,0.5351144820689101,0.01378796348052916,0.02281460754718368,0.604348045523632]
["CALDERDALE",0.042659739057928754,0.04864153295265167,0.8770229157755848,0.12435957373999296,0.25014264319318746,0.49715463206307015,0.016343822748326336,0.027030801719046833,0.6046369959056714]
["SOUTH WEST ESSEX PCT",0.03150620866062821,0.0399106663373492,0.7894182571225095,0.13365561738234086,0.23847246794456872,0.5604656107027339,0.014290418332967464,0.02361740111928537,0.6050800535075924]
["EAST & NORTH HERTFORDSHIRE PCT",0.02979297554673418,0.037083441911161905,0.8034037298400466,0.12180094951326158,0.22193039445336543,0.5488250035028699,0.012056456794368212,0.019918609716866716,0.6052860599080379]
["SHROPSHIRE COUNTY PRIMARY CARE TRUST",0.03842130290061817,0.05057493977492012,0.7596905319434728,0.14431764146457443,0.28190912940101803,0.511929648292026,0.01560016303240269,0.025637270605908268,0.6084954702162224]
["SOLIHULL CARE TRUST",0.03642326710091777,0.04574358868479548,0.7962485705242525,0.1445070885105917,0.26226312330940055,0.5510004101495881,0.014728957979820096,0.024170920171659827,0.6093668704052756]
["SOMERSET PRIMARY CARE TRUST",0.039251254269403346,0.05100327030336933,0.7695830882203325,0.15170221604825718,0.2813156059474715,0.5392598662890522,0.015594483282360527,0.025563453658661788,0.6100303773733864]
["NORFOLK PRIMARY CARE TRUST",0.03976752086776328,0.05168047994603284,0.7694882266823059,0.14516952054562754,0.28277566508060425,0.513373456320039,0.016124382291197167,0.026365607283302755,0.6115687804167773]
["SUFFOLK PCT",0.036880405064964025,0.04300637467195846,0.8575567074946039,0.12944733081682044,0.24502898300921094,0.5282939561968241,0.01327033791206522,0.02154451888095289,0.6159496058088947]
["EASTERN & COASTAL KENT PCT",0.03558648399994192,0.04697035825305129,0.7576370571461449,0.13866189012277072,0.2646131536270499,0.5240173748815339,0.016267352700863658,0.02622751407914449,0.6202399759189942]
["SURREY PCT",0.028901284122487145,0.03336886220653588,0.8661153605898592,0.1204228918602851,0.2338045873375511,0.5150578661933042,0.01075860404051183,0.01725514174200641,0.623501342461927]
["DORSET PRIMARY CARE TRUST",0.04467723386169308,0.0536309567514402,0.8330493537297061,0.16196059802990148,0.28689262359530165,0.564533852422666,0.015398269913495674,0.024432156350494626,0.6302460451135717]
["KNOWSLEY",0.047330758106018396,0.06255886303953825,0.75657957651987,0.12997802500516506,0.25217936550815734,0.5154189548508504,0.029418946076743443,0.04660388275481274,0.6312552589559799]
["CUMBRIA PCT",0.04882566424782893,0.05878175758370027,0.8306261373404035,0.1424387363904201,0.2865262839580682,0.4971227575452218,0.01913782358627263,0.030308485505439613,0.6314345064466474]
["NORTH SOMERSET PCT",0.0383130919328789,0.0495117241485071,0.7738185771507642,0.14593813889715676,0.27631665041980025,0.5281554284746757,0.015877585474985727,0.025123660372295468,0.6319773965936256]
["SOUTH GLOUCESTERSHIRE PCT",0.031050348049966627,0.03831537685260498,0.8103886898832781,0.13227885318330632,0.22751492694573136,0.581407360646972,0.012642636915546231,0.019960270258436184,0.6333900669607836]
["WILTSHIRE PCT",0.03207777123953974,0.041591257332170915,0.7712623588979005,0.13133263249298607,0.24026357577828206,0.5466189873665299,0.012958934722672186,0.020418003138998567,0.6346817871685261]
["NORTH EAST LINCOLNSHIRE CARE TRUST PLUS",0.04331232699216679,0.05221360872997119,0.8295218056304359,0.14665763590317452,0.2598616809898044,0.564368072062647,0.019806820189646034,0.03118583637299358,0.6351223020844942]
["CENTRAL AND EASTERN CHESHIRE PCT",0.03843230896113373,0.04610290750433605,0.8336200695697796,0.13973029807115192,0.26489708878694634,0.5274889909550323,0.015495122825350082,0.02420451930294324,0.6401747802306444]
["GLOUCESTERSHIRE PCT",0.03253637566137566,0.04269227371393669,0.7621139103386362,0.12982142857142856,0.24484062493780384,0.5302283009790827,0.014009589947089948,0.021861778336675894,0.6408257247575826]
["TELFORD & WREKIN PRIMARY CARE TRUST",0.032310666255544226,0.04571168011548994,0.706836112212716,0.1247183415953132,0.24052702677977833,0.5185211128456795,0.016834278124332913,0.026191299749336393,0.6427431355238276]
["CAMBRIDGESHIRE PCT",0.0313107270193234,0.03752253144963176,0.8344513498870204,0.1223362874045334,0.22383364054228166,0.5465500498859301,0.013025169745985188,0.020102494497858153,0.647937983386737]
["EAST RIDING OF YORKSHIRE PCT",0.04667960396545231,0.050740868507179356,0.919960681375558,0.1442774795248096,0.28452095062181987,0.5070891236989455,0.016750397375090167,0.025813231536119755,0.6489074160146043]
["SOUTH TYNESIDE PRIMARY CARE TRUST",0.049514319371222214,0.05350228721024068,0.9254617316948061,0.1524245408724871,0.2651264295906427,0.5749126600008599,0.0300034116730716,0.04578564409525706,0.655301727560051]
["SUNDERLAND TEACHING PRIMARY CARE TRUST",0.05274574602728167,0.05000432991088011,1.0548235747041794,0.15444381943467866,0.2551135589429411,0.6053924380758676,0.028241456897764028,0.043083632688813454,0.6555031489973882]
["DARLINGTON PCT",0.04313597793399353,0.05169383257055042,0.8344511480189178,0.13383262780853142,0.26033843628414627,0.514071720329686,0.01923113758691363,0.029132937321620558,0.6601166705096208]
["OLDHAM PRIMARY CARE TRUST",0.03643618150176153,0.04609834910204743,0.7904010059254647,0.12142281081539963,0.23776855063617477,0.5106764981765676,0.01768326329640477,0.02677892319298134,0.6603425824470601]
["WARRINGTON PCT",0.03808585086984377,0.04079037563064335,0.9336969881010895,0.1260854566063772,0.24418305625441167,0.5163562883536446,0.015356562022571584,0.023034731422173826,0.6666698969100617]
["SWINDON PCT",0.028786390319875406,0.03778528096062477,0.7618413728317406,0.1270492392476339,0.2300146489744982,0.5523528167187295,0.015473822930394154,0.02308481962644951,0.6703029601610995]
["NOTTINGHAMSHIRE COUNTY TEACHING PCT",0.041066929731370466,0.04493555224808046,0.9139073111786391,0.1393671270298983,0.25983339691323726,0.5363711081237003,0.016888753983912583,0.024823045493727977,0.6803659119176111]
["HARTLEPOOL PCT",0.046251386907592326,0.06774932631239575,0.6826840859542237,0.15647487715961325,0.2646556894832432,0.5912394230599775,0.0232155122312041,0.033999987671216376,0.6828094308651127]
["NORTH STAFFORDSHIRE PCT",0.043614047763918466,0.04675541864270146,0.9328126884545955,0.152860701247338,0.2676160595202006,0.5711940513637207,0.017445619105567387,0.025298680158454254,0.6895861363636178]
["CENTRAL LANCS PCT",0.04139646901075912,0.04260200608729229,0.9717023401653199,0.12458542191727164,0.24974761536752332,0.4988452912110266,0.016742390165056423,0.024017087764644365,0.6971032595260342]
["DERBYSHIRE COUNTY PCT",0.041731481294426276,0.04644690760899977,0.898477066454693,0.1435984311733588,0.2660413854355045,0.5397597480493157,0.0178845082698174,0.02564974366562215,0.6972587524836615]
["LINCOLNSHIRE PCT",0.04589072295534724,0.05060039737567358,0.9069241613784136,0.14611355587443112,0.28001059696050956,0.5218143793859266,0.01841620374233456,0.02632327590203971,0.6996167122537946]
["BASSETLAW",0.04198971717669835,0.05411181433102292,0.7759805819821711,0.1343616156634978,0.27088708639383824,0.49600598334965174,0.020309945846232524,0.02893214548928629,0.7019854733467102]
["GATESHEAD PRIMARY CARE TRUST",0.04785429554602666,0.05261219779631854,0.9095665558638798,0.1559937115795519,0.2627947258695415,0.593595290253243,0.022447519432289967,0.031429701883518145,0.7142135651010273]
["BRADFORD & AIREDALE PCT",0.03650938492204475,0.043417952381465216,0.8408822369437745,0.1158240369188884,0.22487825301369982,0.5150521909819011,0.01771523240724466,0.02363932476387817,0.7493967185693156]
["EAST LANCS PCT",0.04380159104925131,0.0498134285697597,0.879312914346193,0.12782581545789756,0.2522211455568606,0.5068005506662826,0.020423540097485957,0.027133873027516166,0.7526953515546663]
["NORTH LANCS PCT",0.050988149325614775,0.050111126438392384,1.0175015600238126,0.14106632344393172,0.2779379481008925,0.5075461066321326,0.019682914388071033,0.026081989436449057,0.7546554083242037]
["NORTHUMBERLAND CARE TRUST",0.05105928309539311,0.05791693393420351,0.8815950642932682,0.15882860516044223,0.28484706532395115,0.5575925628014088,0.022198063042997453,0.029275447074761134,0.7582484730740384]
["ROTHERHAM PCT",0.0481046365914787,0.05068413488873001,0.9491063958590938,0.14301770050125312,0.2572654724721043,0.5559148653994397,0.022716948621553885,0.02804049212151781,0.8101480003669862]
["REDCAR AND CLEVELAND PCT",0.05063319001570135,0.05497138091591719,0.9210827374547599,0.1466021981892086,0.2706149787514885,0.5417371901051957,0.02476264545761369,0.030232927747744897,0.819062105536926]
["COUNTY DURHAM PCT",0.05286165810177816,0.05240108112173596,1.0087894556788286,0.1490120060030015,0.26332154062938945,0.5658937193168244,0.02358186669092122,0.02874232689119275,0.8204578140173889]
["BLACKBURN WITH DARWEN PCT",0.042377726150365516,0.041896387031151644,1.0114887978014901,0.11664213688832667,0.21850931950553326,0.5338085219993235,0.019759648717356137,0.023808221395208103,0.8299506455922481]
["WAKEFIELD DISTRICT PCT",0.046702996648674125,0.0502166746390851,0.9300296561716936,0.13647599174527625,0.2568436049513154,0.5313583406958691,0.024065738872505908,0.027966767109029303,0.8605120062209867]
["DONCASTER PCT",0.0466499320426863,0.051526414372946396,0.9053595638352732,0.14074967647116204,0.25963869640813786,0.5420982250269476,0.02457843704681576,0.028318227904618756,0.867936974361555]
["BARNSLEY PCT",0.0512300425951146,0.0505932722647081,1.012586067314936,0.14226105962074204,0.2580243435246782,0.5513474336468404,0.026273196537749868,0.02780279267672192,0.9449840828309051]
[]
["England",0.03503865805467897,0.045,0.7786368456595327,0.12790365887277078,0.245,0.5220557505011052,0.014807896732726308,0.0287,0.5159545899904637]
[]
["*Please refer to \"sources\" tab for further information and data copyright "]

{"sheet":"Sources","index":1,"n_rows":58,"n_cols":1,"rows_kept":58,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Source Information"]
[]
["Patients on GP lists diagnosed with each disease - NHS Information Centre, September 2008"]
["Quality and Outcomes Framework (QOF) for April 2007 - March 2008, England, unadjusted disease prevalence by PCT"]
["Unadjusted prevalence = (number of patients on each GP's disease register / GP list size) * 100"]
["For more information see: http://www.ic.nhs.uk/statistics-and-data-collections/audits-and-performance/the-quality-and-outcomes-framework/the-quality-and-outcomes-framework-2007-08"]
[]
["Data source: QMAS database - 2007/08 data as at end of June 2008"]
["Copyright terms: This work remains the sole and exclusive property of the Health and Social Care Information Centre and may only be reproduced where "]
["there is explicit reference to the ownership of the Health and Social Care Information Centre."]
["This work may be re-used by NHS and government organisations without permission."]
["This work is subject to the Re-Use of Public Sector Information Regulations and permission for commercial use must be obtained from the copyright holder."]
["Copyright © 2008, The Health and Social Care Information Centre, Prescribing Support Unit. All rights reserved."]
[]
["Estimates of true prevalence - Eastern Region Public Health Observatory, 2008"]
["EPHRO has developed several disease prevalence models, for full information see: http://www.erpho.org.uk/topics/wcc/data.aspx"]
["Please note: estimates for each disease used here were adjusted for HSJ's use by ERPHO, to take account for all age prevalence, rather than just age 16+ as the published ERPHO models, and allow comparison with GP disease registers"]
[]
["Individual model details: "]
["1. Modelled estimates of prevalence of CHD for PCTs in England, version 1, September 2007"]
["These estimates and projections of the prevalence of CHD in people aged 16+ have been calculated using a model developed at the Dept of Primary Care and Social Medicine, Imperial College, London"]
["The model was developed using data from the 2003-2004 Health Surveys for England"]
["The model takes into account age, sex, ethnicity, smoking status and deprivation score."]
["Input data:"]
["Deprivation scores are from the Indices of Multiple Deprivation 2004 (IMD2004)"]
["Local authority population data for 2005 by age (quinary age band), sex and ethnic group were provided by ONS (unpublished data). Data for LAs were combined to give PCT populations. Note that where PCTs are not coterminous with one LA or a group of LAs there is increased uncertainty in the population breakdown by age, sex and ethnicity."]
["Smoking prevalence is taken from the model-based estimates of healthy lifestyle behaviours, published by the Information Centre. As the model-based estimates do not include prevalence of ex-smokers, the national prevalence of ex-smokers from Health Survey for England 2003-2005 was applied everywhere."]
["Projections:"]
["ONS 2006-based population projections were input into the model to create projections of the prevalence of hypertension to 2020."]
["The 2005 ethnic distribution is used for the 2006 – 2009 projections. The distribution of ethnic groups within the population is lagged by 5, 10 and 15 years for the 2010, 2015 and 2020 projections respectively. So, for example, in 2015 the ethnic distribution in the age group 40-44 is calculated using the ethnic proportions from the 30-34 age group in 2005."]
["For more information see: http://www.erpho.org.uk/viewResource.aspx?id=17903"]
[]
["2. Modelled estimates of prevalence of hypertension for PCTs in England, version 1, September 2008"]
["These estimates and projections of the prevalence of hypertension in people aged 16+ have been calculated using a model developed at the Dept of Primary Care and Social Medicine, Imperial College, London"]
["The model was developed using data from the 2003-2004 Health Surveys for England"]
["The model takes into account age, sex, ethnicity and deprivation score."]
["Input data:"]
["Deprivation scores are from the Indices of Multiple Deprivation 2004 (IMD2004)"]
["Local authority population data for 2005 by age (quinary age band), sex and ethnic group were provided by ONS (unpublished data). Data for LAs were combined to give PCT populations. Note that where PCTs are not coterminous with one LA or a group of LAs there is increased uncertainty in the population breakdown by age, sex and ethnicity."]
["Projections:"]
["ONS 2006-based population projections were input into the model to create projections of the prevalence of hypertension to 2020."]
["The 2005 ethnic distribution is used for the 2006 – 2009 projections. The distribution of ethnic groups within the population is lagged by 5, 10 and 15 years for the 2010, 2015 and 2020 projections respectively. So, for example, in 2015 the ethnic distribution in the age group 40-44 is calculated using the ethnic proportions from the 30-34 age group in 2005."]
["For more information see: http://www.erpho.org.uk/Download/Public/17905/1/Modelled%20hypertension%20by%20PCT.xls"]
[]
["3. Modelled estimates of prevalence of COPD for PCTs in England, version 3, October 2008"]
["These estimates and projections of the prevalence of CHD in people aged 16+ have been calculated using a model developed at the Dept of Primary Care and Social Medicine, Imperial College, London"]
["The model was developed using data from the 2001 Health Survey for England"]
["The model takes into account age, sex, ethnicity, smoking status, rurality and deprivation score."]
["Input data:"]
["Deprivation scores are from the Indices of Multiple Deprivation 2004 (IMD2004)"]
["Population data for 2005 by age (quinary age band), sex and ethnic group were provided by ONS (unpublished data)"]
["Smoking prevalence is taken from the model-based estimates of healthy lifestyle behaviours, published by the Information Centre. As the model-based estimates do not include prevalence of ex-smokers, the national prevalence of ex-smokers from Health Survey for England 2003-2005 was applied everywhere."]
["PCTs are categorised as urban, suburban or rural based on a combination of the percentage of the population living in rural areas and the DEFRA classification as applied to PCTs by NEPHO."]
["Projections:"]
["ONS 2006-based population projections were input into the model to create projections of the prevalence of COPD to 2020."]
["The 2005 ethnic distribution is used for the 2006 – 2009 projections. The distribution of ethnic groups within the population is lagged by 5, 10 and 15 years for the 2010, 2015 and 2020 projections respectively. So, for example, in 2015 the ethnic distribution in the age group 40-44 is calculated using the ethnic proportions from the 30-34 age group in 2005."]
["Projections are not available for City of London or Isles of Scilly local authorities."]
["For more information see: http://www.erpho.org.uk/viewResource.aspx?id=18025"]

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