While you deliver
Overallocation Finder
Put every project's assignments in one place and see who is booked past the hours they have, in which weeks, and on which work.
Read assignments from spreadsheets, .xlsx or .csv, or Microsoft Project XML exports, one project or several, inside your browser. Nothing is uploaded.
Assignments
Add every project’s assignments: spreadsheets with a person, a start, a finish and how much time, or Project XML exports with resources assigned. The more projects, the truer the picture.
A project's assignments
Drop a spreadsheet here
Person, task, start, finish, and a percentage, hours a week or total hours.
From Microsoft Project: File, Save As, XML Format. Resources and their assignments are read.
Why one project is not enough
Each project plan books its people sensibly. Nobody sees that the same developer is at 100 percent on one plan and 40 percent on another, because nobody holds both plans. Add every project’s assignments here and the tool adds them up for each person, week by week, whoever made the plan and however it was written.
Against the hours they really have
Booked hours are set against available hours: the working days of each week on your calendar, times the hours in a day, times the share of the week the person works, less any days they are away. A part-timer booked full time shows up at once. So does a person booked on the week of their holiday, which a plan that ignores leave will happily do.
What fills the week
For every week that is over, the tool lists what is in it: this task on this project for so many hours, that task on another for so many more. That is the conversation to have, with the people who own each piece of work, and the tool leaves the choice of what moves to them.
How assignments are read
A spreadsheet needs a person, a start and a finish, and how much time: a percentage, hours a week, or total hours spread across the working days. A Project XML export is read for its resources and their assignments, with each assignment’s work spread evenly across its days. Names are matched ignoring capitals and spacing, and the team list’s spelling is shown.
What this does not do
It does not level resources or move work; it shows where the conflicts are. Work that a plan front-loads or back-loads will not match week by week, because assignments are spread evenly. For demand by role rather than by named person, use the Resource Capacity Planner.