{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["2019 JAN","Exhibit","2019 JUN","COCA"," YE Schedule H Rate History","2020 JAN","List"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":13,"defined_names":10724,"comments":5,"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":"2019 JAN","index":0,"n_rows":45,"n_cols":49,"rows_kept":45,"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]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,[13]List!A2:B132,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:AV40)","v":0}]
["Report Period",null,null,"2019-01-01",null,"2019-12-31",null,null,null,{"$f":"IF($AN$1=\"\",SUM(J4:J39),SUMIF($E$4:$E$39,$AN$1,J4:J39))","v":9490},{"$f":"IF($AN$1=\"\",SUM(K4:K39),SUMIF($E$4:$E$39,$AN$1,K4:K39))","v":26},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:AH39),SUMIF($E$4:$E$39,$AN$1,AH4:AH39))","v":2126008.1999999988},39536.800000000003,46026.499999999993,11461,2223032.5,418158.60000000009,15943.200000000008,9909.7500000000036,0,15220.5,29900.799999999999,489132.85000000015,2712165.3500000006,2712165.3500000006,0,9490]
["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)","Transportion 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,0,0,0,0,{"$f":"+N4*O4+P4*Q4","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":"V4*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$4802,$A4,AL$4:AL$4802))+IF(A5=A4,0,SUMIF($A$4:$A$4802,$A4,AS$4:AS$4802))","v":132491.35},{"$f":"IF($O4=$AU$1,$N4*$O4*$J4,0)+IF($Q4=$AU$1,$P4*$Q4*$J4,0)","v":0},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4802,$A4,J$4:J$4802))+IF(A5=A4,0,SUMIF($A$4:$A$4802,$A4))","v":365}]
["Client B","House 1",501,"SA722-3603 GH CORE","GH Group Home","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,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",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,0,0,0,0,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 D","House 1",503,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-12-31",null,365,1,2,144.81,null,null,null,null,0,0,0,0,0,2.69,4.8499999999999996,152.35,54.84,1.68,0.68,0,0,2.5,59.7,212.05,52855.65,981.85,1770.2499999999998,0,55607.75,20016.600000000002,613.19999999999993,248.20000000000002,0,0,912.5,21790.5,77398.25,77398.25,0,365]
["Client E","House 1",504,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-12-31",null,365,1,6,441.64,null,null,null,null,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,2.5,72.670000000000016,527.37,161198.6,2996.65,1770.2499999999998,0,165965.5,24246.95,613.19999999999993,751.9,0,0,912.5,26524.550000000007,192490.05000000002,192490.05000000002,0,365]
["Client F","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,0,0,0,0,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 G","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,0,0,0,0,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 H","House 2",507,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-12-31",null,365,1,5,364.4,null,null,null,null,0,0,0,0,0,6.78,4.8499999999999996,376.03,61.72,1.68,1.69,0,0,0,65.09,441.12,133006,2474.7000000000003,1770.2499999999998,0,137250.94999999998,22527.8,613.19999999999993,616.85,0,0,0,23757.850000000002,161008.79999999999,161008.79999999999,0,365]
["Client I","House 2",508,"SA722-3603 GH CORE","GH Group Home","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,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 J","House 3",538,"SA722-3603 GH CORE","GH Group Home","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,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 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,0,0,0,0,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,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",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,13.87,54.65,287.21999999999997,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,821.25,5062.5499999999993,19947.25,104835.3,104835.3,0,365]
["Client 04","Cluster 2",512,"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,10.44,50.82,283.39,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,675.25,3810.6,18549.3,103437.35,103437.35,0,365]
["Client 05","Cluster 2",513,"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.88,2.5,42.910000000000004,275.48,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,686.19999999999993,912.5,15662.150000000001,100550.20000000001,100550.20000000001,0,365]
["Client 07","Cluster 2",515,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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,2.5,2.5,41.38,193.73,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,912.5,912.5,15103.7,70711.45,70711.45,0,365]
["Client 08","Cluster 2",516,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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,2.5,10.44,49.32,201.67,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,912.5,3810.6,18001.8,73609.55,73609.55,0,365]
["Client 09","Cluster 2",517,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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,13.87,53.5,205.85,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,1186.25,5062.5499999999993,19527.5,75135.25,75135.25,0,365]
["Client 10","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,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,3.2,7.9,49.63,291.47500000000002,81599.399999999994,1518.4,1770.2499999999998,3385.3749999999995,88273.425000000003,13070.650000000001,613.19999999999993,379.6,0,1168,2883.5,18114.95,106388.375,106388.375,0,365]
["Client 12","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 13","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 16","Cluster 3",524,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,1,3,223.56,0.2,38.75,0.25,26.5,0,0,0,0,14.375,4.16,4.8499999999999996,246.94499999999999,35.81,1.68,1.04,0,2.5,2.5,43.53,290.47500000000002,81599.399999999994,1518.4,1770.2499999999998,5246.875,90134.925000000003,13070.650000000001,613.19999999999993,379.6,0,912.5,912.5,15888.45,106023.375,106023.375,0,365]
["Client 17","Cluster 4",525,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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,2.5,0,38.880000000000003,191.23,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,912.5,0,14191.2,69798.95,69798.95,0,365]
["Client 20","Cluster 4",528,"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,3.47,0,42,274.57,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,1266.5500000000002,0,15330,100218.05,100218.05,0,365]
["Client 23","Cluster 4",531,"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,3.5,0,42.03,274.60000000000002,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,1277.5,0,15340.95,100229,100229,0,365]
["Client 24","Cluster 4",532,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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.5,7.9,47.78,200.13,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,1277.5,2883.5,17439.7,73047.45,73047.45,0,365]
["Client 28","Cluster 4",536,"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.4500000000000002,0,40.980000000000004,273.55,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,894.25000000000011,0,14957.7,99845.75,99845.75,0,365]
[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,{"$f":"IF(F32>0,+IF(I32>0,I32,H32)-IF(G32>0,G32,F32)+1,0)","v":0},"",null,null,null,null,null,null,0,0,0,0,{"$f":"+N32*O32+P32*Q32","v":0},null,null,{"$f":"(M32+V32+W32+X32)","v":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,{"$f":"IF(F39>0,+IF(I39>0,I39,H39)-IF(G39>0,G39,F39)+1,0)","v":0},{"$f":"IF(C39<=0,\"\",IF(C39=C38,\"\",1))","v":""},null,null,null,null,null,null,0,0,0,0,{"$f":"+N39*O39+P39*Q39","v":0},null,null,{"$f":"(M39+V39+W39+X39)","v":0},null,null,null,null,null,null,{"$f":"SUM(Z39:AE39)","v":0},{"$f":"+Y39+AF39","v":0},{"$f":"M39*J39","v":0},{"$f":"W39*J39","v":0},{"$f":"X39*J39","v":0},{"$f":"V39*J39","v":0},{"$f":"$J39*Y39","v":0},{"$f":"$J39*Z39","v":0},{"$f":"$J39*AA39","v":0},{"$f":"$J39*AB39","v":0},{"$f":"$J39*AC39","v":0},{"$f":"J39*AD39","v":0},{"$f":"$J39*AE39","v":0},{"$f":"$J39*AF39","v":0},{"$f":"AL39+AS39","v":0},{"$f":"IF(A40=A39,0,SUMIF($A$4:$A$4802,$A39,AL$4:AL$4802))+IF(A40=A39,0,SUMIF($A$4:$A$4802,$A39,AS$4:AS$4802))","v":0},{"$f":"IF($O39=$AU$1,$N39*$O39*$J39,0)+IF($Q39=$AU$1,$P39*$Q39*$J39,0)","v":0},{"$f":"IF(A40=A39,0,SUMIF($A$4:$A$4802,$A39,J$4:J$4802))+IF(A40=A39,0,SUMIF($A$4:$A$4802,$A39))","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(Z40:AE40)","v":0},{"$f":"+Y40+AF40","v":0},{"$f":"M40*J40","v":0},{"$f":"W40*J40","v":0},{"$f":"X40*J40","v":0},{"$f":"V40*J40","v":0},{"$f":"$J40*Y40","v":0},0,0,0,null,{"$f":"J40*AD40","v":0},{"$f":"$J40*AE40","v":0},0,{"$f":"AL40+AS40","v":0},{"$f":"IF(A41=A40,0,SUMIF($A$4:$A$4802,$A40,AL$4:AL$4802))+IF(A41=A40,0,SUMIF($A$4:$A$4802,$A40,AS$4:AS$4802))","v":0},{"$f":"IF($O40=$AU$1,$N40*$O40*$J40,0)+IF($Q40=$AU$1,$P40*$Q40*$J40,0)","v":0},{"$f":"IF(C41=C40,0,SUMIF($C$4:$C$4594,$C40,J$4:J$4594))+IF(C41=C40,0,SUMIF($C$5:$C$4595,$C40))","v":0}]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J40)","v":9490},{"$f":"SUBTOTAL(9,K4:K40)","v":26},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V40)","v":31.4},null,null,{"$f":"SUBTOTAL(9,Y4:Y40)","v":6090.5},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AF4:AF40)","v":1340.0900000000004},7430.5900000000011,2126008.1999999988,39536.800000000003,46026.499999999993,11461,2223032.5,418158.60000000009,15943.200000000008,9909.7500000000036,0,15220.5,29900.799999999999,489132.85000000015,2712165.3500000006,2712165.3500000006,null,{"$f":"SUBTOTAL(9,AW4:AW40)","v":9490}]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$42,J4:J39)","v":5840},{"$f":"SUMIF($E$4:$E$39,$E$42,K4:K39)","v":16},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$42,V4:V39)","v":31.4},null,null,{"$f":"SUMIF($E$4:$E$39,$E$42,Y4:Y39)","v":3271.2000000000003},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$42,AF4:AF39)","v":719.69999999999993},3990.9,1133127.9000000001,21075.100000000002,28323.999999999996,11461,1193988.0000000002,205210.29999999996,9811.2000000000007,5285.2,0,15220.5,27163.3,262690.50000000006,1456678.5,1456678.5,0,5840]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$43,J4:J40)","v":2555},{"$f":"SUMIF($E$4:$E$39,$E$43,K4:K40)","v":7},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$43,V4:V40)","v":0},null,null,{"$f":"SUMIF($E$4:$E$39,$E$43,Y4:Y40)","v":1760.6399999999999},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$43,AF4:AF40)","v":423.20000000000005},2183.84,618733.4,11508.45,12391.749999999998,0,642633.60000000009,146383.25,4292.3999999999996,2879.85,0,0,912.5,154468,797101.60000000009,797101.60000000009,0,2555]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$44,J4:J39)","v":1095},{"$f":"SUMIF($E$4:$E$39,$E$44,K4:K39)","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$44,V4:V39)","v":0},null,null,{"$f":"SUMIF($E$4:$E$39,$E$44,Y4:Y39)","v":1058.6600000000001},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$39,$E$44,AF4:AF39)","v":197.19},1255.8499999999999,374146.9,6953.25,5310.7499999999991,0,386410.9,66565.05,1839.6,1744.7,0,0,1825,71974.350000000006,458385.25,458385.25,0,1095]
["DSHS/DDA Schedule H Rate History (Rev.12/2019)"]

