Author Topic: Tour 26 FighterVsFighter Stats (Read 380 times)

AKDejaVu · « **on:** April 04, 2002, 12:05:13 AM »

Tour 26

Enjoy!

AKDejaVu

Tac · « **Reply #1 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

CptTrips · « **Reply #2 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

AKDejaVu · « **Reply #3 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

AKDejaVu · « **Reply #4 on:** April 04, 2002, 07:50:05 AM »

Vermillion · « **Reply #5 on:** April 04, 2002, 07:52:43 AM »

As always.... Excellent Work!!

eskimo2 · « **Reply #6 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

Midnight · « **Reply #7 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.

VWE001 · « **Reply #8 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.

AKDejaVu · « **Reply #9 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

AKDejaVu · « **Reply #10 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

Nifty · « **Reply #11 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!~~

eskimo2 · « **Reply #12 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

Vermillion · « **Reply #13 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!

Midnight · « **Reply #14 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...