UPDATE 02nd September 2010: 950 downloads. Preview the burndown and burnup as html here: http://blog.omaconsulting.no/BurnDown/burndown.htm Please provide feedback! END UPDATE
I’m proud to say that there have been over 400 downloads of the burndown and burnup graph excel sheet I published about a year ago. I didn’t clean up nor explain much, just threw it out there. Download the (unmodified) excel sheet here: http://blog.omaconsulting.no/BurnDown/burndown.xls
Here is the post I publish about a year ago 18th June 2008 https://olemortenamundsen.wordpress.com/2008/06/18/sharing-my-burndown-and-burnup-excel-sheet/
What disappoints me, is that I have received no feedback. NO FEEDBACK!? Why not?
It contained a lot of experimental numbers and formulas, I would guess somebody thought they were strange. I’m sure many of you improved it and tried out. Maybe it’s been mostly managers downloading it, I have feeling this group tend to like being shared stuff, than sharing themselves. Too presumptuous? OK, I’ll watch my step :) I’d like feedback, though. I wish to learn from your experiences, good and bad.
The short story: Struggling to find any nice and simple burndown graphs to help me in a project, I created one myself (late 2007). I started out simple, with a burndown graph on A3 paper, then a simple excel sheet. Then it grew in a on-demand manner, truly agile. A friend liked burnup graphs and I discovered that these were really good at presenting the daily delivery speed, while the burndown was better at illustrating remaining work, scope creep up and chance of success (hitting zero at sprint end). Of course, I started using both! Further combining a story point burnup in the (task-) burndown graph proved to be most valuable the times we scoped out user stories during the sprint. The scope down was greatly illustrating that fact that we thus delivered less business value (story points).
Along the way, I experimented a lot with numbers and formulas, mostly related to the burndown factor. The objective was to be able to deliver consistently, always committing to the most we could and always delivering what we committed ourselves to. Predictability is valuable to analyse the progress and the likelihood of reaching your deadline half a year, or a year, away. Do you have to modify your triangle? Scope, Resources, Time?
Good luck and thank you for sharing!