◆ SNAIL [Spec] Racing - Currently Recruiting for GT7 - JOIN TODAY!!Open

Vol Jbolaz · Nov 30, 2012

Would someone mind sending me the Amuse S2000 R1 '04? I didn't grab it recently when it came up win the online dealership.

AMWeaver47
PUBLIC SERVICE ANNOUNCEMENT

If there is anyone on the fence about racing in the SCT group, don't hesitate. It is tons of fun and has some of the highest quality SNAIL drivers participating. Having different cars levels the playing field a lot so don't worry about being in a lower division. I consider myself a mid-range D4 driver and found myself with several high finishes and close door to door racing all night long.

That is all.

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.

jobyone · Nov 30, 2012

Vol Jbolaz
Would someone mind sending me the Amuse S2000 R1 '04? I didn't grab it recently when it came up win the online dealership.

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.

fzappa · Nov 30, 2012

-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.

JLBowler · Nov 30, 2012

Apmaddock
Not to throw a cat into a tree full of pigeons, but I have to bring this back up before the new season begins

Bowler's idea of a multiplier of three percent for each driver over 10, or a reduction of the same under 10, seems to work quite well.

I'll bring back the chart of the winning score versus the number of drivers in the room. The left side is the least number of drivers, the right has the most.

Now, if you apply his multiplier, the trend graph should level off, which would prove that the multiplier is working, making comparing un-level divisions more fair. Of course, there will be blips from racers who dominated the field or some particularly even nights.

That seems to have worked even better than I expected

What are the thoughts on this?

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.

Apmaddock · Nov 30, 2012

JLBowler
It would be even more pronounced if the bottom graph also ranged from 70 to 110 as the top one does.

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.

TEX36 · Nov 30, 2012

DrKronin
We aren't using the white lines as a track boundary at Kart Space. This is similar to how we treat the line at the end of the Mulsanne (sp?) straight at La Sarthe or the yellow-painted areas at Trial Mountain. There are some tracks we treat differently -- Indy Road Course, for example -- so it's a good question.

Okay - will make that adjustment, hopefully. Didn't read any of the earlier posts if it was discussed. Thanks for making it clear.

JLBowler · Nov 30, 2012

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

Apmaddock · Nov 30, 2012

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.

JLBowler · Nov 30, 2012

Yes, it does seem to level it off.

zer05ive · Nov 30, 2012

Yeah it really works well! Bowler, can you put something together that summarizes the formula and how it works?

JLBowler · Nov 30, 2012

I will put something together.

JLBowler · Nov 30, 2012

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.

KuulKrinne · Nov 30, 2012

Why do you wanna change the points system?

Apmaddock · Nov 30, 2012

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.

Handlebar · Nov 30, 2012

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?

Apmaddock · Nov 30, 2012

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

Pretty close

91/11 = 93.73
100/7 = 91
89/10 = 89

JLBowler · Nov 30, 2012

Handlebar
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?

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.

Nicktune · Nov 30, 2012

Looks great Bowler. 👍

Dragonwhisky · Nov 30, 2012

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?

JLBowler · Nov 30, 2012

Dragonwhisky
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?

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.

Dragonwhisky · Nov 30, 2012

JLBowler
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.

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.

JLBowler · Nov 30, 2012

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.

tezgm99 · Nov 30, 2012

Old-fashioned would be slide-rule and/or a abacus, calculators are for the feeble :sly:

Apmaddock · Nov 30, 2012

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.

Dragonwhisky · Nov 30, 2012

Would you mind sending me the sheet(s)?
My spreadheetfu is average, but I'm always looking to increase my knowledge.

Apmaddock · Nov 30, 2012

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.

Dragonwhisky · Nov 30, 2012

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.

JLBowler · Nov 30, 2012

Apmaddock
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.

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.

kcheeb · Nov 30, 2012

Dragonwhisky
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.

With this Sundays results you'll be able to see the formulae, once the Division sheets are copied to the public document.

Dragonwhisky · Nov 30, 2012

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:

◆ SNAIL [Spec] Racing - Currently Recruiting for GT7 - JOIN TODAY!!Open

Hermits United

Because Racecar

A Token Of My Extreme

He needs no introduction

S.N.A.I.L. Driver - Retired from SIM Racing 8/2021

He needs no introduction

SNAIL

He needs no introduction

He needs no introduction

He needs no introduction

He needs no introduction

Similar threads