Maya - BG Spreadsheet

Status
Not open for further replies.
D

Dee_Jay

Member Since 2010
Hello All ...

I've now spent well over 2 hours trying to get a Google Account and get a spreadsheet posted. I am now trying to figure out your spreadsheet and am at my wit's end. Your BG numbers are all different than mine - you are way in the hundreds ... Maya is getting BG readings in and around 16.2 / 17.3 / 13.5 ... etc. Honestly ... this is waaaaaaay too complicated. I need help ... but this has got me in tears.

And yet ... I have been tracking Maya's BG since day 1 in Excel with corresponding graphs.

... DeeJay
 
Hello Dee Jay (which by the way is the opposite of how J.D. spells his name Jay Dee :-D )
There are conversion charts and spreadsheets that will convert the numbers for you. Someone will help you with this tomorrow. I will bump up your thread in the morning. If it doesn't get responded to, then write a new one or tomorrow with Spreadsheet Help Please in the subject line. You'll have it up and running in now time.
 
The World-US template is no longer available on Google Docs :? There are people here who do use the template. You can post here or in Tech and ask someone to share a blank world template with you. Until you can get a template, it's best to note at the top of your SS that you are using mmol so people don't get confused.

To convert mmol numbers to US numbers (mg/dl) just multiply by 18. Example 11 mmol x 18 = 198 mg/dl
 
I appreciate all of this ... I really do. However - with what has happened in my personal life numerous links and converting numbers on top of trying to figure out all of this new jargon is too much.

Is there a KISS (Keep It Simple Silly) spreadsheet anywhere ?? I honestly don't understand the spreadsheet that is posted.

It's way too many links and information and I honestly feel like I'm drowning.

... DeeJay
 
For now I think you can just upload your current Excel file to Google docs. At least that way we can see the data, and you can work on converting it to the template we use later.

MJ&Donovan
 
Dee_Jay said:
Is there a KISS (Keep It Simple Silly) spreadsheet anywhere ?? I honestly don't understand the spreadsheet that is posted.
Click to expand...


Here's what the SS template looks like: http://docs.google.com/previewtemplate? ... ode=public

The top row with the BG (blood glucose) numbers is the code key. A black cell represents a bg over 500, red is bg between 400 to 499, pink is bg between 300 and 399, etc.

The date column is self explanatory :smile: Each row is one single day.

AMPS is the morning (AM) pre-shot (PS) level. This is the bg number before insulin is given.
PMPS is the same but for the evening (PM) pre-shot level.

U is units of insulin.

The columns labeled as +1, +2, etc you fill out as you test bg levels. So if you test 4 hours after the morning insulin shot and the bg is 333, you would type "333" into the +4 column for that day. The cell will automatically turn pink to correspond with the bg color code key :smile:

The remarks column at the end is just notes/comments, like if your cat threw up or if you started a new Lantus pen.

Take a look at other Lantus users' SS to get a general idea of how people are using their SS. There's no right or wrong way :smile: I'd share my SS but it's 4 years of bg data on 3 different insulins across 6 sheets/tabs :shock: It's way to overwhelming for a newbie to even look at.

If you need more help on the SS, you can post in the Tech forum.

Edit:

It looks like there is a US/World SS created by our Ronnie and Luna: https://docs.google.com/previewtemplate ... ode=public It's different from the original one that is used in the link Gingers Mommy posted above.

There is also this one for diabetic cats creatd by someone who I don't know if he/she is a FDMB member: https://docs.google.com/previewtemplate ... ode=public

If neither link works, go to https://docs.google.com/templates?hl=en ... 20template and log in. Ronnie's is "Copy of 12/12 insulin template By Ronnie & Luna" and the other one is "Pat's mmol/L insulin template By Pat Creighton"

Here's what the original US/World SS looks like: https://spreadsheets.google.com/pub?key ... l=en&gid=0 You enter bg data in one of the two sections and I think it will automatically convert on the other section.
 
(((Dee-Jay))). The important thing is to test and share your numbers. The rest will come. The early days are stressful. Hang in!!
 
Status
Not open for further replies.
Back
Top