Skip to content
ProjectControls.com
Planners

Scurve creation in excel

Nick BertramMember for 15 years 11 months
Created
4
1
0

Hi Everyone

I have been given a template to create an S-curve Report.

I have the project data but im unsure how to massage this into the scurve report to get the desired result.

If there are any gurus out there willing to take a look please let me know.

Save Follow Follow forum Report
Reply New topic

4 replies

Oldest first
  1. 0
    Mukunda Y ·
    #1

    Hai Nick, Depends on what

    Hai Nick, 

    Depends on what basis u want to plot s curve based on Duration, weightage, cost or resource, ..after doing this export from the software to spreadsheet, plot the s curve % against Time.

    Report
  2. 0
    Shahnawaz Akhtar ·
    #2

    Can any body tell the steps

    Can any body tell the steps for making S-Curve in excel against MH and time from my p6 plan

    Report
  3. 0
    Shahnawaz Akhtar ·
    #3

    Can any body tell the steps

    Can any body tell the steps for making S-Curve in excel against MH and time from my p6 plan

    Report
  4. 0
    Berker Colakoglu ·
    #4

    Hello Shahnawaz, Go to

    Hello Shahnawaz,

     

    Go to Assignments Page ,use filter resource type equals labor ,right click to right side then go the spreedsheet fields and click customize. Select Budgeted units and Actual Units.

    Select required data then copy and paste to excel.

    From excel click insert tab and click charts to generate your S-Curve. (Generally i use columns chart for budgeted and actual units and line chart for cumulative units)

    Then modify it accordingly.

     

    Regards,

     

    Berker Colakoglu

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?