Jump to content

Sign in to follow this  
Egbert Drenth

Question for a math genius...

Recommended Posts

Guest BobL

and yes, it's FS related.I'm trying to set a spreadsheet up so that it will calculate straight-line distances between two points. And since I never did do well in math I need a little help.Assume two points, x,y and a,b where:X=decimal based longitude of the first pointY=decimal based latitude of teh second pointa=decimal based longitude of the second pointb=decimal based latitude of the second point.Now, what formula do I use in the spreadsheet cell to make it calculate a straight line distance, in nautical miles that takes into effect the fact that the earth isn't as big around at higher latitudes than it is at the equator.How do I do this???BobL

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Tom Allensworth,
    Founder of AVSIM Online


  • Flight Simulation's Premier Resource!

    AVSIM is a free service to the flight simulation community. AVSIM is staffed completely by volunteers and all funds donated to AVSIM go directly back to supporting the community. Your donation here helps to pay our bandwidth costs, emergency funding, and other general costs that crop up from time to time. Thank you for your support!

    Click here for more information and to see all donations year to date.
  • Donation Goals

    AVSIM's 2020 Fundraising Goal

    Donate to our annual general fundraising goal. This donation keeps our doors open and providing you service 24 x 7 x 365. Your donation here helps to pay our bandwidth costs, emergency funding, and other general costs that crop up from time to time. We reset this goal every new year for the following year's goal.


    31%
    $7,835.00 of $25,000.00 Donate Now
×
×
  • Create New...