Using a spreadsheet to track numbers et.al.

Go Back   The Diabetes Forum Support Community For Diabetics Online > Diabetes Forum Community > Diabetes Diet and Nutrition

Diabetes Diet and Nutrition A healthy, well balanced, nutritious diet which factors in Diabetes can be crucial for the long term management of Diabetes. Use this section to discuss your diet, what you would like to try, swap recipes and more.


Like Tree18Likes
  • 3 Post By chargette
  • 1 Post By VeeJay
  • 2 Post By itissteve
  • 2 Post By TooSweetForMe
  • 1 Post By mbuster
  • 2 Post By traceycgiles
  • 1 Post By chargette
  • 2 Post By div2live
  • 2 Post By alamogirl
  • 2 Post By milkmaade

Using a spreadsheet to track numbers et.al.


Closed Thread
 
Shared Thread Thread Tools
Old 10-26-2017, 00:05   #1
Senior Member
 
chargette's Avatar
 
Join Date: Sep 2015
Location: United States
Posts: 269

Member Type
Type 2
Diagnosed in 2004

218 likes received
443 likes given
Default Using a spreadsheet to track numbers et.al.

I downloaded a free spreadsheet program this morning, WPS is the name of it.

I like MyFitnessPal but it drives me nuts going back and forth between pages. I'm setting up spreadsheets in one workbook to track food and BG levels and setting up a menu.

It'll be a time curve getting it set up but it will be so simple to use. I'll share more later as it progresses.
chargette is offline  
Old 10-26-2017, 03:04   #2
Moderator
 
VeeJay's Avatar
 
Join Date: Jan 2012
Location: Midwest USA
Posts: 9,366

Member Type
Type 2
Diagnosed in 2010

11940 likes received
4403 likes given
Default

I hope it works for you.

TooSweetForMe likes this.
__________________
My low-carb recipe collection on Pinterest
https://www.pinterest.com/VRStudio1/...light-recipes/
70 yrs. Dx May 2010
Diet controlled: VLC/HF
BG steady with no highs or lows.
A1C in the 5% range.
____________________________________
Gluten intolerant, sensitive to dairy & eggs.
Eat no grains
VeeJay is offline  
Old 10-26-2017, 14:23   #3
Moderator
 
itissteve's Avatar
 
Join Date: Jul 2017
Location: Minnesota, USA
Posts: 1,476

Member Type
Type 2
Diagnosed in 2011

1106 likes received
457 likes given
Default

I set up my own spreadsheet (for some reason I did not ever think to look for a template). Especially early on, as I was getting the hang of what to eat ("eat to my meter") and poking myself for blood samples, I collected many data points which would throw off a useful average (median might be a better measure, but...). My meter has an app, too, which actually is not bad but is not granular enough for me to be able to see cause and effect easily and also had that issue with excluding questionable measurements.

So I created a spreadsheet. I've since modified it to allow better graphing (individual data points are fine but 7-8 pokes a day over three months creates a lot of data) I can send this to my PCP and being able to graph the data the way I want to makes it easier to spot trends.

I'm looking forward to seeing your spreadsheet whenever you want to share it.

TooSweetForMe and chargette like this.
itissteve is offline  
 
Old 10-26-2017, 14:49   #4
Senior Member
 
Join Date: Sep 2013
Location: OBX, NC aka The Dark Side of the Moon
Posts: 304

Member Type
Type 2
Diagnosed in 2009

126 likes received
443 likes given
Default

I'm using Google Docs atm, because my PCP has started something so that she can look at all her patients numbers on there, and other patients can do selective permissions if they decide they want other patients to see the numbers with or without other personal info.

chargette and skypeace like this.
TooSweetForMe is offline  
Old 10-26-2017, 15:24   #5
Moderator
 
mbuster's Avatar
 
Join Date: Sep 2011
Location: SW Arkansas
Posts: 8,980

Member Type
Type 2
Diagnosed in Feb. 2012

10943 likes received
6042 likes given
Default

I used a spread sheet when I first started tracking because my meter software didn't flag fasting, just pre meal, post meal with time, and other. It worked very well for what I needed it to do.

chargette likes this.
__________________
Think I've had this since 2003. Told I was Type 2 lean on 2/13/12.
a1c 8.8 (8/2011) 5.4 (10/2018)
TC 206 LDL 102 HDL 85 TG 96 (10/2018)
Supplemental vitamins and electrolytes
63 YY Love the LCHF diet. The cheese goes well with my whine

