We are pleased to announce that on March 4, 2025, an updated Rich Text Editor will be introduced in the MyFitnessPal Community. To learn more about the upcoming changes, please click here. We look forward to sharing this new feature with you!

Useful equations for Excel spreadsheet

Crawflowr
Crawflowr Posts: 106 Member
edited November 2024 in Health and Weight Loss
I just thought I'd post a few useful equations for people who have an excel spreadsheet (or OpenOffice calc) and record their weight in it.

Let us say you have two columns A1:A10 holds the dates you weighed in B1:B10 holds the weight on those days

To calculate your average weight loss per week:
(INDEX(LINEST($B$1:$B$10,$A$1:$A$10),1))*7

If you enter a goal weight in C1
To calculate the date you'll reach that goal at the current rate:
(C1-INDEX(LINEST($B$1:$B$10,$A$1:$A$10),2))/INDEX(LINEST($B$1:$B$10,$A$1:$A$10),1)
remember to format the cell as a date

Hope you find this useful.

Replies

  • ScatteredThoughts
    ScatteredThoughts Posts: 3,562 Member
    Very interesting. I'm going to give this a try.

    Thanks!
  • lohitverma
    lohitverma Posts: 161 Member
    Thank you , this was helpful
  • dsjohndrow
    dsjohndrow Posts: 1,820 Member
    I just thought I'd post a few useful equations for people who have an excel spreadsheet (or OpenOffice calc) and record their weight in it.

    Let us say you have two columns A1:A10 holds the dates you weighed in B1:B10 holds the weight on those days

    To calculate your average weight loss per week:
    (INDEX(LINEST($B$1:$B$10,$A$1:$A$10),1))*7

    If you enter a goal weight in C1
    To calculate the date you'll reach that goal at the current rate:
    (C1-INDEX(LINEST($B$1:$B$10,$A$1:$A$10),2))/INDEX(LINEST($B$1:$B$10,$A$1:$A$10),1)
    remember to format the cell as a date

    Hope you find this useful.

    The scale didn't change. ;)
  • Crawflowr
    Crawflowr Posts: 106 Member
    The scale didn't change. ;)

    I know I'm sorry analysing the data doesn't make any difference to your actual weight loss. :)

    I found it helpful though when I felt I was plateauing to graph my actual loss and draw a trend line through it. I was amazed how close to the MFP estimated loss my line was. I am a data analyst by profession so analysing the data was second nature to me. Yes I have developed a mild compulsive disorder with this. I know it's sad but that's what works for me. Trying to lose weight before with guestimates and rules of thumb just wasn't working for me. I like data and facts it's who I am.

    If this graph is still legible then you can see it worked :) Following MFP's instructions and eating my exercise calories back.

    1zq79sy.jpg
  • TheWinman
    TheWinman Posts: 684 Member
    Thank you!
  • sumitini
    sumitini Posts: 1
    These formulas work very well! I calculate my average weight loss to be 1.11 pounds per week, and that I will hit my intermediate target in July and my final target in Oct. Without these formulas I'm not sure how I would have figured this out Cheers
This discussion has been closed.

Categories