Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Changes of Activity Relationships

28 replies [Last post]
Albert Balogo
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 9 Jun 2008
Posts: 44
Hi Planners,

In P3 program, during review of contractor’s updated program, how do we know that there are no replacement of relationships between current and baseline program? Say 10,000 or more activities. Not using manual checking, is it possible in P3 to generate the report instantly for the differences of relationship?


Thanks in Advance,

Albert

Replies

Osama Warid
User offline. Last seen 9 years 29 weeks ago. Offline
Joined: 5 Mar 2007
Posts: 40
Groups: None
Greetings for all
I think the best to follow up the up date by applying the information to the base line and to compare the resulte to the submitted updated schedule if there are any difference between the base line result and the submitted one the consultant have the power to let the contractor to clarify the different result
regards,
Zq qz
User offline. Last seen 12 years 13 weeks ago. Offline
Joined: 6 Jun 2003
Posts: 163
Groups: None
Changing relationship is very important if you do this in good faith and serve the purpose of the shedule, for the project team to use in their day to day activity. if not "just changing to hide something" , the shedule become un-meaningful. sooooo what to do......????
Gary Whitehead
User offline. Last seen 4 years 45 weeks ago. Offline
When performing TIA, would you not apply progress & notified changes to baseline? If so, un-notified changes would have no impact on the assesment?

Regards,

Gary
Albert Balogo
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 9 Jun 2008
Posts: 44
Gary,

The reason why the contractor’s are trying to make a changes is to hide the delayed activities and to shrink the program. As a consultant, any changes in baseline program should put on record for possible delay of the project. At the end of the contract period, contractor would claim their EOT.

Now, these recorded data are essential during Time Impact Analysis.

Regards,

Albert
Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Gary:

I agree it is short-sighted, eventually most probably will backfire. But unfortunately some Contractors will do it as not all inspectors and owner’s reps are expert at CPM scheduling, if they perceive so maybe they will take the chance the job do not ends in court and eventually on the hands of forensic experts.

The Owner will expect the inspector and his rep. will raise the flag as soon it happens, otherwise he might believe them negligent and short of due care. Here a good utility will be of value.

In occasions while looking to solve issues on out-of-sequence the Contractor might even lose track of your own changes and forget to disclose. Here a good utility will be of value.

Gary Whitehead
User offline. Last seen 4 years 45 weeks ago. Offline
So what are the reasons a contractor would want to make changes without the client knowing?
Obviously any EOT claim would be analysed in detail vs the baseline so it can’t be that.
Is it just to get the client off his back during the project, hoping he can recover any delay before he’s found out? That seems short-sighted to me.

Rafael:
It’s not often I get called a gentleman, so thank you for that.
Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Arnold,

Thanks, your option, as well as Digger within P6 is not equivalent to the original Digger for P3, it is not an acceptable option for me. It seems that everything touched by the P6 developers gets rotten.

I will keep looking elsewhere.

Albert,

Follow the link and do a search on “claim digger”, “project management”, “ cpm scheduling”, "P6" ... maybe you will get lucky and find a few technical references. On the internet you will find a few interesting file sharing / hosting services for free. Just make a good use of these.

http://www.4shared.com/

Some files are in .rar file types for these you can download the free utility IZArc from their site.

http://www.izarc.org/index.html


Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Rafael,

It works with me in P6.

If you are going to open the spreadsheet, it will prompt to "Disable or Enable Macros" & More Info.

1. Select the Enable Macros.
2. Select "Load XER file...and select the baseline programme.
3. When done, go to file & save as with different name.
4. Open again another file using parser & builder, this time, select the updated programme and save as..
5. You can compare the two file files using the Vlookup command in Excel.

Note: You must first open the baseline programme or updated current programme using Primavera window and export the project. This are the files that you are going to load to parser & builder.

Let me know if you have done it.

Regards,

Arnold
Christian Adrian ...
User offline. Last seen 4 years 37 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
Hi Albert

For a 10,000 activities I don’t think so.. you would really need a digger to do the job easily, and the contractor is responsible to let the client know of his changes in order to expedite and/or do the job especially if those areas of concern would involve the client...

Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Arnold:

I downloaded the spreadsheet; it works with the outdated P5 format, does not work with the outdated P6.0 nor with its updates P6.1, P6.2 or in between Service Packs.

I got a listing of the database field values, the database tables, I believe.

Because the spreadsheet came with no instructions I wonder how it will manage an outdated 100,000 activities schedule P3 was able to handle and P6 insists it is not enough.
Shall I apply the spreadsheet to the two projects to be compared and then make a field by field comparison of each field? This would be somewhat insane. This cannot be it; can you give me some insight? Definitively I am doing something wrong.

Do you know how a Primavera P6 developer laces his right foot shoe? He stand up in front of a desk, put his left foot on top of the desk, keeps his right foot on the floor and then he bends to lace his right foot shoe.

I hope you understand my frustration, sorry don’t take it personal, blame it to me but don’t leave me in ignorance.

Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147

You are welcome.

Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Arnold,

Thanks. I just downloaded the file; at first glance using xer files seems like the correct approach.

Rafael
Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Rafael,

Please follow the link:

http://knowledgebase.primavera.com/attachment/PATTLNK_632006_536-xerFile...

Albert,

We have a copy of P3 Claim Digger with Serial No. but I cannot give you because this is copyright materials owned by the company. Sorry for that.

Try to check at http://knowledgebase.primavera.com/

Regards,

Arnold
Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Arnold,

Although I am in the Contractor’s side I am interested in a tool for P6 that work as efficiently as P3 Digger. Eventually I might be forced to swallow P6.

Can you give me a link for "PATTLNK_632006_536-xerFileParser&Builder.xls". I do not have Primavera Support Contract and don’t believe I will ever pay for it unless a client implements a Network or Web installation.

You can use rapidshare.com free account to upload the file so we can have direct access to it.

Thanks in advance.

Albert,

You know the street; it is a jungle out there, maybe Garry is too much of a gentleman.
Albert Balogo
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 9 Jun 2008
Posts: 44
Gary,

As a consultant planner one of my duties is to monitor and to optimize the contractor’s program. I can’t wait the completion of the project to verify the changes. As you know a single changes would have a huge impact to shrink the program. You know the changes are very easy to hide specially the the program with multiple activities. Baseline is usefull in comparisson with current program and the current Critical Path is not always critical as program continues updating.

You know Gary I worked in contractor side before and I’m doing it without knowing by the consultant. They don’t know that I did manipulated the program to avoid and/or minimize the delayed.



Gary Whitehead
User offline. Last seen 4 years 45 weeks ago. Offline
Albert,

If the contractor lies about changes to hide delay, he will be found out at the end of the project. and if he has changed the programme to make it look like client is responsible for the delay, it would be a simple matter to check the logic etc of the ’actual’ critical path for un-notified changes vs the baseline.
Albert Balogo
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 9 Jun 2008
Posts: 44
Hi Christian,

That’s Great, if the contrator’s are to follow the agreement. How about, if the contractor’s program is entent to cheat, specially the program is delayed. they will not tell you for sure. Any easies way of checking these changes?

Hi Arnold,

You mentioned that Claim digger is a separate tool in P3.What kind of tool is it? is it packaged with p3 licensed sofware?

Regards,

Albert
Christian Adrian ...
User offline. Last seen 4 years 37 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
Gary

When I was working on my previous project The Engineer has implemented such system, there was an instruction to report on all changes made to the current updated programme (eg. added/deleted activities, modified relationships, etc..) and it has to be included in every update submission.. to me I see this as a benefit to the client and contractor..
Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
For P3, P4/P6
http://scheduleanalyzer.com/sa_brochure.htm
For MS Project the following also provides a schedule comparison tool.
http://www.steelray.com/spa.php

Do any of you have these tools?
How they work?
I believe they should be better than the comparison tools supplied within the software.

Please note that while Claim Digger can handle Changes of Activity Relationships not necessarily Changes in Resources and Calendar Details when comparing differen versions (not baselines) of the same job.

I would have some reserves about the claims by the software vendors themselves the same way I would about the Contractor disclosing everything even under oath. I am law abiding, but in no way naïve. As a contractor those tools would be useful when making changes to the schedule specially when solving issues for out-of-sequence. Good to know, sure I won’t tell the Owner’s rep. I do have these tools, it is his responsibility to make sure we don’t cheat .................(law abiding, are you sure?).


Gary Whitehead
User offline. Last seen 4 years 45 weeks ago. Offline
I was thinking about this very topic the other day, for a client who is about to let a £100m+ project.

I was thinking of advising them to put a clause in the contract which requires the contractor to submit a change log with each programme update, detailing what changes were made (to logic, durations, planned resources, constraints, etc), the reason for the change, when the change was made, and who authorised it.

I’m sure the contractor won’t like it, but is there any legitimate reason to object to standard change control practices being applied to the programme? Has anyone used such a system before?

Cheers,

Gary
Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Gary,

That’s great idea..We need to follow the baseline programme without changing the logic of the update....etc.

Regards,

Arnold
Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Rafael,

As I am in the Consulting side, I am also facing some difficulties with regards to the comparison of baseline and updated. Our Contractor submitting the weekly report however, I cannot check all the changes they made.

What I did, I tried to use Excel sheet with the help of Visual Basic Application and the combination of Claim Digger and Microsoft Access. But it is not easy to do that.

Did you ever try this "PATTLNK_632006_536-xerFileParser&Builder.xls" you can use this as a reference for checking.

Regards,

Arnold

Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Arnold,

I do have MS Project but rarely use it; maybe I can figure it out if no response for this particular issue is posted.

Since I don’t have P6 I appreciate your response. I understood from your response that within P6 you can only compare jobs within a single database, this is not necessarily an issue, but I still have some questions about how to audit submitted files to make sure no unforeseen changes are introduced.

Suppose for a single job you have the monthly update for month no 6 and for month no 7 and you want to compare both files to make sure no hidden changes were made; to work hours, to calendar days, to resources and so on. I need to compare not only the baseline fields but logic, calendars and resources files. I believe that by naming differently the job versions you can load them to your database and compare one against each other but when you compare calendars and resources as well as other fields the report will tell you all are different. What if you compare two jobs exactly equal, the same version different name? The report should disclose there are no differences.

Sorry it is very difficult for me to express myself but all I got is memories from P3e various years ago plus some literature on P6. Because you are a P3 and Digger for P3 user having access to P6 you can make the comparison I am not able to do. To me it is of particular importance because as a Contractor if I know in no easy way the Owner will notice this could give me an advantage, it is good to know. Maybe I will even switch to P6, in this way most probably he will never know.

Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Rafael,

With Digger in P3, there is a calendar & original duration option but in P6 doesn’t have, only duration.

In P6, only the project can be compared not the database.

Resource Assignment, cost & units can be compared between the updates and the baseline.

I am sorry, I am not using MS Project. I don’t have any idea.

Regards,

Arnold
Rafael Davila
User offline. Last seen 1 hour 33 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Arnold,

With Digger in P3 you can pinpoint variations in workdays within each calendar. Can you do that within P6 and MS Project comparison tools?

With Digger in P3 you can compare updates beteween databases as each P3 Job is in a separate database. Can you do that within P6 and MS Project?

In P6, can the software pinpoint differences in your resources among different updates without getting confused and identifying all as different? Seems to me Claim Digger within P6 is strong at comparing baselines but not for comparing update file submissions.

These are questions that have been in my mind for a while; I would appreciate feedback from those knowledgeable of P6 and MS Project.

Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Albert,

In P3, "Claim Digger" is a separate tool use to compare between the baseline and the current schedule.

In P6, this is already under the Tools --> Claim Digger.

Regards,

Arnold
Albert Balogo
User offline. Last seen 9 years 25 weeks ago. Offline
Joined: 9 Jun 2008
Posts: 44
Hi Arnold

Arnold perhaps you are right. But I dont know what is "Claim Digger" is it P6 or P3? In the contract agreement P3 is the only software to be used in planning.

I just mentioned this becouse currently I reviewing the contractors program with more than 9,000 activities, it’s impossible for me to review all activities before due date of report.

Thanks Arnold,

Albert

Arnold Puy
User offline. Last seen 9 years 10 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Hi Albert,

Why don’t you use the "Claim Digger"?

Regards,

Arnold