Create New Document - Spreadsheet Tab

Select the Spreadsheet tab of the Create New Document dialog box to access options to create a new spreadsheet file (*.sta) with a specified number of variables and cases. See the Spreadsheet Overview for more information on spreadsheets and how they can be used in Statistica.

Number of variables

Type a number in the Number of variables box (or use the accompanying microscrolls) to specify the number of variables (columns) to include in the new spreadsheet. Right-click the microscrolls to increase the number by increments of ten ( 10, 20, 30, ...).

Number of cases

Type a number in the Number of cases box (or use the accompanying microscrolls) to specify the number of cases (rows) to include in the new spreadsheet. Right-click the microscrolls to increase the number by increments of ten (10, 20, 30, ...).

Case name length

Specify here the length of the case names (displayed in the first column of the data spreadsheet) for the new file; leave the default value 0 if the new data file should not have case names.

MD code

Specify here the default missing data code for blank cells or specific values that you intend to ignore in calculations. Note that the missing data code for a text data type is always an empty string (see also Variable Types).

Default data type

Choose the default data type for the variables in the new data file (see Variable Types).

Variable length. This option is available only if Text is selected as the Default data type (see above). Specify a maximum number of characters for variables.

Placement

Use the options in the Placement group box to choose whether to create the spreadsheet within a new workbook or as a stand-alone document. For more information about workbooks, see the Workbook Overview.

In a new Workbook

If you select this option button, Statistica creates a new workbook and inserts the new spreadsheet inside it. Note that if you select this option and later decide you want to save the spreadsheet as a stand-alone file, you can extract the spreadsheet (or a copy of it) from the workbook using either the Workbook Extract Original or Workbook Extract Copy option.

As a stand-alone window

If you select the As a stand-alone window option button, Statistica creates the spreadsheet as a single document (not part of any workbook). After creating the spreadsheet, you can add it to the analysis workbook, a new workbook, or any open workbook via the Home tab - Output group - Add to Workbook option (ribbon bar) or the File - Workbook menu (classic menus). See Add to Analysis Workbook and New Workbook for more details.

Var name prefix

Specify the default variable (column) name prefix for all variables in the new data file (all variables in the new data file will have this prefix). The variable name prefix that is defined here will have a sequential number added to the end ( if COL is specified as the prefix and 1 as the Var name start number, then the variables in the new data file will be assigned the default names COL1, COL2, COL3, etc.).

Var name start number

Specify the default start number for the sequence of variable names in the new data file. The new variables will be assigned default names created from the Var name prefixes (see previous paragraph) and consecutive Var name start numbers ( if COL is specified as the prefix and 5 as the Var name start number, then the variables in the new data file will be assigned the default names COL5, COL6, COL7, etc.).

Display format

In the Display format list, select which display format to be used to display the values for the variables (of the respective Default data type, see above) in the new data file. The adjacent box lists additional formats that are compatible with the selected display format. For example, if Time is selected as the display format, the adjacent box will list possible time formats (such as date and time combinations, military time options, etc.). See Variable Types for additional details.

Default

Click the Default button to reset all naming and formatting options on this tab to their defaults, (to set the Case name length to 0 (no case names), the MD code (missing data code) to -999999998, the Var name prefix to Var, the Var name start number to 1, the Default data type to Double, and the Display format to General.