Stats: Something new I've been toying with

[AKDejaVu]

Since the Top10 stats are currently on haitus... I got the itch to put some numbers together that I've been thinking about for a while.

I've totalled the fighter vs fighter kills by tour for each aircraft.  I thought about making some charts up for indicators... but am not sure exactly which way to go with it.

Here are the numbers:

http://www.dbstaines.com/TourStats/TourTotals/FvF_AllTourTotals.htm

AKDejaVu
P.S. I generated this chart in the nude

[ra]

Great job as always Deja.  

It's amazing to see how 8 lousy perk points turned the Hog-C from a mass murderer into a mere nuisance.  

Also, the newly strenghtened P-38 is starting to run up some good numbers.

ra

[Midnight]

DeJa

Will you please share with me the method that you use to pull the data from the HTC database?

I can't believe that you would do this all by hand and copy/paste it into Excel.

Are you using an SQL Query or some other DB engine? If so, please share the info of server, etc. I have a use for this in my squad, but currently have to capture all the data by hand.

Any help would be greatly appreciated. Thanks.

[DblTrubl]

Perk the 190A-5!!    

[Blindman]

theres a good argument for perking the n1k2

for such a limited fighter it sure does see alot of action

[Vruth]

LA-7's

Kills:     Deaths:  %Kills:  %Deaths:  K/D      Total Kills (all FvF)
18384  14211     8.203    6.341        1.294   224104


These numbers screamed at me. 18384 kills? The La-7 is a monster in the MA.

V

[CavemanJ]

Originally posted by Vruth
LA-7's

Kills:     Deaths:  %Kills:  %Deaths:  K/D      Total Kills (all FvF)
18384  14211     8.203    6.341        1.294   224104


These numbers screamed at me. 18384 kills? The La-7 is a monster in the MA.

V

While that may look like alot, it's only 8.2% of the fighter v fighter kills in the MA.  The F4U-1C got priced at 8 points because it was racking up 20% or more of the kills in the MA

That's actually an eye opener for me.  I'd have thught the La7 would have accounted for more than 8%, based on how often I see them in the arena.

[AKDejaVu]

Will you please share with me the method that you use to pull the data from the HTC database?

I can't believe that you would do this all by hand and copy/paste it into Excel.

All of the numbers can be imported into excell using a single macro that makes a single call.  The data can then be tableized for use.  The rest is done by pointers.  I make a spreadsheet for each tour... with the basic data there.  I then rely on some level of consistancy to utilize the data pointers already in the spreadsheet.  If no planes are added, I can update an entire tour in about 15 seconds.  If planes are added, a couple of hours of work is needed re-orienting pointers.

This spreadsheet was simply generated by pointing to each of the tour spreadsheets.  The first page was a squeak, but I'd already laid the tour spreadsheets out to be consistant from page to page as far as cumulative totals went.  That means the rest of the pages were simply find and replacing plane names.

I'm quite thankfull that I had the foresight to organize some things the way I did... it made this not too impacting.  About one hour was all that was needed to create this table.

Are you using an SQL Query or some other DB engine? If so, please share the info of server, etc. I have a use for this in my squad, but currently have to capture all the data by hand.

Any help would be greatly appreciated. Thanks.

I have downloaded MySQL, but have yet figured out how to use it.  I must admit, it was not as intuitive as I had hoped.  I'll need to buy a book on it.

I'm pretty sure I remember some e-mails from you in regards to this.  Basically, there is no good way to get individual pilot's stats as of now.  It can be done, but it would take days and cause some issues on the server.

The cumulative plane stats are easy to retrieve and are almost instantaneous.  Anything else gets exponentially more difficult.

Basically... wait until the new top 10 pages are up... I think they'll have everything you are looking for;)

And for everyone,

What charts do you think would be relevant?  What would be an effective way to graphically represent this data?

AKDejaVu

[AKDejaVu]

These numbers screamed at me. 18384 kills? The La-7 is a monster in the MA.

The tour24 numbers are not up-to-date since the tour had not ended when this was initially posted.  They will be fixed this afternoon.

That 18,384 kills was enough to place it 4th amongst all fighters the last I checked.

AKDejaVu

[Midnight]

That's exactly the part I am talking about DeJa, the pilot stats.

I already have a basic spreadsheet that can look at the data and prase it out in to the fields I want to look at, make logical calculations on the stats and then put the data where I want it for graphing.

The problem is going down the list of squad members and having to do each manually. When you were doing the 'top 10' pages, I assume you were not hand typing every player's game ID in the Data Entry field on the pilot lookup page.

Would you care to share the info on how you do the call? Or maybe send me the call so I can use it? Thanks

[Lephturn]

Originally posted by AKDejaVu
And for everyone,

What charts do you think would be relevant?  What would be an effective way to graphically represent this data?

AKDejaVu

Hmmm.. pie charts for the kill and death % make sense to me.  It would instantly put a plane's number of kills in perspective.  Possibly combine that with trend line graphs for pure # kills over multiple tours for each plane.

As for K/D, a simple bar chart comparing the different K/D ratios for each plane would do the trick.  You could make it more complex by making it 3D and run multiple tours in series in the same chart.

[AKcurly]

Originally posted by ra
Great job as always Deja.  

It's amazing to see how 8 lousy perk points turned the Hog-C from a mass murderer into a mere nuisance.  

Also, the newly strenghtened P-38 is starting to run up some good numbers.

ra

ra, the perk points didn't neutralize the F4U1c.  The F4U1c was gutted by HTC.  Here are the changes that I've noticed:

1) Killing a plane flying straight and level at d 4.0+ requires a good fraction of your ammo.  In the past, it just took a squirt.

2) They added weight to the F4U1c.  It is no longer nimble.

I'm not saying they shouldn't have done this [don't really have an opinion], but I strongly believe the perk value of the chog has nothing to do with the number of chogs we see in the MA.  For me, a chog has one value now: Field suppression.
curly

[AKDejaVu]

The problem is going down the list of squad members and having to do each manually. When you were doing the 'top 10' pages, I assume you were not hand typing every player's game ID in the Data Entry field on the pilot lookup page.

Would you care to share the info on how you do the call? Or maybe send me the call so I can use it? Thanks

This is actually the specific function that was causing problems on the server.  I promised to stop using it until a better solution would be found.  Sorry I cannot give you the info as a result.

When a solution is found, I'll get ahold of you and work out something to meet your needs.  I may even do something similar for all squads wanting to participate.

AKDejaVu

[Midnight]

I see. Well thanks for the info then DeJa.

I'll have to start hounding HTC for their database server info and I'll get an SQL query written for it.

I would only be pulling data for my squad members, which is only 24 right now. I doubt that would put any strain on the server.

If I do make any headway, I'll be sure to let you know. Thanks for the assistance

[janjan]

Heeh, Spits got over 20% of MA kills.