Challenge #415: Efficient Resource Distribution Using Macros

[AYXAcademy]

Hi Maveryx,

A solution to last week’s challenge can be found here. 

Community members Nathan Purvis (@DataNath)  and Luke Cornetta (@Luke_C) , submitted this challenge, which is a perfect opportunity for those of you looking to hone your macro skills! Thanks, Nathan and Luke!

A company that has a set number of resources available annually wants to strategize resource allocation across the various regions it operates in. They provided you with a list that details each region’s current resources and the anticipated resource needs for each period.

For this challenge, assign resources to the regions for each period and flag any periods with unmet needs. Remember, a resource can be allocated only once in a specific region.

In Academy, you can find several lessons about macros that can help you solve this challenge. Creating a Batch Macro and Creating an Iterative Macro will definitely be useful.

Good luck!

[alexnajm]

The way of the macro!

Spoiler

[mmontgomery]

Neat challenge. Done without a macro

Spoiler

[AkimasaKajitani]

My No Macro solution!

Spoiler

 

Batch macro solution!

Spoiler

[RWvanLeeuwen]

HELP! I mean, help me to help you :)

@AYXAcademywhat is the objective? Do we want to optimise the number of resources we use? Do we greedily add resources to periods and regions? Is this list of Resources in order or priority? (first pick compared to others)? Is it reasonable that we have Resources that can be planned for both the North and South region, or even for three regions at the same time (like resource 85029)? Do we prioritze regions with the highest need of resources, or to have the most period*region combinations filling up to meet the demands?

[RolandSchubert]

Spoiler

Nice challenge, did it without a macro

[messi007]

I have done it with a batch and iterative macros :

First the iterative :

Spoiler

Then the batch macro :

Spoiler

And my main workflow to call the batch macro :

Spoiler

It's a good challenge to improve my iterative knowledge :)

Best,

[ahsanaali]

Spoiler

 

[ed_hayter]

Spoiler

Not my finest piece of work but it gets the job done.

[TurboToad]

Non-macro solution. Also marked any rows where 0 resources required as Resources Met - Yes.

Spoiler