From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric Abrahamsen <eric@ericabrahamsen.net>
Subject: Re: table formula help...
Date: Sat, 06 Dec 2014 16:32:48 +0800
Message-ID: <87fvct5gb3.fsf@ericabrahamsen.net>
References: <87ppbxfi5f.fsf@ericabrahamsen.net>
	<CALn3zogy-J5cSHUgOHmxpN2UH=g54QcU2=pqyAMGgMf1Pcd6Jg@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]:45784)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XxAkk-0002jZ-02
	for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 03:30:15 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XxAke-0008SS-UZ
	for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 03:30:09 -0500
Received: from plane.gmane.org ([80.91.229.3]:57636)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XxAke-0008Ri-OT
	for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 03:30:04 -0500
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1XxAke-0000SX-76
	for emacs-orgmode@gnu.org; Sat, 06 Dec 2014 09:30:04 +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 <emacs-orgmode@gnu.org>; Sat, 06 Dec 2014 09:30:04 +0100
Received: from eric by 61.149.185.27 with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sat, 06 Dec 2014 09:30:04 +0100
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

Michael Brand <michael.ch.brand@gmail.com> writes:

> Hi Eric
>
> On Sat, Dec 6, 2014 at 6:42 AM, Eric Abrahamsen <eric@ericabrahamsen.net> 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

Thanks to you and Thomas! From your answers, it appears I'm asking for
something more complicated than I thought. I'm going to see if I can
manage the solution by re-structuring the tables. Either way, I'll take
a look at the links and see what I can learn.

Thanks again,
Eric