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.
hi! can you provide an expected output for this? thanks!
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?