Hi Andrew>> thanks for sharing the video... I just wondering in LET function, why did you calculated the min of (R,C) and then included the 5*(R-D), and 3*(C-D) and kept the 4 without including the R.... if it's possible to explain.. I would appreciate it
It's almost comical how easy you made this one look. You take such little time thinking of how to do the solution so it's all spent just doing it. For example I'm sure it would take most people some time to think about using the data table with offset on the last bonus but you seem to find that without really thinking!
6:49 I like to think I’m seeing my influence in you going straight to a LET like this. If only you didn’t take it and do it better than me 😂 That was an impressive run!
I kicked myself when I watched how quickly you rearranged the columns in the later levels to match the layout in the earlier ones. And a little bit again when you manually tagged which ports would need a canal in about 15 seconds! Watching your solves reminds me that I’m often too much of a purist for my own good…
May I know your Educational background? I am thinking if After matric I wil spend my time learning Ms excel then is it important to have strong educational background for Ms excel jobs? Or only the skill is important?
Great as usual! I really liked the model you made for level 7 with just filtering the aliens and ghost for whole map (I love it). I am just wondering about the top screen of scoring! Did you made after receiving the answer sheet or how did you get it?
Oh that scoring is not live, yeah its done after getting the answer sheet and I just overlay it there for the video so its a bit easier to follow/remember the question
I've always felt amazed by @DimEarly capacity to trigger some complex formula that easily. I'm evenly amazed by the speed you are able to trigger simple formulas (How I loved hearing your keyboard fast strokes during the video :) ) Congrats for the qualification and the win !
Congrats Andrew. Such elegance & efficiency in getting the job done without a ton of complex formulae. Add lightning fast speed (even on slow playback!) and just WOW!! I am new to FMWC and the skills in this competition blow my mind. You've inspired me to learn to use data tables properly before the next round!
What a time to be alive! Watching the 3x champ face a case like this is incredible. It is also incredibe the speed you navigate through everything, Andrew! After Dim (who made some LAMBDAs beforehand), you would have been first place! Congratulations!
"Then I started looking at the scoreboard and hoping it would stay the same" I felt this to my core, glad it's the same right at the top! Thanks for sharing, great to see
What is this magical move at 19:04 ? I don't even understand how it can automaticaly go to pick the good prices at the good date knowing all the initial calculations are being done with the prices of 3 jul 23...
oh that's a data table, sorry i'm clicking the Ribbon but it's hidden behind the banner which I added to the video to keep track of the question/scores Data > What-If Analysis > Data Table, then set column input cell to the cell which you want to vary (in this case A1)
You solved Bonus 2 and 3 so fast. I'm very impressed. Thanks for posting this! Very interesting to watch someone else's approach. I do wish you'd shown your score and reacted to it a little bit, even if you didn't go back and try to solve them again. Also, you ran into the same issues I ran into when trying to do a walkthrough of this case. On level 6, where you actually can leave the designated area. And I'm glad to see you got the same answers as I did on Level 8. The way you solved Bonus Question 5 was similar to Diarmuid Early and missed the double occurrence that appeared in one of the rounds.
Thank you! Will keep that in mind next time :) Might be an issue with the answers if we all got the same issues. Your comment on B5 is interesting though. From the question wording, I think it's not clear whether double occurrences should be treated as two separate instances, or that "3 in same cell" simply satisfies the "2 in same cell" condition. Unfortunately there'll always be some questions where it's easy for different competitors to interpret slightly differently.
I don't think the type of computer is that important, Excel doesn't use a lot of resources (at least for the cases in the competitions), you probably just want any keyboard and mouse that you find comfortable and a decent size monitor
Exciting, looking forward to watching it. It would have been interesting to see the live event - FMWC could, next time, have streams on all the finalist individually. Just a thought. Happy to learn from the best!