Haversine: Straight-Line Distance from Latitude & Longitude
This lesson is part of the course
In this lesson
You calculate the great-circle distance from Maple & Rye's central kitchen to its five bakery-cafés with RADIANS, SIN, COS, ASIN and SQRT.
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