Hi The List I am glad to announce the second version of the Org Aggregate package. It comes with more flexibility and performance, while being simpler.
This new version is based on a clever idea of Michael Brand. Thanks Michael for your reviews and suggestions. * What is it? ---------------------------------------------------- An aggregated Org table is derived from a source table by grouping rows and computing aggregations like sums and averages. Example: #+NAME: sourcetbl | Day | Color | Level | Quantity | |-----+-------+-------+----------| | Mon | Red | 30 | 11 | | Mon | Blue | 25 | 3 | | Thu | Red | 51 | 12 | | Thu | Red | 45 | 15 | | Thu | Blue | 33 | 18 | | Wed | Red | 27 | 23 | | Wed | Blue | 12 | 16 | | Wed | Blue | 15 | 15 | | Tur | Red | 39 | 24 | | Tur | Red | 41 | 29 | | Tur | Red | 49 | 30 | | Fri | Blue | 7 | 5 | | Fri | Blue | 6 | 8 | | Fri | Blue | 11 | 9 | #+BEGIN: aggregate :table sourcetbl :cols "Day vmean(Level);%.1f vsum(Quantity)" | Day | vmean(Level);%.1f | vsum(Quantity) | |-----+-------------------+----------------| | Mon | 27.5 | 14 | | Thu | 43.0 | 45 | | Wed | 18.0 | 54 | | Tur | 43.0 | 83 | | Fri | 8.0 | 22 | #+END * What is new? ---------------------------------------------------- The new version of Aggregate is designed to be seamless with the Org spreadsheet. - Aggregations formulas are now general Calc expressions, they can be as complex as: sqrt(vsum((X-vmean(X))^2)) - The modifiers are those of the spreadsheet, with exactly the same meaning (f3, NE, p24, %.6f and so on). - Spreadsheet formulas can further enrich an aggregation table, with the #+TBLFM line surviving refreshes. - Performance on large data sets has dramatically improved. Documentation here: https://github.com/tbanel/orgaggregate/blob/master/README.org * Install it! ---------------------------------------------------------- The easiest way to install it is through Melpa. Add those lines to your .emacs: (require 'package) (add-to-list 'package-archives '("melpa" . "http://melpa.milkbox.net/packages/";) t) (package-initialize) Type M-x package-list-packages Install orgtbl-aggregate * Happy new year! ------------------------------------------------------ Comments etc. welcome Happy new year, have fun, and stay tunned for more to come Thierry Banel
