MECC August Weekend Battle '25 - Walkthrough by Nick Boberg - PipeMare (V) скачать в хорошем качестве

MECC August Weekend Battle '25 - Walkthrough by Nick Boberg - PipeMare (V)

Join Nick Boberg, MECC Friend and Excel Esports Player and Case Designer as he guides you through the Juan José Cifuentes PipeMare Case from the 2025 MECC August Weekend Battle (Varsity Level). This comprehensive tutorial is perfect for students looking to enhance their Excel skills and confidently tackle challenging cases. 0:00 Intro and case overview 2:55 Level 1: Counting pipe occurrences in storage 3:39 Level 2: Concatenated translation using connects to mapping 4:39 Level 3: Counting pipes connecting in a given direction 7:53 Level 4: Counting matching connections for a pipe (two directions) 13:07 Level 5: Pipes not connecting to previous pipe in sequence 16:38 Level 6: Calculating pipe maze length using INDIRECT formula 20:11 Level 7: Reporting source and outlet corners of pipe sequence 27:08 Bonus 1: Counting pipes excluding sources and outlets 28:05 Bonus 2: Pipes connecting to a specific direction (left) 29:18 Bonus 3: Pipes not connecting to previous pipe exclusion 30:16 Bonus 4: Counting wall sections in pipe sequence areas 31:00 Bonus 5: Most frequent four-letter code excluding example 32:03 Closing remarks