{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Disclaimer","Instructions","References & Assumptions","MODEL INPUT","Input by Entity","Lookups","Assumptions","Data","Revenue at Risk Summary","Charts_Rev & Margin","Charts_Performance","Lookups for charts_WS2","Lookups for charts_WS1"],"not_rendered":{"charts":18,"images":0,"macros":1,"external_links":0,"defined_names":334,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Disclaimer","index":0,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Disclaimer for Software"]
["Important: This Excel Model (\"Software\") is the property of the Society of Actuaries (SOA) and is protected under U.S. and international copyright laws."]
["The Software has been developed for the benefit of actuaries FOR EDUCATIONAL USE ONLY, although others may find it useful. SOA and the author make the Software available to individual users for their personal use on a non–exclusive basis. No commercial use, reproduction or distribution is permitted whatsoever."]
["SOA and the author make no warranty, guarantee, or representation, either expressed or implied, regarding the Software, including its quality, accuracy, reliability, or suitability, and HEREBY DISCLAIM ANY WARRANTY REGARDING THE SOFTWARE'S MERCHANTABILITY OR FITNESS FOR ANY PARTICULAR PURPOSE. SOA and the author make no warranty that the Software is free from errors, defects, worms, viruses or other elements or codes that manifest contaminating or destructive properties. In no event shall SOA or the author be liable for any damages (including any lost profits, lost savings, or direct, indirect, incidental, consequential or other damages) in connection with or resulting from the use, misuse, reliance on, or performance of any aspect of the Software including any instructions or documentation accompanying the Software. SOA and the author make no representation or warranty of non–infringement of proprietary rights of others with respect to the Software. The entire risk as to the uses, outputs, analyses, results and performance of the Software is assumed by the user. This Disclaimer applies regardless of whether the Software is used alone or with other software."]
["The model, accompanying documentation, and methodologies contained herein do not represent an official position, statement, or endorsement on behalf of the Society of Actuaries or its members, nor should the material be construed to do so. It is the product of a research effort commissioned by the Society of Actuaries to add to the library of resource tools. The model is neither intended to preclude the use of other methodologies for any purpose nor provide a statement or position on the use, application, or preferability of other methodologies as compared to the methodology described herein."]

{"sheet":"Instructions","index":1,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,1,32,1],[0,0,0,1],[6,0,6,1],[8,0,8,1],[7,0,7,1]]}
["MACRA/QPP - Provider Revenue Model - Instructions"]
[]
["Published Date: 11/1/18"]
[]
["Overview & Caveats"]
[]
["The MACRA/QPP model is designed to provide an estimate of the revenue impact of the QPP (MIPS, AAPM) on a provider group or ACO, based on the required inputs and scenarios.  The User should note the specific assumptions as outlined in the References & Assumptions tab."]
["The model is based on MACRA regulations as published by CMS through November 1, 2018 (Final Rule Year 3).  Any subsequent publications by CMS after the \"published date\" as noted in this model must be considered for relevant impact to the QPP."]
["Please note the model is designed for estimation only, and is not a guarantee of actual financial results."]
[]
["Model Input"]
[]
["VARIABLE","ENTRY"]
["Provider Group or ACO Name","Enter the provider group or ACO name for the analysis."]
["ACO Type [Advanced APM or APM]","Choose APM or AAPM for current status of group (e.g. Upside risk only = APM, upside/downside = AAPM)."]
["Total Physician Revenue [CY2017]","Enter total physician revenue for Traditional Medicare and Other Payers in 000's for 2017."]
["Revenue and Members by LOB","Enter membership and % of revenue for each product line."]
["Annual Growth Rate %","Enter annual growth rate by product line."]
["Risk Sharing as % of Revenue","Enter risk sharing % for each alternative payment model.  Default is 0%."]
["MIPS Scenario","For each year, enter anticipated score for each measure.  The resulting MIPS CPS and payment adjustment factor will be displayed in the rightmost columns."]
["Quality","Assumes 6 measures, max score of 60.  Min score for each measure is 3 (i.e. default is 18)."]
["Practice Improvement","Max score of 40.  Default is 20."]
["Promoting Interoperability","Min score of 50, max score of 100.  Default is 50."]
["Resource Use","Max score of 10.  Default is 30."]
["AAPM Scenario (Shift)","This is the scenario to model a shift from MIPS to AAPM.  Enter the % of patients for the desired year to move into the AAPM in column G.  QP status will be displayed in the table in rows 28 to 36, based on patient count and/or revenue %.  Based on the table, the QP status in J19 to J25 will be populated."]
[]
[]
["Model Output"]
[]
["TAB","CONTENT"]
["Revenue at Risk Summary","This tab summarizes the results of the MACRA Baseline and MACRA Patient Shift assumptions.  Three tables are presented for each of the two scenarios: Revenue, change in margin, and revenues at risk."]
[]
[]
["Charts_Rev & Margin","Projected Revenue Graphs, FFS and Total, for both scenarios."]
[null,"Margin Erosion Graphs, FFS and Total, for both scenarios."]
["Charts_Performance","Displays Revenue at Risk (i.e. MACRA payments), for both scenarios, using User Input values."]

{"sheet":"References & Assumptions","index":2,"n_rows":39,"n_cols":2,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,1],[36,0,38,0]]}
["MACRA/QPP - Provider Revenue Model - References and Assumptions"]
[]
["VARIABLE","DESCRIPTION"]
["MACRA","Medicare and CHIP Reauthorization Act of 2015"]
["QPP","Quality Payment Program - Implements the MIPS and AAPM pathways"]
["MIPS","Merit-Based Incentive Payment System"]
["AAPM  ","Advanced Alternative Payment Model"]
["QP","Qualified Participant - Must reach defined threshold of Part B patient count or revenue to receive the 5% AAPM bonus payment."]
["Final Rule","https://www.federalregister.gov/documents/2016/11/04/2016-25240/medicare-program-merit-based-incentive-payment-system-mips-and-alternative-payment-model-apm"]
["Final Rule Year 2","https://www.federalregister.gov/documents/2017/11/16/2017-24067/medicare-program-cy-2018-updates-to-the-quality-payment-program-and-quality-payment-program-extreme"]
["Final Rule Year 3","https://www.federalregister.gov/documents/2018/11/23/2018-24170/medicare-program-revisions-to-payment-policies-under-the-physician-fee-schedule-and-other-revisions"]
["MACRA Physician Schedule Growth Rate","The Medicare Part B fee schedule will increase 0.5% each year for 2016 to 2019, after which it will be frozen until 2026, when the increases will be based on MIPS or AAPM status."]
["AAPM Bonus Payment","The bonus payment is 5% for 2019-2024, for Qualified Participants."]
["MIPS Payment – Min","This is the maximum negative payment adjustment."]
[null,"Adjustment is -4% for payment year 2019, -5% for 2020, -7% for 2021, and -9% for 2022."]
["MIPS Payment – Max","This is the maximum positive payment adjustment."]
[null,"Adjustment is 0.2% for payment year 2019, 0.6% for 2020, 1.5% for 2021, and 9% for 2022.  This can be scaled up to 3X for budget neutrality."]
[null,"2019 was originally 4%, 2020 5%, and 2021 7%, however these values were reduced due to \"transition year\" status and a CPS set lower than the median score. This is based"]
[null,"on the release of the 2017 aggregate results: "]
["`","https://www.cms.gov/Medicare/Quality-Payment-Program/Resource-Library/2017-QPP-Performance-Data-Infographic.pdf"]
["MIPS Scaling Factor","CMS calculates MIPS adjustment factor of 1x to 3x; dependent upon budget neutrality; Default is 1X."]
["Exceptional Performer (EP) Adjustment","This adjustment to the MIPS payment factor is for exceptional performers (top 25th percentile) and can be scaled from 0.5% up to a maximum of 10%. "]
["Exceptional Performer (EP) Threshold","The threshold was defined by CMS as a CPS of 70 for 2017 and 2018 per the \"transition year\" regulations.  For 2019, this was defined as CPS of 75 per the Final Year 3 rule."]
[null,"For 2020+, the threshold is set at the top 25th percentile based on the CPS threshold, and for this model, is assumed to be CPS of 80."]
["Exceptional Performer (EP) Scaling Factor","CMS calculates - dependent upon performance and availability of $500M funds; Default is 0.25. Based on the release of the 2017 aggregate results, "]
[null,"the scaling factor is set at 0.168 for performance years 2017 through 2019. "]
["CPS Performance Threshold","Per CMS, the threshold is 3 for 2017, 15 for 2018, and 30 for 2019 based on Final or Proposed Rules."]
[null,"For 2020+, per regulation, the CPS is set at the median score.  Within this model, the assumptions are:  60 for 2020+."]
["QP Status - (Y=1,PQP=2,N=0)","This is determined by % of revenue or patient counts under Medicare risk contracts."]
["Participate in MIPS (Y=1,N=0)","This is determined by QP status and the MIPS adjustment factor."]
["Medical CPI","This is the Consumer Price Index as established by the US Dept. of Labor, Bureau of Labor and Statistics. It measures the price change in medical care and is used to project the baseline costs.  For June 2018 this value is 2.1%."]
["MIPS Measure Weights","MIPS APM:  60% Quality, 15% Improvement Activities, 25% Promoting Interoperability (f/k/a Advancing Care)"]
[null,"MIPS (Standard) 2017:  60% Quality, 15% IA, 25% PI"]
[null,"MIPS (Standard) 2018:  50% Quality, 15% IA, 25% PI, 10% Resource Use"]
[null,"MIPS (Standard) 2019+:  45% Quality, 15% IA, 25% PI, 15% Resource Use"]
["Performance Year","The year in which the performance is measured for the eligible clinicians."]
["Payment Year","The payment year is a 2-year offset from the performance year, i.e. performance year 2017 is payment year 2019.  "]
[null,"MIPS adjustments will be applied to the Part B fee schedule in the payment year, based on the results from the performance year."]
[null,"AAPM 5% bonus will be paid by December of the payment year, based on QP status in the performance year, and calculated off the year prior to the payment year.  For example, if QP status in 2017, 5% bonus paid in 2019 is based on 2018 Part B revenue."]

{"sheet":"MODEL INPUT","index":3,"n_rows":40,"n_cols":23,"rows_kept":40,"cut":false,"hidden":false,"merged":[[29,1,35,1],[6,22,13,22],[18,11,24,11],[3,11,3,12],[0,0,0,8],[6,4,13,4],[18,4,24,4]]}
["MACRA/QPP - Provider Revenue Model - Inputs"]
[]
["Provider Group or ACO Name",null,null,null,null,"MIPS Scenario"]
["ACO Type [Advanced APM or APM]","FFS",null,null,null,"Measure","Quality","Practice Improvement","Promoting Inter-Operability","Resource Use (Cost)","CPS Score","Calculations",null,"Quality","Practice Improvement","Promoting Inoperability","Resource Use","Quality %","Practice %","Promoting Inoperability %","Resource Use %"]
[null,null,null,null,null,"Range","3 to 60","0 to 40","50 to 100","0 to 10","(0 - 100)","MIPS","EP"]
[null,null,null,null,null,"Default",18,20,50,3]
["Total Physician Revenue [CY2017]",1000,"Enter Dollars (000's)",null,"Performance Year",2017,18,20,50,null,{"$f":"MIN(MAX(SUM(N7:Q7),0),100)","v":38},{"$f":"CDO_MIPS_2019","v":7.2164948453608236E-4},{"$f":"CDO_MIPS_Bonus_2019","v":0},{"$f":"G7/60*R7*100","v":18},{"$f":"H7/40*S7*100","v":7.5},{"$f":"I7/100*T7*100","v":12.5},{"$f":"J7/10*U7*100","v":0},0.6,0.15,0.25,0,{"$f":"F7+2","v":2019},"Payment Year"]
[null,null,{"$f":"IF(AND(B4=\"Advanced APM\",OR(C11<>\"\",B11<>\"\")),\"AAPM type selected, ensure no APM Members/Revenue\",IF(AND(B4=\"APM\",OR(C10<>\"\",B10<>\"\")),\"APM type selected, ensure no AAPM Members/Revenue\",IF(AND(B4=\"FFS\",OR(C11<>\"\",B11<>\"\",B10<>\"\",C10<>\"\")),\"FFS type selected, ensure no AAPM or APM Members/Revenue\",\"\")))","v":""},null,null,{"$f":"F7+1","v":2018},18,20,50,3,38,{"$f":"CDO_MIPS_2020","v":1.6235294117647057E-3},{"$f":"CDO_MIPS_Bonus_2020","v":0},{"$f":"G8/60*R8*100","v":15},{"$f":"H8/40*S8*100","v":7.5},{"$f":"I8/100*T8*100","v":12.5},{"$f":"J8/10*U8*100","v":3},{"$f":"IF($B$4=\"FFS\",0.5,$R$7)","v":0.5},0.15,0.25,{"$f":"IF($B$4=\"FFS\",0.1,$U$7)","v":0.1},{"$f":"F8+2","v":2020}]
["Revenue and Members by LOB","# Members","% Revenue*","Revenue per Member",null,{"$f":"F8+1","v":2019},36,40,50,3,59,{"$f":"CDO_MIPS_2021","v":6.2142857142857121E-3},{"$f":"CDO_MIPS_Bonus_2021","v":0},27,15,12.5,4.5,0.45,0.15,0.25,0.15,2021]
["Medicare Advanced APM (AAPM)",null,null,{"$f":"IFERROR($B$7*C10/B10,0)*1000","v":0},null,2020,36,40,50,3,54.5,{"$f":"CDO_MIPS_2022","v":-8.2499999999999934E-3},{"$f":"CDO_MIPS_Bonus_2022","v":0},18,15,12.5,9,{"$f":"IF($B$4=\"FFS\",0.3,$R$7)","v":0.3},0.15,0.25,{"$f":"IF($B$4=\"FFS\",0.3,$U$7)","v":0.3},2022]
["Medicare APM",null,null,{"$f":"IFERROR($B$7*C11/B11,0)*1000","v":0},null,2021,36,40,50,3,54.5,{"$f":"CDO_MIPS_2023","v":-8.2499999999999934E-3},{"$f":"CDO_MIPS_Bonus_2023","v":0},18,15,12.5,9,0.3,0.15,0.25,0.3,2023]
["Medicare FFS",1000,1,{"$f":"IFERROR($B$7*C12/B12,0)*1000","v":1000},null,2022,36,40,50,3,54.5,{"$f":"CDO_MIPS_2024","v":-8.2499999999999934E-3},{"$f":"CDO_MIPS_Bonus_2024","v":0},18,15,12.5,9,0.3,0.15,0.25,0.3,2024]
["Other Payer AAPM",null,null,{"$f":"IFERROR($B$7*C13/B13,0)*1000","v":0},null,2023,36,40,50,3,54.5,{"$f":"CDO_MIPS_2025","v":-8.2499999999999934E-3},{"$f":"CDO_MIPS_Bonus_2025","v":0},18,15,12.5,9,0.3,0.15,0.25,0.3,2025]
["Other Payer non-AAPM",null,{"$f":"1-SUM(C10:C13)","v":0},{"$f":"IFERROR($B$7*C14/B14,0)*1000","v":0},null,{"$f":"F13+1","v":2024},36,40,50,3,54.5,{"$f":"CDO_MIPS_2026","v":-8.2499999999999934E-3},{"$f":"CDO_MIPS_Bonus_2026","v":0},18,15,12.5,9,0.3,0.15,0.25,0.3,2026]
[null,null,"*Total must add up to 100%"]
["Annual Growth Rate %",null,null,null,null,"AAPM Scenario (Shift)"]
["Medicare Advanced APM (AAPM)",null,null,null,null,"Enter % of Members in AAPM (0% to 100%), default is 50%"]
["Medicare APM",null,null,null,null,null,"AAPM","APM","FFS","QP?"]
["Medicare FFS",null,null,null,"Performance Year",{"$f":"F8","v":2018},0,{"$f":"B11/SUM(B11:B12)","v":0},{"$f":"B12/SUM(B11:B12)","v":1},"N/A",{"$f":"F19+2","v":2020},"Payment Year"]
["Other Payer AAPM",null,null,null,null,2019,0.5,{"$f":"IF(G20=0,H19,0)","v":0},{"$f":"1-SUM(G20:H20)","v":0.5},{"$f":"IF(Assumptions!G27=1,\"N\",\"Y\")","v":"Y"},{"$f":"F20+2","v":2021}]
["Other Payer non-AAPM",null,null,null,null,2020,0.5,{"$f":"IF(G21=0,H20,0)","v":0},{"$f":"1-SUM(G21:H21)","v":0.5},{"$f":"IF(Assumptions!H27=1,\"N\",\"Y\")","v":"Y"},2022]
[null,null,null,null,null,2021,0.5,0,0.5,{"$f":"IF(Assumptions!I27=1,\"N\",\"Y\")","v":"Y"},2023]
["Risk Sharing as % of Revenue",null,null,null,null,2022,0.5,0,0.5,{"$f":"IF(Assumptions!J27=1,\"N\",\"Y\")","v":"Y"},2024]
["Medicare Advanced APM (AAPM)",null,null,null,null,2023,0.5,0,0.5,{"$f":"IF(Assumptions!K27=1,\"N\",\"Y\")","v":"Y"},2025]
["Medicare APM",null,null,null,null,2024,0.5,0,0.5,{"$f":"IF(Assumptions!L27=1,\"N\",\"Y\")","v":"Y"},2026]
["Other Payer AAPM"]
[null,null,null,"QP Threshold Score and Thresholds (Shift Scenario)"]
[null,null,null,"Calculated using Revenue Amount",null,null,null,"Calculated using Patient Count"]
[null,null,null,"ACO Calculated Medicare %","ACO Calculated All Payer %","Medicare QP Threshold","All Payer QP Threshold ( > 25% Medicare)","ACO Calculated Medicare %","ACO Calculated All Payer %","Medicare QP Threshold","All Payer QP Threshold ( > 20% Medicare)"]
[null,"Performance Year",2018,"N/A","N/A",{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C32)","v":0.25},"N/A",null,null,{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C32)","v":0.2},"N/A"]
[null,null,{"$f":"+C30+1","v":2019},{"$f":"INDIRECT(\"CDO_MCR_REV_Shift_\"&C31)","v":0},{"$f":"INDIRECT(\"CDO_AP_REV_Shift_\"&C31)","v":0},{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C33)","v":0.5},{"$f":"INDIRECT(\"QP_AP_REV_Threshold_\"&C33)","v":0.5},{"$f":"INDIRECT(\"CDO_MCR_PT_Shift_\"&C31)","v":0},{"$f":"INDIRECT(\"CDO_AP_PT_Shift_\"&C31)","v":0},{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C33)","v":0.35},{"$f":"INDIRECT(\"QP_AP_PT_Threshold_\"&C33)","v":0.35}]
[null,null,{"$f":"+C31+1","v":2020},0,0,{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C34)","v":0.5},{"$f":"INDIRECT(\"QP_AP_REV_Threshold_\"&C34)","v":0.5},{"$f":"INDIRECT(\"CDO_MCR_PT_Shift_\"&C32)","v":0},0,{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C34)","v":0.35},{"$f":"INDIRECT(\"QP_AP_PT_Threshold_\"&C34)","v":0.35}]
[null,null,2021,0.5,{"$f":"INDIRECT(\"CDO_AP_REV_Shift_\"&C33)","v":0.5},{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C35)","v":0.75},{"$f":"INDIRECT(\"QP_AP_REV_Threshold_\"&C35)","v":0.75},0.5,0.5,{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C35)","v":0.5},{"$f":"INDIRECT(\"QP_AP_PT_Threshold_\"&C35)","v":0.5}]
[null,null,2022,0.5,{"$f":"INDIRECT(\"CDO_AP_REV_Shift_\"&C34)","v":0.5},{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C36)","v":0.75},{"$f":"INDIRECT(\"QP_AP_REV_Threshold_\"&C36)","v":0.75},0.5,0.5,{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C36)","v":0.5},{"$f":"INDIRECT(\"QP_AP_PT_Threshold_\"&C36)","v":0.5}]
[null,null,2023,0.5,0.5,{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C39)","v":0.75},{"$f":"INDIRECT(\"QP_AP_REV_Threshold_\"&C39)","v":0.75},0.5,0.5,{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C39)","v":0.5},{"$f":"INDIRECT(\"QP_AP_PT_Threshold_\"&C39)","v":0.5}]
[null,null,2024,{"$f":"INDIRECT(\"CDO_MCR_REV_Shift_\"&C36)","v":0.5},0.5,{"$f":"INDIRECT(\"QP_MCR_REV_Threshold_\"&C40)","v":0.75},{"$f":"INDIRECT(\"QP_AP_REV_Threshold_\"&C40)","v":0.75},0.5,0.5,{"$f":"INDIRECT(\"QP_MCR_PT_Threshold_\"&C40)","v":0.5},{"$f":"INDIRECT(\"QP_AP_PT_Threshold_\"&C40)","v":0.5}]
[]
[]
[null,null,2025]
[null,null,2026]

