{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Options and Impact","Facility Summary","Facility Profile","Rate Calculation","Medians","9.30.19 Costs Annualized","9.30.19 Costs Original","Wage Add-On 6-30-2021 and 2022","Medicaid CR Crosswalk","Inflation","Medicaid CMI","Normalizing CMI","Source and Assumptions","Providers","Data Validation"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":141,"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":"Options and Impact","index":0,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[[53,0,53,1],[52,0,52,1],[14,0,14,1],[42,0,42,1],[45,4,45,5],[50,4,50,5],[15,0,15,1],[20,0,20,1],[26,0,26,1],[17,0,17,1],[18,0,18,1],[38,0,38,1],[40,0,40,1],[49,0,49,1],[50,0,50,1],[36,0,36,1],[16,0,16,1],[27,0,27,1],[13,4,13,5],[0,7,0,9],[8,0,8,2],[8,4,8,5],[6,0,6,9],[20,4,20,5],[11,0,11,1],[12,0,12,1],[32,4,32,5],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[32,0,32,1],[28,0,28,1],[30,0,30,1]]}
[null,null,null,null,null,null,null,"This model is Confidential and Deliberative, and is in draft form for modeling analysis.  This model is iterative and will be updated as decisions or DSS requests are made.  A final version will be completed subject to QA and final decision making prior to rate issuance."]
["Connecticut Department of Social Services"]
["Nursing Home Case Mix Reimbursement Options and Impact"]
[]
["Version 3.1 (4/14/2022)"]
[]
["Cost Component Options"]
[]
["Assign Costs to Options Box 1 through 4",null,null,null,"Options Box 1 = Direct Care Case Mix Adjusted",null,null,"Peer Groups","Median","Limit"]
[null,null,"Options Box",null,"  Type of System","Cost Based",null,"1 - All Facilities",{"$f":"Medians!E3","v":130.16},{"$f":"IFERROR(ROUND(I10*Box_1_Median_Percent,2),\"N/A\")","v":175.72}]
[null,null,null,null,null,null,null,"2 - CCNH Fairfield County",{"$f":"Medians!E4","v":141.32999999999998},{"$f":"IFERROR(ROUND(I11*Box_1_Median_Percent,2),\"N/A\")","v":190.8}]
[null,null,null,null,"  Peer Group Options","2/3 - Fairfield, Non-Fairfield",null,"2 - CCNH Non-Fairfield",{"$f":"Medians!E5","v":127.08},{"$f":"IFERROR(ROUND(I12*Box_1_Median_Percent,2),\"N/A\")","v":171.56},null,null,null,"Price Based",1]
[null,null,null,null,"  Inflation Factor Options","Consumer Price Index",null,"3 - RHNS Fairfield County",{"$f":"Medians!E6","v":"N/A"},{"$f":"IFERROR(ROUND(I13*Box_1_Median_Percent,2),\"N/A\")","v":"N/A"},null,null,null,"Cost Based"]
[null,null,null,null,null,null,null,"3 - RHNS Non-Fairfield",{"$f":"Medians!E7","v":"N/A"},{"$f":"IFERROR(ROUND(I14*Box_1_Median_Percent,2),\"N/A\")","v":"N/A"},null,null,null,"1 - All facilities in one region",1]
[null,null,null,null,"  Percent of Median to Apply as Price/Limit",1.35,null,"Efficiency as % of Median All Facilities",null,{"$f":"IFERROR(I10*$F$16,\"N/A\")","v":130.16}]
[null,null,null,null,"  Efficiency as Percentage of Median",1,null,"Efficiency as % of Median CCNH Fairfield County",null,{"$f":"IFERROR(I11*$F$16,\"N/A\")","v":141.32999999999998},null,null,null,"2 - Freestanding or Hospital Based"]
[null,null,null,null,"  Efficiency Percentage",0,null,"Efficiency as % of Median CCNH Non-Fairfield ",null,127.08,null,null,null,"3 - Bed Size"]
[null,null,null,null,"  Minimum Occupancy",0.9,null,"Efficiency as % of Median RHNS Fairfield County",null,"N/A",null,null,null,"4 - Urban or Rural"]
[null,null,null,null,null,null,null,"Efficiency as % of Median RHNS Non-Fairfield ",null,"N/A"]
[]
[null,null,null,null,"Options Box 2 - Indirect",null,null,"Peer Groups","Median","Limit"]
[null,null,null,null,"  Type of System","Cost Based",null,"1 - All Facilities",{"$f":"Medians!F3","v":58.8},{"$f":"ROUND(I22*Box_2_Median_Percent,2)","v":67.62}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price Based",2]
[null,null,null,null,null,null,null,"Efficiency as Percentage of Median",null,{"$f":"ROUND(I22*F28,2)","v":58.8},null,null,null,"Cost Based"]
[null,null,null,null,"  Inflation Factor Options","Consumer Price Index",null,null,null,null,null,null,null,"1 - All facilities in one region",1]
[]
[null,null,null,null,"  Percent of Median to Apply as Price/Limit",1.1499999999999999,null,null,null,null,null,null,null,"2 - Freestanding or Hospital Based"]
[null,null,null,null,"  Efficiency as Percentage of Median",1,null,null,null,null,null,null,null,"3 - Bed Size"]
[null,null,null,null,"  Efficiency Percentage",0.25,null,null,null,null,null,null,null,"4 - Urban or Rural"]
[null,null,null,null,"  Minimum Occupancy",0.9]
[null,null,null,"Grouper 48"]
[null,null,null,"Grouper 66"]
["Case Mix Index",null,"Four QTR Avg-BCI Excluded",null,"Options Box 3 - Administrative and General",null,null,"Peer Groups","Median","Price/Limit"]
[null,null,null,null,"  Type of System","Cost Based",null,"1 - All Facilities",{"$f":"Medians!G3","v":36.82},{"$f":"ROUND(I34*Box_3_Median_Percent,2)","v":36.82},null,null,null,"Price Based",1]
["CMI Period",null,"2021 Q4"]
[null,null,null,null,null,null,null,"Efficiency as % of Median",null,{"$f":"ROUND(I34*F40,2)","v":36.82},null,null,null,"Cost Based"]
["Aids Modeled as Standard NF",null,"No",null,"  Inflation Factor Options","Consumer Price Index",null,null,null,null,null,null,null,"1 - All facilities in one region",1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - Freestanding or Hospital Based"]
["RHNS as Standard NF",null,"CCH / RHNS Combined",null,"  Percent of Median to Apply as Price/Limit",1,null,null,null,null,null,null,null,"3 - Bed Size"]
[null,null,null,null,"  Efficiency as Percentage of Median",1,null,null,null,null,null,null,null,"4 - Urban or Rural"]
["SLTC as Standard NF",null,"CCH Only",null,"  Efficiency Percentage",0.25]
[null,null,null,null,"  Minimum Occupancy",0.9]
["Secure Care as Standard NF",null,"Exclude"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Price Based",1]
["Reimbursement Rate Phase In Options",null,null,null,"Options Box 4 - Capital/Other",null,null,"Peer Groups","Median",null,null,null,null,"Cost Based"]
[null,null,null,null,"  Type of System","Cost Based",null,"1 - All Facilities",{"$f":"Medians!H3","v":6.99},null,null,null,null,"1 - All facilities in one region",1]
["Rate Phase-in Option",null,"Corridor",null,null,null,null,null,null,null,null,null,null,"2 - Freestanding or Hospital Based"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - Bed Size"]
[null,null,null,null,"  Inflation Factor Options","Consumer Price Index",null,null,null,null,null,null,null,"4 - Urban or Rural"]
["     B.  Phase-In Blended Percentage (New Casemix Rate)",null,0.25]
[null,null,null,null,"  Percent of Median to Apply as Price/Limit",1]
["     a.  Phase-in Rate Corridor Floor",null,0,null,"  Incentive Percentage",0]
["     b.  Phase-in Rate Corridor Ceiling",null,6.5,null,"  Minimum Occupancy",0.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Based"]

{"sheet":"Facility Summary","index":1,"n_rows":9,"n_cols":70,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,65,5,69],[5,62,5,63],[5,0,5,9],[5,27,5,35],[5,48,5,52],[5,54,5,56],[5,58,5,60],[5,41,5,46],[5,11,5,25]]}
[]
[null,"Connecticut Department of Social Services"]
[null,"Facility Summary"]
[null,"Note: Please do not sort this tab."]
[null,null,null,null,null,null,1,2,3,4,null,5,6,8,9,null,null,11,12,13,14,null,15,16,17,null,null,18,19,20,23,24,21,22,null,null,25,26]
["General Provider Information",null,null,null,null,null,null,null,null,null,null,"Rate & Model Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Estimated Payments",null,null,null,null,null,null,null,null,null,"Estimated Fiscal Impact",null,"Rate Prior to Phase-In",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Corridor NF Per Diem Rate BAF Calculation",null,null,null,"Phased In Rate",null,null,"Phased In Rate Plus 7/1/2022 Add-Ons"]
[null,"Facility Name","Ownership Type","Region 1","License Type","Mgmt Company","Provider Number","County"," Bed Capacity Last Day of Period "," Medicaid CT Days ",null,"Calculated Rate (Current System)","Issued Rate","Issued Rate Less Wage Add-on","Total Modeled Rate","Total Modeled Rate Less Wage Add-on","Modeled Rate Less Current Issued Rate","Box 1 Rate","Box 2 Rate","Box 3 Rate","Box 4 Rate","Provider Tax","FRV","ROE","Wage Increase","Social Worker Minimum Staffing Rate Increase",null,"Payments Based on Calculated Rates (Current System) for the Period 10/1/2021 - 9/30/2022",null,"Payments Based on Issued Rates for the Period 10/1/2021 - 9/30/2022",null,"Payments Based on Modeled Rates",null,"Payments Based on Issued Rates Less Wage Add-0n",null,"Payments Based on Modeled Rates Less Wage Add-On",null,"Medicaid Fiscal Impact (Modeled Rate Compared to Current Issued Rate)",null,"Modeled Rate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Budget Adjustment Factor\n(BAF)","NF Per Diem After BAF","NF Per Diem Reimbursement Rate After BAF and  Phase-In (Corridor Option)",null,"Phased In Rate","Phased In Rate Less Issued Rate",null,"7/1/2022 4.5% Rate Increase","Phased In Rate + 7/1/2022 4.5% Rate Increase","Benefits Enhancement Add-On","Phased In Rate Plus 7/1/2022 Add-Ons","New Rate Less Issued Rate"]
[null,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!A$8:A$9&\"\",MATCH($G8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Example Provider # 1"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($G8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$B$8:$B$9,MATCH(G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":"2 - CCNH Non-Fairfield"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($G8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!E$8:E$9&\"\",MATCH($G8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":""},1,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!G$8:G$9&\"\",MATCH($G8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Non-Fairfield County"},{"$f":"IF(E8<>\"\",INDEX('9.30.19 Costs Annualized'!$J$8:$J$9,MATCH($G8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\")","v":57},{"$f":"IF(E8<>\"\",INDEX('9.30.19 Costs Annualized'!$L$8:$L$9,MATCH($G8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\")","v":11716},null,{"$f":"INDEX('9.30.19 Costs Annualized'!AI$8:AI$9,MATCH($G8,'9.30.19 Costs Annualized'!$F$8:$F$9,0))","v":300},{"$f":"INDEX('9.30.19 Costs Annualized'!AJ$8:AJ$9,MATCH($G8,'9.30.19 Costs Annualized'!$F$8:$F$9,0))","v":290},{"$f":"IFERROR(M8-Y8,\"\")","v":269.81},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$BB$8:$BB$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":303.86},{"$f":"IF(E8<>\"\",O8-Y8,\"\")","v":283.67},{"$f":"IF(E8<>\"\",O8-M8,\"\")","v":13.860000000000014},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$U$8:$U$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":146.19999999999999},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AC$8:$AC$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":61.25},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AK$8:$AK$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":36.82},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AO$8:$AO$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":10.08},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AS$8:$AS$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":17.37},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AU$8:$AU$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":10.90821897},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AV$8:$AV$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":1.0454000000000001},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AX$8:$AX$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":20.189999999999998},{"$f":"IF(E8<>\"\",INDEX('Rate Calculation'!$AZ$8:$AZ$9,MATCH($G8,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":0},null,{"$f":"IF(E8<>\"\",L8*J8,\"\")","v":3514800},null,{"$f":"IF(E8<>\"\",M8*J8,\"\")","v":3397640},null,{"$f":"IF(E8<>\"\",O8*J8,\"\")","v":3560023.7600000002},null,{"$f":"IF(E8<>\"\",N8*J8,\"\")","v":3161093.96},null,{"$f":"IF(E8<>\"\",P8*J8,\"\")","v":3323477.72},null,{"$f":"IF(E8<>\"\",AF8-AD8,\"\")","v":162383.76000000024},null,{"$f":"O8","v":303.86},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IFERROR(BG8*AN8,\"\")","v":303.86},{"$f":"IFERROR(IF(BH8<M8,MAX(BH8,M8-'Options and Impact'!$C$53),MIN(BH8,M8+'Options and Impact'!$C$54)),\"\")","v":296.5},null,{"$f":"IF(E8<>\"\",BI8,\"\")","v":296.5},{"$f":"IF(E8<>\"\",BK8-M8,\"\")","v":6.5},null,{"$f":"ROUND(BK8*0.045,2)","v":13.34},{"$f":"BK8+BN8","v":309.83999999999997},null,{"$f":"BO8+BP8","v":309.83999999999997},{"$f":"IF(E8<>\"\",BQ8-M8,\"\")","v":19.839999999999975}]
[null,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!A$8:A$9&\"\",MATCH($G9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Example Provider # 2"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($G9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$B$8:$B$9,MATCH(G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":"2 - CCNH Fairfield County"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($G9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!E$8:E$9&\"\",MATCH($G9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":""},2,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!G$8:G$9&\"\",MATCH($G9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Fairfield County"},{"$f":"IF(E9<>\"\",INDEX('9.30.19 Costs Annualized'!$J$8:$J$9,MATCH($G9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\")","v":135},{"$f":"IF(E9<>\"\",INDEX('9.30.19 Costs Annualized'!$L$8:$L$9,MATCH($G9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\")","v":41556},null,{"$f":"INDEX('9.30.19 Costs Annualized'!AI$8:AI$9,MATCH($G9,'9.30.19 Costs Annualized'!$F$8:$F$9,0))","v":250},{"$f":"INDEX('9.30.19 Costs Annualized'!AJ$8:AJ$9,MATCH($G9,'9.30.19 Costs Annualized'!$F$8:$F$9,0))","v":270},249.66,{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$BB$8:$BB$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":258.49},238.15,-11.509999999999991,{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$U$8:$U$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":120},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AC$8:$AC$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":51.82},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AK$8:$AK$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":34.517499999999998},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AO$8:$AO$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":7.06},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AS$8:$AS$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":20.58},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AU$8:$AU$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":3.8820999999999999},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AV$8:$AV$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":0.29189999999999999},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AX$8:$AX$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":20.34},{"$f":"IF(E9<>\"\",INDEX('Rate Calculation'!$AZ$8:$AZ$9,MATCH($G9,'Rate Calculation'!$E$8:$E$9,0)),\"\")","v":0},null,10389000,null,11220120,null,10741810.439999999,null,10374870.959999999,null,9896561.4000000004,null,-478309.56000000052,null,258.49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,{"$f":"IFERROR(BG9*AN9,\"\")","v":258.49},{"$f":"IFERROR(IF(BH9<M9,MAX(BH9,M9-'Options and Impact'!$C$53),MIN(BH9,M9+'Options and Impact'!$C$54)),\"\")","v":270},null,{"$f":"IF(E9<>\"\",BI9,\"\")","v":270},{"$f":"IF(E9<>\"\",BK9-M9,\"\")","v":0},null,{"$f":"ROUND(BK9*0.045,2)","v":12.15},{"$f":"BK9+BN9","v":282.14999999999998},null,{"$f":"BO9+BP9","v":282.14999999999998},12.149999999999977]

