UPDATE - It's coming, are you ready?

S curve in excel

4 replies [Last post]
Sanjay Malani
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 24 Nov 2008
Posts: 5
Hi!

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

Kind regards
Sanjay Malani

Replies

Sanjay Malani
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 24 Nov 2008
Posts: 5

Hi Rafael

Useful information, many thanks.


Kind regards
Sanjay
Rafael Davila
User offline. Last seen 44 min 28 sec ago. Offline
Joined: 1 Mar 2004
Posts: 3457
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
Sanjay Malani
User offline. Last seen 3 years 32 weeks ago. Offline
Joined: 24 Nov 2008
Posts: 5

Dear Rizwan

Many Thanks.


Regards

Sanjay
Rizwan Rauf, PMP
User offline. Last seen 4 weeks 3 days ago. Offline
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

Market Place

See how the TIME - LOCATION - VIEW brings clearness to your work programmes
The worlds leading Primavera P6 and Deltek implementation and training company www.tensixconsulting.com
Maxim Recruitment – Recruiting Construction, Engineering & Planning Professionals Worldwide in the Infrastructure, Rail, Building and Property Sectors.
A recruitment and consulting organisation that provides services to the European nuclear industry.
Books and training material available from an internationally recognised publisher and PMI accredited REP. Teach yourself or run your own in-house or public planning courses.
EVA19 is the major UK event for Project Control knowledge, know-how and networking. EVA is a conference organised by a project management practitioner for project practitioners and stakeholders
We want to build software that solves real problems, allow people to work more productive and happier.
Providing permanent and interim planning related recruitment solutions to a range of contractor and consultancy organisations.
The toolkit provides advanced analytical tools which can help identify areas of poor schedule quality at the click of a button.