Sprint Planning Tool¶
This tool consists of a Google Sheets file, and accompanying Google Scripts. The sheets involved are:
- Sprint planning
- Issue overview
- Group tags
- Time estimations
- Milestones
Purpose¶
This tool is meant to assist the Process group during the Sprint Planning event. The tool generates Sprint planning cross groups, and assigns them the issues labeled with the current Sprint milestone and time estimation needed. In the Issue overview sheet, time estimations of an issue can be set and which group is assigned each issue can be set.
Setup¶
The tool needs to be setup with data about the current GIRAF team in order to function.
The Sprint planning sheet must contain the number of groups that should be made for the event, and which milestone is used for the current sprint.
The Group tags sheet must be updated with the current GIRAF teams group tags.
The Milestones sheet must be updated with the current set of milestones used in GitHub.
The Google Script can be found at Tools>Script Editor in the menus bar.
In the API.gs file found with the script editor, the ACCESS_TOKEN needs to be updated with a GitHub
access token from one of the team members.
An access token can be generated here.
Usage¶
As preparation to the Sprint Planning event the Generate button under the Sprint planning sheet should be pressed in order to generate Sprint planning cross groups.
After an issue has been time estimated its time estimation can be set in the Issues overview. When all issues have been time estimated the Set time estimations button should be pressed, in order to set the corresponding time estimation tags on GitHub.
The Issues overview sheet can also be used in order to assign the different issues to the Development teams on GitHub by pressing the Set group tags.