I decided on a 2d array because if I use a 1d array and pass it to excel as a single row or column there would not be enough cells in a single row or column to hold all the data samples.
The data is, believe it or not, coming from a hamster wheel - well an opto sensor on an eight segment disc attached to the wheel.
So if hammy is doing 4 rev/sec
4X8X60=1920 timings per minute
=1920x60x12= 1,382,400 timings to be stored in a 12 hour period.
All this is not fixed in granite as it's a project under development.
I can see that I may have to do a more data processing in the vb.net prog before passing to excel to get my fancy graphs. Just wanted to get it in excel early as vb.net is something I am still weak on.
Bookmarks