best practice for excel Data base

Jihad Al-Jarady The Consultation table is totally acceptable and it enables you to connect to it with PQ and easily create the kind of table I created so that you can build a pivot table on that one. You don't need to collect data as in the green table.

I was just wondering how you came up with this aggregated data. Is someone counting visits for e.g. males in a particular age group, this week, with a particular diagnosis to return the number 14? If so, how does that raw data look like? If it is a sequential list of visits in Excel with relevant patient info and diagnosis, you could connect to those lists directly, without the need to create the Consultation table.

In other words, if a medical facility produces a list with say 1000 records, one for each visit, you could use PQ to summarize it for you and determine that there were 14 boys under 5 years old with lower respiratory infections among those 1000 visits. And those lists/tables may contain thousands of rows and you can have many of them. As long as they are consistent (i.e. the same structure for every medical center) it's going to be relatively easy for PQ to prepare the basis for further analysis.