[ale] OpenOffice spreadsheet

[James P. Kinney III]

I got it. It's not elegant, but it works.

There is a RANK function . So the line looks like:

=((IF(RANK(G2;G2:N2;1)<6;G2;0))+(IF(RANK(H2;G2:N2;1)<6;H2;0))+...)

For the values that are non-numerical (student didn't show up for the
quiz) the rank function pukes, so I replaced the "X" with a -.0001.  It
also pukes when the cell is empty. So bogus values go in until the kids
get their own (bogus) values to have entered.

On Thu, 2002-12-05 at 11:21, Sean Kilpatrick wrote:
> On Thursday 05 December 2002 10:59 am, James P. Kinney III wrote:
> > My gut reaction is to dump it to a shell/perl script, but I'm being
> > stubborn about learning how to actually use a spreadsheet.
> 
> There _ought_ to be a sort function. Sort the numbers into a temporary
> row and then do an *add* function on the first (or last) five.
>  I'll hunt around for the Excel command and let you know.
> 
> Sean
> 
> 
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://www.ale.org/mailman/listinfo/ale
-- 
James P. Kinney III   \Changing the mobile computing world/
President and CEO      \          one Linux user         /
Local Net Solutions,LLC \           at a time.          /
770-493-8244             \.___________________________./

GPG ID: 829C6CA7 James P. Kinney III (M.S. Physics) <jkinney at localnetsolutions.com>
Fingerprint = 3C9E 6366 54FC A3FE BA4D 0659 6190 ADC3 829C 6CA7 



 This is a digitally signed message part