distance

I am trying to get in better shape. One part of my regimen is running (jogging). I usually just go out and run one of several routes in our neighborhood that I have mapped out with Google Maps so I know the distance. I take a stopwatch and time the run. When I get back, I log the date, distance...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I want to count the distance between the character "1" and "2", count start should be with "1" and to last "2" </SPAN></SPAN> Data are in columns C:P, and the count results are shown in the columns S:AF</SPAN></SPAN> Note optional request: if...

Hi, I've been trying to look for a VBA code or spreadsheet template that imports Distance and Time from the Google Maps API. Everything I've seen so far either only have Distance or use ActiveX :( :( Compounded to it is the fact that I use a Mac. I'm not sure if XML works well on Mac's Excel...

Hello, I would like to ask for your kind support in solving my not so easy problem. Given City A – City Z distance in miles (one way, by car) City Z – City A distance in miles (the other way, bytrain) Ask: For any given city pairs, find 1. If the A2Z has a counterpart Z2A 2. If there is one...

requesting for the vba program for finding all possible paths between any two nodes in a bi-directional route map. inpit is given in sheet 1 as a=from; B=to; C=distance, d= time; e= fare. output is given in sheet 2 as A1=from ....; B1= to ....; A2= possible path1; B2 = DISTANCE C2= TIME TAKEN...

Hi, I have a population of businesses whose post code I know. What I want is an Excel calculation that will show me the number of other businesses within say 40 square miles of their Post Code? I can get the post codes and convert them to longitude and lattitude coordinates but I dont know how...

So I started off thinking this was "easy"... I have two values and need to find the best match and return a result (3 columns) Input 1: Distance (Actual) Input 2: Capacity (Needed) Column 1: Distance (Max) - Need to solve for closest larger than (Can do separately) Column 2: Capacity...

Good day, I want the Macro to filter out values of distance less than 30km and do a Pivot table as well as also doing for the whole data. So that that I will have 2 pivot tables, one for the whole data and the other for less than 30km. Like this: <colgroup><col><col><col><col...

Greetings, I am looking to switch our current system of looking up mileage between 2 zip codes from Google Map's API to a DOD website (http://www.defensetravel.dod.mil/mobile/views/mileage/mileage.cfm) As you can see, it takes both zips and does a 'as the crow flies' distance and provides the...

I'm trying to find a way to calculate the distance between original zipcode in Column A and destination zipcode in Column B. I've been following other threads that appear to have solved this, however it appears to work on a Windows machine and not a mac. I am unable to change the reference to...

Have adapted an array formula from a previous thread - "Need to compare Latitude & Longitude coordinates to find closest office" The formula is in C2 and picks up Lon and Lat from A1 & A2 and locates nearest from H2:J7...

Hello! I'm trying to figure out what is the probability of a unit traveling greater than X given my data set. I am testing what is the % chance of the distance being greater on 1 try. Here is some info about the data set: Mean Travel Distance: 33.8 Median Travel Distance: 25 Standard...

Please excuse my ignorance and poor terminology for what I'm about to ask. I'm working on an Excel spreadsheet for our farm operation. I want to calculate the the distance of A & B when Ba and Cc change linear and lateral. The current pattern is 40" linear and 20" lateral from center line of...

I have a list of coordinates (columns B and C) of agencies (rows) that are associated to a zone (column A). I attached a screenshot of a reduced list as example. In cell D2 of the example I put a formula that calculates the distance between coordinates in row 2 and row 3...

Consider this two point on the map: <tbody> latitude longitude 45.61782 9.41737 45.48568 9.20181 </tbody> The distance between each other is about 22km. What's the formula to calculate that? I tried different formulas found online but every one returned absurd values...

Hello, I am sorry for my bad English. I am a student from Germany and I have the following problem: I am doing a Master which is in fact a combination of Humanities and Computer science. I did a Java course but last week we have received several exercises about VBA Excel, without having a...

Please help. I am working in Power BI. My primary data table has a variable called "Distance" which is recorded within three levels: "Session", "Athlete" and "Drill". In other words, within each Training Session, multiple Athletes participate in multiple drills, all of which have an...

Construct all pairs with the difference of or distances = 4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,20,21,22,23,24 , 25 From the beginning of 01 to 80 Example = distance of 4 04 08 08 12 12 16 (I.e. Up until 76-80 Another example distance of = 12 05 17 17 29 ...... Up to 78 to 80 Put on an...

This should be a straight-forward question, but I haven't done Excel in a while, so maybe there is a kind soul here that can point me in the right direction ;) I have a table that displays distances between Points T, A, B, C, D, E, which looks like this: <tbody> T A B C D E T 0 22 20 51 59...

Help? I have created a mileage chart for site to site distances. The sites are listed horizontally and vertically. The bottom half is the distances between sites, the top half is for the cost. It's this that I am trying to calculate. B2 = distance 1 = 100 B3 = distance 2 = 150 B4 = distance 3...