From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Re: Help on spreadsheet/calc references and improvements Date: Sat, 5 Oct 2013 18:08:18 +0200 Message-ID: <2013-10-05T18-02-18@devnull.Karl-Voit.at> References: <2013-10-05T16-39-57@devnull.Karl-Voit.at> Reply-To: news1142@Karl-Voit.at Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:38110) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VSUPE-0001Fk-SA for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 12:08:42 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1VSUP8-0000Vm-Ss for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 12:08:36 -0400 Received: from plane.gmane.org ([80.91.229.3]:37009) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1VSUP8-0000Vi-Lk for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 12:08:30 -0400 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1VSUP7-0004vX-GI for emacs-orgmode@gnu.org; Sat, 05 Oct 2013 18:08:29 +0200 Received: from mail.michael-prokop.at ([88.198.6.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 05 Oct 2013 18:08:29 +0200 Received: from news1142 by mail.michael-prokop.at with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sat, 05 Oct 2013 18:08:29 +0200 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 * Michael Brand wrote: > Hi Karl Hi! > You may want to look at the example "$3 = remote(FOO, @@#$2)" in the > Org manual, then it becomes quite simple. :-) I have to admit that I found @@#$2 in the manual. However, I was not able to understand its meaning at all :-( With your example below, I begin to understand it a bit. Thanks! >> #+NAME: Data23vert >> | Descr+ | Data1+ | Data2+ | >> |--------+--------+--------| >> | foo | 12 | 10 | >> | bar | 22 | 24 | >> | baz | 16 | 17 | >> |--------+--------+--------| >> | sum | 50 | 51 | > >| Descr | Data2 | Double | >|-------+-------+--------| >| foo | 10 | 20 | >| bar | 24 | 48 | >| baz | 17 | 34 | >|-------+-------+--------| >| sum | 51 | 102 | > #+TBLFM: $2 = remote(Data23vert, @@#$3) :: $3 = 2 * remote(Data23vert, @@#$3) May I add another example I cannot cope with? | Descr | Current Data2+ | diff | abs.diff | |-------+----------------+------+----------| | foo | 9 | -1 | 1 | | bar | 20 | -4 | 4 | | baz | 23 | +6 | 6 | |-------+----------------+------+----------| | sum | 52 | | 11 | $2 are manually entered values to compare Data2 from above. I still have no idea how to adopt your reference example for $3 and $4. Would you please help me one more time? >> #+NAME: Data23horiz >> | Descr+ | foo | bar | baz | sum | >> |--------+-----+-----+-----+-----| >> | Data1+ | 12 | 22 | 16 | 50 | >> | Data2+ | 10 | 24 | 17 | 51 | > >| Descr | foo | bar | baz | sum | >|--------+-----+-----+-----+-----| >| Data2 | 10 | 24 | 17 | 51 | >| Double | 20 | 48 | 34 | 102 | > #+TBLFM: @2$2..@2$5 = remote(Data23horiz, @3$$#) :: @3$2..@3$5 = 2 * > remote(Data23horiz, @3$$#) Helped me a lot, thanks! ("$$#" is not mentioned in the Org-manual at all.) -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: > get Memacs from https://github.com/novoid/Memacs < https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github