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

Scrum Metrics – Excel Template

Available Metrics