emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* 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

* Re: Help with column formula in radiotable
  2014-08-31  7:45 ` Thorsten Grothe
@ 2014-10-12 12:19   ` Bastien
  0 siblings, 0 replies; 7+ messages in thread
From: Bastien @ 2014-10-12 12:19 UTC (permalink / raw)
  To: Thorsten Grothe; +Cc: emacs-orgmode

Hi Thorsten,

Thorsten Grothe <info@th-grothe.de> writes:

> No one an idea?

Let's have a habit of waiting at least two days before
bumping a thread.  Thanks!

-- 
 Bastien

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