# Org Table Spreadsheet

— Kaushal ModiMy notes on Org Table Spreadsheet feature.

Table of Contents

## 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.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.