On-going Work Status Visualization (for MS Project 2016 or higher)

The MindFraming 'On-going Work Status Visualization' Add-in allows project managers to immediately see the Status of their on-going tasks visually/graphically, enabling them to quickly identify key risks upon the basis of each Task's 'Status Color' -- ranging on a Color Spectrum from Green (Not Late) to Red (Late) -- far more easily than they can do so with a long list of (textual) task statuses (which can often not be displayed all-at-once on the same screen). By default, only tasks with a Status of either 'Late' or 'On Schedule' are displayed (i.e. on-going tasks).

Absent this 'Status Spectrum' in MS Project, high-level tasks that are not yet Complete, but which have been started, can only ever have the Status of either 'Late' or 'Not Late' (i.e. 'On Schedule'), regardless of how many child tasks they have which are Late, or the Work that they represent. A single, insignificant Task low down in the WBS-Hierarchy with a 'Late' Status, can force all of its parents to also have a 'Late' Status in MS Project, with no shades in between.

With the On-going Work Status Visualization, 'Status Colors' -- Green (Not Late) or Red (Late) -- are assigned only to Leaf Tasks (those with no child tasks), which can be either fully-Red (Late) or fully-Green (Not Late). Conversely, the 'Status Color' of each parent task is calculated upon the basis of the averaged 'Status Color' of its (unfiltered) children. The less-Green a Parent Task is, the more Red that is present amongst its (visible) children.

The Size of each task node relative to its (un-filtered) siblings -- at each WBS-level -- is determined by the 'Work' that each task represents. The more space that a Task takes up visually in the Tree Map, the more Work it represents relative to its siblings. For this reason, Milestones (i.e. tasks with zero 'Work') are not displayed in the visualization. By default, 'Complete' and 'Future Tasks' are not displayed either (as they are not 'on-going'), but they can be included if desired.

The project manager's focus should be on the largest Task Nodes, that are most-Red (i.e. those with the most 'Late' Work), as these represent the biggest risks to the project. 'Non-Critical' Tasks are included in the visualization by default, but should the user de-activate the 'Non-Critical' Filter Button, only Tasks along the Critical Path will be displayed.


To drill-down through the various WBS levels, simply (left-)click upon the desired Task to see its children 1-level down. A single right-click anywhere on the graphic will return you 1-level back up the WBS hierarchy -- as will the 'Up' Button in the top-left corner of the Add-in display. If the mouse arrow changes to a hand-pointer when hovering over a Task Node, this means that you are hovering over a parent task, and can left-click to drill-down. A left-click on a Leaf Task -- for which you will only see an arrow-pointer -- results in no action (as it has no child tasks to drill-down to).

Please see the provided Video for a demonstration of how this Add-in works.


NB: The Add-in does not currently support custom WBS formats, but only the standard dot-separated WBS format (e.g. '1.2.2.5').

PRIVACY POLICY: No data read by this Add-in shall be stored remotely, or communicated to any third party. It shall exist only on the client-side, as all processing is done on the client-side.

For Bugs, please contact: info@MindFraming.org