MECC June Weekend Battle '25 - Walkthrough by Joseph R Walsh - Collecting Scarves (JV)
Автор: Microsoft Excel Collegiate Challenge
Загружено: 2025-06-23
Просмотров: 166
Join Joseph R Walsh, Senior Lecturer of Finance at Appalachian State University as he guides you through the Benjamin Weber's Collecting Scarves Case from the 2025 MECC June Weekend Battle (Junior Varsity Level). This comprehensive tutorial is perfect for students looking to enhance their Excel skills and confidently tackle challenging cases.
00:00 Intro – function toolbox & named-range setup
01:13 Challenge overview – manufacture vs travel, plus bonus section
01:34 Level 1 | COUNTIFS: count code “S” in each scarf
02:30 Level 2 | Colour name → code (XLOOKUP) then COUNTIFS
06:44 Level 3 | Count elements with LEN-SUBSTITUTE trick
09:55 Level 4 | Colour cost = element count × XLOOKUP cost
11:28 Level 5 | Total manufacturing cost per scarf (+ $200 setup)
16:17 Level 6 | Find scarf’s city with XLOOKUP
17:18 Travel-and-buy cost (100 √(Δx²+Δy²) + €15)
22:33 Bonus intro
22:44 B1 – Scarves starting with yellow
23:21 B2 – Longest city name
24:53 B3 – Scarf with most black “S” elements
26:20 B4 – Lowest single-scarf cost
26:50 B5 – Cost to manufacture all scarves
27:47 Wrap-up & goodbye
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: