Scrum Team Bundle – 3

Excel Template Bundle 3

Combination of Four Template with a Bundled price

1. Capacity & Sprint Planning :

This Scrum Team Bundle – 3 – Template is prepared for planning your scrum team capacity and optimizing your commitment during Sprint Planning. This Scrum Team Bundle – 3 is designed for the scrum team, who estimate their capacity in hours, and during sprint planning distribute the story into small subtasks and assign them to team members and validate the team member’s allocation and estimation is in sync with their capacity.

There are 5 Sheets to capture the information. You will get the details of the sheet from the Details tab. below mentioned the list of Tabs you will,

Definition
Analytics
Capacity
Sprint Planning
Estimation Accuracy

You will 6 different templates as below

9 Member Template (for 2 weeks and 3 Weeks sprint) – Two Template
15 Members Template (1 week to 4 weeks) – Four Template

2. Sprint Planning Summary :

This is a raw template to prepare your Sprint Planning summary report. Check the sample report as a product image for reference
Key Sections

1. Sprint Goal
2. Sprint Duration
3. Sprint Schedule
4. Capacity Utilization Summary
5. Task Hour Distribution
6. Commitment Summary
7. Committed Story details

3. Scrum Metrics :

This Template is prepared to create and manage Scrum Metrics and KPI. See more details below.

Available Metrics
1	Commitment Reliability	Shows the percentage of story points completed against its commitment for every sprint. With Trend record among last 6 completed sprints.
2	Capacity Utilization	Represent the team capacity in hours and committed hours for each sprint, measured in effort hours. With Trends among the last 6 sprints
3	Velocity	Represents a total number of story points completed each sprint, with trend analysis for the last 6 sprints.
4	Velocity Fluctuation	Represents the velocity variance from average with relation to max and min tolerance.
5	Scope Change	Sprint over Sprint, for Last 6 sprints, the amount of story points added to the sprint or amount of story points removed from the sprint, After Sprint Started.
6	Defect Leakage	Amount of Defects detected after development, You can calculate it as defects detected by the development team Vs Defects detected by the Product Owner / or UAT.
7	Effort Estimation Variance	Effort estimated Vs Actual shows Overestimation hours and underestimation hours
8	Backlog Health	Shows the health of backlog in as a total number of Story Points available in backlog Vs Average Velocity (last 6 months). The speedometer shows the current backlog health is below 1 time of Average Velocity, at least 1 time of Average velocity, at least 2 times of average velocity or more than 3 times of average velocity.

4. Capacity Planning, Sprint Planning, and Tracking for two Week Sprint

This Template is prepared for planning your scrum team capacity and Plan your Sprint and Track it as part of sprint execution This is designed for the scrum team, who estimate their capacity in hours, and during sprint planning distribute the story into small subtasks and assign them to team members and validate that the team members’ allocation and estimation are in sync with their capacity.

There are 11 Sheets to capture the information. You will get the details of the sheet from the Details tab. below mentioned the list of Tabs you will,

1	Team	Define the Team Name and Focus Factor
2	Current Sprint	Sprint Name and Cadence
3	Holiday List	The list of Holidays falls under the sprint duration
4	Ceremony Time	Capture the time for each ceremony or planned meeting
5	Team Member	Team Member’s Name, Role, and their allocation % to the Project
6	Individual Vacations	Capture individual planned vacation time.
7	Default Sub Tasks	Possible Subtask the team will be working on
8	Task Flow Status	Status of subtask in their from start to end
9	Task Status treat as Done	Last status of the task workflow
10	Starting Task Status	First Status pf the workflow
11	Stories to Plan	List of initial stories to be planned, for quick population

Limitations

Team Members	x 15
Sprint Sudation	2 Weeks
Holiday Rule	Team Holiday Override – Individual Holiday
Sub Tasks	Max 10
Status of Subtasks	Max 10
User Stories to Auto Populate with Sub Task	Max 25
Max row of Tracking including Story and Subtask	Max 225