To find that number on your own, you need to use the belt length formula: Belt length = π/2 × (DL + DS) + 2L + (DL - DS)2/ (4L) , where: DL is the diameter of the larger pulley (here 20 inches); DS is the diameter of the smaller pulley (here 6 inches); and. 1. . On the Single sheet you can enter the two postcodes in B3 and B4 (just up to the first space), and on the Multiple sheet you can enter several postcodes on different rows in columns A and B, where, for example, you might have one. Stephen P. 00. The Bing Maps Distance Matrix API calculates distances and travel times between origins and destinations with an optional travel-time histogram. 3303341), Location (37. I would need a function that calculates a driving distance from a starting location, to another location. To calculate your pace per kilometer, measure the distance you covered and the time it took to complete the distance. Welcome to the MrExcel Message Board! Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. xlsx. Use this formula in column C and copy down. Longitude, )) With the values extracted and names defined, the last thing to do is define a calculation which we call distance that returns the value. Finally MapBusinessOnline will populate the distance information in the Data window. Australia: Calculate the route of your journey by car, train, bus or bicycle with driving directions and estimated travel time, customize the way of calculating the road route by changing the options of the trip. 22, 03. (Optional) Add additional rows of start and end addresses and copy the formulas in columns C and D to calculate the driving distances between various places. The distance represented by a degree of longitude varies with latitude. Interactive tool for distance calculation and driving directions between two cities, towns and villages of. Thirdly, in the Data Types category click on Geography. The distance shown assumes you are hitting the ball reasonably efficiently. You just have to construct URL request and scrape data off of HTML document. You can choose between different options such as driving, cycling or walking. In this article Trackman state that by adding an extra 10 yards onto all shots an average mid-handicapper hits, “the percentage of shots that would hit the green increases from 38. com. The Bing Maps Distance Matrix API service calculates travel time and distances in various scenarios with an optional travel-time histogram. Subtract the x-coordinates of one point from the other, same for the y components. In addition to this article, I. The Bing Maps Distance Matrix API service calculates travel time and distances in various scenarios with an optional travel-time histogram. " MsgTxt = MsgTxt & vbCr & "Despite having delays coded to wait for the website to calculate, this macro sometimes returns 0 or the same distance for multiple postcode pairs. geocoders import Nominatim import osmnx as ox import networkx as nx lat1, lon1 = -37. 10-15 seconds to calculate the distance between each pair of postcodes. The Excel Distance Calculator (Windows application) works anywhere in the world. Once again, we would stop and refer you to a tool like the Swing Caddie SC200 Plus+. Chateauguay (Quebec) Quinte West (Ontario) 329. Ex: Add reference to MS HTML object and MS Internet Controls in your project. » Food Centres. 4. Estimate off-peak driving times: Reads an Excel file with two columns of postcodes and returns a third column with estimated off-peak driving times in hours. This distance and driving directions will also be displayed on an interactive map labeled as Distance Map and Driving Directions Texas (US). Then, press on Module. Calculating driving distances between addresses or zip codes in excel is a breeze with this easy and convenient excel distance calculator solution. You will need to know the latitude and longitude coordinates for each of the points you want to measure the distance between. The Excel Driving Distance Calculator is an excel based distance calculator that allows the user to generate Driving distances of a large list of addresses, zip codes, cities or geocodes. Distance. Read More: Excel VBA: Calculate Distance Between Two Addresses or Coordinates. Step 1: Create API Key from Map. Unfortunately, such a distance is merely academic. Set the departure and arrival points and the most convenient routes for freight will be displayed. Adding the distance between two zip codes to a data file. Check the distance between any city, town, airport, national park, venue, landmark or address. Calculate Distances in Google Sheets. This distance and driving directions will also be displayed on an interactive map labeled as Distance Map and Driving Directions India. 8. Platform. 65 yards. Export that data to XLSX or CSV format. Oct 22, 2011. The distance between cities of US is calculated in. Radius mapping software is a tool that allows users to create and visualize maps of geographical areas based on a specified radius or distance from a central point. Upload your spreadsheet here. Compute a route and review the response. I believe PC Miler has an excel add in that you can use two zips to get distance between them. Our Matrix Excel Distance Calculator allows you to calculate the driving distances between the intersections of 2 lists of addresses or zip codes. You can find this information using a variety of online tools, such as Google Maps or GPS devices. Step 1: Open Google Maps on your computer. Higher handicap players often hit 7, 8 and 9 irons for maximum distance while better players hit them for accuracy and stopping ability. Driving distances between two cities. Expect 10-15 seconds to calculate the distance between each pair of postcodes. Here, I need the driving distance, and not the lineal distance. MapBusinessOnline will start calculating distances. Directions (in miles or kilometers) These are step by step driving directions over the entire route, including the travelled distance for each step. 0 - Calculate Distances in intersections between Addresses or Zip Codes in Excel (Matrix Format) from $67. 1719077))= 521. from $97. You will be able to modify the route by dragging the route line on the map. It is extremely versatile and allows the user all the functionality of Excel with the power of. How to use the Routes API. By Using the Google Maps API, it allows for flexible addresses, zip codes and even cities giving real time driving distance and driving time directly into Excel I am looking at writing a query that finds distances between two addresses. Windows. 4. In the last column, type the formula using the GetDistanceH function, and then copy it to the remaining cells in the table. Driving directions. . #1 Hello, I want to implement a macro solution in excel to calculate the driving distance (km) and time between two gps locations using Bing Map API (I have. Given two points with these Latitude and Longitude coordinates: Point 1: Latitude: 37° 57' 3. I find this table extremely useful when you don’t have access to a rangefinder or a Golf Club Distance Calculator. To calculate the distance between these two points on a plane, we simply apply the formula: √[(p₂ - p₁)² + (q₂ - q₁)²] In this case: √[(2 - 1²) + (3 - 2²] = √2 = 1. The tool will help you to calculate distances between to locations in Sri Lanka along with Driving Directions between the two places. Next, go to cell C6 and type in the following formula: =C5. 7203" S. In this formula, each of. Steps to calculate: A = Calculate total hours required for the travel. Distance Between Cities. Calculate your own mileage chart between any places. . Depending on the vehicle you choose, you can calculate the. i have several cities with post code (around 35 k Entries) and i need calculate distance from my office to each. R. Oct 20, 2022. 'Calculate Google Maps distance between two addresses Public Function GetDistance (start As String, dest As String) Dim firstVal As String, secondVal As String,. This guide walks you through how to calculate the distance between two points in a spreadsheet using the haversine distance formula, which is also called straight-line or. I have downloaded the planet. Captures all customers near outlet. 1. Use this formula in column C and copy down. DOMDocument so as to be able to add the namespace. Because of the variable road conditions, travel times can often take longer than you expect. Realtime driving directions based on live traffic updates from Waze - Get the best route to your destination from fellow drivers. For more information around pitching wedge, gap wedge and sand wedge loft check out this article. Since, it will be a cumbersome task, is their a way I can input the origins and destinations from excel and get output as distance between the cities?Maptive’s map route planner allows you to: Find the most efficient route between as many as 25 locations with up to 73 stops. You will also see that based on ability and size, iron distances vary, in some cases significatly. Printout window. Clear searchIn this video, I will show you how to calculate distances between zip codes in terms of miles and kilometers in ExcelDOWNLOAD LINKIf your coordinates are decimal numbers, see formulas in the Decimal Longitude Latitude section. I am in U. Columns A and B show the zip codes and their straight-line distances from the target, as calculated by CDXRadius, and colums C is the calculated driving distance from. Please note that while Stops are not required, a precedence in stops is required. Calculate distance and duration between two places. Digg; del. The free template file is everything you need to become the master of distance. Enter “Seattle” in the “Add a Place” box in the left-hand navigation. With your coordinates in radians, you can use a trigonometric formula to calculate distance along the surface of a sphere. Based on general research it seems this is something that is indeed possible but I cannot seem to find a VBA code that works. I am going to have a long list ( 1000+ ) of addresses that I need to get driving distances for. permanent link. . The template us. ). Click Directions > Generate step-by-step. I'm creating a calculator to calculate Time based on known distance and speed values. Those are the only zip codes I need to worry about. Click Here to Download STEPS: Firstly, select the cell where we put the name of the cities. Use this page to calculate driving, cycling or walking distances between many start locations and many end locations. ZIP Code to Lat/Long. I checked how can I find real driving distance. Get Distance & Directions. 1 Answer. 8, which is the Radius of the in. Please enter the Start and End Location in the fields above the map and click Get Route button. Excel to calculate distance in miles between post codes. I use ArcView GIS and have a full version - But it is about $6000 for the program plus map data. It allows the user to save tremendous amount of time by automating the generation of the driving distances for a large list of addresses, even tens of. 👉 Sign up for 13 hours of FREE E. The Excel Driving Distance Calculator is an excel based distance calculator that allows the user to generate Driving distances of a large list of addresses, zip codes, cities or geocodes. (Source: Excel Easy) The formula for calculating distance in Excel is =SQRT ( (X2-X1)^2+ (Y2-Y1)^2), where X and Y are the coordinates of two points (Source: AbleBits) Excel allows for. Combine this information with the fuel cost tool to find out how much it. Or figure out the driving time to see if you need to stop overnight at a hotel or if you can drive straight through. In the Measure. Then, to find the latitude, select the cell where you put the latitude and type the formula there. To use the distance measurement for driving, simply enter the addresses into the search bar and press enter. Just enter your CDXGeoData API key and then cut and paste your data into a template. . I am trying to use excel to calculate the distance between two points with x,y and z coordinates using the formula distance=SQRT((X1-X2)^2+(Y1-Y2)^2+(Z1-Z2)^2)). How our calculator determines the fuel quantity required. Australia: Calculate the route of your journey by car, train, bus or bicycle with driving directions and estimated travel time, customize the way of calculating the road route by changing the options of the trip. The output can be a: Time matrix; Distance matrix; Time table; Distance tableGood morning! I have a worksheet containing 3122 Zip codes. the loft of the club. For more information, see Get a route and Review the route responses . An example report for zip code 07869 to 08033 is shown on the right side of this screen. Build your delivery routes: To get directions between the points on the map, click on a stop and then click on the arrow icon that appears on the bottom-right of the white window. Calculate exact distance between New South Wales cities and download the mileage chart of 15 major New South Wales cities as Excel with driving and flight distances, travel time. 2) Convert the employee's work address to Lat-Long values using the. Finish zip code in column B. Hi guys, on June 2016, google made some changesaround pricing and authentication etc. Learn how to calculate multiple straight or drive distances and drive times from a location to a. This tool was developed using a mapping API and. sinB] where, r represents the radius of Earth which is approximately 6400 kilometers or 3959 miles, A and B show the latitude of the place, And lastly, the longitudes are presented by X and Y. To download go to help with the tool please call or email VinniePhone: 80. Check out both as the crow flies and driving distance and time when possible, as well as best driving route and suggested pit stops. Print GetDistance ("new york,ny", "miami,fl", "key"). 414. If so, to meet your requirement, please refer to UK Postcode Distance Calculator to check whether it can be done. Worst case scenario, you will need to set up a “web service” (fancy name for a PHP page that takes your arguments (postcodes) and returns a JSON array). I need to calculate the distance between two points in a map in the same way as Google Maps' distance matrix and get direction APIs. The Microsoft Access Distance Calculator is a tool built in Access to allow the user to calculate Driving Distances and Driving time directly in Microsoft Access. provide. Ex: Add reference to MS HTML object and MS Internet Controls in your project. I am writing VBA in Excel to calculate the distance between an employee's home address and work address using Bing Maps API calls. It saves the user a tremendous amount of time by automating the generation of the. Point 2: Latitude: 37° 39' 10. ACOS (SIN (LAT1)*SIN (LAT2) + COS (LAT1)*COS (LAT2)*COS (LON2 –. Search for jobs related to Google driving distance calculator excel or hire on the world's largest freelancing marketplace with 22m+ jobs. Simply upload a list of your start and destination postal codes in 2 columns in an Excel . cdxtech. Track trips from your pocket. While this journey planner tool gives distances in New Zealand, all times are approximate and do not allow time for stops, windy roads, heavy traffic or the impact of weather conditions. 5244" E. Our Matrix Excel Distance Calculator allows you to calculate the driving distances between a large list of Full/partial addresses or Zip Codes DIRECTLY INTO YOUR EXCEL SPREADSHEET in a matrix format! It uses the Ease of Excel with the Power of the Google Maps to bring full distance Calculator Functionality to your spreadsheet . 00001 represents a distance of about one (1) meter in the north-south direction. 96441. 6. But it also provides you with the journey time by car, public transport, bicycle or for a walking tour. See moreIn this article, we will create an Excel function to calculate the distance between two addresses using the Google Maps directions. 5% to 44. . Distance Between Addresses. Next, click on the “Driving” option and select “Get Directions. Calculate a simple driving based Distance Matrix for specific time (asynchronous) The following example shows how to request a simple driving based distance matrix for the set of origins and destinations for a specified time, June 15 th, 2017 at 1PM PST. The report contains the straight line distance, driving distance, distance type, map and the latitude, and longitude for the locations specified. S. This spreadsheet allows you to lookup the distance between 2 US ZIP codes. My next step is to create a formula to return the sequence of addresses in the order I should goto based on shortest distance between each point (also referred to as the traveling salesman problem). With your coordinates in radians, you can use a trigonometric formula to calculate distance along the surface of a sphere. However keep in mind that the calculation is at the rate of about 3-5 calculations per second. This mileage calculator estimates the number of driving miles between two locations in the United States. com. 8529425485297. US Driving Distance Calculator, calculates the Distance and Driving Directions between two addresses, places, cities, villages, towns or airports in US. It’s fast and reliable, but it won’t import the coordinates into your Excel file. The format of the function will be as follows: =TRAVELTIME(origin, destination, api_key), =TRAVELDISTANCE(origin, destination, apikey). In cell D2, enter the formula =METERSTOMILES (C2) and press Enter. Distance. By Google Maps Matrix API, you can also calculate travel time or. 5. Search. 6. By Johin in forum Excel Programming / VBA / Macros Replies: 1 Last Post: 10-18-2013, 03:58 PM. 5. Calculate driving distances with a click of a button. With Driversnote as your automatic mileage tracker, you can record trips without even opening the app. It uses the same basic principles as the other calculators and you also need to have an idea of your swing speed. If you are good at. I had some code years ago which allowed me to enter a formula eg =getdistance (A1,B1) in a cell and it would calculate the distance between two addresses. 00. Thread starter BarnBrian; Start date Feb 1, 2019; Tags calculate distance driving services simple B. Thread starter Alpacino; Start date Oct 22, 2011; A. =LAMBDA (city1, city2, LET (. I am in U. Enter your driver clubhead speed (or the clubhead speed you’d like) and click calculate to see the sort of carry distances you would be achieving with this golf distance calculator. This road distance calculator allows you to plan the trip in advance, but also to quickly find another convenient route, in case there are traffic restrictions in the countries you transit. DISTANCE CALCULATORDownload the tool from the link below:tool will allow you to calculate the. Better players tend to strike irons at the correct impact angle more often than higher handicap players. CDX Technologies - Blog - This video covers using CDXZipStream software to analyze driving routes in Microsoft Excel. The tool will help you to calculate distances between to locations in Zambia along with Driving Directions between the two places. FlightScope's Trajectory Optimizer is a golf ball flight trajectory program. 2. You can measure the driving distance between two cities based on actual turn-by-turn directions. Golf Club Distance Chart for 60 MPH Swing Speeds. To start the search for the best road route: indicate the place of departure and the place of arrival of the. Waze On: our first-ever, virtual global event. This help content & information General Help Center experience. Excel Driving Distance Calculator (With Driving Time) from $67. Georgina (Ontario) Rimouski (Quebec) 949. IFTA calculator at is a free and easy online calculator, you need to provide only information about your stops and your fuel purchases. The size of the file increases with the radius. You can get the distance between cities, airports, states, countries, or zip codes to figure out the best route to travel to your destination. Kenya Driving Distance Calculator, calculates the Distance and Driving Directions between two addresses, places, cities, villages, towns or airports in Kenya. Calculate Distance Between Zip Codes This file can be used to calculate the distance between two zip codes For example in the sample sheet below to calculate the first percentage the correct formula would be, =A2/B6 and the formula would be typed in cell B2 . Create a drive time radius map: explore how far you can travel on a. A: We use the Excel Distance Calculator and the Google Maps API to calculate distances and travel times between multiple addresses or postal codes! The built-in VBA code of our Excel Distance Calculator processes the input of the location data and sends this data on to Google Maps. If you have the latitude and longitude for each zip code, you can use trigonometry to calculate the distance as the crow flies. . Based on scientific algorithms, FlightScope's Trajectory Optimizer will help you find your optimal ball flight trajectory to add distance to your golf shots. 1-800-462-2176. We have a great community of people providing Excel help here, but the hosting. I have to find distance between each pair of these origins and destinations. I want intergrate postcode finder in excel . Zip Code distance in excel. Read more Sign up. Here WeGo – Best Alternative to Google Maps. To find the distance between points, put them in a spreadsheet. Plot your stops onto the map: Click “finish” and all the addresses in your spreadsheet will be plotted on the map, like so: 7. For this we will make use of dot notation and LET. Here the location data is processed by the Directions API of. 62137119) Start zip code in column A. The Excel Driving Distance Calculator is an easy-to-use Excel tool that allows the user to calculate Driving Distance and Driving time directly in Excel. It saves the user a tremendous amount of time by automating the generation of the. 00. Travelmath helps you find the driving time based on actual directions for your road trip. Choose Visual Basic from the ribbon. [Distance / Speed] = Ride Time. Option Explicit Sub main () Dim cell As Range, f As Range Dim rowOffset As Long With Worksheets. The motion detector lets you auto-track trips - all you have to do is drive. How Does it do it?. FDOT provides the official highway mileage between cities in Florida. Find out the distance between any two cities in the world!. As of now, in 2023, Google Sheets does not include a built-in function for calculating the distance between addresses or coordinates. The DISTANCE function is a mathematical function in Excel that calculates the distance between two points in a Cartesian coordinate system. Now when you see the map, the distance is listed along with the other data with each marker. Travelmath provides flight information to help you plan a trip. The distance between cities of Texas (US) is calculated in kilometers (kms), miles and nautical miles. STEPS: Firstly, select the cell where we put the name of the cities. How to calculate distance between two Addresses or Zip codes in excel? Link below:Re: Get google maaps total distance without API. . I work for a moving company and this is was a task assigned to me. I succesfully created an API key and I used a tutorial page that showed two functions in VBA, one for Time and one for Distance: 'Returns the number of seconds it would take to get from one place to another Function. [ (Number of Breaks * Break Duration) + Maintenance Time] C = A + B. A degree of latitude is approximately 60 nautical miles, 111 kilometers or 69 statute miles. Click Validate and Set Options, then choose Advanced Options. Excel Geocoder 2. This sample calculates the distance in miles between two random pushpins on the map. Works for both miles per gallon (MPG) or kilometers per liter (km/L). To find the distance between points, put them in a spreadsheet. Code: Function G_DISTANCE (Origin As String, Destination As String) As Double Dim myRequest As XMLHTTP60 Dim myDomDoc As. You can also book a hotel near the airport. If your zip code is in A1, select it and this macro will ask you for a starting zip code, you type it in and hit enter, and then the distance/time is dropped in to the cell right next to it, which in this case would be B1. 📦 Setup. . The distance in miles and kilometers will display for the straight line or flight mileage along with the distance it would take to get there in a car. It also depends if you want point to point distances or if you want routed distances. JavaScript. Choose cell C13 and type the following formula. May 28, 2021. Currently I'm trying to. The below template is ideal for business owners, self-employed persons, independent contractors, and employees of companies who receive mileage reimbursement as part of their actions driving. We will import the libraries and set two sample location coordinates in Melbourne, Australia: import numpy as np import pandas as pd from math import radians, cos, sin, asin, acos, sqrt, pi from geopy import distance from geopy. A custom Excel formula named CDXRouteBing is described which wo. There are many such formulas that could be used; the following formula will suffice for our purposes: =ACOS (SIN (Lat1)*SIN (Lat2)+COS (Lat1)*COS (Lat2)*COS (Lon2-Lon1))*180/PI ()*60. For example, in my sheet 1 I have "Paris" in cell A1 and "Lyon" in cell B1, and I want to show the distance between two cities in cell C1. Now you have all the distances. Bulk distance calculation to calculate multiple distances from XLSX, CSV, Google Spreadsheet. This solution is often not what people have in mind when they ask for the distance. On the other hand, the excel geocoding tool is copy-paste simple and gets you an interactive map. Calculating the average speed from distance and time, the following formula can help you. Australia Driving Distance Calculator, calculates the Distance and Driving Directions between two addresses, places, cities, villages, towns or airports in Australia. Map will show up here under JavaScript/Typescript mode. Real-world scenarios may include locating where a new commercial bakery should open their next location to reach their customers with ease, or where a school district. Print driving directions between any points on earth. The Excel Driving Distance Calculator is an excel based distance calculator that allows the user to generate Driving distances of a large list of addresses, zip codes, cities or geocodes. You can specify several options, including mode of transportation, such as driving, biking, transit or walking, as well as transit modes, such as bus, subway, train, tram, or rail. Start with Set up your Google Cloud project and complete the setup instructions that follow. This help content & information General Help Center experience. Using Excel 2010, I'm trying to use the above code w/no luck. Place your zipcodes or addresses in the Excel sheet, press the button and Google Maps takes care of the rest. The driving time would be a “nice to have” but the biggest thing is determining the mileage. com. ZIP Code radius maps are an excellent way to explore and show market and trade areas. Click Link to Download Tooltool will allow the user to. Follow the steps and get your result in minutes via email. Club Distance Calculator (Yards) This is a calculator to provide guidance on how far you will hit different clubs. Output the resultk. I am working on a mileage expenses form for two distance from one location to another . Above is a table of average golf club distances for men and women. The beginning zip code is in column A and the destination zip code is in column B. The file works out the distance in miles between 2 UK postcodes. I have about 20 K pairs to calculate driving distance between them. Stephan Georg · Glogauer Straße 5 · 10999 Berlin · Germany. Sign up for an API key here. To calculate distance between addresses, simply use the gps converter to. I am very new to using Macros for Excel and I was wondering if there was a way to calculate the distance between two zip codes. Then draw a route by clicking on the starting point, followed by all the subsequent points you want to measure. More info at arccosine is an angle. For example, the distance between 111 Smith St and 222 Smith St is 10 miles. Please enter the Start and End Location in the fields above the. A dotted line will appear between the two points, and the distance. Update (Jan 2023) - The 2020-01 version of the file was broken due to slight changes in the Google API. After you enter your addresses or postcodes into Excel the tool connects. Results are in statute miles nautical miles kilometers. This option only applies to the driving travel mode. . Therefore, the code compares the answer returned and rescalculates of 0 or if the answer. With the Distance Matrix API, you can provide travel distance and time for a matrix of origins and destinations. A. The route will be displayed on the map, along with the total distance. Longitude: 144° 25' 29. This is where you’ll enter your average fuel mileage. To compute the length of a 2D line given the coordinates of two points on the line, you can use the distance formula, adapted for Excel's formula syntax. The Distance Matrix API is a routing component feature of our Bing Maps V8 Web Control. This example requests the distance matrix data between Washington, DC and New York City, NY, in JSON format: Try it! Test this request by entering the URL into your web browser - be sure to replace YOUR_API_KEY with your actual API key . I am working on a mileage expenses form for two distance from one location to another . One address per line (26 max) Bing Maps Distance Matrix API. The distance shown assumes you are hitting the ball reasonably efficiently. If you need to calculate distance for many zip codes please check out our Zip Code Distance Batch Report. Use the individual distance calculator to determine the distance between two addresses. The tool can also be used on area layers, for example, as a ZIP Code Distance Calculator on ZIP Code areas. 72. Excel Google Maps Distance and Travel Time Calculator with Directions API. e. Browse Excel Distance Calculator How To Calculate Driving Distance Directly Into Excel buy goods, services, and more in your community area. In cell A9, enter the label “Average price/gallon”. The Solution: An analysis template developed using Excel, VBA, and the Google Maps API (application programming interface) with Geo-referenced distance and time calculation abilities. Longitude, lat_2, city2. The IFTA Excel Driving Distance Calculator - Calculate Miles Driven by State - is an Excel based Distance Calculator that allows the user to generate AND summarize driving miles for a single trip or a list of trips usually used in IFTA or other State Reporting. Environmental Protection Agency. Using Google Distance Matrix API, you can calculate the distance between two places. This is an overview of calculating the travel time when the travel mode is driving. I know this question has been posted previously but I could not get those. (The diagonal should equal zero)Download Tool Below:Everybody this is Vinnie with ExcelDistanceCalculator. The matrix itself is often used as a baseline to solve a single user scenario,. I need to calculate the distances between my company head office and a range of customer addresses. Check the option to calculate distance from the first address. Let's say you have a distribution center and you want to know approximately how far away each of your retail stores are. Calculate your own mileage chart between any places. I would use the data from that ZIP list to get the Lat/Lon using a lookup then a function like the following (or you could do it in a formula too) Public Function GetDistance (ByVal Lat1 As Double, Lon1 As Double, Lat2 As Double, Lon2 As Double) Const emR = 6371000 ' Earth's mean radius in meters Dim dLat As Double Dim. So a 200,000 calculations data set would not be practical as it would take quite a long time. VBA Excel Bing Maps API Distance Calculator. Travelmath provides an online cost calculator to help you determine the cost of driving between cities.