{"sheet":"Facility Profile","index":2,"n_rows":71,"n_cols":7,"rows_kept":71,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6],[2,0,2,6],[4,0,4,6],[5,2,5,3],[76,4,76,6],[6,2,6,3],[23,0,23,6],[42,0,42,6],[19,0,19,6],[47,0,47,6],[74,0,75,0],[11,0,11,6],[52,0,52,6],[57,0,57,6]]}
["DRAFT July 1, 2022 REIMBURSEMENT RATE"]
["(FOR DEMONSTRATION PURPOSES ONLY)"]
[{"$f":"INDEX('Facility Summary'!$B:$B,MATCH('Facility Profile'!$B$14,'Facility Summary'!$G:$G,0))","v":0}]
[]
["SELECTED MODEL OPTIONS"]
["Cost Category","Selection","Peer Groups",null,"% of Median","Incentive %","Min. Occ."]
["Box 1",{"$f":"'Options and Impact'!F10","v":"Cost Based"},{"$f":"'Options and Impact'!F12","v":"2/3 - Fairfield, Non-Fairfield"},null,{"$f":"Box_1_Median_Percent","v":1.35},{"$f":"Box_1_Incentive_Percentage","v":0},{"$f":"'Options and Impact'!F18","v":0.9}]
["Box 2",{"$f":"'Options and Impact'!F22","v":"Cost Based"},null,null,{"$f":"Box_2_Median_Percent","v":1.1499999999999999},{"$f":"Box_2_Incentive_Percentage","v":0.25},{"$f":"'Options and Impact'!F30","v":0.9}]
["Box 3",{"$f":"'Options and Impact'!F34","v":"Cost Based"},null,null,{"$f":"Box_3_Median_Percent","v":1},{"$f":"Box_3_Incentive_Percentage","v":0.25},{"$f":"'Options and Impact'!F42","v":0.9}]
["Box 4",{"$f":"'Options and Impact'!F47","v":"Cost Based"},null,null,{"$f":"Box_4_Median_Percent","v":1},{"$f":"Box_4_Incentive_Percentage","v":0},{"$f":"'Options and Impact'!F54","v":0.9}]
[]
["DISCLAIMER: Please Note this rate sheet is for demonstration purposes only, and will not be utilized for Medicaid payment/claim adjudication purposes.  It is designed to show the potential provider impact from the transition to a case mix (acuity-based) reimbursement system. Facility cost and rate information is subject to change from subsequent audit/review findings, CMI updates, additional legislative changes, and/or further system modification."]
[]
["Number:",1,null,"Actual Resident Days:",null,{"$f":"INDEX('Rate Calculation'!$I$8:$I$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":20331}]
["County:",{"$f":"INDEX('Facility Summary'!$H$8:$H$9,MATCH($B$14,'Facility Summary'!$G$8:$G$9,0))","v":"Non-Fairfield County"},null,"Bed Days Available:",null,{"$f":"INDEX('Rate Calculation'!$K$8:$K$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":20805}]
["Geographic Location:",{"$f":"INDEX('Facility Summary'!$D$8:$D$9,MATCH($B$14,'Facility Summary'!$G$8:$G$9,0))","v":"2 - CCNH Non-Fairfield"},null,"Occupancy %:",null,{"$f":"ROUND(F14/F15,4)","v":0.97719999999999996}]
["Cost Year Begin: ",{"$f":"INDEX('9.30.19 Costs Annualized'!$H$8:$H$9,MATCH($B$14,'9.30.19 Costs Annualized'!$F$8:$F$9,0))","v":"2018-10-01"},null,"# Beds:",null,{"$f":"INDEX('Rate Calculation'!$G$8:$G$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":57}]
["Cost Year End: ",{"$f":"INDEX('9.30.19 Costs Annualized'!$I$8:$I$9,MATCH($B$14,'9.30.19 Costs Annualized'!$F$8:$F$9,0))","v":"2019-09-30"}]
[]
["CMI INFORMATION"]
["Quarter Ending","Normalizing \n(Base Year) CMI","Medicaid CMI ","Case Mix Neutrality Factor","Medicaid CMI for Rate Setting"]
[{"$f":"EOMONTH(DATE(LEFT('Options and Impact'!$C$35,4),RIGHT('Options and Impact'!$C$35,1)*3,1),0)","v":"2021-12-31"},{"$f":"ROUND(IF('Options and Impact'!$C$33='Data Validation'!$A$31,INDEX('Normalizing CMI'!$G$9:$G$10,MATCH(B14,'Normalizing CMI'!$A$9:$A$10,0)),INDEX('Normalizing CMI'!$J$9:$J$10,MATCH(B14,'Normalizing CMI'!$A$9:$A$10,0))),4)","v":1.1258999999999999},{"$f":"INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH($B$14,'Medicaid CMI'!$A$8:$A$9,0))","v":1.0566},1,{"$f":"C22*D22","v":1.0566}]
[]
["NET OPERATING"]
["Description","Direct Care","Indirect Care","Admin. & General","Capital/Other","Provider Tax"]
["Facility Costs",{"$f":"INDEX('Rate Calculation'!$M$8:$M$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":3001072},{"$f":"INDEX('Rate Calculation'!$W$8:$W$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":1179924},{"$f":"INDEX('Rate Calculation'!$AE$8:$AE$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":968221},{"$f":"INDEX('Rate Calculation'!$AM$8:$AM$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":194195},{"$f":"INDEX('Rate Calculation'!$AQ$8:$AQ$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":334575}]
["Inflation Multiplier",{"$f":"IF('Options and Impact'!F13='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$11)","v":1.0553999999999999},{"$f":"IF('Options and Impact'!F25='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$11)","v":1.0553999999999999},{"$f":"IF('Options and Impact'!F37='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$11)","v":1.0553999999999999},{"$f":"IF('Options and Impact'!F50='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$26)","v":1.0553999999999999},{"$f":"IF('Options and Impact'!F50='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$26)","v":1.0553999999999999}]
["Inflated Costs",{"$f":"ROUND(B27*B26,0)","v":3167331},{"$f":"ROUND(C27*C26,0)","v":1245292},{"$f":"ROUND(D27*D26,0)","v":1021860},{"$f":"ROUND(E27*E26,0)","v":204953},{"$f":"ROUND(F27*F26,0)","v":353110}]
["Days Used in Division",{"$f":"MAX((G7*$F$15),$F$14)","v":20331},{"$f":"MAX(($G8*$F$15),$F$14)","v":20331},{"$f":"MAX(($G9*$F$15),$F$14)","v":20331},{"$f":"MAX(($G10*$F$15),$F$14)","v":20331},{"$f":"MAX(($G10*$F$15),$F$14)","v":20331}]
["Divided by Days",{"$f":"ROUND(B28/B29,2)","v":155.79},{"$f":"ROUND(C28/C29,2)","v":61.25},{"$f":"ROUND(D28/D29,2)","v":50.26},{"$f":"ROUND(E28/E29,2)","v":10.08},{"$f":"ROUND(F28/F29,2)","v":17.37}]
["Total Facility CMI ",{"$f":"+B22","v":1.1258999999999999},"NA","NA","NA","NA"]
["Cost Per Diem at Total Facility CMI",{"$f":"ROUND(B30/B31,2)","v":138.37},"NA","NA","NA","NA"]
["Limit",{"$f":"INDEX('Rate Calculation'!$Q$8:$Q$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":171.56},{"$f":"INDEX('Rate Calculation'!$Z$8:$Z$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":67.62},{"$f":"INDEX('Rate Calculation'!$AH$8:$AH$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":36.82},"NA","NA"]
["Allowed Per Diem",{"$f":"INDEX('Rate Calculation'!$R$8:$R$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":138.37},{"$f":"INDEX('Rate Calculation'!$AA$8:$AA$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":61.25},{"$f":"INDEX('Rate Calculation'!$AI$8:$AI$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":36.82},{"$f":"INDEX('Rate Calculation'!$AO$8:$AO$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":10.08},{"$f":"INDEX('Rate Calculation'!$AS$8:$AS$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":17.37}]
["Facility's Medicaid CMI",{"$f":"E22","v":1.0566},"NA","NA","NA","NA"]
["Rate",{"$f":"ROUND(B35*B34,2)","v":146.19999999999999},{"$f":"+C34","v":61.25},{"$f":"+D34","v":36.82},{"$f":"+E34","v":10.08},{"$f":"+F34","v":17.37}]
["Incentive Allowance","NA",{"$f":"INDEX('Rate Calculation'!$AB$8:$AB$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":0},{"$f":"IF(Box_3_type_of_system='Data Validation'!A14,0,INDEX('Rate Calculation'!$AJ$8:$AJ$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0)))","v":0},"NA","NA"]
["Final Rate",{"$f":"+B36","v":146.19999999999999},{"$f":"+C37+C36","v":61.25},{"$f":"+D37+D36","v":36.82},{"$f":"E36","v":10.08},{"$f":"F36","v":17.37}]
[]
["Grand Total Net Operating Components ",null,null,null,null,{"$f":"SUM(B38:F38)","v":271.71999999999997}]
[]
[]
["FRV and ROE Rate"]
["Fair Rental Value (FRV) Rate",null,null,null,null,{"$f":"INDEX('Rate Calculation'!$AU$8:$AU$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":10.90821897}]
["Return on Equity (ROE) Rate",null,null,null,null,{"$f":"INDEX('Rate Calculation'!$AV$8:$AV$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":1.0454000000000001}]
[]
[]
["Wage Add-On"]
["Wage Add-On",null,null,null,null,{"$f":"INDEX('Rate Calculation'!$AX$8:$AX$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":20.189999999999998}]
["Social Worker Minimum Staffing Rate Increase",null,null,null,null,{"$f":"INDEX('Rate Calculation'!$AZ$8:$AZ$9,MATCH($B$14,'Rate Calculation'!$E$8:$E$9,0))","v":0}]
[]
[]
["Initial System Phase-In Parameters"]
["Max System Allowed Gain from Issued Rate (Stop Gain)",null,null,null,null,6.5]
["Max System Allowed Loss From Issued Rate (Stop Loss)",null,null,null,null,0]
[]
[]
["Rate Setting Parameters"]
[]
["Case Mix Reimbursement Rate (Prior to Phase-In Adjustment)",null,null,null,null,{"$f":"ROUND(SUM(F50+F49,F45,F44,F40),2)","v":303.86}]
["Current Issued Rate",null,null,null,null,{"$f":"INDEX('Facility Summary'!$M$8:$M$9,MATCH($B$14,'Facility Summary'!$G$8:$G$9,0))","v":290}]
["Variance to Issued Rate",null,null,null,null,{"$f":"F60-F61","v":13.860000000000014}]
[]
["Adjustment to Case Mix Reimbursement Rate for Phase-In Parameters",null,null,null,null,{"$f":"IF(F62<F55,F55-F62,IF(F62>F54,F54-F62,0))","v":-7.3600000000000136}]
[]
["Case Mix Reimbursement Rate (After Phase-In Adjustment)",null,null,null,null,{"$f":"F60+F64","v":296.5}]
["7/1/2022 4.5% Rate Increase",null,null,null,null,{"$f":"INDEX('Facility Summary'!$BN$8:$BN$9,MATCH($B$14,'Facility Summary'!$G$8:$G$9,0))","v":13.34}]
["Benefits Enhancement Add-On",null,null,null,null,{"$f":"INDEX('Facility Summary'!$BP$8:$BP$9,MATCH($B$14,'Facility Summary'!$G$8:$G$9,0))","v":0}]
["Case Mix Reimbursement Rate (After Increases)",null,null,null,null,{"$f":"SUM(F66:F68)","v":309.83999999999997}]
[]
["Total Gain/(Loss) from Issued Rate Prior to 7/1/2022 Increases",null,null,null,null,{"$f":"F66-F61","v":6.5}]

{"sheet":"Rate Calculation","index":3,"n_rows":9,"n_cols":54,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,46,5,47],[5,0,5,10],[5,12,5,20],[5,22,5,28],[5,30,5,36],[5,38,5,40],[5,42,5,44]]}
[]
["Connecticut Department of Social Services"]
["Rate Calculation Summary"]
["Note: Please do not sort this tab."]
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,null,15,16,null,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,null,null,46,47]
["General Provider Information",null,null,null,null,null,null,null,null,null,null,null,"Box 1 Direct Care Information",null,null,null,null,null,null,null,null,null,"Box 2 Indirect Care Information",null,null,null,null,null,null,null,"Box 3 A&G Information",null,null,null,null,null,null,null,"Box 4 Capital Information",null,null,null,"Provider Tax",null,null,null,"FRV & ROE",null,null,"Wage Increase",null,"Social Woker",null,"Rate Prior to Phase-In"]
["Facility Name","Region 1","Mgmt Company","License Type","Provider Number","County"," Bed Capacity Last Day of Period "," Medicaid CT Days ","Total Care Days"," Actual and Imputed Resident Days ","Available Days",null,"Direct Care Costs","Direct Care Inflated Costs","Direct Care Per Diems","Direct Care Normalizing CMI Adjusted Per Diems","Direct Care Limit","Direct Care Allowed Per Diem","Direct Care Efficiency as Percent of Median","Direct Care Efficiency Adjustment","Direct Care Medicaid CMI-Adjusted Per Diem",null,"Indirect Care Costs","Indirect Care Inflated Costs","Indirect Care Per Diems","Indirect Care Limit/Price","Indirect Care Allowed Per Diem","Indirect Care Efficiency Adjustment","Indirect Care Allowed Per Diem with Efficiency Adjustment",null,"A&G Costs","A&G Inflated Costs","A&G Per Diems","A&G Limit/Price","A&G Allowed Per Diem","A&G Efficiency Adjustment","A&G Allowed Per Diem with Efficiency Adjustment",null,"Capital Costs","Capital Inflated Costs","Capital Per Diems",null,"Provider Tax","Provider Tax Inflated Costs","Provider Tax Per Diems",null,"FRV","Inflated ROE",null,"Wage Increase",null,"Social Worker Minimum Staffing Rate Increase",null,"Total NF Per Diem Reimbursement Rate Prior to BAF and Rate Phase-In (Inclusive of Wage Increase)"]
[{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!A$8:A$9,MATCH($E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Example Provider # 1"},{"$f":"IF(D8=\"\",\"\",IF('Options and Impact'!$C$39='Data Validation'!$A$41,IF(AND(F8=\"Fairfield County\",D8=\"Nurs Fac-RHNS\"),Medians!$D$6,IF(AND(F8<>\"Fairfield County\",D8=\"Nurs Fac-RHNS\"),Medians!$D$7,IF(F8=\"Fairfield County\",Medians!$D$4,Medians!$D$5))),IF(F8=\"Fairfield County\",Medians!$D$4,Medians!$D$5)))","v":"2 - CCNH Non-Fairfield"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!E$8:E$9&\"\",MATCH($E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},1,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!G$8:G$9&\"\",MATCH($E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Non-Fairfield County"},{"$f":"IFERROR(INDEX('9.30.19 Costs Annualized'!J$8:J$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\")","v":57},{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!L$8:L$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":11716},{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!Q$8:Q$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":20331},{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!T$8:T$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":20331},{"$f":"IFERROR(IF(INDEX('9.30.19 Costs Original'!$CR$8:$CR$9,(MATCH(E8,'9.30.19 Costs Original'!$F$8:$F$9,0)))>0,INDEX('9.30.19 Costs Original'!$CR$8:$CR$9,(MATCH(E8,'9.30.19 Costs Original'!$F$8:$F$9,0))),G8*365),\"\")","v":20805},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AB$8:AB$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":3001072},{"$f":"IF(E8<>\"\",ROUND(M8*IF('Options and Impact'!$F$13='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$13='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),\"\")","v":3167331},{"$f":"IFERROR(ROUND(N8/MAX($I8,$K8*'Options and Impact'!$F$18),2),\"\")","v":155.79},{"$f":"IFERROR(ROUND(O8/IF('Options and Impact'!$C$33='Data Validation'!$A$31,INDEX('Normalizing CMI'!$G$9:$G$10,MATCH(E8,'Normalizing CMI'!$A$9:$A$10,0)),INDEX('Normalizing CMI'!$J$9:$J$10,MATCH(E8,'Normalizing CMI'!$A$9:$A$10,0))),2),\"\")","v":138.37},{"$f":"IF(E8<>\"\",IF(Box_1_Pgroup='Data Validation'!$A$7,'Options and Impact'!$J$10,INDEX('Options and Impact'!$J$10:$J$14,MATCH(B8,'Options and Impact'!$H$10:$H$14,0))),\"\")","v":171.56},{"$f":"IF(E8<>\"\",IF(P8<Q8,P8,Q8),\"\")","v":138.37},{"$f":"IF(E8<>\"\",IF(Box_1_Pgroup='Data Validation'!$A$7,'Options and Impact'!$J$15,IF(B8='Options and Impact'!$H$11,'Options and Impact'!$J$16,IF(B8='Options and Impact'!$H$12,'Options and Impact'!$J$17,IF(B8='Options and Impact'!$H$13,'Options and Impact'!$J$18,'Options and Impact'!$J$19)))),\"\")","v":127.08},{"$f":"IF(E8<>\"\",ROUND(IF(P8*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E8,'Medicaid CMI'!$A$8:$A$9,0))<S8*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E8,'Medicaid CMI'!$A$8:$A$9,0)),((S8*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E8,'Medicaid CMI'!$A$8:$A$9,0)))-P8*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E8,'Medicaid CMI'!$A$8:$A$9,0)))*Box_1_Incentive_Percentage,0),2),\"\")","v":0},{"$f":"IF(E8<>\"\",IFERROR(ROUND(IFERROR(R8*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E8,'Medicaid CMI'!$A$8:$A$9,0)),R8*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E8,'Medicaid CMI'!$A$8:$A$9,0)))+T8,2),0),\"\")","v":146.19999999999999},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AC$8:AC$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":1179924},{"$f":"IF(E8<>\"\",IFERROR(ROUND(W8*IF('Options and Impact'!$F$25='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$25='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),0),\"\")","v":1245292},{"$f":"IF(E8<>\"\",IFERROR(ROUND(X8/MAX($I8,$K8*'Options and Impact'!$F$30),2),0),\"\")","v":61.25},{"$f":"IF(E8<>\"\",'Options and Impact'!$J$22,\"\")","v":67.62},{"$f":"IF(E8<>\"\",IF(Y8<Z8,Y8,Z8),\"\")","v":61.25},{"$f":"IF(E8<>\"\",ROUND(IF(Y8<'Options and Impact'!$J$24,('Options and Impact'!$J$24-Y8)*'Options and Impact'!$F$29,0),2),\"\")","v":0},{"$f":"IF(E8<>\"\",AA8+AB8,\"\")","v":61.25},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AD$8:AD$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":968221},{"$f":"IF(E8<>\"\",ROUND(AE8*IF('Options and Impact'!$F$37='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$37='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),\"\")","v":1021860},{"$f":"IF(E8<>\"\",IFERROR(ROUND(AF8/MAX($I8,$K8*'Options and Impact'!$F$42),2),0),\"\")","v":50.26},{"$f":"IF(E8<>\"\",'Options and Impact'!$J$34,\"\")","v":36.82},{"$f":"IF(E8<>\"\",IF('Options and Impact'!$F$34=\"Price Based\",AH8,IF(AG8>AH8,AH8,AG8)),\"\")","v":36.82},{"$f":"IF(E8<>\"\",IF(AG8<'Options and Impact'!$J$36,('Options and Impact'!$J$36-AG8)*'Options and Impact'!$F$41,0),\"\")","v":0},{"$f":"IF(E8<>\"\",IF(Box_3_type_of_system='Data Validation'!$A$14,AI8,AI8+AJ8),\"\")","v":36.82},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AE$8:AE$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0))-INDEX('9.30.19 Costs Annualized'!AS$8:AS$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),0),\"\")","v":194195},{"$f":"IF(E8<>\"\",ROUND(AM8*IF('Options and Impact'!$F$50='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$50='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),\"\")","v":204953},{"$f":"IF(E8<>\"\",IFERROR(ROUND(AN8/MAX($I8,$K8*'Options and Impact'!$F$54),2),0),\"\")","v":10.08},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AS$8:AS$9,MATCH($E8,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),0),\"\")","v":334575},{"$f":"IF(E8<>\"\",IFERROR(ROUND(AQ8*IF('Options and Impact'!$F$50='Data Validation'!$B$16,Inflation!$G$19,IF('Options and Impact'!$F$50='Data Validation'!$A$17,Inflation!$G$26,Inflation!$G$11)),0),0),\"\")","v":353110},{"$f":"IF(E8<>\"\",IFERROR(ROUND(AR8/MAX($I8,$K8*'Options and Impact'!$F$54),2),0),\"\")","v":17.37},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Original'!$CJ$8:$CJ$9,MATCH(E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),0),\"\")","v":10.90821897},{"$f":"IF(E8<>\"\",IFERROR(ROUND(INDEX('9.30.19 Costs Original'!$CK$8:$CK$9,MATCH(E8,'9.30.19 Costs Original'!$F$8:$F$9,0))*IF('Options and Impact'!$F$50='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$26),4),0),\"\")","v":1.0454000000000001},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Original'!$CG$8:$CG$9,MATCH(E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),0),\"\")","v":20.189999999999998},null,{"$f":"IF(E8<>\"\",IFERROR(INDEX('9.30.19 Costs Original'!$CH$8:$CH$9,MATCH(E8,'9.30.19 Costs Original'!$F$8:$F$9,0)),0),\"\")","v":0},null,{"$f":"IF(E8<>\"\",ROUND(U8+AC8+AK8+AO8+AU8+AV8+AX8+AZ8+AS8,2),\"\")","v":303.86}]
[{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!A$8:A$9,MATCH($E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Example Provider # 2"},{"$f":"IF(D9=\"\",\"\",IF('Options and Impact'!$C$39='Data Validation'!$A$41,IF(AND(F9=\"Fairfield County\",D9=\"Nurs Fac-RHNS\"),Medians!$D$6,IF(AND(F9<>\"Fairfield County\",D9=\"Nurs Fac-RHNS\"),Medians!$D$7,IF(F9=\"Fairfield County\",Medians!$D$4,Medians!$D$5))),IF(F9=\"Fairfield County\",Medians!$D$4,Medians!$D$5)))","v":"2 - CCNH Fairfield County"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!E$8:E$9&\"\",MATCH($E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":""},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},2,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!G$8:G$9&\"\",MATCH($E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Fairfield County"},{"$f":"IFERROR(INDEX('9.30.19 Costs Annualized'!J$8:J$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\")","v":135},{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!L$8:L$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":41556},{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!Q$8:Q$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":46927},{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!T$8:T$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":46936},{"$f":"IFERROR(IF(INDEX('9.30.19 Costs Original'!$CR$8:$CR$9,(MATCH(E9,'9.30.19 Costs Original'!$F$8:$F$9,0)))>0,INDEX('9.30.19 Costs Original'!$CR$8:$CR$9,(MATCH(E9,'9.30.19 Costs Original'!$F$8:$F$9,0))),G9*365),\"\")","v":49275},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AB$8:AB$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":5024368},{"$f":"IF(E9<>\"\",ROUND(M9*IF('Options and Impact'!$F$13='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$13='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),\"\")","v":5302718},{"$f":"IFERROR(ROUND(N9/MAX($I9,$K9*'Options and Impact'!$F$18),2),\"\")","v":113},{"$f":"IFERROR(ROUND(O9/IF('Options and Impact'!$C$33='Data Validation'!$A$31,INDEX('Normalizing CMI'!$G$9:$G$10,MATCH(E9,'Normalizing CMI'!$A$9:$A$10,0)),INDEX('Normalizing CMI'!$J$9:$J$10,MATCH(E9,'Normalizing CMI'!$A$9:$A$10,0))),2),\"\")","v":123.65},{"$f":"IF(E9<>\"\",IF(Box_1_Pgroup='Data Validation'!$A$7,'Options and Impact'!$J$10,INDEX('Options and Impact'!$J$10:$J$14,MATCH(B9,'Options and Impact'!$H$10:$H$14,0))),\"\")","v":190.8},{"$f":"IF(E9<>\"\",IF(P9<Q9,P9,Q9),\"\")","v":123.65},{"$f":"IF(E9<>\"\",IF(Box_1_Pgroup='Data Validation'!$A$7,'Options and Impact'!$J$15,IF(B9='Options and Impact'!$H$11,'Options and Impact'!$J$16,IF(B9='Options and Impact'!$H$12,'Options and Impact'!$J$17,IF(B9='Options and Impact'!$H$13,'Options and Impact'!$J$18,'Options and Impact'!$J$19)))),\"\")","v":141.32999999999998},{"$f":"IF(E9<>\"\",ROUND(IF(P9*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E9,'Medicaid CMI'!$A$8:$A$9,0))<S9*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E9,'Medicaid CMI'!$A$8:$A$9,0)),((S9*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E9,'Medicaid CMI'!$A$8:$A$9,0)))-P9*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E9,'Medicaid CMI'!$A$8:$A$9,0)))*Box_1_Incentive_Percentage,0),2),\"\")","v":0},{"$f":"IF(E9<>\"\",IFERROR(ROUND(IFERROR(R9*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E9,'Medicaid CMI'!$A$8:$A$9,0)),R9*INDEX('Medicaid CMI'!$BD$8:$BD$9,MATCH(E9,'Medicaid CMI'!$A$8:$A$9,0)))+T9,2),0),\"\")","v":120},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AC$8:AC$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":2200663},{"$f":"IF(E9<>\"\",IFERROR(ROUND(W9*IF('Options and Impact'!$F$25='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$25='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),0),\"\")","v":2322580},{"$f":"IF(E9<>\"\",IFERROR(ROUND(X9/MAX($I9,$K9*'Options and Impact'!$F$30),2),0),\"\")","v":49.49},{"$f":"IF(E9<>\"\",'Options and Impact'!$J$22,\"\")","v":67.62},{"$f":"IF(E9<>\"\",IF(Y9<Z9,Y9,Z9),\"\")","v":49.49},{"$f":"IF(E9<>\"\",ROUND(IF(Y9<'Options and Impact'!$J$24,('Options and Impact'!$J$24-Y9)*'Options and Impact'!$F$29,0),2),\"\")","v":2.33},{"$f":"IF(E9<>\"\",AA9+AB9,\"\")","v":51.82},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AD$8:AD$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),\"\"),\"\")","v":1500787},{"$f":"IF(E9<>\"\",ROUND(AE9*IF('Options and Impact'!$F$37='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$37='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),\"\")","v":1583931},{"$f":"IF(E9<>\"\",IFERROR(ROUND(AF9/MAX($I9,$K9*'Options and Impact'!$F$42),2),0),\"\")","v":33.75},{"$f":"IF(E9<>\"\",'Options and Impact'!$J$34,\"\")","v":36.82},{"$f":"IF(E9<>\"\",IF('Options and Impact'!$F$34=\"Price Based\",AH9,IF(AG9>AH9,AH9,AG9)),\"\")","v":33.75},{"$f":"IF(E9<>\"\",IF(AG9<'Options and Impact'!$J$36,('Options and Impact'!$J$36-AG9)*'Options and Impact'!$F$41,0),\"\")","v":0.76750000000000007},{"$f":"IF(E9<>\"\",IF(Box_3_type_of_system='Data Validation'!$A$14,AI9,AI9+AJ9),\"\")","v":34.517499999999998},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AE$8:AE$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0))-INDEX('9.30.19 Costs Annualized'!AS$8:AS$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),0),\"\")","v":313698},{"$f":"IF(E9<>\"\",ROUND(AM9*IF('Options and Impact'!$F$50='Data Validation'!$A$16,Inflation!$G$19,IF('Options and Impact'!$F$50='Data Validation'!$A$17,Inflation!$G$11,Inflation!$G$26)),0),\"\")","v":331077},{"$f":"IF(E9<>\"\",IFERROR(ROUND(AN9/MAX($I9,$K9*'Options and Impact'!$F$54),2),0),\"\")","v":7.06},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Annualized'!AS$8:AS$9,MATCH($E9,'9.30.19 Costs Annualized'!$F$8:$F$9,0)),0),\"\")","v":914937},{"$f":"IF(E9<>\"\",IFERROR(ROUND(AQ9*IF('Options and Impact'!$F$50='Data Validation'!$B$16,Inflation!$G$19,IF('Options and Impact'!$F$50='Data Validation'!$A$17,Inflation!$G$26,Inflation!$G$11)),0),0),\"\")","v":965625},{"$f":"IF(E9<>\"\",IFERROR(ROUND(AR9/MAX($I9,$K9*'Options and Impact'!$F$54),2),0),\"\")","v":20.58},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Original'!$CJ$8:$CJ$9,MATCH(E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),0),\"\")","v":3.8820999999999999},{"$f":"IF(E9<>\"\",IFERROR(ROUND(INDEX('9.30.19 Costs Original'!$CK$8:$CK$9,MATCH(E9,'9.30.19 Costs Original'!$F$8:$F$9,0))*IF('Options and Impact'!$F$50='Data Validation'!$A$16,Inflation!$G$19,Inflation!$G$26),4),0),\"\")","v":0.29189999999999999},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Original'!$CG$8:$CG$9,MATCH(E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),0),\"\")","v":20.34},null,{"$f":"IF(E9<>\"\",IFERROR(INDEX('9.30.19 Costs Original'!$CH$8:$CH$9,MATCH(E9,'9.30.19 Costs Original'!$F$8:$F$9,0)),0),\"\")","v":0},null,{"$f":"IF(E9<>\"\",ROUND(U9+AC9+AK9+AO9+AU9+AV9+AX9+AZ9+AS9,2),\"\")","v":258.49}]

{"sheet":"Medians","index":4,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[null,"Non-Fairfield"]
["Connecticut Department of Social Services",null,null,"Medians","Box 1 - Direct Care","Box 2 - Indirect Care","Box 3 - \nA&G","Box 4 - Capital"]
["Median Calculation","Hartford County",null,"1 - All Facilities",130.16,58.8,36.82,6.99]
[null,"New London County","Fairfield County","2 - CCNH Fairfield County",141.32999999999998]
[null,"Middlesex County",null,"2 - CCNH Non-Fairfield",127.08]
[null,"Windham County",null,"3 - RHNS Fairfield County","N/A"]
[null,"Litchfield County",null,"3 - RHNS Non-Fairfield","N/A"]
[null,"Tolland County"]

{"sheet":"9.30.19 Costs Annualized","index":5,"n_rows":9,"n_cols":80,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,51,5,54],[5,63,5,79],[5,0,5,20],[5,21,5,32],[5,34,5,35],[5,38,5,43]]}
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73]
[]
["Connecticut Department of Social Services"]
["9/30/19 Annualized Cost Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Options/Impact Response:",null,{"$f":"'Options and Impact'!C12","v":0},null,null,{"$f":"'Options and Impact'!C13","v":0},null,null,null,null,null,null,null,{"$f":"'Options and Impact'!C22","v":0},{"$f":"'Options and Impact'!C23","v":0},{"$f":"'Options and Impact'!C24","v":0},{"$f":"'Options and Impact'!C25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Options and Impact'!C16","v":0},null,null,null,null,null,null,{"$f":"'Options and Impact'!C19","v":0},null,null,{"$f":"'Options and Impact'!C17","v":0},{"$f":"'Options and Impact'!C18","v":0},{"$f":"IF('Options and Impact'!C28='Data Validation'!A26,3,IF('Options and Impact'!C28='Data Validation'!A27,4,'Options and Impact'!C28))","v":0},{"$f":"IF('Options and Impact'!C29='Data Validation'!A26,3,IF('Options and Impact'!C29='Data Validation'!A27,4,'Options and Impact'!C29))","v":0}]
["Note: Please do not sort this tab."]
["General Provider Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Information",null,null,null,null,null,null,null,null,null,null,null,null,"Rates",null,null,null,"Management Fees",null,null,null,null,null,null,null,null,null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,null,null,"Common Cost Report Adjustments"]
["Facility Name","Ownership Type","License Type",null,"Management Company","Provider Number","County","Cost Report Start","Cost Report End"," Bed Capacity Last Day of Period ","Medicare Days"," Medicaid CT Days ","Medicaid Other States","Private Pay","State SSI","Other Resident Days","Total Care Days","Medicaid Bed Reserve Days","Other Bed Reserve Days"," Actual and Imputed Resident Days ","Actual Occupancy","Total Direct Costs not Considering Options","Total Indirect Costs not Considering Options","Total A&G Costs not Considering Options","Total Capital Costs","Total Costs (RCR, New2)","Return on Equity","Total Direct Costs","Total Indirect Costs","Total A&G Costs","Total Capital/Other Costs","Total Costs","Difference",null,"Calculated Rate","Issued Rate",null,null,"Management Fees Direct","Management Fees Direct Adjustment","Management Fee Direct Net of Adjustment","Management Fees Indirect","Management Fees Indirect Adjustment","Management Fee Indirect Net of Adjustment"," Resident Day User Fee "," Equipment Lease "," Movable Equipment Depreciation "," Real Estate Taxes Paid By Owner "," Real Estate Taxes Paid By Lessor "," Personal Property Taxes "," Building Insurance "," Automobile Insurance "," Umbrella Insurance "," Fire and Extended Coverage Insurance "," Other Insurance "," Total Insurance Excluding AnG ","Capital Expense/Movable Equipment Adjustments","Depreciation on Unallowable Motor Vehicles Adjustment","Unallowable Property and Real Estate Taxes","Rental of Building Space or Rooms","Mortgage Insurance Adjustment","Property Insurance Adjustment",null,"Cell Phone Expense","Cell Phone Adjustment","Corporation Business Tax","Income Tax/Corporate Business Tax Adjustment","Holiday Parties for Staff","Gifts to Staff and Residents","Gifts, Flowers, and coffee Shop Adjustment","Management Fees","Unallowable Management Fees",null,"Dues and Membership Fees","Professional Dues Disallowed","Total Managerial Admin Comp Disallowed","Total Moveable Equipment Interest","Other Interest Expense","Interest Income on Accounts Receivable Adjustment","Building Depreciation and Interest Adjustment"]
[{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!A$8:A$9&\"\",MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Example Provider # 1"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!B$8:B$9&\"\",MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Profit"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},{"$f":"IFERROR(IF(INDEX('9.30.19 Costs Original'!$D$8:$D$9,MATCH(F8,'9.30.19 Costs Original'!$F$8:$F$9,0))=0,\"\",(INDEX('9.30.19 Costs Original'!$D$8:$D$9,MATCH(F8,'9.30.19 Costs Original'!$F$8:$F$9,0)))),\"\")","v":""},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!E$8:E$9&\"\",MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":""},1,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!G$8:G$9&\"\",MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Non-Fairfield County"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!H$8:H$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"2018-10-01"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!I$8:I$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"2019-09-30"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!J$8:J$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":57},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!K$8:K$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":3279},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!L$8:L$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":11716},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!M$8:M$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!N$8:N$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":4192},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!O$8:O$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!P$8:P$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":1144},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!Q$8:Q$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":20331},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!R$8:R$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!S$8:S$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!T$8:T$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":20331},{"$f":"IFERROR(ROUND(INDEX('9.30.19 Costs Original'!U$8:U$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),4),\"\")","v":0.97719999999999996},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!V$8:V$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":3001072},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!W$8:W$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":1179924},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!X$8:X$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":968221},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!Y$8:Y$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":528770},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!Z$8:Z$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":5677987},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AA$8:AA$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":20139},{"$f":"IFERROR(V8+IF($AO$4=\"No\",0,-AO8),\"\")","v":3001072},{"$f":"IFERROR(W8+IF($AR$4=\"No\",0,-AR8),\"\")","v":1179924},{"$f":"IFERROR(X8+IF($AR$4=\"Yes\",AR8,0)+IF($AO$4=\"Yes\",AO8,0)-IF($BM$4=\"No\",BM8,0)+IF($AZ$4=\"Yes\",AZ8,0)+IF($BA$4=\"Yes\",BA8,0)+IF($BB$4=\"Yes\",BB8,0)+IF($BC$4=\"Yes\",BC8,0)-IF($BW$4=\"No\",BW8,0)-IF($BX$4=\"No\",BX8,0)-IF($BT$4=\"No\",BT8,0)+IF($BY$4=3,BY8,0)+IF($BZ$4=3,BZ8,0),\"\")","v":968221},{"$f":"IFERROR(Y8-IF($AZ$4=\"Yes\",AZ8,0)-IF($BA$4=\"Yes\",BA8,0)-IF($BB$4=\"Yes\",BB8,0)-IF($BC$4=\"Yes\",BC8,0)+IF($BY$4=4,BY8,0)+IF(B8=\"Profit\",IF($BZ$4=4,BZ8,0),IF($BZ$4=3,0,BZ8))+CA8,\"\")","v":528770},{"$f":"IFERROR(SUM(AB8:AE8),\"\")","v":5677987},{"$f":"IFERROR(Z8-AF8,\"\")","v":0},null,{"$f":"IFERROR(ROUND(INDEX('9.30.19 Costs Original'!$AI$8:$AI$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),2),\"\")","v":300},{"$f":"IFERROR(ROUND(INDEX('9.30.19 Costs Original'!$AJ$8:$AJ$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0)),2),\"\")","v":290},null,null,{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AM$8:AM$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AN$8:AN$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(AM8+AN8,\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AP$8:AP$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AQ$8:AQ$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(AP8+AQ8,\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AS$8:AS$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":334575},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,AT$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,AU$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,AV$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,AW$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,AX$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,AY$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AZ$8:AZ$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BA$8:BA$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BB$8:BB$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":31970},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BC$8:BC$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":22486},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BD$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BE$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BF$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BG$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BH$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BI$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BJ$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BL$8:BL$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":1721},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BM$8:BM$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":-641},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BN$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BO$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BP$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BQ$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BR$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F8,'9.30.19 Costs Original'!$F$7:$CB$9,BS$5,FALSE)/($I8-$H8+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BT$8:BT$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},null,{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BV$8:BV$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":4879},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BW$8:BW$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":-2382},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BX$8:BX$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":-126805},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BY$8:BY$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BZ$8:BZ$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":25088},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!CA$8:CA$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!CB$8:CB$9,MATCH($F8,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I8-$H8+1))*365,0),\"\")","v":0}]
[{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!A$8:A$9&\"\",MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Example Provider # 2"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!B$8:B$9&\"\",MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Profit"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!C$8:C$9&\"\",MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Nurs Fac-CCH"},{"$f":"IFERROR(IF(INDEX('9.30.19 Costs Original'!$D$8:$D$9,MATCH(F9,'9.30.19 Costs Original'!$F$8:$F$9,0))=0,\"\",(INDEX('9.30.19 Costs Original'!$D$8:$D$9,MATCH(F9,'9.30.19 Costs Original'!$F$8:$F$9,0)))),\"\")","v":""},null,2,{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!G$8:G$9&\"\",MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"Fairfield County"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!H$8:H$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"2018-10-01"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!I$8:I$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":"2019-09-30"},{"$f":"IFERROR(INDEX('9.30.19 Costs Original'!J$8:J$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),\"\")","v":135},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!K$8:K$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":2189},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!L$8:L$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":41556},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!M$8:M$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!N$8:N$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":1911},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!O$8:O$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!P$8:P$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":1271},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!Q$8:Q$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":46927},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!R$8:R$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":5},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!S$8:S$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":4},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!T$8:T$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":46936},{"$f":"IFERROR(ROUND(INDEX('9.30.19 Costs Original'!U$8:U$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),4),\"\")","v":0.95230000000000004},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!V$8:V$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":5024368},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!W$8:W$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":2200663},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!X$8:X$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":1500787},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!Y$8:Y$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":1228635},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!Z$8:Z$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":9954454},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AA$8:AA$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":12982},{"$f":"IFERROR(V9+IF($AO$4=\"No\",0,-AO9),\"\")","v":5024368},{"$f":"IFERROR(W9+IF($AR$4=\"No\",0,-AR9),\"\")","v":2200663},{"$f":"IFERROR(X9+IF($AR$4=\"Yes\",AR9,0)+IF($AO$4=\"Yes\",AO9,0)-IF($BM$4=\"No\",BM9,0)+IF($AZ$4=\"Yes\",AZ9,0)+IF($BA$4=\"Yes\",BA9,0)+IF($BB$4=\"Yes\",BB9,0)+IF($BC$4=\"Yes\",BC9,0)-IF($BW$4=\"No\",BW9,0)-IF($BX$4=\"No\",BX9,0)-IF($BT$4=\"No\",BT9,0)+IF($BY$4=3,BY9,0)+IF($BZ$4=3,BZ9,0),\"\")","v":1500787},{"$f":"IFERROR(Y9-IF($AZ$4=\"Yes\",AZ9,0)-IF($BA$4=\"Yes\",BA9,0)-IF($BB$4=\"Yes\",BB9,0)-IF($BC$4=\"Yes\",BC9,0)+IF($BY$4=4,BY9,0)+IF(B9=\"Profit\",IF($BZ$4=4,BZ9,0),IF($BZ$4=3,0,BZ9))+CA9,\"\")","v":1228635},{"$f":"IFERROR(SUM(AB9:AE9),\"\")","v":9954453},{"$f":"IFERROR(Z9-AF9,\"\")","v":1},null,{"$f":"IFERROR(ROUND(INDEX('9.30.19 Costs Original'!$AI$8:$AI$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),2),\"\")","v":250},{"$f":"IFERROR(ROUND(INDEX('9.30.19 Costs Original'!$AJ$8:$AJ$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0)),2),\"\")","v":270},null,null,{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AM$8:AM$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AN$8:AN$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(AM9+AN9,\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AP$8:AP$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AQ$8:AQ$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(AP9+AQ9,\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AS$8:AS$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":914937},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,AT$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,AU$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,AV$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,AW$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,AX$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,AY$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!AZ$8:AZ$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BA$8:BA$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":105606},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BB$8:BB$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BC$8:BC$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BD$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BE$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BF$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BG$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BH$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BI$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BJ$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},null,{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BL$8:BL$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":2714},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BM$8:BM$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":-1274},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BN$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BO$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BP$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BQ$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BR$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"ROUND((VLOOKUP($F9,'9.30.19 Costs Original'!$F$7:$CB$9,BS$5,FALSE)/($I9-$H9+1))*365,0)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BT$8:BT$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":-281609},null,{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BV$8:BV$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":15484},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BW$8:BW$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":-9616},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BX$8:BX$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":-13176},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BY$8:BY$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!BZ$8:BZ$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!CA$8:CA$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0},{"$f":"IFERROR(ROUND((INDEX('9.30.19 Costs Original'!CB$8:CB$9,MATCH($F9,'9.30.19 Costs Original'!$F$8:$F$9,0))/($I9-$H9+1))*365,0),\"\")","v":0}]

