Monday

Tag Archives: scheduling tools

DCMA 14 Point Schedule Assessment – Updated

There seems to be a lot of misunderstanding around the intention and use of the DCMA 14 Point Schedule Assessment.  Following on from several discussions over the last month or so we have updated our White Paper: DCMA 14-Point Assessment Metrics and uploaded the last published version of the Metrics:  Earned Value Management System (EVMS) Program Analysis Pamphlet (PAP), DCMA-EA PAM 200.1, October 2012.

The EVMS-PAP is designed for use in performing an integrated baseline review of a major program using EVM, but EVM relies on a competent schedule and Section 4 of DCMA-EA PAM 200.1 defines the last published version of the DCMA 14 Point Schedule Metrics. As can be seen from the date of publication, the DCMA 14 Points are quite old, and they did change in the years before 2012 (for more on the evolution of the DCMA 14 Points see: The evolution of the DCMA 14 Point Schedule Assessment). This leads to two significant problems:

The first is many people misunderstand the objective of the assessment. The objective is stated explicitly in the document:

The DCMA 14 Point Schedule Metrics were developed to identify potential problem areas with a contractor’s IMS…… These metrics provide the analyst with a framework for asking educated questions and performing follow-up research. The identification of a “red” metric is not in and of itself synonymous with failure but rather an indicator or a catalyst to dig deeper in the analysis for understanding the reason for the situation. Consequently, correction of that metric is not necessarily required, but it should be understood.

Earlier versions talked about pass/fail, this concept has been dropped (and was never a good idea).

The second issue is implementation of the assessment. The implementation of the DCMA 14-Point Assessment in the various software tools is not certified by the DCMA or any other body and varies between the tools!  The biggest issue is around counting of the number of tasks to be considered. The 2012 version stated that the Total Tasks should exclude: Completed tasks, LOE tasks, Subprojects (called Summary tasks in MS Project), and Milestones (Zero Duration Tasks). This differs from the 2009 update, and the 2009 update changed from earlier versions.

There is an established correlation between a competently prepared schedule and project success – successful projects tend to have an effective controls system and a ‘good’ schedule, but the key measure of a good schedule is it is useful and is used. The purpose of the DCMA checks is to identify issues that need to be understood.

For more on schedule quality see: https://mosaicprojects.com.au/PMKI-SCH-020.php#Overview

Schedule Calculations – Old and New

The way CPM schedules were calculated in the 1970s and 80s (prior to the availability of low-cost PC scheduling tools) used a simplification designed to minimise error and speed up a tedious task.  Whilst some of us are old enough to have used this ‘manual’ technique on real schedules, everyone in the modern world recognises Day # 1 = Wednesday 1st October and a 3 day duration activity will work on Wednesday, Thursday and Friday to finish on the 3rd October and the fact 1 + 3 = 4 is simply an anomaly in the way integers and ‘elapsed time’ interact that has to be dealt with inside the computers computations to produce accurate date based bar charts and tabulations.

Unfortunately there has been a rash of postings on linked-in over the last week totally confusing everyone with their nonsense about CPM calculations.  This blog is designed to correct the message!

To overcome the problem of a 3 day activity starting on the 1st October finishing on the 3rd October, but  staring on day 1 and adding a duration of 3 gives you 1 + 3 = 4, the simplified manual calculations assumed the starting point was ‘day Zero’ 0 + 3 = 3!

However, the old manual calculations starting from day Zero have never been correct – the start day number for every activity in a schedule is always the day before it actually starts.  The end dates (day numbers / dates) are correct and the advantage of this option is it only requires one simple calculation per task for both the forward and back passes and the Free Float calculations are a simple subtraction.

EF = ES + Duration
LS = LF – Duration ….  Easy!!

This simplistic methodology was absolutely essential for manually calculating large PDM schedules. The ‘normal’ scheduling practice through to the mid 1980s when affordable PCs arrived – very few companies could afford the expense of mainframe scheduling tools and those that did wanted to make sure the data was correct before the computer run.

