{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Sheet1","Disclaimer","Navigation","s118 A&E Prices","A&E SQL Code","A&E SQL Output","Price Adjustments","2013-14 A&E Tariff ","2014-15 A&E Tariff","Manual adjustment requests","Prices","Link Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
["2015/16 National Tariff Payment System:"]
["A consultation notice"]
[]
["Annex 5g: Accident and emergency (A&E) model"]
[]
[]
[]
[]
[]
[]
["26 November 2014"]
[]
["Monitor publication code: IRCP 14/14"]
[]
["NHS England Publications Gateway Reference 02457"]
["NHS England Document Classification: Official"]
[]
["The complete document set is hosted at:"]
["https://www.gov.uk/government/consultations/national-tariff-payment-system-201516-a-consultation-notice"]

{"sheet":"Disclaimer","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"2015-16 A&E model"]
[]
[null,"Produced by: Monitor"]

{"sheet":"Navigation","index":2,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Steps","Worksheet / Intermediary steps","Overview","Data source"]
[null,"1 >> A&E Prices ","s118 A&E Prices","This worksheet has the s118 prices for A&E "]
[null,"2 >> SQL A&E code","OPATT SQL code","This worksheet shows the OPATT SQL codes","Monitor SQL"]
[null,"3 >> SQL inputs","A&E SQL Output","This worksheet has the total cost and activities.","Monitor SQL"]
[null,"4 >> Non SQL inputs","Price Adjustments","A variety of factors to adjust the prices. Includes: inflation, efficiency, CNST and quantum adjustment.","Mixed (Monitor & External)"]
[null,null,"2013-14 A&E Tariff"]
[null,null,"2014-15 A&E Tariff "]
[null,null,"Expert & Monitor Final Comments","This worksheet displays the changes to tariffs agreed by Monitor."]
[null,"5 >> Processing","A&E 15-16 Draft Model ","Derived table. This is the mapping for percentage split of each TFCs based on HRGs"]
[null,"6 >> Output","Link Sheet","Compares the 2015/16 final prices with that of 2014/15 and 2013/14","PbR 13/14 * 14/15 prices (for % diff calcs)"]

{"sheet":"s118 A&E Prices","index":3,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
["2015-16 tariff - A&E"]
["Home"]
[null,null,"Tariff (£)"]
["HRG code","HRG name","Type 1 and 2 Departments","Type 3 Departments"]
["VB01Z","Any investigation with category 5 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A5,'Link Sheet'!B:E,3,FALSE)","v":238.63891859602694},{"$f":"VLOOKUP(A5,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB02Z","Category 3 investigation with category 4 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A6,'Link Sheet'!B:E,3,FALSE)","v":225.53348936432519},{"$f":"VLOOKUP(A6,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB03Z","Category 3 investigation with category 1-3 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A7,'Link Sheet'!B:E,3,FALSE)","v":191.56519723541047},{"$f":"VLOOKUP(A7,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB04Z","Category 2 investigation with category 4 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A8,'Link Sheet'!B:E,3,FALSE)","v":168.43992527763623},{"$f":"VLOOKUP(A8,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB05Z","Category 2 investigation with category 3 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A9,'Link Sheet'!B:E,3,FALSE)","v":146.01128780586535},{"$f":"VLOOKUP(A9,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB06Z","Category 1 investigation with category 3-4 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A10,'Link Sheet'!B:E,3,FALSE)","v":102.04545692217432},{"$f":"VLOOKUP(A10,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB07Z","Category 2 investigation with category 2 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A11,'Link Sheet'!B:E,3,FALSE)","v":127.76285406506283},{"$f":"VLOOKUP(A11,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB08Z","Category 2 investigation with category 1 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A12,'Link Sheet'!B:E,3,FALSE)","v":116.05498715997055},{"$f":"VLOOKUP(A12,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB09Z","Category 1 investigation with category 1-2 treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A13,'Link Sheet'!B:E,3,FALSE)","v":81.081304380853908},{"$f":"VLOOKUP(A13,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB10Z","Dental Care",{"$f":"VLOOKUP('s118 A&E Prices'!A14,'Link Sheet'!B:E,3,FALSE)","v":56.382241507222588},{"$f":"VLOOKUP(A14,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
["VB11Z","No investigation with no significant treatment",{"$f":"VLOOKUP('s118 A&E Prices'!A15,'Link Sheet'!B:E,3,FALSE)","v":55.6776570878149},{"$f":"VLOOKUP(A15,'Link Sheet'!B:E,4,FALSE)","v":55.6776570878149}]
[]
["Please note that patients who are dead on arrival (DOA) attract the tariff for VB09Z."]

{"sheet":"A&E SQL Code","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Home"]

{"sheet":"A&E SQL Output","index":5,"n_rows":21,"n_cols":4,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Home"]
[null,"AnE SQL Output"]
[]
[null,"Final A&E Total Activity and Cost Draft 33"]
[]
[]
[]
[]
[]
[null,"HRG","SumOfTotal Activity","SumOfTotal Cost"]
[null,"VB01Z",28002,6929753.5088057099]
[null,"VB02Z",80774,18891658.776388198]
[null,"VB03Z",393335,78138787.405618399]
[null,"VB04Z",597172,104311439.809515]
[null,"VB05Z",358112,54224152.002037302]
[null,"VB06Z",450490,47672320.590454802]
[null,"VB07Z",1536505,203575751.24986801]
[null,"VB08Z",4212098,506932036.780334]
[null,"VB09Z",3638615,305945659.161412]
[null,"VB10Z",2314,143090.62948237499]
[null,"VB11Z",5526681,337482184.68877202]

{"sheet":"Price Adjustments","index":6,"n_rows":131,"n_cols":8,"rows_kept":131,"cut":false,"hidden":false,"merged":[[59,1,60,2],[1,2,2,7],[72,1,73,6],[12,1,13,6]]}
["Home"]
[null,null,"Table 1 :  Price Adjustments : Inflation and Efficiency  for all models "]
[]
[null,null,"Adjustment Type","2012/13","2013/14","2014/15","2015/16","Total"]
[null,null,"Inflation",2.1999999999999999E-2,2.7E-2,2.5000000000000001E-2,1.92529689878824E-2,{"$f":"(D5+1)*(E5+1)*(F5+1)*(G5+1)-1","v":9.6546845750163923E-2}]
[null,null,"Efficiency*",-3.6999999999999998E-2,-0.04,-0.04,-3.7999999999999999E-2,-0.1462242304000001]
[null,null,"Inflation and Efficiency (total adjustment)",{"$f":"SUM(D5:D6)","v":-1.4999999999999999E-2},{"$f":"SUM(E5:E6)","v":-1.3000000000000001E-2},-1.4999999999999999E-2,{"$f":"(1+G5)*(1+G6)-1","v":-1.9478643833657161E-2},{"$f":"(1+D7)*(1+E7)*(1+F7)*(1+G7)-1","v":-6.1040909539734511E-2}]
[]
[]
[null,null,"* In 2012-13 the efficiency assumption of 4% was reduced by 0.3% to reflect that BPTs had the effect of reducing overall reimbursement"]
[null,null,"We use a chain linking the post adjustments for joining the efficiency and inflation adjustment together from 2015/16 onwards (this is a slight methodological change from the 13/14 DH method)."]
[]
[null,"Table 2:  Price Adjustments : CNST increase / decrease"]
[]
[null,"Sub-chapter","2012/13","2013/14","2014/15","2015/16","Total"]
[null,"AA",4.4999999999999997E-3,2.7120631448189769E-3,4.0331192887210765E-3,1.0177215451362853E-2,{"$f":"(1+C16)*(1+D16)*(1+E16)*(1+F16)-1","v":2.1578603878145808E-2}]
[null,"AB",3.0000000000000001E-3,4.6639054280992465E-3,2.5168995621460688E-3,6.6765943715936249E-3,{"$f":"(1+C17)*(1+D17)*(1+E17)*(1+F17)-1","v":1.6958911118215347E-2}]
[null,"BZ",2.5999999999999999E-3,1.7135629937548025E-3,2.2965609688603283E-3,1.0261263587219016E-2,1.6953735103538037E-2]
[null,"CZ",1.1999999999999999E-3,7.9831600546853565E-4,8.2227697699654989E-4,5.6058125571560868E-3,8.4448337773224136E-3]
[null,"DZ",4.0000000000000002E-4,2.0988348940491619E-3,1.1281882920322062E-5,1.9793446362510458E-3,4.4952992519378121E-3]
[null,"EA",1.4E-3,6.8376141339254737E-4,8.7019419478395754E-4,3.7895588805165747E-3,6.7574905557648002E-3]
[null,"EB",6.9999999999999999E-4,9.0147384402938791E-4,7.2782220278599929E-4,2.8193295764649129E-3,5.156994822266503E-3]
[null,"FZ",1.6000000000000001E-3,6.9434276756650259E-3,2.0934300240254E-3,9.1560377809849491E-3,1.99195704490156E-2]
[null,"GA",1.6999999999999999E-3,8.3929962527324875E-3,3.2548782592356496E-3,1.1829802699427461E-2,2.5383303906515886E-2]
[null,"GB",1.1000000000000001E-3,3.9857657915021161E-3,1.4670447677391785E-3,5.3411568127927911E-3,1.1940882083719018E-2]
[null,"GC",1.6000000000000001E-3,6.1396776298163758E-3,1.7811411022434775E-3,9.4532152722328622E-3,1.9087886138314136E-2]
[null,"HA",5.5999999999999999E-3,1.1458715826883292E-2,3.9247569065956611E-3,1.1981487115819478E-2,3.3349319057410565E-2]
[null,"HB",5.0000000000000001E-3,1.0604363193151389E-2,3.6557798734122571E-3,1.4053199411787176E-2,3.369582040914354E-2]
[null,"HC",8.6999999999999994E-3,6.3163971875872527E-3,5.2421680236163226E-3,1.4706483431278672E-2,3.5398910168665143E-2]
[null,"HD",1.4E-3,4.2221839108231851E-3,1.2461541146224775E-4,6.6808193690850448E-3,1.2472668600720604E-2]
[null,"HR",4.4999999999999997E-3,6.112531021233325E-3,2.0507319365403731E-3,1.4856762913476818E-2,2.7758220049307836E-2]
[null,"JA",1.1999999999999999E-3,6.4304063507034659E-3,1.2794280689145676E-3,1.0111722621042762E-2,1.9129316574356681E-2]
[null,"JC",1.9E-3,3.6510830811316008E-3,1.7803936364513273E-3,8.9561727149987114E-3,1.6370294680831288E-2]
[null,"JD",8.9999999999999998E-4,2.6729961073768127E-3,1.0486026327254372E-3,4.934546700731568E-3,9.5851361793946044E-3]
[null,"KA",1.4E-3,3.8450441685828896E-3,9.4410677570055945E-4,7.5987092544294033E-3,1.3845308353879426E-2]
[null,"KB",2.9999999999999997E-4,3.5166956544530059E-4,6.6025179707085435E-4,2.7523453530222675E-3,4.0684148875396176E-3]
[null,"KC",4.0000000000000002E-4,1.0156478917267009E-3,1.2352320038200304E-4,2.4360848281963499E-3,3.979588062138939E-3]
[null,"LA",8.0000000000000004E-4,8.7420520085790265E-4,5.1491581673213105E-4,2.3954248606512518E-3,4.5913552933345425E-3]
[null,"LB",1E-3,4.58633918397644E-3,1.1234991714843545E-3,5.6908587612691797E-3,1.2449811445268688E-2]
[null,"LD",0,0,0,0,0]
[null,"MA",0,5.1603725608684536E-2,4.0632237452609132E-3,2.1116748963414533E-2,7.8173308502440308E-2]
[null,"MB",2.9999999999999997E-4,4.6619290226565857E-2,1.5009122892200022E-3,1.6660903497712098E-2,6.5973665508151091E-2]
[null,"NZ",2E-3,-8.928019846899482E-2,2.8267565859709798E-2,0,-6.1663439232474193E-2]
[null,"PA",3.8999999999999998E-3,4.4827502314648271E-4,4.3834448710582397E-3,1.7225773682364887E-2,2.6129079145124301E-2]
[null,"PB",0,0,0,0,0]
[null,"QZ",2.0999999999999999E-3,1.7265642874806364E-3,3.1319345733256121E-3,9.7245168640109902E-3,1.6766457367436649E-2]
[null,"RA",0,0,0,0,0]
[null,"RC",0,0,0,9.9712797237090367E-3,9.9712797237090367E-3]
[null,"SA",4.0000000000000002E-4,6.3410046328193914E-4,-5.5466412123872377E-4,4.7664017120279123E-3,5.2478016357233592E-3]
[null,"SB",0,0,0,0,0]
[null,"SC",0,0,0,0,0]
[null,"UZ",0,0,0,0,0]
[null,"VA",4.7000000000000002E-3,1.3678608794291724E-2,3.1799566526078404E-3,1.1581606613703554E-2,3.3514215771978773E-2]
[null,"WA",1.1999999999999999E-3,1.3776568699075398E-4,1.0210188461163838E-3,5.2826577942732822E-3,{"$f":"(1+C54)*(1+D54)*(1+E54)*(1+F54)-1","v":7.6554424401875654E-3}]
[null,"VB",1.61E-2,1.1539171571975482E-2,7.33525858395212E-3,2.1468190008266497E-2,{"$f":"(1+C55)*(1+D55)*(1+E55)*(1+F55)-1","v":5.7591711859506622E-2}]
[null,"Maternity*",null,null,2.8299999999999999E-2,0.11086894010165449,{"$f":"(1+C56)*(1+D56)*(1+E56)*(1+F56)-1","v":0.14230653110653124}]
[null,"* Note: Maternity is delivery element only."]
[]
[]
[null," Table 3: Quantum Reconciliation (QR)"]
[]
[null,"Components ","Value "]
[null,"Admitted patient care",0]
[null,"Outpatient procedures",0]
[null,"Outpatient attendances",0]
[null,"A&E",4.6061801671540836E-2]
[null,"Unbundled services",0]
[null,"Best Practice Tariffs",0]
[null,"Maternity pathway",0]
[null,"Other mandatory prices",0]
[null,"Non-mandatory Prices",0]
[]
[null,"Table 4:  Price Adjustments : Affordability and other adjustment"]
[]
[null,"Adjustment Type","2012/13","2013/14","2014/15","2015/16","Total"]
[null,"APC & OPROC"]
[null,"Factor 1 (Scaling factor used in sql)",null,-9.4999999999999998E-3]
[null,"Factor 3 (Top slice)",null,-1.39759014037564E-2]
[null,"Factor 4 (Undo Affordability)",null,9.2061283461699599E-3]
[null,"Factor 5 (Post SC Affordability)",null,-6.4999999999999997E-3]
[null,"Factor 6 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,{"$f":"(1+D77)*(1+D79)*(1+D80)*(1+D81)-1","v":-1.1943769087675693E-2},null,null,{"$f":"(1+C82)*(1+D82)-1","v":-1.1943769087675693E-2}]
[]
[null,"OPATT"]
[null,"Factor 1 (First affordability)",null,-9.4999999999999998E-3]
[null,"Factor 2 (Second affordability, ref 2012-13)",null,-1.4999999999999999E-2]
[null,"Factor 4 (Undo first affordability)",null,9.4999999999999998E-3]
[null,"Factor 5 (Fourth affordability)",null,-2.5499999999999998E-2]
[null,"Factor 6 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,-4.5099088335707083E-2,null,null,{"$f":"(1+C90)*(1+D90)-1","v":-4.5099088335707083E-2}]
[]
[null,"A&E"]
[null,"Factor 1 (First Affordability)",null,-6.6000000000000003E-2]
[null,"Factor 2 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,-7.0763400000000032E-2,null,null,{"$f":"(1+D95)-1","v":-7.0763400000000032E-2}]
[]
[null,"Unbundled Services"]
[null,"Factor 1 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Direct access and outpatient diagnostic imaging services",null,-5.1000000000000004E-3]
[null,"Unbundled chemotherapy delivery",null,0]
[null,"Unbundled external beam radiotherapy",null,0]
[null,"Total",null,-5.0999999999999934E-3,null,null,{"$f":"(1+D102)-1","v":-5.0999999999999934E-3}]
[]
[null,"Maternity Pathway"]
[null,"Factor 1 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,-5.0999999999999934E-3,null,null,{"$f":"(1+D106)-1","v":-5.0999999999999934E-3}]
[]
[null,"Non-mandatory"]
[null,"Factor 1 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,-5.0999999999999934E-3,null,null,{"$f":"(1+D110)-1","v":-5.0999999999999934E-3}]
[]
[null,"BPT"]
[null,"Factor 1 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Acute stroke care",null,-5.1000000000000004E-3]
[null,"Adult renal dialysis",null,0]
[null,"Daycases",null,-5.1000000000000004E-3]
[null,"Diabetic ketoacidosis and hypoglycaemia",null,-5.1000000000000004E-3]
[null,"Early inflammatory arthritis",null,-5.1000000000000004E-3]
[null,"Endoscopy procedures",null,-5.1000000000000004E-3]
[null,"Fragility hip fracture",null,-5.1000000000000004E-3]
[null,"Interventional radiology",null,-5.1000000000000004E-3]
[null,"Major trauma",null,0]
[null,"Outpatient procedures",null,-5.1000000000000004E-3]
[null,"Paediatric diabetes year of care",null,0]
[null,"Paediatric epilepsy",null,0]
[null,"Parkinson's disease",null,-5.1000000000000004E-3]
[null,"Pleural effusion",null,-5.1000000000000004E-3]
[null,"Primary total hip and knee replacements",null,-5.1000000000000004E-3]
[null,"Same day emergency care",null,-5.1000000000000004E-3]
[null,"Transient ischaemic attack",null,-5.1000000000000004E-3]
[null,"Total",null,-5.0999999999999934E-3,null,null,{"$f":"(1+D131)-1","v":-5.0999999999999934E-3}]

{"sheet":"2013-14 A&E Tariff ","index":7,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
["2013-14 tariff - A&E",null,null,null,null,"Source: ","https://www.gov.uk/government/publications/payment-by-results-pbr-operational-guidance-and-tariffs "]
["Home"]
[]
[null,null,"Tariff (£)"]
["HRG code","HRG name","Type 1 and 2 Departments","Type 3 Departments"]
["VB01Z","Any investigation with category 5 treatment",237,58]
["VB02Z","Category 3 investigation with category 4 treatment",210,58]
["VB03Z","Category 3 investigation with category 1-3 treatment",164,58]
["VB04Z","Category 2 investigation with category 4 treatment",139,58]
["VB05Z","Category 2 investigation with category 3 treatment",130,58]
["VB06Z","Category 1 investigation with category 3-4 treatment",102,58]
["VB07Z","Category 2 investigation with category 2 treatment",119,58]
["VB08Z","Category 2 investigation with category 1 treatment",110,58]
["VB09Z","Category 1 investigation with category 1-2 treatment",78,58]
["VB10Z","Dental Care",59,58]
["VB11Z","No investigation with no significant treatment",58,58]
[]
["Please note that patients who are dead on arrival (DOA) attract the tariff for VB09Z."]

{"sheet":"2014-15 A&E Tariff","index":8,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
["2014-15 tariff - A&E",null,"Source: ","http://www.monitor.gov.uk/sites/all/modules/fckeditor/plugins/ktbrowser/_openTKFile.php?id=45704"]
["Home"]
[null,null,"Tariff (£)"]
["HRG code","HRG name","Type 1 and 2 Departments","Type 3 Departments"]
["VB01Z","Any investigation with category 5 treatment",235,57]
["VB02Z","Category 3 investigation with category 4 treatment",208,57]
["VB03Z","Category 3 investigation with category 1-3 treatment",163,57]
["VB04Z","Category 2 investigation with category 4 treatment",138,57]
["VB05Z","Category 2 investigation with category 3 treatment",129,57]
["VB06Z","Category 1 investigation with category 3-4 treatment",101,57]
["VB07Z","Category 2 investigation with category 2 treatment",118,57]
["VB08Z","Category 2 investigation with category 1 treatment",109,57]
["VB09Z","Category 1 investigation with category 1-2 treatment",77,57]
["VB10Z","Dental Care",58,57]
["VB11Z","No investigation with no significant treatment",57,57]
[]
["Please note that patients who are dead on arrival (DOA) attract the tariff for VB09Z."]

{"sheet":"Manual adjustment requests","index":9,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Home"]
["HRG","HRG description","Pre TED Expert comments","Monitor (pre TED) assessment","Summary of TED responses and other post TED comments","Monitor (post TED) assessment","Final (post TED) implementation instructions for manual adjustments"]
["VB01Z","Emergency Medicine, Any Investigation with Category 5 Treatment","It is difficult to justify reducing the tariff for the most injured/unwell patients as the cost of care will not have decreased. It is likely to have a disproportionate effect on large EDs as care of more complex cases is centralised","no action ","The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB02Z","Emergency Medicine, Category 3 Investigation with Category 4 Treatment",null,null,"The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB03Z","Emergency Medicine, Category 3 Investigation with Category 1-3 Treatment",null,null,"The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB04Z","Emergency Medicine, Category 2 Investigation with Category 4 Treatment",null,null,"The increase in VB04Z is too large to compensate the decreases in VB11Z. \nResults in a 5% increase (£900k) increase in revenue across providers.\n\nSince the 2011/12 RC model Providers have increased in size and the improved coding results in more activity in the more complex HRGs \n\nThe NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB05Z","Emergency Medicine, Category 2 Investigation with Category 3 Treatment",null,null,"The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB06Z","Emergency Medicine, Category 1 Investigation with Category 3-4 Treatment",null,null,"The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB07Z","Emergency Medicine, Category 2 Investigation with Category 2 Treatment",null,null,"The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB08Z","Emergency Medicine, Category 2 Investigation with Category 1 Treatment",null,null,"The NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB09Z","Emergency Medicine, Category 1 Investigation with Category 1-2 Treatment",null,null,"Want NP to reflect the Providers cost of provision.\n\nThe lower value NP's should be reduced to reflect the increase to the higher value NP's. So the cost quantum remains the same. \n\nThe NP changes mean additional provider income from the same service provided.\n\nThe NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically).","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB10Z","Emergency Medicine, Dental Care",null,null,"The lower value NP's should be reduced to reflect the increase to the higher value NP's. So the cost quantum remains the same\n\nThe NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]
["VB11Z","Emergency Medicine, No Investigation with No Significant Treatment",null,null,"The decrease (what decrease) in VB11Z is too small to compensate the increases in VB04Z. \nResults in a 5% increase (£900k) increase in revenue across providers.\n\nThe NP should reflect the actual costs incurred, without any adj to reduce the impact on commissioners (which was done historically)","The s118 prices are acceptable in line with the updated cost base. No adjustment required","No Action"]

{"sheet":"Prices","index":10,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":false,"merged":[[58,11,59,11],[19,13,19,17],[19,19,19,23],[58,2,59,2],[58,3,59,3],[58,4,59,4],[58,5,59,5],[57,2,57,5],[58,12,59,12],[38,12,39,12],[58,7,59,7],[58,8,59,8],[58,9,59,9],[58,10,59,10],[19,7,19,11],[37,2,37,5],[38,5,39,5],[38,4,39,4],[38,3,39,3],[38,2,39,2],[38,11,39,11],[38,10,39,10],[38,9,39,9],[38,8,39,8],[38,7,39,7]]}
[null,null,"Home"]
[null,null,"A&E Price Adjustments"]
[]
[]
[]
[]
[null,null,"Individual adjustment factors"]
[]
[null,null,"Adjustment Type",null,{"$f":"'Price Adjustments'!D4","v":"2012/13"},{"$f":"'Price Adjustments'!E4","v":"2013/14"},{"$f":"'Price Adjustments'!F4","v":"2014/15"},{"$f":"'Price Adjustments'!G4","v":"2015/16"},{"$f":"'Price Adjustments'!H4","v":"Total"}]
[null,null,"CNST (chapter V)",null,{"$f":"'Price Adjustments'!C55","v":1.61E-2},{"$f":"'Price Adjustments'!D55","v":1.1539171571975482E-2},{"$f":"'Price Adjustments'!E55","v":7.33525858395212E-3},{"$f":"'Price Adjustments'!F55","v":2.1468190008266497E-2},{"$f":"'Price Adjustments'!G55","v":5.7591711859506622E-2}]
[null,null,"Inflation",null,{"$f":"'Price Adjustments'!D5","v":2.1999999999999999E-2},{"$f":"'Price Adjustments'!E5","v":2.7E-2},{"$f":"'Price Adjustments'!F5","v":2.5000000000000001E-2},{"$f":"'Price Adjustments'!G5","v":1.92529689878824E-2},{"$f":"'Price Adjustments'!H5","v":9.6546845750163923E-2}]
[null,null,"Efficiency",null,{"$f":"'Price Adjustments'!D6","v":-3.6999999999999998E-2},{"$f":"'Price Adjustments'!E6","v":-0.04},{"$f":"'Price Adjustments'!F6","v":-0.04},{"$f":"'Price Adjustments'!G6","v":-3.7999999999999999E-2},{"$f":"'Price Adjustments'!H6","v":-0.1462242304000001}]
[null,null,"Inflation and Efficiency",null,{"$f":"'Price Adjustments'!D7+E14","v":-1.4999999999999999E-2},{"$f":"'Price Adjustments'!E7+F14","v":-8.3763400000000029E-2},{"$f":"'Price Adjustments'!F7+G14","v":-1.4999999999999999E-2},{"$f":"'Price Adjustments'!G7*(1+H14)","v":-1.9478643833657161E-2},{"$f":"(1+E13)*(1+F13)*(1+G13)*(1+H13)-1","v":-0.12835999535723797}]
[null,null,"Affordability",null,{"$f":"'Price Adjustments'!C95","v":0},{"$f":"'Price Adjustments'!D95","v":-7.0763400000000032E-2},{"$f":"'Price Adjustments'!E95","v":0},{"$f":"'Price Adjustments'!F95","v":0},{"$f":"(1+E14)*(1+F14)*(1+G14)*(1+H14)-1","v":-7.0763400000000032E-2}]
[]
[]
[]
[]
[]
[null,"A&E 2015/16 Tariff Method selector",null,null,null,"Tariff Selection",null,"A&E 2015/16 Final Tariff (£)",null,null,null,null,null,"Comparison with 14/15",null,null,null,null,null,"Comparison with 13/14"]
[null,null,"HRG code","HRG name","Pricing method used","Type 1 and 2 Departments",null,"Quantum Adjustment","Final Price Type 1 and 2 after quantum adjustment","Rounded Type 1 and Type 2 Departments ","2015/16 tariff - Type 1 and 2 Departments","2015/16 tariff Type 3 Departments",null,"Type 1 and 2 Departments ","Type 3 Departments",null,"Type 1 and 2 Departments (percentage difference)","Type 3 Departments (percentage difference)",null,"Type 1 and 2 Departments ","Type 3 Departments",null,"Type 1 and 2 Departments (percentage difference)","Type 3 Departments (percentage difference comparison)"]
[null,null,"VB01Z","Emergency Medicine, Any Investigation with Category 5 Treatment","Modelled",{"$f":"IF(E22=\"Modelled\",VLOOKUP(C22,$C$41:$M$51,11,FALSE),IF(E22=\"Rollover\",VLOOKUP(C22,$C$61:$M$71,11,FALSE),\"Error\"))","v":228.13080280218338},null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},{"$f":"F22*(1+H22)","v":238.63891859602694},{"$f":"ROUND(I22,0)","v":239},{"$f":"J22","v":239},{"$f":"MIN(K22:K32)","v":56},null,{"$f":"VLOOKUP(C22,'2014-15 A&E Tariff'!A5:D15,3,FALSE)","v":235},{"$f":"VLOOKUP(C22,'2014-15 A&E Tariff'!A5:D15,4,FALSE)","v":57},null,{"$f":"(K22-N22)/K22","v":1.6736401673640166E-2},{"$f":"(L22-O22)/L22","v":-1.7857142857142856E-2},null,{"$f":"VLOOKUP(C22,'2013-14 A&E Tariff '!A6:D16,3,FALSE)","v":237},{"$f":"VLOOKUP(C22,'2013-14 A&E Tariff '!A6:D16,4,FALSE)","v":58},null,{"$f":"(K22-T22)/K22","v":8.368200836820083E-3},{"$f":"(L22-U22)/L22","v":-3.5714285714285712E-2}]
[null,null,"VB02Z","Emergency Medicine, Category 3 Investigation with Category 4 Treatment","Modelled",215.6024519812662,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},225.53348936432519,226,{"$f":"J23","v":226},56,null,{"$f":"VLOOKUP(C23,'2014-15 A&E Tariff'!A6:D16,3,FALSE)","v":208},{"$f":"VLOOKUP(C23,'2014-15 A&E Tariff'!A6:D16,4,FALSE)","v":57},null,{"$f":"(K23-N23)/K23","v":7.9646017699115043E-2},{"$f":"(L23-O23)/L23","v":-1.7857142857142856E-2},null,{"$f":"VLOOKUP(C23,'2013-14 A&E Tariff '!A7:D17,3,FALSE)","v":210},{"$f":"VLOOKUP(C23,'2013-14 A&E Tariff '!A7:D17,4,FALSE)","v":58},null,{"$f":"(K23-T23)/K23","v":7.0796460176991149E-2},{"$f":"(L23-U23)/L23","v":-3.5714285714285712E-2}]
[null,null,"VB03Z","Emergency Medicine, Category 3 Investigation with Category 1-3 Treatment","Modelled",183.12990392087863,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},191.56519723541047,192,192,56,null,{"$f":"VLOOKUP(C24,'2014-15 A&E Tariff'!A7:D17,3,FALSE)","v":163},{"$f":"VLOOKUP(C24,'2014-15 A&E Tariff'!A7:D17,4,FALSE)","v":57},null,0.15104166666666666,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C24,'2013-14 A&E Tariff '!A8:D18,3,FALSE)","v":164},{"$f":"VLOOKUP(C24,'2013-14 A&E Tariff '!A8:D18,4,FALSE)","v":58},null,{"$f":"(K24-T24)/K24","v":0.14583333333333334},{"$f":"(L24-U24)/L24","v":-3.5714285714285712E-2}]
[null,null,"VB04Z","Emergency Medicine, Category 2 Investigation with Category 4 Treatment","Modelled",161.0229194952725,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},168.43992527763623,168,168,56,null,{"$f":"VLOOKUP(C25,'2014-15 A&E Tariff'!A8:D18,3,FALSE)","v":138},{"$f":"VLOOKUP(C25,'2014-15 A&E Tariff'!A8:D18,4,FALSE)","v":57},null,0.17857142857142858,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C25,'2013-14 A&E Tariff '!A9:D19,3,FALSE)","v":139},{"$f":"VLOOKUP(C25,'2013-14 A&E Tariff '!A9:D19,4,FALSE)","v":58},null,0.17261904761904762,-3.5714285714285712E-2]
[null,null,"VB05Z","Emergency Medicine, Category 2 Investigation with Category 3 Treatment","Modelled",139.5818942748397,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},146.01128780586535,146,146,56,null,{"$f":"VLOOKUP(C26,'2014-15 A&E Tariff'!A9:D19,3,FALSE)","v":129},{"$f":"VLOOKUP(C26,'2014-15 A&E Tariff'!A9:D19,4,FALSE)","v":57},null,0.11643835616438356,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C26,'2013-14 A&E Tariff '!A10:D20,3,FALSE)","v":130},{"$f":"VLOOKUP(C26,'2013-14 A&E Tariff '!A10:D20,4,FALSE)","v":58},null,0.1095890410958904,-3.5714285714285712E-2]
[null,null,"VB06Z","Emergency Medicine, Category 1 Investigation with Category 3-4 Treatment","Modelled",97.552034458300753,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},102.04545692217432,102,102,56,null,{"$f":"VLOOKUP(C27,'2014-15 A&E Tariff'!A10:D20,3,FALSE)","v":101},{"$f":"VLOOKUP(C27,'2014-15 A&E Tariff'!A10:D20,4,FALSE)","v":57},null,9.8039215686274508E-3,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C27,'2013-14 A&E Tariff '!A11:D21,3,FALSE)","v":102},{"$f":"VLOOKUP(C27,'2013-14 A&E Tariff '!A11:D21,4,FALSE)","v":58},null,0,-3.5714285714285712E-2]
[null,null,"VB07Z","Emergency Medicine, Category 2 Investigation with Category 2 Treatment","Modelled",122.13700362722913,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},127.76285406506283,128,128,56,null,{"$f":"VLOOKUP(C28,'2014-15 A&E Tariff'!A11:D21,3,FALSE)","v":118},{"$f":"VLOOKUP(C28,'2014-15 A&E Tariff'!A11:D21,4,FALSE)","v":57},null,7.8125E-2,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C28,'2013-14 A&E Tariff '!A12:D22,3,FALSE)","v":119},{"$f":"VLOOKUP(C28,'2013-14 A&E Tariff '!A12:D22,4,FALSE)","v":58},null,7.03125E-2,-3.5714285714285712E-2]
[null,null,"VB08Z","Emergency Medicine, Category 2 Investigation with Category 1 Treatment","Modelled",110.94467551967006,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},116.05498715997055,116,116,56,null,{"$f":"VLOOKUP(C29,'2014-15 A&E Tariff'!A12:D22,3,FALSE)","v":109},{"$f":"VLOOKUP(C29,'2014-15 A&E Tariff'!A12:D22,4,FALSE)","v":57},null,6.0344827586206899E-2,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C29,'2013-14 A&E Tariff '!A13:D23,3,FALSE)","v":110},{"$f":"VLOOKUP(C29,'2013-14 A&E Tariff '!A13:D23,4,FALSE)","v":58},null,5.1724137931034482E-2,-3.5714285714285712E-2]
[null,null,"VB09Z","Emergency Medicine, Category 1 Investigation with Category 1-2 Treatment","Modelled",77.511007716074801,null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},81.081304380853908,81,81,56,null,{"$f":"VLOOKUP(C30,'2014-15 A&E Tariff'!A13:D23,3,FALSE)","v":77},{"$f":"VLOOKUP(C30,'2014-15 A&E Tariff'!A13:D23,4,FALSE)","v":57},null,4.9382716049382713E-2,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C30,'2013-14 A&E Tariff '!A14:D24,3,FALSE)","v":78},{"$f":"VLOOKUP(C30,'2013-14 A&E Tariff '!A14:D24,4,FALSE)","v":58},null,3.7037037037037035E-2,-3.5714285714285712E-2]
[null,null,"VB10Z","Emergency Medicine, Dental Care","Modelled",{"$f":"IF(E31=\"Modelled\",VLOOKUP(C31,$C$41:$M$51,11,FALSE),IF(E31=\"Rollover\",VLOOKUP(C31,$C$61:$M$71,11,FALSE),\"Error\"))","v":53.899531956073069},null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},56.382241507222588,56,56,56,null,{"$f":"VLOOKUP(C31,'2014-15 A&E Tariff'!A14:D24,3,FALSE)","v":58},{"$f":"VLOOKUP(C31,'2014-15 A&E Tariff'!A14:D24,4,FALSE)","v":57},null,-3.5714285714285712E-2,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C31,'2013-14 A&E Tariff '!A15:D25,3,FALSE)","v":59},{"$f":"VLOOKUP(C31,'2013-14 A&E Tariff '!A15:D25,4,FALSE)","v":58},null,-5.3571428571428568E-2,-3.5714285714285712E-2]
[null,null,"VB11Z","Emergency Medicine, No Investigation with No Significant Treatment","Modelled",{"$f":"IF(E32=\"Modelled\",VLOOKUP(C32,$C$41:$M$51,11,FALSE),IF(E32=\"Rollover\",VLOOKUP(C32,$C$61:$M$71,11,FALSE),\"Error\"))","v":53.225972881186863},null,{"$f":"'Price Adjustments'!$C$66","v":4.6061801671540836E-2},55.6776570878149,56,56,56,null,{"$f":"VLOOKUP(C32,'2014-15 A&E Tariff'!A15:D25,3,FALSE)","v":57},{"$f":"VLOOKUP(C32,'2014-15 A&E Tariff'!A15:D25,4,FALSE)","v":57},null,-1.7857142857142856E-2,-1.7857142857142856E-2,null,{"$f":"VLOOKUP(C32,'2013-14 A&E Tariff '!A16:D26,3,FALSE)","v":58},{"$f":"VLOOKUP(C32,'2013-14 A&E Tariff '!A16:D26,4,FALSE)","v":58},null,-3.5714285714285712E-2,-3.5714285714285712E-2]
[]
[]
[null,null,"A&E 15/16 draft tariff prices using the 13/14 PbR Method"]
[null,null,"Type 1 and Type 2 departments"]
[]
[null,null,"SQL Modelled Values",null,null,null,null,null,null,"Additional Adjustments"]
[null,null,"HRG code","Description","SumOfTotal Activity","SumOfTotal Cost",null,"Modelled Price","CNST","Inflation and Efficiency","Adjustment Application","Difference to prior step","Modelled Tariff"]
[null,null,null,null,null,null,null,null,null,null,null,"Difference to prior step"]
[null,null,"VB01Z","Any investigation with category 5 treatment",{"$f":"VLOOKUP(C41,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":28002},{"$f":"VLOOKUP(C41,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":6929753.5088057099},null,{"$f":"F41/E41","v":247.47352006305655},{"$f":"$I$10","v":5.7591711859506622E-2},{"$f":"$I$13","v":-0.12835999535723797},{"$f":"H41*(I41+1)*(J41+1)","v":228.13080280218338},{"$f":"(K41/H41)-1","v":-7.8160755364633072E-2},{"$f":"K41","v":228.13080280218338}]
[null,null,"VB02Z","Category 3 investigation with category 4 treatment",{"$f":"VLOOKUP(C42,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":80774},{"$f":"VLOOKUP(C42,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":18891658.776388198},null,233.88291747825039,{"$f":"$I$10","v":5.7591711859506622E-2},{"$f":"$I$13","v":-0.12835999535723797},215.6024519812662,{"$f":"(K42/H42)-1","v":-7.8160755364633072E-2},215.6024519812662]
[null,null,"VB03Z","Category 3 investigation with category 1-3 treatment",{"$f":"VLOOKUP(C43,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":393335},{"$f":"VLOOKUP(C43,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":78138787.405618399},null,198.65709231474037,5.7591711859506622E-2,-0.12835999535723797,183.12990392087863,-7.8160755364632961E-2,183.12990392087863]
[null,null,"VB04Z","Category 2 investigation with category 4 treatment",{"$f":"VLOOKUP(C44,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":597172},{"$f":"VLOOKUP(C44,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":104311439.809515},null,174.67570450308287,5.7591711859506622E-2,-0.12835999535723797,161.0229194952725,-7.816075536463285E-2,161.0229194952725]
[null,null,"VB05Z","Category 2 investigation with category 3 treatment",{"$f":"VLOOKUP(C45,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":358112},{"$f":"VLOOKUP(C45,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":54224152.002037302},null,151.41674113695521,5.7591711859506622E-2,-0.12835999535723797,139.5818942748397,-7.8160755364632961E-2,139.5818942748397]
[null,null,"VB06Z","Category 1 investigation with category 3-4 treatment",{"$f":"VLOOKUP(C46,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":450490},{"$f":"VLOOKUP(C46,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":47672320.590454802},null,105.82326042854403,5.7591711859506622E-2,-0.12835999535723797,97.552034458300753,-7.8160755364632961E-2,97.552034458300753]
[null,null,"VB07Z","Category 2 investigation with category 2 treatment",{"$f":"VLOOKUP(C47,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":1536505},{"$f":"VLOOKUP(C47,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":203575751.24986801},null,132.49273594935781,5.7591711859506622E-2,-0.12835999535723797,122.13700362722913,-7.8160755364632961E-2,122.13700362722913]
[null,null,"VB08Z","Category 2 investigation with category 1 treatment",{"$f":"VLOOKUP(C48,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":4212098},{"$f":"VLOOKUP(C48,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":506932036.780334},null,120.35143455359633,5.7591711859506622E-2,-0.12835999535723797,110.94467551967006,-7.8160755364632961E-2,110.94467551967006]
[null,null,"VB09Z","Category 1 investigation with category 1-2 treatment",{"$f":"VLOOKUP(C49,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":3638615},{"$f":"VLOOKUP(C49,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":305945659.161412},null,84.082998383014413,5.7591711859506622E-2,-0.12835999535723797,77.511007716074801,-7.816075536463285E-2,77.511007716074801]
[null,null,"VB10Z","Dental Care",{"$f":"VLOOKUP(C50,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":2314},{"$f":"VLOOKUP(C50,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":143090.62948237499},null,61.836918531709159,0,-0.12835999535723797,53.899531956073069,-0.12835999535723797,53.899531956073069]
[null,null,"VB11Z","No investigation with no significant treatment",{"$f":"VLOOKUP(C51,'A&E SQL Output'!$B$11:$D$22,2,FALSE)","v":5526681},{"$f":"VLOOKUP(C51,'A&E SQL Output'!$B$11:$D$22,3,FALSE)","v":337482184.68877202},null,61.064169379193771,0,-0.12835999535723797,53.225972881186863,-0.12835999535723797,53.225972881186863]
[]
[]
[]
[null,null,"A&E 15/16 draft tariff prices using a rollover (14/15 Monitor) Method"]
[null,null,"Type 1 and Type 2 departments"]
[]
[null,null,"SQL Modelled Values",null,null,null,null,null,null,"Additional Adjustments"]
[null,null,"HRG code","Description","SumOfTotal Activity","SumOfTotal Cost",null,"2014/15 Price","CNST","Inflation and Efficiency","Adjustment Application","Difference to prior step","Rollover Tariff"]
[]
[null,null,"VB01Z","Any investigation with category 5 treatment","-","-",null,{"$f":"VLOOKUP(C61,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":235},{"$f":"$H$10","v":2.1468190008266497E-2},{"$f":"$H$13","v":-1.9478643833657161E-2},{"$f":"H61*(I61+1)*(J61+1)","v":235.369273112706},{"$f":"(K61/H61)-1","v":1.5713749476851113E-3},{"$f":"K61","v":235.369273112706}]
[null,null,"VB02Z","Category 3 investigation with category 4 treatment","-","-",null,{"$f":"VLOOKUP(C62,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":208},{"$f":"$H$10","v":2.1468190008266497E-2},{"$f":"$H$13","v":-1.9478643833657161E-2},208.32684598911851,1.5713749476851113E-3,208.32684598911851]
[null,null,"VB03Z","Category 3 investigation with category 1-3 treatment","-","-",null,{"$f":"VLOOKUP(C63,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":163},2.1468190008266497E-2,-1.9478643833657161E-2,163.25613411647268,1.5713749476851113E-3,163.25613411647268]
[null,null,"VB04Z","Category 2 investigation with category 4 treatment","-","-",null,{"$f":"VLOOKUP(C64,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":138},2.1468190008266497E-2,-1.9478643833657161E-2,138.21684974278054,1.5713749476851113E-3,138.21684974278054]
[null,null,"VB05Z","Category 2 investigation with category 3 treatment","-","-",null,{"$f":"VLOOKUP(C65,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":129},2.1468190008266497E-2,-1.9478643833657161E-2,129.20270736825137,1.5713749476851113E-3,129.20270736825137]
[null,null,"VB06Z","Category 1 investigation with category 3-4 treatment","-","-",null,{"$f":"VLOOKUP(C66,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":101},2.1468190008266497E-2,-1.9478643833657161E-2,101.15870886971619,1.5713749476851113E-3,101.15870886971619]
[null,null,"VB07Z","Category 2 investigation with category 2 treatment","-","-",null,{"$f":"VLOOKUP(C67,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":118},2.1468190008266497E-2,-1.9478643833657161E-2,118.18542224382684,1.5713749476851113E-3,118.18542224382684]
[null,null,"VB08Z","Category 2 investigation with category 1 treatment","-","-",null,{"$f":"VLOOKUP(C68,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":109},2.1468190008266497E-2,-1.9478643833657161E-2,109.17127986929766,1.5713749476848893E-3,109.17127986929766]
[null,null,"VB09Z","Category 1 investigation with category 1-2 treatment","-","-",null,{"$f":"VLOOKUP(C69,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":77},2.1468190008266497E-2,-1.9478643833657161E-2,77.12099587097174,1.5713749476848893E-3,77.12099587097174]
[null,null,"VB10Z","Dental Care","-","-",null,{"$f":"VLOOKUP(C70,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":58},0,-1.9478643833657161E-2,56.870238657647882,-1.9478643833657161E-2,56.870238657647882]
[null,null,"VB11Z","No investigation with no significant treatment","-","-",null,{"$f":"VLOOKUP(C71,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":57},0,-1.9478643833657161E-2,55.889717301481539,-1.9478643833657161E-2,55.889717301481539]

{"sheet":"Link Sheet","index":11,"n_rows":14,"n_cols":16,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,3,1,4],[1,9,1,10],[1,14,1,15]]}
[null,"2015-16 tariff - accident & emergency",null,null,null,null,null,"2014-15 tariff - accident & emergency",null,null,null,null,null,"Difference between 2015/16 & 2013/14"]
[null,"Home",null,"Tariff (£)",null,null,null,null,null,"Tariff (£)",null,null,null,null,"Tariff (£)"]
[null,"HRG code","HRG name","Type 1 and 2 Departments","Type 3 Departments",null,null,"HRG code","HRG name","Type 1 and 2 Departments","Type 3 Departments",null,null,"HRG code","Type 1 and 2 Departments","Type 3 Departments"]
[null,"VB01Z","Emergency Medicine, Any Investigation with Category 5 Treatment",{"$f":"VLOOKUP(B4:B14,Prices!$C$21:$L$32,7,FALSE)","v":238.63891859602694},{"$f":"MIN($D$4:$D$14)","v":55.6776570878149},null,null,"VB01Z","Any investigation with category 5 treatment",{"$f":"VLOOKUP(H4,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":235},{"$f":"VLOOKUP(I4,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB01Z",{"$f":"(D4/J4)-1","v":1.5484759983093399E-2},{"$f":"(E4/K4)-1","v":-2.3198998459387665E-2}]
[null,"VB02Z","Emergency Medicine, Category 3 Investigation with Category 4 Treatment",{"$f":"VLOOKUP(B5:B15,Prices!$C$21:$L$32,7,FALSE)","v":225.53348936432519},{"$f":"MIN($D$4:$D$14)","v":55.6776570878149},null,null,"VB02Z","Category 3 investigation with category 4 treatment",{"$f":"VLOOKUP(H5,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":208},{"$f":"VLOOKUP(I5,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB02Z",{"$f":"(D5/J5)-1","v":8.429562194387108E-2},-2.3198998459387665E-2]
[null,"VB03Z","Emergency Medicine, Category 3 Investigation with Category 1-3 Treatment",{"$f":"VLOOKUP(B6:B16,Prices!$C$21:$L$32,7,FALSE)","v":191.56519723541047},55.6776570878149,null,null,"VB03Z","Category 3 investigation with category 1-3 treatment",{"$f":"VLOOKUP(H6,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":163},{"$f":"VLOOKUP(I6,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB03Z",{"$f":"(D6/J6)-1","v":0.17524660880619924},{"$f":"(E6/K6)-1","v":-2.3198998459387665E-2}]
[null,"VB04Z","Emergency Medicine, Category 2 Investigation with Category 4 Treatment",{"$f":"VLOOKUP(B7:B17,Prices!$C$21:$L$32,7,FALSE)","v":168.43992527763623},55.6776570878149,null,null,"VB04Z","Category 2 investigation with category 4 treatment",{"$f":"VLOOKUP(H7,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":138},{"$f":"VLOOKUP(I7,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB04Z",0.22057916867852345,-2.3198998459387665E-2]
[null,"VB05Z","Emergency Medicine, Category 2 Investigation with Category 3 Treatment",{"$f":"VLOOKUP(B8:B18,Prices!$C$21:$L$32,7,FALSE)","v":146.01128780586535},55.6776570878149,null,null,"VB05Z","Category 2 investigation with category 3 treatment",{"$f":"VLOOKUP(H8,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":129},{"$f":"VLOOKUP(I8,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB05Z",0.13187044810748327,-2.3198998459387665E-2]
[null,"VB06Z","Emergency Medicine, Category 1 Investigation with Category 3-4 Treatment",{"$f":"VLOOKUP(B9:B19,Prices!$C$21:$L$32,7,FALSE)","v":102.04545692217432},55.6776570878149,null,null,"VB06Z","Category 1 investigation with category 3-4 treatment",{"$f":"VLOOKUP(H9,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":101},{"$f":"VLOOKUP(I9,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB06Z",1.0351058635389432E-2,-2.3198998459387665E-2]
[null,"VB07Z","Emergency Medicine, Category 2 Investigation with Category 2 Treatment",{"$f":"VLOOKUP(B10:B20,Prices!$C$21:$L$32,7,FALSE)","v":127.76285406506283},55.6776570878149,null,null,"VB07Z","Category 2 investigation with category 2 treatment",{"$f":"VLOOKUP(H10,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":118},{"$f":"VLOOKUP(I10,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB07Z",8.2736051398837551E-2,-2.3198998459387665E-2]
[null,"VB08Z","Emergency Medicine, Category 2 Investigation with Category 1 Treatment",{"$f":"VLOOKUP(B11:B21,Prices!$C$21:$L$32,7,FALSE)","v":116.05498715997055},55.6776570878149,null,null,"VB08Z","Category 2 investigation with category 1 treatment",{"$f":"VLOOKUP(H11,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":109},{"$f":"VLOOKUP(I11,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB08Z",6.4724652843766606E-2,-2.3198998459387665E-2]
[null,"VB09Z","Emergency Medicine, Category 1 Investigation with Category 1-2 Treatment",{"$f":"VLOOKUP(B12:B22,Prices!$C$21:$L$32,7,FALSE)","v":81.081304380853908},55.6776570878149,null,null,"VB09Z","Category 1 investigation with category 1-2 treatment",{"$f":"VLOOKUP(H12,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":77},{"$f":"VLOOKUP(I12,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB09Z",5.3003952998102788E-2,-2.3198998459387665E-2]
[null,"VB10Z","Emergency Medicine, Dental Care",{"$f":"VLOOKUP(B13:B23,Prices!$C$21:$L$32,7,FALSE)","v":56.382241507222588},55.6776570878149,null,null,"VB10Z","Dental Care",{"$f":"VLOOKUP(H13,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":58},{"$f":"VLOOKUP(I13,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB10Z",-2.7892387806507157E-2,-2.3198998459387665E-2]
[null,"VB11Z","Emergency Medicine, No Investigation with No Significant Treatment",{"$f":"VLOOKUP(B14:B24,Prices!$C$21:$L$32,7,FALSE)","v":55.6776570878149},55.6776570878149,null,null,"VB11Z","No investigation with no significant treatment",{"$f":"VLOOKUP(H14,'2014-15 A&E Tariff'!$A$5:$D$15,3, FALSE)","v":57},{"$f":"VLOOKUP(I14,'2014-15 A&E Tariff'!$B$5:$E$15,3, FALSE)","v":57},null,null,"VB11Z",-2.3198998459387665E-2,-2.3198998459387665E-2]