Unofficial 2008 Overall PAX Standings, 08/08/08

[Christine Grice]

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]

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

[Kurt Rahn]

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

[Aaron Goldsmith]

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

Just ask Rick Jung.

[Christine Grice]

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

[Kurt Rahn]

Woo hoo! Holding steady in 106th!

[Giovanni Jaramillo]

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.

[Christine Grice]

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.

[Bob Beamesderfer]

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.

[Chuck Fowler]

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

[Giovanni Jaramillo]

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

[Bob Beamesderfer]

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.

[Giovanni Jaramillo]

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

[Bob Beamesderfer]

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.

[Steve Ekstrand]

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

[Mike Simanyi]

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

[Bob Beamesderfer]

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.

[Giovanni Jaramillo]

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

[Christine Grice]

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.

[Steve Ekstrand]

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.

[Will Kalman]

...I could make more money marrying an attorney.

Fixed that for ya. }:)

[Bob Beamesderfer]

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.

[Steve Ekstrand]

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

[Giovanni Jaramillo]

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?

[Christine Grice]

Raytheon