### [O] 3 beginner table questions

```So, i'm using org mode to keep track of my workouts on a rowing machine and
need help with 3 questions to allow me to finish off my table.
The questions are based on the provided table, which is what I have so far.

1: in @4\$4 and @4\$7
i'm using vmean on a column of HMS values, how do I floor or round to the
nearest second, so I don't get fractions of seconds in my output?
\$4=0@ 16' 6.333
to
\$4=0@ 16' 6

2: i'm lazy and i don't want to type in the split time since I can derive
it from the Watts column.
pace(or 500m split time) from watts formula - 3rd root(2.8/watts)
so
if W = 66 then pace= 3rdRt(2.8/66) = 0.3487 * 500 = 174 seconds = 0@ 2' 54
so
if \$11 = 66, whats the best way to put \$7 = 0@ 2' 54?
does this call for a lisp function where the output is a text string, or is
there an easier/TBLFM way?

3:
the \$1 column of my table is just an i++ value, 1, 2, 3 ... n where n is
the number of rows between the 2nd and 3rd hline.
is there a function I can call to tell me how many rows are in that part of
my table, or, if I want to be able to refer
to a variable which is the number of rows in my table, do I have to keep
track of it manually like this?
so what I want to be able to do is the following, without having to use a
count up column.
@7\$2 = Total(3), where 3 is the number of rows between the 2nd and 3rd
hline

Thanks so much, Ryan Moszynski

|---+-+-+---++-+--+--+--+--+|
|   | date|  lb | h  m   s  | meters | spm | split500 |
C_c2 | C_rl | C_AB |  W |
|   | May | |   || |  |
|  |  ||
|---+-+-+---++-+--+--+--+--+|
| 1 | 050114  | 236 | 0@ 15' 36|   2686 |  29 | 0@ 2' 54|
527 |  632 |  164 | 66 |
| 2 | 050214  | 236 | 0@ 16' 7 |   2793 |  28 | 0@ 2' 53|
531 |  636 |  170 | 67 |
| 3 | 050414  | 234 | 0@ 16' 36|   3023 |  29 | 0@ 2' 44|
568 |  669 |  185 | 78 |
|---+-+-+---++-+--+--+--+--+|
|   | Average | 235 | 0@ 16' 6.333 |   2834 |  29 | 0@ 2' 50.33 |
542 |  646 |  173 | 70 |
|   | Total   | | 0@ 48' 19|   8502 | |  |
|  |  519 ||
|---+-+-+---++-+--+--+--+--+|
#+TBLFM:
@6\$3=vmean(@II..@III);%.0f::
@7\$4=vsum(@II..@III)::
@6\$4=vmean(@II..@III)::
@7\$5=vsum(@II..@III)::
@6\$5=vmean(@II..@III);%.0f::
@6\$6=vmean(@II..@III);%.0f::
@6\$7=vmean(@II..@III)::
@6\$11=vmean(@II..@III);%.0f::
\$9=if(\$8  0, vsum(\$8, -300+\$3*1.714), 0);%.0f::
\$10=vsum(0, ((3600*deg(\$4))/3600)*\$9);%d::
@7\$10=vsum(@II..@III)::
@6\$10=vmean(@II..@III);%.0f::
@7\$9=string()::
@6\$8=vmean(@II..@III);%.0f::
@6\$9=vmean(@II..@III);%.0f::

--
He felt that his whole life was some kind of dream and he sometimes
wondered whose it was and whether they were enjoying it. - Douglas Adams

```

### [O] (no subject)

```If an org table cell contains the HMS 1@ 11' 37

is there an easy way to get the total (time)seconds?

(1*3600 + 11*60 + 37 = 4297)

if \$4 =  1@ 11' 37

how do I get \$8 = 4297?

thanks

ryan

--
He felt that his whole life was some kind of dream and he sometimes
wondered whose it was and whether they were enjoying it. - Douglas