Forum Discussion
Solved
best practice for excel Data base
Hello, I have the workbook that contains information about 20 health Centers and mobile teams that we collect the data from them in weekly basis. I would like to know the best practice to accumu...
Jihad Al-Jarady Well, then you could consider to stop doing the intermediate summary by week and work off a table that may contain max 140 rows (20 centers X 7 days) per week, as long as every row has a date to that you can "calculate" the weekly numbers.
I appreciate your help.
The data is collected in daily basis, but we use it for weeks.
Many thanks
Jihad Al-Jarady Well, then you could consider to stop doing the intermediate summary by week and work off a table that may contain max 140 rows (20 centers X 7 days) per week, as long as every row has a date to that you can "calculate" the weekly numbers.