{"sheet":"9.30.19 Costs Original","index":6,"n_rows":9,"n_cols":96,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,0,5,20],[5,38,5,43],[5,51,5,54],[5,63,5,79],[5,34,5,35],[5,21,5,32]]}
[null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73]
[]
["Connecticut Department of Social Services",null,null,null,null,null,null,null,null,6,7,8,9,10,11,12,13,14,15,16,null,18,19,20,21,22,23,null,null,null,null,null,null,null,24,25,null,null,27,30,null,32,35,null,37,null,null,null,null,null,null,40,43,46,50,null,null,null,null,null,null,null,null,51,54,null,null,null,null,null,null,58,null,59,60,61,62,63,64,66,null,74,76,null,null,null,null,77,78,null,79]
["9/30/19 Cost Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Options/Impact Response:",null,{"$f":"'Options and Impact'!C12","v":0},null,null,{"$f":"'Options and Impact'!C13","v":0},null,null,null,null,null,null,null,{"$f":"'Options and Impact'!C22","v":0},{"$f":"'Options and Impact'!C23","v":0},{"$f":"'Options and Impact'!C24","v":0},{"$f":"'Options and Impact'!C25","v":0},null,null,null,null,null,null,null,null,null,{"$f":"'Options and Impact'!C16","v":0},null,null,null,null,null,null,{"$f":"'Options and Impact'!C19","v":0},null,null,{"$f":"'Options and Impact'!C17","v":0},{"$f":"'Options and Impact'!C18","v":0},{"$f":"IF('Options and Impact'!C28='Data Validation'!A26,3,IF('Options and Impact'!C28='Data Validation'!A27,4,'Options and Impact'!C28))","v":0},{"$f":"IF('Options and Impact'!C29='Data Validation'!A26,3,IF('Options and Impact'!C29='Data Validation'!A27,4,'Options and Impact'!C29))","v":0}]
["Note: Please do not sort this tab.",null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75]
["General Provider Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cost Information",null,null,null,null,null,null,null,null,null,null,null,null,"Rates",null,null,null,"Management Fees",null,null,null,null,null,null,null,null,null,null,null,null,"Insurance",null,null,null,null,null,null,null,null,null,null,null,"Common Cost Report Adjustments"]
["Facility Name","Ownership Type","License Type",null,"Management Company","Provider Number","County","Cost Report Start","Cost Report End"," Bed Capacity Last Day of Period ","Medicare Days"," Medicaid CT Days ","Medicaid Other States","Private Pay","State SSI","Other Resident Days","Total Resident Days","Medicaid Bed Reserve Days","Other Bed Reserve Days"," Actual and Imputed Resident Days ","Actual Occupancy","Total Direct Costs not Considering Options","Total Indirect Costs not Considering Options","Total A&G Costs not Considering Options","Total Capital Costs","Total Costs (RCR, New2)","Return on Equity","Total Direct Costs","Total Indirect Costs","Total A&G Costs","Total Capital/Other Costs","Total Costs","Difference",null,"Calculated Rate","Issued Rate",null,null,"Management Fees Direct","Management Fees Direct Adjustment","Management Fee Direct Net of Adjustment","Management Fees Indirect","Management Fees Indirect Adjustment","Management Fee Indirect Net of Adjustment"," Resident Day User Fee "," Equipment Lease "," Movable Equipment Depreciation "," Real Estate Taxes Paid By Owner "," Real Estate Taxes Paid By Lessor "," Personal Property Taxes "," Building Insurance "," Automobile Insurance "," Umbrella Insurance "," Fire and Extended Coverage Insurance "," Other Insurance "," Total Insurance Excluding AnG ","Capital Expense/Movable Equipment Adjustments","Depreciation on Unallowable Motor Vehicles Adjustment","Unallowable Property and Real Estate Taxes","Rental of Building Space or Rooms","Mortgage Insurance Adjustment","Property Insurance Adjustment",null,"Cell Phone Expense","Cell Phone Adjustment","Corporation Business Tax","Income Tax/Corporate Business Tax Adjustment","Holiday Parties for Staff","Gifts to Staff and Residents","Gifts, Flowers, and coffee Shop Adjustment","Management Fees","Unallowable Management Fees",null,"Dues and Membership Fees","Professional Dues Disallowed","Total Managerial Admin Comp Disallowed","Total Moveable Equipment Interest","Other Interest Expense","Interest Income on Accounts Receivable Adjustment","Building Depreciation and Interest Adjustment",null,"Depreciation/Amortization /Rent Expense","Building Interest Expense Net of Adjustment",null,"Total Wage Add-ons for the Periods 7/1/2019 (pro-rated to 10/1/2019), 10/1/2020, 1/1/2021, and 7/1/2021","Social Worker Minimum Staffing Rate Increase",null,"FRV","ROE",null,"Direct Care Cost Disallowed",null,"CMS Star Rating (Aug. 2021)","Long Stay QM (Aug. 2021)",null,"Special Values - Available Days"]
["Example Provider # 1","Profit","Nurs Fac-CCH",null,null,1,"Non-Fairfield County","2018-10-01","2019-09-30",57,3279,11716,0,4192,0,1144,20331,0,0,20331,{"$f":"ROUND(Q8/(J8*(I8-H8+1)),4)","v":0.97719999999999996},3001071.7793835402,1179924.09253537,968221.49497918005,528770,5677987.3668980896,20139.116379999999,{"$f":"V8+IF($AO$4=\"No\",0,-AO8)","v":3001071.7793835402},{"$f":"W8+IF($AR$4=\"No\",0,-AR8)","v":1179924.09253537},{"$f":"X8+IF($AR$4=\"Yes\",AR8,0)+IF($AO$4=\"Yes\",AO8,0)-IF($BM$4=\"No\",BM8,0)+IF($AZ$4=\"Yes\",AZ8,0)+IF($BA$4=\"Yes\",BA8,0)+IF($BB$4=\"Yes\",BB8,0)+IF($BC$4=\"Yes\",BC8,0)-IF($BW$4=\"No\",BW8,0)-IF($BX$4=\"No\",BX8,0)-IF($BT$4=\"No\",BT8,0)+IF($BY$4=3,BY8,0)+IF($BZ$4=3,BZ8,0)","v":968221.49497918005},{"$f":"Y8-IF($AZ$4=\"Yes\",AZ8,0)-IF($BA$4=\"Yes\",BA8,0)-IF($BB$4=\"Yes\",BB8,0)-IF($BC$4=\"Yes\",BC8,0)+IF($BY$4=4,BY8,0)+IF(B8=\"Profit\",IF($BZ$4=4,BZ8,0),IF($BZ$4=3,0,BZ8))+CA8","v":528770},{"$f":"SUM(AB8:AE8)","v":5677987.3668980906},{"$f":"Z8-AF8","v":0},null,300,290,null,null,0,0,{"$f":"SUM(AM8:AN8)","v":0},0,0,{"$f":"SUM(AP8:AQ8)","v":0},334575,0,0,0,0,0,0,0,0,31970,22486,0,0,0,0,0,0,0,null,1721,-641,-641,-641,-641,-641,-641,-641,0,null,4879,-2381.8000000000002,-126805.46966006,0,25088,0,0,null,553367,0,null,{"$f":"INDEX('Wage Add-On 6-30-2021 and 2022'!$N$6:$N$7,MATCH($F8,'Wage Add-On 6-30-2021 and 2022'!$C$6:$C$7,0))","v":20.189999999999998},null,null,10.90821897,0.99056201760857798,null,0,null,4,5,null,0]
["Example Provider # 2","Profit","Nurs Fac-CCH",null,null,2,"Fairfield County","2018-10-01","2019-09-30",135,2189,41556,0,1911,0,1271,46927,5,4,46936,{"$f":"ROUND(Q9/(J9*(I9-H9+1)),4)","v":0.95230000000000004},5024368.2581692804,2200663.3316809898,1500787.33658247,1228635,9954453.9264327995,12981.688824999999,{"$f":"V9+IF($AO$4=\"No\",0,-AO9)","v":5024368.2581692804},{"$f":"W9+IF($AR$4=\"No\",0,-AR9)","v":2200663.3316809898},{"$f":"X9+IF($AR$4=\"Yes\",AR9,0)+IF($AO$4=\"Yes\",AO9,0)-IF($BM$4=\"No\",BM9,0)+IF($AZ$4=\"Yes\",AZ9,0)+IF($BA$4=\"Yes\",BA9,0)+IF($BB$4=\"Yes\",BB9,0)+IF($BC$4=\"Yes\",BC9,0)-IF($BW$4=\"No\",BW9,0)-IF($BX$4=\"No\",BX9,0)-IF($BT$4=\"No\",BT9,0)+IF($BY$4=3,BY9,0)+IF($BZ$4=3,BZ9,0)","v":1500787.33658247},{"$f":"Y9-IF($AZ$4=\"Yes\",AZ9,0)-IF($BA$4=\"Yes\",BA9,0)-IF($BB$4=\"Yes\",BB9,0)-IF($BC$4=\"Yes\",BC9,0)+IF($BY$4=4,BY9,0)+IF(B9=\"Profit\",IF($BZ$4=4,BZ9,0),IF($BZ$4=3,0,BZ9))+CA9","v":1228635},{"$f":"SUM(AB9:AE9)","v":9954453.9264327399},{"$f":"Z9-AF9","v":5.9604644775390625E-8},null,250,270,null,null,0,0,{"$f":"SUM(AM9:AN9)","v":0},0,0,{"$f":"SUM(AP9:AQ9)","v":0},914937,0,0,0,0,0,0,0,105606,0,0,0,0,0,0,0,0,0,null,2714,-1274,-1274,-1274,-1274,-1274,-1274,-1274,-281609,null,15484,-9615.58,-13176.493567240001,0,0,0,0,null,1541542,0,null,{"$f":"INDEX('Wage Add-On 6-30-2021 and 2022'!$N$6:$N$7,MATCH($F9,'Wage Add-On 6-30-2021 and 2022'!$C$6:$C$7,0))","v":20.34},null,null,3.8820999999999999,0.27658276855718422,null,0,null,4,2,null,0]

