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!

Spreadsheets and formulae

fluffyasacat
fluffyasacat Posts: 242 Member
edited November 2024 in Health and Weight Loss
Does anyone use spreadsheets to help them chart weight loss and work out their calories for the day? How about calculating workouts or targets? Excel or Google Sheets?

Replies

  • jemhh
    jemhh Posts: 14,261 Member
    Yes.

    Do you need help with a formula?
  • LumberJacck
    LumberJacck Posts: 559 Member
    The Hackers diet is a document about using spreadsheets to help with weight loss. You can get a copy here: https://www.fourmilab.ch/hackdiet/
  • fluffyasacat
    fluffyasacat Posts: 242 Member
    jemhh wrote: »
    Yes.

    Do you need help with a formula?

    Not anything specific, I have a nice spreadsheet going. Just wondered if anyone has anything they've made and found useful that they'd like to share.

  • shadow2soul
    shadow2soul Posts: 7,692 Member
    You might like @heybales spreadsheet. It's pretty awesome IMO.

    Weight Loss Calculator MFP - Public
  • fluffyasacat
    fluffyasacat Posts: 242 Member
    shadow2soul wrote: »
    You might like @heybales spreadsheet. It's pretty awesome IMO.

    Weight Loss Calculator MFP - Public

    That's a work of art!
  • Morgaath
    Morgaath Posts: 679 Member
    Commenting so I can find this when not at work where everything is blocked.
    Used to keep spreadsheets when I started. Now I just live it. If I think I need to adjust something, I do.
  • fluffyasacat
    fluffyasacat Posts: 242 Member
    I've been using a Google Sheet to work out my daily calories for ADF and finally have it all working off a single formula which calculates my TDEE (based on age, weight, height, and activity factor) *125% or *25% depending on whether it's a feast or fast day. Spending time refining the formula has been a most unexpected perk of the process!
  • Mediocrates55
    Mediocrates55 Posts: 326 Member
    God I love data.
    That is all. LOL
  • heybales
    heybales Posts: 18,842 Member
    My weight loss spreadsheet, after filling in the Simple Setup tab, if you go to the TDEE Deficit tab near the bottom, you'll find the 5:2 diet arrangement with suggestion on what to do in MFP for the day of the low eating.

    And I must say, the new forum feature to catch a post reference is nice.
  • Mediocrates55
    Mediocrates55 Posts: 326 Member
    @heybales - that spreadsheet is a dream. Thank you so much for putting the time in to make that. <3
  • fluffyasacat
    fluffyasacat Posts: 242 Member
    Thanks @haybales!
This discussion has been closed.

Categories