{"text_format":"1","workbook":"xlsx","n_sheets":24,"sheets":["ReadMe","RES","A","B-1","B","C","C-Sum","E","F","G","H","J Summary","J Detail","J Detail pg 2 - COCA","J Detail pg 3 - Prof Svs","J-Adm","L","M","N","O","O Add'l","P","CountyList","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":11,"defined_names":3043,"comments":12,"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":"ReadMe","index":0,"n_rows":32,"n_cols":4,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,1,1,3],[2,1,2,3],[23,1,23,3],[24,2,24,3],[15,1,15,3],[17,1,17,3],[19,1,19,3],[21,1,21,3],[7,1,7,3],[9,1,9,3],[11,1,11,3],[13,1,13,3],[5,1,5,3],[3,1,3,3]]}
[]
[null,"DDA Residential Programs Cost Report General Guidelines"]
[]
[null,"1. For 2018, Schedule B-1 and Schedule E will continue to include a section to record the 1163 employee training hours not being settled from January 1, 2018 to December 31, 2018 so that the hours and related expense can be deducted from settlement. Intructions for tracking and reporting 1163 training was sent to providers earlier this year. The department has also decided to extend the Consideration of Overtime Credit for 2018, however the way the credit is calculated on Schedule J Summary is slightly different. A decription and sample of these changes were sent to providers in late October."]
[]
[null,"2. The completed cost report must be submitted in excel format using the 12/18 revised cost report template. The cost report (Schedules A, B-1, B, C, E, F, G, H, L, M, N, O & P), settlement (Schedules J Summary, J Detail, & J Detail pg 2 - COCA) are all on a single file. The completed report is to be emailed to both your resource manager and rate analyst (see below for rate analyst). The department no longer accepts Cost Report templates and survey templates from previous years. The current year cost report templates and related materials are available on the web. In addition, cost reports received in PDF or by mail cannot be accepted; only the signed Schedule A is to be scanned as PDF and attached to the email submitting the cost report. If scanning Schedule A is not possible, the signed form (Schedule A only) may be mailed or faxed to your regional resource manager. The resource manager will forward the signed Schedule A to the rates department if mailed or faxed."]
[]
[null,"3. Providers are to fill in cells that are formatted white. Cells that are formatted in yellow are locked and cannot be changed. Several places throughout the cost report, providers will select from a drop down list instead of typing in their information. Do not copy and paste while using this form."]
[]
[null,"4. Do not include client names, identification numbers, or employee information in the cost report. If you use the optional form, Schedule J Detail by Client, 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. Schedule B-2 is a also a separate template file and is an internal use only document. This file will not be submitted with the cost report however it must be made available to the department if requested. An agency may use their internal payroll records provided that the reports breakdown the data exactly how it is displayed on Schedule B-2 for auditing purposes."]
[]
[null,"5. Review the report before submitting to ensure all required information is both accurate and complete. It is also recommended to print preview before printing as some printers allow different margins or use slightly different font sizes that may cause schedules to not fit as they were designed."]
[]
[null,"6. It is recommended that the cost report preparer refer to the cost reporting instructions, DDA policy 6.04, the Chart of Accounts, PowerPoint Presentation and template samples while completing their cost report. "]
[]
[null,"7. On Schedule A, please include your current contact information for your agency and the cost report preparer, including email addresses."]
[]
[null,"8. Each schedule (A through P) is on a separate tab. Move from schedule to schedule by clicking on the appropriate tab. If additional tabs are needed (Schedule F or Schedule O) please contact your rates analyst."]
[]
[null,"9. 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,"10.  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 - Extended Due Date"]
[]
[null,"DD Rates Contact Information"," Telephone"," E-mail address "]
[null,"Lynda O'Neil, DDA Rates Manager                           ","(360) 725-2473","lynda.oneil@dshs.wa.gov"]
[null,"Carson Crepeaux, DDA Rates Program Manager ","(360) 725-2476","crepecn@dshs.wa.gov"]
[null,"Tod Johnson, Analyst - Regions 1 & SOLA","(360) 725-2347","johnstp1@dshs.wa.gov"]
[null,"Samantha (Sam) Everett, Analyst - LSR & Regions 2 & 3","(360) 725-2441","samantha.everett@dshs.wa.gov"]
[null,"Tammy Paulk, Analyst - ICF/ID & RHC","(360) 725-2498","tammy.paulk@dshs.wa.gov"]

{"sheet":"RES","index":1,"n_rows":242,"n_cols":11,"rows_kept":242,"cut":false,"hidden":true,"merged":[[71,2,71,3],[80,2,80,3],[80,4,80,10],[27,2,27,3],[47,2,47,3],[54,2,54,3],[67,2,67,3],[67,4,67,10],[54,4,54,10],[47,4,47,10],[27,4,27,10],[193,4,193,10],[193,2,193,3],[198,2,198,3],[198,4,198,10],[173,4,173,10],[173,2,173,3],[10,0,15,0],[153,2,153,3],[153,4,153,10],[160,4,160,10],[160,2,160,3],[107,2,107,3],[107,4,107,10],[120,2,120,3],[120,4,120,10],[133,2,133,3],[100,2,100,3],[100,4,100,10],[133,4,133,10],[124,4,124,10],[124,2,124,3],[18,2,18,3],[7,0,9,0],[0,0,6,0],[7,2,9,2],[7,3,9,3],[0,6,6,10]]}
[" ","FILE NAME:",{"$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":"2018 Cost Report - Template"}]
[null,"PROVIDER NAME:",{"$f":"_M000001","v":0}]
[null,"REGION:",{"$f":"_M000009","v":""}]
[null,"CITY, ZIP:",{"$f":"_M000005","v":0}]
[null,"MEDICAL SVS:",{"$f":"_M000025","v":0}]
[null,"BUSINESS TYPE: ",{"$f":"B!D13","v":0}]
[null,"ACCTNG BASIS:",{"$f":"B!D17","v":0}]
[null,"PROVIDER NAME","TOTAL SETTLED PROGRAMS","TOTAL ALL PROGRAMS",{"$f":"IF(_M001567=\"\",\"\",_M001567)","v":""},{"$f":"IF(_M001568=\"\",\"\",_M001568)","v":""},{"$f":"IF(_M001569=\"\",\"\",_M001569)","v":""},{"$f":"IF(_M001570=\"\",\"\",_M001570)","v":""},{"$f":"IF(_M001571=\"\",\"\",_M001571)","v":"SSP"},{"$f":"IF(_M001572=\"\",\"\",_M001572)","v":"OTHER"},{"$f":"IF(_M001573=\"\",\"\",_M001573)","v":"OTHER"}]
[null,"P1 ID NUMBER",null,null,{"$f":"IF(_C000108=0,\"\",_C000108)","v":""},{"$f":"IF(_C000109=0,\"\",_C000109)","v":""},{"$f":"IF(_C000110=0,\"\",_C000110)","v":""},{"$f":"IF(_C000111=0,\"\",_C000111)","v":""},{"$f":"IF(_C000112=0,\"\",_C000112)","v":""},{"$f":"IF(_C000113=0,\"\",_C000113)","v":""},{"$f":"IF(_C000114=0,\"\",_C000114)","v":""}]
[null,"PROGRAM TYPE SL/GH",null,null,{"$f":"IF(_M000101=0,\"\",_M000101)","v":""},{"$f":"IF(_M000102=0,\"\",_M000102)","v":""},{"$f":"IF(_M000103=0,\"\",_M000103)","v":""},{"$f":"IF(_M000104=0,\"\",_M000104)","v":""},{"$f":"IF(_M000105=0,\"\",_M000105)","v":"SSP"},{"$f":"IF(_M000106=0,\"\",_M000106)","v":"OTHER"},{"$f":"IF(_M000107=0,\"\",_M000107)","v":"OTHER"}]
[null,"ISS STAFF & PROF SVS STAFF REG & OT HOURS WORKED",{"$f":"SUM(E11:H11)","v":0},{"$f":"SUM(E11:K11)","v":0},{"$f":"_C000042","v":0},{"$f":"_C000050","v":0},{"$f":"_C000058","v":0},{"$f":"_C000066","v":0},{"$f":"_C000074","v":0},{"$f":"_C000082","v":0},{"$f":"_C000090","v":0}]
[null,"SLEEP &/OR CALL BACK HOURS",{"$f":"SUM(E12:H12)","v":0},{"$f":"SUM(E12:K12)","v":0},{"$f":"_C000043","v":0},{"$f":"_C000051","v":0},{"$f":"_C000059","v":0},{"$f":"_C000067","v":0},{"$f":"_C000075","v":0},{"$f":"_C000083","v":0},{"$f":"_C000091","v":0}]
[null,"ADMINISTRATOR ISS HOURS WORKED & AUTHORIZED PURCHASED PROF SVS",{"$f":"SUM(E13:H13)","v":0},{"$f":"SUM(E13:K13)","v":0},{"$f":"_C000044","v":0},{"$f":"_C000052","v":0},{"$f":"_C000060","v":0},{"$f":"_C000068","v":0},{"$f":"_C000076","v":0},{"$f":"_C000084","v":0},{"$f":"_C000092","v":0}]
[null,"TOTAL ISS PAID HOURS WORKED",{"$f":"SUM(E14:H14)","v":0},{"$f":"SUM(E14:K14)","v":0},{"$f":"_C000045","v":0},{"$f":"_C000053","v":0},{"$f":"_C000061","v":0},{"$f":"_C000069","v":0},{"$f":"_C000077","v":0},{"$f":"_C000085","v":0},{"$f":"_C000093","v":0}]
[null,"ANNUAL RESIDENT DAYS",{"$f":"SUM(E15:H15)","v":0},{"$f":"SUM(E15:K15)","v":0},{"$f":"_C000046","v":0},{"$f":"_C000054","v":0},{"$f":"_C000062","v":0},{"$f":"_C000070","v":0},{"$f":"_C000078","v":0},{"$f":"_C000086","v":0},{"$f":"_C000094","v":0}]
[null,"AVERAGE HOURS PER RESIDENT DAY",{"$f":"C14/C15","v":{"$error":"#DIV/0!"}},{"$f":"_C001786/_C001792","v":{"$error":"#DIV/0!"}},{"$f":"IF(_C001787=0,0,IF(_C001793=0,0,ROUND(_C001787/_C001793,2)))","v":0},{"$f":"IF(_C001788=0,0,IF(_C001794=0,0,ROUND(_C001788/_C001794,2)))","v":0},{"$f":"IF(_C001789=0,0,IF(_C001795=0,0,ROUND(_C001789/_C001795,2)))","v":0},{"$f":"IF(_C001790=0,0,IF(_C001796=0,0,ROUND(_C001790/_C001796,2)))","v":0},{"$f":"IF(_C001791=0,0,IF(_C001797=0,0,ROUND(_C001791/_C001797,2)))","v":0},{"$f":"IF(J14=0,0,IF(J15=0,0,ROUND(J14/J15,2)))","v":0},{"$f":"IF(K14=0,0,IF(K15=0,0,ROUND(K14/K15,2)))","v":0}]
[1,"TOTAL ISS PAID HOURS WORKED",{"$f":"SUM(E17:H17)","v":0},{"$f":"SUM(E17:K17)","v":0},{"$f":"+E14","v":0},0,0,0,0,0,0]
[2,"% OF PAID HOURS WORKED",{"$f":"SUM(E18:H18)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E18:K18)","v":{"$error":"#DIV/0!"}},{"$f":"+E17/$D17","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[3,"ADMIN. & OTHER NON ISS STAFF HOURS","ALLOCATED",null,"SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C"]
[null,"ADMINISTRATOR",{"$f":"SUM(E20:H20)","v":{"$error":"#DIV/0!"}},{"$f":"_C000131","v":0},{"$f":"ROUND(+$D20*E$18,2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OWNER",{"$f":"SUM(E21:H21)","v":{"$error":"#DIV/0!"}},{"$f":"'C'!E14","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CHIEF EXECUTIVE",{"$error":"#DIV/0!"},{"$f":"'C'!E15","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER AMDINISTRATIVE STAFF",{"$error":"#DIV/0!"},{"$f":"'C'!E16","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROGRAM  MANAGEMENT",{"$error":"#DIV/0!"},{"$f":"_C000139","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ACCOUNTING/BOOKKEEPING",{"$error":"#DIV/0!"},{"$f":"_C000147","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MAINTENANCE",{"$error":"#DIV/0!"},{"$f":"_C000155","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER NON ISS STAFF",{"$error":"#DIV/0!"},{"$f":"_C000163","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,"ADMINISTRATIVE EXPENSE"]
[null,"ADMIN. SALARIES & WAGES ",{"$f":"SUM(E29:H29)","v":{"$error":"#DIV/0!"}},{"$f":"_C000211","v":0},{"$f":"ROUND(+$D29*E$18,2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ADMIN. BENEFITS & PR TAXES ",{"$f":"SUM(E30:H30)","v":{"$error":"#DIV/0!"}},{"$f":"_C000219","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OWNER SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E31","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OWNER BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E39","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CHIEF EXECUTIVE SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E32","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CHIEF EXECUTIVE BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E40","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER ADMINISTRATIVE STAFF SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER ADMINISTRATIVE STAFF BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E41","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROGRAM MANAGEMENT SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROGRAM MANAGEMENT BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E42","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ACCOUNTING/BOOKKEEPING SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E35","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ACCOUNTING/BOOKKEEPING BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E43","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MAINTENANCE SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E36","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MAINTENANCE BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E44","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER NON-ISS SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"'C'!E37","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER NON-ISS BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"'C'!E45","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PURCHASED PROFESSIONAL SERVICES",{"$error":"#DIV/0!"},{"$f":"_C000227","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MANAGEMENT FEES",{"$error":"#DIV/0!"},{"$f":"_C000235","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL ADMINISTRATIVE EXP.",{"$f":"SUM(C29:C46)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J29:J46)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K29:K46)","v":{"$error":"#DIV/0!"}}]
[5,"PROGRAM OPERATIONS EXPENSE"]
[null,"Administrative Supplies",{"$error":"#DIV/0!"},{"$f":"_C000283","v":0},{"$f":"ROUND(+$D49*E$18,2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Administrative Travel Expenses",{"$error":"#DIV/0!"},{"$f":"_C000291","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Advertising Expense",{"$error":"#DIV/0!"},{"$f":"_C000299","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Professional Liability Insurance",{"$error":"#DIV/0!"},{"$f":"_C000307","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other General Admin. Expense",{"$error":"#DIV/0!"},{"$f":"_C000315","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL PROGRAM OPERATIONS EXPENSE",{"$f":"SUM(C49:C53)","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J49:J53)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K49:K53)","v":{"$error":"#DIV/0!"}}]
[6,"CAPITAL & PROPERTY EXPENSES"]
[null,"Depreciation - Bldgs., Bldg. Improv., Leasehold Improv., Furn. & Equip",{"$error":"#DIV/0!"},{"$f":"_C000371","v":0},{"$f":"ROUND(+$D56*E$18,2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"     Square Footage",{"$error":"#DIV/0!"},{"$f":"'C'!E81","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Communications Expense ",{"$error":"#DIV/0!"},{"$f":"_C000379","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Facility Insurance Expense",{"$error":"#DIV/0!"},{"$f":"_C000387","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Office Rent Expense",{"$error":"#DIV/0!"},{"$f":"_C000395","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"     Square Footage",{"$error":"#DIV/0!"},{"$f":"'C'!E85","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Lease Payments Expense",{"$error":"#DIV/0!"},{"$f":"_C000403","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Utilities Expense",{"$error":"#DIV/0!"},{"$f":"_C000411","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Property Taxes",{"$error":"#DIV/0!"},{"$f":"_C000419","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Minor Equipment Expense",{"$error":"#DIV/0!"},{"$f":"_C000427","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Other Property Expense",{"$error":"#DIV/0!"},{"$f":"_C000435","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL CAPTIAL & PROPERTY EXPENSE",{"$f":"SUM(C56,C58:C60,C62:C66)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D56,D58:D60,D62:D66)","v":0},{"$f":"SUM(E56,E58:E60,E62:E66)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,"INTEREST & TAX EXPENSE"]
[null,"INTEREST EXPENSE: Working Capital & Line-of-Credit Debt Expense",{"$f":"SUM(E69:H69)","v":{"$error":"#DIV/0!"}},{"$f":"_C000523","v":0},{"$f":"ROUND(+$D69*E$18,2)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"BUSINESS TAXES",{"$f":"SUM(E70:H70)","v":{"$error":"#DIV/0!"}},{"$f":"_C000531","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[8,"TOTALS",{"$f":"+C47+C54+C67+C69+C70","v":{"$error":"#DIV/0!"}},0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J47+J54+J67+J69+J70","v":{"$error":"#DIV/0!"}},{"$f":"+K47+K54+K67+K69+K70","v":{"$error":"#DIV/0!"}}]
[3,"ADMIN. & OTHER NON ISS STAFF HOURS","NON ALLOCATED",null,"SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C","SCHEDULE C"]
[null,"ADMINISTRATOR",{"$f":"SUM(E73:H73)","v":0},{"$f":"SUM(E73:K73)","v":0},{"$f":"_C000172","v":0},{"$f":"_C000173","v":0},{"$f":"_C000174","v":0},{"$f":"_C000175","v":0},{"$f":"_C000176","v":0},{"$f":"_C000177","v":0},{"$f":"_C000178","v":0}]
[null,"OWNER",0,{"$f":"SUM(E74:K74)","v":0},{"$f":"'C'!F22","v":0},{"$f":"'C'!G22","v":0},{"$f":"'C'!H22","v":0},{"$f":"'C'!I22","v":0},{"$f":"'C'!J22","v":0},{"$f":"'C'!K22","v":0},{"$f":"'C'!L22","v":0}]
[null,"CHIEF EXECUTIVE",0,0,{"$f":"'C'!F23","v":0},{"$f":"'C'!G23","v":0},{"$f":"'C'!H23","v":0},{"$f":"'C'!I23","v":0},{"$f":"'C'!J23","v":0},{"$f":"'C'!K23","v":0},{"$f":"'C'!L23","v":0}]
[null,"OTHER ADMINISTRATIVE STAFF",0,0,{"$f":"'C'!F24","v":0},{"$f":"'C'!G24","v":0},{"$f":"'C'!H24","v":0},{"$f":"'C'!I24","v":0},{"$f":"'C'!J24","v":0},{"$f":"'C'!K24","v":0},{"$f":"'C'!L24","v":0}]
[null,"PROGRAM  MANAGEMENT",0,0,{"$f":"_C000180","v":0},{"$f":"_C000181","v":0},{"$f":"_C000182","v":0},{"$f":"_C000183","v":0},{"$f":"_C000184","v":0},{"$f":"_C000185","v":0},{"$f":"_C000186","v":0}]
[null,"ACCOUNTING/BOOKKEEPING",0,0,{"$f":"_C000188","v":0},{"$f":"_C000189","v":0},{"$f":"_C000190","v":0},{"$f":"_C000191","v":0},{"$f":"_C000192","v":0},{"$f":"_C000193","v":0},{"$f":"_C000194","v":0}]
[null,"MAINTENANCE",0,0,{"$f":"_C000196","v":0},{"$f":"_C000197","v":0},{"$f":"_C000198","v":0},{"$f":"_C000199","v":0},{"$f":"_C000200","v":0},{"$f":"_C000201","v":0},{"$f":"_C000202","v":0}]
[null,"OTHER NON ISS STAFF",{"$f":"SUM(E80:H80)","v":0},0,{"$f":"_C000204","v":0},{"$f":"_C000205","v":0},{"$f":"_C000206","v":0},{"$f":"_C000207","v":0},{"$f":"_C000208","v":0},{"$f":"_C000209","v":0},{"$f":"_C000210","v":0}]
[4,"ADMINISTRATIVE EXPENSE"]
[null,"ADMIN. SALARIES & WAGES",0,{"$f":"SUM(E82:K82)","v":0},{"$f":"_C000244","v":0},{"$f":"_C000245","v":0},{"$f":"_C000246","v":0},{"$f":"_C000247","v":0},{"$f":"_C000248","v":0},{"$f":"_C000249","v":0},{"$f":"_C000250","v":0}]
[null,"ADMIN. BENEFITS & PR TAXES",0,{"$f":"SUM(E83:K83)","v":0},{"$f":"_C000252","v":0},{"$f":"_C000253","v":0},{"$f":"_C000254","v":0},{"$f":"_C000255","v":0},{"$f":"_C000256","v":0},{"$f":"_C000257","v":0},{"$f":"_C000258","v":0}]
[null,"OWNER SALARIES & WAGES",0,0,{"$f":"'C'!F49","v":0},{"$f":"'C'!G49","v":0},{"$f":"'C'!H49","v":0},{"$f":"'C'!I49","v":0},{"$f":"'C'!J49","v":0},{"$f":"'C'!K49","v":0},{"$f":"'C'!L49","v":0}]
[null,"OWNER BENEFITS & PR TAXES",0,0,{"$f":"'C'!F57","v":0},{"$f":"'C'!G57","v":0},{"$f":"'C'!H57","v":0},{"$f":"'C'!I57","v":0},{"$f":"'C'!J57","v":0},{"$f":"'C'!K57","v":0},{"$f":"'C'!L57","v":0}]
[null,"CHIEF EXECUTIVE SALARIES & WAGES",0,0,{"$f":"'C'!F50","v":0},{"$f":"'C'!G50","v":0},{"$f":"'C'!H50","v":0},{"$f":"'C'!I50","v":0},{"$f":"'C'!J50","v":0},{"$f":"'C'!K50","v":0},{"$f":"'C'!L50","v":0}]
[null,"CHIEF EXECUTIVE BENEFITS & PR TAXES",0,0,{"$f":"'C'!F58","v":0},{"$f":"'C'!G58","v":0},{"$f":"'C'!H58","v":0},{"$f":"'C'!I58","v":0},{"$f":"'C'!J58","v":0},{"$f":"'C'!K58","v":0},{"$f":"'C'!L58","v":0}]
[null,"OTHER ADMINISTRATIVE STAFF SALARIES & WAGES",0,0,{"$f":"'C'!F51","v":0},{"$f":"'C'!G51","v":0},{"$f":"'C'!H51","v":0},{"$f":"'C'!I51","v":0},{"$f":"'C'!J51","v":0},{"$f":"'C'!K51","v":0},{"$f":"'C'!L51","v":0}]
[null,"OTHER ADMINISTRATIVE STAFF BENEFITS & PR TAXES",0,0,{"$f":"'C'!F59","v":0},{"$f":"'C'!G59","v":0},{"$f":"'C'!H59","v":0},{"$f":"'C'!I59","v":0},{"$f":"'C'!J59","v":0},{"$f":"'C'!K59","v":0},{"$f":"'C'!L59","v":0}]
[null,"PROGRAM MANAGEMENT SALARIES & WAGES",0,0,{"$f":"'C'!F52","v":0},{"$f":"'C'!G52","v":0},{"$f":"'C'!H52","v":0},{"$f":"'C'!I52","v":0},{"$f":"'C'!J52","v":0},{"$f":"'C'!K52","v":0},{"$f":"'C'!L52","v":0}]
[null,"PROGRAM MANAGEMENT BENEFITS & PR TAXES",0,0,{"$f":"'C'!F60","v":0},{"$f":"'C'!G60","v":0},{"$f":"'C'!H60","v":0},{"$f":"'C'!I60","v":0},{"$f":"'C'!J60","v":0},{"$f":"'C'!K60","v":0},{"$f":"'C'!L60","v":0}]
[null,"ACCOUNTING/BOOKKEEPING SALARIES & WAGES",0,0,{"$f":"'C'!F53","v":0},{"$f":"'C'!G53","v":0},{"$f":"'C'!H53","v":0},{"$f":"'C'!I53","v":0},{"$f":"'C'!J53","v":0},{"$f":"'C'!K53","v":0},{"$f":"'C'!L53","v":0}]
[null,"ACCOUNTING/BOOKEEPING BENEFITS & PR TAXES",0,0,{"$f":"'C'!F61","v":0},{"$f":"'C'!G61","v":0},{"$f":"'C'!H61","v":0},{"$f":"'C'!I61","v":0},{"$f":"'C'!J61","v":0},{"$f":"'C'!K61","v":0},{"$f":"'C'!L61","v":0}]
[null,"MAINTENANCE SALARIES & WAGES",0,0,{"$f":"'C'!F54","v":0},{"$f":"'C'!G54","v":0},{"$f":"'C'!H54","v":0},{"$f":"'C'!I54","v":0},{"$f":"'C'!J54","v":0},{"$f":"'C'!K54","v":0},{"$f":"'C'!L54","v":0}]
[null,"MAINTENANCE BENEFITS & PR TAXES",0,0,{"$f":"'C'!F62","v":0},{"$f":"'C'!G62","v":0},{"$f":"'C'!H62","v":0},{"$f":"'C'!I62","v":0},{"$f":"'C'!J62","v":0},{"$f":"'C'!K62","v":0},{"$f":"'C'!L62","v":0}]
[null,"OTHER NON-ISS STAFF SALARIES & WAGES",0,0,{"$f":"'C'!F55","v":0},{"$f":"'C'!G55","v":0},{"$f":"'C'!H55","v":0},{"$f":"'C'!I55","v":0},{"$f":"'C'!J55","v":0},{"$f":"'C'!K55","v":0},{"$f":"'C'!L55","v":0}]
[null,"OTHER NON-ISS STAFF BENEFITS & PR TAXES",0,0,{"$f":"'C'!F63","v":0},{"$f":"'C'!G63","v":0},{"$f":"'C'!H63","v":0},{"$f":"'C'!I63","v":0},{"$f":"'C'!J63","v":0},{"$f":"'C'!K63","v":0},{"$f":"'C'!L63","v":0}]
[null,"PURCHASED PROFESSIONAL SERVICES",0,0,{"$f":"_C000260","v":0},{"$f":"_C000261","v":0},{"$f":"_C000262","v":0},{"$f":"_C000263","v":0},{"$f":"_C000264","v":0},{"$f":"_C000265","v":0},{"$f":"_C000266","v":0}]
[null,"MANAGEMENT FEES",0,0,{"$f":"_C000268","v":0},{"$f":"_C000269","v":0},{"$f":"_C000270","v":0},{"$f":"_C000271","v":0},{"$f":"_C000272","v":0},{"$f":"_C000273","v":0},{"$f":"_C000274","v":0}]
[null,"TOTAL ADMINISTRATIVE EXPENSE",{"$f":"SUM(C82:C99)","v":0},0,0,{"$f":"SUM(F82:F99)","v":0},0,0,0,{"$f":"SUM(J82:J99)","v":0},{"$f":"SUM(K82:K99)","v":0}]
[5,"PROGRAM OPERATIONS EXPENSE"]
[null,"Administrative Supplies",{"$f":"SUM(E102:H102)","v":0},{"$f":"SUM(E102:K102)","v":0},{"$f":"_C000324","v":0},{"$f":"_C000325","v":0},{"$f":"_C000326","v":0},{"$f":"_C000327","v":0},{"$f":"_C000328","v":0},{"$f":"_C000329","v":0},{"$f":"_C000330","v":0}]
[null,"Administrative Travel Expenses",{"$f":"SUM(E103:H103)","v":0},{"$f":"SUM(E103:K103)","v":0},{"$f":"_C000332","v":0},{"$f":"_C000333","v":0},{"$f":"_C000334","v":0},{"$f":"_C000335","v":0},{"$f":"_C000336","v":0},{"$f":"_C000337","v":0},{"$f":"_C000338","v":0}]
[null,"Advertising Expense",{"$f":"SUM(E104:H104)","v":0},{"$f":"SUM(E104:K104)","v":0},{"$f":"_C000340","v":0},{"$f":"_C000341","v":0},{"$f":"_C000342","v":0},{"$f":"_C000343","v":0},{"$f":"_C000344","v":0},{"$f":"_C000345","v":0},{"$f":"_C000346","v":0}]
[null,"Professional Liability Insurance",{"$f":"SUM(E105:H105)","v":0},{"$f":"SUM(E105:K105)","v":0},{"$f":"_C000348","v":0},{"$f":"_C000349","v":0},{"$f":"_C000350","v":0},{"$f":"_C000351","v":0},{"$f":"_C000352","v":0},{"$f":"_C000353","v":0},{"$f":"_C000354","v":0}]
[null,"Other General Admin. Expense",{"$f":"SUM(E106:H106)","v":0},{"$f":"SUM(E106:K106)","v":0},{"$f":"_C000356","v":0},{"$f":"_C000357","v":0},{"$f":"_C000358","v":0},{"$f":"_C000359","v":0},{"$f":"_C000360","v":0},{"$f":"_C000361","v":0},{"$f":"_C000362","v":0}]
[null,"TOTAL PROGRAM OPERATIONS EXPENSE",{"$f":"SUM(C102:C106)","v":0},0,0,0,0,0,0,{"$f":"SUM(J102:J106)","v":0},{"$f":"SUM(K102:K106)","v":0}]
[6,"CAPITAL & PROPERTY EXPENSES"]
[null,"Depreciation - Bldgs., Bldg. Improv., Leasehold Improv., Furn. & Equip",{"$f":"SUM(E109:H109)","v":0},{"$f":"SUM(E109:K109)","v":0},{"$f":"_C000444","v":0},{"$f":"_C000445","v":0},{"$f":"_C000446","v":0},{"$f":"_C000447","v":0},{"$f":"_C000448","v":0},{"$f":"_C000449","v":0},{"$f":"_C000450","v":0}]
[null,"     Square Footage",0,0,{"$f":"'C'!F92","v":0},{"$f":"'C'!G92","v":0},{"$f":"'C'!H92","v":0},{"$f":"'C'!I92","v":0},{"$f":"'C'!J92","v":0},{"$f":"'C'!K92","v":0},{"$f":"'C'!L92","v":0}]
[null,"Communications Expense ",0,0,{"$f":"_C000452","v":0},{"$f":"_C000453","v":0},{"$f":"_C000454","v":0},{"$f":"_C000455","v":0},{"$f":"_C000456","v":0},{"$f":"_C000457","v":0},{"$f":"_C000458","v":0}]
[null,"Facility Insurance Expense",0,0,{"$f":"_C000460","v":0},{"$f":"_C000461","v":0},{"$f":"_C000462","v":0},{"$f":"_C000463","v":0},{"$f":"_C000464","v":0},{"$f":"_C000465","v":0},{"$f":"_C000466","v":0}]
[null,"Office Rent Expense",0,0,{"$f":"_C001581","v":0},{"$f":"_C000469","v":0},{"$f":"_C000470","v":0},{"$f":"_C000471","v":0},{"$f":"_C000472","v":0},{"$f":"_C000473","v":0},{"$f":"_C000474","v":0}]
[null,"     Square Footage",0,0,{"$f":"_C000476","v":0},{"$f":"_C000477","v":0},{"$f":"_C000478","v":0},{"$f":"_C000479","v":0},{"$f":"_C000480","v":0},{"$f":"_C000481","v":0},{"$f":"_C000482","v":0}]
[null,"Lease Payments Expense",0,0,{"$f":"'C'!F97","v":0},{"$f":"'C'!G97","v":0},{"$f":"'C'!H97","v":0},{"$f":"'C'!I97","v":0},{"$f":"'C'!J97","v":0},{"$f":"'C'!K97","v":0},{"$f":"'C'!L97","v":0}]
[null,"Utilities Expense",0,0,{"$f":"_C000484","v":0},{"$f":"_C000485","v":0},{"$f":"_C000486","v":0},{"$f":"_C000487","v":0},{"$f":"_C000488","v":0},{"$f":"_C000489","v":0},{"$f":"_C000490","v":0}]
[null,"Property Taxes",0,0,{"$f":"_C000492","v":0},{"$f":"_C000493","v":0},{"$f":"_C000494","v":0},{"$f":"_C000495","v":0},{"$f":"_C000496","v":0},{"$f":"_C000497","v":0},{"$f":"_C000498","v":0}]
[null,"Minor Equipment Expense",0,0,{"$f":"_C000500","v":0},{"$f":"_C000501","v":0},{"$f":"_C000502","v":0},{"$f":"_C000503","v":0},{"$f":"_C000504","v":0},{"$f":"_C000505","v":0},{"$f":"_C000506","v":0}]
[null,"Other Property Expense",0,0,{"$f":"_C000508","v":0},{"$f":"_C000509","v":0},{"$f":"_C000510","v":0},{"$f":"_C000511","v":0},{"$f":"_C000512","v":0},{"$f":"_C000513","v":0},{"$f":"_C000514","v":0}]
[null,"TOTAL CAPTIAL & PROPERTY EXPENSE",{"$f":"SUM(C109,C111:C113,C115:C119)","v":0},0,0,0,0,0,0,0,0]
[7,"INTEREST & TAX EXPENSE"]
[null,"INTEREST EXPENSE: Working Capital & Line-of-Credit Debt Exp. ",{"$f":"SUM(E122:H122)","v":0},{"$f":"SUM(E122:K122)","v":0},{"$f":"_C000540","v":0},{"$f":"_C000541","v":0},{"$f":"_C000542","v":0},{"$f":"_C000543","v":0},{"$f":"_C000544","v":0},{"$f":"_C000545","v":0},{"$f":"_C000546","v":0}]
[null,"BUSINESS TAXES",{"$f":"SUM(E123:H123)","v":0},{"$f":"SUM(E123:K123)","v":0},{"$f":"_C000548","v":0},{"$f":"_C000549","v":0},{"$f":"_C000550","v":0},{"$f":"_C000551","v":0},{"$f":"_C000552","v":0},{"$f":"_C000553","v":0},{"$f":"_C000554","v":0}]
[8,"TOTALS",{"$f":"+C100+C107+C120+C122+C123","v":0},0,0,0,0,0,0,{"$f":"+J100+J107+J120+J122+J123","v":0},{"$f":"+K100+K107+K120+K122+K123","v":0}]
[3,"ADMIN. & OTHER NON ISS STAFF HOURS","TOTAL SCHEDULE C-Sum",null,"TOTAL SCHEDULE C-Sum"]
[null,"ADMINISTRATOR HOURS WORKED",{"$f":"SUM(E126:H126)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E126:K126)","v":{"$error":"#DIV/0!"}},{"$f":"+E20+E73","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OWNER HOURS WORKED",{"$error":"#DIV/0!"},{"$f":"SUM(E127:K127)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CHIEF EXECUTIVE HOURS WORKED",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER AMDINISTRATIVE STAFF HOURS WORKED",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROGRAM  MANAGEMENT HOURS WORKED",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+E24+E77","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J24+J77","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"ACCOUNTING/BOOKKEEPING HOURS WORKED",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MAINTENANCE HOURS WORKED ",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER NON ISS STAFF HOURS WORKED",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[4,"ADMINISTRATIVE EXPENSES"]
[null,"ADMINISTRATOR SALARIES & WAGES",{"$error":"#DIV/0!"},{"$f":"SUM(E135:K135)","v":{"$error":"#DIV/0!"}},{"$f":"+E29+E82","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J29+J82","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"ADMINISTRATOR BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$f":"SUM(E136:K136)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OWNER SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OWNER BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CHIEF EXECUTIVE SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CHIEF EXECUTIVE BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER ADMINISTRATIVE STAFF SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER ADMINISTRATIVE STAFF BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROGRAM MANAGEMENT SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROGRAM MANAGEMENT BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ACCOUNTING/BOOKKEEPING SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+E39+E92","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ACCOUNTING/BOOKEEPING BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MAINTENANCE SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MAINTENANCE BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER NON-ISS STAFF SALARIES & WAGES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER NON-ISS STAFF BENEFITS & PR TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PURCHASED PROFESSIONAL SERVICES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MANAGEMENT FEES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL ADMINISTRATIVE EXPENSES",{"$f":"SUM(C135:C152)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J135:J152)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K135:K152)","v":{"$error":"#DIV/0!"}}]
[5,"PROGRAM OPERATIONS/OVERHEAD EXPENSES"]
[null,"ADMINISTRATIVE SUPPLIES",{"$f":"SUM(E155:H155)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E155:K155)","v":{"$error":"#DIV/0!"}},{"$f":"+E49+E102","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J49+J102","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"ADMINISTRATIVE TRAVEL EXPENSES",{"$f":"SUM(E156:H156)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E156:K156)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"ADVERTISING EXPENSE",{"$f":"SUM(E157:H157)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E157:K157)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROFESSIONAL LIABILITY INSURANCE",{"$f":"SUM(E158:H158)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E158:K158)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER GENERAL ADMINISTRATIVE EXPENSES",{"$f":"SUM(E159:H159)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E159:K159)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL PROGRAM OPERATIONS/OVERHEAD EXPENSES",{"$f":"SUM(C155:C159)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"SUM(J155:J159)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K155:K159)","v":{"$error":"#DIV/0!"}}]
[6,"CAPITAL & PROPERTY EXPENSES"]
[null,"DEPRECIATION - BLDGS, BLDG/LEASEHOLD IMPROVEMENTS, FURNITURE & EQUIPTMENT",{"$f":"SUM(E162:H162)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E162:K162)","v":{"$error":"#DIV/0!"}},{"$f":"+E56+E109","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J56+J109","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,"     SQUARE FOOTAGE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TELEPHONE EXPENSE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"CAPITAL & PROPERTY INSURANCE EXPENSES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OFFICE RENT EXPENSE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"     SQUARE FOOTAGE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"LEASE PAYMENTS EXPENSE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"UTILITIES EXPENSE",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"PROPERTY TAXES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"MINOR EQUIPMENT EXPENSES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"OTHER CAPITAL & PROPERTY EXPENSES",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL CAPITAL & PROPERTY EXPENSES",{"$f":"SUM(C162,C164:C166,C168:C172)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D162,D164:D166,D168:D172)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E162,E164:E166,E168:E172)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F162,F164:F166,F168:F172)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[7,"INTEREST & TAX EXPENSE"]
[null,"WORKING CAPITAL & LOC INTEREST EXPENSES",{"$f":"SUM(E175:H175)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E175:K175)","v":{"$error":"#DIV/0!"}},{"$f":"+E69+E122","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J69+J122","v":{"$error":"#DIV/0!"}},{"$f":"+K69+K122","v":{"$error":"#DIV/0!"}}]
[null,"BUSINESS TAXES",{"$f":"SUM(E176:H176)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E176:K176)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J70+J123","v":{"$error":"#DIV/0!"}},{"$f":"+K70+K123","v":{"$error":"#DIV/0!"}}]
[8,"TOTAL SCHEDULE C EXPENSES",{"$f":"+C153+C160+C173+C175+C176","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"+J153+J160+J173+J175+J176","v":{"$error":"#DIV/0!"}},{"$f":"+K153+K160+K173+K175+K176","v":{"$error":"#DIV/0!"}}]
[{"$f":"+A177+1","v":9},"TOTAL EXPENSES FROM SCHEDULE C",{"$f":"SUM(E178:H178)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E178:K178)","v":{"$error":"#DIV/0!"}},{"$f":"+E177","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[10,"ISS STAFF SALARIES & WAGES (INCLUDING PTO)",0,0,{"$f":"_C000864","v":0},{"$f":"_C000865","v":0},{"$f":"_C000866","v":0},{"$f":"_C000867","v":0},{"$f":"_C000868","v":0},{"$f":"_C000869","v":0},{"$f":"_C000870","v":0}]
[11,"PROFESSIONAL SVS ISS STAFF SALARIES & WAGES (INCLUDING PTO)",0,0,{"$f":"_C000872","v":0},{"$f":"_C000873","v":0},{"$f":"_C000874","v":0},{"$f":"_C000875","v":0},{"$f":"_C000876","v":0},{"$f":"_C000877","v":0},{"$f":"_C000878","v":0}]
[12,"ISS & PROFESSIONAL SVS ISS STAFF BENEFITS & PR TAXES",0,0,{"$f":"_C000880","v":0},{"$f":"_C000881","v":0},{"$f":"_C000882","v":0},{"$f":"_C000883","v":0},{"$f":"_C000884","v":0},{"$f":"_C000885","v":0},{"$f":"_C000886","v":0}]
[13,"ISS PURCHASED PROFESSIONAL SERVICES",0,0,{"$f":"_C000888","v":0},{"$f":"_C000889","v":0},{"$f":"_C000890","v":0},{"$f":"_C000891","v":0},{"$f":"_C000892","v":0},{"$f":"_C000893","v":0},{"$f":"_C000894","v":0}]
[14,"STAFF LODGING EXPENSES (SALARY & WAGES)",0,0,{"$f":"_C000896","v":0},{"$f":"_C000897","v":0},{"$f":"_C000898","v":0},{"$f":"_C000899","v":0},{"$f":"_C000900","v":0},{"$f":"_C000901","v":0},{"$f":"_C000902","v":0}]
[{"$f":"+A183+1","v":15},"TOT ISS/DIRECT CARE STAFF COMPENSATION",{"$f":"SUM(C179:C183)","v":0},0,0,0,0,0,0,0,0]
[16,"ADMINISTRATOR ISS SALARY & WAGES",{"$f":"SUM(E185:H185)","v":0},{"$f":"SUM(E185:K185)","v":0},{"$f":"_C000912","v":0},{"$f":"_C000913","v":0},{"$f":"_C000914","v":0},{"$f":"_C000915","v":0},{"$f":"_C000916","v":0},{"$f":"_C000917","v":0},{"$f":"_C000918","v":0}]
[17,"ADMINISTRATOR ISS BENEFITS & PR TAXES",{"$f":"SUM(E186:H186)","v":0},{"$f":"SUM(E186:K186)","v":0},{"$f":"_C000920","v":0},{"$f":"_C000921","v":0},{"$f":"_C000922","v":0},{"$f":"_C000923","v":0},{"$f":"_C000924","v":0},{"$f":"_C000925","v":0},{"$f":"_C000926","v":0}]
[18,"TOTAL ADMINISTRATOR ISS COMPENSATION",{"$f":"SUM(C185:C186)","v":0},0,0,0,0,0,0,{"$f":"SUM(J185:J186)","v":0},{"$f":"SUM(K185:K186)","v":0}]
[19,"NON-ISS STAFF LODGING EXPENSES (HOUSING FOR ON DUTY STAFF - NOT PRIMARY HOME FOR STAFF)",{"$f":"SUM(E188:H188)","v":0},{"$f":"SUM(E188:K188)","v":0},{"$f":"_C000936","v":0},{"$f":"_C000937","v":0},{"$f":"_C000938","v":0},{"$f":"_C000939","v":0},{"$f":"_C000940","v":0},{"$f":"_C000941","v":0},{"$f":"_C000942","v":0}]
[20,"FOOD COSTS - RESIDENT (GH ONLY)",{"$f":"SUM(E189:H189)","v":0},0,{"$f":"_C000944","v":0},{"$f":"_C000945","v":0},{"$f":"_C000946","v":0},{"$f":"_C000947","v":0},{"$f":"_C000948","v":0},{"$f":"_C000949","v":0},{"$f":"_C000950","v":0}]
[21,"FOOD COSTS - STAFF",0,0,{"$f":"_C000952","v":0},{"$f":"_C000953","v":0},{"$f":"_C000954","v":0},{"$f":"_C000955","v":0},{"$f":"_C000956","v":0},{"$f":"_C000957","v":0},{"$f":"_C000958","v":0}]
[22,"EDUCATION & IN-SERVICE TRAINING & SUPPLIES",0,0,{"$f":"_C000960","v":0},{"$f":"_C000961","v":0},{"$f":"_C000962","v":0},{"$f":"_C000963","v":0},{"$f":"_C000964","v":0},{"$f":"_C000965","v":0},{"$f":"_C000966","v":0}]
[23,"ACTIVITY & HABILITATIVE SUPPLIES EXPENSES",0,0,{"$f":"_C000968","v":0},{"$f":"_C000969","v":0},{"$f":"_C000970","v":0},{"$f":"_C000971","v":0},{"$f":"_C000972","v":0},{"$f":"_C000973","v":0},{"$f":"_C000974","v":0}]
[24,"NURSING SUPPLIES EXPENSES",0,0,{"$f":"_C000976","v":0},{"$f":"_C000977","v":0},{"$f":"_C000978","v":0},{"$f":"_C000979","v":0},{"$f":"_C000980","v":0},{"$f":"_C000981","v":0},{"$f":"_C000982","v":0}]
[25,"TRANSPORTATION EXPENSES"]
[26,"STAFF MILEAGE REIMBURSEMENT",0,{"$f":"SUM(E195:K195)","v":0},{"$f":"_C000984","v":0},{"$f":"_C000985","v":0},{"$f":"_C000986","v":0},{"$f":"_C000987","v":0},{"$f":"_C000988","v":0},{"$f":"_C000989","v":0},{"$f":"_C000990","v":0}]
[{"$f":"+A195+1","v":27},"OTHER VEHICILE EXPENSES",0,{"$f":"SUM(E196:K196)","v":0},{"$f":"_C000992","v":0},{"$f":"_C000993","v":0},{"$f":"_C000994","v":0},{"$f":"_C000995","v":0},{"$f":"_C000996","v":0},{"$f":"_C000997","v":0},{"$f":"_C000998","v":0}]
[{"$f":"+A196+1","v":28},"     MILEAGE - STAFF OWNED VEHICLES",0,{"$f":"SUM(E197:K197)","v":0},{"$f":"E!E36","v":0},{"$f":"E!F36","v":0},{"$f":"E!G36","v":0},{"$f":"E!H36","v":0},{"$f":"E!I36","v":0},{"$f":"E!J36","v":0},{"$f":"E!K36","v":0}]
[{"$f":"+A197+1","v":29},"     MILEAGE - AGENCY OWNED VEHICLES",0,{"$f":"SUM(E198:K198)","v":0},{"$f":"E!E37","v":0},{"$f":"E!F37","v":0},{"$f":"E!G37","v":0},{"$f":"E!H37","v":0},{"$f":"E!I37","v":0},{"$f":"E!J37","v":0},{"$f":"E!K37","v":0}]
[{"$f":"+A198+1","v":30},"MAINTENANCE/LAUNDRY/HOUSEKEEPING/DIETARY"]
[31,"SALARIES & WAGES",0,{"$f":"SUM(E200:K200)","v":0},{"$f":"_C001000","v":0},{"$f":"_C001001","v":0},{"$f":"_C001002","v":0},{"$f":"_C001003","v":0},{"$f":"_C001004","v":0},{"$f":"_C001005","v":0},{"$f":"_C001007","v":0}]
[32,"BENEFITS & PR TAXES",0,0,{"$f":"_C001009","v":0},{"$f":"_C001010","v":0},{"$f":"_C001011","v":0},{"$f":"_C001012","v":0},{"$f":"_C001013","v":0},{"$f":"_C001014","v":0},{"$f":"_C001015","v":0}]
[33,"SUPPLIES - LINENS & BEDDING",0,0,{"$f":"_C001017","v":0},{"$f":"_C001018","v":0},{"$f":"_C001019","v":0},{"$f":"_C001020","v":0},{"$f":"_C001021","v":0},{"$f":"_C001022","v":0},{"$f":"_C001023","v":0}]
[34,"PURCHASED SERVICES",0,0,{"$f":"_C001025","v":0},{"$f":"_C001026","v":0},{"$f":"_C001027","v":0},{"$f":"_C001028","v":0},{"$f":"_C001029","v":0},{"$f":"_C001030","v":0},{"$f":"_C001031","v":0}]
[35,"TOTAL MAINTENANCE/LAUNDRY/HOUSEKEEPING/DIETARY",{"$f":"SUM(E204:H204)","v":0},0,{"$f":"SUM(E188:E193,E195:E196,E200:E203)","v":0},0,0,0,0,0,0]
[36,"TOTAL ISS & NON-ISS EXPENSES",{"$f":"SUM(E205:H205)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"+E178+E184+E187+E204","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[37,"PAID ISS HOURS WORKED",{"$f":"SUM(E206:H206)","v":0},0,{"$f":"+E14","v":0},0,0,0,0,0,0]
[38,"COST PER HOUR - NON-ISS/ADMINISTRATIVE COSTS",{"$f":"IF(C205=0,0,IF(C206=0,0,ROUND(+C205/C206,2)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(D205=0,0,IF(D206=0,0,ROUND(+D205/D206,2)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(E205=0,0,IF(E206=0,0,ROUND(+E205/E206,2)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[39,"COST PER HOUR - ISS/DIRECT CARE & CLIENT RELATED COSTS",{"$f":"IF(C178=0,0,IF(C14=0,0,ROUND((+C178)/C14,2)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[40,"COST PER HOUR - TOTAL PROGRAM (ISS & NON-ISS)",{"$f":"IF((C205-C178)=0,0,IF(C14=0,0,ROUND((+C205-C178)/C14,2)))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[41,"PAYMENTS RECEIVED FROM STATE (ISS & NON-ISS)",{"$f":"SUM(E210:H210)","v":0},{"$f":"SUM(E210:K210)","v":0},{"$f":"_C001296","v":0},{"$f":"_C001297","v":0},{"$f":"_C001298","v":0},{"$f":"_C001299","v":0},{"$f":"_C001300","v":0},{"$f":"_C001301","v":0},{"$f":"_C001302","v":0}]
[42,"CLIENT PARTICIPATION",0,0,{"$f":"_C001304","v":0},{"$f":"_C001305","v":0},{"$f":"_C001306","v":0},{"$f":"_C001307","v":0},{"$f":"_C001308","v":0},{"$f":"_C001309","v":0},{"$f":"_C001310","v":0}]
[43,"OTHER SERVICES REVENUE",0,0,{"$f":"_C001312+_C001320+_C001328","v":0},{"$f":"_C001313+_C001321+_C001329","v":0},{"$f":"_C001314+_C001322+_C001330","v":0},{"$f":"_C001315+_C001323+_C001331","v":0},{"$f":"_C001316+_C001324+_C001332","v":0},{"$f":"_C001317+_C001325+_C001333","v":0},{"$f":"_C001318+_C001326+_C001334","v":0}]
[44,"TOTAL SERVICES REVENUE",0,0,{"$f":"SUM(E210:E212)","v":0},0,0,0,0,0,0]
[45,"OTHER OPERATING REVENUE",0,0,{"$f":"_C001376","v":0},{"$f":"_C001377","v":0},{"$f":"_C001378","v":0},{"$f":"_C001379","v":0},{"$f":"_C001380","v":0},{"$f":"_C001381","v":0},{"$f":"_C001382","v":0}]
[46,"NON OPERATING REVENUE",0,0,{"$f":"_C001416","v":0},{"$f":"_C001417","v":0},{"$f":"_C001418","v":0},{"$f":"_C001419","v":0},{"$f":"_C001420","v":0},{"$f":"_C001421","v":0},{"$f":"_C001422","v":0}]
[47,"TOTAL REVENUES (SCHEDULE H)",{"$f":"SUM(C213:C215)","v":0},{"$f":"SUM(D213:D215)","v":0},{"$f":"SUM(E213:E215)","v":0},0,0,0,{"$f":"SUM(I213:I215)","v":0},0,0]
[48,"REIMBURSED ISS HOURS",{"$f":"_C001662","v":0},{"$f":"SUM(E217:K217)","v":0},{"$f":"_C001606+_C001611","v":0},{"$f":"_C001616+_C001621","v":0},null,null,0,0,0]
[49,"REIMBURSED NURSE DELEGATION HOURS",{"$f":"SUM('J Detail'!D22:D25)","v":0},{"$f":"SUM(E218:K218)","v":{"$error":"#DIV/0!"}},{"$f":"C218*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C218*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C218*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C218*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[50,"REIMBURSED STAFF ADD-ON HOURS",{"$f":"SUM('J Detail'!D26:D29)","v":0},{"$f":"SUM(E219:K219)","v":{"$error":"#DIV/0!"}},{"$f":"C219*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C219*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C219*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C219*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[{"$f":"+A219+1","v":51},"REIMBURSED NON-BENCHMARK PROFESSIONAL SERVICES HOURS",{"$f":"_C001714","v":0},{"$f":"SUM(E220:K220)","v":{"$error":"#DIV/0!"}},{"$f":"C220*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C220*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C220*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C220*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[52,"TOTAL REIMBURSED ISS HOURS",{"$f":"SUM(C217:C220)","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0]
[53,"TOTAL PROVIDER PAID ISS HOURS WORKED",{"$f":"SUM(E222:H222)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E222:K222)","v":{"$error":"#DIV/0!"}},{"$f":"+E14-('B-1'!E18*_C002548/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"+F14-('B-1'!E18*_C002549/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"+G14-('B-1'!E18*_C002550/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"+H14-('B-1'!E18*_C002551/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"+I14","v":0},{"$f":"+J14","v":0},{"$f":"+K14","v":0}]
[{"$f":"+A222+1","v":54},"PROVIDER PAID ISS HOURS WORKED BY ADMINISTRATOR",{"$f":"'J Summary'!_C001584","v":0},0,{"$f":"C223*(_C002578/C222)","v":{"$error":"#DIV/0!"}},{"$f":"C223*(_C002579/C222)","v":{"$error":"#DIV/0!"}},{"$f":"C223*(_C002580/C222)","v":{"$error":"#DIV/0!"}},{"$f":"C223*(_C002581/C222)","v":{"$error":"#DIV/0!"}},0,0,0]
[55,"PROVIDER PAID ISS HOURS WORKED BY ISS STAFF",{"$f":"SUM(E224:H224)","v":{"$error":"#DIV/0!"}},{"$f":"+D222-D223","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0]
[{"$f":"+A224+1","v":56},"ISS HOURS NOT PROVIDED",{"$f":"C222-C221","v":{"$error":"#DIV/0!"}},null,{"$f":"_C002578-_C002572","v":{"$error":"#DIV/0!"}},{"$f":"_C002579-_C002573","v":{"$error":"#DIV/0!"}},{"$f":"IF(G221-G222<0,0,(G221-G222))","v":{"$error":"#DIV/0!"}},{"$f":"IF(H221-H222<0,0,(H221-H222))","v":{"$error":"#DIV/0!"}},0,0,0]
[null,"ISS HOURS NOT PROVIDED TIMES AVERAGE REIMBURSEMENT RATE",{"$f":"-C225*(C229/C221)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E226:K226)","v":{"$error":"#DIV/0!"}},{"$f":"C226*(_C002548/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"C226*(_C002549/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"C226*(_C002550/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},{"$f":"C226*(_C002551/SUM(RES!E217:H217))","v":{"$error":"#DIV/0!"}},0,0,0]
[{"$f":"+A225+1","v":57},"Consideration of Overtime Credit (Additional payroll expense applicable to Settlement A)",{"$f":"SUM(E227:H227)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$f":"-('J Summary'!$F$11-('J Summary'!$E$11*('J Summary'!_C001589/'J Summary'!_C001582)))*_C002548/SUM(RES!E217:H217)","v":{"$error":"#DIV/0!"}},{"$f":"-('J Summary'!$F$11-('J Summary'!$E$11*('J Summary'!_C001589/'J Summary'!_C001582)))*_C002549/SUM(RES!E217:H217)","v":{"$error":"#DIV/0!"}},{"$f":"('J Summary'!$F$11-('J Summary'!$E$11*('J Summary'!_C001589/'J Summary'!_C001582)))*_C002550/SUM(RES!E217:H217)","v":{"$error":"#DIV/0!"}},{"$f":"('J Summary'!$F$11-('J Summary'!$E$11*('J Summary'!_C001589/'J Summary'!_C001582)))*_C002551/SUM(RES!E217:H217)","v":{"$error":"#DIV/0!"}},0,0,0]
[{"$f":"+A227+1","v":58},"NET SETTLEMENT A",{"$f":"'J Summary'!_C001588","v":0},{"$error":"#DIV/0!"},{"$f":"C228*_C002578/SUM(_C002578+_C002579)","v":{"$error":"#DIV/0!"}},{"$f":"C228*_C002579/SUM(_C002578+_C002579)","v":{"$error":"#DIV/0!"}},{"$f":"C228*_C002580/SUM(_C002578+_C002579)","v":{"$error":"#DIV/0!"}},{"$f":"E228*_C002581/SUM(_C002578+_C002579)","v":{"$error":"#DIV/0!"}},0,0,0]
[59,"TOTAL ISS REIMBURSEMENT (FROM SCHEDULE J SUMMARY, LINE 9)",{"$f":"'J Summary'!_C001589","v":0},{"$error":"#DIV/0!"},{"$f":"C229*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C229*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C229*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C229*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[60,"PROVIDER ISS/DIRECT CARE COSTS: (INCLUDES ADMINISTRATOR AS ISS COSTS) ",{"$f":"SUM(E230:H230)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"_C002374+E!E18","v":{"$error":"#N/A"}},{"$f":"_C002375+E!F18","v":{"$error":"#N/A"}},{"$f":"_C002376+E!G18","v":{"$error":"#N/A"}},{"$f":"_C002377+E!H18","v":{"$error":"#N/A"}},{"$f":"_C002378","v":0},{"$f":"J184","v":0},{"$f":"K184","v":0}]
[null,"ALLOWABLE GH ADMINISTRATOR ISS COSTS ",{"$f":"SUM(E231:H231)","v":0},0,{"$f":"_C002392","v":0},{"$f":"_C002393","v":0},{"$f":"_C002394","v":0},{"$f":"_C002395","v":0},{"$f":"_C002396","v":0},{"$f":"J187","v":0},{"$f":"K187","v":0}]
[{"$f":"+A230+1","v":61},"ALLOWABLE SL/GH ADMINISTRATOR ISS COSTS ",{"$f":"'J Summary'!F18","v":0},{"$error":"#DIV/0!"},{"$f":"C232*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C232*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C232*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C232*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[62,"TOTAL ISS STAFF COSTS",{"$f":"SUM(E233:H233)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"SUM(E230:E232)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0]
[63,"SETTLEMENT B ",{"$f":"IF(SUM(E234:H234)>0,SUM(E234:H234),0)","v":{"$error":"#DIV/0!"}},null,{"$f":"+E229-E233","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0]
[64,"SETTLEMENT: A OR B ",{"$f":"IF(C228>0,IF(C228>C234,C228,C234),C234)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},0,0,0]
[65,"NET TOTAL ISS & NON-ISS COST (FROM SCHEDULE E)",{"$f":"SUM(E236:H236)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(E236:K236)","v":{"$error":"#DIV/0!"}},{"$f":"+E205","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[66,"LESS: ALLOWABLE ISS COSTS",{"$f":"SUM(E237:H237)","v":{"$error":"#N/A"}},{"$f":"SUM(E237:K237)","v":{"$error":"#N/A"}},{"$f":"+E233","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},0,0,0]
[67,"NET NON-ISS STAFF COSTS",{"$f":"+C236-C237","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[68,"TOTAL NON-STAFF/ADMINISTRATIVE REIMBURSEMENT (SCHEDULE J DETAIL BY CLIENT CELL AR2)",{"$f":"'J Detail'!F46","v":0},{"$f":"SUM(E239:K239)","v":{"$error":"#DIV/0!"}},{"$f":"C239*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C239*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C239*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C239*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[69,"EXCESS NON-ISS COSTS OVER NON-ISS REIMBURSEMENTS",{"$f":"IF(+C238-C239>0,C238-C239,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(+D238-D239>0,D238-D239,0)","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"IF(+J238-J239>0,J238-J239,0)","v":{"$error":"#DIV/0!"}},{"$f":"IF(+K238-K239>0,K238-K239,0)","v":{"$error":"#DIV/0!"}}]
[70,"REGULAR ISS HOURS (SCHEDULE B-1, COLUMN 5 & 7)",{"$f":"SUM('B-1'!$E$19:$E$22,'B-1'!$G$19:$G$22)","v":0},0,{"$f":"C241*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C241*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C241*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C241*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]
[71,"OVERTIME ISS HOURS (SCHEDULE B-1, COLUMN 6)",{"$f":"SUM('B-1'!$F$19:$F$22)","v":0},0,{"$f":"C242*(_C002548/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C242*(_C002549/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C242*(_C002550/C217)","v":{"$error":"#DIV/0!"}},{"$f":"C242*(_C002551/C217)","v":{"$error":"#DIV/0!"}},0,0,0]

{"sheet":"A","index":2,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,5],[18,3,18,4],[26,2,26,3],[23,1,23,3],[29,2,29,3],[2,1,2,4],[28,1,28,3],[6,1,6,2],[25,1,25,3],[4,1,5,2],[8,3,8,4],[10,3,10,4],[12,1,12,4],[14,3,14,4],[16,2,16,4],[20,3,20,4]]}
["SCHEDULE  A"]
[]
[]
[null,"PART A - PROVIDER IDENTIFYING INFORMATION"]
[null,"1. PROVIDER AGENCY NAME",null,"2. PROVIDER ONE ID (a) SSPS ID (b)"]
[null,null,null,{"$f":"IF(_M000001=\"\",\"\",VLOOKUP(_M000001,Lists!$A$2:$C$138,2,FALSE))","v":""},"a"]
[null,null,null,{"$f":"IF(_M000001=\"\",\"\",IF(VLOOKUP(_M000001,Lists!$A$2:$C$138,3,FALSE)=\"\",\"\",VLOOKUP(_M000001,Lists!$A$2:$C$138,3,FALSE)))","v":""},"b"]
[null,"3. PROVIDER MAILING ADDRESS","4. CITY, ZIP ","5. PROVIDER PHONE NUMBER"]
[]
[null,"6. ADMINISTRATOR","7. E-MAIL ADDRESS","8. DDA REGION ID"]
[null,null,null,{"$f":"LEFT(_M000001,2)","v":""}]
[null,"9. HOME OFFICE/CORPORATE NAME (please indicate if NONE or SAME AS ABOVE)"]
[]
[null,"10. HOME OFFICE MAILING ADDRESS","11. CITY AND ZIP","12. HOME OFFICE PHONE No."]
[]
[null,"13. COST REPORT PREPARER","14. FIRM NAME"]
[]
[null,"15. REPORT CONTACT INDIVIDUAL(S)","16. CONTACT PHONE #","17. CONTACT e-mail Address"]
[]
[null,"18. COST REPORT PERIOD",null,"19.       REPORTING PURPOSE"]
[null,"2018-01-01","2018-12-31","Cost Report"]
[null,"FROM:","TO:"]
[null,"PART B. - CERTIFICATION"]
[null,"MISREPRESENTATION OR FALSIFICATION OF ANY INFORMATION CONTAINED IN THIS COST REPORT MAY BE PUNISHABLE BY FINE AND/OR IMPRISONMENT UNDER STATE OR FEDERAL LAW"]
[null,null,"CERTIFICATION"]
[null,"  I HEREBY CERTIFY that I have read the above statement and that I have examined the accompanying cost report and"]
[null,"  supporting schedules prepared for: "]
[null,null,"(Provider Name)"]
[null,"and to the best of my knowledge and belief, it is a true, correct and complete statement prepared in accordance with applicable instructions, except as noted."]
[]
[null,null,"SIGNATURE of PERSON SIGNING PROVIDER FEDERAL INCOME TAX RETURN"]
[]
[null,null,"TITLE","DATE"]
[]
[]
[null,"DSHS/DDA Schedule A (Rev. 12/18)"]

{"sheet":"B-1","index":3,"n_rows":26,"n_cols":18,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,17,21,17],[15,1,15,2],[16,1,16,2],[18,1,21,2],[18,15,21,15],[18,16,21,16],[18,9,21,9],[18,8,21,8],[22,13,24,13],[22,10,24,10],[22,11,24,11],[18,14,21,14],[22,12,24,12],[22,14,24,14],[22,16,24,16],[22,17,24,17],[18,3,21,3],[18,4,21,4],[18,5,21,5],[18,6,21,6],[18,7,21,7],[18,10,21,10],[18,11,21,11],[18,12,21,12],[18,13,21,13],[22,3,24,3],[22,6,24,6],[22,7,24,7],[22,4,24,5],[22,15,24,15],[0,0,0,17],[2,14,2,17],[4,7,4,11],[10,1,10,2],[8,1,8,2],[9,1,9,2],[22,8,24,8],[22,9,24,9],[25,4,25,5],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[17,1,17,2]]}
["SCHEDULE B-1"]
[null,null,null,null,null,null,null,null,"CONTRACT-RELATED HOURS AND WAGES ONLY"]
[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,"PROVIDER NAME"]
[]
[]
[]
[null,"STAFF SUMMARY - TO BE SUMMITTED WITH COST REPORT"]
[null,"COL. 1-3",null,"COL. 4","COL. 5","COL. 6","COL. 7","COL. 8a","COL. 8b","COL. 8c","COL. 9","COL. 10","COL. 11","COL. 12","COL. 13","COL. 14","COL. 15","COL. 16"]
[null,"PROVIDER SUMMARY",null,"TOTAL HOURS PER PAYROLL (Column 8c+12+13)","REGULAR INSTRUCTION & SUPPORT (ISS) HOURS","OVERTIME INSTRUCTION & SUPPORT (ISS) HOURS","OTHER INSTRUCTION & SUPPORT (ISS) HOURS &/OR SLEEP/CALL BACK HOURS &/OR AUTHORIZED PURCHASED PROFESSIONAL SERVICE HOURS","TOTAL INSTRUCTION & SUPPORT (ISS) HOURS (Col. 5-7)","NON-CONTRACTED/ SSP DIRECT CARE HOURS USED FOR ALLOCATION PURPOSES","TOTAL INSTRUCTION & SUPPORT (ISS) HOURS & NON-CONTRACTED/ SSP DIRECT CARE HOURS (Column 8a+8b)","REGULAR ADMINISTRATIVE/ NON-ISS HOURS","OVERTIME ADMINISTRATIVE/ NON-ISS HOURS","OTHER ADMINISTRATIVE/ NON-ISS HOURS","TOTAL ADMINISTRATIVE/ NON-ISS HOURS (Col. 9-11)","PAID TIME OFF HOURS (HOLIDAYS, VACATION, SICK LEAVE)","INSTRUCTION & SUPPORT (ISS) SALARIES & WAGES (INCLUDES PAID TIME OFF) - ENTER SALARY & WAGES FOR HOURS REPORTED IN COLUMN 8a & 13 (INCLUDE AUTHORIZED PURCHASED PROFESSIONAL SERVICES, LINE 7). **DO NOT INCLUDE SALARY & WAGES FOR NON-CONTRACTED/ SSP DIRECT CARE HOURS REPORTED IN COLUMN 8b","TOTAL SALARIES & WAGES - ENTER SALARY & WAGES FOR HOURS REPORTED IN COLUMNS 8a, 12, & 13. **DO NOT INCLUDE SALARY & WAGES FOR NON-CONTRACTED/ SSP DIRECT CARE HOURS REPORTED IN COLUMN 8b","TOTAL REPORTABLE ADMINISTRATIVE NON-ISS SALARIES & WAGES"]
[1,"ADMINISTRATIVE AND NON-ISS STAFF ONLY",null,{"$f":"SUM(J11,N11,O11)","v":0},null,null,null,{"$f":"SUM(E11:G11)","v":0},null,{"$f":"SUM(H11:I11)","v":0},0,0,0,{"$f":"SUM(K11:M11)","v":0},0,0,0,{"$f":"IF(Q11-P11<0,0,Q11-P11)","v":0}]
[2,"ISS & PROFESSIONAL SERVICES STAFF W/HOURS SPLIT BETWEEN  ISS, NON-CONTRACTED/SSP AND ADMINISTRATIVE/NON-ISS (INCLUDES EMPLOYEED RN, LPN, DBT, ect.)",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(K12:M12)","v":0},0,0,0,0]
[3,"ISS & PROFESSIONAL SERVICES STAFF ONLY (INCLUDES EMPLOYEED RN, LPN, DBT, ect.)",null,0,0,0,0,0,0,0,null,null,null,null,0,0,{"$f":"P13","v":0},0]
[4,"ADMINISTRATOR ONLY - Group Home",null,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(K14:M14)","v":0},0,0,0,0]
[5,"ADMINISTRATOR ONLY - Supported Living or Combined SL/GH with more than 41,600 ISS hours",null,0,null,null,null,0,0,0,0,0,0,{"$f":"SUM(K15:M15)","v":0},0,0,0,0]
[6,"ADMINISTRATOR ONLY - Supported Living or Combined SL/GH with 41,600 or fewer ISS hours",null,0,null,null,0,0,0,0,0,0,0,{"$f":"SUM(K16:M16)","v":0},0,0,0,0]
[7,"AUTHORIZED PURCHASED DIRECT CARE (ISS) PROFESSIONAL SERVICES (NON-EMPLOYEED RN, LPN, DBT ect.)",null,null,null,null,0,0,null,0,null,null,null,null,null,0]
[8,"1163 Training Hours for the following time period: Jan 1, 2018 - Dec 31, 2018",null,null,0,null,null,{"$f":"SUM(E18:G18)","v":0},null,0]
[null,"TOTAL CONTRACTED ISS, NON-CONTRACTED DIRECT CARE/SSP & ADMINISTRATIVE/NON-ISS HOURS & PAYROLL",null,{"$f":"SUM(D11:D17)","v":0},{"$f":"SUM(E11:E17)","v":0},{"$f":"SUM(F11:F17)","v":0},0,{"$f":"SUM(H11:H17)","v":0},0,{"$f":"SUM(J11:J18)-J18","v":0},0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"Total should equal Sch E, Row 2(a) + 2(b)       (≠1)",{"$f":"SUM($P$12:$P$13)","v":0},"Total contracted hours should equal Sch B-2 and/or internal payroll records","Total hours in column 5 & 6 should equal Sch B, Section 1, Column d",null,"Total hours should equal Sch B, Sec 1, Col (e + f)","Total should equal Sch B, Sec 1, Col. (g) & should also equal Sch B-2 and/or internal payroll records","Total should equal the sum of Sch B, Sec 2, Col. g, Lines E-G","Total should equal Sch B, Sec 2, Col g",null,null,null,"Total should equal Sch C, Hours Section, Column \"Agency Totals\" & Sch B-2 and/or internal payroll records","Paid time off hours are not used towards settlement but the salary & wages are part of settlement","Total should equal various amounts posted to Schedule E (see far left) & should also equal Sch B-2 and/or internal payroll records & A/P documents for Purchased Professional Services","Total should equal Sch B-2 and/or internal payroll records **Does not include salary & wages for Non-Contracted Direct Care Hours reported in column 8b","Total should match the sum of Sch C, Sec 4, Acct 5411, Allocated & Non-Allocated"]
[null,"Total should equal Sch E, Sec 2, row (d)          (≠2)",{"$f":"SUM($P$17)","v":0}]
[null,"Total should equal Sch E, Sec 3, row (a)           (≠3)",{"$f":"SUM($P$14)","v":0}]
[null,"DSHS/DDA Schedule B-1 (Rev. 12/18)",{"$f":"IF(C23<>SUM(E!E13:H14),\"≠1 \",\"\")&(IF(C24<>SUM(E!E16:H16),\"≠2 \",\"\")&(IF(C25<>SUM(E!E23:H23),\"≠3 \",\"\")))","v":""},null,{"$f":"IF(SUM(E19:F22)<>B!H34,\"≠\",\"\")","v":""},null,{"$f":"IF(G19<>SUM(B!I34:J34),\"≠\",\"\")","v":""},{"$f":"IF(H19<>SUM(B!K34),\"≠\",\"\")","v":""},{"$f":"IF(I19<>SUM(B!K35:L37),\"≠\",\"\")","v":""},{"$f":"IF(J19<>_C000099,\"≠\",\"\")","v":""},null,null,null,{"$f":"IF(N19<>SUM('C'!E13:E28),\"≠\",\"\")","v":""},null,null,null,{"$f":"IF(R19<>SUM('C'!E30:E37,'C'!E48:E55),\"≠\",\"\")","v":""}]

{"sheet":"B","index":4,"n_rows":41,"n_cols":14,"rows_kept":41,"cut":false,"hidden":false,"merged":[[33,2,33,6],[37,2,37,6],[33,10,33,11],[38,1,38,13],[0,0,0,14],[2,10,2,13],[7,3,7,13],[29,3,29,4],[20,3,20,11],[8,4,9,13],[22,3,22,11],[24,3,24,10],[29,10,29,11],[27,10,27,11],[25,1,25,13],[28,10,28,11],[24,11,24,12],[26,1,26,13],[27,1,27,4],[37,10,37,11],[36,3,36,4],[34,10,34,11],[35,10,35,11],[30,3,30,4],[32,10,32,11],[36,10,36,11],[32,3,32,4],[34,3,34,4],[35,3,35,4],[31,10,31,11],[31,3,31,4],[30,10,30,11]]}
["SCHEDULE B"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[null,1,null,"ARE MEDICAL SERVICES PURCHASED OR PROVIDED FOR DEVELOPMENTAL DISABILITIES CONTRACTS?"]
[null,null,null,null,"If Yes, include cost of services for reported programs in Schedule E, line 2b for Medical Services Staff Salaries and Wages, or line 2d for Authorized Direct Care (ISS) Purchased Services."]
[]
[]
[null,2,null,"PLEASE INDICATE YOUR BUSINESS STRUCTURE"]
[]
[]
[]
[null,3,null,"PLEASE INDICATE THE ACCOUNTING BASIS USED:"]
[]
[]
[]
[null,4,null,"ALLOCATION OF SHARED COSTS"]
[null,"a",null,"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,"b",null,"If yes to question 4a, do you allocate administrative and program overhead costs?"]
[]
[null,"c",null,"What is your agency's method of allocating costs? "]
[null,"If you answered 'Yes\" to questions 4a and 4b, and ISS Hours Worked are used for allocating costs, use the Schedule C, allocation section to report non-ISS/Administrative costs.  If you use another allocation method or do not allocate costs, report the non-ISS/Administrative expenses on schedule C in the non-allocated sections."]
[null,"PAID HOURS WORKED"]
[null,"(a)",null,null,null,"(b)","(c)","(d)","(e)","(f)","(g)",null,"(h)","(i)"]
[null,null,null,"PROGRAM NAME",null,"P1 ID NUMBER","PROG TYPE SL,GH, or SL/GH","REG & OT ISS HOURS WORKED & PROFESSIONAL SERVICES STAFF ISS HOURS WORKED","SLEEP &/OR CALL BACK HOURS","ADMINISTRATOR DIRECT CARE/ISS HOURS &/OR AUTHORIZED PURCHASED PROFESSINAL SERVICE HOURS","TOTAL PAID HOURS WORKED (d+e+f)",null,"ANNUAL RESIDENT DAYS","AVERAGE HOURS  PER RESIDENT DAY"]
[null,1,"A",null,null,null,null,null,null,null,{"$f":"SUM(H30:J30)","v":0},null,null,{"$f":"IF(M30>0,ROUND(+K30/M30,2),0)","v":0}]
[null,null,"B",null,null,null,null,null,null,null,0,null,null,0]
[null,null,"C",null,null,null,null,null,null,null,0,null,null,0]
[null,null,"D",null,null,null,null,null,null,null,0,null,null,0]
[null,null,"Total of column (g) rows A-D (Programs Subject to Settlement) is automatically posted to Schd J Summary, line 2.**",null,null,null,null,{"$f":"SUM(H30:H33)","v":0},{"$f":"SUM(I30:I33)","v":0},{"$f":"SUM(J30:J33)","v":0},{"$f":"SUM(K30:L33)","v":0},null,{"$f":"SUM(M30:M33)","v":0}]
[null,2,"E","SSP",null,null,"SSP",null,null,null,0,null,null,0]
[null,null,"F","OTHER",null,null,"OTHER",null,null,null,0,null,null,0]
[null,null,"G","OTHER",null,null,"OTHER",null,null,null,0,null,null,0]
[null,null,"TOTAL OF ALL PROGRAMS (SETTLED & NON-SETTLED)",null,null,null,null,{"$f":"SUM(H34:H37)","v":0},{"$f":"SUM(I34:I37)","v":0},{"$f":"SUM(J34:J37)","v":0},{"$f":"SUM(K34:L37)","v":0},null,{"$f":"SUM(M34:M37)","v":0}]
[null,"**  Hours associated with SSP and/or other programs not subject to settlement should be excluded from Line 2 and 3 of Schd J Summary."]
[]
[null,"DSHS/DDA Schedule B (Rev. 12/18)"]

{"sheet":"C","index":5,"n_rows":112,"n_cols":12,"rows_kept":112,"cut":false,"hidden":false,"merged":[[0,0,0,11],[108,2,108,3],[66,2,66,4],[78,2,78,4],[12,1,19,1],[20,1,27,1],[47,1,64,1],[105,1,106,1],[90,1,100,1],[103,1,104,1],[67,1,71,1],[29,1,46,1],[72,1,76,1],[79,1,89,1],[11,2,11,3],[102,2,102,4],[15,2,15,3],[16,2,16,3],[2,9,2,11],[10,2,10,3],[9,2,9,3],[7,2,8,3],[6,1,6,3],[27,2,27,3],[11,5,11,11],[28,5,28,11],[22,2,22,3],[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[17,2,17,3],[18,2,18,3],[19,2,19,3],[20,2,20,3],[21,2,21,3],[12,2,12,3],[13,2,13,3],[14,2,14,3]]}
["SCHEDULE C"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[null,null,null,null,null,"A","B","C","D","E","F","G"]
[null,null,"ADMINISTRATIVE & OPERATIONS COSTS",null,"Program",{"$f":"_M000041","v":0},{"$f":"_M000049","v":0},{"$f":"_M000057","v":0},{"$f":"_M000065","v":0},"SSP","OTHER","OTHER"]
[null,null,null,null,"Prov. No.",{"$f":"_C000040","v":0},{"$f":"_C000048","v":0},{"$f":"_C000056","v":0},{"$f":"_C000064","v":0},{"$f":"_C000072","v":0},{"$f":"_C000080","v":0},{"$f":"_C000088","v":0}]
[null,1,"TOTAL PAID HOURS WORKED (From Schedule B)",null,{"$f":"SUM(F10:L10)","v":0},{"$f":"_C000045","v":0},{"$f":"_C000053","v":0},{"$f":"_C000061","v":0},{"$f":"_C000069","v":0},{"$f":"_C000077","v":0},{"$f":"_C000085","v":0},{"$f":"_C000093","v":0}]
[null,2,"% OF TOTAL PAID HOURS WORKED",null,{"$f":"SUM(F11:L11)","v":0},{"$f":"IF($E10>0,+F10/$E10,0)","v":0},0,0,0,0,0,0]
[null,3,"ADMIN. & OTHER NON-ISS STAFF HOURS",null,"Agency Totals","HOURS"]
[null,"Allocated","ADMINISTRATOR",null,0,{"$f":"IF($E13>0,$E13*F$11,0)","v":0},{"$f":"IF($E13>0,$E13*G$11,0)","v":0},0,0,0,0,0]
[null,null,"OWNER",null,0,{"$f":"IF($E14>0,ROUND(+$E14*F$11,2),0)","v":0},0,0,0,0,0,0]
[null,null,"CHIEF EXECUTIVE",null,0,0,0,0,0,0,0,0]
[null,null,"OTHER ADMINISTRATIVE STAFF",null,0,0,0,0,0,0,0,0]
[null,null,"PROGRAM MANAGEMENT",null,0,{"$f":"IF($E17>0,$E17*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,"ACCOUNTING/BOOKKEEPING/OFFICE",null,0,{"$f":"IF($E18>0,$E18*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,"MAINTENANCE",null,0,{"$f":"IF($E19>0,$E19*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,"OTHER NON-ISS STAFF",null,0,{"$f":"IF($E20>0,$E20*F$11,0)","v":0},0,0,0,0,0,0]
[null,"Non-Allocated","ADMINISTRATOR",null,{"$f":"SUM(F21:L21)","v":0},0,0,0,0,0,0,0]
[null,null,"OWNER",null,0,0,0,0,0,0,0,0]
[null,null,"CHIEF EXECUTIVE",null,0,0,0,0,0,0,0,0]
[null,null,"OTHER ADMINISTRATIVE STAFF",null,0,0,0,0,0,0,0,0]
[null,null,"PROGRAM MANAGEMENT",null,0,0,0,0,0,0,0,0]
[null,null,"ACCOUNTING/BOOKKEEPING",null,0,0,0,0,0,0,0,0]
[null,null,"MAINTENANCE",null,0,0,0,0,0,0,0,0]
[null,null,"OTHER NON-ISS STAFF",null,0,0,0,0,0,0,0,0]
[null,4,"ADMINISTRATIVE EXPENSE",null,"Agency Totals","DOLLARS"]
[null,"Allocated",5411,"Administrator Salaries and Wages",0,{"$f":"IF($E30>0,$E30*F$11,0)","v":0},{"$f":"IF($E30>0,$E30*G$11,0)","v":0},0,0,0,0,0]
[null,null,null,"Owner Salaries and Wages",0,{"$f":"IF($E31>0,$E31*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,null,"Chief Executive Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Other Administrative Staff Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Program Management Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Accounting/ Bookkeeping Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Maintenance Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Other Non-ISS Staff Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,5412,"Administrator Benefits & PR Taxes",0,{"$f":"IF($E38>0,$E38*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,null,"Owner Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null," Chief Executive Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Other Administrative Staff Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Program Management Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Accounting/ Bookkeeping Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Maintenance Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Other Non-ISS Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,5414,"Purchased Non-ISS Professional Services",0,0,0,0,0,0,0,0]
[null,null,5417,"Management Fees",0,0,0,0,0,0,0,0]
[null,"Non-Allocated",5411,"Administrator Salaries and Wages",{"$f":"SUM(F48:L48)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Owner Salaries and Wages",{"$f":"SUM(F49:L49)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Chief Executive Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Other Administrative Staff Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Program Management Salaries and Wages",{"$f":"SUM(F52:L52)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Accounting/ Bookkeeping Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Maintenance Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,null,"Other Non-ISS Staff Salaries and Wages",0,0,0,0,0,0,0,0]
[null,null,5412,"Administrator Benefits & PR Taxes",{"$f":"SUM(F56:L56)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Owner Benefits & PR Taxes",{"$f":"SUM(F57:L57)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Chief Executive Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Other Administrative Staff Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Program Management Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Accounting/ Bookkeeping Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Maintenance Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,null,"Other Non-ISS Benefits & PR Taxes",0,0,0,0,0,0,0,0]
[null,null,5414,"Purchased Non-ISS Professional Services",{"$f":"SUM(F64:L64)","v":0},0,0,0,0,0,0,0]
[null,null,5417,"Management Fees",{"$f":"SUM(F65:L65)","v":0},0,0,0,0,0,0,0]
[null,null,"TOTAL ADMINISTRATIVE EXPENSE",null,{"$f":"SUM(E30:E65)","v":0},0,0,0,0,0,0,0]
[null,5,"PROGRAM OPERATIONS EXPENSE"]
[null,"Allocated","5413","Administrative Supplies",0,{"$f":"IF($E68>0,$E68*F$11,0)","v":0},{"$f":"IF($E68>0,$E68*G$11,0)","v":0},0,0,0,0,0]
[null,null,5516,"Administrative Travel Expenses (mileage, lodging, public transportation)",0,{"$f":"IF($E69>0,$E69*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,5431,"Advertising Expense",0,{"$f":"IF($E70>0,$E70*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,5426,"Professional Liability Insurance",0,{"$f":"IF($E71>0,$E71*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,"5439","Other General Admin. Expense",0,{"$f":"IF($E72>0,$E72*F$11,0)","v":0},0,0,0,0,0,0]
[null,"Non-Allocated","5413","Administrative Supplies",{"$f":"SUM(F73:L73)","v":0},0,0,0,0,0,0,0]
[null,null,5516,"Administrative Travel Expenses (mileage, lodging, public transportation)",{"$f":"SUM(F74:L74)","v":0},0,0,0,0,0,0,0]
[null,null,5431,"Advertising Expense",{"$f":"SUM(F75:L75)","v":0},0,0,0,0,0,0,0]
[null,null,5426,"Professional Liability Insurance",{"$f":"SUM(F76:L76)","v":0},0,0,0,0,0,0,0]
[null,null,"5439","Other General Admin. Expense",{"$f":"SUM(F77:L77)","v":0},0,0,0,0,0,0,0]
[null,null,"TOTAL PROGRAM OPERATIONS EXPENSE",null,{"$f":"SUM(E68:E77)","v":0},{"$f":"SUM(F68:F77)","v":0},0,0,0,0,0,0]
[null,6,"CAPITAL & PROPERTY EXPENSE"]
[null,"Allocated","53*0","Depreciation - Land Improvements, Buildings, Building Imp., Leasehold Impr., Furn. & Equip. (Detail on Schedule F)",0,{"$f":"IF($E80>0,+$E80*F$11,0)","v":0},{"$f":"IF($E80>0,+$E80*G$11,0)","v":0},0,0,0,0,0]
[null,null,null,"Square footage (owned buildings)",0,{"$f":"IF($E81>0,+$E81*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,5423,"Communications Expense",0,{"$f":"IF($E82>0,+$E82*F$11,0)","v":0},0,0,0,0,0,0]
[null,null,5426,"Facility Insurance Expense",0,0,0,0,0,0,0,0]
[null,null,5380,"Office Rent Expense",0,0,0,0,0,0,0,0]
[null,null,null,"Square footage (rented space)",0,0,0,0,0,0,0,0]
[null,null,5380,"Lease Payments Expense",0,0,0,0,0,0,0,0]
[null,null,5481,"Utilities Expense",0,0,0,0,0,0,0,0]
[null,null,5483,"Property Taxes",0,0,0,0,0,0,0,0]
[null,null,5486,"Minor Equipment Expense",0,0,0,0,0,0,0,0]
[null,null,5487,"Other Property Expense",0,0,0,0,0,0,0,0]
[null,"Non-Allocated","53*0","Depreciation - Land Improvements, Buildings, Building Imp., Leasehold Impr., Furn. & Equip. (Detail on Schedule F)",{"$f":"SUM(F91:L91)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Square footage (owned buildings)",{"$f":"SUM(F92:L92)","v":0},0,0,0,0,0,0,0]
[null,null,5423,"Communications Expense",0,0,0,0,0,0,0,0]
[null,null,5426,"Facility Insurance Expense",0,0,0,0,0,0,0,0]
[null,null,5380,"Office Rent Expense",{"$f":"SUM(F95:L95)","v":0},0,0,0,0,0,0,0]
[null,null,null,"Square footage (rented space)",{"$f":"SUM(F96:L96)","v":0},0,0,0,0,0,0,0]
[null,null,5380,"Lease Payments Expense",{"$f":"SUM(F97:L97)","v":0},0,0,0,0,0,0,0]
[null,null,5481,"Utilities Expense",0,0,0,0,0,0,0,0]
[null,null,5483,"Property Taxes",0,0,0,0,0,0,0,0]
[null,null,5486,"Minor Equipment Expense",0,0,0,0,0,0,0,0]
[null,null,5487,"Other Property Expense",0,0,0,0,0,0,0,0]
[null,null,"TOTAL CAPTIAL & PROPERTY EXPENSE",null,{"$f":"SUM(E80,E82:E84,E86:E90,E91,E93:E95,E97:E101)","v":0},{"$f":"SUM(F80,F82:F84,F86:F91,F93:F95,F97:F101)","v":0},{"$f":"SUM(G80,G82:G84,G86:G91,G93:G95,G97:G101)","v":0},0,0,0,0,0]
[null,7,"INTEREST & TAX EXPENSE"]
[null,"Allocated","5421, 5370","Working Capital, Property, Line of Credit  Debt Expense (Detail on Schedule G)",0,{"$f":"IF($E104>0,$E104*F$11,0)","v":0},{"$f":"IF($E104>0,$E104*G$11,0)","v":0},0,0,0,0,0]
[null,null,5428,"Business Taxes (Does not include portion of B & O tax charged as ISS Payroll Tax)",0,{"$f":"IF($E105>0,$E105*F$11,0)","v":0},0,0,0,0,0,0]
[null,"Non-Allocated","5421, 5370","Working Capital, Property, Line of Credit  Debt Expense (Detail on Schedule G)",{"$f":"SUM(F106:L106)","v":0},0,0,0,0,0,0,0]
[null,null,5428,"Business Taxes (Does not include portion of B & O tax charged as ISS Payroll Tax)",{"$f":"SUM(F107:L107)","v":0},0,0,0,0,0,0,0]
[null,null,"TOTAL INTEREST & TAX EXPENSE",null,{"$f":"SUM(E104:E107)","v":0},{"$f":"SUM(F104:F107)","v":0},0,0,0,0,0,0]
[null,8,"TOTALS",null,{"$f":"SUM(E66+E78+E102+E108)","v":0},{"$f":"SUM(F66+F78+F102+F108)","v":0},0,0,0,0,0,0]
[null,null,null,null,null,"To Schedule E","To Schedule E","To Schedule E","To Schedule E","To Schedule E","To Schedule E","To Schedule E"]
[null,null,null,null,null,"Col. A, Line 1","Col. B, Line 1","Col. C, Line 1","Col. D, Line 1","Col. E, Line 1","Col. F, Line 1","Col. G, Line 1"]
[null,null,"DSHS/DDA Schedule C (Rev. 12/18)"]

{"sheet":"C-Sum","index":6,"n_rows":68,"n_cols":12,"rows_kept":68,"cut":false,"hidden":true,"merged":[[0,0,0,11],[11,2,11,4],[60,2,60,4],[2,9,2,11],[7,1,8,3],[2,5,2,8],[3,5,3,8],[4,5,4,8],[10,2,10,3],[9,2,9,3],[12,1,19,1],[64,2,64,3],[40,2,40,4],[47,2,47,4],[12,2,19,2],[21,1,38,1],[61,1,62,1],[48,1,58,1],[41,1,45,1]]}
["SCHEDULE C SUM"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[null,"ADMIN. & OPERATIONS COSTS",null,null,"Program",{"$f":"B!$G30","v":0},{"$f":"B!$G31","v":0},{"$f":"B!$G32","v":0},{"$f":"B!$G33","v":0},{"$f":"B!$G35","v":"SSP"},{"$f":"B!$G36","v":"OTHER"},{"$f":"B!$G37","v":"OTHER"}]
[null,null,null,null,"Prov. No.",{"$f":"_C000040","v":0},{"$f":"_C000048","v":0},{"$f":"_C000056","v":0},{"$f":"_C000064","v":0},{"$f":"_C000072","v":0},{"$f":"_C000080","v":0},{"$f":"_C000088","v":0}]
[null,1,"TOTAL PAID HOURS WORKED*",null,{"$f":"SUM(F10:L10)","v":0},{"$f":"_C000045","v":0},{"$f":"_C000053","v":0},{"$f":"_C000061","v":0},{"$f":"_C000069","v":0},{"$f":"_C000077","v":0},{"$f":"_C000085","v":0},{"$f":"_C000093","v":0}]
[null,2,"% OF TOTAL PAID HOURS WORKED",null,{"$f":"SUM(F11:L11)","v":0},{"$f":"IF($E10>0,+F10/$E10,0)","v":0},0,0,0,0,0,0]
[null,3,"ADMIN. & OTHER NON-ISS STAFF HOURS",null,null,null,null,"         H     O     U     R     S"]
[null,"HOURS","Total","ADMINISTRATOR",{"$f":"SUM(F13:L13)","v":0},{"$f":"+'C'!F13+'C'!F21","v":0},{"$f":"+'C'!G13+'C'!G21","v":0},{"$f":"+'C'!H13+'C'!H21","v":0},{"$f":"+'C'!I13+'C'!I21","v":0},{"$f":"+'C'!J13+'C'!J21","v":0},{"$f":"+'C'!K13+'C'!K21","v":0},{"$f":"+'C'!L13+'C'!L21","v":0}]
[null,null,null,"OWNER",0,{"$f":"+'C'!F14+'C'!F22","v":0},{"$f":"+'C'!G14+'C'!G22","v":0},{"$f":"+'C'!H14+'C'!H22","v":0},{"$f":"+'C'!I14+'C'!I22","v":0},{"$f":"+'C'!J14+'C'!J22","v":0},{"$f":"+'C'!K14+'C'!K22","v":0},{"$f":"+'C'!L14+'C'!L22","v":0}]
[null,null,null,"CHIEF EXECUTIVE",0,{"$f":"+'C'!F15+'C'!F23","v":0},{"$f":"+'C'!G15+'C'!G23","v":0},{"$f":"+'C'!H15+'C'!H23","v":0},{"$f":"+'C'!I15+'C'!I23","v":0},{"$f":"+'C'!J15+'C'!J23","v":0},{"$f":"+'C'!K15+'C'!K23","v":0},{"$f":"+'C'!L15+'C'!L23","v":0}]
[null,null,null,"OTHER ADMINISTRATIVE STAFF",0,{"$f":"+'C'!F16+'C'!F24","v":0},{"$f":"+'C'!G16+'C'!G24","v":0},{"$f":"+'C'!H16+'C'!H24","v":0},{"$f":"+'C'!I16+'C'!I24","v":0},{"$f":"+'C'!J16+'C'!J24","v":0},{"$f":"+'C'!K16+'C'!K24","v":0},{"$f":"+'C'!L16+'C'!L24","v":0}]
[null,null,null,"PROGRAM MANAGEMENT",0,{"$f":"+'C'!F17+'C'!F25","v":0},{"$f":"+'C'!G17+'C'!G25","v":0},{"$f":"+'C'!H17+'C'!H25","v":0},{"$f":"+'C'!I17+'C'!I25","v":0},{"$f":"+'C'!J17+'C'!J25","v":0},{"$f":"+'C'!K17+'C'!K25","v":0},{"$f":"+'C'!L17+'C'!L25","v":0}]
[null,null,null,"ACCOUNTING/BOOKKEEPING",0,{"$f":"+'C'!F18+'C'!F26","v":0},{"$f":"+'C'!G18+'C'!G26","v":0},{"$f":"+'C'!H18+'C'!H26","v":0},{"$f":"+'C'!I18+'C'!I26","v":0},{"$f":"+'C'!J18+'C'!J26","v":0},{"$f":"+'C'!K18+'C'!K26","v":0},{"$f":"+'C'!L18+'C'!L26","v":0}]
[null,null,null,"MAINTENANCE",0,{"$f":"+'C'!F19+'C'!F27","v":0},{"$f":"+'C'!G19+'C'!G27","v":0},{"$f":"+'C'!H19+'C'!H27","v":0},{"$f":"+'C'!I19+'C'!I27","v":0},{"$f":"+'C'!J19+'C'!J27","v":0},{"$f":"+'C'!K19+'C'!K27","v":0},{"$f":"+'C'!L19+'C'!L27","v":0}]
[null,null,null,"OTHER NON-ISS STAFF",0,{"$f":"+'C'!F20+'C'!F28","v":0},{"$f":"+'C'!G20+'C'!G28","v":0},{"$f":"+'C'!H20+'C'!H28","v":0},{"$f":"+'C'!I20+'C'!I28","v":0},{"$f":"+'C'!J20+'C'!J28","v":0},{"$f":"+'C'!K20+'C'!K28","v":0},{"$f":"+'C'!L20+'C'!L28","v":0}]
[null,4,"ADMINISTRATIVE EXPENSE",null,null,null,null,"      D    O    L    L    A     R    S"]
[null,"Total",5411,"Administrative Salaries & Wages",{"$f":"SUM(F22:L22)","v":0},{"$f":"+'C'!F30+'C'!F48","v":0},{"$f":"+'C'!G30+'C'!G48","v":0},{"$f":"+'C'!H30+'C'!H48","v":0},{"$f":"+'C'!I30+'C'!I48","v":0},{"$f":"+'C'!J30+'C'!J48","v":0},{"$f":"+'C'!K30+'C'!K48","v":0},{"$f":"+'C'!L30+'C'!L48","v":0}]
[null,null,5411,"Owners Salaries & Wages",0,{"$f":"+'C'!F31+'C'!F49","v":0},{"$f":"+'C'!G31+'C'!G49","v":0},{"$f":"+'C'!H31+'C'!H49","v":0},{"$f":"+'C'!I31+'C'!I49","v":0},{"$f":"+'C'!J31+'C'!J49","v":0},{"$f":"+'C'!K31+'C'!K49","v":0},{"$f":"+'C'!L31+'C'!L49","v":0}]
[null,null,5411,"Chief Exectutive Salaries & Wages",0,{"$f":"+'C'!F32+'C'!F50","v":0},{"$f":"+'C'!G32+'C'!G50","v":0},{"$f":"+'C'!H32+'C'!H50","v":0},{"$f":"+'C'!I32+'C'!I50","v":0},{"$f":"+'C'!J32+'C'!J50","v":0},{"$f":"+'C'!K32+'C'!K50","v":0},{"$f":"+'C'!L32+'C'!L50","v":0}]
[null,null,5411,"Other Administrative Staff Salaries & Wages",0,{"$f":"+'C'!F33+'C'!F51","v":0},{"$f":"+'C'!G33+'C'!G51","v":0},{"$f":"+'C'!H33+'C'!H51","v":0},{"$f":"+'C'!I33+'C'!I51","v":0},{"$f":"+'C'!J33+'C'!J51","v":0},{"$f":"+'C'!K33+'C'!K51","v":0},{"$f":"+'C'!L33+'C'!L51","v":0}]
[null,null,5411,"Program Management Salaries & Wages",0,{"$f":"+'C'!F34+'C'!F52","v":0},{"$f":"+'C'!G34+'C'!G52","v":0},{"$f":"+'C'!H34+'C'!H52","v":0},{"$f":"+'C'!I34+'C'!I52","v":0},{"$f":"+'C'!J34+'C'!J52","v":0},{"$f":"+'C'!K34+'C'!K52","v":0},{"$f":"+'C'!L34+'C'!L52","v":0}]
[null,null,5411,"Accounting/Bookkeeping Salaries & Wages",0,{"$f":"+'C'!F35+'C'!F53","v":0},{"$f":"+'C'!G35+'C'!G53","v":0},{"$f":"+'C'!H35+'C'!H53","v":0},{"$f":"+'C'!I35+'C'!I53","v":0},{"$f":"+'C'!J35+'C'!J53","v":0},{"$f":"+'C'!K35+'C'!K53","v":0},{"$f":"+'C'!L35+'C'!L53","v":0}]
[null,null,5411,"Maintenance Salaries & Wages",0,{"$f":"+'C'!F36+'C'!F54","v":0},{"$f":"+'C'!G36+'C'!G54","v":0},{"$f":"+'C'!H36+'C'!H54","v":0},{"$f":"+'C'!I36+'C'!I54","v":0},{"$f":"+'C'!J36+'C'!J54","v":0},{"$f":"+'C'!K36+'C'!K54","v":0},{"$f":"+'C'!L36+'C'!L54","v":0}]
[null,null,5411,"Other Non-ISS Staff Salaries & Wages",0,{"$f":"+'C'!F37+'C'!F55","v":0},{"$f":"+'C'!G37+'C'!G55","v":0},{"$f":"+'C'!H37+'C'!H55","v":0},{"$f":"+'C'!I37+'C'!I55","v":0},{"$f":"+'C'!J37+'C'!J55","v":0},{"$f":"+'C'!K37+'C'!K55","v":0},{"$f":"+'C'!L37+'C'!L55","v":0}]
[null,null,5412,"Administrative Benefits & PR Taxes",0,{"$f":"+'C'!F38+'C'!F56","v":0},{"$f":"+'C'!G38+'C'!G56","v":0},{"$f":"+'C'!H38+'C'!H56","v":0},{"$f":"+'C'!I38+'C'!I56","v":0},{"$f":"+'C'!J38+'C'!J56","v":0},{"$f":"+'C'!K38+'C'!K56","v":0},{"$f":"+'C'!L38+'C'!L56","v":0}]
[null,null,5412,"Owner Benefits & PR Taxes",0,{"$f":"+'C'!F39+'C'!F57","v":0},{"$f":"+'C'!G39+'C'!G57","v":0},{"$f":"+'C'!H39+'C'!H57","v":0},{"$f":"+'C'!I39+'C'!I57","v":0},{"$f":"+'C'!J39+'C'!J57","v":0},{"$f":"+'C'!K39+'C'!K57","v":0},{"$f":"+'C'!L39+'C'!L57","v":0}]
[null,null,5412,"Chief Exectutive Benefits & PR Taxes",0,{"$f":"+'C'!F40+'C'!F58","v":0},{"$f":"+'C'!G40+'C'!G58","v":0},{"$f":"+'C'!H40+'C'!H58","v":0},{"$f":"+'C'!I40+'C'!I58","v":0},{"$f":"+'C'!J40+'C'!J58","v":0},{"$f":"+'C'!K40+'C'!K58","v":0},{"$f":"+'C'!L40+'C'!L58","v":0}]
[null,null,5412,"Other Administrative Staff Benefits & PR Taxes",0,{"$f":"+'C'!F41+'C'!F59","v":0},{"$f":"+'C'!G41+'C'!G59","v":0},{"$f":"+'C'!H41+'C'!H59","v":0},{"$f":"+'C'!I41+'C'!I59","v":0},{"$f":"+'C'!J41+'C'!J59","v":0},{"$f":"+'C'!K41+'C'!K59","v":0},{"$f":"+'C'!L41+'C'!L59","v":0}]
[null,null,5412,"Program Management Benefits & PR Taxes",0,{"$f":"+'C'!F42+'C'!F60","v":0},{"$f":"+'C'!G42+'C'!G60","v":0},{"$f":"+'C'!H42+'C'!H60","v":0},{"$f":"+'C'!I42+'C'!I60","v":0},{"$f":"+'C'!J42+'C'!J60","v":0},{"$f":"+'C'!K42+'C'!K60","v":0},{"$f":"+'C'!L42+'C'!L60","v":0}]
[null,null,5412,"Accounting/Bookkeeping Benefits & PR Taxes",0,{"$f":"+'C'!F43+'C'!F61","v":0},{"$f":"+'C'!G43+'C'!G61","v":0},{"$f":"+'C'!H43+'C'!H61","v":0},{"$f":"+'C'!I43+'C'!I61","v":0},{"$f":"+'C'!J43+'C'!J61","v":0},{"$f":"+'C'!K43+'C'!K61","v":0},{"$f":"+'C'!L43+'C'!L61","v":0}]
[null,null,5412,"Maintenance Benefits & PR Taxes",0,{"$f":"+'C'!F44+'C'!F62","v":0},{"$f":"+'C'!G44+'C'!G62","v":0},{"$f":"+'C'!H44+'C'!H62","v":0},{"$f":"+'C'!I44+'C'!I62","v":0},{"$f":"+'C'!J44+'C'!J62","v":0},{"$f":"+'C'!K44+'C'!K62","v":0},{"$f":"+'C'!L44+'C'!L62","v":0}]
[null,null,5412,"Other Non-ISS Staff Benefits & PR Taxes",0,{"$f":"+'C'!F45+'C'!F63","v":0},{"$f":"+'C'!G45+'C'!G63","v":0},{"$f":"+'C'!H45+'C'!H63","v":0},{"$f":"+'C'!I45+'C'!I63","v":0},{"$f":"+'C'!J45+'C'!J63","v":0},{"$f":"+'C'!K45+'C'!K63","v":0},{"$f":"+'C'!L45+'C'!L63","v":0}]
[null,null,5414,"Purchased Professional Services",0,{"$f":"+'C'!F46+'C'!F64","v":0},{"$f":"+'C'!G46+'C'!G64","v":0},{"$f":"+'C'!H46+'C'!H64","v":0},{"$f":"+'C'!I46+'C'!I64","v":0},{"$f":"+'C'!J46+'C'!J64","v":0},{"$f":"+'C'!K46+'C'!K64","v":0},{"$f":"+'C'!L46+'C'!L64","v":0}]
[null,null,5417,"Management Fees",0,{"$f":"+'C'!F47+'C'!F65","v":0},{"$f":"+'C'!G47+'C'!G65","v":0},{"$f":"+'C'!H47+'C'!H65","v":0},{"$f":"+'C'!I47+'C'!I65","v":0},{"$f":"+'C'!J47+'C'!J65","v":0},{"$f":"+'C'!K47+'C'!K65","v":0},{"$f":"+'C'!L47+'C'!L65","v":0}]
[null,null,"TOTAL ADMINISTRATIVE EXPENSE",null,{"$f":"SUM(E22:E39)","v":0},0,0,0,0,0,0,0]
[null,5,"PROGRAM OPERATIONS EXPENSE"]
[null,"Total","5413","Administrative Supplies",{"$f":"SUM(F42:L42)","v":0},{"$f":"+'C'!F68+'C'!F73","v":0},{"$f":"+'C'!G68+'C'!G73","v":0},{"$f":"+'C'!H68+'C'!H73","v":0},{"$f":"+'C'!I68+'C'!I73","v":0},{"$f":"+'C'!J68+'C'!J73","v":0},{"$f":"+'C'!K68+'C'!K73","v":0},{"$f":"+'C'!L68+'C'!L73","v":0}]
[null,null,5516,"Administrative Travel Expenses (mileage, lodging, public transportation)",{"$f":"SUM(F43:L43)","v":0},{"$f":"+'C'!F69+'C'!F74","v":0},{"$f":"+'C'!G69+'C'!G74","v":0},{"$f":"+'C'!H69+'C'!H74","v":0},{"$f":"+'C'!I69+'C'!I74","v":0},{"$f":"+'C'!J69+'C'!J74","v":0},{"$f":"+'C'!K69+'C'!K74","v":0},{"$f":"+'C'!L69+'C'!L74","v":0}]
[null,null,5431,"Advertising Expense",{"$f":"SUM(F44:L44)","v":0},{"$f":"+'C'!F70+'C'!F75","v":0},{"$f":"+'C'!G70+'C'!G75","v":0},{"$f":"+'C'!H70+'C'!H75","v":0},{"$f":"+'C'!I70+'C'!I75","v":0},{"$f":"+'C'!J70+'C'!J75","v":0},{"$f":"+'C'!K70+'C'!K75","v":0},{"$f":"+'C'!L70+'C'!L75","v":0}]
[null,null,5426,"Professional Liability Insurance",{"$f":"SUM(F45:L45)","v":0},{"$f":"+'C'!F71+'C'!F76","v":0},{"$f":"+'C'!G71+'C'!G76","v":0},{"$f":"+'C'!H71+'C'!H76","v":0},{"$f":"+'C'!I71+'C'!I76","v":0},{"$f":"+'C'!J71+'C'!J76","v":0},{"$f":"+'C'!K71+'C'!K76","v":0},{"$f":"+'C'!L71+'C'!L76","v":0}]
[null,null,"5439","Other General Admin. Expense",{"$f":"SUM(F46:L46)","v":0},{"$f":"+'C'!F72+'C'!F77","v":0},{"$f":"+'C'!G72+'C'!G77","v":0},{"$f":"+'C'!H72+'C'!H77","v":0},{"$f":"+'C'!I72+'C'!I77","v":0},{"$f":"+'C'!J72+'C'!J77","v":0},{"$f":"+'C'!K72+'C'!K77","v":0},{"$f":"+'C'!L72+'C'!L77","v":0}]
[null,null,"TOTAL PROGRAM OPERATIONS EXPENSE",null,{"$f":"SUM(E42:E46)","v":0},0,0,0,0,0,0,0]
[null,6,"CAPITAL & PROPERTY EXPENSE"]
[null,"Total","53*0","Depreciation - Land Improvements, Buildings, Building Imp., Leasehold Impr., Furn. & Equip. (Detail on Schedule F)",{"$f":"SUM(F49:L49)","v":0},{"$f":"+'C'!F80+'C'!F91","v":0},{"$f":"+'C'!G80+'C'!G91","v":0},{"$f":"+'C'!H80+'C'!H91","v":0},{"$f":"+'C'!I80+'C'!I91","v":0},{"$f":"+'C'!J80+'C'!J91","v":0},{"$f":"+'C'!K80+'C'!K91","v":0},{"$f":"+'C'!L80+'C'!L91","v":0}]
[null,null,null,"Square Footage",0,{"$f":"+'C'!F81+'C'!F92","v":0},{"$f":"+'C'!G81+'C'!G92","v":0},{"$f":"+'C'!H81+'C'!H92","v":0},{"$f":"+'C'!I81+'C'!I92","v":0},{"$f":"+'C'!J81+'C'!J92","v":0},{"$f":"+'C'!K81+'C'!K92","v":0},{"$f":"+'C'!L81+'C'!L92","v":0}]
[null,null,5423,"Communications Expense",0,{"$f":"+'C'!F82+'C'!F93","v":0},{"$f":"+'C'!G82+'C'!G93","v":0},{"$f":"+'C'!H82+'C'!H93","v":0},{"$f":"+'C'!I82+'C'!I93","v":0},{"$f":"+'C'!J82+'C'!J93","v":0},{"$f":"+'C'!K82+'C'!K93","v":0},{"$f":"+'C'!L82+'C'!L93","v":0}]
[null,null,5426,"Facility Insurance Expense",0,{"$f":"+'C'!F83+'C'!F94","v":0},{"$f":"+'C'!G83+'C'!G94","v":0},{"$f":"+'C'!H83+'C'!H94","v":0},{"$f":"+'C'!I83+'C'!I94","v":0},{"$f":"+'C'!J83+'C'!J94","v":0},{"$f":"+'C'!K83+'C'!K94","v":0},{"$f":"+'C'!L83+'C'!L94","v":0}]
[null,null,5380,"Office Rent Expense",0,{"$f":"+'C'!F84+'C'!F95","v":0},{"$f":"+'C'!G84+'C'!G95","v":0},{"$f":"+'C'!H84+'C'!H95","v":0},{"$f":"+'C'!I84+'C'!I95","v":0},{"$f":"+'C'!J84+'C'!J95","v":0},{"$f":"+'C'!K84+'C'!K95","v":0},{"$f":"+'C'!L84+'C'!L95","v":0}]
[null,null,null,"Square Footage",{"$f":"SUM(F54:L54)","v":0},{"$f":"+'C'!F85+'C'!F96","v":0},{"$f":"+'C'!G85+'C'!G96","v":0},{"$f":"+'C'!H85+'C'!H96","v":0},{"$f":"+'C'!I85+'C'!I96","v":0},{"$f":"+'C'!J85+'C'!J96","v":0},{"$f":"+'C'!K85+'C'!K96","v":0},{"$f":"+'C'!L85+'C'!L96","v":0}]
[null,null,5380,"Lease Payments Expense",0,{"$f":"+'C'!F86+'C'!F97","v":0},{"$f":"+'C'!G86+'C'!G97","v":0},{"$f":"+'C'!H86+'C'!H97","v":0},{"$f":"+'C'!I86+'C'!I97","v":0},{"$f":"+'C'!J86+'C'!J97","v":0},{"$f":"+'C'!K86+'C'!K97","v":0},{"$f":"+'C'!L86+'C'!L97","v":0}]
[null,null,5481,"Utilities Expense",0,{"$f":"+'C'!F87+'C'!F98","v":0},{"$f":"+'C'!G87+'C'!G98","v":0},{"$f":"+'C'!H87+'C'!H98","v":0},{"$f":"+'C'!I87+'C'!I98","v":0},{"$f":"+'C'!J87+'C'!J98","v":0},{"$f":"+'C'!K87+'C'!K98","v":0},{"$f":"+'C'!L87+'C'!L98","v":0}]
[null,null,5483,"Property Taxes",0,{"$f":"+'C'!F88+'C'!F99","v":0},{"$f":"+'C'!G88+'C'!G99","v":0},{"$f":"+'C'!H88+'C'!H99","v":0},{"$f":"+'C'!I88+'C'!I99","v":0},{"$f":"+'C'!J88+'C'!J99","v":0},{"$f":"+'C'!K88+'C'!K99","v":0},{"$f":"+'C'!L88+'C'!L99","v":0}]
[null,null,5486,"Minor Equipment Expense",0,{"$f":"+'C'!F89+'C'!F100","v":0},{"$f":"+'C'!G89+'C'!G100","v":0},{"$f":"+'C'!H89+'C'!H100","v":0},{"$f":"+'C'!I89+'C'!I100","v":0},{"$f":"+'C'!J89+'C'!J100","v":0},{"$f":"+'C'!K89+'C'!K100","v":0},{"$f":"+'C'!L89+'C'!L100","v":0}]
[null,null,5487,"Other Property Expense",0,{"$f":"+'C'!F90+'C'!F101","v":0},{"$f":"+'C'!G90+'C'!G101","v":0},{"$f":"+'C'!H90+'C'!H101","v":0},{"$f":"+'C'!I90+'C'!I101","v":0},{"$f":"+'C'!J90+'C'!J101","v":0},{"$f":"+'C'!K90+'C'!K101","v":0},{"$f":"+'C'!L90+'C'!L101","v":0}]
[null,null,"TOTAL CAPITAL & PROPERTY EXPENSE",null,{"$f":"SUM(E49,E51:E53,E55:E59)","v":0},{"$f":"SUM(F49,F51:F53,F55:F59)","v":0},{"$f":"SUM(G49,G51:G53,G55:G59)","v":0},0,0,0,0,0]
[null,7,"INTEREST & TAX EXPENSE"]
[null,"Total","5421, 5370","Working Capital, Property, Line of Credit  Debt Expense (Detail on Schedule G)",{"$f":"SUM(F62:L62)","v":0},{"$f":"+'C'!F104+'C'!F106","v":0},{"$f":"+'C'!G104+'C'!G106","v":0},{"$f":"+'C'!H104+'C'!H106","v":0},{"$f":"+'C'!I104+'C'!I106","v":0},{"$f":"+'C'!J104+'C'!J106","v":0},{"$f":"+'C'!K104+'C'!K106","v":0},{"$f":"+'C'!L104+'C'!L106","v":0}]
[null,null,5428,"Business Taxes (Does not include portion of B & O tax charged as ISS Payroll Tax)",{"$f":"SUM(F63:L63)","v":0},{"$f":"+'C'!F105+'C'!F107","v":0},{"$f":"+'C'!G105+'C'!G107","v":0},{"$f":"+'C'!H105+'C'!H107","v":0},{"$f":"+'C'!I105+'C'!I107","v":0},{"$f":"+'C'!J105+'C'!J107","v":0},{"$f":"+'C'!K105+'C'!K107","v":0},{"$f":"+'C'!L105+'C'!L107","v":0}]
[null,null,"TOTAL INTEREST & TAX EXPENSE",null,{"$f":"SUM(E62:E63)","v":0},0,0,0,0,0,0,0]
[null,8,"TOTALS",null,{"$f":"SUM(E40+E47+E60+E64)","v":0},{"$f":"SUM(F40+F47+F60+F64)","v":0},{"$f":"SUM(G40+G47+G60+G64)","v":0},0,0,0,0,0]
[null,null,null,null,null,"To Schedule E","To Schedule E","To Schedule E","To Schedule E","To Schedule E","To Schedule E","To Schedule E"]
[null,null,null,null,null,"Col. A, Line 1","Col. B, Line 1","Col. C, Line 1","Col. D, Line 1","Col. E, Line 1","Col. F, Line 1","Col. G, Line 1"]
[null,"DSHS/DDA Schedule C-Sum (Rev. 2/15)",null,null,"*From Schedule B"]

{"sheet":"E","index":7,"n_rows":49,"n_cols":11,"rows_kept":49,"cut":false,"hidden":false,"merged":[[0,0,0,10],[10,1,10,2],[6,4,6,10],[8,4,8,10],[2,8,2,10],[5,0,7,3],[8,1,9,2],[47,1,47,2],[18,1,18,2],[11,1,11,2],[21,1,21,2],[24,1,24,2],[25,1,25,2],[32,1,32,2],[45,1,45,2],[46,1,46,2],[37,1,37,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[20,1,20,2]]}
["SCHEDULE E"]
[]
[null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[null,null,null,null,"A","B","C","D","E","F","G"]
[null,null,null,null,"PROGRAMS"]
[null,null,null,null,{"$f":"B!$G30","v":0},{"$f":"B!$G31","v":0},{"$f":"B!$G32","v":0},{"$f":"B!$G33","v":0},{"$f":"B!$G35","v":"SSP"},{"$f":"B!$G36","v":"OTHER"},{"$f":"B!$G37","v":"OTHER"}]
[null,"TOTAL PROGRAM COSTS",null,null,"PROVIDER NUMBER"]
[null,null,null,"TOTALS",{"$f":"_C000040","v":0},{"$f":"_C000048","v":0},{"$f":"_C000056","v":0},{"$f":"_C000064","v":0},{"$f":"_C000072","v":0},{"$f":"_C000080","v":0},{"$f":"_C000088","v":0}]
[1,"ALLOCATED EXPENSES (From Schedule C)",null,{"$f":"SUM(E11:K11)","v":0},{"$f":"+'C'!F109","v":0},{"$f":"+'C'!G109","v":0},{"$f":"+'C'!H109","v":0},{"$f":"+'C'!I109","v":0},{"$f":"+'C'!J109","v":0},{"$f":"+'C'!K109","v":0},{"$f":"+'C'!L109","v":0}]
[2,"DIRECT CARE STAFF COMPENSATION"]
["a",5611,"Direct Staff Salaries and Wages (include paid time off)",{"$f":"SUM(E13:K13)","v":0},0,0,0,0,0,0,0]
["b",5611,"Medical Services Staff Salaries and Wages (include paid time off)",{"$f":"SUM(E14:K14)","v":0},0,0,0,0,0,0,0]
["c",5612,"ISS/Direct Care & Professional Svs Staff Taxable & Non-taxable Fringe Benefits (as described by the IRS) and Payroll Taxes **Note: Paid Time Off is included on line 2a & 2b - not here ",{"$f":"SUM(E15:K15)","v":0},0,0,0,0,0,0,0]
["d",5614,"Authorized Purchased Direct Care (ISS) Professional Services",{"$f":"SUM(E16:K16)","v":0},0,0,0,0,0,0,0]
["e",5612,"Staff Lodging Expenses - SL Only (cost of primary dwelling for ISS personnel paid for by the agency as part of their compensation package)",{"$f":"SUM(E17:K17)","v":0},0,0,0,0,0,0,0]
["f",5425,"Less 1163 Training Hours Times the Average Benchmark Rate *January  - December 31, 2018 (MSA $18.43, Non-MSA $18.12, King $19.03, & MSA/Non-MSA $18.28)",{"$f":"VLOOKUP($I$3,Lists!A2:G138,6)*-'B-1'!E18","v":{"$error":"#N/A"}},{"$f":"$D$18*_C000856/SUM(E11:H11)","v":{"$error":"#N/A"}},{"$f":"$D$18*_C000857/SUM(E11:H11)","v":{"$error":"#N/A"}},{"$f":"$D$18*_C000858/SUM(E11:H11)","v":{"$error":"#N/A"}},{"$f":"$D$18*_C000859/SUM(E11:H11)","v":{"$error":"#N/A"}},0,0,0]
[null,"TOTAL DIRECT CARE STAFF COMPENSATION FOR PROGRAMS SUBJECT TO SETTLEMENT",null,{"$f":"SUM(D13:D17)","v":0},0,0,0,0,0,0,0]
["g","N/A","Direct Care Compensation for programs notsubject to settlement (SSP & Non-Contracted)",{"$f":"SUM(E20:K20)","v":0},0,0,0,0,0,0,0]
[null,"TOTAL CONTRACTED & NON-CONTRACTED DIRECT CARE STAFF COMPENSATION",null,{"$f":"SUM(D19:D20)","v":0},{"$f":"SUM(E19:E20)","v":0},0,0,0,0,0,0]
[3,"ADMINISTRATOR ISS/DIRECT CARE COMPENSATION - GROUP HOMES ONLY"]
["a",5611,"Administrator ISS/Direct Care Salaries & Wages (includes paid time off)",{"$f":"SUM(E23:K23)","v":0},0,0,0,0,0,0,0]
["b",5612,"Administrator ISS/Direct Care Fringe Benefits (as described by the IRS) & PR Taxes **Note: Paid Time Off is included on line 3a - not here ",{"$f":"SUM(E24:K24)","v":0},0,0,0,0,0,0,0]
[null,"TOTAL ADMINISTRATOR ISS/DIRECT CARE COMPENSATION",null,{"$f":"SUM(D23:D24)","v":0},{"$f":"SUM(E23:E24)","v":0},0,0,0,0,0,0]
[4,"OTHER CLIENT RELATED EXPENSES"]
["a",5110,"Overnight Staff Coverage Lodging Expenses (housing units provided for on-duty staff - not primary dwelling for staff): Not ISS",{"$f":"SUM(E27:K27)","v":0},0,0,0,0,0,0,0]
["b",5211,"Food  Costs - Resident (Group Homes primarily)",0,0,0,0,0,0,0,0]
["c",5212,"Food Costs - Staff",0,0,0,0,0,0,0,0]
["d",5425,"Education and In-Service Training & Supplies",0,0,0,0,0,0,0,0]
["e",5435,"Activities and Habilitative Supplies & Other Expenses",0,0,0,0,0,0,0,0]
["f",5435,"Nursing Supplies Expense",0,0,0,0,0,0,0,0]
[null,"TRANSPORTATION EXPENSE"]
["g",5516,"Staff Mileage Reimbursement",{"$f":"SUM(E34:K34)","v":0},0,0,0,0,0,0,0]
["h",5517,"All Other Client Transportation Expense (Agency Vehicle Fuel, Maint., Depreciation; Public Trans. Etc.)",{"$f":"SUM(E35:K35)","v":0},0,0,0,0,0,0,0]
["i","N/A","Client Transportation Mileage on Staff Owned Vehicles (miles driven to provide transportation for clients per mileage log)",{"$f":"SUM(E36:K36)","v":0},0,0,0,0,0,0,0]
["j","N/A","Client Transportation Mileage on Agency Owned Vehicles (miles driven to provide transportation for clients per mileage log)",{"$f":"SUM(E37:K37)","v":0},0,0,0,0,0,0,0]
[null,"MAINTENANCE/ LAUNDRY/ HOUSEKEEPING/ DIETARY"]
["k","54*1","Salaries and Wages",{"$f":"SUM(E39:K39)","v":0},0,0,0,0,0,0,0]
["l","54*2","Fringe Benefits and Payroll Taxes",0,0,0,0,0,0,0,0]
["m","54*3","Supplies & Materials",0,0,0,0,0,0,0,0]
["n","54*4","Purchased Services",0,0,0,0,0,0,0,0]
[null,"TOTAL OTHER RESIDENT RELATED EXPENSE",null,0,{"$f":"SUM(E27:E35,E39:E42)","v":0},{"$f":"SUM(F27:F35,F39:F42)","v":0},0,0,0,0,0]
[5,"TOTALS (Lines 1 - 5)",null,{"$f":"SUM(E44:K44)","v":0},{"$f":"+E11+E21+E25+E43","v":0},{"$f":"+F11+F21+F25+F43","v":0},0,0,0,0,0]
[6,"PAID HOURS WORKED (From Schedule B)",null,0,{"$f":"_C000045","v":0},{"$f":"_C000053","v":0},{"$f":"_C000061","v":0},{"$f":"_C000069","v":0},{"$f":"_C000077","v":0},{"$f":"_C000085","v":0},{"$f":"_C000093","v":0}]
["7a","COST PER HOUR - Non-ISS/Administrative Costs",null,{"$f":"ROUND(+D11/D45,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E45>0,ROUND(+E11/E45,2),0)","v":0},0,0,0,0,0,0]
["7b","COST PER HOUR - ISS/Direct Care & Client Related Costs",null,{"$f":"+D48-D46","v":{"$error":"#DIV/0!"}},{"$f":"+E48-E46","v":0},0,0,0,0,0,0]
["7c","COST PER HOUR - Total Program (ISS&Admin)",null,{"$f":"ROUND(+D44/D45,2)","v":{"$error":"#DIV/0!"}},{"$f":"IF(E45>0,ROUND(+E44/E45,2),0)","v":0},0,0,0,0,0,0]
["DSHS/DDA Schedule E (Rev. 12/18)"]

{"sheet":"F","index":8,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[27,1,39,10],[0,0,0,10],[2,8,2,10],[9,2,9,10],[16,2,16,10],[21,2,21,10],[7,8,8,8],[7,9,8,9]]}
["SCHEDULE F"]
[]
[null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[null,null,null,null,null,null,null," "," "," "]
[]
[null,null,"A","B","C","D","E","F ","G","H","I"]
[null,null,"LAND","LAND","BUILDINGS","BUILDING","LEASEHOLD ","FURNITURE AND",null,null,"VEHICLES"]
[null,null,null,"IMPROVEMENTS",null,"IMPROVEMENTS","IMPROVEMENTS","EQUIPMENT"]
[null,null,"    TOTAL PROPERTY AND RELATED ASSETS"]
[1,"BEGINNING BALANCE",0,0,0,0,0,0,0,0,0]
[2,"ASSET ADDITIONS",0,0,0,0,0,0,0,0,0]
[3,"ASSET RETIREMENTS",0,0,0,0,0,0,0,0,0]
[4,"BALANCE AT END OF PERIOD",{"$f":"+C11+C12-C13","v":0},0,0,0,0,0,{"$f":"+I11+I12-I13","v":0},{"$f":"+J11+J12-J13","v":0},0]
[5,"ADJUSTMENTS/ NON-REIMBURSABLE",0,0,0,0,0,0,0,0,0]
[6,"TOTAL ALLOWABLE PROPERTY AND RELATED ASSETS",{"$f":"+C14+C15","v":0},0,0,0,0,0,{"$f":"+I14+I15","v":0},{"$f":"+J14+J15","v":0},0]
[null,null,"DEPRECIATION EXPENSE"]
[7,"DEPRECIATION METHOD"]
[8,"LIFE",null,0,0,0,0,0,0,0,0]
[9,"SALVAGE VALUE",null,0,0,0,0,0,0,0,0]
[10,"CURRENT PERIOD DEPRECIATION EXP. (To Schedule C or E)",null,0,0,0,0,0,0,0,0]
[null,null,"DEPRECIATION BALANCE"]
[11,"BALANCE AT BEGINNING OF PERIOD",null,0,0,0,0,0,0,0,0]
[12,"CURRENT PERIOD DEPRECIATION EXP.",null,{"$f":"+D21","v":0},0,0,0,0,{"$f":"+I21","v":0},{"$f":"+J21","v":0},0]
[13,"ACCUM. DEPREC. FOR RETIREMENTS",null,0,0,0,0,0,0,0,0]
[14,"BALANCE AT END OF PERIOD",null,{"$f":"SUM(D23:D25)","v":0},0,0,0,0,{"$f":"SUM(I23:I25)","v":0},{"$f":"SUM(J23:J25)","v":0},0]
[15,"EXPLANATION OF RETIREMENTS AND ADJUSTMENTS:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DSHS/DDA Schedule F (Rev. 12/18)"]

{"sheet":"G","index":9,"n_rows":50,"n_cols":11,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,10],[43,1,48,10],[8,3,10,3],[8,2,10,2],[8,1,10,1],[9,7,10,7],[2,8,2,10],[9,8,9,9],[8,5,10,5],[8,4,10,4],[8,10,10,10],[11,1,11,10],[21,1,21,10],[32,1,32,10]]}
["SCHEDULE G"]
[]
[null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[]
[null,"A","B","C","D","E","F","G","H","I","J"]
[null,"DATE of LOAN","CREDITOR","PURPOSE and SECURITY","ORIGINAL TERM OF LOAN","ANNUAL INTEREST RATE",null,null,"REPORT PERIOD",null,"BALANCE at END of PERIOD"]
[null,null,null,null,null,null,null,"BALANCE at BEGINNING of PERIOD","PAYMENTS"]
[null,null,null,null,null,null,"LOAN",null,"PRINCIPLE","INTEREST"]
[1,"WORKING CAPITAL EXPENSE"]
[null,null,null,null,null,0,0,0,0,0,{"$f":"+H13-I13","v":0}]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,"TOTAL INTEREST EXPENSE ON WORKING CAPITAL FOR THE PERIOD",null,null,null,null,null,null,null,{"$f":"SUM(J13:J20)","v":0}]
[2,"              PROPERTY AND OTHER RELATED DEBT EXPENSE"]
[null,null,null,null,null,0,0,0,0,0,{"$f":"+H23-I23","v":0}]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,"TOTAL INTEREST ON PROPERTY AND OTHER RELATED FOR THE PERIOD",null,null,null,null,null,null,null,{"$f":"SUM(J23:J31)","v":0}]
[3,"VEHICLE DEBT EXPENSE"]
[null,null,null,null,null,0,0,0,0,0,{"$f":"+H34-I34","v":0}]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0,0]
[null,"TOTAL INTEREST EXPENSE ON VEHICLES FOR THE PERIOD",null,null,null,null,null,null,null,{"$f":"SUM(J34:J41)","v":0}]
[4,"NOTES:"]
[]
[]
[]
[]
[]
[]
["DSHS/DDA SCHEDULE G (Rev. 12/18)"]

{"sheet":"H","index":10,"n_rows":32,"n_cols":11,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,11],[8,0,8,2],[2,8,2,10],[1,1,1,2],[3,1,3,2],[6,1,6,2]]}
["SCHEDULE H"]
[]
[null,null,null,null,null,null,null,null,{"$f":"_M000001","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[null,null,null,null,"A","B","C","D","E","F","G"]
[null,null,null,null,null,null,null,"              PROGRAMS"]
[null,null,null,null,{"$f":"_M000041","v":0},{"$f":"_M000049","v":0},{"$f":"_M000057","v":0},{"$f":"_M000065","v":0},{"$f":"_M000073","v":"SSP"},{"$f":"_M000081","v":"OTHER"},{"$f":"_M000089","v":"OTHER"}]
["RESIDENTIAL SERVICES REVENUE",null,null,"TOTALS",{"$f":"_C000040","v":0},{"$f":"_C000048","v":0},{"$f":"_C000056","v":0},{"$f":"_C000064","v":0},{"$f":"_C000072","v":0},{"$f":"_C000080","v":0},{"$f":"_C000088","v":0}]
["REVENUE FOR SERVICES"]
[1,4150,"State Payments/Reimbursements for ISS/DSHS Clients (ISS,Admin, & Trans)",{"$f":"SUM(E11:K11)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A11+1","v":2},4160,"DSHS Client Participation",{"$f":"SUM(E12:K12)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A12+1","v":3},4150,"Prior Years Settlements Deducted from State Payments",{"$f":"SUM(E13:K13)","v":0},0,0,0,0,0,0,0]
[4,4130,"Non DSHS Client Payments",{"$f":"SUM(E14:K14)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A14+1","v":5},4140,"Other Revenue (Detail on Schedule L, except for SSP Revenue listed in Column E)",{"$f":"SUM(E15:K15)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A15+1","v":6},null,"TOTAL SERVICES REVENUE",{"$f":"SUM(D11:D15)","v":0},{"$f":"SUM(E11:E15)","v":0},0,0,0,0,0,0]
["OTHER OPERATING REVENUES"]
[{"$f":"+A16+1","v":7},4290,"Summer Programs",{"$f":"SUM(E18:K18)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A18+1","v":8},4150,"Client Evaluation ",{"$f":"SUM(E19:K19)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A19+1","v":9},4140,"Other (Detail on Schedule L)",{"$f":"SUM(E20:K20)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A20+1","v":10},4140,"Non-DSHS Revenue",{"$f":"SUM(E21:K21)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A21+1","v":11},null,"TOTAL OTHER OPERATING REVENUE",{"$f":"SUM(D18:D21)","v":0},{"$f":"SUM(E18:E21)","v":0},0,0,0,0,0,0]
["NONOPERATING REVENUE"]
[{"$f":"+A22+1","v":12},4620,"Interest Income",{"$f":"SUM(E24:K24)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A24+1","v":13},4650,"Cash Donations & Contributions",{"$f":"SUM(E25:K25)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A25+1","v":14},null,"Noncash Donations & Contributions",{"$f":"SUM(E26:K26)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A26+1","v":15},null,"Other (Detail on Schedule L)",{"$f":"SUM(E27:K27)","v":0},0,0,0,0,0,0,0]
[{"$f":"+A27+1","v":16},null,"TOTAL NONOPERATING REVENUE",{"$f":"SUM(D24:D27)","v":0},{"$f":"SUM(E24:E27)","v":0},0,0,0,0,0,0]
["TOTAL REVENUES"]
[{"$f":"+A28+1","v":17},null,"TOTAL FROM LINES 6, 11 and 16",{"$f":"+D16+D22+D28","v":0},0,0,0,0,0,0,0]
[]
["DSHS/DDA Schedule H (Rev. 12/18)"]

{"sheet":"J Summary","index":11,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[21,2,21,4],[15,2,15,4],[16,2,16,4],[17,2,17,4],[18,2,18,3],[19,2,19,4],[20,1,20,5],[14,1,14,5],[7,1,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[6,1,6,5],[0,1,0,5],[1,2,1,3],[2,4,2,5],[3,4,3,5],[5,2,5,3]]}
[null,"J SUMMARY"]
[null,null," "]
[null,null,null,null,{"$f":"A!B7","v":0}]
[null,null,null,null,"PROVIDER NAME"]
[]
[null,"A","B",null,"C","D"]
[null,"SETTLEMENT A"]
[null,null,null,null,"ISS HOURS","DOLLAR CONVERSION"]
[null,1,"TOTAL REIMBURSED HOURS TIMES THE AVERAGE REIMBURSEMENT RATE (Line 7/Line 1, Col C)",null,{"$f":"+'J Detail'!D41","v":0},{"$f":"IF(_C001582=0,0,_C001582*ROUND(_C001589/_C001582,2))","v":0}]
[null,{"$f":"B9+1","v":2},"Regular Paid ISS Hours Worked Times the Average Reimbursement rate (Line 7/Line 1, Col C)\nLess: Mandatory Training Hours RCW 74.39A January 1, 2018 to December 31, 2018 (Sch B-1, Line 8, Col 5)  \n*Note: Hours reported on Line 2 do not include hours reported on line 3",null,{"$f":"'B-1'!H19-'B-1'!F19-'B-1'!E18-_C001584","v":0},{"$f":"IF(_C001583=0,0,_C001583*ROUND(_C001589/_C001582,2))","v":0}]
[null,3,"Overtime Paid Hours Worked Times the Overtime Average Reimbursement Rate (Line 7/Line 1, Col C*1.5) \n*Note: Hours reported on Line 3 are not included with hours reported on line 2 (Applies if approved by the Regional Administrator - a letter requesting consideration of overtime must be submitted to the RA with the completed cost report to be considered)\n",null,{"$f":"'B-1'!F19","v":0},{"$f":"IF(E11=0,0,E11*ROUND((_C001589/_C001582*1.5),2))","v":0}]
[null,4,"Plus: Allowable ISS Paid Hours Worked by Administrator Times the Average Reimbursement Rate (Line 7/Line 1, Col C)\n(SL & Comb programs with 41,600 Direct Care/ISS hours or less)",null,{"$f":"'B-1'!H16","v":0},{"$f":"IF(_C001584=0,0,_C001584*ROUND(_C001589/_C001582,2))","v":0}]
[null,{"$f":"B12+1","v":5},"Equals: \nTOTAL ISS PAID HOURS WORKED & TOTAL AVERAGE REIMBURSEMENT RATE (Line 7/Line 1, Col C)",null,{"$f":"SUM(E10:E12)","v":0},{"$f":"SUM(F10:F12)","v":0}]
[null,{"$f":"B13+1","v":6},"= SETTLEMENT A:   AMOUNT DUE FOR ISS HOURS NOT PROVIDED (Col C & D, Line 1 minus 5)",null,{"$f":"IF(E9-E13<0,0,E9-E13)","v":0},{"$f":"IF(F9-F13<0,0,F9-F13)","v":0}]
[null,"SETTLEMENT B"]
[null,{"$f":"B14+1","v":7},"TOTAL REIMBURSED DOLLARS",null,null,{"$f":"+'J Detail'!F41","v":0}]
[null,{"$f":"B16+1","v":8},"Allowable ISS Staff Payroll Costs\nLess Mandatory Training RCW 74.39A costs calculated on Sch E, Sec 2f (January 1, 2018 to December 31, 2018)",null,null,{"$f":"IF(SUM(E!E19:H19)=0,0,SUM(E!E19:H19)+SUM(E!E25:H25)+E!D18)","v":0}]
[null,{"$f":"B17+1","v":9},"Allowable Payroll Costs for ISS Hours Worked by Administrator (Line, 4, Col. C * Line 7/Line 1, Col. C)\n(SL & Comb SL/GH programs with 41,600 Direct Care/ISS hours or less)",null,null,{"$f":"IF(_C001584=0,0,_C001584*ROUND((_C001589/_C001582),2))","v":0}]
[null,{"$f":"B18+1","v":10},"Equals: TOTAL ALLOWABLE ISS PAYROLL COSTS (Col D, Line 8+9)",null,null,{"$f":"SUM(F17:F18)","v":0}]
[null,{"$f":"B19+1","v":11},"= SETTLEMENT B: AMOUNT DUE FOR UNSPENT ISS REIMBURSEMENTS (Col D, Line 7 minus 10)",null,null,{"$f":"IF(_C001589-F19<0,0,_C001589-F19)","v":0}]
[null,"SETTLEMENT"]
[null,{"$f":"+B20+1","v":12},"TOTAL PRELIMINARY NET SETTLEMENT AMOUNT (Greater of Line 6 or 11)",null,null,{"$f":"IF(_C001588>F20,_C001588,F20)","v":0}]
[null,"DSHS-DDA Schedule J Summary (Rev. 12/18)"]

{"sheet":"J Detail","index":12,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,0,0,5],[34,1,34,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[33,1,33,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[45,1,45,3],[1,1,1,5],[2,2,2,3],[3,2,3,3],[18,1,18,2],[17,1,17,2],[28,1,28,2],[29,1,29,2],[31,1,31,2],[32,1,32,2],[20,1,20,2],[38,1,38,2],[40,1,40,2]]}
["J DETAIL"]
[null,"Settlement Information Worksheet:  Service Hours and Reimbursement are for services provided during the calendar year.  The rate component information required (ISS @ benchmark, Other ISS and Admin) is available from your Schedule J Detail by Client or Exhibit C(s).  "]
[null,"Provider Name",{"$f":"A!B7","v":0},null,"Region",{"$f":"_M000009","v":""}]
[null,"Program Name",null,null,"Report Period",{"$f":"IF(_C000019=\"\",\"-\",MONTH(_C000019)&\"/\"&DAY(_C000019)&\"/\"&YEAR(_C000019)&\" - \"&MONTH(_C000020)&\"/\"&DAY(_C000020)&\"/\"&YEAR(_C000020))","v":"1/1/2018 - 12/31/2018"}]
[null,"A","B","C","D","E",null,null,"           "]
["Line #","Service Type - (SL,GH, or SL/GH) ","Date(s) of Service","Hours Reimbursed","Benchmark Rate","Regular ISS Reimbursement"]
[1,null,null,null,null,{"$f":"+D7*E7","v":0}]
[{"$f":"+A7+1","v":2},null,null,null,null,{"$f":"+D8*E8","v":0}]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[11,null,null,null,null,0]
[12,"Totals from Detail Pg 2 - COCA",null,{"$f":"'J Detail pg 2 - COCA'!D42","v":0},null,{"$f":"'J Detail pg 2 - COCA'!F42","v":0}]
[13,"Sub-Total",null,{"$f":"SUM(D7:D18)","v":0},null,{"$f":"ROUND(SUM(F7:F18),2)","v":0}]
[]
[null,"Nurse Delegation & Other Class Training, and Staff Add-On Hours",null,"Hours Reimbursed","Benchmark Rate","ISS Reimbursement"]
[{"$f":"+A19+1","v":14},"Nurse Delegation Training Hours",null,null,null,{"$f":"ROUND(+D22*E22,2)","v":0}]
[{"$f":"+A22+1","v":15},"Nurse Delegation Training Hours",null,null,null,0]
[16,"Nurse Delegation Training Hours",null,null,null,0]
[17,"Nurse Delegation Training Hours",null,null,null,0]
[18,"Staff Add-On Hours",null,null,null,0]
[19,"Staff Add-On Hours",null,null,null,0]
[20,"Staff Add-On Hours",null,null,null,0]
[21,"Staff Add-On Hours",null,null,null,0]
[22,"Sub-Total",null,{"$f":"SUM(D22:D29)","v":0},null,{"$f":"ROUND(SUM(F22:F29),2)","v":0}]
[]
[null,"Non-Benchmark, Professional Services: Description (Nurse, RN, LPN, Therapist, etc.) ",null,"Hours Reimbursed","Prof. Srvcs. Rate","Other ISS Reimbursement"]
[{"$f":"+A30+1","v":23},null,null,null,null,{"$f":"ROUND(+D33*E33,2)","v":0}]
[{"$f":"+A33+1","v":24},null,null,null,null,0]
[25,null,null,null,null,0]
[26,null,null,null,null,0]
[27,null,null,null,null,0]
[28,null,null,null,null,0]
[29,"Sub-Total",null,{"$f":"SUM(D33:D38)","v":0},null,{"$f":"ROUND(SUM(F33:F38),2)","v":0}]
[]
[{"$f":"+A39+1","v":30},"Total ISS (to J Summary) \n(Average Reimbursement Rate = ISS Reimbursments paid divided by total hours reimbursed)",null,{"$f":"D19+D30+D39","v":0},{"$f":"IF(_C001716=0,0,_C001717/_C001716)","v":0},{"$f":"F19+F30+F39","v":0}]
[]
[31,"Total Itemized Costs (Schedule E, Line 5)",null,null,null,{"$f":"SUM(E!E44:H44)","v":0}]
[{"$f":"A43+1","v":32},"Less:  Total Allowable ISS Cost, (Schedule J Summary, Line  10)",null,null,null,{"$f":"IF(F43=0,0,'J Summary'!F19)","v":0}]
[{"$f":"A44+1","v":33},"TOTAL NON-ISS COSTS (Line 31 - Line 32 )",null,null,null,{"$f":"+F43-F44","v":0}]
[{"$f":"A45+1","v":34},"Reimbursed Administrative/Indirect Client Support/Non-ISS Staff Received for Services (Schedule J Detail by Client cell AR2)"]
[{"$f":"A46+1","v":35},"NON-ISS COSTS GREATER THAN REIMBURSEMENT; If Not Then $0 (Line 33 - Line 34)",null,null,null,{"$f":"IF(F45-F46>0,F45-F46,0)","v":0}]
["DSHS-DDA Schedule J Detail (Rev. 12/18)"]

{"sheet":"J Detail pg 2 - COCA","index":13,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[[0,0,0,5],[1,1,1,5],[2,2,2,3],[3,2,3,3]]}
["J DETAIL PG 2 - COCA"]
[null,"Settlement Information Worksheet:  Service Hours and Reimbursement are for services provided during the calendar year.  The rate component information required (ISS @ benchmark, Other ISS and Admin) is available from your Exhibit C(s).  "]
[null,"Provider Name",{"$f":"A!B7","v":0},null,"Region",{"$f":"_M001601","v":""}]
[null,"Program Name",{"$f":"_M001602","v":0},null,"Report Period",{"$f":"_C001603","v":"1/1/2018 - 12/31/2018"}]
[null,null,null,null,null,null,null,null,"           "]
["Line #","Individual COCA's","Date(s) of Service","Total ISS Hours Reimbursed","Benchmark Rate","Regular ISS Reimbursement"]
[1,"COCA",null,null,null,{"$f":"ROUND(+D7*E7,2)","v":0}]
[{"$f":"+A7+1","v":2},"COCA",null,null,null,0]
[3,"COCA",null,null,null,0]
[4,"COCA",null,null,null,0]
[5,"COCA",null,null,null,0]
[6,"COCA",null,null,null,0]
[7,"COCA",null,null,null,0]
[8,"COCA",null,null,null,0]
[9,"COCA",null,null,null,0]
[10,"COCA",null,null,null,0]
[11,"COCA",null,null,null,0]
[12,"COCA",null,null,null,0]
[13,"COCA",null,null,null,0]
[14,"COCA",null,null,null,0]
[15,"COCA",null,null,null,0]
[16,"COCA",null,null,null,0]
[17,"COCA",null,null,null,0]
[18,"COCA",null,null,null,0]
[19,"COCA",null,null,null,0]
[20,"COCA",null,null,null,0]
[21,"COCA",null,null,null,0]
[22,"COCA",null,null,null,0]
[23,"COCA",null,null,null,0]
[24,"COCA",null,null,null,0]
[25,"COCA",null,null,null,0]
[26,"COCA",null,null,null,0]
[27,"COCA",null,null,null,0]
[28,"COCA",null,null,null,0]
[29,"COCA",null,null,null,0]
[30,"COCA",null,null,null,0]
[31,"COCA",null,null,null,0]
[32,"COCA",null,null,null,0]
[33,"COCA",null,null,null,0]
[34,"COCA",null,null,null,0]
[35,"COCA",null,null,null,0]
[null,"Total (posted to Schd J Detail - Line 12)",null,{"$f":"SUM(D7:D41)","v":0},null,{"$f":"SUM(F7:F41)","v":0}]
["DSHS-DDA Schedule J Detail pg 2 (Rev.12/18)"]

{"sheet":"J Detail pg 3 - Prof Svs","index":14,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":true,"merged":[[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[36,1,36,2],[30,1,30,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,2],[29,1,29,2],[18,1,18,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[6,1,6,2],[0,0,0,5],[1,1,1,5],[2,2,2,3],[3,2,3,3],[5,1,5,2]]}
["J DETAIL PG 3 - PROF SVS"]
[null,"Settlement Information Worksheet:  Service Hours and Reimbursement are for services provided during the calendar year.  The rate component information required (ISS @ benchmark, Other ISS and Admin) is available from your Exhibit C(s).  "]
[null,"Provider Name",{"$f":"#REF!","v":{"$error":"#REF!"}},null,"Region",{"$f":"_M001601","v":""}]
[null,"Program Name",{"$f":"_M001602","v":0},null,"Report Period",{"$f":"_C001603","v":"1/1/2018 - 12/31/2018"}]
[null,null,null,null,null,null,null,null,"           "]
["Line #","Non-Benchmark, Professional Services: Description (Nurse (RN, LPN), Therapist, etc.) - Continued from J Detail",null,"Total Hours Reimbursed","Prof. Srvcs. Rate","Other ISS Reimbursement"]
[1,null,null,null,null,{"$f":"ROUND(+D7*E7,2)","v":0}]
[{"$f":"+A7+1","v":2},null,null,null,null,0]
[3,null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,0]
[6,null,null,null,null,0]
[7,null,null,null,null,0]
[8,null,null,null,null,0]
[9,null,null,null,null,0]
[10,null,null,null,null,0]
[11,null,null,null,null,0]
[12,null,null,null,null,0]
[13,null,null,null,null,0]
[14,null,null,null,null,0]
[15,null,null,null,null,0]
[16,null,null,null,null,0]
[17,null,null,null,null,0]
[18,null,null,null,null,0]
[19,null,null,null,null,0]
[20,null,null,null,null,0]
[21,null,null,null,null,0]
[22,null,null,null,null,0]
[23,null,null,null,null,0]
[24,null,null,null,null,0]
[25,null,null,null,null,0]
[26,null,null,null,null,0]
[27,null,null,null,null,0]
[28,null,null,null,null,0]
[29,null,null,null,null,0]
[30,null,null,null,null,0]
[31,null,null,null,null,0]
[32,null,null,null,null,0]
[33,null,null,null,null,0]
[34,null,null,null,null,0]
[35,null,null,null,null,0]
[null,"Total (posted to Schd J Detail - Line 28)",null,{"$f":"SUM(D7:D41)","v":0},null,{"$f":"SUM(F7:F41)","v":0}]
["DSHS-DDA Schedule J Detail pg 2 (Rev. 2/15)"]

{"sheet":"J-Adm","index":15,"n_rows":33,"n_cols":5,"rows_kept":33,"cut":false,"hidden":true,"merged":[[5,3,5,4],[2,3,2,4],[0,0,0,4],[28,1,28,3]]}
["J-ADM"]
[]
[null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[null,null,null,"PROVIDER NAME"]
[]
["Line","Administrative Rate Settlement Calculation for Hours Not Provided ",null,"Admin. Rate & Payment"]
[null,null,null,"Standard","Paid "]
[1,"Client Days subject to settlement",11272]
[2,"Contracted ISS Hours pd. (do not include Prof. Srvcs, Nurse Delegation Class or Staff Add-On hours)",{"$f":"_C001662","v":0}]
[3,"Admin. Average Weighted Rates",null,{"$f":"IF($C8>0,+D12/$C8,0)","v":41.347423704755144},{"$f":"IF($C8>0,+E13/$C8,0)","v":41.347423704755144}]
[null,"Total Annual Admin Revenue"]
[4,"@ standard Admin rates (Line 16)",null,{"$f":"'J-Adm'!E28","v":466068.16}]
[5,"@ Admin. rates paid (Line 15)",null,null,{"$f":"'J-Adm'!E27","v":466068.16}]
[null,"Adm. Per Hour"]
[6,"@ standard (line 4 / line 2)",null,{"$f":"IF(C9>0,ROUND(+D12/C9,2),0)","v":0}]
[7,"@ rates paid (line 5 / line 2)",null,null,{"$f":"IF(C9>0,ROUND(+E13/C9,2),0)","v":0}]
[8,"Variance: Admin. Rate Paid > Standard (Line 7 - Line 6)",{"$f":"IF(_C001728-_C001727<0,0,_C001728-_C001727)","v":0}]
[9,"Contracted Hours (J-Adm, Line 2)",{"$f":"+C9","v":0}]
[10,"Hours Provided (J Summary, Line 4)",{"$f":"+#REF!","v":{"$error":"#REF!"}}]
[11,"Hours not Provided",{"$f":"+C18-C19","v":{"$error":"#REF!"}}]
[null,"Administrative Rate Settlement Calculation for Hours Not Provided "]
[12,"Hours not Provided",{"$f":"+C20","v":{"$error":"#REF!"}}]
[13,"x Admin. Per Hour over Standard",{"$f":"+C17","v":0},"="]
[14,"If Hrs not provided >0 & Admin paid > standard: Settlement for Hours not Provided",null,null,{"$f":"IF(C22>0,IF(C23>0,+C22*C23,0),0)","v":{"$error":"#REF!"}}]
[]
[null,"Administrative Revenue/Expenditures for Administrative Settlement Calculation",null,null,"Totals"]
[15,"1/ Administrative Reimbursement @ Contracted Rates (Sch J Detail by Client AI2)",null,null,466068.16]
[{"$f":"+A27+1","v":16},"1/ Administrative Reimbursement @ Administrative Standard Rates (Sch J Detail by Client AL2)",null,null,466068.16]
[{"$f":"+A28+1","v":17},"If line 31 greater than line 32, and you have calculated a settlement A, complete Schedule J-Adm to determine the Administrative Rate Settlement",null,null,{"$f":"+E27-E28","v":0}]
[null,"1/ Calculate these amounts only if:"]
[null,"You have a settlement due to hours not provided (settlement A); and"]
[null,"Your agency average administrative rate is higher than the standard (refer to your Exhibit C) "]
["DSHS-DDA Schedule J-Adm (Rev. 11/15)"]

{"sheet":"L","index":16,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,3,9,6],[10,3,10,6],[21,3,21,6],[22,3,22,6],[20,3,20,6],[0,0,0,8],[16,3,16,6],[17,3,17,6],[18,3,18,6],[19,3,19,6],[11,3,11,6],[12,3,12,6],[13,3,13,6],[14,3,14,6],[15,3,15,6],[2,6,2,7],[7,3,7,6],[8,3,8,6]]}
["SCHEDULE L"]
[]
[null,null,null,null,null,null,{"$f":"A!B7","v":0}]
[null,null,null,null,null,null,"PROVIDER NAME"]
[]
[]
[null,"FROM SCHEDULE","ACCT. #",null,null,"DESCRIPTION OF EXPENSES  IN \"OTHER\" CATEGORIES ",null,"AMOUNTS OVER $1,000"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DSHS/DDA Schedule L (Rev. 12/18)"]

{"sheet":"M","index":17,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,1,0,9],[7,5,8,5],[7,8,8,8],[7,4,8,4],[2,7,2,9],[7,6,8,6],[7,7,8,7],[7,9,8,9],[5,1,5,9]]}
[null,"SCHEDULE M"]
[]
[null,null,null,null,null,null,null,{"$f":"A!B7","v":0}]
[null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
[null,"Instructions:  Use this schedule to report ISS salary, wages and other compensation for owner(s) and/or individuals that have any other relationship, interest or involvement with the ownership of the agency other than an employer/employee arrangement.  Include only amounts that are included in schedule E, codes 5611, 5612 or 5614.  Do not include compensation for owners and/or individuals that are included in schedule C for administrators or other administrative staff. "]
[]
[null,null,null,"    SERVICES PERFORMED","Hours Worked During the Period","Cost Report Account Code","Salary Amount Included in Schedule E, lines 2 or 3","Fringe Benefits and PR Taxes Included in Schedule E, lines 2 or 3","Other Payments or Benefits Included in Schedule E, lines 2 or 3","Total ISS Payments or Benefits Included in Schedule E, lines 2 or 3"]
[null,"Employee","Relationship","Job Title - Summary Description of Duties Performed"]
[null,"Employee 1",null,null,0,null,null,null,null,{"$f":"ROUND(SUM(G10:I10),0)","v":0}]
[null,"Employee 2",null,null,0,null,null,null,null,0]
[null,"Employee 3",null,null,0,null,null,null,null,0]
[null,"Employee 4",null,null,0,null,null,null,null,0]
[null,"Employee 5",null,null,0,null,null,null,null,0]
[null,"Employee 6",null,null,0,null,null,null,null,0]
[null,"Employee 7",null,null,0,null,null,null,null,0]
[null,"Employee 8",null,null,0,null,null,null,null,0]
[null,"DSHS/DDA Schedule M (Rev. 12/18)"]

{"sheet":"N","index":18,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,3,5,14],[7,2,7,14],[10,2,11,14],[12,2,13,14],[0,0,0,15],[2,13,2,14],[14,2,15,14],[16,2,17,14],[18,2,19,14],[20,2,21,14],[22,2,23,14]]}
["SCHEDULE N"]
[]
[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,"PROVIDER NAME"]
[]
[null,null,null,"SUPPORTED LIVING PROVIDERS ONLY:"]
[]
[null,null,"DOES THE AGENCY, ITS ADMINISTRATOR OR OWNER, HAVE OWNERSHIP INTEREST IN ANY OF THE HOMES RENTED BY CLIENTS SUPPORTED BY YOUR AGENCY?"]
[null,null,null,null,null,null,"If Yes, list the homes and locations.  Explain special situations."]
[]
[null,"1)"]
[]
[null,"2)"]
[]
[null,"3)"]
[]
[null,"4)"]
[]
[null,"5)"]
[]
[null,"6)"]
[]
[null,"7)"]
[]
[]
["DSHS/DDA Schedule N (Rev. 12/18)"]

{"sheet":"O","index":19,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[19,4,19,8],[0,0,0,11],[2,8,2,10],[6,0,6,11],[10,1,10,9],[12,2,12,3],[12,4,12,7],[13,2,13,3],[13,4,13,7],[16,4,16,8],[17,4,17,8],[18,4,18,8],[5,0,5,11],[7,0,7,11],[39,2,39,8],[22,1,22,10],[23,2,23,8],[24,2,24,8],[25,2,25,8],[26,2,26,8],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[37,2,37,8],[38,2,38,8],[59,1,59,10],[40,2,40,8],[41,2,41,8],[42,2,42,8],[43,2,43,8],[44,2,44,8],[45,2,45,8],[51,2,51,4],[52,2,52,4],[53,2,53,4],[54,2,54,4],[55,2,55,4],[70,1,70,10],[60,1,60,2],[60,4,60,5],[61,1,62,1],[61,2,62,2],[61,3,62,3],[61,4,61,5],[61,6,62,6],[61,7,62,7],[61,8,62,8],[61,9,62,9],[61,10,62,10],[77,1,77,10],[78,1,78,10],[75,5,75,6],[71,2,71,4],[71,5,71,6],[71,7,75,10],[72,2,72,4],[72,5,72,6],[73,2,73,4],[73,5,73,6],[74,2,74,4],[74,5,74,6],[75,2,75,4]]}
["SCHEDULE O"]
[]
[null,null,null,null,null,null,null,null,{"$f":"A!B7","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
["IMPORTANT, PLEASE READ before completing schedule:"]
["COMPLETE A SEPARATE SCHEDULE FOR EACH LOCATION BY: PROGRAM TYPE AND COUNTY \nFOR ADDITIONAL COPIES OF SCHEDULE O CONTACT YOUR AGENCY'S RATE ANALYST \nReporting Period: January 1, 2018 to December 31, 2018 (One Calendar Year, 12 months, 2018)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
["The schedule(s) will be reviewed by the rate analyst to ensure the agency is reporting contracts, programs, and locations separately. Any cost reports found to be incomplete will be returned to the agency for correction. "]
[null,"1. AGENCY INFORMATION:"]
[]
[null,"Where are the Services Provided?"]
[]
[null,null,"PROGRAM TYPE",null,"PROGRAM NAME",null,null,null,"CITY","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. BOARD OF DIRECTORS INFORMATION:  "]
[null,"Non-Profit Agencies only, please fill out the following information if you have a Board of Directors or other governing board.  Do not include advisory committees or other non-governing, non-voting boards."]
[null,null,"a) Board of Directors -  Number of Members (total number of positions)?  …………… "]
[null,null,"b)  Board of Directors -Total number of voting board members? …………………………"]
[null,null,"c)  Voting Board Members - How many are people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?  ………………………………………………………………….."]
[null,null,"d)  Voting Board Members - How many are family members (parents, siblings, or other relatives) of people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?  ………………………………………………"]
[]
[null,"4. CLIENT INFORMATION: "]
[null,null,"Average Monthly Count of Clients supported in this program?  "]
[]
[null,"5. EMPLOYEE BENEFITS:"]
[]
[null,null,"In addition to wages, does your agency provide benefits to direct service staff?\nIf Yes, check all that apply",null,null,null,null,null,null," Yes"]
[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,"6. RECRUITING:"]
[]
[null,null,"\nDifference in recruiting new staff from 1/1/2018 - 12/31/2018?\n(Check boxes that apply)",null,null,"ENTRY LEVEL","1st LINE SUPERVISOR","PROGRAM MANAGERS","*SPECIALISTS\n (e.g., recreation, behavioral, or staff trainers, etc.)","NURSES\n(RN, LPN)"]
[null,null,"Situation is worse (Harder to recruit)"]
[null,null,"Some improvement (Easier to recruit)"]
[null,null,"Definite improvement (Much easier to recruit)"]
[null,null,"No difference"]
[]
[]
[null,"7. STAFFING INFORMATION:"]
[null,"SECTION 1A"]
[null,null,null,1,2,null,3,4,5,6,7]
[null,"Line #","POSITION TYPE","Number of ISS staff (Full-time, Part-time, & Temp combined) on December 31, 2018","Number of ISS staff who left:",null,"Number of ISS vacancies on December 31, 2018","Percentage of ISS work hours filled w/OT or non-scheduled staff (Estimates accepted if unknown)","Average number of days to fill vacant positions (Estimates accepted if unknown)","Current starting wage for this type of position within your agency in 2018 (Hourly Rate)","What is the average wage for this type of position after 2 years of employment (Hourly Rate)"]
[null,null,null,null,"(Six Months) Jan. 1, 2018 to June 30, 2018","(Six Months) July 1, 2018 to Dec. 31, 2018"]
[null,1,"ENTRY LEVEL",null,null,null,null,null,null,0,0]
[null,2,"1st LINE SUPERVISORS",null,null,null,null,null,null,0,0]
[null,3,"PROGRAM MANAGERS",null,null,null,null,null,null,0,0]
[null,4,"*SPECIALISTS (recreation, behavioral, or staff trainers, etc.)",null,null,null,null,null,null,0,0]
[null,5,"NURSES (RN, LPN)",null,null,null,null,null,null,0,0]
[null,null,"TOTAL\n(Lines 1 thru 5)",{"$f":"SUM(D64:D68)","v":0},{"$f":"SUM(E64:E68)","v":0},{"$f":"SUM(F64:F68)","v":0},{"$f":"SUM(G64:G68)","v":0}]
[]
[null,"SECTION 1B"]
[null,"Line #","Length of Time with your Agency\n",null,null,"Using the total number of staff from above, what is the length of time they have been with your agency?",null,"THE AMOUNTS CONNECTED BY THE RED ARROW MUST EQUAL ONE ANOTHER                                                                                           The Number of ISS staff from above (Section 1A) and Number of staff by length of time with your agency (Section 1B) should total to the same number\n"]
[null,7,"LESS than 6 Months"]
[null,8,"BETWEEN 6 and 12 months"]
[null,9,"OVER 12 months"]
[null,null,"Total Staff by Length of Time\n(Total Lines 7 thru 9)",null,null,{"$f":"SUM(F73:F75)","v":0}]
[]
[null,"COMMENTS:"]
[]
[]
["DSHS/DDA Schedule O (Rev. 12/18)"]

{"sheet":"O Add'l","index":20,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[[78,1,78,10],[73,5,73,6],[74,2,74,4],[74,5,74,6],[75,2,75,4],[75,5,75,6],[77,1,77,10],[70,1,70,10],[71,2,71,4],[71,5,71,6],[71,7,75,10],[72,2,72,4],[72,5,72,6],[73,2,73,4],[55,2,55,4],[59,1,59,10],[60,1,60,2],[60,4,60,5],[61,1,62,1],[61,2,62,2],[61,3,62,3],[61,4,61,5],[61,6,62,6],[61,7,62,7],[61,8,62,8],[61,9,62,9],[61,10,62,10],[54,2,54,4],[38,2,38,8],[39,2,39,8],[40,2,40,8],[41,2,41,8],[42,2,42,8],[43,2,43,8],[44,2,44,8],[45,2,45,8],[51,2,51,4],[52,2,52,4],[53,2,53,4],[37,2,37,8],[18,4,18,8],[19,4,19,8],[22,1,22,10],[23,2,23,8],[24,2,24,8],[25,2,25,8],[26,2,26,8],[33,2,33,8],[34,2,34,8],[35,2,35,8],[36,2,36,8],[17,4,17,8],[0,0,0,11],[2,8,2,10],[5,0,5,11],[6,0,6,11],[7,0,7,11],[10,1,10,9],[12,2,12,3],[12,4,12,7],[13,2,13,3],[13,4,13,7],[16,4,16,8]]}
["SCHEDULE O"]
[]
[null,null,null,null,null,null,null,null,{"$f":"A!B7","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
[]
["IMPORTANT, PLEASE READ before completing schedule:"]
["COMPLETE A SEPARATE SCHEDULE FOR EACH LOCATION BY: PROGRAM TYPE AND COUNTY \nFOR ADDITIONAL COPIES OF SCHEDULE O CONTACT YOUR AGENCY'S RATE ANALYST \nReporting Period: January 1, 2018 to December 31, 2018 (One Calendar Year, 12 months, 2018)                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     "]
["The schedule(s) will be reviewed by the rate analyst to ensure the agency is reporting contracts, programs, and locations separately. Any cost reports found to be incomplete will be returned to the agency for correction. "]
[null,"1. AGENCY INFORMATION:"]
[]
[null,"Where are the Services Provided?"]
[]
[null,null,"PROGRAM TYPE",null,"PROGRAM NAME",null,null,null,"CITY","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. BOARD OF DIRECTORS INFORMATION:  "]
[null,"Non-Profit Agencies only, please fill out the following information if you have a Board of Directors or other governing board.  Do not include advisory committees or other non-governing, non-voting boards."]
[null,null,"a) Board of Directors -  Number of Members (total number of positions)?  …………… "]
[null,null,"b)  Board of Directors -Total number of voting board members? …………………………"]
[null,null,"c)  Voting Board Members - How many are people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?  ………………………………………………………………….."]
[null,null,"d)  Voting Board Members - How many are family members (parents, siblings, or other relatives) of people with intellectual disabilities or other developmental disabilities who are recipients of services (from this or any agency)?  ………………………………………………"]
[]
[null,"4. CLIENT INFORMATION: "]
[null,null,"Average Monthly Count of Clients supported in this program?  "]
[]
[null,"5. EMPLOYEE BENEFITS:"]
[]
[null,null,"In addition to wages, does your agency provide benefits to direct service staff?\nIf Yes, check all that apply",null,null,null,null,null,null," Yes"]
[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,"6. RECRUITING:"]
[]
[null,null,"\nDifference in recruiting new staff from 1/1/2018 - 12/31/2018?\n(Check boxes that apply)",null,null,"ENTRY LEVEL","1st LINE SUPERVISOR","PROGRAM MANAGERS","*SPECIALISTS\n (e.g., recreation, behavioral, or staff trainers, etc.)","NURSES\n(RN, LPN)"]
[null,null,"Situation is worse (Harder to recruit)"]
[null,null,"Some improvement (Easier to recruit)"]
[null,null,"Definite improvement (Much easier to recruit)"]
[null,null,"No difference"]
[]
[]
[null,"7. STAFFING INFORMATION:"]
[null,"SECTION 1A"]
[null,null,null,1,2,null,3,4,5,6,7]
[null,"Line #","POSITION TYPE","Number of ISS staff (Full-time, Part-time, & Temp combined) on December 31, 2018","Number of ISS staff who left:",null,"Number of ISS vacancies on December 31, 2018","Percentage of ISS work hours filled w/OT or non-scheduled staff (Estimates accepted if unknown)","Average number of days to fill vacant positions (Estimates accepted if unknown)","Current starting wage for this type of position within your agency in 2018 (Hourly Rate)","What is the average wage for this type of position after 2 years of employment (Hourly Rate)"]
[null,null,null,null,"(Six Months) Jan. 1, 2018 to June 30, 2018","(Six Months) July 1, 2018 to Dec. 31, 2018"]
[null,1,"ENTRY LEVEL",null,null,null,null,null,null,0,0]
[null,2,"1st LINE SUPERVISORS",null,null,null,null,null,null,0,0]
[null,3,"PROGRAM MANAGERS",null,null,null,null,null,null,0,0]
[null,4,"*SPECIALISTS (recreation, behavioral, or staff trainers, etc.)",null,null,null,null,null,null,0,0]
[null,5,"NURSES (RN, LPN)",null,null,null,null,null,null,0,0]
[null,null,"TOTAL\n(Lines 1 thru 5)",{"$f":"SUM(D64:D68)","v":0},{"$f":"SUM(E64:E68)","v":0},{"$f":"SUM(F64:F68)","v":0},{"$f":"SUM(G64:G68)","v":0}]
[]
[null,"SECTION 1B"]
[null,"Line #","Length of Time with your Agency\n",null,null,"Using the total number of staff from above, what is the length of time they have been with your agency?",null,"THE AMOUNTS CONNECTED BY THE RED ARROW MUST EQUAL ONE ANOTHER                                                                                           The Number of ISS staff from above (Section 1A) and Number of staff by length of time with your agency (Section 1B) should total to the same number\n"]
[null,7,"LESS than 6 Months"]
[null,8,"BETWEEN 6 and 12 months"]
[null,9,"OVER 12 months"]
[null,null,"Total Staff by Length of Time\n(Total Lines 7 thru 9)",null,null,{"$f":"SUM(F73:F75)","v":0}]
[]
[null,"COMMENTS:"]
[]
[]
["DSHS/DDA Schedule O (Rev. 12/18)"]

{"sheet":"P","index":21,"n_rows":46,"n_cols":11,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,0,0,11],[18,4,18,8],[19,4,19,8],[20,4,20,8],[21,4,21,8],[6,0,6,11],[3,8,3,10],[10,1,10,2],[9,9,9,10],[10,4,10,8],[11,4,11,8],[12,4,12,8],[5,0,5,11],[13,4,13,8],[14,4,14,8],[25,2,25,8],[27,2,27,8],[28,2,28,8],[34,2,34,8],[25,9,25,10],[27,9,27,10],[29,2,29,8],[28,9,28,10],[29,9,29,10],[31,9,31,10],[32,9,32,10],[33,9,33,10],[34,9,34,10],[26,2,26,8],[26,9,26,10],[43,2,43,8],[43,9,43,10],[44,2,44,8],[44,9,44,10],[30,2,30,8],[31,2,31,8],[32,2,32,8],[33,2,33,8],[30,9,30,10],[36,2,37,4],[39,2,40,4],[42,9,42,10],[42,2,42,8]]}
["SCHEDULE P"]
[]
[]
[null,null,null,null,null,null,null,null,{"$f":"A!B7","v":0}]
[null,null,null,null,null,null,null,null,"PROVIDER NAME"]
["INCLUDE ALL PROGRAMS FOR THE AGENCY ON THIS SCHEDULE"]
["Reporting Period: Dececmber 1, 2018  to  December 31, 2018 (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,null,"Supported Living - Contracted"]
[null,null,"Group Homes"]
[null,null,"Supported Living - SOLA"]
[null,null,"Group Training Home"]
[]
[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,null,"1. Total Number of employees working for the agency"]
[null,null,"2. Total number of Employees from #1 averaging 29 or less hours per week"]
[null,null,"3. Total number of Employees from #1 averaging 30-39 hours per week"]
[null,null,"4. Total number of Employees from #1 averaging 40 or more hours per week \n**The sum of #2, 3, & 4 must equal the total number of employees reported on #1"]
[null,null,"5. Currently how many employees who work in Supported Living (SL), Group Home (GH) or Children's Staffed Residential (CSR) are on your company provided health insurance plan? Please provide one number for all three types of services - add them all together if your company provides coverage for them separately, or accounts for them, separately. \n**This is for health insurance - do not include dental or other services (such as an Employee Assistance Plan (EAP), life insurance, disability insurance etc). Do not include coverage for employees who primarily work in other streams of revenue - private pay, home care, community access, supported employment etc. "]
[null,null,"6. Currently how many ISS hours per week does an employee have to work to be eligible for your company provided health insurance?"]
[null,null,"7. What is the cost per employee (the premium per subscriber) of company provided health insurance? This is the cost to the company and does not include the participation by the employee - if your current premium is $100.00 per subscriber and employee pays $20.00 towards the premium then you would enter $80.00"]
[null,null,"8. Currently how many of your employees work thirty (30) or more hours per week, but are not eligible for company provided health insurance?"]
[null,null,"9. Currently how many employees have waived your company provided health insurance, but will be required to take advantage of it in 2019? (Not 2018)"]
[null,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 2018 to ensure compliance with the ACA? What is the total amount of enrollees you anticipate will be on your plan. (Not 2018)"]
[]
[null,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, 2013 to 2017 or 2014 to 2018. Please represent this number as a percentage based on a per employee/subscriber cost increase from the prior year. For example: In 2017 the premium per employee was $100 and then increased to $150 in 2018; in 2018 you had a 50% increase in your per employee/subscriber premium costs.",null,null,2013,2014,2015,2016,2017,2018]
[]
[]
[null,null,"12. Over the same five year period you included in question 9 above, did your company reduce benefits offered through your company provided health insurance plan to reduce the company costs per employee (per subscriber) because the proposed rate increase was too high? For example, did your company move to a less robust plan which provided less coverage for employees/subscribers and required higher co-pays and deductibles? Please answer with \"Yes\" or \"No\"",null,null,2013,2014,2015,2016,20177,2018]
[]
[]
[null,null,"13. How many clients does your company serve in SL, GH and/or CSR? Please add all numbers together and provide one number for all clients served in all three areas."]
[null,null,"14. How many ISS contract hours per day does your company have in contract for SL, GH and CSR?  Please add them all together and provide one number for all three types."]
[]
["DSHS/DDA Schedule P (Rev. 12/18)"]

{"sheet":"CountyList","index":22,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
["County","MSA, Non MSA, King","Region","County Code",null,"County","MSA, Non MSA, King","Region","County Code"]
["Adams","NON-MSA","1N",1,null,"Adams","NON-MSA","1N",1]
["Asotin","MSA","1S",2,null,"Chelan","MSA","1N",4]
["Benton","MSA","1S",3,null,"Douglas","MSA","1N",9]
["Chelan","MSA","1N",4,null,"Ferry","NON-MSA","1N",10]
["Clallam","NON-MSA","3S",5,null,"Grant","NON-MSA","1N",13]
["Clark","MSA","3S",6,null,"Lincloln","NON-MSA","1N",22]
["Columbia","NON-MSA","1S",7,null,"Okanogan","NON-MSA","1N",24]
["Cowlitz","MSA","3S",8,null,"Pend Oreille","NON-MSA","1N",26]
["Douglas","MSA","1N",9,null,"Spokane","MSA","1N",32]
["Ferry","NON-MSA","1N",10,null,"Stevens","NON-MSA","1N",33]
["Franklin","MSA","1S",11,null,"Whitman","NON-MSA","1N",38]
["Garfield","NON-MSA","1S",12,null,"Asotin","MSA","1S",2]
["Grant","NON-MSA","1N",13,null,"Benton","MSA","1S",3]
["Grays Harbor","NON-MSA","3S",14,null,"Columbia","NON-MSA","1S",7]
["Island","MSA","2N",15,null,"Franklin","MSA","1S",11]
["Jefferson","NON-MSA","3S",16,null,"Garfield","NON-MSA","1S",12]
["King","KING","2S",17,null,"Kittitas","NON-MSA","1S",19]
["Kitsap","MSA","3N",18,null,"Klickitat","NON-MSA","1S",20]
["Kittitas","NON-MSA","1S",19,null,"Walla Walla","NON-MSA","1S",36]
["Klickitat","NON-MSA","1S",20,null,"Yakima","MSA","1S",39]
["Lewis","NON-MSA","3S",21,null,"Island","MSA","2N",15]
["Lincloln","NON-MSA","1N",22,null,"San Juan","NON-MSA","2N",28]
["Mason","MSA","3S",23,null,"Skagit","MSA","2N",29]
["Okanogan","NON-MSA","1N",24,null,"Snohomish","MSA","2N",31]
["Pacific","NON-MSA","3S",25,null,"Whatcom","MSA","2N",37]
["Pend Oreille","NON-MSA","1N",26,null,"King","KING","2S",17]
["Pierce","MSA","3N",27,null,"Kitsap","MSA","3N",18]
["San Juan","NON-MSA","2N",28,null,"Pierce","MSA","3N",27]
["Skagit","MSA","2N",29,null,"Clallam","NON-MSA","3S",5]
["Skamania","NON-MSA","3S",30,null,"Clark","MSA","3S",6]
["Snohomish","MSA","2N",31,null,"Cowlitz","MSA","3S",8]
["Spokane","MSA","1N",32,null,"Grays Harbor","NON-MSA","3S",14]
["Stevens","NON-MSA","1N",33,null,"Jefferson","NON-MSA","3S",16]
["Thurston","MSA","3S",34,null,"Lewis","NON-MSA","3S",21]
["Wahkiakum","NON-MSA","3S",35,null,"Mason","MSA","3S",23]
["Walla Walla","NON-MSA","1S",36,null,"Pacific","NON-MSA","3S",25]
["Whatcom","MSA","2N",37,null,"Skamania","NON-MSA","3S",30]
["Whitman","NON-MSA","1N",38,null,"Thurston","MSA","3S",34]
["Yakima","MSA","1S",39,null,"Wahkiakum","NON-MSA","3S",35]

{"sheet":"Lists","index":23,"n_rows":138,"n_cols":26,"rows_kept":138,"cut":false,"hidden":true,"merged":[]}
["Provider","Provider ID a.","Provider ID b.","FY18 Benchmark or Avg Benchmark","FY19 Benchmark or Avg Benchmark","Calander Year 2018 Average Benchmark","Urban Designation",null,"Urban Designation","FY2018 Jan - Jun Benchmark","FY2018 Jul - Dec Benchmark",null,"Sch B & J Detail",null,null,"Region","\"B\"",null,"Schedule B",null,null,null,null,null,null,"Schedule O"]
[null,null,null,null,null,null,null,null,"KING",18.53,19.53,null,null,null,null,null,null,null,1,2,3,"4a","4b","4c"]
["1N - Aacres WA",111414301,928190,{"$f":"VLOOKUP(G3,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G3,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D3+E3)/2","v":18.43},"MSA",null,"MSA",17.93,18.93,null,"SL",null,null,"1N","Cost Report",null,null,null,null,null,null,null,null,"Supported Living - Contracted"]
["1N - Aacres Spokane 2",111414310,null,17.93,18.93,{"$f":"SUM(D4+E4)/2","v":18.43},"MSA",null,"MSA/NON-MSA",{"$f":"+(17.93+17.62)/2","v":17.774999999999999},{"$f":"+(18.93+18.62)/2","v":18.774999999999999},null,"GH",null,null,"1S","Budget",null,"Yes","Individual","Cash","Yes","Yes","ISS Paid Hours Worked",null,"Group Homes"]
["1N - Aacres Spokane 3",111414309,null,17.93,18.93,{"$f":"SUM(D5+E5)/2","v":18.43},"MSA",null,"NON-MSA",17.62,18.62,null,"SL/GH",null,null,"2N",null,null,"No","Partnership","Accrual","No","No","Other Method",null,"Supported Living - SOLA"]
["1N - Adult Guidance & Empowerment Service",111684901,131592,17.93,18.93,18.43,"MSA",null,null,null,null,null,null,null,null,"2S",null,null,null,"Proprietary Corporation","Modified Cash",null,null,null,null,"Group Training Home"]
["1N - Ambitions - Wenatchee, Omak, Moses Lake",111901903,925218,17.774999999999999,18.774999999999999,18.274999999999999,"MSA/NON-MSA",null,null,null,null,null,null,null,null,"3N",null,null,null,"Non-Profit Corporation"]
["1N - Ambitions - Spokane",111901906,null,17.93,18.93,{"$f":"SUM(D8+E8)/2","v":18.43},"MSA",null,null,null,null,null,null,null,null,"3S",null,null,null,"Government Agency"]
["1N - ARC of Spokane",111426502,322383,17.93,18.93,18.43,"MSA"]
["1N - Assisted Residential Services",111705601,343692,17.93,18.93,18.43,"MSA"]
["1N - Community Integrated Services",111425301,823672,17.93,18.93,18.43,"MSA"]
["1N - Community Visions",111530102,330801,17.93,18.93,18.43,"MSA"]
["1N - Dreamworks Residential",111913801,621527,17.62,18.62,18.12,"NON-MSA"]
["1N - Drive Services",111621401,322188,17.93,18.93,18.43,"MSA"]
["1N - Excel Supported Living",111322002,null,{"$f":"VLOOKUP(G15,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G15,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D15+E15)/2","v":18.43},"MSA"]
["1N - Grant County Developmental Disabilities",200012501,162436,{"$f":"VLOOKUP(G16,$I$2:$K$5,2)","v":17.62},{"$f":"VLOOKUP(G16,$I$2:$K$5,3)","v":18.62},18.12,"NON-MSA"]
["1N - Kaler House",111686001,92824,17.93,18.93,18.43,"MSA"]
["1N - Latah Services",111762501,836399,17.93,18.93,18.43,"MSA"]
["1N - Living In Fulfilling Environment",111777301,58220,17.93,18.93,18.43,"MSA"]
["1N - LMK",111988202,621505,17.62,18.62,18.12,"NON-MSA"]
["1N - Mission Vista",111707401,306053,17.93,18.93,18.43,"MSA"]
["1N - Parent's Cooperative Society for the Handicapped (Merry Glen)",111328901,158076,17.93,18.93,18.43,"MSA"]
["1N - Skils'kin",111632701,695912,17.93,18.93,18.43,"MSA"]
["1S - Alternative Residential Services",111625401,450461,17.774999999999999,18.774999999999999,18.274999999999999,"MSA/NON-MSA"]
["1S - Ambitions - Kennewick",111901901,925274,17.93,18.93,18.43,"MSA"]
["1S - Ambitions - Yakima",111901907,null,17.93,18.93,{"$f":"SUM(D26+E26)/2","v":18.43},"MSA"]
["1S - Community Living",111962202,120191,17.93,18.93,18.43,"MSA"]
["1S - Deaf Access Washington",111321901,91176,17.93,18.93,18.43,"MSA"]
["1S - Elmview",111604101,340022,17.774999999999999,18.774999999999999,18.274999999999999,"MSA/NON-MSA"]
["1S - Habilitat",111449601,531937,17.62,18.62,18.12,"NON-MSA"]
["1S - Kittitas Interactive Management",111688701,45134,17.62,18.62,18.12,"NON-MSA"]
["1S - Reach Supported Living",209862801,null,{"$f":"VLOOKUP(G32,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G32,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D32+E32)/2","v":18.43},"MSA"]
["1S - Tri-Cities Residential Services",111872501,83918,{"$f":"VLOOKUP(G33,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G33,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["1S - Valley Residential Services",111777901,66754,17.62,18.62,18.12,"NON-MSA"]
["2N - Aacres",111414307,null,17.93,18.93,{"$f":"SUM(D35+E35)/2","v":18.43},"MSA"]
["2N - Access Living",111675101,881577,17.93,18.93,18.43,"MSA"]
["2N - All Heart Agency",111961601,53910,17.93,18.93,18.43,"MSA"]
["2N - Alpha Supported Living Services",111320902,null,17.93,18.93,18.43,"MSA"]
["2N - Ambitions Whatcom",111901908,null,{"$f":"VLOOKUP(G39,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G39,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D39+E39)/2","v":18.43},"MSA"]
["2N - Camelot Society",101955202,null,17.93,18.93,18.43,"MSA"]
["2N - Cascade Connections",111724102,"588510/780404",{"$f":"VLOOKUP(G41,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G41,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["2N - Evergreen Supported Living",111690301,197341,17.93,18.93,18.43,"MSA"]
["2N - Holly Community Services",111765001,956087,17.93,18.93,18.43,"MSA"]
["2N - La Casa de Esperanza ",111390801,662956,17.93,18.93,18.43,"MSA"]
["2N - Puffin Island",111959501,119992,17.93,18.93,18.43,"MSA"]
["2N - Quilceda Community Services",111321203,877,17.93,18.93,18.43,"MSA"]
["2N - Rehabco",111681901,57208,17.93,18.93,18.43,"MSA"]
["2N - Rescare",111968512,null,{"$f":"VLOOKUP(G48,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G48,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D48+E48)/2","v":18.43},"MSA"]
["2N - Sails",111805705,null,{"$f":"VLOOKUP(G49,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G49,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D49+E49)/2","v":18.43},"MSA"]
["2N - Service Alternatives for WA",111513304,301532,{"$f":"VLOOKUP(G50,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G50,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["2N - Snohomish Supportive Living Services",111518901,339336,17.93,18.93,18.43,"MSA"]
["2N - Soundview Association",111830201,"660205/973647",17.93,18.93,18.43,"MSA"]
["2N - Steps Toward Independence",112034301,877402,17.93,18.93,18.43,"MSA"]
["2N - Sunrise Services",203434610,177937,17.93,18.93,18.43,"MSA"]
["2N - Village Community Services",111938301,588565,17.93,18.93,18.43,"MSA"]
["2N - Volunteers of America",200494106,126007,17.93,18.93,18.43,"MSA"]
["2S - Aacres",111414302,928233,18.53,19.53,19.03,"KING"]
["2S - Alpha Supported Living Services",111320901,"040175/827344",18.53,19.53,19.03,"KING"]
["2S - Ambitions",111901902,925035,18.53,19.53,19.03,"KING"]
["2S - Arc of King County",112013701,825497,18.53,19.53,19.03,"KING"]
["2S - Banchero Friends Services",111415001,72441,18.53,19.53,19.03,"KING"]
["2S - Bethesda Lutheran Communities",111621301,"432532/433659",18.53,19.53,19.03,"KING"]
["2S - Camelot Society",101955201,303794,18.53,19.53,19.03,"KING"]
["2S - Cascade Community Services",111875001,151578,18.53,19.53,19.03,"KING"]
["2S - Citizen Access Residential Resources",111533401,677982,18.53,19.53,19.03,"KING"]
["2S - Community Integrated Services",111425302,248092,18.53,19.53,19.03,"KING"]
["2S - Community Living",111962201,205884,18.53,19.53,19.03,"KING"]
["2S - Destiny House Operations",111992801,628058,18.53,19.53,19.03,"KING"]
["2S - Friendship House",111405501,44564,18.53,19.53,19.03,"KING"]
["2S - Greenwood Home",111913301,610002,18.53,19.53,{"$f":"SUM(D70+E70)/2","v":19.03},"KING"]
["2S - Habilitation Services",208173701,null,18.53,19.53,19.03,"KING"]
["2S - Helping Hands for the Disabled",111736002,"626261/903550",18.53,19.53,19.03,"KING"]
["2S - Inglewood Residential and Community Services",111568401,433445,18.53,19.53,19.03,"KING"]
["2S - Integrated Living Services",111789002,"180625/681956",18.53,19.53,19.03,"KING"]
["2S - L'Arche Noah Sealth of Seattle",111798601,609889,18.53,19.53,19.03,"KING"]
["2S - Life Skills Center",111499601,68536,18.53,19.53,19.03,"KING"]
["2S - Maksu",111577901,825577,18.53,19.53,19.03,"KING"]
["2S - Nellie Goodhue Group Homes",111800501,610011,18.53,19.53,19.03,"KING"]
["2S - Parkview Services",111456901,602928,18.53,19.53,19.03,"KING"]
["2S - Premier Care Services",111437001,429624,18.53,19.53,19.03,"KING"]
["2S - Provail",101144803,340322,18.53,19.53,19.03,"KING"]
["2S - Puget Sound Regional Services",111925301,825613,18.53,19.53,19.03,"KING"]
["2S - Res-Care Washington",111968506,489354,18.53,19.53,19.03,"KING"]
["2S - Sails",111805704,null,{"$f":"VLOOKUP(G84,$I$2:$K$5,2)","v":18.53},{"$f":"VLOOKUP(G84,$I$2:$K$5,3)","v":19.53},{"$f":"SUM(D84+E84)/2","v":19.03},"KING"]
["2S - Service Alternatives for WA",111513302,544863,{"$f":"VLOOKUP(G85,$I$2:$K$5,2)","v":18.53},{"$f":"VLOOKUP(G85,$I$2:$K$5,3)","v":19.53},19.03,"KING"]
["2S - Shamrock Living Services",111958301,78744,18.53,19.53,19.03,"KING"]
["2S - Shared Journeys",111515201,167481,18.53,19.53,19.03,"KING"]
["2S - Stand Together",111753401,528919,18.53,19.53,19.03,"KING"]
["2S - Tahoma Hills",111799101,351507,18.53,19.53,19.03,"KING"]
["2S - Total Living Concept",111571101,"442688/825635",18.53,19.53,19.03,"KING"]
["2S - United Friends Group Home",101601101,601336,18.53,19.53,19.03,"KING"]
["2S - Volunteers of America",200494104,677104,18.53,19.53,19.03,"KING"]
["3N - Aacres WA",111414304,928259,17.93,18.93,18.43,"MSA"]
["3N - Ambitions, WA",111901904,925079,17.93,18.93,18.43,"MSA"]
["3N - Communitas Group",102702801,"539414/789676",17.93,18.93,18.43,"MSA"]
["3N - Community Alternatives for People with Autism (CAPA)",112026801,868252,17.93,18.93,18.43,"MSA"]
["3N - Educational Programs in Home Living",111975401,219207,17.93,18.93,18.43,"MSA"]
["3N - Group Action for Peninsula People",111703801,196657,17.93,18.93,18.43,"MSA"]
["3N - Hope Human Services",207150601,null,17.93,18.93,18.43,"MSA"]
["3N - Kitsap Residences",111781001,116024,17.93,18.93,18.43,"MSA"]
["3N - Kitsap Tenant Support Services",111715902,586518,17.93,18.93,18.43,"MSA"]
["3N - L'Arche Tahoma Hope Community",111610303,236004,17.93,18.93,18.43,"MSA"]
["3N - Life Force Services",111691201,342850,17.93,18.93,18.43,"MSA"]
["3N - NW Services for Independent Living",111812601,587155,17.93,18.93,18.43,"MSA"]
["3N - Options Unlimited",111904801,625360,17.93,18.93,18.43,"MSA"]
["3N - PAM Group Home",111728401,587202,17.93,18.93,18.43,"MSA"]
["3N - Puget Sound Assisted Living",111557601,686863,17.93,18.93,18.43,"MSA"]
["3N - Res-Care Washington",111968504,378828,17.93,18.93,18.43,"MSA"]
["3N - Self Determined Services ",111874501,153159,17.93,18.93,18.43,"MSA"]
["3N - Service Alternatives for WA",111513305,358400,17.93,18.93,18.43,"MSA"]
["3N - Self Reliant Endeavors",204861001,null,{"$f":"VLOOKUP(G111,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G111,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D111+E111)/2","v":18.43},"MSA"]
["3N - Tahoma Associates",111335302,297927,{"$f":"VLOOKUP(G112,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G112,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["3N - Valley Supported Living",111938101,965589,17.93,18.93,18.43,"MSA"]
["3S - Aacres - Thurston",111414308,929653,17.93,18.93,18.43,"MSA"]
["3S - Aacres - Clark",111414303,929653,17.62,18.62,{"$f":"SUM(D115+E115)/2","v":18.12},"NON-MSA"]
["3S - Ambitions",111901905,925079,17.774999999999999,18.774999999999999,{"$f":"SUM(D116+E116)/2","v":18.274999999999999},"MSA/NON-MSA"]
["3S - Another Option",111619102,415519,17.93,18.93,18.43,"MSA"]
["3S - Arc of Clark County",102623403,451257,17.93,18.93,18.43,"MSA"]
["3S - Brighton Enterprises - Clark",111686601,59722,17.93,18.93,18.43,"MSA"]
["3S - Brighton Enterprises - Thurston",111686602,null,17.93,18.93,{"$f":"SUM(D120+E120)/2","v":18.43},"MSA"]
["3S - Caregivers of Washington",203690902,283667,{"$f":"VLOOKUP(G121,$I$2:$K$5,2)","v":17.62},{"$f":"VLOOKUP(G121,$I$2:$K$5,3)","v":18.62},18.12,"NON-MSA"]
["3S - CCH Individual Support Services",111909801,"597522/987094",17.62,18.62,18.12,"NON-MSA"]
["3S - Citizen Access Residential Resources","111533403/111533401",742522,17.93,18.93,18.43,"MSA"]
["3S - Community Resources",111977701,550757,17.774999999999999,18.774999999999999,18.274999999999999,"MSA/NON-MSA"]
["3S - Exceptional Foresters",111551801,593835,17.93,18.93,18.43,"MSA"]
["3S - Harbor Alternative Living Association",111349601,593904,17.62,18.62,18.12,"NON-MSA"]
["3S - Hope Human Services",207150603,null,17.93,18.93,18.43,"MSA"]
["3S - Kitsap Tenant Support Services",111715901,493668,{"$f":"VLOOKUP(G128,$I$2:$K$5,2)","v":17.62},{"$f":"VLOOKUP(G128,$I$2:$K$5,3)","v":18.62},18.12,"NON-MSA"]
["3S - Kokua",111492901,708859,{"$f":"VLOOKUP(G129,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G129,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["3S - Life Force Services - Thurston",111691202,261724,{"$f":"VLOOKUP(G130,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G130,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["3S - Life Force Services - Clark",111691204,null,{"$f":"VLOOKUP(G131,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G131,$I$2:$K$5,3)","v":18.93},{"$f":"SUM(D131+E131)/2","v":18.43},"MSA"]
["3S - Life Works",111594402,"098329/597533",{"$f":"VLOOKUP(G132,$I$2:$K$5,2)","v":17.93},{"$f":"VLOOKUP(G132,$I$2:$K$5,3)","v":18.93},18.43,"MSA"]
["3S - Placeone",111512001,152951,17.93,18.93,18.43,"MSA"]
["3S - ROAR",111442501,612114,17.93,18.93,18.43,"MSA"]
["3S - Reside Residential Care of Washington",111864101,137760,17.93,18.93,18.43,"MSA"]
["3S - SOLO",111910501,642421,17.93,18.93,18.43,"MSA"]
["3S - Twin Harbors Group Home Association",111669901,663515,17.62,18.62,{"$f":"SUM(D137+E137)/2","v":18.12},"NON-MSA"]
["3S - Vancare",111811201,564924,17.93,18.93,{"$f":"SUM(D138+E138)/2","v":18.43},"MSA"]