e677cdd6-362e-446e-9f1d-496b9ff026ef-Germany - Round 1.tsvg Game History
Round: 1 Purchase Units - Germans Turning on Edit Mode EDIT: Adding units owned by British to Egypt: 1 mech_infantry EDIT: Adding units owned by British to 98 Sea Zone: 1 submarine EDIT: Adding units owned by British to 91 Sea Zone: 1 submarine EDIT: Adding units owned by British to 39 Sea Zone: 1 transport EDIT: Adding units owned by Chinese to Yunnan: 1 infantry EDIT: Adding units owned by Chinese to Kweichow: 1 infantry EDIT: Adding units owned by Russians to Sakha: 1 artillery EDIT: Turning off Edit Mode Turning on Edit Mode EDIT: Adding units owned by British to Alexandria: 1 artillery EDIT: Turning off Edit Mode Germans buy 1 armour and 6 artilleries; Remaining resources: 0 PUs; Combat Move - Germans 1 submarine moved from 117 Sea Zone to 106 Sea Zone 1 submarine moved from 118 Sea Zone to 111 Sea Zone 1 submarine moved from 124 Sea Zone to 111 Sea Zone 1 battleship moved from 113 Sea Zone to 111 Sea Zone 1 fighter moved from Norway to 111 Sea Zone 1 tactical_bomber moved from Western Germany to 111 Sea Zone 1 bomber moved from Germany to 111 Sea Zone 1 fighter moved from Holland Belgium to 110 Sea Zone 2 tactical_bombers moved from Western Germany to 110 Sea Zone 2 fighters moved from Western Germany to 110 Sea Zone 1 bomber moved from Germany to 110 Sea Zone 1 submarine moved from 103 Sea Zone to 110 Sea Zone 1 submarine moved from 108 Sea Zone to 110 Sea Zone 1 artillery and 2 infantry moved from Holland Belgium to Normandy Bordeaux 3 armour, 1 artillery and 2 infantry moved from Holland Belgium to France 1 artillery, 3 infantry and 4 mech_infantrys moved from Western Germany to France 3 armour moved from Greater Southern Germany to France 1 tactical_bomber moved from Poland to France 1 fighter moved from Slovakia Hungary to France 1 tactical_bomber moved from Germany to 110 Sea Zone 2 artilleries and 6 infantry moved from Greater Southern Germany to Yugoslavia 1 armour and 1 infantry moved from Romania to Yugoslavia 1 armour and 2 infantry moved from Slovakia Hungary to Yugoslavia 1 armour moved from Poland to Yugoslavia Combat - Germans Battle in 106 Sea Zone Germans attack with 1 submarine British defend with 1 destroyer and 1 transport Germans win, taking 106 Sea Zone from Neutral with 1 submarine remaining. Battle score for attacker is 15 Casualties for British: 1 destroyer and 1 transport Battle in 110 Sea Zone Germans attack with 1 bomber, 3 fighters, 2 submarines and 3 tactical_bombers British defend with 1 battleship and 1 cruiser; French defend with 1 cruiser Germans win with 1 bomber, 3 fighters and 3 tactical_bombers remaining. Battle score for attacker is 32 Casualties for Germans: 2 submarines Casualties for French: 1 cruiser Casualties for British: 1 battleship and 1 cruiser Battle in 111 Sea Zone Germans attack with 1 battleship, 1 bomber, 1 fighter, 2 submarines and 1 tactical_bomber British defend with 1 battleship, 1 cruiser and 1 destroyer Units damaged: 1 battleship owned by the British Units damaged: 1 battleship owned by the Germans Germans win with 1 battleship and 1 bomber remaining. Battle score for attacker is 7 Casualties for Germans: 1 fighter, 2 submarines and 1 tactical_bomber Casualties for British: 1 battleship, 1 cruiser and 1 destroyer Battle in France Germans attack with 6 armour, 2 artilleries, 1 fighter, 5 infantry, 4 mech_infantrys and 1 tactical_bomber British defend with 1 armour and 1 artillery; French defend with 1 aaGun, 1 airfield, 1 armour, 1 artillery, 1 factory_major, 1 fighter and 6 infantry Germans captures 19PUs while taking French capital Germans converts factory_major into different units Germans win, taking France from French with 6 armour and 1 tactical_bomber remaining. Battle score for attacker is 4 Casualties for Germans: 2 artilleries, 1 fighter, 5 infantry and 4 mech_infantrys Casualties for French: 1 aaGun, 1 armour, 1 artillery, 1 fighter and 6 infantry Casualties for British: 1 armour and 1 artillery Battle in Normandy Bordeaux Germans attack with 1 artillery and 2 infantry French defend with 1 artillery, 1 factory_minor, 1 harbour and 1 infantry Germans win, taking Normandy Bordeaux from French with 1 artillery and 1 infantry remaining. Battle score for attacker is 4 Casualties for French: 1 artillery and 1 infantry Casualties for Germans: 1 infantry Battle in Yugoslavia Germans attack with 3 armour, 2 artilleries and 9 infantry Neutral_Allies defend with 5 infantry Germans win, taking Yugoslavia from Neutral_Allies with 3 armour, 2 artilleries and 8 infantry remaining. Battle score for attacker is 12 Casualties for Germans: 1 infantry Casualties for Neutral_Allies: 5 infantry Trigger Germans Conquer France: Setting switch to true for conditionAttachment_French_1_Liberation_Switch attached to French Non Combat Move - Germans 1 bomber, 2 fighters and 2 tactical_bombers moved from 110 Sea Zone to Western Germany 1 aaGun moved from Western Germany to Holland Belgium 1 tactical_bomber moved from France to Western Germany 1 fighter and 1 tactical_bomber moved from 110 Sea Zone to Holland Belgium 1 bomber moved from 111 Sea Zone to Western Germany 1 infantry moved from Germany to Western Germany 1 infantry moved from Norway to Finland Germans take Finland from Neutral_Axis 1 artillery moved from Germany to 114 Sea Zone 1 infantry moved from Germany to 114 Sea Zone 1 artillery, 1 cruiser, 1 infantry and 1 transport moved from 114 Sea Zone to 113 Sea Zone 1 artillery and 1 infantry moved from 113 Sea Zone to Norway 2 infantry moved from Norway to Finland 1 aaGun moved from Germany to Slovakia Hungary 1 aaGun moved from Germany to Poland 1 aaGun moved from Germany to Poland 1 artillery and 7 infantry moved from Germany to Slovakia Hungary 1 artillery and 2 infantry moved from Germany to Poland 1 infantry moved from Romania to Bulgaria Germans take Bulgaria from Neutral_Axis Place Units - Germans 6 artilleries placed in Germany 1 armour placed in Western Germany Turn Complete - Germans Germans collect 41 PUs; end with 60 PUs Trigger Germans 5 Swedish Iron Ore: Germans met a national objective for an additional 5 PUs; end with 65 PUs Objective Germans 1 Trade with Russia: Germans met a national objective for an additional 5 PUs; end with 70 PUsThe new ELO-based ranking system
-
@gamerman01 said in Proposal for a new, ELO-based, ranking system:
If 6 remains the minimum for qualifying (BM), then conceivably someone could inflate their score by playing several or all of their games against the unknowns (newcomers).
True, but those players would also take a risk: After all, the newcomer could be a secret god in disguise and then they would lose a lot of points against a 1500.
It’s far from a sure way to game the system and I also doubt that we have players who choose their opponents this strategically to maximize their ranking
-
@MrRoboto Have been meaning to say something about the white, and I’ll go ahead and say it on the board -
I really prefer the colors on everyone who’s “active” so the tier for each is clear. The white is difficult to distinguish from the grey.
I know you’ll think of a different way to show a player hasn’t finished 6 yet. Ready, set, Go!
-
@MrRoboto I’m not worried that it will fail to capture the exceptional case. Its just that I’d like the system to ensure that players (new or otherwise) make the playoffs in a given year based on their performance in that year with little influence from games played in prior years. Another example would be if players starting a year with a 1500 ELO, a 1800 ELO and a 2100 ELO all have the same record in that year, I expect we are often going to still see a difference in their ELO at the end even though the lower ranked players have closed some of the gap. With enough games, that difference should more or less disappear but I’m worried that it will be more than the 6 games needed for entry into the playoffs.
But again, happy to give it a try and see how it works. And I do really like this ELO for a bunch of other reasons that your work has illustrated.
-
I don’t know the term in English but you can include “Zahlenformat (?) in die bedingte Formatierung” so that in cells (of the column with players’ names) that are colored white they also display something like “less than three games so far” behind the name
-
@pacifiersboard said in Proposal for a new, ELO-based, ranking system:
I don’t know the term in English but you can include “Zahlenformat (?) in die bedingte Formatierung” so that in cells (of the column with players’ names) that are colored white they also display something like “less than three games so far” behind the name
Are you sure? Maybe Excel can do that, but I don’t see that option in Google Sheets…
-
How do you like it this way?

