Is it possible to feed data from an org table into calc as a matrix, and then get it out again as a vector to fill in a column?
For example, if I have:
| | Fund A | Fund B | Fund C | Combined |
| US | .1 | .8 | .5 | |
| Europe | .2 | .1 | .4 | |
| Pacific | .7 | .1 | .1 | |
| Weighting | .3 | .5 | .2 | |
I would like to use a calc formula to matrix-multiply the data from the first three rows of numbers by the (transposed) weighting in the last row of numbers, and insert the result in the final column, like this:
| | Fund A | Fund B | Fund C | Combined |
| US | .1 | .8 | .5 | .53 |
| Europe | .2 | .1 | .4 | .19 |
| Pacific | .7 | .1 | .1 | .28 |
| Weighting | .3 | .5 | .2 | |
I was hoping maybe something like this would achieve that if inserted in the top cell of the last column -- but this is incorrect: no output is produced in the table:
=($2@2..$2@4) * trn($4@2..$4..@4)
If it's not possible using calc, is it possible using elisp?