Open ◆ SNAIL [Spec] Racing - Presented by ButtKicker: Feel What You've Been Missing

Discussion in 'SNAIL Racing League' started by zer05ive, Dec 13, 2011.

  1. Vol Jbolaz

    Vol Jbolaz Premium

    Messages:
    2,254
    Location:
    United States
    Would someone mind sending me the Amuse S2000 R1 '04? I didn't grab it recently when it came up win the online dealership.

    I would like to second this. It had some good racing, and I won the evening last night.

    Mind you, there were clearly some better drivers than me that had selected horrible cars. My wins were due to my car, and the lucky advantages of traffic from such a varied field.

    Still, was fun.
     
  2. jobyone

    jobyone Premium

    Messages:
    3,558
    Location:
    United States
    If you have not received one by tonight send me a friend request and I can get you one later tonight when I get home. Will be around 7:00 pst.
     
  3. fzappa

    fzappa Premium

    Messages:
    1,716
    Location:
    United States
    -ATTENTION SNAILS-

    If anyone does not have the GT5 Racing Car Pack , for what ever reason , shoot me a PM and I will foward you a code for the DLC so you will be able to race the Kart this Sunday and also possible future races that involve cars from this DLC.
     
  4. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    Thanks for putting something into a visual representation. You can see from the two graphs how the point totals level off from left to right in the two graphs. It would be even more pronounced if the bottom graph also ranged from 70 to 110 as the top one does.

    I will have a list of every instance of prize changes from the past few months that the system would have caused and will post it today.
     
  5. Apmaddock

    Apmaddock Premium

    Messages:
    1,573
    Location:
    United States
    Yeah. I didn't spend the time trying to figure out how to make that happen last night...assuming you can in a google doc.
     
  6. TEX36

    TEX36 Premium

    Messages:
    3,071
    Location:
    United States
    Okay - will make that adjustment, hopefully. Didn't read any of the earlier posts if it was discussed. Thanks for making it clear.
     
  7. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    Here it goes. This will detail the results of every race night since Aug. 5 (when we went to 5 divisions). Divisions are not named and you will only see the points scored, number of racers (averaged if it differed from race to race in the same night), and the change in position with the adjustment applied.

    points/#of racers ......... adjusted position
    98/8 ........ 2
    96/12 ....... 1
    89/6 ....... 5 ....... 8/5/12
    85/9 ....... 4
    84/12 ....... 3

    93/5 ........ 5
    88/9 ........ 3
    83/11 ....... 2 ....... 8/12/12
    79/13 ....... 1
    75/12 ........ 4

    90/9 ....... 1
    89/9 ....... 2
    89/9 ....... 2 ....... 8/19/12
    85/9 ....... 5
    84/11 ...... 4

    95/10 ........ 1
    95/8 ........ 2
    88/7 ........ 3 ........ 8/26/12
    82/9 ........ 4
    81/9 ........ 5

    97/6 ........ 2
    93/6 ........ 4
    87/9 ........ 3 ....... 9/2/12
    87/7 ....... 5
    81/12 ....... 1

    97/12 ....... 1
    91/8 ....... 2
    85/10 ........ 3 ....... 9/9/12
    84/10 ....... 4
    76/11 ...... 5

    89/9 ........ 2
    88/10 ....... 1
    85/10 ........ 4 ....... 9/16/12
    84/10 ........ 5
    81/12 ........ 3

    90/14 ........ 1
    89/14 ....... 2
    89/9 ....... 3 ....... 9/23/12
    86/7 ....... 5
    85/10 ....... 4

    89/9 ....... 3
    87/14 ....... 1
    86/13 ....... 2 ....... 9/30/12
    83/7 ...... 5
    77/11 ...... 4

    92/12 ....... 1
    90/11 ....... 2
    82/12 ....... 3 ....... 10/7/12
    82/12 ....... 3
    82/10 ....... 5

    93/10 ...... 1
    93/7 ....... 4
    90/10 ....... 2 ........ 10/14/12
    86/11 ....... 3
    77/12 ....... 5

    97/7 ....... 3
    97/9 ....... 1
    90/11 ....... 2 ....... 10/21/12
    80/10 ....... 5
    76/15 ....... 4

    95/10 ....... 1
    94/9 ....... 2
    86/10 ....... 3 ....... 10/28/12
    85/10 ....... 4
    80/12 ....... 5

    100/7 ........ 2
    91/11 ....... 1
    89/10 ........ 3 ....... 11/4/12
    77/11 ....... 4
    75/11 ........ 5

    97/10 ....... 1
    87/9 ....... 4
    86/11 ....... 3 ....... 11/11/12
    84/13 ....... 2
    93/9 ....... 5

    93/8 ....... 1
    85/7 ....... 5
    84/11 ....... 2 ..... 11/18/12
    84/9 ....... 4
    81/11 ...... 3

    93/7 ...... 3
    91/8 ...... 2
    86/9 ...... 4 ...... 11/25/12
    86/10 ...... 1
    79/10 ...... 5
     
    Last edited: Nov 30, 2012
  8. Apmaddock

    Apmaddock Premium

    Messages:
    1,573
    Location:
    United States
    I can see from that how close some of the adjusted scores must have been. That certainly makes things interesting.

    There was one time where the highest score adjusted to lowest, and once where the lowest adjusted to highest. Obviously things are being leveled out by this.

    Very cool.
     
  9. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    Yes, it does seem to level it off.
     
  10. zer05ive

    zer05ive Premium

    Messages:
    5,717
    Location:
    United States
    Yeah it really works well! Bowler, can you put something together that summarizes the formula and how it works?
     
  11. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    I will put something together.
     
  12. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    Announcement
    S.N.A.I.L. will now be using a new system to compare the performance of weekly winners that are participating in rooms with a varying number of drivers.

    This system will take into account the number of drivers in a room and adjust the point total of the winner only for the purpose of determing the A, B, and C prize winner for the week.

    This system will not affect the point totals of any drivers within their own division and the system will not change the current point structure in any way except to compare the point totals of different division winners for the purpose of selecting the weekly prize winners.

    The system will use a multiplier based on the average number of participants in a division for the night. If a room has 11 participants for all six races, then the winner's total will use the multiplier for 11 racers. If a room has 11 for one race and 10 for four races and 9 for the sixth race, the average will be taken and the winner's total will use the multiplier for 10 racers.

    The multipliers will be as follows:

    6 = .88
    7 = .91
    8 = .94
    9 = .97
    10 = 1.00
    11 = 1.03
    12 = 1.06
    13 = 1.09
    14 = 1.12
    15 = 1.15
    16 = 1.18

    The system will be implemented by multiplying each division winner's final point total by the multiplier associated with the number of driver in the room. Example:

    D1 - 92 pts. with 9 drivers = 89.24 adjusted total Prize B
    D2 - 86 pts. with 12 drivers = 91.16 adjusted total Prize A
    D3 - 88 pts. with 10 drivers = 88.00 adjusted total
    D4 - 86 pts. with 11 drivers = 88.58 adjusted total Prize C
    D5 - 93 pts. with 7 drivers = 84.63 adjusted total

    This system is in no way a change to the point structure within the divisional structure of the league. This method will only be applied for the purpose of comparing winners from different room sizes to each other in a more accurate way than what we have now. This system will only be used to determine the distribution of the weekly prizes and will not have any effect on the monthly standings.
     
    Last edited: Nov 30, 2012
  13. KuulKrinne

    KuulKrinne

    Messages:
    188
    Why do you wanna change the points system?
     
  14. Apmaddock

    Apmaddock Premium

    Messages:
    1,573
    Location:
    United States
    Because a racer in a room/division with fewer drivers can more easily gain more points.

    The point system is not changing. A multiplier/modifier to better compare one division's winner to another's may be implemented for prize purposes, only.
     
  15. Handlebar

    Handlebar Premium

    Messages:
    3,968
    Location:
    United States
    The only part that jiggled my eyeballs was moving the 100 point driver to second place.

    Yeah, the other guy had many more drivers, and I DO like this system to simply compare the top scores for prize distribution - not just redoing all the numbers, etc.

    That one just caught my attention - I am only wondering how close were they on the adjustment?
     
  16. Apmaddock

    Apmaddock Premium

    Messages:
    1,573
    Location:
    United States
    Pretty close…

    91/11 = 93.73
    100/7 = 91
    89/10 = 89
     
  17. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    The 100 was adjusted to 91 becasue there were 7 drivers in that division. The score that went ahead was a 91 in a room with 11 drivers which adjusted was worth 93.73.

    The decision would fall upon Zero, but I wouldn't be opposed to having an exception and allowing the 100 point night to stay at the top regardless of the adjusted totals.

    In addition, there were three instances of an adjusted total being over 100. Every time this was done, it was done by a driver that has since been moved up at lease one division.
     
  18. Nicktune

    Nicktune Premium

    Messages:
    1,174
    Location:
    Canada
    Looks great Bowler. :tup:
     
  19. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Nice work Bowler. Your MathFu is strong.

    I'd be interested to see how that formula is written in the spreadsheet. Nested if/then statements or something more arcane?
     
    Last edited: Nov 30, 2012
  20. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    I wouldn't even bother putting it in the spread sheet if it were up to me. I would only use it in the results post and prize announcement each week. Putting it in the spread sheet with official results would just muddy it up in my opinion.
     
  21. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Figured you were using a spreadsheet, separately, to make the calcs. And while it may not be used for divisional standings, it is still going to be the "Official" figures for prize distribution, so from my seat, certainly belongs in there, even if as a separate sheet.
     
  22. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    I suppose it should be kept in there somewhere and a seperate sheet is probably the best place for it. I did not use a spread sheet when creating this thing. I did it the old fashioned way with paper and pencil and a calculator.
     
  23. tezgm99

    tezgm99

    Messages:
    2,012
    Location:
    Canada
    Old-fashioned would be slide-rule and/or a abacus, calculators are for the feeble :sly:
     
  24. Apmaddock

    Apmaddock Premium

    Messages:
    1,573
    Location:
    United States
    I've already written it into a spreadsheet. It was pretty easy and looked something like this:

    =SUM((1+((((I6+N6+T6+Y6+AE6+AJ6)/6)-10)*.03))*C7)

    In other words:

    (((Average number of racers per race - 10 (Base number of drivers)) X 3%) + 100%) X Winners Score

    It obviously works in a single cell and can be put wherever so that the data is there when it's needed. It also takes into account any number of drivers for each of the races, so the average number of racers can be in the decimals, which makes it more accurate.
     
    Last edited: Nov 30, 2012
  25. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Would you mind sending me the sheet(s)?
    My spreadheetfu is average, but I'm always looking to increase my knowledge.
     
  26. Apmaddock

    Apmaddock Premium

    Messages:
    1,573
    Location:
    United States
    Hopefully the edit makes sense to you. I can't really give you the spreadsheet as it's on a director's doc right now. It's all pretty much basic math.
     
  27. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Yeah, maybe it is basic math, but you've already got the data entered. While building spreadsheets has been a relatively small hobby of mine over the last 20 years or so, I've never been that jazzed about entering historical data. No big deal I reckon. Was just curious how the formulae were built.
     
  28. JLBowler

    JLBowler Premium

    Messages:
    6,748
    Location:
    United States
    That's nice and even more accurate than what I was able to do by hand with the decimals on the ave field size. I was aiming for simple but effective and I hope I've found it. What you've done in the sheet will give instant results and I like that.
     
  29. kcheeb

    kcheeb Premium

    Messages:
    4,753
    Location:
    Canada
    With this Sundays results you'll be able to see the formulae, once the Division sheets are copied to the public document.
     
  30. Dragonwhisky

    Dragonwhisky Premium

    Messages:
    5,829
    Location:
    United States
    Would I be able to copy the data and formulae from the public doc into my own spreadsheet?

    As I recall, that results workbook has a ton of sheets. :boggled: