remaining work 06, 07

[Jesse]

I need to provide some work hours for a project:
- total work
- actual work
- remaining work in 2006
- remaining work in 2007
I know how to manually go into Resource Usage and grab remaining work for
2006 and 2007. I'm looking for a more efficient and repeatable method. Can I
do a custom filter or create a custom field to allocate remaining work into
2006 and 2007?

 

[John]

I need to provide some work hours for a project:
- total work
- actual work
- remaining work in 2006
- remaining work in 2007
I know how to manually go into Resource Usage and grab remaining work for
2006 and 2007. I'm looking for a more efficient and repeatable method. Can I
do a custom filter or create a custom field to allocate remaining work into
2006 and 2007?

Jesse,
I'm not sure what you mean by "more efficient and repeatable", the
Resource Usage view seems pretty efficient to me if the timescale is set
for years. You might be able to do it with formulas in custom fields but
the issue will be with tasks that cross year boundaries - the formulas
get complex in a hurry - not what I would call an efficient approach. A
custom filter would be even less convenient and may not even be possible
or practical with multi-year tasks.

Of course, you could always use VBA, but given that the Usage view can
already provide the information, why bother.

John
Project MVP

 

[Guidho]

I totally agree with John, but what you might consider is to record (or
create) a macro.
Just record the steps you follow to accomplish the correct view, filter,
timescale, ... and store this as a macro. Now assign this macro to a new
button, and you have a single click solution.

Guidho