Statistics Translator to MS Excel

Standard package

 The Wac_excl.exe program, supplied with the Clarinet System Run-Time package in the \Clatools directory, carries out the translation of a statistics event file (Clarinet-System version 2.2 or higher) into an an MS Excel XLS type file (data format version 2.0).
wac_excl [-f -o -p] <file>
-f<filter>

Defines the path+filename of the default filter used (Counters and Display specifications) to process and convert the statistics event source file into a MS Excel XLS file.

If there is no declared default filter, the filter file \Clatools\TAC_DFT.ASF is used.
-o<file> Defines the name of the output file (.xls), if it has a different name from the source file. By default, the basename of the output file is the same as the source file.
<file> Defines the path+filename of the source statistics event file.


Export to Excel

An MS Excel XLS type file can be automatically generated On-line during the profile execution in the following conditions:-

  • The profile currently being executed specifies a statistics event file.
  • The Wac_excl.exe program is defined in the current configuration file as a test application Process, which is launched by the Manager after each profile execution.
    The Clarinet Manager must be restarted after any modification of the current configuration file.

ini_process_excl.jpg (15051 octets)

Note: The parameter -p (parallel processing) must be specified when the program is defined as process launched at the beginning of the application.


Import to Excel

Standard package

 The Wac_excl.xla complementary macro, supplied with the Clarinet System Run-Time package in the \Clatools directory, can be installed in MS Excel, and provides functions to import the data related to the processing of a statistics event file through a statistics filter file (launching the Wac_excl.exe program) and to format it.
MS Excel must be version 4.0 or higher.

Tools

 For installing wthin the MS Excel environment:-

Add-Ins

 To include the Excel Translator in the set of the active Add-Ins.
This operation is to be carried out only once, for the Wac_excl.xla file being recognised by the Add-Ins manager.

File

 For operating within the MS Excel environment:-

Load Statistics

 To launch the complete loading of the Wac_excl.xla file for accessing the Statistics functions set.

Statistics

 For accessing the Statistics functions of the Excel Translator Interface, concurrently with the use of the Toolbar buttons.
Available only after the complementary macro has loaded.


Excel Translator Interface

Icon

Function

 Description

Import
 To import the data related to the processing of a statistics event file through a statistics filter file.

exclxla_import.jpg (12761 octets) exclxla_select.jpg (14501 octets)

Auto Format
 To format the data within the MS Excel environment, and especially modify the DATE column for a more standard display.
The spreadsheet must be a spreadsheet generated by the translator and must have the Report keyword in the header of each table containing statistics counting values. If the sheet has been modified and no longer contains this keyword, the user must use a built-in MS Excel function to format the table.

Record
 To save the active document in the current format. As the statistics events files were created in the MS Excel data format version 2.0, this function allows automatic conversion to the current MS Excel version format.


Result spreadsheet before being formatted

After the import operation has ended, the results file can be opened to display the results spreadsheet. The table shows the following information in the header:-

  • The name of the source file and the name of the filter file used.
  • The counter values in a table. The column names correspond with the counter names and rows are the dates of samples.

The date consists of two parts:-

  • The whole part represents the number of days that have elapsed since 1900.
  • The decimal part represents the fractional part of the day that has elapsed from 00:00:00 (hours:minutes:seconds) up to 23:59:59.
  • For example 34085.8656 is equal to 04/26/1993 at 20:46:32.

 

home     Quick start     Specifications     Connections     Features     How to?     Notes     Search     Site Map