Message Boards » General Diet and Weight Loss Help

TOPIC: Weekly calorie spreadsheet

 
Ic_disabled_photos
Topic has been inactive for 30 days or more and images have been disabled.
Display All Images
May 8, 2012 9:01 PM
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).
  1512169
May 9, 2012 5:27 AM
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.
  13365089
May 9, 2012 5:32 AM
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
Edited by Daytonsmommy On May 9, 2012 5:32 AM
May 9, 2012 6:00 AM
QUOTE:

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.
  1512169
May 9, 2012 6:37 AM
Bump
  5902677
May 9, 2012 7:01 AM
This is extremely helpful!!! Thank you for sharing :)
  21545957
May 9, 2012 7:06 AM
bump!
  11025986
May 9, 2012 7:07 AM
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.
Edited by mrsdizzyd84 On May 9, 2012 7:08 AM
May 9, 2012 8:01 AM
Thanks so much for posting this!
  16797352
May 11, 2012 5:25 AM
QUOTE:

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.
  1512169
May 11, 2012 5:34 AM
QUOTE:
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.
  8198610
May 11, 2012 5:37 AM
Thanks. I had done something similar a while back, but I like the formatting of yours better.
  13288459
May 11, 2012 5:57 AM
bump thanks!!
May 11, 2012 9:46 AM
QUOTE:

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
  1512169
May 12, 2012 11:42 AM
I was just thnking of doing the same thing - thanks for the format
  19663253
May 12, 2012 5:10 PM
QUOTE:

QUOTE:

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........
  17389365
May 20, 2012 11:59 AM
QUOTE:

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"/>
Edited by Wildheart_Baby On May 20, 2012 12:00 PM
  5747135
May 20, 2012 8:07 PM
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!
  20782155
May 22, 2012 11:15 AM
QUOTE:

Can you (or someone) post a screen capture of the way this looks on the Android? TIA
Image not displayed


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.
  1512169
May 22, 2012 11:17 AM
Yes it does take into account those. The graph shows NET calories left.
July 8, 2012 7:47 AM
bump so i can review this later
  6991029
July 8, 2012 7:52 AM
QUOTE:

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.


Oh that's nice. Thank you!
  9132691

Message Boards » General Diet and Weight Loss Help

Posts by members, moderators and admins should not be considered medical advice and no guarantee is made against accuracy.