Re: proportionality problem

A "greedy" approach ought to work. For each resource i with quality
Q_i, keep track of the number of requests N_i that have been assigned
to it. Let Q be the sum of all Q_i. Also keep track of N the total
number of requests. Then consider the requests one by one in any
order. You'll need to define the "error" in the assignments. One
reasonable choice would be

sum_{i} (Q/Q_i - N_i/N)^2

This error term is zero iff you have a perfect assignment according to
your example. Otherwise it's positive.

So now consider requests in any order. For each possible assignment to
a resource, compute the error that would result and pick the one that
produces the least. If there are many resources, you can use summation
tricks to avoid computing the whole error term for each.

You can fiddle with the definition of error to change the behavior of
the algorithm.

.

Relevant Pages

  • Re: Resource Usage by Task for Selected Tasks Only
    ... assignment) and I still get Asg1 when running the ShowTaskAssignmentdata ... the same data in the assignment custom field added to the Resource Usage ... Add the Text1 column to both Task and Resource Usage views. ...
    (microsoft.public.project)
  • Re: Formula problem in resource usage number field
    ... calculation for task+group summary rows: ... sums on resource level, ... some reason), no value on assignment level (sorry, I mistyped here in my last ...
    (microsoft.public.project)
  • Re: How can I track weighted future project needs?
    ... write formulas for the assignment row only on the resource row, ... can't calculate the weighed work per assignment. ... Project A 100% probability of award, Project B 50% probability, ... As your sales team gets closer to closing the sale, ...
    (microsoft.public.project)
  • Re: Multiple resources, varying units
    ... and put in the % values in the resource table, ... the formula works (duration * assignment = work). ... last two people are allocated at 100% assignment units. ...
    (microsoft.public.project)
  • Re: Task Definitions
    ... Project recalculates the results of this edit as you intend. ... I have a painter assigned to paint a room, expected duration of 5 ... In both examples one resource works 5 hours, ... I now edit his assignment, ...
    (microsoft.public.project)