Here is an automated spreadsheet to track your fitness progress.

All daily progress is keyed on a single page, no more jumping back and forth.
You type in your weight in the morning, click 1 button, and a new daily menu is created, dated, and all of your caloric/fat/carb/protien goals for the day are filled in automatically!
All of your foods are available in pull down menus.
Exercise tracking is also available via pull down menus.
No more cut-n-paste. Keeping track of everything now literaly takes a few seconds each day.
Here is a sample screenshot:
http://www.adif.us/files/sample%20month.gif

I want to thank the JohnStoneFitness community for being such a positive and helpful place to get information and motiviation and especially to John for keeping this site going. John, you are a great inspiration to us all...Thank you.

The spreadsheet contains macros and has been tested and confirmed to work under:
-----Windows:
Excel 2003
Excel 2000
-----Linux:
Gnumeric

It has been confirmed NOT to work under:
-----Linux:
Open Office
-----Mac:
MacOffice 2004 on MacOS 10.x

If it successfully works or doesn't in any other spreadsheets or other version of excel, please let me know.

I have Office XP on my laptop. I'll give it a whirl and let you know if I find any bugs but so far, its been fine. Excellent work! Thanks for sharing this.

Seems to be working. I got a few errors trying to create a menu, but just filled in some fields on the Weight Loss Data page and then was able to continue. Looks like it'll be very easy to maintain. I just have to fill in my menu data.

Thanks!

Mike

, let me know if it works on excel xp or excel 2000) and does contains macros that are required for the automation to run.

Works on excel 2000 and excel XP. looks good , thank you.

I got a few errors trying to create a menu, but just filled in some fields on the Weight Loss Data page and then was able to continue.
Thanks!

Mike

I would like to make it work for as many people as possible with no errors:
What version of excel?
which button, create new month or new daily menu?
what errors did you get?
what fields did you have to fill in on weight loss data?
And did you fill in the 5 fields on the setup page?

I really like the spreadsheet. One suggestion: How about adding a column or 2 after Protein for users to track whatever they choose? If the user doesn't want to track anything else, then the columns aren't copied over. If the user wants to track something like Na, then the user puts it in the customizable cloumn and it is copied over when you create your Daily menu.

What version of excel? Excel 2003

which button, create new month or new daily menu? Create new month says June already created. I deleted that page and was able to recreate a new blank June, but only after I created a daily menu.

what errors did you get? Something about Error 91. Sorry, I didn't really read it. It asked if I wanted to debug.

what fields did you have to fill in on weight loss data? I had to fill in a weight and BF for the current date.

And did you fill in the 5 fields on the setup page? Yes I did.

I think my errors might be user created. I might be doing thing out of order. I did follow your steps on the setup page. When I reset the spreadsheet though, is still there. Might be what is causing some problems. I had to manually delete the June page to get a fresh menu.

Hope that helps..

Mike

Adi,

Is it possible to make an option of coping an entire days menu? If people are like me, we tend to eat the same things over and over.

Maybe the option "Copy Day" Then select which day to copy from... I'm not a programer, so I don't know how difficult or easy this request would be.

Thanks for sharing your speadsheet!

Mike

What version of excel? Excel 2003

which button, create new month or new daily menu? Create new month says June already created. I deleted that page and was able to recreate a new blank June, but only after I created a daily menu.

what errors did you get? Something about Error 91. Sorry, I didn't really read it. It asked if I wanted to debug.

Hope that helps..

Mike

Mike, I managed to duplicate the stuff you did. you found 3 bugs...thanks.

1. When you hit the wipe everything button it only deletes the sample month sheet. I also make it delete the current month.

2. When you entered the start date on the setup page it is not taking the proper date...excel is touchy...if you didnt enter exactly as 6/28/04 then excel screws it up and fills the dates in the weight loss data page with 1900's crap. I'll see if I can force cell validation better...if not I might have to put it in big red letters in the setup page.

3. since the dates arent current. when you enter a date on the jun '04 page, it scans the dates on the weight loss data page, cant find a match, and fails with error 91. I will fix that with a better error message related to bug number 2.

Darn, it fell flat on its face in the first 10 minutes...oh well...thats life.

Thanks very much!!!

Darn, it fell flat on its face in the first 10 minutes...oh well...thats life.

NOT EVEN! Please re-upload the new sheet when you have it. I plan on entering my menu this weekend and to start using it instead of Fitday on Monday.

Thanks again!

Mike

Adi,

Is it possible to make an option of coping an entire days menu? If people are like me, we tend to eat the same things over and over.

Maybe the option "Copy Day" Then select which day to copy from... I'm not a programer, so I don't know how difficult or easy this request would be.

Mike

New Version posted in the 1st post of this thread.

Bugfix 1. it now really screams at you if you dont key the start date right.

Bugfix 2. reset everything clears the current month as well (it does not however clear any other months if they should happen to exist. ie, jan '04, feb '04, and so on would be left alone to be deleted manually if so desired. That way, if you need to use it for more than 6 months...you can run reset on the 1st day of the 7th month, and still have all of your old months to have a history of your foods, weight, exercises, etc.

Enhancement 1. You are right about the being able to choose your foods ahead of time. I also eat many of the same things every day too.
I can't figure out a way to make a "copy day" funtion, I'm not a programmer either. However, way down at the bottom of the menu page you will find the master daily menu. there you can pre-setup the master with times and foods. from then on any time you click create today's menu it will be prepopulated. Its not as good as copy "any day" to "any other day", but its close.

Thanks again for the the feedback.

And not to worry, as fixes come out...you can always:
1. copy/paste the whole menu C4:I399 from the old one to the new one.
2. same with the weight and body fat numbers (wl data, B2:C188)

Great! I'll play with it this weekend.

Thanks again. Great job!

Mike

Works on excel 2000 and excel XP.

Thank you so much for testing...I was worried about the macros not working for everyone. Your time is much appreciated.

v1.03 added to the 1st post in this thread.

1. The 1 outstanding bug, error 91, when keying a date not in the date list has been fixed. Instead of crashing to the debugger you will now be prompted with a nice message explaining how to key the start date.

If anyone finds any more issues, please let me know.

How about adding a column or 2 after Protein for users to track whatever they choose? If the user doesn't want to track anything else, then the columns aren't copied over. If the user wants to track something like Na, then the user puts it in the customizable cloumn and it is copied over when you create your Daily menu.

Hmmm:
The copying it if it exists and not if its blank may be out of my capabilities. But I can add 2 columns that will just always copy whether blank or not.

Questions:
1. A Column or 2 to key whatever one wants. You mean related to each food item?
-So a couple extra colums on the menu page as well?
-Like sodium or other characteristics of the food?
-or just 2 columns not related to the food at all that just go at the end after protien?
-would these columns have calculation at the bottom of each day, like protien and calories, or just informational?

2. You said "something like Na," whats Na?

Comments:
I worked hard to make sure I at least kept the data john and marco had, and to make sure it fit on a 1024x768 without having to scroll . I'm willing to make the change if it is useful, but I cant figure out the usefullness. Thats not to say I cant just make you a custom one with 2 extra columns.

Na is the symbol for sodium.

Hmmm:
The copying it if it exists and not if its blank may be out of my capabilities. But I can add 2 columns that will just always copy whether blank or not.

Questions:
1. A Column or 2 to key whatever one wants. You mean related to each food item?
-So a couple extra colums on the menu page as well?
-Like sodium or other characteristics of the food?
-or just 2 columns not related to the food at all that just go at the end after protien?
-would these columns have calculation at the bottom of each day, like protien and calories, or just informational?

Yes, I was thinking of a couple extra columns related to each food item so that would also mean a couple of extra columns on the menu page. These columns would have calculations at the end of each day (just totals).[/quote]

2. You said "something like Na," whats Na?

Na is Sodium

Comments:
I worked hard to make sure I at least kept the data john and marco had, and to make sure it fit on a 1024x768 without having to scroll . I'm willing to make the change if it is useful, but I cant figure out the usefullness. Thats not to say I cant just make you a custom one with 2 extra columns.

I appreciate the effort to keep it at 1024X768. These 2 extra columns would make it "bigger" but just decreasing the Zoom would enable the user to keep it all on a single page. Some may find it useful, others may not.

Personally, I would like to be able to track Na content so a single column would do. I wouldn't mind a custom made spreadsheet if its not too much of a hassle. I like the enhancments you've made so far. Keep up the good work. :tucool:

Yes, I was thinking of a couple extra columns related to each food item so that would also mean a couple of extra columns on the menu page. These columns would have calculations at the end of each day (just totals).

You have a point...many people probably are probably concerned with Salt.

I had an idea. how about I make the SAT FAT, FIBER, and SUGARS columns customizeable. They are just informational, much like the Sodium that you wanted, and not used for bmr calcs like FAT/CARB/PROT so they dont server any purpose in calculations anyway. You can change the description to anything you like and it will carry over into the daily menu with totals at the bottom.

I have posted it in the first post as v1.04.
Let me know if you still prefer more columns.

I'll check it out later tonight. I was thinking earlier that I could modify it and change Sugar to Na. Thanks for making those columns customizable. This should do it. I'll let you know.

I'm using Excel 2000 and I'm running into some problems.

- I reset the spreadsheet for a new user.
- I entered the info on the setup page correct.
- I entered my weight and bf% in the weight loss data sheet.
- I chose my meal at the bottom of the Menu Sheet.
- Now, when I click create new month on the bottom of the menu sheet, it creates a blank spread called Jun '04. But nothing is in that sheet, its completely blank and unlike your sample month.
- Also, when I click create today's menu on the bottom of the menu sheet after i pick my meals it gives me this error:

'Whoops! You cannot create a new daily menu from this page.'

I'm using Excel 2000 and I'm running into some problems.

- I reset the spreadsheet for a new user.
good
- I entered the info on the setup page correct.
good
- I entered my weight and bf% in the weight loss data sheet.
no weight or bf data is entered on the wld sheet...you enter it on the jun '04 sheet every morning and the wld sheet is automatically populated.
- I chose my meal at the bottom of the Menu Sheet.
this is only done if you plan to pre-populate your daily menu with stuff you eat every day, otherwise dont touch anything here...this is the master daily menu and is used as the source for each day's menu. The meals you eat each day are also recorded on the jun '04 page..this page is of course blank for you, so there is no way you could figure that out.
- Now, when I click create new month on the bottom of the menu sheet, it creates a blank spread called Jun '04. But nothing is in that sheet, its completely blank and unlike your sample month.
Now this could our 1 true problem...although the instructions do say to click the create new month button on the setup page...the one on the menu page should still work...this may actually be an excel macro issue in version 2000...I dont have 2000 to test with, it was tested by one of the users here, listed in a previous post above...maybe he didnt try that button. althought all that button does is create a new page, which is happening, and copy master daily goals section from the menu page...all basic stuff that should really work in older excel versions.
- Also, when I click create today's menu on the bottom of the menu sheet after i pick my meals it gives me this error: 'Whoops! You cannot create a new daily menu from this page.
That is a feature. Daily menu's are to be created on the current month page (in this case june '04) but of course if that page is blank for you, then that is the real problem I need to figure out.

