Org Table Spreadsheet
— Kaushal ModiMy notes on Org Table Spreadsheet feature.
Table of Contents
Normalizing #
Table 1:
Org table Normalizing
Normalized col $1 | Normalized col $3 | Ratio of col $2 / $4 | ||
|---|---|---|---|---|
Col $1 | Col $2 | Col $3 | Col $4 | Col $5 |
| 79922.1 | 6.85 | 0.146993824 | 4.27 | 1.60 |
| 79185.9 | 6.78 | 0.146976008 | 4.27 | 1.59 |
| 64041.0 | 5.48 | 0.147067031 | 4.27 | 1.28 |
| 15452.5 | 1.32 | 0.034456713 | 1.00 | 1.32 |
| 11675.7 | 1.00 | 0.034460162 | 1.00 | 1.00 |
Equations Breakdown #
Equation: #+tblfm: $2=$1/@7$1;%0.2f::$4=$3/@7$3;%0.2f::$5=$2/$4;%0.2f
$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 (@7$1).@is row,$is column.- 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 ($4).;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 #
Do C-u C-c C-c with point anywhere in the table, or do C-c C-c
with point on the #+tblfm line.