Graph your progress

Susan for Maus (GA)

Susan for Maus (GA)

Member Since 2022
Move this to a different tab if appropriate:

My son figured out how to graph all of Maus's BG readings. I figured out how to do 2 columns, but his does each reading. You can see it on her SS under the Graph tab. All the data can be seen on the graph data tab, along with a smaller version at the top of that sheet. That small graph can be copied to it's own tab for better reading.

If you'd like to copy it, feel free to copy the formula to your SS. I think as long as your entries are on a tab called Sheet1, it's good to go. If your tab is named something else, just change Sheet1 to whatever your's is. You probably only need to change the first line, then copy the formula down.

I haven't tried copying to a new SS yet, but I'm sure it can be figured out. The one thing I do manually on the data tab is enter one bg number in cells where there's more info than just the bg; ie, 65 @+2.5 becomes 65. For cells with multiple bg's, I average to one or the nadir if that's where it is; same if it's the high number of the day).
 
Susan for Artemis (Maus) said:
Move this to a different tab if appropriate:

My son figured out how to graph all of Maus's BG readings. I figured out how to do 2 columns, but his does each reading. You can see it on her SS under the Graph tab. All the data can be seen on the graph data tab, along with a smaller version at the top of that sheet. That small graph can be copied to it's own tab for better reading.

If you'd like to copy it, feel free to copy the formula to your SS. I think as long as your entries are on a tab called Sheet1, it's good to go. If your tab is named something else, just change Sheet1 to whatever your's is. You probably only need to change the first line, then copy the formula down.

I haven't tried copying to a new SS yet, but I'm sure it can be figured out. The one thing I do manually on the data tab is enter one bg number in cells where there's more info than just the bg; ie, 65 @+2.5 becomes 65. For cells with multiple bg's, I average to one or the nadir if that's where it is; same if it's the high number of the day).
Click to expand...

Susan, May I adopt your son? I am still trying to figure out calipers consistently :banghead: and test/shot moves forward and back for any holiday outing or volunteer activity. LOL Seriously graphs are wonderful to step back and see the patterns. Thanks for sharing. I look forward to reviewing.
 
I would love to do this! I can do charts but would love to know a formula for copying and transposing all the data. Am I the only one who is not able to download a copy of your s/s?

With some people, I can see all the menu options but certain functions are disabled. Their tabs appear at the bottom and they show up in Google drive as 'shared with me by others'. With other people however, I don't even see the menus at the top and the tab names are hyperlinks at the top of the screen. Artemis' and Oberon's are both like this.

Anyone out there who can explain this mystery to me? I am now googling for info on this mystery formula :) Thanks for posting this!!
 
Liz & Minnie said:
I would love to do this! I can do charts but would love to know a formula for copying and transposing all the data. Am I the only one who is not able to download a copy of your s/s?

With some people, I can see all the menu options but certain functions are disabled. Their tabs appear at the bottom and they show up in Google drive as 'shared with me by others'. With other people however, I don't even see the menus at the top and the tab names are hyperlinks at the top of the screen. Artemis' and Oberon's are both like this.

Anyone out there who can explain this mystery to me? I am now googling for info on this mystery formula :) Thanks for posting this!!
Click to expand...
Can you copy out of mine & paste? If not, I'll make a fresh one & make it available to anyone with the link. Give me till tomorrow
 
You must log in or register to reply here.
Back
Top