YTD Points totals

General discussions about Solo

Moderator: Mike Simanyi

Post Reply
User avatar
Thomas Barrett
Posts: 152
Joined: Thu May 15, 2008 11:29 am
Club: GRA
Car#: 519
Location: San Bernardino Ca

YTD Points totals

Post by Thomas Barrett »

FYI, I think the link to the YTD point totals is down or bad.

I am trying to get to it from the results page. the team link works fine.
Tom Barrett
Corvette Specialty C6
Solo Safety Steward
Life is like a race, the best times win!
Aaron Goldsmith
Posts: 2663
Joined: Wed May 14, 2008 4:22 pm
Club: CASOC
Car#: 32
Location: HB, CA

Re: YTD Points totals

Post by Aaron Goldsmith »

Far as I know there aren't any year to date point totals yet, Rick said he was having some trouble with the software.
User avatar
Rick Brown
Current Solo Director
Posts: 5114
Joined: Thu May 15, 2008 11:25 am
Club: PSCC
Car#: 240
Location: Lake Elsinore, CA

Re: YTD Points totals

Post by Rick Brown »

Aaron Goldsmith wrote:Far as I know there aren't any year to date point totals yet, Rick said he was having some trouble with the software.
Not to mention that I haven't had access to the computers for some time now, been out of town. Looking at going to get them tomorrow (gotta find out if the motorhome is at the speedway or the Angel's) to update the software so it will be completely screwed up...er, I mean all fixed for the No$ event.
Since light is faster than sound...many people look bright until they speak...
User avatar
Jayson Woodruff
Posts: 1754
Joined: Thu May 15, 2008 11:26 am
Club: PSCC
Car#: 51

Re: YTD Points totals

Post by Jayson Woodruff »

I'd like to pre-sign up for not-the-computer please.

Jay W
User avatar
Rick Brown
Current Solo Director
Posts: 5114
Joined: Thu May 15, 2008 11:25 am
Club: PSCC
Car#: 240
Location: Lake Elsinore, CA

Re: YTD Points totals

Post by Rick Brown »

Jayson Woodruff wrote:I'd like to pre-sign up for not-the-computer please.

Jay W
With the attitude displayed in your avatar, whatever you want, sir!
Since light is faster than sound...many people look bright until they speak...
User avatar
Kurt Rahn
Posts: 3923
Joined: Thu May 15, 2008 11:29 am
Club: CASOC
Car#: 88
Location: Pasadena

Re: YTD Points totals

Post by Kurt Rahn »

With the attitude displayed in your avatar, whatever you want, sir!
Yeah, it's definitely got that what-we've-got-heah-is-a-failya-to-cummunacate vibe.
==============
Oversteer is better than understeer because you don't see the tree you're hitting.
User avatar
Rick Brown
Current Solo Director
Posts: 5114
Joined: Thu May 15, 2008 11:25 am
Club: PSCC
Car#: 240
Location: Lake Elsinore, CA

Re: YTD Points totals

Post by Rick Brown »

Kurt Rahn wrote:
With the attitude displayed in your avatar, whatever you want, sir!
Yeah, it's definitely got that what-we've-got-heah-is-a-failya-to-cummunacate vibe.
Or I was thinkin' "So ya don't think ya can make the juice payment this week? Guido here has an opinion on that."
Since light is faster than sound...many people look bright until they speak...
User avatar
Curt Luther
Posts: 1070
Joined: Thu May 15, 2008 11:27 am
Club: PSCC
Car#: 9
Location: Lookin' in Mike's cooler for "water" ;)...and my underwear
Contact:

Re: YTD Points totals

Post by Curt Luther »

I'm going with South American dictator...
Rev. Dr. Curtis J. Luther, Esq., M.D.
User avatar
Steve Ekstrand
Solo Safety Steward
Posts: 7482
Joined: Thu May 15, 2008 11:26 am
Club: CASOC
Car#: 15
Location: This space left intentionally blank
Contact:

Re: YTD Points totals

Post by Steve Ekstrand »

I was thinking Station Chief La Paz, Bolivia.
Dr. Conemangler
aka The Malefic One
2015 Wildcat Honda F600
User avatar
Kurt Rahn
Posts: 3923
Joined: Thu May 15, 2008 11:29 am
Club: CASOC
Car#: 88
Location: Pasadena

Re: YTD Points totals

Post by Kurt Rahn »

I'm going with South American dictator.
I was thinking Station Chief La Paz, Bolivia.
ROTFLMAO. You're right, the shirt would have to be khaki and the glasses Ray Ban cop specials for him to be a cop. The tropical shirt is the tipoff.
==============
Oversteer is better than understeer because you don't see the tree you're hitting.
Gary Mellor
Posts: 5
Joined: Thu May 15, 2008 11:26 am

Re: YTD Points totals

Post by Gary Mellor »

Not that I expect it makes a big difference but on the "Lifetime Points" list my P# is incorrect it should be 339 (listed as 229)
User avatar
John Fendel
Posts: 486
Joined: Thu May 15, 2008 11:26 am
Club: CASOC
Car#: 23
Location: Lake Forest, CA

Re: YTD Points totals

Post by John Fendel »

Not that I expect it makes a big difference but on the "Lifetime Points" list my P# is incorrect it should be 339 (listed as 229)
Thanks for letting me know. I have corrected my master file and the posted results will be corrected the next time I update them, probably at the end of the year.

If anyone else notices an error, please let me know.

Thanks.
#ALSaware, GRC Performance, Red Line Oil
User avatar
Chad Stubblefield
Posts: 285
Joined: Thu May 15, 2008 11:26 am
Club: Team Blew
Car#: 877
Location: Glendale
Contact:

Re: YTD Points totals

Post by Chad Stubblefield »

Any update on the points?
User avatar
Chuck Fowler
Posts: 471
Joined: Thu May 15, 2008 11:30 am
Club: Team Blew
Car#: 299

Re: YTD Points totals

Post by Chuck Fowler »

Chad Stubblefield wrote:Any update on the points?

viewtopic.php?f=7&t=204&p=2845#p2845" onclick="window.open(this.href);return false;

not you class, but at least it's something...
:thumbup:
it's only paranoia if your wrong
Aaron Goldsmith
Posts: 2663
Joined: Wed May 14, 2008 4:22 pm
Club: CASOC
Car#: 32
Location: HB, CA

Re: YTD Points totals

Post by Aaron Goldsmith »

Chuck Fowler wrote:
Chad Stubblefield wrote:Any update on the points?

viewtopic.php?f=7&t=204&p=2845#p2845" onclick="window.open(this.href);return false;

not you class, but at least it's something...
:thumbup:
Yeah, it takes about 20 minutes of work, but you can make a spreadsheet for your class to figure out the points for you. I did it for most of the year last year for my class.

The formula for points is:
Driver’s Points = 100 – 400 ((Drivers Time – Winning Time) / Winning Time)
User avatar
Michael Palero
King of Fastrack!
Posts: 951
Joined: Thu May 15, 2008 11:25 am
Club: SCNAX
Car#: 18
Location: San Gabriel Valley & Long Beach
Contact:

Re: YTD Points totals

Post by Michael Palero »

What's the syntax to drop the lowest 1/2/3 in sum series?

Better yet, send me your file, I'll just look at it.
Aaron Goldsmith
Posts: 2663
Joined: Wed May 14, 2008 4:22 pm
Club: CASOC
Car#: 32
Location: HB, CA

Re: YTD Points totals

Post by Aaron Goldsmith »

Michael Palero wrote:What's the syntax to drop the lowest 1/2/3 in sum series?

