Overallocated Resource Report
in [Project]
|
From: rive on 7 Feb 2006 13:30 Hi Can anyone provide me some assistance in creating a MS Project 2002 overallocated resource report? What I would like is a text report showing which resource is overallocated (i.e. > 8 hours per day) for which activities and on what dates. Maybe I need MS Project 2003 to do this? Any assistance would be most appreciated. thank you -- rive
From: "JulieS" <passport6847 at maine dot rr dot on 7 Feb 2006 15:56 Hi rive, Have you looked at the Overallocated Resource report in View > Reports > Assignments? It does not show which specific activities and which dates but it may be a start. MS Project 2003 is not needed. I hope this helps. Let us know how you get along and please post back with any further questions. Julie "rive" <rive(a)discussions.microsoft.com> wrote in message news:432A487F-A748-427B-BAD4-C1D60D540E27(a)microsoft.com... > Hi > > Can anyone provide me some assistance in creating a MS Project 2002 > overallocated resource report? What I would like is a text report showing > which resource is overallocated (i.e. > 8 hours per day) for which > activities > and on what dates. Maybe I need MS Project 2003 to do this? Any > assistance > would be most appreciated. > > thank you > -- > rive
From: rive on 7 Feb 2006 16:16 Hi Julie Yes I have - but it does not give me the details I need. The only way to spot the conflicts is to print out the report under Reports/Workload/Resource Usage and visually inspect and highlight which resources are overallocated by date. When you are scheduling hundreds of tasks with over 75 resouces for a year, the paperwork this report generates is impressive, and to read through it and highlight the overallocated resouces is second only to Hercules cleaning the Agean stables out - only I have no river. Seems like a valuable report to have, just cannot figure out how to generate it. Any additional insights would be greatly appreciated. thank you -- rive "JulieS" wrote: > Hi rive, > > Have you looked at the Overallocated Resource report in View > Reports > > Assignments? > > It does not show which specific activities and which dates but it may be a > start. MS Project 2003 is not needed. > > I hope this helps. Let us know how you get along and please post back with > any further questions. > > Julie > "rive" <rive(a)discussions.microsoft.com> wrote in message > news:432A487F-A748-427B-BAD4-C1D60D540E27(a)microsoft.com... > > Hi > > > > Can anyone provide me some assistance in creating a MS Project 2002 > > overallocated resource report? What I would like is a text report showing > > which resource is overallocated (i.e. > 8 hours per day) for which > > activities > > and on what dates. Maybe I need MS Project 2003 to do this? Any > > assistance > > would be most appreciated. > > > > thank you > > -- > > rive > > >
From: "JulieS" <passport6847 at maine dot rr dot on 7 Feb 2006 17:13 Hi rive, I'm afraid I don't have a magic answer to your question -- and alas, no river. A couple of thoughts that may assist somewhat. Instead of using the Resource Usage report available under View > Reports, I suggest printing out the Resource Usage view directly with a couple of modifications: 1) Sort the view by the Overallocation field in descending order. (I probably wouldn't renumber the resource IDs). That should place all of the overallocated resources at the top of the view. 2) Add the Overallocated field to the time-scaled portion of the view to help gauge how severe the overallocation is. I think printing the view versus the report is *somewhat* more helpful in that the overallocations appear in red font making them much easier to spot. Another option is to use the Analyze Timescaled data to export the data into Excel. The problem is that doesn't bring over the information on the assignment names, so unless you know VBA (and I don't), you may be reduced to copy and paste. Perhaps one of the VBA "gurus" will weigh in. Sorry, I know it isn't exactly what you wanted. I hope this helps. Let us know how you get along. Julie "rive" <rive(a)discussions.microsoft.com> wrote in message news:0819D732-7B1D-4749-94F2-90BA0038A9CD(a)microsoft.com... > Hi Julie > > Yes I have - but it does not give me the details I need. The only way to > spot the conflicts is to print out the report under > Reports/Workload/Resource > Usage and visually inspect and highlight which resources are overallocated > by > date. When you are scheduling hundreds of tasks with over 75 resouces for > a > year, the paperwork this report generates is impressive, and to read > through > it and highlight the overallocated resouces is second only to Hercules > cleaning the Agean stables out - only I have no river. Seems like a > valuable > report to have, just cannot figure out how to generate it. Any additional > insights would be greatly appreciated. > > thank you > -- > rive > > > "JulieS" wrote: > >> Hi rive, >> >> Have you looked at the Overallocated Resource report in View > Reports > >> Assignments? >> >> It does not show which specific activities and which dates but it may be >> a >> start. MS Project 2003 is not needed. >> >> I hope this helps. Let us know how you get along and please post back >> with >> any further questions. >> >> Julie >> "rive" <rive(a)discussions.microsoft.com> wrote in message >> news:432A487F-A748-427B-BAD4-C1D60D540E27(a)microsoft.com... >> > Hi >> > >> > Can anyone provide me some assistance in creating a MS Project 2002 >> > overallocated resource report? What I would like is a text report >> > showing >> > which resource is overallocated (i.e. > 8 hours per day) for which >> > activities >> > and on what dates. Maybe I need MS Project 2003 to do this? Any >> > assistance >> > would be most appreciated. >> > >> > thank you >> > -- >> > rive >> >> >>
|
Pages: 1 Prev: resource underallocation Next: How can I copy my Auto correct file to another computer |