Hi All,
I have various delivery trucks each which can take the same load (for example 10 orders), data is listed similar to below
Truck | Load |
1 | 10 |
2 | 10 |
3 | 10 |
4 | 10 |
5 | 10 |
6 | 10 |
7 | 10 |
All orders must be assigned to a delivery truck, some have already been automatically assigned. The remaining orders must be assigned to a delivery truck with Order Priority in Descending order (i.e. High -> Medium -> Low) and Order No Ascending.
Order No | Vulnerable Customer | Priority | Assigned Truck |
1 | True | High | 1 |
2 | True | High | 7 |
3 | False | Medium | |
4 | False | Low | |
5 | False | Low | |
6 | True | High | 1 |
7 | False | Low | |
8 | False | Low | |
9 | False | Low | |
10 | True | High | 1 |
11 | False | Medium | |
12 | False | Low | |
13 | False | Low |
This is just a condensed example, the actual data contains hundreds of cases
Open to ideas on the best way to allocate this🙂
Thank you in advance!
Solved! Go to Solution.
Hi @Ashley2
I'll go for a batch macro and with each iteration, I'll recalculate the remained load capability for each Truck.
your parameter control will be the your order listed sorted by Priority and Order N.
Hope that's will help you
Thanks @OllieClarke that worked perfectly!
First time seeing dynamic replace very handy tool!