Diet spreadsheet

15 years ago

Hi, fellow dieters

I have just been diagnosed with diabetes and also need to lose weight. I have been looking for a dieting spreadsheet After doing some googling, I didn't find quite what I wanted. I envision something that would have a library of common foods and their calories/carbs which will allow me to easily calculate the quantities for each meal, perhaps by entering the description of the food and have the spreadsheet look up calories and carbs. The spreadsheet should also let me record my weight each day and blood sugar readings. I think I can make my own, if necessary, but don't want to reinvent the wheel. Any ideas?

Comments (21)

eklektos
15 years ago
Hello, Harold,

I haven't tried it yet, but I've heard from several others that FitDay.com has a great program for tracking your diet and weight. I think it does calculate total calories and carbs based on what you enter. I'm not sure about blood sugar readings. Have you checked that out yet?

If you can't find what you're looking for, then there must be a need for something new. Consider making it yourself and then offering it to others. FitDay and SugarFreeSheila both have developed their own tracking systems. I think FitDay is free, but SFS sells hers in a workbook format and makes enough off her book sales to support her website. You could start a career sideline with an original product! (Can you tell I work in the publishing industry?)

Best wishes to you!
harold14370
Original Author
15 years ago
Thanks, eklektos.

That Fitday is a dandy site. It lets you do the calculations online and has a very extensive database of foods. It calculates a whole lot of stuff like carbs, proteins fats and calories as well as percent daily values of all sorts of nutrients. You do have to sign up and give them your email address, so I hope I don't get too much spam.

It does lack a few features I was looking for, like being abot to track data for each meal, not just the entire day. This would help correlate swings in glucose through the day. I didn't see a way to record data like glucose reading, either.

SugarfreeSheila sells books and a paper workbook. I didn't see an electronic spreadsheet there.