I any case, try this for me.
1. download the new version 1.05
2. Open a new version of the spreadsheet, not the one you already made.
3. goto the sample month page.
4. click "create new monthly menu"
5. it should create a new page called jun '04 and the first 12 lines should match the sample month page.

did this happen, or is it blank?

In the meantime, I will lock out both buttons on the menu page and all of the weight and bf% fields on the data page, to avoid others having the same confusion. I am uploading this to the first post as v1.05

Thanks for your feedback.

Alright thank you. I'll give this a try right now

Well, I downloaded your updated version. I ran it and got the same thing.

I left the sample month there like you asked and clicked create new month right off of the sample month and it brought me yet another blank page.

Also, just to let you know. The 'Create New Monthly Menu' button on the setup page produces the same results. A blank page for Jun '04.

Also, just to let you know. The 'Create New Monthly Menu' button on the setup page produces the same results. A blank page for Jun '04.

darn, I was afraid of that...so much for testing.
It looks like the copy functions I'm using are not compatible with excel 2000. I'm sorry. I will remove the 2000 compatibility statement from the 1st post.

I will test it out and try to fix it if I can get my hands on a copy of excel 2000.

Thanks for trying my suggestions. My guess is that if that doesnt work, then the create daily menu button, which is far more complicated than the create new month will also fail royally. Sorry again.

