s24+_matches: bloon_bot_factory

72 rows

descending

Loadout	Games	Wins	Losses	Winrate	Pickrate	WinRate_LowerBound_95CI
BombShooter, MortarMonkey, SuperMonkey	314	244	70	77.71%	2.04%	73.10%
DartlingGunner, MonkeyVillage, SuperMonkey	198	146	52	73.74%	1.28%	67.61%
MonkeyBuccaneer, MortarMonkey, TackShooter	358	250	108	69.83%	2.32%	65.08%
GlueGunner, HeliPilot, MortarMonkey	2171	1366	805	62.92%	14.08%	60.89%
HeliPilot, MortarMonkey, TackShooter	140	92	48	65.71%	0.91%	57.85%
Alchemist, HeliPilot, MortarMonkey	1171	697	474	59.52%	7.59%	56.71%
Alchemist, MonkeyAce, MortarMonkey	144	90	54	62.50%	0.93%	54.59%
BananaFarm, EngineerMonkey, MortarMonkey	68	44	24	64.71%	0.44%	53.35%
SniperMonkey, SuperMonkey, TackShooter	50	33	17	66.00%	0.32%	52.87%
HeliPilot, MonkeyVillage, MortarMonkey	276	154	122	55.80%	1.79%	49.94%
MonkeyAce, MortarMonkey, TackShooter	49	31	18	63.27%	0.32%	49.77%
BananaFarm, HeliPilot, MortarMonkey	345	183	162	53.04%	2.24%	47.78%
HeliPilot, MonkeyBuccaneer, MortarMonkey	1176	594	582	50.51%	7.63%	47.65%
HeliPilot, MonkeyAce, MortarMonkey	734	369	365	50.27%	4.76%	46.66%
HeliPilot, MortarMonkey, SuperMonkey	162	88	74	54.32%	1.05%	46.65%
GlueGunner, HeliPilot, MonkeyVillage	122	67	55	54.92%	0.79%	46.09%
MonkeyAce, MonkeyBuccaneer, MortarMonkey	624	310	314	49.68%	4.05%	45.76%
MonkeyBuccaneer, MortarMonkey, SniperMonkey	126	65	61	51.59%	0.82%	42.86%
MonkeyBuccaneer, MonkeySub, MortarMonkey	28	17	11	60.71%	0.18%	42.62%
HeliPilot, MortarMonkey, SniperMonkey	176	88	88	50.00%	1.14%	42.61%
BananaFarm, MortarMonkey, SniperMonkey	32	19	13	59.38%	0.21%	42.36%
BananaFarm, EngineerMonkey, MonkeyAce	38	22	16	57.89%	0.25%	42.20%
BombShooter, HeliPilot, MortarMonkey	65	35	30	53.85%	0.42%	41.73%
BananaFarm, SniperMonkey, WizardMonkey	70	37	33	52.86%	0.45%	41.16%
GlueGunner, MonkeyBuccaneer, MortarMonkey	52	28	24	53.85%	0.34%	40.30%
HeliPilot, MortarMonkey, SpikeFactory	125	61	64	48.80%	0.81%	40.04%
BananaFarm, MortarMonkey, TackShooter	53	28	25	52.83%	0.34%	39.39%
HeliPilot, MonkeySub, MortarMonkey	291	130	161	44.67%	1.89%	38.96%
BananaFarm, MonkeyBuccaneer, MortarMonkey	94	46	48	48.94%	0.61%	38.83%
EngineerMonkey, MonkeyAce, MortarMonkey	46	24	22	52.17%	0.30%	37.74%
HeliPilot, MonkeyAce, SniperMonkey	260	113	147	43.46%	1.69%	37.44%
MonkeyAce, MonkeySub, MortarMonkey	100	47	53	47.00%	0.65%	37.22%
EngineerMonkey, HeliPilot, MortarMonkey	98	46	52	46.94%	0.64%	37.06%
BananaFarm, MonkeyAce, MortarMonkey	222	96	126	43.24%	1.44%	36.73%
MonkeyBuccaneer, MortarMonkey, SpikeFactory	34	18	16	52.94%	0.22%	36.16%
HeliPilot, MonkeyBuccaneer, SniperMonkey	176	75	101	42.61%	1.14%	35.31%
DartlingGunner, HeliPilot, SniperMonkey	28	15	13	53.57%	0.18%	35.10%
HeliPilot, SniperMonkey, WizardMonkey	42	21	21	50.00%	0.27%	34.88%
BananaFarm, MonkeySub, SniperMonkey	35	18	17	51.43%	0.23%	34.87%
GlueGunner, MonkeyAce, MortarMonkey	64	30	34	46.88%	0.41%	34.65%
BombShooter, MortarMonkey, SpikeFactory	24	13	11	54.17%	0.16%	34.23%
MonkeyAce, MortarMonkey, SniperMonkey	129	55	74	42.64%	0.84%	34.10%
MonkeyAce, MonkeyBuccaneer, SniperMonkey	185	75	110	40.54%	1.20%	33.47%
MonkeyBuccaneer, SniperMonkey, TackShooter	43	20	23	46.51%	0.28%	31.60%
GlueGunner, HeliPilot, SniperMonkey	21	11	10	52.38%	0.14%	31.02%
MonkeyAce, MortarMonkey, SpikeFactory	52	23	29	44.23%	0.34%	30.73%
MonkeySub, MortarMonkey, SniperMonkey	30	14	16	46.67%	0.19%	28.81%
HeliPilot, MonkeyAce, MonkeyBuccaneer	68	27	41	39.71%	0.44%	28.08%
DartlingGunner, MonkeyBuccaneer, TackShooter	28	13	15	46.43%	0.18%	27.96%
MonkeyBuccaneer, SniperMonkey, WizardMonkey	37	16	21	43.24%	0.24%	27.28%

Advanced export

JSON shape: default, array, newline-delimited

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

bloon_bot_factory_loadouts (view)

72 rows

Advanced export