Required Reporting Templates will need to be used by all RWHAP Parts A and B recipients for submitting the Unmet Need estimates and analyses to HRSA HAB. Optional Calculation Tables are provided to assist recipients in gathering and calculating the Unmet Need estimates and analyses. They are intended to be used locally and are not required to be submitted to HRSA HAB.
This zip file contains two different versions of the Excel file. Both Excel files contain the Required Reporting Templates and Optional Calculation Tables reflected in six distinct tabs in the file. The files were updated on 11/12/2020. Please use these files and discard previous versions.
- Version #1 will auto-calculate percentages within all of the tabs and auto-populates data entered into the Optional Calculation Tables directly into the Required Reporting Templates.
- Version #2 also auto-calculates percentages within all of the tabs but does not auto-populate results from the Optional Calculation Tables.
See the related Ryan White HIV/AIDS Program Methodology for Estimating Unmet Need Instruction Manual.