Total workouts completed today

People in the gym at today's peak

People working out now

More statistics
Message Boards

Simple Fitness. Simple Eating. Fast Results.

Message Boards

Whether you're seeking expert advice or looking for peer support, you'll find helpful and knowledgeable friends on the Message Boards 24 hours a day. 

 

How to post photos in your Message Board threads:


Threads [ Previous | Next ]
Carb and calorie cycling calculator
Showing 20 results.
Carb and calorie cycling calculator
body fat analysis body fat calculator
12/23/10 8:53 AM
Ok I think I have put the final touches on the calculator I have been playing around with and am putting it here for you to check it out and play with.

Edit: I am no longer putting up the calculator and if interested you can contact me here. I took out the links to my Facebook Fan Page and Paypal but refuse to take my email address out.
----
Attachment

Attachments: UDC.png (34.3k)
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/11/10 6:15 PM as a reply to JCFitCoach.
Nice looking calculator John. I like the weekly re-feed day.

Question, Seems like the "R" (rest) days assume the 500 calories (or whatever is input for workout expenditure) is still being incurred?
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/11/10 7:01 PM as a reply to KailuaDude.
KailuaDude:
Nice looking calculator John. I like the weekly re-feed day.

Question, Seems like the "R" (rest) days assume the 500 calories (or whatever is input for workout expenditure) is still being incurred?


KD,

Thanks. You won't see it change on the daily calories unless you use the maintain feature. All others the calories stay the same but the loss/gain number will go up or down based on number of rest days.

If you pick say Lose weight and you change number of rest days you will see it affect that number up or down.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 10:07 AM as a reply to JCFitCoach.
nice calculator john,

Couple points

The ratios isn't clear what they are, I assume it is FAT, CARBS, Protein?, but the table below shows protein, carbs, fat?

Also, in the GRAPHIC which shows daily deficit for seven days, my SCALE is NEGATIVE 10000, to positive 10000. Maybe, it should be set to 4500 top to bottom, or scalable easily. I think the grahpic is locked, so one needs to unlock to edit. Not a bit deal, but reading the graph doesn't make much sense with 10K thresholds.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/22/10 11:46 AM as a reply to tivoboy.
tivoboy:
nice calculator john,

Couple points

The ratios isn't clear what they are, I assume it is FAT, CARBS, Protein?, but the table below shows protein, carbs, fat?

Also, in the GRAPHIC which shows daily deficit for seven days, my SCALE is NEGATIVE 10000, to positive 10000. Maybe, it should be set to 4500 top to bottom, or scalable easily. I think the grahpic is locked, so one needs to unlock to edit. Not a bit deal, but reading the graph doesn't make much sense with 10K thresholds.


Tivo,

Each nutrient is clearly marked and color coded. Not sure what you mean by scale is negative 10000 to positive 10000. The graph is not locked and is based on daily calories.

No the are Protein/Carbs/Fats just like the order listed. If you look at the image below you will see that graph is based on the highest number of 4200 rounded to 5000 which becomes the top and bottom range of 5000 to - 5000. The only way the graph would show 10000 would be if daily calories were that high.

-----
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 10:45 AM as a reply to tivoboy.
tivoboy:
nice calculator john,

Couple points

The ratios isn't clear what they are, I assume it is FAT, CARBS, Protein?, but the table below shows protein, carbs, fat?

Also, in the GRAPHIC which shows daily deficit for seven days, my SCALE is NEGATIVE 10000, to positive 10000. Maybe, it should be set to 4500 top to bottom, or scalable easily. I think the grahpic is locked, so one needs to unlock to edit. Not a bit deal, but reading the graph doesn't make much sense with 10K thresholds.


Tivo,

Check your input for calories burned from exercise as only way for graph to say 10000 range would be if your calories burned are wrong. I had to enter 6000 for graph to show that range. Maybe when you entered 600 you added an extra zero and it became 6000.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 12:49 PM as a reply to JCFitCoach.
Just wanted to give some tips on how to use the calculator as it seems some are confused.

