Inputs
Example Data Table
Sample weekly tracking rows you can mirror in your team sheet.
| Week | Target (Units) | Actual (Units) | Quality factor | Attainment (%) |
|---|---|---|---|---|
| Week 1 | 25 | 18 | 0.95 | 68.40 |
| Week 2 | 25 | 22 | 1.00 | 88.00 |
| Week 3 | 25 | 27 | 1.05 | 113.40 |
| Week 4 | 25 | 23 | 0.98 | 90.16 |
Formula Used
- Raw attainment (%): (Actual ÷ Target) × 100
- Capped attainment (%): min(Raw attainment, Cap) (Cap is optional)
- Quality-adjusted (%): Capped attainment × Quality factor
- Weighted attainment (%): Quality-adjusted × (Weight ÷ 100)
- Projected end actual: (Actual ÷ Days elapsed) × Period days
- Required daily to hit target: (Target − Actual) ÷ (Period days − Days elapsed) (when remaining days > 0)
How to Use This Calculator
- Enter your period target and the actual progress so far.
- Set total period days and how many days have elapsed.
- Optionally adjust quality, apply a weight, or cap attainment.
- Click Calculate to see results above the form.
- Use projected attainment to judge pacing and risk.
- Download CSV or PDF to share with stakeholders.