From mboxrd@z Thu Jan  1 00:00:00 1970
From: Carl Bolduc <carlbolduc@gmail.com>
Subject: monthly budget with year summary using tables
Date: Wed, 2 Jan 2013 14:21:12 -0500
Message-ID: <CA+gsZcdZgLAQ3aWUjAJ5Ehc+6o8sM9dor2QFtga05WGYKU2Few@mail.gmail.com>
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b603d18734a1a04d2532774
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:53967)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <carlbolduc@gmail.com>) id 1TqTsf-0005JZ-AC
	for emacs-orgmode@gnu.org; Wed, 02 Jan 2013 14:21:41 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <carlbolduc@gmail.com>) id 1TqTsc-00042G-8M
	for emacs-orgmode@gnu.org; Wed, 02 Jan 2013 14:21:37 -0500
Received: from mail-ea0-f181.google.com ([209.85.215.181]:50679)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <carlbolduc@gmail.com>) id 1TqTsc-00041k-1G
	for emacs-orgmode@gnu.org; Wed, 02 Jan 2013 14:21:34 -0500
Received: by mail-ea0-f181.google.com with SMTP id k14so6086116eaa.40
	for <emacs-orgmode@gnu.org>; Wed, 02 Jan 2013 11:21:32 -0800 (PST)
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" <emacs-orgmode@gnu.org>

--047d7b603d18734a1a04d2532774
Content-Type: text/plain; charset=ISO-8859-1

I would like to move my budget from MS Excel to Org-Mode. I currently have
one Excel sheet per month with all the transactions as well as a summary
sheet that uses sumif functions.

Assuming the following format for the monthly table:

#+tblname: january
| date | transaction | amount | category  |
|------+-------------+--------+-----------|
|   01 | iga         |     50 | groceries |
|   01 | echo        |     30 | car       |
|   02 | iga         |     47 | groceries |

How can I get the following summary table?

| category  | january | february |
|-----------+---------+----------|
| groceries |      97 |          |
| car       |      30 |          |

I found this post on the mailing list that suggest to use babel:
http://www.mail-archive.com/emacs-orgmode@gnu.org/msg22736.html

However, I need help to understand how I can put the resulting sums inside
the summary table.

Thanks,
Carl

--047d7b603d18734a1a04d2532774
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I would like to move my budget from MS Excel to Org-Mode. =
I currently have one Excel sheet per month with all the transactions as wel=
l as a summary sheet that uses <span style class=3D"">sumif</span> function=
s.<br>

<br>Assuming the following format for the monthly table:<br><br>#+<span sty=
le class=3D"">tblname</span>: <span style class=3D"">january</span><br>| da=
te | transaction | amount | category =A0|<br>|------+-------------+--------=
+-----------|<br>

| =A0 01 | <span style class=3D"">iga</span> =A0 =A0 =A0 =A0 | =A0 =A0 50 |=
 groceries |<br>| =A0 01 | echo =A0 =A0 =A0 =A0| =A0 =A0 30 | car =A0 =A0 =
=A0 |<br>| =A0 02 | <span style class=3D"">iga</span> =A0 =A0 =A0 =A0 | =A0=
 =A0 47 | groceries |<br><br>How can I get the following summary table?<br>

<br>| category =A0| <span style class=3D"">january</span> | <span style cla=
ss=3D"">february</span> |<br>|-----------+---------+----------|<br>| grocer=
ies | =A0 =A0 =A097 | =A0 =A0 =A0 =A0 =A0|<br>| car =A0 =A0 =A0 | =A0 =A0 =
=A030 | =A0 =A0 =A0 =A0 =A0|<br>=A0<br>I found this post on the mailing lis=
t that suggest to use babel:<br>

<a href=3D"http://www.mail-archive.com/">http://www.mail-archive.com/</a><s=
pan style class=3D"">emacs</span>-<span style class=3D"">orgmode</span>@<a =
href=3D"http://gnu.org/msg22736.html">gnu.org/msg22736.html</a><br><br>Howe=
ver, I need help to understand how I can put the resulting sums inside the =
summary table.<br>

<br>Thanks,<br>Carl</div>

--047d7b603d18734a1a04d2532774--