Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Linking Progress

11 replies [Last post]
Dean Grimes
User offline. Last seen 11 years 27 weeks ago. Offline
Joined: 30 Nov 2011
Posts: 3
Groups: None

First post to the forum so please bear with me.

 

I am trying to link % complete on two or three seperate tasks but not having a lot of success.

I want to be able to enter the % complete on one bar but at the same time it enters the same the summary bar then updates another summary bar elsewhere.

 

the reason behind this is that i am running a contract programme and a target programme, however i am only doing the weekly updates against the target programme although i need to show the % complete on the Contract programme.

 

if you can help it would be a great help

 

Dean

Replies

Johannes Vandenberg
User offline. Last seen 1 year 11 weeks ago. Offline
Joined: 21 Jan 2010
Posts: 234

Hi Dean

To work and update two schedules at the same time is quit common in P6. The main reason is often that variations are already implemented but not yet approved.

Suggest to proceed as follows;

  • Baseline the schedule, when completed, and call this the "Contract Program" 
  • Note that % completion on duration type can be rolled up to a higher level.
  • Units and Physical % completion cannot be rolled up.
  • As and when it becomes necessary update it with durations, and or labor units.
  • When ready, baseline the schedule and call it "Target Program".

So, now their are two "Programs" in the same schedule.

Updating the schedule

  • Update the schedule say on a weekly basis. Their is only one schedule!

Analysis an reporting

  • Assign the baseline "Contract Program" to the schedule. Note, this is not the same as making or setting the baseline.
  • Now you can apply all the CPI, Performance, Schedule % completion, Schedule Variance you desire against the Contract Baseline. 
  • The next step to assign the Target Program to the schedule and report the against the Target Program.

Trust this helps

Johannes

 

 

 

 

Anoon Iimos
User offline. Last seen 3 years 16 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422

Hi Mike,

It's quite confusing that (you) being the promotor of Finish-to-Start (FS) only, and it seems that you don't care about the day-to-day activities (as a delay analyst)?

If I remember correctly, you also mentioned that "disruption" starts from "upperfixer" or something (the one who climb the ladder fixing something).

I agree with Vladimir, copy and paste will only work on exactly the same program (twins).

 

Kindly enlighten me please?

Mike Testro
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4420

Hi Vladimir

Anything on a spreadsheet can be copy pasted into Powerproject and back again.

Regarding proportionality I really don't know, my work as a delay analyst does not involve day to day project time control.

Best regards

Mike Testro

Hi Mike,

thank you, I understood your approach and expect that it is clear to Asta users.

I expect that by copy-paste you import not only %complete but also all other data including actual and remaining work, actual and remaining duration, actual and remaining material requirements, actual and remaining costs, etc. I hope that Asta does not make all these data proportional to %complete?

Best Regards,

Vladimir

Mike Testro
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4420

Hi Vladimir

If the two layouts are different I have developed a method in the spreadsheet to solve the problem.

The ouput data is in one sheet with unique Task ID's and the input data is in the other sheet with a Vlookup formula that picks up the data with reference to the same Task ID.

The result is copy paste to the output programme.

This works best with Lotus 123 and Asta Powerproject.

Best regards

Mike Testro

Anoon,

Mike explained what did you mean by stating that there is a need in the same layouts. With copy - paste technique it is necessary.

Mike Testro
User offline. Last seen 23 weeks 1 day ago. Offline
Joined: 14 Dec 2005
Posts: 4420

Hi Dean

Welcome to planning planet.

When you enter a percentage progress in a task the value rolls up to the upper level summary bars.

You can switch this off in the progress column dialogue box by clicking off the rolled up values.

If you need to enter the same data to two programmes that have the same format and the tasks are in the same sequence then just copy and paste between the columns.

Best regards

Mike Testro

Anoon,

layout does not matter.

I don't know how it is done in Asta, in Spider Project actual data of all activities will be imported and project status will be shown in any layout.

But it is necessary activity and resource codes to be the same in both versions.

Anoon Iimos
User offline. Last seen 3 years 16 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422

Vladimir,

It's the same thing.

What if the two versions were completely different (i.e. in layouts)?

Anoon,

the question is about moving actual data from one project version to another.

I don't know how it is done in Asta, let's wait for the answers of Asta experts.

Regards,

Vladimir

 

 

Anoon Iimos
User offline. Last seen 3 years 16 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422

how can % complete affect tasks having no relationships?

you should define logic-links.