Useful equations for Excel spreadsheet

Crawflowr
Crawflowr Posts: 106 Member
edited November 12 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