LXGLUC.wk1 - Diabetes Data Management

These are the files you need. You can send them from the package contents below.

• LXGLUC.WK1 → A:\HOJAS hoja de Lotus 1-2-3 194.0 KB

No need to put LXGLUC.TXT: they are manuals, source code or supporting material. Read them here and save 25.1 KB on a 1 MB disk.

1. The .WK1 worksheets are not installed: open them from Lotus 1-2-3 with Menu → File → Retrieve.

Derived from the package contents and the 200LX conventions. It installs to A: on purpose: C: is a RAM disk and every byte there is memory taken from the system.

Installation:
   Open the worksheet and first setup
   Diary data entry
   Save changes and quit (Alt-Q)
   Manual timestamp for Diary (Alt-T and Alt-P)
   Erase diary and start new one (Alt-X)
   Longterm part data entry (Alt-T and Alt-L)
   Enter the basal insulin rate (Alt-B)
   Analyze data (ALt-A)
   Show graphs (Alt-G)
   Usage of the statistical data (NEW!)

THE MACROS
   ALT-T:
   ALT-Q:
   ALT-S:
   ALT-B:
   ALT-A:
   ALT-G:
   ALT-F:
   ALT-X:
   ALT-I: (NEW!)
   ALT-O: (NEW!)

TROUBLESHOOTING
   Worksheet Ranges:
   Different Language versions:
   A cell shows ****** or data in an unusual format:
   A graph looks stange, totally wrong scaling, **** as a label...
   Any other problems or bugs?

TODO


HISTORY:

v1.0 released 05/19/02:
     First release, some functions not yet implemented,

v1.1 released 05/30/02
     * Much improved Standard Day graph (now 24 bars, each for one hour
       of the day, instead of 4 ranges, additionally amount of
       measurements (which the value is calculated from) on top of the
       bars!
     * Improved Standard week graph (amount of measurements on top of
       bar)
     * Analysis macro now writes the date of its execution into
       cell Q4 and graphs use that date in the title, so it is now
       obvious how recent the data is from which a graph is created.
     * Basal Rate graph now uses Basal Rate date in title
     * Usage guide (LXGLUC.TXT) partially rewritten. Please read it!
       (Especially advice added how to use data analysis to improve
       the therapy)
     * macro \I added to import old v1.0 data.
     * macro \O added to sort the diary
     * minor macro enhancements


DISCLAIMER:
I have written this worksheet mainly for my own usage, but I decided to
…

Literal excerpt from LXGLUC.TXT, exactly as it came in the package.