Distance Matrix: Every Customer Town × Every Store
This lesson is part of the course
In this lesson
You build an 8 × 5 distance matrix from customer towns to Maple & Rye stores with one formula and mixed references, then summarise each store's reach.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Haversine: Straight-Line Distance from Latitude & Longitude Locked
- Distance Matrix: Every Customer Town × Every Store Locked
- Nearest Store per Customer with MIN and INDEX/MATCH Locked
- Catchment Rings: Counts and Revenue within a Radius Locked
- Drive-Time Proxy: Circuity Factor and Speed Assumptions Locked
- Territory Balancing: Workload per Sales Rep Locked
- Huff Gravity Model: Probabilities and Market Share Locked
- New Site Selection: Weighted Scoring and a Scatter Map Locked