Z-Transform Scrollsheet statement

 [/h/]Ztsc
   [[/h/]Optn[=Ext-Clr-Dskip-Tskip]]
   [/h/]iFile[=file_name]

Type conventions and statement syntax are explained in the Glossary.

Parameters...

Optn
Check box parameter indicating execution options. Default = None, else any combination of the following options:

• Ext = use external reference table to determine mean and SD,
• Clr = clear column if no external reference available,
• Dskip = skip columns of type date,
• Tskip = skip columns of type time or hours.

iFile
File parameter indicating the scrollsheet file to be used as external reference. Must be specified if Optn=Ext. You may specify Wintrack scrollsheet files (.WTB), tab-delimited text files (.TXT), comma-delimited text files (.CSV), and space-delimited text files with fixed column width (.LOG).

Note that...

The Clr option of the Optn parameter is only considered if the Ext option is selected as well. The iFile parameter is only relevant if Optn=Ext. When encountering a text file, Wintrack determines the column/field delimiter as follows. If the file contains any tab-characters, tab is used as delimiter. Else, the file is scanned for commata. If any are found, comma is used as delimiter. If a file contains neither tabs nor commata, it is assumed to be space-delimited with fixed column width. Tab-delimited text is the preferred format for data import from other applications. In this format cell data may contain spaces and/or commata. Space-delimited files may not be imported correctly if they contain empty cells.

Additional information...

• See the topic Z-Transform Scrollsheet command for basic information on the command.
• Inside scrollsheets provides advanced information on scrollsheets.
• See Creating and using macros to learn how to use and create macros.
• There are lists of all available macro statements and menu commands.