Monte Carlo Simulation for backlog prognosis - with one function in Google Sheets
March 15, 2024
Ever since I first read When will it be done by Daniel Vacanti I have been fascinated with how much prognosis work that can be created using very little data. I have written extensively about these “kanban metrics” in other blog posts, should you want a deeper understanding.
Dan and the Actionable Agile Team have created a brilliant tool called Actionable Agile which has many more capabilities than I will show here. This is a straw-man version, BUT I learned a lot of the mechanics behind the scenes in creating this and I hope you will too.