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 curve in excel

4 replies [Last post]
Sun, 2010-05-23 03:00
Sanjay Malani
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 24 Nov 2008
Posts: 5
Groups: None
Hi!

After exporting the report from primavera 6.0 to excel sheet, how to get S-curve in excel?

Kind regards
Sanjay Malani
Top

Replies

Sat, 2010-05-29 01:48
#1
Sanjay Malani
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 24 Nov 2008
Posts: 5
Groups: None

Hi Rafael

Useful information, many thanks.


Kind regards
Sanjay
Top
Sun, 2010-05-23 08:53
#2
Rafael Davila
User offline. Last seen 1 day 19 min ago. Offline
Joined: 1 Mar 2004
Posts: 5229
Groups: Spider Project Team
Some time ago I uploaded a sample Excel Workbook with a couple of spreadsheets that generate the S-Curves. These are very simple, just read the formulas and you will see the logic. After you feel comfortable on how to create the table then you can try yourself creating the graphs from your own table or just use the templates and populate them with your own data. If more columns are needed more columns can be inserted at some intermediate column and with some knowledge of how the formulas work just drag the required formulas. Make sure of inserting at an intermediate month column and not at an end/start month column so these are included in formula ranges as sometimes inserting at the end or beginning of a range leave out the new insertion.

You can download the file from the following link:

http://rs555.rapidshare.com/files/270364909/PA_Progress_Curve.xls

Sample S-Curves
Top
Sun, 2010-05-23 07:07
#3
Sanjay Malani
User offline. Last seen 13 years 47 weeks ago. Offline
Joined: 24 Nov 2008
Posts: 5
Groups: None

Dear Rizwan

Many Thanks.


Regards

Sanjay
Top
Sun, 2010-05-23 06:34
#4
Rizwan Rauf, PMP
User offline. Last seen 8 years 33 weeks ago. Offline
Joined: 23 Jun 2009
Posts: 19
Groups: Building Information Modelling, GPC Qatar, Petro-Chem / Oil & Gas
Dear Mr. Sanjay Malani,

After exporting from P6 to excel, you will sum up your activity loaded Man-hours/Cost (Whatever your basis is) and get percentage by dividing weekly/monthly man-hours/cost with the total and will get %age and then plot it in excel using graph commands.

Regards,

Rizwan Rauf
Top