How to create a excel chart for BGL?

Hi All

I have my cat tightly regulated now. I need to make a new chart as I'm using the wrong one. I've looked through FDMB and I can't remember how to do it. Any advice would be great, thanks all

 

http://www.felinediabetes.com/FDMB/threads/fdmb-spreadsheet-instructions.130337/

 

Thanks so much

 

Do you know how to write an and/if formula?

 

Whats and/if? Also I am planning on looking at tutorial on Excell so maybe this will answer my question

 

I created my own little spreadsheet to use. Here is a copy of it if you want to use it. I print fold it up and put it in my testing kit.

 

The and/if is good for averages but any mathematician will tell you averages are useless here.
Example, 3 days at 108, 108, 432 will average out to a 3 day average of 216. In that case it doesn't tell you anything.
It is good for other things but the formulas get really long. My OCD is math driven.
If you really want to go nuts get a $100 soft cover book about Excel.
I 'pretend' gamble and run spreadsheets that won't fit on a DVD. I learned my lesson in the 80's, never went back.