Resource overload report

the media fire link, which you have posted does not work, can you re-post it please?

• please try and let me know: http://www.mediafire.com/download/0izs5v17sltr3d1/RD008.002.sprj
• If it does not work I can send it directly to you, just contact me via PP e-mail. I always like to make my files available to anyone for their convenience and constructive comments.

Totally separate question: how do you use spider in the environment, when everybody around doesn't? You must be doing a lot of explanation in order to make sure, that your stakeholders agree to use Spider?

• I do not do any explanation it is either they use Spider or find another scheduler, very frequently they come back for help. I still provide other services such as quantity take off for their bids, something a contractor does not outsource unless they know you well, they can accept a Fly-by-night scheduler to meet the specs and use either MSP or SureTrak by their own if they do not want to spend more money into something I believe should be done in-house, none use P6 in house. Of course I do not have any objection to the use of a full time in-house scheduler provided by reputable firms in such case I favor they use whatever they choose. 
• To me Spider represents intellectual excellence for resource planning, it is a matter of professional choice to use best of breed. 

• Which over allocation-related reports do you personally look at, when working with Spider?
  • I frequently use standard reports and templates. At times create my own reports.
  • The following figure shows how you can see overloads summarized per week.
  • 
  • A negative free value means an overload happened.
  • There are ways to create tabular templates from diagrams but frequently must be modified. At times I do it by trial and error.
  • I posted the file so you can download it, do not pay attention to the title it was an existing file I modified and no longer uses variable assignments. Try changing resource quantities and look how free quantity changes. I suppose the free quantity displayed amount is the minimum experienced within the week period under this specific diagram report. In case of overload the minimum available is the negative value with maximum absolute value.
    • https://www.mediafire.com/folder/undefined/
• Does it make sense to ask Vladimir to implement option for resource over loads report to show only one entry for the whole period, when over allocation is caused by the same conditions (the same activities, the same resource availability?)  
  • I do not see the need, maybe it is a complicated issue as continuity of overload can be dependent on shifts, calendars and the user must define it somehow... Here it is Vladimir who can give us some light.
  • About the report generator I do not need any more, it is way too much over what I could ever do within other software.

Evgeny,

Managing resources is not always as simple as clicking the mouse or as if a cooking recipe, you might still have to execute some control as to improve what the resource leveling algorithm determined, it is limited by constraints you might release, it is of much value but some decisions must be made by the manager not the computer. Therefore at times I compare unleveled schedule to leveled schedule and look for over-allocations, here another field of much help is delay reason.

Managing of resources is better done by an in-house planner and his team, those that know better the schedule and to whom activities have real meaning rather than abstracts. Using optimization algorithm on every update can change activities sequence more than needed, stability of the activities sequencing is something you got to manage. 

By the way, this is how I would like all my jobs be managed but local practice is poor, perhaps due to prevalence of poor resource planning software. Many do not realize how big a difference the tool can make; like running on foot against a Lamborghini, but they do not know the existence of the modern car, they still move on bare foot. 

Best regards,

Rafael

It looks like the report is designed to identify continuous ranges, can be hours, minutes or days. Therefore if you define the resource to work non continuous hours instead of 24/7 the interruption will be shown at least once every day.

The following figure shows what happens when using 24/7 calendars and true continuous over-allocations, but I do not think you want to do that.

The report is great for finding over-allocations that are less than one day but for larger it might be easier at looking at the diagrams rather than at the table. To find over-allocations as small as 1 hr on the diagrams require expanding the timescale to hours and scrolling a long way, not a good idea. Over-allocations do matter, no matter how small, as it means the schedule is not feasible as long as there is a single over-allocation.

Imagine expanding following figure to display hours and then scrolling to visually find small over-allocations.  For each resource doing the same hundreds of times.