Procedure in P6/6.2 for to update on a similar file.
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
Hi Mohammed,
My email is [email protected]
Regards.
Thank you Mr.Arnold,
I did all those consecutive steps as per your reply, but the out come is nil.
Could you please send me your email id so that i can forward my .xer file to you .
my email id is [email protected]
Hi Mohammed,
If I understood you, you are working with the same file with the sub-contractor. Meaning the one he is updating came form your master plan, with the Activity ID, Activity Name, WBS, so on & so forth. Only the difference is the Data Date, Actual Start & Finish, % Complete, Units & etc...
If this is the case, all you have to do is the following:
1. Export those sub-contractor updated activities to Excel sheet.
2. When you are trying to export from P6 to spreadsheet, use only the Export Type as “Activities”.
3. From default, add the Actual Start & Finish and Physical % Complete or Performance % Complete however, these two % cannot be modified in Excel sheet. You have to create a UDF and run the Global change or if not you can do it manually.
4. The WBS Code must be the same with the one you have. WBS Code is the combination of Project ID and each sequence number of the WBS Code.
5. Afterwards, import the said file to P6 then select schedule (F9) by changing the data date.
Let me know if you did it. Otherwise, send me your .xer file and I will help you how to do it.
HTH.
Arnold