Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #14: Warehouse Distribution

Dazzerman
11 - Bolide

Here is my solution :

 

Spoiler
I elected to used Multi-Row Tool rather than Macros to achieve this solution.

Challenge14.jpg

 EDIT

 

Decided to have a go at this challenge using a macro as well, and ended up using a Batch macro to solve it which worked out well.

 

Spoiler
Challenge14_macro.jpg
ZenonH
8 - Asteroid

Package delivered. 

Spoiler
ZHSOL.png
justindavis
10 - Fireball

Am I proud of it? No. Does it work? Yes. Should I try again with the macro approach? Probably...

Spoiler
challenge_14_solution_justindavis.PNG
SueDonim
8 - Asteroid

Pretty straight-forward this time (and I did a lot better than I did with the last warehouse problem faced)

 

Spoiler
Process:
- Join Store and Required data
- Sort results by Item then by Priority
- Join with warehouse Count in stock
- 1st Multi-Row tool groups by Item and decrements Count by amount required per store (but can't go below 0)
- 2nd Multi-Row tool groups by Item and calculates the Assigned amount which will equal Required, except
  -- If Count has decreased to 0, then Assigned is equal to Count of the prior row
- Clean-up data
- Sort by Store then by Item (both ascending)

MySolution.PNG
nivi_s
8 - Asteroid

Challenge #14 Solved!

 

Spoiler
clipboard_image_0.png
KT2
7 - Meteor
Spoiler
 

Boom.

Stevej028
7 - Meteor
Spoiler
image.png
rslopez2
8 - Asteroid
Spoiler
RLWK_14Macro.png
Spoiler
RL_wk_14workflow.png
Inactive User
Not applicable
 
dsmdavid
11 - Bolide

Previously here, missing the file.