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.

Exporting Resource Histrogram P3e to Excell

4 replies [Last post]
Wed, 2007-08-15 12:02
Minhas Shaikh
User offline. Last seen 13 years 31 weeks ago. Offline
Joined: 30 Mar 2007
Posts: 44
Groups: Petro-Chem / Oil & Gas
Hi Planners,
Can we export resource histrogram from p3e to excel. If yes please write down steps. and if no please explain if you can.
waiting for your reply.
Minhas
Top

Replies

Thu, 2007-08-23 07:05
#1
Brad Lord
User offline. Last seen 10 years 15 weeks ago. Offline
Joined: 27 May 2003
Posts: 256
Groups: None
Minhas

the simplest way is to go to resource view

on the right hand side is a spreadsheet view, right click and change the display to Budget Qty or Budget Cost,

one the left and side you can group and sort the assignments how you wish, ie by resource,

once you have the view how you want, do edit, select all, right click and press copy, press cntrl and you then highight all the columns on the spreadsheet view you want to copy, open excel and you can paste the info in, from here you can produce your scurves/histograms

regards

bradley
Top
Wed, 2007-08-22 13:41
#2
Minhas Shaikh
User offline. Last seen 13 years 31 weeks ago. Offline
Joined: 30 Mar 2007
Posts: 44
Groups: Petro-Chem / Oil & Gas
Hi Mukesh and Arvin,
Thanks for your kind reply. But I couldn’t found CSV file format can you please write down the steps for CSV format file.

Further, I tried to open in HTML format but it shows in picture format not in excel.

Thanks again

Minhas
Top
Mon, 2007-08-20 10:43
#3
Mukesh Jain
User offline. Last seen 13 years 30 weeks ago. Offline
Joined: 14 Oct 2002
Posts: 14
Groups: Petro-Chem / Oil & Gas
you directly take output in CSV file format which can be opened in excel directly.
Top
Fri, 2007-08-17 21:33
#4
Arvin Dayday
User offline. Last seen 16 years 33 weeks ago. Offline
Joined: 18 May 2007
Posts: 12
Groups: None
minhas,

yes you can. :) publish it first to html then open your html file in excel and save it in excel format. hope it works.

arvin

Top