25 replies to this topic

[santanu]

I am trying to make a simple access database of distance of each city in AE from my hub. Right now I manually enter the reading in the db after checking the "distance calculator" but thats very tedious and boring. Can any programming guru suggest me a more automated method?

Why I need it? Well I have an excel sheet on aircraft yeild curve so superimposing the two I get the best DoP for that city and my hub. It kind of becomes a very good ready recokoner. So I can progress from nearest to the most further city from my hub and make tons of virtual moolah!

[watchdog]

Originally posted by santanu
I am trying to make a simple access database of distance of each city in AE from my hub. Right now I manually enter the reading in the db after checking the "distance calculator" but thats very tedious and boring. Can any programming guru suggest me a more automated method?

Why I need it? Well I have an excel sheet on aircraft yeild curve so superimposing the two I get the best DoP for that city and my hub. It kind of becomes a very good ready recokoner. So I can progress from nearest to the most further city from my hub and make tons of virtual moolah!

One can recall that a player did an excel sheet to do this but not sure who it was.

It was before this re-set was performed so look in the search field.

Also see your U2U

[santanu]

Yes that excel sheet I've. Now I need to make the DB. LOL! check your U2U too!

[watchdog]

Originally posted by santanu
Yes that excel sheet I've. Now I need to make the DB. LOL! check your U2U too!

Your U2U also...again....

[miller22 (inactive)]

There exists no database for distance in Ae. It is all calculated.

[santanu]

Ah! Thanks Miller. Is it possible that at you can give a command which will generate this output in a flat file-distance of all the cities from a particular city. Right now I have to see individually each one in the distance calculator and then write down in my Db which is boring.

[ziliu]

Those of you who trust me enough to run a .exe file from me might be interested in downloading a program I made.

For screenshot and download link, see http://www.airlineem...ad.php?tid=4421.


[Edited on 10/9/2005 by ziliu]

[watchdog]

Many thanks for this nice little file, now I can work faster making routes.

10/10........

[g-w-r]

coool, the gate prices are totally wrong, but the distances are great.

[masscop]

I cant get it to run...it says I need some dll file. THis make sense to anyone?

[Willip]

really useful, thanks a lot

[ziliu]

Oops, I never caught gate prices being wrong. Well fixed that now, download http://bea.xmgfree.c...ySearcher03.zip instead.

Masscop and others: You'll probably need to download Visual Basic runtimes from Microsoft. A direct link is http://www.microsoft...&displaylang=en.

[Edited on 10/9/2005 by ziliu]

[Edited on 10/9/2005 by ziliu]

[masscop]

Thanks for the info...I tried installing that and I got the same message. Guess I just have to crunch the numbers myself:(

[thehammy]

cool thts brilliant thanks for tht

[tropicalsq744]

Originally posted by ziliu
Oops, I never caught gate prices being wrong. Well fixed that now, download http://bea.xmgfree.c...ySearcher03.zip instead.

Masscop and others: You'll probably need to download Visual Basic runtimes from Microsoft. A direct link is http://www.microsoft...&displaylang=en.

[Edited on 10/9/2005 by ziliu]

[Edited on 10/9/2005 by ziliu]

Wow. Thanks man.

[ziliu]

Masscop: What DLL does it say is missing?

[santanu]

Thanks a million ziliu thats it!! Thats the one I was looking for. Wow! you are a wizard!

Now see the fun!

[watchdog]

Originally posted by santanu
Thanks a million ziliu thats it!! Thats the one I was looking for. Wow! you are a wizard!

Now see the fun!

Just remember that the distance in that program is NOTTTTTTTTTTTTTT correct, so double check before ordering gates.

[masscop]

says I am missing the MSSDFMT dll

[watchdog]

Originally posted by masscop
says I am missing the MSSDFMT dll

Get it here

http://www.dll-files....shtml?msstdfmt