MECC August Weekend Battle '25 - Walkthrough by Nick Boberg - PipeMare (V)
Автор: Microsoft Excel Collegiate Challenge
Загружено: 2025-09-01
Просмотров: 196
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
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: