SOLVED

Trying to do a weekly tracker for excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2872464%22%20slang%3D%22en-US%22%3ETrying%20to%20do%20a%20weekly%20tracker%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872464%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20find%20a%20way%20to%20track%20the%20meals%20every%207%20days%20staring%20on%20Monday%20ending%20on%20Sunday.%3C%2FP%3E%3CP%3ERight%20now%20this%20is%20my%20formula%20if%20the%20first%20was%20on%20Monday.%3C%2FP%3E%3CP%3E%3D'1'!I5%2B'2'!I5%2B'3'!I5%2B'4'!I5%2B'5'!I5%2B'6'!I5%2B'7'!I5%3C%2FP%3E%3CP%3EIs%20there%20a%20better%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20apricated.%3C%2FP%3E%3CP%3EI%20attached%20the%20file%20so%20you%20can%20see%20what%20I%20been%20doing%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2872464%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2872477%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20weekly%20tracker%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872477%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192639%22%20target%3D%22_blank%22%3E%40Intodeep%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETrack%20the%20meals%20in%20which%20context%3F%20who%20ate%20them%3F%20to%20switch%20the%20type%20of%20meals%20round%20robin%3F%20%3F%3F%20your%20meals%20are%20the%20predicate%20what%20is%20the%20subject%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2872522%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20weekly%20tracker%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872522%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%20for%20pointing%20out%20the%20lacking%20information%20I%20am%20relative%20new%20to%20this.%3CBR%20%2F%3EI%20am%20looking%20to%20track%20the%20number%20of%20meals%20going%20out.%3CBR%20%2F%3EExample%20Sheet%201%20it%20would%20have%20the%20monthly%20numbers%20in%20column%20B%2C%20then%20column%20D%20would%20be%20the%20start%20of%20the%20weekly%20numbers.%26nbsp%3B%3CBR%20%2F%3EFor%20each%20day%20of%20the%20month%20I%20have%203%20meals%20going%20out%20for%20breakfast%2C%20lunch%20and%20supper%20and%20I%20am%20tracking%20that%20number%20with%20the%26nbsp%3Bformula%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3D'1'!I5%2B'2'!I5%2B'3'!I5%2B'4'!I5%2B'5'!I5%2B'6'!I5%2B'7'!I5%20going%20to%20the%20end%20of%20the%20month%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20like%20to%20see%20if%20I%20can%20break%20down%20the%20number%20of%20meals%20going%20out%26nbsp%3Bby%20week.%26nbsp%3B%3CBR%20%2F%3E1%20being%20the%20first%20of%20the%20month%20and%20I5%20the%20cell%20number%20and%20getting%20the%20cell%20number%20posted%20on%20Sheet%201.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2872536%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20weekly%20tracker%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2872536%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1192639%22%20target%3D%22_blank%22%3E%40Intodeep%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyour%20explanation%20still%20lacks%20context.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20stated%3A%3C%2FP%3E%3CP%3E%3CSPAN%3EExample%20Sheet%201%20it%20would%20have%20the%20monthly%20numbers%20in%20column%20B%2C%20then%20column%20D%20would%20be%20the%20start%20of%20the%20weekly%20numbers.%26nbsp%3B%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EFor%20each%20day%20of%20the%20month%20I%20have%203%20meals%20going%20out%20for%20breakfast%2C%20lunch%20and%20supper%20and%20I%20am%20tracking%20that%20number%20with%20the%26nbsp%3Bformula%2C%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ETracking%20down%20what%20number%3F%20number%20of%20breakfast%2C%20lunch%2C%20or%20dinner%3F%20that%20is%20the%20only%20context%20mentioned%20in%20your%20narrative.%26nbsp%3B%20According%20to%20your%20narrative%20which%20only%20talks%20about%20breakfast%20lunch%20or%20dinner%2C%20with%20one%20of%20each%20every%20day%20then%20the%20answer%20would%20be%20if%20there%20were%2031%20days%20to%20the%20month%20you%20are%20tracking%20there%20would%20be%2031%20of%20each%20breakfast%2C%20lunch%20and%20dinner%20since%20there%20aren't%20any%20other%20context%20your%20narrative%20is%20specifying.%20do%20you%20follow%3F%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EFor%20example%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eyou%20serve%202%20apples%20at%20breakfast%20(context%20here%20is%20number%20of%20apples)%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eyou%20serve%201%20apple%20for%20lunch%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eyou%20serve%20peaches%20for%20dinner%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3Eso%20the%20context%20in%20tracking%20numbers%20is%20how%20many%20fruits%20and%20what%20kind%20context%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3Eso%20in%20all%20in%2031%20days%20contextually%20how%20many%20apples%20did%20you%20serve%20and%20how%20many%20peaches%20did%20you%20serve.%26nbsp%3B%20That%20is%20the%20context%20I%20am%20speaking%20of.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2873171%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20weekly%20tracker%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2873171%22%20slang%3D%22en-US%22%3ERight%20now%20I%20am%20just%20trying%20to%20track%20the%20number%20of%20meals.%20If%20serve%20400%20breakfast%20for%20the%20month%2C%20I%20would%20like%20to%20then%20brake%20it%20down%20to%20weekly.%3CBR%20%2F%3EWeek%201%3D100%20meals%2C%20week%202%3D100%20meals%20Week%203%3D100%20meals%2C%20week%204%3D100%20meals.%20I%20tring%20to%20find%20out%20if%20there%20is%20a%20better%20way%20of%20doing%20this%20then%20entering%3CBR%20%2F%3E%3D'date'%20!cell%20number%2B'date'%20!cell%20number%3CBR%20%2F%3EThen%20repeating%20this%20formula%20for%207%20days.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2876310%22%20slang%3D%22en-US%22%3ERe%3A%20Trying%20to%20do%20a%20weekly%20tracker%20for%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2876310%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20help%2C%20the%20video%20was%20great%2C%20and%20helped%20me%20out.%3C%2FLINGO-BODY%3E
New Contributor

