{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["2025 JAN","Exhibit","2025 JUN","COCA","YE Schedule H Rate History","2026 JAN","List"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":11,"defined_names":12013,"comments":4,"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":"2025 JAN","index":0,"n_rows":32,"n_cols":38,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,4],[1,5,1,8],[1,11,1,23],[0,0,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,10],[0,11,0,37]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,List!A2:C141,2)","v":555777999},null,null,null,"FOR PROVIDER USE ONLY\nDO NOT SUBMIT WITH COST REPORT"]
["Report Period",null,null,"2025-01-01",null,"2025-12-31",null,null,null,{"$f":"IF($AD$1=\"\",SUM(J4:J27),SUMIF($E$4:$E$27,$AD$1,J4:J27))","v":5110},{"$f":"IF($AD$1=\"\",SUM(K4:K27),SUMIF($E$4:$E$27,$AD$1,K4:K27))","v":14},"Annual Totals",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$1=\"\",SUM(Y4:Y27),SUMIF($E$4:$E$27,$AD$1,Y4:Y27))","v":1130784.6000000001},9603.15,21027.650000000005,1161415.4000000001,220492.84999999998,0,5270.6,12775,7475.2,16319.15,262332.80000000005,1423748.2000000002,1423748.2000000002,5110]
["Client Name (b) ","COCA Recipient","Client P1 ID (c)","P1 Service Code/RAC (v)","Program Type","Rate Effective Date (d)","Actual Start Date Overrides Column F","Rate End Date","Actual End Date Overrides Column H","Resid Days Paid","Client Count","ISS Tier Level (e)","ISS Tier Rate (f)","ISS Prof Svs Rate (k)","ISS CRST Tier Rate (l)","Total ISS Daily Rate","Admin Tier Rate (n)","Temp Rate Adjust (o)","Admin CRST Tier Rate (p)","Admin Cert Rate (q)","Transport Rate (r)","Other Non-ISS Rates (s)","Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Paid","Annual ISS Prof Svs Paid","Annual ISS CRST Paid","Total Annual ISS Paid","Annual Admin Paid","Annual Temp Rate Adjust","Annual Admin CRST Paid","Annual Admin Cert Paid","Annual Transport Paid","Annual Other Non-ISS Paid","Total Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Annual ISS & Non-ISS Paid per Client","Annual Days Paid per Client"]
["Client A",null,500,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-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,0,5.42,{"$f":"SUM(M4:O4)","v":297.13},57.97,0,1.36,2.5,0,0,{"$f":"SUM(Q4:V4)","v":61.83},{"$f":"+P4+W4","v":358.96},{"$f":"M4*J4","v":106474.15},{"$f":"J4*N4","v":0},{"$f":"O4*J4","v":1978.3},{"$f":"$J4*P4","v":108452.45},21159.05,0,496.40000000000003,912.5,0,0,22567.95,{"$f":"AB4+AI4","v":131020.4},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4789,$A4,AB$4:AB$4789))+IF(A5=A4,0,SUMIF($A$4:$A$4789,$A4,AI$4:AI$4789))","v":131020.4},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4789,$A4,J$4:J$4789))+IF(A5=A4,0,SUMIF($A$4:$A$4789,$A4))","v":365}]
["Client B",null,502,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-12-31",null,{"$f":"IF(F5>0,+IF(I5>0,I5,H5)-IF(G5>0,G5,F5)+1,0)","v":365},{"$f":"IF(C5<=0,\"\",IF(C5=C4,\"\",1))","v":1},3,223.56,0,4.16,{"$f":"SUM(M5:O5)","v":227.72},56.63,0,1.04,2.5,0,0,{"$f":"SUM(Q5:V5)","v":60.17},{"$f":"+P5+W5","v":287.89},{"$f":"M5*J5","v":81599.399999999994},{"$f":"J5*N5","v":0},{"$f":"O5*J5","v":1518.4},{"$f":"$J5*P5","v":83117.8},{"$f":"$J5*Q5","v":20669.95},{"$f":"$J5*R5","v":0},{"$f":"$J5*S5","v":379.6},{"$f":"$J5*T5","v":912.5},{"$f":"$J5*U5","v":0},{"$f":"$J5*V5","v":0},{"$f":"$J5*W5","v":21962.05},{"$f":"AB5+AI5","v":105079.85},{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4789,$A5,AB$4:AB$4789))+IF(A6=A5,0,SUMIF($A$4:$A$4789,$A5,AI$4:AI$4789))","v":105079.85},{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4789,$A5,J$4:J$4789))+IF(A6=A5,0,SUMIF($A$4:$A$4789,$A5))","v":365}]
["Client C",null,503,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-12-31",null,365,1,2,144.81,7.75,2.69,155.25,54.84,0,0.68,2.5,0,2.5,60.52,215.77,52855.65,2828.75,981.85,56666.25,20016.600000000002,0,248.20000000000002,912.5,0,912.5,22089.800000000003,78756.05,78756.05,365]
["Client D",null,505,"SA722-3905 GTH State","GTH Group Training Home","2025-01-01",null,"2025-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,2.5,64.33,361.46,106474.15,0,1978.3,108452.45,21159.05,0,496.40000000000003,912.5,0,912.5,23480.45,131932.9,131932.9,365]
["Client E",null,506,"SA722-3905 GTH State","GTH Group Training Home","2025-01-01",null,"2025-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,0,61.83,358.96,106474.15,0,1978.3,108452.45,21159.05,0,496.40000000000003,912.5,0,0,22567.95,131020.4,131020.4,365]
["Client 01",null,509,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.25,2.5,41.95,189.45,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,821.25,912.5,15311.750000000002,69149.25,69149.25,365]
["Client 02",null,510,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,2.25,13.87,55.47,292.47000000000003,81599.399999999994,3387.2,1518.4,86505,13070.650000000001,0,379.6,912.5,821.25,5062.5499999999993,20246.55,106751.55,106751.55,365]
["Client 04",null,512,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,10.44,51.64,279.36,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,675.25,3810.6,18848.599999999999,101966.39999999999,101966.39999999999,365]
["Client 05",null,513,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.88,2.5,43.730000000000004,271.45,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,686.19999999999993,912.5,15961.45,99079.25,99079.25,365]
["Client 07",null,515,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.5,2.5,42.2,189.7,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,912.5,912.5,15403.000000000002,69240.5,69240.5,365]
["Client 08",null,518,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,3.2,7.9,50.45,287.45,81599.399999999994,3387.2,1518.4,86505,13070.650000000001,0,379.6,912.5,1168,2883.5,18414.25,104919.25,104919.25,365]
["Client 10",null,520,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.25,0,41.6,269.32,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,821.25,0,15184,98301.8,98301.8,365]
["Client 11",null,521,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,0,41.2,268.92,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,675.25,0,15038.000000000002,98155.8,98155.8,365]
["Client 16",null,536,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.4500000000000002,0,41.800000000000004,269.52,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,894.25000000000011,0,15257.000000000002,98374.8,98374.8,365]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,0,null,{"$f":"SUM(M27:O27)","v":0},null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J27)","v":5110},{"$f":"SUBTOTAL(9,K4:K27)","v":14},null,null,null,null,{"$f":"SUBTOTAL(9,P4:P27)","v":3181.9599999999996},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,W4:W27)","v":718.72000000000014},3900.68,1130784.6000000001,9603.15,21027.650000000005,1161415.4000000001,220492.84999999998,0,5270.6,12775,7475.2,16319.15,262332.80000000005,1423748.2000000002,1423748.2000000002,5110]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$29,J4:J26)","v":3285},{"$f":"SUMIF($E$4:$E$26,$E$29,K4:K26)","v":9},null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$29,P4:P26)","v":1907.6000000000001},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$29,W4:W26)","v":410.04},2317.64,676907.10000000009,6774.4,12592.5,696274.00000000012,116329.15,0,3153.6,8212.5,7475.2,14494.15,149664.6,845938.60000000009,845938.60000000009,3285]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$30,J4:J27)","v":1095},{"$f":"SUMIF($E$4:$E$26,$E$30,K4:K27)","v":3},null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$30,P4:P27)","v":680.1},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$30,W4:W27)","v":182.52},862.61999999999989,240929.19999999998,2828.75,4478.55,248236.5,61845.600000000006,0,1124.2,2737.5,0,912.5,66619.8,314856.3,314856.3,1095]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$31,J4:J26)","v":730},{"$f":"SUMIF($E$4:$E$26,$E$31,K4:K26)","v":2},null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$31,P4:P26)","v":594.26},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$26,$E$31,W4:W26)","v":126.16},720.42,212948.3,0,3956.6,216904.9,42318.1,0,992.80000000000007,1825,0,912.5,46048.4,262953.3,262953.3,730]
["DSHS/DDA Schedule H Rate History (Rev. 08/2024)"]

