bloonstone_quarry_loadouts (view)

53 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, SniperMonkey 41 30 11 73.17% 0.57% 59.61%
Alchemist, MonkeyBuccaneer, SpikeFactory 679 418 261 61.56% 9.45% 57.90%
BananaFarm, BombShooter, WizardMonkey 39 28 11 71.79% 0.54% 57.67%
BananaFarm, DartlingGunner, SuperMonkey 109 71 38 65.14% 1.52% 56.19%
BananaFarm, DartMonkey, MortarMonkey 86 55 31 63.95% 1.20% 53.81%
BombShooter, MonkeySub, SpikeFactory 50 33 17 66.00% 0.70% 52.87%
BananaFarm, BombShooter, MonkeySub 96 59 37 61.46% 1.34% 51.72%
IceMonkey, MonkeyVillage, TackShooter 160 94 66 58.75% 2.23% 51.12%
GlueGunner, HeliPilot, MonkeyVillage 94 56 38 59.57% 1.31% 49.65%
BananaFarm, Druid, MonkeySub 134 76 58 56.72% 1.86% 48.33%
IceMonkey, MonkeyVillage, SuperMonkey 54 33 21 61.11% 0.75% 48.11%
HeliPilot, IceMonkey, SuperMonkey 128 71 57 55.47% 1.78% 46.86%
BananaFarm, SniperMonkey, WizardMonkey 48 29 19 60.42% 0.67% 46.58%
DartMonkey, IceMonkey, MonkeyVillage 50 30 20 60.00% 0.70% 46.42%
Alchemist, IceMonkey, NinjaMonkey 94 53 41 56.38% 1.31% 46.36%
DartlingGunner, MonkeyVillage, SuperMonkey 262 133 129 50.76% 3.64% 44.71%
BananaFarm, BoomerangMonkey, SpikeFactory 42 25 17 59.52% 0.58% 44.68%
MonkeyAce, SniperMonkey, WizardMonkey 33 20 13 60.61% 0.46% 43.93%
GlueGunner, MonkeyVillage, TackShooter 131 68 63 51.91% 1.82% 43.35%
BoomerangMonkey, MortarMonkey, SpikeFactory 34 20 14 58.82% 0.47% 42.28%
BananaFarm, DartlingGunner, IceMonkey 76 40 36 52.63% 1.06% 41.41%
DartlingGunner, SpikeFactory, SuperMonkey 91 47 44 51.65% 1.27% 41.38%
BananaFarm, SniperMonkey, TackShooter 47 26 21 55.32% 0.65% 41.11%
DartlingGunner, Druid, MonkeyVillage 56 30 26 53.57% 0.78% 40.51%
DartlingGunner, IceMonkey, MonkeyVillage 59 31 28 52.54% 0.82% 39.80%
BananaFarm, BombShooter, SpikeFactory 59 30 29 50.85% 0.82% 38.09%
BoomerangMonkey, MonkeySub, SpikeFactory 37 20 17 54.05% 0.51% 38.00%
BananaFarm, TackShooter, WizardMonkey 79 37 42 46.84% 1.10% 35.83%
Alchemist, DartlingGunner, SpikeFactory 39 20 19 51.28% 0.54% 35.59%
DartMonkey, GlueGunner, MonkeyVillage 89 40 49 44.94% 1.24% 34.61%
BananaFarm, DartMonkey, SpikeFactory 24 13 11 54.17% 0.33% 34.23%
IceMonkey, SniperMonkey, WizardMonkey 24 13 11 54.17% 0.33% 34.23%
HeliPilot, IceMonkey, MonkeyVillage 38 19 19 50.00% 0.53% 34.10%
BombShooter, DartlingGunner, MonkeyBuccaneer 25 13 12 52.00% 0.35% 32.42%
MonkeyVillage, SniperMonkey, SuperMonkey 50 23 27 46.00% 0.70% 32.19%
MonkeyVillage, SniperMonkey, TackShooter 50 23 27 46.00% 0.70% 32.19%
BananaFarm, MonkeySub, SuperMonkey 30 15 15 50.00% 0.42% 32.11%
GlueGunner, MonkeyBuccaneer, WizardMonkey 30 15 15 50.00% 0.42% 32.11%
Alchemist, HeliPilot, NinjaMonkey 51 23 28 45.10% 0.71% 31.44%
Alchemist, GlueGunner, NinjaMonkey 49 22 27 44.90% 0.68% 30.97%
DartlingGunner, MonkeyVillage, SpikeFactory 26 13 13 50.00% 0.36% 30.78%
MonkeyBuccaneer, SniperMonkey, WizardMonkey 43 19 24 44.19% 0.60% 29.34%
GlueGunner, SniperMonkey, WizardMonkey 27 13 14 48.15% 0.38% 29.30%
HeliPilot, MonkeyVillage, SuperMonkey 61 25 36 40.98% 0.85% 28.64%
BoomerangMonkey, SniperMonkey, SpikeFactory 21 10 11 47.62% 0.29% 26.26%
Druid, MonkeySub, SpikeFactory 25 11 14 44.00% 0.35% 24.54%
GlueGunner, MonkeySub, SuperMonkey 28 12 16 42.86% 0.39% 24.53%
SniperMonkey, SuperMonkey, TackShooter 44 17 27 38.64% 0.61% 24.25%
Alchemist, NinjaMonkey, SniperMonkey 30 12 18 40.00% 0.42% 22.47%
EngineerMonkey, TackShooter, WizardMonkey 31 12 19 38.71% 0.43% 21.56%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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