Sim2 Distance Calculator Excel sheet

Hi everyone,

I've made a spreadsheet that allows for distance calculations on sim2, using Excel



Basically you can pick an airport at the top, and then you can pick an aircraft, and the spreadsheet calculates all the cities in range of that airport for that aircraft. You can also specify a minimum distance the nearest airport can be away as well.

I'm sure that there are a few problems with it, but I'm fairly sure it works in the main. Let me know what you think!

http://whiox.mazca.c...eempiresv2b.xls

At some point I'll add some data for the non 1946 aircraft as well. Thanks to FlyWorld Air for his airport database, as I have used it for the basis for the data in this spreadsheet!

Top Class Willip

Good to see another player add content to keep AE going and interesting

10/10

Nicely done excel sheet! I tried something similar with excel but got horrible rounding errors.

thanks, the formula for working out the distances took a while to figure out!

I've now updated the spreadsheet to include all aircraft in sim2. I've left the 1946 aircraft in for reference at the bottom of the drop down list.

http://whiox.mazca.c...eempiresv2b.xls

new version contains round trip calculator that lets you see if a certain aircraft can fly a certain route round trip and how many times. Still experimenting with it though so it may not be 100% accurate.

Nicely done excel sheet! I tried something similar with excel but got horrible rounding errors.

1+1=3 eh, Timsher?

1+1=3 eh, Timsher?

yeah almost, IND -> CVG would report in at 500nm even after I triple checked the formulas... I already had the Java calc written, so I knew that wasn't the problem.

Weird, think I'll stick to creating the airprot database, this technical whatnot is way over my head.