Scrum Metrics – Excel Template

6,000.00 4,500.00 additional tax may apply

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

Please Note : If you are using Office 2010 or lower version,You may get some formatting issue.

Downloadable products are not Refundable.

Limitations

Max : Sprint Count in Trend : 6
Watch the video tutorial to know how it works. The Video Tutorial is to target the version 1 only
Note :
1.
Change Worksheet Zoom to adjust the visible area, based on your screen resolution

2. If the Speedometer border is not sync with the Graph Use the Other Excel Sheet Suffix with NSC (No Speedometer Circle)

Understanding the Metrics

Understanding the Template

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

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 last 6 sprints  
3 Velocity Represents total number of story points completed each sprint, with trend analysis for 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 sprint, 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 development team Vs Defects detected by Product Owner / or UAT.  
7 Effort Estimation Variance Effort estimated Vs Actual, shows Overestimation hours and under estimation hours  
8 Backlog Health Shows the health of backlog in as 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.  

Customization

 
All the Possible Customizations are under worksheet Definition  
Team Name Name of the Team  
 
Commitment Reliability Can Customize the color coding Range for Red , Amber, Green. By defining the From and to % for each color  
 
Velocity Fluctuation Upper limit and lower limit Percentage from average velocity  
 
Defect Leakage Can Customize the color coding Range for Red , Amber, Green. By defining the From and to % for each color  
 

Data Capture

 
Sprint Data needs to be captured under Sprint Trend Data worksheet and PB Groom History worksheet. The Graph will automatically pick the last 6 sprint information. It is capable to capture 30 Sprints, after that you can simple clean the past information.  
Information needed to capture to get all the metrics populated – Under Sprint Trend Date  
1 Sprint  
2 Committed Story Points  
3 Accepted Story Points  
4 Added Story Points  
5 Descoped Story Points  
6 Available Capacity (Day 1)  
7 Estimated Hours  
8 Actual Hours  
9 Defects Captured during Sprint  
10 Defects Captured After Sprint or PO verification  
11 Defects Captured After Sprint or PO verification  
Information needed to capture to get all the metrics populated – Under Backlog Grooming  
1 Date of Capture  
2 Story Points available for future sprint  

Dashboard worksheet Reference

 
Dashboard 8 Metrics, 6 Sprint Trend  
Any One Sprint Dashboard 7 Metrics of specific sprint as per selection  
Commitment Reliability 6 Speedometer an 1 Trend  
Capacity Utilization 6 Cylindrical Column Trend  
Velocity 6 sprint velocity trend, and 6 sprint velocity fluctuation  
Defect Leakage 6 Speedometer an 1 Trend  
Estimation Variance 6 Sprint Estimation variance trend  

Video Tutorial

 
Understanding the Metrics
https://youtu.be/O_gzadW_Sb8Understanding the Excel
https://youtu.be/tnhQmpIkGmk
 
 
 
 
 

Contact Us

 
support@agiledigest.com