Automated Assignment

757
1
10-04-2016 02:13 PM
RonKnepper
Occasional Contributor II

So wondering if anyone has come across this case.  We have 2 data sets: one has thousands of locations with fields for status and assigned inspector, then another data set for inspector locations with a field for the max number each can handle.  Trying to determine an approach to run a script which will take the first inspector and assign locations to each inspector up to their max.  Once the first inspector is assigned their max, the next inspector assigned up to their max until all are assigned.  Next time the script is run it will look at the first inspector, check to see how many locations are assigned and open then assign additional as needed, then through each inspector.

0 Kudos
1 Reply
DanPatterson_Retired
MVP Esteemed Contributor

Never seen that, but I have seen example where the locations are parsed not only to an individual but to minimize their drivetime, before moving on to assigning to the next individual.  Fairly complex and requires human intervention.  A naive approach would be just to slice the list (N) into chunks of 'n' and assign accordingly to 'm' individuals until N is exhausted

0 Kudos