how do i show remaining work by month?

[Juro]

Greetings All,

It seems this has been the subject of much debate already... All i want /
need is Remaining Work to be available as a calculated value by month for
specific financial projections in the right hand side of the screen. I have a
custom view but can only access the usual work, actual work, remaining
availability and so on...

I am working over a reasonably high number of plans and the subtraction of
actual work from work to give the value is impractical. From what I can tell
there is no way to achieve my ends - but if anyone can show me the light I'd
be very greatful!!

Cheers,
Juro.

 

[Rod Gill]

Remaining work field provides you with total work for each task remaining.
In the Resource and Task Usage views, work in the future is remaining, work
in the past is actual (provided you have updated your schedules correctly:
there shouldn't be any incomplete work in the past, or any completed work in
the future.
Adjust timescale to monthly and you have your information.

If you want a specifically formatted report that the Usage Views don't
provide then you need a VBA macro to create it. This is probably best
created in Excel for individual or all projects.

If you do want to go down this track, let me know your exact needs and I can
provide a quote for you.
--

Rod Gill
Project MVP

NEW!! Project VBA Book, for details visit: www.projectvbabook.com