{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":[" Expenditures Report","Core Medical Calculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":2,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":" Expenditures Report","index":0,"n_rows":80,"n_cols":14,"rows_kept":80,"cut":false,"hidden":false,"merged":[[3,3,3,5],[4,3,4,5],[5,3,5,5],[0,0,0,13],[2,0,5,1],[6,0,6,1],[2,3,2,5],[6,3,6,5],[13,12,13,13],[9,3,9,5],[13,10,13,11],[7,3,7,5],[11,3,11,5],[13,1,13,3],[7,0,7,1],[12,0,12,13],[10,0,10,1],[10,3,10,5],[74,0,74,13],[66,5,66,6],[66,1,66,2],[66,3,66,4],[11,0,11,1],[30,0,31,0],[30,1,30,2],[30,3,30,4],[30,11,63,13],[75,0,77,10],[13,0,14,0],[65,1,65,6],[30,5,30,6],[13,4,13,6],[30,7,30,8],[13,7,13,9],[30,9,30,10],[65,7,73,13]],"flags":["formulas_cached_only"]}
["FY14 Part B & MAI Expenditures Report"]
[]
["Detailed instructions for completing and submitting your report \ncan be downloaded from the HRSA Electronic Handbook: https://grants.hrsa.gov/webexternal/Login.asp",null,null,"Section B:  Reporting Year Award Information",null,null,"Award Amount","Prior Year Carryover","Total Avail. Funds"]
[null,null,null,"1. Part B Base Award",{"$nulls":4},0]
[null,null,null,"2. Part B ADAP Earmark Award",{"$nulls":4},0]
[null,null,null,"3. Part B ADAP Supplemental Award",{"$nulls":4},0]
["Section A: Identifying Information",null,null,"4. Total Part B Base + ADAP + ADAP Supplemental Funds",null,null,0,0,0]
["~ Enter Name of Grantee Here ~",null,null,"5. Part B Emerging Communities Award",{"$nulls":4},0]
["~ Enter Preparer's Name Here ~",null,null,"6. Part B Supplemental Award",{"$nulls":4},0]
["~ Enter Preparer's Phone Number Here ~",null,null,"7. Total Part B Funds",null,null,0,0,0]
["~ Enter Preparer's Email Address Here ~",null,null,"8. Part B MAI Award",{"$nulls":4},0]
[null,null,null,"9. Total Part B + MAI Funds",null,null,0,0,0]
[]
["Section C: Part B Expenditures by Program Component","1. Base Award",null,null," 2. ADAP Earmark + ADAP Supplemental ",null,null,"3. Emerging Communities Award",null,null,"4. Total Prior Year Carryover",null,"5. Total (including carryover)"]
[null,"Award","Carryover","Percent*","Award","Carryover","Percent*","Award","Carryover","Percent*","Amount","Percent","Amount","Percent"]
["1. Part B AIDS Drug Assistance Program Subtotal",0,0,"- -",0,0,"- -",0,null,"- -",0,"- -",0,"- -"]
["a. ADAP Services",null,null,"- -",null,null,"- -",null,null,"- -",0,"- -",0,"- -"]
["b. Health Insurance to Provide Medications",null,null,"- -",null,null,"- -",null,null,"- -",0,"- -",0,"- -"]
["c. ADAP Access/Adherence/Monitoring Services",null,null,"- -",null,null,"- -",null,null,"- -",0,"- -",0,"- -"]
["2. Part B Health Insurance Premium & Cost Sharing Assistance ",null,null,"- -",{"$nulls":5},"- -",0,"- -",0,"- -"]
["3. Part B Home and Community-based Health Services",null,null,"- -",{"$nulls":5},"- -",0,"- -",0,"- -"]
["4. Part B HIV Care Consortia (Provide service detail in Sec. D, Column 1 & 4) 1 ",0,0,"- -",{"$nulls":5},"- -",0,"- -",0,"- -"]
["4a. Part B HIV Care Consortia Administration, Planning & Evaluation2",null,null,"- -",{"$nulls":5},"- -",0,"- -",0,"- -"]
["5. Part B State Direct Services (Provide detail in Sec. D, Column 2 & 4)1",0,0,"- -",{"$nulls":5},"- -",0,"- -",0,"- -"]
["6. Part B Clinical Quality Management3 ",null,null,"- -",null,null,"- -",null,null,"- -",0,"- -",0,"- -"]
["7. Part B Grantee Planning & Evaluation Activities4",null,null,"- -",null,null,"- -",null,null,"- -",0,"- -",0,"- -"]
["8. Grantee Administration 4",null,null,"- -",null,null,"- -",null,null,"- -",0,"- -",0,"- -"]
["9. Column Totals ",0,0,"- -",0,0,"- -",0,0,"- -",0,"- -",0,"- -"]
["10.Total Part B Expenditures (excluding carryover)",0]
[]
["Section D: Breakdown for Consortia, State Direct  Services and Emerging Communities","1. Consortia5",null,"2. Direct Services",null,"3. Emerging Communities 6",null,"4. Prior Year Carryover",null,"5. Total (including carryover)"]
[null,"Award","Percent","Award","Percent","Award","Percent","Amount","Percent","Amount","Percent"]
["1. Core Medical Services Sub-total",0,"- -",0,"- -",0,"- -",0,"- -",0,"- -"]
["a. Outpatient /Ambulatory Health Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["b. AIDS Drug Assistance Program (ADAP) Treatments",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["c. AIDS Pharmaceutical Assistance (local)",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["d. Oral Health Care",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["e. Early Intervention Services ",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["f. Health Insurance Premium & Cost Sharing Assistance ",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["g. Home Health Care ",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["h. Home and Community-based Health Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["i. Hospice Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["j. Mental Health Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["k. Medical Nutrition Therapy",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["l. Medical Case Management (including Treatment Adherence)",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["m. Substance Abuse Services–outpatient",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["2. Support Services Sub-total",0,"- -",0,"- -",0,"- -",0,"- -",0,"- -"]
["a. Case Management (non-Medical) ",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["b. Child Care Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["c. Emergency Financial Assistance",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["d. Food Bank/Home-Delivered Meals",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["e. Health Education/Risk Reduction",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["f. Housing Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["g. Legal Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["h. Linguistics Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["i. Medical Transportation Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["j. Outreach Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["k. Psychosocial Support Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["l. Referral for Health Care/Supportive Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["m. Rehabilitation Services",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["n. Respite Care",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["o. Substance Abuse Residential Services ",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["p. Treatment Adherence Counseling",null,"- -",null,"- -",null,"- -",null,"- -",0,"- -"]
["3.  Total",0,"- -",0,"- -",0,"- -",0,"- -",0,"- -"]
[]
[null,"MAI AWARD",{"$nulls":5},"* Percentage is calculated on the combined total of the current Fiscal Year award plus prior year carryover amount.\n(1) In the Base Award column ONLY, this cell will automatically calculate based on the detail you provide in Section D.\n(2) Administration expenditures for first-line entities is capped at 10% of the aggregate amount allocated for services.  Therefore, Consortia Administration, Planning and Evaluation may not exceed 10% of Consortia funds.\n(3) May not exceed 5% of the Part B award, or 3 million, whichever amount is smaller.\n(4) May not exceed 10% of the Part B award for either Planning & Evaluation or Grantee Admin.  Additionally, the combined costs for these two categories may not exceed 15% of the Part B award.\n(5) All services in this column are considered Supprt Services.\n(6) In the Emerging Communities Column ONLY, the Total Allocations should equal the combined total of Rows 4 + 5 in Section C, Column 3."]
[null,"REPORTING YEAR AWARD",null,"PRIOR FY CARRYOVER",null,"TOTAL"]
["Section E: MAI Expenditures by Program Component","Amount","Percent","Amount","Percent","Amount","Percent"]
["1.  Education to increase minority participation in ADAP",null,"- -",null,"- -",0,"- -"]
["2.  Outreach to increase minority participation in ADAP",null,"- -",null,"- -",0,"- -"]
["3.  Clinical Quality Management 3",null,"- -",null,"- -",0,"- -"]
["4.  Grantee Planning & Evaluation Activities 4",null,"- -",null,"- -",0,"- -"]
["5.  Grantee Administration 4",null,"- -",null,"- -",0,"- -"]
["6. Total MAI Expenditures",0,0,0,0,0,0]
[]
["PUBLIC BURDEN STATEMENT: An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB number. The OMB control number for this project is 0915-0318. Public reporting burden for this collection of information is estimated to be 12 hours per response. These estimates include the time for reviewing instructions, searching existing data sources, gathering and maintaining the data needed, and completing and reviewing the collection of information. Send comments to HRSA Reports Clearance Officer, Health Resources and Services Administration, Room 10-33, 5600 Fishers Lane, Rockville, MD. 20857."]
[]
[]
["FOR OFFICE USE ONLY:"]
["o Grantee received waiver for 75% core medical services requirement."]

{"sheet":"Core Medical Calculation","index":1,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,0,2],[19,0,19,2],[4,0,4,2],[47,0,49,0],[47,1,48,1],[2,0,2,2],[1,0,1,2],[3,0,3,2]],"flags":["formulas_cached_only"]}
["Part B & MAI Expenditures Report"]
["Automatic Calculation of Part B Core Medical & Support Services Expenditures"]
[]
["NOTE: This table is for reference only and is provided for grantees to automatically calculate their total Core Medical Service allocations/percentages across all Part B service dollars.  The figures below reflect the amounts entered in the Expenditures Report (green tab)."]
[]
[" Core Medical Services Expenditures","Amount","Percentage\n(Amount / Total Service Expenditures)"]
["ADAP (M16)",0,"- -"]
["Home-and Community-based Health Services (M21)",0,"- -"]
["Health Insurance Premium & Cost Sharing Assistance (M20)",0,"- -"]
["State-Direct Services: Core Medical Services (D33)",0,"- -"]
["Emerging Communities: Core Medical Services (F33)",0,"- -"]
["Total Core Medical Services Expenditures",0,"- -"]
[]
["Support Services Expenditures","Amount","Percent"]
["Consortia Services (M22) ",0,"- -"]
["State-Direct Services: Support Services (D47)",0,"- -"]
["Emerging Communities: Support Services (F47)",0,"- -"]
["MAI Allocations for Education + Outreach Services (F69 + F70)",0,"- -"]
["Total Support Services Expenditures",0,"- -"]
[]
["Total Part B Services Expenditures",0]