A diabetic patient must keep a log of his blood sugar levels regularly. In order simplify the process we have created a Monthly Blood Sugar Log Excel Template to maintain a monthly log of your blood sugar levels.
According to 2016 statistical data from the World Health Organization, an estimated 422 million adults are living with diabetes mellitus. It has been constantly increasing.
As per the American Diabetes Association, the normal level of blood sugar before breakfast(also called fasting levels) should be between 80 mg/dl to 130 mg/dl. Whereas the blood sugar level after 2 hours of lunch should be 180 mg/dl.
To download the National Diabetes Statistics Report, 2017 click on the link below:
A patient having blood sugar levels below or above this has to consult a health care physician and take appropriate precautions.
Considering the above-mentioned normal levels, we have created Monthly Blood Sugar Log Excel Template with predefined formulas.
If your levels are below or above the normal levels the template will automatically turn the cell red in color. This template can be helpful to patients suffering from diabetes, health professional/ consultants etc.
You can manage data in excel using it on your phone, personal computer, laptop or even in the form of a printable sheet.
Let us discuss the contents of the template in detail.
Contents of Monthly Blood Sugar Log Excel Template
Monthly Blood Sugar Log Excel Template consists of 3 sections:
- Personal Information
- Sugar Levels (Normal and Targets)
- Datewise Monthly Blood Sugar Log
1. Personal Information
Here you need to enter the name of the patient, his age, gender and the name of the consulting doctor. Manually enter the name of the patient, name of doctor and age. You can select the gender from the drop-down menu.
2. Sugar Levels (Normal and Targets)
As discussed above, the normal blood sugar levels for fasting are between 80-130 mg/dl and post lunch are 180 mg/dl. Target Sugar levels are those that you want to achieve.
3. Datewise Monthly Blood Sugar Log
Datewise Blood Sugar Log consists of following columns:
- 2 Hours Post Lunch
- Additional Remarks
Enter date in the first column in dd/mm/yyyy format.
Time is at which you measure your blood sugar level. Time must be entered in hh: mm format. The time must be entered in 24 hours calculation. For example, 1:00 pm will be entered as 13:00.
Fasting level means the blood sugar level taken in the morning before taking any intake.
The second column of time is for the time of measuring blood sugar level 2 hours post lunch.
A separate column has been given for putting additional remarks. If there are any complications or symptoms you face can be written here.
Disclaimer: There are 3 major types of Diabetes. This template has been created with a general overview. It is highly recommended that you consult your Health Care Physician (HCP) for the normal range of your blood sugar levels and any complications.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. We will be more than happy to assist you.