[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
## Re: [O] Insert calc vector directly into spreadsheet cells?

**From**: |
Michael Brand |

**Subject**: |
Re: [O] Insert calc vector directly into spreadsheet cells? |

**Date**: |
Mon, 26 May 2014 22:43:39 +0200 |

Hi Steven
On Mon, May 26, 2014 at 9:39 PM, Steven Adrian <address@hidden> wrote:
>* This is great. I wish I had seen this earlier. I did not know about*
>* the subscr function, but I had basically gotten to the same point by*
>* writing an equivalent custom calc function.*
With the Calc function defmath? How does it look like?
>* 1. I wrote a custom calc function called tailsInARow that uses the*
>* calc random function to simulate a coin toss and return the number*
>* of tails in a row. I used this function to fill a 20x20 table of*
>* values. I then used the calc histogram function in a table formula*
>* to read the table values, histogram the number of tails in a row,*
>* then write the histogram to a new table.*
Didn't know that Calc has a histogram function. The histogram values
would fit perfectly to the ASCII plot within an Org table:
http://orgmode.org/worg/org-contrib/orgtbl-ascii-plot.html
>* 2. I calculated a rotation matrix as a succession of individual*
>* rotations about x, y, and z axes. I then wrote the resulting matrix*
>* to a table. I then wrote a table function to read the matrix, take*
>* the inverse, and write the result to a new table.*
Interesting. How does the "function to read the matrix" look like?
Michael