{"sheet":"Exhibit","index":1,"n_rows":30,"n_cols":23,"rows_kept":30,"cut":false,"hidden":false,"merged":[[3,18,3,22],[3,0,3,6],[2,18,2,22],[2,15,2,16],[3,15,3,16],[2,10,2,11],[3,10,3,11],[2,0,2,5],[2,7,2,8],[3,7,3,8],[5,0,5,22],[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,null,null,null,null,null,null,null,null,null,null,"Revision #: 250101"]
[]
["ABC Residential Services",null,null,null,null,null,null,555777999,null,null,"1234-567890",null,null,"3S",null,"2025-03-01",null,null,14]
["Contractor Name",null,null,null,null,null,null,"Provider ID",null,null,"Contract No.",null,null,"Region",null,"Process Date",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"]
["Program Name","Client Name","Client P1 ID","Rate Effective Date","ISS Tier Level","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","Total ISS Daily Rate","Admin Tier Rate","Temp Rate Adjust","Admin CRST Tier Rate","Cert Rate","Trans Rate","Other Non-ISS Rates","Total Non-ISS Daily Rate","Total Daily Rate","P1 Service Code-RAC","Revision #"]
["ABC Residential Services","Client A",500,"2025-01-01",4,291.70999999999998,0,0,0,0,0,5.42,{"$f":"SUM(F13,K13,L13)","v":297.13},57.97,0,1.36,2.5,0,0,{"$f":"SUM(N13:S13)","v":61.83},{"$f":"M13+T13","v":358.96},"SA722-3603",250100]
["ABC Residential Services","Client B",502,"2025-01-01",3,223.56,0,0,0,0,0,4.16,{"$f":"SUM(F14,K14,L14)","v":227.72},56.63,0,1.04,2.5,0,0,{"$f":"SUM(N14:S14)","v":60.17},{"$f":"M14+T14","v":287.89},"SA722-3603",250100]
["ABC Residential Services","Client C",503,"2025-01-01",2,144.81,0,0,0,0,7.75,2.69,155.25,54.84,0,0.68,2.5,0,2.5,60.52,215.77,"SA722-3603",250100]
["ABC Residential Services","Client D",505,"2025-01-01",4,291.70999999999998,0,0,0,0,0,5.42,297.13,57.97,0,1.36,2.5,0,0,61.83,358.96,"SA722-3905",250100]
["ABC Residential Services","Client E",506,"2025-01-01",4,291.70999999999998,0,0,0,0,0,5.42,297.13,57.97,0,1.36,2.5,0,0,61.83,358.96,"SA722-3905",250100]
["ABC Residential Services","Client 1",509,"2025-01-01",2,144.81,0,0,0,0,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.25,2.5,41.95,189.45,"SA716-3603",250100]
["ABC Residential Services","Client 2",510,"2025-01-01",3,223.56,0,0,0,0,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,2.25,13.87,55.47,292.47000000000003,"SA716-3603",250100]
["ABC Residential Services","Client 4",512,"2025-03-01",3,223.56,0.35,26.5,0,0,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,4.58,7.9,51.83,288.83,"SA716-3603",250101]
["ABC Residential Services","Client 7",515,"2025-01-01",2,144.81,0,0,0,0,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.5,2.5,42.2,189.7,"SA716-3603",250100]
["ABC Residential Services","Client 8",518,"2025-01-01",3,223.56,0.35,26.5,0,0,9.2799999999999994,4.16,{"$f":"SUM(F22,K22,L22)","v":237},35.81,0,1.04,2.5,3.2,7.9,{"$f":"SUM(N22:S22)","v":50.45},{"$f":"M22+T22","v":287.45},"SA716-3603",250100]
["ABC Residential Services","Client 10",520,"2025-01-01",3,223.56,0,0,0,0,0,4.16,227.72,35.81,0,1.04,2.5,2.25,0,41.6,269.32,"SA716-3603",250100]
["ABC Residential Services","Client 11",521,"2025-01-01",3,223.56,0,0,0,0,0,4.16,227.72,35.81,0,1.04,2.5,1.85,0,41.2,268.92,"SA716-3603",250100]
["ABC Residential Services","Client 13",523,"2025-02-01",2,144.81,0,0,0,0,0,2.69,147.5,34.020000000000003,0,0.68,2.5,3.25,2.5,42.95,190.45,"SA716-3603",250101]
["ABC Residential Services","Client 16",536,"2025-01-01",3,223.56,0,0,0,0,0,4.16,227.72,35.81,0,1.04,2.5,2.4500000000000002,0,41.800000000000004,269.52,"SA716-3603",250100]
[]
[]
[]
["DSHS/DDA Exhibit C (Rev. 08/2024)"]

{"sheet":"2025 JUN","index":2,"n_rows":37,"n_cols":38,"rows_kept":37,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,4],[1,5,1,8],[1,11,1,23],[0,0,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,10],[0,11,0,37]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,List!A2:C141,2)","v":555777999},null,null,null,"FOR PROVIDER USE ONLY\nDO NOT SUBMIT WITH COST REPORT"]
["Report Period",null,null,"2025-01-01",null,"2025-06-30",null,null,null,{"$f":"IF($AD$1=\"\",SUM(J4:J32),SUMIF($E$4:$E$32,$AD$1,J4:J32))","v":2642},{"$f":"IF($AD$1=\"\",SUM(K4:K32),SUMIF($E$4:$E$32,$AD$1,K4:K32))","v":18},"Annual Totals",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$1=\"\",SUM(Y4:Y32),SUMIF($E$4:$E$32,$AD$1,Y4:Y32))","v":573077.22},5894.27,10656.190000000002,589627.68000000005,115167.01000000001,0,2671.96,6605,4331.6399999999994,8104.3799999999992,136879.99,726507.67,726507.67,2642]
["Client Name (b) ","COCA Recipient","Client P1 ID (c)","P1 Service Code/RAC (v)","Program Type","Rate Effective Date (d)","Actual Start Date Overrides Column F","Rate End Date","Actual End Date Overrides Column H","Resid Days Paid","Client Count","ISS Tier Level (e)","ISS Daily Tier Rate (f)","ISS Prof Svs Daily Rate (k)","ISS CRST Tier Rate (l)","Total ISS Daily Rate","Admin Tier Rate (n)","Temp Rate Adjust (o)","Admin CRST Tier Rate (p)","Admin Cert Rate (q)","Transport Rate (r)","Other Non-ISS Rates (s)","Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Paid","Annual ISS Prof Svs Paid","Annual ISS CRST Paid","Total Annual ISS Paid","Annual Admin Paid","Annual Temp Rate Adjust","Annual Admin CRST Paid","Annual Admin Cert Paid","Annual Transport Paid","Annual Other Non-ISS Paid","Total Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Annual ISS & Non-ISS Paid per Client","Annual Days Paid per Client"]
["Client A",null,500,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-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,0,5.42,{"$f":"SUM(M4:O4)","v":297.13},57.97,0,1.36,2.5,0,0,{"$f":"SUM(Q4:V4)","v":61.83},{"$f":"+P4+W4","v":358.96},{"$f":"M4*J4","v":52799.509999999995},{"$f":"J4*N4","v":0},{"$f":"O4*J4","v":981.02},{"$f":"$J4*P4","v":53780.53},10492.57,0,246.16000000000003,452.5,0,0,11191.23,{"$f":"AB4+AI4","v":64971.759999999995},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4794,$A4,AB$4:AB$4794))+IF(A5=A4,0,SUMIF($A$4:$A$4794,$A4,AI$4:AI$4794))","v":64971.759999999995},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4794,$A4,J$4:J$4794))+IF(A5=A4,0,SUMIF($A$4:$A$4794,$A4))","v":181}]
["Client B",null,502,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-06-30",null,181,1,3,223.56,0,4.16,{"$f":"SUM(M5:O5)","v":227.72},56.63,0,1.04,2.5,0,0,60.17,287.89,40464.36,{"$f":"J5*N5","v":0},752.96,41217.32,10250.030000000001,0,188.24,452.5,0,0,10890.77,52108.09,{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4794,$A5,AB$4:AB$4794))+IF(A6=A5,0,SUMIF($A$4:$A$4794,$A5,AI$4:AI$4794))","v":52108.09},{"$f":"IF(A6=A5,0,SUMIF($A$4:$A$4794,$A5,J$4:J$4794))+IF(A6=A5,0,SUMIF($A$4:$A$4794,$A5))","v":181}]
["Client C",null,503,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-06-30",null,181,1,2,144.81,7.75,2.69,155.25,54.84,0,0.68,2.5,0,2.5,60.52,215.77,26210.61,1402.75,486.89,28100.25,9926.0400000000009,0,123.08000000000001,452.5,0,452.5,10954.12,39054.370000000003,39054.370000000003,181]
["Client D",null,505,"SA722-3905 GTH State","GTH Group Training Home","2025-01-01",null,"2025-06-30",null,181,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,2.5,64.33,361.46,52799.509999999995,0,981.02,53780.53,10492.57,0,246.16000000000003,452.5,0,452.5,11643.73,65424.259999999995,65424.259999999995,181]
["Client E",null,506,"SA722-3905 GTH State","GTH Group Training Home","2025-01-01",null,"2025-06-30",null,181,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,0,61.83,358.96,52799.509999999995,0,981.02,53780.53,10492.57,0,246.16000000000003,452.5,0,0,11191.23,64971.759999999995,64971.759999999995,181]
["Client F",null,508,"SA722-3603 GTH CORE","GTH Group Training Home","2025-03-16",null,"2025-06-30",null,107,1,3,223.56,0,4.16,227.72,56.63,0,1.04,2.5,0,0,60.17,287.89,23920.920000000002,0,445.12,24366.04,6059.41,0,111.28,267.5,0,0,6438.1900000000005,30804.230000000003,30804.230000000003,107]
["Client 01",null,509,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.25,2.5,41.95,189.45,26210.61,0,486.89,26697.5,6157.6200000000008,0,123.08000000000001,452.5,407.25,452.5,7592.9500000000007,34290.449999999997,34290.449999999997,181]
["Client 02",null,510,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,2.25,13.87,55.47,292.47000000000003,40464.36,1679.6799999999998,752.96,42897,6481.6100000000006,0,188.24,452.5,407.25,2510.4699999999998,10040.07,52937.07,52937.07,181]
["Client 04",null,512,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-02-28",59,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,10.44,51.64,279.36,13190.04,0,245.44,13435.48,2112.79,0,61.36,147.5,109.15,615.95999999999992,3046.76,16482.239999999998,0,0]
["Client 04",null,512,"SA716-3603 SL CORE","SL Supported Living","2025-03-01",null,"2025-06-30",null,122,"",3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,4.58,7.9,51.83,288.83,27274.32,1132.1599999999999,507.52000000000004,28914,4368.8200000000006,0,126.88000000000001,305,558.76,963.80000000000007,6323.26,35237.26,51719.5,181]
["Client 05",null,513,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-01-21",21,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.88,2.5,43.730000000000004,271.45,4694.76,0,87.36,4782.12,752.01,0,21.84,52.5,39.479999999999997,52.5,918.33,5700.45,5700.45,21]
["Client 06",null,514,"SA716-3603 SL CORE","SL Supported Living","2025-05-18","2025-05-15","2025-06-30",null,47,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.35,0,41.7,269.42,10507.32,0,195.52,{"$f":"$J15*P15","v":10702.84},1683.0700000000002,0,48.88,117.5,110.45,0,1959.9,12662.74,12662.74,47]
["Client 07",null,515,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.5,2.5,42.2,189.7,26210.61,0,486.89,26697.5,6157.6200000000008,0,123.08000000000001,452.5,452.5,452.5,7638.2000000000007,34335.699999999997,34335.699999999997,181]
["Client 08",null,518,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,3.2,7.9,50.45,287.45,40464.36,1679.6799999999998,752.96,42897,6481.6100000000006,0,188.24,452.5,579.20000000000005,1429.9,9131.4500000000007,52028.45,52028.45,181]
["Client 10",null,520,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.25,0,41.6,269.32,40464.36,0,752.96,41217.32,6481.6100000000006,0,188.24,452.5,407.25,0,7529.6,48746.92,48746.92,181]
["Client 11",null,521,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,0,41.2,268.92,40464.36,0,752.96,41217.32,6481.6100000000006,0,188.24,452.5,334.85,0,7457.2000000000007,48674.520000000004,48674.520000000004,181]
["Client 13",null,523,"SA716-3603 SL CORE","SL Supported Living","2025-02-01",null,"2025-06-30",null,150,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,3.25,2.5,42.95,190.45,21721.5,0,403.5,22125,5103.0000000000009,0,102.00000000000001,375,487.5,375,6442.5,28567.5,28567.5,150]
["Client 14",null,533,"SA716-3603 SL CORE","SL Supported Living","2025-06-05","2025-06-06","2025-06-30",null,25,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,5.76,13.87,58.98,286.7,5589,0,104,5693,895.25,0,26,62.5,144,346.75,1474.5,7167.5,7167.5,25]
["Client 16",null,536,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-04-30",120,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.4500000000000002,0,41.800000000000004,269.52,26827.200000000001,0,499.20000000000005,27326.400000000001,4297.2000000000007,0,124.80000000000001,300,294,0,5016.0000000000009,32342.400000000001,32342.400000000001,120]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,0,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A33=A32,0,SUMIF($A$4:$A$4794,$A32,AB$4:AB$4794))+IF(A33=A32,0,SUMIF($A$4:$A$4794,$A32,AI$4:AI$4794))","v":0},{"$f":"IF(A33=A32,0,SUMIF($A$4:$A$4794,$A32,J$4:J$4794))+IF(A33=A32,0,SUMIF($A$4:$A$4794,$A32))","v":0}]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J32)","v":2642},{"$f":"SUBTOTAL(9,K4:K32)","v":18},null,null,null,null,{"$f":"SUBTOTAL(9,P4:P32)","v":4249.619999999999},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,W4:W32)","v":974.35000000000025},5223.9699999999993,573077.22,5894.27,10656.190000000002,589627.68000000005,115167.01000000001,0,2671.96,6605,4331.6399999999994,8104.3799999999992,136879.99,726507.67,726507.67,2642]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$34,J4:J31)","v":1630},{"$f":"SUMIF($E$4:$E$31,$E$34,K4:K31)","v":12},null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$34,P4:P31)","v":2747.5399999999995},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$34,W4:W31)","v":605.49999999999989},3353.04,324082.8,4491.5199999999995,6028.16,334602.48000000004,57453.820000000007,0,1510.88,4075,4331.6399999999994,7199.3799999999992,74570.720000000001,409173.2,409173.2,1630]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$35,J4:J32)","v":543},{"$f":"SUMIF($E$4:$E$31,$E$35,K4:K32)","v":3},null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$35,P4:P32)","v":680.1},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$35,W4:W32)","v":182.52},862.61999999999989,119474.48,1402.75,2220.87,123098.1,30668.639999999999,0,557.48,1357.5,0,452.5,33036.120000000003,156134.22,156134.22,543]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$36,J4:J31)","v":469},{"$f":"SUMIF($E$4:$E$31,$E$36,K4:K31)","v":3},null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$36,P4:P31)","v":821.98},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$31,$E$36,W4:W31)","v":186.32999999999998},1008.31,129519.93999999999,0,2407.16,131927.1,27044.55,0,603.6,1172.5,0,452.5,29273.15,161200.25,161200.25,469]
["DSHS/DDA Schedule H Rate History (Rev. 08/2024)"]