{"sheet":"Exhibit","index":1,"n_rows":43,"n_cols":24,"rows_kept":43,"cut":false,"hidden":false,"merged":[[2,8,2,10],[3,8,3,10],[5,0,5,23],[3,18,3,23],[3,0,3,6],[2,0,2,6],[2,18,2,23],[3,14,3,16],[2,14,2,16],[8,9,8,10],[8,20,8,21],[8,12,8,18],[8,0,8,7],[6,18,6,19],[7,0,7,7],[7,9,7,10],[7,12,7,18],[7,20,7,21]]}
["Supported Living / Group Home -Exhibit C",null,null,null,null,null,null,null,null,null,"July 1, 2018 - June 30, 2019",null,null,null,null,null,null,null,null,null,"Revision #: 190103"]
[]
["ABC Residential Services",null,null,null,null,null,null,null,"1234-567890",null,null,null,"3S",null,"2019-03-15",null,null,null,31]
["Contractor Name",null,null,null,null,null,null,null,"Contract No.",null,null,null,"Region",null,"Process Date",null,null,null,"No. of Clients (excluding SSP funded)"]
[]
["The undersigned hereby affirm that the following are the agreed upon number of clients and reimbursement rates associated with the indicated contract and contract period. This rate sheet revision supersedes all previous rate sheets as of the effective date."]
[]
[]
["Contractor Signature",null,null,null,null,null,null,null,null,"Date Signed",null,null,"DSHS Regional Administrator or Designee",null,null,null,null,null,null,null,"Date Signed"]
[]
["a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x"]
["Program Name","Client Name","Client P1 ID","Rate Effective Date","ISS Tier Rate","ISS Daily Tier Rate","Prof Svs Hrs PCD 1","Prof Svs Hrly Rate 1","Prof Svs Hrs PCD 2","Prof Svs Hrly Rate 2","ISS Prof Svs Daily Rate","ISS CRST Tier Rate","ISS Hold Harmless Rate","Total ISS Daily Rate","Admin Tier Rate","Admin Hold Harmles","Admin CRST Tier Rate","Cert Rate","Transp. Rate","Other Non-ISS Rates","Total Non-ISS Daily Rate","Total Daily Rate","P1 Service Code/RA","Revision #"]
["ABC Residential Services","Client A",500,"2018-07-01",4,291.70999999999998,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,0,61.01,362.99,"SA722-3603",190100]
["ABC Residential Services","Client B",501,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,"SA722-3603",190102]
["ABC Residential Services","Client C",502,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,"SA722-3603",190100]
["ABC Residential Services","Client D",503,"2018-07-01",2,144.81,0,0,0,0,0,2.69,4.8499999999999996,152.35,54.84,1.68,0.68,0,0,2.5,59.7,212.05,"SA722-3603",190100]
["ABC Residential Services","Client E",504,"2018-07-01",6,441.64,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,2.5,72.67,527.37,"SA722-3603",190100]
["ABC Residential Services","Client F",505,"2018-07-01",4,291.70999999999998,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,2.5,63.51,365.49,"SA722-3603",190100]
["ABC Residential Services","Client G",506,"2018-07-01",4,291.70999999999998,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,0,61.01,362.99,"SA722-3603",190100]
["ABC Residential Services","Client H",507,"2018-07-01",5,364.4,0,0,0,0,0,6.78,4.8499999999999996,376.03,61.72,1.68,1.69,0,0,0,65.09,441.12,"SA722-3603",190100]
["ABC Residential Services","Client I",508,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,"SA716-3603",190100]
["ABC Residential Services","Client J",538,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,"SA716-3603",190100]
["ABC Residential Services","Client 1",509,"2018-07-01",2,144.81,0.2,38.75,0,0,7.75,2.69,4.8499999999999996,160.1,34.020000000000003,1.68,0.68,0,2.25,2.5,41.13,201.23,"SA716-3603",190100]
["ABC Residential Services","Client 2",510,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.25,13.87,54.65,287.22000000000003,"SA716-3603",190100]
["ABC Residential Services","Client 4",512,"2019-03-01",3,223.56,0.35,26.5,0,0,9.2799999999999994,4.16,4.8499999999999996,241.85,35.81,1.68,1.04,0,4.58,7.9,51.01,292.86,"SA716-3603",190103]
["ABC Residential Services","Client 5",513,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,1.88,2.5,42.91,275.48,"SA716-3603",190100]
["ABC Residential Services","Client 6",514,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.35,0,40.880000000000003,273.45,"SA716-3603",190100]
["ABC Residential Services","Client 7",515,"2018-07-01",2,144.81,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,2.5,2.5,41.38,193.73,"SA716-3603",190100]
["a","b","c","d","e","f","g","h","i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x"]
["Program Name","Client Name","Client P1 ID","Rate Effective Date","ISS Tier Rate","ISS Daily Tier Rate","Prof Svs Hrs PCD 1","Prof Svs Hrly Rate 1","Prof Svs Hrs PCD 2","Prof Svs Hrly Rate 2","ISS Prof Svs Daily Rate","ISS CRST Tier Rate","ISS Hold Harmless Rate","Total ISS Daily Rate","Admin Tier Rate","Admin Hold Harmles","Admin CRST Tier Rate","Cert Rate","Transp. Rate","Other Non-ISS Rates","Total Non-ISS Daily Rate","Total Daily Rate","P1 Service Code/RA","Revision #"]
["ABC Residential Services","Client 8",516,"2018-07-01",2,144.81,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,2.5,0,49.32,201.67,"SA716-3603",190100]
["ABC Residential Services","Client 9",517,"2018-07-01",2,144.81,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,3.25,0,42.78,174.8,"SA716-3603",190100]
["ABC Residential Services","Client 10",518,"2018-09-01",3,223.56,0.35,26.5,0,0,9.2799999999999994,4.16,4.8499999999999996,241.85,35.81,1.68,1.04,0,3.2,7.9,49.63,291.48,"SA716-3603",190100]
["ABC Residential Services","Client 12",520,"2018-07-01",3,223.56,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,"SA716-3603",190100]
["ABC Residential Services","Client 13",521,"2018-07-01",3,223.56,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,"SA716-3603",190101]
["ABC Residential Services","Client 15",523,"2019-02-01",2,144.81,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,"SA716-3603",190103]
["ABC Residential Services","Client 16",524,"2018-07-01",3,223.56,0.2,38.75,0.25,26.5,14.38,4.16,4.8499999999999996,246.95,35.81,1.68,1.04,0,2.5,2.5,43.53,290.48,"SA716-3603",190100]
["ABC Residential Services","Client 17",525,"2018-07-01",2,144.81,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,2.5,0,38.880000000000003,191.23,"SA716-3603",190100]
["ABC Residential Services","Client 20",528,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,3.47,0,42,274.57,"SA716-3603",190100]
["ABC Residential Services","Client 23",531,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,3.5,0,42.03,274.60000000000002,"SA716-3603",190101]
["ABC Residential Services","Client 24",532,"2018-07-01",2,144.81,0,0,0,0,0,2.69,4.8499999999999996,152.35,34.020000000000003,1.68,0.68,0,3.5,7.9,47.78,200.13,"SA716-3603",190100]
["ABC Residential Services","Client 25",533,"2018-07-01",3,223.56,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,"SA716-3603",190100]
["ABC Residential Services","Client 28",536,"2018-07-01",3,223.56,0,0,0,0,0,4.16,4.8499999999999996,232.57,35.81,1.68,1.04,0,2.4500000000000002,0,40.98,273.55,"SA716-3603",190100]

