Challenge #14: Warehouse Distribution

[ydmuley]

Slightly different from the provided solution.

I used a Multi-Row formula to arrive at the Running Total instead of Running Total tool and used a separate formula for values < 0 to be marked as ZERO as compared to the same nested IF formula. Good Learning!!!!

The solving thrill continues!!!!!!!!!!!!!!!!

[josh_brandt]

Good practice with Macro's - I first started iterating on the stores/items, which in hindsight didn't make much sense. 

[aking]

Well it is easier than the first time I did the iteration but still needed more help. Good learning process for this one. 

[tcroberts]

Here's my no macro solution:

Spoiler

I experimented with a few different workflows, but managed to get it super short using the Running Total tool and a nested conditional statement to keep allocated values non-negative

I'll attach a macro version shortly.

I wish the second solution could be update though, would be interested to see the 'official' macro-based solution.

[Mikkel_D_Karlsen]

My Solution

[Treyson]

We used this one to demonstrate an Iterative Macro to our business! Thank you guys again for putting these out!

[Kenda]

The second solution file attached is actually for challenge 11, not 14, so I compared my workflow to others, and it seems pretty similar to @NicoleJohnson's!

Spoiler

This was a good way to brush up on my iterative macro skills!

[danilang]

Macro-free solution.  Multi row to the rescue!

Spoiler

Dan