* Problem with table sums
@ 2010-02-23 22:08 Sébastien Vauban
2010-02-24 9:40 ` Carsten Dominik
0 siblings, 1 reply; 6+ messages in thread
From: Sébastien Vauban @ 2010-02-23 22:08 UTC (permalink / raw)
To: emacs-orgmode-mXXj517/zsQ
Hello,
I have such a table whose formatting is forced by someone more powerful than
me (my boss):
#+TBLNAME: etape1
| | Étape 1 | p.j | EUR HTVA |
|---+-------------------+-----+----------|
| | Prestations | 100 | 40000.00 |
| | Frais annexes | | 1280.00 |
| | Gestion du projet | | 3200.00 |
| | Licence | | 8000.00 |
|---+-------------------+-----+----------|
| | Total | | 52480.00 |
| ^ | | | Total |
#+TBLFM: @2$4=@2$3*400.00;%.2f::@3$4=@2$4*0.08*0.40;%.2f::@4$4=@2$4*0.08;%.2f::@5$4=@2$4*0.20;%.2f::@6$4=vsum(@-I..@-II);%.2f
It works as expected.
Though, I need to re-use some of the intermediate computations for another
"summary table". Therefore, I add names to some cells:
#+TBLNAME: etape1
| | Étape 1 | p.j | EUR HTVA |
|---+-------------------+-----+-----------------|
| | Prestations | 100 | 40000.00 |
| ^ | | pj | Prestations |
| | Frais annexes | | 1280.00 |
| ^ | | | FraisAnnexes |
| | Gestion du projet | | 3200.00 |
| ^ | | | GestionDuProjet |
| | Licence | | 8000.00 |
| ^ | | | Licence |
|---+-------------------+-----+-----------------|
| | Total | | 40000.00 |
| ^ | | | Total |
#+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%.2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-II);%.2f
Now, the total is wrong: it's the value of the first cell... Like if the `^'
prefix was simply dropped... and total limited to the first real figure.
Any reason for this phenomenon? Or workaround (other than describing every
cell to be summed)?
Best regards,
Seb
--
Sébastien Vauban
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode-mXXj517/zsQ@public.gmane.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Problem with table sums
2010-02-23 22:08 Problem with table sums Sébastien Vauban
@ 2010-02-24 9:40 ` Carsten Dominik
2010-02-24 15:40 ` Dan Davison
0 siblings, 1 reply; 6+ messages in thread
From: Carsten Dominik @ 2010-02-24 9:40 UTC (permalink / raw)
To: Sébastien Vauban; +Cc: emacs-orgmode
On Feb 23, 2010, at 11:08 PM, Sébastien Vauban wrote:
> Hello,
>
> I have such a table whose formatting is forced by someone more
> powerful than
> me (my boss):
>
> #+TBLNAME: etape1
> | | Étape 1 | p.j | EUR HTVA |
> |---+-------------------+-----+----------|
> | | Prestations | 100 | 40000.00 |
> | | Frais annexes | | 1280.00 |
> | | Gestion du projet | | 3200.00 |
> | | Licence | | 8000.00 |
> |---+-------------------+-----+----------|
> | | Total | | 52480.00 |
> | ^ | | | Total |
> #+TBLFM: @2$4=@2$3*400.00;%.2f::@3$4=@2$4*0.08*0.40;%.
> 2f::@4$4=@2$4*0.08;%.2f::@5$4=@2$4*0.20;%.2f::@6$4=vsum(@-I..@-II);%.
> 2f
>
> It works as expected.
>
> Though, I need to re-use some of the intermediate computations for
> another
> "summary table". Therefore, I add names to some cells:
>
> #+TBLNAME: etape1
> | | Étape 1 | p.j | EUR HTVA |
> |---+-------------------+-----+-----------------|
> | | Prestations | 100 | 40000.00 |
> | ^ | | pj | Prestations |
> | | Frais annexes | | 1280.00 |
> | ^ | | | FraisAnnexes |
> | | Gestion du projet | | 3200.00 |
> | ^ | | | GestionDuProjet |
> | | Licence | | 8000.00 |
> | ^ | | | Licence |
> |---+-------------------+-----+-----------------|
> | | Total | | 40000.00 |
> | ^ | | | Total |
> #+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%.
> 2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-II);
> %.2f
>
> Now, the total is wrong: it's the value of the first cell... Like if
> the `^'
> prefix was simply dropped... and total limited to the first real
> figure.
>
> Any reason for this phenomenon? Or workaround (other than
> describing every
> cell to be summed)?
Well, the reason is that the parser probably stops at the first text
when summing, it tries to add "Prestations".
I am afraid there is not good work-around for this.
- Carsten
>
> Best regards,
> Seb
>
> --
> Sébastien Vauban
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
- Carsten
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Problem with table sums
2010-02-24 9:40 ` Carsten Dominik
@ 2010-02-24 15:40 ` Dan Davison
2010-02-25 11:11 ` Carsten Dominik
0 siblings, 1 reply; 6+ messages in thread
From: Dan Davison @ 2010-02-24 15:40 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Sébastien Vauban, emacs-orgmode
Carsten Dominik <carsten.dominik@gmail.com> writes:
> On Feb 23, 2010, at 11:08 PM, Sébastien Vauban wrote:
[...]
>> Though, I need to re-use some of the intermediate computations for
>> another
>> "summary table". Therefore, I add names to some cells:
>>
>> #+TBLNAME: etape1
>> | | Étape 1 | p.j | EUR HTVA |
>> |---+-------------------+-----+-----------------|
>> | | Prestations | 100 | 40000.00 |
>> | ^ | | pj | Prestations |
>> | | Frais annexes | | 1280.00 |
>> | ^ | | | FraisAnnexes |
>> | | Gestion du projet | | 3200.00 |
>> | ^ | | | GestionDuProjet |
>> | | Licence | | 8000.00 |
>> | ^ | | | Licence |
>> |---+-------------------+-----+-----------------|
>> | | Total | | 40000.00 |
>> | ^ | | | Total |
>> #+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%.
>> 2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-II);
>> %.2f
>>
>> Now, the total is wrong: it's the value of the first cell... Like if
>> the `^'
>> prefix was simply dropped... and total limited to the first real
>> figure.
>>
>> Any reason for this phenomenon? Or workaround (other than
>> describing every
>> cell to be summed)?
>
> Well, the reason is that the parser probably stops at the first text
> when summing, it tries to add "Prestations".
>
> I am afraid there is not good work-around for this.
Hi Seb,
Well, I was going to suggest using org-babel. After playing around for a
while, I ended up reading the org manual on table formulas and coming
back to a pure org solution.
My simplest solution is almost straight out of the manual (which makes
me worry that I've missed the point of the question?):
#+TBLFM:@10$4='(apply '+ '(@-I..@-II));N
But seeing as I've got them, I may as well post my org-babel solutions.
Here's the first set of org-babel solutions, which are just like the
first solution, but use blocks to do the computation:
#+TBLFM:@10$4='(sbe my-sum-LANG (n (@-I..@-II)));N
where LANG is whatever language you want to compute the sum in:
#+function: my-sum-elisp(n)
#+begin_src emacs-lisp
(apply '+ n)
#+end_src
#+function: my-sum-R(n)
#+begin_src R
sum(n)
#+end_src
#+function: my-sum-python(n)
#+begin_src python
return sum(n)
#+end_src
The second set of org-babel solutions use org-babel to do the table
indexing. This was before I realised that I could use the @-I..@-II and
;N syntax in conjunction with the org-babel sbe macro. So these ones
have to deal with separating the numeric entries from the character
strings.
#+TBLFM:@10$4='(sbe my-tab-sum-LANG);%.2f
#+function: my-tab-sum-elisp
#+begin_src emacs-lisp :var tab=etape1[2:9,3]
(apply '+ (remq nil (mapcar (lambda (row) (if (numberp (car row)) (car row))) tab)))
#+end_src
#+function: my-tab-sum-R
#+begin_src R :var tab=etape1[2:9,3]
sum(as.numeric(tab[[1]]), na.rm=TRUE)
#+end_src
#+function: my-tab-sum-python
#+begin_src python :var tab=etape1[2:9,3]
flatten = lambda(lizt): sum(lizt, [])
return sum(filter(lambda x: isinstance(x, float), flatten(tab)))
#+end_src
Dan
>
> - Carsten
>
>>
>> Best regards,
>> Seb
>>
>> --
>> Sébastien Vauban
>>
>>
>>
>> _______________________________________________
>> Emacs-orgmode mailing list
>> Please use `Reply All' to send replies to the list.
>> Emacs-orgmode@gnu.org
>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>
> - Carsten
>
>
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Problem with table sums
2010-02-24 15:40 ` Dan Davison
@ 2010-02-25 11:11 ` Carsten Dominik
2010-03-01 0:37 ` Dan Davison
0 siblings, 1 reply; 6+ messages in thread
From: Carsten Dominik @ 2010-02-25 11:11 UTC (permalink / raw)
To: Dan Davison; +Cc: Sébastien Vauban, emacs-orgmode
:-) I should have known. These days, babel is the answer to most
questions ... :-)
- Carste
On Feb 24, 2010, at 4:40 PM, Dan Davison wrote:
> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
>> On Feb 23, 2010, at 11:08 PM, Sébastien Vauban wrote:
> [...]
>>> Though, I need to re-use some of the intermediate computations for
>>> another
>>> "summary table". Therefore, I add names to some cells:
>>>
>>> #+TBLNAME: etape1
>>> | | Étape 1 | p.j | EUR HTVA |
>>> |---+-------------------+-----+-----------------|
>>> | | Prestations | 100 | 40000.00 |
>>> | ^ | | pj | Prestations |
>>> | | Frais annexes | | 1280.00 |
>>> | ^ | | | FraisAnnexes |
>>> | | Gestion du projet | | 3200.00 |
>>> | ^ | | | GestionDuProjet |
>>> | | Licence | | 8000.00 |
>>> | ^ | | | Licence |
>>> |---+-------------------+-----+-----------------|
>>> | | Total | | 40000.00 |
>>> | ^ | | | Total |
>>> #+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%.
>>> 2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-II);
>>> %.2f
>>>
>>> Now, the total is wrong: it's the value of the first cell... Like if
>>> the `^'
>>> prefix was simply dropped... and total limited to the first real
>>> figure.
>>>
>>> Any reason for this phenomenon? Or workaround (other than
>>> describing every
>>> cell to be summed)?
>>
>> Well, the reason is that the parser probably stops at the first text
>> when summing, it tries to add "Prestations".
>>
>> I am afraid there is not good work-around for this.
>
> Hi Seb,
>
> Well, I was going to suggest using org-babel. After playing around
> for a
> while, I ended up reading the org manual on table formulas and coming
> back to a pure org solution.
>
> My simplest solution is almost straight out of the manual (which makes
> me worry that I've missed the point of the question?):
>
> #+TBLFM:@10$4='(apply '+ '(@-I..@-II));N
>
> But seeing as I've got them, I may as well post my org-babel
> solutions.
>
> Here's the first set of org-babel solutions, which are just like the
> first solution, but use blocks to do the computation:
>
> #+TBLFM:@10$4='(sbe my-sum-LANG (n (@-I..@-II)));N
>
> where LANG is whatever language you want to compute the sum in:
>
> #+function: my-sum-elisp(n)
> #+begin_src emacs-lisp
> (apply '+ n)
> #+end_src
>
> #+function: my-sum-R(n)
> #+begin_src R
> sum(n)
> #+end_src
>
> #+function: my-sum-python(n)
> #+begin_src python
> return sum(n)
> #+end_src
>
>
> The second set of org-babel solutions use org-babel to do the table
> indexing. This was before I realised that I could use the @-I..@-II
> and
> ;N syntax in conjunction with the org-babel sbe macro. So these ones
> have to deal with separating the numeric entries from the character
> strings.
>
> #+TBLFM:@10$4='(sbe my-tab-sum-LANG);%.2f
>
> #+function: my-tab-sum-elisp
> #+begin_src emacs-lisp :var tab=etape1[2:9,3]
> (apply '+ (remq nil (mapcar (lambda (row) (if (numberp (car row))
> (car row))) tab)))
> #+end_src
>
> #+function: my-tab-sum-R
> #+begin_src R :var tab=etape1[2:9,3]
> sum(as.numeric(tab[[1]]), na.rm=TRUE)
> #+end_src
>
> #+function: my-tab-sum-python
> #+begin_src python :var tab=etape1[2:9,3]
> flatten = lambda(lizt): sum(lizt, [])
> return sum(filter(lambda x: isinstance(x, float), flatten(tab)))
> #+end_src
>
>
> Dan
>
>
>>
>> - Carsten
>>
>>>
>>> Best regards,
>>> Seb
>>>
>>> --
>>> Sébastien Vauban
>>>
>>>
>>>
>>> _______________________________________________
>>> Emacs-orgmode mailing list
>>> Please use `Reply All' to send replies to the list.
>>> Emacs-orgmode@gnu.org
>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>
>> - Carsten
>>
>>
>>
>>
>>
>> _______________________________________________
>> Emacs-orgmode mailing list
>> Please use `Reply All' to send replies to the list.
>> Emacs-orgmode@gnu.org
>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
- Carsten
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Problem with table sums
2010-02-25 11:11 ` Carsten Dominik
@ 2010-03-01 0:37 ` Dan Davison
2010-03-01 7:49 ` Carsten Dominik
0 siblings, 1 reply; 6+ messages in thread
From: Dan Davison @ 2010-03-01 0:37 UTC (permalink / raw)
To: Carsten Dominik; +Cc: Sébastien Vauban, emacs-orgmode
Carsten Dominik <carsten.dominik@gmail.com> writes:
> :-) I should have known. These days, babel is the answer to most
> questions ... :-)
Well, that wasn't the conclusion I meant to be drawn -- I thought the
pure org solution was best here! (at least for simple summation)
Dan
>
> - Carste
>
> On Feb 24, 2010, at 4:40 PM, Dan Davison wrote:
>
>> Carsten Dominik <carsten.dominik@gmail.com> writes:
>>
>>> On Feb 23, 2010, at 11:08 PM, Sébastien Vauban wrote:
>> [...]
>>>> Though, I need to re-use some of the intermediate computations for
>>>> another
>>>> "summary table". Therefore, I add names to some cells:
>>>>
>>>> #+TBLNAME: etape1
>>>> | | Étape 1 | p.j | EUR HTVA |
>>>> |---+-------------------+-----+-----------------|
>>>> | | Prestations | 100 | 40000.00 |
>>>> | ^ | | pj | Prestations |
>>>> | | Frais annexes | | 1280.00 |
>>>> | ^ | | | FraisAnnexes |
>>>> | | Gestion du projet | | 3200.00 |
>>>> | ^ | | | GestionDuProjet |
>>>> | | Licence | | 8000.00 |
>>>> | ^ | | | Licence |
>>>> |---+-------------------+-----+-----------------|
>>>> | | Total | | 40000.00 |
>>>> | ^ | | | Total |
>>>> #+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%.
>>>> 2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-II);
>>>> %.2f
>>>>
>>>> Now, the total is wrong: it's the value of the first cell... Like if
>>>> the `^'
>>>> prefix was simply dropped... and total limited to the first real
>>>> figure.
>>>>
>>>> Any reason for this phenomenon? Or workaround (other than
>>>> describing every
>>>> cell to be summed)?
>>>
>>> Well, the reason is that the parser probably stops at the first text
>>> when summing, it tries to add "Prestations".
>>>
>>> I am afraid there is not good work-around for this.
>>
>> Hi Seb,
>>
>> Well, I was going to suggest using org-babel. After playing around
>> for a
>> while, I ended up reading the org manual on table formulas and coming
>> back to a pure org solution.
>>
>> My simplest solution is almost straight out of the manual (which makes
>> me worry that I've missed the point of the question?):
>>
>> #+TBLFM:@10$4='(apply '+ '(@-I..@-II));N
>>
>> But seeing as I've got them, I may as well post my org-babel
>> solutions.
>>
>> Here's the first set of org-babel solutions, which are just like the
>> first solution, but use blocks to do the computation:
>>
>> #+TBLFM:@10$4='(sbe my-sum-LANG (n (@-I..@-II)));N
>>
>> where LANG is whatever language you want to compute the sum in:
>>
>> #+function: my-sum-elisp(n)
>> #+begin_src emacs-lisp
>> (apply '+ n)
>> #+end_src
>>
>> #+function: my-sum-R(n)
>> #+begin_src R
>> sum(n)
>> #+end_src
>>
>> #+function: my-sum-python(n)
>> #+begin_src python
>> return sum(n)
>> #+end_src
>>
>>
>> The second set of org-babel solutions use org-babel to do the table
>> indexing. This was before I realised that I could use the @-I..@-II
>> and
>> ;N syntax in conjunction with the org-babel sbe macro. So these ones
>> have to deal with separating the numeric entries from the character
>> strings.
>>
>> #+TBLFM:@10$4='(sbe my-tab-sum-LANG);%.2f
>>
>> #+function: my-tab-sum-elisp
>> #+begin_src emacs-lisp :var tab=etape1[2:9,3]
>> (apply '+ (remq nil (mapcar (lambda (row) (if (numberp (car row))
>> (car row))) tab)))
>> #+end_src
>>
>> #+function: my-tab-sum-R
>> #+begin_src R :var tab=etape1[2:9,3]
>> sum(as.numeric(tab[[1]]), na.rm=TRUE)
>> #+end_src
>>
>> #+function: my-tab-sum-python
>> #+begin_src python :var tab=etape1[2:9,3]
>> flatten = lambda(lizt): sum(lizt, [])
>> return sum(filter(lambda x: isinstance(x, float), flatten(tab)))
>> #+end_src
>>
>>
>> Dan
>>
>>
>>>
>>> - Carsten
>>>
>>>>
>>>> Best regards,
>>>> Seb
>>>>
>>>> --
>>>> Sébastien Vauban
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Emacs-orgmode mailing list
>>>> Please use `Reply All' to send replies to the list.
>>>> Emacs-orgmode@gnu.org
>>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>>
>>> - Carsten
>>>
>>>
>>>
>>>
>>>
>>> _______________________________________________
>>> Emacs-orgmode mailing list
>>> Please use `Reply All' to send replies to the list.
>>> Emacs-orgmode@gnu.org
>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>
> - Carsten
>
>
>
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Please use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 6+ messages in thread
* Re: Problem with table sums
2010-03-01 0:37 ` Dan Davison
@ 2010-03-01 7:49 ` Carsten Dominik
0 siblings, 0 replies; 6+ messages in thread
From: Carsten Dominik @ 2010-03-01 7:49 UTC (permalink / raw)
To: Dan Davison; +Cc: Sébastien Vauban, emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 467 bytes --]
On Mar 1, 2010, at 1:37 AM, Dan Davison wrote:
> Carsten Dominik <carsten.dominik@gmail.com> writes:
>
>> :-) I should have known. These days, babel is the answer to most
>> questions ... :-)
>
> Well, that wasn't the conclusion I meant to be drawn -- I thought the
> pure org solution was best here! (at least for simple summation)
Well, yes. But the pure Org-solution is not predictable. If you turn
on formula debugging, you see that Org computes this:
[-- Attachment #2: pastedGraphic.tiff --]
[-- Type: image/tiff, Size: 19010 bytes --]
[-- Attachment #3: Type: text/plain, Size: 5407 bytes --]
If the "name" of a field would read as "222GestionDuProjet" (which is
not a valid name, yes), the effect of the N switch you added would
convert this field into not 0, but 222.
Furthermore, if the function had not been vsum, but vprod, the result
would always be 0 because the "names" are turned into zeros.
Using org-babel (or, if you like, emacs-lisp formulas) can try to
throw out these names in the correct way.
Really, what should happen is that Org should ignore "^" and "_" lines
when interpreting the formulas - but that is unfortunately neither
implemented,
not easy to do (I think...)
- Carsten
>
> Dan
>
>>
>> - Carste
>>
>> On Feb 24, 2010, at 4:40 PM, Dan Davison wrote:
>>
>>> Carsten Dominik <carsten.dominik@gmail.com> writes:
>>>
>>>> On Feb 23, 2010, at 11:08 PM, Sébastien Vauban wrote:
>>> [...]
>>>>> Though, I need to re-use some of the intermediate computations for
>>>>> another
>>>>> "summary table". Therefore, I add names to some cells:
>>>>>
>>>>> #+TBLNAME: etape1
>>>>> | | Étape 1 | p.j | EUR HTVA |
>>>>> |---+-------------------+-----+-----------------|
>>>>> | | Prestations | 100 | 40000.00 |
>>>>> | ^ | | pj | Prestations |
>>>>> | | Frais annexes | | 1280.00 |
>>>>> | ^ | | | FraisAnnexes |
>>>>> | | Gestion du projet | | 3200.00 |
>>>>> | ^ | | | GestionDuProjet |
>>>>> | | Licence | | 8000.00 |
>>>>> | ^ | | | Licence |
>>>>> |---+-------------------+-----+-----------------|
>>>>> | | Total | | 40000.00 |
>>>>> | ^ | | | Total |
>>>>> #+TBLFM: @2$4=@2$3*400.00;%.2f::@4$4=@2$4*0.08*0.40;%.
>>>>> 2f::@6$4=@2$4*0.08;%.2f::@8$4=@2$4*0.20;%.2f::@10$4=vsum(@-I..@-
>>>>> II);
>>>>> %.2f
>>>>>
>>>>> Now, the total is wrong: it's the value of the first cell...
>>>>> Like if
>>>>> the `^'
>>>>> prefix was simply dropped... and total limited to the first real
>>>>> figure.
>>>>>
>>>>> Any reason for this phenomenon? Or workaround (other than
>>>>> describing every
>>>>> cell to be summed)?
>>>>
>>>> Well, the reason is that the parser probably stops at the first
>>>> text
>>>> when summing, it tries to add "Prestations".
>>>>
>>>> I am afraid there is not good work-around for this.
>>>
>>> Hi Seb,
>>>
>>> Well, I was going to suggest using org-babel. After playing around
>>> for a
>>> while, I ended up reading the org manual on table formulas and
>>> coming
>>> back to a pure org solution.
>>>
>>> My simplest solution is almost straight out of the manual (which
>>> makes
>>> me worry that I've missed the point of the question?):
>>>
>>> #+TBLFM:@10$4='(apply '+ '(@-I..@-II));N
>>>
>>> But seeing as I've got them, I may as well post my org-babel
>>> solutions.
>>>
>>> Here's the first set of org-babel solutions, which are just like the
>>> first solution, but use blocks to do the computation:
>>>
>>> #+TBLFM:@10$4='(sbe my-sum-LANG (n (@-I..@-II)));N
>>>
>>> where LANG is whatever language you want to compute the sum in:
>>>
>>> #+function: my-sum-elisp(n)
>>> #+begin_src emacs-lisp
>>> (apply '+ n)
>>> #+end_src
>>>
>>> #+function: my-sum-R(n)
>>> #+begin_src R
>>> sum(n)
>>> #+end_src
>>>
>>> #+function: my-sum-python(n)
>>> #+begin_src python
>>> return sum(n)
>>> #+end_src
>>>
>>>
>>> The second set of org-babel solutions use org-babel to do the table
>>> indexing. This was before I realised that I could use the @-I..@-II
>>> and
>>> ;N syntax in conjunction with the org-babel sbe macro. So these ones
>>> have to deal with separating the numeric entries from the character
>>> strings.
>>>
>>> #+TBLFM:@10$4='(sbe my-tab-sum-LANG);%.2f
>>>
>>> #+function: my-tab-sum-elisp
>>> #+begin_src emacs-lisp :var tab=etape1[2:9,3]
>>> (apply '+ (remq nil (mapcar (lambda (row) (if (numberp (car row))
>>> (car row))) tab)))
>>> #+end_src
>>>
>>> #+function: my-tab-sum-R
>>> #+begin_src R :var tab=etape1[2:9,3]
>>> sum(as.numeric(tab[[1]]), na.rm=TRUE)
>>> #+end_src
>>>
>>> #+function: my-tab-sum-python
>>> #+begin_src python :var tab=etape1[2:9,3]
>>> flatten = lambda(lizt): sum(lizt, [])
>>> return sum(filter(lambda x: isinstance(x, float), flatten(tab)))
>>> #+end_src
>>>
>>>
>>> Dan
>>>
>>>
>>>>
>>>> - Carsten
>>>>
>>>>>
>>>>> Best regards,
>>>>> Seb
>>>>>
>>>>> --
>>>>> Sébastien Vauban
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> Emacs-orgmode mailing list
>>>>> Please use `Reply All' to send replies to the list.
>>>>> Emacs-orgmode@gnu.org
>>>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>>>
>>>> - Carsten
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> _______________________________________________
>>>> Emacs-orgmode mailing list
>>>> Please use `Reply All' to send replies to the list.
>>>> Emacs-orgmode@gnu.org
>>>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
>>
>> - Carsten
>>
>>
>>
>>
>>
>> _______________________________________________
>> Emacs-orgmode mailing list
>> Please use `Reply All' to send replies to the list.
>> Emacs-orgmode@gnu.org
>> http://lists.gnu.org/mailman/listinfo/emacs-orgmode
- Carsten
[-- Attachment #4: Type: text/plain, Size: 201 bytes --]
_______________________________________________
Emacs-orgmode mailing list
Please use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
^ permalink raw reply [flat|nested] 6+ messages in thread
end of thread, other threads:[~2010-03-01 8:18 UTC | newest]
Thread overview: 6+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2010-02-23 22:08 Problem with table sums Sébastien Vauban
2010-02-24 9:40 ` Carsten Dominik
2010-02-24 15:40 ` Dan Davison
2010-02-25 11:11 ` Carsten Dominik
2010-03-01 0:37 ` Dan Davison
2010-03-01 7:49 ` Carsten Dominik
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).