Resources Usage Sheet

M

meesh1224

Is it possible to show when a resource is not available (based on resource calendar) in the resource usage sheet other than having the cell blank? Can it be colored like weekends and how?
I want to understand the difference between when I do not have someone assigned and when they are not available.

thanks,
Michelle
 
J

John

Michele,
Well . . . yes and no. An individual's non-availability can be shown on
a Usage view but it will also show up as non-availability for all
resources. In other words, if you have 10 resources the timescale data
can correspond to the non-availability of the first resource or the
non-availability of the second resource or etc. This is done by setting
the calendar to each resource in the non-working tab of Format/Timscale.
It does differentiate between resource availability and non-assignment
but it probably isn't what you want.

If you really want a color coded sheet of resource availability you can
get there from her but it will require the data to be exported to Excel
where individual cells can be colored however desired. Although the
Resource Usage data can be exported to Excel by using the "analyze
timescale data in Excel" add-in it will not provide an easy method for
identifying which cells to color as unavailable and which to color as
unassigned. However a custom VBA macro can do what you want. The coding
isn't difficult, it just requires a little VBA experience and some time.

So, the answer to your basic question is "yes".

John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top