Modified Resource Usage View

[Albert]

I am trying to create a modified version of the resource usage view wherein
the actual work hours would be displayed by Resource, Tasks assigned to the
Resource, and date when the actual work took place. Sofar I am not
successful, the actual work hours would only be displayed on a cummulative
total basis. Need your help in trying to figure this out. I intend to
export this modified view to excel format as well.

Thanks

 

[Gérard Ducouret]

Hello Albert,

Right click a yellow cell in the right hand pane of the Resource Usage view,
and select Actual Work.
To export the timephased data to Excel, display the Analysis tool bar and
click the "Analyse timescale data to Microsoft Excel" button.
Hope this helps,

Gérard Ducouret

 

[Albert]

Thanks for the quick response. However this does not quite satisfy what I am
looking for. You see the excel generated by your suggestion provided me with
the following report format.
14-Nov-05 15-Nov-05 16-Nov-05 17-Nov-05 18-Nov-05
Resource A
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource B
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource C
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource D
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource E
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs
Resource F
Actual Work 8 hrs 8 hrs 8 hrs 8 hrs 8 hrs

The format that I need would look like this:
14-Nov-05 15-Nov-05 16-Nov-05 17-Nov-05 18-Nov-05
Resource A
Task 1 0 0 2 hrs 3 hrs 0
Task 2 8 hrs 8 hrs 6 hrs 5 hrs 8 hrs
Resource B
Task 2 0 1 hrs 1 hrs 0 2 hrs
Task 3 2 hrs 0 0 1 hrs 0
Task 4 6 hrs 7 hrs 7 hrs 7 hrs 6 hrs
Resource C
Task 4 2 hrs 3 hrs 0 0 8 hrs
Task 5 3 hrs 3 hrs 3 hrs 0
Task 6 3 hrs 5 hrs 5 hrs 5 hrs 0
Resource D
Task 2 4 hrs 4 hrs 4 hrs 4 hrs 0
Task 3 4 hrs 4 hrs 4 hrs 4 hrs 8 hrs
Resource E
Task 4 3 hrs 2 hrs 6 hrs 0 0
Task 6 5 hrs 6 hrs 2 hrs 8 hrs 8 hrs
Resource F
Task 1 2 hrs 0 8 hrs 8 hrs 8 hrs
Task 3 1 hrs 0 0 0 0
Task 4 2 hrs 0 0 0 0
Task 5 3 hrs 8 hrs 0 0 0

or the following format may do as well
Name Task Name Date Actual Work
Resource A Task 1 11/16/2005 2
Resource A Task 1 11/17/2005 3
Resource A Task 1 11/18/2005 1
Resource A Task 2 11/14/2005 8
Resource A Task 2 11/15/2005 8
Resource A Task 2 11/16/2005 6
Resource A Task 2 11/17/2005 5
Resource A Task 2 11/18/2005 7
Resource B Task 2 11/15/2005 1
Resource B Task 2 11/16/2005 1
Resource B Task 2 11/18/2005 2
Resource B Task 3 11/14/2005 2
Resource B Task 3 11/17/2005 1
Resource B Task 4 11/14/2005 6
Resource B Task 4 11/15/2005 7
Resource B Task 4 11/16/2005 7
Resource B Task 4 11/17/2005 7
Resource B Task 4 11/18/2005 6
Resource C Task 4 11/14/2005 2
Resource C Task 4 11/15/2005 3
Resource C Task 4 11/18/2005 8

Any suggestions?

Thanks