Procedure in P6/6.2 for to update on a similar file.
In the Open Standard
Mohammed WasiuddinMember for 17 years 7 months
- Created
- 3
- 1
0
Hi , I am wasim. Can any one explain me on the following concern please! What is the procedure in P6/6.2 for to update on a similar file, when a subcontractor brought to me with his updated activities on the same.
Ex . Suppose i am working as a main contractor , and my subcontractor (MEP) was submitted his updates on the same file . Then how can i import those updated activities of sub contractor(MEP) into my project file so as to illustrate the total progress of the project on XXXX reporting period.
I tried this with Spreadsheet – (XLS) through export and import, but the outcome is zilch. And I perceived in my file(on which I am working as a main contractor) that, not only those updated subcontractor activities as well as the activities which are related to the subcontractor are not present in the WBS node/activity code . It is like hide if any empty.
Thanking you.
Ex . Suppose i am working as a main contractor , and my subcontractor (MEP) was submitted his updates on the same file . Then how can i import those updated activities of sub contractor(MEP) into my project file so as to illustrate the total progress of the project on XXXX reporting period.
I tried this with Spreadsheet – (XLS) through export and import, but the outcome is zilch. And I perceived in my file(on which I am working as a main contractor) that, not only those updated subcontractor activities as well as the activities which are related to the subcontractor are not present in the WBS node/activity code . It is like hide if any empty.
Thanking you.
3 replies
Oldest first- 0Arnold Puy ·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
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?