Spreadsheet Restrict/Filter Menu

The Spread | Restrict/Filter submenu contains a number of commands for controlling Genstat data restrictions. A restriction, also known as filter in other applications such as Microsoft Excel, can be used to subset the data displayed for use in menus and graphics. When data are restricted in a spreadsheet only the rows included in the restriction are updated to the Genstat server. Therefore, rows excluded from the restriction will be not be included in any subsequent analysis, thus, providing a way of analysing a subset of data without having to make a copy of the data containing just the required rows.

Restrictions can be applied to matrices and tables within a spreadsheet, however, these structures cannot be restricted within the Genstat server. Restricting these structures is useful for display purposes and putting subsets of the rows into a Word table or Excel file. If the Subset on Update option is selected, then a reduced matrix or table with restricted rows removed will be sent to the server.

Display Excluded Rows

When selected, any rows that have been excluded from the restriction will have the row number and contents displayed in red (this colour can be changed in the Tools | Spreadsheet Options | Appearance tab ). This just provides a visual indication of the restriction and values can still be selected or modified. If this option is not selected, then the rows excluded from the restriction will be hidden from view.

Subset on Update

When selected, the update menu items on the Spread menu will only submit a subset of the data based on any restriction that has been applied. If any rows have been restricted then these will be submitted to the Genstat server creating a (unrestricted) subset including just those rows. Any factors updated in this way will have any unused levels/labels excluded so, for example, they will not appear in tables of means, etc. Any change to data in the restricted rows will enforce an update of all the columns in the spreadsheet to the Genstat server. When this option is activated the row numbers are displayed in the colour used for restricted items (the default colour is red) to indicate this mode.

By Logical Expression

Lets you create a restriction by specifying a logical expression.

To Groups (factor levels)

Lets you create a restriction using factor grouping.

By Value

Lets you create a restriction using a simple expression.

Selected Rows

Add or remove the selected rows to the current restriction.

Set as Excluded rows	The selected rows will be set to be the excluded rows.
Combine with Excluded rows	The selected rows will be added to the excluded rows.
Remove from Excluded rows	The selected rows will be removed from the excluded rows.

Unselected Rows

Add or remove the unselected rows to the current restriction.

Set as Excluded rows	The unselected rows will be set to be the excluded rows.
Combine with Excluded rows	The unselected rows will be added to the excluded rows.
Remove from Excluded rows	The unselected rows will be removed from the excluded rows.

Save/Apply…

Lets you save the current spreadsheet restriction or apply a previously saved restriction. This opens the Save Restriction/Filter dialog.

Bookmarked Rows

Add bookmarked rows to the current restriction.

Include only	The bookmarked rows will be set to be the included rows.
Exclude	The bookmarked rows will be added to the excluded rows.

Duplicate Rows

Filter the displayed rows to only display the rows which have duplicate values. This opens the Restrict/Filter Duplicate Rows dialog.

Random Rows

Filter the displayed rows to only display a random subset of rows. This opens the Restrict/Filter Random Rows dialog.

Rows selected from Graph

This opens the Restrict rows selected from Graph dialog which lets you restrict the rows in the spreadsheet based on a set of points selected in the Graphics Viewer using the Data Information mode and copied onto the clipboard.

Values Equal to the current Cell

Using the values in the current column, any row not containing the same value as the current cell is excluded from the restriction set. This combines the restriction of including only values equal to the current cell with any current restriction in place.

Values Not Equal to the current Cell

Using the values in the current column, any row containing the same value as the current cell is excluded from the restriction set. This combines the restriction of excluding values equal to the current cell with any current restriction in place.

Exclude rows with Missing values

Any row containing a missing value (*) is excluded from the restriction set.

Exclude rows with all Missing values

Any row containing only missing value (*) is excluded from the restriction set. This can be also used with table spreadsheets to hide empty rows of factor combinations that do not exist.

Include only rows with Missing values

The rows in the restriction set (i.e. included) is set to just those rows containing at least one missing value (*).

Reverse Exclusion/Inclusion

The rows currently excluded are set as included, and vice-versa.

Remove All

Removes any existing restriction/filter.