Click here to Skip to main content
15,178,008 members
Articles / Productivity Apps and Services / Microsoft Office / Microsoft Excel

Tagged as


2 bookmarked

How to Analyze the Impact of Velocity on Your Release Date

Rate me:
Please Sign up or sign in to vote.
5.00/5 (2 votes)
24 Feb 2020CPOL8 min read
Figuring out your velocity and how to increase it has much greater business value (bringing release dates in) rather than trying to specify and estimate everything up front to the utmost detail.
It's possible to model the impact of a higher or lower average future velocity on release dates. In other words, if there is a need for a plan, you can make the entire plan using the following approach: dependent variables - incremental release dates, and independent variable - hypothetical velocity. And then look at what happens to the release dates as you vary velocity. In this article we run through the following: Pull Out the Scope Sizes from Jira, Create a Key Assumptions Section, Fill Out the Remaining Formulas to Estimate Your Release Date, Rinse and Repeat for Remaining Versions on Your Backlog, and Kick Up the What if Analysis Using Excel's Scenario Planner.



This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Lukasz Szyrmer
Program Manager
United Kingdom United Kingdom
Lukasz Szyrmer used to develop in C++ and C# and now manages development teams. He writes about agile, lasagna, and the cost of delay. If you are hungry for more, check out Debugging Velocity for a free chapter in his upcoming book.

Comments and Discussions