Ads displayed for guests and not donating members only. Get ad-free by donating. If you have already donated, please read here.
Results 1 to 14 of 14

Thread: VeryRisky's fancy number bashing

  1. #1

    VeryRisky's fancy number bashing

    I like to dig around in my battle results data and often post interesting bits on the WoT forums. But since some of these may be ideas for this site I thought I'd gather them here in a thread.

  2. #2
    First off today was a query to tell me how long ago I got my max damage and max (base)XP games. Quite amusing to see how long ago that big game was.



    Tank tier Max XP Date Max Dam Date
    M46 Patton 9 980 09-Nov-14 3446 09-Nov-14
    M103 9 968 03-Nov-14 3195 07-Oct-14
    M4A3E8 Fury 6 1220 30-Oct-14 1939 05-Nov-14
    T7 Combat Car 2 779 15-Oct-14 649 15-Oct-14
    T37 6 767 11-Oct-14 1589 22-Oct-14
    T30 9 930 10-Oct-14 3429 10-Oct-14
    T14 5 1034 06-Oct-14 1594 16-May-14
    T67 5 1392 30-Sep-14 2440 26-May-14
    T69 8 729 12-Sep-14 1911 19-Aug-14
    T57 2 680 05-Sep-14 973 05-Sep-14
    M41 HMC 5 913 12-Aug-14 2198 15-Jun-13
    T26E4 SuperPershing 8 1299 20-Jul-14 2959 20-Jul-14
    M12 7 918 08-Jul-14 3057 08-Jun-14
    M18 Hellcat 6 1130 21-Jun-14 2343 21-Jun-14
    M26 Pershing 8 959 09-May-14 2817 22-Dec-13
    T32 8 1123 05-May-14 2584 09-Feb-14
    T71 7 1090 01-May-14 2066 30-Dec-13
    M44 6 1317 24-Apr-14 2835 24-Apr-14
    M37 4 849 24-Apr-14 1407 24-Apr-14
    T29 7 1408 23-Mar-14 3422 23-Mar-14
    M4A3E2 Sherman Jumbo 6 1230 10-Mar-14 2172 07-May-14
    T28 Prototype 8 1336 15-Jan-14 3969 23-Mar-14
    T25/2 7 1016 13-Jan-14 2741 08-Aug-13
    T28 8 1200 28-Dec-13 4163 28-Dec-13
    M2 Light Tank 2 939 15-Dec-13 822 12-May-13
    M4 Sherman 5 1399 12-Dec-13 2589 12-Dec-13
    T40 4 1528 11-Dec-13 2536 11-Dec-13
    M3 Lee 4 825 09-Dec-13 1311 09-Dec-13
    T18 2 1021 30-Nov-13 1140 31-May-13
    T25 AT 7 1108 29-Nov-13 3154 29-Nov-13
    M2 Medium Tank 3 943 28-Nov-13 979 27-Nov-13
    M8A1 4 1073 12-Nov-13 1810 12-Nov-13
    T20 7 1579 01-Nov-13 3734 01-Nov-13
    M3 Stuart 3 674 31-Oct-13 795 29-Aug-13
    T82 3 1394 24-Oct-13 1934 24-Oct-13
    T1 Heavy Tank 5 1445 13-Oct-13 2589 13-Oct-13
    M24 Chaffee 5 1549 22-Sep-13 1925 22-Sep-13
    T1E6 2 635 06-Sep-13 455 06-Sep-13
    T2 Light Tank 2 1002 22-Aug-13 505 22-Aug-13
    M5 Stuart 4 939 28-Jul-13 1014 25-Jan-13
    M6 6 1296 28-Jul-13 2652 09-Aug-13
    T2 Medium Tank 2 767 23-Jul-13 549 24-May-13
    M4A3E8 Sherman 6 788 13-Jul-13 1721 13-Aug-13
    M36 Jackson 6 1219 07-Jul-13 3012 07-Jul-13
    M10 Wolverine 5 1358 03-Jul-13 2309 03-Jul-13
    M7 5 1226 03-Jul-13 1125 26-May-14
    Ram II 5 1038 01-Jul-13 1480 01-Jul-13
    T21 6 1308 26-May-13 1603 05-Jan-14
    M7 Priest 4 763 06-May-13 3324 24-Mar-13
    M22 Locust 3 1044 11-Apr-13 962 06-Apr-13
    T1 Cunningham 1 1472 12-Feb-13 1120 12-Feb-13

  3. #3
    Another thign I like to do is to split the tank stats between wins and losses - e.g.

    Tank WR Av Dam On Loss On Win
    T25 AT 62% 1093 834 1251
    T25/2 49% 1031 1022 1041

    An amusing little analysis of how two tanks with the same average damage have such different WR!

  4. #4
    And this chart I've produced a few times, showing how my tank tier changed by month

  5. #5
    This one I'll just link as there were a few tables that will take a while to format for vBulletin.

    http://forum.worldoftanks.eu/index.p...6#entry9342126

    What that shows is the distribution of battles by tier spread (TierMax-TankTier) and the winrate in them. I rand this by Class and by tank tier and then showed some individual tanks. The point is to show that no you just don't get "All of my battles are bottom tier" and that you can win just as well without being top tier in a lot of tanks.

  6. #6
    Retired Commander Phalynx.eu's Avatar
    Join Date
    Jan 2013
    Location
    Erlangen, Germany
    Posts
    2,127
    Quote Originally Posted by VeryRisky.eu View Post
    And this chart I've produced a few times, showing how my tank tier changed by month
    This one sounds like fun. There is already an issue about this.

    Will add also a type related chart.

  7. #7
    ^ Cheers - I think people will like that one.

    Now one you won't want to do as moving averages are horrible in SQL


    Plus it's only really of interest where you have a number of battles of a long period.

  8. #8
    Retired Commander Phalynx.eu's Avatar
    Join Date
    Jan 2013
    Location
    Erlangen, Germany
    Posts
    2,127

  9. #9
    Nice work! You could possibly add Platoon/Non Platoon (since January) or Game Mode (Random/Team/Stronkhold etc) if you want.

    The data labels do make it look a little messy, though (particularly if you have a row of zeros. Would you consider a switch to show/hide them?

  10. #10
    Retired Commander Phalynx.eu's Avatar
    Join Date
    Jan 2013
    Location
    Erlangen, Germany
    Posts
    2,127
    Removed that label, I think the Tooltip is enough.

    Added Platoon (limited to 15 months, not only since 2014-01) and Game Mode.

  11. #11
    I think that looks really good.

  12. #12
    Decided to try to correlate survival time (lifetime/battle duration) with winrate. I think it might have had some value but I will need to try it with some bettler players to make sense of the logic.

    The concept though is to see in which tanks, you win significantly more where you are alive for most of the battle and in which it doesn't matter. Sure enough my hardest carrying tank the T40 came top.

  13. #13
    Supporter kevenh_66.eu's Avatar
    Join Date
    Mar 2014
    Location
    Royal County Of Berks
    Posts
    17
    you two are up to some good number crunching stuff
    Keep it up

  14. #14
    Just a quick one as a summary for my most played tanks this year (or actually since the 9th Jan when platoon flag arrived!


    Funny how I seem happier solo with some of them.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •