Видео

Also just to clarify on level 2 it is the lake cells around the perimeter of the lake that you want, including the ones that only touch on one corner

Hi could I get a copy of this excel sheet?

This one is really tough. Good job getting so far on a timed solve. You made some of the early questions and bonuses look far easier than me!

I love how you stacked the different cells and were able to make that work quickly! That is super impressive! In the original solve I had each row being one cell and like a seperate turn and new counter/tracker column, and then did SUMIFS on it for the speed accumulation

3:38 😂

My bonus 4 there was a bit mean because it is really heavy calculation if you take it at face value - however if you think about the shapes the lines for level 3 draw out on the map there are only the full up/down lines, left/right lines are the two diagonals so there are not that many in the end!

I'm not a huge fan of the bonus 3 that was added because it doesn't say if it means including diagonals or not, I guess in their defence the rest of the case always included diagonals

Thanks Lorenzo! I think the slightly off error on the ice crystal one and a couple of the snowman ones was maybe about when you start on those things - will do more watching to try to check that and spot the other snowman ☃️ oness

This one was tough! : ) I think I performed worse because the reading time was so long - I spent 20 minutes thinking about a model setup that would be flexible to add extra titans, and then had trouble implementing it in the time. I'm pretty sure I would have fared better by just taking each level as it came (but of course, that wouldn't have scaled well to the last few levels, and hindsight is 20/20...) I'll try to revisit this one next week!

Thank you for putting this out it was really enjoyable and informative for me to watch!😊

On level 4 I think the missing ones are caused when something is going wrong with your M health when it links to the previous table, it looks like it could be linking to the health before the last attack on the previous row, rather than after it

I think bonus 4 went wrong for missing the triggering of Dim's ability in the second battle (to halve Andrew's attack)

17:00 The FMWC team put this question in I did not make myself a bonus answer 😭

Sorry about that level 3 description! I should have fleshed out the example rules more when writing this and written all 7 levels to avoid the confusion on level 3, the FMWC team made some changes to align it with the other cases that resulted in that level 3 being made and they wouldn't have had to if I had started off more aligned!

Hi w.r.t the tournament, was just curious to know, how did you'll focus on the stage with so much noise etc - i saw many were wearing headphones - were you people listening to music etc or those were some noise cancelling headphones? were you allowed to use your own laptops or you had to use the workstations over there?

😀 been waiting so eagerly for the recaps to start coming, so hungry for excel content after that! Thanks for the awesome speed! 🏎️🏎️

I'm so going next year! Seemed like so much fun based on all I've seen and heard!

That question 5 ruined me in the real thing!

Hah! Just did this one last night for the first time as well. Really good practice in the modeling side of excel.

13:17 'Of course it is' 😂

Nice work… for a home solve, at least ; ) This would have been a very risk approach if it were live - people started scoring the bonus points from quite early on (way before they solved all the levels, and even before they had time to think about good general strategies). I’m trying to get into that mindset as we gear up for Vegas…

Good content

How do you build that kind of formulas to find next cells based on directions input

Nice work! I honestly thought the data table for B5 would crash your Excel - you must have a powerful computer! : )

ottimi video, come sempre

You did really great man … keep up the great work in sharing your knowledge. You will get there for sure

Thanks for hosting, Lorenzo, this was a lot of fun. What a show of support from the community in the live chat, too!

Ciao Lorenzo, Si può avere il file ?

Damn this is such a clean and nicely laid out solution, makes mine look a mess! So crazy to go out with such a high score, I will face Peter next so going to be very hard for me.

I know well how painful this is! I didn’t even score as well as this in 2022, but I did get knocked out with the second highest score across the whole round. You vs Peter was always going to be a bloodbath! I’m glad you’re going to be in Vegas anyway - looking forward to meeting in person at last! 13:47 You can also use the optional argument in TOCOL to scan by column - that would flatten them out in the right tie-breaker order. (I think sorting could actually break in an edge case, although it’s not likely - e.g. B16 would come before B2 but both be equally far from B9.)

Thank you so much for creating these videos! I’ve learned a lot from your content, and it has really helped me improve my skills. Keep up the amazing work-looking forward to learning more from you!

