SAVE DATA TO EXCEL, POST ACQUISITION,
VIA INSTRUNET WORLD SOFTWARE SOFTWARE > INSTRUNET WORLD SOFTWARE (iW) >
Saving Data After Digitization Is Complete
Exporting a file to a spreadsheet, post-acquisition, is done by first acquiring data into instruNet World software,
saving it to disk in the form of a text file, and then opening that text file with a spreadsheet program, as illustrated to the
right. To do this, one would:
Run instruNet World.
Select channels for digitizing in the Network Page.
> set Digitize Into to To Ram Buffer,
> set File Type to Text Merge
set the desired Sample Rate
> set the desired Points per Scan
set the Number of Scans to 1
set Scan Mode to Oscillo
If you want to show the date and time of each point in the left most columns of your spreadsheet, as pictured below, press the "More" button and set the Text Format field to Day Time (this requires instruNet software version ≥ 3.0). Alternatively, this field is set to Point Time and the left most column shows the number of seconds since the start of digitization, for each data point.
Press OK to exit the dialog and to return to the Record page.
Press the Network tab, press the Save button to save these settings to disk, and then press the Record tab to return to the Record page.
Press the Start button to begin recording, and the Stop button to stop recording.
Press the Save button in the Record page (or, if running instrunet World+, one can select Save Waveforms To Excel in the Record menu) to save the data to disk in a text file named "Excel Waveform Data.txt". This file places each channel in its own column, and looks something like the aboveillustration when opened with a spreadsheet program.
Columns are separated with TAB characters, and rows are separated with CARRIAGE RETURN characters.
Saving Data To Excel While Digitizing
instruNet supports the acquisition of data into instruNet World with Export to a spreadsheet, post-acquisition as described above; and also supports the digitizing of data directly into an Excel spreadsheet, in realtime while digitizing, via the Direct To Excel program.