I developed a data logger for a computer simulation that people
interact with. The logged data is stored in a tab deliminated text
format. That data can be imported into Excel. I bring in different
subjects and have them test the simulation while I log their usage of
the simulation. I would like to be able to coalesce the logged data of
all the different subjects data into meaningful statistics about the
simulation. I can log the data by time or by room the person is in the
simulation. The data logged per time slice or per room is health,
amount of object 1, amount of object 2, etc. So it would look like the
following:

Loc : Room 1 - Room 2 - Room 3
Health : 125 127 103
Object1: 5 7 10
Object2: 1 0 5

or if time based like the following:

Time : 20 sec - 40 sec - 60 sec
Health : 125 102 103
Object1: 4 3 10
Object2: 0 1 7

I could have anywhere from 5 to 100 sets of tests from different
people. I would like to be able to coalesce the logged data so that I
could find information like:

On average people have a health of 104 in room 1, on average people
have 4 units of object 1 in room 3, etc.

Is there an easy way to do this in Excel? If you could just point me in
the right direction I would appreciate it. If there is not an easy way
to do this is there a way to bring it into a SQL database and then use
Excel to analyze the data?

Thank you in advance for any help on this!

Best Regards,
John