Better yet, send me your file, I'll just look at it.
I guess you could script that, but I just made a second sheet with drops. I haven't done it this year, Richard has won every event, I know who's winning.
User avatar
Christine Grice
King of Fastrack!
Posts: 1932
Joined: Thu May 15, 2008 11:26 am
Club: CASOC
Car#: 17

Re: YTD Points totals

Post by Christine Grice »

In excel I make a couple columns to the far right and use the "smallest" formulas

example:
=small(B1:G1,1) - 1st smallest
=small(B1:G1,2) - 2nd smallest
=small(B1:G1,3) - 3rd smallest

Then add those values up and subtract from event total.

as seen far right:
Attachments
Pax results 080620.JPG
Pax results 080620.JPG (69.7 KiB) Viewed 10762 times
~Christine Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
Aaron Goldsmith
Posts: 2663
Joined: Wed May 14, 2008 4:22 pm
Club: CASOC
Car#: 32
Location: HB, CA

Re: YTD Points totals

Post by Aaron Goldsmith »

Christine Berry wrote:In excel I make a couple columns to the far right and use the "smallest" formulas

example:
=small(B1:G1,1) - 1st smallest
=small(B1:G1,2) - 2nd smallest
=small(B1:G1,3) - 3rd smallest

Then add those values up and subtract from event total.
You can probably just put (small(B1:G1,1)) in the actual calc formulas instead of doing it externally, but it's kinda neat to see the lowest.
User avatar
Christine Grice
King of Fastrack!
Posts: 1932
Joined: Thu May 15, 2008 11:26 am
Club: CASOC
Car#: 17

Re: YTD Points totals

Post by Christine Grice »

Aaron Goldsmith wrote:
Christine Berry wrote:In excel I make a couple columns to the far right and use the "smallest" formulas

example:
=small(B1:G1,1) - 1st smallest
=small(B1:G1,2) - 2nd smallest
=small(B1:G1,3) - 3rd smallest

Then add those values up and subtract from event total.
You can probably just put (small(B1:G1,1)) in the actual calc formulas instead of doing it externally, but it's kinda neat to see the lowest.

Hmm, very true, less cells and clean. :thumbup: But I also try to avoid long formulas because I tend to get them wrong and then have to go troubleshooting. This way I can see which step I screwed up on. :D
~Christine Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
User avatar
Mako Koiwai
Posts: 6490
Joined: Thu May 15, 2008 11:25 am
Club: SCNAX
Car#: 34
Location: South Pasadena, CA
Contact:

Re: YTD Points totals

Post by Mako Koiwai »

Christine for Secretary Points Keeper! :thumbup:
User avatar
Sebastian Rios
King of Fastrack!
Posts: 1656
Joined: Thu May 15, 2008 11:27 am
Club: SCNAX
Car#: 397
Location: Out to lunch

Re: YTD Points totals

Post by Sebastian Rios »

Christine Berry wrote:
Aaron Goldsmith wrote:
Christine Berry wrote:In excel I make a couple columns to the far right and use the "smallest" formulas

example:
=small(B1:G1,1) - 1st smallest
=small(B1:G1,2) - 2nd smallest
=small(B1:G1,3) - 3rd smallest

Then add those values up and subtract from event total.
You can probably just put (small(B1:G1,1)) in the actual calc formulas instead of doing it externally, but it's kinda neat to see the lowest.

Hmm, very true, less cells and clean. :thumbup: But I also try to avoid long formulas because I tend to get them wrong and then have to go troubleshooting. This way I can see which step I screwed up on. :D
Cool! I just learned a new excel trick. :ugeek:
User avatar
Michael Palero
King of Fastrack!
Posts: 951
Joined: Thu May 15, 2008 11:25 am
Club: SCNAX
Car#: 18
Location: San Gabriel Valley & Long Beach
Contact:

Re: YTD Points totals

Post by Michael Palero »

"excel points drop sum blah blah blah"

Awesome! ME100L and ME232 are finally coming back to me...
Post Reply