Improve your experience. We are very sorry but this website does not support Internet Explorer. We recommend using a different browser that is supported such as Google Chrome or Mozilla Firefox.

Using the Monte Carlo Forecasting Spreadsheets (e-learning)

Learn how to use the free throughput and velocity forecasting spreadsheets offered by Focused Objective. Many people use these spreadsheets when forecasting software project delivery dates, portfolios, and team capacity.


Self-paced course on using the Monte Carlo forecasting spreadsheets::

Throughput Forecaster: I want to forecast how long a single feature may take 

Multiple Feature Cut Line Forecaster: I want to forecast multiple features at once

Course curriculum

  1. Welcome and Introduction

    1. About this course

    2. Before we begin...

    3. Downloading the Spreadsheets and Getting them Running

    4. Exercise 1 - Download and PLAY!

    5. Resources: Slides, Spreadsheets, Worksheets

  2. Using the spreadsheets

    1. Forecasting a Single Feature (or backlog) Introduction

    2. Exercise 2 - Basic Forecasting of a Single Backlog

    3. Forecasting Multiple Features Introduction

    4. How to use Team Throughput or Velocity Data

    5. How to Manage the Splitting of Work

    6. How to Manage Risks (things that "might" go wrong)

    7. How to Handle System Changes in Delivery Pace (e.g. vacations, adding people, pandemics, etc)

  3. Advanced topics

    1. What is Monte Carlo Forecasting and Why Do I Care?

    2. How Much Historical Data Do I Need?

    3. Spreadsheet Settings and Options

  4. Before you go...

    1. Quiz on the key points

    2. Still got questions? What's next...

    3. How did we do?

Similar workshops

Call: Ask Me Anything: on Metrics & Forecasting

Zoom conference call + webinar on Metrics and Forecasting. I'll answer questions and if there are no questions I'll talk about something interesting!

More Information
Using the Monte Carlo Throughput Forecasting Spreadsheets

This two-hour online power-session discusses how to use the throughput and velocity forecasting spreadsheets. Learn how to quickly forecast.

More Information
Practical Forecasting Essentials (online)

Practical product features and portfolio probabilistic forecasting.

More Information
Managing Blockers and Dependencies using "Blocked" (free)

How to capture, manage and eliminate Blockers and Dependencies using "Blocked"

More Information
Dependency Management Deep-Dive Workshop

Understand, plan and mange cross team dependencies better

More Information
Introduction to Flight Levels

Introduction to Flight Levels with a self-paced learning course

More Information
Agile Physics - The Math of Flow

Short explanations of how and why to apply math, probability, and statistics in Agile development. These are topics everyone should know, but are too scared to ask.

More Information
Using the Team Dashboard Spreadsheet (e-learning)

Learn how to use the Team Dashboard spreadsheet to give teams a set of flow metrics without the hassle of managing a more complicated tool or process - you only need the story and defect start dates and finish dates.

More Information

Press enter to see more results