See the explanatory video below (or here: http://youtu.be/7qMs5NJjeuk).
This is an easy way to simulate Kanban using Excel. You can run the simulation without work in progress limits and then with the limits, to compare the total flow time and the time per individual item. The instructions tab contains link to video of author demonstrating this.
However, the sheet is much more powerful than that: almost everything in the sheet is configurable, from the number of tasks to the effort per task per state. So you can use this to simulate your projects.
But it is most useful for demonstrating and explaining the principle of Kanban to groups. You can see an example of that in the video below or here (from timestamp 15:40) by the author of the tool: https://youtu.be/zgryxnk8_7c
It can also be used to demonstrate The Theory of Constraints from Eli Goldratt's classic, "The Goal". See instructions and video below.
This is an Excel 2003 compatible version which also works in later Excel versions. It also works on a Mac but please note that the macro execution speed is approximately eight to ten times slower(!) than on Windows (and in the video).
Spreadsheet, not macro.
There are 3 reviews posted on this application.
“Description lists that the file is unlocked and available for editing. However, there is a password on the VBA code, the designer is unresponsive, and all you can do is change the title of a few cells. No customization within the file, what you see in the video is what you get but it does work. ”
“I'm just wondering why in every simulation I tried so far, a WIP of 1 is the best for a low "Average time
Is there a mistake in the sheet?
Posted on March 4, 2012 4:39pmLet's Chat
“I downloaded and have been playing with it for a few days. It is such an elegant solution as a teaching tool. All you have to do is use it as a model and simulate to the business what would happen in various scenarios. Very happy with it. I will test drive with the business starting Q2 once i stress test this enough.
Many thanks Mark, I think its really good.
ROI is well worth it.”