{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Instructions","Lists","Administrator Regression Table","RES","ReadMe","A - General Info & Cert","B - ISS Payroll Expenses","C - Non-ISS Expenses","D - Revenue","E - Residential Staffing","E - Residential Staffing Add'l","F - Healthcare Expenses","G - ISS Settlement"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":12,"defined_names":9412,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Workbook must be manipulated to accommodate DDA changes"]
[]
["Unhide all tabs"]
["Unprotect all tabs"]
["Headings will need to be selected to make changes"]
[]
["Lists Tab"]
["Revise any list for drop down menus used throughout the cost report. This may affect formulas throughout the report. "]
[]
["Adminstrator Regression Table"]

{"sheet":"Lists","index":1,"n_rows":145,"n_cols":19,"rows_kept":145,"cut":false,"hidden":true,"merged":[[0,15,0,18]]}
["Provider Name","Provider ID","Urban Designation",null,"Program Type","Service Code & RAC","Professional Services","Purchased Professional Services","COCA Service Code & RAC","Staff Add-On Service Code & RAC",null,"Monthly / Quarterly",null,"Region",null,"Schedule B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,"2a","2b","2c"]
["1N - Aacres WA",111414301,"MSA",null,"SL Supported Living","SL Supported Living","SL Behav Hab","SL Authorized ISS Purchased Professional Services","GH SA720-3603 COCA CORE","SA725-3701 GH STAFF ADD-ON FEDERAL RCL",null,"Monthly",null,"1N"]
["1N - Aacres Spokane 2",111414310,"MSA",null,"GH Group Home","GH Group Home","SL Hab DBT","GH Authorized ISS Purchased Professional Services","GH SA720-3701 COCA RCL","SA725-3905 GH STAFF ADD-ON FEDERAL State",null,"Quarterly",null,"1S",null,"Yes","Yes","Yes","Program Revenues"]
["1N - Aacres Spokane 3",111414309,"MSA",null,"GTH Group Training Home","GTH Group Training Home","SL Language Translator","GTH Authorized ISS Purchased Professional Services","GH SA726-3603 COCA CORE","SA719-3603 GH STAFF ADD-ON STATE CORE",null,null,null,"2N",null,"No","No","No","ISS/Direct Care Cost"]
["1N - Adult Guidance & Empowerment Service",111684901,"MSA",null,null,"SA716-3603 SL CORE","SL LPN M&C",null,"GH SA726-3701 COCA RCL","SA719-3701 GH STAFF ADD-ON STATE RCL",null,null,null,"2S",null,null,null,null,"Other Method - Please describe"]
["1N - Alpha Supported Living (Spokane)",111320906,"MSA",null,null,"SA716-3604 SL CP","SL RN M&C",null,"GH SA726-3905 COCA State","SA719-3905 GH STAFF ADD-ON STATE State",null,null,null,"3N"]
["1N - Ambitions - Spokane",111901906,"MSA",null,null,"SA716-3701 SL RCL","SL Sign Language Interp",null,"SL SA720-3603 COCA CORE","SA719-3603 SL STAFF ADD-ON STATE CORE",null,null,null,"3S"]
["1N - Ambitions - Wenatchee, Omak, Moses Lake",111901903,"MSA/NON-MSA",null,null,"SA716-3905 SL State","SL Other",null,"SL SA720-3604 COCA CP","SA719-3604 SL STAFF ADD-ON STATE CP"]
["1N - ARC of Spokane",111426502,"MSA",null,null,"SA722-3603 GH CORE","GH Behav Hab",null,"SL SA720-3701 COCA RCL","SA719-3701 SL STAFF ADD-ON STATE RCL"]
["1N - Assisted Residential Services",111705601,"MSA",null,null,"SA722-3701 GH RCL","GH Hab DBT",null,"SL SA726-3603 COCA CORE","SA719-3905 SL STAFF ADD-ON STATE State"]
["1N - Community Integrated Services",111425301,"MSA",null,null,"SA722-3905 GH State","GH Language Translator",null,"SL SA726-3604 COCA CP","SA725-3603 SL STAFF ADD-ON FEDERAL CORE"]
["1N - Community Visions",111530102,"MSA",null,null,"SA722-3603 GTH CORE","GH LPN M&C",null,"SL SA726-3701 COCA RCL","SA725-3604 SL STAFF ADD-ON FEDERAL CP"]
["1N - Dreamworks Residential",111913801,"NON-MSA",null,null,"SA722-3701 GTH RCL","GH RN M&C",null,"SA726-3905 SL COCA State","SA725-3701 SL STAFF ADD-ON FEDERAL RCL"]
["1N - Drive Services",111621401,"MSA",null,null,"SA722-3905 GTH State","GH Sign Language Interp",null,null,"SA725-3905 SL STAFF ADD-ON FEDERAL State"]
["1N - Excel Supported Living",111322002,"MSA",null,null,null,"GH Other"]
["1N - Grace Support Services",212120601,"MSA",null,null,null,"GTH Behav Hab"]
["1N - Grant County Developmental Disabilities (DCL)",200012501,"NON-MSA",null,null,null,"GTH Hab DBT"]
["1N - Hope Human Services (Spokane)",207150604,"MSA",null,null,null,"GTH Language Translator"]
["1N - Hope Supported Living",213504001,"MSA",null,null,null,"GTH LPN M&C"]
["1N - Kaler House",111686001,"MSA",null,null,null,"GTH RN M&C"]
["1N - L.M.K.",111988202,"NON-MSA",null,null,null,"GTH Sign Language Interp"]
["1N - Latah Services",111762501,"MSA",null,null,null,"GTH Other"]
["1N - Living In Fulfilling Environment",111777301,"MSA"]
["1N - Mission Vista",111707401,"MSA"]
["1N - Parent's Cooperative Society for the Handicapped (Merry Glen)",111328901,"MSA"]
["1N - ResCare Spokane",111968514,"MSA"]
["1S - Alternative Residential Services",111625401,"MSA/NON-MSA"]
["1S - Ambitions - Kennewick",111901901,"MSA"]
["1S - Ambitions - Yakima",111901907,"MSA"]
["1S - Community Living",111962202,"MSA"]
["1S - Deaf Access Washington",111321901,"MSA"]
["1S - Elmview",111604101,"MSA/NON-MSA"]
["1S - Habilitat",111449601,"NON-MSA"]
["1S - Kittitas Interactive Management",111688701,"NON-MSA"]
["1S - Kittitas Interactive Management (Yakima)",111688702,"MSA"]
["1S - Reach Supported Living",209862801,"MSA"]
["1S - Reach Supported Living Walla Walla",209862802,"MSA"]
["1S - Tri-Cities Residential Services",111872501,"MSA"]
["1S - Valley Residential Services",111777901,"NON-MSA"]
["2N - Aacres",111414307,"MSA"]
["2N - Access Living",111675101,"MSA"]
["2N - All Heart Agency",111961601,"MSA"]
["2N - Alpha Supported Living Services",111320902,"MSA"]
["2N - Ambitions Whatcom",111901908,"MSA"]
["2N - Camelot Society",101955202,"MSA"]
["2N - Cascade Connections",111724102,"MSA"]
["2N - Evergreen Supported Living",111690301,"MSA"]
["2N - Holly Community Services",111765001,"MSA"]
["2N - La Casa de Esperanza ",111390801,"MSA"]
["2N - Puffin Island",111959501,"MSA"]
["2N - Quilceda Community Services",111321203,"MSA"]
["2N - Rehabco",111681901,"MSA"]
["2N - Rescare",111968512,"MSA"]
["2N - Sails",111805705,"MSA"]
["2N - Service Alternatives for WA",111513304,"MSA"]
["2N - Snohomish Supportive Living Services",111518901,"MSA"]
["2N - Soundview Association",111830201,"MSA"]
["2N - Steps Toward Independence",112034301,"MSA"]
["2N - Sunrise Services",203434610,"MSA"]
["2N - Village Community Services",111938301,"MSA"]
["2N - Volunteers of America",200494106,"MSA"]
["2S - Aacres",111414302,"KING"]
["2S - Alpha Supported Living Services",111320901,"KING"]
["2S - Ambitions",111901902,"KING"]
["2S - Arc of King County",112013701,"KING"]
["2S - Banchero Friends Services",111415001,"KING"]
["2S - Bethesda Lutheran Communities",111621301,"KING"]
["2S - Camelot Society",101955201,"KING"]
["2S - Cascade Community Services",111875001,"KING"]
["2S - Citizen Access Residential Resources",111533401,"KING"]
["2S - Community Integrated Services",111425302,"KING"]
["2S - Community Living",111962201,"KING"]
["2S - Destiny House Operations",111992801,"KING"]
["2S - Friendship House",111405501,"KING"]
["2S - Greenwood Home",111913301,"KING"]
["2S - Habilitation Services",208173701,"KING"]
["2S - Helping Hands for the Disabled",111736002,"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 - Nellie Goodhue Group Homes",111800501,"KING"]
["2S - Parkview Services",111456901,"KING"]
["2S - Premier Care Services",111437001,"KING"]
["2S - Provail",101144803,"KING"]
["2S - Puget Sound Regional Services",111925301,"KING"]
["2S - Res-Care Washington",111968506,"KING"]
["2S - SAILS",111805704,"KING"]
["2S - Service Alternatives for WA",111513302,"KING"]
["2S - Shamrock Living Services",111958301,"KING"]
["2S - Shared Journeys",111515201,"KING"]
["2S - Stand Together",111753401,"KING"]
["2S - Tahoma Hills",111799101,"KING"]
["2S - Total Living Concept",111571101,"KING"]
["2S - United Friends Group Home",101601101,"KING"]
["2S - Volunteers of America",200494104,"KING"]
["3N - Aacres WA",111414304,"MSA"]
["3N - Ambitions, WA",111901904,"MSA"]
["3N - Communitas Group",102702801,"MSA"]
["3N - Community Alternatives for People with Autism (CAPA)",112026801,"MSA"]
["3N - Educational Programs in Home Living",111975401,"MSA"]
["3N - Group Action for Peninsula People",111703801,"MSA"]
["3N - Hope Human Services",207150601,"MSA"]
["3N - Kitsap Residences",111781001,"MSA"]
["3N - Kitsap Tenant Support Services",111715902,"MSA"]
["3N - L'Arche Tahoma Hope Community",111610303,"MSA"]
["3N - Life Force Services",111691201,"MSA"]
["3N - NW Services for Independent Living",111812601,"MSA"]
["3N - Options Unlimited",111904801,"MSA"]
["3N - PAM Group Home",111728401,"MSA"]
["3N - Puget Sound Assisted Living",111557601,"MSA"]
["3N - Res-Care Washington",111968504,"MSA"]
["3N - Self Determined Services ",111874501,"MSA"]
["3N - Service Alternatives for WA",111513305,"MSA"]
["3N - Tahoma Associates",111335302,"MSA"]
["3N - Valley Supported Living",111938101,"MSA"]
["3S - Aacres - Clark",111414303,"NON-MSA"]
["3S - Aacres - Thurston",111414308,"MSA"]
["3S - ABC Residential Services",555777999,"MSA"]
["3S - Adam's Place",214039510,"MSA"]
["3S - Ambitions",111901905,"MSA/NON-MSA"]
["3S - Another Option",111619102,"MSA"]
["3S - Arc of Clark County",102623403,"MSA"]
["3S - Brighton Enterprises - Clark",111686601,"MSA"]
["3S - Brighton Enterprises - Thurston",111686602,"MSA"]
["3S - CCH Individual Support Services",111909801,"NON-MSA"]
["3S - Citizen Access Residential Resources",111533403,"MSA"]
["3S - Community Resources",111977701,"MSA/NON-MSA"]
["3S - Exceptional Foresters",111551801,"MSA"]
["3S - Harbor Alternative Living Association",111349601,"NON-MSA"]
["3S - Hope Human Services",207150603,"MSA"]
["3S - Kitsap Tenant Support Services",111715901,"NON-MSA"]
["3S - Kokua",111492901,"MSA"]
["3S - Life Force Services - Clark",111691204,"MSA"]
["3S - Life Force Services - Thurston",111691202,"MSA"]
["3S - Life Works",111594402,"MSA"]
["3S - Placeone",111512001,"MSA"]
["3S - Reside Residential Care of Washington",111864101,"MSA"]
["3S - ROAR",111442501,"MSA"]
["3S - SOLO",111910501,"MSA"]
["3S - Twin Harbors Group Home Association",111669901,"NON-MSA"]
["3S - Vancare",111811201,"MSA"]

{"sheet":"Administrator Regression Table","index":2,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
["NUMBER OF ISS FTE's","KING","MSA","MSA/\nNON-MSA","NON-MSA",null,null,"KING","MSA","MSA/\nNON-MSA","NON-MSA",null,"URBAN DESIGNATION & REPORTING PERIOD","FTE MTH/QRT WAGES FY2019",null,{"$f":"CONCATENATE(Q1,'B - ISS Payroll Expenses'!B10)","v":"MSAMonthly"},{"$f":"VLOOKUP(_M000001,Lists!A1:C145,3)","v":"MSA"},"KING","MSA","MSA/\nNON-MSA","NON-MSA"]
[1,{"$f":"2080*H4","v":81244.800000000003},{"$f":"2080*I4","v":78748.800000000003},{"$f":"2080*J4","v":78104},{"$f":"2080*K4","v":77459.199999999997},null,"FY2019 Benchmark",19.53,18.93,{"$f":"(18.93+18.62)/2","v":18.774999999999999},18.62,null,"KingMonthly",{"$f":"H7/12","v":3385.2000000000003}]
[2,{"$f":"$B$2-($B$2*(A3-1)*5%)","v":77182.559999999998},{"$f":"$C$2-($C$2*(A3-1)*5%)","v":74811.360000000001},{"$f":"$D$2-($D$2*(A3-1)*5%)","v":74198.8},{"$f":"$E$2-($E$2*(A3-1)*5%)","v":73586.239999999991},1,"100% Increase",{"$f":"H2*F3","v":19.53},{"$f":"I2*F3","v":18.93},{"$f":"J2*F3","v":18.774999999999999},{"$f":"K2*F3","v":18.62},null,"KingQuarterly",{"$f":"H7/4","v":10155.6}]
[3,73120.320000000007,70873.919999999998,70293.600000000006,69713.279999999999,null,"Adminstrator ISS Regression Hrly Rate",{"$f":"ROUND(SUM(H2:H3),2)","v":39.06},{"$f":"ROUND(SUM(I2:I3),2)","v":37.86},{"$f":"ROUND(SUM(J2:J3),2)","v":37.549999999999997},{"$f":"ROUND(SUM(K2:K3),2)","v":37.24},null,"MSA/NON-MSAMonthly",{"$f":"J7/12","v":3254.3333333333335}]
[4,69058.080000000002,66936.479999999996,66388.399999999994,65840.319999999992,null,null,null,null,null,null,null,"MSA/NON-MSAQuarterly",{"$f":"J7/4","v":9763}]
[5,64995.840000000004,62999.040000000001,62483.199999999997,61967.360000000001,null,"ISS FTE Annual Hours",2080,2080,2080,2080,null,"MSAMonthly",{"$f":"I7/12","v":3281.2000000000003}]
[6,60933.600000000006,59061.600000000006,58578,58094.399999999994,null,"Annual ISS FTE Wages",{"$f":"H2*H6","v":40622.400000000001},{"$f":"I2*I6","v":39374.400000000001},{"$f":"J2*J6","v":39052},{"$f":"K2*K6","v":38729.599999999999},null,"MSAQuarterly",{"$f":"I7/4","v":9843.6}]
[7,56871.360000000001,55124.160000000003,54672.800000000003,54221.440000000002,null,null,null,null,null,null,null,"NON-MSAMonthly",{"$f":"K7/12","v":3227.4666666666667}]
[8,52809.120000000003,51186.720000000001,50767.6,50348.479999999996,null,null,null,null,null,null,null,"NON-MSAQuarterly",{"$f":"K7/4","v":9682.4}]
[9,48746.880000000005,47249.279999999999,46862.399999999994,46475.519999999997]
[10,44684.639999999999,43311.839999999997,42957.2,42602.559999999998]
[11,40622.400000000001,39374.400000000001,39052,38729.599999999999]
[12,36560.159999999996,35436.959999999999,35146.799999999996,34856.639999999999]
[13,32497.919999999998,31499.519999999997,31241.599999999999,30983.68]
[14,28435.679999999993,27562.080000000002,27336.399999999994,27110.719999999994,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D16=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D16,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D16=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D16,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D16=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D16,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D16=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D16,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[15,24373.440000000002,23624.639999999999,23431.199999999997,23237.759999999995]
[16,20311.199999999997,19687.199999999997,19526,19364.799999999996]
[17,16248.96,15749.759999999995,15620.799999999996,15491.839999999997]
[18,12186.720000000001,11812.319999999992,11715.599999999991,11618.880000000005,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D21=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D21,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D21=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D21,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D21=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D21,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D21=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D21,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[19,8124.4799999999959,7874.8799999999901,7810.3999999999942,7745.9199999999983]
[20,4062.2400000000052,3937.4400000000023,3905.1999999999971,3872.9599999999919]
[21,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D26=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,2)/12,VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,2)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D26=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,3)/12,VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,3)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D26=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,4)/12,VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,4)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D26=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,5)/12,VLOOKUP('B - ISS Payroll Expenses'!D26,'Administrator Regression Table'!$A$1:$E$22,5)/4))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D31=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D31,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D31=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D31,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D31=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D31,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D31=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D31,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D36=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D36,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D36=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D36,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D36=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D36,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D36=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D36,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D41=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,2)/12,VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,2)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D41=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,3)/12,VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,3)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D41=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,4)/12,VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,4)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D41=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,5)/12,VLOOKUP('B - ISS Payroll Expenses'!D41,'Administrator Regression Table'!$A$1:$E$22,5)/4))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D46=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D46,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D46=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D46,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D46=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D46,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D46=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D46,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D51=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D51,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D51=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D51,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D51=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D51,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D51=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D51,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D56=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,2)/12,VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,2)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D56=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,3)/12,VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,3)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D56=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,4)/12,VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,4)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D56=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,5)/12,VLOOKUP('B - ISS Payroll Expenses'!D56,'Administrator Regression Table'!$A$1:$E$22,5)/4))","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D61=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D61,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D61=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D61,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D61=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D61,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D61=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D61,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D66=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D66,'Administrator Regression Table'!$A$1:$E$22,2))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D66=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D66,'Administrator Regression Table'!$A$1:$E$22,3))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D66=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D66,'Administrator Regression Table'!$A$1:$E$22,4))/12)","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D66=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Quarterly\",0,VLOOKUP('B - ISS Payroll Expenses'!D66,'Administrator Regression Table'!$A$1:$E$22,5))/12)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('B - ISS Payroll Expenses'!D71=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,2)/12,VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,2)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D71=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,3)/12,VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,3)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D71=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,4)/12,VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,4)/4))","v":0},{"$f":"IF('B - ISS Payroll Expenses'!D71=0,0,IF('B - ISS Payroll Expenses'!$B$10=\"Monthly\",VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,5)/12,VLOOKUP('B - ISS Payroll Expenses'!D71,'Administrator Regression Table'!$A$1:$E$22,5)/4))","v":0}]

