{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Disclaimer","Navigation","TED A&E","A&E SQL Output","Price Adjustments","2013-14 A&E Tariff ","2014-15 A&E Tariff","Expert & Monitor Final Comments","A&E 15-16 Draft Model","Link Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Disclaimer","index":0,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"2015-16 A&E model.xlsx"]
[]
[null,"Produced by: Monitor"]

{"sheet":"Navigation","index":1,"n_rows":18,"n_cols":7,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Steps","Worksheet / Intermediary steps","Overview","Input tables","Data source","Date last updated"]
[null,"1>> TED Prices ","TED A&E","This worksheet has the TED prices for A&E "]
[null,"2 >> SQL inputs","A&E SQL Output","This worksheet has the total cost and activities.","[output].[OPATT_FinalTariff]","Monitor SQL","2014-06-18"]
[null,"3 >> Non SQL inputs","Price Adjustments","A variety of factors to adjust the prices. Includes: inflation, efficiency, CNST and quantum adjustment.",null,"Mixed (Monitor & External)","2014-06-18"]
[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,null,"2014-07-15"]
[null,"4 >> Processing","A&E 15-16 Draft Model ","Derived table. This is the mapping for percentage split of each TFCs based on HRGs"]
[null,"5>> Output","Link Sheet","Compares the 2015/16 final prices with that of 2014/15 and 2013/14",null,"PbR 13/14 * 14/15 prices (for % diff calcs)"]
[]
[]
[null,"Colour cordination"]
[null,null,"TED Prices "]
[null,null,"SQL figures"]
[null,null,"Non-SQL figures"]
[null,null,"Processing steps"]
[null,null,"Output"]

{"sheet":"TED A&E","index":2,"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('TED A&E'!A5,'Link Sheet'!B:E,3,FALSE)","v":233.06624283254314},{"$f":"VLOOKUP(A5,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB02Z","Category 3 investigation with category 4 treatment",{"$f":"VLOOKUP('TED A&E'!A6,'Link Sheet'!B:E,3,FALSE)","v":220.26685047143727},{"$f":"VLOOKUP(A6,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB03Z","Category 3 investigation with category 1-3 treatment",{"$f":"VLOOKUP('TED A&E'!A7,'Link Sheet'!B:E,3,FALSE)","v":187.0917830159643},{"$f":"VLOOKUP(A7,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB04Z","Category 2 investigation with category 4 treatment",{"$f":"VLOOKUP('TED A&E'!A8,'Link Sheet'!B:E,3,FALSE)","v":164.50653044530924},{"$f":"VLOOKUP(A8,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB05Z","Category 2 investigation with category 3 treatment",{"$f":"VLOOKUP('TED A&E'!A9,'Link Sheet'!B:E,3,FALSE)","v":142.60164461129392},{"$f":"VLOOKUP(A9,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB06Z","Category 1 investigation with category 3-4 treatment",{"$f":"VLOOKUP('TED A&E'!A10,'Link Sheet'!B:E,3,FALSE)","v":99.662500077123894},{"$f":"VLOOKUP(A10,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB07Z","Category 2 investigation with category 2 treatment",{"$f":"VLOOKUP('TED A&E'!A11,'Link Sheet'!B:E,3,FALSE)","v":124.77934674567544},{"$f":"VLOOKUP(A11,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB08Z","Category 2 investigation with category 1 treatment",{"$f":"VLOOKUP('TED A&E'!A12,'Link Sheet'!B:E,3,FALSE)","v":113.34488095439968},{"$f":"VLOOKUP(A12,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB09Z","Category 1 investigation with category 1-2 treatment",{"$f":"VLOOKUP('TED A&E'!A13,'Link Sheet'!B:E,3,FALSE)","v":79.187900645817223},{"$f":"VLOOKUP(A13,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB10Z","Dental Care",{"$f":"VLOOKUP('TED A&E'!A14,'Link Sheet'!B:E,3,FALSE)","v":56.24776713070495},{"$f":"VLOOKUP(A14,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
["VB11Z","No investigation with no significant treatment",{"$f":"VLOOKUP('TED A&E'!A15,'Link Sheet'!B:E,3,FALSE)","v":55.544863179259792},{"$f":"VLOOKUP(A15,'Link Sheet'!B:E,4,FALSE)","v":55.544863179259792}]
[]
["Please note that patients who are dead on arrival (DOA) attract the tariff for VB09Z."]

{"sheet":"A&E SQL Output","index":3,"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 "]
[]
[]
[]
[]
[]
[null,"HRG","SumOfTotal Activity","SumOfTotal Cost"]
[null,"VB01Z",28002,6929753.5088057071]
[null,"VB02Z",80774,18891658.776388176]
[null,"VB03Z",393335,78138787.405618444]
[null,"VB04Z",597172,104311439.80951495]
[null,"VB05Z",358112,54224152.002037257]
[null,"VB06Z",450490,47672320.59045478]
[null,"VB07Z",1536505,203575751.24986768]
[null,"VB08Z",4212098,506932036.78033352]
[null,"VB09Z",3638615,305945659.16141206]
[null,"VB10Z",2314,143090.62948237488]
[null,"VB11Z",5526681,337482184.6887722]

{"sheet":"Price Adjustments","index":4,"n_rows":131,"n_cols":17,"rows_kept":131,"cut":false,"hidden":false,"merged":[[59,1,60,2],[1,2,2,7],[1,11,2,16],[72,1,73,6],[12,1,13,6]]}
["Home"]
[null,null,"Table 1 :  Price Adjustments : Inflation and Efficiency  for all models ",null,null,null,null,null,null,null,null,"Table 2 :  Price Adjustments for quantum reconciliation (if BPT reconciled separately)  "]
[]
[null,null,"Adjustment Type","2012/13","2013/14","2014/15","2015/16","Total",null,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,0,{"$f":"(D5+1)*(E5+1)*(F5+1)*(G5+1)-1","v":7.5833849999999758E-2},null,null,null,"Inflation",2.1999999999999999E-2,2.7E-2,2.5000000000000001E-2,0,{"$f":"(M5+1)*(N5+1)*(O5+1)*(P5+1)-1","v":7.5833849999999758E-2}]
[null,null,"Efficiency*",-3.6999999999999998E-2,-0.04,-0.04,0,-0.11249920000000002,null,null,null,"Efficiency",-0.04,-0.04,-0.04,0,{"$f":"(M6+1)*(N6+1)*(O6+1)*(P6+1)-1","v":-0.11526400000000003}]
[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":0},{"$f":"(1+D7)*(1+E7)*(1+F7)*(1+G7)-1","v":-4.2387925000000104E-2},null,null,null,"Inflation and Efficiency (total adjustment)",{"$f":"SUM(M5:M6)","v":-1.8000000000000002E-2},{"$f":"SUM(N5:N6)","v":-1.3000000000000001E-2},-1.4999999999999999E-2,{"$f":"(1+P5)*(1+P6)-1","v":0},{"$f":"(M7+1)*(N7+1)*(O7+1)*(P7+1)-1","v":-4.5304510000000131E-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 reimbusement"]
[null,null,"We use a chain linking the post adjustments for joining the efficency and inflation adjustment together from 2015/16 onwards (this is a slight methodological change from the 13/14 DH method)."]
[]
[null,"Table 3:  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,0,{"$f":"(1+C16)*(1+D16)*(1+E16)*(1+F16)-1","v":1.1286523050006325E-2}]
[null,"AB",3.0000000000000001E-3,4.6639054280992465E-3,2.5168995621460688E-3,0,{"$f":"(1+C17)*(1+D17)*(1+E17)*(1+F17)-1","v":1.0214121202490434E-2}]
[null,"BZ",2.5999999999999999E-3,1.7135629937548025E-3,2.2965609688603283E-3,0,6.6244958185919245E-3]
[null,"CZ",1.1999999999999999E-3,7.9831600546853565E-4,8.2227697699654989E-4,0,2.8231949186401373E-3]
[null,"DZ",4.0000000000000002E-4,2.0988348940491619E-3,1.1281882920322062E-5,0,2.5109845119613006E-3]
[null,"EA",1.4E-3,6.8376141339254737E-4,8.7019419478395754E-4,0,2.9567269842478705E-3]
[null,"EB",6.9999999999999999E-4,9.0147384402938791E-4,7.2782220278599929E-4,0,2.3310931260058787E-3]
[null,"FZ",1.6000000000000001E-3,6.9434276756650259E-3,2.0934300240254E-3,0,1.0665875508903744E-2]
[null,"GA",1.6999999999999999E-3,8.3929962527324875E-3,3.2548782592356496E-3,0,1.339504052057916E-2]
[null,"GB",1.1000000000000001E-3,3.9857657915021161E-3,1.4670447677391785E-3,0,6.5646623797330772E-3]
[null,"GC",1.6000000000000001E-3,6.1396776298163758E-3,1.7811411022434775E-3,0,9.5444451712236589E-3]
[null,"HA",5.5999999999999999E-3,1.1458715826883292E-2,3.9247569065956611E-3,0,2.1114844701843438E-2]
[null,"HB",5.0000000000000001E-3,1.0604363193151389E-2,3.6557798734122571E-3,0,1.9370404835515886E-2]
[null,"HC",8.6999999999999994E-3,6.3163971875872527E-3,5.2421680236163226E-3,0,2.039252441495587E-2]
[null,"HD",1.4E-3,4.2221839108231851E-3,1.2461541146224775E-4,0,5.7534117271307306E-3]
[null,"HR",4.4999999999999997E-3,6.112531021233325E-3,2.0507319365403731E-3,0,1.2712589211893555E-2]
[null,"JA",1.1999999999999999E-3,6.4304063507034659E-3,1.2794280689145676E-3,0,8.92732333599211E-3]
[null,"JC",1.9E-3,3.6510830811316008E-3,1.7803936364513273E-3,0,7.3483092391237737E-3]
[null,"JD",8.9999999999999998E-4,2.6729961073768127E-3,1.0486026327254372E-3,0,4.6277536123433549E-3]
[null,"KA",1.4E-3,3.8450441685828896E-3,9.4410677570055945E-4,0,6.1994909700431311E-3]
[null,"KB",2.9999999999999997E-4,3.5166956544530059E-4,6.6025179707085435E-4,0,1.3124571990446032E-3]
[null,"KC",4.0000000000000002E-4,1.0156478917267009E-3,1.2352320038200304E-4,0,1.5397522668061381E-3]
[null,"LA",8.0000000000000004E-4,8.7420520085790265E-4,5.1491581673213105E-4,0,2.1906828166025072E-3]
[null,"LB",1E-3,4.58633918397644E-3,1.1234991714843545E-3,0,6.7207060948377695E-3]
[null,"LD",0,0,0,0,0]
[null,"MA",0,5.1603725608684536E-2,4.0632237452609132E-3,0,5.5876626837182641E-2]
[null,"MB",2.9999999999999997E-4,4.6619290226565857E-2,1.5009122892200022E-3,0,4.8504631033596146E-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,0,8.7525362540996632E-3]
[null,"PB",0,0,0,0,0]
[null,"QZ",2.0999999999999999E-3,1.7265642874806364E-3,3.1319345733256121E-3,0,6.9741205505204906E-3]
[null,"RA",0,0,0,0,0]
[null,"RC",0,0,0,0,0]
[null,"SA",4.0000000000000002E-4,6.3410046328193914E-4,-5.5466412123872377E-4,0,4.7911626311858413E-4]
[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,0,2.1681502525233931E-2]
[null,"WA",1.1999999999999999E-3,1.3776568699075398E-4,1.0210188461163838E-3,0,{"$f":"(1+C54)*(1+D54)*(1+E54)*(1+F54)-1","v":2.360315904703425E-3}]
[null,"VB",1.61E-2,1.1539171571975482E-2,7.33525858395212E-3,0,{"$f":"(1+C55)*(1+D55)*(1+E55)*(1+F55)-1","v":3.5364314037961142E-2}]
[null,"Maternity*",null,null,2.8299999999999999E-2]
[null,"* Note: Maternity is delivery element only."]
[]
[]
[null," Table 4: Quantum Reconciliation (QR)"]
[]
[null,"Components ","Value "]
[null,"Admitted patient care",-6.1683993539870308E-2]
[null,"Outpatient procedures",6.3876199701790481E-2]
[null,"Outpatient attendances",-2.1474056912737183E-2]
[null,"A&E",2.3239625777739199E-2]
[null,"Unbundled services",1.5685391533066362E-2]
[null,"Best Practice Tariffs",-6.1683993539870308E-2]
[null,"Maternity pathway",0]
[null,"Other mandatory prices",0]
[null,"Non-mandatory Prices",0]
[]
[null,"Table 5:  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,-2.5752745552273471E-2,null,null,-2.5752745552273471E-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,-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,-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,-5.0999999999999934E-3]
[]
[null,"Maternity Pathway"]
[null,"Factor 1 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,-5.0999999999999934E-3,null,null,-5.0999999999999934E-3]
[]
[null,"Non-mandatory"]
[null,"Factor 1 (Road test adjustment)",null,-5.1000000000000004E-3]
[null,"Total",null,-5.0999999999999934E-3,null,null,-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,-5.0999999999999934E-3]

{"sheet":"2013-14 A&E Tariff ","index":5,"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":6,"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":"Expert & Monitor Final Comments","index":7,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Home"]
["HRG","HRG name","Rationale and evidence for price changed required. \nPlease also explain the rationale for any alternative prices suggested.","Monitor/NHSE assessment"]
["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 disporportionate effect on large EDs as care of more complex cases is centralised","no action"]
["VB02Z","Emergency Medicine, Category 3 Investigation with Category 4 Treatment"]
["VB03Z","Emergency Medicine, Category 3 Investigation with Category 1-3 Treatment"]
["VB04Z","Emergency Medicine, Category 2 Investigation with Category 4 Treatment"]
["VB05Z","Emergency Medicine, Category 2 Investigation with Category 3 Treatment"]
["VB06Z","Emergency Medicine, Category 1 Investigation with Category 3-4 Treatment"]
["VB07Z","Emergency Medicine, Category 2 Investigation with Category 2 Treatment"]
["VB08Z","Emergency Medicine, Category 2 Investigation with Category 1 Treatment"]
["VB09Z","Emergency Medicine, Category 1 Investigation with Category 1-2 Treatment"]
["VB10Z","Emergency Medicine, Dental Care"]
["VB11Z","Emergency Medicine, No Investigation with No Significant Treatment"]

{"sheet":"A&E 15-16 Draft Model","index":8,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":false,"merged":[[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],[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]]}
[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",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":0},{"$f":"'Price Adjustments'!G55","v":3.5364314037961142E-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":0},{"$f":"'Price Adjustments'!H5","v":7.5833849999999758E-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":0},{"$f":"'Price Adjustments'!H6","v":-0.11249920000000002}]
[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":0},{"$f":"(1+E13)*(1+F13)*(1+G13)*(1+H13)-1","v":-0.11104434476500002}]
[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","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,15,FALSE),\"Error\"))","v":227.7728861950545},null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},{"$f":"F22*(1+H22)","v":233.06624283254314},{"$f":"ROUND(I22,0)","v":233},{"$f":"J22","v":233},{"$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":-8.5836909871244635E-3},{"$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":-1.7167381974248927E-2},{"$f":"(L22-U22)/L22","v":-3.5714285714285712E-2}]
[null,null,"VB02Z","Category 3 investigation with category 4 treatment","Modelled",{"$f":"IF(E23=\"Modelled\",VLOOKUP(C23,$C$41:$M$51,11,FALSE),IF(E23=\"Rollover\",VLOOKUP(C23,$C$61:$M$71,10,FALSE),\"Error\"))","v":215.26419122404283},null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},220.26685047143727,220,{"$f":"J23","v":220},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":5.4545454545454543E-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":4.5454545454545456E-2},{"$f":"(L23-U23)/L23","v":-3.5714285714285712E-2}]
[null,null,"VB03Z","Category 3 investigation with category 1-3 treatment","Modelled",182.84258965612327,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},187.0917830159643,187,187,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.12834224598930483,-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.12299465240641712},{"$f":"(L24-U24)/L24","v":-3.5714285714285712E-2}]
[null,null,"VB04Z","Category 2 investigation with category 4 treatment","Modelled",160.77028909066328,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},164.50653044530924,165,165,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.16363636363636364,-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.15757575757575756,-3.5714285714285712E-2]
[null,null,"VB05Z","Category 2 investigation with category 3 treatment","Modelled",139.36290290058491,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},142.60164461129392,143,143,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,9.7902097902097904E-2,-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,9.0909090909090912E-2,-3.5714285714285712E-2]
[null,null,"VB06Z","Category 1 investigation with category 3-4 treatment","Modelled",97.398984134701479,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},99.662500077123894,100,100,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,-0.01,-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.02,-3.5714285714285712E-2]
[null,null,"VB07Z","Category 2 investigation with category 2 treatment","Modelled",121.94538170942485,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},124.77934674567544,125,125,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,5.6000000000000001E-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,4.8000000000000001E-2,-3.5714285714285712E-2]
[null,null,"VB08Z","Category 2 investigation with category 1 treatment","Modelled",110.77061335290747,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},113.34488095439968,113,113,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,3.5398230088495575E-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,2.6548672566371681E-2,-3.5714285714285712E-2]
[null,null,"VB09Z","Category 1 investigation with category 1-2 treatment","Modelled",77.389399951774209,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},79.187900645817223,79,79,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,2.5316455696202531E-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,1.2658227848101266E-2,-3.5714285714285712E-2]
[null,null,"VB10Z","Dental Care","Modelled",54.970278431068785,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},56.24776713070495,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","No investigation with no significant treatment","Modelled",54.283338701862249,null,{"$f":"'Price Adjustments'!$C$66","v":2.3239625777739199E-2},55.544863179259792,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.5088057071},null,{"$f":"F41/E41","v":247.47352006305647},{"$f":"$I$10","v":3.5364314037961142E-2},{"$f":"$I$13","v":-0.11104434476500002},{"$f":"H41*(I41+1)*(J41+1)","v":227.7728861950545},{"$f":"(K41/H41)-1","v":-7.9607037807447933E-2},{"$f":"K41","v":227.7728861950545}]
[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.776388176},null,233.88291747825014,{"$f":"$I$10","v":3.5364314037961142E-2},{"$f":"$I$13","v":-0.11104434476500002},215.26419122404283,{"$f":"(K42/H42)-1","v":-7.9607037807448044E-2},215.26419122404283]
[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.405618444},null,198.65709231474048,3.5364314037961142E-2,-0.11104434476500002,182.84258965612327,-7.9607037807447933E-2,182.84258965612327]
[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.80951495},null,174.67570450308278,3.5364314037961142E-2,-0.11104434476500002,160.77028909066328,-7.9607037807447822E-2,160.77028909066328]
[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.002037257},null,151.41674113695507,3.5364314037961142E-2,-0.11104434476500002,139.36290290058491,-7.9607037807448044E-2,139.36290290058491]
[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.59045478},null,105.82326042854399,3.5364314037961142E-2,-0.11104434476500002,97.398984134701479,-7.9607037807447933E-2,97.398984134701479]
[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.24986768},null,132.49273594935758,3.5364314037961142E-2,-0.11104434476500002,121.94538170942485,-7.9607037807447933E-2,121.94538170942485]
[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.78033352},null,120.35143455359622,3.5364314037961142E-2,-0.11104434476500002,110.77061335290747,-7.9607037807448044E-2,110.77061335290747]
[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.16141206},null,84.082998383014427,3.5364314037961142E-2,-0.11104434476500002,77.389399951774209,-7.9607037807448044E-2,77.389399951774209]
[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.62948237488},null,61.836918531709109,0,-0.11104434476500002,54.970278431068785,-0.11104434476500002,54.970278431068785]
[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.6887722},null,61.064169379193807,0,-0.11104434476500002,54.283338701862249,-0.11104434476500002,54.283338701862249]
[]
[]
[]
[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":0},{"$f":"$H$13","v":0},{"$f":"H61*(I61+1)*(J61+1)","v":235},{"$f":"(K61/H61)-1","v":0},{"$f":"K61","v":235}]
[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":0},{"$f":"$H$13","v":0},208,0,208]
[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},0,0,163,0,163]
[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},0,0,138,0,138]
[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},0,0,129,0,129]
[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},0,0,101,0,101]
[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},0,0,118,0,118]
[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},0,0,109,0,109]
[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},0,0,77,0,77]
[null,null,"VB10Z","Dental Care","-","-",null,{"$f":"VLOOKUP(C70,'2014-15 A&E Tariff'!$A$5:$C$15,3,FALSE)","v":58},0,0,58,0,58]
[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,0,57,0,57]