{"sheet":"Wage Add-On 6-30-2021 and 2022","index":7,"n_rows":7,"n_cols":17,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Schedule of Nursing Facility Rate Increases"]
["Data as of March 15, 2022"]
[]
[]
["Provider Name","Provider Number","Provider Number","Provider Type","7/1/2019 Wage Increase",null," 7/1/2019 Wage Increase Prorated","7/1/2020 Rate","10/1/2020 Wage Increase 1%","10/1/2020 Rate","1/1/2021 Wage Increase 1%","1/1/2021 Rate Excluding CRF","7/1/2021 Wage Increase 4.5%","Total Wage Add-on at 7/1/2021","CY 2020 Fair Rent Add-On",null,"Social Worker Add-On Effective 1/1/2022"]
["Example Provider # 1",1,1,"CCNH",4.9000000000000004,null,{"$f":"ROUND(E6*9/12,2)","v":3.68},250.12,{"$f":"ROUND(H6*0.01,2)","v":2.5},{"$f":"H6+I6","v":252.62},{"$f":"ROUND(J6*0.01,2)","v":2.5299999999999998},{"$f":"J6+K6","v":255.15},{"$f":"ROUND(L6*0.045,2)","v":11.48},{"$f":"G6+I6+K6+M6","v":20.189999999999998},0]
["Example Provider # 2",2,2,"CCNH",4.93,null,{"$f":"ROUND(E7*9/12,2)","v":3.7},251.99,{"$f":"ROUND(H7*0.01,2)","v":2.52},{"$f":"H7+I7","v":254.51000000000002},{"$f":"ROUND(J7*0.01,2)","v":2.5499999999999998},{"$f":"J7+K7","v":257.06},{"$f":"ROUND(L7*0.045,2)","v":11.57},{"$f":"G7+I7+K7+M7","v":20.34},0.04]

{"sheet":"Medicaid CR Crosswalk","index":8,"n_rows":57,"n_cols":12,"rows_kept":57,"cut":false,"hidden":false,"merged":[[64,1,64,11],[0,1,0,11],[5,2,5,3],[5,4,5,5],[5,6,5,7],[5,8,5,9],[5,10,5,11],[5,0,5,1]]}
[null,"\n"]
["Connecticut Department of Social Services"]
["Medicaid Cost Report Crosswalk"]
[]
[]
["Direct Care Expenses",null,"Indirect Expenses",null,"Administrative and General Expenses",null,"Capital Expenses",null,"Fringes*",null,"Non-Reimbursable"]
[null,"Salaries",null,"Salaries","10/A1","Owners and Operators",null,"Capital",null,"Daycare Workers","10/A9","Barber and Beautician Services"]
["10/A12A","Director and Assistant Director of Nurses","10/A5A","Head Dietician","10/A2","Administrators","15/1K3","Resident Day User Fee","15/1A1","Workmen's compensation","10/A12G","Occupational Therapy"]
["10/A12B1","RN - Direct Care","10/A5B","Food Service Supervisor","10/A3","Assistant Administrators","20/6E","Equipment Lease","15/1A2","Disability insurance","10/A12I3","Resident Care Physicians Salaries"]
["10/A12B2","RN - Administrative","10/A5C","Dietary Workers","10/A4","Other Administrative Salaries","22/7D","Movable equipment Depreciation","15/1A3","Unemployment insurance","13/B8C","Resident Care Physicians Fees"]
["10/A12C1","LPN - Direct Care","10/A6A","Head Housekeeper","10/A7A","Engineer or Chief of Maintenance","22/10A","Real estate taxes paid by owner","15/1A4","Social security (FICA)","13/B10A","Resident Care Occupational Therapists"]
["10/A12C2","LPN - Administrative","10/A6B","Other Housekeeping Workers","10/A7B","Other Maintenance Workers","22/10B","Real estate taxes paid by lessor","15/1A5","Health Insurance","13/B10B","Other Occupational Therapists"]
["10/A12D","Aides and Attendants","10/A8A","Laundry Supervisor","10/A10","Protective Services","22/10C","Personal property taxes","15/1A6","Life insurance","15/1B","Owner's Pension and Profit-Sharing Plans"]
[null,null,"10/A8B","Other Laundry Workers","10/A11A","Head Accountant","27/14A","Buildings Insurance","15/1A7","Employee pensions","15/1C","Bad Debts"]
[null,"Fees","10/A12E","Physical Therapists","10/A11B","Other Accountants","27/14B","Automobile Insurance","15/1A8","Uniform allowances","15/1F","Insurance on Lives of Owners"]
["13/B11A1","RN - Direct Care","10/A12F","Speech Therapists","15/1D","Accounting and auditing","27/14C1","Umbrella Insurance","15/1A9","Other employee health and welfare","15/1I","Appraisals"]
["13/B11A2","RN - Administrative","10/A12H","Recreation Workers","15/1E","Legal","27/14C2","Fire and extended coverage Insurance",null,null,"15/1K1","Income Taxes"]
["13/B11B1","LPN - Direct Care","10/A12I1","Medical Director","15/1G","Office supplies","27/14C3","Other Insurance ",null,null,"16/M2","Telephone Directory Advertising"]
["13/B11B2","LPN - Administrative","10/A12I2","Utilization Review","15/1H1","Telephone ",null,null,null,null,"16/M3","Other Advertising"]
["13/B11C","Aides and Attendants","10/A12I4","Other Physicians","15/1H2","Cellular Phone ",null,null,null,null,"16/M4","Fund raising"]
["13/B11D","Other Nurses and Aides and Attendants","10/A12J","Dentist","15/1J","Corporation business taxes",null,"Interest and Depreciation Replaced by Fair Rent",null,null,"16/M6","Barber and Beauty Supplies"]
[null,"Nursing Pool Costs","10/A12K","Pharmacists","15/1K2","Other taxes not related to property","22/7A","Land improvements Depreciation",null,null,"16/M8a","Dues to Chamber of Commerce"]
["20/5J","Management Fees Direct","10/A12L","Podiatrist","16/L1","Resident travel and entertainment","22/7B","Buildings and building improvements Depreciation",null,null,"16/M10","Contributions"]
[null,null,"10/A12M","Social Workers/Case Management","16/L2","Holiday parties for staff","22/7C","Non-movable equipment Depreciation",null,null,"20/5A1","Own pharmacy prescription drugs"]
[null,null,"10/A12O","Other Salaries","16/L3","Gifts to staff and residents","22/8B","Mortgage expense",null,null,"20/5A2","Purchased prescription drugs"]
[null,null,null,"Fees","16/L4","Employee travel","22/8C","Leasehold Improvements Amortization",null,null,"20/5D","Ambulances and limousines"]
[null,null,"13/B1","Dietitians","16/L5","Education expense","22/8D","Other Amortization",null,null,"20/5e2","Other oxygen"]
[null,null,"13/B2","Dentists","16/L6","Automobile expense","22/9","Rental of real property less real estate taxes",null,null,"20/5f","X-rays and radiological procedures"]
[null,null,"13/B3","Pharmacists","16/L7","Other travel and entertainment","26/12B7","Building and non-movable equipment Interest ",null,null,"20/5h","Laboratory"]
[null,null,"13/B4","Podiatrists","16/M1","Help wanted advertising","27/12C1","Automobile equipment interest expense"]
[null,null,"13/B5A","Resident Care Physical Therapists","16/M5","Medical records","27/12C2","Movable equipment interest expense"]
[null,null,"13/B5B","Other Physical Therapists","16/M7","Postage","27/12D","Other interest expense"]
[null,null,"13/B6","Social Workers","16/M8","Dues and membership fees"]
[null,null,"13/B7","Recreation Workers","16/M9","Subscriptions"]
[null,null,"13/B8A","Medical Director","16/M11","Services provided by contract"]
[null,null,"13/B8B","Utilization Review Physicians","16/M12","Administrative management services"]
[null,null,"13/B8D1","Infection Control Committee","16/M13","Other administrative and general expense"]
[null,null,"13/B8D2","Pharmaceutical Committee","22/6A","Repair and maintenance"]
[null,null,"13/B8D3","Staff Development Committee","22/6B","Heat"]
[null,null,"13/B8E","Other Physicians","22/6C","Light and Power"]
[null,null,"13/B9A","Resident Care Speech Therapists","22/6D","Water"]
[null,null,"13/B9B","Other Speech Therapists","20/6F","Other Maintenance and Operation of Plant Expense"]
[null,null,"13/B12","Other Fees","22/8A","Organization Expense"]
[]
[null,null,"18/2D","Non Salary Dietary Expense"]
[null,null,"19/3D","Non Salary Laundry Expense"]
[null,null,"20/4D","Non Salary Housekeeping Expense"]
[null,null,"20/5B","Medicine cabinet drugs"]
[null,null,"20/5C","Medical and therapeutic supplies"]
[null,null,"20/5E1","Emergency use oxygen"]
[null,null,"20/5G","Dental supplies"]
[null,null,"20/5I","Recreation Supplies"]
[null,null,"20/5K","Management Fees Indirect"]
[null,null,"20/5L","Other resident care expenses "]
[]
[]
["* Fringes: Fringes are allocated on the basis of salaries to all rate components. "]

{"sheet":"Inflation","index":9,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[14,1,14,6],[0,0,0,1],[5,1,5,6],[13,1,13,6],[6,1,6,6],[23,1,23,5],[24,1,24,5],[25,1,25,5],[20,1,20,6],[21,1,21,6]]}
[]
["Connecticut Department of Social Services"]
["Inflation"]
[]
["Inflation Information:"]
[null,"2020 Fourth Quarter Healthcare Cost Review"]
[null,"Table 6.7 CMS Nursing Home Without Capital Market Basket (FFY)"]
[null,null,"Begin","End","Mid","Quarter"]
[null,"Cost Reports:","2018-10-01","2019-09-30","2019-03-31","2019:1",1.1240000000000001]
[null,"Rates:","2021-07-01","2022-06-30","2021-12-31","2021:4",1.1950000000000001]
[null,"Inflation:",null,null,null,null,{"$f":"ROUND(+G10/G9,4)","v":1.0631999999999999}]
[]
[]
[null,"2020 Fourth Quarter Healthcare Cost Review"]
[null,"Table 7 CPI All Items Northeast (CY)"]
[null,null,"Begin","End","Mid","Quarter"]
[null,"Cost Reports:","2018-10-01","2019-09-30","2019-03-31","2019:1",267.3]
[null,"Rates:","2021-07-01","2022-06-30","2021-12-31","2021:4",282.10000000000002]
[null,"Inflation:",null,null,null,null,{"$f":"ROUND(+G18/G17,4)","v":1.0553999999999999}]
[]
[null,"RSMeans"]
[null,"Construction Cost Indexes with RSMeans Data"]
[]
[null,"January 2019 Connecticut Weighted Average",null,null,null,null,244.41]
[null,"January 2021 Connecticut Weighted Average",null,null,null,null,257.74]
[null,"Inflation:",null,null,null,null,{"$f":"ROUND(+G25/G24,4)","v":1.0545}]

