here is a quick idea for auto updating project plans. The concept uses the Kanban categories to enable the automatic shifting of non-active tasks. This will enable the plan to be quickly and easily be kept up to date and allow the formation of new critical paths to be tracked. In Kanban, tasks can be categorised as “Done”, “In Progress”, “To Do”, etc. It is possible then to apply such categorisation to a waterfall plan, and for those tasks not yet in progress to have their dates shifted. The rule applying to the task shifting would be that for planned start dates that are before the current date and have not yet started to have their start date updated to the current date. I implemented a demonstration macro in MS Project. Please let me know if you want to experiment with it. I am not great at programming so cut me some slack on the coding. It required the Flag1 column to indicate if the task is active. Note, this is for demo only, Do not try this on your professional plans! I know this is not applicable in all circumstances. For example where problems emerge or the start date will be well beyond the current date. For such cases manual intervention is still needed. However, for simple updating of non-started tasks this may be a useful tool.....and it is often the case that people start later that the planned start date especially for non critical path items.
If you have any question just reply! Saving Changes...
Community Champion
