A Data Block Spreadsheet file contains columns of text separated by delimiters such as commas or tab characters.
It is strongly recommended that you use the Data Block Spreadsheet format (.TXT) as a text file template. (See instructions below.)
In a Data Block Spreadsheet file, each column (or pair of columns) is assumed to contain samples of data for a single measurement function (time waveform, Auto spectrum , etc..
A single column is used for real data, two columns for complex data.
The header is optional. If there is no header, each column of data is assumed to be a real valued time waveform, and all other header information is set to default values.
A Data Block Spreadsheet file can also contain a file header which consists of,
A Keyword followed by a Value
A Value is separated from its Keyword by the same delimiter used to separate data values in the spreadsheet columns.
Keywords and example Values are listed in the Table below.
Keyword |
Value |
Description |
Measurement Type |
Time Waveform, Fourier Spectrum, Auto & Cross Spectrum, Auto & Cross Correlation, PSD , FRF , Coherence, IRF. |
Default: Time Waveform for time domain, Linear Spectrum for frequency domain. Time Domain: each column is a Trace. Frequency Domain: each pair of columns is a Trace. |
Label |
Any text |
Data Block description. |
X Axis Spacing |
Uniform, Non-uniform, No X Data. |
No X Data: Defaults (Uniform Spacing, X Start = 0, X Step = 1) Uniform, Non-uniform: first column is X Axis values. |
X Axis Units |
Any text |
X axis time or frequency units. |
Y Axis Type |
Magnitude, Real/Imaginary |
For complex data only. Magnitude denotes magnitude & phase, Real/Imaginary denotes real & imaginary data. |
Measurement Label |
Any text |
measurement label |
Y Axis Units |
formatted text |
(output units) / or * (input units). Examples: Gs, Gs/N, Gs*Gs. |
Y Axis DOFs |
formatted text |
Roving DOF : Reference DOF [Meas. Set]. Examples: 1Z, 1Z:3Z, 1Z:3Z [1]. |
Remark |
Any text |
Not read |
Keywords &Fields of an ASCII Text Data Block (.TXT) file.
The best way to put measurement data into a (.TXT) file format is to start with an ME'scope Data Block file as a template, and add your data to it using a spreadsheet or text program To create a (.TXT) file template, open any Data Block file in its window in ME'scope.
Open a time domain Data Block if you want to import time domain measurements
Open a frequency domain Data Block if you want to import frequency domain measurements.
Execute File | Export Data Block and save the file in (.TXT) format.
Open the (.TXT) file in a spreadsheet program like Microsoft Excel or a word processor like Microsoft Word.
Replace the measurement data into the spreadsheet columns with your own measurement data.
Edit the other information where applicable, and save the file to disk.
Make sure that the (.TXT) file is no longer open in the spreadsheet or word processor program before importing it into ME'scope.
Execute File | Import | Data Block in the ME'scope window and import the (.TXT) File into an ME'scope Data Block file