none
Macro for a pop up message if resource has a parallel task RRS feed

  • Question

  • Dear All,

    I want to create a macro that create either, a msgbox with a hint or a column with a hint: that a resource is working on a parallel task at the moment.

    For example: I have a schedule (in MS-Project 2003) and if I move a task because of some technical reasons from one week to another, the macro should check after moving the task, if the resource on that task is also invited to another task at the same time (must not be overloaded, even if he works on a parallel task, even if that is only for 1 hour).

    The hint could be something like: "Be careful! Resource XY is also working at that time on task 41".

    Is that in any way possible to do something like that?

    I am very happy about any kind of help.

    Best regards,

    Toby

    Thursday, November 29, 2012 10:37 AM

All replies

  • Toby,

    Project 2010 has the ROG "Red Over-allocated Guy" graphical indicator that appears in the Indicators column if ever you schedule work to a resource that would cause them to be over-allocated.

    If you operate in a "Standalone" environment it will alert you to such situations in the schedule, if you are using Project Server it will alert you to such situations across all live projects. You can then use the Task Inspector to review the conflict and consider your best option to resolve the forecast problem.


    Dominic Moss MAPM Microsoft Certified Technology Specialist Wellingtone Ltd - Your Project Management Partner - Certified Microsoft Partner Specialising in EPM/PPM - Corporate Members of the Association for Project Management [APM] - Members of the Recruitment & Employment Confederation [REC] www.wellingtone.co.uk http://www.wellingtone.co.uk/blog Subscribe to The Wellingtone Project Management Newsletter Join the thousands of project management professionals who receive practical, straight forward advice, templates, tips and expert articles every month.

    Thursday, November 29, 2012 10:59 AM
  • Dominic,

    thanks for the very fast answer but that doesn't solve my problem.

    Because I need also an alert if there is no over allocation (50% on each of two task e.g.).

    Only the "parallel" should make a hint for me.

    Best regards,

    Toby

    Thursday, November 29, 2012 11:05 AM
  • Toby --
     
    If you were using the 2010 version of Microsoft Project, you would not be asking this question.  This is because the 2010 version automatically warns you of resource overallocations using a burning man or red stick figure in the Indicators column to the left of any task that has an overallocated resource assigned.
     
    To get advice on creating a macro to do this in Project 2003, I would recommend you repost this question in the Project Customization and Programming user forum at:
     
     
    Hope this helps.

    Dale A. Howard [MVP]
    VP of Educational Services
    msProjectExperts
    http://www.msprojectexperts.com
    http://www.projectserverexperts.com
    "We write the books on Project Server"

    Thursday, November 29, 2012 1:32 PM
    Moderator
  • Toby,

    I guess the other guys are focused on the overallocation idea but that's not what you are asking. On the other hand, maybe Dale is aware of a feature that I've missed.

    At any rate a macro could be developed to provide the "alert" you want but I wonder if it's really worth the effort to develop it. By using the Resource Usage view it is pretty easy to look at the resources's assignment Start and Finish fields to see if there is an overlap (doing that with code would take a little bit of effort). Or, you could just look at the timescaled data for a resource's assignments and visually see overlap.

    My thoughts.

    John


    Thursday, November 29, 2012 3:49 PM
  • @Dale: Thanks for the hint with the other forum.

    @John: Yes, exactly, not the over allocation is what I want. Thanks also for the hints with the views, my hope was to have in addition this kind of allert directly in the schedule/gantt view.

    I asked my question now in the other forum and may someone there can help me.

    Thanks anyway for the nice hints!

    Toby

    Friday, November 30, 2012 7:51 AM
  • Per John's advice, why not just split the view and show the resource usage view at the bottom.  Selecting the task at the top should show a visual of exactly the alert you're talking about without requiring customization.


    Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

    Friday, November 30, 2012 12:24 PM
    Moderator
  • Very good Andrew - reminds me of the following:

    The first American in space returned to earth with a blank notepad, he had been supposed to write down his observations whilst in orbit but his pen would not work in zero gravity. As a result the Americans, armed with the ability to solve problems with brains and money developed a pen that could write in zero gravity.

    The Russians confronted by the same problem equipped their cosmonauts with a pencil.

    Sometimes we can be so consumed by out ability to solve a problem in a complex way that we lose sight of what the problem actually is.


    Dominic Moss MAPM Microsoft Certified Technology Specialist Wellingtone Ltd - Your Project Management Partner - Certified Microsoft Partner Specialising in EPM/PPM - Corporate Members of the Association for Project Management [APM] - Members of the Recruitment & Employment Confederation [REC] www.wellingtone.co.uk http://www.wellingtone.co.uk/blog Subscribe to The Wellingtone Project Management Newsletter Join the thousands of project management professionals who receive practical, straight forward advice, templates, tips and expert articles every month.

    Friday, November 30, 2012 12:47 PM