Challenge #14: Warehouse Distribution

[LordNeilLord]

This one caused a bit of head scratching...

スポイラ

[DE0413]

I started out attempting an iterative macro but, still being new to macros, I couldn't figure out how to get the new count values to replace in the iterations.  I ended up using multi-row formulas to solve.  I'll be sure to check out all of the iterative macro solutions to hopefully get a better understanding of how those work.

スポイラ

[LordNeilLord]

Workflow

[sagarb]

Used running total and multi row formula tools. Going to try with macros as well.

[nick_ceneviva]

Solution attached.  I kind of took a shortcut with byte to handle the negative numbers but it seems to have worked.

[jamielaird]

Solution attached.  I used a running total and multi-row formula tool rather than an iterative macro.

スポイラ

[patrick_digan]

スポイラ

[Natasha]

I used two multi-row formulas instead of a running total, which is quite an interesting idea.

スポイラ

[MaxGiegerich]

Solved with the running total method as others have shared. Took a stab at the iterative macro and got stuck so thanks for highlighting that hole in my knowledge!

[JoshKushner]

This was quite fun! (A bit thrown that the category of this question is 'macros' when it doesn't require a macro though)