op_cvov
A utility that extracts scalar and vector information from an output vector file (file type suffix .ov) into a tab-delimited text file (.csv) so that it can be imported into a spreadsheet and analyzed.
Description
Exporting data from the Results Browser might be inconvenient when dealing with a very large number of vectors. You can use op_cvov to extract selected information from one or more output vector files. For example, you can
- Get a list of all the vectors “names” (list of hierarchical names, possibly restricted by some regular expression)
- Extract data for selected vectors (based on a list of vector names)
- Extract scalar data
Preferences
This program supports the following preference sets:
- “Standard Preferences”
- “Development” preferences
- “Diagnostics” preferences
- “User Lock” preferences
This program also supports the following additional preferences.
data_precision
Specifies the maximum number of decimal digits for data values.
- Type: integer
- Default Value: 12
m
Specifies a list of files to extract statistics from. Files can be specified in three ways:
“<project-scenario>-DES-<run#>”refers to a specific output file“<project-scenario>”refers to all output files for that scenario“<project>”refers to all output files for all scenarios in that project
This preference is required and can be entered only from the command line.
- Type: string list
- Default Value:
<empty>
nosymbols
Specifies whether symbolic values should be used in the output. When TRUE, symbolic values will not be used when a numerical value is available.
- Type: boolean
- Default Value: FALSE
output_file_path
Specifies the name of the output file for output data (tab-separated). The file path and file type suffix must be included in the value of this preference. This preference is required and can be entered only from the command line.
- Type: string
- Default Value: none
scalar
Specifies whether scalar information should be extracted from the specified files. When TRUE, scalar information is extracted. This preference can be entered only from the command line.
- Type: boolean
- Default Value: FALSE
thousand_separator
Specifies whether the thousands separator for the current locale should be included in numbers. When TRUE, the thousands separator is included.
- Type: boolean
- Default Value: FALSE
time_precision
Specifies the maximum number of decimal digits for time values.
- Type: integer
- Default Value: 12
vector_data
Specifies whether vector information should be extracted from the specified files. When TRUE, vector information is extracted. This preference can be entered only from the command line.
- Type: boolean
- Default Value: FALSE
vector_data_format
Specifies which data rows to generate for each statistic before the time/data portion of the output. The rows are generated in the order of the characters in the string. The string value for this preference uses the following characters:
-
H– hierarchical name -
O– object name -
S– statistic name -
R– report -
F– file name -
d– date -
h– hour/min/sec -
a– annotation -
#– number of elements -
Type: string
-
Default Value: “HOSRFdha#”
vector_header
Specifies whether vector header information should be extracted from the specified files. When TRUE, vector header information is extracted. This preference can be entered only from the command line.
- Type: boolean
- Default Value: FALSE
vector_header_format
Specifies which data columns to generate for each statistic header entry after the file name. The columns are generated in the order of the characters in the string. The string value for this preference uses the following characters:
' '– (space or tab): extra columnH– hierarchical nameO– object nameS– statistic nameR– reportF– file name (required to display the following elements)d– dateh– hour/min/seca– annotation#– number of elementst– min timeT– max timem– min valueM– max value[– first value]– last valuee– expected value-– sample meanv– variances– standarddev
H, O, S, R information is only printed for the first file.
- Type: string
- Default Value: “HOSRFdha#tTnM[]e-vs”
vector_max_time
Specifies the maximum simulation time for reporting data. Statistic data generated after this time is not extracted from the output vector file. Negative values indicate the end-of-simulation time. This preference can be entered only from the command line.
- Type: double
- Default Value: –1
vector_min_time
Specifies the minimum simulation time for reporting data. Statistic data generated before this time is not extracted from the output vector file. This preference can be entered only from the command line.
- Type: double
- Default Value: 0
vector_patterns
Restricts the vector output to statistics that match one of the specified hierarchical patterns. The patterns can contain the following tokens:
*– can be used to represent any item in the full hierarchical name…– can be placed at the beginning or end of a pattern to indicate, respectively, any prefix or suffix to the rest of the pattern
This preference is required and can be entered only from the command line.
- Type: string list
- Default Value: “”
verbose
Specifies whether op_cvov should generate progress information as it runs. When TRUE, progress information is generated. This preference can be entered only from the command line.
- Type: boolean
- Default Value: FALSE
Example Usage
Example of output for a scenario with 4 runs (just one statistic from the group):
% op_cvov -output_file_path /home/abc/mydata.txt -vector_header -vector_data -m s89050-modeling_approach_purely_micro_simulation
Hierarchical Name Annotation Statistic Report File Start Date Start Time Annotation # elements Min Time Max Time Max Val 1st Val Last Val Expected Value Sample Mean Variance Standard Deviation
Dallas <-> Atlanta [0].point-to-point.queuing delay (sec) --> Dallas <-> Atlanta [0] --> point-to-point.queuing delay (sec) s89050-modeling_approach_purely_micro_simulation-DES-1 101 0 1500 0.000008179012 0.000005709877 0.000003858025 0.000003900892 0.000003900892 0 0.000000504719
s89050-modeling_approach_purely_micro_simulation-DES-2 101 0 1500 0.000008179012 0.000005709877 0.000003858025 0.000003900892 0.000003900892 0 0.000000504719
s89050-modeling_approach_purely_micro_simulation-DES-3 101 0 1500 0.000008179012 0.000005709877 0.000003858025 0.000003900892 0.000003900892 0 0.000000504719
s89050-modeling_approach_purely_micro_simulation-DES-4 101 0 1500 0.000008179012 0.000005709877 0.000003858025 0.000003900892 0.000003900892 0 0.000000504719
...
Hierarchical name Dallas <-> Atlanta [0].point-to-point.queuing delay (sec) -->
Object Dallas <-> Atlanta [0] -->
Statistic point-to-point.queuing delay (sec)
Report
File s89050-modeling_approach_purely_micro_simulation-DES-4 s89050-modeling_approach_purely_micro_simulation-DES-4 s89050-modeling_approach_purely_micro_simulation-DES-4 s89050-modeling_approach_purely_micro_simulation-DES-4
Start date unspecified unspecified unspecified unspecified
Start time unspecified unspecified unspecified unspecified
Annotation
Number of values 101 101 101 101
Sim time Value Value Value Value
0 0.000005709877 0.000005709877 0.000005709877 0.000005709877
15 0.000008179012 0.000008179012 0.000008179012 0.000008179012
30 0.000003858025 0.000003858025 0.000003858025 0.000003858025
45 0.000003858025 0.000003858025 0.000003858025 0.000003858025
60 0.000003858025 0.000003858025 0.000003858025 0.000003858025
...
1485 0.000003858025 0.000003858025 0.000003858025 0.000003858025
1500 Vector end Vector end Vector end Vector end