{"text_format":"1","workbook":"xlsx","n_sheets":29,"sheets":["Title Page","About This File","Table of Contents","Certification Page","C.I.A.","C.I.B.","C.I.C.","C.I.D.","C.I.E.","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."],"not_rendered":{"charts":0,"images":34,"macros":1,"external_links":0,"defined_names":30,"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":20,"n_cols":1,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Area Plan on Aging"]
[]
["Contract Module"]
[]
["Template and Instructions for Three-Year Cycle\n1/1/2009 - 12/31/2011"]
[]
["Contract Year 3: 01/01/2011 - 12/31/2011"]

{"sheet":"About This File","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"About This Contract Module File"]
[]
[null,null,"Instructions:\n1. All information needed in the Contract Module portion of your area plan should be placed in this Excel workbook (Contract Module Part 1.xls), in the file Contract Module Part 2.xls or a separte file referenced in this workbook.  If you want to add additional information to 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 Contract Module Parts I and II.\n\n"]
[null,null,"2.Enter your PSA number 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:.\""]
[null,null,"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."]
[null,null,"4. When you are ready to print the entire Contract Module you will need to ensure the page numbers of Contract Module Part 2 follow those of Contract Module Part 1.  The starting page number in Contract Module Part 2 may need to be changed.  Determine the number of pages in contract Contract Module Part 1, then set the starting page number in Contract Module Part 2 to the following page number.  One way to determine the number of pages in Contract Module Part 1 is to right-click on any sheet tab, select \"Select All Sheets\" from the shortcut menu, then select \"Print Preview\" from the File menu. Click \"Next\" until you arrive at the last page.  IMPORTANT: In order to continue editing a worksheet after you have selected all worksheets, you must ungroup your worksheets.  You may do so by right-clicking on a tab and selecting \"Ungroup Sheets\" from the menu.  Failure to do so will cause all edits to occur on all selected sheets."]
[null,null,"To set the starting page number in the Contract Module Part 2, click on tab C.II.C. in Contract Module Part 2 and select \"Page Setup\" from the File menu.  Enter the correct starting page number in the field \"First Page Number\" then click OK."]
[]
[null,null,"General Information About Colors Used in This Workbook"]
[null,null,"Cells in this workbook are color coded as follows:"]
[]
[null,null," Purple cells are calculated (contain formulas).  Data should not be typed into purple cells. "]
[null,null,"Yellow cells require your input.  The information should come directly from the allocation spreadsheet issued by the department. "]
[null,null,"Aqua fields require your input if applicable.  "]
[null,null,"Gray cross-hatched cells are not applicable and should not be updated."]

{"sheet":"Table of Contents","index":2,"n_rows":27,"n_cols":4,"rows_kept":27,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,1,1,3]]}
["Contract Module Table of Contents"]
[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."]
[]
[null,"Section","Item","Page"]
[null,null,"Contract Module Certification Page"]
[null,"Section C.I.A.","Allocation to the Planning and Service Area (PSA)"]
[null,"Section C.I.B.","OAA TITLE IIIB Services Expenditures"]
[null,"Section C.I.C.","Service Units and Costs Projections Provider Summary"]
[null,"Section C.I.D.","Blank worksheet to prevent renaming of remaining sections"]
[null,"Section C.I.E.","Service Units and Costs Projections PSAs"]
[null,"Section C.I.F.AAA.","Areawide Funding Profile"]
[null,"Section C.I.F.","County Funding Profile"]
[null,"Section C.I.G.","Areawide Funding Summary"]
[null,"Section C.II.A.","AAA Administration Budget"]
[null,"Section C.II.B.","OAA Budget Summary"]
[null,"Section C.II.C.","Financial and Compliance Audit Schedule"]
[null,"Section C.III.A.","AAA Monitoring Schedule"]
[null,"Section C.IV.A.","Civil Rights Compliance"]
[null,"Section C.IV.B.","Section 504 Assurance"]
[null,"Section C.V.A.","Availability of Documents"]
[null,"Section C.VI.A.","Contract Providers (OAA Contract Agencies)"]
[null,"Section C.VI.A.","Contract Providers (Medicaid Waiver Agencies)"]
[null,"Section C.VI.A.","Contract Providers (All Other Contract Agencies)"]
[null,"Section C.VII.A.","AAA Board of Directors"]
[null,"Section C.VII.B","AAA Advisory Council Members"]
[null,"Section C.VIII.A.","Contract Module Review Checklist"]
[null,null,"Contract Module Attachments"]

{"sheet":"Certification Page","index":3,"n_rows":47,"n_cols":5,"rows_kept":47,"cut":false,"hidden":false,"merged":[[47,2,47,4],[41,2,41,4],[44,2,44,4],[2,0,2,5],[36,2,36,4],[0,0,0,4],[38,2,38,4],[37,2,37,4],[34,2,34,4],[35,2,35,4],[32,2,32,4],[31,2,31,4],[30,2,30,4],[19,2,19,4]]}
["Contract Module Certification Page"]
[]
["Instructions: This Certification Page is to be completed as indicated and signed by the Board President or other authorized official, the Advisory Council chair and the AAA Executive Director.  This form is submitted only with the original submission of the Contract Module. An updated Certification Page must be submitted when the Area Plan Contract Module is updated to incorporate General Revenue funds each state fiscal year. The certification page still has an entry for ARRA.  Although the ARRA nutrition funding discontinues September 30, the AAA may have other ARRA funding."]
[]
[]
[null,null,"1.  AREA AGENCY ON AGING  ",null,"2.  GOVERNING BOARD CHAIR:"]
[null,null,"     INFORMATION:",null,"     (Name/Address/Phone)"]
[null,null,"Legal Name of Agency:"]
[]
[]
[null,null,"Mailing Address:"]
[]
[null,null,null,null,"3.  ADVISORY COUNCIL CHAIR:"]
[null,null,null,null,"     (Name/Address/Phone)"]
[null,null,"Telephone:  [         ]"]
[]
[null,null,"FEDERAL ID NUMBER :"]
[]
[]
[null,null,"4.  FUNDS ADMINISTERED: (check all that apply)"]
[null,null,"             OAA Title IIIB",null,"o     RELIEF"]
[null,null,"             OAA Title IIIC",null,"o     NSIP"]
[null,null,"             OAA Title IIID",null,"o     ADA Waiver"]
[null,null,"             OAA Title IIIE",null,"o     ALE Waiver"]
[null,null,"             OAA Title VII   ",null,"o     SHINE"]
[null,null,"             CCE",null,"o     EHEAP"]
[null,null,"             HCE",null,"       ARRA"]
[null,null,"             ADI"]
[null,null,"             LSP"]
[]
[null,null,"5.  CERTIFICATION BY BOARD PRESIDENT, ADVISORY COUNCIL CHAIR, AAA DIRECTOR:"]
[]
[null,null,"I hereby certify that the attached document:"]
[]
[]
[]
[]
[]
[null,null,"I further certify that the contents are true, accurate and complete statements.  I acknowledge that intentional misrepresentation or falsification may result in the termination of financial assistance.  I have reviewed and approved the 2010 update to the 2009-2011 area plan:"]
[null,null,"Name:                                                          Signature:                                                                Date:                            "]
[null,null,"(President, Board of Directors)"]
[]
[null,null,"Name:                                                          Signature:                                                                Date:                            "]
[null,null,"  (Advisory Council Chair)"]
[]
[null,null,"Name:                                                          Signature:                                                                Date:                            "]
[null,null,"(Area Agency on Aging Director)"]

{"sheet":"C.I.A.","index":4,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[36,7,36,9],[35,7,35,9],[43,7,43,9],[42,7,42,9],[41,7,41,9],[40,7,40,9],[39,7,39,9],[38,7,38,9],[31,0,31,2],[4,0,4,10],[7,0,7,10],[22,0,22,10],[26,0,27,2],[26,7,27,9],[25,0,25,3],[25,7,25,10],[5,0,5,10],[32,7,32,9],[33,0,33,2],[3,0,3,10],[37,0,37,2],[36,0,36,2],[35,0,35,2],[34,0,34,2],[32,0,32,2],[28,0,28,2],[29,0,29,2],[30,0,30,2],[28,7,28,9],[31,7,31,9],[29,7,29,9],[34,7,34,9],[33,7,33,9]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["Section C.I.A.  Allocation to the Planning and Service Area "]
["This worksheet documents all Federal 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; C1 to C2 or C2 to C1 can be no more than 40 percent.)  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 WebDB. 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 III B, include the total amount for Title III B services in the table and indicate below the table the portion of this total maintained by the AAA as Title III B set aside.  The Title III B set aside currently approved by the department cannot be increased. Modify the label \"ARC/ADRC\" below in the  SUPPLEMENTAL RESOURCE ACTIVITIES table so it reads \"ARC\" or \"ADRC,\" as appropriate for your PSA.   In accord 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 OTHER.)  ARRA was removed from the worksheet since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
["         FEDERAL ALLOCATION TO THE PLANNING AND SERVICE AREA  "]
[]
["OAA FEDERAL FUNDING","AAA","TITLE","TITLE","TITLE","TRANSFER","TITLE","TITLE","TITLE","TITLE","TOTAL OAA"]
["COMPOSITION","ADMIN","III B","III C1","III C2","AMOUNT","III D1","III D2","III E","VII","Minus VII"]
["Original Allocation\nFFY 2010-11",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B12:E12)+SUM(G12:I12)","v":0}]
["Revised Allocation\nFFY 2010-11",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,null,null,null,null,null,{"$f":"SUM(B14:F14)","v":0}]
["Plus (+)\nTransfer Amount",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B15:F15)","v":0}]
["Adjusted Amount\nFFY 2010-11",{"$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 2009-10",null,null,null,null,null,null,null,null,null,{"$f":"SUM(B17:I17)","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}]
[]
["Title III B Total Funds include $",null,null," in set aside funds (included in the Title III B column)."]
[]
[]
[" 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,null," SUPPLEMENTAL RESOURCE ACTIVITIES \n(STATE, FEDERAL & PRIVATE)"]
["FUNDING COMPOSITION",null,null,"FFY 2010-11",null,null,null,"SOURCE OF FUNDING",null,null,"AMOUNT"]
[null,null,null,"GR AMOUNTS",null,null,null,null,null,null,"OF FUNDING"]
["AAA ADMINISTRATION",null,null,null,null,null,null,"NSIP"]
["CCE ADMINISTRATION",null,null,null,null,null,null,"EHEAP"]
["CCE SERVICES",null,null,null,null,null,null,"EHEAP ADMINISTRATION"]
["HCE ADMINISTRATION",null,null,null,null,null,null,"ADA WAIVER"]
["HCE CASE MANAGEMENT",null,null,null,null,null,null,"ALE WAIVER"]
["HCE SUBSIDY",null,null,null,null,null,null,"MED WAIVER SPECIALIST"]
["ADI ADMINISTRATION",null,null,null,null,null,null,"SHINE"]
["ADI SERVICES",null,null,null,null,null,null,"RELIEF"]
["LSP ADMINISTRATION",null,null,null,null,null,null,"ARC/ADRC"]
["LSP SERVICES",null,null,null,null,null,null,"OTHERS (LIST BELOW):"]

{"sheet":"C.I.B.","index":5,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[25,0,25,5],[5,0,5,5],[4,0,4,5],[9,0,9,5],[16,0,16,5]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["Section 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. "]
["Instructions: 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). The \"% of Total IIIB Allocation\" column is calculated based on the percentage of the amounts entered on tab C.I.A.  The 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.  IIIB Non-Priority Services needs to include set aside funds and other funds allocated to the AAA not included in IIIB Priority Services."]
[]
["Title III B Expenditures","Funds Allocated","% of Total IIIB Allocation","# Units of Services Provided","# of Unduplicated Consumers Served","% of Total 60+ Population*"]
["IIIB Priority Services"]
["Access Services"]
["Information",null,{"$f":"B11/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E11/E32","v":{"$error":"#DIV/0!"}}]
["Referral",null,{"$f":"B12/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E12/E32","v":{"$error":"#DIV/0!"}}]
["Outreach",null,{"$f":"B13/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E13/E32","v":{"$error":"#DIV/0!"}}]
["Transportation",null,{"$f":"B14/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E14/E32","v":{"$error":"#DIV/0!"}}]
["Subtotal",{"$f":"SUM(B11:B14)","v":0}]
[{"$f":"B15/B30","v":{"$error":"#DIV/0!"}},"= amount allocated for Access Services (must be equal to or greater than 20%)"]
["In-Home Services"]
["Homemaker",null,{"$f":"B18/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E18/E32","v":{"$error":"#DIV/0!"}}]
["Personal Care",null,{"$f":"B19/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E19/E32","v":{"$error":"#DIV/0!"}}]
["In-Home Respite",null,{"$f":"B20/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E20/E32","v":{"$error":"#DIV/0!"}}]
["Chore",null,{"$f":"B21/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E21/E32","v":{"$error":"#DIV/0!"}}]
["Companionship",null,{"$f":"B22/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E22/E32","v":{"$error":"#DIV/0!"}}]
["Telephone Reass.",null,{"$f":"B23/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E23/E32","v":{"$error":"#DIV/0!"}}]
["Subtotal",{"$f":"SUM(B18:B23)","v":0}]
[{"$f":"B24/B30","v":{"$error":"#DIV/0!"}},"= amount allocated for In-Home Services (must be equal to or greater than 8%)"]
["Legal Assistance"]
["Legal Assistance",null,{"$f":"B27/C.I.A.!C18","v":{"$error":"#DIV/0!"}},null,null,{"$f":"E27/E32","v":{"$error":"#DIV/0!"}}]
[{"$f":"B27/B30","v":{"$error":"#DIV/0!"}},"= amount allocated for Legal Services (must be equal to or greater than 1%)"]
["IIIB Non-Priority Services",null,{"$f":"B29/C.I.A.!C18","v":{"$error":"#DIV/0!"}}]
["Total  IIIB ",{"$f":"B15+B24+B27+B29","v":0},{"$f":"B30/C.I.A.!C18","v":{"$error":"#DIV/0!"}},{"$f":"SUM(D11:D14)+SUM(D18:D23)+D27+D29","v":0},{"$f":"SUM(E11:E14)+SUM(E18:E23)+E27+E29","v":0}]
[]
["* To have % total 60+ population computed, enter 60+ population:"]

{"sheet":"C.I.C.","index":6,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":false,"merged":[[4,0,4,7],[6,0,6,7]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["Section C.I.C.  PSA-Wide Service Units and Costs Projections"]
[]
["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.  Services provided directly by the AAA must also be reflected.  "]
[]
["Instructions: Run the WebDB summary report “PSA-wide: C.I.C. Service Units and Costs Projections.”  Select your PSA and run the report for each general revenue program and Older Americans Act title.  After each report is run, select and copy the contents of the report FROM THE PROGRAM NAME DOWN to the bottom of the report and paste the report into this worksheet.  Each report should be pasted one after the other."]

{"sheet":"C.I.D.","index":7,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":false,"merged":[[2,0,2,7]]}
["Section C.I.D.  Service Units and Costs Projections County Summaries  "]
[]
["This Section Is No Longer Required for the Area Plan"]
[]
["Worksheet left blank to prevent renaming of remaining sections"]

{"sheet":"C.I.E.","index":8,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,0,2,8],[4,0,4,8],[5,0,5,8],[7,0,7,8]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["C.I.E. Service Units and Cost Projections "]
[]
["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: Run the WebDB summary report “C.I.E. Service Units and Costs Projections - PSA Summary.”  Select your PSA and run the report for each general revenue program and Older Americans Act title.  After each report is run, select and copy the contents of the report FROM THE PROGRAM NAME DOWN to the bottom of the report and paste the report into this worksheet.  Each report should be pasted one after the other. Do not use the report “All Programs: C.I.E. Service Units and Costs Projections - PSA Summary” for this section because the programs need to be run separately since they span different fiscal years.\nNote:  Unduplicated client count and unit rate data must be reported in WebDB.  Data entered in WebDB must reconcile to contract amounts.  Printouts from WebDB for each of the general revenue programs and Older Americans Act titles are to be submitted with the area plan."]
[]
["(Insert WebDB Pages)"]

{"sheet":"C.I.F.AAA","index":9,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[2,0,2,3],[3,0,3,7],[4,0,4,7]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["C.I.F.AAA. AREAWIDE FUNDING PROFILE  "]
["This worksheet lists the amount retained at the AAA for areawide use.  Amounts 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.  The amounts entered on this form must be apportioned to each county on the C.I.F. tabs.  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 set aside.  \"OAA IIIB set aside\" is automatically populated on line two from the value on C.I.A.  "]
["Instructions: \nUpdate all aqua-colored cells as appopriate.  Purple cells are calculated automatically.  Enter the amount of all funding allocated for areawide activities or handled as an AAA allocation. ARRA was removed from the worksheet since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources.\""]
[]
[]
[null,"Federal/State Share:","Federal:",0.66539999999999999]
[null,null,"State:",0.33460000000000001]
[null,"AREAWIDE"]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA IIIB Set Aside",{"$f":"C.I.A.!C20","v":0},null,0]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B17:C17)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA ADMINISTRATION",{"$f":"C.I.A.!B18","v":0},{"$f":"C.I.A.!D29","v":0},{"$f":"SUM(B21:C21)","v":0}]
["OAA  TOTAL",{"$f":"SUM(B13:B21)","v":0},{"$f":"C21","v":0},{"$f":"SUM(D13:D20)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B23:C23)","v":0}]
["ALE WAIVER",null,null,0]
["MED. WAIVER SPECIALIST",{"$f":"C.I.A.!K34*D8","v":0},{"$f":"C.I.A.!K34*D9","v":0},0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",{"$f":"C.I.A.!K31","v":0},null,{"$f":"SUM(B27:C27)","v":0}]
["NSIP",null,null,0]
["CCE",null,null,0]
["CCE ADMINISTRATION",null,{"$f":"C.I.A.!D30","v":0},0]
["ADI",null,null,0]
["ADI ADMINISTRATION",null,{"$f":"C.I.A.!D35","v":0},0]
["HCE",null,null,0]
["HCE ADMINISTRATION",null,{"$f":"C.I.A.!D32","v":0},0]
["LSP",null,null,0]
["LSP ADMINISTRATION",null,{"$f":"C.I.A.!D37","v":0},0]
["SHINE",{"$f":"C.I.A.!K35","v":0},null,0]
["RELIEF",null,null,{"$f":"SUM(B38:C38)","v":0}]
["ARC/ADRC",null,{"$f":"C.I.A.!K37","v":0},{"$f":"SUM(B39:C39)","v":0}]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B41:C41)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B22:B46)","v":0},{"$f":"SUM(C22:C46)","v":0},{"$f":"SUM(D22:D46)","v":0}]

{"sheet":"C.I.F.(1)","index":10,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(2)","index":11,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(3)","index":12,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(4)","index":13,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(5)","index":14,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(6)","index":15,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(7)","index":16,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(8)","index":17,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(9)","index":18,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(10)","index":19,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(11)","index":20,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(12)","index":21,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(13)","index":22,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(14)","index":23,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(15)","index":24,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.F.(16)","index":25,"n_rows":38,"n_cols":4,"rows_kept":38,"cut":false,"hidden":false,"merged":[[9,2,9,3],[2,0,2,3],[3,0,3,3],[4,0,4,3]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["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. Sixteen 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."]
["Instructions: \nUpdate all aqua-colored cells as appropriate.  Purple cells are calculated automatically.  Enter the county name in the first row.  ARRA was removed from the worksheets since this funding source is discontinued as of September 30, 2010.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources."]
[]
[null,null,null,"Federal/State Share:"]
[null,null,null,"Federal:  66.54%"]
[null,null,null,"State:  33.46%"]
[null,"COUNTY:  "]
["PROGRAM","FEDERAL","STATE","TOTAL"]
[null,"SHARE","SHARE","BUDGETED"]
["OAA IIIB",null,null,{"$f":"SUM(B13:C13)","v":0}]
["OAA C1",null,null,0]
["OAA C2",null,null,0]
["OAA IIID1",null,null,{"$f":"SUM(B16:C16)","v":0}]
["OAA IIID2",null,null,0]
["OAA IIIE",null,null,0]
["OAA VII",null,null,0]
["OAA  TOTAL",{"$f":"SUM(B13:B19)","v":0},null,{"$f":"SUM(D13:D19)","v":0}]
["ADA WAIVER",null,null,{"$f":"SUM(B21:C21)","v":0}]
["ALE WAIVER",null,null,0]
["EHEAP",null,null,0]
["EHEAP ADMINISTRATION",null,null,0]
["NSIP",null,null,0]
["CCE",null,null,0]
["ADI",null,null,0]
["HCE",null,null,0]
["LSP",null,null,0]
["RELIEF",null,null,0]
["OTHERS (List Below):"]
[{"$f":"C.I.A.!H39","v":0},null,null,{"$f":"SUM(B32:C32)","v":0}]
[{"$f":"C.I.A.!H40","v":0},null,null,0]
[{"$f":"C.I.A.!H41","v":0},null,null,0]
[{"$f":"C.I.A.!H42","v":0},null,null,0]
[{"$f":"C.I.A.!H43","v":0},null,null,0]
[{"$f":"C.I.A.!H44","v":0},null,null,0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B20:B37)","v":0},{"$f":"SUM(C20:C37)","v":0},{"$f":"SUM(D20:D37)","v":0}]

{"sheet":"C.I.G.","index":26,"n_rows":48,"n_cols":7,"rows_kept":48,"cut":false,"hidden":false,"merged":[[36,1,36,2],[4,0,4,3],[5,0,5,3],[7,0,8,0]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["Section 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\" does not include set aside.  \"OAA IIIB Set Aside\" is automatically populated on line two from the 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)'!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(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-D11","v":0}]
["OAA C1",{"$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,{"$f":"SUM(B12:C12)","v":0},null,{"$f":"C.I.A.!D18","v":0},{"$f":"F12-D12","v":0}]
["OAA C2",{"$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,{"$f":"SUM(B13:C13)","v":0},null,{"$f":"C.I.A.!E18","v":0},0]
["OAA IIID1",{"$f":"'C.I.F.(1)'!B16+'C.I.F.(2)'!B16+'C.I.F.(3)'!B16+'C.I.F.(4)'!B16+'C.I.F.(5)'!B16+'C.I.F.(6)'!B16+'C.I.F.(7)'!B16+'C.I.F.(8)'!B16+'C.I.F.(9)'!B16+'C.I.F.(10)'!B16+'C.I.F.(11)'!B16+'C.I.F.(12)'!B16+'C.I.F.(13)'!B16+'C.I.F.(14)'!B16+'C.I.F.(15)'!B16+'C.I.F.(16)'!B16","v":0},null,{"$f":"SUM(B14:C14)","v":0},null,{"$f":"C.I.A.!G17+C.I.A.!H17","v":0},{"$f":"F14-D14","v":0}]
["OAA IIID2",{"$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.!G18+C.I.A.!H18","v":0},0]
["OAA IIIE",{"$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.!I18","v":0},0]
["OAA VII",{"$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.!J18","v":0},0]
["OAA ADMINISTRATION",{"$f":"C.I.A.!B18","v":0},{"$f":"C.I.A.!D29","v":0},0,null,{"$f":"C.I.A.!B18+C.I.A.!D29","v":0},0]
["OAA  TOTAL",{"$f":"SUM(B10:B18)","v":0},{"$f":"SUM(C10:C18)","v":0},{"$f":"SUM(D10:D18)","v":0}]
["ADA WAIVER",{"$f":"'C.I.F.(1)'!B21+'C.I.F.(2)'!B21+'C.I.F.(3)'!B21+'C.I.F.(4)'!B21+'C.I.F.(5)'!B21+'C.I.F.(6)'!B21+'C.I.F.(7)'!B21+'C.I.F.(8)'!B21+'C.I.F.(9)'!B21+'C.I.F.(10)'!B21+'C.I.F.(11)'!B21+'C.I.F.(12)'!B21+'C.I.F.(13)'!B21+'C.I.F.(14)'!B21+'C.I.F.(15)'!B21+'C.I.F.(16)'!B21","v":0},{"$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.!K32","v":0},{"$f":"F20-D20","v":0}]
["ALE WAIVER",{"$f":"'C.I.F.(1)'!B22+'C.I.F.(2)'!B22+'C.I.F.(3)'!B22+'C.I.F.(4)'!B22+'C.I.F.(5)'!B22+'C.I.F.(6)'!B22+'C.I.F.(7)'!B22+'C.I.F.(8)'!B22+'C.I.F.(9)'!B22+'C.I.F.(10)'!B22+'C.I.F.(11)'!B22+'C.I.F.(12)'!B22+'C.I.F.(13)'!B22+'C.I.F.(14)'!B22+'C.I.F.(15)'!B22+'C.I.F.(16)'!B22","v":0},{"$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.!K33","v":0},{"$f":"F21-D21","v":0}]
["MED. WAIVER SPECIALIST",{"$f":"C.I.A.!K34*B47","v":0},{"$f":"C.I.A.!K34*B48","v":0},0,null,{"$f":"C.I.A.!K34","v":0},0]
["EHEAP",{"$f":"'C.I.F.(1)'!B23+'C.I.F.(2)'!B23+'C.I.F.(3)'!B23+'C.I.F.(4)'!B23+'C.I.F.(5)'!B23+'C.I.F.(6)'!B23+'C.I.F.(7)'!B23+'C.I.F.(8)'!B23+'C.I.F.(9)'!B23+'C.I.F.(10)'!B23+'C.I.F.(11)'!B23+'C.I.F.(12)'!B23+'C.I.F.(13)'!B23+'C.I.F.(14)'!B23+'C.I.F.(15)'!B23+'C.I.F.(16)'!B23","v":0},null,0,null,{"$f":"C.I.A.!K30","v":0},0]
["EHEAP ADMINISTRATION",{"$f":"C.I.A.!K31","v":0},null,0,null,{"$f":"C.I.A.!K31","v":0},0]
["NSIP",{"$f":"'C.I.F.(1)'!B25+'C.I.F.(2)'!B24+'C.I.F.(3)'!B24+'C.I.F.(4)'!B24+'C.I.F.(5)'!B24+'C.I.F.(6)'!B24+'C.I.F.(7)'!B24+'C.I.F.(8)'!B24+'C.I.F.(9)'!B24+'C.I.F.(10)'!B24+'C.I.F.(11)'!B24+'C.I.F.(12)'!B24+'C.I.F.(13)'!B24+'C.I.F.(14)'!B24+'C.I.F.(15)'!B24+'C.I.F.(16)'!B24","v":0},null,{"$f":"SUM(B25:C25)","v":0},null,{"$f":"C.I.A.!K29","v":0},0]
["CCE "," ",{"$f":"'C.I.F.(1)'!C26+'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.!D31","v":0},0]
["CCE ADMINISTRATION",null,{"$f":"C.I.A.!D30","v":0},0,null,{"$f":"C.I.A.!D30","v":0},0]
["ADI ",null,{"$f":"'C.I.F.(1)'!C27+'C.I.F.(2)'!C26+'C.I.F.(3)'!C26+'C.I.F.(4)'!C26+'C.I.F.(5)'!C26+'C.I.F.(6)'!C26+'C.I.F.(7)'!C26+'C.I.F.(8)'!C26+'C.I.F.(9)'!C26+'C.I.F.(10)'!C26+'C.I.F.(11)'!C26+'C.I.F.(12)'!C26+'C.I.F.(13)'!C26+'C.I.F.(14)'!C26+'C.I.F.(15)'!C26+'C.I.F.(16)'!C26","v":0},0,null,{"$f":"C.I.A.!D36","v":0},0]
["ADI ADMINISTRATION",null,{"$f":"C.I.A.!D35","v":0},0,null,{"$f":"C.I.A.!D35","v":0},0]
["HCE",null,{"$f":"'C.I.F.(1)'!C28+'C.I.F.(2)'!C27+'C.I.F.(3)'!C27+'C.I.F.(4)'!C27+'C.I.F.(5)'!C27+'C.I.F.(6)'!C27+'C.I.F.(7)'!C27+'C.I.F.(8)'!C27+'C.I.F.(9)'!C27+'C.I.F.(10)'!C27+'C.I.F.(11)'!C27+'C.I.F.(12)'!C27+'C.I.F.(13)'!C27+'C.I.F.(14)'!C27+'C.I.F.(15)'!C27+'C.I.F.(16)'!C27","v":0},0,null,{"$f":"C.I.A.!D33+C.I.A.!D34","v":0},0]
["HCE ADMINISTRATION",null,{"$f":"C.I.A.!D32","v":0},0,null,{"$f":"C.I.A.!D32","v":0},0]
["LSP",null,{"$f":"'C.I.F.(1)'!C29+'C.I.F.(2)'!C28+'C.I.F.(3)'!C28+'C.I.F.(4)'!C28+'C.I.F.(5)'!C28+'C.I.F.(6)'!C28+'C.I.F.(7)'!C28+'C.I.F.(8)'!C28+'C.I.F.(9)'!C28+'C.I.F.(10)'!C28+'C.I.F.(11)'!C28+'C.I.F.(12)'!C28+'C.I.F.(13)'!C28+'C.I.F.(14)'!C28+'C.I.F.(15)'!C28+'C.I.F.(16)'!C28","v":0},0,null,{"$f":"C.I.A.!D38","v":0},0]
["LSP ADMINISTRATION",null,{"$f":"C.I.A.!D37","v":0},{"$f":"SUM(B33:C33)","v":0},null,{"$f":"C.I.A.!D37","v":0},0]
["SHINE",{"$f":"C.I.A.!K35","v":0},null,{"$f":"SUM(B34:B34)","v":0},null,{"$f":"C.I.A.!K35","v":0},0]
["RELIEF",null,{"$f":"'C.I.F.(1)'!C30+'C.I.F.(2)'!C30+'C.I.F.(3)'!C30+'C.I.F.(4)'!C30+'C.I.F.(5)'!C30+'C.I.F.(6)'!C30+'C.I.F.(7)'!C30+'C.I.F.(8)'!C30+'C.I.F.(9)'!C30+'C.I.F.(10)'!C30+'C.I.F.(11)'!C30+'C.I.F.(12)'!C30+'C.I.F.(13)'!C30+'C.I.F.(14)'!C30+'C.I.F.(15)'!C30+'C.I.F.(16)'!C30","v":0},0,null,{"$f":"C.I.A.!K36","v":0},0]
["ARC/ADRC",null,{"$f":"C.I.F.AAA!C39","v":0},0,null,{"$f":"C.I.A.!K37","v":0},{"$f":"F36-D36","v":0}]
["OTHERS (LIST):"]
[{"$f":"C.I.A.!H39","v":0},{"$f":"'C.I.F.(1)'!B32+'C.I.F.(2)'!B31+'C.I.F.(3)'!B31+'C.I.F.(4)'!B31+'C.I.F.(5)'!B31+'C.I.F.(6)'!B31+'C.I.F.(7)'!B31+'C.I.F.(8)'!B31+'C.I.F.(9)'!B31+'C.I.F.(10)'!B31+'C.I.F.(11)'!B31+'C.I.F.(12)'!B31+'C.I.F.(13)'!B31+'C.I.F.(14)'!B31+'C.I.F.(15)'!B31+'C.I.F.(16)'!B31","v":0},{"$f":"'C.I.F.(1)'!C32+'C.I.F.(2)'!C31+'C.I.F.(3)'!C31+'C.I.F.(4)'!C31+'C.I.F.(5)'!C31+'C.I.F.(6)'!C31+'C.I.F.(7)'!C31+'C.I.F.(8)'!C31+'C.I.F.(9)'!C31+'C.I.F.(10)'!C31+'C.I.F.(11)'!C31+'C.I.F.(12)'!C31+'C.I.F.(13)'!C31+'C.I.F.(14)'!C31+'C.I.F.(15)'!C31+'C.I.F.(16)'!C31","v":0},{"$f":"SUM(B38:C38)","v":0},null,{"$f":"C.I.A.!K39","v":0},{"$f":"F38-D38","v":0}]
[{"$f":"C.I.A.!H40","v":0},{"$f":"'C.I.F.(1)'!B33+'C.I.F.(2)'!B32+'C.I.F.(3)'!B32+'C.I.F.(4)'!B32+'C.I.F.(5)'!B32+'C.I.F.(6)'!B32+'C.I.F.(7)'!B32+'C.I.F.(8)'!B32+'C.I.F.(9)'!B32+'C.I.F.(10)'!B32+'C.I.F.(11)'!B32+'C.I.F.(12)'!B32+'C.I.F.(13)'!B32+'C.I.F.(14)'!B32+'C.I.F.(15)'!B32+'C.I.F.(16)'!B32","v":0},{"$f":"'C.I.F.(1)'!C33+'C.I.F.(2)'!C32+'C.I.F.(3)'!C32+'C.I.F.(4)'!C32+'C.I.F.(5)'!C32+'C.I.F.(6)'!C32+'C.I.F.(7)'!C32+'C.I.F.(8)'!C32+'C.I.F.(9)'!C32+'C.I.F.(10)'!C32+'C.I.F.(11)'!C32+'C.I.F.(12)'!C32+'C.I.F.(13)'!C32+'C.I.F.(14)'!C32+'C.I.F.(15)'!C32+'C.I.F.(16)'!C32","v":0},0,null,{"$f":"C.I.A.!K40","v":0},0]
[{"$f":"C.I.A.!H41","v":0},{"$f":"'C.I.F.(1)'!B34+'C.I.F.(2)'!B33+'C.I.F.(3)'!B33+'C.I.F.(4)'!B33+'C.I.F.(5)'!B33+'C.I.F.(6)'!B33+'C.I.F.(7)'!B33+'C.I.F.(8)'!B33+'C.I.F.(9)'!B33+'C.I.F.(10)'!B33+'C.I.F.(11)'!B33+'C.I.F.(12)'!B33+'C.I.F.(13)'!B33+'C.I.F.(14)'!B33+'C.I.F.(15)'!B33+'C.I.F.(16)'!B33","v":0},{"$f":"'C.I.F.(1)'!C34+'C.I.F.(2)'!C33+'C.I.F.(3)'!C33+'C.I.F.(4)'!C33+'C.I.F.(5)'!C33+'C.I.F.(6)'!C33+'C.I.F.(7)'!C33+'C.I.F.(8)'!C33+'C.I.F.(9)'!C33+'C.I.F.(10)'!C33+'C.I.F.(11)'!C33+'C.I.F.(12)'!C33+'C.I.F.(13)'!C33+'C.I.F.(14)'!C33+'C.I.F.(15)'!C33+'C.I.F.(16)'!C33","v":0},0,null,{"$f":"C.I.A.!K41","v":0},0]
[{"$f":"C.I.A.!H42","v":0},{"$f":"'C.I.F.(1)'!B35+'C.I.F.(2)'!B34+'C.I.F.(3)'!B34+'C.I.F.(4)'!B34+'C.I.F.(5)'!B34+'C.I.F.(6)'!B34+'C.I.F.(7)'!B34+'C.I.F.(8)'!B34+'C.I.F.(9)'!B34+'C.I.F.(10)'!B34+'C.I.F.(11)'!B34+'C.I.F.(12)'!B34+'C.I.F.(13)'!B34+'C.I.F.(14)'!B34+'C.I.F.(15)'!B34+'C.I.F.(16)'!B34","v":0},{"$f":"'C.I.F.(1)'!C35+'C.I.F.(2)'!C34+'C.I.F.(3)'!C34+'C.I.F.(4)'!C34+'C.I.F.(5)'!C34+'C.I.F.(6)'!C34+'C.I.F.(7)'!C34+'C.I.F.(8)'!C34+'C.I.F.(9)'!C34+'C.I.F.(10)'!C34+'C.I.F.(11)'!C34+'C.I.F.(12)'!C34+'C.I.F.(13)'!C34+'C.I.F.(14)'!C34+'C.I.F.(15)'!C34+'C.I.F.(16)'!C34","v":0},0,null,{"$f":"C.I.A.!K42","v":0},0]
[{"$f":"C.I.A.!H43","v":0},{"$f":"'C.I.F.(1)'!B36+'C.I.F.(2)'!B35+'C.I.F.(3)'!B35+'C.I.F.(4)'!B35+'C.I.F.(5)'!B35+'C.I.F.(6)'!B35+'C.I.F.(7)'!B35+'C.I.F.(8)'!B35+'C.I.F.(9)'!B35+'C.I.F.(10)'!B35+'C.I.F.(11)'!B35+'C.I.F.(12)'!B35+'C.I.F.(13)'!B35+'C.I.F.(14)'!B35+'C.I.F.(15)'!B35+'C.I.F.(16)'!B35","v":0},{"$f":"'C.I.F.(1)'!C36+'C.I.F.(2)'!C35+'C.I.F.(3)'!C35+'C.I.F.(4)'!C35+'C.I.F.(5)'!C35+'C.I.F.(6)'!C35+'C.I.F.(7)'!C35+'C.I.F.(8)'!C35+'C.I.F.(9)'!C35+'C.I.F.(10)'!C35+'C.I.F.(11)'!C35+'C.I.F.(12)'!C35+'C.I.F.(13)'!C35+'C.I.F.(14)'!C35+'C.I.F.(15)'!C35+'C.I.F.(16)'!C35","v":0},0,null,{"$f":"C.I.A.!K43","v":0},0]
[{"$f":"C.I.A.!H44","v":0},{"$f":"'C.I.F.(1)'!B37+'C.I.F.(2)'!B36+'C.I.F.(3)'!B36+'C.I.F.(4)'!B36+'C.I.F.(5)'!B36+'C.I.F.(6)'!B36+'C.I.F.(7)'!B36+'C.I.F.(8)'!B36+'C.I.F.(9)'!B36+'C.I.F.(10)'!B36+'C.I.F.(11)'!B36+'C.I.F.(12)'!B36+'C.I.F.(13)'!B36+'C.I.F.(14)'!B36+'C.I.F.(15)'!B36+'C.I.F.(16)'!B36","v":0},{"$f":"'C.I.F.(1)'!C37+'C.I.F.(2)'!C36+'C.I.F.(3)'!C36+'C.I.F.(4)'!C36+'C.I.F.(5)'!C36+'C.I.F.(6)'!C36+'C.I.F.(7)'!C36+'C.I.F.(8)'!C36+'C.I.F.(9)'!C36+'C.I.F.(10)'!C36+'C.I.F.(11)'!C36+'C.I.F.(12)'!C36+'C.I.F.(13)'!C36+'C.I.F.(14)'!C36+'C.I.F.(15)'!C36+'C.I.F.(16)'!C36","v":0},0,null,{"$f":"C.I.A.!K44","v":0},0]
["TOTAL ALL FUNDING SOURCES",{"$f":"SUM(B19:B43)","v":0},{"$f":"SUM(C19:C43)","v":0},{"$f":"SUM(D19:D43)","v":0}]
[]
["Federal/State Share:"]
["Federal:  ",0.55400000000000005,"Federal:  66.54%"]
["State:  ",0.44600000000000001,"State:  33.46%"]

{"sheet":"C.II.A.","index":27,"n_rows":184,"n_cols":23,"rows_kept":184,"cut":false,"hidden":false,"merged":[[117,0,117,1],[176,0,176,18],[150,0,150,18],[183,0,183,18],[177,0,177,18],[180,0,180,18],[181,0,181,18],[182,0,182,18],[178,0,178,18],[138,0,138,1],[125,0,125,1],[126,0,126,1],[128,0,128,1],[129,0,129,1],[137,0,137,1],[5,0,5,9],[21,0,23,0],[51,0,51,19],[174,0,174,18],[175,0,175,18],[82,0,82,1],[83,0,83,1],[7,0,7,1],[95,0,95,1],[96,0,96,1],[98,0,98,1],[147,0,147,1],[93,0,93,1],[108,0,108,1],[115,0,115,1],[116,0,116,1]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["C.II.A. AREA AGENCY ON AGING ADMINISTRATIVE BUDGET SUMMARY AND ALLOCATIONS"]
["NAME OF AGENCY:"]
["BUDGET YEAR - 2011"]
["Instructions:  Update all aqua-colored cells as appropriate.  Purple cells are calculated automatically. Use the categories provided, adding rows as needed.  In accord 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.) ARRA nutrition funding discontinues September 30, so ARRA was removed from the worksheet.  If the AAA has ARRA funding for another program, it should be added on the form along with other funding sources. 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":"+D131","v":0}]
["OTHER",null,{"$f":"+D149","v":0}]
["REVENUE",null,{"$f":"+D166","v":0}]
[]
[]
["1. PERSONNEL SALARIES"]
["TITLE and NAME","GROSS","TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,"AVAILABLE","BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,"HOURS","CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:U25)","v":0},{"$f":"SUM(D25-C25)","v":0}]
[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}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E28:U28)","v":0},{"$f":"SUM(D28-C28)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["OVERTIME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["BONUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["ACCRUED LEAVE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["MEALS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,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,{"$f":"SUM(L25:L49)","v":0},0,0,0,{"$f":"SUM(P25:P49)","v":0},{"$f":"SUM(Q25:Q49)","v":0},{"$f":"SUM(R25:R49)","v":0},{"$f":"SUM(S25:S49)","v":0},0,0,{"$f":"SUM(V25:V49)","v":0},{"$f":"SUM(W25:W49)","v":0}]
["TOTAL GROSS AVAIL HRS",{"$f":"SUM(B25:B49)","v":0}]
["Note 1:  Enter on the last page of this Administrative 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 Administrative 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","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["VOLUNTEER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E60:U60)","v":0},{"$f":"SUM(D60-C60)","v":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,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(E61:U61)","v":0},{"$f":"SUM(W60:W60)","v":0}]
["TOTAL SALARIES",null,{"$f":"SUM(C50,C61)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(V50,V61)","v":0},0]
[]
[]
["3. FRINGE BENEFITS"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
[" RETIREMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E69:U69)","v":0},{"$f":"SUM(D69-C69)","v":0}]
[" SOCIAL SECURITY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E70:U70)","v":0},{"$f":"SUM(D70-C70)","v":0}]
[" FL UNEMP. COMP.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E71:U71)","v":0},{"$f":"SUM(D71-C71)","v":0}]
["EMPLOYEE INSURANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E72:U72)","v":0},{"$f":"SUM(D72-C72)","v":0}]
[" WORKERS COMPENSATION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E73:U73)","v":0},{"$f":"SUM(D73-C73)","v":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,{"$f":"SUM(V69:V73)","v":0},{"$f":"SUM(W69:W73)","v":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]
[]
[]
["4. TRAVEL"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["TRAVEL (In-Area)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E82:U82)","v":0},{"$f":"D82-C82","v":0}]
["TRAVEL (In-State/Conferences    - please identify)*"]
["TRAVEL (Out-of State/Conferences - please identify"]
["BOARD & VOLUNTEER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E85:U85)","v":0},{"$f":"D85-C85","v":0}]
[" IN-KIND TRAVEL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E86:U86)","v":0},{"$f":"D86-C86","v":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,{"$f":"SUM(O82:O86)","v":0},0,0,0,0,0,0,0,0]
["* Note 3:  For each  in and out of state conference,  on the last page of this Administrative Budget add 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,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["DEPRECIATION - BUILDING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E94:U94)","v":0},{"$f":"D94-C94","v":0}]
["INSURANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E95:U95)","v":0},{"$f":"D95-C95","v":0}]
["REPAIR AND MAINTENANCE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E96:U96)","v":0},{"$f":"D96-C96","v":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,{"$f":"SUM(E97:U97)","v":0},{"$f":"D97-C97","v":0}]
["    IN-KIND ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E98:U98)","v":0},{"$f":"D98-C98","v":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]
[]
[]
["6. COMMUNICATIONS & UTILITIES"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["TELEPHONE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E106:U106)","v":0},{"$f":"D106-C106","v":0}]
["POSTAGE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E107:U107)","v":0},{"$f":"D107-C107","v":0}]
["UTILITIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E108:U108)","v":0},{"$f":"D108-C108","v":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,{"$f":"SUM(W106:W108)","v":0}]
[]
[]
["7.  PRINTING & SUPPLIES"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["GENERAL OFFICE SUPPLIES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E116:U116)","v":0},{"$f":"D116-C116","v":0}]
["PRINTING AND REPRODUCTION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E117:U117)","v":0},{"$f":"D117-C117","v":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,{"$f":"SUM(O116:O117)","v":0},0,0,0,0,0,0,0,0]
["Note 4:  Enter on the last page of this Administrative Budget a narrative explanation of planned expenditures in the communications category."]
[]
[]
["8.  EQUIPMENT"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["DEPRECIATION - EQUIPMENT",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E126:U126)","v":0},{"$f":"D126-C126","v":0}]
["SMALL OFFICE FURN/EQUIPT.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E127:U127)","v":0},{"$f":"D127-C127","v":0}]
["OFFICE FURN/EQUIPT.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E128:U128)","v":0},{"$f":"D128-C128","v":0}]
["COMPUTER HARDWARE/SOFTWARE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E129:U129)","v":0},{"$f":"D129-C129","v":0}]
["PROGRAM EQUIPMENT (Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E130:U130)","v":0},{"$f":"D130-C130","v":0}]
["TOTAL EQUIPMENT",null,{"$f":"SUM(C126:C130)","v":0},{"$f":"SUM(D126:D130)","v":0},0,0,0,0,0,0,{"$f":"SUM(K126:K130)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["9. OTHER COSTS (UNIQUE TO AAA)"]
[null,null,"TOTAL","TOTAL","TITLE","TITLE","TITLE","TITLE","TITLE","OAA","CCE","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","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,{"$f":"SUM(E138:U138)","v":0},{"$f":"SUM(D138-C138)","v":0}]
["PROGRAM ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["FOOD SUPPLIES"]
["ADVERTISING",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["MISCELLANEOUS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(D143-C143)","v":0}]
["PUBLICATIONS  (Total)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["SUB-CONTRACTOR(S)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"SUM(D146-C146)","v":0}]
["RELOCATION EXPENSES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["PARTICIPANT SUPPORT COSTS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["TOTAL OTHER COSTS",null,{"$f":"SUM(C138:C148)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["TOTAL ALL COSTS",null,{"$f":"SUM(C149,C131,C118,C109,C99,C87,C75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Note 5:  Enter on the last page of this Administrative Budget a narrative explanation for planned purchases/expenditures in the equipment & 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","EHEAP","HCE","MEDICAID","SHINE","ARC/","ADI","LSP","OTHER \nPROJECTS","OTHER \nPROJECTS","OTHER","TOTAL","TOTAL"]
[null,null,"BUDGET","BUDGET","III-B","III-B","III-D","VII","III-E","AAA","ADMIN","ADMIN","ADMIN","WAIVER","ADMIN","ADRC","ADMIN","ADMIN","DOEA","DOEA","PROJECTS","ALLOCATED","BUDGET"]
[null,null,"CURRENT","PROPOSED","SET ASIDE","I&R",null,null,null,"ADMIN",null,null,null,"SPECIALISTS\nADMIN",null,"ADMIN",null,null,"(IDENTIFY)","(IDENTIFY)","NON-DOEA","FUNDS","CHANGE"]
["FEDERAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E158:U158)","v":0},{"$f":"D158-C158","v":0}]
["STATE GENERAL REVENUE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E159:U159)","v":0},{"$f":"D159-C159","v":0}]
["PROGRAM INCOME",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["OTHER FUNDS ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["LOCAL CASH",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     (MATCH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["IN-KIND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0]
["     (MATCH)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E165:U165)","v":0},0]
["TOTAL REVENUES",null,{"$f":"SUM(C158:C165)","v":0},{"$f":"SUM(D158:D165)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(N158:N165)","v":0},{"$f":"SUM(O158:O165)","v":0},0,0,0,0,0,0,{"$f":"SUM(V158:V165)","v":0},{"$f":"SUM(W158:W165)","v":0}]
[]
[]
["TOTAL REVENUES",null,{"$f":"+C166","v":0},{"$f":"+D166","v":0},0,0,0,0,0,0,{"$f":"+K166","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"+W166","v":0}]
["TOTAL EXPENSES",null,{"$f":"+C150","v":0},{"$f":"+D150","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"+V150","v":0},{"$f":"+W150","v":0}]
["TOTAL REVENUE - EXPENSES",null,{"$f":"C169-C170","v":0},{"$f":"D169-D170","v":0},0,0,0,0,0,0,0,{"$f":"L169-L170","v":0},0,0,0,0,0,0,0,0,0,0,0]
["PERCENT REVENUE",null,{"$f":"C169/$C$169","v":{"$error":"#DIV/0!"}},{"$f":"D169/$C$169","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!"},{"$f":"U169/$C$169","v":{"$error":"#DIV/0!"}},{"$f":"V169/$C$169","v":{"$error":"#DIV/0!"}},{"$f":"W169/$C$169","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 none are paid."]
["Enter text here:"]
["Note 3:  Please provide the following detail about each in and out of state conference attended:  Name of conference, number who attended, and amount budgeted."]
[]
["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 & 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:"]

{"sheet":"C.II.B.","index":28,"n_rows":54,"n_cols":10,"rows_kept":54,"cut":false,"hidden":false,"merged":[[2,0,2,9],[4,0,4,9]]}
["PSA:                    Original Submission Date:                                     Resubmission Date:"]
[]
["C.II.B. OAA Budget Summary  "]
[]
["Instructions: Update all aqua-colored cells as appropriate. Purple cells are calculated based on values entered in tab C.I.A.  "]
[]
[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.!D29","v":0},null,null,null,{"$f":"SUM(D11:H11)","v":0}]
["  B.","Prior Year CF* (2010)",null,{"$f":"C.I.A.!B17","v":0},null,null,null,null,null,{"$f":"SUM(D12:H12)","v":0}]
["  CONTRACT TOTAL",null,null,{"$f":"SUM(D11:D12)","v":0},null,{"$f":"SUM(F11:F12)","v":0},null,{"$f":"SUM(H11:H12)","v":0},null,0]
["   C.","CCE GR Administration",null,null,null,null,null,{"$f":"C.I.A.!D30","v":0},null,0]
["   D.","HCE GR Administration",null,null,null,null,null,{"$f":"C.I.A.!D32","v":0},null,0]
["   E.","LSP Admin",null,null,null,null,null,{"$f":"C.I.A.!D37","v":0},null,0]
["   F.","LSP Services",null,null,null,null,null,null,null,0]
["   G.","Local Match",null,null,null,null,null,null,null,0]
["   TOTAL ADMIN",null,null,{"$f":"SUM(D13:D18)","v":0},null,{"$f":"SUM(F13:F18)","v":0},null,{"$f":"SUM(H13:H18)","v":0},null,{"$f":"SUM(D19:H19)","v":0}]
["2.  Title III-B"]
["   A.","Supportive Services"]
["     (1)","Current Year",null,{"$f":"C.I.A.!C16","v":0},null,null,null,null,null,{"$f":"SUM(D22:H22)","v":0}]
[-2,"Prior Year CF* (2010)",null,{"$f":"C.I.A.!C17","v":0},null,null,null,null,null,{"$f":"SUM(D23:H23)","v":0}]
["     TOTAL",null,null,{"$f":"SUM(D22:D23)","v":0},null,null,null,{"$f":"SUM(H22:H23)","v":0},null,{"$f":"SUM(D24:H24)","v":0}]
["   B.","IIIB Set-Aside (also included in Total)",null,{"$f":"C.I.A.!C20","v":0},null,null,null,null,null,{"$f":"SUM(D25:H25)","v":0}]
["3.  Title III-C1 Nutrition Services"]
["   A.","Current Year",null,{"$f":"C.I.A.!D16","v":0},null,null,null,null,null,{"$f":"SUM(D27:H27)","v":0}]
["   B.","Prior Year CF* (2010)",null,{"$f":"C.I.A.!D17","v":0},null,null,null,null,null,{"$f":"SUM(D28:H28)","v":0}]
["     TOTAL",null,null,{"$f":"SUM(D27:D28)","v":0},null,null,null,{"$f":"SUM(H27:H28)","v":0},null,{"$f":"SUM(D29:H29)","v":0}]
["4.  Title III-C2 Nutrition Services"]
["   A.","Current Year",null,{"$f":"C.I.A.!E16","v":0},null,null,null,null,null,{"$f":"SUM(D31:H31)","v":0}]
["   B.","Prior Year CF* (2010)",null,{"$f":"C.I.A.!E17","v":0},null,null,null,null,null,{"$f":"SUM(D32:H32)","v":0}]
["     TOTAL",null,null,{"$f":"SUM(D31:D32)","v":0},null,null,null,{"$f":"SUM(H31:H32)","v":0},null,{"$f":"SUM(D33:H33)","v":0}]
["5.  Title III-D1 Preventive Health"]
["  A.","Current Year",null,{"$f":"C.I.A.!G16","v":0},null,null,null,null,null,{"$f":"SUM(D35:H35)","v":0}]
["  B.","Prior Year CF* (2010)",null,{"$f":"C.I.A.!G17","v":0},null,null,null,null,null,{"$f":"SUM(D36:H36)","v":0}]
["   TOTAL",null,null,{"$f":"SUM(D35:D36)","v":0},null,null,null,{"$f":"SUM(H35:H36)","v":0},null,{"$f":"SUM(D37:H37)","v":0}]
["6.  Title III-D2  Preventive Health"]
["  A.","Current Year",null,{"$f":"C.I.A.!H16","v":0},null,null,null,null,null,{"$f":"SUM(D39:H39)","v":0}]
["  B.","Prior Year CF* (2010)",null,{"$f":"C.I.A.!H17","v":0},null,null,null,null,null,{"$f":"SUM(D40:H40)","v":0}]
["   TOTAL",null,null,{"$f":"SUM(D39:D40)","v":0},null,null,null,{"$f":"SUM(H39:H40)","v":0},null,{"$f":"SUM(D41:H41)","v":0}]
["7.  Title III-E Caregiver Support Services"]
["   A.","Current Year",null,{"$f":"C.I.A.!I16","v":0},null,null,null,null,null,{"$f":"SUM(D43:H43)","v":0}]
["   B.","Prior Year CF* (2010)",null,{"$f":"C.I.A.!I17","v":0},null,null,null,null,null,{"$f":"SUM(D44:H44)","v":0}]
["   TOTAL",null,null,{"$f":"SUM(D43:D44)","v":0},null,null,null,{"$f":"SUM(H43:H44)","v":0},null,{"$f":"SUM(D45:H45)","v":0}]
["8.  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,D22,D27,D31,D35,D39,D43)","v":0}]
["9. Total CF Funds Awarded"]
["(Sum of 1.B, 2.A(2), 3.B, 4.B, 5.B, 6.B, 7.B)",null,null,{"$f":"D12+D23+D28+D32+D36+D40+D44","v":0}]
["10.  Total GR Awarded"]
["(Total of column (2))",null,null,{"$f":"F19","v":0}]
["11.Total of All Funds to be Received"]
["(Sum of  8, 9, 10)",null,null,{"$f":"D47+D49+D51","v":0}]
["* Carry Forward"]