{"text_format":"1","workbook":"xlsx","n_sheets":17,"sheets":["Cost Report Posting & Training","Cost Report Build Update","2023 Notes","Lists","Administrator Regression Table","ISS Detail","RES","Checklist","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":4,"macros":1,"external_links":12,"defined_names":6789,"comments":8,"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":"Cost Report Posting & Training","index":0,"n_rows":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
["INCOMPLETE"]
["Cost Report training is completed between October and November each year so that providers are prepared to complete their cost report as soon as the year ends. The current year cost report template was made available to the providers at the beginning of the calendar year. Providers will need to be notified of any major template changes that would require them to transfer their data to a revised template. Providers will also be notified of any known changes (if any) to the upcoming calendar year template that will be posted in January. "]
[]
["All the following resources will need to be revised for any changes made to the reporting & training process. Each resource has instructions located within the file. "]
[]
["YYYY ABC Sample - Cost Report"]
["YYYY ABC Sample - Schedule H Rate History"]
["YYYY ABC Sample - Scheduel I Allocations"]
["YYYY Cost Report - Template"]
["YYYY Schedule H Rate History - Template"]
["YYYY Schedule I Allocations - Template"]
["YYYY Powerpoint Presentation"]
["YYYY Cost Report Instructions"]
["YYYY Schedule H Rate History - Training"]
["YYYY Comment Form"]
["YYYY Cost Report - Powerpoint Presentation Training"]
[]
["In July each year begin working with the RMA to determine how many will be presented in each region and schedule training rooms as to ensure availability, seating, and projection capabilities. "]
[]
["After the dates and locations have been scheduled make any necessary hotel and travel arrangments. "]

{"sheet":"Cost Report Build Update","index":1,"n_rows":56,"n_cols":1,"rows_kept":56,"cut":false,"hidden":true,"merged":[]}
["INCOMPLETE"]
[]
["Workbook must be manipulated to accommodate DDA changes. Use the sample cost report to make changes so that the "]
[]
["Unhide all tabs"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Unprotect all tabs"]
[]
[]
[]
[]
[]
[]
["Headings under the view tab will need to be selected to make changes to columns and rows"]
[]
[]
[]
[]
[]
[]
[]
["Lists Tab"]
["Revise/update the lists on this tab for drop down menus used throughout the cost report. **This may affect formulas throughout the report. "]
[]
["Adminstrator Regression Table"]
["Revise formulas in cells B2 through E2 to increase or decrease the maximum annual claimable Administrator ISS wages equal to the percentage change in the daily rate. "]
[]
["RES Tab"]
["This schedule summarizes data from schedules B, C, D, & G in to a column format by program and by provider. The data is used to create the residential summary file used to provide DDA with cost report data in a format that can be analyzed and SAO for auditing purposes. "]
[]
["If a reporting change is made to Schedule B, C, D, or G a corresponding change to the RES tab may be necessary. Once the changes are made verify the formulas are producing the correct data for each schedule section. "]
[]
[]
["Read Me Tab"]
["Revise #1 (highlighted green) annually to announce changes from the previous annual cost report template. "]
["Revise remaining list as necessary, including contact information at the bottom of the worksheet."]
[]
["Schedule A"]
["Revise as necessary. Verify all drop down lists and formulas are working for all schedules after making changes. "]
[]
["Schedule B"]

{"sheet":"2023 Notes","index":2,"n_rows":23,"n_cols":1,"rows_kept":23,"cut":false,"hidden":true,"merged":[]}
["2022 Cost Report Template changes"]
["Regression table increased 23%"]
["Regression table changed back to 21 FTE's (SL & Combined agencies with fewer than 21 FTE's calculated on Schedule B are eligible to claim ISS, providing ISS duties are performed)"]
["Replaced Schedule E, reformated visually, added box for #3"]
["Corrected Sch F missing provider name"]
["Corrected spelling \"regular\" on Sch B, columns D/G"]
["Updated list tab - provider names, ID, & urban designation for drop down lists"]
["Revised ARC of Clark name to be Arc of Southwest Washington"]
["Updated Read Me tab #1 year to year changes"]
["Corrected formula for average Sch B, FTE calculation"]
["Added Lead/Supervisor settlement check points"]
["Updated - ABC sample Schedule E's, including additional formatting and print views"]
["Template revision date updated"]
["Schedule D covid revenue reporting hints added to lines 1 & 2 - in red font"]
["Created Sch B sample for ISS accrual reporting idea to yearend accrual reporting and reversal of accruals claimed in following year. Eliminate all other accrual may require policy change"]
["Added questions to Schedule C"]
["Added to RES tab: Region, Sch H # of clients by dividing # of days by 365, "]
["Added tab to gather ISS payroll detail: reg, OT, PTO, other wages, ER taxes, ER benefits, & the average regression table FTE's"]
[]
["2023 Cost Report Template changes"]
["Regression table increased 2% effective 1/1/23"]
["Read Me tab - Revised #1"]
["Revised all dates from 2022 to 2023"]

{"sheet":"Lists","index":3,"n_rows":143,"n_cols":15,"rows_kept":143,"cut":false,"hidden":true,"merged":[[0,6,0,9]]}
["Provider Name","Provider ID","Urban Designation",null,"Schedule B Monthly / Quarterly",null,"Schedule B",null,null,null,null,"Program Type",null,"B&O CITY","effective 1/1/22"]
[null,null,null,null,null,null,1,"2a","2b","2c"]
["1N - Accendo of Washington",215573301,"MSA",null,"Monthly",null,null,null,null,null,null,"SL Supported Living",null,"Aberdeen"]
["1N - Adult Guidance & Empowerment Service",111684901,"MSA",null,"Quarterly",null,"Yes","Yes","Yes","Program Revenues",null,"GH Group Home",null,"Algona"]
["1N - Alpha Supported Living (Spokane)",111320906,"MSA",null,null,null,"No","No","No","ISS/Direct Care Cost",null,"GTH Group Training Home",null,"Auburn"]
["1N - Ambitions Accendo",111901911,"MSA",null,null,null,null,null,null,"Other Method - Please describe",null,null,null,"Bainbridge Island"]
["1N - Ambitions - Moses Lake, Omak, and Wenatchee",111901903,"MSA/NON-MSA",null,null,null,null,null,null,null,null,null,null,"Bellevue"]
["1N - Ambitions - Spokane",111901906,"MSA",null,null,null,null,null,null,null,null,null,null,"Bellingham"]
["1N - ARC of Spokane",111426502,"MSA",null,null,null,null,null,null,null,null,null,null,"Blaine"]
["1N - Assisted Residential Services",111705601,"MSA",null,null,null,null,null,null,null,null,null,null,"Bremerton"]
["1N - Community Integrated Services",111425301,"MSA",null,null,null,null,null,null,null,null,null,null,"Burien"]
["1N - Community Visions",111530102,"MSA",null,null,null,null,null,null,null,null,null,null,"Burlington"]
["1N - Dreamworks Residential",111913801,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Cosmopolis"]
["1N - Drive Services",111621401,"MSA",null,null,null,null,null,null,null,null,null,null,"Darrington"]
["1N - Excel Supported Living",111322002,"MSA",null,null,null,null,null,null,null,null,null,null,"Des Moines"]
["1N - Grace Support Services",212120601,"MSA",null,null,null,null,null,null,null,null,null,null,"DuPont"]
["1N - Grant County Developmental Disabilities (DCL)",200012501,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Everett"]
["1N - Hope Human Services (Spokane)",207150604,"MSA",null,null,null,null,null,null,null,null,null,null,"Everson"]
["1N - Hope Supported Living",213504001,"MSA",null,null,null,null,null,null,null,null,null,null,"Granite Falls"]
["1N - Kaler House",111686001,"MSA",null,null,null,null,null,null,null,null,null,null,"Hoquiam"]
["1N - LMK",111988202,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Ilwaco"]
["1N - Latah Services",111762501,"MSA",null,null,null,null,null,null,null,null,null,null,"Issaquah"]
["1N - Living In Fulfilling Environment",111777301,"MSA",null,null,null,null,null,null,null,null,null,null,"Kelso"]
["1N - Mission Vista",111707401,"MSA",null,null,null,null,null,null,null,null,null,null,"Kenmore"]
["1N - Parent's Cooperative Society for the Handicapped (Merry Glen)",111328901,"MSA",null,null,null,null,null,null,null,null,null,null,"Kent"]
["1N - ResCare Spokane",111968514,"MSA",null,null,null,null,null,null,null,null,null,null,"Lacey"]
["1N - Sails Spokane",111805707,"MSA",null,null,null,null,null,null,null,null,null,null,"Lake Forest Park"]
["1S - Alternative Residential Services",111625401,"MSA/NON-MSA",null,null,null,null,null,null,null,null,null,null,"Long Beach"]
["1S - Ambitions Ellensburg",111901909,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Longview"]
["1S - Ambitions - Kennewick",111901901,"MSA",null,null,null,null,null,null,null,null,null,null,"Lyman"]
["1S - Ambitions - Yakima",111901907,"MSA",null,null,null,null,null,null,null,null,null,null,"Mercer Island"]
["1S - Community Living",111962202,"MSA",null,null,null,null,null,null,null,null,null,null,"North Bend"]
["1S - Habilitat",111449601,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Ocean Shores"]
["1S - Kittitas Interactive Management",111688701,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Olympia"]
["1S - Kittitas Interactive Management (Yakima)",111688702,"MSA",null,null,null,null,null,null,null,null,null,null,"Pacific"]
["1S - Reach Supported Living",209862801,"MSA",null,null,null,null,null,null,null,null,null,null,"Port Townsend"]
["1S - Reach Supported Living Walla Walla",209862802,"MSA",null,null,null,null,null,null,null,null,null,null,"Rainier"]
["1S - Reach Supported Living Yakima",209862803,"MSA",null,null,null,null,null,null,null,null,null,null,"Raymond"]
["1S - Tri-Cities Residential Services",111872501,"MSA",null,null,null,null,null,null,null,null,null,null,"Renton"]
["1S - Valley Residential Services",111777901,"NON-MSA",null,null,null,null,null,null,null,null,null,null,"Roy"]
["2N - Access Living",111675101,"MSA",null,null,null,null,null,null,null,null,null,null,"Ruston"]
["2N - All Heart Agency",111961601,"MSA",null,null,null,null,null,null,null,null,null,null,"Seattle"]
["2N - Alpha Supported Living Services",111320902,"MSA",null,null,null,null,null,null,null,null,null,null,"Shelton"]
["2N - Ambitions Whatcom",111901908,"MSA",null,null,null,null,null,null,null,null,null,null,"Shoreline"]
["2N - Camelot Society",101955202,"MSA",null,null,null,null,null,null,null,null,null,null,"Snoqualmie"]
["2N - Cascade Connections",111724102,"MSA",null,null,null,null,null,null,null,null,null,null,"South Bend"]
["2N - Dungarvin",111414307,"MSA",null,null,null,null,null,null,null,null,null,null,"Tacoma"]
["2N - Evergreen Supported Living",111690301,"MSA",null,null,null,null,null,null,null,null,null,null,"Tenino"]
["2N - Holly Community Services",111765001,"MSA",null,null,null,null,null,null,null,null,null,null,"Tumwater"]
["2N - La Casa de Esperanza ",111390801,"MSA",null,null,null,null,null,null,null,null,null,null,"Westport"]
["2N - Puffin Island",111959501,"MSA",null,null,null,null,null,null,null,null,null,null,"Yelm"]
["2N - Quilceda Community Services",111321203,"MSA"]
["2N - Rehabco",111681901,"MSA"]
["2N - Res-Care of Washington",111968512,"MSA"]
["2N - SAILS",111805705,"MSA"]
["2N - Service Alternatives",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 - Ablelight",111621301,"KING"]
["2S - Alpha Supported Living Services",111320901,"KING"]
["2S - Ambitions",111901902,"KING"]
["2S - Arc of King County",112013701,"KING"]
["2S - Banchero Disability Partners",111415001,"KING"]
["2S - Camelot Society",101955201,"KING"]
["2S - Cascade Community Services",111875001,"KING"]
["2S - CARR Supported Living King",111533401,"KING"]
["2S - Community Integrated Services",111425302,"KING"]
["2S - Community Living",111962201,"KING"]
["2S - Destiny House",111992801,"KING"]
["2S - Friendship House",111405501,"KING"]
["2S - Greenwood Home",111913301,"KING"]
["2S - Habilitation Services",208173701,"KING"]
["2S - Helping Hands DBA Dahlia",111736003,"KING"]
["2S - Hershey Housing",217522701,"KING"]
["2S - Inglewood Residential and Community Services",111568401,"KING"]
["2S - Integrated Living Services",111789002,"KING"]
["2S - L'Arche Noah Sealth of Seattle",111798601,"KING"]
["2S - Life Skills Center",111499601,"KING"]
["2S - Maksu",111577901,"KING"]
["2S - Parkview Services",111456901,"KING"]
["2S - Provail",101144803,"KING"]
["2S - Puget Sound Regional Services",111925301,"KING"]
["2S - Res-Care Washington",111968506,"KING"]
["2S - SAILS",111805704,"KING"]
["2S - Service Alternatives for WA",111513302,"KING"]
["2S - Shamrock Living Services",111958301,"KING"]
["2S - Shared Journeys",111515201,"KING"]
["2S - Stand Together",111753401,"KING"]
["2S - Tahoma Hills",111799101,"KING"]
["2S - Total Living Concept",111571101,"KING"]
["2S - United Friends Group Home",101601101,"KING"]
["2S - Volunteers of America",200494104,"KING"]
["3N - Ambitions",111901904,"MSA"]
["3N - Communitas Group",102702801,"MSA"]
["3N - Community Alternatives for People with Autism (CAPA)",112026801,"MSA"]
["3N - Dungarvin Pierce",111414304,"MSA"]
["3N - Educational Programs in Home Living",111975401,"MSA"]
["3N - Group Action for Peninsula People (GAPP)",111703801,"MSA"]
["3N - Hope Human Services",207150601,"MSA"]
["3N - Kitsap Residences",111781001,"MSA"]
["3N - Kitsap Tenant Support Services (KTSS)",111715902,"MSA"]
["3N - L'Arche Tahoma Hope Community",111610303,"MSA"]
["3N - Life Force Services",111691201,"MSA"]
["3N - NW Services for Independent Living (NWSIL)",111812601,"MSA"]
["3N - PAM Group Home",111728401,"MSA"]
["3N - Puget Sound Assisted Living",111557601,"MSA"]
["3N - Res-Care Washington",111968504,"MSA"]
["3N - Service Alternatives",111513305,"MSA"]
["3N - Steadfast Supported Living",217455001,"MSA"]
["3N - Tahoma Associates",111335302,"MSA"]
["3N - Valley Supported Living",111938101,"MSA"]
["3N - Vibrant Health Homecare",212772002,"MSA"]
["3S - ABC Residential Services",555777999,"MSA"]
["3S - Adam's Place",214039501,"MSA"]
["3S - Ambitions",111901905,"MSA/NON-MSA"]
["3S - Another Option",111619102,"MSA"]
["3S - Arc of Southwest Washington Clark",102623403,"MSA"]
["3S - CCH Individual Support Services",111909801,"NON-MSA"]
["3S - CARR Thurston",111533403,"MSA"]
["3S - CARR Clark",111533405,"MSA"]
["3S - Community Resources",111977701,"MSA/NON-MSA"]
["3S - Dungarvin Clark",111414303,"NON-MSA"]
["3S - Dungarvin Thurston",111414308,"MSA"]
["3S - Exceptional Foresters",111551801,"MSA"]
["3S - Harbor Alternative Living Association (HALA)",111349601,"NON-MSA"]
["3S - Hope Human Services",207150603,"MSA"]
["3S - Kitsap Tenant Support Services (KTSS)",111715901,"NON-MSA"]
["3S - Kokua",111492901,"MSA"]
["3S - Life Force Services - Thurston",111691202,"MSA"]
["3S - Life Works",111594402,"MSA"]
["3S - Northwest Supported Living - Clark",215510001,"MSA"]
["3S - Northwest Supported Living - Thurston",215510002,"MSA"]
["3S - Placeone",111512001,"MSA"]
["3S - Reside Residential",111864101,"MSA"]
["3S - ROAR",111442501,"MSA"]
["3S - SOLO",111910501,"MSA"]
["3S - Twin Harbors Group Home",111669901,"NON-MSA"]
["3S - Vancare",111811201,"MSA"]
["DSHS/DDA Administrator Regression Table (Rev. 12/2022)"]

{"sheet":"Administrator Regression Table","index":4,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":true,"merged":[[0,6,1,6]]}
["NUMBER OF ISS FTE's","KING","MSA","MSA/\nNON-MSA","NON-MSA",null,"Annual ISS Wages used to calculate FTE's","KING","MSA","MSA/\nNON-MSA","NON-MSA",null,"URBAN DESIGNATION & REPORTING PERIOD","FTE MTH/QRT WAGES FOR FY",null,{"$f":"CONCATENATE(Q1,'B - ISS Payroll Expenses'!B10)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(_M000001,Lists!A1:C144,3)","v":{"$error":"#N/A"}},"KING","MSA","MSA/\nNON-MSA","NON-MSA"]
[1,{"$f":"ROUND((117772.66*1.02),2)","v":120128.11},{"$f":"ROUND((114154.46*1.02),2)","v":116437.55},{"$f":"ROUND((113219.74*1.02),2)","v":115484.13},{"$f":"ROUND((112285.04*1.02),2)","v":114530.74},null,null,{"$f":"B2/2","v":60064.055},{"$f":"C2/2","v":58218.775000000001},{"$f":"D2/2","v":57742.065000000002},{"$f":"E2/2","v":57265.37},null,"KingMonthly",{"$f":"H2/12","v":5005.3379166666664}]
[2,{"$f":"$B$2-($B$2*(A3-1)*5%)","v":114121.70449999999},{"$f":"$C$2-($C$2*(A3-1)*5%)","v":110615.6725},{"$f":"$D$2-($D$2*(A3-1)*5%)","v":109709.9235},{"$f":"$E$2-($E$2*(A3-1)*5%)","v":108804.20300000001},null,null,null,null,null,null,null,"KingQuarterly",{"$f":"H2/4","v":15016.01375}]
[3,108115.299,104793.795,103935.717,103077.666,null,null,null,null,null,null,null,"MSA/NON-MSAMonthly",{"$f":"J2/12","v":4811.8387499999999}]
[4,102108.89350000001,98971.917499999996,98161.510500000004,97351.129000000001,null,null,null,null,null,null,null,"MSA/NON-MSAQuarterly",{"$f":"J2/4","v":14435.516250000001}]
[5,96102.487999999998,93150.040000000008,92387.304000000004,91624.592000000004,null,null,null,null,null,null,null,"MSAMonthly",{"$f":"I2/12","v":4851.5645833333338}]
[6,90096.08249999999,87328.162500000006,86613.097500000003,85898.054999999993,null,null,null,null,null,null,null,"MSAQuarterly",{"$f":"I2/4","v":14554.69375}]
[7,84089.676999999996,81506.285000000003,80838.891000000003,80171.518000000011,null,null,null,null,null,null,null,"NON-MSAMonthly",{"$f":"K2/12","v":4772.1141666666672}]
[8,78083.271500000003,75684.407500000001,75064.684500000003,74444.981,null,null,null,null,null,null,null,"NON-MSAQuarterly",{"$f":"K2/4","v":14316.342500000001}]
[9,72076.865999999995,69862.53,69290.478000000003,68718.444000000003]
[10,66070.460500000001,64040.652499999997,63516.271500000003,62991.906999999999]
[11,60064.054999999993,58218.775000000001,57742.065000000002,57265.369999999995]
[12,54057.6495,52396.897499999999,51967.858499999995,51538.832999999999]
[13,48051.243999999992,46575.01999999999,46193.652000000002,45812.296000000002]
[14,42044.838499999998,40753.142499999987,40419.445500000002,40085.758999999991,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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[15,36038.43299999999,34931.264999999999,34645.239000000001,34359.221999999994]
[16,30032.027499999997,29109.387499999997,28871.032499999987,28632.684999999998]
[17,24025.621999999988,23287.509999999995,23096.826000000001,22906.148000000001]
[18,18019.216499999995,17465.632499999992,17322.619500000001,17179.61099999999,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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[19,12012.811000000002,11643.75499999999,11548.413,11453.073999999993]
[20,6006.405500000008,5821.8774999999878,5774.2064999999857,5726.5369999999966]
[21,0,0,0,0]
["DSHS/DDA Administrator Regression Table (Rev. 12/2022)",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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]
[]
[]
[]
[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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}},{"$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":{"$error":"#N/A"}}]

{"sheet":"ISS Detail","index":5,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":true,"merged":[[0,9,1,9],[0,10,1,10],[8,0,8,1],[0,1,0,2],[0,3,0,7],[0,0,1,0],[0,8,1,8]]}
["SCHEDULE B LINE/ROW","Working ISS Expenses",null,"Non-working ISS Expenses",null,null,null,null,"TOTALS","SCHEDULE B, COLUMN S","VARIANCE"]
[null,"REG WAGES","2/3 OT WAGES","1/3 OT WAGES","PTO WAGES","OTHER WAGES","ER PAID TAXES","ER PAID BENEFITS"]
["LINE 1",{"$f":"'B - ISS Payroll Expenses'!E73","v":0},{"$f":"'B - ISS Payroll Expenses'!F73/3*2","v":0},{"$f":"'B - ISS Payroll Expenses'!F73/3","v":0},{"$f":"'B - ISS Payroll Expenses'!M73","v":0},{"$f":"'B - ISS Payroll Expenses'!N73","v":0},{"$f":"'B - ISS Payroll Expenses'!P73","v":0},{"$f":"'B - ISS Payroll Expenses'!Q73","v":0},{"$f":"SUM(B3:H3)","v":0},{"$f":"'B - ISS Payroll Expenses'!S73","v":0},{"$f":"J3-I3","v":0}]
["LINE 2",{"$f":"'B - ISS Payroll Expenses'!E74","v":0},{"$f":"'B - ISS Payroll Expenses'!F74/3*2","v":0},{"$f":"'B - ISS Payroll Expenses'!F74/3","v":0},{"$f":"'B - ISS Payroll Expenses'!M74*'B - ISS Payroll Expenses'!G74","v":0},{"$f":"'B - ISS Payroll Expenses'!N74*'B - ISS Payroll Expenses'!G74","v":0},{"$f":"'B - ISS Payroll Expenses'!P74*'B - ISS Payroll Expenses'!G74","v":0},{"$f":"'B - ISS Payroll Expenses'!Q74*'B - ISS Payroll Expenses'!G74","v":0},{"$f":"SUM(B4:H4)","v":0},{"$f":"'B - ISS Payroll Expenses'!S74","v":0},{"$f":"J4-I4","v":0}]
["LINE 3",{"$f":"'B - ISS Payroll Expenses'!E75","v":0},{"$f":"'B - ISS Payroll Expenses'!F75/3*2","v":0},{"$f":"'B - ISS Payroll Expenses'!F75/3","v":0},{"$f":"'B - ISS Payroll Expenses'!M75*'B - ISS Payroll Expenses'!G75","v":0},{"$f":"'B - ISS Payroll Expenses'!N75*'B - ISS Payroll Expenses'!G75","v":0},{"$f":"'B - ISS Payroll Expenses'!P75*'B - ISS Payroll Expenses'!G75","v":0},{"$f":"'B - ISS Payroll Expenses'!Q75*'B - ISS Payroll Expenses'!G75","v":0},0,{"$f":"'B - ISS Payroll Expenses'!S75","v":0},{"$f":"J5-I5","v":0}]
["LINE 4",{"$f":"('B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!E76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76)))","v":{"$error":"#DIV/0!"}},{"$f":"('B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!F76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76))/3)*2","v":{"$error":"#DIV/0!"}},{"$f":"('B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!F76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76)))/3","v":{"$error":"#DIV/0!"}},{"$f":"'B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!M76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76))","v":{"$error":"#DIV/0!"}},{"$f":"'B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!N76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76))","v":{"$error":"#DIV/0!"}},{"$f":"'B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!P76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76))","v":{"$error":"#DIV/0!"}},{"$f":"'B - ISS Payroll Expenses'!S76*('B - ISS Payroll Expenses'!Q76/('B - ISS Payroll Expenses'!E76+'B - ISS Payroll Expenses'!F76+'B - ISS Payroll Expenses'!M76+'B - ISS Payroll Expenses'!N76+'B - ISS Payroll Expenses'!P76+'B - ISS Payroll Expenses'!Q76))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"'B - ISS Payroll Expenses'!S76","v":0},{"$f":"J6-I6","v":{"$error":"#DIV/0!"}}]
["TOTALS",{"$f":"SUM(B3:B6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(C3:C6)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(I3:I6)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(J3:J6)","v":0},{"$f":"SUM(K3:K6)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,{"$f":"I7-SUM(B7:H7)","v":{"$error":"#DIV/0!"}}]
["AVG REGRESSION FTE'S",null,{"$f":"'B - ISS Payroll Expenses'!D76","v":{"$error":"#N/A"}}]
[]
[null," "]

{"sheet":"RES","index":6,"n_rows":75,"n_cols":38,"rows_kept":75,"cut":false,"hidden":true,"merged":[[17,0,17,1],[0,0,15,0],[0,5,15,7]]}
[" ","REGION:",{"$f":"LEFT(_M001742,2)","v":"0"},{"$f":"LEFT(_M001742,2)","v":"0"},{"$f":"LEFT(_M001742,2)","v":"0"}]
[null,"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":"2023 Cost Report - Template"},{"$f":"MID(CELL(\"filename\",B2),FIND(\"[\",CELL(\"filename\",B2))+1,FIND(\".\",CELL(\"filename\",B2),FIND(\"[\",CELL(\"filename\",B2))+1)-FIND(\"[\",CELL(\"filename\",B2))-1)","v":"2023 Cost Report - Template"},{"$f":"MID(CELL(\"filename\",C2),FIND(\"[\",CELL(\"filename\",C2))+1,FIND(\".\",CELL(\"filename\",C2),FIND(\"[\",CELL(\"filename\",C2))+1)-FIND(\"[\",CELL(\"filename\",C2))-1)","v":"2023 Cost Report - Template"}]
[null,"PROVIDER ID:",{"$f":"_C000002","v":""},{"$f":"_C000002","v":""},{"$f":"_C000002","v":""}]
[null,"PROVIDER REGION & NAME:",{"$f":"_M000001","v":0},{"$f":"_M000001","v":0},{"$f":"_M000001","v":0}]
[null,"PROVIDER MAILING ADDRESS:",{"$f":"_M000004","v":0},{"$f":"_M000004","v":0},{"$f":"_M000004","v":0}]
[null,"CITY, STATE, ZIP:",{"$f":"_M000005","v":0},{"$f":"_M000005","v":0},{"$f":"_M000005","v":0}]
[null,"HOME OFFICE MAILING ADDRESS:",{"$f":"IF(_M000011=\"\",\"\",_M000011)","v":""},{"$f":"IF(_M000011=\"\",\"\",_M000011)","v":""},{"$f":"IF(_M000011=\"\",\"\",_M000011)","v":""}]
[null,"HOME OFFICE CITY, STATE, ZIP:",{"$f":"IF(_M000012=\"\",\"\",_M000012)","v":""},{"$f":"IF(_M000012=\"\",\"\",_M000012)","v":""},{"$f":"IF(_M000012=\"\",\"\",_M000012)","v":""}]
[null,"HOME OFFICE PHONE:",{"$f":"IF(_M000013=\"\",\"\",_M000013)","v":""},{"$f":"IF(_M000013=\"\",\"\",_M000013)","v":""},{"$f":"IF(_M000013=\"\",\"\",_M000013)","v":""}]
[null,"ADMINISTRATOR:",{"$f":"_M000007","v":0},{"$f":"_M000007","v":0},{"$f":"_M000007","v":0}]
[null,"ADMINISTRATOR EMAIL:",{"$f":"_M000008","v":0},{"$f":"_M000008","v":0},{"$f":"_M000008","v":0}]
[null,"COST REPORT CONTACT",{"$f":"_M000016","v":0},{"$f":"_M000016","v":0},{"$f":"_M000016","v":0}]
[null,"COST REPORT CONTACT PHONE",{"$f":"_M000017","v":0},{"$f":"_M000017","v":0},{"$f":"_M000017","v":0}]
[null,"COST REPORT CONTACT EMAIL",{"$f":"_M000018","v":0},{"$f":"_M000018","v":0},{"$f":"_M000018","v":0}]
[null,"FEDERAL IDENTIFICATION NUMBER(S)",{"$f":"'A - General Info & Cert'!$D$20","v":0},{"$f":"'A - General Info & Cert'!$D$20","v":0},{"$f":"'A - General Info & Cert'!$D$20","v":0}]
[null,"PURCHASED PROFESSIONAL SERVICES",{"$f":"'C - Non-ISS Expenses'!$H$19","v":0},{"$f":"'C - Non-ISS Expenses'!$H$19","v":0},{"$f":"'C - Non-ISS Expenses'!$H$19","v":0}]
["Line","PROGRAM TYPE","TOTAL SUPPORTED LIVING","TOTAL GROUP HOME & GROUP TRAINING HOME","TOTAL ALL PROGRAMS",{"$f":"'C - Non-ISS Expenses'!_M000101","v":0},{"$f":"'C - Non-ISS Expenses'!_M000102","v":0},{"$f":"'C - Non-ISS Expenses'!_M000105","v":0}]
[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":0},{"$f":"IF(_M001749=\"SL Supported Living\",1,IF(_M001749=\"GH Group Home\",2,IF(_M001749=\"GTH Group Training Home\",3,0)))","v":0},{"$f":"IF(_M001752=\"SL Supported Living\",1,IF(_M001752=\"GH Group Home\",2,IF(_M001752=\"GTH Group Training Home\",3,0)))","v":0}]
[1,"ISS & PROFESSIONAL SERVICES STAFF REGULAR TIME PAYROLL EXPENSES ",{"$f":"SUMIF($F$18:$H$18,1,F19:H19)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F19:H19))+(SUMIF($F$18:$H$18,3,F19:H19))","v":0},{"$f":"SUM(F19:H19)","v":0},{"$f":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$S$73+'B - ISS Payroll Expenses'!$S$74-'B - ISS Payroll Expenses'!$F$73-'B - ISS Payroll Expenses'!$F$74)*(F58/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$S$73+'B - ISS Payroll Expenses'!$S$74-'B - ISS Payroll Expenses'!$F$73-'B - ISS Payroll Expenses'!$F$74)*(G58/_C002601))","v":0},{"$f":"IF($H$18=0,0,('B - ISS Payroll Expenses'!$S$73+'B - ISS Payroll Expenses'!$S$74-'B - ISS Payroll Expenses'!$F$73-'B - ISS Payroll Expenses'!$F$74)*(H58/_C002601))","v":0}]
[2,"ISS & PROFESSIONAL SERVICES STAFF OVERTIME PAYROLL EXPENSES ",0,0,0,{"$f":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$F$73+'B - ISS Payroll Expenses'!$F$74)*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$F$73+'B - ISS Payroll Expenses'!$F$74)*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('B - ISS Payroll Expenses'!$F$73+'B - ISS Payroll Expenses'!$F$74)*(_C002606/_C002601))","v":0}]
[3,"ALLOWABLE GH ADMINISTRATOR ISS REGULAR TIME PAYROLL EXPENSES (GROUP HOME ONLY)",0,0,0,{"$f":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$S$75-'B - ISS Payroll Expenses'!$F$75)*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$S$75-'B - ISS Payroll Expenses'!$F$75)*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('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":"IF($F$18=0,0,'B - ISS Payroll Expenses'!$F$75*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,'B - ISS Payroll Expenses'!$F$75*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,'B - ISS Payroll Expenses'!$F$75*(_C002606/_C002601))","v":0}]
[5,"ALLOWABLE SL/COMB ADMINISTRATOR ISS REGULAR TIME PAYROLL EXPENSES",0,0,0,{"$f":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$S$76-'B - ISS Payroll Expenses'!$F$76)*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$S$76-'B - ISS Payroll Expenses'!$F$76)*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('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":"IF($F$18=0,0,'B - ISS Payroll Expenses'!$F$76*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,'B - ISS Payroll Expenses'!$F$76*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,'B - ISS Payroll Expenses'!$F$76*(_C002606/_C002601))","v":0}]
[null,"TOTAL ISS PAYROLL EXPENSES (SCHEDULE B)",{"$f":"SUM(C19:C24)","v":0},0,0,0,0,0]
[7,"AUTHORIZED PURCHASED/CONTRACTED ISS PROFESSIONAL SERVICES (SCHEDULE G)",{"$f":"SUMIF($F$18:$H$18,1,F26:H26)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F26:H26))+(SUMIF($F$18:$H$18,3,F26:H26))","v":0},{"$f":"SUM(F26:H26)","v":0},{"$f":"SUMIF('G - ISS Settlement'!$E$35:$E$37,F18,'G - ISS Settlement'!$C$35:$C$37)","v":0},{"$f":"SUMIF('G - ISS Settlement'!$E$35:$E$37,G18,'G - ISS Settlement'!$C$35:$C$37)","v":0},{"$f":"SUMIF('G - ISS Settlement'!$E$35:$E$37,H18,'G - ISS Settlement'!$C$35:$C$37)","v":0}]
[null,"TOTAL ISS EXPENSES (SCHEDULE B & SCHEDULE G)",{"$f":"SUM(C25:C26)","v":0},0,0,0,0,0]
[8,"NON-ISS/ ADMINISTRATIVE STAFF REGULAR TIME PAYROLL EXPENSES ",{"$f":"SUMIF($F$18:$H$18,1,F28:H28)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F28:H28))+(SUMIF($F$18:$H$18,3,F28:H28))","v":0},{"$f":"SUM(F28:H28)","v":0},{"$f":"IF($F$18=0,0,('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":0},{"$f":"IF($G$18=0,0,('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":0},{"$f":"IF($H$18=0,0,('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":0}]
[9,"NON-ISS/ ADMINISTRATIVE STAFF OVERTIME PAYROLL EXPENSES ",0,0,0,{"$f":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$I$73+'B - ISS Payroll Expenses'!$I$74)*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$I$73+'B - ISS Payroll Expenses'!$I$74)*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('B - ISS Payroll Expenses'!$I$73+'B - ISS Payroll Expenses'!$I$74)*(_C002606/_C002601))","v":0}]
[10,"NON-ISS/ ADMINISTRATIVE GH ADMINISTRATOR REGULAR TIME PAYROLL EXPENSES",0,0,0,{"$f":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$T$75-'B - ISS Payroll Expenses'!$I$75)*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$T$75-'B - ISS Payroll Expenses'!$I$75)*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('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":"IF($F$18=0,0,'B - ISS Payroll Expenses'!$I$75*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,'B - ISS Payroll Expenses'!$I$75*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('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":"IF($F$18=0,0,('B - ISS Payroll Expenses'!$T$76-'B - ISS Payroll Expenses'!$I$76)*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,('B - ISS Payroll Expenses'!$T$76-'B - ISS Payroll Expenses'!$I$76)*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,('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":"IF($F$18=0,0,'B - ISS Payroll Expenses'!$I$76*(_C002602/_C002601))","v":0},{"$f":"IF($G$18=0,0,'B - ISS Payroll Expenses'!$I$76*(_C002603/_C002601))","v":0},{"$f":"IF($H$18=0,0,'B - ISS Payroll Expenses'!$I$76*(_C002606/_C002601))","v":0}]
[null,"TOTAL NON-ISS/ ADMINISTRATIVE PAYROLL EXPENSES (SCHEDULE B)",{"$f":"SUM(C28:C33)","v":0},{"$f":"SUM(D28:D33)","v":0},{"$f":"SUM(F34:H34)","v":0},{"$f":"SUM(F28:F33)","v":0},{"$f":"SUM(G28:G33)","v":0},{"$f":"SUM(H28:H33)","v":0}]
[14,"ADMINISTRATIVE/ NON-ISS PAYROLL EXPENSES",{"$f":"SUMIF($F$18:$H$18,1,F35:H35)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F35:H35))+(SUMIF($F$18:$H$18,3,F35:H35))","v":0},{"$f":"SUM(F35:H35)","v":0},{"$f":"'C - Non-ISS Expenses'!F39","v":0},{"$f":"'C - Non-ISS Expenses'!G39","v":0},{"$f":"'C - Non-ISS Expenses'!H39","v":0}]
[15,"PROGRAM OPERATIONS EXPENSES",{"$f":"SUMIF($F$18:$H$18,1,F36:H36)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F36:H36))+(SUMIF($F$18:$H$18,3,F36:H36))","v":0},0,{"$f":"'C - Non-ISS Expenses'!F41","v":0},{"$f":"'C - Non-ISS Expenses'!G41","v":0},{"$f":"'C - Non-ISS Expenses'!H41","v":0}]
[16,"CAPITAL & PROPERTY EXPENSES",{"$f":"SUMIF($F$18:$H$18,1,F37:H37)","v":0},0,0,{"$f":"'C - Non-ISS Expenses'!F43","v":0},{"$f":"'C - Non-ISS Expenses'!G43","v":0},{"$f":"'C - Non-ISS Expenses'!H43","v":0}]
[17,"INTEREST & TAX EXPENSES",{"$f":"SUMIF($F$18:$H$18,1,F38:H38)","v":0},0,0,{"$f":"'C - Non-ISS Expenses'!F45","v":0},{"$f":"'C - Non-ISS Expenses'!G45","v":0},{"$f":"'C - Non-ISS Expenses'!H45","v":0}]
[null,"TOTAL NON-ISS ADMINISTRATIVE & OPERATING EXPENSES (SCHEDULE C)",{"$f":"SUM(C35:C38)","v":0},0,0,0,0,0]
[18,"MAINTENANCE/LAUNDRY/HOUSEKEEPING/DIETARY (GROUP HOME ONLY)",{"$f":"SUMIF($F$18:$H$18,1,F40:H40)","v":0},0,0,{"$f":"'C - Non-ISS Expenses'!F48","v":0},{"$f":"'C - Non-ISS Expenses'!G48","v":0},{"$f":"'C - Non-ISS Expenses'!H48","v":0}]
[19,"TRANSPORTATION EXPENSES",{"$f":"SUMIF($F$18:$H$18,1,F41:H41)","v":0},0,0,{"$f":"'C - Non-ISS Expenses'!F50","v":0},{"$f":"'C - Non-ISS Expenses'!G50","v":0},{"$f":"'C - Non-ISS Expenses'!H50","v":0}]
[20,"OTHER NON-ISS CLIENT RELATED EXPENSES",{"$f":"SUMIF($F$18:$H$18,1,F42:H42)","v":0},0,0,{"$f":"'C - Non-ISS Expenses'!F52","v":0},{"$f":"'C - Non-ISS Expenses'!G52","v":0},{"$f":"'C - Non-ISS Expenses'!H52","v":0}]
[null,"TOTAL NON-ISS CLIENT RELATED EXPENSES (SCHEDULE C)",{"$f":"SUM(C40:C42)","v":0},0,0,0,0,0]
[null,"TOTAL NON-ISS/ ADMINISTRATIVE EXPENSES (SCHEDULE B & SCHEDULE C)",{"$f":"C34+C39+C43","v":0},0,0,0,0,0]
[null,"TOTAL PROGRAM EXPENSES (SCHEDULE B, C & G)",{"$f":"C27+C44","v":0},0,0,0,0,0]
[21,"REVENUE FOR SERVICES PROVIDED",{"$f":"SUMIF($F$18:$H$18,1,F46:H46)","v":0},0,0,{"$f":"'D - Revenue'!F8","v":0},{"$f":"'D - Revenue'!G8","v":0},{"$f":"'D - Revenue'!H8","v":0}]
[22,"OTHER OPERATING REVENUE",{"$f":"SUMIF($F$18:$H$18,1,F47:H47)","v":0},0,0,{"$f":"'D - Revenue'!F10","v":0},{"$f":"'D - Revenue'!G10","v":0},{"$f":"'D - Revenue'!H10","v":0}]
[23,"NON OPERATING REVENUE",{"$f":"SUMIF($F$18:$H$18,1,F48:H48)","v":0},0,0,{"$f":"'D - Revenue'!F12","v":0},{"$f":"'D - Revenue'!G12","v":0},{"$f":"'D - Revenue'!H12","v":0}]
[null,"TOTAL REVENUES (SCHEDULE D)",{"$f":"SUM(C46:C48)","v":0},0,0,0,0,0]
[24,"ANNUAL ISS TIERED REIMBURSEMENT",{"$f":"SUMIF($F$18:$H$18,1,F50:H50)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F50:H50))+(SUMIF($F$18:$H$18,3,F50:H50))","v":0},0,{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,25))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,25))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,25))","v":0}]
[25,"ANNUAL ISS CRST REIMBURSEMENT",{"$f":"SUMIF($F$18:$H$18,1,F51:H51)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F51:H51))+(SUMIF($F$18:$H$18,3,F51:H51))","v":0},0,{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,27))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,27))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,27))","v":0}]
[26,"ANNUAL ISS PROFESSIONAL SERVICES PAID",{"$f":"SUMIF($F$18:$H$18,1,F52:H52)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F52:H52))+(SUMIF($F$18:$H$18,3,F52:H52))","v":0},{"$f":"SUM(F52:H52)","v":0},{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,26))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,26))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,26))","v":0}]
[null,"TOTAL ISS TIERED REIMBURSEMENTS (RECONCILED SCHEDULE H)",{"$f":"SUM(C50:C52)","v":0},{"$f":"SUM(D50:D52)","v":0},{"$f":"SUM(F53:H53)","v":0},{"$f":"SUM(F50:F52)","v":0},{"$f":"SUM(G50:G52)","v":0},{"$f":"SUM(H50:H52)","v":0}]
[27,"TOTAL ISS TIERED REIMBURSEMENTS",{"$f":"SUMIF($F$18:$H$18,1,F54:H54)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F54:H54))+(SUMIF($F$18:$H$18,3,F54:H54))","v":0},{"$f":"SUM(F54:H54)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E9:E11,F18,'G - ISS Settlement'!C9:C11)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E9:E11,RES!G18,'G - ISS Settlement'!C9:C11)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E9:E11,RES!H18,'G - ISS Settlement'!C9:C11)","v":0}]
[28,"PROFESSIONAL SERVICES REIMBURSED",{"$f":"SUMIF($F$18:$H$18,1,F55:H55)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F55:H55))+(SUMIF($F$18:$H$18,3,F55:H55))","v":0},{"$f":"SUM(F55:H55)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E24:E26,F18,'G - ISS Settlement'!C24:C26)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E24:E26,G18,'G - ISS Settlement'!C24:C26)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E24:E26,H18,'G - ISS Settlement'!C24:C26)","v":0}]
[29,"NURSE DELEGATION REIMBURSED",{"$f":"SUMIF($F$18:$H$18,1,F56:H56)","v":0},0,0,{"$f":"SUMIF('G - ISS Settlement'!E15:E17,F18,'G - ISS Settlement'!C15:C17)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E15:E17,RES!G18,'G - ISS Settlement'!C15:C17)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E15:E17,RES!H18,'G - ISS Settlement'!C15:C17)","v":0}]
[30,"STAFF ADD ON REIMBURSEMENTS",{"$f":"SUMIF($F$18:$H$18,1,F57:H57)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F57:H57))+(SUMIF($F$18:$H$18,3,F57:H57))","v":0},{"$f":"SUM(F57:H57)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E18:E20,F18,'G - ISS Settlement'!C18:C20)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E18:E20,G18,'G - ISS Settlement'!C18:C20)","v":0},{"$f":"SUMIF('G - ISS Settlement'!E18:E20,H18,'G - ISS Settlement'!C18:C20)","v":0}]
[null,"TOTAL ISS REIMBURSEMENTS (SCHEDULE G)",{"$f":"SUM(C54:C57)","v":0},{"$f":"SUM(D54:D57)","v":0},{"$f":"SUM(F58:H58)","v":0},{"$f":"SUM(F54:F57)","v":0},{"$f":"SUM(G54:G57)","v":0},{"$f":"SUM(H54:H57)","v":0}]
[null,"TOTAL PRELIMINRY SETTLEMENT - ISS REIMBURSEMENTS MINUS ISS EXPENSES (SCHEDULE G)",{"$f":"IF(C58-C27<=0,0,C58-C27)","v":0},{"$f":"IF(D58-D27<=0,0,D58-D27)","v":0},{"$f":"(E58-E27)","v":0},{"$f":"(F58-F27)","v":0},{"$f":"(G58-G27)","v":0},{"$f":"(H58-H27)","v":0}]
[31,"ANNUAL NON-ISS/ AMININISTRATIVE REIMBURSEMENTS",{"$f":"SUMIF($F$18:$H$18,1,F60:H60)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F60:H60))+(SUMIF($F$18:$H$18,3,F60:H60))","v":0},{"$f":"SUM(F60:H60)","v":0},{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,29))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,29))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,29))","v":0}]
[32,"ANNUAL NON-ISS TEMPORARY RATE ADJUSTMENT REIMBURSEMENTS",0,0,{"$f":"SUM(F61:H61)","v":0},{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,30))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,30))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,30))","v":0}]
[33,"ANNUAL NON-ISS/ ADMINISTRATIVE CRST REIMBURSEMENTS",0,0,0,{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,31))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,31))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,31))","v":0}]
[34,"ANNUAL NON-ISS  ADMIN CERT RATE REIMBURSEMENTS",0,0,0,{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,32))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,32))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,32))","v":0}]
[35,"ANNUAL NON-ISS TRANSPORTATION REIMBURSEMENTS",0,0,0,{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,33))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,33))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,33))","v":0}]
[36,"ANNUAL NON-ISS OTHER REIMBURSEMENTS",0,0,0,{"$f":"IF($F$18=0,0,VLOOKUP($F$18,RES!$A$73:$AL$75,34))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP($G$18,RES!$A$73:$AL$75,34))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP($H$18,RES!$A$73:$AL$75,34))","v":0}]
[null,"TOTAL NON-ISS/ADMINISTRATIVE REIMBURSEMENTS (RECONCILED SCHEDULE H)",{"$f":"SUM(C60:C65)","v":0},0,0,0,0,0]
[null,"NET NON-ISS/ ADMIN INCOME/LOSS (RECONCILED SCHEDULE H LESS SCHEDULE B & C EXPENSES) ",{"$f":"C66-C44","v":0},0,0,0,0,0]
[37,"CLIENT DAYS",{"$f":"SUMIF($F$18:$H$18,1,F68:H68)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F68:H68))+(SUMIF($F$18:$H$18,3,F68:H68))","v":0},0,{"$f":"IF($F$18=0,0,VLOOKUP(RES!F18,RES!$A$73:$AL$75,10))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP(RES!$G$18,RES!$A$73:$AL$75,10))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP(RES!H18,RES!$A$73:$AL$75,10))","v":0}]
[38,"NUMBER OF CLIENTS (SCH H)",{"$f":"SUMIF($F$18:$H$18,1,F69:H69)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F69:H69))+(SUMIF($F$18:$H$18,3,F69:H69))","v":0},{"$f":"SUM(F69:H69)","v":0},{"$f":"IF($F$18=0,0,VLOOKUP(RES!F18,RES!$A$73:$AL$75,11))","v":0},{"$f":"IF($G$18=0,0,VLOOKUP(RES!G18,RES!$A$73:$AL$75,11))","v":0},{"$f":"IF($H$18=0,0,VLOOKUP(RES!H18,RES!$A$73:$AL$75,11))","v":0}]
[39,"NUMBER OF CLIENTS (SCH H CLIENT DAYS/365)",{"$f":"SUMIF($F$18:$H$18,1,F70:H70)","v":0},{"$f":"(SUMIF($F$18:$H$18,2,F70:H70))+(SUMIF($F$18:$H$18,3,F70:H70))","v":0},{"$f":"SUM(F70:H70)","v":0},{"$f":"ROUND(F68/365,0)","v":0},{"$f":"ROUND(G68/365,0)","v":0},{"$f":"ROUND(H68/365,0)","v":0}]
[]
[null,"Schedule H Rate History Total Lines 1-3",null,null,"Program Type",null,null,null,null,"Resid Days Paid","Client Count",null,null,null,null,"Total ISS Daily Rate",null,null,null,null,null,null,"Total Non-ISS Daily Rate","Total ISS & Non-ISS Daily Rate","Annual ISS Paid","Annual ISS Prof Svs Paid","Annual ISS CRST Paid","Total Annual ISS Paid","Annual Admin Paid","Annual Temp Rate Adjust","Annual Admin CRST Paid","Annual Admin Cert Paid","Annual Transport Paid","Annual Other Non-ISS Paid","Total Annual Non-ISS Paid","Annual ISS & Non-ISS Paid","Annual ISS & Non-ISS Paid per Client","Annual Days Paid per Client"]
[1,null,null,null,"SL Supported Living",null,null,null,null,3788,16,null,null,null,null,5151.3499999999995,null,null,null,null,null,null,1717.0085000000001,6868.3585000000012,781703.71000000008,9614.0799999999981,14930.43,806248.22000000009,135580.62000000002,88687.30419999997,3741.01,9412.5,11102.199999999999,19818.71,268342.34420000005,1074590.5642000001,1074590.5642000001,3788]
[2,null,null,null,"GH Group Home",null,null,null,null,1059,3,null,null,null,null,827.6,null,null,null,null,null,null,331.57600000000002,1159.1759999999999,230427.63999999998,1402.75,4283.4299999999994,236113.82,59758.680000000008,25972.520200000003,1075.2400000000002,2647.5,0,452.5,89906.440200000012,326020.26020000002,326020.26020000002,1059]
[3,null,null,null,"GTH Group Training Home",null,null,null,null,1021,3,null,null,null,null,821.98,null,null,null,null,null,null,276.74780000000004,1098.7278000000001,278004.26,0,5167.16,283171.42,58797.43,31148.856200000002,1295.44,2552.5,0,912.5,94706.726200000005,377878.14619999996,377878.14619999996,1021]

