Analyzing data in collections of classes?
Ker writes: "Once I have my data loaded from my worksheet into the
objects, my analysis
will be to look for specific patterns; What was the total amount of
vanilla
ice cream purchased from Brand_C as compared to vanilla ice cream
purchased
from Brand_X, excluding purchases where Brand_X was purchased in the
same
transaction as any items from Brand_Z? "
Don't load the data into the worksheet. If it's not loaded into a
database already, load it into a database. Let the database handle the
queries like this one.
|