From mboxrd@z Thu Jan 1 00:00:00 1970 From: "T. V. Raman" Subject: spreadsheet advice Date: Tue, 11 Sep 2007 06:16:57 -0700 Message-ID: <18150.38217.21522.919173@gargle.gargle.HOWL> References: <87fy1m9cr1.fsf@gmail.com> Reply-To: raman@users.sf.net Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1IV5bw-0006G6-5S for emacs-orgmode@gnu.org; Tue, 11 Sep 2007 09:17:00 -0400 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1IV5bu-0006Fh-PD for emacs-orgmode@gnu.org; Tue, 11 Sep 2007 09:16:59 -0400 Received: from [199.232.76.173] (helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1IV5bu-0006Fe-E1 for emacs-orgmode@gnu.org; Tue, 11 Sep 2007 09:16:58 -0400 Received: from alnrmhc14.comcast.net ([206.18.177.54]) by monty-python.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1IV5bu-0003zl-06 for emacs-orgmode@gnu.org; Tue, 11 Sep 2007 09:16:58 -0400 In-Reply-To: <87fy1m9cr1.fsf@gmail.com> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: robdcraw@gmail.com Cc: emacs-orgmode@gnu.org 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 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