Re: [Orgmode] Re: orgmode and physical fitness training

[Eric Schulte]

Mikael Fornius <address@hidden> writes:

> David O'Toole <address@hidden> writes:
>
>> Does anyone else here use org-mode for fitness and/or health tracking?
[...]
> Lately I have been thinking of and trying to implement a true org-mode
> running diary. Which means to use the org-mode file as raw-data file
> (properties) instead of my parallell sexp-assoc-list-elisp-data-file.
>
> I tried column mode but it is far too slow for 300 headings and the
> calculations possible is only sums but I need much more.
>

Hi Mikael,

I ran into a very similar issue with column view lately while trying to
use org-mode to collect experimental results.  I created the attached
file, which can be used to collect data from properties in a manner
similar to column view, but using a simpler method meant only for table
display, rather than column viewing, and allowing for the application of
general elisp to the values before they are dumped into the table.  I
think it would work in your case as well.

I applied it to the data you posted with the following results.  The
mechanics are working, but it could use some display cleaning.  The file
`org-collector.el' is attached

org-collector.el
Description: application/emacs-lisp

and is available at http://github.com/eschulte/org-contrib/tree/master

Best -- Eric

** exercise
#+BEGIN: propview :id "nov" :cols (ITEM TIME DISTANCE (/ DISTANCE TIME) 
HEARTRATE)
| "ITEM"                                                     | "TIME" | 
"DISTANCE" | "(/ DISTANCE TIME)" | "HEARTRATE" |
|------------------------------------------------------------+--------+------------+---------------------+-------------|
| "<2008-11-01 sat>                         :running:hill:"  |     20 |        
3.0 |                0.15 |         169 |
| "<2008-11-02 sun>                         :skiing:alpine:" |     27 |        
4.0 | 0.14814814814814814 |         198 |
| "<2008-11-04 tue>                         :running:lake:"  |     27 |        
6.0 |  0.2222222222222222 |         169 |
|                                                            |        |         
   |                     |             |
#+END:

*** 2008-11                                   :november:
      :PROPERTIES:
      :ID:       nov
      :END:

**** <2008-11-01 sat>                         :running:hill:
     :PROPERTIES:
     :TIME:      20:08
     :DISTANCE:  3.0
     :HEARTRATE:     169
     :MAXHEARTRATE:  183
     :PACE: 4:36
     :SHAPEINDEX:  -8.4%
     :WEATHER: +5 cloudy
     :CALORIES: 370
     :SHOES:     nb858-1
     :STATFLAG: t
     :END:

**** <2008-11-02 sun>                         :skiing:alpine:
     :PROPERTIES:
     :TIME:      27:34
     :DISTANCE:  4.0
     :HEARTRATE:     198
     :MAXHEARTRATE:  145
     :PACE: 4:36
     :SHAPEINDEX:  -8.4%
     :WEATHER: +5 cloudy
     :CALORIES: 370
     :SHOES:     nb858-1
     :STATFLAG: t
     :END:

**** <2008-11-04 tue>                         :running:lake:
     :PROPERTIES:
     :TIME:      27:34
     :DISTANCE:  6.0
     :HEARTRATE:     169
     :MAXHEARTRATE:  183
     :PACE: 4:36
     :SHAPEINDEX:  -8.4%
     :WEATHER: +5 cloudy
     :CALORIES: 370
     :SHOES:     nb858-1
     :STATFLAG: t
     :END: