Distance Matrix: Every Customer Town × Every Store
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Haversine: Straight-Line Distance from Latitude & LongitudeFree
- Distance Matrix: Every Customer Town × Every Store Pro
- Nearest Store per Customer with MIN and INDEX/MATCH Pro
- Catchment Rings: Counts and Revenue within a Radius Pro
- Drive-Time Proxy: Circuity Factor and Speed Assumptions Pro
- Territory Balancing: Workload per Sales Rep Pro
- Huff Gravity Model: Probabilities and Market Share Pro
- New Site Selection: Weighted Scoring and a Scatter Map Pro