Rion VA-12 Скачать руководство пользователя страница 25

Страница: 25 / 27

6.4 Data import to Microsoft Excel

Since a measurement data file is written by CSV format, the data can be imported into Microsoft Excel.

①

Starting Microsoft Excel

Start Microsoft Excel and execute file open. The file open window appears as shown in the following figure.

In this window, select the folder to import for example MAN_9999. In this stage, since the file type is set to

All Excel Files, "No items match your search" is displayed and data files are not displayed.

②

Selecting the file type to “All Files”

Select the file type to “All Files”. Then the data files with extension name RVD are displayed.

File type

Содержание VA-12

Страница 1: ...ion 2 Measurement in Vibration Meter Mode 3 Measurement in Time Waveform Mode 4 Measurement in FFT Analyzer Mode 5 Examples of typical vibration measurement 5 1 Diagnosis of unbalance and misalignment...

Страница 2: ...sis functions Vibration Meter Mode Time Waveform Mode and FFT Analyzer Mode The operation about common setups to each analysis function before starting measurement is explained in this section Inserti...

Страница 3: ...7I Other accelerometers than PV 57I Optional accessory When the amplitude of vibration is too small or too large or the frequency is too high the PV 57I cannot measure them In that case an acceleromet...

Страница 4: ...ching the accelerometer it is necessary to wait about 30 seconds until the influence of the impulsive vibration disappears Moreover it is necessary to care about the contact resonance frequency of the...

Страница 5: ...selectable Input range setting Set the input range to the optimal setting The optimal setting is to use the lowest range where an overload does not occur The key changes to the higher range the key ch...

Страница 6: ...ured data Store the data if necessary When the STORE key is pressed the data at that time is stored on SD card in VA 12 When in a paused state the fixed data is stored 3 Measurement in Time Waveform M...

Страница 7: ...igher range the key changes to the lower range By changing input range an electric transient noise occurs and overload may be displayed In this case it is not an excessive input of vibration When an o...

Страница 8: ...key The measurement changes to the paused state and a measured time waveform is fixed To resume the measurement press the PAUSE CONT key one more time Zooming the X axis and the Y axis of the graph d...

Страница 9: ...STORE key is pressed the data at that time is stored on SD card in VA 12 When in a paused state the fixed data is stored 4 Measurement in FFT Mode Selecting the analysis function to FFT mode after com...

Страница 10: ...hout repetition like a single pulse Hanning It is used for the usual measurement Flattop It is used for reading the amplitude correctly although the frequency resolution may be worse Selecting the mea...

Страница 11: ...y span and the Number of analysis lines In order to determine the maximum frequency to analyze and the frequency resolution the frequency span and the number of analysis lines are set up The frequency...

Страница 12: ...e average is not necessary since the vibration is steady The operation type is chosen as follows according to the measurement purpose Linear average It is a popular averaging type and is used to obtai...

Страница 13: ...rum In Linear average or Maximum hold the operation stops when the average counter reaches to the average number and the FFT spectrum is fixed In Instantaneous measurement or Exponential average the o...

Страница 14: ...is assumed that the cursor move symbol is displayed at first If the Graph zoom symbol is displayed at first press the SCALE EXPAND MOVE key to change the zoom mode Move the cursor to the position whe...

Страница 15: ...d in VA 12 When in a paused state the fixed data is stored STORE key PAUSE CONT key Original graph Move the cursor to the position you want to expand Expand 4 Expand 8 Expand 16 Cursor Cursor SCALE EX...

Страница 16: ...are investigated by Time Waveform Mode or FFT Analyzer Mode In unbalance condition only a shaft rotational frequency appears but in misalignment condition a shaft rotational frequency and its harmonic...

Страница 17: ...udgment is abnormal the precise diagnosis is carried out In precise diagnosis the defected part can be predicted by FFT analysis of acceleration envelope if the information about the bearing to diagno...

Страница 18: ...of VA 12 about the details of the trigger function When an exciting point and an attached point of the accelerometer changes to the other position the measured frequencies may change In this case all...

Страница 19: ...e trigger ON Trigger level 1 8 2 8 Slope The trigger conditions are set in the submenu Measurement Press the MENU key and go into the submenu Measurement from the Menu List A measurement example of na...

Страница 20: ...ddress is indicated at the upper right corner of display This store address means the address contained in a Store Name which was set up at the previous step The measured data can be stored in the ind...

Страница 21: ...e the selected data is recalled and the character Recall is displayed at the upside center The recall address can be selected by keys Returning to the measurement state The START STOP key is pressed t...

Страница 22: ...reen bitmap image Press both the MENU key and the ENT key simultaneously When the storing is started the indicator blinks red It disappears after completed Recalling the screen bitmap image Press both...

Страница 23: ...s the SD card in VA 12 as a removable disk All stored files exist in the VA 12 folder The folders MAN_ include measured data files means 4 digits number The folder name MAN_ is same as the Store Name...

Страница 24: ...following figure there are six data files in the folder MAN_9999 The extension names of the data files are RVD Copy required data files to another folder in a computer Copying BMP files The stored BM...

Страница 25: ...The file open window appears as shown in the following figure In this window select the folder to import for example MAN_9999 In this stage since the file type is set to All Excel Files No items match...

Страница 26: ...ining that the selected file is delimited After clicking the Open the Text Import Wizard Step 1 of 3 appears as shown in the following figure In this wizard select the Choose the file type that best d...

Страница 27: ...ile After clicking the Next the Text Import Wizard Step 2 of 3 appears Check the checkbox of the Comma Then click the Finish Importing the data to Microsoft Excel After clicking the Finish the data ar...