You need to know your fat % to calculate your LBM (lean body mass).
If you don't know it, there are plenty of places that will help you calculate it, or estimate it. Or just put a pic of you here and someone might be able to help you.

That's how UD2 Works! just by filling the excel you loose fat!
Anyway... doesn't look right. What did you fill in the boxes? can you send me your excel file or a screenshot of what you filled?

ADK.

Sure, I tried filling it in again and it still seems to be doing wierd things. I'll PM you w/ my excel doc. This thing is awesome though once I can get it working. thx

Sure, I tried filling it in again and it still seems to be doing wierd things. I'll PM you w/ my excel doc. This thing is awesome though once I can get it working. thx

Just checked your excel file.

This is the problem:
Your maint calories is 2300 (quiet low...) and your LBM is 68kg (150lb)
You want to cut that by 50%
New Maint cals: 1150 cals
You want 20% of that to be carbs
CARBS=57grams
You want 1.5 protein per LBM
PROTEIN=150lb*1.5=225grams
And the rest, fats... so how much fats?

FAT=(1151cals - (57*4) - (225*4)) / 9 = 3grams!!!

For Thursday is even more apparent, since Thursday until lunch, is only 75% of the normal low carb cals.

This is the problem:
Your maint calories is 2300 (quiet low...) and your LBM is 68kg (150lb)
You want to cut that by 50%
New Maint cals: 1150 cals
You want 20% of that to be carbs
CARBS=57grams
You want 1.5 protein per LBM
PROTEIN=150lb*1.5=225grams
And the rest, fats... so how much fats?

FAT=(1151cals - (57*4) - (225*4)) / 9 = 3grams!!!

For Thursday is even more apparent, since Thursday until lunch, is only 75% of the normal low carb cals.

Is there a way to modify the spreadsheet so one can cut cals on Saturday by 10-20% as it says in the book if fat-loss is the priority? Right now it seems as though it only calculates maintenance level cals.

Yeah i guess what I meant was that it would be cool to be able to choose for Sat whether you wanted to eat at maintenance, or a 10-20% deficit if fat loss is the priority (per the book). From there you can then indicate how much of each macro you wanted to eat at whatever your desired calorie level is for Sat.