From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric Schulte <schulte.eric@gmail.com>
Subject: Re: sum up variables from different org-mode tables
Date: Mon, 19 Nov 2012 14:21:32 -0700
Message-ID: <87vcd170gz.fsf@gmail.com>
References: <CAJkULmktbtUYOnZbhf_VLbhHoh8fiJca_6uOFK2qr7nDT0O+8Q@mail.gmail.com>
	<CALn3zoi4oyakLiKNshvqzmO8os6LySEaSPPn2Rg8x2L3Rrr80g@mail.gmail.com>
	<CAJkULmko4YdGDzHnceNe3OwSYcCky0rNMB3u3Nf+5aogDPaO9w@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="=-=-="
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:33109)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1TaYls-0004mI-0U
	for emacs-orgmode@gnu.org; Mon, 19 Nov 2012 16:20:49 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1TaYlq-0006ec-Hm
	for emacs-orgmode@gnu.org; Mon, 19 Nov 2012 16:20:47 -0500
Received: from mail-ie0-f169.google.com ([209.85.223.169]:41672)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <schulte.eric@gmail.com>) id 1TaYlq-0006eN-8b
	for emacs-orgmode@gnu.org; Mon, 19 Nov 2012 16:20:46 -0500
Received: by mail-ie0-f169.google.com with SMTP id 10so9260415ied.0
	for <emacs-orgmode@gnu.org>; Mon, 19 Nov 2012 13:20:45 -0800 (PST)
In-Reply-To: <CAJkULmko4YdGDzHnceNe3OwSYcCky0rNMB3u3Nf+5aogDPaO9w@mail.gmail.com>
	(Martin Gross's message of "Mon, 19 Nov 2012 12:54:59 +0100")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=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: Martin Gross <m-gross@gmx.net>
Cc: Michael Brand <michael.ch.brand@gmail.com>, Org Mode <emacs-orgmode@gnu.org>

--=-=-=
Content-Type: text/plain

Martin Gross <m-gross@gmx.net> writes:

> Dear Michael,
>
> thank you very much, this is what I was looking for.  I myself
> supposed the answer should be related to "remote references", but was
> not sure how to use them.
>
> Just one point is not yet optimum to me: I do not have just 2 tables,
> but hundreds.  It would be hard and not very clean to add them all one
> by one.  Do you know if it there is a better way to reference remote
> tables?

Not a pure Org-mode solution, but something like the attached could be
used to sum up a particular column from every table in a file.  Not
flexible but possibly sufficient.


--=-=-=
Content-Type: text/x-org
Content-Disposition: inline; filename=multiple-tables.org

#+Title: Example 

* one table
| 1 |  2 |
| 2 |  4 |
| 3 |  6 |
| 4 |  8 |
| 5 | 10 |

* another table
| 20 | 20 |

* and one more
| 0 | 1 |
| 0 | 1 |

* here we sum them up
#+begin_src sh :results scalar :var file=(buffer-file-name) :var col=1
  cat $file|grep "^|"|sed 's/|//g'|awk '{ sum += $1} END{ print sum }'
#+end_src

#+RESULTS:
: 35

--=-=-=
Content-Type: text/plain


> For example telling org-mode to search data from all tables but "this"
> one?
>

With a little more work and one more sed command this could stop
processing the file at a particular line or keyword.

Hope this helps,

>
> Best regards,
>
> Martin
>

-- 
Eric Schulte
http://cs.unm.edu/~eschulte

--=-=-=--