Iteratively assigning work based on duration?

Claje

Hi,

I have a problem that I'm trying to solve for with an Iterative Macro, and so far I haven't had much luck.

Essentially, I have a number of work efforts, alongside a duration, and a group of people who can be assigned work.

What I want to be able to do is check who has the least work, assign them the next work item, and loop iteratively through the dataset in order to continue reassigning efforts to workers.

Its possible that I really want a batch macro, but an iterative macro felt like a good option.

Anyone have any thoughts or suggestions?

The dataset is pretty straightforward starting:
Starting Workers:

WorkerID	HoursAssigned
1	0
2	0
3	0

Starting Actions:

Action_ID	WorkerID	Hours
1	0	2
2	0	1
3	0	3
4	0	1
5	0	2
6	0	1

Ending Workers:

WorkerID	HoursAssigned
1	4
2	3
3	3

Ending Actions:

Action_ID	WorkerID	Hours
1	1	2
2	2	1
3	3	3
4	1	1
5	2	2
6	1	1

Dynamomo

@Claje

You would want to use an iterative macro for this.  If you look at the "Assign Supply to Demand Sample" in the Sample workflows, it is a very similar problem to solve.  I have created a solution by using the append fields and then iterating through the worker IDs to assign them workers.  I'm going to let you try to solve it from here and if you need help, i have built out a solution.

Maureen