Game History
Round: 1 Purchase Units - Japanese Japanese buy 1 infantry and 4 transports; Remaining resources: 0 PUs; 6 SuicideAttackTokens; Combat Move - Japanese 1 infantry moved from Jehol to Chahar Japanese take Chahar from Chinese 1 artillery and 1 infantry moved from Jehol to Shansi 1 fighter, 1 mech_infantry and 1 tactical_bomber moved from Southern Manchuria to Shansi 1 fighter and 1 tactical_bomber moved from Kiangsu to Shansi 1 infantry moved from Shantung to Anhwe Japanese take Anhwe from Chinese 1 infantry moved from Kiangsu to Kiangsi Japanese take Kiangsi from Chinese 1 infantry moved from Kwangsi to Hunan Japanese take Hunan from Chinese 1 infantry moved from Kwangsi to Kweichow Japanese take Kweichow from Chinese 2 artilleries, 1 fighter, 2 infantry and 1 tactical_bomber moved from Kwangsi to Yunnan 2 bombers moved from Japan to Yunnan Combat - Japanese Battle in Shansi Japanese attack with 1 artillery, 2 fighters, 1 infantry, 1 mech_infantry and 2 tactical_bombers Chinese defend with 1 infantry Japanese win, taking Shansi from Chinese with 1 artillery, 2 fighters, 1 infantry, 1 mech_infantry and 2 tactical_bombers remaining. Battle score for attacker is 3 Casualties for Chinese: 1 infantry Battle in Yunnan Japanese attack with 2 artilleries, 2 bombers, 1 fighter, 2 infantry and 1 tactical_bomber Chinese defend with 4 infantry Japanese win, taking Yunnan from Chinese with 2 artilleries, 2 bombers, 1 fighter, 1 infantry and 1 tactical_bomber remaining. Battle score for attacker is 9 Casualties for Chinese: 4 infantry Casualties for Japanese: 1 infantry Non Combat Move - Japanese 1 artillery and 3 infantry moved from Fukien to Kiangsi 1 artillery and 2 infantry moved from Kiangsu to Kiangsi 1 artillery and 1 infantry moved from Shantung to Anhwe 1 marine moved from Caroline Islands to 34 Sea Zone 1 cruiser and 1 marine moved from 34 Sea Zone to 37 Sea Zone 1 artillery and 1 infantry moved from Southern Manchuria to 20 Sea Zone 1 artillery, 1 infantry and 1 transport moved from 20 Sea Zone to 37 Sea Zone 1 infantry moved from Hokkaido to 7 Sea Zone 1 infantry moved from Kyushu to 7 Sea Zone 1 carrier, 2 infantry and 1 transport moved from 7 Sea Zone to 37 Sea Zone 1 artillery, 3 infantry and 1 marine moved from 37 Sea Zone to Kwangsi 1 battleship, 1 destroyer and 1 submarine moved from 20 Sea Zone to 37 Sea Zone 1 cruiser moved from 7 Sea Zone to 34 Sea Zone 1 cruiser moved from 21 Sea Zone to 7 Sea Zone 1 transport moved from 21 Sea Zone to 20 Sea Zone 1 infantry moved from Southern Manchuria to 20 Sea Zone 1 infantry moved from Okinawa to 20 Sea Zone 2 infantry and 1 transport moved from 20 Sea Zone to 21 Sea Zone 2 infantry moved from 21 Sea Zone to Fukien 1 infantry moved from Southern Manchuria to Jehol 3 infantry moved from Korea to Southern Manchuria 1 aaGun and 2 infantry moved from Northern Manchuria to Southern Manchuria 1 fighter moved from Korea to 37 Sea Zone 1 fighter and 1 tactical_bomber moved from Yunnan to Kwangsi 2 bombers moved from Yunnan to Kwangsi 1 fighter moved from Formosa to 37 Sea Zone 1 fighter and 1 tactical_bomber moved from 7 Sea Zone to Kwangsi 2 infantry moved from Japan to Kyushu 2 fighters and 2 tactical_bombers moved from Shansi to Kiangsu Place Units - Japanese 1 infantry placed in Japan 4 transports placed in 7 Sea Zone Turn Complete - Japanese Japanese collect 34 PUs; end with 34 PUs Objective Japanese 1 Trade With America: Japanese met a national objective for an additional 10 PUs; end with 44 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
