spreadsheet advice

spreadsheet advice

[Robert D. Crawford]

I am a new user to org-mode and picked it up mainly for the spreadsheet
functionality.  I have a few questions that I cannot seem to get an
answer to from reading the info manual.

I am using the spreadsheet to keep track of my blood glucose levels,
correctional boluses, carb intake, meal boluses, and basal increases.
All of these things need to be recorded to the nearest hour.  Each
section will look like the following and corresponds to one day.  I have
removed many of the hours for brevity.

|   | date  |  00 | 01 | 22 | 23 | avg bg | tot carb |
|---+-------+-----+----+----+----+--------+----------|
|   | bg    |     |    |    |    |        |          |
|   | corr  |     |    |    |    |        |          |
|   | carb  |     |    |    |    |        |          |
|   | bolus |     |    |    |    |        |          |
|   | basal |     |    |    |    |        |          |
|   |       |     |    |    |    |        |          |
|---+-------+-----+----+----+----+--------+----------|
#+TBLFM: @3$3=if(@-1>0,(@-1-100.0)/100.0,string("")

As you can see, I have only the basic layout and one equation.

Now for the questions.

1.  I would like to keep all the tables above in one spreadsheet, one
table for each day of the month, creating a new spreadsheet each month.
If there is a more efficient way to do it I am more than open to
suggestion.  The reason is that I would be able to more easily track
trends in blood glucose levels on a time-of-day basis.

All other questions assume the above layout.

2.  I would like to create a bg-template.org file and simply insert that
file every morning when I do my first reading.  One problem I see is
the equations might need to be rewritten for the bit that gets added.
Is there some way to get past this issue?

3.  Is there some functionality for row equations like there is for
column equations?  The rows marked "corr" and "bolus" can be
automatically filled with values and I would like to do this but don't
want to have to bother with the work necessary to yank the equation in
each field if it is not necessary.  I did try to use a range in the
tblfm line but this does not work.

4.  In the name of further automation, can one jump to a particular
coordinate in the spreadsheet?

I think that takes care of my immediate questions.  Thanks for any
assistance offered.

rdc
-- 
Robert D. Crawford                                     robdcraw@gmail.com

"But I don't like Spam!!!!"

spreadsheet advice

[T. V. Raman]

For easy insertion of templates as you make entries on a
daily/hourly basis, look at the org -> remember integration ---
the easiest way to do this would be to 

A)  install remember
B) Create an appropriate entry in the org-remember-templates,
C) Just hit remember and jot down what you are entering.



>>>>> "Robert" == Robert D Crawford <robdcraw@gmail.com> writes:
    Robert> I am a new user to org-mode and picked it up mainly
    Robert> for the spreadsheet functionality.  I have a few
    Robert> questions that I cannot seem to get an answer to from
    Robert> reading the info manual.
    Robert> 
    Robert> I am using the spreadsheet to keep track of my blood
    Robert> glucose levels, correctional boluses, carb intake,
    Robert> meal boluses, and basal increases.  All of these
    Robert> things need to be recorded to the nearest hour.  Each
    Robert> section will look like the following and corresponds
    Robert> to one day.  I have removed many of the hours for
    Robert> brevity.
    Robert> 
    Robert> | | date | 00 | 01 | 22 | 23 | avg bg | tot carb |
    Robert> |---+-------+-----+----+----+----+--------+----------|
    Robert> | | bg | | | | | | | | | corr | | | | | | | | | carb
    Robert> | | | | | | | | | bolus | | | | | | | | | basal | | |
    Robert> | | | | | | | | | | | | |
    Robert> |---+-------+-----+----+----+----+--------+----------|
    Robert> #+TBLFM: @3$3=if(@-1>0,(@-1-100.0)/100.0,string("")
    Robert> 
    Robert> As you can see, I have only the basic layout and one
    Robert> equation.
    Robert> 
    Robert> Now for the questions.
    Robert> 
    Robert> 1.  I would like to keep all the tables above in one
    Robert> spreadsheet, one table for each day of the month,
    Robert> creating a new spreadsheet each month.  If there is a
    Robert> more efficient way to do it I am more than open to
    Robert> suggestion.  The reason is that I would be able to
    Robert> more easily track trends in blood glucose levels on a
    Robert> time-of-day basis.
    Robert> 
    Robert> All other questions assume the above layout.
    Robert> 
    Robert> 2.  I would like to create a bg-template.org file and
    Robert> simply insert that file every morning when I do my
    Robert> first reading.  One problem I see is the equations
    Robert> might need to be rewritten for the bit that gets
    Robert> added.  Is there some way to get past this issue?
    Robert> 
    Robert> 3.  Is there some functionality for row equations
    Robert> like there is for column equations?  The rows marked
    Robert> "corr" and "bolus" can be automatically filled with
    Robert> values and I would like to do this but don't want to
    Robert> have to bother with the work necessary to yank the
    Robert> equation in each field if it is not necessary.  I did
    Robert> try to use a range in the tblfm line but this does
    Robert> not work.
    Robert> 
    Robert> 4.  In the name of further automation, can one jump
    Robert> to a particular coordinate in the spreadsheet?
    Robert> 
    Robert> I think that takes care of my immediate questions.
    Robert> Thanks for any assistance offered.
    Robert> 
    Robert> rdc -- Robert D. Crawford robdcraw@gmail.com
    Robert> 
    Robert> "But I don't like Spam!!!!"
    Robert> 
    Robert> 
    Robert> _______________________________________________
    Robert> Emacs-orgmode mailing list Remember: use `Reply All'
    Robert> to send replies to the list.  Emacs-orgmode@gnu.org
    Robert> http://lists.gnu.org/mailman/listinfo/emacs-orgmode

-- 
Best Regards,
--raman

      
Email:  raman@users.sf.net
WWW:    http://emacspeak.sf.net/raman/
AIM:    emacspeak       GTalk: tv.raman.tv@gmail.com
PGP:    http://emacspeak.sf.net/raman/raman-almaden.asc
Google: tv+raman 
IRC:    irc://irc.freenode.net/#emacs

Re: spreadsheet advice

[Carsten Dominik]

On Sep 11, 2007, at 4:06, Robert D. Crawford wrote:

> I am a new user to org-mode and picked it up mainly for the spreadsheet
> functionality.  I have a few questions that I cannot seem to get an
> answer to from reading the info manual.
>
> I am using the spreadsheet to keep track of my blood glucose levels,
> correctional boluses, carb intake, meal boluses, and basal increases.
> All of these things need to be recorded to the nearest hour.  Each
> section will look like the following and corresponds to one day.  I 
> have
> removed many of the hours for brevity.
>
> |   | date  |  00 | 01 | 22 | 23 | avg bg | tot carb |
> |---+-------+-----+----+----+----+--------+----------|
> |   | bg    |     |    |    |    |        |          |
> |   | corr  |     |    |    |    |        |          |
> |   | carb  |     |    |    |    |        |          |
> |   | bolus |     |    |    |    |        |          |
> |   | basal |     |    |    |    |        |          |
> |   |       |     |    |    |    |        |          |
> |---+-------+-----+----+----+----+--------+----------|
> #+TBLFM: @3$3=if(@-1>0,(@-1-100.0)/100.0,string("")
>
> As you can see, I have only the basic layout and one equation.
>
> Now for the questions.
>
> 1.  I would like to keep all the tables above in one spreadsheet, one
> table for each day of the month, creating a new spreadsheet each month.
> If there is a more efficient way to do it I am more than open to
> suggestion.  The reason is that I would be able to more easily track
> trends in blood glucose levels on a time-of-day basis.

Org-mode does not really have the term "one spreadsheet".

It has a table.  A document can contain many tables.  Do you mean to
put everything into a single table, or many tables in a document?

> All other questions assume the above layout.
>
> 2.  I would like to create a bg-template.org file and simply insert 
> that
> file every morning when I do my first reading.  One problem I see is
> the equations might need to be rewritten for the bit that gets added.
> Is there some way to get past this issue?

Why would they need rewriting?  If you use a separate table each day,
no problem, they all look t eh same then.  If you want to put things
into one big table, hmmmm.  Harder.  You could use calculation markers
in the first column, to make sure that intermediate lines are not 
computes

|   | date1 |  00 | 01 | 22 | 23 | avg bg | tot carb |
|---+-------+-----+----+----+----+--------+----------|
| # | bg    |     |    |    |    |        |          |
| # | corr  |     |    |    |    |        |          |
| # | carb  |     |    |    |    |        |          |
| # | bolus |     |    |    |    |        |          |
| # | basal |     |    |    |    |        |          |
|   |       |     |    |    |    |        |          |
|---+-------+-----+----+----+----+--------+----------|
|   | date2 |  00 | 01 | 22 | 23 | avg bg | tot carb |
|---+-------+-----+----+----+----+--------+----------|
| # | bg    |     |    |    |    |        |          |
| # | corr  |     |    |    |    |        |          |
| # | carb  |     |    |    |    |        |          |
| # | bolus |     |    |    |    |        |          |
| # | basal |     |    |    |    |        |          |
|   |       |     |    |    |    |        |          |
|---+-------+-----+----+----+----+--------+----------|
|   | date3 |  00 | 01 | 22 | 23 | avg bg | tot carb |
|---+-------+-----+----+----+----+--------+----------|
| # | bg    |     |    |    |    |        |          |
| # | corr  |     |    |    |    |        |          |
| # | carb  |     |    |    |    |        |          |
| # | bolus |     |    |    |    |        |          |
| # | basal |     |    |    |    |        |          |
|   |       |     |    |    |    |        |          |
|---+-------+-----+----+----+----+--------+----------|
#+TBLFM: @3$3=if(@-1>0,(@-1-100.0)/100.0,string("")

>
> 3.  Is there some functionality for row equations like there is for
> column equations?

No.

>  The rows marked "corr" and "bolus" can be
> automatically filled with values and I would like to do this but don't
> want to have to bother with the work necessary to yank the equation in
> each field if it is not necessary.  I did try to use a range in the
> tblfm line but this does not work.

I don't know a way around putting these equations separately into
each field.

>
> 4.  In the name of further automation, can one jump to a particular
> coordinate in the spreadsheet?

Not yet.  Do you know the coordinates by heart?  Would you like
to jump there from a program?

If you want to do complex analysis of this data, you might want to
consider using Excel or another "real" spreadsheet instead.

- Carsten

Re: spreadsheet advice

[Robert D. Crawford]

Thanks to you and Dr. Raman  for answering my questions.  I decided to
sort of roll my own solution, building on org mode spreadsheet tables.
Basically, it just inserts the grid, puts in the formulae, replaces
the date placeholder with the current date and time unless it gets a
numeric arg.  If anyone is interested in this (probably ugly and
inefficient) code, let me know and I will provide it.

I was attempting to write something that would prompt for values,
compute correctionals and boluses and insert them into the table but ran
into several issues I could not readily figure out.  I have spent too
much time on this already, so I stopped with something that works
mostly.  Maybe one day I will revisit this issue and create a proper
mode to address this problem.  

Thanks again,
rdc
-- 
Robert D. Crawford                                     robdcraw@gmail.com

The chicken that clucks the loudest is the one most likely to show up
at the steam fitters' picnic.