Skip to content

Scrum backlog templates and examples

November 6, 2006 by Artem Marchenko

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

AttachmentSize
ph_product_sprint_backlog_0.03.xls176.5 KB

About the Author: As the Editor-in-Chief for AgileSoftwareDevelopment.com, Artem is charged with overseeing the direction for content, advertising, and the overall management of the site. Nowadays in his day life, Artem is a product manager in a global telecommunication company where he leads the development of a product developed in extremely distributed environment. Artem has been applying Agile and researching Agile since 2005. Contact Artem

Comments

It would be great to explain the backlogs examples

February 25, 2008 by joao (not verified), 6 years 35 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, 6 years 35 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), 6 years 35 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, 6 years 27 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), 6 years 19 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), 6 years 13 weeks 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), 5 years 50 weeks 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, 5 years 50 weeks 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), 5 years 36 weeks 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), 5 years 36 weeks 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), 5 years 35 weeks ago
Comment id: 2306

The video tutorial posted few posts above were excellent! online roulettebootleg moviespoker sites

Templates and Video

March 1, 2009 by Jude Pachamuthu (not verified), 5 years 34 weeks 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), 5 years 32 weeks 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.

Petri Heiramo's advanced template - about excels definition

August 25, 2009 by mregazzi (not verified), 5 years 9 weeks ago
Comment id: 3075

I'm not an Excel expert..... maybe there are others.

If you want to order a product backlog with more than 127 rows you need to redefine some names because the macro uses them.
"ProductBacklog" (I found it in the main menù -> insert - names - define).
It was defined as:
='Product Backlog'!$A$4:$G$127
and redefined as:
='Product Backlog'!$A$4:$G$1024
And so on with
"StoryName": redefined as ='Product Backlog'!$B$5:$B$1024
"Status": redefined as ='Product Backlog'!$C$5:$C$1024
"Sprint": redefined as ='Product Backlog'!$E$5:$E$1024

Apply the same to the Sort Sprint Task macro as it uses "SprintTasks", "TaskStoryID") and "TaskStatus".

Simply apply the same cell

August 25, 2009 by mregazzi (not verified), 5 years 9 weeks ago
Comment id: 3076

Simply apply the same cell format to all the rows.

Ok. Thanks for the examples.

September 24, 2009 by Anonymous (not verified), 5 years 5 weeks ago
Comment id: 3560

Ok. Thanks for the examples.

Product and Sprint Backlog: I think thy must be lowly coupled

November 8, 2009 by mregazzi (not verified), 4 years 51 weeks ago
Comment id: 4055

I'm using the Petri Heiramo advanced sheet since july 2009. I also added some macros that help me going on with iteration and synchronizing product backlog to sprint backlog and generating new sprint. Now I wonder that product backlog is owned by the product owner, and he put there just "business cases". When the team explode them in task, probably it means that I'm going to put the tasks in the sprint backlog. So I would like to decouple the product backlog and the sprint backlog, but I also would like to create a hierarchy so I have two item's level in the sprint backlog: a story development would be completed only when all the related tasks are completed, then the product backlog may be synchronized.
Otherwise, like I'm operating today, I must add tasks to the product backlog or just remember the relationships between a task (sprint) and a story (product). But tasks are not owned by the PO and a relationship should be defined into the sheet.

What do you think about ?

Thank you
Matteo

Coupled only within a Sprint

November 9, 2009 by Petri Heiramo (not verified), 4 years 51 weeks ago
Comment id: 4071

Hi Matteo,

> Now I wonder that product backlog is owned by the product owner, and
> he put there just "business cases". When the team explode them in task,
> probably it means that I'm going to put the tasks in the sprint backlog.

In your team, is this activity of task planning done in advance to a sprint starting?

> So I would like to decouple the product backlog and the sprint backlog,
> but I also would like to create a hierarchy so I have two item's level in the
> sprint backlog: a story development would be completed only when all
> the related tasks are completed, then the product backlog may be synchronized.

I personally think this is overcomplexifying the issue. Of course, I don't know this particular case, but I don't see the great benefit from this activity being done within the Product Backlog and Sprint Backlog. Firstly, I wouldn't go into task level (apart from discussions related to estimating the size and effort) until the beginning of an iteration where the story is being made, and then track the tasks on a wall board or some other similar mechanic. This would mean that the Product Backlog would ever only have business stories and that the Sprint Backlog is emptied between iterations. Thus I wouldn't have the problem you're describing.

In fact, I don't even have an Excel based Sprint Backlog anymore in the latest version of the template. :)

Hope that helps, Petri

Updated template

November 13, 2009 by Petri Heiramo (not verified), 4 years 50 weeks ago
Comment id: 4095

Hi,

I sent the latest (public) version of the Product Backlog template to Artem and maybe he will find the time to publish it :).

There are some key changes to the version that has been here.

  • It no longer has a burndown, but burn-up. I personally just prefer that for its visual appearance and ability to better visualize different feature priorities in it. Because of that, it currently requires that the "MoSCoW" column in the backlog sheet must have some value in it or the diagram doesn't work (it could simply be "Must" for every story).
  • I dropped the sprint burndown completely. I don't see any value for it anymore in that Excel. If the team is small and colocated, I'd always prefer a physical team wall and a hand-drawn burndown. If the team is large or not colocated, well, an Excel just doesn't make sense to me as a tool.

