Challenge #14: Warehouse Distribution

[Inactive User]

I did not go the macro route, but the job got done nonetheless!

[Hesham]

Solved this challenge using an Iterative macro

Spoiler

[MikeHinz]

I went the no macro approach

Spoiler

[David-Carnes]

Wow, it worked on the first try!

I thought my formula to calculate the quantity assigned when not enough stock was available was pretty clever:

Spoiler

iif([Count] - [Required] >= 0,
    [Required],
    [Required] + ([Count] - [Required]))

[NikolajFrosig]

Macro solution challenge 14

[TimofeyKapustin]

Iterative macro solution to challenge 14

[ADerbak]

Solution attached!

[EricR]

Here is my solution

[FRANCK_ROUQUETTE]

This one is a really challenging one to be solved using an iterative macro. I did it with both method (with and without iterative macro). For the iterative macro solution I finally used a kind of assignation rank (from 1 to max(priority)) as a counter to iterate. Thanks for the exercice - really interesting.

[FRANCK_ROUQUETTE]

This one is a really challenging one to be solved using an iterative macro. I did it with both method (with and without iterative macro). For the iterative macro solution I finally used a kind of assignation rank (from 1 to max(priority)) as a counter to iterate. Thanks for the exercice - really interesting. With the correct files (package including macro).