Re: [O] searching for csv utilities
Michael Brand michael.ch.br...@gmail.com writes: On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos ndo...@gmail.com wrote: | Date |Sys | Dia | Pul | Sugar | |--++---+---+---| | [2014-04-27 Sun] |125 |88 |78 |92 | | [2014-04-28 Mon] |102 |88 |86 |92 | |--++---+---+---| | Averages:| 113.50 | 88.00 | 82.00 | 92.00 | | Counts: | 2 | 2 | 2 | 2 | | Maximums:| 125.00 | 88.00 | 86.00 | 92.00 | | Medians: || | | | | Minimums:|| | | | | Modes: || | | | | Standard Deviations: || | | | | Sums:|| | | | |--++---+---+---| #+TBLFM: @$2..@$ = vmean(@I..@II);%.2f :: @$2..@$ = vcount(@I..@II) :: @$2..@$ = vmax(@I..@II);%.2f I just found the Calc function apply() which leads to this simplification: | Date |Sys |Dia |Pul | Sugar | |--++++| | [2014-04-27 Sun] |125 | 88 | 78 | 92 | | [2014-04-28 Mon] |102 | 88 | 86 | 92 | |--++++| | vmean| 113.50 | 88.00 | 82.00 | 92.00 | | vcount | 2.00 | 2.00 | 2.00 | 2.00 | | vmax | 125.00 | 88.00 | 86.00 | 92.00 | | vmedian | 113.50 | 88.00 | 82.00 | 92.00 | | vmin | 102.00 | 88.00 | 78.00 | 92.00 | | vstdev | 0.00 | 0.00 | 0.00 | 0.00 | | vsum | 227.00 | 176.00 | 164.00 | 184.00 | |--++++| #+TBLFM: @$2..@$ = apply($1, @I..@II); %.2f Delicious! Thanks, Nick
Re: [O] searching for csv utilities
On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos ndo...@gmail.com wrote: | Date |Sys | Dia | Pul | Sugar | |--++---+---+---| | [2014-04-27 Sun] |125 |88 |78 |92 | | [2014-04-28 Mon] |102 |88 |86 |92 | |--++---+---+---| | Averages:| 113.50 | 88.00 | 82.00 | 92.00 | | Counts: | 2 | 2 | 2 | 2 | | Maximums:| 125.00 | 88.00 | 86.00 | 92.00 | | Medians: || | | | | Minimums:|| | | | | Modes: || | | | | Standard Deviations: || | | | | Sums:|| | | | |--++---+---+---| #+TBLFM: @$2..@$ = vmean(@I..@II);%.2f :: @$2..@$ = vcount(@I..@II) :: @$2..@$ = vmax(@I..@II);%.2f I just found the Calc function apply() which leads to this simplification: | Date |Sys |Dia |Pul | Sugar | |--++++| | [2014-04-27 Sun] |125 | 88 | 78 | 92 | | [2014-04-28 Mon] |102 | 88 | 86 | 92 | |--++++| | vmean| 113.50 | 88.00 | 82.00 | 92.00 | | vcount | 2.00 | 2.00 | 2.00 | 2.00 | | vmax | 125.00 | 88.00 | 86.00 | 92.00 | | vmedian | 113.50 | 88.00 | 82.00 | 92.00 | | vmin | 102.00 | 88.00 | 78.00 | 92.00 | | vstdev | 0.00 | 0.00 | 0.00 | 0.00 | | vsum | 227.00 | 176.00 | 164.00 | 184.00 | |--++++| #+TBLFM: @$2..@$ = apply($1, @I..@II); %.2f Michael
Re: [O] Links in #+caption: lines
Hi, t...@tsdye.com (Thomas S. Dye) writes: I don't know if it is an effect of 37d2a2d. I just tested it against 50a0e712cceeef02c0d6a7c41b619b308ea1b15c. 37d2a2d seems critical here. I'm also seeing a different background for captions, similar to the background the emacs 24 starter kit gives me for #+begin_src and #+end_src lines. On my computer with angry fruit colors, captions are formatted as #+caption: caption text AFC color RedGray Face org-meta-line org-block I don't know starter kit. But the Leuven theme changes background colors for various parts of Org like this: https://github.com/fniessen/emacs-leuven-theme/blob/master/images/agenda-and-task-list.png Is that your theme? I use links for citations, which frequently appear in captions when I specify the source of data, etc. The paper I'm working on now looks a bit ungainly in the Org mode buffer due to the literal links in captions and the weird backgrounds. For the latter try something like: (set-face-background 'org-block nil) If it is necessary to choose between literal links in macros or descriptive links in captions, perhaps there could be a switch for users like you and me who use one but not the other? In the patch I guess this is the passage you disagree with: + ((equal dc1 +caption:) + (org-remove-flyspell-overlays-in (match-end 2) (match-end 0)) + (remove-text-properties (match-beginning 0) (match-end 0) + '(display t invisible t intangible t)) + (add-text-properties (match-beginning 1) (match-end 3) +'(font-lock-fontified t face org-meta-line)) + (add-text-properties (match-beginning 6) (+ (match-end 6) 1) +'(font-lock-fontified t face org-block))) Perhaps it is possible to let normal fontification rule in region six above? IMO hidden link (== no color highlight and not literal) is no good. Rasmus -- One thing that is clear: it's all down hill from here
Re: [O] orgmode to markdown
flow adolf...@sindominio.net writes: I guessed setext support 6 levels so I don't know why ox-md supprot just 2 levels although my exporter seems to support 3 levels. Why? Setext style supports only 2 levels. Atx supports 6 of them, per http://daringfireball.net/projects/markdown/syntax#header. That's a good question but not what I wanted to know. What I want -and I would like to know whay ox-md doesn't- is to export org as org-mode to html does: - The title becomes h1, so the org title becomes # or ===, I don't mind - The * becomes h2, so the org * becomes ## or - The ** becomes h3, so the org ** becomes ### (in case it supports 3 leveles) - etc. What do you think about it? I think it is very opinionated and may be undesirable in the general case. It means that every headline would be numbered 1.xxx. Also some Markdown extensions provide meta-data keywords to specify, e.g., the title of the document. This behaviour would just get in the way for them since headlines would get one too many level with no real reason. There are several workarounds: - you can define filters to add another level to each headline and title at the beginning of the document. - you can use a {{{title}}} macro, e.g., @@md:#@@ {{{title}}} and shift other headlines If this is common enough, we could also add a defcustom to toggle this behaviour (yet, off by default). But is it common enough? Regards,
Re: [O] searching for csv utilities
Hi Jonathan, calc has vmode if that helps any. On Wed, 3 Jun 2015, Jonathan Leech-Pepin wrote: Date: Wed, 3 Jun 2015 12:38:37 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities On 3 June 2015 at 12:07, Jude DaShiell jdash...@panix.com wrote: This is a piece of a modified ecm that may show what's going on. cut here. |--+-+++| | Averages:| |||| | Counts: | |||| | Maximums:| |||| | Medians: | |||| | Minimums:| |||| | Modes: | |||| | Standard Deviations: | |||| | Sums:| 108.69) | 70.45) | 66.62) | 92.93) | |--+-+++| #+TBLFM: @$2..@$=vmean(@I..@;%.2f) I haven't even attempted the rest of the math since I have no way to predict where any of the results will land. @ means last line, @ is second to last, @ third to last and so on. So for 7th from the bottom it would be @. Re: PrintF specification Everything after the =;= is considered part of the specification, so the =)= used to close the vmean is actually part of the specification. Changing that to =vmean();%.2f= will correct it. For your sample ECM (plus original data and one sample line to actually confirm median works) you would work with the following (Apologies for the very long TBLFM line): I was unable to find a built-in to determine the mode. I've found sample functions on Stack Overflow that would calculate it based on a list, but I'm not familiar enough with Org-Table format on how to go from cell references =@I..@II= to a list of values for the sake of manipulating them. : | Date |Sys |Dia |Pul | Sugar | : |--++++| : | [2014-04-27 Sun] |125 | 88 | 78 | 92 | : | [2014-04-28 Mon] |102 | 88 | 86 | 92 | : | [2014-04-29 Tue] |115 | 88 | 85 | 95 | : |--++++| : | Averages:| 114.00 | 88.00 | 83.00 | 93.00 | : | Counts: | 3.00 | 3.00 | 3.00 | 3.00 | : | Maximums:| 125.00 | 88.00 | 86.00 | 95.00 | : | Medians: | 115.00 | 88.00 | 85.00 | 92.00 | : | Minimums:| 102.00 | 88.00 | 78.00 | 92.00 | : | Modes: ||||| : | Standard Deviations: | 11.53 | 0.00 | 4.36 | 1.73 | : | Sums:| 342.00 | 264.00 | 249.00 | 279.00 | : |--++++| : #+TBLFM: @$2..@$=vsum(@I..@II);%.2f::@$2..@$=vsdev(@I..@II );%.2f::@$2..@$=vmin(@I..@II);%.2f::@$2..@ $=vmedian(@I..@II);%.2f::@$2..@$=vmax(@I..@II);%.2f::@ $2..@$=vcount(@I..@II);%.2f::@$2..@ $=vmean(@I..@II);%.2f Regards, Jonathan On Tue, 2 Jun 2015, Jonathan Leech-Pepin wrote: Date: Tue, 2 Jun 2015 08:04:20 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | | Averages:| =$2=vmean(@..@) | | | | #+TBLFM: $2=$2=vmean(@..@) The formula in question is the culprit in this case (at least as stated there). : $2=$2=vmean(@..@) Second column is equal to the second column which is equal to the mean of all the values in the second column (including the header Sys). If you change the table as follows: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | |--+---+-+-+---| | Averages:| 113.5 | 88 | 82 |92 | #+TBLFM: @$2..@$=vmean(@I..@II) All the values will properly compute. If you want to avoid the second HLINE above Averages: then change =@II= to =@= (penultimate row) Regards, Jon This is a cut down version of my full record set. Sometimes when I key formulas in I get ?ERROR back for a result after keying in c-c+c-c once I've completed the formula and hit tab. If I do c-u+c-c+c-c that sometimes generated ?ERROR. Other times I key in a formula and the cursor gets locked and I have to hit c-g to exit #+TBLFM: mode; I
Re: [O] searching for csv utilities
Jude DaShiell jdash...@panix.com writes: Hi Jonathan, calc has vmode if that helps any. I think Jonathan is right that calc does not have a vmode. I thought it did at first, but looking further I could not find any reference to it in the calc manual or in emacs help. Why do you think it exists? Nick
Re: [O] [PATCH] org-timer.el: Use hh:mm:ss format instead of minutes
Following is ORG-NEWS entry: * Incompatible changes ** org-timer-default-timer type changed from number to string If you have, in your configuration, something like =(setq org-timer-default-timer 10)= replace it with =(setq org-timer-default-timer 10)=. * New features ** Countdown timer support hh:mm:ss format In addition to setting countdown timers in minutes, they can also be set using the hh:mm:ss format. 2015-06-02 23:24 GMT+02:00 Nicolas Goaziou m...@nicolasgoaziou.fr: Brice Waegenire brice@gmail.com writes: Here is that version of this patch, at least I hope it is. Applied, Thank you. Would you mind preparing an entry in ORG-NEWS? Regards,
Re: [O] Make ob-shell conform to the org-babel interface
Sorry for the delay. Is this better? 0001-ob-shell-Conform-to-variable-assignment-interface.patch Description: Binary data On 01 Jun 2015, at 19:18, Nicolas Goaziou m...@nicolasgoaziou.fr wrote: Hello, Bjarte Johansen bjarte.johan...@infomedia.uib.no writes: I found that ob-shell’s org-babel-variable-assignments:bash function does not respect the interface for org-babel. It takes multiple arguments when it should only take 1. This is a problem when f.ex. org-babel-sha1-hash tries to expand the body of a bash source block and tries to call that function with only 1 argument. I am not sure if the following patch follows best practices in the project, but it solves the problem for me. Thank you for the patch. Some comments follow. From 04f00e4f69c5352d51b7de1ba8783ddd96124c1f Mon Sep 17 00:00:00 2001 From: Bjarte Johansen bjarte.johan...@gmail.com Date: Wed, 27 May 2015 17:20:41 +0200 Subject: [PATCH] ob-shell: Conform to variable assignment interface You need to list modified functions in commit message. Change org-babel-variable-assignments functions in ob-shell to use the same function so conform to the interface used for variable assignment in org-babel. Org Babel +(ert-deftest test-ob-shell/should-respect-ob-interface-naming-convention () + Functions used to interface with the different org-babel + should have the correct signature. Org Babel. Also, do not indent second line, and please make first sentence fit on a single line. + (dolist (shell org-babel-shell-names) +(org-test-with-temp-text +(format #+BEGIN_SRCpoint %s :cache yes + echo test +#+END_SRC shell) + (let ((info (org-babel-get-src-block-info))) +(org-babel-sha1-hash info) You need to wrap this within a `should' in order to define a proper test. Regards, -- Nicolas Goaziou
Re: [O] Links in #+caption: lines
t...@tsdye.com (Thomas S. Dye) writes: Aloha all, Links in #+caption: lines are shown as literal links. IIRC, they used to show as descriptive links. Has this changed, or is my memory faulty? In any case, I'd like them to be descriptive links to keep the #+caption: lines as short as possible. Maybe it's an effect of 37d2a2d1cfa58c5334eec4f7fbabc4a2f313ab33? Cf. http://thread.gmane.org/gmane.emacs.orgmode/95415 In any case, unless links can be fortified in captions, I think current behavior is OK. Hidden links are worse, IMO. Rasmus -- Lasciate ogni speranza, voi che leggete questo.
[O] Links in #+caption: lines
Aloha all, Links in #+caption: lines are shown as literal links. IIRC, they used to show as descriptive links. Has this changed, or is my memory faulty? In any case, I'd like them to be descriptive links to keep the #+caption: lines as short as possible. All the best, Tom -- T.S. Dye Colleagues, Archaeologists 735 Bishop St, Suite 315, Honolulu, HI 96813 Tel: 808-529-0866, Fax: 808-529-0884 http://www.tsdye.com
Re: [O] Bug: Property inheritance not working in columns [7.9.3f (release_7.9.3f-17-g7524ef @ /usr/share/emacs/24.3/lisp/org/)]
On 2 June 2015 at 21:02, Nicolas Goaziou m...@nicolasgoaziou.fr wrote: Nik Clayton n...@ngo.org.uk writes: I also see the same problem in agenda view (org-agenda-columns) Fixed in 03936a50f4fe9a261577d467098ed1080c61cb6e. Thank you. Great. Thanks again -- N -- http://try-dot-ch.blogspot.com/
Re: [O] Specifying ATTR_LATEX document wide?
Nicolas Goaziou m...@nicolasgoaziou.fr writes: Hello, Rainer M Krug rai...@krugs.de writes: In one document, I would like to make two changes how images are inserted in LaTeX / pdf documents, namely: 1) have no re-sizing, i.e. , | \includegraphics[]{./output/fig_crossValidationDefaultByUA.pdf} ` instead of , | \includegraphics[width=.9\linewidth]{./output/fig_crossValidationDefaultByUA.pdf} ` #+BIND: org-latex-image-default-width and 2) have no floats, even if a caption is given or use the :placement [H] with the float package. According to [[info:org#LaTeX%20specific%20attributes][info:org#LaTeX specific attributes]] I can use #+ATTR_LATEX: :float nil or #+ATTR_LATEX: :placement [H] #+BIND: org-latex-default-figure-position H Of course, this assumes, `org-export-allow-bind-keywords' is non-nil. Thanks - perfectly. But I assume, I could also set them via file local variables, which I did with `org-export-allow-bind-keywords'. Thanks, Rainer Regards, -- Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany) Centre of Excellence for Invasion Biology Stellenbosch University South Africa Tel : +33 - (0)9 53 10 27 44 Cell: +33 - (0)6 85 62 59 98 Fax : +33 - (0)9 58 10 27 44 Fax (D):+49 - (0)3 21 21 25 22 44 email: rai...@krugs.de Skype: RMkrug PGP: 0x0F52F982 signature.asc Description: PGP signature
Re: [O] markdown export?
Peter Davis p...@pfdstudio.com writes: I'm looking at http://orgmode.org/manual/Markdown-export.html, which says I can export to markdown, but these options don't exist in my org installation (8.2.10). If I type C-c C-e m, I get 'Invalid key' Do I have to install something else? I believe that you have the backend installed but not loaded: From: http://orgmode.org/manual/Export-back_002dends.html By default, the following four back-ends are loaded: ascii, html, icalendar and latex. It is possible to add more (or remove some) by customizing org-export-backends. -- Giles Chamberlin
[O] markdown export?
I'm looking at http://orgmode.org/manual/Markdown-export.html, which says I can export to markdown, but these options don't exist in my org installation (8.2.10). If I type C-c C-e m, I get 'Invalid key' Do I have to install something else? Thanks! -pd -- Peter Davis The Tech Curmudgeon www.techcurmudgeon.com
Re: [O] markdown export?
gi...@pexip.com writes: Peter Davis p...@pfdstudio.com writes: I'm looking at http://orgmode.org/manual/Markdown-export.html, which says I can export to markdown, but these options don't exist in my org installation (8.2.10). If I type C-c C-e m, I get 'Invalid key' Do I have to install something else? I believe that you have the backend installed but not loaded: From: http://orgmode.org/manual/Export-back_002dends.html By default, the following four back-ends are loaded: ascii, html, icalendar and latex. It is possible to add more (or remove some) by customizing org-export-backends. Yup! Customizing the variable did it. Thank you! -pd -- Peter Davis The Tech Curmudgeon www.techcurmudgeon.com
Re: [O] markdown export?
Maybe you need to (require 'ox-md) in your init file? Peter Davis writes: I'm looking at http://orgmode.org/manual/Markdown-export.html, which says I can export to markdown, but these options don't exist in my org installation (8.2.10). If I type C-c C-e m, I get 'Invalid key' Do I have to install something else? Thanks! -pd -- Professor John Kitchin Doherty Hall A207F Department of Chemical Engineering Carnegie Mellon University Pittsburgh, PA 15213 412-268-7803 @johnkitchin http://kitchingroup.cheme.cmu.edu
Re: [O] searching for csv utilities
Jonathan, Your modified ecm in this case works. Having applied the ecm to a larger file with seven additional calculation rows in it the averages are now displaying on the sums line. I tried @-7 at the start of the #+TBLFM: line and that generated about as many errors as someone's first efforts at a Cobol program. I also put a printf format string into that TBLFM: line that rounds averages to two decimal places and also prints out right parens at the end of each result. Is that an emacs-orgmode convention? I think the 2$2 piece of the #+TBLFM: line tells emacs-orgmode to put that calculation's results on the last line of the file and in column 2. Are these calculations elisp format? If so, I didn't read the elisp section of the spreadsheet info for emacs-orgmode yet. On Tue, 2 Jun 2015, Jonathan Leech-Pepin wrote: Date: Tue, 2 Jun 2015 08:04:20 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | | Averages:| =$2=vmean(@..@) | | | | #+TBLFM: $2=$2=vmean(@..@) The formula in question is the culprit in this case (at least as stated there). : $2=$2=vmean(@..@) Second column is equal to the second column which is equal to the mean of all the values in the second column (including the header Sys). If you change the table as follows: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | |--+---+-+-+---| | Averages:| 113.5 | 88 | 82 |92 | #+TBLFM: @$2..@$=vmean(@I..@II) All the values will properly compute. If you want to avoid the second HLINE above Averages: then change =@II= to =@= (penultimate row) Regards, Jon This is a cut down version of my full record set. Sometimes when I key formulas in I get ?ERROR back for a result after keying in c-c+c-c once I've completed the formula and hit tab. If I do c-u+c-c+c-c that sometimes generated ?ERROR. Other times I key in a formula and the cursor gets locked and I have to hit c-g to exit #+TBLFM: mode; I don't know what's actually happening when that situation arises since other than suddenly finding the cursor locked I can neither tell what state I'm in or if a few more keystrokes are needed or if I've generated an error situation. -- --
Re: [O] Testers / Feedback wanted: Gantt charts via org-gantt.el
* Eric S Fraga e.fr...@ucl.ac.uk wrote: The only comments I have at the moment is that it is missing support for milestones and all of my GANTT charts have such and that I would like to be able to link tasks across headlines (i.e. groups). Can I suggest a :milestone: tag or MILESTONE property for the former and a LINKED-TO or similar for the latter? How about a heading task who got only DEADLINE (no SCHEDULED) and does not span more than 1 day? This seems to be a mile-stone to me. (Or *additionally* this tag?) -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: get Memacs from https://github.com/novoid/Memacs https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
Re: [O] Testers / Feedback wanted: Gantt charts via org-gantt.el
Hi! * Bernhard Schmitz bernhard.schm...@vis.uni-stuttgart.de wrote: Von: Karl Voit [mailto:devn...@karl-voit.at] And accomplishing this, I personally would like to see that your method takes org-depend into consideration. Namely the properties BLOCKER and TRIGGER:(NEXT|TODO|STARTED). I plan my projects using mostly BLOCKER and TRIGGER:NEXT to express dependencies. This should be possible (might take a while, and no promises), at least for those simple dependencies. More complicated things expressed via org-depend would require some serious effort. Understood. I don't understand the TRIGGER:(NEXT) syntax, though. According to the org-depend documentation TRIGGER: requires an id or a chain-siblings string. Oh, I was too lazy to write a working example. ,[ working example ] | ** DONE My pretty task | CLOSED: [2015-04-30 Thu 07:50] SCHEDULED: 2015-04-30 Thu | :PROPERTIES: | :CREATED: [2015-04-17 Fri 15:36] | :ID: 2015-04-17-Dach-zu | :TRIGGER: foo1(NEXT) bar1(WAITING) | :BLOCKER: previousXY prevZ | :END: ` So when this task got marked as DONE, the headings with the ID propertes previousXY and prevZ must not have been in an open state. Further more, the headings with ID foo1 got the new states NEXT and bar1 WAITING accordingly. That's basically it. So if you can describe a consistent way that org-gantt should handle org-depend, then I might implement it (again, no promises), I hope I could describe the dependency definitions properly now. but as I have never used org-depend I don't know if whatever I could come up with would make sense. :-) -- mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode: get Memacs from https://github.com/novoid/Memacs https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github
Re: [O] searching for csv utilities
This is a piece of a modified ecm that may show what's going on. cut here. |--+-+++| | Averages:| |||| | Counts: | |||| | Maximums:| |||| | Medians: | |||| | Minimums:| |||| | Modes: | |||| | Standard Deviations: | |||| | Sums:| 108.69) | 70.45) | 66.62) | 92.93) | |--+-+++| #+TBLFM: @$2..@$=vmean(@I..@;%.2f) I haven't even attempted the rest of the math since I have no way to predict where any of the results will land. On Tue, 2 Jun 2015, Jonathan Leech-Pepin wrote: Date: Tue, 2 Jun 2015 08:04:20 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | | Averages:| =$2=vmean(@..@) | | | | #+TBLFM: $2=$2=vmean(@..@) The formula in question is the culprit in this case (at least as stated there). : $2=$2=vmean(@..@) Second column is equal to the second column which is equal to the mean of all the values in the second column (including the header Sys). If you change the table as follows: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | |--+---+-+-+---| | Averages:| 113.5 | 88 | 82 |92 | #+TBLFM: @$2..@$=vmean(@I..@II) All the values will properly compute. If you want to avoid the second HLINE above Averages: then change =@II= to =@= (penultimate row) Regards, Jon This is a cut down version of my full record set. Sometimes when I key formulas in I get ?ERROR back for a result after keying in c-c+c-c once I've completed the formula and hit tab. If I do c-u+c-c+c-c that sometimes generated ?ERROR. Other times I key in a formula and the cursor gets locked and I have to hit c-g to exit #+TBLFM: mode; I don't know what's actually happening when that situation arises since other than suddenly finding the cursor locked I can neither tell what state I'm in or if a few more keystrokes are needed or if I've generated an error situation. -- --
Re: [O] searching for csv utilities
On 3 June 2015 at 12:07, Jude DaShiell jdash...@panix.com wrote: This is a piece of a modified ecm that may show what's going on. cut here. |--+-+++| | Averages:| |||| | Counts: | |||| | Maximums:| |||| | Medians: | |||| | Minimums:| |||| | Modes: | |||| | Standard Deviations: | |||| | Sums:| 108.69) | 70.45) | 66.62) | 92.93) | |--+-+++| #+TBLFM: @$2..@$=vmean(@I..@;%.2f) I haven't even attempted the rest of the math since I have no way to predict where any of the results will land. @ means last line, @ is second to last, @ third to last and so on. So for 7th from the bottom it would be @. Re: PrintF specification Everything after the =;= is considered part of the specification, so the =)= used to close the vmean is actually part of the specification. Changing that to =vmean();%.2f= will correct it. For your sample ECM (plus original data and one sample line to actually confirm median works) you would work with the following (Apologies for the very long TBLFM line): I was unable to find a built-in to determine the mode. I've found sample functions on Stack Overflow that would calculate it based on a list, but I'm not familiar enough with Org-Table format on how to go from cell references =@I..@II= to a list of values for the sake of manipulating them. : | Date |Sys |Dia |Pul | Sugar | : |--++++| : | [2014-04-27 Sun] |125 | 88 | 78 | 92 | : | [2014-04-28 Mon] |102 | 88 | 86 | 92 | : | [2014-04-29 Tue] |115 | 88 | 85 | 95 | : |--++++| : | Averages:| 114.00 | 88.00 | 83.00 | 93.00 | : | Counts: | 3.00 | 3.00 | 3.00 | 3.00 | : | Maximums:| 125.00 | 88.00 | 86.00 | 95.00 | : | Medians: | 115.00 | 88.00 | 85.00 | 92.00 | : | Minimums:| 102.00 | 88.00 | 78.00 | 92.00 | : | Modes: ||||| : | Standard Deviations: | 11.53 | 0.00 | 4.36 | 1.73 | : | Sums:| 342.00 | 264.00 | 249.00 | 279.00 | : |--++++| : #+TBLFM: @$2..@$=vsum(@I..@II);%.2f::@$2..@$=vsdev(@I..@II );%.2f::@$2..@$=vmin(@I..@II);%.2f::@$2..@ $=vmedian(@I..@II);%.2f::@$2..@$=vmax(@I..@II);%.2f::@ $2..@$=vcount(@I..@II);%.2f::@$2..@ $=vmean(@I..@II);%.2f Regards, Jonathan On Tue, 2 Jun 2015, Jonathan Leech-Pepin wrote: Date: Tue, 2 Jun 2015 08:04:20 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | | Averages:| =$2=vmean(@..@) | | | | #+TBLFM: $2=$2=vmean(@..@) The formula in question is the culprit in this case (at least as stated there). : $2=$2=vmean(@..@) Second column is equal to the second column which is equal to the mean of all the values in the second column (including the header Sys). If you change the table as follows: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | |--+---+-+-+---| | Averages:| 113.5 | 88 | 82 |92 | #+TBLFM: @$2..@$=vmean(@I..@II) All the values will properly compute. If you want to avoid the second HLINE above Averages: then change =@II= to =@= (penultimate row) Regards, Jon This is a cut down version of my full record set. Sometimes when I key formulas in I get ?ERROR back for a result after keying in c-c+c-c once I've completed the formula and hit tab. If I do c-u+c-c+c-c that sometimes generated ?ERROR. Other times I key in a formula and the cursor gets locked and I have to hit c-g to exit #+TBLFM: mode; I don't know what's actually happening when that situation arises since other than suddenly finding the cursor locked I can neither tell what state I'm in or if a few more keystrokes are needed or if I've generated an error situation. -- --
Re: [O] Links in #+caption: lines
Aloha Rasmus, Rasmus ras...@gmx.us writes: t...@tsdye.com (Thomas S. Dye) writes: Aloha all, Links in #+caption: lines are shown as literal links. IIRC, they used to show as descriptive links. Has this changed, or is my memory faulty? In any case, I'd like them to be descriptive links to keep the #+caption: lines as short as possible. Maybe it's an effect of 37d2a2d1cfa58c5334eec4f7fbabc4a2f313ab33? Cf. http://thread.gmane.org/gmane.emacs.orgmode/95415 In any case, unless links can be fortified in captions, I think current behavior is OK. Hidden links are worse, IMO. I don't know if it is an effect of 37d2a2d. I'm also seeing a different background for captions, similar to the background the emacs 24 starter kit gives me for #+begin_src and #+end_src lines. I use links for citations, which frequently appear in captions when I specify the source of data, etc. The paper I'm working on now looks a bit ungainly in the Org mode buffer due to the literal links in captions and the weird backgrounds. If it is necessary to choose between literal links in macros or descriptive links in captions, perhaps there could be a switch for users like you and me who use one but not the other? All the best, Tom -- Thomas S. Dye http://www.tsdye.com
Re: [O] searching for csv utilities
First, I tried usinb multiple #+TBLFM: lines to do all of the math and that only did the first line of calculations which was the sums which appear last. After replacing the double colons between calculation lines in the single line form of the #+TBLFM: line seven of the 8 lines worked correctly. The vmode() function only returned zeros since the columns weren't sorted. I did find a calc-sort function in the calc info and tried vmode(sort(@I..@II))%.2f (nested functions) and that also returned zeros on the mode line. Must be some other way to use that function I'll have to search out. Thanks much for the help on this project, it probably will be stolen from and used in other projects here. -- --
Re: [O] searching for csv utilities
Nick Dokos ndo...@gmail.com writes: With that caveat, the above TBLFM line will calculate the first three of the eight statistics you want - the rest can be done similarly with the calc functions vmedian, vmin, vmode, vstdev and vsum As Jonathan Leech-Pepin points out, there is no vmode - my mistake. Nick
Re: [O] searching for csv utilities
Jude DaShiell jdash...@panix.com writes: This is a piece of a modified ecm that may show what's going on. cut here. |--+-+++| | Averages:| |||| | Counts: | |||| | Maximums:| |||| | Medians: | |||| | Minimums:| |||| | Modes: | |||| | Standard Deviations: | |||| | Sums:| 108.69) | 70.45) | 66.62) | 92.93) | |--+-+++| #+TBLFM: @$2..@$=vmean(@I..@;%.2f) The syntax is wrong - the format has to go *outside* the parens of the function. Also the row spec is almost certainly wrong - something like the following is needed (but see below for a more exact specification of what the table looks like and what the actual TBLFM line should be): #+TBLFM: @$2..@$=vmean(@I..@II);%.2f The @I..@II restricts the range of rows to be considered to be between the first and the second hline. IOW, the assumption is that you have three areas in your table: a header line, followed by an hline, a number of rows with data, followed by an hline and a number of rows containing calculated statistics, followed by an (optional) hline - something like this: | Date |Sys | Dia | Pul | Sugar | |--++---+---+---| | [2014-04-27 Sun] |125 |88 |78 |92 | | [2014-04-28 Mon] |102 |88 |86 |92 | |--++---+---+---| | Averages:| 113.50 | 88.00 | 82.00 | 92.00 | | Counts: | 2 | 2 | 2 | 2 | | Maximums:| 125.00 | 88.00 | 86.00 | 92.00 | | Medians: || | | | | Minimums:|| | | | | Modes: || | | | | Standard Deviations: || | | | | Sums:|| | | | |--++---+---+---| #+TBLFM: @$2..@$ = vmean(@I..@II);%.2f :: @$2..@$ = vcount(@I..@II) :: @$2..@$ = vmax(@I..@II);%.2f The only challenges left are to refer to the correct row and to find the appropriate calc function for the statistic at hand. Unfortunately, org mode is not particularly flexible in referring to cells (although it is a *lot* more flexible than it used to be). In particular, referring to the Averages: row can not be done simply (afaik): it's the first row after the second hline, so you'd think that you can refer to it as @II+1 but hline-relative references are not allowed on the LHS, so the best that I could do is refer to it as the eightth column from the bottom: @ and similarly for the others - looks like chicken scratchings (or what amounts to the same thing, Perl :-) ). With that caveat, the above TBLFM line will calculate the first three of the eight statistics you want - the rest can be done similarly with the calc functions vmedian, vmin, vmode, vstdev and vsum; but you can see it's getting unwieldy, particularly since the whole thing has to be on one line (or has that changed? I'm not keeping track any longer...) I believe that you are (partially or completely?) blind, which makes this all the more difficult: counting how many greater than signs are in each of those row specs is a pain for anybody, but I can't even imagine how a blind person would deal with it. I haven't even attempted the rest of the math since I have no way to predict where any of the results will land. On Tue, 2 Jun 2015, Jonathan Leech-Pepin wrote: Date: Tue, 2 Jun 2015 08:04:20 From: Jonathan Leech-Pepin jonathan.leechpe...@gmail.com To: Jude DaShiell jdash...@panix.com Cc: Org Mode Mailing List emacs-orgmode@gnu.org Subject: Re: [O] searching for csv utilities Hello, On 2 June 2015 at 07:44, Jude DaShiell jdash...@panix.com wrote: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 | | Averages:| =$2=vmean(@..@) | | | | #+TBLFM: $2=$2=vmean(@..@) The formula in question is the culprit in this case (at least as stated there). : $2=$2=vmean(@..@) Second column is equal to the second column which is equal to the mean of all the values in the second column (including the header Sys). If you change the table as follows: | Date | Sys | Dia | Pul | Sugar | |--+---+-+-+---| | [2014-04-27 Sun] | 125 | 88 | 78 |92 | | [2014-04-28 Mon] | 102 | 88 | 86 |92 |