{"sheet":"RES","index":3,"n_rows":62,"n_cols":47,"rows_kept":62,"cut":false,"hidden":true,"merged":[[0,0,4,0],[0,7,4,7],[6,0,6,1]]}
[" ","FILE:",{"$f":"MID(CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1,FIND(\".\",CELL(\"filename\",A1),FIND(\"[\",CELL(\"filename\",A1))+1)-FIND(\"[\",CELL(\"filename\",A1))-1)","v":"2019 ABC Sample - Cost Report"},{"$f":"MID(CELL(\"filename\",B1),FIND(\"[\",CELL(\"filename\",B1))+1,FIND(\".\",CELL(\"filename\",B1),FIND(\"[\",CELL(\"filename\",B1))+1)-FIND(\"[\",CELL(\"filename\",B1))-1)","v":"2019 ABC Sample - Cost Report"},{"$f":"MID(CELL(\"filename\",C1),FIND(\"[\",CELL(\"filename\",C1))+1,FIND(\".\",CELL(\"filename\",C1),FIND(\"[\",CELL(\"filename\",C1))+1)-FIND(\"[\",CELL(\"filename\",C1))-1)","v":"2019 ABC Sample - Cost Report"}]
[null,"PROVIDER ID:",{"$f":"_C000002","v":555777999},{"$f":"_C000002","v":555777999},{"$f":"_C000002","v":555777999}]
[null,"PROVIDER NAME:",{"$f":"_M000001","v":"3S - ABC Residential Services"},{"$f":"_M000001","v":"3S - ABC Residential Services"},{"$f":"_M000001","v":"3S - ABC Residential Services"}]
[null,"CITY, ZIP:",{"$f":"_M000005","v":"Small Town, WA  99901"},{"$f":"_M000005","v":"Small Town, WA  99901"},{"$f":"_M000005","v":"Small Town, WA  99901"}]
[null,"PURCHASED PROFESSIONAL SERVICES",{"$f":"'C - Non-ISS Expenses'!$H$9","v":"Yes"},{"$f":"'C - Non-ISS Expenses'!$H$9","v":"Yes"},{"$f":"'C - Non-ISS Expenses'!$H$9","v":"Yes"}]
["Line","PROGRAM TYPE","TOTAL SUPPORTED LIVING","TOTAL GROUP HOME & GROUP TRAINING HOME","TOTAL ALL PROGRAMS",{"$f":"'C - Non-ISS Expenses'!_M000101","v":"SL Supported Living"},{"$f":"'C - Non-ISS Expenses'!_M000102","v":"GH Group Home"},{"$f":"'C - Non-ISS Expenses'!_M000105","v":"GTH Group Training Home"}]
[null,null,null,null,null,{"$f":"IF(_M001748=\"SL Supported Living\",1,IF(_M001748=\"GH Group Home\",2,IF(_M001748=\"GTH Group Training Home\",3,0)))","v":1},{"$f":"IF(_M001749=\"SL Supported Living\",1,IF(_M001749=\"GH Group Home\",2,IF(_M001749=\"GTH Group Training Home\",3,0)))","v":2},{"$f":"IF(_M001752=\"SL Supported Living\",1,IF(_M001752=\"GH Group Home\",2,IF(_M001752=\"GTH Group Training Home\",3,0)))","v":3}]
[1,"ISS & PROFESSIONAL SERVICES STAFF REGULAR TIME PAYROLL EXPENSES ",{"$f":"SUMIF($F$7:$H$7,1,F8:H8)","v":1247732.1747879104},{"$f":"(SUMIF($F$7:$H$7,2,F8:H8))+(SUMIF($F$7:$H$7,3,F8:H8))","v":827082.94521208911},{"$f":"SUM(F8:H8)","v":2074815.1199999996},{"$f":"('B - ISS Payroll Expenses'!$S$73+'B - ISS Payroll Expenses'!$S$74-'B - ISS Payroll Expenses'!$F$73-'B - ISS Payroll Expenses'!$F$74)*(F48/_C002601)","v":1247732.1747879104},{"$f":"('B - ISS Payroll Expenses'!$S$73+'B - ISS Payroll Expenses'!$S$74-'B - ISS Payroll Expenses'!$F$73-'B - ISS Payroll Expenses'!$F$74)*(G48/_C002601)","v":464427.88895126665},{"$f":"('B - ISS Payroll Expenses'!$S$73+'B - ISS Payroll Expenses'!$S$74-'B - ISS Payroll Expenses'!$F$73-'B - ISS Payroll Expenses'!$F$74)*(H48/_C002601)","v":362655.05626082246}]
[2,"ISS & PROFESSIONAL SERVICES STAFF OVERTIME PAYROLL EXPENSES ",76475.89922540843,50693.500774591535,127169.39999999997,{"$f":"('B - ISS Payroll Expenses'!$F$73+'B - ISS Payroll Expenses'!$F$74)*(_C002602/_C002601)","v":76475.89922540843},{"$f":"('B - ISS Payroll Expenses'!$F$73+'B - ISS Payroll Expenses'!$F$74)*(_C002603/_C002601)","v":28465.67648938244},{"$f":"('B - ISS Payroll Expenses'!$F$73+'B - ISS Payroll Expenses'!$F$74)*(_C002606/_C002601)","v":22227.824285209099}]
[3,"ALLOWABLE GH ADMINISTRATOR ISS REGULAR TIME PAYROLL EXPENSES (GROUP HOME ONLY)",0,0,0,{"$f":"('B - ISS Payroll Expenses'!$S$75-'B - ISS Payroll Expenses'!$F$75)*(_C002602/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$S$75-'B - ISS Payroll Expenses'!$F$75)*(_C002603/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$S$75-'B - ISS Payroll Expenses'!$F$75)*(_C002606/_C002601)","v":0}]
[4,"ALLOWABLE GH ADMINISTRATOR ISS OVERTIME PAYROLL EXPENSES (GROUP HOME ONLY)",0,0,0,{"$f":"'B - ISS Payroll Expenses'!$F$75*(_C002602/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$F$75*(_C002603/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$F$75*(_C002606/_C002601)","v":0}]
[5,"ALLOWABLE SL/COMB ADMINISTRATOR ISS REGULAR TIME PAYROLL EXPENSES",0,0,0,{"$f":"('B - ISS Payroll Expenses'!$S$76-'B - ISS Payroll Expenses'!$F$76)*(_C002602/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$S$76-'B - ISS Payroll Expenses'!$F$76)*(_C002603/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$S$76-'B - ISS Payroll Expenses'!$F$76)*(_C002606/_C002601)","v":0}]
[6,"ALLOWABLE SL/COMB ADMINISTRATOR ISS OVERTIME PAYROLL EXPENSES",0,0,0,{"$f":"'B - ISS Payroll Expenses'!$F$76*(_C002602/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$F$76*(_C002603/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$F$76*(_C002606/_C002601)","v":0}]
[null,"TOTAL ISS PAYROLL EXPENSES (SCHEDULE B)",{"$f":"SUM(C8:C13)","v":1324208.0740133189},877776.44598668069,2201984.5199999996,1324208.0740133189,492893.56544064911,384882.88054603158]
[7,"AUTHORIZED PURCHASED/CONTRACTED ISS PROFESSIONAL SERVICES (SCHEDULE G)",{"$f":"SUMIF($F$7:$H$7,1,F15:H15)","v":4892.25},{"$f":"(SUMIF($F$7:$H$7,2,F15:H15))+(SUMIF($F$7:$H$7,3,F15:H15))","v":3701.99},{"$f":"SUM(F15:H15)","v":8594.24},{"$f":"SUMIF('G - ISS Settlement'!$E$41:$E$43,F7,'G - ISS Settlement'!$C$41:$C$43)","v":4892.25},{"$f":"SUMIF('G - ISS Settlement'!$E$41:$E$43,G7,'G - ISS Settlement'!$C$41:$C$43)","v":3701.99},{"$f":"SUMIF('G - ISS Settlement'!$E$41:$E$43,H7,'G - ISS Settlement'!$C$41:$C$43)","v":0}]
[null,"TOTAL ISS EXPENSES (SCHEDULE B & SCHEDULE G)",{"$f":"SUM(C14:C15)","v":1329100.3240133189},881478.43598668068,2210578.7599999998,1329100.3240133189,496595.5554406491,384882.88054603158]
[8,"NON-ISS/ ADMINISTRATIVE STAFF REGULAR TIME PAYROLL EXPENSES ",{"$f":"SUMIF($F$7:$H$7,1,F17:H17)","v":13167.255121263388},{"$f":"(SUMIF($F$7:$H$7,2,F17:H17))+(SUMIF($F$7:$H$7,3,F17:H17))","v":8728.1648787366084},{"$f":"SUM(F17:H17)","v":21895.42},{"$f":"('B - ISS Payroll Expenses'!$T$73+'B - ISS Payroll Expenses'!$T$74-'B - ISS Payroll Expenses'!$I$73-'B - ISS Payroll Expenses'!$I$74)*(_C002602/_C002601)","v":13167.255121263388},{"$f":"('B - ISS Payroll Expenses'!$T$73+'B - ISS Payroll Expenses'!$T$74-'B - ISS Payroll Expenses'!$I$73-'B - ISS Payroll Expenses'!$I$74)*(_C002603/_C002601)","v":4901.0842413281352},{"$f":"('B - ISS Payroll Expenses'!$T$73+'B - ISS Payroll Expenses'!$T$74-'B - ISS Payroll Expenses'!$I$73-'B - ISS Payroll Expenses'!$I$74)*(_C002606/_C002601)","v":3827.0806374084732}]
[9,"NON-ISS/ ADMINISTRATIVE STAFF OVERTIME PAYROLL EXPENSES ",1187.4056417704965,787.09435822950354,1974.5,{"$f":"('B - ISS Payroll Expenses'!$I$73+'B - ISS Payroll Expenses'!$I$74)*(_C002602/_C002601)","v":1187.4056417704965},{"$f":"('B - ISS Payroll Expenses'!$I$73+'B - ISS Payroll Expenses'!$I$74)*(_C002603/_C002601)","v":441.97329096689646},{"$f":"('B - ISS Payroll Expenses'!$I$73+'B - ISS Payroll Expenses'!$I$74)*(_C002606/_C002601)","v":345.12106726260703}]
[10,"NON-ISS/ ADMINISTRATIVE GH ADMINISTRATOR REGULAR TIME PAYROLL EXPENSES",0,0,0,{"$f":"('B - ISS Payroll Expenses'!$T$75-'B - ISS Payroll Expenses'!$I$75)*(_C002602/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$T$75-'B - ISS Payroll Expenses'!$I$75)*(_C002603/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$T$75-'B - ISS Payroll Expenses'!$I$75)*(_C002606/_C002601)","v":0}]
[11,"NON-ISS/ ADMINISTRATIVE GH ADMINISTRATOR OVERTIME PAYROLL EXPENSES",0,0,0,{"$f":"'B - ISS Payroll Expenses'!$I$75*(_C002602/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$I$75*(_C002603/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$I$75*(_C002606/_C002601)","v":0}]
[12,"NON-ISS/ ADMINISTRATIVE SL/COMB ADMINISTRATOR REGULAR TIME PAYROLL EXPENSES",0,0,0,{"$f":"('B - ISS Payroll Expenses'!$T$76-'B - ISS Payroll Expenses'!$I$76)*(_C002602/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$T$76-'B - ISS Payroll Expenses'!$I$76)*(_C002603/_C002601)","v":0},{"$f":"('B - ISS Payroll Expenses'!$T$76-'B - ISS Payroll Expenses'!$I$76)*(_C002606/_C002601)","v":0}]
[13,"NON-ISS/ ADMINISTRATIVE SL/COMB ADMINISTRATOR OVERTIME PAYROLL EXPENSES",0,0,0,{"$f":"'B - ISS Payroll Expenses'!$I$76*(_C002602/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$I$76*(_C002603/_C002601)","v":0},{"$f":"'B - ISS Payroll Expenses'!$I$76*(_C002606/_C002601)","v":0}]
[null,"TOTAL NON-ISS/ ADMINISTRATIVE PAYROLL EXPENSES (SCHEDULE B)",{"$f":"SUM(C17:C22)","v":14354.660763033884},{"$f":"SUM(D17:D22)","v":9515.2592369661124},{"$f":"SUM(F23:H23)","v":23869.919999999995},{"$f":"SUM(F17:F22)","v":14354.660763033884},{"$f":"SUM(G17:G22)","v":5343.0575322950317},{"$f":"SUM(H17:H22)","v":4172.2017046710798}]
[14,"ADMINISTRATIVE/ NON-ISS PAYROLL EXPENSES",{"$f":"SUMIF($F$7:$H$7,1,F24:H24)","v":129838.285},{"$f":"(SUMIF($F$7:$H$7,2,F24:H24))+(SUMIF($F$7:$H$7,3,F24:H24))","v":44363.02},{"$f":"SUM(F24:H24)","v":174201.30499999999},{"$f":"'C - Non-ISS Expenses'!_C000276","v":129838.285},{"$f":"'C - Non-ISS Expenses'!_C000277","v":31108.259999999995},{"$f":"'C - Non-ISS Expenses'!_C000280","v":13254.76}]
[15,"PROGRAM OPERATIONS EXPENSES",{"$f":"SUMIF($F$7:$H$7,1,F25:H25)","v":27366.33},{"$f":"(SUMIF($F$7:$H$7,2,F25:H25))+(SUMIF($F$7:$H$7,3,F25:H25))","v":4228.66},31594.99,{"$f":"'C - Non-ISS Expenses'!F31","v":27366.33},{"$f":"'C - Non-ISS Expenses'!G31","v":3241.12},{"$f":"'C - Non-ISS Expenses'!H31","v":987.54}]
[16,"CAPITAL & PROPERTY EXPENSES",{"$f":"SUMIF($F$7:$H$7,1,F26:H26)","v":48940},38446.35,87386.349999999991,{"$f":"'C - Non-ISS Expenses'!F33","v":48940},{"$f":"'C - Non-ISS Expenses'!G33","v":25116.37},{"$f":"'C - Non-ISS Expenses'!H33","v":13329.98}]
[17,"INTEREST & TAX EXPENSES",{"$f":"SUMIF($F$7:$H$7,1,F27:H27)","v":7878.58},928.3,8806.8799999999992,{"$f":"'C - Non-ISS Expenses'!F35","v":7878.58},{"$f":"'C - Non-ISS Expenses'!G35","v":680.64},{"$f":"'C - Non-ISS Expenses'!H35","v":247.66}]
[null,"TOTAL NON-ISS ADMINISTRATIVE & OPERATING EXPENSES (SCHEDULE C)",{"$f":"SUM(C24:C27)","v":214023.19499999998},87966.33,301989.52499999997,214023.19499999998,60146.39,27819.94]
[18,"MAINTENANCE/LAUNDRY/HOUSEKEEPING/DIETARY (GROUP HOME ONLY)",{"$f":"SUMIF($F$7:$H$7,1,F29:H29)","v":15731.98},20831.07,36563.049999999996,{"$f":"'C - Non-ISS Expenses'!F38","v":15731.98},{"$f":"'C - Non-ISS Expenses'!G38","v":19065.73},{"$f":"'C - Non-ISS Expenses'!H38","v":1765.34}]
[19,"TRANSPORTATION EXPENSES",{"$f":"SUMIF($F$7:$H$7,1,F30:H30)","v":9264.15},20654.53,29918.68,{"$f":"'C - Non-ISS Expenses'!F40","v":9264.15},{"$f":"'C - Non-ISS Expenses'!G40","v":17500.14},{"$f":"'C - Non-ISS Expenses'!H40","v":3154.39}]
[20,"OTHER NON-ISS CLIENT RELATED EXPENSES",{"$f":"SUMIF($F$7:$H$7,1,F31:H31)","v":48041.364999999998},29251.35,77292.714999999997,{"$f":"'C - Non-ISS Expenses'!F42","v":48041.364999999998},{"$f":"'C - Non-ISS Expenses'!G42","v":23814.59},{"$f":"'C - Non-ISS Expenses'!H42","v":5436.76}]
[null,"TOTAL NON-ISS CLIENT RELATED EXPENSES (SCHEDULE C)",{"$f":"SUM(C29:C31)","v":73037.494999999995},70736.95,143774.44500000001,73037.494999999995,60380.459999999992,10356.49]
[null,"TOTAL NON-ISS/ ADMINISTRATIVE EXPENSES (SCHEDULE B & SCHEDULE C)",{"$f":"C23+C28+C32","v":301415.35076303384},168218.53923696611,469633.88999999996,301415.35076303384,125869.90753229502,42348.631704671076]
[null,"TOTAL PROGRAM EXPENSES (SCHEDULE B, C & G)",{"$f":"C16+C33","v":1630515.6747763527},1049696.9752236467,2680212.65,1630515.6747763527,622465.46297294414,427231.51225070265]
[21,"REVENUE FOR SERVICES PROVIDED",{"$f":"SUMIF($F$7:$H$7,1,F35:H35)","v":1622205.64},1067030.67,2689236.31,{"$f":"'D - Revenue'!F8","v":1622205.64},{"$f":"'D - Revenue'!G8","v":608645.42000000004},{"$f":"'D - Revenue'!H8","v":458385.25}]
[22,"OTHER OPERATING REVENUE",15750,4200,19950,{"$f":"'D - Revenue'!F10","v":15750},{"$f":"'D - Revenue'!G10","v":2000},{"$f":"'D - Revenue'!H10","v":2200}]
[23,"NON OPERATING REVENUE",1032,1200,2232,{"$f":"'D - Revenue'!F12","v":1032},{"$f":"'D - Revenue'!G12","v":744},{"$f":"'D - Revenue'!H12","v":456}]
[null,"TOTAL REVENUES (SCHEDULE D)",{"$f":"SUM(C35:C37)","v":1638987.64},1072430.67,2711418.31,1638987.64,611389.42000000004,461041.25]
[24,"ANNUAL ISS TIERED REIMBURSEMENT",{"$f":"SUMIF($F$7:$H$7,1,F39:H39)","v":1259031.49},{"$f":"(SUMIF($F$7:$H$7,2,F39:H39))+(SUMIF($F$7:$H$7,3,F39:H39))","v":850506.34000000008},2109537.83,{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,33)","v":1259031.49},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,33)","v":476359.44},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,33)","v":374146.9}]
[25,"ANNUAL ISS CRST REIMBURSEMENT",{"$f":"SUMIF($F$7:$H$7,1,F40:H40)","v":23429.889999999996},{"$f":"(SUMIF($F$7:$H$7,2,F40:H40))+(SUMIF($F$7:$H$7,3,F40:H40))","v":15811.52},39241.409999999996,{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,34)","v":23429.889999999996},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,34)","v":8858.27},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,34)","v":6953.25}]
[26,"ANNUAL ISS HOLD HARMLESS REIMBURSMENT",{"$f":"SUMIF($F$7:$H$7,1,F41:H41)","v":31554.100000000006},{"$f":"(SUMIF($F$7:$H$7,2,F41:H41))+(SUMIF($F$7:$H$7,3,F41:H41))","v":14409.349999999999},45963.450000000004,{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,35)","v":31554.100000000006},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,35)","v":9098.5999999999985},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,35)","v":5310.7499999999991}]
[null,"TOTAL ISS TIERED REIMBURSEMENTS (RECONCILED SCHEDULE H)",{"$f":"SUM(C39:C41)","v":1314015.48},{"$f":"SUM(D39:D41)","v":880727.21000000008},{"$f":"SUM(F42:H42)","v":2194742.69},{"$f":"SUM(F39:F41)","v":1314015.48},{"$f":"SUM(G39:G41)","v":494316.31},{"$f":"SUM(H39:H41)","v":386410.9}]
[27,"TOTAL ISS TIERED REIMBURSEMENTS",{"$f":"SUMIF($F$7:$H$7,1,F43:H43)","v":1314015.48},{"$f":"(SUMIF($F$7:$H$7,2,F43:H43))+(SUMIF($F$7:$H$7,3,F43:H43))","v":880727.21},{"$f":"SUM(F43:H43)","v":2194742.69},{"$f":"SUMIF('G - ISS Settlement'!E9:E11,F7,'G - ISS Settlement'!C9:C11)","v":1314015.48},{"$f":"SUMIF('G - ISS Settlement'!E9:E11,RES!G7,'G - ISS Settlement'!C9:C11)","v":494316.31},{"$f":"SUMIF('G - ISS Settlement'!E9:E11,RES!H7,'G - ISS Settlement'!C9:C11)","v":386410.9}]
[27,"PROFESSIONAL SERVICES REIMBURSED",{"$f":"SUMIF($F$7:$H$7,1,F44:H44)","v":14299.15},{"$f":"(SUMIF($F$7:$H$7,2,F44:H44))+(SUMIF($F$7:$H$7,3,F44:H44))","v":0},{"$f":"SUM(F44:H44)","v":14299.15},{"$f":"SUMIF('G - ISS Settlement'!E27:E32,F7,'G - ISS Settlement'!C27:C32)","v":14299.15},{"$f":"SUMIF('G - ISS Settlement'!E27:E32,G7,'G - ISS Settlement'!C27:C32)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E27:E32,H7,'G - ISS Settlement'!C27:C32)","v":0}]
[28,"NURSE DELEGATION REIMBURSED",3437,1853.5,5290.5,{"$f":"SUMIF('G - ISS Settlement'!E15:E17,F7,'G - ISS Settlement'!C15:C17)","v":3437},{"$f":"SUMIF('G - ISS Settlement'!E15:E17,RES!G7,'G - ISS Settlement'!C15:C17)","v":1165.8699999999999},{"$f":"SUMIF('G - ISS Settlement'!E15:E17,RES!H7,'G - ISS Settlement'!C15:C17)","v":687.63}]
[29,"STAFF ADD ON REIMBURSEMENTS",251.52,{"$f":"(SUMIF($F$7:$H$7,2,F46:H46))+(SUMIF($F$7:$H$7,3,F46:H46))","v":362.85},{"$f":"SUM(F46:H46)","v":614.37},{"$f":"SUMIF('G - ISS Settlement'!E18:E20,F7,'G - ISS Settlement'!C18:C20)","v":251.52},{"$f":"SUMIF('G - ISS Settlement'!E18:E20,G7,'G - ISS Settlement'!C18:C20)","v":312.85000000000002},{"$f":"SUMIF('G - ISS Settlement'!E18:E20,H7,'G - ISS Settlement'!C18:C20)","v":50}]
[29,"COCA COST OF CARE ADJUSTMENTS",0,0,0,{"$f":"SUMIF('G - ISS Settlement'!E21:E23,F7,'G - ISS Settlement'!C21:C23)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E21:E23,G7,'G - ISS Settlement'!C21:C23)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E21:E23,H7,'G - ISS Settlement'!C21:C23)","v":0}]
[null,"TOTAL ISS REIMBURSEMENTS (SCHEDULE G)",{"$f":"SUM(C43:C47)","v":1332003.1499999999},{"$f":"SUM(D43:D47)","v":882943.55999999994},{"$f":"SUM(F48:H48)","v":2214946.71},{"$f":"SUM(F43:F47)","v":1332003.1499999999},{"$f":"SUM(G43:G47)","v":495795.02999999997},{"$f":"SUM(H43:H47)","v":387148.53}]
[null,"TOTAL PRELIMINRY SETTLEMENT - ISS REIMBURSEMENTS MINUS ISS EXPENSES (SCHEDULE G)",{"$f":"IF(C48-C16<=0,0,C48-C16)","v":2902.8259866810404},{"$f":"IF(D48-D16<=0,0,D48-D16)","v":1465.1240133192623},{"$f":"(E48-E16)","v":4367.9500000001863},{"$f":"(F48-F16)","v":2902.8259866810404},{"$f":"(G48-G16)","v":-800.52544064912945},{"$f":"(H48-H16)","v":2265.64945396845}]
[31,"ANNUAL NON-ISS/ AMININISTRATIVE REIMBURESMENTS",{"$f":"SUMIF($F$7:$H$7,1,F50:H50)","v":228651.95999999993},{"$f":"(SUMIF($F$7:$H$7,2,F50:H50))+(SUMIF($F$7:$H$7,3,F50:H50))","v":175071.14999999997},{"$f":"SUM(F50:H50)","v":403723.10999999993},{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,38)","v":228651.95999999993},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,38)","v":108506.09999999998},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,38)","v":66565.05}]
[32,"ANNUAL NON-ISS/ ADMINISTRATIVE HOLD HARMLESS",{"$f":"SUMIF($F$7:$H$7,1,F51:H51)","v":10930.080000000002},{"$f":"(SUMIF($F$7:$H$7,2,F51:H51))+(SUMIF($F$7:$H$7,3,F51:H51))","v":4991.2800000000007},{"$f":"SUM(F51:H51)","v":15921.360000000002},{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,39)","v":10930.080000000002},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,39)","v":3151.6800000000003},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,39)","v":1839.6}]
[33,"ANNUAL NON-ISS/ ADMINISTRATIVE CRST REIMBURSEMENTS",{"$f":"SUMIF($F$7:$H$7,1,F52:H52)","v":5877.91},{"$f":"(SUMIF($F$7:$H$7,2,F52:H52))+(SUMIF($F$7:$H$7,3,F52:H52))","v":3963.5300000000007},9841.44,{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,40)","v":5877.91},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,40)","v":2218.8300000000004},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,40)","v":1744.7}]
[34,"ANNUAL NON-ISS TRANSPORTATION REIMBURSEMENTS",{"$f":"SUMIF($F$7:$H$7,1,F53:H53)","v":18381.86},{"$f":"(SUMIF($F$7:$H$7,2,F53:H53))+(SUMIF($F$7:$H$7,3,F53:H53))","v":0},18381.86,{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,41)","v":18381.86},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,41)","v":0},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,41)","v":0}]
[35,"ANNUAL NON-ISS OTHER REIMBURSEMENTS",{"$f":"SUMIF($F$7:$H$7,1,F54:H54)","v":30049.199999999993},{"$f":"(SUMIF($F$7:$H$7,2,F54:H54))+(SUMIF($F$7:$H$7,3,F54:H54))","v":2277.5},32326.699999999993,{"$f":"VLOOKUP($F$7,RES!$A$60:$AU$62,42)","v":30049.199999999993},{"$f":"VLOOKUP($G$7,RES!$A$60:$AU$62,42)","v":452.5},{"$f":"VLOOKUP($H$7,RES!$A$60:$AU$62,42)","v":1825}]
[null,"TOTAL NON-ISS/ADMINISTRATIVE REIMBURSEMENTS (RECONCILED SCHEDULE H)",{"$f":"SUM(C50:C54)","v":293891.00999999995},186303.45999999996,480194.46999999991,293891.00999999995,114329.10999999997,71974.350000000006]
[null,"NET NON-ISS/ ADMIN INCOME/LOSS (RECONCILED SCHEDULE H LESS SCHEDULE B & C EXPENSES) ",{"$f":"C55-C33","v":-7524.3407630338916},18084.92076303385,10560.579999999958,-7524.3407630338916,-11540.797532295051,29625.71829532893]
[36,"CLIENT DAYS",{"$f":"SUMIF($F$7:$H$7,1,F57:H57)","v":6506},{"$f":"(SUMIF($F$7:$H$7,2,F57:H57))+(SUMIF($F$7:$H$7,3,F57:H57))","v":2971},9477,{"$f":"VLOOKUP(RES!F7,RES!$A$60:$AU$62,47)","v":6506},{"$f":"VLOOKUP(RES!G7,RES!$A$60:$AU$62,47)","v":1876},{"$f":"VLOOKUP(RES!H7,RES!$A$60:$AU$62,47)","v":1095}]
[37,"NUMBER OF CLIENTS",{"$f":"SUMIF($F$7:$H$7,1,F58:H58)","v":23},{"$f":"(SUMIF($F$7:$H$7,2,F58:H58))+(SUMIF($F$7:$H$7,3,F58:H58))","v":10},33,{"$f":"VLOOKUP(RES!F7,RES!$A$60:$AU$62,11)","v":23},{"$f":"VLOOKUP(RES!G7,RES!$A$60:$AU$62,11)","v":7},{"$f":"VLOOKUP(RES!H7,RES!$A$60:$AU$62,11)","v":3}]
[]
[1,null,null,null,"SL Supported Living",null,null,null,null,6506,23,null,null,null,null,null,null,null,null,null,null,40.674999999999997,null,null,6726.1549999999997,null,null,null,null,null,1510.8000000000002,8236.9549999999999,1259031.49,23429.889999999996,31554.100000000006,14299.15,1328314.6300000001,228651.95999999993,10930.080000000002,5877.91,18381.86,30049.199999999993,293891.01,1622205.64,1622205.6400000001,0,6506]
[2,null,null,null,"GH Group Home",null,null,null,null,1876,7,null,null,null,null,null,null,null,null,null,null,0,null,null,2600.2599999999998,null,null,null,null,null,609.91999999999996,3210.1800000000003,476359.44,8858.27,9098.5999999999985,0,494316.30999999994,108506.09999999998,3151.6800000000003,2218.8300000000004,0,452.5,114329.11,608645.41999999993,608645.41999999993,0,1876]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,1095,3,null,null,null,null,null,null,null,null,null,null,0,null,null,1058.6600000000001,null,null,null,null,null,197.19,1255.8499999999999,374146.9,6953.25,5310.7499999999991,0,386410.9,66565.05,1839.6,1744.7,0,1825,71974.350000000006,458385.25,458385.25,0,1095]

