FvA Opening Database

Use this forum to discuss Diplomacy strategy.
Forum rules
This forum is limited to topics relating to the game Diplomacy only. Other posts or topics will be relocated to the correct forum category or deleted. Please be respectful and follow our normal site rules at http://www.webdiplomacy.net/rules.php.
Post Reply
Message
Author
RoganJosh
Silver Donator
Silver Donator
Posts: 556
Joined: Sun Dec 31, 2017 1:02 am
Location: Stockholm
Karma: 464
Contact:

FvA Opening Database

#1 Post by RoganJosh » Fri Nov 06, 2020 3:34 pm

I was convinced that I should learn some Tableau. So I put together an opening database for FvA:

https://public.tableau.com/profile/jens ... ublish=yes

It stops at builds 1901. For two reasons: 1) even for the most common combinations of openings, there are just too few games to make any statistical analysis past 01, and 2) I fear the Tableau format isn't malleable enough to push it further. It's fancy and all, but it's not built for this.

What are the takeaways? For inexperienced players, just looking at what orders are played the most will help you avoid most mistakes in 1901. For more experienced players, I'd guess the approx. payoff matrices for the builds in 1901 will be the most interesting.

Let me know if there are any improvements you'd like to see. I'm not promising anything, but I might fancy a challange.
8

jasnah
Posts: 507
Joined: Tue Jun 02, 2020 8:13 pm
Karma: 308
Contact:

Re: FvA Opening Database

#2 Post by jasnah » Fri Nov 06, 2020 3:44 pm

Omg, fantastic. I've really wanted to see something like this for a while - great work and thanks for putting it together!

jasnah
Posts: 507
Joined: Tue Jun 02, 2020 8:13 pm
Karma: 308
Contact:

Re: FvA Opening Database

#3 Post by jasnah » Fri Nov 06, 2020 3:51 pm

I think there is a slight error on the Winter 1901 page. The description on the left says that stats are given in the order:

n games
Austria's mean score
France's mean score

But in the actual table, France's score is listed above Austria's.

User avatar
DougJoe
Posts: 897
Joined: Thu Aug 15, 2019 9:02 pm
Location: Alto, MI, USA
Karma: 208
Contact:

Re: FvA Opening Database

#4 Post by DougJoe » Fri Nov 06, 2020 4:06 pm

This is really cool. How did you pull the moves from so many games? Did you get a dump from the DB or something like that?

RoganJosh
Silver Donator
Silver Donator
Posts: 556
Joined: Sun Dec 31, 2017 1:02 am
Location: Stockholm
Karma: 464
Contact:

Re: FvA Opening Database

#5 Post by RoganJosh » Fri Nov 06, 2020 4:20 pm

jasnah wrote:
Fri Nov 06, 2020 3:51 pm
I think there is a slight error on the Winter 1901 page.
Thanks, fixed it, and added colors.
DougJoe wrote:
Fri Nov 06, 2020 4:06 pm
Did you get a dump from the DB or something like that?
I was convinced that I should learn some BeautifulSoup...
2

President Eden
Posts: 6907
Joined: Fri Oct 20, 2017 2:11 pm
Location: possibly Britain
Karma: 9609
Contact:

Re: FvA Opening Database

#6 Post by President Eden » Fri Nov 06, 2020 4:23 pm

Based on taking the highest average score for each moves, the "best openings" appear to be:

Austria:
A Vie -> Tyl
A Bud -> Tri
F Gre -> Alb

France:
A Par -> Pic
A Mar -> Bur
F Bre -> ENG -or- MAO

Interesting note: Despite the difference between ENG/MAO being negligible in average score [~0.001], moving to ENG while also moving to Pic/Bur increases average score by 0.018. This suggests to me that while the difference in abstract power level between ENG/MAO is essentially zero, moving to ENG synergizes better with moving to Pic/Bur. This makes sense to me because moving the fleet north allows it to influence the fight over Germany that those armies will conduct in 1902-04.

