My notes on Org Table Spreadsheet feature.Kaushal Modi
|Normalized col ||Normalized col ||Ratio of col |
|Col ||Col ||Col ||Col ||Col |
Equations Breakdown #
$2=$1/@7$1– Assign the value of a field in column 2 (
$2) to the value of the field in column 1 in the same row (
$1) divided by the value of the field in row 7, column 1 (
- Row and column numbers start with 1 (not 0).
$4=$3/@7$3– Similar to above, but with different row/column numbers.
$5=$2/$4– Assign the value of a field in column 5 (
$5) to the value of the field in column 2 in the same row (
$2) divided by the value of the field in column 4 in the same row as well (
;is used to separate the equation from the formatting.
- For all the 3 equations, formatting is applied using
%0.2fi.e. the numbers will be formatted with 2 decimal places. See Field Formatters in Org table for more info.
- Each of those equations are applied to the same table by
concatenating them with
Evaluate the whole table #
C-u C-c C-c with point anywhere in the table, or do
with point on the