Share via

Utilizing Resource Usage as a resourcing heat map

Anonymous
2017-01-19T04:39:33+00:00

Hi all,

We have a very good resourcing tool that is based on an SSRS report for resource forecasting and heat-mapping (figure 1)

However, this functionality is very similar to using the Resource Usage report within MS Project itself (figure 3)

Also, the update time for SSRS reports can bog down due to the sheer number of project we have running so having this as live report in Project is desirable.

PS: Don't look at the actual data as it is from different times!

Is there anyway of:

  1. creating a new cell type being "Capacity" - ie how many hours in that week or day a person is available
  2. conditionally formatting cells - ie 0 - 85% load is orange (underutilized), 85 - 100% is green (utilized), >100% is red (over utilized), blue for if a task is pending etc.

It seems like the Resource Usage in Project is completely underutilized as a planning tool!

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Project 49,695 Reputation points Volunteer Moderator
    2017-01-19T14:32:23+00:00

    Tom,

    To answer your questions, no, additional timescaled fields cannot be added, and the field cells of the timescaled data cannot be separately formatted.

    You're probably right that the Resource Usage view could be configured to do a lot more, but it doesn't. I suggest you submit a request to the following user voice forum.

    https://microsoftproject.uservoice.com/forums/218133-microsoft-project

    John

    0 comments