{"sheet":"2019 JUN","index":2,"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]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,[13]List!A2:B132,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,"2019-01-01",null,"2019-12-31",null,null,null,{"$f":"IF($AN$1=\"\",SUM(J4:J42),SUMIF($E$4:$E$42,$AN$1,J4:J42))","v":4556},{"$f":"IF($AN$1=\"\",SUM(K4:K42),SUMIF($E$4:$E$42,$AN$1,K4:K42))","v":29},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":1008920.5799999996},18761.419999999995,22096.6,6814.9499999999989,1056593.55,195245.81999999989,7654.08,4704.1499999999996,0,8473.26,15239.389999999998,231316.7,1287910.25,1287910.2499999998,0,4556]
["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)","Transportion 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-06-30",null,{"$f":"IF(F4>0,+IF(I4>0,I4,H4)-IF(G4>0,G4,F4)+1,0)","v":181},{"$f":"IF(C4<=0,\"\",IF(C4=C3,\"\",1))","v":1},4,291.70999999999998,null,null,null,null,0,0,0,0,{"$f":"+N4*O4+P4*Q4","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":52799.509999999995},{"$f":"W4*J4","v":981.02},{"$f":"X4*J4","v":877.84999999999991},{"$f":"V4*J4","v":0},{"$f":"$J4*Y4","v":54658.380000000005},{"$f":"$J4*Z4","v":10492.57},{"$f":"$J4*AA4","v":304.08},{"$f":"$J4*AB4","v":246.16000000000003},{"$f":"$J4*AC4","v":0},{"$f":"J4*AD4","v":0},{"$f":"$J4*AE4","v":0},{"$f":"$J4*AF4","v":11042.81},{"$f":"AL4+AS4","v":65701.19},{"$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":65701.19},{"$f":"IF($O4=$AU$1,$N4*$O4*$J4,0)+IF($Q4=$AU$1,$P4*$Q4*$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":181}]
["Client B","House 1",501,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-06-30",null,181,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,40464.36,752.96,877.84999999999991,0,42095.17,10250.030000000001,304.08,188.24,0,0,0,10742.35,52837.52,52837.52,0,181]
["Client C","House 1",502,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-06-30",null,181,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,40464.36,752.96,877.84999999999991,0,42095.17,10250.030000000001,304.08,188.24,0,0,0,10742.35,52837.52,52837.52,0,181]
["Client D","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,0,0,0,0,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,38381.050000000003,0,181]
["Client E","House 1",504,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-06-30",null,181,1,6,441.64,null,null,null,null,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,2.5,72.670000000000016,527.37,79936.84,1486.0100000000002,877.84999999999991,0,82300.7,12023.830000000002,304.08,372.86,0,0,452.5,13153.270000000002,95453.97,95453.97,0,181]
["Client F","House 2",505,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-06-30",null,181,1,4,291.70999999999998,null,null,null,null,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,2.5,63.51,365.49,52799.509999999995,981.02,877.84999999999991,0,54658.380000000005,10492.57,304.08,246.16000000000003,0,0,452.5,11495.31,66153.69,66153.69,0,181]
["Client G","House 2",506,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-06-30",null,181,1,4,291.70999999999998,null,null,null,null,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,0,61.01,362.99,52799.509999999995,981.02,877.84999999999991,0,54658.380000000005,10492.57,304.08,246.16000000000003,0,0,0,11042.81,65701.19,65701.19,0,181]
["Client H","House 2",507,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-06-30",null,181,1,5,364.4,null,null,null,null,0,0,0,0,0,6.78,4.8499999999999996,376.03,61.72,1.68,1.69,0,0,0,65.09,441.12,65956.399999999994,1227.18,877.84999999999991,0,68061.429999999993,11171.32,304.08,305.89,0,0,0,11781.29,79842.720000000001,79842.720000000001,0,181]
["Client I","House 2",508,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-12-31","2019-01-21",21,1,3,223.56,null,null,null,null,0,0,0,0,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 J","House 3",538,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-01-30",null,30,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,6706.8,124.80000000000001,145.5,0,6977.0999999999995,1698.9,50.4,31.200000000000003,0,0,0,1780.5,8757.5999999999985,8757.5999999999985,0,30]
["Client 01","Cluster 1",509,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,1,2,144.81,0.2,38.75,null,null,0,0,0,0,7.75,2.69,4.8499999999999996,160.1,34.020000000000003,1.68,0.68,0,2.25,2.5,41.13,201.23,26210.61,486.89,877.84999999999991,1402.75,28978.1,6157.6200000000008,304.08,123.08000000000001,0,407.25,452.5,7444.5300000000007,36422.629999999997,36422.629999999997,0,181]
["Client 02","Cluster 1",510,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,13.87,54.65,287.21999999999997,40464.36,752.96,877.84999999999991,0,42095.17,6481.6100000000006,304.08,188.24,0,407.25,2510.4699999999998,9891.65,51986.82,51986.82,0,181]
["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,0,0,0,0,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-06-30",null,122,"",3,223.56,0.35,26.5,null,null,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,4.58,7.9,51.01,292.85500000000002,27274.32,507.52000000000004,591.69999999999993,1131.5499999999997,29505.09,4368.8200000000006,204.95999999999998,126.88000000000001,0,558.76,963.80000000000007,6223.2199999999993,35728.31,52448.32,0,181]
["Client 05","Cluster 2",513,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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.88,2.5,42.910000000000004,275.48,40464.36,752.96,877.84999999999991,0,42095.17,6481.6100000000006,304.08,188.24,0,340.28,452.5,7766.7100000000009,49861.88,49861.88,0,181]
["Client 06","Cluster 2",514,"SA716-3603 SL CORE","SL Supported Living","2019-05-18","2019-05-15","2019-06-30",null,47,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.35,0,40.880000000000003,273.45,10507.32,195.52,227.95,0,10930.789999999999,1683.0700000000002,78.959999999999994,48.88,0,110.45,0,1921.3600000000001,12852.15,12852.15,0,47]
["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,0,0,0,0,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,35065.129999999997,0,181]
["Client 08","Cluster 2",516,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,2.5,10.44,49.32,201.67,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,452.5,1889.6399999999999,8926.92,36502.269999999997,36502.269999999997,0,181]
["Client 09","Cluster 2",517,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,13.87,53.5,205.85,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,588.25,2510.4699999999998,9683.5,37258.85,37258.85,0,181]
["Client 10","Cluster 3",518,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,1,3,223.56,0.35,26.5,null,null,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,3.2,7.9,49.63,291.47500000000002,40464.36,752.96,877.84999999999991,1678.7749999999996,43773.945,6481.6100000000006,304.08,188.24,0,579.20000000000005,1429.9,8983.0300000000007,52756.974999999999,52756.974999999999,0,181]
["Client 12","Cluster 3",520,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,40464.36,752.96,877.84999999999991,0,42095.17,6481.6100000000006,304.08,188.24,0,407.25,0,7381.18,49476.35,49476.35,0,181]
["Client 13","Cluster 3",521,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,40464.36,752.96,877.84999999999991,0,42095.17,6481.6100000000006,304.08,188.24,0,334.85,0,7308.7800000000007,49403.95,49403.95,0,181]
["Client 15","Cluster 3",523,"SA716-3603 SL CORE","SL Supported Living","2019-02-01",null,"2019-06-30",null,150,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,21721.5,403.5,727.5,0,22852.5,5103.0000000000009,252,102.00000000000001,0,487.5,375,6319.5,29172,29172,0,150]
["Client 16","Cluster 3",524,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,1,3,223.56,0.2,38.75,0.25,26.5,0,0,0,0,14.375,4.16,4.8499999999999996,246.94499999999999,35.81,1.68,1.04,0,2.5,2.5,43.53,290.47500000000002,40464.36,752.96,877.84999999999991,2601.875,44697.044999999998,6481.6100000000006,304.08,188.24,0,452.5,452.5,7878.93,52575.974999999999,52575.974999999999,0,181]
["Client 17","Cluster 4",525,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,2.5,0,38.880000000000003,191.23,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,452.5,0,7037.2800000000007,34612.629999999997,34612.629999999997,0,181]
["Client 20","Cluster 4",528,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,3.47,0,42,274.57,40464.36,752.96,877.84999999999991,0,42095.17,6481.6100000000006,304.08,188.24,0,628.07000000000005,0,7602,49697.17,49697.17,0,181]
["Client 23","Cluster 4",531,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,3.5,0,42.03,274.60000000000002,40464.36,752.96,877.84999999999991,0,42095.17,6481.6100000000006,304.08,188.24,0,633.5,0,7607.43,49702.6,49702.6,0,181]
["Client 24","Cluster 4",532,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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.5,7.9,47.78,200.13,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,633.5,1429.9,8648.18,36223.53,36223.53,0,181]
["Client 25","Cluster 4",533,"SA716-3603 SL CORE","SL Supported Living","2019-06-05","2019-06-06","2019-06-30",null,25,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,5589,104,121.24999999999999,0,5814.25,895.25,42,26,0,144,346.75,1454,7268.25,7268.25,0,25]
["Client 28","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,"",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,{"$f":"IF(F36>0,+IF(I36>0,I36,H36)-IF(G36>0,G36,F36)+1,0)","v":0},"",null,null,null,null,null,null,0,0,0,0,{"$f":"+N36*O36+P36*Q36","v":0},null,null,{"$f":"(M36+V36+W36+X36)","v":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},{"$f":"V42*J42","v":0},{"$f":"$J42*Y42","v":0},0,0,0,0,{"$f":"J42*AD42","v":0},{"$f":"$J42*AE42","v":0},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},{"$f":"IF($O42=$AU$1,$N42*$O42*$J42,0)+IF($Q42=$AU$1,$P42*$Q42*$J42,0)","v":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,{"$f":"SUM(Z43:AE43)","v":0},0,0,0,0,0,0,0,0,0,null,0,0,0,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},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":4556},{"$f":"SUBTOTAL(9,K4:K43)","v":29},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V43)","v":40.674999999999997},null,null,{"$f":"SUBTOTAL(9,Y4:Y43)","v":6949.8350000000009},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AF4:AF43)","v":1532.2700000000007},8482.1049999999996,1008920.5799999996,18761.419999999995,22096.6,6814.9499999999989,1056593.55,195245.81999999989,7654.08,4704.1499999999996,0,8473.26,15239.389999999998,231316.7,1287910.25,1287910.2499999998,null,{"$f":"SUBTOTAL(9,AW4:AW43)","v":4556}]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,J4:J42)","v":3057},{"$f":"SUMIF($E$4:$E$42,$E$45,K4:K42)","v":19},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,V4:V42)","v":40.674999999999997},null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,Y4:Y42)","v":4130.5349999999999},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$45,AF4:AF42)","v":911.87999999999988},5042.415,586087.91999999981,10900.2,14826.450000000003,6814.9499999999989,618629.5199999999,107258.73,5135.76,2734.3199999999997,0,8473.26,13881.889999999998,137483.96,756113.48,756113.48,0,3057]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$46,J4:J43)","v":956},{"$f":"SUMIF($E$4:$E$42,$E$46,K4:K43)","v":7},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":1760.6399999999999},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$46,AF4:AF43)","v":423.20000000000005},2183.84,237296.79999999996,4413.17,4636.6000000000004,0,246346.57,54978.12,1606.08,1104.6500000000001,0,0,452.5,58141.350000000006,304487.92,304487.92,0,956]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$47,J4:J42)","v":543},{"$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":1058.6600000000001},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$42,$E$47,AF4:AF42)","v":197.19},1255.8499999999999,185535.86,3448.05,2633.5499999999997,0,191617.46000000002,33008.97,912.24,865.18000000000006,0,0,905,35691.39,227308.85,227308.85,0,543]
["DSHS/DDA Schedule H Rate History (Rev.12/2019)"]

{"sheet":"COCA","index":3,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[[25,0,25,2],[1,3,1,5],[2,3,2,5],[4,0,4,8],[5,0,5,2],[5,3,5,6],[5,7,5,8],[6,0,6,2],[6,3,6,6],[6,7,6,8],[7,3,7,6],[8,0,8,1],[8,3,8,6],[14,0,14,1],[9,0,9,1],[10,0,10,1],[10,6,10,8],[11,0,11,1],[11,3,11,5],[11,6,11,8],[12,0,12,1],[12,3,12,5],[13,0,13,1],[13,3,13,4],[13,5,13,8],[15,0,15,1],[15,3,15,4],[15,5,15,7],[16,0,16,1],[16,3,16,4],[16,5,16,7],[24,0,24,2],[17,0,17,1],[18,0,18,8],[19,0,19,3],[19,4,19,8],[20,0,20,2],[20,4,20,8],[21,0,21,2],[21,6,21,8],[22,0,22,2],[22,4,22,8],[23,0,23,2],[31,0,31,8],[32,0,33,8],[34,0,34,8],[35,0,35,8],[26,0,26,8],[27,0,27,4],[28,0,28,6],[28,7,28,8],[29,0,29,8],[30,0,30,1]]}
[]
[null,null,null,"Deveopmental Disabilities"]
[null,null,null,"Cost of Care Adjustment"]
[]
["Provider Completes"]
["Absent Client's Name: ",null,null,"Provider Name",null,null,null,"Date Submitted"]
["Client 2",null,null,"ABC Residential Services",null,null,null,"2019-07-15"]
["Affected Housemates",null,"P1 ID","Provider ID"]
["Client 8",null,null,555777999]
[null,null,null,"Reason for Temporary Absence"]
[null,null,null,"       Admitted to medical facility",null,null,"    Admitted to nursing facility"]
[null,null,null,"      Social leave",null,null,"    RHC respite",null,null,null," "]
[null,null,null,"      In jail",null,null,"    Death(date):"]
[null,null,null,"      other (describe)"]
[]
[null,null,null,"Departure Date",null,"Estimated Return Date",null,null,"Est. Days"]
[null,null,null,"2019-07-01",null,"2019-07-31",null,null,{"$f":"_xlfn.DAYS(F17,D17)+1","v":31}]
[]
["DDA Use Only"]
["Covered Cost",null,null,null,"housemate assigned for COCA authorization"]
["ISS Shared Support",null,null,139.66,"Client 8"]
["ISS CRST",null,null,3.17,"Service Code",null,"726 U1 (waiver SL)"]
["Shared Professional Services",null,null,0,"amount paid per calendar month "]
["Administrative Tier Rate",null,null,37.229999999999997,31,"1st","2nd","3rd","total"]
["Administrative CRST",null,null,0.79,"# days",0,0,0]
["Total COCA Daily Rate",null,null,{"$f":"SUM(D21:D25)","v":180.84999999999997},"amount  ",{"$f":"D26*F25","v":0},{"$f":"D26*G25","v":0},{"$f":"D26*H25","v":0},{"$f":"F26+G26+H26","v":0}]
["Approval "]
["DDA RMA/DESIGNEE SIGNATURE:",null,null,null,null,null,null,"DATE: ",null," "]
[null,null,null,null,null,null,null,"2019-07-31"]
["authorization"]
["Date authorized: "]
["processing commments:"]
[]
[]
["DISTRIBUTION:           Resource Manager Contracts file          PROVIDER      DDA Rates Analyst"]
["DSHS 06-124 (REV. 02/19)"]

