Aces High Bulletin Board

General Forums => Aces High General Discussion => Topic started by: AKDejaVu on April 04, 2002, 12:05:13 AM

Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 04, 2002, 12:05:13 AM
Tour 26 (http://www.dbstaines.com/TourStats/Tour26/Tour26.htm)

Enjoy!

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: Tac on April 04, 2002, 12:20:46 AM
Every plane when looked upon has the exact same kills and deaths of its own type? Am I misenterpreting something?

me262 has 26 kills and 26 deaths on the me262 row.
P38L has 639 kills and 639 deaths on the P-38L row

and so on with every plane.

regardless, this is awesome
Title: Tour 26 FighterVsFighter Stats
Post by: CptTrips on April 04, 2002, 12:34:38 AM
>Every plane when looked upon has the exact same kills and
>deaths of its own type? Am I misenterpreting something?



Uhhm.  It pretty much HAS to be that way, right?


Wab
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 04, 2002, 12:38:11 AM
Quote
Originally posted by Tac
Every plane when looked upon has the exact same kills and deaths of its own type? Am I misenterpreting something?
Yes Tac.

If you are flying in a P-38 and shoot down another P-38.. how does that affect overall stats?  1 P-38 kill and 1 P-38 death right?  That is how it would be every single time.... so they'd always stay even.

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 04, 2002, 07:50:05 AM
Title: Tour 26 FighterVsFighter Stats
Post by: Vermillion on April 04, 2002, 07:52:43 AM
As always.... Excellent Work!! :)
Title: Tour 26 FighterVsFighter Stats
Post by: eskimo2 on April 04, 2002, 08:08:17 AM
AKDejaVu,

Thanks, cool stuff!

Can you post a list of fighter vs fighter in desending order by K/D?
And the same for Fighters vs Bombers, GVs etc...?

Thanks,

eskimo
Title: Tour 26 FighterVsFighter Stats
Post by: Midnight on April 04, 2002, 08:43:37 AM
Amazing.

The P-51D is second on the list of overall kills.

Top of the list for bomber kills

Second in fighter kills

The strange part is, I still seem to think that I see more Spits, LA7s and N1Ks than P-51s combined.

What I would really like to know is how many sorties were flown by each plane type. I think that would paint a little better picture as to how these planes are utilized.

Also, we really need to know who the top ten are again ASAP.

DeJa, I know I've asked before, and you still haven't shared, but PLEASE, PRETTY PLEASE, with Sugar on Top, How do you query to get all this info? I can't imagine that you get all these numbers manually.
Title: Tour 26 FighterVsFighter Stats
Post by: VWE001 on April 04, 2002, 10:58:02 AM
Curious as to why more don't take some of the off beat type of planes. Last tour I had 221 kills in the Hurricane Mk.IIc while I only shot down 7 of them. My deaths in it were 108... now yes i sometimes feel as though I could run faster than it goes but it really is a great turn fighter.
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 04, 2002, 11:00:58 AM
Quote
DeJa, I know I've asked before, and you still haven't shared, but PLEASE, PRETTY PLEASE, with Sugar on Top, How do you query to get all this info? I can't imagine that you get all these numbers manually.
The data is all gathered in one single querry (all fighters vs all fighters).  The rest is simply done via macro (place the returned querry into a table) and links on each page to the original data page... then from the overal comparison page to each aircraft page.

Its really quite simple... until they add a new fricking aircraft.

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 04, 2002, 11:06:49 AM
Quote
Can you post a list of fighter vs fighter in desending order by K/D?
And the same for Fighters vs Bombers, GVs etc...?
OK... I'll add another table.  Probably won't be for a couple days though.

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: Nifty on April 04, 2002, 12:00:24 PM
what I wanna know are the people who lost a Me262 to a c202, a spit I and a zeke!   ;)

DjV!   I don't even want to know how big that "one, single query" is!
Title: Tour 26 FighterVsFighter Stats
Post by: eskimo2 on April 04, 2002, 12:03:14 PM
Quote
Originally posted by AKDejaVu
OK... I'll add another table.  Probably won't be for a couple days though.

AKDejaVu


Thanks AKDejaVu!

eskimo
Title: Tour 26 FighterVsFighter Stats
Post by: Vermillion on April 04, 2002, 12:19:36 PM
Quote
what I wanna know are the people who lost a Me262 to a c202, a spit I and a zeke!


How much you wanna bet that those are collision deaths? LOL! :)
Title: Tour 26 FighterVsFighter Stats
Post by: Midnight on April 04, 2002, 04:38:07 PM
Quote
Originally posted by AKDejaVu
The data is all gathered in one single querry (all fighters vs all fighters).  The rest is simply done via macro (place the returned querry into a table) and links on each page to the original data page... then from the overal comparison page to each aircraft page.

Its really quite simple... until they add a new fricking aircraft.

AKDejaVu


And the instructions for running this query are???

I sent another request to HTC, and they said to ask you...
Title: Tour 26 FighterVsFighter Stats
Post by: hazed- on April 04, 2002, 06:02:21 PM
is there any chance of having the stats the way you used to do them? you know with top 10 pilots names on each plane?

i got on there once and was really chuffed :)

stats are cool but name up in lights is even better :)

if not then how about a stats for the CT like this one? :)
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 05, 2002, 09:01:06 AM
Sorry, but my site is down until QWest figures out the problem with their DSLAM.

I did take the oportunity to add the K/D sorting for each individual category... someday you may be able to see it.

And Hazed, I plan on doing the Top 10 pages again... just waiting on HTC to help coordinate some things.  When that happens, I'll do pages for all tours up till now... and they'll be quite a bit more inclusive than they used to be.

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: hazed- on April 05, 2002, 09:17:39 AM
cool deja thnx
Title: Tour 26 FighterVsFighter Stats
Post by: Vector on April 05, 2002, 09:24:31 AM
S!
I sure would like to see your stats up again. THERE would be something to aim for (for those who's interested of k/d's anyway). It was also interesting to see what planes folks actually flies :)
Good job dejavu and I really hope HTC could bring the answer.

EDIT: Oh and I managed somehow to get my prettythang there too in 109G-2 & P-47D-11 and I'll remember it for the rest of my life :)
Title: Tour 26 FighterVsFighter Stats
Post by: Vruth on April 05, 2002, 09:46:55 AM
Quote
Midnight Said:
Amazing.

The P-51D is second on the list of overall kills.

Top of the list for bomber kills

Second in fighter kills

The strange part is, I still seem to think that I see more Spits, LA7s and N1Ks than P-51s combined.


From what I can tell Midnight, the P-51 is an expert's plane. It is hard to fly, it's hard to dogfight, it's hard to shoot down opponents, and when in the hands of a competent pilot, it is a lethal machine.  Given the number of aces who fly the P-51 in our arena, (yeah -  even you Hangtime) the numbers IMHO reflect a small number of pilots who rack up a few thousand kills.  

It's not that everyone is flying the P-51D, it's the fact that those who are flying the 51 are flying it well.
Title: Tour 26 FighterVsFighter Stats
Post by: MANDOBLE on April 05, 2002, 10:40:38 AM
It is hard to fly, it's hard to dogfight, it's hard to shoot down opponents

Are you talking about AH P51??? :eek: :eek: :eek:
Title: Tour 26 FighterVsFighter Stats
Post by: Nifty on April 05, 2002, 10:48:19 AM
no, you see more spits than P-51s because there are 4 models that carry the SPIT icon, one of which is usually the top killer, and another that is in the top 5.  You can also instantly tell the difference between a D pony and a B pony, but usually you have to get a little closer to the Spits to pick out the color schemes.

As for only experts flying the P-51...  How come it's got basically the same K/D ratio as the Spitfires which are flown by newbies?  So there have to be lots of newbies that die in the Runstang to make up for the sparkling K/D that aces in the Pony must have.   That and last tour, the P-51D accounted for 2 of my 10 Spitfire Mk I kills.  ;)  I know none of you hot Pony riders would have ever let a Spit I get ya!

Be careful Vruth, you're starting to sound like those leather wearing LuftWobble "experten"!   :D
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 05, 2002, 02:19:52 PM
The page is back up now.

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: Zippatuh on April 05, 2002, 03:10:16 PM
Deja,

Ok, this may be a stupid question, but what application are you using to run the queries?  Microsoft Excel web queries do not work with the HTC web site due to how it is retrieving the data.  Unless there is a catch that I haven’t found.  Everything I have found for the Excel queries wants to reference the query information in the http address.

So, is it something you designed yourself?
Something off the shelf you purchased?
It can be done in Excel and either I do not have a robust version or just not finding the directions?


Can ya help a desktop dunce out? ;)

Zippatuh
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 05, 2002, 03:54:48 PM
All data you can view is done via a web querry.  You just need to figure out the web adress and switches to use with the querry.  Its all right there on the scorepage.

AKDejaVu
Title: Tour 26 FighterVsFighter Stats
Post by: AKDejaVu on April 05, 2002, 04:44:37 PM
Another thing to try would be to save the web page and see if the macros save with it.

AKDejaVu