Emacs, scripting and anything text oriented.

My notes on Org Table Spreadsheet feature.
Kaushal Modi

## 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.16.850.1469938244.271.60
79185.96.780.1469760084.271.59
64041.05.480.1470670314.271.28
15452.51.320.0344567131.001.32
11675.71.000.0344601621.001.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.
• `\$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.2f` i.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.

## References #

If you have written a response to this, enter your response post's URL below.

Or, you can send a "comment" webmention (it's OK if you don't know what that means). When asked about your website on an IndieAuth login screen, simply type `https://commentpara.de`.

Markdown Support`**`bold`**`, `_`italics`_`, `~~`strikethrough`~~`, `[`descr`]``(`link`)`, ````monospace````, ``````LANG``\nline1\nline2\n`````` (Yep, multi-line code blocks too, with syntax highlighting!), auto-hyperlinking.