Timescale Macro

As part of a home-spun earned value approach based on
hours, I need a macro that can calculate the number of
hours (Work) at a task level that should have been worked
(in other words, was scheduled to be worked) during a
particular timeframe - for example, from project start to
current status date. This value then needs to be
populated into a custom number field. I've had issues
with macros dealing with timescaled data in the past, so
figured I would just ask right off the bat if anyone has
suggestions.

John
Mon Aug 09 10:14:45 CDT 2004


Gbeav,
Well, you've kinda got some apples (MacIntosh I hope) and some oranges.
It sounds like you want the hours equivalent of BCWS (perhaps BHWS). And
ordinarily this is simply:
(Duration to Status Date)/(Task Duration) x Baseline Hours
It gets more complicated if work contouring is used. I don't honestly
remember if this value is already available in a Project field or not.
If it isn't, it is fairly easy to use a custom field with the above
formula (without work contouring) or a VBA macro if work contouring is
used. However, you also mention timescale data and a custom field
(here's the apple and oranges part). Custom fields are static, that is
they can hold single values but not multiple values, (unless a separate
custom field is used for each discrete value), like a timescale field
(e.g Work). From the type of data you describe (single value BHWS) why
do you think you need timescale values?

John

JackD
Mon Aug 09 13:32:30 CDT 2004

I'd simply assign a cost of $1 for each hour of work, then use BCWS
-Jack

"gbeav" <gbeaver1@tampabay.rr.com> wrote in message
news:234601c47db5$9628b7e0$a301280a@phx.gbl...
> As part of a home-spun earned value approach based on
> hours, I need a macro that can calculate the number of
> hours (Work) at a task level that should have been worked
> (in other words, was scheduled to be worked) during a
> particular timeframe - for example, from project start to
> current status date. This value then needs to be
> populated into a custom number field. I've had issues
> with macros dealing with timescaled data in the past, so
> figured I would just ask right off the bat if anyone has
> suggestions.