* [ANN] orgtbl-aggregate version 2
@ 2015-01-09 21:38 Thierry Banel
0 siblings, 0 replies; only message in thread
From: Thierry Banel @ 2015-01-09 21:38 UTC (permalink / raw)
To: emacs-orgmode
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
^ permalink raw reply [flat|nested] only message in thread
only message in thread, other threads:[~2015-01-09 21:38 UTC | newest]
Thread overview: (only message) (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2015-01-09 21:38 [ANN] orgtbl-aggregate version 2 Thierry Banel
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/emacs/org-mode.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).