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.

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	The 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 the *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 simply 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

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

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)

Is this Template work in Google Sheets

We have not tested it. We believe as this template are using complex formulas and formats. It may create problems in google sheets
Can we increase the number of sprints?

Yes If you are good at Excel, you can. You will get an unprotected sheet where you can make any changes. if you want us to do the changes for you, you can request us, we may do it with a minimal charge.

Quick Glance

Price

Original price was: ₹6,000.00.Current price is: ₹4,500.00. + Tax

Enquire now more information about

Scrum Metrics – Excel Template

We recognize that committing to training investments can be a challenging decision. Rest assured, our team is here to assist you. Kindly provide your information in the form below, and we will promptly reach out to you with the necessary details.

You May be Interested in

Sale!
Templates
Conflict Trigger Checklist
Rated 0 out of 5
Original price was: ₹1,200.00.Current price is: ₹500.00. + Tax Add to cart
Sale!
Template Bundles
Scrum Team Bundle – 4
Rated 0 out of 5
Original price was: ₹20,150.00.Current price is: ₹12,000.00. + Tax Add to cart
Sale!
Template Bundles
Scrum Team Bundle – 3
Rated 0 out of 5
Original price was: ₹15,650.00.Current price is: ₹9,000.00. + Tax Add to cart
Sale!
Agile Centric Template
Capacity Planning, Sprint Planning and Tracking – 4 Weeks Iteration
Rated 0 out of 5
Original price was: ₹11,000.00.Current price is: ₹9,200.00. + Tax Add to cart
Sale!
Agile Centric Template
Capacity Planning, Sprint Planning and Tracking – 3 Weeks Iteration
Rated 0 out of 5
Original price was: ₹11,000.00.Current price is: ₹8,500.00. + Tax Add to cart
Sale!
Templates
Capacity Planning, Sprint Planning and Tracking – 2 Weeks Iteration
Rated 0 out of 5
Original price was: ₹8,500.00.Current price is: ₹7,500.00. + Tax Add to cart
Sale!
Agile Centric Template
Milestone RAG Status-Excel Template
Rated 0 out of 5
Original price was: ₹1,500.00.Current price is: ₹1,200.00. + Tax Add to cart
Sale!
Template Bundles
Maturity Assessment Bundle
Rated 0 out of 5
Original price was: ₹8,000.00.Current price is: ₹6,000.00. + Tax Add to cart
Sale!
Template Bundles
Scrum Team Bundle – 2
Rated 0 out of 5
Original price was: ₹12,350.00.Current price is: ₹9,000.00. + Tax Add to cart
Sale!
Template Bundles
Scrum Team Bundle – 1
Rated 0 out of 5
Original price was: ₹7,850.00.Current price is: ₹6,250.00. + Tax Add to cart

Dynamic Visibility - Custom Condition: syntax error, unexpected end of file