It sounds like you are looking for the data from the left side (non-timescaled) portion of the Resource Usage view.
I suggest adding the Start and Finish fields to the table and then select all in the table. (Click the select all area above the ID numbers )
Copy and paste into Excel.
Does that get you what you need?
I'm not sure how you intend to create a RAG status for each "activity". How would you determine what a task status is if more than one person is assigned?
|