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 #48: Calculating Distribution Priority

nick_ceneviva
11 - Bolide

Solution attached.  Looking at the other solutions I should have used the running total solution to simplify this as opposed to using the Multi Row formula tool.

Natasha
9 - Comet

Since I am doing the challenges not in a chronological order I already encountered a very similar challenge that required to calculate items supplied. I find this one a bit more challenging as this challenge allows to make a partial fulfilment. 

 

Spoiler
In my solution I defaulted to my favourite multi row formula tool.
Screen Shot 2017-11-04 at 20.35.52.png


samN
10 - Fireball

Modified a macro from a past challenge to loop through each store by priority. Pretty fun!

ggruccio
ACE Emeritus
ACE Emeritus

Created iterative macro then answered the questions.  Fun!

PhilipMannering
16 - Nebula
16 - Nebula

Hopefully I've answered all three questions accurately. Solution attached.

 

Spoiler
challenge_48 - Snip.PNG
LandonG
8 - Asteroid

Solution attached.

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

struggled understanding how to assess priority, but the rework was minimal. a great challenge!

 

Spoiler
challenge48.png
jamielaird
14 - Magnetar

Here's my solution.

 

Spoiler
solution_48.PNG
JoshKushner
12 - Quasar

Honestly the third question is pretty confusing. couldn't get an answer to match, but I couldn't decipher the wording