Forum Discussion
Trying to do a weekly tracker for excel
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
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.
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.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