Index-based Productivity Measurement

Measure what
actually matters.

Agency-level Total Factor Productivity analysis from input deflation and PPE estimation to weighted index computation and full reporting.

Open Calculator See the Guide
TFP Total Factor Productivity IPM Index Productivity Measurement IQR Outlier Normalization PPE Depreciation Estimation GDP Deflation Applied COA-Aligned Methodology TFP Total Factor Productivity IPM Index Productivity Measurement IQR Outlier Normalization PPE Depreciation Estimation GDP Deflation Applied COA-Aligned Methodology
Step-by-Step Guide

How to use the calculator

Four clear steps to compute your agency's TFP accurately no spreadsheet formulas required.

Step 01
Prepare your performance data
Gather at least one output or outcome indicator across multiple years.

For physical performance, check your agency's Transparency Seal look for the Physical Report of Operations or Accomplishment Report.

For financial data (PS, MOOE, PPE), download audited financial statements from the COA website.
Examples: beneficiaries served, permits issued, km of roads completed
Step 02
Set year range & indicator type
Select your Start Year and End Year. The first year becomes the base year (Index = 100) all subsequent years are measured relative to it.

Choose your indicator type:
Output direct products of your programs
Outcome results and impact indicators
Both combined analysis
Minimum 2 years required. 5+ years recommended for trends.
Step 03
Input your data
After clicking Generate Table, enter data in the grid manually or by pasting directly from Excel.

From Excel: Select a column, copy with Ctrl+C, click the first cell in the table, then press Ctrl+V. Values fill downward automatically.

Input variables (PS, MOOE, PPE) are entered in a dedicated input table.
Multi-column paste works fills across columns and rows simultaneously.
Step 04
Deflate & compute TFP
For monetary data (budget in pesos), click the ? Deflate button on each column to remove inflation effects using auto-fetched GDP deflators. Required for PS, MOOE, and PPE.

Non-monetary indicators (counts, rates, percentages) do not need deflation.

Click Compute TFP to generate the full report with indices, trend charts, and an AI interpretation.
Skipping deflation overstates input growth and understates TFP.
Where to Get Your Data

Recommended data sources

All required data is publicly available. Here's where to find each piece for Philippine government agencies.

Transparency Seal
Physical Report of Operations & Physical Accomplishment Report your output and outcome indicators per year.
COA Website
Audited Financial Statements Personnel Services (PS), MOOE, and PPE/Depreciation data by year.
PREXC / MFO Reports
Major Final Outputs and Performance Indicators from your Program Expenditure Classification documents.
PSA / BSP GDP Deflators
Automatically fetched by the calculator no manual lookup needed. Used to convert nominal to real values.
DBM Budget Data
Annual budget allocations and obligations from the Department of Budget and Management's open data portal.
Agency Annual Reports
Performance narratives and accomplishment tables often includes both physical and financial data consolidated.

Ready to compute your agency's productivity?

Open the calculator, paste your data, and generate a full TFP analysis report with trend charts and AI interpretation in minutes.

Open Calculator