Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI'm with you, TurboToad. I couldn't figure out why I needed a macro and also removed an if statement by concluding 0 resources needed was a "Yes".
Tool golf! (4 tools)
My try! Also did it without macro.
Why do we consider Period 9 in East as an one unmet requirement? With zero resources needed and no resources allocated, it is a perfect match for me.
I found it tricky to understand the resource usage. Perhaps it is a product like a software free trial - that may explain why it could be used in multiple regions but only once per region.
I also agree with several of the users above that when 0 resources are needed, the need is met regardless of the resource availability.
Initial workflow
set up candidate resources, a total pool of resources, and prep regions
Batch macro
Iterative macro
My solution witout macro.
Was going to say it like it was Butch Cassidy and the Sundance kid: "Macro? We don't need no stinking macro"
But it seems, that's the majority of the consensus, I didn't see a need either. Short, sweet, clear, simple.
I agree with someone else who posted about "0 needed" being no, I actually labeled them N/A.
My solution without macro.
(It would be simpler to use the GetPart function, but my version did not have it)