Burndown Chart Calculator
Generate sprint burndown charts with ideal vs actual lines, velocity tracking, scope creep detection, and PNG/CSV export for Agile teams.
About
A burndown chart plots W (remaining work) against t (elapsed time) to expose the gap between plan and reality. The ideal line assumes constant velocity: Wideal = S ร (1 โ t รท T), where S is total scope and T is sprint length. When the actual line drifts above ideal, the team is behind. When remaining work increases between days, scope creep has occurred. Misreading this chart costs sprints: teams commit to the next iteration based on flawed velocity data, compounding estimation error across the release plan.
This calculator generates a publication-ready burndown from raw daily data. It computes average velocity, detects scope additions, and projects a completion day if the sprint is at risk. The projection assumes current average velocity holds constant. That assumption breaks down when teams hit integration phases or holidays. Account for those manually. The tool approximates effort distribution as uniform across working days. Non-uniform distributions (e.g., front-loaded testing) will show as deceptive early progress followed by plateau.
Formulas
The ideal burndown is a linear function from total scope to zero over the sprint duration:
The actual remaining work on day d is computed cumulatively:
where ci is points completed (or added, if negative) on day i. Average velocity after d elapsed days:
Projected completion day (if behind schedule):
Where S = total story points (scope), T = sprint length in days, d = current day index, ci = points completed on day i (negative value indicates scope addition), vavg = average velocity in points per day, tproj = projected day of completion. Scope creep is detected when Wactual(d) > Wactual(d โ 1).
Reference Data
| Metric | Formula / Definition | Healthy Range | Warning Sign |
|---|---|---|---|
| Sprint Velocity | v = Scompleted รท T | 80% - 110% of planned | < 70% or > 130% |
| Scope Creep | Days where Wd > Wdโ1 | 0 - 1 occurrences | โฅ 3 occurrences per sprint |
| Burndown Slope | ฮWฮt | Matches or exceeds ideal slope | Flattening in final 30% of sprint |
| Points Remaining at End | WT | 0 | > 10% of S |
| Projected Completion Day | tproj = tnow + Wnowvavg | โค T | > T (sprint will overrun) |
| Focus Factor | VelocityTeam Capacity | 0.6 - 0.8 | < 0.5 |
| Standard Sprint Length | Scrum Guide recommendation | 5 - 10 working days | > 20 days (not a sprint) |
| Ideal Daily Burn Rate | S รท T | Consistent day-over-day | Zero-burn days mid-sprint |
| Effort Variance | stdev(daily burned) | Low variance | High variance signals blocking |
| Commitment Reliability | Sprints completed on timeTotal sprints | โฅ 0.8 | < 0.6 |
| Typical Team Velocity | 20 - 40 SP/sprint (5-person team) | Stable over 3+ sprints | Varies > 30% sprint-to-sprint |
| Plateau Detection | 2+ consecutive days with 0 burn | No plateaus | Indicates blockers or dependencies |