---
# System prepended metadata

title: Spreadsheets from Team Guide to Metrics for Business Decisions
tags: [' kanban', metrics]

---

---
title: Spreadsheets from Team Guide to Metrics for Business Decisions
tags: metrics, kanban
---

###### tags: `metrics` `kanban`

_(cloned from https://github.com/SkeltonThatcher/bizmetrics-book/edit/master/README.md)_

# Team Guide to Metrics for Business Decisions
Public resources for the book **Team Guide to Metrics for Business Decisions** by Mattia Battiston and Chris Young (http://bizmetricsbook.com/)

![](https://i.imgur.com/MRvuaib.png)

## Example Spreadsheets
We have created some example spreadsheets to demonstrate what we are talking about in the book. Feel free to use them, copy them, edit them as you like - they should help you get started with metrics for your business decisions!

You can find them all in this public folder in google drive: [example spreadsheets](https://drive.google.com/open?id=0B2p8TYBgYF-MSkx2ZUt6SGxTY3c) 

The folder contains the following spreadsheets:

### Throughput

* [Are my story points predictable?](https://drive.google.com/open?id=1rfrr9ZoUjlIQS8hxCKjTx9r9ndvwcDZ9zHgd_T17rIE) Many teams rely on story points to give them predictability and answer questions like _"How long will this story take? When are we going to complete these stories? How much can we achieve in the next two weeks?"_. But is that really giving you any predictability? Use this spreadsheet to verify whether there is correlation between your estimates (story points) and how long stories actually take (lead time). 

* [Throughput - Stats & Trend](https://drive.google.com/open?id=1JyTEYg3vIh0OoPM_TSwzPNGn_cXYGsBMFXT2SnF5Tg0) Find out how many stories you're completing in each iteration/sprint and analyse your data to make better business decisions. Answer questions like _"How many stories can we complete in the next iteration?"_ and _"Are we improving?"_

* [Throughput - Simple Project Forecasting](https://drive.google.com/open?id=13NdAyShAsAuKZZFITg2w3dznQN6wTHIyW7vkhmtmdPQ) Use your throughput to make simple predictions and answer questions like _"When will this project/functionality be done?"_ and _"Which stories can we complete in the next iteration?"_

### Forecasting

* [Probabilistic Forecasting](https://docs.google.com/spreadsheets/d/1L-BHVNIAFprYT0auzoBxvR3wI9JQS8wxVHG9XrDR1uQ) Use your past throughput to forecast the future. Answer questions like _"How long is it going to take to complete these N stories?"_ _"What can I get in the next X sprints?"_ _"Is this feature going to be ready by sprint X?"_ _"Which feature should we work on next?"_
* [Forecasting number of stories](https://drive.google.com/open?id=1Q0mqSoGlaVbFPeVxrydMJsc9NX2RajbkJQP1k3nwmgQ) Sometimes it's not feasible to break down all the requirements upfront to find the total number of stories to complete, especially for big projects. Just break down a few epics (5-7 is good enough to get started) and then use this spreadsheet to forecast how many stories you are going to have in total.

_(note: the examples are a read-only version. In order to use them use the menu "File/Make a copy" to copy them)_

## Example Trello board

* [Example Trello Board](https://trello.com/b/fq07LbFO/bizmetrics-book-example-board) We have created an example Trello board that demonstrates how you can track information for your stories, including the sprint when they were completed to easily calculate your Throughput.