I tried to make it as easy as possible but sometimes it can be confusing.

I locked the spreadsheet with exception of the cells that need input from you so as to avoid any formulas from being erased by mistake.

Gender, daily activity burn and your goal are selected using the drop-down box. Age, height, weight and body fat is inputed using the appropriate yellow box. Any cell that is yellow means you can input info into it. Underneath the days of the week you will put an R for rest day and leave blank if you are working out.

That is it and the rest is done by calculations.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/22/10 11:48 AM as a reply to JCFitCoach.
John, hopefully, (although it appears to be the case) you haven't taken my comments as criticism. Wasn't meant to be. That's why I said, NICE SPREADSHEET.

that being said, I don't see where the macros are COLOR CODED with respect to what they are? Maybe in the GRAPH do you mean, in that case, the scale on the one I downloaded is totally off and NO it isn't from putting the wrong input in. Mine goes from -10K to +10k, so doesn't help. I can't seem to change the scale even AFTER unlocking. (must be the 30 years of spreadsheet experience getting me rusty)

Here's a snapshot of what I am SEEING

(just one other point. Is dietary FAT really supposed to be the highest percentage of daily intake EVERYDAY then?)

?
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 1:36 PM as a reply to tivoboy.
tivoboy:
John, hopefully, (although it appears to be the case) you have taken my comments as criticism. Wasn't meant to be. That's why I said, NICE SPREADSHEET.

that being said, I don't see where the macros are COLOR CODED with respect to what they are? Maybe in the GRAPH do you mean, in that case, the scale on the one I downloaded is totally off and NO it isn't from putting the wrong input in. Mine goes from -10K to +10k, so doesn't help. I can't seem to change the scale even AFTER unlocking. (must be the 30 years of spreadsheet experience getting me rusty)

Here's a snapshot of what I am SEEING.


Nope I didn't take comments as criticism and am glad you posted as I am not sure why yours is doing that. try downloading the new one I put up.

I will make adjustment on that day is very high as that day was supposed to be a 1200 calorie day as it was done for a friend.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 3:16 PM as a reply to tivoboy.
Tivo,

What did you mean by you unlocked it? The spreadsheet requires a password to unlock it so not sure how you unlocked it. You know something I don't? LOL
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 3:27 PM as a reply to JCFitCoach.
johncab:
Tivo,

What did you mean by you unlocked it? The spreadsheet requires a password to unlock it so not sure how you unlocked it. You know something I don't? LOL


Indeed,

as I said, I've been doing this a while now. :-)
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 5:28 PM as a reply to tivoboy.
tivoboy:
johncab:
Tivo,

What did you mean by you unlocked it? The spreadsheet requires a password to unlock it so not sure how you unlocked it. You know something I don't? LOL


Indeed,

as I said, I've been doing this a while now. :-)


Hey I have been using spreadsheets since symphony but am not aware of how to unlock a password protected spreadsheet. You using some kind of software?
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 5:54 PM as a reply to JCFitCoach.
I think he's surfing on your computer right now John! LOL. Better hide those online bank accounts.

He's probably got one of those password busters.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 6:12 PM as a reply to JCFitCoach.
yes, it's software. Sometimes it just strips it, sometimes it actually presents it. I haven't found much rhyme or reason why not.

But, when you work in spreadsheets A LOT, across many companies, colleagues, regions of the world, etc., one really HAS to come up with a way to get into the spreadsheet, or unencrypt it, or one can be sitting around for a while waiting for people to be found, wake up, come off safari, get down from Everest, what have you.

:-)

lookup excel password crack with the goog and you'll find many options. My personal favourite is from the Ukraine. Those math wizzes really come up with the fashizzle.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/12/10 6:29 PM as a reply to KailuaDude.
KailuaDude:
I think he's surfing on your computer right now John! LOL. Better hide those online bank accounts.

