Estimate missing values using interpolation or extrapolation before computing TFP
Missing values found in:
Estimation Method
Regression Summary
Estimated Values by Column
Step 1 of 9
Set Year Range
Productivity Analytics
Productivity Calculator
Missing data detection · Interpolation · Extrapolation · TFP
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 34 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, PPE) 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.
3
Input Variables
PS / MOOE / PPE · Click headers to rename · ? Deflate required for monetary inputs
Enter actual budget/expenditure values per year. ? Deflation is required for monetary inputs.
Variables: 3
4
Compute & Analyze
Range: · First year = Base Year (Index = 100)
Missing values are detected automatically and estimation options will appear.