That way everyone can see the lifetime-ranking and also the playoff-spot
-
I still can’t access the spreadsheet directly and use things like the search and filter function, or put new data in directly. I can just see it as another page in chrome (so no google sheets interface either) and nothing tells me that I don’t have permission or that it is read only. I’ve tried going into google sheets and then loading the page but can’t find it.
Two questions. If others are able to access it, how? If others aren’t, is there something that @MrRoboto needs to do to open up access.
I usually use office, not google for documents and spreadsheets, so might just not be familiar enough.
-
-
@MrRoboto that does work! Thanks!
-
@MrRoboto said in Proposal for a new, ELO-based, ranking system:
How do you like it this way?
That way everyone can see the lifetime-ranking and also the playoff-spot
Yes, perfect, tier colors across and also formulaed rankings for 6+ games. I said ready, set, go because I had confidence you would make the solution quickly! 💯
-
@MrRoboto
Why are the ELO ranking levels different for the different versions? Is that intentional based on some mathematical spread?



-
I was playing around with the exact numbers and apparently didn’t settle on the same number across different versions.
Tiers have no actual meaning and are just a visual cue.
And they add motivation, I think.I will discuss final numbers with gamerman later, probably after entering more of the historical results.
Huge thanks btw to @mr_stucifer and @farmboy who provided all of the data before 2023.
As of right now, we have everything from 01-01-2019 until now! -
@MrRoboto Mr. Roboto, this is excellent work! It’s actually quite perfect timing, I created my own spreadsheet a few days ago for Revised players on TripleA. The one thing I can’t seem to wrap my head around is setting an ELO and then updating it without creating a circular reference. If you could help this I would be eternally grateful! My spreadsheet is here: https://bit.ly/revisedstats
Thanks!
-
The dwarves are digging deep, all the way to 9/30/17 so far…
Watch as the life-time ELO rankings take shape…
Or wait until all is entered and edit checks done -
I just saw that your post was queued for approval, and approved it
-
@gamerman01 Thank you
-
From the first page:
“A win by the current #1 against the current last place will award only meager 4 points for the winner and -2 for the loser.
However, the last player would receive a whopping 136 for a win and #1 would suffer -87 for that loss!”Maybe this has been adressed before and. I am just curious why this is fair.
In chess, the winner and the loser gain/lose the same number of points whereas here the winner always gain more than the loser lose. Why is it this way? This means that everyones rating will increase over time given the number of players are constant? How is this fair to new players?
I am sure I am missing something!
-
I say everyones rating will increase. I mean “everyone” or most player.
-
The loser’s ELO drops more than the winner’s gains if the winner’s ELO is higher than the loser’s
I think you can access the “results” tab
Type in a player’s name in the yellow box and I think you’ll be able to seeIt’ll be more efficient if @MrRoboto answers the rest
-
We have 4489 games finished now.
The Average rating is 1486,77
The Median rating is 1459.So as you can see, everyones rating hasn’t increased and a brand new player with 0-0 is even better than average ;-)





