22-11-2003 19:12									#1
	Score Charts as of 90 A.D. Help yourself to an AD-FREE life

So I got bored this morning and decided to update my old score charts for the ISDG.

The average scores:

	22-11-2003 19:13									#2
	Put an end to popups!

The turn scores:

	29-01-2004 12:24									#3
	Support Apolyton, buy Call to Power 2

Bump

Arnelos, can we get an update OR can we get a volunteer to take this job over (i.e. get the spreadsheets from Arnie).

E_T

	31-01-2004 18:41									#4
	Support Apolyton, buy Civilization 2

as requested by E_T, average score chart from Turn 121 (where GCA/Poly and GWT/CGN war started) to current turn, Turn 156.

3 years are missing. Consuls did not post the screenshots of the overall scores.

	31-01-2004 18:45									#5
	Full PM-box? Change here!

The next chart is the incremental score.

Incremental Score = Total score of current turn - Total score of previous turn where
Total Score = Average score x Turn #

Observation : GWT incremental score is raising, it's now higher than CGN. Poly's incremental score is raising too.

	01-02-2004 00:42									#6
	Support Apolyton, buy Call to Power 2

quote: Originally posted by rush 3 years are missing. Consuls did not post the screenshots of the overall scores.

I told you the current Consuls suck and are LAZY!

	01-02-2004 01:59									#7
	Put an end to popups!

Trip was supposed to e-mail the shots to another consul, because his upload space was full.

Hmmm, IIRC, I told him to e-mail DanQ about it. THis was before the general announcement about the upload space and after Dans post in the thread about deleteing things in the upload area. So yah, he is lazy and S*cks!

E_T

	01-02-2004 03:02									#8
	Remove this text

I think I have completed charts. Lemme go find my most recent chart and post it here.

rush, which turns are you missing again? I remember having to go hunt down a few missing turns manually by hunting through my e-mail history for the save from miccofl... I'll pass what you need if you let me know which (since I don't remember which turns were the holes).

	01-02-2004 05:15									#9
	Increase the size of your Attachments

Turns 142, 149 and 150 are missing from rush's analysis. You can't tell by looking at his chart?

	01-02-2004 06:21									#10
	Support Apolyton, buy Civilization 2

quote: Originally posted by BigFree Turns 142, 149 and 150 are missing from rush's analysis. You can't tell by looking at his chart?

You are right on the missing turn #s.

	01-02-2004 16:40									#11
	Suffering from ads?

quote: Originally posted by BigFree Turns 142, 149 and 150 are missing from rush's analysis. You can't tell by looking at his chart?

I didn't look very close, I just scanned it.

To be honest, I've been horribly busy the past 2 days. Things should improve by Monday.

That said, now that I look at the chart, you missed Turn 143 and Turn 151.

	01-02-2004 16:47									#12
	Lose 30 kilos (of popups)

Turn 142
GCA: 298
CGN: 590
ACS: 297
CFC: 225
GWT: 512

Turn 143
GCA: 296
CGN: 597
ACS: 300
CFC: 226
GWT: 518

Turn 149
GCA: 288
CGN: 640
ACS: 320
CFC: 236
GWT: 559

Turn 150
GCA: 287
CGN: 647
ACS: 323
CFC: 238
GWT: 566

Turn 151
GCA: 285
CGN: 654
ACS: 327
CFC: 239
GWT: 574

	01-02-2004 17:07									#13
	Increase Your PM Length

Here's the lastest turn-score chart:

	01-02-2004 17:50									#14
	Support Apolyton, pre-order Civilization IV

Hehe, it's nice to see just the effects of just the beginning of our Super REX... I can't wait to see what it will look like when we are done

E_T

	02-02-2004 15:54									#15
	Inflate your Upload Space

NICE graph! Funny to see that GCA is climbing again...

What are those dots?

	02-02-2004 17:15									#16
	Support Apolyton buy from Amazon

quote: Originally posted by BigFurryMonster NICE graph! Funny to see that GCA is climbing again... What are those dots?

GCA is climbing again because they went from one city on our continent to multiple cities on GWT's continent.

The dots are the actual data points... the lines are a polynomial function calculated to at least SOMEWHAT conform to the layout of the data points. Unfortunately, as I've discovered, Excel isn't terribly good at it, but this is as best as I've been able to figure out with Excel.

	02-02-2004 19:39									#17
	Remove this text

Ah - that explains why all curves are going up again - it's Excel's attempt to calculate a polynomial function.