I think I might take a crack at putting together my own spreadsheet.
Related Discussions
Sure has been slow on here. What is everyone up to?
Q
Comments (9)
OOPS...got behind on this thread. Peggy, I am still working on my spreadsheets and making labels in preparation to then plant, plant, plant without having to stop and make more labels. I have targeted Thanksgiving for having all bulbs, or nearly all the important bulbs planted. I'm not as concerned about the few NO ID daffs I have and the 250 or so specie tulips and muscari. I can sneak them in easily anywhere anytime before a good ground freeze. You wear me out with everything you have going so many evenings? Has all of the exercising given you more energy? Linda, Congratulations on your very first grand baby. I'm sure he caused a lot of excitement for everyone and hope he is doing great. Sorry to hear of your Mom's fall, but glad it was nothing serious. Possibly it served as a good warning to try and be very careful. She sure seems to be doing well for her age and please tell her I am looking forward to her making it to the next swap...hear? Doris, I'm sure the daffs your boss got will not to too pink. I'm going to guess that they were likely ordered from Breck's. If so, their pics are touched up and are not a good depiction of their true colors. Here is Breck's Pink Collection (not!) Here are some pics that better show their true colors Chromacolor at Daffseek Romance at Daffseek Pink Charm at Daffseek In attending some local Daffodil Shows, I did see many daffs that had a very pretty pink color to them...a true soft pink, nothing peachy about it. Another thing too, is that a daffs color changes as the bloom matures. A bloom that emerges as a yellowy peach can turn its true color of being more pink as it matures. The pic below is Salome on the left and Mrs. R. O. Backhouse on the right. The pic below was taken one day later (and some blooms were added), but you can seed how they have 'pinked up' a good bit. Neither are ones I would call one of the truer pinks though compared to what I have seen at shows. Peggy, your garden club lunch and then work sounds like a lot of fun. I hope it does well and you get us some pics next year. Sue...off to hopefully finish up pretty well on labels today.
...See More
Weekly Weigh-in Thread 2
Q
Comments (48)
Hi Jasmi, I do Jari Love's Ripped 1000 three days a week for one hour. I do little half hours here and there on my exercise ball (sit ups,etc) or weight lifting while I watch TV (10 lbs). Then I go hiking 2-3 days a week for 2-3 hours. I found a friend who wants to lose weight too, so it works out well. We were up to six miles a day last week, but I took a week off because my husband was going out of town and I wanted to spend those afternoons with him. We want to go hiking this afternoon but it's 90 degrees out. I'm not doing anything this afternoon!!! Maybe lift some weights tonight when it cools off. But I'm also concentrating in other ways. Walking to pick up my dd at school (1/2 mile round trip), parking furthest away from the shopping center, gardening, walking the dog, etc. I stand up at work and do jumping jacks when no one is in the office. Sounds silly, but it revs up my metabolism. I also eat a big breakfast. I've heard that's really good to do. I have a hard time eating in the morning, but i force myself to do it, and I think it helps get me going on burning calories because my body knows it has enough and doesn't feel depleted.
...See More
Dieting and watching what you eat
Q
Comments (27)
A woman up the river gave me wise advice ten years ago when my metabolism shut down. She is in excellent condition. She told me she eats whatever she wants but has to work it off. Her approach to food is like budgeting and saving money: 'do I want to waste calories on this junk or do I want to save up and have a really good dinner later on?' she asks herself. This way she has always has a choice. She's never backed into a corner. She also turned me onto this little tip and by golly it works! Get an exercise bike or a treadmill. Rent one or buy at a second hand store if you can't afford new. Park it in front of tv. In the evenings, while you are watching tv, ride the bike or walk the treadmill during the commercials. I do this three nights a week. My average ride on the airdyne is FIVE MILES for a one hour show. At first take it easy but as you get stronger, up the speed/resistance. I've never kept track of the time I ride but it's a well known fact that without commercials a one hour show would only be something like 1/2 hour long....LOL I've lost a little weight since Christmas. How much, I don't know but my clothes fit better. I keep a big tupperware bowl of celery, carrots, radishes, green onions, etc in the frig so I have a choice between eating that cookie(s)or veggies to hold me until time for a real meal. I love how the bike riding tones me up and makes me feel strong. My sister lost sixty pounds (over a two year period) by eating anything she wanted. She cut her portions by a third and doesn't allow herself seconds. She will eat desserts but cuts that portion by half. You can do this. Just don't look at it as a chore or make it into something you dread. Give yourself some choices. Most of the time you'll make the right choice. Lori
...See More
My little tuxedo Sophie: Matted hair - one functioning kidney
Q
Comments (9)
Sue, I'm so sorry to read of Sophie's difficulties. Renal problems are so common in elderly cats, but if they are caught early (and even if not caught until later), there is often much that can be done to manage renal insufficiency and improve and maintain good quality of life for these cats. There are fantastic information and support resources online for renal cat caretakers (and hyperT caretakers), but these resources will be of most value to you if you get copies of all of Sophie's test results for your own file at home. If, for example, you join the Feline-CRF-Support mailing list at Yahoo Groups, the members will request that you post all of Sophie's test results so that they can review and get a handle on her current state of health. You'll also need those test results in hand so that you can make sense of the information you find on CRF websites. I am currently caring for two hyperT cats, one of whom is also CRF (he's my third CRF cat), and they're both doing quite well. Billy was diagnosed with both hyperT and CRF in 10/07. He's 20 yrs old this year. I know Sophie's diagnosis is scary, but don't let it throw you for a loop. Get copies of her test results and start doing your research. The website I am linking below is considered the "CRF Bible" by many of us CRF caretakers. There really isn't much of anything related to renal issues that it doesn't cover. You'll probably find it overwhelming at first, but don't worry if 90% of it goes right in one eye and out the other at first reading. That's what bookmarks are for. Feel free to email me privately anytime. I'm happy to hold your hand down the renal road. It can be a daunting journey traveled alone, but rest assured that there are tens of thousands of us out here walking it with you. Take care, Laurie Here is a link that might be useful: Tanya's Feline CRF Info Centre
...See More
harold14370
Original Author
15 years ago
I finished making my spreadsheet. If I say so myself, it's 10 times better than any of the free spreadsheet templates you can get off the internet.

If anyone is interested, I could email it to you. I tried to post it on the Microsoft excel template page but they wouldn't accept anything written in versions before Excel 2007. I'm sure not going to upgrade to 2007 just so I can post a template on their web site.

If you're afraid of posting your email here, you could just create a new hotmail account or something like that, so the spam, if any, would not clutter your regular email.
sandi
15 years ago
Hi Harold,
I'd sure love to have it e-mailed to me as I'm just stumbling my way through this diabetes stuff.
Thanks,
Sandi
harold14370
Original Author
15 years ago
Hi, Sandi

Maybe I'm a little technically challenged, but if your email address is available somewhere on this site, I don't know how to find it.
sandi
15 years ago
Can't very well get help without an e-mail address!!
harley2ride62@yahoo.com
Thanks, Sandi
Prncess61
15 years ago
Add me to the new dibetic needing help would love the spread sheet list.

Bearsdesigns@aol.com

