distances

Hi, I am storing all of m running times on an excel sheet. I have the distance run in column A (lets say A1:100) and the time in column B (B1:100). In a separate table columns E and F have ranges of distances (0 - 10[in E1 and F1 resp.], 11 to 20 in row 2, 1 to 30 I row 3, etc). What I want is...

Can you use vba to measure distances in excel, such as between any given row at the bottom of the current page?

Hi, I am looking for a way to find the closest destination based on a post code entered by an user. As below, when an user inputs "Post code A", I would like the macro to use maps:) and bring back the closest location to post code A which for e.g may be Post code Y Post code entered : Post...

calculate the delta values in the vertical and horizontal line of the draws, delta is the memso that distances, in the vertical is always from the last to the next, horizontally, we have 6 values because the base is the 1st number, already in the vertical we have 7 delta values or distances...

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...

I need to visualize train paths on a single track railway to suggest optimization of train schedule slots and increased service patterns. The distances the train are traveling are obviously well known and should ideally be displayed on the Y-axis with the fixed points being the (accumulated)...

I need to calculate the distances between my company head office and a range of customer addresses. Is there a way of doing this in excel perhaps using google maps?. I am in the UK so the distance needs to be calculated between postcodes.

Hi there, when using the Concatenate() command, was wondering how you go about making the distances only show 3 decimal places. EG at current I have CONCATENATE(BEARING,BEARING SYMBOL,MIN,,,SECS,"~10.000000112) Any help would be greatly appreciated, Warmest Regards, Rob

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...

Hello everybody Consider I have something like attached. What I need to do is; compare distances between A1-B1, A1-B2, A1-B3... etc. and match A1 with the closest one (in this case it is B1) I have X-Y coordinates for all items here. I attached a screenshot of a sample excel file to make it...