Alan Schmitt <alan.schm...@polytechnique.org> writes: > | Name | Grade | Question 1 | Question 2 | Question 3 | > | Coeff | 6 | 1 | 3 | 2 | > |-------+-------+------------+------------+------------| > | Foo | | 1/2 | 1 | 1/4 | > | Bar | | 1 | 1 | 0 | > #+TBLFM: @2$2=vsum($3..$>) > > I would like the grade of Foo to be 10 * (1/2 * 1 + 1 * 3 + 1/4 * 2)/6 > and Bar to be 10 * (1 * 1 + 1 * 3 + 0 * 2)/6
both are ≈ 6.67. > Thanks, but I does not seem to do what I want. I prefer to keep the > coefficient in the column with the question name so that I can easily > know what it refers to when I adjust it. 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. –Rasmus -- When in doubt, do it!
