My son was diagnosed in March of 2015. He was 10. I put together a system using Google docs so that everyone involved in helping him manage his diabetes could be on the same page at all times, in real time.
It's still in progress, but here's a sample of what we are using:
I started with a spreadsheet that did what you have created and would estimate the HbA1c etc. This morphed into a full blown app that covers all sorts (including Insulin on Board estimates and plots of BG against IOB against Carb intake). Have a look at the thread linked in my signature it will give you some ideas.
I started with a spreadsheet that did what you have created and would estimate the HbA1c etc. This morphed into a full blown app that covers all sorts (including Insulin on Board estimates and plots of BG against IOB against Carb intake). Have a look at the thread linked in my signature it will give you some ideas.
The system that I posted here is just an online log that is updated in real-time. Use the 'Diabetes Management Form' and the online log updates instantly and is accessible to anyone with internet connectivity. The dose calculation jazz has been removed from the version here because of the whole IOB issue. However, the simple log is still nice because when multiple people are dealing with a young person, it's nice for everyone to be in the loop.