Bas Vodde collected and published examples and templates of the Scrum product and Sprint backlogs. Most of them are in MS Excel format. Some (XLS) include a lot of comments, some (XLS) are very colourful. Check them out, Excel can really cover most of the needs of the archived backlog tracking.
Cached templates
Here are the cached copies of templates that I reviewed on this website.
See Also
| Attachment | Size |
|---|---|
| ph_product_sprint_backlog_0.03.xls | 176.5 KB |
Comments
It would be great to explain the backlogs examples
February 25, 2008 by joao (not verified), 1 year 18 weeks ago
Comment id: 1458
It would be nice if we can have a drill down in these backlogs explaining each of its components.
Thanks for the examples
A good idea. Though not sure
February 25, 2008 by Artem, 1 year 18 weeks ago
Comment id: 1459
A good idea. Though not sure if I am able to understand these templates - I personally use different excels. Maybe I will find time to dig through these examples and create some screencast on using them. Or maybe somebody else could do it :)
the idea of having some
February 25, 2008 by joao (not verified), 1 year 18 weeks ago
Comment id: 1461
the idea of having some screencasts of using them would be already a great great help.
keep us informed
And exactly two months
April 25, 2008 by Artem, 1 year 9 weeks ago
Comment id: 1521
And exactly two months later, here is the first video tutorial! :)
Let's see what the comments will say. If the people like the tutorial, I will probably shoot more screencasts for different templates.
Product Backlogs: List of
June 17, 2008 by phani (not verified), 1 year 2 weeks ago
Comment id: 1588
Product Backlogs: List of desired functionality in the system.
Team Commits to getting "X" number of items from the Product Backlogs done in 30 days .
This 30 days is called Sprint Backlog.
Sprint Backlog:List of items that must be done to turn the Product Backlog into shippable items during the Sprint
Spreadsheet column acronyms: what do they mean?
August 1, 2008 by ric (not verified), 48 weeks 15 hours ago
Comment id: 1736
In the Product Backlog (c_backlog.xls) there are a few columns whose titles are specified by acronyms such as MR, Pri, 50%, 90% and (90%-50%)^2.
Does anybody know the acronyms’ meanings? What are they supposed to tell you?
Thanks you so much in advance
Ric
Advanced Excel template
November 12, 2008 by tsj123 (not verified), 33 weeks 3 days ago
Comment id: 1985
Hi ,
I tried clicking the "Scrum backlog templates and examples" , but unable to find the advanced excel file.
Is there a link where I can download the advanced product and sprint backlog excel templates?
Regards
Uploaded
November 12, 2008 by Artem, 33 weeks 2 days ago
Comment id: 1986
Oups, it looks like file was missing on the server for some strange reason.
Anyway, I uploaded it again and you can download the template from the "ph_product_sprint_backlog_0.03.xls" link in the post.
Thank you for noticing the problem, tsj123.
on acronyms meaning
February 18, 2009 by xasima (not verified), 19 weeks 2 days ago
Comment id: 2254
Please follow the link http://osdir.com/ml/programming.scrum.general/2003-11/msg00075.html
Extract from that place
The columns are estimates in days of six items on the product backlog. The first column is the 90% confident estimate, the next is the 50% estimate, the final is the squared difference of the two.
.....
Sum the squared differences and get 51. Take the square root of that and get
about 7. The seven is the project buffer. Add that to the sum of the 50%
estimates (16) and get 23. So, to buffer this project to a 90% level of
confidence you should plan on 23 days, not the 16 that is the sum of the 50%
estimates or the 31 that is the sum of the 90% estimates. Naturally this
doesn't add a lot of value when there are only this many tasks.
on acronyms meaning
February 18, 2009 by xasima (not verified), 19 weeks 2 days ago
Comment id: 2256
Pri means Priority,
MR means MiniRelease (it's the same for all rows in the same mini release in the sheet)
The video tutorial posted few
February 28, 2009 by Zoran (not verified), 18 weeks 2 hours ago
Comment id: 2306
The video tutorial posted few posts above were excellent!


Templates and Video
March 1, 2009 by Jude Pachamuthu (not verified), 17 weeks 5 days ago
Comment id: 2313
The videos and templates posted are excellent. Thanks for the effort and work done.
Keep up the good work.
rgds
Jude
Change colors
March 18, 2009 by Dave Marble (not verified), 15 weeks 2 days ago
Comment id: 2390
I'm trying to figure out how I can change the default colors that appear when the task status is updated to Ongoing or Done. Can you point me in the right direction? I don't see any VBA code or formulas that I can tweak.
Post new comment