---
title: "SCRUM METRICS – EXCEL TEMPLATE"
slug: scrum-metrics-excel-template
url: https://agiledigest.perfectlyimperfectdigital.com/digital-downloads/scrum-metrics-excel-template
type: paid
price: "US$70"
---

# SCRUM METRICS – EXCEL TEMPLATE

## Description

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. CustomizationAll the Possible Customizations are under the worksheet DefinitionTeam NameName of the TeamCommitment ReliabilityCan Customize the color-coding Range for Red, Amber, and Green. By defining the From and to % for each colorVelocity FluctuationThe upper limit and lower limit Percentage from the average velocityDefect LeakageCan Customize the color-coding Range for Red, Amber, and Green. By defining the From and to % for each color Data CaptureSprint 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 Date1Sprint2Committed Story Points3Accepted Story Points4Added Story Points5Descoped Story Points6Available Capacity (Day 1)7Estimated Hours8Actual Hours9Defects Captured during Sprint10Defects Captured After Sprint or PO verification11Defects Captured After Sprint or PO verificationInformation needed to capture to get all the metrics populated – Under Backlog Grooming1Date of Capture2Story Points available for future sprint Dashboard worksheet ReferenceDashboard8 Metrics, 6 Sprint TrendAny One Sprint Dashboard7 Metrics of specific sprint as per selectionCommitment Reliability6 Speedometer an 1 TrendCapacity Utilization6 Cylindrical Column TrendVelocity6 sprint velocity trend, and 6 sprint velocity fluctuationDefect Leakage6 Speedometer an 1 TrendEstimation Variance6 Sprint Estimation variance trend LimitationsMax : Sprint Count in Trend : 6Watch the video tutorial to know how it works. The Video Tutorial is to target the version 1 onlyNote :1. Change Worksheet Zoom to adjust the visible area, based on your screen resolution2. If the Speedometer border is not sync with the Graph Use the Other Excel Sheet Suffix with NSC (No Speedometer Circle)Please Note: If you are using Office 2010 or the lower version, You may get some formatting issueFAQQ1. Is this Template work in Google Sheets?Ans. We have not tested it. We believe as this template are using complex formulas and formats. It may create problems in google sheetsQ2. Can we increase the number of sprints?Ans. 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. Video Tutorial Download Brochure Gallery

## Details

- Price: US$70

## Authors

- [Perfectly Imperfect Digital Online Courses](https://agiledigest.perfectlyimperfectdigital.com/@1)