Kanban simulation  This Intellectual Capital has a video  This design has 5 screenshots

Seller : Mark Robinson

  1. Rating 3 Rating3 Rating(s)
  2. views 30,280
  3. price$9.99
  4. Compatibility
  5. Date added February 27, 2012

You must be logged in to purchase or download design files.

Not a member? Create an account.

Product Description

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).


Includes Macros

Includes Results Summary

Push Button Display Table Updating

Unlocked for Editing

Spreadsheet, not macro.

Includes Graphic Data Display

Includes Instructions

Ratings & Reviews

There are 3 reviews posted on this application.


Posted on August 16, 2016 2:04pm

Let's Chat

“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. ”


Posted on May 15, 2012 7:15am

Let's Chat

“I'm just wondering why in every simulation I tried so far, a WIP of 1 is the best for a low "Average time
to complete"
Is there a mistake in the sheet?


Posted on March 4, 2012 4:39pm

Let'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.”