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

Team Roborally updated league tables, Jan 11 2009

Expand Messages
  • Allan Mertner
    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
    Message 1 of 7 , Jan 17, 2009
    View Source
    • 0 Attachment
      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
    • David Bullions
      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:
      Message 2 of 7 , Jan 17, 2009
      View Source
      • 0 Attachment
        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: lbgc@...
        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!
      • zoran2531
        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
        Message 3 of 7 , Jan 18, 2009
        View Source
        • 0 Attachment
          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 Played ' column? Cheers! Zoran.
        • Allan Mertner
          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
          Message 4 of 7 , Jan 18, 2009
          View Source
          • 0 Attachment
            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 participated in the last round - do you still think it would be worth having the historical info too?

            Cheers,
            Allan

            On Sun, Jan 18, 2009 at 10:33 AM, zoran2531 <zoran80@...> wrote:

            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 Played ' column? Cheers! Zoran.


          • Allan Mertner
            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,
            Message 5 of 7 , Jan 18, 2009
            View Source
            • 0 Attachment
              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!

            • zoran2531
              ... In the ... who ... worth having ... the ... you ... no need to add the Last Played column, cheers, Zoran.
              Message 6 of 7 , Jan 18, 2009
              View Source
              • 0 Attachment
                --- In lbgc@..., "Allan Mertner" <allan@...> wrote:
                >
                > 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
                > participated in the last round - do you still think it would be
                worth having
                > the historical info too?
                >
                > Cheers,
                > Allan
                >
                > On Sun, Jan 18, 2009 at 10:33 AM, zoran2531 <zoran80@...> wrote:
                >
                > > 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 Played ' column? Cheers! Zoran.
                > >
                > >
                > >
                >Hi Allan, on second thoughts the table works well as a league table,
                no need to add the 'Last Played' column, cheers, Zoran.
              • David Bullions
                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
                Message 7 of 7 , Jan 19, 2009
                View Source
                • 0 Attachment
                  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


                  To: lbgc@...
                  From: allan@...
                  Date: Sun, 18 Jan 2009 14:37:18 +0000
                  Subject: Re: [lbgc] Team Roborally updated league tables, Jan 11 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@ hotmail.com> 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@mertner. com
                  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!




                  Are you a PC? Upload your PC story and show the world
                Your message has been successfully submitted and would be delivered to recipients shortly.