MECC June Weekend Battle '25 - Walkthrough by Joseph R Walsh - Collecting Scarves (JV) скачать в хорошем качестве

MECC June Weekend Battle '25 - Walkthrough by Joseph R Walsh - Collecting Scarves (JV)

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