{"text_format":"1","workbook":"xlsx","n_sheets":25,"sheets":["Calculator","Control","MCCALCS","1.START","2.Flow","3.Population Data","4.Costs","5.Additional Utilizations","6.Medical Utilization","7.Revenue Enhancements","8a.Summary","8b.Scenario Comparison","9a.Monte Carlo Analysis","9b.MC-ROI","9c.MC-Net Benefit PMPM","Sheet6","9d.Sensitivity Analysis","9d.Visit Sensitivity","9e.Cost Sensitivity","9f.Visit Reduction Sensitivity","Scenarios","Scen Meta","Sheet1","Report ","SACALCS"],"not_rendered":{"charts":10,"images":17,"macros":1,"external_links":0,"defined_names":106,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"9b.MC-ROI","index":13,"reason":"not_a_worksheet"},{"sheet":"9c.MC-Net Benefit PMPM","index":14,"reason":"not_a_worksheet"},{"sheet":"9d.Visit Sensitivity","index":17,"reason":"not_a_worksheet"},{"sheet":"9e.Cost Sensitivity","index":18,"reason":"not_a_worksheet"},{"sheet":"9f.Visit Reduction Sensitivity","index":19,"reason":"not_a_worksheet"}],"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":"Calculator","index":0,"n_rows":101,"n_cols":23,"rows_kept":101,"cut":false,"hidden":true,"merged":[[74,6,75,6],[71,2,71,3],[0,0,0,3],[46,1,46,3],[54,1,54,3],[74,2,74,3],[97,3,97,5],[74,4,75,4],[74,5,75,5]]}
["PCC CALCULATOR and SCENARIO SIMULATOR",null,null,null,null,null,null,"Move Population and levels to top"]
[null,null,null,null,null,null,null,"Minumum Population to start"]
[null,null,null,null,null,null,null,"ADD Semi fixed costs thresholds"]
[null,null,null,null,null,null,null,"Add Admin; Direct Equipment and supply; indirect; misc."]
[null,null,null,null,null,null,null,"New section for variable labor"]
[null,null,null,null,null,null,null,"Launch Expenses:"]
[null,null,null,null,null,null,null,"Payback period calculation"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Select Years of Op"]
[null,null,null,null,null,null,null,"Launch Cost",1,2,3,4,5]
[null,null,null,null,null,null,null,-100000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"ADD Increased utilization of services on PMPM or step function"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(O25,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,{"$f":"IF(O26,1,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,0]
[]
[]
[]
[]
[]
[]
[]
["Monthly Program Costs",null,{"$f":"'3.Population Data'!B5","v":"Level 1"},{"$f":"'3.Population Data'!B6  &\" Incremental\"","v":"Level 2 Incremental"},"All Groups",null,"Level one only"]
["Eligible members",null,null,null,null,null,"add total offerd to number"]
[null,null,100]
["Total cost with no CPO's ",null,{"$f":"'4.Costs'!E44+'3.Population Data'!E5*'4.Costs'!D61","v":20168.385416666668},{"$f":"E41-C41","v":20019.999999999996},{"$f":"'4.Costs'!E44+('3.Population Data'!E5+'3.Population Data'!E6)*'4.Costs'!D61","v":40188.385416666664}]
["PMPM Costs with No CPO's",null,{"$f":"C41/'3.Population Data'!E5","v":100.84192708333335},{"$f":"D41/'3.Population Data'!E6","v":100.09999999999998},{"$f":"E41/'3.Population Data'!#REF!","v":{"$error":"#REF!"}}]
["Total cost with all selected CPO's",null,{"$f":"C41+'3.Population Data'!E5*SUMPRODUCT('7.Revenue Enhancements'!C4:C9,P25:P30)","v":20168.385416666668},{"$f":"E43-C43","v":20019.999999999996},{"$f":"E41+('3.Population Data'!E5+'3.Population Data'!E6)*SUMPRODUCT('7.Revenue Enhancements'!C4:C9,P25:P30)","v":40188.385416666664}]
["PMPM Costs with all selected CPO's",null,{"$f":"C43/'3.Population Data'!E5","v":100.84192708333335},{"$f":"D43/'3.Population Data'!E6","v":100.09999999999998},{"$f":"E43/'3.Population Data'!#REF!","v":{"$error":"#REF!"}}]
[]
["Events and Costs"]
[null,"Baseline Events PMPM"]
["Events","Total Population",{"$f":"+'3.Population Data'!B5","v":"Level 1"},{"$f":"'3.Population Data'!B6","v":"Level 2"},null,null,null,"Need increased existing utilization areas"]
["Emergency Room Visits",0.16666666666666666,0.5,0.5,null,null,null,"New services by level"]
["Admittance",0.33333333333333331,0.3,0.3]
["Re-Admittance",8.3333333333333329E-2,0.4,0.4]
["Specialist Encounters",8.3333333333333329E-2,0.2,0.2,null,null,null,"Payment types radio buttons turn of irrelevant sections"]
["Other",8.3333333333333329E-2,0.25,0.25,null,null,null,"Full Risk"]
[null,null,null,null,null,null,null,"Shared savings"]
[null,"Cost Per Event","Average Cost per Event",null,null,null,null,"FFS"]
["Cost Per Event",{"$f":"B48","v":"Total Population"},{"$f":"C48","v":"Level 1"},"Level 2"]
[{"$f":"A49","v":"Emergency Room Visits"},500,500,500,null,null,null,"Risk exposure:"]
[{"$f":"A50","v":"Admittance"},10000,10000,10000,null,null,null,"Health plan"]
["Re-admittance",8000,8000,8000,null,null,null,"Hospital"]
["Specialist Encounters",200,200,200]
[{"$f":"A53","v":"Other"},250,250,250,null,null,null,"NEW REVENUE"]
[null,null,null,null,null,null,null,"PMPM  Stipend:"]
["Total Costs PMPM",null,null,null,null,null,null,"Medicare new codes for PCC services"]
[{"$f":"A49","v":"Emergency Room Visits"},{"$f":"B57*B49","v":83.333333333333329},250,250,null,null,null,null,"Nurses, social work for patient transitions"]
[{"$f":"A50","v":"Admittance"},3333.333333333333,3000,3000]
[{"$f":"A59","v":"Re-admittance"},{"$f":"B59*B51","v":666.66666666666663},3200,3200]
[{"$f":"A60","v":"Specialist Encounters"},{"$f":"B60*B52","v":16.666666666666664},40,40]
[{"$f":"A53","v":"Other"},{"$f":"B61*B53","v":20.833333333333332},62.5,62.5]
["Total PMPM Costs",{"$f":"SUM(B64:B68)","v":4120.833333333333},{"$f":"SUM(C64:C68)","v":6552.5},{"$f":"SUM(D64:D68)","v":6552.5}]
[]
[]
["Utilization Cost Avoidance per Month",null,"Depth of Program "]
[null,null,"Level 1","Level 1 and 2"]
[]
["Events",null,"Reduction Slider (0-40%)",null,"Percent Reduction","Events Reduced","Cost Avoided PMPM",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,"  0……………………………….…………..40%"]
[{"$f":"A64","v":"Emergency Room Visits"},"Level 1",null,null,null,null,{"$f":"+'6.Medical Utilization'!P4*C64","v":50},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,"Level 2",null,null,null,null,{"$f":"IF(W75=2,'6.Medical Utilization'!W4*D64,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8]
[{"$f":"A65","v":"Admittance"},"Level 1",null,null,{"$f":"W79/100","v":0.15},{"$f":"E79*C50","v":4.4999999999999998E-2},{"$f":"+E79*C65","v":450},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,"Level 2",null,null,0.09,{"$f":"IF(W75=2,E80*D50,0)","v":2.7E-2},{"$f":"IF(W75=2,E80*D65,0)","v":270},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[{"$f":"A59","v":"Re-admittance"},"Level 1",null,null,0.14000000000000001,{"$f":"+C51*E81","v":5.6000000000000008E-2},{"$f":"E81*C66","v":448.00000000000006},null,"30 day Readmittance penalty",null,null,null,null,null,null,null,null,null,null,null,null,null,14]
[null,"Level 2",null,null,0.09,{"$f":"IF(W75=2,D51*E82,0)","v":3.5999999999999997E-2},{"$f":"IF(W75=2,E82*D66,0)","v":288},null,"30-90 day bundle",null,null,null,null,null,null,null,null,null,null,null,null,null,9]
[{"$f":"A67","v":"Specialist Encounters"},"Level 1",null,null,0.18,{"$f":"+E83*C52","v":3.5999999999999997E-2},{"$f":"E83*C67","v":7.1999999999999993},null,"medicare shared savings",null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,"Level 2",null,null,0.11,{"$f":"IF(W75=2,E84*D52,0)","v":2.2000000000000002E-2},{"$f":"IF(W75=2,E84*D67,0)","v":4.4000000000000004},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11]
[{"$f":"A68","v":"Other"},"Level 1",null,null,0.12,{"$f":"E85*C53","v":0.03},{"$f":"E85*C68","v":7.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,"Level 2",null,null,0.06,{"$f":"IF(W75=2,E86*D53,0)","v":1.4999999999999999E-2},{"$f":"IF(W75=2,E86*D68,0)","v":3.75},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,"Total Utilization Cost Avoidance PMPM",{"$f":"IF(Level=1,SUM(G77:G86),SUM(G77,G79,G81,G83,G85)*'3.Population Data'!E5/'3.Population Data'!#REF!+SUM(G78,G80,G82,G84,G86)*'3.Population Data'!E6/'3.Population Data'!#REF!)","v":{"$error":"#REF!"}}]
[]
["Economic Benefits"]
[null,"Revenue Increase",100,"PMPM"]
[]
[null,"Utilization Cost Increase"]
[null,null,"Category","Incremental Encounters PMPM","Cost per Encounter","Total Incremental Cost per Category"]
[null,null,"Mental Health",1,100,{"$f":"E94*D94","v":100}]
[null,null,"Rehabilitation and Occupational Therapy",2,200,{"$f":"+E95*D95","v":400}]
[null,null,null,null,"Total Utilization Cost Increase PMPM",{"$f":"SUM(F94:F95)","v":500}]
[]
["Gross Benefit PMPM",{"$f":"G87-F96+C90","v":{"$error":"#REF!"}},null,"Admission Only Test"]
["GRACE Costs PMPM",{"$f":"IF(W75=1,C44,E44)","v":{"$error":"#REF!"}},{"$f":"IF(W75=1,\"Level 1 Only\", \"Level 1 and 2\")","v":"Level 1 and 2"},null,"Required ROI",1.56]
["Net Benefit PMPM",{"$f":"B98-B99","v":{"$error":"#REF!"}},null,null,"Admission Reduction Required",0.54798560846560851]
["Return on Investment",{"$f":"B100/B99","v":{"$error":"#REF!"}}]

{"sheet":"Control","index":1,"n_rows":21,"n_cols":26,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,"Costs",null,"ED Benefits",null,null,null,"Admin benefits",null,null,null,"Readmit Benefits",null,null,null,null,"month",null,{"$f":"TEXT(RETURNONINV,\"#%\")","v":"206%"}]
[null,"Services","Costs",null,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,null,null,0.5,0.2,0.05,null,0.5,0.2,0.05,null,0.5,0.2,0.05,null,null,"year",null,{"$f":"TEXT(PBMONTH,\"#.##\")","v":".57"}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($B3=2,1,0)","v":{"$error":"#REF!"}},{"$f":"IF($B3=3,1,0)","v":{"$error":"#REF!"}},{"$f":"IF($B3=4,1,0)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT(E3:G3,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C3=1,1,0)","v":{"$error":"#REF!"}},null,{"$f":"E3*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E3,F3),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G3,F3,E3),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E3*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F3,E3),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G3,F3,E3),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E3*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F3,E3),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G3,E3:F3),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"IF($B4=2,1,0)","v":{"$error":"#REF!"}},{"$f":"IF($B4=3,1,0)","v":{"$error":"#REF!"}},{"$f":"IF($B4=4,1,0)","v":{"$error":"#REF!"}},{"$f":"SUMPRODUCT(E4:G4,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(C4=1,1,0)","v":{"$error":"#REF!"}},null,{"$f":"E4*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E4,F4),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G4,F4,E4),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E4*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F4,E4),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G4,F4,E4),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E4*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F4,E4),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G4,E4:F4),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E5:G5,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E5*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E5,F5),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G5,F5,E5),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E5*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F5,E5),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G5,F5,E5),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E5*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F5,E5),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G5,E5:F5),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E6:G6,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E6*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E6,F6),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G6,F6,E6),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E6*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F6,E6),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G6,F6,E6),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E6*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F6,E6),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G6,E6:F6),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E7:G7,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E7*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E7,F7),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G7,F7,E7),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E7*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F7,E7),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G7,F7,E7),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E7*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F7,E7),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G7,E7:F7),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E8:G8,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E8*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E8,F8),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G8,F8,E8),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E8*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F8,E8),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G8,F8,E8),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E8*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F8,E8),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G8,E8:F8),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E9:G9,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E9*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E9,F9),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G9,F9,E9),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E9*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F9,E9),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G9,F9,E9),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E9*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F9,E9),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G9,E9:F9),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E10:G10,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E10*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E10,F10),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G10,F10,E10),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E10*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F10,E10),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G10,F10,E10),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E10*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F10,E10),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G10,E10:F10),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E11:G11,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E11*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E11,F11),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G11,F11,E11),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E11*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F11,E11),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G11,F11,E11),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E11*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F11,E11),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G11,E11:F11),#REF!,0)","v":{"$error":"#REF!"}}]
[{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUMPRODUCT(E12:G12,#REF!)*#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"E12*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(E12,F12),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G12,F12,E12),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E12*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F12,E12),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G12,F12,E12),#REF!,0)","v":{"$error":"#REF!"}},null,{"$f":"E12*#REF!","v":{"$error":"#REF!"}},{"$f":"IF(OR(F12,E12),#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(G12,E12:F12),#REF!,0)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H12)","v":{"$error":"#REF!"}},null,null,{"$f":"1-SUM(K3:K12)","v":{"$error":"#REF!"}},{"$f":"1-SUM(L3:L12)","v":{"$error":"#REF!"}},{"$error":"#REF!"},null,{"$f":"1-SUM(O3:O12)","v":{"$error":"#REF!"}},{"$f":"1-SUM(P3:P12)","v":{"$error":"#REF!"}},{"$f":"1-SUM(Q3:Q12)","v":{"$error":"#REF!"}},null,{"$f":"1-SUM(S3:S12)","v":{"$error":"#REF!"}},{"$f":"1-SUM(T3:T12)","v":{"$error":"#REF!"}},{"$f":"1-SUM(U3:U12)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"+#REF!-D15-E15","v":{"$error":"#REF!"}},{"$f":"+#REF!-#REF!","v":{"$error":"#REF!"}},{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[null,"Visit Count per 1000",null,null,null,null,null,"Total Scenario Costs Costs",null,null,null,"Cost Savings",null,"ROI"]
[null,null,"21-50%","6-20%","0-5%",null,"Cost per Visit","21-50%","6-20%","0-5%","Total Costs"]
[null,"ER",{"$f":"#REF!*Control!K13","v":{"$error":"#REF!"}},{"$f":"#REF!*Control!L13","v":{"$error":"#REF!"}},{"$f":"#REF!*Control!M13","v":{"$error":"#REF!"}},null,25000,{"$f":"$G18*C18*Control!C$15/1000","v":{"$error":"#REF!"}},{"$f":"$G18*D18*Control!D$15/1000","v":{"$error":"#REF!"}},{"$f":"$G18*E18*Control!E$15/1000","v":{"$error":"#REF!"}},{"$f":"SUM(H18:J18)","v":{"$error":"#REF!"}},{"$f":"#REF!-Control!K18","v":{"$error":"#REF!"}},{"$f":"L18/#REF!","v":{"$error":"#REF!"}}]
[null,"Admittance",{"$f":"#REF!*Control!O13","v":{"$error":"#REF!"}},{"$f":"#REF!*Control!P13","v":{"$error":"#REF!"}},{"$f":"#REF!*Control!Q13","v":{"$error":"#REF!"}},null,50000,{"$f":"$G19*C19*Control!C$15/1000","v":{"$error":"#REF!"}},{"$f":"$G19*D19*Control!D$15/1000","v":{"$error":"#REF!"}},{"$f":"$G19*E19*Control!E$15/1000","v":{"$error":"#REF!"}},{"$f":"SUM(H19:J19)","v":{"$error":"#REF!"}},{"$f":"#REF!-Control!K19","v":{"$error":"#REF!"}},{"$f":"L19/#REF!","v":{"$error":"#REF!"}}]
[null,"Readmit",{"$f":"#REF!*Control!S13","v":{"$error":"#REF!"}},{"$f":"#REF!*Control!T13","v":{"$error":"#REF!"}},{"$f":"#REF!*Control!U13","v":{"$error":"#REF!"}},null,35000,{"$f":"$G20*C20*Control!C$15/1000","v":{"$error":"#REF!"}},{"$f":"$G20*D20*Control!D$15/1000","v":{"$error":"#REF!"}},{"$f":"$G20*E20*Control!E$15/1000","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"#REF!-Control!K20","v":{"$error":"#REF!"}},{"$f":"L20/#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(K18:K20)","v":{"$error":"#REF!"}},{"$f":"SUM(L18:L20)","v":{"$error":"#REF!"}},{"$f":"L21/#REF!","v":{"$error":"#REF!"}},{"$f":"(L21-H13)/H13","v":{"$error":"#REF!"}}]

{"sheet":"MCCALCS","index":2,"n_rows":126,"n_cols":28,"rows_kept":126,"cut":false,"hidden":true,"merged":[]}
[null,null,"Current","Low","Mostlikely","High",null,"Rand","Standard","TRI",null,null,null,"NET Ben","ROI"]
[null,{"$f":"'9a.Monte Carlo Analysis'!B3","v":"Launch Costs"},{"$f":"'9a.Monte Carlo Analysis'!D3","v":140000},{"$f":"'9a.Monte Carlo Analysis'!E3","v":0},{"$f":"'9a.Monte Carlo Analysis'!F3","v":0},{"$f":"'9a.Monte Carlo Analysis'!G3","v":0},null,{"$f":"RAND()","v":0.1116469228982826},{"$f":"(E2-D2)/(F2-D2)","v":{"$error":"#DIV/0!"}},{"$f":"(D2+(F2-D2)*IF(H2<=I2,SQRT(H2*I2),1-SQRT((1-I2)*(1-H2))))","v":{"$error":"#DIV/0!"}},null,null,"MIN",{"$f":"MIN(T27:T10027)","v":459.80119999999999},{"$f":"MIN(U27:U10027)","v":1.5372290879810102},null,null,null,null,null,"ROI",{"$f":"'9a.Monte Carlo Analysis'!G44","v":2.4315562883511368},{"$f":"COUNTIF(U$27:U$10026,\"<\"&V2)/COUNT($U27:U$10026)","v":0.93}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B5","v":"Hospital Admissions"},{"$f":"'9a.Monte Carlo Analysis'!D5","v":1.33},{"$f":"'9a.Monte Carlo Analysis'!E5","v":1.0640000000000001},{"$f":"'9a.Monte Carlo Analysis'!F5","v":1.33},{"$f":"'9a.Monte Carlo Analysis'!G5","v":1.5960000634193421},null,{"$f":"RAND()","v":0.48576497343270197},{"$f":"(E3-D3)/(F3-D3)","v":0.49999994039536239},{"$f":"(D3+(F3-D3)*IF(H3<=I3,SQRT(H3*I3),1-SQRT((1-I3)*(1-H3))))","v":1.326186157367323},null,null,"MAX",{"$f":"MAX(T27:T10027)","v":773.7491},{"$f":"MAX(U27:U10027)","v":2.5868342912468298},null,null,null,null,null,null,{"$f":"'9a.Monte Carlo Analysis'!G45","v":2.9719021302069448},{"$f":"COUNTIF(U$27:U$10026,\">\"&V3)/COUNT($U28:U$10026)","v":0}]
[2,{"$f":"B3","v":"Hospital Admissions"},{"$f":"'9a.Monte Carlo Analysis'!D6","v":0.66500000000000004},{"$f":"'9a.Monte Carlo Analysis'!E6","v":0.53200000000000003},{"$f":"'9a.Monte Carlo Analysis'!F6","v":0.66500000000000004},{"$f":"'9a.Monte Carlo Analysis'!G6","v":0.79800003170967104},null,0.92209360337895019,{"$f":"(E4-D4)/(F4-D4)","v":0.49999994039536239},{"$f":"(D4+(F4-D4)*IF(H4<=I4,SQRT(H4*I4),1-SQRT((1-I4)*(1-H4))))","v":0.74550076042574109},null,null,null,{"$f":"ROUNDDOWN(N2,0)","v":459},{"$f":"ROUNDDOWN(O2,1)","v":1.5},null,null,null,null,null,null,null,{"$f":"(1-W2)-(W3)","v":6.9999999999999951E-2}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B8","v":"Hospital Readmissions"},{"$f":"'9a.Monte Carlo Analysis'!D8","v":0.17},{"$f":"'9a.Monte Carlo Analysis'!E8","v":0.13600000000000001},{"$f":"'9a.Monte Carlo Analysis'!F8","v":0.17},{"$f":"'9a.Monte Carlo Analysis'!G8","v":0.2040000081062317},null,0.946985991402577,0.49999994039536233,0.19292894529767005,null,null,null,{"$f":"ROUNDUP(N3,0)","v":774},{"$f":"ROUNDUP(O3,1)","v":2.6},null,null,null,null,null,"NET Bene",{"$f":"'9a.Monte Carlo Analysis'!G40","v":2715.2379000000001},{"$f":"COUNTIF(T$27:T$10026,\"<\"&V5)/COUNT($T30:T$10026)","v":1.0309278350515463}]
[2,{"$f":"B5","v":"Hospital Readmissions"},{"$f":"'9a.Monte Carlo Analysis'!D9","v":8.5000000000000006E-2},{"$f":"'9a.Monte Carlo Analysis'!E9","v":6.8000000000000005E-2},{"$f":"'9a.Monte Carlo Analysis'!F9","v":8.5000000000000006E-2},{"$f":"'9a.Monte Carlo Analysis'!G9","v":0.10200000405311585},null,0.81688998131731505,0.49999994039536233,9.1712262384067836E-2,null,null,null,{"$f":"(N5-N4)/30","v":10.5},{"$f":"(O5-O4)/30","v":3.6666666666666667E-2},null,null,null,null,null,null,{"$f":"'9a.Monte Carlo Analysis'!G41","v":3318.6241000000005},{"$f":"COUNTIF(T$27:T$10026,\">\"&V6)/COUNT($T31:T$10026)","v":0}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B11","v":"Emergency Dept."},{"$f":"'9a.Monte Carlo Analysis'!D11","v":1890},{"$f":"'9a.Monte Carlo Analysis'!E11","v":1512},{"$f":"'9a.Monte Carlo Analysis'!F11","v":1890},{"$f":"'9a.Monte Carlo Analysis'!G11","v":2268.0000901222229},null,0.87804997288067632,{"$f":"(E7-D7)/(F7-D7)","v":0.49999994039536233},{"$f":"(D7+(F7-D7)*IF(H7<=I7,SQRT(H7*I7),1-SQRT((1-I7)*(1-H7))))","v":2081.3200756242645},null,null,null,{"$f":"ROUNDUP(N6,1)","v":10.5},{"$f":"O6","v":3.6666666666666667E-2},null,null,null,null,null,null,null,{"$f":"(1-W5)-(W6)","v":-3.0927835051546282E-2}]
[2,{"$f":"B7","v":"Emergency Dept."},{"$f":"'9a.Monte Carlo Analysis'!D12","v":945},{"$f":"'9a.Monte Carlo Analysis'!E12","v":756},{"$f":"'9a.Monte Carlo Analysis'!F12","v":945},{"$f":"'9a.Monte Carlo Analysis'!G12","v":1134.0000450611115},null,0.14957468061593671,0.49999994039536233,859.37270242391855]
[1,{"$f":"'9a.Monte Carlo Analysis'!B14","v":"Baseline Cost of Hospital Admissions"},{"$f":"'9a.Monte Carlo Analysis'!D14","v":3500},{"$f":"'9a.Monte Carlo Analysis'!E14","v":2800},{"$f":"'9a.Monte Carlo Analysis'!F14","v":3500},{"$f":"'9a.Monte Carlo Analysis'!G14","v":4200.0001668930054},null,7.8058026816327009E-2,{"$f":"(E9-D9)/(F9-D9)","v":0.49999994039536233},{"$f":"(D9+(F9-D9)*IF(H9<=I9,SQRT(H9*I9),1-SQRT((1-I9)*(1-H9))))","v":3076.5806851519778}]
[2,null,{"$f":"'9a.Monte Carlo Analysis'!D15","v":2625},{"$f":"'9a.Monte Carlo Analysis'!E15","v":2100},{"$f":"'9a.Monte Carlo Analysis'!F15","v":2625},{"$f":"'9a.Monte Carlo Analysis'!G15","v":3150.000125169754},null,0.3608327245764561,{"$f":"(E10-D10)/(F10-D10)","v":0.49999994039536233},{"$f":"(D10+(F10-D10)*IF(H10<=I10,SQRT(H10*I10),1-SQRT((1-I10)*(1-H10))))","v":2545.9922231772398}]
[1,"Baseline Cost of Hospital Day-Admission",{"$f":"'9a.Monte Carlo Analysis'!D17","v":3500},{"$f":"'9a.Monte Carlo Analysis'!E17","v":2800},{"$f":"'9a.Monte Carlo Analysis'!F17","v":3500},{"$f":"'9a.Monte Carlo Analysis'!G17","v":4200.0001668930054},null,0.80814429058721771,0.49999994039536233,3766.3889787702569]
[2,null,{"$f":"'9a.Monte Carlo Analysis'!D18","v":2625},{"$f":"'9a.Monte Carlo Analysis'!E18","v":2100},{"$f":"'9a.Monte Carlo Analysis'!F18","v":2625},{"$f":"'9a.Monte Carlo Analysis'!G18","v":3150.000125169754},null,0.67076921407536816,0.49999994039536233,2723.9854122239531]
[null,{"$f":"'9a.Monte Carlo Analysis'!B20","v":"Costs per Emergency Dept."},{"$f":"'9a.Monte Carlo Analysis'!D20","v":2800},{"$f":"'9a.Monte Carlo Analysis'!E20","v":2240},{"$f":"'9a.Monte Carlo Analysis'!F20","v":2800},{"$f":"'9a.Monte Carlo Analysis'!G20","v":3360.0001335144043},null,0.6889163150313411,{"$f":"(E13-D13)/(F13-D13)","v":0.49999994039536233},{"$f":"(D13+(F13-D13)*IF(H13<=I13,SQRT(H13*I13),1-SQRT((1-I13)*(1-H13))))","v":2918.2855684503515}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B22","v":"Percentage Change in Specialty Care"},{"$f":"'9a.Monte Carlo Analysis'!D22*100+20","v":10},{"$f":"'9a.Monte Carlo Analysis'!E22*100+20","v":11.999999999999998},{"$f":"'9a.Monte Carlo Analysis'!F22*100+20","v":10},{"$f":"'9a.Monte Carlo Analysis'!G22*100+20","v":7.9999995231628418},null,0.27891921823735388,{"$f":"(E14-D14)/(F14-D14)","v":0.49999994039536211},{"$f":"(D14+(F14-D14)*IF(H14<=I14,SQRT(H14*I14),1-SQRT((1-I14)*(1-H14))))","v":10.506228259774296},null,null,"Point",0]
[null,{"$f":"'9a.Monte Carlo Analysis'!B24","v":"Percentage Change in Emergency Dept."},{"$f":"'9a.Monte Carlo Analysis'!D24*100+60","v":25},{"$f":"'9a.Monte Carlo Analysis'!E24*100+60","v":32},{"$f":"'9a.Monte Carlo Analysis'!F24*100+60","v":25},{"$f":"'9a.Monte Carlo Analysis'!G24*100+60","v":17.999998331069946},null,4.3770728727640651E-2,{"$f":"(E15-D15)/(F15-D15)","v":0.49999994039536233},{"$f":"(D15+(F15-D15)*IF(H15<=I15,SQRT(H15*I15),1-SQRT((1-I15)*(1-H15))))","v":29.928881479330364}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B26","v":"Percentage Change in Hospital Admissions"},{"$f":"'9a.Monte Carlo Analysis'!D26*100+60","v":35},{"$f":"'9a.Monte Carlo Analysis'!E26*100+60","v":40},{"$f":"'9a.Monte Carlo Analysis'!F26*100+60","v":35},{"$f":"'9a.Monte Carlo Analysis'!G26*100+60","v":29.999998807907104},null,8.6904672558660412E-2,{"$f":"(E16-D16)/(F16-D16)","v":0.49999994039536233},{"$f":"(D16+(F16-D16)*IF(H16<=I16,SQRT(H16*I16),1-SQRT((1-I16)*(1-H16))))","v":37.915477477712166}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B28","v":"Percentage Change in Hospital Readmissions"},{"$f":"'9a.Monte Carlo Analysis'!D28*100+60","v":35},{"$f":"'9a.Monte Carlo Analysis'!E28*100+60","v":40},{"$f":"'9a.Monte Carlo Analysis'!F28*100+60","v":35},{"$f":"'9a.Monte Carlo Analysis'!G28*100+60","v":29.999998807907104},null,0.77660256946107331,{"$f":"(E17-D17)/(F17-D17)","v":0.49999994039536233},{"$f":"(D17+(F17-D17)*IF(H17<=I17,SQRT(H17*I17),1-SQRT((1-I17)*(1-H17))))","v":33.342135178793846}]
[]
[null,null,null,"D2+(F2-D2)*IF(H2<=i2,SQRT(H2*I2),1-SQRT(1-I2)*(1-H2))"]
[]
[]
[]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[null,null,"INPUTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outputs",null,0,{"$f":"+N4","v":459},{"$f":"COUNTIFS(T$27:T$10026,\">\" &N14,T$27:T$10026, \"<=\" &W24)","v":0},{"$f":"O$4+O$7*V24","v":1.5},{"$f":"COUNTIFS(U$27:U$10026,\">\" &P14,U$27:U$10026, \"<=\" &Y24)","v":0},{"$f":"X24/X$55","v":0},{"$f":"Z24/Z$55","v":0}]
[null,"Iteration","LaunchCosts","BaseAdmin 1","BaseAdmin 2","BaseReadmin 1","BaseReadmin 2","EDVisit1","EDVisit2","Hosp Costs Admin Level1","Hosp Costs Admin Level2","Hosp Costs ReAdmin Level1","Hosp Costs ReAdmin Level2","EDCost","PCSPecVisit","PCEDVisits","PCADMIN","PCREADMIN",null,"NETBEN","ROI",1,{"$f":"+W$24+V25*N$7","v":469.5},{"$f":"COUNTIFS(T$27:T$10026,\">\" &W24,T$27:T$10026, \"<=\" &W25)","v":1},{"$f":"O$4+O$7*V25","v":1.5366666666666666},{"$f":"COUNTIFS(U$27:U$10026,\">\" &Y24,U$27:U$10026, \"<=\" &Y25)","v":0},0.01,0]
[null,null,140000,1.33,0.66500000000000004,0.17,8.5000000000000006E-2,1890,945,3500,2625,3500,2625,2800,10,25,35,35,null,615.21230000000003,2.0568065875025248,2,480,{"$f":"COUNTIFS(T$27:T$10026,\">\" &W25,T$27:T$10026, \"<=\" &W26)","v":1},{"$f":"O$4+O$7*V26","v":1.5733333333333333},{"$f":"COUNTIFS(U$27:U$10026,\">\" &Y25,U$27:U$10026, \"<=\" &Y26)","v":1},0.01,0.01]
[null,null,{"$error":"#DIV/0!"},1.378817815464068,0.64667747935285802,0.18083820782545371,8.7702952798233785E-2,1993.4653897412832,931.92723875593322,3349.3069,2793.0567000000001,4029.9933000000001,2694.3427000000001,3034.4043999999999,9.4912034801048808,23.285543869044279,32.890345348895671,35.435550777489482,null,615.21230000000003,2.0568065875025248,3,490.5,1,1.61,1,0.01,0.01]
[null,null,{"$error":"#DIV/0!"},1.341378965253047,0.64251823879306658,0.17002704891063752,9.2951017340863959E-2,1846.7876911278615,1079.3588682345169,3929.8687,2436.777,3545.17,2329.9135000000001,2681.6806999999999,10.218813577521999,21.309241999567622,35.153746702810288,35.409914648865431,null,674.93830000000003,2.2564853989127571,4,501,2,1.6466666666666667,1,0.02,0.01]
[null,null,{"$error":"#DIV/0!"},1.3231214400862314,0.73531441459702318,0.17168091669580079,8.9730251742619851E-2,2074.9290404329654,1032.5598472419952,2995.6522,2727.7429999999999,4134.8926000000001,2553.1251000000002,3114.5853999999999,11.368947061672678,21.465136164828735,34.97311419446612,34.600969401224908,null,682.0865,2.2803837023131437,5,511.5,1,1.6833333333333333,2,0.01,0.02]
[null,null,{"$error":"#DIV/0!"},1.1040254220081407,0.67349806421242231,0.16298973271674005,8.2644057542018215E-2,2018.2954469417473,930.44891764515023,3766.4371999999998,2627.1815000000001,3296.2046,2976.8325,2877.1073999999999,11.301206071142161,23.271420821326714,33.668259444970296,34.785814625976208,null,606.37620000000004,2.0272653635988083,6,522,2,1.72,1,0.02,0.01]
[null,null,{"$error":"#DIV/0!"},1.2434842606113286,0.7500297222806267,0.17384409339476817,8.7885242467626468E-2,1576.4021675796464,943.35697827789647,3398.1538,2408.3434999999999,3608.0036,2479.7725999999998,2547.0445,9.5579779460606353,29.659670134465468,36.547241426405122,33.250039809644385,null,582.99959999999999,1.9491115584100882,7,532.5,7,1.7566666666666666,5,7.0000000000000007E-2,0.05]
[null,null,{"$error":"#DIV/0!"},1.3879658082893815,0.68504016375632037,0.19567632896646478,8.8513725295001774E-2,1829.8053534717878,1075.5657987839165,2921.6136000000001,2560.8788,4013.8874000000001,2515.3231000000001,2782.9164999999998,8.9598370862949519,26.808478220344494,33.470458314827084,37.929703786313119,null,524.06870000000004,1.7520911653201663,8,543,3,1.7933333333333334,4,0.03,0.04]
[null,null,{"$error":"#DIV/0!"},1.4885583303473977,0.75552248696200874,0.16688908794058926,9.155225607440165E-2,1836.1636146973201,1056.3053760597527,3377.2186000000002,2634.0567000000001,3114.8274000000001,2476.3056999999999,3017.9571999999998,9.3892732602064157,29.22955447527972,36.609720828137739,35.651792177631492,null,574.55669999999998,1.9208849994823427,9,553.5,5,1.83,5,0.05,0.05]
[null,null,{"$error":"#DIV/0!"},1.2403987739207274,0.69527660996841933,0.15528895532566342,9.7731575151757927E-2,1853.42588393592,854.26691895339104,3195.4072999999999,2697.5439999999999,2939.2750999999998,2256.4340999999999,2855.0353,9.701223345591881,28.363758190395032,34.222515255715763,34.175785599716775,null,642.55700000000002,2.1482266596498798,10,564,4,1.8666666666666667,5,0.04,0.05]
[null,null,{"$error":"#DIV/0!"},1.1959654626275988,0.74212220176956012,0.16633509629135146,9.0023055347997885E-2,1655.8748323554457,1046.0461843435692,3386.8510999999999,2510.4148,3742.3566999999998,2609.0180999999998,2944.8692999999998,10.488534260489406,29.548631253680774,37.072669332214431,33.26146775980687,null,525.15060000000005,1.7557079985067758,11,574.5,5,1.9033333333333333,5,0.05,0.05]
[null,null,{"$error":"#DIV/0!"},1.3444880510392878,0.66007889569547185,0.16278373623796449,7.6569522888123367E-2,2112.576274698903,886.60526015497703,3556.5057999999999,2667.6916999999999,3487.4681999999998,2673.5805,3232.3503999999998,11.134598105755897,26.268895850207304,34.8797575647679,35.174960277510174,null,522.59079999999994,1.7471499723626382,12,585,9,1.94,6,0.09,0.06]
[null,null,{"$error":"#DIV/0!"},1.2038330640643919,0.63530758848979263,0.18411164456405751,7.8482676172862975E-2,1830.8037058691102,933.83132946827448,3961.6342,2685.5477999999998,4117.7048000000004,2788.3334,2638.9384,10.831988864403455,26.147291702726687,35.231504177097307,36.368693417004351,null,648.01969999999994,2.1664900486465855,13,595.5,3,1.9766666666666666,5,0.03,0.05]
[null,null,{"$error":"#DIV/0!"},1.5134139431693923,0.62692870911883425,0.18513263341549424,7.8535722565100927E-2,1995.3621679911944,986.6243338288233,3197.3002000000001,2718.9713000000002,3449.8078,2475.3416999999999,2991.9955,11.632061800427081,24.609261409737936,33.835805904453501,33.967900596926228,null,624.32060000000001,2.0872579873216157,14,606,2,2.0133333333333332,3,0.02,0.03]
[null,null,{"$error":"#DIV/0!"},1.3581400289391925,0.57860927587943556,0.14854044453598306,8.9243938546780741E-2,1949.7411809826972,905.81730564916234,3983.0668000000001,2467.4168,3755.1279,2910.1210000000001,2964.3445999999999,10.076853125371033,26.768364838215717,31.87816387404704,32.576892159602281,null,667.0634,2.2301575604020591,15,616.5,7,2.0499999999999998,5,7.0000000000000007E-2,0.05]
[null,null,{"$error":"#DIV/0!"},1.4208527958107715,0.7287521125828138,0.17028665680680793,9.2279295247152004E-2,1803.6353026778006,855.95916006967798,3743.6478000000002,3020.1374999999998,3332.2573000000002,2675.6993000000002,2507.6406000000002,9.8686049561338116,20.316635527618267,33.685541603020809,32.485162884448087,null,723.40819999999997,2.4185321450077755,16,627,6,2.0866666666666669,9,0.06,0.09]
[null,null,{"$error":"#DIV/0!"},1.3025848073413764,0.65060372562791569,0.19053301128280861,7.7346490777288446E-2,1931.2479338847356,908.74660314804112,3230.1523999999999,3007.1052,3227.4198999999999,2725.0855999999999,2893.4281999999998,9.5879869564666365,27.810722790642913,32.370861169478843,34.231707778201383,null,738.94920000000002,2.4704898339138235,17,637.5,3,2.1233333333333331,{"$f":"COUNTIFS(U$27:U$10026,\">\" &Y40,U$27:U$10026, \"<=\" &Y41)","v":4},0.03,0.04]
[null,null,{"$error":"#DIV/0!"},1.3778258508360053,0.70987471274638736,0.1806114386049657,8.1647202171461125E-2,1680.6703402763712,875.16948945842387,3192.6291999999999,2859.8694,3408.2710000000002,2448.0835999999999,2953.7307000000001,9.2595780536093528,23.225736769342063,36.188463725180412,33.694012012245665,null,605.1069,2.0230219344829257,18,648,5,2.16,4,0.05,0.04]
[null,null,{"$error":"#DIV/0!"},1.4453905252823611,0.6918288636557548,0.17335954768521217,8.0290483232661594E-2,1705.3574305380935,1062.558507476987,3570.3831,2617.5695999999998,3762.1995000000002,2324.9137000000001,2650.6752999999999,10.532727015132592,23.588832340397289,36.354522463283672,33.500091517593106,null,594.80880000000002,1.988592782836905,19,658.5,8,2.1966666666666668,8,0.08,0.08]
[null,null,{"$error":"#DIV/0!"},1.3318584851103639,0.63458626723695166,0.16059981017329619,7.0468726738736692E-2,2174.6637032093122,933.56407908484266,3986.8056000000001,2441.7545,3687.7645000000002,2577.7662,2659.4157,9.4768359604478203,28.145937166221358,31.149907235275215,39.765469269580123,null,661.90260000000001,2.2129038689358831,20,669,5,2.2333333333333334,6,0.05,0.06]
[null,null,{"$error":"#DIV/0!"},1.2000426383278442,0.70180212082247184,0.1998314057479002,8.2739835014133345E-2,2091.6772174298048,919.56247783042386,3192.4942999999998,2447.3625000000002,3052.2860999999998,2931.7271000000001,2479.9452000000001,10.43479759456754,25.247791611611426,34.250819455789141,36.489740537679126,null,711.81769999999995,2.3797822763284961,21,679.5,5,2.27,5,0.05,0.05]
[null,null,{"$error":"#DIV/0!"},1.2066340851496415,0.74200228620928721,0.16661823855638508,8.1813974696280253E-2,1888.3128645496313,951.03018215884742,3202.6732999999999,2708.6792,3630.9706999999999,2568.6469000000002,2914.6021999999998,10.170699010053671,26.032523727908718,33.345173129678159,32.694623852017585,null,518.50980000000004,1.7335062420277303,22,690,3,2.3066666666666666,3,0.03,0.03]
[null,null,{"$error":"#DIV/0!"},1.2233577027345215,0.67523702358791304,0.19425137697183231,8.7266955566515592E-2,2071.0946669272071,1090.8689374960632,3728.3027999999999,2751.0452,2883.2957999999999,2515.8595,2908.7141000000001,9.4300080340862653,21.022230583062246,33.873625180282673,38.366356036630513,null,564.95280000000002,1.8887769096529443,23,700.5,1,2.3433333333333333,1,0.01,0.01]
[null,null,{"$error":"#DIV/0!"},1.3928954148015926,0.67362379284466456,0.15880475217498424,8.6265469612267179E-2,1733.1334967441585,1074.9989687994082,4062.0659999999998,2647.1869999999999,4050.3434000000002,2619.3694,3142.8838000000001,10.096826666739444,24.608047726982981,33.464327095214401,35.872591765038585,null,651.15309999999999,2.1769656804200328,24,711,2,2.38,3,0.02,0.03]
[null,null,{"$error":"#DIV/0!"},1.3258201327027126,0.67962273788356697,0.18861841751500141,7.7217600806352871E-2,1971.1661571031532,959.20150218035428,3280.0073000000002,2500.4834999999998,3579.49,2526.9168,2731.6999000000001,9.7054733279470859,22.512204982392049,36.853820101388266,34.848881758373444,null,773.52760000000001,2.5860936633402591,25,721.5,1,2.4166666666666665,0,0.01,0]
[null,null,{"$error":"#DIV/0!"},1.43374761777097,0.61646669871227977,0.1839470879052118,7.9305957148504899E-2,1662.7853160180182,976.53370703850408,3756.8179,2404.0540000000001,3537.1269000000002,2467.0920000000001,2457.6347999999998,9.2267385041498304,25.25558467459161,35.480103662682851,34.582986586768982,null,572.29740000000004,1.9133316265396432,26,732,1,2.4533333333333331,1,0.01,0.01]
[null,null,{"$error":"#DIV/0!"},1.2149654139275083,0.66462529833706374,0.16239732678971086,0.10057345625730224,1856.4879550957196,938.09597933042983,3014.4029999999998,2241.0255000000002,3054.8863000000001,2546.0785999999998,2640.6228000000001,10.337207700266147,22.241184328735017,33.62135795903685,36.352166031378154,null,658.00670000000002,2.1998788937770288,27,742.5,1,2.4900000000000002,1,0.01,0.01]
[null,null,{"$error":"#DIV/0!"},1.2807314472720535,0.62750584939721366,0.17925001383173114,7.7172694892419846E-2,1834.5357665401509,964.14701340305987,3147.8353000000002,2676.4692,4027.4095000000002,2871.8067000000001,2762.5034999999998,9.7131350255789997,26.794680285499609,34.726978009234699,38.311407358177213,null,485.5111,1.6231835544059436,28,753,0,2.5266666666666664,2,0,0.02]
[null,null,{"$error":"#DIV/0!"},1.38629646942547,0.66981858683580897,0.18916022265147661,8.5669044054112645E-2,1738.9427323702512,967.12493315439963,2941.7890000000002,2249.308,3634.4679999999998,2509.7723000000001,2856.4295000000002,10.318748109454727,22.688668965509954,31.502169672012108,37.65611091617491,null,540.79369999999994,1.8080068176901489,29,763.5,3,2.5633333333333335,1,0.03,0.01]
[null,null,{"$error":"#DIV/0!"},1.4876784309317412,0.57115927375425124,0.15046422243614102,8.755409694596919E-2,2015.313151628005,844.593039501813,4005.2174,2567.7168000000001,3715.317,3112.3132999999998,3145.9576999999999,11.326967330570724,26.456289506541822,34.748600539416778,33.321981509966164,null,577.38869999999997,1.9303529654848812,30,774,3,2.6,3,0.03,0.03]
[null,null,{"$error":"#DIV/0!"},1.4146070273527351,0.69391638454817461,0.18597739911387678,7.3541665362805209E-2,1891.7309993234387,846.20983635280868,3573.2076000000002,2685.8710000000001,3276.3656000000001,2533.2928999999999,2446.8220999999999,10.143098171604249,25.223130728913773,35.974404310764292,37.368588668478957,null,760.30079999999998,2.5418732913728674,null,null,{"$f":"SUM(X24:X54)","v":100},null,{"$f":"SUM(Z24:Z54)","v":100}]
[null,null,{"$error":"#DIV/0!"},1.3831512071373906,0.73345563009937442,0.16935678646940483,7.4725123976551247E-2,1744.0105870552579,1058.8234287142557,3176.4337,2481.0853000000002,3673.9395,2854.2363,2962.1079,9.8033097852612094,25.932428163590409,38.164537301072528,37.856031924974623,null,634.45230000000004,2.1211306135313617]
[null,null,{"$error":"#DIV/0!"},1.2017997888145215,0.64751708209935699,0.15033939875512028,9.5191505168208748E-2,1796.3449116477218,836.02118365929778,3534.3710000000001,2632.0214000000001,3537.1316000000002,2557.6003000000001,2734.8379,10.585988110256061,31.566049516094665,38.394776936145469,33.887770949035449,null,554.53650000000005,1.8539524623815775]
[null,null,{"$error":"#DIV/0!"},1.5668684360362453,0.69458068399798245,0.17497582349918345,8.5073174555529527E-2,1781.6024800681355,1030.0677793226741,3522.0711000000001,2910.7840999999999,3433.2240999999999,2578.9252000000001,2980.8453,10.039554275316766,24.01397526071645,34.399801375715711,35.131324929124112,null,493.18669999999997,1.6488450990468004]
[null,null,{"$error":"#DIV/0!"},1.4696544792964266,0.65942773571212077,0.16931156874667699,9.6767813771472921E-2,2176.0334897369667,863.06827649964191,3949.5571,2390.9072000000001,3494.3361,2625.1224000000002,2736.3471,11.772919858368404,26.467439772098366,38.984377397771119,37.682648824657093,null,753.0213,2.517536125184717]
[null,null,{"$error":"#DIV/0!"},1.2914713399459206,0.69599378275774793,0.1530870251503659,9.4294309754393776E-2,1770.9422969053201,943.35102853677449,3500.4283,2333.6120999999998,4069.8454999999999,2417.1493999999998,2706.6491000000001,10.122020430568938,29.950616283049044,34.041640836114951,35.697016496068549,null,677.28790000000004,2.2643407128963302]
[null,null,{"$error":"#DIV/0!"},1.384090407663024,0.63364847882765207,0.16802483286178727,8.4316490801625593E-2,1912.1805332447072,944.77771925152433,3478.8472000000002,2965.0011,3830.5641000000001,2877.9126999999999,2903.7557999999999,10.710249719538048,27.902635306353375,35.291369359864071,32.979848258534133,null,580.48159999999996,1.9406932097599241]
[null,null,{"$error":"#DIV/0!"},1.1097966681713669,0.70623609644313845,0.15681874771733814,8.3699801136931512E-2,2027.9604254165786,938.38246400837352,3539.0455000000002,2777.2799,3409.3955999999998,2592.0619999999999,2532.3508000000002,9.5148290191261466,24.760771655779688,34.514693787275611,35.864946492256522,null,643.8021,2.1523892715826198]
[null,null,{"$error":"#DIV/0!"},1.2650592229543443,0.68426134726015775,0.1828774365215359,8.1070294960291833E-2,1740.3486024527015,1037.0547073734906,3380.7181,2867.6024000000002,3813.5898999999999,2848.0983000000001,2503.6979999999999,10.734196336487233,24.752221581910682,32.085998247421905,36.519357811032442,null,538.60320000000002,1.8006834927363411]
[null,null,{"$error":"#DIV/0!"},1.340553336485288,0.63556754447690889,0.1524469155207748,9.0115439126215224E-2,1728.7531104036566,874.79886444979832,3290.2150000000001,2654.8620999999998,3963.9953999999998,2401.6797999999999,2932.4713000000002,10.581630483340808,22.076908021038861,32.29028241979352,35.322317542726125,null,615.02599999999995,2.0561837483012764]
[null,null,{"$error":"#DIV/0!"},1.2271641443382966,0.65981761079378731,0.14489266246938559,7.0971074793105368E-2,1778.8687886282767,1104.3397787370113,3269.3128000000002,2412.1169,3873.1473999999998,2473.9137000000001,2995.0920000000001,10.504261124715121,21.98310736479203,33.289281240102433,37.062946757870975,null,618.17359999999996,2.0667068883302702]
[null,null,{"$error":"#DIV/0!"},1.1702051907860804,0.72714821526040463,0.16856414052975044,7.5667928274966656E-2,1683.849328124863,1045.0378722035623,3756.3847000000001,2551.5189999999998,3389.6846999999998,2920.6588999999999,2446.4189999999999,10.778593230970152,27.176916544060909,35.28176351664748,33.721188069374023,null,559.32460000000003,1.869960234306691]
[null,null,{"$error":"#DIV/0!"},1.3938965592305519,0.60790201933212351,0.16018691970356075,9.8986689601500699E-2,1818.0434105672662,1054.2369455552252,3957.4236999999998,2689.8494999999998,2957.0499,2501.0758999999998,2587.5122000000001,10.900098408956733,24.155193830160044,30.372007283464015,34.616680282510629,null,564.05809999999997,1.8857855131650276]
[null,null,{"$error":"#DIV/0!"},1.3912264155031875,0.74406156808095492,0.19202887197380109,7.1765924602899434E-2,1614.7636734898103,1027.675648340447,3812.7638000000002,2980.9771000000001,3587.1777000000002,2505.7337000000002,2855.6469000000002,9.6622260545992518,20.663735920425026,37.88391161529281,38.809642202891133,null,753.16319999999996,2.5180105561716357]
[null,null,{"$error":"#DIV/0!"},1.2942543052137268,0.67930522143968863,0.17254583429291614,8.3326404179338509E-2,1864.8712467281737,908.58406558777324,3654.6291000000001,2388.1885000000002,3157.1923999999999,2414.2084,2842.1462000000001,9.1969254105100777,23.681061083270649,34.971301171234018,33.458161427794423,null,693.50279999999998,2.3185510293611875]
[null,null,{"$error":"#DIV/0!"},1.2901384854438762,0.63637944827963022,0.15125604582163132,8.7729316272863636E-2,1668.1877206906697,880.16463241374186,3299.9346,3027.3218999999999,3710.047,2848.6442999999999,3115.4095000000002,8.1524779946207371,25.064172591775755,35.749271884763942,33.43129958816791,null,614.61159999999995,2.0547984894283844]
[null,null,{"$error":"#DIV/0!"},1.2546686842223147,0.59453386138750086,0.18026901941167306,9.5365865712235584E-2,1899.5343613045793,794.93201319951697,3505.9465,2292.9733000000001,2908.4124999999999,2576.9856,2398.2312000000002,8.2264590439785934,28.80290800575948,34.239705604870771,37.09533480126445,null,574.61969999999997,1.921095437479108]
[null,null,{"$error":"#DIV/0!"},1.10321380868038,0.74605797729248369,0.17733155043330159,8.9650946535042658E-2,1929.108629474867,1050.7930141516852,3385.5073000000002,2428.1291000000001,3809.5232999999998,2563.4866000000002,2705.1237000000001,10.610140781068088,28.725147757490074,38.234818221847995,35.509497851776004,null,527.04100000000005,1.7620281560620734]
[null,null,{"$error":"#DIV/0!"},1.2762692629013646,0.70770978177783839,0.15271370279533697,8.327003715981908E-2,1615.5637684014548,1048.2981049469938,3233.2186999999999,2993.3287999999998,3641.1012999999998,2868.9285,3173.0988000000002,10.879682213094814,25.207217120227799,33.725609042228278,38.72773575614319,null,478.36369999999999,1.5992881408579807]
[null,null,{"$error":"#DIV/0!"},1.2800807793378113,0.71343278210152739,0.16075176732822105,9.3955069686149473E-2,1703.2191783176211,1063.167363127543,3672.0030999999999,2869.5513999999998,3346.7728999999999,2557.3498,2429.9533000000001,10.54174041513145,21.23762653255114,31.210914529867033,34.923326247541539,null,593.22460000000001,1.983296284174106]
[null,null,{"$error":"#DIV/0!"},1.3345774801758863,0.62127017769703774,0.15772582527680426,9.1256794993019627E-2,1593.144975967906,773.37377302568336,3993.2622999999999,2638.4711000000002,3520.0578,2682.0488,2909.5019000000002,10.501989480425793,26.666949672400555,36.301992722674129,35.260027697592918,null,676.30669999999998,2.2610603733860857]
[null,null,{"$error":"#DIV/0!"},1.4437395566682847,0.6446897269777907,0.15597662720899452,7.7318991492524955E-2,1969.8668250783755,943.59848341572069,3534.99,2297.7507000000001,3546.2876000000001,2603.0189999999998,2711.0365000000002,9.1681560508474202,26.55544904830829,37.52292142935196,33.321841936771946,null,644.77239999999995,2.1556333535724481]
[null,null,{"$error":"#DIV/0!"},1.4029529482387255,0.72813008593735673,0.19118189236643632,7.6763756192170823E-2,1972.2147989197499,877.19792149551176,3725.277,2653.1651000000002,3710.6711,2956.9101000000001,2681.4594999999999,10.238329790248708,26.212540959851644,38.104976806877019,30.893725814598564,null,607.83590000000004,2.0321453936439178]
[null,null,{"$error":"#DIV/0!"},1.4151434065288928,0.63537587561741782,0.18124564961839007,8.1734294174842154E-2,2017.4379155121378,780.54218911254895,3532.3314,2344.2458999999999,3747.6007,2633.6707000000001,2409.9479999999999,10.005119212692655,28.598967468491818,35.698050749876288,32.270441695248387,null,663.86069999999995,2.2194503272931181]
[null,null,{"$error":"#DIV/0!"},1.3731766380390567,0.58674937353498269,0.16491140972914728,7.7491017402656126E-2,2169.8090149031459,975.9429542389629,3019.2386000000001,2646.5088999999998,3729.0898999999999,2332.6902,2845.6936999999998,8.7415011054857157,19.626321637376641,36.811304343738392,35.752045351448935,null,613.29089999999997,2.0503827901260538]
[null,null,{"$error":"#DIV/0!"},1.440110277782821,0.62675986201563338,0.1724964780876562,7.7013751079351683E-2,1824.7068893709454,938.10601800435734,3506.6417000000001,2561.0953,3473.3101000000001,2635.3209000000002,2747.1552000000001,9.1209157949375133,26.588373193677221,34.035553084394145,35.997985000904457,null,557.52149999999995,1.8639320472936487]
[null,null,{"$error":"#DIV/0!"},1.324900086389754,0.70849162422258272,0.1763441386733188,7.5200728416778315E-2,1784.3366496488545,878.53551144584731,3051.5295000000001,2933.3885,3840.4303,2535.7397000000001,2821.5122999999999,8.6625729779958931,22.653162960951917,37.91458037487169,35.41530149097548,null,651.05079999999998,2.1766237728926998]
[null,null,{"$error":"#DIV/0!"},1.3168689038190911,0.69528468327864168,0.18728026959394911,8.7169131062349081E-2,2112.7296015731495,887.565372049144,3878.2345999999998,2640.3247000000001,3055.8238999999999,2397.4346,2622.9205000000002,10.768808419381122,25.689467581019983,36.481692985847893,34.70001498604401,null,543.99649999999997,1.8187147495311884]
[null,null,{"$error":"#DIV/0!"},1.1772795907835103,0.69266312441174493,0.19590225795735908,9.2443928918745921E-2,2069.3407410192126,802.05742868761035,3188.5481,2497.4774000000002,3405.1088,2424.5652,2734.8348999999998,10.875184882460978,28.554328924570946,35.644606821456946,34.25532328123451,null,648.12120000000004,2.1668293266918162]
[null,null,{"$error":"#DIV/0!"},1.2560195131129794,0.62375630241698699,0.16459531166556737,8.3596901476270788E-2,1881.7449963405948,997.70264416341229,2933.3406,2690.4506999999999,4167.0547999999999,2360.7239,2537.1570000000002,10.72218818513463,20.312826851114703,32.904174927878024,34.701888828098831,null,499.1943,1.6689299784431713]
[null,null,{"$error":"#DIV/0!"},1.3984787736530324,0.62264356795448328,0.15998712813805335,8.9505845058329966E-2,1820.1742719311098,883.71918559248695,3533.2089000000001,2768.5657999999999,2954.3213000000001,2909.5979000000002,2973.9740999999999,10.351889634348939,27.904368690654827,36.192634400097553,31.507625648085437,null,532.07029999999997,1.7788425901242788]
[null,null,{"$error":"#DIV/0!"},1.2248911301287089,0.61274340726002119,0.16634328429135065,7.1350151870176265E-2,1832.7471024048284,995.86923110619546,3350.6498000000001,2675.2800999999999,3719.6502999999998,2660.8072000000002,2953.6446999999998,10.880288304436027,21.737070107000761,33.523313172027507,36.429885614030098,null,616.91600000000005,2.0625024061206947]
[null,null,{"$error":"#DIV/0!"},1.2400821525699599,0.58370865898689261,0.17958650591894701,8.9439232832559779E-2,1921.0294046936349,1016.8336236292612,3601.9555,2979.4321,3470.9956000000002,2706.3361,2999.4783000000002,8.6764799666380252,30.513165642121518,39.315633243498262,32.574181681991874,null,575.17340000000002,1.9229465816555917]
[null,null,{"$error":"#DIV/0!"},1.4479605127269217,0.71464298070877796,0.16595704397808131,7.3729063136044937E-2,1680.4359817150782,1035.3513458216376,3385.9427000000001,2572.2627000000002,4110.1517000000003,2232.6752000000001,2507.9097999999999,9.3393600790955631,24.461944441198867,33.469176829173826,34.754420800825713,null,544.41650000000004,1.8201187190062058]
[null,null,{"$error":"#DIV/0!"},1.185736673181248,0.60873257157834959,0.19599516064215303,7.6144610859275166E-2,1885.3924089587997,1049.1836289690846,3615.8283000000001,2829.0616,3128.5045,2901.4920000000002,2518.8188,10.683997886132573,26.566832670585804,35.024535419002262,35.093539692962075,null,660.95830000000001,2.2097466865097619]
[null,null,{"$error":"#DIV/0!"},1.3066817258606613,0.77589690384380638,0.19009765404492882,9.5252040354646308E-2,2058.3897469376352,1028.7985502337926,3487.3240000000001,2544.3353999999999,3352.5504999999998,2617.6082999999999,2749.3571999999999,9.7762840228779524,25.62838315653913,36.027094385953205,36.65204748078316,null,559.37059999999997,1.8701139956762429]
[null,null,{"$error":"#DIV/0!"},1.1856878406250351,0.68539016062696778,0.18203790085372498,7.2278537032670523E-2,2110.1607695178159,1018.4012321417714,3498.9096,2780.4609999999998,3658.9744999999998,2540.1446999999998,2715.8816999999999,10.219487385437954,29.002674372282303,33.881117007498908,31.316466737385788,null,617.40239999999994,2.0641286874455154]
[null,null,{"$error":"#DIV/0!"},1.3083599900395053,0.72608068914126089,0.15490062510888311,8.5084999469969877E-2,1708.2940441643443,1017.1810278462731,3249.5302000000001,2640.2838999999999,3778.8485000000001,3035.3018000000002,2757.8287,10.932452439704472,23.21974142361028,39.340230351397771,30.651542133982204,null,584.89390000000003,1.9554448136397526]
[null,null,{"$error":"#DIV/0!"},1.2977183769090652,0.69016979336339623,0.17436079697523607,8.4288424048923907E-2,1822.8717982740002,1046.3598973600897,3602.5120000000002,2318.4063999999998,3554.9722000000002,2515.7085999999999,2547.2800999999999,9.8399959379061137,28.498755192606581,35.576052213946042,33.708431583675868,null,538.21339999999998,1.7993801756109684]
[null,null,{"$error":"#DIV/0!"},1.3133241175608283,0.61481553770422859,0.1624789538791597,8.6070826229072028E-2,2088.1609231779689,943.59397663542291,3691.8105,2615.7862,3450.6801,2553.9958999999999,2629.4313000000002,9.6680203689087172,30.148472477557807,35.596636195872975,31.639744874875262,null,584.47640000000001,1.9540489755063544]
[null,null,{"$error":"#DIV/0!"},1.5349466433614836,0.67568530334827104,0.18015604891351147,8.2441644198892522E-2,2039.0904311515703,1055.0547761460648,3721.4418000000001,2721.9047,3734.8386,2630.2721000000001,2797.2727,9.7008753916006469,23.332410359573487,34.252884694661901,38.451802253919418,null,604.69860000000006,2.0216567785302724]
[null,null,{"$error":"#DIV/0!"},1.536249962904382,0.63371476960635131,0.18769773008046822,9.1697259238614603E-2,2199.741282177908,999.89841954802387,3082.9043999999999,2414.3346000000001,3415.9796999999999,2352.6934000000001,3100.03,9.2061831899460458,20.482641225444851,35.744440976263462,34.908232836355289,null,773.7491,2.5868342912468298]
[null,null,{"$error":"#DIV/0!"},1.4468447076887261,0.57597707678452992,0.16079062144383763,8.8868202679542693E-2,1862.1587396588898,947.28291865427445,3399.2602000000002,2597.2930000000001,3469.7256000000002,2857.7755000000002,2683.0147999999999,10.43879708407772,23.520497058414271,31.999625648158144,31.995951634718978,null,653.05240000000003,2.1833155917010534]
[null,null,{"$error":"#DIV/0!"},1.3497422277180022,0.70031059976067211,0.17003449895759776,7.6373851343478738E-2,2036.4830155060586,1006.1122720291421,3802.605,2638.2678999999998,3405.9180999999999,2366.2103000000002,2728.6619999999998,9.9924667044762252,25.871401732066087,36.392028468661259,36.102517590984398,null,664.76919999999996,2.222487567171656]
[null,null,{"$error":"#DIV/0!"},1.5473192857208182,0.66988587520295984,0.15510263785672052,9.0635764274963532E-2,1661.6462340529604,976.46447651179687,3796.9657999999999,2285.3472000000002,3081.6781000000001,2835.6305000000002,2733.9439000000002,11.053891940082925,23.817667121472638,36.360266965279287,36.217355981712736,null,656.03319999999997,2.1932808661910639]
[null,null,{"$error":"#DIV/0!"},1.2657434876146831,0.59323436085871295,0.18020845581367576,8.632769795999401E-2,2019.8039846317263,963.55406673522907,3738.8418999999999,2384.3721,3869.9753999999998,2878.7199000000001,3019.7579999999998,9.1854970743157285,23.311314055049195,37.023378583864989,35.057607843744307,null,702.21900000000005,2.3476916236825787]
[null,null,{"$error":"#DIV/0!"},1.3874107562565114,0.70250239742572962,0.15555804774832263,9.5211696753362454E-2,2181.6917078924052,1063.3443540855442,3676.7710999999999,2659.9106999999999,2990.8051999999998,2643.2473,2836.6759000000002,9.0177800603351681,20.490219154939759,35.715262534949204,36.448383358938727,null,611.89919999999995,2.0457303135280154]
[null,null,{"$error":"#DIV/0!"},1.0798669274768815,0.60457776914436323,0.17273969849372492,7.3565128793256329E-2,1720.829669255975,865.62993065780756,3680.1992,2882.1694000000002,3128.4994000000002,2559.6997000000001,2706.3092999999999,10.106209782864445,22.980307292320092,35.823100117506741,35.79108417538928,null,688.71230000000003,2.3025352634906531]
[null,null,{"$error":"#DIV/0!"},1.3963628573022933,0.62323145944402425,0.17834786719192364,9.0399094547133158E-2,1930.9514356930581,891.93758477735582,3597.7586000000001,2851.2719000000002,4016.9794000000002,2736.7689999999998,2594.6012000000001,9.0598318060682494,23.46757397063126,37.47254204123859,37.605322980500119,null,510.97190000000001,1.7083051260564621]
[null,null,{"$error":"#DIV/0!"},1.267894265100894,0.70575530389779528,0.17206620803361894,9.3640186789137714E-2,1737.8433760135026,855.68445060404599,3400.6795000000002,2662.7820000000002,4142.1405000000004,2513.2822000000001,2859.5733,10.387231595509242,27.528736634669961,38.583183511682975,30.854003609551533,null,635.03229999999996,2.1230696695992077]
[null,null,{"$error":"#DIV/0!"},1.3688638288674626,0.56833136909679616,0.17004703836851068,9.3321153442089771E-2,1878.2605317570833,911.85415074623688,3272.9495999999999,2988.7408,3666.2337000000002,2419.6587,2717.8597,9.1422598394870001,23.969356402527175,31.93207188571602,38.512099769484166,null,548.90970000000004,1.8351405468773221]
[null,null,{"$error":"#DIV/0!"},1.1835548220097252,0.72704653783125339,0.19751454150176692,8.5023301762845727E-2,1882.6947016915126,1013.6642170951724,3515.3447999999999,2964.4445999999998,3883.1817999999998,2473.2907,2454.6559000000002,9.032593407350836,25.090878254149402,36.09209152063805,35.079664887206022,null,623.45069999999998,2.0843495734534234]
[null,null,{"$error":"#DIV/0!"},1.1455955788657692,0.61153018378407109,0.16278950996556008,8.7046157589682233E-2,1637.3021312791111,927.3669467070207,3650.4946,2754.0360000000001,3417.8946999999998,2944.4404,3179.9025000000001,10.931074412364344,29.296313480387241,34.583311476913373,34.507495685015613,null,580.35249999999996,1.9402616570858637]
[null,null,{"$error":"#DIV/0!"},1.2180741486317546,0.70038541918744168,0.17575247534548272,9.0533616685072427E-2,2128.691263033279,859.36770216774903,3462.6161000000002,2367.8719000000001,3013.5279999999998,2602.0774000000001,2716.9155999999998,9.8531953635015306,24.477595690184749,37.760680094324506,33.126487226617471,null,547.46590000000003,1.8303138297058721]
[null,null,{"$error":"#DIV/0!"},1.5163668152268557,0.68214202378166799,0.17345641579000695,7.6228743252513637E-2,2074.916346965967,1037.0567272144617,3754.8299000000002,2712.0399000000002,3062.9114,2609.8011000000001,2659.7777999999998,9.6247075380819442,27.028720002360057,32.334582145715373,37.502459645402936,null,529.24329999999998,1.7693910659189065]
[null,null,{"$error":"#DIV/0!"},1.1665661884663194,0.67013189225721559,0.1711926893718255,0.10048340230559903,1950.4477227802536,945.93431421188939,3780.1444000000001,2815.3788,3960.2078999999999,2241.6037000000001,3223.6759000000002,10.548983538921849,28.668595010275077,33.665350200651417,34.692767411533559,null,767.0127,2.5643128148615855]
[null,null,{"$error":"#DIV/0!"},1.1423721523348054,0.62413326518004431,0.19650287392561419,9.2024540793877133E-2,2086.9850560925001,899.50614993106717,3560.1505000000002,2265.6109000000001,3340.3591000000001,2821.9679999999998,3158.9731000000002,9.4709394440779135,21.759780797971921,34.780768345583979,37.166922092898723,null,627.63160000000005,2.0983274663533296]
[null,null,{"$error":"#DIV/0!"},1.2187649455679526,0.72836846235278907,0.17301703798071535,8.83639474144301E-2,1916.7063478164355,897.84494840199659,3896.3094000000001,2954.3919000000001,3534.6462999999999,2884.9681999999998,2471.0767999999998,10.189808173745721,20.018425167921166,33.783874690638918,34.78696848143727,null,566.30870000000004,1.8933098691283585]
[null,null,{"$error":"#DIV/0!"},1.1328653188435931,0.69264530686035941,0.16879346426607372,7.2666886735156172E-2,1776.3307595852898,1088.9662332861071,3719.0664999999999,2915.2584999999999,3636.2741999999998,2703.8047999999999,2947.7289999999998,10.28976120377774,23.710841646651936,38.580352074668724,39.378165501346814,null,674.24649999999997,2.2541724249161659]
[null,null,{"$error":"#DIV/0!"},1.3710711814668812,0.63906180364930798,0.15258581328487553,9.1308744525445101E-2,1702.2504237644359,950.92709461451454,3813.6277,2729.3155999999999,3641.5531000000001,2246.3440000000001,2918.6295,10.067259908829126,25.490654540522243,34.561964100175445,36.335845025895772,null,549.22370000000001,1.8361903958245964]
[null,null,{"$error":"#DIV/0!"},1.3475948247386733,0.7639127206853259,0.1793803849117184,9.1551271238822354E-2,2046.7790011818938,969.37006042784469,3485.6873000000001,3070.3247999999999,3653.8368999999998,2728.7532000000001,2921.6936999999998,9.3184773303064166,23.448908478514099,35.48015834469966,32.197882206071725,null,675.57659999999998,2.2586192835930472]
[null,null,{"$error":"#DIV/0!"},1.3192625085259677,0.69017926594531664,0.16535436063820377,9.867011685588882E-2,1895.7774501115696,881.48115225013544,3294.0679,2836.5605,3753.0992999999999,2342.4756000000002,2601.4609999999998,10.785310781578071,26.934688858860603,31.790067487068313,35.719851805834992,null,687.77650000000006,2.2994067065190467]
[null,null,{"$error":"#DIV/0!"},1.2550049045786449,0.6753555239558221,0.15823974497465818,9.3677623543390945E-2,1723.7928132971911,818.03961315844913,3644.4405000000002,2774.0770000000002,3248.2705999999998,2507.9117000000001,2935.3398000000002,8.7059287854565781,19.484580532578974,33.062093199633097,34.727760769520749,null,617.06190000000004,2.0629903476076246]
[null,null,{"$error":"#DIV/0!"},1.2851520225800783,0.65003940702768714,0.19616042989417695,8.3992545149014997E-2,1860.7147331576084,861.86674478042517,3444.3184000000001,2825.2266,3678.1315,2682.6895,2974.3164000000002,8.9163635593883068,27.453500536758742,31.146544541425772,32.381041162604049,null,641.19550000000004,2.1436748320100358]
[null,null,{"$error":"#DIV/0!"},1.1842118478753227,0.76006919892611369,0.19482147218994275,8.0727585308161182E-2,1818.9445140075265,972.03346662527701,3774.5716000000002,2789.6707000000001,3638.5832999999998,2558.3200000000002,2873.8649,10.163039147451162,24.788968282993672,34.132285230213569,32.738572681237557,null,652.13469999999995,2.1802474417423636]
[null,null,{"$error":"#DIV/0!"},1.178435560519816,0.70772903049069713,0.15653725594291881,9.4430198470502769E-2,1958.8720075475862,1069.2965541638546,3892.7224000000001,2396.2714000000001,3706.9312,2749.3989000000001,2631.7192,9.5250960877128961,25.003875196539866,37.842132288383795,35.042269051042268,null,647.36760000000004,2.1643098391313895]
[null,null,{"$error":"#DIV/0!"},1.1409002350025053,0.6429797495557229,0.1635043903255263,8.3052603613626402E-2,1994.024173866884,1094.0079649738118,3114.6399000000001,2348.3587000000002,3569.3218999999999,2890.0009,2331.2287000000001,8.2578200112019609,26.247085434625923,34.42232110564796,37.211219267305246,null,572.03120000000001,1.912441584000421]
[null,null,{"$error":"#DIV/0!"},1.3655428441367277,0.61251343367740607,0.16952433562565339,9.1280253855736737E-2,1784.6864565111682,1092.9262396188326,2907.5227,2614.0502000000001,3651.4295999999999,2458.5029,2580.4133000000002,9.9519661195725764,19.856010313874975,36.041120336057737,33.171855606238665,null,459.80119999999999,1.5372290879810102]
[null,null,{"$error":"#DIV/0!"},1.2685496641411915,0.61668706612649959,0.16774693716915431,8.5953662320689142E-2,1807.0002980917056,1021.2334733828952,3664.2031000000002,2673.5636,3116.0578,2497.076,2653.6080999999999,9.881179661073741,23.813720543538793,35.552672682854947,31.195383239482418,null,528.94449999999995,1.7683920447377821]
[null,null,{"$error":"#DIV/0!"},1.2258469905323661,0.64265916472700291,0.16760782424815154,8.4630960360091947E-2,1986.9390372895755,973.17352639441401,3059.2426,2864.5050000000001,3589.8197,2732.0034000000001,2754.5466000000001,8.8713466288170295,28.059660081580816,33.844298045619738,37.844432938627122,null,595.00109999999995,1.989235772356559]
[null,null,{"$error":"#DIV/0!"},1.3583176901733425,0.60273068190898993,0.19173898291463096,8.3949370739154511E-2,1861.290150580395,944.92081919177008,3699.0545000000002,2676.2737999999999,3323.6689999999999,2695.1763999999998,3059.7426999999998,9.565345844182005,27.363901628790963,30.650975682940501,36.922640383345041,null,519.74019999999996,1.7376197797598347]
[null,null,{"$error":"#DIV/0!"},1.2779100628109707,0.6763163977849882,0.15857264291407983,8.8721069392606169E-2,1655.7293200464003,937.05024175064682,3464.1921000000002,2417.8800999999999,3810.6675,2470.5754999999999,2759.2932000000001,10.724588469512234,19.117877640702801,31.196928234191951,35.74653338373583,null,705.75419999999997,2.3595107515031475]

{"sheet":"1.START","index":3,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[10,0,14,12],[19,11,21,13]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Return On Investment Calculator\n for Person-Centered Care Program"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Once opened, press CTRL and the Contents Item to move to that section."]

{"sheet":"2.Flow","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"3.Population Data","index":5,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["3. Eligible Population",2000,"Members"]
[]
["Levels of Utilization"]
[null,"Group","Percentage Cut Off","Range","Level Members","Test Group"]
["Most Severe Members","Level 1",0.1,{"$f":"IF(ISNUMBER(C5),\"0 to \"&TEXT(C5,\"##%\"),\"\")","v":"0 to 10%"},{"$f":"IF(TESTONLY,F5,IFERROR('3.Population Data'!C5*'3.Population Data'!B1,0))","v":200},null,null,null,null,null,false,{"$f":"\"0 to \" & TEXT(F5/B1,\"##.#%\")","v":"0 to .%"}]
["Next Most Severe Members","Level 2",0.2,{"$f":"IF(E6=0,\"\",TEXT(C5,\"##%\")  & \" to \" & TEXT(C6,\"##%\"))","v":"10% to 20%"},{"$f":"IFERROR(IF(OR(TESTONLY=TRUE,C6=0),0,'3.Population Data'!B1*('3.Population Data'!C6-'3.Population Data'!C5)),0)","v":200}]
[null,null,null,"Total Members Targeted",{"$f":"IF(K5,F5,E5+E6)","v":400}]

{"sheet":"4.Costs","index":6,"n_rows":61,"n_cols":5,"rows_kept":61,"cut":false,"hidden":false,"merged":[[0,1,0,2]]}
[null,"4a. Launch Costs"]
[null,"(one time charges to start-up PCC)"]
[null,"Item","Amount"]
[null,"Training",50000]
[null,"Equipment",25000]
[null,"Other",25000]
[null,"Recruitment",25000]
[null,"Remodel/Costruction",15000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total Launch Costs",{"$f":"SUM(C4:C18)","v":140000}]
[]
[]
[null,"4b. Operating Costs",null,"Target Population set at:",{"$f":"'3.Population Data'!E7","v":400}]
[null,{"$f":"\"Fixed Costs for PCC\"","v":"Fixed Costs for PCC"}]
[null,"Position","FTE","Annual Cost","Annual Program Cost"]
[null,"Program Director",1,150000,{"$f":"IFERROR(IF(C25=\"\",1,C25)*D25,0)","v":150000}]
[null,"Medical Director",0.5,200000,{"$f":"IFERROR(IF(C26=\"\",1,C26)*D26,0)","v":100000}]
[null,"Nurse Practitioner",2,95000,190000]
[null,"Social Worker",2,42000,84000]
[null,"Medical Assistant",1,45000,45000]
[null,"Pharmacist",0.5,120000,60000]
[null,"Mental Health Liaison",0.1,175000,17500]
[null,null,null,1000,1000]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,"Total Fixed Costs",{"$f":"SUM(E25:E39)","v":647500}]
[]
[null,null,"Overhead %",0.1,{"$f":"IFERROR(E40*D42,0)","v":64750}]
[null,null,null,"Total Fixed Costs with O/H",{"$f":"E40+E42","v":712250}]
[null,null,null,"PMPM FC",{"$f":"IFERROR(E43/12/E22,0)","v":148.38541666666666}]
[]
[]
[null," 4c. Variable Costs for Direct Services","Per Member per Month"]
[null,"Item","PMPM"]
[null,"Mileage",36]
[null,"Supplies",8]
[null,"Other",36]
[null,"Misc",11]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C49:C58)","v":91}]
[null,"Overhead as a percent of Total Var.Costs",0.1,{"$f":"IFERROR(C60*C59,0)","v":9.1}]
[null,null,"Average Variable Costs with overhead  PMPM",{"$f":"C59+D60","v":100.1}]

{"sheet":"5.Additional Utilizations","index":7,"n_rows":19,"n_cols":15,"rows_kept":19,"cut":false,"hidden":false,"merged":[[2,5,3,5],[1,2,3,2],[0,1,0,5]]}
[null,"5. Additional Utilizations"]
[null,"Increases in Utilization","Time Period: Day, Month, Year"]
[null,null,null,null,null,{"$f":"\"Percent of \" & TEXT('3.Population Data'!E7,\"#\") & \" Members Served\"","v":"Percent of 400 Members Served"}]
["Exclude from Analysis","Service",null,"Costs Per","Added Units",null,"Weighted PMPM"]
[null,"Behavioral Health","Year",125,2,0.45,{"$f":"IFERROR(IF(C5=\"Year\",1/12,IF(C5=\"day\",30,1))*E5*D5*F5*(1-N5),0)","v":9.375},null,null,null,null,null,false,{"$f":"IF(M5,1,0)","v":0}]
[null,"Rehabilitation Services","Month",85,1,0.25,{"$f":"IFERROR(IF(C6=\"Year\",1/12,IF(C6=\"day\",30,1))*E6*D6*F6*(1-N6),0)","v":21.25},null,null,null,null,null,false,0,"Day"]
[null,"Home Delivered Meals","Month",10,6,0.1,0,null,null,null,null,null,true,{"$f":"IF(M7,1,0)","v":1},"Month"]
[null,"In-Home Modifications","Year",1000,1,0.6,0,null,null,null,null,null,true,1,"Year"]
[null,"Caregiver Education & Support","Month",25,1,0.5,12.5,null,null,null,null,null,false,0]
[null,"Transport to Appointments","Month",25,1,0.3,7.5,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,null,null,0,null,null,null,null,null,false,{"$f":"IF(M17,1,0)","v":0}]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0]
[null,null,null,null,"Total Other Services Increases",null,{"$f":"SUM(G5:G18)","v":50.625}]

{"sheet":"6.Medical Utilization","index":8,"n_rows":83,"n_cols":37,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,11,1,17],[0,11,0,17],[15,11,15,17],[14,11,14,17]]}
["6a. Medical Utilization Data",null,null,null,null,null,null,null,null,null,null,"6e. Change in Utilization"]
["Exclude from Analysis",null,"Indicates Monte Carlo Variable",null,null,null,null,null,null,null,null,"All Levels",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Savings"]
[null,"EVENT","Metric","Base Units Level 1",{"$f":"IF(TESTONLY=TRUE,\"Level 2 Units Ignored\",\"Base Units Level 2\")","v":"Base Units Level 2"},"Costs Per","Time Period","Based on Patient Count","Base Costs Level 1 PMPM",{"$f":"IF(TESTONLY=TRUE, \"Level 2 Costs Ignored\",\"Base Costs Level 2 PMPM\")","v":"Base Costs Level 2 PMPM"},null,null,null,null,null,"Percent Change","Costs Reduced Level 1 PMPM","Costs Reduced Level 2 PMPM",null,null,null,null,null,"Baseline costs1","Baseline Costs 2",null,null,null,null,null,null,"Exclude",null,null,null,"Level1","Level2"]
[null,"Primary Care","Visits",1,0.5,125,null,1,{"$f":"IFERROR(D4*$F4*$AE4/IF($H4=0,1,$H4),0)","v":125},{"$f":"IFERROR(E4*$F4*$AE4/IF($H4=0,1,$H4),0)","v":62.5},null,"-20% to +20%",null,null,null,{"$f":"IFERROR(AA4/100-0.2,0)","v":0.2},{"$f":"IFERROR(-P4*I4*NOT(AF4),0)","v":-25},{"$f":"IFERROR(-J4*P4*NOT(AF4),0)","v":-12.5},null,null,null,null,null,{"$f":"IF($AF4,0,I4)","v":125},{"$f":"IF($AF4,0,J4)","v":62.5},null,40,null,null,1,{"$f":"VLOOKUP(AD4,AG$4:AH$5,2,0)","v":1},false,1,1,null,{"$f":"IF($AF4,0,Q4)","v":-25},{"$f":"IF(NOT(TESTONLY),IF($AF4,0,R4),0)","v":-12.5}]
[null,"Specialty Care","Visits",4,2,200,null,1,{"$f":"IFERROR(D5*$F5*$AE5/IF($H5=0,1,$H5),0)","v":66.666666666666657},{"$f":"IFERROR(E5*$F5*$AE5/IF($H5=0,1,$H5),0)","v":33.333333333333329},null,"-20% to +20%",null,null,null,{"$f":"IFERROR(AA5/100-0.2,0)","v":-0.1},{"$f":"IFERROR(-P5*I5*NOT(AF5),0)","v":6.6666666666666661},{"$f":"IFERROR(-J5*P5*NOT(AF5),0)","v":3.333333333333333},null,null,null,null,null,{"$f":"IF($AF5,0,I5)","v":66.666666666666657},{"$f":"IF($AF5,0,J5)","v":33.333333333333329},null,10,null,null,2,{"$f":"VLOOKUP(AD5,AG$4:AH$5,2,0)","v":8.3333333333333329E-2},false,2,8.3333333333333329E-2,null,{"$f":"IF($AF5,0,Q5)","v":6.6666666666666661},3.333333333333333]
[null,"Emergency Dept.","Visits",1890,945,2800,null,1000,441,220.5,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA6)/100,0)","v":-0.35},154.35,77.174999999999997,null,null,null,null,null,441,220.5,null,25,null,null,2,8.3333333333333329E-2,false,null,null,null,154.35,77.174999999999997]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA7)/100,0)","v":0},0,0,null,null,null,null,null,0,0,null,60,null,null,2,8.3333333333333329E-2,false,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,0,0,null,null,null,null,null,0,0,null,60,null,null,2,8.3333333333333329E-2,false,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,0,0,null,null,null,null,null,0,0,null,60,null,null,2,8.3333333333333329E-2,true,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,0,0,null,null,null,null,null,0,0,null,60,null,null,2,8.3333333333333329E-2,true,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,0,0,null,null,null,null,null,0,0,null,60,null,null,2,8.3333333333333329E-2,true,null,null,null,0,0]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,0,0,null,null,null,null,null,0,0,null,60,null,null,2,8.3333333333333329E-2,true,null,null,null,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Members"]
[null,"6b. Inpatient Events",null,null,null,null,null,null,null,null,null,"6f. Change in Utilization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(TESTONLY,'3.Population Data'!F5,'3.Population Data'!E5)","v":200},{"$f":"IF(TESTONLY,0,'3.Population Data'!E6)","v":200}]
[null,null,null,null,null,null,null,null,null,null,null,"All Levels"]
["Exclude from Analysis","Events","Base Level 1",{"$f":"IF(TESTONLY=TRUE,\"Level 2 Units Ignored\",\"Base Level 2\")","v":"Base Level 2"},null,null,"Time Period","Based on Patient Count","Base Level 1 PMPM",{"$f":"IF(TESTONLY=TRUE,\"Level 2 Units Ignored\",\"Base Level 2 PMPM\")","v":"Base Level 2 PMPM"},null,null,null,null,null,"Percent Change","Costs Reduced Level 1 PMPM","Costs Reduced Level 2 PMPM",null,null,null,null,null,null,null,null,null,null,{"$f":"RETURNONINV","v":2.0568065875025248},{"$f":"'8a.Summary'!D36","v":1.5}]
[null,"Hospital Admissions",1.33,0.66500000000000004,null,null,null,1,{"$f":"IFERROR(basehospday*C25*V18*(1-AF18),0)","v":2521.4583333333335},{"$f":"IFERROR(W18*D25*D32*(1-AF18),0)","v":581.875},null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA18)/100,0)","v":-0.25},{"$f":"IFERROR(I18-(X18*X25*X32),0)","v":1074.7716145833333},{"$f":"IFERROR(J18-(Y18*Y25*Y32),0)","v":248.02421874999999},null,null,null,{"$f":"C18/(IF($H18=0,1,$H18)*IF($AD18=2,12,1))","v":0.11083333333333334},{"$f":"D18/(IF($H18=0,1,$H18)*IF($AD18=2,12,1))","v":5.541666666666667E-2},{"$f":"+(1+$P18)*V18*(1-$AF18)","v":8.3125000000000004E-2},4.1562500000000002E-2,null,35,null,null,2,null,false,null,null,null,{"$f":"IF($AF18,0,K18)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF18,0,R18),0)","v":248.02421874999999}]
[null,"Hospital Readmissions",0.17,8.5000000000000006E-2,null,null,null,1,{"$f":"IFERROR(C33*C26*V19*(1-AF19),0)","v":297.5},{"$f":"IFERROR(W19*D26*D33*(1-AF19),0)","v":65.078125000000014},null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA19)/100,0)","v":-0.25},{"$f":"IFERROR(I19-(X19*X26*X33),0)","v":126.80937499999996},27.739550781250017,null,null,null,{"$f":"C19/(IF(H19=0,1,H19)*IF(AD19=2,12,1))","v":1.4166666666666668E-2},{"$f":"D19/(IF($H19=0,1,$H19)*IF($AD19=2,12,1))","v":7.0833333333333338E-3},1.0625000000000001E-2,5.3125000000000004E-3,null,35,null,null,2,null,false,null,null,null,{"$f":"IF($AF19,0,K19)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF19,0,R19),0)","v":27.739550781250017}]
[null,"Skilled Nursing Admissions",0.33,0.16500000000000001,null,null,null,1,{"$f":"IFERROR(C34*C27*V20*(1-AF20),0)","v":165},46.40625,null,"-60% to 0%",null,null,null,-0.15,{"$f":"IFERROR(I20-(X20*X27*X34),0)","v":64.02},18.005625000000002,null,null,null,{"$f":"C20/(IF(H20=0,1,H20)*IF(AD20=2,12,1))","v":2.75E-2},{"$f":"D20/(IF($H20=0,1,$H20)*IF($AD20=2,12,1))","v":1.375E-2},2.3375E-2,1.16875E-2,null,45,null,null,2,null,false,null,null,null,{"$f":"IF($AF20,0,K20)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF20,0,R20),0)","v":18.005625000000002}]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,{"$f":"IFERROR(I21-(X21*X28*X35),0)","v":0},0,null,null,null,{"$f":"C21/(IF(H21=0,1,H21)*IF(AD21=2,12,1))","v":0},{"$f":"D21/(IF($H21=0,1,$H21)*IF($AD21=2,12,1))","v":0},0,0,null,60,null,null,2,null,false,null,null,null,{"$f":"IF($AF21,0,K21)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF21,0,R21),0)","v":0}]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,0,{"$f":"IFERROR(I22-(X22*X29*X36),0)","v":0},0,null,null,null,{"$f":"C22/(IF(H22=0,1,H22)*IF(AD22=2,12,1))","v":0},{"$f":"D22/(IF($H22=0,1,$H22)*IF($AD22=2,12,1))","v":0},0,0,null,60,null,null,null,null,true,null,null,null,{"$f":"IF($AF22,0,K22)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF22,0,R22),0)","v":0}]
[]
[null,"6c. Length of Stay",{"$f":"C17","v":"Base Level 1"},{"$f":"D17","v":"Base Level 2"},null,"6g. Length of Stay Change"]
[null,{"$f":"IF(ISBLANK(B18),\"\",B18)","v":"Hospital Admissions"},6.5,4,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA25)/100,0)","v":-0.1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J25)*C25*(1-$AF25)","v":5.8500000000000005},{"$f":"+(1+$J25)*D25*(1-$AF25)","v":3.6},null,50]
[null,{"$f":"IF(ISBLANK(B19),\"\",B19)","v":"Hospital Readmissions"},6,3.5,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA26)/100,0)","v":-0.1},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J26)*C26*(1-$AF26)","v":5.4},{"$f":"+(1+$J26)*D26*(1-$AF26)","v":3.15},null,50,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ18:AJ22)+SUM(AJ4:AJ12)","v":136.01666666666665},{"$f":"SUM(AK18:AK22)+SUM(AK4:AK12)","v":361.77772786458331}]
[null,"Skilled Nursing Admissions",20,15,null,"-60% to 0%",null,null,null,-0.2,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J27)*C27*(1-$AF27)","v":16},{"$f":"+(1+$J27)*D27*(1-$AF27)","v":12},null,40,null,null,null,null,null,null,null,null,{"$f":"AJ15","v":200},{"$f":"AK15","v":200}]
[null,"",null,null,null,"-60% to 0%",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,60]
[null,"",null,null,null,"-60% to 0%",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,60,null,null,null,null,null,null,null,null,{"$f":"SUMPRODUCT(AJ26:AK26,AJ27:AK27)/SUM(AJ27:AK27)","v":248.89719726562495}]
[]
[null,"6d. Average Daily Costs","Base Level 1",{"$f":"D24","v":"Base Level 2"},null,"6h. Average Cost per Day Change"]
[null,{"$f":"IF(ISBLANK(B18),\"\",B25)","v":"Hospital Admissions"},3500,2625,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA32)/100,0)","v":-0.15},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J32)*C32*(1-$AF32)","v":2975},{"$f":"+(1+$J32)*D32*(1-$AF32)","v":2231.25},null,45]
[null,{"$f":"IF(ISBLANK(B19),\"\",B26)","v":"Hospital Readmissions"},3500,2625,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA33)/100,0)","v":-0.15},null,null,null,null,null,null,null,null,null,null,null,null,null,2975,2231.25,null,45]
[null,"Skilled Nursing Admissions",300,225,null,"-60% to 0%",null,null,null,-0.1,null,null,null,null,null,null,null,null,null,null,null,null,null,270,202.5,null,50]
[null,"",null,null,null,"-60% to 0%",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,60]
[null,{"$f":"IF(ISBLANK(B22),\"\",B29)","v":""},null,null,null,"-60% to 0%",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,60]
[]
[null,"6i. Total Medical Utilization Savings",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total PMPM","Lev1","Lev2"]
[null,null,null,"Level 1","Level 2","Weighted",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Base",{"$f":"SUM(I18:I22)+SUM(I4:I12)","v":3616.625},{"$f":"IF(TESTONLY=TRUE,0,SUM(J18:J22)+SUM(J4:J12))","v":1009.6927083333333}]
[null,null,"Members",{"$f":"AJ15","v":200},{"$f":"AK27","v":200},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reduced",{"$f":"SUM(Q18:Q22)+SUM(Q4:Q12)","v":1401.61765625},{"$f":"IF(TESTONLY=TRUE,0,SUM(R18:R22)+SUM(R4:R12))","v":361.77772786458331}]
[null,null,"Baseline Costs PMPM",{"$f":"Y39","v":3616.625},{"$f":"Z39","v":1009.6927083333333},{"$f":"IFERROR(X42,0)","v":2313.1588541666665}]
[null,null,"Reduced Costs PMPM",{"$f":"Y40","v":1401.61765625},{"$f":"Z40","v":361.77772786458331},{"$f":"IFERROR(X43,0)","v":881.69769205729153},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D40*D41+E40*E41)/(D40+E40)","v":2313.1588541666665}]
[null,null,"Percent Reduction",{"$f":"IFERROR(D42/D41,0)","v":0.38754851726402378},{"$f":"IF(E41=0,0,E42/E41)","v":0.35830478409788458},{"$f":"IFERROR(F42/F41,0)","v":0.38116607965298172},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(D42*D40+E40*E42)/(D40+E40)","v":881.69769205729153}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10]

{"sheet":"7.Revenue Enhancements","index":9,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":false,"merged":[[32,1,32,2],[17,1,17,2]]}
[]
[null," Optional LTSS *"]
[null,"Option","PMPM","Select CPOs"]
[null,"Home delivered meals",10]
[null,"In Home modifications",10]
[null,"Caregiver Education & Support",5]
[null,"Transport to appointments",15]
[null,"Other",5]
[]
[]
[]
[]
[]
[null,"Total PMPM Variable Costs",{"$f":"SUMPRODUCT(C4:C13,'5.Additional Utilizations'!N7:N16)","v":20}]
[]
[]
[]
[null,"7a. Additional Benefits (Annual Based)"]
[null,"Current Target Population",{"$f":"'3.Population Data'!E7","v":400}]
[]
[null,"Benefit","Total Annual","PMPM"]
[null,"Medicare/ACO Shared Savings ",25000,{"$f":"IFERROR(C22/C$19/12,0)","v":5.208333333333333}]
[null,"CMS 30-Day Penalty Reduction",50000,{"$f":"IFERROR(C23/C$19/12,0)","v":10.416666666666666}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,"Total Additional Benefits",{"$f":"SUM(C22:C28)","v":75000},{"$f":"SUM(D22:D28)","v":15.625}]
[]
[]
[]
[null,"7b. Additional Benefits (PMPM Based)"]
[]
[]
[null,"Benefit","PMPM","Total Annual"]
[null,"Revisions to HCC",8,{"$f":"IFERROR(C37*C$19*12,0)","v":38400}]
[null,"Stipend for PCC",6,{"$f":"IFERROR(C38*C$19*12,0)","v":28800}]
[null,"Fee for Care Coordination",3,14400]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,"Total Additional Benefits",{"$f":"SUM(C37:C43)","v":17},{"$f":"SUM(D37:D43)","v":81600}]

{"sheet":"8a.Summary","index":10,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,4],[33,1,33,4]]}
[null,"8a. Summary Results"]
[null,"Eligible Population",{"$f":"'3.Population Data'!B1","v":2000}]
[null,null,"Level 1",{"$f":"IF('3.Population Data'!K5,'3.Population Data'!F5,'3.Population Data'!E5)","v":200},{"$f":"IF('3.Population Data'!K5,'3.Population Data'!L5,'3.Population Data'!D5)","v":"0 to 10%"}]
[null,null,"Level 2",{"$f":"IF('3.Population Data'!K5,0,'3.Population Data'!E6)","v":200},{"$f":"IF('3.Population Data'!K5,\"\",'3.Population Data'!D6)","v":"10% to 20%"}]
[null,null,"Total",{"$f":"D3+D4","v":400}]
[]
[null,"Launch Costs",null,{"$f":"'4.Costs'!C19","v":140000},"One Time"]
[null,null,"PMPM","All Members per Month"]
[null,"Operating Costs",{"$f":"'4.Costs'!E44","v":148.38541666666666},{"$f":"'4.Costs'!E44*D5","v":59354.166666666664}]
[]
[null,"Direct Services",{"$f":"'4.Costs'!C59","v":91},{"$f":"C11*D$5","v":36400}]
[null,"Overhead",{"$f":"'4.Costs'!D60","v":9.1},{"$f":"C12*D$5","v":3640}]
[null,null,null,null,null,null,null,null,null,{"$f":"0.8*'6.Medical Utilization'!F7","v":0}]
[null,"Additional Services",{"$f":"'5.Additional Utilizations'!G19","v":50.625},20250]
[null,null,{"$f":"SUM(C11:C14)","v":150.72499999999999},{"$f":"SUM(D11:D14)","v":60290}]
[]
[null,"Total Operating Costs",{"$f":"C9+SUM(C11:C14)","v":299.11041666666665},null,{"$f":"D15+D9","v":119644.16666666666}]
[]
[null,"Benefit Savings","PMPM","All Members per Month"]
[null,"Level 1",{"$f":"'6.Medical Utilization'!D42","v":1401.61765625},{"$f":"C20*D3","v":280323.53125}]
[null,"Level 2",{"$f":"IF('3.Population Data'!K5,0,'6.Medical Utilization'!E42)","v":361.77772786458331},{"$f":"C21*D4","v":72355.545572916657}]
[]
[null,"Additional Benefits",{"$f":"'7.Revenue Enhancements'!D29+'7.Revenue Enhancements'!C44","v":32.625},{"$f":"C23*D5","v":13050}]
[]
[null,"Total Monthly Benefits",{"$f":"IFERROR(E25/D5,0)","v":914.32269205729153},null,{"$f":"D20+D21+D23","v":365729.07682291663}]
[]
[null,"Net Benefit PMPM",{"$f":"IFERROR(E28/D5,0)","v":615.21227539062488}]
[null,"Total Net Benefit Per Month",null,null,{"$f":"E25-E17","v":246084.91015624997}]
[]
[null,"ROI",null,null,{"$f":"IFERROR(E28/E17, 0)","v":2.0568065875025248}]
[null,"Startup Payback (months)",null,null,{"$f":"IFERROR(D7/E28,0)","v":0.56890932447303633}]
[]
[]
[null,"Find the change in Hospital Admissions required to yield the ROI Goal"]
[]
[null,null,"ROI  Goal:",1.5]
[null,null,"Hospital Admissions Event Change:",-0.10969406677144548]
[null,{"$f":"IF(GOALADMITREDUX>0,\"ROI can be achieved with an Increase in Admission Events!\",\"\")","v":""}]
[]
[]
["Find the PMPM Costs needed to achieve ROI goal:"]
[null,null,"ROI  Goal:",1.5]
[null,null,"Annual Operating Costs:",{"$f":"+E25/(1+D42)","v":146291.63072916665}]
[null,null,"PMPM:",{"$f":"+D43/'3.Population Data'!E7","v":365.72907682291662}]

{"sheet":"8b.Scenario Comparison","index":11,"n_rows":34,"n_cols":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,15,1,18],[2,3,2,4],[2,10,2,11],[0,1,0,11],[2,1,2,2],[1,1,1,4],[1,8,1,11],[2,8,2,9]]}
[null,"8b. Scenario Results Comparison"]
[null,"Scenario A",null,null,null,null,null,null,"Scenario B",null,null,null,null,null,null,"Delta (Scenario B-Scenario A)"]
[null,{"$f":"IF(ISBLANK('Scen Meta'!C8),\"\",'Scen Meta'!C8)","v":"Baseline"},null,{"$f":"IF(ISBLANK('Scen Meta'!D8),\"\",'Scen Meta'!D8)","v":"2016-11-14T13:05:59"},null,null,null,null,{"$f":"IF(ISBLANK('Scen Meta'!C9),\"\",'Scen Meta'!C9)","v":"Restricted"},null,{"$f":"IF(ISBLANK('Scen Meta'!D9),\"\",'Scen Meta'!D9)","v":"2016-11-14T13:06:30"}]
[]
[null,"Eligible Population",{"$f":"INDIRECT(\"scenarios!\" & \"D\" &'Scen Meta'!$B$8)","v":2000},null,null,null,null,null,"Eligible Population",{"$f":"INDIRECT(\"scenarios!\" & \"D\" &'Scen Meta'!$B$9)","v":2000},null,null,null,null,null,"Eligible Population",{"$f":"J5-C5","v":0}]
[null,null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"e\" &'Scen Meta'!$B$8)*C5","v":200},{"$f":"INDIRECT(\"scenarios!\" & \"nx\" &'Scen Meta'!$B$8)","v":"0 to 10%"},null,null,null,null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"e\" &'Scen Meta'!$B$9)*J5","v":100},{"$f":"INDIRECT(\"scenarios!\" & \"nx\" &'Scen Meta'!$B$9)","v":"0 to 5%"},null,null,null,null,"Level 1",{"$f":"K6-D6","v":-100}]
[null,null,"Level 2",{"$f":"IF(INDIRECT(\"scenarios!\" & \"nn\" &'Scen Meta'!$B$8)=TRUE,0,INDIRECT(\"scenarios!\" & \"f\" &'Scen Meta'!$B$8)*C5-D6)","v":200},{"$f":"INDIRECT(\"scenarios!\" & \"ny\" &'Scen Meta'!$B$8)","v":"10% to 20%"},null,null,null,null,"Level 2",{"$f":"IF(INDIRECT(\"scenarios!\" & \"oa\" &'Scen Meta'!$B$9)=TRUE,0,INDIRECT(\"scenarios!\" & \"f\" &'Scen Meta'!$B$9)*J5-K6)","v":100},{"$f":"INDIRECT(\"scenarios!\" & \"ny\" &'Scen Meta'!$B$9)","v":"5% to 10%"},null,null,null,null,"Level 2",{"$f":"K7-D7","v":-100}]
[null,null,"Total",{"$f":"D6+D7","v":400},null,null,null,null,null,"Total",{"$f":"K6+K7","v":200},null,null,null,null,null,"Total",{"$f":"K8-D8","v":-200}]
[]
[null,"Launch Costs",null,{"$f":"INDIRECT(\"scenarios!\" & \"my\" &'Scen Meta'!$B$8)","v":140000},"One Time",null,null,null,"Launch Costs",null,{"$f":"INDIRECT(\"scenarios!\" & \"my\" &'Scen Meta'!$B$9)","v":140000},"One Time",null,null,null,"Launch Costs",null,{"$f":"K10-D10","v":0},"One Time"]
[null,null,"PMPM","Monthly",null,null,null,null,null,"PMPM","Monthly",null,null,null,null,null,"PMPM","Monthly"]
[null,"Operating Costs",{"$f":"INDIRECT(\"scenarios!\" & \"mz\" &'Scen Meta'!$B$8)","v":148.3854},{"$f":"INDIRECT(\"scenarios!\" & \"na\" &'Scen Meta'!$B$8)","v":59354.166700000002},null,null,null,null,"Operating Costs",{"$f":"INDIRECT(\"scenarios!\" & \"mz\" &'Scen Meta'!$B$9)","v":296.77080000000001},{"$f":"INDIRECT(\"scenarios!\" & \"na\" &'Scen Meta'!$B$9)","v":59354.166700000002},null,null,null,null,"Operating Costs",{"$f":"J12-C12","v":148.3854},{"$f":"K12-D12","v":0}]
[]
[null,"Direct Services",{"$f":"INDIRECT(\"scenarios!\" & \"nb\" &'Scen Meta'!$B$8)","v":91},{"$f":"INDIRECT(\"scenarios!\" & \"nc\" &'Scen Meta'!$B$8)","v":36400},null,null,null,null,"Direct Services",{"$f":"INDIRECT(\"scenarios!\" & \"nb\" &'Scen Meta'!$B$9)","v":91},{"$f":"INDIRECT(\"scenarios!\" & \"nc\" &'Scen Meta'!$B$9)","v":18200},null,null,null,null,"Direct Services",{"$f":"J14-C14","v":0},{"$f":"K14-D14","v":-18200}]
[null,"Overhead",{"$f":"INDIRECT(\"scenarios!\" & \"nd\" &'Scen Meta'!$B$8)","v":9.1},{"$f":"INDIRECT(\"scenarios!\" & \"ne\" &'Scen Meta'!$B$8)","v":3640},null,null,null,null,"Overhead",{"$f":"INDIRECT(\"scenarios!\" & \"nd\" &'Scen Meta'!$B$9)","v":9.1},{"$f":"INDIRECT(\"scenarios!\" & \"ne\" &'Scen Meta'!$B$9)","v":1820},null,null,null,null,"Overhead",{"$f":"J15-C15","v":0},{"$f":"K15-D15","v":-1820}]
[]
[null,"Additional Services",{"$f":"INDIRECT(\"scenarios!\" & \"nf\" &'Scen Meta'!$B$8)","v":50.625},{"$f":"INDIRECT(\"scenarios!\" & \"ng\" &'Scen Meta'!$B$8)","v":20250},null,null,null,null,"Additional Services",{"$f":"INDIRECT(\"scenarios!\" & \"nf\" &'Scen Meta'!$B$9)","v":50.625},{"$f":"INDIRECT(\"scenarios!\" & \"ng\" &'Scen Meta'!$B$9)","v":10125},null,null,null,null,"Additional Services",{"$f":"J17-C17","v":0},{"$f":"K17-D17","v":-10125}]
[null,null,{"$f":"SUM(C14:C17)","v":150.72499999999999},{"$f":"SUM(D14:D17)","v":60290},null,null,null,null,null,{"$f":"SUM(J14:J17)","v":150.72499999999999},{"$f":"SUM(K14:K17)","v":30145},null,null,null,null,null,{"$f":"SUM(Q14:Q17)","v":0},{"$f":"SUM(R14:R17)","v":-30145}]
[]
[null,"Total Operating Costs",{"$f":"C12+SUM(C14:C17)","v":299.11040000000003},null,{"$f":"D18+D12","v":119644.1667},null,null,null,"Total Operating Costs",{"$f":"J12+SUM(J14:J17)","v":447.49580000000003},null,{"$f":"K18+K12","v":89499.166700000002},null,null,null,"Total Operating Costs",{"$f":"Q12+SUM(Q14:Q17)","v":148.3854},null,{"$f":"R18+R12","v":-30145}]
[]
[null,"Benefit Savings","PMPM","Monthly",null,null,null,null,"Benefit Savings","PMPM","Monthly",null,null,null,null,"Benefit Savings","PMPM","Monthly"]
[null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"nl\" &'Scen Meta'!$B$8)","v":1401.6177},{"$f":"INDIRECT(\"scenarios!\" & \"nm\" &'Scen Meta'!$B$8)","v":280323.53120000003},null,null,null,null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"nl\" &'Scen Meta'!$B$9)","v":1401.6177},{"$f":"INDIRECT(\"scenarios!\" & \"nm\" &'Scen Meta'!$B$9)","v":140161.76560000001},null,null,null,null,"Level 1",{"$f":"J23-C23","v":0},{"$f":"K23-D23","v":-140161.76560000001}]
[null,"Level 2",{"$f":"INDIRECT(\"scenarios!\" & \"nn\" &'Scen Meta'!$B$8)","v":361.77769999999998},{"$f":"INDIRECT(\"scenarios!\" & \"no\" &'Scen Meta'!$B$8)","v":72355.545599999998},null,null,null,null,"Level 2",{"$f":"INDIRECT(\"scenarios!\" & \"nn\" &'Scen Meta'!$B$9)","v":361.77769999999998},{"$f":"INDIRECT(\"scenarios!\" & \"no\" &'Scen Meta'!$B$9)","v":36177.772799999999},null,null,null,null,"Level 2",{"$f":"J24-C24","v":0},{"$f":"K24-D24","v":-36177.772799999999}]
[]
[null,"Additional Benefits",{"$f":"INDIRECT(\"scenarios!\" & \"np\" &'Scen Meta'!$B$8)","v":32.625},{"$f":"INDIRECT(\"scenarios!\" & \"nq\" &'Scen Meta'!$B$8)","v":13050},null,null,null,null,"Additional Benefits",{"$f":"INDIRECT(\"scenarios!\" & \"np\" &'Scen Meta'!$B$9)","v":48.25},{"$f":"INDIRECT(\"scenarios!\" & \"nq\" &'Scen Meta'!$B$9)","v":9650},null,null,null,null,"Additional Benefits",{"$f":"J26-C26","v":15.625},{"$f":"K26-D26","v":-3400}]
[]
[null,"Total Monthly Benefits",{"$f":"IFERROR(E28/D8,0)","v":914.32269200000007},null,{"$f":"D23+D24+D26","v":365729.07680000004},null,null,null,"Total Monthly Benefits",{"$f":"IFERROR(L28/K8,0)","v":929.94769200000007},null,{"$f":"K23+K24+K26","v":185989.53840000002},null,null,null,"Total Monthly Benefits",0,null,{"$f":"L28-E28","v":-179739.53840000002}]
[]
[null,"Net Benefit PMPM",{"$f":"IFERROR(E31/D8,0)","v":615.21227525000006},null,null,null,null,null,"Net Benefit PMPM",{"$f":"IFERROR(L31/K8,0)","v":482.45185850000007},null,null,null,null,null,"Net Benefit PMPM",0]
[null,"Total Net Benefit Per Month",null,null,{"$f":"E28-E20","v":246084.91010000004},null,null,null,"Total Net Benefit Per Month",null,null,{"$f":"L28-L20","v":96490.371700000018},null,null,null,"Total Net Benefit Per Month",null,null,{"$f":"L31-E31","v":-149594.53840000002}]
[]
[null,"Operating Margin ROI",null,null,{"$f":"IFERROR(E31/E20,0)","v":2.0568065864593468},null,null,null,"Operating Margin ROI",null,null,{"$f":"IFERROR(L31/L20,0)","v":1.0781147496426915},null,null,null,"Operating Margin ROI",null,null,{"$f":"L33-RETURNONINV","v":-0.97869183681665528}]
[null,"Startup Payback (months)",null,null,{"$f":"IFERROR(D10/E31,0)","v":0.56890932460307719},null,null,null,"Startup Payback (months)",null,null,{"$f":"IFERROR(K10/L31,0)","v":1.4509219679998391},null,null,null,"Startup Payback (months)",null,null,{"$f":"L34-PBMONTH","v":0.88201264339676189}]

