Blogs


Welcome to Project Controls Institute, Australia blog.

Selection of thoughts and tips shared by Project Controls community.

Scheduling and the ‘Progress Override v Retained Logic’ Conundrum

Scheduling and the ‘Progress Override v Retained Logic’ Conundrum

With the growing use of project management software to analyse construction delays, comes the often overlooked question – how does the software really work? This is of course a pretty meaty query and way too big for a single article. But within it are some more manageable ‘bite-sized’ issues. One of these is programme scheduling and how out-of-sequence working is rationalized by the software during the scheduling process. Now whilst some might consider the usefulness of this topic limited to the planners’ amongst you, it is important to recognise its wider implications upon defining and quantifying critical path delays.


 
So what is ‘programme scheduling’?
 
In a nutshell, scheduling is the process of updating a programme to a certain date during the course of a project (often referred to as the ‘data date’) by incorporating progress information for all activities in the programme up to that point in time. On many projects this is done at least once a month, with the updated programme included in the monthly progress report. The process itself involves adding actual start/finish dates, the percentage complete, and remaining duration of individual activities that have in some way changed over the reporting period. Once this information is added, the programme is scheduled (or rescheduled), calculating new start/finish dates for all activities in the programme according to a bunch of preset logic rules defined by the operator.
 
The average construction programme invariably contains many thousands of these user defined logic rules. These rules transform a static bar chart into a much more useful dynamic model which can be gradually updated with progress and other changes to assist managing the project and tracking delays. These rules include things like:- (a) logic relationships between activities (e.g. task A must be complete before task B can start); (b) different working-day calendars for specific types of tasks; and (c) resource dependent activity durations.
 
In addition, they also include a choice between using the Progress Override or Retained Logic options when dealing with out-of-sequence progress of activities (i.e. when an activity progresses in advance of when it otherwise would have according to the prevailing logic rules). When the Progress Override option is chosen, work is allowed to proceed on the out-of-sequence activity immediately and the logic links from its predecessor activities are overridden. If the Retained Logic option is chosen, these predecessor links are not overridden and remain in force thereby governing when the remainder of the out-of-sequence activity will be carried out.
 
Figure-1 and 2 are included below to help show the difference between these 2 operations.
Figure-1 shows 2 activities, A and B, where activity A was planned to be fully complete before the start of B. This is known as a finish-to-start logic link.
 
Figure-2 then demonstrates how the software deals with the situation where, during the works, activity B starts before A is complete. If the Retained Logic option is used, the remaining duration of activity B is scheduled to occur after A is complete. In contrast if the Progress Override option is chosen, then the finish-to-start logic between activity A and B is ignored or overridden. In this case activity B is allowed to progress notwithstanding that A is not finished.
 
 
The end result is that the Progress Override option leads to an earlier projected finish date for activity B. It also means that activity A is no longer on the critical path at the time of the progress update.
 
The wider implications of this choice will hopefully become clearer after working through an example. Consider a hypothetical reclamation project with a contract duration of 8 months. Upon commencement the Contractor is to carry out preliminary site investigation of the seabed and then prepare a detailed dredging layout plan. Once this is approved by the Engineer, the Contractor is to proceed with dredging, followed by construction of a rock filled seawall. The final stage is to place sand fill behind the seawall up to formation level. The corresponding programme is set out in Figure-3 below.
 
 
Now consider the situation as at the end of Month-2. Say that site investigation and drawing preparation proceeded as-planned. However, whilst generally accepting the submitted dredging layout, the Engineer would not formally approve the drawing until he had ‘checked a few things’. In response the Contractor decided to proceed with dredging and make any minor amendments (if necessary) after final approval was received. By doing this the Contractor was able to progress dredging at the planned rate so that up to the end of Month-2 it was around 30% complete, and there was no actual delay to dredging.
The status at the end of Month-2 can therefore be shown in 2 ways. The first is shown in Figure-4a (using Progress Override) and 2nd in Figure-4b (using Retained Logic).
 
 
The most sensible view of status at the end of Month-2 is clearly that shown in Figure-4a. As soon as dredging commenced it became critical, and the ongoing late ‘formal’ approval of the dredging layout dropped off the critical path. The alternative view, shown in Figure-4b, is that progress of dredging was being critically delayed by late approval of the layout drawing. Moreover this delay already amounted to around 10 days. In this situation therefore, the Progress Override option provides the most sensible outcome.
 
