From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nick Dokos <ndokos@gmail.com>
Subject: Re: Can this table formula be done more efficient
Date: Sun, 08 Jun 2014 07:53:01 -0400
Message-ID: <87tx7vk482.fsf@gmail.com>
References: <CAG-LmmD0sNL3KOi=fbbq3CRru4x1QwZhDuuxyULkeBPThEjUvQ@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 8bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:40238)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1WtbxF-0008WF-I3
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 08:12:13 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Wtbx8-0003KV-28
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 08:12:05 -0400
Received: from plane.gmane.org ([80.91.229.3]:44502)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Wtbx7-0003KJ-SG
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 08:11:58 -0400
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1Wtbgq-0007Ta-KT
	for emacs-orgmode@gnu.org; Sun, 08 Jun 2014 13:55:08 +0200
Received: from pool-98-110-160-12.bstnma.fios.verizon.net ([98.110.160.12])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 08 Jun 2014 13:55:08 +0200
Received: from ndokos by pool-98-110-160-12.bstnma.fios.verizon.net with local
	(Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 08 Jun 2014 13:55:08 +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

Cecil Westerhof <cldwesterhof@gmail.com> writes:

> 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?
>

--8<---------------cut here---------------start------------->8---
#+TBLFM: @<<$4..@>>$4 = $2 - $3 :: @>$2..$4=vsum(@<<$0..@>>$0)
--8<---------------cut here---------------end--------------->8---

See (info "(org) References")

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

I don't believe so but my belief may be out of date. It has been
discussed before: check the list archives.

-- 
Nick