From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric Abrahamsen Subject: Re: table formula help... Date: Sun, 07 Dec 2014 10:05:11 +0800 Message-ID: <87a9306wq0.fsf@ericabrahamsen.net> References: <87ppbxfi5f.fsf@ericabrahamsen.net> <54838805.8090705@free.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:34392) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XxR8P-0002xD-B0 for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 20:59:46 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1XxR8K-0003yo-G8 for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 20:59:41 -0500 Received: from plane.gmane.org ([80.91.229.3]:59498) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1XxR8K-0003ye-9I for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 20:59:36 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1XxR8I-00064o-Pr for emacs-orgmode@gnu.org; Sun, 07 Dec 2014 02:59:34 +0100 Received: from 61.149.185.27 ([61.149.185.27]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 07 Dec 2014 02:59:34 +0100 Received: from eric by 61.149.185.27 with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Sun, 07 Dec 2014 02:59:34 +0100 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 Thierry Banel writes: > To elaborate on Michael's first suggestion, > we will first give a name ("work") to the table: > > #+TBLNAME: work > | Chars | Lines | Translator | > > |-------+-------+-----------------| > | | 84 | Austin Woerner | > | 6633 | | Eric Abrahamsen | > | 16984 | | Canaan Morse | > | | 24 | Lucas Klein | > | | 10 | Lucas Klein | > > Then typing C-c C-x i and answering the wizard questions, > we get a new table as follow: > > #+BEGIN: aggregate :table "work" :cols "Translator sum(Chars) sum(Lines)" > | Translator | sum(Chars) | sum(Lines) | > > |-----------------+------------+------------| > | Austin Woerner | NA | 84 | > | Eric Abrahamsen | 6633 | NA | > | Canaan Morse | 16984 | NA | > | Lucas Klein | 2 NA | 34 | > #+END: > > Whenever you change the "work" table, > you can easily refresh the aggregated table by typing C-c C-c Whoa, that's really intense, going to play with it for a bit... Thanks! > To install the orgtbl-aggregate module, > add those lines to your .emacs: > > (require 'package) > (add-to-list 'package-archives '("melpa" . > "http://melpa.milkbox.net/packages/") t) > (package-initialize) > > Then type M-x package-list-packages > and install orgtbl-aggregate > > Have fun > Thierry > > > > Le 06/12/2014 09:05, Michael Brand a écrit : >> Hi Eric >> >> On Sat, Dec 6, 2014 at 6:42 AM, Eric Abrahamsen wrote: >>> #+NAME: counts >>> | Piece | Chars | Lines | Translator | >>> +----------------+--------+-------+------------------+ >>> | 凤凰 | | 84 | Austin Woerner | >>> | 王血 | 6633 | | Eric Abrahamsen | >>> | 赵氏孤儿 | 16984 | | Canaan Morse | >>> | 山鬼故家 | | 24 | Lucas Klein | >>> | 寂静何其深沉 | | 10 | Lucas Klein | >>> >>> And the second: >>> >>> #+NAME: payments >>> #+CONSTANTS: prose=0.7 poetry=10 >>> | Translator | Total Chars | Total Lines | Payment | >>> |------------------+-------------+-------------+---------| >>> | Austin Woerner | | | | >>> | Eric Abrahamsen | | | | >>> | Canaan Morse | | | | >>> | Lucas Klein | | | | >> Thierry Banel recently announced orgaggregate: >> http://lists.gnu.org/archive/cgi-bin/namazu.cgi?idxname=emacs-orgmode&max=100&sort=date:late&query=%2Bsubject:"%5BANN%5D+Aggregate+Table" >> >> For a solution with only built-in functionality see the example >> test-org-table/org-lookup-all in the Org source file >> testing/lisp/test-org-table.el >> http://orgmode.org/w/org-mode.git?p=org-mode.git;a=blob;f=testing/lisp/test-org-table.el >> >> Michael >> >>