daily / weekly total

**Tobyriley** · 06-07-2010, 11:20 AM

I am trying to make a spreadsheet to keep track of my daily food intake. I am basing this on the weight watchers point system. I get a daily number of points i can use and a weekly amount of "bonus" points i can use. If I go over my daily points it comes off of my weekly bonus point totals. how do i make a daily point total column and subtract my weekly bonus points as a running total for lack of better terminology.

Here is what i have so far

Daily Allowed Daily Used Daily Remaining Weekly Remaining Weekly Bonus Points Over
44 0 44 35 35 0

These columns start in "g". Column c is my daily point totals. I can only come up with a running total for daily use by then my daily used column is off. I hope this makes sense.

Thanks for any help anyone can give
Toby

**6StringJazzer** · 06-07-2010, 12:23 PM

Is one of the columns A-F a date, or day of week? We need to know how to figure out which rows go with which week.

Is there one row per day?

If column H is Daily Used, then what is in Column C for what you call "daily point totals"?

Sounds to me like the strategy is to keep you so busy entering data you don't have time to eat

**Tobyriley** · 06-07-2010, 01:20 PM

6StringJazzer - after reading my initial post i agree with you - I won't have time to eat! I'll try to put it simpler: I enter the food in column b5 and the point total for that food in c5. say i eat 10 things that day. every time i enter a point total in column c it subtracts from my daily used total in h3. The only data I am actually entering is column a) date column b) food column c) point total. At the start of a new day I need h2 to "reset" back to 0. I can only get a running total so far and that doesn't work. Does this make any more sense?

g2 daily allowed / g3 is a fixed # of 44

h2 daily used / h3 auto populates from the c column total

i2 daily remaining / i3 subtracts daily used (h3) from daily allowed (g2)

j2 weekly remaining / j3 is an =if cmd =if(h2>44,j2-L2,"0")

k2 weekly bonus k3 is a fixed # of 35

L2 daily points over / L3 is an =if cmd =IF(H3>G3,H3-G3,"0")

**6StringJazzer** · 06-13-2010, 11:29 PM

I'm sorry, I haven't forgotten you, I've been swamped working on a proposal this week. I'll try to get back to you Monday....

**royUK** · 06-14-2010, 12:36 AM

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

If the data is correctly laid out you could use a PivotTable

**6StringJazzer** · 06-15-2010, 02:08 PM

After reading your second post, I would agree that I need to see your workbook. Can you attach one with some data in it for at least two days? It doesn't have to be real data.

Among other things, I am not sure how you want this to happen:

At the start of a new day I need h2 to "reset" back to 0