How to Make an Insulin Spreadsheet

For people with diabetes, tracking your insulin needs daily is very important. Proper management of your blood sugar levels and insulin requirements is vital for your overall health. Your doctor uses this information to decide if adjustments are needed, and you can also make day to day adjustments if you have the information you need. An insulin spreadsheet can make diabetes management that much easier.

Instructions

    • 1

      Open your spreadsheet program. Create a title for your spreadsheet, such as "My Insulin Chart." You can add this at the third column, so it appears centered over the rest of your columns.

    • 2

      Skip a row, then add your column titles one by one. The first should be the date column. The next ones should be named for each time you check your blood sugar, such as breakfast, lunch, and dinner. Leave a space between each column where you check your blood sugar, so you can include both your blood sugar result and the amount of insulin you took.

    • 3

      On the next row, you can add individual labels for blood sugars and insulin, or you can leave them blank if you can remember which amount goes where. On the side of your chart, you can enter in your doctor's sliding scale for your insulin, if applicable. For example, if your blood sugars are in the 180-200 range, your doctor may suggest increasing your insulin by two units.

    • 4

      You can color code your columns and add borders by right-clicking on the area you want to enhance. Choose "format cells" to add any colors or lines to make your chart more functional for you.

    • 5

      Next, you can either print out your chart, or calibrate your blood sugar machine to upload the results to your spreadsheet. However, you will still have to manually add how much insulin you took each time, so remember to update your chart often.

Diabetes - Related Articles