--- 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.