{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Schedule J Detail by Client","Formulas for P1 Payment Rpt","Other Codes","Response List","List"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":7,"defined_names":125,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Schedule J Detail by Client","index":0,"n_rows":60,"n_cols":48,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,1,0,4],[1,1,1,2],[1,3,1,4],[0,25,0,29],[0,47,1,47],[0,38,0,44],[0,9,0,10],[0,11,0,13],[0,14,0,24]]}
["Program Name","3S - ABC Residential Services",null,null,null,null,null,null,null,"Provider ID",null,{"$f":"VLOOKUP(B1,List!A2:C132,2,FALSE)","v":"555777999/444666888"},null,null,"FOR PROVIDER USE ONLY                                                                                                                                                                                                                                                                                                                                                   DO NOT SUBMIT WITH COST REPORT",null,null,null,null,null,null,null,null,null,null,"ISS Hours",null,null,null,null,null,null,{"$f":"IF(AK3=$AE$1,SUM(AK4:AK57),\"\")","v":""},{"$f":"IF(AL3=$AE$1,SUM(AL4:AL57),\"\")","v":""},null,null,null,null,"Professional Services",null,null,null,null,null,null,null,{"$f":"SUM(AV4:AV57)","v":0},"Professional Svs Hrs Calculation"]
["Report Period","2018-01-01",null,"2018-12-31",null,null,null,null,null,{"$f":"SUM(J4:J57)","v":11302},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average",{"$f":"IF(AN2=0,0,IF(J2=0,0,ROUND(+AN2/$J2,2)))","v":41.24},null,null,null,null,"Totals",{"$f":"SUM(AF4:AF57)","v":131594.89600000001},131241.421,2130065.5299999998,43870.220999999998,87371.200000000012,0,0,0,466068.16000000003,23546.61,0,56462.139999999985,546076.91000000027,2676142.439999999,2676142.44,11302]
["Client Name (c) ","House or Cluster","Client P1 ID (d)","Srvc Type (SL, GH, SSP)","P1 Srvc Code/RAC (v)","Rate Start Date (e)","Actual Start Date","Rate End Date","Actual End Date","Resid Days Paid","ISS Hrs PCD (f)","Benchmark Rate (g)","ISS Daily Rate","Prof Svs Hrs PCD 1 (i)","Prof Svs Hrly Rate 1 (j)","Prof Svs Hrs PCD 2 (k)","Prof Svs Hrly Rate 2 (l)","Prof Svs Hrs PCD 3","Prof Svs Hrly Rate 3","Prof Svs Hrs PCD 4","Prof Svs Hrly Rate 4","Prof Svs Daily Rate ","1163 Training Rate PCD July 1,2018 - Dec 31, 2019","Total ISS Daily Rate","Enhanced Rate PCD (o)","Admin Rate PCD (q)","Transportion Rate PCD (r)","Other Non-ISS Rate PCD (s) Jan 1, 2018 - Dec 31, 2019","1163 Training Rate PCD (p) Jan 1, 2018 - Jun 30, 2019","Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Hours Pd w/ Professional Svs","Annual ISS Hrs Pd w/o Professional Svs","Annual ISS Paid","GH","SL","GH","SL","Annual Enhanced Rate Paid","Annual Admin Paid","Annual Transportation Paid","Annual Other Non-ISS Paid","Annual 1163 Training Paid","Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Total ISS & Non-ISS Paid per Client","Total Days Paid per Client","Prof Svs Hrs Calculation"]
["Client A","House 1",500,"GH",null,"2018-01-01",null,"2018-12-31",null,{"$f":"IF(F4>0,+IF(I4>0,I4,H4)-IF(G4>0,G4,F4)+1,0)","v":365},15,16.100000000000001,{"$f":"+K4*L4","v":241.50000000000003},null,null,null,null,0,0,0,0,{"$f":"+N4*O4+P4*Q4","v":0},null,{"$f":"ROUND(M4+V4+W4,2)","v":241.5},0,56.8,0,0,6.45,{"$f":"SUM(Y4:AC4)","v":63.25},{"$f":"+X4+AD4","v":304.75},{"$f":"IF(D4=\"SSP\",0,+J4*(K4+N4+P4))","v":5475},{"$f":"K4*J4","v":5475},{"$f":"IF($D4=\"SSP\",0,$J4*X4)","v":88147.5},{"$f":"IF(D4=\"GH\",AG4,\"\")","v":5475},{"$f":"IF(D4=\"SL\",AG4,\"\")","v":""},{"$f":"IF(L4=$AF$1,AI4,\"\")","v":""},{"$f":"IF(L4=$AF$1,AJ4,\"\")","v":""},{"$f":"$J4*Y4","v":0},{"$f":"IF($D4=\"SSP\",0,$J4*Z4)","v":20732},{"$f":"J4*AA4","v":0},{"$f":"$J4*AB4","v":0},{"$f":"$J4*AC4","v":2354.25},{"$f":"IF($D4=\"SSP\",0,$J4*AD4)","v":23086.25},{"$f":"AH4+AR4","v":111233.75},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4609,$A4,AH$4:AH$4609))+IF(A5=A4,0,SUMIF($A$4:$A$4609,$A4,AR$4:AR$4609))","v":111233.75},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4609,$A4,J$4:J$4609))+IF(A5=A4,0,SUMIF($A$4:$A$4609,$A4))","v":365},{"$f":"IF($O4=$AT$1,$N4*$J4,0)+IF($Q4=$AT$1,$P4*$J4,0)","v":0}]
["Client B","House 1",501,"GH",null,"2018-01-01",null,"2018-06-30",null,181,10.5,16.100000000000001,169.05,null,null,null,null,0,0,0,0,0,null,169.05,0,55.8,0,0,4.5199999999999996,60.319999999999993,229.37,1900.5,1900.5,30598.050000000003,1900.5,"","","",0,10099.799999999999,0,0,818.11999999999989,10917.919999999998,41515.97,0,0,0]
["Client B","House 1",501,"GH",null,"2018-07-01",null,"2018-12-31",null,184,10.5,17.28,181.44,null,null,null,null,0,0,0,0,0,null,181.44,0,55.8,0,0,4.5199999999999996,60.319999999999993,241.76,1932,1932,33384.959999999999,1932,"","","",0,10267.199999999999,0,0,831.68,11098.88,44483.839999999997,85999.81,365,0]
["Client C","House 1",502,"GH",null,"2018-01-01",null,"2018-12-31",null,365,13,16.100000000000001,209.3,null,null,null,null,0,0,0,0,0,null,209.3,0,55.37,0,0,5.59,60.959999999999994,270.26,4745,4745,76394.5,4745,"","","",0,20210.05,0,0,2040.35,22250.399999999998,98644.9,98644.9,365,0]
["Client D","House 1",503,"GH",null,"2018-01-01",null,"2018-06-30",null,181,7.5,16.100000000000001,120.75000000000001,null,null,null,null,0,0,0,0,0,null,120.75,0,52.32,0,0,3.23,55.55,176.3,1357.5,1357.5,21855.75,1357.5,"","","",0,9469.92,0,0,584.63,10054.549999999999,31910.3,0,0,0]
["Client D","House 1",503,"GH",null,"2018-07-01",null,"2018-12-31",null,184,7.5,17.28,129.60000000000002,null,null,null,null,0,0,0,0,0,null,129.6,0,52.32,0,0,3.23,55.55,185.14999999999998,1380,1380,23846.399999999998,1380,"","","",0,9626.8799999999992,0,0,594.32000000000005,10221.199999999999,34067.599999999999,65977.899999999994,365,0]
["Client E","House 1",504,"GH",null,"2018-01-01",null,"2018-12-31",null,365,22,16.100000000000001,354.20000000000005,null,null,null,null,0,0,0,0,0,null,354.2,0,64.900000000000006,0,0,9.4600000000000009,74.360000000000014,428.56,8030,8030,129283,8030,"","","",0,23688.500000000004,0,0,3452.9,27141.400000000005,156424.4,156424.4,365,0]
["Client F","House 2",505,"GH",null,"2018-01-01",null,"2018-12-31",null,365,14.5,16.100000000000001,233.45000000000002,null,null,null,null,0,0,0,0,0,null,233.45,0,56.04,0,0,6.24,62.28,295.73,5292.5,5292.5,85209.25,5292.5,"","","",0,20454.599999999999,0,0,2277.6,22732.2,107941.45,107941.45,365,0]
["Client G","House 2",506,"GH",null,"2018-01-01",null,"2018-12-31",null,365,15.5,16.100000000000001,249.55,null,null,null,null,0,0,0,0,0,null,249.55,0,57.3,0,0,6.67,63.97,313.52,5657.5,5657.5,91085.75,5657.5,"","","",0,20914.5,0,0,2434.5500000000002,23349.05,114434.8,114434.8,365,0]
["Client H","House 2",507,"GH",null,"2018-01-01",null,"2018-08-31",null,243,18.5,16.100000000000001,297.85000000000002,null,null,null,null,0,0,0,0,0,null,297.85000000000002,0,59.6,0,0,7.96,67.56,365.41,4495.5,4495.5,72377.55,4495.5,"","","",0,14482.800000000001,0,0,1934.28,16417.080000000002,88794.63,0,0,0]
["Client H","House 2",507,"GH",null,"2018-09-01",null,"2018-12-31",null,122,25,16.100000000000001,402.50000000000006,null,null,null,null,0,0,0,0,0,null,402.5,0,60.02,0,0,10.75,70.77000000000001,473.27,3050,3050,49105,3050,"","","",0,7322.4400000000005,0,0,1311.5,8633.94,57738.94,146533.57,365,0]
["Client I","House 2",508,"GH",null,"2018-01-01",null,"2018-12-31","2018-01-21",21,10,16.100000000000001,161,null,null,null,null,0,0,0,0,0,null,161,0,54.4,0,0,4.3,58.699999999999996,219.7,210,210,3381,210,"","","",0,1142.3999999999999,0,0,90.3,1232.6999999999998,4613.7,4613.7,21,0]
["Client J","House 3",538,"GH",null,"2018-01-01",null,"2018-01-30",null,30,11.4907,17.28,198.55929600000002,null,null,null,null,0,0,0,0,0,null,198.56,0,0,0,0,6.67,6.67,205.23,344.721,344.721,5956.8,344.721,"","","",0,0,0,0,200.1,200.1,6156.9000000000005,6156.9000000000005,30,0]
["Client 01","Cluster 1",509,"SL",null,"2018-01-01",null,"2018-12-31",null,365,8.5,16.100000000000001,136.85000000000002,0.2,38.75,null,null,0,0,0,0,7.75,null,144.6,0,34.74,2.25,0,3.66,40.650000000000006,185.25,3175.4999999999995,3102.5,52779,"",3102.5,"","",0,12680.1,821.25,0,1335.9,14837.250000000002,67616.25,67616.25,365,0]
["Client 02","Cluster 1",510,"SL",null,"2018-01-01",null,"2018-12-31","2018-06-30",181,9.1999999999999993,16.100000000000001,148.12,null,null,null,null,0,0,0,0,0,null,148.12,0,34.979999999999997,2.25,0,3.96,41.19,189.31,1665.1999999999998,1665.1999999999998,26809.72,"",1665.1999999999998,"","",0,6331.3799999999992,407.25,0,716.76,7455.3899999999994,34265.11,0,0,0]
["Client 02","Cluster 1","510 (Client 8) COCA","SL",null,"2018-07-01",null,"2018-07-31",null,31,9.1999999999999993,16.100000000000001,148.12,null,null,null,null,0,0,0,0,0,null,148.12,0,34.979999999999997,2.25,0,3.96,41.19,189.31,285.2,285.2,4591.72,"",285.2,"","",0,1084.3799999999999,69.75,0,122.76,1276.8899999999999,5868.6100000000006,40133.72,212,0]
["Client 03","Cluster 1",511,"SL",null,"2018-08-01","2018-08-03","2018-12-31","2018-10-31",90,7.25,16.100000000000001,116.72500000000001,null,null,null,null,0,0,0,0,0,null,116.73,0,33.49,1.85,0,3.12,38.46,155.19,652.5,652.5,10505.7,"",652.5,"","",0,3014.1000000000004,166.5,0,280.8,3461.4,13967.1,0,0,0]
["Client 03","Cluster 1","511 (Client 12) COCA","SL",null,"2018-11-01",null,"2018-12-31",null,61,7.25,16.100000000000001,116.72500000000001,null,null,null,null,0,0,0,0,0,null,116.73,0,33.49,3.5,0,3.12,40.11,156.84,442.25,442.25,7120.5300000000007,"",442.25,"","",0,2042.89,213.5,0,190.32,2446.71,9567.2400000000016,23534.340000000004,151,0]
["Client 04","Cluster 2",512,"SL",null,"2018-01-01",null,"2018-12-31","2018-02-28",59,9.6,16.100000000000001,154.56,null,null,null,null,0,0,0,0,0,null,154.56,0,35.18,1.85,0,4.13,41.160000000000004,195.72,566.4,566.4,9119.0400000000009,"",566.4,"","",0,2075.62,109.15,0,243.67,2428.44,11547.480000000001,0,0,0]
["Client 04","Cluster 2",512,"SL",null,"2018-03-01",null,"2018-12-31",null,306,10.199999999999999,16.100000000000001,164.22,0.35,26.5,null,null,0,0,0,0,9.2749999999999986,null,173.5,0,35.51,4.58,0,4.3899999999999997,44.48,217.98,3228.2999999999997,3121.2,53091,"",3121.2,"","",0,10866.06,1401.48,0,1343.34,13610.88,66701.88,78249.36,365,0]
["Client 05","Cluster 2",513,"SL",null,"2018-01-01",null,"2018-12-31","2018-11-27",331,11.5,16.100000000000001,185.15,null,null,null,null,0,0,0,0,0,null,185.15,0,35.81,1.88,0,4.95,42.640000000000008,227.79000000000002,3806.5,3806.5,61284.65,"",3806.5,"","",0,11853.11,622.28,0,1638.45,14113.840000000002,75398.490000000005,75398.490000000005,331,0]
["Client 06","Cluster 2",514,"SL",null,"2018-05-18","2018-05-15","2018-12-31",null,231,9.75,16.100000000000001,156.97500000000002,null,null,null,null,0,0,0,0,0,null,156.97999999999999,0,35.18,2.35,0,4.1900000000000004,41.72,198.7,2252.25,2252.25,36262.379999999997,"",2252.25,"","",0,8126.58,542.85,0,967.8900000000001,9637.32,45899.7,45899.7,231,0]
["Client 07","Cluster 2",515,"SL",null,"2018-01-01",null,"2018-06-30",null,181,8.5,16.100000000000001,136.85000000000002,null,null,null,null,0,0,0,0,0,null,136.85,0,39.130000000000003,2.5,0,3.66,45.290000000000006,182.14,1538.5,1538.5,24769.85,"",1538.5,"","",0,7082.5300000000007,452.5,0,662.46,8197.4900000000016,32967.339999999997,0,0,0]
["Client 07","Cluster 2",515,"SL",null,"2018-07-01",null,"2018-12-31",null,184,8.5,16.100000000000001,136.85000000000002,null,null,null,null,0,0,0,0,0,null,136.85,0,39.130000000000003,2.5,0,3.66,45.290000000000006,182.14,1564,1564,25180.399999999998,"",1564,"","",0,7199.92,460,0,673.44,8333.36,33513.759999999995,66481.100000000006,365,0]
["Client 08","Cluster 2",516,"SL",null,"2018-01-01",null,"2018-06-30",null,181,6.25,16.100000000000001,100.62500000000001,null,null,null,null,0,0,0,0,0,null,100.63,0,36,2.5,0,2.69,41.19,141.82,1131.25,1131.25,18214.03,"",1131.25,"","",0,6516,452.5,0,486.89,7455.3899999999994,25669.42,0,0,0]
["Client 08","Cluster 2",516,"SL",null,"2018-07-01",null,"2018-12-31",null,184,6.5,16.68,108.42,null,null,null,null,0,0,0,0,0,null,108.42,0,36,2.5,0,2.69,41.19,149.61000000000001,1196,1196,19949.28,"",1196,"","",0,6624,460,0,494.96,7578.9599999999991,27528.239999999998,53197.659999999996,365,0]
["Client 09","Cluster 2",517,"SL",null,"2018-01-01",null,"2018-06-30",null,181,8.1999999999999993,16.100000000000001,132.02000000000001,null,null,null,null,0,0,0,0,0,null,132.02000000000001,0,36,3.25,0,3.53,42.78,174.8,1484.1999999999998,1484.1999999999998,23895.620000000003,"",1484.1999999999998,"","",0,6516,588.25,0,638.92999999999995,7743.18,31638.800000000003,0,0,0]
["Client 09","Cluster 2",517,"SL",null,"2018-07-01",null,"2018-12-31",null,184,8.5,16.68,141.78,null,null,null,null,0,0,0,0,0,null,141.78,0,36,3.25,0,3.53,42.78,184.56,1564,1564,26087.52,"",1564,"","",0,6624,598,0,649.52,7871.52,33959.040000000001,65597.84,365,0]
["Client 10","Cluster 3",518,"SL",null,"2018-01-01",null,"2018-12-31",null,365,13,16.100000000000001,209.3,2.5000000000000001E-2,26.5,null,null,0,0,0,0,0.66250000000000009,null,209.96,0,37.15,3.2,0,5.59,45.94,255.9,4754.125,4745,76635.400000000009,"",4745,"","",0,13559.75,1168,0,2040.35,16768.099999999999,93403.5,93403.5,365,0]
["Client 11","Cluster 3",519,"SL",null,"2018-08-01","2018-08-15","2018-12-31","2018-09-30",47,17.75,16.100000000000001,285.77500000000003,null,null,null,null,0,0,0,0,0,null,285.77999999999997,0,39.119999999999997,2.25,0,7.63,49,334.78,834.25,834.25,13431.659999999998,"",834.25,"","",0,1838.6399999999999,105.75,0,358.61,2303,15734.659999999998,0,0,0]
["Client 11","Cluster 3",519,"SL",null,"2018-10-01",null,"2018-12-31",null,92,12.75,16.100000000000001,205.27500000000001,null,null,null,null,0,0,0,0,0,null,205.28,0,36.159999999999997,2.25,0,5.48,43.89,249.17000000000002,1173,1173,18885.759999999998,"",1173,"","",0,3326.72,207,0,504.16,4037.88,22923.64,38658.299999999996,139,0]
["Client 12","Cluster 3",520,"SL",null,"2018-01-01",null,"2018-12-31",null,365,11.12,16.100000000000001,179.03200000000001,null,null,null,null,0,0,0,0,0,null,179.03,0,38,2.25,0,4.78,45.03,224.06,4058.7999999999997,4058.7999999999997,65345.95,"",4058.7999999999997,"","",0,13870,821.25,0,1744.7,16435.95,81781.899999999994,81781.899999999994,365,0]
["Client 13","Cluster 3",521,"SL",null,"2018-01-01",null,"2018-12-31",null,{"$f":"IF(F36>0,+IF(I36>0,I36,H36)-IF(G36>0,G36,F36)+1,0)","v":365},10.5,16.100000000000001,{"$f":"+K36*L36","v":169.05},null,null,null,null,0,0,0,0,{"$f":"+N36*O36+P36*Q36","v":0},null,{"$f":"ROUND(M36+V36+W36,2)","v":169.05},0,35.51,1.85,0,4.5199999999999996,{"$f":"SUM(Y36:AC36)","v":41.879999999999995},{"$f":"+X36+AD36","v":210.93},{"$f":"IF(D36=\"SSP\",0,+J36*(K36+N36+P36))","v":3832.5},{"$f":"K36*J36","v":3832.5},{"$f":"IF($D36=\"SSP\",0,$J36*X36)","v":61703.250000000007},{"$f":"IF(D36=\"GH\",AG36,\"\")","v":""},{"$f":"IF(D36=\"SL\",AG36,\"\")","v":3832.5},{"$f":"IF(L36=$AF$1,AI36,\"\")","v":""},{"$f":"IF(L36=$AF$1,AJ36,\"\")","v":""},{"$f":"$J36*Y36","v":0},{"$f":"IF($D36=\"SSP\",0,$J36*Z36)","v":12961.15},{"$f":"J36*AA36","v":675.25},{"$f":"$J36*AB36","v":0},{"$f":"$J36*AC36","v":1649.8},{"$f":"IF($D36=\"SSP\",0,$J36*AD36)","v":15286.199999999999},{"$f":"AH36+AR36","v":76989.450000000012},{"$f":"IF(A37=A36,0,SUMIF($A$4:$A$4609,$A36,AH$4:AH$4609))+IF(A37=A36,0,SUMIF($A$4:$A$4609,$A36,AR$4:AR$4609))","v":76989.450000000012},{"$f":"IF(A37=A36,0,SUMIF($A$4:$A$4609,$A36,J$4:J$4609))+IF(A37=A36,0,SUMIF($A$4:$A$4609,$A36))","v":365},{"$f":"IF($O36=$AT$1,$N36*$J36,0)+IF($Q36=$AT$1,$P36*$J36,0)","v":0}]
["Client 14","Cluster 3",522,"SL",null,"2018-07-01",null,"2018-12-31","2018-08-31",62,12.6,16.100000000000001,202.86,null,null,null,null,0,0,0,0,0,null,202.86,0,37.61,4.58,0,5.42,47.61,250.47000000000003,781.19999999999993,781.19999999999993,12577.320000000002,"",781.19999999999993,"","",0,2331.8200000000002,283.95999999999998,0,336.04,2951.82,15529.140000000001,0,0,0]
["Client 14","Cluster 3",522,"SL",null,"2018-09-01",null,"2018-12-31",null,122,16.25,16.100000000000001,261.625,null,null,null,null,0,0,0,0,0,null,261.63,0,37.61,4.25,0,6.99,48.85,310.48,1982.5,1982.5,31918.86,"",1982.5,"","",0,4588.42,518.5,0,852.78,5959.7,37878.559999999998,53407.7,184,0]
["Client 15","Cluster 3",523,"SL",null,"2018-02-01",null,"2018-12-31","2018-09-30",242,8.75,16.100000000000001,140.875,null,null,null,null,0,0,0,0,0,null,140.88,0,34.74,3.25,0,3.76,41.75,182.63,2117.5,2117.5,34092.959999999999,"",2117.5,"","",0,8407.08,786.5,0,909.92,10103.5,44196.46,0,0,0]
["Client 15","Cluster 3",523,"SL",null,"2018-10-01",null,"2018-12-31",null,92,8,16.100000000000001,128.80000000000001,null,null,null,null,0,0,0,0,0,null,128.80000000000001,0,34.74,1.88,0,3.44,40.06,168.86,736,736,11849.6,"",736,"","",0,3196.0800000000004,172.95999999999998,0,316.48,3685.5200000000004,15535.12,59731.58,334,0]
["Client 16","Cluster 3",524,"SL",null,"2018-01-01",null,"2018-12-31",null,365,11.25,16.100000000000001,181.12500000000003,0.2,38.75,0.25,26.5,0,0,0,0,14.375,null,195.5,0,35.99,2.5,0,4.84,43.33,238.82999999999998,4270.5,4106.25,71357.5,"",4106.25,"","",0,13136.35,912.5,0,1766.6,15815.449999999999,87172.95,87172.95,365,0]
["Client 17","Cluster 4",525,"SL",null,"2018-01-01",null,"2018-12-31",null,365,8.4499999999999993,16.100000000000001,136.04499999999999,null,null,null,null,0,0,0,0,0,null,136.05000000000001,0,34.4,2.5,0,3.63,40.53,176.58,3084.2499999999995,3084.2499999999995,49658.250000000007,"",3084.2499999999995,"","",0,12556,912.5,0,1324.95,14793.45,64451.700000000012,64451.700000000012,365,0]
["Client 18","Cluster 4",526,"SL",null,"2018-01-01",null,"2018-12-31",null,365,18.25,16.100000000000001,293.82500000000005,null,null,null,null,0,0,0,0,0,null,293.83,0,39.68,2.5,0,7.85,50.03,343.86,6661.25,6661.25,107247.95,"",6661.25,"","",0,14483.2,912.5,0,2865.25,18260.95,125508.9,125508.9,365,0]
["Client 19","Cluster 4",527,"SL",null,"2018-01-01",null,"2018-12-31",null,365,16.2,16.100000000000001,260.82,null,null,null,null,0,0,0,0,0,null,260.82,0,37.61,3.25,0,6.97,47.83,308.64999999999998,5913,5913,95199.3,"",5913,"","",0,13727.65,1186.25,0,2544.0499999999997,17457.95,112657.25,112657.25,365,0]
["Client 20","Cluster 4",528,"SL",null,"2018-01-01",null,"2018-12-31",null,365,12.8,16.100000000000001,206.08000000000004,null,null,null,null,0,0,0,0,0,null,206.08,0,42,3.47,0,5.5,50.97,257.05,4672,4672,75219.200000000012,"",4672,"","",0,15330,1266.5500000000002,0,2007.5,18604.05,93823.250000000015,93823.250000000015,365,0]
["Client 21","Cluster 4",529,"SL",null,"2018-01-01",null,"2018-12-31",null,365,14.75,16.100000000000001,237.47500000000002,null,null,null,null,0,0,0,0,0,null,237.48,0,36.880000000000003,1.88,0,6.34,45.100000000000009,282.58,5383.75,5383.75,86680.2,"",5383.75,"","",0,13461.2,686.19999999999993,0,2314.1,16461.500000000004,103141.7,103141.7,365,0]
["Client 22","Cluster 4",530,"SL",null,"2018-01-01",null,"2018-12-31",null,365,9.6,16.100000000000001,154.56,null,null,null,null,0,0,0,0,0,null,154.56,0,35.18,3.5,0,4.13,42.81,197.37,3504,3504,56414.400000000001,"",3504,"","",0,12840.7,1277.5,0,1507.45,15625.650000000001,72040.05,72040.05,365,0]
["Client 23","Cluster 4",531,"SL",null,"2018-01-01",null,"2018-12-31",null,365,12.2,16.100000000000001,196.42000000000002,null,null,null,null,0,0,0,0,0,null,196.42,0,37.5,3.5,0,5.25,46.25,242.67,4453,4453,71693.299999999988,"",4453,"","",0,13687.5,1277.5,0,1916.25,16881.25,88574.549999999988,88574.549999999988,365,0]
["Client 24","Cluster 4",532,"SL",null,"2018-01-01",null,"2018-12-31",null,365,6.24,16.100000000000001,100.46400000000001,null,null,null,null,0,0,0,0,0,null,100.46,0,35.99,3.5,0,2.68,42.17,142.63,2277.6,2277.6,36667.899999999994,"",2277.6,"","",0,13136.35,1277.5,0,978.2,15392.050000000001,52059.95,52059.95,365,0]
["Client 25","Cluster 4",533,"SL",null,"2018-06-05","2018-06-06","2018-12-31","2018-07-30",55,11.5,16.100000000000001,185.15,null,null,null,null,0,0,0,0,0,null,185.15,0,36.5,5.76,0,4.95,47.21,232.36,632.5,632.5,10183.25,"",632.5,"","",0,2007.5,316.8,0,272.25,2596.5500000000002,12779.8,12779.8,55,0]
["Client 26","Cluster 4",534,"SL",null,"2018-01-01",null,"2018-12-31",null,365,1.74,16.100000000000001,28.014000000000003,null,null,null,null,0,0,0,0,0,null,28.01,0,16.369999999999997,3.02,0,0.75,20.139999999999997,48.15,635.1,635.1,10223.650000000001,"",635.1,"","",0,5975.0499999999993,1102.3,0,273.75,7351.0999999999985,17574.75,17574.75,365,0]
["Client 27","Cluster 4",535,"SL",null,"2018-09-24",null,"2018-10-31","2018-09-27",4,25.75,16.100000000000001,414.57500000000005,null,null,null,null,0,0,0,0,0,null,414.58,0,47.61,5.0199999999999996,0,11.07,63.699999999999996,478.28,103,103,1658.32,"",103,"","",0,190.44,20.079999999999998,0,44.28,254.79999999999998,1913.12,1913.12,4,0]
["Client 28","Cluster 4",536,"SL",null,"2018-01-01",null,"2018-04-30",null,120,10.94,16.100000000000001,176.13400000000001,null,null,null,null,0,0,0,0,0,null,176.13,0,36.74,2.4500000000000002,0,4.7,43.890000000000008,220.02,1312.8,1312.8,21135.599999999999,"",1312.8,"","",0,4408.8,294,0,564,5266.8000000000011,26402.400000000001,26402.400000000001,120,0]
["Client 29","Smith Ave",537,"SSP",null,"2018-01-01",null,"2018-12-31","2017-12-31",0,8,16.100000000000001,128.80000000000001,null,null,null,null,0,0,0,0,0,null,128.80000000000001,0,34.06,6.23,0,3.44,43.730000000000004,172.53000000000003,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,null,null,null,0,0,0,0,0,null,0,null,null,null,null,null,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,null,null,null,null,null,null,null,0,null,0,null,null,null,null,null,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:J57)","v":11302},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,AF4:AF57)","v":131594.89600000001},131241.421,2130065.5299999998,43870.220999999998,87371.200000000012,0,0,0,466068.16000000003,23546.61,0,56462.139999999985,546076.91000000027,2676142.439999999,2676142.44,11302]
["DSHS/DDA Schedule J Detail By Client (Rev. 12/18)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0.43*F60","v":0},null,null,null,null,{"$f":"0.43*K60","v":0},null,null,{"$f":"+X60+Y60+AB60+Z60+AA60","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"J60*AA60","v":0}]

{"sheet":"Formulas for P1 Payment Rpt","index":1,"n_rows":10,"n_cols":34,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Schedule J Detail by Client Contracted Amount","Schedule J Detail by Client Contracted Days","Cost Variance","Days Variance","Sched J Rate","Sched J Days","Schedule J Total","Days Variance","Dollars Variance","Comments","Resource Manager Response","Resource Manager Comments","Action taken by Analyst"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUMIF('Schedule J Detail by Client'!$C$4:$C$307,I1,'Schedule J Detail by Client'!$AT$4:$AT$307)","v":0},{"$f":"SUMIF('Schedule J Detail by Client'!$C$4:$C$307,I1,'Schedule J Detail by Client'!$AU$4:$AU$56)","v":0},{"$f":"(M2+N2)-Q2","v":0},{"$f":"K2-R2","v":0},null,null,{"$f":"U2*V2","v":0},{"$f":"K2-V2","v":0},{"$f":"M2+N2-W2","v":0},null,null,null,null,"SA716 & SA722","Supported Living & Group Home",{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}},null,{"$f":"SUBTOTAL(9,#REF!)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,V2)","v":0},{"$f":"SUBTOTAL(9,W2)","v":0},0,0,null,null,null,null,"Provider1 Total",null,{"$f":"SUM(AF2:AF2)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AH2:AH2)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Subtotal",null,null,{"$f":"SUBTOTAL(9,X2:X3)","v":0},{"$f":"SUBTOTAL(9,Y2:Y3)","v":0},null,null,null,null,"Less overpayments",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Add underpayments",null,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Total",null,{"$f":"SUM(AF2:AF2,AF5,AF6)","v":{"$error":"#REF!"}},null,{"$f":"SUM(AH2:AH2,AH5,AH6)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sched J Check",null,{"$f":"#REF!","v":{"$error":"#REF!"}},null,{"$f":"#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Difference",null,{"$f":"AF7-AF9","v":{"$error":"#REF!"}},null,{"$f":"AH7-AH9","v":{"$error":"#REF!"}}]

{"sheet":"Other Codes","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Response List","index":3,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[]
["Underpayment to be claimed"]
["Underpayment will not be claimed, please adjust settlement"]
["Overpayment to be adjusted in P1"]
["Overpayment will not to be adjusted in P1 (explain why in column AE)"]
["COCA to be issued (Copy Attached)"]
["COCA issued previously (Copy Attached)"]

{"sheet":"List","index":4,"n_rows":139,"n_cols":3,"rows_kept":139,"cut":false,"hidden":true,"merged":[]}
["PROVIDER","P1 ID","SSPS ID"]
[]
["1N - Aacres WA",111414301,928190]
["1N - Aacres Spokane 2",111414310]
["1N - Aacres Spokane 3",111414309]
["1N - Adult Guidance & Empowerment Service",111684901,131592]
["1N - Ambitions - Wenatchee, Omak, Moses Lake",111901903,925218]
["1N - Ambitions - Spokane",111901906]
["1N - ARC of Spokane",111426502,322383]
["1N - Assisted Residential Services",111705601,343692]
["1N - Community Integrated Services",111425301,823672]
["1N - Community Visions",111530102,330801]
["1N - Dreamworks Residential",111913801,621527]
["1N - Drive Services",111621401,322188]
["1N - Excel Supported Living",111322002]
["1N - Grant County Developmental Disabilities",200012501,162436]
["1N - Kaler House",111686001,92824]
["1N - Latah Services",111762501,836399]
["1N - Living In Fulfilling Environment",111777301,58220]
["1N - LMK",111988202,621505]
["1N - Mission Vista",111707401,306053]
["1N - Parent's Cooperative Society for the Handicapped (Merry Glen)",111328901,158076]
["1N - Skils'kin",111632701,695912]
["1S - Alternative Residential Services",111625401,450461]
["1S - Ambitions - Kennewick",111901901,925274]
["1S - Ambitions - Yakima",111901907]
["1S - Community Living",111962202,120191]
["1S - Deaf Access Washington",111321901,91176]
["1S - Elmview",111604101,340022]
["1S - Habilitat",111449601,531937]
["1S - Kittitas Interactive Management",111688701,45134]
["1S - Reach Supported Living",209862801]
["1S - Tri-Cities Residential Services",111872501,83918]
["1S - Valley Residential Services",111777901,66754]
["2N - Aacres",111414307]
["2N - Access Living",111675101,881577]
["2N - All Heart Agency",111961601,53910]
["2N - Alpha Supported Living Services",111320902]
["2N - Ambitions Whatcom",111901908]
["2N - Camelot Society",101955202]
["2N - Cascade Connections",111724102,"588510/780404"]
["2N - Evergreen Supported Living",111690301,197341]
["2N - Holly Community Services",111765001,956087]
["2N - La Casa de Esperanza ",111390801,662956]
["2N - Puffin Island",111959501,119992]
["2N - Quilceda Community Services",111321203,877]
["2N - Rehabco",111681901,57208]
["2N - Rescare",111968512]
["2N - Sails",111805705]
["2N - Service Alternatives for WA",111513304,301532]
["2N - Snohomish Supportive Living Services",111518901,339336]
["2N - Soundview Association",111830201,"660205/973647"]
["2N - Steps Toward Independence",112034301,877402]
["2N - Sunrise Services",203434610,177937]
["2N - Village Community Services",111938301,588565]
["2N - Volunteers of America",200494106,126007]
["2S - Aacres",111414302,928233]
["2S - Alpha Supported Living Services",111320901,"040175/827344"]
["2S - Ambitions",111901902,925035]
["2S - Arc of King County",112013701,825497]
["2S - Banchero Friends Services",111415001,72441]
["2S - Bethesda Lutheran Communities",111621301,"432532/433659"]
["2S - Camelot Society",101955201,303794]
["2S - Cascade Community Services",111875001,151578]
["2S - Citizen Access Residential Resources",111533401,677982]
["2S - Community Integrated Services",111425302,248092]
["2S - Community Living",111962201,205884]
["2S - Destiny House Operations",111992801,628058]
["2S - Friendship House",111405501,44564]
["2S - Greenwood Home",111913301,610002]
["2S - Habilitation Services",208173701]
["2S - Helping Hands for the Disabled",111736002,"626261/903550"]
["2S - Inglewood Residential and Community Services",111568401,433445]
["2S - Integrated Living Services",111789002,"180625/681956"]
["2S - L'Arche Noah Sealth of Seattle",111798601,609889]
["2S - Life Skills Center",111499601,68536]
["2S - Maksu",111577901,825577]
["2S - Nellie Goodhue Group Homes",111800501,610011]
["2S - Parkview Services",111456901,602928]
["2S - Premier Care Services",111437001,429624]
["2S - Provail",101144803,340322]
["2S - Puget Sound Regional Services",111925301,825613]
["2S - Res-Care Washington",111968506,489354]
["2S - Sails",111805704]
["2S - Service Alternatives for WA",111513302,544863]
["2S - Shamrock Living Services",111958301,78744]
["2S - Shared Journeys",111515201,167481]
["2S - Stand Together",111753401,528919]
["2S - Tahoma Hills",111799101,351507]
["2S - Total Living Concept",111571101,"442688/825635"]
["2S - United Friends Group Home",101601101,601336]
["2S - Volunteers of America",200494104,677104]
["3N - Aacres WA",111414304,928259]
["3N - Ambitions, WA",111901904,925079]
["3N - Communitas Group",102702801,"539414/789676"]
["3N - Community Alternatives for People with Autism (CAPA)",112026801,868252]
["3N - Educational Programs in Home Living",111975401,219207]
["3N - Group Action for Peninsula People",111703801,196657]
["3N - Hope Human Services",207150601]
["3N - Kitsap Residences",111781001,116024]
["3N - Kitsap Tenant Support Services",111715902,586518]
["3N - L'Arche Tahoma Hope Community",111610303,236004]
["3N - Life Force Services",111691201,342850]
["3N - NW Services for Independent Living",111812601,587155]
["3N - Options Unlimited",111904801,625360]
["3N - PAM Group Home",111728401,587202]
["3N - Puget Sound Assisted Living",111557601,686863]
["3N - Res-Care Washington",111968504,378828]
["3N - Self Determined Services ",111874501,153159]
["3N - Service Alternatives for WA",111513305,358400]
["3N - Self Reliant Endeavors",204861001]
["3N - Tahoma Associates",111335302,297927]
["3N - Valley Supported Living",111938101,965589]
["3S - ABC Residential Services","555777999/444666888","111111/333333"]
["3S - Aacres - Thurston",111414308,929653]
["3S - Aacres - Clark",111414303,929653]
["3S - Ambitions",111901905,925079]
["3S - Another Option",111619102,415519]
["3S - Arc of Clark County",102623403,451257]
["3S - Brighton Enterprises - Clark",111686601,59722]
["3S - Brighton Enterprises - Thurston",111686602]
["3S - Caregivers of Washington",203690902,283667]
["3S - CCH Individual Support Services",111909801,"597522/987094"]
["3S - Citizen Access Residential Resources","111533403/111533401",742522]
["3S - Community Resources",111977701,550757]
["3S - Exceptional Foresters",111551801,593835]
["3S - Harbor Alternative Living Association",111349601,593904]
["3S - Hope Human Services",207150603]
["3S - Kitsap Tenant Support Services",111715901,493668]
["3S - Kokua",111492901,708859]
["3S - Life Force Services - Thurston",111691202,261724]
["3S - Life Force Services - Clark",111691204]
["3S - Life Works",111594402,"098329/597533"]
["3S - Placeone",111512001,152951]
["3S - ROAR",111442501,612114]
["3S - Reside Residential Care of Washington",111864101,137760]
["3S - SOLO",111910501,642421]
["3S - Twin Harbors Group Home Association",111669901,663515]
["3S - Vancare",111811201,564924]