{"text_format":"1","workbook":"xlsx","n_sheets":33,"sheets":["Title Page","Table of Contents","About This File","C.I.A.","C.I.B.","C.I.C.","C.I.E.","C.I.E. Crosswalk","C.I.F.AAA","C.I.F.(1)","C.I.F.(2)","C.I.F.(3)","C.I.F.(4)","C.I.F.(5)","C.I.F.(6)","C.I.F.(7)","C.I.F.(8)","C.I.F.(9)","C.I.F.(10)","C.I.F.(11)","C.I.F.(12)","C.I.F.(13)","C.I.F.(14)","C.I.F.(15)","C.I.F.(16)","C.I.G.","C.II.A.","C.II.B.","C.II.C.","C.III","C.IV","C.V","Attachments"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":119,"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":"Title Page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Table of Contents","index":1,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,2],[0,0,0,2]]}
["Contract Module Table of Contents",null,null,":)"]
["Instructions: Enter the page number that begins each section in the \"Page\" column. Page numbers are automatically added to each tab in this file; use these page numbers to complete this Table of Contents. If additional tabs are added, they should be added to this page as well. To identify the page numbers assigned to each tab/section, right-click on any tab, and select \"Select All Sheets\" from the menu; then select \"Print Preview\" from the File menu. Remember to \"deselect\" all tabs when done by clicking on any tab other than the active tab, making only one tab white (the others gray). Click on underlined text to move to the named tab. Sections not underlined are located in a separate file, Contract Module Part II."]
[]
["Section","Item","Page"]
["Section C.I.A.","Allocation to the Planning and Service Area (PSA)"]
["Section C.I.B.","OAA Title IIIB Services Expenditures"]
["Section C.I.C.","Service Units and Costs Projections - Provider Summary "]
["Section C.I.E.","Service Units and Cost Projections - PSA Summary"]
[]
["Section C.I.F.AAA.","Areawide Funding Profile"]
["Section C.I.F.","County Funding Profile"]
["Section C.I.G.","Areawide Funding Summary"]
["Section C.II.A.","AAA Administration Budget"]
["Section C.II.B.","OAA Budget Summary"]
["Section C.II.C.","Financial and Compliance Audit Schedule"]
["Section C.III","AAA Monitoring Schedule"]
["Section C.IV","Contract Providers"]
["Section C.V","Contract Module Review Checklist"]
["Attachments","Contract Module Attachments"]

{"sheet":"About This File","index":2,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["About This Contract Module File",":)"]
["Instructions:\n1. All information needed in the Contract Module portion of your area plan should be placed in this Excel workbook (Contract Module.xls) or a separate file referenced in this workbook. If you want to include additional information in this workbook, you may insert the information in one or more new worksheets. Worksheets can be created/inserted by selecting \"Worksheet\" from the Insert menu.  If you want to link to other files, the names of the files must be referenced in the Attachments tab in this workbook. Add the names of additional worksheets included in the workbook to the list of attachments. Do not include in the list of attachments worksheets that are already provided in the Contract Module.\n\n"]
["2. Enter your PSA number on the first page in the blank next to \"PSA\" and in the first row of each worksheet next to the text \"PSA.\" If you are entering information for the original submittal of the contract module for the year, enter the date the file will be submitted to the Department next to the text \"Original Submission Date.\" If you are updating information in the worksheet after the original submission, do not change the original submission date; instead enter the date the contract module is being resubmitted next to the text \"Resubmission Date.\""]
["3. Instructions have been included in italics in a row at the top of most worksheets.  After completing the contract module, we recommend the Instructions row in each worksheet be hidden to make the document more readable. To hide the row, highlight the row and select \"Row/Hide\" from the Format menu."]
["General Information About Colors Used in This Workbook"]
["Cells in this workbook are color coded as follows:"]
["Purple cells are calculated (contain formulas). Data should not be typed into purple cells. "]
["Yellow cells require your input. The information should come directly from the allocation spreadsheet issued by the Department. "]
["Aqua fields require your input, if applicable.  "]
["Gray cross-hatched cells are not applicable and should not be updated."]

{"sheet":"C.I.A.","index":3,"n_rows":46,"n_cols":13,"rows_kept":46,"cut":false,"hidden":false,"merged":[[42,6,42,9],[43,6,43,9],[44,6,44,9],[31,6,31,9],[32,6,32,9],[33,6,33,9],[34,6,34,9],[35,6,35,9],[36,6,36,9],[41,6,41,9],[38,6,38,9],[40,6,40,9],[37,6,37,9],[27,6,27,10],[28,6,29,9],[30,6,30,9],[32,0,32,2],[33,0,33,2],[45,6,45,9],[3,0,3,11],[38,0,38,2],[37,0,37,2],[36,0,36,2],[35,0,35,2],[34,0,34,2],[30,0,30,2],[31,0,31,2],[4,0,4,11],[7,0,7,11],[24,0,24,11],[28,0,29,2],[27,0,27,3],[5,0,5,11],[25,0,25,11]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,null,null,null,null,null,null,":)"]
[]
["C.I.A. -  Allocation to the Planning and Service Area "]
["This worksheet documents all funds allocated to the PSA. The “Original Allocation” row contains the continuation budget amount issued in the original contract for the year. The amount on this line does not change. The “Revised Allocation” line is the amount of the allocations after the actual federal grant award for the year is received. It is also where subsequent changes in allocations via contract amendments are reflected.  "]
["Less (-) Transfer Amount and Plus (+) Transfer Amount contain transfers between titles. The amounts must be within allowable percentages: B to C or C to B can be no more than 30 percent (i.e., B ↔ [C1+C2]); amounts transferred between C1 and C2 can be no more than 40 percent of the source title (not the combined amount of [C1+C2]. Adjusted Amount is the total after the transfers. Carry Forward Funds must be exact amounts and allocated to the titles in which they were awarded. Total Funds equals the total after all adjustments have been made. Total OAA plus the GR AAA admin will equal the contract amount. State General Revenue Allocations and Supplemental Resource Activities (State, Federal, and Private) should match current contract amounts and the amounts detailed in CIRTS.  Transfer Amount sums up transfers recorded in previous four columns."]
["Instructions:\nUpdate all yellow and aqua-colored cells as appropriate. Purple cells are calculated automatically. For Title IIIB, C1, and C2, include the total amount for Title IIIB, C1, and C2 services in the table.  Indicate below the table, the portion of the total maintained by the AAA as Title IIIB LAN set aside and Title IIIB, C1, and C2 Disaster Recovery Reserves. The Title IIIB LAN set aside currently approved by the Department cannot be increased. The Title IIIB, CI, and CII Disaster Recovery Reserves must remain in reserve until the need arises, when the Department will issue further guidance.  In accordance with the requirement for Area Agencies to describe all activities of the Agency, whether funded by public or private funds, and ensuring the Agency is managing the availability of financial resources for programs and services used to carry out programs for the elderly the operating budget must include ALL of the sources of funding and be included in the spreadsheets. (OAA and Chapter 430.2053, F.S) (Board and other non-DOEA funds should go under OTHERS.)"]
[]
["      C.1.A - FEDERAL ALLOCATION TO THE PLANNING AND SERVICE AREA  "]
[]
["OAA FEDERAL FUNDING","AAA","TITLE","TITLE","TITLE","TRANSFER","TITLE","TITLE",null,"TITLE","TOTAL OAA"]
["COMPOSITION","ADMIN","IIIB","IIIC1","IIIC2","AMOUNT","IIID","IIIE","NSIP","VII","Minus VII"]
["Original Allocation\nFFY 2019-20",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B12:E12)+SUM(G12:I12)","v":0}]
["Revised Allocation\nFFY 2019-20",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B13:E13)+SUM(G13:I13)","v":0}]
["Less (-)\nTransfer Amount",null,null,null,null,{"$f":"SUM(B14:E14)","v":0},null,null,null,null,{"$f":"SUM(B14:E14)","v":0}]
["Plus (+)\nTransfer Amount",null,null,null,null,{"$f":"SUM(B15:E15)","v":0},null,null,null,null,{"$f":"SUM(B15:E15)","v":0}]
["Adjusted Amount\nFFY 2019-20",{"$f":"SUM(B12:B15)","v":0},{"$f":"SUM(C12:C15)","v":0},{"$f":"SUM(D12:D15)","v":0},{"$f":"SUM(E12:E15)","v":0},null,{"$f":"SUM(G12:G15)","v":0},{"$f":"SUM(H12:H15)","v":0},{"$f":"SUM(I12:I15)","v":0},{"$f":"SUM(J12:J15)","v":0},{"$f":"SUM(B16:E16)+SUM(G16:I16)","v":0}]
["Carry Forward Funds\nFFY 2018-19",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B17:J17)","v":0}]
["TOTAL FUNDS",{"$f":"B16+B17","v":0},{"$f":"C16+C17","v":0},{"$f":"D16+D17","v":0},{"$f":"E16+E17","v":0},{"$f":"F14+F15","v":0},{"$f":"G16+G17","v":0},{"$f":"H16+H17","v":0},{"$f":"I16+I17","v":0},{"$f":"J16+J17","v":0},{"$f":"SUM(B18:I18)","v":0}]
[]
[null,"Title III B Total Funds include $",null," in set aside funds (included in the Title III B column)."]
[null,"Disaster Recovery Reserves include $",null,null,null,"in set-aside funds (included in IIIB, C1, and C2 columns)."]
[]
[]
[]
[" STATE GENERAL REVENUE ALLOCATION TO THE PLANNING AND SERVICE AREA  "]
["The State General Revenue Allocations and Supplemental Resource Activities (State, Federal, and Private) below should match current contract amounts."]
[]
["STATE GENERAL REVENUE ALLOCATIONS",null,null,null,null,null," SUPPLEMENTAL RESOURCE ACTIVITIES \n(STATE, FEDERAL & PRIVATE)"]
["FUNDING COMPOSITION",null,null,"SFY 2019-20",null,null,"SOURCE OF FUNDING",null,null,null,"AMOUNT"]
[null,null,null,"GR AMOUNTS",null,null,null,null,null,null,"OF FUNDING"]
["AAA ADMINISTRATION",null,null,null,null,null,"EHEAP SERVICES"]
["CCE ADMINISTRATION",null,null,null,null,null,"EHEAP ADMINISTRATION"]
["CCE SERVICES",null,null,null,null,null,"EHEAP OUTREACH"]
["HCE ADMINISTRATION",null,null,null,null,null,"MED WAIVER SPECIALIST"]
["HCE SUBSIDY & CASE MANAGEMENT",null,null,null,null,null,"SHINE"]
["ADI ADMINISTRATION",null,null,null,null,null,"RELIEF"]
["ADI SERVICES",null,null,null,null,null,"ADRC (MAC)"]
["LSP ADMINISTRATION",null,null,null,null,null,"Families First Act"]
["LSP SERVICES",null,null,null,null,null,"CARES Act"]
[null,null,null,null,null,null,"EHEAP - CARES Act"]
[null,null,null,null,null,null,"ADRC - CARES Act"]
[null,null,null,null,null,null,"OTHERS (LIST BELOW):"]
[null,null,null,null,null,null,"Other 1"]
[null,null,null,null,null,null,"Other 2"]
[null,null,null,null,null,null,"Other 3"]
[null,null,null,null,null,null,"Other 4"]

{"sheet":"C.I.B.","index":4,"n_rows":33,"n_cols":7,"rows_kept":33,"cut":false,"hidden":false,"merged":[[26,0,26,5],[4,0,4,5],[10,0,10,5],[17,0,17,5]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.B. - OAA TITLE IIIB Services Expenditures "]
[]
["This worksheet documents OAA Title IIIB expenditures by service, with services categorized as priority services or non-priority services. \n\nInstructions: Update all aqua-colored cells as appropriate.  Purple cells are calculated automatically. Funds allocated for Access Services, In-Home Services, and Legal Assistance must be equal to or greater than the following percentages of the total Title IIIB Priority Services: Access services (20 percent), In-Home (8 percent), and Legal Assistance (1 percent)\n\nThe \"% of Total IIIB Allocation\" column total is calculated.  The total funds allocated on this sheet are divided by the total IIIB funds calculated on C.I.A.\n\nThe percentage in the \"Total IIIB\" row at the bottom must equal 100 percent. If  it does not, the amounts entered in the \"Funds Allocated\" column do not match those entered on tab C.I.A.\n\nIIIB LAN Set Aside and IIIB, C1, and C2 Disaster Recovery Reserve totals are calculated automatically, and included in the \"Total IIIB\".\n\nIIIB Non-Priority Services needs to include other funds allocated to the AAA not included in IIIB Priority Services."]
["Title IIIB Expenditures","Funds Allocated","% of Total IIIB Allocation","# Units of Services Provided","# of Unduplicated Consumers Served","% of Total 60+ Population*"]
["LAN Set-Aside",{"$f":"'C.I.A.'!$C$20","v":0},{"$f":"SUM(B7/'C.I.A.'!C18)","v":{"$error":"#DIV/0!"}}]
["Disaster Recovery Reserve",{"$f":"'C.I.A.'!$C$21","v":0},{"$f":"SUM(B8/'C.I.A.'!C18)","v":{"$error":"#DIV/0!"}}]
[]
["IIIB Priority Services"]
["Access Services"]
["Information",null,{"$f":"B12/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E12/E33","v":{"$error":"#DIV/0!"}}]
["Referral",null,{"$f":"B13/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E13/E33","v":{"$error":"#DIV/0!"}}]
["Outreach",null,{"$f":"B14/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E14/E33","v":{"$error":"#DIV/0!"}}]
["Transportation",null,{"$f":"B15/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E15/E33","v":{"$error":"#DIV/0!"}}]
["Subtotal",{"$f":"SUM(B12:B15)","v":0}]
[{"$f":"B16/B31","v":{"$error":"#DIV/0!"}},"= amount allocated for Access Services (must be equal to or greater than 20%)"]
["In-Home Services"]
["Homemaker",null,{"$f":"B19/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E19/E33","v":{"$error":"#DIV/0!"}}]
["Personal Care",null,{"$f":"B20/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E20/E33","v":{"$error":"#DIV/0!"}}]
["In-Home Respite",null,{"$f":"B21/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E21/E33","v":{"$error":"#DIV/0!"}}]
["Chore",null,{"$f":"B22/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E22/E33","v":{"$error":"#DIV/0!"}}]
["Companionship",null,{"$f":"B23/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E23/E33","v":{"$error":"#DIV/0!"}}]
["Telephone Reass.",null,{"$f":"B24/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E24/E33","v":{"$error":"#DIV/0!"}}]
["Subtotal",{"$f":"SUM(B19:B24)","v":0}]
[{"$f":"B25/B31","v":{"$error":"#DIV/0!"}},"= amount allocated for In-Home Services (must be equal to or greater than 8%)"]
["Legal Assistance"]
["Legal Assistance",null,{"$f":"B28/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E28/E33","v":{"$error":"#DIV/0!"}}]
[{"$f":"B28/B31","v":{"$error":"#DIV/0!"}},"= amount allocated for Legal Services (must be equal to or greater than 1%)"]
["IIIB Non-Priority Services",null,{"$f":"B30/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}}]
["Total  IIIB ",{"$f":"B7+B8+B16+B25+B28+B30","v":0},{"$f":"B31/'C.I.A.'!C18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D12:D15)+SUM(D19:D24)+D28+D30","v":0},{"$f":"SUM(E12:E15)+SUM(E19:E24)+E28+E30","v":0}]
[]
["* To have % total 60+ population computed, enter 60+ population:"]

{"sheet":"C.I.C.","index":5,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,0,3,6],[6,0,6,6],[4,0,4,6],[5,0,5,6]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,null,null,":)"]
[]
["C.I.C. - Service Units and Costs Projections - PSA Summary"]
["This worksheet lists the actual unit rate (what providers report as their actual costs to provide a unit of service) and the adjusted unit rate (the negotiated unit rate/what the Area Agency on Aging agrees to pay for a unit of service) for each service provider under direct contract with the AAA.\n\nServices provided directly by the AAA must also be included and reflect county allocations.\n\nService and client count projections must be included for each service and substantiate the funds allocated for each service."]
["Instructions: Part A - C.I.C. Service Units and Cost Projections - PSA Summary\nRun report #3, C.I.C. Service Units and Cost Projections - PSA Summary:\nRun a report for each federally funded and state-funded program:\nSelect Program,\nType in begin and end date:\nFor federally funded programs: type in 01/01/2021 to 12/31/2021; \nFor state-funded programs: type in 07/01/2020 to 06/30/2021"]
["Instructions: Part B - C.I.C. Service Units and Cost Projections - Provider Summary for AAA as Provider of Direct Services:\nRun report #3, C.I.C. Service Units and Cost Projections - Provider Summary for AAA as provider of direct services:\nRun a report for both the federally funded and the state-funded programs:\nSelect either federally funded or state funded from the drop-down \nSelect your AAA provider name and code:\nSelect Year 2020 for federally funded and 2019 for state-funded programs\nSelect Output Format type DELIMITEDDATA, then\n\"Click\" either the Run Report or Run Report in New Tab button. The latter will allow you to view the results of a number of reports simultaneously by switching windows rather than having to rerun the reports to view results."]
["Instructions: Inserting Data Into This Spreadsheet\nIn order to insert the data into this template, once you have the DELIMITEDDATA output from each report, \"select\" the data on the report output screen. This can be accomplished by clicking and holding the cursor on the screen and dragging the cursor across the screen ensuring that all the data is highlighted.\n\nNext, with all the data highlighted \"right click\" on the highlighted data and select copy from the menu provided.\n\nWith the data copied to the clipboard, navigate from the CIRTS report output screen to this template.\n\nSelect the destination cell in this template then \"right click\" in your destination cell and select \"Paste Special\" and text from the menus provided.\n\nTo finish the process, add a subtotal row to the data you just pasted into this spreadsheet.\n\nRepeat this process for each report you run pasting your data below any data previously entered into this spreadsheet.\n\nOnce you have completed inserting all your data into this spreadsheet, you can adjust the column headings to accommodate the labels from the data you've imported."]

{"sheet":"C.I.E.","index":6,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,8],[4,0,4,8],[5,0,5,8],[6,0,6,8]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,null,null,null,":)"]
[]
["C.I.E.- Service Units and Cost Projections — PSA Summary — All Programs"]
[]
["This worksheet displays for each program (except Medicaid waivers) the services provided and for each service the projected cost; number of units to be served; average unit rate; highest and lowest unit rate; and average, highest, and lowest contracted unit rate."]
["\nInstructions: C.I.E. Service Units and Costs Projections – PSA Summary – All Programs:  \nRun report number 7, C.I.E. Service Units and Costs Projections – PSA Summary – All Programs:\n  \nFor federally funded programs:\n     Select PSA \n     Select federally funded (01/01 to 12/31) \n     Select Year “2021” \nFor state-funded programs:\n     Select PSA\n     Select state-funded (07/01 to 06/30)\n     Select Year “2020”\n \nNote: Unduplicated client count and unit rate data must be reported in CIRTS.  Data entered in CIRTS must reconcile to contract amounts. Printouts from CIRTS for each of the general revenue programs and Older Americans Act titles are to be submitted with the Area Plan."]
["Instructions: Inserting Data Into This Spreadsheet\n\nIn order to insert the data into this template, once you have the DELIMITEDDATA output from each report, \"select\" the data on the report output screen. This can be accomplished by clicking and holding the cursor on the screen and dragging the cursor across the screen ensuring that all the data is highlighted.\n\nNext, with all the data highlighted \"right click\" on the highlighted data and select copy from the menu provided.\n\nWith the data copied to the clipboard, navigate from the CIRTS report output screen to this template.\n\nSelect the destination cell in this template then \"right click\" in your destination cell and select \"Paste Special\" and text from the menus provided.\n\nTo finish the process, add a subtotal row to the data you just pasted into this spreadsheet.\n\nRepeat this process for each report you run pasting your data below any data previously entered into this spreadsheet.\n\nOnce you have completed inserting all your data into this spreadsheet, you can adjust the column headings to accommodate the labels from the data you've imported."]

{"sheet":"C.I.E. Crosswalk","index":7,"n_rows":16,"n_cols":29,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,0,2,8],[4,0,4,8],[5,0,5,8]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,null,null,null,":)"]
[]
["Crosswalk of 2020 and 2021 OAA Services and Unit Costs"]
[]
["This worksheet displays for each OAA program the services provided, the highest unit rate for each service, and the differences in services and highest unit rate from one year to the next. AAAs shall confirm in the notes column which services are new and which have been removed. AAAs shall provide justification for any unit rate that has changed more than 5 percent, either as an increase or as a decrease."]
["Instructions: Inserting Data Into This Spreadsheet\n\nFollow the instructions in the C.I.E. Spreadsheet to capture Delimited Data for 2020 Services and insert them in this C.I.E. Crosswalk Spreadsheet. Then repeat with the 2021 Services and insert them to the right of the 2020 Services with column N as a separator. Hide columns C-F, H-M, Q-T, and V-Z. Add column AA \"Variance\" with the formula: =SUM(U11-G11). Add column AB \"% Change\" with the formula: =SUM(AA11/G11). Copy and paste these formulas for all rows. The \"% Change\" column has conditional formatting to highlight the cell if the rate has changed by more than 5 percent, either as an increase or as a decrease. An explanation must be provided for all rate adjustments more than 5 percent. There may need to be some manual manipulation to ensure services are lined up correctly to identify any changes between the two years. "]
[]
[]
[2020,2020,2018,2018,2018,2018,2020,2018,2018,2018,2018,2018,null,null,2021,2021,2019,2019,2019,2019,2021,2019,2019,2019,2019]
["PROGRAM","SERVICE","PSA","TOTAL_STATE_FEDERAL_SHARE","TOTAL_PROJECTED_SERVICE_UNITS","AVG_REIMBURSEMENT_UNIT_RATE","HIGH REIM","LOW_REIMBURSEMENT_UNIT_RATE","AVG_PROVIDER_COST_PER_UNIT","HIGH_PROVIDER_COST_PER_UNIT","LOW_PROVIDER_COST_PER_UNIT",null,null,null,"PROGRAM","SERVICE","PSA","TOTAL_STATE_FEDERAL_SHARE","TOTAL_PROJECTED_SERVICE_UNITS","AVG_REIMBURSEMENT_UNIT_RATE","HIGH REIM","LOW_REIMBURSEMENT_UNIT_RATE","AVG_PROVIDER_COST_PER_UNIT","HIGH_PROVIDER_COST_PER_UNIT","LOW_PROVIDER_COST_PER_UNIT",null,"VARIANCE","% Change","PROVIDE EXPLANATION FOR ALL % CHANGES MORE THAN 5% (Highlighted Yellow)"]
["O3C1","CONGREGATE MEALS",1,850275.48,114943,8.16,7,6.62,9.06,10.77,7.35,null,null,null,"O3C1","CONGREGATE MEALS",1,700973.53,33931,8.33,7.5,6.75,9.25,11,7.5,null,{"$f":"SUM(U11-G11)","v":0.5},{"$f":"SUM(AA11/G11)","v":7.1428571428571425E-2}]
["O3C2","HOME DELIVERED MEALS",1,439490.57,70420,6.8,8,5.85,7.56,8.6300000000000008,6.5,null,null,null,"O3C2","HOME DELIVERED MEALS",1,360355.03,48563,6.91,8.25,5.85,7.68,8.86,6.5,null,0.25,3.125E-2]
["OA3B","ADULT DAY CARE",1,2121.52,152,13.09,20,12.15,14.54,15.58,13.5,null,null,null,"OA3B","ADULT DAY CARE",1,125.02,10,12.5,12,12.5,13.89,13.89,13.89,null,-8,-0.4]
["OA3D","A MATTER OF BALANCE",1,19574.13,4,5453.74,5500,5453.35,5453.74,5453.94,5453.35,null,null,null,"OA3D","A MATTER OF BALANCE",1,32577.66,6,5429.61,5600,5429.61,5429.61,5429.61,5429.61,null,100,1.8181818181818181E-2]
["OA3EG","CAREGIVER TRAIN/SUPPORT (GRP)",1,17580.21,68,270,250,270,300,300,300,null,null,null,"OA3EG","CAREGIVER TRAIN/SUPPORT (GRP)",1,6152.05,61,110.5,300,110.5,122.78,122.78,122.78,null,50,0.2]
["OA3ES","CHORE",1,183.6,10,18.36,20,18.36,20.399999999999999,20.399999999999999,20.399999999999999,null,null,null,"OA3ES","CHORE",1,185.86,10,18.59,19.5,18.59,20.65,20.65,20.65,null,-0.5,-2.5000000000000001E-2]

{"sheet":"C.I.F.AAA","index":8,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,":)"]
[]
["C.I.F. - AAA AREAWIDE FUNDING PROFILE  "]
["This worksheet lists the amount retained at the AAA for areawide use including both administrative, direct service funding, LAN Set-Aside, and Disaster Recovery Reserves.  Service funding included on this sheet must reflect the C.I.C. Service Units and Cost Projections - Provider Summary for AAA as provider of direct services.\n\nAmounts are separated out by program and by state and/or federal share. Sixteen C.I.F. tabs have also been included in this workbook to capture county-level budgets.  Direct services provided by the AAA entered on this form must be apportioned to each county on the C.I.F. tabs, by recording in the \"County Share\" and as \"AAA Spending\".  Cells in the county C.I.F. and the areawide C.I.G. tabs do not include formulae to calculate values entered on this form.  \"OAA IIIB\" does not include LAN Set-Aside or Disaster Recovery Reserves.  \"OAA Administration\", \"OAA IIIB LAN Set Aside\", \"OAA IIIB, OAA C1, and OAA C2 Disaster Recovery Reserves\", \"State General Revenue Administration\", and \"Supplemental Resource Activities\" automatically populate in the respective line item, from the values entered in the C.I.A.  "]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the amount of all funding allocated for areawide activities or handled as an AAA allocation."]
[null,"AREAWIDE"]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B9:C9)","v":0}]
["OAA IIIB Set Aside",{"$f":"'C.I.A.'!C20","v":0},null,{"$f":"SUM(B10:C10)","v":0}]
["OAA IIIB Disaster Recovery Reserve",{"$f":"'C.I.A.'!$C$21","v":0},null,{"$f":"SUM(B11:C11)","v":0}]
["OAA C1",null,null,0]
["OAA C1 Disaster Recovery Reserve",{"$f":"'C.I.A.'!$D$21","v":0},null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C2",null,null,0]
["OAA C2 Disaster Recovery Reserve",{"$f":"'C.I.A.'!$E$21","v":0},null,{"$f":"SUM(B15:C15)","v":0}]
["OAA IIID",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA ADMINISTRATION",{"$f":"'C.I.A.'!B18","v":0},{"$f":"'C.I.A.'!D31","v":0},{"$f":"SUM(B19:C19)","v":0}]
["OAA  TOTAL",{"$f":"SUM(B9:B19)","v":0},{"$f":"C19","v":0},{"$f":"SUM(D9:D19)","v":0}]
["MED. WAIVER SPECIALIST",{"$f":"'C.I.A.'!K34/2","v":0},{"$f":"'C.I.A.'!K34/2","v":0},{"$f":"SUM(B21:C21)","v":0}]
["EHEAP SERVICES",{"$f":"'C.I.A.'!K31","v":0},null,{"$f":"SUM(B22:C22)","v":0}]
["EHEAP ADMINISTRATION",{"$f":"'C.I.A.'!K32","v":0},null,0]
["EHEAP OUTREACH",{"$f":"'C.I.A.'!K33","v":0},null,{"$f":"SUM(B24:C24)","v":0}]
["NSIP",{"$f":"'C.I.A.'!I18","v":0},null,0]
["CCE",null,null,0]
["CCE ADMINISTRATION",null,{"$f":"'C.I.A.'!D32","v":0},0]
["CCE INTAKE",null,null,0]
["ADI",null,null,0]
["ADI ADMINISTRATION",null,{"$f":"'C.I.A.'!D36","v":0},0]
["HCE",null,null,0]
["HCE ADMINISTRATION",null,{"$f":"'C.I.A.'!D34","v":0},0]
["LSP",null,null,0]
["LSP ADMINISTRATION",null,{"$f":"'C.I.A.'!D38","v":0},0]
["SHINE",{"$f":"'C.I.A.'!K35","v":0},null,0]
["RELIEF",null,null,{"$f":"SUM(B36:C36)","v":0}]
["ADRC (MAC)",{"$f":"'C.I.A.'!K37/2","v":0},{"$f":"'C.I.A.'!K37/2","v":0},{"$f":"SUM(B37:C37)","v":0}]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]
["OTHERS (List Below):"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"},null,null,{"$f":"'C.I.A.'!K38","v":0}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"},null,null,{"$f":"'C.I.A.'!K39","v":0}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"},null,null,{"$f":"'C.I.A.'!K40","v":0}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"},null,null,{"$f":"'C.I.A.'!K41","v":0}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"},null,null,{"$f":"'C.I.A.'!K43","v":0}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"},null,null,{"$f":"'C.I.A.'!K44","v":0}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"},null,null,{"$f":"'C.I.A.'!K45","v":0}]
[{"$f":"'C.I.A.'!G46","v":"Other 4"},null,null,{"$f":"'C.I.A.'!K46","v":0}]
[]
[]
[]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D38:D50)","v":0}]

{"sheet":"C.I.F.(1)","index":9,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,0,35,2],[35,4,35,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,5,8,5],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.1 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding included on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary. \n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
[{"$f":"'C.I.A.'!G46","v":"Other 4"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D35)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F35)","v":0}]

{"sheet":"C.I.F.(2)","index":10,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.2 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(3)","index":11,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.3 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(4)","index":12,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                    ",null,null,null,null,null,":)"]
[]
["C.I.F.4 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(5)","index":13,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.5 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(6)","index":14,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.6 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(7)","index":15,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.7 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(8)","index":16,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.8 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(9)","index":17,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.9 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(10)","index":18,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.10 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(11)","index":19,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.11 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(12)","index":20,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.12 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(13)","index":21,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.13 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(14)","index":22,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.14 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(15)","index":23,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.15 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.F.(16)","index":24,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[[30,4,30,5],[32,4,32,5],[33,4,33,5],[34,0,34,2],[34,4,34,5],[26,1,26,3],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[7,3,8,3],[4,0,4,5],[3,0,3,5],[6,2,6,3],[2,0,2,3],[6,4,6,5],[7,4,8,4],[7,5,8,5],[7,0,8,0],[7,1,8,1],[7,2,8,2]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,":)"]
[]
["C.I.F.16 - COUNTY FUNDING PROFILE  "]
["This worksheet lists for one county the amount budgeted to each program separated out by state and/or federal share. Service funding include on this sheet must reflect the county total in the C.I.C. Service Units and Cost Projections - PSA Summary.\n\nSixteen C.I.F. tabs have been included in this workbook to allow for the maximum number of counties in a PSA. The funds identified on the C.I.F.AAA form must be apportioned to each county on the C.I.F. tabs.\n"]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  In the AAA SPENDING columns, please indicate any spending by the AAA on behalf of the respective county. If the AAA is a provider for any program, the AAA SPENDING should be a portion of the FEDERAL SHARE and must reflect the AAA's allocated service funds for the county in the C.I.C. Service Units and Cost Projections - PSA Summary."]
[]
[null,"COUNTY:  ",null,null,"AAA SPENDING"]
["PROGRAM","FEDERAL SHARE","STATE SHARE","TOTAL BUDGETED","FEDERAL","STATE"]
[]
["OAA IIIB",null,null,{"$f":"SUM(B10:C10)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B10:B15)","v":0},null,{"$f":"SUM(D10:D15)","v":0},{"$f":"SUM(E10:E15)","v":0}]
["EHEAP SERVICES",null,null,{"$f":"SUM(B17:C17)","v":0}]
["EHEAP ADMINISTRATION",null,null,{"$f":"SUM(B18:C18)","v":0}]
["EHEAP OUTREACH",null,null,0]
["NSIP",null,null,{"$f":"SUM(B20:C20)","v":0}]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B16:B20)","v":0},{"$f":"SUM(C21:C25)","v":0},{"$f":"SUM(D16:D25)","v":0},{"$f":"SUM(E16:E20)","v":0},{"$f":"SUM(F21:F25)","v":0}]
["OTHERS (List Below):","COUNTY'S SHARE OF FUNDING LISTED BELOW",null,null,"AAA SPENDING"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"}]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"}]
[{"$f":"'C.I.A.'!G44","v":"Other 2"}]
[{"$f":"'C.I.A.'!G45","v":"Other 3"}]
["TOTAL ALL FUNDING SOURCES",null,null,{"$f":"SUM(D26:D34)","v":0},{"$f":"SUM(E26:F26)+SUM(E28:F34)","v":0}]

