Loading ...
Sorry, an error occurred while loading the content.

561Re: [lbgc] Team Roborally updated league tables, Jan 11 2009

Expand Messages
  • Allan Mertner
    Jan 18, 2009
      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, I'll check if there is a function that allows me to "IF NAME=DAVE THEN MOVE UP A BIT" :-)

      Allan

      On Sat, Jan 17, 2009 at 10:19 PM, David Bullions <davebullions@...> wrote:

      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



      From: allan@...
      Date: Sat, 17 Jan 2009 15:01:46 +0000

      Subject: [lbgc] Team Roborally updated league tables, Jan 11 2009


      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














      NamePointsGamesLast?Prev RatingRatingRankMovementLast played
      Stuart F5112Yes3.7503.9231Up 1!11/01/2009
      Josep A4210Yes3.6003.8182Up 1!11/01/2009
      Tomas P266Yes4.0003.7143Down 211/01/2009
      Martial C143
      3.5003.5004
      23/11/2008
      Jean-FH102
      3.3333.3335
      04/01/2009
      Andrew M3510Yes2.9003.1826Up 3!11/01/2009
      Allan M319Yes3.1113.1007Down 111/01/2009
      Neil P185
      3.0003.0008Down 107/12/2008
      Stania M61
      3.0003.0009Down 113/04/2008
      Bob R4615
      2.8752.87510
      04/01/2009
      Dave B227
      2.7502.75011
      04/01/2009
      Michael P51
      2.5002.50012
      28/09/2008
      Nicky R51
      2.5002.50013
      13/07/2008
      George Y51
      2.5002.50014
      20/01/2008
      Richard B93
      2.2502.25015
      26/10/2008
      Michal K83
      2.0002.00016
      23/11/2008
      Keith D115
      1.8331.83317
      04/01/2009
      Attila W52
      1.6671.66718
      06/04/2008
      Dave P42
      1.3331.33319
      23/11/2008
      Felix K75
      1.1671.16720
      07/12/2008
      Hannes S22Yes1.0000.66721
      11/01/2009
      Zoran D11
      0.5000.50022
      04/01/2009
      Sandy E11
      0.5000.50023
      26/10/2008
      James R11
      0.5000.50024
      13/07/2008
      Henning S11
      0.5000.50025
      06/04/2008
      Mark F01
      0.0000.00026
      23/11/2008
      Robert F01
      0.0000.00027
      23/03/2008
      Michael Y01
      0.0000.00028
      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



      Are you a PC?  Upload your PC story and show the world Click Here!

    • Show all 7 messages in this topic