Progress Curves

[Kevin]

all

Is there a feature in project 2000 that will allow me to generate project
S-curves of planned versus actual progress?

thanks

/kevin

[John]

Kevin,
No, not directly, however it can be done with VBA. The basic process is
to get the necessary data exported to Excel where it can easily be
plotted. The first question however is, what exactly do you mean when
you say "planned versus actual progress"? Are you referring to earned
values measurements or perhaps some measurement of Duration (% Complete)
or Work (% Work Complete)?

One approach you might try is by using the "analyze timescaled data in
Excel" add-in found on the Analysis toolbar. Depending on the data you
need, it may or may not be readily exportable with the add-in.

Personally, I would develop my own VBA code to extract and export the
data. I know there was a macro to do "S curves" available through the
MVP website, but unfortunately I can no longer find it.

Hope this helps.
John

[Bob]

Hi,

I downloaded a macro from Rod Gil's great site. It generates S-Curves
into Excel. Slick.

Bob

Post by John
Kevin,
No, not directly, however it can be done with VBA. The basic process is
to get the necessary data exported to Excel where it can easily be
plotted. The first question however is, what exactly do you mean when
you say "planned versus actual progress"? Are you referring to earned
values measurements or perhaps some measurement of Duration (% Complete)
or Work (% Work Complete)?
One approach you might try is by using the "analyze timescaled data in
Excel" add-in found on the Analysis toolbar. Depending on the data you
need, it may or may not be readily exportable with the add-in.
Personally, I would develop my own VBA code to extract and export the
data. I know there was a macro to do "S curves" available through the
MVP website, but unfortunately I can no longer find it.
Hope this helps.
John

[Bob]

Hi,
Can you post the adress of Rod Gil's site ?
I am very interested in this macro for S-curves.
AB

Salut André

Voici l'infor pour Rod Gill


Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project VBA
development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz

[Mike Glen]

It's in his signature block below :)

Mike Glen
Project MVP

Post by Bob

Hi,
Can you post the adress of Rod Gil's site ?
I am very interested in this macro for S-curves.
AB

Salut André
Voici l'infor pour Rod Gill
Rod Gill
Project MVP
For Microsoft Project companion projects, best practices and Project
VBA development services
visit www.project-systems.co.nz/
Email rodg AT project-systems DOT co DOT nz