Hello everyone! The following contains the link to a spreadsheet template to help track your cat's BGs using a 12/12 insulin.
**there are two options for getting a spreadsheet template***
1) Check google doc template gallery to see if it is playing nicely. One click and you've got a template!
OR
2) you can download a excel spreadsheet (directions by Sam and S'Mores), which you have to then upload back to google docs
I would advise those who are less computer savvy to try #1 first. If the template is not copying to your account or not loading, then try Sam & S'Mores directions (option #2). Note: Sometimes it takes 1-2 minutes for the google template to "copy" and "load."
Please follow these directions, step-by-step, to the very end. If you have questions, please post a new topic in the TECH forum and someone will help you.
You can click on the link in my signature for an example of a spreadsheet (SS)
SET UP (everyone should follow these directions)
1) You will need a google account.
In order to get a google account, click the link here: New Google Account
You do not need to have a gmail (email hosted by google) account. You can use your current email address and link it to the google account so you can have access to google docs.
Now we're ready to begin!!
A. Getting and Using the Template
Option #1: Direct from Google Docs:
1) Sign into your google account
2) Go to THIS TEMPLATE if you live in the USA. Go to THIS TEMPLATE for a WORLD spreadsheet if you live anywhere else.
Click on "use this template" button.
Image
3) go to step 6 of the directions below and continue from there.
OPTION #2 (directions by Sam & S'Mores)
1) Go to this post for the links to the templates to download.
2) sign into your google account.
3) go to googledocs
3) Click on "Files..." from the "upload" menu
4) Select the XLS file you downloaded and click "open"
5) If the "upload settings" box shows up, make sure "convert documents..." is selected and click "start upload"
6) A copy of the SS will appear. Click on "File" then choose "rename..."
Image
7) Call your SS whatever you like.
8) enter dates, BGs, and doses as indicated on the SS.
B. Publishing your SS, aka Attaching to signature (directions by Squeem3)
1) In a new browser tab, open up your google doc
2) Click on "FILE" in the toolbar and then choose "publish to the web"
Image
3) MAKE SURE that "automatically republish when changes are made" has a check mark next to it.
Image
4) click on "start publishing" button.
5) if a box saying "Are you sure you want to publish this document?" appears, click OK.
6) Copy the link in the DOCUMENT LINK box. (CTRL + C or CMD + C)
7) For a simple text link, like
http://spreadsheets.google.com/pub?key= ... utput=html, replace the words "link here" in the following code with the link to YOUR spreadsheet:
link here
It will look like this:
Code: Select all
http://spreadsheets.google.com/pub?key=p4nuph4W6EFUSqZA10igCfg&output=html
(go to #8 below)
7) If you would like a "word" link, such as Cosmo's SS, use the following code:
text. replace "link" with your spreadsheet URL, and replace 'text' with the name of your spreadsheet.
it will look like this
Code: Select all
Cosmo's SS
8) Go to the "User Control Panel" at the top of this page, and go to profile tab. In the edit signature tab, paste the code you created (control v or command v) and save it.
If you have questions, post a new topic in the TECH forum and ask away! Someone will help!