Table of Contents

How Should We Initially Track Multiple Team's Progress?

Sometimes you kick off a couple of teams at the same time, and want to see how the team's are doing over time. I've found this spreadsheet will help in those situations.

Sample Output

The spreadsheet shows a team by team view with a chart showing committed versus actual velocity over time, including an “acceptable range” band:

The idea is that you don't want the team to always hit the commitment (that just leads to “sand-bagging”) but rather want to encourage teams to take risks and not feel too bad when it doesn't work out, but also isn't way off. I've used plus / minus 16% as the acceptable range (based on reading) and found that to work well.

Its also shows velocity trend over time:

In addition the spreadsheet shows:

Files

Planned (committed) vs Actual Velocity.xlsx