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.
each current schedule activitys "Variance" (es or ef) is measured against the referenced target schedules 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.
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
Member for
18 years 1 month
Member for18 years1 month
Submitted by Johny Kesserwany on Tue, 2008-01-08 09:50
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
Member for
18 years 1 month
Member for18 years1 month
Submitted by Johny Kesserwany on Mon, 2008-01-07 12:23
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.
Member for
17 years 8 monthsRE: Calculation of Variance
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
Member for
21 yearsRE: Calculation of Variance
each current schedule activitys "Variance" (es or ef) is measured against the referenced target schedules 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.
Member for
17 years 8 monthsRE: Calculation of Variance
.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
Member for
18 years 1 monthRE: Calculation of Variance
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
Member for
18 years 9 monthsRE: Calculation of Variance
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
Member for
18 years 1 monthRE: Calculation of Variance
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