If you like this version, feel free to use it.

Yours Sincerely, Petri

Re: Coupled only within a Sprint

November 18, 2009 by mregazzi (not verified), 4 years 49 weeks ago
Comment id: 4104

Hi Petri,

so there are now three sheets: the original one (that I'm recommending everywhere), the new one that you recently added (I didn't see it yet, but let me download it), and finally the original with some enhancement.
I really appreciated you comment and I understood that I was wrong: so the enhancements are just in the way of simplifying the management of all these sheets such as the automatic creation of a new sprint sheet, the synchronization of the sprint backlog to the product backlog, some different type of ordering. The most debated one was the synchronization: now I presume the Product backlog contains only business level stories (each one with a unique story ID) while the Sprint backlog contains tasks where more tasks can be related to a single story (same story ID). So the status of the item on the product backlog depends on the status of every task related. Yes, it is probably useless, but it's dramatically different to the intermediate version where I copy every task from the sprint backlog to the product backlog. While may be it was a VBA exercise, it was a big step towards the comprehension of Scrum philosophy.

Thank you again!

Matteo

great

February 6, 2012 by Lilia Smit (not verified), 2 years 38 weeks ago
Comment id: 20897

I think it's great. Thanks for useful information. Good luck!
New Online Slots

Hi. just getting my head

March 2, 2012 by NOnn (not verified), 2 years 34 weeks ago
Comment id: 21102

Hi. just getting my head around Agile DB development. I am sure your example above is given as a simple example but surely you would have to be really dumb to create a field called Person_Name in the first place. This may appear to be an obnoxious comment. but all the examples I see around Agile refactoring are for refactoring really stupid mistakes. eg breaking 1NF as in this case. It seems from what I have read that the Agile method uses refactoring to solve problems caused by really bad data modelling. whereas Agile should be used to avoid these errors in the first place. sosh forfait sans engagement forfait illimite forfait sms illimite forfait mobile internet comparateur forfait bloque rio orange rio orange rio sfr rio bouygues rio virgin calcul imc portabilite du numero

So informative things are

March 21, 2012 by Anonymous456 (not verified), 2 years 32 weeks ago
Comment id: 21443

So informative things are provided here,I really happy to read this post,I was just imagine about it and you provided me the correct information I really bookmark it,for further reading,So thanks for sharing the information.
Sale h13 Tool Steel

it fine.

May 21, 2012 by Johan android. (not verified), 2 years 23 weeks ago
Comment id: 22245

I thank you for taking your time sharing your thoughts and ideas to a
lot of readers out there. cheat black ops 2

nice one

May 21, 2012 by Angela (not verified), 2 years 23 weeks ago
Comment id: 22253

Nicely explained. It's indeed an art to stop new visitors with your attractive writing style. Truly impressive and nice information. Thanks for sharing. Book of ra

fine site.

May 23, 2012 by Jajdish sha. (not verified), 2 years 23 weeks ago
Comment id: 22443

It is important to choose right one since the first time. Thank you for the tips. Gorras Planas

Nice

May 25, 2012 by rodger (not verified), 2 years 22 weeks ago
Comment id: 22527

Very nice, I found the template, pretty useful.

Movies For Download

I am very happy to discover

May 26, 2012 by Anonymous (not verified), 2 years 22 weeks ago
Comment id: 22558

I am very happy to discover your post as it will become on top in my collection of favorite blogs to visit. HackingEge.com

I am hoping the same best

May 28, 2012 by Anonymous (not verified), 2 years 22 weeks ago
Comment id: 22605

I am hoping the same best effort from you in the future as well. In fact your creative writing skills has inspired me. Merissa Raygosa

It proved to be Very helpful

May 30, 2012 by Anonymous (not verified), 2 years 22 weeks ago
Comment id: 22655

It proved to be Very helpful to me and I am sure to all the commentators here!
fastest paday loans

This was one of the most well

June 23, 2012 by Anonymous (not verified), 2 years 18 weeks ago
Comment id: 23009

This was one of the most well documented blog entries I have read in a long time. It was a pleasure to fill all the gaps I had about this topic. Well written an concise.get a loan

Thanks so much for sharing

June 25, 2012 by Anonymous (not verified), 2 years 18 weeks ago
Comment id: 23042

Thanks so much for sharing this awesome info! I am looking forward to see more postsby you! Help at Cap Credit

Northwest Austin Homes

June 28, 2012 by Northwest Austin Homes (not verified), 2 years 17 weeks ago
Comment id: 23095

Thank you for providing such a valuable information and thanks for sharing this matter.........
FinanceNorthwest Austin Homes

Lionel Andrés Messi is an

July 1, 2012 by jafyesor (not verified), 2 years 17 weeks ago
Comment id: 23155

Lionel Andrés Messi is an Argentinian contestant who currently plays for Municipality and the Argentinian arc set. Sapient one of the lettered expiry players of his elegance.