{"sheet":"Input by Entity","index":4,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":true,"merged":[]}
["OptumInsight MACRA Revenue Model",null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"APM"]
["Provider Group or ACO Name",null,null,{"$f":"'MODEL INPUT'!B3","v":0},null,null,null,null,null,null,null,null,null,null,"Advanced APM"]
["ACO Type [Advanced APM or APM]",null,null,{"$f":"'MODEL INPUT'!B4","v":"FFS"},null,null,null,null,null,null,null,null,null,null,{"$f":"ACO_Selection","v":"FFS"}]
[]
["Total Revenue [CY2017]",null,null,{"$f":"'MODEL INPUT'!B7","v":1000},"( 000's)"]
["Revenue Distr. by LOB"]
[null,"Medicare Advanced APM",null,{"$f":"'MODEL INPUT'!C10","v":0},{"$f":"D8*$D$6","v":0}]
[null,"Medicare APM",null,{"$f":"'MODEL INPUT'!C11","v":0},{"$f":"D9*$D$6","v":0}]
[null,"Medicare FFS",null,{"$f":"'MODEL INPUT'!C12","v":1},{"$f":"D10*$D$6","v":1000}]
[null,"Other Payer AAPM",null,{"$f":"'MODEL INPUT'!C13","v":0},{"$f":"D11*$D$6","v":0}]
[null,"Other Payer non-AAPM",null,{"$f":"'MODEL INPUT'!C14","v":0},{"$f":"D12*$D$6","v":0}]
[]
["PERFORMANCE YEAR",null,null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
["Attributed Patient #"]
[null,"Traditional Medicare",null,{"$f":"SUM(D17:D19)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,null,"Medicare Advanced APM",{"$f":"'MODEL INPUT'!B10","v":0},{"$f":"D17*(1+E33)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Medicare APM",{"$f":"'MODEL INPUT'!B11","v":0},{"$f":"D18*(1+E34)","v":0},0,0,0,0,0,0,0,0]
[null,null,"Medicare FFS",{"$f":"'MODEL INPUT'!B12","v":1000},{"$f":"D19*(1+E35)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Other Payer AAPM",null,{"$f":"'MODEL INPUT'!B13","v":0},{"$f":"D20*(1+E36)","v":0},0,0,0,0,0,0,0,0]
[null,"Other Payer non-AAPM",null,{"$f":"'MODEL INPUT'!B14","v":0},{"$f":"D21*(1+E37)","v":0},0,0,0,0,0,0,0,0]
[null,null,null,{"$f":"SUM(D17:D21)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000]
[]
["Attributed Patients - Timing of Shift from APM to AAPM Scenario"]
[null,null,null,null,{"$f":"IF(AND(E26=0,E27=0),0,IF(E26<>0,1,IF(E27<>0,2)))","v":0},1,1,1,1,1,1,1,1]
[null,"Medicare Advanced APM",null,null,{"$f":"'MODEL INPUT'!G19","v":0},{"$f":"'MODEL INPUT'!G20","v":0.5},{"$f":"'MODEL INPUT'!G21","v":0.5},{"$f":"'MODEL INPUT'!G22","v":0.5},{"$f":"'MODEL INPUT'!G23","v":0.5},{"$f":"'MODEL INPUT'!G24","v":0.5},{"$f":"'MODEL INPUT'!G25","v":0.5},0.5,0.5]
[null,"Medicare APM",null,null,{"$f":"'MODEL INPUT'!H19","v":0},{"$f":"'MODEL INPUT'!H20","v":0},{"$f":"'MODEL INPUT'!H21","v":0},{"$f":"'MODEL INPUT'!H22","v":0},{"$f":"'MODEL INPUT'!H23","v":0},{"$f":"'MODEL INPUT'!H24","v":0},{"$f":"'MODEL INPUT'!H25","v":0}]
[null,"Medicare FFS",null,null,{"$f":"1-SUM(E26:E27)","v":1},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[]
[]
["Patient # Growth Rate"]
[null,"Traditional Medicare"]
[null,null,"Medicare Advanced APM",null,{"$f":"'MODEL INPUT'!B17","v":0},{"$f":"AAPM_Pt_rate_2018","v":0},0,0,0,0,0,0,0]
[null,null,"Medicare APM",null,{"$f":"'MODEL INPUT'!B18","v":0},0,0,0,0,0,0,0,0]
[null,null,"Medicare FFS",null,{"$f":"'MODEL INPUT'!B19","v":0},0,0,0,0,0,0,0,0]
[null,"Other Payer AAPM",null,null,{"$f":"'MODEL INPUT'!B20","v":0},0,0,0,0,0,0,0,0]
[null,"Other Payer non-AAPM",null,null,{"$f":"'MODEL INPUT'!B21","v":0},0,0,0,0,0,0,0,0]
[]
["Risk Sharing as % of Revenue"]
[null,"Medicare Advanced APM",null,{"$f":"'MODEL INPUT'!B24","v":0},{"$f":"AAPM_Rsk_Shr_2017","v":0},0,0,0,0,0,0,0,0,null,"<don't grey out, used for both workstreams>"]
[null,"Medicare APM",null,{"$f":"'MODEL INPUT'!B25","v":0},{"$f":"APM_Rsk_Shr_2017","v":0},0,0,0,0,0,0,0,0]
[null,"Other Payer AAPM",null,{"$f":"'MODEL INPUT'!B26","v":0},{"$f":"Comm_Rsk_Shr_2017","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[]
["Composite Performance Score (CPS)",null,null,{"$f":"'MODEL INPUT'!K7","v":38},{"$f":"'MODEL INPUT'!K8","v":38},{"$f":"'MODEL INPUT'!K9","v":59},{"$f":"'MODEL INPUT'!K10","v":54.5},{"$f":"'MODEL INPUT'!K11","v":54.5},{"$f":"'MODEL INPUT'!K12","v":54.5},{"$f":"'MODEL INPUT'!K13","v":54.5},{"$f":"'MODEL INPUT'!K14","v":54.5},{"$f":"'MODEL INPUT'!K15","v":0},{"$f":"'MODEL INPUT'!K18","v":0}," <this number can't be over 100>"]
["Ratio to Median",null,null,{"$f":"D47/Assumptions!E30","v":12.666666666666666},{"$f":"E47/Assumptions!F30","v":2.5333333333333332},{"$f":"F47/Assumptions!G30","v":1.9666666666666666},{"$f":"G47/Assumptions!H30","v":0.90833333333333333},{"$f":"H47/Assumptions!I30","v":0.90833333333333333},{"$f":"I47/Assumptions!J30","v":0.90833333333333333},{"$f":"J47/Assumptions!K30","v":0.90833333333333333},{"$f":"K47/Assumptions!L30","v":0.90833333333333333},{"$f":"L47/Assumptions!M30","v":0},{"$f":"M47/Assumptions!N30","v":0}]
[]
["MIPS Adjustment Factor Output",null,null,null,null,{"$f":"IF(Lookups!C29<0,Lookups!C29,Lookups!C29*Assumptions!E35)","v":7.2164948453608236E-4},{"$f":"IF(Lookups!H29<0,Lookups!H29,Lookups!H29*Assumptions!F35)","v":1.6235294117647057E-3},{"$f":"IF(Lookups!L29<0,Lookups!L29,Lookups!L29*Assumptions!G35)","v":6.2142857142857121E-3},{"$f":"IF(Lookups!P29<0,Lookups!P29,Lookups!P29*Assumptions!H35)","v":-8.2499999999999934E-3},{"$f":"IF(Lookups!T29<0,Lookups!T29,Lookups!T29*Assumptions!I35)","v":-8.2499999999999934E-3},{"$f":"IF(Lookups!X29<0,Lookups!X29,Lookups!X29*Assumptions!J35)","v":-8.2499999999999934E-3},{"$f":"IF(Lookups!AB29<0,Lookups!AB29,Lookups!AB29*Assumptions!K35)","v":-8.2499999999999934E-3},{"$f":"IF(Lookups!AF29<0,Lookups!AF29,Lookups!AF29*Assumptions!L35)","v":-8.2499999999999934E-3}]
["(corridor +/-% includes up to 3x)"]
[]
["Exceptional Performance Adjustment Factor",null,null,null,null,{"$f":"Lookups!C38*Assumptions!E41","v":0},{"$f":"Lookups!H38*Assumptions!F41","v":0},{"$f":"Lookups!L38*Assumptions!G41","v":0},{"$f":"Lookups!P38*Assumptions!H41","v":0},{"$f":"Lookups!T38*Assumptions!I41","v":0},{"$f":"Lookups!X38*Assumptions!J41","v":0},{"$f":"Lookups!AB38*Assumptions!K41","v":0},{"$f":"Lookups!AF38*Assumptions!L41","v":0}]
["(0.5% to 10% linearly interpolated)"]

{"sheet":"Lookups","index":5,"n_rows":38,"n_cols":35,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"QP patient count threshold",null,null,null,null,null,null,null,null,null,null,null,null,"QP Revenue threshold"]
[null,null,null,null,null,2019,2020,2021,2022,2023,2024,2025,2026,"2026+",null,null,null,null,{"$f":"F3","v":2019},{"$f":"G3","v":2020},2021,2022,2023,2024,2025,2026,"2026+"]
[null,null,"Medicare Option",null,null,null,null,null,null,null,null,null,null,null,null,"Medicare Option"]
[null,null,null,null,"Full",0.2,0.2,0.35,0.35,0.5,0.5,0.5,0.5,0.5,null,null,null,"Full",0.25,0.25,0.5,0.5,0.75,0.75,0.75,0.75,0.75]
[null,null,null,null,"Partial",0.1,0.1,0.25,0.25,0.35,0.35,0.35,0.35,0.35,null,null,null,"Partial",0.2,0.2,0.4,0.4,0.5,0.5,0.5,0.5,0.5]
[]
[null,null,"All Payer Option",null,null,null,null,null,null,null,null,null,null,null,null,"All Payer Option"]
[null,null,"must also meet 20% and 10%",null,"Full",null,null,0.35,0.35,0.5,0.5,0.5,0.5,0.5,null,"must also meet 25% and 20%",null,"Full",null,null,0.5,0.5,0.75,0.75,0.75,0.75,0.75]
[null,null,"for Medicare for QP and PQP",null,"Partial",null,null,0.25,0.25,0.35,0.35,0.35,0.35,0.35,null,"for Medicare for QP and PQP",null,"Partial",null,null,0.4,0.4,0.5,0.5,0.5,0.5,0.5]
[null,null," respectively",null,null,null,null,null,null,null,null,null,null,null,null,"respectively"]
[]
[null,null,null,"Baseline",null,null,null,null,null,null,null,null,null,null,null,null,"Baseline"]
[null,null,null,null,"Medicare ",{"$f":"IFERROR(Data!D34/Data!D5,0)","v":0},{"$f":"IFERROR(Data!E34/Data!E5,0)","v":0},{"$f":"IFERROR(Data!F34/Data!F5,0)","v":0},{"$f":"IFERROR(Data!G34/Data!G5,0)","v":0},{"$f":"IFERROR(Data!H34/Data!H5,0)","v":0},{"$f":"IFERROR(Data!I34/Data!I5,0)","v":0},{"$f":"IFERROR(Data!J34/Data!J5,0)","v":0},{"$f":"IFERROR(Data!K34/Data!K5,0)","v":0},{"$f":"IFERROR(Data!L34/Data!L5,0)","v":0},null,null,null,"Medicare ",{"$f":"IFERROR(Data!D44/Data!D15,0)","v":0},{"$f":"IFERROR(Data!E44/Data!E15,0)","v":0},{"$f":"IFERROR(Data!F44/Data!F15,0)","v":0},{"$f":"IFERROR(Data!G44/Data!G15,0)","v":0},{"$f":"IFERROR(Data!H44/Data!H15,0)","v":0},{"$f":"IFERROR(Data!I44/Data!I15,0)","v":0},{"$f":"IFERROR(Data!J44/Data!J15,0)","v":0},{"$f":"IFERROR(Data!K44/Data!K15,0)","v":0},{"$f":"IFERROR(Data!L44/Data!L15,0)","v":0}]
[null,null,null,null,"All Payer",{"$f":"IFERROR(SUM(Data!D34,Data!D121)/SUM(Data!D5,Data!D121,Data!D150),0)","v":0},{"$f":"IFERROR(SUM(Data!E34,Data!E121)/SUM(Data!E5,Data!E121,Data!E150),0)","v":0},{"$f":"IFERROR(SUM(Data!F34,Data!F121)/SUM(Data!F5,Data!F121,Data!F150),0)","v":0},{"$f":"IFERROR(SUM(Data!G34,Data!G121)/SUM(Data!G5,Data!G121,Data!G150),0)","v":0},{"$f":"IFERROR(SUM(Data!H34,Data!H121)/SUM(Data!H5,Data!H121,Data!H150),0)","v":0},{"$f":"IFERROR(SUM(Data!I34,Data!I121)/SUM(Data!I5,Data!I121,Data!I150),0)","v":0},{"$f":"IFERROR(SUM(Data!J34,Data!J121)/SUM(Data!J5,Data!J121,Data!J150),0)","v":0},{"$f":"IFERROR(SUM(Data!K34,Data!K121)/SUM(Data!K5,Data!K121,Data!K150),0)","v":0},{"$f":"IFERROR(SUM(Data!L34,Data!L121)/SUM(Data!L5,Data!L121,Data!L150),0)","v":0},null,null,null,"All Payer",{"$f":"IFERROR(SUM(Data!D44,Data!D123)/SUM(Data!D15,Data!D123,Data!D152),0)","v":0},{"$f":"IFERROR(SUM(Data!E44,Data!E123)/SUM(Data!E15,Data!E123,Data!E152),0)","v":0},{"$f":"IFERROR(SUM(Data!F44,Data!F123)/SUM(Data!F15,Data!F123,Data!F152),0)","v":0},{"$f":"IFERROR(SUM(Data!G44,Data!G123)/SUM(Data!G15,Data!G123,Data!G152),0)","v":0},{"$f":"IFERROR(SUM(Data!H44,Data!H123)/SUM(Data!H15,Data!H123,Data!H152),0)","v":0},{"$f":"IFERROR(SUM(Data!I44,Data!I123)/SUM(Data!I15,Data!I123,Data!I152),0)","v":0},{"$f":"IFERROR(SUM(Data!J44,Data!J123)/SUM(Data!J15,Data!J123,Data!J152),0)","v":0},{"$f":"IFERROR(SUM(Data!K44,Data!K123)/SUM(Data!K15,Data!K123,Data!K152),0)","v":0},{"$f":"IFERROR(SUM(Data!L44,Data!L123)/SUM(Data!L15,Data!L123,Data!L152),0)","v":0}]
[null,null,null,"Shifting",null,null,null,null,null,null,null,null,null,null,null,null,"Shifting"]
[null,null,null,null,"Medicare ",{"$f":"IFERROR(Data!D35/Data!D6,0)","v":0},{"$f":"IFERROR(Data!E35/Data!E6,0)","v":0},{"$f":"IFERROR(Data!F35/Data!F6,0)","v":0.5},{"$f":"IFERROR(Data!G35/Data!G6,0)","v":0.5},{"$f":"IFERROR(Data!H35/Data!H6,0)","v":0.5},{"$f":"IFERROR(Data!I35/Data!I6,0)","v":0.5},{"$f":"IFERROR(Data!J35/Data!J6,0)","v":0.5},{"$f":"IFERROR(Data!K35/Data!K6,0)","v":0.5},{"$f":"IFERROR(Data!L35/Data!L6,0)","v":0.5},null,null,null,"Medicare ",{"$f":"IFERROR(Data!D51/Data!D22,0)","v":0},{"$f":"IFERROR(Data!E51/Data!E22,0)","v":0},{"$f":"IFERROR(Data!F51/Data!F22,0)","v":0.5},{"$f":"IFERROR(Data!G51/Data!G22,0)","v":0.5},{"$f":"IFERROR(Data!H51/Data!H22,0)","v":0.5},{"$f":"IFERROR(Data!I51/Data!I22,0)","v":0.5},{"$f":"IFERROR(Data!J51/Data!J22,0)","v":0.5},{"$f":"IFERROR(Data!K51/Data!K22,0)","v":0.5},{"$f":"IFERROR(Data!L51/Data!L22,0)","v":0.5}]
[null,null,null,null,"All Payer",{"$f":"IFERROR(SUM(Data!D35,Data!D122)/SUM(Data!D6,Data!D122,Data!D151),0)","v":0},{"$f":"IFERROR(SUM(Data!E35,Data!E122)/SUM(Data!E6,Data!E122,Data!E151),0)","v":0},{"$f":"IFERROR(SUM(Data!F35,Data!F122)/SUM(Data!F6,Data!F122,Data!F151),0)","v":0.5},{"$f":"IFERROR(SUM(Data!G35,Data!G122)/SUM(Data!G6,Data!G122,Data!G151),0)","v":0.5},{"$f":"IFERROR(SUM(Data!H35,Data!H122)/SUM(Data!H6,Data!H122,Data!H151),0)","v":0.5},{"$f":"IFERROR(SUM(Data!I35,Data!I122)/SUM(Data!I6,Data!I122,Data!I151),0)","v":0.5},{"$f":"IFERROR(SUM(Data!J35,Data!J122)/SUM(Data!J6,Data!J122,Data!J151),0)","v":0.5},{"$f":"IFERROR(SUM(Data!K35,Data!K122)/SUM(Data!K6,Data!K122,Data!K151),0)","v":0.5},{"$f":"IFERROR(SUM(Data!L35,Data!L122)/SUM(Data!L6,Data!L122,Data!L151),0)","v":0.5},null,null,null,"All Payer",{"$f":"IFERROR(SUM(Data!D51,Data!D125)/SUM(Data!D22,Data!D154,Data!D125),0)","v":0},{"$f":"IFERROR(SUM(Data!E51,Data!E125)/SUM(Data!E22,Data!E154,Data!E125),0)","v":0},{"$f":"IFERROR(SUM(Data!F51,Data!F125)/SUM(Data!F22,Data!F154,Data!F125),0)","v":0.5},{"$f":"IFERROR(SUM(Data!G51,Data!G125)/SUM(Data!G22,Data!G154,Data!G125),0)","v":0.5},{"$f":"IFERROR(SUM(Data!H51,Data!H125)/SUM(Data!H22,Data!H154,Data!H125),0)","v":0.5},{"$f":"IFERROR(SUM(Data!I51,Data!I125)/SUM(Data!I22,Data!I154,Data!I125),0)","v":0.5},{"$f":"IFERROR(SUM(Data!J51,Data!J125)/SUM(Data!J22,Data!J154,Data!J125),0)","v":0.5},{"$f":"IFERROR(SUM(Data!K51,Data!K125)/SUM(Data!K22,Data!K154,Data!K125),0)","v":0.5},{"$f":"IFERROR(SUM(Data!L51,Data!L125)/SUM(Data!L22,Data!L154,Data!L125),0)","v":0.5}]
[]
[]
[]
[null,null,"MIPS Adjustment -2019",null,null,null,null,"MIPS Adjustment -2020",null,null,null,"MIPS Adjustment -2021",null,null,null,"MIPS Adjustment -2022",null,null,null,"MIPS Adjustment -2023",null,null,null,"MIPS Adjustment -2024",null,null,null,"MIPS Adjustment -2025",null,null,null,"MIPS Adjustment -2026"]
[null,null,"Min","Max","slope","Intercept",null,"Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept"]
[null,null,0,0.25,0,{"$f":"MIPS_MIN_2019","v":-0.04},null,0,0.25,0,{"$f":"MIPS_MIN_2020","v":-0.05},0,0.25,0,{"$f":"MIPS_MIN_2021","v":-7.0000000000000007E-2},0,0.25,0,{"$f":"MIPS_MIN_2022","v":-0.09},0,0.25,0,{"$f":"MIPS_MIN_2023","v":-0.09},0,0.25,0,{"$f":"MIPS_MIN_2024","v":-0.09},0,0.25,0,{"$f":"MIPS_MIN_2025","v":-0.09},0,0.25,0,{"$f":"MIPS_MIN_2026","v":-0.09}]
[null,null,0.25009999999999999,1,{"$f":"MIPS_MAX_2019","v":2E-3},{"$f":"F24","v":-0.04},null,0.25009999999999999,1,{"$f":"MIPS_MAX_2020","v":6.0000000000000001E-3},{"$f":"K24","v":-0.05},0.25009999999999999,1,{"$f":"MIPS_MAX_2021","v":1.4999999999999999E-2},{"$f":"O24","v":-7.0000000000000007E-2},0.25009999999999999,1,{"$f":"MIPS_MAX_2022","v":0.09},{"$f":"S24","v":-0.09},0.25009999999999999,1,{"$f":"MIPS_MAX_2023","v":0.09},{"$f":"W24","v":-0.09},0.25009999999999999,1,{"$f":"MIPS_MAX_2024","v":0.09},{"$f":"AA24","v":-0.09},0.25009999999999999,1,{"$f":"MIPS_MAX_2025","v":0.09},{"$f":"AE24","v":-0.09},0.25009999999999999,1,{"$f":"MIPS_MAX_2026","v":0.09},{"$f":"AI24","v":-0.09}]
[null,null,1.0001,{"$f":"100/Assumptions!E30","v":33.333333333333336},{"$f":"E25/(D26-1)","v":6.1855670103092776E-5},{"$f":"-E26","v":-6.1855670103092776E-5},null,1.0001,{"$f":"100/Assumptions!F30","v":6.666666666666667},{"$f":"J25/(I26-1)","v":1.0588235294117646E-3},{"$f":"-J26","v":-1.0588235294117646E-3},1.0001,{"$f":"100/Assumptions!G30","v":3.3333333333333335},{"$f":"N25/(M26-1)","v":6.4285714285714276E-3},{"$f":"-N26","v":-6.4285714285714276E-3},1.0001,{"$f":"100/Assumptions!H30","v":1.6666666666666667},{"$f":"R25/(Q26-1)","v":0.13499999999999998},{"$f":"-R26","v":-0.13499999999999998},1.0001,{"$f":"100/Assumptions!I30","v":1.6666666666666667},{"$f":"V25/(U26-1)","v":0.13499999999999998},{"$f":"-V26","v":-0.13499999999999998},1.0001,{"$f":"100/Assumptions!J30","v":1.6666666666666667},{"$f":"Z25/(Y26-1)","v":0.13499999999999998},{"$f":"-Z26","v":-0.13499999999999998},1.0001,{"$f":"100/Assumptions!K30","v":1.6666666666666667},{"$f":"AD25/(AC26-1)","v":0.13499999999999998},{"$f":"-AD26","v":-0.13499999999999998},1.0001,{"$f":"100/Assumptions!L30","v":1.6666666666666667},{"$f":"AH25/(AG26-1)","v":0.13499999999999998},{"$f":"-AH26","v":-0.13499999999999998}]
[]
[]
[null,null,{"$f":"VLOOKUP('Input by Entity'!D48,$C$24:$F$26,3)*'Input by Entity'!D48+VLOOKUP('Input by Entity'!D48,$C$24:$F$26,4)","v":7.2164948453608236E-4},null,null,null,null,{"$f":"VLOOKUP('Input by Entity'!E48,$H$24:$K$26,3)*'Input by Entity'!E48+VLOOKUP('Input by Entity'!E48,$H$24:$K$26,4)","v":1.6235294117647057E-3},null,null,null,{"$f":"VLOOKUP('Input by Entity'!F48,$L$24:$O$26,3)*'Input by Entity'!F48+VLOOKUP('Input by Entity'!F48,$L$24:$O$26,4)","v":6.2142857142857121E-3},null,null,null,{"$f":"VLOOKUP('Input by Entity'!G48,$P$24:$S$26,3)*'Input by Entity'!G48+VLOOKUP('Input by Entity'!G48,$P$24:$S$26,4)","v":-8.2499999999999934E-3},null,null,null,{"$f":"VLOOKUP('Input by Entity'!H48,$T$24:$W$26,3)*'Input by Entity'!H48+VLOOKUP('Input by Entity'!H48,$T$24:$W$26,4)","v":-8.2499999999999934E-3},null,null,null,{"$f":"VLOOKUP('Input by Entity'!I48,$X$24:$AA$26,3)*'Input by Entity'!I48+VLOOKUP('Input by Entity'!I48,$X$24:$AA$26,4)","v":-8.2499999999999934E-3},null,null,null,{"$f":"VLOOKUP('Input by Entity'!J48,$AB$24:$AE$26,3)*'Input by Entity'!J48+VLOOKUP('Input by Entity'!J48,$AB$24:$AE$26,4)","v":-8.2499999999999934E-3},null,null,null,{"$f":"VLOOKUP('Input by Entity'!K48,$AB$24:$AE$26,3)*'Input by Entity'!K48+VLOOKUP('Input by Entity'!K48,$AB$24:$AE$26,4)","v":-8.2499999999999934E-3}]
[]
[]
[null,null,"Addtl MIPS -2019",null,null,null,null,"Addtl MIPS-2020",null,null,null,"Addtl MIPS-2021",null,null,null,"Addtl MIPS-2022",null,null,null,"Addtl MIPS-2023",null,null,null,"Addtl MIPS-2024",null,null,null,"Addtl MIPS-2025",null,null,null,"Addtl MIPS-2026"]
[null,null,"Min","Max","slope","Intercept",null,"Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept","Min","Max","slope","Intercept"]
[null,null,0,0.999,0,0,null,0,0.999,0,0,0,0.999,0,0,0,0.999,0,0,0,0.999,0,0,0,0.999,0,0,0,0.999,0,0,0,0.999,0,0]
[null,null,1,{"$f":"IFERROR(100/Assumptions!E38,1)","v":1.4285714285714286},{"$f":"IFERROR((0.1-0.5/100)/(D35-1),0)","v":0.22166666666666665},{"$f":"0.5/100-E35","v":-0.21666666666666665},null,1,{"$f":"IFERROR(100/Assumptions!F38,1)","v":1.4285714285714286},{"$f":"IFERROR((0.1-0.5/100)/(I35-1),0)","v":0.22166666666666665},{"$f":"0.5/100-J35","v":-0.21666666666666665},1,{"$f":"IFERROR(100/Assumptions!G38,1)","v":1.3333333333333333},{"$f":"IFERROR((0.1-0.5/100)/(M35-1),0)","v":0.28500000000000009},{"$f":"0.5/100-N35","v":-0.28000000000000008},1,{"$f":"IFERROR(100/Assumptions!H38,1)","v":1.3333333333333333},{"$f":"IFERROR((0.1-0.5/100)/(Q35-1),0)","v":0.28500000000000009},{"$f":"0.5/100-R35","v":-0.28000000000000008},1,{"$f":"IFERROR(100/Assumptions!I38,1)","v":1.25},{"$f":"IFERROR((0.1-0.5/100)/(U35-1),0)","v":0.38},{"$f":"0.5/100-V35","v":-0.375},1,{"$f":"IFERROR(100/Assumptions!J38,1)","v":1.25},{"$f":"IFERROR((0.1-0.5/100)/(Y35-1),0)","v":0.38},{"$f":"0.5/100-Z35","v":-0.375},1,{"$f":"IFERROR(100/Assumptions!K38,1)","v":1.25},{"$f":"IFERROR((0.1-0.5/100)/(AC35-1),0)","v":0.38},{"$f":"0.5/100-AD35","v":-0.375},1,{"$f":"IFERROR(100/Assumptions!L38,1)","v":1.25},{"$f":"IFERROR((0.1-0.5/100)/(AG35-1),0)","v":0.38},{"$f":"0.5/100-AH35","v":-0.375}]
[]
[]
[null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!D48*Assumptions!$E$30/Assumptions!$E$38,$C$34:$F$35,3)*'Input by Entity'!D48*Assumptions!$E$30/Assumptions!$E$38+VLOOKUP('Input by Entity'!D48*Assumptions!$E$30/Assumptions!$E$38,$C$34:$F$35,4),0)","v":0},null,null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!E48*Assumptions!$F$30/Assumptions!$F$38,$H$34:$K$35,3)*'Input by Entity'!E48*Assumptions!$F$30/Assumptions!$F$38+VLOOKUP('Input by Entity'!E48*Assumptions!$F$30/Assumptions!$F$38,$H$34:$K$35,4),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!F48*Assumptions!$G$30/Assumptions!$G$38,$L$34:$O$35,3)*'Input by Entity'!F48*Assumptions!$G$30/Assumptions!$G$38+VLOOKUP('Input by Entity'!F48*Assumptions!$G$30/Assumptions!$G$38,$L$34:$O$35,4),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!G48*Assumptions!$H$30/Assumptions!$H$38,$P$34:$S$35,3)*'Input by Entity'!G48*Assumptions!$H$30/Assumptions!$H$38+VLOOKUP('Input by Entity'!G48*Assumptions!$H$30/Assumptions!$H$38,$P$34:$S$35,4),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!H48*Assumptions!$I$30/Assumptions!$I$38,$T$34:$W$35,3)*'Input by Entity'!H48*Assumptions!$I$30/Assumptions!$I$38+VLOOKUP('Input by Entity'!H48*Assumptions!$I$30/Assumptions!$I$38,$T$34:$W$35,4),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!I48*Assumptions!$J$30/Assumptions!$J$38,$X$34:$AA$35,3)*'Input by Entity'!I48*Assumptions!$J$30/Assumptions!$J$38+VLOOKUP('Input by Entity'!I48*Assumptions!$J$30/Assumptions!$J$38,$X$34:$AA$35,4),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!J48*Assumptions!$K$30/Assumptions!$K$38,$AB$34:$AE$35,3)*'Input by Entity'!J48*Assumptions!$K$30/Assumptions!$K$38+VLOOKUP('Input by Entity'!J48*Assumptions!$K$30/Assumptions!$K$38,$AB$34:$AE$35,4),0)","v":0},null,null,null,{"$f":"IFERROR(VLOOKUP('Input by Entity'!K48*Assumptions!$L$30/Assumptions!$L$38,$AF$34:$AI$35,3)*'Input by Entity'!K48*Assumptions!$L$30/Assumptions!$L$38+VLOOKUP('Input by Entity'!K48*Assumptions!$L$30/Assumptions!$L$38,$AF$34:$AI$35,4),0)","v":0}]

{"sheet":"Assumptions","index":6,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["OptumInsight MACRA Model"]
[]
[null,null,"Payment Yr",null,{"$f":"E4+2","v":2019},{"$f":"F4+2","v":2020},2021,2022,2023,2024,2025,2026,2027,2028]
[null,null,"Performance Yr",null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026]
["FFS (MIPS Exempt)"]
["Physician Schedule Growth Rate",null,null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,0]
[]
["AAPM"]
["Physician Schedule Growth Rate",null,null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,7.4999999999999997E-3]
["AAPM Bonus Payment",null,null,null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0,0]
[]
["MIPS"]
["Physician Schedule Growth Rate",null,null,null,5.0000000000000001E-3,5.0000000000000001E-3,5.0000000000000001E-3,0,0,0,0,0,0,2.5000000000000001E-3]
["Min Payment",null,null,null,null,null,-0.04,-0.05,-7.0000000000000007E-2,-0.09,-0.09,-0.09,-0.09,-0.09]
["Max Payment",null,null,null,null,null,2E-3,6.0000000000000001E-3,1.4999999999999999E-2,0.09,0.09,0.09,0.09,0.09]
["Additional Performance Adjustment",null,null,null,null,null,0,0,0,0,0,0,0,0,"<between 0.5% and 10%>"]
[]
[]
[]
["QP Status (Y=1,PQP=2,N=0) - Baseline Patient",null,null,null,{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&E3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&E3),1,IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&E3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&E3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&F3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&F3),1,IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&F3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&F3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&G3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&G3),1,IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&G3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&G3),IF(INDIRECT(\"CDO_AP_PT_Baseline_\"&G3)>=INDIRECT(\"QP_AP_PT_Threshold_\"&G3),1,IF(OR(INDIRECT(\"CDO_AP_PT_Baseline_\"&G3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&G3),INDIRECT(\"CDO_MCR_PT_Baseline_\"&G3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&G3)),2,0)),IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&G3)>INDIRECT(\"PQP_MCR_PT_Threshold_\"&G3),IF(OR(INDIRECT(\"CDO_AP_PT_Baseline_\"&G3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&G3),INDIRECT(\"CDO_MCR_PT_Baseline_\"&G3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&G3)),2,0),0)))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&H3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&H3),1,IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&H3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&H3),IF(INDIRECT(\"CDO_AP_PT_Baseline_\"&H3)>=INDIRECT(\"QP_AP_PT_Threshold_\"&H3),1,IF(OR(INDIRECT(\"CDO_AP_PT_Baseline_\"&H3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&H3),INDIRECT(\"CDO_MCR_PT_Baseline_\"&H3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&H3)),2,0)),IF(INDIRECT(\"CDO_MCR_PT_Baseline_\"&H3)>INDIRECT(\"PQP_MCR_PT_Threshold_\"&H3),IF(OR(INDIRECT(\"CDO_AP_PT_Baseline_\"&H3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&H3),INDIRECT(\"CDO_MCR_PT_Baseline_\"&H3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&H3)),2,0),0)))","v":0},0,0,0,0,"<< Patient Count"]
["QP Status (Y=1,PQP=2,N=0) - Baseline Revenue",null,null,null,{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&E3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&E3),1,IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&E3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&E3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&F3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&F3),1,IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&F3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&F3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&G3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&G3),1,IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&G3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&G3),IF(INDIRECT(\"CDO_AP_REV_Baseline_\"&G3)>=INDIRECT(\"QP_AP_REV_Threshold_\"&G3),1,IF(OR(INDIRECT(\"CDO_AP_REV_Baseline_\"&G3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&G3),INDIRECT(\"CDO_MCR_REV_Baseline_\"&G3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&G3)),2,0)),IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&G3)>INDIRECT(\"PQP_MCR_REV_Threshold_\"&G3),IF(OR(INDIRECT(\"CDO_AP_REV_Baseline_\"&G3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&G3),INDIRECT(\"CDO_MCR_REV_Baseline_\"&G3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&G3)),2,0),0)))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&H3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&H3),1,IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&H3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&H3),IF(INDIRECT(\"CDO_AP_REV_Baseline_\"&H3)>=INDIRECT(\"QP_AP_REV_Threshold_\"&H3),1,IF(OR(INDIRECT(\"CDO_AP_REV_Baseline_\"&H3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&H3),INDIRECT(\"CDO_MCR_REV_Baseline_\"&H3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&H3)),2,0)),IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&H3)>INDIRECT(\"PQP_MCR_REV_Threshold_\"&H3),IF(OR(INDIRECT(\"CDO_AP_REV_Baseline_\"&H3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&H3),INDIRECT(\"CDO_MCR_REV_Baseline_\"&H3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&H3)),2,0),0)))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&I3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&I3),1,IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&I3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&I3),IF(INDIRECT(\"CDO_AP_REV_Baseline_\"&I3)>=INDIRECT(\"QP_AP_REV_Threshold_\"&I3),1,IF(OR(INDIRECT(\"CDO_AP_REV_Baseline_\"&I3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&I3),INDIRECT(\"CDO_MCR_REV_Baseline_\"&I3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&I3)),2,0)),IF(INDIRECT(\"CDO_MCR_REV_Baseline_\"&I3)>INDIRECT(\"PQP_MCR_REV_Threshold_\"&I3),IF(OR(INDIRECT(\"CDO_AP_REV_Baseline_\"&I3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&I3),INDIRECT(\"CDO_MCR_REV_Baseline_\"&I3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&I3)),2,0),0)))","v":0},0,0,0,"<< Revenue Count"]
["QP Status (Y=1,PQP=2,N=0) - Baseline",null,null,null,{"$f":"IF(OR(E21=1,E20=1),1,IF(AND(E20=0,E21=0),0,2))","v":0},0,0,0,0,0,0,0,"<< Determined QP status"]
["QP Status (Y=1,PQP=2,N=0) - Shifting Patient",null,null,null,{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&E3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&E3),1,IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&E3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&E3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&F3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&F3),1,IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&F3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&F3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&G3)>=INDIRECT(\"QP_MCR_PT_Threshold_\"&G3),1,IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&G3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&G3),IF(INDIRECT(\"CDO_AP_PT_Shift_\"&G3)>=INDIRECT(\"QP_AP_PT_Threshold_\"&G3),1,IF(OR(INDIRECT(\"CDO_AP_PT_Shift_\"&G3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&G3),INDIRECT(\"CDO_MCR_PT_Shift_\"&G3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&G3)),2,0)),IF(INDIRECT(\"CDO_MCR_PT_Shift_\"&G3)>INDIRECT(\"PQP_MCR_PT_Threshold_\"&G3),IF(OR(INDIRECT(\"CDO_AP_PT_Shift_\"&G3)>=INDIRECT(\"PQP_AP_PT_Threshold_\"&G3),INDIRECT(\"CDO_MCR_PT_Shift_\"&G3)>=INDIRECT(\"PQP_MCR_PT_Threshold_\"&G3)),2,0),0)))","v":1},1,1,1,1,1,"<< Patient Count"]
["QP Status (Y=1,PQP=2,N=0) - Shifting Revenue",null,null,null,{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&E3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&E3),1,IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&E3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&E3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&F3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&F3),1,IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&F3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&F3),2,0))","v":0},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&G3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&G3),1,IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&G3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&G3),IF(INDIRECT(\"CDO_AP_REV_Shift_\"&G3)>=INDIRECT(\"QP_AP_REV_Threshold_\"&G3),1,IF(OR(INDIRECT(\"CDO_AP_REV_Shift_\"&G3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&G3),INDIRECT(\"CDO_MCR_REV_Shift_\"&G3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&G3)),2,0)),IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&G3)>INDIRECT(\"PQP_MCR_REV_Threshold_\"&G3),IF(OR(INDIRECT(\"CDO_AP_REV_Shift_\"&G3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&G3),INDIRECT(\"CDO_MCR_REV_Shift_\"&G3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&G3)),2,0),0)))","v":1},{"$f":"IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&H3)>=INDIRECT(\"QP_MCR_REV_Threshold_\"&H3),1,IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&H3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&H3),IF(INDIRECT(\"CDO_AP_REV_Shift_\"&H3)>=INDIRECT(\"QP_AP_REV_Threshold_\"&H3),1,IF(OR(INDIRECT(\"CDO_AP_REV_Shift_\"&H3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&H3),INDIRECT(\"CDO_MCR_REV_Shift_\"&H3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&H3)),2,0)),IF(INDIRECT(\"CDO_MCR_REV_Shift_\"&H3)>INDIRECT(\"PQP_MCR_REV_Threshold_\"&H3),IF(OR(INDIRECT(\"CDO_AP_REV_Shift_\"&H3)>=INDIRECT(\"PQP_AP_REV_Threshold_\"&H3),INDIRECT(\"CDO_MCR_REV_Shift_\"&H3)>=INDIRECT(\"PQP_MCR_REV_Threshold_\"&H3)),2,0),0)))","v":1},2,2,2,2,"<< Revenue Count"]
["QP Status (Y=1,PQP=2,N=0) - Shifting",null,null,null,{"$f":"IF(OR(E24=1,E23=1),1,IF(AND(E23=0,E24=0),0,2))","v":0},0,1,1,1,1,1,1,"<< Determined QP status"]
["Participate in MIPS (Y=1,N=0)-Baseline",null,null,null,{"$f":"IF(OR(E22=0,AND(E22=2,'Input by Entity'!D47>0)),1,0)","v":1},{"$f":"IF(OR(F22=0,AND(F22=2,'Input by Entity'!E47>0)),1,0)","v":1},{"$f":"IF(OR(G22=0,AND(G22=2,'Input by Entity'!F47>0)),1,0)","v":1},{"$f":"IF(OR(H22=0,AND(H22=2,'Input by Entity'!G47>0)),1,0)","v":1},{"$f":"IF(OR(I22=0,AND(I22=2,'Input by Entity'!H47>0)),1,0)","v":1},{"$f":"IF(OR(J22=0,AND(J22=2,'Input by Entity'!I47>0)),1,0)","v":1},{"$f":"IF(OR(K22=0,AND(K22=2,'Input by Entity'!J47>0)),1,0)","v":1},{"$f":"IF(OR(L22=0,AND(L22=2,'Input by Entity'!K47>0)),1,0)","v":1}]
["Participate in MIPS (Y=1,N=0)-Shifting",null,null,null,{"$f":"IF(OR(E25=0,AND(E25=2,'Input by Entity'!D47>0)),1,0)","v":1},{"$f":"IF(OR(F25=0,AND(F25=2,'Input by Entity'!E47>0)),1,0)","v":1},{"$f":"IF(OR(G25=0,AND(G25=2,'Input by Entity'!F47>0)),1,0)","v":0},{"$f":"IF(OR(H25=0,AND(H25=2,'Input by Entity'!G47>0)),1,0)","v":0},{"$f":"IF(OR(I25=0,AND(I25=2,'Input by Entity'!H47>0)),1,0)","v":0},{"$f":"IF(OR(J25=0,AND(J25=2,'Input by Entity'!I47>0)),1,0)","v":0},{"$f":"IF(OR(K25=0,AND(K25=2,'Input by Entity'!J47>0)),1,0)","v":0},{"$f":"IF(OR(L25=0,AND(L25=2,'Input by Entity'!K47>0)),1,0)","v":0}]
[]
[]
["CPS Performance Threshold",null,null,null,3,15,30,60,{"$f":"H30","v":60},{"$f":"I30","v":60},60,60,60,60]
["(CMS calculates - Median)"]
[]
["Medical CPI (Baseline Cost)",null,null,null,2.1000000000000001E-2]
[]
["MIPS Scaling Factor",null,null,null,1,1,1,1,1,1,1,1,1,1]
["(CMS calculates - 1x to 3x; dependent upon budget neutrality)"]
[]
["Exceptional Performance Threshold",null,null,null,70,70,75,75,80,80,80,80,80,80]
["(CMS calculates - top 25th percentile)"]
[]
["Exceptional Performance Scaling Factor",null,null,null,0.16800000000000001,0.16800000000000001,{"$f":"F41","v":0.16800000000000001},0.25,{"$f":"H41","v":0.25},0.25,0.25,0.25,0.25,0.25]
["(CMS calculates - dependent upon performance)"]

