iterate assign value from another table based on groupings with running total limits

Question

Hi Community!

I have a fun one here, but have no idea how to go about it. Any clues much appreciated!

I'm making a work assignment for a team of 3, based on how many days each employee will be in the office that week.  Each row is one piece of work that needs to be assigned out.

Rule1: If ID-Loc-Order has duplicates, that particular group must be assigned to the same person

Rule2: runningTotalAssigned can't exceed workloadAssigned, or exceeds as little as possible in order to accommodate Rule1 first.

I filled in the "sample idea output" manually....I don't know how to:

STEP 1: iteratively assign

STEP 2: ensure that no one was assigned too much work

Thanks so much for taking a look!

Gina

AP_MerchWorkDir-HELP1.yxmd

Qiu · Accepted Answer

@Gina2021

It is indeed very interesting yet challeging one. Thank you.
I came to the point that assign equally and the result is that "Nina" is assgined "a  little" more.

Since the ID-Loc-Order is having many 1, so we should be able to assign perfectly equal, still working on how to close the loop.