The accurate calculation used in all scheduling software, recognises that a 3 day activity starts at the beginning of day 1 and works on days 1, 2 and 3 to finish at the end of day 3 and its successor (assuming a FS0 link) starts at the beginning of day 4.  Unfortunately these ‘real’ calculations require much more complex calculations[1].

ES = 1, EF = (1 + 3) – 1 to get to the end of day 3.
The Zero duration link requires (EF 3 + 0) + 1 = the next activity ES is the start of day 4.

This approach more than doubles the amount of calculation effort and increases the opportunity for error and of course affects Free Float calculations as well.

Fortunately computer software is not prone to making calculation errors and runs these more complex sums 100% accurately to calculate the date activities start and end accurately when transposed onto a calendar. For more on the actual calculations see: http://www.mosaicprojects.com.au/PDF/Schedule_Calculations.pdf

Given no one has used manual calculations to determine a major schedule in the last 20 years (at least) the old simplistic manual approach is redundant and should be consigned to my area of interest, the history of project scheduling (see: http://www.mosaicprojects.com.au/PM-History.html).

[1] For a more complete discussion see the excellent paper by Ron Winters written in 2003 and entitled ‘How to Befuddle a College Professor’, which can be found at:  http://www.ronwinterconsulting.com/Befuddle.pdf

Time Analysis Schedule Calculations

There are a range of options for the calculation of dates and float in a CPM network.

I’ve just finished a White Paper focusing on the basic calculations and would appreciate comments on the correctness of the calculations and the methodology adopted.  The aim is to produce a definitive document that is generally agreed. 

You can download the paper from http://www.mosaicprojects.com.au/PDF/Schedule_Calculations.pdf   All comments gratefully appreciated.

Scheduling Tools

Has Microsoft overcooked the price and performance of Microsoft Project (MSP)? With the impending release of Project 2010 most organisations should be re-evaluating their scheduling tools. Blindly following the Microsoft upgrade path should not be an option.

The trigger for this post is a number of emails I have received plus comments in a number of published articles and on Planning Planet.  Some users criticise MSP for flawed analytical performance, poor data handling and lack of real power in analysis. Other users criticise MSP for being too complex and too hard to use (you could almost feel sympathy for the MSP development teams dilemma). These criticisms have not changed much since the release of Project 2003 and Project Server. What has changed dramatically is the scheduling software market.

Through to the early 2000s Microsoft virtually gave MSP away, almost anyone could access a ‘competitive upgrade’ for under US$100. The very low cost of MSP effectively destroyed 90%+ of the mid to low end competition, TimeLine, CA SuperProject and a host of other businesses closed merged or changed focus.

Today most people outside of major corporations pay around US$1000 for a set of MSP. This tenfold increase in the ‘real price’ of the tool, primarily caused by the elimination of heavy discounts has opened the window for a host of new players in the mid to low end scheduling market place. Many with free options.

Asta PowerProject seems to be a complete replacement for MSP with equivalent levels of capability and sophistication and better presentation and analytical capabilities.

Other graphical tools include CASCAD-e and NetPoint

Some of the tools that are completely free, or have free entry level options include: jxProject, Gantter.com, PlanningForce and OpenProj

This is not a comprehensive list by any means more tools are documented on our ‘scheduling home page’. And I have not ventured into discussion of the high end products such as ACOS, Micro Planner, Primavera, Spider and the Deltek range.

The purpose of this blog is to challenge every organisation to really evaluate their scheduling requirements and test the market before letting their IT department blindly follow the Microsoft upgrade path.

Project 2010 may still be the best answer, but this needs to be an informed decision based on a proper review of the available alternatives. Simply paying the cost of upgrading to project 2010 (including licence fees, retraining and data conversion costs) without re-testing the market should be seen as being totally unacceptable because in 2010 there is a real choice of tools available!