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.

Trend Analysis and Forecasts

12 replies [Last post]
Tue, 2005-12-06 09:44
Marcio Sampaio
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Dear all Planning Planet friends,

Does anybody knows if Primavera P3E provides a Trend Analysis and Forecasts based on previous performance (plotted on S-curve)?
If it doesn’t, how can i do it with excel or other tool?
This is an important management information required by high administration.

Thanks in advance.

Best regards;

Marcio Eduardo
Rio de Janeiro - Brazil.
Top

Replies

Sun, 2005-12-18 15:31
#1
Renaud Moisan
User offline. Last seen 13 years 8 weeks ago. Offline
Joined: 3 Nov 2005
Posts: 11
Groups: Petro-Chem / Oil & Gas
I feel like you’ve explored only one side of the trend analysis: the "statistical" side using only the numbers. But you need also to check a more reality anchored analysis.

Part of the trend analysis shall also rely on reveiwing the remaining durations and future durations, in-light of past performances, asses whether the past perf is relevant or not. Once the reviw is done update the plan accordingly and get out your forecast curve. Now you can compare this to the "statistical" trends for an even better analysis.
Top
Wed, 2005-12-14 07:33
#2
Marcio Sampaio
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Thank u all for your responses.

Good explanations here. It is realy going to help me.

Best regards;

Marcio Eduardo
Rio de Janeiro - Brazil.
Top
Wed, 2005-12-14 00:38
#3
Alex Rozenkevich
User offline. Last seen 6 years 27 weeks ago. Offline
Joined: 19 Aug 2004
Posts: 21
Groups: None
Marcio,

I’m used to calculating it manually based on performance factor. It is calculated as Actual / Planned. Normally latest figure is used although you may be requested by client to use average figure which in case of poor previous performance and a sudden increase will not allow you to show any significant improvement until you performance becomes stable.

Alex
Top
Thu, 2005-12-08 07:15
#4
Vladimir Liberzon
User offline. Last seen 3 weeks 9 hours ago. Offline
Joined: 5 Feb 2001
Posts: 2750
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Marcio,
we insist on management by trends. Not only S-curves but trends of other parameters like planned finish date, resource requirements, probabilities to meet target parameters successfully shall be analyzed. If the trends are negative then it is a trigger for considering corrective actions.
Even if current project status is favourable you shall analyze trends.
Example: you are ahead of schedule for 2 days, a week ago you were ahead of schedule for 5 days, a month ago - for 10 days. This trend means that you have a problem that shall be solved immediately not waiting until the project will be in trouble.
Regards,
Vladimir
Top
Thu, 2005-12-08 07:05
#5
Marcio Sampaio
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Zhang Haixiang and Vladimir Liberzon,

Thanks a lot for your responses. I’ll try both.

Do u use to create trend curve to analyse the future and create recover plans???

Best regards.

Marcio Eduardo
Rio de Janeiro - Brazil.
Top
Thu, 2005-12-08 03:19
#6
Vladimir Liberzon
User offline. Last seen 3 weeks 9 hours ago. Offline
Joined: 5 Feb 2001
Posts: 2750
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Marcio,
Earned value analysis forecasts EAC basing on the trends (performance factor). Performance factor is usually set as 1/CPI. Obtaining report on future costs and multiplying them by performance factor you will adjust them in accordance to trends based on the past performence.
In response to your question about other tools - Spider Project creates trend curves for the data you choose.
Best Regards,
Vladimir
Top
Thu, 2005-12-08 00:11
#7
Zhang Haixiang
User offline. Last seen 3 years 41 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
to make it start only from you last update and look like continuation of your s-curve, my suggestion is to do it manually.

add anothor row of date for your trend-curve, try to put some data, and make it fit with the trendline, then delete the trendline

hope this helps
Top
Thu, 2005-12-08 00:05
#8
Zhang Haixiang
User offline. Last seen 3 years 41 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
you have x-axis the date, and you have the y-axis the progress. the data may like this (current date is 6):

date 1 2 3 4 5 6 7 8 9
progress x1 x2 x3 x4 x5 x6

select all the above data for you curve.
the s-curve will stop at date 6 (which is you last update),but the trend line will extend to date 9 (last data of your x-axis)
Top
Wed, 2005-12-07 07:22
#9
Marcio Sampaio
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Dear Zhang Haixiang;

Thanks a lot for your response.

It realy works on Excel. But do u know how to create trend curve only from the last update? As a continuation of the progress curve.

Best regards.

Marcio Eduardo.
Rio de Janeiro - Brazil.

Top
Wed, 2005-12-07 00:09
#10
Zhang Haixiang
User offline. Last seen 3 years 41 weeks ago. Offline
Joined: 14 Apr 2005
Posts: 250
Groups: None
first export the data to excel,then
prepare the date in excel and generate the s-curve,
then right click the s-curve, from the menu select ’add trendline, select the type of trendline most fit your s-curve.

hope this helps
Top
Tue, 2005-12-06 14:31
#11
Marcio Sampaio
User offline. Last seen 11 years 46 weeks ago. Offline
Joined: 7 Nov 2005
Posts: 658
Groups: Petro-Chem / Oil & Gas
Charleston-Joseph Orbe;

Thanks a lot for your response.

But i also need to create a trend curve. This trend curve will show me which will be the progress based in the progress until the moment.

If P3e can’t do it, i’d like to know how to do it with another tool (like excel).

Best regards;

Marcio Eduardo
Rio de Janeiro - Brazil.

Top
Tue, 2005-12-06 13:41
#12
Charleston-Joseph...
User offline. Last seen 2 years 51 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hi Marcio,

I’m not familiar with P3e. However I did a lot of progress S-curve in Excel.

Before Primavera P3, with derive the Progress S-curve using Gant Chart and eventually PERT/CPM. The simplest i can discuss to you is the Gantt Chart.

For each activity, you evaluate the duration, start date and finish date. For simplicity, we will use the early start dates in your Gantt Chart.

Each activity you assign a percentage weight. You can use your cost for each activities and compute the equivalent percentage. This equivalent weight for each activity will be distributed in the particular timeline of each activity. The simplest you can do is to distribute it uniformly, however this is not very precise. You can also distribute the percentage base on your understanding on the cost behaviour of each activities that you derive from past experience.

This is only my humble contribution. I hope it will help you jumpstart your S-curve

Best regards,

Charlie
Top