CrossFit Discussion Board  

Go Back   CrossFit Discussion Board > CrossFit Forum > Nutrition
CrossFit Home Forum Site Rules CrossFit FAQ Search Today's Posts Mark Forums Read

Nutrition Diet, supplements, weightloss, health & longevity

Reply
 
Thread Tools
Old 07-08-2007, 09:03 PM   #1
George Mounce
Banned for Ethical and Integrity Violations George Mounce is offline
 
Profile:
Join Date: Mar 2007
Location: Steens  MS
Posts: 3,295
So I invented an Excel spread sheet for the blocks presented in the Front Range CrossFit Zone block guide and added some flare to it.

I made it a calculator, because when I'm cooking for large groups of people I hate doing the math, and I can use it to quickly calculate things for recipes.

It includes the block guide data from the Front Range in different worksheets. You enter the number of blocks, it spits out how much of each thing equals that number of blocks.

I am posting an Excel 97-2003 version and a Excel 2007 version for all of us with Office 2007.

If the "Angry G" confuses you, it is what I post by on the blog comments for the WODs.
Attached Files
File Type: email Zone Block Calculator.xlsx (27.0 KB, 1095 views)
  Reply With Quote
Old 07-08-2007, 09:44 PM   #2
Matthew Swift
Affiliate Matthew Swift is offline
 
Profile:
Join Date: Sep 2006
Location: Brisbane  Queensland
Posts: 119
Nice! Thanks George!

  Reply With Quote
Old 07-08-2007, 10:24 PM   #3
Ian Carver
Affiliate Ian Carver is offline
 
Ian Carver's Avatar
 
Profile:
Join Date: Feb 2006
Location: Sacramento  CA
Posts: 335
Geeez, thanks, George. You are one squared away guy. Pilot, master resume creator, and Excel/Zone spreadsheet fiend...Very cool. Thanks again. Stay safe!!
  Reply With Quote
Old 07-09-2007, 06:42 PM   #4
George Mounce
Banned for Ethical and Integrity Violations George Mounce is offline
 
Profile:
Join Date: Mar 2007
Location: Steens  MS
Posts: 3,295
No problem. I am currently working on a Zone cookbook to pass out to people who need easy things to make. I tend to write down all the recipes I create. I'm currently working on a homemade Zone protein bar. :lightbulb: Hopefully it turns out good, the taste test bars I've made so far are excellent, just fudging with the ingredients to make it perfect so I get a 2-block bar every time. I hope to post it soon!

  Reply With Quote
Old 07-09-2007, 06:45 PM   #5
Sarena Kopciel
Member Sarena Kopciel is offline
 
Profile:
Join Date: Nov 2006
Location: Monsey  NY
Posts: 2,042
Incredible! Thanks.
  Reply With Quote
Old 07-09-2007, 07:45 PM   #6
Frank M Needham
Member Frank M Needham is offline
 
Profile:
Join Date: Jun 2006
Location: Las Vegas  NV
Posts: 452
whoa! I never knew that it'd take 37.5 cups of alfalfa sprouts to make my typical 5 block helping! Thank you George, awesome job!

(Message edited by fmn on July 09, 2007)
  Reply With Quote
Old 07-10-2007, 01:32 PM   #7
Ben Allen
Affiliate Ben Allen is offline
 
Ben Allen's Avatar
 
Profile:
Join Date: Jul 2007
Location: Southampton  Hampshire, UK
Posts: 42
George, great post, Thanks.
I have ordered mastering the zone and enter the zone, and they should be delivered this week. I have tried to convert your excel spread sheet into uk weights (grams instead of cups and oz), but my conversions show that for 1 block of cooked cabbage I should be eating 300g. this would mean for a 4 block meal if I used just cabage i would need 1200g. That seems an awful lot of cabbage.

Do you think my conversions sound along the right lines?
  Reply With Quote
Old 07-10-2007, 04:23 PM   #8
George Mounce
Banned for Ethical and Integrity Violations George Mounce is offline
 
Profile:
Join Date: Mar 2007
Location: Steens  MS
Posts: 3,295
I can easily convert all of that to grams and mL if you would like. Wouldn't take me long at all.
  Reply With Quote
Old 07-10-2007, 04:27 PM   #9
George Mounce
Banned for Ethical and Integrity Violations George Mounce is offline
 
Profile:
Join Date: Mar 2007
Location: Steens  MS
Posts: 3,295
I would say, give me about 6 hours to do all the conversions and I'll have a UK version up. Any other ones you want converted?

So far I have:

change oz to grams
change cups to grams (wouldn't milliliters work better for fluid?)
  Reply With Quote
Old 07-10-2007, 04:47 PM   #10
George Mounce
Banned for Ethical and Integrity Violations George Mounce is offline
 
Profile:
Join Date: Mar 2007
Location: Steens  MS
Posts: 3,295
I come up with using a converter 375g. Yes, your leafy vegetables have absolutely no carbs in them, they are all water. That is why I generally do not count them when making a salad and only count the things that aren't that don't require massive quantities like tomatoes, cucumbers.
  Reply With Quote
Reply


Thread Tools

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Next time you're bored Michael Winker Community 2 10-05-2006 07:03 PM
Some more things to try when you're bored... Pat Janes Exercises 2 05-03-2005 07:05 AM


All times are GMT -7. The time now is 01:16 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
CrossFit is a registered trademark of CrossFit Inc.