From: Martin Halder <martin.halder@gmail.com>
To: nicholas.dokos@hp.com, Russell Adams <RLAdams@AdamsInfoServ.Com>
Cc: emacs-orgmode@gnu.org
Subject: Re: table spreadsheet problem
Date: Mon, 19 Mar 2012 17:25:08 +0100 [thread overview]
Message-ID: <E73C1C45-7980-4E14-A878-C7216050401A@gmail.com> (raw)
In-Reply-To: <17453.1332172608@alphaville>
Am 19.03.2012 um 16:56 schrieb Nick Dokos:
> Russell Adams <RLAdams@AdamsInfoServ.Com> wrote:
>
>> On Mon, Mar 19, 2012 at 04:01:42PM +0100, Martin Halder wrote:
>>> Hi all,
>>>
>>> question about table calculation. Found in the documentation that I could refer to e.g. first line after second hline with @II+2.
>>>
>>> Would like to calculate sum = vsum(@I..@II) and tax = sum * 0.08
>>>
>>> Am I doing sth wrong ?
>>>
>>> Thanks for help,
>>> Martin
>>>
>>> | article | price |
>>> |---------+--------|
>>> | item1 | 100.00 |
>>> | item2 | 200.00 |
>>> |---------+--------|
>>> | sum | |
>>> | tax | |
>>> |---------+--------|
>>> | sum | 0 |
>>> #+TBLFM: @II+1$2=vsum(@I..@II);f2N::@II+2$2=@II+1$2*0.08;f2N::@>$2=vsum(@II..@III);f2N
>>>
>>>
>>
>> | article | price |
>> |---------+--------|
>> | item1 | 100.00 |
>> | item2 | 200.00 |
>> |---------+--------|
>> | sum | 300.00 |
>> | tax | 24.00 |
>> |---------+--------|
>> | sum | 324.00 |
>> #+TBLFM: @4$2=vsum(@-I..@-II);%.2f::@5$2=@4$2*0.08;%.2f::@6$2=vsum(@-I..@-II);%.2f
>>
>> I often use negative headline references for total lines in order to
>> sum backward from the current cell.
>>
>> So vsum(@-I..@-II);%.2f means sum the cells between the first headline
>> above the current cell to the second headline above the current cell,
>> and then format the result as a decimal with two decimal places
>> (%.2f).
>>
>> Looking at your formula, I think you manually wrote the TBLFM
>> line. One thing I've found is that the TBLFM line doesn't support
>> relative references for the cell specification, only in the formula.
>>
>> I used C-u C-c = to set mine.
>>
>
> Nowadays, you can use (both on the LHS and the RHS of the formula)
> symbolic references relative to the first, second, third ... row like
> this: @<, @<<, @<< ... and relative to the last, penultimate,
> antepenultimate (is there such a word?) row like this: @>, @>>, @>>>
> ..., and similarly for columns, so you could write the formula, like
> this:
>
> #+TBLFM: @>>>$>=vsum(@-I..@-II);%.2f::@>>$>=@>>>$>*0.08;%.2f::@>$>=vsum(@-I..@-II);%.2f
>
> This *does* require iterated evaluations, so C-u C-u C-c C-c is your
> best bet, to make sure everything is updated properly.
>
> Nick
>
that is fantastic, many thanks for you help to you both.
Martin
>> Good luck!
>>
>> ------------------------------------------------------------------
>> Russell Adams RLAdams@AdamsInfoServ.com
>>
>> PGP Key ID: 0x1160DCB3 http://www.adamsinfoserv.com/
>>
>> Fingerprint: 1723 D8CA 4280 1EC9 557F 66E8 1154 E018 1160 DCB3
>>
>
next prev parent reply other threads:[~2012-03-19 16:25 UTC|newest]
Thread overview: 104+ messages / expand[flat|nested] mbox.gz Atom feed top
2009-09-08 20:41 Correct Way to Customize LaTeX Export? Peter Jones
2009-09-08 20:49 ` Russell Adams
[not found] ` <RLAdams@AdamsInfoServ.Com>
2009-09-08 21:11 ` Nick Dokos
2009-10-30 3:17 ` [OT] lisp func to write timestamp to buffer Nick Dokos
2011-07-24 15:58 ` Table formula to convert hex to dec Nick Dokos
2012-01-25 17:34 ` ICS import? Russell Adams
2012-01-25 17:50 ` Nick Dokos
[not found] ` <CALRk1sZc5JL_zY8Xnt+XDZfgqMmtQb4XXia4UmrP4f4sdOopCw@mail.gmail.com>
[not found] ` <3023.1327520270@alphaville>
[not found] ` <CALRk1sZ9YC9ftvB4wK84i4-68FF3kYPwhuYm9n=iwvsKerRMRQ@mail.gmail.com>
[not found] ` <4180.1327526628@alphaville>
2012-01-25 22:26 ` Matthew Sauer
2012-01-25 23:51 ` Russell Adams
2012-01-26 0:03 ` Arun Persaud
2012-01-26 0:21 ` Nick Dokos
2012-01-26 0:58 ` Russell Adams
2012-03-15 19:56 ` Latex Listings & Floats Nick Dokos
2012-03-19 15:56 ` table spreadsheet problem Nick Dokos
2012-03-19 16:05 ` Russell Adams
2012-03-19 16:25 ` Martin Halder [this message]
2012-03-19 17:42 ` Nick Dokos
2012-03-19 17:54 ` Russell Adams
2012-03-19 18:01 ` Nick Dokos
2012-03-19 18:21 ` Russell Adams
2012-05-15 2:57 ` ICS import? Nick Dokos
2012-05-15 3:03 ` Nick Dokos
2012-08-10 6:41 ` [Orgmode] Re: contact management in org-mode? Nick Dokos
2012-08-10 11:40 ` Sriram Karra
2012-08-10 14:03 ` Nick Dokos
2012-11-21 22:06 ` Babel source blocks Nick Dokos
2012-11-21 22:15 ` Russell Adams
2012-11-21 22:44 ` Nick Dokos
2012-11-21 22:53 ` Russell Adams
-- strict thread matches above, loose matches on Subject: below --
2009-10-07 0:17 contact management in org-mode? Lindsay Todd
2009-10-07 2:21 ` Maurizio Vitale
2009-10-07 4:16 ` Bernt Hansen
2009-10-25 2:34 ` Russell Adams
2009-10-25 6:04 ` Charles Philip Chan
2009-10-25 13:51 ` Darlan Cavalcante Moreira
2009-10-25 14:14 ` Charles Philip Chan
2009-10-25 14:18 ` Richard Riley
2009-10-25 14:22 ` Russell Adams
2009-10-29 7:58 ` Eric S Fraga, Eric S Fraga
2009-10-29 15:46 ` Gregory J. Grubbs
2009-10-29 16:00 ` Richard Riley
2009-10-29 17:36 ` Russell Adams
2009-10-29 20:00 ` Alan E. Davis
2009-10-29 22:25 ` Eric S Fraga
2009-10-30 8:48 ` Uwe Jochum
2009-10-31 3:10 ` Russell Adams
2009-10-31 3:26 ` Russell Adams
2009-10-31 16:38 ` Gregory J. Grubbs
2009-11-20 14:32 ` Russell Adams
2012-07-19 11:10 ` [Orgmode] " Russell Adams
2012-07-20 0:57 ` Karl Voit
2012-08-08 12:04 ` Thomas Koch
2012-08-08 12:14 ` Bastien
2012-08-09 11:31 ` Jose E. Marchesi
2012-08-10 5:48 ` Russell Adams
2012-08-13 22:24 ` Semantics, Tagging, File systems, Tools, tagstore (was: [Orgmode] Re: contact management in org-mode?) Karl Voit
2012-08-09 12:04 ` [Orgmode] Re: contact management in org-mode? Sriram Karra
2009-11-02 10:37 ` Eric S Fraga, Eric S Fraga
2009-11-08 5:59 ` Ben Finney
2009-11-08 14:52 ` Matt Lundin
2009-11-08 22:22 ` Sebastian Rose
2009-11-11 13:19 ` Sebastian Rose
2009-11-09 6:41 ` Gour
2009-11-15 20:50 ` Sean Sieger
2009-10-31 21:54 ` Shelagh Manton
2009-10-08 17:13 ` Sean Sieger
2009-10-29 23:29 [OT] lisp func to write timestamp to buffer Marcelo de Moraes Serpa
2009-10-30 0:47 ` Russell Adams
2009-10-30 2:44 ` Nick Dokos
2009-10-30 2:53 ` Russell Adams
2011-02-27 1:36 Startup page Matthew Sauer
2011-02-27 2:57 ` Dan Davison
2011-02-28 20:35 ` Eric S Fraga
2011-02-27 10:15 ` Bastien
2011-02-27 14:03 ` Christian Mandel
2011-02-28 11:51 ` Konrad Hinsen
2011-03-11 5:59 ` Ido Magal
2011-03-11 7:56 ` Rainer M Krug
[not found] ` <improv.philosophy@gmail.com>
2011-03-06 2:49 ` Bug: Org-Contacts.el [7.4] U-SWEETSAUERPORT\Matthew Sauer
2011-03-06 4:47 ` Nick Dokos
2011-03-06 19:50 ` Matthew Sauer
2011-03-06 20:02 ` Matthew Sauer
2011-03-06 23:20 ` Bastien
2011-03-07 1:26 ` Matthew Sauer
2011-03-07 17:32 ` Achim Gratz
2011-03-16 16:19 ` Re: [Orgmode] Startup page Matthew Sauer
2011-03-16 16:45 ` Nick Dokos
2011-03-17 10:34 ` Matthew Sauer
2011-03-17 10:52 ` Filippo A. Salustri
2011-03-17 22:17 ` Matthew Sauer
2011-03-17 22:48 ` Nick Dokos
2011-03-18 0:03 ` Filippo A. Salustri
2011-03-18 0:08 ` Bastien
2011-03-18 0:22 ` Matthew Sauer
2011-07-24 8:00 Table formula to convert hex to dec Russell Adams
2011-07-24 9:52 ` Michael Brand
2011-07-24 16:39 ` Michael Brand
2012-03-15 17:45 Latex Listings & Floats Russell Adams
2012-03-15 20:33 ` Sebastien Vauban
2012-03-19 15:01 table spreadsheet problem Martin Halder
2012-03-19 15:32 ` Russell Adams
2012-03-19 15:45 ` Martin Halder
2012-03-19 15:48 ` Russell Adams
2012-11-21 21:15 Babel source blocks Russell Adams
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://www.orgmode.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=E73C1C45-7980-4E14-A878-C7216050401A@gmail.com \
--to=martin.halder@gmail.com \
--cc=RLAdams@AdamsInfoServ.Com \
--cc=emacs-orgmode@gnu.org \
--cc=nicholas.dokos@hp.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
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).