×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

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

*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.

# How to prepare S curve in M S Project

## How to prepare S curve in M S Project

(OP)
hi,
We have recently started planning using MS Project-2000. Is there any option to get S curve?
Thanks in anticipation,
imtiyaz

### RE: How to prepare S curve in M S Project

Not as far as know

I have same Problem and export data to excel

sorry

AB

### RE: How to prepare S curve in M S Project

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,
Rentaplan

### RE: How to prepare S curve in M S Project

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.

victormarcel@yahoo.com

### RE: How to prepare S curve in M S Project

hi
please show me that xl file
thanks.

hi
thanks.

### RE: How to prepare S curve in M S Project

(OP)
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.
Regards,

Imtiyaz

Take care :)

### RE: How to prepare S curve in M S Project

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.

### RE: How to prepare S curve in M S Project

Hi

victormarcel@yahoo.com

Thank you,

### RE: How to prepare S curve in M S Project

Primavera will do S-Curves for you.

### RE: How to prepare S curve in M S Project

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

### RE: How to prepare S curve in M S Project

The Cube OLAP draws S Curve automatically based on the Work and actual work & Estimate to Complete info

#### Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

#### Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

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:

• Talk To Other Members
• Notification Of Responses To Questions
• Favorite Forums One Click Access
• Keyword Search Of All Posts, And More...

Register now while it's still free!