Let’s now take the example a bit further. Assume that the dredging layout is finally approved early in Month-3, but the remaining dredging work is immediately suspended by the Engineer pending a comprehensive design review. Moreover this suspension remains in place up to the end of Month-6. Shortly after dredging is suspended, and with knowledge that this might last for several months, the Contractor carried out some preliminary filling work at the seawall trench. This was done to protect the small section of dredged trench from damage and siltation, and amounted to only 2% of the total filling. The 2 possible outcomes after rescheduling the programme are shown in Figure-5a (using Progress Override) and Figure-5b (using Retained Logic).
Figure-5a and 5b give a very different result compared to Figure-4a and 4b. This time the Retained Logic option produces the most sensible outcome (see Figure-5b). The occurrence of out-of-sequence filling in these circumstances should not override the prevailing logic. Clearly the critical issue affecting progress from the start of Month-3 to the end of Month-6 was the suspension to dredging, and this governed the earliest projected date for completing the Works.
The table below compares the different outcomes produced by the Retained Logic and Progress Override options. It is submitted that the most sensible result is that the 2 events have caused critical delay amounting to 110 days. Moreover this outcome is achieved by using a combination of the 2 scheduling options. Using only the Progress Override option underestimates the impact, whilst the Retained Logic function overestimates it.
 
The example above is a reminder that slavishly using one or other of the 2 scheduling options discussed here can lead to errors in defining the critical path, as well as the extent of critical path delays. If not treated carefully, this simple programming function can have significant consequences with respect to entitlement to time and money.
Continue reading
10101 Hits
0 comments

Make report to Show only some WBS in Gantt chart

Make report to Show only some WBS in Gantt chart

 

2

 
Continue reading
4101 Hits
0 comments

What does The Carat (^) Symbol next to the Resource Price/Unit in Primavera P6 mean?

 
 

What does The Carat (^) Symbol next to the Resource Price/Unit in Primavera P6 mean?

1
 

When we assign resource to activity, sometime we can see a carat (^) symbol appear in Price/Unit column.

Continue reading
16096 Hits
0 comments

Why is P6 the software tool of choice for planning?

Primavera allows for top level planning as well as being ideal for managing the intricate details. This enables project managers, planners, planning controllers and other associated professionals to have instant access to all the project information they require at the touch of a button. It also means that all parties can be kept updated within one system, reducing duplicate information and keeping everyone in the loop.

There are number of other P6 features which makes it unique and recommended tool for planning and will make a planner or a project manager life easier by providing structure, access to information, monitoring progress and reporting mechanisms capability:-


 

Perfect for Project-focused Business functions - Primavera project portfolio management solutions are also suited for any company with project-focused business functions such as Construction program management, Capital asset maintenance,  Software system development and deployment, Enterprise investment portfolio management, Resource productivity and capacity planning, Product design, manufacturing, and implementation program management etc.

High performance project management - The recognised standard for high performance project management Primavera handles large-scale, highly sophisticated and multifaceted projects. Organise projects of up to 100,000 activities with unlimited resources and an unlimited number of target plans. Enhanced fiscal accountability to customers to identify common scheduling pitfalls and quickly remedy them. Track costs and gain insight into change orders and forecasts. P6 allows top level planning as well as being ideal for managing the intricate details. All the parties can be kept updated within one system, reducing duplicate information and keeping everyone in the loop. Primavera P6 Implement sound risk management principles, reducing the risks associated with projects such as delays in delivery and resource shortages. It reduces risks of schedule inconstancies, errors, or overrun issues. P6 helps identify and mitigate risks in the course of planning and controlling projects. 

Optimized Resources – It helps to carefully monitor resource availability and adjust scare resources to meet project demand. Furthermore, the software can help identify areas where resource cost may be reduced by analysing trends and costs. Primavera has resource levelling option which is very handy in optimizing resources.

Enhanced visibility – Everything is included in the programme so you can easily see what’s going on with a project at any time.  It allows all data to be entered, tracked and analyzed in one location. An unified project view for all participants and stakeholders.

Improved Forecasting – Having up to date information means that you are able to clearly see where there is likely to be overbooked or underutilized resources and can plan accordingly. As the project progresses, the project may require additional resources/activities to meet stakeholder demand. Within P6 schedulers can create forecasts for resources, activities and other project needs.

Instant and Quicker access – Keeping track of progress with time and resources and getting information whenever and wherever needed. Usage of only one system which gives you all the information needed which saves time and cost by not having to refer different tools.