updated 10/26/18
mbuster is online now  
Old 10-26-2017, 16:46   #6
Junior Member
 
Join Date: Oct 2017
Posts: 4

Member Type
Type 2
Diagnosed in 2017

7 likes received
3 likes given
Default

I use an app called glucose wiz. It has been amazing so far and it will allow you to print as a excel or pdf which is great for when I see the doctor!


Sent from my iPhone using Tapatalk

TooSweetForMe and chargette like this.
traceycgiles is offline  
Old 10-31-2017, 16:58   #7
Senior Member
 
chargette's Avatar
 
Join Date: Sep 2015
Location: United States
Posts: 269

Member Type
Type 2
Diagnosed in 2004

218 likes received
443 likes given
Default

I have most of the foods I consume in the spreadsheet. I just need to put in their numbers for carbs, etc. I've started analyzing my meals for how much they spike my blood sugar and it's a real eye opener. I'm recording meals in the spreadsheet too.

TooSweetForMe likes this.
chargette is offline  
Old 10-31-2017, 17:19   #8
Senior Member
 
Join Date: Apr 2015
Location: USA
Posts: 1,852

Member Type
Type 2
Diagnosed in 2002

2379 likes received
1559 likes given
Default

I have all historical bloodwork, blood pressures, weight, etc. On an Excel Spreadsheet. Since I worked in business for a zillion years I started to learn on the old ledgers and paper columnar pads, back in the 'olden' days. As time moved forward I learned to use the Excel Spreadsheet for all applications....

My doctor loves when I see him with my overall history. For him to see that he would have to go back all of my old tests in his little computer he carries around. I think bring your historical summarized records helps the doctors out as they cannot take time for each patient to look back over 3-4 years of history.

Works for me, it does....

TooSweetForMe and chargette like this.
div2live is offline  
Old 10-31-2017, 20:48   #9
Senior Member
 
Join Date: May 2017
Location: TX
Posts: 966

Member Type
Type 2
Diagnosed in 2017

1028 likes received
1360 likes given
Default

I keep a journal. I record my 1st morning reading. I don't record again until I come home from work. I usually eat the same thing. If I deviate, then I will write down what I ate.

TooSweetForMe and chargette like this.
__________________
30 Sep 19:
A1C: 5.8
Cholesterol: 155
Crestor 5mg
Metformin 1000mg
BP: Cozaar 50mg
LC/HF

Wishing y'all Peace & Love!
alamogirl is offline  
Old 11-13-2017, 16:19   #10
Active Member
 
Join Date: Jun 2017
Location: Midwest USA
Posts: 57

Member Type
Type 2
Diagnosed in 2016

50 likes received
44 likes given
Default

I've done that too; also, I started one to make my own food list with carbs/cals by adding each food as I purchased/ate it but found that just too time consuming daily. Nice thing is being able to turn the results into various types of graphs if you want to.

TooSweetForMe and chargette like this.
__________________
Insulin resistant, years; Metabolic Syndrome, years.
Type 2 <1 yr with A1c of 8.2 on 6/9/17 down to 9/11/17 A1c 6.3.
Metformin ER 500 mg 2xday (usually).
New to LCHF. Celiac, psoriatic arthritis,
constellation of autoimmune disorders
short gut post several bowel surgeries.
milkmaade is offline  
Closed Thread

Tags
bg levels, food counts, track

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
what's the best way to keep track of BS to show dr.? zinger60 Diabetes 14 01-09-2016 18:33
Back on track jbardellini Diabetes Treatment 3 03-13-2014 12:00
Help me get back on track! 3babygirls Diabetes 11 04-09-2013 19:58
Time to get on track kelee New Member Introductions 2 02-05-2012 15:24
On the right track? SandraO Diabetes Diet and Nutrition 2 05-10-2011 21:33

LEGAL NOTICE
By using this Website, you agree to abide by our Terms and Conditions (the "Terms"). This notice does not replace our Terms, which you must read in full as they contain important information. You must not post any defamatory, unlawful or undesirable content, or any content copied from a third party, on the Website. You must not copy material from the Website except in accordance with the Terms. This Website gives users an opportunity to share information only and is not intended to contain any advice which you should rely upon. It does not replace the need to take professional or other advice. We have no liability to you or any other person in respect of any content on this Website.


All times are GMT +1. The time now is 11:11.




Powered by vBulletin®
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Search Engine Optimization by vBSEO
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.1.0 (Pro) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.