jasnah
Posts: 507
Joined: Tue Jun 02, 2020 8:13 pm
Karma: 308
Contact:

Re: FvA Opening Database

#7 Post by jasnah » Fri Nov 06, 2020 4:33 pm

President Eden wrote:
Fri Nov 06, 2020 4:23 pm
Based on taking the highest average score for each moves, the "best openings" appear to be:

Austria:
A Vie -> Tyl
A Bud -> Tri
F Gre -> Alb

France:
A Par -> Pic
A Mar -> Bur
F Bre -> ENG -or- MAO

Interesting note: Despite the difference between ENG/MAO being negligible in average score [~0.001], moving to ENG while also moving to Pic/Bur increases average score by 0.018. This suggests to me that while the difference in abstract power level between ENG/MAO is essentially zero, moving to ENG synergizes better with moving to Pic/Bur. This makes sense to me because moving the fleet north allows it to influence the fight over Germany that those armies will conduct in 1902-04.
While it's certainly interesting to note these stats I wouldn't put very much stock into a bald evaluation of opening strength. Most people I think, consider the openings to be a rock-paper-scissors where Vie-Tyr Bud-Tri Tri-Alb beats Par-Pic Mar-Bur Bre-ENG beats Vie-Tyr Bud-Gal Tri-Ven beats Par-Bur Mar-Pie Bre-MAO beats again the first opening, and so on, with no dominant combination. This is reflected in the stats and the handicap from losing the rock-paper-scissors can be pretty large.

Anecdotally I also would speculate that the Italian (Vie-Tyr Bud-Tri Tri-Alb) is played disproportionately by more experienced players compared to other openings and this is partly related to its historical success.
3

User avatar
DougJoe
Posts: 897
Joined: Thu Aug 15, 2019 9:02 pm
Location: Alto, MI, USA
Karma: 208
Contact:

Re: FvA Opening Database

#8 Post by DougJoe » Fri Nov 06, 2020 7:31 pm

RoganJosh wrote:
Fri Nov 06, 2020 4:20 pm

DougJoe wrote:
Fri Nov 06, 2020 4:06 pm
Did you get a dump from the DB or something like that?
I was convinced that I should learn some BeautifulSoup...
I had to lookup what BeautifulSoup is, but I get it now. Pretty cool.

Squigs44
Developer
Developer
Posts: 4003
Joined: Thu Jul 12, 2018 11:50 pm
Location: OKC
Karma: 2010
Contact:

Re: FvA Opening Database

#9 Post by Squigs44 » Fri Nov 06, 2020 8:13 pm

RoganJosh wrote:
Fri Nov 06, 2020 4:20 pm
jasnah wrote:
Fri Nov 06, 2020 3:51 pm
I think there is a slight error on the Winter 1901 page.
Thanks, fixed it, and added colors.
DougJoe wrote:
Fri Nov 06, 2020 4:06 pm
Did you get a dump from the DB or something like that?
I was convinced that I should learn some BeautifulSoup...
Beautiful Soup is a wonderful tool. Tableau as well. Nice work

teccles
Posts: 237
Joined: Mon Mar 25, 2019 8:10 pm
Karma: 285
Contact:

Re: FvA Opening Database

#10 Post by teccles » Fri Nov 06, 2020 9:46 pm

This is amazing.

Peregrine Falcon
Site Contributor
Site Contributor
Posts: 245
Joined: Tue Mar 14, 2017 8:44 pm
Karma: 310
Contact:

Re: FvA Opening Database

#11 Post by Peregrine Falcon » Fri Nov 06, 2020 11:35 pm

RoganJosh wrote:
Fri Nov 06, 2020 4:20 pm
jasnah wrote:
Fri Nov 06, 2020 3:51 pm
I think there is a slight error on the Winter 1901 page.
Thanks, fixed it, and added colors.
DougJoe wrote:
Fri Nov 06, 2020 4:06 pm
Did you get a dump from the DB or something like that?
I was convinced that I should learn some BeautifulSoup...
This is excellent. Thanks for putting it together!

I had actually been thinking of doing some similar analyses, but writing a scraper for webDip was a barrier to actually starting it. Would you be willing to publish the code on GitHub or something?

RoganJosh
Silver Donator
Silver Donator
Posts: 556
Joined: Sun Dec 31, 2017 1:02 am
Location: Stockholm
Karma: 464
Contact:

Re: FvA Opening Database

#12 Post by RoganJosh » Sat Nov 07, 2020 12:59 am

Thanks all!

I don't mind sharing it, but let me check in with our president. I don't know how willing they are to just provide dumps of the database either, this was en exercise for me, so I never asked.
1

RoganJosh
Silver Donator
Silver Donator
Posts: 556
Joined: Sun Dec 31, 2017 1:02 am
Location: Stockholm
Karma: 464
Contact:

Re: FvA Opening Database

#13 Post by RoganJosh » Sat Nov 07, 2020 1:11 am

President Eden wrote:
Fri Nov 06, 2020 4:23 pm
This suggests to me that while the difference in abstract power level between ENG/MAO is essentially zero, moving to ENG synergizes better with moving to Pic/Bur.
One of the informal principles I try to follow, is that you should think of your units like the pawns in a chess game. It's all about the structure. An isolated unit is weak. I think that's why ENG/Pie is weak. The fleet in ENG is definitely isolated. The army in Piedmont can also end up being somewhat isolated, if you're not careful.

The MAO fleet can always get a backup fleet build in Mar.
1

President Eden
Posts: 6907
Joined: Fri Oct 20, 2017 2:11 pm
Location: possibly Britain
Karma: 9609
Contact:

Re: FvA Opening Database

#14 Post by President Eden » Sat Nov 07, 2020 1:21 am

RoganJosh wrote:
Sat Nov 07, 2020 12:59 am
I don't mind sharing it, but let me check in with our president.
You have my permission
RoganJosh wrote:
Sat Nov 07, 2020 1:11 am
President Eden wrote:
Fri Nov 06, 2020 4:23 pm
This suggests to me that while the difference in abstract power level between ENG/MAO is essentially zero, moving to ENG synergizes better with moving to Pic/Bur.
One of the informal principles I try to follow, is that you should think of your units like the pawns in a chess game. It's all about the structure. An isolated unit is weak. I think that's why ENG/Pie is weak. The fleet in ENG is definitely isolated. The army in Piedmont can also end up being somewhat isolated, if you're not careful.

The MAO fleet can always get a backup fleet build in Mar.
Definitely agree. The nature of supports and "tied strength" units not dislodging each other means that you really want to concentrate force and keep your units together. I seem to remember the "northern" opening for France (ENG/Pic/Bur) being considered the best opening, since all three units can fight together to win the battle over Germany. I don't know whether it's true that this opening is the best anymore - it's been a couple years since I looked at the format in detail - but I'm sure its strength comes from concentrating everything on a key front.
2

RoganJosh
Silver Donator
Silver Donator
Posts: 556
Joined: Sun Dec 31, 2017 1:02 am
Location: Stockholm
Karma: 464
Contact:

Re: FvA Opening Database

#15 Post by RoganJosh » Sat Nov 07, 2020 3:07 pm

Another aspect there is predictability. An isolated unit can only move, and is usually stuck with only one or two realistic options (read: easy to predict). Units in a cluster that can support/convoy in different ways can give you a dozen of realistic options (read: almost impossible to predict).

Of course, you also have to rush to Scandinavia and Tunis...

I think the Belgian (ENG/Pic/Bur) is the best, but people where playing it too much. Even if it's the best, playing it every time allows your opponent to optimize their response.
3

Post Reply

Who is online

Users browsing this forum: No registered users and 48 guests