{"sheet":" YE Schedule H Rate History","index":4,"n_rows":63,"n_cols":49,"rows_kept":63,"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]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,[13]List!A2:B132,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:AV58)","v":0}]
["Report Period",null,null,"2019-01-01",null,"2019-12-31",null,null,null,{"$f":"IF($AN$1=\"\",SUM(J4:J57),SUMIF($E$4:$E$57,$AN$1,J4:J57))","v":9477},{"$f":"IF($AN$1=\"\",SUM(K4:K57),SUMIF($E$4:$E$57,$AN$1,K4:K57))","v":33},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:AH57),SUMIF($E$4:$E$57,$AN$1,AH4:AH57))","v":2109537.8300000005},39241.409999999989,45963.449999999983,14299.15,2209041.8400000003,403723.11,15921.36,9841.4400000000023,0,18381.86,32326.699999999997,480194.47000000003,2689236.3100000005,2689236.31,0,9477]
["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)","Transportion 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,0,0,0,0,{"$f":"+N4*O4+P4*Q4","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":"V4*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},22268.649999999998,{"$f":"AL4+AS4","v":132491.35},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4820,$A4,AL$4:AL$4820))+IF(A5=A4,0,SUMIF($A$4:$A$4820,$A4,AS$4:AS$4820))","v":132491.35},{"$f":"IF($O4=$AU$1,$N4*$O4*$J4,0)+IF($Q4=$AU$1,$P4*$Q4*$J4,0)","v":0},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4820,$A4,J$4:J$4820))+IF(A5=A4,0,SUMIF($A$4:$A$4820,$A4))","v":365}]
["Client B","House 1",501,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-06-30",null,181,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,{"$f":"SUM(Z5:AE5)","v":59.35},{"$f":"+Y5+AF5","v":291.92},{"$f":"M5*J5","v":40464.36},{"$f":"W5*J5","v":752.96},{"$f":"X5*J5","v":877.84999999999991},{"$f":"V5*J5","v":0},{"$f":"$J5*Y5","v":42095.17},{"$f":"$J5*Z5","v":10250.030000000001},{"$f":"$J5*AA5","v":304.08},{"$f":"$J5*AB5","v":188.24},{"$f":"$J5*AC5","v":0},{"$f":"J5*AD5","v":0},{"$f":"$J5*AE5","v":0},{"$f":"$J5*AF5","v":10742.35},{"$f":"AL5+AS5","v":52837.52},{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4820,$A5,AL$4:AL$4820))+IF(A6=A5,0,SUMIF($A$4:$A$4820,$A5,AS$4:AS$4820))","v":0},0,{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4820,$A5,J$4:J$4820))+IF(A6=A5,0,SUMIF($A$4:$A$4820,$A5))","v":0}]
["Client B","House 1",501,"SA722-3603 GH CORE","GH Group Home","2019-07-01",null,"2019-12-31",null,184,"",3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,41135.040000000001,765.44,892.4,0,42792.88,10419.92,309.12,191.36,0,0,0,10920.4,53713.279999999999,106550.79999999999,0,365]
["Client C","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,0,0,0,0,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 D","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,0,0,0,0,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 D","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,0,0,0,0,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 E","House 1",504,"SA722-3905 GTH State","GTH Group Training Home","2019-01-01",null,"2019-12-31",null,365,1,6,441.64,null,null,null,null,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,2.5,72.670000000000016,527.37,161198.6,2996.65,1770.2499999999998,0,165965.5,24246.95,613.19999999999993,751.9,0,0,912.5,26524.550000000007,192490.05000000002,192490.05000000002,0,365]
["Client F","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,0,0,0,0,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 G","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,0,0,0,0,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 H","House 2",507,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-08-31",null,243,1,5,364.4,null,null,null,null,0,0,0,0,0,6.78,4.8499999999999996,376.03,61.72,1.68,1.69,0,0,0,65.09,441.12,88549.2,1647.54,1178.55,0,91375.29,14997.96,408.24,410.66999999999996,0,0,0,15816.87,107192.15999999999,0,0,0]
["Client H","House 2",507,"SA722-3603 GH CORE","GH Group Home","2019-09-01",null,"2019-12-31",null,122,"",6,441.64,null,null,null,null,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,0,70.170000000000016,524.87,53880.08,1001.6200000000001,591.69999999999993,0,55473.4,8104.4600000000009,204.95999999999998,251.32,0,0,0,8560.7400000000016,64034.14,171226.3,0,365]
["Client I","House 2",508,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-12-31","2019-01-21",21,1,3,223.56,null,null,null,null,0,0,0,0,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 J","House 3",538,"SA722-3603 GH CORE","GH Group Home","2019-01-01",null,"2019-01-30",null,30,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,6706.8,124.80000000000001,145.5,0,6977.0999999999995,1698.9,50.4,31.200000000000003,0,0,0,1780.5,8757.5999999999985,8757.5999999999985,0,30]
["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,0,0,0,0,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,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,0,0,0,0,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,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,0,0,0,0,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,0,0,0,0,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,0,0,0,0,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,0,0,0,0,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,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,4.58,7.9,51.01,292.85500000000002,68409.36,1272.96,1484.1,2838.1499999999996,74004.569999999992,10957.86,514.07999999999993,318.24,0,1401.48,2417.4,15609.06,89613.62999999999,106333.64,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,0,0,0,0,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,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,0,0,0,0,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,0,0,0,0,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,0,0,0,0,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 08","Cluster 2",516,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,2.5,10.44,49.32,201.67,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,452.5,1889.6399999999999,8926.92,36502.269999999997,0,0,0]
["Client 08","Cluster 2",516,"SA716-3603 SL CORE","SL Supported Living","2019-07-01",null,"2019-12-31",null,184,"",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,2.5,13.87,52.75,205.1,26645.040000000001,494.96,892.4,0,28032.399999999998,6259.68,309.12,125.12,0,460,2552.08,9706,37738.399999999994,74240.67,0,365]
["Client 09","Cluster 2",517,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-06-30",null,181,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,13.87,53.5,205.85,26210.61,486.89,877.84999999999991,0,27575.35,6157.6200000000008,304.08,123.08000000000001,0,588.25,2510.4699999999998,9683.5,37258.85,0,0,0]
["Client 09","Cluster 2",517,"SA716-3603 SL CORE","SL Supported Living","2019-07-01",null,"2019-12-31",null,184,"",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,7.9,47.53,199.88,26645.040000000001,494.96,892.4,0,28032.399999999998,6259.68,309.12,125.12,0,598,1453.6000000000001,8745.52,36777.919999999998,74036.77,0,365]
["Client 10","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,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,3.2,7.9,49.63,291.47500000000002,81599.399999999994,1518.4,1770.2499999999998,3385.3749999999995,88273.425000000003,13070.650000000001,613.19999999999993,379.6,0,1168,2883.5,18114.95,106388.375,106388.375,0,365]
["Client 11","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,0,0,0,0,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 11","Cluster 3",519,"SA716-3603 SL CORE","SL Supported Living","2019-10-01",null,"2019-12-31",null,92,"",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,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 12","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 13","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 14","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 14","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 15","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 15","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 16","Cluster 3",524,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,1,3,223.56,0.2,38.75,0.25,26.5,0,0,0,0,14.375,4.16,4.8499999999999996,246.94499999999999,35.81,1.68,1.04,0,2.5,2.5,43.53,290.47500000000002,81599.399999999994,1518.4,1770.2499999999998,5246.875,90134.925000000003,13070.650000000001,613.19999999999993,379.6,0,912.5,912.5,15888.45,106023.375,106023.375,0,365]
["Client 17","Cluster 4",525,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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,2.5,0,38.880000000000003,191.23,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,912.5,0,14191.2,69798.95,69798.95,0,365]
["Client 20","Cluster 4",528,"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,3.47,0,42,274.57,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,1266.5500000000002,0,15330,100218.05,100218.05,0,365]
["Client 23","Cluster 4",531,"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,3.5,0,42.03,274.60000000000002,81599.399999999994,1518.4,1770.2499999999998,0,84888.05,13070.650000000001,613.19999999999993,379.6,0,1277.5,0,15340.95,100229,100229,0,365]
["Client 24","Cluster 4",532,"SA716-3603 SL CORE","SL Supported Living","2019-01-01",null,"2019-12-31",null,365,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.5,7.9,47.78,200.13,52855.65,981.85,1770.2499999999998,0,55607.75,12417.300000000001,613.19999999999993,248.20000000000002,0,1277.5,2883.5,17439.7,73047.45,73047.45,0,365]
["Client 25","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 27","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 28","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,"",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,{"$f":"IF(F52>0,+IF(I52>0,I52,H52)-IF(G52>0,G52,F52)+1,0)","v":0},"",null,null,null,null,null,null,0,0,0,0,{"$f":"+N52*O52+P52*Q52","v":0},null,null,{"$f":"(M52+V52+W52+X52)","v":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,{"$f":"IF(F57>0,+IF(I57>0,I57,H57)-IF(G57>0,G57,F57)+1,0)","v":0},"",null,null,null,null,null,null,0,0,0,0,{"$f":"+N57*O57+P57*Q57","v":0},null,null,{"$f":"(M57+V57+W57+X57)","v":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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z58:AE58)","v":0},{"$f":"+Y58+AF58","v":0},{"$f":"M58*J58","v":0},{"$f":"W58*J58","v":0},{"$f":"X58*J58","v":0},{"$f":"V58*J58","v":0},{"$f":"$J58*Y58","v":0},{"$f":"$J58*Z58","v":0},{"$f":"$J58*AA58","v":0},{"$f":"$J58*AB58","v":0},{"$f":"$J58*AC58","v":0},{"$f":"J58*AD58","v":0},{"$f":"$J58*AE58","v":0},{"$f":"$J58*AF58","v":0},{"$f":"AL58+AS58","v":0},{"$f":"IF(A59=A58,0,SUMIF($A$4:$A$4820,$A58,AL$4:AL$4820))+IF(A59=A58,0,SUMIF($A$4:$A$4820,$A58,AS$4:AS$4820))","v":0},0,{"$f":"IF(A59=A58,0,SUMIF($A$4:$A$4820,$A58,J$4:J$4820))+IF(A59=A58,0,SUMIF($A$4:$A$4820,$A58))","v":0}]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J58)","v":9477},{"$f":"SUBTOTAL(9,K4:K58)","v":33},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V58)","v":40.674999999999997},null,null,{"$f":"SUBTOTAL(9,Y4:Y58)","v":10385.075000000001},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AF4:AF58)","v":2317.9100000000008},12702.985000000001,2109537.8300000005,39241.409999999989,45963.449999999983,14299.15,2209041.8400000003,403723.11,15921.36,9841.4400000000023,0,18381.86,32326.699999999997,480194.47000000003,2689236.3100000005,2689236.31,null,{"$f":"SUBTOTAL(9,AW4:AW58)","v":9477}]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$60,J4:J57)","v":6506},{"$f":"SUMIF($E$4:$E$57,$E$60,K4:K57)","v":23},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$60,V4:V57)","v":40.674999999999997},null,null,{"$f":"SUMIF($E$4:$E$57,$E$60,Y4:Y57)","v":6726.1549999999997},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$60,AF4:AF57)","v":1510.8000000000002},8236.9549999999999,1259031.49,23429.889999999996,31554.100000000006,14299.15,1328314.6300000001,228651.95999999993,10930.080000000002,5877.91,0,18381.86,30049.199999999993,293891.01,1622205.64,1622205.6400000001,0,6506]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$61,J4:J58)","v":1876},{"$f":"SUMIF($E$4:$E$57,$E$61,K4:K58)","v":7},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$61,V4:V58)","v":0},null,null,{"$f":"SUMIF($E$4:$E$57,$E$61,Y4:Y58)","v":2600.2599999999998},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$61,AF4:AF58)","v":609.91999999999996},3210.1800000000003,476359.44,8858.27,9098.5999999999985,0,494316.30999999994,108506.09999999998,3151.6800000000003,2218.8300000000004,0,0,452.5,114329.11,608645.41999999993,608645.41999999993,0,1876]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$62,J4:J57)","v":1095},{"$f":"SUMIF($E$4:$E$57,$E$62,K4:K57)","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$62,V4:V57)","v":0},null,null,{"$f":"SUMIF($E$4:$E$57,$E$62,Y4:Y57)","v":1058.6600000000001},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$57,$E$62,AF4:AF57)","v":197.19},1255.8499999999999,374146.9,6953.25,5310.7499999999991,0,386410.9,66565.05,1839.6,1744.7,0,0,1825,71974.350000000006,458385.25,458385.25,0,1095]
["DSHS/DDA Schedule H Rate History (Rev.12/2019)"]

