Scrum backlog templates and examples

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

Pri means Priority,
MR means MiniRelease (it's the same for all rows in the same mini release in the sheet)

The videos and templates posted are excellent. Thanks for the effort and work done.

Keep up the good work.

rgds
Jude

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".

Ok. Thanks for the examples.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

"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

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