Website Upgrade Incoming - we're working on a new look (and speed!) standby while we deliver the project

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.

Calculation of Variance

6 replies [Last post]
Mon, 2008-01-07 08:30
Pranab Kumar Deb
User offline. Last seen 3 years 48 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Dear All,
Is there any option available in P3 to calculate the schedule variance on CALENDAR DAYS and not working days.
Other than changing the total calendar of the schedule.
regards
deb
Top

Replies

Wed, 2008-03-05 03:16
#1
WAEL ELHAJJ
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 14 Feb 2008
Posts: 55
Groups: Petro-Chem / Oil & Gas
thank you jim,
i was able to sort out the matter by exporting the file to dbf format and it opened in excel , which was very great and i was able to calculate variance as needed and subtract the variance in order to find the disrupts. since primavera doesnot calculate disrupts on the actual date schedule.
always yours
wael
Top
Fri, 2008-02-29 21:02
#2
Jim McCombs
User offline. Last seen 10 years 32 weeks ago. Offline
Joined: 6 Nov 2004
Posts: 13
Groups: None
each current schedule activity’s "Variance" (es or ef) is measured against the referenced target schedule’s date (for es or ef), but the calculation is measured based upon the calendar assigned to the activity. If the activity is assigned to a 5 day a week calendar, then variance is in working days. If the activity has a 7 days per week calendar, then the variance is calculated in calendar days. So, the only way for Primavera to calculate the variance in calendar days is to assign a 7 day calendar to the activity. Of course, if you want to schedule in working days, this is counter productive. It depends on how important this is to you. You can use copy you data into ms excel and have it calculate the difference between the dates in calendar days. I hope this is helpful.
Top
Tue, 2008-02-26 08:13
#3
WAEL ELHAJJ
User offline. Last seen 2 years 19 weeks ago. Offline
Joined: 14 Feb 2008
Posts: 55
Groups: Petro-Chem / Oil & Gas
.my friend ,
i might be facing a simillar problem yet since i am introduced to primavera since a very short time i wish if you can help me in what i am facing.
i wish to ask again some specific and nore challenging question regarding the use of primavera.
i am stuck on a stage where i want to find the difference between the variance at early start and the variance at early finish. all i need to know is how to perform column subtraction in primavera?
i tried using the converter to excel and do it there yet i am facing a proplem since MPX does not copy the primavera activity ID. what shall i do?
yours always , wael el hajj
Top
Tue, 2008-01-08 09:50
#4
Johny Kesserwany
User offline. Last seen 8 years 15 weeks ago. Offline
Joined: 18 Sep 2007
Posts: 118
Groups: Civil Engineering
Dear Deb

I believe that the only way in P3 is, as you said, to change the calendar to a 7 days one!

Regards
Jk
Top
Tue, 2008-01-08 08:42
#5
Pranab Kumar Deb
User offline. Last seen 3 years 48 weeks ago. Offline
Joined: 23 Jan 2007
Posts: 291
Groups: Civil Engineering
Dear Johny Kessarwany,
Thank you for the excellent bit of information.
Though i was speaking about the Variance from the target schedule in terms of time. I.e delay/acceleration to work schedule vis-a-vis the target schedule is calcluated in working days , i want to have it in calendar days. I believe now i am sufficiently clear. Please provide me any clues if this can be achieved.
regards
Deb
Top
Mon, 2008-01-07 12:23
#6
Johny Kesserwany
User offline. Last seen 8 years 15 weeks ago. Offline
Joined: 18 Sep 2007
Posts: 118
Groups: Civil Engineering
The Schedule variance is calculated in P3 independently of the type of ’Days’! :

The Budget Summary form displays the planned value (BCWS) and earned value (BCWP). In earned value analysis, you can
compare BCWP to the BCWS and to the actual to date (ACWP).
The planned value reflects the work that should have been finished as of the data date according to the target plan; earned value measures the value of the work actually accomplished as of the data date. The difference between these two figures is called schedule variance (favorable if the earned value exceeds the planned value). The difference between ACWP and earned value is called cost variance (favorable if the earned value exceeds the actual cost).

P3 calculates earned value as the product of the budget and the resource percent complete. P3 uses schedule percent complete (PCT) if the resource percent complete is blank. P3 calculates the planned value as the product of the budget and the percent complete that the target should be on the current data date.

Regards
JK
Top