Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Eng-Tips
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

imtiyaz (Mechanical) (OP)
14 Aug 01 2:43
We have recently started planning using MS Project-2000. Is there any option to get S curve?
Thanks in anticipation,
blooda (Mechanical)
14 Mar 02 15:47
Not as far as know

I have same Problem and export data to excel


Rentaplan (Computer)
3 Apr 02 7:46
Hi Imtiyaz,
Like blooda, I have exported data from the task/resource usage tables to excel, the reason being that you can't hold progressive actuals to measure against the plan curve - all you can pull off are the latest values.
If you want to see a planned curve only, split the window to Gannt & Resource Graph (bottom pane). Then format the graph details to cumulative work (this will give you stepped appearance. Format the bar styles to line. This will give you an s curve for planned work only - unfortunately this is as far as you can go.
Good luck,
santo2002 (Mechanical)
29 Aug 02 16:41
What I have done to obtain an ADVANCE s curve is to export the activity, start date and finish date, to excel, and make a formula that calculates the distribution of that activity in time with "IF". In columns, the time frame. then I compare the time frame with start and finish date, and it gives me the % of advance of each activity across the time. Then I find the incidence of each activity based on ManPower for example, and make a SUMPRODUCT of the incidences with its advance distribution, and finally obtain a beautiful and realistic s curve of ADVANCE. I can show you the excel file if you want.

Dont have information about resources S curve like Primavera does.
sad1980 (Industrial)
9 Apr 04 14:35
please show me that xl file
sad1980 (Industrial)
9 Apr 04 15:22
show me that file please.
imtiyaz (Mechanical) (OP)
9 Apr 04 16:09
Hi Santo2002,
Thanks for the reply, I am develop something similar by exporting data in excel and using if statements. But it take lot of manhours and also if I revise the baseline, so again I have to do the complete file.
I would love to see your excel spread sheet.


Take care :)

santo2002 (Mechanical)
12 Apr 04 9:57
You are right imtiyaz, every time you modify the baseline, you must go to the excel file and copy/paste the dates. This must be done every time you revise it / reschedule it.

It wont require a lot of man hours though ;), just copy and paste...

Sad1980, imtiyaz, please send a little message to my email, and I will reply it with the file.

Regards, Santo.
sad1980 (Industrial)
13 Apr 04 7:16
Thanks for the reply, I send a message to this address:

Thank you,
Verner (Mining)
6 May 04 14:33
Primavera will do S-Curves for you.
indxpt (Civil/Environmental)
25 Oct 05 10:09
well u can have the s curve in msp itself .go to view-resource graph. right click -choose cumulative cost.then choose bar styles and then choose filtered resources total costs and choose line. click ok there u have ur s curve with cumulative costs shown on vertical and monthly cost on horizontal line. ofcourse primavera has ready s curves
Frenchlady (Computer)
7 Nov 05 8:14
The Cube OLAP draws S Curve automatically based on the Work and actual work & Estimate to Complete info

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close