Friday, January 20, 2012

Doing Scrum in Microsoft Project 2010

Two year ago, I was involved in a project for a luxury company, and previous project manager used Scrum to manage it and the deliveries. After a quick introduction of this methodology, we used his tools (mainly Excel) to implement Scrum.
Today I would like to reuse Scrum in another project, but I wanted to see if it’s possible to use Microsoft Project instead of Excel to manage Scrum artifacts as Product backlog, Sprint Backlog and Burn down chart.
Note that this article will not explain the methodology; you can check this article in Wikipedia or watch this interesting video by Hamid Shojaee for a quick course on Scrum.

Step 1: Create Product backlog
Looking at Wikipedia article I read: “The product backlog is a high-level list (of features)”. This is basically what Microsoft Project does with tasks list. Then “The product backlog contains rough estimates of both business value and development effort”. This can be achieved by adding some custom fields and display existing ones.
·         Task Name
·         Description (will be done in the task note)
·         Sprint (Custom text or number, must be a lookup), see below how to create a lookup.
·         Points (using for example Fibonacci sequence) (Custom number or list), note that “Priority” as field name is already used
·         Baseline work
·         Actual Work
·         % Complete
·         Work
·         Duration
·         Start and finish date
·         Resource Names

Here is how to create a lookup field:

This is an example of a project file I made:

As you can see, on note mouse over, I see the task description (note). We can also add this field as a column to display it in the table.

Step 2: Sprint backlog
To display stories based on sprint, I just create a custom Group by (Group by Sprint). This will be my sprint(s) backlog.

Step 3: Burn down chart
Now it’s time to create the burn down chart. First of all I will input some actuals in my planning and update it. Note that the status date has been set to 16/01/2012 (I am a little bit ahead of schedule). Then click on Visual Reports.

Click on new template, select Excel application and Assignment usage as Data Type. You also need to add to your report custom fields you have created. Click on Field Picker and select the Sprint (Text 2) field; this can be used to filter data. Let’s use days as Level of usage data to include in the report (Note you can use weeks or any other time frame).

Important note: To be exported as a dimension, the custom field should be a lookup. This is why we have defined Sprint custom field as a lookup.

Create your pivot table in Excel as follow:

Now you need to create additional columns to make calculation of:
·         Cumulative Baseline: Cumulative of Baseline Work
·         Cumulative Actual: Cumulative of Actual work
·         Remaining Planned = Baseline Work Grand total – Cumulative baseline
·         Remaining Actual = Baseline Work Grand total – Cumulative actual
·         Copy also day number on the first column

This will be used to draw you burn down chart. Select the first 3 columns and insert a 2D line chart.

You have now your burn down chart. Yellow tag when remaining work is not moving is simply week ends. As you can see at the end of the graph, on Jan 16th we are ahead of schedule.

NOTE that of course this report can be saved as a template for future use. When saving your file, you will be prompted for that.

Alternative solution
Some people may say, “Wow it’s too complex for me, do you have any easier solution?”
There is always a simpler solution for lazy project managersJ. You can download the Microsoft Project 2010 Scrum Solution Starter. You can download this free package (under MICROSOFT PUBLIC LICENSE) on MSDN website.
The pitch given on this page is:
Microsoft Project 2010 Scrum Solution Starter is designed to provide guidance on using the Microsoft Project 2010 to manage Scrum projects, aiming to help individual Scrum teams to start using Project to:
·         Manage Product backlog
·         Manage Scrum backlog
·         Track progress and generate Burn down charts

You can check the overview document under download section for a quick “how to guide”.
I did not use it yet in a real project, but will try and will not miss to write on my experience.

10 commentaires:

arumugam said...

just linked this article on my facebook account. it’s a very interesting article for all.

Scrum Courses- cPrime

Jeremy Cottino said...

Thanks Arumugam for your message, really appreciated

Pankaj Goswami said...

This is really great article and very well explained.

Jeremy Cottino said...

Many thanks Pankaj, do not hesitate to share it

Juergen Bruns said...

Thanks Jeremy, that is what I was looking for. The MS Project Scrum Solution starter set does not work (yet). Bets regards from Germany
Juergen Bruns

Jeremy Cottino said...

Hi Juergen,
Thanks for the comment, do not hesitate to share this post with your contacts

Bobby Saeidi said...

You can also create burndownchart with a tool called projectsimple can be downloaded from or

Jeremy Cottino said...

Thanks Bobby for this information. Less than 25$ i think this is something maybe users should try.

Payal said...

Hey thanks for the post its good idea to use scrum training methodlogy in microsoft project.

christyjames said...

Your posts are good and so informative. Microsoft Office Word and Excel have their own distinct advantages.
Business templates | Excel templates

Post a Comment