Loading...
Quick Links

Automated process to check if a Resource has a unique calendar

Home Forums Discussion Automated process to check if a Resource has a unique calendar

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #125450 Reply
    Michael Wellhousen
    Participant

    Hello —

    I’m inquiring if there is an automated way (i.e. formula which could provide an indicator in an ms project column) if a resource has a unique calendar (i.e. the resource has non working days that are different from the project base calendar)?

    My reason for asking this is to determine if non working days for the Resource has been setup in ms project — I realize I could check the properties for every resource and review the “Change Working Time”, but obviously this is not very efficient.

    So, I would like to setup a customized column that would conduct a comparison between the Resource’s and the Project’s working time – If these are different, then it would indicate that unique working times have been setup for that Resource.

    Thanks in advance —

    Michael

    #125526 Reply

    Try the following formula in a resource custom text field, for example, Text1; and insert this field to the Entry table in the Resource Sheet to see the results:
    iif ( ProjDateDiff( [Start];[Finish];[Name]) = ProjDateDiff( [Start];[Finish];[Base Calendar]); “”; “Check Calendar” )
    Pls also see this article: http://www.msptips.com/ListCalendars.html
    Good Luck.
    Ismet

    #125774 Reply
    Michael Wellhousen
    Guest

    Mr. Ismet –

    Thank you for your response — Unfortunately, I received an error with your suggested formula.

    I was thinking about this and basically, the thing I want to check is total working days in the project base calendar versus an individual’s calendar. If vacation or other non working time has been set for an individual (which should almost always be the case), then the number of working days between the individual’s calendar and the project base calendar should be different, which be the condition I want to check.

    If(# Working Days Resource Calendar <> (# Working Days Project Calendar, “Resource Calendar Prepared”, “Resource Calendar Not Prepared”)

    Is there a way to accomplish this type of checking?

    Thanks again —

    Michael

    #125793 Reply

    Michael,

    Please try this:
    iif ( ProjDateDiff( [Project Start];[Project Finish];[Name]) <> ProjDateDiff( [Project Start];[Project Finish];[Project Calendar]); “Resource Calendar Prepared”; “Resource Calendar NOT Prepared” )

    The #ERROR situation is just because both Start and Finish hold NA for an unassigned resource. You can use [Base Calendar] instead of [Project Calendar], depending on the calendar use for resources.

    Regards,
    Ismet | ikocaman.pm[at]gmail.com

Viewing 4 posts - 1 through 4 (of 4 total)
Reply To: Automated process to check if a Resource has a unique calendar
Your information:




− 3 = 1