Tracking Features – The tracking features of Primavera P6 allows to rapidly generates wide range of reports

Enhanced Communication – Projects spanning large geographic areas requires hundreds of workers, engineers and many contractors. Primavera P6 enables executive staff to communicate with other stakeholders easily. Furthermore, notes can be made to the schedule in the software to ensure all users see the message.

Improved Collaboration – Since communication is enhanced throughout a project, it’s easy to see how improved communication translates into improved collaboration. 

Gives Employees user access in schedule creation/update- Site Engineers can create schedule, turn in timesheets and update progress.

"This blog is writen by Vishal K Singh, ProjCon. ProjCon is exclusive, niche and rapidly growing Project Controls Consultancy offering innovative, advisory, implementation, technical and training support to our Clients. Our consulting services enable effective use of Project Controls technology, methods and practices for EPC (Oil & Gas, Power, Defence and Infrastructure) industry customers worldwide.

Our comprehensive array of products and services provide powerful, affordable solutions to virtually all aspects of the Project Controls. Contact us to find out how we can help you to build/strengthen your Project Controls capability. For more info, visit us on www.ProjCon.co.uk"

Continue reading
22173 Hits
0 comments

How to modify Activity ID Suffix in Primavera P6

How to modify Activity ID Suffix in Primavera P6

Continue reading
9742 Hits
0 comments

Primavera become slow – Limitations of SQL Server Express Edition

Primavera become slow – Limitations of SQL Server Express Edition

1
 

A lot of people are using Primavera with SQL Express database. And after using Primavera for a long time, we may realize the software become slow.

Our database is become bigger and bigger. And the slow performance is may be because of the limitations of SQL Server Express Edition, not because of the CPU or RAM.


 

1

 

Based on the table you can see SQL Express only support:

  • 1 CPU
  • 1 GB RAM
  • 10 GB for database size.

No matter how your PC is strong, it only take a few resource from it.

So you may consider buy SQL Standard Edition before upgrade your PC hardware.

Continue reading
18657 Hits
0 comments

Automatically update progress in Primavera: The difference between Apply Actuals and Update Progress

2
 

In Primavera, when you need to make a quick update of project (Let’s say everything goes as it’s planned) we have 2 ways of automatically update progress:

  • Apply Actuals

Update Progress


 

1

Here I will only explain what is the difference between these 2 options.

The Apply Actuals function will update any activities with the “Auto Compute Actuals” checkbox marked…

PATTLNK_12212005_160054-cwilkinson-image

…whereas the Update Progress (Progress Spotlight) feature will update activities which fall within the spotlighted region regardless the status of “Auto Compute Actuals” checkbox.

PATTLNK_12212005_155938-cwilkinson-image

And this is the rule when Primavera automatically apply the Actual (in both option):

  • Apply an Actual Start to all Activities that have a Planned Start < Data Date. The Actual Start is set to the Planned Start.
  • Level of Efforts and WBS Summary activites get there dates from other activities.
  • Planned Finish is not changed.
  • Calculates Remaining Duration as the Early Finish-New Data Date.
  • Calculates Actual Duration as Original Duration-Remaining Duration.
  • Calculates Actual Units as Activity % Complete * At Complete Units..
  • If Planned Finish is < Data Date, then an Actual Finish will be applied. The Actual Finish is set to the Planned Finish.
  • Actuals are subtracted from Budgeted values to calculate Remaining values.
Continue reading
21109 Hits
0 comments

Graphing a P6 Resource S-Curve in Excel

Graphing a P6 Resource S-Curve in Excel

 

image020

 

 

Continue reading
20180 Hits
0 comments

How to Download Primavera P6 Professional

 
 

How to Download Primavera P6 Professional

 

Go to the following website: https://edelivery.oracle.com

 

1

Continue reading
23416 Hits
0 comments

Convert Microsoft Project MPP to MPX to import to Primavera

Convert Microsoft Project MPP to MPX to import to Primavera

 

 

Nowadays, Microsoft Project save file as MPP format. However Primavera allow to import file as MPX format.

So, here is the tool help you to convert MPP to MPX.

https://drive.google.com/file/d/0ByHnieTJNwKGdGVybE5LaElOcnM/view?usp=sharing

Continue reading
26204 Hits
0 comments

Categories

Search

Australian Open Learning Pty Ltd t/a Project Controls Institute, Australia | RTO CODE :45806