Incremental & Cumulative Progress Percentages & S curve

Resolved · Urgent Priority · Version 2003

Mon 30 Sep 2013, 11:40 Delegate Daniel said...

Daniel has attended:
Project Introduction course
Project Intermediate course
Project Advanced course

Incremental & Cumulative Progress Percentages & S curve

Hi,

I've created my MSP plan and have been asked to show planned engineering work completion by month with a table of incremental & cumulative progress percentages & corresponding 'S' curve.

Please advise on what reports would be best to show this detail ?

Many Thanks,

Daniel

Wed 2 Oct 2013, 15:07 Trainer Andrew said...

RE: Incremental & Cumulative Progress Percentages & S curve

Hi Daniel

Thank you for your question.

To produce an S-Curve you will need to get your data out of Project into Excel. To help do this Microsoft Project comes with a toolbar to do this.

From the View menu choose Toolbars then Analysis

On this toolbar you will find the Analyze Timescaled Data in Excel Button. This will take you through a series of steps to export your information to Excel where you can then create the charts you require.

I hope this helps.
Let me know how you get on.

Kind regards,
Andrew

Wed 2 Oct 2013, 15:14 Delegate Daniel said...

RE: Incremental & Cumulative Progress Percentages & S curve

Thanks for the advice and I will let you know if it works ok.

Wed 2 Oct 2013, 15:15 Delegate Daniel said...

RE: Incremental & Cumulative Progress Percentages & S curve

Thanks for the advice and I will let you know if it works ok.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

MS Project tip:

Keep constraining dates to a minimum

As far as possible avoid fixing the dates of your tasks. For example try to steer of clear dragging task bars in the Gantt chart to move them on the timeline or entering dates directly into the Start / Finish fields.

Date constraints such as these limit Microsoft Project's ability to automatically adjust your project whenever you add, remove or modify the duration of your tasks. Instead use the logic in your task dependencies that link your tasks to enable Project to calculate the start and finish dates for you.

View all MS Project hints and tips