GOTM score calculation

[Ali Ardavan]

Starting with GOTM 93 a new formula is being used for GOTM socre calculation. The formula and the excel calculator on the website at http://www.civfanatics.com/civ2/gotm/rules are both for scores up to GOTM 89.

Magic, could you please tell us how the new scores are calculated?

 

[Magic_gorter]

As far as I know the same formula is used. When using the original file the max number of turns were not always calculated correctly (e.g. special maps) so when taking over the organisation of the GOTM games I decided to made a new spreadsheat file. I've added an example file.

Everytime I look at the results I first find out the max number of turns (with cheat menu->set game year). This is the only way to be sure if the max number of turns is correct.

The file a made is also easier for me to find out who scored best. Otherwise I had to write all the scores somewhere again to find out how everybody performed.

 

[Inkerman]

Part of the background to this I believe is a question in the GoTM 121 Spoiler thread about whether to end the game or not. It assumes the player has the time, energy and interest to continue but doesn't want to decrease the GotM score by playing on.

Like others I am afraid I cannot handle Excel macros.

Google does have a helpful calculator however. One types the sum in the search bar and presses enter.

It could be, if I have understood things correctly, that typing this -

2222*(50**(2/470)-1))

replace 2222 with your current score as shown by F9
replace 470 with the maximum number of turns for this particular game

will tell what you need to be adding next turn to improve your score.

As mentioned in the spoiler, if you are increasing by 2% you are doing fine at any difficulty level. At King the threshold is 1.67%

 

[Ali Ardavan]

I was one the impression that the scoring system changed partly because the old scores were in the hundreds and the new ones in hundreds of thousands. Looking at the excel file Magic provided I realize now that the calculation formula is the same. The reported number are also in the hundreds as before. My guess is that Magic is displaying the score to 3 digits after the decimal as reported by Excel. The fact that . is used for the decimal in the USA and , in Europe made me think that 329,272 is three hundred twenty nine thousand ... where in fact it is three hundred twenty nine point ...

The old spread sheet had problems calculating the end turn when a space ship was launched. How do you deal with that, Magic?

 

[Major Advantage]

I was one the impression that the scoring system changed partly because the old scores were in the hundreds and the new ones in hundreds of thousands. Looking at the excel file Magic provided I realize now that the calculation formula is the same. The reported number are also in the hundreds as before. My guess is that Magic is displaying the score to 3 digits after the decimal as reported by Excel. The fact that . is used for the decimal in the USA and , in Europe made me think that 329,272 is three hundred twenty nine thousand ... where in fact it is three hundred twenty nine point ...

That is exactly why I avoid excel whenever I can! It's almost impossible to get it all right when you import any kind of data and one cell will always give you "March-20-1854" or something like that.
I made a small matlab-script to keep track on how my score is developing:

gscore=sqrt(score).*50.^(1-turn/520)
plot(turn,gscore,'-*')

with "turn" being a vector with the turns according to the game-scores in "score".
Am I right we are currently playing with 520 turns max? I was figuring that out from tables with oedo-years I found somewhere deep inside these forums.

 

[Magic_gorter]

I was one the impression that the scoring system changed partly because the old scores were in the hundreds and the new ones in hundreds of thousands. Looking at the excel file Magic provided I realize now that the calculation formula is the same. The reported number are also in the hundreds as before. My guess is that Magic is displaying the score to 3 digits after the decimal as reported by Excel. The fact that . is used for the decimal in the USA and , in Europe made me think that 329,272 is three hundred twenty nine thousand ... where in fact it is three hundred twenty nine point ...

The old spread sheet had problems calculating the end turn when a space ship was launched. How do you deal with that, Magic?

Yes it's still in the hundreds Ali. As you mentioned I use , and use 3 digits after the decimal (as was done by Duke). You could have seen this when looking at the average score (which has no digits).

To find out the right end turn I use the cheat menu and look at the set game year info. When it's a conquest victory I use the info displayed in the set game year box and for spaceship victory I add one turn above the info displayed in the set game year box.

That is exactly why I avoid excel whenever I can! It's almost impossible to get it all right when you import any kind of data and one cell will always give you "March-20-1854" or something like that.
I made a small matlab-script to keep track on how my score is developing:

gscore=sqrt(score).*50.^(1-turn/520)
plot(turn,gscore,'-*')

with "turn" being a vector with the turns according to the game-scores in "score".
Am I right we are currently playing with 520 turns max? I was figuring that out from tables with oedo-years I found somewhere deep inside these forums.

Don't know yet if it's a 520 turn game. I created a special map and will check the max number of turns after finishing the game (when checking the scores for all players).

Because it's a special map I'm not sure if the table you used is correct. The only way to find out (without using the cheatmenu) is looking at the steps in years. Eg. if the game starts with steps of 20 years you know it's a 570 turn game....