distance

I need to calculate the end LAT/LON for thousands of lines of data. The existing spreadsheet has the start LAT, start LON, azimuth and distance. Is there a formula so excel can calculate it for me?

<tbody> B C D E Location Easting Northing Distance 1 WAS001 391428 6470346 8717.121 2 WAS002 400141 6470614 0.000 3 WAS003 402232 6464061 6878.524 4 WAS004 394873 6474455 6461.184 5 WAS005 393893 6464097 9028.222 Surveyor location WAS001 Closest SSM WAS003...

<tbody> A B C 1 Point Eastings Northings 2 1 567768 6376890 3 2 567702 6376035 4 3 567835 6377836 5 4 567936 6376471 6 5 568035 6376044 7 6 566834 6377837 8 7 567413 6378635 9 8 566036 6378999 10 9 568634 6377941 11 10 566345 6376534 12 13 14 First Point 15...

Hello guys. I made a function that calculates the distances between the points (of a X,Y table) and the regression line, while you need only the X and Y ranges/tables and of course their values. Here's what it looks like...

Hi Wanting your opinion on what you have saw or created in excel that you thought was a good example of a time vs distance chart. For example if you were charged with athletics in the Olympics, what would you use a basis for your ideas of the running events?

I have a huge spreadsheet of locations with lat and log. I need to calculate the distance between all locations from each other within a specific state, as well as finding the locations closest to each other. I have the basic formula for calculating distance between point A and point B. Is...

Hi Everyone, I am very new to Excel Vba and to this forum. I really need help in one of the macros that I want to write as part of my internship work. I have a list (1125) of latitude and longitude of addresses. I want to write a macro, which will give me the distance between two latitudes and...

Hi all How are you? My problem is as follows: I guess it's better to explain my problem with an illustrated problem. I have some circles with radius of 5 meters, and some points that some of them are located in the circles. I want to find that which point is located in which circle. The...

Any idea how to do this? You have LAT1, LON1, LAT2, LON2 and you want to calculate: A: distance B: bearing (initial bearing along a great circle ie the shortest distance) C: bearing along rhumb lines ("constant bearing") For example if you want to go from 0, 0 to 0, 90E, the answer to C would...

Hi So basically I was wondering if there is something I could put into a cell that would show me the number of blank cells above it before the next filled cell so for example o=empty cell x=filled cell Instead of oooxooo oxoooox ooooooo oooxoox oxooooo I would have oooxooo oxoooox ooooooo...

Hey guys and gals, here is a good one, Given 3 latitudes and longitudes, can you calculate the bearing from the first lat/long to the second lat/long. 2nd to 3rd, then 3rd to first? The ULTIMATE goal is to create an irregular polygon given multiple lat longs, and determine the area. I don't...

If the title didn't say enough, here's the deal. What I have, My current aircraft altitude 400ft the current bearing of the aircraft to target is338 degrees... 5.899212872 in radians the current depression angle 15 degrees.... .261799388 in radians the current aircraft Latitude 34º 36‘...

Ok, I'm not a programmer and my excel skills are stretched to the max at this point. Problem I am in an aircraft with a camera, on a gimbal. I know my altitude, I know my depression angle of my camera, should be simple enough to find my distance. Unfortunately I have no idea how to...

Hello I have an excel spreadsheet with 4000 different locations in the following order column 1 location id column 2 location easting column 3 location northing eg 1 450000 300000 2 500000 330000 3 4590000 345000 I need to run a macro or query to report...

Weird one for my first post on this forum but here goes!<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I have a friend who works as a travelling support worker (ie she drives to a number of different disabled people’s homes every day) come...

OK i've been going crazy trying to figure this out. I have been manually able to do this in excel using functions, but its very tedious and not that pretty (a lot of cells w/ numbers in it :mad:) so i was wondering if someone can help me with scripting the process. Heres everything i...