{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Disclaimer","Staffing and Service Delivery","Net Financial Impact","Monthly CoCM Case Rate"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":4,"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":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":false,"merged":[[9,1,18,4]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"THIS FINANCIAL MODELING WORKBOOK (\"WORKBOOK\") IS AN ESTIMATION TOOL PROVIDED WITHOUT COST AND FOR YOUR CONVENIENCE THAT SHOULD ONLY BE USED FOR INFORMATIONAL PURPOSES. THE INFORMATION GENERATED BY THE WORKBOOK IS RELIANT ON USER INPUT DATA AND THE WORKBOOK’S ACCURACY IS DEPENDENT ON THE DATA PROVIDED BY THE END USER. NEITHER THE UNIVERSITY OF WASHINGTON (“UW”) NOR THE AMERICAN PSYCHIATRIC ASSOCIATION (“APA”) SHALL BE LIABLE IN ANY WAY FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, OR PUNITIVE DAMAGES, LOST PROFITS, TECHNICAL ISSUES, OR OTHER DAMAGES, REGARDLESS OF FORESEEABILITY, THAT ARISE OUT OF OR RELATE TO THE USE OF THE WORKBOOK. USERS OF THE WORKBOOK HEREBY RELEASE UW, UW SCHOOL OF MEDICINE, APA AND THEIR OFFICERS, AGENTS, EMPLOYEES, REPRESENTATIVES, FACULTY, AND STUDENTS FROM ALL CLAIMS ARISING OUT OF OR RELATING TO THE WORKBOOK.\n\nTHE WORKBOOK IS PROVIDED \"AS-IS” AND NEITHER APA NOR UW MAKE ANY WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WARRANTIES OF MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE, NON-INFRINGEMENT AND INTERFERENCE RELATING TO THE WORKBOOK AND HEREBY DISCLAIMS ALL SUCH WARRANTIES AS TO ANY MATTER WHATSOEVER."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"As Agreed:","2017-09-27"]

{"sheet":"Staffing and Service Delivery","index":1,"n_rows":80,"n_cols":13,"rows_kept":80,"cut":false,"hidden":false,"merged":[[73,1,73,3],[71,1,71,3],[68,1,68,3],[70,1,70,3],[72,1,72,3],[78,1,78,3],[74,1,75,3],[79,1,79,3],[2,2,3,4],[7,1,7,6],[14,1,14,6],[55,1,55,6],[63,1,63,6],[37,1,37,6],[21,6,22,6],[69,1,69,3],[67,1,67,3],[66,1,66,3],[65,1,65,3],[77,1,77,3],[76,1,76,3]]}
[]
[null,null,null,null,null,"Input"," = User-entered value"]
[null,null,"Staffing and Service Delivery",null,null,"Calculation"," = Calculated field (not editable)"]
[null,null,null,null,null,"Benchmark"," = Suggested benchmark (editable)"]
[null,"  Workbook Template Updated 06/29/2017",null,null,null,"Linked Information"," = Information copied from another cell"]
[]
[]
[null,"STAFFING"]
[]
[null,"Hours per week per 1.0 FTE at your organization"]
[null,"Team Member","FTE","Total Hours \nper Week","Suggested \nHours per Week \n(Based on 40:3 ratio)"]
[null,"Care Manager",null,{"$f":"C12*C10","v":0}]
[null,"Psychiatric Consultant",null,{"$f":"C13*C10","v":0},{"$f":"IF(D12>0,D12/40*3,\"\")","v":""}]
[]
[null,"WEEKLY TIME AND EFFORT ALLOCATION AND SERVICE UNIT GENERATION: CARE MANAGER",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Total Care Manager Hours per Week",{"$f":"IF(D12>0,D12,\"\")","v":""}]
[null,"Care Management Service Category","Percentage (%) \nof Total Hours \nper Week","Hours per Week","Service Units Generated"," Hours per Service Unit"]
[null,"Reimbursable Direct Care Services"]
[null,"Direct Treatment: Assessment Visit",null,{"$f":"IF(COUNTA(C20)>0,C20*$D$12,\"\")","v":""},{"$f":"IF(COUNTA(C20)>0,D20/F20,\"\")","v":""},0.75,"Avg. length of assessment visit"]
[null,"Direct Treatment: Ongoing Visits",null,{"$f":"IF(COUNTA(C21)>0,C21*$D$12,\"\")","v":""},{"$f":"IF(COUNTA(C21)>0,D21/F21,\"\")","v":""},0.5,"Avg. length of ongoing visits"]
[null,"Group Treatment",null,{"$f":"IF(COUNTA(C22)>0,C22*$D$12,\"\")","v":""},{"$f":"IF(COUNTA(C22)>0,D22/F22,\"\")","v":""},0.25,"Avg. length of group visit divided by\nAvg. # of participants"]
[null,"Subtotal: Reimbursable Direct Care Services",{"$f":"IF(COUNTA(C20:C22)>0,SUM(C20:C22),\"\")","v":""},{"$f":"IF(COUNTA(C20:C22)>0,SUM(D20:D22),\"\")","v":""},{"$f":"IF(COUNTA(C20:C22)>0,SUM(E20:E22),\"\")","v":""}]
[null,"Non-Reimbursable Direct Care Services "]
[null,"Warm Connection (Non-Billable)",null,{"$f":"IF(COUNTA(C25)>0,C25*$D$12,\"\")","v":""},{"$f":"IF(COUNTA(C25)>0,D25/F25,\"\")","v":""},0.25,"Avg. length of warm connection"]
[null,"Care Management Telephonic Services",null,{"$f":"IF(COUNTA(C26)>0,C26*$D$12,\"\")","v":""},{"$f":"IF(COUNTA(C26)>0,D26/F26,\"\")","v":""},0.25,"Avg. length of phone calls"]
[null,"Subtotal: Non-Reimbursable Direct Care Services",{"$f":"IF(COUNTA(C25:C26)>0,SUM(C25:C26),\"\")","v":""},{"$f":"IF(COUNTA(C25:C26)>0,SUM(D25:D26),\"\")","v":""}]
[null,"Indirect Care Coordination and Administrative Tasks"]
[null,"Charting",null,{"$f":"IF(COUNTA(C29)>0,C29*$D$12,\"\")","v":""}]
[null,"Registry Management",null,{"$f":"IF(COUNTA(C30)>0,C30*$D$12,\"\")","v":""}]
[null,"Psychiatric Consultation",null,""]
[null,"Team Communication",null,""]
[null,"Other (Clinical Supervision, Staff Meetings, Training, etc.)",null,""]
[null,"Subtotal: Indirect Care Coordination and Administrative Tasks",{"$f":"IF(COUNTA(C29:C33)>0,SUM(C29:C33),\"\")","v":""},{"$f":"IF(COUNTA(C29:C33)>0,SUM(D29:D33),\"\")","v":""}]
[]
[null,"Unassigned Time [Target = 0%]  ",{"$f":"1-SUM(C23,C27,C34)","v":1},"  (Green checkmark indicates value is at target)"]
[]
[null,"WEEKLY TIME AND EFFORT ALLOCATION AND SERVICE UNIT GENERATION: PSYCHIATRIC CONSULTANT",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"Total Psychiatric Consultant Hours per Week",{"$f":"IF(D13>0,D13,\"\")","v":""}]
[null,"Psychiatric Consultant Service Category","Percentage (%) of Total Hours per Week","Hours per Week","Service Units Generated"," Hours Per Service Unit"]
[null,"Indirect Care and Administrative Tasks"]
[null,"Registry Management",null,{"$f":"IF(COUNTA(C43)>0,C43*$D$13,\"\")","v":""}]
[null,"Psychiatric Consultation",null,{"$f":"IF(COUNTA(C44)>0,C44*$D$13,\"\")","v":""}]
[null,"Charting",null,""]
[null,"Direct PCP Communication",null,""]
[null,"Other (Reseach, Staff Meetings, Training, etc.)",null,""]
[null,"Subtotal: Indirect Care and Administrative Tasks",{"$f":"IF(COUNTA(C43:C47)>0,SUM(C43:C47),\"\")","v":""},{"$f":"IF(COUNTA(C43:C47)>0,SUM(D43:D47),\"\")","v":""}]
[null,"Reimbursable Direct Care Services"]
[null,"Direct Treatment: Assessment Visit",null,{"$f":"IF(COUNTA(C50)>0,C50*$D$13,\"\")","v":""},{"$f":"IF(COUNTA(C50)>0,D50/F50,\"\")","v":""},1,"Avg. length of assessment visit"]
[null,"Direct Treatment: Ongoing Visits",null,"",{"$f":"IF(COUNTA(C51)>0,D51/F51,\"\")","v":""},0.5,"Avg. length of ongoing visits"]
[null,"Subtotal: Reimbursable  Direct Care Services",{"$f":"IF(COUNTA(C50:C51)>0,SUM(C50:C51),\"\")","v":""},{"$f":"IF(COUNTA(C50:C51)>0,SUM(D50:D51),\"\")","v":""},{"$f":"IF(COUNTA(C50:C51)>0,SUM(E50:E51),\"\")","v":""}]
[]
[null,"Unassigned Time [Target = 0%]  ",{"$f":"1-SUM(C52,C48)","v":1},"  (Green checkmark indicates value is at target)"]
[]
[null,"ANNUALIZED REIMBURSABLE DIRECT CARE SERVICES"]
[]
[null,"Working Weeks Per Year"]
[null,"Annualized Reimbursable Direct Care Service Units","Direct Treatment: Assessment","Direct Treatment: Ongoing ","Group Treatment","Total \nService Units"]
[null,"Care Manager",{"$f":"IFERROR(IF(COUNTA(C58)>0,(E20)*C58,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNTA(C58)>0,(E21)*C58,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNTA(C58)>0,(E22)*C58,\"\"),\"\")","v":""},{"$f":"IF(SUM(C60:E60)>0,SUM(C60:E60),\"\")","v":""}]
[null,"Psychiatric Consultant",{"$f":"IFERROR(IF(COUNTA(C58)>0,(E50)*C58,\"\"),\"\")","v":""},{"$f":"IFERROR(IF(COUNTA(C58)>0,(E51)*C58,\"\"),\"\")","v":""},null,{"$f":"IF(SUM(C61:E61)>0,SUM(C61:E61),\"\")","v":""}]
[null,"Total: Annualized Reimbursable Direct Care Service Units",{"$f":"IF(SUM(C60:C61)>0,SUM(C60:C61),\"\")","v":""},{"$f":"IF(SUM(D60:D61)>0,SUM(D60:D61),\"\")","v":""},"",""]
[]
[null,"CASELOAD AND MONTHLY CASE VOLUME"]
[]
[null,"Average Weeks Elapsed Between First and Last Direct Care Service"]
[null,"Avg. number of weeks per episode of care"]
[null,"Average Count of Direct Care Service Units Provided"]
[null,"Avg. number of contacts per episode of care",null,null,null,"Per 1.0 FTE",null,null,null,null," "]
[null,"Single Point in Time Caseload Capacity",null,null,{"$f":"IF(E66*E68=0,\"\",F60/E68*E66/52)","v":""},{"$f":"IF(E66*E68=0,\"\",(F60/E68*E66/52)/C12)","v":""}]
[null,"Number of individuals feasible to have on the caseload at any point in time across all Care Managers"]
[null,"Projected Annual Caseload Capacity",null,null,{"$f":"IF(E66*E68=0,\"\",52*E70/E66)","v":""}]
[null,"Number of unique individuals feasible to serve over one year across all Care Managers"]
[null,"Projected Average Monthly Caseload Turnover ",null,null,{"$f":"IF(E66*E68=0,\"\",E72/12)","v":""}]
[null,"Number of cases opened and closed each month, based on above estimate of number of individuals \npossible to serve over one year"]
[]
[null,"Projected Number of Patients Served per Calendar Month",null,null,{"$f":"IF(E66*E68=0,\"\",E70+E74)","v":""}]
[null,"Potential number of patients served over one month who might be eligible for monthly case rate reimbursement"]
[null,"Projected Annualized Monthly Case Rate Potential ",null,null,{"$f":"IF(E66*E68=0,\"\",E77*12)","v":""}]
[null,"Number of times a monthly case rate could potentially be billed in one year--before accounting for payer mix."]

{"sheet":"Net Financial Impact","index":2,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[65,1,65,8],[31,1,31,8],[14,1,14,4],[2,3,3,6],[45,8,46,8],[43,1,43,7],[35,3,35,5],[35,6,35,7],[17,1,17,8],[6,1,6,8],[27,1,27,7],[49,1,49,8],[54,1,54,8]]}
[]
[null,null,null,null,null,null,null,"Input"," = User-entered value"]
[null,null,null,"Net Financial Impact             ",null,null,null,"Calculation"," = Calculated field (not editable)"]
[null,null,null,null,null,null,null,"Linked Information"," = Information copied from another cell"]
[null,"  Workbook Template Updated 06/29/2017"]
[]
[null,"PAYER MIX"]
[null,"Payer","% of Patients per Payer","% of Patients per Payer Eligible for Monthly Case Rate","Adjusted % of Patients Eligible for Monthly Case Rate"]
[null,null,null,null,{"$f":"IF(D9<>\"\",D9*C9,\"\")","v":""}]
[null,null,null,null,{"$f":"IF(D10<>\"\",D10*C10,\"\")","v":""}]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,{"$f":"IF(D14<>\"\",D14*C14,\"\")","v":""}]
[null,"To add rows: 1) Unprotect sheet  2) Insert rows above the last row with data  3) Copy formula in column E  4) Protect sheet"]
[null,"No Payer Assigned  [Target = 0%]  ",{"$f":"1-SUM(C9:C15)","v":1},"  (Green checkmark indicates value is at target)"]
[]
[null,"REIMBURSEMENT: ANNUALIZED MONTHLY CASE RATE"]
[]
[null,"Potential patient/months for billing case rate",{"$f":"IF('Staffing and Service Delivery'!E79>0,'Staffing and Service Delivery'!E79,\"\")","v":""}]
[null,"Payer","Monthly Case Rate Name","Monthly Reimbursement \nper Case","Adjusted % of Patients Eligible for Monthly Case Rate","Of Patients Eligible for Case Rate, % of Patients Also Eligible for Individual Services","Annualized Count of Cases Eligible for Monthly Case Rate","Annualized Reimbursement per Monthly Case Rate"]
[null,null,null,null,{"$f":"IF(SUMIF(B$9:B$14,B22,E$9:E$14)>0,VLOOKUP(B22,$B$9:$E$14,4,FALSE),\"\")","v":""},null,{"$f":"IFERROR(E22*$C$20,\"\")","v":""},{"$f":"IFERROR(G22*D22,\"\")","v":""}]
[null,null,null,null,"",null,{"$f":"IFERROR(E23*$C$20,\"\")","v":""},""]
[null,null,null,null,"",null,"",""]
[null,null,null,null,"",null,"",""]
[null,null,null,null,"",null,"",""]
[null,null,null,null,"",null,"",""]
[null,"To add rows: 1) Unprotect sheet  2) Insert rows above the last row with data  3) Copy formula in columns E, G, and H  4) Protect sheet"]
[null,"TOTAL Annualized Count of Cases Eligible for Monthly Case Rate",null,null,null,null,{"$f":"SUM(G22:G28)","v":0}]
[null,"Subtotal: Annualized Monthly Case Rate Reimbursement",null,null,null,null,null,null,{"$f":"IF(SUM(H22:H28)<>0,SUM(H22:H28),\"\")","v":""}]
[]
[null,"REIMBURSEMENT: ANNUALIZED BILLABLE INDIVIDUAL SERVICES"]
[]
[null,"Reimbursable Direct Care Service Units",{"$f":"IF('Staffing and Service Delivery'!F62>0,'Staffing and Service Delivery'!F62,\"\")","v":""}]
[]
[null,null,null,"Care Manager",null,null,"Psychiatric Consultant"]
[null,"Payer","% of Patients per Payer Eligible for Monthly Service Billing","Direct Treatment: Assessment \nAvg. Payment","Direct Treatment: Ongoing \nAvg. Payment","Group Treatment Avg. Payment","Direct Treatment: Assessment\nAvg. Payment","Direct Treatment: Ongoing\nAvg. Payment"]
[null,null,{"$f":"IF(SUMIF(B$9:B$15,B38,C$9:C$15)>0,VLOOKUP(B38,$B$9:$C$15,2,FALSE)-(SUMIF($B$9:$B$15,B38,$E$9:$E$15))+((SUMIF($B$9:$B$15,B38,$E$9:$E$15))*(SUMIF($B$22:$B$28,B38,$F$22:$F$28))),\"\")","v":""}]
[null,null,{"$f":"IF(SUMIF(B$9:B$15,B39,C$9:C$15)>0,VLOOKUP(B39,$B$9:$C$15,2,FALSE)-(SUMIF($B$9:$B$15,B39,$E$9:$E$15))+((SUMIF($B$9:$B$15,B39,$E$9:$E$15))*(SUMIF($B$22:$B$28,B39,$F$22:$F$28))),\"\")","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]
[null,"To add rows: 1) Unprotect sheet  2) Insert rows above the last row with data  3) Copy formula in column C  4) Protect sheet"]
[null,"Weighted Average per Service Unit",null,{"$f":"SUMPRODUCT(D38:D43,C38:C43)/SUM(C38:C43)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(E38:E43,C38:C43)/SUM(C38:C43)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(F38:F43,C38:C43)/SUM(C38:C43)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(G38:G43,C38:C43)/SUM(C38:C43)","v":{"$error":"#DIV/0!"}},{"$f":"SUMPRODUCT(H38:H43,C38:C43)/SUM(C38:C43)","v":{"$error":"#DIV/0!"}}]
[null,"Annualized Service Units",null,{"$f":"'Staffing and Service Delivery'!C60","v":""},{"$f":"'Staffing and Service Delivery'!D60","v":""},{"$f":"'Staffing and Service Delivery'!E60","v":""},{"$f":"'Staffing and Service Delivery'!C61","v":""},{"$f":"'Staffing and Service Delivery'!D61","v":""},"Across All Individual Service Categories:"]
[null,"Billable Individual Service Units",null,{"$f":"D46*(SUM($C38:$C44))","v":{"$error":"#VALUE!"}},{"$f":"E46*(SUM($C38:$C44))","v":{"$error":"#VALUE!"}},{"$f":"F46*(SUM($C38:$C44))","v":{"$error":"#VALUE!"}},{"$f":"G46*(SUM($C38:$C44))","v":{"$error":"#VALUE!"}},{"$f":"H46*(SUM($C38:$C44))","v":{"$error":"#VALUE!"}}]
[null,"Subtotal: Annualized Billable Individual Services Reimbursement",null,{"$f":"D47*D45","v":{"$error":"#VALUE!"}},{"$f":"E47*E45","v":{"$error":"#VALUE!"}},{"$f":"F47*F45","v":{"$error":"#VALUE!"}},{"$f":"G47*G45","v":{"$error":"#VALUE!"}},{"$f":"H47*H45","v":{"$error":"#VALUE!"}},{"$f":"SUM(D48:H48)","v":{"$error":"#VALUE!"}}]
[]
[null,"TOTAL REIMBURSEMENT"]
[]
[null,"Total Reimbursement:",null,null,"Monthly Case Rate Reimbursement",null,"       Billable Individual Services Reimbursement"]
[null,"Monthly Case Rate Reimbursement + Billable Individual Services Reimbursement",null,null,{"$f":"IF(I30>0,I30,\"\")","v":""},"+  ",{"$f":"IFERROR(I48,\"\")","v":""},"=",{"$f":"I48+I30","v":{"$error":"#VALUE!"}}]
[]
[null,"TOTAL COST"]
[]
[null,"Personnel",null,"Annual Salary per 1.0 FTE","FTE","Salary Cost Per FTE","Fringe Benefits \n% of Salary","Fringe Benefits Cost","Personnel Subtotal"]
[null,"Care Manager",null,null,{"$f":"IF('Staffing and Service Delivery'!C12>0,'Staffing and Service Delivery'!C12,\"\")","v":""},{"$f":"IF('Staffing and Service Delivery'!C12>0,E58*D58,\"\")","v":""},null,{"$f":"IF('Staffing and Service Delivery'!C12>0,G58*F58,\"\")","v":""},{"$f":"IF('Staffing and Service Delivery'!C12>0,H58+F58,\"\")","v":""}]
[null,"Psychiatric Consultant",null,null,{"$f":"IF('Staffing and Service Delivery'!C13>0,'Staffing and Service Delivery'!C13,\"\")","v":""},{"$f":"IF('Staffing and Service Delivery'!C13>0,E59*D59,\"\")","v":""},null,{"$f":"IF('Staffing and Service Delivery'!C13>0,G59*F59,\"\")","v":""},{"$f":"IF('Staffing and Service Delivery'!C13>0,H59+F59,\"\")","v":""}]
[null,"Subtotal: Personnel Cost",null,null,null,null,null,null,{"$f":"IF(SUM(I58:I59)>0,SUM(I58:I59),\"\")","v":""}]
[]
[null,"Organizational Overhead",null,null,null,null,"Percentage:",null,{"$f":"IF(SUM(I58:I59)>0,I60*H62,\"\")","v":""}]
[]
[null,"Total Cost: Personnel + Overhead",null,null,null,null,null,null,{"$f":"I62+I60","v":{"$error":"#VALUE!"}}]
[]
[null,"NET IMPACT"]
[null,null,null,null,"Total Reimbursement",null,"Total Cost"]
[null,"Net Impact: Total Reimbursement - Total Cost",null,null,{"$f":"IFERROR(I53,\"\")","v":""},"-",{"$f":"IFERROR(I64,\"\")","v":""},"=",{"$f":"I53-I64","v":{"$error":"#VALUE!"}}]

{"sheet":"Monthly CoCM Case Rate","index":3,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,3,3,7],[16,2,16,5],[7,4,7,8],[22,1,22,5]]}
[]
[null,null,null,null,null,null,null,null,"Input"," = User-entered value"]
[null,null,null,"Average Monthly Reimbursement for Patients Eligible for CoCM Case Rate",null,null,null,null,"Calculation"," = Calculated field (not editable)"]
[null,null,null,null,null,null,null,null,"Linked Information"," = Information copied from another cell"]
[null,"  Workbook Template Updated 06/29/2017"]
[]
[null,"Projected Number of Patients Served per Calendar Month",null,{"$f":"'Staffing and Service Delivery'!E77","v":""}]
[null,"Percent (%) of Patients Eligible for CoCM Case Rate",null,null,"Add up CoCM case rate percentages in column E of Net Financial Impact worksheet"]
[null,"Total Number of Patients Eligible for CoCM Case Rate",null,{"$f":"IFERROR(D8*D7,\"\")","v":""}]
[null,"Minutes/Month","Percent (%) of Eligible Patients","Avg. Number of Patients","Reimbursement Amount","Total"]
[null,"Not Seen",null,{"$f":"C11*$D$9","v":{"$error":"#VALUE!"}},0,{"$f":"IFERROR(D11*E11,\"\")","v":""}]
[null,"70 Initial Minutes",null,{"$f":"C12*$D$9","v":{"$error":"#VALUE!"}},142.84,{"$f":"IFERROR(D12*E12,\"\")","v":""}]
[null,"100 Initial Minutes",null,{"$error":"#VALUE!"},{"$f":"142.84+66.04","v":208.88},""]
[null,"130 Initial Minutes",null,{"$error":"#VALUE!"},{"$f":"142.84+66.04+66.04","v":274.92},""]
[null,"60 Subsequent Minutes",null,{"$error":"#VALUE!"},126.33,""]
[null,"90 Subsequent Minutes",null,{"$f":"C16*$D$9","v":{"$error":"#VALUE!"}},{"$f":"126.33+66.04","v":192.37},""]
[null,null,"Insert additional rows above the last row; copy formulas in columns D and F"]
[null,"Total Monthly Reimbursement for Eligible Patients",null,null,null,{"$f":"SUM(F11:F17)","v":0}]
[]
[null,"Unassigned Patients [Target = 0%]  ",{"$f":"1-SUM(C11:C17)","v":1},"  (Green checkmark indicates value is at target)"]
[]
[null,"Average Monthly Reimbursement per Eligible Patient",null,null,null,{"$f":"IFERROR(F18/D9,0)","v":0}]
[null,"Use this value for CoCM case rate in Net Financial Impact worksheet (column D; Monthly Reimbursement per Case)"]