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.

Activity usage spreadsheet

2 replies [Last post]
Mon, 2006-06-19 10:37
Shahzad Sikandar
User offline. Last seen 5 years 45 weeks ago. Offline
Joined: 1 Feb 2006
Posts: 67
Groups: None
Hi guys,

Do any one how i can transfer activity usage spreadsheet items to excel? Lets say i need following in my excel.

1.resource name and its associated activity
2.Bugeted units
3.Planned start and finish of resource
4.start and finsih of activity
Top

Replies

Fri, 2006-09-01 06:42
#1
Kym Lesinski
User offline. Last seen 17 years 30 weeks ago. Offline
Joined: 31 Aug 2006
Posts: 15
Groups: None
I find the easiest way to get info into excel is using a report. They’re very useful once you figure out how to set them up.
Top
Mon, 2006-06-19 21:20
#2
Julie Scully
User offline. Last seen 16 years 25 weeks ago. Offline
Joined: 9 Nov 2005
Posts: 25
Groups: Petro-Chem / Oil & Gas
It may be easier to use the resource assignments, which is very similar to the activity usage spreadsheet. Once you have all the columns etc in you layout, you can simply copy and paste the resource assignments. I don’t think this option is available in the activity usage spreadsheet. The other option is to create a report and output it to a csv file and open with excel.

HTH
Julie
Top