{"sheet":"COCA","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"YE Schedule H Rate History","index":4,"n_rows":49,"n_cols":38,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,4],[1,5,1,8],[1,11,1,23],[0,0,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,10],[0,11,0,37]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,List!A2:C141,2)","v":555777999},null,null,null,"FOR PROVIDER USE ONLY\nDO NOT SUBMIT WITH COST REPORT"]
["Report Period",null,null,"2025-01-01",null,"2025-12-31",null,null,null,{"$f":"IF($AD$1=\"\",SUM(J4:J44),SUMIF($E$4:$E$44,$AD$1,J4:J44))","v":5868},{"$f":"IF($AD$1=\"\",SUM(K4:K44),SUMIF($E$4:$E$44,$AD$1,K4:K44))","v":22},"Annual Totals",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$1=\"\",SUM(Y4:Y44),SUMIF($E$4:$E$44,$AD$1,Y4:Y44))","v":1290135.6100000001},11016.829999999998,24381.02,1325533.4599999997,254136.72999999998,0,6111.6900000000014,14612.5,11102.199999999999,21183.71,307146.83000000013,1632680.29,1632680.29,5868]
["Client Name (b) ","COCA Recipient","Client P1 ID (c)","P1 Service Code/RAC (v)","Program Type","Rate Effective Date (d)","Actual Start Date Overrides Column F","Rate End Date","Actual End Date Overrides Column H","Resid Days Paid","Client Count","ISS Tier Level (e)","ISS Daily Tier Rate (f)","ISS Prof Svs Daily Rate (k)","ISS CRST Tier Rate (l)","Total ISS Daily Rate","Admin Tier Rate (n)","Temp Rate Adjust (o)","Admin CRST Tier Rate (p)","Admin Cert Rate (q)","Transport Rate (r)","Other Non-ISS Rates (s)","Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Paid","Annual ISS Prof Svs Paid","Annual ISS CRST Paid","Total Annual ISS Paid","Annual Admin Paid","Annual Temp Rate Adjust","Annual Admin CRST Paid","Annual Admin Cert Paid","Annual Transport Paid","Annual Other Non-ISS Paid","Total Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Annual ISS & Non-ISS Paid per Client","Annual Days Paid per Client"]
["Client A",null,500,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-12-31","2025-11-25",{"$f":"IF(F4>0,+IF(I4>0,I4,H4)-IF(G4>0,G4,F4)+1,0)","v":329},{"$f":"IF(C4<=0,\"\",IF(C4=C3,\"\",1))","v":1},4,291.70999999999998,0,5.42,{"$f":"SUM(M4:O4)","v":297.13},57.97,0,1.36,2.5,0,0,{"$f":"SUM(Q4:V4)","v":61.83},{"$f":"+P4+W4","v":358.96},{"$f":"M4*J4","v":95972.59},{"$f":"J4*N4","v":0},{"$f":"O4*J4","v":1783.18},{"$f":"$J4*P4","v":97755.77},19072.13,0,447.44000000000005,822.5,0,0,20342.07,{"$f":"AB4+AI4","v":118097.84},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4806,$A4,AB$4:AB$4806))+IF(A5=A4,0,SUMIF($A$4:$A$4806,$A4,AI$4:AI$4806))","v":118097.84},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4806,$A4,J$4:J$4806))+IF(A5=A4,0,SUMIF($A$4:$A$4806,$A4))","v":329}]
["Client B",null,502,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-12-31",null,{"$f":"IF(F5>0,+IF(I5>0,I5,H5)-IF(G5>0,G5,F5)+1,0)","v":365},{"$f":"IF(C5<=0,\"\",IF(C5=C4,\"\",1))","v":1},3,223.56,0,4.16,227.72,56.63,0,1.04,2.5,0,0,{"$f":"SUM(Q5:V5)","v":60.17},{"$f":"+P5+W5","v":287.89},81599.399999999994,0,1518.4,{"$f":"$J5*P5","v":83117.8},{"$f":"$J5*Q5","v":20669.95},{"$f":"$J5*R5","v":0},{"$f":"$J5*S5","v":379.6},{"$f":"$J5*T5","v":912.5},{"$f":"$J5*U5","v":0},{"$f":"$J5*V5","v":0},{"$f":"$J5*W5","v":21962.05},{"$f":"AB5+AI5","v":105079.85},105079.85,365]
["Client C",null,503,"SA722-3603 GH CORE","GH Group Home","2025-01-01",null,"2025-06-30",null,181,1,2,144.81,7.75,2.69,155.25,54.84,0,0.68,2.5,0,2.5,60.52,215.77,26210.61,1402.75,486.89,28100.25,9926.0400000000009,0,123.08000000000001,452.5,0,452.5,10954.12,39054.370000000003,0,0]
["Client C",null,503,"SA722-3603 GH CORE","GH Group Home","2025-07-01",null,"2025-12-31",null,184,"",2,144.81,0,2.69,147.5,54.84,0,0.68,2.5,0,0,58.02,205.52,26645.040000000001,0,494.96,27140,10090.560000000001,0,125.12,460,0,0,10675.68,37815.68,76870.05,365]
["Client D",null,505,"SA722-3905 GTH State","GTH Group Training Home","2025-01-01",null,"2025-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,2.5,64.33,361.46,106474.15,0,1978.3,108452.45,21159.05,0,496.40000000000003,912.5,0,912.5,23480.45,131932.9,131932.9,365]
["Client E",null,506,"SA722-3905 GTH State","GTH Group Training Home","2025-01-01",null,"2025-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,0,61.83,358.96,106474.15,0,1978.3,108452.45,21159.05,0,496.40000000000003,912.5,0,0,22567.95,131020.4,131020.4,365]
["Client F",null,508,"SA722-3603 GTH CORE","GTH Group Training Home","2025-03-16",null,"2025-12-31",null,291,1,3,223.56,0,4.16,227.72,56.63,0,1.04,2.5,0,0,60.17,287.89,65055.96,0,1210.56,66266.52,16479.330000000002,0,302.64,727.5,0,0,17509.47,83775.990000000005,83775.990000000005,291]
["Client 01",null,509,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.25,2.5,41.95,189.45,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,821.25,912.5,15311.750000000002,69149.25,69149.25,365]
["Client 02",null,510,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-07-02",183,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,2.25,13.87,55.47,292.47000000000003,40911.480000000003,1698.2399999999998,761.28,43371,6553.2300000000005,0,190.32,457.5,411.75,2538.21,10151.01,53522.01,0,0]
["Client 02","Client 8",510,"SA716-3603 SL CORE","SL Supported Living","2025-07-03",null,"2025-07-25",null,23,"",3,139.66,9.2799999999999994,3.17,152.10999999999999,37.229999999999997,0,0.79,0,0,0,38.019999999999996,190.13,3212.18,213.44,72.91,3498.5299999999997,856.29,0,18.170000000000002,0,0,0,874.45999999999992,4372.99,0,0]
["Client 02",null,510,"SA716-3603 SL CORE","SL Supported Living","2025-07-26",null,"2025-12-31",null,159,"",3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,2.25,13.87,55.47,292.47000000000003,35546.04,1475.52,661.44,37683,5693.79,0,165.36,397.5,357.75,2205.33,8819.73,46502.729999999996,104397.73,365]
["Client 03",null,511,"SA716-3603 SL CORE","SL Supported Living","2025-08-01","2025-08-03","2025-12-31","2025-10-31",90,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,1.85,7.9,46.95,194.45,13032.9,0,242.1,13275,3061.8,0,61.2,225,166.5,711,4225.5,17500.5,0,0]
["Client 03",null,511,"SA716-3603 SL CORE","SL Supported Living","2025-11-01",null,"2025-12-31",null,61,"",2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,3.5,10.44,51.14,198.64,8833.41,0,164.09,8997.5,2075.2200000000003,0,41.480000000000004,152.5,213.5,636.83999999999992,3119.54,12117.04,29617.54,151]
["Client 04",null,512,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-02-28",59,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,10.44,51.64,279.36,13190.04,0,245.44,13435.48,2112.79,0,61.36,147.5,109.15,615.95999999999992,3046.76,16482.239999999998,0,0]
["Client 04",null,512,"SA716-3603 SL CORE","SL Supported Living","2025-03-01",null,"2025-12-31",null,306,"",3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,4.58,7.9,51.83,288.83,68409.36,2839.68,1272.96,72522,10957.86,0,318.24,765,1401.48,2417.4,15859.98,88381.98,104864.22,365]
["Client 05",null,513,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-01-21",21,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.88,2.5,43.730000000000004,271.45,4694.76,0,87.36,4782.12,752.01,0,21.84,52.5,39.479999999999997,52.5,918.33,5700.45,5700.45,21]
["Client 06",null,514,"SA716-3603 SL CORE","SL Supported Living","2025-05-18","2025-05-15","2025-12-31",null,231,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.35,0,41.7,269.42,51642.36,0,960.96,52603.32,8272.11,0,240.24,577.5,542.85,0,9632.7000000000007,62236.020000000004,62236.020000000004,231]
["Client 07",null,515,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-06-30",null,181,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.5,2.5,42.2,189.7,26210.61,0,486.89,26697.5,6157.6200000000008,0,123.08000000000001,452.5,452.5,452.5,7638.2000000000007,34335.699999999997,0,0]
["Client 07",null,515,"SA716-3603 SL CORE","SL Supported Living","2025-07-01",null,"2025-12-31","2025-08-16",47,"",2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.5,10.44,50.14,197.64,6806.07,0,126.42999999999999,6932.5,1598.94,0,31.96,117.5,117.5,490.67999999999995,2356.58,9289.08,43624.78,228]
["Client 08",null,518,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,3.2,7.9,50.45,287.45,81599.399999999994,3387.2,1518.4,86505,13070.650000000001,0,379.6,912.5,1168,2883.5,18414.25,104919.25,104919.25,365]
["Client 09",null,519,"SA716-3603 SL CORE","SL Supported Living","2025-08-01","2025-08-15","2025-12-31","2025-09-30",47,1,5,364.4,0,6.78,371.17999999999995,40.9,0,1.69,2.5,2.25,0,47.339999999999996,418.51999999999992,17126.8,0,318.66000000000003,17445.46,1922.3,0,79.429999999999993,117.5,105.75,0,2224.98,19670.439999999999,0,0]
["Client 09",null,519,"SA716-3603 SL CORE","SL Supported Living","2025-10-01",null,"2025-12-31",null,92,"",3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.25,0,41.6,269.32,20567.52,0,382.72,20950.240000000002,3294.5200000000004,0,95.68,230,207,0,3827.2000000000003,24777.440000000002,44447.88,139]
["Client 10",null,520,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-09-04",247,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.25,0,41.6,269.32,55219.32,0,1027.52,56246.84,8845.07,0,256.88,617.5,555.75,0,10275.200000000001,66522.039999999994,66522.039999999994,247]
["Client 11",null,521,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,0,41.2,268.92,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,675.25,0,15038.000000000002,98155.8,98155.8,365]
["Client 12",null,522,"SA716-3603 SL CORE","SL Supported Living","2025-07-01",null,"2025-12-31","2025-08-31",62,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,4.58,10.44,54.37,282.08999999999997,13860.72,0,257.92,14118.64,2220.2200000000003,0,64.48,155,283.95999999999998,647.28,3370.94,17489.579999999998,0,0]
["Client 12",null,522,"SA716-3603 SL CORE","SL Supported Living","2025-09-01",null,"2025-12-31",null,122,"",4,291.70999999999998,0,5.42,297.13,37.15,0,1.36,2.5,4.25,10.44,55.699999999999996,352.83,35588.619999999995,0,661.24,36249.86,4532.3,0,165.92000000000002,305,518.5,1273.6799999999998,6795.4,43045.26,60534.84,184]
["Client 13",null,523,"SA716-3603 SL CORE","SL Supported Living","2025-02-01",null,"2025-12-31","2025-09-30",242,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,3.25,2.5,42.95,190.45,35044.020000000004,0,650.98,35695,8232.84,0,164.56,605,786.5,605,10393.900000000001,46088.9,0,0]
["Client 13",null,523,"SA716-3603 SL CORE","SL Supported Living","2025-10-01",null,"2025-12-31",null,92,"",2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,1.88,2.5,41.580000000000005,189.08,13322.52,0,247.48,13570,3129.84,0,62.56,230,172.95999999999998,230,3825.3600000000006,17395.36,63484.26,334]
["Client 14",null,533,"SA716-3603 SL CORE","SL Supported Living","2025-06-05","2025-06-06","2025-12-31",null,209,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,5.76,13.87,58.98,286.7,46724.04,0,869.44,47593.48,7484.2900000000009,0,217.36,522.5,1203.8399999999999,2898.83,12326.82,59920.3,59920.3,209]
["Client 15",null,535,"SA716-3603 SL CORE","SL Supported Living","2025-09-24",null,"2025-12-31",null,99,1,7,291.70999999999998,0,9.24,300.95,50.22,0,2.31,2.5,5.0199999999999996,2.5,62.55,363.5,28879.289999999997,0,914.76,29794.05,4971.78,0,228.69,247.5,496.97999999999996,247.5,6192.45,35986.5,35986.5,99]
["Client 16",null,536,"SA716-3603 SL CORE","SL Supported Living","2025-01-01",null,"2025-12-31","2025-04-30",120,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.4500000000000002,0,41.800000000000004,269.52,26827.200000000001,0,499.20000000000005,27326.400000000001,4297.2000000000007,0,124.80000000000001,300,294,0,5016.0000000000009,32342.400000000001,32342.400000000001,120]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,0,null,0,null,null,null,null,null,null,0,0,0,0,0,{"$f":"$J44*P44","v":0},0,0,0,0,0,0,0,0,0,0]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J44)","v":5868},{"$f":"SUBTOTAL(9,K4:K44)","v":22},null,null,null,null,{"$f":"SUBTOTAL(9,P4:P44)","v":6800.9300000000012},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,W4:W44)","v":1577.2299999999998},8378.159999999998,1290135.6100000001,{"$f":"SUBTOTAL(9,Z4:Z44)","v":11016.829999999998},24381.02,1325533.4599999997,254136.72999999998,0,6111.6900000000014,14612.5,11102.199999999999,21183.71,307146.83000000013,1632680.29,1632680.29,5868]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$46,J4:J43)","v":3788},{"$f":"SUMIF($E$4:$E$43,$E$46,K4:K43)","v":16},null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$46,P4:P43)","v":5151.3499999999995},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$46,W4:W43)","v":1150.3600000000001},6301.7099999999991,781703.71000000008,{"$f":"SUMIF($E$4:$E$43,$E$46,Z4:Z43)","v":9614.0799999999981},14930.43,806248.22000000009,135580.62000000002,0,3741.01,9412.5,11102.199999999999,19818.71,179655.03999999998,985903.26,985903.26000000013,3788]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$47,J4:J44)","v":1059},{"$f":"SUMIF($E$4:$E$43,$E$47,K4:K44)","v":3},null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$47,P4:P44)","v":827.6},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$47,W4:W44)","v":240.54000000000002},1068.1399999999999,230427.63999999998,{"$f":"SUMIF($E$4:$E$43,$E$47,Z4:Z44)","v":1402.75},4283.4299999999994,236113.82,59758.680000000008,0,1075.2400000000002,2647.5,0,452.5,63933.919999999998,300047.74,300047.74,1059]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$48,J4:J43)","v":1021},{"$f":"SUMIF($E$4:$E$43,$E$48,K4:K43)","v":3},null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$48,P4:P43)","v":821.98},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$43,$E$48,W4:W43)","v":186.32999999999998},1008.31,278004.26,{"$f":"SUMIF($E$4:$E$43,$E$48,Z4:Z43)","v":0},5167.16,283171.42,58797.43,0,1295.44,2552.5,0,912.5,63557.87,346729.29,346729.29,1021]
["DSHS/DDA Schedule H Rate History (Rev. 08/2024)"]

