* Fun with name fields and recalculation in org tables See http://orgmode.org/org.html#Advanced-features |---+---------+--------+--------+--------+-------+-------| | | Student | Prob 1 | Prob 2 | Prob 3 | Total | Note | |---+---------+--------+--------+--------+-------+-------| | ! | | P1 | P2 | P3 | Tot | | | # | Maximum | 11 | 15 | 1000 | 1026 | 205.2 | | ^ | | m1 | m2 | m3 | mt | | |---+---------+--------+--------+--------+-------+-------| | # | Peter | 10 | 8 | -10 | 8 | 1.6 | | # | Sam | 2 | 6 | 3 | 11 | 2.2 | |---+---------+--------+--------+--------+-------+-------| | | Average | | | | 9.5 | | | ^ | | | | | at | | | $ | max=50 | | | | | | |---+---------+--------+--------+--------+-------+-------| #+TBLFM: $6=vsum($P1..$P3)::$7=10*$Tot/$max;%.1f::$at=vmean(@-II..@-I);%.1f