{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Schedule H - Rate History","Reconciliation","Other Codes","List"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":11,"defined_names":2724,"comments":1,"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":"Schedule H - Rate History","index":0,"n_rows":48,"n_cols":49,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,43,0,45],[1,0,1,2],[1,3,1,4],[1,5,1,8],[0,0,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,10],[0,11,0,35],[0,36,0,38],[0,41,0,42]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,List!A2:C145,2,FALSE)","v":555777999},null,null,null,"FOR PROVIDER USE ONLY\nDO NOT SUBMIT WITH COST REPORT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ANNUAL SERVICES\n PAID BY PROGRAM TYPE",null,null,null,{"$f":"IF(AN1=\"\",\"\",AH2+AI2+AJ2)","v":""},null,null,"PROFESSIONAL SERVICES",null,null,null,"Professional Svs Paid Calculation",{"$f":"SUM(AV4:AV43)","v":0}]
["Report Period",null,null,"2020-01-01",null,"2020-12-31",null,null,null,{"$f":"IF($AN$1=\"\",SUM(J4:J42),SUMIF($E$4:$E$42,$AN$1,J4:J42))","v":5797},{"$f":"IF($AN$1=\"\",SUM(K4:K42),SUMIF($E$4:$E$42,$AN$1,K4:K42))","v":22},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Totals",{"$f":"IF($AN$1=\"\",SUM(AH4:AH42),SUMIF($E$4:$E$42,$AN$1,AH4:AH42))","v":1261382.9500000004},23469.8,28115.450000000004,9055.630000000001,1322023.83,245123.7399999999,9738.9599999999955,5885.1500000000005,0,10636.559999999998,19212.409999999996,290596.82,1612620.6499999997,1612620.65,0,5797]
["Client Name (b) ","House or Cluster","Client P1 ID (c)","P1 Service Code/RAC (w)","Program Type","Rate Effective Date (d)","Actual Start Date (Overrides Rate Effective Date)","Rate End Date","Actual End Date (Overrides Rate End Date)","Resid Days Paid","Client Count","ISS Tier Level (e)","ISS Daily Tier Rate (f)","Prof Svs Hrs PCD 1 (g)","Prof Svs Hrly Rate 1 (h)","Prof Svs Hrs PCD 2 (i)","Prof Svs Hrly Rate 2 (j)","Prof Svs Hrs PCD 3","Prof Svs Hrly Rate 3","Prof Svs Hrs PCD 4","Prof Svs Hrly Rate 4","ISS Prof Svs Daily Rate","ISS CRST Tier Rate (l)","ISS Hold Harmless Rate (m)","Total ISS Daily Rate","Admin Tier Rate (o)","Admin Hold Harmless (p)","Admin CRST Tier Rate (q)","Admin Cert Rate (r)","Transportation Rate (s)","Other Non-ISS Rates (t)","Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Paid","Annual ISS CRST Paid","Annual ISS Hold Harmless Paid","Annual ISS Prof Svs Paid","Total Annual ISS Paid","Annual Admin Paid","Annual Admin Hold Harmless Paid","Annual Admin CRST Paid","Annual Admin Cert Paid","Annual Transportation Paid","Annual Other Non-ISS Paid","Total Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Total ISS & Non-ISS Paid per Client","Prof Svs Paid Calculation","Total Days Paid per Client"]
["Client A","House 1",500,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-12-31",null,{"$f":"IF(F4>0,+IF(I4>0,I4,H4)-IF(G4>0,G4,F4)+1,0)","v":365},{"$f":"IF(C4<=0,\"\",IF(C4=C3,\"\",1))","v":1},4,291.70999999999998,null,null,null,null,-30,-30,-30,-30,{"$f":"ROUND(+N4*O4+P4*Q4,2)","v":0},5.42,4.8499999999999996,{"$f":"(M4+V4+W4+X4)","v":301.98},57.97,1.68,1.36,0,0,0,{"$f":"SUM(Z4:AE4)","v":61.01},{"$f":"+Y4+AF4","v":362.99},{"$f":"M4*J4","v":106474.15},{"$f":"W4*J4","v":1978.3},{"$f":"X4*J4","v":1770.2499999999998},{"$f":"ROUND(+N4*O4+P4*Q4,2)*J4","v":0},{"$f":"$J4*Y4","v":110222.70000000001},{"$f":"$J4*Z4","v":21159.05},{"$f":"$J4*AA4","v":613.19999999999993},{"$f":"$J4*AB4","v":496.40000000000003},{"$f":"$J4*AC4","v":0},{"$f":"J4*AD4","v":0},{"$f":"$J4*AE4","v":0},{"$f":"$J4*AF4","v":22268.649999999998},{"$f":"AL4+AS4","v":132491.35},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4805,$A4,AL$4:AL$4805))+IF(A5=A4,0,SUMIF($A$4:$A$4805,$A4,AS$4:AS$4805))","v":132491.35},{"$f":"IF($O4=$AU$1,ROUND($N4*$O4,2)*$J4,0)+IF($Q4=$AU$1,ROUND($P4*$Q157,2)*$J4,0)","v":0},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4805,$A4,J$4:J$4805))+IF(A5=A4,0,SUMIF($A$4:$A$4805,$A4))","v":365}]
["Client B","House 1",502,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-12-31",null,365,1,3,223.56,null,null,null,null,-27,-27,-27,-27,{"$f":"ROUND(+N5*O5+P5*Q5,2)","v":0},4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,20669.95,613.19999999999993,379.6,0,0,0,21662.75,106550.8,106550.8,0,365]
["Client C","House 1",503,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-06-30",null,181,1,2,144.81,null,null,null,null,-26,-26,-26,-26,0,2.69,4.8499999999999996,152.35,54.84,1.68,0.68,0,0,2.5,59.7,212.05,26210.61,486.89,877.84999999999991,0,27575.35,9926.0400000000009,304.08,123.08000000000001,0,0,452.5,10805.7,38381.050000000003,0,0,0]
["Client C","House 1",503,"SA722-3603 GH CORE","GH Group Home","2019-07-01",null,"2019-12-31",null,184,"",2,144.81,null,null,null,null,-25,-25,-25,-25,0,2.69,4.8499999999999996,152.35,54.84,1.68,0.68,0,0,0,57.2,209.55,26645.040000000001,494.96,892.4,0,28032.399999999998,10090.560000000001,309.12,125.12,0,0,0,10524.800000000001,38557.199999999997,76938.25,0,365]
["Client D","House 2",505,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-12-31",null,365,1,4,291.70999999999998,null,null,null,null,-23,-23,-23,-23,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,2.5,63.51,365.49,106474.15,1978.3,1770.2499999999998,0,110222.70000000001,21159.05,613.19999999999993,496.40000000000003,0,0,912.5,23181.149999999998,133403.85,133403.85,0,365]
["Client E","House 2",506,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-12-31",null,365,1,4,291.70999999999998,null,null,null,null,-22,-22,-22,-22,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,0,61.01,362.99,106474.15,1978.3,1770.2499999999998,0,110222.70000000001,21159.05,613.19999999999993,496.40000000000003,0,0,0,22268.649999999998,132491.35,132491.35,0,365]
["Client F","House 2",508,"SA722-3603 GH CORE","GTH Group Training Home","2019-01-01",null,"2019-12-31","2019-01-21",21,1,3,223.56,null,null,null,null,-19,-19,-19,-19,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,4694.76,87.36,101.85,0,4883.97,1189.23,35.28,21.84,0,0,0,1246.3500000000001,6130.3200000000006,6130.3200000000006,0,21]
["Client 01","Cluster 1",509,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,1,2,144.81,0.2,38.75,null,null,-17,-17,-17,-17,7.75,2.69,4.8499999999999996,160.1,34.020000000000003,1.68,0.68,0,2.25,2.5,41.13,201.23,52855.65,981.85,1770.2499999999998,{"$f":"ROUND(+N11*O11+P11*Q11,2)*J11","v":2828.75},58436.5,12417.300000000001,613.19999999999993,248.20000000000002,0,821.25,912.5,15012.45,73448.95,73448.95,0,365]
["Client 02","Cluster 1",510,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31","2019-06-30",181,1,3,223.56,null,null,null,null,-16,-16,-16,-16,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.25,13.87,54.65,287.21999999999997,40464.36,752.96,877.84999999999991,{"$f":"ROUND(+N12*O12+P12*Q12,2)*J12","v":0},42095.17,6481.6100000000006,304.08,188.24,0,407.25,2510.4699999999998,9891.65,51986.82,51986.82,0,181]
["Client 02 (Client 8) COCA","Cluster 1",510,"SA716-3603 SL CORE","SL Supported Living","2019-07-01",null,"2019-07-31",null,31,"",3,223.56,null,null,null,null,-15,-15,-15,-15,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.25,13.87,54.65,287.21999999999997,6930.36,128.96,150.35,0,7209.67,1110.1100000000001,52.08,32.24,0,69.75,429.96999999999997,1694.1499999999999,8903.82,8903.82,0,31]
["Client 03","Cluster 1",511,"SA716-3603 SL CORE","SL Supported Living","2019-08-01","2019-08-03","2019-12-31","2019-10-31",90,1,2,144.81,null,null,null,null,-14,-14,-14,-14,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,1.85,7.9,46.13,198.48,13032.9,242.1,436.49999999999994,0,13711.5,3061.8,151.19999999999999,61.2,0,166.5,711,4151.7,17863.2,17863.2,0,90]
["Client 03 (Client 12) COCA","Cluster 1",511,"SA716-3603 SL CORE","SL Supported Living","2019-11-01",null,"2019-12-31",null,61,"",2,144.81,null,null,null,null,-13,-13,-13,-13,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,3.5,10.44,50.32,202.67,8833.41,164.09,295.84999999999997,0,9293.35,2075.2200000000003,102.47999999999999,41.480000000000004,0,213.5,636.83999999999992,3069.52,12362.87,12362.87,0,61]
["Client 04","Cluster 2",512,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31","2019-02-28",59,1,3,223.56,null,null,null,null,-12,-12,-12,-12,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,1.85,10.44,50.82,283.39,13190.04,245.44,286.14999999999998,0,13721.63,2112.79,99.11999999999999,61.36,0,109.15,615.95999999999992,2998.38,16720.009999999998,0,0,0]
["Client 04","Cluster 2",512,"SA716-3603 SL CORE","SL Supported Living","2019-03-01",null,"2019-12-31",null,306,"",3,223.56,0.35,26.5,null,null,-11,-11,-11,-11,9.2799999999999994,4.16,4.8499999999999996,241.85,35.81,1.68,1.04,0,4.58,7.9,51.01,292.86,68409.36,1272.96,1484.1,2839.68,74006.099999999991,10957.86,514.07999999999993,318.24,0,1401.48,2417.4,15609.06,89615.159999999989,106335.17,{"$f":"IF($O17=$AU$1,ROUND($N17*$O17,2)*$J17,0)+IF($Q17=$AU$1,ROUND($P17*$Q170,2)*$J17,0)","v":0},365]
["Client 05","Cluster 2",513,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31","2019-11-27",331,1,3,223.56,null,null,null,null,-10,-10,-10,-10,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,1.88,2.5,42.910000000000004,275.48,73998.36,1376.96,1605.35,0,76980.67,11853.11,556.07999999999993,344.24,0,622.28,827.5,14203.210000000001,91183.88,91183.88,{"$f":"IF($O18=$AU$1,ROUND($N18*$O18,2)*$J18,0)+IF($Q18=$AU$1,ROUND($P18*$Q171,2)*$J18,0)","v":0},331]
["Client 06","Cluster 2",514,"SA716-3603 SL CORE","SL Supported Living","2019-05-18","2019-05-15","2019-12-31",null,231,1,3,223.56,null,null,null,null,-9,-9,-9,-9,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.35,0,40.880000000000003,273.45,51642.36,960.96,1120.3499999999999,0,53723.67,8272.11,388.08,240.24,0,542.85,0,9443.2800000000007,63166.95,63166.95,0,231]
["Client 07","Cluster 2",515,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,1,2,144.81,null,null,null,null,-8,-8,-8,-8,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,2.5,2.5,41.38,193.73,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,452.5,452.5,7489.7800000000007,35065.129999999997,0,0,0]
["Client 07","Cluster 2",515,"SA716-3603 SL CORE","SL Supported Living","2019-07-01",null,"2019-12-31",null,184,"",2,144.81,null,null,null,null,-7,-7,-7,-7,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,2.5,10.44,49.32,201.67,26645.040000000001,494.96,892.4,0,28032.399999999998,6259.68,309.12,125.12,0,460,1920.9599999999998,9074.8799999999992,37107.279999999999,72172.41,0,365]
["Client 8","Cluster 3",518,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,1,3,223.56,0.35,26.5,null,null,-2,-2,-2,-2,9.2799999999999994,4.16,4.8499999999999996,241.85,35.81,1.68,1.04,0,3.2,7.9,49.63,291.48,81599.399999999994,1518.4,1770.2499999999998,3387.2,88275.25,13070.650000000001,613.19999999999993,379.6,0,1168,2883.5,18114.95,106390.2,106390.2,0,365]
["Client 9","Cluster 3",519,"SA716-3603 SL CORE","SL Supported Living","2019-08-01","2019-08-15","2019-12-31","2019-09-30",47,1,5,364.4,null,null,null,null,-1,-1,-1,-1,0,6.78,4.8499999999999996,376.03,40.9,1.68,1.69,0,2.25,0,46.519999999999996,422.54999999999995,17126.8,318.66000000000003,227.95,0,17673.41,1922.3,78.959999999999994,79.429999999999993,0,105.75,0,2186.4399999999996,19859.849999999999,0,0,0]
["Client 9","Cluster 3",519,"SA716-3603 SL CORE","SL Supported Living","2019-10-01",null,"2019-12-31",null,{"$f":"IF(F24>0,+IF(I24>0,I24,H24)-IF(G24>0,G24,F24)+1,0)","v":92},"",3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,{"$f":"(M24+V24+W24+X24)","v":232.57},35.81,1.68,1.04,0,2.25,0,40.78,273.35000000000002,20567.52,382.72,446.2,0,21396.44,3294.5200000000004,154.56,95.68,0,207,0,3751.76,25148.199999999997,45008.049999999996,0,139]
["Client 10","Cluster 3",520,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.25,0,40.78,273.35000000000002,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,821.25,0,14884.7,99772.75,99772.75,0,365]
["Client 11","Cluster 3",521,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,1.85,0,40.380000000000003,272.95,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,675.25,0,14738.7,99626.75,99626.75,0,365]
["Client 12","Cluster 3",522,"SA716-3603 SL CORE","SL Supported Living","2019-07-01",null,"2019-12-31","2019-08-31",62,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,4.58,10.44,53.55,286.12,13860.72,257.92,300.7,0,14419.34,2220.2200000000003,104.16,64.48,0,283.95999999999998,647.28,3320.1,17739.439999999999,0,0,0]
["Client 12","Cluster 3",522,"SA716-3603 SL CORE","SL Supported Living","2019-09-01",null,"2019-12-31",null,122,"",4,291.70999999999998,null,null,null,null,0,0,0,0,0,5.42,4.8499999999999996,301.98,37.15,1.68,1.36,0,4.25,10.44,54.879999999999995,356.86,35588.619999999995,661.24,591.69999999999993,0,36841.560000000005,4532.3,204.95999999999998,165.92000000000002,0,518.5,1273.6799999999998,6695.36,43536.920000000006,61276.360000000008,0,184]
["Client 13","Cluster 3",523,"SA716-3603 SL CORE","SL Supported Living","2019-02-01",null,"2019-12-31","2019-09-30",242,1,2,144.81,null,null,null,null,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,3.25,2.5,42.13,194.48,35044.020000000004,650.98,1173.6999999999998,0,36868.699999999997,8232.84,406.56,164.56,0,786.5,605,10195.460000000001,47064.159999999996,0,0,0]
["Client 13","Cluster 3",523,"SA716-3603 SL CORE","SL Supported Living","2019-10-01",null,"2019-12-31",null,92,"",2,144.81,null,null,null,null,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,1.88,2.5,40.760000000000005,193.11,13322.52,247.48,446.2,0,14016.199999999999,3129.84,154.56,62.56,0,172.95999999999998,230,3749.9200000000005,17766.12,64830.28,0,334]
["Client 14","Cluster 4",533,"SA716-3603 SL CORE","SL Supported Living","2019-06-05","2019-06-06","2019-12-31","2019-07-30",55,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,5.76,13.87,58.16,290.73,12295.8,228.8,266.75,0,12791.35,1969.5500000000002,92.399999999999991,57.2,0,316.8,762.84999999999991,3198.7999999999997,15990.15,15990.15,0,55]
["Client 15","Cluster 4",535,"SA716-3603 SL CORE","SL Supported Living","2019-09-24",null,"2019-10-31","2019-09-27",4,1,7,291.70999999999998,null,null,null,null,0,0,0,0,0,9.24,4.8499999999999996,305.8,50.22,1.68,2.31,0,5.0199999999999996,2.5,61.730000000000004,367.53000000000003,1166.8399999999999,36.96,19.399999999999999,0,1223.2,200.88,6.72,9.24,0,20.079999999999998,10,246.92000000000002,1470.1200000000001,1470.1200000000001,0,4]
["Client 16","Cluster 4",536,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-04-30",null,120,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.4500000000000002,0,40.980000000000004,273.55,26827.200000000001,499.20000000000005,582,0,27908.399999999998,4297.2000000000007,201.6,124.80000000000001,0,294,0,4917.6000000000004,32826,32826,0,120]
[null,null,null,null,null,null,null,null,null,0,{"$f":"IF(C34<=0,\"\",IF(C34=C33,\"\",1))","v":""},null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,null,null,0,0,0,0,0,null,null,0,null,null,null,null,null,null,{"$f":"SUM(Z42:AE42)","v":0},{"$f":"+Y42+AF42","v":0},{"$f":"M42*J42","v":0},{"$f":"W42*J42","v":0},{"$f":"X42*J42","v":0},0,{"$f":"$J42*Y42","v":0},{"$f":"$J42*Z42","v":0},{"$f":"$J42*AA42","v":0},{"$f":"$J42*AB42","v":0},{"$f":"$J42*AC42","v":0},{"$f":"J42*AD42","v":0},{"$f":"$J42*AE42","v":0},{"$f":"$J42*AF42","v":0},{"$f":"AL42+AS42","v":0},{"$f":"IF(A43=A42,0,SUMIF($A$4:$A$4805,$A42,AL$4:AL$4805))+IF(A43=A42,0,SUMIF($A$4:$A$4805,$A42,AS$4:AS$4805))","v":0},0,{"$f":"IF(A43=A42,0,SUMIF($A$4:$A$4805,$A42,J$4:J$4805))+IF(A43=A42,0,SUMIF($A$4:$A$4805,$A42))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z43:AE43)","v":0},{"$f":"+Y43+AF43","v":0},{"$f":"M43*J43","v":0},{"$f":"W43*J43","v":0},{"$f":"X43*J43","v":0},{"$f":"V43*J43","v":0},{"$f":"$J43*Y43","v":0},{"$f":"$J43*Z43","v":0},{"$f":"$J43*AA43","v":0},{"$f":"$J43*AB43","v":0},null,{"$f":"J43*AD43","v":0},{"$f":"$J43*AE43","v":0},{"$f":"$J43*AF43","v":0},{"$f":"AL43+AS43","v":0},{"$f":"IF(A44=A43,0,SUMIF($A$4:$A$4805,$A43,AL$4:AL$4805))+IF(A44=A43,0,SUMIF($A$4:$A$4805,$A43,AS$4:AS$4805))","v":0},{"$f":"IF($O43=$AU$1,$N43*$O43*$J43,0)+IF($Q43=$AU$1,$P43*$Q43*$J43,0)","v":0},{"$f":"IF(C44=C43,0,SUMIF($C$4:$C$4597,$C43,J$4:J$4597))+IF(C44=C43,0,SUMIF($C$5:$C$4598,$C43))","v":0}]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J43)","v":5797},{"$f":"SUBTOTAL(9,K4:K43)","v":22},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V43)","v":26.310000000000002},null,null,{"$f":"SUBTOTAL(9,Y4:Y43)","v":6775.7599999999993},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AF4:AF43)","v":1514.6100000000001},8290.369999999999,1261382.9500000004,23469.8,28115.450000000004,9055.630000000001,1322023.83,245123.7399999999,9738.9599999999955,5885.1500000000005,0,10636.559999999998,19212.409999999996,290596.82,1612620.6499999997,1612620.65,null,{"$f":"SUBTOTAL(9,AW4:AW43)","v":5797}]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,J4:J42)","v":3951},{"$f":"SUMIF($E$4:$E$42,$E$45,K4:K42)","v":16},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,V4:V42)","v":26.310000000000002},null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,Y4:Y42)","v":5099.9800000000005},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,AF4:AF42)","v":1093.4799999999998},6193.4599999999991,802810.69,14947.289999999997,19162.350000000006,9055.630000000001,845975.95999999985,139770.81000000003,6637.68,3746.3099999999995,0,10636.559999999998,17847.409999999996,178638.77000000002,1024614.73,1024614.7300000001,0,3951]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$46,J4:J43)","v":1095},{"$f":"SUMIF($E$4:$E$42,$E$46,K4:K43)","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$46,V4:V43)","v":0},null,null,{"$f":"SUMIF($E$4:$E$42,$E$46,Y4:Y43)","v":839.25},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$46,AF4:AF43)","v":237.26},1076.51,240929.19999999998,4478.5499999999993,5310.7499999999991,0,250718.5,61845.600000000006,1839.6,1124.2,0,0,452.5,65261.899999999994,315980.40000000002,315980.40000000002,0,1095]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$47,J4:J42)","v":751},{"$f":"SUMIF($E$4:$E$42,$E$47,K4:K42)","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$47,V4:V42)","v":0},null,null,{"$f":"SUMIF($E$4:$E$42,$E$47,Y4:Y42)","v":836.53},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$47,AF4:AF42)","v":183.87},1020.4000000000001,217643.06,4043.96,3642.3499999999995,0,225329.37000000002,43507.33,1261.6799999999998,1014.6400000000001,0,0,912.5,46696.149999999994,272025.52,272025.52,0,751]
["DSHS/DDA Schedule H Rate History (Rev. 12/2020)"]

