* spreadsheet advice
@ 2007-09-11 2:06 Robert D. Crawford
2007-09-11 13:16 ` T. V. Raman
2007-09-14 14:25 ` Carsten Dominik
0 siblings, 2 replies; 4+ messages in thread
From: Robert D. Crawford @ 2007-09-11 2:06 UTC (permalink / raw)
To: org-mode list
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!!!!"
^ permalink raw reply [flat|nested] 4+ messages in thread
* spreadsheet advice
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
1 sibling, 0 replies; 4+ messages in thread
From: T. V. Raman @ 2007-09-11 13:16 UTC (permalink / raw)
To: robdcraw; +Cc: emacs-orgmode
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
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: spreadsheet advice
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
2007-09-22 14:48 ` Robert D. Crawford
1 sibling, 1 reply; 4+ messages in thread
From: Carsten Dominik @ 2007-09-14 14:25 UTC (permalink / raw)
To: Robert D. Crawford; +Cc: org-mode list
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
^ permalink raw reply [flat|nested] 4+ messages in thread
* Re: spreadsheet advice
2007-09-14 14:25 ` Carsten Dominik
@ 2007-09-22 14:48 ` Robert D. Crawford
0 siblings, 0 replies; 4+ messages in thread
From: Robert D. Crawford @ 2007-09-22 14:48 UTC (permalink / raw)
To: Carsten Dominik; +Cc: org-mode list
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.
^ permalink raw reply [flat|nested] 4+ messages in thread
end of thread, other threads:[~2007-09-22 14:48 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
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
2007-09-22 14:48 ` Robert D. Crawford
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).