HelpDiabetes is a help for people with diabetes. It is a carb counting application that runs on a cellular phone. The application has built in the Norwegian Food Composition Table :
The Norwegian Food Safety Authority, the Directorate of Health and Social Affairs and the Department of Nutrition at the University of Oslo have collaborated to publish the Norwegian Food Composition Table 2006 (MVT-06) :
It is also possible to make your own foodtable in Excel and transfer it to the GSM. The application also calculates the amounts of insuline needed for diabetic people.
Food composition tables in other langues are also available on
http://www.johandegraeve.net]HelpDiabetes - English
Use the application :
The first screen displays the list of all food items, starting with the first in alphabetical order.
Search an item :
You can search an item by entering the starting characters of the item's name, as you would type an SMS.
You can scroll with game keys 'UP' and 'DOWN' . Only characters a..z can be entered, but the application also recognizes variants for example é è ë are all found as 'e'.
To select a food item press the 'SELECT' key or choose option 'Choose'.
Note : some food items may have special characters like 'Macaroni cheese - Tin'. All the letters can be entered in the search box, and also the spaces by clicking the game key 'RIGHT' . However '-' can't be typed by pressing numeric keys. One possibility is to get 'Macaroni cheese - Tin' displayed as first item in the list, and pressing the game key'RIGHT' .
Letters can be removed from the search box by pressing keys 'C', 'BACK' of 'LEFT' (not all phones support the 'C' and 'BACK' key).
Count the amount of carbs and add to a list
After having selected a food item, you can choose the amount. The units are shown and is always 'gram' for the standard fooddatabase.
Example, suppose the selected food item is 'Bread White', press on numeric key '6' and then '0'. The application will immediately count the amount of carbs (gram) for 60 grams of 'Bread White' and show the result. Also the amount of proteins, fat and kilocalories are calculated. For these elements, only the total amounts are shown, being the total for all the food items that have been selected by you and added to the list with your chosen amounts.
If not all information can be shown on one screen, a scrollbar will appear on the right. Use keys 'UP' and 'DOWN' to scroll.
Remark : Total amounts are shown rounded to the lower Integer value. The calculation keeps into account the correct figures.
It is also possible to enter digits after the decimal point (eg 0,5 piece of apple, assuming an apple would be there with unit 'piece' (which is not the case in the standard table). Choose 'RIGHT', and the cursor will move to the decimal part, choose 'LEFT' and the cursor moves back to the Integer part. Chosing 'LEFT' also removes already entered digits.
Once you've chosen the amount, you can add the food item to a list by choosing option 'Add'.
Show total amount kilocalories, fat, proteins and carbohydrates and calculate amounts of insuline needed.
From the first screen, using option 'Show current total' you can see the total amounts of carbohydrates, fats, porteins and kilocalories for the chosen food items and amounts in the list.
Remark : whenever the source fooddatabase contains no value for proteins, fats or kilocalories for one of the items in the list of chosen items, then the totals are not calculated.
The amount of insuline needed is also shown here , this value is calculated based on personal settings. If your settings are not intialized, the amount of insuline is not calculated.
Show Current list of chosen food items
With this option you can view the list of food items selected so far with the amounts.
It's possible to modify one of the amounts : scroll 'up' or 'down' to scroll to the item you want to change, press 'select', now you can change the amount.
Choose 'Save' to store the new amount or 'back' to cancel.
With this option you remove the food items that you selected and have added to the list. You do this typically at start of a new meal.
You can make your own version of the food composition table on a PC using Excel. Use fooddatabase.xls which you can find here
, and add your own items at the bottom on the first empty row. The application will stop reading when the first row with column A empty is found. You can also modify existing items.
There's no limitation to the characters used in the names of the fooditems. Choose the unit which can be any free text and the standard amount. Example : unit can be "gram", standard amount can be "50". You then enter the amounts of carbohydrates, kilocalories, fats and proteins for 50 gram. Unit could also be "slice" with standard amount "1". Both fields can also be empty.
The amounts of kilocalories, fats and proteins is optional.
When the list is ready, press ctrl+h or click on 'Press here to prepare the worksheet for transfer to the GSM'. The Excel table will be saved and a second file will be generated named foodfileuk.csv and stored in c:\temp (c:\temp must exist on your PC !)
Copy the file c:\temp\foodfileuk.csv to your cellular phone using USB/Bluetooth/Infrared. Then you can use the HelpDiabetes application on the phone to load foodfileuk.csv using 'options' 'Reload'.
- You should put excel macro security to low. In Excel chose Tools Options Security 'macro Security' 'Low'
- if you want to enter digits after the decimal point, use the decimal which you would normally use in Excel. The table attached uses '.' as decimal point (example 2,5 is written in the table as 2.5). If you would normally use ',' , use it here also.
- Set the amounts of required insuline : what je enter is the amount of grams of carbohydrates you can have per unit of insuline. This you can do for breakfast, dinner, supper.
- Set the times you switch from breakfast to supper, supper to dinner. The application will use these times to use the correct value of amounts of carbohydates per unit insuline.
- font size
- speed : this is a setting which allows to take into account the different capacities of cellular phones.
Nokia phones seem to work faster than Sony Ericsson. The standard value is 50. For Nokia phones you can set it to 1000. For Motorola phones even to 2000.
Please verify the food composition table and experiment with the application before you start using it. Note that this program is only a help. I've written it for myself because I want to be able to do precise calculations without having a PC next to me. This is also how you should use it.
I do not take the responsibility for the consequences of misusing this application