VBA to generate plot points

[Harold]

Does anyone have a VBA function that when passed
1). start date
2). finish date
3). amount
4). Optional Curve Ditribution (front loaded, back etc)

generates plot points by day/week/month.

Seems this would be quite useful if not tied to a
scheduling package, just good old Access/Excel

Thanks

 

[Jack D.]

Does anyone have a VBA function that when passed
1). start date
2). finish date
3). amount
4). Optional Curve Ditribution (front loaded, back etc)

generates plot points by day/week/month.

Seems this would be quite useful if not tied to a
scheduling package, just good old Access/Excel

Thanks

I think excel would be appropriate for doing this.
You would need some mathematical description of the loading (or a lookup
table) but other than that it would not be very difficult.
What would you use it for?

--
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


+++++++++++++++++++

 

[Harold]

I use Access and MSGraph. Most project control tasks
revolve around start and end dates. We assign budgets (hrs/
$) to these tasks. Once defined, the loading over time
(histogram or cum curve) as a graphical representation is
usually asked for, to determine resource/cost loading. I
just would like the plot points.