Attachment_3_-_Expenditure_Analysis_Data_Collection_Template.xlsx
XLSX spreadsheet 2 MB Posted
- Solicitation number
- SOL-OAA-16-000004
About this file
This is the standard EA Data Collection Template which is used by PEPFAR Implementing Partners to report expenditure data and is ultimately uploaded to the PROMIS System for approval.
View the file
Other files
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Instructions
| Annual Expenditure Analysis - Data Input Instructions | OU | TYPE | VERSION | MASTER | LANGUAGE | COUNTRY |
| xx | Expenditure | 2015.10 | v17-500r | en-us | xx | |
| Please complete this Excel template and submit it according to the instructions below. | ||||||
| DS-4213 President's Emergency Plan for AIDS Relief (PEPFAR) Program Expenditures | ||||||
| A manual has been provided to assist with this data request. Please review the template and manual now and contact your Activity Manager (AM)/Program Officer (PO)/Agreement/Contracting Officer's Technical Representative (A/COTR) with any questions. | ||||||
| Please read Agency Disclosure Notice and |
Instructions prior to completing this form
| To ensure uniqueness of file names, please use the following conventions when saving your completed templates: |
| Public reporting burden for this collection of information is estimated to average 24 hours per response, including time required for searching existing data sources, gathering the necessary documentation, providing the information and/or documents required, and reviewing the final collection. You do not have to supply this information unless this collection displays a currently valid OMB control number. If you have comments on the accuracy of this burden estimate and/or recommendations for reducing it, please send them to: Office of the US Global AIDS Coordinator (S/GAC) U.S. Department of State, SA-29, 2nd Floor, Washington, DC 20522-2920 |
| <OU>_<Agreement ID>_ EP_<Partner Name>_<Reporting Cycle>_<Seq>.xlsx |
Where:
<OU> = Two letter international Country code (e.g., VN for Vietnam, TZ for Tanzania, etc.) or Operating Unit (OU) identifier
<Agreement_ID> = Mechanism Agreement number; the <Agreement ID> is available from the table on the Results web page in PROMIS
| E = E for an Expenditure Analysis Template |
| OMB No. 1405-0208 OMB approval expires 11/05/2014 Burden-24 hours |
| P = P for template to be attributed to Prime Partner |
<Partner_Name> = Name of the organization associated with template results; enter Prime Partner name
| <Reporting Cycle> = 'yyyy Expenditures' where yyyy is corresponding Fiscal Year (e.g., 2015 Expenditures) |
| Privacy Statement & Disclosure Notice |
| <Seq> = should consist of two numeric digits as follows: |
| PERSONAL INFORMATION |
Once uploaded to the PROMIS website, this information on this form is only accessible to authorized PROMIS users with an assigned user identifier and associated password. All transmissions to and from the PROMIS application are protected and secured via SSL encryption.
PROMIS tracks and associates the following information with each user:
- User name (to ensure a user is uniquely identified within PROMIS)
- User organization (to limit access to only those elements of PROMIS data relevant to your organization)
- User email address (to support user notifications such as a notice for a required password change, a notice to review the site terms of use, etc.)
- User roles & privileges (used to further limit access to only those PROMIS functional capabilities and elements of PROMIS data that are relevant to your role within your organization)
- Each user log-on session to include log-in time and log-out time (to assess the appropriateness of your access to the PROMIS web site)
- Each PROMIS data element entered, updated, or deleted by you in the course of your interactions with PROMIS (to track PROMIS data change history, to assess inappropriate PROMIS data changes, and to provide a means to identify data that may need to be corrected at a future date)
The PROMIS hosting services provider also tracks information to support site performance to include:
- The browser used when accessing PROMIS
- The time & date of each visit to the PROMIS log-in page
- The PROMIS web pages visited
- The address of the web site visited immediately prior to visiting the PROMIS web site
- Any malicious actions against the PROMIS web service.
Your information will not be disclosed, given, sold, or transferred unless required for law enforcement or otherwise required by law.
The PROMIS website is maintained by the U.S. Government and is protected by various provisions of Title 18, U.S. Code. Violations of Title 18 are subject to criminal prosecution in Federal court.
1st Digit = template number; 1 for 1st template, 2 for 2nd template (if more than one template of this type needed), and so on up to 9
2nd Digit = template update number; 1 for initial submission; 2 for the next update (if any), and so on up to 9 For example, Seq = ’34’ means the 4th submission of the 3rd template uploaded (3rd in the original sequence)
Note: if a given template fails to upload successfully, its name should be reused in a subsequent upload try after correction
.xlsx = must be saved as a .xlsx Excel file (not .xls)
Example expenditure analysis (E) template file name :
VN_9740_EP_Columbia University_2015 Expenditures_11.xlsx
Submit the completed template via the PROMIS web-based application and alert your AM/PO/A/COTR of each draft and final submission. Respective USG Agency staff (USAID, CDC, DOD, Peace Corps, State) will receive the data from the PROMIS application.
Complete the Partner Info page. Be sure to include your organization's contact information. Verify that your inputs include all required information in your submission. Implementing organizations, defined as having a direct financial agreement with a USG Agency, are responsible for collating and submitting all sub-partner data.
For each row on the Program Information- ... and Expenditures- ... information entry tabs, use the drop downs to select the geographical area (sub-national unit, national or above-national) pertaining to each entry row and associated values. Also fill in the program area fields for that row of data following the guidance provided (see manual). Each row can have entries for one or more of the listed program information columns. Do not use more than one row to enter program information for each sub-national unit set. Enter results in the correct program information column for that row. Each row with results MUST specify the sub-national unit in the row in which the results appear. Your trainer will provide additional guidance on how to apply the categories listed on the form.
The Expenditure Analysis reporting period is 12 months (01 October to 30 September). This period is regardless of when your organization receives PEPFAR funding.
Please make note of your general comments regarding this mechanism on the Partner Info tab. Please make note of your calculations and comments for the appropriate Program Area heading in the Program Information - Comments and Expenditures - Comments tabs.
On each Comments tab, please explain the following using the comments fields:
o Explain methods for allocation that differ from the recommended methods in the Expenditure Analysis Manual o Explain any expenditure values reported less than 10 USD
In general, more information is better.
USE OF COOKIES
When interacting with the PROMIS website, the PROMIS website maintains both session-based and persistent "cookies" on your browser. PROMIS session-based cookies store text information temporarily in your computer's random access memory (RAM) while you are using PROMIS. When you close your web browser, these cookies are removed. PROMIS persistent cookies store information for a longer period and are used to identify returning PROMIS users.
Prior to submission, please confirm that each of the data quality issues identified on the Data Quality Checks tab are resolved.
| All USG partners are entitled to report their achievements regardless of overlap with another partner. The information you provide will help the USG team report more accurate aggregate data. |
| HIPAA PRIVACY RULE NOTICE |
The PROMIS website does not collect or maintain individually identifiable Protected Health Information (PHI). While PEPFAR Partners may have access to such information from their health service provider Sub-Partners in-Country, PROMIS provides for entry of only aggregated results by pre-defined health Indicator.
PROMIS maintains no individual identifiers that may be linked to a specific individual or patient.
The PROMIS web site maintains only aggregate statistical data. In addition to population counts versus Indicator, PROMIS only maintains sub-counts for certain Indicators by gender (i.e., male or female) and/or age group (e.g., <1 year, 1-5 years, etc.). Hence the PROMIS database and application is not covered under the HIPAA Privacy Rule.
For the detailed definitions of program and expenditure categories, please refer to the manual provided on the PROMIS website.
To help with navigation on the different information entry tabs, notice the Quick Links bar on the left-hand column. Click on any of the blue hyperlink buttons to quickly navigate to that entry sub-section. Additionally, on each information entry tab, there are hyperlink buttons to the respective comments field above each entry area. Click a hyperlink button to quickly move to the proper tab and cell to enter comments for the Program information area; each button reads "Add Comment". Clicking the corresponding button next to each comment field will return you to the previous Program Information or Expenditure column.
* NOTE: DO NOT ADD COLUMNS OR ROWS TO THE WORKSHEETS
Entry Guidance
| Indicator Entry Guidance | |
| To Be Developed |
Expenditures Entry Guidance
To Be Developed
Data Quality Tips
1. To be developed
Other Guidance
Partner Info
Partner Information
Annual Expenditure Analysis FY 2015
| Partner Background (Complete the areas in light gray below) | |
| Partner Organization Name & Agreement ID: | <e.g., ABC Associates: Health Systems Renew (12035 <- 1234)> |
| Director/Chief of Party: |
| Telephone: |
| Cell: |
| E-mail: |
| SI Focal Person (if applicable): |
| Telephone: |
| Cell: |
| E-mail: |
| Financial Focal Person (if applicable): |
| Telephone: |
| Cell: |
| E-mail: |
| Reporting Information |
| Submission Date: |
| Name of Person Submitting Form: |
| USG Approval (For internal purposes only) |
| USG Agency: |
| A/COTR Approval (Name/Date): |
| SI Officer Approval (Name/Date): |
Comments (Provide general comments if needed)
Expenditures - Site-Level
| Result | |||||||||||||||||||||||||||||||||||||||||||||||||
| Country | Tab | Location | Location | Location | Empty | Empty | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | Break | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | FBCTS | Empty | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | CBCTS | Break | CBCTS | CBCTS |
| TZ | Expenditures - Site-Level | Sub-National Unit | Sub-Sub-National Unit | Point-of-Service | FBCTS.INV.TR | FBCTS.INV.CONST&REN | FBCTS.INV.VEHI | FBCTS.INV.EQP&FURN | FBCTS.INV.OTHEXP | FBCTS.REC.PERS | FBCTS.REC.ARV | FBCTS.REC.NONARV | FBCTS.REC.HIVTEST | FBCTS.REC.CONDOM | FBCTS.REC.OTHSUPPLY | FBCTS.REC.FOOD | FBCTS.REC.BLDGRENTAL | FBCTS.REC.TRVL | FBCTS.REC.OTHEXP | FBCTS.ADLTPREART.CV | FBCTS.CHLDPREART.CV | FBCTS.ADLTART.CV | FBCTS.CHLDART.CV | FBCTS.ADLTPREART.LT | FBCTS.CHLDPREART.LT | FBCTS.ADLTART.LT | FBCTS.CHLDART.LT | CBCTS.INV.TR | CBCTS.INV.CONST&REN | CBCTS.INV.VEHI | CBCTS.INV.EQP&FURN | CBCTS.INV.OTHEXP | CBCTS.REC.PERS | CBCTS.REC.ARV | CBCTS.REC.NONARV | CBCTS.REC.HIVTEST | CBCTS.REC.CONDOM | CBCTS.REC.OTHSUPPLY | CBCTS.REC.FOOD | CBCTS.REC.BLDGRENTAL | CBCTS.REC.TRVL | CBCTS.REC.OTHEXP | CBCTS.MEDCARE.EXP | CBCTS.ECSTRNGTH.EXP | |||||
| StartRow | 22 | ||||||||||||||||||||||||||||||||||||||||||||||||
| EndRow | 1521 |
| 0 | |
| 0 | |
| Quick Worksheet Navigation |
Links
| [click link below to advance the worksheet to the selected Program Area] | Site-level Expenditures by Program Area (to be completed by Partner) | Add Comments | Add Comments | ||||||||||||||||||||||||||||||||||||||||||||||
| Total Expenditures: | |||||||||||||||||||||||||||||||||||||||||||||||||
| Site-Lvl Expenditures: | FBCTS - Facility-based Care, Treatment, and Support | CBCTS - Community-based Care, Treatment, and Support | |||||||||||||||||||||||||||||||||||||||||||||||
| Area Totals | 0 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||
| Selected Subtotals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| Selected Totals | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||
| Location | Category Details | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | Clinic Visit: Estimate the average number of times over the year each patient-type received a clinic visit | Lab Tests: Estimate the average number of times over the year each patient-type received a lab test, including CD4 tests, biochemical panels, hematology tests, and viral load assessments | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | Record the amount spent to support activities in each beneficiary service category (Note: The sum of each row must equal the total reported expenditures for CBCTS by Sub-National Unit) | |||||||||||||||||||||||||||||||||||||||||
| specify each as integer value from 0 to 100) | Record the amount spent for HIV test kits that were used to support women and infants | Record the amount spent for ARVs that were used to support women and infants | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | Record the total expenditures spent for each testing modality (sum across modalities must equal total expenditures for HTC by Sub-National Unit) | Investment Expenditures (integer dollar amount) | |||||||||||||||||||||||||||||||||||||||||
| (Note: The sum of each row must equal to the total reported expenditures for OVC by Sub-National Unit) | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | Estimate the amount spent to support GP-PREV activities in each service category (Note: The sum of each row must equal to the total reported expenditures for GP-PREV by Sub-national Unit) | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | Investment Expenditures (integer dollar amount) | Recurrent Expenditures (integer dollar amount) | ||||||||||||||||||||||||||||||||||||||||||
| Sub-National Unit | Sub-Sub-National Unit | Point-of-Service | Training (in-service) | Construction & renovation | Vehicles | Equipment and furniture | Other investment expenditures* | Personnel | Antiretroviral drugs (ARVs) | Non-ARV drugs and reagents | HIV Test Kits | Condoms | Other supplies | Food Supplements | Building rental and Utilities | Travel / Transport | Other site recurrent expenditures* | Adult Pre-ART patients | |||||||||||||||||||||||||||||||
| (15+ years) | Pediatric Pre-ART patients | ||||||||||||||||||||||||||||||||||||||||||||||||
| (< 15 years) | Adult ART patients | ||||||||||||||||||||||||||||||||||||||||||||||||
| (15+ years) | Pediatric ART patients | ||||||||||||||||||||||||||||||||||||||||||||||||
| (< 15 years) | Adult Pre-ART patients | ||||||||||||||||||||||||||||||||||||||||||||||||
| (15+ years) | Pediatric Pre-ART patients | ||||||||||||||||||||||||||||||||||||||||||||||||
| (< 15 years) | Adult ART patients (15+ years) | Pediatric ART patients (< 15 years) | Training (in-service) | Construction & renovation | Vehicles | Equipment and furniture | Other investment expenditures* | Personnel | Antiretroviral drugs (ARVs) | Non-ARV drugs and reagents | HIV Test Kits | Condoms | Other supplies | Food Supplements | Building rental and Utilities | Travel / Transport | Other site recurrent expenditures* | Medical Care (not facility-based) | Economic Strengthening | Psychological, Social, and Spiritual Care | Nutrition and food security | Training (in-service) | Construction & renovation | Vehicles | Equipment and furniture | Other investment expenditures* | Personnel | Antiretroviral drugs (ARVs) | Non-ARV drugs and reagents | HIV Test Kits | Condoms | Other supplies | Food Supplements | Building rental and Utilities | Travel / Transport | Other site recurrent expenditures* | HIV Testing for Pregnant Women | HIV Testing for Exposed Infants | Prevention and Care for Pregnant Women (Option A, B, or B+ Services) | Prevention and Care for Exposed Infants | Pregnant Women | Infants | Pregnant Women | Infants | |||||
| FBCTS | |||||||||||||||||||||||||||||||||||||||||||||||||
| CBCTS | |||||||||||||||||||||||||||||||||||||||||||||||||
| PMTCT | |||||||||||||||||||||||||||||||||||||||||||||||||
| VMMC | |||||||||||||||||||||||||||||||||||||||||||||||||
| HTC | |||||||||||||||||||||||||||||||||||||||||||||||||
| PEP | |||||||||||||||||||||||||||||||||||||||||||||||||
| BS | |||||||||||||||||||||||||||||||||||||||||||||||||
| LAB | |||||||||||||||||||||||||||||||||||||||||||||||||
| IC | |||||||||||||||||||||||||||||||||||||||||||||||||
| OVC | |||||||||||||||||||||||||||||||||||||||||||||||||
| GP-PREV | |||||||||||||||||||||||||||||||||||||||||||||||||
| SORP-KP |
Add Comments /xl/drawings/drawing1.xml#Cmt_E_FBCTSAdd Comments /xl/drawings/drawing1.xml#Cmt_E_CBCTSAdd Comments /xl/drawings/drawing1.xml#Cmt_E_PMTCTAdd Comments /xl/drawings/drawing1.xml#Cmt_E_VMMCAdd Comments /xl/drawings/drawing1.xml#Cmt_E_HTCAdd Comments /xl/drawings/drawing1.xml#Cmt_E_PEPAdd Comments /xl/drawings/drawing1.xml#Cmt_E_BSAdd Comments /xl/drawings/drawing1.xml#Cmt_E_LABAdd Comments /xl/drawings/drawing1.xml#Cmt_E_ICAdd Comments /xl/drawings/drawing1.xml#Cmt_E_OVCAdd Comments /xl/drawings/drawing1.xml#Cmt_E_SORP_GPAdd Comments /xl/drawings/drawing1.xml#Cmt_E_SORP_IDUAdd Comments /xl/drawings/drawing1.xml#Cmt_E_SORP_CSWAdd Comments /xl/drawings/drawing1.xml#Cmt_E_SORP_MSMAdd Comments /xl/drawings/drawing1.xml#Cmt_E_SORP_KPOthAdd Comments /xl/drawings/drawing1.xml#Cmt_E_MMTFBCTS /xl/drawings/drawing1.xml#Link_ESL_FBCTSCBCTS /xl/drawings/drawing1.xml#Link_ESL_CBCTSPMTCT /xl/drawings/drawing1.xml#Link_ESL_PMTCTVMMC /xl/drawings/drawing1.xml#Link_ESL_VMMCHTC /xl/drawings/drawing1.xml#Link_ESL_HTCPEP /xl/drawings/drawing1.xml#Link_ESL_PEPBS /xl/drawings/drawing1.xml#Link_ESL_BSLAB /xl/drawings/drawing1.xml#Link_ESL_LABIC /xl/drawings/drawing1.xml#Link_ESL_ICOVC /xl/drawings/drawing1.xml#Link_ESL_OVCGP-PREV /xl/drawings/drawing1.xml#Link_ESL_SORP_GPKP-PWID /xl/drawings/drawing1.xml#Link_ESL_SORP_IDUKP-FSW /xl/drawings/drawing1.xml#Link_ESL_SORP_CSWKP-MSMTG /xl/drawings/drawing1.xml#Link_ESL_SORP_MSMPP-PREV /xl/drawings/drawing1.xml#Link_ESL_SORP_KPOthMAT /xl/drawings/drawing1.xml#Link_ESL_MMT Expenditures - PM
| Result | ||||||||||||||||||||||||||||||
| Country | Tab | Location | Location | Empty | Empty | Empty | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | PM | End-of-data |
| TZ | Expenditures - PM | Sub-National Unit | Sub-Sub-National Unit | PM.PERS | PM.CNSLT | PM.TRNSPT | PM.OTH | PM.FBCTS.EXP | PM.CBCTS.EXP | PM.PMTCT.EXP | PM.VMMC.EXP | PM.HTC.EXP | PM.PEP.EXP | PM.BS.EXP | PM.LAB.EXP | PM.IC.EXP | PM.OVC.EXP | PM.SORPG.EXP | PM.SORPI.EXP | PM.SORPC.EXP | PM.SORPM.EXP | PM.SORPO.EXP | PM.MMT.EXP | PM.SI.EXP | PM.SURV.EXP | PM.HSS.EXP | End-of-data | |||
| StartRow | 22 | |||||||||||||||||||||||||||||
| EndRow | 521 |
| 0 | ||||||||||||||||||||||||||||
| Program Management Expenditures (to be completed by Partner) | Add Comments | |||||||||||||||||||||||||||
| Total Expenditures: | ||||||||||||||||||||||||||||
| PM Expenditures: | PM - Program Management | |||||||||||||||||||||||||||
| Selected Subtotals | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
| Selected Totals | 0 | |||||||||||||||||||||||||||
| Location | Category Details | Above Site-Level Program Management expenditures | ||||||||||||||||||||||||||
| (select Sub-National Unit, National or Above National as appropriate for Location) | Indicate percentage (0 to 100) of program management expenditures used to support services (each row should total to 100) | |||||||||||||||||||||||||||
| Quick Worksheet Navigation | ||||||||||||||||||||||||||||
| Links | Sub-National Unit | Sub-Sub-National Unit | Point-of-Service | Personnel | Consultants (External) | Transport/ Travel | Other General/ Administrative | FBCTS | CBCTS | PMTCT | VMMC | HTC | PEP | BS | LAB | IC | OVC | GP-PREV | KP-PWID | KP-FSW | KP-MSMTG | PP-PREV | MAT | SI | Surveillance | HSS | ||
| PM |
/xl/drawings/drawing2.xml#Cmt_E_PM Expenditures - SI
| Result | |||||||||||||||||||||||||||||||||
| Country | Tab | Location | Location | Empty | Empty | Empty | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | SI | Empty | Surveillance | Surveillance | Surveillance | Surveillance | End-of-data |
| TZ | Expenditures - SI | Sub-National Unit | Sub-Sub-National Unit | SI.PERS | SI.CNSLT | SI.TRNSPT | SI.OTH | SI.FBCTS.EXP | SI.CBCTS.EXP | SI.PMTCT.EXP | SI.VMMC.EXP | SI.HTC.EXP | SI.PEP.EXP | SI.BS.EXP | SI.LAB.EXP | SI.IC.EXP | SI.OVC.EXP | SI.SORPG.EXP | SI.SORPI.EXP | SI.SORPC.EXP | SI.SORPM.EXP | SI.SORPO.EXP | SI.MMT.EXP | SI.HSS.EXP | SURV.PERS | SURV.CNSLT | SURV.TRNSPT | SURV.OTH | End-of-data | ||||
| StartRow | 22 | ||||||||||||||||||||||||||||||||
| EndRow | 521 |
| 0 | |
| Quick Worksheet Navigation |
Links
| [click link below to advance the worksheet to the selected Program Area] | SI and Surveillance Expenditures (to be completed by Partner) | Add Comments | Add Comment | ||||||||||||
| Total Expenditures: | |||||||||||||||
| SI/Surv Expenditures: | SI - Strategic Information | Surveillance | |||||||||||||
| Selected Subtotals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
| Selected Totals | 0 | 0 | |||||||||||||
| Location | Category Details | Above Site Level SI expenditures | |||||||||||||
| (select Sub-National Unit, National or Above National as appropriate for Location) | Indicate percentage (0 to 100) of SI expenditures used to support services (each row should total to 100) | Above Site-Level Surveillance expenditures |
(select Sub-National Unit, National or Above National as appropriate for Location)
| Sub-National Unit | Sub-Sub-National Unit | Point-of-Service | Personnel | Consultants (External) | Transport/ Travel | Other General/ Administrative | FBCTS | CBCTS | PMTCT | VMMC | HTC | PEP | BS | LAB | IC | OVC | GP-PREV | KP-PWID | KP-FSW | KP-MSMTG | PP-PREV | MAT | HSS | Personnel | Consultants (External) | Transport/ Travel | Other General/ Administrative | |
| SI | ||||||||||||||||||||||||||||
| Surveillance |
/xl/drawings/drawing3.xml#Cmt_E_SIAdd Comments /xl/drawings/drawing3.xml#Cmt_E_SurveillanceSI /xl/drawings/drawing3.xml#Link_ESI_SISurveillance /xl/drawings/drawing3.xml#Link_ESI_Surveillance Expenditures - HSS
| Result | ||||||||||||||||||||||||||||||||||||||||||
| Country | Tab | Location | Location | Empty | Empty | Empty | HSS | HSS | HSS | HSS | HSS | Empty | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | HSS | End-of-data |
| TZ | Expenditures - HSS | Sub-National Unit | Sub-Sub-National Unit | HSS.PERS | HSS.CNSLT | HSS.TRNSPT | HSS.CONSTR | HSS.OTH | HSS.HR.PSTNEW.EXP | HSS.HR.INSERVTR.EXP | HSS.HR.PERFSPRT.EXP | HSS.HR.PLCYPLAN.EXP | HSS.GOV.SGTP.EXP | HSS.GOV.GENPOL.EXP | HSS.FIN.EXP | HSS.SYSDEV.SCS.EXP | HSS.SYSDEV.HIS.EXP | HSS.SYSDEV.LABSTR.EXP | HSS.ORGDEV.CIVNGORG.EXP | HSS.ORGDEV.GOVINST.EXP | HSS.FBCTS.EXP | HSS.CBCTS.EXP | HSS.PMTCT.EXP | HSS.VMMC.EXP | HSS.HTC.EXP | HSS.PEP.EXP | HSS.BS.EXP | HSS.LAB.EXP | HSS.IC.EXP | HSS.OVC.EXP | HSS.SORPG.EXP | HSS.SORPI.EXP | HSS.SORPC.EXP | HSS.SORPM.EXP | HSS.SORPO.EXP | HSS.MMT.EXP | HSS.SI.EXP | End-of-data | ||||
| StartRow | 22 | |||||||||||||||||||||||||||||||||||||||||
| EndRow | 521 |
| 0 | |||||||||||||||||||||||||||||||||||||||||
| Health System Strengthening (HSS) Expenditures (to be completed by Partner) | Add Comments | ||||||||||||||||||||||||||||||||||||||||
| Total Expenditures: | |||||||||||||||||||||||||||||||||||||||||
| HSS Expenditures: | HSS - Health System Strengthening | ||||||||||||||||||||||||||||||||||||||||
| Selected Subtotals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||
| Selected Totals | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||||||
| Location | Category Details | Above Site-Level health system strengthening expenditures | |||||||||||||||||||||||||||||||||||||||
| (select Sub-National Unit, National or Above National as appropriate for Location) | For each Sub-National Unit, record the total expenditures used to support services in each functional area: | ||||||||||||||||||||||||||||||||||||||||
| (Note: The sum of this table must equal the total spent to support HSS) | Indicate the percentage (0 to 100) of total HSS expenditures used to support each of the following program areas (each row should total to 100) | ||||||||||||||||||||||||||||||||||||||||
| Human Resources (HR) | Governance | Finance | Systems Development | Institutional and Organizational Development | |||||||||||||||||||||||||||||||||||||
| Quick Worksheet Navigation | |||||||||||||||||||||||||||||||||||||||||
| Links | Sub-National Unit | Sub-Sub-National Unit | Point-of-Service | Personnel | Consultants (External) | Transport/ Travel | Construction and Renovation | Other General/ Administrative | Pre-service training | In-service training systems support and institutionalization | HRH performance support /quality | HRH policy, planning, and management | Technical-area Specific Guidelines, Tools and Policy | General Policy and Other Governance | Supply Chain Systems | Health Information Systems | Laboratory Strengthening | Civil Society and Non-Governmental Organizations | Government Institutions | FBCTS | CBCTS | PMTCT | VMMC | HTC | PEP | BS | LAB | IC | OVC | GP-PREV | KP-PWID | KP-FSW | KP-MSMTG | PP-PREV | MAT | SI | |||||
| HSS |
/xl/drawings/drawing4.xml#Cmt_E_HSS Expenditures - Comments
| Comment | Unused text string for SpreadSheet Gear | Unused text string for SpreadSheet Gear | ||
| Country | Partner-Mechanism | Technical-Sub-Area | Comment | End-Of-Data |
| TZ | <e.g., ABC Associates: Health Systems Renew (12035 <- 1234)> | Unused text string for SpreadSheet Gear | Unused text string for SpreadSheet Gear | |
| 18 | 18 | |||
| 44 | 44 |
Expenditures - Comments
| Please use the space below to provide comments that will aid in interpreting the data. | ||
| Return to Expenditures Worksheet | ||
| FBCTS | Site-Level | |
| Return to Expenditures Worksheet | ||
| CBCTS | Site-Level | |
| Return to Expenditures Worksheet | ||
| PMTCT | Site-Level | |
| Return to Expenditures Worksheet | ||
| VMMC | Site-Level | |
| Return to Expenditures Worksheet | ||
| HTC | Site-Level | |
| Return to Expenditures Worksheet | ||
| PEP | Site-Level | |
| Return to Expenditures Worksheet | ||
| BS | Site-Level | |
| Return to Expenditures Worksheet | ||
| LAB | Site-Level | |
| Return to Expenditures Worksheet | ||
| IC | Site-Level | |
| Return to Expenditures Worksheet | ||
| OVC | Site-Level | |
| Return to Expenditures Worksheet | ||
| GP-PREV | Site-Level | |
| Return to Expenditures Worksheet | ||
| SORP-KP | Site-Level | |
| Return to Expenditures Worksheet | ||
| KP-PWID | Site-Level | |
| Return to Expenditures Worksheet | ||
| KP-FSW | Site-Level | |
| Return to Expenditures Worksheet | ||
| KP-MSMTG | Site-Level | |
| Return to Expenditures Worksheet | ||
| PP-PREV | Site-Level | |
| Return to Expenditures Worksheet | ||
| MAT | Site-Level | |
| Return to Expenditures Worksheet | ||
| PM | PM | |
| Return to Expenditures Worksheet | ||
| SI | SI | |
| Return to Expenditures Worksheet | ||
| Surveillance | Surveillance | |
| Return to Expenditures Worksheet | ||
| Reserved | Site-Level | |
| Return to Expenditures Worksheet | ||
| HSS | HSS |
Site-Level /xl/drawings/drawing5.xml#Link_ESL_FBCTSSite-Level /xl/drawings/drawing5.xml#Link_ESL_CBCTSSite-Level /xl/drawings/drawing5.xml#Link_ESL_PMTCTSite-Level /xl/drawings/drawing5.xml#Link_ESL_VMMCSite-Level /xl/drawings/drawing5.xml#Link_ESL_HTCSite-Level /xl/drawings/drawing5.xml#Link_ESL_PEPSite-Level /xl/drawings/drawing5.xml#Link_ESL_BSSite-Level /xl/drawings/drawing5.xml#Link_ESL_LABSite-Level /xl/drawings/drawing5.xml#Link_ESL_ICSite-Level /xl/drawings/drawing5.xml#Link_ESL_OVCSite-Level /xl/drawings/drawing5.xml#Link_ESL_SORP_GPSite-Level /xl/drawings/drawing5.xml#Link_ESL_SORP_MARPsPM /xl/drawings/drawing5.xml#Link_EPM_PMSI /xl/drawings/drawing5.xml#Link_ESI_SISI (Surveillance) /xl/drawings/drawing5.xml#Link_ESI_SurveillanceHSS /xl/drawings/drawing5.xml#Link_EHS_HSSSite-Level /xl/drawings/drawing5.xml#Link_ESL_MMTSite-Level /xl/drawings/drawing5.xml#Link_ESL_SORP_IDUSite-Level /xl/drawings/drawing5.xml#Link_ESL_SORP_CSWSite-Level /xl/drawings/drawing5.xml#Link_ESL_SORP_MSMSite-Level /xl/drawings/drawing5.xml#Link_ESL_SORP_KPOth Definitions
| Definitions | ||
| Definitions To Be Provided | Return to Worksheet |
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
Return to Worksheet
| Abbreviations | |
| BS | Blood Safety |
| CBCT | Community-based counseling and testing |
| CBCTS | Community-based Care, Treatment and Support |
| CSW | Commercial sex worker |
| FBCTS | Facility-based Care, Treatment and Support |
| HSS | Health system strengthening |
| HTC | HIV Testing and Counseling |
| IC | Infection Control |
| IDU | Injection Drug User |
| Lab | Lab |
| M&E | Monitoring and Evaluation |
| MMT | Medically-assisted Methodone Therapy |
| MSM | Men who have sex with men |
| OVC | Orphans and Vulnerable Children |
| PEP | Post-exposure Prophylaxis |
| PITC | Provider-initiated testing and counseling |
| PLHIV | Person living with HIV/AIDS |
| PM | Program management |
| PMTCT | Prevention of Mother-to-Child Transmission |
| SORP- GP | Sexual and Other Risk Prevention- General Population |
| SORP- MARPs | Sexual and Other Risk Prevention- Most at risk populatons |
| VCT | voluntary testing and counseling |
| VMMC | Voluntary Medical Male Circumcision |
Data Quality Checks
Data Quality Check Navigation Links
[click link below to advance the worksheet to the selected tab data quality check] Site-level Expenditure Data Quality Checks PM Expenditure Data Quality Checks SI Expenditure Data Quality Checks HSS Expenditure Data Quality Checks Expenditures Comments Data Quality Checks Total Expenditures Data Quality Check
| If 'No!' appears anywhere in the table below, please correct the corresponding Sub-National Unit row location and/or expenditure entries on the Expenditures - Site-Level tab | |||||
| If 'Please Explain' appears anywhere in the table below, please confirm & include an explanation for the data on Expenditures - Comments tab | If 'No!' appears anywhere in the table below, | ||||
| please correct the corresponding Sub-National Unit row location and/or percentage entries on the Expenditures - PM tab | If 'No!' appears anywhere in the table below, please correct corresponding Sub-National Unit location and/or row percentage entries on Expenditures - SI tab | ||||
| If 'Please Explain' appears anywhere in the table below, please confirm & include an explanation for the data on Expenditures - Comments tab | If 'No!' appears anywhere in the table below, please correct the corresponding Sub-National Unit location and/or row percentage entries on Expenditures - HSS tab | ||||
| If 'Please Explain' appears anywhere in the table below, please confirm & include an explanation for the data on Expenditures - Comments tab | If 'No!' appears anywhere in the table below, please limit comments entries to 5,000 characters or less for the Program Area on the Expenditures - Comments tabs | If 'No!' appears in the table below, please confirm all expenditures reported in USD and not local currency |
| Expenditures - Site-Level tab data quality checks (DQCs) : | C:E when H:LB > 0 | H:LB > 0 when C:E | [L+V]/[H:V] <= 0.2 | H:V >= 0 | X > 50 | Y > 50 | Z > 50 | AA > 50 | AB > 50 | AC > 50 | AD > 50 | AE > 50 | AG:AU = AW:AZ | [AK+AU]/[AG:AU] <= 0.2 | AG:AU >= 0 and | ||||||||||||||||||||||||||||||||||
| AW:AZ >= 0 | BH = BX:BY | BJ = BV:BW | [BF+BP]/[BB:BP] <= 0.2 | BB:BP >= 0 | BR:BU = 100 | BR:BU >= 0 | CG = 0 | [CE+CO]/[CA:CO] <= 0.2 | CA:CO >= 0 | CQ:DE = DG:DI | CW = 0 | [CU+DE]/[CQ:DE] <= 0.2 | CQ:DE + DG:DI >= 0 | [DO+DY]/[DK:DY] <= 0.2 | DK:DY >= 0 | EG = 0 | [EE+EO]/[EA:EO] <= 0.2 | EA:EO >= 0 | EW = 0 | EX = FK:FN | FA = FO:FR | [EU+FE]/[EQ:FE] <= 0.2 | EQ:FE , FK:FR >= 0 | FG:FJ = 100 | FG:FJ >= 0 | FZ = 0 | [FX+GH]/[FT:GH] <= 0.2 | FT:GH >= 0 | GJ:GX = GZ:HF | GP = 0 | [GN+GX]/[GJ:GX] <= 0.2 | GJ:GX , GZ:HF >= 0 | HH:HV = HX:HZ | HN = 0 | [HL+HV]/[HH:HV] <= 0.2 | HH:HV >= 0 | IH = 0 | [IF+IP]/[IB:IP] <= 0.2 | IB:IP >= 0 | IX = 0 | [IV+JF]/[IR:JF] <= 0.2 | IR:JF >= 0 | JN = 0 | [JL+JV]/[JH:JV] <= 0.2 | JH:JV >= 0 | KD= 0 | [KB+KL]/[JX:KL] <= 0.2 | JX:KL >= 0 | KT = 0 |
| Location | Location and Point-of-Service identified on all rows with results? | Results identified on all rows with Location and Point-of-Service? | FBCTS Other Investment & Recurrent expenditures <= 20% of total FBCTS expenditures on row? | All FBCTS expenditures non-negative? | Average yearly clinic visits for Adult patients on Pre-ART less than or equal to 50 on row? | Average yearly clinic visits for Pediatric patients on Pre-ART less than or equal to 50 on row? | Average yearly clinic visits for Adult patients on ART less than or equal to 50 on row? | Average yearly clinic visits for Pediatric patients on ART less than or equal to 50 on row? | Average yearly lab tests for Adult patients on Pre-ART less than or equal to 50 on row? | Average yearly lab tests for Pediatric patients on Pre-ART less than or equal to 50 on row? | Average yearly lab tests for Adult patients on ART less than or equal to 50 on row? | Average yearly lab tests for Pediatric patients on ART less than or equal to 50 on row? | CBCTS expenditures equal disaggregated expenditures? | CBCTS Other Investment & Recurrent expenditures <= 20% of total CBCTS expenditures on row? | All CBCTS expenditures non-negative? | PMTCT recurrent ARV expenditures equal disaggregated ARV expenditures for women & infants? | PMTCT recurrent HIV Test Kit expenditures equal disaggregated HIV Test Kit expenditures for women & infants? | PMTCT Other Investment & Recurrent expenditures <= 20% of total PMTCT expenditures on row? | All PMTCT expenditures non-negative? | Distribution of PMTCT activities equals 100? | All PMTCT percentages non-negative? | Recurrent ARV expenditures for VMMC on row? | VMMC Other Investment & Recurrent expenditures <= 20% of total VMMC expenditures on row? | All VMMC expenditures non-negative? | HTC expenditures equal disaggregated expenditures? | Recurrent ARV expenditures for HTC on row? | HTC Other Investment & Recurrent expenditures <= 20% of total HTC expenditures on row? | All HTC expenditures non-negative? | PEP Other Investment & Recurrent expenditures <= 20% of total PEP expenditures on row? | All PEP expenditures non-negative? | Recurrent ARV expenditures for Blood Safety (BS) on row? | Blood Safety (BS) Other Investment & Recurrent expenditures <= 20% of total BS expenditures on row? | All Blood Safety expenditures non-negative? | Recurrent ARV expenditures for LAB on row? | LAB recurrent Non-ARV drugs and reagents expenditures equal disaggregated Non-ARV expenditures? | LAB recurrent Other Supplies expenditures equal disaggregated Other Supplies expenditures? | LAB Other Investment & Recurrent expenditures <= 20% of total LAB expenditures on row? | All LAB expenditures non-negative? | Distribution of LAB activities equals 100? | All LAB percentages non-negative? | Recurrent ARV expenditures for IC on row? | IC Other Investment & Recurrent expenditures <= 20% of total IC expenditures on row? | All IC expenditures non-negative? | OVC expenditures equal disaggregated expenditures? | |||||
| Sub-National Unit | Sub-Sub-National Unit | Point-of-Service | |||||||||||||||||||||||||||||||||||||||||||||||
| Expenditure - Site-Level | |||||||||||||||||||||||||||||||||||||||||||||||||
| Expenditure - PM | |||||||||||||||||||||||||||||||||||||||||||||||||
| Expenditure - SI | |||||||||||||||||||||||||||||||||||||||||||||||||
| Expenditure - HSS |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .