3,99 €
Mehr erfahren.
This book enables you to log your meals, medications, exercise and readings more conveniently. The auto-log software logs the time of entry and flags the type of entry. You need only enter your numbers or other information. Spread Sheets calculate and display average glucose readings by meal, time of day, day of the week, week of the month and gives grand total. All of these results and calculations can be printed out for you and your healthcare Professional's use.
Das E-Book können Sie in Legimi-Apps oder einer beliebigen App lesen, die das folgende Format unterstützen:
Veröffentlichungsjahr: 2014
Ähnliche
SOFTWARE FOR DIABETICS
BookRix GmbH & Co. KG81371 MunichCHAPTER 1 YOUR DIET
Part of the heartache of having diabetes is the way it sometimes seems to suck up every part of your free time.
Imagine having to stop what you’re doing every 4 or 5 hours and perform a ritual that involves stabbing yourself with a pin-like tool, bleeding a drop of blood, then writing down the number.
Imagine having to stop after every meal or snack to write down what you ate, how much, along with the date and time of the day.
I’m not suggesting that the diabetic not do these things, but I have automated the process so the computer is doing most of the work.
Click on the icon, write what you ate and, if you need to, enter the medication type and dosage. The computer does all the rest, entering the date and time and logging the information for you.
You can print out multiple copies if needed. I always print out 2 copies so I have one to look at while the Doctor, PharmD or Dietician is looking at theirs.
With all the times, totals, descriptions, dosages and averages laid out neatly, you have more time to talk with your healthcare professionals because they don’t have to decipher your handwriting and crank through the numbers while you sit and wait.
Your progress is available at a glance.
With the cost of healthcare today, you want the maximum amount of time to work with your healthcare professional.
CHAPTER 2 KNOW YOUR ENEMY
After so many decades of being a type II diabetic, there is so much I could tell you.
There is so much I could tell you about the balance between Blood Glucose and Insulin.
There is so much I could tell you about the balance of exercise and Blood Glucose.
There is so much I could tell you about the balance of exercise and Insulin.
There is so much I could tell you about the balance of exercise and weight.
There is so much I could tell you about the balance of weight and Blood Glucose.
There is so much I could tell you about the balance of insulin and weight.
Did I mention there is a balance between weight, blood glucose, diet and exercise? It’s a complex business, but I’m not a licensed Physician, so I can’t tell you what I know.
I encourage you to find the answers. Your life depends on it and that’s not medical advice, it’s a fact.
If you have questions there are three people on your team. I will introduce each of them in the next three brief chapters.
CHAPTER 3 YOUR DIETICIAN
There are relationships between different foods that you need to be aware of.
Various foods fall into various categories, such as protein, vitamins, minerals, carbs and more.
Some of the factors in your diet include foods that metabolize at different rates. There are foods with various glycemic index levels that can cause your blood sugar readings to vary in ways you need to understand. Is a baked potato going to raise your blood sugar faster than french-fries? You might be surprised. Glycemic index and caloric values are different in the way they affect your blood sugar and weight.
Your Dietician can help you to control your blood sugar and your weight, but only if you do the work.
The entire process is much like the time I joined a gym to reduce my weight and get into shape. I paid every month faithfully weighed myself every day and never lost any weight at all. Then I figured out the problem. I had to go there and work out or the membership was useless.
My experience with Dieticians is much the same. I have studied diet and nutrition. I have visited Dieticians and had the discussions about my eating habits, but never seemed to have a lot of luck.
Then, much like the gym situation it occurred to me that knowledge of good nutrition isn’t helping the situation when I’m living on spaghetti and hot dogs.
Ask your Dietician about your caloric set point and how to lower it. That will do a lot to help you control your weight.
CHAPTER 4 YOUR DOCTOR
The Doctor is your General in the war against diabetes. If you have a choice, pick a good one. Your life and health is in his hands to some extent, but only if you follow his advice.
The one person who wholly owns your success or your failure is you. No one else is usually there when you make a bad choice.
When you have the spreadsheets completed with the matrix of data depicting the averages, see how the Doctor feels about the complete overview of your measurements and information.
The matrix of average results plays in concert with the listing of meals and medications. Together they form a complete picture of your treatment, except for exercise.
You can enter your exercise information in the space provided for food, giving the distance walked or the equipment used.
Because the “Nutritional Information” log has no calculations involved, you can enter anything you want.
The log will post the time and date of the entry, but will not post the actual meal or activity time and date, so post entries as soon as possible after performing the task.
CHAPTER 5 THE PHARMD
If you’re lucky enough to have a Doctor of Pharmacology assigned to you, take full advantage of their expertise. A good PharmD can advise you of the best course of treatment for you.
The PharmD is the most knowledgeable person for deciding which insulin will be best and which medications will be most effective.
When taking a blend of medications, there is a danger of interaction when some are combined in your treatment.
The PharmD is the expert on these complex interactions. Having the PharmD review your medications is a smart move.
CHAPTER 6 DOWNLOAD & INSTALL
Let’s get the show on the road here. You will need your PC and an Internet connection in order to install the software covered in this course of instruction.
First you will need to prepare a place for the software and spreadsheets to go. The best place for now is probably drive C, so click on the Icon, System Information, and the list of disk drives will be displayed.
Now click on Drive C: and when it opens, right click on it. A command box will open and you will click on menu item, “New” and when the sub-folder opens, click on “Folder”.
You can name the folder anything you want. I like to call it “Diabetic Software”.
Bring up your Internet Browser and type in the following URL.
Be sure and type it in exactly as shown. http://www.RobStetson.com/Diabetic/Load.html
This address is case sensitive and if you fail to capitalize the letters shown and have the rest in lower case, the connection will fail.
After going to the web location shown above, the screen will show a page with no menu and 5 files.
As you click on the “Runner” link, your Windows Browser will ask what you want to do with the file. Click on “Run” and be aware that this program needs to be run only once to install the DLL’s for the program “Nutrition.exe”. The DLL’s are the “Runtime” files. There is no reason to download the program called by “Runner” unless you choose to.
I have seen warning flags for Runner saying “Unknown Publisher”. Don’t panic, just say, “Yes”. Saying yes just means you are allowing the program to install the runtime files needed to run the program.
After you have run the program called by the “Runner”, you can install NI.exe. Click on the Link called “Nutrition” and select “Download” as your option using “Save as” and specifying C:Diabetic as the target folder.
After the system has saved the file, do the same for the link, “Data”, Spreadsheet1 and Spreadsheet2. With all 4 files in the folder, you have successfully installed the software.
Now you need to put an Icon on the desktop for the file NI.exe if you want to run the program conveniently.
By the way… You will find a file called z.txt in the folder. Don’t delete that. It’s your database which I have created in ASCII so you can read it clearly using Notepad, MS Word or any other editor.
This makes it an open source data file. I just hate it when someone writes software and then encrypts the data file so you can’t get at it any other way.
I just put a shortcut to the folder on Drive C:Diabetic and it enables me to not only run NI.exe, but it also enables me to simply click on BSB1.xlsx and BSB2.xlsx.
When you click on either BSB1.xlsx or BSB2.xlsx, they open in Excel so you can read the content, print them out or enter the data.
We’re going to get back to the BSB files shortly, but first, let’s talk about the NI.exe file.
CHAPTER 7 USING NI.exe
When you open NI.exe the program runs with the following window as your control panel.
This control panel enables you to enter your day to day meals, readings, exercise info and medications.
Instructions are built right into the form. If you practice using the program you will become proficient at entering the data.
Notice the time and date information at the top of the form. This data is retrieved directly from your system’s clock information. However accurate your system’s time and date information is, that will be reflected in your data sheets.
Under the time and date box, there is a large window where you will enter the information regarding your food or exercise routine. Try to be brief. There is a lot of room to write, but the program can only scan in a certain amount of data before the buffers and arrays overflow,
Do food as one entry. Then do exercise (if you are including it) as a separate entry. When doing exercise you will have to select a mealtime for the entry because there is no exercise bullet on the list.
After you write out a meal or regimen, select one of the bullets on the left to identify the mealtime for the entry.
The bottom 2 bullets in the list of mealtime selections are for the bottom portion of the form where you enter information regarding your medication and blood sugar readings.
Since you may not be taking these readings and medications at the same time each day you are eating your meal, I have put a window toward the left under the meal data entry window labeled “TIME”. This is the time you enter with the keyboard manually.
Use the format you choose because the system does not read it, it just prints it as part of your data entries.
To the right of the “TIME” entry window is the “VALUE mg/dl” which means “Value in milligrams-per-deciliter”.
That is the standard unit of blood sugar measurement.
Take the “VALUE mg/dl” straight from the window on your glucometer.
Once you have entered the time and the reading, click on the button on the far left row of buttons called “VALUE mg”.
This will store the value you have entered in the window.
If you fail to put the dose in the window, and then click on the button, the values will not be stored.
Next are the 2 windows under the “VALUE mg/dl” window. These are labeled “MEDICATION DOSE 1” and “MEDICATION DOSE 2”.
Once again, you have literary license to write whatever fits in the window.
If you take insulin, input the type and number of units.
If you take pills, input the type and number of pills you took.
I have 2 windows for entering data, but you can choose to leave the second one open, or you can do more medications using separate entries.
Remember, if you add more entries, clear the windows marked MEDICATION DOSE if the window is not going to be used again.
CHAPTER 9 USING THE BSBs
You see the ads on TV and they all say, “Test your readings and test them often.”
“Often” is rather subjective, so let me say, “Test your readings and test them in the specific frequencies required by your health care provider.”
The pre-formulated Excel Spread Sheet will give you a running total of your readings along with a running average for breakfast, lunch, and dinner. It will also give an average trend for mornings, noon and evening readings. It also gives an average trend daily, weekly and total over all.
By seeing your average trends, you can consult your Nutritional Information log printed out from (Z.txt) and, hopefully, get some clues to the changes in your average readings.
The Excel formulas are not complex and they do the entire calculation for you. The formulas are already embedded in the spreadsheets when you download them.
There is a row and a column that requires no formulation. These have an open labeling format requirement, meaning that you can type in anything you want.
I have typed in the first row that will appear at the top of the page when you decide to print them out.
The left column “A” is the day of the week and I insert the month number 1 through 12, a slash and the days date for each row. You can see the method I use in the example screenshots.
Above is the 3 readings a day spreadsheet.
Below is the 4 readings a day spreadsheet.
Both are essentially the same in terms of the formulation and the daily averages.
The spreadsheet shown above is the way it will look when you download the software for the first time.
The empty spreadsheet is clustered with the content “#REF!” which means there is no data available for the formula.
You will be providing data as you take your readings.
Some of the examples shown here have three columns for data and some have four columns for data. I have provided both sizes of forms because some people measure three times a day and others measure four times a day.
