% End Timeliness per Project

% End Timeliness per Project

% End Timeliness per Project is a project metrics that show the time deviation (expressed as percentage) in providing the project deliverables. % End Timeliness is calculated using the formula below:

% End Timeliness = ((Actual Delivery Date Planned Delivery Date) / Planned Duration) * 100

Actual Delivery Date is the date when the deliverable was actually provided.

Planned Delivery Date is the estimated date when the deliverable should be provided.

Planned Duration is the aggregated estimated duration of project phases. Planned

Duration is calculated as the difference between Planned Delivery Date and Start Date of the first phase in the set of phases ended with delivery of a product or service. In other words, Planned Duration is the sum of all durations of phases preceding the delivery of a product or service.

Let’s take development project as the example. Suppose the part of development project comprises three Phases: Phase 1 – Initiation, Phase 2 Requirements Specification and Phase 3 – Analysis &Design. After Phase 3 is complete, the company should provide Analysis and Design Document to the customer (this document is the result of work during three Phases). 

Planned Delivery Date for Analysis and Design Document is 04/09/2012

Actual Delivery Date for Analysis and Design Document is 04/16/2012

Planned Duration for three Phases:

Phase 1. Initiation 25 days

Phase 2. Requirements Specification – 30 days

Phase 3. Analysis &Design – 31 day

Total Planned Duration of three Phases is 86 days

According to the formula for computing % End Timeliness:

% End Timeliness = ((Actual Delivery Date Planned Delivery Date) / Planned Duration) * 100= (04/16/2012 04/09/2012) / 86 = (7/86) * 100 = 8.14%

To calculate % End Timeliness per Project please follow the steps below:

• Add custom field “Planned Delivery Date” with code “cf_planned_delivery_date” and Type “Date”



• Add the custom field “Actual Delivery Date” with code “cf_actual_delivery_date” and Type “Date”



• Add the custom field “Planned Duration” with code “with code “cf_planned_duration” and Type “Duration”



• Add the custom field “% End Timeliness” with the formula:

(($cf_actual_delivery_date $cf_planned_delivery_date) / $cf_planned_duration)* 100



In the field “Display format” enter: #0.00% to display the value as 8.14% for example or #0.0% to display it as 8.1%

• On Task Tree select the task group for which you need to display “% End Timeliness” per Project  and select “Custom fields options”



• To enter Planned Delivery Date, Actual Delivery Date and Planned Duration per task group or project phase you need to right click on task group with project tasks, select “Custom fields options” and select “Edit” for the corresponding custom field







• To enter the values for the custom fields “Planned Delivery Date”, “Actual Delivery Date” and “Planned Duration” per task group right click on task group with project tasks and select “Edit”







Alternatively it is possible to calculate aggregated Planned Duration for required project phases automatically. Following the example above the program can display the total planned duration 86 days for 3 Phases that precede the phase for which you need to calculate %End Timeliness (4. A&D Document):

Phase 1 – Initiation (25 days)

Phase 2 Requirements Specification (30 days)

Phase 3 – Analysis &Design (31 day)

86 days = 25 days + 30 days + 31 day



• To calculate aggregated Planned Duration automatically you need to create tasks groups associated with project phases (following previous example: 1. Initiation, 2. Requirements Specification, 3. Analysis &Design) under the task group for which you need to calculate %End Timeliness (4. A&D Document)



• To set automatic aggregation for task group for which you need to calculate % End Timeliness (A&D Document) right click on this task group and select “Aggregated (for task group)” for the custom field “Planned Duration”



• Set the following custom fields settings for the custom field “%End Timeliness”
  • In “Settings for” select “This task group”
  • select “Enable”
  • select “Calculated by custom field formula (for task group)”



%End Timeliness per Project on Task Tree