From mboxrd@z Thu Jan  1 00:00:00 1970
From: michael.zombok@googlemail.com
Subject: Recursive formulaes in org-mode tables
Date: Tue, 13 Oct 2015 17:35:52 +0200
Message-ID: <sousi5eeq7b.fsf@gmx.de>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:50424)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Zm1cu-0008WT-I6
	for emacs-orgmode@gnu.org; Tue, 13 Oct 2015 11:36:33 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Zm1cp-0000Jm-JP
	for emacs-orgmode@gnu.org; Tue, 13 Oct 2015 11:36:32 -0400
Received: from plane.gmane.org ([80.91.229.3]:34770)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Zm1cp-0000IB-DG
	for emacs-orgmode@gnu.org; Tue, 13 Oct 2015 11:36:27 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Zm1cm-0002l3-6h
	for emacs-orgmode@gnu.org; Tue, 13 Oct 2015 17:36:24 +0200
Received: from x4d0db57f.dyn.telefonica.de ([77.13.181.127])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 13 Oct 2015 17:36:24 +0200
Received: from michael.zombok by x4d0db57f.dyn.telefonica.de with local
	(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Tue, 13 Oct 2015 17:36:24 +0200
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: emacs-orgmode@gnu.org

Hi,

I have the following table:

| Year (Beginn) |    Price | Increase |
|---------------+----------+----------|
|          2016 | 20000.00 |  1000.00 |
|          2017 |          |  1000.00 |
|          2018 |          |  1000.00 |
|          2019 |          |  1000.00 |
|          2020 |          |  1000.00 |
|          2021 |          |  1000.00 |
|          2022 |          |  1000.00 |
|          2023 |          |  1000.00 |
|          2024 |          |  1000.00 |
|          2025 |          |  1000.00 |
|          2026 |          |  1000.00 |
|          2027 |          |  1000.00 |
|          2028 |          |  1000.00 |
|          2029 |          |  1000.00 |
|          2030 |          |  1000.00 |
|---------------+----------+----------|

I want to compute the price recursively such that the final table looks
like this:

| Year (Beginn) |    Price | Increase |
|---------------+----------+----------|
|          2016 | 20000.00 |  1000.00 |
|          2017 | 22000.00 |  1000.00 |
|          2018 | 24000.00 |  1000.00 |
|          2019 | 26000.00 |  1000.00 |
|          2020 | 28000.00 |  1000.00 |
|          2021 | 30000.00 |  1000.00 |
|          2022 | 32000.00 |  1000.00 |
|          2023 | 34000.00 |  1000.00 |
|          2024 | 36000.00 |  1000.00 |
|          2025 | 38000.00 |  1000.00 |
|          2026 | 40000.00 |  1000.00 |
|          2027 | 42000.00 |  1000.00 |
|          2028 | 44000.00 |  1000.00 |
|          2029 | 46000.00 |  1000.00 |
|          2030 | 48000.00 |  1000.00 |
|---------------+----------+----------|
After reading a related SO question I tried the formula

#+TBLFM: @<<<..>$2=@<<..>>$2+2*$3

but it doesn't work. It gives an error and also seems to operate on
column one instead of the specified column two. Any idea how to
correctly compute column two? I am using org-mode version 8.2.5c with
Emacs version 24.5.1.

Disclaimer: I posted this question also on Stack Overflow:

http://stackoverflow.com/questions/33063425/recursive-formulaes-in-org-mode-tables

Feel free to answer here or there.

Thanks!

Best,
Michael