{"text_format":"2","workbook":"xls","n_sheets":13,"sheets":["Sheet4","A&E","A&E data","Emergency adms","Emergency Adm data","Readmissions","Readmission data","Same day discharge","Same day data","total electives","Electives data","day cases","Overview"],"not_rendered":{"charts":5,"images":0,"macros":0,"external_links":2,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"A&E","index":1,"reason":"not_a_worksheet"},{"sheet":"Emergency adms","index":3,"reason":"not_a_worksheet"},{"sheet":"Readmissions","index":5,"reason":"not_a_worksheet"}],"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":"Sheet4","index":0,"n_rows":15,"n_cols":1,"rows_kept":15,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
["This data was exclusively compiled for HSJ by CHKS for an HSJ special on the NHS in the 4 UK nations"]
["see: 'Huge contrast found between UK nations', Health Service Journal, 28 August 2008, p4-5"]
[]
["For more information on CHKS see:"]
["http://www.chks.co.uk/index.php?aboutus"]
[]
["Original sources: "]
[]
["England: Secondary Users Service/Health Episode Statistics"]
["Scotland: Information Services Division (ISD)"]
["Wales: CHKS's own hospital-level data collections"]
["Northern Ireland: Department for Health Social Services and Public Safety Northern Ireland"]
["Note: Where necessary CHKS has supplemented official data sources with its own hospital-level data collections"]

