Combination of Five Template with a Bundled price - Capacity & Sprint Planning, Sprint Planning Summary, Scrum Metrics, Capacity Planning, Sprint Planning, and Tracking for two Week Sprint, Product Backlog
Exclusive offer for Academy Members
SCRUM TEAM BUNDLE – 4
How to Apply
Eligibility
Minimum 2 Months of Membership age
Process
- Meet the Eligibility Criteria
- Apply for coupon code by filling out the Form
- Admin Validation
- Receive the Coupon Code
- Purchase from the Purchase link by applying the coupon code
- Download the Template
Excel Template Bundle 4
Combination of Five Template with a Bundled price
-
Capacity & Sprint Planning :
This Scrum bundle team – 1 Template is prepared for Plan your scrum team capacity and optimize your commitment during Sprint Planning. This Scrum Bundle team – 1 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 get 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 -
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- Sprint Goal
- Sprint Duration
- Sprint Schedule
- Capacity Utilization Summary
- Task Hour Distribution
- Commitment Summary
- Committed Story details
-
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. -
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 Candance | ||||
| 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 |
5. Product Backlog
This Template is prepared to manage your product backlog Items with, with below features
- Add your backlog item in excel
- Easy navigation in the form
- Compare Stories
- Measure Story Points with Complexity Bucket
- Measure Story Points Story Point Factors
- Find new Story Points
- Watch the video to get the demo to know it in detail
- Manage Epics and Status Master
- Manage Project Master
- Manage Frequent use Projects
CAPACITY AND SPRINT PLANNING
The details of each worksheet are mentioned below
Definition
The “Definition” sheet is the first sheet where you will configure the sprint for Capacity Planning
This sheet have 6 sections to define
1 Team Define the Team Name and Focus Factor
2 Current Sprint Sprint Name and Cadence
3 Holiday List List of Holidays fall under the sprint duration
4 Ceremony Time Capture the time for each ceremony or planned meeting
5 Team Member Team Members Name, Role and their allocation % to the Project
6 Individual Vacations Capture individual planned vacation time.
Note : There will be some default values when you are using it for the first time. Please change it accordingly
Analytics
The Sheet has the pivot table that you may need to refresh after any change on the definition sheet
Capacity
This Sheet is the Final output of the planned capacity. It’s a View only a Sheet to calculate and represent the capacity. If any changes are required, please change the definition sheet.
Sprint Planning
This sheet is you can use to plan your sprint my adding committed stories, with the task hours estimated by each team member, This Sheet will auto calculate the Planned Capacity and commitment Hours, with a graphical representation of utilization, and visual warning on over-commitment
Estimation Accuracy
This sheet is to use on the last day of the sprint or after the sprint closure, to calculate Over and Under Estimation
SPRINT PLANNING SUMMARY-REPORT TEMPLATE
Ready made excel template to easily prepare your Sprint Planning summary report.
This is a raw template to prepare your Sprint Planning summary report.
Check the sample report as product image for reference
for any clarification write us at [email protected]
Key Sections
- Sprint Goal
- Sprint Duration
- Sprint Schedule
- Capacity Utilization Summary
- Task Hour Distribution
- Commitment Summary
- Committed Story details
SCRUM METRICS – EXCEL TEMPLATE
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. | ||
CAPACITY AND SPRINT PLANNING AND TRACKING – 2 WEEKS ITERATION
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 Duration | 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 |
Product Backlog
This Template is prepared to manage your product backlog Items with, with below features
-
-
- Add your backlog item in excel
- Easy navigation in the form
- Compare Stories
- Measure Story Points with Complexity Bucket
- Measure Story Points Story Point Factors
- Find new Story Points
- Watch the video to get the demo to know it in detail
- Manage Epics and Status Master
- Manage Project Master
- Manage Frequent use Projects
-
For related videos you can visit https://academy.agiledigest.com/videos/
Can I make Modification or Customization?
Yes You Can
Where Can i request for support
You can drop us a email @[email protected]
SCRUM TEAM BUNDLE – 4
Explore the Screenshots
Apply for Coupon Code
Seems like You have not logged in yet, Please log in or sign up
