Thanks Darlan!! I will try this as soon as I can. Best regards, Johan On Wed, May 5, 2010 at 11:27 AM, Darlan Cavalcante Moreira < darcamo@gmail.com> wrote: > > The snippet is attached. > > In my case I call the snippet inside a 2-level heading (also using odd > number of start for each level) and you will probably want to modify the > snippet to your needs. > > The snippet only asks the name of the current month, the current year and > the name of the last month. I suppose this could be completely automatic if > you know how to get this information with lisp. > > Darlan > > > > > > At Tue, 4 May 2010 16:35:07 +0200, > Johan Ekh wrote: > > > > [1 ] > > [1.1 ] > > 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 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 > > > > wrote: > > > > > > > > > Johan Ekh 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 ] > > > > [2 ] > > _______________________________________________ > > 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 > >