Unofficial 2008 Overall PAX Standings, 08/08/08
Moderators: Mike Simanyi, Christine Grice, Rick Brown
- Christine Grice
- King of Fastrack!
- Posts: 1932
- Joined: Thu May 15, 2008 11:26 am
- Club: CASOC
- Car#: 17
Unofficial 2008 Overall PAX Standings, 08/08/08
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
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 Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
- Christine Grice
- King of Fastrack!
- Posts: 1932
- Joined: Thu May 15, 2008 11:26 am
- Club: CASOC
- Car#: 17
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
I have also added the class points for PAX, PAXL, BSP, STU, and SM
~Christine Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
Actually, I'd have to say it's winning consistently
==============
Oversteer is better than understeer because you don't see the tree you're hitting.
Oversteer is better than understeer because you don't see the tree you're hitting.
-
- Posts: 2663
- Joined: Wed May 14, 2008 4:22 pm
- Club: CASOC
- Car#: 32
- Location: HB, CA
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
Just ask Rick Jung.Kurt Rahn wrote:Actually, I'd have to say it's winning consistently
- Christine Grice
- King of Fastrack!
- Posts: 1932
- Joined: Thu May 15, 2008 11:26 am
- Club: CASOC
- Car#: 17
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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
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
~Christine Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
Woo hoo! Holding steady in 106th!
==============
Oversteer is better than understeer because you don't see the tree you're hitting.
Oversteer is better than understeer because you don't see the tree you're hitting.
-
- Posts: 2761
- Joined: Thu May 15, 2008 11:25 am
- Club: PSCC
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
Christine, e-mail me offline as there should be an easier (database-driven) way to do this.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 Grice
- King of Fastrack!
- Posts: 1932
- Joined: Thu May 15, 2008 11:26 am
- Club: CASOC
- Car#: 17
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.
=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 Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
-
- Posts: 3376
- Joined: Thu May 15, 2008 11:26 am
- Club: PSCC
- Location: Orange
- Contact:
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.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.
- Chuck Fowler
- Posts: 471
- Joined: Thu May 15, 2008 11:30 am
- Club: Team Blew
- Car#: 299
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
thanks Christine...now if i can figure out what the heck you guy's are talking aboutBob Beamesderfer wrote: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.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.
it's only paranoia if your wrong
-
- Posts: 2761
- Joined: Thu May 15, 2008 11:25 am
- Club: PSCC
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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".Chuck Fowler wrote:thanks Christine...now if i can figure out what the heck you guy's are talking aboutBob Beamesderfer wrote: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.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.
-
- Posts: 3376
- Joined: Thu May 15, 2008 11:26 am
- Club: PSCC
- Location: Orange
- Contact:
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.
At least I can still look at fundamental HTML and know what's happening or not happening.
-
- Posts: 2761
- Joined: Thu May 15, 2008 11:25 am
- Club: PSCC
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
If you know PERL, you can get a job in I.T. writing it (Unix is the platform).Bob Beamesderfer wrote:I should've kept going on Frontier and PERL scripting. I also used to know how to write GREP expressions.
-
- Posts: 3376
- Joined: Thu May 15, 2008 11:26 am
- Club: PSCC
- Location: Orange
- Contact:
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.Giovanni Jaramillo wrote:If you know PERL, you can get a job in I.T. writing it (Unix is the platform).Bob Beamesderfer wrote:I should've kept going on Frontier and PERL scripting. I also used to know how to write GREP expressions.
- 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: Unofficial 2008 Overall PAX Standings, 08/08/08
You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.
Dr. Conemangler
aka The Malefic One
2015 Wildcat Honda F600
aka The Malefic One
2015 Wildcat Honda F600
- Mike Simanyi
- Former Club Chair
- Posts: 2460
- Joined: Thu May 15, 2008 11:26 am
- Club: No$
- Car#: 6
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
MUMPS at the Mayo Clinic? Is that some sort of joke?Steve Ekstrand wrote:You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.
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
-
- Posts: 3376
- Joined: Thu May 15, 2008 11:26 am
- Club: PSCC
- Location: Orange
- Contact:
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.
http://en.wikipedia.org/wiki/MUMPS" onclick="window.open(this.href);return false;
Or Steve was one sickly child. Who became a sicko adult.
-
- Posts: 2761
- Joined: Thu May 15, 2008 11:25 am
- Club: PSCC
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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...........Mike Simanyi wrote:MUMPS at the Mayo Clinic? Is that some sort of joke?Steve Ekstrand wrote:You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.
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
- Christine Grice
- King of Fastrack!
- Posts: 1932
- Joined: Thu May 15, 2008 11:26 am
- Club: CASOC
- Car#: 17
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.
However, Gio, in excel the small formula takes a range and returns the smallest values in it. Its the way I calculate the drops.
~Christine Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
- 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: Unofficial 2008 Overall PAX Standings, 08/08/08
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.
Dr. Conemangler
aka The Malefic One
2015 Wildcat Honda F600
aka The Malefic One
2015 Wildcat Honda F600
- Will Kalman
- Posts: 1210
- Joined: Thu May 15, 2008 11:24 am
- Club: PSCC
- Car#: 232
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
Fixed that for ya. }:)Steve Ekstrand wrote:...I could make more money marrying an attorney.
-
- Posts: 3376
- Joined: Thu May 15, 2008 11:26 am
- Club: PSCC
- Location: Orange
- Contact:
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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.Giovanni Jaramillo wrote: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...........Mike Simanyi wrote:MUMPS at the Mayo Clinic? Is that some sort of joke?Steve Ekstrand wrote:You want outdated? I programmed in MUMPS for the Mayo Clinic in the early 80's as a teenager.
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 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: Unofficial 2008 Overall PAX Standings, 08/08/08
Other than BASIC, I first started programming in FORTH on my Rockwell AIM-65.
Dr. Conemangler
aka The Malefic One
2015 Wildcat Honda F600
aka The Malefic One
2015 Wildcat Honda F600
-
- Posts: 2761
- Joined: Thu May 15, 2008 11:25 am
- Club: PSCC
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
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".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.
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?
- Christine Grice
- King of Fastrack!
- Posts: 1932
- Joined: Thu May 15, 2008 11:26 am
- Club: CASOC
- Car#: 17
Re: Unofficial 2008 Overall PAX Standings, 08/08/08
Raytheon
~Christine Grice
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam
2006 Mitsubishi Evolution, Berry Family Racing/Hoosier/ChaseCam