Product Planning Workbook
You can use the Product Planning workbook to manage the backlog and development of user stories, determine the team velocity, and balance the workload across several iterations, also known as sprints. To plan an iteration, you review, rank, prioritize, and assign points to the stories that will be implemented for a project. To balance workload, you assign each story to a specific iteration and adjust these assignments until the number of story points that are assigned across all iterations are roughly equal.
Note
The Product Planning workbook is stored on the server that hosts SharePoint Products for your team project. If a project portal has not been enabled for your team project, you cannot access the workbook. For more information, see Access a Team Project Portal and Process Guidance.
Also, when you open the workbook for the first time, you must enable macros by clicking Options next to the Security Warning. To modify the contents, you must click Edit Workbook next to Server Workbook. For more information, see Workbooks (Agile).
If your team project was created before the release of Visual Studio Application Lifecycle Management (ALM), you must perform upgrade tasks so that you can use the Product Backlog workbook with your team project. For more information, see Adding Workbooks to Team Projects.
In this topic
|
Open the Product Planning workbook from the Shared Documents folder in Team Explorer: .png "Open the Product Backlog Workbook") |
Required Permissions
To create or modify user stories by using the workbook, you must be a member of the Contributors group or your View work items in this node and Edit work items in this node permissions must be set to Allow.
To add iterations or change the project structure, you must be a member of the Project Administrators group or your Create and order child nodes, Delete this node, and Edit this node permissions must be set to Allow.
For more information, see Team Foundation Server Permissions.
Managing the Product Backlog
You can use the Product Planning workbook to balance workload across several iterations. This workbook provides three worksheets as the following illustration shows and as described later in this topic.
.png "Product Backlog Worksheet")
Product Backlog: You use this worksheet to filter, rank, and prioritize the user stories that you want to manage. You can specify story points and assign user stories to iterations.
The Product Backlog worksheet references the Product Backlog team query, which finds all user stories that are defined for the team project. Within the workbook, you can filter the stories based on product area. In addition, you can perform the following actions:
Add User Stories to the Backlog
Reorder the List of User Stories
Iteration Planning: You use this worksheet to schedule the iterations, review the workload for each iteration, and determine how to balance the workload across the iterations.
Interruptions: You use this worksheet to specify holidays or other dates when the team will perform no work.
Ranking and Estimating User Stories
After you create the initial set of user stories in the backlog, the team estimates the size of each story, and then you rank them to determine the order in which the team will implement them. Typically, you start the process by ranking each story, the team then estimates the size of each story, and then you rank the stories again based on the team's story point estimates.
Story points measure the amount and complexity of the work that each story requires compared to all other stories in the backlog. Teams should try not to be overly precise with these estimates. They serve only to help identify appropriate tradeoffs when teams determine each story's rank, which indicates how important the story is compared to the other stories in the backlog. Teams can also specify a high, medium, or low level of risk for each user story to indicate a relative level of uncertainty about the story's requirements or design.
To rank and estimate user stories
In the Product Planning workbook, click the Product Backlog worksheet.
If you have opened a saved workbook, on the Team tab, in the Work Items group, click Refresh.
This step helps make sure that the list of user stories contains the most current information.
(Optional) To filter the list of stories based on product area, in the Area list, select the check box next to each product area that you want to include. To define additional area paths, see Defining Additional Iterations later in this topic.
Review the values for rank and story points for each user story, and update the fields in the following table as needed:
Field Name
Description
Stack Rank
A subjective rating of the user story compared to all other user stories in the backlog. A user story that is assigned a lower number should be implemented before a user story that is assigned a higher number.
Story Points
A subjective measure of the size and complexity of the user story. The team assigns story points by considering several factors and estimating how big a story is compared to other stories in the backlog.
Risk
A subjective rating of the relative uncertainty as to the successful completion of the user story. Teams can specify the following values:
1 - High
2 - Medium
3 - Low
On the Team tab, in the Work Items group, click Publish.
Note
You can use the undo feature in Excel to reverse recent changes that were made to work items before you publish the changes.
For more information, see Publish Work Items in Office Excel.
Click
.gif "Save")
.The workbook is saved to your team project portal site.
Planning the Iterations
Planning iterations is an iterative process in which you perform the following steps:
(Optional) Defining Additional Iterations
Scheduling Iterations
Accounting for Holidays and Planned Interruptions
Balancing the Workload Across Iterations
Defining Additional Iterations
Before you can assign user stories to iterations, you will want all the iterations to be defined for your team project. The following illustration shows the default iteration structure that is defined in the process template for MSF for Agile Software Development v5.0.
.png "Default agile iterations")
You can rename the iterations, add iterations, and change the tree hierarchy of the iterations.
You can modify the product area and iteration structure by using Team Web Access, Team Explorer, Office Excel, or Office Project. The following procedure describes how to add iterations from Office Excel. For more information, see Create and Modify Areas and Iterations.
To add iterations to your team project from Office Excel
In the Product Planning workbook, on the Team tab, in the Work Items group, click Edit Areas and Iterations.
The Areas and Iterations dialog box opens.
Click the Iteration tab, and perform one or both of the following steps:
To add an iteration, click the parent node, click the Add a child node button on the toolbar, type a name for the new iteration, and then press ENTER.
To promote a node, demote a node, or move a node up or down in the list, click the node, and then click the appropriate button on the toolbar.
Click Close.
Scheduling Iterations
To schedule the iterations, you add each iteration to the Iteration Planning worksheet and specify its start and end dates. This step provides the necessary data to balance the stories across the iterations.
To schedule the iterations
In the Product Planning workbook, click the Iterations worksheet.
(Optional) To filter the stories, click the
.gif "Down arrow")
down arrow in the cell next to Area, and then click the product area that you want to include.For each iteration in your planning, perform the following actions in the table area under Story Points per Iteration:
Click the cell under Iteration, click the
down arrow, and then click the iteration that you want to include.Click the cell under Start Date, and type the calendar date for the start of the iteration.
The date format should be month/day/year.
Click the cell under End Date, and type the calendar date for the end of the iteration.
The date format should be month/day/year.
Click the cell under Team Size, and type the number of team members who will work on the iteration.
The worksheet automatically calculates the following columns:
The Days column is calculated based on the start and end dates.
The Planned and Delivered columns are calculated from the Product Backlog worksheet. The story points for user stories that have been resolved or closed are counted as having been Delivered. Only those story points that are assigned to active user stories are counted as Planned.
As you complete each row for each iteration, a bar appears in the Velocity chart to indicate the story points that are assigned to each iteration.
Accounting for Holidays and Planned Interruptions
You use the Interruptions worksheet to specify days when the team will perform little or no work, such as holidays or team events. The number of days in each iteration is updated in the Iteration Planning worksheet to reflect these interruptions.
To account for holidays or planned work interruptions
In the Product Planning workbook, click the Interruptions worksheet.
Click the cell under Description, and type the name of the holiday or reason for the work interruption.
Click the cell under Date, and type the date for the holiday or work interruption.
Add as many dates to the worksheet that fall within the planned iterations.
Balancing the Workload Across Sprints
By assigning each story to an iteration, you add work to that iteration. Typically, the higher ranked stories are implemented first. However, to balance workload across multiple iterations, you might need to make iterative adjustments to the iteration assignments.
Initially, you might divide the number of stories to be implemented by the number of iterations that you have planned. This strategy can provide a baseline for starting your assignment of stories to iterations.
Before you balance the stories across the iterations, make sure that the following steps have been completed:
Each user story has been assigned story points. Also, a best practice is to have user stories of similar point size.
User stories have been ranked, and the Product Backlog worksheet is sorted by rank.
The iterations to be planned have been added to the Iterations worksheet.
Time off for the team has been accounted for on the Interruptions worksheet.
To balance the workload across iterations
In the Product Backlog worksheet, do a first pass of specifying the iteration for each story by clicking the
down arrow next to Iteration and then clicking the iteration.In the Iterations worksheet, view the story points that are assigned to each iteration. If the story points are not evenly distributed across the iterations, such as the following illustration shows, adjust the iteration assignment until the iterations are balanced.
.png "Story points not balanced across sprints")
Determine how many story points that you must move from one iteration to another.
Note
If the team size does not remain constant across iterations, you will want to factor these differences into your planning.
In the Product Backlog worksheet, change the iteration assignments until the number of story points is roughly even across all iterations.
The following illustration shows work that has been balanced across five iterations.
.png "Load balanced sprints")
Click
.The workbook is saved to your team project portal site.
Reviewing Team Velocity
Your team's velocity is the number of story points that it can complete in an iteration. After several iterations have been completed, you can review the team velocity by viewing the Iterations worksheet. As shown in the following illustration, the team velocity is 15 story points for Iteration 1 and 16 story points for Iteration 2.
By continuing to track story points across iterations, you can better forecast upcoming iterations. For more information, see Scrum.
Adding User Stories to the Product Backlog
You can define user stories by adding them to the Product Backlog workbook and publishing it to the database for tracking work item. Even when the project is underway, the team might continue to create, estimate, and rank user stories.
To add user stories to the database for tracking work items
In Office Excel, open the Product Planning workbook.
If you have opened a saved workbook, on the Team tab, in the Work Items group, click Refresh.
This step helps make sure that the list of user stories has the most current information.
For each story that you want to add, click the row at the bottom of the list, and specify the following information:
In Title, type an entry that identifies the customer as specifically as possible and describes the customer's goal at a high level.
For example, you could specify "As a <type of customer>, I want to <perform this operation>". For more information, see Creating a Great Product Backlog.
In the Work Item Type list, click User Story.
Note
Before you can publish a work item, you must specify the type of work item that you want to publish.
(Optional) To show additional Team Foundation fields in the list of work items, on the Team tab, in the Work Items group, click Choose Columns.
For more information, see Add or Remove Columns in a Work Item List.
Add information to the remaining fields as appropriate.
For more information about each field, see User Story (Agile).
(Optional) Save the workbook.
On the Team tab, in the Work Items group, click Publish.
Reordering the List of User Stories
You can reorder the user stories in the Product Planning workbook by using the Excel feature for sorting rows.
To reorder the list of user stories in the workbook
To reorder the user stories, perform one of the following actions:
Click the
down arrow next to Stack Rank, and then click the sort option that you want.Click the
down arrow next to Story Points, and then click the sort option that you want.
(Optional) Save the workbook.
Additional Resources for Managing the Product Backlog
For more information about how to modify user stories by using Office Excel, see the following topics:
See Also
Concepts
Creating a Great Product Backlog