Rasmus writes: > So perhaps you'd want something like this > > | | Name | Grade | Question 1 | Question 2 | Question 3 | > | ! | | grade | q1 | | q3 | > | _ | | g | | | | > | / | Coeff | 6 | 1 | 3 | 2 | > |---+-----------+-----------+------------+------------+------------| > | * | Foo | 6.67 | 1/2 | 1 | 1/4 | > | * | Bar | 6.67 | 1 | 1 | 0 | > | * | Baz | 7.5 | 1 | 3/2 | -1/2 | > |---+-----------+-----------+------------+------------+------------| > | _ | | mean | | max | | > | | Mean | 6.9444445 | std.dev. | 0.48112521 | | > | $ | Constants | magic=10 | | | | > |---+-----------+-----------+------------+------------+------------| > #+TBLFM: $g=vsum($q1..$q3):: $3=round(@I-1$q1..@I-1$q3*$q1..$q3*$magic/$g,2):: > #+TBLFM: $mean=vmean(@I$grade..II$grade)::$max=vsdev(@I$grade..II$grade) > > It even exports pretty tables so you could hardly wish for more.
Thanks, this is great! I had no idea multiplying ranges would do the right thing. Thanks again, Alan
