Game History
Round: 3 Purchase Units - Japanese Japanese buy 1 carrier, 1 destroyer, 4 infantry, 1 submarine and 1 transport; Remaining resources: 0 PUs; 6 SuicideAttackTokens; Combat Move - Japanese Non Combat Move - Japanese 1 artillery moved from Yunnan to Kwangsi 2 artilleries and 4 infantry moved from Hunan to Kwangsi 2 artilleries and 2 infantry moved from Kwangsi to 37 Sea Zone 2 artilleries, 2 infantry and 6 transports moved from 37 Sea Zone to 132 Sea Zone 1 artillery moved from Japan to 7 Sea Zone 1 infantry moved from Iwo Jima to 7 Sea Zone 1 artillery, 1 carrier, 1 destroyer, 1 infantry and 1 transport moved from 7 Sea Zone to 36 Sea Zone 1 marine moved from Kwangsi to 37 Sea Zone 1 battleship, 1 cruiser, 1 marine and 1 submarine moved from 37 Sea Zone to 36 Sea Zone 1 fighter and 1 tactical_bomber moved from Fukien to 36 Sea Zone 1 armour moved from Kwangsi to Kiangsi 1 destroyer moved from 37 Sea Zone to 132 Sea Zone Place Units - Japanese 1 carrier, 1 destroyer, 1 submarine and 1 transport placed in 7 Sea Zone 4 infantry placed in Japan Turning on Edit Mode EDIT: Removing units owned by Japanese from 21 Sea Zone: 1 transport EDIT: Adding units owned by Japanese to 7 Sea Zone: 1 transport EDIT: Turning off Edit Mode Turn Complete - Japanese Japanese collect 37 PUs; end with 37 PUs Objective Japanese 1 Trade With America: Japanese met a national objective for an additional 10 PUs; end with 47 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!
-
S simon33 referenced this topic on
-
F FlyingBadger referenced this topic on
Suggested Topics
