Question

Is there a way to crate a burndown chart that a "rolling" burndown chart in excel?
How would you create one?

Answer 1

.

CRUM is a great way to manage all sorts of tasks including sprints, but you don’t have to purchase expensive software packages to burn one. Excel is a great tool for rolling your own sprint burn down graph or you can just take mine. In this article, I’ll walk you through a burn down spreadsheet I created, show you how to modify it and at the end you can download it for yourself and kick the tires.

There are many examples of how to create simple-burn down charts in Excel but

1. They usually have a straight line for estimated progress, when this isn’t realistic. Sprint progress is never a straight, linear process so measuring against this will give a distorted picture of whether the sprint is ahead or behind schedule until the last day. The planned/estimated/projected line will usually accelerate and decelerate at certain points in the sprint so the estimated progress line should to.
2. They require a lot of tedious booking of hours, units etc
3. They aren’t flexible enough to easily add tasks, remove them

My goals in create this were …

• to make something simple, yet sophisticated enough to handle sprints with a reasonably large number of PBIs with varying weights, in terms of effort or value.
• to make it easy enough to use so that all you have to do is enter in some data in red colored cells (aka inputs)
• to make updating the sheet as simply as indicate the day a particular task was completed and nothing else
• to be robust enough to not throw errors unless outside of most normal usage scenarios
• to abstract the user from complexity, noise and just present inputs and outputs, as much as possible

Burndown graph Task completion log Completed tasks Task completion (%) Building Rome in 30 days Projected Actual Projected Actual Task ID Task ID Date 100% 2/16/2013 100% 100% 2/17/2013 94% 100.0% 90% 2/18/2013 94% 88 % 2 2/19/2013 2/20/2013 88% 80% 2/21/2013 82% 2/22/2013 82% 2/23/2013 70% л 72% 2/24/2013 72% 2/25/2013 67% 60% 2/26/2013 67% 2/27/2013 52% 2/28/2013 52% 50% 3/1/2013 37% 3/2/2013 37% 40% 8 3/3/2013 22% 3/4/2013 22% 3/5/2013 20% 30% 3/6/2013 20% 3/7/2013 10 15% 20% 3/8/2013 15% 3/9/2013 11 14 % 14 % 3/10/2013 10% 3/11/2013 12 8% 3/12/2013 иа 3/13/2013 13 0 % 2/28/2013 3/3/2013 2/16/2013 2/19/2013 2/22/2013 2/25/2013 3/6/2013 3/9/2013 3/12/2013 3/15/2013 236 14 3/14/2013 3/15/2013 % ..Projected Actual 15 3/16/2013

1. Step 1 – Create Estimate Effort. Suppose your ideal baseline for using the available hours over the sprint. ...
2. Step 2 – Track Daily Process. The daily progress is then captured in the table against each task. ...
3. Step 3 – Compute the Actual Effort. ...
4. Step 4 – Obtain the Final Dataset. ...
5. Step 5 – Plot the Burndown using the Dataset.