{"sheet":"ReadMe","index":4,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,3],[2,1,2,3],[25,1,25,3],[26,2,26,3],[17,1,17,3],[19,1,19,3],[21,1,21,3],[23,1,23,3],[7,1,7,3],[9,1,9,3],[13,1,13,3],[15,1,15,3],[5,1,5,3],[3,1,3,3],[11,1,11,3]]}
[]
[null,"DDA Residential Programs Cost Report General Guidelines"]
[]
[null,"1. For 2019, a revised cost report has been developed to accomodate the tiered rate methodology system implemented 1/1/19. The department no longer settles on ISS hours, just ISS reimbursements. Agencies no longer need to track the hours employees attend CRST training (formerly 1163 training) as 80% of these funds will become part of the ISS settlement beginning in 2019, while 20% will remain in the Non-ISS/Admin cost center. The overtime consideration credit will not be extended to 2019 settlements because we no longer settle on hours. Schedule C used for reporting Non-ISS expenses does not provide a way for allocating costs between contracted and non-contracted. If an agency needs to allocate Non-ISS/Administrative costs they can use the (optional) Schedule I to do so. Schedule I can also be used to track ISS reimbursements recieived from COCA's. Schedule A must be revised with the current date each time a cost report is submitted. "]
[]
[null,"2. The completed cost report must be submitted in excel format using the 12/2019 revised cost report template. The cost report schedules (A, B, C, D, E, F, & G) are all in a single file. The completed report is to be emailed to both your resource manager and rate analyst (see below for rate analyst). The department no longer accepts Cost Report templates and survey templates from previous years. The current year cost report templates and related materials are available on the web. In addition, cost reports received in PDF or by mail cannot be accepted; only the signed Schedule A is to be scanned as PDF and attached to the email submitting the cost report. If scanning Schedule A is not possible, the signed form (Schedule A only) may be mailed or faxed to your regional resource manager. The resource manager will forward the signed Schedule A to the rates department if mailed or faxed."]
[]
[null,"3. Providers are to fill in cells that are formatted white. Cells that are formatted in yellow are locked and cannot be changed. Several places throughout the cost report, providers will select from a drop down list instead of typing in their information. Do not copy and paste while using this form."]
[]
[null,"4. Do not include client names, identification numbers, or identifying employee information in the cost report. If you use the optional form, Schedule H - Rate History, do not submit it with your cost report. This form, once complete, will list client names and identification numbers. The form is a separate file from the cost report template and providers have the option of using it to complete their cost report. Providers that choose to use this optional form will need to enter the necessary information throughout the year using their Exhibit C's and COCA's."]
[]
[null,"5. On Schedule B, ISS Payroll Expenses, providers must report all payroll costs for staff and eligible Administrators that work both contracted & non-contracted business in an ISS/direct care and/or Administrative capacity to allocate employer paid taxes and benefits, and to determine the percentage of Administrator compensation that can be claimed as ISS if eligible. On Schedule C, non-ISS Expenses, agencies are no longer able to allocate expenses between contracted, non-contracted, and administrative expenses. Agencies that need to allocate non-ISS costs will need to do so outside of the cost report. Providers can use the optional Schedule I - Allocations, to allocate expenses that are no longer able to be done within the cost report. "]
[]
[null,"6. Review the report before submitting to ensure all required information is both accurate and complete. It is also recommended to print preview before printing as some printers allow different margins or use slightly different font sizes that may cause schedules to not fit as they were designed."]
[]
[null,"7. It is recommended that the cost report preparer refer to the cost reporting instructions, DDA policy 6.04, the Chart of Accounts, PowerPoint Presentation and template samples while completing their cost report. "]
[]
[null,"8. On Schedule A, please include your current contact information for your agency and the cost report preparer, including email addresses."]
[]
[null,"9. Each schedule (A through G) is on a separate tab. Move from schedule to schedule by clicking on the appropriate tab. If additional tabs are needed for Schedule E - Residential Staffing, please contact your rates analyst."]
[]
[null,"10. There are several places throughout the schedules where you will find a small red triangle in the upper right corner of a cell.  As you pass the mouse cursor over the triangle, an explanation of the information required or relative information for that cell will appear in a comment box."]
[]
[null,"11.  If you have any trouble or have questions about using the spreadsheet, or if you find any errors in logic, line or column references or anything else that requires attention, please feel free to contact any of the individuals listed below.     "]
[]
[null,"IMPORTANT DATES"]
[null,"Extension Requests must be received by March 15\nMarch 31 - Cost Reports Due","April 30 - Extension Due Date"]
[]
[null,"DD Rates Contact Information"," Telephone"," E-mail address "]
[null,"Ken Callaghan, DDA Rates Manager                           ","(360) 725-3206","kenneth.callaghan@dshs.wa.gov"]
[null,"Serena Clark, DDA Program Manager","(360) 725-2476","serena.clark@dshs.wa.gov"]
[null,"Tod Johnson, Analyst - Regions 1 & SOLA","(360) 725-2347","tod.johnson@dshs.wa.gov"]
[null,"Samantha (Sam) Everett, Analyst - LSR & Regions 2 & 3","(360) 725-2441","samantha.everett@dshs.wa.gov"]
[null,"Tammy Paulk, Analyst - ICF/ID & RHC","(360) 725-2498","tammy.paulk@dshs.wa.gov"]

{"sheet":"A - General Info & Cert","index":5,"n_rows":35,"n_cols":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[28,2,28,3],[2,1,2,4],[27,1,27,3],[5,1,5,2],[24,1,24,3],[7,3,7,4],[9,3,9,4],[11,1,11,4],[13,3,13,4],[15,2,15,4],[19,3,19,4],[26,2,26,3],[0,1,0,4],[5,3,5,4],[17,3,17,4],[25,2,25,3],[22,1,22,3]]}
[null,"SCHEDULE  A"]
[]
[]
[null,"PART A - PROVIDER IDENTIFYING INFORMATION"]
[null,"1. PROVIDER AGENCY NAME",null,"2. PROVIDER ONE ID"]
[null,"3S - ABC Residential Services",null,{"$f":"IF(_M000001=\"\",\"\",VLOOKUP(_M000001,Lists!$A$4:$B$138,2,FALSE))","v":555777999}]
[null,"3. PROVIDER MAILING ADDRESS","4. CITY, ZIP ","5. PROVIDER PHONE NUMBER"]
[null,"123 Main Street","Small Town, WA  99901","360-555-5555"]
[null,"6. ADMINISTRATOR","7. E-MAIL ADDRESS","8. DDA REGION ID"]
[null,"Joe Smith","jsmith@gmail.com",{"$f":"LEFT(_M000001,2)","v":"3S"}]
[null,"9. HOME OFFICE/CORPORATE NAME (please indicate if NONE or SAME AS ABOVE)"]
[null,"same as above"]
[null,"10. HOME OFFICE MAILING ADDRESS","11. CITY AND ZIP","12. HOME OFFICE PHONE No."]
[]
[null,"13. COST REPORT PREPARER","14. FIRM NAME"]
[null,"Sally Tenkey","Tenkey Accounting"]
[null,"15. REPORT CONTACT INDIVIDUAL(S)","16. CONTACT PHONE #","17. CONTACT e-mail Address"]
[null,"Sally Tenkey","360-123-4567","Sally@TenkeyAccounting.comm"]
[null,"18. COST REPORT PERIOD",null,"19.       REPORTING PURPOSE"]
[null,"2019-01-01","2019-12-31","Cost Report"]
[null,"FROM:","TO:"]
[null,"PART B. - CERTIFICATION"]
[null,"MISREPRESENTATION OR FALSIFICATION OF ANY INFORMATION CONTAINED IN THIS COST REPORT MAY BE PUNISHABLE BY FINE AND/OR IMPRISONMENT UNDER STATE OR FEDERAL LAW"]
[null,null,"CERTIFICATION"]
[null,"I HEREBY CERTIFY under penalty of perjury that I have read the above statement and have examined the accompanying cost report and supporting schedules prepared for: "]
[null," ","ABC Residential Services, Inc."]
[null,null,"(Provider Name)"]
[null,"and I attest, it is a true, correct and complete representation of actual costs related to client supports prepared in accordance with applicable instructions provided by DDA, except as noted."]
[null,null,"Joe Smith"]
[null,null,"PERSON SIGNING MUST HAVE AUTHORITY TO BIND THE PROVIDER LISTED"]
[null,null,"Administrator","2020-03-31"]
[null,null,"TITLE","DATE"]
[]
[]
[null,"DSHS/DDA Schedule A (Rev. 12/2019)"]

