Sign In
New User? Sign Up
lbgc · London Board Games Club
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
You can schedule a time for the group to chat?

Messages

  Messages Help
Advanced
Team Roborally updated league tables, Jan 11 2009   Message List  
Reply | Forward Message #557 of 607 |
In order to relieve Rob of some of the effort involved in computing the league tables for TRR, I have put together a spreadsheet that does it all automatically.  This means that we just have to put in the results of the game, and an updated table pops out - reducing the scope for typos at the same time as making things easier.

There has been two games in 2009 already, the last one on Jan 11th - I will leave it to Bob to describe how Stuart's Bad Guys team managed to win against Tomas' Dream Team, and just show you the resulting league table more or less directly from Excel:

Summary Results of Team Roborally Fun-League: ETERNAL LEAGUE


Last game date: 11/01/2009














Name Points Games Last? Prev Rating Rating Rank Movement Last played
Stuart F 51 12 Yes 3.750 3.923 1 Up 1! 11/01/2009
Josep A 42 10 Yes 3.600 3.818 2 Up 1! 11/01/2009
Tomas P 26 6 Yes 4.000 3.714 3 Down 2 11/01/2009
Martial C 14 3
3.500 3.500 4
23/11/2008
Jean-FH 10 2
3.333 3.333 5
04/01/2009
Andrew M 35 10 Yes 2.900 3.182 6 Up 3! 11/01/2009
Allan M 31 9 Yes 3.111 3.100 7 Down 1 11/01/2009
Neil P 18 5
3.000 3.000 8 Down 1 07/12/2008
Stania M 6 1
3.000 3.000 9 Down 1 13/04/2008
Bob R 46 15
2.875 2.875 10
04/01/2009
Dave B 22 7
2.750 2.750 11
04/01/2009
Michael P 5 1
2.500 2.500 12
28/09/2008
Nicky R 5 1
2.500 2.500 13
13/07/2008
George Y 5 1
2.500 2.500 14
20/01/2008
Richard B 9 3
2.250 2.250 15
26/10/2008
Michal K 8 3
2.000 2.000 16
23/11/2008
Keith D 11 5
1.833 1.833 17
04/01/2009
Attila W 5 2
1.667 1.667 18
06/04/2008
Dave P 4 2
1.333 1.333 19
23/11/2008
Felix K 7 5
1.167 1.167 20
07/12/2008
Hannes S 2 2 Yes 1.000 0.667 21
11/01/2009
Zoran D 1 1
0.500 0.500 22
04/01/2009
Sandy E 1 1
0.500 0.500 23
26/10/2008
James R 1 1
0.500 0.500 24
13/07/2008
Henning S 1 1
0.500 0.500 25
06/04/2008
Mark F 0 1
0.000 0.000 26
23/11/2008
Robert F 0 1
0.000 0.000 27
23/03/2008
Michael Y 0 1
0.000 0.000 28
13/01/2008

It doesn't format quite as nicely as I would like, so here is a picture of it.  If it somehow works to embed it so it shows up without having to open an attachment, that would be nice:



Finally, here is my attempt at doing the same thing in plain text. 

Name         Points  Games  Last?  Prev    Rating  Rank  Move    Last played
Stuart F     51      12     Yes    3.750   3.923   1     Up 1!   11/01/2009
Josep A      42      10     Yes    3.600   3.818   2     Up 1!   11/01/2009
Tomas P      26      6      Yes    4.000   3.714   3     Down 2  11/01/2009
Martial C    14      3             3.500   3.500   4             23/11/2008
Jean-FH      10      2             3.333   3.333   5             04/01/2009
Andrew M     35      10     Yes    2.900   3.182   6     Up 3!   11/01/2009
Allan M      31      9      Yes    3.111   3.100   7     Down 1  11/01/2009
Neil P       18      5             3.000   3.000   8     Down 1  07/12/2008
Stania M     6       1             3.000   3.000   9     Down 1  13/04/2008
Bob R        46      15            2.875   2.875   10            04/01/2009
Dave B       22      7             2.750   2.750   11            04/01/2009
Michael P    5       1             2.500   2.500   12            28/09/2008
Nicky R      5       1             2.500   2.500   13            13/07/2008
George Y     5       1             2.500   2.500   14            20/01/2008
Richard B    9       3             2.250   2.250   15            26/10/2008
Michal K     8       3             2.000   2.000   16            23/11/2008
Keith D      11      5             1.833   1.833   17            04/01/2009
Attila W     5       2             1.667   1.667   18            06/04/2008
Dave P       4       2             1.333   1.333   19            23/11/2008
Felix K      7       5             1.167   1.167   20            07/12/2008
Hannes S     2       2      Yes    1.000   0.667   21            11/01/2009
Zoran D      1       1             0.500   0.500   22            04/01/2009
Sandy E      1       1             0.500   0.500   23            26/10/2008
James R      1       1             0.500   0.500   24            13/07/2008
Henning S    1       1             0.500   0.500   25            06/04/2008
Mark F       0       1             0.000   0.000   26            23/11/2008
Robert F     0       1             0.000   0.000   27            23/03/2008
Michael Y    0       1             0.000   0.000   28            13/01/2008

So - which works best for you?  Do you care?  Drop me a line, or I'll just choose a format to use next time :)

Allan


Sat Jan 17, 2009 3:01 pm

amertner
Offline Offline
Send Email Send Email

Forward
Message #557 of 607 |
Expand Messages Author Sort by Date

In order to relieve Rob of some of the effort involved in computing the league tables for TRR, I have put together a spreadsheet that does it all...
Allan Mertner
amertner
Offline Send Email
Jan 17, 2009
3:01 pm

Allan Thanks for doing that, The middle one looks best. The one thing that would make it look better would be if my name was at the top. Dave To:...
David Bullions
bty819186
Offline Send Email
Jan 17, 2009
10:19 pm

Hi Dave, I'll see what I can do about that, but I have a suspicion it's unrelated to Excel and more related to the results you manage to come up with. OTOH, ...
Allan Mertner
amertner
Offline Send Email
Jan 18, 2009
2:37 pm

Hi Allan Well, if you could look into the possibilies of that. "Related to the results I manage to come up with" - Yes, you might have a point there ;-) Dave ...
David Bullions
bty819186
Offline Send Email
Jan 19, 2009
9:33 am

Hi Allan, thanks for the tables, my vote is for the middle one, the splash of colour enlivens it a bit. Would it be too squashed if you added on the 'Last...
zoran2531
Offline Send Email
Jan 18, 2009
10:33 am

Hi Zoran, I can add "last played" of course, if you think it's interesting. In the latest revision, I added a win/loss column to make it easy to see who ...
Allan Mertner
amertner
Offline Send Email
Jan 18, 2009
2:36 pm

... In the ... who ... worth having ... the ... you ... no need to add the 'Last Played' column, cheers, Zoran....
zoran2531
Offline Send Email
Jan 18, 2009
9:17 pm
Advanced

Copyright © 2009 Yahoo! UK. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help