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

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 5.8K   2  
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.

Views

Daily Counts

License

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


Written By
Product Manager
Poland Poland
Lukasz Szyrmer used to develop in C++ and C# and now manages development teams as a technical product manager. He writes about agile, lasagna, and the cost of delay. If you are hungry for more, check out Debugging Velocity if you'd like to see more.

Comments and Discussions