December 5, 200322 yr 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
December 5, 200322 yr Hi,You need the great circle calcs, wrestle through:http://forums.avsim.net/dcboard.php?az=sho...ing_type=searchHope it helps,Jan"Procul Negotiis" Jan "Beatus ille qui procul negotiis..."
December 5, 200322 yr Author Hi,I think you should check the webpage of this math genius. I have used it several times:http://williams.best.vwh.net/avform.htmEgbert Location: Vleuten, The Netherlands, 17.3dme SPL 108.40 | Simulator: FS2024 System: AMD 7800X3D - Gigabyte X670 - RTX 4090 - 64GB DDR5 - 2 x 2TB SSD - 32" 1440p Display - Windows 11 Pro
Create an account or sign in to comment