Cal Club Autocross Forums

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.

Far as I know there aren't any year to date point totals yet, Rick said he was having some trouble with the software.

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.

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

Jay W

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!

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.

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

I'm going with South American dictator...

I was thinking Station Chief La Paz, Bolivia.

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.

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)

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.

Any update on the points?

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

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

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)

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.

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.

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:

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.

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

Christine for Secretary Points Keeper!

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

Cool! I just learned a new excel trick.

"excel points drop sum blah blah blah"

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