{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["INFLATION","TEST - INBASE","TEST - UNBASE","Data","Stats","Revenue","Expenses","Deductions","Productivity","Report Data","Final Report","CashFlow","Lookup","New","Old","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":57,"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":"INFLATION","index":0,"n_rows":47,"n_cols":10,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[null,"I","I","I","I",null,"CI","CI","CI","CI"]
[null,"INBASE","INBASE","INBASE","INBASE",null,"INBASE","INBASE","INBASE","INBASE"]
[null,"999","999","999","999",null,"999","999","999","999"]
[null,"2013","2014","2015","2016",null,"2013","2014","2015","2016"]
["ICU",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["NIC",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["ONS",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["PED",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["WNO",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["AOIP",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["CVS",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["EDR",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["IMG",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["SUR",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["AOOP",0.06,0.06,0.06,0.06,null,1.06,1.1236000000000002,1.1910160000000003,1.2624769600000003]
["SVREV",0.03,0.03,0.03,0.03,null,1.03,1.0609,1.092727,1.1255088100000001]
["LTREV",0.03,0.03,0.03,0.03,null,1.03,1.0609,1.092727,1.1255088100000001]
["OOR",1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,null,1.0149999999999999,1.0302249999999997,1.0456783749999996,1.0613635506249994]
[]
["MCARE","0","0","0","0",null,1,1,1,1]
["MCAID","0","0","0","0",null,1,1,1,1]
[]
["SELECTH","0","0","0","0",null,1,1,1,1]
["CONT","0","0","0","0",null,1,1,1,1]
["NCONT","0","0","0","0",null,1,1,1,1]
["UNINS","0","0","0","0",null,1,1,1,1]
["CHAR","0","0","0","0",null,1,1,1,1]
["BDEBT","0","0","0","0",null,1,1,1,1]
["ODED","0","0","0","0",null,1,1,1,1]
[]
["TSAL",0.03,0.03,0.03,0.03,null,1.03,1.0609,1.092727,1.1255088100000001]
["PHY",0.02,0.02,0.02,0.02,null,1.02,1.0404,1.0612079999999999,1.08243216]
["RET","0","0","0","0",null,1,1,1,1]
["OBEN",7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,7.0000000000000007E-2,null,1.07,1.1449,1.2250430000000001,1.3107960100000002]
["TFEE",6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3,6.0000000000000001E-3,null,1.006,1.0120359999999999,1.0181082159999999,1.024216865296]
["MSUP",4.4700000000000004E-2,4.4700000000000004E-2,4.4700000000000004E-2,4.4700000000000004E-2,null,1.0447,1.09139809,1.140183584623,1.1911497908556481]
["NMSUP",3.6799999999999999E-2,3.6799999999999999E-2,3.6799999999999999E-2,3.6799999999999999E-2,null,1.0367999999999999,1.0749542399999998,1.1145125560319997,1.1555266180939772]
["TOPS",3.1199999999999999E-2,3.1199999999999999E-2,3.1199999999999999E-2,3.1199999999999999E-2,null,1.0311999999999999,1.0633734399999999,1.0965506913279999,1.1307630728974334]
["OEXP",3.7100000000000001E-2,3.7100000000000001E-2,3.7100000000000001E-2,3.7100000000000001E-2,null,1.0370999999999999,1.0755764099999998,1.1154802948109996,1.1568646137484877]
["MEXP",4.8000000000000001E-2,4.8000000000000001E-2,4.8000000000000001E-2,4.8000000000000001E-2,null,1.048,1.0983040000000002,1.1510225920000001,1.2062716764160002]
["TINS",2.3061670782178467E-3,2.2875105345405711E-3,2.2875105345405711E-3,2.2875105345405711E-3,null,1.0023061670782178,1.0045989529942443,1.006896983682207,1.0092002711395771]
["TCENT",2.9389999999999999E-2,2.929E-2,2.929E-2,2.929E-2,null,1.02939,1.0595408331,1.090574784101499,1.122517719527832]
["TOTE"]
["4472","0","0","0","0",null,1,1,1,1]
["4471",2.9382273594757535E-2,2.8785218419539182E-2,2.8785218419539182E-2,2.8785218419539182E-2,null,1.0293822735947575,1.0590132671773844,1.0894971953822752,1.1208586101188294]
["4474","0","0","0","0",null,1,1,1,1]
["4475",2.7153652009997975E-2,2.5318241897167582E-2,2.5318241897167582E-2,2.5318241897167582E-2,null,1.027153652009998,1.0531593766371461,1.0798235204911155,1.1071627535891606]

{"sheet":"TEST - INBASE","index":1,"n_rows":56,"n_cols":18,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
[null,null,"2013","2014","2015","2016"]
[null,null,"INBASE","INBASE","INBASE","INBASE"]
[null,null,"999","999","999","999"]
["9001","V",70692,72465,72465,73400,null,"9001","V",{"$f":"SUM(Stats!E5:E9)","v":0},{"$f":"SUM(Stats!F5:F9)","v":0},{"$f":"SUM(Stats!G5:G9)","v":0},{"$f":"SUM(Stats!H5:H9)","v":0},null,{"$f":"C4-J4","v":70692},{"$f":"D4-K4","v":72465},72465,73400]
["9011","V",18532,19416,19416,19600,null,"9011","V",{"$f":"SUM(Stats!E11:E15)","v":0},{"$f":"SUM(Stats!F11:F15)","v":0},{"$f":"SUM(Stats!G11:G15)","v":0},{"$f":"SUM(Stats!H11:H15)","v":0},null,{"$f":"C5-J5","v":18532},19416,19416,19600]
[]
["ICU","V",21299551.962531216,23028372.96181364,24410075.339522462,26315463.879881829,null,"ICU","V",{"$f":"Stats!E5*Revenue!D5*INFLATION!G5","v":0},{"$f":"Stats!F5*Revenue!E5*INFLATION!H5","v":0},{"$f":"Stats!G5*Revenue!F5*INFLATION!I5","v":0},{"$f":"Stats!H5*Revenue!G5*INFLATION!J5","v":0},null,21299551.962531216,23028372.96181364,24410075.339522462,26315463.879881829]
["NIC","V",25413655.986408509,27477310.165816423,29125948.775765412,31189065.660761394,null,"NIC","V",{"$f":"Stats!E6*Revenue!D6*INFLATION!G6","v":0},{"$f":"Stats!F6*Revenue!E6*INFLATION!H6","v":0},{"$f":"Stats!G6*Revenue!F6*INFLATION!I6","v":0},{"$f":"Stats!H6*Revenue!G6*INFLATION!J6","v":0},null,25413655.986408509,27477310.165816423,29125948.775765412,31189065.660761394]
["ONS","V",113356542.95479238,122559340.26289666,129912900.67867047,139113298.67475015,null,"ONS","V",{"$f":"Stats!E7*Revenue!D7*INFLATION!G7","v":0},{"$f":"Stats!F7*Revenue!E7*INFLATION!H7","v":0},{"$f":"Stats!G7*Revenue!F7*INFLATION!I7","v":0},{"$f":"Stats!H7*Revenue!G7*INFLATION!J7","v":0},null,113356542.95479238,122559340.26289666,129912900.67867047,139113298.67475015]
["PED","V",4797494.6317248754,5337995.731135034,5658275.4750031373,6271748.3801080454,null,"PED","V",{"$f":"Stats!E8*Revenue!D8*INFLATION!G8","v":0},{"$f":"Stats!F8*Revenue!E8*INFLATION!H8","v":0},{"$f":"Stats!G8*Revenue!F8*INFLATION!I8","v":0},{"$f":"Stats!H8*Revenue!G8*INFLATION!J8","v":0},null,4797494.6317248754,5337995.731135034,5658275.4750031373,6271748.3801080454]
["WNO","V",34697670.239515632,38619939.201287046,40937135.553364277,44254311.195274197,null,"WNO","V",{"$f":"Stats!E9*Revenue!D9*INFLATION!G9","v":0},{"$f":"Stats!F9*Revenue!E9*INFLATION!H9","v":0},{"$f":"Stats!G9*Revenue!F9*INFLATION!I9","v":0},{"$f":"Stats!H9*Revenue!G9*INFLATION!J9","v":0},null,34697670.239515632,38619939.201287046,40937135.553364277,44254311.195274197]
["AOIP","V",231430936.06196818,247769960.14794317,265262519.33438796,283990053.19939578,null,"AOIP","V",{"$f":"'TEST - UNBASE'!J12*INFLATION!G10","v":0},{"$f":"'TEST - UNBASE'!K12*INFLATION!H10","v":0},{"$f":"'TEST - UNBASE'!L12*INFLATION!I10","v":0},{"$f":"'TEST - UNBASE'!M12*INFLATION!J10","v":0},null,{"$f":"C12-J12","v":231430936.06196818},247769960.14794317,265262519.33438796,283990053.19939578]
[]
["CVS","V",32373275.569715787,35002043.774750486,37102166.401235521,40073333.254594043,null,"CVS","V",{"$f":"Stats!E20*Revenue!D13*INFLATION!G11","v":0},{"$f":"Stats!F20*Revenue!E13*INFLATION!H11","v":0},{"$f":"Stats!G20*Revenue!F13*INFLATION!I11","v":0},{"$f":"Stats!H20*Revenue!G13*INFLATION!J11","v":0},null,32373275.569715787,35002043.774750486,37102166.401235521,40073333.254594043]
["IMG","V",107700235.02316795,116445667.33187871,123432407.37179145,131821260.67726973,null,"IMG","V",{"$f":"Stats!E21*Revenue!D14*INFLATION!G12","v":0},{"$f":"Stats!F21*Revenue!E14*INFLATION!H12","v":0},{"$f":"Stats!G21*Revenue!F14*INFLATION!I12","v":0},{"$f":"Stats!H21*Revenue!G14*INFLATION!J12","v":0},null,107700235.02316795,116445667.33187871,123432407.37179145,131821260.67726973]
["SUR","V",43832112.632423669,48783585.363926716,51710600.48576232,55246819.146181889,null,"SUR","V",{"$f":"Stats!E22*Revenue!D15*INFLATION!G13","v":0},{"$f":"Stats!F22*Revenue!E15*INFLATION!H13","v":0},{"$f":"Stats!G22*Revenue!F15*INFLATION!I13","v":0},{"$f":"Stats!H22*Revenue!G15*INFLATION!J13","v":0},null,43832112.632423669,48783585.363926716,51710600.48576232,55246819.146181889]
["EDR","V",83312778.715106845,92727201.08505854,98290833.150162056,105674774.97380327,null,"EDR","V",{"$f":"Stats!E23*Revenue!D16*INFLATION!G14","v":0},{"$f":"Stats!F23*Revenue!E16*INFLATION!H14","v":0},{"$f":"Stats!G23*Revenue!F16*INFLATION!I14","v":0},{"$f":"Stats!H23*Revenue!G16*INFLATION!J14","v":0},null,83312778.715106845,92727201.08505854,98290833.150162056,105674774.97380327]
["AOOP","V",117696811.40071917,127253792.48645757,137586800.43635795,148758848.63179019,null,"AOOP","V",{"$f":"Revenue!C17*(1+Revenue!D18)*INFLATION!G15","v":0},{"$f":"Revenue!D17*(1+Revenue!E18)*INFLATION!H15","v":0},{"$f":"Revenue!E17*(1+Revenue!F18)*INFLATION!I15","v":0},{"$f":"Revenue!F17*(1+Revenue!G18)*INFLATION!J15","v":0},null,117696811.40071917,127253792.48645757,137586800.43635795,148758848.63179019]
[]
["SVREV","V",0,0,0,0,null,"SVREV","V",{"$f":"(SUM(Stats!E5:E9)*Revenue!D20)+Revenue!D21","v":0},{"$f":"(SUM(Stats!F5:F9)*Revenue!E20)+Revenue!E21","v":0},{"$f":"(SUM(Stats!G5:G9)*Revenue!F20)+Revenue!F21","v":0},{"$f":"(SUM(Stats!H5:H9)*Revenue!G20)+Revenue!G21","v":0},null,0,0,0,0]
["LTREV","V",0,0,0,0,null,"LTREV","V",{"$f":"(SUM(Stats!E5:E9)*Revenue!D23)+Revenue!D21","v":0},{"$f":"(SUM(Stats!F5:F9)*Revenue!E23)+Revenue!E21","v":0},{"$f":"(SUM(Stats!G5:G9)*Revenue!F23)+Revenue!F21","v":0},{"$f":"(SUM(Stats!H5:H9)*Revenue!G23)+Revenue!G21","v":0},null,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["OOR","V",14939464.934849862,15440544.206707273,15742269.06175977,16138222.584509773,null,"OOR","V",{"$f":"(Revenue!D27*INFLATION!G18)+(SUM('TEST - UNBASE'!J7:J21)*Revenue!D26*INFLATION!G18)","v":0},{"$f":"(Revenue!E27*INFLATION!H18)+(SUM('TEST - UNBASE'!K7:K21)*Revenue!E26*INFLATION!H18)","v":0},{"$f":"(Revenue!F27*INFLATION!I18)+(SUM('TEST - UNBASE'!L7:L21)*Revenue!F26*INFLATION!I18)","v":0},{"$f":"(Revenue!G27*INFLATION!J18)+(SUM('TEST - UNBASE'!M7:M21)*Revenue!G26*INFLATION!J18)","v":0},null,14939464.934849862,15440544.206707273,15742269.06175977,16138222.584509773]
[]
["MCARE","MR",295593498.09388053,320625367.86231244,349068975.31074852,374702321.73930991,null,"MCARE","MR",{"$f":"SUM(J$7:J$21)*Deductions!D5","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E5","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F5","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G5","v":0},null,{"$f":"C25-J25","v":295593498.09388053},320625367.86231244,349068975.31074852,374702321.73930991]
["MCAID","MR",97995315.622927755,106293894.56464194,103777262.93022253,111397987.54411916,null,"MCAID","MR",{"$f":"SUM(J$7:J$21)*Deductions!D6","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E6","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F6","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G6","v":0},null,97995315.622927755,106293894.56464194,103777262.93022253,111397987.54411916]
["SELECTH","MR",131358233.70963602,142482098.81639332,149061886.75431964,160008018.47246209,null,"SELECTH","MR",{"$f":"SUM(J$7:J$21)*Deductions!D7","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E7","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F7","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G7","v":0},null,131358233.70963602,142482098.81639332,149061886.75431964,160008018.47246209]
["CONT","MR",207483055.19060129,225053430.89297202,247178571.70653003,265329752.15053838,null,"CONT","MR",{"$f":"SUM(J$7:J$21)*Deductions!D8","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E8","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F8","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G8","v":0},null,207483055.19060129,225053430.89297202,247178571.70653003,265329752.15053838]
["NCONT","MR",21309506.165314648,23114068.128278866,22642311.912048552,24305015.464171454,null,"NCONT","MR",{"$f":"SUM(J$7:J$21)*Deductions!D9","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E9","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F9","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G9","v":0},null,21309506.165314648,23114068.128278866,22642311.912048552,24305015.464171454]
["UNINS","MR",62171456.395714127,67436348.248365715,71888222.453450993,77167224.142565161,null,"UNINS","MR",{"$f":"SUM(J$7:J$21)*Deductions!D10","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E10","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F10","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G10","v":0},null,62171456.395714127,67436348.248365715,71888222.453450993,77167224.142565161]
[]
["MCARE","F","0","0","0","0"]
["MCAID","F","0","0","0","0",null,null,null,null,null,null,null,null,0,0,0,0]
["MCARE","V",201160013.41362268,223992881.4668659,249818942.40973428,274194484.663405,null,"MCARE","V",{"$f":"C32+J25-('TEST - UNBASE'!J25*Deductions!D15)","v":0},{"$f":"D32+K25-('TEST - UNBASE'!K25*Deductions!E15)","v":0},{"$f":"E32+L25-('TEST - UNBASE'!L25*Deductions!F15)","v":0},{"$f":"F32+M25-('TEST - UNBASE'!M25*Deductions!G15)","v":0},null,201160013.41362268,223992881.4668659,249818942.40973428,274194484.663405]
["MCAID","V",54011681.406544924,61286046.454114035,62322324.310752288,69417686.933913767,null,"MCAID","V",{"$f":"C33+J26-('TEST - UNBASE'!J26*Deductions!D16)","v":0},{"$f":"D33+K26-('TEST - UNBASE'!K26*Deductions!E16)","v":0},{"$f":"E33+L26-('TEST - UNBASE'!L26*Deductions!F16)","v":0},{"$f":"F33+M26-('TEST - UNBASE'!M26*Deductions!G16)","v":0},null,54011681.406544924,61286046.454114035,62322324.310752288,69417686.933913767]
["SELECTH","V",49328831.622491792,53506166.025872171,55977067.484696075,60087657.838974386,null,"SELECTH","V",{"$f":"J27-(J27*Deductions!D17)","v":0},{"$f":"K27-(K27*Deductions!E17)","v":0},{"$f":"L27-(L27*Deductions!F17)","v":0},{"$f":"M27-(M27*Deductions!G17)","v":0},null,49328831.622491792,53506166.025872171,55977067.484696075,60087657.838974386]
["CONT","V",54300543.327738076,58898899.305457652,64689286.218139529,69439645.032954782,null,"CONT","V",{"$f":"J28-(J28*Deductions!D18)","v":0},{"$f":"K28-(K28*Deductions!E18)","v":0},{"$f":"L28-(L28*Deductions!F18)","v":0},{"$f":"M28-(M28*Deductions!G18)","v":0},null,54300543.327738076,58898899.305457652,64689286.218139529,69439645.032954782]
["NCONT","V",3614373.9577078596,3920451.522969529,3840435.4320708588,4122451.9354829937,null,"NCONT","V",{"$f":"J29-(J29*Deductions!D19)","v":0},{"$f":"K29-(K29*Deductions!E19)","v":0},{"$f":"L29-(L29*Deductions!F19)","v":0},{"$f":"M29-(M29*Deductions!G19)","v":0},null,3614373.9577078596,3920451.522969529,3840435.4320708588,4122451.9354829937]
["UNINS","V",0,0,0,0,null,"UNINS","V",{"$f":"J30-(J30*Deductions!D20)","v":0},{"$f":"K30-(K30*Deductions!E20)","v":0},{"$f":"L30-(L30*Deductions!F20)","v":0},{"$f":"M30-(M30*Deductions!G20)","v":0},null,0,0,0,0]
[]
["CHAR","V",43236524.300566435,46897941.254966706,49993953.129388601,53665182.629970975,null,"CHAR","V",{"$f":"Expenses!D8+(Expenses!D5*SUM(J$7:J$22))","v":0},{"$f":"Expenses!E8+(Expenses!E5*SUM(K$7:K$22))","v":0},{"$f":"Expenses!F8+(Expenses!F5*SUM(L$7:L$22))","v":0},{"$f":"Expenses!G8+(Expenses!G5*SUM(M$7:M$22))","v":0},null,43236524.300566435,46897941.254966706,49993953.129388601,53665182.629970975]
["BDEBT","V",33441229.36836056,36273147.200934805,38667753.2636232,41507260.596345097,null,"BDEBT","V",{"$f":"Expenses!D9+(Expenses!D6*SUM(J$7:J$22))","v":0},{"$f":"Expenses!E9+(Expenses!E6*SUM(K$7:K$22))","v":0},{"$f":"Expenses!F9+(Expenses!F6*SUM(L$7:L$22))","v":0},{"$f":"Expenses!G9+(Expenses!G6*SUM(M$7:M$22))","v":0},null,33441229.36836056,36273147.200934805,38667753.2636232,41507260.596345097]
["ODED","V",21371305.51278038,23181100.856138654,24711423.117463425,26526068.687006816,null,"ODED","V",{"$f":"Expenses!D10+(Expenses!D7*SUM(J$7:J$22))","v":0},{"$f":"Expenses!E10+(Expenses!E7*SUM(K$7:K$22))","v":0},{"$f":"Expenses!F10+(Expenses!F7*SUM(L$7:L$22))","v":0},{"$f":"Expenses!G10+(Expenses!G7*SUM(M$7:M$22))","v":0},null,21371305.51278038,23181100.856138654,24711423.117463425,26526068.687006816]
[]
["TSAL","V",111313958.24089611,114735955.61759838,117090601.00663453,118887010.79478717,null,"TSAL","V",{"$f":"Expenses!D13+(Expenses!D12*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E13+(Expenses!E12*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F13+(Expenses!F12*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G13+(Expenses!G12*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,111313958.24089611,114735955.61759838,117090601.00663453,118887010.79478717]
["PHY","V",8274356.0102458578,8321742.1140658753,8333560.1831421554,8360099.4423018303,null,"PHY","V",{"$f":"Expenses!D16+(Expenses!D15*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E16+(Expenses!E15*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F16+(Expenses!F15*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G16+(Expenses!G15*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,8274356.0102458578,8321742.1140658753,8333560.1831421554,8360099.4423018303]
["OBEN","V",29065453.192657728,29170942.280859318,29197251.203320961,29256331.862514492,null,"OBEN","V",{"$f":"Expenses!D19+(Expenses!D18*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E19+(Expenses!E18*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F19+(Expenses!F18*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G19+(Expenses!G18*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,29065453.192657728,29170942.280859318,29197251.203320961,29256331.862514492]
["TFEE","V",15159726.475923482,16395351.524627967,15454116.286387412,18586081.434985206,null,"TFEE","V",{"$f":"Expenses!D22+(Expenses!D21*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E22+(Expenses!E21*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F22+(Expenses!F21*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G22+(Expenses!G21*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,15159726.475923482,16395351.524627967,15454116.286387412,18586081.434985206]
["MSUP","V",61319856.113708176,62711804.957782649,63058956.258771703,63838536.940277234,null,"MSUP","V",{"$f":"Expenses!D25+(Expenses!D24*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E25+(Expenses!E24*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F25+(Expenses!F24*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G25+(Expenses!G24*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,61319856.113708176,62711804.957782649,63058956.258771703,63838536.940277234]
["NMSUP","V",7018991.9729604153,7072446.0196786076,7085777.4304846488,7115715.1270797458,null,"NMSUP","V",{"$f":"Expenses!D28+(Expenses!D27*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E28+(Expenses!E27*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F28+(Expenses!F27*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G28+(Expenses!G27*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,7018991.9729604153,7072446.0196786076,7085777.4304846488,7115715.1270797458]
["TOPS","V",10245611.416535001,10251307.652759528,10252728.291042682,10255918.548886452,null,"TOPS","V",{"$f":"Expenses!D31+(Expenses!D30*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E31+(Expenses!E30*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F31+(Expenses!F30*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G31+(Expenses!G30*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,10245611.416535001,10251307.652759528,10252728.291042682,10255918.548886452]
["OEXP","V",2476961.7699192194,2479904.0909316875,2480637.9042264461,2482285.7928179502,null,"OEXP","V",{"$f":"Expenses!D34+(Expenses!D33*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E34+(Expenses!E33*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F34+(Expenses!F33*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G34+(Expenses!G33*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,2476961.7699192194,2479904.0909316875,2480637.9042264461,2482285.7928179502]
["MEXP","V","0","0","0","0",null,"MEXP","V",{"$f":"Expenses!D37+(Expenses!D36*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E37+(Expenses!E36*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F37+(Expenses!F36*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G37+(Expenses!G36*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,0,0,0,0]
["TREIM","V",-1029482.9446512479,-1029482.9446512479,-1029482.9446512479,-1029482.9446512479,null,"TREIM","V",{"$f":"Expenses!D40+(Expenses!D39*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E40+(Expenses!E39*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F40+(Expenses!F39*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G40+(Expenses!G39*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,-1029482.9446512479,-1029482.9446512479,-1029482.9446512479,-1029482.9446512479]
[]
["PROE","V",1900,1920,1950,2000,null,"PROE","V",{"$f":"Expenses!D42","v":0},{"$f":"Expenses!E42","v":0},{"$f":"Expenses!F42","v":0},{"$f":"Expenses!G42","v":0},null,1900,1920,1950,2000]

{"sheet":"TEST - UNBASE","index":2,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
[null,null,"2013","2014","2015","2016"]
[null,null,"UNBASE","UNBASE","UNBASE","UNBASE"]
[null,null,"999","999","999","999"]
["9001","V",70692,72465,72465,73400,null,"9001","V",{"$f":"SUM(Stats!E5:E9)","v":0},{"$f":"SUM(Stats!F5:F9)","v":0},{"$f":"SUM(Stats!G5:G9)","v":0},{"$f":"SUM(Stats!H5:H9)","v":0},null,{"$f":"C4-J4","v":70692},{"$f":"D4-K4","v":72465},{"$f":"E4-L4","v":72465},{"$f":"F4-M4","v":73400}]
["9011","V",18532,19416,19416,19600,null,"9011","V",{"$f":"SUM(Stats!E11:E15)","v":0},{"$f":"SUM(Stats!F11:F15)","v":0},{"$f":"SUM(Stats!G11:G15)","v":0},{"$f":"SUM(Stats!H11:H15)","v":0},null,{"$f":"C5-J5","v":18532},{"$f":"D5-K5","v":19416},{"$f":"E5-L5","v":19416},{"$f":"F5-M5","v":19600}]
[]
["ICU","V",20093916.945784166,20495169.955334317,20495169.955334317,20844312.184423409,null,"ICU","V",{"$f":"Stats!E5*Revenue!D5","v":0},{"$f":"Stats!F5*Revenue!E5","v":0},{"$f":"Stats!G5*Revenue!F5","v":0},{"$f":"Stats!H5*Revenue!G5","v":0},null,20093916.945784166,20495169.955334317,20495169.955334317,20844312.184423409]
["NIC","V",23975147.156989157,24454708.228743698,24454708.228743698,24704661.272203639,null,"NIC","V",{"$f":"Stats!E6*Revenue!D6","v":0},{"$f":"Stats!F6*Revenue!E6","v":0},{"$f":"Stats!G6*Revenue!F6","v":0},{"$f":"Stats!H6*Revenue!G6","v":0},null,23975147.156989157,24454708.228743698,24454708.228743698,24704661.272203639]
["ONS","V",106940134.86301166,109077376.52447191,109077376.52447191,110190762.35240769,null,"ONS","V",{"$f":"Stats!E7*Revenue!D7","v":0},{"$f":"Stats!F7*Revenue!E7","v":0},{"$f":"Stats!G7*Revenue!F7","v":0},{"$f":"Stats!H7*Revenue!G7","v":0},null,106940134.86301166,109077376.52447191,109077376.52447191,110190762.35240769]
["PED","V",4525938.3318159198,4750797.1975213904,4750797.1975213904,4967812.1493069017,null,"PED","V",{"$f":"Stats!E8*Revenue!D8","v":0},{"$f":"Stats!F8*Revenue!E8","v":0},{"$f":"Stats!G8*Revenue!F8","v":0},{"$f":"Stats!H8*Revenue!G8","v":0},null,4525938.3318159198,4750797.1975213904,4750797.1975213904,4967812.1493069017]
["WNO","V",32733651.169354364,34371608.402711853,34371608.402711853,35053559.468740076,null,"WNO","V",{"$f":"Stats!E9*Revenue!D9","v":0},{"$f":"Stats!F9*Revenue!E9","v":0},{"$f":"Stats!G9*Revenue!F9","v":0},{"$f":"Stats!H9*Revenue!G9","v":0},null,32733651.169354364,34371608.402711853,34371608.402711853,35053559.468740076]
["AOIP","V",218331071.75657374,220514382.47413948,222719526.29888088,224946721.56186968,null,"AOIP","V",{"$f":"Revenue!C10*(1+Revenue!D11)","v":0},{"$f":"Revenue!D10*(1+Revenue!E11)","v":0},{"$f":"Revenue!E10*(1+Revenue!F11)","v":0},{"$f":"Revenue!F10*(1+Revenue!G11)","v":0},null,218331071.75657374,220514382.47413948,222719526.29888088,224946721.56186968]
[]
["CVS","V",30540826.009165835,31151694.352750517,31151694.352750517,31741833.335789375,null,"CVS","V",{"$f":"Stats!E20*Revenue!D13","v":0},{"$f":"Stats!F20*Revenue!E13","v":0},{"$f":"Stats!G20*Revenue!F13","v":0},{"$f":"Stats!H20*Revenue!G13","v":0},null,30540826.009165835,31151694.352750517,31151694.352750517,31741833.335789375]
["IMG","V",101603995.30487542,103636229.38045451,103636229.38045451,104414785.26251258,null,"IMG","V",{"$f":"Stats!E21*Revenue!D14","v":0},{"$f":"Stats!F21*Revenue!E14","v":0},{"$f":"Stats!G21*Revenue!F14","v":0},{"$f":"Stats!H21*Revenue!G14","v":0},null,101603995.30487542,103636229.38045451,103636229.38045451,104414785.26251258]
["SUR","V",41351049.65322987,43417217.305025548,43417217.305025548,43760655.359747618,null,"SUR","V",{"$f":"Stats!E22*Revenue!D15","v":0},{"$f":"Stats!F22*Revenue!E15","v":0},{"$f":"Stats!G22*Revenue!F15","v":0},{"$f":"Stats!H22*Revenue!G15","v":0},null,41351049.65322987,43417217.305025548,43417217.305025548,43760655.359747618]
["EDR","V",78596961.051987588,82526878.858186647,82526878.858186647,83704319.62085332,null,"EDR","V",{"$f":"Stats!E23*Revenue!D16","v":0},{"$f":"Stats!F23*Revenue!E16","v":0},{"$f":"Stats!G23*Revenue!F16","v":0},{"$f":"Stats!H23*Revenue!G16","v":0},null,78596961.051987588,82526878.858186647,82526878.858186647,83704319.62085332]
["AOOP","V",111034727.7365275,113255422.29125805,115520530.73708321,117830941.35182488,null,"AOOP","V",{"$f":"Revenue!C17*(1+Revenue!D18)","v":0},{"$f":"Revenue!D17*(1+Revenue!E18)","v":0},{"$f":"Revenue!E17*(1+Revenue!F18)","v":0},{"$f":"Revenue!F17*(1+Revenue!G18)","v":0},null,111034727.7365275,113255422.29125805,115520530.73708321,117830941.35182488]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0]
["SVREV","V",0,0,0,0,null,"SVREV","V",{"$f":"(SUM(Stats!E5:E9)*Revenue!D20)+Revenue!D21","v":0},{"$f":"(SUM(Stats!F5:F9)*Revenue!E20)+Revenue!E21","v":0},{"$f":"(SUM(Stats!G5:G9)*Revenue!F20)+Revenue!F21","v":0},{"$f":"(SUM(Stats!H5:H9)*Revenue!G20)+Revenue!G21","v":0},null,0,0,0,0]
["LTREV","V",0,0,0,0,null,"LTREV","V",{"$f":"(SUM(Stats!E5:E9)*Revenue!D23)+Revenue!D21","v":0},{"$f":"(SUM(Stats!F5:F9)*Revenue!E23)+Revenue!E21","v":0},{"$f":"(SUM(Stats!G5:G9)*Revenue!F23)+Revenue!F21","v":0},{"$f":"(SUM(Stats!H5:H9)*Revenue!G23)+Revenue!G21","v":0},null,0,0,0,0]
[]
["OOR","V",14718684.664876714,14987545.639745956,15054599.423804455,15205178.823982174,null,"OOR","V",{"$f":"(SUM(J7:J12,J14:J18,J20:J21)*Revenue!D26)+Revenue!D27","v":0},{"$f":"(SUM(K7:K12,K14:K18,K20:K21)*Revenue!E26)+Revenue!E27","v":0},{"$f":"(SUM(L7:L12,L14:L18,L20:L21)*Revenue!F26)+Revenue!F27","v":0},{"$f":"(SUM(M7:M12,M14:M18,M20:M21)*Revenue!G26)+Revenue!G27","v":0},null,14718684.664876714,14987545.639745956,15054599.423804455,15205178.823982174]
[]
["MCARE","MR",278861790.65460426,285355435.97571415,293085042.77923083,296799334.65028131,null,"MCARE","MR",{"$f":"SUM(J$7:J$21)*Deductions!D5","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E5","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F5","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G5","v":0},null,278861790.65460426,285355435.97571415,293085042.77923083,296799334.65028131]
["MCAID","MR",92448410.965026185,94601187.757780269,87133391.096528083,88237640.031164706,null,"MCAID","MR",{"$f":"SUM(J$7:J$21)*Deductions!D6","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E6","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F6","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G6","v":0},null,92448410.965026185,94601187.757780269,87133391.096528083,88237640.031164706]
["SELECTH","MR",123922861.99022265,126808560.71234718,125155234.48410398,126741337.49930932,null,"SELECTH","MR",{"$f":"SUM(J$7:J$21)*Deductions!D7","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E7","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F7","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G7","v":0},null,123922861.99022265,126808560.71234718,125155234.48410398,126741337.49930932]
["CONT","MR",195738731.31188798,200296752.30773586,207535895.15718511,210166015.34695596,null,"CONT","MR",{"$f":"SUM(J$7:J$21)*Deductions!D8","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E8","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F8","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G8","v":0},null,195738731.31188798,200296752.30773586,207535895.15718511,210166015.34695596]
["NCONT","MR",20103307.703127027,20571438.348414794,19010921.693787947,19251848.734072302,null,"NCONT","MR",{"$f":"SUM(J$7:J$21)*Deductions!D9","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E9","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F9","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G9","v":0},null,20103307.703127027,20571438.348414794,19010921.693787947,19251848.734072302]
["UNINS","MR",58652317.354447283,60018109.868606009,60358737.794833124,61123669.252993844,null,"UNINS","MR",{"$f":"SUM(J$7:J$21)*Deductions!D10","v":0},{"$f":"SUM(K$7:K$21)*Deductions!E10","v":0},{"$f":"SUM(L$7:L$21)*Deductions!F10","v":0},{"$f":"SUM(M$7:M$21)*Deductions!G10","v":0},null,58652317.354447283,60018109.868606009,60358737.794833124,61123669.252993844]
[]
["MCARE","V",184428305.9743464,188722949.58026761,193835009.87821659,196291497.5743764,null,"MCARE","V",{"$f":"'TEST - UNBASE'!J25-('TEST - UNBASE'!J25*Deductions!D15)","v":0},{"$f":"'TEST - UNBASE'!K25-('TEST - UNBASE'!K25*Deductions!E15)","v":0},{"$f":"'TEST - UNBASE'!L25-('TEST - UNBASE'!L25*Deductions!F15)","v":0},{"$f":"'TEST - UNBASE'!M25-('TEST - UNBASE'!M25*Deductions!G15)","v":0},null,184428305.9743464,188722949.58026761,193835009.87821659,196291497.5743764]
["MCAID","V",48464776.748643354,49593339.647252366,45678452.477057844,46257339.420959316,null,"MCAID","V",{"$f":"'TEST - UNBASE'!J26-('TEST - UNBASE'!J26*Deductions!D16)","v":0},{"$f":"'TEST - UNBASE'!K26-('TEST - UNBASE'!K26*Deductions!E16)","v":0},{"$f":"'TEST - UNBASE'!L26-('TEST - UNBASE'!L26*Deductions!F16)","v":0},{"$f":"'TEST - UNBASE'!M26-('TEST - UNBASE'!M26*Deductions!G16)","v":0},null,48464776.748643354,49593339.647252366,45678452.477057844,46257339.420959316]
["SELECTH","V",46536633.606124327,47620297.281837106,46999425.267751276,47595053.013065964,null,"SELECTH","V",{"$f":"'TEST - UNBASE'!J27-('TEST - UNBASE'!J27*Deductions!D17)","v":0},{"$f":"'TEST - UNBASE'!K27-('TEST - UNBASE'!K27*Deductions!E17)","v":0},{"$f":"'TEST - UNBASE'!L27-('TEST - UNBASE'!L27*Deductions!F17)","v":0},{"$f":"'TEST - UNBASE'!M27-('TEST - UNBASE'!M27*Deductions!G17)","v":0},null,46536633.606124327,47620297.281837106,46999425.267751276,47595053.013065964]
["CONT","V",51226927.667677432,52419810.702614486,54314372.11434567,55002702.808100939,null,"CONT","V",{"$f":"'TEST - UNBASE'!J28-('TEST - UNBASE'!J28*Deductions!D18)","v":0},{"$f":"'TEST - UNBASE'!K28-('TEST - UNBASE'!K28*Deductions!E18)","v":0},{"$f":"'TEST - UNBASE'!L28-('TEST - UNBASE'!L28*Deductions!F18)","v":0},{"$f":"'TEST - UNBASE'!M28-('TEST - UNBASE'!M28*Deductions!G18)","v":0},null,51226927.667677432,52419810.702614486,54314372.11434567,55002702.808100939]
["NCONT","V",3409786.7525545843,3489187.8986912854,3224503.6440071799,3265368.0550993904,null,"NCONT","V",{"$f":"'TEST - UNBASE'!J29-('TEST - UNBASE'!J29*Deductions!D19)","v":0},{"$f":"'TEST - UNBASE'!K29-('TEST - UNBASE'!K29*Deductions!E19)","v":0},{"$f":"'TEST - UNBASE'!L29-('TEST - UNBASE'!L29*Deductions!F19)","v":0},{"$f":"'TEST - UNBASE'!M29-('TEST - UNBASE'!M29*Deductions!G19)","v":0},null,3409786.7525545843,3489187.8986912854,3224503.6440071799,3265368.0550993904]
["UNINS","V",0,0,0,0,null,"UNINS","V",{"$f":"'TEST - UNBASE'!J30-('TEST - UNBASE'!J30*Deductions!D20)","v":0},{"$f":"'TEST - UNBASE'!K30-('TEST - UNBASE'!K30*Deductions!E20)","v":0},{"$f":"'TEST - UNBASE'!L30-('TEST - UNBASE'!L30*Deductions!F20)","v":0},{"$f":"'TEST - UNBASE'!M30-('TEST - UNBASE'!M30*Deductions!G20)","v":0},null,0,0,0,0]
[]
["CHAR","V",40789173.868458897,41739000.760917321,41975887.082447752,42507851.097711086,null,"CHAR","V",{"$f":"Expenses!D8+(Expenses!D5*SUM('TEST - UNBASE'!J$7:J$22))","v":0},{"$f":"Expenses!E8+(Expenses!E5*SUM('TEST - UNBASE'!K$7:K$22))","v":0},{"$f":"Expenses!F8+(Expenses!F5*SUM('TEST - UNBASE'!L$7:L$22))","v":0},{"$f":"Expenses!G8+(Expenses!G5*SUM('TEST - UNBASE'!M$7:M$22))","v":0},null,40789173.868458897,41739000.760917321,41975887.082447752,42507851.097711086]
["BDEBT","V",31548329.59279298,32282971.876944464,32466191.271673251,32877638.096734125,null,"BDEBT","V",{"$f":"Expenses!D9+(Expenses!D6*SUM('TEST - UNBASE'!J$7:J$22))","v":0},{"$f":"Expenses!E9+(Expenses!E6*SUM('TEST - UNBASE'!K$7:K$22))","v":0},{"$f":"Expenses!F9+(Expenses!F6*SUM('TEST - UNBASE'!L$7:L$22))","v":0},{"$f":"Expenses!G9+(Expenses!G6*SUM('TEST - UNBASE'!M$7:M$22))","v":0},null,31548329.59279298,32282971.876944464,32466191.271673251,32877638.096734125]
["ODED","V",20161608.974321112,20631097.237574451,20748187.360592484,21011130.917594574,null,"ODED","V",{"$f":"Expenses!D10+(Expenses!D7*SUM('TEST - UNBASE'!J$7:J$22))","v":0},{"$f":"Expenses!E10+(Expenses!E7*SUM('TEST - UNBASE'!K$7:K$22))","v":0},{"$f":"Expenses!F10+(Expenses!F7*SUM('TEST - UNBASE'!L$7:L$22))","v":0},{"$f":"Expenses!G10+(Expenses!G7*SUM('TEST - UNBASE'!M$7:M$22))","v":0},null,20161608.974321112,20631097.237574451,20748187.360592484,21011130.917594574]
[]
["TSAL","V",111313958.24089611,114735955.61759838,117090601.00663453,118887010.79478717,null,"TSAL","V",{"$f":"Expenses!D13+(Expenses!D12*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E13+(Expenses!E12*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F13+(Expenses!F12*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G13+(Expenses!G12*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,111313958.24089611,114735955.61759838,117090601.00663453,118887010.79478717]
["PHY","V",8274356.0102458578,8321742.1140658753,8333560.1831421554,8360099.4423018303,null,"PHY","V",{"$f":"Expenses!D16+(Expenses!D15*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E16+(Expenses!E15*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F16+(Expenses!F15*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G16+(Expenses!G15*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,8274356.0102458578,8321742.1140658753,8333560.1831421554,8360099.4423018303]
["OBEN","V",29065453.192657728,29170942.280859318,29197251.203320961,29256331.862514492,null,"OBEN","V",{"$f":"Expenses!D19+(Expenses!D18*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E19+(Expenses!E18*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F19+(Expenses!F18*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G19+(Expenses!G18*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,29065453.192657728,29170942.280859318,29197251.203320961,29256331.862514492]
["TFEE","V",15159726.475923482,16395351.524627967,15454116.286387412,18586081.434985206,null,"TFEE","V",{"$f":"Expenses!D22+(Expenses!D21*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E22+(Expenses!E21*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F22+(Expenses!F21*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G22+(Expenses!G21*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,15159726.475923482,16395351.524627967,15454116.286387412,18586081.434985206]
["MSUP","V",61319856.113708176,62711804.957782649,63058956.258771703,63838536.940277234,null,"MSUP","V",{"$f":"Expenses!D25+(Expenses!D24*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E25+(Expenses!E24*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F25+(Expenses!F24*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G25+(Expenses!G24*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,61319856.113708176,62711804.957782649,63058956.258771703,63838536.940277234]
["NMSUP","V",7018991.9729604153,7072446.0196786076,7085777.4304846488,7115715.1270797458,null,"NMSUP","V",{"$f":"Expenses!D28+(Expenses!D27*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E28+(Expenses!E27*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F28+(Expenses!F27*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G28+(Expenses!G27*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,7018991.9729604153,7072446.0196786076,7085777.4304846488,7115715.1270797458]
["TOPS","V",10245611.416535001,10251307.652759528,10252728.291042682,10255918.548886452,null,"TOPS","V",{"$f":"Expenses!D31+(Expenses!D30*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E31+(Expenses!E30*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F31+(Expenses!F30*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G31+(Expenses!G30*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,10245611.416535001,10251307.652759528,10252728.291042682,10255918.548886452]
["OEXP","V",2476961.7699192194,2479904.0909316875,2480637.9042264461,2482285.7928179502,null,"OEXP","V",{"$f":"Expenses!D34+(Expenses!D33*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E34+(Expenses!E33*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F34+(Expenses!F33*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G34+(Expenses!G33*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,2476961.7699192194,2479904.0909316875,2480637.9042264461,2482285.7928179502]
["MEXP","V","0","0","0","0",null,"MEXP","V",{"$f":"Expenses!D37+(Expenses!D36*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E37+(Expenses!E36*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F37+(Expenses!F36*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G37+(Expenses!G36*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,0,0,0,0]
["TREIM","V",-1029482.9446512479,-1029482.9446512479,-1029482.9446512479,-1029482.9446512479,null,"TREIM","V",{"$f":"Expenses!D40+(Expenses!D39*SUM('TEST - UNBASE'!J$7:J$23))","v":0},{"$f":"Expenses!E40+(Expenses!E39*SUM('TEST - UNBASE'!K$7:K$23))","v":0},{"$f":"Expenses!F40+(Expenses!F39*SUM('TEST - UNBASE'!L$7:L$23))","v":0},{"$f":"Expenses!G40+(Expenses!G39*SUM('TEST - UNBASE'!M$7:M$23))","v":0},null,-1029482.9446512479,-1029482.9446512479,-1029482.9446512479,-1029482.9446512479]
[]
["PROE","V",1900,1920,1950,2000,null,"PROE","V",{"$f":"Expenses!D42","v":0},{"$f":"Expenses!E42","v":0},{"$f":"Expenses!F42","v":0},{"$f":"Expenses!G42","v":0},null,1900,1920,1950,2000]

{"sheet":"Data","index":3,"n_rows":107,"n_cols":6,"rows_kept":107,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"2010","2011","2012","2012"]
[null,null,"Actual","UNBASE","UNBASE","INBASE"]
[null,null,{"$f":"Facility","v":"116"},"116",{"$f":"Facility","v":"116"},{"$f":"Facility","v":"116"}]
["9001ICU","V",773,837.00234835222898,830.82483156476928,830.82483156476928]
["9001NIC","V","0","0","0","0"]
["9001ONS","V",7148,6662.4623488943507,6611.0000000000009,6611.0000000000009]
["9001PED","V","0","0","0","0"]
["9001WNO","V",3705,3132.6906007636085,3128.9999999999995,3128.9999999999995]
["9001AOIP","V","0","0","0","0"]
[]
["9011ICU","V",300,279.52952825877975,277.83995972469967,277.83995972469967]
["9011NIC","V","0","0","0","0"]
["9011ONS","V",2091,1861.0225233209799,1846.75327867845,1846.75327867845]
["9011PED","V","0","0","0","0"]
["9011WNO","V",1808,1558.3895810225356,1556.0111810020433,1556.0111810020433]
["9011AOIP","V","0","0","0","0"]
[]
["9146","V",1113,1110.0134341082819,1099.8530625504247,1099.8530625504247]
["9209","V",1898,1734.2695642254166,1709,1709]
[]
["9308CVS","V",3977,3718,3718.0000000000005,3718.0000000000005]
["9308IMG","V",47303,41171,41057.22063238603,41057.22063238603]
["9031","V",5716,5509,5565,5565]
["9309","V",22996,20797.000000000004,20866,20866]
[]
["ICU","R","0","0","0","0"]
["NIC","R","0","0","0","0"]
["ONS","R","0","0","0","0"]
["PED","R","0","0","0","0"]
["WNO","R","0","0","0","0"]
["AOIP","V",37416261.569999993,"0","0","0"]
[]
["CVS","R","0","0","0","0"]
["IMG","R","0","0","0","0"]
["SUR","R","0","0","0","0"]
["EDR","R","0","0","0","0"]
["AOOP","V",27798611.180000003,"0","0","0"]
[]
["SVREV","R","0","0","0","0"]
["SVREV","F","0","0","0","0"]
[]
["LTREV","R","0","0","0","0"]
["LTREV","F","0","0","0","0"]
[]
["OOR","R","0","0","0","0"]
["OOR","F","0","0","0","0"]
[]
["CHAR","R","0","0","0","0"]
["CHAR","F","0","0","0","0"]
["BDEBT","R","0","0","0","0"]
["BDEBT","F","0","0","0","0"]
["ODED","R","0","0","0","0"]
["ODED","F","0","0","0","0"]
[]
["TSAL","R","0","0","0","0"]
["TSAL","F","0","0","0","0"]
[]
["PHY","R","0","0","0","0"]
["PHY","F","0","0","0","0"]
[]
["OBEN","R","0","0","0","0"]
["OBEN","F","0","0",0,0]
[]
["TFEE","R","0","0","0","0"]
["TFEE","F","0","0","0","0"]
[]
["MSUP","R","0","0","0","0"]
["MSUP","F","0","0","0","0"]
[]
["NMSUP","R","0","0","0","0"]
["NMSUP","F","0","0","0","0"]
[]
["TOPS","R","0","0","0","0"]
["TOPS","F","0","0","0","0"]
[]
["OEXP","R","0","0","0","0"]
["OEXP","F","0","0","0","0"]
[]
["MEXP","R","0","0","0","0"]
["MEXP","F","0","0","0","0"]
[]
["TREIM","R","0","0","0","0"]
["TREIM","F","0","0","0","0"]
[]
["PROE","V",423.71340996168584,"0","0","0"]
[]
["4472","V","0","0","0","0"]
["4471","V",2353483.0399999996,"0","0","0"]
["4474","V",943684.37000000011,"0","0","0"]
["4475","V",3958709.4,"0","0","0"]
[]
["MCARE","P","0","0","0","0"]
["MCAID","P","0","0","0","0"]
["SELECTH","P","0","0","0","0"]
["CONT","P","0","0","0","0"]
["NCONT","P","0","0","0","0"]
["UNINS","P","0","0","0","0"]
[]
["MCARE","R","0","0","0","0"]
["MCAID","R","0","0","0","0"]
["SELECTH","R","0","0","0","0"]
["CONT","R","0","0","0","0"]
["NCONT","R","0","0","0","0"]
["UNINS","R","0","0","0","0"]
[]
["NOI","V",26953456.599999979,0,0,0]

{"sheet":"Stats","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"Facility","v":"116"}]
[null,null,"UNBASE"]
[null,null,"2011","2012","2013","2014","2015","2016"]
["9001ICU","V",{"$f":"Data!D5","v":837.00234835222898},{"$f":"Data!E5","v":830.82483156476928},0,0,0,0]
["9001NIC","V",{"$f":"Data!D6","v":"0"},{"$f":"Data!E6","v":"0"},0,0,0,0]
["9001ONS","V",{"$f":"Data!D7","v":6662.4623488943507},{"$f":"Data!E7","v":6611.0000000000009},0,0,0,0]
["9001PED","V",{"$f":"Data!D8","v":"0"},{"$f":"Data!E8","v":"0"},0,0,0,0]
["9001WNO","V",{"$f":"Data!D9","v":3132.6906007636085},{"$f":"Data!E9","v":3128.9999999999995},0,0,0,0]
[]
["9011ICU","V",{"$f":"Data!D12","v":279.52952825877975},{"$f":"Data!E12","v":277.83995972469967},0,0,0,0]
["9011NIC","V",{"$f":"Data!D13","v":"0"},{"$f":"Data!E13","v":"0"},0,0,0,0]
["9011ONS","V",{"$f":"Data!D14","v":1861.0225233209799},{"$f":"Data!E14","v":1846.75327867845},0,0,0,0]
["9011PED","V",{"$f":"Data!D15","v":"0"},{"$f":"Data!E15","v":"0"},0,0,0,0]
["9011WNO","V",{"$f":"Data!D16","v":1558.3895810225356},{"$f":"Data!E16","v":1556.0111810020433},0,0,0,0]
[]
["9146","V",{"$f":"Data!D19","v":1110.0134341082819},{"$f":"Data!E19","v":1099.8530625504247},0,0,0,0]
["9209","V",{"$f":"Data!D20","v":1734.2695642254166},{"$f":"Data!E20","v":1709},0,0,0,0]
[]
["9308CVS","V",{"$f":"Data!D22","v":3718},{"$f":"Data!E22","v":3718.0000000000005},0,0,0,0]
["9308IMG","V",{"$f":"Data!D23","v":41171},{"$f":"Data!E23","v":41057.22063238603},0,0,0,0]
["9031","V",{"$f":"Data!D24","v":5509},{"$f":"Data!E24","v":5565},0,0,0,0]
["9309","V",{"$f":"Data!D25","v":20797.000000000004},{"$f":"Data!E25","v":20866},0,0,0,0]

{"sheet":"Revenue","index":5,"n_rows":27,"n_cols":7,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"Facility","v":"116"}]
[null,null,"UNBASE"]
[null,null,{"$f":"year2","v":"2012"},{"$f":"year3","v":"2013"},{"$f":"year4","v":"2014"},{"$f":"year5","v":"2015"},{"$f":"year6","v":"2016"}]
["ICU","R",{"$f":"Data!E27","v":"0"},0,0,0,0]
["NIC","R",{"$f":"Data!E28","v":"0"},0,0,0,0]
["ONS","R",{"$f":"Data!E29","v":"0"},0,0,0,0]
["PED","R",{"$f":"Data!E30","v":"0"},0,0,0,0]
["WNO","R",{"$f":"Data!E31","v":"0"},0,0,0,0]
["AOIP","V",{"$f":"Data!E32","v":"0"},{"$f":"C10*(1+D11)","v":0},{"$f":"D10*(1+E11)","v":0},{"$f":"E10*(1+F11)","v":0},{"$f":"F10*(1+G11)","v":0}]
["AOIP","R",null,0,0,0,0]
[]
["CVS","R",{"$f":"Data!E34","v":"0"},0,0,0,0]
["IMG","R",{"$f":"Data!E35","v":"0"},0,0,0,0]
["SUR","R",{"$f":"Data!E36","v":"0"},0,0,0,0]
["EDR","R",{"$f":"Data!E37","v":"0"},0,0,0,0]
["AOOP","V",{"$f":"Data!E38","v":"0"},{"$f":"C17*(1+D18)","v":0},{"$f":"D17*(1+E18)","v":0},{"$f":"E17*(1+F18)","v":0},{"$f":"F17*(1+G18)","v":0}]
["AOOP","R",null,0,0,0,0]
[]
["SVREV","R",{"$f":"Data!E40","v":"0"},0,0,0,0]
["SVREV","F",{"$f":"Data!E41","v":"0"},0,0,0,0]
[]
["LTREV","R",{"$f":"Data!E43","v":"0"},0,0,0,0]
["LTREV","F",{"$f":"Data!E44","v":"0"},0,0,0,0]
[]
["OOR","R",{"$f":"Data!E46","v":"0"},1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2,1.4999999999999999E-2]
["OOR","F",{"$f":"Data!E47","v":"0"},0,0,0,0]

{"sheet":"Expenses","index":6,"n_rows":42,"n_cols":7,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"Facility","v":"116"}]
[null,null,"UNBASE"]
[null,null,{"$f":"year2","v":"2012"},{"$f":"year3","v":"2013"},{"$f":"year4","v":"2014"},{"$f":"year5","v":"2015"},{"$f":"year6","v":"2016"}]
["CHAR","R",{"$f":"Data!E49","v":"0"},0,0,0,0]
["BDEBT","R",{"$f":"Data!E51","v":"0"},0,0,0,0]
["ODED","R",{"$f":"Data!E53","v":"0"},0,0,0,0]
["CHAR","F",{"$f":"Data!E50","v":"0"},0,0,0,0]
["BDEBT","F",{"$f":"Data!E52","v":"0"},0,0,0,0]
["ODED","F",{"$f":"Data!E54","v":"0"},0,0,0,0]
[]
["TSAL","R",{"$f":"Data!E56","v":"0"},0,0,0,0]
["TSAL","F",{"$f":"Data!E57","v":"0"},0,0,0,0]
[]
["PHY","R",{"$f":"Data!E59","v":"0"},0,0,0,0]
["PHY","F",{"$f":"Data!E60","v":"0"},0,0,0,0]
[]
["OBEN","R",{"$f":"Data!E62","v":"0"},0,0,0,0]
["OBEN","F",{"$f":"Data!E63","v":0},0,0,0,0]
[]
["TFEE","R",{"$f":"Data!E65","v":"0"},0,0,0,0]
["TFEE","F",{"$f":"Data!E66","v":"0"},0,0,0,0]
[]
["MSUP","R",{"$f":"Data!E68","v":"0"},0,0,0,0]
["MSUP","F",{"$f":"Data!E69","v":"0"},0,0,0,0]
[]
["NMSUP","R",{"$f":"Data!E71","v":"0"},0,0,0,0]
["NMSUP","F",{"$f":"Data!E72","v":"0"},0,0,0,0]
[]
["TOPS","R",{"$f":"Data!E74","v":"0"},0,0,0,0]
["TOPS","F",{"$f":"Data!E75","v":"0"},0,0,0,0]
[]
["OEXP","R",{"$f":"Data!E77","v":"0"},0,0,0,0]
["OEXP","F",{"$f":"Data!E78","v":"0"},0,0,0,0]
[]
["MEXP","R",{"$f":"Data!E80","v":"0"},"0","0","0","0"]
["MEXP","F",{"$f":"Data!E81","v":"0"},"0","0","0","0"]
[]
["TREIM","R",{"$f":"Data!E83","v":"0"},0,0,0,0]
["TREIM","F",{"$f":"Data!E84","v":"0"},0,0,0,0]
[]
["PROE","V",{"$f":"Data!E86","v":"0"},0,0,0,0]

{"sheet":"Deductions","index":7,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"Facility","v":"116"}]
[null,null,"UNBASE"]
[null,null,{"$f":"year2","v":"2012"},{"$f":"year3","v":"2013"},{"$f":"year4","v":"2014"},{"$f":"year5","v":"2015"},{"$f":"year6","v":"2016"}]
["MCARE","P",{"$f":"Data!E93","v":"0"},0,0,0,0]
["MCAID","P",{"$f":"Data!E94","v":"0"},0,0,0,0]
["SELECTH","P",{"$f":"Data!E95","v":"0"},0,0,0,0]
["CONT","P",{"$f":"Data!E96","v":"0"},0,0,0,0]
["NCONT","P",{"$f":"Data!E97","v":"0"},0,0,0,0]
["UNINS","P",{"$f":"Data!E98","v":"0"},0,0,0,0]
[null,null,{"$f":"SUM(C5:C10)","v":0},{"$f":"SUM(D5:D10)","v":0},{"$f":"SUM(E5:E10)","v":0},{"$f":"SUM(F5:F10)","v":0},{"$f":"SUM(G5:G10)","v":0}]
[]
[]
[]
["MCARE","R",{"$f":"Data!E100","v":"0"},0,0,0,0]
["MCAID","R",{"$f":"Data!E101","v":"0"},0,0,0,0]
["SELECTH","R",{"$f":"Data!E102","v":"0"},0,0,0,0]
["CONT","R",{"$f":"Data!E103","v":"0"},0,0,0,0]
["NCONT","R",{"$f":"Data!E104","v":"0"},0,0,0,0]
["UNINS","R",1,1,1,1,1]

{"sheet":"Productivity","index":8,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,{"$f":"Facility","v":"116"}]
[null,null,"UNBASE"]
[null,null,{"$f":"year3","v":"2013"},{"$f":"year4","v":"2014"},{"$f":"year5","v":"2015"},{"$f":"year6","v":"2016"}]
["TSAL","PR",0,{"$f":"C5","v":0},{"$f":"D5","v":0},0]
["TSAL","PRF",0,{"$f":"C6","v":0},0,0]
[]
["PHY","PR",0,0,0,0]
["PHY","PRF",0,0,0,0]
[]
["OBEN","PR",0,0,0,0]
["OBEN","PRF",0,0,0,0]
[]
["TFEE","PR",0,0,0,0]
["TFEE","PRF",0,0,0,0]
[]
["MSUP","PR",0,{"$f":"C17","v":0},0,0]
["MSUP","PRF",0,0,0,0]
[]
["NMSUP","PR",0,0,0,0]
["NMSUP","PRF",0,0,0,0]
[]
["TOPS","PR",0,0,0,0]
["TOPS","PRF",0,0,0,0]
[]
["OEXP","PR",0,0,{"$f":"D26","v":0},{"$f":"E26","v":0}]
["OEXP","PRF",0,{"$f":"C27","v":0},{"$f":"D27","v":0},{"$f":"E27","v":0}]

{"sheet":"Report Data","index":9,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Facility","v":"116"},{"$f":"Facility","v":"116"}]
[null,"Actual",{"$f":"VLOOKUP(Lookup!D5,Lookup!$C$7:$D$17,2,0)","v":"Inflated"}]
[null,"V","V"]
[null,{"$f":"TEXT(Year,0)","v":"2010"},{"$f":"year1","v":"2011"},{"$f":"year2","v":"2012"},{"$f":"year3","v":"2013"},{"$f":"year4","v":"2014"},{"$f":"year5","v":"2015"},{"$f":"year6","v":"2016"}]
["IPREV","0",519710564.01893598,559484665.63233805,608986099.76485646,663633987.050174,608986099.76485646,663633987.050174]
["OPREV","0",532951472.05613333,583582097.20380723,642939958.09423327,708104845.2064712,642939958.09423327,708104845.2064712]
["SVREV","0",0,0,0,0,0,0]
["LTREV","0",1816941.6128714727,1881002.8296761606,1947234.1548842336,2025803.454405572,1947234.1548842336,2025803.454405572]
["OOR","0",17852952.373175118,18822123.944111183,19743362.433562133,21674310.624438904,19743362.433562133,21674310.624438904]
["PTREV","0",1054478977.6879408,1144947765.6658213,1253873292.013974,1373764635.7110507,1253873292.013974,1373764635.7110507]
["TREV","0",1072331930.0611159,1163769889.6099327,1273616654.4475362,1395438946.3354897,1273616654.4475362,1395438946.3354897]
[]
["MCARE","0",239831500.83882374,273986480.11054933,306525473.81244618,345879907.96419907,306525473.81244618,345879907.96419907]
["MCAID","0",65520292.905283257,76359440.579816118,92521939.414152965,112965704.21666916,92521939.414152965,112965704.21666916]
["DISC","0",126096610.83651769,138247446.80659786,150584068.22879189,163410126.82252783,150584068.22879189,163410126.82252783]
["CHAR","0",49773570.410541333,54930523.435290851,61594377.810169086,69170537.104920611,61594377.810169086,69170537.104920611]
["BDEBT","0",37936768.11856582,41400062.63339968,46169828.069451869,51470508.288557991,46169828.069451869,51470508.288557991]
["ODED","0",28621336.395859905,31321348.496439986,34605994.134333611,38179011.820737489,34605994.134333611,38179011.820737489]
["TDED","0",547780079.50559175,616245302.06209385,692001681.46934557,781075796.21761215,692001681.46934557,781075796.21761215]
[]
["NREV","0",524551850.55552411,547524587.54783881,581614972.97819066,614363150.1178776,581614972.97819066,614363150.1178776]
[]
["GTSAL","0",167939662.38730603,175154613.16180876,184621579.15054858,195895441.19392794,184621579.15054858,195895441.19392794]
["EBEN","0",59636221.861887954,63532281.886774257,68042636.515920132,72582493.830562294,68042636.515920132,72582493.830562294]
["TFEE","0",16662395.923597114,16991675.77862151,17611997.770120669,18328732.103500508,17611997.770120669,18328732.103500508]
["TSUP","0",93907634.193898678,98933663.668707415,106319042.82959299,114683320.08757213,106319042.82959299,114683320.08757213]
["TOPS","0",16163940.891894866,16245696.166741025,16632671.559834061,17030250.789383359,16632671.559834061,17030250.789383359]
["AOEXP","0",27138313.218133837,28632765.765363093,29260504.434648514,29672269.655986547,29260504.434648514,29672269.655986547]
[]
["EBIDA","0",87134231.991177097,89399011.735489488,96226246.635792047,99374032.61471805,96226246.635792047,99374032.61471805]
[]
["INT","0",9919484,10231104.679948226,10721683.72321333,12242221.415270692,10721683.72321333,12242221.415270692]
["DEP","0",27176497.8258266,26280861.666666664,26967395.095238097,29122398.333333336,26967395.095238097,29122398.333333336]
["TCORP","0",55969450.087628491,58634879.384333245,62900294.081733696,66796609.842226885,62900294.081733696,66796609.842226885]
[]
["TEXP","0",474513600.39017361,494637542.15896422,523077805.16085005,556353737.25176358,523077805.16085005,556353737.25176358]
[]
["NOI","0",50038250.165350497,52887045.38887459,58537167.817340612,58009412.86611402,58537167.817340612,58009412.86611402]
[]
["9011","0",24530,24852.090000000004,25297.951449999997,25792.7329235,25297.951449999997,25792.7329235]
["9001","0",88633.779438292244,89642.993920572771,91203.865125662705,92917.712306754605,91203.865125662705,92917.712306754605]
["9146","0",5245,5277.7950000000001,5330.5729499999998,5397.7520395000001,5330.5729499999998,5397.7520395000001]
["9031","0",19764,20097.447499999998,20448.579687499998,20840.995013749998,20448.579687499998,20840.995013749998]
["9209","0",11274,11572.259999999998,11937.732499999998,12327.136649499998,11937.732499999998,12327.136649499998]
["9309","0",79933,81103.125,83203.429550000001,85361.253800499995,83203.429550000001,85361.253800499995]
["9308IMG","0",192161,199606.44,207392.19760000001,214991.04859200001,207392.19760000001,214991.04859200001]
["9308CVS","0",61361,63512.73,65784.591899999999,67819.954599000004,65784.591899999999,67819.954599000004]
[]
["CAPEX","0","0","0","0","0","0","0"]
[]
["PROE","0",2700.1805877807465,2725.949166958917,2768.2886493956426,2813.1710674238484,2768.2886493956426,2813.1710674238484]

{"sheet":"Final Report","index":10,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,11],[5,4,5,11],[1,0,1,11],[2,0,2,11],[3,0,3,11]]}
[{"$f":"VLOOKUP('Report Data'!$B$2,Lookup!A:B,2,0)","v":"Alta View Hospital"}]
[{"$f":"VLOOKUP('Report Data'!C3,Lookup!D:E,2,0)&\" Financial Projection\"","v":"Productivity Adjusted Inflated Financial Projection"}]
[{"$f":"TODAY()","v":"2012-04-11"}]
["(in thousands)"]
[]
[]
[null,null,{"$f":"year1","v":"2011"},null,{"$f":"year2","v":"2012"},null,{"$f":"year3","v":"2013"},null,{"$f":"year4","v":"2014"},null,{"$f":"year5","v":"2015"},null,{"$f":"year6","v":"2016"}]
[]
["Inpatient Revenue",null,{"$f":"'Report Data'!C6/1000","v":519710.56401893595},{"$f":"C9/C$13","v":0.48465456399243456},{"$f":"'Report Data'!D6/1000","v":559484.66563233803},{"$f":"E9/E$13","v":0.48075196877611576},{"$f":"'Report Data'!E6/1000","v":608986.09976485651},{"$f":"G9/G$13","v":0.4781549437487686},{"$f":"'Report Data'!F6/1000","v":663633.98705017404},{"$f":"I9/I$13","v":0.47557364569257471},{"$f":"'Report Data'!G6/1000","v":608986.09976485651},{"$f":"K9/K$13","v":0.4781549437487686},{"$f":"'Report Data'!H6/1000","v":663633.98705017404},{"$f":"M9/M$13","v":0.47557364569257471}]
["Outpatient Revenue",null,{"$f":"'Report Data'!C7/1000","v":532951.47205613332},{"$f":"C10/C$13","v":0.49700233399350385},{"$f":"'Report Data'!D7/1000","v":583582.09720380721},0.50145832300181759,{"$f":"'Report Data'!E7/1000","v":642939.9580942333},{"$f":"G10/G$13","v":0.50481434570524275},{"$f":"'Report Data'!F7/1000","v":708104.84520647116},{"$f":"I10/I$13","v":0.50744236934621811},{"$f":"'Report Data'!G7/1000","v":642939.9580942333},{"$f":"K10/K$13","v":0.50481434570524275},{"$f":"'Report Data'!H7/1000","v":708104.84520647116},{"$f":"M10/M$13","v":0.50744236934621811}]
["Other Patient Revenue",null,{"$f":"('Report Data'!C8+'Report Data'!C9)/1000","v":1816.9416128714727},1.6943835783831587E-3,{"$f":"('Report Data'!D8+'Report Data'!D9)/1000","v":1881.0028296761607},1.61630133797896E-3,{"$f":"('Report Data'!E8+'Report Data'!E9)/1000","v":1947.2341548842337},{"$f":"G11/G$13","v":1.5289012970146E-3},{"$f":"('Report Data'!F8+'Report Data'!F9)/1000","v":2025.803454405572},{"$f":"I11/I$13","v":1.4517320587371155E-3},{"$f":"('Report Data'!G8+'Report Data'!G9)/1000","v":1947.2341548842337},{"$f":"K11/K$13","v":1.5289012970146E-3},{"$f":"('Report Data'!H8+'Report Data'!H9)/1000","v":2025.803454405572},{"$f":"M11/M$13","v":1.4517320587371155E-3}]
["Other Operating Revenue",null,{"$f":"'Report Data'!C10/1000","v":17852.952373175118},1.6648718435678417E-2,{"$f":"'Report Data'!D10/1000","v":18822.123944111183},1.6173406884087627E-2,{"$f":"'Report Data'!E10/1000","v":19743.362433562135},{"$f":"G12/G$13","v":1.5501809248973996E-2},{"$f":"'Report Data'!F10/1000","v":21674.310624438906},{"$f":"I12/I$13","v":1.5532252902469868E-2},{"$f":"'Report Data'!G10/1000","v":19743.362433562135},{"$f":"K12/K$13","v":1.5501809248973996E-2},{"$f":"'Report Data'!H10/1000","v":21674.310624438906},{"$f":"M12/M$13","v":1.5532252902469868E-2}]
["Total Operating Revenue",null,{"$f":"'Report Data'!C12/1000","v":1072331.9300611159},{"$f":"C13/C$13","v":1},{"$f":"'Report Data'!D12/1000","v":1163769.8896099327},{"$f":"E13/E$13","v":1},{"$f":"'Report Data'!E12/1000","v":1273616.6544475362},{"$f":"G13/G$13","v":1},{"$f":"'Report Data'!F12/1000","v":1395438.9463354899},{"$f":"I13/I$13","v":1},{"$f":"'Report Data'!G12/1000","v":1273616.6544475362},{"$f":"K13/K$13","v":1},{"$f":"'Report Data'!H12/1000","v":1395438.9463354899},{"$f":"M13/M$13","v":1}]
[]
["Medicare Discount",null,{"$f":"'Report Data'!C14/1000","v":239831.50083882373},{"$f":"C15/C$13","v":0.22365416352486578},{"$f":"'Report Data'!D14/1000","v":273986.48011054931},0.23543011600204136,{"$f":"'Report Data'!E14/1000","v":306525.47381244617},{"$f":"G15/G$13","v":0.24067326125333172},{"$f":"'Report Data'!F14/1000","v":345879.90796419908},{"$f":"I15/I$13","v":0.24786459405658801},{"$f":"'Report Data'!G14/1000","v":306525.47381244617},{"$f":"K15/K$13","v":0.24067326125333172},{"$f":"'Report Data'!H14/1000","v":345879.90796419908},{"$f":"M15/M$13","v":0.24786459405658801}]
["Medicaid Discount",null,{"$f":"'Report Data'!C15/1000","v":65520.292905283255},6.1100757208217261E-2,{"$f":"'Report Data'!D15/1000","v":76359.440579816117},6.5613865130511276E-2,{"$f":"'Report Data'!E15/1000","v":92521.939414152963},7.2645045187703455E-2,{"$f":"'Report Data'!F15/1000","v":112965.70421666915},8.095352685499009E-2,{"$f":"'Report Data'!G15/1000","v":92521.939414152963},7.2645045187703455E-2,{"$f":"'Report Data'!H15/1000","v":112965.70421666915},{"$f":"M16/M$13","v":8.095352685499009E-2}]
["Commercial Discounts",null,{"$f":"'Report Data'!C16/1000","v":126096.61083651769},0.11759102503767747,{"$f":"'Report Data'!D16/1000","v":138247.44680659787},0.11879276826188986,{"$f":"'Report Data'!E16/1000","v":150584.0682287919},0.11823343209508484,{"$f":"'Report Data'!F16/1000","v":163410.12682252782},0.11710302858584609,{"$f":"'Report Data'!G16/1000","v":150584.0682287919},0.11823343209508484,{"$f":"'Report Data'!H16/1000","v":163410.12682252782},0.11710302858584609]
["Charity",null,{"$f":"'Report Data'!C17/1000","v":49773.570410541332},4.6416197275506443E-2,{"$f":"'Report Data'!D17/1000","v":54930.523435290852},4.7200502372253525E-2,{"$f":"'Report Data'!E17/1000","v":61594.377810169084},4.8361787351852134E-2,{"$f":"'Report Data'!F17/1000","v":69170.537104920615},4.9569017180269175E-2,{"$f":"'Report Data'!G17/1000","v":61594.377810169084},4.8361787351852134E-2,{"$f":"'Report Data'!H17/1000","v":69170.537104920615},4.9569017180269175E-2]
["Bad Debt",null,{"$f":"'Report Data'!C18/1000","v":37936.768118565822},3.5377821973839457E-2,{"$f":"'Report Data'!D18/1000","v":41400.062633399677},3.5574096737694398E-2,{"$f":"'Report Data'!E18/1000","v":46169.828069451869},3.6250961314163416E-2,{"$f":"'Report Data'!F18/1000","v":51470.50828855799},3.6884815651535861E-2,{"$f":"'Report Data'!G18/1000","v":46169.828069451869},3.6250961314163416E-2,{"$f":"'Report Data'!H18/1000","v":51470.50828855799},3.6884815651535861E-2]
["Other Deductions",null,{"$f":"'Report Data'!C19/1000","v":28621.336395859904},2.6690743410231827E-2,{"$f":"'Report Data'!D19/1000","v":31321.348496439987},2.69136955476122E-2,{"$f":"'Report Data'!E19/1000","v":34605.99413433361},2.7171436564909592E-2,{"$f":"'Report Data'!F19/1000","v":38179.011820737491},2.7359858287600448E-2,{"$f":"'Report Data'!G19/1000","v":34605.99413433361},2.7171436564909592E-2,{"$f":"'Report Data'!H19/1000","v":38179.011820737491},2.7359858287600448E-2]
["Total Deductions",null,{"$f":"'Report Data'!C20/1000","v":547780.07950559177},0.51083070843033829,{"$f":"'Report Data'!D20/1000","v":616245.30206209386},0.52952504405200262,{"$f":"'Report Data'!E20/1000","v":692001.68146934558},0.54333592376704509,{"$f":"'Report Data'!F20/1000","v":781075.79621761211},0.55973484061682965,{"$f":"'Report Data'!G20/1000","v":692001.68146934558},0.54333592376704509,{"$f":"'Report Data'!H20/1000","v":781075.79621761211},0.55973484061682965]
[]
["Net Revenue",null,{"$f":"'Report Data'!C22/1000","v":524551.85055552411},0.48916929156966171,{"$f":"'Report Data'!D22/1000","v":547524.5875478388},0.47047495594799732,{"$f":"'Report Data'!E22/1000","v":581614.97297819064},{"$f":"G23/G$13","v":0.45666407623295491},{"$f":"'Report Data'!F22/1000","v":614363.15011787764},{"$f":"I23/I$13","v":0.44026515938317029},{"$f":"'Report Data'!G22/1000","v":581614.97297819064},{"$f":"K23/K$13","v":0.45666407623295491},{"$f":"'Report Data'!H22/1000","v":614363.15011787764},{"$f":"M23/M$13","v":0.44026515938317029}]
[]
["Salaries",null,{"$f":"'Report Data'!C24/1000","v":167939.66238730605},0.15661164018284393,{"$f":"'Report Data'!D24/1000","v":175154.61316180875},0.15050622526461507,{"$f":"'Report Data'!E24/1000","v":184621.57915054858},{"$f":"G25/G$13","v":0.14495851519045416},{"$f":"'Report Data'!F24/1000","v":195895.44119392795},{"$f":"I25/I$13","v":0.14038266719469286},{"$f":"'Report Data'!G24/1000","v":184621.57915054858},{"$f":"K25/K$13","v":0.14495851519045416},{"$f":"'Report Data'!H24/1000","v":195895.44119392795},{"$f":"M25/M$13","v":0.14038266719469286}]
["Benefits",null,{"$f":"'Report Data'!C25/1000","v":59636.221861887956},5.5613583993986901E-2,{"$f":"'Report Data'!D25/1000","v":63532.281886774254},5.4591790399448059E-2,{"$f":"'Report Data'!E25/1000","v":68042.636515920138},5.3424738345177629E-2,{"$f":"'Report Data'!F25/1000","v":72582.493830562293},5.2014094934908092E-2,{"$f":"'Report Data'!G25/1000","v":68042.636515920138},5.3424738345177629E-2,{"$f":"'Report Data'!H25/1000","v":72582.493830562293},5.2014094934908092E-2]
["Total Fees",null,{"$f":"'Report Data'!C26/1000","v":16662.395923597112},1.5538468506339697E-2,{"$f":"'Report Data'!D26/1000","v":16991.675778621509},1.460054597590311E-2,{"$f":"'Report Data'!E26/1000","v":17611.99777012067},1.3828335008511902E-2,{"$f":"'Report Data'!F26/1000","v":18328.732103500508},1.3134743122680434E-2,{"$f":"'Report Data'!G26/1000","v":17611.99777012067},1.3828335008511902E-2,{"$f":"'Report Data'!H26/1000","v":18328.732103500508},1.3134743122680434E-2]
["Total Supplies",null,{"$f":"'Report Data'!C27/1000","v":93907.634193898673},8.7573289166673007E-2,{"$f":"'Report Data'!D27/1000","v":98933.663668707421},8.5011362256388653E-2,{"$f":"'Report Data'!E27/1000","v":106319.04282959299},8.3478056335335532E-2,{"$f":"'Report Data'!F27/1000","v":114683.32008757212},8.2184405407873778E-2,{"$f":"'Report Data'!G27/1000","v":106319.04282959299},8.3478056335335532E-2,{"$f":"'Report Data'!H27/1000","v":114683.32008757212},8.2184405407873778E-2]
["Other Purchased Services",null,{"$f":"'Report Data'!C28/1000","v":16163.940891894867},1.5073635726741466E-2,{"$f":"'Report Data'!D28/1000","v":16245.696166741025},1.3959543301284575E-2,{"$f":"'Report Data'!E28/1000","v":16632.67155983406},1.3059401745220509E-2,{"$f":"'Report Data'!F28/1000","v":17030.250789383361},1.2204224938759139E-2,{"$f":"'Report Data'!G28/1000","v":16632.67155983406},1.3059401745220509E-2,{"$f":"'Report Data'!H28/1000","v":17030.250789383361},1.2204224938759139E-2]
["All Other Expenses",null,{"$f":"'Report Data'!C29/1000","v":27138.313218133837},2.5307754490335031E-2,{"$f":"'Report Data'!D29/1000","v":28632.765765363092},2.4603459860058845E-2,{"$f":"'Report Data'!E29/1000","v":29260.504434648516},2.2974341873176124E-2,{"$f":"'Report Data'!F29/1000","v":29672.269655986547},2.1263753411718791E-2,{"$f":"'Report Data'!G29/1000","v":29260.504434648516},2.2974341873176124E-2,{"$f":"'Report Data'!H29/1000","v":29672.269655986547},2.1263753411718791E-2]
["Interest",null,{"$f":"'Report Data'!C33/1000","v":9919.4840000000004},9.2503857452371618E-3,{"$f":"'Report Data'!D33/1000","v":10231.104679948226},8.7913467871019099E-3,{"$f":"'Report Data'!E33/1000","v":10721.683723213329},8.4182973626896664E-3,{"$f":"'Report Data'!F33/1000","v":12242.221415270691},8.7730254680217518E-3,{"$f":"'Report Data'!G33/1000","v":10721.683723213329},{"$f":"K31/K$13","v":8.4182973626896664E-3},{"$f":"'Report Data'!H33/1000","v":12242.221415270691},{"$f":"M31/M$13","v":8.7730254680217518E-3}]
["Depreciation",null,{"$f":"'Report Data'!C34/1000","v":27176.497825826602},2.534336343437775E-2,{"$f":"'Report Data'!D34/1000","v":26280.861666666664},2.2582524175355119E-2,{"$f":"'Report Data'!E34/1000","v":26967.395095238098},2.1173871275211847E-2,{"$f":"'Report Data'!F34/1000","v":29122.398333333334},2.086970441079531E-2,{"$f":"'Report Data'!G34/1000","v":26967.395095238098},{"$f":"K32/K$13","v":2.1173871275211847E-2},{"$f":"'Report Data'!H34/1000","v":29122.398333333334},{"$f":"M32/M$13","v":2.086970441079531E-2}]
["Corporate Charge",null,{"$f":"'Report Data'!C35/1000","v":55969.450087628495},5.2194146717647959E-2,{"$f":"'Report Data'!D35/1000","v":58634.879384333246},5.0383568012733367E-2,{"$f":"'Report Data'!E35/1000","v":62900.294081733693},4.9387147900494678E-2,{"$f":"'Report Data'!F35/1000","v":66796.609842226884},4.7867812502753321E-2,{"$f":"'Report Data'!G35/1000","v":62900.294081733693},{"$f":"K33/K$13","v":4.9387147900494678E-2},{"$f":"'Report Data'!H35/1000","v":66796.609842226884},4.7867812502753321E-2]
["Total Expenses",null,{"$f":"'Report Data'!C37/1000","v":474513.60039017361},0.44250626796418291,{"$f":"'Report Data'!D37/1000","v":494637.54215896421},0.42503036603288874,{"$f":"'Report Data'!E37/1000","v":523077.80516085005},0.41070270503627204,{"$f":"'Report Data'!F37/1000","v":556353.73725176358},0.3986944313922034,{"$f":"'Report Data'!G37/1000","v":523077.80516085005},{"$f":"K34/K$13","v":0.41070270503627204},{"$f":"'Report Data'!H37/1000","v":556353.73725176358},0.3986944313922034]
[]
["Net Operating Income",null,{"$f":"'Report Data'!C39/1000","v":50038.250165350495},{"$f":"C36/C$13","v":4.6663023605478804E-2},{"$f":"'Report Data'!D39/1000","v":52887.045388874591},4.5444589915108594E-2,{"$f":"'Report Data'!E39/1000","v":58537.167817340611},{"$f":"G36/G$13","v":4.5961371196682886E-2},{"$f":"'Report Data'!F39/1000","v":58009.41286611402},{"$f":"I36/I$13","v":4.1570727990966838E-2},{"$f":"'Report Data'!G39/1000","v":58537.167817340611},{"$f":"K36/K$13","v":4.5961371196682886E-2},{"$f":"'Report Data'!H39/1000","v":58009.41286611402},{"$f":"M36/M$13","v":4.1570727990966838E-2}]
[]
["EBIDA",null,{"$f":"'Report Data'!C31/1000","v":87134.23199117709},{"$f":"C38/C$13","v":8.1256772785093703E-2},{"$f":"'Report Data'!D31/1000","v":89399.01173548949},{"$f":"E38/E$13","v":7.6818460877565636E-2},{"$f":"'Report Data'!E31/1000","v":96226.246635792049},{"$f":"G38/G$13","v":7.5553539834584404E-2},{"$f":"'Report Data'!F31/1000","v":99374.032614718046},{"$f":"I38/I$13","v":7.1213457869783905E-2},{"$f":"'Report Data'!G31/1000","v":96226.246635792049},{"$f":"K38/K$13","v":7.5553539834584404E-2},{"$f":"'Report Data'!H31/1000","v":99374.032614718046},{"$f":"M38/M$13","v":7.1213457869783905E-2}]
[]
["FTE's",null,{"$f":"'Report Data'!C52","v":2700.1805877807465},null,{"$f":"'Report Data'!D52","v":2725.949166958917},null,{"$f":"'Report Data'!E52","v":2768.2886493956426},null,{"$f":"'Report Data'!F52","v":2813.1710674238484},null,{"$f":"'Report Data'!G52","v":2768.2886493956426},null,{"$f":"'Report Data'!H52","v":2813.1710674238484}]
[]
["Key Indicators"]
["Admissions",null,{"$f":"'Report Data'!C41","v":24530},null,{"$f":"'Report Data'!D41","v":24852.090000000004},null,{"$f":"'Report Data'!E41","v":25297.951449999997},null,{"$f":"'Report Data'!F41","v":25792.7329235},null,{"$f":"'Report Data'!G41","v":25297.951449999997},null,{"$f":"'Report Data'!H41","v":25792.7329235}]
["Patient Days",null,{"$f":"'Report Data'!C42","v":88633.779438292244},null,{"$f":"'Report Data'!D42","v":89642.993920572771},null,{"$f":"'Report Data'!E42","v":91203.865125662705},null,{"$f":"'Report Data'!F42","v":92917.712306754605},null,{"$f":"'Report Data'!G42","v":91203.865125662705},null,{"$f":"'Report Data'!H42","v":92917.712306754605}]
["Surgeries",null,{"$f":"'Report Data'!C43+'Report Data'!C44","v":25009},null,{"$f":"'Report Data'!D43+'Report Data'!D44","v":25375.2425},null,{"$f":"'Report Data'!E43+'Report Data'!E44","v":25779.152637499996},null,{"$f":"'Report Data'!F43+'Report Data'!F44","v":26238.747053249997},null,{"$f":"'Report Data'!G43+'Report Data'!G44","v":25779.152637499996},null,{"$f":"'Report Data'!H43+'Report Data'!H44","v":26238.747053249997}]
["ER Visits",null,{"$f":"'Report Data'!C45+'Report Data'!C46","v":91207},null,{"$f":"'Report Data'!D45+'Report Data'!D46","v":92675.384999999995},null,{"$f":"'Report Data'!E45+'Report Data'!E46","v":95141.162049999999},null,{"$f":"'Report Data'!F45+'Report Data'!F46","v":97688.390449999992},null,{"$f":"'Report Data'!G45+'Report Data'!G46","v":95141.162049999999},null,{"$f":"'Report Data'!H45+'Report Data'!H46","v":97688.390449999992}]
["Imaging Procedures",null,{"$f":"'Report Data'!C47","v":192161},null,{"$f":"'Report Data'!D47","v":199606.44},null,{"$f":"'Report Data'!E47","v":207392.19760000001},null,{"$f":"'Report Data'!F47","v":214991.04859200001},null,{"$f":"'Report Data'!G47","v":207392.19760000001},null,{"$f":"'Report Data'!H47","v":214991.04859200001}]
["Cardiovascular Procedures",null,{"$f":"'Report Data'!C48","v":61361},null,{"$f":"'Report Data'!D48","v":63512.73},null,{"$f":"'Report Data'!E48","v":65784.591899999999},null,{"$f":"'Report Data'!F48","v":67819.954599000004},null,{"$f":"'Report Data'!G48","v":65784.591899999999},null,{"$f":"'Report Data'!H48","v":67819.954599000004}]

{"sheet":"CashFlow","index":11,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[2,0,2,10],[3,0,3,10]]}
[{"$f":"'Final Report'!A1:L1","v":"Alta View Hospital"}]
["Statement of Cash Flows"]
[{"$f":"'Final Report'!A3:L3","v":"2012-04-11"}]
[{"$f":"'Final Report'!A4:L4","v":"(in thousands)"}]
[]
[null,null,{"$f":"'Final Report'!C7","v":"2011"},null,{"$f":"'Final Report'!E7","v":"2012"},null,{"$f":"'Final Report'!G7","v":"2013"},null,{"$f":"'Final Report'!I7","v":"2014"},null,{"$f":"'Final Report'!K7","v":"2015"},null,{"$f":"'Final Report'!M7","v":"2016"}]
["Net Operating Income",null,{"$f":"'Final Report'!C36","v":50038.250165350495},null,{"$f":"'Final Report'!E36","v":52887.045388874591},null,{"$f":"'Final Report'!G36","v":58537.167817340611},null,{"$f":"'Final Report'!I36","v":58009.41286611402},null,{"$f":"'Final Report'!K36","v":58537.167817340611},null,{"$f":"'Final Report'!M36","v":58009.41286611402}]
[]
[{"$f":"\"+ Depreciation\"","v":"+ Depreciation"},null,{"$f":"'Final Report'!C32","v":27176.497825826602},null,{"$f":"'Final Report'!E32","v":26280.861666666664},null,{"$f":"'Final Report'!G32","v":26967.395095238098},null,{"$f":"'Final Report'!I32","v":29122.398333333334},null,{"$f":"'Final Report'!K32","v":26967.395095238098},null,{"$f":"'Final Report'!M32","v":29122.398333333334}]
[{"$f":"\"- Capital Expenditures\"","v":"- Capital Expenditures"},null,{"$f":"-'Report Data'!C50/1000","v":0},null,{"$f":"-'Report Data'!D50/1000","v":0},null,{"$f":"-'Report Data'!E50/1000","v":0},null,{"$f":"-'Report Data'!F50/1000","v":0},null,{"$f":"-'Report Data'!G50/1000","v":0},null,{"$f":"-'Report Data'!I50/1000","v":0}]
["Change in Working Capital",null,{"$f":"-(('Report Data'!C12-'Report Data'!B12)*0.07)/1000","v":-75063.235104278123},null,{"$f":"-0.07*('Final Report'!E13-'Final Report'!C13)","v":-6400.6571684171759},null,{"$f":"-0.07*('Final Report'!G13-'Final Report'!E13)","v":-7689.2735386322493},null,{"$f":"-0.07*('Final Report'!I13-'Final Report'!G13)","v":-8527.5604321567553},null,{"$f":"-0.07*('Final Report'!K13-'Final Report'!I13)","v":8527.5604321567553},null,{"$f":"-0.07*('Final Report'!M13-'Final Report'!K13)","v":-8527.5604321567553}]
[]
["Cash Flow",null,{"$f":"SUM(C7:C11)","v":2151.5128868989705},null,{"$f":"SUM(E7:E11)","v":72767.249887124082},null,{"$f":"SUM(G7:G11)","v":77815.289373946463},null,{"$f":"SUM(I7:I11)","v":78604.250767290607},null,{"$f":"SUM(K7:K11)","v":94032.123344735461},null,{"$f":"SUM(M7:M11)","v":78604.250767290607}]
[]
["Discounted Cash Flow @10%",null,{"$f":"C13","v":2151.5128868989705},null,{"$f":"E13/(1.1^(E6-$C$6))","v":66152.045351930981},null,{"$f":"G13/(1.1^(G6-$C$6))","v":64310.15650739376},null,{"$f":"I13/(1.1^(I6-$C$6))","v":59056.537015244612},null,{"$f":"K13/(1.1^(K6-$C$6))","v":64225.205481002275},null,{"$f":"M13/(1.1^(M6-$C$6))","v":48807.055384499683}]

{"sheet":"Lookup","index":12,"n_rows":102,"n_cols":5,"rows_kept":102,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,null,null,4]
[]
["IHCE","IHC - Eliminations",1,"UNBASE","Uninflated Baseline"]
["010","Parent Company",2,"INBASE","Inflated Baseline"]
["710","IHC Management Company",3,"Uninfl","Productivity Adjusted Uninflated "]
["810","Healthcare Captive Insurance Co.",4,"Inflated","Productivity Adjusted Inflated"]
["910","IHC Foundation, Inc.",5,"Actual","Actual"]
["610","SelectHealth, Inc.",6,"UF10","Uninflated Final - 2010"]
["611","IHC Care, Inc.",7,"IF10","Inflated Final - 2010"]
["612","IHC Insurance Agency"]
["613","IHC Group, Inc."]
["614","SelectHealth Benefit Assurance Company, Inc."]
["HPLANS","IHC Health Plans, Inc"]
["310","PSI Administration"]
["311","Affiliated Services, Inc"]
["333","Heritage Schools - IHC"]
["PSI","IHC Professional Services, Inc"]
["OTHENT","Other Non-Hospital Entities"]
["107","A/R Management"]
["109","Intermountain Homecare"]
["109HH2","Home Health and Private Duty - 109"]
["HMESTO","HME Stores - 109"]
["109HSP","Hospice Free-Standing - 109"]
["109AAA","IV Therapy -  109"]
["109B00","Other - 109"]
["653109","Home Med Equip - HME-Wheelchair/PT - 109"]
["113","Supply Chain Organization"]
["153","Intermountain Central Laboratory"]
["116","Alta View Hospital"]
["124","Cottonwood Hospital Medical Center"]
["128","LDS Hospital"]
["363","Avenues Surgical Center"]
["TLDS","Total LDS/Avenues Surgical"]
["139","Riverton Hospital"]
["154","Intermountain Medical Center"]
["270","Rehabilitation Services"]
["370","Orthopedic Specialty Hospital"]
["161","Wasatch Canyons Hospital"]
["163","IHC Counseling Services"]
["UCR","Urban Central Region Hospitals"]
["138","Primary Children's Medical Center"]
["375","Primary Children's - Riverton"]
["138","Primary Children's Medical Center"]
["375","Primary Children's - Riverton"]
["PCR","Primary Children's Region"]
["120","Bear River Valley Hospital"]
["130","Logan Regional Hospital"]
["367","Logan Surgical Center"]
["TLOGAN","Total Logan/Logan Surgical"]
["132","McKay-Dee Hospital Center"]
["364","McKay-Dee Surgical Center, LLC"]
["366","McKay-Dee Surgical Center"]
["TMCKAY","Total McKay-Dee Hospital Center"]
["UNR","Urban North Region Hospitals"]
["118","American Fork Hospital"]
["134","Orem Community Hospital"]
["144","Utah Valley Regional Medical Center"]
["USR","Urban South Region Hospitals"]
["126","Dixie Regional Medical Center"]
["146","Valley View Medical Center"]
["SWR","Southwest Region"]
["122","Cassia Regional Medical Center"]
["125","Delta Community Medical Center"]
["127","Fillmore Community Hospital"]
["140","Sanpete Valley Hospital"]
["142","Sevier Valley Medical Center"]
["143","Park City Medical Center"]
["365","Park City Surgical Center"]
["TPM","Total Park City Medical Center"]
["148","Heber Valley Medical Center"]
["RUR","Rural Region"]
["136","Pocatello Regional Medical Center"]
["150","Evanston Regional Hospital"]
["152","Garfield Memorial Hospital & Clinics"]
["182","Garfield Memorial Hospital"]
["188","Millard County Care Center"]
["THOSP","Hospital Entities"]
["VOLCO","Volume Adjusting Entities"]
["100","Corporate Treasury"]
["103","Self Insurance Program"]
["105","Employee Benefit Program"]
["110","Central Office"]
["111","Window"]
["112","Lost Creek LLC"]
["114","Information Technology"]
["312","5300 South Center, LLC"]
["313","5245 College Drive LLC"]
["400","Intermountain Medical Group"]
["420","Medical Group Contingency"]
["620","Utah Community Health Plans"]
["730","Research Admin/Sponsored Projects"]
["740","Federal Grants"]
["750","IHC Intellectual Asset Management (IAM)"]
["NONH","Non-Hospital Entities"]
["IHCHNE","IHCHS - No Eliminations"]
["IHCHE","IHCHS - Eliminations"]
["IHCH","IHC Health Services, Inc"]
["IHC","Intermountain Healthcare, Inc"]

{"sheet":"New","index":13,"n_rows":94,"n_cols":9,"rows_kept":94,"cut":false,"hidden":true,"merged":[]}
[null,null,"Working"]
[null,null,"V"]
[null,null,"M"]
[null,null,"FY11"]
[null,null,"UNBASE"]
[null,null,"Jan"]
[null,null,"IHC",null,null,null,"New/Not Old","Old/Not New"]
["CAPEX","Capital Expenditures","0","CAPEX",null,null,"Minor Equipment - $2000 to $5000","NMSUP"]
["BDEBT","Tot Bad Debt","0","BDEBT",null,null,"Tot Non Operating Revenue","NOI%",{"$f":"VLOOKUP(H9,Old!$A$5:$B$72,2,FALSE)","v":"NOI%"}]
["CHAR","Tot Charity","0","CHAR",null,null,"Net Operating Income","EBIDA",{"$f":"VLOOKUP(H10,Old!$A$5:$B$72,2,FALSE)","v":"EBIDA"}]
["CONT","Contracted Payers","0","CONT",null,null,"Provider Work RVUs","PHYE",{"$f":"VLOOKUP(H11,Old!$A$5:$B$72,2,FALSE)","v":"Total Physician FTES"}]
["NCONT","Other Non Contracted Payers","0","NCONT",null,null,"IP Base Flexing Stat"]
["SH","SelectHealth","0","SELECTH",null,null,"OP Base Flexing Stat"]
["ODED","Tot Other Deductions","0","ODED",null,null,"Other Possible Base Stat 2"]
["UNINS","Uninsured/Other","0","UNINS",null,null,"Reg, Educ & Orien- Hrs : Management"]
["MCAID","Tot Medicaid C/A","0","MCARE",null,null,"Reg, Educ & Orien- Hrs : Prof Clin"]
["MCARE","Tot Medicare C/A","0","MCAID",null,null,"Reg, Educ & Orien- Hrs : RN"]
["OOR","Tot Other Operating Rev","0","OOR",null,null,"Reg, Educ & Orien- Hrs : LPN"]
["AOIPR","All Other IP Revenue","0","AOIP",null,null,"Reg, Educ & Orien- Hrs : Aides Order"]
["ICUR","Plan IP Intensive Care Revenue","0","ICU",null,null,"Reg, Educ & Orien- Hrs : Med Prac"]
["NICR","Plan IP Newborn Intensive Care Revenue","0","NIC",null,null,"Reg, Educ & Orien- Hrs : Students"]
["ONSR","Plan Other Nursing Revenue","0","ONS",null,null,"Reg, Educ & Orien- Hrs : Tech/Prof Non-Cl"]
["PEDR","Plan IP Pediatric Revenue","0","PED",null,null,"Reg, Educ & Orien- Hrs : IT Prof - Non-Cl"]
["WNOR","Womens/Nursery/Obstetrics Revenue","0","WNO",null,null,"Reg, Educ & Orien- Hrs : Technicians Clin"]
["LTREV","Tot Geriatrics Revenue","0","LTREV",null,null,"Reg, Educ & Orien- Hrs : Mod Duty"]
["AOOPR","All Other OP Revenue","0","AOOP",null,null,"Reg, Educ & Orien- Hrs : Trades/Spec Non-Clin"]
["CVSR","Plan OP Cardiovascular Revenue","0","CVS",null,null,"Reg, Educ & Orien- Hrs : Transfer"]
["EDR","Plan OP Emergency Department Revenue","0","EDR",null,null,"Reg, Educ & Orien- Hrs : Gen Off/Maint"]
["IMGR","Plan OP Imaging Revenue","0","IMG",null,null,"Reg, Educ & Orien- Hrs : Nurse Nwrk"]
["SURR","Plan OP Surgery Revenue","0","SUR",null,null,"Reg, Educ & Orien- Hrs : Nurse Out"]
["SVREV","Tot Other Service Revenue","0","SVREV",null,null,"Reg, Educ & Orien- Hrs : Other Out"]
["OBEN","All Other Benefits (Including FICA)","0","OBEN"]
["RET","Retirement Benefit","0","RET"]
["PHY","Tot Physician Salaries","0","PHY"]
["TSAL","Total Staff Salaries","0","TSAL"]
["TFEE","Tot Prof Fees","0","TFEE"]
["MSUP","Tot Med/Surg Supplies","0","MSUP"]
["4182","Minor Equipment - $2000 to $5000","0"]
["TOPS","Tot Util & Purchased Svc","0","TOPS"]
["4472","Corporate Charge - Intrmtn","0","4472"]
["MEXP","Total Medical Expense","0","MEXP"]
["OEXP","Total Other Expense","0","OEXP"]
["TCENT","Central Services Transfer","0","TCENT"]
["TINS","Insurance Transfers","0","TINS"]
["TREIM","Transfers-Reimbursed","0","TREIM"]
["DEP","Tot Deprec & Amortization","0","DEP"]
["INT","Tot Interest","0","INT"]
["4471","Corporate Charge - Health Svcs","0","4471"]
["4474","System Integration Charge","0","4474"]
["4475","Corp Data Process Chg","0","4475","4477"]
["NONOP","Tot Non Operating Revenue","0",null,"NOI%"]
["EBIDA%","EBIDA%","0","EBIDA%","EBIDA"]
["NOI","Net Operating Income","0"]
["9160","Provider Work RVUs","0"]
["IBASE","IP Base Flexing Stat","0",null,"PHYE"]
["OBASE","OP Base Flexing Stat","0"]
["OBAS2","Other Possible Base Stat 2","0"]
["PROEPLN","Productive FTEs PLN","0"]
["9146PLN","IP Cases - Adm PLN","0","9146"]
["9209PLN","IP ER Visits PLN","0","9209"]
["9011AOIP","All Other Inpatient Acute Admissions","0","9011AOIP"]
["9011ICU","ICU Acute Admissions","0","9011ICU"]
["9011NIC","NICU Acute Admissions","0","9011NIC"]
["9011ONS","Other Nursing Acute Admissions","0","9011ONS"]
["9011PED","Pediatric Acute Admissions","0","9011PED"]
["9011WNO","Womens/Obstetric Acute Admissions","0","9011WNO"]
["9001AOIP","All Other Inpatient Acute Patient Days","0","9001AOIP"]
["9001ICU","ICU Acute Patient Days","0","9001ICU"]
["9001NIC","NICU Acute Patient Days","0","9001NIC"]
["9001ONS","Other Nursing Acute Patient Days","0","9001ONS"]
["9001PED","Pediatric Acute Patient Days","0","9001PED"]
["9001WNO","Womens/Obstetric Acute Patient Days","0","9001WNO"]
["9031PLN","Total OP Surgeries PLN","0","9031"]
["9308CVS","OP Cardiovascular Procedures","0","9308CVS"]
["9308IMG","OP Imaging Procedures","0","9308IMG","Accounts"]
["9309PLN","OP ER Visits PLN","0","9309"]
["4003H.01","Reg, Educ & Orien- Hrs : Management","0"]
["4004H.01","Reg, Educ & Orien- Hrs : Prof Clin","0"]
["4005H.01","Reg, Educ & Orien- Hrs : RN","0"]
["4006H.01","Reg, Educ & Orien- Hrs : LPN","0"]
["4007H.01","Reg, Educ & Orien- Hrs : Aides Order","0"]
["4009H.01","Reg, Educ & Orien- Hrs : Med Prac","0"]
["4010H.01","Reg, Educ & Orien- Hrs : Students","0"]
["4014H.01","Reg, Educ & Orien- Hrs : Tech/Prof Non-Cl","0"]
["4015H.01","Reg, Educ & Orien- Hrs : IT Prof - Non-Cl","0"]
["4016H.01","Reg, Educ & Orien- Hrs : Technicians Clin","0"]
["4023H.01","Reg, Educ & Orien- Hrs : Mod Duty","0"]
["4024H.01","Reg, Educ & Orien- Hrs : Trades/Spec Non-Clin","0"]
["4027H.01","Reg, Educ & Orien- Hrs : Transfer","0"]
["4029H.01","Reg, Educ & Orien- Hrs : Gen Off/Maint","0"]
["4026H.01","Reg, Educ & Orien- Hrs : Nurse Nwrk","0"]
["4070H.01","Reg, Educ & Orien- Hrs : Nurse Out","0"]
["4071H.01","Reg, Educ & Orien- Hrs : Other Out","0"]
["Account","Account","0"]

{"sheet":"Old","index":14,"n_rows":72,"n_cols":3,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[null,null,"V"]
[null,null,"2011"]
[null,null,"UNBASE"]
[null,null,"IHC"]
["ICU","Intensive Care Unit Revenue"]
["NIC","Newborn Intensive Care Revenue"]
["ONS","Other Nursing Services Revenue"]
["PED","Pediatric Revenue"]
["WNO","Womens/Nursery/Obstetrics Revenue"]
["AOIP","All Other IP Revenue"]
["CVS","OP Cardiovascular Revenue"]
["EDR","OP Emergency Department Revenue"]
["IMG","OP Imaging Revenue"]
["SUR","OP Surgery Revenue"]
["AOOP","All Other OP Revenue"]
["SVREV","Tot Other Service Revenue"]
["LTREV","Tot Geriatrics Revenue"]
["OOR","Tot Other Operating Rev"]
["MCARE","Tot Medicare C/A"]
["MCAID","Tot Medicaid C/A"]
["SELECTH","SelectHealth"]
["CONT","Contracted Payers"]
["NCONT","Other Non Contracted Payers"]
["UNINS","Uninsured/Other"]
["BDEBT","Tot Bad Debt"]
["CHAR","Uninsured"]
["ODED","Tot Other Deductions"]
["TSAL","Total Staff Salaries"]
["PHY","Tot Physician Salaries"]
["RET","Retirement Benefit"]
["OBEN","All Other Benefits (Including FICA)"]
["TFEE","Tot Prof Fees"]
["MSUP","Tot Med/Surg Supplies"]
["NMSUP","Tot Non-Med/Surg Supplies"]
["TOPS","Tot Util & Purchased Svc"]
["TREIM","Transfers-Reimbursed"]
["TCENT","Central Services Transfer"]
["TINS","Insurance Transfers"]
["OEXP","Other Expenses"]
["MEXP","Total Medical Expense"]
["4472","Central Charge- IHC"]
["INT","Tot Interest"]
["DEP","Tot Deprec & Amortization"]
["4471","Corp Charge-IHCH"]
["4474","System Integration Charge"]
["4475","Corp Data Process Chg"]
["4477","Revenue Cycle Charge"]
["NOI%","NOI%"]
["EBIDA","EBIDA"]
["EBIDA%","EBIDA%"]
["PROE","Productive FTES"]
["PHYE","Total Physician FTES"]
["9031","Total OP Surgeries"]
["9308CVS","OP Cardiovascular Procedures"]
["9308IMG","OP Imaging Procedures"]
["9309","OP ER Visits"]
["9011AOIP","All Other Inpatient Acute Admissions"]
["9011ICU","ICU Acute Admissions"]
["9011NIC","NICU Acute Admissions"]
["9011ONS","Other Nursing Acute Admissions"]
["9011PED","Pediatric Acute Admissions"]
["9011WNO","Womens/Obstetic Acute Admissions"]
["9001AOIP","All Other Inpatient Acute Patient Days"]
["9001ICU","ICU Acute Patient Days"]
["9001NIC","NICU Acute Patient Days"]
["9001ONS","Other Nursing Acute Patient Days"]
["9001PED","Pediatric Acute Patient Days"]
["9001WNO","Womens/Obstetric Acute Patient Days"]
["9146","IP Surgery Cases"]
["9209","IP ER Visits"]
["CAPEX","Capital Expenditures"]
["Accounts","Accounts"]

{"sheet":"Sheet1","index":15,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[null,"V"]
[null,"Y"]
[null,"2010"]
[null,"Actual"]
[null,"Jun"]
[null,"IHC"]
["4005","0"]