I like what’s in OP. I will copy for sure.
For the record, I’ve found myself defining a function and using org-sbe instead, as often I want the data in the same table :
Here’s an example with a python formula, but you can use whatever
#+NAME: sampformula
#+BEGIN_SRC python :var angle=90 :var r=2 :exports none
from math import radians, cos
result = r*cos(radians(angle))
return result
#+END_SRC
| angle | r | x |
|-------+----+---------------|
| 30 | 10 | 8.66025403784 |
| 45 | 10 | 7.07106781187 |
| 60 | 10 | 5.0 |
#+TBLFM: $3='(org-sbe "sampformula" (angle $1) (r $2))
I like what’s in OP. I will copy for sure. For the record, I’ve found myself defining a function and using org-sbe instead, as often I want the data in the same table :
Here’s an example with a python formula, but you can use whatever