Request for excel formula

[jitendracellplan]

hi everyone
i have need formula in excel.

Given value

1.one Point lat /long
2. distance
3.Angle form given lat/long


then find the
Another point Lat/Long:):)

[haryarin]

hi everyone
i have need formula in excel.

Given value

1.one Point lat /long
2. distance
3.Angle form given lat/long


then find the
Another point Lat/Long:):)

Follow this Url :

Calculate distance and bearing between two Latitude/Longitude points using Haversine formula in JavaScript (http://www.movable-type.co.uk/scripts/latlong.html)

[thodoris85]

Hope this helps as well:

Calculate second point knowing the starting point and distance (http://stackoverflow.com/questions/2187657/calculate-second-point-knowing-the-starting-point-and-distance)

[jitendracellplan]

its not true.
pls help me


Hope this helps as well:

Calculate second point knowing the starting point and distance (http://stackoverflow.com/questions/2187657/calculate-second-point-knowing-the-starting-point-and-distance)

[krisqtl]

please try this http://www.4shared.com/document/vgFGJlXP/Earthdistance.html
i hope this useful

[mail2paturi]

Hi,

Please find the excel tool for calculating the distance between 2 lat/Longs

[jitendracellplan]

hi sir,
Please check your excel formula.this is not useable

my question
i have need formula in excel.

Given value

1.one Point lat /long
2. distance
3.Angle form given lat/long


then find the
Another point Lat/Long
:):)

[arun909]

Hi,

Please try this one.

http://www.scribd.com/doc/75591047/Finding-lat-long-of-end-B-using-end-A-lat-long-and-Azimuth

Thanks

Clicking Thanks/Reputation is highly appreciated..


hi everyone
i have need formula in excel.

Given value

1.one Point lat /long
2. distance
3.Angle form given lat/long


then find the
Another point Lat/Long:):)

[jitendracellplan]

Many many Thanks

[val2032]

Mentor Software Forward Inverse (http://freegeographytools.com/2008/calculate-new-coordinate-position-from-current-position-bearing-and-distance) here (http://www.mediafire.com/?cyzmzzzxnvm)

[raja_liaqat]

Hi everyone
i have need formula in excel that Batch convert the coordinates DD MM SS into DD.DDDD

[mimoX]

the dd mm ss in single cell or separate cell?

[mimoX]

let say if dd mm ss in cell A1 A2 and A3 respectively, just put in this formula in A4. =((A1)+(A2/60)+A3(3600)). If within the same cell, than if the format is always 2 integers (i mean the format is consistent, DD MM SS and not DD MM SS.SSS or D M SS.S) then break them into separate cell first. let A1 be DD MM SS then we break them into 3 separate cell namely A2 A3 A4. A2, A3 and A4 shall have the following formula. A2> =LEFT(A1,2). A3> =MID(A1,4,2). A4> =RIGHT(A1,2)

[tomsg]

I am sharing my add-in excel function to convert coordinate from DMS to DD format.

simple type this function in your excel: =DMS2DD(C,[d],[m],[s]), where:
C: your source coordinate data, ex: 5° 54' 7.47"
d, degree separation, ex: °, this is optional. if it is omit ° will be used.
m, minute separation, ex: ', this is optional. if it is omit ' will be used.
s, second separation, ex: ", this is optional. if it is omit " will be used.

run this xla file to add function into your excel to make it available then you can use. you can add this add-in into your excel then you dont need to run every time you use.

Hope this help.

[raja_liaqat]

let say if dd mm ss in cell A1 A2 and A3 respectively, just put in this formula in A4. =((A1)+(A2/60)+A3(3600)). If within the same cell, than if the format is always 2 integers (i mean the format is consistent, DD MM SS and not DD MM SS.SSS or D M SS.S) then break them into separate cell first. let A1 be DD MM SS then we break them into 3 separate cell namely A2 A3 A4. A2, A3 and A4 shall have the following formula. A2> =LEFT(A1,2). A3> =MID(A1,4,2). A4> =RIGHT(A1,2)


Dear Thanks for this Post but Your Formula got some error =((A1)+(A2/60)+A3(3600)). may be its clarical mistake correct formula is =((A1)+(A2/60)+(A3/3600)).

[mimoX]

Dear Thanks for this Post but Your Formula got some error =((A1)+(A2/60)+A3(3600)). may be its clarical mistake correct formula is =((A1)+(A2/60)+(A3/3600)).

you are right. typo error. thanks for correcting it.

[raja_liaqat]

I am sharing my add-in excel function to convert coordinate from DMS to DD format.

simple type this function in your excel: =DMS2DD(C,[d],[m],[s]), where:
C: your source coordinate data, ex: 5° 54' 7.47"
d, degree separation, ex: °, this is optional. if it is omit ° will be used.
m, minute separation, ex: ', this is optional. if it is omit ' will be used.
s, second separation, ex: ", this is optional. if it is omit " will be used.

run this xla file to add function into your excel to make it available then you can use. you can add this add-in into your excel then you dont need to run every time you use.

Hope this help.


This Micro cannot work where i can find add-in

[tomsg]

This Micro cannot work where i can find add-in

Word 2003, tools>Add-Ins>Browse to select DMS2DD converter.xla file>OK. you will see new add-ins.

[raja_liaqat]

Word 2003, tools>Add-Ins>Browse to select DMS2DD converter.xla file>OK. you will see new add-ins.

Can you provide me the said micro for word2007

[raja_liaqat]

Hi,

Please try this one.

http://www.scribd.com/doc/75591047/Finding-lat-long-of-end-B-using-end-A-lat-long-and-Azimuth

Thanks

Clicking Thanks/Reputation is highly appreciated..

Hi dear i want formula in excel for batch converting of

Given value

1.one Point lat /long
2.2nd Point lat /long
3.distance b/w 2 points
4.Angle/True Azimuth forward/reverse form given lat/long

[wnsworld]

Hi All,

I have post Geo library Excel Add-In time ago,,

pls check http://www.finetopix.com/showthread.php?7128-Geo-library-%28Helpfull-in-RF-Tx-Survey-Planing%29

and let me know if not working..

BR//
WNS..