{"sheet":"Data","index":7,"n_rows":173,"n_cols":13,"rows_kept":173,"cut":false,"hidden":true,"merged":[[171,1,172,1],[169,1,170,1],[26,1,27,1],[55,1,56,1],[84,1,85,1],[113,1,114,1],[142,1,143,1],[91,1,92,1],[68,1,71,1],[72,1,74,1],[75,1,78,1],[79,1,81,1],[82,1,83,1],[166,1,168,1],[97,1,100,1],[101,1,103,1],[4,1,5,1],[33,1,34,1],[62,1,63,1],[39,1,42,1],[43,1,45,1],[46,1,49,1],[50,1,52,1],[10,1,13,1],[14,1,16,1],[17,1,20,1],[21,1,23,1],[24,1,25,1],[53,1,54,1],[104,1,107,1],[108,1,110,1],[126,1,129,1],[130,1,132,1],[120,1,121,1],[162,1,165,1],[111,1,112,1],[140,1,141,1],[149,1,150,1],[133,1,136,1],[137,1,139,1],[155,1,158,1],[159,1,161,1]]}
[]
[null,{"$f":"CDO_NAME &\" --- Traditional Medicare - Total\"","v":"0 --- Traditional Medicare - Total"}]
[]
[null,null,null,{"$f":"'Input by Entity'!D14","v":2017},{"$f":"'Input by Entity'!E14","v":2018},{"$f":"'Input by Entity'!F14","v":2019},{"$f":"'Input by Entity'!G14","v":2020},{"$f":"'Input by Entity'!H14","v":2021},{"$f":"'Input by Entity'!I14","v":2022},{"$f":"'Input by Entity'!J14","v":2023},{"$f":"'Input by Entity'!K14","v":2024},{"$f":"'Input by Entity'!L14","v":2025},{"$f":"'Input by Entity'!M14","v":2026}]
[null,"Patients","Baseline Patient Count",{"$f":"SUM(D34,D63,D92)","v":1000},{"$f":"SUM(E34,E63,E92)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000]
[null,null,"Shifted Patient Count",{"$f":"SUM(D35,D64,D93)","v":1000},1000,1000,1000,1000,1000,1000,1000,1000,1000]
[null,"Baseline Revenue","Baseline",{"$f":"SUM(D36,D65,D94)","v":1000},1020.9999999999999,1042.4409999999998,1064.3322609999998,1086.6832384809998,1109.5035864891006,1132.8031618053717,1156.5920282032844,1180.8804607955533,1205.6789504722599]
[null,"Cost","VBC on Baseline",{"$f":"SUM(D37,D66,D95)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"SUM(D38,D67,D96)","v":1000},1020.9999999999999,1042.4409999999998,1064.3322609999998,1086.6832384809998,1109.5035864891006,1132.8031618053717,1156.5920282032844,1180.8804607955533,1205.6789504722599]
[null,"Shift","VBC on Baseline",{"$f":"SUM(D39,D68,D97)","v":0},0,0,0,0,0,0,0,0,0]
[null,"MIPS","Baseline with Fee Schedule",{"$f":"SUM(D40,D69,D98)","v":1000},1004.9999999999999,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1012.5500624999997]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"SUM(D41,D70,D99)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"MIPS Minimum",null,null,{"$f":"SUM(F42,F71,F100)","v":-40.400999999999989},{"$f":"SUM(G42,G71,G100)","v":-50.501249999999992},-70.70174999999999,-90.902249999999981,-90.902249999999981,-90.902249999999981,-90.902249999999981,-91.129505624999979]
[null,null,"MIPS Maximum",null,null,{"$f":"SUM(F43,F72,F101)","v":2.0200500000000012},6.0601500000000037,15.150374999999897,90.902250000000052,90.902250000000052,90.902250000000052,90.902250000000052,91.129505625000064]
[null,"AAPM","Baseline with Fee Schedule",{"$f":"SUM(D44,D73,D102)","v":1000},1004.9999999999999,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1017.6001874999998]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"SUM(D45,D74,D103)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"APM Payments",null,null,50.25,50.501249999999992,50.501249999999992,50.501249999999992,50.501249999999992,50.501249999999992,0,0]
[null,"MIPS - Patient Shift","Baseline with Fee Schedule",{"$f":"SUM(D47,D76,D105)","v":1000},1004.9999999999999,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1012.5500624999997]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"SUM(D48,D77,D106)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"MIPS Minimum",null,null,{"$f":"SUM(F49,F78,F107)","v":-40.400999999999989},-50.501249999999992,-70.70174999999999,-90.902249999999981,-90.902249999999981,-90.902249999999981,-90.902249999999981,-91.129505624999979]
[null,null,"MIPS Maximum",null,null,{"$f":"SUM(F50,F79,F108)","v":2.0200500000000012},6.0601500000000037,15.150374999999897,90.902250000000052,90.902250000000052,90.902250000000052,90.902250000000052,91.129505625000064]
[null,"AAPM - Patient Shift","Baseline with Fee Schedule",{"$f":"SUM(D51,D80,D109)","v":1000},1004.9999999999999,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1017.6001874999998]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"SUM(D52,D81,D110)","v":0},0,0,0,0,0,0,0,0,0]
[null,null,"APM Payments",null,null,50.25,50.501249999999992,50.501249999999992,50.501249999999992,50.501249999999992,50.501249999999992,0,0]
[null,"Payments","MIPS",{"$f":"SUM(D54,D83,D112)","v":0},0,0.72888402061855639,1.6398052941176464,{"$f":"SUM(H54,H83,H112)","v":6.2765839285714247},-8.3327062499999904,-8.3327062499999904,-8.3327062499999904,-8.3327062499999904,-8.3535380156249914]
[null,null,"AAPM",{"$f":"SUM(D55,D84,D113)","v":0},0,0,0,0,0,0,0,0,0]
[null,"Payments- Pt Shift","MIPS",{"$f":"SUM(D56,D85,D114)","v":0},0,0.72888402061855639,1.6398052941176464,0,0,0,0,0,0]
[null,null,"AAPM",{"$f":"SUM(D57,D86,D115)","v":0},0,0,0,50.501249999999992,50.501249999999992,50.501249999999992,50.501249999999992,0,0]
[]
[]
[null,{"$f":"CDO_NAME &\" --- Medicare Advanced APM\"","v":"0 --- Medicare Advanced APM"}]
[]
[null,null,null,{"$f":"D4","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Patients","Baseline Patient Count",{"$f":"AAPM_Patient_count","v":0},{"$f":"D34*(1+INDIRECT(\"AAPM_Pt_rate_\"&E33))","v":0},{"$f":"E34*(1+INDIRECT(\"AAPM_Pt_rate_\"&F33))","v":0},0,0,0,0,0,0,0]
[null,null,"Shifted Patient Count",{"$f":"D34","v":0},{"$f":"E$5*INDIRECT(\"AAPM_Pt_Dist_\"&E33)","v":0},{"$f":"F5*INDIRECT(\"AAPM_Pt_Dist_\"&F33)","v":500},500,500,500,500,500,500,500]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*AAPM_Rev_Percent","v":0},{"$f":"IFERROR(D36*E34/D34*(1+Medical_CPI),0)","v":0},0,0,0,0,0,0,0,0]
[null,"Cost","VBC on Baseline",{"$f":"D36*INDIRECT(\"AAPM_Rsk_Shr_\"&D33)","v":0},{"$f":"E36*INDIRECT(\"AAPM_Rsk_Shr_\"&E33)","v":0},{"$f":"F36*INDIRECT(\"AAPM_Rsk_Shr_\"&F33)","v":0},0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*AAPM_Rev_Percent","v":0},{"$f":"IFERROR(D$7/D$5*E35*(1+Medical_CPI),0)","v":0},521.2204999999999,532.16613049999989,543.34161924049988,554.7517932445503,566.40158090268585,578.29601410164219,590.44023039777665,602.83947523612994]
[null,"Shift","VBC on Baseline",{"$f":"D38*INDIRECT(\"AAPM_Rsk_Shr_\"&D33)","v":0},{"$f":"E38*INDIRECT(\"AAPM_Rsk_Shr_\"&E33)","v":0},0,0,0,0,0,0,0,0]
[null,"MIPS","Baseline with Fee Schedule",{"$f":"D36","v":0},{"$f":"IFERROR(D40*E34/D34*(1+INDIRECT(\"PartB_MIPS_\"&E33)),0)","v":0},{"$f":"IFERROR(E40*F34/E34*(1+INDIRECT(\"PartB_MIPS_\"&F33)),0)","v":0},0,0,0,0,0,0,0]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"D40*INDIRECT(\"AAPM_Rsk_Shr_\"&D33)","v":0},{"$f":"E40*INDIRECT(\"AAPM_Rsk_Shr_\"&E33)","v":0},{"$f":"F40*INDIRECT(\"AAPM_Rsk_Shr_\"&F33)","v":0},0,0,0,0,0,0,0]
[null,null,"MIPS Minimum",null,null,{"$f":"F40*INDIRECT(\"MIPS_MIN_\"&F33)","v":0},{"$f":"G40*INDIRECT(\"MIPS_MIN_\"&G33)","v":0},0,0,0,0,0,0]
[null,null,"MIPS Maximum",null,null,{"$f":"F40*(((1+INDIRECT(\"MIPS_MAX_\"&F33))*(1+INDIRECT(\"MIPS_Bonus_\"&F33)))-1)","v":0},{"$f":"G40*(((1+INDIRECT(\"MIPS_MAX_\"&G33))*(1+INDIRECT(\"MIPS_Bonus_\"&G33)))-1)","v":0},0,0,0,0,0,0]
[null,"AAPM","Baseline with Fee Schedule",{"$f":"D36","v":0},{"$f":"IFERROR(D44*E34/D34*(1+INDIRECT(\"PartB_APM_\"&E33)),0)","v":0},{"$f":"IFERROR(E44*F34/E34*(1+INDIRECT(\"PartB_APM_\"&F33)),0)","v":0},0,0,0,0,0,0,0]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"D44*INDIRECT(\"AAPM_Rsk_Shr_\"&D33)","v":0},{"$f":"E44*INDIRECT(\"AAPM_Rsk_Shr_\"&E33)","v":0},{"$f":"F44*INDIRECT(\"AAPM_Rsk_Shr_\"&F33)","v":0},0,0,0,0,0,0,0]
[null,null,"APM Payments",null,null,{"$f":"E44*INDIRECT(\"AAPM_Bonus_\"&F33)","v":0},{"$f":"F44*INDIRECT(\"AAPM_Bonus_\"&G33)","v":0},0,0,0,0,0,0]
[null,"MIPS - Patient Shift","Baseline with Fee Schedule",{"$f":"D40","v":0},{"$f":"IFERROR(D$11/D$5*E35*(1+INDIRECT(\"PartB_MIPS_\"&E33)),0)","v":0},{"$f":"IFERROR(E$11/E$5*F35*(1+INDIRECT(\"PartB_MIPS_\"&F33)),0)","v":505.01249999999987},505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,506.27503124999987]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"D47*INDIRECT(\"AAPM_Rsk_Shr_\"&D33)","v":0},{"$f":"E47*INDIRECT(\"AAPM_Rsk_Shr_\"&E33)","v":0},{"$f":"F47*INDIRECT(\"AAPM_Rsk_Shr_\"&F33)","v":0},{"$f":"G47*INDIRECT(\"AAPM_Rsk_Shr_\"&G33)","v":0},{"$f":"H47*INDIRECT(\"AAPM_Rsk_Shr_\"&H33)","v":0},{"$f":"I47*INDIRECT(\"AAPM_Rsk_Shr_\"&I33)","v":0},0,0,0,0]
[null,null,"MIPS Minimum",null,null,{"$f":"F47*INDIRECT(\"MIPS_MIN_\"&F33)","v":-20.200499999999995},{"$f":"G47*INDIRECT(\"MIPS_MIN_\"&G33)","v":-25.250624999999996},-35.350874999999995,-45.45112499999999,-45.45112499999999,-45.45112499999999,-45.45112499999999,-45.564752812499989]
[null,null,"MIPS Maximum",null,null,{"$f":"F47*(((1+INDIRECT(\"MIPS_MAX_\"&F33))*(1+INDIRECT(\"MIPS_Bonus_\"&F33)))-1)","v":1.0100250000000006},{"$f":"G47*(((1+INDIRECT(\"MIPS_MAX_\"&G33))*(1+INDIRECT(\"MIPS_Bonus_\"&G33)))-1)","v":3.0300750000000019},7.5751874999999487,45.451125000000026,45.451125000000026,45.451125000000026,45.451125000000026,45.564752812500032]
[null,"AAPM - Patient Shift","Baseline with Fee Schedule",{"$f":"D38","v":0},{"$f":"IFERROR(D$15/D$5*E35*(1+INDIRECT(\"PartB_APM_\"&E33)),0)","v":0},{"$f":"IFERROR(E$15/E$5*F35*(1+INDIRECT(\"PartB_APM_\"&F33)),0)","v":505.01249999999987},505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,508.80009374999992]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"D51*INDIRECT(\"AAPM_Rsk_Shr_\"&D33)","v":0},{"$f":"E51*INDIRECT(\"AAPM_Rsk_Shr_\"&E33)","v":0},{"$f":"F51*INDIRECT(\"AAPM_Rsk_Shr_\"&F33)","v":0},0,0,0,0,0,0,0]
[null,null,"APM Payments",null,null,{"$f":"E51*INDIRECT(\"AAPM_Bonus_\"&F33)","v":0},{"$f":"F51*INDIRECT(\"AAPM_Bonus_\"&G33)","v":25.250624999999996},25.250624999999996,25.250624999999996,25.250624999999996,25.250624999999996,0,0]
[null,"Payments","MIPS",null,null,{"$f":"F40*Assumptions!E$26*(INDIRECT(\"CDO_MIPS_\"&F33)+INDIRECT(\"CDO_MIPS_Bonus_\"&F33))","v":0},{"$f":"G40*Assumptions!F$26*(INDIRECT(\"CDO_MIPS_\"&G33)+INDIRECT(\"CDO_MIPS_Bonus_\"&G33))","v":0},{"$f":"H40*Assumptions!G$26*(INDIRECT(\"CDO_MIPS_\"&H33)+INDIRECT(\"CDO_MIPS_Bonus_\"&H33))","v":0},{"$f":"I40*Assumptions!H$26*(INDIRECT(\"CDO_MIPS_\"&I33)+INDIRECT(\"CDO_MIPS_Bonus_\"&I33))","v":0},{"$f":"J40*Assumptions!I$26*(INDIRECT(\"CDO_MIPS_\"&J33)+INDIRECT(\"CDO_MIPS_Bonus_\"&J33))","v":0},{"$f":"K40*Assumptions!J$26*(INDIRECT(\"CDO_MIPS_\"&K33)+INDIRECT(\"CDO_MIPS_Bonus_\"&K33))","v":0},{"$f":"L40*Assumptions!K$26*(INDIRECT(\"CDO_MIPS_\"&L33)+INDIRECT(\"CDO_MIPS_Bonus_\"&L33))","v":0},{"$f":"M40*Assumptions!L$26*(INDIRECT(\"CDO_MIPS_\"&M33)+INDIRECT(\"CDO_MIPS_Bonus_\"&M33))","v":0}]
[null,null,"AAPM",null,null,{"$f":"IF(Assumptions!E$22=1,F46,0)","v":0},{"$f":"IF(Assumptions!F$22=1,G46,0)","v":0},{"$f":"IF(Assumptions!G$22=1,H46,0)","v":0},{"$f":"IF(Assumptions!H$22=1,I46,0)","v":0},{"$f":"IF(Assumptions!I$22=1,J46,0)","v":0},{"$f":"IF(Assumptions!J$22=1,K46,0)","v":0},{"$f":"IF(Assumptions!K$22=1,L46,0)","v":0},{"$f":"IF(Assumptions!L$22=1,M46,0)","v":0}]
[null,"Payments- Pt Shift","MIPS",null,null,{"$f":"F47*Assumptions!E$27*(INDIRECT(\"CDO_MIPS_\"&F33)+INDIRECT(\"CDO_MIPS_Bonus_\"&F33))","v":0.3644420103092782},{"$f":"G47*Assumptions!F$27*(INDIRECT(\"CDO_MIPS_\"&G33)+INDIRECT(\"CDO_MIPS_Bonus_\"&G33))","v":0.81990264705882321},{"$f":"H47*Assumptions!G$27*(INDIRECT(\"CDO_MIPS_\"&H33)+INDIRECT(\"CDO_MIPS_Bonus_\"&H33))","v":0},{"$f":"I47*Assumptions!H$27*(INDIRECT(\"CDO_MIPS_\"&I33)+INDIRECT(\"CDO_MIPS_Bonus_\"&I33))","v":0},{"$f":"J47*Assumptions!I$27*(INDIRECT(\"CDO_MIPS_\"&J33)+INDIRECT(\"CDO_MIPS_Bonus_\"&J33))","v":0},{"$f":"K47*Assumptions!J$27*(INDIRECT(\"CDO_MIPS_\"&K33)+INDIRECT(\"CDO_MIPS_Bonus_\"&K33))","v":0},{"$f":"L47*Assumptions!K$27*(INDIRECT(\"CDO_MIPS_\"&L33)+INDIRECT(\"CDO_MIPS_Bonus_\"&L33))","v":0},{"$f":"M47*Assumptions!L$27*(INDIRECT(\"CDO_MIPS_\"&M33)+INDIRECT(\"CDO_MIPS_Bonus_\"&M33))","v":0}]
[null,null,"AAPM",null,null,{"$f":"IF(Assumptions!E$25=1,F53,0)","v":0},{"$f":"IF(Assumptions!F$25=1,G53,0)","v":0},{"$f":"IF(Assumptions!G$25=1,H53,0)","v":25.250624999999996},{"$f":"IF(Assumptions!H$25=1,I53,0)","v":25.250624999999996},{"$f":"IF(Assumptions!I$25=1,J53,0)","v":25.250624999999996},{"$f":"IF(Assumptions!J$25=1,K53,0)","v":25.250624999999996},{"$f":"IF(Assumptions!K$25=1,L53,0)","v":0},{"$f":"IF(Assumptions!L$25=1,M53,0)","v":0}]
[]
[]
[null,{"$f":"CDO_NAME &\" --- Medicare APM\"","v":"0 --- Medicare APM"}]
[]
[null,null,null,{"$f":"D33","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Patients","Baseline Patient Count",{"$f":"APM_Patient_count","v":0},{"$f":"D63*(1+INDIRECT(\"APM_Pt_rate_\"&E62))","v":0},{"$f":"E63*(1+INDIRECT(\"APM_Pt_rate_\"&F62))","v":0},0,0,0,0,0,0,0]
[null,null,"Shifted Patient Count",{"$f":"D63","v":0},{"$f":"E$5*INDIRECT(\"APM_Pt_Dist_\"&E62)","v":0},{"$f":"F$5*INDIRECT(\"APM_Pt_Dist_\"&F62)","v":0},0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*APM_Rev_Percent","v":0},{"$f":"IFERROR(D65*E63/D63*(1+Medical_CPI),0)","v":0},0,0,0,0,0,0,0,0]
[null,"Cost","VBC on Baseline",{"$f":"D65*INDIRECT(\"APM_Rsk_Shr_\"&D62)","v":0},{"$f":"E65*INDIRECT(\"APM_Rsk_Shr_\"&E62)","v":0},{"$f":"F65*INDIRECT(\"APM_Rsk_Shr_\"&F62)","v":0},0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*APM_Rev_Percent","v":0},{"$f":"IFERROR(D$7/D$5*E64*(1+Medical_CPI),0)","v":0},0,0,0,0,0,0,0,0]
[null,"Shift","VBC on Baseline",{"$f":"D67*INDIRECT(\"APM_Rsk_Shr_\"&D62)","v":0},{"$f":"E67*INDIRECT(\"APM_Rsk_Shr_\"&E62)","v":0},0,0,0,0,0,0,0,0]
[null,"MIPS","Baseline with Fee Schedule",{"$f":"D65","v":0},{"$f":"IFERROR(D69*E63/D63*(1+INDIRECT(\"PartB_MIPS_\"&E62)),0)","v":0},{"$f":"IFERROR(E69*F63/E63*(1+INDIRECT(\"PartB_MIPS_\"&F62)),0)","v":0},0,0,0,0,0,0,0]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"D69*INDIRECT(\"APM_Rsk_Shr_\"&D62)","v":0},{"$f":"E69*INDIRECT(\"APM_Rsk_Shr_\"&E62)","v":0},{"$f":"F69*INDIRECT(\"APM_Rsk_Shr_\"&F62)","v":0},0,0,0,0,0,0,0]
[null,null,"MIPS Minimum",null,null,{"$f":"F69*INDIRECT(\"MIPS_MIN_\"&F62)","v":0},{"$f":"G69*INDIRECT(\"MIPS_MIN_\"&G62)","v":0},0,0,0,0,0,0]
[null,null,"MIPS Maximum",null,null,{"$f":"F69*(((1+INDIRECT(\"MIPS_MAX_\"&F62))*(1+INDIRECT(\"MIPS_Bonus_\"&F62)))-1)","v":0},{"$f":"G69*(((1+INDIRECT(\"MIPS_MAX_\"&G62))*(1+INDIRECT(\"MIPS_Bonus_\"&G62)))-1)","v":0},0,0,0,0,0,0]
[null,"AAPM","Baseline with Fee Schedule",{"$f":"D65","v":0},{"$f":"IFERROR(D73*E63/D63*(1+INDIRECT(\"PartB_APM_\"&E62)),0)","v":0},{"$f":"IFERROR(E73*F63/E63*(1+INDIRECT(\"PartB_APM_\"&F62)),0)","v":0},0,0,0,0,0,0,0]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments",null,null,{"$f":"E73*INDIRECT(\"AAPM_Bonus_\"&F62)","v":0},{"$f":"F73*INDIRECT(\"AAPM_Bonus_\"&G62)","v":0},{"$f":"G73*INDIRECT(\"AAPM_Bonus_\"&H62)","v":0},{"$f":"H73*INDIRECT(\"AAPM_Bonus_\"&I62)","v":0},{"$f":"I73*INDIRECT(\"AAPM_Bonus_\"&J62)","v":0},{"$f":"J73*INDIRECT(\"AAPM_Bonus_\"&K62)","v":0},{"$f":"K73*INDIRECT(\"AAPM_Bonus_\"&L62)","v":0},{"$f":"L73*INDIRECT(\"AAPM_Bonus_\"&M62)","v":0}]
[null,"MIPS - Patient Shift","Baseline with Fee Schedule",{"$f":"D69","v":0},{"$f":"IFERROR(D$11/D$5*E64*(1+INDIRECT(\"PartB_MIPS_\"&E62)),0)","v":0},{"$f":"IFERROR(E$11/E$5*F64*(1+INDIRECT(\"PartB_MIPS_\"&F62)),0)","v":0},0,0,0,0,0,0,0]
[null,null,"VBC on Baseline with Fee Schedule",{"$f":"D76*INDIRECT(\"APM_Rsk_Shr_\"&D62)","v":0},{"$f":"E76*INDIRECT(\"APM_Rsk_Shr_\"&E62)","v":0},{"$f":"F76*INDIRECT(\"APM_Rsk_Shr_\"&F62)","v":0},0,0,0,0,0,0,0]
[null,null,"MIPS Minimum",null,null,{"$f":"F76*INDIRECT(\"MIPS_MIN_\"&F62)","v":0},{"$f":"G76*INDIRECT(\"MIPS_MIN_\"&G62)","v":0},0,0,0,0,0,0]
[null,null,"MIPS Maximum",null,null,{"$f":"F76*(((1+INDIRECT(\"MIPS_MAX_\"&F62))*(1+INDIRECT(\"MIPS_Bonus_\"&F62)))-1)","v":0},{"$f":"G76*(((1+INDIRECT(\"MIPS_MAX_\"&G62))*(1+INDIRECT(\"MIPS_Bonus_\"&G62)))-1)","v":0},0,0,0,0,0,0]
[null,"AAPM - Patient Shift","Baseline with Fee Schedule",{"$f":"D76","v":0},{"$f":"IFERROR(D$15/D$5*E64*(1+INDIRECT(\"PartB_APM_\"&E62)),0)","v":0},{"$f":"IFERROR(E$15/E$5*F64*(1+INDIRECT(\"PartB_APM_\"&F62)),0)","v":0},0,0,0,0,0,0,0]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments",null,null,{"$f":"E80*INDIRECT(\"AAPM_Bonus_\"&F62)","v":0},{"$f":"F80*INDIRECT(\"AAPM_Bonus_\"&G62)","v":0},{"$f":"G80*INDIRECT(\"AAPM_Bonus_\"&H62)","v":0},{"$f":"H80*INDIRECT(\"AAPM_Bonus_\"&I62)","v":0},{"$f":"I80*INDIRECT(\"AAPM_Bonus_\"&J62)","v":0},{"$f":"J80*INDIRECT(\"AAPM_Bonus_\"&K62)","v":0},{"$f":"K80*INDIRECT(\"AAPM_Bonus_\"&L62)","v":0},{"$f":"L80*INDIRECT(\"AAPM_Bonus_\"&M62)","v":0}]
[null,"Payments","MIPS",null,null,{"$f":"F69*Assumptions!E$26*(INDIRECT(\"CDO_MIPS_\"&F62)+INDIRECT(\"CDO_MIPS_Bonus_\"&F62))","v":0},{"$f":"G69*Assumptions!F$26*(INDIRECT(\"CDO_MIPS_\"&G62)+INDIRECT(\"CDO_MIPS_Bonus_\"&G62))","v":0},{"$f":"H69*Assumptions!G$26*(INDIRECT(\"CDO_MIPS_\"&H62)+INDIRECT(\"CDO_MIPS_Bonus_\"&H62))","v":0},{"$f":"I69*Assumptions!H$26*(INDIRECT(\"CDO_MIPS_\"&I62)+INDIRECT(\"CDO_MIPS_Bonus_\"&I62))","v":0},{"$f":"J69*Assumptions!I$26*(INDIRECT(\"CDO_MIPS_\"&J62)+INDIRECT(\"CDO_MIPS_Bonus_\"&J62))","v":0},{"$f":"K69*Assumptions!J$26*(INDIRECT(\"CDO_MIPS_\"&K62)+INDIRECT(\"CDO_MIPS_Bonus_\"&K62))","v":0},{"$f":"L69*Assumptions!K$26*(INDIRECT(\"CDO_MIPS_\"&L62)+INDIRECT(\"CDO_MIPS_Bonus_\"&L62))","v":0},{"$f":"M69*Assumptions!L$26*(INDIRECT(\"CDO_MIPS_\"&M62)+INDIRECT(\"CDO_MIPS_Bonus_\"&M62))","v":0}]
[null,null,"AAPM",null,null,{"$f":"IF(Assumptions!E$22=1,F75,0)","v":0},{"$f":"IF(Assumptions!F$22=1,G75,0)","v":0},{"$f":"IF(Assumptions!G$22=1,H75,0)","v":0},{"$f":"IF(Assumptions!H$22=1,I75,0)","v":0},{"$f":"IF(Assumptions!I$22=1,J75,0)","v":0},{"$f":"IF(Assumptions!J$22=1,K75,0)","v":0},{"$f":"IF(Assumptions!K$22=1,L75,0)","v":0},{"$f":"IF(Assumptions!L$22=1,M75,0)","v":0}]
[null,"Payments- Pt Shift","MIPS",null,null,{"$f":"F76*Assumptions!E$27*(INDIRECT(\"CDO_MIPS_\"&F62)+INDIRECT(\"CDO_MIPS_Bonus_\"&F62))","v":0},{"$f":"G76*Assumptions!F$27*(INDIRECT(\"CDO_MIPS_\"&G62)+INDIRECT(\"CDO_MIPS_Bonus_\"&G62))","v":0},{"$f":"H76*Assumptions!G$27*(INDIRECT(\"CDO_MIPS_\"&H62)+INDIRECT(\"CDO_MIPS_Bonus_\"&H62))","v":0},{"$f":"I76*Assumptions!H$27*(INDIRECT(\"CDO_MIPS_\"&I62)+INDIRECT(\"CDO_MIPS_Bonus_\"&I62))","v":0},{"$f":"J76*Assumptions!I$27*(INDIRECT(\"CDO_MIPS_\"&J62)+INDIRECT(\"CDO_MIPS_Bonus_\"&J62))","v":0},{"$f":"K76*Assumptions!J$27*(INDIRECT(\"CDO_MIPS_\"&K62)+INDIRECT(\"CDO_MIPS_Bonus_\"&K62))","v":0},{"$f":"L76*Assumptions!K$27*(INDIRECT(\"CDO_MIPS_\"&L62)+INDIRECT(\"CDO_MIPS_Bonus_\"&L62))","v":0},{"$f":"M76*Assumptions!L$27*(INDIRECT(\"CDO_MIPS_\"&M62)+INDIRECT(\"CDO_MIPS_Bonus_\"&M62))","v":0}]
[null,null,"AAPM",null,null,{"$f":"IF(Assumptions!E$25=1,F82,0)","v":0},{"$f":"IF(Assumptions!F$25=1,G82,0)","v":0},{"$f":"IF(Assumptions!G$25=1,H82,0)","v":0},{"$f":"IF(Assumptions!H$25=1,I82,0)","v":0},{"$f":"IF(Assumptions!I$25=1,J82,0)","v":0},{"$f":"IF(Assumptions!J$25=1,K82,0)","v":0},{"$f":"IF(Assumptions!K$25=1,L82,0)","v":0},{"$f":"IF(Assumptions!L$25=1,M82,0)","v":0}]
[]
[]
[null,{"$f":"CDO_NAME &\" ---Medicare FFS\"","v":"0 ---Medicare FFS"}]
[]
[null,null,null,{"$f":"D62","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Patients","Baseline Patient Count",{"$f":"FFS_Patient_count","v":1000},{"$f":"D92*(1+INDIRECT(\"FFS_Pt_rate_\"&E91))","v":1000},{"$f":"E92*(1+INDIRECT(\"FFS_Pt_rate_\"&F91))","v":1000},1000,1000,1000,1000,1000,1000,1000]
[null,null,"Shifted Patient Count",{"$f":"D92","v":1000},{"$f":"E$5*INDIRECT(\"FFS_Pt_Dist_\"&E91)","v":1000},{"$f":"F$5*INDIRECT(\"FFS_Pt_Dist_\"&F91)","v":500},500,500,500,500,500,500,500]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*FFS_Rev_Percent","v":1000},{"$f":"IFERROR(D94*E92/D92*(1+Medical_CPI),0)","v":1020.9999999999999},{"$f":"IFERROR(E94*F92/E92*(1+Medical_CPI),0)","v":1042.4409999999998},1064.3322609999998,1086.6832384809998,1109.5035864891006,1132.8031618053717,1156.5920282032844,1180.8804607955533,1205.6789504722599]
[null,"Cost","VBC on Baseline"]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*FFS_Rev_Percent","v":1000},{"$f":"IFERROR(D$7/D$5*E93*(1+Medical_CPI),0)","v":1020.9999999999999},521.2204999999999,532.16613049999989,543.34161924049988,554.7517932445503,566.40158090268585,578.29601410164219,590.44023039777665,602.83947523612994]
[null,"Shift","VBC on Baseline"]
[null,"MIPS","Baseline with Fee Schedule",{"$f":"D94","v":1000},{"$f":"IFERROR(D98*E92/D92*(1+INDIRECT(\"PartB_MIPS_\"&E91)),0)","v":1004.9999999999999},{"$f":"IFERROR(E98*F92/E92*(1+INDIRECT(\"PartB_MIPS_\"&F91)),0)","v":1010.0249999999997},1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1012.5500624999997]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"MIPS Minimum",null,null,{"$f":"F98*INDIRECT(\"MIPS_MIN_\"&F91)","v":-40.400999999999989},{"$f":"G98*INDIRECT(\"MIPS_MIN_\"&G91)","v":-50.501249999999992},-70.70174999999999,-90.902249999999981,-90.902249999999981,-90.902249999999981,-90.902249999999981,-91.129505624999979]
[null,null,"MIPS Maximum",null,null,{"$f":"F98*(((1+INDIRECT(\"MIPS_MAX_\"&F91))*(1+INDIRECT(\"MIPS_Bonus_\"&F91)))-1)","v":2.0200500000000012},{"$f":"G98*(((1+INDIRECT(\"MIPS_MAX_\"&G91))*(1+INDIRECT(\"MIPS_Bonus_\"&G91)))-1)","v":6.0601500000000037},15.150374999999897,90.902250000000052,90.902250000000052,90.902250000000052,90.902250000000052,91.129505625000064]
[null,"AAPM","Baseline with Fee Schedule",{"$f":"D94","v":1000},{"$f":"IFERROR(D102*E92/D92*(1+INDIRECT(\"PartB_APM_\"&E91)),0)","v":1004.9999999999999},{"$f":"IFERROR(E102*F92/E92*(1+INDIRECT(\"PartB_APM_\"&F91)),0)","v":1010.0249999999997},1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1010.0249999999997,1017.6001874999998]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments",null,null,{"$f":"E102*INDIRECT(\"AAPM_Bonus_\"&F91)","v":50.25},{"$f":"F102*INDIRECT(\"AAPM_Bonus_\"&G91)","v":50.501249999999992},{"$f":"G102*INDIRECT(\"AAPM_Bonus_\"&H91)","v":50.501249999999992},{"$f":"H102*INDIRECT(\"AAPM_Bonus_\"&I91)","v":50.501249999999992},{"$f":"I102*INDIRECT(\"AAPM_Bonus_\"&J91)","v":50.501249999999992},{"$f":"J102*INDIRECT(\"AAPM_Bonus_\"&K91)","v":50.501249999999992},{"$f":"K102*INDIRECT(\"AAPM_Bonus_\"&L91)","v":0},{"$f":"L102*INDIRECT(\"AAPM_Bonus_\"&M91)","v":0}]
[null,"MIPS - Patient Shift","Baseline with Fee Schedule",{"$f":"D98","v":1000},{"$f":"IFERROR(D$11/D$5*E93*(1+INDIRECT(\"PartB_MIPS_\"&E91)),0)","v":1004.9999999999999},{"$f":"IFERROR(E$11/E$5*F93*(1+INDIRECT(\"PartB_MIPS_\"&F91)),0)","v":505.01249999999987},505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,506.27503124999987]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"MIPS Minimum",null,null,{"$f":"F105*INDIRECT(\"MIPS_MIN_\"&F91)","v":-20.200499999999995},{"$f":"G105*INDIRECT(\"MIPS_MIN_\"&G91)","v":-25.250624999999996},-35.350874999999995,-45.45112499999999,-45.45112499999999,-45.45112499999999,-45.45112499999999,-45.564752812499989]
[null,null,"MIPS Maximum",null,null,{"$f":"F105*(((1+INDIRECT(\"MIPS_MAX_\"&F91))*(1+INDIRECT(\"MIPS_Bonus_\"&F91)))-1)","v":1.0100250000000006},{"$f":"G105*(((1+INDIRECT(\"MIPS_MAX_\"&G91))*(1+INDIRECT(\"MIPS_Bonus_\"&G91)))-1)","v":3.0300750000000019},7.5751874999999487,45.451125000000026,45.451125000000026,45.451125000000026,45.451125000000026,45.564752812500032]
[null,"AAPM - Patient Shift","Baseline with Fee Schedule",{"$f":"D102","v":1000},{"$f":"IFERROR(D$15/D$5*E93*(1+INDIRECT(\"PartB_APM_\"&E91)),0)","v":1004.9999999999999},{"$f":"IFERROR(E$15/E$5*F93*(1+INDIRECT(\"PartB_APM_\"&F91)),0)","v":505.01249999999987},505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,505.01249999999987,508.80009374999992]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments",null,null,{"$f":"E109*INDIRECT(\"AAPM_Bonus_\"&F91)","v":50.25},{"$f":"F109*INDIRECT(\"AAPM_Bonus_\"&G91)","v":25.250624999999996},25.250624999999996,25.250624999999996,25.250624999999996,25.250624999999996,0,0]
[null,"Payments","MIPS",null,null,{"$f":"F98*Assumptions!E$26*(INDIRECT(\"CDO_MIPS_\"&F91)+INDIRECT(\"CDO_MIPS_Bonus_\"&F91))","v":0.72888402061855639},{"$f":"G98*Assumptions!F$26*(INDIRECT(\"CDO_MIPS_\"&G91)+INDIRECT(\"CDO_MIPS_Bonus_\"&G91))","v":1.6398052941176464},{"$f":"H98*Assumptions!G$26*(INDIRECT(\"CDO_MIPS_\"&H91)+INDIRECT(\"CDO_MIPS_Bonus_\"&H91))","v":6.2765839285714247},{"$f":"I98*Assumptions!H$26*(INDIRECT(\"CDO_MIPS_\"&I91)+INDIRECT(\"CDO_MIPS_Bonus_\"&I91))","v":-8.3327062499999904},{"$f":"J98*Assumptions!I$26*(INDIRECT(\"CDO_MIPS_\"&J91)+INDIRECT(\"CDO_MIPS_Bonus_\"&J91))","v":-8.3327062499999904},{"$f":"K98*Assumptions!J$26*(INDIRECT(\"CDO_MIPS_\"&K91)+INDIRECT(\"CDO_MIPS_Bonus_\"&K91))","v":-8.3327062499999904},{"$f":"L98*Assumptions!K$26*(INDIRECT(\"CDO_MIPS_\"&L91)+INDIRECT(\"CDO_MIPS_Bonus_\"&L91))","v":-8.3327062499999904},{"$f":"M98*Assumptions!L$26*(INDIRECT(\"CDO_MIPS_\"&M91)+INDIRECT(\"CDO_MIPS_Bonus_\"&M91))","v":-8.3535380156249914}]
[null,null,"AAPM",null,null,{"$f":"IF(Assumptions!E$22=1,F104,0)","v":0},{"$f":"IF(Assumptions!F$22=1,G104,0)","v":0},{"$f":"IF(Assumptions!G$22=1,H104,0)","v":0},{"$f":"IF(Assumptions!H$22=1,I104,0)","v":0},{"$f":"IF(Assumptions!I$22=1,J104,0)","v":0},{"$f":"IF(Assumptions!J$22=1,K104,0)","v":0},{"$f":"IF(Assumptions!K$22=1,L104,0)","v":0},{"$f":"IF(Assumptions!L$22=1,M104,0)","v":0}]
[null,"Payments- Pt Shift","MIPS",null,null,{"$f":"F105*Assumptions!E$27*(INDIRECT(\"CDO_MIPS_\"&F91)+INDIRECT(\"CDO_MIPS_Bonus_\"&F91))","v":0.3644420103092782},{"$f":"G105*Assumptions!F$27*(INDIRECT(\"CDO_MIPS_\"&G91)+INDIRECT(\"CDO_MIPS_Bonus_\"&G91))","v":0.81990264705882321},{"$f":"H105*Assumptions!G$27*(INDIRECT(\"CDO_MIPS_\"&H91)+INDIRECT(\"CDO_MIPS_Bonus_\"&H91))","v":0},{"$f":"I105*Assumptions!H$27*(INDIRECT(\"CDO_MIPS_\"&I91)+INDIRECT(\"CDO_MIPS_Bonus_\"&I91))","v":0},{"$f":"J105*Assumptions!I$27*(INDIRECT(\"CDO_MIPS_\"&J91)+INDIRECT(\"CDO_MIPS_Bonus_\"&J91))","v":0},{"$f":"K105*Assumptions!J$27*(INDIRECT(\"CDO_MIPS_\"&K91)+INDIRECT(\"CDO_MIPS_Bonus_\"&K91))","v":0},{"$f":"L105*Assumptions!K$27*(INDIRECT(\"CDO_MIPS_\"&L91)+INDIRECT(\"CDO_MIPS_Bonus_\"&L91))","v":0},{"$f":"M105*Assumptions!L$27*(INDIRECT(\"CDO_MIPS_\"&M91)+INDIRECT(\"CDO_MIPS_Bonus_\"&M91))","v":0}]
[null,null,"AAPM",null,null,{"$f":"IF(Assumptions!E$25=1,F111,0)","v":0},{"$f":"IF(Assumptions!F$25=1,G111,0)","v":0},{"$f":"IF(Assumptions!G$25=1,H111,0)","v":25.250624999999996},{"$f":"IF(Assumptions!H$25=1,I111,0)","v":25.250624999999996},{"$f":"IF(Assumptions!I$25=1,J111,0)","v":25.250624999999996},{"$f":"IF(Assumptions!J$25=1,K111,0)","v":25.250624999999996},{"$f":"IF(Assumptions!K$25=1,L111,0)","v":0},{"$f":"IF(Assumptions!L$25=1,M111,0)","v":0}]
[]
[]
[null,{"$f":"CDO_NAME &\" --- Other Payer AAPM\"","v":"0 --- Other Payer AAPM"}]
[]
[null,null,null,{"$f":"D91","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Patients","Baseline Patient Count",{"$f":"Comm_Patient_count","v":0},{"$f":"D121*(1+INDIRECT(\"Comm_Pt_rate_\"&E120))","v":0},{"$f":"E121*(1+INDIRECT(\"Comm_Pt_rate_\"&F120))","v":0},0,0,0,0,0,0,0]
[null,null,"Shifted Patient Count",{"$f":"D121","v":0},{"$f":"E121","v":0},0,0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*Comm_Rev_Percent","v":0},{"$f":"D123*(1+INDIRECT(\"Comm_Pt_rate_\"&E120))*(1+Medical_CPI)","v":0},0,0,0,0,0,0,0,0]
[null,"Cost","VBC on Baseline",null,{"$f":"E123*INDIRECT(\"Comm_Rsk_Shr_\"&E120)","v":0},{"$f":"F123*INDIRECT(\"Comm_Rsk_Shr_\"&F120)","v":0},0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*Comm_Rev_Percent","v":0},{"$f":"D125*(1+INDIRECT(\"Comm_Pt_rate_\"&E120))*(1+Medical_CPI)","v":0},0,0,0,0,0,0,0,0]
[null,"Shift","VBC on Baseline",null,{"$f":"E125*INDIRECT(\"Comm_Rsk_Shr_\"&E120)","v":0},{"$f":"F125*INDIRECT(\"Comm_Rsk_Shr_\"&F120)","v":0},0,0,0,0,0,0,0]
[null,"MIPS","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"MIPS Minimum"]
[null,null,"MIPS Maximum"]
[null,"AAPM","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments"]
[null,"MIPS - Patient Shift","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"MIPS Minimum"]
[null,null,"MIPS Maximum"]
[null,"AAPM - Patient Shift","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments"]
[null,"Payments","MIPS"]
[null,null,"AAPM"]
[null,"Payments- Pt Shift","MIPS"]
[null,null,"AAPM"]
[]
[]
[null,{"$f":"CDO_NAME &\" --- Other Payer non AAPM\"","v":"0 --- Other Payer non AAPM"}]
[]
[null,null,null,{"$f":"D120","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026]
[null,"Patients","Baseline Patient Count",{"$f":"All_Other_Patient_count","v":0},{"$f":"D150*(1+INDIRECT(\"All_other_Pt_rate_\"&E149))","v":0},{"$f":"E150*(1+INDIRECT(\"All_other_Pt_rate_\"&F149))","v":0},0,0,0,0,0,0,0]
[null,null,"Shifted Patient Count",{"$f":"D150","v":0},{"$f":"E150","v":0},0,0,0,0,0,0,0,0]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*All_Other_Rev_Percent","v":0},{"$f":"D152*(1+INDIRECT(\"All_other_Pt_rate_\"&E149))*(1+Medical_CPI)","v":0},0,0,0,0,0,0,0,0]
[null,null,"VBC on Baseline"]
[null,"Baseline Revenue","Baseline",{"$f":"Revenue*All_Other_Rev_Percent","v":0},{"$f":"D154*(1+INDIRECT(\"All_other_Pt_rate_\"&E149))*(1+Medical_CPI)","v":0},0,0,0,0,0,0,0,0]
[null,"Shift","VBC on Baseline"]
[null,"MIPS","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"MIPS Minimum"]
[null,null,"MIPS Maximum"]
[null,"AAPM","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments"]
[null,"MIPS - Patient Shift","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"MIPS Minimum"]
[null,null,"MIPS Maximum"]
[null,"AAPM - Patient Shift","Baseline with Fee Schedule"]
[null,null,"VBC on Baseline with Fee Schedule"]
[null,null,"APM Payments"]
[null,"Payments","MIPS"]
[null,null,"AAPM"]
[null,"Payments- Pt Shift","MIPS"]
[null,null,"AAPM"]

{"sheet":"Revenue at Risk Summary","index":8,"n_rows":56,"n_cols":13,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,2,0,12]]}
[null,null,"MACRA/QPP - Provider Revenue Model - Revenue at Risk Summary"]
[]
[null,null,{"$f":"CDO_NAME &\"   Revenue in ( '000)\"","v":"0   Revenue in ( '000)"}]
[null,null,"Scenarios",2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total"]
[null,null,"Baseline Cost (Overhead)",{"$f":"SUM(Data!E7,Data!E123,Data!E152,Data!E8,Data!E124)","v":1020.9999999999999},{"$f":"SUM(Data!F7,Data!F123,Data!F152,Data!F8,Data!F124)","v":1042.4409999999998},{"$f":"SUM(Data!G7,Data!G123,Data!G152,Data!G8,Data!G124)","v":1064.3322609999998},{"$f":"SUM(Data!H7,Data!H123,Data!H152,Data!H8,Data!H124)","v":1086.6832384809998},{"$f":"SUM(Data!I7,Data!I123,Data!I152,Data!I8,Data!I124)","v":1109.5035864891006},{"$f":"SUM(Data!J7,Data!J123,Data!J152,Data!J8,Data!J124)","v":1132.8031618053717},{"$f":"SUM(Data!K7,Data!K123,Data!K152,Data!K8,Data!K124)","v":1156.5920282032844},{"$f":"SUM(Data!L7,Data!L123,Data!L152,Data!L8,Data!L124)","v":1180.8804607955533},{"$f":"SUM(Data!M7,Data!M123,Data!M152,Data!M8,Data!M124)","v":1205.6789504722599},{"$f":"SUM(D5:L5)","v":9999.9146872465699}]
[null,null,"Baseline - Part B fee schedule increase",{"$f":"SUM(Data!E11:E12,Data!E123:E124,Data!E152)","v":1004.9999999999999},{"$f":"SUM(Data!F11:F12,Data!F123:F124,Data!F152)","v":1010.0249999999997},{"$f":"SUM(Data!G11:G12,Data!G123:G124,Data!G152)","v":1010.0249999999997},{"$f":"SUM(Data!H11:H12,Data!H123:H124,Data!H152)","v":1010.0249999999997},{"$f":"SUM(Data!I11:I12,Data!I123:I124,Data!I152)","v":1010.0249999999997},{"$f":"SUM(Data!J11:J12,Data!J123:J124,Data!J152)","v":1010.0249999999997},{"$f":"SUM(Data!K11:K12,Data!K123:K124,Data!K152)","v":1010.0249999999997},{"$f":"SUM(Data!L11:L12,Data!L123:L124,Data!L152)","v":1010.0249999999997},{"$f":"SUM(Data!M11:M12,Data!M123:M124,Data!M152)","v":1012.5500624999997},9087.7250624999979]
[null,null,"Maximum MIPS adjustment",{"$f":"D6+SUM(Data!E14)","v":1004.9999999999999},{"$f":"E6+SUM(Data!F14)","v":1012.0450499999997},{"$f":"F6+SUM(Data!G14)","v":1016.0851499999998},{"$f":"G6+SUM(Data!H14)","v":1025.1753749999996},{"$f":"H6+SUM(Data!I14)","v":1100.9272499999997},{"$f":"I6+SUM(Data!J14)","v":1100.9272499999997},{"$f":"J6+SUM(Data!K14)","v":1100.9272499999997},{"$f":"K6+SUM(Data!L14)","v":1100.9272499999997},{"$f":"L6+SUM(Data!M14)","v":1103.6795681249998},9565.6941431249979]
[null,null,"Minimum MIPS adjustment",{"$f":"D6+SUM(Data!E13)","v":1004.9999999999999},{"$f":"E6+SUM(Data!F13)","v":969.6239999999998},{"$f":"F6+SUM(Data!G13)","v":959.52374999999972},{"$f":"G6+SUM(Data!H13)","v":939.3232499999998},{"$f":"H6+SUM(Data!I13)","v":919.12274999999977},{"$f":"I6+SUM(Data!J13)","v":919.12274999999977},{"$f":"J6+SUM(Data!K13)","v":919.12274999999977},{"$f":"K6+SUM(Data!L13)","v":919.12274999999977},{"$f":"L6+SUM(Data!M13)","v":921.42055687499976},8471.382556874998]
[null,null,"AAPM 5% Bonus",{"$f":"D6+Data!E17","v":1004.9999999999999},{"$f":"E6+Data!F17","v":1060.2749999999996},{"$f":"F6+Data!G17","v":1060.5262499999997},{"$f":"G6+Data!H17","v":1060.5262499999997},{"$f":"H6+Data!I17","v":1060.5262499999997},{"$f":"I6+Data!J17","v":1060.5262499999997},{"$f":"J6+Data!K17","v":1060.5262499999997},{"$f":"K6+Data!L17","v":1010.0249999999997},{"$f":"L6+Data!M17","v":1012.5500624999997},9390.4813125000001]
[null,null,"Actual MIPS",{"$f":"D6+Data!E25","v":1004.9999999999999},{"$f":"E6+Data!F25","v":1010.7538840206183},{"$f":"F6+Data!G25","v":1011.6648052941174},{"$f":"G6+Data!H25","v":1016.3015839285712},{"$f":"H6+Data!I25","v":1001.6922937499997},{"$f":"I6+Data!J25","v":1001.6922937499997},{"$f":"J6+Data!K25","v":1001.6922937499997},{"$f":"K6+Data!L25","v":1001.6922937499997},{"$f":"L6+Data!M25","v":1004.1965244843748},9054.6859727276787]
[null,null,"Actual AAPM",{"$f":"D6+Data!E26","v":1004.9999999999999},{"$f":"E6+Data!F26","v":1010.0249999999997},{"$f":"F6+Data!G26","v":1010.0249999999997},{"$f":"G6+Data!H26","v":1010.0249999999997},{"$f":"H6+Data!I26","v":1010.0249999999997},{"$f":"I6+Data!J26","v":1010.0249999999997},{"$f":"J6+Data!K26","v":1010.0249999999997},{"$f":"K6+Data!L26","v":1010.0249999999997},{"$f":"L6+Data!M26","v":1012.5500624999997},9087.7250624999979]
[]
[null,null,{"$f":"CDO_NAME &\"   Change in Margin in ( '000)\"","v":"0   Change in Margin in ( '000)"}]
[null,null,"Scenario: Difference from Baseline Cost (Overhead)",2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total"]
[null,null,"Baseline with Part B fee schedule",{"$f":"-(D$5-D6)","v":-16},-32.416000000000054,-54.30726100000004,-76.658238481000012,-99.478586489100849,{"$f":"-(I$5-I6)","v":-122.77816180537195},-146.56702820328462,-170.85546079555354,-193.12888797226015,-912.18962474657201]
["MAX MIPS",null,"Max MIPS adjustment",{"$f":"-(D$5-D7)","v":-16},-30.395950000000084,-48.247111000000018,-61.507863481000186,-8.5763364891008678,-31.87591180537197,-55.664778203284641,-79.953210795553559,-101.99938234726005,{"$f":"-(M$5-M7)","v":-434.22054412157195}]
["MIN MIPS",null,"Min MIPS adjustment",-16,-72.817000000000007,-104.80851100000007,-147.35998848099996,-190.38083648910083,-213.68041180537193,-237.4692782032846,-261.75771079555352,-284.25839359726012,{"$f":"-(M$5-M8)","v":-1528.5321303715718}]
["AAPM Fixed",null,"AAPM 5% Bonus",{"$f":"-(D$5-D9)","v":-16},17.833999999999833,-3.8060110000001259,-26.156988481000099,-48.977336489100935,-72.276911805372038,-96.065778203284708,-170.85546079555354,-193.12888797226015,-609.43337474656983]
["MIPS",null,"Actual MIPS",{"$f":"-(D$5-D10)","v":-16},-31.687115979381474,-52.667455705882389,-70.381654552428586,-107.81129273910085,-131.11086805537195,-154.89973445328462,-179.18816704555354,-201.48242598788511,-945.22871451889114]
["AAPM",null,"Actual AAPM",{"$f":"-(D$5-D11)","v":-16},-32.416000000000054,-54.30726100000004,-76.658238481000012,-99.478586489100849,-122.77816180537195,-146.56702820328462,-170.85546079555354,-193.12888797226015,-912.18962474657201]
[]
[null,null,{"$f":"CDO_NAME &\"   Revenue at Risk in ( '000)\"","v":"0   Revenue at Risk in ( '000)"}]
[null,null,"Scenario: Difference from Baseline with Part B Fee schedule",2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total"]
["MAX MIPS",null,"Max MIPS adjustment",{"$f":"-(D$6-D7)","v":0},2.0200499999999693,6.0601500000000215,15.150374999999826,90.902249999999981,90.902249999999981,90.902249999999981,90.902249999999981,91.129505625000093,477.96908062500006]
["MIN MIPS",null,"Min MIPS adjustment",{"$f":"-(D$6-D8)","v":0},-40.400999999999954,-50.501250000000027,-70.701749999999947,-90.902249999999981,-90.902249999999981,-90.902249999999981,-90.902249999999981,-91.129505624999979,-616.34250562499983]
["AAPM Fixed",null,"AAPM 5% Bonus",{"$f":"-(D$6-D9)","v":0},50.249999999999886,50.501249999999914,50.501249999999914,50.501249999999914,50.501249999999914,50.501249999999914,0,0,302.75625000000218]
["MIPS",null,"Actual MIPS",{"$f":"-(D$6-D10)","v":0},0.7288840206185796,1.6398052941176502,6.2765839285714264,-8.3327062500000011,-8.3327062500000011,-8.3327062500000011,-8.3327062500000011,-8.353538015624963,-33.03908977231913]
["AAPM",null,"Actual AAPM",{"$f":"-(D$6-D11)","v":0},0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,{"$f":"CDO_NAME &\"   Revenue in ( '000) - Shifting to QP APM Assumed\"","v":"0   Revenue in ( '000) - Shifting to QP APM Assumed"}]
[null,null,"Scenarios",2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total"]
[null,null,"Baseline Cost (Overhead)",{"$f":"D5","v":1020.9999999999999},1042.4409999999998,1064.3322609999998,1086.6832384809998,1109.5035864891006,1132.8031618053717,1156.5920282032844,1180.8804607955533,1205.6789504722599,{"$f":"SUM(D33:L33)","v":9999.9146872465699}]
[null,null,"Baseline - Part B fee schedule increase",{"$f":"SUM(Data!E18:E19,Data!E152,Data!E123:E124)","v":1004.9999999999999},{"$f":"SUM(Data!F18:F19,Data!F123:F124,Data!F152)","v":1010.0249999999997},{"$f":"SUM(Data!G18:G19,Data!G152,Data!G123:G124)","v":1010.0249999999997},{"$f":"SUM(Data!H18:H19,Data!H152,Data!H123:H124)","v":1010.0249999999997},{"$f":"SUM(Data!I18:I19,Data!I152,Data!I123:I124)","v":1010.0249999999997},{"$f":"SUM(Data!J18:J19,Data!J152,Data!J123:J124)","v":1010.0249999999997},{"$f":"SUM(Data!K18:K19,Data!K152,Data!K123:K124)","v":1010.0249999999997},{"$f":"SUM(Data!L18:L19,Data!L152,Data!L123:L124)","v":1010.0249999999997},{"$f":"SUM(Data!M18:M19,Data!M152,Data!M123:M124)","v":1012.5500624999997},{"$f":"SUM(D34:L34)","v":9087.7250624999979}]
[null,null,"Maximum MIPS adjustment",{"$f":"D34+SUM(Data!E21)","v":1004.9999999999999},{"$f":"E34+SUM(Data!F21)","v":1012.0450499999997},{"$f":"F34+SUM(Data!G21)","v":1016.0851499999998},{"$f":"G34+SUM(Data!H21)","v":1025.1753749999996},{"$f":"H34+SUM(Data!I21)","v":1100.9272499999997},{"$f":"I34+SUM(Data!J21)","v":1100.9272499999997},{"$f":"J34+SUM(Data!K21)","v":1100.9272499999997},{"$f":"K34+SUM(Data!L21)","v":1100.9272499999997},{"$f":"L34+SUM(Data!M21)","v":1103.6795681249998},{"$f":"SUM(D35:L35)","v":9565.6941431249979}]
[null,null,"Minimum MIPS adjustment",{"$f":"D34+SUM(Data!E20)","v":1004.9999999999999},{"$f":"E34+SUM(Data!F20)","v":969.6239999999998},{"$f":"F34+SUM(Data!G20)","v":959.52374999999972},{"$f":"G34+SUM(Data!H20)","v":939.3232499999998},{"$f":"H34+SUM(Data!I20)","v":919.12274999999977},{"$f":"I34+SUM(Data!J20)","v":919.12274999999977},{"$f":"J34+SUM(Data!K20)","v":919.12274999999977},{"$f":"K34+SUM(Data!L20)","v":919.12274999999977},{"$f":"L34+SUM(Data!M20)","v":921.42055687499976},{"$f":"SUM(D36:L36)","v":8471.382556874998}]
[null,null,"AAPM 5% Bonus",{"$f":"D34+Data!E24","v":1004.9999999999999},{"$f":"E34+Data!F24","v":1060.2749999999996},{"$f":"F34+Data!G24","v":1060.5262499999997},{"$f":"G34+Data!H24","v":1060.5262499999997},{"$f":"H34+Data!I24","v":1060.5262499999997},{"$f":"I34+Data!J24","v":1060.5262499999997},{"$f":"J34+Data!K24","v":1060.5262499999997},{"$f":"K34+Data!L24","v":1010.0249999999997},{"$f":"L34+Data!M24","v":1012.5500624999997},{"$f":"M34+Data!N24","v":9087.7250624999979}]
[null,null,"Actual MIPS",{"$f":"D34+Data!E27","v":1004.9999999999999},{"$f":"E34+Data!F27","v":1010.7538840206183},{"$f":"F34+Data!G27","v":1011.6648052941174},{"$f":"G34+Data!H27","v":1010.0249999999997},{"$f":"H34+Data!I27","v":1010.0249999999997},{"$f":"I34+Data!J27","v":1010.0249999999997},{"$f":"J34+Data!K27","v":1010.0249999999997},{"$f":"K34+Data!L27","v":1010.0249999999997},{"$f":"L34+Data!M27","v":1012.5500624999997},{"$f":"M33+Data!N27","v":9999.9146872465699}]
[null,null,"Actual AAPM",{"$f":"D34+Data!E28","v":1004.9999999999999},{"$f":"E34+Data!F28","v":1010.0249999999997},{"$f":"F34+Data!G28","v":1010.0249999999997},{"$f":"G34+Data!H28","v":1060.5262499999997},{"$f":"H34+Data!I28","v":1060.5262499999997},{"$f":"I34+Data!J28","v":1060.5262499999997},{"$f":"J34+Data!K28","v":1060.5262499999997},{"$f":"K34+Data!L28","v":1010.0249999999997},{"$f":"L34+Data!M28","v":1012.5500624999997},{"$f":"M34+Data!N28","v":9087.7250624999979}]
[]
[null,null,{"$f":"CDO_NAME &\"   Change in Margin in ( '000) - Shifting to QP APM Assumed\"","v":"0   Change in Margin in ( '000) - Shifting to QP APM Assumed"}]
[null,null,"Scenario: Difference from Baseline Cost (Overhead)",2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total"]
[null,null,"Baseline with Part B fee schedule",{"$f":"-(D$33-D34)","v":-16},-32.416000000000054,-54.30726100000004,-76.658238481000012,-99.478586489100849,-122.77816180537195,-146.56702820328462,-170.85546079555354,-193.12888797226015,-912.18962474657201]
["MAX MIPS",null,"Max MIPS adjustment",{"$f":"-(D$33-D35)","v":-16},-30.395950000000084,-48.247111000000018,-61.507863481000186,-8.5763364891008678,-31.87591180537197,-55.664778203284641,-79.953210795553559,-101.99938234726005,-434.22054412157195]
["MIN MIPS",null,"Min MIPS adjustment",{"$f":"-(D$33-D36)","v":-16},-72.817000000000007,-104.80851100000007,-147.35998848099996,-190.38083648910083,-213.68041180537193,-237.4692782032846,-261.75771079555352,-284.25839359726012,-1528.5321303715718]
["AAPM Fixed",null,"AAPM 5% Bonus",{"$f":"-(D$33-D37)","v":-16},17.833999999999833,-3.8060110000001259,-26.156988481000099,-48.977336489100935,-72.276911805372038,-96.065778203284708,-170.85546079555354,-193.12888797226015,-912.18962474657201]
["MIPS",null,"Actual MIPS",{"$f":"-(D$33-D38)","v":-16},-31.687115979381474,-52.667455705882389,-76.658238481000012,-99.478586489100849,-122.77816180537195,-146.56702820328462,-170.85546079555354,-193.12888797226015,0]
["AAPM",null,"Actual AAPM",{"$f":"-(D$33-D39)","v":-16},-32.416000000000054,-54.30726100000004,-26.156988481000099,-48.977336489100935,-72.276911805372038,-96.065778203284708,-170.85546079555354,-193.12888797226015,-912.18962474657201]
[]
[null,null,{"$f":"CDO_NAME &\"  Revenue at Risk in ( '000) - Shifting to QP APM Assumed\"","v":"0  Revenue at Risk in ( '000) - Shifting to QP APM Assumed"}]
[null,null,"Scenario: Difference from Baseline with Part B Fee schedule",2018,2019,2020,2021,2022,2023,2024,2025,2026,"Total"]
["MAX MIPS",null,"Max MIPS adjustment",{"$f":"-(D$34-D35)","v":0},{"$f":"-(E$34-E35)","v":2.0200499999999693},6.0601500000000215,15.150374999999826,90.902249999999981,90.902249999999981,90.902249999999981,90.902249999999981,91.129505625000093,477.96908062500006]
["MIN MIPS",null,"Min MIPS adjustment",{"$f":"-(D$34-D36)","v":0},-40.400999999999954,-50.501250000000027,-70.701749999999947,-90.902249999999981,-90.902249999999981,-90.902249999999981,-90.902249999999981,-91.129505624999979,-616.34250562499983]
["AAPM Fixed",null,"AAPM 5% Bonus",{"$f":"-(D$34-D37)","v":0},50.249999999999886,50.501249999999914,50.501249999999914,50.501249999999914,50.501249999999914,50.501249999999914,0,0,0]
["MIPS",null,"Actual MIPS",{"$f":"-(D$34-D38)","v":0},0.7288840206185796,1.6398052941176502,0,0,0,0,0,0,912.18962474657201]
["AAPM",null,"Actual AAPM",{"$f":"-(D$34-D39)","v":0},0,0,50.501249999999914,50.501249999999914,50.501249999999914,50.501249999999914,0,0,0]

{"sheet":"Charts_Rev & Margin","index":9,"n_rows":38,"n_cols":74,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,19],[0,1,0,19]]}
[null,"MACRA/QPP - Provider Revenue Model - Revenue and Margin Graphs"]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"With No Shifting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Graphs should show 6 individual years"]
[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,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,null,"Medicare FFS Beneficiaries only - line graphs",null,"baseline mips, max mips, min mips, AAPM, Expected MACRA Rev"]
[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,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,null,"Total (Medicare pluls other) - - line graphs",null,"Non Medicare"]
[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,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,null,"Margin erosion graph - column graph"]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Clinician Entity Revenue -FFS",2018,2019,2020,2021,2022,2023,2024,2025,2026,null,"Clinician Entity Revenue -FFS",2018,2019,2020,2021,2022,2023,2024,2025,2026]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Revenue - Baseline",{"$f":"SUM(Data!E11:E12)*1000","v":1004999.9999999999},{"$f":"SUM(Data!F11:F12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!G11:G12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!H11:H12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!I11:I12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!J11:J12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!K11:K12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!L11:L12)*1000","v":1010024.9999999998},{"$f":"SUM(Data!M11:M12)*1000","v":1012550.0624999998},null,"FFS Revenue - Baseline",{"$f":"SUM(Data!E18:E19)*1000","v":1004999.9999999999},{"$f":"SUM(Data!F18:F19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!G18:G19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!H18:H19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!I18:I19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!J18:J19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!K18:K19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!L18:L19)*1000","v":1010024.9999999998},{"$f":"SUM(Data!M18:M19)*1000","v":1012550.0624999998}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"chart 3 & chart 4",null,null,null,"FFS Revenue - Maximum MIPS",{"$f":"BB8+(Data!E14*1000)","v":1004999.9999999999},{"$f":"BC8+(Data!F14*1000)","v":1012045.0499999998},{"$f":"BD8+(Data!G14*1000)","v":1016085.1499999998},{"$f":"BE8+(Data!H14*1000)","v":1025175.3749999997},{"$f":"BF8+(Data!I14*1000)","v":1100927.2499999998},{"$f":"BG8+(Data!J14*1000)","v":1100927.2499999998},{"$f":"BH8+(Data!K14*1000)","v":1100927.2499999998},{"$f":"BI8+(Data!L14*1000)","v":1100927.2499999998},{"$f":"BJ8+(Data!M14*1000)","v":1103679.5681249998},null,"FFS Revenue - Maximum MIPS",{"$f":"BM8+(Data!E21*1000)","v":1004999.9999999999},{"$f":"BN8+(Data!F21*1000)","v":1012045.0499999998},{"$f":"BO8+(Data!G21*1000)","v":1016085.1499999998},{"$f":"BP8+(Data!H21*1000)","v":1025175.3749999997},{"$f":"BQ8+(Data!I21*1000)","v":1100927.2499999998},{"$f":"BR8+(Data!J21*1000)","v":1100927.2499999998},{"$f":"BS8+(Data!K21*1000)","v":1100927.2499999998},{"$f":"BT8+(Data!L21*1000)","v":1100927.2499999998},{"$f":"BU8+(Data!M21*1000)","v":1103679.5681249998}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"min:",{"$f":"ROUNDDOWN(MIN(BB8:BU12),-6)","v":0},null,null,"FFS Revenue - Minimum MIPS",{"$f":"BB8+(Data!E13*1000)","v":1004999.9999999999},{"$f":"BC8+(Data!F13*1000)","v":969623.99999999977},{"$f":"BD8+(Data!G13*1000)","v":959523.74999999977},{"$f":"BE8+(Data!H13*1000)","v":939323.24999999977},{"$f":"BF8+(Data!I13*1000)","v":919122.74999999977},{"$f":"BG8+(Data!J13*1000)","v":919122.74999999977},{"$f":"BH8+(Data!K13*1000)","v":919122.74999999977},{"$f":"BI8+(Data!L13*1000)","v":919122.74999999977},{"$f":"BJ8+(Data!M13*1000)","v":921420.55687499978},null,"FFS Revenue - Minmum MIPS",{"$f":"BM8+(Data!E20*1000)","v":1004999.9999999999},{"$f":"BN8+(Data!F13*1000)","v":969623.99999999977},{"$f":"BO8+(Data!G13*1000)","v":959523.74999999977},{"$f":"BP8+(Data!H13*1000)","v":939323.24999999977},{"$f":"BQ8+(Data!I13*1000)","v":919122.74999999977},{"$f":"BR8+(Data!J13*1000)","v":919122.74999999977},{"$f":"BS8+(Data!K13*1000)","v":919122.74999999977},{"$f":"BT8+(Data!L13*1000)","v":919122.74999999977},{"$f":"BU8+(Data!M13*1000)","v":921420.55687499978}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"max:",{"$f":"ROUNDUP(MAX(BB8:BU12),-6)","v":2000000},null,null,"FFS Revenue - AAPM ",{"$f":"BB8+(Data!E17*1000)","v":1004999.9999999999},{"$f":"BC8+(Data!F17*1000)","v":1060274.9999999998},{"$f":"BD8+(Data!G17*1000)","v":1060526.2499999998},{"$f":"BE8+(Data!H17*1000)","v":1060526.2499999998},{"$f":"BF8+(Data!I17*1000)","v":1060526.2499999998},{"$f":"BG8+(Data!J17*1000)","v":1060526.2499999998},{"$f":"BH8+(Data!K17*1000)","v":1060526.2499999998},{"$f":"BI8+(Data!L17*1000)","v":1010024.9999999998},{"$f":"BJ8+(Data!M17*1000)","v":1012550.0624999998},null,"FFS Revenue - AAPM ",{"$f":"BM8+(Data!E24*1000)","v":1004999.9999999999},{"$f":"BN8+(Data!F24*1000)","v":1060274.9999999998},{"$f":"BO8+(Data!G24*1000)","v":1060526.2499999998},{"$f":"BP8+(Data!H24*1000)","v":1060526.2499999998},{"$f":"BQ8+(Data!I24*1000)","v":1060526.2499999998},{"$f":"BR8+(Data!J24*1000)","v":1060526.2499999998},{"$f":"BS8+(Data!K24*1000)","v":1060526.2499999998},{"$f":"BT8+(Data!L24*1000)","v":1010024.9999999998},{"$f":"BU8+(Data!M24*1000)","v":1012550.0624999998}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Revenue - Expected Performance (Baseline)",{"$f":"BB8+(SUM(Data!E25:E26)*1000)","v":1004999.9999999999},{"$f":"BC8+(SUM(Data!F25:F26)*1000)","v":1010753.8840206183},{"$f":"BD8+(SUM(Data!G25:G26)*1000)","v":1011664.8052941174},{"$f":"BE8+(SUM(Data!H25:H26)*1000)","v":1016301.5839285712},{"$f":"BF8+(SUM(Data!I25:I26)*1000)","v":1001692.2937499997},{"$f":"BG8+(SUM(Data!J25:J26)*1000)","v":1001692.2937499997},{"$f":"BH8+(SUM(Data!K25:K26)*1000)","v":1001692.2937499997},{"$f":"BI8+(SUM(Data!L25:L26)*1000)","v":1001692.2937499997},{"$f":"BJ8+(SUM(Data!M25:M26)*1000)","v":1004196.5244843748},null,"FFS Revenue - Expected Performance (Shift)",{"$f":"BM8+(SUM(Data!E27:E28)*1000)","v":1004999.9999999999},{"$f":"BN8+(SUM(Data!F27:F28)*1000)","v":1010753.8840206183},{"$f":"BO8+(SUM(Data!G27:G28)*1000)","v":1011664.8052941174},{"$f":"BP8+(SUM(Data!H27:H28)*1000)","v":1060526.2499999998},{"$f":"BQ8+(SUM(Data!I27:I28)*1000)","v":1060526.2499999998},{"$f":"BR8+(SUM(Data!J27:J28)*1000)","v":1060526.2499999998},{"$f":"BS8+(SUM(Data!K27:K28)*1000)","v":1060526.2499999998},{"$f":"BT8+(SUM(Data!L27:L28)*1000)","v":1010024.9999999998},{"$f":"BU8+(SUM(Data!M27:M28)*1000)","v":1012550.0624999998}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Revenue - Baseline",{"$f":"BB8+(SUM(Data!E123:E124,Data!E152:E153)*1000)","v":1004999.9999999999},{"$f":"BC8+(SUM(Data!F123:F124,Data!F152:F153)*1000)","v":1010024.9999999998},{"$f":"BD8+(SUM(Data!G123:G124,Data!G152:G153)*1000)","v":1010024.9999999998},{"$f":"BE8+(SUM(Data!H123:H124,Data!H152:H153)*1000)","v":1010024.9999999998},{"$f":"BF8+(SUM(Data!I123:I124,Data!I152:I153)*1000)","v":1010024.9999999998},{"$f":"BG8+(SUM(Data!J123:J124,Data!J152:J153)*1000)","v":1010024.9999999998},{"$f":"BH8+(SUM(Data!K123:K124,Data!K152:K153)*1000)","v":1010024.9999999998},{"$f":"BI8+(SUM(Data!L123:L124,Data!L152:L153)*1000)","v":1010024.9999999998},{"$f":"BJ8+(SUM(Data!M123:M124,Data!M152:M153)*1000)","v":1012550.0624999998},null,"Total Revenue - Baseline",{"$f":"BM8+(SUM(Data!E125:E126,Data!E154:E155)*1000)","v":1004999.9999999999},{"$f":"BN8+(SUM(Data!F125:F126,Data!F154:F155)*1000)","v":1010024.9999999998},{"$f":"BO8+(SUM(Data!G125:G126,Data!G154:G155)*1000)","v":1010024.9999999998},{"$f":"BP8+(SUM(Data!H125:H126,Data!H154:H155)*1000)","v":1010024.9999999998},{"$f":"BQ8+(SUM(Data!I125:I126,Data!I154:I155)*1000)","v":1010024.9999999998},{"$f":"BR8+(SUM(Data!J125:J126,Data!J154:J155)*1000)","v":1010024.9999999998},{"$f":"BS8+(SUM(Data!K125:K126,Data!K154:K155)*1000)","v":1010024.9999999998},{"$f":"BT8+(SUM(Data!L125:L126,Data!L154:L155)*1000)","v":1010024.9999999998},{"$f":"BU8+(SUM(Data!M125:M126,Data!M154:M155)*1000)","v":1012550.0624999998}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"chart 5 & chart 6",null,null,null,"Total Revenue - Maximum MIPS",{"$f":"(BB$13-BB$8)+BB9","v":1004999.9999999999},1012045.0499999998,1016085.1499999998,1025175.3749999997,1100927.2499999998,{"$f":"(BG$13-BG$8)+BG9","v":1100927.2499999998},1100927.2499999998,1100927.2499999998,1103679.5681249998,null,"Total Revenue - Maximum MIPS",{"$f":"(BM$13-BM$8)+BM9","v":1004999.9999999999},1012045.0499999998,1016085.1499999998,1025175.3749999997,1100927.2499999998,{"$f":"(BR$13-BR$8)+BR9","v":1100927.2499999998},1100927.2499999998,1100927.2499999998,1103679.5681249998]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"min:",{"$f":"ROUNDDOWN(MIN(BB13:BU17),-6)","v":0},null,null,"Total Revenue - Minimum MIPS",1004999.9999999999,969623.99999999977,959523.74999999977,939323.24999999977,919122.74999999977,{"$f":"(BG$13-BG$8)+BG10","v":919122.74999999977},919122.74999999977,919122.74999999977,921420.55687499978,null,"Total Revenue - Minmum MIPS",1004999.9999999999,969623.99999999977,959523.74999999977,939323.24999999977,919122.74999999977,{"$f":"(BR$13-BR$8)+BR10","v":919122.74999999977},919122.74999999977,919122.74999999977,921420.55687499978]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,"max:",{"$f":"ROUNDUP(MAX(BB13:BU17),-6)","v":2000000},null,null,"Total Revenue - AAPM",1004999.9999999999,1060274.9999999998,1060526.2499999998,1060526.2499999998,1060526.2499999998,{"$f":"(BG$13-BG$8)+BG11","v":1060526.2499999998},1060526.2499999998,1010024.9999999998,1012550.0624999998,null,"Total Revenue - AAPM ",1004999.9999999999,1060274.9999999998,1060526.2499999998,1060526.2499999998,1060526.2499999998,{"$f":"(BR$13-BR$8)+BR11","v":1060526.2499999998},1060526.2499999998,1010024.9999999998,1012550.0624999998]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Revenue - Expected Performance (Baseline)",1004999.9999999999,1010753.8840206183,1011664.8052941174,1016301.5839285712,1001692.2937499997,{"$f":"(BG$13-BG$8)+BG12","v":1001692.2937499997},1001692.2937499997,1001692.2937499997,1004196.5244843748,null,"Total Revenue - Expected Performance (Shift)",1004999.9999999999,1010753.8840206183,1011664.8052941174,1060526.2499999998,{"$f":"(BQ$13-BQ$8)+BQ12","v":1060526.2499999998},{"$f":"(BR$13-BR$8)+BR12","v":1060526.2499999998},1060526.2499999998,1010024.9999999998,1012550.0624999998]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Baseline Cost  ",{"$f":"SUM(Data!E7:E8)*1000","v":1020999.9999999999},{"$f":"SUM(Data!F7:F8)*1000","v":1042440.9999999998},{"$f":"SUM(Data!G7:G8)*1000","v":1064332.2609999997},{"$f":"SUM(Data!H7:H8)*1000","v":1086683.2384809998},{"$f":"SUM(Data!I7:I8)*1000","v":1109503.5864891007},{"$f":"SUM(Data!J7:J8)*1000","v":1132803.1618053718},{"$f":"SUM(Data!K7:K8)*1000","v":1156592.0282032844},{"$f":"SUM(Data!L7:L8)*1000","v":1180880.4607955534},{"$f":"SUM(Data!M7:M8)*1000","v":1205678.9504722599},null,"FFS Baseline Cost  ",{"$f":"BB20","v":1020999.9999999999},{"$f":"BC20","v":1042440.9999999998},{"$f":"BD20","v":1064332.2609999997},{"$f":"BE20","v":1086683.2384809998},{"$f":"BF20","v":1109503.5864891007},{"$f":"BG20","v":1132803.1618053718},{"$f":"BH20","v":1156592.0282032844},{"$f":"BI20","v":1180880.4607955534},{"$f":"BJ20","v":1205678.9504722599}]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Baseline Cost",{"$f":"'Revenue at Risk Summary'!D5*1000","v":1020999.9999999999},{"$f":"'Revenue at Risk Summary'!E5*1000","v":1042440.9999999998},{"$f":"'Revenue at Risk Summary'!F5*1000","v":1064332.2609999997},{"$f":"'Revenue at Risk Summary'!G5*1000","v":1086683.2384809998},{"$f":"'Revenue at Risk Summary'!H5*1000","v":1109503.5864891007},{"$f":"'Revenue at Risk Summary'!I5*1000","v":1132803.1618053718},{"$f":"'Revenue at Risk Summary'!J5*1000","v":1156592.0282032844},{"$f":"'Revenue at Risk Summary'!K5*1000","v":1180880.4607955534},{"$f":"'Revenue at Risk Summary'!L5*1000","v":1205678.9504722599},null,"Total Baseline Cost",1020999.9999999999,1042440.9999999998,1064332.2609999997,1086683.2384809998,1109503.5864891007,1132803.1618053718,1156592.0282032844,1180880.4607955534,1205678.9504722599]
[]
[]
[]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Margin - Baseline",{"$f":"(BB8-BB$20)/BB$20","v":-1.5670910871694418E-2},-3.109624429584025E-2,-5.1024725069383152E-2,-7.0543315445037488E-2,-8.9660446077411735E-2,-0.10838437421881653,-0.12672318728581428,-0.14468480635241365,-0.16018268204534239,null,"FFS Margin - Baseline",{"$f":"(BM8-BM$20)/BM$20","v":-1.5670910871694418E-2},-3.109624429584025E-2,-5.1024725069383152E-2,-7.0543315445037488E-2,-8.9660446077411735E-2,{"$f":"(BR8-BR$20)/BR$20","v":-0.10838437421881653},-0.12672318728581428,-0.14468480635241365,-0.16018268204534239]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Margin - Maximum MIPS",{"$f":"(BB9-BB$20)/BB$20","v":-1.5670910871694418E-2},-2.9158436784431887E-2,-4.5330873419799432E-2,-5.6601465176713148E-2,-7.7298862243787717E-3,{"$f":"(BG9-BG$20)/BG$20","v":-2.813896789851E-2},-4.8128274141537551E-2,-6.7706438924130849E-2,-8.4599123429423204E-2,null,"FFS Margin - Maximum MIPS",{"$f":"(BM9-BM$20)/BM$20","v":-1.5670910871694418E-2},-2.9158436784431887E-2,-4.5330873419799432E-2,-5.6601465176713148E-2,-7.7298862243787717E-3,{"$f":"(BR9-BR$20)/BR$20","v":-2.813896789851E-2},-4.8128274141537551E-2,-6.7706438924130849E-2,-8.4599123429423204E-2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Margin - Minimum MIPS",-1.5670910871694418E-2,-6.9852394524006656E-2,-9.8473488815914015E-2,-0.13560528336388489,-0.17159100593044468,-0.18862978053912308,-0.20531810043009102,-0.22166317378069644,-0.23576624066126159,null,"FFS Margin - Minmum MIPS",-1.5670910871694418E-2,-6.9852394524006656E-2,-9.8473488815914015E-2,-0.13560528336388489,-0.17159100593044468,{"$f":"(BR10-BR$20)/BR$20","v":-0.18862978053912308},-0.20531810043009102,-0.22166317378069644,-0.23576624066126159]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Margin - AAPM ",-1.5670910871694418E-2,1.7107922654615471E-2,-3.5759613228523021E-3,-2.4070481217289347E-2,-4.4143468381282309E-2,-6.3803592929757347E-2,-8.305934665010499E-2,-0.14468480635241365,-0.16018268204534239,null,"FFS Margin - AAPM ",-1.5670910871694418E-2,1.7107922654615471E-2,-3.5759613228523021E-3,-2.4070481217289347E-2,-4.4143468381282309E-2,{"$f":"(BR11-BR$20)/BR$20","v":-6.3803592929757347E-2},-8.305934665010499E-2,-0.14468480635241365,-0.16018268204534239]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FFS Margin - Expected Performance (Baseline)",-1.5670910871694418E-2,-3.0397035399971312E-2,-4.9484035799495792E-2,-6.4767406048160212E-2,-9.7170747397273133E-2,-0.11574020313151134,-0.13392772099070635,-0.15174115670000626,-0.1671111749184683,null,"FFS Margin - Expected Performance (Shift)",-1.5670910871694418E-2,-3.0397035399971312E-2,-4.9484035799495792E-2,-2.4070481217289347E-2,-4.4143468381282309E-2,{"$f":"(BR12-BR$20)/BR$20","v":-6.3803592929757347E-2},-8.305934665010499E-2,-0.14468480635241365,-0.16018268204534239]
[]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026,null,null,2018,2019,2020,2021,2022,2023,2024,2025,2026]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Margin - Baseline",{"$f":"(BB13-BB$21)/BB$21","v":-1.5670910871694418E-2},-3.109624429584025E-2,-5.1024725069383152E-2,-7.0543315445037488E-2,-8.9660446077411735E-2,-0.10838437421881653,-0.12672318728581428,-0.14468480635241365,-0.16018268204534239,null,"Total Margin - Baseline MIPS",{"$f":"(BM13-BM$21)/BM$21","v":-1.5670910871694418E-2},-3.109624429584025E-2,-5.1024725069383152E-2,-7.0543315445037488E-2,-8.9660446077411735E-2,{"$f":"(BR13-BR$21)/BR$21","v":-0.10838437421881653},-0.12672318728581428,-0.14468480635241365,-0.16018268204534239]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Margin - Maximum MIPS",{"$f":"(BB14-BB$21)/BB$21","v":-1.5670910871694418E-2},-2.9158436784431887E-2,-4.5330873419799432E-2,-5.6601465176713148E-2,-7.7298862243787717E-3,{"$f":"(BG14-BG$21)/BG$21","v":-2.813896789851E-2},-4.8128274141537551E-2,-6.7706438924130849E-2,-8.4599123429423204E-2,null,"Total Margin - Maximum MIPS",{"$f":"(BM14-BM$21)/BM$21","v":-1.5670910871694418E-2},-2.9158436784431887E-2,-4.5330873419799432E-2,-5.6601465176713148E-2,-7.7298862243787717E-3,{"$f":"(BR14-BR$21)/BR$21","v":-2.813896789851E-2},-4.8128274141537551E-2,-6.7706438924130849E-2,-8.4599123429423204E-2]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Margin - Minimum MIPS",-1.5670910871694418E-2,-6.9852394524006656E-2,-9.8473488815914015E-2,-0.13560528336388489,-0.17159100593044468,-0.18862978053912308,-0.20531810043009102,-0.22166317378069644,-0.23576624066126159,null,"Total Margin - Minmum MIPS",-1.5670910871694418E-2,-6.9852394524006656E-2,-9.8473488815914015E-2,-0.13560528336388489,-0.17159100593044468,{"$f":"(BR15-BR$21)/BR$21","v":-0.18862978053912308},-0.20531810043009102,-0.22166317378069644,-0.23576624066126159]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Margin - AAPM",-1.5670910871694418E-2,1.7107922654615471E-2,-3.5759613228523021E-3,-2.4070481217289347E-2,-4.4143468381282309E-2,-6.3803592929757347E-2,-8.305934665010499E-2,-0.14468480635241365,-0.16018268204534239,null,"Total Margin - AAPM",-1.5670910871694418E-2,1.7107922654615471E-2,-3.5759613228523021E-3,-2.4070481217289347E-2,-4.4143468381282309E-2,{"$f":"(BR16-BR$21)/BR$21","v":-6.3803592929757347E-2},-8.305934665010499E-2,-0.14468480635241365,-0.16018268204534239]
[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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Margin - Expected Performance (Baseline)",-1.5670910871694418E-2,-3.0397035399971312E-2,-4.9484035799495792E-2,-6.4767406048160212E-2,-9.7170747397273133E-2,-0.11574020313151134,-0.13392772099070635,-0.15174115670000626,-0.1671111749184683,null,"Total Margin - Expected Performance (Shift)",-1.5670910871694418E-2,-3.0397035399971312E-2,-4.9484035799495792E-2,-2.4070481217289347E-2,-4.4143468381282309E-2,{"$f":"(BR17-BR$21)/BR$21","v":-6.3803592929757347E-2},-8.305934665010499E-2,-0.14468480635241365,-0.16018268204534239]

{"sheet":"Charts_Performance","index":10,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,20]]}
[null,"MACRA/QPP - Provider Revenue Model - Revenue at Risk"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,{"$f":"ROUND(MAX('Revenue at Risk Summary'!D55:L56,'Revenue at Risk Summary'!D27:L28),-2)","v":100}]

