MECC August Weekend Battle '25 - Walkthrough by Chris McNeil - PipeMare (JV)

Join Chris McNeil, MECC Faculty Fellow and Professor at the Appalachian State University, as he guides you through the Juan José Cifuentes PipeMare Case from the 2025 MECC August Weekend Battle (JV 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
0:27 Level 1: Counting occurrences of a pipe
1:09 Level 2: Pipe maze counting with named ranges
2:33 Level 3: Using XLOOKUP to find maze cell contents
4:30 Level 4: Lookup pipe mapping codes and concatenation
6:47 Level 5: Connects from/to analysis with XLOOKUP
10:51 Level 6: Cataloging pipes by connection direction and code
16:53 Summing connections and converting text to numbers
18:46 Data table setup for multiple game analysis
21:07 Level 7: Checking pipes not connecting to previous pipe
26:26 Checking pipe connectivity through digit codes
28:25 Using SEARCH and IFERROR for connection detection
31:43 Summing positions and connections that do not connect
33:42 Data table rerun and values paste special
34:39 Bonus questions intro
35:09 Bonus 1: Counting non-pipe elements
37:06 Bonus 3: Unique count of elements appearance
38:38 Counting occurrences for other levels
40:22 Bonus 4: Pipes connecting to the right
42:24 Bonus 5: Counting pipes not connecting in sequences
44:52 Closing remarks