emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] Spreadsheet calculations (24.3/8.0-pre)


From: Christopher Allan Webber
Subject: Re: [O] Spreadsheet calculations (24.3/8.0-pre)
Date: Mon, 18 Mar 2013 10:03:48 -0500
User-agent: mu4e 0.9.9.5-dev5; emacs 24.1.50.1

I've posted here before about it, but it looks like you're trying to do
the same thing as I am; see https://gitorious.org/org-diet

Here's an example of an org-diet file entry:

| Food / Exercise                        | Calories | Quantity | Total |
|----------------------------------------+----------+----------+-------|
| thin & crispy flatbread                |       16 |        2 |    32 |
| tbsp neufchatel cheese spread          |       35 |        1 |    35 |
| tbsp apple butter                      |       30 |       .5 |    15 |
| tbsp jam                               |       50 |       .5 |    25 |
| Tea w/ agave & creamer                 |       40 |        1 |    40 |
| cedarlane eggplant parmesan            |      240 |        1 |   240 |
| goldfish cracker                       |        2 |       20 |    40 |
| bequet wrapped caramel                 |       48 |        1 |    48 |
| Beverage w/ sugar in the raw & creamer |       40 |        1 |    40 |
| pecan half                             |       10 |        3 |    30 |
| orange                                 |       62 |        1 |    62 |
| presliced aged swiss cheese            |       70 |        1 |    70 |
| starbucks tall latte low fat milk      |      109 |        1 |   109 |
| 1 pkt sugar in the raw                 |       20 |        1 |    20 |
| amy's cheese lasagna                   |      380 |        1 |   380 |
| baby carrot                            |        4 |        3 |    12 |
| cup low fat cottage cheese             |      180 |       .5 |    90 |
| tofutti cutie                          |      130 |        1 |   130 |
|----------------------------------------+----------+----------+-------|
| Total                                  |          |          |  1418 |
#+TBLFM: $4=$2*$3;%.0f::$LR4=vsum(@address@hidden)

That's not answering your question but might be useful given the type of
things you appear to be entering :)

Oliver Večerník writes:

> 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!




reply via email to

[Prev in Thread] Current Thread [Next in Thread]