{"sheet":"Medicaid CMI","index":10,"n_rows":9,"n_cols":58,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,3,5,6],[5,8,5,11],[5,48,5,51],[5,13,5,16],[5,18,5,21],[5,23,5,26],[5,28,5,31],[5,33,5,36],[5,38,5,41],[5,43,5,46]]}
[]
["Connecticut Department of Social Services"]
["Medicaid CMI Calculations"]
[]
[1,2,3,4,5,6,7]
[null,null,null,"Preliminary Q1 2020",null,null,null,null,"Final Q1 2020",null,null,null,null,"Final Q2 2020",null,null,null,null,"Final Q3 2020",null,null,null,null,"Final Q4 2020",null,null,null,null,"Final Q1 2021",null,null,null,null,"Prelim Q2 2021",null,null,null,null,"Final Q3 2021",null,null,null,null,"Final Q4 2021"]
["Medicaid Number","CMS Facility Internal ID","Provider Name","Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,"Medicaid Residents","Medicaid Points","Medicaid Days","Medicaid Avg CMI",null,null,null,null,null,null,"Provider  Attributes",null,"CMI By Quarter Selection",null,"CMI Rank"]
[1,1,"Example Provider # 1",46,3492.1,3192,1.0940162907268169,null,46,3499.6,3192,1.0963659147869673,null,40,3263.27,3011,1.0837827964131517,null,49,3497.68,3221,1.0858987891959018,null,40,3067.76,2842,1.0793999999999999,null,40,3010.26,2681,1.1228,null,41,3032.92,2766,1.0965,null,41,3023.73,2808,1.0768,null,38,2346.7399999999998,2221,1.0566,null,null,null,null,null,null,null,null,{"$f":"IF('Options and Impact'!$C$35='Data Validation'!$A$54,'Medicaid CMI'!$L8,IF('Options and Impact'!$C$35='Data Validation'!$A$55,'Medicaid CMI'!$Q8,IF('Options and Impact'!$C$35='Data Validation'!$A$56,'Medicaid CMI'!$V8,IF('Options and Impact'!$C$35='Data Validation'!$A$57,'Medicaid CMI'!$AA8,IF('Options and Impact'!$C$35='Data Validation'!$A$58,'Medicaid CMI'!$AF8,IF('Options and Impact'!$C$35='Data Validation'!$A$59,'Medicaid CMI'!$AK8,IF('Options and Impact'!$C$35='Data Validation'!$A$60,$AP8,IF('Options and Impact'!$C$35='Data Validation'!$A$61,$AU8,))))))))","v":1.0566},null,{"$f":"RANK(BD8,$BD$8:$BD$9)","v":1}]
[2,2,"Example Provider # 2",142,9577.4699999999993,10432,0.91808569785276062,null,140,9503.52,10421,0.91195854524517805,null,119,6698.06,6586,1.0170148800485879,null,97,7393.4,6877,1.0750908826523193,null,113,7813.84,7837,0.997,null,110,7212.11,7363,0.97950000000000004,null,116,8302.0499999999993,8384,0.99019999999999997,null,121,8510.82,8830,0.96389999999999998,null,126,8548.73,8809,0.97050000000000003,null,null,null,null,null,null,null,null,{"$f":"IF('Options and Impact'!$C$35='Data Validation'!$A$54,'Medicaid CMI'!$L9,IF('Options and Impact'!$C$35='Data Validation'!$A$55,'Medicaid CMI'!$Q9,IF('Options and Impact'!$C$35='Data Validation'!$A$56,'Medicaid CMI'!$V9,IF('Options and Impact'!$C$35='Data Validation'!$A$57,'Medicaid CMI'!$AA9,IF('Options and Impact'!$C$35='Data Validation'!$A$58,'Medicaid CMI'!$AF9,IF('Options and Impact'!$C$35='Data Validation'!$A$59,'Medicaid CMI'!$AK9,IF('Options and Impact'!$C$35='Data Validation'!$A$60,$AP9,IF('Options and Impact'!$C$35='Data Validation'!$A$61,$AU9,))))))))","v":0.97050000000000003},null,{"$f":"RANK(BD9,$BD$8:$BD$9)","v":2}]

{"sheet":"Normalizing CMI","index":11,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,8,0,10],[0,0,0,2],[5,0,7,0],[5,1,7,1],[5,2,7,2],[5,7,5,9],[5,4,5,6]]}
[]
["Connecticut Department of Social Services"]
["Normalizing CMI Calculations"]
[]
[1,2,3,null,20,21,22]
["Medicaid Number","CMS Facility Internal ID","Provider Name",null,"Annual CMIs with BC1 days included for the Period of 10/01/2018 - 9/30/2019",null,null,"Annual CMIs with BC1 days excluded for the Period of 10/01/2018 - 9/30/2019"]
[null,null,null,null,"Total","Total","Normalized ","Total","Total","Normalized "]
[null,null,null,null,"Points Four Quarters","Days Four Quarters","CMI Based on 4 Quarters","Points Four Quarters","Days Four Quarters","CMI Based on 4 Quarters",null,"Provider Attributes"]
[1,1,"Example Provider # 1",null,23216.879999999997,21609,{"$f":"ROUND(E9/F9,4)","v":1.0744},23939.65,21263,{"$f":"ROUND(H9/I9,4)","v":1.1258999999999999}]
[2,2,"Example Provider # 2",null,42857.479999999996,46917,{"$f":"ROUND(E10/F10,4)","v":0.91349999999999998},42878.479999999996,46917,{"$f":"ROUND(H10/I10,4)","v":0.91390000000000005}]

