Re: [O] vmin and probably vmax functions don't work

[Jude DaShiell]

| 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<address@hidden>  "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 <address@hidden>
"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