OK, I figured it out (it's the Small function that allows you to find the nth smallest item in a range). Updated results posted. It's not quite as close at the top now, but it does pull the HC's down a bit.
Here is the chart used to figure it out (so you can double check to make sure I am not doing something silly). As you can see, it's essentially Dean's lack of a win that puts him into 3rd. Brick, Darwin and Drillin are all out of drops now though.
Shouldn't I be in 10th at Brands Hatch instead of 12th?
I will update the HC weights tonight.
So moving forward how will drops be added? I was thinking that they would be applied starting with the third race and the second being applied at the start of the 8th race. Does this make sence?
HC updated on the server adjusted for the 2nd Drop. Changes things around a bit at the front. Should make things close next week!!!!
In reply to gunner (Forum Supporter) :
OK, yeah, there was a flaw in the spreadsheet. I SWEAR, I have no idea how these pop up, put they happen a lot. Doesn't really give me great confidence in Google Sheets.
It's pretty possible for me to do entries wrong (I try to do them pretty fast), so a good idea to double check those also.
In reply to dean1484 :
I currently have it setup to start applying the first drop in the 2nd race (maybe it makes more sense in the 3rd?), and applying 2 drops in the 6ths.
The drops are from anytime in the season though, so if you miss the first two races, you don't get that second miss credited until race 6.
How did this piece of E36 M3 get a ten race season?
Ya git what ya git, unless you come up with something else.
Sold for 1.2 Million on Bring a Trailer:
In reply to aircooled :
Yeah, Ive seen it happen to several of us. I appreciate you staying on top of it. Just wanted to bring it to someones attention
Here is a quick highlight from the last race. For some reason I did not get the first race unfortunately.
Standings and Highlights. Highlights are almost dull since the racing was very clean. CONTENT PEOPLE, WE NEED CONTENT!