What a great tool - thank you!!
I have adjusted it for Canadian prices and additional menu items, bars. I do not know how to attach the link to this forum but if any Canuck's out there would like the file emailed, just let me know.
Tanya
9
Personal MS Excel Menu Planner
Started by Lisah101, Feb 15 2008 08:05 AM
53 replies to this topic
#41
-
- Members
-
- 329 posts
Advanced Member
Posted 04 May 2008 - 01:56 PM
Lisah,
What a great tool - thank you!!
I have adjusted it for Canadian prices and additional menu items, bars. I do not know how to attach the link to this forum but if any Canuck's out there would like the file emailed, just let me know.
Tanya
What a great tool - thank you!!
I have adjusted it for Canadian prices and additional menu items, bars. I do not know how to attach the link to this forum but if any Canuck's out there would like the file emailed, just let me know.
Tanya
Joined JC 06/13/05
SW 168
GW 130
Stopped at 145
Rejoined JC 04/30/08
SW 182.6
GW 140
Stopped at 162
Rejoining *third times a charm!* 11/11/09
SW 188
1st GW 160
2nd GW 140
11/11/09 188
11/19/09 187 (-1.0)
11/29/09 182.4 (-4.6)
12/03/09 183.4 (+1) Off plan for 3 days at conference
12/10/09 182.2 (-1.2)
12/16/09 181.2 (-1.0)
12/28/09 181.6 (+0.4) After the holidays and TOM
01/07/10 179.2 (-2.4)
01/15/10 179 (-0.2)
01/21/2010 176 (-3.0)
01/28/2010 175 (-1.0)
02/04/2010 173.6 (-1.4)
02/11/2010 172.2 (-1.4)
02/18/2010 171.8 (-0.4)
03/08/2010 170.8 (-1.0)
03/22/2010 172 (+1.2)
04/01/2010 173.8 (+1.8)
04/08/2010 172.2 (-1.6)
04/15/2010 171.5 (-0.7)
05/17/2010 170 (-1.5)
Biggest Loser Challenge
Canada Day Challenge 2010
Overall Weight Loss Goal
SW 168
GW 130
Stopped at 145
Rejoined JC 04/30/08
SW 182.6
GW 140
Stopped at 162
Rejoining *third times a charm!* 11/11/09
SW 188
1st GW 160
2nd GW 140
11/11/09 188
11/19/09 187 (-1.0)
11/29/09 182.4 (-4.6)
12/03/09 183.4 (+1) Off plan for 3 days at conference
12/10/09 182.2 (-1.2)
12/16/09 181.2 (-1.0)
12/28/09 181.6 (+0.4) After the holidays and TOM
01/07/10 179.2 (-2.4)
01/15/10 179 (-0.2)
01/21/2010 176 (-3.0)
01/28/2010 175 (-1.0)
02/04/2010 173.6 (-1.4)
02/11/2010 172.2 (-1.4)
02/18/2010 171.8 (-0.4)
03/08/2010 170.8 (-1.0)
03/22/2010 172 (+1.2)
04/01/2010 173.8 (+1.8)
04/08/2010 172.2 (-1.6)
04/15/2010 171.5 (-0.7)
05/17/2010 170 (-1.5)
Biggest Loser Challenge
Canada Day Challenge 2010
Overall Weight Loss Goal
#42
-
- Members
-
- 3 posts
Newbie
Posted 11 May 2008 - 06:25 PM
QUOTE(Lisah101 @ Feb 15 2008, 08:05 AM) <{POST_SNAPBACK}>
I created this in excel to help me plan my menus. Anyone else who would like to can use it also. I use the first tab to plan my weekly menu, then the second tab to print it out and take to my JCC.
If you add new foods, click on the sort button when you are done. For some reason the VLookup that adds price and add ons won't work unless the list is sorted. I buy my own vitamins and thus don't use the anytime bars or multiplus. Let me know what you think.
If you add new foods, click on the sort button when you are done. For some reason the VLookup that adds price and add ons won't work unless the list is sorted. I buy my own vitamins and thus don't use the anytime bars or multiplus. Let me know what you think.
Lisah, this ROCKS! I never would have thought of something like this, or even known how to make it work!!!
I managed to figure out your coding, and I added a column in for calories. I don't like peanuts, so if I want to swap out a Peanut Butter Bar..... I want to know the impact of choosing a Triple Chocolate Cheesecake over the Cheese Curls.
Unfortunately, I can't figure out how to attach a file!!! Can anyone help? (Or if anyone wants a copy... drop a line and I can email it.)
Once again, thanks for the AWESOME spreadsheet Lisah!!!
MissTish
Age: 34
Height: 5'6"
Start Date: 5/3/08
SW: 204
Week 1: 199.2
Week 2: 196.8
Week 3: 194.4
GW: 155
Age: 34
Height: 5'6"
Start Date: 5/3/08
SW: 204
Week 1: 199.2
Week 2: 196.8
Week 3: 194.4
GW: 155
#43
-
- Members
-
- 29 posts
Member
Posted 19 May 2008 - 05:17 PM
I wanted to join in on the kudos to you Lisa!! Thank you so much for this.
~Bayou
~Bayou
walking.... walking.... walking....Age: 52
Height: 5' 10"
#44
-
- Members
-
- 16 posts
Member
Posted 06 September 2008 - 04:12 PM
LisaH,
According to one of your posts, were you able to add a weight graph to the spreadsheet? I love it and have been using it every week! Keep up the great work.
Carol
According to one of your posts, were you able to add a weight graph to the spreadsheet? I love it and have been using it every week! Keep up the great work.
Carol
[url=http://www.TickerFactory.com/weight-loss/wXuXptn/]
SW: 323.7 start date 1/6/08
1st goal lose 50 lbs. by 4/21 for Panama Canal Cruise
GW: 200.0
1 week - 15 week - 48#'s gone -- Panama Canal cruise did it!!!!
16 week - 30 week - 46.9 #'s gone
31 week - 48.3 #'s gone
SW: 323.7 start date 1/6/08
1st goal lose 50 lbs. by 4/21 for Panama Canal Cruise
GW: 200.0
1 week - 15 week - 48#'s gone -- Panama Canal cruise did it!!!!
16 week - 30 week - 46.9 #'s gone
31 week - 48.3 #'s gone
#45
-
- Members
-
- 61 posts
Advanced Member
Posted 06 September 2008 - 05:17 PM
THANK YOU!! This is quite simply, amazing! Thank you for the time and effort. I'm going to do what a previous poster said and add some calorie information as well as a weight chart. WOW, just WOW. I wish I could give you a hug!
Katypie
-----
Start: 7/20/08
Interim/First Goal: -50.4 lbs
-----
Month 1 (8/17/08): -7.6
Month 2, Week 1 (8/24/08): +1.0 (boooo....)
-----
-----
Halloween Challenge Progress:
-----
Start: 7/20/08
Interim/First Goal: -50.4 lbs
-----
Month 1 (8/17/08): -7.6
Month 2, Week 1 (8/24/08): +1.0 (boooo....)
-----
-----
Halloween Challenge Progress:
#46
-
- Members
-
- 83 posts
Advanced Member
Posted 06 September 2008 - 07:05 PM
Hi - THis looks really cool. I am so frustrated with the Web menu's technical difficulties. This may be the answer. One question - Is this for 1200 calorie plan? (Looks like it maybe....) If so, does anyone know what I add to make it 1500?
Thanks BUNCHES!
Thanks BUNCHES!
[url=http://www.TickerFactory.com/weight-loss/wcsLVQ7/]
Started JC 7/3/08 - SW 290.2
GW 175
Started JC 7/3/08 - SW 290.2
GW 175
#47
-
- Members
-
- 57 posts
Advanced Member
Posted 07 September 2008 - 01:24 PM
You're an absolute genius! Thank you SO very much for your generosity in sharing this with us! I love this spreadsheet and the ability to dynamically plan your meals.
Absolutely FANTASTIC!!!!
Thank you!!!
Absolutely FANTASTIC!!!!
Thank you!!!
#48
-
- Members
-
- 17 posts
Member
Posted 30 September 2008 - 11:16 PM
Cool spreadsheet! Thanks for sharing it with us. I too was pondering cobbling one up. I thing you did a way better job then I would have!
Thanks again
Thanks again
Started June 26, 2008
220 lbs
Goal wieght 155 lbs
220 lbs
Goal wieght 155 lbs
#49
-
- Members
-
- 89 posts
Advanced Member
Posted 06 October 2008 - 08:08 PM
I just posted the updated spreadsheet, but I'm a little nervous, I created it on a mac and haven't been able to see how that creating looks when viewed on a PC.
Phoenix, AZ 43 years old, 5 foot even
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
#50
-
- Members
-
- 53 posts
Advanced Member
Posted 06 October 2008 - 08:24 PM
QUOTE(Lisah101 @ Oct 6 2008, 08:08 PM) <{POST_SNAPBACK}>
I just posted the updated spreadsheet, but I'm a little nervous, I created it on a mac and haven't been able to see how that creating looks when viewed on a PC.
Thank you so much for creating the Spread sheet. I love it. It really helps me stay within my budget.
I notice you said you posted an updated version, where can I find it?
Thanks a million
Claudia
Join me on my journey to better health.
Weight is one loss I don't mind having.
Hoping we all have great success.
Weight is one loss I don't mind having.
Hoping we all have great success.
#51
-
- Members
-
- 89 posts
Advanced Member
Posted 06 October 2008 - 08:49 PM
I can't upload files anymore, so back on the first post of this topic, at the bottom is a link to the spreadsheet where it's posted on iVillage.
Glad it helps!
Glad it helps!
Phoenix, AZ 43 years old, 5 foot even
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
#52
-
- Members
-
- 53 posts
Advanced Member
Posted 06 October 2008 - 08:53 PM
QUOTE(Lisah101 @ Oct 6 2008, 08:49 PM) <{POST_SNAPBACK}>
I can't upload files anymore, so back on the first post of this topic, at the bottom is a link to the spreadsheet where it's posted on iVillage.
Glad it helps!
Glad it helps!
Thanks
Join me on my journey to better health.
Weight is one loss I don't mind having.
Hoping we all have great success.
Weight is one loss I don't mind having.
Hoping we all have great success.
#53
-
- Members
-
- 16 posts
Member
Posted 07 October 2008 - 02:48 PM
Thank you so much Lisa. I've been using your original spreadsheet every week. Now I can enjoy the weight loss graph too!
Thanks again for your great work!!!!
Carol
Thanks again for your great work!!!!
Carol
[url=http://www.TickerFactory.com/weight-loss/wXuXptn/]
SW: 323.7 start date 1/6/08
1st goal lose 50 lbs. by 4/21 for Panama Canal Cruise
GW: 200.0
1 week - 15 week - 48#'s gone -- Panama Canal cruise did it!!!!
16 week - 30 week - 46.9 #'s gone
31 week - 48.3 #'s gone
SW: 323.7 start date 1/6/08
1st goal lose 50 lbs. by 4/21 for Panama Canal Cruise
GW: 200.0
1 week - 15 week - 48#'s gone -- Panama Canal cruise did it!!!!
16 week - 30 week - 46.9 #'s gone
31 week - 48.3 #'s gone
#54
-
- Members
-
- 89 posts
Advanced Member
Posted 07 October 2008 - 05:37 PM
Thanks Carol,
Creating the spreadsheet is the easy part for me... sticking to the plan and staying away from bread and good artisan cheese..... that's the hard part!
Creating the spreadsheet is the easy part for me... sticking to the plan and staying away from bread and good artisan cheese..... that's the hard part!
Phoenix, AZ 43 years old, 5 foot even
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
#55
-
- Members
-
- 230 posts
Advanced Member
Posted 25 August 2009 - 08:18 AM
Hi!
I know your thread here is pretty old but I just found it and have to say AWESOME! You must have a lot of free time like I do but I didn't come up with something as thorough as this. It's August 2009 and a lot has changed w/JC (I'm talking prices!!). I just finished making all the changes and will be using this from now on. Thanks!!
I know your thread here is pretty old but I just found it and have to say AWESOME! You must have a lot of free time like I do but I didn't come up with something as thorough as this. It's August 2009 and a lot has changed w/JC (I'm talking prices!!). I just finished making all the changes and will be using this from now on. Thanks!!
SW: 182.4
CW: 169.2
GW: 140.0
Wk 1: -3.6
Wk 2: -1.8
Wk 3: -1.6
Wk 4: -1.6
Wk 5: -.2
Wk 6: -4.4
#56
-
- Members
-
- 89 posts
Advanced Member
Posted 07 September 2009 - 07:59 AM
Glad it was helpful to you. I haven't done JC in a while since my husband lost his job and we needed to cut back on expenses. I had lost most of the weight and am trying to do the last few pounds on my own by going to the gym a lot and making better food choices.
The prices must be way out of whack now, but I am glad people still find it helpful.
The prices must be way out of whack now, but I am glad people still find it helpful.
Phoenix, AZ 43 years old, 5 foot even
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
SW 154.4 Nov, 2007
CW 145.6
GW 120
the rest was deleted by the mysterious website gremlin doing updates.
#57
-
- Members
-
- 48 posts
Advanced Member
Posted 02 January 2010 - 07:49 PM
Wow, this is awesome. All I have to do is change the pricing and maybe add some items but all I can say is WOW! This is the best! Thanks so much for posting this. This is really going to help me.
The 7 Week Challenge for January 2010
SW as of 12/31/09- 199.5
Week 1 - lost 3.6 on 1/7/10 Yay! - 195.9
Week 2- lost 2.0 on 1/14/10 Woot! 193.9
Week 3- lost 4.6 on 1/21/10 Goodbye 190s
Week 4
Week 5
Week 6
Week 7
GW- to lose 15lbs and be at 184.5
JANUARY 2010 CHALLENGE
Biggest Loser Challenge- Season 9
PERSONAL GOAL
SW 213 on 12/17/09
WI on 12/24/09- 206.2- Good bye 210s!
WI on 12/31/09- 199.5- Good bye 200s! Happy 2010!
WI on 1/7/10- 195.9 - Half way through the 190s!
WI on 1/14/10- 193.9- Doing good.
WI on 1/21/10- 189.3 - Doing awesome!
One day at a time. Instead of giving myself reasons why I can't, I give myself reasons why I can.
COMPLETED CHALLENGES
DECEMBER 2009 CHALLENGE
I kicked some butt and then some! Yay!
SW as of 12/31/09- 199.5
Week 1 - lost 3.6 on 1/7/10 Yay! - 195.9
Week 2- lost 2.0 on 1/14/10 Woot! 193.9
Week 3- lost 4.6 on 1/21/10 Goodbye 190s
Week 4
Week 5
Week 6
Week 7
GW- to lose 15lbs and be at 184.5
JANUARY 2010 CHALLENGE
Biggest Loser Challenge- Season 9
PERSONAL GOAL
SW 213 on 12/17/09
WI on 12/24/09- 206.2- Good bye 210s!
WI on 12/31/09- 199.5- Good bye 200s! Happy 2010!
WI on 1/7/10- 195.9 - Half way through the 190s!
WI on 1/14/10- 193.9- Doing good.
WI on 1/21/10- 189.3 - Doing awesome!
One day at a time. Instead of giving myself reasons why I can't, I give myself reasons why I can.
COMPLETED CHALLENGES
DECEMBER 2009 CHALLENGE
I kicked some butt and then some! Yay!
#58
-
- Members
-
- 38 posts
Advanced Member
Posted 03 January 2010 - 08:02 AM
Thank you! This is so much more useful than the one on the website. It addresses the things that are important to people on the program (super user friendly, factors in the cost of food, options for using or not using Anytime Bars and JC Vitamins). Thank you so much for the time that you put into creating this fabulous tool and thank you for your willingness to share it with the rest of us.
#59
-
- Members
-
- 1,120 posts
Advanced Member
Posted 04 January 2010 - 08:22 AM
Thank you so much for this!
Does anyone know the prices of the new Yogurt Dream Bar and the New anytime bars? chocolate crisp and peanut butter.
I can't find my recipe from my WI on Sunday....
Thanks!
Beth
Does anyone know the prices of the new Yogurt Dream Bar and the New anytime bars? chocolate crisp and peanut butter.
I can't find my recipe from my WI on Sunday....
Thanks!
Beth
Joined: 12/09/08
SW: 270.2 lbs
1st Year on JC
December 9, 2008 - December 6, 2009
SW 1st year = 270.2 lbs
Last WI 1st year = 179.8 lbs
Lost 90.4 lbs and 54 inches
Went from a size 26 pair of jeans to a 12!!!!
2nd Year on JC
December 6, 2009 - December 5, 2010
SW 2nd year = 179.8 lbs
Last WI 2nd year =
MILESTONES:
SW: 270.2 lbs - 12/09/08
- LOSE 10 lbs. (260.2 lbs) - 12/30/08
- LOSE 25 lbs. (245.2 lbs) - 02/17/09
- LOSE 50 lbs. (220.2 lbs) - 05/05/09
- HALFWAY (210.1 lbs) - 06/09/09
- ONEDERLAND (199.9 lbs) - 08/11/09
- LOSE 75 lbs. (195.2 lbs) - 10/11/09
- LOSE 100 lbs. (170.2 lbs) - 05/08/10
***GW: 150 lbs
Total WL Goal!!!
SW: 270.2 lbs
1st Year on JC
December 9, 2008 - December 6, 2009
SW 1st year = 270.2 lbs
Last WI 1st year = 179.8 lbs
Lost 90.4 lbs and 54 inches
Went from a size 26 pair of jeans to a 12!!!!
2nd Year on JC
December 6, 2009 - December 5, 2010
SW 2nd year = 179.8 lbs
Last WI 2nd year =
MILESTONES:
SW: 270.2 lbs - 12/09/08
- LOSE 10 lbs. (260.2 lbs) - 12/30/08
- LOSE 25 lbs. (245.2 lbs) - 02/17/09
- LOSE 50 lbs. (220.2 lbs) - 05/05/09
- HALFWAY (210.1 lbs) - 06/09/09
- ONEDERLAND (199.9 lbs) - 08/11/09
- LOSE 75 lbs. (195.2 lbs) - 10/11/09
- LOSE 100 lbs. (170.2 lbs) - 05/08/10
***GW: 150 lbs
Total WL Goal!!!
#60
-
- Members
-
- 48 posts
Advanced Member
Posted 05 January 2010 - 01:55 PM
When I updated the prices and the items. Everything went down the tubes on the front page with the end totals. I looked at the formulas and they look right but they aren't totaling. Gosh, I'm so confused. I ONLY touched the yellow areas on the different tabs (the Breakfast, Lunch. Dinner....) Can someone help me get this straighten out? I appreciate the help, thanks so much!
The 7 Week Challenge for January 2010
SW as of 12/31/09- 199.5
Week 1 - lost 3.6 on 1/7/10 Yay! - 195.9
Week 2- lost 2.0 on 1/14/10 Woot! 193.9
Week 3- lost 4.6 on 1/21/10 Goodbye 190s
Week 4
Week 5
Week 6
Week 7
GW- to lose 15lbs and be at 184.5
JANUARY 2010 CHALLENGE
Biggest Loser Challenge- Season 9
PERSONAL GOAL
SW 213 on 12/17/09
WI on 12/24/09- 206.2- Good bye 210s!
WI on 12/31/09- 199.5- Good bye 200s! Happy 2010!
WI on 1/7/10- 195.9 - Half way through the 190s!
WI on 1/14/10- 193.9- Doing good.
WI on 1/21/10- 189.3 - Doing awesome!
One day at a time. Instead of giving myself reasons why I can't, I give myself reasons why I can.
COMPLETED CHALLENGES
DECEMBER 2009 CHALLENGE
I kicked some butt and then some! Yay!
SW as of 12/31/09- 199.5
Week 1 - lost 3.6 on 1/7/10 Yay! - 195.9
Week 2- lost 2.0 on 1/14/10 Woot! 193.9
Week 3- lost 4.6 on 1/21/10 Goodbye 190s
Week 4
Week 5
Week 6
Week 7
GW- to lose 15lbs and be at 184.5
JANUARY 2010 CHALLENGE
Biggest Loser Challenge- Season 9
PERSONAL GOAL
SW 213 on 12/17/09
WI on 12/24/09- 206.2- Good bye 210s!
WI on 12/31/09- 199.5- Good bye 200s! Happy 2010!
WI on 1/7/10- 195.9 - Half way through the 190s!
WI on 1/14/10- 193.9- Doing good.
WI on 1/21/10- 189.3 - Doing awesome!
One day at a time. Instead of giving myself reasons why I can't, I give myself reasons why I can.
COMPLETED CHALLENGES
DECEMBER 2009 CHALLENGE
I kicked some butt and then some! Yay!
2 user(s) are reading this topic
0 members, 2 guests, 0 anonymous users
