Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resource Usage Spreadsheet Distribution Issues

1 reply [Last post]
Nisha Joseph
User offline. Last seen 1 year 3 days ago. Offline
Joined: 23 Oct 2017
Posts: 6
Groups: None

Hi ,


I have a project, for which I have resource loaded an "X" engineering discipline. The monthly distribution, looks ok, but when I zoom to see the weekly distribution, it dosen't show a proper resource histogram. Thereby i thought to re-adjust in the weeks, in the same month. However when I go to "Resource Assignment Tab" with timescale set to "Month/week", the figures aren't legible and I am unable to manually edit the weekly distribution. I tried to zoom out and zoom in, but the weekly distribution column window is not legible. 

Thanks !


Best Regards,



Zoltan Palffy
User offline. Last seen 16 hours 35 min ago. Offline
Joined: 13 Jul 2009
Posts: 3000
Groups: None

go to view show on bottom 

go to resource usage profile or resource usage spreadsheet in the right area right click 

if using spreasheet profile select spreadsheet optioncheck calculate average and check base on hour per time period

if using resource useage profile right click on the right area and select Resource usage profile options

then click on the graph tab

at the bottom check calculate Average and check Base on Hours per time period

what this does is it automatically adjusts the resource distrubition based on the time scale that you choos be it days, week or months.

another note is that if you have any resources assigned to an activity type as a LOE (level of effort) you must assign a resource curve to that resource for the LOE activity. If you do nto do this then all of the resources for this activity will be show on the data date.