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 could we calculate Planned %?

9 replies [Last post]
Wed, 2005-11-23 10:15
Mohammed Abo El Magd
User offline. Last seen 14 years 34 weeks ago. Offline
Joined: 29 Nov 2004
Posts: 46
Groups: None
How could we calculate Planned % or Scheduled % ? for comparison purpose, as an example, between Actual % vs. Planned %.
Top

Replies

Wed, 2005-12-14 00:14
#1
Alex Rozenkevich
User offline. Last seen 6 years 13 weeks ago. Offline
Joined: 19 Aug 2004
Posts: 21
Groups: None
Hello Mohammed,

As I understood you need a technical advise i.e. how to do it using f.e. P3. First of all you need to make sure that some common measure resourse is assigned to your activities. (f.e. manhours). Than you create a target, assign it to you current project and can already see planned, earned and current estimate figures in resource profile view. To create an S-curve in Excel you need to export data using primavera reports.

Hope this is what you’ve asked about.

Alex
Top
Fri, 2005-12-09 01:40
#2
Charleston-Joseph...
User offline. Last seen 2 years 38 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hello,

First of all a clear understanding of construction progress is essential. Does S-curve ring a bell.

Whether you use EV, P3, Excel, PERT/CPM or other planning tools, the way construction were done, are ongoing, and will be done, the construction progress as monitored in uniform interval within the timeline (for example-week, months) will look like a bell shape. The cummulative progress will look like an S-curve.

The fundamentals is that construction tend to slow at the start of the timeline (shop drawings submittal, materials submittal, etc). In due course there will be more workfronts, more delivery of materials, incerease availability of shop drawings, etc. As the project approach completion, there will be not much work to be done.

In calculating planed %, you can apply a value for each activities and compute the equvalent percentage of this value for that particular activities. In your Gantt Chart where you have the start and finish date of activities, distribute the equivalent percentage in the timeline. Then, you add all the value that falls within the particular time interval (say weeks, months, etc)

Now you have the planned % for each time interval.

IMHO

Charlie
Top
Tue, 2005-12-06 16:39
#3
Ernesto Puyana
User offline. Last seen 7 years 34 weeks ago. Offline
Joined: 12 Jan 2001
Posts: 111
Groups: None
Hello.

I mean there`s more than one way to apply the EV concept: activity cost and man-hours being the most widely used because they are applicable to any kind of job. However, on certain cases, where project scope allows, EV could be calculated in M3 of concrete, Tons of steel, meters of pipe, etc.

On how to calculate Planned %, apply the procedure described before: using the project progress option, combines with the spotlight. This would be a nice feature to add to a wish list for future updates: a target percent complete column.
Top
Tue, 2005-12-06 03:14
#4
Mohammed Abo El Magd
User offline. Last seen 14 years 34 weeks ago. Offline
Joined: 29 Nov 2004
Posts: 46
Groups: None
Hello Gentlemen,
First of all I’d like to ask Ernesto, how Primavera allows many other methods and where I could do that in the soft were? Or do you mean the method available to calculate the ETC?
Second, thank you Adel for your kind offer. But the problem that not all the time you can report for the project progress using EV, all the time , you been asked to report as I explained before (Actual % against Scheduled %). And even if you reported using EV, you will go through the same question (How could I calculate the Scheduled % ?) to get the Planned value or BCWS.

Best Regards
Top
Sun, 2005-12-04 18:15
#5
Ernesto Puyana
User offline. Last seen 7 years 34 weeks ago. Offline
Joined: 12 Jan 2001
Posts: 111
Groups: None
There`s no doubt EV is the best way to measure progress, specially in lump sum contracts, since payment depends on it.

However, measuring % complete the way suretrak or primavera measure it when no cost or resources are loaded onto activities is a pretty simple and easy way to keep track of projects. We`ve been using it on a weekly basis on small and large projects, with good results.

After all what one needs is a baseline to compare against; what changes when using dollars, man-hours or days is the specific weight of each activity.
Top
Sun, 2005-12-04 05:10
#6
Adil Gibreel
User offline. Last seen 8 years 21 weeks ago. Offline
Joined: 21 Nov 2005
Posts: 9
Groups: None
I think this should be donre using the EV (Earned Value) by considering both the work done and the cost of that work compared to the planned work and cost. If you are not familiar with EV, I will be more than happy to elaborate n that
Top
Thu, 2005-12-01 19:24
#7
Ernesto Puyana
User offline. Last seen 7 years 34 weeks ago. Offline
Joined: 12 Jan 2001
Posts: 111
Groups: None
the most common asumption made to model activity progress is that there is a lineal relationship between time elapsed and work performed. Thats not always the case, but that’s why Primavera allows several other models.
Top
Sun, 2005-11-27 05:01
#8
Mohammed Abo El Magd
User offline. Last seen 14 years 34 weeks ago. Offline
Joined: 29 Nov 2004
Posts: 46
Groups: None
Hallow Christian
Thank you for your replay. The problem is, if we assumed that we have activity of

10 days duration and
800 units assigned to it.
One day elapsed, so, the Planned % will be calculated as follows,
800/10 = 80 unit / day
80 unit (Just one day elapsed)/800unit = 0.1*100 = 10%
Means that after one day, I should accomplish 10% of this activity. Even if we calculate it using time units
(1/10) * 100 = 10%

And here is the problem, is it correct to say that If 10% of the project elapsed I should accomplish 10% of the work?

I think many factors should be taken in consideration to calculate the Planned %.

What is your opinion Christian?

Cheers
Top
Thu, 2005-11-24 12:19
#9
Christian Adrian ...
User offline. Last seen 4 years 38 weeks ago. Offline
Joined: 3 Jun 2003
Posts: 193
Groups: None
Hello Mohammed

Is your programme done in P3 3.1? if so then you may use the update progress tools... change your date into a new data date then you may select "all activities" or "selected activities" the press update...

Hope this helps...

Christian
Top