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 12-08-2009, 07:46 AM   #51
Bruce Gray
Member Bruce Gray is offline
 
Profile:
Join Date: Dec 2009
Location: Brisbane  QLD Australia
Posts: 5
Re: Zone Diet Spreadsheet

I just came across Nathan's spreadsheet. It is excellent work, and has motivated me to delve deeper into the Zone Diet and its block structure.

It also motivated me to share a diet spreadsheet I've evolved over several years. I recently released this spreadsheet into the wild via the blog mentioned below.

I am a physiologist in Australia, and have used the xls to educate clients about macronutrient intake and as a diet planner.

Some of the algorithms were developed for commercial software and the xls was used as a proof of concept to demonstrate diet education and planning to several government health authorities.

There is a database of ingredients that you can add to, but I live in Australia and the planner was designed to build diets out of mostly raw unprocessed ingredients. US, Canadian, and Europeans tend to eat more processed foods. (I've lived in all these countries and know it is so.) As you can imagine, the variety of processed or packaged food is endless. Rather than expand the database to cover these, I suggest everyone eats more unprocessed food.

There are several template 1 week portion plans in the xls currently, but nothing based on the Atkins or Zone diets.

You can easily experiment building your own diets, and watch macronutrient percentage/grams and total Calories update automatically.

It also has a shopping list generator, but keep in mind that this requires editing price and package information in the database, to represent your local prices. Current prices are what we pay in Australia, which is on average higher than North America and Europe.

It is a large spreadsheet, and will look overwhelming at first. But it is all quite logical and has instructions.

The weight tracking chart is one of the most valued features by my clients.....and this feature was difficult to program. Microsoft excel is quite hamstrung in its charting abilities, and this required a lot of vba coding to overcome.

All functionality works in US (imperial) or metric units.
It can also be used for bulking phases when you are increasing gross weight.

Compatibility Notes
It won't run if macros aren't enabled.
It should run on any windows system with excel 97,03,07.
It won't run on Macs because Microsoft didn't build macro (visual basic) capability into Excel for Macs. (however, I don't know if Microsoft has updated this limitation recently).
If you have issues, try the service pack updates for XPP or MS Office.
Open Office and Linux: unfortunately, visual basic varies considerably in OO, and it would take several hundred man hours to adapt the macros from excel to OO. I don't have the time or expertise.

I'd be interested in any feedback.

Download via googling "Grays Diet Planner"
or go to first blog entry at
http://graysdietplanner.blogspot.com/

Last edited by Bruce Gray : 12-08-2009 at 07:56 AM.
  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
Which diet is more effective in given cases, Paleolithic diet or Zone diet? Nicolas Castonguay Nutrition 28 11-05-2007 02:34 PM
Zone Diet Critique: "The Zone Diet Phenomenon" Ben Moskowitz Nutrition 15 10-10-2007 12:35 PM
Diet soda, diet energy drinks, and zone bars... John Fox Nutrition 31 04-18-2006 02:27 PM
Spreadsheet for the benchmarks Scott Kustes Community 12 09-06-2005 06:21 AM
Paleo-zone diet = anti-rhabdo-diet? Seth Drown Nutrition 3 04-05-2005 11:03 AM


All times are GMT -7. The time now is 04:19 PM.


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