{"text_format":"1","workbook":"xlsx","n_sheets":19,"sheets":["Combine all facilities","Overview","A - Certification","A - CoverSheet","B - Year 1","B - Year 2","B - Year 3","B - Note Pad","B - Definitions","B - Budget Total","Combine all facilities (2)","C - Macros Instructions","C - Instructions","C - Timeline","D - Narrative","E -Instructions","E - Operating","E - Quality","E - Financial"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":1,"defined_names":29,"comments":0,"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":"Combine all facilities","index":0,"n_rows":3,"n_cols":20,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,2,0],[0,1,0,12],[0,13,0,15],[0,16,1,18],[0,19,2,19],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,13,1,15]]}
["Facility Name","Operating Expenses-Direct",null,null,null,null,null,null,null,null,null,null,null,"Operating Expenses-Indirect ",null,null,"Total Direct and Indirect Expenses",null,null,"Grand Total"]
[null,"Total Inpatient",null,null,"Total Outpatient",null,null,"Total Ancillary",null,null,"Total Direct",null,null,"Total Indirect"]
[null,"Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense"]

{"sheet":"Overview","index":1,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[18,1,18,2],[20,1,20,2],[16,1,16,2]]}
["Tab Name","Description","Notes"]
["A - Certification","PDF of signed & dated Certification","Instructions at top of page (MUST be updated with Quarterly Reports)"]
["A - CoverSheet","Summary of award information","This form will completed by the Department."]
["B - Year 1","Entry of budgeted Year 1 expenses","Instructions at top of page"]
["B - Year 2","Entry of budgeted Year 2 expenses","Instructions at top of page"]
["B - Year 3","Entry of budgeted Year 3 expenses","Instructions at top of page"]
["B - Note Pad","Additional details for Year 1-3 budgets\nAdditional details for Capital Financing\nAdditional details for Sustainability","Instructions at top of page"]
["B - Budget Total","Display of Total 3 Year Budget","No entry required; data is automatically populated from Year 1-3 Budgets"]
["C - Timeline","Entry of plan action items, objectives, steps to completion, and associated costs.","Instructions located on tabs \"C - Macros Instructions\" and \"C - Instructions\"\nTotal for Year 1 timeline should match total for Year 1 budget, etc. "]
["D - Narrative","Narrative of progress being made towards project","Instructions at top of page"]
["E - Financial","Entry of metrics, descriptions, baselines, and projections for Year 1, 2 and 3","Instructions located on tab \"E - Instructions\""]
["E - Operating","Entry of metrics, descriptions, baselines, and projections for Year 1, 2 and 3","Instructions located on tab \"E - Instructions\""]
["E - Quality","Entry of metrics, descriptions, baselines, and projections for Year 1, 2 and 3","Instructions located on tab \"E - Instructions\""]
["TMRAA","(To be) signed Temporary Medicaid Rate Adjustment Agreement between the facility and the Department","Located in separate file. Please print, sign, and scan the document to be returned with this package. (Not required to resubmit for Quarterly Reporting)"]
[]
["Other Notes:","Operating vs. Capital Costs"]
[null,"VAP funding can only be applied to operating costs. Operating costs include both overhead costs and administrative costs. This includes, but is not limited to: utilities, wages, advertising, raw materials, office supplies and consumables.  \nCapital costs should not be included in the Expenditure Plans or the Timelines.  Capital costs are fixed, one-time expenses incurred on the purchase of land, buildings, construction, rent and capital debt. If your facility's plan is related to outside capital costs, please include a short narrative of how they will be financed (since they cannot be funded through VAP) on the \"B - Note Pad\" tab. "]
[null,"Specific Deliverables:"]
[null,"The Quarterly Reports must include an update to the Timeline, Expenditure Plan, and Metrics attachments detailing the status of specific activities, services or work projects necessary to complete the Project, including the specifics of expenditures to date, results for all metrics, and any closure plan progress (if applicable).  Documentation of deliverables should be broken down into the discrete activities that were performed during the quarter and any impact on the anticipated timeline(s) for implementation or completion of Project deliverables.  "]
[null,"Submission of Reports:"]
[null,"The Quarterly Reports must be filed electronically with the Department no later than 15 days after the close of the given quarter, as detailed in the terms of Agreement under item number 2 of the TMRAA. Reports for VAP/Safety Net Projects should be sent to the Bureau of Vital Access Provider Reimbursement, attention of John W. Gahan, Jr., Director, via email address: bvapr@health.state.ny.us.  \nReports must include a signature page (as PDF document) documenting certification of the Report by the facility’s Authorized Signatory to this Agreement, or his/her Contact designee identified as the Authorizing  Officer on Attachment A of this Agreement."]
[]
["If you need any clarification, after reading the instructions for the attachment, please send an email to BVAPR@health.state.ny.us. "]

{"sheet":"A - Certification","index":2,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,2,6,5],[1,2,1,5],[2,2,2,5],[3,2,3,5],[4,2,4,5],[5,2,5,5],[18,2,18,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[30,2,30,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,3,24,5],[25,2,25,5],[26,4,26,5],[28,2,28,5],[29,2,29,5],[44,2,44,3],[31,2,31,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[56,2,56,5],[45,2,45,3],[46,2,46,5],[47,2,47,4],[48,2,48,4],[49,2,49,5],[50,2,50,4],[51,2,51,5],[52,2,52,5],[53,2,53,5],[54,2,54,5],[55,2,55,5]]}
[]
[null,null,"Instructions:  "]
[]
[null,null,"The facility's Operator Signatory (e.g., CEO or CFO) must sign and date the Certification Statement provided below as certification of:  The budgeted cost and statistical data detailed in the Expenditure Plan (Attachment B),  the Project Timeline (Attachment C) , VAP/Safety Net Quarterly Narrative Report (Attachment D), and the Metrics Quarterly Report (Attachment E) included as part of the Temporary Medicaid Rate Adjustment Agreement (TMRAA). "]
[null,null,"This Certification Statement must initially be provided in support of Attachment B, C, D and E submitted with the TMRAA.  This Certification Statement MUST ALSO BE SUBMITTED (with \"current\" signature and date) as certification of updated Project Timeline cost and statistical data being provided for a given quarter for each Quarterly Progress Report filing.    "]
[null,null,"1. Insert Signatory's Name and Title below."]
[]
[null,null,"2. Print the Certification Statement (print specs are pre-set) to obtain a hard copy of the pre-filled Certification Statement document.  "]
[]
[null,null,"3. The facility's authorized Operator Signatory must sign and date the hard copy Certification Statement document. "]
[]
[null,null,"4. Make a PDF of the signed and dated hard copy Certification Statement document."]
[]
[null,null,"5. Submit the Certification Statement as a PDF to the Department along with the electronic filing of Attachment B, C, D, and E (this excel file)."]
[]
[]
[null,null,"AUTHORIZATION FOR SUBMISSION OF THE"]
[null,null,"VITAL ACCESS PROVIDER (VAP)/SAFETY NET PROGRAM"]
[null,null,"PROJECT EXPENDITURE PLAN (WORK PLAN BUDGET)"]
[null,null,"PROJECT TIMELINE (WORK PLAN TIMELINE)"]
[null,null,"VAP/SAFETY NET QUARTERLY NARRATIVE REPORT"]
[null,null,"METRICS QUARTERLY REPORT"]
[]
[]
[null,null,"Facility:"]
[]
[null,null,"OpCert #:"]
[null,null,"MMIS #:"]
[]
[null,null,"CERTIFICATION STATEMENT"]
[]
[null,null,"I hereby certify that I have read and examined the costs, full-time equivalents (FTEs) and other statistical data contained in the Year 1 through Year 3 Expenditure Plans (as applicable) and the Note Pad Schedule included as Attachment B (tabs \"B - Year 1\", \"B - Year 2\", \"B - Year 3\", and \"B - Note Pad\") provided in support of the facility's VAP/Safety Net Project, and that to the best of my knowledge and belief, the information fairly and accurately represents the budgeted costs, FTEs and statistics necessary to implement the facility's VAP/Safety Net Project. "]
[]
[null,null,"I hereby certify that I have read and examined the costs and planned / actual completion date data contained in the Project Timeline included as Attachment C (tab \"C - Timeline\") provided in support of the facility's VAP/Safety Net Project, and that to the best of my knowledge and belief, the information fairly and accurately represents the costs and completion date statistics related to implementation of the facility's VAP/Safety Net Project. "]
[]
[null,null,"I hereby certify that I have read and examined the metric data contained in Attachment E (tabs \"E - Instructions\", \"E - Financial\", \"E - Operating\", and \"E - Quality\") provided in support of the facility's VAP/Safety Net Project, and that to the best of my knowledge and belief, the information fairly and accurately represents the Financial, Operational, and Quality Metrics related to the implementation of the facility's VAP/Safety Net Project."]
[]
[null,null,"I hereby affirm that the reports do NOT include costs or expenditures which are included in any HEAL Award Grants."]
[]
[null,null,"I hereby authorize the submission of Attachment B (tabs \"B - Year 1\", \"B - Year 2\", \"B - Year 3\", and \"B - Note Pad\"), Attachment C (tab \"C - Timeline\"), Attachment D (tab \"D - Narrative\"), and Attachment E (tabs \"E - Instructions\", \"E - Financial\", \"E - Operating\", and \"E - Quality\") to the New York State Department of Health, Office of Health Insurance Programs, as documentation of the Project's budgeted expenditures, staffing needs, planned / actual completion dates, narrative report, and metrics goals and accomplishments."]
[]
[]
[]
[]
[]
[null,null,"Signature Date",null,null,"Authorized Signature"]
[]
[]
[null,"Insert Signatory Name =>","Print Signatory Name:"]
[]
[null,"Insert Signatory Title =>","Print Signatory Title:"]

{"sheet":"A - CoverSheet","index":3,"n_rows":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[[23,2,23,3],[24,2,24,3],[25,2,25,3],[26,2,26,3],[21,2,21,3],[7,2,7,3],[8,1,11,1],[8,2,11,3],[12,2,13,3],[14,2,14,3],[20,2,20,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[18,2,18,3],[19,2,19,3]]}
[null,null,"This form will be completed by the Department"]
[]
[null,"NYS Department of Health"]
[null,"Vital Access Provider (VAP) / Safety Net Award Summary"]
[]
[null,"Date Submitted:              "]
[]
[null,"Legal Entity Name:",null,null,"opcert#"]
[null,"Mailing Address:",null,null,"mmis #"]
[null,null,null,null,"NPI #"]
[]
[]
[null,"Authorizing Officer"]
[null,"Contact Name:"]
[null,"Contact Title:"]
[null,"Phone:"]
[null,"Email:"]
[null,"VAP/Safety Net Project Name:"]
[null,"Total Award Amount:"]
[]
[null,"2019-'20",null,null,"* State Fiscal Year (SFY)"]
[null,"2020-'21"]
[]
[null,2019,null,null,"** Calendar Year (CY)"]
[null,2020]
[null,2021]
[null,"Payment Contingencies:","Provider must submit timely quarterly progress reports to the NYS Department of Health documenting the status of the use of VAP/Safety Net Award funding.   See Attachment C, D, and E for details."]

{"sheet":"B - Year 1","index":4,"n_rows":123,"n_cols":13,"rows_kept":123,"cut":false,"hidden":false,"merged":[[9,0,9,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[4,0,5,12],[8,0,8,12],[6,0,6,12],[7,0,7,12],[86,0,86,12],[31,2,31,3],[31,6,31,8],[31,9,31,10],[32,0,32,12],[33,3,33,6],[33,7,33,11],[61,0,61,12],[62,0,62,12],[63,0,63,12],[64,3,64,6],[64,7,64,11],[121,7,121,10],[122,7,122,10],[87,0,87,12],[88,0,88,12],[89,3,89,6],[89,7,89,11],[119,7,119,10],[120,7,120,10],[10,0,10,12],[11,0,11,12],[12,0,12,12],[13,0,13,12],[14,0,14,12],[15,0,15,12],[16,0,16,1],[16,2,16,12],[17,0,17,1],[17,2,17,12],[18,0,18,1],[18,2,18,12],[19,0,19,1],[19,2,19,12],[21,0,21,12],[20,0,20,12],[22,0,22,12],[28,0,28,12],[29,0,29,12],[23,0,23,12],[24,0,24,12],[25,0,25,12],[26,0,26,12],[27,0,27,12]]}
["Vital Access Provider (VAP) / Safety Net Funding"]
["Medicaid Rate Adjustment"]
["Year 1 Expenditure Plan (VAP ONLY)"]
[]
[]
[]
["Instructions for Expenditure Plan :"]
[]
["1) This schedule details budgeted and actual operating expenses directly related to funding requested for your VAP/Safety Net Project.  Do not include any capital costs in the Expenditure Plans. For a definition of capital vs. operating costs, please see the Definitions tab. "]
[]
["2) Enter Date Submitted below as month/day/year. The cell is formatted to display the date as text. Date will auto fill to B Year 2, B Year 3, B Note Pad, B Budget Total, and the C Timeline tabs. As a reminder, this date must be updated with each Quarterly Report filing."]
[]
["3)Enter the Begin Date of the First Quarter below as month/day/year. The cell is formatted to display the date as text. Date will auto fill to B Year 2, B Year 3, B Note Pad, B Budget Total, and the C Timeline tabs."]
[]
["4) Please indicate the Budgeted Expenditures and Actual Expenditures (if project has begun), rounded to whole numbers, and Comments for the following categories for all lines as applicable:  "]
[]
["Full time equivalents (FTEs) -",null,"total annual paid hours (including budgeted vacation, sick leave & overtime expectations) for the employee(s) divided by the number of hours in a standard work week, then divide by 52, expressed to one decimal point (e.g., 1.5)"]
["Salaries & Wages - ",null,"amounts paid to employees as compensation for their service."]
["Employee Benefits - ",null,"payroll related costs such as FICA, SUI, group health insurance, pensions, etc. to be paid to or on behalf of employees."]
["Other Than Personal Service (OTPS) Costs - ",null,"Project costs not related to salaries and wages (e.g., office supplies, fees)."]
[]
["Note: Totals and sub-totals will auto-calculate; please only enter data in the white cells"]
[]
["4) Enter amounts (if applicable) as a positive number: Provider In-Kind Contributions (Line 65) and Incremental Revenue To Offset (Line 66)."]
[]
["5) Please see 'Definitions' tab for detailed definitions/descriptions of all lines."]
[]
["6) Do not add lines to this schedule. If needed for clarity, please use the 'Note Pad' tab to provide additional details to specific costs reported below. "]
[]
[]
[]
[null,"Date Submitted:",null,null,null,null,"Begin Date of First Quarter"]
["Operating Expenses-Direct"]
[null,null,null,"YEAR 1 BUDGETED EXPENDITURES",null,null,null,"YEAR 1 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 1 Actual Expense","Comments"]
[" "," "]
["A.","Inpatient Services:",null,null,null,null," "]
[1,"Physicians",null,null,null,null,{"$f":"SUM(D38:F38)","v":0},null,null,null,null,{"$f":"SUM(H38:K38)","v":0}]
[2,"Nursing:"]
[3,"         Administrator",null,null,null,null,{"$f":"SUM(D40:F40)","v":0},null,null,null,null,{"$f":"SUM(H40:K40)","v":0}]
[4,"         Nurse Practitioner",null,null,null,null,0,null,null,null,null,0]
[5,"         RN",null,null,null,null,0,null,null,null,null,0]
[6,"         LPN",null,null,null,null,0,null,null,null,null,0]
[7,"Administration/Clerical",null,null,null,null,0,null,null,null,null,0]
[8,"Technicians",null,null,null,null,0,null,null,null,null,0]
[9,"Aides",null,null,null,null,0,null,null,null,null,0]
[10,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[11,"Total Inpatient",{"$f":"SUM(C38:C47)","v":0},{"$f":"SUM(D38:D47)","v":0},{"$f":"SUM(E38:E47)","v":0},{"$f":"SUM(F38:F47)","v":0},{"$f":"SUM(G38:G47)","v":0},{"$f":"SUM(H38:H47)","v":0},0,0,0,{"$f":"SUM(L38:L47)","v":0}]
[null,null,null,null,null,null," "]
["B.","Outpatient Services:"]
[12,"Physicians",null,null,null,null,{"$f":"SUM(D51:F51)","v":0},null,null,null,null,{"$f":"SUM(H51:K51)","v":0}]
[13,"Nursing:"]
[14,"         Administrator",null,null,null,null,{"$f":"SUM(D53:F53)","v":0},null,null,null,null,{"$f":"SUM(H53:K53)","v":0}]
[15,"         Nurse Practitioner",null,null,null,null,0,null,null,null,null,0]
[16,"         RN",null,null,null,null,0,null,null,null,null,0]
[17,"         LPN",null,null,null,null,0,null,null,null,null,0]
[18,"Administration/Clerical",null,null,null,null,0,null,null,null,null,0]
[19,"Technicians",null,null,null,null,0,null,null,null,null,0]
[20,"Aides",null,null,null,null,0,null,null,null,null,0]
[21,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[22,"Total Outpatient",{"$f":"SUM(C51:C60)","v":0},{"$f":"SUM(D51:D60)","v":0},{"$f":"SUM(E51:E60)","v":0},{"$f":"SUM(F51:F60)","v":0},{"$f":"SUM(G51:G60)","v":0},{"$f":"SUM(H51:H60)","v":0},0,0,0,0]
[]
[]
["Operating Expenses-Direct"]
[null,null,null,"YEAR 1 BUDGETED EXPENDITURES",null,null,null,"YEAR 1 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 1 Actual Expense","Comments"]
[]
["C.","Ancillary Services:"]
[23,"Laboratory Services",null,null,null,null,{"$f":"SUM(D69:F69)","v":0},null,null,null,null,{"$f":"SUM(H69:K69)","v":0}]
[24,"Electrocardiology",null,null,null,null,{"$f":"SUM(D70:F70)","v":0},null,null,null,null,0]
[25,"Electroencephology",null,null,null,null,0,null,null,null,null,0]
[26,"Radiology",null,null,null,null,0,null,null,null,null,0]
[27,"Inhalation Therapy",null,null,null,null,0,null,null,null,null,0]
[28,"Podiatry",null,null,null,null,0,null,null,null,null,0]
[29,"Dental",null,null,null,null,0,null,null,null,null,0]
[30,"Psychiatric",null,null,null,null,0,null,null,null,null,0]
[31,"Therapy-Physical",null,null,null,null,0,null,null,null,null,0]
[32,"Therapy-Occupational",null,null,null,null,0,null,null,null,null,0]
[33,"Therapy-Speech Language Pathology",null,null,null,null,0,null,null,null,null,0]
[34,"Pharmaceutical Services",null,null,null,null,0,null,null,null,null,0]
[35,"Central Service Supply",null,null,null,null,0,null,null,null,null,0]
[36,"Medical Staff Services",null,null,null,null,0,null,null,null,null,0]
[37,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[38,"Total Ancillary",{"$f":"SUM(C69:C83)","v":0},{"$f":"SUM(D69:D83)","v":0},{"$f":"SUM(E69:E83)","v":0},{"$f":"SUM(F69:F83)","v":0},{"$f":"SUM(G69:G83)","v":0},{"$f":"SUM(H69:H83)","v":0},0,0,0,0]
[]
[39,"Total Direct (Lines 11 + 22 + 38)",{"$f":"C48+C61+C84","v":0},{"$f":"D48+D61+D84","v":0},{"$f":"E48+E61+E84","v":0},{"$f":"F48+F61+F84","v":0},{"$f":"G48+G61+G84","v":0},{"$f":"H48+H61+H84","v":0},0,0,0,0]
[]
[]
["Operating Expenses-Indirect "]
[" ",null,null,"YEAR 1 BUDGETED EXPENDITURES",null,null,null,"YEAR 1 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 1 Actual Expense","Comments"]
["D.","Administrative and General Services:"]
[40,"Fiscal Services",null,null,null,null,{"$f":"SUM(D93:F93)","v":0},null,null,null,null,{"$f":"SUM(H93:K93)","v":0}]
[41,"Administrative Services",null,null,null,null,0,null,null,null,null,0]
[42,"Plant Operation and Maintenance",null,null,null,null,0,null,null,null,null,0]
[43,"Utilities",null,null,null,null,0,null,null,null,null,0]
[44,"Property Taxes",null,null,null,null,0,null,null,null,null,0]
[45,"Property Insurance",null,null,null,null,0,null,null,null,null,0]
[46,"Grounds",null,null,null,null,{"$f":"SUM(D99:F99)","v":0},null,null,null,null,{"$f":"SUM(H99:K99)","v":0}]
[47,"Security",null,null,null,null,0,null,null,null,null,0]
[48,"Laundry and Linen",null,null,null,null,0,null,null,null,null,0]
[49,"Housekeeping",null,null,null,null,0,null,null,null,null,0]
[50,"Patient Food Service",null,null,null,null,0,null,null,null,null,0]
[51,"Cafeteria",null,null,null,null,0,null,null,null,null,0]
[52,"Nursing Administration",null,null,null,null,0,null,null,null,null,0]
[53,"Activities Program",null,null,null,null,0,null,null,null,null,0]
[54,"Nonphysician Education",null,null,null,null,0,null,null,null,null,0]
[55,"Medical Education",null,null,null,null,0,null,null,null,null,0]
[56,"Medical Director's Office",null,null,null,null,0,null,null,null,null,0]
[57,"Housing",null,null,null,null,0,null,null,null,null,0]
[58,"Medical Records",null,null,null,null,0,null,null,null,null,0]
[59,"Utilization Review",null,null,null,null,0,null,null,null,null,0]
[60,"Social Service",null,null,null,null,0,null,null,null,null,0]
[61,"Transportation",null,null,null,null,0,null,null,null,null,0]
[62,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[63,"Total Indirect (Sum of Lines 40 - 62) ",{"$f":"SUM(C93:C115)","v":0},{"$f":"SUM(D93:D115)","v":0},{"$f":"SUM(E93:E115)","v":0},{"$f":"SUM(F93:F115)","v":0},{"$f":"SUM(G93:G115)","v":0},{"$f":"SUM(H93:H115)","v":0},0,0,0,0]
[]
[64,"Grand Total (Lines 39 + 63)",{"$f":"C86+C116","v":0},{"$f":"D86+D116","v":0},{"$f":"E86+E116","v":0},{"$f":"F86+F116","v":0},{"$f":"G86+G116","v":0},{"$f":"H86+H116","v":0},0,0,0,0]
[]
[65,"Provider In-kind Contributions",null,null,null,null,null,"Provider In-kind Contributions"]
[66,"Incremental Revenue To Offset (projected)",null,null,null,null,null,"Incremental Revenue To Offset (projected)"]
[]
[67,"Total VAP/Safety Net Funding Requested",null,null,null,null,{"$f":"G118-G120-G121","v":0},"Total VAP/Safety Net Funding",null,null,null,{"$f":"L118-L120-L121","v":0}]

{"sheet":"B - Year 2","index":5,"n_rows":121,"n_cols":13,"rows_kept":121,"cut":false,"hidden":false,"merged":[[13,0,13,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[4,0,5,12],[6,0,6,12],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[14,0,14,12],[15,0,15,12],[16,0,16,1],[16,2,16,12],[17,0,17,1],[17,2,17,12],[27,0,27,12],[18,0,18,1],[18,2,18,12],[19,0,19,1],[19,2,19,12],[20,0,20,12],[21,0,21,12],[22,0,22,12],[23,0,23,12],[24,0,24,12],[25,0,25,12],[26,0,26,12],[84,0,84,12],[28,0,28,12],[29,2,29,3],[29,6,29,8],[29,9,29,10],[30,0,30,12],[31,3,31,6],[31,7,31,11],[59,0,59,12],[60,0,60,12],[61,0,61,12],[62,3,62,6],[62,7,62,11],[119,7,119,10],[120,7,120,10],[85,0,85,12],[86,0,86,12],[87,3,87,6],[87,7,87,11],[117,7,117,10],[118,7,118,10]]}
["Vital Access Provider (VAP) / Safety Net Funding"]
["Medicaid Rate Adjustment"]
["Year 2 Expenditure Plan (VAP ONLY)"]
[]
[]
[]
["Instructions for Expenditure Plan :"]
[]
["1) This schedule details budgeted and actual operating expenses directly related to funding requested for your VAP/Safety Net Project.  Do not include any capital costs in the Expenditure Plans. For a definition of capital vs. operating costs, please see the Definitions tab. "]
[]
["2)Date Submitted will auto fill from \"B - Year 1\" tab."]
[]
["3)The Begin Date of the First Quarter for Year 2 will auto fill from \"B - Year 1\" tab"]
[]
["4) Please indicate the Budgeted Expenditures and Actual Expenditures (if project has begun), rounded to whole numbers, and Comments for the following categories for all lines as applicable:  "]
[]
["Full time equivalents (FTEs) -",null,"total annual paid hours (including budgeted vacation, sick leave & overtime expectations) for the employee(s) divided by the number of hours in a standard work week, then divide by 52, expressed to one decimal point (e.g., 1.5)"]
["Salaries & Wages - ",null,"amounts paid to employees as compensation for their service."]
["Employee Benefits - ",null,"payroll related costs such as FICA, SUI, group health insurance, pensions, etc. to be paid to or on behalf of employees."]
["Other Than Personal Service (OTPS) Costs - ",null,"Project costs not related to salaries and wages (e.g., office supplies, fees)."]
[]
["Note: Totals and sub-totals will auto-calculate; please only enter data in the white cells"]
[]
["4) Enter amounts (if applicable) as a positive number: Provider In-Kind Contributions (Line 65) and Incremental Revenue To Offset (Line 66)."]
[]
["5) Please see 'Definitions' tab for detailed definitions/descriptions of all lines."]
[]
["6) Do not add lines to this schedule. If needed for clarity, please use the 'Note Pad' tab to provide additional details to specific costs reported below. "]
[]
[null,"Date Submitted:",{"$f":"IF('B - Year 1'!C32=\"\",\"\",'B - Year 1'!C32)","v":""},null,null,null,"Begin Date of First Quarter",null,null,{"$f":"IF('B - Year 1'!J32=\"\",\"\",(EDATE('B - Year 1'!J32,12)))","v":""}]
["Operating Expenses-Direct"]
[null,null,null,"YEAR 2 BUDGETED EXPENDITURES",null,null,null,"YEAR 2 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 2 Actual Expense","Comments"]
[" "," "]
["A.","Inpatient Services:",null,null,null,null," "]
[1,"Physicians",null,null,null,null,{"$f":"SUM(D36:F36)","v":0},null,null,null,null,{"$f":"SUM(H36:K36)","v":0}]
[2,"Nursing:"]
[3,"         Administrator",null,null,null,null,{"$f":"SUM(D38:F38)","v":0},null,null,null,null,{"$f":"SUM(H38:K38)","v":0}]
[4,"         Nurse Practitioner",null,null,null,null,0,null,null,null,null,0]
[5,"         RN",null,null,null,null,0,null,null,null,null,0]
[6,"         LPN",null,null,null,null,0,null,null,null,null,0]
[7,"Administration/Clerical",null,null,null,null,0,null,null,null,null,0]
[8,"Technicians",null,null,null,null,0,null,null,null,null,0]
[9,"Aides",null,null,null,null,0,null,null,null,null,0]
[10,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[11,"Total Inpatient",{"$f":"SUM(C36:C45)","v":0},{"$f":"SUM(D36:D45)","v":0},{"$f":"SUM(E36:E45)","v":0},{"$f":"SUM(F36:F45)","v":0},{"$f":"SUM(G36:G45)","v":0},{"$f":"SUM(H36:H45)","v":0},0,0,0,{"$f":"SUM(L36:L45)","v":0}]
[null,null,null,null,null,null," "]
["B.","Outpatient Services:"]
[12,"Physicians",null,null,null,null,{"$f":"SUM(D49:F49)","v":0},null,null,null,null,{"$f":"SUM(H49:K49)","v":0}]
[13,"Nursing:"]
[14,"         Administrator",null,null,null,null,{"$f":"SUM(D51:F51)","v":0},null,null,null,null,{"$f":"SUM(H51:K51)","v":0}]
[15,"         Nurse Practitioner",null,null,null,null,0,null,null,null,null,0]
[16,"         RN",null,null,null,null,0,null,null,null,null,0]
[17,"         LPN",null,null,null,null,0,null,null,null,null,0]
[18,"Administration/Clerical",null,null,null,null,0,null,null,null,null,0]
[19,"Technicians",null,null,null,null,0,null,null,null,null,0]
[20,"Aides",null,null,null,null,0,null,null,null,null,0]
[21,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[22,"Total Outpatient",{"$f":"SUM(C49:C58)","v":0},{"$f":"SUM(D49:D58)","v":0},{"$f":"SUM(E49:E58)","v":0},{"$f":"SUM(F49:F58)","v":0},{"$f":"SUM(G49:G58)","v":0},{"$f":"SUM(H49:H58)","v":0},0,0,0,0]
[]
[" "]
["Operating Expenses-Direct"]
[null,null,null,"YEAR 2 BUDGETED EXPENDITURES",null,null,null,"YEAR 2 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 2 Actual Expense","Comments"]
[]
["C.","Ancillary Services:"]
[23,"Laboratory Services",null,null,null,null,{"$f":"SUM(D67:F67)","v":0},null,null,null,null,{"$f":"SUM(H67:K67)","v":0}]
[24,"Electrocardiology",null,null,null,null,{"$f":"SUM(D68:F68)","v":0},null,null,null,null,0]
[25,"Electroencephology",null,null,null,null,0,null,null,null,null,0]
[26,"Radiology",null,null,null,null,0,null,null,null,null,0]
[27,"Inhalation Therapy",null,null,null,null,0,null,null,null,null,0]
[28,"Podiatry",null,null,null,null,0,null,null,null,null,0]
[29,"Dental",null,null,null,null,0,null,null,null,null,0]
[30,"Psychiatric",null,null,null,null,0,null,null,null,null,0]
[31,"Therapy-Physical",null,null,null,null,0,null,null,null,null,0]
[32,"Therapy-Occupational",null,null,null,null,0,null,null,null,null,0]
[33,"Therapy-Speech Language Pathology",null,null,null,null,0,null,null,null,null,0]
[34,"Pharmaceutical Services",null,null,null,null,0,null,null,null,null,0]
[35,"Central Service Supply",null,null,null,null,0,null,null,null,null,0]
[36,"Medical Staff Services",null,null,null,null,0,null,null,null,null,0]
[37,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[38,"Total Ancillary",{"$f":"SUM(C67:C81)","v":0},{"$f":"SUM(D67:D81)","v":0},{"$f":"SUM(E67:E81)","v":0},{"$f":"SUM(F67:F81)","v":0},{"$f":"SUM(G67:G81)","v":0},{"$f":"SUM(H67:H81)","v":0},0,0,0,0]
[]
[39,"Total Direct (Lines 11 + 22 + 38)",{"$f":"C46+C59+C82","v":0},{"$f":"D46+D59+D82","v":0},{"$f":"E46+E59+E82","v":0},{"$f":"F46+F59+F82","v":0},{"$f":"G46+G59+G82","v":0},{"$f":"H46+H59+H82","v":0},0,0,0,0]
[]
[" "]
["Operating Expenses-Indirect "]
[" ",null,null,"YEAR 2 BUDGETED EXPENDITURES",null,null,null,"YEAR 2 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 2 Actual Expense","Comments"]
["D.","Administrative and General Services:"]
[40,"Fiscal Services",null,null,null,null,{"$f":"SUM(D91:F91)","v":0},null,null,null,null,{"$f":"SUM(H91:K91)","v":0}]
[41,"Administrative Services",null,null,null,null,0,null,null,null,null,0]
[42,"Plant Operation and Maintenance",null,null,null,null,0,null,null,null,null,0]
[43,"Utilities",null,null,null,null,0,null,null,null,null,0]
[44,"Property Taxes",null,null,null,null,0,null,null,null,null,0]
[45,"Property Insurance",null,null,null,null,0,null,null,null,null,0]
[46,"Grounds",null,null,null,null,{"$f":"SUM(D97:F97)","v":0},null,null,null,null,{"$f":"SUM(H97:K97)","v":0}]
[47,"Security",null,null,null,null,0,null,null,null,null,0]
[48,"Laundry and Linen",null,null,null,null,0,null,null,null,null,0]
[49,"Housekeeping",null,null,null,null,0,null,null,null,null,0]
[50,"Patient Food Service",null,null,null,null,0,null,null,null,null,0]
[51,"Cafeteria",null,null,null,null,0,null,null,null,null,0]
[52,"Nursing Administration",null,null,null,null,0,null,null,null,null,0]
[53,"Activities Program",null,null,null,null,0,null,null,null,null,0]
[54,"Nonphysician Education",null,null,null,null,0,null,null,null,null,0]
[55,"Medical Education",null,null,null,null,0,null,null,null,null,0]
[56,"Medical Director's Office",null,null,null,null,0,null,null,null,null,0]
[57,"Housing",null,null,null,null,0,null,null,null,null,0]
[58,"Medical Records",null,null,null,null,0,null,null,null,null,0]
[59,"Utilization Review",null,null,null,null,0,null,null,null,null,0]
[60,"Social Service",null,null,null,null,0,null,null,null,null,0]
[61,"Transportation",null,null,null,null,0,null,null,null,null,0]
[62,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[63,"Total Indirect (Sum of Lines 40 - 62) ",{"$f":"SUM(C91:C113)","v":0},{"$f":"SUM(D91:D113)","v":0},{"$f":"SUM(E91:E113)","v":0},{"$f":"SUM(F91:F113)","v":0},{"$f":"SUM(G91:G113)","v":0},{"$f":"SUM(H91:H113)","v":0},0,0,0,0]
[]
[64,"Grand Total (Lines 39 + 63)",{"$f":"C84+C114","v":0},{"$f":"D84+D114","v":0},{"$f":"E84+E114","v":0},{"$f":"F84+F114","v":0},{"$f":"G84+G114","v":0},{"$f":"H84+H114","v":0},0,0,0,0]
[]
[65,"Provider In-kind Contributions",null,null,null,null,null,"Provider In-kind Contributions"]
[66,"Incremental Revenue To Offset (projected)",null,null,null,null,null,"Incremental Revenue To Offset (projected)"]
[]
[67,"Total VAP/Safety Net Funding Requested",null,null,null,null,{"$f":"G116-G118-G119","v":0},"Total VAP/Safety Net Funding",null,null,null,{"$f":"L116-L118-L119","v":0}]

{"sheet":"B - Year 3","index":6,"n_rows":121,"n_cols":13,"rows_kept":121,"cut":false,"hidden":false,"merged":[[13,0,13,12],[0,0,0,12],[1,0,1,12],[2,0,2,12],[4,0,5,12],[6,0,6,12],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[14,0,14,12],[15,0,15,12],[16,0,16,1],[16,2,16,12],[17,0,17,1],[17,2,17,12],[27,0,27,12],[18,0,18,1],[18,2,18,12],[19,0,19,1],[19,2,19,12],[20,0,20,12],[21,0,21,12],[22,0,22,12],[23,0,23,12],[24,0,24,12],[25,0,25,12],[26,0,26,12],[84,0,84,12],[28,0,28,12],[29,2,29,3],[29,6,29,8],[29,9,29,10],[30,0,30,12],[31,3,31,6],[31,7,31,11],[59,0,59,12],[60,0,60,12],[61,0,61,12],[62,3,62,6],[62,7,62,11],[119,7,119,10],[120,7,120,10],[85,0,85,12],[86,0,86,12],[87,3,87,6],[87,7,87,11],[117,7,117,10],[118,7,118,10]]}
["Vital Access Provider (VAP) / Safety Net Funding"]
["Medicaid Rate Adjustment"]
["Year 3 Expenditure Plan (VAP ONLY)"]
[]
[]
[]
["Instructions for Expenditure Plan :"]
[]
["1) This schedule details budgeted and actual operating expenses directly related to funding requested for your VAP/Safety Net Project.  Do not include any capital costs in the Expenditure Plans. For a definition of capital vs. operating costs, please see the Definitions tab. "]
[]
["2)Date Submitted will auto fill from \"B - Year 1\" tab."]
[]
["3)The Begin Date of the First Quarter for Year 2 will auto fill from \"B - Year 1\" tab"]
[]
["4) Please indicate the Budgeted Expenditures and Actual Expenditures (if project has begun), rounded to whole numbers, and Comments for the following categories for all lines as applicable:  "]
[]
["Full time equivalents (FTEs) -",null,"total annual paid hours (including budgeted vacation, sick leave & overtime expectations) for the employee(s) divided by the number of hours in a standard work week, then divide by 52, expressed to one decimal point (e.g., 1.5)"]
["Salaries & Wages - ",null,"amounts paid to employees as compensation for their service."]
["Employee Benefits - ",null,"payroll related costs such as FICA, SUI, group health insurance, pensions, etc. to be paid to or on behalf of employees."]
["Other Than Personal Service (OTPS) Costs - ",null,"Project costs not related to salaries and wages (e.g., office supplies, fees)."]
[]
["Note: Totals and sub-totals will auto-calculate; please only enter data in the white cells"]
[]
["4) Enter amounts (if applicable) as a positive number: Provider In-Kind Contributions (Line 65) and Incremental Revenue To Offset (Line 66)."]
[]
["5) Please see 'Definitions' tab for detailed definitions/descriptions of all lines."]
[]
["6) Do not add lines to this schedule. If needed for clarity, please use the 'Note Pad' tab to provide additional details to specific costs reported below. "]
[]
[null,"Date Submitted:",{"$f":"IF('B - Year 1'!C32=\"\",\"\",'B - Year 1'!C32)","v":""},null,null,null,"Begin Date of Full Quarter",null,null,{"$f":"IF('B - Year 1'!J32=\"\",\"\",(EDATE('B - Year 1'!J32,24)))","v":""}]
["Operating Expenses-Direct"]
[null,null,null,"YEAR 3 BUDGETED EXPENDITURES",null,null,null,"YEAR 3 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 3 Actual Expense","Comments"]
[" "," "]
["A.","Inpatient Services:",null,null,null,null," "]
[1,"Physicians",null,null,null,null,{"$f":"SUM(D36:F36)","v":0},null,null,null,null,{"$f":"SUM(H36:K36)","v":0}]
[2,"Nursing:"]
[3,"         Administrator",null,null,null,null,{"$f":"SUM(D38:F38)","v":0},null,null,null,null,{"$f":"SUM(H38:K38)","v":0}]
[4,"         Nurse Practitioner",null,null,null,null,0,null,null,null,null,0]
[5,"         RN",null,null,null,null,0,null,null,null,null,0]
[6,"         LPN",null,null,null,null,0,null,null,null,null,0]
[7,"Administration/Clerical",null,null,null,null,0,null,null,null,null,0]
[8,"Technicians",null,null,null,null,0,null,null,null,null,0]
[9,"Aides",null,null,null,null,0,null,null,null,null,0]
[10,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[11,"Total Inpatient",{"$f":"SUM(C36:C45)","v":0},{"$f":"SUM(D36:D45)","v":0},{"$f":"SUM(E36:E45)","v":0},{"$f":"SUM(F36:F45)","v":0},{"$f":"SUM(G36:G45)","v":0},{"$f":"SUM(H36:H45)","v":0},0,0,0,{"$f":"SUM(L36:L45)","v":0}]
[null,null,null,null,null,null," "]
["B.","Outpatient Services:"]
[12,"Physicians",null,null,null,null,{"$f":"SUM(D49:F49)","v":0},null,null,null,null,{"$f":"SUM(H49:K49)","v":0}]
[13,"Nursing:"]
[14,"         Administrator",null,null,null,null,{"$f":"SUM(D51:F51)","v":0},null,null,null,null,{"$f":"SUM(H51:K51)","v":0}]
[15,"         Nurse Practitioner",null,null,null,null,0,null,null,null,null,0]
[16,"         RN",null,null,null,null,0,null,null,null,null,0]
[17,"         LPN",null,null,null,null,0,null,null,null,null,0]
[18,"Administration/Clerical",null,null,null,null,0,null,null,null,null,0]
[19,"Technicians",null,null,null,null,0,null,null,null,null,0]
[20,"Aides",null,null,null,null,0,null,null,null,null,0]
[21,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[22,"Total Outpatient",{"$f":"SUM(C49:C58)","v":0},{"$f":"SUM(D49:D58)","v":0},{"$f":"SUM(E49:E58)","v":0},{"$f":"SUM(F49:F58)","v":0},{"$f":"SUM(G49:G58)","v":0},{"$f":"SUM(H49:H58)","v":0},0,0,0,0]
[]
[" "]
["Operating Expenses-Direct"]
[null,null,null,"YEAR 3 BUDGETED EXPENDITURES",null,null,null,"YEAR 3 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 3 Actual Expense","Comments"]
[]
["C.","Ancillary Services:"]
[23,"Laboratory Services",null,null,null,null,{"$f":"SUM(D67:F67)","v":0},null,null,null,null,{"$f":"SUM(H67:K67)","v":0}]
[24,"Electrocardiology",null,null,null,null,{"$f":"SUM(D68:F68)","v":0},null,null,null,null,0]
[25,"Electroencephology",null,null,null,null,0,null,null,null,null,0]
[26,"Radiology",null,null,null,null,0,null,null,null,null,0]
[27,"Inhalation Therapy",null,null,null,null,0,null,null,null,null,0]
[28,"Podiatry",null,null,null,null,0,null,null,null,null,0]
[29,"Dental",null,null,null,null,0,null,null,null,null,0]
[30,"Psychiatric",null,null,null,null,0,null,null,null,null,0]
[31,"Therapy-Physical",null,null,null,null,0,null,null,null,null,0]
[32,"Therapy-Occupational",null,null,null,null,0,null,null,null,null,0]
[33,"Therapy-Speech Language Pathology",null,null,null,null,0,null,null,null,null,0]
[34,"Pharmaceutical Services",null,null,null,null,0,null,null,null,null,0]
[35,"Central Service Supply",null,null,null,null,0,null,null,null,null,0]
[36,"Medical Staff Services",null,null,null,null,0,null,null,null,null,0]
[37,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[38,"Total Ancillary",{"$f":"SUM(C67:C81)","v":0},{"$f":"SUM(D67:D81)","v":0},{"$f":"SUM(E67:E81)","v":0},{"$f":"SUM(F67:F81)","v":0},{"$f":"SUM(G67:G81)","v":0},{"$f":"SUM(H67:H81)","v":0},0,0,0,0]
[]
[39,"Total Direct (Lines 11 + 22 + 38)",{"$f":"C46+C59+C82","v":0},{"$f":"D46+D59+D82","v":0},{"$f":"E46+E59+E82","v":0},{"$f":"F46+F59+F82","v":0},{"$f":"G46+G59+G82","v":0},{"$f":"H46+H59+H82","v":0},0,0,0,0]
[]
[" "]
["Operating Expenses-Indirect "]
[" ",null,null,"YEAR 3 BUDGETED EXPENDITURES",null,null,null,"YEAR 3 ACTUAL EXPENDITURES"]
["Line No","Description","FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total YEAR 3 Actual Expense","Comments"]
["D.","Administrative and General Services:"]
[40,"Fiscal Services",null,null,null,null,{"$f":"SUM(D91:F91)","v":0},null,null,null,null,{"$f":"SUM(H91:K91)","v":0}]
[41,"Administrative Services",null,null,null,null,0,null,null,null,null,0]
[42,"Plant Operation and Maintenance",null,null,null,null,0,null,null,null,null,0]
[43,"Utilities",null,null,null,null,0,null,null,null,null,0]
[44,"Property Taxes",null,null,null,null,0,null,null,null,null,0]
[45,"Property Insurance",null,null,null,null,0,null,null,null,null,0]
[46,"Grounds",null,null,null,null,{"$f":"SUM(D97:F97)","v":0},null,null,null,null,{"$f":"SUM(H97:K97)","v":0}]
[47,"Security",null,null,null,null,0,null,null,null,null,0]
[48,"Laundry and Linen",null,null,null,null,0,null,null,null,null,0]
[49,"Housekeeping",null,null,null,null,0,null,null,null,null,0]
[50,"Patient Food Service",null,null,null,null,0,null,null,null,null,0]
[51,"Cafeteria",null,null,null,null,0,null,null,null,null,0]
[52,"Nursing Administration",null,null,null,null,0,null,null,null,null,0]
[53,"Activities Program",null,null,null,null,0,null,null,null,null,0]
[54,"Nonphysician Education",null,null,null,null,0,null,null,null,null,0]
[55,"Medical Education",null,null,null,null,0,null,null,null,null,0]
[56,"Medical Director's Office",null,null,null,null,0,null,null,null,null,0]
[57,"Housing",null,null,null,null,0,null,null,null,null,0]
[58,"Medical Records",null,null,null,null,0,null,null,null,null,0]
[59,"Utilization Review",null,null,null,null,0,null,null,null,null,0]
[60,"Social Service",null,null,null,null,0,null,null,null,null,0]
[61,"Transportation",null,null,null,null,0,null,null,null,null,0]
[62,"Other (specify in Note Pad section):",null,null,null,null,0,null,null,null,null,0]
[63,"Total Indirect (Sum of Lines 40 - 62) ",{"$f":"SUM(C91:C113)","v":0},{"$f":"SUM(D91:D113)","v":0},{"$f":"SUM(E91:E113)","v":0},{"$f":"SUM(F91:F113)","v":0},{"$f":"SUM(G91:G113)","v":0},{"$f":"SUM(H91:H113)","v":0},0,0,0,0]
[]
[64,"Grand Total (Lines 39 + 63)",{"$f":"C84+C114","v":0},{"$f":"D84+D114","v":0},{"$f":"E84+E114","v":0},{"$f":"F84+F114","v":0},{"$f":"G84+G114","v":0},{"$f":"H84+H114","v":0},0,0,0,0]
[]
[65,"Provider In-kind Contributions",null,null,null,null,null,"Provider In-kind Contributions"]
[66,"Incremental Revenue To Offset (projected)",null,null,null,null,null,"Incremental Revenue To Offset (projected)"]
[]
[67,"Total VAP/Safety Net Funding Requested",null,null,null,null,{"$f":"G116-G118-G119","v":0},"Total VAP/Safety Net Funding",null,null,null,{"$f":"L116-L118-L119","v":0}]

{"sheet":"B - Note Pad","index":7,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[[37,0,45,1],[36,0,36,1],[0,0,0,1],[2,0,2,1],[3,0,3,1],[6,0,6,1],[27,0,27,1],[14,0,14,1],[7,0,7,1],[77,0,77,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[72,0,72,1],[73,0,73,1],[74,0,74,1],[68,0,68,1],[55,0,55,1],[8,0,13,1],[75,0,75,1],[76,0,76,1],[15,0,26,1],[28,0,35,1],[67,0,67,1],[64,0,64,1],[62,0,62,1],[63,0,63,1],[65,0,65,1],[66,0,66,1],[47,0,54,1],[56,0,61,1],[46,0,46,1]]}
["Instructions:\nUnder \"Additional Details for Sustainability\", please provide a short description of how your plan will become sustainable after VAP funding has ended (required). \n\nUnder \"Additional Details for Capital Financing\", please provide a short description of how capital funds will be financed (if your project is related to outside capital funds).\n\nUnder \"Additional Details for Year _ Budget\", please provide additional information and/or details to specific cost items included in your budget (if needed).  Specify by applicable budget year for the given cost item being detailed.  Add lines as needed."]
[]
["Note Pad Section"]
[]
["Date Submitted:",{"$f":"IF('B - Year 1'!C32=\"\",\"\",('B - Year 1'!C32))","v":""}]
["First Quarter:",{"$f":"IF('B - Year 1'!J32=\"\",\"\",('B - Year 1'!J32))","v":""}]
[]
["General Notes & Other Comments:"]
[]
[]
[]
[]
[]
[]
["Additional Details for Sustainability:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Details for Capital Financing:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Details for Year 1 Budget:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Details for Year 2 Budget:"]
[]
[]
[]
[]
[]
[]
[]
[]
["Additional Details for Year 3 Budget:"]

{"sheet":"B - Definitions","index":8,"n_rows":70,"n_cols":3,"rows_kept":70,"cut":false,"hidden":false,"merged":[[0,0,0,2],[1,0,1,2]]}
["Vital Access Provider (VAP) Funding"]
["Expenditure Plan Definitions"]
["Line No","Description","Definition"]
[null,"Operating","VAP funding can only be applied to operating costs.  \n\nOperating costs include both overhead costs and administrative costs. This includes, but is not limited to: utilities, wages, advertising, raw materials, office supplies and consumables.  "]
[null,"Capital","Capital costs should not be included in the expenditure plans or timelines. \n\nCapital costs are fixed, one-time expenses incurred on the purchase of land, buildings, construction, rent and capital debt.\nIf your project is dependent on outside capital funding, please include these details on \"B - Note Pad\". "]
["Operating Expenses-Direct"]
["A.","Inpatient Services:"]
[1,"Physicians","A doctor of medicine or of osteopathy who is fully licensed to practice medicine."]
[2,"Nursing:"]
[3,"Administrator","This functional reporting center must contain all the expenses associated with the overall administration and supervision of all nursing services, including all nursing in-service training, scheduling and transferring of nurses between services and units, nursing staff supervision, evaluation and discipline. It includes the work of the director, assistants and/or associates, secretaries, clerks, and all nursing personnel who are responsible for conducting in-service education of nursing personnel, and the following specific job titles: RN Supervisor (supervising two or more units and/or areas), Health Services Supervisor, Director of Nursing Services, and Assistant Director of Nursing Services.  Additional activities include but are not limited to the following: recommendation of appointments to the nursing staff; definition and execution of the philosophy, objectives, policies and standards for nursing care of patients; participation in community education health programs; participation in patient care review committees; inspection of patient areas to verify that patient needs are met; and coordination of all nursing activities and functions with other residential health care facility functions."]
[4,"Nurse Practitioner","\"Nurse practitioner\" means a person who is licensed and currently registered as a registered professional nurse in New York State and who is certified as a nurse practitioner by the Department of Education."]
[5,"RN","Those persons licensed to practice as a registered nurse in the State where the facility is located. Includes geriatric nurse practitioners and clinical nurse specialists who primarily perform nursing, not physician-delegated tasks. Do not include Registered Nurses elsewhere."]
[6,"LPN","Those persons licensed to practice as a licensed practical/vocational nurse in the State where the facility is located.  Do not include those hours of LPN/LVNs reported elsewhere."]
[7,"Administration/Clerical","Staff concerned with or relating to work provided in an office, especially routine tasks."]
[8,"Technicians","A worker in a field of technology who is proficient in the relevant skills and techniques, and possesses a practical understanding of the theoretical principles of the technology. Experienced technicians in a specific tool domain typically have intermediate understanding of theory and expert proficiency in technique."]
[9,"Aides","Individuals who have completed a State approved training and competency evaluation program, or competency evaluation program approved by the State, or have been determined competent and who are providing nursing-related services to residents.  Do not include volunteers."]
["B.","Outpatient Services:"]
[12,"Physicians","A doctor of medicine or of osteopathy who is fully licensed to practice medicine."]
[13,"Nursing:"]
[14," Administrator","This functional reporting center must contain all the expenses associated with the overall administration and supervision of all nursing services, including all nursing in-service training, scheduling and transferring of nurses between services and units, nursing staff supervision, evaluation and discipline. It includes the work of the director, assistants and/or associates, secretaries, clerks, and all nursing personnel who are responsible for conducting in-service education of nursing personnel, and the following specific job titles: RN Supervisor (supervising two or more units and/or areas), Health Services Supervisor, Director of Nursing Services, and Assistant Director of Nursing Services.  Additional activities include but are not limited to the following: recommendation of appointments to the nursing staff; definition and execution of the philosophy, objectives, policies and standards for nursing care of patients; participation in community education health programs; participation in patient care review committees; inspection of patient areas to verify that patient needs are met; and coordination of all nursing activities and functions with other residential health care facility functions."]
[15,"Nurse Practitioner","\"Nurse practitioner\" means a person who is licensed and currently registered as a registered professional nurse in New York State and who is certified as a nurse practitioner by the Department of Education."]
[16," RN","Those persons licensed to practice as a registered nurse in the State where the facility is located. Includes geriatric nurse practitioners and clinical nurse specialists who primarily perform nursing, not physician-delegated tasks. Do not include Registered Nurses elsewhere."]
[17,"LPN","Those persons licensed to practice as a licensed practical/vocational nurse in the State where the facility is located.  Do not include those hours of LPN/LVNs reported elsewhere."]
[18,"Administration/Clerical","Staff concerned with or relating to work provided in an office, especially routine tasks."]
[19,"Technicians","A worker in a field of technology who is proficient in the relevant skills and techniques, and possesses a practical understanding of the theoretical principles of the technology. Experienced technicians in a specific tool domain typically have intermediate understanding of theory and expert proficiency in technique."]
[20,"Aides","Individuals who have completed a State approved training and competency evaluation program, or competency evaluation program approved by the State, or have been determined competent and who are providing nursing-related services to residents.  Do not include volunteers."]
[]
["Operating Expenses-Direct"]
["C.","Ancillary Services:"]
[23,"Laboratory Services","This functional reporting center must contain all the expenses associated with performance of diagnostic and routine laboratory tests on tissues and cultures necessary for the diagnosis and treatment of residential health care facility patients. This functional reporting center should also include maintenance of a blood bank within the residential health care facility. Additional activities include but are not limited to the following: transportation of specimens from nursing floors; care of laboratory equipment; preparation of samples for testing; drawing or otherwise procuring, processing, storing and issuing whole blood and blood derivatives."]
[24,"Electrocardiology","This functional reporting center must contain all the expenses associated with the operation of specialized equipment to record electromotive variations in actions of the heart muscle on an electrocardiograph for diagnosis of heart ailments. Additional activities include but are not limited to the following: wheeling portable equipment to patients' bedsides; explaining test procedures to patients; operating electrocardiograph equipment; inspecting, testing and maintaining special equipment; and attaching and removing electrodes to and from patients."]
[25,"Electroencephology","This functional reporting center must contain all the expenses associated with the operation of specialized equipment to record electromotive variations in brain waves on an electroencephalograph for diagnosis. Additional activities include but are not limited to the following: wheeling portable equipment to patients' bedside; explaining test procedures to patient; operating electroencephalograph equipment; inspecting, testing and maintaining special equipment."]
[26,"Radiology","This functional reporting center must contain all the expenses associated with the provision of diagnostic radiology services under the direction of a radiologist as required for the examination and care of patients. Additional activities include but are not limited to the following: taking and processing fluorographs and radiographs; examining and interpreting results; consulting with patients and attending physicians; disposing of radioactive waste; and storing and retrieving film and radioactive materials."]
[27,"Inhalation Therapy","This functional reporting center must contain all the expenses associated with the administration of oxygen and certain potent drugs through inhalation or positive pressure and other forms of rehabilitative therapy as prescribed by physicians. This function is performed by specially trained personnel who initiate, monitor and evaluate patient performance, cooperation and ability during testing procedures. Additional activities include but are not limited to the following: assisting physician in performance of emergency care; maintaining open airways, breathing and blood circulation; maintaining aseptic conditions; transporting equipment to patients' bedsides; observing and instructing patients during therapy; visiting all assigned patients to ensure that physicians' orders are being carried out; inspecting and testing equipment; enforcing safety rules; and calculating test results."]
[28,"Podiatry","This functional reporting center must contain all the expenses associated with the provision of specialized diagnostic and therapeutic procedures in treatment of a patient by a podiatrist and/or podiatry staff. Additional activities include but are not limited to the following: examination of patients; consulting with patients and attending physicians."]
[29,"Dental","This functional reporting center must contain all the expenses associated with the provision of preventive and emergency dental care under the supervision of a dentist or other licensed dental personnel. Additional activities include but are not limited to the following: examination and treatment of patients; consulting with patients and attending physician."]
[30,"Psychiatric","This functional reporting center must contain all the expenses associated with providing specialized diagnostic and therapeutic procedures by a licensed psychiatrist or psychologist. Additional activities include but are not limited to the following: consultation with patients, patient relatives and attending physician; establishing goal-directed relationship with patient; participating in group and milieu therapy."]
[31,"Therapy - Physical","This functional reporting center must contain all the expenses associated with employing therapeutic exercises and massage and utilizing effective properties of heat, light, cold water and electricity for diagnosis and rehabilitation of patients with neuromuscular, orthopedic and other impairments. Such services are provided in a coordinated and integrated program under the direction and prescription of a physician or a registered physical therapist. Additional activities include but are not limited to the following: the provision of clinical and consultative services; the direction of patients in the use, function and care of braces, artificial limbs and other devices; prescribing therapeutic exercises; counseling patients and their relatives; organizing and conducting medically prescribed physical therapy programs; applying diagnostic muscle tests; administering whirlpool and compact baths; changing linen on physical therapy department beds and treatment tables; assisting patients in changing clothes and other personal needs and participating in discharge coordination as required by the code."]
[32,"Therapy - Occupational","This functional reporting center must contain all the expenses associated with teaching manual skills and independence in personal care to stimulate mental and emotional activity on the part of patients. This would include the utilization of modalities and tests of occupational therapy and rehabilitative nursing in a coordinated and integrated program of services under the direction of a physician. This would consist of instructing patients in prescribed academic subjects to prevent mental deconditioning, improving patients' mental and physical conditions and aiding in the attainment of knowledge and skills that will further patients' progress toward vocational objectives. Additional activities include but are not limited to the following: evaluation by conducting diagnostic tests; consultations; prescriptions and carrying out prescriptions; assisting patients with personal needs; counseling patients' relatives and employees on both individual case and group bases; administering accreditation and other academic tests; instructing patients in technical aspects of work participation and in discharge coordination as required by the code."]
[33,"Therapy - Speech Language Pathology","This functional reporting center must contain all expenses associated with the utilization of modalities and tests of speech and hearing therapy and rehabilitation nursing in a coordinated and integrated program of services under the direction and prescription of a physician. Additional activities include but are not limited to the following: evaluation by conducting diagnostic tests; consultations, prescriptions, and carrying out prescriptions; assisting patients with personal needs; and participation in discharge coordination as required by code."]
[34,"Pharmaceutical Services","This functional reporting center must contain all the expenses associated with the procurement, preservation, storage, compounding, manufacturing, packaging, controlling, assaying and dispensing of medications (including intravenous solutions) for in-and out-patients carried out under the jurisdiction of a licensed pharmacist. This functional reporting center should include the cost of drugs charged to patients and the cost of non-billable floor stock distributed to the various departments. Additional activities include but are not limited to the following: developing and maintaining formularies established by the medical staff; consulting and advising medical staff and nursing staff on drug therapy overdoses; adding drugs to I.V. solutions; analyzing incompatibility of drug combinations; and stocking of floor drugs and dispensing machines."]
[35,"Central Service Supply","This functional reporting center must contain all the expenses associated with the preparation and issuance of medical and surgical supplies and equipment to patients and other functional reporting centers, and the cost of medical/surgical supplies and equipment charged to patients and the cost of non-billable medical supplies distributed to the various floors as stock. Additional activities include but are not limited to the following: requisitioning and issuing appropriate supply items required for patient care; preparing sterile irrigating solutions; collecting, assembling, cleaning, sterilizing and redistributing reusable items; and cleaning, assembling, maintaining and issuing of portable apparatus."]
[36,"Medical Staff Services","This functional reporting center must contain all the expenses associated with services to patients provided by physicians who are not assigned to specific professional service departments. All remuneration for physicians' services should be reported under this functional classification for payment to chiefs of service, house officers, and all other physicians not assigned to a specific professional service department. "]
[]
["Operating Expenses-Indirect "]
["D.","Administrative and General"]
[40,"Fiscal Services","This functional reporting center must contain all expenses related to managing the residential health care facility's fiscal affairs, including general ledger accounting, budgeting, accounts payable, plant asset records, payroll, inventory accounting and data processing. Additional activities include but are not restricted to the following: entering abstracted data on insurance forms; accounting for sales to other institutions; patient accounting, including the processing of patient charges, preparing claims for patient-related billings, receiving and processing payments from or on behalf of patients for services rendered, extending credit, collecting outstanding accounts, and recording and accounting for patient trust funds."]
[41,"Administrative Services","This functional reporting center must contain all the expenses associated with the overall management of the facility, including the office of the administrative director, management fees, public relations, auxiliaries or volunteer groups, messenger services, purchasing, governing board, information and paging activities, maintaining all insurance policies (except employee benefit insurance), licenses and taxes, and working capital interest. Additional activities include but are not limited to the following: provision of staff support to the board; charting the flow of patients through residential health care facility services; projecting daily census for budgets; pickup and delivery of mail within the residential health care facility; printing and duplication of forms and reports; operation of the communications system within the facility, including the telephone switchboard and related telephone services; receipt and processing of requisitions; monitoring perpetual supply items; obtaining quotes from selected vendors and monitoring receipt of supplies; receiving, storing and delivering materials, equipment and supplies to various departments; recruitment, employee selection, salary and wage administration; fringe benefit program administration; procurement of temporary help; scheduling and recordkeeping relative to employee visits and pre-employment and post-illness employee physicals."]
[42,"Plant Operation and Maintenance","This functional reporting center must contain all the expenses associated with the maintenance, repair and service of buildings, fixed and movable equipment, and operating and utility systems, including minor renovation of buildings (including services of the building trades, i.e., carpentry, plumbing, electricity, painting, masonry, plastering and mechanical repairs); maintenance and repair of the following systems: domestic water supply, sewage treatment facility, domestic hot water storage and distribution; bulk oxygen distribution from entry into the buildings; biomedical equipment inspection, testing, maintenance and repair; electrical distribution; operation and maintenance of the boiler plant to include steam distribution piping up to and including PRV stations and the condensate return system from the receiving tanks to the boiler plant; emergency power system; air conditioning systems to include air handling equipment; incinerators and waste removal equipment; elevators and dumbwaiters. This center should include all similar services performed under contract. Additional activities include but are not limited to the following: technical assistance on equipment purchases and installations; coordinating construction; establishing priorities for repairs and utility systems and projects; service and maintenance of water and sewage treatment facilities; and maintenance of utilities such as heat, light, water, air conditioning and air treatment."]
[43,"Utilities","Amounts paid for heat, phones etc."]
[44,"Property Taxes","Amounts for real property tax."]
[45,"Property Insurance","Amounts paid for insurance"]
[46,"Grounds","This functional reporting center must contain all the expenses associated with the maintenance of grounds of the facility, including landscaped and paved areas, streets on the property, sidewalks, fenced areas and fencing, external recreation areas and parking facilities (e.g., lawn care, repairs and snow removal)."]
[47,"Security","This functional reporting center must contain all the expenses associated with maintaining the safety and well-being of residential health care facility patients, personnel and visitors, and protecting the facility by patrolling and guarding designated areas."]
[48,"Laundry and Linen","This functional reporting center must contain all the expenses associated with picking up, sorting, issuing, distributing, mending, washing, and processing in-service linens, including uniforms and special linens. Also included in this reporting center are linen purchases, purchased laundry services and the cost of disposable linen."]
[49,"Housekeeping","This functional reporting center must contain all the expenses associated with care and cleaning of the interior physical plant, including care of floors (washing, waxing and stripping), walls, ceilings, partitions, windows (inside and outside), furniture stripping, disinfecting beds, fixtures (excluding equipment), and furnishings, and emptying of room trash containers. Routine housekeeping services performed by dietary personnel in dietary (kitchen) should be reported in the Patient Food Service functional center. This includes the costs of purchasing similar services from outside organizations. Additional activities include but are not limited to the following: providing pest and rodent control; gathering bacteriological surface samplings and carrying out pertinent infection control procedures; providing technical assistance in selection of furniture and furnishings; moving and relocating furniture; and arranging for refinishing, repairing and upholstering or replacement of furniture."]
[50,"Patient Food Service","This functional reporting center must contain all the expenses associated with the procurement, storage, processing and delivery of food and nourishments to the floors and dining facilities in compliance with public health regulations and physicians' orders. This would include the material costs relative to tube feeding of a high protein diet. Additional activities include but are not limited to the following: teaching patients and their families about nutrition and modified diet requirements; determining patient food preferences in terms of type of food and method of preparation; preparing selective menus for various specific diet requirements; preparing or recommending a diet manual, approved by the medical staff, for use by physicians and nurses; and delivering and collecting food trays to the floors and dining facilities for meals and nourishments."]
[51,"Cafeteria","This functional reporting center must contain all the expenses associated with procurement, storage, processing and delivery of food and nourishment to personnel and visitors in compliance with public health regulations, including vending machine operation. Additional activities include but are not limited to the following: preparation of food, food service, maintenance of vending machines, and operation of the cafeteria to serve employees and visitors. Note that when distributing shared (common) kitchen costs between this center and the Patient Food Service functional center, the reclassification criteria do not apply."]
[52,"Nursing Administration","This functional reporting center must contain all the expenses associated with the overall administration and supervision of all nursing services, including all nursing in-service training, scheduling and transferring of nurses between services and units, nursing staff supervision, evaluation and discipline. It includes the work of the director, assistants and/or associates, secretaries, clerks, and all nursing personnel who are responsible for conducting in-service education of nursing personnel, and the following specific job titles: RN Supervisor (supervising two or more units and/or areas), Health Services Supervisor, Director of Nursing Services, and Assistant Director of Nursing Services.  Additional activities include but are not limited to the following: recommendation of appointments to the nursing staff; definition and execution of the philosophy, objectives, policies and standards for nursing care of patients; participation in community education health programs; participation in patient care review committees; inspection of patient areas to verify that patient needs are met; and coordination of all nursing activities and functions with other residential health care facility functions."]
[53,"Activities Program","This functional reporting center must contain all the expenses associated with providing recreational and leisure-time facilities, activities and services to patients both at the facility and on special group activities including trips for recreational purposes, excluding transportation costs. This department is supervised by personnel trained for administration of an activities program. Additional activities encompassed by this functional reporting center include but are not limited to the following: coordinating and scheduling activity programs; arranging for special group activities and trips; arranging for transportation to activities; supervising activity programs; participating in discharge coordination as required by code."]
[54,"Nonphysician Education","This functional reporting center must contain all the direct expenses associated with State-approved schools for educating professional people other than physicians. Additional activities include but are not limited to the following: student assistance; selecting qualified students; providing education in theory and practice conforming to approved standards; maintaining an education library and student personnel records; counseling students regarding their professional, personal and educational problems; selecting faculty personnel; assigning and supervising students in on-the-job training; and administering aptitude tests and other tests for counseling and selection purposes."]
[55,"Medical Education","This functional reporting center must contain all expenses associated with organized medical education programs approved by the American Medical Association that provide medical clinical education to interns and residents. Additional activities include but are not limited to the following: providing services of interns and residents; selecting qualified students; providing education in theory and practice conforming to approved standards; maintaining student personnel records; counseling students regarding professional, personal and educational problems."]
[56,"Medical Director's Office","This functional reporting center must contain all the expenses, both professional and clerical, associated with the medical director's office and providing overall medical administration at the facility. Additional activities include but are not limited to the following: providing administrative guidance to physicians at the facility; monitoring the quality of physician care; conducting medical staff meetings; providing clerical assistance to physicians. Note that the time spent by the medical director on direct patient care, as well as in this function, must be specifically assigned to the appropriate reporting center and is not subject to the reclassification criteria."]
[57,"Housing","This functional reporting center must contain all the expenses associated with the provision of living quarters to residential health care facility employees."]
[58,"Medical Records","This functional reporting center must contain all the expenses associated with maintaining a record system for the use, transcription, retrieval, storage and disposal of patient medical records and production of indexes, abstracts and statistics for residential health care facility management and medical staff use. Additional activities include but are not limited to: operating microfilm equipment (or equivalent)."]
[59,"Utilization Review","This functional reporting center must contain all the expenses associated with providing utilization review. Reference: section 416.9 of this Subchapter. Additional activities include but are not limited to the following: conducting ongoing evaluation of the quality of care provided. This includes periodic review of utilization of bed facilities and of the diagnostic, nursing and therapeutic resources of the residential health care facility with respect to availability of these resources to all patients according to their medical needs, and recognition of the medical practitioner's responsibility for the costs of health care. This review should cover necessity of admission (including concurrent review of admission), length of stay, level of care, quality of care, utilization of ancillary services, professional services furnished, and availability and alternative use of facilities and services. The review committee should include two or more physicians with participation of other professional personnel, or a group outside the facility which is similarly composed and which is established by the local medical society and some or all of the residential health care facilities in the locality, or a group established and organized in a manner approved by the Department of Health that is capable of performing such function."]
[60,"Social Service","This functional reporting center must contain all the expenses associated with obtaining, analyzing and interpreting social and economic information to assist in diagnosis, treatment and rehabilitation of patients, including counseling of staff and patients in case units and group units, participating in the development of community social and health education programs, coordinating the admission and transfer of patients, coordinating discharges, and providing religious counseling and services. Additional activities include but are not limited to the following: filling out admission forms; scheduling admission times; accompanying patients to rooms or service areas after admission and arrangement of admission details; interviewing patients and relatives in order to obtain social history relevant to medical problems and planning; interpreting problems of social situations as they relate to the medical condition and/or hospitalization of the patient; arranging for post-discharge care of chronically ill patients; and collecting and revising information on community health and welfare resources."]
[61,"Transportation","This functional reporting center must contain all the expenses associated with the transporting of patients and supplies to and from the facility on behalf of patient-related activities. Additional activities include but are not limited to the following: transporting patients to and from scheduled outside activities; transporting patients to and from department and other stores; transporting supplies to be used in patient-related activities."]
[65,"Provider In-kind Contributions","This offset includes contributions other than VAP funds that have been given by either your facility or outside parties for the benefit of this VAP program."]
[66,"Incremental Revenue To Offset (projected)","This offset includes the increased revenue from the implementation of the added services from this VAP program."]

{"sheet":"B - Budget Total","index":9,"n_rows":122,"n_cols":12,"rows_kept":122,"cut":false,"hidden":false,"merged":[[6,0,6,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[4,0,4,11],[5,0,5,11],[17,0,17,1],[17,2,17,11],[7,0,7,11],[8,0,8,11],[9,0,9,11],[10,0,10,11],[11,0,11,11],[12,0,12,12],[13,0,13,11],[14,0,14,11],[15,0,15,11],[16,0,16,1],[16,2,16,11],[27,0,27,11],[18,0,18,1],[18,2,18,11],[19,0,19,1],[19,2,19,11],[20,0,20,11],[21,0,21,12],[22,0,22,11],[23,0,23,11],[24,0,24,11],[25,0,25,11],[26,0,26,11],[28,0,28,11],[29,2,29,3],[29,6,29,8],[29,9,29,10],[30,0,30,11],[31,11,33,11],[60,0,60,11],[61,0,61,11],[62,0,62,11],[63,3,63,6],[63,7,63,10],[31,0,33,0],[31,1,33,1],[31,2,33,2],[31,3,32,6],[31,7,32,10],[119,7,119,9],[120,7,120,9],[121,7,121,9],[85,0,85,11],[86,0,86,11],[87,0,87,11],[88,3,88,6],[88,7,88,10],[118,7,118,9]]}
["Vital Access Provider (VAP) / Safety Net Funding"]
["Medicaid Rate Adjustment"]
["3 Year Total Operating Budget"]
[]
[]
[]
["Instructions for Expenditure Plan :"]
["DO NOT KEY TO THIS SCHEDULE! It will AUTO FILL/CALC based on data keyed to Years 1-3 Expend Worksheets."]
["1) This schedule details the total operating budget directly related to the funding requested  and a three year total of the Actual Expenditures for your VAP/Safety Net Project. "]
[]
["2) Date Submitted will auto fill with submission date listed on 'Year 1 Expend' tab."]
[]
["2a) Begin Date of First Full Quarter will auto fill using Begin date listed on 'Year 1 Expend' tab."]
[]
["3) Indicates total budgeted Costs and Details for the following categories for all lines as applicable:  "]
[]
["Full time equivalents (FTEs) -",null,"total annual paid hours (including budgeted vacation, sick leave & overtime expectations) for the employee(s) divided by the number of hours in a standard work week, then divide by 52 (averaged over the life of the project), expressed to one decimal point (e.g., 1.5)"]
["Salaries & Wages - ",null,"amounts paid to employees as compensation for their service."]
["Employee Benefits - ",null,"payroll related costs such as FICA, SUI, group health insurance, pensions, etc. to be paid to or on behalf of employees."]
["Other Than Personal Service (OTPS) Costs - ",null,"Project costs not related to salaries and wages (e.g., office supplies, fees)."]
[]
["3a) Indicates full quarter amounts in actual expenses. "]
[]
["4) Provider In-Kind Contributions (Line 65) and Incremental Revenue To Offset (Line 66) are indicated if applicable."]
[]
["5) Please see 'Definitions' tab for detailed definitions/descriptions of all lines."]
[]
["6) Do not add lines to this schedule. If needed for clarity, please use the 'Note Pad' tab to provide additional details to specific costs reported below. "]
[]
[null,"Date Submitted:",{"$f":"IF('B - Year 1'!C32=\"\",\"\",'B - Year 1'!C32)","v":""},null,null,null,"Begin Date of First Quarter",null,null,{"$f":"IF('B - Year 1'!J32=\"\",\"\",'B - Year 1'!J32)","v":""}]
["Operating Expenses-Direct"]
["Line No","Description","Average Annual FTE's","3 YEAR TOTAL OPERATING BUDGET",null,null,null,"3 YEAR ACTUAL EXPENDITURES",null,null,null,"Comments"]
[]
[null,null,null,"Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Total 3 YEAR Actual Expense"]
[" "," "]
["A.","Inpatient Services:",null,null,null,null," "]
[1,"Physicians",{"$f":"IF(AND('B - Year 1'!C38=\"\",'B - Year 2'!C36=\"\",'B - Year 3'!C36=\"\"),0,IF(AND('B - Year 1'!C38>0,'B - Year 2'!C36=\"\",'B - Year 3'!C36=\"\"),'B - Year 1'!C38,IF(AND('B - Year 1'!C38>0,'B - Year 2'!C36>0,'B - Year 3'!C36=\"\"),ROUND(('B - Year 1'!C38+'B - Year 2'!C36)/2,1),ROUND(('B - Year 1'!C38+'B - Year 2'!C36+'B - Year 3'!C36)/3,1))))","v":0},{"$f":"'B - Year 1'!D38+'B - Year 2'!D36+'B - Year 3'!D36","v":0},{"$f":"'B - Year 1'!E38+'B - Year 2'!E36+'B - Year 3'!E36","v":0},{"$f":"'B - Year 1'!F38+'B - Year 2'!F36+'B - Year 3'!F36","v":0},{"$f":"'B - Year 1'!G38+'B - Year 2'!G36+'B - Year 3'!G36","v":0},{"$f":"'B - Year 1'!L38","v":0},{"$f":"'B - Year 2'!L36","v":0},{"$f":"'B - Year 3'!L36","v":0},{"$f":"SUM(H37:J37)","v":0}]
[2,"Nursing:"]
[3,"         Administrator",{"$f":"IF(AND('B - Year 1'!C40=\"\",'B - Year 2'!C38=\"\",'B - Year 3'!C38=\"\"),0,IF(AND('B - Year 1'!C40>0,'B - Year 2'!C38=\"\",'B - Year 3'!C38=\"\"),'B - Year 1'!C40,IF(AND('B - Year 1'!C40>0,'B - Year 2'!C38>0,'B - Year 3'!C38=\"\"),ROUND(('B - Year 1'!C40+'B - Year 2'!C38)/2,1),ROUND(('B - Year 1'!C40+'B - Year 2'!C38+'B - Year 3'!C38)/3,1))))","v":0},{"$f":"'B - Year 1'!D40+'B - Year 2'!D38+'B - Year 3'!D38","v":0},{"$f":"'B - Year 1'!E40+'B - Year 2'!E38+'B - Year 3'!E38","v":0},{"$f":"'B - Year 1'!F40+'B - Year 2'!F38+'B - Year 3'!F38","v":0},{"$f":"'B - Year 1'!G40+'B - Year 2'!G38+'B - Year 3'!G38","v":0},{"$f":"'B - Year 1'!L40","v":0},{"$f":"'B - Year 2'!L38","v":0},{"$f":"'B - Year 3'!L38","v":0},{"$f":"SUM(H39:J39)","v":0}]
[4,"         Nurse Practitioner",{"$f":"IF(AND('B - Year 1'!C41=\"\",'B - Year 2'!C39=\"\",'B - Year 3'!C39=\"\"),0,IF(AND('B - Year 1'!C41>0,'B - Year 2'!C39=\"\",'B - Year 3'!C39=\"\"),'B - Year 1'!C41,IF(AND('B - Year 1'!C41>0,'B - Year 2'!C39>0,'B - Year 3'!C39=\"\"),ROUND(('B - Year 1'!C41+'B - Year 2'!C39)/2,1),ROUND(('B - Year 1'!C41+'B - Year 2'!C39+'B - Year 3'!C39)/3,1))))","v":0},{"$f":"'B - Year 1'!D41+'B - Year 2'!D39+'B - Year 3'!D39","v":0},{"$f":"'B - Year 1'!E41+'B - Year 2'!E39+'B - Year 3'!E39","v":0},{"$f":"'B - Year 1'!F41+'B - Year 2'!F39+'B - Year 3'!F39","v":0},{"$f":"'B - Year 1'!G41+'B - Year 2'!G39+'B - Year 3'!G39","v":0},{"$f":"'B - Year 1'!L41","v":0},{"$f":"'B - Year 2'!L39","v":0},{"$f":"'B - Year 3'!L39","v":0},0]
[5,"         RN",{"$f":"IF(AND('B - Year 1'!C42=\"\",'B - Year 2'!C40=\"\",'B - Year 3'!C40=\"\"),0,IF(AND('B - Year 1'!C42>0,'B - Year 2'!C40=\"\",'B - Year 3'!C40=\"\"),'B - Year 1'!C42,IF(AND('B - Year 1'!C42>0,'B - Year 2'!C40>0,'B - Year 3'!C40=\"\"),ROUND(('B - Year 1'!C42+'B - Year 2'!C40)/2,1),ROUND(('B - Year 1'!C42+'B - Year 2'!C40+'B - Year 3'!C40)/3,1))))","v":0},{"$f":"'B - Year 1'!D42+'B - Year 2'!D40+'B - Year 3'!D40","v":0},{"$f":"'B - Year 1'!E42+'B - Year 2'!E40+'B - Year 3'!E40","v":0},{"$f":"'B - Year 1'!F42+'B - Year 2'!F40+'B - Year 3'!F40","v":0},{"$f":"'B - Year 1'!G42+'B - Year 2'!G40+'B - Year 3'!G40","v":0},{"$f":"'B - Year 1'!L42","v":0},{"$f":"'B - Year 2'!L40","v":0},{"$f":"'B - Year 3'!L40","v":0},0]
[6,"         LPN",{"$f":"IF(AND('B - Year 1'!C43=\"\",'B - Year 2'!C41=\"\",'B - Year 3'!C41=\"\"),0,IF(AND('B - Year 1'!C43>0,'B - Year 2'!C41=\"\",'B - Year 3'!C41=\"\"),'B - Year 1'!C43,IF(AND('B - Year 1'!C43>0,'B - Year 2'!C41>0,'B - Year 3'!C41=\"\"),ROUND(('B - Year 1'!C43+'B - Year 2'!C41)/2,1),ROUND(('B - Year 1'!C43+'B - Year 2'!C41+'B - Year 3'!C41)/3,1))))","v":0},{"$f":"'B - Year 1'!D43+'B - Year 2'!D41+'B - Year 3'!D41","v":0},{"$f":"'B - Year 1'!E43+'B - Year 2'!E41+'B - Year 3'!E41","v":0},{"$f":"'B - Year 1'!F43+'B - Year 2'!F41+'B - Year 3'!F41","v":0},{"$f":"'B - Year 1'!G43+'B - Year 2'!G41+'B - Year 3'!G41","v":0},{"$f":"'B - Year 1'!L43","v":0},{"$f":"'B - Year 2'!L41","v":0},{"$f":"'B - Year 3'!L41","v":0},0]
[7,"Administration/Clerical",{"$f":"IF(AND('B - Year 1'!C44=\"\",'B - Year 2'!C42=\"\",'B - Year 3'!C42=\"\"),0,IF(AND('B - Year 1'!C44>0,'B - Year 2'!C42=\"\",'B - Year 3'!C42=\"\"),'B - Year 1'!C44,IF(AND('B - Year 1'!C44>0,'B - Year 2'!C42>0,'B - Year 3'!C42=\"\"),ROUND(('B - Year 1'!C44+'B - Year 2'!C42)/2,1),ROUND(('B - Year 1'!C44+'B - Year 2'!C42+'B - Year 3'!C42)/3,1))))","v":0},{"$f":"'B - Year 1'!D44+'B - Year 2'!D42+'B - Year 3'!D42","v":0},{"$f":"'B - Year 1'!E44+'B - Year 2'!E42+'B - Year 3'!E42","v":0},{"$f":"'B - Year 1'!F44+'B - Year 2'!F42+'B - Year 3'!F42","v":0},{"$f":"'B - Year 1'!G44+'B - Year 2'!G42+'B - Year 3'!G42","v":0},{"$f":"'B - Year 1'!L44","v":0},{"$f":"'B - Year 2'!L42","v":0},{"$f":"'B - Year 3'!L42","v":0},0]
[8,"Technicians",{"$f":"IF(AND('B - Year 1'!C45=\"\",'B - Year 2'!C43=\"\",'B - Year 3'!C43=\"\"),0,IF(AND('B - Year 1'!C45>0,'B - Year 2'!C43=\"\",'B - Year 3'!C43=\"\"),'B - Year 1'!C45,IF(AND('B - Year 1'!C45>0,'B - Year 2'!C43>0,'B - Year 3'!C43=\"\"),ROUND(('B - Year 1'!C45+'B - Year 2'!C43)/2,1),ROUND(('B - Year 1'!C45+'B - Year 2'!C43+'B - Year 3'!C43)/3,1))))","v":0},{"$f":"'B - Year 1'!D45+'B - Year 2'!D43+'B - Year 3'!D43","v":0},{"$f":"'B - Year 1'!E45+'B - Year 2'!E43+'B - Year 3'!E43","v":0},{"$f":"'B - Year 1'!F45+'B - Year 2'!F43+'B - Year 3'!F43","v":0},{"$f":"'B - Year 1'!G45+'B - Year 2'!G43+'B - Year 3'!G43","v":0},{"$f":"'B - Year 1'!L45","v":0},{"$f":"'B - Year 2'!L43","v":0},{"$f":"'B - Year 3'!L43","v":0},0]
[9,"Aides",{"$f":"IF(AND('B - Year 1'!C46=\"\",'B - Year 2'!C44=\"\",'B - Year 3'!C44=\"\"),0,IF(AND('B - Year 1'!C46>0,'B - Year 2'!C44=\"\",'B - Year 3'!C44=\"\"),'B - Year 1'!C46,IF(AND('B - Year 1'!C46>0,'B - Year 2'!C44>0,'B - Year 3'!C44=\"\"),ROUND(('B - Year 1'!C46+'B - Year 2'!C44)/2,1),ROUND(('B - Year 1'!C46+'B - Year 2'!C44+'B - Year 3'!C44)/3,1))))","v":0},{"$f":"'B - Year 1'!D46+'B - Year 2'!D44+'B - Year 3'!D44","v":0},{"$f":"'B - Year 1'!E46+'B - Year 2'!E44+'B - Year 3'!E44","v":0},{"$f":"'B - Year 1'!F46+'B - Year 2'!F44+'B - Year 3'!F44","v":0},{"$f":"'B - Year 1'!G46+'B - Year 2'!G44+'B - Year 3'!G44","v":0},{"$f":"'B - Year 1'!L46","v":0},{"$f":"'B - Year 2'!L44","v":0},{"$f":"'B - Year 3'!L44","v":0},0]
[10,"Other (specify in Note Pad section):",{"$f":"IF(AND('B - Year 1'!C47=\"\",'B - Year 2'!C45=\"\",'B - Year 3'!C45=\"\"),0,IF(AND('B - Year 1'!C47>0,'B - Year 2'!C45=\"\",'B - Year 3'!C45=\"\"),'B - Year 1'!C47,IF(AND('B - Year 1'!C47>0,'B - Year 2'!C45>0,'B - Year 3'!C45=\"\"),ROUND(('B - Year 1'!C47+'B - Year 2'!C45)/2,1),ROUND(('B - Year 1'!C47+'B - Year 2'!C45+'B - Year 3'!C45)/3,1))))","v":0},{"$f":"'B - Year 1'!D47+'B - Year 2'!D45+'B - Year 3'!D45","v":0},{"$f":"'B - Year 1'!E47+'B - Year 2'!E45+'B - Year 3'!E45","v":0},{"$f":"'B - Year 1'!F47+'B - Year 2'!F45+'B - Year 3'!F45","v":0},{"$f":"'B - Year 1'!G47+'B - Year 2'!G45+'B - Year 3'!G45","v":0},{"$f":"'B - Year 1'!L47","v":0},{"$f":"'B - Year 2'!L45","v":0},{"$f":"'B - Year 3'!L45","v":0},0]
[11,"Total Inpatient",{"$f":"SUM(C37:C46)","v":0},{"$f":"'B - Year 1'!D48+'B - Year 2'!D46+'B - Year 3'!D46","v":0},{"$f":"'B - Year 1'!E48+'B - Year 2'!E46+'B - Year 3'!E46","v":0},{"$f":"'B - Year 1'!F48+'B - Year 2'!F46+'B - Year 3'!F46","v":0},{"$f":"'B - Year 1'!G48+'B - Year 2'!G46+'B - Year 3'!G46","v":0},{"$f":"SUM(H37:H46)","v":0},0,0,{"$f":"SUM(K37:K46)","v":0}]
[null,null,null,null,null,null," "]
["B.","Outpatient Services:"]
[12,"Physicians",{"$f":"IF(AND('B - Year 1'!C51=\"\",'B - Year 2'!C49=\"\",'B - Year 3'!C49=\"\"),0,IF(AND('B - Year 1'!C51>0,'B - Year 2'!C49=\"\",'B - Year 3'!C49=\"\"),'B - Year 1'!C51,IF(AND('B - Year 1'!C51>0,'B - Year 2'!C49>0,'B - Year 3'!C49=\"\"),ROUND(('B - Year 1'!C51+'B - Year 2'!C49)/2,1),ROUND(('B - Year 1'!C51+'B - Year 2'!C49+'B - Year 3'!C49)/3,1))))","v":0},{"$f":"'B - Year 1'!D51+'B - Year 2'!D49+'B - Year 3'!D49","v":0},{"$f":"'B - Year 1'!E51+'B - Year 2'!E49+'B - Year 3'!E49","v":0},{"$f":"'B - Year 1'!F51+'B - Year 2'!F49+'B - Year 3'!F49","v":0},{"$f":"'B - Year 1'!G51+'B - Year 2'!G49+'B - Year 3'!G49","v":0},{"$f":"'B - Year 1'!L51","v":0},{"$f":"'B - Year 2'!L49","v":0},{"$f":"'B - Year 3'!L49","v":0},{"$f":"SUM(H50:J50)","v":0}]
[13,"Nursing:"]
[14,"         Administrator",{"$f":"IF(AND('B - Year 1'!C53=\"\",'B - Year 2'!C51=\"\",'B - Year 3'!C51=\"\"),0,IF(AND('B - Year 1'!C53>0,'B - Year 2'!C51=\"\",'B - Year 3'!C51=\"\"),'B - Year 1'!C53,IF(AND('B - Year 1'!C53>0,'B - Year 2'!C51>0,'B - Year 3'!C51=\"\"),ROUND(('B - Year 1'!C53+'B - Year 2'!C51)/2,1),ROUND(('B - Year 1'!C53+'B - Year 2'!C51+'B - Year 3'!C51)/3,1))))","v":0},{"$f":"'B - Year 1'!D53+'B - Year 2'!D51+'B - Year 3'!D51","v":0},{"$f":"'B - Year 1'!E53+'B - Year 2'!E51+'B - Year 3'!E51","v":0},{"$f":"'B - Year 1'!F53+'B - Year 2'!F51+'B - Year 3'!F51","v":0},{"$f":"'B - Year 1'!G53+'B - Year 2'!G51+'B - Year 3'!G51","v":0},{"$f":"'B - Year 1'!L53","v":0},{"$f":"'B - Year 2'!L51","v":0},{"$f":"'B - Year 3'!L51","v":0},{"$f":"SUM(H52:J52)","v":0}]
[15,"         Nurse Practitioner",{"$f":"IF(AND('B - Year 1'!C54=\"\",'B - Year 2'!C52=\"\",'B - Year 3'!C52=\"\"),0,IF(AND('B - Year 1'!C54>0,'B - Year 2'!C52=\"\",'B - Year 3'!C52=\"\"),'B - Year 1'!C54,IF(AND('B - Year 1'!C54>0,'B - Year 2'!C52>0,'B - Year 3'!C52=\"\"),ROUND(('B - Year 1'!C54+'B - Year 2'!C52)/2,1),ROUND(('B - Year 1'!C54+'B - Year 2'!C52+'B - Year 3'!C52)/3,1))))","v":0},{"$f":"'B - Year 1'!D54+'B - Year 2'!D52+'B - Year 3'!D52","v":0},{"$f":"'B - Year 1'!E54+'B - Year 2'!E52+'B - Year 3'!E52","v":0},{"$f":"'B - Year 1'!F54+'B - Year 2'!F52+'B - Year 3'!F52","v":0},{"$f":"'B - Year 1'!G54+'B - Year 2'!G52+'B - Year 3'!G52","v":0},{"$f":"'B - Year 1'!L54","v":0},{"$f":"'B - Year 2'!L52","v":0},{"$f":"'B - Year 3'!L52","v":0},0]
[16,"         RN",{"$f":"IF(AND('B - Year 1'!C55=\"\",'B - Year 2'!C53=\"\",'B - Year 3'!C53=\"\"),0,IF(AND('B - Year 1'!C55>0,'B - Year 2'!C53=\"\",'B - Year 3'!C53=\"\"),'B - Year 1'!C55,IF(AND('B - Year 1'!C55>0,'B - Year 2'!C53>0,'B - Year 3'!C53=\"\"),ROUND(('B - Year 1'!C55+'B - Year 2'!C53)/2,1),ROUND(('B - Year 1'!C55+'B - Year 2'!C53+'B - Year 3'!C53)/3,1))))","v":0},{"$f":"'B - Year 1'!D55+'B - Year 2'!D53+'B - Year 3'!D53","v":0},{"$f":"'B - Year 1'!E55+'B - Year 2'!E53+'B - Year 3'!E53","v":0},{"$f":"'B - Year 1'!F55+'B - Year 2'!F53+'B - Year 3'!F53","v":0},{"$f":"'B - Year 1'!G55+'B - Year 2'!G53+'B - Year 3'!G53","v":0},{"$f":"'B - Year 1'!L55","v":0},{"$f":"'B - Year 2'!L53","v":0},{"$f":"'B - Year 3'!L53","v":0},0]
[17,"         LPN",{"$f":"IF(AND('B - Year 1'!C56=\"\",'B - Year 2'!C54=\"\",'B - Year 3'!C54=\"\"),0,IF(AND('B - Year 1'!C56>0,'B - Year 2'!C54=\"\",'B - Year 3'!C54=\"\"),'B - Year 1'!C56,IF(AND('B - Year 1'!C56>0,'B - Year 2'!C54>0,'B - Year 3'!C54=\"\"),ROUND(('B - Year 1'!C56+'B - Year 2'!C54)/2,1),ROUND(('B - Year 1'!C56+'B - Year 2'!C54+'B - Year 3'!C54)/3,1))))","v":0},{"$f":"'B - Year 1'!D56+'B - Year 2'!D54+'B - Year 3'!D54","v":0},{"$f":"'B - Year 1'!E56+'B - Year 2'!E54+'B - Year 3'!E54","v":0},{"$f":"'B - Year 1'!F56+'B - Year 2'!F54+'B - Year 3'!F54","v":0},{"$f":"'B - Year 1'!G56+'B - Year 2'!G54+'B - Year 3'!G54","v":0},{"$f":"'B - Year 1'!L56","v":0},{"$f":"'B - Year 2'!L54","v":0},{"$f":"'B - Year 3'!L54","v":0},0]
[18,"Administration/Clerical",{"$f":"IF(AND('B - Year 1'!C57=\"\",'B - Year 2'!C55=\"\",'B - Year 3'!C55=\"\"),0,IF(AND('B - Year 1'!C57>0,'B - Year 2'!C55=\"\",'B - Year 3'!C55=\"\"),'B - Year 1'!C57,IF(AND('B - Year 1'!C57>0,'B - Year 2'!C55>0,'B - Year 3'!C55=\"\"),ROUND(('B - Year 1'!C57+'B - Year 2'!C55)/2,1),ROUND(('B - Year 1'!C57+'B - Year 2'!C55+'B - Year 3'!C55)/3,1))))","v":0},{"$f":"'B - Year 1'!D57+'B - Year 2'!D55+'B - Year 3'!D55","v":0},{"$f":"'B - Year 1'!E57+'B - Year 2'!E55+'B - Year 3'!E55","v":0},{"$f":"'B - Year 1'!F57+'B - Year 2'!F55+'B - Year 3'!F55","v":0},{"$f":"'B - Year 1'!G57+'B - Year 2'!G55+'B - Year 3'!G55","v":0},{"$f":"'B - Year 1'!L57","v":0},{"$f":"'B - Year 2'!L55","v":0},{"$f":"'B - Year 3'!L55","v":0},0]
[19,"Technicians",{"$f":"IF(AND('B - Year 1'!C58=\"\",'B - Year 2'!C56=\"\",'B - Year 3'!C56=\"\"),0,IF(AND('B - Year 1'!C58>0,'B - Year 2'!C56=\"\",'B - Year 3'!C56=\"\"),'B - Year 1'!C58,IF(AND('B - Year 1'!C58>0,'B - Year 2'!C56>0,'B - Year 3'!C56=\"\"),ROUND(('B - Year 1'!C58+'B - Year 2'!C56)/2,1),ROUND(('B - Year 1'!C58+'B - Year 2'!C56+'B - Year 3'!C56)/3,1))))","v":0},{"$f":"'B - Year 1'!D58+'B - Year 2'!D56+'B - Year 3'!D56","v":0},{"$f":"'B - Year 1'!E58+'B - Year 2'!E56+'B - Year 3'!E56","v":0},{"$f":"'B - Year 1'!F58+'B - Year 2'!F56+'B - Year 3'!F56","v":0},{"$f":"'B - Year 1'!G58+'B - Year 2'!G56+'B - Year 3'!G56","v":0},{"$f":"'B - Year 1'!L58","v":0},{"$f":"'B - Year 2'!L56","v":0},{"$f":"'B - Year 3'!L56","v":0},0]
[20,"Aides",{"$f":"IF(AND('B - Year 1'!C59=\"\",'B - Year 2'!C57=\"\",'B - Year 3'!C57=\"\"),0,IF(AND('B - Year 1'!C59>0,'B - Year 2'!C57=\"\",'B - Year 3'!C57=\"\"),'B - Year 1'!C59,IF(AND('B - Year 1'!C59>0,'B - Year 2'!C57>0,'B - Year 3'!C57=\"\"),ROUND(('B - Year 1'!C59+'B - Year 2'!C57)/2,1),ROUND(('B - Year 1'!C59+'B - Year 2'!C57+'B - Year 3'!C57)/3,1))))","v":0},{"$f":"'B - Year 1'!D59+'B - Year 2'!D57+'B - Year 3'!D57","v":0},{"$f":"'B - Year 1'!E59+'B - Year 2'!E57+'B - Year 3'!E57","v":0},{"$f":"'B - Year 1'!F59+'B - Year 2'!F57+'B - Year 3'!F57","v":0},{"$f":"'B - Year 1'!G59+'B - Year 2'!G57+'B - Year 3'!G57","v":0},{"$f":"'B - Year 1'!L59","v":0},{"$f":"'B - Year 2'!L57","v":0},{"$f":"'B - Year 3'!L57","v":0},0]
[21,"Other (specify in Note Pad section):",{"$f":"IF(AND('B - Year 1'!C60=\"\",'B - Year 2'!C58=\"\",'B - Year 3'!C58=\"\"),0,IF(AND('B - Year 1'!C60>0,'B - Year 2'!C58=\"\",'B - Year 3'!C58=\"\"),'B - Year 1'!C60,IF(AND('B - Year 1'!C60>0,'B - Year 2'!C58>0,'B - Year 3'!C58=\"\"),ROUND(('B - Year 1'!C60+'B - Year 2'!C58)/2,1),ROUND(('B - Year 1'!C60+'B - Year 2'!C58+'B - Year 3'!C58)/3,1))))","v":0},{"$f":"'B - Year 1'!D60+'B - Year 2'!D58+'B - Year 3'!D58","v":0},{"$f":"'B - Year 1'!E60+'B - Year 2'!E58+'B - Year 3'!E58","v":0},{"$f":"'B - Year 1'!F60+'B - Year 2'!F58+'B - Year 3'!F58","v":0},{"$f":"'B - Year 1'!G60+'B - Year 2'!G58+'B - Year 3'!G58","v":0},{"$f":"'B - Year 1'!L60","v":0},{"$f":"'B - Year 2'!L58","v":0},{"$f":"'B - Year 3'!L58","v":0},0]
[22,"Total Outpatient",{"$f":"SUM(C50:C59)","v":0},{"$f":"'B - Year 1'!D61+'B - Year 2'!D59+'B - Year 3'!D59","v":0},{"$f":"'B - Year 1'!E61+'B - Year 2'!E59+'B - Year 3'!E59","v":0},{"$f":"'B - Year 1'!F61+'B - Year 2'!F59+'B - Year 3'!F59","v":0},{"$f":"'B - Year 1'!G61+'B - Year 2'!G59+'B - Year 3'!G59","v":0},{"$f":"SUM(H50:H59)","v":0},0,0,0]
[]
[" "]
["Operating Expenses-Direct"]
[null,null,null,"3 YEAR TOTAL OPERATING BUDGET",null,null,null,"3 YEAR ACTUAL EXPENDITURES"]
["Line No","Description","Average Annual FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Total 3 YEAR Actual Expense","Comments"]
[]
["C.","Ancillary Services:"]
[23,"Laboratory Services",{"$f":"IF(AND('B - Year 1'!C69=\"\",'B - Year 2'!C67=\"\",'B - Year 3'!C67=\"\"),0,IF(AND('B - Year 1'!C69>0,'B - Year 2'!C67=\"\",'B - Year 3'!C67=\"\"),'B - Year 1'!C69,IF(AND('B - Year 1'!C69>0,'B - Year 2'!C67>0,'B - Year 3'!C67=\"\"),ROUND(('B - Year 1'!C69+'B - Year 2'!C67)/2,1),ROUND(('B - Year 1'!C69+'B - Year 2'!C67+'B - Year 3'!C67)/3,1))))","v":0},{"$f":"'B - Year 1'!D69+'B - Year 2'!D67+'B - Year 3'!D67","v":0},{"$f":"'B - Year 1'!E69+'B - Year 2'!E67+'B - Year 3'!E67","v":0},{"$f":"'B - Year 1'!F69+'B - Year 2'!F67+'B - Year 3'!F67","v":0},{"$f":"'B - Year 1'!G69+'B - Year 2'!G67+'B - Year 3'!G67","v":0},{"$f":"'B - Year 1'!L69","v":0},{"$f":"'B - Year 2'!L67","v":0},{"$f":"'B - Year 3'!L67","v":0},{"$f":"SUM(H68:J68)","v":0}]
[24,"Electrocardiology",{"$f":"IF(AND('B - Year 1'!C70=\"\",'B - Year 2'!C68=\"\",'B - Year 3'!C68=\"\"),0,IF(AND('B - Year 1'!C70>0,'B - Year 2'!C68=\"\",'B - Year 3'!C68=\"\"),'B - Year 1'!C70,IF(AND('B - Year 1'!C70>0,'B - Year 2'!C68>0,'B - Year 3'!C68=\"\"),ROUND(('B - Year 1'!C70+'B - Year 2'!C68)/2,1),ROUND(('B - Year 1'!C70+'B - Year 2'!C68+'B - Year 3'!C68)/3,1))))","v":0},{"$f":"'B - Year 1'!D70+'B - Year 2'!D68+'B - Year 3'!D68","v":0},{"$f":"'B - Year 1'!E70+'B - Year 2'!E68+'B - Year 3'!E68","v":0},{"$f":"'B - Year 1'!F70+'B - Year 2'!F68+'B - Year 3'!F68","v":0},{"$f":"'B - Year 1'!G70+'B - Year 2'!G68+'B - Year 3'!G68","v":0},{"$f":"'B - Year 1'!L70","v":0},{"$f":"'B - Year 2'!L68","v":0},{"$f":"'B - Year 3'!L68","v":0},0]
[25,"Electroencephology",{"$f":"IF(AND('B - Year 1'!C71=\"\",'B - Year 2'!C69=\"\",'B - Year 3'!C69=\"\"),0,IF(AND('B - Year 1'!C71>0,'B - Year 2'!C69=\"\",'B - Year 3'!C69=\"\"),'B - Year 1'!C71,IF(AND('B - Year 1'!C71>0,'B - Year 2'!C69>0,'B - Year 3'!C69=\"\"),ROUND(('B - Year 1'!C71+'B - Year 2'!C69)/2,1),ROUND(('B - Year 1'!C71+'B - Year 2'!C69+'B - Year 3'!C69)/3,1))))","v":0},{"$f":"'B - Year 1'!D71+'B - Year 2'!D69+'B - Year 3'!D69","v":0},{"$f":"'B - Year 1'!E71+'B - Year 2'!E69+'B - Year 3'!E69","v":0},{"$f":"'B - Year 1'!F71+'B - Year 2'!F69+'B - Year 3'!F69","v":0},{"$f":"'B - Year 1'!G71+'B - Year 2'!G69+'B - Year 3'!G69","v":0},{"$f":"'B - Year 1'!L71","v":0},{"$f":"'B - Year 2'!L69","v":0},{"$f":"'B - Year 3'!L69","v":0},0]
[26,"Radiology",{"$f":"IF(AND('B - Year 1'!C72=\"\",'B - Year 2'!C70=\"\",'B - Year 3'!C70=\"\"),0,IF(AND('B - Year 1'!C72>0,'B - Year 2'!C70=\"\",'B - Year 3'!C70=\"\"),'B - Year 1'!C72,IF(AND('B - Year 1'!C72>0,'B - Year 2'!C70>0,'B - Year 3'!C70=\"\"),ROUND(('B - Year 1'!C72+'B - Year 2'!C70)/2,1),ROUND(('B - Year 1'!C72+'B - Year 2'!C70+'B - Year 3'!C70)/3,1))))","v":0},{"$f":"'B - Year 1'!D72+'B - Year 2'!D70+'B - Year 3'!D70","v":0},{"$f":"'B - Year 1'!E72+'B - Year 2'!E70+'B - Year 3'!E70","v":0},{"$f":"'B - Year 1'!F72+'B - Year 2'!F70+'B - Year 3'!F70","v":0},{"$f":"'B - Year 1'!G72+'B - Year 2'!G70+'B - Year 3'!G70","v":0},{"$f":"'B - Year 1'!L72","v":0},{"$f":"'B - Year 2'!L70","v":0},{"$f":"'B - Year 3'!L70","v":0},0]
[27,"Inhalation Therapy",{"$f":"IF(AND('B - Year 1'!C73=\"\",'B - Year 2'!C71=\"\",'B - Year 3'!C71=\"\"),0,IF(AND('B - Year 1'!C73>0,'B - Year 2'!C71=\"\",'B - Year 3'!C71=\"\"),'B - Year 1'!C73,IF(AND('B - Year 1'!C73>0,'B - Year 2'!C71>0,'B - Year 3'!C71=\"\"),ROUND(('B - Year 1'!C73+'B - Year 2'!C71)/2,1),ROUND(('B - Year 1'!C73+'B - Year 2'!C71+'B - Year 3'!C71)/3,1))))","v":0},{"$f":"'B - Year 1'!D73+'B - Year 2'!D71+'B - Year 3'!D71","v":0},{"$f":"'B - Year 1'!E73+'B - Year 2'!E71+'B - Year 3'!E71","v":0},{"$f":"'B - Year 1'!F73+'B - Year 2'!F71+'B - Year 3'!F71","v":0},{"$f":"'B - Year 1'!G73+'B - Year 2'!G71+'B - Year 3'!G71","v":0},{"$f":"'B - Year 1'!L73","v":0},{"$f":"'B - Year 2'!L71","v":0},{"$f":"'B - Year 3'!L71","v":0},0]
[28,"Podiatry",{"$f":"IF(AND('B - Year 1'!C74=\"\",'B - Year 2'!C72=\"\",'B - Year 3'!C72=\"\"),0,IF(AND('B - Year 1'!C74>0,'B - Year 2'!C72=\"\",'B - Year 3'!C72=\"\"),'B - Year 1'!C74,IF(AND('B - Year 1'!C74>0,'B - Year 2'!C72>0,'B - Year 3'!C72=\"\"),ROUND(('B - Year 1'!C74+'B - Year 2'!C72)/2,1),ROUND(('B - Year 1'!C74+'B - Year 2'!C72+'B - Year 3'!C72)/3,1))))","v":0},{"$f":"'B - Year 1'!D74+'B - Year 2'!D72+'B - Year 3'!D72","v":0},{"$f":"'B - Year 1'!E74+'B - Year 2'!E72+'B - Year 3'!E72","v":0},{"$f":"'B - Year 1'!F74+'B - Year 2'!F72+'B - Year 3'!F72","v":0},{"$f":"'B - Year 1'!G74+'B - Year 2'!G72+'B - Year 3'!G72","v":0},{"$f":"'B - Year 1'!L74","v":0},{"$f":"'B - Year 2'!L72","v":0},{"$f":"'B - Year 3'!L72","v":0},0]
[29,"Dental",{"$f":"IF(AND('B - Year 1'!C75=\"\",'B - Year 2'!C73=\"\",'B - Year 3'!C73=\"\"),0,IF(AND('B - Year 1'!C75>0,'B - Year 2'!C73=\"\",'B - Year 3'!C73=\"\"),'B - Year 1'!C75,IF(AND('B - Year 1'!C75>0,'B - Year 2'!C73>0,'B - Year 3'!C73=\"\"),ROUND(('B - Year 1'!C75+'B - Year 2'!C73)/2,1),ROUND(('B - Year 1'!C75+'B - Year 2'!C73+'B - Year 3'!C73)/3,1))))","v":0},{"$f":"'B - Year 1'!D75+'B - Year 2'!D73+'B - Year 3'!D73","v":0},{"$f":"'B - Year 1'!E75+'B - Year 2'!E73+'B - Year 3'!E73","v":0},{"$f":"'B - Year 1'!F75+'B - Year 2'!F73+'B - Year 3'!F73","v":0},{"$f":"'B - Year 1'!G75+'B - Year 2'!G73+'B - Year 3'!G73","v":0},{"$f":"'B - Year 1'!L75","v":0},{"$f":"'B - Year 2'!L73","v":0},{"$f":"'B - Year 3'!L73","v":0},0]
[30,"Psychiatric",{"$f":"IF(AND('B - Year 1'!C76=\"\",'B - Year 2'!C74=\"\",'B - Year 3'!C74=\"\"),0,IF(AND('B - Year 1'!C76>0,'B - Year 2'!C74=\"\",'B - Year 3'!C74=\"\"),'B - Year 1'!C76,IF(AND('B - Year 1'!C76>0,'B - Year 2'!C74>0,'B - Year 3'!C74=\"\"),ROUND(('B - Year 1'!C76+'B - Year 2'!C74)/2,1),ROUND(('B - Year 1'!C76+'B - Year 2'!C74+'B - Year 3'!C74)/3,1))))","v":0},{"$f":"'B - Year 1'!D76+'B - Year 2'!D74+'B - Year 3'!D74","v":0},{"$f":"'B - Year 1'!E76+'B - Year 2'!E74+'B - Year 3'!E74","v":0},{"$f":"'B - Year 1'!F76+'B - Year 2'!F74+'B - Year 3'!F74","v":0},{"$f":"'B - Year 1'!G76+'B - Year 2'!G74+'B - Year 3'!G74","v":0},{"$f":"'B - Year 1'!L76","v":0},{"$f":"'B - Year 2'!L74","v":0},{"$f":"'B - Year 3'!L74","v":0},0]
[31,"Therapy-Physical",{"$f":"IF(AND('B - Year 1'!C77=\"\",'B - Year 2'!C75=\"\",'B - Year 3'!C75=\"\"),0,IF(AND('B - Year 1'!C77>0,'B - Year 2'!C75=\"\",'B - Year 3'!C75=\"\"),'B - Year 1'!C77,IF(AND('B - Year 1'!C77>0,'B - Year 2'!C75>0,'B - Year 3'!C75=\"\"),ROUND(('B - Year 1'!C77+'B - Year 2'!C75)/2,1),ROUND(('B - Year 1'!C77+'B - Year 2'!C75+'B - Year 3'!C75)/3,1))))","v":0},{"$f":"'B - Year 1'!D77+'B - Year 2'!D75+'B - Year 3'!D75","v":0},{"$f":"'B - Year 1'!E77+'B - Year 2'!E75+'B - Year 3'!E75","v":0},{"$f":"'B - Year 1'!F77+'B - Year 2'!F75+'B - Year 3'!F75","v":0},{"$f":"'B - Year 1'!G77+'B - Year 2'!G75+'B - Year 3'!G75","v":0},{"$f":"'B - Year 1'!L77","v":0},{"$f":"'B - Year 2'!L75","v":0},{"$f":"'B - Year 3'!L75","v":0},0]
[32,"Therapy-Occupational",{"$f":"IF(AND('B - Year 1'!C78=\"\",'B - Year 2'!C76=\"\",'B - Year 3'!C76=\"\"),0,IF(AND('B - Year 1'!C78>0,'B - Year 2'!C76=\"\",'B - Year 3'!C76=\"\"),'B - Year 1'!C78,IF(AND('B - Year 1'!C78>0,'B - Year 2'!C76>0,'B - Year 3'!C76=\"\"),ROUND(('B - Year 1'!C78+'B - Year 2'!C76)/2,1),ROUND(('B - Year 1'!C78+'B - Year 2'!C76+'B - Year 3'!C76)/3,1))))","v":0},{"$f":"'B - Year 1'!D78+'B - Year 2'!D76+'B - Year 3'!D76","v":0},{"$f":"'B - Year 1'!E78+'B - Year 2'!E76+'B - Year 3'!E76","v":0},{"$f":"'B - Year 1'!F78+'B - Year 2'!F76+'B - Year 3'!F76","v":0},{"$f":"'B - Year 1'!G78+'B - Year 2'!G76+'B - Year 3'!G76","v":0},{"$f":"'B - Year 1'!L78","v":0},{"$f":"'B - Year 2'!L76","v":0},{"$f":"'B - Year 3'!L76","v":0},0]
[33,"Therapy-Speech Language Pathology",{"$f":"IF(AND('B - Year 1'!C79=\"\",'B - Year 2'!C77=\"\",'B - Year 3'!C77=\"\"),0,IF(AND('B - Year 1'!C79>0,'B - Year 2'!C77=\"\",'B - Year 3'!C77=\"\"),'B - Year 1'!C79,IF(AND('B - Year 1'!C79>0,'B - Year 2'!C77>0,'B - Year 3'!C77=\"\"),ROUND(('B - Year 1'!C79+'B - Year 2'!C77)/2,1),ROUND(('B - Year 1'!C79+'B - Year 2'!C77+'B - Year 3'!C77)/3,1))))","v":0},{"$f":"'B - Year 1'!D79+'B - Year 2'!D77+'B - Year 3'!D77","v":0},{"$f":"'B - Year 1'!E79+'B - Year 2'!E77+'B - Year 3'!E77","v":0},{"$f":"'B - Year 1'!F79+'B - Year 2'!F77+'B - Year 3'!F77","v":0},{"$f":"'B - Year 1'!G79+'B - Year 2'!G77+'B - Year 3'!G77","v":0},{"$f":"'B - Year 1'!L79","v":0},{"$f":"'B - Year 2'!L77","v":0},{"$f":"'B - Year 3'!L77","v":0},0]
[34,"Pharmaceutical Services",{"$f":"IF(AND('B - Year 1'!C80=\"\",'B - Year 2'!C78=\"\",'B - Year 3'!C78=\"\"),0,IF(AND('B - Year 1'!C80>0,'B - Year 2'!C78=\"\",'B - Year 3'!C78=\"\"),'B - Year 1'!C80,IF(AND('B - Year 1'!C80>0,'B - Year 2'!C78>0,'B - Year 3'!C78=\"\"),ROUND(('B - Year 1'!C80+'B - Year 2'!C78)/2,1),ROUND(('B - Year 1'!C80+'B - Year 2'!C78+'B - Year 3'!C78)/3,1))))","v":0},{"$f":"'B - Year 1'!D80+'B - Year 2'!D78+'B - Year 3'!D78","v":0},{"$f":"'B - Year 1'!E80+'B - Year 2'!E78+'B - Year 3'!E78","v":0},{"$f":"'B - Year 1'!F80+'B - Year 2'!F78+'B - Year 3'!F78","v":0},{"$f":"'B - Year 1'!G80+'B - Year 2'!G78+'B - Year 3'!G78","v":0},{"$f":"'B - Year 1'!L80","v":0},{"$f":"'B - Year 2'!L78","v":0},{"$f":"'B - Year 3'!L78","v":0},0]
[35,"Central Service Supply",{"$f":"IF(AND('B - Year 1'!C81=\"\",'B - Year 2'!C79=\"\",'B - Year 3'!C79=\"\"),0,IF(AND('B - Year 1'!C81>0,'B - Year 2'!C79=\"\",'B - Year 3'!C79=\"\"),'B - Year 1'!C81,IF(AND('B - Year 1'!C81>0,'B - Year 2'!C79>0,'B - Year 3'!C79=\"\"),ROUND(('B - Year 1'!C81+'B - Year 2'!C79)/2,1),ROUND(('B - Year 1'!C81+'B - Year 2'!C79+'B - Year 3'!C79)/3,1))))","v":0},{"$f":"'B - Year 1'!D81+'B - Year 2'!D79+'B - Year 3'!D79","v":0},{"$f":"'B - Year 1'!E81+'B - Year 2'!E79+'B - Year 3'!E79","v":0},{"$f":"'B - Year 1'!F81+'B - Year 2'!F79+'B - Year 3'!F79","v":0},{"$f":"'B - Year 1'!G81+'B - Year 2'!G79+'B - Year 3'!G79","v":0},{"$f":"'B - Year 1'!L81","v":0},{"$f":"'B - Year 2'!L79","v":0},{"$f":"'B - Year 3'!L79","v":0},0]
[36,"Medical Staff Services",{"$f":"IF(AND('B - Year 1'!C82=\"\",'B - Year 2'!C80=\"\",'B - Year 3'!C80=\"\"),0,IF(AND('B - Year 1'!C82>0,'B - Year 2'!C80=\"\",'B - Year 3'!C80=\"\"),'B - Year 1'!C82,IF(AND('B - Year 1'!C82>0,'B - Year 2'!C80>0,'B - Year 3'!C80=\"\"),ROUND(('B - Year 1'!C82+'B - Year 2'!C80)/2,1),ROUND(('B - Year 1'!C82+'B - Year 2'!C80+'B - Year 3'!C80)/3,1))))","v":0},{"$f":"'B - Year 1'!D82+'B - Year 2'!D80+'B - Year 3'!D80","v":0},{"$f":"'B - Year 1'!E82+'B - Year 2'!E80+'B - Year 3'!E80","v":0},{"$f":"'B - Year 1'!F82+'B - Year 2'!F80+'B - Year 3'!F80","v":0},{"$f":"'B - Year 1'!G82+'B - Year 2'!G80+'B - Year 3'!G80","v":0},{"$f":"'B - Year 1'!L82","v":0},{"$f":"'B - Year 2'!L80","v":0},{"$f":"'B - Year 3'!L80","v":0},0]
[37,"Other (specify in Note Pad section):",{"$f":"IF(AND('B - Year 1'!C83=\"\",'B - Year 2'!C81=\"\",'B - Year 3'!C81=\"\"),0,IF(AND('B - Year 1'!C83>0,'B - Year 2'!C81=\"\",'B - Year 3'!C81=\"\"),'B - Year 1'!C83,IF(AND('B - Year 1'!C83>0,'B - Year 2'!C81>0,'B - Year 3'!C81=\"\"),ROUND(('B - Year 1'!C83+'B - Year 2'!C81)/2,1),ROUND(('B - Year 1'!C83+'B - Year 2'!C81+'B - Year 3'!C81)/3,1))))","v":0},{"$f":"'B - Year 1'!D83+'B - Year 2'!D81+'B - Year 3'!D81","v":0},{"$f":"'B - Year 1'!E83+'B - Year 2'!E81+'B - Year 3'!E81","v":0},{"$f":"'B - Year 1'!F83+'B - Year 2'!F81+'B - Year 3'!F81","v":0},{"$f":"'B - Year 1'!G83+'B - Year 2'!G81+'B - Year 3'!G81","v":0},{"$f":"'B - Year 1'!L83","v":0},{"$f":"'B - Year 2'!L81","v":0},{"$f":"'B - Year 3'!L81","v":0},0]
[38,"Total Ancillary",{"$f":"SUM(C68:C82)","v":0},{"$f":"'B - Year 1'!D84+'B - Year 2'!D82+'B - Year 3'!D82","v":0},{"$f":"'B - Year 1'!E84+'B - Year 2'!E82+'B - Year 3'!E82","v":0},{"$f":"'B - Year 1'!F84+'B - Year 2'!F82+'B - Year 3'!F82","v":0},{"$f":"'B - Year 1'!G84+'B - Year 2'!G82+'B - Year 3'!G82","v":0},{"$f":"SUM(H68:H82)","v":0},0,0,0]
[]
[39,"Total Direct (Lines 11 + 22 + 38)",{"$f":"C47+C60+C83","v":0},{"$f":"'B - Year 1'!D86+'B - Year 2'!D84+'B - Year 3'!D84","v":0},{"$f":"'B - Year 1'!E86+'B - Year 2'!E84+'B - Year 3'!E84","v":0},{"$f":"'B - Year 1'!F86+'B - Year 2'!F84+'B - Year 3'!F84","v":0},{"$f":"'B - Year 1'!G86+'B - Year 2'!G84+'B - Year 3'!G84","v":0},{"$f":"H47+H60+H83","v":0},0,0,0]
[]
[" "]
["Operating Expenses-Indirect "]
[" ",null,null,"3 YEAR TOTAL OPERATING BUDGET",null,null,null,"3 YEAR ACTUAL EXPENDITURES"]
["Line No","Description","Average Annual FTE's","Salaries & Wages","Employee Benefits","OTPS Costs","Total Funding Requested","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Total 3 YEAR Actual Expense","Comments"]
["D.","Administrative and General Services:"]
[40,"Fiscal Services",{"$f":"IF(AND('B - Year 1'!C93=\"\",'B - Year 2'!C91=\"\",'B - Year 3'!C91=\"\"),0,IF(AND('B - Year 1'!C93>0,'B - Year 2'!C91=\"\",'B - Year 3'!C91=\"\"),'B - Year 1'!C93,IF(AND('B - Year 1'!C93>0,'B - Year 2'!C91>0,'B - Year 3'!C91=\"\"),ROUND(('B - Year 1'!C93+'B - Year 2'!C91)/2,1),ROUND(('B - Year 1'!C93+'B - Year 2'!C91+'B - Year 3'!C91)/3,1))))","v":0},{"$f":"'B - Year 1'!D93+'B - Year 2'!D91+'B - Year 3'!D91","v":0},{"$f":"'B - Year 1'!E93+'B - Year 2'!E91+'B - Year 3'!E91","v":0},{"$f":"'B - Year 1'!F93+'B - Year 2'!F91+'B - Year 3'!F91","v":0},{"$f":"'B - Year 1'!G93+'B - Year 2'!G91+'B - Year 3'!G91","v":0},{"$f":"'B - Year 1'!L93","v":0},{"$f":"'B - Year 2'!L91","v":0},{"$f":"'B - Year 3'!L91","v":0},{"$f":"SUM(H92:J92)","v":0}]
[41,"Administrative Services",{"$f":"IF(AND('B - Year 1'!C94=\"\",'B - Year 2'!C92=\"\",'B - Year 3'!C92=\"\"),0,IF(AND('B - Year 1'!C94>0,'B - Year 2'!C92=\"\",'B - Year 3'!C92=\"\"),'B - Year 1'!C94,IF(AND('B - Year 1'!C94>0,'B - Year 2'!C92>0,'B - Year 3'!C92=\"\"),ROUND(('B - Year 1'!C94+'B - Year 2'!C92)/2,1),ROUND(('B - Year 1'!C94+'B - Year 2'!C92+'B - Year 3'!C92)/3,1))))","v":0},{"$f":"'B - Year 1'!D94+'B - Year 2'!D92+'B - Year 3'!D92","v":0},{"$f":"'B - Year 1'!E94+'B - Year 2'!E92+'B - Year 3'!E92","v":0},{"$f":"'B - Year 1'!F94+'B - Year 2'!F92+'B - Year 3'!F92","v":0},{"$f":"'B - Year 1'!G94+'B - Year 2'!G92+'B - Year 3'!G92","v":0},{"$f":"'B - Year 1'!L94","v":0},{"$f":"'B - Year 2'!L92","v":0},{"$f":"'B - Year 3'!L92","v":0},0]
[42,"Plant Operation and Maintenance",{"$f":"IF(AND('B - Year 1'!C95=\"\",'B - Year 2'!C93=\"\",'B - Year 3'!C93=\"\"),0,IF(AND('B - Year 1'!C95>0,'B - Year 2'!C93=\"\",'B - Year 3'!C93=\"\"),'B - Year 1'!C95,IF(AND('B - Year 1'!C95>0,'B - Year 2'!C93>0,'B - Year 3'!C93=\"\"),ROUND(('B - Year 1'!C95+'B - Year 2'!C93)/2,1),ROUND(('B - Year 1'!C95+'B - Year 2'!C93+'B - Year 3'!C93)/3,1))))","v":0},{"$f":"'B - Year 1'!D95+'B - Year 2'!D93+'B - Year 3'!D93","v":0},{"$f":"'B - Year 1'!E95+'B - Year 2'!E93+'B - Year 3'!E93","v":0},{"$f":"'B - Year 1'!F95+'B - Year 2'!F93+'B - Year 3'!F93","v":0},{"$f":"'B - Year 1'!G95+'B - Year 2'!G93+'B - Year 3'!G93","v":0},{"$f":"'B - Year 1'!L95","v":0},{"$f":"'B - Year 2'!L93","v":0},{"$f":"'B - Year 3'!L93","v":0},0]
[43,"Utilities",{"$f":"IF(AND('B - Year 1'!C96=\"\",'B - Year 2'!C94=\"\",'B - Year 3'!C94=\"\"),0,IF(AND('B - Year 1'!C96>0,'B - Year 2'!C94=\"\",'B - Year 3'!C94=\"\"),'B - Year 1'!C96,IF(AND('B - Year 1'!C96>0,'B - Year 2'!C94>0,'B - Year 3'!C94=\"\"),ROUND(('B - Year 1'!C96+'B - Year 2'!C94)/2,1),ROUND(('B - Year 1'!C96+'B - Year 2'!C94+'B - Year 3'!C94)/3,1))))","v":0},{"$f":"'B - Year 1'!D96+'B - Year 2'!D94+'B - Year 3'!D94","v":0},{"$f":"'B - Year 1'!E96+'B - Year 2'!E94+'B - Year 3'!E94","v":0},{"$f":"'B - Year 1'!F96+'B - Year 2'!F94+'B - Year 3'!F94","v":0},{"$f":"'B - Year 1'!G96+'B - Year 2'!G94+'B - Year 3'!G94","v":0},{"$f":"'B - Year 1'!L96","v":0},{"$f":"'B - Year 2'!L94","v":0},{"$f":"'B - Year 3'!L94","v":0},0]
[44,"Property Taxes",{"$f":"IF(AND('B - Year 1'!C97=\"\",'B - Year 2'!C95=\"\",'B - Year 3'!C95=\"\"),0,IF(AND('B - Year 1'!C97>0,'B - Year 2'!C95=\"\",'B - Year 3'!C95=\"\"),'B - Year 1'!C97,IF(AND('B - Year 1'!C97>0,'B - Year 2'!C95>0,'B - Year 3'!C95=\"\"),ROUND(('B - Year 1'!C97+'B - Year 2'!C95)/2,1),ROUND(('B - Year 1'!C97+'B - Year 2'!C95+'B - Year 3'!C95)/3,1))))","v":0},{"$f":"'B - Year 1'!D97+'B - Year 2'!D95+'B - Year 3'!D95","v":0},{"$f":"'B - Year 1'!E97+'B - Year 2'!E95+'B - Year 3'!E95","v":0},{"$f":"'B - Year 1'!F97+'B - Year 2'!F95+'B - Year 3'!F95","v":0},{"$f":"'B - Year 1'!G97+'B - Year 2'!G95+'B - Year 3'!G95","v":0},{"$f":"'B - Year 1'!L97","v":0},{"$f":"'B - Year 2'!L95","v":0},{"$f":"'B - Year 3'!L95","v":0},0]
[45,"Property Insurance",{"$f":"IF(AND('B - Year 1'!C98=\"\",'B - Year 2'!C96=\"\",'B - Year 3'!C96=\"\"),0,IF(AND('B - Year 1'!C98>0,'B - Year 2'!C96=\"\",'B - Year 3'!C96=\"\"),'B - Year 1'!C98,IF(AND('B - Year 1'!C98>0,'B - Year 2'!C96>0,'B - Year 3'!C96=\"\"),ROUND(('B - Year 1'!C98+'B - Year 2'!C96)/2,1),ROUND(('B - Year 1'!C98+'B - Year 2'!C96+'B - Year 3'!C96)/3,1))))","v":0},{"$f":"'B - Year 1'!D98+'B - Year 2'!D96+'B - Year 3'!D96","v":0},{"$f":"'B - Year 1'!E98+'B - Year 2'!E96+'B - Year 3'!E96","v":0},{"$f":"'B - Year 1'!F98+'B - Year 2'!F96+'B - Year 3'!F96","v":0},{"$f":"'B - Year 1'!G98+'B - Year 2'!G96+'B - Year 3'!G96","v":0},{"$f":"'B - Year 1'!L98","v":0},{"$f":"'B - Year 2'!L96","v":0},{"$f":"'B - Year 3'!L96","v":0},0]
[46,"Grounds",{"$f":"IF(AND('B - Year 1'!C99=\"\",'B - Year 2'!C97=\"\",'B - Year 3'!C97=\"\"),0,IF(AND('B - Year 1'!C99>0,'B - Year 2'!C97=\"\",'B - Year 3'!C97=\"\"),'B - Year 1'!C99,IF(AND('B - Year 1'!C99>0,'B - Year 2'!C97>0,'B - Year 3'!C97=\"\"),ROUND(('B - Year 1'!C99+'B - Year 2'!C97)/2,1),ROUND(('B - Year 1'!C99+'B - Year 2'!C97+'B - Year 3'!C97)/3,1))))","v":0},{"$f":"'B - Year 1'!D99+'B - Year 2'!D97+'B - Year 3'!D97","v":0},{"$f":"'B - Year 1'!E99+'B - Year 2'!E97+'B - Year 3'!E97","v":0},{"$f":"'B - Year 1'!F99+'B - Year 2'!F97+'B - Year 3'!F97","v":0},{"$f":"'B - Year 1'!G99+'B - Year 2'!G97+'B - Year 3'!G97","v":0},{"$f":"'B - Year 1'!L99","v":0},{"$f":"'B - Year 2'!L97","v":0},{"$f":"'B - Year 3'!L97","v":0},{"$f":"SUM(H98:J98)","v":0}]
[47,"Security",{"$f":"IF(AND('B - Year 1'!C100=\"\",'B - Year 2'!C98=\"\",'B - Year 3'!C98=\"\"),0,IF(AND('B - Year 1'!C100>0,'B - Year 2'!C98=\"\",'B - Year 3'!C98=\"\"),'B - Year 1'!C100,IF(AND('B - Year 1'!C100>0,'B - Year 2'!C98>0,'B - Year 3'!C98=\"\"),ROUND(('B - Year 1'!C100+'B - Year 2'!C98)/2,1),ROUND(('B - Year 1'!C100+'B - Year 2'!C98+'B - Year 3'!C98)/3,1))))","v":0},{"$f":"'B - Year 1'!D100+'B - Year 2'!D98+'B - Year 3'!D98","v":0},{"$f":"'B - Year 1'!E100+'B - Year 2'!E98+'B - Year 3'!E98","v":0},{"$f":"'B - Year 1'!F100+'B - Year 2'!F98+'B - Year 3'!F98","v":0},{"$f":"'B - Year 1'!G100+'B - Year 2'!G98+'B - Year 3'!G98","v":0},{"$f":"'B - Year 1'!L100","v":0},{"$f":"'B - Year 2'!L98","v":0},{"$f":"'B - Year 3'!L98","v":0},0]
[48,"Laundry and Linen",{"$f":"IF(AND('B - Year 1'!C101=\"\",'B - Year 2'!C99=\"\",'B - Year 3'!C99=\"\"),0,IF(AND('B - Year 1'!C101>0,'B - Year 2'!C99=\"\",'B - Year 3'!C99=\"\"),'B - Year 1'!C101,IF(AND('B - Year 1'!C101>0,'B - Year 2'!C99>0,'B - Year 3'!C99=\"\"),ROUND(('B - Year 1'!C101+'B - Year 2'!C99)/2,1),ROUND(('B - Year 1'!C101+'B - Year 2'!C99+'B - Year 3'!C99)/3,1))))","v":0},{"$f":"'B - Year 1'!D101+'B - Year 2'!D99+'B - Year 3'!D99","v":0},{"$f":"'B - Year 1'!E101+'B - Year 2'!E99+'B - Year 3'!E99","v":0},{"$f":"'B - Year 1'!F101+'B - Year 2'!F99+'B - Year 3'!F99","v":0},{"$f":"'B - Year 1'!G101+'B - Year 2'!G99+'B - Year 3'!G99","v":0},{"$f":"'B - Year 1'!L101","v":0},{"$f":"'B - Year 2'!L99","v":0},{"$f":"'B - Year 3'!L99","v":0},0]
[49,"Housekeeping",{"$f":"IF(AND('B - Year 1'!C102=\"\",'B - Year 2'!C100=\"\",'B - Year 3'!C100=\"\"),0,IF(AND('B - Year 1'!C102>0,'B - Year 2'!C100=\"\",'B - Year 3'!C100=\"\"),'B - Year 1'!C102,IF(AND('B - Year 1'!C102>0,'B - Year 2'!C100>0,'B - Year 3'!C100=\"\"),ROUND(('B - Year 1'!C102+'B - Year 2'!C100)/2,1),ROUND(('B - Year 1'!C102+'B - Year 2'!C100+'B - Year 3'!C100)/3,1))))","v":0},{"$f":"'B - Year 1'!D102+'B - Year 2'!D100+'B - Year 3'!D100","v":0},{"$f":"'B - Year 1'!E102+'B - Year 2'!E100+'B - Year 3'!E100","v":0},{"$f":"'B - Year 1'!F102+'B - Year 2'!F100+'B - Year 3'!F100","v":0},{"$f":"'B - Year 1'!G102+'B - Year 2'!G100+'B - Year 3'!G100","v":0},{"$f":"'B - Year 1'!L102","v":0},{"$f":"'B - Year 2'!L100","v":0},{"$f":"'B - Year 3'!L100","v":0},0]
[50,"Patient Food Service",{"$f":"IF(AND('B - Year 1'!C103=\"\",'B - Year 2'!C101=\"\",'B - Year 3'!C101=\"\"),0,IF(AND('B - Year 1'!C103>0,'B - Year 2'!C101=\"\",'B - Year 3'!C101=\"\"),'B - Year 1'!C103,IF(AND('B - Year 1'!C103>0,'B - Year 2'!C101>0,'B - Year 3'!C101=\"\"),ROUND(('B - Year 1'!C103+'B - Year 2'!C101)/2,1),ROUND(('B - Year 1'!C103+'B - Year 2'!C101+'B - Year 3'!C101)/3,1))))","v":0},{"$f":"'B - Year 1'!D103+'B - Year 2'!D101+'B - Year 3'!D101","v":0},{"$f":"'B - Year 1'!E103+'B - Year 2'!E101+'B - Year 3'!E101","v":0},{"$f":"'B - Year 1'!F103+'B - Year 2'!F101+'B - Year 3'!F101","v":0},{"$f":"'B - Year 1'!G103+'B - Year 2'!G101+'B - Year 3'!G101","v":0},{"$f":"'B - Year 1'!L103","v":0},{"$f":"'B - Year 2'!L101","v":0},{"$f":"'B - Year 3'!L101","v":0},0]
[51,"Cafeteria",{"$f":"IF(AND('B - Year 1'!C104=\"\",'B - Year 2'!C102=\"\",'B - Year 3'!C102=\"\"),0,IF(AND('B - Year 1'!C104>0,'B - Year 2'!C102=\"\",'B - Year 3'!C102=\"\"),'B - Year 1'!C104,IF(AND('B - Year 1'!C104>0,'B - Year 2'!C102>0,'B - Year 3'!C102=\"\"),ROUND(('B - Year 1'!C104+'B - Year 2'!C102)/2,1),ROUND(('B - Year 1'!C104+'B - Year 2'!C102+'B - Year 3'!C102)/3,1))))","v":0},{"$f":"'B - Year 1'!D104+'B - Year 2'!D102+'B - Year 3'!D102","v":0},{"$f":"'B - Year 1'!E104+'B - Year 2'!E102+'B - Year 3'!E102","v":0},{"$f":"'B - Year 1'!F104+'B - Year 2'!F102+'B - Year 3'!F102","v":0},{"$f":"'B - Year 1'!G104+'B - Year 2'!G102+'B - Year 3'!G102","v":0},{"$f":"'B - Year 1'!L104","v":0},{"$f":"'B - Year 2'!L102","v":0},{"$f":"'B - Year 3'!L102","v":0},0]
[52,"Nursing Administration",{"$f":"IF(AND('B - Year 1'!C105=\"\",'B - Year 2'!C103=\"\",'B - Year 3'!C103=\"\"),0,IF(AND('B - Year 1'!C105>0,'B - Year 2'!C103=\"\",'B - Year 3'!C103=\"\"),'B - Year 1'!C105,IF(AND('B - Year 1'!C105>0,'B - Year 2'!C103>0,'B - Year 3'!C103=\"\"),ROUND(('B - Year 1'!C105+'B - Year 2'!C103)/2,1),ROUND(('B - Year 1'!C105+'B - Year 2'!C103+'B - Year 3'!C103)/3,1))))","v":0},{"$f":"'B - Year 1'!D105+'B - Year 2'!D103+'B - Year 3'!D103","v":0},{"$f":"'B - Year 1'!E105+'B - Year 2'!E103+'B - Year 3'!E103","v":0},{"$f":"'B - Year 1'!F105+'B - Year 2'!F103+'B - Year 3'!F103","v":0},{"$f":"'B - Year 1'!G105+'B - Year 2'!G103+'B - Year 3'!G103","v":0},{"$f":"'B - Year 1'!L105","v":0},{"$f":"'B - Year 2'!L103","v":0},{"$f":"'B - Year 3'!L103","v":0},0]
[53,"Activities Program",{"$f":"IF(AND('B - Year 1'!C106=\"\",'B - Year 2'!C104=\"\",'B - Year 3'!C104=\"\"),0,IF(AND('B - Year 1'!C106>0,'B - Year 2'!C104=\"\",'B - Year 3'!C104=\"\"),'B - Year 1'!C106,IF(AND('B - Year 1'!C106>0,'B - Year 2'!C104>0,'B - Year 3'!C104=\"\"),ROUND(('B - Year 1'!C106+'B - Year 2'!C104)/2,1),ROUND(('B - Year 1'!C106+'B - Year 2'!C104+'B - Year 3'!C104)/3,1))))","v":0},{"$f":"'B - Year 1'!D106+'B - Year 2'!D104+'B - Year 3'!D104","v":0},{"$f":"'B - Year 1'!E106+'B - Year 2'!E104+'B - Year 3'!E104","v":0},{"$f":"'B - Year 1'!F106+'B - Year 2'!F104+'B - Year 3'!F104","v":0},{"$f":"'B - Year 1'!G106+'B - Year 2'!G104+'B - Year 3'!G104","v":0},{"$f":"'B - Year 1'!L106","v":0},{"$f":"'B - Year 2'!L104","v":0},{"$f":"'B - Year 3'!L104","v":0},0]
[54,"Nonphysician Education",{"$f":"IF(AND('B - Year 1'!C107=\"\",'B - Year 2'!C105=\"\",'B - Year 3'!C105=\"\"),0,IF(AND('B - Year 1'!C107>0,'B - Year 2'!C105=\"\",'B - Year 3'!C105=\"\"),'B - Year 1'!C107,IF(AND('B - Year 1'!C107>0,'B - Year 2'!C105>0,'B - Year 3'!C105=\"\"),ROUND(('B - Year 1'!C107+'B - Year 2'!C105)/2,1),ROUND(('B - Year 1'!C107+'B - Year 2'!C105+'B - Year 3'!C105)/3,1))))","v":0},{"$f":"'B - Year 1'!D107+'B - Year 2'!D105+'B - Year 3'!D105","v":0},{"$f":"'B - Year 1'!E107+'B - Year 2'!E105+'B - Year 3'!E105","v":0},{"$f":"'B - Year 1'!F107+'B - Year 2'!F105+'B - Year 3'!F105","v":0},{"$f":"'B - Year 1'!G107+'B - Year 2'!G105+'B - Year 3'!G105","v":0},{"$f":"'B - Year 1'!L107","v":0},{"$f":"'B - Year 2'!L105","v":0},{"$f":"'B - Year 3'!L105","v":0},0]
[55,"Medical Education",{"$f":"IF(AND('B - Year 1'!C108=\"\",'B - Year 2'!C106=\"\",'B - Year 3'!C106=\"\"),0,IF(AND('B - Year 1'!C108>0,'B - Year 2'!C106=\"\",'B - Year 3'!C106=\"\"),'B - Year 1'!C108,IF(AND('B - Year 1'!C108>0,'B - Year 2'!C106>0,'B - Year 3'!C106=\"\"),ROUND(('B - Year 1'!C108+'B - Year 2'!C106)/2,1),ROUND(('B - Year 1'!C108+'B - Year 2'!C106+'B - Year 3'!C106)/3,1))))","v":0},{"$f":"'B - Year 1'!D108+'B - Year 2'!D106+'B - Year 3'!D106","v":0},{"$f":"'B - Year 1'!E108+'B - Year 2'!E106+'B - Year 3'!E106","v":0},{"$f":"'B - Year 1'!F108+'B - Year 2'!F106+'B - Year 3'!F106","v":0},{"$f":"'B - Year 1'!G108+'B - Year 2'!G106+'B - Year 3'!G106","v":0},{"$f":"'B - Year 1'!L108","v":0},{"$f":"'B - Year 2'!L106","v":0},{"$f":"'B - Year 3'!L106","v":0},0]
[56,"Medical Director's Office",{"$f":"IF(AND('B - Year 1'!C109=\"\",'B - Year 2'!C107=\"\",'B - Year 3'!C107=\"\"),0,IF(AND('B - Year 1'!C109>0,'B - Year 2'!C107=\"\",'B - Year 3'!C107=\"\"),'B - Year 1'!C109,IF(AND('B - Year 1'!C109>0,'B - Year 2'!C107>0,'B - Year 3'!C107=\"\"),ROUND(('B - Year 1'!C109+'B - Year 2'!C107)/2,1),ROUND(('B - Year 1'!C109+'B - Year 2'!C107+'B - Year 3'!C107)/3,1))))","v":0},{"$f":"'B - Year 1'!D109+'B - Year 2'!D107+'B - Year 3'!D107","v":0},{"$f":"'B - Year 1'!E109+'B - Year 2'!E107+'B - Year 3'!E107","v":0},{"$f":"'B - Year 1'!F109+'B - Year 2'!F107+'B - Year 3'!F107","v":0},{"$f":"'B - Year 1'!G109+'B - Year 2'!G107+'B - Year 3'!G107","v":0},{"$f":"'B - Year 1'!L109","v":0},{"$f":"'B - Year 2'!L107","v":0},{"$f":"'B - Year 3'!L107","v":0},0]
[57,"Housing",{"$f":"IF(AND('B - Year 1'!C110=\"\",'B - Year 2'!C108=\"\",'B - Year 3'!C108=\"\"),0,IF(AND('B - Year 1'!C110>0,'B - Year 2'!C108=\"\",'B - Year 3'!C108=\"\"),'B - Year 1'!C110,IF(AND('B - Year 1'!C110>0,'B - Year 2'!C108>0,'B - Year 3'!C108=\"\"),ROUND(('B - Year 1'!C110+'B - Year 2'!C108)/2,1),ROUND(('B - Year 1'!C110+'B - Year 2'!C108+'B - Year 3'!C108)/3,1))))","v":0},{"$f":"'B - Year 1'!D110+'B - Year 2'!D108+'B - Year 3'!D108","v":0},{"$f":"'B - Year 1'!E110+'B - Year 2'!E108+'B - Year 3'!E108","v":0},{"$f":"'B - Year 1'!F110+'B - Year 2'!F108+'B - Year 3'!F108","v":0},{"$f":"'B - Year 1'!G110+'B - Year 2'!G108+'B - Year 3'!G108","v":0},{"$f":"'B - Year 1'!L110","v":0},{"$f":"'B - Year 2'!L108","v":0},{"$f":"'B - Year 3'!L108","v":0},0]
[58,"Medical Records",{"$f":"IF(AND('B - Year 1'!C111=\"\",'B - Year 2'!C109=\"\",'B - Year 3'!C109=\"\"),0,IF(AND('B - Year 1'!C111>0,'B - Year 2'!C109=\"\",'B - Year 3'!C109=\"\"),'B - Year 1'!C111,IF(AND('B - Year 1'!C111>0,'B - Year 2'!C109>0,'B - Year 3'!C109=\"\"),ROUND(('B - Year 1'!C111+'B - Year 2'!C109)/2,1),ROUND(('B - Year 1'!C111+'B - Year 2'!C109+'B - Year 3'!C109)/3,1))))","v":0},{"$f":"'B - Year 1'!D111+'B - Year 2'!D109+'B - Year 3'!D109","v":0},{"$f":"'B - Year 1'!E111+'B - Year 2'!E109+'B - Year 3'!E109","v":0},{"$f":"'B - Year 1'!F111+'B - Year 2'!F109+'B - Year 3'!F109","v":0},{"$f":"'B - Year 1'!G111+'B - Year 2'!G109+'B - Year 3'!G109","v":0},{"$f":"'B - Year 1'!L111","v":0},{"$f":"'B - Year 2'!L109","v":0},{"$f":"'B - Year 3'!L109","v":0},0]
[59,"Utilization Review",{"$f":"IF(AND('B - Year 1'!C112=\"\",'B - Year 2'!C110=\"\",'B - Year 3'!C110=\"\"),0,IF(AND('B - Year 1'!C112>0,'B - Year 2'!C110=\"\",'B - Year 3'!C110=\"\"),'B - Year 1'!C112,IF(AND('B - Year 1'!C112>0,'B - Year 2'!C110>0,'B - Year 3'!C110=\"\"),ROUND(('B - Year 1'!C112+'B - Year 2'!C110)/2,1),ROUND(('B - Year 1'!C112+'B - Year 2'!C110+'B - Year 3'!C110)/3,1))))","v":0},{"$f":"'B - Year 1'!D112+'B - Year 2'!D110+'B - Year 3'!D110","v":0},{"$f":"'B - Year 1'!E112+'B - Year 2'!E110+'B - Year 3'!E110","v":0},{"$f":"'B - Year 1'!F112+'B - Year 2'!F110+'B - Year 3'!F110","v":0},{"$f":"'B - Year 1'!G112+'B - Year 2'!G110+'B - Year 3'!G110","v":0},{"$f":"'B - Year 1'!L112","v":0},{"$f":"'B - Year 2'!L110","v":0},{"$f":"'B - Year 3'!L110","v":0},0]
[60,"Social Service",{"$f":"IF(AND('B - Year 1'!C113=\"\",'B - Year 2'!C111=\"\",'B - Year 3'!C111=\"\"),0,IF(AND('B - Year 1'!C113>0,'B - Year 2'!C111=\"\",'B - Year 3'!C111=\"\"),'B - Year 1'!C113,IF(AND('B - Year 1'!C113>0,'B - Year 2'!C111>0,'B - Year 3'!C111=\"\"),ROUND(('B - Year 1'!C113+'B - Year 2'!C111)/2,1),ROUND(('B - Year 1'!C113+'B - Year 2'!C111+'B - Year 3'!C111)/3,1))))","v":0},{"$f":"'B - Year 1'!D113+'B - Year 2'!D111+'B - Year 3'!D111","v":0},{"$f":"'B - Year 1'!E113+'B - Year 2'!E111+'B - Year 3'!E111","v":0},{"$f":"'B - Year 1'!F113+'B - Year 2'!F111+'B - Year 3'!F111","v":0},{"$f":"'B - Year 1'!G113+'B - Year 2'!G111+'B - Year 3'!G111","v":0},{"$f":"'B - Year 1'!L113","v":0},{"$f":"'B - Year 2'!L111","v":0},{"$f":"'B - Year 3'!L111","v":0},0]
[61,"Transportation",{"$f":"IF(AND('B - Year 1'!C114=\"\",'B - Year 2'!C112=\"\",'B - Year 3'!C112=\"\"),0,IF(AND('B - Year 1'!C114>0,'B - Year 2'!C112=\"\",'B - Year 3'!C112=\"\"),'B - Year 1'!C114,IF(AND('B - Year 1'!C114>0,'B - Year 2'!C112>0,'B - Year 3'!C112=\"\"),ROUND(('B - Year 1'!C114+'B - Year 2'!C112)/2,1),ROUND(('B - Year 1'!C114+'B - Year 2'!C112+'B - Year 3'!C112)/3,1))))","v":0},{"$f":"'B - Year 1'!D114+'B - Year 2'!D112+'B - Year 3'!D112","v":0},{"$f":"'B - Year 1'!E114+'B - Year 2'!E112+'B - Year 3'!E112","v":0},{"$f":"'B - Year 1'!F114+'B - Year 2'!F112+'B - Year 3'!F112","v":0},{"$f":"'B - Year 1'!G114+'B - Year 2'!G112+'B - Year 3'!G112","v":0},{"$f":"'B - Year 1'!L114","v":0},{"$f":"'B - Year 2'!L112","v":0},{"$f":"'B - Year 3'!L112","v":0},0]
[62,"Other (specify in Note Pad section):",{"$f":"IF(AND('B - Year 1'!C115=\"\",'B - Year 2'!C113=\"\",'B - Year 3'!C113=\"\"),0,IF(AND('B - Year 1'!C115>0,'B - Year 2'!C113=\"\",'B - Year 3'!C113=\"\"),'B - Year 1'!C115,IF(AND('B - Year 1'!C115>0,'B - Year 2'!C113>0,'B - Year 3'!C113=\"\"),ROUND(('B - Year 1'!C115+'B - Year 2'!C113)/2,1),ROUND(('B - Year 1'!C115+'B - Year 2'!C113+'B - Year 3'!C113)/3,1))))","v":0},{"$f":"'B - Year 1'!D115+'B - Year 2'!D113+'B - Year 3'!D113","v":0},{"$f":"'B - Year 1'!E115+'B - Year 2'!E113+'B - Year 3'!E113","v":0},{"$f":"'B - Year 1'!F115+'B - Year 2'!F113+'B - Year 3'!F113","v":0},{"$f":"'B - Year 1'!G115+'B - Year 2'!G113+'B - Year 3'!G113","v":0},{"$f":"'B - Year 1'!L115","v":0},{"$f":"'B - Year 2'!L113","v":0},{"$f":"'B - Year 3'!L113","v":0},0]
[63,"Total Indirect (Sum of Lines 40 - 62) ",{"$f":"SUM(C92:C114)","v":0},{"$f":"'B - Year 1'!D116+'B - Year 2'!D114+'B - Year 3'!D114","v":0},{"$f":"'B - Year 1'!E116+'B - Year 2'!E114+'B - Year 3'!E114","v":0},{"$f":"'B - Year 1'!F116+'B - Year 2'!F114+'B - Year 3'!F114","v":0},{"$f":"'B - Year 1'!G116+'B - Year 2'!G114+'B - Year 3'!G114","v":0},{"$f":"SUM(H92:H114)","v":0},0,0,0]
[]
[64,"Grand Total (Lines 39 + 63)",{"$f":"C85+C115","v":0},{"$f":"'B - Year 1'!D118+'B - Year 2'!D116+'B - Year 3'!D116","v":0},{"$f":"'B - Year 1'!E118+'B - Year 2'!E116+'B - Year 3'!E116","v":0},{"$f":"'B - Year 1'!F118+'B - Year 2'!F116+'B - Year 3'!F116","v":0},{"$f":"'B - Year 1'!G118+'B - Year 2'!G116+'B - Year 3'!G116","v":0},{"$f":"H85+H115","v":0},0,0,0]
[]
[65,"Provider In-kind Contributions",null,null,null,null,{"$f":"'B - Year 1'!G120+'B - Year 2'!G118+'B - Year 3'!G118","v":0},"Provider In-kind Contributions",null,null,{"$f":"'B - Year 1'!L120+'B - Year 2'!L118+'B - Year 3'!L118","v":0}]
[66,"Incremental Revenue To Offset (projected)",null,null,null,null,{"$f":"'B - Year 1'!G121+'B - Year 2'!G119+'B - Year 3'!G119","v":0},"Incremental Revenue To Offset (projected)",null,null,{"$f":"'B - Year 1'!L121+'B - Year 2'!L119+'B - Year 3'!L119","v":0}]
[]
[67,"Total VAP/Safety Net Funding Requested",null,null,null,null,{"$f":"'B - Year 1'!G123+'B - Year 2'!G121+'B - Year 3'!G121","v":0},"Total VAP/Safety Net Funding",null,null,{"$f":"K117-K119-K120","v":0}]

{"sheet":"Combine all facilities (2)","index":10,"n_rows":3,"n_cols":20,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,2,0],[0,1,0,12],[0,13,0,15],[0,16,1,18],[0,19,2,19],[1,1,1,3],[1,4,1,6],[1,7,1,9],[1,10,1,12],[1,13,1,15]]}
["Facility Name","Operating Expenses-Direct",null,null,null,null,null,null,null,null,null,null,null,"Operating Expenses-Indirect ",null,null,"Total Direct and Indirect Expenses",null,null,"Grand Total"]
[null,"Total Inpatient",null,null,"Total Outpatient",null,null,"Total Ancillary",null,null,"Total Direct",null,null,"Total Indirect"]
[null,"Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense","Year 1 Total Actual Expense","Year 2 Total Actual Expense","Year 3 Total Actual Expense"]

{"sheet":"C - Macros Instructions","index":11,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,32,8],[1,1,1,8],[28,1,28,8],[29,1,29,8],[30,1,30,8],[31,1,31,8]]}
[]
[null,"IMPORTANT NOTICE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This file contains macros for the Project Timeline tab to generate the correct number of Action/Activity Item Forms and related Print specifications for each year of the project.  The macros are run by clicking on the respective \"Make Forms\" button and \"Set Print Area\" button for each year once the correct number of action/activity items for the given year has been entered in cell C6. "]
[null,"To enable the macros to operate, you must first: "]
[null,"    - Click the \"Options\" button in the \"Security Warning\" tool bar "]
[null,"    - Select \"Enable this content\" "]
[null,"    - Select the \"OK\" button "]

{"sheet":"C - Instructions","index":12,"n_rows":53,"n_cols":2,"rows_kept":53,"cut":false,"hidden":false,"merged":[[53,1,53,14],[41,1,41,14],[42,1,42,14],[43,1,43,14],[44,1,44,14],[45,1,45,14],[46,1,46,14],[47,1,47,14],[48,1,48,14],[50,1,50,14],[51,1,51,14],[52,1,52,14],[49,1,49,14],[40,1,40,14],[0,1,0,14],[1,1,1,14],[2,1,2,14],[4,1,4,14],[35,1,35,14],[36,1,36,14],[37,1,37,14],[38,1,38,14],[39,1,39,14],[3,1,3,14]]}
[null,"Vital Access Provider (VAP) Funding"]
[null,"Medicaid Rate Adjustment"]
[null,"Project Timeline"]
[]
[null,"The following instructions should be utilized when completing the Project Timeline tab of the VAP report"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Setting up the report: The Project Timeline form has limited flexibility. Please do not change the format of the form. This is to avoid data input errors and to allow for the efficient aggregation of the data once received. "]
[]
["# 1","Fill in the number of Action/Activity Items the VAP plan has for the year indicated.  When the \"Make Forms\" button is selected, the number you input in cell C6 will generate the appropriate number of Action/Activity Item forms for the given year.  You must Hit Enter or Click Outside of cell C6, as the macro will only work if the data is properly \"entered\" in cell C6.  Make sure the appropriate number of Action/Activity Items is determined prior to selecting the \"Make Forms\" button, as running the \"Make Forms\" macro for the given year will prohibit step # 1 from being done again for that year.  "]
["# 2","Click on the “Make Forms” button to generate a set of Steps 1-10 for each discrete Action/Activity Item.  The \"Make Forms\" button will only work once for each given year."]
["# 3","Action/Activity Item: Input a short description of the impact the Action/Activity Item is intended to have on achieving long term financial stability, meeting community service needs, improving quality care and health equity (e.g., reconfiguration for greater access to primary care services, meeting community health needs, integration with other providers, merger/closure's intent, addresses disparities in health services, provides care to vulnerable populations, patient centered care, improves patient outcomes, reduces inpatient stays, increases access to ambulatory care services, or reconfigures business strategy)."]
["# 4","Overall Goal/Objective: Input a brief description of the observable and measurable results to be achieved. "]
["# 5","Steps for Action/Activity: Input a brief description of the events which need to be completed in order to achieve the Overall Goal/Objective."]
["# 6","Planned Completion Date: Fill in the date on which the Steps are planned to be achieved. Use MM/DD/YYYY format."]
["# 7","Qtrly Projected Expenses: Provide the estimated/predetermined cost of performing the Steps for the Action/Activity Item (rounded to the nearest whole dollar)."]
["# 8","Total Year # Projected Expense: Total of the Qtrly Projected Expense Amounts. (Automatically calculated.) "]
["# 9","Actual Completion Date: Fill in the actual date of completion for each given Step. Use MM/DD/YYYY format."]
["# 10","Qtrly Actual Expenses: Report the actual amounts paid / incurred to perform the Steps for the Action/Activity Item (rounded to the nearest whole dollar)."]
["# 11","Total Year # Actual Expense: Total of the Qtly Actual Expense Amounts. (Automatically calculated.) "]
["# 12","Submission Date: Date will auto fill from \"B - Year 1\" tab. As a reminder, this date must be updated with each Quarterly Report filing."]
["#12a","Begin Date of First Full Quarter: Date will auto fill from \"B - Year 1\" tab."]
["# 13","Outcome: Provide a short description of the end result of the Action/Activity Item."]
[]
[null,"Printing Instructions: Click on the “Set Print Area” button in the year you wish to print. Then print using \"file print\" or the printer icon (if applicable on your software) to print as you would normally print an Excel document."]

{"sheet":"C - Timeline","index":13,"n_rows":24,"n_cols":45,"rows_kept":24,"cut":false,"hidden":false,"merged":[[14,1,14,2],[14,16,14,17],[14,31,14,32],[23,0,24,3],[17,1,17,2],[17,16,17,17],[17,31,17,32],[18,1,18,2],[18,16,18,17],[18,31,18,32],[23,15,24,18],[23,30,24,33],[21,0,21,3],[21,30,21,33],[21,15,21,18],[12,16,12,17],[12,31,12,32],[13,1,13,2],[13,16,13,17],[13,31,13,32],[0,0,2,14],[0,15,2,29],[0,30,2,44],[19,1,19,2],[19,16,19,17],[19,31,19,32],[15,1,15,2],[15,16,15,17],[15,31,15,32],[16,1,16,2],[16,16,16,17],[16,31,16,32],[11,1,11,2],[11,16,11,17],[11,31,11,32],[12,1,12,2],[3,0,3,14],[3,15,3,29],[3,30,3,44],[10,31,10,32],[7,1,7,14],[7,16,7,29],[7,31,7,44],[9,30,9,32],[10,1,10,2],[10,16,10,17],[9,0,9,2],[9,15,9,17],[6,31,6,42],[6,16,6,27],[6,1,6,12],[4,0,4,2],[4,15,4,17],[4,13,5,13],[4,14,5,14],[4,3,5,12],[4,18,5,27],[4,43,5,43],[4,44,5,44],[4,33,5,42],[4,28,5,28],[4,29,5,29],[4,30,4,32]]}
["Vital Access Provider (VAP) Funding\nMedicaid Rate Adjustment\nProject Timeline Year 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vital Access Provider (VAP) Funding\nMedicaid Rate Adjustment\nProject Timeline Year 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vital Access Provider (VAP) Funding\nMedicaid Rate Adjustment\nProject Timeline Year 3"]
[]
[]
["           See Instructions                                                                                                                                                                                   See Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           See Instructions                                                                                                                                                                                   See Instructions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"           See Instructions                                                                                                                                                                                   See Instructions"]
["Action/Activity Item",null,null,null,null,null,null,null,null,null,null,null,null,"Submission Date",{"$f":"IF('B - Year 1'!C32=\"\",\"\",(EDATE('B - Year 1'!C32,0)))","v":""},"Action/Activity Item",null,null,null,null,null,null,null,null,null,null,null,null,"Submission Date",{"$f":"O5","v":""},"Action/Activity Item",null,null,null,null,null,null,null,null,null,null,null,null,"Submission Date",{"$f":"O5","v":""}]
[1,"of",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"of",null,null,null,null,null,null,null,null,null,null,null,null,null,1,"of"]
["Overall Goal / Objective",null,null,null,null,null,null,null,null,null,null,null,null,"Begin Date of First Quarter",{"$f":"IF('B - Year 1'!J32=\"\",\"\",(EDATE('B - Year 1'!J32,0)))","v":""},"Overall Goal / Objective",null,null,null,null,null,null,null,null,null,null,null,null,"Begin Date of First Quarter",{"$f":"IF(O7=\"\",\"\",EDATE(O7,12))","v":""},"Overall Goal / Objective",null,null,null,null,null,null,null,null,null,null,null,null,"Begin Date of First Quarter",{"$f":"IF(O7=\"\",\"\",EDATE(O7,24))","v":""}]
["Outcome",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Outcome"]
[]
["Steps for Action/Activity",null,null,"Planned Completion Date","Qtr 1    Projected Expense","Qtr 2    Projected Expense","Qtr 3    Projected Expense","Qtr 4    Projected Expense","Total Year 1    Projected Expense","Actual Completion Date","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total Year 1 Actual Expense","Steps for Action/Activity",null,null,"Planned Completion Date","Qtr 1    Projected Expense","Qtr 2    Projected Expense","Qtr 3    Projected Expense","Qtr 4    Projected Expense","Total Year 2    Projected Expense","Actual Completion Date","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total Year 2 Actual Expense","Steps for Action/Activity",null,null,"Planned Completion Date","Qtr 1    Projected Expense","Qtr 2    Projected Expense","Qtr 3    Projected Expense","Qtr 4    Projected Expense","Total Year 3    Projected Expense","Actual Completion Date","Qtr 1 Actual Expense","Qtr 2 Actual Expense","Qtr 3 Actual Expense","Qtr 4 Actual Expense","Total Year 3 Actual Expense"]
["Step 1",null,null,null,null,null,null,null,{"$f":"+SUM(E11:H11)","v":0},null,null,null,null,null,{"$f":"+SUM(K11:N11)","v":0},"Step 1",null,null,null,null,null,null,null,{"$f":"+SUM(T11:W11)","v":0},null,null,null,null,null,{"$f":"+SUM(Z11:AC11)","v":0},"Step 1",null,null,null,null,null,null,null,{"$f":"+SUM(AI11:AL11)","v":0},null,null,null,null,null,{"$f":"+SUM(AO11:AR11)","v":0}]
["Step 2",null,null,null,null,null,null,null,{"$f":"+SUM(E12:H12)","v":0},null,null,null,null,null,{"$f":"+SUM(K12:N12)","v":0},"Step 2",null,null,null,null,null,null,null,{"$f":"+SUM(T12:W12)","v":0},null,null,null,null,null,{"$f":"+SUM(Z12:AC12)","v":0},"Step 2",null,null,null,null,null,null,null,{"$f":"+SUM(AI12:AL12)","v":0},null,null,null,null,null,{"$f":"+SUM(AO12:AR12)","v":0}]
["Step 3",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 3",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 3",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 4",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 4",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 4",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 5",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 5",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 5",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 6",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 6",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 6",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 7",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 7",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 7",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 8",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 8",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 8",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 9",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 9",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 9",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
["Step 10",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 10",null,null,null,null,null,null,null,0,null,null,null,null,null,0,"Step 10",null,null,null,null,null,null,null,0,null,null,null,null,null,0]
[]
[{"$f":"\"Total for Activity #\"&A6","v":"Total for Activity #1"},null,null,null,{"$f":"SUM(E11:E20)","v":0},{"$f":"SUM(F11:F20)","v":0},0,0,0,null,{"$f":"SUM(K11:K20)","v":0},0,0,0,0,{"$f":"\"Total for Activity #\"&P6","v":"Total for Activity #1"},null,null,null,{"$f":"SUM(T11:T20)","v":0},{"$f":"SUM(U11:U20)","v":0},0,0,0,null,{"$f":"SUM(Z11:Z20)","v":0},0,0,0,0,{"$f":"\"Total for Activity #\"&AE6","v":"Total for Activity #1"},null,null,null,{"$f":"SUM(AI11:AI20)","v":0},{"$f":"SUM(AJ11:AJ20)","v":0},0,0,0,null,{"$f":"SUM(AO11:AO20)","v":0},0,0,0,0]
[]
["Year 1 Grand Total of Projected and Actual Expenses",null,null,null,"Total Year 1 Qtr 1 VAP Projected Expense","Total Year 1 Qtr 2 VAP Projected Expense","Total Year 1 Qtr 3 VAP Projected Expense","Total Year 1 Qtr 4 VAP Projected Expense","Total Year 1 VAP Projected Expense",null,"Total Year 1 Qtr 1 VAP       Actual Expense","Total Year 1 Qtr 2 VAP       Actual Expense","Total Year 1 Qtr 3 VAP       Actual Expense","Total Year 1 Qtr 4 VAP       Actual Expense","Total Year 1 VAP Actual Expense","Year 2 Grand Total of Total Projected and Actual Expenses",null,null,null,"Total Year 2 Qtr 1 VAP Projected Expense","Total Year 2 Qtr 2 VAP Projected Expense","Total Year 2 Qtr 3 VAP Projected Expense","Total Year 2 Qtr 4 VAP Projected Expense","Total Year 2 VAP Projected Expense",null,"Total Year 2 Qtr 1 VAP       Actual Expense","Total Year 2 Qtr 2 VAP       Actual Expense","Total Year 2 Qtr 3 VAP       Actual Expense","Total Year 2 Qtr 4 VAP       Actual Expense","Total Year 2 VAP Actual Expense","Year 3 Grand Total of Total Projected and Actual Expenses",null,null,null,"Total Year 3 Qtr 1 VAP Projected Expense","Total Year 3 Qtr 2 VAP Projected Expense","Total Year 3 Qtr 3 VAP Projected Expense","Total Year 3 Qtr 4 VAP Projected Expense","Total Year 3 VAP Projected Expense",null,"Total Year 3 Qtr 1 VAP       Actual Expense","Total Year 3 Qtr 2 VAP       Actual Expense","Total Year 3 Qtr 3 VAP       Actual Expense","Total Year 3 Qtr 4 VAP       Actual Expense","Total Year 3 VAP Actual Expense"]

{"sheet":"D - Narrative","index":14,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":false,"merged":[[8,0,8,1],[0,0,0,1],[2,0,2,1],[5,0,5,1],[6,0,6,1],[7,0,7,1]]}
["OUTLINE FOR VAP/SAFETY NET QUARTERLY PROGRESS REPORT\n~ RESTRUCTURING PROGRAM WORK PLAN ~\n\nThis Attachment is to provide to the Department a narrative of the facility’s Work Plan in the table below.\n1.  SUMMARY STATEMENT\nThis section should include a narrative describing the progress made on the Project being funded by the Agreement.  This overview should be concise and to the point.  Further details can be included in the section which addresses specific deliverables.\n2.  PROGRAM GOALS\nThis section should include details on the current status toward reaching the goals and objectives expected to be accomplished under the terms of the Agreement.  Project goals should be quantified as much as possible.  The Report on the Restructuring Program Work Plan (Work Plan) must include:\na. specific actions taken during the quarter for achieving long term financial stability, including the current status of Department approved benchmarks used to measure performance in achieving the goals;\nb. address how the project is ensuring that the healthcare needs of the community are being met, including any actionable plan developed in collaboration with community and/or regional stakeholders;\nc. a detailed analysis of performance measurements, as agreed to by the Facility and approved by the Department per the Work Plan, targeting improvement in the quality of care provided;\nd. address disparities in health services and how the project will help to provide better care to vulnerable populations who are at greater risk for experiencing poorer health outcomes than the general population."]
["Facility:"]
["VAP/Safety Net Quarterly Narrative Report - Attachment D"]
["First Quarter:",{"$f":"IF('B - Year 1'!J32=\"\",\"\",EDATE('B - Year 1'!J32,0))","v":""}]
["Submission Date:",{"$f":"IF('B - Year 1'!C32=\"\",\"\",(EDATE('B - Year 1'!C32,0)))","v":""}]
["Summary Statement:"]
[]
["Program Goals:"]

{"sheet":"E -Instructions","index":15,"n_rows":47,"n_cols":3,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Instructions"]
[null,"Note: There are 3 separate \"Metric\" tabs that must be filled out, each with a different category of metrics (Financial, Operating, and Quality) These instructions are the same for each tab. ","See \"E - Financial\", \"E - Operating\", and \"E - Quality\" tabs"]
[null,"Note: Use the objectives found in the Timeline to determine how many Objectives you have for each category of metrics.","See \"C - Instructions\" - #4"]
[1,"Enter the number of objectives in cell C5 (highlighted Yellow). Click outside of the cell."]
[null,"Note: When the \"Create Forms\" button is selected, the number you input in cell C5 will generate the appropriate number of Objectives.  You must hit Enter or click outside of cell C5, as the macro will only work if the data is properly \"entered\" in cell C5.  Make sure the appropriate number of Objectives is determined prior to selecting the \"Create Forms\" button, as running the \"Create Forms\" macro for the given year will prohibit step this from being done again for that category of metrics.  "]
[2,"Click the \"Create Forms\" button."]
[3,"Objectives: Use the objectives found in the tab \"C - Timeline\" to fill in each objective "]
[4,"Metrics: List all of the metrics used to measure the success of each objective."]
[5,"Description of Metric: Provide a short explanation/description of the measurement"]
[6,"Unit of Measure: Indicate the unit of measure used for your 'Projected' and 'Result' numbers. [For Example: Visits per week or Percent (%) increase in patients, etc.]."]
["*7","Baselines: Provide a baseline measurement (what the metric measures before the program starts) If the metric is measuring part of a new initiative (with no baseline), enter \"N/A\""]
["*8","Projected Values: For every year (1-3), fill in the each of the quarterly projections for all of the metrics (NUMERICAL VALUE ONLY)."]
["*9","Actual Results: Fill in the actual results for past quarters  (NUMERICAL VALUE ONLY)."]
[null,"*Fill in ONLY numerical Baselines, Projected numbers and Results."]
[]
[null,"Examples of Operational Metrics:"]
[null,"• Increase Primary care visits"]
[null,"• Reduce inpatient admissions"]
[null,"• Improved patient throughput in ED and ambulatory services "]
[null,"• Close beds"]
[null,"Examples of Financial Metrics:"]
[null,"• Improve operating margin"]
[null,"• Decrease ED costs"]
[null,"• Reduce operating costs"]
[null,"Examples of Quality Metrics:"]
[null,"• Reduce percentage of Medicaid in PPRs/PPAs"]
[null,"• Reduce readmissions"]
[null,"• Increase Patient satisfaction"]

{"sheet":"E - Operating","index":16,"n_rows":12,"n_cols":31,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[5,29,5,30],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,9,5,10],[5,11,5,12],[4,7,4,14],[5,25,5,26],[5,27,5,28],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,6,6,6],[5,7,5,8],[5,5,6,5],[0,0,0,3],[3,0,3,2],[3,3,4,6],[4,15,4,22],[4,23,4,30]]}
["Operating Metrics"]
[]
[]
["Objective",null,null,null,null,null,null,"Start Date",null,{"$f":"IF('B - Year 1'!J32=\"\",\"\",(EDATE('B - Year 1'!J32,0)))","v":""},null,null,null,null,null,"Start Date",null,{"$f":"IF(J4=\"\",\"\",EDATE(J4,12))","v":""},null,null,null,null,null,"Start Date",null,{"$f":"IF(J4=\"\",\"\",EDATE(J4,24))","v":""}]
[null,"of",null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,"Year 3"]
["#",null,null,"Metric","Description","Unit of Measure","Baseline","Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4",null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4",null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4"]
[null,null,null,null,null,null,null,"Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result"]
[1]
[2]
[3]
[4]
[5]

{"sheet":"E - Quality","index":17,"n_rows":12,"n_cols":31,"rows_kept":12,"cut":false,"hidden":false,"merged":[[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[5,29,5,30],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,9,5,10],[5,11,5,12],[4,7,4,14],[5,25,5,26],[5,27,5,28],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,6,6,6],[5,7,5,8],[5,5,6,5],[0,0,0,3],[3,0,3,2],[3,3,4,6],[4,15,4,22],[4,23,4,30]]}
["Quality Metrics"]
[]
[]
["Objective",null,null,null,null,null,null,"Start Date",null,{"$f":"IF('B - Year 1'!J32=\"\",\"\",(EDATE('B - Year 1'!J32,0)))","v":""},null,null,null,null,null,"Start Date",null,{"$f":"IF(J4=\"\",\"\",EDATE(J4,12))","v":""},null,null,null,null,null,"Start Date",null,{"$f":"IF(J4=\"\",\"\",EDATE(J4,24))","v":""}]
[null,"of",null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,"Year 2 ",null,null,null,null,null,null,null,"Year 3"]
["#",null,null,"Metric","Description","Unit of Measure","Baseline","Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4",null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4",null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4"]
[null,null,null,null,null,null,null,"Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result"]
[1]
[2]
[3]
[4]
[5]

{"sheet":"E - Financial","index":18,"n_rows":14,"n_cols":31,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,0,7,2],[8,0,8,2],[9,0,9,2],[10,0,10,2],[11,0,11,2],[5,29,5,30],[5,13,5,14],[5,15,5,16],[5,17,5,18],[5,19,5,20],[5,21,5,22],[5,23,5,24],[5,9,5,10],[5,11,5,12],[4,7,4,14],[5,25,5,26],[5,27,5,28],[5,0,6,2],[5,3,6,3],[5,4,6,4],[5,6,6,6],[5,7,5,8],[5,5,6,5],[0,0,0,3],[3,0,3,2],[3,3,4,6],[4,15,4,22],[4,23,4,30]]}
["Financial Metrics"]
[]
[]
["Objective",null,null,null,null,null,null,"Start Date",null,{"$f":"IF('B - Year 1'!J32=\"\",\"\",(EDATE('B - Year 1'!J32,0)))","v":""},null,null,null,null,null,"Start Date",null,{"$f":"IF(J4=\"\",\"\",EDATE(J4,12))","v":""},null,null,null,null,null,"Start Date",null,{"$f":"IF(J4=\"\",\"\",EDATE(J4,24))","v":""}]
[null,"of",null,null,null,null,null,"Year 1",null,null,null,null,null,null,null,"Year 2",null,null,null,null,null,null,null,"Year 3"]
["#",null,null,"Metric","Description","Unit of Measure","Baseline","Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4",null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4",null,"Quarter 1",null,"Quarter 2",null,"Quarter 3",null,"Quarter 4"]
[null,null,null,null,null,null,null,"Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result","Projected","Result"]
[1]
[2]
[3]
[4]
[5]
[]
[" "]