From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: remote ref in spreadsheets
Date: Wed, 21 Jan 2015 22:12:30 +0100
Message-ID: <CALn3zojjT6Wj3gHe86wTudM72msVHo1hrmNibvrmTHNma-CeLg@mail.gmail.com>
References: <9ae5pbxf26.ln2@news.c0t0d0s0.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:49973)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1YE2Zj-0006Fh-Kd
	for emacs-orgmode@gnu.org; Wed, 21 Jan 2015 16:12:32 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1YE2Zi-0008Jr-MV
	for emacs-orgmode@gnu.org; Wed, 21 Jan 2015 16:12:31 -0500
Received: from mail-qg0-x22a.google.com ([2607:f8b0:400d:c04::22a]:48546)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1YE2Zi-0008Ja-I2
	for emacs-orgmode@gnu.org; Wed, 21 Jan 2015 16:12:30 -0500
Received: by mail-qg0-f42.google.com with SMTP id q107so23361128qgd.1
	for <emacs-orgmode@gnu.org>; Wed, 21 Jan 2015 13:12:30 -0800 (PST)
In-Reply-To: <9ae5pbxf26.ln2@news.c0t0d0s0.de>
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: Michael Welle <mwe012008@gmx.net>
Cc: Org Mode <emacs-orgmode@gnu.org>

Hi Michael

On Wed, Jan 21, 2015 at 9:20 PM, Michael Welle <mwe012008@gmx.net> wrote:
> @2$2=remote(BC_2014,@II$3)
> @3$2=remote(BC_2013,@II$3)
> @4$2=remote(BC_2012,@II$3)
> [...]
> would be nice to use a column formula, something like remote($1,@II$3),
> where $1 of the master table holds the name of the referenced table.

It was also January when I needed this for yearly tables the first
time :-) and I implemented and documented it with an ERT and in the
manual one year ago. It is still available only in Org release_8.3beta
which you seem not to have installed yet.

If you do an aggregation, in this case by year, then Thierry Banel's
package Org aggregate
https://github.com/tbanel/orgaggregate
is very convenient as it can simplify a lot.

Michael