{"sheet":"2026 JAN","index":5,"n_rows":36,"n_cols":38,"rows_kept":36,"cut":false,"hidden":false,"merged":[[1,0,1,2],[1,3,1,4],[1,5,1,8],[1,11,1,23],[0,0,0,2],[0,3,0,4],[0,5,0,6],[0,7,0,10],[0,11,0,37]]}
["Program Name",null,null,"3S - ABC Residential Services",null,"Provider ID",null,{"$f":"VLOOKUP(D1,List!A2:C141,2)","v":555777999},null,null,null,"FOR PROVIDER USE ONLY\nDO NOT SUBMIT WITH COST REPORT"]
["Report Period",null,null,"2026-01-01",null,"2026-12-31",null,null,null,{"$f":"IF($AD$1=\"\",SUM(J4:J31),SUMIF($E$4:$E$31,$AD$1,J4:J31))","v":6570},{"$f":"IF($AD$1=\"\",SUM(K4:K31),SUMIF($E$4:$E$31,$AD$1,K4:K31))","v":18},"Annual Totals",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$1=\"\",SUM(Y4:Y31),SUMIF($E$4:$E$31,$AD$1,Y4:Y31))","v":1424569.4499999997},10161.599999999999,27882.350000000002,1462613.4000000001,276728.39999999997,0,6989.75,16425,15198.6,30973.899999999998,346315.65000000008,1808929.05,1808929.05,6570]
["Client Name (b) ","COCA Recipient","Client P1 ID (c)","P1 Service Code/RAC (v)","Program Type","Rate Effective Date (d)","Actual Start Date Overrides Column F","Rate End Date","Actual End Date Overrides Column H","Resid Days Paid","Client Count","ISS Tier Level (e)","ISS Daily Tier Rate (f)","ISS Prof Svs Daily Rate (k)","ISS CRST Tier Rate (l)","Total ISS Daily Rate","Admin Tier Rate (n)","Temp Rate Adjust (o)","Admin CRST Tier Rate (p)","Admin Cert Rate (q)","Transport Rate (r)","Other Non-ISS Rates (s)","Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Paid","Annual ISS Prof Svs Paid","Annual ISS CRST Paid","Total Annual ISS Paid","Annual Admin Paid","Annual Temp Rate Adjust","Annual Admin CRST Paid","Annual Admin Cert Paid","Annual Transport Paid","Annual Other Non-ISS Paid","Total Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Annual ISS & Non-ISS Paid per Client","Annual Days Paid per Client"]
["Client B",null,502,"SA722-3603 GH CORE","GH Group Home","2026-01-01",null,"2026-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},3,223.56,0,4.16,{"$f":"SUM(M4:O4)","v":227.72},56.63,0,1.04,2.5,0,0,{"$f":"SUM(Q4:V4)","v":60.17},{"$f":"+P4+W4","v":287.89},{"$f":"M4*J4","v":81599.399999999994},{"$f":"J4*N4","v":0},{"$f":"O4*J4","v":1518.4},{"$f":"$J4*P4","v":83117.8},{"$f":"$J4*Q4","v":20669.95},{"$f":"$J4*R4","v":0},{"$f":"$J4*S4","v":379.6},{"$f":"$J4*T4","v":912.5},{"$f":"$J4*U4","v":0},{"$f":"$J4*V4","v":0},{"$f":"$J4*W4","v":21962.05},{"$f":"AB4+AI4","v":105079.85},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4793,$A4,AB$4:AB$4793))+IF(A5=A4,0,SUMIF($A$4:$A$4793,$A4,AI$4:AI$4793))","v":105079.85},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4793,$A4,J$4:J$4793))+IF(A5=A4,0,SUMIF($A$4:$A$4793,$A4))","v":365}]
["Client C",null,503,"SA722-3603 GH CORE","GH Group Home","2026-01-01",null,"2026-12-31",null,{"$f":"IF(F5>0,+IF(I5>0,I5,H5)-IF(G5>0,G5,F5)+1,0)","v":365},{"$f":"IF(C5<=0,\"\",IF(C5=C4,\"\",1))","v":1},2,144.81,0,2.69,147.5,54.84,0,0.68,2.5,0,0,58.02,205.52,52855.65,0,981.85,53837.5,20016.600000000002,0,248.20000000000002,912.5,0,0,21177.300000000003,75014.8,75014.8,365]
["Client D",null,505,"SA722-3905 GTH State","GTH Group Training Home","2026-01-01",null,"2026-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,2.5,64.33,361.46,106474.15,0,1978.3,108452.45,21159.05,0,496.40000000000003,912.5,0,912.5,23480.45,131932.9,131932.9,365]
["Client E",null,506,"SA722-3905 GTH State","GTH Group Training Home","2026-01-01",null,"2026-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,57.97,0,1.36,2.5,0,0,61.83,358.96,106474.15,0,1978.3,108452.45,21159.05,0,496.40000000000003,912.5,0,0,22567.95,131020.4,131020.4,365]
["Client F",null,508,"SA722-3603 GTH CORE","GTH Group Training Home","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,0,4.16,227.72,56.63,0,1.04,2.5,0,0,60.17,287.89,81599.399999999994,0,1518.4,83117.8,20669.95,0,379.6,912.5,0,0,21962.05,105079.85,105079.85,365]
["Client 01",null,509,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.25,2.5,41.95,189.45,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,821.25,912.5,15311.750000000002,69149.25,69149.25,365]
["Client 02",null,510,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,2.25,13.87,55.47,292.47000000000003,81599.399999999994,3387.2,1518.4,86505,13070.650000000001,0,379.6,912.5,821.25,5062.5499999999993,20246.55,106751.55,106751.55,365]
["Client 03",null,511,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,3.5,10.44,51.14,198.64,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,1277.5,3810.6,18666.099999999999,72503.600000000006,72503.600000000006,365]
["Client 04",null,512,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,4.58,7.9,51.83,288.83,81599.399999999994,3387.2,1518.4,86505,13070.650000000001,0,379.6,912.5,1671.7,2883.5,18917.95,105422.95,105422.95,365]
["Client 06",null,514,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.35,0,41.7,269.42,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,857.75,0,15220.500000000002,98338.3,98338.3,365]
["Client 07",null,515,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,2.5,10.44,50.14,197.64,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,912.5,3810.6,18301.099999999999,72138.600000000006,72138.600000000006,365]
["Client 08",null,518,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,9.2799999999999994,4.16,237,35.81,0,1.04,2.5,3.2,7.9,50.45,287.45,81599.399999999994,3387.2,1518.4,86505,13070.650000000001,0,379.6,912.5,1168,2883.5,18414.25,104919.25,104919.25,365]
["Client 09",null,519,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,2.25,0,41.6,269.32,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,821.25,0,15184,98301.8,98301.8,365]
["Client 11",null,521,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,1.85,0,41.2,268.92,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,675.25,0,15038.000000000002,98155.8,98155.8,365]
["Client 12",null,522,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,4,291.70999999999998,0,5.42,297.13,37.15,0,1.36,2.5,4.25,10.44,55.699999999999996,352.83,106474.15,0,1978.3,108452.45,13559.75,0,496.40000000000003,912.5,1551.25,3810.6,20330.5,128782.95,128782.95,365]
["Client 13",null,523,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,2,144.81,0,2.69,147.5,34.020000000000003,0,0.68,2.5,1.88,2.5,41.580000000000005,189.08,52855.65,0,981.85,53837.5,12417.300000000001,0,248.20000000000002,912.5,686.19999999999993,912.5,15176.700000000003,69014.2,69014.2,365]
["Client 14",null,533,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,3,223.56,0,4.16,227.72,35.81,0,1.04,2.5,5.76,13.87,58.98,286.7,81599.399999999994,0,1518.4,83117.8,13070.650000000001,0,379.6,912.5,2102.4,5062.5499999999993,21527.699999999997,104645.5,104645.5,365]
["Client 15",null,535,"SA716-3603 SL CORE","SL Supported Living","2026-01-01",null,"2026-12-31",null,365,1,7,291.70999999999998,0,9.24,300.95,50.22,0,2.31,2.5,5.0199999999999996,2.5,62.55,363.5,106474.15,0,3372.6,109846.75,18330.3,0,843.15,912.5,1832.3,912.5,22830.75,132677.5,132677.5,365]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,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]
[null,null,null,null,null,null,null,null,null,0,"",null,null,null,null,0,null,null,null,null,null,null,{"$f":"SUM(Q30:V30)","v":0},{"$f":"+P30+W30","v":0},{"$f":"M30*J30","v":0},{"$f":"J30*N30","v":0},{"$f":"O30*J30","v":0},{"$f":"$J30*P30","v":0},0,0,0,0,0,0,0,{"$f":"AB30+AI30","v":0},{"$f":"IF(A31=A30,0,SUMIF($A$4:$A$4793,$A30,AB$4:AB$4793))+IF(A31=A30,0,SUMIF($A$4:$A$4793,$A30,AI$4:AI$4793))","v":0},{"$f":"IF(A31=A30,0,SUMIF($A$4:$A$4793,$A30,J$4:J$4793))+IF(A31=A30,0,SUMIF($A$4:$A$4793,$A30))","v":0}]
[null,null,null,null,null,null,null,null,null,0,"",null,null,0,null,0,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF(A32=A31,0,SUMIF($A$4:$A$4793,$A31,AB$4:AB$4793))+IF(A32=A31,0,SUMIF($A$4:$A$4793,$A31,AI$4:AI$4793))","v":0},{"$f":"IF(A32=A31,0,SUMIF($A$4:$A$4793,$A31,J$4:J$4793))+IF(A32=A31,0,SUMIF($A$4:$A$4793,$A31))","v":0}]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J31)","v":6570},{"$f":"SUBTOTAL(9,K4:K31)","v":18},null,null,null,null,{"$f":"SUBTOTAL(9,P4:P31)","v":4007.1599999999994},null,null,null,null,null,null,{"$f":"SUBTOTAL(9,W4:W31)","v":948.81000000000006},4955.9699999999993,1424569.4499999997,10161.599999999999,27882.350000000002,1462613.4000000001,276728.39999999997,0,6989.75,16425,15198.6,30973.899999999998,346315.65000000008,1808929.05,1808929.05,6570]
[1,null,null,null,"SL Supported Living",null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$33,J4:J30)","v":4745},{"$f":"SUMIF($E$4:$E$30,$E$33,K4:K30)","v":13},null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$33,P4:P30)","v":2809.9599999999996},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$33,W4:W30)","v":644.29},3454.2499999999995,995566.70000000019,10161.599999999999,19907.099999999999,1025635.4,173053.79999999996,0,4989.55,11862.5,15198.6,30061.399999999998,235165.85000000003,1260801.25,1260801.25,4745]
[2,null,null,null,"GH Group Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$34,J4:J31)","v":730},{"$f":"SUMIF($E$4:$E$30,$E$34,K4:K31)","v":2},null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$34,P4:P31)","v":375.22},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$34,W4:W31)","v":118.19},493.40999999999997,134455.04999999999,0,2500.25,136955.29999999999,40686.550000000003,0,627.80000000000007,1825,0,0,43139.350000000006,180094.65000000002,180094.65000000002,730]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$35,J4:J30)","v":1095},{"$f":"SUMIF($E$4:$E$30,$E$35,K4:K30)","v":3},null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$35,P4:P30)","v":821.98},null,null,null,null,null,null,{"$f":"SUMIF($E$4:$E$30,$E$35,W4:W30)","v":186.32999999999998},1008.31,294547.69999999995,0,5475,300022.7,62988.05,0,1372.4,2737.5,0,912.5,68010.45,368033.15,368033.15,1095]
["DSHS/DDA Schedule H Rate History (Rev. 08/2024)"]

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