Weekly calorie spreadsheet

Options
nehushtan
nehushtan Posts: 566 Member
in Health and Weight Loss
I like to keep track of my calories on a weekly basis rather than a daily basis. That way I get to save calories from earlier in the week, and indulge a bit later in the week (or vice versa).

So I've been keeping a spreadsheet that displays my weekly calorie slop as I fill in each day's numbers. I wish MFP would do this for me, but this is the next best thing.

Here's a Google Docs version of the spreadsheet. It's about as brain-dead a spreadsheet as there could be, but it works for me.

https://docs.google.com/spreadsheet/ccc?key=0AtLvWeJyKrzLdDhPVW9VTkc3cTA3RGp0b191ci1sUFE

If you want to keep a weekly instead of a daily budget, feel free to make or save your own copy (the shared version above is not editable).
«1

Replies

  • txwomyn
    txwomyn Posts: 36
    Options
    I look at your spreadsheet. I take it you input your daily totals in to the sheet and limit what you weekly total should be.
  • Daytonsmommy
    Daytonsmommy Posts: 162 Member
    Options
    I actually just started doing something similar and it seems to be helping me. If I don't consume all of my "bonus" or exercise calories on any given day (although I do try) I am able to see that they are available to me for say a Friday night indulgence :smile:
  • nehushtan
    nehushtan Posts: 566 Member
    Options
    I look at your spreadsheet. I take it you input your daily totals in to the sheet and limit what you weekly total should be.

    Yes. At the end of each day, put your MFP "total" (either a positive or a negative number). The last column of the spreadsheet simply shows how much you are currently over your budget (a negative number) or under your budget (a positive number) for the week.

    At the end of the week, that number should be close to zero.
  • Yori1
    Yori1 Posts: 142
    Options
    Bump
  • buttons235
    buttons235 Posts: 13
    Options
    This is extremely helpful!!! Thank you for sharing :)
  • skullik
    skullik Posts: 142 Member
    Options
    bump!
  • mrsdizzyd84
    mrsdizzyd84 Posts: 422 Member
    Options
    Actually, you can do this on the phone app. It isn't as neat and tidy as your spreadsheet but if you go to your home page and then select the weekly table it will tell you have far under you are for the week, and it will show you your daily totals in bar graph form.

    ETA: you can also see your nutrient breakdown over the week and your % of Carbs vs. fat vs. protein.
  • LadyElby
    LadyElby Posts: 151 Member
    Options
    Thanks so much for posting this!
  • nehushtan
    nehushtan Posts: 566 Member
    Options
    Actually, you can do this on the phone app. It isn't as neat and tidy as your spreadsheet but if you go to your home page and then select the weekly table it will tell you have far under you are for the week, and it will show you your daily totals in bar graph form.

    ETA: you can also see your nutrient breakdown over the week and your % of Carbs vs. fat vs. protein.

    That feature is not available on the BlackBerry version, which I use.

    Actually I checked out the iPhone version (my wife's phone), and don't care for it because it does not give a single number of calories that I'm over/under for the week.
  • StarryEyed500
    StarryEyed500 Posts: 225 Member
    Options
    That feature is not available on the BlackBerry version, which I use.

    Actually I checked out the iPhone version (my wife's phone), and don't care for it because it does not give a single number of calories that I'm over/under for the week.
    You get a single number on the Android version. I find it very useful. The Net details bit doesn't work - instead of showing weekly details, it shows the daily figures. It also has a handy pie chart so you can see your macro breakdown at a glance.
  • ScatteredThoughts
    ScatteredThoughts Posts: 3,562 Member
    Options
    Thanks. I had done something similar a while back, but I like the formatting of yours better.
  • jesscod
    jesscod Posts: 98
    Options
    bump thanks!!
  • nehushtan
    nehushtan Posts: 566 Member
    Options
    You get a single number on the Android version. I find it very useful.

    Can you (or someone) post a screen capture of the way this looks on the Android? TIA
  • EbonySD
    EbonySD Posts: 142
    Options
    I was just thnking of doing the same thing - thanks for the format
  • acman145acp
    acman145acp Posts: 76 Member
    Options
    Actually, you can do this on the phone app. It isn't as neat and tidy as your spreadsheet but if you go to your home page and then select the weekly table it will tell you have far under you are for the week, and it will show you your daily totals in bar graph form.

    ETA: you can also see your nutrient breakdown over the week and your % of Carbs vs. fat vs. protein.

    That feature is not available on the BlackBerry version, which I use.

    Actually I checked out the iPhone version (my wife's phone), and don't care for it because it does not give a single number of calories that I'm over/under for the week.

    Thats odd it gives me the daily number i'm over /under and it gives the total over / under for the week on my iphone app........
  • Wildheart_Baby
    Wildheart_Baby Posts: 44 Member
    Options
    Can you (or someone) post a screen capture of the way this looks on the Android? TIA
    <img src="http://i.imgur.com/GB9Be.jpg"/&gt;
  • _Schatzi_
    _Schatzi_ Posts: 112 Member
    Options
    I have suggested this to MFP. The feature is available on the iPhone and iPad. I use my iPad and track for a weekly average that is my net goal. It tells you how many calories you are over or under for the week and has a bar for your weekly average.
    Dunno why they don't put it on the website?? It's really useful!
  • nehushtan
    nehushtan Posts: 566 Member
    Options
    Can you (or someone) post a screen capture of the way this looks on the Android? TIA
    GB9Be.jpg

    That's cool. I need a better smart phone.

    Does the app's weekly numbers take into account your earned exercise calories? I'm thinking that my wife's iPhone app does not, which has always been another irritation.

    In the spreadsheet, I'm just entering the positive or negative number from the MFP food diary for the day, and that already accounts for the exercise calories I've burned.
  • beccala18
    beccala18 Posts: 293 Member
    Options
    Yes it does take into account those. The graph shows NET calories left.
  • goldengirl28
    goldengirl28 Posts: 130 Member
    Options
    bump so i can review this later

Categories