I am not sure if this will be wanted, or if this is even allowed; so mods if this isn't allowed, please delete this... I created a document for my son's diabetes to track as well as to calculate everything for my wife and myself. My wife was struggling the day my son was diagnosed while sitting in the Children's Hospital during class. I could see her slowly growing more frustrated with the math. I said "there has to be an easier way for us to do this." This is why I created this spreadsheet. Its not an app or anything fancy, but it has made it very simple for us to use this instead of what we were using which was a paper log with a pen and a calculator. After someone helped me in this sub earlier today, I figured I should share what I made with anyone that might need a solution and cant come up with one on their own... This will allow you to have a relatively good base for you to start with and come up with your own look/feel and data...
Be warned this is based on US unit of measure and my son is Type 1 diabetic. So this is what works for him and us.
The link is here. It is a Google Drive link. Yes, this is shared on a newly created Google account so that my real one is not exposed.
It has a lot of features that you will have to customize to your desired outcome. This is also not the most prettiest spreadsheet in the world. With that said, it has been wonderful.
To use this, I open up my Formulas tab at the bottom of the sheet, and type or select the correct information for the meal. I left in some example numbers so you can see how it works. Play with it, if you wish. Don't remove the formulas, though. Only edit cells B2, B3, B4, B6 and B7 (example). It will then calculate all of the amount of insulin to give and will tell you to round up or down to the nearest half unit. So in the example picture, we would give him a half a unit because it came out to 0.759 units, and you would round down to the nearest half unit, which comes to 0.5 units. This is based on what our Endocrinologist doctors told us was acceptable, so your mileage may vary. Check with your Endocrinologist doctor and adjust the formulas as necessary.
What I do next is I then go to the Carb Diary tab at the bottom of the sheet, and I input how many carbs in the correct cell for the day. Just type in the number, it fills in the units for you... Done with that tab!
Finally on my daily use of the sheet, I then go to the Diabetes Diary tab and fill out each cell as necessary. So for Breakfast we would go to the 1st day of the month and put in how much insulin that my son will be getting for that meal. Then I go over to the Long Lasing Insulin column, then type in the amount of units he received since he gets his long lasting insulin shot first thing at 8:00 a.m. every morning. Next I go over to the Urine Sugar Ketones column and select if he has ketones on his first test of the day. Usually is Negative for him, of course! Next I will go over to the Breakfast Blood Sugar Level Column and type in his blood glucose level there. It will highlight all high numbers above 180 to the color Pink, normal stays white in the cell, and lows highlight Yellow below 80. If you want to change the colors, or values you will have to go to Format>Conditional formatting at the very top of the page and adjust as necessary. Finally, if you have any notes to type in, like your kid was exercising, or whatever can explain a high or low, I will put those notes in the last column.
I do have a Ratios tab where I keep the ratios and sensitivity levels for each meal. You can change that to your own liking... Then there is an Insulin Dates sheet where you can keep track of when you pulled out and started to use insulin. Input the date you opened it and used it, and it will automatically fill out the final day by adding 28 days on to it so you know when the last day is and have to swap our your insulin. There is also a Carb Cheat Sheet tab if you want to put some carbs for certain foods down for ease of use. You should always check labels though, as carbs can change on products.
I hope this helps someone. It has been a fun project. I have a script running in my personal one that automatically backs the sheet up to a different folder on google drive, to which my computer downloads and synchs with Google Drive. If you want help doing this, PM me and I will be glad to give that to you. I will also print out the spreadsheets to put in his binder that we take to his doctor visits to have his numbers easily for the appointment. Merry Christmas, or Happy Holidays!
Social Plugin