Challenge #14: Warehouse Distribution

[lainecaruzca]

my solution

[MikeLR]

That took some time and thinking!

Spoiler

[JP_SDAK]

This probably lended itself to an iterative macro, but I did it the brute force way instead since still getting the hang of macros.  I sorted by item and priority,grouped by item, and then started subtracting from inventory for each item.  To calculate assigned- if inventory was still positive or 0, then it was equal to required. Elseif abs(inventory) > required, then 0, otherwise required+inventory to get the amount fulfilled.

Spoiler

Spoiler

[bkwilson]

Back at it to try and get my advanced cert! This took me forever to figure out... Managed it with the iterative macro in the end!!

Spoiler

[dssnek]

Spoiler

 

[enwiegand]

Macro didn't really make sense to me either... 

[Romy]

My non-macro solution for this problem:

Spoiler

[enwiegand]

Slept on it and the macro came to me in my dreams😃

[JBraithwaite]

My solution

[NikitaParab]

Tried it without Macro

Spoiler