Erickwidya,
The Calendar PSI will give you calendar exceptions for enterprise
calendars, while the Resource PSI will give you calendar exceptions for
resources. The Calendar Exceptions are interesting to work with, but as
you've discovered they can be challenging. It's rather difficult to
explain without code on a screen and a lot of coffee
) The best thing
I can suggest to just "shotgun" it in a console app and work through it.
Off the top of my head, here's your basic flow:
1) Retrieve calendar exceptions and their durations from the
aforementioned PSI services.
2) Determine if there are any calendar exceptions between today and
(today + n). Evaluate for any overlap between the two types of calendar
exception and adjust the value of x accordingly by addding the duration
(x) of said exceptions to (today + n), which results in (x').
3) Create a list of assignments that have a finish date less than or
equal to (x' + today + n) and process according to your business rules.
Hope that helps...
Steve
--
Stephen Sanderlin
Principal Consultant
MSProjectExperts
For Project Server Consulting:
http://www.msprojectexperts.com
For Project Server Training:
http://www.projectservertraining.com
Read my blog at:
http://www.projectserverhelp.com
Join the community at:
http://forums.epmfaq.com