inflection_loadouts (view)

112 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 460 340 120 73.91% 2.13% 69.90%
Alchemist, DartlingGunner, SuperMonkey 101 78 23 77.23% 0.47% 69.05%
DartlingGunner, MonkeyVillage, SuperMonkey 299 213 86 71.24% 1.38% 66.11%
BananaFarm, DartlingGunner, NinjaMonkey 239 164 75 68.62% 1.10% 62.74%
BananaFarm, MonkeySub, SpikeFactory 595 394 201 66.22% 2.75% 62.42%
BananaFarm, DartMonkey, SpikeFactory 5574 3365 2209 60.37% 25.75% 59.09%
BananaFarm, DartlingGunner, IceMonkey 348 216 132 62.07% 1.61% 56.97%
BananaFarm, BoomerangMonkey, IceMonkey 54 36 18 66.67% 0.25% 54.09%
BananaFarm, DartMonkey, DartlingGunner 95 60 35 63.16% 0.44% 53.46%
BananaFarm, HeliPilot, SpikeFactory 44 29 15 65.91% 0.20% 51.90%
DartMonkey, DartlingGunner, SpikeFactory 35 23 12 65.71% 0.16% 49.99%
BananaFarm, GlueGunner, SpikeFactory 44 28 16 63.64% 0.20% 49.42%
BananaFarm, DartMonkey, MonkeySub 220 122 98 55.45% 1.02% 48.89%
BananaFarm, EngineerMonkey, SpikeFactory 68 41 27 60.29% 0.31% 48.66%
BananaFarm, DartlingGunner, GlueGunner 97 56 41 57.73% 0.45% 47.90%
SpikeFactory, TackShooter, WizardMonkey 188 102 86 54.26% 0.87% 47.13%
BananaFarm, BoomerangMonkey, GlueGunner 95 54 41 56.84% 0.44% 46.88%
Alchemist, BananaFarm, DartlingGunner 240 126 114 52.50% 1.11% 46.18%
BananaFarm, EngineerMonkey, WizardMonkey 56 33 23 58.93% 0.26% 46.04%
BananaFarm, DartMonkey, SniperMonkey 122 66 56 54.10% 0.56% 45.26%
BananaFarm, BoomerangMonkey, SpikeFactory 443 221 222 49.89% 2.05% 45.23%
DartlingGunner, GlueGunner, SpikeFactory 36 22 14 61.11% 0.17% 45.19%
BananaFarm, DartMonkey, MortarMonkey 301 150 151 49.83% 1.39% 44.19%
BananaFarm, DartlingGunner, SpikeFactory 264 132 132 50.00% 1.22% 43.97%
Alchemist, DartlingGunner, SpikeFactory 905 425 480 46.96% 4.18% 43.71%
BananaFarm, BoomerangMonkey, SniperMonkey 106 56 50 52.83% 0.49% 43.33%
Alchemist, DartlingGunner, NinjaMonkey 48 27 21 56.25% 0.22% 42.22%
DartMonkey, MonkeyBuccaneer, SpikeFactory 44 25 19 56.82% 0.20% 42.18%
BananaFarm, Druid, MonkeySub 364 171 193 46.98% 1.68% 41.85%
Alchemist, DartMonkey, SpikeFactory 59 32 27 54.24% 0.27% 41.52%
DartMonkey, NinjaMonkey, SpikeFactory 57 31 26 54.39% 0.26% 41.46%
Alchemist, MonkeyBuccaneer, SpikeFactory 441 201 240 45.58% 2.04% 40.93%
BananaFarm, BoomerangMonkey, MonkeySub 152 74 78 48.68% 0.70% 40.74%
DartMonkey, GlueGunner, SpikeFactory 87 44 43 50.57% 0.40% 40.07%
BananaFarm, DartlingGunner, WizardMonkey 74 38 36 51.35% 0.34% 39.96%
DartMonkey, MonkeySub, SpikeFactory 70 36 34 51.43% 0.32% 39.72%
BananaFarm, BombShooter, DartlingGunner 28 16 12 57.14% 0.13% 38.81%
MonkeyBuccaneer, TackShooter, WizardMonkey 26 15 11 57.69% 0.12% 38.70%
SniperMonkey, SpikeFactory, SuperMonkey 37 20 17 54.05% 0.17% 38.00%
DartMonkey, SpikeFactory, WizardMonkey 42 22 20 52.38% 0.19% 37.28%
BoomerangMonkey, IceMonkey, MonkeySub 29 16 13 55.17% 0.13% 37.07%
DartMonkey, SniperMonkey, SpikeFactory 56 28 28 50.00% 0.26% 36.90%
EngineerMonkey, IceMonkey, SniperMonkey 27 15 12 55.56% 0.12% 36.81%
SniperMonkey, SuperMonkey, TackShooter 61 30 31 49.18% 0.28% 36.63%
BananaFarm, DartMonkey, NinjaMonkey 25 14 11 56.00% 0.12% 36.54%
BoomerangMonkey, MonkeySub, SpikeFactory 66 32 34 48.48% 0.30% 36.43%
NinjaMonkey, TackShooter, WizardMonkey 23 13 10 56.52% 0.11% 36.26%
BananaFarm, DartMonkey, GlueGunner 185 79 106 42.70% 0.85% 35.57%
SniperMonkey, SpikeFactory, WizardMonkey 94 42 52 44.68% 0.43% 34.63%
BoomerangMonkey, MortarMonkey, SpikeFactory 129 55 74 42.64% 0.60% 34.10%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW inflection_loadouts AS 
WITH inflection AS
    (SELECT *
    FROM matches
    WHERE map = 'inflection')
SELECT Loadout,
       Games,
       Wins,
       Losses,
       printf('%.2f%%', WR * 100)                                          AS Winrate,
       printf('%.2f%%', PR * 100)                                          AS Pickrate,
       printf('%.2f%%', (WR - 1.96 * SQRT((WR * (1 - WR)) / Games)) * 100) AS WinRate_LowerBound_95CI
FROM (SELECT Loadout,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM inflection) * 2)    AS PR
      FROM (SELECT Loadout,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT printf('%s, %s, %s', lt1, lt2, lt3) AS Loadout,
                         playerLeftWin                       AS Win
                  FROM inflection
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM inflection)
            GROUP BY Loadout)
      WHERE Wins >= 10
        AND Losses >= 10)
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(WinRate_LowerBound_95CI) = 6
ORDER BY WinRate_LowerBound_95CI DESC;