How To

How to Create a File for Tracking Daily Glucose Levels

How to Create a File for Tracking Daily Glucose Levels
Member
By Sarah Wilson CCRP
eHow Community Member
(3 Ratings)

Tracking your glucose levels is very important, especially if your doctor noticed warning signs or if you are a diabetic. It is a lot like taking blood pressure medicine - if you miss a dose you will know it. Missing too many doses or allowing it to get out of control can be detrimental. I’m going to tell you how to create a file or a system to track your glucose levels.

Difficulty: Moderate
Instructions

Things You'll Need:

  • Diary & Pen - or -
  • Computer
  • Microsoft Excel or Word (or similar wordprocessing software)
  • Blood Glucose Checking instrument
  • Consistency!!!
  1. Step 1

    Keep a Diary.

    The best file you can have is a diary Get a notebook, a diary or a notepad and write down all readings before and after each meal, at bedtime and any other time that you do a glucose check. Better yet, write down your daily routine including the date, what you ate, when you ate and how you felt. Not that organized, huh? Well, carry a small notepad in your pocket or purse and write the reading down each time you take one.

    Tip: Many (if not all) of the blood glucose checking systems comes with a diary.

  2. Step 2

    Create an Excel Spreadsheet (or similar) and enter your reading.

    Go to Microsoft Excel and open a spreadsheet. In the first row, enter a heading for the file.

  3. Step 3

    In the next row, enter “Week Beginning: MM / DD / YYYY”. This will allow you to record the date one time which will be the Sunday date always.

  4. Step 4

    In the first column (or your column of choice) enter the days of the week in each row going down.

  5. Step 5

    In the column next to the days of the week, enter mealtimes going across. For example, enter Breakfast, Lunch and Dinner (we’re suppose to eat at least 3 meals a day, right?) Also enter a field for times when you think you need to take a reading but is not related to the meal. I call that “Unplanned”. In research, we call it “unscheduled”. Finally, in the next column, enter the word “Comments. You will need to write down explanations for low readings or high readings. When I say “explanations”, just try to write down anything you did different that day, like exercise 60 minutes longer (Yeah, right!) or skipped a meal or ate a whole pie - something along those lines.

  6. Step 6

    Enter a backward-slash in each row for each day of the week under each of the column headings. The reading before a meal will be recorded in front of the “slash” and the reading after your meal will be recorded behind the slash.

  7. Step 7

    Save the file with a name you can remember in a place you can find it and you are done. I recommend you save the file to your Desktop as you will access it several times a day.

    Tip: A similar chart can be created in Microsoft Word using the “Table, Insert” features.

  8. Step 8

    For the “Less Tech Savvy”, use an online form already created.

    The “Less Tech Savvy” is a term I picked up from a cyber-friend on The Third Option.net. Jess doesn’t like for us to call ourselves dumb or stupid when it comes to computers so I adopted his name for those of us who are not members of the Geek Squad. I digress, Sorry. Click on the Walgreen resource link below and print a ready-made chart for tracking your blood glucose levels.

  9. Step 9

    For the Software Savvy, create a database.

    Using Filemaker Pro or Excel Access, create a database using the same headings above and entering the readings as appropriate. This would be an awesome tool for you because you could do trends and see look for patterns to determine if there is any specific time that your sugar is low or high.

  10. Step 10

    Regardless of which tool you choose, track your glucose levels. It will help you and your doctor manage the illness and afford you a happy, healthy life.

Tips & Warnings
  • Go to Walgreen.com and print out a diary.(http://www.walgreens.com/images/pdfs/library/diabetes/self_care_diary.pdf)
  • Read the information on the site about diabetes.

Comments  

JIN1128 said

Flag This Comment

on 8/8/2008 Great tips!

Post a Comment

Post a Comment

Have you done this? Click here to let us know.

I Did This

Related Ads

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy.   en-US

Live Strong Partner
Livestrong_eHow Health