emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* getting calc-units working in table formulas
@ 2014-12-16  4:21 Eric Abrahamsen
  2014-12-16  6:33 ` Eric Abrahamsen
  2014-12-16 13:06 ` Michael Brand
  0 siblings, 2 replies; 9+ messages in thread
From: Eric Abrahamsen @ 2014-12-16  4:21 UTC (permalink / raw)
  To: emacs-orgmode

I've been playing with calc-units, and it's pretty amazing. See all the
units with `calc-view-units-table'.

Some calc-units stuff works out the box (maybe have to require
calc-units?), I think this should be mentioned in the manual:

| distance | time   | speed       |
|----------+--------+-------------|
| 3 km     | 2.5 hr | 1.2 km / hr |
#+TBLFM: @2$3=$1/$2

Who knew it could do that?! Probably everyone but me... It doesn't need
the constants.el package, and looks nicer in the input, to boot.

calc-units makes a few of its functions available via defmath:

| speed        | simplified speed |
|--------------+------------------|
| 40km / 2.5hr | 16. km / hr      |
|              |                  |
#+TBLFM: @2$2=usimplify($1)

But it's got a lot more tricks. I think unit conversion would be very
handy to have, but there's something I'm not getting about using
defmath. For instance, this works:

| km    |      ft |
|-------+---------|
| 2.5km | 8202.10 |
#+TBLFM: $2='(calc-eval (math-convert-units (calc-eval $1 'raw) (calc-eval "ft" 'raw))); %.2f

But this doesn't:

#+BEGIN_SRC emacs-lisp
  (defmath uconvert (expr target-units)
    (math-convert-units expr target-units))
#+END_SRC

| km    | ft                  |
|-------+---------------------|
| 2.5km | uconvert(2.5 km ft) |
#+TBLFM: $2=uconvert($1 ft)

I can't tell if I've written the calcFunc thing wrong, or if it's
somehow not getting installed correctly. I've tried several variants,
and they mostly all just give me the results above.

Does anyone know what I'm doing wrong?

Also, once that's figured out, wouldn't it be handy if Org came with a
few predefined units-related math functions? It would be a tiny bit of
code, for quite a bit more power.

At the very least, I'd like to provide a patch to the manual to make the
units stuff a little more explicit...

Eric

^ permalink raw reply	[flat|nested] 9+ messages in thread

end of thread, other threads:[~2014-12-21  4:17 UTC | newest]

Thread overview: 9+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2014-12-16  4:21 getting calc-units working in table formulas Eric Abrahamsen
2014-12-16  6:33 ` Eric Abrahamsen
2014-12-16 13:06 ` Michael Brand
2014-12-17  1:09   ` Eric Abrahamsen
2014-12-17  6:39     ` Michael Brand
2014-12-17  7:02       ` Eric Abrahamsen
2014-12-18 10:07         ` [PATCH] " Eric Abrahamsen
2014-12-20 16:33           ` Nicolas Goaziou
2014-12-21  4:22             ` Eric Abrahamsen

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).