{"sheet":"B - ISS Payroll Expenses","index":6,"n_rows":80,"n_cols":21,"rows_kept":80,"cut":false,"hidden":false,"merged":[[9,3,9,20],[0,1,0,20],[2,3,7,18],[2,19,2,20],[12,3,14,3],[17,3,19,3],[22,3,24,3],[27,3,29,3],[32,3,34,3],[37,3,39,3],[72,3,74,3],[67,3,69,3],[42,3,44,3],[47,3,49,3],[62,3,64,3],[57,3,59,3],[52,3,54,3]]}
[null,"SCHEDULE B"]
[]
[null,null,null,"MONTHLY OR QUARTERLY PAYROLL REPORTING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"_M000001","v":"3S - ABC Residential Services"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[]
[]
[null,"Monthly","Reporting Period (Select from drop down list)","PROVIDER MUST MAINTAIN SUPPORTING PAYROLL RECORDS FOR AMOUNTS REPORTED EACH MONTH/QUARTER (BY EMPLOYEE) - AVAILABLE UPON REQUEST"]
[null,"COL. A","COL. B","COL. C","COL. D","COL. E","COL. F","COL. G","COL. H","COL. I","COL. J","COL. K","COL. L","COL. M","COL. N","COL. O","COL. P","COL. Q","COL. R","COL. S","COL. T"]
[null,"MONTH / QUARTER","EMPLOYEE TYPE","ISS FTE'S ","ISS GROSS PAYROLL FOR STAFF (REGUALAR TIME)","ISS GROSS PAYROLL FOR STAFF (OVERTIME)","ISS % OF TOTAL GROSS PAYROLL","ADMINISTRATIVE/ NON-ISS GROSS PAYROLL FOR STAFF (REGUALAR TIME)","ADMINISTRATIVE/ NON-ISS GROSS PAYROLL FOR STAFF (OVERTIME)","ADMINISTRATIVE/ NON-ISS % OF TOTAL GROSS PARYOLL","GROSS PAYROLL FOR NON-CONTRACTED BUSINESS (REGULAR & OT)","NON-CONTRACTED % OF TOTAL GROSS PAYROLL","GROSS PAYROLL FOR PAID TIME OFF (HOLIDAYS, VACATION &/OR SICK LEAVE)","GROSS PAYROLL OTHER COMPENSATION","TOTAL MONTHLY GROSS PAYROLL","TOTAL EMPLOYER PAID PAYROLL TAXES \n(SOCIAL SECURITY & MEDICARE, FUTA, SUTA, L&I) & ISS PORTION OF B&O TAXES","TOTAL EMPLOYER PAID TAXABLE & NON-TAXABLE FRINGE BENEFITS \n(AS DESCRIBED BY THE IRS)","TOTAL MONTHLY GROSS PAYROLL INCLUDING EMPLOYER PAID TAXES & BENEFITS","TOTAL ISS PAYROLL COSTS","TOTAL NON-ISS PAYROLL COSTS","TOTAL NON-CONTRACTED PAYROLL COSTS"]
[1,"JANUARY","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E13+E14)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},{"$f":"109417.06+4800","v":114217.06},10597.45,{"$f":"IF((E13+F13)<=0,0,SUM(E13+F13)/SUM(E13+F13+H13+I13+K13))","v":1},0,0,{"$f":"IF((H13+I13)<=0,0,SUM(H13+I13)/SUM(E13+F13+H13+I13+K13))","v":0},0,{"$f":"IF(K13<=0,0,K13/SUM(E13+F13+H13+I13+K13))","v":0},10437.06,0,{"$f":"SUM(E13+F13+H13+I13+M13+N13+K13)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O13:Q13)","v":163834.91000000003},{"$f":"ROUND(SUM(E13+F13),2)+ROUND(SUM(M13+N13+P13+Q13)*G13,2)","v":163834.91},0,{"$f":"K13+ROUND(SUM(M13+N13+P13+Q13)*L13,2)","v":0}]
[2,"JANUARY","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E14+F14)<=0,0,SUM(E14+F14)/SUM(E14+F14+H14+I14+K14))","v":0.84009360873379724},{"$f":"1727.09-179.5","v":1547.59},179.5,{"$f":"IF((H14+I14)<=0,0,SUM(H14+I14)/SUM(E14+F14+H14+I14+K14))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K14<=0,0,K14/SUM(E14+F14+H14+I14+K14))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E14+F14+H14+I14+M14+N14+K14)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O14:Q14)","v":23406.68},{"$f":"ROUND(SUM(E14+F14),2)+ROUND(SUM(M14+N14+P14+Q14)*G14,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H14+I14),2)+ROUND(SUM(M14+N14+P14+Q14)*J14,2)","v":1989.1599999999999},{"$f":"K14+ROUND(SUM(M14+N14+P14+Q14)*L14,2)","v":1753.72}]
[3,"JANUARY","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E15+F15)<=0,0,SUM(E15+F15)/SUM(E15+F15+H15+I15+K15))","v":0},0,0,{"$f":"IF((H15+I15)<=0,0,SUM(H15+I15)/SUM(E15+F15+H15+I15+K15))","v":0},0,{"$f":"IF(K15<=0,0,K15/SUM(E15+F15+H15+I15+K15))","v":0},0,0,{"$f":"SUM(E15+F15+H15+I15+M15+N15+K15)","v":0},0,0,{"$f":"SUM(O15:Q15)","v":0},{"$f":"ROUND(SUM(E15+F15),2)+ROUND(SUM(M15+N15+P15+Q15)*G15,2)","v":0},{"$f":"ROUND(SUM(H15+I15),2)+ROUND(SUM(M15+N15+P15+Q15)*J15,2)","v":0},{"$f":"K15+ROUND(SUM(M15+N15+P15+Q15)*L15,2)","v":0}]
[4,"JANUARY","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D13:D14)","v":40},0,0,{"$f":"IF((E16+F16)<=0,0,SUM(E16+F16)/SUM(E16+F16+H16+I16+K16))","v":0},0,0,{"$f":"IF((H16+I16)<=0,0,SUM(H16+I16)/SUM(E16+F16+H16+I16+K16))","v":0},0,{"$f":"IF(K16<=0,0,K16/SUM(E16+F16+H16+I16+K16))","v":0},0,0,{"$f":"SUM(E16+F16+H16+I16+M16+N16+K16)","v":0},0,0,{"$f":"SUM(O16:Q16)","v":0},{"$f":"IF(G16=0,0,IF((M16+N16+P16+Q16)*G16+(E16+F16)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,15)*G16),((M16+N16+P16+Q16)*G16+(E16+F16)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,15)*G16)))","v":0},{"$f":"R16-U16-S16","v":0},{"$f":"K16+ROUND(SUM(M16+N16+P16+Q16)*L16,2)","v":0}]
[5,"JANUARY TOTAL",null,null,{"$f":"SUM(E13:E16)","v":131290.19},{"$f":"SUM(F13:F16)","v":10597.45},null,{"$f":"SUM(H13:H16)","v":1547.59},{"$f":"SUM(I13:I16)","v":179.5},null,{"$f":"SUM(K13:K16)","v":1522.67},null,{"$f":"SUM(M13:M16)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[6,"FEBRUARY","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E18+E19)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E18+F18)<=0,0,SUM(E18+F18)/SUM(E18+F18+H18+I18+K18))","v":1},0,0,{"$f":"IF((H18+I18)<=0,0,SUM(H18+I18)/SUM(E18+F18+H18+I18+K18))","v":0},0,{"$f":"IF(K18<=0,0,K18/SUM(E18+F18+H18+I18+K18))","v":0},10437.06,0,{"$f":"SUM(E18+F18+H18+I18+M18+N18+K18)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O18:Q18)","v":163834.91000000003},{"$f":"ROUND(SUM(E18+F18),2)+ROUND(SUM(M18+N18+P18+Q18)*G18,2)","v":163834.91},0,{"$f":"K18+ROUND(SUM(M18+N18+P18+Q18)*L18,2)","v":0}]
[7,"FEBRUARY","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E19+F19)<=0,0,SUM(E19+F19)/SUM(E19+F19+H19+I19+K19))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H19+I19)<=0,0,SUM(H19+I19)/SUM(E19+F19+H19+I19+K19))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K19<=0,0,K19/SUM(E19+F19+H19+I19+K19))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E19+F19+H19+I19+M19+N19+K19)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O19:Q19)","v":23406.68},{"$f":"ROUND(SUM(E19+F19),2)+ROUND(SUM(M19+N19+P19+Q19)*G19,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H19+I19),2)+ROUND(SUM(M19+N19+P19+Q19)*J19,2)","v":1989.1599999999999},{"$f":"K19+ROUND(SUM(M19+N19+P19+Q19)*L19,2)","v":1753.72}]
[8,"FEBRUARY","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E20+F20)<=0,0,SUM(E20+F20)/SUM(E20+F20+H20+I20+K20))","v":0},0,0,{"$f":"IF((H20+I20)<=0,0,SUM(H20+I20)/SUM(E20+F20+H20+I20+K20))","v":0},0,{"$f":"IF(K20<=0,0,K20/SUM(E20+F20+H20+I20+K20))","v":0},0,0,{"$f":"SUM(E20+F20+H20+I20+M20+N20+K20)","v":0},0,0,{"$f":"SUM(O20:Q20)","v":0},{"$f":"ROUND(SUM(E20+F20),2)+ROUND(SUM(M20+N20+P20+Q20)*G20,2)","v":0},{"$f":"ROUND(SUM(H20+I20),2)+ROUND(SUM(M20+N20+P20+Q20)*J20,2)","v":0},{"$f":"K20+ROUND(SUM(M20+N20+P20+Q20)*L20,2)","v":0}]
[9,"FEBRUARY","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D18:D19)","v":40},0,0,{"$f":"IF((E21+F21)<=0,0,SUM(E21+F21)/SUM(E21+F21+H21+I21+K21))","v":0},0,0,{"$f":"IF((H21+I21)<=0,0,SUM(H21+I21)/SUM(E21+F21+H21+I21+K21))","v":0},0,{"$f":"IF(K21<=0,0,K21/SUM(E21+F21+H21+I21+K21))","v":0},0,0,{"$f":"SUM(E21+F21+H21+I21+M21+N21+K21)","v":0},0,0,{"$f":"SUM(O21:Q21)","v":0},{"$f":"IF(G21=0,0,IF((M21+N21+P21+Q21)*G21+(E21+F21)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,19)*G21),((M21+N21+P21+Q21)*G21+(E21+F21)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,19)*G21)))","v":0},{"$f":"R21-U21-S21","v":0},{"$f":"K21+ROUND(SUM(M21+N21+P21+Q21)*L21,2)","v":0}]
[10,"FEBRUARY TOTAL",null,null,{"$f":"SUM(E18:E21)","v":131290.19},{"$f":"SUM(F18:F21)","v":10597.45},null,{"$f":"SUM(H18:H21)","v":1547.59},{"$f":"SUM(I18:I21)","v":179.5},null,{"$f":"SUM(K18:K21)","v":1522.67},null,{"$f":"SUM(M18:M21)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[11,"MARCH / \n1ST QUARTER","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E23+E24)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E23+F23)<=0,0,SUM(E23+F23)/SUM(E23+F23+H23+I23+K23))","v":1},0,0,{"$f":"IF((H23+I23)<=0,0,SUM(H23+I23)/SUM(E23+F23+H23+I23+K23))","v":0},0,{"$f":"IF(K23<=0,0,K23/SUM(E23+F23+H23+I23+K23))","v":0},10437.06,0,{"$f":"SUM(E23+F23+H23+I23+M23+N23+K23)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O23:Q23)","v":163834.91000000003},{"$f":"ROUND(SUM(E23+F23),2)+ROUND(SUM(M23+N23+P23+Q23)*G23,2)","v":163834.91},0,{"$f":"K23+ROUND(SUM(M23+N23+P23+Q23)*L23,2)","v":0}]
[12,"MARCH / \n1ST QUARTER","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E24+F24)<=0,0,SUM(E24+F24)/SUM(E24+F24+H24+I24+K24))","v":0.84009360873379724},1727.09,0,{"$f":"IF((H24+I24)<=0,0,SUM(H24+I24)/SUM(E24+F24+H24+I24+K24))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K24<=0,0,K24/SUM(E24+F24+H24+I24+K24))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E24+F24+H24+I24+M24+N24+K24)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O24:Q24)","v":23406.68},{"$f":"ROUND(SUM(E24+F24),2)+ROUND(SUM(M24+N24+P24+Q24)*G24,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H24+I24),2)+ROUND(SUM(M24+N24+P24+Q24)*J24,2)","v":1989.1599999999999},{"$f":"K24+ROUND(SUM(M24+N24+P24+Q24)*L24,2)","v":1753.72}]
[13,"MARCH / \n1ST QUARTER","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E25+F25)<=0,0,SUM(E25+F25)/SUM(E25+F25+H25+I25+K25))","v":0},0,0,{"$f":"IF((H25+I25)<=0,0,SUM(H25+I25)/SUM(E25+F25+H25+I25+K25))","v":0},0,{"$f":"IF(K25<=0,0,K25/SUM(E25+F25+H25+I25+K25))","v":0},0,0,{"$f":"SUM(E25+F25+H25+I25+M25+N25+K25)","v":0},0,0,{"$f":"SUM(O25:Q25)","v":0},{"$f":"ROUND(SUM(E25+F25),2)+ROUND(SUM(M25+N25+P25+Q25)*G25,2)","v":0},{"$f":"ROUND(SUM(H25+I25),2)+ROUND(SUM(M25+N25+P25+Q25)*J25,2)","v":0},{"$f":"K25+ROUND(SUM(M25+N25+P25+Q25)*L25,2)","v":0}]
[14,"MARCH / \n1ST QUARTER","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D23:D24)","v":40},0,0,{"$f":"IF((E26+F26)<=0,0,SUM(E26+F26)/SUM(E26+F26+H26+I26+K26))","v":0},0,0,{"$f":"IF((H26+I26)<=0,0,SUM(H26+I26)/SUM(E26+F26+H26+I26+K26))","v":0},0,{"$f":"IF(K26<=0,0,K26/SUM(E26+F26+H26+I26+K26))","v":0},0,0,{"$f":"SUM(E26+F26+H26+I26+M26+N26+K26)","v":0},0,0,{"$f":"SUM(O26:Q26)","v":0},{"$f":"IF(G26=0,0,IF((M26+N26+P26+Q26)*G26+(E26+F26)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,23)*G26),((M26+N26+P26+Q26)*G26+(E26+F26)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,23)*G26)))","v":0},{"$f":"R26-U26-S26","v":0},{"$f":"K26+ROUND(SUM(M26+N26+P26+Q26)*L26,2)","v":0}]
[15,"MARCH TOTAL",null,null,{"$f":"SUM(E23:E26)","v":131290.19},{"$f":"SUM(F23:F26)","v":10597.45},null,{"$f":"SUM(H23:H26)","v":1727.09},{"$f":"SUM(I23:I26)","v":0},null,{"$f":"SUM(K23:K26)","v":1522.67},null,{"$f":"SUM(M23:M26)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[16,"APRIL","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E28+E29)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E28+F28)<=0,0,SUM(E28+F28)/SUM(E28+F28+H28+I28+K28))","v":1},0,0,{"$f":"IF((H28+I28)<=0,0,SUM(H28+I28)/SUM(E28+F28+H28+I28+K28))","v":0},0,{"$f":"IF(K28<=0,0,K28/SUM(E28+F28+H28+I28+K28))","v":0},10437.06,0,{"$f":"SUM(E28+F28+H28+I28+M28+N28+K28)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O28:Q28)","v":163834.91000000003},{"$f":"ROUND(SUM(E28+F28),2)+ROUND(SUM(M28+N28+P28+Q28)*G28,2)","v":163834.91},0,{"$f":"K28+ROUND(SUM(M28+N28+P28+Q28)*L28,2)","v":0}]
[17,"APRIL","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E29+F29)<=0,0,SUM(E29+F29)/SUM(E29+F29+H29+I29+K29))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H29+I29)<=0,0,SUM(H29+I29)/SUM(E29+F29+H29+I29+K29))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K29<=0,0,K29/SUM(E29+F29+H29+I29+K29))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E29+F29+H29+I29+M29+N29+K29)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O29:Q29)","v":23406.68},{"$f":"ROUND(SUM(E29+F29),2)+ROUND(SUM(M29+N29+P29+Q29)*G29,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H29+I29),2)+ROUND(SUM(M29+N29+P29+Q29)*J29,2)","v":1989.1599999999999},{"$f":"K29+ROUND(SUM(M29+N29+P29+Q29)*L29,2)","v":1753.72}]
[18,"APRIL","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E30+F30)<=0,0,SUM(E30+F30)/SUM(E30+F30+H30+I30+K30))","v":0},0,0,{"$f":"IF((H30+I30)<=0,0,SUM(H30+I30)/SUM(E30+F30+H30+I30+K30))","v":0},0,{"$f":"IF(K30<=0,0,K30/SUM(E30+F30+H30+I30+K30))","v":0},0,0,{"$f":"SUM(E30+F30+H30+I30+M30+N30+K30)","v":0},0,0,{"$f":"SUM(O30:Q30)","v":0},{"$f":"ROUND(SUM(E30+F30),2)+ROUND(SUM(M30+N30+P30+Q30)*G30,2)","v":0},{"$f":"ROUND(SUM(H30+I30),2)+ROUND(SUM(M30+N30+P30+Q30)*J30,2)","v":0},{"$f":"K30+ROUND(SUM(M30+N30+P30+Q30)*L30,2)","v":0}]
[19,"APRIL","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D28:D29)","v":40},0,0,{"$f":"IF((E31+F31)<=0,0,SUM(E31+F31)/SUM(E31+F31+H31+I31+K31))","v":0},0,0,{"$f":"IF((H31+I31)<=0,0,SUM(H31+I31)/SUM(E31+F31+H31+I31+K31))","v":0},0,{"$f":"IF(K31<=0,0,K31/SUM(E31+F31+H31+I31+K31))","v":0},0,0,{"$f":"SUM(E31+F31+H31+I31+M31+N31+K31)","v":0},0,0,{"$f":"SUM(O31:Q31)","v":0},{"$f":"IF(G31=0,0,IF((M31+N31+P31+Q31)*G31+(E31+F31)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,27)*G31),((M31+N31+P31+Q31)*G31+(E31+F31)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,27)*G31)))","v":0},{"$f":"R31-U31-S31","v":0},{"$f":"K31+ROUND(SUM(M31+N31+P31+Q31)*L31,2)","v":0}]
[20,"APRIL TOTAL",null,null,{"$f":"SUM(E28:E31)","v":131290.19},{"$f":"SUM(F28:F31)","v":10597.45},null,{"$f":"SUM(H28:H31)","v":1547.59},{"$f":"SUM(I28:I31)","v":179.5},null,{"$f":"SUM(K28:K31)","v":1522.67},null,{"$f":"SUM(M28:M31)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[21,"MAY","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E33+E34)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E33+F33)<=0,0,SUM(E33+F33)/SUM(E33+F33+H33+I33+K33))","v":1},0,0,{"$f":"IF((H33+I33)<=0,0,SUM(H33+I33)/SUM(E33+F33+H33+I33+K33))","v":0},0,{"$f":"IF(K33<=0,0,K33/SUM(E33+F33+H33+I33+K33))","v":0},10437.06,0,{"$f":"SUM(E33+F33+H33+I33+M33+N33+K33)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O33:Q33)","v":163834.91000000003},{"$f":"ROUND(SUM(E33+F33),2)+ROUND(SUM(M33+N33+P33+Q33)*G33,2)","v":163834.91},0,{"$f":"K33+ROUND(SUM(M33+N33+P33+Q33)*L33,2)","v":0}]
[22,"MAY","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E34+F34)<=0,0,SUM(E34+F34)/SUM(E34+F34+H34+I34+K34))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H34+I34)<=0,0,SUM(H34+I34)/SUM(E34+F34+H34+I34+K34))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K34<=0,0,K34/SUM(E34+F34+H34+I34+K34))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E34+F34+H34+I34+M34+N34+K34)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O34:Q34)","v":23406.68},{"$f":"ROUND(SUM(E34+F34),2)+ROUND(SUM(M34+N34+P34+Q34)*G34,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H34+I34),2)+ROUND(SUM(M34+N34+P34+Q34)*J34,2)","v":1989.1599999999999},{"$f":"K34+ROUND(SUM(M34+N34+P34+Q34)*L34,2)","v":1753.72}]
[23,"MAY","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E35+F35)<=0,0,SUM(E35+F35)/SUM(E35+F35+H35+I35+K35))","v":0},0,0,{"$f":"IF((H35+I35)<=0,0,SUM(H35+I35)/SUM(E35+F35+H35+I35+K35))","v":0},0,{"$f":"IF(K35<=0,0,K35/SUM(E35+F35+H35+I35+K35))","v":0},0,0,{"$f":"SUM(E35+F35+H35+I35+M35+N35+K35)","v":0},0,0,{"$f":"SUM(O35:Q35)","v":0},{"$f":"ROUND(SUM(E35+F35),2)+ROUND(SUM(M35+N35+P35+Q35)*G35,2)","v":0},{"$f":"ROUND(SUM(H35+I35),2)+ROUND(SUM(M35+N35+P35+Q35)*J35,2)","v":0},{"$f":"K35+ROUND(SUM(M35+N35+P35+Q35)*L35,2)","v":0}]
[24,"MAY","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D33:D34)","v":40},0,0,{"$f":"IF((E36+F36)<=0,0,SUM(E36+F36)/SUM(E36+F36+H36+I36+K36))","v":0},0,0,{"$f":"IF((H36+I36)<=0,0,SUM(H36+I36)/SUM(E36+F36+H36+I36+K36))","v":0},0,{"$f":"IF(K36<=0,0,K36/SUM(E36+F36+H36+I36+K36))","v":0},0,0,{"$f":"SUM(E36+F36+H36+I36+M36+N36+K36)","v":0},0,0,{"$f":"SUM(O36:Q36)","v":0},{"$f":"IF(G36=0,0,IF((M36+N36+P36+Q36)*G36+(E36+F36)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,31)*G36),((M36+N36+P36+Q36)*G36+(E36+F36)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,31)*G36)))","v":0},{"$f":"R36-U36-S36","v":0},{"$f":"K36+ROUND(SUM(M36+N36+P36+Q36)*L36,2)","v":0}]
[25,"MAY TOTAL",null,null,{"$f":"SUM(E33:E36)","v":131290.19},{"$f":"SUM(F33:F36)","v":10597.45},null,{"$f":"SUM(H33:H36)","v":1547.59},{"$f":"SUM(I33:I36)","v":179.5},null,{"$f":"SUM(K33:K36)","v":1522.67},null,{"$f":"SUM(M33:M36)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[26,"JUNE / \n2ND QUARTER","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E38+E39)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E38+F38)<=0,0,SUM(E38+F38)/SUM(E38+F38+H38+I38+K38))","v":1},0,0,{"$f":"IF((H38+I38)<=0,0,SUM(H38+I38)/SUM(E38+F38+H38+I38+K38))","v":0},0,{"$f":"IF(K38<=0,0,K38/SUM(E38+F38+H38+I38+K38))","v":0},10437.06,0,{"$f":"SUM(E38+F38+H38+I38+M38+N38+K38)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O38:Q38)","v":163834.91000000003},{"$f":"ROUND(SUM(E38+F38),2)+ROUND(SUM(M38+N38+P38+Q38)*G38,2)","v":163834.91},0,{"$f":"K38+ROUND(SUM(M38+N38+P38+Q38)*L38,2)","v":0}]
[27,"JUNE / \n2ND QUARTER","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E39+F39)<=0,0,SUM(E39+F39)/SUM(E39+F39+H39+I39+K39))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H39+I39)<=0,0,SUM(H39+I39)/SUM(E39+F39+H39+I39+K39))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K39<=0,0,K39/SUM(E39+F39+H39+I39+K39))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E39+F39+H39+I39+M39+N39+K39)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O39:Q39)","v":23406.68},{"$f":"ROUND(SUM(E39+F39),2)+ROUND(SUM(M39+N39+P39+Q39)*G39,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H39+I39),2)+ROUND(SUM(M39+N39+P39+Q39)*J39,2)","v":1989.1599999999999},{"$f":"K39+ROUND(SUM(M39+N39+P39+Q39)*L39,2)","v":1753.72}]
[28,"JUNE / \n2ND QUARTER","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E40+F40)<=0,0,SUM(E40+F40)/SUM(E40+F40+H40+I40+K40))","v":0},0,0,{"$f":"IF((H40+I40)<=0,0,SUM(H40+I40)/SUM(E40+F40+H40+I40+K40))","v":0},0,{"$f":"IF(K40<=0,0,K40/SUM(E40+F40+H40+I40+K40))","v":0},0,0,{"$f":"SUM(E40+F40+H40+I40+M40+N40+K40)","v":0},0,0,{"$f":"SUM(O40:Q40)","v":0},{"$f":"ROUND(SUM(E40+F40),2)+ROUND(SUM(M40+N40+P40+Q40)*G40,2)","v":0},{"$f":"ROUND(SUM(H40+I40),2)+ROUND(SUM(M40+N40+P40+Q40)*J40,2)","v":0},{"$f":"K40+ROUND(SUM(M40+N40+P40+Q40)*L40,2)","v":0}]
[29,"JUNE / \n2ND QUARTER","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D38:D39)","v":40},0,0,{"$f":"IF((E41+F41)<=0,0,SUM(E41+F41)/SUM(E41+F41+H41+I41+K41))","v":0},0,0,{"$f":"IF((H41+I41)<=0,0,SUM(H41+I41)/SUM(E41+F41+H41+I41+K41))","v":0},0,{"$f":"IF(K41<=0,0,K41/SUM(E41+F41+H41+I41+K41))","v":0},0,0,{"$f":"SUM(E41+F41+H41+I41+M41+N41+K41)","v":0},0,0,{"$f":"SUM(O41:Q41)","v":0},{"$f":"IF(G41=0,0,IF((M41+N41+P41+Q41)*G41+(E41+F41)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,35)*G41),((M41+N41+P41+Q41)*G41+(E41+F41)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,35)*G41)))","v":0},{"$f":"R41-U41-S41","v":0},{"$f":"K41+ROUND(SUM(M41+N41+P41+Q41)*L41,2)","v":0}]
[30,"JUNE TOTAL",null,null,{"$f":"SUM(E38:E41)","v":131290.19},{"$f":"SUM(F38:F41)","v":10597.45},null,{"$f":"SUM(H38:H41)","v":1547.59},{"$f":"SUM(I38:I41)","v":179.5},null,{"$f":"SUM(K38:K41)","v":1522.67},null,{"$f":"SUM(M38:M41)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[31,"JULY","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E43+E44)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E43+F43)<=0,0,SUM(E43+F43)/SUM(E43+F43+H43+I43+K43))","v":1},0,0,{"$f":"IF((H43+I43)<=0,0,SUM(H43+I43)/SUM(E43+F43+H43+I43+K43))","v":0},0,{"$f":"IF(K43<=0,0,K43/SUM(E43+F43+H43+I43+K43))","v":0},10437.06,0,{"$f":"SUM(E43+F43+H43+I43+M43+N43+K43)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O43:Q43)","v":163834.91000000003},{"$f":"ROUND(SUM(E43+F43),2)+ROUND(SUM(M43+N43+P43+Q43)*G43,2)","v":163834.91},0,{"$f":"K43+ROUND(SUM(M43+N43+P43+Q43)*L43,2)","v":0}]
[32,"JULY","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E44+F44)<=0,0,SUM(E44+F44)/SUM(E44+F44+H44+I44+K44))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H44+I44)<=0,0,SUM(H44+I44)/SUM(E44+F44+H44+I44+K44))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K44<=0,0,K44/SUM(E44+F44+H44+I44+K44))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E44+F44+H44+I44+M44+N44+K44)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O44:Q44)","v":23406.68},{"$f":"ROUND(SUM(E44+F44),2)+ROUND(SUM(M44+N44+P44+Q44)*G44,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H44+I44),2)+ROUND(SUM(M44+N44+P44+Q44)*J44,2)","v":1989.1599999999999},{"$f":"K44+ROUND(SUM(M44+N44+P44+Q44)*L44,2)","v":1753.72}]
[33,"JULY","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E45+F45)<=0,0,SUM(E45+F45)/SUM(E45+F45+H45+I45+K45))","v":0},0,0,{"$f":"IF((H45+I45)<=0,0,SUM(H45+I45)/SUM(E45+F45+H45+I45+K45))","v":0},0,{"$f":"IF(K45<=0,0,K45/SUM(E45+F45+H45+I45+K45))","v":0},0,0,{"$f":"SUM(E45+F45+H45+I45+M45+N45+K45)","v":0},0,0,{"$f":"SUM(O45:Q45)","v":0},{"$f":"ROUND(SUM(E45+F45),2)+ROUND(SUM(M45+N45+P45+Q45)*G45,2)","v":0},{"$f":"ROUND(SUM(H45+I45),2)+ROUND(SUM(M45+N45+P45+Q45)*J45,2)","v":0},{"$f":"K45+ROUND(SUM(M45+N45+P45+Q45)*L45,2)","v":0}]
[34,"JULY","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D43:D44)","v":40},0,0,{"$f":"IF((E46+F46)<=0,0,SUM(E46+F46)/SUM(E46+F46+H46+I46+K46))","v":0},0,0,{"$f":"IF((H46+I46)<=0,0,SUM(H46+I46)/SUM(E46+F46+H46+I46+K46))","v":0},0,{"$f":"IF(K46<=0,0,K46/SUM(E46+F46+H46+I46+K46))","v":0},0,0,{"$f":"SUM(E46+F46+H46+I46+M46+N46+K46)","v":0},0,0,{"$f":"SUM(O46:Q46)","v":0},{"$f":"IF(G46=0,0,IF((M46+N46+P46+Q46)*G46+(E46+F46)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,39)*G46),((M46+N46+P46+Q46)*G46+(E46+F46)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,39)*G46)))","v":0},{"$f":"R46-U46-S46","v":0},{"$f":"K46+ROUND(SUM(M46+N46+P46+Q46)*L46,2)","v":0}]
[35,"JULY TOTAL",null,null,{"$f":"SUM(E43:E46)","v":131290.19},{"$f":"SUM(F43:F46)","v":10597.45},null,{"$f":"SUM(H43:H46)","v":1547.59},{"$f":"SUM(I43:I46)","v":179.5},null,{"$f":"SUM(K43:K46)","v":1522.67},null,{"$f":"SUM(M43:M46)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[36,"AUGUST","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E48+E49)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E48+F48)<=0,0,SUM(E48+F48)/SUM(E48+F48+H48+I48+K48))","v":1},0,0,{"$f":"IF((H48+I48)<=0,0,SUM(H48+I48)/SUM(E48+F48+H48+I48+K48))","v":0},0,{"$f":"IF(K48<=0,0,K48/SUM(E48+F48+H48+I48+K48))","v":0},10437.06,0,{"$f":"SUM(E48+F48+H48+I48+M48+N48+K48)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O48:Q48)","v":163834.91000000003},{"$f":"ROUND(SUM(E48+F48),2)+ROUND(SUM(M48+N48+P48+Q48)*G48,2)","v":163834.91},0,{"$f":"K48+ROUND(SUM(M48+N48+P48+Q48)*L48,2)","v":0}]
[37,"AUGUST","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E49+F49)<=0,0,SUM(E49+F49)/SUM(E49+F49+H49+I49+K49))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H49+I49)<=0,0,SUM(H49+I49)/SUM(E49+F49+H49+I49+K49))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K49<=0,0,K49/SUM(E49+F49+H49+I49+K49))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E49+F49+H49+I49+M49+N49+K49)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O49:Q49)","v":23406.68},{"$f":"ROUND(SUM(E49+F49),2)+ROUND(SUM(M49+N49+P49+Q49)*G49,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H49+I49),2)+ROUND(SUM(M49+N49+P49+Q49)*J49,2)","v":1989.1599999999999},{"$f":"K49+ROUND(SUM(M49+N49+P49+Q49)*L49,2)","v":1753.72}]
[38,"AUGUST","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E50+F50)<=0,0,SUM(E50+F50)/SUM(E50+F50+H50+I50+K50))","v":0},0,0,{"$f":"IF((H50+I50)<=0,0,SUM(H50+I50)/SUM(E50+F50+H50+I50+K50))","v":0},0,{"$f":"IF(K50<=0,0,K50/SUM(E50+F50+H50+I50+K50))","v":0},0,0,{"$f":"SUM(E50+F50+H50+I50+M50+N50+K50)","v":0},0,0,{"$f":"SUM(O50:Q50)","v":0},{"$f":"ROUND(SUM(E50+F50),2)+ROUND(SUM(M50+N50+P50+Q50)*G50,2)","v":0},{"$f":"ROUND(SUM(H50+I50),2)+ROUND(SUM(M50+N50+P50+Q50)*J50,2)","v":0},{"$f":"K50+ROUND(SUM(M50+N50+P50+Q50)*L50,2)","v":0}]
[39,"AUGUST","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D48:D49)","v":40},0,0,{"$f":"IF((E51+F51)<=0,0,SUM(E51+F51)/SUM(E51+F51+H51+I51+K51))","v":0},0,0,{"$f":"IF((H51+I51)<=0,0,SUM(H51+I51)/SUM(E51+F51+H51+I51+K51))","v":0},0,{"$f":"IF(K51<=0,0,K51/SUM(E51+F51+H51+I51+K51))","v":0},0,0,{"$f":"SUM(E51+F51+H51+I51+M51+N51+K51)","v":0},0,0,{"$f":"SUM(O51:Q51)","v":0},{"$f":"IF(G51=0,0,IF((M51+N51+P51+Q51)*G51+(E51+F51)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,43)*G51),((M51+N51+P51+Q51)*G51+(E51+F51)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,43)*G51)))","v":0},{"$f":"R51-U51-S51","v":0},{"$f":"K51+ROUND(SUM(M51+N51+P51+Q51)*L51,2)","v":0}]
[40,"AUGUST TOTAL",null,null,{"$f":"SUM(E48:E51)","v":131290.19},{"$f":"SUM(F48:F51)","v":10597.45},null,{"$f":"SUM(H48:H51)","v":1547.59},{"$f":"SUM(I48:I51)","v":179.5},null,{"$f":"SUM(K48:K51)","v":1522.67},null,{"$f":"SUM(M48:M51)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[41,"SEPTEMBER / 3RD QUARTER","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E53+E54)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E53+F53)<=0,0,SUM(E53+F53)/SUM(E53+F53+H53+I53+K53))","v":1},0,0,{"$f":"IF((H53+I53)<=0,0,SUM(H53+I53)/SUM(E53+F53+H53+I53+K53))","v":0},0,{"$f":"IF(K53<=0,0,K53/SUM(E53+F53+H53+I53+K53))","v":0},10437.06,0,{"$f":"SUM(E53+F53+H53+I53+M53+N53+K53)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O53:Q53)","v":163834.91000000003},{"$f":"ROUND(SUM(E53+F53),2)+ROUND(SUM(M53+N53+P53+Q53)*G53,2)","v":163834.91},0,{"$f":"K53+ROUND(SUM(M53+N53+P53+Q53)*L53,2)","v":0}]
[42,"SEPTEMBER / 3RD QUARTER","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E54+F54)<=0,0,SUM(E54+F54)/SUM(E54+F54+H54+I54+K54))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H54+I54)<=0,0,SUM(H54+I54)/SUM(E54+F54+H54+I54+K54))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K54<=0,0,K54/SUM(E54+F54+H54+I54+K54))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E54+F54+H54+I54+M54+N54+K54)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O54:Q54)","v":23406.68},{"$f":"ROUND(SUM(E54+F54),2)+ROUND(SUM(M54+N54+P54+Q54)*G54,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H54+I54),2)+ROUND(SUM(M54+N54+P54+Q54)*J54,2)","v":1989.1599999999999},{"$f":"K54+ROUND(SUM(M54+N54+P54+Q54)*L54,2)","v":1753.72}]
[43,"SEPTEMBER / 3RD QUARTER","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E55+F55)<=0,0,SUM(E55+F55)/SUM(E55+F55+H55+I55+K55))","v":0},0,0,{"$f":"IF((H55+I55)<=0,0,SUM(H55+I55)/SUM(E55+F55+H55+I55+K55))","v":0},0,{"$f":"IF(K55<=0,0,K55/SUM(E55+F55+H55+I55+K55))","v":0},0,0,{"$f":"SUM(E55+F55+H55+I55+M55+N55+K55)","v":0},0,0,{"$f":"SUM(O55:Q55)","v":0},{"$f":"ROUND(SUM(E55+F55),2)+ROUND(SUM(M55+N55+P55+Q55)*G55,2)","v":0},{"$f":"ROUND(SUM(H55+I55),2)+ROUND(SUM(M55+N55+P55+Q55)*J55,2)","v":0},{"$f":"K55+ROUND(SUM(M55+N55+P55+Q55)*L55,2)","v":0}]
[44,"SEPTEMBER / 3RD QUARTER","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D53:D54)","v":40},0,0,{"$f":"IF((E56+F56)<=0,0,SUM(E56+F56)/SUM(E56+F56+H56+I56+K56))","v":0},0,0,{"$f":"IF((H56+I56)<=0,0,SUM(H56+I56)/SUM(E56+F56+H56+I56+K56))","v":0},0,{"$f":"IF(K56<=0,0,K56/SUM(E56+F56+H56+I56+K56))","v":0},0,0,{"$f":"SUM(E56+F56+H56+I56+M56+N56+K56)","v":0},0,0,{"$f":"SUM(O56:Q56)","v":0},{"$f":"IF(G56=0,0,IF((M56+N56+P56+Q56)*G56+(E56+F56)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,47)*G56),((M56+N56+P56+Q56)*G56+(E56+F56)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,47)*G56)))","v":0},{"$f":"R56-U56-S56","v":0},{"$f":"K56+ROUND(SUM(M56+N56+P56+Q56)*L56,2)","v":0}]
[45,"SEPTEMBER TOTAL",null,null,{"$f":"SUM(E53:E56)","v":131290.19},{"$f":"SUM(F53:F56)","v":10597.45},null,{"$f":"SUM(H53:H56)","v":1547.59},{"$f":"SUM(I53:I56)","v":179.5},null,{"$f":"SUM(K53:K56)","v":1522.67},null,{"$f":"SUM(M53:M56)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[46,"OCTOBER","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E58+E59)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E58+F58)<=0,0,SUM(E58+F58)/SUM(E58+F58+H58+I58+K58))","v":1},0,0,{"$f":"IF((H58+I58)<=0,0,SUM(H58+I58)/SUM(E58+F58+H58+I58+K58))","v":0},0,{"$f":"IF(K58<=0,0,K58/SUM(E58+F58+H58+I58+K58))","v":0},10437.06,0,{"$f":"SUM(E58+F58+H58+I58+M58+N58+K58)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O58:Q58)","v":163834.91000000003},{"$f":"ROUND(SUM(E58+F58),2)+ROUND(SUM(M58+N58+P58+Q58)*G58,2)","v":163834.91},0,{"$f":"K58+ROUND(SUM(M58+N58+P58+Q58)*L58,2)","v":0}]
[47,"OCTOBER","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E59+F59)<=0,0,SUM(E59+F59)/SUM(E59+F59+H59+I59+K59))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H59+I59)<=0,0,SUM(H59+I59)/SUM(E59+F59+H59+I59+K59))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K59<=0,0,K59/SUM(E59+F59+H59+I59+K59))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E59+F59+H59+I59+M59+N59+K59)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O59:Q59)","v":23406.68},{"$f":"ROUND(SUM(E59+F59),2)+ROUND(SUM(M59+N59+P59+Q59)*G59,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H59+I59),2)+ROUND(SUM(M59+N59+P59+Q59)*J59,2)","v":1989.1599999999999},{"$f":"K59+ROUND(SUM(M59+N59+P59+Q59)*L59,2)","v":1753.72}]
[48,"OCTOBER","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E60+F60)<=0,0,SUM(E60+F60)/SUM(E60+F60+H60+I60+K60))","v":0},0,0,{"$f":"IF((H60+I60)<=0,0,SUM(H60+I60)/SUM(E60+F60+H60+I60+K60))","v":0},0,{"$f":"IF(K60<=0,0,K60/SUM(E60+F60+H60+I60+K60))","v":0},0,0,{"$f":"SUM(E60+F60+H60+I60+M60+N60+K60)","v":0},0,0,{"$f":"SUM(O60:Q60)","v":0},{"$f":"ROUND(SUM(E60+F60),2)+ROUND(SUM(M60+N60+P60+Q60)*G60,2)","v":0},{"$f":"ROUND(SUM(H60+I60),2)+ROUND(SUM(M60+N60+P60+Q60)*J60,2)","v":0},{"$f":"K60+ROUND(SUM(M60+N60+P60+Q60)*L60,2)","v":0}]
[49,"OCTOBER","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D58:D59)","v":40},0,0,{"$f":"IF((E61+F61)<=0,0,SUM(E61+F61)/SUM(E61+F61+H61+I61+K61))","v":0},0,0,{"$f":"IF((H61+I61)<=0,0,SUM(H61+I61)/SUM(E61+F61+H61+I61+K61))","v":0},0,{"$f":"IF(K61<=0,0,K61/SUM(E61+F61+H61+I61+K61))","v":0},0,0,{"$f":"SUM(E61+F61+H61+I61+M61+N61+K61)","v":0},0,0,{"$f":"SUM(O61:Q61)","v":0},{"$f":"IF(G61=0,0,IF((M61+N61+P61+Q61)*G61+(E61+F61)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,51)*G61),((M61+N61+P61+Q61)*G61+(E61+F61)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,51)*G61)))","v":0},{"$f":"R61-U61-S61","v":0},{"$f":"K61+ROUND(SUM(M61+N61+P61+Q61)*L61,2)","v":0}]
[50,"OCTOBER TOTAL",null,null,{"$f":"SUM(E58:E61)","v":131290.19},{"$f":"SUM(F58:F61)","v":10597.45},null,{"$f":"SUM(H58:H61)","v":1547.59},{"$f":"SUM(I58:I61)","v":179.5},null,{"$f":"SUM(K58:K61)","v":1522.67},null,{"$f":"SUM(M58:M61)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[51,"NOVEMBER","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E63+E64)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E63+F63)<=0,0,SUM(E63+F63)/SUM(E63+F63+H63+I63+K63))","v":1},0,0,{"$f":"IF((H63+I63)<=0,0,SUM(H63+I63)/SUM(E63+F63+H63+I63+K63))","v":0},0,{"$f":"IF(K63<=0,0,K63/SUM(E63+F63+H63+I63+K63))","v":0},10437.06,0,{"$f":"SUM(E63+F63+H63+I63+M63+N63+K63)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O63:Q63)","v":163834.91000000003},{"$f":"ROUND(SUM(E63+F63),2)+ROUND(SUM(M63+N63+P63+Q63)*G63,2)","v":163834.91},0,{"$f":"K63+ROUND(SUM(M63+N63+P63+Q63)*L63,2)","v":0}]
[52,"NOVEMBER","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E64+F64)<=0,0,SUM(E64+F64)/SUM(E64+F64+H64+I64+K64))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H64+I64)<=0,0,SUM(H64+I64)/SUM(E64+F64+H64+I64+K64))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K64<=0,0,K64/SUM(E64+F64+H64+I64+K64))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E64+F64+H64+I64+M64+N64+K64)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O64:Q64)","v":23406.68},{"$f":"ROUND(SUM(E64+F64),2)+ROUND(SUM(M64+N64+P64+Q64)*G64,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H64+I64),2)+ROUND(SUM(M64+N64+P64+Q64)*J64,2)","v":1989.1599999999999},{"$f":"K64+ROUND(SUM(M64+N64+P64+Q64)*L64,2)","v":1753.72}]
[53,"NOVEMBER","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E65+F65)<=0,0,SUM(E65+F65)/SUM(E65+F65+H65+I65+K65))","v":0},0,0,{"$f":"IF((H65+I65)<=0,0,SUM(H65+I65)/SUM(E65+F65+H65+I65+K65))","v":0},0,{"$f":"IF(K65<=0,0,K65/SUM(E65+F65+H65+I65+K65))","v":0},0,0,{"$f":"SUM(E65+F65+H65+I65+M65+N65+K65)","v":0},0,0,{"$f":"SUM(O65:Q65)","v":0},{"$f":"ROUND(SUM(E65+F65),2)+ROUND(SUM(M65+N65+P65+Q65)*G65,2)","v":0},{"$f":"ROUND(SUM(H65+I65),2)+ROUND(SUM(M65+N65+P65+Q65)*J65,2)","v":0},{"$f":"K65+ROUND(SUM(M65+N65+P65+Q65)*L65,2)","v":0}]
[54,"NOVEMBER","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D63:D64)","v":40},0,0,{"$f":"IF((E66+F66)<=0,0,SUM(E66+F66)/SUM(E66+F66+H66+I66+K66))","v":0},0,0,{"$f":"IF((H66+I66)<=0,0,SUM(H66+I66)/SUM(E66+F66+H66+I66+K66))","v":0},0,{"$f":"IF(K66<=0,0,K66/SUM(E66+F66+H66+I66+K66))","v":0},0,0,{"$f":"SUM(E66+F66+H66+I66+M66+N66+K66)","v":0},0,0,{"$f":"SUM(O66:Q66)","v":0},{"$f":"IF(G66=0,0,IF((M66+N66+P66+Q66)*G66+(E66+F66)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,55)*G66),((M66+N66+P66+Q66)*G66+(E66+F66)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,55)*G66)))","v":0},{"$f":"R66-U66-S66","v":0},{"$f":"K66+ROUND(SUM(M66+N66+P66+Q66)*L66,2)","v":0}]
[55,"NOVEMBER TOTAL",null,null,{"$f":"SUM(E63:E66)","v":131290.19},{"$f":"SUM(F63:F66)","v":10597.45},null,{"$f":"SUM(H63:H66)","v":1547.59},{"$f":"SUM(I63:I66)","v":179.5},null,{"$f":"SUM(K63:K66)","v":1522.67},null,{"$f":"SUM(M63:M66)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[56,"DECEMBER / 4TH QUARTER","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN((E68+E69)/VLOOKUP('Administrator Regression Table'!$P$1,'Administrator Regression Table'!$M$1:$N$9,2),0)","v":40},114217.06,10597.45,{"$f":"IF((E68+F68)<=0,0,SUM(E68+F68)/SUM(E68+F68+H68+I68+K68))","v":1},0,0,{"$f":"IF((H68+I68)<=0,0,SUM(H68+I68)/SUM(E68+F68+H68+I68+K68))","v":0},0,{"$f":"IF(K68<=0,0,K68/SUM(E68+F68+H68+I68+K68))","v":0},10437.06,0,{"$f":"SUM(E68+F68+H68+I68+M68+N68+K68)","v":135251.57},23217.83,5365.51,{"$f":"SUM(O68:Q68)","v":163834.91000000003},{"$f":"ROUND(SUM(E68+F68),2)+ROUND(SUM(M68+N68+P68+Q68)*G68,2)","v":163834.91},0,{"$f":"K68+ROUND(SUM(M68+N68+P68+Q68)*L68,2)","v":0}]
[57,"DECEMBER / 4TH QUARTER","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,17073.13,0,{"$f":"IF((E69+F69)<=0,0,SUM(E69+F69)/SUM(E69+F69+H69+I69+K69))","v":0.84009360873379724},1547.59,179.5,{"$f":"IF((H69+I69)<=0,0,SUM(H69+I69)/SUM(E69+F69+H69+I69+K69))","v":8.4982500028293217E-2},1522.67,{"$f":"IF(K69<=0,0,K69/SUM(E69+F69+H69+I69+K69))","v":7.4923891237909573E-2},818.37,0,{"$f":"SUM(E69+F69+H69+I69+M69+N69+K69)","v":21141.260000000002},1788.48,476.94,{"$f":"SUM(O69:Q69)","v":23406.68},{"$f":"ROUND(SUM(E69+F69),2)+ROUND(SUM(M69+N69+P69+Q69)*G69,2)","v":19663.800000000003},{"$f":"ROUND(SUM(H69+I69),2)+ROUND(SUM(M69+N69+P69+Q69)*J69,2)","v":1989.1599999999999},{"$f":"K69+ROUND(SUM(M69+N69+P69+Q69)*L69,2)","v":1753.72}]
[58,"DECEMBER / 4TH QUARTER","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E70+F70)<=0,0,SUM(E70+F70)/SUM(E70+F70+H70+I70+K70))","v":0},0,0,{"$f":"IF((H70+I70)<=0,0,SUM(H70+I70)/SUM(E70+F70+H70+I70+K70))","v":0},0,{"$f":"IF(K70<=0,0,K70/SUM(E70+F70+H70+I70+K70))","v":0},0,0,{"$f":"SUM(E70+F70+H70+I70+M70+N70+K70)","v":0},0,0,{"$f":"SUM(O70:Q70)","v":0},{"$f":"ROUND(SUM(E70+F70),2)+ROUND(SUM(M70+N70+P70+Q70)*G70,2)","v":0},{"$f":"ROUND(SUM(H70+I70),2)+ROUND(SUM(M70+N70+P70+Q70)*J70,2)","v":0},{"$f":"K70+ROUND(SUM(M70+N70+P70+Q70)*L70,2)","v":0}]
[59,"DECEMBER / 4TH QUARTER","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D68:D69)","v":40},0,0,{"$f":"IF((E71+F71)<=0,0,SUM(E71+F71)/SUM(E71+F71+H71+I71+K71))","v":0},0,0,{"$f":"IF((H71+I71)<=0,0,SUM(H71+I71)/SUM(E71+F71+H71+I71+K71))","v":0},0,{"$f":"IF(K71<=0,0,K71/SUM(E71+F71+H71+I71+K71))","v":0},0,0,{"$f":"SUM(E71+F71+H71+I71+M71+N71+K71)","v":0},0,0,{"$f":"SUM(O71:Q71)","v":0},{"$f":"IF(G71=0,0,IF((M71+N71+P71+Q71)*G71+(E71+F71)<(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,59)*G71),((M71+N71+P71+Q71)*G71+(E71+F71)),(HLOOKUP('Administrator Regression Table'!$Q$1,'Administrator Regression Table'!$R$1:$U$63,59)*G71)))","v":0},{"$f":"R71-U71-S71","v":0},{"$f":"K71+ROUND(SUM(M71+N71+P71+Q71)*L71,2)","v":0}]
[60,"DECEMBER TOTAL",null,null,{"$f":"SUM(E68:E71)","v":131290.19},{"$f":"SUM(F68:F71)","v":10597.45},null,{"$f":"SUM(H68:H71)","v":1547.59},{"$f":"SUM(I68:I71)","v":179.5},null,{"$f":"SUM(K68:K71)","v":1522.67},null,{"$f":"SUM(M68:M71)","v":11255.43},0,156392.83000000002,25006.31,5842.45,187241.59000000003,183498.71000000002,1989.1599999999999,1753.72]
[61,"ANNUAL TOTALS","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN(IF(B10=\"Quarterly\",SUM(D23+D38+D53+D68)/12,SUM(D13+D18+D23+D28+D33+D38+D43+D48+D53+D58+D63+D68)/12),0)","v":40},{"$f":"SUM(E13+E18+E23+E28+E33+E38+E43+E48+E53+E58+E63+E68)","v":1370604.7200000004},127169.39999999998,{"$f":"IF((E73+F73)<=0,0,SUM(E73+F73)/SUM(E73+F73+H73+I73+K73))","v":1},{"$f":"SUM(H13+H18+H23+H28+H33+H38+H43+H48+H53+H58+H63+H68)","v":0},0,{"$f":"IF((H73+I73)<=0,0,SUM(H73+I73)/SUM(E73+F73+H73+I73+K73))","v":0},{"$f":"SUM(K13+K18+K23+K28+K33+K38+K43+K48+K53+K58+K63+K68)","v":0},{"$f":"IF(K73<=0,0,K73/SUM(E73+F73+H73+I73+K73))","v":0},{"$f":"SUM(M13+M18+M23+M28+M33+M38+M43+M48+M53+M58+M63+M68)","v":125244.71999999999},0,{"$f":"SUM(E73+F73+H73+I73+M73+N73+K73)","v":1623018.8400000003},{"$f":"SUM(P13+P18+P23+P28+P33+P38+P43+P48+P53+P58+P63+P68)","v":278613.96000000008},64386.120000000017,{"$f":"SUM(O73:Q73)","v":1966018.9200000004},{"$f":"SUM(S13+S18+S23+S28+S33+S38+S43+S48+S53+S58+S63+S68)","v":1966018.9199999997},0,0]
[62,"ANNUAL TOTALS","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,204877.56000000003,0,{"$f":"IF((E74+F74)<=0,0,SUM(E74+F74)/SUM(E74+F74+H74+I74+K74))","v":0.84009360873379724},18750.579999999998,1974.5,{"$f":"IF((H74+I74)<=0,0,SUM(H74+I74)/SUM(E74+F74+H74+I74+K74))","v":8.4982500028293204E-2},{"$f":"SUM(K14+K19+K24+K29+K34+K39+K44+K49+K54+K59+K64+K69)","v":18272.04},{"$f":"IF(K74<=0,0,K74/SUM(E74+F74+H74+I74+K74))","v":7.492389123790956E-2},9820.44,0,{"$f":"SUM(E74+F74+H74+I74+M74+N74+K74)","v":253695.12000000002},21461.759999999998,5723.2799999999988,{"$f":"SUM(O74:Q74)","v":280880.16000000003},235965.59999999998,23869.919999999998,21044.639999999999]
[63,"ANNUAL TOTALS","GH ONLY - ADMINISTRATOR PAYROLL",null,0,0,{"$f":"IF((E75+F75)<=0,0,SUM(E75+F75)/SUM(E75+F75+H75+I75+K75))","v":0},0,0,{"$f":"IF((H75+I75)<=0,0,SUM(H75+I75)/SUM(E75+F75+H75+I75+K75))","v":0},{"$f":"SUM(K15+K20+K25+K30+K35+K40+K45+K50+K55+K60+K65+K70)","v":0},{"$f":"IF(K75<=0,0,K75/SUM(E75+F75+H75+I75+K75))","v":0},0,0,{"$f":"SUM(E75+F75+H75+I75+M75+N75+K75)","v":0},0,0,{"$f":"SUM(O75:Q75)","v":0},{"$f":"SUM(S15+S20+S25+S30+S35+S40+S45+S50+S55+S60+S65+S70)","v":0},0,0]
[64,"ANNUAL TOTALS","ADMINISTRATOR ISS PAYROLL FOR SL & COMBINED SL/GH AGENCIES WITH 20 OR FEWER ISS FTE'S",{"$f":"SUM(D73:D74)","v":40},0,0,{"$f":"IF((E76+F76)<=0,0,SUM(E76+F76)/SUM(E76+F76+H76+I76+K76))","v":0},0,0,{"$f":"IF((H76+I76)<=0,0,SUM(H76+I76)/SUM(E76+F76+H76+I76+K76))","v":0},{"$f":"SUM(K16+K21+K26+K31+K36+K41+K46+K51+K56+K61+K66+K71)","v":0},{"$f":"IF(K76<=0,0,K76/SUM(E76+F76+H76+I76+K76))","v":0},0,0,{"$f":"SUM(E76+F76+H76+I76+M76+N76+K76)","v":0},0,0,{"$f":"SUM(O76:Q76)","v":0},0,0,0]
[65,"ANNUAL TOTALS",null,null,{"$f":"SUM(E73:E76)","v":1575482.2800000005},{"$f":"SUM(F73:F76)","v":127169.39999999998},{"$f":"IF((E77+F77)<=0,0,SUM(E77+F77)/SUM(E77+F77+H77+I77+K77))","v":0.97760907939648911},{"$f":"SUM(H73:H76)","v":18750.579999999998},{"$f":"SUM(I73:I76)","v":1974.5},{"$f":"IF((H77+I77)<=0,0,SUM(H77+I77)/SUM(E77+F77+H77+I77+K77))","v":1.1899689535571117E-2},{"$f":"SUM(K73:K76)","v":18272.04},{"$f":"IF(K77<=0,0,K77/SUM(E77+F77+H77+I77+K77))","v":1.0491231067939756E-2},{"$f":"SUM(M73:M76)","v":135065.15999999997},0,1876713.9600000004,300075.72000000009,70109.400000000023,2246899.0800000005,2201984.5199999996,23869.919999999998,21044.639999999999]
[null,null,null,null,null,"Posts to Sch G,\nLine 25",null,null,null,null,null,null,null,null,null,null,null,null,"Posts to Sch G, Line 24 \n(less OT-see E65)","DO NOT INCLUDE ON SCHEDULE C"]
[]
[null,"DSHS/DDA Schedule B (Rev. 12/2019)"]

{"sheet":"C - Non-ISS Expenses","index":7,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[24,4,26,4],[0,1,0,8],[28,2,28,3],[20,3,20,7],[15,3,15,5],[17,3,17,5],[19,3,19,5],[24,1,26,3],[2,6,2,8],[21,2,21,7],[9,2,9,6],[24,7,24,8],[25,7,26,8],[25,6,26,6],[25,5,26,5],[32,2,32,3],[27,1,27,3],[28,7,28,8],[30,7,30,8],[27,7,27,8],[30,2,30,3],[32,7,32,8],[29,2,29,8],[31,2,31,8],[43,1,43,3],[36,1,36,3],[34,2,34,3],[39,7,39,8],[37,2,37,3],[41,7,41,8],[43,7,43,8],[34,7,34,8],[36,7,36,8],[37,7,37,8],[39,2,39,3],[41,2,41,3],[33,2,33,8],[35,2,35,8],[38,2,38,8],[40,2,40,8],[42,2,42,8]]}
[null,"SCHEDULE C"]
[]
[null,null,null,null,null,null,{"$f":"_M000001","v":"3S - ABC Residential Services"}]
[null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[]
[null,1,"ARE PROFESSIONAL SERVICES CONTRACTED OR PURCHASED FOR CLIENTS SUPPORTED BY THE AGENCY?",null,null,null,null,"Yes"]
[null,null,"If Yes, include the cost of purchased professional services for settled programs on Schedule G, line 29-31. Professional Services Staff are Contracted or purchased professional services must be authorized in the client assessment. Provider must have supporting documentation for amounts reported and made available upon request."]
[]
[]
[]
[null,2,"ALLOCATION OF SHARED COSTS"]
[]
[null,null,"a","Does your agency operate multiple programs contracted with DDA, e.g., Supported Living and Group Homes, or a combination of DDA and other contracts?  ",null,null,null,"Yes"]
[]
[null,null,"b","If yes to question 2a, do you allocate administrative and program overhead costs?",null,null,null,"Yes"]
[]
[null,null,"c","What is your agency's method of allocating costs? ",null,null,null,"Other Method - Please describe"]
[null,null,null,"*If you answered \"Other Method\" for question 2c please describe your agencies allocation method in the box below:"]
[null,null,"Agency uses direct care hours for allocation purposes."]
[]
[]
[null,"ADMINISTRATIVE & OPERATIONS COSTS \n(NON-ISS COSTS)",null,null,"AGENCY TYPE (Select from dropdown list)","A","B","C"]
[null,null,null,null,null,"SL Supported Living","GH Group Home","GTH Group Training Home"]
[]
[null,"NON-CLIENT RELATED EXPENSES"]
[null,1,"ADMINISTRATIVE/ NON-ISS PAYROLL EXPENSES (Do not include adminstrative payroll expenses reported on Schedule B, Columns G & H) ",null,{"$f":"SUM(F29:H29)","v":174201.30499999999},{"$f":"7227+18122.56+29432+66478.82+8577.91-0.005","v":129838.285},{"$f":"10083.21+1301.06+2748.75+23216+7014-_C000280","v":31108.259999999995},13254.76]
[null,null,"Adminstrator compensation for agencies with 21 or more FTE's, Administrative/Non-ISS staff compensation, Employer Paid Adminstrative/Non-ISS Payroll Taxes & Benefits, Administrative/Non-ISS Purchased Professional Services (i.e. CPA, Janitorial Svs, Lawn Svs), & Management Fees"]
[null,2,"PROGRAM OPERATIONS EXPENSES",null,{"$f":"SUM(F31:H31)","v":31594.99},{"$f":"4717.85+2744.93+2144.48+5575.64+6433.43+2750+2500+500","v":27366.33},{"$f":"715.58+416.34+325.26+845.69+975.79+750+200-H31","v":3241.12},987.54]
[null,null,"Administrative Supplies, Administrative Transportation Expenses (i.e. travel, mileage, lodging, public transportation), Advertising Expense, Professional Liability Insurance, & any other General Administrative Expenses"]
[null,3,"CAPITAL & PROPERTY EXPENSES",null,{"$f":"SUM(F33:H33)","v":87386.349999999991},{"$f":"686.23+4717.85+24018.15+4460.51+3602.72+3002.27+3002.27+1750+500+1200+2000","v":48940},{"$f":"104.08+715.58+3642.96+676.55+546.44+455.37+455.37+11450+800+800+2500+6800+4500+2800+2200-H33","v":25116.37},13329.98]
[null,null,"Depreciation - Land Improvements, Buildings, Building Improvements, Leasehold Improvements, Furniture & Equipment, Communications Expense, Facility Insurance, Office Rent, Lease Payments, Utilities, Property Taxes, Minor Equipment, Other Property"]
[null,4,"INTEREST & TAX EXPENSES",null,{"$f":"SUM(F35:H35)","v":8806.8799999999992},{"$f":"1818.52+3860.06+2200","v":7878.58},{"$f":"275.82+585.48+67-H35","v":680.64},247.66]
[null,null,"Working Capital, Property, Line of Credit Debt Expense, Business Taxes (Does not include portion of B & O tax charged as ISS Payroll Tax)"]
[null,"NON-ISS CLIENT RELATED EXPENSES"]
[null,5,"MAINTENANCE/ LAUNDRY/ HOUSEKEEPING/ DIETARY EXPENSES (GROUP HOME ONLY)",null,{"$f":"SUM(F38:H38)","v":36563.049999999996},15731.98,19065.73,1765.34]
[null,null,"Salaries and Wages, Fringe Benefits and Payroll Taxes, Supplies & Materials, Purchased Services"]
[null,6,"TRANSPORTATION EXPENSES",null,{"$f":"SUM(F40:H40)","v":29918.68},{"$f":"9264.15","v":9264.15},17500.14,3154.39]
[null,null,"Staff Mileage Reimbursement, All Other Client Transportation Expense (Agency Vehicle Fuel, Maint., Depreciation; Public Trans. Etc.)"]
[null,7,"OTHER NON-ISS CLIENT RELATED EXPENSES",null,{"$f":"SUM(F42:H42)","v":77292.714999999997},48041.364999999998,23814.59,5436.76]
[null,null,"Overnight Staff Coverage Lodging Expenses (housing units provided for on-duty staff - not primary dwelling for staff), Education and In-Service Training & Supplies, Activities and Habilitative Supplies & Other Expenses, Nursing Supplies Expense, Food  Costs - Resident (Group Homes primarily), Food Costs - Staff"]
[null,"TOTAL NON-ISS PROGRAM EXPENSES",null,null,{"$f":"_C000275+E31+E33+E35+E38+E40+E42","v":445763.97},{"$f":"_C000276+F31+F33+F35+F38+F40+F42","v":287060.69},{"$f":"_C000277+G31+G33+G35+G38+G40+G42","v":120526.84999999999},{"$f":"_C000280+H31+H33+H35+H38+H40+H42","v":38176.43}]
[]
[null,"DSHS/DDA Schedule C (Rev. 12/2019)"]

{"sheet":"D - Revenue","index":8,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[[13,1,13,3],[11,2,11,3],[12,2,12,7],[0,1,0,7],[7,2,7,3],[8,2,8,7],[9,2,9,3],[10,2,10,7],[5,4,6,4],[2,6,2,7],[1,2,1,3],[3,2,3,3],[5,1,6,3]]}
[null,"SCHEDULE D"]
[]
[null,null,null,null,null,null,{"$f":"_M000001","v":"3S - ABC Residential Services"}]
[null,null,null,null,null,null,"PROVIDER NAME"]
[]
[null,"RESIDENTIAL SERVICES REVENUE",null,null,"TOTALS","A","B","C"]
[null,null,null,null,null,{"$f":"'C - Non-ISS Expenses'!_M000101","v":"SL Supported Living"},{"$f":"'C - Non-ISS Expenses'!_M000102","v":"GH Group Home"},{"$f":"'C - Non-ISS Expenses'!_M000105","v":"GTH Group Training Home"}]
[null,1,"REVENUE FOR SERVICES PROVIDED",null,{"$f":"SUM(F8:H8)","v":2689236.31},1622205.64,608645.42000000004,458385.25]
[null,null,"State Payments/Reimbursements for ISS/DSHS Clients (Total Daily Rate), ISS/DSHS Client Participation, Prior Years Settlements Deducted from State Payments, Non DSHS Client Payments"]
[null,2,"OTHER OPERATING REVENUE",null,{"$f":"SUM(F10:H10)","v":19950},15750,2000,2200]
[null,null,"Summer Programs, Client Evaluation, Non-DSHS Revenue"]
[null,3,"NON-OPERATING REVENUE",null,{"$f":"SUM(F12:H12)","v":2232},1032,744,456]
[null,null,"Interest Income, Cash Donations & Contributions, Noncash Donations & Contributions"]
[null,"TOTAL RESIDENTIAL SERVICES REVENUE",null,null,{"$f":"E8+E10+E12","v":2711418.31},{"$f":"F8+F10+F12","v":1638987.64},{"$f":"G8+G10+G12","v":611389.42000000004},{"$f":"H8+H10+H12","v":461041.25}]
[]
[null,"DSHS/DDA Schedule D (Rev. 12/2019)"]

{"sheet":"E - Residential Staffing","index":9,"n_rows":84,"n_cols":14,"rows_kept":84,"cut":false,"hidden":false,"merged":[[72,7,72,8],[70,5,70,6],[71,5,71,6],[72,5,72,6],[72,2,72,4],[70,7,70,8],[71,7,71,8],[70,2,70,4],[71,2,71,4],[17,2,17,3],[18,2,18,3],[19,2,19,3],[32,2,32,11],[26,2,26,11],[29,2,29,11],[36,2,36,11],[67,2,67,4],[68,2,68,4],[66,1,66,8],[41,2,41,11],[42,2,42,11],[43,2,43,11],[39,2,39,11],[51,2,51,7],[37,2,37,11],[38,2,38,11],[68,5,68,6],[44,2,44,11],[49,2,49,7],[50,2,50,7],[48,2,48,7],[0,1,0,13],[6,0,6,14],[12,5,12,10],[13,5,13,10],[40,2,40,11],[2,12,2,13],[3,12,3,13],[7,0,7,14],[13,2,13,4],[12,2,12,4],[23,2,23,11],[24,2,24,11],[25,2,25,11],[35,2,35,11],[33,2,33,11],[16,2,16,3],[82,1,82,13],[81,1,81,13],[75,10,79,13],[75,8,75,9],[75,2,75,5],[78,2,78,5],[79,2,79,5],[76,6,76,7],[76,8,76,9],[77,6,77,7],[77,2,77,5],[76,2,76,5],[69,2,69,4],[56,7,56,10],[57,7,57,10],[67,7,67,8],[68,7,68,8],[69,5,69,6],[69,7,69,8],[67,5,67,6],[56,1,57,2],[74,1,74,9],[83,1,83,13],[16,5,16,10],[17,5,17,10],[18,5,18,10],[19,5,19,10],[22,2,22,10],[75,6,75,7],[55,1,55,13],[34,2,34,11],[77,8,77,9],[78,6,78,7],[78,8,78,9],[79,6,79,7],[79,8,79,9],[47,2,47,7]]}
[null,"SCHEDULE E"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'G - ISS Settlement'!C3","v":"3S - ABC Residential Services"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
["IMPORTANT , PLEASE READ before completing schedule:\nCOMPLETE A SEPARATE SCHEDULE FOR EACH LOCATION BY: PROGRAM TYPE, CITY, AND COUNTY \nFOR ADDITIONAL COPIES OF SCHEDULE E CONTACT YOUR AGENCY'S RATE ANALYST \nReporting Period: January 1, 2019 to December 31, 2019 (One Calendar Year, 12 months, 2019)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
["The schedule(s) will be reviewed by the rate analyst to ensure the Agency is rporting contracts, programs, and locations separately. \nAny cost reports found to be incomplete will be returned to the agency for correction."]
[]
[null,"1. AGENCY INFORMATION:"]
[null,null,"Where are the Services Provided?"]
[]
[null,null,"PROGRAM TYPE",null,null,"PROGRAM NAME",null,null,null,null,null,"CITY","COUNTY"]
[null,null,"SL Supported Living",null,null,"3S - ABC Residential Services",null,null,null,null,null,"Small Town","Clark"]
[]
[null,"2. CONTACT INFORMATION:"]
[null,null,"Name (Person Completing Schedule):",null,null,"John Doe"]
[null,null,"Title (Person Completing Schedule):",null,null,"Human Resources Director"]
[null,null,"Telephone Number:",null,null,"360-555-9876"]
[null,null,"E-Mail Address:",null,null,"jdoe@gmail.com"]
[]
[null,"3. BOARD OF DIRECTORS INFORMATION:  "]
[null,null,"Non-Profit Agencies only, please fill out the following information if you have a Board of Directors or other governing board.  Do not include advisory committees or other non-governing, non-voting boards."]
[null,null,"a) Board of Directors -  Number of Members (total number of positions)?",null,null,null,null,null,null,null,null,null,5]
[null,null,"b)  Board of Directors -Total number of voting board members?",null,null,null,null,null,null,null,null,null,5]
[null,null,"c)  Voting Board Members - How many are people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?",null,null,null,null,null,null,null,null,null,1]
[null,null,"d)  Voting Board Members - How many are family members (parents, siblings, or other relatives) of people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?",null,null,null,null,null,null,null,null,null,0]
[]
[null,"4. CLIENT INFORMATION: "]
[null,null,"Average Monthly Count of Clients supported in this program?  ",null,null,null,null,null,null,null,null,null,23]
[]
[null,"5. EMPLOYEE BENEFITS:"]
[null,null,"In addition to wages, does your agency provide benefits to ISS staff?\nIf Yes, check all that apply",null,null,null,null,null,null,null,null,null," Yes"]
[null,null,"Medical Insurance (paid in whole or in part by agency)",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Dental Insurance (paid in whole or in part by agency)",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Retirement (paid in whole or in part by agency)",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Paid Sick Leave",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Paid Vacation",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Short-Term Disability"]
[null,null,"Long-Term Disability",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Jury Duty Leave",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Bereavement Leave",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Vision Insurance"]
[null,null,"Employee Assistance Plan"]
[null,null,"Life Insurance",null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"6. RECRUITING:"]
[null,null,"\nDifference in recruiting new staff from 1/1/2019 - 12/31/2019?\n(Only check boxes that apply)",null,null,null,null,null,"ENTRY LEVEL","1st LINE SUPERVISOR","PROGRAM MANAGERS","*SPECIALISTS\n (Recreation, behavioral, or staff trainers)","NURSES\n(RN, LPN)"]
[null,null,"Situation is worse than previous year (Harder to recruit)",null,null,null,null,null,"X"]
[null,null,"Some improvement from previous year (Easier to recruit)",null,null,null,null,null,null,"X","X","X"]
[null,null,"Definite improvement from previous year (Much easier to recruit)"]
[null,null,"No difference from previous year",null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"7. STAFFING INFORMATION:"]
[]
[null,"SECTION 1A (TURNOVER)"]
[null,null,null,1,2,3,4,5,null,null,null,6,7,8]
[null,null,null,"Beginning of Year ISS Staffing Level","Current ISS Staffing Level","Full ISS Employment","Number of ISS Staff Hired","Number of ISS staff who left or had their employment terminated:",null,null,null,"Positions Available"]
[null,"Line #","POSITION TYPE","Number of ISS staff (Full-time, Part-time, & Temp combined) on January 1st, 2019","Number of ISS staff (Full-time, Part-time, & Temp combined) on December 31, 2019","Number of ISS staff needed for full employment on December 31st 2019","Number of ISS staff hired during the calander year.","a. Total ISS Staff who left/or had their employment terminated during the Calander Year (Col. 7.1 + Col. 7.4 - Col. 7.2)","b. (Six Months) \nJan 1, 2019 to June 30, 2019","c. (Six Months) \nJuly 1, 2019 to Dec. 31, 2019 (Col. 7.5a - Col. 7.5b)","d. Optional: Within 90 days of hiring date (Calander Year)","Number of vacancies on Dec 31, 2019","ISS Staff Turnover percentage","Average number of days to fill vacant positions (Estimates accepted if unknown)"]
[null,1,"ENTRY LEVEL",42,45,50,15,{"$f":"D60+G60-E60","v":12},12,{"$f":"H60-I60","v":0},5,{"$f":"-E60+F60","v":5},{"$f":"H60/(0.5*(D60+E60))","v":0.27586206896551724},0]
[null,2,"1st LINE SUPERVISORS",15,18,22,3,{"$f":"D61+G61-E61","v":0},0,{"$f":"H61-I61","v":0},1,{"$f":"-E61+F61","v":4},0,0]
[null,3,"PROGRAM MANAGERS",2,2,2,1,{"$f":"D62+G62-E62","v":1},0,{"$f":"H62-I62","v":1},1,{"$f":"-E62+F62","v":0},0.5,0]
[null,4,"*SPECIALISTS \n(recreation, behavioral, or staff trainers, etc.)",20,15,25,2,{"$f":"D63+G63-E63","v":7},5,{"$f":"H63-I63","v":2},2,{"$f":"-E63+F63","v":10},0.4,0]
[null,5,"NURSES (RN, LPN)",1,1,2,0,{"$f":"D64+G64-E64","v":0},0,{"$f":"H64-I64","v":0},1,{"$f":"-E64+F64","v":1},0,0]
[null,null,"TOTAL\n (Lines 1 thru 5)",{"$f":"SUM(D60:D64)","v":80},81,101,21,20,17,3,10,{"$f":"SUM(L60:L64)","v":20},0.2484472049689441]
[]
[null,"SECTION 1B (WAGES)"]
[null,"Line #","POSITION TYPE",null,null,"Current starting wage for this type of position within your agency in 2019 (Hourly Rate)",null,"What is the average wage for this type of position after 2 years of employment (Hourly Rate)"]
[null,6,"ENTRY LEVEL",null,null,13,null,14]
[null,7,"1st LINE SUPERVISORS",null,null,15,null,16]
[null,8,"PROGRAM MANAGERS",null,null,19,null,22]
[null,9,"*SPECIALISTS (recreation, behavioral, or staff trainers, etc.)",null,null,15,null,18]
[null,10,"NURSES (RN, LPN)",null,null,0,null,0]
[]
[null,"SECTION 1C (RETENTION)"]
[null,"Line #","Length of Time with your Agency",null,null,null,"Using the total number of ISS staff from section 1A, column 2 (current ISS staffing level), what is the length of time they have been with your agency?",null,"Using the total number of ISS staff from section 1A, column 5A (total ISS staff who left), what was the length of time they were with your agency?"]
[null,11,"LESS than 6 Months",null,null,null,8,null,13]
[null,12,"BETWEEN 6 and 12 months",null,null,null,21,null,5]
[null,13,"OVER 12 months",null,null,null,52,null,2]
[null,null,"Total Staff by Length of Time\n (Total Lines 7 thru 9)",null,null,null,{"$f":"IF(SUM(G77:H79)<>E65,\"Does not equal Section 1A, Col 2 Total\",SUM(G77:H79))","v":81},null,{"$f":"IF(SUM(I77:J79)<>H65,\"Does not equal Section 1A, Col 5a\",SUM(I77:I79))","v":20}]
[]
[null,"COMMENTS:"]
[]
[null,"DSHS/DDA Schedule E (Rev. 12/2019)"]

{"sheet":"E - Residential Staffing Add'l","index":10,"n_rows":84,"n_cols":14,"rows_kept":84,"cut":false,"hidden":false,"merged":[[81,1,81,13],[82,1,82,13],[83,1,83,13],[77,8,77,9],[78,2,78,5],[78,6,78,7],[78,8,78,9],[79,2,79,5],[79,6,79,7],[79,8,79,9],[74,1,74,9],[75,2,75,5],[75,6,75,7],[75,8,75,9],[75,10,79,13],[76,2,76,5],[76,6,76,7],[76,8,76,9],[77,2,77,5],[77,6,77,7],[71,2,71,4],[71,5,71,6],[71,7,71,8],[72,2,72,4],[72,5,72,6],[72,7,72,8],[69,2,69,4],[69,5,69,6],[69,7,69,8],[70,2,70,4],[70,5,70,6],[70,7,70,8],[66,1,66,8],[67,2,67,4],[67,5,67,6],[67,7,67,8],[68,2,68,4],[68,5,68,6],[68,7,68,8],[56,1,57,2],[56,7,56,10],[57,7,57,10],[40,2,40,11],[41,2,41,11],[42,2,42,11],[43,2,43,11],[44,2,44,11],[47,2,47,7],[48,2,48,7],[49,2,49,7],[50,2,50,7],[51,2,51,7],[55,1,55,13],[39,2,39,11],[24,2,24,11],[25,2,25,11],[26,2,26,11],[29,2,29,11],[32,2,32,11],[33,2,33,11],[34,2,34,11],[35,2,35,11],[36,2,36,11],[37,2,37,11],[38,2,38,11],[23,2,23,11],[13,2,13,4],[13,5,13,10],[16,2,16,3],[16,5,16,10],[17,2,17,3],[17,5,17,10],[18,2,18,3],[18,5,18,10],[19,2,19,3],[19,5,19,10],[22,2,22,10],[12,2,12,4],[12,5,12,10],[0,1,0,13],[2,12,2,13],[3,12,3,13],[6,0,6,14],[7,0,7,14]]}
[null,"SCHEDULE E"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'G - ISS Settlement'!C3","v":"3S - ABC Residential Services"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
["IMPORTANT , PLEASE READ before completing schedule:\nCOMPLETE A SEPARATE SCHEDULE FOR EACH LOCATION BY: PROGRAM TYPE, CITY, AND COUNTY \nFOR ADDITIONAL COPIES OF SCHEDULE E CONTACT YOUR AGENCY'S RATE ANALYST \nReporting Period: January 1, 2019 to December 31, 2019 (One Calendar Year, 12 months, 2019)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
["The schedule(s) will be reviewed by the rate analyst to ensure the Agency is rporting contracts, programs, and locations separately. \nAny cost reports found to be incomplete will be returned to the agency for correction."]
[]
[null,"1. AGENCY INFORMATION:"]
[null,null,"Where are the Services Provided?"]
[]
[null,null,"PROGRAM TYPE",null,null,"PROGRAM NAME",null,null,null,null,null,"CITY","COUNTY"]
[null,null,"GH Group Home",null,null,"3S - ABC Residential Services",null,null,null,null,null,"New Town","Thurston"]
[]
[null,"2. CONTACT INFORMATION:"]
[null,null,"Name (Person Completing Schedule):",null,null,"John Doe"]
[null,null,"Title (Person Completing Schedule):",null,null,"Human Resources Director"]
[null,null,"Telephone Number:",null,null,"360-555-9876"]
[null,null,"E-Mail Address:",null,null,"jdoe@gmail.com"]
[]
[null,"3. BOARD OF DIRECTORS INFORMATION:  "]
[null,null,"Non-Profit Agencies only, please fill out the following information if you have a Board of Directors or other governing board.  Do not include advisory committees or other non-governing, non-voting boards."]
[null,null,"a) Board of Directors -  Number of Members (total number of positions)?",null,null,null,null,null,null,null,null,null,5]
[null,null,"b)  Board of Directors -Total number of voting board members?",null,null,null,null,null,null,null,null,null,5]
[null,null,"c)  Voting Board Members - How many are people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?",null,null,null,null,null,null,null,null,null,1]
[null,null,"d)  Voting Board Members - How many are family members (parents, siblings, or other relatives) of people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?",null,null,null,null,null,null,null,null,null,0]
[]
[null,"4. CLIENT INFORMATION: "]
[null,null,"Average Monthly Count of Clients supported in this program?  ",null,null,null,null,null,null,null,null,null,10]
[]
[null,"5. EMPLOYEE BENEFITS:"]
[null,null,"In addition to wages, does your agency provide benefits to ISS staff?\nIf Yes, check all that apply",null,null,null,null,null,null,null,null,null," Yes"]
[null,null,"Medical Insurance (paid in whole or in part by agency)",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Dental Insurance (paid in whole or in part by agency)",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Retirement (paid in whole or in part by agency)"]
[null,null,"Paid Sick Leave",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Paid Vacation",null,null,null,null,null,null,null,null,null,"X"]
[null,null,"Short-Term Disability"]
[null,null,"Long-Term Disability"]
[null,null,"Jury Duty Leave"]
[null,null,"Bereavement Leave"]
[null,null,"Vision Insurance"]
[null,null,"Employee Assistance Plan"]
[null,null,"Life Insurance",null,null,null,null,null,null,null,null,null,"X"]
[]
[null,"6. RECRUITING:"]
[null,null,"\nDifference in recruiting new staff from 1/1/2019 - 12/31/2019?\n(Only check boxes that apply)",null,null,null,null,null,"ENTRY LEVEL","1st LINE SUPERVISOR","PROGRAM MANAGERS","*SPECIALISTS\n (Recreation, behavioral, or staff trainers)","NURSES\n(RN, LPN)"]
[null,null,"Situation is worse than previous year (Harder to recruit)",null,null,null,null,null,"X"]
[null,null,"Some improvement from previous year (Easier to recruit)"]
[null,null,"Definite improvement from previous year (Much easier to recruit)"]
[null,null,"No difference from previous year",null,null,null,null,null,null,"x","x","x","X"]
[]
[null,"7. STAFFING INFORMATION:"]
[]
[null,"SECTION 1A (TURNOVER)"]
[null,null,null,1,2,3,4,5,null,null,null,6,7,8]
[null,null,null,"Beginning of Year ISS Staffing Level","Current ISS Staffing Level","Full ISS Employment","Number of ISS Staff Hired","Number of ISS staff who left or had their employment terminated:",null,null,null,"Positions Available"]
[null,"Line #","POSITION TYPE","Number of ISS staff (Full-time, Part-time, & Temp combined) on January 1st, 2019","Number of ISS staff (Full-time, Part-time, & Temp combined) on December 31, 2019","Number of ISS staff needed for full employment on December 31st 2019","Number of ISS staff hired during the calander year.","a. Total ISS Staff who left/or had their employment terminated during the Calander Year (Col. 7.1 + Col. 7.4 - Col. 7.2)","b. (Six Months) \nJan 1, 2019 to June 30, 2019","c. (Six Months) \nJuly 1, 2019 to Dec. 31, 2019 (Col. 7.5a - Col. 7.5b)","d. Optional: Within 90 days of hiring date (Calander Year)","Number of vacancies on Dec 31, 2019","ISS Staff Turnover percentage","Average number of days to fill vacant positions (Estimates accepted if unknown)"]
[null,1,"ENTRY LEVEL",25,20,28,8,{"$f":"D60+G60-E60","v":13},5,{"$f":"H60-I60","v":8},5,{"$f":"-E60+F60","v":8},{"$f":"H60/(0.5*(D60+E60))","v":0.57777777777777772},0]
[null,2,"1st LINE SUPERVISORS",6,5,6,0,{"$f":"D61+G61-E61","v":1},0,{"$f":"H61-I61","v":1},0,{"$f":"-E61+F61","v":1},0.18181818181818182,0]
[null,3,"PROGRAM MANAGERS",1,1,1,0,{"$f":"D62+G62-E62","v":0},0,{"$f":"H62-I62","v":0},0,{"$f":"-E62+F62","v":0},0,0]
[null,4,"*SPECIALISTS \n(recreation, behavioral, or staff trainers, etc.)",4,4,4,0,{"$f":"D63+G63-E63","v":0},0,{"$f":"H63-I63","v":0},0,{"$f":"-E63+F63","v":0},0,0]
[null,5,"NURSES (RN, LPN)",1,1,1,0,{"$f":"D64+G64-E64","v":0},0,{"$f":"H64-I64","v":0},0,{"$f":"-E64+F64","v":0},0,0]
[null,null,"TOTAL\n (Lines 1 thru 5)",{"$f":"SUM(D60:D64)","v":37},31,40,8,14,5,9,5,{"$f":"SUM(L60:L64)","v":9},0.41176470588235292]
[]
[null,"SECTION 1B (WAGES)"]
[null,"Line #","POSITION TYPE",null,null,"Current starting wage for this type of position within your agency in 2019 (Hourly Rate)",null,"What is the average wage for this type of position after 2 years of employment (Hourly Rate)"]
[null,6,"ENTRY LEVEL",null,null,13,null,14]
[null,7,"1st LINE SUPERVISORS",null,null,18,null,20]
[null,8,"PROGRAM MANAGERS",null,null,21,null,25]
[null,9,"*SPECIALISTS (recreation, behavioral, or staff trainers, etc.)",null,null,37,null,41]
[null,10,"NURSES (RN, LPN)",null,null,26,null,30]
[]
[null,"SECTION 1C (RETENTION)"]
[null,"Line #","Length of Time with your Agency",null,null,null,"Using the total number of ISS staff from section 1A, column 2 (current ISS staffing level), what is the length of time they have been with your agency?",null,"Using the total number of ISS staff from section 1A, column 5A (total ISS staff who left), what was the length of time they were with your agency?"]
[null,11,"LESS than 6 Months",null,null,null,13,null,12]
[null,12,"BETWEEN 6 and 12 months",null,null,null,17,null,0]
[null,13,"OVER 12 months",null,null,null,1,null,2]
[null,null,"Total Staff by Length of Time\n (Total Lines 7 thru 9)",null,null,null,{"$f":"IF(SUM(G77:H79)<>E65,\"Does not equal Section 1A, Col 2 Total\",SUM(G77:H79))","v":31},null,{"$f":"IF(SUM(I77:J79)<>H65,\"Does not equal Section 1A, Col 5a\",SUM(I77:I79))","v":14}]
[]
[null,"COMMENTS:"]
[]
[null,"DSHS/DDA Schedule E (Rev. 12/2019)"]

{"sheet":"F - Healthcare Expenses","index":11,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[17,4,17,8],[18,4,18,8],[19,4,19,8],[41,1,41,8],[27,9,27,10],[28,9,28,10],[30,9,30,10],[31,9,31,10],[32,9,32,10],[28,1,28,8],[27,1,27,8],[40,1,40,10],[35,1,36,4],[38,1,39,4],[33,9,33,10],[20,4,20,8],[0,1,0,10],[24,9,24,10],[26,9,26,10],[25,9,25,10],[3,9,3,10],[24,1,24,8],[25,1,25,8],[26,1,26,8],[6,0,6,11],[9,1,9,2],[8,9,8,10],[9,4,9,8],[10,4,10,8],[11,4,11,8],[5,0,5,11],[2,9,2,10],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[12,4,12,8],[13,4,13,8],[42,1,42,10],[29,9,29,10],[41,9,41,10],[29,1,29,8],[30,1,30,8],[31,1,31,8],[32,1,32,8],[33,1,33,8],[34,1,34,10],[37,1,37,10]]}
[null,"SCHEDULE F"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"'G - ISS Settlement'!C3","v":"3S - ABC Residential Services"}]
[null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
["INCLUDE ALL PROGRAMS FOR THE AGENCY ON THIS SCHEDULE"]
["Reporting Period: Dececmber 1, 2019  to  December 31, 2019 (One Month)"]
[null,"PROVIDER INFORMATION:"]
[null,null,null,null,null,null,null,null,null,"Where are the Client Services Provided?"]
[null,"PROGRAM TYPE",null,"PROVIDER NUMBER","PROGRAM NAME",null,null,null,null,"CITY   ","COUNTY   "]
[null,"Supported Living",null,111111,"ABC Supported Living",null,null,null,null,"Small Town","Pierce"]
[null,"Group Home",null,333333,"ABC Group Home",null,null,null,null,"Small Town","Pierce"]
[null,"Group Training Home"]
[null,"Supported Living - SOLA"]
[]
[null,"CONTACT INFORMATION:"]
[]
[null,null,"Name (Person Completing Schedule)",null,"John Doe"]
[null,null,"Title (Person Completing Schedule)",null,"Human Resources Manager"]
[null,null,"Telephone Number:",null,"360-555-9876"]
[null,null,"E-Mail Address:",null,"john.doe@abc.org"]
[]
[null,"HEALTH INSURANCE:"]
[]
[null,"1. Total Number of employees working for the agency",null,null,null,null,null,null,null,112]
[null,"2. Total number of Employees from #1 averaging 29 or less hours per week",null,null,null,null,null,null,null,18]
[null,"3. Total number of Employees from #1 averaging 30-39 hours per week",null,null,null,null,null,null,null,8]
[null,"4. Total number of Employees from #1 averaging 40 or more hours per week \n**The sum of #2, 3, & 4 must equal the total number of employees reported on #1",null,null,null,null,null,null,null,86]
[null,"5. Currently how many employees who work in Supported Living (SL), Group Home (GH) or Children's Staffed Residential (CSR) are on your company provided health insurance plan? Please provide one number for all three types of services - add them all together if your company provides coverage for them separately, or accounts for them, separately. \n**This is for health insurance - do not include dental or other services (such as an Employee Assistance Plan (EAP), life insurance, disability insurance etc). Do not include coverage for employees who primarily work in other streams of revenue - private pay, home care, community access, supported employment etc. ",null,null,null,null,null,null,null,90]
[null,"6. Currently how many ISS hours per week does an employee have to work to be eligible for your company provided health insurance?",null,null,null,null,null,null,null,25]
[null,"7. What is the average cost per employee (the premium per subscriber) of company provided health insurance? This is the cost to the company and does not include the participation by the employee - if your current premium is $100.00 per subscriber and employee pays $20.00 towards the premium then you would enter $80.00",null,null,null,null,null,null,null,224.95]
[null,"8. Currently how many of your employees work thirty (30) or more hours per week, but are not eligible for company provided health insurance?",null,null,null,null,null,null,null,0]
[null,"9. Currently how many employees have waived your company provided health insurance, but will be required to take advantage of it in 2020? (Not 2019)",null,null,null,null,null,null,null,56]
[null,"10. Taking into account your answers to question #4, #7 and #8; how many employees do you estimate will be enrolled in your company provided health insurance plan in 2020 to ensure compliance with the ACA? What is the total amount of enrollees you anticipate will be on your plan. (Not 2019)",null,null,null,null,null,null,null,75]
[]
[null,"11. Over a five year period what has been the percentage per employee (per subscriber) premium increase on your company provided health insurance? Please select a consecutive five year period, 2014 to 2018 or 2015 to 2019. Please represent this number as a percentage based on a per employee/subscriber cost increase from the prior year. For example: In 2015 the premium per employee was $100 and then increased to $150 in 2016; in 2016 you had a 50% increase in your per employee/subscriber premium costs.",null,null,null,2014,2015,2016,2017,2018,2019]
[null,null,null,null,null,"8% increase","No Change","8.41% Increase","2.1% Increase","No Change","9.25% Increase"]
[]
[null,"12. Over the same five year period you included in question 9 above, did your company reduce benefits offered through your company provided health insurance plan to reduce the company costs per employee (per subscriber) because the proposed rate increase was too high? For example, did your company move to a less robust plan which provided less coverage for employees/subscribers and required higher co-pays and deductibles? Please answer with \"Yes\" or \"No\"",null,null,null,2014,2015,2016,2017,2018,2019]
[null,null,null,null,null,"No","No","Yes","Yes","No","Yes"]
[]
[null,"13. How many clients does your company serve in SL, GH and/or LSR? Please add all numbers together and provide one number for all clients served in all three areas.",null,null,null,null,null,null,null,296]
[null,"DSHS/DDA Schedule F (Rev. 12/2019)"]

{"sheet":"G - ISS Settlement","index":12,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,2],[35,0,35,2],[6,0,6,2],[39,1,39,2],[24,0,24,2],[33,0,33,2]]}
["SCHEDULE G"]
[null," "]
[null,null,{"$f":"_M000001","v":"3S - ABC Residential Services"}]
[null,null,"PROVIDER NAME"]
[]
["A","B","C"]
["REIMBURSEMENT SUMMARY"]
["Line","Tiered ISS by Program Type","ISS Reimbursement"]
[1,"SL Supported Living",1314015.48,null,{"$f":"IF(B9=\"GH Group Home\",2,IF(B9=\"GTH Group Training Home\",3,IF(B9=\"SL Supported Living\",1,\"NA\")))","v":1}]
[{"$f":"A9+1","v":2},"GH Group Home",494316.31,null,{"$f":"IF(B10=\"GH Group Home\",2,IF(B10=\"GTH Group Training Home\",3,IF(B10=\"SL Supported Living\",1,\"NA\")))","v":2}]
[{"$f":"A10+1","v":3},"GTH Group Training Home",386410.9,null,{"$f":"IF(B11=\"GH Group Home\",2,IF(B11=\"GTH Group Training Home\",3,IF(B11=\"SL Supported Living\",1,\"NA\")))","v":3}]
[{"$f":"+A11+1","v":4},"Sub-Total",{"$f":"SUM(C9:C11)","v":2194742.69}]
[]
[null,"Nurse Delegation, Staff Add On & COCA Cost of Care Adjustment ","ISS Reimbursement"]
[{"$f":"+A12+1","v":5},"SL Nurse Delegation",{"$f":"2012.5+1668+1610-C16-C17","v":3437},null,1]
[{"$f":"+A15+1","v":6},"GH Nurse Delegation",1165.8699999999999,null,2]
[7,"GTH Nurse Delegation",687.63,null,3]
[8,"SL Staff Add On",251.52,null,1]
[9,"GH Staff Add On",312.85000000000002,null,2]
[10,"GTH Staff Add On",50,null,3]
[11,"SL COCA",0,null,1]
[12,"GH COCA",0,null,2]
[13,"GTH COCA",0,null,3]
[14,"Sub-Total",{"$f":"SUM(C15:C23)","v":5904.8700000000008}]
[]
[null,"Staff & Purchased Professional Services: Description \n(RN, LPN, DBT, Therapist, etc.) ","Professional Services ISS Reimbursement"]
[{"$f":"+A24+1","v":15},"SL LPN M&C",8641.65,null,{"$f":"IF(F27=\"GH\",2,IF(F27=\"GT\",3,IF(F27=\"SL\",1,\"\")))","v":1},{"$f":"LEFT(B27,2)","v":"SL"}]
[{"$f":"+A27+1","v":16},"SL RN M&C",5657.5,null,1,"SL"]
[17,null,0,null,"",""]
[18,null,0,null,"",""]
[19,null,0,null,"",""]
[20,null,0,null,"",""]
[21,"Sub-Total",{"$f":"SUM(C27:C32)","v":14299.15}]
[]
[{"$f":"+A33+1","v":22},"Total ISS Reimbursements paid by DSHS (carries to Line 23)",{"$f":"C12+C24+C33","v":2214946.71}]
["SETTLEMENT"]
[{"$f":"A35+1","v":23},"TOTAL REIMBURSED DOLLARS (Auto-filled from Line 22)",{"$f":"C35","v":2214946.71}]
[{"$f":"A37+1","v":24},"ISS Staff Payroll & Allowable Administrator ISS Payroll less Overtime\n(Auto-filled from Sch B, Row 65, Col R less Sch B, Row 65, Col E)",{"$f":"'B - ISS Payroll Expenses'!S77-'B - ISS Payroll Expenses'!F77","v":2074815.1199999996}]
[{"$f":"A38+1","v":25},"ISS Overtime Staff Costs (Auto-filled from Sch B, Row 65, Col E)",{"$f":"'B - ISS Payroll Expenses'!F77","v":127169.39999999998}]
[null,"Authorized Purchased Professional Services: (RN, LPN, DBT, Therapist, etc.) "]
[{"$f":"A39+1","v":26},"SL Authorized ISS Purchased Professional Services",4892.25,null,{"$f":"IF(F41=\"GH\",2,IF(F41=\"GT\",3,IF(F41=\"SL\",1,\"\")))","v":1},{"$f":"LEFT(B41,2)","v":"SL"}]
[{"$f":"A41+1","v":27},"GH Authorized ISS Purchased Professional Services",3701.99,null,{"$f":"IF(F42=\"GH\",2,IF(F42=\"GT\",3,IF(F42=\"SL\",1,\"\")))","v":2},{"$f":"LEFT(B42,2)","v":"GH"}]
[{"$f":"A42+1","v":28},null,null,null,{"$f":"IF(F43=\"GH\",2,IF(F43=\"GT\",3,IF(F43=\"SL\",1,\"\")))","v":""},{"$f":"LEFT(B43,2)","v":""}]
[{"$f":"A43+1","v":29},"TOTAL ALLOWABLE ISS COSTS PAID BY THE PROVIDER (Line 24+25+26+27+28)",{"$f":"SUM(C38:C43)","v":2210578.7599999998}]
[{"$f":"A44+1","v":30},"TOTAL PRELIMINARY NET SETTLEMENT AMOUNT",{"$f":"IF((_C001589-C44)<0,0,(_C001589-C44))","v":4367.9500000001863}]
[null,"DSHS/DDA Schedule G ISS Settlement (Rev. 12/2019)"]