{"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":168,"n_cols":48,"rows_kept":168,"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",null,null,null,null,null,null,null,null,"Provider ID",null,{"$f":"VLOOKUP(B1,List!A2:C131,2,FALSE)","v":{"$error":"#N/A"}},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:AK165),\"\")","v":""},{"$f":"IF(AL3=$AE$1,SUM(AL4:AL165),\"\")","v":""},null,null,null,null,"Professional Services",null,null,null,null,null,null,null,{"$f":"SUM(AV4:AV165)","v":0},"Professional Svs Hrs Calculation"]
["Report Period","2018-01-01",null,"2018-12-31",null,null,null,null,null,{"$f":"SUM(J4:J165)","v":0},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":0},null,null,null,null,"Totals",{"$f":"SUM(AF4:AF165)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["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"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F4>0,+IF(I4>0,I4,H4)-IF(G4>0,G4,F4)+1,0)","v":0},null,null,{"$f":"+K4*L4","v":0},null,null,null,null,0,0,0,0,{"$f":"+N4*O4+P4*Q4","v":0},null,{"$f":"ROUND(M4+V4+W4,2)","v":0},null,null,null,null,null,{"$f":"SUM(Y4:AC4)","v":0},{"$f":"+X4+AD4","v":0},{"$f":"IF(D4=\"SSP\",0,+J4*(K4+N4+P4))","v":0},{"$f":"K4*J4","v":0},{"$f":"IF($D4=\"SSP\",0,$J4*X4)","v":0},{"$f":"IF(D4=\"GH\",AG4,\"\")","v":""},{"$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":0},{"$f":"J4*AA4","v":0},{"$f":"$J4*AB4","v":0},{"$f":"$J4*AC4","v":0},{"$f":"IF($D4=\"SSP\",0,$J4*AD4)","v":0},{"$f":"AH4+AR4","v":0},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4717,$A4,AH$4:AH$4717))+IF(A5=A4,0,SUMIF($A$4:$A$4717,$A4,AR$4:AR$4717))","v":0},{"$f":"IF(A5=A4,0,SUMIF($A$4:$A$4717,$A4,J$4:J$4717))+IF(A5=A4,0,SUMIF($A$4:$A$4717,$A4))","v":0},{"$f":"IF($O4=$AT$1,$N4*$J4,0)+IF($Q4=$AT$1,$P4*$J4,0)","v":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,{"$f":"IF(F6>0,+IF(I6>0,I6,H6)-IF(G6>0,G6,F6)+1,0)","v":0},null,null,{"$f":"+K6*L6","v":0},null,null,null,null,0,0,0,0,{"$f":"+N6*O6+P6*Q6","v":0},null,{"$f":"ROUND(M6+V6+W6,2)","v":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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"SUM(Y68:AC68)","v":0},{"$f":"+X68+AD68","v":0},{"$f":"IF(D68=\"SSP\",0,+J68*(K68+N68+P68))","v":0},{"$f":"K68*J68","v":0},{"$f":"IF($D68=\"SSP\",0,$J68*X68)","v":0},{"$f":"IF(D68=\"GH\",AG68,\"\")","v":""},{"$f":"IF(D68=\"SL\",AG68,\"\")","v":""},{"$f":"IF(L68=$AF$1,AI68,\"\")","v":""},{"$f":"IF(L68=$AF$1,AJ68,\"\")","v":""},{"$f":"$J68*Y68","v":0},{"$f":"IF($D68=\"SSP\",0,$J68*Z68)","v":0},{"$f":"J68*AA68","v":0},{"$f":"$J68*AB68","v":0},{"$f":"$J68*AC68","v":0},{"$f":"IF($D68=\"SSP\",0,$J68*AD68)","v":0},{"$f":"AH68+AR68","v":0},{"$f":"IF(A69=A68,0,SUMIF($A$4:$A$4717,$A68,AH$4:AH$4717))+IF(A69=A68,0,SUMIF($A$4:$A$4717,$A68,AR$4:AR$4717))","v":0},{"$f":"IF(A69=A68,0,SUMIF($A$4:$A$4717,$A68,J$4:J$4717))+IF(A69=A68,0,SUMIF($A$4:$A$4717,$A68))","v":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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"IF(F106>0,+IF(I106>0,I106,H106)-IF(G106>0,G106,F106)+1,0)","v":0},null,null,{"$f":"+K106*L106","v":0},null,null,null,null,0,0,0,0,{"$f":"+N106*O106+P106*Q106","v":0},null,{"$f":"ROUND(M106+V106+W106,2)","v":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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,0,0,0,0,0,null,0,null,null,null,null,null,{"$f":"SUM(Y132:AC132)","v":0},{"$f":"+X132+AD132","v":0},{"$f":"IF(D132=\"SSP\",0,+J132*(K132+N132+P132))","v":0},{"$f":"K132*J132","v":0},{"$f":"IF($D132=\"SSP\",0,$J132*X132)","v":0},{"$f":"IF(D132=\"GH\",AG132,\"\")","v":""},{"$f":"IF(D132=\"SL\",AG132,\"\")","v":""},{"$f":"IF(L132=$AF$1,AI132,\"\")","v":""},{"$f":"IF(L132=$AF$1,AJ132,\"\")","v":""},{"$f":"$J132*Y132","v":0},{"$f":"IF($D132=\"SSP\",0,$J132*Z132)","v":0},{"$f":"J132*AA132","v":0},{"$f":"$J132*AB132","v":0},{"$f":"$J132*AC132","v":0},{"$f":"IF($D132=\"SSP\",0,$J132*AD132)","v":0},{"$f":"AH132+AR132","v":0},{"$f":"IF(A133=A132,0,SUMIF($A$4:$A$4717,$A132,AH$4:AH$4717))+IF(A133=A132,0,SUMIF($A$4:$A$4717,$A132,AR$4:AR$4717))","v":0},{"$f":"IF(A133=A132,0,SUMIF($A$4:$A$4717,$A132,J$4:J$4717))+IF(A133=A132,0,SUMIF($A$4:$A$4717,$A132))","v":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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,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,{"$f":"IF(F164>0,+IF(I164>0,I164,H164)-IF(G164>0,G164,F164)+1,0)","v":0},null,null,{"$f":"+K164*L164","v":0},null,null,null,null,null,null,null,null,{"$f":"+N164*O164+P164*Q164","v":0},null,{"$f":"ROUND(M164+V164+W164,2)","v":0},null,null,null,null,null,{"$f":"SUM(Y164:AC164)","v":0},{"$f":"+X164+AD164","v":0},{"$f":"IF(D164=\"SSP\",0,+J164*(K164+N164+P164))","v":0},{"$f":"K164*J164","v":0},{"$f":"IF($D164=\"SSP\",0,$J164*X164)","v":0},{"$f":"IF(D164=\"GH\",AG164,\"\")","v":""},{"$f":"IF(D164=\"SL\",AG164,\"\")","v":""},{"$f":"IF(L164=$AF$1,AI164,\"\")","v":""},{"$f":"IF(L164=$AF$1,AJ164,\"\")","v":""},{"$f":"$J164*Y164","v":0},{"$f":"IF($D164=\"SSP\",0,$J164*Z164)","v":0},{"$f":"J164*AA164","v":0},{"$f":"$J164*AB164","v":0},{"$f":"$J164*AC164","v":0},{"$f":"IF($D164=\"SSP\",0,$J164*AD164)","v":0},{"$f":"AH164+AR164","v":0},{"$f":"IF(A165=A164,0,SUMIF($A$4:$A$4717,$A164,AH$4:AH$4717))+IF(A165=A164,0,SUMIF($A$4:$A$4717,$A164,AR$4:AR$4717))","v":0},{"$f":"IF(A165=A164,0,SUMIF($A$4:$A$4717,$A164,J$4:J$4717))+IF(A165=A164,0,SUMIF($A$4:$A$4717,$A164))","v":0},{"$f":"IF($O164=$AT$1,$N164*$J164,0)+IF($Q164=$AT$1,$P164*$J164,0)","v":0}]
[]
["Totals - Detail",null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,J4:J165)","v":0},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:AF165)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["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*F168","v":0},null,null,null,null,{"$f":"0.43*K168","v":0},null,null,{"$f":"+X168+Y168+AB168+Z168+AA168","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"J168*AA168","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$415,I1,'Schedule J Detail by Client'!$AT$4:$AT$415)","v":0},{"$f":"SUMIF('Schedule J Detail by Client'!$C$4:$C$415,I1,'Schedule J Detail by Client'!$AU$4:$AU$164)","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":138,"n_cols":3,"rows_kept":138,"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 - 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]