I spent time looking for vmode in info org using a regular expression
search and couldn't find it either. That capability is probably in R
though it may be under another name. I have emacs-ess package and R
installed on this system though haven't used them yet. I also found sbcl
so if it get
On Thursday, 4 Jun 2015 at 23:24, Thierry Banel wrote:
> You may want to consider a slightly different approach. It may (or
> maynot) be relevant depending on your context.
[...]
> Then using a package named "org-aggregate" (on Melpa) you can derivean
> aggregated table:
Thanks for reminding me
You may want to consider a slightly different approach. It may (or
maynot) be relevant depending on your context.
First, denormalize your table into a "fact table" (which is handy when
dealingwith cubes):
#+name: data
| date | type | q |
|--+---+-|
| [2014-0
Hi Nick
On Thu, Jun 4, 2015 at 5:22 PM, Nick Dokos wrote:
> Also, if one uses a format on an undefined function (e.g. using
> vmode(@I..@II); %.2f), I get 0.0 as a result and the error is hidden -
> if the format is omitted, the literal vmode([...]) appears in the table,
> so in that case at leas
Nick Dokos writes:
>
> I mispelled it the same way: I can never remember the right name.
>
... and I misspelled "misspelled" :-)
Michael Brand writes:
> Hi Eric
>
> On Thu, Jun 4, 2015 at 9:21 AM, wrote:
>> however, vstdev does not appear to work?
>
> My mistake, it should be vsdev or vpsdev.
>
I mispelled it the same way: I can never remember the right name.
Also, if one uses a format on an undefined function (e.g. us
Hi Eric
On Thu, Jun 4, 2015 at 9:21 AM, wrote:
> however, vstdev does not appear to work?
My mistake, it should be vsdev or vpsdev.
Michael
On Wednesday, 3 Jun 2015 at 22:05, Michael Brand wrote:
[...]
> I just found the Calc function apply() which leads to this
> simplification:
>
> | Date |Sys |Dia |Pul | Sugar |
> |--++++|
> | [2014-04-27 Sun] |125 |
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 correct
Jude DaShiell 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
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
To: Jude DaShiell
Cc: Org Mode Mailing List
Subject: Re: [O] searching for csv utilities
On 3 June 2015 at 12:07, Jude DaShiell wrote
Michael Brand writes:
> On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos wrote:
>> | Date |Sys | Dia | Pul | Sugar |
>> |--++---+---+---|
>> | [2014-04-27 Sun] |125 |88 |78 |92 |
>> | [2014-04-28 Mon] |102 |
On Wed, Jun 3, 2015 at 7:21 PM, Nick Dokos wrote:
> | Date |Sys | Dia | Pul | Sugar |
> |--++---+---+---|
> | [2014-04-27 Sun] |125 |88 |78 |92 |
> | [2014-04-28 Mon] |102 |88 |86 |92 |
> |-
Nick Dokos 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
ns 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 Lee
..@
>>>>>$>=vmedian(@I..@II);%.2f::@>>>>>>$2..@>>>>>>$>=vmax(@I..@II);%.2f::@
>>>>>>>$2..@>>>>>>>$>=vcount(@I..@II);%.2f::@>>>>>>>>$2..@
>>>>>>&
015, Jonathan Leech-Pepin wrote:
Date: Tue, 2 Jun 2015 08:04:20
From: Jonathan Leech-Pepin
To: Jude DaShiell
Cc: Org Mode Mailing List
Subject: Re: [O] searching for csv utilities
Hello,
On 2 June 2015 at 07:44, Jude DaShiell wrote:
| Date |
From: Jonathan Leech-Pepin
To: Jude DaShiell
Cc: Org Mode Mailing List
Subject: Re: [O] searching for csv utilities
Hello,
On 2 June 2015 at 07:44, Jude DaShiell wrote:
| Date | Sys | Dia | Pul | Sugar |
|--+---+-+-+-
Hello,
On 2 June 2015 at 07:44, Jude DaShiell wrote:
> | Date | Sys | Dia | Pul | Sugar |
> |--+---+-+-+---|
> | [2014-04-27 Sun] | 125 | 88 | 78 |92 |
> | [2014-04-28 Mon] | 102 | 88 | 86 |
| Date | Sys | Dia | Pul | Sugar |
|--+---+-+-+---|
| [2014-04-27 Sun] | 125 | 88 | 78 |92 |
| [2014-04-28 Mon] | 102 | 88 | 86 |92 |
| Averages:| =$2=vmean(@<..@>) | | |
20 matches
Mail list logo
