You can use now() to find the current date. You can use the
project.statusdate to determine when the project was just statused. You can
change the baseline and use the BCWS (if you have set a baseline) to
determine the planned status at a certain point in time. You can take
current progress, and calculate the remaining duration using the ratio of
work, actual work and remaining work along with the task start date and the
current date.
There are many different ways to do it. Personally I'd just:
Determine when the task started (actual start)
Determine current date ( now() or status date if you know that it has been
properly statused)
Determine how much work was completed. (Actual work)
Use some math to figure out how much longer it would take at this rate:
rate = actual work / (now()-actual start)
duration for remaining work = remaining work / rate
projected finish date = now() + duration for remaining work.
--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check
http://masamiki.com/project
-Jack Dahlgren, Project MVP
+++++++++++++++++++
