{"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":0},{"$f":"E41-C41","v":0},{"$f":"'4.Costs'!E44+('3.Population Data'!E5+'3.Population Data'!E6)*'4.Costs'!D61","v":0}]
["PMPM Costs with No CPO's",null,{"$f":"C41/'3.Population Data'!E5","v":{"$error":"#DIV/0!"}},{"$f":"D41/'3.Population Data'!E6","v":{"$error":"#DIV/0!"}},{"$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":0},{"$f":"E43-C43","v":0},{"$f":"E41+('3.Population Data'!E5+'3.Population Data'!E6)*SUMPRODUCT('7.Revenue Enhancements'!C4:C9,P25:P30)","v":0}]
["PMPM Costs with all selected CPO's",null,{"$f":"C43/'3.Population Data'!E5","v":{"$error":"#DIV/0!"}},{"$f":"D43/'3.Population Data'!E6","v":{"$error":"#DIV/0!"}},{"$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":0},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":"%"}]
[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":"."}]
[{"$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":55,"n_cols":28,"rows_kept":55,"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":0},{"$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.18653727416605093},{"$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":0},{"$f":"MIN(U27:U10027)","v":0},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":{"$error":"#DIV/0!"}}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B5","v":""},{"$f":"'9a.Monte Carlo Analysis'!D5","v":0},{"$f":"'9a.Monte Carlo Analysis'!E5","v":0},{"$f":"'9a.Monte Carlo Analysis'!F5","v":0},{"$f":"'9a.Monte Carlo Analysis'!G5","v":0},null,{"$f":"RAND()","v":0.57203033695215744},{"$f":"(E3-D3)/(F3-D3)","v":{"$error":"#DIV/0!"}},{"$f":"(D3+(F3-D3)*IF(H3<=I3,SQRT(H3*I3),1-SQRT((1-I3)*(1-H3))))","v":{"$error":"#DIV/0!"}},null,null,"MAX",{"$f":"MAX(T27:T10027)","v":0},{"$f":"MAX(U27:U10027)","v":0},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":{"$error":"#DIV/0!"}}]
[2,{"$f":"B3","v":""},{"$f":"'9a.Monte Carlo Analysis'!D6","v":0},{"$f":"'9a.Monte Carlo Analysis'!E6","v":0},{"$f":"'9a.Monte Carlo Analysis'!F6","v":0},{"$f":"'9a.Monte Carlo Analysis'!G6","v":0},null,0.82351639453173409,{"$f":"(E4-D4)/(F4-D4)","v":{"$error":"#DIV/0!"}},{"$f":"(D4+(F4-D4)*IF(H4<=I4,SQRT(H4*I4),1-SQRT((1-I4)*(1-H4))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUNDDOWN(N2,0)","v":0},{"$f":"ROUNDDOWN(O2,1)","v":0},null,null,null,null,null,null,null,{"$f":"(1-W2)-(W3)","v":{"$error":"#DIV/0!"}}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B8","v":""},{"$f":"'9a.Monte Carlo Analysis'!D8","v":0},{"$f":"'9a.Monte Carlo Analysis'!E8","v":0},{"$f":"'9a.Monte Carlo Analysis'!F8","v":0},{"$f":"'9a.Monte Carlo Analysis'!G8","v":0},null,0.2769294739183441,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"ROUNDUP(N3,0)","v":0},{"$f":"ROUNDUP(O3,1)","v":0},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":{"$error":"#DIV/0!"}}]
[2,{"$f":"B5","v":""},{"$f":"'9a.Monte Carlo Analysis'!D9","v":0},{"$f":"'9a.Monte Carlo Analysis'!E9","v":0},{"$f":"'9a.Monte Carlo Analysis'!F9","v":0},{"$f":"'9a.Monte Carlo Analysis'!G9","v":0},null,0.21218598365656305,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,null,null,{"$f":"(N5-N4)/30","v":0},{"$f":"(O5-O4)/30","v":0},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":{"$error":"#DIV/0!"}}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B11","v":""},{"$f":"'9a.Monte Carlo Analysis'!D11","v":0},{"$f":"'9a.Monte Carlo Analysis'!E11","v":0},{"$f":"'9a.Monte Carlo Analysis'!F11","v":0},{"$f":"'9a.Monte Carlo Analysis'!G11","v":0},null,0.73998498126872314,{"$f":"(E7-D7)/(F7-D7)","v":{"$error":"#DIV/0!"}},{"$f":"(D7+(F7-D7)*IF(H7<=I7,SQRT(H7*I7),1-SQRT((1-I7)*(1-H7))))","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"ROUNDUP(N6,1)","v":0},{"$f":"O6","v":0},null,null,null,null,null,null,null,{"$f":"(1-W5)-(W6)","v":{"$error":"#DIV/0!"}}]
[2,{"$f":"B7","v":""},{"$f":"'9a.Monte Carlo Analysis'!D12","v":0},{"$f":"'9a.Monte Carlo Analysis'!E12","v":0},{"$f":"'9a.Monte Carlo Analysis'!F12","v":0},{"$f":"'9a.Monte Carlo Analysis'!G12","v":0},null,0.73864532400878569,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B14","v":"Baseline Cost of "},{"$f":"'9a.Monte Carlo Analysis'!D14","v":0},{"$f":"'9a.Monte Carlo Analysis'!E14","v":0},{"$f":"'9a.Monte Carlo Analysis'!F14","v":0},{"$f":"'9a.Monte Carlo Analysis'!G14","v":0},null,0.46247249188663819,{"$f":"(E9-D9)/(F9-D9)","v":{"$error":"#DIV/0!"}},{"$f":"(D9+(F9-D9)*IF(H9<=I9,SQRT(H9*I9),1-SQRT((1-I9)*(1-H9))))","v":{"$error":"#DIV/0!"}}]
[2,null,{"$f":"'9a.Monte Carlo Analysis'!D15","v":0},{"$f":"'9a.Monte Carlo Analysis'!E15","v":0},{"$f":"'9a.Monte Carlo Analysis'!F15","v":0},{"$f":"'9a.Monte Carlo Analysis'!G15","v":0},null,0.80938429648412524,{"$f":"(E10-D10)/(F10-D10)","v":{"$error":"#DIV/0!"}},{"$f":"(D10+(F10-D10)*IF(H10<=I10,SQRT(H10*I10),1-SQRT((1-I10)*(1-H10))))","v":{"$error":"#DIV/0!"}}]
[1,"Baseline Cost of Hospital Day-Admission",{"$f":"'9a.Monte Carlo Analysis'!D17","v":0},{"$f":"'9a.Monte Carlo Analysis'!E17","v":0},{"$f":"'9a.Monte Carlo Analysis'!F17","v":0},{"$f":"'9a.Monte Carlo Analysis'!G17","v":0},null,0.90854522458972176,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[2,null,{"$f":"'9a.Monte Carlo Analysis'!D18","v":0},{"$f":"'9a.Monte Carlo Analysis'!E18","v":0},{"$f":"'9a.Monte Carlo Analysis'!F18","v":0},{"$f":"'9a.Monte Carlo Analysis'!G18","v":0},null,0.75859049937422263,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B20","v":"Costs per "},{"$f":"'9a.Monte Carlo Analysis'!D20","v":0},{"$f":"'9a.Monte Carlo Analysis'!E20","v":0},{"$f":"'9a.Monte Carlo Analysis'!F20","v":0},{"$f":"'9a.Monte Carlo Analysis'!G20","v":0},null,0.92992845486036291,{"$f":"(E13-D13)/(F13-D13)","v":{"$error":"#DIV/0!"}},{"$f":"(D13+(F13-D13)*IF(H13<=I13,SQRT(H13*I13),1-SQRT((1-I13)*(1-H13))))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B22","v":"Percentage Change in "},{"$f":"'9a.Monte Carlo Analysis'!D22*100+20","v":20},{"$f":"'9a.Monte Carlo Analysis'!E22*100+20","v":20},{"$f":"'9a.Monte Carlo Analysis'!F22*100+20","v":20},{"$f":"'9a.Monte Carlo Analysis'!G22*100+20","v":20},null,0.26765350852429282,{"$f":"(E14-D14)/(F14-D14)","v":{"$error":"#DIV/0!"}},{"$f":"(D14+(F14-D14)*IF(H14<=I14,SQRT(H14*I14),1-SQRT((1-I14)*(1-H14))))","v":{"$error":"#DIV/0!"}},null,null,"Point",0]
[null,{"$f":"'9a.Monte Carlo Analysis'!B24","v":"Percentage Change in "},{"$f":"'9a.Monte Carlo Analysis'!D24*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!E24*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!F24*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!G24*100+60","v":60},null,5.81280253457368E-2,{"$f":"(E15-D15)/(F15-D15)","v":{"$error":"#DIV/0!"}},{"$f":"(D15+(F15-D15)*IF(H15<=I15,SQRT(H15*I15),1-SQRT((1-I15)*(1-H15))))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B26","v":"Percentage Change in "},{"$f":"'9a.Monte Carlo Analysis'!D26*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!E26*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!F26*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!G26*100+60","v":60},null,0.33142375470809238,{"$f":"(E16-D16)/(F16-D16)","v":{"$error":"#DIV/0!"}},{"$f":"(D16+(F16-D16)*IF(H16<=I16,SQRT(H16*I16),1-SQRT((1-I16)*(1-H16))))","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B28","v":"Percentage Change in "},{"$f":"'9a.Monte Carlo Analysis'!D28*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!E28*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!F28*100+60","v":60},{"$f":"'9a.Monte Carlo Analysis'!G28*100+60","v":60},null,0.94748941205943038,{"$f":"(E17-D17)/(F17-D17)","v":{"$error":"#DIV/0!"}},{"$f":"(D17+(F17-D17)*IF(H17<=I17,SQRT(H17*I17),1-SQRT((1-I17)*(1-H17))))","v":{"$error":"#DIV/0!"}}]
[]
[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":0},{"$f":"COUNTIFS(T$27:T$10026,\">\" &N14,T$27:T$10026, \"<=\" &W24)","v":0},{"$f":"O$4+O$7*V24","v":0},{"$f":"COUNTIFS(U$27:U$10026,\">\" &P14,U$27:U$10026, \"<=\" &Y24)","v":0},{"$f":"X24/X$55","v":{"$error":"#DIV/0!"}},{"$f":"Z24/Z$55","v":{"$error":"#DIV/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":0},{"$f":"COUNTIFS(T$27:T$10026,\">\" &W24,T$27:T$10026, \"<=\" &W25)","v":0},{"$f":"O$4+O$7*V25","v":0},{"$f":"COUNTIFS(U$27:U$10026,\">\" &Y24,U$27:U$10026, \"<=\" &Y25)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0,{"$f":"COUNTIFS(T$27:T$10026,\">\" &W25,T$27:T$10026, \"<=\" &W26)","v":0},{"$f":"O$4+O$7*V26","v":0},{"$f":"COUNTIFS(U$27:U$10026,\">\" &Y25,U$27:U$10026, \"<=\" &Y26)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17,0,0,0,{"$f":"COUNTIFS(U$27:U$10026,\">\" &Y40,U$27:U$10026, \"<=\" &Y41)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(X24:X54)","v":0},null,{"$f":"SUM(Z24:Z54)","v":0}]

{"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",null,"Members"]
[]
["Levels of Utilization"]
[null,"Group","Percentage Cut Off","Range","Level Members","Test Group"]
["Most Severe Members","Level 1",null,{"$f":"IF(ISNUMBER(C5),\"0 to \"&TEXT(C5,\"##%\"),\"\")","v":""},{"$f":"IF(TESTONLY,F5,IFERROR('3.Population Data'!C5*'3.Population Data'!B1,0))","v":0},null,null,null,null,null,false,{"$f":"\"0 to \" & TEXT(F5/B1,\"##.#%\")","v":{"$error":"#DIV/0!"}}]
["Next Most Severe Members","Level 2",null,{"$f":"IF(E6=0,\"\",TEXT(C5,\"##%\")  & \" to \" & TEXT(C6,\"##%\"))","v":""},{"$f":"IFERROR(IF(OR(TESTONLY=TRUE,C6=0),0,'3.Population Data'!B1*('3.Population Data'!C6-'3.Population Data'!C5)),0)","v":0}]
[null,null,null,"Total Members Targeted",{"$f":"IF(K5,F5,E5+E6)","v":0}]

{"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,"Total Launch Costs",{"$f":"SUM(C4:C18)","v":0}]
[]
[]
[null,"4b. Operating Costs",null,"Target Population set at:",{"$f":"'3.Population Data'!E7","v":0}]
[null,{"$f":"\"Fixed Costs for PCC\"","v":"Fixed Costs for PCC"}]
[null,"Position","FTE","Annual Cost","Annual Program Cost"]
[null,null,null,null,{"$f":"IFERROR(IF(C25=\"\",1,C25)*D25,0)","v":0}]
[null,null,null,null,{"$f":"IFERROR(IF(C26=\"\",1,C26)*D26,0)","v":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,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":0}]
[]
[null,null,"Overhead %",null,{"$f":"IFERROR(E40*D42,0)","v":0}]
[null,null,null,"Total Fixed Costs with O/H",{"$f":"E40+E42","v":0}]
[null,null,null,"PMPM FC",{"$f":"IFERROR(E43/12/E22,0)","v":0}]
[]
[]
[null," 4c. Variable Costs for Direct Services","Per Member per Month"]
[null,"Item","PMPM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Total",{"$f":"SUM(C49:C58)","v":0}]
[null,"Overhead as a percent of Total Var.Costs",null,{"$f":"IFERROR(C60*C59,0)","v":0}]
[null,null,"Average Variable Costs with overhead  PMPM",{"$f":"C59+D60","v":0}]

{"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  Members Served"}]
["Exclude from Analysis","Service",null,"Costs Per","Added Units",null,"Weighted PMPM"]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(C5=\"Year\",1/12,IF(C5=\"day\",30,1))*E5*D5*F5*(1-N5),0)","v":0},null,null,null,null,null,false,{"$f":"IF(M5,1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IFERROR(IF(C6=\"Year\",1/12,IF(C6=\"day\",30,1))*E6*D6*F6*(1-N6),0)","v":0},null,null,null,null,null,false,0,"Day"]
[null,null,null,null,null,null,0,null,null,null,null,null,false,{"$f":"IF(M7,1,0)","v":0},"Month"]
[null,null,null,null,null,null,0,null,null,null,null,null,false,0,"Year"]
[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,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":0}]

{"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,null,null,null,null,null,null,null,{"$f":"IFERROR(D4*$F4*$AE4/IF($H4=0,1,$H4),0)","v":0},{"$f":"IFERROR(E4*$F4*$AE4/IF($H4=0,1,$H4),0)","v":0},null,"-20% to +20%",null,null,null,{"$f":"IFERROR(AA4/100-0.2,0)","v":0},{"$f":"IFERROR(-P4*I4*NOT(AF4),0)","v":0},{"$f":"IFERROR(-J4*P4*NOT(AF4),0)","v":0},null,null,null,null,null,{"$f":"IF($AF4,0,I4)","v":0},{"$f":"IF($AF4,0,J4)","v":0},null,20,null,null,2,{"$f":"VLOOKUP(AD4,AG$4:AH$5,2,0)","v":8.3333333333333329E-2},false,1,1,null,{"$f":"IF($AF4,0,Q4)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF4,0,R4),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(D5*$F5*$AE5/IF($H5=0,1,$H5),0)","v":0},{"$f":"IFERROR(E5*$F5*$AE5/IF($H5=0,1,$H5),0)","v":0},null,"-20% to +20%",null,null,null,{"$f":"IFERROR(AA5/100-0.2,0)","v":0},{"$f":"IFERROR(-P5*I5*NOT(AF5),0)","v":0},{"$f":"IFERROR(-J5*P5*NOT(AF5),0)","v":0},null,null,null,null,null,{"$f":"IF($AF5,0,I5)","v":0},{"$f":"IF($AF5,0,J5)","v":0},null,20,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":0},0]
[null,null,null,null,null,null,null,null,0,0,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA6)/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,{"$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,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,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,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":0},{"$f":"IF(TESTONLY,0,'3.Population Data'!E6)","v":0}]
[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":0},{"$f":"'8a.Summary'!D36","v":2}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(basehospday*C25*V18*(1-AF18),0)","v":0},{"$f":"IFERROR(W18*D25*D32*(1-AF18),0)","v":0},null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA18)/100,0)","v":0},{"$f":"IFERROR(I18-(X18*X25*X32),0)","v":0},{"$f":"IFERROR(J18-(Y18*Y25*Y32),0)","v":0},null,null,null,{"$f":"C18/(IF($H18=0,1,$H18)*IF($AD18=2,12,1))","v":0},{"$f":"D18/(IF($H18=0,1,$H18)*IF($AD18=2,12,1))","v":0},{"$f":"+(1+$P18)*V18*(1-$AF18)","v":0},0,null,60,null,null,1,null,false,null,null,null,{"$f":"IF($AF18,0,K18)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF18,0,R18),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(C33*C26*V19*(1-AF19),0)","v":0},{"$f":"IFERROR(W19*D26*D33*(1-AF19),0)","v":0},null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA19)/100,0)","v":0},{"$f":"IFERROR(I19-(X19*X26*X33),0)","v":0},0,null,null,null,{"$f":"C19/(IF(H19=0,1,H19)*IF(AD19=2,12,1))","v":0},{"$f":"D19/(IF($H19=0,1,$H19)*IF($AD19=2,12,1))","v":0},0,0,null,60,null,null,1,null,false,null,null,null,{"$f":"IF($AF19,0,K19)","v":0},{"$f":"IF(NOT(TESTONLY),IF($AF19,0,R19),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IFERROR(C34*C27*V20*(1-AF20),0)","v":0},0,null,"-60% to 0%",null,null,null,0,{"$f":"IFERROR(I20-(X20*X27*X34),0)","v":0},0,null,null,null,{"$f":"C20/(IF(H20=0,1,H20)*IF(AD20=2,12,1))","v":0},{"$f":"D20/(IF($H20=0,1,$H20)*IF($AD20=2,12,1))","v":0},0,0,null,60,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":0}]
[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,false,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":""},null,null,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA25)/100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J25)*C25*(1-$AF25)","v":0},{"$f":"+(1+$J25)*D25*(1-$AF25)","v":0},null,60]
[null,{"$f":"IF(ISBLANK(B19),\"\",B19)","v":""},null,null,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA26)/100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J26)*C26*(1-$AF26)","v":0},{"$f":"+(1+$J26)*D26*(1-$AF26)","v":0},null,60,null,null,null,null,null,null,null,null,{"$f":"SUM(AJ18:AJ22)+SUM(AJ4:AJ12)","v":0},{"$f":"SUM(AK18:AK22)+SUM(AK4:AK12)","v":0}]
[null,"",null,null,null,"-60% to 0%",null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J27)*C27*(1-$AF27)","v":0},{"$f":"+(1+$J27)*D27*(1-$AF27)","v":0},null,60,null,null,null,null,null,null,null,null,{"$f":"AJ15","v":0},{"$f":"AK15","v":0}]
[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":{"$error":"#DIV/0!"}}]
[]
[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":""},null,null,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA32)/100,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+(1+$J32)*C32*(1-$AF32)","v":0},{"$f":"+(1+$J32)*D32*(1-$AF32)","v":0},null,60]
[null,{"$f":"IF(ISBLANK(B19),\"\",B26)","v":""},null,null,null,"-60% to 0%",null,null,null,{"$f":"IFERROR(-(60-AA33)/100,0)","v":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,"-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":0},{"$f":"IF(TESTONLY=TRUE,0,SUM(J18:J22)+SUM(J4:J12))","v":0}]
[null,null,"Members",{"$f":"AJ15","v":0},{"$f":"AK27","v":0},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":0},{"$f":"IF(TESTONLY=TRUE,0,SUM(R18:R22)+SUM(R4:R12))","v":0}]
[null,null,"Baseline Costs PMPM",{"$f":"Y39","v":0},{"$f":"Z39","v":0},{"$f":"IFERROR(X42,0)","v":0}]
[null,null,"Reduced Costs PMPM",{"$f":"Y40","v":0},{"$f":"Z40","v":0},{"$f":"IFERROR(X43,0)","v":0},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":{"$error":"#DIV/0!"}}]
[null,null,"Percent Reduction",{"$f":"IFERROR(D42/D41,0)","v":0},{"$f":"IF(E41=0,0,E42/E41)","v":0},{"$f":"IFERROR(F42/F41,0)","v":0},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":{"$error":"#DIV/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,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":0}]
[]
[]
[]
[null,"7a. Additional Benefits (Annual Based)"]
[null,"Current Target Population",{"$f":"'3.Population Data'!E7","v":0}]
[]
[null,"Benefit","Total Annual","PMPM"]
[null,null,null,{"$f":"IFERROR(C22/C$19/12,0)","v":0}]
[null,null,null,{"$f":"IFERROR(C23/C$19/12,0)","v":0}]
[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":0},{"$f":"SUM(D22:D28)","v":0}]
[]
[]
[]
[null,"7b. Additional Benefits (PMPM Based)"]
[]
[]
[null,"Benefit","PMPM","Total Annual"]
[null,null,null,{"$f":"IFERROR(C37*C$19*12,0)","v":0}]
[null,null,null,{"$f":"IFERROR(C38*C$19*12,0)","v":0}]
[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(C37:C43)","v":0},{"$f":"SUM(D37:D43)","v":0}]

{"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":0}]
[null,null,"Level 1",{"$f":"IF('3.Population Data'!K5,'3.Population Data'!F5,'3.Population Data'!E5)","v":0},{"$f":"IF('3.Population Data'!K5,'3.Population Data'!L5,'3.Population Data'!D5)","v":""}]
[null,null,"Level 2",{"$f":"IF('3.Population Data'!K5,0,'3.Population Data'!E6)","v":0},{"$f":"IF('3.Population Data'!K5,\"\",'3.Population Data'!D6)","v":""}]
[null,null,"Total",{"$f":"D3+D4","v":0}]
[]
[null,"Launch Costs",null,{"$f":"'4.Costs'!C19","v":0},"One Time"]
[null,null,"PMPM","All Members per Month"]
[null,"Operating Costs",{"$f":"'4.Costs'!E44","v":0},{"$f":"'4.Costs'!E44*D5","v":0}]
[]
[null,"Direct Services",{"$f":"'4.Costs'!C59","v":0},{"$f":"C11*D$5","v":0}]
[null,"Overhead",{"$f":"'4.Costs'!D60","v":0},{"$f":"C12*D$5","v":0}]
[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":0},0]
[null,null,{"$f":"SUM(C11:C14)","v":0},{"$f":"SUM(D11:D14)","v":0}]
[]
[null,"Total Operating Costs",{"$f":"C9+SUM(C11:C14)","v":0},null,{"$f":"D15+D9","v":0}]
[]
[null,"Benefit Savings","PMPM","All Members per Month"]
[null,"Level 1",{"$f":"'6.Medical Utilization'!D42","v":0},{"$f":"C20*D3","v":0}]
[null,"Level 2",{"$f":"IF('3.Population Data'!K5,0,'6.Medical Utilization'!E42)","v":0},{"$f":"C21*D4","v":0}]
[]
[null,"Additional Benefits",{"$f":"'7.Revenue Enhancements'!D29+'7.Revenue Enhancements'!C44","v":0},{"$f":"C23*D5","v":0}]
[]
[null,"Total Monthly Benefits",{"$f":"IFERROR(E25/D5,0)","v":0},null,{"$f":"D20+D21+D23","v":0}]
[]
[null,"Net Benefit PMPM",{"$f":"IFERROR(E28/D5,0)","v":0}]
[null,"Total Net Benefit Per Month",null,null,{"$f":"E25-E17","v":0}]
[]
[null,"ROI",null,null,{"$f":"IFERROR(E28/E17, 0)","v":0}]
[null,"Startup Payback (months)",null,null,{"$f":"IFERROR(D7/E28,0)","v":0}]
[]
[]
[null,"Find the change in Hospital Admissions required to yield the ROI Goal"]
[]
[null,null,"ROI  Goal:",2]
[null,null,"Hospital Admissions Event Change:",-0.18681298582533132]
[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:",2]
[null,null,"Annual Operating Costs:",{"$f":"+E25/(1+D42)","v":0}]
[null,null,"PMPM:",{"$f":"+D43/'3.Population Data'!E7","v":{"$error":"#DIV/0!"}}]

{"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":""},null,{"$f":"IF(ISBLANK('Scen Meta'!D8),\"\",'Scen Meta'!D8)","v":""},null,null,null,null,{"$f":"IF(ISBLANK('Scen Meta'!C9),\"\",'Scen Meta'!C9)","v":""},null,{"$f":"IF(ISBLANK('Scen Meta'!D9),\"\",'Scen Meta'!D9)","v":""}]
[]
[null,"Eligible Population",{"$f":"INDIRECT(\"scenarios!\" & \"D\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,null,"Eligible Population",{"$f":"INDIRECT(\"scenarios!\" & \"D\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,null,"Eligible Population",{"$f":"J5-C5","v":{"$error":"#REF!"}}]
[null,null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"e\" &'Scen Meta'!$B$8)*C5","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nx\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"e\" &'Scen Meta'!$B$9)*J5","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nx\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Level 1",{"$f":"K6-D6","v":{"$error":"#REF!"}}]
[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":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"ny\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},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":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"ny\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Level 2",{"$f":"K7-D7","v":{"$error":"#REF!"}}]
[null,null,"Total",{"$f":"D6+D7","v":{"$error":"#REF!"}},null,null,null,null,null,"Total",{"$f":"K6+K7","v":{"$error":"#REF!"}},null,null,null,null,null,"Total",{"$f":"K8-D8","v":{"$error":"#REF!"}}]
[]
[null,"Launch Costs",null,{"$f":"INDIRECT(\"scenarios!\" & \"my\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},"One Time",null,null,null,"Launch Costs",null,{"$f":"INDIRECT(\"scenarios!\" & \"my\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},"One Time",null,null,null,"Launch Costs",null,{"$f":"K10-D10","v":{"$error":"#REF!"}},"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":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"na\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Operating Costs",{"$f":"INDIRECT(\"scenarios!\" & \"mz\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"na\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Operating Costs",{"$f":"J12-C12","v":{"$error":"#REF!"}},{"$f":"K12-D12","v":{"$error":"#REF!"}}]
[]
[null,"Direct Services",{"$f":"INDIRECT(\"scenarios!\" & \"nb\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nc\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Direct Services",{"$f":"INDIRECT(\"scenarios!\" & \"nb\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nc\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Direct Services",{"$f":"J14-C14","v":{"$error":"#REF!"}},{"$f":"K14-D14","v":{"$error":"#REF!"}}]
[null,"Overhead",{"$f":"INDIRECT(\"scenarios!\" & \"nd\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"ne\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Overhead",{"$f":"INDIRECT(\"scenarios!\" & \"nd\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"ne\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Overhead",{"$f":"J15-C15","v":{"$error":"#REF!"}},{"$f":"K15-D15","v":{"$error":"#REF!"}}]
[]
[null,"Additional Services",{"$f":"INDIRECT(\"scenarios!\" & \"nf\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"ng\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Additional Services",{"$f":"INDIRECT(\"scenarios!\" & \"nf\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"ng\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Additional Services",{"$f":"J17-C17","v":{"$error":"#REF!"}},{"$f":"K17-D17","v":{"$error":"#REF!"}}]
[null,null,{"$f":"SUM(C14:C17)","v":{"$error":"#REF!"}},{"$f":"SUM(D14:D17)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUM(J14:J17)","v":{"$error":"#REF!"}},{"$f":"SUM(K14:K17)","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"SUM(Q14:Q17)","v":{"$error":"#REF!"}},{"$f":"SUM(R14:R17)","v":{"$error":"#REF!"}}]
[]
[null,"Total Operating Costs",{"$f":"C12+SUM(C14:C17)","v":{"$error":"#REF!"}},null,{"$f":"D18+D12","v":{"$error":"#REF!"}},null,null,null,"Total Operating Costs",{"$f":"J12+SUM(J14:J17)","v":{"$error":"#REF!"}},null,{"$f":"K18+K12","v":{"$error":"#REF!"}},null,null,null,"Total Operating Costs",{"$f":"Q12+SUM(Q14:Q17)","v":{"$error":"#REF!"}},null,{"$f":"R18+R12","v":{"$error":"#REF!"}}]
[]
[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":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nm\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Level 1",{"$f":"INDIRECT(\"scenarios!\" & \"nl\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nm\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Level 1",{"$f":"J23-C23","v":{"$error":"#REF!"}},{"$f":"K23-D23","v":{"$error":"#REF!"}}]
[null,"Level 2",{"$f":"INDIRECT(\"scenarios!\" & \"nn\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"no\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Level 2",{"$f":"INDIRECT(\"scenarios!\" & \"nn\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"no\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Level 2",{"$f":"J24-C24","v":{"$error":"#REF!"}},{"$f":"K24-D24","v":{"$error":"#REF!"}}]
[]
[null,"Additional Benefits",{"$f":"INDIRECT(\"scenarios!\" & \"np\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nq\" &'Scen Meta'!$B$8)","v":{"$error":"#REF!"}},null,null,null,null,"Additional Benefits",{"$f":"INDIRECT(\"scenarios!\" & \"np\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(\"scenarios!\" & \"nq\" &'Scen Meta'!$B$9)","v":{"$error":"#REF!"}},null,null,null,null,"Additional Benefits",{"$f":"J26-C26","v":{"$error":"#REF!"}},{"$f":"K26-D26","v":{"$error":"#REF!"}}]
[]
[null,"Total Monthly Benefits",{"$f":"IFERROR(E28/D8,0)","v":0},null,{"$f":"D23+D24+D26","v":{"$error":"#REF!"}},null,null,null,"Total Monthly Benefits",{"$f":"IFERROR(L28/K8,0)","v":0},null,{"$f":"K23+K24+K26","v":{"$error":"#REF!"}},null,null,null,"Total Monthly Benefits",0,null,{"$f":"L28-E28","v":{"$error":"#REF!"}}]
[]
[null,"Net Benefit PMPM",{"$f":"IFERROR(E31/D8,0)","v":0},null,null,null,null,null,"Net Benefit PMPM",{"$f":"IFERROR(L31/K8,0)","v":0},null,null,null,null,null,"Net Benefit PMPM",0]
[null,"Total Net Benefit Per Month",null,null,{"$f":"E28-E20","v":{"$error":"#REF!"}},null,null,null,"Total Net Benefit Per Month",null,null,{"$f":"L28-L20","v":{"$error":"#REF!"}},null,null,null,"Total Net Benefit Per Month",null,null,{"$f":"L31-E31","v":{"$error":"#REF!"}}]
[]
[null,"Operating Margin ROI",null,null,{"$f":"IFERROR(E31/E20,0)","v":0},null,null,null,"Operating Margin ROI",null,null,{"$f":"IFERROR(L31/L20,0)","v":0},null,null,null,"Operating Margin ROI",null,null,{"$f":"L33-RETURNONINV","v":0}]
[null,"Startup Payback (months)",null,null,{"$f":"IFERROR(D10/E31,0)","v":0},null,null,null,"Startup Payback (months)",null,null,{"$f":"IFERROR(K10/L31,0)","v":0},null,null,null,"Startup Payback (months)",null,null,{"$f":"L34-PBMONTH","v":0}]

{"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":0},0,0,0,{"$f":"AVERAGE(E3:G3)","v":0}]
[]
[null,{"$f":"IF(ISBLANK('6.Medical Utilization'!B18),\"\",'6.Medical Utilization'!B18)","v":""},"Level 1",{"$f":"'6.Medical Utilization'!C18","v":0},0,0,0,{"$f":"SUM(E5:G5)/3","v":0},null,null,null,null,null,1,null,null,"HA Complete",{"$f":"IF('6.Medical Utilization'!I18<>0,1,0)","v":0}]
[null,null,"Level 2",{"$f":"'6.Medical Utilization'!D18","v":0},0,0,0,{"$f":"SUM(E6:G6)/3","v":0},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":""},"Level 1",{"$f":"'6.Medical Utilization'!C19","v":0},0,0,0,{"$f":"SUM(E8:G8)/3","v":0},null,null,null,null,null,1,null,null,"HR Complete",{"$f":"IF('6.Medical Utilization'!I19<>0,1,0)","v":0}]
[null,null,"Level 2",{"$f":"'6.Medical Utilization'!D19","v":0},0,0,0,{"$f":"SUM(E9:G9)/3","v":0},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":""},"Level 1",{"$f":"'6.Medical Utilization'!D6","v":0},0,0,0,{"$f":"SUM(E11:G11)/3","v":0},null,null,"Aggressive",0.2,null,1,null,null,"ED Complete",{"$f":"IF('6.Medical Utilization'!D6<>0,1,0)","v":0}]
[null,null,"Level 2",{"$f":"'6.Medical Utilization'!E6","v":0},0,0,0,{"$f":"SUM(E12:G12)/3","v":0},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 "},"Level1",{"$f":"'6.Medical Utilization'!C32","v":0},0,0,0,{"$f":"SUM(E14:G14)/3","v":0},null,null,null,null,null,1]
[null,null,"Level2",{"$f":"'6.Medical Utilization'!D32","v":0},0,0,0,{"$f":"SUM(E15:G15)/3","v":0},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":""},"Level1",{"$f":"'6.Medical Utilization'!C33","v":0},0,0,0,0,null,null,null,null,null,1]
[null,null,"Level2",{"$f":"'6.Medical Utilization'!D33","v":0},0,0,0,0,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 "},null,{"$f":"'6.Medical Utilization'!F6","v":0},0,0,0,{"$f":"SUM(E20:G20)/3","v":0},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 "},null,{"$f":"'6.Medical Utilization'!P5","v":0},0,0,0,{"$f":"SUM(E22:G22)/3","v":0},null,null,null,null,null,1,null,null,null,{"$f":"IF('6.Medical Utilization'!I5<>0,1,0)","v":0}]
[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 "},null,{"$f":"'6.Medical Utilization'!P6","v":0},0,0,0,{"$f":"SUM(E24:G24)/3","v":0},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 "},null,{"$f":"'6.Medical Utilization'!P18","v":0},0,0,0,{"$f":"SUM(E26:G26)/3","v":0},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 "},null,{"$f":"'6.Medical Utilization'!P19","v":0},0,0,0,{"$f":"SUM(E28:G28)/3","v":0},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":0}]
[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":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Var",{"$f":"'4.Costs'!D61","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add",{"$f":"'5.Additional Utilizations'!G19","v":0}]
[null,null,null,null,null,null,"Average Net Benefit PMPM",{"$f":"IFERROR(AVERAGE(MCCALCS!T27:T10026),\"Insufficient Data\")","v":"Insufficient Data"},null,null,null,null,null,null,null,null,"Error",{"$f":"SUM(R31:R33)","v":0}]
[null,null,null,null,null,null,"Average ROI",{"$f":"IFERROR(AVERAGE(MCCALCS!U27:U10026),\"Insufficient Data\")","v":"Insufficient Data"}]
[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":1}]
[]
[]
[null,null,null,"Net Benefit PMPM"]
[null,null,null,null,"Percent Less than",null,2715.2379000000001,{"$f":"IFERROR(MCCALCS!W5,\"\")","v":""}]
[null,null,null,null,"Percent Greater than",null,3318.6241000000005,{"$f":"IFERROR(MCCALCS!W6,\"\")","v":""}]
[null,null,null,null,"Percent Between",null,null,{"$f":"IFERROR(MCCALCS!W7,\"\")","v":""}]
[null,null,null,"ROI"]
[null,null,null,null,"Percent Less than",null,2.4315562883511368,{"$f":"IFERROR(MCCALCS!W2,\"\")","v":""}]
[null,null,null,null,"Percent Greater than",null,2.9719021302069448,{"$f":"IFERROR(MCCALCS!W3,\"\")","v":""}]
[null,null,null,null,"Percent Between",null,null,{"$f":"IFERROR(MCCALCS!W4,\"\")","v":""}]

{"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":0}]
[2,{"$f":"'8a.Summary'!E$28","v":0}]
[3,{"$f":"'8a.Summary'!E$28","v":0}]
[4,{"$f":"'8a.Summary'!E$28","v":0}]
[5,{"$f":"'8a.Summary'!E$28","v":0}]
[6,{"$f":"'8a.Summary'!E$28","v":0}]
[7,{"$f":"'8a.Summary'!E$28","v":0}]
[8,{"$f":"'8a.Summary'!E$28","v":0}]
[9,{"$f":"'8a.Summary'!E$28","v":0}]
[10,{"$f":"'8a.Summary'!E$28","v":0}]
[11,{"$f":"'8a.Summary'!E$28","v":0}]
[12,{"$f":"'8a.Summary'!E$28","v":0}]
[13,{"$f":"'8a.Summary'!E$28","v":0}]
[14,{"$f":"'8a.Summary'!E$28","v":0}]
[15,{"$f":"'8a.Summary'!E$28","v":0}]
[16,{"$f":"'8a.Summary'!E$28","v":0}]
[17,{"$f":"'8a.Summary'!E$28","v":0}]
[18,{"$f":"'8a.Summary'!E$28","v":0}]
[19,{"$f":"'8a.Summary'!E$28","v":0}]
[20,{"$f":"'8a.Summary'!E$28","v":0}]
[21,{"$f":"'8a.Summary'!E$28","v":0}]
[22,{"$f":"'8a.Summary'!E$28","v":0}]
[23,{"$f":"'8a.Summary'!E$28","v":0}]
[24,{"$f":"'8a.Summary'!E$28","v":0}]
[25,{"$f":"'8a.Summary'!E$28","v":0}]
[26,{"$f":"'8a.Summary'!E$28","v":0}]
[27,{"$f":"'8a.Summary'!E$28","v":0}]
[28,{"$f":"'8a.Summary'!E$28","v":0}]
[29,{"$f":"'8a.Summary'!E$28","v":0}]
[30,{"$f":"'8a.Summary'!E$28","v":0}]
[31,{"$f":"'8a.Summary'!E$28","v":0}]
[32,{"$f":"'8a.Summary'!E$28","v":0}]
[33,{"$f":"'8a.Summary'!E$28","v":0}]
[34,{"$f":"'8a.Summary'!E$28","v":0}]
[35,{"$f":"'8a.Summary'!E$28","v":0}]
[36,{"$f":"'8a.Summary'!E$28","v":0}]
[37,{"$f":"'8a.Summary'!E$28","v":0}]
[38,{"$f":"'8a.Summary'!E$28","v":0}]
[39,{"$f":"'8a.Summary'!E$28","v":0}]
[40,{"$f":"'8a.Summary'!E$28","v":0}]
[41,{"$f":"'8a.Summary'!E$28","v":0}]
[42,{"$f":"'8a.Summary'!E$28","v":0}]
[43,{"$f":"'8a.Summary'!E$28","v":0}]
[44,{"$f":"'8a.Summary'!E$28","v":0}]
[45,{"$f":"'8a.Summary'!E$28","v":0}]
[46,{"$f":"'8a.Summary'!E$28","v":0}]
[47,{"$f":"'8a.Summary'!E$28","v":0}]
[48,{"$f":"'8a.Summary'!E$28","v":0}]
[49,{"$f":"'8a.Summary'!E$28","v":0}]
[50,{"$f":"'8a.Summary'!E$28","v":0}]
[51,{"$f":"'8a.Summary'!E$28","v":0}]
[52,{"$f":"'8a.Summary'!E$28","v":0}]
[53,{"$f":"'8a.Summary'!E$28","v":0}]
[54,{"$f":"'8a.Summary'!E$28","v":0}]
[55,{"$f":"'8a.Summary'!E$28","v":0}]
[56,{"$f":"'8a.Summary'!E$28","v":0}]
[57,{"$f":"'8a.Summary'!E$28","v":0}]
[58,{"$f":"'8a.Summary'!E$28","v":0}]
[59,{"$f":"'8a.Summary'!E$28","v":0}]
[60,{"$f":"'8a.Summary'!E$28","v":0}]

{"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":""},1,{"$f":"'9a.Monte Carlo Analysis'!D5","v":0},{"$f":"SACALCS!R3","v":{"$error":"#DIV/0!"}}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D6","v":0},{"$f":"SACALCS!R4","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B8","v":""},1,{"$f":"'9a.Monte Carlo Analysis'!D8","v":0},{"$f":"SACALCS!R5","v":{"$error":"#DIV/0!"}}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D9","v":0},{"$f":"SACALCS!R6","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B11","v":""},1,{"$f":"'9a.Monte Carlo Analysis'!D11","v":0},{"$f":"SACALCS!R7","v":{"$error":"#DIV/0!"}}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D12","v":0},{"$f":"SACALCS!R8","v":{"$error":"#DIV/0!"}}]
[null,"Costs"]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B14","v":"Baseline Cost of "},1,{"$f":"'9a.Monte Carlo Analysis'!D14","v":0},{"$f":"SACALCS!R9","v":{"$error":"#DIV/0!"}}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D15","v":0},{"$f":"SACALCS!R10","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B17","v":""},1,{"$f":"'9a.Monte Carlo Analysis'!D17","v":0},{"$f":"SACALCS!R11","v":{"$error":"#DIV/0!"}}]
[null,null,null,2,{"$f":"'9a.Monte Carlo Analysis'!D18","v":0},{"$f":"SACALCS!R12","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B20","v":"Costs per "},null,{"$f":"'9a.Monte Carlo Analysis'!D20","v":0},{"$f":"SACALCS!R13","v":{"$error":"#DIV/0!"}}]
[null,null,"Total Operating Costs",null,{"$f":"'8a.Summary'!E17","v":0},{"$f":"+SACALCS!R14","v":{"$error":"#DIV/0!"}}]
[null,"Reduction Rate of Visits"]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B22","v":"Percentage Change in "},null,{"$f":"'9a.Monte Carlo Analysis'!D22","v":0},{"$f":"SACALCS!R15","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B24","v":"Percentage Change in "},null,{"$f":"'9a.Monte Carlo Analysis'!D24","v":0},{"$f":"SACALCS!R16","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B26","v":"Percentage Change in "},null,{"$f":"'9a.Monte Carlo Analysis'!D26","v":0},{"$f":"SACALCS!R17","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"'9a.Monte Carlo Analysis'!B28","v":"Percentage Change in "},null,{"$f":"'9a.Monte Carlo Analysis'!D28","v":0},{"$f":"SACALCS!R18","v":{"$error":"#DIV/0!"}}]

{"sheet":"Scenarios","index":20,"n_rows":1,"n_cols":391,"rows_kept":1,"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"]

{"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:A458)","v":0},{"$f":"COUNT(Scenarios!A2:A458)","v":0}]
[null,null,null,null,null,null,null,"Navigation Selected",null,"MC Navigation Selected"]
[null,null,null,null,null,null,null,10]
[]
[null,"Comparison Scenarios"]
["Scenerio","#","Name","Date",null,null,null,null,"Required","9a. Monte Carlo Data"]
["A",null,null,null,null,null,0,"1.  Start",null,"9b. MC Results-ROI Chart"]
["B",null,null,null,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"]
[2,null,null,null,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",0,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$83,MATCH(1,Scenarios!NZ$1:NZ$83))","v":{"$error":"#N/A"}},{"$f":"MATCH(1,Scenarios!NZ$1:NZ$80)","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":0},{"$f":"OR(ISERROR(I32),I32=0)","v":true},{"$f":"IF(J32=TRUE,\"Missing Population Data\",\"\")","v":"Missing Population Data"}]
[null,null,null,null,null,null,null,"4a. Launch Costs",{"$f":"launchcosts","v":0}]
[null,null,null,null,null,null,null,"4b.Operating Costs",{"$f":"'4.Costs'!E43","v":0}]
[null,null,null,null,null,null,null,"4c. Variable Costs",{"$f":"+'4.Costs'!D61","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(I33:I35)=0,TRUE,FALSE)","v":true}]

{"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":""},null,null,null,null,null,null,null,null,null,null,null,"Baseadmin",null,{"$f":"1-F3/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"1-G3/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(ABS(P3),ABS(Q3))/0.01","v":{"$error":"#DIV/0!"}},null,{"$f":"1-I3/$C$20","v":{"$error":"#DIV/0!"}},{"$f":"1-J3/$C$20","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(ABS(T3),ABS(U3))/0.01","v":{"$error":"#DIV/0!"}}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,"baseadmin2",null,{"$f":"1-F4/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"1-G4/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(ABS(P4),ABS(Q4))/0.01","v":{"$error":"#DIV/0!"}},null,{"$f":"1-I4/$C$20","v":{"$error":"#DIV/0!"}},{"$f":"1-J4/$C$20","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(ABS(T4),ABS(U4))/0.01","v":{"$error":"#DIV/0!"}}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B8","v":""},null,null,null,null,null,null,null,null,null,null,null,"Basereadmin",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,"Basereadmin2",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B11","v":""},null,null,null,null,null,null,null,null,null,null,null,"baseed",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,"baseed2",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,{"$f":"'9a.Monte Carlo Analysis'!B14","v":"Baseline Cost of "},null,null,null,null,null,null,null,null,null,null,null,"basehospdayAD1",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,"basehospdayAD2",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[1,"Baseline Cost of Hospital Day-Admission",null,null,null,null,null,null,null,null,null,null,null,"basehospdayRE1",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[2,null,null,null,null,null,null,null,null,null,null,null,null,"basehospdayRE2",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B20","v":"Costs per "},null,null,null,null,null,null,null,null,null,null,null,"edcosts",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Total Operating Costs",null,null,null,null,null,null,null,null,null,null,null,"topcost",null,{"$f":"1-F14/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"1-G14/$C$19","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(ABS(P14),ABS(Q14))/0.01","v":{"$error":"#DIV/0!"}},null,{"$f":"1-I14/$C$20","v":{"$error":"#DIV/0!"}},{"$f":"1-J14/$C$20","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(ABS(T14),ABS(U14))/0.01","v":{"$error":"#DIV/0!"}}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B22","v":"Percentage Change in "},null,null,null,null,null,null,null,null,null,null,null,"pcspecvisit1",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B24","v":"Percentage Change in "},null,null,null,null,null,null,null,null,null,null,null,"pcedvisit1",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B26","v":"Percentage Change in "},null,null,null,null,null,null,null,null,null,null,null,"pcadmin1",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,{"$f":"'9a.Monte Carlo Analysis'!B28","v":"Percentage Change in "},null,null,null,null,null,null,null,null,null,null,null,"pcreadmin1",null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Net Bennefit PMPM"]
[null,"ROI"]