s24+_matches: basalt_columns_loadouts: 106 rows

106 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey	455	339	116	74.51%	2.61%	70.50%
BananaFarm, DartMonkey, SpikeFactory	1158	778	380	67.18%	6.65%	64.48%
BananaFarm, DartlingGunner, IceMonkey	274	188	86	68.61%	1.57%	63.12%
DartlingGunner, MonkeyVillage, SuperMonkey	279	185	94	66.31%	1.60%	60.76%
BananaFarm, DartMonkey, MortarMonkey	468	304	164	64.96%	2.69%	60.63%
Alchemist, BananaFarm, MonkeyAce	800	492	308	61.50%	4.59%	58.13%
BananaFarm, DartMonkey, SniperMonkey	142	90	52	63.38%	0.82%	55.46%
BananaFarm, DartlingGunner, NinjaMonkey	166	102	64	61.45%	0.95%	54.04%
BananaFarm, BoomerangMonkey, MonkeySub	213	129	84	60.56%	1.22%	54.00%
BananaFarm, MonkeyAce, MonkeySub	277	163	114	58.84%	1.59%	53.05%
Alchemist, DartlingGunner, SuperMonkey	84	53	31	63.10%	0.48%	52.78%
BananaFarm, MonkeySub, WizardMonkey	84	53	31	63.10%	0.48%	52.78%
MonkeyBuccaneer, SniperMonkey, SpikeFactory	34	23	11	67.65%	0.20%	51.92%
BananaFarm, MonkeySub, SpikeFactory	361	203	158	56.23%	2.07%	51.12%
BananaFarm, BoomerangMonkey, SniperMonkey	106	64	42	60.38%	0.61%	51.07%
BananaFarm, DartlingGunner, GlueGunner	79	48	31	60.76%	0.45%	49.99%
BananaFarm, DartMonkey, MonkeySub	277	154	123	55.60%	1.59%	49.74%
Alchemist, MonkeyAce, SpikeFactory	84	50	34	59.52%	0.48%	49.03%
Alchemist, BananaFarm, DartlingGunner	486	257	229	52.88%	2.79%	48.44%
BananaFarm, DartlingGunner, MonkeyAce	106	61	45	57.55%	0.61%	48.14%
BananaFarm, EngineerMonkey, MonkeyAce	571	297	274	52.01%	3.28%	47.92%
Alchemist, DartlingGunner, MonkeyBuccaneer	273	144	129	52.75%	1.57%	46.82%
BananaFarm, MonkeyAce, SpikeFactory	189	101	88	53.44%	1.09%	46.33%
BananaFarm, DartlingGunner, WizardMonkey	154	83	71	53.90%	0.88%	46.02%
Alchemist, DartlingGunner, SpikeFactory	469	235	234	50.11%	2.69%	45.58%
BananaFarm, Druid, MonkeySub	380	190	190	50.00%	2.18%	44.97%
BananaFarm, MonkeyAce, SniperMonkey	93	51	42	54.84%	0.53%	44.72%
DartlingGunner, MonkeyAce, SpikeFactory	42	25	17	59.52%	0.24%	44.68%
BananaFarm, BoomerangMonkey, IceMonkey	31	19	12	61.29%	0.18%	44.14%
Alchemist, MonkeyAce, MonkeySub	108	57	51	52.78%	0.62%	43.36%
BananaFarm, BombShooter, SniperMonkey	26	16	10	61.54%	0.15%	42.84%
Alchemist, MonkeyBuccaneer, SpikeFactory	379	180	199	47.49%	2.18%	42.47%
DartMonkey, SpikeFactory, WizardMonkey	27	16	11	59.26%	0.16%	40.73%
BananaFarm, BoomerangMonkey, EngineerMonkey	33	19	14	57.58%	0.19%	40.71%
BananaFarm, SniperMonkey, WizardMonkey	144	70	74	48.61%	0.83%	40.45%
HeliPilot, IceMonkey, NinjaMonkey	36	20	16	55.56%	0.21%	39.32%
BoomerangMonkey, MortarMonkey, SpikeFactory	51	27	24	52.94%	0.29%	39.24%
BananaFarm, BoomerangMonkey, SpikeFactory	133	62	71	46.62%	0.76%	38.14%
BananaFarm, DartlingGunner, MonkeySub	57	29	28	50.88%	0.33%	37.90%
Alchemist, MonkeyAce, SniperMonkey	46	24	22	52.17%	0.26%	37.74%
DartlingGunner, MonkeyBuccaneer, SniperMonkey	40	21	19	52.50%	0.23%	37.02%
MonkeyAce, SniperMonkey, SpikeFactory	47	24	23	51.06%	0.27%	36.77%
MonkeyBuccaneer, SniperMonkey, WizardMonkey	99	46	53	46.46%	0.57%	36.64%
GlueGunner, MonkeyBuccaneer, SniperMonkey	36	19	17	52.78%	0.21%	36.47%
BananaFarm, NinjaMonkey, WizardMonkey	43	22	21	51.16%	0.25%	36.22%
BananaFarm, MonkeyAce, WizardMonkey	32	17	15	53.13%	0.18%	35.83%
DartMonkey, SniperMonkey, SpikeFactory	46	23	23	50.00%	0.26%	35.55%
SniperMonkey, SpikeFactory, WizardMonkey	65	31	34	47.69%	0.37%	35.55%
Alchemist, MonkeyAce, MonkeyVillage	26	14	12	53.85%	0.15%	34.68%
BananaFarm, DartMonkey, DartlingGunner	52	25	27	48.08%	0.30%	34.50%

Advanced export

JSON shape: default, array, newline-delimited

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

basalt_columns_loadouts (view)

106 rows

Advanced export