1 2 3 4
aircooled
aircooled MegaDork
10/31/24 6:18 p.m.

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.

gunner (Forum Supporter)
gunner (Forum Supporter) GRM+ Memberand Dork
10/31/24 9:41 p.m.

Shouldn't I be in 10th at Brands Hatch instead of 12th?

dean1484
dean1484 GRM+ Memberand MegaDork
11/1/24 7:52 a.m.

I will update the HC weights tonight. 

dean1484
dean1484 GRM+ Memberand MegaDork
11/1/24 7:55 a.m.

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?  

dean1484
dean1484 GRM+ Memberand MegaDork
11/1/24 11:43 a.m.

HC updated on the server adjusted for the 2nd Drop.  Changes things around a bit at the front.  Should make things close next week!!!!

aircooled
aircooled MegaDork
11/1/24 3:08 p.m.

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.

aircooled
aircooled MegaDork
11/1/24 3:10 p.m.

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.

Racebrick
Racebrick HalfDork
11/1/24 5:33 p.m.

How did this piece of E36 M3 get a ten race season? laugh

aircooled
aircooled MegaDork
11/1/24 5:44 p.m.

Ya git what ya git, unless you come up with something else.

Sold for 1.2 Million on Bring a Trailer:

1991 Porsche 911 Carrera 4 Coupe by Singer

gunner (Forum Supporter)
gunner (Forum Supporter) GRM+ Memberand Dork
11/1/24 6:41 p.m.

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

Piguin
Piguin Reader
11/1/24 7:22 p.m.

In reply to Racebrick :

Dean likes it indecision

aircooled
aircooled MegaDork
11/2/24 12:35 a.m.

Here is a quick highlight from the last race.  For some reason I did not get the first race unfortunately.

 

aircooled
aircooled MegaDork
11/5/24 1:23 a.m.

Standings and Highlights.  Highlights are almost dull since the racing was very clean.  CONTENT PEOPLE, WE NEED CONTENT!

 

1 2 3 4

You'll need to log in to post.

Our Preferred Partners
zhcUiGrcV4yim4am1tZVT4f3nFRFzEs0KHKRyryOBbD0gKoWdz0jUyfjKcP7FEZe