Step-by-Step Guide
How to use the calculator
Follow these eight steps to compute your agency's Total Factor Productivity accurately and efficiently.
01
Set Your Year Range
Choose a Start Year and End Year from the dropdowns in Step 1.
The first year you select becomes the Base Year — all index values are set to 100 for that year, and all subsequent years are measured relative to it.
The first year you select becomes the Base Year — all index values are set to 100 for that year, and all subsequent years are measured relative to it.
Select at least 3–4 years for meaningful TFP trend analysis. A minimum of 2 years is required.
02
Select Variable Type
Use the Variable Type dropdown to choose what you want to measure:
• Output — quantitative deliverables (no. of cases, services rendered)
• Outcome — qualitative results (satisfaction rates, impact scores)
• Both — compute Output TFP and Outcome TFP side by side
Then click Generate Table to build your data entry grid.
• Output — quantitative deliverables (no. of cases, services rendered)
• Outcome — qualitative results (satisfaction rates, impact scores)
• Both — compute Output TFP and Outcome TFP side by side
Then click Generate Table to build your data entry grid.
Use Both when your agency tracks both direct deliverables and program impact indicators simultaneously.
03
Enter or Paste Data
Type values directly into each cell, or paste from Excel:
1. Select and copy a column in Excel (Ctrl+C)
2. Click the first input cell in the calculator
3. Press Ctrl+V — values fill downward automatically
Use Enter, Tab, or arrow keys to navigate between cells. Input variables (PS, MOOE, PPE) are entered in the dedicated input table below.
1. Select and copy a column in Excel (Ctrl+C)
2. Click the first input cell in the calculator
3. Press Ctrl+V — values fill downward automatically
Use Enter, Tab, or arrow keys to navigate between cells. Input variables (PS, MOOE, PPE) are entered in the dedicated input table below.
Multi-column paste works too — copy a range in Excel and paste; the calculator fills matching columns automatically.
04
Rename Column Headers
Each column header is editable. Click directly on a column name in the table header to rename it.
Press Enter or click away to confirm the new name.
Example: Rename "Output 1" → "No. of Clients Served" to make your report more descriptive and meaningful.
Press Enter or click away to confirm the new name.
Example: Rename "Output 1" → "No. of Clients Served" to make your report more descriptive and meaningful.
Use the actual MFO or indicator name from your PREXC documents so the generated report is immediately usable.
05
Apply GDP Deflation
For monetary data (budget amounts in pesos), click the ⊕ Deflate button on each column header to apply GDP deflators automatically.
• Output & Outcome: Deflation is optional (only for monetary values)
• Input columns (PS, MOOE, PPE): Deflation is required
Non-monetary data (counts, rates, headcount) — skip deflation entirely.
• Output & Outcome: Deflation is optional (only for monetary values)
• Input columns (PS, MOOE, PPE): Deflation is required
Non-monetary data (counts, rates, headcount) — skip deflation entirely.
Skipping deflation on monetary inputs will overstate or understate TFP. Always deflate budget and expenditure columns.
06
Set Budget Weights
If you have 2 or more output or outcome columns, assign annual budget weights to each variable:
1. Enter the budget allocation for each column per year in the Budget panel
2. Click Compute Weights
The Törnqvist index will use these weights — averaged over 3 years — for a more accurate productivity measure. If you only have 1 column, this step is skipped automatically.
1. Enter the budget allocation for each column per year in the Budget panel
2. Click Compute Weights
The Törnqvist index will use these weights — averaged over 3 years — for a more accurate productivity measure. If you only have 1 column, this step is skipped automatically.
Budget weights should come from your agency's annual budget obligations per program or MFO from DBM or COA records.
07
Compute TFP
Once all data is entered, click the Compute TFP button in Step 4.
The calculator will:
• Build chain-linked output & outcome indices
• Compute the Törnqvist input index (3-year average weights)
• Calculate TFP = (Output Index ÷ Input Index) × 100
• Display results in a summary table with status badges
Then click Generate Diagram to view interactive trend charts.
The calculator will:
• Build chain-linked output & outcome indices
• Compute the Törnqvist input index (3-year average weights)
• Calculate TFP = (Output Index ÷ Input Index) × 100
• Display results in a summary table with status badges
Then click Generate Diagram to view interactive trend charts.
TFP > 100 means output grew faster than inputs (productivity gain). TFP < 100 means inputs grew faster (productivity decline).
08
Interpret, Export & Reset
After generating diagrams, click Interpret to get an automated analysis of your TFP results — identifying years of gain, decline, and a management recommendation.
Click Download PDF Report to export a complete formatted report with tables, trend charts, and interpretation for submission or presentation.
To start over, click Reset All — this clears all data and returns you to Step 1.
Click Download PDF Report to export a complete formatted report with tables, trend charts, and interpretation for submission or presentation.
To start over, click Reset All — this clears all data and returns you to Step 1.
Use Reset All before changing the Variable Type (Output / Outcome / Both), as switching modes requires a fresh table.
Data Sources
Where to get your data
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 begin
Compute your agency's productivity today
Open the calculator, paste your data from Excel, and generate a full TFP analysis report with trend charts and interpretation — no formulas needed.