 |
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, as illustrated to the
left. To do this, one would:
- Run instruNet World.
- Select channels for digitizing in the Network Page.
- Press the Record tab.
- Press the Setup button to open the Setup dialog. Select Digitize Into: To Ram Buffer, select File Type: Text Merge, select the desired Sample Rate, select the desired Pts Per Scan, set the No of Scans to 1, and 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; and also supports the digitizing of data directly into an Excel spreadsheet, in realtime, via the Direct To Excel program.
|
 |