{"sheet":"C.I.G.","index":25,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[46,0,48,0],[38,1,38,2],[4,0,4,3],[5,0,5,3],[7,0,8,0]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,":)"]
[]
["C.I.G. - Areawide Funding Summary "]
[]
["This worksheet contains the federal and state share allocations for each program for the AAA.  Amounts are calculated from values entered on the C.I.F. tabs and C.I.A. The amounts are not calculated from the values entered on the C.I.F.AAA tab. \"OAA IIIB, OAA C1, and OAA C2\" do not include LAN Set-Aside or Disaster Recovery Reserves. \"OAA IIIB LAN Set Aside and OAA IIIB, OAA C1, OAA C2 Disaster Recovery Reserves\" automatically populate in the respective line item, from each value in the C.I.A."]
["Instructions:  Purple cells are calculated automatically.  "]
[]
["PROGRAM","FEDERAL","STATE","TOTAL",null,"FOR DOEA USE ONLY"]
[null,"SHARE","SHARE","BUDGETED",null,"C.I.A.","DIFF."]
["OAA IIIB",{"$f":"'C.I.F.(1)'!B10+'C.I.F.(2)'!B10+'C.I.F.(3)'!B10+'C.I.F.(4)'!B10+'C.I.F.(5)'!B10+'C.I.F.(6)'!B10+'C.I.F.(7)'!B10+'C.I.F.(8)'!B10+'C.I.F.(9)'!B10+'C.I.F.(10)'!B10+'C.I.F.(11)'!B10+'C.I.F.(12)'!B10+'C.I.F.(13)'!B10+'C.I.F.(14)'!B10+'C.I.F.(15)'!B10+'C.I.F.(16)'!B10","v":0},null,{"$f":"SUM(B10:C10)","v":0},null,{"$f":"'C.I.A.'!C18-'C.I.A.'!C20","v":0},{"$f":"F10-D10","v":0}]
["OAA IIIB Set Aside",{"$f":"'C.I.A.'!C20","v":0},null,{"$f":"SUM(B11:C11)","v":0},null,{"$f":"'C.I.A.'!C20","v":0},{"$f":"F11-D11","v":0}]
["OAA IIIB Disaster Recovery Reserve",{"$f":"'C.I.A.'!C21","v":0},null,{"$f":"SUM(B12:C12)","v":0},null,{"$f":"'C.I.A.'!$C$20","v":0},{"$f":"F12-D12","v":0}]
["OAA C1",{"$f":"'C.I.F.(1)'!B11+'C.I.F.(2)'!B11+'C.I.F.(3)'!B11+'C.I.F.(4)'!B11+'C.I.F.(5)'!B11+'C.I.F.(6)'!B11+'C.I.F.(7)'!B11+'C.I.F.(8)'!B11+'C.I.F.(9)'!B11+'C.I.F.(10)'!B11+'C.I.F.(11)'!B11+'C.I.F.(12)'!B11+'C.I.F.(13)'!B11+'C.I.F.(14)'!B11+'C.I.F.(15)'!B11+'C.I.F.(16)'!B11","v":0},null,{"$f":"SUM(B13:C13)","v":0},null,{"$f":"'C.I.A.'!D18","v":0},{"$f":"F13-D13","v":0}]
["OAA C1 Disaster Recovery Reserve",{"$f":"'C.I.A.'!D21","v":0},null,{"$f":"SUM(B14:C14)","v":0},null,{"$f":"'C.I.A.'!$D$21","v":0},0]
["OAA C2",{"$f":"'C.I.F.(1)'!B12+'C.I.F.(2)'!B12+'C.I.F.(3)'!B12+'C.I.F.(4)'!B12+'C.I.F.(5)'!B12+'C.I.F.(6)'!B12+'C.I.F.(7)'!B12+'C.I.F.(8)'!B12+'C.I.F.(9)'!B12+'C.I.F.(10)'!B12+'C.I.F.(11)'!B12+'C.I.F.(12)'!B12+'C.I.F.(13)'!B12+'C.I.F.(14)'!B12+'C.I.F.(15)'!B12+'C.I.F.(16)'!B12","v":0},null,{"$f":"SUM(B15:C15)","v":0},null,{"$f":"'C.I.A.'!E18","v":0},0]
["OAA C2 Disaster Recovery Reserve",{"$f":"'C.I.A.'!E21","v":0},null,0,null,{"$f":"'C.I.A.'!$E$21","v":0},0]
["OAA IIID",{"$f":"'C.I.F.(1)'!B13+'C.I.F.(2)'!B13+'C.I.F.(3)'!B13+'C.I.F.(4)'!B13+'C.I.F.(5)'!B13+'C.I.F.(6)'!B13+'C.I.F.(7)'!B13+'C.I.F.(8)'!B13+'C.I.F.(9)'!B13+'C.I.F.(10)'!B13+'C.I.F.(11)'!B13+'C.I.F.(12)'!B13+'C.I.F.(13)'!B13+'C.I.F.(14)'!B13+'C.I.F.(15)'!B13+'C.I.F.(16)'!B13","v":0},null,{"$f":"SUM(B17:C17)","v":0},null,{"$f":"'C.I.A.'!G18","v":0},{"$f":"F17-D17","v":0}]
["OAA IIIE",{"$f":"'C.I.F.(1)'!B14+'C.I.F.(2)'!B14+'C.I.F.(3)'!B14+'C.I.F.(4)'!B14+'C.I.F.(5)'!B14+'C.I.F.(6)'!B14+'C.I.F.(7)'!B14+'C.I.F.(8)'!B14+'C.I.F.(9)'!B14+'C.I.F.(10)'!B14+'C.I.F.(11)'!B14+'C.I.F.(12)'!B14+'C.I.F.(13)'!B14+'C.I.F.(14)'!B14+'C.I.F.(15)'!B14+'C.I.F.(16)'!B14","v":0},null,0,null,{"$f":"'C.I.A.'!H18","v":0},0]
["OAA VII",{"$f":"'C.I.F.(1)'!B15+'C.I.F.(2)'!B15+'C.I.F.(3)'!B15+'C.I.F.(4)'!B15+'C.I.F.(5)'!B15+'C.I.F.(6)'!B15+'C.I.F.(7)'!B15+'C.I.F.(8)'!B15+'C.I.F.(9)'!B15+'C.I.F.(10)'!B15+'C.I.F.(11)'!B15+'C.I.F.(12)'!B15+'C.I.F.(13)'!B15+'C.I.F.(14)'!B15+'C.I.F.(15)'!B15+'C.I.F.(16)'!B15","v":0},null,0,null,{"$f":"'C.I.A.'!J18","v":0},0]
["OAA ADMINISTRATION",{"$f":"'C.I.A.'!B18","v":0},{"$f":"'C.I.A.'!D31","v":0},0,null,{"$f":"'C.I.A.'!B18+'C.I.A.'!D31","v":0},0]
["OAA  TOTAL",{"$f":"SUM(B10:B20)","v":0},{"$f":"SUM(C10:C20)","v":0},{"$f":"SUM(D10:D20)","v":0}]
["MED. WAIVER SPECIALIST",{"$f":"'C.I.A.'!K34/2","v":0},{"$f":"'C.I.A.'!K34/2","v":0},{"$f":"SUM(B22:C22)","v":0},null,{"$f":"'C.I.A.'!K34","v":0},{"$f":"F22-D22","v":0}]
["EHEAP SERVICES",{"$f":"'C.I.F.(1)'!B17+'C.I.F.(2)'!B17+'C.I.F.(3)'!B17+'C.I.F.(4)'!B17+'C.I.F.(5)'!B17+'C.I.F.(6)'!B17+'C.I.F.(7)'!B17+'C.I.F.(8)'!B17+'C.I.F.(9)'!B17+'C.I.F.(10)'!B17+'C.I.F.(11)'!B17+'C.I.F.(12)'!B17+'C.I.F.(13)'!B17+'C.I.F.(14)'!B17+'C.I.F.(15)'!B17+'C.I.F.(16)'!B17","v":0},null,0,null,{"$f":"'C.I.A.'!K31","v":0},0]
["EHEAP ADMINISTRATION",{"$f":"'C.I.F.(1)'!B18+'C.I.F.(2)'!B18+'C.I.F.(3)'!B18+'C.I.F.(4)'!B18+'C.I.F.(5)'!B18+'C.I.F.(6)'!B18+'C.I.F.(7)'!B18+'C.I.F.(8)'!B18+'C.I.F.(9)'!B18+'C.I.F.(10)'!B18+'C.I.F.(11)'!B18+'C.I.F.(12)'!B18+'C.I.F.(13)'!B18+'C.I.F.(14)'!B18+'C.I.F.(15)'!B18+'C.I.F.(16)'!B18","v":0},null,0,null,{"$f":"'C.I.A.'!K32","v":0},0]
["EHEAP OUTREACH",{"$f":"'C.I.F.(1)'!B19+'C.I.F.(2)'!B19+'C.I.F.(3)'!B19+'C.I.F.(4)'!B19+'C.I.F.(5)'!B19+'C.I.F.(6)'!B19+'C.I.F.(7)'!B19+'C.I.F.(8)'!B19+'C.I.F.(9)'!B19+'C.I.F.(10)'!B19+'C.I.F.(11)'!B19+'C.I.F.(12)'!B19+'C.I.F.(13)'!B19+'C.I.F.(14)'!B19+'C.I.F.(15)'!B19+'C.I.F.(16)'!B19","v":0},null,0,null,{"$f":"'C.I.A.'!K33","v":0},0]
["NSIP",{"$f":"'C.I.F.(1)'!B20+'C.I.F.(2)'!B20+'C.I.F.(3)'!B20+'C.I.F.(4)'!B20+'C.I.F.(5)'!B20+'C.I.F.(6)'!B20+'C.I.F.(7)'!B20+'C.I.F.(8)'!B20+'C.I.F.(9)'!B20+'C.I.F.(10)'!B20+'C.I.F.(11)'!B20+'C.I.F.(12)'!B20+'C.I.F.(13)'!B20+'C.I.F.(14)'!B20+'C.I.F.(15)'!B20+'C.I.F.(16)'!B20","v":0},null,{"$f":"SUM(B26:C26)","v":0},null,{"$f":"'C.I.A.'!I18","v":0},0]
["CCE "," ",{"$f":"'C.I.F.(1)'!C21+'C.I.F.(2)'!C21+'C.I.F.(3)'!C21+'C.I.F.(4)'!C21+'C.I.F.(5)'!C21+'C.I.F.(6)'!C21+'C.I.F.(7)'!C21+'C.I.F.(8)'!C21+'C.I.F.(9)'!C21+'C.I.F.(10)'!C21+'C.I.F.(11)'!C21+'C.I.F.(12)'!C21+'C.I.F.(13)'!C21+'C.I.F.(14)'!C21+'C.I.F.(15)'!C21+'C.I.F.(16)'!C21","v":0},0,null,{"$f":"'C.I.A.'!D33","v":0},0]
["CCE ADMINISTRATION",null,{"$f":"'C.I.A.'!D32","v":0},0,null,{"$f":"'C.I.A.'!D32","v":0},0]
["ADI ",null,{"$f":"'C.I.F.(1)'!C22+'C.I.F.(2)'!C22+'C.I.F.(3)'!C22+'C.I.F.(4)'!C22+'C.I.F.(5)'!C22+'C.I.F.(6)'!C22+'C.I.F.(7)'!C22+'C.I.F.(8)'!C22+'C.I.F.(9)'!C22+'C.I.F.(10)'!C22+'C.I.F.(11)'!C22+'C.I.F.(12)'!C22+'C.I.F.(13)'!C22+'C.I.F.(14)'!C22+'C.I.F.(15)'!C22+'C.I.F.(16)'!C22","v":0},0,null,{"$f":"'C.I.A.'!D37","v":0},0]
["ADI ADMINISTRATION",null,{"$f":"'C.I.A.'!D36","v":0},0,null,{"$f":"'C.I.A.'!D36","v":0},0]
["HCE",null,{"$f":"'C.I.F.(1)'!C23+'C.I.F.(2)'!C23+'C.I.F.(3)'!C23+'C.I.F.(4)'!C23+'C.I.F.(5)'!C23+'C.I.F.(6)'!C23+'C.I.F.(7)'!C23+'C.I.F.(8)'!C23+'C.I.F.(9)'!C23+'C.I.F.(10)'!C23+'C.I.F.(11)'!C23+'C.I.F.(12)'!C23+'C.I.F.(13)'!C23+'C.I.F.(14)'!C23+'C.I.F.(15)'!C23+'C.I.F.(16)'!C23","v":0},0,null,{"$f":"'C.I.A.'!D35+'C.I.A.'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["HCE ADMINISTRATION",null,{"$f":"'C.I.A.'!D34","v":0},0,null,{"$f":"'C.I.A.'!D34","v":0},0]
["LSP",null,{"$f":"'C.I.F.(1)'!C24+'C.I.F.(2)'!C24+'C.I.F.(3)'!C24+'C.I.F.(4)'!C24+'C.I.F.(5)'!C24+'C.I.F.(6)'!C24+'C.I.F.(7)'!C24+'C.I.F.(8)'!C24+'C.I.F.(9)'!C24+'C.I.F.(10)'!C24+'C.I.F.(11)'!C24+'C.I.F.(12)'!C24+'C.I.F.(13)'!C24+'C.I.F.(14)'!C24+'C.I.F.(15)'!C24+'C.I.F.(16)'!C24","v":0},0,null,{"$f":"'C.I.A.'!D39","v":0},0]
["LSP ADMINISTRATION",null,{"$f":"'C.I.A.'!D38","v":0},{"$f":"SUM(B34:C34)","v":0},null,{"$f":"'C.I.A.'!D38","v":0},0]
["SHINE",{"$f":"'C.I.A.'!K35","v":0},null,{"$f":"SUM(B35:C35)","v":0},null,{"$f":"'C.I.A.'!K35","v":0},0]
["RELIEF",null,{"$f":"'C.I.F.(1)'!C25+'C.I.F.(2)'!C25+'C.I.F.(3)'!C25+'C.I.F.(4)'!C25+'C.I.F.(5)'!C25+'C.I.F.(6)'!C25+'C.I.F.(7)'!C25+'C.I.F.(8)'!C25+'C.I.F.(9)'!C25+'C.I.F.(10)'!C25+'C.I.F.(11)'!C25+'C.I.F.(12)'!C25+'C.I.F.(13)'!C25+'C.I.F.(14)'!C25+'C.I.F.(15)'!C25+'C.I.F.(16)'!C25","v":0},0,null,{"$f":"'C.I.A.'!K36","v":0},0]
["ADRC (MAC)",{"$f":"'C.I.A.'!K37/2","v":0},{"$f":"'C.I.A.'!K37/2","v":0},0,null,{"$f":"'C.I.A.'!K37","v":0},{"$f":"F37-D37","v":0}]
["TOTAL ALL FEDERAL AND STATE FUNDING SOURCES",{"$f":"SUM(B21:B37)","v":0},{"$f":"SUM(C21:C37)","v":0},{"$f":"SUM(D21:D37)","v":0}]
["OTHERS (LIST):"]
[{"$f":"'C.I.A.'!G38","v":"Families First Act"},null,null,{"$f":"'C.I.F.(1)'!D28+'C.I.F.(2)'!D28+'C.I.F.(3)'!D28+'C.I.F.(4)'!D28+'C.I.F.(5)'!D28+'C.I.F.(6)'!D28+'C.I.F.(7)'!D28+'C.I.F.(8)'!D28+'C.I.F.(9)'!D28+'C.I.F.(10)'!D28+'C.I.F.(11)'!D28+'C.I.F.(12)'!D28+'C.I.F.(13)'!D28+'C.I.F.(14)'!D28+'C.I.F.(15)'!D28+'C.I.F.(16)'!D28","v":0},null,{"$f":"'C.I.A.'!K39","v":0},{"$f":"F40-D40","v":0}]
[{"$f":"'C.I.A.'!G39","v":"CARES Act"},null,null,{"$f":"'C.I.F.(1)'!D29+'C.I.F.(2)'!D29+'C.I.F.(3)'!D29+'C.I.F.(4)'!D29+'C.I.F.(5)'!D29+'C.I.F.(6)'!D29+'C.I.F.(7)'!D29+'C.I.F.(8)'!D29+'C.I.F.(9)'!D29+'C.I.F.(10)'!D29+'C.I.F.(11)'!D29+'C.I.F.(12)'!D29+'C.I.F.(13)'!D29+'C.I.F.(14)'!D29+'C.I.F.(15)'!D29+'C.I.F.(16)'!D29","v":0},null,{"$f":"'C.I.A.'!K41","v":0},0]
[{"$f":"'C.I.A.'!G40","v":"EHEAP - CARES Act"},null,null,{"$f":"'C.I.F.(1)'!D30+'C.I.F.(2)'!D30+'C.I.F.(3)'!D30+'C.I.F.(4)'!D30+'C.I.F.(5)'!D30+'C.I.F.(6)'!D30+'C.I.F.(7)'!D30+'C.I.F.(8)'!D30+'C.I.F.(9)'!D30+'C.I.F.(10)'!D30+'C.I.F.(11)'!D30+'C.I.F.(12)'!D30+'C.I.F.(13)'!D30+'C.I.F.(14)'!D30+'C.I.F.(15)'!D30+'C.I.F.(16)'!D30","v":0},null,{"$f":"'C.I.A.'!#REF!","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[{"$f":"'C.I.A.'!G41","v":"ADRC - CARES Act"},null,null,{"$f":"'C.I.F.(1)'!D31+'C.I.F.(2)'!D31+'C.I.F.(3)'!D31+'C.I.F.(4)'!D31+'C.I.F.(5)'!D31+'C.I.F.(6)'!D31+'C.I.F.(7)'!D31+'C.I.F.(8)'!D31+'C.I.F.(9)'!D31+'C.I.F.(10)'!D31+'C.I.F.(11)'!D31+'C.I.F.(12)'!D31+'C.I.F.(13)'!D31+'C.I.F.(14)'!D31+'C.I.F.(15)'!D31+'C.I.F.(16)'!D31","v":0},null,{"$f":"'C.I.A.'!K43","v":0},{"$f":"F43-D43","v":0}]
[{"$f":"'C.I.A.'!G43","v":"Other 1"},null,null,{"$f":"'C.I.F.(1)'!D32+'C.I.F.(2)'!D32+'C.I.F.(3)'!D32+'C.I.F.(4)'!D32+'C.I.F.(5)'!D32+'C.I.F.(6)'!D32+'C.I.F.(7)'!D32+'C.I.F.(8)'!D32+'C.I.F.(9)'!D32+'C.I.F.(10)'!D32+'C.I.F.(11)'!D32+'C.I.F.(12)'!D32+'C.I.F.(13)'!D32+'C.I.F.(14)'!D32+'C.I.F.(15)'!D32+'C.I.F.(16)'!D32","v":0},null,{"$f":"'C.I.A.'!K44","v":0},0]
[{"$f":"'C.I.A.'!G44","v":"Other 2"},null,null,{"$f":"'C.I.F.(1)'!D33+'C.I.F.(2)'!D33+'C.I.F.(3)'!D33+'C.I.F.(4)'!D33+'C.I.F.(5)'!D33+'C.I.F.(6)'!D33+'C.I.F.(7)'!D33+'C.I.F.(8)'!D33+'C.I.F.(9)'!D33+'C.I.F.(10)'!D33+'C.I.F.(11)'!D33+'C.I.F.(12)'!D33+'C.I.F.(13)'!D33+'C.I.F.(14)'!D33+'C.I.F.(15)'!D33+'C.I.F.(16)'!D33","v":0},null,{"$f":"'C.I.A.'!K45","v":0},0]
[{"$f":"'C.I.A.'!G45","v":"Other 3"},null,null,{"$f":"'C.I.F.(1)'!D34+'C.I.F.(2)'!D34+'C.I.F.(3)'!D34+'C.I.F.(4)'!D34+'C.I.F.(5)'!D34+'C.I.F.(6)'!D34+'C.I.F.(7)'!D34+'C.I.F.(8)'!D34+'C.I.F.(9)'!D34+'C.I.F.(10)'!D34+'C.I.F.(11)'!D34+'C.I.F.(12)'!D34+'C.I.F.(13)'!D34+'C.I.F.(14)'!D34+'C.I.F.(15)'!D34+'C.I.F.(16)'!D34","v":0},null,{"$f":"'C.I.A.'!K46","v":0},0]
["TOTAL ALL FUNDING SOURCES","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
[null,{"$f":"SUM(B38)","v":0},{"$f":"SUM(C38)","v":0},{"$f":"SUM(D38:D46)","v":0}]

{"sheet":"C.II.A.","index":26,"n_rows":191,"n_cols":28,"rows_kept":191,"cut":false,"hidden":false,"merged":[[5,0,5,9],[21,0,23,0],[51,0,51,21],[125,0,125,1],[82,0,82,1],[7,0,7,1],[95,0,95,1],[83,0,83,1],[96,0,96,1],[93,0,93,1],[137,0,137,1],[153,0,153,20],[98,0,98,1],[150,0,150,1],[108,0,108,1],[128,0,128,1],[117,0,117,1],[136,0,136,1],[127,0,127,1],[115,0,115,1],[116,0,116,1],[190,0,190,20],[189,0,189,20],[179,0,179,20],[181,0,181,20],[177,0,177,20],[178,0,178,20],[182,0,182,20],[187,0,187,20],[188,0,188,20],[186,0,186,20],[180,0,180,20],[183,0,183,20],[184,0,184,20],[185,0,185,20]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":)"]
[]
["C.II.A. - AREA AGENCY ON AGING OPERATING BUDGET SUMMARY AND ALLOCATIONS"]
["NAME OF AGENCY:"]
["BUDGET YEAR - 2021"]
["Instructions:  Update all aqua-colored cells as appropriate.  Purple cells are calculated automatically. Use the categories provided, adding rows as needed. In accordance with the requirement for Area Agencies to describe all activities of the Agency, whether funded by public or private funds, and ensuring the agency is managing the availability of financial resources for programs and services used to carry out programs for the elderly, the operating budget must include ALL of the sources of funding and be included in the spreadsheets. (OAA and Chapter 430.2053, F.S)(Board and other non-DOEA funds should go in the OTHER PROJECTS-NON-DOEA column and should match their anticipated revenues and expenses.) Note: When adding rows, formulae in Total columns need to be added.  Notes 1 through 5 describe narrative details needed for specific sections.  Include the narratives at the end of the worksheet. "]
[]
["PERSONNEL SALARIES",null,{"$f":"+D50","v":0}]
["IN KIND SALARIES",null,{"$f":"+D61","v":0}]
["FRINGE BENEFITS",null,{"$f":"+D74","v":0}]
["TOTAL PERSONNEL COSTS",null,{"$f":"+D75","v":0}]
["TRAVEL",null,{"$f":"+D87","v":0}]
["BUILDING SPACE",null,{"$f":"+D99","v":0}]
["COMMUNICATIONS & UTILITIES",null,{"$f":"+D109","v":0}]
["PRINTING & SUPPLIES",null,{"$f":"+D118","v":0}]
["EQUIPMENT",null,{"$f":"+D130","v":0}]
["OTHER",null,{"$f":"+D152","v":0}]
["REVENUE",null,{"$f":"+D169","v":0}]
[]
[]
["1. PERSONNEL SALARIES"]
["TITLE and NAME","GROSS","TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,"AVAILABLE","BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,"HOURS","CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:W25)","v":0},{"$f":"SUM(D25-C25)","v":0},{"$f":"Y25/C25","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(D26-C26)","v":0},{"$f":"Y26/C26","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:W28)","v":0},{"$f":"SUM(D28-C28)","v":0},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["OVERTIME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["BONUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["ACCRUED LEAVE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["MEALS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["TOTAL PERSONNEL SALARIES",null,{"$f":"SUM(C25:C49)","v":0},{"$f":"SUM(D25:D49)","v":0},{"$f":"SUM(E25:E49)","v":0},0,{"$f":"SUM(G25:G49)","v":0},0,0,{"$f":"SUM(J25:J49)","v":0},0,0,{"$f":"SUM(M25:M49)","v":0},{"$f":"SUM(N25:N49)","v":0},0,0,0,{"$f":"SUM(R25:R49)","v":0},{"$f":"SUM(S25:S49)","v":0},{"$f":"SUM(T25:T49)","v":0},{"$f":"SUM(U25:U49)","v":0},0,0,{"$f":"SUM(X25:X49)","v":0},{"$f":"SUM(Y25:Y49)","v":0},{"$f":"Y50/C50","v":{"$error":"#DIV/0!"}}]
["TOTAL GROSS AVAIL HRS",{"$f":"SUM(B25:B49)","v":0}]
["Note 1:  Enter on the last page of this Operating Budget a narrative explanation of the use of funds (salary and other) from Title IIIB Set Aside (LAN), Title IIIB I&R, and any other DOEA-funded special project (separately for each category of funds).  Break out federally funded expenditures from other sources of funding. "]
["Note 2:   Enter on the last page of this Operating Budget a narrative explanation of bonuses paid that ensures they have been approved by the Board of Directors."]
[]
[]
["2.  IN-KIND SALARIES"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["VOLUNTEER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E60:W60)","v":0},{"$f":"SUM(D60-C60)","v":0},{"$f":"Y60/C60","v":{"$error":"#DIV/0!"}}]
["TOTAL IN-KIND SALARIES",null,{"$f":"SUM(C60:C60)","v":0},{"$f":"SUM(D60:D60)","v":0},{"$f":"SUM(E60:E60)","v":0},0,0,0,0,0,{"$f":"SUM(K60:K60)","v":0},{"$f":"SUM(L60:L60)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E61:W61)","v":0},{"$f":"SUM(Y60:Y60)","v":0},{"$f":"Y61/C61","v":{"$error":"#DIV/0!"}}]
["TOTAL SALARIES",null,{"$f":"SUM(C50,C61)","v":0},0,0,0,0,0,0,0,{"$f":"SUM(K50,K61)","v":0},{"$f":"SUM(L50,L61)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(X50,X61)","v":0},0,{"$f":"Y62/C62","v":{"$error":"#DIV/0!"}}]
[]
[]
["3. FRINGE BENEFITS"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
[" RETIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:W69)","v":0},{"$f":"SUM(D69-C69)","v":0},{"$f":"Y69/C69","v":{"$error":"#DIV/0!"}}]
[" SOCIAL SECURITY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E70:W70)","v":0},{"$f":"SUM(D70-C70)","v":0},{"$f":"Y70/C70","v":{"$error":"#DIV/0!"}}]
[" FL UNEMP. COMP.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E71:W71)","v":0},{"$f":"SUM(D71-C71)","v":0},{"$error":"#DIV/0!"}]
["EMPLOYEE INSURANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:W72)","v":0},{"$f":"SUM(D72-C72)","v":0},{"$error":"#DIV/0!"}]
["WORKERS COMPENSATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E73:W73)","v":0},{"$f":"SUM(D73-C73)","v":0},{"$error":"#DIV/0!"}]
["TOTAL FRINGE BENEFITS",null,{"$f":"SUM(C69:C73)","v":0},{"$f":"SUM(D69:D73)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(X69:X73)","v":0},{"$f":"SUM(Y69:Y73)","v":0},{"$error":"#DIV/0!"}]
["TOTAL PERSONNEL COSTS",null,{"$f":"SUM(C74,C62)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
[]
["4. TRAVEL"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["TRAVEL (In-Area)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E82:W82)","v":0},{"$f":"D82-C82","v":0},{"$f":"Y82/C82","v":{"$error":"#DIV/0!"}}]
["TRAVEL (In-State/Conferences) - please identify)*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E83:W83)","v":0},{"$f":"D83-C83","v":0},{"$error":"#DIV/0!"}]
["TRAVEL (Out-of State/Conferences) - please identify*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E84:W84)","v":0},{"$f":"D84-C84","v":0},{"$error":"#DIV/0!"}]
["BOARD & VOLUNTEER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E85:W85)","v":0},{"$f":"D85-C85","v":0},{"$error":"#DIV/0!"}]
["IN-KIND TRAVEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E86:W86)","v":0},{"$f":"D86-C86","v":0},{"$error":"#DIV/0!"}]
["TOTAL TRAVEL",null,{"$f":"SUM(C82:C86)","v":0},{"$f":"SUM(D82:D86)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q82:Q86)","v":0},0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
["* Note 3:  For each  in and out-of-state conference budgeted, enter on the last page of this Operating Budget, the name of the conference, the number attending, and the amount budgeted."]
[]
["5. BUILDING SPACE",null," "," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["DEPRECIATION - BUILDING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E94:W94)","v":0},{"$f":"D94-C94","v":0},{"$f":"Y94/C94","v":{"$error":"#DIV/0!"}}]
["INSURANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E95:W95)","v":0},{"$f":"D95-C95","v":0},{"$error":"#DIV/0!"}]
["REPAIR AND MAINTENANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E96:W96)","v":0},{"$f":"D96-C96","v":0},{"$error":"#DIV/0!"}]
["RENT, LEASE, OR MORTGAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E97:W97)","v":0},{"$f":"D97-C97","v":0},{"$error":"#DIV/0!"}]
["    IN-KIND ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E98:W98)","v":0},{"$f":"D98-C98","v":0},{"$error":"#DIV/0!"}]
["TOTAL BUILDING SPACE",null,{"$f":"SUM(C94:C98)","v":0},{"$f":"SUM(D94:D98)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
[]
["6. COMMUNICATIONS & UTILITIES"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["TELEPHONE / INTERNET",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E106:W106)","v":0},{"$f":"D106-C106","v":0},{"$f":"Y106/C106","v":{"$error":"#DIV/0!"}}]
["POSTAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E107:W107)","v":0},{"$f":"D107-C107","v":0},{"$f":"Y107/C107","v":{"$error":"#DIV/0!"}}]
["UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E108:W108)","v":0},{"$f":"D108-C108","v":0},{"$f":"Y108/C108","v":{"$error":"#DIV/0!"}}]
["TOTAL COMMUNICATION & UTILITIES",null,{"$f":"SUM(C106:C108)","v":0},0,0,{"$f":"SUM(F106:F108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Y106:Y108)","v":0},{"$f":"Y109/C109","v":{"$error":"#DIV/0!"}}]
[]
[]
["7.  PRINTING & SUPPLIES"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["GENERAL OFFICE SUPPLIES / EQUIPMENT UNDER $1,500.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E116:W116)","v":0},{"$f":"D116-C116","v":0},{"$f":"Y116/C116","v":{"$error":"#DIV/0!"}}]
["PRINTING AND REPRODUCTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E117:W117)","v":0},{"$f":"D117-C117","v":0},{"$f":"Y117/C117","v":{"$error":"#DIV/0!"}}]
["TOTAL PRINTING & SUPPLIES",null,{"$f":"SUM(C116:C117)","v":0},0,0,0,0,{"$f":"SUM(H116:H117)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(Q116:Q117)","v":0},0,0,0,0,0,0,0,0,{"$f":"Y118/C118","v":{"$error":"#DIV/0!"}}]
["Note 4:  Enter on the last page of this Operating Budget a narrative explanation of planned expenditures in the communications category."]
[]
[]
["8.  EQUIPMENT"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["DEPRECIATION - EQUIPMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E126:W126)","v":0},{"$f":"D126-C126","v":0},{"$f":"Y126/C126","v":{"$error":"#DIV/0!"}}]
["OFFICE FURN / EQUIPT. OVER $1,000.00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E127:W127)","v":0},{"$f":"D127-C127","v":0},{"$error":"#DIV/0!"}]
["COMPUTER HARDWARE/SOFTWARE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E128:W128)","v":0},{"$f":"D128-C128","v":0},{"$error":"#DIV/0!"}]
["PROGRAM EQUIPMENT (Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E129:W129)","v":0},{"$f":"D129-C129","v":0},{"$error":"#DIV/0!"}]
["TOTAL EQUIPMENT",null,{"$f":"SUM(C126:C129)","v":0},{"$f":"SUM(D126:D129)","v":0},0,0,0,0,0,0,{"$f":"SUM(K126:K129)","v":0},{"$f":"SUM(L126:L129)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
[]
[]
["9. OTHER COSTS (UNIQUE TO AAA)"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["LEGAL, AUDIT, PROFESSIONAL FEES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F137:W137)","v":0},{"$f":"SUM(E137-D137)","v":0},{"$f":"Y137/C137","v":{"$error":"#DIV/0!"}}]
["PROGRAM SUPPLIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F138:W138)","v":0},0,{"$f":"Y138/C138","v":{"$error":"#DIV/0!"}}]
["FOOD SUPPLIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F139:W139)","v":0},0,{"$error":"#DIV/0!"}]
["ADVERTISING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F140:W140)","v":0},0,{"$error":"#DIV/0!"}]
["LOBBYING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["DUES AND SUBSCRIPTIONS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["STAFF DEVELOPMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["FUNDRAISER / SPECIAL EVENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F144:W144)","v":0},0,{"$error":"#DIV/0!"}]
["MISCELLANEOUS (List items in row below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(E146-D146)","v":0},{"$error":"#DIV/0!"}]
["PUBLICATIONS  (Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["SUB-CONTRACTOR(S) (List in row below)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["RELOCATION EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["PARTICIPANT SUPPORT COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["TOTAL OTHER COSTS",null,{"$f":"SUM(C137:C151)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N137:N151)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$error":"#DIV/0!"}]
["TOTAL ALL COSTS",null,{"$f":"SUM(C152,C130,C118,C109,C99,C87,C75)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(N152,O130,O118,O109,O99,O87,O75)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Y138:Y152)","v":0},{"$error":"#DIV/0!"}]
["Note 5:  Enter on the last page of this Operating Budget a narrative explanation for planned purchases/expenditures in the equipment and other categories in the Title IIIB Set Aside, Title IIIB I&R, and any other DOEA-funded special project (separately for each category of funds).  Break out federally funded expenditures from other sources of funding."]
[]
[]
["10. REVENUES"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","CCE","EHEAP","EHEAP","HCE","MEDICAID","SHINE","ADRC ","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL","%"]
[null,null,"BUDGET","BUDGET","IIIB","IIIB","IIID","VII","IIIE","AAA","ADMIN","INTAKE","ADMIN","OUTREACH","ADMIN","WAIVER","ADMIN","(MAC)","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,null,null,"SPECIALISTS\nADMIN",null,null,null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE","CHANGE"]
["FEDERAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E161:W161)","v":0},{"$f":"D161-C161","v":0},{"$f":"Y161/C161","v":{"$error":"#DIV/0!"}}]
["STATE GENERAL REVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E162:W162)","v":0},{"$f":"D162-C162","v":0},{"$f":"Y162/C162","v":{"$error":"#DIV/0!"}}]
["PROGRAM INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["OTHER FUNDS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["LOCAL CASH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["     (MATCH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["IN-KIND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,{"$error":"#DIV/0!"}]
["     (MATCH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E168:W168)","v":0},0,{"$error":"#DIV/0!"}]
["TOTAL REVENUES",null,{"$f":"SUM(C161:C168)","v":0},{"$f":"SUM(D161:D168)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(P161:P168)","v":0},{"$f":"SUM(Q161:Q168)","v":0},0,0,0,0,0,0,{"$f":"SUM(X161:X168)","v":0},{"$f":"SUM(Y161:Y168)","v":0},{"$error":"#DIV/0!"}]
[]
[]
["TOTAL REVENUES",null,{"$f":"+C169","v":0},{"$f":"+D169","v":0},0,0,0,0,0,0,{"$f":"+K169","v":0},{"$f":"+L169","v":0},0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+Y169","v":0}]
["TOTAL EXPENSES",null,{"$f":"+C153","v":0},{"$f":"+D153","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"+N153","v":0},0,0,0,0,0,0,0,0,0,0]
["TOTAL REVENUE - EXPENSES",null,{"$f":"C172-C173","v":0},{"$f":"D172-D173","v":0},0,0,0,0,0,0,0,0,{"$f":"M172-M173","v":0},{"$f":"N172-N173","v":0},0,0,0,0,0,0,0,0,0,0,0]
["PERCENT REVENUE",null,{"$f":"C172/$C$172","v":{"$error":"#DIV/0!"}},{"$f":"D172/$C$172","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$f":"W172/$C$172","v":{"$error":"#DIV/0!"}},{"$f":"X172/$C$172","v":{"$error":"#DIV/0!"}},{"$f":"Y172/$C$172","v":{"$error":"#DIV/0!"}}]
["PERCENT CHANGE"]
[]
["Note 1: Please provide a narrative explanation of the use of funds (salary and other) from Title IIIB Set Aside (LAN), Title IIIB I&R, and any other DOEA-funded special project (separately for each category of funds).  Break out federally funded expenditures from other sources of funding.  If there are no funds allocated in the \"Other Projects Non-DOEA\" column, provide explanation here."]
["Enter text here:"]
["Note 2: Please provide a narrative explanation of bonuses paid that ensures they have been approved by the Board of Directors or indicate that no bonuses are paid."]
["Enter text here:"]
["Note 3: Please provide the following detail about each in and out-of-state conference budgeted:  Name of conference, number attending, and amount budgeted."]
["Enter text here:"]
["Note 4: Please provide a narrative explanation of planned expenditures in the communications category."]
["Enter text here:"]
["Note 5: Please provide a narrative explanation for planned purchases/expenditures in the equipment and other categories in the Title IIIB Set Aside, Title IIIB I&R, and any other DOEA-funded special project (separately for each category of funds).  Break out federally funded expenditures from other sources of funding."]
["Enter text here:"]
["Note 6: Please provide a narrative explanation for any percent budget change as identified in the % Budget Change column that exceeds the current year's budget by +/- 3 percent."]
["Enter text here:"]
["Note 7: Please list each service for which a Direct Service Waiver has been approved (current) or is being requested as they appear in the Program Module. Include the funding source for each service."]
["Enter text here:\n<Service Title>, <Funding Source>, <current or requested>\n<Service Title>, <Funding Source>, <current or requested>"]

{"sheet":"C.II.B.","index":27,"n_rows":63,"n_cols":14,"rows_kept":63,"cut":false,"hidden":false,"merged":[[57,0,57,1],[2,0,2,9],[4,0,4,9],[18,12,18,13],[48,12,48,13],[47,12,47,13]]}
["PSA:                    Original Submission Date:                                     ",null,null,null,null,null,null,null,null,null,null,":)"]
[]
["C.II.B. - OAA Budget Summary  "]
[]
["Instructions: Update all aqua-colored cells as appropriate. Purple cells are populated from the values entered in tab C.I.A. Carry Forward is not added at the time of the Area Plan. It will be added during Carry Forward amendments.\nThe total Admin match must be at least 25 percent of the federal funding. For titles III B, III CI, III CII, and III E, match must be at least 10 percent of the federal funding (match may be pulled between III B, III CI., and IIIC2.)"]
[]
[null,null,null,"(1)",null,"(2)",null,"(3)",null,"(4)"]
[null,null,null,"Federal",null,"General",null,"Local \nMatch/",null,"TOTAL"]
[null,null,null,"Funding",null,"Revenue",null,"CCE/HCE",null,"FUNDS"]
["1.  Area Agency Admin"]
["   A.  ","Current Year",null,{"$f":"'C.I.A.'!B16","v":0},null,{"$f":"'C.I.A.'!D31","v":0},null,null,null,{"$f":"SUM(D11:H11)","v":0}]
["   B.","Prior Year CF* ",null,{"$f":"'C.I.A.'!$B$17","v":0},null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
["   C.","Prior Year CF* (2016)",null,null,null,null,null,null,null,{"$f":"SUM(D13:H13)","v":0}]
["  CONTRACT TOTAL",null,null,{"$f":"SUM(D11:D13)","v":0},null,{"$f":"SUM(F11:F13)","v":0},null,{"$f":"SUM(H11:H13)","v":0},null,0]
["   D.","CCE GR Administration",null,null,null,null,null,{"$f":"'C.I.A.'!D32","v":0},null,0]
["   E.","HCE GR Administration",null,null,null,null,null,{"$f":"'C.I.A.'!D34","v":0},null,0]
["   F.","LSP Admin",null,null,null,null,null,{"$f":"'C.I.A.'!D38","v":0},null,0]
["   G.","LSP Services",null,null,null,null,null,null,null,0]
["   H.","Local Match",null,null,null,null,null,null,null,0,null,null,"Admin Match Check"]
["   TOTAL ADMIN",null,null,{"$f":"SUM(D14:D19)","v":0},null,{"$f":"SUM(F14:F19)","v":0},null,{"$f":"SUM(H14:H19)","v":0},null,{"$f":"SUM(D20:H20)","v":0},null,null,{"$f":"H20/D20","v":{"$error":"#DIV/0!"}},0.25]
["2.  Title IIIB"]
["   A.","Supportive Services"]
["     (1)","Current Year",null,{"$f":"'C.I.A.'!C16","v":0},null,null,null,null,null,{"$f":"SUM(D23:H23)","v":0}]
["(2)","Prior Year CF* ",null,{"$f":"'C.I.A.'!$C$17","v":0},null,null,null,null,null,0]
["(3)","Prior Year CF* (2016)",null,null,null,null,null,null,null,0]
["     TOTAL",null,null,{"$f":"SUM(D23:D25)","v":0},null,null,null,{"$f":"SUM(H23:H25)","v":0},null,0]
["   B.","IIIB Set-Aside (also included in Total)",null,{"$f":"'C.I.A.'!C20","v":0},null,null,null,null,null,0]
["   C.","IIIB Disaster Recovery Reserve (also included in Total)",null,{"$f":"'C.I.A.'!C21","v":0},null,null,null,null,null,0]
["3.  Title IIIC1 Nutrition Services"]
["   A.","Current Year",null,{"$f":"'C.I.A.'!D16","v":0},null,null,null,null,null,{"$f":"SUM(D30:H30)","v":0}]
["   B.","Prior Year CF* ",null,{"$f":"'C.I.A.'!$D$17","v":0},null,null,null,null,null,{"$f":"SUM(D31:H31)","v":0}]
["   C.","Prior Year CF* (2016)",null,null,null,null,null,null,null,{"$f":"SUM(D32:H32)","v":0}]
["     TOTAL",null,null,{"$f":"SUM(D30:D32)","v":0},null,null,null,{"$f":"SUM(H30:H32)","v":0},null,{"$f":"SUM(D33:H33)","v":0}]
["   D.","IIIC1 Disaster Recovery Reserve (also included in Total)",null,{"$f":"'C.I.A.'!D21","v":0},null,null,null,null,null,{"$f":"SUM(D34:H34)","v":0}]
["4.  Title IIIC2 Nutrition Services"]
["   A.","Current Year",null,{"$f":"'C.I.A.'!E16","v":0},null,null,null,null,null,{"$f":"SUM(D36:H36)","v":0}]
["   B.","Prior Year CF* ",null,{"$f":"'C.I.A.'!$E$17","v":0},null,null,null,null,null,{"$f":"SUM(D37:H37)","v":0}]
["   C.","Prior Year CF* (2016)",null,null,null,null,null,null,null,{"$f":"SUM(D38:H38)","v":0}]
["     TOTAL",null,null,{"$f":"SUM(D36:D38)","v":0},null,null,null,{"$f":"SUM(H36:H38)","v":0},null,{"$f":"SUM(D39:H39)","v":0}]
["   D.","IIIC2 Disaster Recovery Reserve (also included in Total)",null,{"$f":"'C.I.A.'!E21","v":0},null,null,null,null,null,{"$f":"SUM(D40:H40)","v":0}]
["5.  Title IIID Preventive Health"]
["   A.","Current Year",null,{"$f":"'C.I.A.'!G16","v":0},null,null,null,null,null,{"$f":"SUM(D42:H42)","v":0}]
["   B.","Prior Year CF* ",null,{"$f":"'C.I.A.'!$G$17","v":0},null,null,null,null,null,{"$f":"SUM(D43:H43)","v":0}]
["   C.","Prior Year CF* (2016)",null,null,null,null,null,null,null,{"$f":"SUM(D44:H44)","v":0}]
["   TOTAL",null,null,{"$f":"SUM(D42:D44)","v":0},null,null,null,null,null,{"$f":"SUM(D45:H45)","v":0}]
["6.  Title IIIE Caregiver Support Services"]
["   A.","Current Year",null,0,null,null,null,0,null,{"$f":"SUM(D47:H47)","v":0}]
["   B.","Prior Year CF* ",null,{"$f":"'C.I.A.'!$H$17","v":0},null,null,null,null,null,{"$f":"SUM(D48:H48)","v":0}]
["   B.","Prior Year CF* (2016)",null,null,null,null,null,null,null,{"$f":"SUM(D49:H49)","v":0},null,null,"Program Match Check"]
["   TOTAL",null,null,{"$f":"SUM(D47:D49)","v":0},null,null,null,{"$f":"SUM(H47:H49)","v":0},null,{"$f":"SUM(D50:H50)","v":0},null,null,{"$f":"SUM(H50,H39,H33,H26)/SUM(D50,D39,D33,D26)","v":{"$error":"#DIV/0!"}},0.1]
["7.  NSIP"]
["   A.","Current Year",null,{"$f":"'C.I.A.'!I16","v":0},null,null,null,null,null,{"$f":"SUM(D52:H52)","v":0}]
["   B.","Prior Year CF* ",null,{"$f":"'C.I.A.'!$I$17","v":0},null,null,null,null,null,{"$f":"SUM(D53:H53)","v":0}]
["   TOTAL",null,null,{"$f":"SUM(D52:D53)","v":0},null,null,null,null,null,{"$f":"SUM(D54:H54)","v":0}]
["7.  Total Federal Current Year Funds Awarded"]
["(Sum of 1.A, 2.A(1), 3.A, 4.A, 5.A., 6.A, 7.A)",null,null,{"$f":"SUM(D11,D23,D30,D36,D42,D47,D52)","v":0}]
["8. Total CF Funds Awarded"]
["(Sum of 1.B, 1.C, 2.A(2), 2.A.(3), 3.B, 3.C, 4.B, 4.C, 5.B, 5.C, 6.B, 6.C, 7B)",null,null,{"$f":"SUM(D12:D13)+SUM(D24:D25)+SUM(D31:D32)+SUM(D37:D38)+SUM(D43:D44)+SUM(D48:D49)+D53","v":0}]
["9.  Total GR Awarded"]
["(Total of column (2))",null,null,{"$f":"F20","v":0}]
["10.Total of All Funds to be Received"]
["(Sum of  8, 9, 10)",null,null,{"$f":"D56+D58+D60","v":0}]
["* Carry Forward"]

{"sheet":"C.II.C.","index":28,"n_rows":7,"n_cols":7,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,0,2,5]]}
["PSA:                    Original Submission Date:                                    ",null,null,null,null,null,":)"]
[]
["C.II.C. - Financial and Compliance Audit Schedule "]
[]
["Instructions: Enter the financial and compliance audit schedule for your sub-contractor agencies."]
[]
["Sub-Contractor Agency","Sub-Contractor Fiscal Year","Last Audit Period End Date","Status of Action on Audit Findings and Recommendations","Date Due to Contract Manager","Estimated Date of Next Report"]

{"sheet":"C.III","index":29,"n_rows":7,"n_cols":5,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,0,4,3]]}
["PSA:                    Original Submission Date:                                    ",null,null,null,":)"]
[]
["C.III - AAA MONITORING SCHEDULE  "]
[]
["This worksheet contains a description of the AAA fiscal and programmatic monitoring schedule, to include all DOEA-funded service providers."]
[]
["Provider","Date\n of Visit","Program /\nService","Fiscal Admin/\nProgrammatic"]

{"sheet":"C.IV","index":30,"n_rows":35,"n_cols":40,"rows_kept":35,"cut":false,"hidden":false,"merged":[[2,0,2,8],[5,0,5,8],[10,3,10,15],[6,0,6,13],[4,0,4,13],[8,0,8,13],[7,0,7,13],[10,16,10,38],[11,3,11,5],[11,7,11,9],[11,10,12,10],[11,17,11,19],[11,32,13,32],[11,34,11,38],[11,20,11,29]]}
["PSA:                    Original Submission Date:                                    ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,":)"]
[]
["C.IV - CONTRACT PROVIDERS"]
[]
["This worksheet contains contact information for each contract agency including Community Focal Points, Senior Centers, Lead Agencies, and Aging and Disability Resource Center Access Points.  "]
[]
["Instructions for completing the form: Provider information needed for this report that was not entered in CIRTS will need to be manually added. In addition, information for some providers may be needed that is not in CIRTS and will need to be manually updated. Each row should be reviewed for accuracy before the report is submitted.  \n\n\n"]
["For each provider, complete each of the applicable fields in the row. Enter the information in each of the cells in the contact information section. In the Programmatic Information  section, enter an \"X\" in each applicable cell except for columns AG, AH, AK which require information to be entered. In AG and AH, specify the program name in the column header (replacing the word Other) if there are any additional programs, then enter an \"X\" in the applicable cells in the column(s). Insert additional columns if there are more than the two programs to add. In AK, provide the name of the sponsoring organization in the relevant cell if the provider is a Senior Center or Foal point. For Access Points, Focal Points, and Senior Centers, leave the programmatic information blank. The intention is to only have to enter a provider once. However, providers that serve multiple counties will have a row for each county. Providers that are primary contractors but also subcontractors for DOEA services will need to complete a row for each entity for whom the provider is the subcontractor in addition to the row that reflects the information as a Primary Contractor. The intent is to be able to sort the spreadsheet by county, program, or any of the programmatic information and have a list of providers while limiting the amount of data entry.  Add rows as necessary."]
["Instructions on how to run the report:\n1)Run delimited data CIRTS report (Aging Network Provider Report); 2) Report # 1 under Miscellaneous CIRTS reports, A) Select delimited data; \nB) Click Edit, Select All, Edit, Copy; C) Open Notepad; D) Click Edit, Paste; E) Click file, save as and save the file to your computer; \nF) Open Excel; G) Click on the Data tab; H) Click on Get External Data from Text; I) Click on the file you just saved; J) Click Import; \nK) A Text Wizard will pop up; L) Click Next, Next, Finish; M) An Import Data Box will pop up; N) Click ok."]
["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ"]
[null,null,null,"Contact Information",null,null,null,null,null,null,null,null,null,null,null,null,"Programmatic Information"]
[null,null,null,"Mailing Address",null,null,null,"Physical Address",null,null,null,null,null,null,null,null,null,"Type of Organization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sponsoring Organization Name\n(if Sr. Center or Focal Point is checked)",null,"Check each box that applies to the Sr. Center operations"]
[]
["Row #","PSA","Agency Name","Street  Address","City","County","Zip Code","Street Address","City","County ","County Served \n(One row per county)","Zip\n Code","Phone Number","Fax","Director Name","Contact Person Name","CCE\nLead Agency","Govt.","Non-Profit","Profit- Making","ADI","CCE","EHEAP","HCE","LSP","NSIP","OAA","RELIEF","Other\n(Please List)","Other\n(Please List)","Access \nPoint","Focal Point",null,"Senior Center","Congregate\nDining","Health\nScreening","Recreational\nClass","Learning\nOpportunities","Regular\nHours"]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
["1  If an entity is a Primary Contractor and also a Sub-Contractor for DOEA services, complete a row for the Contractor, and additional rows for each entity for which the provider is  a sub-contractor."]

{"sheet":"C.V","index":31,"n_rows":62,"n_cols":6,"rows_kept":62,"cut":false,"hidden":false,"merged":[[26,0,26,4],[35,0,35,4],[53,0,53,4],[59,0,59,4],[55,0,55,4],[37,0,37,4],[32,0,32,4],[39,0,39,4],[41,0,41,4],[47,0,47,4],[51,0,51,4],[4,0,4,4],[8,0,8,4],[10,0,10,4],[15,0,15,4],[22,0,22,4]]}
["PSA:                    Original Submission Date:                                    ",null,null,null,null,":)"]
[]
["C.V - CONTRACT MODULE REVIEW CHECKLIST"]
[]
["Instructions: Indicate whether each item is included in the area plan (Yes/No/Not Applicable), and identify the area plan page numbers(s) where the item can be found."]
[]
[null,"ITEM INCLUDED"]
["Contract Module","YES","NO","N/A","PAGE"]
["Table of Contents"]
["The location of each section of the contract module is accurately reflected."]
["Contract Module Certification Page"]
["The form is properly completed."]
["The form is signed by Board President (or Designee) and dated."]
["The form is signed by Advisory Council Chair and dated."]
["The form is signed by Executive Director and dated."]
["Section C.I.A. Allocation to the Planning and Service Area"]
["The OAA funding amounts are correct."]
["Transfers between titles are within allowable percentages  (IIIB to IIIC or IIIC to IIIB - no more than 30 percent; IIIC1 to IIIC2 or IIIC2 to IIIC1 - no more than 40 percent)."]
["The Title IIIB total includes the set aside amount and includes a footnote that indicates the amount set aside."]
["The Title IIIB set aside amount currently approved by the Department did not increase."]
["General revenue amounts are correct."]
["Amounts for supplemental resource activities are reflected."]
["Section C.I.B. OAA Title III Priority Services Expenditures"]
["Title III B funds allocated to OAA Access Services meet or exceed 20 percent."]
["Title III B funds allocated to OAA In-Home Services meet or exceed eight percent."]
["Title III B funds allocated to OAA Legal Assistance Services meet or exceed one percent."]
["Section C.I.C. Service Units and Costs Projections Provider Summary"]
["Provider summary information from the PSA-Summary Service Units and Costs Projections CIRTS report has been entered correctly for each provider."]
["Provider summary information from the PSA-Summary Service Units and Costs Projections CIRTS report has been entered correctly for the AAA as the provider of direct services."]
["Services provided directly by the AAA are reflected."]
["Funds are allocated only to allowable services."]
["The actual and negotiated unit rates are provided."]
["Section C.I.E. Service Units and Costs Projections - \nPlanning and Service Area Summary"]
["PSA summary information from CIRTS has been entered correctly."]
["Data in CIRTS reconciles to the contract amounts."]
["Section C.I.F.AAA. Areawide Funding Profile"]
["Accurate areawide information for the PSA is displayed on a separate form."]
["Section C.I.F. County Funding Profiles"]
["Accurate information for each county in the PSA is displayed on a separate form."]
["Section C.I.G. Areawide Funding Summary"]
["The roll-up of all funds allocated to the PSA, including funds allocated to services provided directly by the AAA is accurately reflected."]
["Section C.II.A. AAA Operating Budget Allocation"]
["All pages (1-6) were submitted as a separate attachment."]
["Pages 1-6 of the detailed operating budget and cost allocation plan accurately display the breakout of salaries and expenses by positions and funding sources."]
["Includes narrative justification for the planned purchase/expenditures in the equipment and other categories in the III B set aside funds."]
["Includes written explanation of planned expenditures in the communications category."]
["All expenses of the Agency are reflected in the budget.  Non-DOEA column is completed with the portion not funded through DOEA."]
["Section C.II.B. OAA Budget Summary"]
["The minimum match requirement of 25 percent is met for administration."]
["The minimum match requirement of 10 percent is met for services."]
["The III B set aside amount was not increased."]
["Section C.II.C. Financial and Compliance Audit Schedule"]
["The form is completed in its entirety."]
["Section C.III AAA Monitoring Schedule"]
["The form displays the schedule for conducting fiscal and programmatic monitoring of service providers."]
["Section C.IV Contract Providers"]
["The form includes the name, address, phone number, and fax number for each contract and subcontract provider."]
["The form includes a contact person for each contract and subcontract provider."]
["The form identifies the type of organization (government, non-profit, profit-making) for each contract and subcontract provider."]
["Section C.V  Contract Module Review Checklist"]
["The form indicates whether each item is included in the Contract Module."]
["The form identifies the page location(s) of each item."]

{"sheet":"Attachments","index":32,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,0,5,1]]}
["PSA:                    Original Submission Date:                                    ",null,":)"]
[]
["Contract Module Attachments"]
[]
["This worksheet lists the names of all Contract Module attachments."]
["Instructions: We recommend entering all Contract Module information in this workbook.  If information not requested in the pre-formatted worksheets needs to be entered, you may insert additional worksheets into which you insert your information.  If information you want added cannot be easily entered into this workbook, enter the name and file type below of each attachment you will be including as part of the Contract Module."]
[]
["Attachment Name","Attachment\nFile Type"]