emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Steven Adrian <sadrian@acumeniacal.com>
To: Michael Brand <michael.ch.brand@gmail.com>
Cc: Org Mode <emacs-orgmode@gnu.org>
Subject: Re: Insert calc vector directly into spreadsheet cells?
Date: Tue, 27 May 2014 05:12:01 -0400	[thread overview]
Message-ID: <94E4DBCE-2BEF-4766-A49F-D20DCE9ABB29@acumeniacal.com> (raw)
In-Reply-To: <CALn3zogFQfb-k+mi9LfVrfrmD=HfeZFpq83+xGb+NUVY5hMQhA@mail.gmail.com>


Here is the custom calc function that is similar to subscr. It will work for both vectors and matrices:

(defmath getElem (indices m)
  (let (i j)
    (if (vectorp indices)
        (setq i (cadr indices))
        (setq j (nth 2 indices))
        (nth j (nth i m))
        (setq i indices)
        (nth i m)

Here is the table function to get matrix data from a table, take the inverse, and write the result to a new table:

#+TBLFM: @1$1..@3$3=getElem([@#,$#],inv(arrange(remote(matrixTable,@1$2..@3$4),3))

Thanks for the tip about orgtbl-ascii-plot. I have been working on a set of notes about using calc and org mode that I am migrating over to read more like a tutorial, and I am now thinking about changing the histogram example to use orgtbl-ascii-plot instead of just writing the bin values in a table.


On May 26, 2014, at 4:43 PM, Michael Brand <michael.ch.brand@gmail.com> wrote:

> Hi Steven
> On Mon, May 26, 2014 at 9:39 PM, Steven Adrian <sadrian@acumeniacal.com> 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

  reply	other threads:[~2014-05-27  9:12 UTC|newest]

Thread overview: 7+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2014-05-17 21:40 Insert calc vector directly into spreadsheet cells? Steven Adrian
2014-05-20 15:23 ` Bastien
2014-05-21  7:29   ` Michael Brand
2014-05-26 19:39     ` Steven Adrian
2014-05-26 20:43       ` Michael Brand
2014-05-27  9:12         ` Steven Adrian [this message]
2014-05-27 18:06           ` Michael Brand

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=94E4DBCE-2BEF-4766-A49F-D20DCE9ABB29@acumeniacal.com \
    --to=sadrian@acumeniacal.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=michael.ch.brand@gmail.com \


* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox


This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).