emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Carsten Dominik <dominik@science.uva.nl>
To: "Robert D. Crawford" <robdcraw@gmail.com>
Cc: org-mode list <emacs-orgmode@gnu.org>
Subject: Re: spreadsheet advice
Date: Fri, 14 Sep 2007 16:25:50 +0200	[thread overview]
Message-ID: <77a9352b6bc3e4e461682639d2ca871d@science.uva.nl> (raw)
In-Reply-To: <87fy1m9cr1.fsf@gmail.com>


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

  parent reply	other threads:[~2007-09-14 14:25 UTC|newest]

Thread overview: 4+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2007-09-11  2:06 spreadsheet advice Robert D. Crawford
2007-09-11 13:16 ` T. V. Raman
2007-09-14 14:25 ` Carsten Dominik [this message]
2007-09-22 14:48   ` Robert D. Crawford

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=77a9352b6bc3e4e461682639d2ca871d@science.uva.nl \
    --to=dominik@science.uva.nl \
    --cc=emacs-orgmode@gnu.org \
    --cc=robdcraw@gmail.com \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
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).