{"sheet":"9a.Monte Carlo Analysis","index":12,"n_rows":46,"n_cols":18,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,4,0,6]]}
[null,"9a. Monte Carlo Data",null,null,"Plausible Range of Values"]
[null,"Variable ",null,"Current Value","Conservative (lowers ROI)","Intermediate","Aggressive (raises ROI)","Average"]
[null,"Launch Costs",null,{"$f":"'4.Costs'!C19","v":140000},0,0,0,{"$f":"AVERAGE(E3:G3)","v":0}]
[]
[null,{"$f":"IF(ISBLANK('6.Medical Utilization'!B18),\"\",'6.Medical Utilization'!B18)","v":"Hospital Admissions"},"Level 1",{"$f":"'6.Medical Utilization'!C18","v":1.33},1.0640000000000001,1.33,1.5960000634193421,{"$f":"SUM(E5:G5)/3","v":1.3300000211397807},null,null,null,null,null,1,null,null,"HA Complete",{"$f":"IF('6.Medical Utilization'!I18<>0,1,0)","v":1}]
[null,null,"Level 2",{"$f":"'6.Medical Utilization'!D18","v":0.66500000000000004},0.53200000000000003,0.66500000000000004,0.79800003170967104,{"$f":"SUM(E6:G6)/3","v":0.66500001056989033},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('6.Medical Utilization'!B19=\"\",\"\",'6.Medical Utilization'!B19)","v":"Hospital Readmissions"},"Level 1",{"$f":"'6.Medical Utilization'!C19","v":0.17},0.13600000000000001,0.17,0.2040000081062317,{"$f":"SUM(E8:G8)/3","v":0.17000000270207724},null,null,null,null,null,1,null,null,"HR Complete",{"$f":"IF('6.Medical Utilization'!I19<>0,1,0)","v":1}]
[null,null,"Level 2",{"$f":"'6.Medical Utilization'!D19","v":8.5000000000000006E-2},6.8000000000000005E-2,8.5000000000000006E-2,0.10200000405311585,{"$f":"SUM(E9:G9)/3","v":8.500000135103862E-2},null,null,"Conservative",-0.2,null,1]
[null,null,null,null,null,null,null,null,null,null,"Current",0,null,0]
[null,{"$f":"IF(ISBLANK('6.Medical Utilization'!B6),\"\",'6.Medical Utilization'!B6)","v":"Emergency Dept."},"Level 1",{"$f":"'6.Medical Utilization'!D6","v":1890},1512,1890,2268.0000901222229,{"$f":"SUM(E11:G11)/3","v":1890.000030040741},null,null,"Aggressive",0.2,null,1,null,null,"ED Complete",{"$f":"IF('6.Medical Utilization'!D6<>0,1,0)","v":1}]
[null,null,"Level 2",{"$f":"'6.Medical Utilization'!E6","v":945},756,945,1134.0000450611115,{"$f":"SUM(E12:G12)/3","v":945.00001502037048},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"\"Baseline Cost of \"& '6.Medical Utilization'!B18","v":"Baseline Cost of Hospital Admissions"},"Level1",{"$f":"'6.Medical Utilization'!C32","v":3500},2800,3500,4200.0001668930054,{"$f":"SUM(E14:G14)/3","v":3500.0000556310019},null,null,null,null,null,1]
[null,null,"Level2",{"$f":"'6.Medical Utilization'!D32","v":2625},2100,2625,3150.000125169754,{"$f":"SUM(E15:G15)/3","v":2625.0000417232513},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"IF('6.Medical Utilization'!B19=\"\",\"\",\"Baseline Cost of \" & '6.Medical Utilization'!B19)","v":"Baseline Cost of Hospital Readmissions"},"Level1",{"$f":"'6.Medical Utilization'!C33","v":3500},2800,3500,4200.0001668930054,3500.0000556310019,null,null,null,null,null,1]
[null,null,"Level2",{"$f":"'6.Medical Utilization'!D33","v":2625},2100,2625,3150.000125169754,2625.0000417232513,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"\"Costs per \" &  '6.Medical Utilization'!B6","v":"Costs per Emergency Dept."},null,{"$f":"'6.Medical Utilization'!F6","v":2800},2240,2800,3360.0001335144043,{"$f":"SUM(E20:G20)/3","v":2800.0000445048013},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"\"Percentage Change in \" &'6.Medical Utilization'!B5","v":"Percentage Change in Specialty Care"},null,{"$f":"'6.Medical Utilization'!P5","v":-0.1},-8.0000000000000016E-2,-0.1,-0.12000000476837158,{"$f":"SUM(E22:G22)/3","v":-0.10000000158945721},null,null,null,null,null,1,null,null,null,{"$f":"IF('6.Medical Utilization'!I5<>0,1,0)","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"\"Percentage Change in \" &'6.Medical Utilization'!B6","v":"Percentage Change in Emergency Dept."},null,{"$f":"'6.Medical Utilization'!P6","v":-0.35},-0.27999999999999997,-0.35,-0.42000001668930054,{"$f":"SUM(E24:G24)/3","v":-0.35000000556310013},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"\"Percentage Change in \" &'6.Medical Utilization'!B18","v":"Percentage Change in Hospital Admissions"},null,{"$f":"'6.Medical Utilization'!P18","v":-0.25},-0.2,-0.25,-0.30000001192092896,{"$f":"SUM(E26:G26)/3","v":-0.25000000397364297},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,{"$f":"\"Percentage Change in \" &'6.Medical Utilization'!B19","v":"Percentage Change in Hospital Readmissions"},null,{"$f":"'6.Medical Utilization'!P19","v":-0.25},-0.2,-0.25,-0.30000001192092896,{"$f":"SUM(E28:G28)/3","v":-0.25000000397364297},null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MC Error",{"$f":"+R22+R11+R8+R5","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Costs"]
[null,"Number of Simulations (MAX 10,000)",500,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fixed",{"$f":"'4.Costs'!E43","v":712250}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Var",{"$f":"'4.Costs'!D61","v":100.1}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add",{"$f":"'5.Additional Utilizations'!G19","v":50.625}]
[null,null,null,null,null,null,"Average Net Benefit PMPM",{"$f":"IFERROR(AVERAGE(MCCALCS!T27:T10026),\"Insufficient Data\")","v":612.32065800000009},null,null,null,null,null,null,null,null,"Error",{"$f":"SUM(R31:R33)","v":712400.72499999998}]
[null,null,null,null,null,null,"Average ROI",{"$f":"IFERROR(AVERAGE(MCCALCS!U27:U10026),\"Insufficient Data\")","v":2.0471391690383909}]
[null,null,"A Run may take several minutes. See the scenario count in the lower left.",null,null,null,null,null,null,null,null,null,null,null,null,null,"Error Flag",{"$f":"IF(OR(R34=0,R29=0),1,0)","v":0}]
[]
[]
[null,null,null,"Net Benefit PMPM"]
[null,null,null,null,"Percent Less than",null,2715.2379000000001,{"$f":"IFERROR(MCCALCS!W5,\"\")","v":1.0309278350515463}]
[null,null,null,null,"Percent Greater than",null,3318.6241000000005,{"$f":"IFERROR(MCCALCS!W6,\"\")","v":0}]
[null,null,null,null,"Percent Between",null,null,{"$f":"IFERROR(MCCALCS!W7,\"\")","v":-3.0927835051546282E-2}]
[null,null,null,"ROI"]
[null,null,null,null,"Percent Less than",null,2.4315562883511368,{"$f":"IFERROR(MCCALCS!W2,\"\")","v":0.93}]
[null,null,null,null,"Percent Greater than",null,2.9719021302069448,{"$f":"IFERROR(MCCALCS!W3,\"\")","v":0}]
[null,null,null,null,"Percent Between",null,null,{"$f":"IFERROR(MCCALCS!W4,\"\")","v":6.9999999999999951E-2}]

{"sheet":"Sheet6","index":15,"n_rows":74,"n_cols":4,"rows_kept":74,"cut":false,"hidden":true,"merged":[]}
[]
[-12,{"$f":"IF(-A2<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}},null,{"$f":"(1+IRR(B2:B74,0.1))^12-1","v":{"$error":"#VALUE!"}}]
[-11,{"$f":"IF(-A3<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-10,{"$f":"IF(-A4<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-9,{"$f":"IF(-A5<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-8,{"$f":"IF(-A6<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-7,{"$f":"IF(-A7<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-6,{"$f":"IF(-A8<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-5,{"$f":"IF(-A9<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-4,{"$f":"IF(-A10<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-3,{"$f":"IF(-A11<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-2,{"$f":"IF(-A12<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[-1,{"$f":"IF(-A13<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[0,{"$f":"IF(-A14<'4.Costs'!#REF!,-'4.Costs'!$C$19/'4.Costs'!#REF!,\"\")","v":{"$error":"#REF!"}}]
[1,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[2,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[3,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[4,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[5,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[6,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[7,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[8,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[9,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[10,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[11,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[12,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[13,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[14,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[15,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[16,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[17,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[18,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[19,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[20,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[21,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[22,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[23,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[24,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[25,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[26,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[27,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[28,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[29,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[30,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[31,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[32,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[33,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[34,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[35,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[36,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[37,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[38,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[39,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[40,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[41,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[42,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[43,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[44,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[45,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[46,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[47,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[48,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[49,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[50,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[51,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[52,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[53,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[54,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[55,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[56,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[57,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[58,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[59,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]
[60,{"$f":"'8a.Summary'!E$28","v":246084.91015624997}]

{"sheet":"9d.Sensitivity Analysis","index":16,"n_rows":22,"n_cols":6,"rows_kept":22,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"9d. Sensitivity Analysis"]
[]
[null,null,"Variable","Level","Current Value","Net Benefit Elasticity"]
[null,"Visit Rate"]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B5","v":"Hospital Admissions"},1,{"$f":"'9a.Monte Carlo Analysis'!D5","v":1.33},{"$f":"SACALCS!R3","v":0.87349521457877888}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D6","v":0.66500000000000004},{"$f":"SACALCS!R4","v":0.20157269287366386}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B8","v":"Hospital Readmissions"},1,{"$f":"'9a.Monte Carlo Analysis'!D8","v":0.17},{"$f":"SACALCS!R5","v":0.10306198364369301}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D9","v":8.5000000000000006E-2},{"$f":"SACALCS!R6","v":2.2545062899420598E-2}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B11","v":"Emergency Dept."},1,{"$f":"'9a.Monte Carlo Analysis'!D11","v":1890},{"$f":"SACALCS!R7","v":0.12544450102833782}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D12","v":945},{"$f":"SACALCS!R8","v":6.2726314152045104E-2}]
[null,"Costs"]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B14","v":"Baseline Cost of Hospital Admissions"},1,{"$f":"'9a.Monte Carlo Analysis'!D14","v":3500},{"$f":"SACALCS!R9","v":0.87349521457877888}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D15","v":2625},{"$f":"SACALCS!R10","v":0.20157269287366386}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B17","v":"Baseline Cost of Hospital Readmissions"},1,{"$f":"'9a.Monte Carlo Analysis'!D17","v":3500},{"$f":"SACALCS!R11","v":0.10306198364369301}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D18","v":2625},{"$f":"SACALCS!R12","v":2.2545062899420598E-2}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B20","v":"Costs per Emergency Dept."},null,{"$f":"'9a.Monte Carlo Analysis'!D20","v":2800},{"$f":"SACALCS!R13","v":0.18816268790464719}]
[null,null,"Total Operating Costs",null,{"$f":"'8a.Summary'!E17","v":119644.16666666666},{"$f":"+SACALCS!R14","v":0.48618988924636897}]
[null,"Reduction Rate of Visits"]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B22","v":"Percentage Change in Specialty Care"},null,{"$f":"'9a.Monte Carlo Analysis'!D22","v":-0.1},{"$f":"SACALCS!R15","v":8.1272757388062278E-3}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B24","v":"Percentage Change in Emergency Dept."},null,{"$f":"'9a.Monte Carlo Analysis'!D24","v":-0.35},{"$f":"SACALCS!R16","v":0.13440888616824687}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B26","v":"Percentage Change in Hospital Admissions"},null,{"$f":"'9a.Monte Carlo Analysis'!D26","v":-0.25},{"$f":"SACALCS!R17","v":0.67531159568819388}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B28","v":"Percentage Change in Hospital Readmissions"},null,{"$f":"'9a.Monte Carlo Analysis'!D28","v":-0.25},{"$f":"SACALCS!R18","v":7.8899592872255786E-2}]

{"sheet":"Scenarios","index":20,"n_rows":3,"n_cols":391,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["#","Scenario Name","Date","Members","L1_Pct","L2_Pct","Test Group","LCostsItem1","LCostsItem2","LCostsItem3","LCostsItem4","LCostsItem5","LCostsItem6","LCostsItem7","LCostsItem8","LCostsItem9","LCostsItem10","LCostsItem11","LCostsItem12","LCostsItem13","LCostsItem14","LCostsItem15","LCosts1","LCosts2","LCosts3","LCosts4","LCosts5","LCosts6","LCosts7","LCosts8","LCosts9","LCosts10","LCosts11","LCosts12","LCosts13","LCosts14","LCosts15","OCostsPos1","OCostsPos2","OCostsPos3","OCostsPos4","OCostsPos5","OCostsPos6","OCostsPos7","OCostsPos8","OCostsPos9","OCostsPos10","OCostsPos11","OCostsPos12","OCostsPos13","OCostsPos14","OCostsPos15","OCostsFTE1","OCostsFTE2","OCostsFTE3","OCostsFTE4","OCostsFTE5","OCostsFTE6","OCostsFTE7","OCostsFTE8","OCostsFTE9","OCostsFTE10","OCostsFTE11","OCostsFTE12","OCostsFTE13","OCostsFTE14","OCostsFTE15","OCostsANNFTE1","OCostsANNFTE2","OCostsANNFTE3","OCostsANNFTE4","OCostsANNFTE5","OCostsANNFTE6","OCostsANNFTE7","OCostsANNFTE8","OCostsANNFTE9","OCostsANNFTE10","OCostsANNFTE11","OCostsANNFTE12","OCostsANNFTE13","OCostsANNFTE14","OCostsANNFTE15","OCOSTSOH","VarCostItem1","VarCostItem2","VarCostItem3","VarCostItem4","VarCostItem5","VarCostItem6","VarCostItem7","VarCostItem8","VarCostItem9","VarCostItem10","VarCostsPMPM1","VarCostsPMPM2","VarCostsPMPM3","VarCostsPMPM4","VarCostsPMPM5","VarCostsPMPM6","VarCostsPMPM7","VarCostsPMPM8","VarCostsPMPM9","VarCostsPMPM10","VarCostsOH","AddUtEX1","AddUtEX2","AddUtEX3","AddUtEX4","AddUtEX5","AddUtEX6","AddUtEX7","AddUtEX8","AddUtEX9","AddUtEX10","AddUtEX11","AddUtEX12","AddUtEX13","AddUtEX14","AddUtServ1","AddUtServ2","AddUtServ3","AddUtServ4","AddUtServ5","AddUtServ6","AddUtServ7","AddUtServ8","AddUtServ9","AddUtServ10","AddUtServ11","AddUtServ12","AddUtServ13","AddUtServ14","AddUtMetric1","AddUtMetric2","AddUtMetric3","AddUtMetric4","AddUtMetric5","AddUtMetric6","AddUtMetric7","AddUtMetric8","AddUtMetric9","AddUtMetric10","AddUtMetric11","AddUtMetric12","AddUtMetric13","AddUtMetric14","AddUtCostper1","AddUtCostper2","AddUtCostper3","AddUtCostper4","AddUtCostper5","AddUtCostper6","AddUtCostper7","AddUtCostper8","AddUtCostper9","AddUtCostper10","AddUtCostper11","AddUtCostper12","AddUtCostper13","AddUtCostper14","AddUtPMPM1","AddUtPMPM2","AddUtPMPM3","AddUtPMPM4","AddUtPMPM5","AddUtPMPM6","AddUtPMPM7","AddUtPMPM8","AddUtPMPM9","AddUtPMPM10","AddUtPMPM11","AddUtPMPM12","AddUtPMPM13","AddUtPMPM14","AddUtPctMem1","AddUtPctMem2","AddUtPctMem3","AddUtPctMem4","AddUtPctMem5","AddUtPctMem6","AddUtPctMem7","AddUtPctMem8","AddUtPctMem9","AddUtPctMem10","AddUtPctMem11","AddUtPctMem12","AddUtPctMem13","AddUtPctMem14","MUEX1","MUEX2","MUEX3","MUEX4","MUEX5","MUEX6","MUEX7","MUEX8","MUEX9","MUEvent1","MUEvent2","MUEvent3","MUEvent4","MUEvent5","MUEvent6","MUEvent7","MUEvent8","MUEvent9","MUMetric1","MUMetric2","MUMetric3","MUMetric4","MUMetric5","MUMetric6","MUMetric7","MUMetric8","MUMetric9","MUBase_L1_1","MUBase_L1_2","MUBase_L1_3","MUBase_L1_4","MUBase_L1_5","MUBase_L1_6","MUBase_L1_7","MUBase_L1_8","MUBase_L1_9","MUBase_L2_1","MUBase_L2_2","MUBase_L2_3","MUBase_L2_4","MUBase_L2_5","MUBase_L2_6","MUBase_L2_7","MUBase_L2_8","MUBase_L2_9","MUCpost_1","MUCpost_2","MUCpost_3","MUCpost_4","MUCpost_5","MUCpost_6","MUCpost_7","MUCpost_8","MUCpost_9","MUTime_1","MUTime_2","MUTime_3","MUTime_4","MUTime_5","MUTime_6","MUTime_7","MUTime_8","MUTime_9","MUPatCount_1","MUPatCount_2","MUPatCount_3","MUPatCount_4","MUPatCount_5","MUPatCount_6","MUPatCount_7","MUPatCount_8","MUPatCount_9","MUChng_1","MUChng_2","MUChng_3","MUChng_4","MUChng_5","MUChng_6","MUChng_7","MUChng_8","MUChng_9","IPEx_1","IPEx_2","IPEx_3","IPEx_4","IPEx_5","IPEvents_1","IPEvents_2","IPEvents_3","IPEvents_4","IPEvents_5","IPBase_L1_1","IPBase_L1_2","IPBase_L1_3","IPBase_L1_4","IPBase_L1_5","IPBase_L2_1","IPBase_L2_2","IPBase_L2_3","IPBase_L2_4","IPBase_L2_5","IPTime_1","IPTime_2","IPTime_3","IPTime_4","IPTime_5","IPPatCount_1","IPPatCount_2","IPPatCount_3","IPPatCount_4","IPPatCount_5","IPEventsChng_1","IPEventsChng_2","IPEventsChng_3","IPEventsChng_4","IPEventsChng_5","IPLOS_L1_1","IPLOS_L1_2","IPLOS_L1_3","IPLOS_L1_4","IPLOS_L1_5","IPLOS_L2_1","IPLOS_L2_2","IPLOS_L2_3","IPLOS_L2_4","IPLOS_L2_5","IPLOS_Chng_1","IPLOS_Chng_2","IPLOS_Chng_3","IPLOS_Chng_4","IPLOS_Chng_5","IPCost_L1_1","IPCost_L1_2","IPCost_L1_3","IPCost_L1_4","IPCost_L1_5","IPCosts_L2_1","IPCosts_L2_2","IPCosts_L2_3","IPCosts_L2_4","IPCosts_L2_5","IPCosts_Chng_1","IPCosts_Chng_2","IPCosts_Chng_3","IPCosts_Chng_4","IPCosts_Chng_5","OF_Ben_ann_Item1","OF_Ben_ann_Item2","OF_Ben_ann_Item3","OF_Ben_ann_Item4","OF_Ben_ann_Item5","OF_Ben_ann_Item6","OF_Ben_ann_Item7","OF_Ben_ann_Amt1","OF_Ben_ann_Amt2","OF_Ben_ann_Amt3","OF_Ben_ann_Amt4","OF_Ben_ann_Amt5","OF_Ben_ann_Amt6","OF_Ben_ann_Amt7","OF_Ben_PMPM_Item1","OF_Ben_PMPM_Item2","OF_Ben_PMPM_Item3","OF_Ben_PMPM_Item4","OF_Ben_PMPM_Item5","OF_Ben_PMPM_Item6","OF_Ben_PMPM_Item7","OF_Ben_PMPM_Amt1","OF_Ben_PMPM_Amt2","OF_Ben_PMPM_Amt3","OF_Ben_PMPM_Amt4","OF_Ben_PMPM_Amt5","OF_Ben_PMPM_Amt6","OF_Ben_PMPM_Amt7","R_Launch","R_OC_PMPM","R_OC_Monthly","R_DS_PMPM","R_DS_Month","R_OH_PMPM","R_OH_Month","R_AS_PMPM","R_AS_Month","R_TOTNONOP_PMPM","R_TOTNONOP_Month","R_TOT_OPCOST_PMPM","R_TOTOPCOSTS","R_SAV_L1_PMPM","R_SAV_L1_Monthly","R_SAV_L2_PMPM","R_SAV_L2_Monthly","R_AddBen_PMPM","R_AddBen_Monthly","R_TOTBen_PMPM","R_TOTBen_Monthly","R_NetBen_PMPM","R_NetBen_Monthly","R_ROI","R_Payback","PopPct_L1","PopPct_L2","BASELINE","Testgroup selected"]
[1,"Baseline","2016-11-14T13:05:59",2000,0.1,0.2,null,"Training","Equipment","Other","Recruitment","Remodel/Costruction",null,null,null,null,null,null,null,null,null,null,50000,25000,25000,25000,15000,null,null,null,null,null,null,null,null,null,null,"Program Director","Medical Director","Nurse Practitioner","Social Worker","Medical Assistant","Pharmacist","Mental Health Liaison",null,null,null,null,null,null,null,null,1,0.5,2,2,1,0.5,0.1,null,null,null,null,null,null,null,null,150000,200000,95000,42000,45000,120000,175000,1000,null,null,null,null,null,null,null,0.1,"Mileage","Supplies","Other","Misc",null,null,null,null,null,null,36,8,36,11,null,null,null,null,null,null,0.1,false,false,true,true,false,false,false,false,false,false,false,false,false,false,"Behavioral Health","Rehabilitation Services","Home Delivered Meals","In-Home Modifications","Caregiver Education & Support","Transport to Appointments",null,null,null,null,null,null,null,null,"Year","Month","Month","Year","Month","Month",null,null,null,null,null,null,null,null,125,85,10,1000,25,25,null,null,null,null,null,null,null,null,2,1,6,1,1,1,null,null,null,null,null,null,null,null,0.45,0.25,0.1,0.6,0.5,0.3,null,null,null,null,null,null,null,null,false,false,false,false,false,true,true,true,true,"Primary Care","Specialty Care","Emergency Dept.",null,null,null,null,null,null,"Visits","Visits","Visits",null,null,null,null,null,null,1,4,1890,null,null,null,null,null,null,0.5,2,945,null,null,null,null,null,null,125,200,2800,null,null,null,null,null,null,1,2,2,2,2,2,2,2,2,1,1,1000,null,null,null,null,null,null,40,10,25,60,60,60,60,60,60,false,false,false,false,true,"Hospital Admissions","Hospital Readmissions","Skilled Nursing Admissions",null,null,1.33,0.17,0.33,null,null,0.66500000000000004,8.5000000000000006E-2,0.16500000000000001,null,null,2,2,2,2,null,1,1,1,null,null,35,35,45,60,60,6.5,6,20,null,null,4,3.5,15,null,null,50,50,40,60,60,3500,3500,300,null,null,2625,2625,225,null,null,45,45,50,60,60,"Medicare/ACO Shared Savings ","CMS 30-Day Penalty Reduction",null,null,null,null,null,25000,50000,null,null,null,null,null,"Revisions to HCC","Stipend for PCC","Fee for Care Coordination",null,null,null,null,8,6,3,null,null,null,null,140000,148.3854,59354.166700000002,91,36400,9.1,3640,50.625,20250,150.72499999999999,60290,299.11040000000003,119644.1667,1401.6177,280323.53120000003,361.77769999999998,72355.545599999998,32.625,13050,914.32270000000005,365729.07679999998,615.21230000000003,246084.91020000001,2.0568065875025248,0.56890932447303633,"0 to 10%","10% to 20%",null,false]
[2,"Restricted","2016-11-14T13:06:30",2000,0.05,0.1,null,"Training","Equipment","Other","Recruitment","Remodel/Costruction",null,null,null,null,null,null,null,null,null,null,50000,25000,25000,25000,15000,null,null,null,null,null,null,null,null,null,null,"Program Director","Medical Director","Nurse Practitioner","Social Worker","Medical Assistant","Pharmacist","Mental Health Liaison",null,null,null,null,null,null,null,null,1,0.5,2,2,1,0.5,0.1,null,null,null,null,null,null,null,null,150000,200000,95000,42000,45000,120000,175000,1000,null,null,null,null,null,null,null,0.1,"Mileage","Supplies","Other","Misc",null,null,null,null,null,null,36,8,36,11,null,null,null,null,null,null,0.1,false,false,true,true,false,false,false,false,false,false,false,false,false,false,"Behavioral Health","Rehabilitation Services","Home Delivered Meals","In-Home Modifications","Caregiver Education & Support","Transport to Appointments",null,null,null,null,null,null,null,null,"Year","Month","Month","Year","Month","Month",null,null,null,null,null,null,null,null,125,85,10,1000,25,25,null,null,null,null,null,null,null,null,2,1,6,1,1,1,null,null,null,null,null,null,null,null,0.45,0.25,0.1,0.6,0.5,0.3,null,null,null,null,null,null,null,null,false,false,false,false,false,true,true,true,true,"Primary Care","Specialty Care","Emergency Dept.",null,null,null,null,null,null,"Visits","Visits","Visits",null,null,null,null,null,null,1,4,1890,null,null,null,null,null,null,0.5,2,945,null,null,null,null,null,null,125,200,2800,null,null,null,null,null,null,1,2,2,2,2,2,2,2,2,1,1,1000,null,null,null,null,null,null,40,10,25,60,60,60,60,60,60,false,false,false,false,true,"Hospital Admissions","Hospital Readmissions","Skilled Nursing Admissions",null,null,1.33,0.17,0.33,null,null,0.66500000000000004,8.5000000000000006E-2,0.16500000000000001,null,null,2,2,2,2,null,1,1,1,null,null,35,35,45,60,60,6.5,6,20,null,null,4,3.5,15,null,null,50,50,40,60,60,3500,3500,300,null,null,2625,2625,225,null,null,45,45,50,60,60,"Medicare/ACO Shared Savings ","CMS 30-Day Penalty Reduction",null,null,null,null,null,25000,50000,null,null,null,null,null,"Revisions to HCC","Stipend for PCC","Fee for Care Coordination",null,null,null,null,8,6,3,null,null,null,null,140000,296.77080000000001,59354.166700000002,91,18200,9.1,1820,50.625,10125,150.72499999999999,30145,447.49579999999997,89499.166700000002,1401.6177,140161.76560000001,361.77769999999998,36177.772799999999,48.25,9650,929.94770000000005,185989.53839999999,482.45190000000002,96490.371700000003,1.0781147505446977,1.450921967326309,"0 to 5%","5% to 10%",null,false]

{"sheet":"Scen Meta","index":21,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Max Recnum","recnum count"]
[{"$f":"MAX(Scenarios!A2:A457)","v":2},{"$f":"COUNT(Scenarios!A2:A457)","v":2}]
[null,null,null,null,null,null,null,"Navigation Selected",null,"MC Navigation Selected"]
[]
[]
[null,"Comparison Scenarios"]
["Scenerio","#","Name","Date",null,null,null,null,"Required","9a. Monte Carlo Data"]
["A",2,"Baseline","2016-11-14T13:05:59",null,null,0,"1.  Start",null,"9b. MC Results-ROI Chart"]
["B",3,"Restricted","2016-11-14T13:06:30",null,null,1,"2.  Flow",null,"9c. MC Results-Net Benefit PMPM Chart"]
[null,null,null,null,null,null,2,"3.  Population Data","x","9d. Sensitivity Analysis"]
[null,null,null,null,null,null,3,"4a. Launch Costs","a","9e. Net Benefit Sensitivity Chart"]
[null,null,null,null,null,null,4,"4b.Operating Costs","a","9f. Cost Sensitivity Chart"]
["Selected Scenario",null,null,null,null,null,5,"4c. Variable Costs","a","9g. Visit Sensitivity Chart"]
["row","Name","Date","Edit name or date ONLY",null,null,6,"5.  Additional Utilizations"]
[3,"Restricted","2016-11-14T13:06:30",0,null,null,7,"6a. Medical Utilization Data","b"]
[null,null,null,null,null,null,8,"6b. Inpatient Events","bc"]
[null,null,null,null,null,null,9,"6c. Inpatients Length of Stay","bc"]
[null,null,null,null,null,null,10,"6d. Inpatient Average Costs","bc"]
["Show ROI Flag",1,null,null,null,null,11,"6e. Inpatient Utilization Change","b"]
["Show MC Sections",1,null,null,null,null,12,"6f. Event Utilization Change","bcd"]
[null,null,null,null,null,null,13,"6g. Length of Stay Change","bcd"]
["Baseline:",{"$f":"INDEX(Scenarios!B$1:B$82,MATCH(1,Scenarios!NZ$1:NZ$82))","v":{"$error":"#N/A"}},{"$f":"MATCH(1,Scenarios!NZ$1:NZ$79)","v":{"$error":"#N/A"}},null,null,null,14,"6h. Average Cost Per Day Change","bcd"]
[null,null,null,null,null,null,15,"6i. Medical Utilization Summary"]
[null,null,null,null,null,null,16,"7a. Additional Benefits-(Annual Based)"]
["Resize with NEXT Button",null,1,null,null,null,17,"7b. Additional Benefits-(PMPM Based)"]
[null,null,null,null,null,null,18,"8a. Summary"]
["Sheet instructions",null,1,null,null,null,19,"8b. Scenario Comparisons"]
["Cell Instructions",null,0,null,null,null,20,"Report"]
[]
[]
[null,null,null,null,null,null,null,null,null,"Missing"]
[null,null,null,null,null,null,null,"3.  Population Data",{"$f":"'3.Population Data'!E7","v":400},{"$f":"OR(ISERROR(I32),I32=0)","v":false},{"$f":"IF(J32=TRUE,\"Missing Population Data\",\"\")","v":""}]
[null,null,null,null,null,null,null,"4a. Launch Costs",{"$f":"launchcosts","v":140000}]
[null,null,null,null,null,null,null,"4b.Operating Costs",{"$f":"'4.Costs'!E43","v":712250}]
[null,null,null,null,null,null,null,"4c. Variable Costs",{"$f":"+'4.Costs'!D61","v":100.1}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I33:I35)=0,TRUE,FALSE)","v":false}]

{"sheet":"Sheet1","index":22,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Report ","index":23,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,4,0,25]]}
[null,null,null,null,"Report Pictures"]

{"sheet":"SACALCS","index":24,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[null,null,null,"Test Values",null,"NBPMPM",null,null,"ROI",null,null,null,null,14,null,"NBPMPM",null,null,null,"ROI"]
[null,null,"Current","Decrease","Increase","Decrease","Increase",null,"Decrease","Increase",null,null,null,"Rangename"]
[1,{"$f":"'9a.Monte Carlo Analysis'!B5","v":"Hospital Admissions"},1.33,1.3167,1.3433000000000002,609.83839999999998,620.58609999999999,null,2.0388404526791248,2.0747727223259247,null,null,null,"Baseadmin",null,{"$f":"1-F3/$C$19","v":8.7350334185452017E-3},{"$f":"1-G3/$C$19","v":-8.7348708730303759E-3},{"$f":"AVERAGE(ABS(P3),ABS(Q3))/0.01","v":0.87349521457877888},null,{"$f":"1-I3/$C$20","v":8.7349656173628665E-3},{"$f":"1-J3/$C$20","v":-8.7349656173627555E-3},{"$f":"AVERAGE(ABS(T3),ABS(U3))/0.01","v":0.8734965617362811}]
[2,null,0.66500000000000004,0.65834999999999999,0.67165000000000008,613.97220000000004,616.45240000000001,null,2.0526605563894327,2.0609526186156173,null,null,null,"baseadmin2",null,{"$f":"1-F4/$C$19","v":2.0157269287366386E-3},{"$f":"1-G4/$C$19","v":-2.0157269287366386E-3},{"$f":"AVERAGE(ABS(P4),ABS(Q4))/0.01","v":0.20157269287366386},null,{"$f":"1-I4/$C$20","v":2.0157612963144222E-3},{"$f":"1-J4/$C$20","v":-2.0157612963145333E-3},{"$f":"AVERAGE(ABS(T4),ABS(U4))/0.01","v":0.20157612963144778}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B8","v":"Hospital Readmissions"},0.17,0.16830000000000001,0.17170000000000002,614.57820000000004,615.84630000000004,null,2.0546868121965836,2.0589263628084669,null,null,null,"Basereadmin",null,1.030701109194343E-3,-1.0305385636795172E-3,0.10306198364369301,null,1.0306147981152813E-3,-1.0306147981158365E-3,0.10306147981155589]
[2,null,8.5000000000000006E-2,8.4150000000000003E-2,8.585000000000001E-2,615.07360000000006,615.351,null,2.0563428866543503,2.0572702883506997,null,null,null,"Basereadmin2",null,2.2545062899415047E-4,-2.2545062899426149E-4,2.2545062899420598E-2,null,2.2544698708770738E-4,-2.2544698708792943E-4,2.2544698708781841E-2]
[1,{"$f":"'9a.Monte Carlo Analysis'!B11","v":"Emergency Dept."},1890,1871.1,1908.9,614.44050000000004,615.98400000000004,null,2.0542264366385048,2.0593867383665456,null,null,null,"baseed",null,1.2545262830407911E-3,-1.2543637375259653E-3,0.12544450102833782,null,1.2544450604627944E-3,-1.2544450604632384E-3,0.12544450604630164]
[2,null,945,935.55,954.45,614.82640000000004,615.59820000000002,null,2.0555165120705148,2.0580966629345352,null,null,null,"baseed2",null,6.2726314152039553E-4,-6.2726314152050655E-4,6.2726314152045104E-2,null,6.2722253023139718E-4,-6.2722253023173025E-4,6.2722253023156371E-2]
[1,{"$f":"'9a.Monte Carlo Analysis'!B14","v":"Baseline Cost of Hospital Admissions"},3500,3465,3535,609.83839999999998,620.58609999999999,null,2.0388404526791248,2.0747727223259256,null,null,null,"basehospdayAD1",null,8.7350334185452017E-3,-8.7348708730303759E-3,0.87349521457877888,null,8.7349656173628665E-3,-8.7349656173631995E-3,0.8734965617363033]
[2,null,2625,2598.75,2651.25,613.97220000000004,616.45240000000001,null,2.0526605563894327,2.0609526186156173,null,null,null,"basehospdayAD2",null,2.0157269287366386E-3,-2.0157269287366386E-3,0.20157269287366386,null,2.0157612963144222E-3,-2.0157612963145333E-3,0.20157612963144778]
[1,"Baseline Cost of Hospital Day-Admission",3500,3465,3535,614.57820000000004,615.84630000000004,null,2.0546868121965827,2.0589263628084669,null,null,null,"basehospdayRE1",null,1.030701109194343E-3,-1.0305385636795172E-3,0.10306198364369301,null,1.0306147981157254E-3,-1.0306147981158365E-3,0.10306147981157809]
[2,null,2625,2598.75,2651.25,615.07360000000006,615.351,null,2.0563428866543503,2.0572702883506997,null,null,null,"basehospdayRE2",null,2.2545062899415047E-4,-2.2545062899426149E-4,2.2545062899420598E-2,null,2.2544698708770738E-4,-2.2544698708792943E-4,2.2544698708781841E-2]
[null,{"$f":"'9a.Monte Carlo Analysis'!B20","v":"Costs per Emergency Dept."},2800,2772,2828,614.05470000000003,616.36990000000003,null,2.0529363612064944,2.0606768137985556,null,null,null,"edcosts",null,1.8816268790464719E-3,-1.8816268790464719E-3,0.18816268790464719,null,1.8816675906945246E-3,-1.8816675906947467E-3,0.18816675906946356]
[null,"Total Operating Costs",119644.1667,118447.725033,120840.60836700001,618.20339999999999,612.22119999999995,null,2.0876834217197215,2.0265411740753585,null,null,null,"topcost",null,{"$f":"1-F14/$C$19","v":-4.8618988924635786E-3},{"$f":"1-G14/$C$19","v":4.8618988924638007E-3},{"$f":"AVERAGE(ABS(P14),ABS(Q14))/0.01","v":0.48618988924636897},null,{"$f":"1-I14/$C$20","v":-1.5012026120885258E-2},{"$f":"1-J14/$C$20","v":1.4714759088707563E-2},{"$f":"AVERAGE(ABS(T14),ABS(U14))/0.01","v":1.486339260479641}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B22","v":"Percentage Change in Specialty Care"},10,9.9,10.1,615.26229999999998,615.16229999999996,null,2.0569737490003064,2.0566394243014665,null,null,null,"pcspecvisit1",null,-8.1272757388006767E-5,8.1272757388117789E-5,8.1272757388062278E-3,null,-8.1272346557748065E-5,8.1273174674767468E-5,8.1272760616257766E-3]
[null,{"$f":"'9a.Monte Carlo Analysis'!B24","v":"Percentage Change in Emergency Dept."},25,24.75,25.25,616.03920000000005,614.3854,null,2.0595710340044238,2.0540421392973491,null,null,null,"pcedvisit1",null,-1.3440888616824687E-3,1.3440888616824687E-3,0.13440888616824687,null,-1.34404786463449E-3,1.3440486927516204E-3,0.13440482786930552]
[null,{"$f":"'9a.Monte Carlo Analysis'!B26","v":"Percentage Change in Hospital Admissions"},35,34.65,35.35,619.36689999999999,611.05769999999995,null,2.0706963987983267,2.0429167745034471,null,null,null,"pcadmin1",null,-6.7531159568818833E-3,6.7531159568819943E-3,0.67531159568819388,null,-6.7530954928862741E-3,6.7530963210028494E-3,0.67530959069445617]
[null,{"$f":"'9a.Monte Carlo Analysis'!B28","v":"Percentage Change in Hospital Readmissions"},35,34.65,35.35,615.69770000000005,614.7269,null,2.0584294036363926,2.0551837696653799,null,null,null,"pcreadmin1",null,-7.8899592872261337E-4,7.8899592872250235E-4,7.8899592872255786E-2,null,-7.8899792704301142E-4,7.8899875516025286E-4,7.8899834110163214E-2]
[null,"Net Bennefit PMPM",615.21230000000003]
[null,"ROI",2.0568065875025248]