{"sheet":"Lookups for charts_WS2","index":11,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
[null,null,"With Shifting",null,null,null,null,null,null,null,"With No Shifting"]
[null,null,2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,null,2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,null,{"$f":"Data!E6+Data!E122+Data!E151","v":1000},{"$f":"Data!F6+Data!F122+Data!F151","v":1000},{"$f":"Data!G6+Data!G122+Data!G151","v":1000},{"$f":"SUM(C3:E3)","v":3000},{"$f":"SUM(Data!H6:J6,Data!H122:J122,Data!H151:J151)","v":3000},{"$f":"F3+G3","v":6000},null,null,{"$f":"Data!E5+Data!E121+Data!E150","v":1000},{"$f":"Data!F5+Data!F121+Data!F150","v":1000},{"$f":"Data!G5+Data!G121+Data!G150","v":1000},{"$f":"SUM(K3:M3)","v":3000},{"$f":"SUM(Data!H5:J5,Data!H121:J121,Data!H150:J150)","v":3000},{"$f":"N3+O3","v":6000}]
[]
[]
[null,"CDO revenue",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"CDO revenue",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Revenue -CPI",{"$f":"'Revenue at Risk Summary'!D33*1000","v":1020999.9999999999},{"$f":"'Revenue at Risk Summary'!E33*1000","v":1042440.9999999998},{"$f":"'Revenue at Risk Summary'!F33*1000","v":1064332.2609999997},{"$f":"SUM(C7:E7)","v":3127773.260999999},{"$f":"SUM('Revenue at Risk Summary'!G33:I33)*1000","v":3328989.9867754718},{"$f":"SUM(F7,G7)","v":6456763.2477754708},null,"Revenue -CPI",{"$f":"'Revenue at Risk Summary'!D5*1000","v":1020999.9999999999},{"$f":"'Revenue at Risk Summary'!E5*1000","v":1042440.9999999998},{"$f":"'Revenue at Risk Summary'!F5*1000","v":1064332.2609999997},{"$f":"SUM(K7:M7)","v":3127773.260999999},{"$f":"SUM('Revenue at Risk Summary'!G5:I5)*1000","v":3328989.9867754718},{"$f":"N7+O7","v":6456763.2477754708}]
[null,"Revenue - FFS Update w/o Quality Bonus",{"$f":"'Revenue at Risk Summary'!D34*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E34*1000","v":1010024.9999999998},{"$f":"'Revenue at Risk Summary'!F34*1000","v":1010024.9999999998},{"$f":"SUM(C8:E8)","v":3025049.9999999991},{"$f":"SUM('Revenue at Risk Summary'!G34:I34)*1000","v":3030074.9999999995},{"$f":"SUM(F8,G8)","v":6055124.9999999981},null,"Revenue - FFS Update w/o Quality Bonus",{"$f":"'Revenue at Risk Summary'!D6*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E6*1000","v":1010024.9999999998},{"$f":"'Revenue at Risk Summary'!F6*1000","v":1010024.9999999998},{"$f":"SUM(K8:M8)","v":3025049.9999999991},{"$f":"SUM('Revenue at Risk Summary'!G6:I6)*1000","v":3030074.9999999995},6055124.9999999981]
[null,"Revenue - FFS + MIPS Adj",{"$f":"'Revenue at Risk Summary'!D38*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E38*1000","v":1010753.8840206183},{"$f":"'Revenue at Risk Summary'!F38*1000","v":1011664.8052941174},{"$f":"SUM(C9:E9)","v":3027418.6893147356},{"$f":"SUM('Revenue at Risk Summary'!G38:I38)*1000","v":3030074.9999999995},{"$f":"SUM(F9,G9)","v":6057493.6893147351},null,"Revenue - FFS + MIPS Adj",{"$f":"'Revenue at Risk Summary'!D10*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E10*1000","v":1010753.8840206183},{"$f":"'Revenue at Risk Summary'!F10*1000","v":1011664.8052941174},{"$f":"SUM(K9:M9)","v":3027418.6893147356},{"$f":"SUM('Revenue at Risk Summary'!G10:I10)*1000","v":3019686.1714285705},6047104.8607433066]
[null,"Revenue - MIPS + APM",{"$f":"'Revenue at Risk Summary'!D39*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E39*1000","v":1010024.9999999998},{"$f":"'Revenue at Risk Summary'!F39*1000","v":1010024.9999999998},{"$f":"SUM(C10:E10)","v":3025049.9999999991},{"$f":"SUM('Revenue at Risk Summary'!G39:I39)*1000","v":3181578.7499999986},{"$f":"SUM(F10,G10)","v":6206628.7499999981},null,"Revenue - MIPS + APM",{"$f":"'Revenue at Risk Summary'!D11*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E11*1000","v":1010024.9999999998},{"$f":"'Revenue at Risk Summary'!F11*1000","v":1010024.9999999998},{"$f":"SUM(K10:M10)","v":3025049.9999999991},{"$f":"SUM('Revenue at Risk Summary'!G11:I11)*1000","v":3030074.9999999995},6055124.9999999981]
[]
[]
[null,"CDO-Revenue Per Clinician",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"CDO-Revenue Per Clinician",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Revenue -CPI",null,null,null,null,null,null,null,"Revenue -CPI"]
[null,"Revenue - FFS Update w/o Quality Bonus",null,null,null,null,null,null,null,"Revenue - FFS Update w/o Quality Bonus"]
[null,"Revenue - FFS + MIPS Adj",null,null,null,null,null,null,null,"Revenue - FFS + MIPS Adj"]
[null,"Revenue - MIPS + APM",null,null,null,null,null,null,null,"Revenue - MIPS + APM"]
[]
[]
[null,"CDO - Revenue Per Capita",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"CDO - Revenue Per Capita",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Revenue -CPI",{"$f":"C7/C$3","v":1020.9999999999999},1042.4409999999998,1064.3322609999998,1042.5910869999996,1109.6633289251572,1076.1272079625785,null,"Revenue -CPI",{"$f":"K7/K$3","v":1020.9999999999999},1042.4409999999998,1064.3322609999998,1042.5910869999996,1109.6633289251572,1076.1272079625785]
[null,"Revenue - FFS Update w/o Quality Bonus",1004.9999999999999,1010.0249999999997,1010.0249999999997,1008.3499999999997,1010.0249999999999,1009.1874999999997,null,"Revenue - FFS Update w/o Quality Bonus",{"$f":"K8/K$3","v":1004.9999999999999},1010.0249999999997,1010.0249999999997,1008.3499999999997,1010.0249999999999,1009.1874999999997]
[null,"Revenue - FFS + MIPS Adj",1004.9999999999999,1010.7538840206183,1011.6648052941174,1009.1395631049119,1010.0249999999999,1009.5822815524558,null,"Revenue - FFS + MIPS Adj",{"$f":"K9/K$3","v":1004.9999999999999},1010.7538840206183,1011.6648052941174,1009.1395631049119,1006.5620571428568,1007.8508101238845]
[null,"Revenue - MIPS + APM",1004.9999999999999,1010.0249999999997,1010.0249999999997,1008.3499999999997,1060.5262499999994,1034.4381249999997,null,"Revenue - MIPS + APM",{"$f":"K10/K$3","v":1004.9999999999999},1010.0249999999997,1010.0249999999997,1008.3499999999997,1010.0249999999999,1009.1874999999997]
[]
[null,"Revenue at Risk - Per clinician",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"Revenue at Risk - Per clinician",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Baseline MIPS less MIPS",null,null,null,null,null,null,null,"Baseline MIPS less MIPS"]
[null,"Baseline MIPS less MIPS + AAPM",null,null,null,null,null,null,null,"Baseline MIPS less MIPS + AAPM"]

{"sheet":"Lookups for charts_WS1","index":12,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,null,"With Shifting",null,null,null,null,null,null,null,"With No Shifting"]
[null,null,2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,null,2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,null,{"$f":"Data!E6+Data!E122+Data!E151","v":1000},{"$f":"Data!F6+Data!F122+Data!F151","v":1000},{"$f":"Data!G6+Data!G122+Data!G151","v":1000},{"$f":"SUM(C3:E3)","v":3000},{"$f":"SUM(Data!H6:J6,Data!H122:J122,Data!H151:J151)","v":3000},{"$f":"F3+G3","v":6000},null,null,{"$f":"Data!E5+Data!E121+Data!E150","v":1000},{"$f":"Data!F5+Data!F121+Data!F150","v":1000},{"$f":"Data!G5+Data!G121+Data!G150","v":1000},{"$f":"SUM(K3:M3)","v":3000},{"$f":"SUM(Data!H5:J5,Data!H121:J121,Data!H150:J150)","v":3000},{"$f":"N3+O3","v":6000}]
[]
[]
[null,"CDO revenue",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"CDO revenue",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Revenue -CPI",{"$f":"'Revenue at Risk Summary'!D33*1000","v":1020999.9999999999},{"$f":"'Revenue at Risk Summary'!E33*1000","v":1042440.9999999998},{"$f":"'Revenue at Risk Summary'!F33*1000","v":1064332.2609999997},{"$f":"SUM(C7:E7)","v":3127773.260999999},{"$f":"SUM('Revenue at Risk Summary'!G33:I33)*1000","v":3328989.9867754718},{"$f":"SUM(F7,G7)","v":6456763.2477754708},null,"Revenue -CPI",{"$f":"'Revenue at Risk Summary'!D5*1000","v":1020999.9999999999},{"$f":"'Revenue at Risk Summary'!E5*1000","v":1042440.9999999998},{"$f":"'Revenue at Risk Summary'!F5*1000","v":1064332.2609999997},{"$f":"SUM(K7:M7)","v":3127773.260999999},{"$f":"SUM('Revenue at Risk Summary'!G5:I5)*1000","v":3328989.9867754718},{"$f":"SUM(N7:O7)","v":6456763.2477754708}]
[null,"Revenue - FFS Update w/o Quality Bonus",{"$f":"'Revenue at Risk Summary'!D34*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E34*1000","v":1010024.9999999998},{"$f":"'Revenue at Risk Summary'!F34*1000","v":1010024.9999999998},{"$f":"SUM(C8:E8)","v":3025049.9999999991},{"$f":"SUM('Revenue at Risk Summary'!G34:I34)*1000","v":3030074.9999999995},{"$f":"SUM(F8,G8)","v":6055124.9999999981},null,"Revenue - FFS Update w/o Quality Bonus",{"$f":"'Revenue at Risk Summary'!D6*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E6*1000","v":1010024.9999999998},{"$f":"'Revenue at Risk Summary'!F6*1000","v":1010024.9999999998},{"$f":"SUM(K8:M8)","v":3025049.9999999991},{"$f":"SUM('Revenue at Risk Summary'!G6:I6)*1000","v":3030074.9999999995},{"$f":"SUM(N8:O8)","v":6055124.9999999981}]
[null,"Maximum - MIPS + AAPM",{"$f":"'Revenue at Risk Summary'!D35*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E35*1000","v":1012045.0499999997},{"$f":"'Revenue at Risk Summary'!F35*1000","v":1016085.1499999998},{"$f":"SUM(C9:E9)","v":3033130.1999999993},{"$f":"SUM('Revenue at Risk Summary'!G35:I35)*1000","v":3227029.8749999991},{"$f":"SUM(F9,G9)","v":6260160.0749999983},null,"Maximum - MIPS + AAPM",{"$f":"'Revenue at Risk Summary'!D7*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E7*1000","v":1012045.0499999997},{"$f":"'Revenue at Risk Summary'!F7*1000","v":1016085.1499999998},{"$f":"SUM(K9:M9)","v":3033130.1999999993},{"$f":"SUM('Revenue at Risk Summary'!G7:I7)*1000","v":3227029.8749999991},6260160.0749999983]
[null,"Minimum - MIPS + AAAPM",{"$f":"'Revenue at Risk Summary'!D36*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E36*1000","v":969623.99999999977},{"$f":"'Revenue at Risk Summary'!F36*1000","v":959523.74999999977},{"$f":"SUM(C10:E10)","v":2934147.7499999991},{"$f":"SUM('Revenue at Risk Summary'!G36:I36)*1000","v":2777568.7499999995},{"$f":"SUM(F10,G10)","v":5711716.4999999981},null,"Minimum - MIPS + AAAPM",{"$f":"'Revenue at Risk Summary'!D8*1000","v":1004999.9999999999},{"$f":"'Revenue at Risk Summary'!E8*1000","v":969623.99999999977},{"$f":"'Revenue at Risk Summary'!F8*1000","v":959523.74999999977},{"$f":"SUM(K10:M10)","v":2934147.7499999991},{"$f":"SUM('Revenue at Risk Summary'!G8:I8)*1000","v":2777568.7499999995},5711716.4999999981]
[]
[]
[null,"CDO-Revenue Per Clinician",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"CDO-Revenue Per Clinician",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Revenue -CPI",null,null,null,null,null,null,null,"Revenue -CPI"]
[null,"Revenue - FFS Update w/o Quality Bonus",null,null,null,null,null,null,null,"Revenue - FFS Update w/o Quality Bonus"]
[null,"Maximum - MIPS + AAPM",null,null,null,null,null,null,null,"Maximum - MIPS + AAPM"]
[null,"Minimum - MIPS + AAAPM",null,null,null,null,null,null,null,"Minimum - MIPS + AAAPM"]
[]
[]
[null,"CDO - Revenue Per Capita",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023",null,"CDO - Revenue Per Capita",2018,2019,2020,"3 Yrs: 2018-2020","3 Yrs: 2021-2023","6 Yrs: 2018-2023"]
[null,"Revenue -CPI",{"$f":"C7/C$3","v":1020.9999999999999},1042.4409999999998,1064.3322609999998,1042.5910869999996,1109.6633289251572,1076.1272079625785,null,"Revenue -CPI",{"$f":"K7/K$3","v":1020.9999999999999},1042.4409999999998,1064.3322609999998,1042.5910869999996,1109.6633289251572,1076.1272079625785]
[null,"Revenue - FFS Update w/o Quality Bonus",1004.9999999999999,1010.0249999999997,1010.0249999999997,1008.3499999999997,1010.0249999999999,1009.1874999999997,null,"Revenue - FFS Update w/o Quality Bonus",{"$f":"K8/K$3","v":1004.9999999999999},1010.0249999999997,1010.0249999999997,1008.3499999999997,1010.0249999999999,1009.1874999999997]
[null,"Maximum - MIPS + AAPM",1004.9999999999999,1012.0450499999997,1016.0851499999998,1011.0433999999998,1075.6766249999996,1043.3600124999998,null,"Maximum - MIPS + AAPM",1004.9999999999999,1012.0450499999997,1016.0851499999998,1011.0433999999998,1075.6766249999996,1043.3600124999998]
[null,"Minimum - MIPS + AAAPM",1004.9999999999999,969.6239999999998,959.52374999999972,978.04924999999969,925.85624999999982,951.9527499999997,null,"Minimum - MIPS + AAAPM",1004.9999999999999,969.6239999999998,959.52374999999972,978.04924999999969,925.85624999999982,951.9527499999997]
[]
[null,"Revenue at Risk - Per clinician",null,null,null,null,null,null,null,"Revenue at Risk - Per clinician"]
[null,"Baseline MIPS less Min MIPS + AAPM",null,null,null,null,null,null,null,"Baseline MIPS less Max MIPS"]
[null,"Baseline MIPS less Max MIPS + AAPM",null,null,null,null,null,null,null,"Baseline MIPS less Min MIPS"]
[null,null,null,null,null,null,null,null,null,"Baseline MIPS less Expected MACRA"]