Summary Duration Incorrect

J
Joel Villanueva 👤 Member for 17 years

Hi Dieter,



It’s the Actual Duration, I found out that some activities have inconsistent time hour in Start & Finish dates. I revised it based on the 8hr/day work period and its shows now the correct actual duration in the roll up summary bar. Thanks a lot for the help.



Regards,

-Joel-

D
Dieter Wambach 👤 Member for 19 years 5 months

Joel



Which duration doesn’t follow your expectation?



Original, Actual, or the dates? or any other?



I assume a misunderstanding on the meaning of this data item. Switch on "Hint Help" (View-->Hint Help). Then move your mouse within that column. In the small window is an explanation of that field and how it’s summed up.



Regards

Dieter

(p.s.: I’ll leave PP for about six hours)

R
R. Catalan 👤 Member for 20 years 10 months

Bilal,



With regard to your Post # 15:



Tell them that to have the same durations as Primavera Software, the Excel calculation should follow the correct formula for CPM calculations of duration which is:



Forward Pass: D = EF - ES + 1

Backward Pass: D = LF - LS + 1



The first day is read as 0, so you have to add 1.



Hope the above helps.



Regards,

R. Catalan


J
Joel Villanueva 👤 Member for 17 years

Hi Dieter,



I am using 1 calendar for all activities which is a calendar converted to global and this is also my default calendar,and directly assigned to each activity. Is there might be a possibility that relationship of activities have contributed on this incorrect actual duration? I have a lot of SS and FF relationship on this schedule... Thanks.



Regards,

-Joel-

J
Joel Villanueva 👤 Member for 17 years

Hi Guys,



I tried to check the calendars but to no avail they are exactly thesame.I just recently discovered overnight,that I have a planned finish date on several activities greater than the Project mandatory project finish milestone date. I pull back those planned dates to within the mandatory finsh constraint date(Project Finish milestone) and it corrected the problem. My only ordeal right now is I don’t get the correct actual duration on my top WBS roll up summary band to be equal to my uppermost WBS summary activity. Thanks in advance for your help.



Cheers

-Joel-

D
Dieter Wambach 👤 Member for 19 years 5 months

Joel



As Bilal wrote the reason for differences always should be the calendar.

The duration of activities is taken from the activity’s not from the project’s calendar.

Please explain, which durations you mean, by which criterion you summarize.



Regards

Dieter

B
bilal tirmizi 👤 Member for 17 years 6 months

Heloo Joel

ur default calender shuold be 7 days working.

2nd check for ur hours per day of work

also check(in project calendar) how many leaves u have given like 5 days or 6 days

J
Joel Villanueva 👤 Member for 17 years

Hi All,



I have the same trouble with summary duration but it’s not just a 1 day difference it has an almost 1 year variance. My default calendar is thesame with my project calendar. Can anyone kind enough to list all possible causes of discrefancies of incorrect summary duration.Thanks.



Cheers

-Joel-

D
Dieter Wambach 👤 Member for 19 years 5 months

Bilal



Show him a calendar. Maybe you’ll explain to him that if you’ll start Sep 11 at 8am and stop at 5pm that is one day. Otherwise don’t pay him for that day. As Ravi wrote, the calculation of Excel is different.



In other words: let him work 549 days and pay 548.



Good luck!



Dieter

A
A D 👤 Member for 19 years 1 month

In Simple words,



if u calculate from say 11th sep 08 to 12th sep 08, then it will show 1 day only, while p6 will show 2 days, as two days have been conumed.



Its basically, mistake in excel formula rather than p6

P
PINAN T. 👤 Member for 18 years 10 months

you should explain to them that sep 11 2008 will be calculated immediately as the first day and not just the difference bet sep 11 2008 and mar 13 2010.



the calculation should be mar 13 2010 minus sep 11 2008 plus 1

B
bilal tirmizi 👤 Member for 17 years 6 months

I DONT WANT TO CHANGE ... ITS JUST THAT MY MANAGEMNT

GET FROM ANA EXCEL SHEET 548 DAYS AND TEHY WANT TO SE IN THE SAME MANNER FROM PRIMAVERA ALSO