{"sheet":"Source and Assumptions","index":12,"n_rows":70,"n_cols":8,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,7,0,13],[17,0,17,12],[19,0,19,12],[4,0,4,12],[68,0,68,12],[22,0,22,12],[27,0,27,12],[33,0,33,12],[39,0,39,12],[59,0,59,12],[24,0,24,12],[54,0,54,12],[55,0,55,12],[45,0,45,12],[64,0,64,12]]}
[null,null,null,null,null,null,null,"This model is Confidential and Deliberative, and is in draft form for modeling analysis.  This model is iterative and will be updated as decisions or DSS requests are made.  A final version will be completed subject to QA and final decision making prior to rate issuance."]
["Connecticut Department of Social Services"]
["Source Data and Assumptions of the Rate Model"]
[]
["Options and Impact Tab"]
["The following cost assignments on the options and impact tab represent the current reimbursement system:"]
[" Reclass Management Fees Direct and Indirect set to No"]
["  Administrative and General Options set to Yes"]
["  Capital Included in A&G set to No"]
["  Movable Equipment Interest and Other Interest Expense Included in allowable cost Set to No"]
["  Return on Equity set to Yes"]
["  Aids Modeled as Standard NF set to No"]
["  RHNS as Standard NF set to Combined"]
["  SLTC as Standard NF set to CCH only"]
["  Percentage of Median to apply as Limit: "]
["    Direct Care Component Limitation: 135% of the median"]
["    Indirect Care Component Limitation: 115% of the median"]
["    Indirect Care Component Efficiency Adjustment: 100% of the median - If the allowable per diem costs are less 100% of the median an  efficiency  adjustment is added to the rate equal to 25% of the difference between the per diem allowable costs and 100% of the median."]
["  Administrative and General Limitation: 100% of the median"]
["  Administrative and General Component Efficiency Adjustment: 100% of the median - If the allowable per diem costs are less 100% of the median an efficiency adjustment is added to the rate equal to 25% of the difference between the per diem allowable costs and 100% of the median."]
[]
[]
["Facility Profile"]
["Source: Selected Model Options based on rate setting parameters selected on the Options and Impact tab."]
["Source: Facility Costs based on facility costs from the 9/30/2019 Rate Computation Report adjusted to consider options selected on the Options and Impact tab."]
[]
[]
["Rate Calculation"]
["Source: General Provider Information and costs in columns M, V, AD, AL, AP, AT and AU are based on the 9/30/2019 Rate Computation Reports."]
["Assumption: 9 months of the 7/1/2019 Wage Increases were added into modeled rates in column AX, as the associated expense is not included in 9/30/2019 costs.  "]
["Note:  Seven providers had bed changes during the period, therefore, the bed days available calculation is adjusted to account for the change."]
[]
[]
["Medians"]
["Source: Medians for each cost component were calculated based on data in the 2019 Rate Computation Reports."]
["Source: Medians were calculated based on all nursing facilities combined as well as Fairfield and Non-Fairfield Counties separately"]
["Assumption: SLTC and Aides levels of care have been excluded from the Median calculation."]
[]
[]
["9/30/19 Costs Annualized"]
["Source: Cost Year 2019 Rate Computation Reports as of March 2021. "]
["Source: Issued rates in column H as of October 2020."]
["Assumption: Providers with an * in column C have the costs for both the CCNH and RHNS levels of care combined."]
["Note: Days and costs for providers with a short period/long period cost report were annualized/pro-rated to 365 days (4 providers)"]
[]
["9/30/19 Costs Original"]
["Source: Cost Year 2019 Rate Computation Reports as of March 2021. "]
["Source: Issued rates in column AJ as of August 2021."]
["Source: Special agreed on available days are included for two providers."]
["Assumption: Providers with an * in column D have the costs for both the CCNH and RHNS/STLC levels of care combined."]
["Note:  Seven providers had bed changes during the period, therefore, the bed days available calculation is adjusted to account for the change."]
["Note:  The wage add-on is inclusive of wage add-ons given for the 7/1/2019, 10/1/2020, 1/1/2021 and 7/1/2021 time periods. "]
["             The 10/1/2019 amounts were pro-rated to 9 months since some of the add-on would be included in the cost report."]
[]
["Medicaid Cost Report Cross Walk"]
["Source:  Cost report groupings are shown based on the rate components they are included within, this could be subject to change based on the modeling options chosen on the Options tab"]
["Note: Fringe benefits are allocated on the basis of salaries for all rate components"]
[]
[]
["Inflation"]
["Source: IHS Market Healthcare Cost Review 2020 Fourth Quarter, Tables 6.7 and 7."]
["Source: RSMeans Construction Index from the RSMeans publication, January 2019 and January 2021"]
[]
[]
["Medicaid CMI"]
["Source: Based on data provided by The Department of Health"]
["Regal Care Greenwich and Wolocott View Manor are temporary closures. The average CMI was used pending new quarterly assessments."]
[]
["Normalizing CMI"]
["Source: Based on data provided by The Department of Health"]

