Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Generating Progress S-curve (Plan VS Actual)

8 replies [Last post]
Wed, 2008-05-14 03:03
Chin Fwei Yip
User offline. Last seen 6 years 7 weeks ago. Offline
Joined: 19 Oct 2007
Posts: 12
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Hi there.

Just wonder if we are able to generate progrss S-curve (plan VS actual) with a resources and material loaded schedule created by MS Project 2003? This is not mentioned in the book I read last week.

Thanks and Regards,
Top

Replies

Sun, 2013-04-21 13:37
#1
Jean-Yves Moine
User offline. Last seen 3 years 21 weeks ago. Offline
Joined: 17 Jan 2009
Posts: 87
Groups: None

 

you can buy "S curves V2" VBA EXCEL application: http://www.cubixpm-scurves.com/en/

it allows to :

  • Create 26 S curves (baseline early and late, physical progress) in automatic connection with aMS PROJECT or PRIMAVERA P6 schedule.
  • Spread the weights in a linear or Gaussian way over the tasks of schedule.
  • Create S curves with 3 criteria, on the basis of 5 task codes.
  • Manage a schedule up to 10,000 tasks.

BR, Jean-Yves Moine.

Top
Sat, 2008-06-07 03:43
#2
Trevor Rabey
User offline. Last seen 1 year 39 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
What about all of the timephased data that you can export to EXCEL (and it draws the graph for you) with the "analyse timescaled data in EXCEL" button on the Analysis Toolbar?
Top
Fri, 2008-06-06 21:54
#3
Madeliene Ozaeta
User offline. Last seen 13 years 12 weeks ago. Offline
Joined: 30 Mar 2004
Posts: 5
Groups: None
hi! i also mean to ask the same thing as chin. Simply how t plot planned progress vs actual progress in terms of weighted %.

Is there also a way of adding a row in the gant chart to show the total cost of the project?

million thanks po!

maimai
Top
Thu, 2008-05-15 00:47
#4
Chin Fwei Yip
User offline. Last seen 6 years 7 weeks ago. Offline
Joined: 19 Oct 2007
Posts: 12
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Been doing this all the time.

Just wonder is there any ’plug-in’ to let MSP to generate the curve just like Primavera Project Planner...
Top
Wed, 2008-05-14 21:37
#5
Trevor Rabey
User offline. Last seen 1 year 39 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
Read up on Earned Value in MSP Help.
See also the Analysis Toolbar, where you can export Cumulative Cost and Cumulative Work, as well as all of the Earned Value numbers to EXCEL, and it draws the graph for you.
Top
Wed, 2008-05-14 19:23
#6
Chin Fwei Yip
User offline. Last seen 6 years 7 weeks ago. Offline
Joined: 19 Oct 2007
Posts: 12
Groups: GPC Malaysia, Petro-Chem / Oil & Gas
Anything, says plan manhours VS earned manhours to-date, plan manhours VS actual spent to-date, plan cost to-date VS earned cost to-date etc.
Top
Wed, 2008-05-14 09:49
#7
Trevor Rabey
User offline. Last seen 1 year 39 weeks ago. Offline
Joined: 29 Nov 2005
Posts: 530
Groups: None
plan vs actual of what?
Top