At Tue, 4 May 2010 16:35:07 +0200,
Johan Ekh <ekh.johan@gmail.com> wrote:
> 
> [1  <multipart/alternative (7bit)>]
> [1.1  <text/plain; ISO-8859-1 (7bit)>]
> That sounds very good! This is the functionality I am looking for!
> Would you like to share your yasnippet and any other settings that you have
> worked out?
> It would help me alot!
> 
> Thanks!
> 
> Johan
> 
> On Tue, May 4, 2010 at 10:36 AM, Darlan Cavalcante Moreira <
> darcamo@gmail.com> wrote:
> 
> >
> > For that I just use separate tables. I use a headline for each month, say
> > "May 2010" and subheadings for each category (groceries, bills, transport,
> > etc.) with a corresponding table in each one. Each table calculates the
> > total for that category and has a unique name, say "BillsMay2010".
> >
> > All of the totals for each table are concatenated in a table
> > "ExpensesMay2010" (also in a subheadings of the month headline) that has
> > one line for each category and calculates the total. There is even gnuplot
> > code with org-babel to plot the amount spent in each category from the
> > "ExpensesMay2010" table.
> >
> > Of course there is a snippet (with yasnippet) for all of this and in the
> > first day of the month I call the snippet and only provide the month name
> > and the year (both used to make the name of each table unique). This
> > snippet makes easy creating all the infrastructure for each month and org
> > speedkeys makes easy navigating the categories to quickly add
> > something.
> >
> > This works very well and I only need to be careful and update each table
> > (C-u C-u C-c *) when I make some change.
> >
> > Darlan
> >
> > At Tue, 4 May 2010 08:36:05 +0200,
> > Johan Ekh <ekh.johan@gmail.com> wrote:
> > >
> > > Thanks Dan!
> > > My idea was to go through a long imported table and quickly categorize
> > the
> > > different rows
> > > into a number of predefined categories, without having to actually type
> > the
> > > category for
> > > each row. Can I do that?
> > >
> > > If babel is a way, I think I would prefer to use python as I am familiar
> > > with it. But I have not used
> > > it with babel, is that possible?
> > >
> > > Best regards,
> > > Johan
> > >
> > >
> > > On Mon, May 3, 2010 at 10:52 PM, Dan Davison <davison@stats.ox.ac.uk>
> > wrote:
> > >
> > > > Johan Ekh <ekh.johan@gmail.com> writes:
> > > >
> > > > > Hi all,
> > > > > I wonder if it is possible to tag rows in a table?
> > > > >
> > > > > For example, if  I have a table of expenses, i.e. columns with
> > "date",
> > > > "note" and "sum",
> > > > > and then want to group the entries into different categories such as
> > > > "groceries", "car" etc.
> > > > >
> > > > > Can I do this someway?
> > > >
> > > > Hi Johan,
> > > >
> > > > You can't attach metadata such as tags to table rows. Two things come
> > to
> > > > mind.
> > > >
> > > > 1. If you just want the table for visual purposes (as opposed for doing
> > > >   calculations with it), then you could use column-view. I.e. you would
> > > >   have a subtree for groceries and a subtree for car; categories such
> > > >   as date, note and sum would be stored in properties.
> > > >
> > > > http://orgmode.org/manual/Column-view.html#Column-view
> > > >
> > > > Visibility cycling works in column view so you can group and ungroup
> > the
> > > > rows.
> > > >
> > > > [is there anyway of creating a normal Org table from a column view
> > > > "table"?]
> > > >
> > > > 2. org-babel: If you're happy with a suitable supported language, then
> > > >   store the category label in a column and you can transform the master
> > > >   table however you want. R would be a convenient language for working
> > > >   with a table like this.
> > > >
> > > > Dan
> > > >
> > > >
> > > >
> > > > >
> > > > > Best regards,
> > > > > Johan
> > > > >
> > > > > _______________________________________________
> > > > > Emacs-orgmode mailing list
> > > > > Please use `Reply All' to send replies to the list.
> > > > > Emacs-orgmode@gnu.org
> > > > > http://lists.gnu.org/mailman/listinfo/emacs-orgmode
> > > >
> >
> [1.2  <text/html; ISO-8859-1 (quoted-printable)>]
> 
> [2  <text/plain; us-ascii (7bit)>]
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode