@@Harryjackgross thanks, yes she is definitely kinder than Lana. I did consider giving her a fear of ducks and

@@harryseiders1336ducks and?

@@JeanWolleh try this one www.flexiquiz.com/SC/N/9e682396-af90-4bd1-82aa-d3a516a66238 Merry Christmas

@@harryseiders1336 Thanks Harry! Nice case :), I forgot to round the last level! looking forward to future cases!

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

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

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.

I see your point. The way I originally read it was what was the greatest possible increase, which I thought would mean ignoring the speed limit, so I would have answered 77. Once I saw that 30 was the "correct" answer I didn't consider the turning speed.

@@harryseiders1336 They gave me credit for 26 when I explained the rationale, so I can’t complain. Between missing the speed limit, misinterpreting the power-up, and missing the rounding, there were a lot of places that people stumbled on this case! But it’s so hard to take the time to read everything carefully when you know that might mean you run out of time… exam technique is a big factor.

I solved everything including level 4 using just INDIRECT and OFFSET. Ran out of time after L4, but I expanded the same logic with a few more helper columns and solved L5 too with INDIRECT and OFFSET

@@vikhattangady I thought the indirect offset would cause a REF# Error for level 5 by moving off the screen, and would further complicate goal scoring analysis when trying to work around the error.

I used the Map mostly for practice on level 1. Copy and paste is probably quicker but sometimes I stumble when trying to get the paste range and i like getting all the answers at once.

@@harryseiders1336 it did. I had to use some extra columns. 1 set for rows/columns of the starting cell, 1 set for the offsets, 1 set for the direct calculation, then checking if goal/out of bounds, then 1 final set to feed into the indirect formula

Thanks, The What if Data Table is a life saver and it is something I learned about through these excel competitions

Thanks indirect has always been my favorite obscure function. You almost never need it but when you do it comes in clutch