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!

Excel formula

srv524
srv524 Posts: 1,363 Member
in Health and Weight Loss
Looking for an excel formula for weight loss. Checking google and I find the same formula with different variations but when I do it myself, it doesn't look right.

A1= starting weight
A2 = latest weight

=(A2-A1)/A1

For example-

Me - 218.8, now 218. Formula shows -.00366 weight loss. This seems really low, even as part of my overall weight. I thought there was something where we multiplied it by 100?

Replies

  • BigT555
    BigT555 Posts: 2,067 Member
    are you looking for a percentage of total weight lost?
    in that case you are correct you need to multiply by 100 to get percentage i.e. 0.366%
  • FaithfulJewel
    FaithfulJewel Posts: 177 Member
    BigT is correct.

    It should be:

    =((A2-A1)/A1)*100

    :)
  • srv524
    srv524 Posts: 1,363 Member
    Yes, percentage of total weight lost. So % of 218.8 in my case. I'll use the below, thanks!
  • Paco4gsc
    Paco4gsc Posts: 119 Member
    If you are using Excel, you could also just change the cell format to Percentage instead of multiplying by 100.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    You might find this useful

    http://www.myfitnesspal.com/blog/EvgeniZyntx/view/new-mfp-data-export-tool-major-update-659927
  • SunofaBeach14
    SunofaBeach14 Posts: 4,899 Member
    bumpity bump bump for that ^
  • RabbitLost
    RabbitLost Posts: 333 Member
    bumpity bump bump for that ^

    ^^^ x2
  • srv524
    srv524 Posts: 1,363 Member
    I'm at my work computer so can't access this now...

    Is it an add-on to your browser or separate program? Looks like it runs a macro based on your food diary on MFP and provides analysis/numbers based on that.
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    I'm at my work computer so can't access this now...

    Is it an add-on to your browser or separate program? Looks like it runs a macro based on your food diary on MFP and provides analysis/numbers based on that.

    Separate spreadsheet in Excel 2010 or 2013 that runs a few macros to extract your data and then provides an analysis. Self-configuring and runs at the click of one button.

    Someone else wrote a browser add-on for chrome if you prefer that.
  • srv524
    srv524 Posts: 1,363 Member
    Do you have the link for the chrome add-on? I've tried downloading this 4x now (using IE and chrome) and it times out about 60% of the way through.
  • srv524
    srv524 Posts: 1,363 Member
    Wait just found it

    https://chrome.google.com/webstore/detail/myfitnesspal-data-exporte/pjhcgkchlaggpkjioockflccjfkmnccn/related
  • srv524
    srv524 Posts: 1,363 Member
    Actually no that doesn't do projections.....
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Do you have the link for the chrome add-on? I've tried downloading this 4x now (using IE and chrome) and it times out about 60% of the way through.

    Let me know if you are still experiencing download issues and I'll publish it to a different server.
  • srv524
    srv524 Posts: 1,363 Member
    Still not downloading for me...
  • EvgeniZyntx
    EvgeniZyntx Posts: 24,208 Member
    Since you are having trouble downloading it, here is the file available at a different location:

    http://www.filedropper.com/mfp3v12

    This is a one-time upload - I'll only maintain upgrades at the other location.

Categories