Need suggestions on structuring this data

Jester87

Hey guys,

I need input on how to store and analyze the data I am collecting. Basically, I am monitoring about 900 different "bins." Every ten minutes I record the number of items in each different bin, and the "alpha level" associated with each bin. Each bin has a maximum number of objects, and I've casually noticed that some bins hit max units and never fluctuate, while others flow up and down.

Right now I have it structured as follows (saved as a CSV file that appends every run):

Bin Name, Alpha Level, Bin Item Count, Bin Item Capacity, Date of recording

Again, my goals are :

1. Find Trends in alpha levels and item counts
2. Efficiently store and analyze my data ( I have limited resources - both computing power and bandwidth)

Suggestions?  TYIA

EDIT: Alpha Level, Bin Item Count, and Bin Capacity are real numbers, Bin Name is a string, and Date is obviously a date.

MariusHelf

Hi Jester,

are you aware of our Value Series Extension? It is made for analyzing series of data, as you actually have: for each bin, the item numbers form a series of values over time. If you need help with the series extension, please post your issues here.

Best regards,
Marius