View Single Post
Unread 06-21-2017, 05:11 PM
neokahn neokahn is offline
Junior Member
Join Date: Jun 2017
Location: South Central Texas
Posts: 18
Default UD2 Workbooks for Excel...

I thought I would share my excel workbooks with you guys. These are what I use to plan, log and track my UD2 cycles. Those of you that like delving into the numbers of this sort of thing and tweak values at this level will have a splendid time digging into them and learning how to use them effectively. Those of you who do not...will absolutely hate them and wonder why you would need to do this sort of thing. Well, I am a software systems developer so this is right up my alley and I literally can't think a compelling reason why you would NOT want to use a tool like this! LOL I hope you guys benefit as much as my wife and I have!

It consists of three separate workbooks...

Program Outline - This is where you look at where you currently are fitness-wise...where you want to go and how you plan to get there. It allows you to plan each week in detail from workouts to supplements. Set your UD2 values and track your caloric intake vs. workout expenditure...body composition through impedance monitoring (yeah, i know...garbage in garbage out...not the worst for tracking delta though)...use calipers if you like..i check it both ways just for kicks. It includes an analysis sheet that graphs your progress over time...a sheet to create your workouts and take your weekly measurements.

Workout Calculator - There are many phone / heart rate monitor apps that do the same thing, but I find it convenient to track it here via a CSV download from the HRM app...I use Motifit. I wrote the core of this one years ago and didn't want to just scrap it so i updated it to work for both men and women, to set zone values and the MHR calculation method. For those of you that attend Orange Theory Fitness (like my wife does) can use the OTF formula to set the zones and colors to their system. You can track steady state workouts, varying interval workouts (comparing different interval setups to find which one puts you in the zone you want to be in and for how long). Also analyzes actual HRM output data so you can literally do anything you like while wearing your HRM and the plug the numbers back into the program outline to track progress.

Meal Planner - This helps you plan and track meals to a very fine level of accuracy. First you enter in your foods from your pantry into the appropriate category on the food list sheet using the calculator (either as ingredients or fixed items) and then you can use them to create meals that conform to your UD2 goals. You enter your daily meal goals into the Meal Planner sheet and determine your UD2 carb load values by simply selecting which meals in the thursday/friday transition zone you want to include. You can create 'Low Carb', 'High Carb' and 'Maintenance Meals' for later use...just basically copy and paste from one sheet to another or you can create 'Menu Items' that contain multiple ingredients distilled down to the base macro-nutrient ratio and treat them just like any other food item.

There is some redundancy between the workbooks to allow you to generate the necessary UD2 values and then track them in other workbooks that also depend on those values...and then over time you can recheck your values and make whatever adjustments you need moving forward. My wife and I have used this for the past few weeks and it has been a great tool.

There are literally too many caveats in how these work to explain them in this post, but if you have any questions or find any bugs just post them here and I will do my best to answer in a timely manner.

I am constantly updating and improving these, but for now here are the links to my working copies so you can see what they look like in progress as the data is being filled in.

hope you enjoy,

Reply With Quote