8:49 I realized when I watched Bo’s video that I hadn’t allowed for different sized aisles on this question. I only got it out because of luck (and maybe your generosity as a question setter - it certainly seemed like you were trying to avoid ‘gotcha’s).
Yes, I try to avoid gotchas as much as possible. My biggest hurdle in these competition is reading comprehension so I try to keep it relatively simple with as few rules as possible while still be challenging. A great example of this was your othello case. Easy to understand the question but still a challenge because it is a novel use of excel. I have created several lambda functions in case another case like that comes up again.
14:22 Thank you for this case and this solution I have a question please At the fifth level We used it full time On the other hand, we subtracted the balance cumulatively Please clarify this matter Why did we subtract the quantities from red to green? Then from red and green to blue Apologize for the translation
Thanks for the question. The reason I subtracted out red's total is because red went first. so Red takes from the original inventory and then green can take what is left over after Red went. Blue goes last so it can only take what is left after both Red and Green. does that make sense? here are the instructions from the case for level 5 There are 3 teams competing in the game. All the three teams are given a chance to shop. They will all have the same amount of time for their shopping trips, but they move at different speeds and choose different aisles.
The sequence of shopping is as follows: Red team goes first, followed by the Green team after Red is done, and finally, the Blue team after Green is done. During their shopping, each team is limited to taking no more than 5 items of the same product name. The units of a particular item taken by a team become unavailable to the other teams. One of the highest-priced products is Mixed Bouquet in Aisle #3. There are only 13 of these Mixed Bouquets available in the store. In Example5 the Red team will take 5 of these, then Green team will take another 5 and finally the Blue team will take the remaining 3 of these Mixed Bouquets.
Calculate the maximum possible retail value for the given team, assuming that all teams aim to maximize their total scores. Some teams may still have some time remaining when they finish shopping.
it is not mine to share. the FMWC add a lot of bells and whistles to it. if you want purchase it you can do that here fmworldcup.com/product/grocery-store-cleanup-rtlv2023/ They also have some cases for free on their site including the championship battle
8:49 I realized when I watched Bo’s video that I hadn’t allowed for different sized aisles on this question. I only got it out because of luck (and maybe your generosity as a question setter - it certainly seemed like you were trying to avoid ‘gotcha’s).
Yes, I try to avoid gotchas as much as possible.
My biggest hurdle in these competition is reading comprehension so I try to keep it relatively simple with as few rules as possible while still be challenging.
A great example of this was your othello case. Easy to understand the question but still a challenge because it is a novel use of excel. I have created several lambda functions in case another case like that comes up again.
14:22
Thank you for this case and this solution
I have a question please
At the fifth level
We used it full time
On the other hand, we subtracted the balance cumulatively
Please clarify this matter
Why did we subtract the quantities from red to green?
Then from red and green to blue
Apologize for the translation
Thanks for the question. The reason I subtracted out red's total is because red went first. so Red takes from the original inventory and then green can take what is left over after Red went. Blue goes last so it can only take what is left after both Red and Green. does that make sense? here are the instructions from the case for level 5
There are 3 teams competing in the game. All the three teams are given a chance to shop.
They will all have the same amount of time for their shopping trips, but they move at different speeds and choose different aisles.
The sequence of shopping is as follows: Red team goes first, followed by the Green team after Red is done, and finally, the Blue team after Green is done.
During their shopping, each team is limited to taking no more than 5 items of the same product name. The units of a particular item taken by a team become unavailable to the other teams.
One of the highest-priced products is Mixed Bouquet in Aisle #3. There are only 13 of these Mixed Bouquets available in the store.
In Example5 the Red team will take 5 of these, then Green team will take another 5 and finally the Blue team will take the remaining 3 of these Mixed Bouquets.
Calculate the maximum possible retail value for the given team, assuming that all teams aim to maximize their total scores.
Some teams may still have some time remaining when they finish shopping.
Thank you very much for these details
It's clearer to me now
@@harryseiders1336
Perfect 👍 please share data file for practice
it is not mine to share. the FMWC add a lot of bells and whistles to it. if you want purchase it you can do that here fmworldcup.com/product/grocery-store-cleanup-rtlv2023/
They also have some cases for free on their site including the championship battle