Challenge #415: Efficient Resource Distribution Using Macros

[RWvanLeeuwen]

@AYXAcademynever mind!

Here's my take on this topic.

Without macros and without any issues on supply/demand

Révélation

if you ask for the most, you will get the least.... with that principle I added priorities for regions and periods. for resources I did it the other way around because high priority resources are in high demandafter crossjoining all resources with all region/period data, I filtered and sampled to keep only one resource*period row.... Apparently all needs can be met

 I even built a super ugly dashboard to check whether this result is correct, and it seems to be:

Révélation

[RWvanLeeuwen]

dashboard image cannot be uploaded somhow, let's retry

Révélation

ugly but is shows resource priority and resources + the regions where they can be allocated

[alacoume]

A solution without macro:

[balajilolla2]

Révélation

Solution Attached

[AUX]

There is no mentioning in the challenge about the optimization needs for the resources.

Révélation

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.

[kelvin_law1]

Here is my solution using Batch Macro:

Révélation

[olga_strubbe]

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: 

[ksukhraj]

This is very well structured and easy to understand. Thanks for sharing.

[RashedDS]

Révélation

 

[ggruccio]

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.

Révélation