The sheet displays utilization of resources as a percentage at the project level and is shown for each resource-role combination.
Utilization% = (Total Assigned Hours / Hard-booked Hours) *100
- Rolling over the cell value shows a break up of hard-booked hours and assigned hours.
- Utilization over 100% (over-utilization) is displayed in red.
This sheet cannot be opened unless the Schedule Manager is loaded or a master schedule sheet is created.
To view the project-level utilization summary sheet
In the project-level Resource Sheets log, select Utilization Summary Sheet and click Open. You can view this sheet by hours only.