diabetestalk.net

Diabetes Spreadsheets

Diabetes Meal Plates | Reverse Diabetes

Diabetes Meal Plates | Reverse Diabetes

Author's Perspective: When I was diabetic, I used MS Excel spreadsheets to do my meal planning. But, when I started doing talks, the Excel spreadsheets didn’t go over very well. :-) So, I created a pictorial representation of what a healthy meal plate should look like. The meal plate diagram was such a big hit at my next talk, that I had to make over 300 copies just for one meeting. By the following month, I had made and handed out more than 2,000 copies! Later, I had to create additional examples of meal plates for breakfast, lunch, dinner and snack for the meetings. At that time, I didn't realize that these diagrams would become the foundation of my diet program; and, later, my book. The following are the pictorial representations of the sample meals for breakfast, lunch, dinner and snack. As previously mentioned, this meal plate model and this type of plant-based diet is supported by hundreds of clinical studies, including the China Study. The benefits of a plant-based nutritional program can prevent and possibly reverse the effects of heart disease, Type 2 diabetes, and possibly some cancers. This meal plate model has many of the attributes of the Zone Diet, Mediterranean Diet, Paleo Diet, South Beach Diet, Raw Food Diet, Asian Diet, Detox Diet and Vegan Diet. Continue reading >>

Type 1 & 2: Free Excel-based Calorie Control Program

Type 1 & 2: Free Excel-based Calorie Control Program

My Deluxe Calorie Diary, a free Excel-based spreadsheetprogram designed by Thomas M. Manger, MD, PhD, allows usersto record all their daily meals and snacks and instantly learntheir totals for calories, carbohydrates, fats and proteins. Do you want to know just how many calories you burn duringan hour-long aerobics class? My Deluxe Calorie Dairy will tally the total number of calories you burn throughout the day ina variety of activities and will compare the calories burnedwith calories consumed. Theresults are displayed to showdaily progress. The software is available atno cost. To download, go towww.smartcalorie.com. I think that it’s safe to say that none of us were happy when we first found out that we had diabetes. The words “you’re a diabetic” or “you have diabetes” can sound like a death sentence and while we … This time of year, I always like to look back at the previous year and reflect on the people and the events that shaped me; giving thanks for what I have learned and reflecting on what I would like to … Continue reading >>

Building A Computerized Disease Registry For Chronic Illness Management Of Diabetes

Building A Computerized Disease Registry For Chronic Illness Management Of Diabetes

IN BRIEF Changes in lifestyle and food consumption are fueling a dramatic increase in type 2 diabetes in children and adolescents. To combat the increasing prevalence of obesity that underlies this trend, health care providers must recognize risk factores in their pediatric patients so that aggressive intervention can be offered. Development of strategies to curb obesity and prevent type 2 diabetes require a team effort by parents, health providers, school personnel, and motivated patients. The University of Washington Physicians Network (UWPN) is a nonprofit primary care delivery system in Seattle with nine clinics linked by a computerized, networked clinical information system. In 1998, UWPN initiated a diabetes management program in collaboration with the Institute for Healthcare Improvement. In the process of developing the diabetes program, several successive types of registry systems were constructed using a computerized spreadsheet and a relational database. This project has clarified some of the challenges that any delivery system seeking to construct a diabetes management program must face regardless of whether they have paper charts or a completely computerized medical record system. As more providers make the transition to computerized clinical information systems, there will be greater opportunities to use the information residing in electronic charts for population-based care of chronic diseases like diabetes. This article reviews the conceptual framework for chronic illness management programs. It then addresses specific key issues pertaining to construction of a registry for diabetic patients using readily available software. The Conceptual Framework for Chronic Illness Management Chronic illnesses such as diabetes are characterized by gradually worsening Continue reading >>

Diabetes Meal Planning And Nutrition For Dummies

Diabetes Meal Planning And Nutrition For Dummies