{"sheet":"2020 JAN","index":5,"n_rows":43,"n_cols":49,"rows_kept":43,"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]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,[13]List!A2:B132,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:AV38)","v":0}]
["Report Period",null,null,"2020-01-01",null,"2020-12-31",null,null,null,{"$f":"IF($AN$1=\"\",SUM(J4:J37),SUMIF($E$4:$E$37,$AN$1,J4:J37))","v":9882},{"$f":"IF($AN$1=\"\",SUM(K4:K37),SUMIF($E$4:$E$37,$AN$1,K4:K37))","v":27},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:AH37),SUMIF($E$4:$E$37,$AN$1,AH4:AH37))","v":2209223.5799999996},41076.180000000008,47927.699999999975,14887.05,2313114.5100000012,418074.48000000021,16601.759999999991,10306.56,0,19280.88,36826.920000000006,501090.59999999992,2814205.1100000008,2814205.1100000008,0,9882]
["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)","Transportion 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","2020-01-01",null,"2020-12-31",null,{"$f":"IF(F4>0,+IF(I4>0,I4,H4)-IF(G4>0,G4,F4)+1,0)","v":366},{"$f":"IF(C4<=0,\"\",IF(C4=C3,\"\",1))","v":1},4,291.70999999999998,null,null,null,null,0,0,0,0,{"$f":"+N4*O4+P4*Q4","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":106765.85999999999},{"$f":"W4*J4","v":1983.72},{"$f":"X4*J4","v":1775.1},{"$f":"V4*J4","v":0},{"$f":"$J4*Y4","v":110524.68000000001},{"$f":"$J4*Z4","v":21217.02},{"$f":"$J4*AA4","v":614.88},{"$f":"$J4*AB4","v":497.76000000000005},{"$f":"$J4*AC4","v":0},{"$f":"J4*AD4","v":0},{"$f":"$J4*AE4","v":0},{"$f":"$J4*AF4","v":22329.66},{"$f":"AL4+AS4","v":132854.34},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4800,$A4,AL$4:AL$4800))+IF(A5=A4,0,SUMIF($A$4:$A$4800,$A4,AS$4:AS$4800))","v":132854.34},{"$f":"IF($O4=$AU$1,$N4*$O4*$J4,0)+IF($Q4=$AU$1,$P4*$Q4*$J4,0)","v":0},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4800,$A4,J$4:J$4800))+IF(A5=A4,0,SUMIF($A$4:$A$4800,$A4))","v":366}]
["Client B","House 1",501,"SA722-3603 GH CORE","GH Group Home","2020-01-01",null,"2020-12-31",null,366,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,{"$f":"SUM(Z5:AE5)","v":59.35},{"$f":"+Y5+AF5","v":291.92},{"$f":"M5*J5","v":81822.960000000006},{"$f":"W5*J5","v":1522.56},{"$f":"X5*J5","v":1775.1},{"$f":"V5*J5","v":0},{"$f":"$J5*Y5","v":85120.62},{"$f":"$J5*Z5","v":20726.580000000002},{"$f":"$J5*AA5","v":614.88},{"$f":"$J5*AB5","v":380.64},{"$f":"$J5*AC5","v":0},{"$f":"J5*AD5","v":0},{"$f":"$J5*AE5","v":0},{"$f":"$J5*AF5","v":21722.100000000002},{"$f":"AL5+AS5","v":106842.72},{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4800,$A5,AL$4:AL$4800))+IF(A6=A5,0,SUMIF($A$4:$A$4800,$A5,AS$4:AS$4800))","v":106842.72},0,{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4800,$A5,J$4:J$4800))+IF(A6=A5,0,SUMIF($A$4:$A$4800,$A5))","v":366}]
["Client C","House 1",502,"SA722-3603 GH CORE","GH Group Home","2020-01-01",null,"2020-12-31",null,366,1,3,223.56,null,null,null,null,0,0,0,0,0,4.16,4.8499999999999996,232.57,56.63,1.68,1.04,0,0,0,59.35,291.92,81822.960000000006,1522.56,1775.1,0,85120.62,20726.580000000002,614.88,380.64,0,0,0,21722.100000000002,106842.72,106842.72,0,366]
["Client D","House 1",503,"SA722-3603 GH CORE","GH Group Home","2020-01-01",null,"2020-12-31",null,366,1,2,144.81,null,null,null,null,0,0,0,0,0,2.69,4.8499999999999996,152.35,54.84,1.68,0.68,0,0,0,57.2,209.55,53000.46,984.54,1775.1,0,55760.1,20071.440000000002,614.88,248.88000000000002,0,0,0,20935.2,76695.3,76695.3,0,366]
["Client E","House 1",504,"SA722-3905 GTH State","GTH Group Training Home","2020-01-01",null,"2020-12-31",null,366,1,6,441.64,null,null,null,null,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,2.5,72.670000000000016,527.37,161640.24,3004.86,1775.1,0,166420.19999999998,24313.38,614.88,753.96,0,0,915,26597.220000000005,193017.41999999998,193017.41999999998,0,366]
["Client F","House 2",505,"SA722-3905 GTH State","GTH Group Training Home","2020-01-01",null,"2020-12-31",null,366,1,4,291.70999999999998,null,null,null,null,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,2.5,63.51,365.49,106765.85999999999,1983.72,1775.1,0,110524.68000000001,21217.02,614.88,497.76000000000005,0,0,915,23244.66,133769.34,133769.34,0,366]
["Client G","House 2",506,"SA722-3905 GTH State","GTH Group Training Home","2020-01-01",null,"2020-12-31",null,366,1,4,291.70999999999998,null,null,null,null,0,0,0,0,0,5.42,4.8499999999999996,301.98,57.97,1.68,1.36,0,0,0,61.01,362.99,106765.85999999999,1983.72,1775.1,0,110524.68000000001,21217.02,614.88,497.76000000000005,0,0,0,22329.66,132854.34,132854.34,0,366]
["Client H","House 2",507,"SA722-3603 GH CORE","GH Group Home","2020-01-01",null,"2020-12-31",null,366,1,6,441.64,null,null,null,null,0,0,0,0,0,8.2100000000000009,4.8499999999999996,454.7,66.430000000000007,1.68,2.06,0,0,0,70.170000000000016,524.87,161640.24,3004.86,1775.1,0,166420.19999999998,24313.38,614.88,753.96,0,0,0,25682.220000000005,192102.41999999998,192102.41999999998,0,366]
["Client 01","Cluster 1",509,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,1,2,144.81,0.2,38.75,null,null,0,0,0,0,7.75,2.69,4.8499999999999996,160.1,34.020000000000003,1.68,0.68,0,2.25,2.5,41.13,201.23,53000.46,984.54,1775.1,2836.5,58596.6,12451.320000000002,614.88,248.88000000000002,0,823.5,915,15053.580000000002,73650.179999999993,73650.179999999993,0,366]
["Client 02","Cluster 1",510,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,13.87,54.65,287.21999999999997,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,823.5,5076.42,20001.899999999998,105122.51999999999,105122.51999999999,0,366]
["Client 03","Cluster 1",511,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,1.85,7.9,46.13,198.48,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,677.1,2891.4,16883.580000000002,72643.679999999993,72643.679999999993,0,366]
["Client 04","Cluster 2",512,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,1,3,223.56,0.35,26.5,null,null,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,4.58,7.9,51.01,292.85500000000002,81822.960000000006,1522.56,1775.1,3394.6499999999996,88515.27,13106.460000000001,614.88,380.64,0,1676.28,2891.4,18669.66,107184.93000000001,107184.93000000001,0,366]
["Client 06","Cluster 2",514,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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.35,0,40.880000000000003,273.45,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,860.1,0,14962.080000000002,100082.7,100082.7,0,366]
["Client 07","Cluster 2",515,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,2.5,10.44,49.32,201.67,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,915,3821.04,18051.12,73811.22,73811.22,0,366]
["Client 08","Cluster 2",516,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,2.5,13.87,52.75,205.1,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,915,5076.42,19306.5,75066.600000000006,75066.600000000006,0,366]
["Client 09","Cluster 2",517,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,7.9,47.53,199.88,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,1189.5,2891.4,17395.98,73156.08,73156.08,0,366]
["Client 10","Cluster 3",518,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,1,3,223.56,0.35,26.5,null,null,0,0,0,0,9.2749999999999986,4.16,4.8499999999999996,241.845,35.81,1.68,1.04,0,3.2,7.9,49.63,291.47500000000002,81822.960000000006,1522.56,1775.1,3394.6499999999996,88515.27,13106.460000000001,614.88,380.64,0,1171.2,2891.4,18164.580000000002,106679.85,106679.85,0,366]
["Client 11","Cluster 3",519,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,823.5,0,14925.48,100046.09999999999,100046.09999999999,0,366]
["Client 12","Cluster 3",520,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,823.5,0,14925.48,100046.09999999999,100046.09999999999,0,366]
["Client 13","Cluster 3",521,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,677.1,0,14779.080000000002,99899.7,99899.7,0,366]
["Client 14","Cluster 3",522,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,1,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,106765.85999999999,1983.72,1775.1,0,110524.68000000001,13596.9,614.88,497.76000000000005,0,1555.5,3821.04,20086.079999999998,130610.76000000001,130610.76000000001,0,366]
["Client 15","Cluster 3",523,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,1.88,2.5,40.760000000000005,193.11,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,688.07999999999993,915,14918.160000000002,70678.259999999995,70678.259999999995,0,366]
["Client 16","Cluster 3",524,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,1,3,223.56,0.2,38.75,0.25,26.5,0,0,0,0,14.375,4.16,4.8499999999999996,246.94499999999999,35.81,1.68,1.04,0,2.5,2.5,43.53,290.47500000000002,81822.960000000006,1522.56,1775.1,5261.25,90381.87,13106.460000000001,614.88,380.64,0,915,915,15931.98,106313.84999999999,106313.84999999999,0,366]
["Client 17","Cluster 4",525,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,2.5,0,38.880000000000003,191.23,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,915,0,14230.080000000002,69990.179999999993,69990.179999999993,0,366]
["Client 20","Cluster 4",528,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,3.47,0,42,274.57,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,1270.02,0,15372,100492.62,100492.62,0,366]
["Client 23","Cluster 4",531,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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,3.5,0,42.03,274.60000000000002,81822.960000000006,1522.56,1775.1,0,85120.62,13106.460000000001,614.88,380.64,0,1281,0,15382.98,100503.59999999999,100503.59999999999,0,366]
["Client 24","Cluster 4",532,"SA716-3603 SL CORE","SL Supported Living","2020-01-01",null,"2020-12-31",null,366,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.5,7.9,47.78,200.13,53000.46,984.54,1775.1,0,55760.1,12451.320000000002,614.88,248.88000000000002,0,1281,2891.4,17487.48,73247.58,73247.58,0,366]
[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,{"$f":"IF(F32>0,+IF(I32>0,I32,H32)-IF(G32>0,G32,F32)+1,0)","v":0},"",null,null,null,null,null,null,0,0,0,0,{"$f":"+N32*O32+P32*Q32","v":0},null,null,{"$f":"(M32+V32+W32+X32)","v":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,{"$f":"IF(C37<=0,\"\",IF(C37=C36,\"\",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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Z38:AE38)","v":0},{"$f":"+Y38+AF38","v":0},{"$f":"M38*J38","v":0},{"$f":"W38*J38","v":0},{"$f":"X38*J38","v":0},{"$f":"V38*J38","v":0},{"$f":"$J38*Y38","v":0},0,0,0,null,{"$f":"J38*AD38","v":0},{"$f":"$J38*AE38","v":0},0,{"$f":"AL38+AS38","v":0},{"$f":"IF(A39=A38,0,SUMIF($A$4:$A$4800,$A38,AL$4:AL$4800))+IF(A39=A38,0,SUMIF($A$4:$A$4800,$A38,AS$4:AS$4800))","v":0},{"$f":"IF($O38=$AU$1,$N38*$O38*$J38,0)+IF($Q38=$AU$1,$P38*$Q38*$J38,0)","v":0},{"$f":"IF(C39=C38,0,SUMIF($C$4:$C$4592,$C38,J$4:J$4592))+IF(C39=C38,0,SUMIF($C$5:$C$4593,$C38))","v":0}]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J38)","v":9882},{"$f":"SUBTOTAL(9,K4:K38)","v":27},null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V4:V38)","v":40.674999999999997},null,null,{"$f":"SUBTOTAL(9,Y4:Y38)","v":6319.9849999999988},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AF4:AF38)","v":1369.1},7689.085,2209223.5799999996,41076.180000000008,47927.699999999975,14887.05,2313114.5100000012,418074.48000000021,16601.759999999991,10306.56,0,19280.88,36826.920000000006,501090.59999999992,2814205.1100000008,2814205.1100000008,null,{"$f":"SUBTOTAL(9,AW4:AW38)","v":9882}]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$40,J4:J37)","v":6954},{"$f":"SUMIF($E$4:$E$37,$E$40,K4:K37)","v":19},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$40,V4:V37)","v":40.674999999999997},null,null,{"$f":"SUMIF($E$4:$E$37,$E$40,Y4:Y37)","v":3887.1550000000002},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$40,AF4:AF37)","v":864.82999999999981},4751.9849999999997,1348999.14,25085.640000000007,33726.899999999987,14887.05,1422698.7300000004,244272.06000000003,11682.719999999996,6295.2000000000007,0,19280.88,34996.920000000006,316527.77999999997,1739226.5100000002,1739226.5100000002,0,6954]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$41,J4:J38)","v":1830},{"$f":"SUMIF($E$4:$E$37,$E$41,K4:K38)","v":5},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$41,V4:V38)","v":0},null,null,{"$f":"SUMIF($E$4:$E$37,$E$41,Y4:Y38)","v":1374.1699999999998},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$41,AF4:AF38)","v":307.08000000000004},1681.25,485052.48000000004,9018.24,8875.5,0,502946.22,107055.00000000001,3074.4,2261.88,0,0,0,112391.28,615337.5,615337.5,0,1830]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$42,J4:J37)","v":1098},{"$f":"SUMIF($E$4:$E$37,$E$42,K4:K37)","v":3},null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$42,V4:V37)","v":0},null,null,{"$f":"SUMIF($E$4:$E$37,$E$42,Y4:Y37)","v":1058.6600000000001},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$37,$E$42,AF4:AF37)","v":197.19},1255.8499999999999,375171.95999999996,6972.3,5325.2999999999993,0,387469.56,66747.42,1844.6399999999999,1749.48,0,0,1830,72171.540000000008,459641.1,459641.1,0,1098]
["DSHS/DDA Schedule H Rate History (Rev.12/2019)"]

