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

kbwissi
8 - Asteroid

Done!

catherineduffy
8 - Asteroid

Created my first iterative macro :)

pasccout
8 - Asteroid

Here is my solution

jssandom
8 - Asteroid

Really fun challenge!

kelly_gilbert
13 - Pulsar

This one was fun - some simple spatial operations, plus an inventory allocation problem!

 

Spoiler
Capture.PNG
Kenda
16 - Nebula
16 - Nebula
Spoiler

Seeing the other answers, utilizing the Running Totals tool probably would have been quicker and a little more intuitive, but I got there, nonetheless, with a couple Multi-Row Formula tools instead!
Also, I was admittedly stumped for a couple minutes at the start because I did not scroll down far enough to see the Warehouse Locations Text Input included, and I was really confused on how I was to figure out which one was located nearest to each store.

 48.PNG

JoshuaGostick
11 - Bolide

My solution :)

Spoiler
challenge_48.PNG

 

tan_mingh_ui
6 - Meteoroid

Better late than never

jbranaum
8 - Asteroid

My Solution

Suzu
9 - Comet

Here is my solution.