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.

Scurve creation in excel

4 replies [Last post]
Nick Bertram
User offline. Last seen 12 years 32 weeks ago. Offline
Joined: 16 Nov 2010
Posts: 2
Groups: None

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.

Replies

Berker Colakoglu
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 11 Jan 2008
Posts: 13
Groups: None

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

shahnawaz akhtar
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 19 Feb 2012
Posts: 4
Groups: None

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

shahnawaz akhtar
User offline. Last seen 11 years 24 weeks ago. Offline
Joined: 19 Feb 2012
Posts: 4
Groups: None

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

mukunda y
User offline. Last seen 10 years 32 weeks ago. Offline
Joined: 12 Nov 2008
Posts: 97
Groups: None

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.