ANY-maze Help > The ANY-maze reference > The Data page > Choosing what data is shown on the Data page > Limiting the tests (rows) shown

Limiting the tests (rows) shown

In brief

To alter which tests (i.e. rows) are included in the spreadsheet:

1.

Click the Select data button in the Actions section of the ribbon bar - this will cause the 'Data settings' page to be shown.

Details

Each row of the Data page spreadsheet shows a single test (or a segment of a test), but in some situations you may not want all the experiment's tests to be shown. For example, you might want to exclude some 'training' tests, the results of which are of little interest to you.

At the bottom of the 'Data settings' is a list which shows various measures, and you can use this list to select which tests should be shown - see figure 1.

Figure 1. The Data page settings include a list of measures which you can use to limit the tests shown on the Data page spreadsheet.

Clicking a measure's name expands the list to show the individual values of the measure. For example, one of the measures listed is Treatment - clicking it will show a list of the experiment's treatments - see figure 2.

Figure 2. In this case, the spreadsheet will just include those tests performed on animals which received the treatments 'Saline' or 'Compound X 1.0 mg/kg'.

To limit the tests, you should select items you want included - for example, in figure 2 the spreadsheet would include all the tests performed on animals which received the treatments 'Saline' OR 'Compound X 1.0 mg/kg.' Note that if you want to include all the treatments then you don't need to select any of them at all; i.e. selecting nothing in a group is the same as selecting everything.

You can choose to limit the tests based on more than one measure - for example, you could also open the Trial measure and select just the 'Retest' trial. In this case, only the tests which match the selected treatments AND the selected trials will be included. So, in our example, just the 'Retest' trials performed on animals which received the treatments 'Saline' OR 'Compound X 1.0 mg/kg' would be included in the spreadsheet.

If you want to select a block of items within the same group then you can use a 'shift-click' as follows: Click the first item you want to select, then hold down the shift key on the keyboard and click the last item you want to select. All the items from the first to the last (inclusive) will change to the same state as the LAST item now has. This works whether you're selecting or deselecting items - all the items simply change to have the same state as the LAST item you click.

Selecting trials

In fact, limiting the tests to just those which match certain trials can be a little less obvious than it appears. Imagine you have a 'Training' stage, in which animals have repeated trials until they achieve some training goal, or have had a maximum number of trials - perhaps 6.

In this 'Training' stage, some animals might have 4 trials, some might have 5 etc. but what would probably interest you would be an animal's performance in its last training trial, irrespective of which trial this happened to be. For example, you might want to compare its performance in the last training trial to its performance in a trial performed after some type of treatment.

For this reason, when listing the Trials in a stage, ANY-maze includes not just the individual trials (trial 1, trial 2, etc.) but also Last trial which will match the last trial for each animal, irrespective of which trial it happened to be. (For obvious reasons, the Last trial isn't listed for stages which include just a single trial).

Excluding retired animals

As you may know, ANY-maze allows you to mark an animal as Retired. This means that the results of any tests the animal has already had are maintained, but the animal doesn't receive any further tests.

Retiring animals is common in experiments which include some type of training - animals which fail to achieve the training goal are retired.

Ordinarily, tests performed on retired animals are still included in the Data page spreadsheet, but you can choose to exclude them by checking the box shown at the bottom of the Data page settings titled Don't include retired animals in the spreadsheet.

Clearing the list

If you want the spreadsheet to go back to showing all tests (the default) then you should 'un-check' all the entries in the list. A quick way to do this is to right click over the list and select Deselect all from the menu which appears.

See also:

© Copyright 2003-2026 Stoelting Co. All rights reserved

ANY-maze help topic T0882