{"sheet":"A&E data","index":2,"n_rows":10,"n_cols":13,"rows_kept":10,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["A&E New attends rate"]
[]
[null,null,null,"England",null,null,"N. Ireland",null,null,"Scotland",null,null,"Wales"]
[null,"Pop'n","No.","Rate","Pop'n","No.","Rate","Pop'n","No.","Rate","Pop'n","No.","Rate"]
[2002,49450,12953432,261.9500910010111,1689,584350,345.9739490822972,5064,1393016,275.0821484992101,2910,877700,301.6151202749141]
[2003,49647,12852702,258.8817451205511,1697,584062,344.1732469063052,5055,1370201,271.05855588526214,2923,888700,304.0369483407458]
[2004,49856,12945413,259.6560694801027,1703,605001,355.2560187903699,5057,1400469,276.93672137631006,2938,915700,311.6746085772634]
[2005,50093,15312738,305.68618369832114,1710,619289,362.15730994152045,5078,1360477,267.9159117762899,2953,937100,317.33830003386385]
[2006,50431,17775225,352.466241002558,1724,626994,363.6856148491879,5094,1379336,270.77659992147625,2958,942000,318.4584178498986]
[2007,50763,18010506,354.7959340464512,1742,638464,366.51205510907005,5117,1450944,283.55364471369944,2966,0]

{"sheet":"Emergency Adm data","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Emergency admissions - rate"]
[null,null,null,"England",null,null,"N. Ireland",null,null,"Scotland",null,null,"Wales"]
[]
[2002,49450,3938622,79.64857431749242,1689,147772,87.49082297217288,5064,481644,95.11137440758294,2910,0]
[2003,49647,3970216,79.96890043708582,1697,147210,86.74720094284031,5055,476658,94.29436201780416,2923,0]
[2004,49856,4136039,82.95970394736842,1703,150788,88.54257193188491,5057,477938,94.51018390350009,2938,315786,107.48332198774676]
[2005,50093,4492172,89.67664144690875,1710,150992,88.29941520467837,5078,480805,94.68393068137061,2953,313759,106.25093125634947]
[2006,50431,4734329,93.87735718109893,1724,151040,87.61020881670534,5094,486296,95.46446800157048,2958,326866,110.50236646382692]
[2007,50763,4795653,94.4714260386502,1742,145443,83.49196326061998,5117,504078,98.51045534492867,2966,327716,110.49089683074848]

{"sheet":"Readmission data","index":6,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Emergency re-admision rates"]
[null,"England","N. Ireland","Scotland","Wales"]
[]
[2002]
[2003,0.115,0.1,null,0.12]
[2004,0.121,0.106,null,0.099]
[2005,0.128,0.107,null,0.105]
[2006,0.13,0.107,null,0.111]
[2007,0.133,0.09699999999999999,null,0.114]

{"sheet":"Same day discharge","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Same day data","index":8,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["0 LoS emergencies"]
[null,"England","N. Ireland","Scotland","Wales"]
[]
[2002,0.15996564877154504,0.10507510671637758,null,0.1677166167510069]
[2003,0.16603616758167783,0.1047952312168128,null,0.17039997779443194]
[2004,0.17727936840331684,0.10818130649273251,0.15553937779858937,0.17617310457081695]
[2005,0.20708868638137604,0.11507907635117705,0.17715218557713164,0.19090448401480117]
[2006,0.23786308934233505,0.11931047712284276,0.17004589030032968,0.2242111446280739]
[2007,0.25394896357138325,0.12085044431320303,0.15252570450756997,0.23684531728691915]

{"sheet":"total electives","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Electives data","index":10,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Total electives rate"]
[null,null,null,"England",null,null,"N. Ireland",null,null,"Scotland",null,null,"Wales"]
[]
[2002,49450,5576953,112.77963599595552,1689,277028,164.01894612196566,5064,738557,145.84458925750394,2910,0]
[2003,49647,6355651,128.01681874030658,1697,289669,170.69475545079553,5055,713292,141.10623145400592,2923,0]
[2004,49856,6500721,130.38994303594353,1703,306033,179.70229007633588,5057,714464,141.28218311251732,2938,426796,145.26752893124575]
[2005,50093,6612479,132.0040524624199,1710,317095,185.43567251461988,5078,754031,148.48975974793225,2953,420493,142.39519133085]
[2006,50431,7031919,139.4364379052567,1724,328454,190.5185614849188,5094,775864,152.30938358853552,2958,405864,137.20892494929006]
[2007,50763,7373453,145.25250674704017,1742,335909,192.82950631458095,5117,798320,156.01328903654485,2966,378793,127.71173297370196]

{"sheet":"day cases","index":11,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["% of electives (in patients & day cases) treated as day cases"]
[]
[null,"FY ending in"]
[]
[null,null,"England","NI","Scotland","Wales"]
[null,2002,0.6577430917834073,0.6733846759000476,0.5201264086590474]
[null,2003,0.6599526467439577,0.6836686384634936,0.5043909086320889]
[null,2004,0.6622539672348288,0.707293552049634,0.5103168249204998,0.6364786333713404]
[null,2005,0.673105416705458,0.7012419044081803,0.4979914618894979,0.6250828063836193]
[null,2006,0.6837098091353162,0.7049857414233188,0.5059482074177949,0.6092382636377348]
[null,2007,0.7058311564075501,0.7036269339420496,0.5038305441426997,0.6138729948883299]

{"sheet":"Overview","index":12,"n_rows":44,"n_cols":9,"rows_kept":44,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"FY ending in","Population","A&E (New)","EMs","EM re-admissions","Elective IPs","DCs","%age DC"]
[]
[]
["England",2002,49450,12953432,3938622,null,1845184,3546041,0.6577430917834073]
[null,2003,49647,12852702,3970216,0.115,1898533,3684610,0.6599526467439577]
[null,2004,49856,12945413,4136039,0.121,1904253,3733868,0.6622539672348288]
[null,2005,50093,15312738,4492172,0.128,1857450,3824657,0.673105416705458]
[null,2006,50431,17775225,4734329,0.13,1890834,4087328,0.6837098091353162]
[null,2007,50763,18010506,4795653,0.133,1827526,4384981,0.7058311564075501]
[]
["N. Ireland",2002,1689,584350,147772,null,63106,130106,0.6733846759000476]
[null,2003,1697,584062,147210,0.1,63476,137187,0.6836686384634936]
[null,2004,1703,605001,150788,0.106,61615,148886,0.707293552049634]
[null,2005,1710,619289,150992,0.107,64351,151044,0.7012419044081803]
[null,2006,1724,626994,151040,0.107,65071,155498,0.7049857414233188]
[null,2007,1742,638464,145443,0.09699999999999999,67774,160904,0.7036269339420496]
[]
["Scotland",2002,5064,1393016,481644,null,null,384143]
[null,2003,5055,1370201,476658,null,208766,359778,0.632805904204424]
[null,2004,5057,1400469,477938,null,205710,364603,0.6393033299258477]
[null,2005,5078,1360477,480805,null,202090,375501,0.6501157393380437]
[null,2006,5094,1379336,486296,null,208799,392547,0.6527805955306928]
[null,2007,5117,1450944,504078,null,197818,402218,0.6703231139464966]
[]
["Wales",2002,2910,877700]
[null,2003,2923,888700,null,0.12]
[null,2004,2938,915700,315786,0.099,125296,219377,0.6364786333713404]
[null,2005,2953,937100,313759,0.105,124510,207590,0.6250828063836193]
[null,2006,2958,942000,326866,0.111,121768,189849,0.6092382636377348]
[null,2007,2966,null,327716,0.114,129095,205238,0.6138729948883299]
{"$rows_empty":10}
[{"$nulls":5},16711750]