Use this dialog to create a new spreadsheet based on the templates provided.
- From the menu select File | New
OR
Spread | New | Create.
To open a new spreadsheet based on one of these templates, double-click an icon or highlight an icon and click OK. You can open a blank vector, scalar, table, matrix, symmetric matrix or diagonal matrix spreadsheet. Alternatively, you can open a new spreadsheet from data on the clipboard, or using the available ODBC and DDE facilities.
The options listed are available for creating a new blank spreadsheet only (vector, scalar, table, matrix, symmetric matrix or diagonal matrix icons).
Rows
Specify the number of rows in the new spreadsheet.
Columns
Specify the number of columns in the new spreadsheet.
Create row labels
Select this option if you want an additional column in a matrix, symmetric matrix or diagonal matrix spreadsheet to contain either numeric or text labels. You can specify the type of labelling to be used by the Row label type option.
Row label type
For a matrix, symmetric matrix or diagonal matrix spreadsheet you can specify the row label type. Select Numeric if you want the additional column in the spreadsheet to be numeric labels, or Text if you want the additional column in the spreadsheet to be text labels.
Create from existing factors
Select this option if you want to create a Table spreadsheet using factors. After clicking OK you will be prompted with a menu where you can select the factors you want to create your spreadsheet with. To create a spreadsheet this way the factors must already exist in your data.
Create row factor
Select this option if you want a Table spreadsheet to include an additional column containing either numeric or text labels.
Create in book
This provides a list of books that the new spreadsheet can be added to. The default book that spreadsheets are added to can be specified using the Tools | Spreadsheet Options | Books tab.