dofollow blog finder

Very interesting comments all

July 2, 2012 by Anonymous (not verified), 2 years 17 weeks ago
Comment id: 23190

Very interesting comments all users visiting friends, who contribute with their views on this post. get a loan

Viselike this tamed of method

July 3, 2012 by jafyesor (not verified), 2 years 17 weeks ago
Comment id: 23198

Viselike this tamed of method is echt commonwealth apt for, salutary fit for readers and a creator for you as get definitely shew the decorativeness of the communicator. It's subscription to bonk these kinds of articles around to taciturnity the run cerebrate nonviolence. Conveying those who o.k. can playacting things overripe in the venerable add!
bulk links checker

I could see the croupier, in

July 4, 2012 by Anonymous (not verified), 2 years 17 weeks ago
Comment id: 23202

I could see the croupier, in a sort of vestibule which opened out of it, eating his supper in solitude.If any one inquires for me, tell them that I am gone to the Ascoli Palace.I could see the croupier, in a sort of vestibule which opened out of it, eating his supper in solitude.If any one inquires for me, tell them that I am gone to the Ascoli Palace.

Francois shuddered as he

July 4, 2012 by Anonymous (not verified), 2 years 17 weeks ago
Comment id: 23203

Francois shuddered as he looked, and moved away hastily from the bed.That action and louis vuitton outlet the hints which preceded it seemed to bewilder the little man more than ever.Frank, or No? loan
bad credit loans

thanks

July 5, 2012 by العاب تلبيس (not verified), 2 years 16 weeks ago
Comment id: 23220

Greetings! This is my first visit to your blog! We are a collection of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a wonderful job!

Very useful post. This is my

July 8, 2012 by Anonymous (not verified), 2 years 16 weeks ago
Comment id: 23269

Very useful post. This is my first time i visit here. I found so many interesting stuff in your blog especially its discussion. Really its great article. Keep it up.
funny videos

jackmason

July 16, 2012 by jackmason (not verified), 2 years 15 weeks ago
Comment id: 23376

The nation's governors well, many of them, anyway are gathering in Colonial Williamsburg, Va., for their annual summer meeting this weekend.company registration

http://www.viviennetwestwooduk.com

July 31, 2012 by Vivienne Westwood (not verified), 2 years 13 weeks ago
Comment id: 23593

Saw your Blog bookmarked on Reddit.I really enjoy your blog and marketing tactic. Investigate out my Farmville Guidebook in the event you get a moment.

Vivienne shoes
Vivienne Westwood bracelet
Vivienne Westwood brooches
Vivienne Westwood Cufflinks
Vivienne Westwood earrings
Vivienne Westwood necklaces
Vivienne Westwood rings
Vivienne Westwood polo
Vivienne Westwood shirts
Vivienne Westwood t shirt

rock

August 1, 2012 by SMS steel recycling (not verified), 2 years 13 weeks ago
Comment id: 23606

same niche. Your blog provided us useful information to work on. You have done a wonderful job!

Awesome

September 17, 2012 by karan singh (not verified), 2 years 6 weeks ago
Comment id: 23902

This site is excellent and so is how the subject matter was explained. I also like some of the comments too. Looking forward to your next post. SBObet Casino

Very cool article

September 18, 2012 by Claudia Swift (not verified), 2 years 6 weeks ago
Comment id: 23911

This was a great article. I have enjoyed this and I have learned so much here also. I really do appreciate this great information.
buy youtube views

wow

September 28, 2012 by fiance visa (not verified), 2 years 4 weeks ago
Comment id: 24113

It is really nice to hear your discussion on specific topic here. I too agree with your points here. keep posting good blogs. Thanks.

I found this interesting i

October 3, 2012 by Virath Kohali (not verified), 2 years 4 weeks ago
Comment id: 24175

I found this interesting i like the small idea. i also liked the presentation of this site. it was nice, i enjoyed reading this paragraph. Ambleside

"The instinct of nearly all

November 10, 2012 by Anonymous (not verified), 1 year 50 weeks ago
Comment id: 24562

"The instinct of nearly all societies is to lock up anybody who is truly free. First, society begins by trying to beat you up. If this fails, they try to poison you. If this fails too, they finish by loading honors on your head." "There are people in the world so hungry, that God cannot appear to them except in the form of bread."

wedding outfits

Greetings! This is my first

December 11, 2012 by james caan (not verified), 1 year 46 weeks ago
Comment id: 25070

Greetings! This is my first visit to your blog! We are a collection of volunteers and starting a new project in a community in the same niche. Your blog provided us useful information to work on. You have done a wonderful job!

learning center

Really impressed! Everything

December 12, 2012 by Aisin (not verified), 1 year 46 weeks ago
Comment id: 25119

Really impressed! Everything is very, very clear, open is a description of the problem. It contains the information.iwc watches\\Rolex watches

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <b> <i> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <br> <blockquote>
  • Lines and paragraphs break automatically.
  • Web page addresses and e-mail addresses turn into links automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>. Beside the tag style "<foo>" it is also possible to use "[foo]".

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.

Best of AgileSoftwareDevelopment.com