Gotta find yourself a girl as loyal as Alex is to scandiavia.

What about Young Wolf and west africa @plat?

Interesting project.

So if I'm understanding this correctly color-coding for each bonus is relative to other players. When I plug myself in I get a mild green for Scan at 38.9% but a dark green for greenland at 23% and west china at 21.2%. Meanwhile antarctica is a mild orange at 20%.

This would indicate I pick greenland and west china far more than the distribution of players, while picking scan more in raw games?

@Phobos: The colors are based on the value for you picking that bonus (as your first or second pick, when it's not wastelanded) relative to all the other values in the same row in columns C through O (you can check the conditional formatting rule by making a copy of the sheet; it's just a standard Color Scale rule), with yellow hardcoded by _ to be the average pick rate for all players (so if you're close to average, you'll be yellow).

So it's not strictly reliable since, e.g., the Blowfly column has just as much weight in that conditional formatting rule as the "All" column or each rating category. The players you pick in the right-side columns could, for example, make your West China preference look less exceptional if they're all players who, like you, go for West China. The shading itself also breaks down a bit since the color scale is based on max/min values, so if the distribution is low variance (say, the average player picks Bonus X 5% of the time, some pick it 6%, some pick it 4%) slight deviations will get highlighted with dark colors even though they're not really that notable. Thanks to the hardcoding by _, the yellow can be trusted but the dark reds and dark greens can get noisy.

But yeah, that's why your West China preference (21.2% when the average player picks it 7.6% of the time) is more exceptional than your Scandinavia preference (38.9% when the average player picks it 28.9% of the time).

Edited 2/6/2021 04:26:51

Nice work so far! It's pretty cool to see how picking patterns change with time and I'm curious if there are general patterns spanning most players at any given time (and if that changed over the course of the ladder). Also nice to see Blowfly making the chart for highest % picked bonus :P

Looking forward to see what else you have in store!

I added a new tab in the same sheet called counter picking. You can see % of getting certain starting positions and wining rate on them.

Example 1: in 67% of games of players <1500 they got their 1 2 3 picks and won 40% with it, at the same time top 1 players got 1 2 3 picks 40% of the time and won 67% of it. Top players try to counter pick their opponent as a strategy to get early information. I added an extra column so you can see everyone's personal score.


Edited 2/6/2021 18:12:01

I don't see 126 on the sheet? Other than that, great work!

yeah sorry already updated it with the 126.

Edited 2/7/2021 10:27:48

I added a new feature which is game search

You can use this search to see if there are any 2 identical maps but I think it's way more useful to find equivalent maps. You can set yourself relevant information e.g. certain starting positions, wastelands, or bonuses in which a wastelands are or in which aren't (as the exact location of wastelands doesn't always matter). The search requires at this point a manual input so let me show you an example:

Example 1 - easy
1. What do you want to find - was there ever a game where all territories of Antarctica were wastlands?
2. Get territories IDs - South Pole - 128, Siple - 93, Novolazarevskaya - 85, Scott - 20
3. Parse data by separating each value with the dot - 128.93.85.20
4. Insert the value to the column "Strict wastelands"
5. Result - https://www.warzone.com/MultiPlayer?GameID=19066680

Example 2 - find a similar game to the one you are playing
1. What do you want to find - I want to find a game similar to https://www.warzone.com/MultiPlayer?GameID=25622164
2. List all information that you find relevant:
- Bonuses with wastelands - Europ, Indonesia, East Africa, West US,
- Strict start - Sweden, Moscow, Siple
- Bonuses without wastelands (you don't need to list all just the one that you don't want to have them for 100%) - Central Amerika, Scandinavia
3. Get all the ids and format data
- Strickt start - 39.2.93
- Bonuses with wastelands - 4.16.17.9
- Bonuses without wastelands - 6.13
4. Insert the values in the columns
5. Result - 24445695, 16394551. 25352156, 25622164, 21453673

Remember that there might be 0 games matching your filter, that's why it's easier to have relaxed request focusing on bonuses instead of strict territories



Edited 2/12/2021 18:34:44

Incredible.

I added 2 new features: delaying players search, and top delayers

You can use this search to see how often given players are having the last turn in combat. You would expect to have 50% first turns and 50% of the last turns in combat, but since the last turn is usually crucial skilled players are delaying their orders to have it.



You can also go to top delayers and use filters to see different views - go to 'Data' (on the top bar) -> 'Filter views'. If you have any other ideas for the filters let me know.

Top 30 delayers based the on last 500 turns played (rating over 2000+)




Top 30 delayers over all (played over 1000 turns)

I added a new feature - 'first turn analysis' which is an analysis of the first turn if you see an opponent

You can see everyone's results in the sheet, it can be useful next time in a game you see your opponent in right away.

The table presents players with a rating of 2200+ and had more than 30 games in this scenario. You can see that even top players vary in their style:

alhazi- will attack you with 1 army 46% of the time
Beep Beep Im A Jeep - will attack you with 7+ armies 43% of the time
DrApe - if attacks with 7+ armies does it allows in the first move
Equivoque - doesn't do anything and stays still 35% of the time
Jefferspin - defends with 6+ armies but doesn't attack 89% of the time
doca - runs away 26% of the time



Memorable mentions (from all players that played over 30 games in this scenario)

Do not deploy any armies on the connected territory:
88.9% - [NL] Sander
Attack opponent with only 1 (tap):
71% - x
Attack opponent with 2-6 armies:
38.6% - Wiredawg
Attack opponent with 7+ armies:
68.4% - TheThedde
Stayed still with 4 armies:
88.9% - [NL] Sander
Stayed still with 5 armies:
33.7% - Squibbles
Stayed still with 6+ armies:
89.2% - Jeferspin
Runaway:
92.3% - Captain Trip

Edited 2/13/2021 20:27:22

I added a new feature - 'income over time' which is an analysis of average income on each turn

It's pretty interesting as top players have a higher income than average only on turn 3,4 and 5. I see 2 explanations:
1. top players know their early combos (but they don't play first turn compo as it's too easy to counter)
2. top players play against other top players so after few turns they usually meet and focus on taking each other bonuses



Edited 2/14/2021 01:39:21

tbh this thread gave me an insite to beat terry cloth

Edited 2/14/2021 01:24:22

How?

by not picking worse worse places, and knowing what he'd probably pick and taking advantage of that

Just a reminder that all data from this thread can be seen for any player, you just need to go to the sheet and enter a player ID.

Pretty cool that you found it useful! I just checked your data for the income over time and I can see that you really like the first turn bonus and after that, your income grows a little bit slower. You could maybe try to experiment with continuous expansion and second turn bonuses and see how do you like the result of this tactic.



Edited 2/14/2021 02:06:40

I added a new feature - 'territories over time' which is an analogous analysis to the income one

Top-rated players have a higher income than average on turn 3,4,5 but not the number of territories. That can reveal that smart expansion is superior as every army counts in the early game.



Edited 2/14/2021 09:58:38

And the last feature in this series - 'avg controlled armies per turn'

Here we should look closely at the standard deviation e.g. games for +2000 are way closer than games for <1500 players.

Sorry for spamming but I added yet another feature that combines all 3 previous one's territories/income/armies in one

Now you can try to find some patterns between those 3 data points for each turn. E.g.: Timinator might be lower than avg on a number of territories and income in the first few turns but he is a leader in the army's management.



Edited 2/16/2021 11:36:14