Creating S-Curves in MS Project 2010

Submitted by Ronald St.Hilaire on
Microsoft Project

Member for

15 years 5 months
Member for 15 years 5 months
Submitted by Chris Rymer on Mon, 2014-01-20 18:53
Permalink

With Project Tracker you can create S curves directly from Microsoft Project without the need to export the data to a spreadsheet. If you have the XML file you don't even have to have MSP on your machine. It can create the curve from the durations of the activities in your project plan, you do not need resource or cost allocations. For more information and a free trial, go to ww.willmer.co.uk.

Member for

17 years 2 months
Member for 17 years 3 months
Submitted by Ronald St.Hilaire on Tue, 2012-09-18 17:09
Permalink

Alexandre/ Donald,

Would it be possible for me to get your individual e-mail addresses?

Ronald.

Member for

17 years 2 months
Member for 17 years 3 months
Submitted by Ronald St.Hilaire on Tue, 2012-09-18 17:09
Permalink

Alexandre/ Donald,

Would it be possible for me to get your individual e-mail addresses?

Ronald.

Member for

22 years 9 months
Member for 22 years 9 months
Submitted by Alexandre Faul… on Wed, 2012-09-12 09:43
Permalink

Donald,

how can you change the units from "hours" to "days"" by right-clicking the Task Usage time-distributed panel?

Alexandre

Member for

14 years 7 months
Member for 14 years 7 months
Submitted by Project Manager 67 on Wed, 2012-09-12 00:15
Permalink

Right click on the table and you will be able to change the view to manhours

Member for

22 years 9 months
Member for 22 years 9 months
Submitted by Alexandre Faul… on Tue, 2012-09-11 09:24
Permalink

Ronald,

if you want to use the Earned Value Over Time Report, do not "edit" the template, but select the report in the list and click "View"

if you want to do as Donald is suggesting, which is really an easy way to generate a S Curve in MS Excel or any other spreadsheet: display the Task Usage View (not "Report"), copy and paste one after the other the left hand table and the right hand distribution sheet;

be careful to properly paste the data in the spreadsheet side to side

Alexandre

Member for

17 years 2 months
Member for 17 years 3 months
Submitted by Ronald St.Hilaire on Mon, 2012-09-10 20:37
Permalink

Donald

I don't understand if I'm in Task Usage the only thing I'm seeing is a Cash Flow Report.

Member for

14 years 7 months
Member for 14 years 7 months
Submitted by Project Manager 67 on Fri, 2012-09-07 08:44
Permalink

The easiest and most flexible way to generate S-Curves is to copy and paste time phased data from the task usage table in to Excel. You will need to format man-hour data to remove the "h" so that Excel interprets the data correctly as numbers.

Member for

17 years 2 months
Member for 17 years 3 months
Submitted by Ronald St.Hilaire on Thu, 2012-09-06 14:33
Permalink

Hi Alexandre,

Thanks for the response. I went into the area put I'm stumped and I was wondering if you could give me some more help

  1. I hit the edit template button
  2. Selected Task % Comp
  3. This where I'm stumped, a prompt came back telling me to select a cost and I could go no further.

Can you guide me from here please? The help would be greatly appreciated.

 

Ronald

Member for

22 years 9 months
Member for 22 years 9 months
Submitted by Alexandre Faul… on Thu, 2012-09-06 11:15
Permalink

Ronald,

you have to use the Visual Reports instead: Earned Value Over Time Report

Alexandre