He's probably got one of those password busters.



LOL I found a VBA script that you add to sheet and it unlocks it, Darn hackers. KD, my accounts are empty LOL
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/13/10 2:06 AM as a reply to JCFitCoach.
Nice spreadsheet john. Yep, I had taken a look at the protected area already as well. Definitely never use any account passwords to protect an excel spreadsheet...or anything you put in the public domain as it will be broken by simple and easy to use scripts! emoticon

That out of the way...

Nice calculator!

I really like how it does rearrange how many calories are being taken in...and what proportions of carbs/protein/fat.

I'm curious what the figures (ie, amount of calories and proportions) are based on.

For example, I was really curious that during 'muscle gaining' there is a higher proportion of protein intake than during 'maintaining'...which is what one woudl expect. But, I didn't expect the proportion of carbs to be so much higher on 'rest days'. Is there any literature to support not continuing with the higher protein even on rest days...indeed, isn't it even most important on these days when muscle is being built?

Second, when 'maintaining' the proportion of carbs really goes up...and the proportion of fat generally seems a bit high at times. Again, is there evidence to back these up?

Just curious really... as it saves me the work!

Thanks again for the calendar! I'm thinking of starting calorie cycling and this is a great place to start (though I might do a bit of research and alter the proportions a bit! emoticon )
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/13/10 12:21 PM as a reply to Specialized.
Specialized:
Nice spreadsheet john. Yep, I had taken a look at the protected area already as well. Definitely never use any account passwords to protect an excel spreadsheet...or anything you put in the public domain as it will be broken by simple and easy to use scripts! emoticon

That out of the way...

Nice calculator!

I really like how it does rearrange how many calories are being taken in...and what proportions of carbs/protein/fat.

I'm curious what the figures (ie, amount of calories and proportions) are based on.

For example, I was really curious that during 'muscle gaining' there is a higher proportion of protein intake than during 'maintaining'...which is what one woudl expect. But, I didn't expect the proportion of carbs to be so much higher on 'rest days'. Is there any literature to support not continuing with the higher protein even on rest days...indeed, isn't it even most important on these days when muscle is being built?

Second, when 'maintaining' the proportion of carbs really goes up...and the proportion of fat generally seems a bit high at times. Again, is there evidence to back these up?

Just curious really... as it saves me the work!

Thanks again for the calendar! I'm thinking of starting calorie cycling and this is a great place to start (though I might do a bit of research and alter the proportions a bit! emoticon )


Yeah I only locked it to avoid having cells with formulas accidentally erased.

I will try to see if I can answer your questions as best I can based on what I have read or tried.

I am using 1.1 grams of protein on rest days and 1.5 on workout days. even on rest days I feel 1.1 will be more than enough for repair and growth.

Personally I would have carbs under 100 grams with exception of Carb load days but I know folks would complain its to much fat so I have tried to keep it under 30% most days.

What I have tried to do is a balance and not go to extremes on carbs except on the extreme weight loss option.

If you tweak it let me know what you tweak. This is not based on any research per say just trying to keep carbs under control.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/22/10 11:47 AM as a reply to JCFitCoach.
Jon -

If you want to re-post that spreadsheet without the link and paypal plug, that would be great. Otherwise, it's WAY inappropriate and I'm surprised you did that, given your history here.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/23/10 8:21 AM as a reply to AdStaffDenis.
bbadvicestaff:
Jon -

If you want to re-post that spreadsheet without the link and paypal plug, that would be great. Otherwise, it's WAY inappropriate and I'm surprised you did that, given your history here.


The link is to face book and not a site selling anything and its a donation not a mandatory requirement. I have done as requested.
Report Post Report Post
?
RE: Carb and calorie cycling calculator
12/23/10 8:22 AM as a reply to JCFitCoach.
Nice try. Take your email address off.
Report Post Report Post
?
Showing 20 results.