Titration

I have moved from Google Sheets to Microsoft Excel for doing Insulin titration for my mother. I am an Android, Linux, Windows shop and felt that Google sheets would be better for being able to move between Windows and my Samsung tablet and phone. From past experience, Google Docs is excellent in collaboration. The issue that I noticed was that sometimes the data that I entered in did not prorogate between devices. I know that SAAS spreadsheets are a hub and spoke. What I think was happening was that the cached version was not being uploaded to the central server. When it was, uploaded, it became the older version because it was changed elsewhere. The issue may have been my work offline settings or how I move from device to device or wifi to wifi. In the end, it does not matter to me. For my well being and mother’s health, it just has to work.

Before I show an HTML table representation of my spreadsheet, here are my sources:

• Personal Doctor

• Starting patients on Levemir

• Type 2 Diabetes Glucose Management Goals

• What are Blood Sugar Target Ranges? What is Normal Blood Sugar Level?

The spreadsheet that I created looks like this:

Underlying cell formulas look like:

I am using the round function for the moving average because there is no such thing as decimal numbers on the blood glucose monitor.

The current Insulin titration looks like:

=IF(ISBLANK(B31),"",IF(COUNTIF(D27:D30,D30)>=4,IF(C31<70,MROUND(D30*0.9,2),D30+LOOKUP(C31,$H$6:$H$10,$I$6:$I$10)),D30))

The titration uses the fasting simple moving average. From what I understand about Tresiba, does change should happen every 3 to 4 days. The countif function checks to see if the last 4 doses were the same. If they are the same, titrate. Also, if the simple moving average is under 70, reduce dosage by 10%.

Look Up table: