Your feedback helps us improve the Productivity Calculator
Overall satisfaction
Tap a star to rate
Likelihood to recommend (0 = not likely, 10 = definitely)
Not likelyDefinitely
Areas for improvement (select all that apply)
Additional comments (optional)
0 / 1000
Thank you for your feedback!
Your response has been recorded and will help the COE-PSP team continue improving this tool for Philippine public sector agencies.
Missing Data Detected
Estimate missing values using interpolation or extrapolation before computing TFP
Missing values found in:
Estimation Method
Regression Summary
Estimated Values by Column
Estimate Capitals (PPE)
Derive Capitals proportionally from program & agency budget shares
Formula: Program Budget + CO ÷ Total Agency Budget+ CO × Total Agency Capitals (PPE)
Enter Values by Year
Year
Program Budget
Total Agency Budget
Agency Capitals (PPE)
Estimated Capitals
Action
Step 1 of 9
Set Year Range
Productivity Analytics
Productivity Calculator
1
Configure
2
Variables
3
Inputs
4
Compute
5
Results
How to Use click to expand
Quick reference below — or launch the step-by-step guide:
1
Set Year Range Choose Start & End Year. The first year becomes the Base Year (Index = 100). Select at least 3-4 years for meaningful analysis.
2
Select Variable Type Pick Output (deliverables), Outcome (results/impact), or Both. Click Generate Table.
3
Enter / Paste Data Type values or paste from Excel (Ctrl+C → click first cell → Ctrl+V). Multi-column paste supported. Use arrow keys to navigate.
4
Rename Column Headers Click any column header to rename it. Use your actual MFO or indicator name (e.g. "No. of Clients Served") for a ready-to-submit report.
5
Apply GDP Deflation For monetary columns click Deflate. Input columns (PS, MOOE, Capitals) require deflation. Output/Outcome — optional for monetary values only.
6
Set Budget Weights For 2+ output/outcome columns, enter annual budget allocations per column and click Compute Weights. Single-column setups skip this step.
7
Missing Data Detection Leave cells blank — clicking Compute TFP auto-detects gaps and offers Linear Regression, Piecewise, Mean, or CAGR estimation.
8
Compute TFP Click Compute TFP to generate chain-linked indices and TFP values. Then click Generate Diagram for interactive trend charts.
9
Interpret, Export & Reset Click Interpret for automated analysis, Download PDF Report to export, or Reset All to start fresh.
Tip: Leave cells blank and click Compute TFP → missing values are detected automatically with Linear Regression, Piecewise, Mean, or CAGR estimation. For multi-column outputs, assign budget weights per year and click Compute Weights before computing TFP. Budget data from DBM or COA annual records.
1
Configure Year Range & Variable Type
Start Year
End Year
Variable Type
Output
Outcome
Both (Output & Outcome)
Select start and end years above.
Use Reset All to clear data and start over.
2Output VariablesClick headers to rename · Deflate = optional GDP deflator
Enter your output/outcome values per year. Paste from Excel with Ctrl+V. First year = base year (Index = 100). Missing values? Leave cells blank — clicking Compute TFP will detect them and offer estimation options automatically. Multiple columns? Enter annual budget allocation and click Compute Weights. Monetary values (in pesos)? Deflation is required to remove the effects of inflation — click Deflate on that column's header.
3
Input Variables
PS / MOOE / Capitals (PPE) · Click headers to rename · Deflate required for monetary inputs
Enter actual budget/expenditure values per year. Deflation is required for monetary inputs. No program-level Capitals (PPE) data on hand? Use the Estimate Capitals (PPE) button above the table to derive it proportionally from budget shares — it automatically detects whichever column is named "Capitals" or "PPE".
Variables: 3
4
Compute & Analyze
Range: · First year = Base Year (Index = 100)
Missing values are detected automatically and estimation options will appear.
TFP Analysis Report
Total Factor Productivity ·
Index & TFP Summary Table
Available for Both mode — checks if Output is translating into Outcome.
TFP Trend Diagram
TFP Trend Diagrams
Output TFP Trend
Outcome TFP Trend
Outcome-to-Output Gap
Is Output translating into Outcome? Gap Index = Outcome TFP ÷ Output TFP × 100 for each year. A value at or near 100 means outcomes are keeping pace with outputs. Below 100 — outputs aren't fully translating into outcomes/impact. Above 100 — outcomes are improving faster than outputs, worth double-checking against your data.