mayan_map_01_loadouts (view)

182 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 86 64 22 74.42% 0.37% 65.20%
BananaFarm, BoomerangMonkey, GlueGunner 47 36 11 76.60% 0.20% 64.49%
BananaFarm, MortarMonkey, TackShooter 206 138 68 66.99% 0.88% 60.57%
Alchemist, NinjaMonkey, SniperMonkey 122 82 40 67.21% 0.52% 58.88%
GlueGunner, MonkeyVillage, TackShooter 2117 1275 842 60.23% 9.06% 58.14%
BananaFarm, BombShooter, MonkeySub 103 68 35 66.02% 0.44% 56.87%
BananaFarm, BoomerangMonkey, WizardMonkey 134 87 47 64.93% 0.57% 56.85%
BananaFarm, TackShooter, WizardMonkey 1556 920 636 59.13% 6.66% 56.68%
BananaFarm, MonkeySub, TackShooter 97 64 33 65.98% 0.42% 56.55%
GlueGunner, HeliPilot, MonkeyVillage 293 177 116 60.41% 1.25% 54.81%
DartMonkey, GlueGunner, MonkeyAce 50 33 17 66.00% 0.21% 52.87%
IceMonkey, SniperMonkey, SuperMonkey 64 41 23 64.06% 0.27% 52.31%
BananaFarm, GlueGunner, TackShooter 229 134 95 58.52% 0.98% 52.13%
BananaFarm, BombShooter, WizardMonkey 231 135 96 58.44% 0.99% 52.09%
BananaFarm, IceMonkey, TackShooter 99 61 38 61.62% 0.42% 52.04%
BananaFarm, SniperMonkey, TackShooter 238 138 100 57.98% 1.02% 51.71%
DartMonkey, GlueGunner, MonkeyVillage 253 145 108 57.31% 1.08% 51.22%
BananaFarm, BoomerangMonkey, SpikeFactory 104 63 41 60.58% 0.45% 51.18%
IceMonkey, MonkeyVillage, NinjaMonkey 58 36 22 62.07% 0.25% 49.58%
BoomerangMonkey, NinjaMonkey, SniperMonkey 60 37 23 61.67% 0.26% 49.36%
BananaFarm, BoomerangMonkey, SuperMonkey 94 55 39 58.51% 0.40% 48.55%
BombShooter, SpikeFactory, WizardMonkey 29 19 10 65.52% 0.12% 48.22%
DartlingGunner, TackShooter, WizardMonkey 58 35 23 60.34% 0.25% 47.76%
Alchemist, Druid, NinjaMonkey 31 20 11 64.52% 0.13% 47.67%
BananaFarm, DartlingGunner, IceMonkey 162 89 73 54.94% 0.69% 47.28%
BananaFarm, SniperMonkey, WizardMonkey 234 124 110 52.99% 1.00% 46.60%
BananaFarm, BombShooter, SpikeFactory 161 87 74 54.04% 0.69% 46.34%
BananaFarm, DartMonkey, MortarMonkey 41 25 16 60.98% 0.18% 46.04%
BananaFarm, BoomerangMonkey, NinjaMonkey 168 89 79 52.98% 0.72% 45.43%
BoomerangMonkey, MonkeyVillage, SuperMonkey 65 37 28 56.92% 0.28% 44.88%
IceMonkey, MonkeyVillage, TackShooter 394 196 198 49.75% 1.69% 44.81%
IceMonkey, MonkeyVillage, WizardMonkey 42 25 17 59.52% 0.18% 44.68%
BombShooter, MonkeyVillage, SuperMonkey 37 22 15 59.46% 0.16% 43.64%
Alchemist, DartlingGunner, SpikeFactory 77 42 35 54.55% 0.33% 43.42%
SniperMonkey, TackShooter, WizardMonkey 205 103 102 50.24% 0.88% 43.40%
Druid, SniperMonkey, SuperMonkey 73 40 33 54.79% 0.31% 43.38%
BananaFarm, BoomerangMonkey, SniperMonkey 69 38 31 55.07% 0.30% 43.34%
MonkeyAce, SniperMonkey, WizardMonkey 63 35 28 55.56% 0.27% 43.29%
SniperMonkey, SuperMonkey, WizardMonkey 197 99 98 50.25% 0.84% 43.27%
SniperMonkey, SpikeFactory, WizardMonkey 163 83 80 50.92% 0.70% 43.25%
BoomerangMonkey, SniperMonkey, SuperMonkey 92 49 43 53.26% 0.39% 43.07%
GlueGunner, NinjaMonkey, SuperMonkey 26 16 10 61.54% 0.11% 42.84%
DartMonkey, IceMonkey, MonkeyVillage 76 41 35 53.95% 0.33% 42.74%
Alchemist, GlueGunner, TackShooter 28 17 11 60.71% 0.12% 42.62%
BananaFarm, BoomerangMonkey, MonkeySub 30 18 12 60.00% 0.13% 42.47%
BananaFarm, BombShooter, MortarMonkey 56 31 25 55.36% 0.24% 42.34%
BananaFarm, NinjaMonkey, WizardMonkey 100 52 48 52.00% 0.43% 42.21%
IceMonkey, MonkeyVillage, SuperMonkey 92 48 44 52.17% 0.39% 41.97%
SniperMonkey, SpikeFactory, TackShooter 129 65 64 50.39% 0.55% 41.76%
BananaFarm, DartlingGunner, GlueGunner 59 32 27 54.24% 0.25% 41.52%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW mayan_map_01_loadouts AS 
WITH mayan_map_01 AS
    (SELECT *
    FROM matches
    WHERE map = 'mayan_map_01')
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 mayan_map_01) * 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 mayan_map_01
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM mayan_map_01)
            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;