* Help with column formula in radiotable
@ 2014-08-30 15:28 Thorsten Grothe
2014-08-31 7:45 ` Thorsten Grothe
2014-08-31 7:53 ` Christian Moe
0 siblings, 2 replies; 7+ messages in thread
From: Thorsten Grothe @ 2014-08-30 15:28 UTC (permalink / raw)
To: emacs-orgmode
Hello,
I would like to assign a relative column formular for the 6 column (name
= BIPr).
The formular should start in the *second field* of column 3 (value = 12)
and multiply it with *first value of column* 4 (value = 2.8) etc. like this:
12 * 2.8
4 * 0.7
...
|---+------+-------+-------+-------+-------+---|
| ! | Jahr | Menge | Preis | BIPn | BIPr | W |
|---+------+-------+-------+-------+-------+---|
| # | 1 | 10 | 2.8 | 28.00 | 0 | |
| # | 2 | 12 | 0.7 | 8.40 | | |
| # | 3 | 4 | 4.00 | 16.00 | | |
|---+------+-------+-------+-------+-------+---|
| _ | | | | suma | sumb | |
| | | | | 52.40 | 16.00 | |
How can I do this?
Thanks in advance for your help!!
Regards
Thorsten Grothe
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Help with column formula in radiotable
2014-08-30 15:28 Help with column formula in radiotable Thorsten Grothe
@ 2014-08-31 7:45 ` Thorsten Grothe
2014-10-12 12:19 ` Bastien
2014-08-31 7:53 ` Christian Moe
1 sibling, 1 reply; 7+ messages in thread
From: Thorsten Grothe @ 2014-08-31 7:45 UTC (permalink / raw)
To: emacs-orgmode
No one an idea?
Regards
Thorsten Grothe
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Help with column formula in radiotable
2014-08-30 15:28 Help with column formula in radiotable Thorsten Grothe
2014-08-31 7:45 ` Thorsten Grothe
@ 2014-08-31 7:53 ` Christian Moe
2014-08-31 7:59 ` Christian Moe
1 sibling, 1 reply; 7+ messages in thread
From: Christian Moe @ 2014-08-31 7:53 UTC (permalink / raw)
To: Thorsten Grothe; +Cc: emacs-orgmode
Hi,
You can reference the next row with @+1. If I understand your question
correctly, this works:
|---+------+-------+-------+-------+-------+---|
| ! | Jahr | Menge | Preis | BIPn | BIPr | W |
|---+------+-------+-------+-------+-------+---|
| # | 1 | 10 | 2.8 | 28.00 | 33.60 | |
| # | 2 | 12 | 0.7 | 8.40 | 2.80 | |
| # | 3 | 4 | 4.00 | 16.00 | 0.00 | |
|---+------+-------+-------+-------+-------+---|
| _ | | | | suma | sumb | |
| | | | | 52.40 | 36.4 | |
#+TBLFM: $6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III)
...but you may not want to calculate the last value, since there is no
"Menge" value to calculate it with. Something like this would calculate
only the first two rows:
#+TBLFM: @2$6..@3$6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III)
Yours,
Christian
Thorsten Grothe writes:
> Hello,
>
> I would like to assign a relative column formular for the 6 column (name
> = BIPr).
>
> The formular should start in the *second field* of column 3 (value = 12)
> and multiply it with *first value of column* 4 (value = 2.8) etc. like this:
>
> 12 * 2.8
> 4 * 0.7
> ...
>
> |---+------+-------+-------+-------+-------+---|
> | ! | Jahr | Menge | Preis | BIPn | BIPr | W |
> |---+------+-------+-------+-------+-------+---|
> | # | 1 | 10 | 2.8 | 28.00 | 0 | |
> | # | 2 | 12 | 0.7 | 8.40 | | |
> | # | 3 | 4 | 4.00 | 16.00 | | |
> |---+------+-------+-------+-------+-------+---|
> | _ | | | | suma | sumb | |
> | | | | | 52.40 | 16.00 | |
>
> How can I do this?
>
> Thanks in advance for your help!!
>
> Regards
> Thorsten Grothe
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Help with column formula in radiotable
2014-08-31 7:53 ` Christian Moe
@ 2014-08-31 7:59 ` Christian Moe
2014-08-31 8:14 ` Thorsten Grothe
2014-08-31 10:41 ` Thorsten Grothe
0 siblings, 2 replies; 7+ messages in thread
From: Christian Moe @ 2014-08-31 7:59 UTC (permalink / raw)
To: Thorsten Grothe, emacs-orgmode
Oops, I did misunderstand. I think this is what you wanted:
|---+------+-------+-------+-------+-------+---|
| ! | Jahr | Menge | Preis | BIPn | BIPr | W |
|---+------+-------+-------+-------+-------+---|
| # | 1 | 10 | 2.8 | 28.00 | 0 | |
| # | 2 | 12 | 0.7 | 8.40 | 33.60 | |
| # | 3 | 4 | 4.00 | 16.00 | 2.80 | |
|---+------+-------+-------+-------+-------+---|
| _ | | | | suma | sumb | |
| | | | | 52.40 | 36.4 | |
#+TBLFM: $6=$3*@-1$4;%.2f::@2$6=0::$sumb=vsum(@II..@III)
Here I add a formula to set the first row to 0.
Yours,
Christian
> Hi,
>
> You can reference the next row with @+1. If I understand your question
> correctly, this works:
>
> |---+------+-------+-------+-------+-------+---|
> | ! | Jahr | Menge | Preis | BIPn | BIPr | W |
> |---+------+-------+-------+-------+-------+---|
> | # | 1 | 10 | 2.8 | 28.00 | 33.60 | |
> | # | 2 | 12 | 0.7 | 8.40 | 2.80 | |
> | # | 3 | 4 | 4.00 | 16.00 | 0.00 | |
> |---+------+-------+-------+-------+-------+---|
> | _ | | | | suma | sumb | |
> | | | | | 52.40 | 36.4 | |
> #+TBLFM: $6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III)
>
> ...but you may not want to calculate the last value, since there is no
> "Menge" value to calculate it with. Something like this would calculate
> only the first two rows:
>
> #+TBLFM: @2$6..@3$6=@+1$3*$4;%.2f::$sumb=vsum(@II..@III)
>
> Yours,
> Christian
>
> Thorsten Grothe writes:
>
>> Hello,
>>
>> I would like to assign a relative column formular for the 6 column (name
>> = BIPr).
>>
>> The formular should start in the *second field* of column 3 (value = 12)
>> and multiply it with *first value of column* 4 (value = 2.8) etc. like this:
>>
>> 12 * 2.8
>> 4 * 0.7
>> ...
>>
>> |---+------+-------+-------+-------+-------+---|
>> | ! | Jahr | Menge | Preis | BIPn | BIPr | W |
>> |---+------+-------+-------+-------+-------+---|
>> | # | 1 | 10 | 2.8 | 28.00 | 0 | |
>> | # | 2 | 12 | 0.7 | 8.40 | | |
>> | # | 3 | 4 | 4.00 | 16.00 | | |
>> |---+------+-------+-------+-------+-------+---|
>> | _ | | | | suma | sumb | |
>> | | | | | 52.40 | 16.00 | |
>>
>> How can I do this?
>>
>> Thanks in advance for your help!!
>>
>> Regards
>> Thorsten Grothe
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Help with column formula in radiotable
2014-08-31 7:59 ` Christian Moe
@ 2014-08-31 8:14 ` Thorsten Grothe
2014-08-31 10:41 ` Thorsten Grothe
1 sibling, 0 replies; 7+ messages in thread
From: Thorsten Grothe @ 2014-08-31 8:14 UTC (permalink / raw)
To: emacs-orgmode
Am 31.08.2014 um 09:59 schrieb Christian Moe:
>
> Oops, I did misunderstand. I think this is what you wanted:
>
> |---+------+-------+-------+-------+-------+---|
> | ! | Jahr | Menge | Preis | BIPn | BIPr | W |
> |---+------+-------+-------+-------+-------+---|
> | # | 1 | 10 | 2.8 | 28.00 | 0 | |
> | # | 2 | 12 | 0.7 | 8.40 | 33.60 | |
> | # | 3 | 4 | 4.00 | 16.00 | 2.80 | |
> |---+------+-------+-------+-------+-------+---|
> | _ | | | | suma | sumb | |
> | | | | | 52.40 | 36.4 | |
> #+TBLFM: $6=$3*@-1$4;%.2f::@2$6=0::$sumb=vsum(@II..@III)
>
> Here I add a formula to set the first row to 0.
Christian, thank you for your help, I'm out now and will report later!!
Regards
Thorsten
^ permalink raw reply [flat|nested] 7+ messages in thread
* Re: Help with column formula in radiotable
2014-08-31 7:59 ` Christian Moe
2014-08-31 8:14 ` Thorsten Grothe
@ 2014-08-31 10:41 ` Thorsten Grothe
1 sibling, 0 replies; 7+ messages in thread
From: Thorsten Grothe @ 2014-08-31 10:41 UTC (permalink / raw)
To: emacs-orgmode
Am 31.08.2014 um 09:59 schrieb Christian Moe:
> Here I add a formula to set the first row to 0.
I testet your formular and it works fine! Thank you very much for your
help!!
Regards
Thorsten
^ permalink raw reply [flat|nested] 7+ messages in thread
end of thread, other threads:[~2014-10-12 12:19 UTC | newest]
Thread overview: 7+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2014-08-30 15:28 Help with column formula in radiotable Thorsten Grothe
2014-08-31 7:45 ` Thorsten Grothe
2014-10-12 12:19 ` Bastien
2014-08-31 7:53 ` Christian Moe
2014-08-31 7:59 ` Christian Moe
2014-08-31 8:14 ` Thorsten Grothe
2014-08-31 10:41 ` Thorsten Grothe
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).