jalsina
03-01-2007, 06:23 AM
Greetings! Joined this board in hope of getting advice on how to tackle a data logging/robotics job.
The job involves acquiring a bunch of data samples and transmitting them to Excel for analysis and long-term storage.
The data consists of pressure measurements generating by pushing a sensor against a Thing To Be Tested.
The test cycle lasts about 1 second. I need 512 8-bit samples per cycle, so the time available to take and store each sample is about 2 mS.
There are 128 Things To Be Tested, with a delay of about 1 second between test cycles.
So I either need to be able to store 512 x 128 = 64K of data for batch transmission to Excel at a later time,
or I need to send the 512 bytes acquired during each cycle to Excel during the 1-second interval before the next cycle begins.
I would like to accomplish this with stock components, but don't see how I can achieve the required sampling speed and data capacity without custom hardware.
How would you approach this job? If special hardware is required, what would it be?
Thanks for your thoughts.
J Alsina
The job involves acquiring a bunch of data samples and transmitting them to Excel for analysis and long-term storage.
The data consists of pressure measurements generating by pushing a sensor against a Thing To Be Tested.
The test cycle lasts about 1 second. I need 512 8-bit samples per cycle, so the time available to take and store each sample is about 2 mS.
There are 128 Things To Be Tested, with a delay of about 1 second between test cycles.
So I either need to be able to store 512 x 128 = 64K of data for batch transmission to Excel at a later time,
or I need to send the 512 bytes acquired during each cycle to Excel during the 1-second interval before the next cycle begins.
I would like to accomplish this with stock components, but don't see how I can achieve the required sampling speed and data capacity without custom hardware.
How would you approach this job? If special hardware is required, what would it be?
Thanks for your thoughts.
J Alsina