Challenge #65: Fulfilling Inventory Orders

[brandowd]

Took me a bit longer than I expected and I'm sure there should be an easier way but I seemed to have followed the solution. I realise that it probably requires some iterative macro if you want to optimise it but I'm not that advanced (yet). Still good fun.

It's a shame that some tools (e.g. Multi-field formula, multi-row formula, Generate rows) that use formulas / expressions don't have the same intellisense as the main formula tool as would improve builds.

Spoiler

[pdave87]

Happy beginning of the week 🙂

PFA my solution. 

Data analysis is derived via multi field tool expression, which is always a great learning. It covers statistical permutation and combination method to fulfill the orders however, the task is to fulfill only those orders that are highest in quantity. It is a brilliant exercise as this can be a very practical use case scenario.

Thanks to SMEs.

Regards,

Pratik

[Original_Yodies]

Spoiler

[MichelleL]

Fun with MultiRow!

[simon_inviso]

My solution:

Spoiler

[cindyrez]

Thanks for the practice with the multi row formula tool.

[Joe_Lipski]

🙂

[AndrewSu]

my take 🙂 

[leozhang2work]

Spoiler

[DanTh]

Spoiler

Not quite sure I would say that two Multi-Row blocks should be "Beginner", but got there without too much trouble.

4/5