{"sheet":"Reconciliation","index":1,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["TCN","Procedure Code","REGION","Provider Name","Provider Number","RAC Code","Client Last Name","Client First Name","Client P1 Id","Service Month","Paid Units","Daily Rate","Paid Amt","Participation","Remittance","Remittance Paid Date","Schedule J Detail by Client Contracted Amount","Schedule J Detail by Client Contracted Days","Cost Variance","Days Variance","Sched J Rate","Sched J Days","Schedule J Total","Days Variance","Dollars Variance","Comments","Resource Manager Response","Resource Manager Comments","Action taken by Analyst"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF('Schedule H - Rate History'!$C$4:$C$42,I1,'Schedule H - Rate History'!$AU$4:$AU$42)","v":0},{"$f":"SUMIF('Schedule H - Rate History'!$C$4:$C$42,I1,'Schedule H - Rate History'!$AW$4:$AW$42)","v":0},{"$f":"(M2+N2)-Q2","v":0},{"$f":"K2-R2","v":0},null,null,{"$f":"U2*V2","v":0},{"$f":"K2-V2","v":0},{"$f":"M2+N2-W2","v":0},null,null,null,null,"SA716 & SA722","Supported Living & Group Home",{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V2)","v":0},{"$f":"SUBTOTAL(9,W2)","v":0},{"$f":"SUBTOTAL(9,X2)","v":0},{"$f":"SUBTOTAL(9,Y2)","v":0},null,null,null,null,"Provider1 Total",null,{"$f":"SUM(AF2:AF2)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AH2:AH2)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUBTOTAL(9,X2:X3)","v":0},{"$f":"SUBTOTAL(9,Y2:Y3)","v":0},null,null,null,null,"Less overpayments",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add underpayments",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Total",null,{"$f":"SUM(AF2:AF2,AF5,AF6)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AH2:AH2,AH5,AH6)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sched J Check",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Difference",null,{"$f":"AF7-AF9","v":{"$error":"#REF!"}},null,{"$f":"AH7-AH9","v":{"$error":"#REF!"}}]

{"sheet":"Other Codes","index":2,"n_rows":1,"n_cols":16,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["TCN","Procedure Code","REGION","Provider Name","Provider Number","RAC Code","Client Last Name","Client First Name","Client P1 Id","Service Month","Paid Units","Daily Rate","Paid Amt","Participation","Remittance","Remittance Paid Date"]

{"sheet":"List","index":3,"n_rows":138,"n_cols":9,"rows_kept":138,"cut":false,"hidden":true,"merged":[]}
["Provider Name","Provider ID","Urban Designation",null,null,"Program Type","Service Code & RAC",null,"RM Responses"]
[]
["1N - Adult Guidance & Empowerment Service",111684901,"MSA",null,null,"SL Supported Living","SA716-3603 SL CORE",null,"Underpayment to be claimed"]
["1N - Alpha Supported Living (Spokane)",111320906,"MSA",null,null,"GH Group Home","SA716-3604 SL CP",null,"Underpayment will not be claimed, please adjust settlement"]
["1N - Ambitions - Spokane",111901906,"MSA",null,null,"GTH Group Training Home","SA716-3701 SL RCL",null,"Overpayment to be adjusted in P1"]
["1N - Ambitions - Wenatchee, Omak, Moses Lake",111901903,"MSA/NON-MSA",null,null,null,"SA716-3905 SL State",null,"Overpayment will not to be adjusted in P1 (explain why in column AE)"]
["1N - ARC of Spokane",111426502,"MSA",null,null,null,"SA722-3603 GH CORE",null,"COCA to be issued (Copy Attached)"]
["1N - Assisted Residential Services",111705601,"MSA",null,null,null,"SA722-3701 GH RCL",null,"COCA issued previously (Copy Attached)"]
["1N - Community Integrated Services",111425301,"MSA",null,null,null,"SA722-3905 GH State",null,"COCA not submitted by provider per DDA policy timelines"]
["1N - Community Visions",111530102,"MSA",null,null,null,"SA722-3603 GTH CORE"]
["1N - Dreamworks Residential",111913801,"NON-MSA",null,null,null,"SA722-3701 GTH RCL"]
["1N - Drive Services",111621401,"MSA",null,null,null,"SA722-3905 GTH State"]
["1N - Excel Supported Living",111322002,"MSA"]
["1N - Grace Support Services",212120601,"MSA"]
["1N - Grant County Developmental Disabilities (DCL)",200012501,"NON-MSA"]
["1N - Hope Human Services (Spokane)",207150604,"MSA"]
["1N - Hope Supported Living",213504001,"MSA"]
["1N - Kaler House",111686001,"MSA"]
["1N - L.M.K.",111988202,"NON-MSA"]
["1N - Latah Services",111762501,"MSA"]
["1N - Living In Fulfilling Environment",111777301,"MSA"]
["1N - Mission Vista",111707401,"MSA"]
["1N - Parent's Cooperative Society for the Handicapped (Merry Glen)",111328901,"MSA"]
["1N - ResCare Spokane",111968514,"MSA"]
["1S - Alternative Residential Services",111625401,"MSA/NON-MSA"]
["1S - Ambitions - Kennewick",111901901,"MSA"]
["1S - Ambitions - Yakima",111901907,"MSA"]
["1S - Community Living",111962202,"MSA"]
["1S - Deaf Access Washington",111321901,"MSA"]
["1S - Elmview",111604101,"MSA/NON-MSA"]
["1S - Habilitat",111449601,"NON-MSA"]
["1S - Kittitas Interactive Management",111688701,"NON-MSA"]
["1S - Kittitas Interactive Management (Yakima)",111688702,"MSA"]
["1S - Reach Supported Living",209862801,"MSA"]
["1S - Reach Supported Living Walla Walla",209862802,"MSA"]
["1S - Tri-Cities Residential Services",111872501,"MSA"]
["1S - Valley Residential Services",111777901,"NON-MSA"]
["2N - Aacres",111414307,"MSA"]
["2N - Access Living",111675101,"MSA"]
["2N - All Heart Agency",111961601,"MSA"]
["2N - Alpha Supported Living Services",111320902,"MSA"]
["2N - Ambitions Whatcom",111901908,"MSA"]
["2N - Camelot Society",101955202,"MSA"]
["2N - Cascade Connections",111724102,"MSA"]
["2N - Evergreen Supported Living",111690301,"MSA"]
["2N - Holly Community Services",111765001,"MSA"]
["2N - La Casa de Esperanza ",111390801,"MSA"]
["2N - Puffin Island",111959501,"MSA"]
["2N - Quilceda Community Services",111321203,"MSA"]
["2N - Rehabco",111681901,"MSA"]
["2N - Rescare",111968512,"MSA"]
["2N - Sails",111805705,"MSA"]
["2N - Service Alternatives for WA",111513304,"MSA"]
["2N - Snohomish Supportive Living Services",111518901,"MSA"]
["2N - Soundview Association",111830201,"MSA"]
["2N - Steps Toward Independence",112034301,"MSA"]
["2N - Sunrise Services",203434610,"MSA"]
["2N - Village Community Services",111938301,"MSA"]
["2N - Volunteers of America",200494106,"MSA"]
["2S - Alpha Supported Living Services",111320901,"KING"]
["2S - Ambitions",111901902,"KING"]
["2S - Arc of King County",112013701,"KING"]
["2S - Banchero Friends Services",111415001,"KING"]
["2S - Bethesda Lutheran Communities",111621301,"KING"]
["2S - Camelot Society",101955201,"KING"]
["2S - Cascade Community Services",111875001,"KING"]
["2S - Citizen Access Residential Resources",111533401,"KING"]
["2S - Community Integrated Services",111425302,"KING"]
["2S - Community Living",111962201,"KING"]
["2S - Destiny House Operations",111992801,"KING"]
["2S - Friendship House",111405501,"KING"]
["2S - Greenwood Home",111913301,"KING"]
["2S - Habilitation Services",208173701,"KING"]
["2S - Helping Hands DBA Dahlia",111736003,"KING"]
["2S - Inglewood Residential and Community Services",111568401,"KING"]
["2S - Integrated Living Services",111789002,"KING"]
["2S - L'Arche Noah Sealth of Seattle",111798601,"KING"]
["2S - Life Skills Center",111499601,"KING"]
["2S - Maksu",111577901,"KING"]
["2S - Parkview Services",111456901,"KING"]
["2S - Premier Care Services",111437001,"KING"]
["2S - Provail",101144803,"KING"]
["2S - Puget Sound Regional Services",111925301,"KING"]
["2S - Res-Care Washington",111968506,"KING"]
["2S - SAILS",111805704,"KING"]
["2S - Service Alternatives for WA",111513302,"KING"]
["2S - Shamrock Living Services",111958301,"KING"]
["2S - Shared Journeys",111515201,"KING"]
["2S - Stand Together",111753401,"KING"]
["2S - Tahoma Hills",111799101,"KING"]
["2S - Total Living Concept",111571101,"KING"]
["2S - United Friends Group Home",101601101,"KING"]
["2S - Volunteers of America",200494104,"KING"]
["3N - Aacres WA",111414304,"MSA"]
["3N - Ambitions, WA",111901904,"MSA"]
["3N - Communitas Group",102702801,"MSA"]
["3N - Community Alternatives for People with Autism (CAPA)",112026801,"MSA"]
["3N - Educational Programs in Home Living",111975401,"MSA"]
["3N - Group Action for Peninsula People",111703801,"MSA"]
["3N - Hope Human Services",207150601,"MSA"]
["3N - Kitsap Residences",111781001,"MSA"]
["3N - Kitsap Tenant Support Services",111715902,"MSA"]
["3N - L'Arche Tahoma Hope Community",111610303,"MSA"]
["3N - Life Force Services",111691201,"MSA"]
["3N - NW Services for Independent Living",111812601,"MSA"]
["3N - Options Unlimited",111904801,"MSA"]
["3N - PAM Group Home",111728401,"MSA"]
["3N - Puget Sound Assisted Living",111557601,"MSA"]
["3N - Res-Care Washington",111968504,"MSA"]
["3N - Service Alternatives for WA",111513305,"MSA"]
["3N - Tahoma Associates",111335302,"MSA"]
["3N - Valley Supported Living",111938101,"MSA"]
["3S - Aacres - Clark",111414303,"NON-MSA"]
["3S - Aacres - Thurston",111414308,"MSA"]
["3S - ABC Residential Services",555777999,"MSA"]
["3S - Adam's Place",214039510,"MSA"]
["3S - Ambitions",111901905,"MSA/NON-MSA"]
["3S - Another Option",111619102,"MSA"]
["3S - Arc of Clark County",102623403,"MSA"]
["3S - Brighton Enterprises - Clark",111686601,"MSA"]
["3S - Brighton Enterprises - Thurston",111686602,"MSA"]
["3S - CCH Individual Support Services",111909801,"NON-MSA"]
["3S - Citizen Access Residential Resources",111533403,"MSA"]
["3S - Community Resources",111977701,"MSA/NON-MSA"]
["3S - Exceptional Foresters",111551801,"MSA"]
["3S - Harbor Alternative Living Association",111349601,"NON-MSA"]
["3S - Hope Human Services",207150603,"MSA"]
["3S - Kitsap Tenant Support Services",111715901,"NON-MSA"]
["3S - Kokua",111492901,"MSA"]
["3S - Life Force Services - Clark",111691204,"MSA"]
["3S - Life Force Services - Thurston",111691202,"MSA"]
["3S - Life Works",111594402,"MSA"]
["3S - Placeone",111512001,"MSA"]
["3S - Reside Residential Care of Washington",111864101,"MSA"]
["3S - ROAR",111442501,"MSA"]
["3S - SOLO",111910501,"MSA"]
["3S - Twin Harbors Group Home Association",111669901,"NON-MSA"]
["3S - Vancare",111811201,"MSA"]