red said:
HI,
This should be pretty easy but I can't figure how to do it. I need a way to
create a report that shows the progress from a given status date...I need to
know what the remaining work is and what the remaining work should be a the
given point. I would like it in a table format, not the graphical
representation in the Gantt. Any suggestions?
red,
"Pretty easy" is a relative term. On the other hand "easy" is a well
defined term.....
First I'm assuming you want the following type of information. Say a
task is 10 days duration with 80 hours of work. At the end of the 5th
day, assuming a linear spread of work, 40 hours of work should have been
completed and 40 hours remain. But on this particular task the % work
complete is only 40% so only 32 hours have been completed and 48 hours
remain. You would like some type of tabular data showing actual
remaining work of 48 hours versus an ideal 40 hours remaining. Correct?
On the surface it may be possible to utilize the existing earned value
metrics data (i.e. BCWS & BCWP) with appropriate factors to create the
remaining work fields. However that may be more effort than simply
setting up one or more spare fields that are customized with formulas to
calculate the values. It will get more complex if work is contoured.
Another approach that can certainly get the data you desire is with a
VBA macro. A macro has a whole lot more flexibility to create custom
data but it does require VBA experience and the macro must be run each
time the schedule is updated.
So the bottom line is, yes it can be done and it might be fairly easy
(yet a new term) depending on the approach taken.
John
Project MVP
