Explanaton, Excel and text converson specfcatons – Yokogawa Button Operated MV2000 User Manual
Page 82
4-30
IM 04L47B01-01EN
Explanaton
If the data targeted for conversion that is being waveform displayed has multiple intervals
and no values, you can specify to use nearby data to fill it in, or to leave it blank. Event
data is filled in with previous values, and display data is filled in with subsequent values.
For [Cell without value] in the conversion dialog box, set [Padding] or [Not padding].
Regarding alarms, marks, and messages, conversion results are saved to separate
sheets within the same file.
Settngs for Excel/Text converson of data under waveform dsplay
Settng tem
Descrpton
Start tim
Cannot be changed
When cursors displayed:
time at left cursor position
When cursors not displayed: start time
Stop time
Cannot be changed
When cursors displayed:
time at right cursor position
When cursors not displayed: stop time
Specify group
Set from 1 to 50 groups
Cell without value
Fill with previous values, fill with subsequent values, or leave blank
Set converson to Excel or text by fle (same as automatc converson of watch folder)
Settng tem
Descrpton
Number of steps
Specify the number of steps of data to convert
Number of steps specification range: unlimited, default is 1 step
1 step: all data converted
1st data must be converted
Folder
Specify location for changed data
Excel and text converson specfcatons
Data is converted to Excel or text per the following specifications. Conversion
specifications for watch data are the same as those for conversion by file.
Specfcatons for converson to Excel of data under waveform dsplay
Item
Descrpton
Format
Excel 98 worksheet
Group
Separated by sheet
Initial file name setting
When converting from waveform display screens: graph.xls
Restriction
If the limits of Excel are exceeded, conversion results are assigned a
serial number and divided
Alarm/mark conversion
Marks and alarms are converted at the same time as the waveform
conversion, and saved to a separate sheet in the same file
Specfcatons for converson to text of data under waveform dsplay
Item
Descrpton
Format
Tab delimited text file
Group
Files divided
File name: filename_groupname(group number).txt
Example: Graph1_Group1(01).txt
Initial file name setting
When converting from waveform display screens: graph.txt
Restrictions
If the limits of Excel are exceeded, conversion results are assigned a
serial number and divided
Alarm/mark conversion
Marks and alarms are also converted and saved when waveforms
are converted
Mark file: filename_marklist.txt
Alarm file: filename_alarmlist.txt
4.9 Data Format Converson