Challenge #14: Warehouse Distribution

[johnsand]

Using iterative macro

[Courchaine_]

Spoiler

1) Joined Store Priority and Store Required data, followed by a Join of the result to the Store Inventory Data
2) Sort for the result of #1 by Item (Ascending) followed by Priority (Ascending)
3) Running Total, grouped by Item, with the running total based on the Required stock
4) Formula to add new column called "Remaining" with the following if [Count]-[RunTot_Required] <0 then 0 else [Count]-[RunTot_Required] endif
5) Select tool to adjust data type
6) Multi-Row Formula if [Remaining]=0 then [Row-1:Remaining] else [Required] endif
7) Select to adjust order of columns
😎 Sort on Store (Ascending) followed by Item (Ascending)

[sesterly]

Spoiler

used formula and multi-field formula tools for most interesting parts.

[cstroh]

Spoiler

Join
Join
Sort
Running 
Total
Formula
if ([Count]-[RunTot_Required]) < 0 then 0 else [Count]-[RunTot_Required] endif
Select
Multi-Row Formula
Select
Sort

[mbodell]

Spoiler

joined the three sources, sorted, calculated the remaining inventory, created an if statement for those which exceeded, resorted

[DavidJShi311]

Spoiler

After completing the necessary joins, the running total works really well to determine total items assigned.  The multi-row formula can reference that last total to determine total that is assigned.  

[rachelglascock]

Spoiler

Used two joins and a couple formula tools and select tools to get from point A to point Z! 

[ASAHM]

Spoiler

Joined the data into one sheet, sorted by priority then developed a running total for the inventory left, then made a formula for negative numbers to be 0, reformatted data, made a multi-row formula to grab the cell above when the running total was a 0. Resorted by store and item