Importing a Data Block Spreadsheet File

Column Format

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..

Header Format

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,

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.

Creating a (.TXT) File Template

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.

Adding Your Data to the Template

Make sure that the (.TXT) file is no longer open in the spreadsheet or word processor program before importing it into ME'scope.

Importing the (.TXT) File