[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Spreadsheet calculations (24.3/8.0-pre)
From: |
Oliver Večerník |
Subject: |
[O] Spreadsheet calculations (24.3/8.0-pre) |
Date: |
Mon, 18 Mar 2013 10:52:32 +0100 |
Hi,
I'm trying to do some simple calculations, but the results are plain
wrong. I started the minimal example with `emacs -Q -l minimal.emacs
org/minimal.org'. My Emacs is 24.3 with Org-mode version 8.0-pre
(release_8.0-pre-116-g65cde8 @ /home/ov/p/org-mode/lisp/):
#+TITLE: Nutrition Facts
#+CONSTANTS: b=100 j=4.182
#+TBLNAME: nf
| Product | kJ | kcal |
|-----------+------+------|
| Bread | 1372 | 328 |
| Butter | 3054 | 730 |
| Marmalade | 926 | 221 |
#+TBLFM: $3=$2/$j;%.0f
Here are some calculations per portion (plain wrong):
| Product | g | kJ | kcal |
|-----------+------+------+------|
| Bread | 50.6 | 658 | 157 |
| Butter | 11.5 | 150 | 36 |
| Marmalade | 19.7 | 256 | 61 |
|-----------+------+------+------|
| | | 1064 | 254 |
#+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@address@hidden))
'(remote(nf,@address@hidden))) 100));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II)
Expected:
| Product | g | kJ | kcal |
|-----------+------+------+------|
| Bread | 50.6 | 694 | 166 |
| Butter | 11.5 | 351 | 84 |
| Marmalade | 19.7 | 182 | 44 |
|-----------+------+------+------|
| | | 1227 | 294 |
#+TBLFM: $4=$3/$j;%.0f::@>$3..$4=vsum(@I..II)
Using the constant b is also totally wrong:
| Product | g | kJ | kcal |
|-----------+------+----+------|
| Bread | 50.6 | 0 | 0 |
| Butter | 11.5 | 0 | 0 |
| Marmalade | 19.7 | 0 | 0 |
|-----------+------+----+------|
| | | 0 | 0 |
#+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@address@hidden))
'(remote(nf,@address@hidden))) $b));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II)
These results are achieved using `C-c C-c' on the first column of the
format line. If I use `C-u C-c C-c' in the tabel I get different
results *every* time. E.g. pressing `C-u C-c C-c' three times on the
`B' of `Bread':
| Product | g | kJ | kcal |
|-----------+------+--------+-------|
| Bread | 50.6 | 32606 | 7784 |
| Butter | 11.5 | 59888 | 14297 |
| Marmalade | 19.7 | 110192 | 26306 |
|-----------+------+--------+-------|
| | | 202686 | 48387 |
#+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@address@hidden))
'(remote(nf,@address@hidden))) 100));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II)
If I go to the end of the format line and press `C-c C-c' I get totally
different results as at the beginning:
| Product | g | 1064 | 254 |
|-----------+------+------+------|
| Bread | 50.6 | 1064 | 254 |
| Butter | 11.5 | 1470 | 351 |
| Marmalade | 19.7 | 2790 | 666 |
|-----------+------+------+------|
| | | 5324 | 1271 |
#+TBLFM: $3='(* $2 (/ (org-lookup-first $1 '(remote(nf,@address@hidden))
'(remote(nf,@address@hidden))) 100));N%.0f::$4=$3/$j;%.0f::@>$3..$4=vsum(@I..II)
If I use `M-x org-table-recalculate-buffer-tables' even the headlines
get screwed up. Am I doing something wrong or are there severe problems
in the spreadsheet mode?
Thanks in advance!
--
Regards, Oliver
- [O] Spreadsheet calculations (24.3/8.0-pre),
Oliver Večerník <=