I would like to know , based on the assigned calendar, how many days (duration) passed since BL start date till data date? is there any easy way to get this AT WBS LEVEL?
A work-around may be: Testproject --> one activity per calendar - with duration=1 year - you want to show with that specific calendar assigned. Set timescale (Gantt chart) to week and day; bars: Neck for non-working time. Then either show/print the Gantt chart with those activities or create a report and export to EXCEL.
Actually I just wanted to have a list of non-working days for each different calendar in my programme,
That way others without the knowledge of the software (like the clients representative) would know why certain activities have short duration but long looking bars.
Member for
18 years 9 months
Member for18 years9 months
Submitted by Dieter Wambach on Tue, 2009-12-01 01:49
Within the Primavera database calendars are a binary block - not accessible with standard tools. Ive heard that the API can read and transform it. But neither Im sure nor a programmer.
Tell what are your needs. Maybe somebody will know a work-around.
Member for
8 yearsDears, I would like to know
Dears,
I would like to know , based on the assigned calendar, how many days (duration) passed since BL start date till data date? is there any easy way to get this AT WBS LEVEL?
Member for
15 years 10 monthsRE: Exporting the Calendars?
If you have Primavera ERD database, you can get this details from Calendar table in workdayflag column.
Member for
21 years 7 monthsRE: Exporting the Calendars?
thanks for the advise, this has been great help!
Member for
23 years 8 monthsRE: Exporting the Calendars?
Further to Dieters proposed, assign a resource in 1 unit per day to that activity.
Then export the resource assignment per day (by change the time sclae into day) on excel, the "zero" value will be non-working day.
This easy than to examine where the necking on a bar for me. On spreadsheet, we can filter those "zero" value out quick
Member for
21 years 7 monthsRE: Exporting the Calendars?
Thanks Dieter, that might just work and keep them off my neck for the time being.
Member for
18 years 9 monthsRE: Exporting the Calendars?
Nickie
Thank you for reply.
A work-around may be: Testproject --> one activity per calendar - with duration=1 year - you want to show with that specific calendar assigned. Set timescale (Gantt chart) to week and day; bars: Neck for non-working time. Then either show/print the Gantt chart with those activities or create a report and export to EXCEL.
Dieter
Member for
21 years 7 monthsRE: Exporting the Calendars?
Actually I just wanted to have a list of non-working days for each different calendar in my programme,
That way others without the knowledge of the software (like the clients representative) would know why certain activities have short duration but long looking bars.
Member for
18 years 9 monthsRE: Exporting the Calendars?
Nickie
Within the Primavera database calendars are a binary block - not accessible with standard tools. Ive heard that the API can read and transform it. But neither Im sure nor a programmer.
Tell what are your needs. Maybe somebody will know a work-around.
Good luck
Dieter