alright :( I guess I'll have to find someone who can lend me a copy of 2003 then because this spreadsheet is worth it. dang this sucks.

thanks again for the help

I'm curious. Where did you get all the nutrition information for your menu? There's so many different sources and a lot of them say different things about the same fruit.

I'm curious. Where did you get all the nutrition information for your menu? There's so many different sources and a lot of them say different things about the same fruit.

Lets see, I had several spreadsheets to start with and I used the foods I eat from both, deleted what I dont eat, and added more from box labels, so:
Some of the menu is from john's original transformations.xls
some is from marcos marcofitness.xls
and a majority of the vegetarian meat stuff is from box tops in my freezer.
The fruits however, I agree, are tough, but eventually I just gave up worrying about the discrepancies and just said, what the heck, close enough. the two sites I used are:
http://www.calorieking.com/
http://www.weightlossfriends.com/index.php/food/groups/0900

And thank you for the compliment in the above post. I appreciate it very much. I hope a lot of people use it, it will make me feel like I've really contributed to the cause.

WOW Adi... thank you.

Today was chosen as the day I go back On Program - I've been letting things go for a good long while now and I'm seeing the negative results of that path. I chose today to get back, and then I came here and found this fantastic spreadsheet. Thank you so much for your time and effort - and thanks also to everybody helping to test this sheet and make it the best it can be.

Thank you all, really, from the bottom of my heart.

James

WOW Adi... thank you.

Today was chosen as the day I go back On Program - I've been letting things go for a good long while now and I'm seeing the negative results of that path. I chose today to get back, and then I came here and found this fantastic spreadsheet. Thank you so much for your time and effort - and thanks also to everybody helping to test this sheet and make it the best it can be.

Thank you all, really, from the bottom of my heart.

James

Wow James, thanks a lot...really makes me feel good.

alright :( I guess I'll have to find someone who can lend me a copy of 2003 then because this spreadsheet is worth it. dang this sucks.

thanks again for the help

Version 1.6 posted in 1st post of this thread.

Excel 2000 compatibility fixed and tested.
Thanks again for all of the kind words.

adi,

the spreadsheet is awesome. I have another suggestion for you if you're interested in trying it. How about adding a couple more pages for training that are similar to the menu/monthly pages? Or a new spreadsheet dedicated to training?

1. One page will be like the menu in which there are different categories but these categories would be muscle groups. Under each group one would list all the different exercises he/she would want.
2. The user would hit the "Create" button and a general workout log would be generated. The user would then use the drop-down buttons and select the muscle and exercises that was trained that day.
3. Time, Category, Description, Set, Reps, Weight, Failure (Y/N), Difficulty(1-10) could be some of the columns that would replace the current categories. In place of calories it would be set, fat would be replaced with reps, etc.

Just a few thoughts. Your work has been awesome. I prefer to use Excel to track food and workouts and your spreadsheet has made it much more convenient to do this. Thanks again.

adi,

the spreadsheet is awesome. I have another suggestion for you if you're interested in trying it. How about adding a couple more pages for training that are similar to the menu/monthly pages? Or a new spreadsheet dedicated to training?

Funny Enough, I had been thinking about that issue:
The daily menu, based on Marco's stuff, does have a place for you to put that day's weights and cario routines, and even the calories burned for each one.

Currently that piece is all manual of course, I left it there because it can be very useful, especially if you want to go back in time to a specific day and see what you did.

Thoughts on this:
I would lik to make 1 integrated spreadsheet with both weights and food on the same daily menu . I think about using it myself and dont think I would if it were 2 separate sheets.

I dont think the current configuration of the sheet will work because there is only room for 1 pulldown for weights and 1 for cardio, which means:
You would have to group your stuff by day, ie, (legs, back on one day) (chest, tri, delts on another) and have 1 grand total for calories burned. This doesnt really fit the the max-ot process of changing things around all the time.
So I'm guessing the menu itself would need a bit of a retrofit.
If anyone wants to simply cut/paste 1 daily menu onto a blank spreadsheet and play around with layout suggestions (no formulas, just layout') I would be happy to look at them and try to put something together. I've played around but cant figure a menu that is not huge!!!

however, all of the suggestions here so far have been great and I believe I have implemented every last one...so I'm obviously willing if someone helps me come up a useable integrated menu, or at least gives me something to get me in the right direction.

Yeah, I agree that it would be better in one spreadsheet - I just didn't want to seem too pushy ;)

Your responses to the posts have been great. I'll play around with the menu layout tonight and see if I can actually help with the work instead of suggesting more work for you :)

Yeah, I agree that it would be better in one spreadsheet - I just didn't want to seem too pushy ;)

Your responses to the posts have been great. I'll play around with the menu layout tonight and see if I can actually help with the work instead of suggesting more work for you :)

Dont mind doing the work, just need someone more creative to suggest a layout. I tried for hours but eventually gave up out of frustration...

Similar to the whole sodium thing, sometimes other people can kick-start and idea and get you going again.

Dont mind doing the work, just need someone more creative to suggest a layout. I tried for hours but eventually gave up out of frustration....

First, I was premature on my call on the 2000 compatiability, I am sorry. I jumped over to XP version and missed the problems.

Is the measurements area of weight loss data page locked out, how do we enter?

The one spreadsheet would be the best means. Thanks for your work.

First, I was premature on my call on the 2000 compatiability, I am sorry. I jumped over to XP version and missed the problems.

Is the measurements area of weight loss data page locked out, how do we enter?

The one spreadsheet would be the best means. Thanks for your work.

Your weight is entered every morning on the monthly menu page. and then you press the create today's menu button. the wld page gets automatically populated.
in the instructions on the setup page see step 5, how to use the monthly menu page for all the details.

note: if you are importing your weight from an older spreadsheet, just unlock that page..there is no password, and it will relock the next morning when you click the create today's menu button.

Your weight is entered every morning on the monthly menu page. and then you press the create today's menu button. the wld page gets automatically populated.

I am referring to chest, arm, and etc measurements, How do you enter those?

I am referring to chest, arm, and etc measurements, How do you enter those?

Oh I'm sorry...didnt realize what you meant. There was no clean way I could think of to automate the measurements, so they are of course entered manually if so chosen.

I just checked the v1.07 spreadsheet and all of the measurement cells in WHITE are unlocked except for the SAMPLE column. the samples are locked. field i21 for example, should allow you to key in measurements. let me know if yours doesnt.

1. do you think I should unlock the samples column?
2. do you think the sample column is necessary? I could have it get cleared along with the others when you click "reset everything"

1. do you think I should unlock the samples column?
2. do you think the sample column is necessary? I could have it get cleared along with the others when you click "reset everything"

Works fine, now. Don't know why I couldn't enter after clearing. Sample will be all right, as is. Thanks again. :claplow:

Great idea, but I've run into a problem.

First, I'm using Office 2004 for Macintosh.
When I first open the spreadsheet, I get an error:
"Compile error:
Sub or Function not defined"

If launches Excel's VB editor and has "Sub Auto_Open()" highligted in yellow (on line 1) and "MonthName" highlighted in blue (on line 3).

I'll see if I find anything else.

When I press the "Reset Spreadsheet" button, I get the same error again, this time "Sub Reset_Everything()" is highlighted. Looks like it is on line 12.

Great idea, but I've run into a problem.

First, I'm using Office 2004 for Macintosh.
When I first open the spreadsheet, I get an error:
"Compile error:
Sub or Function not defined"

If launches Excel's VB editor and has "Sub Auto_Open()" highligted in yellow (on line 1) and "MonthName" highlighted in blue (on line 3).

I'll see if I find anything else.

When I press the "Reset Spreadsheet" button, I get the same error again, this time "Sub Reset_Everything()" is highlighted. Looks like it is on line 12.

Wow, I've fixed all the rest, but eventually even my luck runs out. I appreciate your detailed error messages and descriptions but you are running on a MAC. Macs run unix and I have no clue how vba (which is what the macro's are written in) works on a MAC. I did some research online and spoke to a couple programmers at work, and can find nothing to even point me in the right direction. My guess is the macros need to be rewritten specifically to run on a mac, but thats out of my league.

I did try one thing...the error is a compile error, and there is a compile option in the vb editor....so I ran it and uploaded a version 1.08.
I dont really think it will fix it but please give it a try and let us know.

Good Luck!

Sorry, I've been busy and haven't visited in a while. I work on Macs at work, but use a PC at home. I'll just use it on my PC.

But I'll give the new version a spin at work on Tuesday and let you know how (or if) it works.

Take care and have a good Fourth!

Hey Adi,

I was wondering if it would be possible to add rows for what you eat at any given time. For instance; let's say at 11:30am I have an apple, banana, and a turkey sandwich, and maybe a protein shake or something. That leaves me with 4 food items I ate and only 2 rows to enter my data.

I'm finding that once in a while I'll run into a little bit of a bind because I've eaten more items than what I'm allowed to enter. Maybe keep 2 rows for breakfast, and 4 for the rest? I'm not sure if it'd work out, just throwin it out there.

Thanks

Also, on your newest update I may have found a minor bug.

When you reset the spreadsheet for a new user the dates where you manually put your measurements in at are messed up. I'm not sure if you intended for us to change them manually as well or not so I figure I'd mention it.

The date it starts with is Jan, 1900.

Hey Adi,

I was wondering if it would be possible to add rows for what you eat at any given time. For instance; let's say at 11:30am I have an apple, banana, and a turkey sandwich, and maybe a protein shake or something. That leaves me with 4 food items I ate and only 2 rows to enter my data.

Thanks

The times on the left are totally arbitrary, you can change them to be anything you want. They are simply the times I eat every day. To change the master, so that they prepopulate everyday, just modify the master menu at the bottom of menu page. the ability to do this is documented on the advanced menu config instructions on the setup page along with the ability to prepopulate some of your meals as well.

Also, on your newest update I may have found a minor bug.

When you reset the spreadsheet for a new user the dates where you manually put your measurements in at are messed up. I'm not sure if you intended for us to change them manually as well or not so I figure I'd mention it.

The date it starts with is Jan, 1900.

Hmm...Are you talking about the start date that you enter on the setup page? I just downloaded 1.08 from the site and tried it and it seems okay to me.
1. is it version 1.08 you are using?
2. when you reset the spreadsheet the 5 fields on the setup page should go blank, is that happening?
3. then when you key the start date you get a yellow popup message indicating specifially how you must key the date with an explanation about excel's quirkiness. do you get that?

the 1900 is the date excel defaults to if you key what excel considers an invalid date...but I fixed it a couple versions ago...it wont allow you to enter a date that old if you tried. If what I tested is not the problem, please let me know...be as specific as possible and I will strive to fix it.

Thanks,
Adi

About my first problem.

What I mean is, let's say at 9:30 I want to eat more than 2 foods. There's only to rows that I can enter my food information into. So if I eat three things, I have no where to put my third item.

It doesnt look like I can change that on the menu page, I tried but maybe I'm missing something.

In other words, I dont want to change the times that I eat, just how much data/foods I can enter for each time.

In other words, I dont want to change the times that I eat, just how much data/foods I can enter for each time.

There are a total of 15 lines for food for each day...the times column can be customized any way you want. if you need more spaces at 9:30, move the 11:30 and all the rest of them down a couple lines.

You can customize column A any way you want....in ANY combination. The time entries are arbitrary. You can put times in the blanks and blank out the ones that currently have times. You can make 9:30 3 lines or 4 or 5 or whatever you want. The only limit is that you have -15 lines total for each day.

Do you need more than 15 lines for a given day? Thats not a problem either...once you create a menu for today you can add as many lines as you want. the instructions are explained step by step on the setup page....
-in the how to use the monthly menu section.
-in the diet subheading
-look for the text that says "If you need to add more lines for food items:"

I hope that helps.

Well, its been a fun run for the past 2 weeks. I see that my little program has been downloaded 100 times and this thread has been viewed over 1000 times. Makes me feel good that people are finding my program helpful.

Given the popularity, I have release version 2.0 on the 1st post in this thread. Its 2.0 because of 1 major change: you can now track your workouts using the menus just like you track your meals.
New features include:
1. I cleaned up the daily menu by removing the "Choose Food Item" text in each of the menu items. I found it to clutter the menu and make it harder to read. the food items are now blank until you use the pull down menu.
2. Yep, as stated above, due to popular request I have added and "Exercise Menu" similar to the food "Menu"
You can now automatically track you workouts and calories burned along with your food.
Now, word of warning, the workout menu I devised will not be for everyone.

If you, like me, work out on a fixed schedule (example: Tuesday: chest, delts, triceps. Thursday: back, biceps) then this should work well.
If you work out on a varying schedule like Max-OT where each week has a different routine, this probably wont work....thats ok, the workout stuff is totally optional and you can still use the food menu just like before.
You Max-Ot'ers out there are welcomed to make suggestions on how to accomodate for that type of workout.

I hope everyone finds this new version useful.
Upcoming modifications:
Marco of Marcofitness contacted me and said that he keys his menu the night before. The current program of course assumes that you key your weight the morning of each day, not the night before. I am trying to figure out a way to grant marco's enhancement request.

This looks great! Unfornately it doesn't work for me!

I get a lot of Macro errors! I tried to turn the macro security on low, but it says "The Macro 'Fitness Log.xls'!New_Month' cannot be found"

Any help would be great!!

I get a lot of Macro errors! I tried to turn the macro security on low, but it says "The Macro 'Fitness Log.xls'!New_Month' cannot be found"


Weird...I just checked the the zip file, opened the spreadsheet and clicked new month and it works fine. I checked all of the macro's and they are all there including new_month.

So far, I have been able to fix every problem anyone has ever posted except for the macintosh user....so here goes:
1.What version of excel are you running?
2. Have you ever tried any of the older versions or is this the first time you are seeing my spreadsheet?

This is the first time seeing the spreadsheet. I'm using Excel 2002...

Also, when I start excel I get this:

Microsoft Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\Russell\Desktop\Fitness Log.xls'
The following is a list of repairs:

Lost Visual Basic project.
Lost ActiveX controls.

Also, when I start excel I get this:

Microsoft Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\Russell\Desktop\Fitness Log.xls'
The following is a list of repairs:

Lost Visual Basic project.
Lost ActiveX controls.

Fatburner, I just downloaded the zip at a coworkers machine...he is running excel 2000...everything worked fine...all buttons worked.

As you can see on the 1st post, this has never been tested under excel 2002 (xp); however, since it does work under excel 2000 and 2003, I think it should work fine under 2002.

1. My guess is that the xls inside the zip file you have is corrupted in some way.
2. Maybe try downloading it again?
3. Also try dl'ing it from another machine and running it there...maybe you have a hard drive problem? (i hope not, but it could be a possibility)
4. The errors you list indicate that something is seriously wrong, not an excel 2002 incompatibility. But since I can download it on a 2003 machine and a 2000 machine with no errors, I must assume the proble lies on your machine.

Please try my suggestions and let us know.

ps, is anyone else out there able to open it in excel 2002?

Adi, this is marco. Just wanted to say thank you, you have been extremely helpful. I am using your 1.8version of the spreadsheet.

I've found a few ways to get it to do what i want with the exception of being able to plan my meals one day in advance...no biggie, but if you do find a way that would cool.
I don't know what happened, but for some reason when i edited your sheet it is also putting my BMR in the area where protein grams remaining should be. This occurs when i press the "create todays menu" button. Can't seem to fix that even though it looks like i did everything right on the menu page. I put the spreadsheet here on my site...
http://www.pfg-marco.com/tools.html

Once again, thank you very much.

Adi, this is marco. Just wanted to say thank you, you have been extremely helpful. I am using your 1.8version of the spreadsheet.

I've found a few ways to get it to do what i want with the exception of being able to plan my meals one day in advance...no biggie, but if you do find a way that would cool.
I don't know what happened, but for some reason when i edited your sheet it is also putting my BMR in the area where protein grams remaining should be. This occurs when i press the "create todays menu" button. Can't seem to fix that even though it looks like i did everything right on the menu page. I put the spreadsheet here on my site...
http://www.pfg-marco.com/tools.html

Once again, thank you very much.

Marco, I figured out how to do your request. I was hoping to incorporate your changes into my spreadsheet so that it could do both. Sadly there was no clean way. So I created a custom sheet for you. Its not the way I wanted to go, but as I told you in our earlier emails, without your and John's inspiration I would not have done this, so I will strive to fulfill any request you make.

Man you changed alot of stuff, or should I say you changed alot of it back...oh well, whatever works for you my friend.
The create today's menu button has been removed.
It has been replaced by 2 buttons,
1. create tomorrows menu
click button 1 the night before and it will populate a blank menu with tomorrow's date. No fat, carbs, prot, bmr, etc...

2. enter today's weight.
the next morning, enter your weight and click the button 2. this will fill in the weight loss data page, and all of the stuff on the menu you created the night before.

I also fixed your bmr problem.

I have no problem with you taking my sheet and making it your own. I also have no problem with you publishing it on your site as well. (thanks for giving me credit on your site, btw, but it was not necessary.)

I ask only 2 favors:
1. My request is that to avoid confusion, please modify the top of the setup page so that people don't get confused between yours and mine.
2. Always rename the file. You've already done that which is a good thing.

I just dont want people asking for enhancements or error fixes and have it turn out not to be my sheet. Keeping up with fixes/enhancements for 1 sheet is more work than you can imagine.

I unlocked the setup page on your copy and will send it to you in an email. I'm glad you like my program...I hope in time you find it easier to use than what you had before.

ps. anyone wanting to use marcos sheet, please visit his site.

It worked! I tried re-downloading it again! Thanks for troubleshootin! :D

It worked! I tried re-downloading it again! Thanks for troubleshootin! :D

Do me a favor...use it for a couple days...if everything works, please let us know, that way I can add excel 2002(xp) to the list of supported versions.

Version 2.01 has been posted in the first post of this thread.

New Feature in 2.01:
You no longer have to start your program on a Monday. The start date can now be any day and the program will modify all of the weight loss data accordingly.

To date, I have implemented every suggestion made, and even added several of my own ideas that popped up along the way. (I am, of course, always open to further enhancement requests and will fix any bugs found.)

adi,

wow! great job on the spreadsheet. I forgot to check out earlier versions due to other commitments and blah blah blah. In short: Life gets in the way sometimes and clutters up the mind. As I said before, thanks for working on this. You and Marco have provided some great tools for everyone to use.

adi,

wow! great job on the spreadsheet. I forgot to check out earlier versions due to other commitments and blah blah blah. In short: Life gets in the way sometimes and clutters up the mind. As I said before, thanks for working on this. You and Marco have provided some great tools for everyone to use.
Hobbes,
You stink...what happened to your suggested layout for a workout page....I thought you might have over-fitnessed yourself and keeled over.
You were the first one to make the exercise suggestion, so try out the exercise menu page for a couple days and see if you can come up with any improvements.
It really only works for those on a consistent workout routine. It cant cope with people changing things around all the time like max-ot. I'd like to figure out a way to do that. The cardio part should work for everyone, but the weights portion is too strict.

Hobbes,
You stink...what happened to your suggested layout for a workout page....I thought you might have over-fitnessed yourself and keeled over.

lol. Sorry adi. :o I took my wife on a surprise get-away and I got caught up in the planning, the actual trip, etc. When I got back, I just forgot as I was swamped with work and family issues.

You were the first one to make the exercise suggestion, so try out the exercise menu page for a couple days and see if you can come up with any improvements.
It really only works for those on a consistent workout routine. It cant cope with people changing things around all the time like max-ot. I'd like to figure out a way to do that. The cardio part should work for everyone, but the weights portion is too strict.

I'll give it a go :tu:

Version 2.02 has been posted in the first post of this thread.

Version 2.02 Features:
Enhancements to the measurements section.
For those who take weekly measurements, the weight loss data page now contains:
1. a place for all measurements for a 6 month period.
2. the ability to choose from a pulldown the day of the week that you prefer to take your measurements and all dates will be filled in accordingly.
3. a link to Health Central's online body fat calculator where you can input your measurements to get your bfp.


The longer I use my own program, the more features and tweaks that present themselves. (I am, of course, always open to further enhancement requests and bugs fixes.)

bump

Version 2.03 has been posted in the first post of this thread.

Version 2.03 Features:
For those who take measurements and record body fat percentage, the weight loss data page now contains More Enhancements to the measurements section:

In addition to the v2.02 enhancements:
1. a place for all measurements for a 6 month period.
2. the ability to choose from a pulldown the day of the week that you prefer to take your measurements and all dates will be filled in accordingly.
3. a link to Health Central's online body fat calculator where you can input your measurements to get your bfp.

v2.03 enhancements:
4. When you key your body fat %age on any given day, it is recorded on the Weight Loss DATA page.
- On days you dont key your bfp, the bfp on the wld page would get set to 0. Now it stays the same until you key a new bfp.
- This makes for more consitent data on the wld page.

All in all, this update is just some nice sprucing up for those who track body fat. So get yourself some myotape and track away.

I'd love to get this spreadsheet to work on my mac. I'm using the Microsoft Office X version of Excel. I read through the previous posts and saw your comment that a mac version would be "out of your league". Are there possible solutions? -Pablo

I'd love to get this spreadsheet to work on my mac.

All of the errors given to me by the last person seemed to be related directly to the vba scripts running...I did recompile to try to fix the mac issues but that person never responded whether things worked or not.

I'll try recompiling again and post a "possible mac compatible version" in the first post of this thread. Just do me a favor and let me know if it works or not.

In addition, if you can find anything on the web regarding vba programming on the mac, that might help me...I could find no mac vba programming references so I dont know where to begin to try to fix things.

Thanks for the reply. I'll let you know if it works or not. -Pablo

All of the errors given to me by the last person seemed to be related directly to the vba scripts running...I did recompile to try to fix the mac issues but that person never responded whether things worked or not.

I'll try recompiling again and post a "possible mac compatible version" in the first post of this thread. Just do me a favor and let me know if it works or not.

In addition, if you can find anything on the web regarding vba programming on the mac, that might help me...I could find no mac vba programming references so I dont know where to begin to try to fix things.

Thanks for the reply. I'll let you know if it works or not. -Pablo

Ok, here it is pablo, i posted it here instead of the 1st post in the hopes less people will see and download it since its just a test version.
I dont have a lot of hope, but let me know how it goes.

Update: Pablo, I have removed the mac test version and am awaiting your feedback.

Adi, this file is the best thing to happen to my hope for a better body! Without a daily process to keep track of my day, with such ease, I would probably be lost and given up by now.

I notice on the "Setup Page", it says you should start logging on a Monday. I started on a Thursday. Shall I expect problems?

Also, I vote for this thread to be sticky.

Adi, this file is the best thing to happen to my hope for a better body! Without a daily process to keep track of my day, with such ease, I would probably be lost and given up by now.

Also, I vote for this thread to be sticky.
Thanks for All the kind words. Its nice to be appreciated...especially when I worked so hard for so long doing this.
Prior to this spreadsheet, I had only programmed in vb once before, and never written an excel formula, so you can imagine how long it took. My guess is somewhere along the line of 300 hours to create this.
I, like you, knew I couldnt keep up with my program without something like this. All the other spreadsheets like this took me too much time with all the cutting and pasting. I spent the first month of my program writing this more than dieting and exercising, so my first month did not yield any real results. But using this spreadsheet diligently for the last 2 months, I have been able to lose 18 lbs so far. I've gone from a size 40 to a 36, and I'm hoping to see 34 by the end of this month, and if I can do you you can too.

I hope someone will make this a sticky too, i think it will help lots of people, but thats for the forum gods to decide and not me, but thanks for the vote!

I notice on the "Setup Page", it says you should start logging on a Monday. I started on a Thursday. Shall I expect problems?
To answer your question:
Wat version are you running??? I fixed the start on monday issue (by adding copious amounts of excel formulation to figure out the days of the week) several versions back, so if you are using 2.03 you should be fine. I looked at the setup page and did not find any reference to monday on version 2.03 (i removed the "you must start on monday" statement at the same time that I added the extra code.)

If you are using an older version, you can still start on thursday, but the dates will not match the days of the week on the weight loss data page. its not a big deal but I would find it extremely annoying....so I definitely recommend moving up the the newest version.

Again, thanks for the kind words and Good Luck in your quest. This is a great site for motivation and inspiration. I look at john's monthly photos (for months 1-6 of his program) every day just to keep me motivated. I have patterned my diet and exercise program after the suggestions he gives in his FAQ section, and things are working great for me.

No question, real sticky material.

Wat version are you running???

V. 1.08, yikes! Now how do I update the new file with my old file's data (the daily menus of August and July)? Do I have to re-enter the times of my meals, etc.?

So far, I can move the months from my old database, by dragging and dropping. The weight loss data page and weight loss chart have no info. Do I need to do this all manually? :d_frown:

V. 1.08, yikes! Now how do I update the new file with my old file's data (the daily menus of August and July)? Do I have to re-enter the times of my meals, etc.?
the daily menu's you'll lose...you can cut and paste entire pages, like cut august from the old one and paste into the new one..but the food fat/carb/etc values get screwed up, so easier to just scrap the old days, or just hang on to the old spreadsheet...all the other stuff can be copied over...you just fill out the 5 items on the setup page again, and as for the menu and the weight loss data page, there are instructions on the setup page and in some of the old posts in this thread. I always use the latest version for my own stuff too, and it takes me less than 10 minutes to transfer the data over. You dont even need all of it, just the menu, the weight loss history (columns B and C on the weight loss data sheet) and your measurements...everything else will get auto populated the next time you key in your morning weight. just read the setup page.

sorry for the inconvenience, if I ever come up with a way to bring over the old menu's, I will add it as a new version, but for now, I'm stumped.

Adi, everything is working great except the new Exercise Menu. I understand it's still a work in progress, and you haven't seen any suggestions on it, yet. So here goes:

I'm running outta room in the Cardio section. Every day my jogging times and BPM changes, it seems. The amount of calories burned changes daily. The menu only allows 15 inputs.

Also, sadly, caloriesperhour.com only estimates how many calories you burn based on time, not the specific workout you had. I'm doing continous research on exactly how many calories I burn during a normal day, in an effort to get to the minutia of how many calories I should have a day. Anyone have any links on where we could find more accurate information?

I noticed the BMR calculation doesn't include marcus' additional math (http://forums.johnstonefitness.com/showthread.php?t=1222):

Now we need to take into account the amount of energy burned through activity.

1. If you are sedentary (little or no exercise) – BMR X 1.2

2. If your are lightly active (light exercise/sports 1-3 days a week) – BMR X 1.375

3. If you are moderately active (moderate exercise/sports 3-5 days a week) – BMR X 1.55

4. If you are very active (hard exercise/sports 6-7 days a week) – BMR X 1.725

5. If you are extra active (very hard daily exercise/sports & physical job or training twice daily – BMR X 1.9

Which you then subtract the amount of pounds you intend to lose a week (for ex. 2 pounds a week, means you subtract 1000 from this number).

Shouldn't this be added on top of the BMR?

Minor improvement: We should have to enter our birthday. When we age a year, the BMR equation changes. Shouldn't this be an automatic process?

I'm running outta room in the Cardio section. Every day my jogging times and BPM changes, it seems. The amount of calories burned changes daily. The menu only allows 15 inputs.
Alright thats 2 votes for cardio enhancement. Hobbes sent sent me a similar private request a few weeks ago and he had worked up the cardio changes in xls file he sent me...
Ok, I will modify the cardio section. hobbes' suggestions for cardio included yours snotfu and then some...so I will do them all.

Minor improvement: We should have to enter our birthday. When we age a year, the BMR equation changes. Shouldn't this be an automatic process?
Point made...will do that as well.

As for the other stuff...I will look at all of it...its a little complicated so give me a some time.

Thanks for the suggestions. I hope to have the 2 changes above in the 2.04 version in a few days.

Thanks for the suggestions.

Awesome! Thank YOU.

I noticed the BMR calculation doesn't include marcus' additional math (http://forums.johnstonefitness.com/showthread.php?t=1222):
Ok, so this is done, but I couldnt decide where the activity level options belong.
1. Do the options belong on the set page where you set them once,
2. Or do they belong on the monthly menu where you set each time you create a new month or even change them every day when you key your weight, if a person so desires.
I think option 2 makes the most sense and is the most flexible, but other opinions are always helpful

Also, is the marcus stuff accurate? I had never seen it before, and I'm not knocking another man's research, but are there many people that follow this method? john's original spreadsheet did not, marco's later enhancement to that did not...should we???

Which you then subtract the amount of pounds you intend to lose a week (for ex. 2 pounds a week, means you subtract 1000 from this number).

Shouldn't this be added on top of the BMR?
Ok, so this one I really need to discuss more...using this approach now makes that new bmr a replacement for the daily caloric goal that you get by mulitplying your weight by 10-12 does it not?

And in that case is it not an issue of semantics as to which caloric goal numbers one wants to use? I dont know that I want to replace the method in place for this one...nor do I know if it is wise to have a caloric goal on the daily menu, and a different daily caloric goal on the wld page.

What do you think???

Ok, so this one I really need to discuss more...using this approach now makes that new bmr a replacement for the daily caloric goal that you get by mulitplying your weight by 10-12 does it not?

And in that case is it not an issue of semantics as to which caloric goal numbers one wants to use? I dont know that I want to replace the method in place for this one...nor do I know if it is wise to have a caloric goal on the daily menu, and a different daily caloric goal on the wld page.

What do you think???

I think the BMR is a better determinate of calories than the 10-12X. I wish we could have a choice. Note that height, age, and sex doesn't change that often, weight does. When it changes your BMR will change also.

You might have to run a poll. You have done a great job, it will be hard to satisfy us all. If you stopped now, you have produced the best thing going.

1. Do the options belong on the set page where you set them once,
2. Or do they belong on the monthly menu where you set each time you create a new month or even change them every day when you key your weight, if a person so desires.
This option belongs in the setup page, because the information will be needed daily. Also, you have to leave it customizable because a person's activity might increase or decrease at any time. I don't think anyone would be able to change this daily, but if they realize they are playing more sports this week than they did last week, they will want to change their activity figures from "sedentary" to "lightly active". Which is an increase of .175 x your dailly caloric intake.

Also, is the marcus stuff accurate?I would love for Marcus to field this, but I will try to find some relevant links and such. Basically, your BMR is what you would burn if you sat in bed all day. And since nobody at JSF is sleeping in all day, adding in the activity calculation is useful.

So far, for links I have this (http://my.webmd.com/content/article/79/96024?z=4246_00000_4026_00_11 and http://walking.about.com/cs/calories/l/blcalcalc.htm and http://www.tim-richardson.net/BodyForLife/analysis.html and http://michaelandkendra.com/BMRCALC/bmrcalc.htm which is an excel document that does the math for you, courtesy of JSF's own "taffer").

...using this approach now makes that new bmr a replacement for the daily caloric goal that you get by mulitplying your weight by 10-12 does it not?I thought the field for your Daily Caloric Intake Goal was obsolete. I always assumed the only number you used for acquiring your caloric intake was the BMR number. For example, my current weight x 10 is 2120. Wheras, my BMR is 2050. The number of calories I would be eating today would be 2050, not 2120.

However, once I multiply the extra 1.55 x my BMR, I get my real caloric intake goal: 3177.5. Then I subtract my weekly weight loss goals from this number: 3177.5 - 1000 (2 lbs a week), and I get 2177.5 calories I need to take today. Which you can see is more than 10x my weight, and 120 calories more than my current BMR (the amount the excel document tells us to consume). One you get this amount, you then calculate your 40/40/20.

The only problem I have with the acitivity math, is that it thinks I only burn an additional 120 calories a day. We know that when we workout and do some cardio we burn more than this in a day. I would ultimately like to know exactly how many calories I burned and work from that. But, that would be crazy to implement. Approximations are much easier.

And in that case is it not an issue of semantics as to which caloric goal numbers one wants to use?I want know what I am burning and calculate my intake accordingly. Some people might not think 120 calories is a significant number, considering that means about 1 more gram of protein and carbs a day. Getting the additional figures will be a boon for any perfectionist such as myself.

I cannot seem to get the XLS to accept today's date....it keeps on saying that "The oldest date you can enter is 1/1/04"

Is is broke fur good??? ;)

I would love to use it!

Thanks,
Mike

This option belongs in the setup page, because the information will be needed daily.I agree, the people need to be able to change it daily or weekly or monthly, thats why it doesnt belong on the setup page. the purpose of the program is to make entering data easy, threfore, from 1 page. once you key your data in the setup page, you should never have to go back there again. So on the monthly menu it goes. The only exception to this rule are the measurements entries...there is just no room for them on the monthly menu.

my current weight x 10 is 2120......I get 2177.5 calories I need to take today. Which you can see is more than 10x my weight, and 120 calories more than my current BMR (the amount the excel document tells us to consume).1. Realize, your bmr is not how much to consume, its how much you burn in a day if you do nothing. on the spreadsheet, its not the amount you are told to consume, it subtracts from that amount, defined as weight x 10 in this case.
2. I would like to point out that 2120 and 2177 are pretty darn close...you'd theoretically lose a little more weight if you used the x10 method.
Now those 2 things being said, I'm not picking on you, I need your help with double checking my work below. Or anyone else who would like to make any suggestions is welcome as well.

The only problem I have with the acitivity math, is that it thinks I only burn an additional 120 calories a day. I would ultimately like to know exactly how many calories I burned and work from that.
I want know what I am burning and calculate my intake accordingly. My spreadsheet tries to do just that...instead of making approximations, such as guessing at your activity level, the spreadsheet tries to give you extremely accurate calorie numbers.

On the spreadsheet, the line containing the bmr (the BURNED CALORIES line) also contains the calories burned by your daily cardio and weights routines. All of these items are added together to give you a total calories burned for the day. In the BMR field on this line, I enter the ACTUAL BMR not the modfied one....so when it adds together your BMR burned calories + your cardio + weights burned calories, you are getting a more precise number than just BMR x 1.55.

I think my thinking is sound...If anyone would care to chime in I would appreciate it.

I will be doing a final doublecheck and adding documentation on the setup page of v2.04 with ALL of the proposed suggestions and hopefully posting it within the next 24 hours.

I cannot seem to get the XLS to accept today's date....it keeps on saying that "The oldest date you can enter is 1/1/04"

Is is broke fur good??? ;)

I would love to use it!

Thanks,
Mike

I just opened it an typed in 8/17/04 followed by the enter key and it worked perfectly. when you go to key the date there is a popup window explaining exactly how it must be keyed and why.

version 2.04 has been posted in the first post of this thread.

Version 2.04 Features:
Enhancement 1: Added Marcus' enhanced BMR calculations for calculating the daily caloric intake goal. - suggestion by snotfu.
This required a major redo of the spreadsheet layout on both the menu page and the monthly menu page. While the menu section WILL copy over from old versions of this program, the daily menus' probably WILL NOT copy over well. Sorry folks...a little pain for the sake of progress.
Both the Weight or BMR method can be used. - suggestion by Rtestes

Enhancement 2: Added 2nd Cardio entry for those who do cardio splits. - suggestion by HobbesAB

Enhancement 3: Added Cardio duration. Now you can key explicit cardio (ie, HIIT for 12 minutes) or you can choose a cardio type and how many minutes performed. - suggestion by HobbesAB

Enhancement 4: Further cleaned the daily menu by removing the "Category" text in each of the menu items. The category items are now blank until you use the pulldown menu.

version 2.05 has been posted in the first post of this thread.
Bugfix: Found a small problem with clearing the "category" text in each of the menu items (enhancement in 2.04.) Blanks apparently don't work in excel, so once you choose a food item, it can be changed, but never removed. I put the category text back for now, but did shorten it to "Cat"

Hi adi -

I was attempting to use your Fitness log on Mac OSx using Microsoft Office 2004 and I get these errors:

"Compile Error: Sub or Function not Defined."
Sub Auto_Open() is highlighted in yellow and
It has "MonthName" on line 9 highlighted in blue.

Hi adi -

I was attempting to use your Fitness log on Mac OSx using Microsoft Office 2004 and I get these errors:


If you read this thread you can see that this currently does not work on a mac. If I ever find someone with a mac that I can code on I will attempt a fix. the versions of excel that it has been tested and works on are posted right above the link where you downloaded it.

version 2.06 has been posted in the first post of this thread.

Big Big changes!!!!

Version 2.06 Features:

1. Enhancement: Complete revamp of the Weights section. You can now enter 6 different lifts per day and the calories expended for each will be totalled and added to your daily calories burned.
Now anyone doing any program can enter their daily lifts...much more flexible than in previous versions.

2. Enhancement: Added Import Data from Previous version. Many have asked...and it was a major pain, but you can now import your data from any previous version.
I've tested it many times, but you never know...The code for the import is bigger than all of the other code put together, so there is always a chance that you'll find something I didn't.

3. Enhancement: Modified some of the sample data, input more of John Stone's actual data. As time permits, I plan to replace all data with John's real information from his first 5 months.

John, if I can add all of your 1st 5 months data into the spreadsheet, would you consider replacing your transformations.xls with this one? It would surely help get it into the hands of alot more people.

Wow! Sounds like an awesome update Adi. I will try this out a.s.a.p. and let you know how it goes.

I really wish more people would try this. I have been promoting it as much as possible, and I still see people struggling with their menus. The main problem is this thread hasn't been stickied. Hopefully when this thread gets bumped, it's ranking will get everyone's attention.

Nice icon :D

Great spreadsheet. It's really aiding me in my diet. I'm a numbers guy, and it's important to my success to have a strict system to operate within.

Suggestion for the next version: Add a quantity modifier to the daily menu screen. This way, you only have to add each type of food once in the menu sheet. Example: If I have a PB sandwich, I use 2 slices of bread and 2 tbsp PB. Right now, I either have to put "1 slice of bread" twice on the daily menu, or explicitly put "2 slices of bread" in the global menu. It would be great if instead the menu sheet looked like:

CATEGORY QUANTITY FOOD CALORIES ...

then I'd have:

Starch - 2 - 1 slice of bread ...
Nuts - 2 - 1oz peanut butter ...

This would also be good for things like meats, where you never get exactly a 6oz chicken breast. You could do:

Meats - 6.5 - 1oz chicken breast


This would make the global menu less cluttered (less things to scroll through in the dropdown) and save slots on the daily menu.

adi - first of all, bump for the spreadsheet - awesome work!

Next, I've recently moved to all-mac, and would be happy to do testing for you if need be... I'd love to see this spreadsheet compatible with Office 2004 on OS X.3... but I *do* fully understand the challenges of such a proposition and I do not expect you to go out of your way at all. Has the issue been you just haven't heard from folks if the more-mac-compatible version you posted had worked or not, or are you indeed hearing from them that it doesn't work? If it doesn't work, that's fine and I'll drop it so that it's not *completely* beat into the ground, but if it's a lack of response on a tester's part, I'd be happy to step in and let you know what does or does not work. :)

Thanks,
James

Good job as always. Causticmuse has a spreadsheet, everyone might want to look at:

http://maggiewang.com/bfl/WeightLossCalculator_v2.xls

version 2.07 has been posted in the first post of this thread.

Version 2.07 Features:

1. Enhancement: Extended tracking range from 6 months to 1 year.

i lost 30 pounds in 4 months and then my weight loss has completely plateaued for the past 2 months. So suffice it to say a 6 month spreadsheet will not be enough. I guess I just dont have John's willpower. Hopefully the next 6 months will be enough to get the remaining 30 pounds off....we'll see.

Wow, this thread has been viewed over 4000 times (thats more than some of the sticky pages) and the 2.06 version that I just updated to 2.07 had been downloaded 230+ times. thats great!!! I hope many people find this spreadsheet helpful.

version 2.07 has been posted in the first post of this thread.

Wow, this thread has been viewed over 4000 times (thats more than some of the sticky pages) and the 2.06 version that I just updated to 2.07 had been downloaded 230+ times. thats great!!! I hope many people find this spreadsheet helpful.

A good one made better, thanks for your efforts and sharing them.

Excellent spreadsheet! :) :tu:

It's working fine in Excel 2000. I have Office 97 at home, so I'll give that a test run when I get back there tonight.

-Maggie

Since it isn't a sticky, this topic needs to be bumped for newbies.

thanks rtestes...

i do a lot of searches on these pages so I don't ask the same question that has already been answered a bunch of times, but it's posts like this that are hard to find...but very useful.

Bloody hell, this is the first time I've come across this thread. I dont know how I missed it :p I think I need to browse the boards more throughly in the future. I'm glad it was made a sticky.

Outstanding work Adi, It sure makes things a lot easier. I'm gonna link to this in my nutrition sticky and the links sticky.

Cheers :tu:

Marcus

Bloody hell, this is the first time I've come across this thread. I dont know how I missed it :p

Same here - I saw this thread for the first time in a long, long time today and said "this is sticky material!" Then I saw several people asking for it to be made a sticky (assuming I'd see the posts) but no one ever thought to PM me about it. :p

Anyway, it's a well-deserved sticky now. What an awesome spreadsheet! Excellent work, adi! :)

Yea, cheers for the spreadsheet it's awesome (and for the sticky, never would have found it otherwise!)

Thanks for the spreadsheet!
I am running Suse Linux with Open Office as my spreadsheet program. Your excel file works great with Open Office and Gnumeric (another Linux based spreadsheet program).

Just spent 2 hours reading this thread. Your dedication is amazing Adi, thanks for all your hard work. Can't wait to get on my PC and give the spreadsheet a try (currently on my mac).

I really like this program. I'm finally down to 229 and just adjusted it to lose 2 pounds a week. I'm 6'4" and used to weigh 265, then got to 250, then found JSF and started reading. I then decided to get serious, clean diet, max-ot, and fasted cardio. I feel great, my wife likes the progress, even my little ones like to watch and imitate. Great program.

Sean

i must be doing something wrong. when i open it, it looks nothing like the sceenshot. i keep getting messages saying macros not enabled. i shure would like to try this. thanks!....TreeSlayer

i must be doing something wrong. when i open it, it looks nothing like the sceenshot. i keep getting messages saying macros not enabled. i shure would like to try this. thanks!....TreeSlayer

Hey TreeSlayer, just saw your private msg and responded. Please include your OS and Excel version. After I get that I should be able to tell you how to enable macros in that version.

Hey TreeSlayer, just saw your private msg and responded. Please include your OS and Excel version. After I get that I should be able to tell you how to enable macros in that version.
Thanks, Adi! i'm on XP home and Excel 2000

So, I havent been by here in couple months. There had been no updates to this thread since december and it was falling further and further down the list...I was a little dissapointed that even though the only thread that had more views was the "all the whey" sticky thread, this thread was being outpaced by other stuff.

I show up today and I can't find this article at all...I keep scrolling down the list further and further, on to the next pages, and still cant find it. I think "they must have decided it was too old or no longer useful and deleted it." And then I see it...its the VERY FIRST article...and a STICKY!!!

:jumping: WOW, its really uplifting that others find my contributions useful and meaningful. Thank you all for all the kind words. Making this spreadsheet was a long personal journey for me. While I was writing it, I was adopting the John Stone lifestyle and using this spreadsheet to help motivate and keep me honest. Its been a tought battle, the first 30 pounds fell off easily in 4 months, then came the plateau. The next 4 months had me hovering between 190 and 195. Then last month I suddenly added about 5 pounds back...and no, its not muscle. So now I'm between 195 and 200 and it doesn't feel good. The goal is 160, and now I've got 35-40 pounds to go instead of 30.

But today has been a great day for me!! I see that others are using and enjoying my work, and it has motivated me to buckle down and get back on track. :bb:

:bow: Thanks to you all, for the suggestions and great compliments. Special thanks to those here from the beginning like Hobbes and Snotfu and Walcrawlr for all of your suggestions. And I cant leave out Rtestes, whos always lurking around, for the compliments, suggestions, sticky recommendations, and the occasional bump.

You are all great...this is a wonderful forum filled with great people. You've all really inspired me today. :D

Thanks, Adi! i'm on XP home and Excel 2000

In excel, goto tools, macro, security

change it from high to medium...with this setting you will have to enable macros every day when you open the spreadsheet. this is how I have it set.

you can change it to low, but only if you are very sure of your virus scanner.

Thanks for the spreadsheet!
I am running Suse Linux with Open Office as my spreadsheet program. Your excel file works great with Open Office and Gnumeric (another Linux based spreadsheet program).

Thanks for the info Irongrl! I will add Open Office and Gnumeric to the list of working versions. I wouldn't have though either of those apps would support the VBA code in the macros. Given the problems mac office seems to have, I'm glad to know that it works under linux. btw...do you know the version of either of those apps?

In excel, goto tools, macro, security

change it from high to medium...with this setting you will have to enable macros every day when you open the spreadsheet. this is how I have it set.

you can change it to low, but only if you are very sure of your virus scanner.
Outstanding! Works just fine now. :tu: I can't wait to get started. Thanks again, and I'll keep ya posted. :nod:

Well now that I can see Adi is still around, I want to say a few things. First, I am very glad this has been stickied. Well deserved. This spreadsheet is enough to keep people on a healthy path all by itself. I use it EVERY day and have been since July 14, 2004. Everyone needs to download and use this.

Now for the bugs:
I have found that the document does not go infinite. You cannot add any more days after the 186th day. I went from 7/14/04 to 1/16/05. I had to save the old document and start fresh. This is not a big deal, but you cannot track overall progress. Looks like 2.07 bumps this to 1 year of logs, even though I cannot get it to import data from v 2.06.

From the 1st to the 9th of every month, you have to edit the date on the "Setup" tab to match the current day. It does not acknowledge single digit dates. Says something like "the day does not exist". You can fix this error by setting the setup date to match the current day such as "3/6/05" to create a new day for the 6th, inputting whatever data is needed for the day, and then going back and editing the original start date back to the original date.

It would be nice to be able to customize the "Master Daily Menu" portion on the "Menu" tab. Like being able to delete or add a row.



Do not let any of these problems stop new users from trying this out. This document is perfect for logging your progress. Thanks in advance to Adi if he continues to improve this.

I know that the Fitness Log v2.07 was not created for Execl 97 but when I open it works except for a few bugs that I was hoping I coudl get some help with. When I open it I get a Visual Basic Error saying "Complie Error Sub or Fucntion not defined". After I close Visual Basic and try to reset the form VB opens up again and I get the same error in the reset everything macro. The macro initially reads like this
Sheets(MonthName(Month(Now), True) & " '" & Right(Year(Now), 2)).Delete
and then after anding in some parentheses and changing some things
the line looks like this
Sheets(MonthName)(Month(Now), True) = " '" & Right(Year(Now), 2).Delete
And I am able to reset the spreadsheet but the sample month sheet disappears and I am not able to get it back so I can get my daily menus.

Adi,
Can't wait to use this spreadsheet. It looks awesome.
I have encountered 1 glitch.

I am entering my date on the main page as 3/8/05, along with all of the other required information.

Then, I go to Create Todays Menu, enter my weight today, and click the create todays menu button.

I get a whoops! box: Todays date 03/08/2005, does not match any date on the WL sheet, column D.....

If I go to the WL sheet, I see the appropriate date there.

I am guessing this is one of those 'duh' moments, but I cannot figure it out.
Can you help?

SF, nice to see you again...with problems like you describe below I am amazed that you are able to use the thing at all...I'd never use it if it was that screwed up. I think your copy is corrupted.
All of the bugs you have dont exist in my copy...I use it every day and have never had to change anyhing on any screen. I only add my weight and food every day...nothing else...and mine is into the 9th month...well past the 186th day. Having said that (so as to let others reading this know its ok and works better than that) lets address your issues each in turn.

I have found that the document does not go infinite. You cannot add any more days after the 186th day. I went from 7/14/04 to 1/16/05. I had to save the old document and start fresh. This is not a big deal, but you cannot track overall progress. looks like 2.07 bumps this to 1 year of logs.
Correct, until v 2.07 it was only good for 6 months...of course the very first line on the very first page (the setup page) does say 6 months).
yes v2.07 extends it to 1 year, but no longer than that. If there is a desire, I will extend it further, but the spreadsheet is getting so long on the weight loss data page its not pleasant to scroll thru it.

I cannot get it to import data from v 2.06.
I test each version by upgrading my own previous spreadsheet....so I am running 2.07 and it is an import from my own 2.06, so it worked for me...if you have your old 2.06, maybe you can send it to me and I can try upgrading it myself...send me a pm if you like. Maybe I can import your 2.07 into a clean 2.07 and see if that works better.


From the 1st to the 9th of every month, you have to edit the date on the "Setup" tab to match the current day. It does not acknowledge single digit dates. Says something like "the day does not exist". You can fix this error by setting the setup date to match the current day such as "3/6/05" to create a new day for the 6th, inputting whatever data is needed for the day, and then going back and editing the original start date back to the original date.
What the heck is that all about...I'd spit fire if I had to do that every month....I have never had to go to the setup page again after my intial setup and import of 2.06. I cant imagine anyone else is having that problem either or there would have been complaints aplenty ever since I posted 2.07...or then again maybe no one is using it....:)

My guess is that "somehow" (no offense intended) the formatting got changed on one of the cells or columns...feel free to pm me a copy of your 2.07 and I'll look at that too.

It would be nice to be able to customize the "Master Daily Menu" portion on the "Menu" tab. Like being able to delete or add a row.

Tough luck on this one...youre not the first to ask, but its excel, and if you change that screen the spreadsheet will never work again...Sorry.

Dee, this is probably going to end in tears, but lets give it a try anyway.
The problem I have found is that older versions of excel dont support alot of the calls/vba that 2000/2003 support...so this might be a lost cause. I had to rewrite major portions just to make it work with excel 2000.

I know that the Fitness Log v2.07 was not created for Execl 97 but when I open it works except for a few bugs that I was hoping I coudl get some help with. When I open it I get a Visual Basic Error saying "Complie Error Sub or Fucntion not defined". After I close Visual Basic and try to reset the form VB opens up again and I get the same error in the reset everything macro. The macro initially reads like this
Sheets(MonthName(Month(Now), True) & " '" & Right(Year(Now), 2)).Delete
and then after anding in some parentheses and changing some things
the line looks like this
Sheets(MonthName)(Month(Now), True) = " '" & Right(Year(Now), 2).Delete
So you changed some parens around and got past the issue above...nice...just realize that the code you modified sets the name of the sheet to the current month and year...if the mod you made changes the syntax of the name in any way...other stuff will likely fail....but nicely done nonetheless.
And I am able to reset the spreadsheet but the sample month sheet disappears and I am not able to get it back so I can get my daily menus.
When you reset the spreadsheet, the sample month is deleted. thats by design. then you fill in your 5 pieces of data and choose, new month and a new one (with the current month/year) is created for you....its blank, except for the first 10 lines (just like the section in black that was at the top of the sample page) where you key your daily info before pressing the create todays menu button.
Is it possible the stuff changed above has caused it not the create a menu for the new month?

Told you it would end in tears...you know, everyone and their brother has a copy of office 2000, xp or 2003 that you might be able to borrow...:)

Adi,
I get a whoops! box: Todays date 03/08/2005, does not match any date on the WL sheet, column D.....

If I go to the WL sheet, I see the appropriate date there.
Can you help?

Well, thats a new one. today is 3/8 and I keyed my weight this morning and it worked fine. But based on what you've written above, it seems like you're doing everything correctly. pm me and send me your copy and I'll take a look...this might be a new bug.

I am kinda new here, but I decided to de-lurk and say this thing is amazing! I love it! I can't wait to incorporate it into my current challenge! I am sure it will help out immensely! :D

~Stacey

Excellent work, Adi!!! I am putting this to the test tomorrow. I think it will help me out a lot as far as getting back on track.

One suggestion for future versions is maybe to have some sort of a confirmation when you hit the "Reset Spreadsheet" button. Right now, you click it, and all is gone.

I am looking to use your spreadsheet, however, I am noticing a "problem", unless I am missing something. What happens if I want to add more foods/excercises than you have space for. For example, right now, there is no space left to add a Chest/Pecs excercise. Is there a way around this? I only ask because I know for a fact that I will have many more foods logged, then you have room for.

Also, are we limited to only adding two fodds per timeslot?

The following is a bit of paraphrasing from a previous snotfu post. I will use it to create some decent import instructions to help anyone who might be trying to import from a previous version.
1. I cannot get 2.07 to import data from v 2.06.
OK, snotfu, you sent me your last 2 spreadsheets. both were version 2.06. 1 was for june thru december last year and the other was for january to march this year. Sadly you cannot import 2 old spreadsheets into 1 new one, so the best I could do is import your latest one into the new 2.07 version. Here's what I did.
1. rename the old one (the one you are currently using) to anything other than fitness log.xls. I chose fitness fitness log-old.xls.
2. close it...make sure fitness log-old.xls is closed.
3. open the newly downloaded 2.07 version of fintess log.xls
4. on the setup page:
a. do a reset
b. fill in the 5 personal items (just copy exactly what is in fitness log-old)
c. make sure fitness log-old is closed.
d. run the import.
5. during import:
a. the first thing import will do is pop up a file window.
b. locate the fitness log-old.xls file and open it
c. the import will then run, importing data from fitness log-old to the new fitness log.
d. you will see lots of stuff happening on the screen...things will jump around all over the place...pretend its a fireworks display and enjoy the show.
e. if during the import any messages about categories pop-up, click OK on them..
6. once import is done, a message will popup telling you that both files are being closed. click OK.
7. open your newly imported fitness log.xls and check for any errors or missing data...hopefully there will be none...I've never had any.

Thats it. I successfully imported your current 2.06 into 2.07 with no issues whatsoever.



2. From the 1st to the 9th of every month, you have to edit the date on the "Setup" tab to match the current day. It does not acknowledge single digit dates. Says something like "the day does not exist". You can fix this error by setting the setup date to match the current day such as "3/6/05" to create a new day for the 6th, inputting whatever data is needed for the day, and then going back and editing the original start date back to the original date.


I figured this out but cant explain it. Using the v2.06 you sent me I changed my system date to 3/2/2005 and added today weight. when I clicked "create todays menu" I got an error saying that the date 3/2/2005 does not match anything in the wld page column D. I checked an on the wld page column D there is no 3/2/2005. there is however a 3/02/2005...so this all boils down to a difference between m/d/yy and m/dd/yy. Somehow the format of that column got screwed up in your copy. Rest assured the v2.06 and 2.07 I have on my system do not have this issue. I'm sorry you had this problem...excel is only as good as microsoft makes it. Please download a nice new copy of 2.07 and import your data like I detail above and lets hope you never see this problem again.

I am kinda new here, but I decided to de-lurk and say this thing is amazing! I love it! I can't wait to incorporate it into my current challenge! I am sure it will help out immensely! :D

~Stacey

Stacey, thank you for the kind words...they are greatly appreciated:)

One suggestion for future versions is maybe to have some sort of a confirmation when you hit the "Reset Spreadsheet" button. Right now, you click it, and all is gone.
Thanks. I never bothered with a confirm, because you usually dont go to the setup more than once....but the suggestion has merit and I will add it to the next version.
I am looking to use your spreadsheet, however, I am noticing a "problem", unless I am missing something. What happens if I want to add more foods/excercises than you have space for. For example, right now, there is no space left to add a Chest/Pecs excercise. Is there a way around this? I only ask because I know for a fact that I will have many more foods logged, then you have room for.Sadly, no, you cannot modify the menu pages. they are what they are. Its been downloaded 700 times and you're the first to ask. increasing the ranges would not be a massive change, but it would make the spreadsheet extremely long and hard to get thru. its already too long and even I find it annoying to constantly scroll up and down...but excel, what can you do.
If more folks ask for this I will do it, but for now my preference is to leave it as is in regard to this...sorry.

Can anyone who is computer savy PLEASE configure this for Mac OS X. I have microsoft excel but there is a porblem with something called macros

Can anyone who is computer savy PLEASE configure this for Mac OS X. I have microsoft excel but there is a porblem with something called macros

Good Timing Erik. I think I stumbled across the fix for the macintosh problems. But before I post it and prove myself a liar I need a volunteer to test it out. I'm lookin for someone who will:
1. be willing to run thru every button this application has and email me any screenprints of errors recieved.
2. be willing to do this back and forth several times if necessary as I work thru any new bugs.
3. be able to email me back and forth in a timely manner, say within 24 hours. previous macintosh volunteers either never emailed me back or were very slow in responding (weeks.)

So if anyone is willing, reply back here...I only need 1 volunteer, so whoever replies back first will be my tester. If I need more volunteers in future I will ask again..for now just 1.

Also be sure you are running mac office 2004...Im not prepared to test anything older yet. I want to get it running under the newest version of excel first and then work back if I can.

Adi, your use of the macros in this excel sheet is great! You are the man! I created something like with drop down menus and such but no where near as good as this!

Thanks again!

version 2.08 has been posted in the first post of this thread.

Version 2.08 Features:

Enhancement: Added a confirmation to the "Reset Spreadsheet" button.
Enhancement: More detailed instructions for the import function.
Enhancement: Office 2004 for ;) macintosh OSX support. Some fonts are a litte small on the mac, but it works without errors.
Enhancement: If Importing from v2.04 or newer, the "current month(imported)" sheet is now incorporated added to the bottom of the "current month" sheet. No more duplicate sheets for the current month.

Bugfix: Found an issue with importing old monthly menus. Would only import current year. Now will import the last 36 months worth of old monthly menus.
Bugfix: Import would sometimes cause errors by leaving references to the old spreadsheet. A message would display every time the new file was opened referencing a linked sheet. This is fixed.
Bugfix: "The date x/x/xxxx does not exist on column D of the WL Data page" should now be fixed. Appears to have been a cell formatting issue. Old format was *3/14/2001, new format is 3/14/2001.
Wow, since becoming a sticky, version 2.07 was downloaded almost 1000 times...Amazing!!!:claphigh:

Works perfect! Thank you for all the hard work Adi.

If anyone is hesitating because they think this is too complicated or not going to work, you can stop now. Download 2.08 and get started today.

This document will make tracking your weight loss/gain progress so simple that you can focus 100% on the physical side, instead of mulling over figures and numbers. There is simply no better way to keep track of your daily menu and exercise routine.

Thanks for the info Irongrl! I will add Open Office and Gnumeric to the list of working versions. I wouldn't have though either of those apps would support the VBA code in the macros. Given the problems mac office seems to have, I'm glad to know that it works under linux. btw...do you know the version of either of those apps?

I just downloaded your spreadsheet, and opened it up in OpenOffice 1.1.0, which is installed at my work. I am quite unfamiliar with OpenOffice, so I'm not sure how to get the buttons to work. Is there a setting somewhere to enable the form elements (like buttons)? Thanks for any help on this! ~ Alan

When I click on the "Create New Month" tab in step four it gives me an error message. "Macros in this workbook are disabled because the security level is high, and the Macros have not been digitally signed or verified as safe."

Just wondering if you know how to correct this.

Thanks for this by the way, I am trying to lose weight for wrestling SAFELY so that I can be more competitive next year.

Thanks for all the work you put into this.

When I click on the "Create New Month" tab in step four it gives me an error message. "Macros in this workbook are disabled because the security level is high, and the Macros have not been digitally signed or verified as safe."

Just wondering if you know how to correct this.

Thanks for this by the way, I am trying to lose weight for wrestling SAFELY so that I can be more competitive next year.

Thanks for all the work you put into this.

In Excel, go to Tools --> Macro --> Security...
Select "Medium" and click Ok
Close Excel and reopen the spreadsheet.

I did that and it is working for me now. Thanks

One more thing, on the Weight Loss Data chart. I found out what my Body fat percent is but I don't know how to input it into the blank space in the info section on the current statistics. I also want to know how to put in how much is lean muscle and how much is fat mass. Does it do this automatically once you enter your measurements,(I have)? Or do you enter it?

Thanks.

--Xander

Curious, I recently ran across this Excel Spreadsheet and I have a MAc running OSX 10.3.9. I am able to open the file and enter info in but when I save it and then try to reopen the saved file, it shuts down my Excel software. Got any ideas? Thanks!

One more thing, on the Weight Loss Data chart. I found out what my Body fat percent is but I don't know how to input it into the blank space in the info section on the current statistics.
--Xander

BFP is covered in the instructions on the setup page. BFP is entered on the current month page (ie, the Jun '05 page) right under the weight...just put in the %age without the % sign. so 15, 20, 25, etc. You can enter it as often as every day or whenever you feel like it...the WLD page gets update automatically.

just downloaded it adi, just cant get it working it says something about needing a security sig or the setting is to high so i lowered it to med then low and still not working...whats there to do mate?
thanks :confused:

So I was trying out the spreadsheet and I now have Three versions of June 10. How do I delete the two that I don't need?

Thanks. I never bothered with a confirm, because you usually dont go to the setup more than once....but the suggestion has merit and I will add it to the next version.
Sadly, no, you cannot modify the menu pages. they are what they are. Its been downloaded 700 times and you're the first to ask. increasing the ranges would not be a massive change, but it would make the spreadsheet extremely long and hard to get thru. its already too long and even I find it annoying to constantly scroll up and down...but excel, what can you do.
If more folks ask for this I will do it, but for now my preference is to leave it as is in regard to this...sorry.
So you'll be rolling out that customized web app...........when???

:D

Ho my God! This Thread is Amazing, this is the fist time i see IT!!!

This program will save me a lot of time!! :claplow:


I really don´t know how i miss this thread!!!


Thanks Men this is GreaT!!!

I am looking to use your spreadsheet, however, I am noticing a "problem", unless I am missing something. What happens if I want to add more foods/excercises than you have space for. For example, right now, there is no space left to add a Chest/Pecs excercise. Is there a way around this? I only ask because I know for a fact that I will have many more foods logged, then you have room for.

Also, are we limited to only adding two fodds per timeslot?

Yeah this is bugging me as well, I cant insert any new rows for my foods, anyone know how to fix this?

How do i get the buttons to work in openoffice?

I'm having trouble opening th file. I have office with all the latest updates, however I am on a mac. I have the latest OSX 10.4. It goes to open it then after enabling macros it stops then goes to microsoft error reporting. Eh...the life of a mac user.

How can I save the spreadsheet as a webpage? It says it's password protected.

As was stated before by others...

Wow. This is a great tool. It sure beats the things I had cooked up, and makes meals. calories, etc alot easier to keep track of.

Thanks.

Feature Request:

Can you set up the daily menu with quantities? IE I put in one base unit in the food menu, then in the daily menu i insert a quantity.

Say i eat 3 eggs, instead of putting an egg in the daily menu 3 times, there is a quantity button next to eggs that multiplies the values by 3.

Feature Request:

Can you set up the daily menu with quantities? IE I put in one base unit in the food menu, then in the daily menu i insert a quantity.

Say i eat 3 eggs, instead of putting an egg in the daily menu 3 times, there is a quantity button next to eggs that multiplies the values by 3.

I'm actually working on that right now.

First i want to thank you for making this excel sheet... it has been a ton of help in organizing my diet. But i seem to have a problem... When i try to use it on my mac os x 10.4.3, excel version 11.2 it crashes.... any suggestions for fixing this? I would really like to us it on my mac (so i can perfect my diet during class :whistle: )...Thanks
Cheers,
Joe

Really nice.
Congrats for the good work.

I am running on Win XP, Microsoft Office 2003.
I have a little problem though, I cannot dial in my DOB (07/17/78), it pulls up a message saying that the oldest date I can enter is 01/01/1900...I'm not that old lol

nevermind, got it worked out, just had to enter it as D/M/Y, instead of M/D/Y

As a note this works in open office as someone stated, but open office is not a linux only program it is availible for windows and maybe mac even(since its written in java). It is a free replacement for word/excel/powerpoint. www.openoffice.org for anyone who wants it. Anyhow thanks agai nfor writing this :tu:

the buttons don't seem to work in openoffice for windows xp.

Feature Request:

Can you set up the daily menu with quantities? IE I put in one base unit in the food menu, then in the daily menu i insert a quantity.

Say i eat 3 eggs, instead of putting an egg in the daily menu 3 times, there is a quantity button next to eggs that multiplies the values by 3.

I agree this would be extremely helpful and save menu space

Adi,

Quick question, how did you come up with the aerobic values on the exercise menu. If I go to think muscle and use the calculator and input my weight and say 30 minutes or so????? I just cant figure out how you come up with the values that you come up with!

And thanks by the way for the spreadsheet, you will make my life as well as others a heck of a lot easier!!

Thx,
ZD

I no longer remember where I got my information for the exercise section. I think it was a member in a previous post in this thread that suggested I add the excercise section and he pointed me to the info, so it might be in a prior thread.

of course the calorie and description fields are are merely a sample, based on my workout. They are freely editable.

marcus' equations for BMR are give, but it doesnt seem like they are used. i select the BMR method, and have entered my stats (5'10", 175lbs, 20 years, M, and at least cat 3 exercise. This gives me 1272 as my BMR, but if i use marcus' equations, i get a much higher value.

am i not undersanding this right, or is your bmr method different from his?

Adi thanks for creating the Excel log. This should help me keep track of my meals every day.

I am using Excel 2007 and I haven't had any problems yet.

Thanks again

I have tested this spreadsheet in Excel 2007 on a Windows Vista Enterprise machine, and it performs flawlessly.

Thanks!

I agree this would be extremely helpful and save menu space
Definitely a good idea. I'd also like to see the menu items changed to reflect such a change. Put in the nutritional information for 1-cup of Skim milk, and just input .5 for half a cup.

great spreadsheet! thanks!

This is awesome. It blows my spreadsheet out of the water.

Should it take into account "net carbs"? Technically this wouldn't be technically correct, but should I deduct fiber grams from carbs? For Column L cells, type in =x-Mr, where x is # of carb grams and r is the row #?

Hello,

This is a great spreadsheet. I'd like to be able to track cholesterol and sodium. I read through the posts and at one time you were talking about adding those fields or how can I add those?

Thanks

Thank you for this excellent tool! It blows mine away.

I seem to be having some trouble. I have opened the spreadsheet and viewed all of the sample data successfully but when I go to start my own spreadsheet I am having trouble. I can reset the data, enter my name, enter the date (m/d/yy) and when I click out of the date field the spreadsheet locks up on me. The first page goes transparent and I can see the cells from the other pages scattered around the screen. I am using Excel 2003 and I do choose to enable the macros when the spreadsheet opens. I am doing something stupid???

Thanks for your help, this tool looks fantastic!

JW

EDIT: OK, I was wrong, it does not lock up. The spreadsheet does have some sort of graphics issue once I tab out of "start date" but it allows me to keep entering data. I navigated to a different tab and then back to the setup tab and the graphic issue seemed to go away. I will let you know if I have any further issues. Thanks for the spreadsheet!