* vmin and probably vmax functions don't work
@ 2011-09-19 2:52 Jude DaShiell
2011-09-19 7:51 ` Christian Moe
0 siblings, 1 reply; 5+ messages in thread
From: Jude DaShiell @ 2011-09-19 2:52 UTC (permalink / raw)
To: emacs-orgmode
I'm getting identical numbers with vmean and vmode. I don't know if that
information is correct but will check it with another system later this
week. The same figures though also come up for vmin function and I know
for a fact that isn't correct. That was after saving my org file and
starting up emacs again to see if those figures would change and those
figures did not change. The only functions from calc that may work are
vmean and perhaps vsum but I've not tried vsum yet so won't make any more
categorical statements about that yet. I modified the #+TBLFM: line with
the original vmean formulas on it changing them first to vmode and later
to vmin. And that's how I got these results. What I would have liked to
have done would have been to calculate a mode and a min and max for each
of the three figures I'm tracking then had that information show up at the
bottom of the table.
Something like:
| stats: | systalic | diastalic | pulse |
| mode | xxx | yyy | zzz |
| min | xxx | yyy | zzz |
| max | xxx | yyy | zzz |
|-
Though how to get a #+TBLFM: line to calculate for all of this and
position correctly I'll have to figure out later.
Jude <jdashiel@shellworld.net> "I love the Pope, I love seeing him in his
Pope-Mobile, his three feet of bullet proof plexi-glass. That's faith in
action folks! You know he's got God on his side."
~ Bill Hicks
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: vmin and probably vmax functions don't work
2011-09-19 2:52 vmin and probably vmax functions don't work Jude DaShiell
@ 2011-09-19 7:51 ` Christian Moe
2011-09-19 10:15 ` Jude DaShiell
0 siblings, 1 reply; 5+ messages in thread
From: Christian Moe @ 2011-09-19 7:51 UTC (permalink / raw)
To: Jude DaShiell; +Cc: emacs-orgmode
Hi,
I think you'll need to include an actual example that isn't working.
With my own tables I don't see any errors with vmean, vmin, vmax. As
for vmode, does Calc have such a function? I can't see it documented,
and putting one in my table doesn't work.
Yours,
Christian
On 9/19/11 4:52 AM, Jude DaShiell wrote:
> I'm getting identical numbers with vmean and vmode. I don't know if that
> information is correct but will check it with another system later this
> week. The same figures though also come up for vmin function and I know
> for a fact that isn't correct. That was after saving my org file and
> starting up emacs again to see if those figures would change and those
> figures did not change. The only functions from calc that may work are
> vmean and perhaps vsum but I've not tried vsum yet so won't make any more
> categorical statements about that yet. I modified the #+TBLFM: line with
> the original vmean formulas on it changing them first to vmode and later
> to vmin. And that's how I got these results. What I would have liked to
> have done would have been to calculate a mode and a min and max for each
> of the three figures I'm tracking then had that information show up at the
> bottom of the table.
>
> Something like:
> | stats: | systalic | diastalic | pulse |
> | mode | xxx | yyy | zzz |
> | min | xxx | yyy | zzz |
> | max | xxx | yyy | zzz |
> |-
>
> Though how to get a #+TBLFM: line to calculate for all of this and
> position correctly I'll have to figure out later.
>
>
>
> Jude<jdashiel@shellworld.net> "I love the Pope, I love seeing him in his
> Pope-Mobile, his three feet of bullet proof plexi-glass. That's faith in
> action folks! You know he's got God on his side."
> ~ Bill Hicks
>
>
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: vmin and probably vmax functions don't work
2011-09-19 7:51 ` Christian Moe
@ 2011-09-19 10:15 ` Jude DaShiell
2011-09-19 10:38 ` Christian Moe
0 siblings, 1 reply; 5+ messages in thread
From: Jude DaShiell @ 2011-09-19 10:15 UTC (permalink / raw)
To: Christian Moe; +Cc: emacs-orgmode
| Date Stamp | Systalic | Diastalic | Pulse |
|------------------------+----------+-----------+-------|
| [2011-07-19 Tue 02:26] | 138 | 92 | 74 |
| [2011-07-20 Wed 04:03] | 130 | 85 | 74 |
| [2011-07-21 Thu 03:50] | 128 | 79 | 76 |
| [2011-07-22 Fri 02:33] | 121 | 80 | 79 |
| [2011-07-23 Sat 02:52] | 118 | 75 | 68 |
| [2011-07-24 Sun 04:13] | 126 | 83 | 78 |
| [2011-07-25 Mon 02:12] | 122 | 79 | 76 |
| [2011-07-26 Tue 01:57] | 124 | 79 | 72 |
| [2011-07-27 Wed 04:03] | 137 | 74 | 76 |
| [2011-07-28 Thu 03:47] | 136 | 80 | 76 |
| [2011-07-29 Fri 04:06] | 120 | 72 | 76 |
| [2011-07-30 Sat 03:18] | 128 | 92 | 80 |
| [2011-07-31 Sun 07:11] | 124 | 84 | 72 |
| [2011-08-01 Mon 04:55] | 124 | 77 | 69 |
| [2011-08-02 Tue 02:47] | 128 | 80 | 67 |
| [2011-08-03 Wed 06:00] | 132 | 89 | 70 |
| [2011-08-04 Thu 04:30] | 137 | 82 | 77 |
| [2011-08-05 Fri 06:10] | 124 | 86 | 77 |
| [2011-08-06 Sat 04:04] | 139 | 88 | 78 |
| [2011-08-07 Sun 04:02] | 124 | 80 | 68 |
| [2011-08-08 Mon 06:36] | 137 | 93 | 79 |
| [2011-08-10 Wed04:03] | 120 | 80 | 68 |
| [2011-08-11 Thu 04:30] | 128 | 78 | 77 |
| [2011-08-12 Fri 06:36] | 143 | 82 | 76 |
| [2011-08-13 Sat 06:18] | 125 | 76 | 69 |
| [2011-08-14 Sun 04:04] | 123 | 70 | 69 |
| [2011-08-15 Mon 04:04] | 135 | 83 | 76 |
| [2011-08-16 Tue 04:03] | 128 | 80 | 69 |
| [2011-08-17 Wed 04:04] | 124 | 80 | 68 |
| [2011-08-18 Thu 05:58] | 136 | 87 | 72 |
| [2011-08-19 Fri 05:50] | 116 | 80 | 64 |
| [2011-08-20 Sat 06:38] | 139 | 84 | 64 |
| [2011-08-21 Sun 08:20] | 124 | 84 | 73 |
| [2011-08-22 Mon 03:50] | 138 | 76 | 70 |
| [2011-08-23 Tue 05:52] | 126 | 79 | 68 |
| [2011-08-24 Wed 04:53] | 125 | 81 | 64 |
| [2011-08-25 Thu 05:37] | 124 | 79 | 68 |
| [2011-08-26 Fri 06:41] | 124 | 87 | 74 |
| [2011-08-27 Sat 05:44] | 133 | 74 | 61 |
| [2011-08-28 Sun 03:22] | 124 | 76 | 61 |
| [2011-08-29 Mon 04:06] | 124 | 76 | 65 |
| [2011-08-30 Tue 05:52] | 139 | 87 | 71 |
| [2011-08-31 Wed 06:47] | 152 | 86 | 68 |
| [2011-09-01 Thu 06:00] | 136 | 86 | 78 |
| [2011-09-02 Fri 01:22] | 142 | 100 | 78 |
| [2011-09-03 Sat 09:12] | 126 | 79 | 70 |
| [2011-09-04 Sun 11:53] | 130 | 90 | 72 |
| [2011-09-05 Mon 06:29] | 138 | 77 | 65 |
| [2011-09-06 Tue 05:42] | 121 | 76 | 68 |
| [2011-09-07 Wed 06:47] | 131 | 77 | 68 |
| [2011-09-08 Thu 06:02] | 122 | 76 | 72 |
| [2011-09-10 Sat 05:38] | 126 | 76 | 69 |
| [2011-09-11 Sun 10:12] | 137 | 87 | 64 |
| [2011-09-12 Mon 04:00] | 135 | 78 | 89 |
| [2011-09-13 Tue 06:00] | 132 | 82 | 66 |
| [2011-09-14 Wed 06:01] | 137 | 77 | 77 |
| [2011-09-15 Thu 04:08] | 141 | 87 | 64 |
| [2011-09-17 Sat 08:35] | 121 | 78 | 66 |
| [2011-09-18 Sun 07:04] | 124 | 69 | 65 |
| | | | |
|------------------------+----------+-----------+-------|
| modes | 127. | 81. | 74. |
#+TBLFM: $2=vmin(@I..II);f0::$3=vmin(@I..II);f0::$4=vmin(@I..II);f0
# Local Variables:
# kept-new-versions: 100
# version-control: t
# End:
On Mon, 19 Sep 2011, Christian Moe wrote:
> Hi,
>
> I think you'll need to include an actual example that isn't working.
>
> With my own tables I don't see any errors with vmean, vmin, vmax. As for
> vmode, does Calc have such a function? I can't see it documented, and putting
> one in my table doesn't work.
>
> Yours,
> Christian
>
>
> On 9/19/11 4:52 AM, Jude DaShiell wrote:
> > I'm getting identical numbers with vmean and vmode. I don't know if that
> > information is correct but will check it with another system later this
> > week. The same figures though also come up for vmin function and I know
> > for a fact that isn't correct. That was after saving my org file and
> > starting up emacs again to see if those figures would change and those
> > figures did not change. The only functions from calc that may work are
> > vmean and perhaps vsum but I've not tried vsum yet so won't make any more
> > categorical statements about that yet. I modified the #+TBLFM: line with
> > the original vmean formulas on it changing them first to vmode and later
> > to vmin. And that's how I got these results. What I would have liked to
> > have done would have been to calculate a mode and a min and max for each
> > of the three figures I'm tracking then had that information show up at the
> > bottom of the table.
> >
> > Something like:
> > | stats: | systalic | diastalic | pulse |
> > | mode | xxx | yyy | zzz |
> > | min | xxx | yyy | zzz |
> > | max | xxx | yyy | zzz |
> > |-
> >
> > Though how to get a #+TBLFM: line to calculate for all of this and
> > position correctly I'll have to figure out later.
> >
> >
> >
> > Jude<jdashiel@shellworld.net> "I love the Pope, I love seeing him in his
> > Pope-Mobile, his three feet of bullet proof plexi-glass. That's faith in
> > action folks! You know he's got God on his side."
> > ~ Bill Hicks
> >
> >
>
>
>
Jude <jdashiel@shellworld.net>
"I love the Pope, I love seeing him in his Pope-Mobile, his three feet
of bullet proof plexi-glass. That's faith in action folks! You know he's
got God on his side."
~ Bill Hicks
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: vmin and probably vmax functions don't work
2011-09-19 10:15 ` Jude DaShiell
@ 2011-09-19 10:38 ` Christian Moe
2011-09-19 11:37 ` Christian Moe
0 siblings, 1 reply; 5+ messages in thread
From: Christian Moe @ 2011-09-19 10:38 UTC (permalink / raw)
To: Jude DaShiell; +Cc: emacs-orgmode
Hi,
You've got row formulas when you want single-cell formulas. Assuming
it's minima you're after, try
#+TBLFM: @>$2=vmin(@I..@II);f0::@>$3=vmin(@I..II);f0::@>$4=vmin(@I..II);f0
hth
Christian
On 9/19/11 12:15 PM, Jude DaShiell wrote:
> | Date Stamp | Systalic | Diastalic | Pulse |
> |------------------------+----------+-----------+-------|
> | [2011-07-19 Tue 02:26] | 138 | 92 | 74 |
> | [2011-07-20 Wed 04:03] | 130 | 85 | 74 |
> | [2011-07-21 Thu 03:50] | 128 | 79 | 76 |
> | [2011-07-22 Fri 02:33] | 121 | 80 | 79 |
> | [2011-07-23 Sat 02:52] | 118 | 75 | 68 |
> | [2011-07-24 Sun 04:13] | 126 | 83 | 78 |
> | [2011-07-25 Mon 02:12] | 122 | 79 | 76 |
> | [2011-07-26 Tue 01:57] | 124 | 79 | 72 |
> | [2011-07-27 Wed 04:03] | 137 | 74 | 76 |
> | [2011-07-28 Thu 03:47] | 136 | 80 | 76 |
> | [2011-07-29 Fri 04:06] | 120 | 72 | 76 |
> | [2011-07-30 Sat 03:18] | 128 | 92 | 80 |
> | [2011-07-31 Sun 07:11] | 124 | 84 | 72 |
> | [2011-08-01 Mon 04:55] | 124 | 77 | 69 |
> | [2011-08-02 Tue 02:47] | 128 | 80 | 67 |
> | [2011-08-03 Wed 06:00] | 132 | 89 | 70 |
> | [2011-08-04 Thu 04:30] | 137 | 82 | 77 |
> | [2011-08-05 Fri 06:10] | 124 | 86 | 77 |
> | [2011-08-06 Sat 04:04] | 139 | 88 | 78 |
> | [2011-08-07 Sun 04:02] | 124 | 80 | 68 |
> | [2011-08-08 Mon 06:36] | 137 | 93 | 79 |
> | [2011-08-10 Wed04:03] | 120 | 80 | 68 |
> | [2011-08-11 Thu 04:30] | 128 | 78 | 77 |
> | [2011-08-12 Fri 06:36] | 143 | 82 | 76 |
> | [2011-08-13 Sat 06:18] | 125 | 76 | 69 |
> | [2011-08-14 Sun 04:04] | 123 | 70 | 69 |
> | [2011-08-15 Mon 04:04] | 135 | 83 | 76 |
> | [2011-08-16 Tue 04:03] | 128 | 80 | 69 |
> | [2011-08-17 Wed 04:04] | 124 | 80 | 68 |
> | [2011-08-18 Thu 05:58] | 136 | 87 | 72 |
> | [2011-08-19 Fri 05:50] | 116 | 80 | 64 |
> | [2011-08-20 Sat 06:38] | 139 | 84 | 64 |
> | [2011-08-21 Sun 08:20] | 124 | 84 | 73 |
> | [2011-08-22 Mon 03:50] | 138 | 76 | 70 |
> | [2011-08-23 Tue 05:52] | 126 | 79 | 68 |
> | [2011-08-24 Wed 04:53] | 125 | 81 | 64 |
> | [2011-08-25 Thu 05:37] | 124 | 79 | 68 |
> | [2011-08-26 Fri 06:41] | 124 | 87 | 74 |
> | [2011-08-27 Sat 05:44] | 133 | 74 | 61 |
> | [2011-08-28 Sun 03:22] | 124 | 76 | 61 |
> | [2011-08-29 Mon 04:06] | 124 | 76 | 65 |
> | [2011-08-30 Tue 05:52] | 139 | 87 | 71 |
> | [2011-08-31 Wed 06:47] | 152 | 86 | 68 |
> | [2011-09-01 Thu 06:00] | 136 | 86 | 78 |
> | [2011-09-02 Fri 01:22] | 142 | 100 | 78 |
> | [2011-09-03 Sat 09:12] | 126 | 79 | 70 |
> | [2011-09-04 Sun 11:53] | 130 | 90 | 72 |
> | [2011-09-05 Mon 06:29] | 138 | 77 | 65 |
> | [2011-09-06 Tue 05:42] | 121 | 76 | 68 |
> | [2011-09-07 Wed 06:47] | 131 | 77 | 68 |
> | [2011-09-08 Thu 06:02] | 122 | 76 | 72 |
> | [2011-09-10 Sat 05:38] | 126 | 76 | 69 |
> | [2011-09-11 Sun 10:12] | 137 | 87 | 64 |
> | [2011-09-12 Mon 04:00] | 135 | 78 | 89 |
> | [2011-09-13 Tue 06:00] | 132 | 82 | 66 |
> | [2011-09-14 Wed 06:01] | 137 | 77 | 77 |
> | [2011-09-15 Thu 04:08] | 141 | 87 | 64 |
> | [2011-09-17 Sat 08:35] | 121 | 78 | 66 |
> | [2011-09-18 Sun 07:04] | 124 | 69 | 65 |
> | | | | |
> |------------------------+----------+-----------+-------|
> | modes | 127. | 81. | 74. |
> #+TBLFM: $2=vmin(@I..II);f0::$3=vmin(@I..II);f0::$4=vmin(@I..II);f0
^ permalink raw reply [flat|nested] 5+ messages in thread
* Re: vmin and probably vmax functions don't work
2011-09-19 10:38 ` Christian Moe
@ 2011-09-19 11:37 ` Christian Moe
0 siblings, 0 replies; 5+ messages in thread
From: Christian Moe @ 2011-09-19 11:37 UTC (permalink / raw)
Cc: Jude DaShiell, emacs-orgmode
On second thought, these days you can just use a single range formula:
#+TBLFM: @>$2..$4=vmin(@I..@II);f0
hth,
Christian
On 9/19/11 12:38 PM, Christian Moe wrote:
> Hi,
>
> You've got row formulas when you want single-cell formulas. Assuming
> it's minima you're after, try
>
> #+TBLFM:
> @>$2=vmin(@I..@II);f0::@>$3=vmin(@I..II);f0::@>$4=vmin(@I..II);f0
>
> hth
> Christian
>
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2011-09-19 11:36 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2011-09-19 2:52 vmin and probably vmax functions don't work Jude DaShiell
2011-09-19 7:51 ` Christian Moe
2011-09-19 10:15 ` Jude DaShiell
2011-09-19 10:38 ` Christian Moe
2011-09-19 11:37 ` Christian Moe
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).