Re: Customize Task Usage & Resource Usage

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Claudio ,

Welcome to this Microsoft Project newsgroup :)

No possible, sorry :(

FAQs, companion products and other useful Project information can be seen at
this web address: http://project.mvps.org/faqs.htm

Hope this helps - please let us know how you get on :)

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

Claudio wrote:
Hi eveybody

I'm not a project manager but a line manager. In this functions, the
project managers request resources for me for their various projects.
So on one hand I have to make sure, that I have enough resources
available for all the projects and on the other hand, that all my
resource have enough work assigned.

So in MS project, I don't want to do a planning on task level. Each
project may just be respresented by 1 task or maybe if it has several
workstreams, by a few tasks.

I've already found out, that the interesting views for me are the
Task Usage View and the Resource Usage View. In the Task Usage View,
I can easily verify how many resources I have assigned to the
different projects, in the Resource Usage View, I can check if I have
under or over allocated resources.

MS Project also marks over allocated resources in red.

And that's exactly, where I'm looking for improvement. I'd like to
have kind of the possibility to change the format of single cells
similar to Excel. If a resources is underalocated in a certain week,
I'd like to color the cell with another color and so on.

Any change to achieve that? Maybe at least with VBA?

Cheers
Claudio



.

Relevant Pages

  • Re: Customize Task Usage & Resource Usage
    ... I'm not a project manager but a line manager. ... project managers request resources for me for their various projects. ... Task Usage View and the Resource Usage View. ... have kind of the possibility to change the format of single cells ...
    (microsoft.public.project)
  • Re: custom report
    ... I clicked menue ... does not have resources explicitly assigned to it. ... Sie brauchen exact was John anzeigte: der Task Usage View ... using a german version). ...
    (microsoft.public.project)
  • Re: Cost Rate Table
    ... In either the Task Usage view or the Resource Usage view, add the Cost ... (It will only show for assignment lines.) ... many resources as I can and then changing the table. ...
    (microsoft.public.project)
  • Re: Tracking Actual Time
    ... You are missing one vital step: you MUST assign one or more resources to each of your tasks. ... Then when you enter progress in the Task Usage view, the system will behave as I described it. ...
    (microsoft.public.project)
  • Re: Shared Task with Multiple Resources
    ... I never used Task usage before. ... Resources" posted on 9/16.....please! ... "JulieS" wrote: ... Project MVP ...
    (microsoft.public.project)