{"sheet":"Link Sheet","index":9,"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","Any investigation with category 5 treatment",{"$f":"VLOOKUP(B4:B14,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":233.06624283254314},{"$f":"MIN($D$4:$D$14)","v":55.544863179259792},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":-8.2287539040717395E-3},{"$f":"(E4/K4)-1","v":-2.5528716153336961E-2}]
[null,"VB02Z","Category 3 investigation with category 4 treatment",{"$f":"VLOOKUP(B5:B15,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":220.26685047143727},{"$f":"MIN($D$4:$D$14)","v":55.544863179259792},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":5.8975242651140736E-2},-2.5528716153336961E-2]
[null,"VB03Z","Category 3 investigation with category 1-3 treatment",{"$f":"VLOOKUP(B6:B16,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":187.0917830159643},55.544863179259792,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.147802349791192},{"$f":"(E6/K6)-1","v":-2.5528716153336961E-2}]
[null,"VB04Z","Category 2 investigation with category 4 treatment",{"$f":"VLOOKUP(B7:B17,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":164.50653044530924},55.544863179259792,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.19207630757470473,-2.5528716153336961E-2]
[null,"VB05Z","Category 2 investigation with category 3 treatment",{"$f":"VLOOKUP(B8:B18,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":142.60164461129392},55.544863179259792,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.10543910551390634,-2.5528716153336961E-2]
[null,"VB06Z","Category 1 investigation with category 3-4 treatment",{"$f":"VLOOKUP(B9:B19,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":99.662500077123894},55.544863179259792,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.3242573493822851E-2,-2.5528716153336961E-2]
[null,"VB07Z","Category 2 investigation with category 2 treatment",{"$f":"VLOOKUP(B10:B20,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":124.77934674567544},55.544863179259792,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",5.7452091065046007E-2,-2.5528716153336961E-2]
[null,"VB08Z","Category 2 investigation with category 1 treatment",{"$f":"VLOOKUP(B11:B21,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":113.34488095439968},55.544863179259792,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",3.9861293159630051E-2,-2.5528716153336961E-2]
[null,"VB09Z","Category 1 investigation with category 1-2 treatment",{"$f":"VLOOKUP(B12:B22,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":79.187900645817223},55.544863179259792,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",2.8414294101522408E-2,-2.5528716153336961E-2]
[null,"VB10Z","Dental Care",{"$f":"VLOOKUP(B13:B23,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":56.24776713070495},55.544863179259792,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",-3.0210911539569785E-2,-2.5528716153336961E-2]
[null,"VB11Z","No investigation with no significant treatment",{"$f":"VLOOKUP(B14:B24,'A&E 15-16 Draft Model'!$C$21:$L$32,7,FALSE)","v":55.544863179259792},55.544863179259792,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.5528716153336961E-2,-2.5528716153336961E-2]