In my previous post I talked about the Excel workbooks in combination with the MS Scrum template. Excel is a great help in quickly organizing and editing your work items.
It is however kind of hard to see a good status overview of your work in the current sprint.
Main problem is, that Parent Items (Product Backlog Items) are not automatically set to Done when the child tasks are done. Because of the colors in the excel list this is also very hard to see.
As you can see, the colors directly attend you on which PBI’s are not yet ready and which PBI’s can be set to done. All underlying tasks are either red, yellow or green, depending on their state.
Jasper was so kind to make this fully configurable as well and create a xlsm template which you can easily use. This template is attached to the post.
In order to use the sheet, you need to follow some additional steps.
First create a query in Team Explorer that define the required columns. Call this Color Progress (or something like that)
Make sure you include at least the columns:
- Work Item Type
- Title 1 (PBI title)
- Title 2 (Task title)
- Assigned To
- Remaining Work
After that you open the Excel sheet and link the sheet to the query
- Go to the Team Tab on the Ribbon
- Set your cursor on the A1 cell in the Work Item Progress sheet
- Press “New List”
- Select you Color Progress Query
- Click OK
The data will now be retrieved from TFS
If you want to change the colors, or if you are using a different template and thus other state names and work item types, you can use the Settings sheet to modify this.
This is really great and helpful!
Thanks Jasper Gilhuis, for your great work !