Are the dots the current, average or cumulative scores? Why do they all fluctuate?

	02-02-2004 22:16									#18
	Increase the size of your Attachments

quote: Originally posted by Arnelos That said, now that I look at the chart, you missed Turn 143 and Turn 151.

So is that why rush said " You are right on the missing turn #s."

	03-02-2004 09:37									#19
	Help yourself to an AD-FREE life

quote: Originally posted by BigFurryMonster Ah - that explains why all curves are going up again - it's Excel's attempt to calculate a polynomial function. Are the dots the current, average or cumulative scores? Why do they all fluctuate?

They flucuate because they're reflecting the change in score on each turn multiplied by a number reflective of the previous accumulation of score across the entire game to that point.

So the bouncing in the turnscore chart you see is merely a reflection of the +2 score one turn, +3 score the next (and these are changes in AVERAGE score, not ACTUAL score). The reality is that ACTUAL score is at a point where the increases in the average each turn lies between 2 and 3, but since the increase in the posted average is always a whole number, it's 2 one turn and 3 the next, etc.

That's the reason why I decided to have just the actual posted scores be points on the graph and try to plot a line that reflected where the score probably was really at.

	03-02-2004 10:46									#20
	Support Apolyton, buy Civilization 2

Let me join the crowd and try to explain this too

the average scores that you see on the game screen is average scores round up/down to the nearest whole number. So, if the scores for a player increase by +2 this turn, +3 next turn, it could simply means +2.4 each turn. The first turn is rounded down to +2. But in the 2nd turn, the accumulative decimal (+4.8) results in rounding up to +3.

Arnelos graph attempts to eliminate this fluctuation and smoothens the curve, whereas my chart just display the raw incremental value.

	20-04-2004 07:40									#21
	Turn 172, 560AD score chart Support Apolyton, pre-order Civilization IV

Arnelos is still having problems uploading, so he has asked me to post this for him. I'll let him edit this, to make any comments.



The only thing I have to say is WOW, look at that slope on that score.....

E_T

	20-04-2004 07:56									#22
	Increase Your PM Length

CFC ?? !! ??

	20-04-2004 11:50									#23
	Re: Turn 172, 560AD score chart Help yourself to an AD-FREE life

quote: Originally posted by E_T Arnelos is still having problems uploading, so he has asked me to post this for him. I'll let him edit this, to make any comments. The only thing I have to say is WOW, look at that slope on that score..... E_T

WOW that is very impressing. Is this per turn scores?

	20-04-2004 22:20									#24
	Browse Apolyton AD-FREE

We need to work on CFC and get there curve more like GCA's.

Why the hell aren't they REXing anyway?

Did we ever find that out?

	20-04-2004 22:52									#25
	Support Apolyton or Terrorists Win

One city got its pop pumped up for their FP build.

The others... uh...

Donovan said that we would soon see new cities popping up though, so hopefully that'll begin soon.

	20-04-2004 23:24									#26
	Put an end to popups!

Face it, they just don't have an E_T....

E_T

	20-04-2004 23:35									#27
	Get a bigger avatar today!

No, but we can easily arrange that...

	21-04-2004 06:56									#28
	Increase Your PM Length

Can I get the spreadsheet for that? I can do some meaningless but fun estimations of the date we become the top civ...

And what about an explanation to that legend? Some of those points have the same x values, and what is all this Poly . (GCA), Poly . (CFC) stuff?

	21-04-2004 07:46									#29
	Browse Apolyton AD-FREE

quote: Originally posted by MrWhereItsAt And what about an explanation to that legend? Some of those points have the same x values, and what is all this Poly . (GCA), Poly . (CFC) stuff?

1. As I have stated elsewhere (I think even further up in this thread), the points reflect the estimated REAL score on each individual turn. Since this is, at best, a rough estimate based upon the change in score from the previous turn combined with accumulated scores over time, the points themselves aren't terribly reliable. Also, since the difference between a score going up by 2 points or 3 points from one turn or another is absolutely enormous, the jump in score tends to flucuate if the actual value would cause an increase somewhere between 2 and 3 on average each turn. Again, the individual points don't normally mean very much. What has much more significant meaning are the trends established over time.

2. As such, the lines are polynomial functions created by Excel to approximate the curve of the data points. I used Excel for this and it inserts "Poly. (data set)" as the format in the legend for such functions.

Does that help to explain the issue?

	23-04-2004 16:58									#30
	Support Apolyton, buy Alpha Centauri

Try pre-smoothing with a moving 2 point average for the "y" and a transposition of -0.5 for the "x"