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.

how to make a forecast curve?

15 replies [Last post]
Wed, 2008-09-24 00:10
jeoffrey reyes
User offline. Last seen 3 years 43 weeks ago. Offline
Joined: 19 Jun 2008
Posts: 214
Groups: GPC Qatar, Pinoy Planning Planet Community
our client wanted to include a forecast curve on my progress curve in spreadsheet. what are the considerations can i make for making such curve in spreadsheet?

regards,

jeff
Top

Replies

Sun, 2016-05-22 05:36
#1
syed husaini
User offline. Last seen 7 years 48 weeks ago. Offline
Joined: 9 Feb 2015
Posts: 2
Groups: None

Hi,

How can I adjust my forecast curve. if you have any exmaple to please provide 

 

Thanks

 

Top
Thu, 2008-09-25 05:29
#2
jeff hadjail
User offline. Last seen 3 years 22 weeks ago. Offline
Joined: 30 Aug 2008
Posts: 16
Groups: Accreditation Editors, Civil Engineering, GPC Qatar, Petro-Chem / Oil & Gas, Pinoy Planning Planet Community
hi jeff reyes,

You know,arnold and anoon are right with regards to that reporting in comparing the current schedule vs planned scheduled which includes the earned cost and the manhours and the real billing...i guess we have the same procedure in reporting the forecasts im also new with this works...but mine project activities are more on electro-mechanical for 4 star hotel with a 34 floors.

with this,its a big help when we help each other...thank you and more power guys...
jeffh
Top
Thu, 2008-09-25 02:36
#3
Anoon Iimos
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
i believe another problem you’ll be having is during the reporting, how to explain it to the audience, remember not all of them are planners, just make sure you got all the back-ups (and you can handle stress).

no, i’m somewhere around, been there also (ingat lang).
Top
Thu, 2008-09-25 02:27
#4
jeoffrey reyes
User offline. Last seen 3 years 43 weeks ago. Offline
Joined: 19 Jun 2008
Posts: 214
Groups: GPC Qatar, Pinoy Planning Planet Community
thanks, Anoon. very well said. actually, i’ve been having this problem since i handled this project. and because i have so much assigments in field and office, i cannot rectify some problems all at the same time. luckily, you’re here guys whose always watching the pplanet for those who were at need. you’re in our country right now, Anoon?

i am really grateful having this pplanet exists. so many brilliant and crazy idea(s) you can find here.

Arnold, i have sent already the files. please advise if you can do something with it.
Top
Thu, 2008-09-25 02:11
#5
Anoon Iimos
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
Jeff,

Try to check and compare your Target (Planned - Original Schedule), which has the original forecast (early curve as you said), but remember you also have your late curve on the same schedule which can originally be used as forecast as well.

Now you have your Current/Updated Schedule, (Arnold is right), forget about all the original forecasts that you had derived from your Baseline or Target Plan (just keep the records). Your new forecasts now are to be reckoned from your Current/Updated Schedule, which can either be late or early.

From there, you can now establish the comparisons (Planned vs.Actual Forecasts), just make sure you labeled your curves correctly (you can do this in excel).

By the way you guys have plenty of time PP..ing while working?

regards
Top
Thu, 2008-09-25 02:02
#6
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hello Jeff,

Yap, I’ve been working for 7 years in Saudi Arabia before I transfer to Abu-Dhabi. I worked for SAUDI ARAMCO Project for 5 years & 2 years in RC Jubail Project. If you don’t mind, can you send me your Files both Excel & Primavera, I can help you on this. I know the format of RC Project that they are using. If it is okey for you, I know you’re Filipino, me too.

My email is p3-fer@sixco.ae

Regards,

Arnold
Top
Thu, 2008-09-25 01:51
#7
jeoffrey reyes
User offline. Last seen 3 years 43 weeks ago. Offline
Joined: 19 Jun 2008
Posts: 214
Groups: GPC Qatar, Pinoy Planning Planet Community
yes Arnold, your wild guess really shocked me. how did you know? have you been here also in jubail and worked in Royal Commission? Maybe RC is the only one who asks for forecast curve? in other clients or ours, no need for forecast curve. currently, almost all of the projects were assigned to me. big headache, really, because even the preliminaries on our tender department were all assigned to me.

when i got here, the schedule was already existing. the forecast curve as i said was under the early curve. i tried what Anoon said but still the curve went under. is there a problem on resources loading? or is there something else? same thru with cost curve.

Anoon, really appreciate your advise. thanks.


regards,


jeff
Top
Thu, 2008-09-25 01:38
#8
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community

Yes, you are right Anoon. I’m just trying to explain to Jeff why his forecast went under the early curve.

regards
Top
Thu, 2008-09-25 01:34
#9
Anoon Iimos
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
Arnold,

I agree with what you said (but not only in P6), Forecast can be early and late as well. Forecast of the remaining works from your current/updated schedule (which has early and late curves also).

regards
Top
Thu, 2008-09-25 00:32
#10
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Jeff,

In your Progress Curve there should be Four Curves:

1. Early Curve
2. Actual Curve
3. Late Curve
4. Forecast Curve

These Four curves above came from your Primavera Files. The Early Curve is your Target/Baseline Curve. Actual is the current/update schedule. Late Curve is your late Planned & Forecast is your Planned for the next update of remaining activities.

Now, to get your forecast it depends on your lookahead schedule. In P6 this is your Remaining Early Curve based on current schedule & not based in your baseline schedule.

Now, if you are using P3x you can export this data from P3 to excel by using Tools --> Tabular Reports --> Resource --> Tabular, depending in your resources.

If you have your forecast curve went under your early curve, I assumed that is not forecast, that is late curve. However, if that value is correct then you might have to double check with your CM.

Forecast curve always starts from your data date because this is the starting point for schedule calculation of remaining activities.

Jeff, are you working with Jubail Royal Commission Project & the PM Consultant is BECHTEL?

HTH.

Arnold
Top
Thu, 2008-09-25 00:00
#11
Anoon Iimos
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
read more and practise more
Top
Wed, 2008-09-24 09:26
#12
jeoffrey reyes
User offline. Last seen 3 years 43 weeks ago. Offline
Joined: 19 Jun 2008
Posts: 214
Groups: GPC Qatar, Pinoy Planning Planet Community
will i add the early and late planned data to get the forecast data?


regards,



jeff
Top
Wed, 2008-09-24 09:24
#13
jeoffrey reyes
User offline. Last seen 3 years 43 weeks ago. Offline
Joined: 19 Jun 2008
Posts: 214
Groups: GPC Qatar, Pinoy Planning Planet Community
thanks guys. i tried it today...but is it normal that forecast curve will go under the early curve? because i am expecting that it will be above the early curve.


regards,

jeff
Top
Wed, 2008-09-24 02:33
#14
Arnold Puy
User offline. Last seen 9 years 11 weeks ago. Offline
Joined: 25 Apr 2007
Posts: 1147
Groups: GPC Qatar, Pinoy Planning Planet Community
Hi Jeff,

In addition to what Mr. Anoon’s post, you can export all the datas & values from your P3, P5 or P6 to Excel. Based on that Planned Values (Early or Late) you have consider in your schedule. By adding these Planned Values you can now produce & create the forecast curve to your Progress Report.


Top
Wed, 2008-09-24 01:41
#15
Anoon Iimos
User offline. Last seen 2 years 14 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
a forecast curve is a planned curve, create your curve using planned data.
Top