Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
This one was a little tricky. Got my head around it eventually though.
Spoiler
I started by joining the the sets together then sorting into SKU order, then by the highest demand on each order.
I then used a couple of multi-row formulae, the first to determine if there was a greater supply than required on the fulfilled amount on the previous order and the demand of the current order combined, therefore determining if the max fulfilled amount had been reached, and the second to determine if that meant the current order had been completed or not.
Then it was simply a matter of calculating the remaining amount on each row and removing those that were not fulfilled.
I then used a couple of multi-row formulae, the first to determine if there was a greater supply than required on the fulfilled amount on the previous order and the demand of the current order combined, therefore determining if the max fulfilled amount had been reached, and the second to determine if that meant the current order had been completed or not.
Then it was simply a matter of calculating the remaining amount on each row and removing those that were not fulfilled.
M.
