Tweet
With the assistance of a few other members, I put together this google doc spreadsheet that anyone can use in order to track their pet's glucose readings over the course of a day as well as month or longer (sky is the limit!)
With accurate tracking and note taking, plus a very responsive team of Vets, my little puppy lived a very long and healthy 17 years (the last 10 with diabetes) before God wanted him to come home. If this chart helps anyone get even another month with their pet, then it was time well invested.
Step 1:
The first step is you will need to register for a Google account. You don't need an actual gmail address, but that does make it more streamlined. If you already have an android phone or are familiar with Google Docs, you can skip down to step 2.
Go to https://accounts.google.com and click on "Create an account".
If you want to create a Google account, go ahead and fill out all the information on the right side to set up an account. If you prefer just to create a Google login, without actually creating an @Gmail email address, there is a shortcut called "I prefer to use my current email address".
In either case, the password will be unique. Google is not asking you to type in the password to your current email address, it just needs something to authenticate you the next time you visit.
Gender and birthdate are required, but mobile phone and "current email address" are not if you are going with an @gmail user name.
Confirm everything and viola! You are ready to start with Google Docs.
For a video guide, see here, but remember, phone number and email address are optional (This guy entered in his) https://www.youtube.com/watch?v=iUnv8JdxF24
Step 2:
Once you have a google account or login set up, click this link:
https://docs.google.com/spreadsheets...gid=1657996007
That will take you to the tracking spreadsheet template. There are three tabs at the bottom, a "Daily Log" that you can fill in each day and keep a running log, a "Daily Curve" that will dynamically update the line chart according to your numbers, and a "Trending Curve" that you can fill in just the numbers for each day to see a monthly overview of how your pet has been doing.
With the daily log and trending curve, you can go back and review what might have caused very low numbers (new dosage) or very high numbers (stress, visitors, doctor visit) based on the notes you took in the daily log.
When you are looking at the Spreadsheet, click on "File" then "Make a Copy" and that will transfer a copy of this document to your own Google Drive cloud folder.
Step 3
Now that you have copied the template to your own storage, go to drive.google.com and click on "My Drive" at the top right. If you just created a google account from this guide, it should be the only file listed. If you have used Google Drive before, it will have been copied to the main 'root' folder.
Double click on "Copy of Diabetes Data" and it will open in Google Docs and now you can start entering in your own data and it will save automatically. If you need to print out anything to show your vet, you can print from this like any web page.
Bonus Step
If your vet has an email address, you can "Share" this document with their email address, allowing them to hop in at anytime and take a look at the values you have been entering.
When you have the spreadsheet open, at the top right there is a "Share" button. Click that and on the screen that pops up, enter in your vets email address and on the drop down button to the right of the email address, you can choose what access they have.
"Can Edit" means they can enter data in to the cells just like you (I wouldn't, just in case they accidentally erase something).
"Can Comment" means they can add just a comment to the file, in which case you will get an email that they made a notation. They won't be able to enter in or modify any data though.
"Can View" means they can just see what you have been putting in, but would have to call you to make any comments.
If I missed something, let me know and I'll try to append this how-to.
With accurate tracking and note taking, plus a very responsive team of Vets, my little puppy lived a very long and healthy 17 years (the last 10 with diabetes) before God wanted him to come home. If this chart helps anyone get even another month with their pet, then it was time well invested.
Step 1:
The first step is you will need to register for a Google account. You don't need an actual gmail address, but that does make it more streamlined. If you already have an android phone or are familiar with Google Docs, you can skip down to step 2.
Go to https://accounts.google.com and click on "Create an account".
If you want to create a Google account, go ahead and fill out all the information on the right side to set up an account. If you prefer just to create a Google login, without actually creating an @Gmail email address, there is a shortcut called "I prefer to use my current email address".
In either case, the password will be unique. Google is not asking you to type in the password to your current email address, it just needs something to authenticate you the next time you visit.
Gender and birthdate are required, but mobile phone and "current email address" are not if you are going with an @gmail user name.
Confirm everything and viola! You are ready to start with Google Docs.
For a video guide, see here, but remember, phone number and email address are optional (This guy entered in his) https://www.youtube.com/watch?v=iUnv8JdxF24
Step 2:
Once you have a google account or login set up, click this link:
https://docs.google.com/spreadsheets...gid=1657996007
That will take you to the tracking spreadsheet template. There are three tabs at the bottom, a "Daily Log" that you can fill in each day and keep a running log, a "Daily Curve" that will dynamically update the line chart according to your numbers, and a "Trending Curve" that you can fill in just the numbers for each day to see a monthly overview of how your pet has been doing.
With the daily log and trending curve, you can go back and review what might have caused very low numbers (new dosage) or very high numbers (stress, visitors, doctor visit) based on the notes you took in the daily log.
When you are looking at the Spreadsheet, click on "File" then "Make a Copy" and that will transfer a copy of this document to your own Google Drive cloud folder.
Step 3
Now that you have copied the template to your own storage, go to drive.google.com and click on "My Drive" at the top right. If you just created a google account from this guide, it should be the only file listed. If you have used Google Drive before, it will have been copied to the main 'root' folder.
Double click on "Copy of Diabetes Data" and it will open in Google Docs and now you can start entering in your own data and it will save automatically. If you need to print out anything to show your vet, you can print from this like any web page.
Bonus Step
If your vet has an email address, you can "Share" this document with their email address, allowing them to hop in at anytime and take a look at the values you have been entering.
When you have the spreadsheet open, at the top right there is a "Share" button. Click that and on the screen that pops up, enter in your vets email address and on the drop down button to the right of the email address, you can choose what access they have.
"Can Edit" means they can enter data in to the cells just like you (I wouldn't, just in case they accidentally erase something).
"Can Comment" means they can add just a comment to the file, in which case you will get an email that they made a notation. They won't be able to enter in or modify any data though.
"Can View" means they can just see what you have been putting in, but would have to call you to make any comments.
If I missed something, let me know and I'll try to append this how-to.
Comment