AND OTHER THING MY CONTRACT MENTINS LIKE TAHT

548 DAYS STARTING FROM 11-SEP-08 TO 13-03-09



SO WHATS THE REMEDY

P
PINAN T. 👤 Member for 18 years 10 months

From Primavera calculation,



Sep 11 ’08 to Mar 13 ’10 equals 549



should be ok



why you need to deduct one day?

B
bilal tirmizi 👤 Member for 17 years 6 months

THANKS DIETER,



AS USUAL A PROMPT REPLY TO HELP FROM YOUR SIDE.



DEAR YOU ARE RIGHT I HAVE THE DETAILED WORKING HOURS LIKE THAT (8AM TO 5PM)



SO NOW WHAT I DO, CONSULTANT WILL NOT ACCEPT THAT


D
Dieter Wambach 👤 Member for 19 years 5 months

Bilal



If start is 8 am and end 5 pm (1h break) then it is 549.



Regards

Dieter

B
bilal tirmizi 👤 Member for 17 years 6 months

sorry project closing dat is 13-march-2010



i need soem urgent help on it

B
bilal tirmizi 👤 Member for 17 years 6 months

Gentleman

i am using a default calendar of 7 days a week and 8 hours

but my total calcutaion for the the level "show total" is not comming correct



my project starts from 11-sept-08 to 13-sept-10, duration equal to 548 days



but my summary bar shows 549 days



i have checked with hours per day they are same as 8 hurs and in default calendar there are no holidays

D
Dieter Wambach 👤 Member for 19 years 5 months

Mark

Default calendar for each WBS for my opinion would be too difficult to maintain.

Recently most of the main German EPC contractors had a meeting and we made this an enhancement request for Primavera. It seems that there is a chance for Ver. 7.



Please write this request to Primavera.



Regards

Dieter

M
Mark M 👤 Member for 18 years

G’day Mark



Agreed, & in my opinion it would be nice to see this for float calculations at summary also...?



My two cents...



Cheers

Mark

M
Mark Porter 👤 Member for 18 years 10 months

Thinking out loud...

Would a good enhancement be that you can assign a default calendar to each wbs element for the calculation of the summary level activity duration?

Mark

M
Mark Porter 👤 Member for 18 years 10 months

Gents,



I agree that this is a problem that can cause a fair bit of confussion even for the more experienced operators.



My work around involves assigning edit user preference authority to the planners in their idividual security profiles by selecting the "allow users to specify the number of work hours for each time period" & then getting them to adjusts the Hours per time period field to match the most dominate calender that is assigned to each project that they are displaying. This and all other project specific settings should be added as a project notebook topic so that all users can refer to the correct settings prior to configuring their idividual workspace.



Hope this helps & I will watch with interest any further ideas or debate that this comment may generate

Cheers

Mark

A
A D 👤 Member for 19 years 1 month

Thats a good work around, but eventually some (Idiot) project managers do ask the need of this LoE activity and question ur abilities to make a simple plan.



U need to explain to ur admin guys this problem and ideally global calender should be 7 days a week with no holidays and u can assign project calender what u want. I tried to explain to my admin guys, but to of no use. She still uses 40 hour global calender, as she has to report to management and she dont have those guts to better explain to management.



All d best!!!

D
David Kelly 👤 Member for 21 years 8 months

The only work-around I can offer is that you create either LoE or WBS summary activities which span the timescale that you want. When you schedule the project these activities will have their duration back-calculated using the calender that you give each LoE or WBS activity.

D
Dave Turnbull 👤 Member for 18 years 8 months

Thanks for reply, I have set up a project calender which works 24 hours 7 days a week, however the default calender in the enterprise-calendar-global is only on a 37.5hour week. I have tried to change it but it wont let me. Do you know how i get around this as at the moment my summary bars are of no use.

D
Dieter Wambach 👤 Member for 19 years 5 months

Dave

It’s a typical misunderstanding for a beginner. Duration in activity line are based on the calendar assigned to that activity; on the summary lines based on the default calendar of your database. You can find it under Enterprise --> Calendars --> select "global" --> look for the calendar marked in the default column.

Regards

Dieter

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts