Teledyne LeCroy SAS Suite User Manual - Manual (Page 279)

SASSuite User Manual Version 6.25
LeCroy Corporation
269
When the file is opened, a large spreadsheet similar the following will appear:
This spreadsheet will have a large number of columns (most of which are blank). This
format is used for all SASSuite data exports, and many of the columns will not have
application to SASTracker data files.
The first row of the spreadsheet contains the titles for each column. Remaining rows
contain information on each completed command that was present in the exported data.
Since there are many blank columns (for data values which are not used in SASTracker
Command Log Files), these columns can be deleted to simplify the spreadsheet. If a very
large number of events has been exported, it may be difficult to be sure that no data exists
anywhere in a column. In such cases, insert an extra row just below the column titles and
enter a formula similar to "=1000 - COUNTBLANK(A3:A1002)", and copy this value
across all columns. In this example (which assumes 1000 exported events), all blank
columns will show "0" as the result of this function and may be deleted. Any column with
data will show the number of cells that contain data in that column.
Some data is exported as text fields which represent numeric values. For example, the
command completion time will be exported as fields such as "234.245 us" or "3.456 ms".
In order to convert these text fields to values which can be sorted and otherwise
manipulated, create a new column next to the "COMPL TIME" column and enter a
formula such as the following into the first data row of the new column:
=IF(P2="","",IF(RIGHT(P2,2)="ms",1000*VALUE(LEFT(P2,LEN(P2)-3)),
VALUE(LEFT(P2,LEN(P2)-3))))
This formula assumes that the original data value is in cell P2. The formula first checks
to see if P2 contains any data (if not a blank value will be inserted--this is typically the
case for command fragments such as incomplete commands or orphans). If data exists,
the formula determines whether the units used are millisecs ("ms"), in which case it
extracts the numeric value of the cell and multiplies it 1000. If the units are not ms, then
the formula extracts the numeric value as microseconds. The result (for data that
contains only millisec and microsec values), is a column with completion times all in
microseconds.