Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #415: Efficient Resource Distribution Using Macros

AYXAcademy
Alteryx
Alteryx

Maveryx_WC_Banner.png

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!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

alexnajm
16 - Nebula
16 - Nebula

The way of the macro!

Challenge 415 Workflow.png

Spoiler
Challenge 415 Macro.png
mmontgomery
10 - Fireball

Neat challenge. Done without a macro

Spoiler
c415.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My No Macro solution!

 

Spoiler
スクリーンショット 2024-02-27 005048.png

 

Batch macro solution!

Spoiler
スクリーンショット 2024-02-27 212702.png



スクリーンショット 2024-02-27 212715.png

 

 

RWvanLeeuwen
11 - Bolide

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
16 - Nebula
16 - Nebula
Spoiler
W415.jpg

Nice challenge, did it without a macro

messi007
15 - Aurora
15 - Aurora

I have done it with a batch and iterative macros :

 

First the iterative :

 

Spoiler
Iterative.PNG

Then the batch macro :

 

Spoiler
Batch.PNG

And my main workflow to call the batch macro :

 

Spoiler
Workflow.PNG

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

 

Best,

ahsanaali
11 - Bolide
Spoiler
415.png

ed_hayter
12 - Quasar
Spoiler
Not my finest piece of work but it gets the job done.

image.pngimage.png
TurboToad
9 - Comet

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

Spoiler
415.PNG