* very long table calc expressions ? @ 2018-06-19 17:21 Uwe Brauer 2018-06-20 6:13 ` Thierry Banel 2018-06-21 19:06 ` Bernt Hansen 0 siblings, 2 replies; 14+ messages in thread From: Uwe Brauer @ 2018-06-19 17:21 UTC (permalink / raw) To: emacs-orgmode Hi Take the following example #+TBLNAME: data | Name | Cual 1 | |------+--------| | A | NT | | B | NT | | C | MH | | D | AP | | E | MH | | F | SS | | G | NP | | H | NP | | I | NP | | | NT | | | AP | | | AP | | | AP | | | AP | | | SB | #+TBLNAME: stat-final2 | | Frequency | |----+-----------| | SS | 1 | | AP | 5 | | NT | 3 | | SB | 1 | | MH | 2 | | NP | 3 | #+TBLFM: @>$2='(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil))::@>>$2='(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil))::@>>>$2='(length (org-lookup-all "SB" '(remote(data,@2$2..@>I$2)) nil))::@>>>>$2='(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>$2='(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>>$2='(length (org-lookup-all "SS" '(remote(data,@2$2..@>I$2)) nil)) Are there any rules to break this very long expression? Thanks Uwe Brauer ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-19 17:21 very long table calc expressions ? Uwe Brauer @ 2018-06-20 6:13 ` Thierry Banel 2018-06-20 9:09 ` Uwe Brauer 2018-06-21 19:06 ` Bernt Hansen 1 sibling, 1 reply; 14+ messages in thread From: Thierry Banel @ 2018-06-20 6:13 UTC (permalink / raw) To: emacs-orgmode Le 19/06/2018 19:21, Uwe Brauer a écrit : > > Hi > > Take the following example > > > #+TBLNAME: data > | Name | Cual 1 | > |------+--------| > | A | NT | > | B | NT | > | C | MH | > | D | AP | > | E | MH | > | F | SS | > | G | NP | > | H | NP | > | I | NP | > | | NT | > | | AP | > | | AP | > | | AP | > | | AP | > | | SB | > > > #+TBLNAME: stat-final2 > | | Frequency | > |----+-----------| > | SS | 1 | > | AP | 5 | > | NT | 3 | > | SB | 1 | > | MH | 2 | > | NP | 3 | > #+TBLFM: @>$2='(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil))::@>>$2='(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil))::@>>>$2='(length (org-lookup-all "SB" '(remote(data,@2$2..@>I$2)) nil))::@>>>>$2='(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>$2='(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>>$2='(length (org-lookup-all "SS" '(remote(data,@2$2..@>I$2)) nil)) > > > Are there any rules to break this very long expression? > > Thanks > > Uwe Brauer > > > You may want to take a look at the orgtbl-aggregate package available on Melpa. #+BEGIN: aggregate :table "data" :cols "'Cual 1' count()" | 'Cual 1' | count() | |----------+---------| | NT | 3 | | MH | 2 | | AP | 5 | | SS | 1 | | NP | 3 | | SB | 1 | #+END: It features the count() function which computes frequency, but also sum, mean, filtering and much more. Documentation here: https://github.com/tbanel/orgaggregate To gain access to the Melpa repository I have those settings in my .emacs file: (require 'package) (setq package-enable-at-startup nil) ; To prevent initialising twice (add-to-list 'package-archives '("gnu" . "http://elpa.gnu.org/packages/" ) t) (add-to-list 'package-archives '("melpa" . "http://melpa.milkbox.net/packages/") t) (package-initialize) Have fun Thierry ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-20 6:13 ` Thierry Banel @ 2018-06-20 9:09 ` Uwe Brauer 2018-06-20 18:28 ` Thierry Banel 0 siblings, 1 reply; 14+ messages in thread From: Uwe Brauer @ 2018-06-20 9:09 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 2482 bytes --] > Le 19/06/2018 19:21, Uwe Brauer a écrit : > You may want to take a look at the orgtbl-aggregate package available on > Melpa. > #+BEGIN: aggregate :table "data" :cols "'Cual 1' count()" > | 'Cual 1' | count() | > |----------+---------| > | NT | 3 | > | MH | 2 | > | AP | 5 | > | SS | 1 | > | NP | 3 | > | SB | 1 | > #+END: > It features the count() function which computes frequency, but also sum, > mean, filtering and much more. > Documentation here: https://github.com/tbanel/orgaggregate Thanks very much. I have already installed that package but the example presented in the documentation were too sophisticated for my purpose. May I suggest to include this example in the documentation, because your package is a real time saver!! I take the opportunity to ask whether your package can also easily deal with the following problem (which is very important to me and drives my crazy) Take the following table #+TBLNAME: raw-data | Test | |------| | 0 | | 1 | | 2 | | 3 | | 4 | | 5 | | 6 | | 7 | | 8 | | 9 | | | | | | | Important are the last three empty strings. I know, thanks to the https://orgmode.org/worg/org-tutorials/org-lookups.html how to count the frequencies of the numbers in the column in an interval using the function #+TBLNAME: stat-table #+ATTR_HTML: :border 2 :rules all :frame border | | lower bound | upper bound | frequency | |----+-------------+-------------+-----------| | NP | 0 | 0 | 1 | | SS | 0 | 4.9 | 5 | | AP | 5 | 6.9 | 2 | | NT | 7 | 8.9 | 2 | | SB | 9 | 10 | 1 | #+TBLFM: $4='(length (org-lookup-all '($2 $3) '(remote(raw-data,@2$1..@>$1)) nil 'in-interval));N #+BEGIN_SRC emacs-lisp (defun in-interval (bounds el) (and (>= el (car bounds)) (<= el (cadr bounds)))) #+END_SRC However that function can not deal with empty strings (I could replace the empty string by some string but then the function does not distinguish between the string and 0). So I want that the entry NP represents the counts of the empty strings: there are three in that column. So can your package deal with this situation? Thanks again Uwe Brauer [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5025 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-20 9:09 ` Uwe Brauer @ 2018-06-20 18:28 ` Thierry Banel 2018-06-21 13:35 ` Uwe Brauer 0 siblings, 1 reply; 14+ messages in thread From: Thierry Banel @ 2018-06-20 18:28 UTC (permalink / raw) To: emacs-orgmode Le 20/06/2018 11:09, Uwe Brauer a écrit : > > Le 19/06/2018 19:21, Uwe Brauer a écrit : > > > You may want to take a look at the orgtbl-aggregate package available on > > Melpa. > > > > Thanks very much. I have already installed that package but the example > presented in the documentation were too sophisticated for my purpose. May > I suggest to include this example in the documentation, because your > package is a real time saver!! > I included such an example (and added your name to the contributors list). > I take the opportunity to ask whether your package can also easily > deal with the following problem (which is very important to me and > drives my crazy) Not easily. orgaggregate groups rows using equality, whereas you need to group rows based on intervals (between 5 and 6.9 for example). But you can prepare the data table with a new, computed column, telling in which interval each value falls: #+TBLNAME: raw-data | Test | Interval | |------+----------| | 0 | SS | | 1 | SS | | 2 | SS | | 3 | SS | | 4 | SS | | 5 | AP | | 6 | AP | | 7 | NT | | 8 | NT | | 9 | SB | | | NP | | | NP | | | NP | #+TBLFM: $2= "nan"="$1" ? string("NP") : 0<=$1 && $1<=4.9 ? string("SS") : 5<=$1 && $1<=6.9 ? string("AP") : 7<=$1 && $1<=8.9 ? string("NT") : 9<=$1 && $1<=10 ? string("SB") : string("OTHER");E And then orgaggregate can handle it: #+BEGIN: aggregate :table "raw-data" :cols "Interval count()" | Interval | count() | |----------+---------| | SS | 5 | | AP | 2 | | NT | 2 | | SB | 1 | | NP | 3 | #+END: > > #+TBLFM: $4='(length (org-lookup-all '($2 $3) '(remote(raw-data,@2$1..@>$1)) nil 'in-interval));N > > > However that function can not deal with empty strings (I could replace > the empty string by some string but then the function does not > distinguish between the string and 0). So I want that the entry NP > represents the counts of the empty strings: there are three in that column. > > So can your package deal with this situation? > > Thanks again > > Uwe Brauer > I don't have a solution out of my hat. But I guess the problem you face may originate from the remote() function. It filters out empty values. However you can change this behavior using the ;E modifier. | [0, 1, 2, 3, 4, 5, 6, 7, 8, 9] | #+TBLFM: $1=remote(raw-data,@2$1..@>$1) | [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, nan, nan, nan] | #+TBLFM: $1=remote(raw-data,@2$1..@>$1);E Regards Thierry ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-20 18:28 ` Thierry Banel @ 2018-06-21 13:35 ` Uwe Brauer 0 siblings, 0 replies; 14+ messages in thread From: Uwe Brauer @ 2018-06-21 13:35 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 2182 bytes --] > Le 20/06/2018 11:09, Uwe Brauer a écrit : > I included such an example (and added your name to the contributors list). Thanks! I don't feel that I am a contributor, but thanks very much. > Not easily. orgaggregate groups rows using equality, whereas you need to > group rows based on intervals (between 5 and 6.9 for example). > But you can prepare the data table with a new, computed column, telling > in which interval each value falls: > #+TBLNAME: raw-data > | Test | Interval | > |------+----------| > | 0 | SS | > | 1 | SS | > | 2 | SS | > | 3 | SS | > | 4 | SS | > | 5 | AP | > | 6 | AP | > | 7 | NT | > | 8 | NT | > | 9 | SB | > | | NP | > | | NP | > | | NP | > #+TBLFM: $2= "nan"="$1" ? string("NP") : 0<=$1 && $1<=4.9 ? string("SS") > : 5<=$1 && $1<=6.9 ? string("AP") : 7<=$1 && $1<=8.9 ? string("NT") : > 9<=$1 && $1<=10 ? string("SB") : string("OTHER");E > And then orgaggregate can handle it: > #+BEGIN: aggregate :table "raw-data" :cols "Interval count()" > | Interval | count() | > |----------+---------| > | SS | 5 | > | AP | 2 | > | NT | 2 | > | SB | 1 | > | NP | 3 | > #+END: This is great. I have to play a around with it a bit but it looks *precisely* what I was looking for since quite a while. I have to admitd that the complicated structure #+TBLFM: $2= "nan"="$1" ? string("NP") : 0<=$1 && $1<=4.9 ? string("SS") I would have never found myself. Thanks very much. Again I have the feeling that this is a real world example worth to be mentioned in the documentation (such example make your package so much more attractive because I presume most users feel like me, they are overwhelmed by its potential but on able to really use it). But maybe I am a bit biased :-D I have not looked into your second part of your answer since the first seems so useful. Regards Uwe [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5025 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-19 17:21 very long table calc expressions ? Uwe Brauer 2018-06-20 6:13 ` Thierry Banel @ 2018-06-21 19:06 ` Bernt Hansen 2018-06-22 10:28 ` Uwe Brauer 1 sibling, 1 reply; 14+ messages in thread From: Bernt Hansen @ 2018-06-21 19:06 UTC (permalink / raw) To: emacs-orgmode Uwe Brauer <oub@mat.ucm.es> writes: > #+TBLNAME: stat-final2 > | | Frequency | > |----+-----------| > | SS | 1 | > | AP | 5 | > | NT | 3 | > | SB | 1 | > | MH | 2 | > | NP | 3 | > #+TBLFM: @>$2='(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil))::@>>$2='(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil))::@>>>$2='(length (org-lookup-all "SB" '(remote(data,@2$2..@>I$2)) nil))::@>>>>$2='(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>$2='(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>>$2='(length (org-lookup-all "SS" '(remote(data,@2$2..@>I$2)) nil)) > > > Are there any rules to break this very long expression? Hi Uwe, You can edit or view the table formulas with C-c ' in case that helps. This splits the formulas one per line for editing. Regards, Bernt ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-21 19:06 ` Bernt Hansen @ 2018-06-22 10:28 ` Uwe Brauer 2018-06-22 13:16 ` Bernt Hansen 0 siblings, 1 reply; 14+ messages in thread From: Uwe Brauer @ 2018-06-22 10:28 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 543 bytes --] > Uwe Brauer <oub@mat.ucm.es> writes: Hello Bernt, > Hi Uwe, > You can edit or view the table formulas with C-c ' in case that helps. > This splits the formulas one per line for editing. Thanks for pointing this out to me, but I seem unable to do it. When I use C-c ' I obtain that very long formula in a special buffer, but it is again a long line. Breaking this line and then using C-c C-c cuts the second line. So this is not what I was looking for, but maybe I misunderstood something fundamental. Uwe [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5025 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 10:28 ` Uwe Brauer @ 2018-06-22 13:16 ` Bernt Hansen 2018-06-22 14:16 ` Uwe Brauer 0 siblings, 1 reply; 14+ messages in thread From: Bernt Hansen @ 2018-06-22 13:16 UTC (permalink / raw) To: emacs-orgmode Uwe Brauer <oub@mat.ucm.es> writes: > > Uwe Brauer <oub@mat.ucm.es> writes: > > Hello Bernt, > > Hi Uwe, > > > You can edit or view the table formulas with C-c ' in case that helps. > > This splits the formulas one per line for editing. > > Thanks for pointing this out to me, but I seem unable to do it. > > When I use C-c ' I obtain that very long formula in a special buffer, > but it is again a long line. Breaking this line and then using C-c C-c > cuts the second line. So this is not what I was looking for, but maybe I > misunderstood something fundamental. When I hit C-c ' in this table #+TBLNAME: stat-final2 | | Frequency | |----+-----------| | SS | | | AP | 5 | | NT | 3 | | SB | #ERROR | | MH | 2 | | NP | 3 | #+TBLFM: @>$2='(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil))::@>>$2='(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil))::@>>>$2='(length (org-lookup-all "SB" '\(remote(data,@2$2..@>I$2)) nil))::@>>>>$2='(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil))::@>>>>>$2='(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil)) I get a new window with this in it: # Field and Range Formulas @>$2 = '(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil)) @>>$2 = '(length (org-lookup-all "MH" '(remote(data,@2$2..@>I$2)) nil)) @>>>$2 = '(length (org-lookup-all "SB" '\(remote(data,@2$2..@>I$2)) nil)) @>>>>$2 = '(length (org-lookup-all "NT" '(remote(data,@2$2..@>I$2)) nil)) @>>>>>$2 = '(length (org-lookup-all "AP" '(remote(data,@2$2..@>I$2)) nil)) and I can edit individual lines and then C-c C-c or C-c ' again to exit and rebuild the formula line on the table. It seems to reverse the lines every other time I do it which is strange but it works for me. Regards, Bernt ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 13:16 ` Bernt Hansen @ 2018-06-22 14:16 ` Uwe Brauer 2018-06-22 15:03 ` Jonathan Leech-Pepin 0 siblings, 1 reply; 14+ messages in thread From: Uwe Brauer @ 2018-06-22 14:16 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1.1: Type: text/plain, Size: 781 bytes --] > Uwe Brauer <oub@mat.ucm.es> writes: > When I hit C-c ' in this table > #+TBLNAME: stat-final2 > | | Frequency | > |----+-----------| > | SS | | > | AP | 5 | > | NT | 3 | > | SB | #ERROR | > | MH | 2 | > | NP | 3 | > I get a new window with this in it: > # Field and Range Formulas > @>$2 = '(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) nil)) > nil)) > nil)) > nil)) > and I can edit individual lines and then C-c C-c or C-c ' again to exit > and rebuild the formula line on the table. Not for me, that is strange. Here is the screenshot I obtain (running git master emacs from May and org git master form last July, so maybe this feature is missing?) [-- Attachment #1.2: edit-special.png --] [-- Type: image/png, Size: 83372 bytes --] [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5025 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 14:16 ` Uwe Brauer @ 2018-06-22 15:03 ` Jonathan Leech-Pepin 2018-06-22 15:25 ` Uwe Brauer 0 siblings, 1 reply; 14+ messages in thread From: Jonathan Leech-Pepin @ 2018-06-22 15:03 UTC (permalink / raw) To: Org Mode Mailing List [-- Attachment #1: Type: text/plain, Size: 1113 bytes --] Hi Uwe, On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer <oub@mat.ucm.es> wrote: > > > Uwe Brauer <oub@mat.ucm.es> writes: > > > When I hit C-c ' in this table > > > #+TBLNAME: stat-final2 > > | | Frequency | > > > |----+-----------| > > | SS | | > > | AP | 5 | > > | NT | 3 | > > | SB | #ERROR | > > | MH | 2 | > > | NP | 3 | > > > > I get a new window with this in it: > > > # Field and Range Formulas > > @>$2 = '(length (org-lookup-all "NP" '(remote(data,@2$2..@>I$2)) > nil)) > > nil)) > > nil)) > > nil)) > > > and I can edit individual lines and then C-c C-c or C-c ' again to > exit > > and rebuild the formula line on the table. > > > Not for me, that is strange. Here is the screenshot I obtain (running > git master emacs from May and org git master form last July, so maybe > this feature is missing?) > > Pretty sure the spacer between formulas is supposed to be a double colon (::) not just a single. Brent's example has it with double while yours only shows it with a single one. Regards, Jon [-- Attachment #2: Type: text/html, Size: 1855 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 15:03 ` Jonathan Leech-Pepin @ 2018-06-22 15:25 ` Uwe Brauer 2018-06-22 16:48 ` Nick Dokos 0 siblings, 1 reply; 14+ messages in thread From: Uwe Brauer @ 2018-06-22 15:25 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 555 bytes --] Hi Jonathan > Hi Uwe, > On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer <oub@mat.ucm.es> wrote: > (::) > not just a single. Brent's example has it with double while yours only > shows > it with a single one. Right, thanks for clarifying that. My original example had various :: and indeed there Bernt's advice helped. Meanwhile Thierry posted a more sophisticated example containing only simple : (which does not work with ::) and that example cannot be dealt with via C-c '. @Thierry: that is correct? Uwe [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 5025 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 15:25 ` Uwe Brauer @ 2018-06-22 16:48 ` Nick Dokos 2018-06-22 17:22 ` Thierry Banel 0 siblings, 1 reply; 14+ messages in thread From: Nick Dokos @ 2018-06-22 16:48 UTC (permalink / raw) To: emacs-orgmode Uwe Brauer <oub@mat.ucm.es> writes: > Hi Jonathan > > > Hi Uwe, > > On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer <oub@mat.ucm.es> wrote: > > > (::) > > not just a single. Brent's example has it with double while yours only > > shows > > it with a single one. > > Right, thanks for clarifying that. My original example had various :: and > indeed there Bernt's advice helped. > > Meanwhile Thierry posted a more sophisticated example containing only > simple : > (which does not work with ::) and that example cannot be dealt with via > C-c '. > > @Thierry: that is correct? > The double colons separate different formulas. The single colons in Thierry's formula are part of the syntax of a conditional expression, i.e. they are part of a *single* (long) formula. So yes, that cannot be dealt with via C-c '. -- Nick "There are only two hard problems in computer science: cache invalidation, naming things, and off-by-one errors." -Martin Fowler ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 16:48 ` Nick Dokos @ 2018-06-22 17:22 ` Thierry Banel 2018-06-22 17:54 ` Uwe Brauer 0 siblings, 1 reply; 14+ messages in thread From: Thierry Banel @ 2018-06-22 17:22 UTC (permalink / raw) To: emacs-orgmode On 22/06/2018 18:48, Nick Dokos wrote: > Uwe Brauer <oub@mat.ucm.es> writes: > >> Hi Jonathan >> >> > Hi Uwe, >> > On Fri, Jun 22, 2018 at 10:16 AM, Uwe Brauer <oub@mat.ucm.es> wrote: >> >> > (::) >> > not just a single. Brent's example has it with double while yours only >> > shows >> > it with a single one. >> >> Right, thanks for clarifying that. My original example had various :: and >> indeed there Bernt's advice helped. >> >> Meanwhile Thierry posted a more sophisticated example containing only >> simple : >> (which does not work with ::) and that example cannot be dealt with via >> C-c '. >> >> @Thierry: that is correct? >> > The double colons separate different formulas. The single colons in Thierry's > formula are part of the syntax of a conditional expression, i.e. they are part > of a *single* (long) formula. So yes, that cannot be dealt with via C-c '. > A utility lisp function can enhance readability: #+begin_src elisp (defun test-to-interval (x) (let ((n (string-to-number x))) (cond ((equal x "") "NP") ((and (<= 0 n) (<= n 4.9)) "SS") ((and (<= 5 n) (<= n 6.9)) "AP") ((and (<= 7 n) (<= n 8.9)) "NT") ((and (<= 9 n) (<= n 10 )) "SB") (t "other")))) #+end_src #+TBLNAME: raw-data | Test | Interval | |------+----------| | 0 | SS | | 1 | SS | | 2 | SS | | 3 | SS | | 4 | SS | | 5 | AP | | 6 | AP | | 7 | NT | | 8 | NT | | 9 | SB | | | NP | | | NP | | | NP | #+TBLFM: $2='(test-to-interval $1) ^ permalink raw reply [flat|nested] 14+ messages in thread
* Re: very long table calc expressions ? 2018-06-22 17:22 ` Thierry Banel @ 2018-06-22 17:54 ` Uwe Brauer 0 siblings, 0 replies; 14+ messages in thread From: Uwe Brauer @ 2018-06-22 17:54 UTC (permalink / raw) To: emacs-orgmode [-- Attachment #1: Type: text/plain, Size: 910 bytes --] > On 22/06/2018 18:48, Nick Dokos wrote: > A utility lisp function can enhance readability: > #+begin_src elisp > (defun test-to-interval (x) > (let ((n (string-to-number x))) > (cond > ((equal x "") "NP") > ((and (<= 0 n) (<= n 4.9)) "SS") > ((and (<= 5 n) (<= n 6.9)) "AP") > ((and (<= 7 n) (<= n 8.9)) "NT") > ((and (<= 9 n) (<= n 10 )) "SB") > (t "other")))) > #+end_src This is extremely helpful! Thanks a lot. I hope France will make it to the final of the World Cup (more I cannot wish you :-D ) @Nick, I think this example should make it into the documentation, for example in https://orgmode.org/worg/org-tutorials/org-lookups.html. What do you think? Uwe [-- Attachment #2: smime.p7s --] [-- Type: application/pkcs7-signature, Size: 4393 bytes --] ^ permalink raw reply [flat|nested] 14+ messages in thread
end of thread, other threads:[~2018-06-22 17:54 UTC | newest] Thread overview: 14+ messages (download: mbox.gz / follow: Atom feed) -- links below jump to the message on this page -- 2018-06-19 17:21 very long table calc expressions ? Uwe Brauer 2018-06-20 6:13 ` Thierry Banel 2018-06-20 9:09 ` Uwe Brauer 2018-06-20 18:28 ` Thierry Banel 2018-06-21 13:35 ` Uwe Brauer 2018-06-21 19:06 ` Bernt Hansen 2018-06-22 10:28 ` Uwe Brauer 2018-06-22 13:16 ` Bernt Hansen 2018-06-22 14:16 ` Uwe Brauer 2018-06-22 15:03 ` Jonathan Leech-Pepin 2018-06-22 15:25 ` Uwe Brauer 2018-06-22 16:48 ` Nick Dokos 2018-06-22 17:22 ` Thierry Banel 2018-06-22 17:54 ` Uwe Brauer
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).
![[-- Attachment #1.2: edit-special.png --] [-- Type: image/png, Size: 83372 bytes --]](../../877emqgb4g.fsf@mat.ucm.es/1.2-edit-special.png){kind=link}