{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":[" Allocations 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":" Allocations Report","index":0,"n_rows":85,"n_cols":9,"rows_kept":85,"cut":false,"hidden":false,"merged":[[83,0,83,4],[84,0,85,4],[12,2,12,3],[67,3,76,8],[78,0,81,8],[6,4,6,7],[8,2,8,3],[8,4,8,7],[14,1,15,2],[7,2,7,3],[66,0,66,8],[12,0,12,1],[12,4,12,7],[9,2,9,3],[10,2,10,3],[14,7,15,8],[14,5,15,6],[32,0,33,0],[32,1,32,2],[32,5,32,6],[32,7,32,8],[0,0,0,8],[1,0,1,8],[10,4,10,7],[11,4,11,7],[11,2,11,3],[5,4,5,7],[7,0,7,1],[8,0,8,1],[7,4,7,7],[11,0,11,1],[3,4,3,7],[4,4,4,7],[2,4,2,8],[2,0,6,3],[67,1,67,2],[14,0,16,0],[14,3,15,4],[32,3,32,4],[13,0,13,8],[9,4,9,7]],"flags":["formulas_cached_only"]}
["FY14 Part B and MAI Allocations Report"]
[]
["Detailed instructions for completing and submitting this report can be \nfound in the Electronic Handbooks and download from the web:\nhttps://grants.hrsa.gov/webexternal/Login.asp",null,null,null,"Section B:  Reporting Year Award Information"]
[{"$nulls":4},"1. Part B Base Award"]
[{"$nulls":4},"2. Part B Supplemental Award"]
[{"$nulls":4},"3. Total Part B Base + Base Supplemental Awards",null,null,null,0]
[{"$nulls":4},"4. Part B ADAP Earmark Award"]
["Section A: Identifying Information",null,null,null,"5. Part B ADAP Supplemental Award"]
["~ Enter Name of Grantee Here ~",null,null,null,"6. Total Part B ADAP + ADAP Supplemental Awards",null,null,null,0]
["~ Enter Preparer's Name Here ~",null,null,null,"7. Part B Emerging Communities Award"]
["~ Enter Preparer's Phone Number Here ~",null,null,null,"8. Total Part B Funds",null,null,null,0]
["~ Enter Preparer's Email Address Here ~",null,null,null,"9. Part B MAI Award"]
[{"$nulls":4},"10. Total Part B + MAI Funds",null,null,null,0]
[]
["Section C: Part B Allocations by Program Component","1. Base Award",null," 2. ADAP + ADAP Supplemental Award",null,"3. Emerging Communities Award (EC)",null,"4. Total "]
[]
[null,"Amount","Percentage","Amount","Percentage","Amount","Percentage","Amount","Percentage"]
["1. Part B AIDS Drug Assistance Program Subtotal",0,"- -",0,"- -",0,"- -",0,"- -"]
["a. ADAP Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["b. Health Insurance to Provide Medications",null,"- -",null,"- -",null,"- -",0,"- -"]
["c. ADAP Access/Adherence/Monitoring Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["2. Part B Health Insurance Premium & Cost Sharing Assistance ",null,"- -",null,null,null,"- -",0,"- -"]
["3. Part B Home and Community-based Health Services",null,"- -",null,null,null,"- -",0,"- -"]
["4a. Part B HIV Care Consortia/EC services  (Provide detail in Section D, Column 1 or 3)1 ",0,"- -",null,null,0,"- -",0,"- -"]
["4b. Part B HIV Care Cosortia/EC Administration2   ",null,"- -",null,null,null,"- -",0,"- -"]
["5. Part B State Direct Services  (Provide detail in Section D, Column 2)1",0,"- -",null,null,null,"- -",0,"- -"]
["6. Part B Clinical Quality Management3 ",null,"- -",null,"- -",null,"- -",0,"- -"]
["7. Part B Grantee Planning & Evaluation Activities4",null,"- -",null,"- -",null,"- -",0,"- -"]
["8. Grantee Administration 4",null,"- -",null,"- -",null,"- -",0,"- -"]
["9. Column Totals ",0,"- -",0,"- -",0,"- -",0,"- -"]
["10.Total Part B Allocations5",0]
[]
["Section D: Breakdown for Consortia, State Direct  Services and Emerging Communities","1. Consortia6",null,"2. Direct Services",null,"3. Emerging Communities ",null,"4. Total"]
[null,"Amount","Percentage","Amount","Percentage","Amount","Percentage","Amount","Percentage"]
["1. Core Medical Services Sub-total",0,"- -",0,"- -",0,"- -",0,"- -"]
["a. Outpatient /Ambulatory Health Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["b. AIDS Drug Assistance Program (ADAP) Treatments",null,"- -",null,"- -",null,"- -",0,"- -"]
["c. AIDS Pharmaceutical Assistance (local)",null,"- -",null,"- -",null,"- -",0,"- -"]
["d. Oral Health Care",null,"- -",null,"- -",null,"- -",0,"- -"]
["e. Early Intervention Services ",null,"- -",null,"- -",null,"- -",0,"- -"]
["f. Health Insurance Premium & Cost Sharing Assistance ",null,"- -",null,"- -",null,"- -",0,"- -"]
["g. Home Health Care ",null,"- -",null,"- -",null,"- -",0,"- -"]
["h. Home and Community-based Health Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["i. Hospice Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["j. Mental Health Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["k. Medical Nutrition Therapy",null,"- -",null,"- -",null,"- -",0,"- -"]
["l. Medical Case Management (including Treatment Adherence)",null,"- -",null,"- -",null,"- -",0,"- -"]
["m. Substance Abuse Services–outpatient",null,"- -",null,"- -",null,"- -",0,"- -"]
["2. Support Services Sub-total",0,"- -",0,"- -",0,"- -",0,"- -"]
["a. Case Management (non-Medical) ",null,"- -",null,"- -",null,"- -",0,"- -"]
["b. Child Care Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["c. Emergency Financial Assistance",null,"- -",null,"- -",null,"- -",0,"- -"]
["d. Food Bank/Home-Delivered Meals",null,"- -",null,"- -",null,"- -",0,"- -"]
["e. Health Education/Risk Reduction",null,"- -",null,"- -",null,"- -",0,"- -"]
["f. Housing Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["g. Legal Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["h. Linguistics Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["i. Medical Transportation Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["j. Outreach Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["k. Psychosocial Support Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["l. Referral for Health Care/Supportive Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["m. Rehabilitation Services",null,"- -",null,"- -",null,"- -",0,"- -"]
["n. Respite Care",null,"- -",null,"- -",null,"- -",0,"- -"]
["o. Substance Abuse Residential Services ",null,"- -",null,"- -",null,"- -",0,"- -"]
["p. Treatment Adherence Counseling",null,"- -",null,"- -",null,"- -",0,"- -"]
["3.  Total",0,"- -",0,"- -",0,"- -",0,"- -"]
[]
[null,"MAI Award",null,"(1) The total services amounts will automatically be calculated based on the details you provide in Section D, column 1 or 2 or 3.\n(2) Consortia/Emerging Communities Administration, Planning and Evaluation costs may not exceed 10% of their respective total 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) This amount must equal the combined total of the Part B Base, Part B Supplemental, ADAP, ADAP Supplemental, and Emerging Communities awards.\n(6) All services in this column are considered Supprt Services.\n(7) This amount must equal the total of the Part B MAI Award.\n\n"]
["Section E: MAI Allocations by Program Component","Amount","Percentage"]
["1.  Education to increase minority participation in ADAP",null,"- -"]
["2.  Outreach to increase minority participation in ADAP",null,"- -"]
["3.  Clinical Quality Management 3",null,"- -"]
["4.  Grantee Planning & Evaluation Activities 4",null,"- -"]
["5.  Grantee Administration 4",null,"- -"]
["6. Total MAI Allocations 7",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":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,2],[2,0,2,2],[1,0,1,2],[4,0,4,2],[49,0,51,0],[49,1,50,1],[5,0,5,2],[3,0,3,2],[21,0,21,2],[6,0,6,2]],"flags":["formulas_cached_only"]}
["Part B & MAI Allocations Report"]
["Automatic Calculation of Part B Core Medical & Support Services Allocations"]
[]
["~ Enter Name of Grantee Here ~"]
[]
["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 Allocations Report (green tab)."]
[]
[" Core Medical Services Allocations ","Amount","Percentage\n(Amount / Total Service Allocations)"]
["ADAP (H18)",0,"- -"]
["Home-and Community-based Health Services (H23)",0,"- -"]
["Health Insurance Premium & Cost Sharing Assistance (H22)",0,"- -"]
["State-Direct Services: Core Medical Services (D35)",0,"- -"]
["Emerging Communities: Core Medical Services (F35)",0,"- -"]
["Total Core Medical Services Allocations",0,"- -"]
[]
["Support Services Allocations","Amount","Percent"]
["Consortia Services (B24) + Consortia/EC Administration (H25)",0,"- -"]
["State-Direct Services: Support Services (D49)",0,"- -"]
["Emerging Communities: Support Services (F49)",0,"- -"]
["MAI Allocations for Education + Outreach Services (B70 + B71)",0,"- -"]
["Total Support Services Allocations",0,"- -"]
[]
["Total Part B + MAI Services Allocations ",0]