From mboxrd@z Thu Jan  1 00:00:00 1970
From: Cecil Westerhof <cldwesterhof@gmail.com>
Subject: Can this table formula be done more efficient
Date: Sun, 8 Jun 2014 12:19:15 +0200
Message-ID: <CAG-LmmD0sNL3KOi=fbbq3CRru4x1QwZhDuuxyULkeBPThEjUvQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7bdc96c83bec5604fb506d1f
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:47660)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1WtaC5-0008UF-JH
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 06:19:18 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1WtaC4-0001qq-8m
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 06:19:17 -0400
Received: from mail-qg0-x236.google.com ([2607:f8b0:400d:c04::236]:57317)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <cldwesterhof@gmail.com>) id 1WtaC4-0001qa-5d
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 06:19:16 -0400
Received: by mail-qg0-f54.google.com with SMTP id q108so7492693qgd.41
	for <emacs-orgmode@gnu.org>; Sun, 08 Jun 2014 03:19:15 -0700 (PDT)
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

--047d7bdc96c83bec5604fb506d1f
Content-Type: text/plain; charset=UTF-8

At the moment I am using the following formula:
    #+TBLFM: @<<$4..@>>$4 = $2 - $3 :: @>$2=vsum(@<<$2..@>>$2) ::
@>$3=vsum(@<<$3..@>>$3) :: @>$4=vsum(@<<$4..@>>$4)

This does what I want, but there are two things that could be improved.

- The second, third and fourth formula do exactly the same, only on
different columns. Could this be rewritten to one formula?

- The line becomes long and hard to evaluate for a person. Is there a
possibility to put the formulas below each-other?

-- 
Cecil Westerhof

--047d7bdc96c83bec5604fb506d1f
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:courier =
new,monospace">At the moment I am using the following formula:<br>=C2=A0=C2=
=A0=C2=A0 #+TBLFM: @&lt;&lt;$4..@&gt;&gt;$4 =3D $2 - $3 :: @&gt;$2=3Dvsum(@=
&lt;&lt;$2..@&gt;&gt;$2) :: @&gt;$3=3Dvsum(@&lt;&lt;$3..@&gt;&gt;$3) :: @&g=
t;$4=3Dvsum(@&lt;&lt;$4..@&gt;&gt;$4)<br>
<br></div><div class=3D"gmail_default" style=3D"font-family:courier new,mon=
ospace">This does what I want, but there are two things that could be impro=
ved.<br></div><div class=3D"gmail_default" style=3D"font-family:courier new=
,monospace">
<br>- The second, third and fourth formula do exactly the same, only on dif=
ferent columns. Could this be rewritten to one formula?<br><br></div><div c=
lass=3D"gmail_default" style=3D"font-family:courier new,monospace">- The li=
ne becomes long and hard to evaluate for a person. Is there a possibility t=
o put the formulas below each-other?<br clear=3D"all">
</div><br>-- <br>Cecil Westerhof
</div>

--047d7bdc96c83bec5604fb506d1f--