Exporting the Calendars?

Member for

8 years

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 months

If you have Primavera ERD database, you can get this details from ’Calendar’ table in ’workdayflag’ column.

Member for

21 years 7 months

thanks for the advise, this has been great help!

Member for

23 years 8 months

Further to Dieter’s 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 months

Thanks Dieter, that might just work and keep them off my neck for the time being.

Member for

18 years 9 months

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 months

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 client’s representative) would know why certain activities have short duration but long looking bars.

Member for

18 years 9 months

Nickie



Within the Primavera database calendars are a binary block - not accessible with standard tools. I’ve heard that the API can read and transform it. But neither I’m sure nor a programmer.



Tell what are your needs. Maybe somebody will know a work-around.



Good luck



Dieter