Importing actual progress in a schedule

K
Kannan CP 👤 Member for 17 years 11 months

Dear All,

Due to a variation order, the approved baseline programme has been revised with the incorporation of the variation item and few changes in the logic as mitigation.

In the last updated programme (without variation), out of 11,000 activities nearly 5000 activities are completed/in progress.

In order to set the revised baseline, is there any option to import the progress of those 5000 activities- from the last updated schedule to the revissed baseline?

Thanks

 

Best Regards

Kannan

Z
Zoltan Palffy 👤 Member for 16 years 10 months

make sure that the actual start TIME an and actual finish TIME is correct

A
Anas Khan 👤 Member for 13 years 11 months

Steve.

I have two programs.

1) original baseline.

2) substantial completion mep program.

What i have to do is, import resources and budgeted labor units from (2) to (1), but when i do this, it does not happen.

I think as they are two different programs, i will have to map the WBS(es) as well.

Can you help me out with this issue?

M
Mohammed Ayaz Maniar 👤 Member for 11 years 9 months

Hi All. Can anyone guide me how to import actual start / actual finish, physical percent complete and duration percent complete from Excel, as I need to transfer actuals from other schedule into revised schedule by excel.

Regards,
Mohammed Ayaz

M
Mohammed Ayaz Maniar 👤 Member for 11 years 9 months

Hi All. Can anyone guide me how to import actual start / actual finish, physical percent complete and duration percent complete from Excel, as I need to transfer actuals from other schedule into revised schedule by excel.

Regards,
Mohammed Ayaz

M
Mohammed Ayaz Maniar 👤 Member for 11 years 9 months

Hi All.

Can anyone guide me how to import actual start / actual finish, physical percent complete and duration percent complete from Excel, as I need to transfer actuals from other schedule into revised schedule by excel.

Regards,
Mohammed Ayaz

R
Robin Clare-Talbot 👤 Member for 15 years 9 months

Hi all,

Raymund has the best suggestion on this. Since they have improved this module in the last 2 revisions, the Baseline Update is a fantastic way to get around some tedious tasks.

I would suggest however, until you are 100% familiar with all the options you have in the Baseline Update, make a backup of your schedule, and try a few things out first.

We have done baseline update on schedules over 100,000 activities, it may seem like your machine, the server and all things Primavera have frozen, but be patient, give it time and it will work.

Z
Zoltan Palffy 👤 Member for 16 years 10 months

I also do as Steve does the key is to export the excel file with the correct columns and then use this as a template for populating and importing back into P6. The TIMES must be correct with the actual start and finish dates. 

S
Steve Eiden 👤 Member for 21 years 8 months

Its a bit complicated but i import AS/AF and % into p6 frequently.The key is to correlate in Excel the list of actual dates by ID (i use vlookup) so that the rows of updated tasks line up by ID with the rows in the xls export from the baseline file. Then i make sure all AS/AF dates are 0800 to 1700 and then I import...works like a charm. This method maintains the WBS codes for all the tasks involved.

Forum Sponsor

Top Posters

Josephus Enot
1 posts
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts