Scrum Metrics – Excel Template

scrum metrics ,scrum metrics, 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

Shopping Cart
Scroll to Top

Have some query or want to show Interest on this Trending Agile Tracks ?

Let us help you answer your query

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

International IP Detected

It looks like you're visiting from outside India. Would you like to switch to our international site?

Switch to International Web Site

The Agile Leadership and Product Management Excellence Certification (ALPMEC) is a comprehensive program designed for aspiring and seasoned product managers aiming to excel in Agile environments.

16 Modules

100+ Hours

Cap stone Project

Have Some Question ? Contact us

Let's Get Familiar with SAFe: 3-Hour Live Session on Key Concepts

INR 2000/-

Join us for an engaging 3-hour live session on June 9th, 2024, from 7:00 PM IST to 10:00 PM IST, where we will dive deep into the fundamentals of SAFe 6.0. This non-certification awareness program is designed to help you understand the key concepts of the SAFe Framework. Whether you have doubts about SAFe, are considering which certification is best for you, or are undecided about whether SAFe is the right fit, this session is perfect for you.

Want to make a DEEP DIVE To JIRA JQL?

The Offer You Can Not Refuse
As many of us are well-acquainted with the versatility of Jira, we often encounter challenges in filtering data precisely as needed. This is where the power of Jira Query Language (JQL) becomes indispensable. I am excited to share some fundamental concepts of JQL that will empower you to craft more effective queries, enhancing your data manipulation capabilities within Jira.

Join our "Refer and Earn" program by simply filling out this form. Here’s how to get started:

You are referring to Scrum Metrics – Excel Template

If there's anything else you'd like us to know about your referral, or any specific instructions, please include them here.
How do you want to get your reward
Once you’ve filled out the form, click ‘Submit & Earn’. We’ll take it from there, and you’ll be on your way to earning rewards!

Scaled Agile Framework (SAFe) - Certification

No results found.

Agile life cylce Management - Training

Navigating the Future: Unleashing the Power of Jira Advanced Roadmap for Seamless Project Planning and Execution
Working with Rally Software
Jira Service Management
Mastering Jira
Azure Boards

Agile Digest Exclusive

Mastering SAFe with PI Planning Simulation in 2 Days
Navigating the Future: Unleashing the Power of Jira Advanced Roadmap for Seamless Project Planning and Execution
Working with Rally Software
Jira Service Management
Mastering Jira
Azure Boards
(ESM) Efficient Scrum Master
Sprint Simulation

Recent Blogs and Articles

Explore our Excel Templates

Feed back From popular courses

Azure Board Training Feedback
Thursday Virtual Collaboration
Jira Training Feedback
Sprint Simulation Feedback
Efficient Scrum Master Feedback
SAFe POPM Feedback
SAFe Advanced Scrum Master Feedback
SAFE Scrum Master Feedback
Leading SAFe Feedback
Training Calendar
SAFe Transformation
Corporate Engagement

EARN FROM YOUR SPECIALIZED SKILLS

We may not be experts on everything, but all of us have some skills that we are super experts in, It can be Agile, It can be Excel or Jira or Java or Database or Machine Learning or Project Management or UI Design, or anything else.
Sounds Interesting? wants to know more? feel this form we will contact you and explain the next step and process. Does not matter which country you belong to and which Time zone you are in we all have potential needs everywhere. 
You may be Trainer, Freelancer, Full Time Employee, or consultant. Why not you earn little extra money with your expertise on your available time. You chose what you want to do, support another professional or train a group of people or participate in a small or large project choose the skill you complete hold. On top of that, you choose the rate that you want to charge. Get yourself exposed to the people who may need your service.

Offers and Discounts

Republic Day
Sale

Efficient Scrum Master

ESM early bird, Flat 10% discount for ESM Courses(A & P) , Please talk with the chat agent to get the discount code.

 

On Going

SAFe

Attractive Discounts and Offers on SAFe Certification

On Going

Special Discounts on Excel Template, 


Connect with our Chat Agents for more information and to grab more offers and discounts

Upcoming Training and Events at a glance