This is probably a naive question because I am an extreme novice of
Labview...
A coworker of mine has a complicated program that takes raw binary data
containing modified voltages and polarity information for each data
point (+ or -) saved from a data acquisition and constructs a waveform
graph from scratch using certain entered parameters (scan rate, and
converts the binary data to a 2D voltage array using arithmetic
operations and the polarity information), with the end result of
getting a voltage vs. time plot.
I would like to actually use and be able to manipulate data in Excel
and have some binary files that only contain modified voltage data. It
would be nice if I could take the datapoints used by Labview to
construct the waveform graph and write this to a spreadsheet file. If
this is possible, how could this be accomplished? At this point, I
can't even remember how to concatenate arrays to 2D data that could
then be fed to the Write to Spreadsheet.vi, but perhaps this is a way
to go about it?
Also, I'm looking for any example .vi's that show methods of scanning
through spreadsheet data and intelligently selecting certain data
points to write to a new file (eg. record point every time the voltage
changes 0.005 V or more between points OR every 5 seconds, whatever
comes sooner). Our scan rate is extremely fast due to the need for
detail in the first 0.2 seconds of acquisition, but after this point
the scan rate cannot be changed on our board, and the acquisition
continues another 10 minutes. When I converted a raw binary file to
txt, it was 17 MB for a single file, and Excel would only open the
first 64000 rows. I'm more comfortable with Matlab so may resort to
using this instead of Labview.
Thanks for any assistance.
