Scheduling algorithm based on expected labor hours vs available crew

[ladazhome]

I have been trying to create an algorithm to "schedule activities" based on expected labor hours vs available crew. Has anyone created something similar?

I already have my datasets ready, and I've been exploring using the multirow formula (but im having values updating values inside of an iterative macro). I'm using two examples I found, but I haven't identified my error.  I would appreciate a recommendation on how you would address a problem like this.

By one hand I have the WR vs expected labor hours:

WR	Expected labor hours
4400	31.7
3475	128
4868	1
5122	1
5425	1
5738	1
5594	1
5659	1
5665	1
5707	1
5789	1
5579	928.22
5805	673.96
5579	45.72
5619	41.82
4769	13.13
4940	433.88
6116	52.07
6126	1
5319	111.35
6144	1
6152	1
6201	1
5708	58.39
6272	1
6271	77.71
6285	1

Then by the other hand I've 10 crews, 200 hrs slots of available time to assign them tasks

Available Time (hrs)	Crew No
200	Crew 1
200	Crew 2
200	Crew 3
200	Crew 4
200	Crew 5
200	Crew 6
200	Crew 7
200	Crew 8
200	Crew 9
200	Crew 10

I appreciate any suggestions you could please provide me.

[shancmiralles]

hi! can you provide an expected output for this? thanks!

[apathetichell]

Honestly - you can probably use an iterative macro for this - but the optimization tool would be a better use case for this. I'm rusty on it -but perhaps you can check out the one tool example and play around with it?

[Qiu · Accepted solution]

@ladazhome 
I would think this as a Bin Packing problem.

We had a similar discussion here and based the solution I made some changes as below. maybe this will work?
Note that where is a duplication on WR number in your input, so I have modified it to another number.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/HELP-How-to-use-ITERATIVE-MACR...

[ladazhome]

My goal is to assign jobs to crews not passing the available time (200 hrs) and have a report that shows the distribution.

[ladazhome]

Thank you for this guidance.

I didnt think on using the mod and is great! definitely boost my start at this project

[Qiu]

@ladazhome 
Would it be possble for you to provide a sample date showing your goal?