How do I add the "remaining work" field to custom resource usage .

TheMSsForum.com: The Microsoft Software Forum

MS Project 2003

I need to be able to run a cross-tab report, but using "remaining work"
rather then work, actual work, etc. I cannot seem to add this field, even
though I would assume that it is held on the same table.
Top

Re: How do I add the "remaining work" field to custom resource usage . by John

John
Mon May 21 09:44:39 CDT 2007

In article <C07493DB-3E9F-4B76-93E4-802024D1B586@microsoft.com>,
pebbles <pebbles@discussions.microsoft.com> wrote:

> MS Project 2003
>
> I need to be able to run a cross-tab report, but using "remaining work"
> rather then work, actual work, etc. I cannot seem to add this field, even
> though I would assume that it is held on the same table.

pebbles,
For whatever reason, remaining work is not a timescaled value. That is,
Project does not create a time phased set of values (i.e. values spread
over the duration).

Is there a particular reason you want to show remaining work spread over
the remaining duration of the task?

John
Project MVP
Top

Re: How do I add the "remaining work" field to custom resource usa by pebbles

pebbles
Mon May 21 09:58:00 CDT 2007

Thanks John. I need this as our internal reporting requires an estimate of
remaining work, by resource, over the next 4 months (totaled by month). If it
is not possible, I will need to run the report for Work and then for Actual
Work, and subtract one from the other.

"John" wrote:

> In article <C07493DB-3E9F-4B76-93E4-802024D1B586@microsoft.com>,
> pebbles <pebbles@discussions.microsoft.com> wrote:
>
> > MS Project 2003
> >
> > I need to be able to run a cross-tab report, but using "remaining work"
> > rather then work, actual work, etc. I cannot seem to add this field, even
> > though I would assume that it is held on the same table.
>
> pebbles,
> For whatever reason, remaining work is not a timescaled value. That is,
> Project does not create a time phased set of values (i.e. values spread
> over the duration).
>
> Is there a particular reason you want to show remaining work spread over
> the remaining duration of the task?
>
> John
> Project MVP
>
Top

Re: How do I add the "remaining work" field to custom resource usa by John

John
Mon May 21 15:18:00 CDT 2007

In article <3D757391-6A4F-40EE-B537-E24F3D2F1A37@microsoft.com>,
pebbles <pebbles@discussions.microsoft.com> wrote:

> Thanks John. I need this as our internal reporting requires an estimate of
> remaining work, by resource, over the next 4 months (totaled by month). If it
> is not possible, I will need to run the report for Work and then for Actual
> Work, and subtract one from the other.

pebbles,
You're welcome. It's not that is isn't possible, it's just that you will
either need to make the two runs as you suggest or you could use VBA.

John
Project MVP
>
> "John" wrote:
>
> > In article <C07493DB-3E9F-4B76-93E4-802024D1B586@microsoft.com>,
> > pebbles <pebbles@discussions.microsoft.com> wrote:
> >
> > > MS Project 2003
> > >
> > > I need to be able to run a cross-tab report, but using "remaining work"
> > > rather then work, actual work, etc. I cannot seem to add this field, even
> > > though I would assume that it is held on the same table.
> >
> > pebbles,
> > For whatever reason, remaining work is not a timescaled value. That is,
> > Project does not create a time phased set of values (i.e. values spread
> > over the duration).
> >
> > Is there a particular reason you want to show remaining work spread over
> > the remaining duration of the task?
> >
> > John
> > Project MVP
> >
Top