+ Reply to Thread
Results 1 to 8 of 8

How to find the coordinates at a given distance and bearing

  1. #1
    Registered User
    Join Date
    07-10-2012
    Location
    Jakarta, Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to find the coordinates at a given distance and bearing

    Need an Excel formula to get new coordinate at a given distance and bearing/heading.
    example:
    Lat/Lon : -6.24525785446167, 106.627548217773
    Distance : 300m
    Bearing : 90 degree
    New Lat/Lon : ?

    I've found the coordinate calculator and apps toll, but I've a lot of data to work with.

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Rocester, New York, USA
    MS-Off Ver
    Excel 2007:10
    Posts
    2,019

    Re: How to find the coordinates at a given distance and bearing

    Please Login or Register  to view this content.
    From Movable Type Scripts: Calculate distance, bearing and more between Latitude/Longitude points.

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    Montreal, QC
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: How to find the coordinates at a given distance and bearing

    ben_hensel, could you please indicate what values you refer to by your variables?

    Correct me if I'm wrong, given OmJose's example, three of the four variables would be:
    lat1=-6.24525785446167
    lon1=106.627548217773
    d=300

    What does variable R refer to?

    Quote Originally Posted by ben_hensel View Post
    Please Login or Register  to view this content.
    EDIT: figured it out
    lat1=-6.24525785446167
    lon1=106.627548217773
    d=300 meters
    R= radial distance of the Earth, 6371.1 meters

    Also, all values in degrees (lat1, lon1, bearing, lat2) are to be converted to radians for input, and then the output is converted back to degrees

    Thanks for the help.
    Last edited by andrew.e.mcintyre; 04-03-2013 at 11:04 AM.

  4. #4
    Registered User
    Join Date
    07-29-2013
    Location
    Denver
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How to find the coordinates at a given distance and bearing

    Do you have to include the negative value for south or west in the calculations?

  5. #5
    Registered User
    Join Date
    04-02-2013
    Location
    Montreal, QC
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: How to find the coordinates at a given distance and bearing

    I believe you do, though I don't know if it can account for values crossing across positive/negative (East/West or North/South) thresholds.

  6. #6
    Registered User
    Join Date
    07-29-2013
    Location
    Denver
    MS-Off Ver
    Excel 2013
    Posts
    2

    Re: How to find the coordinates at a given distance and bearing

    OK. It also looks like the distance needs to be in km not meters.

  7. #7
    Registered User
    Join Date
    04-02-2013
    Location
    Montreal, QC
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: How to find the coordinates at a given distance and bearing

    Correct, as long as long as R is also in KM.
    I ended up using meters instead of kilometers so my R was set to 6371100.

  8. #8
    Registered User
    Join Date
    04-02-2013
    Location
    Montreal, QC
    MS-Off Ver
    Excel 2008
    Posts
    4

    Re: How to find the coordinates at a given distance and bearing

    ben_hensel, could you please indicate what values you refer to by your variables?

    Correct me if I'm wrong, given OmJose's example, three of the four variables would be:
    lat1=-6.24525785446167
    lon1=106.627548217773
    d=300

    What does variable R refer to?

    Quote Originally Posted by ben_hensel View Post
    [Select Code] copy to clipboard

    lat2: =ASIN(SIN(lat1)*COS(d/R) + COS(lat1)*SIN(d/R)*COS(brng))
    lon2: =lon1 + ATAN2(COS(d/R)-SIN(lat1)*SIN(lat2), SIN(brng)*SIN(d/R)*COS(lat1))

    EDIT: figured it out
    lat1=-6.24525785446167
    lon1=106.627548217773
    d=300 meters
    R= radial distance of the Earth, 6371.1 kilometers

    Also, all values in degrees (lat1, lon1, bearing, lat2) are to be converted to radians for input, and then the output is converted back to degrees

    Thanks for the help.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.06496 seconds
  • Memory Usage 9,002KB
  • Queries Executed 14 (?)
More Information
Template Usage (33):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (2)bbcode_code
  • (1)bbcode_quote
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (8)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (8)postbit_legacy
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (4)showthread_bookmarksite
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./includes/functions_notice.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php 

Hooks Called (46):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1