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.
