Microsoft Excel Tutorial: Finding best routing for a trip with 148 locations.
Hey Excel fam! 🚀 Bill Jelen here with an epic Excel challenge. 🏋️♂️ Joined forces with the Supernatural workout community to optimize a 148-location quest using Excel magic. 🌍 Check out the journey, from Tahiti to Antarctica, and witness the distance-cutting madness unfold. 🌐
💡 First attempt started in Tahiti, but the route was a rollercoaster. 🔄 Tried a radical pivot, starting in Antarctica. 🏔️ Improved the distance to 90,253 miles, but still seeking perfection.
🤔 Experimented with K-Means clustering, exploring different strategies. 🧩 Finally settled on a plan starting in Alaska, sweeping through clusters and ending in Antarctica. 🌈 Achieved a 85,911-mile route – progress, but the quest for the ultimate efficiency continues.
👉 Download the workbook via this link: https://www.mrexcel.com/youtube/19GKvAbauYM/ 📊 Dive into the data, explore the macro, and share your genius in the YouTube comments. 🤓 Let’s crack the code together!
👾 Calling all Supernatural enthusiasts! Add me, Bill Jelen, to your leaderboard. 🏆 If you’re curious about Supernatural, hit me up for a 30-day free pass. 🎮 Shoutout to Roxanna, ABSN, and the community for the original quest. 🙌 Thanks for stopping by – until next time, Like, Subscribe, and Ring the Bell! 🔔💬 #ExcelQuest #SupernaturalChallenge #MrExcelMagic
To download the workbook from today: https://www.mrexcel.com/youtube/19GKvAbauYM/
Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/
The formula for distance between two coordinates on Earth: =ACOS(SIN(RADIANS(B2))*SIN(RADIANS(B3))+COS(RADIANS(B2))*COS(RADIANS(B3))*COS(RADIANS(C3)-RADIANS(C2)))*3958
Table of Contents
(0:00) MrExcel playing Supernatural VR to workout
(1:01) Shortest Route
(1:20) ABSN Quest to travel around the Supernatural world
(1:54) Arrange west to east by sorting Longitude
(2:22) Excel workbook to search by location
(2:33) Mapping the trip using Excel with animated trails
(3:24) Distance of trip is 177 thousand miles
(3:45) Macro to find closest point
(4:50) Running the macro repeatedly
(5:06) India, Scotland, Antarctica all left
(5:44) Down to 94K miles
(6:00) Choosing Antarctica as start point
(6:32) Too many disparate places left
(7:14) Do I remember Python?
(7:29) Using k-Means Clustering
(8:07) Running the macro on each of 6 clusters
(8:42) Nominally better 86K Miles
(9:02) Invitation to download workbook
(9:18) Supernatural VR
(9:33) Clicking Like really helps the algorithm
#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial #excelchallenge #excelvba #excel3dmap #excelmaps
This video answers these common search terms:
excel supernatural workout quest, bill jelen excel challenge, optimize workout locations in excel, supernatural vr game excel tutorial, excel route optimization tutorial, 148 locations excel quest, k-means clustering for optimizing a route, excel macro for distance calculation, bill jelen 3d map excel tutorial, supernatural ninjas adventures excel help, absn adventures by supernatural ninjas, working out in supernatural vr in a meta quest headset, fitness game