thanks a million
Sherry
silversword
15 years ago
Hi Harold,
The link I posted to My Calorie Counter allows you to track each meal as well as daily. It also tracks exercise and has averages and goal setting. It works pretty well!
eklektos
15 years ago
Good for you, Harold, for making it yourself!
And see, you've already got a following. Should we watch for you on the HSN channel? (I'm only half teasing--I hope you find your spreadsheet works exactly for what you need, and that it helps many others in the process.)
harold14370
Original Author
15 years ago
Thanks, Eklektos. I'm having fun tinkering with the spreadsheet and learning more about Excel as I go. As soon as I figure out how to make dynamic charts with the OFFSET function, it's gonna be awesome:)
jackie643
15 years ago
Hi Harold,
If you wouldn't mind I would like your spreadsheet.

Thanks, Jackie.
jhoege@merr.com
sandi
15 years ago
Hi Harold,I'm sorry I didn't give you my e-mail address the first time around, but I would really like your spreadsheet too.
Thanks,
sandi
harley2ride62@yahoo.com
harold14370
Original Author
15 years ago
I just sent them out to Jackie and Sandi. I sent one to Sandi before, but it apparently vanished into cyberspace. Let me know if there is a problem and shoot me an email if you have any trouble with it.

This is still the old version. The dynamic charts are kicking my butt, but when I figure that out, I can send you the upgraded one.
kitttenn37096
15 years ago
I am interested also...

silversplinter@hotmail.com

Thanks bunches,
Kitt
Linda Harris
15 years ago
harold, would you be so kind as to send me a copy of the spreadsheet. thanks in advance.
unitedrealty35@bellsouth.net
silversword
15 years ago
Hi Harold,
I don't know if the offset function is still giving you trouble, but here's a little info guide if you need it.

Enter the following data into a blank Excel worksheet:

A1: Name B1: Dept C1: Age
A2: Henry B2: 501 C2: 28
A3: Stan B3: 201 C3: 19
A4: Mary B4: 101 C4: 22
A5: Larry B5: 301 C5: 29

Enter the following formulas into cell E2 (or any available blank cell):

=OFFSET(C2,2,-1,1,1)

C2 The referenced cell.

2 Indicates the number of rows to move. Positive numbers mean move down, and negative numbers mean move up.

-1 Indicates the number of columns to move. Positive numbers mean move to the right, and negative numbers mean move to the left.

1 (second last value) - (Optional.) Indicates how many rows of data to return. This number must be a positive number.

1 (last value) - (Optional.) Indicates how many columns of data to return. This number must be a positive number.

Examples:
When you use this formula, the OFFSET function returns the value of the cell that is located two rows down (2) and 1 row to the left (-1) of cell C2 (which is cell B4). The value in cell B4 is "101". Therefore, the formula returns "101".

If you want to email me the spreadsheet I'd be happy to tinker with it for you, and I'd like to look at it anyway! I love Excel and am an experienced user (my geek is showing!)

silver_sword808@yahoo.com
harold14370
Original Author
15 years ago
Thanks Silversword. Yeah, I had all that info but sometimes you make some little error and can't find what you did wrong. I eventually did master the dynamic charts and got that working. I'll send you out a copy anyway. Maybe you will be able to think of a way to make it better.
silversword
15 years ago
Sure, no problem. I love spreadsheets!!
silversword
15 years ago
Well Harold, your spreadsheet looks pretty darn good to me! I have to admit, not being diabetic myself the whole glucose thing confuses me.

I would lock the cells to prevent overwriting, but that's about it.
harold14370
Original Author
15 years ago
Hm. Well, if it confuses you it would probably confuse others as well. It made sense to me at the time, but it often turns out that way when I write something. I appreciate the feedback. I'll see if I can try to make it more self-explanatory.
jspears47_gmail_com
13 years ago
Hi Harold,

I would like to try your spreadsheet.

Thanks,
Joe

jspears47@gmail.com

Diet spreadsheet

Comments (21)

eklektos

harold14370
Original Author

Related Discussions

harold14370
Original Author

sandi

harold14370
Original Author

sandi

Prncess61

silversword

eklektos

harold14370
Original Author

jackie643

sandi

harold14370
Original Author

kitttenn37096

Linda Harris

silversword

harold14370
Original Author

silversword

silversword

harold14370
Original Author

jspears47_gmail_com

COMPANY

BUSINESS SERVICES

GET HELP

CONNECT WITH US

Diet spreadsheet

Comments (21)

harold14370Original Author

Related Discussions

harold14370Original Author

harold14370Original Author

harold14370Original Author

harold14370Original Author

harold14370Original Author

harold14370Original Author

COMPANY

BUSINESS SERVICES

GET HELP

CONNECT WITH US

harold14370
Original Author

harold14370
Original Author

harold14370
Original Author

harold14370
Original Author

harold14370
Original Author

harold14370
Original Author

harold14370
Original Author