From Diabetes is a serious medical condition where your body cannot properly process foods to meet your energy demands and keep your blood glucose levels balanced. But, you can do a lot to help your body work better. Adopting, and sticking to, a heart-healthy diet that also manages your intake of carbohydrate foods can help prevent the complications of diabetes for years to come. When it comes to diabetes, food is medicine. Diabetes-Friendly Foods to Keep on Hand One trick to eating healthier is keeping diabetic-friendly choices available at all times. You can fight the urge to hit the fast-food drive-through and instead whip up a convenient and healthy breakfast, lunch, dinner, or snack if you keep the right foods handy. Some healthy foods to always have on hand in your pantry include: Olive oil or canola oil for healthy, unsaturated fats Egg substitute for the high-quality egg white protein without the fat and cholesterol Frozen fruits and vegetables for healthy choices at every meal Herbs and spices, fresh or dried, to replace salt with intense flavors Whole-grain, high-fiber tortillas for sandwich-like lunches without the full amount of carbohydrates in bread Canned tuna (in water) to have healthy seafood available anytime — aim to eat seafood twice each week Almonds, walnuts, or peanuts for healthy fats Black beans (or your favorite beans) for healthy carbohydrate, protein, and soluble fiber Buy no-added-salt varieties of canned beans Low-fat dairy products, including 1 percent or skim milk, and no-fat regular or Greek yogurt. Remember that milk products include carbohydrates Tea, for relaxation and powerful phytonutrients Managing Diabetes Takes More than Just Food Preparation for diabetes meal planning and nutrition starts with a very minor kitchen makeover. Yo Continue reading >>

Diabetes Spreadsheet

Diabetes Spreadsheet

This is example of Diabetes Spreadsheet designed to inspire you in creating a spreadsheet for your business. This simple spreadsheet is a simple and fairly basic example, so depending on your business and your policies you may find that you may want to add more columns for the information you need. We provide an example of this Diabetes Spreadsheet in the form of an image. You can take an example of this Diabetes Spreadsheet by saving it to your desktop PC, laptop, Mac, tablet PC, or smartphone. We hope this Diabetes Spreadsheet is useful to you. Gallery of Diabetes Spreadsheet Related Post "Diabetes Spreadsheet" Continue reading >>

On-line Diabetes Resources

On-line Diabetes Resources

Log Sheet or Spreadsheet A log sheet is an alternative or adjunct to software. There are a lot of different log sheets out there, but the best, in my opinion, is one developed by Jean-François Yale, M.D., Associate Professor of Medicine, Crabtree Nutrition Laboratories, McGill Nutrition and Food Science Centre, Royal Victoria Hospital, and Director, Metabolic Day Centre. I met with him in Montreal in August 2002, and at that time he authorized me to make his log sheet available on my Web site. Dr. Yale's log sheet lets you enter blood glucose readings, insulin dosages, carbohydrate grams, and exercise (which you can put on a scale of 1 to 5) for any hour of the day. Before printing the log sheets remember to change the page layout to landscape and when you are finished to change it back to the usual portrait layout. Two pages of the log sheet cover the seven days of the week. It is an Adobe Acrobat PDF file, which requires the free Acrobat Reader, available at if you don't have it already. Download the log sheet at Added February 1, 2010: HumaLogger is a new website that makes it easy for you to log your blood glucose levels online. Following are their service plans: Monthly: $2 monthly Yearly: $24 yearly Both monthly and yearly services include: Glucose Log, Blood Pressure Log, Medication INtake Log, Weight Log and Exercise Log. They provide a free 14 days trial which you can subscribe to on their website here: A spreadsheet is yet another way to track your blood glucose readings, insulin dosages and ratio, carbohydrates grams, and exercise. To view it you need to have Microsoft Excel or OpenOffice at Not only is OpenOffice free, but it is also available on Macintosh and Linux platforms in addition to Microsoft Windows. Kenneth A. Carrasco has developed a printable/po Continue reading >>

Blood Sugar Chart

Blood Sugar Chart

Our free blood sugar chart (or blood glucose chart) lets you track your blood sugar levels throughout the day. It also allows you to enter in normal blood sugar levels, both high and low, so you can see how well you are staying within your healthy range. Next to each entry, you can enter notes about your diet and exercise, to see how they affect your levels. You can also keep track of your A1C levels (also referred to as hemoglobin HbA1c levels), which you get tested by your doctor. Printable Blood Sugar Log For Excel & PDF When you measure your blood sugar levels, you're not always next to your computer. This printable blood sugar log allows you to write down your results no matter where you are. Print this blood sugar log and attach it to your fridge or wherever you typically test your blood sugar. Description With this Blood Sugar Chart spreadsheet you can enter your blood sugar test results and see those results plotted on a graph along with your recommended upper and lower blood sugar levels. Remember to enter notes next to your entries regarding your diet and exercise so that you can see how they may be affecting your levels. Consult a doctor to find out what your upper and lower levels should be. This spreadsheet also contains a chart for tracking your A1C level. For the A1C level chart, you can enter the level that your doctor recommends you stay close to. Using a Blood Sugar Chart Tracking your A1C levels * Continue reading >>

Graphics And Spreadsheets

Graphics And Spreadsheets

The lattice library is actually flexible enough to produce separate plots for each state: > xyplot(Diabetes~Prim_Care_Phys_Rate|CHSI_State_Name,data=risk,main='Diabetes vs. Physician Rate by Region') Looking at the plot, we should make some elements of the plot smaller, namely the titles on the strips and the points themselves: > xyplot(Diabetes~Prim_Care_Phys_Rate|CHSI_State_Name,data=risk,main='Diabetes vs. Physician Rate by Region',cex=.5,par.strip.text=list(cex=.6)) This results in the following plot: Finally, let's suppose that we want to break up the plots into two pages, each with 25 plots in a 5x5 arrangement. To get exactly 50 states, we'll use the argument of the lattice functions to remove Alaska (for which there's no data), and the argument to arrange the plots the way we want, and the argument to call a function at the end of each page: > xyplot(Diabetes~Prim_Care_Phys_Rate|CHSI_State_Name,data=risk,main='Diabetes vs. Physician Rate by Region',subset=CHSI_State_Name != 'Alaska',layout=c(5,5,2),page=readline) You can run this example to see the two pages. Now that we've seen some of the basics of how the lattice library routines work, we'll take a look at some of the functions that are available. Remember that there are usually similar alternatives available among the traditional graphics functions, so you can think of these as additional choices that are available, and not necessarily the only possibility for producing a particular type of plot. Univariate displays are plots that are concerned with the distribution of a single variable, possibly comparing the distribution among several subsamples of the data. They are especially useful when you are first getting acquainted with a data set, since you may be able to identify outliers or ot Continue reading >>

Free Blood Glucose Spreadsheets

Free Blood Glucose Spreadsheets

Good glucose control with type 2 diabetes is very important. It's the difference between good health and serious complications. Why? Because it's the high glucose levels that cause damage to the vessels and organs throughout the body. And that's exactly where blood glucose spreadsheets can act as a great tool (and we have some to give you for free). Before moving on, let's get one thing clear: blood glucose and blood sugar refer to the same thing. So, let's look a little closer at blood glucose monitoring and control. What Does It Mean To Control Blood Sugar Levels? It simply means you want to get your blood glucose and A1C as close to normal (non-diabetic) as possible and maintain them at normal levels, too. What's normal? FASTING AFTER MEALS 2 HOURS HbA1c Normal 70-99 mg/dL (4-6 mmol/L)* <140 mg/dL (<7.8 mmol/L)** <5.7% *Note that different agencies establish different standards. Some range 70-100 mg/dL, some 70-110 mg/dL, some 70-130 mg/dL. **Some agencies recommend <180 mg/dL post-meal especially in the elderly and those who have had diabetes for a very long time. Setting Goals to Lower Your Blood Glucose Overall your goal is to gain good control of your diabetes, which means maintaining normal glucose levels, or getting as close to normal levels as possible (refer to the normal numbers above). But, be aware that you must work with your doctor or healthcare team to set goals. If your glucose is currently running at 250 (13.9), it's unrealistic to think you'll reach 140 (7.8) overnight. In this case your initial goals would be higher, then once you reach those you will adjust again. Please pin, tweet or share; then keep on reading. Testing and Logging Blood Glucose Your physician or health practitioner may recommend different testing routines for you, for instance, o Continue reading >>

How Do You Keep Diabetes Logs?

How Do You Keep Diabetes Logs?

One of the most important self-management skills is keeping logs of health-related information. Do you do that? What do you keep records of? Are you consistent with logging, and does it help? I’m working a lot these days with people newly diagnosed with Type 2. I believe logging will help them understand how their bodies work and what affects their diabetes, but maybe I’m wrong. How can I help them start with logging, and should I? What should they log, and how can they do that? I’m asking for help because logging is a skill I’m terrible at. I trust my memory on things like what I ate, how far I could walk, how many times I fell, etc. It never works. Two months later, who can accurately remember what supplements they were taking or how many days they did their stretching exercises? You’re just guessing most of the time, so you might miss important patterns that a good log would show. Most people with diabetes, if they monitor at home, at least record their blood glucose results. But do you also record what you ate, your activity, what medications and supplements you took? Do you keep track of how you feel, your energy levels and symptom levels? When you think about it, you could log so many different parts of your life. It all might be helpful, but it’s also a lot of energy and time spent. I can’t imagine many people doing it all. Do you think it’s worth doing, or even possible? If you keep logs, how do you do it? I just use a big notebook and write down things that I think of, but I’m sure it would be better to be more orderly. There are diabetes logs for computers and apps for cell phones. Most monitors now will link to computers to store results and put them into charts. Do you use any of those, and do they help? The diabetes log I give out has five Continue reading >>

Recordkeeping

Recordkeeping

Thorough record keeping provides an invaluable tool for both you and your vet to determine the needs of your sugar pet. Without good records you won't see the "whole picture" of how your dog is doing or whether and increase/decrease may be in order. Accurate data will also give you a reference of how your dog reacts to doses, feedings and times of day. It's good to have a Diabetic Log book for your diabetic dog. It should contain everything needed to maintain up to date information. One suggestion is to purchase a hard surface 3 ring binder that has a pocket on each cover. On the front inside pocket to clip a business card for your vet as well as your local emergency clinic. In a crisis it is handy to know where these are. On the front you might insert a picture of your dog and the title Diabetic Log Book. The picture of your dog could be handy for a pet sitter, etc. to know without a doubt who they are caring for. List of items you should have in your Log Book BG Log Some glucometer manufacturers also provide logging software, such as this free software from LifeScan, [1] the manufacturer of the One Touch meters Vet information Insulin Type/Manufacturer/Ordering Info (+script if necessary) Syringe Type/Ordering Info (+script if necessary) Most recent lab results Pet sitter information Blank pages for notes The curve article discusses recording blood glucose numbers and completing a curve graph. Having a card with information on it in the area with your driver's license stating you have a diabetic pet at home, possibly with some individual care information on it would be great. In cases of accident/illness away from home, the driver's license is ALWAYS checked for your ID, in case you're unable to ID yourself. At home, it's good to keep a current sheet of information in Continue reading >>

Classification Of Diabetes (cod) Self Audit Toolkit

Classification Of Diabetes (cod) Self Audit Toolkit

Key references: de Lusignan S, Khunti K, Belsey J, Hattersley A, van Vlymen J, Gallagher H, Millett C, Hague NJ, Tomson C, Harris K, Majeed A. A method of identifying and correcting miscoding, misclassification and misdiagnosis in diabetes: a pilot and validation study of routinely collected data.Diabet Med. 2010 Feb;27(2):203-9. PMID: 20546265 Stone MA, Camosso-Stefinovic J, Wilkinson J, de Lusignan S, Hattersley AT, Khunti K. Incorrect and incomplete coding and classification of diabetes: a systematic review. Diabet Med. 2010 May;27(5):491-7. PMID: 20536944 de Lusignan S.Flagging fasting plasma glucose specimens: time to routinely label the context in which pathology specimens are recorded. Inform Prim Care. 2009;17(2):63-4. PMID: 19807947 Bagheri A, Sadek A, Chan T, Khunti K, de Lusignan S. Using surrogate markers in primary electronic patient record systems to confirm or refute the diagnosis of diabetes. Inform Prim Care. 2009;17(2):121-9. PMID: 19807954 Rollason W, Khunti K, de Lusignan S. Variation in the recording of diabetes diagnostic data in primary care computer systems: implications for the quality of care. Inform Prim Care. 2009;17(2):113-9. PMID: 19807953 de Lusignan S, Sadek N, Mulnier H, Tahir A, Russell-Jones D, Khunti K. Miscoding, misclassification and misdiagnosis of diabetes in primary care. Diabet Med. 2012 Feb;29(2):181-9. doi: 10.1111/j.1464-5491.2011.03419.x. Sadek AR, van Vlymen J, Khunti K, de Lusignan S. Automated identification of miscoded and misclassified cases of diabetes from computer records. Diabet Med. 2012 Mar;29(3):410-4. doi: 10.1111/j.1464-5491.2011.03457.x. Continue reading >>

Diabetes Excel Spreadsheet

Diabetes Excel Spreadsheet

Home | About | How to use software | Contact | Definitions | FAQ | Information Links Computer Issues | DOS Commands | Troubleshoot Tools | How to use Windows | Site Map Copyright © 2002 UpgradeNRepair. All Rights Reserved. > DISCLAIMER:UpgradeNRepair (UNR), the owner, and any representatives of UpgradeNRepair (UNR) is not liable for any data loss or hardware failure because of the following procedure. The Information provided is a guide to assist the customer with an issue with their system or software. The procedures offered here may or may not harm your files. Even procedures that are not designed to harm files, can harm files, depending on the issue with the system. Because there is too many unknowns, UpgradeNRepair is unable to guarantee the safety of the files. Customer is responsible for their data and their actions. Before following the directions on this page and the pages these links are linked to, any data the customer does not want to lose will have to be saved. Saving the data is the sole responsibility of the customer. Some or all of the following procedures or information may not apply to your situation. Continue reading >>

Diabetes Tracking Spreadsheet

Diabetes Tracking Spreadsheet

This diabetes tracking spreadsheet allows you to track the foods you eat and the glucose levels from your testing. By tracking both the food and the glucose readings, you can look back to see what effected your blood sugar levels. Knowing how your diabetes reacts to certain foods can help you control the glucose levels. In addition to the food tab and the glucose tracking tab, there is an instructions tab in the spreadsheet. Food Tracker Tab To record your foods, simply type in the food item description and any nutrition information you want to track. The nutrition columns include calories, fat, protein, carbs, sugars and fiber. There are additional columns that are formulas. Depending on what information you input, these will calculate the proper values. These additional columns are net carbs, WW Pts and Pts Plus. The net carbs is a calculation using carbs - fiber to give you the net carbs. The Weight Watchers points formulas use the calories, fat and fiber (for original points) and fat, carbs, fiber and protein for the plus system. So if you are a member and want to know the points, you must input all the nutrition information. If you do not have fiber available, just use zero for this nutrient. Glucose Tracker Tab On this tab of the diabetes tracking spreadsheet, you can track up to four weeks of glucose testing. There are columns for different times of the day so no matter when you take your test, you can record it here. There is an area to record your morning readings and bedtime readings. In addition, you can record your blood sugars before and/or after each meal. The averages for the week (and the four weeks totals) will automatically be calculated using the formulas in this spreadsheet. Once you are done with the four weeks, simply save the file as a new name if Continue reading >>

Pet Diabetes - Anne's Excel Instructions For Canine Blood Glucose Curve

Pet Diabetes - Anne's Excel Instructions For Canine Blood Glucose Curve

Instructions following the example of Max's Curve that Anne done in Excel...Thanks Anne! You can download this sample and directions at the bottom of this page! You will need winzip! 1) Open Excel and put headings on three columns: DATE TIME BG Enter the appropriate values under these columns 2) Once all values have been entered, bold only the TIME and BG columns including headings and values 3) Click once on the Chart Wizard button on the toolbar (blue yellow red bar graph) 4) Under the Standard Types tab, select Line graph ~ you can click on a button here labeled 'press and hold to view sample' to see what it'll look like. Click on Next > 5) Chart source data, click on Next > 6) Chart options, (here you can enter the title of the chart). Click on the Data Table tab and put a check in the Show Data Table box (this puts the actual readings along with times at the bottom of the chart), Click on Next > 7) Chart location, the default here is As object in, where the chart will show up next to your numbers. If you click in the top button As new sheet, you'll have a separate worksheet tab on the bottom of the whole spreadsheet that says chart1. Click on Finish 8) Once the chart has been added to the worksheet you can move it around to put it below the readings, make it wider so that all readings are showing. You can print the chart alone by clicking on it and hitting the print button. If you want to print the columns and values along with the chart, make sure you have clicked somewhere outside of the chart. Blood Curve Directions and Sample in a Zip Download the above zip and zip it opent into a file folder. Then open the file titled SampleSS.xls with Microsoft excel If you need addtional help on how to do this in Excel please email Anne Fiorenzo Max Continue reading >>

More in diabetes