Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Resource Usage 1
- Thread starter komark
- Start date
-
1
- #2
- Thread starter
- #3
I guessed you'd want something like that. It can't be *done in* Project, but it can be *driven by* Project.
Display the Analysis toolbar
View | Resources
Click on "Analyse Timescaled Data" button the Analysis toolbar
Answer the Wizard's questions.
This will load Excel and pass the data to it. The resulting graph (which probably isn't what you want) is a grand total but nothing else.
You'll have to massage the data a bit to get rid of blank lines and extraneous colums (it took me about a minute or so).
Then click on the Chart Wizard button and you're off to the races.
Display the Analysis toolbar
View | Resources
Click on "Analyse Timescaled Data" button the Analysis toolbar
Answer the Wizard's questions.
This will load Excel and pass the data to it. The resulting graph (which probably isn't what you want) is a grand total but nothing else.
You'll have to massage the data a bit to get rid of blank lines and extraneous colums (it took me about a minute or so).
Then click on the Chart Wizard button and you're off to the races.
- Thread starter
- #5
I'm not sure what you mean here.
The Project button "Analyze TimeScaleData in Excel" generates an Excel spreadsheet with a (not particularly useful) grand total graph.
Within Excel, displaying the worksheet with the data and clicking on the Excel Chart Wizard button you can customize the chart format and data selection.
You might have to reformat the data into a pivot table and then use the pivot table data as input for the Excel Chart Wizard ... but I'm a beginner when it comes to Excel.
The Project button "Analyze TimeScaleData in Excel" generates an Excel spreadsheet with a (not particularly useful) grand total graph.
Within Excel, displaying the worksheet with the data and clicking on the Excel Chart Wizard button you can customize the chart format and data selection.
You might have to reformat the data into a pivot table and then use the pivot table data as input for the Excel Chart Wizard ... but I'm a beginner when it comes to Excel.
- Thread starter
- #7
PDQBach: Thanks for your earlier reply. The TimeScaleData that comes in from MS Project, you cannot select the project the resource is working. It gives you option of choosing the fields: work, remaining work,percent allocation etc. But nothing about the projects they are working under.
Hmmm ... you're quite right. You can see the Task name field but not the Project field.
Looks like you'll have to do one of two things:
1. Do the "analyze timescale data" on the individual projects, save the individual sheets and then do some manual/vba stuff to tidy them up and consolidate them; or
2. Write the vba to do the export to a spreadsheet yourself.
Neither is particularly palatable, is it? It's been a while since I wrote some vba timescaledata code but, iirc, it was a bit of a slog to get it working.
You could try this: either use VBA or (if you are using P2000+) create a equation on a Text field to concatenate the Project field and the Task Name field and store the result in the Text field; then do a copy and paste from the text field to the Task Name field. Not particularly elegant, I know, and since I don't have P2000 on this machine I can't confirm that it will work.
Looks like you'll have to do one of two things:
1. Do the "analyze timescale data" on the individual projects, save the individual sheets and then do some manual/vba stuff to tidy them up and consolidate them; or
2. Write the vba to do the export to a spreadsheet yourself.
Neither is particularly palatable, is it? It's been a while since I wrote some vba timescaledata code but, iirc, it was a bit of a slog to get it working.
You could try this: either use VBA or (if you are using P2000+) create a equation on a Text field to concatenate the Project field and the Task Name field and store the result in the Text field; then do a copy and paste from the text field to the Task Name field. Not particularly elegant, I know, and since I don't have P2000 on this machine I can't confirm that it will work.
- Status
Similar threads