without going into too much detail, I can see that the calculation for your Index 30 is wrong. it says 840 for a straight of 4 5 6 and ♣ which would be 4*6*5^4, also just a tip: If you want to filter on an array, you have to somehow get that into the structure of 1 Row N columns or N Columns and 1 row. Thats why you cant just = on more than one item. If you do it gets broadcasted, which doesnt work in FILTER. You could do something like ISNA or ISNUMBER with SEARCH, FIND, XMATCH or anything. more complex Filters with MAP, also work well in those situations.

3:04 When you find and replace by format from cell, it has to match the whole format - e.g. borders, font, etc. So it can be safer to just find the cell color if that’s what you really want to replace. (Maybe I’ll make a case some day where every cell in the map has a different font just to mess with people 😂) 1:00:27 Isn’t that within a few points of the top score? You’re a hard man to please! I’ll come back to watch L5 after I’ve got to try it myself…

Thanks for having me Lorenzo this was lots of fun!

Auguri Lorenzo! Avete fatto un lavoro belissimo! (Congrats Lorenzo! You make a great Work!)

This was great! I want to see more of these : )

This was a great video, really cool to see all the stats!

Damn what a long and hard case! I admire your dedication to stick at it here.

This was awesome!! You two should do a bracket breakdown

Great to see awesome collabs in the community!

Lot of work! Great! As I saw in live session one of presenters told that he was able to solve the case in 2 hours and half! You are there! :) Good luck and watching for you in Final round! ;)

48:02 I’m getting in your head! ; ) 2:04:17 So much pain captured in that moment… why do we do this to ourselves? 😂 I’ll have to come back for the end later…

I agree I really liked the storytelling of the case here. On the first part I had the same worry about the size of the table but did a few checks and looks like it was always 30 so I could reference the columns like normal. Funny we did the set up for the first half of the case exactly the same. Always a small error or lapse of thinking can cost you the case like for you the odd or even. Every case I feel there's something too so you're not alone there! Your pathfinder method for 5 is interesting, but seems time consuming compared to the way I did although my way was a bit manual. 6 was a very nice clean approach. Our approaches are actually very very similar in terms of how we think about solving the problems. I have my vid up if you're interested.

11:58 For Level 3 I solve it into a single function like @DimEarly but lost lot of time. My function form Example3: =LET(tab;SORT(SORT(SORT(FILTER(tRez;tRez[Battle]=H120);3;1);5;1);6;-1);poz; XMATCH(G120;CHOOSECOLS(tab;3)); INDEX(CHOOSECOLS(tab;3);poz+1))

15:34 If it makes you feel any better, I made the same very stupid decision! 😂 38:17 Every time I see you snip like this, I think ‘I should do that!’ - and then I forget to… 39:30 Go To -> Special -> Formula is your friend here!

For Pitagora Theorem is an Excel function SUMSQ()

20:03 That TLOOKUP working with an array is pretty nifty… I might have to steal that! ; )

22:46 I recognize that reaction - when you can’t quite believe that you got a hard question our first time! 😂 It would be heartbreaking to build a model like this in the competition and only get half the points for the level because of an off-by-one bug!

I was on the edge of my seat wondering if you’d make it on L6! I kept thinking ‘no, he won’t be able to do it from here in the time’, then thinking ‘wait, he still might!’. I did L6 the way you suggested, modeling one string for each players hand and for the pot at the end of each round, but I think your way could also work. If you added a column for an index within each player (i.e. count the number of occurrences of the current player up to the current row), then sort by that and then by player, it wouldn’t be too hard to interlace them. It’s still *very* hard to get it all done in the 30 mins, but I think you were closer than you gave yourself credit for!

L_ReverseArray: =LAMBDA(Array;[horizontal];LET(C;COLUMNS(Array);R;ROWS(Array);H;IF(OR(ISOMITTED(horizontal);IFERROR(--horizontal=0;0));0;1);IF(H;CHOOSECOLS(Array;SEQUENCE(C;;C;-1));CHOOSEROWS(Array;SEQUENCE(R;;R;-1)))))