Spreadsheet for BMR/TDEE Deficit, Macro calcs, HRM zones

So someone asked about when the Simple Setup TDEG would switch from using a deficit method based on amount to lose to a more traditional TDEE - % Deficit method.

So I ran weekly numbers on the example person the spreadsheet is based on. The OP at the bottom of post shares those figures.

18 weeks.
Starting out losing 2 lbs weekly, eventually reaching 1.2 lbs.
Moving from weight 230 to 200 (avg 1.7 weekly).
Went from needing to lose 100 lbs to 70.
Bodyfat% from 45.4% to 37.1%.
LBM stayed the same about. (but actually would likely increase with all the exercise and eating right). So did BMR of course.
TDEG slowly raised from 1605 to 1905 with one deficit method, until 70 lbs and switching to 2012 with other deficit method.
Deficit went from 39% to 23% off TDEE. So just as less to lose, less is at deficit, more to lose allows more deficit.
Fat mass went from 104 to 74 lbs.

From this point out, our sample gal will move from 23% deficit to TDEE down to 10% until goal weight.

bump to find again after I input my numbers....

Did ya find them!