Re: Spreadsheet FR

[Russell Adams <RLAdams@AdamsInfoServ.Com>]

On Fri, Apr 02, 2010 at 10:44:23AM -0400, Dan Davison wrote:
> How about keeping a master table containing all the information, and
> then generating narrowed views as separate tables? The babel way to do
> this would be to have a block function "filter-table" (provided below)
> and then call it where needed:
> 
> #+TBLNAME: lime-table
> | *Lime* | *Cost* |
> |--------+--------|
> | Y      |      1 |
> | Y      |      2 |
> | Y      |      2 |
> | N      |      3 |
> | N      |      4 |
> | Y      |      5 |
> | Total  |     17 |
> #+TBLFM: @8$2=vsum(@-I..@-II)
> 
> #+call: filter-table(table=lime-table, field=0, value="Y")
> 
> #+results: filter-table(table=lime-table, field=0, value="Y")
> | *Lime* | *Cost* |
> |--------+--------|
> | Y      |      1 |
> | Y      |      2 |
> | Y      |      2 |
> | Y      |      5 |
> 
> As you can see I got rid of a few horizontal separator lines, and we
> don't currently have totals. I'll suggest fixes for that below, but my
> main point is that although it may make sense to extend org-mode, it's
> already easy to do this in org-babel.

That's a better way to do it than properties in my opinion.

Whether extension was required or not, my only point was that for
small lists the only reason I still use OO or Excel was for the
ability to dynamically narrow a list.

Given org narrows outlines, I thought it might fit.

I'll have to play with babel now!

> OK, so I hard wired a 6 into the TBLFM line. Perhaps someone can tell me
> how to refer to the last line of the table. Also, it might be nice if
> babel could apply the table formula automaticaly after generating the
> table.

This is why I use @-I..@-II, the separators are your cues. There's an
LR symbol, but I don't use it often.

That alone is a good reason to make sure separator lines are preserved.

Thanks.

------------------------------------------------------------------
Russell Adams                            RLAdams@AdamsInfoServ.com

PGP Key ID:     0x1160DCB3           http://www.adamsinfoserv.com/

Fingerprint:    1723 D8CA 4280 1EC9 557F  66E8 1154 E018 1160 DCB3