Forum Discussion
REPORT (Resoruces assigned vs Resources available)
Need Urgent help please. in Project, I need a way of tracking OR Displaying Resources available vs Resources assigned and remaining availability (for each resource). I've searched the Reports and ca...
This won't give you exactly what you asked for but it's very close. Look at the Resource Usage view. Set the Details to display, Work Availability, % Allocation and Remaining Availability. You will be able to see that for each resource and for each assignment for that resource.
If you require the exact parameters you specified, the data will need to be exported to Excel and formatted there. Interestingly enough, I just wrote a macro for another user who had a very similar request. Here is the opening user interface for that macro.
Hope this helps.
John
- John, i think i'm getting what i need from the Resource Usage View now! Big Thank you! Have a Blessed Week dude!
- Will,
You're welcome and thanks for the feedback.
John
- I figured out how to add to the Details! so disregard my question on that. thanks
- Would you give me access to the your Macro mentioned?
- it does help. thanks. However, I don't see % Allocation as an option. Is there a way to add to the Details options?
Good day John! Thank you very much for your reply and insights. i will give this a try.
Have a great day!
Willard
