Page 2 of 8 FirstFirst 1234 ... LastLast
Results 11 to 20 of 80

Thread: 2019 pick'ems

  1. #11
    Senior Member
    Join Date
    Nov 2011
    Location
    France
    Posts
    649
    Like
    35
    Liked 296 Times in 135 Posts
    Quote Originally Posted by Kradovech View Post
    If someone can figure out how to convert the entries from that thread into a single data file, I could rather easily create an excel spreadsheet for calculating the results. The data file could be for example something like this:

    Participant1 1 Ogier 2 Tänak 3 Meeke 4 Latvala 5 Neuville 6 Loeb 7 Lappi 8 Evans
    Participant2 1 Ogier 2 Tanak 3 Lappi 4 Loeb 5 Latvala 6 Neuville 7 Evans 8 Meeke
    Participant3 1 Tanak 2 Ogier 3 Meeke 4 Loeb 5 Lappi 6 Neuville 7 Mikkelsen 8 Suninen
    Etc…

    Of the top of the head I cannot figure out how to get that done automatically, doing it by hand requires more time than I would be willing to contribute. I could handle creating the excel and posting the results from that point on. Unless of course someone would be willing to share an already working (automated?) spreadheet.
    Sent you a private message. With regards to the rules i suggest to use the same scoring as last year (with the opportunity to drop the lowest score at the end of the season)

  2. Likes: Kradovech (2nd February 2019),Rallyper (2nd February 2019)
  3. #12
    Senior Member
    Join Date
    Jan 2019
    Location
    Estonia
    Posts
    210
    Like
    67
    Liked 443 Times in 105 Posts
    Since spiderem has presented the data exactly how I requested for Monte, I really have no excuse not to do it I will spend some time on it tomorrow, ill see how far I will get. I'm sure I will be able to post Monte results some time next week.

    I will then use dupanton's scoring system from last year:
    Quote Originally Posted by dupanton View Post

    U\P 1 2 3 4 5 6 7 8
    1 25 14 8 3 1 1 1 1
    2 15 18 11 6 1 1 1 1
    3 10 14 15 9 4 1 1 1
    4 6 10 11 12 6 2 1 1
    5 4 6 8 9 10 5 2 1
    6 1 2 3 5 6 8 3 2
    7 1 1 2 3 4 5 6 3
    8 1 1 1 1 1 2 3 4
    The lowest scoring round will be dropped.

    If there are any other requests or proposals for the rules, let me know and discuss it here.

  4. Likes: EstWRC (2nd February 2019),KiwiRallyFan (3rd February 2019),Micke_VOC (3rd February 2019),pantealex (5th February 2019),Rallyper (3rd February 2019),skarderud (3rd February 2019),TWRC (3rd February 2019)
  5. #13
    Senior Member EstWRC's Avatar
    Join Date
    Nov 2014
    Location
    Estonia
    Posts
    13,882
    Like
    6,764
    Liked 12,162 Times in 5,216 Posts
    Awesome dude! Thanks !
    #8 Ott Tänak - Martin Järveoja #8
    - World Rally Champions 2019 -

  6. #14
    Senior Member
    Join Date
    Jan 2019
    Location
    Estonia
    Posts
    210
    Like
    67
    Liked 443 Times in 105 Posts
    Ok here we go, I am finished with Monte results. If spiderem agrees to provide me with the data file for upcoming rallies same as this time, we have a working solution!

    I went with the same scoring as last year:

    I flipped the results/prediction axis in the table for my own reasons, the system should be exactly the same.

    In case of equal score, the win is given to the better prediction of 1st place. If that is equal then better prediction of 2nd place gets the win etc... If all 8 predictions are equal then I dont know. A cage fight to decide? Or maybe we will just agree with a tie.

    As mentioned before, in overall standings the lowest scoring round will be dropped, starting from Sweden.

    Below are preliminaty results for Monte. Please check that your score is correct, if there is a problem, send me a PM. After 1 week I will change the results to official. If you have any proposals for changing/improving the rules, post it within a week as well.
    Also one more request for the future. Please check the spelling of names in your predictions! I might notice and correct them but I cannot quarantee you will get your points for a misspelt name I dont mean the use of special charachters, Tanak instead of Tänak and Rovanpera instead of Rovanperä is ok. But Nuevill, Tidemann or Oger may not go through, I dont plan to go through all entries in the future.

    Without further ado:


    Rally Monte Carlo
    Very close round with top 3 all at 80 points. Victory goes to Ucci while papar007 and sidrum share the second place


    Attached Images Attached Images
    Last edited by Kradovech; 4th February 2019 at 18:19.

  7. Likes: AnttiL (5th February 2019),Co-driven (5th February 2019),COD (8th February 2019),EstWRC (3rd February 2019),KiwiRallyFan (4th February 2019),maailmameister (4th February 2019),Micke_VOC (3rd February 2019),pantealex (5th February 2019),Rallyper (3rd February 2019),TWRC (3rd February 2019)
  8. #15
    Senior Member
    Join Date
    Jan 2019
    Location
    Estonia
    Posts
    210
    Like
    67
    Liked 443 Times in 105 Posts
    It seems results are missing for seven guys. I don't have time to spend on it today, I'll sort it out sometime next week. If you find any other errors, go ahead and let me know

  9. #16
    Senior Member
    Join Date
    Feb 2009
    Posts
    1,841
    Like
    2
    Liked 629 Times in 347 Posts
    Holy moly-this is a surprise. Finally my trust in Ogier paid off.....best way to start the season with the 1st place in pickems!!

  10. Likes: pantealex (5th February 2019),Rallyper (4th February 2019)
  11. #17
    Senior Member Rallyper's Avatar
    Join Date
    Jan 2009
    Location
    Östhammar, Sweden
    Posts
    8,075
    Like
    5,621
    Liked 2,832 Times in 1,606 Posts
    Pickems for Rally Sweden starts from Thursday 7th.

    For now on Pickems WRC 2019 is a joint venture between me, Kradovech and Spiderem.

    I´m playing the smallest role. They do the real job.
    "Reis vas pät pat kaar vas kut"
    Tommi Mäkinen, back in the years...

  12. Likes: AnttiL (5th February 2019),ELPE (4th February 2019),Kradovech (4th February 2019),pantealex (5th February 2019),TWRC (4th February 2019)
  13. #18
    Senior Member
    Join Date
    Jul 2004
    Location
    Jyvaskyla rallycity
    Posts
    1,587
    Like
    483
    Liked 266 Times in 170 Posts
    Nice start 4th place 🤩

  14. #19
    Senior Member
    Join Date
    Jan 2019
    Location
    Estonia
    Posts
    210
    Like
    67
    Liked 443 Times in 105 Posts
    I updated the table with the five missing guys (Not seven, that was my fail in basic math ). I added them by hand for now.
    Top 20 are unaffected by this change.
    Again, let me know if you find any other errors

  15. #20
    Senior Member
    Join Date
    Nov 2011
    Location
    France
    Posts
    649
    Like
    35
    Liked 296 Times in 135 Posts
    Quote Originally Posted by Kradovech View Post
    I updated the table with the five missing guys (Not seven, that was my fail in basic math ). I added them by hand for now.
    Top 20 are unaffected by this change.
    Again, let me know if you find any other errors
    Thanks for the scoring! Yes i ignored people who didn't follow the rules for typing pickems (1. Ogier or 1) Ogier etc). It is a timely exercise to convert to excel, i don't necessarily want to spend more time correcting typo.

    Agree on the cage fight for equal scores, there are few specimens on this forum, that should keep us entertained for a while.

    I commit myself to provide excel after each round, as long as people can create the pickem thread on the forum?

    May the best win.

  16. Likes: Kradovech (5th February 2019),Rallyper (5th February 2019)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •