INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • 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!

*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

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.

RE: How to prepare S curve in M S Project

hi
show me that file please.
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.
I would love to see your excel spread sheet.
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
Thanks for the reply, I send a message to this address:
 
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.

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!


Resources


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