I am trying to find a way to track the meals every 7 days staring on Monday ending on Sunday.

Right now this is my formula if the first was on Monday.

='1'!I5+'2'!I5+'3'!I5+'4'!I5+'5'!I5+'6'!I5+'7'!I5

Is there a better way to do this?

Any help would be greatly apricated.

I attached the file so you can see what I have been doing.

 

Edit: I am looking to track the number of meals going out.

Example Sheet 1 it would have the monthly numbers in column B, then column D would be the start of the weekly numbers. 

 

for each day of the month I have 3 meals going out for breakfast, lunch and supper and I am tracking that number with the formula

='1'!I5+'2'!I5+'3'!I5+'4'!I5+'5'!I5+'6'!I5+'7'!I5 going to the end of the month, 

I would like to see if I can break down the number of meals going out by week. 
1 being the first of the month and I5 the cell number and getting the cell number posted on Sheet 1.

 

 

7 Replies

@Intodeep 

 

Track the meals in which context? who ate them? to switch the type of meals round robin? ?? your meals are the predicate what is the subject?

Thank you for pointing out the lacking information I am relative new to this.
I am looking to track the number of meals going out.
Example Sheet 1 it would have the monthly numbers in column B, then column D would be the start of the weekly numbers. 
For each day of the month I have 3 meals going out for breakfast, lunch and supper and I am tracking that number with the formula,

='1'!I5+'2'!I5+'3'!I5+'4'!I5+'5'!I5+'6'!I5+'7'!I5 going to the end of the month, 

I would like to see if I can break down the number of meals going out by week. 
1 being the first of the month and I5 the cell number and getting the cell number posted on Sheet 1.

@Intodeep 

 

your explanation still lacks context.

 

You stated:

Example Sheet 1 it would have the monthly numbers in column B, then column D would be the start of the weekly numbers. 
For each day of the month I have 3 meals going out for breakfast, lunch and supper and I am tracking that number with the formula,

 

Tracking down what number? number of breakfast, lunch, or dinner? that is the only context mentioned in your narrative.  According to your narrative which only talks about breakfast lunch or dinner, with one of each every day then the answer would be if there were 31 days to the month you are tracking there would be 31 of each breakfast, lunch and dinner since there aren't any other context your narrative is specifying. do you follow?

 

For example:

you serve 2 apples at breakfast (context here is number of apples)

you serve 1 apple for lunch

you serve peaches for dinner

 

so the context in tracking numbers is how many fruits and what kind context

so in all in 31 days contextually how many apples did you serve and how many peaches did you serve.  That is the context I am speaking of.

 

 

 

 

Right now I am just trying to track the number of meals. If serve 400 breakfast for the month, I would like to then brake it down to weekly.
Week 1=100 meals, week 2=100 meals Week 3=100 meals, week 4=100 meals. I tring to find out if there is a better way of doing this then entering
='date' !cell number+'date' !cell number
Then repeating this formula for 7 days.
best response confirmed by allyreckerman (Microsoft)
Solution

@Intodeep 

 

In that context, I would suggest to just gather the data in one transaction table, and use the pivot table to track the numbers in that manner as you go along, then you will start to see a trend and develop an analysis strategy which will dictate which excel functions you're going to be using to formulate equations for a specific analysis of the data set you have gathered.

 

watch this video to get an idea of what I'm talking about:

https://www.youtube.com/watch?v=e-CFYi52gpc

Thank you for your help, the video was great, and helped me out.

@Intodeep 

 

I'm glad it forged your goal to a much more specific target.  Have a great weekend.

 

cheers