7 replies to this topic

[Costaz]

Great Britain 2012 - Guess the Podium Results

I remember lots of rain, and some interesting final laps? Nobody guessed Alonso for the win, and wlleiotl was the clear winner, with 4 points :

wlleiotl 4
JEAN 4
acuraf1 3
Dispenser89 3
Makarias 3
scheivlak 3
sir jackie walker 3
Anderis 2
August 2
BERNIE 2
Crazy Canuck 2
dank 2
DutchQuicksilver 2
Estwald 2
Fastcake 2
Ghostrider 2
Grayson 2
kismet 2
mark f1 2
Mekola 2
Brawn BGP 001 1
Costaz 1
fisichella_2001 1
M2000-5 1
rvd2hbk 1
Hans 0
GB Avg: 2.076923077

One day, I'll figure out how the code and this /pre thing works...

Edited by Costaz, 23 August 2012 - 10:34.

[Costaz]

Germany 2012 - Guess the Podium Results

Previously published Germany results removed, I messed up the calculation. Coming back soon.

Edited by Costaz, 23 August 2012 - 13:29.

[Costaz]

Germany 2012 - Guess the Podium Results

An improved performace by all, and particularly by Kingshark, who manages to win the round in his maiden appearence in the game . His score of five is the highest score since the opening round in Australia!

Kingshark 5
Mekola 4
Anderis 4
Apex 4
August 4
Costaz 4
DutchQuicksilver 4
Estwald 4
fisichella_2001 4
Grayson 4
JEAN 4
M2000-5 4
Makarias 4
mark f1 4
rvd2hbk 4
wlleiotl 4
wrcva 3
BERNIE 3
Brawn BGP 001 2
Dispenser89 3
Iscurrega 3
Kismet 3
scheivlak 3
sir jackie walker 2
AcuraF1 2
dank 2
Fastcake 2

Germany Avg: 3.444444444

Note that, as per the game rules ('Points will be awarded as per the drivers who celebrate the official podium ceremony after the race, with no subsequent protests or exclusions taken into account'), the winning podium for the game was Alon/Vett/Butt.

Edited by Costaz, 23 August 2012 - 14:22.

[Costaz]

Hungary 2012 - Guess the Podium Results

After the heights of Germany, we are back to low scores, and an average of 1.08 for the round. Still, scheivlak shows his good form, and wins the round!

scheivlak 4
Brawn BGP 001 3
Dispenser89 3
Makarias 3
M2000-5 2
rvd2hbk 2
Anderis 1
BERNIE 0
Estwald 1
fisichella_2001 1
Ghostrider 1
Grayson 1
kismet 1
Mekola 1
wlleiotl 1
AcuraF1 0
August 0
Costaz 0
dank 0
Fastcake 0
Iscurrega 0
JEAN 0
mark f1 0
sir jackie walker 0

Hungary Avg: 1.041666667

Edited by Costaz, 23 August 2012 - 13:47.

[Costaz]

Last, but not least, the overall standings, following the Hungarian Grand Prix. wlleiotl and scheivlak have shown really good form in the summer races, but the championship is still tight, and everything is in play. Roll on, Spa!

Overall standings	
1	wlleiotl 	23
=	scheivlak	23
3	Anderis	22
=	Makarias	22
5	sir jackie walker	21
=	acuraf1 	21
=	Grayson 	21
8	Costaz 	19
=	DutchQuicksilver 	19
=	Dispenser89 	19
11	rvd2hbk	18
=	JEAN 	18
13	Brawn BGP 001 	17
=	Apex 	17
=	August 	17
=	fisichella_2001 	17
=	kismet 	17
18	Mekola 	16
=	Crazy Canuck 	16
=	Iscurrega	16
=	Estwald 	16
22	mark f1	15
23	dank 	13
=	BERNIE 	13
=	Fastcake	13
26	Ghostrider 	11
=	M2000-5	11
28	D82 	8
=	rodlamas   	8
=	shays 	8
31	Kingshark	5
32	sumpthy 	4
33	wrcva	3
=	ali.unal 	3
=	Hartik 	3

[Makarias]

I suppose you just copy/paste spreadsheet cells to make a row in your tables, say A1, B1 and C1 for the three columns of overall standings. They then come out with tabs between them, and since our nicknames vary in length the tabs don't get nicely aligned and the whole shebang looks messy.

You can instead merge the cell texts together into a single cell with the suitable amount of space characters between them to make it all look very tidy, write something like this in another cell:

=rept(" ";2-len(A1))&A1&" "&B1&rept(" ";35-len(B1))&rept(" ";3-len(C1))&C1

Breakdown:

rept(" ";2-len(A1))&A1 -First column (pos)
&" " -Space character between first and second column
&B1&rept(" ";35-len(B1)) -Second Column (names)
&rept(" ";3-len(C1))&C1 -Third Column (points)

*The & joins together different bits of text.

*The rept function repeats the single space written in the quote marks (you could write anything you'd like to repeat several times in there) and the X-len(Y) thing defines how many times it is repeated. =rept("a";5) returns aaaaa. The value of X determines the width of the column when the rept is joined together with cell Y. 35 is probably longer than necessary for forum nicks, around 20 or so may be enough.

*Note that the different order in the Second column (text before spaces) makes it left aligned, unlike First and Third columns, which become right aligned (spaces before text). The extra Space character between First and Second column is necessary when a left aligned column comes after a right aligned one.

*"rept" and "len" are english language commands and may have to be replaced by the corresponding commands in whatever language you use your spreadsheet; in Swedish they are "rep" and "längd".

Hopefully that helps and isn't completely stupid! I'm not any good with spreadsheets really.

[Makarias]

Oh and in the above example the

rept(" ";35-len(B1))&rept(" ";3-len(C1))

bit can be replaced with

rept(" ";38-len(B1)-len(C1))

which should give the same result, but for pedagogical purposes the first version is pretty handy!

[Costaz]

...

Hopefully that helps and isn't completely stupid! I'm not any good with spreadsheets really.

First time I read your post, I didn't understand a single thing. I'm now reading it more carefully, and it starts to make sense. We'll see how much when I post the next results though

Thank you very much, Makarias, for taking the time to explain this, I really appreciate it. Imagine the things you'd do if you were good with spreadsheets...