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.

S-Curves in Primavera

16 replies [Last post]
Mon, 2006-06-05 19:04
ersin namli
User offline. Last seen 11 years 40 weeks ago. Offline
Joined: 19 Jul 2005
Posts: 54
Groups: None
Hi, How can I draw S-Curves (cumulative Cost and Cumulative Work)in Primavera, can I send data to excell like in MS Project. Thanks for answers
Top

Replies

Wed, 2016-05-04 13:14
#1
Gareth Wheeler
User offline. Last seen 7 years 50 weeks ago. Offline
Joined: 22 Oct 2010
Posts: 2
Groups: None

Hey

Top
Mon, 2016-04-25 20:50
#2
SAIDA NJIM
User offline. Last seen 7 years 49 weeks ago. Offline
Joined: 24 May 2012
Posts: 7
Groups: None

Hi

 

Please can you send me the spreadsheet

 

my mail is fcs.btp@topnet.tn

 

Best regards

Top
Mon, 2016-04-25 20:50
#3
SAIDA NJIM
User offline. Last seen 7 years 49 weeks ago. Offline
Joined: 24 May 2012
Posts: 7
Groups: None

Hi

 

Please can you send me the spreadsheet

 

my mail is fcs.btp@topnet.tn

 

Best regards

Top
Mon, 2016-04-25 20:50
#4
SAIDA NJIM
User offline. Last seen 7 years 49 weeks ago. Offline
Joined: 24 May 2012
Posts: 7
Groups: None

Hi

 

Please can you send me the spreadsheet

 

my mail is fcs.btp@topnet.tn

 

Best regards

Top
Fri, 2010-12-03 17:15
#5
cenk vardar
User offline. Last seen 13 years 18 weeks ago. Offline
Joined: 2 Dec 2010
Posts: 7
Groups: None

Thanks Waseem,

 

But what I want is to timely display or graph percent completions not for individual activities or resources only...but as a whole project...like 10%-1stMonth,15%-2ndmonth, 40%-3rdmonth.....etc... just this simple info I am exploring to display...And I start to think that this is impossible in P6 without additional calcs. and integration with other software such as excel. right? I wish a lot to be wrong and that someone show it to me.

Top
Fri, 2010-12-03 13:36
#6
Waseem Saber
User offline. Last seen 1 year 33 weeks ago. Offline
Joined: 1 Dec 2004
Posts: 63
Groups: None

Hi Cenk,

did you added the resource for the cost, if yes, click on the Resource Usage Profile, select the resource for the cost and it should display the required profile, you will need to do some modification on Res/Role Usage Profile options, select the At completion Cost and under Show select the Total Cumulative Curve........

hope this helps and am sure there are so many threads on this topic, advice to go through and it should help.

 

Cheers!

 

Waseem Saber

Top
Fri, 2010-12-03 13:31
#7
cenk vardar
User offline. Last seen 13 years 18 weeks ago. Offline
Joined: 2 Dec 2010
Posts: 7
Groups: None

-

Top
Fri, 2010-12-03 13:24
#8
cenk vardar
User offline. Last seen 13 years 18 weeks ago. Offline
Joined: 2 Dec 2010
Posts: 7
Groups: None

Hi friends,

 

How can I display planned period percent of completions for whole project in a spreadsheet form and as an s-curve?

I would appreciate your guidance.. But I kindly ask you to be precise when guiding..

my email is: prjmngr<at>mail.ru

 

thanks in advance

cenk

Top
Wed, 2010-10-20 14:33
#9
JW Groeneweg
User offline. Last seen 8 years 5 weeks ago. Offline
Joined: 12 Dec 2006
Posts: 4
Groups: Petro-Chem / Oil & Gas

Hi,

I am interested in your excel sheet.

I will send you a pm.

regards

JW

Top
Mon, 2010-10-18 04:30
#10
Alfian Mohamad
User offline. Last seen 11 years 17 weeks ago. Offline
Joined: 1 Mar 2004
Posts: 4
Groups: GPC Malaysia, Petro-Chem / Oil & Gas

Hi D Artagnan,

Came across with your posting in the Planning Planet wrt Excel connecting to P6 database to generate s-curve and cash flows.

I'm interested with it and wish if you could kindly email to "amo007@streamyx.com".

Thanks & Cheers;

Top
Mon, 2010-10-18 04:30
#11
Alfian Mohamad
User offline. Last seen 11 years 17 weeks ago. Offline
Joined: 1 Mar 2004
Posts: 4
Groups: GPC Malaysia, Petro-Chem / Oil & Gas

Hi D Artagnan,

Came across with your posting in the Planning Planet wrt Excel connecting to P6 database to generate s-curve and cash flows.

I'm interested with it and wish if you could kindly email to "amo007@streamyx.com".

Thanks & Cheers;

Top
Tue, 2010-01-19 09:13
#12
Gary Whitehead
User offline. Last seen 4 years 46 weeks ago. Offline
Joined: 24 Mar 2009
Posts: 1215
Groups: Building Information Modelling, Content Moderators, Petro-Chem / Oil & Gas, The GrapeVine
Athar,

Please request this by sending D Artagnan a PM (private message), rather than giving out your email. We discourage people distributing email addresses here, as there are spammers and scammers who have used this site in the past.

To send a pm, click on the blue envelope next to D Artagnan’s name below.

Cheers,

Gary
Top
Tue, 2010-01-19 06:39
#13
Athar Hashmi
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 21 Mar 2009
Posts: 38
Groups: Civil Engineering
Dear
Please send me that excel program for S-Curve
*email removed by Gary W*

regards
Top
Sat, 2009-12-26 04:35
#14
D Artagnan
User offline. Last seen 2 years 6 weeks ago. Offline
Joined: 19 Sep 2008
Posts: 207
Groups: Civil Engineering, GPC Qatar
i designed an excel sheet that connects p6 database to access to generate s-curve and cash flow. if interested you can send me pm.
Top
Thu, 2006-06-08 19:42
#15
Marcio Sampaio
User offline. Last seen 11 years 33 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Hello Ersin;

If u are not going to assign resources on your schedule, u can do this:

Create a fictitious resource (eg: S-Curve);
Stipulate weights for all activities (using excel);
Assign resource S-Curve in all activities using weight for budget unit;
eg: Stipulate 1.000.000 as 100% of your project, so u it eliminates the use of much decimal (eg: 0,000003 budget);

If u assign only this resource, u can create a S-Curve direct from Primavera. If u asign any other resource, go to Assignments, create a lay-out showing Cum Budget and Cum Actual and use a filter "resource is equal to S-Curve". Than, copy and paste in excel and create a curve;

Hope it helps;

Regards.

Top
Tue, 2006-06-06 09:58
#16
said tahoon
User offline. Last seen 16 years 41 weeks ago. Offline
Joined: 5 Jan 2005
Posts: 6
Groups: None
You can make S-Curves in Primavera in Units or cost by adding all resources and cost to the activities and you can see this S-Curves in Primavera by display activity usage profile from tool bar . also you can see earned value curve and S-Curves also from tracking layout.
ENG. Said tahoon
Top