Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA@AYXAcademynever mind!
Here's my take on this topic.
Without macros and without any issues on supply/demand
I even built a super ugly dashboard to check whether this result is correct, and it seems to be:
dashboard image cannot be uploaded somhow, let's retry
There is no mentioning in the challenge about the optimization needs for the resources.
Based on the provided output, it looks like the resources are assigned period by period to meet resources needed. So it should be straightforward to use Resources column and ResourcesNeeded column to get the assignment for each period.
A neat challenge, thank you, @DataNath and @Luke_C! It gave me a hand at batch macros with the pieces finally starting to come together :)
I would like to give a credit to @AkimasaKajitani as being my inspiration in solving this challenge. Thank you, @AkimasaKajitani - I liked the fact that you've created a Row Position field to align the number of resources needed for each region with Row Position - this made it an easier way to solve it for me.
Workflow:
Batch Macro:
This is very well structured and easy to understand. Thanks for sharing.
An iterative approach to building the iterative macro because it took a few times to get all the logic. Once everyone was matched, I then checked against the original data to find out if all were assigned.