1.02.10 CT PITT Template - 2026-02-12 - ALL FUNDING MECHANISMS - FINAL.xlsx
XLSX spreadsheet 26 KB Posted
- Opportunity number
- DFOP0018078
About this file
This file is a Performance Indicator Tracking Table (PITT) template designed for implementers of U.S. Department of State Bureau of Counterterrorism (CT) projects to monitor and report progress against project indicators and outcomes. The template serves as a standardized tool for tracking performance data across all CT funding mechanisms and is populated from project Performance Monitoring Plans (PMPs). Implementers must update the PITT with actual indicator data on a quarterly basis throughout the project's period of performance and submit it as either a standalone spreadsheet or annex within quarterly and final reports.
The PITT template requires implementers to document outcomes and their associated indicators, including both output-level indicators (minimum two per outcome) and outcome-level indicators (minimum one per outcome), with at least three relevant CT indicators incorporated overall. The template mandates tracking of initial baselines, quarterly targets and actuals, final targets and actuals, disaggregated data (such as by geography or sex), and progress-to-completion percentages calculated using the formula: (final actual ÷ final target) × 100. Implementers must also include a comments column to explain significant variances from targets, identify data limitations or collection challenges, and note any missing data marked as "N/A." For multi-year projects, additional columns should be added to accommodate additional quarters. The template emphasizes quarterly data review and analysis to identify gaps, trends, and inconsistencies, with notable findings to be documented in corresponding quarterly performance report narratives.
PITT
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
| PITT Instructions |
| Working from a CT project's Performance Monitoring Plan (PMP), implementers should incorporate all indicator data into a performance indicator tracking table (PITT) using the template under the next tab as a model. The PITT documents every indicator's data and tracks its progress over time. This allows for implementers and CT to easily identify gaps, trends, and inconsistencies. When submitting quarterly and final reports, PITTs must be updated with the latest indicator data ("actuals" columns) and submitted as stand-alone spreadsheets or as annexes within the quarterly performance report itself. Implementers should draw from relevant PMP fields (e.g., indicators, indicator type, disaggregations, baselines, targets, etc.) to populate their PITTs. For projects lasting longer than one year, additional columns should be added to the template for quarterly targets and actuals. During project implementation, indicator data should be reviewed and analyzed on a quarterly basis to determine the extent of the project's progress over its period of performance. Notable successes or challenges deriving from the data should be noted in the quarterly report narratives. |
| 1. Copy the Outcomes from the PMP to your PITT in Column B. Add rows as needed to accomodate additional outcomes that reflect your project's parameters. |
| 2. Indicator: Add indicators in Column B under their relevant outcomes. In line with PMP requirements, the PITT must include both output-level indicators (at least two per outcome) and outcome-level indicators (at least one per outcome). These can be drawn from the list of provided CT indicators (see Annex II in PMP Indicators "How To" Guide), and recipients are reminded to use at least three relevant CT indicators. Recipients may also develop/use customized indicators as needed. |
| 2a. Disaggregation: Add any disaggregates of an indicator in separate rows below the indicator. Disaggregation involves additional sub-dividing of data to create additional units of analysis such as geography or sex for a specific indicator. |
| 3. Initial Baseline: Add an initial baseline number in Column C. Baselines are data that are collected before or at the start of a project and provide a basis for planning and/or assessing subsequent progress and impact. For new projects, baselines are usually "zero." The baselines for ongoing projects that have been implemented for some time (e.g., through cost amendments, etc.) should include previous project figures (the number of individuals previously trained or supported). If a project conducts a baseline study, then the PITT must be updated with those figures once the study is completed. |
| 4. Target: In the "Target" columns, add the expected target value for each indicator for each quarter (and for the entire project). Targets are the value of what we expect to achieve for each indicator for each quarter and for the entire project (under "Final Target"). They should be ambitious but achievable. For indicators with disaggregations, include disaggregated targets as well, such as targets specifically for males and females. Use the PMP's Final Target value to establish your quarterly and overall project targets. |
| 5. Actual: The quarterly “Actual” columns are used to report the most recent data available for each indicator. This figure must be updated on a quarterly basis. In the "Final Actual" column, tabulate data from each quarter to determine the total actual for each indicator. |
| 6.Progress to Completion: In this column, "progress to completion" indicates the % progress against an indicator's total target. The percentage formula is as follows: final actual/final target*100=% progress to completion. |
| 7. Comments: Add a brief description in the comments cell for each indicator as needed. If indicators are significantly lower or higher than the target, explain why. If there are any data limitations/challenges for specific indicators, please provide a brief explanation (e.g., self-reporting bias, obtaining follow-up, determining demographic information from administrative files, etc.). Please also include an explanation if data is missing, and mark these cells "N/A". Outlining such limitations and challenges helps to understand/explain the feasibility of collecting and measuring data and controlling for data quality. |
PITT
Project Information Award (Grant or CoAg only) or Agreement Number (IAA only): <Number> Implementing Organization: <Organization Name>
| Period of Performance (POP): MM/DD/YYYY - MM/DD/YYYY | Project Year 1 | ||||
| [Add project years and quarters as needed] | Project Cumulative | ||||
| Qtr. 1 | |||||
| (Oct - Dec YYYY) | Qtr. 2 | ||||
| (Jan - Mar YYYY) | Qtr. 3 | ||||
| (Apr - Jun YYYY) | Qtr. 4 |
(Jul - Sep YYYY)
| Indicator | |||||||||||||
| [Add disaggregrations if needed and type of indicator - output or outcome] | Initial Baseline (PoP Start) | Final Target (PoP End) | Target | Actual | Target | Actual | Target | Actual | Target | Actual | Final Actual | % Progress to Completion | |
| (actual/target) | Comments | ||||||||||||
| OUTCOME 1 [Insert outcome statement from your PMP] | |||||||||||||
| Indicator 1.1: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 1.2: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 1.3: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| [Add rows for additional indicators as needed] | ERROR:#DIV/0! | ||||||||||||
| OUTCOME 2 [Insert outcome statement from your PMP] | |||||||||||||
| Indicator 2.1: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 2.2: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| Indicator 2.3: [Insert indicator title & (Output or OUTCOME)] | ERROR:#DIV/0! | ||||||||||||
| Disaggregation [if needed] | |||||||||||||
| [Add rows for additional indicators as needed] | ERROR:#DIV/0! |
File details come from the government source that posted it. Updated .