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.

Resource Table & Resource Profiles export to Excel

7 replies [Last post]
Thu, 2005-07-14 03:42
Kris Harry
User offline. Last seen 13 years 8 weeks ago. Offline
Joined: 4 Oct 2004
Posts: 47
Groups: None
Hi guys,

Can anyone tell me if Resource Table and Resource Profiles obtained from View can be exported to Excel.

Kris
Top

Replies

Wed, 2006-07-12 02:47
#1
Svein Myklebust
User offline. Last seen 15 years 51 weeks ago. Offline
Joined: 27 May 2006
Posts: 25
Groups: Petro-Chem / Oil & Gas
It’s easy?
No, exporting is not easy with this program.

Never use Word og Word Pad as described over.
Some times you get formats that you dont expect.

Notepad is the perfect tool for this.
Washes away all formats.


Sam Bell
P3 only when necessary
Top
Tue, 2006-07-04 10:22
#2
Leong Hong Phua
User offline. Last seen 6 years 45 weeks ago. Offline
Joined: 17 Mar 2003
Posts: 5
Groups: None
If you are using P3ver3.1, go to "Tools" -> "Tabular Report" -> "Resource" -> "Loading...". Modify one of the standard report to your desire, then on the "Format" tab check the "Export report in CSV format to the file" and type in a file name. You will be able to open the file in MS Excel.

Have fun!
Top
Sun, 2005-11-06 10:52
#3
Ruby Dasan
User offline. Last seen 12 years 4 weeks ago. Offline
Joined: 4 Nov 2005
Posts: 8
Groups: Petro-Chem / Oil & Gas
Sorry, I meant resourse loading reports, not profile.

Ruby
Top
Sun, 2005-11-06 08:38
#4
Ruby Dasan
User offline. Last seen 12 years 4 weeks ago. Offline
Joined: 4 Nov 2005
Posts: 8
Groups: Petro-Chem / Oil & Gas
It is Easy.

First select the report. Copy/Paste to MS Word and from Word copy/Paste to Excel. You will get a tabular report

Ruby
Top
Fri, 2005-07-15 00:12
#5
Bill Guthrie
User offline. Last seen 8 years 23 weeks ago. Offline
Joined: 14 Mar 2005
Posts: 262
Groups: Petro-Chem / Oil & Gas
Gentlemen
For exporting resource table, please use the file
projmod.xls, that comes with some installation disc.

IF you cnnnot find it in your progs folder tell me and will send to you
send a personal message with your email address.

cheers bill
Top
Thu, 2005-07-14 04:04
#6
Steven Oliver
User offline. Last seen 11 years 47 weeks ago. Offline
Joined: 8 Nov 2002
Posts: 313
Groups: None
I hate to be negative, but no.

The (IMHO) easiest method is to use one of the cost/resource reports which export in wk? format which can then be read by Excel. I cant remember which is the better report, its something the cost loading report.


HTH
Top
Thu, 2005-07-14 11:11
#7
Shahzad Munawar
User offline. Last seen 9 years 24 weeks ago. Offline
Joined: 2 Jul 2003
Posts: 551
Groups: None
It is not possible to export resource table and profile by your stating method so better to make file *.wk and export to excel.
Top