How to Display

S

Steved

Hello From Steved

I receive data each Day from 7 different Locations
Col A I have 01-Jun the first to Last Day of the month.
Col B I have Day formated as TEXT(A1, "ddd")
Col C I have Data

Based on a calendar Month.

In your opinion how would I best design a database,
so that the information can be displayed row wise per week.
The reasoning behind this is so the data from a location
can be checked against the day before. Data from a
Location is similar, but from time to time the data can be
wrong hence the need to put it in a format so that I can
check for any errors.
Thankyou.
 
B

BrianB

Most of my job for the last 15 years has been related to analysing an
reporting data from large databases. I think that the ideal method i
to have *all* the base data in a single unformatted table. This the
allows several very powerful functions to become available for use
especially pivot tables. If the data table gets bigger than Excel'
65,536 rows then it goes into Access. It is also extremely flexible.

I think that you have only gone part of the way that you could
although you seem to be grasping the principle. I suggest the additio
of 3 columns. Month, Week Number, Location - and that you pu
everything into a single table. As new data arrives it goes to th
bottom of the table and the empty columns populated. With pivot table
you can then view the data in practically any way you want. Takes
couple of minutes to set up, seconds to update. When changes occur yo
only have to change the raw data table. The drilldown is only
doublemouseclick away.

Do not try formatting your data or pivot tables. If you need a prett
summary report then make one and link to a special PT via =VLOOKUP()
You might need to make up a special indexing column concatenating othe
columns. The data flow is raw data ->to Pivot ->to Report
 
Top