Re: Focus Cup - Points Standings

**GLR Viper58** Sat Feb 05, 2011 2:20 pm

Fixed... he was on the race results page but didn't transfer to the points page.

**GLR Viper58** Thu Feb 10, 2011 5:59 pm

Points are updated through the race at Silverstone.

Note I have a formula problem for the average points per start. I am working on a fix for this.

**Midnite Rider** Fri Feb 11, 2011 2:30 pm

GLR Viper58 wrote:Points are updated through the race at Silverstone.

Note I have a formula problem for the average points per start. I am working on a fix for this.

I looked over your sheet, looks fine to me, I was wondering about the formula you used, but when I added a column and did it using the AverageA function it shows the same results as your IF(countA) function. I will put a copy of it up if you want to look at it.

Guest Fri Feb 11, 2011 3:56 pm

Yea, the average points are wrong because it is also averaging races they didn't compete in.

**Midnite Rider** Fri Feb 11, 2011 4:22 pm

Yeah, I saw that. I did a fix for him and uploaded it to the document space, My average does not count a race with no points and only averages races with a points total. I used the AverageIf function and specified it to skip any that has a 0 in it. What a Face

**GLR Viper58** Fri Feb 11, 2011 5:50 pm

GLR Lothar wrote:Yea, the average points are wrong because it is also averaging races they didn't compete in.

Yeah I know why... I chose the lessor of two evils... I made sure the points are right. I can switch things and make points per race right but then the best finish points are wrong... Anyway I think we have a fix as well as some more embellishments coming.

**GLR Asteroid** Fri Feb 11, 2011 5:58 pm

Man....., they're really working you and midnite......LOL !!

Hmmmm.......get your act together young man !!! Shocked

Guest Fri Feb 11, 2011 6:23 pm

GLR Asteroid wrote:Man....., they're really working you and midnite......LOL !!

Hmmmm.......get your act together young man !!!

LOL....its then 1 person getting stuck with all of it though.

**GLR Viper58** Fri Feb 11, 2011 6:29 pm

All fixed... by the end of this experiment we ought to have a pretty comprehensive spreadsheet.

**GLR Viper58** Fri Feb 18, 2011 12:53 am

Points thru Camino full are now updated.

**GLR Viper58** Thu Feb 24, 2011 10:01 am

Points thru Sebring Club now updated.

**TrooperR6** Thu Feb 24, 2011 11:54 am

Last place on the grid! cheers

Guest Mon Feb 28, 2011 1:17 pm

Hey Viper, How come in the race 5 column it is showing 0 total points for Sponge?

**GLR Viper58** Mon Feb 28, 2011 1:44 pm

GLR Lothar wrote:Hey Viper, How come in the race 5 column it is showing 0 total points for Sponge?

Must be a glitch in the formula. It doesn't appear to be summing correctly as the raw points fields are correct. I will fix. That error will affect his overall points total but will not affect his points per race for grid purposes.

**GLR Viper58** Tue Mar 01, 2011 9:02 pm

Lothar and Sponge... that error really doesn't affect anything in the standings. I calculate the total points and anything that matters from the raw points data and all that is correct. It will be correct on the next upload, but the Final points and the Points per start are correct as shown.

**GLR Viper58** Thu Mar 03, 2011 7:10 pm

Laguna Seca Points are now updated!

**Midnite Rider** Thu Mar 03, 2011 8:55 pm

Woo Hoo!! Nothin like last place points!! cheers

Thanks a bunch Turn 10, you suck! What a Face

**GLR Viper58** Thu Mar 03, 2011 9:55 pm

Yeah that sucks for you Midnite... but the glass half full argument is at least you come away with a "cheap" 70 points.

**Midnite Rider** Fri Mar 04, 2011 12:36 pm

I know, I'm not complaining, just voicing my disgust! LOL Wink

**GLR Viper58** Thu Mar 10, 2011 7:05 pm

Mugello Club Race Points Updated...

Final Race of the series next at Road Atlanta (Full)

**rodrigo.o.s** Fri Mar 11, 2011 6:36 pm

Anyone have the reply of the race at Mugello? I think I did the best lap and did not give me the score, somebody can send the replay?

Guest Fri Mar 11, 2011 6:48 pm

rodrigo.o.s wrote:Anyone have the reply of the race at Mugello? I think I did the best lap and did not give me the score, somebody can send the replay?

Rodrigo, here is the picture of the lobby 1 results. You clearly didn't have the fastest lap. Sorry dude

Focus Cup - Points Standings - Page 2 IMG_0672

**GLR Viper58** Fri Mar 11, 2011 6:55 pm

Oops but I did give it to Michae1 Weston by mistake... I see now that I missed inviseco's time.

**glrdopehat420** Sun Mar 13, 2011 2:22 pm

I like the weekly progression spreadsheet guys, nice touch.

**GLR Viper58** Thu Mar 17, 2011 3:08 am

Final Points Standings are up! Congratulations to EZT Trooper for the overall Ford Focus Cup title!

Sponsored content