Game History
Round: 1 Purchase Units - Italians Italians buy 1 fighter; Remaining resources: 0 PUs; Combat Move - Italians 1 infantry moved from Ethiopia to Anglo Egyptian Sudan Italians take Anglo Egyptian Sudan from British 1 infantry moved from Italian Somaliland to Kenya Italians take Kenya from British 1 bomber moved from Northern Italy to United Kingdom 1 submarine moved from 95 Sea Zone to 96 Sea Zone 2 fighters moved from Southern Italy to 96 Sea Zone 1 armour and 1 mech_infantry moved from Tobruk to Tunisia 1 artillery and 1 infantry moved from Libya to Tunisia 1 transport moved from 95 Sea Zone to 97 Sea Zone 3 infantry moved from Southern Italy to 97 Sea Zone 1 artillery moved from Northern Italy to 97 Sea Zone 1 armour, 1 artillery and 2 infantry moved from Northern Italy to Southern France 1 cruiser moved from 95 Sea Zone to 97 Sea Zone 3 infantry moved from 97 Sea Zone to Greece 1 artillery moved from 97 Sea Zone to Greece 1 armour and 2 infantry moved from Albania to Greece Combat - Italians Air Battle in United Kingdom Italians attacks with 1 units heading to United Kingdom Air Battle is over, the remaining bombers go on to their targets Strategic bombing raid in United Kingdom Bombing raid in United Kingdom rolls: 7 and causes: 7 damage to unit: factory_major Bombing raid in United Kingdom causes 7 damage total. Battle in Greece Italians attack with 1 armour, 1 artillery and 5 infantry Neutral_Allies defend with 4 infantry Italians win, taking Greece from Neutral_Allies with 1 armour, 1 artillery and 3 infantry remaining. Battle score for attacker is 6 Casualties for Italians: 2 infantry Casualties for Neutral_Allies: 4 infantry Battle in 96 Sea Zone Italians attack with 2 fighters and 1 submarine British defend with 1 destroyer Italians win with 2 fighters and 1 submarine remaining. Battle score for attacker is 8 Casualties for British: 1 destroyer Battle in Tunisia Italians attack with 1 armour, 1 artillery, 1 infantry and 1 mech_infantry French defend with 1 infantry Italians win, taking Tunisia from French with 1 armour, 1 artillery, 1 infantry and 1 mech_infantry remaining. Battle score for attacker is 3 Casualties for French: 1 infantry Battle in Southern France Italians attack with 1 armour, 1 artillery and 2 infantry French defend with 1 artillery, 1 factory_minor, 1 harbour and 1 infantry Italians win, taking Southern France from French with 1 armour, 1 artillery and 1 infantry remaining. Battle score for attacker is 4 Casualties for Italians: 1 infantry Casualties for French: 1 artillery and 1 infantry Cleaning up after air battles Non Combat Move - Italians 1 aaGun moved from Northern Italy to Southern France 1 aaGun moved from Northern Italy to Southern Italy 2 fighters moved from 96 Sea Zone to Southern Italy 1 artillery and 1 infantry moved from Ethiopia to Kenya 1 destroyer moved from 95 Sea Zone to 97 Sea Zone 1 bomber moved from United Kingdom to Holland Belgium Place Units - Italians 1 fighter placed in Southern Italy Turn Complete - Italians Total Cost from Convoy Blockades: 2 Rolling for Convoy Blockade Damage in 93 Sea Zone. Rolls: 4,2 Rolling for Convoy Blockade Damage in 72 Sea Zone. Rolls: 6 Italians collect 16 PUs (2 lost to blockades); end with 16 PUsThe new ELO-based ranking system
-
Is there a list of all the calculated ELO rankings?
-
-
Good morning,
I have a technical question: When I download the ELO table to my PC and open it in Excel, all players have an ELO of 1500. Is there anything I have to pay attention to in order to have the real ELO shown?
Thank you very much in advance for your help!
-
MrRoboto is probably the only one who can help you,
He’ll most likely see your post in this thread, but now that you know who you need, you could PM him if he doesn’t respond here soon -
Pretty sure the formulas in Excel are ever so slightly different from the formulas in Google sheets.
Gonna download it on my work computer tomorrow, since I don’t have an excel license on my personal one.
-
Ok two major formulas didnt translate properly from google sheets to excel and it seemed to work after fixing both of them.
First, check the “Data” Sheet, column G
In Google Sheets, the formula is:
=IF(ISBLANK(F2),IF(EQ(F2,D2),E2,D2))In Excel, I had to rewrite it slightly to:
=IF(ISBLANK(F2),IF(F2=D2),E2,D2))And of course you have to extend the formula to the whole column.
I have the German Excel version and it failed to translate the formula in the (hidden) column B.
Google Sheets formula:
=IF(ISBlANK($A2),IFS($A2=“OOB”,1,$A2=“BM4”,2,$A2=“PtV”,3))Wrong translated Excel formula:
=WENN(ISTLEER($A2),IFS($A2=“OOB”,1,$A2=“BM4”,2,$A2=“PtV”,3))As you can see, it translated the “IF” and the “ISBLANK”, but not the “IFS”.
I suspect you don’t have that problem.You might have other issues though. Just check the cells and see if they are doing what you’d expect them to.
-
Fantastic - thank you very much for your quick help! It now works for me in Excel as well. I replaced the formula in cell [G2] by =IF(F2=D2;E2;D2) and applied it to the whole column.
I also did some small adjustment in cell [B2] and applied it to the whole column B. If I remember correctly, there is a “@” added to formulas in the new Excel version, and it does not seem to work for me, so I just deleted the “@”
Thank you again!
-
-
F FlyingBadger referenced this topic on