Hello,

I couldn't decide where to post this, so it goes into general discussion...

I have recently received the results of a vibration test conducted in a university laboratory; and the results data (autospectrum and frequency response data) are given in Universal File Format. I haven't worked with the Universal File Format before, so I'm a little confused about how to handle the data. Here are the inputs of my question:

* The files are in "Universal Dataset Number 58". I have recieved the corresponding key file and understood most of it. Ordinate is real and single precision; the abscisse is evenly spaced with increments of 4.0Hz. As far as I understood, the data in the columns are ordered like this:

Y1 Y2 Y3 Y4 Y5 Y6

Y7 Y8 Y9 Y10 Y11 Y12

Y13 ... ...

* The test was a random vibration test ranging from 5 to 2000 Hz for a total of 19,18 Grms.

The problem, or what I fail to understand is that, the file has 6401 values as data (total of 1067 lines with 6 columns), and the file says it starts from 0Hz with increments of 4.0Hz at every point. So this takes the end frequency to 25604Hz! I'm considering if the beginning and end points of the data are 0 and 2000 Hz as in the test, but there are more data points due to sampling (or resolution). Could this be possible? Seems unlikely because this is not time domain, but then again, I'm not very educated on the subject.

I'd also love any help that could make me plot these files on Excel. I can also use Matlab but the company has limited number of licenses and I generally can't get to use Matlab.

I hope I've stated my question clear enough. Thanks in advance for all the help!

1## Re: Help regarding universal file format