{"sheet":"Providers","index":13,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[5,0,5,5]]}
[]
["Connecticut Department of Social Services"]
["Provider Selection Analysis"]
["Note: Please do not sort this tab."]
[null,null,null,null,null,null,null,null,"Count:",{"$f":"SUM(--(LEN(TRIM(J8:J9))>0))","v":2},null,"Count:",{"$f":"SUM(--(LEN(TRIM(M8:M9))>0))","v":0}]
["Options Indicators",null,null,null,null,null,null,"Hard coded indicators",null,"Hard coded provider numbers",null,null,"Do Not Edit This Column.  Dynamic array based on Options selected."]
["Indicator\nCCH Only","Indicator\nAIDS","Indicator\nRHNS","Indicator\nSLTC","Indicator\nSecureCare","SUM","Include","Special Indicator","Facility Name","Provider Number",null,null,"Provider Numbers to Include"]
[{"$f":"IF(H8=\"CCH Only\",1,0)","v":1},{"$f":"IF(AND('Options and Impact'!$C$37=\"Yes\",OR(H8=\"AIDS Only\",H8=\"CCH/AIDS\")),1,IF(AND('Options and Impact'!$C$37=\"No\",H8=\"CCH No AIDS\"),1,0))","v":0},{"$f":"IF(H8=\"RHNS Only\",1,IF(AND('Options and Impact'!$C$39=\"CCH / RHNS Separate\",OR(H8=\"CCH No RHNS\",H8=\"RHNS\")),1,IF(AND('Options and Impact'!$C$39=\"CCH / RHNS Combined\",H8=\"CCH/RHNS\"),1,IF(AND('Options and Impact'!$C$39=\"CCH Only\",H8=\"CCH No RHNS\"),1,0))))","v":0},{"$f":"IF(AND('Options and Impact'!$C$41=\"CCH / SLTC Separate\",OR(H8=\"CCH No SLTC\",H8=\"SLTC\")),1,IF(AND('Options and Impact'!$C$41=\"CCH / SLTC Combined\",H8=\"CCH/SLTC\"),1,IF(AND('Options and Impact'!$C$41=\"CCH Only\",H8=\"CCH No SLTC\"),1,0)))","v":0},{"$f":"IF(AND('Options and Impact'!$C$43='Data Validation'!$A$48,H8=\"SecureCare CCH Only\"),1,0)","v":0},{"$f":"SUM(A8:E8)","v":1},{"$f":"IF(F8>0,\"Yes\",\"No\")","v":"Yes"},"CCH Only","Example Provider # 1",1,null,null,{"$f":"IFERROR(INDEX($J$8:$J$9,SMALL(IF($G$8:$G$9=\"Yes\",ROW($J$8:$J$9)),ROW(#REF!))-7,1),\"\")","v":""}]
[{"$f":"IF(H9=\"CCH Only\",1,0)","v":1},{"$f":"IF(AND('Options and Impact'!$C$37=\"Yes\",OR(H9=\"AIDS Only\",H9=\"CCH/AIDS\")),1,IF(AND('Options and Impact'!$C$37=\"No\",H9=\"CCH No AIDS\"),1,0))","v":0},{"$f":"IF(H9=\"RHNS Only\",1,IF(AND('Options and Impact'!$C$39=\"CCH / RHNS Separate\",OR(H9=\"CCH No RHNS\",H9=\"RHNS\")),1,IF(AND('Options and Impact'!$C$39=\"CCH / RHNS Combined\",H9=\"CCH/RHNS\"),1,IF(AND('Options and Impact'!$C$39=\"CCH Only\",H9=\"CCH No RHNS\"),1,0))))","v":0},{"$f":"IF(AND('Options and Impact'!$C$41=\"CCH / SLTC Separate\",OR(H9=\"CCH No SLTC\",H9=\"SLTC\")),1,IF(AND('Options and Impact'!$C$41=\"CCH / SLTC Combined\",H9=\"CCH/SLTC\"),1,IF(AND('Options and Impact'!$C$41=\"CCH Only\",H9=\"CCH No SLTC\"),1,0)))","v":0},{"$f":"IF(AND('Options and Impact'!$C$43='Data Validation'!$A$48,H9=\"SecureCare CCH Only\"),1,0)","v":0},{"$f":"SUM(A9:E9)","v":1},{"$f":"IF(F9>0,\"Yes\",\"No\")","v":"Yes"},"CCH Only","Example Provider # 2",2,null,null,{"$f":"IFERROR(INDEX($J$8:$J$9,SMALL(IF($G$8:$G$9=\"Yes\",ROW($J$8:$J$9)),ROW(#REF!))-7,1),\"\")","v":""}]

{"sheet":"Data Validation","index":14,"n_rows":61,"n_cols":2,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Data Validation"]
["Internal Use- Do Not Use"]
[]
["Peer Groups"]
["1 -All Facilities"]
["2/3 - Fairfield, Non-Fairfield"]
[]
[]
[]
["Type of System"]
["Cost Based"]
["Price Based"]
["Inflation Factor Options"]
["Consumer Price Index","Consumer Price Index"]
["Nursing Home Without Capital Market Basket","RS Means"]
["RS Means"]
[]
[]
[]
["Yes"]
["No"]
[]
[]
["Yes - Box 3"]
["Yes - Box 4"]
["No"]
[]
[]
["Four QTR Avg-BCI Included"]
["Four QTR Avg-BCI Excluded"]
[]
[]
[]
["Corridor"]
["Blended (Direct Only)"]
["Blended (All)"]
[]
["CCH Only"]
["CCH / RHNS Separate"]
["CCH / RHNS Combined"]
[]
["CCH Only"]
["CCH / SLTC Separate"]
["CCH / SLTC Combined"]
[]
["Include"]
["Exclude"]
[]
["Model Only"]
["Model After Phase-In/BAF"]
[]
["2020 Q1"]
["2020 Q2"]
["2020 Q3"]
["2020 Q4"]
["2021 Q1"]
["2021 Q2"]
["2021 Q3"]
["2021 Q4"]