From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jeffrey Brent McBeth Subject: org-table relative reference questions Date: Mon, 20 Apr 2015 09:35:28 -0400 Message-ID: <20150420133528.GB16503@broggs.org> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:45059) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YkBrh-0005KV-E2 for emacs-orgmode@gnu.org; Mon, 20 Apr 2015 09:35:58 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1YkBra-00039p-3v for emacs-orgmode@gnu.org; Mon, 20 Apr 2015 09:35:57 -0400 Received: from cdptpa-outbound-snat.email.rr.com ([107.14.166.230]:48882 helo=cdptpa-oedge-vip.email.rr.com) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1YkBrZ-00039H-Hz for emacs-orgmode@gnu.org; Mon, 20 Apr 2015 09:35:49 -0400 Received: from williwaw ([10.0.1.2]) by broggs.org with esmtp (Exim 4.82) (envelope-from ) id 1YkBrX-0006TL-66 for emacs-orgmode@gnu.org; Mon, 20 Apr 2015 09:35:47 -0400 Received: from localhost ([127.0.0.1] helo=broggs.org) by williwaw with esmtp (Exim 4.84_RC1) (envelope-from ) id 1YkBrE-0001WO-L7 for emacs-orgmode@gnu.org; Mon, 20 Apr 2015 09:35:28 -0400 Content-Disposition: inline List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 I'm looking for a way to reference a row or column on both the left side and right side of a table formula that is "easily" manipulable. At first, I thought the hline references would work for me @I..@II, except they cannot be used on the left side of an equation. I hoped that maybe named fields would work (^,_), but those are apparently value aliases and not location references. Essentially, I want to keep a single table in which I can enter and calculate data, and limit the computation to start at a given row that I change as I go along. Maybe I'm simply using the wrong tool for this, excel is certainly not capable; so if org-table isn't either, it certainly doesn't lessen it. #+BEGIN_EXAMPLE | F | A | B | C | |---+----+----+----| | _ | tA | tB | tC | | | 1 | 3 | 42 | | | 2 | 4 | 69 | |---+----+----+----| | # | | | | #+TBLFM=@>$2=vsum(@tA..@II)::$tC=$-2+$-1 | F | A | B | C | |---+----+----+----| | | 1 | 3 | 42 | | _ | tA | tB | tC | | | 2 | 4 | 69 | |---+----+----+----| | # | | | | #+TBLFM=@>$2=vsum(@tA..@II)::$tC=$-2+$-1 #+END_EXAMPLE -- "The man who does not read good books has no advantage over the man who cannot read them." -- Mark Twain