Critical Chain Project Management in an Excel

Sometimes (often in the beginning of an CCPM implementation) we need a plan and some execution to get the something done. That is very usual - but we are TOC-guys and we know about buffers and buffer management. So there was a huge need to have a small critical chain tool at hand that can be used everywhere easily - and that means without installing something, without database and then you are at Excel.

But don't underestimate the "CCPM in an Excel" it has everything you need:

  • like MS-Project and all others - there ist a list of workpackages (three level), milestones and dependencies and time estimations
  • it can determin the end date and backwards the latest possible start of all feeding chains
  • everything is shown in a gantt-chart
  • and of course it can "compress" the existing plan, so that some buffer is generated - full blown CCPM
  • but that's not all - it has also execution functionality. So it's possible to set work packages "in progress" or "on finished"-status. And for in progress tasks you can give an estimation for the remaining duration (all in working days)
  • out of this the current plan is calculated and also shown as shadow in the gantt-chart
  • this is all used to generate a classic CCPM fever chart
  • in the current version there are also functionalities like Contractual Milestones and Feeding Buffer - but you don't have to use this - it's often a sing that the organization is still not in flow

So have fun with watching the tutorials ...

... if you want to use the "CCPM in an Excel" - you can get it for free - it's under a Creative Commons License:

click here to get the CCPM in an Excel file

Critical Chain in an Excel - Planning and Execution Management - Basic Functions

New Features in Version v0.28

(1) Feeding Buffer (2) Contractual Milestones (3) structuring the project in subtasks/subprojects