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

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