Cal Club Autocross Forums

Name of the game is not winning, its consistancy.

http://spreadsheets.google.com/pub?key= ... lTBlF3fmYA" onclick="window.open(this.href);return false;

If you see any mistakes please tell me. Enough of this is done by hand that I am sure that I screwed up somewhere

I have also added the class points for PAX, PAXL, BSP, STU, and SM

Actually, I'd have to say it's winning consistently

Kurt Rahn wrote:Actually, I'd have to say it's winning consistently

Just ask Rick Jung.

Updated to include the Aug/NOTLD event.

http://spreadsheets.google.com/pub?key= ... lTBlF3fmYA" onclick="window.open(this.href);return false;

The sheet is now sorted by the W/ 2 Drops column because we have had 8 events so we will have at least 2 drops

Woo hoo! Holding steady in 106th!

Christine Berry wrote:Name of the game is not winning, its consistancy.

http://spreadsheets.google.com/pub?key= ... lTBlF3fmYA" onclick="window.open(this.href);return false;

If you see any mistakes please tell me. Enough of this is done by hand that I am sure that I screwed up somewhere

Christine, e-mail me offline as there should be an easier (database-driven) way to do this.

Actually, after playing with excel formulas for a while it is now mostly done by formulas, not by hand.

=small(...)
=vlookup( ...)
=iserror(...)
=if(...)

are my new friends

only way to speed up the process now is to have Rick output the PAX results with just: number and indexed time.

Christine Berry wrote:Actually, after playing with excel formulas for a while it is now mostly done by formulas, not by hand.

=small(...)
=vlookup( ...)
=iserror(...)
=if(...)

are my new friends

only way to speed up the process now is to have Rick output the PAX results with just: number and indexed time.

If he does that, wouldn't Xcel be able to link to a database of names? I'd think the results could be exported tab or comma delimited, too.

Bob Beamesderfer wrote:

Christine Berry wrote:Actually, after playing with excel formulas for a while it is now mostly done by formulas, not by hand.

=small(...)
=vlookup( ...)
=iserror(...)
=if(...)

are my new friends

only way to speed up the process now is to have Rick output the PAX results with just: number and indexed time.

If he does that, wouldn't Xcel be able to link to a database of names? I'd think the results could be exported tab or comma delimited, too.

thanks Christine...now if i can figure out what the heck you guy's are talking about

Chuck Fowler wrote:

Bob Beamesderfer wrote:

Christine Berry wrote:Actually, after playing with excel formulas for a while it is now mostly done by formulas, not by hand.

=small(...)
=vlookup( ...)
=iserror(...)
=if(...)

are my new friends

only way to speed up the process now is to have Rick output the PAX results with just: number and indexed time.

If he does that, wouldn't Xcel be able to link to a database of names? I'd think the results could be exported tab or comma delimited, too.

thanks Christine...now if i can figure out what the heck you guy's are talking about

vlookup is a table to "look up" values hence the name "vlookup". "is error", "if" (self-explanatory). "small" is basically "floor" or "rounding down to the nearest thousandth".

I should've kept going on Frontier and PERL scripting. I also used to know how to write GREP expressions.

At least I can still look at fundamental HTML and know what's happening or not happening.

Bob Beamesderfer wrote:I should've kept going on Frontier and PERL scripting. I also used to know how to write GREP expressions.

If you know PERL, you can get a job in I.T. writing it (Unix is the platform).

Giovanni Jaramillo wrote:

Bob Beamesderfer wrote:I should've kept going on Frontier and PERL scripting. I also used to know how to write GREP expressions.

If you know PERL, you can get a job in I.T. writing it (Unix is the platform).

I know; never got far enough; it's not an easy language, quite verbose. Frontier was much more elegant and fairly powerful, ran on Mac or Windows, but it's now outdated. Frontier's author, Dave Winer, created the first blog software.

You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.

Steve Ekstrand wrote:You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.

MUMPS at the Mayo Clinic? Is that some sort of joke?

I haven't heard of MUMPS and my father and brother both were quite active in the languages for their respective jobs. Well, my brother still is. ;)

Mike

Either it's this:

http://en.wikipedia.org/wiki/MUMPS" onclick="window.open(this.href);return false;

Or Steve was one sickly child. Who became a sicko adult.

Mike Simanyi wrote:

Steve Ekstrand wrote:You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.

MUMPS at the Mayo Clinic? Is that some sort of joke?

I haven't heard of MUMPS and my father and brother both were quite active in the languages for their respective jobs. Well, my brother still is. ;)

Mike

Steve's right. There was a language called "MUMPS", along with Ada, Fortran, Pascal, Assembly, PL/1, Smalltalk, C, C++, C# (aka C Sharp), Java, PL/SQL, Perl, etc...........

I am certainly not a programer so almost everything you guys have said has gone over my head.

However, Gio, in excel the small formula takes a range and returns the smallest values in it. Its the way I calculate the drops.

I developed a system to collect laboratory testing equipment results and add it to a patient database basically automating what had previously been a manual process. It worked pretty well til we could no longer buy PC's with cassette ports. I used the cassette ports as a programmable on-off switch for the lab equipment. It was pretty basic... I'd prefer to describe it as elegant. The DEC engineers said it couldn't be done for less than the GDP of a small country. 4 months later we invited them back.... They offered me a job. I thought I could make more money as an attorney. MUMPS was actually a very good language to use for the project, its sort of what it was designed for originally.

Steve Ekstrand wrote:...I could make more money marrying an attorney.

Fixed that for ya. }:)

Giovanni Jaramillo wrote:

Mike Simanyi wrote:

Steve Ekstrand wrote:You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.

MUMPS at the Mayo Clinic? Is that some sort of joke?

I haven't heard of MUMPS and my father and brother both were quite active in the languages for their respective jobs. Well, my brother still is. ;)

Mike

Steve's right. There was a language called "MUMPS", along with Ada, Fortran, Pascal, Assembly, PL/1, Smalltalk, C, C++, C# (aka C Sharp), Java, PL/SQL, Perl, etc...........

You forgot Cobol and RPG II. [ex IBM System 3 Models 10 and 15 operator here.] I wonder what a 370 mainframe goes for these days? Probably less than the scrap price.

Other than BASIC, I first started programming in FORTH on my Rockwell AIM-65.

Christine Berry wrote:I am certainly not a programer so almost everything you guys have said has gone over my head.

However, Gio, in excel the small formula takes a range and returns the smallest values in it. Its the way I calculate the drops.

That was my guess but now I remember! I had to do this to calculate the year-end averages back when I was using Tony Payne's scripts and only the word "AVG" was in the excel spreadsheet. Then at the end of the year I had to calculate and it used the function called "small".

Which in Oracle the function is called "least" and you provide it a set of values. The opposite would be "greatest".

You're an engineer by trade like me, just a different specialty (mechanical vs. software), so you would pickup programming easily Christine. Which aero company are you with Raytheon, or Boeing?

Raytheon