{"sheet":"List","index":6,"n_rows":139,"n_cols":7,"rows_kept":139,"cut":false,"hidden":true,"merged":[]}
["Provider","Provider ID a.","Benchmark or Avg Benchmark","Urban Designation",null,null,"Program Type"]
[]
["1N - Aacres WA",111414301,18.43,"MSA",null,null,"SL Supported Living"]
["1N - Aacres Spokane 2",111414310,18.43,"MSA",null,null,"GH Group Home"]
["1N - Aacres Spokane 3",111414309,18.43,"MSA",null,null,"GTH Group Training Home"]
["1N - Adult Guidance & Empowerment Service",111684901,18.43,"MSA"]
["1N - Ambitions - Spokane",111901906,18.43,"MSA"]
["1N - Ambitions - Wenatchee, Omak, Moses Lake",111901903,18.274999999999999,"MSA/NON-MSA"]
["1N - ARC of Spokane",111426502,18.43,"MSA"]
["1N - Assisted Residential Services",111705601,18.43,"MSA"]
["1N - Community Integrated Services",111425301,18.43,"MSA"]
["1N - Community Visions",111530102,18.43,"MSA"]
["1N - Dreamworks Residential",111913801,18.12,"NON-MSA"]
["1N - Drive Services",111621401,18.43,"MSA"]
["1N - Excel Supported Living",111322002,18.43,"MSA"]
["1N - Grant County Developmental Disabilities (DCL)",200012501,18.12,"NON-MSA"]
["1N - Kaler House",111686001,18.43,"MSA"]
["1N - L.M.K.",111988202,18.12,"NON-MSA"]
["1N - Latah Services",111762501,18.43,"MSA"]
["1N - Living In Fulfilling Environment",111777301,18.43,"MSA"]
["1N - Mission Vista",111707401,18.43,"MSA"]
["1N - Parent's Cooperative Society for the Handicapped (Merry Glen)",111328901,18.43,"MSA"]
["1N - Skils'kin",111632701,18.43,"MSA"]
["1S - Alternative Residential Services",111625401,18.274999999999999,"MSA/NON-MSA"]
["1S - Ambitions - Kennewick",111901901,18.43,"MSA"]
["1S - Ambitions - Yakima",111901907,18.43,"MSA"]
["1S - Community Living",111962202,18.43,"MSA"]
["1S - Deaf Access Washington",111321901,18.43,"MSA"]
["1S - Elmview",111604101,18.274999999999999,"MSA/NON-MSA"]
["1S - Habilitat",111449601,18.12,"NON-MSA"]
["1S - Kittitas Interactive Management",111688701,18.12,"NON-MSA"]
["1S - Reach Supported Living",209862801,18.43,"MSA"]
["1S - Tri-Cities Residential Services",111872501,18.43,"MSA"]
["1S - Valley Residential Services",111777901,18.12,"NON-MSA"]
["2N - Aacres",111414307,18.43,"MSA"]
["2N - Access Living",111675101,18.43,"MSA"]
["2N - All Heart Agency",111961601,18.43,"MSA"]
["2N - Alpha Supported Living Services",111320902,18.43,"MSA"]
["2N - Ambitions Whatcom",111901908,18.43,"MSA"]
["2N - Camelot Society",101955202,18.43,"MSA"]
["2N - Cascade Connections",111724102,18.43,"MSA"]
["2N - Evergreen Supported Living",111690301,18.43,"MSA"]
["2N - Holly Community Services",111765001,18.43,"MSA"]
["2N - La Casa de Esperanza ",111390801,18.43,"MSA"]
["2N - Puffin Island",111959501,18.43,"MSA"]
["2N - Quilceda Community Services",111321203,18.43,"MSA"]
["2N - Rehabco",111681901,18.43,"MSA"]
["2N - Rescare",111968512,18.43,"MSA"]
["2N - Sails",111805705,18.43,"MSA"]
["2N - Service Alternatives for WA",111513304,18.43,"MSA"]
["2N - Snohomish Supportive Living Services",111518901,18.43,"MSA"]
["2N - Soundview Association",111830201,18.43,"MSA"]
["2N - Steps Toward Independence",112034301,18.43,"MSA"]
["2N - Sunrise Services",203434610,18.43,"MSA"]
["2N - Village Community Services",111938301,18.43,"MSA"]
["2N - Volunteers of America",200494106,18.43,"MSA"]
["2S - Aacres",111414302,19.03,"KING"]
["2S - Alpha Supported Living Services",111320901,19.03,"KING"]
["2S - Ambitions",111901902,19.03,"KING"]
["2S - Arc of King County",112013701,19.03,"KING"]
["2S - Banchero Friends Services",111415001,19.03,"KING"]
["2S - Bethesda Lutheran Communities",111621301,19.03,"KING"]
["2S - Camelot Society",101955201,19.03,"KING"]
["2S - Cascade Community Services",111875001,19.03,"KING"]
["2S - Citizen Access Residential Resources",111533401,19.03,"KING"]
["2S - Community Integrated Services",111425302,19.03,"KING"]
["2S - Community Living",111962201,19.03,"KING"]
["2S - Destiny House Operations",111992801,19.03,"KING"]
["2S - Friendship House",111405501,19.03,"KING"]
["2S - Greenwood Home",111913301,19.03,"KING"]
["2S - Habilitation Services",208173701,19.03,"KING"]
["2S - Helping Hands for the Disabled",111736002,19.03,"KING"]
["2S - Inglewood Residential and Community Services",111568401,19.03,"KING"]
["2S - Integrated Living Services",111789002,19.03,"KING"]
["2S - L'Arche Noah Sealth of Seattle",111798601,19.03,"KING"]
["2S - Life Skills Center",111499601,19.03,"KING"]
["2S - Maksu",111577901,19.03,"KING"]
["2S - Nellie Goodhue Group Homes",111800501,19.03,"KING"]
["2S - Parkview Services",111456901,19.03,"KING"]
["2S - Premier Care Services",111437001,19.03,"KING"]
["2S - Provail",101144803,19.03,"KING"]
["2S - Puget Sound Regional Services",111925301,19.03,"KING"]
["2S - Res-Care Washington",111968506,19.03,"KING"]
["2S - Sails",111805704,19.03,"KING"]
["2S - Service Alternatives for WA",111513302,19.03,"KING"]
["2S - Shamrock Living Services",111958301,19.03,"KING"]
["2S - Shared Journeys",111515201,19.03,"KING"]
["2S - Stand Together",111753401,19.03,"KING"]
["2S - Tahoma Hills",111799101,19.03,"KING"]
["2S - Total Living Concept",111571101,19.03,"KING"]
["2S - United Friends Group Home",101601101,19.03,"KING"]
["2S - Volunteers of America",200494104,19.03,"KING"]
["3N - Aacres WA",111414304,18.43,"MSA"]
["3N - Ambitions, WA",111901904,18.43,"MSA"]
["3N - Communitas Group",102702801,18.43,"MSA"]
["3N - Community Alternatives for People with Autism (CAPA)",112026801,18.43,"MSA"]
["3N - Educational Programs in Home Living",111975401,18.43,"MSA"]
["3N - Group Action for Peninsula People",111703801,18.43,"MSA"]
["3N - Hope Human Services",207150601,18.43,"MSA"]
["3N - Kitsap Residences",111781001,18.43,"MSA"]
["3N - Kitsap Tenant Support Services",111715902,18.43,"MSA"]
["3N - L'Arche Tahoma Hope Community",111610303,18.43,"MSA"]
["3N - Life Force Services",111691201,18.43,"MSA"]
["3N - NW Services for Independent Living",111812601,18.43,"MSA"]
["3N - Options Unlimited",111904801,18.43,"MSA"]
["3N - PAM Group Home",111728401,18.43,"MSA"]
["3N - Puget Sound Assisted Living",111557601,18.43,"MSA"]
["3N - Res-Care Washington",111968504,18.43,"MSA"]
["3N - Self Determined Services ",111874501,18.43,"MSA"]
["3N - Self Reliant Endeavors",204861001,18.43,"MSA"]
["3N - Service Alternatives for WA",111513305,18.43,"MSA"]
["3N - Tahoma Associates",111335302,18.43,"MSA"]
["3N - Valley Supported Living",111938101,18.43,"MSA"]
["3S - Aacres - Clark",111414303,18.12,"NON-MSA"]
["3S - Aacres - Thurston",111414308,18.43,"MSA"]
["3S - ABC Residential Services",555777999,18.43,"MSA"]
["3S - Ambitions",111901905,18.274999999999999,"MSA/NON-MSA"]
["3S - Another Option",111619102,18.43,"MSA"]
["3S - Arc of Clark County",102623403,18.43,"MSA"]
["3S - Brighton Enterprises - Clark",111686601,18.43,"MSA"]
["3S - Brighton Enterprises - Thurston",111686602,18.43,"MSA"]
["3S - Caregivers of Washington",203690902,18.12,"NON-MSA"]
["3S - CCH Individual Support Services",111909801,18.12,"NON-MSA"]
["3S - Citizen Access Residential Resources",111533403,18.43,"MSA"]
["3S - Community Resources",111977701,18.274999999999999,"MSA/NON-MSA"]
["3S - Exceptional Foresters",111551801,18.43,"MSA"]
["3S - Harbor Alternative Living Association",111349601,18.12,"NON-MSA"]
["3S - Hope Human Services",207150603,18.43,"MSA"]
["3S - Kitsap Tenant Support Services",111715901,18.12,"NON-MSA"]
["3S - Kokua",111492901,18.43,"MSA"]
["3S - Life Force Services - Clark",111691204,18.43,"MSA"]
["3S - Life Force Services - Thurston",111691202,18.43,"MSA"]
["3S - Life Works",111594402,18.43,"MSA"]
["3S - Placeone",111512001,18.43,"MSA"]
["3S - Reside Residential Care of Washington",111864101,18.43,"MSA"]
["3S - ROAR",111442501,18.43,"MSA"]
["3S - SOLO",111910501,18.43,"MSA"]
["3S - Twin Harbors Group Home Association",111669901,18.12,"NON-MSA"]
["3S - Vancare",111811201,18.43,"MSA"]