From mboxrd@z Thu Jan 1 00:00:00 1970 From: Michael Brand Subject: Re: Insert calc vector directly into spreadsheet cells? Date: Mon, 26 May 2014 22:43:39 +0200 Message-ID: References: <87vbt04gq3.fsf@bzg.ath.cx> <7D34B671-E545-4AAF-A704-07D45B9A4715@acumeniacal.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:60826) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Wp1kE-0006dL-1E for emacs-orgmode@gnu.org; Mon, 26 May 2014 16:43:43 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Wp1kC-0005JK-U6 for emacs-orgmode@gnu.org; Mon, 26 May 2014 16:43:41 -0400 Received: from mail-qg0-x235.google.com ([2607:f8b0:400d:c04::235]:53537) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Wp1kC-0005J9-NH for emacs-orgmode@gnu.org; Mon, 26 May 2014 16:43:40 -0400 Received: by mail-qg0-f53.google.com with SMTP id f51so12586145qge.12 for ; Mon, 26 May 2014 13:43:39 -0700 (PDT) In-Reply-To: <7D34B671-E545-4AAF-A704-07D45B9A4715@acumeniacal.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Steven Adrian Cc: Org Mode Hi Steven On Mon, May 26, 2014 at 9:39 PM, Steven Adrian 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