Average Weight Lost Per Week

So, for the last 90 days from today, I have burned 704,881 calories, consumed around 591,802 calories. That would give me a 90 day deficit of 113,079, right? Just wondering what the weekly average weight loss would work out to be... I guessed at 1.6/wk. I'm trying to refresh my mathing
«1

Replies

  • dhimaan
    dhimaan Posts: 774 Member
    It is about 2.5 lb/week.
  • This content has been removed.
  • Kimegatron
    Kimegatron Posts: 772 Member
    How did you get to that? I have only lost 25-26, but I don't think I logged everything correctly. I'm getting more diligent and tight with my logging.
  • Werk2Eat
    Werk2Eat Posts: 114 Member
    shell1005 wrote: »

    There are a lot of ifs in that equation though.
    two

  • This content has been removed.
  • Kimegatron
    Kimegatron Posts: 772 Member
    Ah, see, I learn something every day! I had no idea how many calories were in a pound, and didn't even think to look something like that up! Thanks a lot!
  • Kimegatron
    Kimegatron Posts: 772 Member
    That deficit seems too high, honestly. Maybe I missed something in the 90 days. Would you look at the calories option in the reports tab, or the net?
  • lorrpb
    lorrpb Posts: 11,463 Member
    Your exercise/burn calories might be overestimated, but it looks like you still are doing a great job! How much have you actually lost during these 90 days?
  • Kimegatron
    Kimegatron Posts: 772 Member
    I have lost 25-26 total, so maybe a few under that in 90 days. My calculations are all off, I need to try to add this up while I'm not at work, ha ha!
  • sashayoung72
    sashayoung72 Posts: 441 Member
    that's still 2 lbs per week which is awesome!
  • ncboiler89
    ncboiler89 Posts: 2,408 Member
    edited September 2015
    Kimegatron wrote: »
    How did you get to that? I have only lost 25-26, but I don't think I logged everything correctly. I'm getting more diligent and tight with my logging.

    ((113,000calorie deficit/3500 calories/pound)/90days)*7 days per week

    To break it down;

    You have a deficit of 113,079. Divide that by 3500 which is the calories per pound to get the number of expected pounds loss.

    Take that number and divide by 90 days which is that expected loss per day

    Take that number and multiply by 7 which is the number of days in a week. This gets you the pounds loss per week

    The result is 2.5 pounds per week.
  • minties82
    minties82 Posts: 907 Member
    2lbs a week sounds blardy good to me, well done.

    Do you have microsoft office? Maybe look at the myfitnesspal data export tool. If you enjoy numbers it is pretty fun.
  • RMCottonRPh
    RMCottonRPh Posts: 41 Member
    You actual loss is never going to exactly match the math, due to tons of variables. But bottom line, you are doing great!
  • Merkavar
    Merkavar Posts: 3,082 Member
    I divided 113k by 90
    Times that by 7
    Divided that by 3500
    Got 2.51 pounds per week

    You may not have matched the maths but sounds like you did a good job anyway.

    Keep it up.
  • random5483
    random5483 Posts: 63 Member
    The equations stated above are correct. However, weight is never quite that simple. Gained muscle? If so, your weight loss might be less than expected. Lost muscle? Maybe your weight loss would be more than expected. Was water weight loss included in the period? Changes in water weight are not always based on net calorie change and if you switched to a sodium low or sodium rich diet, the amount of water weight you have might change. Let's not also forget things like when you weigh yourself. Things as minor as using the restroom before or after could effect weight.

    If your calculations are off by 5 lbs or so out of 25ish lbs, the error is not due to your lack of diligence. The weight loss equations based on net calorie deficits are 100% accurate on paper, but never 100% accurate in practice. On paper, we can control for every single variance. But in reality, we cannot control everything. Did you walk up the stairs more to gain calorie loss? Chances are you gained a little muscle that might offset part of the weight loss. And this is not taking into account the inherent inaccuracies in even the most accurate devices for tracking calorie burn.

    Keep doing what you are doing. Don't worry about minor logging errors or slightly slower/faster weight loss than you expect.
  • Kimegatron
    Kimegatron Posts: 772 Member
    random5483 wrote: »
    The equations stated above are correct. However, weight is never quite that simple. Gained muscle? If so, your weight loss might be less than expected. Lost muscle? Maybe your weight loss would be more than expected. Was water weight loss included in the period? Changes in water weight are not always based on net calorie change and if you switched to a sodium low or sodium rich diet, the amount of water weight you have might change. Let's not also forget things like when you weigh yourself. Things as minor as using the restroom before or after could effect weight.

    If your calculations are off by 5 lbs or so out of 25ish lbs, the error is not due to your lack of diligence. The weight loss equations based on net calorie deficits are 100% accurate on paper, but never 100% accurate in practice. On paper, we can control for every single variance. But in reality, we cannot control everything. Did you walk up the stairs more to gain calorie loss? Chances are you gained a little muscle that might offset part of the weight loss. And this is not taking into account the inherent inaccuracies in even the most accurate devices for tracking calorie burn.

    Keep doing what you are doing. Don't worry about minor logging errors or slightly slower/faster weight loss than you expect.

    I'm not so much as basing the end result, mathematically, to what my actual loss is. I think I added up a few things wrong with the calorie burn, ha ha! I get bored sometimes and just wonder what the difference is.
  • ColinsMommaOC
    ColinsMommaOC Posts: 296 Member
    Kimegatron wrote: »

    I'm not so much as basing the end result, mathematically, to what my actual loss is. I think I added up a few things wrong with the calorie burn, ha ha! I get bored sometimes and just wonder what the difference is.

    I am so with you there. I have a spreadsheet on my computer that I update daily. Weight, how much I ate, how much fitbit says I burned. I even put the useless 5-week estimate in there, and compare it to where I am at 5 weeks after. Data is fun to play around with :)
    lryrd2xok965.jpg
  • Kimegatron
    Kimegatron Posts: 772 Member
    edited September 2015
    Oh wow, yeah I was way off! I was using the report on Fitbit, and since they don't have a 90 day option, I did it for the whole year... thinking that I didn't get my Fitbit since June, not thinking that it gives you a calorie burn for all of the days that I didn't have one. So it is actually:
    237,598 burned(as of right now)
    +143,737 consumed(including today)
    =93,861 deficit???
    Divide by 3,500
    =26.82
    Divide by 90 days
    =.31
    x 7 days
    x 12 weeks
    =2.09lbs lost/wk, so roughly 25.08 pounds. Does that sound about right? I have no idea what makes me want to figure this stuff out sometimes...
  • Kimegatron
    Kimegatron Posts: 772 Member
    Kimegatron wrote: »

    I'm not so much as basing the end result, mathematically, to what my actual loss is. I think I added up a few things wrong with the calorie burn, ha ha! I get bored sometimes and just wonder what the difference is.

    I am so with you there. I have a spreadsheet on my computer that I update daily. Weight, how much I ate, how much fitbit says I burned. I even put the useless 5-week estimate in there, and compare it to where I am at 5 weeks after. Data is fun to play around with :)
    lryrd2xok965.jpg

    omg that is beautiful! Is that Excel? I will have to see if I have that on my laptop at home :)
  • ColinsMommaOC
    ColinsMommaOC Posts: 296 Member
    Kimegatron wrote: »

    omg that is beautiful! Is that Excel? I will have to see if I have that on my laptop at home :)

    It is. If you do not have excel on your computer, Google Sheets works just as well.

  • OhMsDiva
    OhMsDiva Posts: 1,073 Member
    Where do you find your calories burned?
  • ColinsMommaOC
    ColinsMommaOC Posts: 296 Member
    OhMsDiva wrote: »
    Where do you find your calories burned?
    I use a fitbit to estimate my calories burned and I believe the OP does as well...
  • Kimegatron
    Kimegatron Posts: 772 Member
    OhMsDiva wrote: »
    Where do you find your calories burned?
    I use a fitbit to estimate my calories burned and I believe the OP does as well...

    I have a question for your "actual," because I just set this up.... Do you go back after the 5wk mark to enter the actual weight, then? So I am starting this sheet today, which means I will have to wait 5 weeks to finish a line, right? Is that how you did it?
  • Kimegatron
    Kimegatron Posts: 772 Member
    And yes, I do have a Fitbit, I am obsessed
  • ColinsMommaOC
    ColinsMommaOC Posts: 296 Member
    edited September 2015
    Kimegatron wrote: »

    I have a question for your "actual," because I just set this up.... Do you go back after the 5wk mark to enter the actual weight, then? So I am starting this sheet today, which means I will have to wait 5 weeks to finish a line, right? Is that how you did it?

    Yep. See below. I have the last 28 days waiting for their 5 week actual weight and I have started my next 28 day log too. 129yy32c449x.jpg

    ETA: I find the daily reminder of where I have been to be very helpful to keep me motivated. Though not so much this week, but I think that is just sheer laziness on my part.
  • Kimegatron
    Kimegatron Posts: 772 Member
    This is so awesome! And a great way for me to use Excel! I haven't used it in so long, I forget how to factor in it's equations.
  • AnnPT77
    AnnPT77 Posts: 34,204 Member
    I have nothing to add, but I love this level of data-geekery. Go, ladies!

    (I spend my data geek energies more on my sport than my weight loss. ;) .)
  • ColinsMommaOC
    ColinsMommaOC Posts: 296 Member
    mostly just your basic SUM equations honestly. I tried to keep it as simple as possible.

    B32 =Sum(b2:b8)
    B33 =Sum(b9:b15)
    B34 =Sum(b16:b22)
    b35 =sum(b23:b29)
    B37 =sum(b32:b35)
    B38 =B37/28

    same with columns C D and E

    F32 =D32/3500
    etc
  • Kimegatron
    Kimegatron Posts: 772 Member
    How do you do the conditional formatting for colors? I'm so rusty at spreadsheets
  • ColinsMommaOC
    ColinsMommaOC Posts: 296 Member
    edited September 2015
    I think it would be a IF formula... Let me look it up. I just change the color manually on mine

    ETA: I found this link https://www.ablebits.com/office-addins-blog/2013/10/18/change-background-color-excel-based-on-cell-value/