Useful equations for Excel spreadsheet

Crawflowr

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.

ScatteredThoughts

Very interesting. I'm going to give this a try.

Thanks!

lohitverma

Thank you , this was helpful

dsjohndrow

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

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.

TheWinman

Thank you!

sumitini

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