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.

Regarding Importing Data from P3 to Excel

1 reply [Last post]
Suresh Devarajan
User offline. Last seen 7 years 45 weeks ago. Offline
Joined: 11 Jul 2004
Posts: 24
Groups: None
Hi All,
Thank you all for your response to my previous question. Now I am trying to man hour load the schedule. I have concrete budgeted quantity entered in the schedule as a separate resource. I wanted to transfer the resource and it’s budgeted quantity to another schedule.I know I cannot copy all the activities and paste them on the new schedule as the durations vary between the two schedules.
Please let me know how I can transfer the resource id and the budgeted quantity to the respective activities from one P3 Schedule to another.
Thanks,
Suresh

Replies

MK TSE
User offline. Last seen 2 years 16 weeks ago. Offline
Joined: 27 Feb 2002
Posts: 552
Groups: None
On P3 installation CD, there is a folder "RA". In the folder, you’ll find some sample XLS to extract/import P3 data. The file you are looking for is Project.XLS. It allows you to extract whole Resources Library from one P3 onto spreadsheet, review the spreadsheet and import it to another P3 project.

(btw, this topic be in P3 forum category, not in this one)