{"sheet":"Checklist","index":7,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":true,"merged":[[0,0,0,4],[2,1,2,3],[17,3,18,3],[17,4,18,4]]}
["RESIDENTIAL COST REPORT ANALYSIS CHECKLIST"]
[null,"Agency Region & Name:"]
[null,{"$f":"'A - General Info & Cert'!B6:C6","v":0}]
[]
[null,"Upon receiving a cost report the analyst does the following for each schedule: "]
[]
[null,"Analyst Initials","Date Analyzed","Schedule","To Be Reviewed/Analyzed"]
[null,null,null,"Schedule A ","Verify correct provider name is selected in box 1 drop down list\nBe sure there is contact information for questions\nCheck for dates in line 18\nSigned certification is received via scan, fax, or mail"]
[null,null,null,"Schedule B","Verify that the appropriate reporting period is selected. If quarterly is selected only March, June, September, and December sections should have data entered. If an agency closes before year end the formula in C61 needs to have the number of months/quarters changed to how ever many months/quarters the agency was open during the calendar year.\n\nFor each payroll reporting period (month/quarter) review the following:\nRow 1 - Check for reasonableness: If there are wages reported in columns D & E then in theory there should be amounts reported in columns O & P and possibly in column L.\nRow 2 - Check for reasonableness: Payroll reported on row 2 is for employees that perform ISS and non-ISS duties so in addition to ISS payroll in columns D & E verify that there is administrative or non-contracted payroll entered in columns G, H, or J. If a provider did not report any payroll on row 1 and only entered payroll on row 2 verify that all the payroll reported on row 2 is for employee's that work ISS and something else (i.e. administrative/non-contracted business). If there are employees that only perform contracted ISS included on row 2 the report will need to be returned for correction. If there are wages reported in columns D & E then in theory there should be amounts reported in columns O & P and possibly in column L.\nRow 3 - Check for reasonableness: Payroll reported here should be for a Group Home or Group Training Home Administrator (a single employee) that performs ISS duties. If the Administrator does not perform ISS then this row should be blank.\nRow 4 - Check for reasonableness: Payroll reported here should be for a Supported Living or Combined SL/GH/GTH Administrator (a single employee) that performs ISS duties. If the Administrator does not perform ISS then this row should be blank. Review formula in cell C61 to verify that the number of months or quarters are correct. If the number of clients in cell C61 is more than 20 then verify that cell R61 is zero.\n\nEvery agency needs to have Administrative payroll expenses - verify there is administrative payroll in cell G61 or on Schedule C, line 1.\nVerify the provider reported payroll taxes in cell O61.\nIf cell P61 is zero verify with the employer that they do not pay for any taxable or non-taxable fringe benefits for their employees.\n "]
[null,null,null,"Schedule C","Verify provider completed questions 1-2.\n1. If yes, and there are amounts posted to Schedule G, lines 29-31 verify with the resource manager if purchased professional services was authorized in the client's assessment.\n2. If yes, and \"Other Method\" was selected in 2c, determine if the method described is reasonable. \n\nAdministrative & Operating Costs (Non-ISS Costs) are not settled and therefore do not need to be analyzed.\nVerify that an \"Agency Type\" was selected in any columns (A-C) that have amounts reported. If not return to provider for correction."]
[null,null,null,"Schedule D","Verify line 1 has amounts posted in any column that has a program type selected in columns A-C.\nCompare to revenues recived on Schedule H, cell AT2; in theory these numbers should equal."]
[null,null,null,"Schedule E","Verify that the agency completed the correct number of Schedule O's.\nAll areas must be completed.\nSave a copy to the survey folder: S:\\Shared_Data\\Cost Reimbursement\\Surveys\\Residential Wage & Turnover results"]
[null,null,null,"Schedule F","Health Insurance section must be completed.\nLine 11 - reported as percentages\nLine 12 - reported as yes or no\nSave a copy to the survey folder: S:\\Shared_Data\\Cost Reimbursement\\Surveys\\ACA Survey"]
[null,null,null,"Schedule G\n(Settlement)","Lines 1-3: \nUse the department’s internal reconciliation of contracted days and reimbursements from Schedule H Rate History to verify or revise the program type and/or the amounts reported by the provider.  \nLines 5-13:\nUse the departments internal reconciliation \"Other Codes\" tab to verify or revise the program type and/or the amounts reported by the provider.\nLines 15-20\nUse the department’s internal reconciliation of contracted days and reimbursements from Schedule H Rate History to verify or revise the professional services type and amount reported.\nLines 26-28\nVerify that the appropriate program type was selected from the drop down list and verify with the resource manager that purchased professional services is authorized in the client's assessment. "]
[null,null,null,"RES tab","Copy & paste the last three rows of Schedule H to the RES tab rows 60-62 to correct the column difference.\nCopy & paste as values the same last three rows of Schedule H to the RES tab to remove the formulas.\nSave the file and rename it by adding \"Final\" after the dash (-) if it is a zero settlement or \"Final$\" after the dash (-) if there is an amount due.\nCopy the appropriate RES tab column(s) to the settlement summary tab on the Cost Report Analysis Checklist & Settlement Summary file on sharepoint."]
[null,null,null,"ISS Payroll Verification (Complete section if selected for ISS Payroll review)","Upon accepting the annual cost report, email the provider requesting them to submit their ISS payroll supporting documentation for specified months/quarter and to complete the Provider Employee Data Form. \nPlace all documentation received from the provider in the Payroll Verification sub-folder within the regional Cost Report and Settlement Data folder for the respective year at this location: S:\\Shared_Data\\Cost Reimbursement\\Residential\\Residential Cost Report Settlements\nUsing the providers source documents, compare and analyze the Provider Employee Data information to the ISS payroll detail to locate any inconsistencies and to check for reasonableness.\nUsing the departments standardized payroll review worksheet, analyze and compare the ISS payroll detail (source documents) to the amounts reported on Schedule B, including accruals for January and December. Supporting documentation must demonstrate how their detail ties to amounts reported on Schedule B.\nReview all employees whose job duties are split between ISS and non-ISS/Admin, check for reasonableness.  \nVariances over 2% must be resolved and may require a larger sample to be pulled. If a full year review is warranted, the employee W-2’s and/or ESD reports may be used for further analysis. \nEnter payroll review data, explanations, and results on the residential tracking log.\nNotify DDA and section manager when the review is completed, including findings. "]
[]
[null,null,null,"Lead/Supervisor Checklist Review","1. Review all cost report schedules (A-H) and resulting settlement for accuracy, completeness, & reasonableness\n2. Confirm the following:\n     a) Schedule G, Line 4, Column C equals Schedule H, cell Y2 plus AA2\n     b) Schedule G, Line 15, Column C equals Schedule H, cell Z2\n     c) Schedule G, Lines 5 + 6 + 7 equals \"Other Codes\" tab procedure codes SA452 plus SA453 (Nurse Delegation)\n     d) Schedule G, Lines 8 + 9 + 10 equals \"Other Codes\" tab procedure codes SA719 plus SA725 (Staff Add On)\n3. Evaluate/examine all ISS payroll review analysis summary files for accuracy, completeness, & reasonableness"]
[null,"(initials)","(Date)"]

{"sheet":"ReadMe","index":8,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,3],[2,1,2,3],[28,1,28,3],[29,2,29,3],[20,1,20,3],[22,1,22,3],[24,1,24,3],[26,1,26,3],[10,1,10,3],[12,1,12,3],[18,1,18,3],[5,1,5,3],[6,1,6,3],[8,1,8,3],[3,1,3,3],[14,1,14,3],[16,1,16,3],[30,1,30,3]]}
[]
[null,"DDA Residential Programs Cost Report General Guidelines"]
[]
[null,"1. For 2023, the Administrator Regression table maximums have been increased 2% relative to the increase in the daily rate and covid funds have been reduced from 7.3% to 5.4%, effective January 1, 2023. Four questions have been added to Schedule C and Schedule E has been revised to report staffing on a semiannual basis. The ISS payroll review is still being developed and will be presented once complete."]
[]
[null,"2. It is recommended that the cost report preparer refer to the cost reporting instructions, DDA policy 6.04, PowerPoint Presentation and template samples while completing their cost report. Select the link below for Covid reporting requirements."]
[null,"Covid Reporting Requirements"]
[]
[null,"3. The completed cost report must be submitted in excel format using the 12/2022 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 does not accept Cost Report 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. Schedule A will need to be recertified each time a cost report or revised cost report is submitted. "]
[]
[null,"4. Providers are to fill in cells that are formatted white. Cells that are formatted in yellow or grey 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,"5. 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,"6. 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. "]
[]
[null,"7. 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,"8. 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 for different margins or use slightly different font sizes that may cause schedules to not fit as they were designed."]
[]
[null,"9. On Schedule A, please include your current contact information for your agency and the cost report preparer, including email addresses."]
[]
[null,"10. 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. Optional Schedule H – Rate History and Schedule I – Non-ISS Expenses are for internal use only."]
[]
[null,"11. 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,"12.  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) 995-2810","kenneth.callaghan@dshs.wa.gov"]
[null,"Tod Johnson, Analyst - Regions 1 & SOLA","(360) 915-6997","tod.johnson@dshs.wa.gov"]
[null,"Charlene Hunt, Analyst - Regions 2 & RHC","(360) 725-2441","charlene.hunt@dshs.wa.gov"]
[null,"Tammy Paulk, Analyst - Region 3 & LSR","(360) 725-2498","tammy.paulk@dshs.wa.gov"]

{"sheet":"A - General Info & Cert","index":9,"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],[4,1,4,2],[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,null,null,{"$f":"IF(_M000001=\"\",\"\",VLOOKUP(_M000001,Lists!$A$4:$B$144,2,FALSE))","v":""}]
[null,"3. PROVIDER MAILING ADDRESS","4. CITY, STATE, ZIP ","5. PROVIDER PHONE NUMBER"]
[]
[null,"6. ADMINISTRATOR NAME","7. ADMINISTRATOR E-MAIL","8. ADMINISTRATOR PHONE NUMBER"]
[]
[null,"9. HOME OFFICE/CORPORATE NAME (please indicate if NONE or SAME AS ABOVE)"]
[]
[null,"10. HOME OFFICE MAILING ADDRESS","11. CITY, STATE, ZIP","12. HOME OFFICE PHONE NUMBER"]
[]
[null,"13. COST REPORT PREPARER","14. FIRM NAME"]
[]
[null,"15. REPORT CONTACT INDIVIDUAL(S)","16. CONTACT PHONE NUMBER","17. CONTACT EMAIL"]
[]
[null,"18. COST REPORT PERIOD",null,"19. FEDERAL ID NUMBER(S)"]
[null,"2023-01-01","2023-12-31"]
[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," "]
[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,"PERSON SIGNING MUST HAVE AUTHORITY TO BIND THE PROVIDER LISTED"]
[]
[null,null,"TITLE","DATE"]
[]
[]
[null,"DSHS/DDA Schedule A (Rev. 12/2022)"]

{"sheet":"B - ISS Payroll Expenses","index":10,"n_rows":79,"n_cols":21,"rows_kept":79,"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":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[]
[]
[null,null,"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 (REGULAR TIME)","ISS GROSS PAYROLL FOR STAFF (OVERTIME)","ISS % OF TOTAL GROSS PAYROLL","ADMINISTRATIVE/ NON-ISS GROSS PAYROLL FOR STAFF (REGULAR 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":{"$error":"#N/A"}},0,0,{"$f":"IF((E13+F13)<=0,0,SUM(E13+F13)/SUM(E13+F13+H13+I13+K13))","v":0},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},0,0,{"$f":"SUM(E13+F13+H13+I13+M13+N13+K13)","v":0},0,0,{"$f":"SUM(O13:Q13)","v":0},{"$f":"ROUND(SUM(E13+F13),2)+ROUND(SUM(M13+N13+P13+Q13)*G13,2)","v":0},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,0,0,{"$f":"IF((E14+F14)<=0,0,SUM(E14+F14)/SUM(E14+F14+H14+I14+K14))","v":0},0,0,{"$f":"IF((H14+I14)<=0,0,SUM(H14+I14)/SUM(E14+F14+H14+I14+K14))","v":0},0,{"$f":"IF(K14<=0,0,K14/SUM(E14+F14+H14+I14+K14))","v":0},0,0,{"$f":"SUM(E14+F14+H14+I14+M14+N14+K14)","v":0},0,0,{"$f":"SUM(O14:Q14)","v":0},{"$f":"ROUND(SUM(E14+F14),2)+ROUND(SUM(M14+N14+P14+Q14)*G14,2)","v":0},{"$f":"ROUND(SUM(H14+I14),2)+ROUND(SUM(M14+N14+P14+Q14)*J14,2)","v":0},{"$f":"K14+ROUND(SUM(M14+N14+P14+Q14)*L14,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F13:F16)","v":0},null,{"$f":"SUM(H13:H16)","v":0},{"$f":"SUM(I13:I16)","v":0},null,{"$f":"SUM(K13:K16)","v":0},null,{"$f":"SUM(M13:M16)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E18+F18)<=0,0,SUM(E18+F18)/SUM(E18+F18+H18+I18+K18))","v":0},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},0,0,{"$f":"SUM(E18+F18+H18+I18+M18+N18+K18)","v":0},0,0,{"$f":"SUM(O18:Q18)","v":0},{"$f":"ROUND(SUM(E18+F18),2)+ROUND(SUM(M18+N18+P18+Q18)*G18,2)","v":0},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,0,0,{"$f":"IF((E19+F19)<=0,0,SUM(E19+F19)/SUM(E19+F19+H19+I19+K19))","v":0},0,0,{"$f":"IF((H19+I19)<=0,0,SUM(H19+I19)/SUM(E19+F19+H19+I19+K19))","v":0},0,{"$f":"IF(K19<=0,0,K19/SUM(E19+F19+H19+I19+K19))","v":0},0,0,{"$f":"SUM(E19+F19+H19+I19+M19+N19+K19)","v":0},0,0,{"$f":"SUM(O19:Q19)","v":0},{"$f":"ROUND(SUM(E19+F19),2)+ROUND(SUM(M19+N19+P19+Q19)*G19,2)","v":0},{"$f":"ROUND(SUM(H19+I19),2)+ROUND(SUM(M19+N19+P19+Q19)*J19,2)","v":0},{"$f":"K19+ROUND(SUM(M19+N19+P19+Q19)*L19,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F18:F21)","v":0},null,{"$f":"SUM(H18:H21)","v":0},{"$f":"SUM(I18:I21)","v":0},null,{"$f":"SUM(K18:K21)","v":0},null,{"$f":"SUM(M18:M21)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E23+F23)<=0,0,SUM(E23+F23)/SUM(E23+F23+H23+I23+K23))","v":0},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},0,0,{"$f":"SUM(E23+F23+H23+I23+M23+N23+K23)","v":0},0,0,{"$f":"SUM(O23:Q23)","v":0},{"$f":"ROUND(SUM(E23+F23),2)+ROUND(SUM(M23+N23+P23+Q23)*G23,2)","v":0},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,0,0,{"$f":"IF((E24+F24)<=0,0,SUM(E24+F24)/SUM(E24+F24+H24+I24+K24))","v":0},0,0,{"$f":"IF((H24+I24)<=0,0,SUM(H24+I24)/SUM(E24+F24+H24+I24+K24))","v":0},0,{"$f":"IF(K24<=0,0,K24/SUM(E24+F24+H24+I24+K24))","v":0},0,0,{"$f":"SUM(E24+F24+H24+I24+M24+N24+K24)","v":0},0,0,{"$f":"SUM(O24:Q24)","v":0},{"$f":"ROUND(SUM(E24+F24),2)+ROUND(SUM(M24+N24+P24+Q24)*G24,2)","v":0},{"$f":"ROUND(SUM(H24+I24),2)+ROUND(SUM(M24+N24+P24+Q24)*J24,2)","v":0},{"$f":"K24+ROUND(SUM(M24+N24+P24+Q24)*L24,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F23:F26)","v":0},null,{"$f":"SUM(H23:H26)","v":0},{"$f":"SUM(I23:I26)","v":0},null,{"$f":"SUM(K23:K26)","v":0},null,{"$f":"SUM(M23:M26)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E28+F28)<=0,0,SUM(E28+F28)/SUM(E28+F28+H28+I28+K28))","v":0},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},0,0,{"$f":"SUM(E28+F28+H28+I28+M28+N28+K28)","v":0},0,0,{"$f":"SUM(O28:Q28)","v":0},{"$f":"ROUND(SUM(E28+F28),2)+ROUND(SUM(M28+N28+P28+Q28)*G28,2)","v":0},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,0,0,{"$f":"IF((E29+F29)<=0,0,SUM(E29+F29)/SUM(E29+F29+H29+I29+K29))","v":0},0,0,{"$f":"IF((H29+I29)<=0,0,SUM(H29+I29)/SUM(E29+F29+H29+I29+K29))","v":0},0,{"$f":"IF(K29<=0,0,K29/SUM(E29+F29+H29+I29+K29))","v":0},0,0,{"$f":"SUM(E29+F29+H29+I29+M29+N29+K29)","v":0},0,0,{"$f":"SUM(O29:Q29)","v":0},{"$f":"ROUND(SUM(E29+F29),2)+ROUND(SUM(M29+N29+P29+Q29)*G29,2)","v":0},{"$f":"ROUND(SUM(H29+I29),2)+ROUND(SUM(M29+N29+P29+Q29)*J29,2)","v":0},{"$f":"K29+ROUND(SUM(M29+N29+P29+Q29)*L29,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F28:F31)","v":0},null,{"$f":"SUM(H28:H31)","v":0},{"$f":"SUM(I28:I31)","v":0},null,{"$f":"SUM(K28:K31)","v":0},null,{"$f":"SUM(M28:M31)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E33+F33)<=0,0,SUM(E33+F33)/SUM(E33+F33+H33+I33+K33))","v":0},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},0,0,{"$f":"SUM(E33+F33+H33+I33+M33+N33+K33)","v":0},0,0,{"$f":"SUM(O33:Q33)","v":0},{"$f":"ROUND(SUM(E33+F33),2)+ROUND(SUM(M33+N33+P33+Q33)*G33,2)","v":0},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,0,0,{"$f":"IF((E34+F34)<=0,0,SUM(E34+F34)/SUM(E34+F34+H34+I34+K34))","v":0},0,0,{"$f":"IF((H34+I34)<=0,0,SUM(H34+I34)/SUM(E34+F34+H34+I34+K34))","v":0},0,{"$f":"IF(K34<=0,0,K34/SUM(E34+F34+H34+I34+K34))","v":0},0,0,{"$f":"SUM(E34+F34+H34+I34+M34+N34+K34)","v":0},0,0,{"$f":"SUM(O34:Q34)","v":0},{"$f":"ROUND(SUM(E34+F34),2)+ROUND(SUM(M34+N34+P34+Q34)*G34,2)","v":0},{"$f":"ROUND(SUM(H34+I34),2)+ROUND(SUM(M34+N34+P34+Q34)*J34,2)","v":0},{"$f":"K34+ROUND(SUM(M34+N34+P34+Q34)*L34,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F33:F36)","v":0},null,{"$f":"SUM(H33:H36)","v":0},{"$f":"SUM(I33:I36)","v":0},null,{"$f":"SUM(K33:K36)","v":0},null,{"$f":"SUM(M33:M36)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E38+F38)<=0,0,SUM(E38+F38)/SUM(E38+F38+H38+I38+K38))","v":0},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},0,0,{"$f":"SUM(E38+F38+H38+I38+M38+N38+K38)","v":0},0,0,{"$f":"SUM(O38:Q38)","v":0},{"$f":"ROUND(SUM(E38+F38),2)+ROUND(SUM(M38+N38+P38+Q38)*G38,2)","v":0},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,0,0,{"$f":"IF((E39+F39)<=0,0,SUM(E39+F39)/SUM(E39+F39+H39+I39+K39))","v":0},0,0,{"$f":"IF((H39+I39)<=0,0,SUM(H39+I39)/SUM(E39+F39+H39+I39+K39))","v":0},0,{"$f":"IF(K39<=0,0,K39/SUM(E39+F39+H39+I39+K39))","v":0},0,0,{"$f":"SUM(E39+F39+H39+I39+M39+N39+K39)","v":0},0,0,{"$f":"SUM(O39:Q39)","v":0},{"$f":"ROUND(SUM(E39+F39),2)+ROUND(SUM(M39+N39+P39+Q39)*G39,2)","v":0},{"$f":"ROUND(SUM(H39+I39),2)+ROUND(SUM(M39+N39+P39+Q39)*J39,2)","v":0},{"$f":"K39+ROUND(SUM(M39+N39+P39+Q39)*L39,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F38:F41)","v":0},null,{"$f":"SUM(H38:H41)","v":0},{"$f":"SUM(I38:I41)","v":0},null,{"$f":"SUM(K38:K41)","v":0},null,{"$f":"SUM(M38:M41)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E43+F43)<=0,0,SUM(E43+F43)/SUM(E43+F43+H43+I43+K43))","v":0},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},0,0,{"$f":"SUM(E43+F43+H43+I43+M43+N43+K43)","v":0},0,0,{"$f":"SUM(O43:Q43)","v":0},{"$f":"ROUND(SUM(E43+F43),2)+ROUND(SUM(M43+N43+P43+Q43)*G43,2)","v":0},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,0,0,{"$f":"IF((E44+F44)<=0,0,SUM(E44+F44)/SUM(E44+F44+H44+I44+K44))","v":0},0,0,{"$f":"IF((H44+I44)<=0,0,SUM(H44+I44)/SUM(E44+F44+H44+I44+K44))","v":0},0,{"$f":"IF(K44<=0,0,K44/SUM(E44+F44+H44+I44+K44))","v":0},0,0,{"$f":"SUM(E44+F44+H44+I44+M44+N44+K44)","v":0},0,0,{"$f":"SUM(O44:Q44)","v":0},{"$f":"ROUND(SUM(E44+F44),2)+ROUND(SUM(M44+N44+P44+Q44)*G44,2)","v":0},{"$f":"ROUND(SUM(H44+I44),2)+ROUND(SUM(M44+N44+P44+Q44)*J44,2)","v":0},{"$f":"K44+ROUND(SUM(M44+N44+P44+Q44)*L44,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F43:F46)","v":0},null,{"$f":"SUM(H43:H46)","v":0},{"$f":"SUM(I43:I46)","v":0},null,{"$f":"SUM(K43:K46)","v":0},null,{"$f":"SUM(M43:M46)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E48+F48)<=0,0,SUM(E48+F48)/SUM(E48+F48+H48+I48+K48))","v":0},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},0,0,{"$f":"SUM(E48+F48+H48+I48+M48+N48+K48)","v":0},0,0,{"$f":"SUM(O48:Q48)","v":0},{"$f":"ROUND(SUM(E48+F48),2)+ROUND(SUM(M48+N48+P48+Q48)*G48,2)","v":0},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,0,0,{"$f":"IF((E49+F49)<=0,0,SUM(E49+F49)/SUM(E49+F49+H49+I49+K49))","v":0},0,0,{"$f":"IF((H49+I49)<=0,0,SUM(H49+I49)/SUM(E49+F49+H49+I49+K49))","v":0},0,{"$f":"IF(K49<=0,0,K49/SUM(E49+F49+H49+I49+K49))","v":0},0,0,{"$f":"SUM(E49+F49+H49+I49+M49+N49+K49)","v":0},0,0,{"$f":"SUM(O49:Q49)","v":0},{"$f":"ROUND(SUM(E49+F49),2)+ROUND(SUM(M49+N49+P49+Q49)*G49,2)","v":0},{"$f":"ROUND(SUM(H49+I49),2)+ROUND(SUM(M49+N49+P49+Q49)*J49,2)","v":0},{"$f":"K49+ROUND(SUM(M49+N49+P49+Q49)*L49,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F48:F51)","v":0},null,{"$f":"SUM(H48:H51)","v":0},{"$f":"SUM(I48:I51)","v":0},null,{"$f":"SUM(K48:K51)","v":0},null,{"$f":"SUM(M48:M51)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E53+F53)<=0,0,SUM(E53+F53)/SUM(E53+F53+H53+I53+K53))","v":0},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},0,0,{"$f":"SUM(E53+F53+H53+I53+M53+N53+K53)","v":0},0,0,{"$f":"SUM(O53:Q53)","v":0},{"$f":"ROUND(SUM(E53+F53),2)+ROUND(SUM(M53+N53+P53+Q53)*G53,2)","v":0},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,0,0,{"$f":"IF((E54+F54)<=0,0,SUM(E54+F54)/SUM(E54+F54+H54+I54+K54))","v":0},0,0,{"$f":"IF((H54+I54)<=0,0,SUM(H54+I54)/SUM(E54+F54+H54+I54+K54))","v":0},0,{"$f":"IF(K54<=0,0,K54/SUM(E54+F54+H54+I54+K54))","v":0},0,0,{"$f":"SUM(E54+F54+H54+I54+M54+N54+K54)","v":0},0,0,{"$f":"SUM(O54:Q54)","v":0},{"$f":"ROUND(SUM(E54+F54),2)+ROUND(SUM(M54+N54+P54+Q54)*G54,2)","v":0},{"$f":"ROUND(SUM(H54+I54),2)+ROUND(SUM(M54+N54+P54+Q54)*J54,2)","v":0},{"$f":"K54+ROUND(SUM(M54+N54+P54+Q54)*L54,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F53:F56)","v":0},null,{"$f":"SUM(H53:H56)","v":0},{"$f":"SUM(I53:I56)","v":0},null,{"$f":"SUM(K53:K56)","v":0},null,{"$f":"SUM(M53:M56)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E58+F58)<=0,0,SUM(E58+F58)/SUM(E58+F58+H58+I58+K58))","v":0},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},0,0,{"$f":"SUM(E58+F58+H58+I58+M58+N58+K58)","v":0},0,0,{"$f":"SUM(O58:Q58)","v":0},{"$f":"ROUND(SUM(E58+F58),2)+ROUND(SUM(M58+N58+P58+Q58)*G58,2)","v":0},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,0,0,{"$f":"IF((E59+F59)<=0,0,SUM(E59+F59)/SUM(E59+F59+H59+I59+K59))","v":0},0,0,{"$f":"IF((H59+I59)<=0,0,SUM(H59+I59)/SUM(E59+F59+H59+I59+K59))","v":0},0,{"$f":"IF(K59<=0,0,K59/SUM(E59+F59+H59+I59+K59))","v":0},0,0,{"$f":"SUM(E59+F59+H59+I59+M59+N59+K59)","v":0},0,0,{"$f":"SUM(O59:Q59)","v":0},{"$f":"ROUND(SUM(E59+F59),2)+ROUND(SUM(M59+N59+P59+Q59)*G59,2)","v":0},{"$f":"ROUND(SUM(H59+I59),2)+ROUND(SUM(M59+N59+P59+Q59)*J59,2)","v":0},{"$f":"K59+ROUND(SUM(M59+N59+P59+Q59)*L59,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F58:F61)","v":0},null,{"$f":"SUM(H58:H61)","v":0},{"$f":"SUM(I58:I61)","v":0},null,{"$f":"SUM(K58:K61)","v":0},null,{"$f":"SUM(M58:M61)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E63+F63)<=0,0,SUM(E63+F63)/SUM(E63+F63+H63+I63+K63))","v":0},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},0,0,{"$f":"SUM(E63+F63+H63+I63+M63+N63+K63)","v":0},0,0,{"$f":"SUM(O63:Q63)","v":0},{"$f":"ROUND(SUM(E63+F63),2)+ROUND(SUM(M63+N63+P63+Q63)*G63,2)","v":0},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,0,0,{"$f":"IF((E64+F64)<=0,0,SUM(E64+F64)/SUM(E64+F64+H64+I64+K64))","v":0},0,0,{"$f":"IF((H64+I64)<=0,0,SUM(H64+I64)/SUM(E64+F64+H64+I64+K64))","v":0},0,{"$f":"IF(K64<=0,0,K64/SUM(E64+F64+H64+I64+K64))","v":0},0,0,{"$f":"SUM(E64+F64+H64+I64+M64+N64+K64)","v":0},0,0,{"$f":"SUM(O64:Q64)","v":0},{"$f":"ROUND(SUM(E64+F64),2)+ROUND(SUM(M64+N64+P64+Q64)*G64,2)","v":0},{"$f":"ROUND(SUM(H64+I64),2)+ROUND(SUM(M64+N64+P64+Q64)*J64,2)","v":0},{"$f":"K64+ROUND(SUM(M64+N64+P64+Q64)*L64,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F63:F66)","v":0},null,{"$f":"SUM(H63:H66)","v":0},{"$f":"SUM(I63:I66)","v":0},null,{"$f":"SUM(K63:K66)","v":0},null,{"$f":"SUM(M63:M66)","v":0},0,0,0,0,0,0,0,0]
[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":{"$error":"#N/A"}},0,0,{"$f":"IF((E68+F68)<=0,0,SUM(E68+F68)/SUM(E68+F68+H68+I68+K68))","v":0},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},0,0,{"$f":"SUM(E68+F68+H68+I68+M68+N68+K68)","v":0},0,0,{"$f":"SUM(O68:Q68)","v":0},{"$f":"ROUND(SUM(E68+F68),2)+ROUND(SUM(M68+N68+P68+Q68)*G68,2)","v":0},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,0,0,{"$f":"IF((E69+F69)<=0,0,SUM(E69+F69)/SUM(E69+F69+H69+I69+K69))","v":0},0,0,{"$f":"IF((H69+I69)<=0,0,SUM(H69+I69)/SUM(E69+F69+H69+I69+K69))","v":0},0,{"$f":"IF(K69<=0,0,K69/SUM(E69+F69+H69+I69+K69))","v":0},0,0,{"$f":"SUM(E69+F69+H69+I69+M69+N69+K69)","v":0},0,0,{"$f":"SUM(O69:Q69)","v":0},{"$f":"ROUND(SUM(E69+F69),2)+ROUND(SUM(M69+N69+P69+Q69)*G69,2)","v":0},{"$f":"ROUND(SUM(H69+I69),2)+ROUND(SUM(M69+N69+P69+Q69)*J69,2)","v":0},{"$f":"K69+ROUND(SUM(M69+N69+P69+Q69)*L69,2)","v":0}]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F68:F71)","v":0},null,{"$f":"SUM(H68:H71)","v":0},{"$f":"SUM(I68:I71)","v":0},null,{"$f":"SUM(K68:K71)","v":0},null,{"$f":"SUM(M68:M71)","v":0},0,0,0,0,0,0,0,0]
[61,"ANNUAL TOTALS","ISS & PROFESSIONAL SERVICES STAFF (CONTRACTED ISS JOB DUTIES ONLY)",{"$f":"ROUNDDOWN(IF(B10=\"Quarterly\",SUM(D23+D38+D53+D68)/4,SUM(D13+D18+D23+D28+D33+D38+D43+D48+D53+D58+D63+D68)/12),0)","v":{"$error":"#N/A"}},{"$f":"SUM(E13+E18+E23+E28+E33+E38+E43+E48+E53+E58+E63+E68)","v":0},0,{"$f":"IF((E73+F73)<=0,0,SUM(E73+F73)/SUM(E73+F73+H73+I73+K73))","v":0},{"$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":0},0,{"$f":"SUM(E73+F73+H73+I73+M73+N73+K73)","v":0},{"$f":"SUM(P13+P18+P23+P28+P33+P38+P43+P48+P53+P58+P63+P68)","v":0},0,{"$f":"SUM(O73:Q73)","v":0},{"$f":"SUM(S13+S18+S23+S28+S33+S38+S43+S48+S53+S58+S63+S68)","v":0},0,0]
[62,"ANNUAL TOTALS","ISS & ADMINISTRATIVE OR NON-CONTRACTED STAFF (STAFF PERFORMS CONTRACTED & NON-CONTRACTED AND/OR ADMINSTRATIVE WORK)",null,0,0,{"$f":"IF((E74+F74)<=0,0,SUM(E74+F74)/SUM(E74+F74+H74+I74+K74))","v":0},0,0,{"$f":"IF((H74+I74)<=0,0,SUM(H74+I74)/SUM(E74+F74+H74+I74+K74))","v":0},{"$f":"SUM(K14+K19+K24+K29+K34+K39+K44+K49+K54+K59+K64+K69)","v":0},{"$f":"IF(K74<=0,0,K74/SUM(E74+F74+H74+I74+K74))","v":0},0,0,{"$f":"SUM(E74+F74+H74+I74+M74+N74+K74)","v":0},0,0,{"$f":"SUM(O74:Q74)","v":0},0,0,0]
[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":{"$error":"#N/A"}},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":0},{"$f":"SUM(F73:F76)","v":0},{"$f":"IF((E77+F77)<=0,0,SUM(E77+F77)/SUM(E77+F77+H77+I77+K77))","v":0},{"$f":"SUM(H73:H76)","v":0},{"$f":"SUM(I73:I76)","v":0},{"$f":"IF((H77+I77)<=0,0,SUM(H77+I77)/SUM(E77+F77+H77+I77+K77))","v":0},{"$f":"SUM(K73:K76)","v":0},{"$f":"IF(K77<=0,0,K77/SUM(E77+F77+H77+I77+K77))","v":0},{"$f":"SUM(M73:M76)","v":0},0,0,0,0,0,0,0,0]
[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/2022)"]

{"sheet":"C - Non-ISS Expenses","index":11,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[34,4,36,4],[0,1,0,8],[38,2,38,3],[30,3,30,7],[25,3,25,5],[27,3,27,5],[29,3,29,5],[34,1,36,3],[2,6,2,8],[31,2,31,7],[19,2,19,6],[34,7,34,8],[35,7,36,8],[35,6,36,6],[35,5,36,5],[14,2,14,3],[42,2,42,3],[37,1,37,3],[38,7,38,8],[40,7,40,8],[37,7,37,8],[40,2,40,3],[42,7,42,8],[39,2,39,8],[41,2,41,8],[53,1,53,3],[46,1,46,3],[44,2,44,3],[49,7,49,8],[47,2,47,3],[51,7,51,8],[53,7,53,8],[44,7,44,8],[46,7,46,8],[47,7,47,8],[49,2,49,3],[51,2,51,3],[43,2,43,8],[45,2,45,8],[48,2,48,8],[50,2,50,8],[52,2,52,8]]}
[null,"SCHEDULE C"]
[]
[null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[]
[null,1,"IS THE AGENCY A NON-PROFIT ORGANIZATION"]
[]
[null,2,"DOES THE AGENCY PAY B&O TAXES TO THE DEPARTMENT OF REVENUE?"]
[]
[null,3,"DOES THE AGENCY PAY CITY B&O TAXES? IF YES, SELECT CITY"]
[]
[]
[]
[null,4,"ARE ISS ACCRUALS CLAIMED ON SCHEDULE B?"]
[]
[null,5,"ARE PROFESSIONAL SERVICES CONTRACTED OR PURCHASED FOR CLIENTS SUPPORTED BY THE AGENCY?"]
[null,null,"If Yes, include the cost of purchased or contracted professional services for settled programs on Schedule G, lines 20-22. Contracted or purchased professional services must be authorized in the client assessment. Provider must have supporting documentation for amounts reported and available to the department upon request."]
[]
[]
[]
[null,6,"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,"b","If yes to question 2a, do you allocate administrative and program overhead costs?"]
[]
[null,null,"c","What is your agency's method of allocating costs? "]
[null,null,null,"*If you answered \"Other Method\" for question 2c please describe your agencies allocation method in the box below:"]
[]
[]
[]
[null,"ADMINISTRATIVE & OPERATIONS COSTS \n(NON-ISS COSTS)",null,null,"AGENCY TYPE (Select from dropdown list)","A","B","C"]
[]
[]
[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(F39:H39)","v":0}]
[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(F41:H41)","v":0}]
[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(F43:H43)","v":0}]
[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(F45:H45)","v":0}]
[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(F48:H48)","v":0}]
[null,null,"Salaries and Wages, Fringe Benefits and Payroll Taxes, Supplies & Materials, Purchased Services"]
[null,6,"TRANSPORTATION EXPENSES",null,{"$f":"SUM(F50:H50)","v":0}]
[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(F52:H52)","v":0}]
[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+E41+E43+E45+E48+E50+E52","v":0},{"$f":"_C000276+F41+F43+F45+F48+F50+F52","v":0},{"$f":"_C000277+G41+G43+G45+G48+G50+G52","v":0},{"$f":"_C000280+H41+H43+H45+H48+H50+H52","v":0}]
[]
[null,"DSHS/DDA Schedule C (Rev. 12/2022)"]

{"sheet":"D - Revenue","index":12,"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":0}]
[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":0},{"$f":"'C - Non-ISS Expenses'!_M000102","v":0},{"$f":"'C - Non-ISS Expenses'!_M000105","v":0}]
[null,1,"REVENUE FOR SERVICES PROVIDED",null,{"$f":"SUM(F8:H8)","v":0}]
[null,null,"State Payments/Reimbursements for ISS/DSHS Clients (Total Daily Rate less covid add-on), 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":0}]
[null,null,"Summer Programs, Client Evaluation, Non-DSHS Revenue, & Covid Add-On"]
[null,3,"NON-OPERATING REVENUE",null,{"$f":"SUM(F12:H12)","v":0}]
[null,null,"Interest Income, Cash Donations & Contributions, Noncash Donations & Contributions"]
[null,"TOTAL RESIDENTIAL SERVICES REVENUE",null,null,{"$f":"E8+E10+E12","v":0},{"$f":"F8+F10+F12","v":0},{"$f":"G8+G10+G12","v":0},{"$f":"H8+H10+H12","v":0}]
[]
[null,"DSHS/DDA Schedule D (Rev. 12/2022)"]

{"sheet":"E - Residential Staffing","index":13,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[[36,2,36,13],[37,2,37,13],[38,2,38,13],[33,2,33,13],[34,2,34,13],[35,2,35,13],[30,2,30,13],[38,14,38,15],[37,14,37,15],[36,14,36,15],[31,2,31,13],[32,2,32,13],[41,14,41,15],[40,14,40,15],[39,14,39,15],[25,14,25,15],[29,14,29,15],[32,14,32,15],[31,14,31,15],[30,14,30,15],[35,14,35,15],[34,14,34,15],[33,14,33,15],[86,1,86,16],[71,15,71,16],[71,2,71,8],[72,2,72,8],[73,2,73,8],[74,2,74,8],[75,2,75,8],[80,15,80,16],[79,13,79,14],[80,13,80,14],[81,13,81,14],[82,13,82,14],[83,13,83,14],[73,13,73,14],[72,15,72,16],[73,15,73,16],[74,15,74,16],[75,15,75,16],[76,15,76,16],[83,2,83,12],[78,1,78,16],[85,1,85,16],[74,9,74,10],[74,11,74,12],[74,13,74,14],[75,9,75,10],[75,11,75,12],[75,13,75,14],[72,9,72,10],[72,11,72,12],[72,13,72,14],[73,9,73,10],[73,11,73,12],[79,15,79,16],[83,15,83,16],[82,15,82,16],[81,15,81,16],[81,2,81,12],[82,2,82,12],[79,2,79,12],[80,2,80,12],[76,9,76,10],[76,11,76,12],[76,13,76,14],[76,2,76,8],[60,13,60,15],[61,6,61,7],[61,8,61,11],[61,13,61,15],[71,9,71,10],[71,11,71,12],[71,13,71,14],[52,2,52,10],[53,2,53,10],[54,2,54,10],[55,2,55,10],[60,1,61,2],[60,6,60,7],[60,8,60,11],[59,1,59,16],[70,1,70,16],[45,2,45,10],[46,2,46,10],[47,2,47,10],[48,2,48,10],[49,2,49,10],[51,2,51,10],[39,2,39,13],[40,2,40,13],[41,2,41,13],[25,2,25,11],[29,2,29,13],[21,2,21,4],[18,2,18,4],[19,2,19,4],[20,2,20,4],[18,6,18,13],[19,6,19,13],[20,6,20,13],[21,6,21,13],[13,2,13,4],[13,5,13,11],[13,12,13,13],[13,14,13,15],[14,2,14,4],[14,5,14,11],[14,12,14,13],[14,14,14,15],[0,1,0,16],[2,2,2,6],[2,15,2,16],[3,15,3,16],[5,0,5,16],[7,0,7,16]]}
[null,"SCHEDULE E"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A - General Info & Cert'!B6","v":0}]
[null,null,null,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 Periods: January 1, 2023 to June 30, 2023 & July 1, 2023 to December 31, 2023 (Semiannual Year, 12 months, 2023)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
[]
["The schedule(s) will be reviewed by the rate analyst to ensure the Agency is reporting 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,null,"CITY",null,"COUNTY"]
[]
[]
[null,"2. CONTACT INFORMATION:"]
[]
[null,null,"Name (Person Completing Schedule):"]
[null,null,"Title (Person Completing Schedule):"]
[null,null,"Telephone Number:"]
[null,null,"E-Mail Address:"]
[]
[null,"3. CLIENT INFORMATION: "]
[]
[null,null,"Average Monthly Count of Clients supported in this program?  "]
[]
[null,"4. EMPLOYEE BENEFITS:"]
[]
[null,null,"In addition to wages, does your agency provide benefits to ISS staff?\nSelect yes or no from drop down list",null,null,null,null,null,null,null,null,null,null,null," Yes or No"]
[null,null,"Medical Insurance (paid in whole or in part by agency)"]
[null,null,"Dental Insurance (paid in whole or in part by agency)"]
[null,null,"Retirement (paid in whole or in part by agency)"]
[null,null,"Paid Sick Leave"]
[null,null,"Paid Vacation"]
[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,"5. RECRUITING:"]
[]
[null,null,"\nDifference in recruiting new staff from 1/1/2023 - 6/30/2023?\n(Only check boxes that apply)",null,null,null,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 six months (Harder to recruit)"]
[null,null,"Some improvement from previous six months (Easier to recruit)"]
[null,null,"Definite improvement from previous six months (Much easier to recruit)"]
[null,null,"No difference from previous six months"]
[]
[null,null,"\nDifference in recruiting new staff from 7/1/2023 - 12/31/2023?\n(Only check boxes that apply)",null,null,null,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 six months (Harder to recruit)"]
[null,null,"Some improvement from previous six months (Easier to recruit)"]
[null,null,"Definite improvement from previous six months (Much easier to recruit)"]
[null,null,"No difference from previous six months"]
[]
[null,"6. STAFFING INFORMATION:"]
[]
[null,"SECTION 1A (TURNOVER)"]
[null,null,null,1,2,3,4,null,5,null,null,null,6,7,null,null,8]
[null,null,null,"Beginning of Year ISS Staffing Level","Current ISS Staffing Level","Full ISS Employment","Number of ISS Staff Hired",null,"Number of ISS staff and authorized ISS purchased service staff who left or had their employment/contract terminated:",null,null,null,"Positions Available","Turnover"]
[null,"Line #","ISS POSITION TYPE (exclude any positions that are being paid at a negotiated/exceptional rate)","Number of ISS staff (Full-time, Part-time, and authorized purchased ISS staff services) on January 1st, 2023","Number of ISS staff (Full-time, Part-time, and authorized purchased ISS staff services) on December 31, 2023","Number of ISS staff needed for full employment on December 31st 2023","  a. Number of ISS staff hired, Jan. 1, 2023 - June 30, 2023","b. Number of ISS staff hired, July 1, 2023 - Dec. 31, 2023","a. Total ISS Staff who left/or had their employment terminated during the Calendar Year (Col. 6.1 + Col. 6.4 - Col. 6.2)","b. (Six Months) \nJan 1, 2023 to June 30, 2023","c. (Six Months) \nJuly 1, 2023 to Dec. 31, 2023 (Col. 6.5a - Col. 6.5b)","d. Optional: Within 90 days of hiring date (Calander Year)","Number of vacancies on Dec 31, 2023","ISS Staff Turnover percentage, Jan. 1, 2023 - June 30, 2023","ISS Staff Turnover percentage, July 1, 2023 - Dec. 31, 2023","ISS Staff Turnover percentage, Calendar Year (Jan.1, 2023-Dec. 31, 2023)","Average number of days to fill vacant positions (Estimates accepted if unknown)"]
[null,1,"ENTRY LEVEL",null,null,null,null,null,{"$f":"D64+G64+H64-E64","v":0},null,{"$f":"I64-J64","v":0},null,{"$f":"-E64+F64","v":0},{"$f":"J64/D64","v":{"$error":"#DIV/0!"}},{"$f":"K64/E64","v":{"$error":"#DIV/0!"}},{"$f":"I64/(AVERAGE(D64:E64))","v":{"$error":"#DIV/0!"}}]
[null,2,"1st LINE SUPERVISORS (supervisors of DSPs)",null,null,null,null,null,{"$f":"D65+G65+H65-E65","v":0},null,{"$f":"I65-J65","v":0},null,{"$f":"-E65+F65","v":0},{"$f":"J65/D65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"I65/(AVERAGE(D65:E65))","v":{"$error":"#DIV/0!"}}]
[null,3,"PROGRAM MANAGERS (supervisors of 1st line supervisor)",null,null,null,null,null,0,null,{"$f":"I66-J66","v":0},null,{"$f":"-E66+F66","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,4,"*SPECIALISTS \n(recreation, behavioral, or staff trainers, QA, financial, medical coordinators, etc.)",null,null,null,null,null,0,null,{"$f":"I67-J67","v":0},null,{"$f":"-E67+F67","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,5,"NURSES (RN, LPN)",null,null,null,null,null,{"$f":"D68+G68+H68-E68","v":0},null,{"$f":"I68-J68","v":0},null,{"$f":"-E68+F68","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"TOTAL\n (Lines 1 thru 5)",{"$f":"SUM(D64:D68)","v":0},{"$f":"SUM(E64:E68)","v":0},0,0,0,{"$f":"SUM(I64:I68)","v":0},0,0,0,{"$f":"SUM(M64:M68)","v":0},{"$f":"J69/D69","v":{"$error":"#DIV/0!"}},{"$f":"K69/E69","v":{"$error":"#DIV/0!"}},{"$f":"I69/(AVERAGE(D69:E69))","v":{"$error":"#DIV/0!"}}]
[]
[null,"SECTION 1B (WAGES)"]
[null,"Line #","POSITION TYPE",null,null,null,null,null,null,"Starting wage for this type of position within your agency 1/1/23-6/30/23 (Hourly Rate)",null,"What is the average wage for this type of position after two years of employment 1/1/23-6/30/23 (Hourly Rate)",null," Starting wage for this type of position within your agency 7/1/23-12/31/23  (Hourly Rate)",null,"What is the average wage for this type of position after two years of employment 7/1/23-12/31/23 (Hourly Rate)"]
[null,6,"ENTRY LEVEL"]
[null,7,"1st LINE SUPERVISORS"]
[null,8,"PROGRAM MANAGERS"]
[null,9,"*SPECIALISTS (recreation, behavioral, or staff trainers, etc.)"]
[null,10,"NURSES (RN, LPN)"]
[]
[null,"SECTION 1C (RETENTION)"]
[null,"Line #","Length of Time with your Agency as of 12/31/2023",null,null,null,null,null,null,null,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,12,"BETWEEN 6 and 12 months"]
[null,13,"OVER 12 months"]
[null,null,"Total Staff by Length of Time\n (Total Lines 7 thru 9)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N81:N83)<>E69,\"Does not equal Section 1A, Col 2\",SUM(N81:N83))","v":0},null,{"$f":"IF(SUM(P81:Q83)<>I69,\"Does not equal Section 1A, Col 5a\",SUM(P81:P83))","v":0}]
[]
[null,"COMMENTS:"]
[]
[null,"DSHS/DDA Schedule E (Rev. 12/2022)"]

{"sheet":"E - Residential Staffing Add'l","index":14,"n_rows":88,"n_cols":17,"rows_kept":88,"cut":false,"hidden":false,"merged":[[83,2,83,12],[83,13,83,14],[83,15,83,16],[85,1,85,16],[86,1,86,16],[81,2,81,12],[81,13,81,14],[81,15,81,16],[82,2,82,12],[82,13,82,14],[82,15,82,16],[79,2,79,12],[79,13,79,14],[79,15,79,16],[80,2,80,12],[80,13,80,14],[80,15,80,16],[76,2,76,8],[76,9,76,10],[76,11,76,12],[76,13,76,14],[76,15,76,16],[78,1,78,16],[74,2,74,8],[74,9,74,10],[74,11,74,12],[74,13,74,14],[74,15,74,16],[75,2,75,8],[75,9,75,10],[75,11,75,12],[75,13,75,14],[75,15,75,16],[72,2,72,8],[72,9,72,10],[72,11,72,12],[72,13,72,14],[72,15,72,16],[73,2,73,8],[73,9,73,10],[73,11,73,12],[73,13,73,14],[73,15,73,16],[61,8,61,11],[61,13,61,15],[70,1,70,16],[71,2,71,8],[71,9,71,10],[71,11,71,12],[71,13,71,14],[71,15,71,16],[52,2,52,10],[53,2,53,10],[54,2,54,10],[55,2,55,10],[59,1,59,16],[60,1,61,2],[60,6,60,7],[60,8,60,11],[60,13,60,15],[61,6,61,7],[45,2,45,10],[46,2,46,10],[47,2,47,10],[48,2,48,10],[49,2,49,10],[51,2,51,10],[39,2,39,13],[39,14,39,15],[40,2,40,13],[40,14,40,15],[41,2,41,13],[41,14,41,15],[36,2,36,13],[36,14,36,15],[37,2,37,13],[37,14,37,15],[38,2,38,13],[38,14,38,15],[33,2,33,13],[33,14,33,15],[34,2,34,13],[34,14,34,15],[35,2,35,13],[35,14,35,15],[30,2,30,13],[30,14,30,15],[31,2,31,13],[31,14,31,15],[32,2,32,13],[32,14,32,15],[21,2,21,4],[21,6,21,13],[25,2,25,11],[25,14,25,15],[29,2,29,13],[29,14,29,15],[18,2,18,4],[18,6,18,13],[19,2,19,4],[19,6,19,13],[20,2,20,4],[20,6,20,13],[13,2,13,4],[13,5,13,11],[13,12,13,13],[13,14,13,15],[14,2,14,4],[14,5,14,11],[14,12,14,13],[14,14,14,15],[0,1,0,16],[2,2,2,6],[2,15,2,16],[3,15,3,16],[5,0,5,16],[7,0,7,16]]}
[null,"SCHEDULE E"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'A - General Info & Cert'!B6","v":0}]
[null,null,null,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 Periods: January 1, 2023 to June 30, 2023 & July 1, 2023 to December 31, 2023 (Semiannual Year, 12 months, 2023)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
[]
["The schedule(s) will be reviewed by the rate analyst to ensure the Agency is reporting 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,null,"CITY",null,"COUNTY"]
[]
[]
[null,"2. CONTACT INFORMATION:"]
[]
[null,null,"Name (Person Completing Schedule):"]
[null,null,"Title (Person Completing Schedule):"]
[null,null,"Telephone Number:"]
[null,null,"E-Mail Address:"]
[]
[null,"3. CLIENT INFORMATION: "]
[]
[null,null,"Average Monthly Count of Clients supported in this program?  "]
[]
[null,"4. EMPLOYEE BENEFITS:"]
[]
[null,null,"In addition to wages, does your agency provide benefits to ISS staff?\nSelect yes or no from drop down list",null,null,null,null,null,null,null,null,null,null,null," Yes or No"]
[null,null,"Medical Insurance (paid in whole or in part by agency)"]
[null,null,"Dental Insurance (paid in whole or in part by agency)"]
[null,null,"Retirement (paid in whole or in part by agency)"]
[null,null,"Paid Sick Leave"]
[null,null,"Paid Vacation"]
[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,"5. RECRUITING:"]
[]
[null,null,"\nDifference in recruiting new staff from 1/1/2023 - 6/30/2023?\n(Only check boxes that apply)",null,null,null,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 six months (Harder to recruit)"]
[null,null,"Some improvement from previous six months (Easier to recruit)"]
[null,null,"Definite improvement from previous six months (Much easier to recruit)"]
[null,null,"No difference from previous six months"]
[]
[null,null,"\nDifference in recruiting new staff from 7/1/2023 - 12/31/2023?\n(Only check boxes that apply)",null,null,null,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 six months (Harder to recruit)"]
[null,null,"Some improvement from previous six months (Easier to recruit)"]
[null,null,"Definite improvement from previous six months (Much easier to recruit)"]
[null,null,"No difference from previous six months"]
[]
[null,"6. STAFFING INFORMATION:"]
[]
[null,"SECTION 1A (TURNOVER)"]
[null,null,null,1,2,3,4,null,5,null,null,null,6,7,null,null,8]
[null,null,null,"Beginning of Year ISS Staffing Level","Current ISS Staffing Level","Full ISS Employment","Number of ISS Staff Hired",null,"Number of ISS staff and authorized ISS purchased service staff who left or had their employment/contract terminated:",null,null,null,"Positions Available","Turnover"]
[null,"Line #","ISS POSITION TYPE (exclude any positions that are being paid at a negotiated/exceptional rate)","Number of ISS staff (Full-time, Part-time, and authorized purchased ISS staff services) on January 1st, 2023","Number of ISS staff (Full-time, Part-time, and authorized purchased ISS staff services) on December 31, 2023","Number of ISS staff needed for full employment on December 31st 2023","  a. Number of ISS staff hired, Jan. 1, 2023 - June 30, 2023","b. Number of ISS staff hired, July 1, 2023 - Dec. 31, 2023","a. Total ISS Staff who left/or had their employment terminated during the Calendar Year (Col. 6.1 + Col. 6.4 - Col. 6.2)","b. (Six Months) \nJan 1, 2023 to June 30, 2023","c. (Six Months) \nJuly 1, 2023 to Dec. 31, 2023 (Col. 6.5a - Col. 6.5b)","d. Optional: Within 90 days of hiring date (Calander Year)","Number of vacancies on Dec 31, 2023","ISS Staff Turnover percentage, Jan. 1, 2023 - June 30, 2023","ISS Staff Turnover percentage, July 1, 2023 - Dec. 31, 2023","ISS Staff Turnover percentage, Calendar Year (Jan.1, 2023-Dec. 31, 2023)","Average number of days to fill vacant positions (Estimates accepted if unknown)"]
[null,1,"ENTRY LEVEL",null,null,null,null,null,{"$f":"D64+G64+H64-E64","v":0},null,{"$f":"I64-J64","v":0},null,{"$f":"-E64+F64","v":0},{"$f":"J64/D64","v":{"$error":"#DIV/0!"}},{"$f":"K64/E64","v":{"$error":"#DIV/0!"}},{"$f":"I64/(AVERAGE(D64:E64))","v":{"$error":"#DIV/0!"}}]
[null,2,"1st LINE SUPERVISORS (supervisors of DSPs)",null,null,null,null,null,{"$f":"D65+G65+H65-E65","v":0},null,{"$f":"I65-J65","v":0},null,{"$f":"-E65+F65","v":0},{"$f":"J65/D65","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"I65/(AVERAGE(D65:E65))","v":{"$error":"#DIV/0!"}}]
[null,3,"PROGRAM MANAGERS (supervisors of 1st line supervisor)",null,null,null,null,null,0,null,{"$f":"I66-J66","v":0},null,{"$f":"-E66+F66","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,4,"*SPECIALISTS \n(recreation, behavioral, or staff trainers, QA, financial, medical coordinators, etc.)",null,null,null,null,null,0,null,{"$f":"I67-J67","v":0},null,{"$f":"-E67+F67","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,5,"NURSES (RN, LPN)",null,null,null,null,null,{"$f":"D68+G68+H68-E68","v":0},null,{"$f":"I68-J68","v":0},null,{"$f":"-E68+F68","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"TOTAL\n (Lines 1 thru 5)",{"$f":"SUM(D64:D68)","v":0},{"$f":"SUM(E64:E68)","v":0},0,0,0,{"$f":"SUM(I64:I68)","v":0},0,0,0,{"$f":"SUM(M64:M68)","v":0},{"$f":"J69/D69","v":{"$error":"#DIV/0!"}},{"$f":"K69/E69","v":{"$error":"#DIV/0!"}},{"$f":"I69/(AVERAGE(D69:E69))","v":{"$error":"#DIV/0!"}}]
[]
[null,"SECTION 1B (WAGES)"]
[null,"Line #","POSITION TYPE",null,null,null,null,null,null,"Starting wage for this type of position within your agency 1/1/23-6/30/23 (Hourly Rate)",null,"What is the average wage for this type of position after two years of employment 1/1/23-6/30/23 (Hourly Rate)",null," Starting wage for this type of position within your agency 7/1/23-12/31/23  (Hourly Rate)",null,"What is the average wage for this type of position after two years of employment 7/1/23-12/31/23 (Hourly Rate)"]
[null,6,"ENTRY LEVEL"]
[null,7,"1st LINE SUPERVISORS"]
[null,8,"PROGRAM MANAGERS"]
[null,9,"*SPECIALISTS (recreation, behavioral, or staff trainers, etc.)"]
[null,10,"NURSES (RN, LPN)"]
[]
[null,"SECTION 1C (RETENTION)"]
[null,"Line #","Length of Time with your Agency as of 12/31/2023",null,null,null,null,null,null,null,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,12,"BETWEEN 6 and 12 months"]
[null,13,"OVER 12 months"]
[null,null,"Total Staff by Length of Time\n (Total Lines 7 thru 9)",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(N81:N83)<>E69,\"Does not equal Section 1A, Col 2\",SUM(N81:N83))","v":0},null,{"$f":"IF(SUM(P81:Q83)<>I69,\"Does not equal Section 1A, Col 5a\",SUM(P81:P83))","v":0}]
[]
[null,"COMMENTS:"]
[]
[null,"DSHS/DDA Schedule E (Rev. 12/2022)"]

{"sheet":"F - Healthcare Expenses","index":15,"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":"'A - General Info & Cert'!B6","v":0}]
[null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
["INCLUDE ALL PROGRAMS FOR THE AGENCY ON THIS SCHEDULE"]
["Reporting Period: Dececmber 1, 2023  to  December 31, 2023 (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,"Group Home"]
[null,"Group Training Home"]
[null,"Supported Living - SOLA"]
[]
[null,"CONTACT INFORMATION:"]
[]
[null,null,"Name (Person Completing Schedule)"]
[null,null,"Title (Person Completing Schedule)"]
[null,null,"Telephone Number:"]
[null,null,"E-Mail Address:"]
[]
[null,"HEALTH INSURANCE:"]
[]
[null,"1. Total Number of employees working for the agency",null,null,null,null,null,null,null,0]
[null,"2. Total number of Employees from #1 averaging 29 or less hours per week"]
[null,"3. Total number of Employees from #1 averaging 30-39 hours per week"]
[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,"5. Currently how many employees who work in Supported Living (SL), Group Home (GH), Group Training Home (GTH) or Children's Licensed Staffed Residential (LSR) are on your company provided health insurance plan? Please provide one number for all types of services - add them all together whether your company provides coverage for them separately or accounts for them separately. \n\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,"6. Currently how many ISS hours per week does an employee have to work to be eligible for your company provided health insurance?"]
[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 the employee pays $20.00 towards the premium then you would enter $80.00"]
[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,"9. Currently how many employees have waived your company provided health insurance, but will be required to take advantage of it in 2024? (Not 2023)"]
[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 2024 to ensure compliance with the ACA? What is the total amount of enrollees you anticipate will be on your plan. (Not 2023)"]
[]
[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, 2018 to 2022 or 2019 to 2023. Please represent this number as a percentage based on a per employee/subscriber cost increase from the prior year. For example: In 2020 the premium per employee was $100 and then increased to $150 in 2021; in 2021 you had a 50% increase in your per employee/subscriber premium costs.",null,null,null,2018,2019,2020,2021,2022,{"$f":"J36+1","v":2023}]
[]
[]
[null,"12. Over the same five year period you included in question 11 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,2018,2019,2020,2021,2022,{"$f":"J39+1","v":2023}]
[]
[]
[null,"13. How many clients does your company serve in SL, GH, GTH, and/or LSR? Please add all numbers together and provide one number for all clients served in all programs."]
[null,"DSHS/DDA Schedule F (Rev. 12/2022)"]

{"sheet":"G - ISS Settlement","index":16,"n_rows":40,"n_cols":6,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,2],[29,0,29,2],[6,0,6,2],[33,1,33,2],[21,0,21,2],[27,0,27,2]]}
["SCHEDULE G"]
[null," "]
[null,null,{"$f":"_M000001","v":0}]
[null,null,"PROVIDER NAME"]
[]
["A","B","C"]
["REIMBURSEMENT SUMMARY"]
["Line","Tiered ISS Reimbursements by Program Type","ISS Reimbursement"]
[1,"SL Supported Living",null,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",null,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",null,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":0}]
[]
[null,"Nurse Delegation and Staff Add On","ISS Reimbursement"]
[{"$f":"+A12+1","v":5},"SL Nurse Delegation",null,null,1]
[{"$f":"+A15+1","v":6},"GH Nurse Delegation",null,null,2]
[{"$f":"+A16+1","v":7},"GTH Nurse Delegation",null,null,3]
[{"$f":"+A17+1","v":8},"SL Staff Add On",null,null,1]
[{"$f":"+A18+1","v":9},"GH Staff Add On",null,null,2]
[{"$f":"+A19+1","v":10},"GTH Staff Add On",null,null,3]
[{"$f":"A20+1","v":11},"Sub-Total",{"$f":"SUM(C15:C20)","v":0}]
[]
[null,"Staffed Professional Services: \n(RN, LPN, DBT, Therapist, etc.)","Professional Services ISS Reimbursement"]
[{"$f":"+A21+1","v":12},"SL Supported Living Staffed Professional Services",null,null,{"$f":"IF(F24=\"GH\",2,IF(F24=\"GT\",3,IF(F24=\"SL\",1,\"\")))","v":1},{"$f":"LEFT(B24,2)","v":"SL"}]
[{"$f":"+A24+1","v":13},"GH Group Home Staffed Professional Services",null,null,{"$f":"IF(F25=\"GH\",2,IF(F25=\"GT\",3,IF(F25=\"SL\",1,\"\")))","v":2},{"$f":"LEFT(B25,2)","v":"GH"}]
[{"$f":"+A25+1","v":14},"GTH Group Training Home Staffed Professional Services",null,null,{"$f":"IF(F26=\"GH\",2,IF(F26=\"GT\",3,IF(F26=\"SL\",1,\"\")))","v":3},{"$f":"LEFT(B26,2)","v":"GT"}]
[{"$f":"+A26+1","v":15},"Sub-Total",{"$f":"SUM(C24:C26)","v":0}]
[]
[{"$f":"+A27+1","v":16},"Total ISS Reimbursements paid by DSHS (carries to Line 17)",{"$f":"C12+C21+C27","v":0}]
["SETTLEMENT"]
[{"$f":"A29+1","v":17},"TOTAL REIMBURSED DOLLARS (Auto-filled from Line 16)",{"$f":"C29","v":0}]
[{"$f":"A31+1","v":18},"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":0}]
[{"$f":"A32+1","v":19},"ISS Overtime Staff Costs (Auto-filled from Sch B, Row 65, Col E)",{"$f":"'B - ISS Payroll Expenses'!F77","v":0}]
[null,"Authorized Purchased or Contracted Professional Services: (RN, LPN, DBT, Therapist, etc.) "]
[{"$f":"A33+1","v":20},"SL Authorized ISS Purchased or Contracted Professional Services",null,null,{"$f":"IF(F35=\"GH\",2,IF(F35=\"GT\",3,IF(F35=\"SL\",1,\"\")))","v":1},{"$f":"LEFT(B35,2)","v":"SL"}]
[{"$f":"A35+1","v":21},"GH Authorized ISS Purchased or Contracted Professional Services",null,null,{"$f":"IF(F36=\"GH\",2,IF(F36=\"GT\",3,IF(F36=\"SL\",1,\"\")))","v":2},{"$f":"LEFT(B36,2)","v":"GH"}]
[{"$f":"A36+1","v":22},"GTH Authorized ISS Purchased or Contracted Professional Services",null,null,{"$f":"IF(F37=\"GH\",2,IF(F37=\"GT\",3,IF(F37=\"SL\",1,\"\")))","v":3},{"$f":"LEFT(B37,2)","v":"GT"}]
[{"$f":"A37+1","v":23},"TOTAL ALLOWABLE ISS COSTS PAID BY THE PROVIDER (Line 18+19+20+21+22)",{"$f":"SUM(C32:C37)","v":0}]
[{"$f":"A38+1","v":24},"TOTAL PRELIMINARY NET SETTLEMENT AMOUNT",{"$f":"IF((_C001589-C38)<0,0,(_C001589-C38))","v":0}]
[null,"DSHS/DDA Schedule G ISS Settlement (Rev. 12/2022)"]