FishStat Plus Help Manual

Fisheries Data Analysis Software for Windows™

FAO Headquarters
FIDI, F-201
Viale delle Terme di Caracalla
00100 Rome, Italy
 FishStat Plus Help Manual 2

FishStat Plus Help Contents

1 Introduction
1.1 About FishStat Plus
1.2 Receiving Technical Support from the FAO
1.3 An Overview of the Main Window
2 Installation
2.1 Installation
2.2 Opening the Program
2.3 Opening a Dataset
3 Menus
3.1 Pop-up Menus
3.1.1 Aggregate
3.1.2 Format
3.2 File Menu
3.2.1 Introduction
3.2.2 Open Dataset
3.2.3 Close Dataset
3.2.4 Save Dataset
3.2.5 Manage Datasets
3.2.6 Install Dataset
3.2.7 Exit Program
3.3 Data Menu
3.3.1 Introduction
3.3.2 Filter
3.3.3 Aggregate
3.3.4 Edit Columns
3.3.5 Sort
3.3.6 Top/Other
3.3.7 Grand Total
3.3.8 Undo
3.4 Output Menu
3.4.1 Introduction
3.4.2 Copy
3.4.3 Simple Report
3.4.4 Tables
3.4.5 Charts
 FishStat Plus Help Manual 3

3.4.6 Tables and Charts

3.4.7 Printer Setup
3.4.8 Report Wizard
3.5 Tools Menu
3.5.1 Introduction
3.5.2 Format Numbers
3.5.3 Format Special Values (Hilite)
3.5.4 Custom Group (Group Manager)
3.5.5 Language and Font
3.5.6 Dataset Notes
3.5.7 Map
4 Building Expressions
4.1 Expression Builder
4.2 Edit Expression
4.3 Calculated Column
4.4 Expression Function List
4.4.1 Arithmetical Operators
4.4.2 Conversion Functions
4.4.3 Logical Operators
4.4.4 Numeric & String Comparison Operators
4.4.5 Statistical Functions
4.4.6 String Functions
5 Report Wizard
5.1 Introduction
5.2 Report Tables and Charts
5.3 Report Columns
5.4 Report Rows & Chart Direction
5.5 Select Data Columns
5.6 Select Source Records
5.7 Table Options
5.8 Table Preview
5.9 Chart Options
5.10 Chart Preview
5.11 Output
6 Customising
6.1 Formatting
6.1.1 Format Key Column
6.1.2 Numeric Column Options
6.2 Creating Groups
6.2.1 Aggregate Set
 FishStat Plus Help Manual 4

6.2.2 Custom Filter

6.2.3 Edit Group
6.2.4 Group Manager
7 Understanding Datasets
7.1 Introduction
7.2 Dataset Family
7.3 Measurement Units
8 Working with Columns
8.1 Introduction
8.2 Calculated Column
8.3 Key Column
8.4 Rank Column
8.5 Time-series Column
8.6 Notes
9 Tutorial
9.1 Introduction
9.2 Navigating the Main Window
9.3 Filtering the Dataset
9.4 Aggregating the Dataset
9.5 Analysing the Dataset
9.6 Sorting the Dataset
9.7 Displaying Only the Significant Data
9.8 Defining Report Tables
9.9 Defining Report Columns
9.10 Defining Rows and Charts
9.11 Choosing which Columns to Output
9.12 Choosing which Records to Output
9.13 Selecting Table Options
9.14 Table Preview
9.15 Selecting Chart Options
9.16 Chart Preview
9.17 Outputting the Data
9.18 Tutorial Conclusion
10 Glossary
10.1 Commands and Shortcuts
Cancel
Deselect All
Five Ways to Access the Menu
Hot-keys
How to Find Text
 FishStat Plus Help Manual 5

Invert Selection
Keyboard Reference
Select All
10.2 Concepts
Base Dataset
Calculated Columns Grid
Chart Point
Chart Set
Clipboard
Keys
Notes
Objects
Reference Dataset
Time-series Grid
ToolTip Window
Years List
10.3 Screen Elements
Accelerator Button
Arrows
Data Display
Menubar
Pop-up Menus
Scrollbar
Splits
Statusbar
Toolbar
11 Index
 FishStat Plus Help Manual 6

1 Introduction
1.1 About FishStat Plus

Fisheries Data

Statistical Reporting Software

• FishStat Plus is the Windows version of FishStat for Dos.

• Its robust design allows it to be used on the most minimal of systems (an antiquated 16-bit 386 laptop
will run FishStat without difficulty).

• It can be installed and operated on any MS Windows system (3.1/95/98/2000/NT).

• New functionality has been added to this version, including multi-lingual support, enhanced
expression building, sophisticated file export options, and advanced chart and table creation.

Time-series...
• FishStat Plus contains datasets organised by year, with statistics on capture, production, and value.
Each dataset can be run through a set of filtering and aggregating options that help you organise
your data.

• Its open-ended architecture ensures that as new datasets are produced they can be installed into the
system for immediate analysis and reporting.

Charts...
• FishStat Plus comes equipped with an array of charting tools to help you get the most from your data.
With the Report Wizard you can produce 2D and 3D pie and bar charts using a wide variety of
colours and layouts.

Customisation...
• With FishStat Plus’ Group Manager and Aggregate Set functions, you can save custom-designed
filtering and aggregating options for use with other datasets.
 FishStat Plus Help Manual 7

1.2 Receiving Technical Support from the FAO

Support for FishStat Plus

is provided by:

Yury Shatz
Programmer
FAO Headquarters, F-201
Viale delle Terme di Caracalla
00100 Rome, ITALY
Email: Yury.Shatz@FAO.ORG

Phone: (39) 06 570 54820

Fax: (39) 06 570 52476

Tony Jarrett
Fisheries Data Officer
FAO Headquarters, F-201
Viale delle Terme di Caracalla
00100 Rome, ITALY
Email: Tony.Jarrett@FAO.ORG

Phone: (39) 06 570 55964

Fax: (39) 06 570 52476
 FishStat Plus Help Manual 8

1.3 An Overview of the Main Window

Controls and details

• Menubar: a standard feature of most Windows applications. Use it to select a command. Many
Menu commands are also available through the Toolbar, but only the Menubar provides access to all
program features.

• Toolbar: an easy way to access the most commonly used commands. The Toolbar can be resized or
hidden. It becomes scrollable if some of the buttons do not fit vertically.

• Data Display: a grid that displays the records of the current Dataset. Some rows may be highlighted,
e.g. currently selected rows are grey. Use the <Arrow> keys to change the current row. You can also
click on a row to make it current. There are several ways to select more than one row: click-drag,
Shift-click, and Ctrl-click.

• Column headers: dataset column names are displayed here. Click on a column header to display
its Pop-up Menu.

• Time-series grid: displays all the Time-series data for the current record, since the screen is often
not wide enough to view all of the Columns. You can adjust its width and height.

• Calculated Columns grid: displays all the Calculated Columns data for the current record. Similar to
the Time-series grid.

• Statusbar: contains information about the total number of dataset rows, the number currently
selected, and the dataset unit.
 FishStat Plus Help Manual 9

2 Installation
2.1 Installation

Select your installation:

1. Installing from the FAO Network

• From the Windows Program menu go to Fi Applications and click <FishStat Plus installation>.
The program will self-install. After installation, a program icon is created in the Program/Fi
Applications menu.

Tip: It may take a moment for the new program icon to appear.
2.2
• Next, try opening the program.

2. Installing from an installation disk into a Win95/98/NT/2000 operating system

• Insert the FishStat Plus CD-ROM into your CD-ROM drive. If the AUTORUN feature is enabled on
your system, the setup program will launch the installation. If not, go to the Windows Start menu
and click <Run>. Type the following line in the input box: D\FishStat\Setup (where "D:" is the drive
letter of your CD-ROM) and press <Enter>.

Tip: If you're not sure what letter corresponds to your CD-ROM, open Microsoft Explorer and
search for the drive letter that shows the FishStat CD-ROM.

• Follow the installation instructions. After installation, a program icon is created in the Program menu.
2.2
Next, try opening the program.

3. Installing from an installation disk into a Win3.1 operating system

• Insert the FishStat Plus CD-ROM into your CD-ROM drive. From the Program Manager select
<Run>. Type the following line in the input box: D\FishStat\Setup (where "D:" is the drive letter of
your CD-ROM) and press <Enter>.

Tip: If you're not sure what letter corresponds to your CD-ROM, open File Manager and search for
the drive letter that shows the FishStat CD-ROM.

• Follow the installation instructions. After installation, a program icon and Group are created within the
2.2
Program Manager. Next, try opening the program.

See Also
2.2
Opening the Program
2.3
Opening a Dataset
 FishStat Plus Help Manual 10

2.2 Opening the Program

Where FishStat Plus is found depends on your system.

1. If the program has been installed from the FAO network:

• You can find it in the Program menu under FI Applications.

2. If you've installed it from a disk

• It will create its own program Group, in which case it can be found in the Program menu under
FishStat Plus (Win95/98/NT), or within a program Group of the Program Manager (Win3.1)

Tip: Once you've opened the program, you may need to load it with a Dataset.

See Also
2.3
Opening a Dataset
2.1
Installation
 FishStat Plus Help Manual 11

2.3 Opening a Dataset

• If no datasets are installed on the system

1. FishStat Plus will automatically search the network (if you are installing from the CD-ROM, leave it
in the CD-ROM drive. FishStat Plus will search for the datasets included on the CD-ROM) and locate
any that are available. It will prompt you to install each dataset it finds.

2. Install any you require by selecting <Yes>. If you select <No>, you will not be asked in the future to
install the dataset. If you select <Later> you will be prompted to install the dataset the next time you
open FishStat.

3. For every dataset you elect to install, the program will ask you whether you would like to <Copy>,
<Keep>, or <Cancel> it. Copying the dataset takes room on your hard-drive but may increase
program speed.
Tip: At the time of the production of these help instructions (Mar. 2000) the entire FishStat Plus
package including ALL available datasets required 40mb of memory.

4. Once all available datasets have been either accepted or rejected the program will display the
Load Dataset dialog box. It contains the list of all installed datasets (you may only work with one
dataset at a time). Select the one you wish to use by clicking it and then click <OK>.

• If the program has already been used with a dataset, it will automatically load the last dataset
used, together with any filtering, aggregating, formatting, etc. options configured at the time the
program was last closed.

See Also
2.2
Opening the Program
2.1
Installation
 FishStat Plus Help Manual 12

3 Menus
3.1 Pop-up Menus

• Within many FishStat Plus screens and dialog boxes a right-click of the mouse calls a Pop-up Menu
that is tailored not only to the current area of the program, but also to the specific Object or data that
is clicked.

Examples
• In the Main Window, right-clicking on a Key Column brings up this menu:

• Note how it's tailored to the Key Column "Environment". There are secondary submenus for
3.1.1 3.1.2
Aggregating and Formatting .

8.5 8.2 8.4

• Right-clicking on a Time-series , Calculated , or Rank Column calls a menu of this type:
Note how it's tailored to the Time-series Column "1985"

• Note how it's tailored to the Time-series Column "1985"

 FishStat Plus Help Manual 13

3.3.2 6.2
• Within the Filter and Custom Groups dialog boxes are other valuable menus:
Once again, note how it's tailored to the Object "Algeria", as well as the Include window of the dialog
box.

• Once again, note how it's tailored to the Object "Algeria", as well as to the Include window of the dialog
box.

See Also:
10.1
Four Ways to Use the Menu
10.1
Keyboard Reference
10.1
How to Find Text
 FishStat Plus Help Manual 14

3.1.1 Aggregate Pop-up Menu

• Any Key Column can also be aggregated from the Main Window.

• Right-click the column you wish to aggregate and a Pop-up Menu appears. In the middle of the menu
are the aggregation commands, Keep details, Group, and Aggregate. Click the aggregation level you
desire.

• Placing the mouse pointer over the Group command causes a secondary pop-up to appear that lists
the Group types available for selection. If you choose Handpicked FishStat will open the Aggregate
6.2.1
Set dialog box.
 FishStat Plus Help Manual 15

3.1.2 Format Pop-up Menu

• Any Key Column can also be formatted from the Main Window.

• Right-click the column you wish to format and a Pop-up Menu appears. Towards the bottom of the
menu is the Format command.

• Placing the mouse pointer over Format causes a secondary pop-up to appear that lists the available
display types. Click the desired type and the program returns you to the Data Display.
 FishStat Plus Help Manual 16

3.2 File Menu

3.2.1 Introduction

The six commands found in the File menu have to do with loading, saving, and managing Datasets
3.2.2
• Open
3.2.4
• Save
3.2.3
• Close
3.2.5
• Manage Datasets
3.2.6
• Install Dataset
3.2.7
• Exit

See also:
3.5
Tools Menu
3.3
Data Menu
3.4
Output Menu
10.1
Four Ways to Use the Menu
10.1
Keyboard Reference
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 17

3.2.2 Open Dataset

When should you use it?

7.0
• To select and load a Dataset into the program.

Where do you find it?

10.3
• On the Menubar click <File> and select <Open>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <Ctrl+O> or press <Alt> then <F> and then <O>.

How does it work?

10.2
• The dialog box displays a list of all known datasets. Bold names are Base Datasets . These are
8.2
always loaded in their original form, unfiltered and without Calculated Columns . Under each base
dataset there may be an indented list of child datasets.

• datasets with a key icon next to their name are read-only and indicate a base or system-defined
child dataset.

To load a Dataset
• Double-click it

• Highlight it using the Keyboard10.1 arrows and then press <Enter>

• Click it with the mouse pointer and click <OK>.

7.0
• Opening a Dataset takes several seconds for a child dataset and up to a minute for a base dataset.

Tip: If a dataset was open when the program was last closed, then it will be autoloaded at the start of
the next session, together with all filtering, aggregating, sorting options present at the close of the last
session. If not, the program will bring up the Open dataset dialog box.
 FishStat Plus Help Manual 18

See also:
10.3
Menubar
10.3
Toolbar
7.0
Dataset
3.2.3
Close
3.2.4
Save
3.2.5
Manage Dataset
3.2.6
Install Dataset
3.2.7
Exit
3.1
Pop-up Menus
 FishStat Plus Help Manual 19

3.2.3 Close Dataset

When should you use it?

7.0
• To close the current Dataset without saving any changes.

• Useful for returning the dataset to its original state.

Where do you find it?

10.3
• On the Menubar click <File> and select <Close>.
10.1
• On the Keyboard press <Alt> then <F> and then <C>.

How does it work?

• The Close command will close the current dataset without saving any changes you have made. The
10.3 3.2.7 3.2.2
data display will go blank. The Toolbar will display only two options, Exit and Open . You can
either open a new dataset or exit the program.

Tip: FishStat Plus automatically saves the current dataset when you exit the program. You need
only use the Save command if you plan on switching datasets.

See also:
10.3
Menubar
10.3
Toolbar
7.0
Dataset
3.2.4
Save
3.2.7
Exit
3.2.2
Open
3.2.5
Manage Dataset
3.2.6
Install Dataset
3.1
Pop-up Menus
 FishStat Plus Help Manual 20

3.2.4 Save Dataset

When should you use it?

7.0 10.2
• To save changes to the current Dataset , and to delete or rename existing Reference Datasets .
3.2.7
Tip: FishStat Plus automatically saves the current dataset when you Exit the program. You need
only use the Save command if you plan on switching datasets.

Tip: FishStat Plus will not save your dataset under an independent, exportable file name. To export a
3.4.2 3.4.3
dataset to an independent file you must copy it to the clipboard or export it to an .RTF, .CSV,
.HTML, or .SYLK file. Please note that such a file cannot be opened from within FishStat Plus.

Where do you find it?

10.3
• On the Menubar click <File> and select <Save>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <Ctrl+S> or press <Alt> then <F> and then <S>.

How does it work?

• The Save command will open the Save dataset dialog box:

10.2
• A list of all existing datasets will appear. Left-aligned bold names are Base Datasets . Under each
10.2
base dataset there may be an indented list of its Reference Datasets .

• You may either type a new name in the dataset Name input box or select an existing user-defined
reference dataset to overwrite (the program will not allow you to select a base or system dataset,
7.0
indicated by the key next to the Dataset name).
 FishStat Plus Help Manual 21

To switch between the input box and the list box

• Click the box with the mouse or use the <Tab> key.

To select existing Datasets for overwriting

10.1
• Click them with the mouse or scroll the list with the Keyboard <Arrow> keys.

Tip: Double-clicking a user-defined reference dataset will cause the program to immediately
overwrite it.

To save changes and exit the Save Dataset dialog box

• Click <OK> or press <Enter>.

To close the dialog box without saving the Dataset

• Click <Cancel> or press <Esc>.

Tip: You may also delete or rename any reference dataset you highlight.

See also:
10.3
Menubar
10.3
Toolbar
7.0
Dataset
3.2.7
Exit
3.2.3
Close
3.2.2
Open
3.2.5
Manage Dataset
3.2.6
Install Dataset
3.1
Pop-up Menus
 FishStat Plus Help Manual 22

3.2.5 Manage Datasets

When should you use it?

7.0
• To install a Dataset , remove an installed dataset, or view properties information about an installed
7.2
dataset, e.g. date created, file size, Dataset Family , etc.

Where do you find it?

10.3
• On the Menubar click <File> and select <Manage Datasets>.
10.1
• On the Keyboard , press <Ctrl+M> or press <Alt> then <F> and then <M>.

How does it work?

10.2
• A list of all existing datasets will appear. Left-aligned bold names are Base Datasets . Under each
10.2
base dataset there may be an indented list of its Reference Datasets .

To delete an installed Dataset

10.1
• Highlight it by clicking it with the mouse or scrolling the list with the Keyboard <Arrow> keys. Click
<Delete>.

To add a new Dataset

3.2.6
• Click <Add>. The program will take you to the Install Dataset dialog box.

To exit
1.3
• Click <Close>. The program will return you to the Main Window .

See also:
10.3
Menubar
7.0
Dataset
3.2.2
Open
10.3
Toolbar
3.2.3
Close
3.2.4
Save
3.2.6
Install Dataset
3.1
Pop-up Menus
 FishStat Plus Help Manual 23

3.2.6 Install Dataset

When should you use it?

7.0 3.2.2
• To install a new Dataset so that it can be opened by FishStat Plus.

Where do you find it?

10.3
• On the Menubar click <File> and select <Install Dataset>.
10.1
• On the Keyboard , press <Ctrl+I> or press <Alt> then <F> and then <I>.

How does it work?

• The Install dataset dialog box contains two windows. On the left, the directory window displays the
current directory in which it is searching for datasets. On the right, the window displays the datasets
found within the current directory.

To switch between the Directory window and the Dataset window

• Click the window with the mouse or use the <Tab> key.

To switch directories
• The program defaults to the location where it stores installed datasets (normally C:\program
files\fishstat\db for Win95/98/NT and C:\fishstat\db for Win3.1).

Tip: It does not display the already installed datasets. It will only display datasets that have not yet
been installed.

• The directory window will display any directories found within the current directory.

To go to the parent directory

 FishStat Plus Help Manual 24

• Double click on the two dots (..) found in the upper left corner of the directory window or highlight
10.1
them by clicking them or scrolling to them with the Keyboard <Arrows> and then pressing
<Enter>.

To go to a sub-directory of the current directory

10.1
• Double-click it, or highlight it by clicking it or scrolling to it with the Keyboard <Arrows> and then
pressing <Enter>.

To switch drives
7.0
• Use this option if you have a Dataset on a different hard-drive or on a CD-ROM or floppy disk.

• Click at the right of the combo box found in the lower left-corner of the screen and select the
appropriate drive.

To install a Dataset from the Dataset window

10.1
• Double-click it, or highlight it by clicking it or scrolling to it with the Keyboard <Arrows> and then
pressing <Enter>.

See also:
10.3
Menubar
7.0
Dataset
3.2.4
Save
3.2.3
Close
3.2.2
Open
10.3
Toolbar
3.2.5
Manage Dataset
3.1
Pop-up Menus
 FishStat Plus Help Manual 25

3.2.7 Exit

When should you use it?

• To end your current session, close the open dataset with changes saved, and exit the program.

Where do you find it?

10.3
• On the Menubar click <File> and select <Exit>.

10.3
• From the Toolbar click or .
10.1
• On the Keyboard , press <Alt> then <F> and then <X>.

How does it work?

• Exit automatically saves your current session including all filtering, aggregating, etc. options and any
8.2
Calculated Columns before closing down the program and returning you to Windows .

See also:
10.3
Menubar
10.3
Toolbar
7.0
Dataset
3.2.4
Save
3.2.3
Close
3.2.2
Open
3.2.5
Manage Dataset
3.2.6
Install Dataset
3.1
Pop-up Menus
 FishStat Plus Help Manual 26

3.3 Data Menu

3.3.1 Introduction

3.3
The six commands found in the Data Menu access all the ways in which a Dataset can be
transformed
3.3.2
• Filter
3.3.7
• Grand Total
3.3.3
• Aggregate
3.3.4
• Edit Columns
3.3.5
• Sort
3.3.6
• Top/Other

Although you can use these commands in any order and in any combination, they are related to one another,
3.3.3 7.0
and the program executes them in the order listed above, e.g. if you Aggregate a Dataset , and then go
back and alter the filter, the program will filter the data and then re-aggregate it since filtering affects
aggregation.

See also:
3.2
File Menu
3.5
Tools Menu
3.4
Output Menu
10.1
Four Ways to Use the Menu
10.1
Keyboard Reference
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 27

3.3.2 Filter

When should you use it?

7.0
• Use the Filter command to filter your Key Columns and create a subset of the current Dataset , i.e.
by restricting the number of records (rows).

Where do you find it?

10.3
• On the Menubar click <Data> and select <Filter>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <F4> or press <Alt> then <D> and then <F>.
3.1
• To use a Pop-up Menu , right-click any Key Column.

How does it work?

The filter is actually a set of filters
• There is a separate filter for every Key Column. You can switch from filter to filter by clicking the tab
names that run along the top of the dialog box (or by pressing <Ctrl+PgDN> & <Ctrl+PgUp>).

The Include and Exclude windows

• The records in each Key Column are filtered according to the inclusion/exclusion parameters set by
the user:

Tip: Any filter for which no parameters are set will allow all records to pass.

Selecting Objects from the Include/Exclude lists

• Select a single Object by clicking it with the mouse.

• Select multiple Objects by click-dragging with the mouse.

• Select Objects singly by holding down the <Ctrl> key and clicking them with the mouse.
 FishStat Plus Help Manual 28

• Select a range of Objects by clicking the first Object with the mouse and then holding down the
10.1
<Shift> key and clicking the last Object in the range, or by using the Keyboard arrows.

Finding Objects from the Include/Exclude lists

• Start typing in the Include or Exclude list. A yellow box will appear with the text you typed, and the

Find window will be displayed next to it. If you press a letter key but text in the
yellow box does not change, this means that text was not found.

• You can either continue typing until the Object you want appears, or type a few characters and use

the Find Next and Find Previous buttons to find occurrences of the text you typed.

• By toggling you can switch between searching only from the beginning of a name or searching
anywhere within a name.

• To find and select ALL Objects, whose names contain the text you typed press the Find All
button.

Moving selected Objects between lists

• Use the blue and red arrow buttons to move selected Objects in the direction indicated by
the arrow.

• Press <Ctrl+LArrow> or <Ctrl+RArrow>

• Drag selected Objects to the opposing list.

Moving all Objects between lists

• Use the thick blue and red arrow buttons to move all Objects in the direction indicated by
the arrow.

• Press <Ctrl+Shift+LArrow> or <Ctrl+Shift+RArrow>

Moving Groups of Objects between lists

• In the middle of the dialog box is the Group window where Groups are listed. There is a combo box
across its top that allows you to choose different types of Groups, e.g. continents, economic Groups
of countries, etc).
 FishStat Plus Help Manual 29

• Click at the upper-right of the combo box to choose a type of Group. As you select different types
of Groups you will notice the Groups changing.
To include or exclude all the members of a Group click the appropriate arrow, or click-drag the Group
name into one of the boxes.
6.2.2
Tip: You may also save and load your own Custom Filters based on your specific
Inclusion/Exclusion criteria

• Once you've set the filtration options for your Key Columns click <OK> to filter, or <Cancel> to
1.3
abandon your changes. The program will return you to the Main Window .

See also:
3.3.7
Grand Total
3.3.3
Aggregate
3.3.4
Edit Columns
3.3.5
Sort
3.3.6
Top/Other
7.0
Dataset
3.3
Data Menu
6.2.2
Custom Filter
3.3.7
Grand Total
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 30

3.3.3 Aggregate

When should you use it?

• To reduce the number of records by Grouping like records together, e.g. the categories "North
Atlantic" and "South Atlantic" can be aggregated as "Atlantic"

Where do you find it?

10.3
• On the Menubar click <Data> and select <Filter>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <F5> or press <Alt> then <D> and then <A>.
3.1.1
• To use the Aggregate Pop-up Menu , right-click any Key Column.

How does it work?

• Each Key Column can be configured in any one of three ways from within the Aggregate dataset
dialog Box:

• The default is Detailed, which preserves the current state of disaggregation.

• Selecting Grouped brings up a combo box that allows you to choose from among a set of standard
3.3.2
Groups (identical to those found in the Filter dialog box) or choose Handpicked, an option which
6.2.1
allows you to create your own Aggregate Sets .

• Selecting Aggregated means that the Objects in the column are replaced with the word "All". The
effect is of Grouping the entire Key Column into one Group, i.e. the column no longer has an effect
on how data is displayed. It loses all variability and becomes a constant.

• Once you've set the aggregation options for your Key Columns click <OK> to aggregate, or
1.3
<Cancel> to abandon your changes. The program will return you to the Main Window .
 FishStat Plus Help Manual 31

See also:
3.3.2
Filter
3.3.7
Grand Total
3.3.4
Edit Columns
3.3.5
Sort
3.3.6
Top/Other
6.2.1
Aggregate Sets
7.0
Dataset
3.3
Data Menu
6.2.2
Custom Filter
3.1
Pop-up Menus
 FishStat Plus Help Manual 32

3.3.4 Edit Columns

When should you use it?

8.2 8.4
• Use this command to create, edit, and remove Calculated & Rank Columns , Hide/Reveal Time-
8.5
series Columns , and modify column headers, widths and output formats.

Where do you find it?

10.3
• On the Menubar click <Data> and select <Columns>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <F6> or press <Alt> then <D> and then <C>.

Tip: Calculated Columns can also be edited by right-clicking them and selecting <Edit> from the
3.1
Pop-up Menu .

How does it work?

• When you click the Edit Columns command the program opens the Edit Columns dialog box.

• In the centre of the dialog box is a list of all Dataset Columns. They are divided into three Groups:
Key Columns, Time-series Columns and Calculated Columns. Click or to view individual
Columns. On the left are commands to delete, hide and modify Columns. On the right are commands
for creating new Columns.

Tip: Only user-created Columns can actually be deleted. Time-series Columns are instead hidden,
and Key Columns are completely unaffected by the Delete command.)

Selecting Columns:
To Select a column or Columns
 FishStat Plus Help Manual 33

• Click or to view individual Columns.

• Select a single column by clicking it with the mouse.
• Select multiple Columns by click-dragging with the mouse.
• Select Columns singly by holding down the <Ctrl> key and clicking them with the mouse.
• Select a range of Columns by clicking the first Object with the mouse and then holding down the
10.1
<Shift> key and clicking the last Object in the range or by using the Keyboard arrows.

Deleting, hiding, and revealing Columns

To Delete a Calculated or Rank Column or Columns
10.1
• Select the column or Columns you wish to delete. Click <Delete> or press it on your Keyboard .
Tip: you can also delete by right-clicking the column and selecting <Delete> from the Pop-up
3.1
Menu .

To Hide a Time-series Column or Columns

• Select the column or Columns you wish to hide. Click <Delete> or press it on your Keyboard.
Tip: you can also hide by right-clicking the column and selecting <Hide> from the Pop-up Menu.

To Reveal a hidden Time-series Column or Columns

• Click <Year>, and then click the column you wish to Reveal (click <ALL> to reveal all hidden
Columns.
Tip: you can also reveal by right-clicking the column and selecting <Reveal> from the Pop-up Menu.

Adding a Key Column with a new display format

• Click . FishStat will display a combo box containing a list of existing Key Columns:

• Click the column for which you wish to add a second display format and the program will open the
Format Key Column dialog box.
Tip: you can also add a second column by right-clicking the Key Column you wish to add a display
3.1
format to and click <New Column> from the Pop-up Menu .

Formatting Columns
To Format or Reformat a Key Column or Columns
• Select the Key Column or Columns you wish to format. Click <Format>. The program will take you to
the Format Key Column dialog box.
6.1 3.1.2
Tip: you can also Format a Key Column via the Format Pop-up Menu .

To Format or Reformat a Time-series or Calculated column or Columns

 FishStat Plus Help Manual 34

8.2
• Select the Time-series or Calculated Columns or Columns you wish to format. Click <Format>. The
6.1.2
program displays the Column Options dialog box.
Tip: you can also Format by right-clicking the column and selecting <Format> from the Pop-up
3.1
Menu .

Working with Expressions

To Edit the expression in an existing Calculated column
• Select the column you wish to edit. Click <Edit> or press <F2>. The program will open the Edit
4.2
Expression dialog box.

To create a new Sum or Average Calculated column

• Click on Sum (or press <Alt> then <S>) or Average (or <Alt> then <A>). The program will
display the Edit Expression dialog box with the expression already completed.
8.5
• If you wish to apply the expression to only a selected portion of the Time-series Columns , edit the
10.2
numbers in the Years List . Click <OK> or press <Enter>.

• The program will now display the Column Options dialog box. Format the column and then click
<OK> or press <Enter>. The program will return you to the Edit Columns dialog box where you can
create another column, or edit or delete an existing column.

• If you're finished, click <OK> to exit and apply your changes, <Cancel> to exit and abandon your
1.3
changes. The program will return you to the Main Window

To create a Rank Column that ranks the values of another column

• Click (or press <Alt> then <R>). The program displays the Edit Rank Column dialog box:
3.1
Tip: you can also rank by right-clicking and selecting <Rank> from the Pop-up Menu .

• Click at the right of the combo box and choose a column to rank. Click the <Reverse> check box
if you'd like to rank the column from the smallest value to the largest value and then click <OK>.

• The program will display the Rank options dialog box. Re-title the column if you wish by typing in the
left input box, and adjust the column width by typing in the right input box. Click <OK> to return to the
Edit Columns dialog box. Otherwise click <Cancel> to abandon your changes.

To create a Calculated column with a user-defined expression

• Click (or press <Alt> then <F>)

4.1
The program will display the Expression Builder dialog box.
 FishStat Plus Help Manual 35

See also
4.4
Expressions, functions and operators
4.1
Expression Builder
7.0
Dataset
3.3
Data Menu
6.1
Format
6.1.2
Column Options
3.1
Pop-up Menus
 FishStat Plus Help Manual 36

3.3.5 Sort

When should you use it?

7.0
• To select sort criteria and sort the current Dataset .

Where do you find it?

10.3
• On the Menubar click <Data> and select <Sort>.

10.3
• From the Toolbar click or
10.1
• From the Keyboard type <F7> or press <Alt> then <D> and then <S>.
10.3
• From the Data Display , put the mouse pointer in any Time-series or Calculated column and right-
3.1
click. Choose <Sort [name of column]> from the Pop-up Menu .

How does it work?

• You may select up to 5 Columns to use as sort criteria.

• Normal or reverse order can be set independently for each column.

• During sorting, values in the first sort column are compared, and only when these are equal are
second and subsequent sort Columns taken into account:

8.4
• The Columns window lists all Columns that can be used as sort criteria (Rank Columns cannot be
used as they depend on other Columns). The first item in the list is always "None". Click it to clear the
sort criteria field.

To make a column the primary sort key

• Drag column name to the first Sort Criteria box, or
 FishStat Plus Help Manual 37

• Click on the column name in the Columns window and click the topmost button, or press <Alt>
then <1>.

To make a column the secondary, tertiary, etc. sort key

• Drag column name to the desired Sort Criteria box, or

• Click on the column name in the Columns window and click the button next to the desired Sort
Criteria box, or press <Alt> then <[number of desired Sort Criteria box]>.

To delete any sort key other than the primary sort key
• Drag <None> to the Sort Criteria box containing the key you wish to delete, or

• Click <None> in the Columns window and click the button next to the Sort Criteria box
containing the key you wish to delete, or press <Alt> then <[number of desired Sort Criteria box]>.

To reverse the sort order of a sort key

• Use the A-to-Z and Z-to-A buttons to switch between direct and reverse sort order for
each Sort Criteria box. Direct order is A-to-Z for alphabetical fields, High-to-Low for numeric data.

See also:
3.3.2
Filter
3.3.7
Grand Total
3.3.3
Aggregate
3.3.4
Edit Columns
3.3.6
Top/Other
4.4
Expressions, functions and operators
4.1
Expression Builder
7.0
Dataset
3.3
Data Menu
6.1
Format
6.1.2
Column Options
6.2.1
Aggregate Sets
6.2.2
Custom Filter
3.1
Pop-up Menus
 FishStat Plus Help Manual 38

3.3.6 Top/Other

When should you use it?

• Use this command to limit the display of your records to those that are more significant.

Where do you find it?

10.3
• On the Menubar click <Data> and select <Columns>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <F8> or press <Alt> then <D> and then <T>.
3.1 8.5
• To use a Pop-up Menu , right-click any Time-series Column .

How does it work?

7.0
• FishStat Plus can be configured to display only the top (or most significant) records of the Dataset .
The program will display the Top/Other selection dialog box:

8.5
• First click at the right of the "...by field" combo box. Select a Time-series or Calculated
8.2
Column by clicking it.

• Next, specify either a number of top records to select (e.g. top 50 records), or a percentage of the
total (e.g. records comprising 80% of the total column value, with inclusion priority given to those
records with the highest values), or a threshold (e.g. all records with values exceeding 1000).

Tip: Records not included as top records will be aggregated and listed as "Other".

See also:
3.3.2
Filter
3.3.7
Grand Total
3.3.3
Aggregate
3.3.4
Edit Columns
3.3.5
Sort
4.4
Expressions, functions and operators
4.1
Expression Builder
7.0
Dataset
 FishStat Plus Help Manual 39

3.3
Data Menu
6.1
Format
6.1.2
Column Options
6.2.1
Aggregate Set
6.2.2
Custom Filter
3.1
Pop-up Menus
 FishStat Plus Help Manual 40

3.3.7 Grand Total

When should you use it?

1.3
• To add a Grand Total line to the bottom of the Main Window Data Display.

Where do you find it?

10.3
• On the Menubar click <Data> and select <Grand Total>.

10.3
• From the Toolbar click or
10.1
• On the Keyboard , press <Ctrl+F8> or press <Alt> then <D> and then <G>.
3.1 8.5
• To use a Pop-up Menu , right-click any Time-series Column .

How does it work?

• This command toggles the Grand Total line on and off. If the Grand Total is currently on, the Grand

Total button will be pressed in and a tick mark will appear next to its command name in
3.3
the Data Menu .

• The values displayed in the Grand Total row are only affected by the choices you make when
3.3.2
Filtering .
8.2
Tip: Formulas in the Calculated Columns are evaluated AFTER the Grand Total has been
calculated, e.g. for the column "Forecast" the Grand Total row contains the forecast of sum, not the
sum of all forecasts.

See Also:
3.3.2
Filter
3.3.3
Aggregate
Columns
3.3.5
Sort
3.3.6
Top/Other
3.1
Pop-up Menus
 FishStat Plus Help Manual 41

3.3.8 Undo

When should you use it?

• The Undo Command reverses the last action.

Where do you find it?

10.3
• On the Menubar click <Data> and select <Undo>.
10.1
• On the Keyboard , press <Ctrl+Z> or press <Alt> then <D> and then <U>.

How does it work?

• Select the command and the program will automatically go back one step.
3.2.3
Tip: to undo all of your changes since you last saved the file, use the Close command and then
3.2.2 7.0
re-Open the Dataset .

See also:
3.2.7
Exit
3.1
Pop-up Menus
 FishStat Plus Help Manual 42

3.4 Output Menu

3.4.1 Introduction

3.4
The six commands found in the Output Menu access all the ways in which a Dataset can be
outputted
3.4.2
• copy
3.4.3
• Simple Report
3.4.4
• Tables
3.4.5
• Charts
3.4.6
• Tables and Charts
3.4.7
• Printer Setup

3.4.2 10.2
These commands range from the simple copy command, which sends row data to the Clipboard , to the
3.4.6
sophisticated Tables and Charts option that allows you to create combination text and graphic reports.
5.0
Tip: Tables, Charts, and Tables and Charts all use the Report Wizard to navigate you through report
creation.

See also:
3.2
File Menu
3.3
Data Menu
3.5
Tools Menu
5.0
Report Wizard
10.1
Four Ways to Use the Menu
10.1
Keyboard Reference
3.1
Pop-up Menus
 FishStat Plus Help Manual 43

3.4.2 Copy

When should you use it?

10.2
• To export a row or rows to the Clipboard for use by another application.

Where do you find it?

10.3
• On the Menubar click <Options> and select <Copy>.
10.1
• On the Keyboard , press <Ctrl+C> or press <Alt> then <O> and then <C>.
3.1
• To use a Pop-up Menu to copy, right-click any column and select <Copy>.

Tip: This command is only available if one or more rows are selected.

How does it work?

1. Select one or more rows from the Main Window Data Display
• Select multiple rows by click-dragging with the mouse.

• Select single rows by holding down the <Ctrl> key and clicking with the mouse.

• Select a range of rows by clicking the first row with the mouse and then holding down the <Shift> key
and clicking the last Object in the range, or hold down the <Shift> key and then press the
10.1
Keyboard up or down <Arrow>.

2. Copy the selected rows to the Windows clipboard

• Access the command as described above in "Where do you find it?"

3. Paste into another application

• Open or make current the other application you wish to paste the selected and copied rows into, and
follow that applications instructions for pasting.

Tip: if your rows are not pasted properly into Excel , change its settings by going to the Tools
3.5
Menu , Text-to-Table Command and then setting the Delimiter to "Tab". This is the default, and
should only need to be changed if previously altered by a user.

See also:
5.0
Report Wizard
3.4.4
Tables
3.4.5
Charts
3.4.6
Tables and Charts
3.1
Pop-up Menus
 FishStat Plus Help Manual 44

3.4.3 Simple Report

When should you use it?

1.3
• To print a report that has the same layout as does the data in the Main Window , without the
addition of any other supporting material.

Tip: useful for exporting to a spreadsheet program like Excel.

Where do you find it?

10.3
• On the Menubar click <Output> and select <Simple Report>.

10.3
• From the Toolbar click or . The program will display a drop-down menu with four
commands. Select <Simple Report>.
10.1
• On the Keyboard , press <Ctrl+R> or press <Alt> then <O> and then <S>.

How does it work?

5.11
• Following the selection of "Simple Report" the program opens the Destination dialog box.

See also:
5.0
Report Wizard
3.4.4
Tables
3.4.5
Charts
3.4.6
Tables and Charts
3.4.2
copy
3.1
Pop-up Menus
 FishStat Plus Help Manual 45

3.4.4 Tables

When should you use it?

• To print tables with a custom layout. The Table option gives you control of the X-, Y-, and Z-axes.
Other features include the option to limit the range of any of the axes, e.g. you can limit the Time-
8.5
series Columns to a few years.
3.4.5
Tip: This option does not support Charts .

Where do you find it?

10.3
• On the Menubar click <Output> and select <Tables>.

10.3
• From the Toolbar click or . The program will display a drop-down menu with four
commands. Select <Tables>.
10.1
• On the Keyboard , press <Ctrl+W> or press <Alt> then <O> and then <T>.

How does it work?

• Following the selection of "Tables" the program opens the Report Type dialog box.

See also:
5.0
Report Wizard
3.4.5
Charts
3.4.6
Tables and Charts
3.4.3
Simple Report
3.4.2
copy
3.1
Pop-up Menus
 FishStat Plus Help Manual 46

3.4.5 Charts

When should you use it?

3.4.5 7.0
• To print Charts using the data in your Dataset . The Chart option gives you control of the X-, Y-,
and Z-axes. Other features include the option to limit the range of any of the axes, e.g. you can limit
8.5
the Time-series Columns to a few years. You may also choose from a multitude of styles, e.g. pie,
bar, 3-d.
3.4.4
Tip: This option does not support Tables .

Where do you find it?

10.3
• On the Menubar click <Output> and select <Charts>.

10.3
• From the Toolbar click or . The program will display a drop-down menu with four
commands. Select <Charts>.
10.1
• On the Keyboard , press <Ctrl+H> or press <Alt> then <O> and then <C>.

How does it work?

• Following the selection of "Charts" the program opens the Report Type dialog box.

See also:
5.0
Report Wizard
3.4.4
Tables
3.4.6
Tables and Charts
3.4.3
Simple Report
3.4.2
copy
3.1
Pop-up Menus
 FishStat Plus Help Manual 47

3.4.6 Tables and Charts

When should you use it?

7.0
• To print tables and charts using the data in your Dataset . The Tables and charts option gives you
3.4.4 3.4.5
all the versatility found in the Tables option and in the Charts option, including control of the X-,
Y-, and Z-axes, range-limiting of the axes, etc.

• The only difference is that with this command both Tables and charts are produced at the same time.

• This can sometimes complicate the process of producing a report, since a change in the keys (X-, Y-,
and Z-axes) affects both the tables and the charts. To overcome this difficulty, experiment with the
5.4
Chart Direction option

Where do you find it?

10.3
• On the Menubar click <Output> and select <Tables and Charts>.

10.3
• From the Toolbar click or . The program will display a drop-down menu with four
commands. Select <Tables and Charts>.
10.1
• On the Keyboard , press <Ctrl+B> or press <Alt> then <O> and then <A>.

How does it work?

3.4.5
• Following the selection of "Tables and Charts " the program opens the Report Type dialog box. Be
5.4
sure and experiment with the very important Chart Direction command.

See also:
5.0
Report Wizard
3.4.5
Charts
3.4.4
Tables
3.4.3
Simple Report
3.4.2
copy
3.1
Pop-up Menus
 FishStat Plus Help Manual 48

3.4.7 Printer Setup

When should you use it?

• To select and configure the printer.

• FishStat Plus has its own printer configuration. All changes made in this dialog box are local to
FishStat Plus. This allows you to use a printer other than the default Windows printer, and/or use
the printer with different settings. This behaviour is by design.

Where do you find it?

10.3
• On the Menubar click <Output> and select <Printer Setup>.
10.1
• On the Keyboard , press <Ctrl+N> or press <Alt> then <O> and then <N>.

• Or from any of the Report Wizard's eight screens, click from the Toolbar. The program will
5.11
display the Destination dialog box. If printer output is selected, the Printer <Set Up> button will be
enabled.

How does it work?

Printer Settings
• Paper source size of paper loaded
• Paper which tray the printer will use as its Paper Source
• Orientation Portrait or Landscape
• Resolution Print quality
• Number of Copies how many reports to print
• Duplex double-sided printing

Tip: These settings are controlled by your printer's driver software and can only be changed by
altering the configurations found in the printer driver software. See the instructions below: "To change
printer settings".
 FishStat Plus Help Manual 49

To select printer
• In the Select Printer combo box, click and click on one of the listed printers to select it. There may
be a delay (5-10 seconds) following printer selection.

Tip: If there are no printers listed you must connect a printer to your computer and/or install a printer
driver. Consult the instructions that came with your printer.

To change printer settings

• Select the printer (see above) and click <Set Up> or press <Alt+U>. The Printer Options dialog box
will display. Change the settings as desired and press <OK> to return to the Printer Setup dialog box.
Otherwise click <Cancel> to abandon your changes.

Tip: The Printer Options dialog box is a part of the printer driver software provided by your printer
manufacturer. We cannot provide support or help in using this dialog box. Please consult the help file
that came with your printer.

To change margins

• Click or in the Margins box. The margins change one millimetre per click.

Tip: Margins cannot normally be set to less than 3-7 mm, depending on the type of printer. FishStat
Plus will not allow you set margins to less than 3mm or more than 75 mm.

See also:
5.0
Report Wizard
3.4.5
Charts
3.4.4
Tables
3.4.3
Simple Report
3.4.2
copy
3.1
Pop-up Menus
 FishStat Plus Help Manual 50

3.4.8 Report Wizard

When should you use it?

• To output a report to a printer or file. The Report Wizard contains a series of dialog boxes that help
3.4.5
you to format your tables and Charts .

Where do you find it?

10.3
• On the Menubar click <Output> and select either <Tables>, <Charts>, or <Tables and Charts>.

• From the Toolbar click or . The program will display a drop-down menu with four
commands. Select either <Tables>, <Charts>, or <Tables and Charts>.
10.1
• On the Keyboard , press <Ctrl+W> (for Tables), <Ctrl+H> (for Charts), or <Ctrl+B> (for Tables
and Charts), or press <Alt> then <O> and then either <T>(for Tables), <C>(for Charts), or <A>(for
Tables and Charts).

How does it work?

• The Report Wizard is an integrated output solution designed to save you time while maximising the
layout and content of your reports. Along the bottom of every Report Wizard dialog box is a
specialised Toolbar:

#Tables Chart Dir Sel Col Table Pre Chart Pre FWD

REV #Col Sel Rows Table Opt Chart Opt Print Exit

• The Toolbar takes you from any Report Wizard screen to any Report Wizard screen.
3.4.4
• To learn more about the Report Wizard's screens, continue to Report Tables , the first step in the
Report Wizard.

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 51

3.5 Tools Menu

3.5.1 Introduction

The three commands in the Tools Menu are for viewing dataset information, creating Aggregate
6.2.1
Sets , and configuring the look and feel of the program
3.5.2
• Format Numbers
3.5.3
• Format Hilite
3.5.4
• Custom Group
3.5.5
• Language and Font
3.5.5
• Dataset Notes
• Map

See also:
3.2
File Menu
3.3
Data Menu
3.4
Output Menu
10.1
Four Ways to Use the Menu
10.1
Keyboard Reference
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 52

3.5.2 Format Numbers

When should you use it?

8.2 8.4 8.5
• To change the numerical display format for Calculated , Rank , and Time-series Columns .

Tip: Changes to a Time-series Column are applied universally to all Time-series Columns.

Tip: to change the way FishStat displays unknown, estimated, and negligible records, you must
select <Format Hilite> from the <Tools> menu.

Where do you find it?

10.3
• On the Menubar click <Tools> and select <Format Numbers>.
10.1
• On the Keyboard , press <Ctrl+F>, or press <Alt> then <T> and then <F>.

How does it work?

• In the window on the left is a list of all the user-created (Calculated) Columns, and a single-entry for
8.5
Time-series (a display format change to a Time-series Columns affects all Time-series Columns).

• Select the column you want to format.

To change the number of significant digits

• Select from the "At least/most" combo boxes, and then enter a value or click to specify the number
of digits.

To change the display format between "," (comma) and decimal point "."

• Click .

To display values in scientific (exponential) notation

• Click .
 FishStat Plus Help Manual 53

To display values as percentages (useful for some values)

• Click .

When the numbers are formatted/reformatted

• Click <OK> or press <Enter>. The program will return you to your previous screen. Otherwise click
<Cancel> to abandon your changes.

See also:
3.3.4
Edit Columns
3.5.3
Format Highlight
3.1
Pop-up Menus
 FishStat Plus Help Manual 54

3.5.3 Format Special Values (Hilite)

When should you use it?

• To change the display format of Special Values, i.e. unknown, estimated, negligible, wrong unit, and
repeated data (numbers).

Tip: to change the way FishStat displays other numbers, you must select <Format Numbers> from
the <Tools> menu.

Where do you find it?

10.3
• On the Menubar click <Tools> and select <Format Highlight>.
10.1
• On the Keyboard , press <Ctrl+A>, or press <Alt> then <T> and then <A>.

How does it work?

• The program displays the Hilite box:

• Click on any combo box to view the available display formats, and click on any of them to change
the display format for that field.

• To eliminate the use of colour for a particular field, clear its checkbox by clicking it.

1. Unknown value
• Considered as zero for calculations, but less than zero when sorting.

2. Negligible value
• Considered as zero in calculations, but slightly greater than zero when sorting.
 FishStat Plus Help Manual 55

3. Zero

4. FAO Estimate
• Data was unavailable and was estimated.

5. Repetition
• Data on a year was unavailable and was assumed to be identical to the previous year.

6. Wrong Unit
• Data for the record is in a unit which does not match the standard unit for the dataset.

Tip: when calculating, the program will preserve Special values to the fullest extent possible, e.g. the
sum of two unknown values is also an unknown value, the sum of two negligible values - a negligible
value, etc. In complex cases, all flags are removed and the result of the calculation is considered a
"normal" number.

• If you're happy with your choices, click <OK> and the program will return you to your previous
screen. Otherwise click <Cancel> to abandon your changes.
 FishStat Plus Help Manual 56

See also:
3.3.4
Edit Columns
6.1.2
Column Options
3.1
Pop-up Menus
 FishStat Plus Help Manual 57

3.5.4 Custom Group (Group Manager)

When should you use it:

3.3.3
• To create, delete, rename, edit, or copy Custom Groups for use within the Aggregation and
3.3.2 3.3
Filter commands of the Data Menu .

Where do you find it:

6.2.1
• From within the Aggregate Set dialog box click <Groups>. The program will display the Group
Manager dialog box.
10.3
• On the Menubar click <Tools> and select <Custom Groups>
10.1
• On the Keyboard , press <Ctrl+L> or press <Alt> then <T> and then <C>.

How does it work?

3.3.2
• If you've done any Filtering the Group Manager dialog box should look somewhat familiar.

• You can switch from Key Column to Key Column by clicking the tab names that run along the top of
the dialog box (or by pressing <Ctrl+PgDwn> & <Ctrl+PgUp>).

• The existing Custom Groups for each Key Column are displayed in the centre window. To work with
10.1
an existing Group, highlight it by clicking it or scrolling with the Keyboard <Arrows>.

Once an existing Group is selected you may

• <Delete> This will remove the Group from the list.
6.2.3
• <Edit> Takes you to the Edit Group dialog box where you can change the Group's makeup.

• <Rename> Allows you to rename the Group.

• <Copy> Creates a copy of the Group and also allows you to rename it.
 FishStat Plus Help Manual 58

To create a new Custom Group

• Select the desired Tab (Key Column) and click <Create>. The program will bring up the Edit Group
dialog box.

To exit
1.3
• Click <Close>. The program will return you to the Main Window .

See also:
6.2.3
Edit Group
6.2.1
Aggregate Set
3.3.3
Aggregation
3.3.2
Filter
6.2.2
Custom Filter
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 59

3.5.5 Language and Font

When should you use it?

• To change the language and/or the font of the program.

Where do you find it?

10.3
• On the Menubar click <Tools> and select <Language and Font>.
10.1
• On the Keyboard , press <Ctrl+L> or press <Alt> then <T> and then <L>.

How does it work?

• The program displays the Options dialog box:

To change the system language

• Click at the right of the System Language combo box and select a language from the list by
clicking it.

To change the system font

• Click the Font window. The program will display a standard Windows Font Selection dialog box.
From this box you can choose the type of font, then click <OK> to return to the Options dialog box.
Otherwise click <Cancel> to abandon your changes.

Tip: for font changes to take effect, please restart FishStat Plus.

Tip: the Windows Font Selection dialog box is a part of the Windows software. For additional help
on this dialog box please consult Windows help.

When finished
• Click <OK> to save changes and exit
• Click <Cancel> to abandon changes and exit.

See Also
3.3.4
Edit Columns
3.5.3
Format Highlight
6.1.2
Column Options
3.1
Pop-up Menus
 FishStat Plus Help Manual 60

3.5.6 Dataset Notes

When should you use it?

• To view bibliographic information for the current dataset.

Where do you find it?

10.3
• On the Menubar click <Tools> and select <Dataset Notes>.

How does it work?

• The program opens a text box containing all of the available bibliographic information.

To export the information

1. Highlight it by clicking the mouse pointer at the beginning of the text and dragging the mouse down
the page. Alternately, you can place the cursor at the beginning of the text and hold down the <Shift>
key while pressing the down <Arrow>.

2. Press <CTRL+ C>. This copies the highlighted text to the Windows clipboard.

3. Open the application into which you want to paste the text.

4. Place the cursor where you want to paste the text and select the application's paste function or try
pressing <CTRL+ V>.

When finished
• Click <Close> to exit and return to the Main Window

See Also
3.3.4
Edit Columns
3.5.3
Format Highlight
6.1.2
Column Options
3.5.2
Format Numbers
3.1
Pop-up Menus
 FishStat Plus Help Manual 61

3.5.7 Map

When should you use it?

• To view the map associated with the dataset.
• Most often, this map will be broken down by Area and labelled using FAO numeric codes.
Tip: not all datasets contain maps.

Where do you find it?

10.3
• On the Menubar click <Tools> and select <Maps>.

How does it work?

• The program displays the map:

When finished
• Click <Close> to exit and return to the Main Window

See Also
10.2
Notes
3.5.6
Dataset Notes
6.1
Formatting
 FishStat Plus Help Manual 62

4 Building Expressions
4.1 Expression Builder

When should you use it?

8.2
• To build the expression for a Calculated Column .

Where do you find it?

3.3.4
• From the Edit Columns dialog box, click

How does it work?

• The Select Function dialog box will appear. On the left are the Function Types, and on the right are
the functions or operators found within each type (if you've ever used the expression builders within
Microsoft Excel™ or Access™ you'll find yourself in familiar territory).

• Click a Function Type from the menu on the left, and then click a function or operator from the menu
on the right.
4.2
• Click <OK> to continue building your expression in the Edit Expression dialog box. Otherwise click
<Cancel> to abandon your changes.

Tip: an explanation for each parameter is displayed by the ToolTip window. Move the mouse over a
parameter to get help on it.

See also:
4.2
Edit Expression
3.3.4
Edit Columns
8.2
Calculated Column
 FishStat Plus Help Manual 63

4.2 Edit Expression

When should you use it?

• To edit an existing expression, or to complete a new expression.

Tip: expressions can be nested, i.e. subexpressions can be placed inside of expressions.

Where do you find it?

4.1 4.4
• In the Expression Builder dialog box, once the function has been selected the Edit Expression
dialog box will be displayed.
3.3.4
• From the Edit Columns dialog box, if <Sum> or <Average> are clicked, the Edit Expression
dialog box will be displayed.
8.2
• From the Edit Columns dialog box, if an existing Calculated Column is selected and <Edit> is
clicked, the Edit Expression dialog box will be displayed.
3.1
• To edit an existing Calculated column simply right-click it and select <Edit> from the Pop-up Menu .

How does it work?

• The Edit expression dialog box will display with some variation depending on the function selected:

• In the blue title bar you should see "Edit Expression [Function you selected]".

Depending on the parameter type you may be able to enter one of the following
• Number
 FishStat Plus Help Manual 64

Tip: for any number that is the number of a year in the dataset range, FishStat will automatically
interpret as a year and not a numeric constant. To force the program to recognise a constant as a
constant add ".0" to the end of it, e.g. "1994.0"

• Text

• Year (or quarter for a dataset that contains more than one column per year.)
Tip: for years simply type in the four digit year. FishStat will automatically precede it with "@" to
indicate that it's not a numeric constant.

• Subexpression -- click the button to enter a nested (recursive) expression, i.e. you can use a
subexpression as a parameter to another expression.

• key -- click to select a Key Column.

You will see (depending on the function selected) one or more of the following input boxes
(This is a glossary of all possible parameters).

• Complexity: if set to 'Low', FishStat Plus recognises three shapes: Up, Down, and Stable. If set to
'High' it recognises approximately twenty shapes.
4.4.5
(Statistical Functions )

• Digits after decimal point: rounds contents of 'source number'. A positive number affects decimal
places, e.g. a of '1' makes 1234 = 123, a negative number affects whole numbers, e.g. a of '-1'
makes 1234 = 10.
4.4.2
(Conversion Functions )

• Expression 1: first string or string expression against which to apply a function or operator.
4.4.1 4.4.3
(Arithmetical & Logical Operators )

• Expression 2: second string or string expression against which to apply a function or operator.
4.4.1 4.4.3
(Arithmetical & Logical Operators )

• Expression To Test: expression that must be examined. If result is non-zero, function returns 2,
otherwise it returns 3
4.4.3
(Logical Operators )

• Forecast Year: sets year for which forecast is calculated

4.4.5
(Statistical Functions )

• Format String: contains format mask used to convert a number into a string
4.4.2
(Conversion Functions )

• Ignore Case: if set to True FishStat Plus does not differentiate between upper- and lower-case, e.g.
A=a
4.4.6
(String Functions )

• Minimum/Maximum Value: all Columns containing values outside this range are ignored
4.4.5
(Statistical Functions )

• Number of Symbols: length of substring returned by function. If sub string is found to be longer than
source string, then function returns all of it
(Substring)
 FishStat Plus Help Manual 65

• Regression Model: select line truest to data: linear (straight line), exponential (exponent curve), or
better fit
4.4.5
(Statistical Functions )

• Return if False: expression result (number or numeric expression) if Expression to test returns zero
4.4.3
(Logical Operators )

• Return if True: expression result (number or numeric expression) if Expression to test does not
return zero
4.4.3
(Logical Operators )

• Skip Estimates: If set to YES, estimates are not counted, or are not counted when looking for the
maximum.
4.4.5
(Statistical Functions )

• Skip Negligible Values: if set to Yes FishStat Plus ignores negligible values, marking them as <05
4.4.5
(Statistical Functions )

• Skip Unknown Values: if set to Yes FishStat Plus ignores unknown values, also when looking for a
minimum, and displays them as ...
4.4.5
(Statistical Functions )

• Skip Zero Values: if set to Yes FishStat Plus ignores null values, also when looking for a minimum
4.4.5
(Statistical Functions )

• Source Number: contains number or expression to be rounded or to be formatted as text

4.4.2
(Conversion Functions )

• Source String: contains a string or a string expression that will be converted into a number or have a
substring extracted or return a length function.
(Substring)

• Source Years: a list of years from which to calculate an average, draw an analytical shape, calculate
a total/fluctuation/linking ratio/average/exponential growth/sum/slope, produce a count, find a
minimum/maximum, or make a forecast
4.4.5
(Statistical Functions )

• Start Position: Position from which function begins searching for substring, or a substring extraction
start-point
(Substring)

• String 1: first string to concatenate

4.4.6
(String Functions )

• String 2: second string to concatenate

4.4.6
(String Functions )

• String to Search for: function searches for this substring within string specified in 1 or 2
4.4.6
(String Functions )

• Sum of: determines whether to sum squares, logarithms or inverse values.

4.4.5
(Statistical Functions )

• Type of Average: determines whether method used to average is arithmetic, geometric, harmonic,
square mean, or median
4.4.5
(Statistical Functions )
 FishStat Plus Help Manual 66

• Weight factor: if set to YES, data from recent years have more influence on regression and forecast
equations than data from earlier years, e.g. for a 2001 forecast, the years 1996-2000 would have
more influence than years 1986-1991
4.4.5
(Statistical Functions )

• Years List: a list of years from which to calculate an average, draw an analytical shape, calculate a
total/fluctuation/linking ratio/average/exponential growth/sum/slope, produce a count, find a
minimum/maximum, or make a forecast
4.4.5
(Statistical Functions )

These parameters can be fine-tuned with multiple passes.

3.3.4
• Simply click <OK> or press <Enter>. The program will return you to the Edit Columns dialog box.
From there click <OK> or press <Enter> again to view the results of your calculations, or click
<Cancel> to abandon your changes.

• If your new column is unsatisfactory, you may return to the Edit Columns dialog box, select your
8.2
Calculated Column , and press <Edit> to be returned to the Edit Expression dialog box.

See also:
4.1
Expression Builder
3.3.4
Edit Columns
8.2
Calculated Column
 FishStat Plus Help Manual 67

4.3 Calculated Column

These are Columns defined by the user.

7.0
• You can add new Columns to a Dataset and configure them with formulas containing arithmetical
4.4.5
operators such as +, -, /, *, Statistical Functions such as sum, average, exponential growth or
4.4
forecast, and many other expressions functions, and operators .

• A Calculated column may contain numerical data or text, depending on the formula.
4.1
• When you define a Calculated column, you use the Expression Builder and its built-in formulas.
This way, you can't make a mistake in spelling or syntax.
8.2
• Expressions in Calculated Columns are always evaluated after filtering and aggregation have been
8.5
finished. These expressions may include constants as well as key and Time-series Columns values
as parameters.

To create a new Calculated column

3.3.4
• Use Edit Columns or right-click any column and select <New Calculated column> from the Pop-
3.1
up Menu .

To edit an existing Calculated column

3.1 3.3.4
• Right-click it and select <Edit> from the Pop-up Menu , or access it via Edit Columns .

See also:
8.4
Rank Column
8.5
Time-series Column
4.1
Expression Builder
3.3.4
Edit Columns
6.1.2
Column Options
6.1
Format
4.2
Edit Expression
3.1
Pop-up Menus
 FishStat Plus Help Manual 68

4.4 Expression Function List

4.4.1 Arithmetical Operators

* (multiply) multiplies two numeric expressions

+ (add) adds two numeric expressions
- (subtract) subtracts two numeric expressions
/ (divide) divides two numeric expressions
^ (power) calculates power of selected number
Minimum selects smallest value among selected years
Maximum selects greatest value among selected years
Round truncates decimal part of a number, or converts a real number into an integer
 FishStat Plus Help Manual 69

4.4.2 Conversion Functions

Convert converts a string into a number when possible. Otherwise, returns Ø

Format formats number according to parameters found in format string
Round truncates decimal portion of a number, or converts a real number into an integer
 FishStat Plus Help Manual 70

4.4.3 Logical Operators

AND Returns TRUE (-1) if both operands are not Ø. Otherwise, returns Ø
IIF (numbers) Returns one of two numeric expressions depending on value of first argument
IIF (strings) Returns one of two string expressions depending on value of first argument
NOR Returns TRUE (-1) if both operands are zero. Otherwise, returns Ø
NOT Returns TRUE (-1) if operand is zero
OR Returns TRUE (-1) if at least one operand is not zero. Otherwise, returns Ø
XOR Returns TRUE (-1) if any one operand is Ø, and another is not. Otherwise, returns Ø
 FishStat Plus Help Manual 71

4.4.4 Numeric & String Comparison Operators

< (less than) Returns TRUE (-1) if the first number or string is less or comes
alphabetically before the second.
<= (less than or equal to) Returns TRUE(-1) if the first number or string is less than or equal
or comes alphabetically before or is identical to the second.
<> (not equal) Returns TRUE (-1) if the compared numbers or strings are unequal
or different.
= (equal) Returns TRUE (-1) if the compared numbers or strings are equal or
identical.
(greater than) Returns TRUE (-1) if the first number or string is greater or comes
alphabetically after the second.
>= (greater than or equal to) Returns TRUE (-1) if the first number or string is greater than or
equal or comes alphabetically after or is identical to the second.

Tip: these operators will often be used together with the Logical Operator IIF to output one of two
values depending on a condition.
 FishStat Plus Help Manual 72

4.4.5 Statistical Functions

Analytical shape "up-down" means - numbers went up, and then down. "up-UP" -
they went up a little, and then UP a lot. "DOWN-up" - they went
down a lot, and then up a little, etc.
Average Average value for selected years
AverageX Average of squares, logarithms, or inverse values
Coefficient of Determination between 0 (fluctuation/unreliable) and 1 (ideal fit/reliable), is deviation
explained by linear/exponential regression. Model it using linear,
exponential, or better-fit curves, possibly with 'weight' method
Correlation between values for 'year' and 'time-series'. It ranges from -1 (decline)
to +1 (increase), with 0 representing no change or fluctuation
Count Years function counts the number of Time-series Columns that fall within a
specified range of years.
Exponential growth this is average increase or decrease per year expressed as a
percentage
Fluctuation the average change for the period selected
Forecast for any year. Select a function: linear, exponential, or 'better fit' (and
possibly 'weight' method)
Slope average increase or decrease per year in absolute numbers
Standard Deviation gives an indication of the amount of scatter from the measure of
central tendency
Sum Sum of values for selected years
SumX Sum of squares, logarithms, or inverse values
Trend value change relative to average value. Lies between -1 (rapid
decline to 0) and +1 (rapid growth from 0)
 FishStat Plus Help Manual 73

4.4.6 String Functions

Concatenate appends one string to another.

Format formats a number according to the parameters of the format string.
InString looks for a substring within a string. If found, it returns the substring's starting
position, otherwise it returns Ø.
Left substring returns characters from a string's beginning.
Length of string returns the number of characters in a string.
Middle substring returns characters from the middle of a string.
Right substring returns characters from the end of a string.
 FishStat Plus Help Manual 74

5 Report Wizard
5.1 Introduction

When should you use it?

• To output a report to a printer or file. The Report Wizard contains a series of dialog boxes that help
3.4.5
you to format your tables and Charts .

Where do you find it?

10.3
• On the Menubar click <Output> and select either <Tables>, <Charts>, or <Tables and Charts>.

• From the Toolbar click or . The program will display a drop-down menu with four
commands. Select either <Tables>, <Charts>, or <Tables and Charts>.
10.1
• On the Keyboard , press <Ctrl+W> (for Tables), <Ctrl+H> (for Charts), or <Ctrl+B> (for Tables
and Charts), or press <Alt> then <O> and then either <T>(for Tables), <C>(for Charts), or <A>(for
Tables and Charts).

How does it work?

• The Report Wizard is an integrated output solution designed to save you time while maximising the
layout and content of your reports. Along the bottom of every Report Wizard dialog box is a
specialised Toolbar:

#Tables Chart Dir Sel Col Table Pre Chart Pre FWD

REV #Col Sel Rows Table Opt Chart Opt Print Exit

• The Toolbar takes you from any Report Wizard screen to any Report Wizard screen.
3.4.4
• To learn more about the Report Wizard's screens, continue to Report Tables , the first step in the
Report Wizard, or click on any of the command buttons found in the above graphic.

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 75

5.2 Report Tables and Charts

When should you use it?

3.4.3
• This dialog box is the first step towards outputting any report (other than a Simple Report ).
3.4.5
• Here you decide which Key Column to design your tables (Charts ) around. FishStat can design a
new table (chart) for every Object in the Key Column you choose.

Where do you find it?

• Report Type can be selected at any time from the FishStat Toolbar by clicking or from the

Report Wizard Toolbar by clicking

How does it work?

• Towards the bottom left of the screen you'll see a box listing your Columns. The column "Year"
8.5
represents the Time-series Columns as a whole.

• Click any entry to define it as a Table (Chart) key. A red check mark will appear next to each column
you click. To the right of the column window FishStat displays the estimated number of tables
3.4.5
(Charts ) your current selection is expected to create. If your selection seems to create too many
tables (Charts), other Report Wizard screens will allow you to limit the final number by excluding
data.
 FishStat Plus Help Manual 76

Tip: if exporting to a file for use in another program, you may want to leave all your information in one
table, and not divide it up. In this case choose "Do not partition report."

To advance to the next screen and choose which keys you want as Columns, click either or

See also:
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 77

5.3 Report Columns

When should you use it?

• Use this option to control which columns end up in your report. Any column not chosen will be placed
in the rows.

Where do you find it?

• Report Columns is the second of the Report Wizard's screens. It can be selected at any time from the

Report Wizard's Toolbar by clicking .

How does it work?

• In the "Start a new column (point set) for each" window are listed all your available Columns. Note that
any column you previously chose to be a Table key is not available for selection.

• Click any entry to add it to your table Columns (chart point sets). A red check mark will appear in the
box next to it, and to the right FishStat will display the estimated number of Columns (point sets) your
current selection is expected to produce. If your selection creates too many, other Report Wizard
screens allow you to limit the number by excluding data.

Tip: you can also force a limit to the number of Columns (point sets) by checking "Limit number of
Columns (point sets) to" and then typing a number in the input box. FishStat will display the Columns
(point sets) with the highest values and aggregate the rest as "Other".

• Any column you select is moved to the top of the stack. If you select more than one, a set of blue
arrows appear within the column window. By clicking these you can decide which is at the top of the
stack. This affects which key FishStat uses as your primary column key.
 FishStat Plus Help Manual 78

To advance to the next screen and choose what data to output, click either or .

See also:
3.4.4
Report Tables
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 79

5.4 Report Rows & Chart Direction

When should you use it?

• This screen allows you to fine-tune the organisation of your table rows, as well as alter the layout of
your charts.

Where do you find it?

• Report Rows and Chart direction is the third of the Report Wizard's screens. It can be selected at any

time from the Report Wizard's Toolbar by clicking .

Tip: the lower-half of the dialog box will only appear if you are in <Charts and Tables> mode.

How does it work?

In Tables-only mode
• The top of the dialog box lists the table and column choices you've made in the previous screens and
then lists the leftover Key Columns that will make up the rows together with an estimate of how many
rows will be created.

• If the number of rows seems too high, click the "Limit number of rows to" check box and enter a
number into the input box. FishStat will display the most significant rows and aggregate the remainder
in a row labelled "Other."

Tip: you can also limit the number of rows in the later Report Wizard screens by excluding data.

In Charts-only mode
 FishStat Plus Help Manual 80

• The top of the dialog box lists the Chart and Point Set choices you've made in the previous screens
and then lists the leftover Key Columns that will make up the Points together with an estimate of how
many Points will be created.

• If the number of Points seems too high, click the "Limit number of points to" check box and enter a
number into the input box. FishStat will display the most significant points and aggregate the remainder
in a point labelled "Other."

Tip: you can also limit the number of points in the later Report Wizard screens by excluding data.

If in Tables and Charts mode, for help on Chart Direction click here.

See also:
3.4.4
Report Tables
5.3
Report Columns
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 81

5.5 Select Data Columns

When should you use it?

3.4.3
• This dialog box is the fourth step towards outputting any report (other than a Simple Report ).

• Here you can limit the inclusion of dataset Columns. When FishStat Plus prepares your report, it will
ignore any Columns you've put in the Exclude field.

Where do you find it?

• The Select dataset Columns dialog box can be selected at any time from the Report Wizard's Toolbar

by clicking:

How does it work?

• The default is for all Columns to be included. A convenient method is to send them all to the Exclude

window by clicking , and then selecting the Columns you want to include by holding down the
<CTRL> key and clicking them one-by-one.

• You can also select a range by clicking on the first or last column you want to include and holding
down the mouse button while dragging up or down. The process is essentially identical to the one
3.3.2
explained in detail for the Filter dialog box.

• Once you've completed your selection, send them over to the Include box by clicking .

10.3
• Use the Scrollbar in the middle of the dialog box if some Columns you need to include/exclude are
outside of the Include/Exclude window.
 FishStat Plus Help Manual 82

If satisfied, to advance to the Source Records screen click either or .

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 83

5.6 Select Source Records

When should you use it?

3.4.3
• This dialog box is the fifth step towards outputting any report (other than a Simple Report ).

• Here you can limit the inclusion of records (rows). When FishStat Plus prepares your report, it will
ignore any rows you've put in the Exclude field.

Where do you find it?

• The Select Source Records dialog box can be selected at any time from the Report Wizard's Toolbar

by clicking:

How does it work?

• The default is for all records to be included. A convenient method is to send them all down to the

Exclude window by clicking , and then selecting the rows you want to include by holding down
the <CTRL> key and clicking them one-by-one.

• You can also select a range by clicking on the first or last row you want to include and holding down
the mouse button while dragging up or down. The process is essentially identical to the one used in
5.5
the Select Data Columns dialog box.

• Once you've completed your selection, send them up to the Include box by clicking .

10.3
• Use the Scrollbar in the middle of the dialog box if parts of a record you need to see are outside of
the Include/Exclude window.
 FishStat Plus Help Manual 84

If satisfied, to advance to the Table Options screen click either or .

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.7
Table Options
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 85

5.7 Table Options

When should you use it?

• This dialog box is the sixth step towards outputting any Table-based report (other than a Simple
3.4.3
Report ).

• In this dialog box you can name your table, change the font and font size, and toggle several other
options to maximise the layout.

Tip: If you're producing a Chart-only report this screen will not appear nor will you see it among the
command buttons in the Report Wizard Toolbar.

Where do you find it?

• Table Options can be selected at any time from the Report Wizard's Toolbar by clicking:

How does it work?

To name the table:
• Click anywhere in the Table header input box found at the top of the dialog box and start typing.

• Next, if your report is larger than the physical page upon which it will be printed, decide whether you
want to repeat the header on every page regardless of whether or not the page represents the
beginning of a new chart. To change this option, toggle the "Repeat" / "Do not Repeat" buttons found
in the middle right of the dialog box.

Tip: "Repeat" is a good way to increase readability for large tables. "Do not Repeat" is a space-saver,
and also useful if you plan to "glue" together the pages of your output.
 FishStat Plus Help Manual 86

To change the Font and the Font size

• Down at the bottom of the dialog box your Table's font and font size are listed. If you'd like to change
them just click the Font box and a standard Windows™ Font Selection dialog box opens. Make your
selections, click <OK> and you'll be returned to the Table Options dialog box. Otherwise click
<Cancel> to abandon your changes.

Tip: The Windows Font Selection dialog box is a part of the Windows software. For help on this
dialog box please consult Windows help.

Merging Identical cells

• This option determines how FishStat Plus lays out the Row or Column headings when making a
table. Below are two examples, the first merged, the second not merged:

To advance to the Table preview screen click either or .

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.8
Table Preview
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 87

5.8 Table Preview

When should you use it?

• This dialog box is the seventh step towards outputting any Table-based report (other than a Simple
Report).

• In this dialog box you can view your table before it is printed or exported.

Tip: If you're producing a Chart-only report this screen will not appear nor will you see it among the
command buttons in the Report Wizard Toolbar.

Where do you find it?

• The Table Preview dialog box can be selected at any time from the Report Wizard's Toolbar by

clicking:

How does it work?

• Note the combo box in the bottom middle of the dialog box. It contains the list of pages (Z-axis
values. The "subject" of each table).

• Click to view the list. Click any item on the list to switch to its table.

To print the current table

• Click the printer icon .

To copy the current table to the clipboard

 FishStat Plus Help Manual 88

• Click the copy icon .

If you don't like what you see

Often tables can get too crowded, and/or too numerous. If this is the case with your table:

5.3
• Go back to the Report Columns dialog box and set a value for Max. Columns or go back
5.4
to the Report Rows and Chart Direction dialog box and set a value for Max. Rows.

5.5
• Go back to the Select Dataset Columns dialog box by clicking and exclude some Columns.

5.6
• Go back to the Select Source Records dialog box by clicking and exclude some rows.

You may also want to consider

• Going back to Report Tables and choosing a different Table key, or even adding a second Table key.
The more you stack the Report Table with keys, the simpler each table will be.

Tip: If you're working in Tables and Charts mode any changes you make to the axes will affect
your charts as well. If you find that altering the axes has fixed your tables but destroyed your
charts, try repairing your charts with the Chart Direction, and the Chart Options dialog boxes.

Remember, you can back up to ANY of the Report Wizard dialog boxes, or even further back, to change any
3.3.2 3.3.3
of the Filtering or Aggregating you've done. Remember, the underlying dataset remains the same. It's
possible at any time to back up and rethink the choices you've made.

If you like what you see

If in Tables and Charts mode, advance to the Chart Options screen by clicking . Otherwise click

to Output your table.

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.9
Chart Options
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 89

5.9 Chart Options

When should you use it?

• This dialog box is the sixth step towards outputting any Chart-based report. If you're producing both
3.4.6
Tables and Charts this screen will appear as the eighth step.

• In this dialog box you can choose the type of chart, colour palette, title, as well as a number of other
parameters to fine-tune your chart layout.

Tip: If you're producing a Table-only report this screen will not appear nor will you see it among the
command buttons in the Report Wizard Toolbar.

Where do you find it?

• The Chart Options dialog box can be selected at any time from the Report Wizard's Toolbar by

clicking:

How does it work?

1. Select the Chart type

Line: plot values as a series of lines

Bar: plot values as a series of bars

Pie: plot values as a pie chart

 FishStat Plus Help Manual 90

Area: plot values as an area chart

Logarithmic Line: plot values as a series of lines with the Y-axis set to a logarithm.

3-D Bar: plot values as a series of 3-D bars

3-D Pie: plot values as a 3-D pie chart

2. Select the Colour Palette

Black-and-white: only black-and-white patterns.

Greyscale: a series of greys.

Pastel: pastel colours

Bright: bright colours

3. Select Other Chart Options

The Chart options change depending on the Chart type. Below is a complete list of all Chart options:
• Title chart title

• Line Graph - show symbols: marks with a unique symbol, every point at which a Chart Set meets a
Chart Point, i.e. every actual value or related set of values.
• Line Graph - show sticks: draws a line from the Chart Points to their Chart Sets, i.e. to the point at
which there are actual data.
• Line Graph - show lines: if set to "No", only symbols and/or sticks are displayed, and the lines
connecting actual values are removed.

• Label Every: if set to greater than "1", skips Chart Points when labelling. Useful when charts with
repetitive information get too crowded.
• Show ticks: tick marks along the X- and/or Y-axes can be toggled on and off.
• Show Grid: a backing grid pattern to the chart can be toggled on and off.
• Show [key/Time-series Column] in legend: column headings can be toggled on and off. Useful
when charts get too crowded.

• Bar Graph – Orientation: controls whether the bars run vertically or horizontally.
• Bar Graph – Style: "normal" means that the Chart Set values are placed in bars that stand side-to-
side at the Chart Point.

• Pie labels with lines: controls whether lines are drawn from the labels to their pie-pieces.
• Pie labels in colour: controls whether the labels are black or the same colour as their pie-pieces.
• Pie labels as: controls whether the labels consist of the actual values of the pie-pieces, the
percentage each pie-piece is of the total pie, the keys (titles) of the pie-pieces, or whether the labels
are nothing (hidden).
 FishStat Plus Help Manual 91

• Area Graph - Style absolute: starts each Chart Set from zero (some chart sets may become
hidden), Stacked places them one on top of the other, so that each Chart Set's value for a given
Chart Point begins not at zero but at its lowest area, Percentage shows each area as a percentage
of the total so that the width of a Chart Set at any given Chart Point reflects its percentage of the
whole at that point.

Advance to the Chart preview screen by clicking either or .

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.10
Chart Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 92

5.10 Chart Preview

When should you use it?

• This dialog box is the seventh step towards outputting any Chart-based report (other than a Simple
3.4.3 3.4.6
Report ) unless you selected Tables and Charts , in which case it is the ninth.

• In this dialog box you can view your chart before it is printed or exported.

Tip: If you're producing a Table-only report this screen will not appear nor will you see it among the
command buttons in the Report Wizard Toolbar.

Where do you find it?

• The Chart Preview dialog box can be selected at any time from the Report Wizard's Toolbar by

clicking:

How does it work?

• Note the combo box(es) in the bottom middle of the dialog box. It/they contain(s) the list of tables, i.e.
the "subject" of each chart).

• Click to view the list(s). Click any item on a list to switch to that chart. Depending on the choices
you've made, you may find that you have an enormous number of charts.

To print the current chart

• Click the printer icon .

To copy the current chart to the clipboard

 FishStat Plus Help Manual 93

• Click the copy icon .

If you don't like what you see

3.4.5
Often Charts can get too crowded and/or too numerous. If this is the case with yours:

5.3
• Go back to the Report Columns dialog box and set a value for Max. Columns or go back
5.4
to the Report Rows dialog box and set a value for Max. Rows.

5.5
• Go back to the Select Dataset Columns dialog box by clicking and exclude some Columns.

5.6
• Go back to the Select Source Records dialog box by clicking and exclude some rows.

You may also want to consider

• Going back to Report Tables and choosing a different Table key, or even adding a second Table key.
The more you stack the Report Table with keys, the simpler each chart will be.

5.9
• Go back to the Chart Options dialog box by clicking and try changing some parameters or
the Chart Type, and then return to Chart Preview.

Tip: If you're working in Tables and Charts mode any changes you make to the keys (axes)
will affect your tables as well. To alter your charts without affecting your tables try playing
with the Chart Direction, and the Chart Options dialog boxes.

Remember, you can back up to ANY of the Report Wizard dialog boxes, or even further back, to change any
3.3.2 3.3.3
of the Filtering or Aggregating you've done. Remember, the underlying dataset remains the same. It's
possible at any time to back up and rethink the choices you've made.

If you like what you see

To output your chart and/or table Click or to get to the Output screen.

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.11
Outputting to a File or Printer
3.1
Pop-up Menus
 FishStat Plus Help Manual 94

5.11 Output

When should you use it?

• This dialog box is the last step before report output.

• Type of output (hardcopy or file) and style (file and printer type) are decided here.

Where do you find it?

• The Destination dialog box always appears as the last step when preparing a report. It appears
3.4.3
automatically when Simple Report is selected, and it appears at the end of the Report Wizard

Toolbar as an icon: . You can click this icon at any time from within the Report Wizard

How does it work?

• Press at the right side of the combo box to choose your output, whether it's to the printer or to any
of the supported file types (currently *.html, *.rtf, *.csv, and *.sylk).

• Click your selection.

Tip: for charts, *.rtf is the only supported file type.

If you choose to output to a file

• Type the path and file name in the lower input box
-or-
 FishStat Plus Help Manual 95

Click <Browse> to search for a directory and/or an existing file. The program will open a window for
browsing files and directories. After you've found the directory where you want to write the file, and
you've named a new file or selected an existing file to overwrite, click <OK>. The program will return
you to the Destination dialog box. Otherwise click <Cancel> to abandon your changes.

• Click <Go>. The program will begin outputting the file. This may take several minutes for a large
7.0 5.6
Dataset . You may want to go back to earlier stages of the Report Wizard and limit your records or
5.5
your Columns until you end up with an acceptable number of pages. You may even want to go
3.3
back even further to the Data Menu commands to limit your dataset pre-Report Wizard.

If you choose to output to a printer

• The lower box will display the default printer. You may configure the printer or select a different
default printer by clicking <Set Up> found at the right side of the dialog box.

Tip: If there are no printers listed you must connect a printer to your computer and/or install a printer
driver. Consult the instructions that came with your printer.

• If you're happy with your print options, click <Go>. The program will begin outputting the file. This
7.0
may take more than several minutes if there are a large amount of records in the Dataset . You may
want to consider going back to earlier stages of the Report Wizard and limiting your records or your
Time-series until you end up with an acceptable number of pages. You may even want to consider
3.3
going further back to the Data Menu commands to limit your dataset pre-Report Wizard.

• When the Progress window disappears, FishStat Plus opens a second application that controls the
actual output. This way, you can return to your data and continue working while your report is
produced in the background.

• Take a look at your output (if you chose to output to a file, open an application that can handle the
outputted file and load it).
3.4.3
• If you outputted a Simple Report , it should look almost identical to what you saw in the Data
10.3 5.10
Display . If you created it using the Report Wizard, it should look as it did in the Chart Preview
5.8
and/or Table Preview screens. If not, you may need to configure the associated application, or the
printer.

See also:
3.4.4
Report Tables
5.3
Report Columns
5.4
Report Rows and Chart Direction
5.5
Selecting Columns
5.6
Selecting Source Records
5.7
Table Options
5.8
Table Preview
5.10
Chart Preview
3.1
Pop-up Menus
 FishStat Plus Help Manual 96

6 Customising
6.1 Format

When should you use it?

7.0
• To format the display of Dataset Objects and numbers.

Where do you find it?

10.3
• On the Menubar click <Tools> and select <Format>.
10.1
• On the Keyboard , press <Ctrl+F> or press <Alt> then <T> and then <F>.
3.3.4
• From the Edit Columns dialog box select a Key Column. Click <Format>.
10.3
• From the Data Display , put the mouse pointer in any column and right-click. Choose <Format
3.1
[name of column]> from the Pop-up Menu

How does it work?

• Since this dialog has a variety of functions depending on the type of column you're formatting, please
click the appropriate link:
6.1.1
Formatting a Key Column
3.5.2
Formatting a Time-series Column from the Menubar

3.1.2
Formatting a Time-series Column from the Pop-up Menu

3.5.3
Formatting the Display of Special Values

See also:
3.3.4
Edit Columns
3.5.3
Format Highlight
6.1.2
Column Options
3.5.2
Format Numbers
3.1
Pop-up Menus
 FishStat Plus Help Manual 97

6.1.1 Format Key Column

When should you use it?

• To change the display format of Object (text) records (found in Key Columns).

• To duplicate a Key Column while also changing its display format, e.g. Key Column "Country" can
display twice, once with the country names, and again with the country numeric codes.

Where do you find it?

10.3
• From the Data Display , put the mouse pointer in any Key Column and right-click. Choose
3.1
<Format> from the Pop-up Menu .
3.3.4
• From within the Edit Columns dialog box, select a Key Column and click <Format>.

How does it work?

• The top input box contains the column's header name. Double-click it to edit the existing entry or to
enter a new header.

• The bottom list box contains the available display formats. Click the desired format.

Tip: Using codes can be valuable if you plan to export your data.

• If you're happy with your choices, click <OK> and the program will return you to your previous
screen. Otherwise click <Cancel> to abandon your changes.
 FishStat Plus Help Manual 98

See also:
3.3.4
Edit Columns
3.5.2
Format Numbers
3.5.3
Format Highlight
6.1.2
Column Options
 FishStat Plus Help Manual 99

6.1.2 Numerical Column Options

When should you use it?

8.2 8.4 8.5
• To change the display format for Calculated , Rank , and Time-series Columns .

Tip: Changes to a Time-series Column are applied universally to all Time-series Columns.

Where do you find it?

3.3.4
• From within the Edit Columns dialog box, select a column and click <Format>.
10.3
• From the Data Display , put the mouse pointer in any numeric column and right-click. Choose
3.1
<Format [name of column]> from the Pop-up Menu .

How does it work?

To change the column width
• In the top left corner is the Width input box. Enter a new value or click to change the width of the
selected columns.

To change the number of significant digits

• Select from the "At least/most" combo boxes, and then enter a value or click to specify the number
of digits.

To change the display format between "," (comma) and "." (decimal point)

• Click .

To display values in scientific (exponential) notation

• Click .

To display values as percentages (useful for some values)

 FishStat Plus Help Manual 100

• Click .

For user-created (i.e. Rank and Calculated) Columns

• The column name (header) may also be altered from this box. Simply type the new name in the input
box.

When the numbers are formatted/reformatted

• Click <OK> or press <Enter>. The program will return you to your previous screen. Otherwise click
<Cancel> to abandon your changes.

See also:
3.3.4
Edit Columns
6.1
Format
3.1
Pop-up Menus
 FishStat Plus Help Manual 101

6.2 Creating Groups

6.2.1 Aggregate Set

When should you use it?

3.3.3
• To create, load, or save a new Aggregate Set for use in the Aggregate dialog box. The Aggregate
6.2
Set can consist of individual Objects, standard Groups, and/or Custom Groups .
7.2
• These sets can also be used within other datasets of the same Dataset Family .

Where do you find it?

• From the Aggregate dialog box choose the Key Column you want to customise and select
<Grouped>.

• From the list of Groups to the right of the Key Column scroll to the bottom and choose
<Handpicked>. If the program does not automatically take you to the Aggregate Set dialog box, you

should see the pick button to the left of the word "Handpick". Click it.

How does it work?

Within the Aggregate Set dialog box are four main options

1. To build a handpicked Aggregate Set from scratch:

To select Objects or Groups from the Include/Exclude lists

• The Include/Exclude windows contain expandable lists of both Standard & Custom (if you've created
any) Groups. Click the signs to view the Objects contained within each Group.
• Select a single Object or Group by clicking it with the mouse.
• Select multiple Objects or Groups by click-dragging with the mouse.
• Select Objects or Groups singly by holding down the <Ctrl> key and clicking them with the mouse.
• Select a range of Objects or Groups by clicking the first Object with the mouse and then holding
down the <Shift> key and clicking the last Object in the range or by using the keyboard arrows.

To find Objects or Groups from the Include/Exclude lists

 FishStat Plus Help Manual 102

• Start typing in the Include or Exclude list. A yellow box will appear with the text you typed, and the

Find window will be displayed next to it. If you press a letter key but text in the
yellow box does not change, this means that the text was not found.

• You can either continue typing until the Object or Group you want appears, or type a few characters

and use the Find Next and Find Previous buttons to find occurrences of the text you typed.

• By toggling you can switch between searching only from the beginning of a name or searching
anywhere within a name.

• To find and select ALL Objects or Groups whose names contain the text you typed press the Find All

button.

To move selected Objects or Groups between lists

• Use the blue and red arrow buttons to move selected Objects in the direction indicated by
the arrow, or
• Press <Ctrl+LArrow> or <Ctrl+RArrow>, or
• Drag selected Objects to the opposing list.

2. To load a previously saved Aggregate Set:

• Click <Load>. You will see the Load Aggregate Set dialog box. To load a previously saved
10.1
Aggregate Set double-click its name, or highlight it by clicking it or scrolling with the Keyboard
<Arrows> and then click <OK> or press <Enter>..

• The program will return you to the Aggregate Set dialog box, with your previously saved Aggregate
Set already organised in the Include/Exclude windows. If satisfied, click <OK> or press <Enter>.

• To exit the Load Aggregate Set dialog box without loading a Group click <Cancel> or press the
<Esc> key.

3. To save your current handpicked aggregation as a new Aggregate Set:

• Click <Save>. The program will display the Save Aggregate Set dialog box. Select an existing set to
10.1
overwrite by double-clicking its name, or highlight it by clicking it or scrolling with the Keyboard
<Arrows> and then click <OK> or press <Enter>. Save your set under a new name by typing in the
input box and then clicking <OK> or pressing <Enter>.

• The program will return you to the Aggregate Set dialog box.

• To exit the Save Aggregate Set dialog box without saving a set click <Cancel> or press the <Esc>
key.

4. To create Custom Groups that can later be added to an Aggregate Set:

3.5.4
• Click <Groups>. The program will display the Group Manager dialog box.
 FishStat Plus Help Manual 103

See also:
7.0
Dataset
3.3.2
Filter
3.3
Data Menu
6.2.2
Custom Filters
3.5.4
Group Manager
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 104

6.2.2 Filter Group

When should you use it?

3.3.2
• To save a new Filter Group or load an existing Filter Group for use in the Filter dialog box.
7.2
• Filter Groups can also be used within other datasets of the same Dataset Family

Where do you find it?

• From the Filter dialog box click <Load> to load a previously saved Filter Group or <Save> to save a
new Filter Group.

How does it work?

To save your current filter for later use
• Click <Save>. The program will display the Save Filter dialog box:

3.3.2
• Select an existing Filter to overwrite by double-clicking its name, or highlight it by clicking it or
10.1
scrolling with the Keyboard <Arrows> and then click <OK> or press <Enter>.

• Save your Filter under a new name by typing in the input box and then clicking <OK> or pressing
<Enter>.

• The program will then return you to the Filter dialog box.

• To exit the Save Filter dialog box without saving a Filter click <Cancel> or press the <Esc> key.

To select filter criteria by using a previously saved filter

• Click <Load>. The program will display the Load Filter dialog box:
 FishStat Plus Help Manual 105

• To load a previously saved filter double-click its name, or highlight it by clicking it or scrolling with the
keyboard <Arrows> and then click <OK> or press <Enter>.
3.3.2
• The program will return you to the Filter dialog box, with your Filter Group already organised in the
Include/Exclude windows.

• To exit the Load Filter dialog box without applying a filter click <Cancel> or press the <Esc> key.

See also:
7.0
Dataset
3.3.2
Filter
3.3
Data Menu
6.2.1
Aggregate Set
3.5.4
Group Manager
3.1
Pop-up Menus
 FishStat Plus Help Manual 106

6.2.3 Edit Group

When should you use it?

• To adjust the makeup of an existing Custom Group, or to create the makeup of a new Custom Group.

Where do you find it?

3.5.4
• From within the Group Manager dialog box click <Create> to handpick the makeup of a new
Custom Group.

• To adjust the makeup of an existing Custom Group select one from within the Group manager and
click <Edit>. The program will display the Edit Group dialog box:

How does it work?

3.3.2
If you've worked with the Filter command this dialog box should look very familiar.

To select Objects from the Include/Exclude lists

• Select an Object by clicking it with the mouse.
• Select multiple Objects by click-dragging with the mouse.
• Select Objects singly by holding down the <Ctrl> key and clicking with the mouse, or
• Select a range of Objects by clicking the first Object with the mouse and then holding down the
<Shift> key and clicking the last Object in the range, or by using the keyboard arrows.

To find Objects from the Include/Exclude lists

• Start typing in the Include or Exclude list. A yellow box will appear with the text you typed, and the

Find window will be displayed next to it. If you press a letter key but text in the
yellow box does not change, this means that the text was not found.

• You can either continue typing until the Object you want appears, or type a few characters and use

the Find Next and Find Previous buttons to find occurrences of the text you typed.
 FishStat Plus Help Manual 107

• By toggling you can switch between searching only from the beginning of a name or searching
anywhere within a name.

• To find and select ALL Objects, whose names contain the text you typed press the Find All
button.

To move selected Objects between lists

• Use the blue and red arrow buttons to move selected Objects in the direction indicated by
the arrow, or
• Press <Ctrl+LArrow> or <Ctrl+RArrow>, or
• Drag selected Objects to the opposing list.

To move all Objects between lists

• Use the thick blue and red arrow buttons to move all Objects in the direction indicated by
the arrow, or
• Press <Ctrl+Shift+LArrow> or <Ctrl+Shift+RArrow>.

To move Groups of Objects between lists

• In the middle of the dialog box is the Group combo box where Groups are listed. There is a combo
box across its top that allows you to choose from among different types of Groups, e.g. continents,
economic Groups of countries, etc).

• Click at the right of the combo box to choose a type of Group. As you select different types of
Groups you will notice the Groups below changing.

• To include or exclude all the members of a Group click the appropriate arrow, or click-drag the Group
name into one of the boxes.

Once you're satisfied with the makeup of your Custom Group

• Click <OK> to continue or <Cancel> to abandon your changes.

• If you're editing an existing Group, the program will ask for overwrite confirmation after which you will
3.5.4
be returned to the Group Manager dialog box.

• If you're creating a new Group the program will display the Save Group dialog box.

• Select an existing Group to overwrite by double-clicking its name, or highlight it by clicking it or

scrolling with the keyboard <Arrows> and then click <OK> or press <Enter>.
 FishStat Plus Help Manual 108

• Save your Group under a new name by typing in the input box and then clicking <OK> or pressing
<Enter>.
3.5.4
• The program will then return you to the Group Manager dialog box.

• To exit the Save Group dialog box without saving a Group click <Cancel> or press the <Esc> key.

See also:
7.0
Dataset
3.3
Data Menu
6.2.2
Custom Filter
6.2.1
Aggregate Set
3.5.4
Group Manager
3.3.3
Aggregation
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 109

6.2.4 Group Manager

When should you use it:

3.3.3
• To create, delete, rename, edit, or copy Custom Groups for use within the Aggregation and
3.3.2 3.3
Filter commands of the Data Menu .

Where do you find it:

6.2.1
• From within the Aggregate Set dialog box click <Groups>. The program will display the Group
Manager dialog box.
10.3
• On the Menubar click <Tools> and select <Custom Groups>
10.1
• On the Keyboard , press <Ctrl+L> or press <Alt> then <T> and then <C>.

How does it work?

3.3.2
• If you've done any Filtering the Group Manager dialog box should look somewhat familiar.

• You can switch from Key Column to Key Column by clicking the tab names that run along the top of
the dialog box (or by pressing <Ctrl+PgDwn> & <Ctrl+PgUp>).

• The existing Custom Groups for each Key Column are displayed in the centre window. To work with
10.1
an existing Group, highlight it by clicking it or scrolling with the Keyboard <Arrows>.

Once an existing Group is selected you may

• <Delete> This will remove the Group from the list.
6.2.3
• <Edit> Takes you to the Edit Group dialog box where you can change the Group's makeup.

• <Rename> Allows you to rename the Group.

• <Copy> Creates a copy of the Group and also allows you to rename it.
 FishStat Plus Help Manual 110

To create a new Custom Group

• Select the desired Tab (Key Column) and click <Create>. The program will bring up the Edit Group
dialog box.

To exit
1.3
• Click <Close>. The program will return you to the Main Window .

See also:
6.2.3
Edit Group
6.2.1
Aggregate Set
3.3.3
Aggregation
3.3.2
Filter
6.2.2
Custom Filter
10.1
How to Find Text
3.1
Pop-up Menus
 FishStat Plus Help Manual 111

7 Understanding Datasets
7.1 Introduction

A Dataset is a table containing two types of Columns

• Key Columns define what kind of information is stored in each record (row), e.g. Country or Species.
The dataset may have from 1 to 5 Key Columns.

• Time-series Columns contain numeric information about catch size, production, or trade, usually
organised under one column for each year. The number of Time-series Columns is not limited.

To switch to another Dataset

3.2.2
• Use the Open command.

To transform a Dataset
10.2
• An unprocessed dataset is referred to as a Base Dataset . You can transform a base dataset by
3.3 3.3.2 3.3.3 3.3.4
using the commands found in the Data Menu , such as Filter , Aggregate , or Edit Columns .

10.2
To save a transformed Dataset (referred to as a Reference Dataset )
3.2.4
• Use the Save command. These kind of files are called reference datasets because they contain
references to a base dataset, rather than actual data.
8.5
• Base datasets contain only key and Time-series Columns whereas a reference dataset may also
8.2
contain user-defined Calculated Columns . When you save the dataset, the Calculated Columns are
saved as well.

Tip: when transferring a dataset to another computer you must be sure that the other system is
loaded with both FishStat Plus and the relevant Base dataset.

Tip: Reference datasets can be system-defined or user defined. System defined reference datasets are
created by the System Administrator and are read-only. You can modify and save them under a new name,
but the program will not allow you to overwrite the original. A user-defined reference dataset is anything you
save using the Save command. It can be derived from either a system defined reference dataset, or directly
from a base dataset.

See also:
3.2.2
Open
3.2.4
Save
3.3
Data Menu
3.1
Pop-up Menus
 FishStat Plus Help Manual 112

7.2 Dataset Family

• Each Dataset has a family name.

• datasets with the same family name are based on the same data structure and the same reference
tables. For instance, names and codes of species in "Aquaculture production" and "Global fish
production" datasets are identical.
6.2.1 6.2.2
• This allows you to create Aggregate Sets and Custom Filters in one dataset, and later reuse
them in another dataset of the same family.
3.2.5
• To view dataset family properties, use the Manage Datasets command.
6.2
Tip: remember, if you switch to a dataset that is NOT in the same family, your Custom Groups ,
Filters, and Aggregate Sets will not be transportable due to incompatible codes, names and Object
identifiers.

See also:
7.1
Dataset Introduction
3.3
Data Menu
3.1
Pop-up Menus
 FishStat Plus Help Manual 113

7.3 Measurement Units

• Every Dataset has a default measurement unit (normally - Metric ton). However, some records may
have measurement units that differ from the default. Such records are highlighted in the browser with
an italic font and a magenta colour in the Key Column.

• When a dataset is aggregated, records with non-standard measurement units may have to be
discarded. If two records using the same non-standard unit are aggregated the resulting record
retains the non-standard unit, but if two records with different units are added, one of the two is
always discarded.

• If after filtering all dataset records have non-standard units, the default dataset unit changes.

• When sorting, non-standard unit values are considered as less than standard unit values. Thus, if you
8.5 8.2
sort a dataset with mixed units by any Time-series Column , or Calculated Column , all the
"standard" records will come out on top followed by the "non-standard".

• The dataset measurement unit and the unit of the current record are displayed in the Statusbar.
3.5.3
• You can change the way non-standard units are highlighted with the Format Highlight dialog box.

See also:
3.3
Data Menu
3.1
Pop-up Menus
8.5
Time-series Columns
3.5.3
Special values
 FishStat Plus Help Manual 114

8 Working with Columns

8.1 Introduction

Columns are the main units of Dataset organisation

8.3
• Key Columns define what kind of information is stored in each record (row), e.g. Country or
Species. The dataset may have from 1 to 5 Key Columns.
8.5
• Time-series Columns contain numeric information about catch size, production, or trade, usually
organised under one column for each year. The number of Time-series Columns is not limited.
8.2
• Calculated Columns are user-created and contain formulas that use the data in the key and Time-
series Columns as values with which to create new calculated values.
8.4
• Rank Columns are Columns that rank the values in other Columns.

See also:
3.3.4
Edit Columns
8.2
Calculated Column
3.1
Pop-up Menus
 FishStat Plus Help Manual 115

8.2 Calculated Column

These are Columns defined by the user.

7.0
• You can add new Columns to a Dataset and configure them with formulas containing arithmetical
4.4.1 4.4.5
operators such as +, -, /, *, Statistical Functions such as sum, average, exponential growth or
4.4
forecast, and many other expressions functions, and operators .

• A Calculated column may contain numerical data or text, depending on the formula.
4.1
• When you define a Calculated column, you use the Expression Builder and its built-in formulas.
This way, you can't make a mistake in spelling or syntax.

• Expressions in Calculated Columns are always evaluated after filtering and aggregation have been
8.5
finished. These expressions may include constants as well as key and Time-series Columns values
as parameters.

To create a new Calculated column

3.3.4
• Use Edit Columns or right-click any column and select <New Calculated column> from the Pop-
3.1
up Menu .

To edit an existing Calculated column

• Right-click it and select <Edit> from the Pop-up Menu, or access it via Edit Columns.

See also:
8.3
Key Column
8.4
Rank Column
8.5
Time-series Column
4.1
Expression Builder
3.3.4
Edit Columns
4.4
expressions functions, and operators
6.1.2
Column Options
6.1
Format
4.2
Edit Expression
3.1
Pop-up Menus
 FishStat Plus Help Manual 116

8.3 Key Column

A Key Column is a column in a Dataset containing text data about each record.

• A dataset may contain from 1 to 5 Key Columns.

• Each Key Column contains Objects of a particular type, for instance, countries, species, areas, etc.
Although stored as a numeric code of an Object, data in these Columns is usually displayed as text.
The combination of the various values in the Key Columns produces a reference to a unique record
in the dataset.
3.3.1
• When a dataset is Aggregated , the data in the Key Columns changes. For instance, if you Group
countries by continent, the names of continents will appear in the Key Column Country, where before
the column displayed the names of countries.
3.3.5
• When a Key Column becomes one of the Sort criteria, data in it are sorted alphabetically, from A-
to-Z (direct order), or Z-to-A (reverse order). Sorting is not case sensitive.
1.3
• In the Main Window , Key Columns are "attached" to the left side of the display, i.e. horizontal
scrolling does not affect them, and they are always visible.

To change a column's width

• Click the mouse button over its border and drag left or right.
3.1
• You can also click the right mouse button on any Key Column to activate a Pop-up Menu
containing a list of common column commands.
3.3.4
• To change the way a Key Column displays you must format it in the Edit Columns dialog box or
6.1 3.5
with the Format command found in the Tools Menu .

See also:
8.5
Time-series Column
8.4
Rank Column
8.2
Calculated Column
3.3.4
Edit Columns
6.1.2
Column Options
6.1
Format
3.1
Pop-up Menus
 FishStat Plus Help Manual 117

8.4 Rank Column

The Rank Column is a special kind of Calculated column.

8.5
• It is always based on some other column, which can be either a Time-series Column , or another
3.3.4
Calculated column. To create a Rank Column you must go to the Edit Columns dialog box.
7.0
• Rank is a sequence number that a record would have if the Dataset were sorted by that record's
column, i.e. the Rank command ranks the values in a column without regard to the values found in
any other column.

See also:
8.3
Key Column
8.2
Calculated Column
8.5
Time-series Column
3.3.4
Edit Columns
6.1.2
Column Options
6.1
Format
3.1
Pop-up Menus
 FishStat Plus Help Manual 118

8.5 Time-series Column

The Time-series Columns are Columns in a Dataset that contain data (such as catch or production)
for a specific time period, generally (but not always) a year.
8.5
• There is no functional limit to the number of Time-series Columns that FishStat Plus can support.
Generally, data is divided up so that there is one column for every year.

• Time-series Columns are located on the right.

For each record in a Time-series Column, there is a number or a special value

• Unknown value displayed as "…". Summed as 0. Sorted as being less than zero.

• Negligible value displayed as "<0.5". Sorted as being greater than 0 but less than any non-zero
value. Summed as 0.

• Estimate this number is flagged using a tilde, e.g. "~20".

• Repetitions this number is fronted by an "R"

• Non-standard Units shown in italics.

To hide (or reveal hidden) Columns, either some or all

3.3.4
• Go to the Edit Columns dialog box, or click the right mouse button on a column and select
3.1
<Hide/Unhide column> from the Pop-up Menu .

To change the display format (# of decimals, etc.) of a Time-series Columns

6.1.2 6.1
• Use the Column Options or the Format command. You can change the width of a Time-series
8.5
Columns by clicking on a column border and then dragging it to the right or left.

Tip: all Time-series Columns have the same width. When you resize one, the others are resized as
well.

See also:
8.3
Key Column
8.4
Rank Column
8.2
Calculated Column
3.3.4
Edit Columns
6.1.2
Column Options
6.1
Format
3.1
Pop-up Menus
 FishStat Plus Help Manual 119

8.6 Notes

• Every Object in every Key Column has a set of notes associated to it that give all available
background information such as FAO ID numbers, names in other languages, associated geographic
regions, etc.

• The only way to access Notes is to right-click the desired Object. The program will display the
information within a small, scrollable pop-up box. This action can be performed from within any
screen in which an Object name appears.

See also:
8.3
Key Column
8.4
Rank Column
8.2
Calculated Column
6.1
Format
3.1
Pop-up Menus
 FishStat Plus Help Manual 120

9 Tutorial
9.1 Introduction

• This tutorial is designed to give you a brief and comprehensive overview of the major features and
functions found in FishStat Plus for Windows .

• After going through this tutorial you will have learned how to load datasets, modify their contents and
layouts, add your own Calculated Columns, and shape the style and type of final output.

• All of the features covered in this tutorial are described in greater detail elsewhere in the manual. If
you need in-depth help on a particular topic, please go to the contents tab or query the search engine
with a keyword.
 FishStat Plus Help Manual 121

9.2 Navigating the Main Window

In the centre of the screen is the Main window. It contains two Groups of Columns
• Key Column (Left) these contain textual information that identifies and separates the numeric data,
e.g. Country, Area, and Species.

• Time-series Column (Right) these columns are numeric. They contain the values produced by
combinations of Key Columns. They are usually organised by year.

Problem! I don't see any numbers.

Don't worry. Since reporting varies between years and countries, some data fields will be empty.
These fields are marked by three dots (…). Other possibilities are a report of zero (0), a negligible
value (<0.5), and an FAO estimate or repeated data (preceded by a tilde "~")

Problem! I only see a few columns of data. My dataset is bigger than that.
Don't worry. Use the Horizontal and Vertical Main Window Scrollbars (either by clicking the end
arrows or by dragging the Scroll button ) to view additional years and/or additional records.
Don't worry. Use the Horizontal and Vertical Main Window Scrollbars (either by clicking the end
arrows or by dragging the Scroll button ) to view additional years and/or additional records.

If you haven't used the Scrollbars yet, give them a try.

• The Horizontal Scrollbar allows you to see the columns that don't fit into the screen area.

• The Vertical Scrollbar allows you to view the records (rows) that don't fit into the screen area.

• Since datasets may contain thousands of records, the Vertical Scrollbar has Accelerator buttons
at each end. The deeper you press the Accelerator, the faster you scroll through the records. Try it!
 FishStat Plus Help Manual 122

Below the Main Window is the Time-Series grid.

• It displays the Time-Series values for a selected record (row) allowing you to see all of the values for
a single record without having to scroll the Main Window.

• Try clicking on different records within the Main Window. Notice how the values displayed in the
Time-Series grid change whenever you select a new record.

Tip: this feature is NOT additive. Selecting multiple records does NOT cause the Time-Series grid to
add the values of the records. Instead, it always displays the last record selected.

At the very bottom of the screen is the Status bar.

• It displays information about the current dataset.

Things to try
• Leave the mouse pointer in different areas of the screen to view the context-sensitive Help.

• Have a second look at the options for each of the Menubar's pull-down submenus.

• Right-click different areas of the screen to view Pop-up Menus of frequently accessed commands.

• Put the mouse pointer over various borders (splits) and click-drag them to change the heights and
widths of Columns and windows.

Now that you've been introduced to the Main Window, let's start manipulating the data by filtering it.
 FishStat Plus Help Manual 123

9.3 Filtering the Dataset

Filtering is the first step in shaping the data to your needs. Each Key Column that we looked at in the
previous screen can be filtered according to your custom specifications.

To get to the Filter screen, let's use the right mouse button. This button accesses the FishStat Plus Pop-up
Menu, a handy set of commands custom tailored to each area of the program.

• Place your mouse pointer over any Key Column and right-click the mouse. A Pop-up Menu will
appear with the word "Filter" listed as the first command. Click it and the program will open the Filter
dialog box.

• Just so you know, you can also get to the Filter dialog box by clicking or found on the
Toolbar.

The Edit Filter dialog box will appear in the centre of the screen:
• At the top of this box are a set of tabs, one for each key (text) column. Click any tab to select a Key
Column and view its filtering options. On the left is the Include window, and on the right the Exclude
window. In the example below, Africa has been included, and all other Countries excluded.

• Since you haven't filtered anything yet, you'll see a yellow box in the Include window that says, "All
[Key Column title] Included".

In the middle of the dialog box is the Groups combo box

• It allows you to quickly include/exclude whole classes of data using some common categories, e.g.
for the Key Column <Country> you will find as categories <Continent>, <Economic Class>, and
<Economic Group>.

• Click to the right of the Groups combo box. Practice selecting different categories and clicking

and to move Groups of key records between the Include/Exclude windows.

 FishStat Plus Help Manual 124

• When you've selected the perfect Group, click the <Save> button to name your own Filter Group for
re-use at a later time (using the <Load> button). This is completely optional but can save you time if
you consistently filter data according to similar criteria.

• Click <OK> to actually perform the filtering operation and return to the Main Window.

Still too detailed to easily analyse? Try aggregating a few Key Columns.
 FishStat Plus Help Manual 125

9.4 Aggregating the Dataset

Aggregating is the next step in formatting the data to your needs. Each Key Column that we looked at in the
previous screen can be aggregated according to your custom specifications, thus removing any unneeded
detail from you data.

To get to the Aggregation screen, let's use the Toolbar at the left side of the screen:

• Click or .

The Aggregate Dataset dialog box will appear in the centre of the screen
• You should see the titles of each of your Key Columns. Since you haven't aggregated anything yet,
the Key Columns will all be set to <Detailed>. In the example below, "Country" has been left detailed
(disaggregated), while "Area" and "Environment" are set to custom-designed Groups, and "Species"
has been aggregated (i.e. information for various species will all be lumped together into one
category -- "Species")

• For any Key Column, click <Grouped>. To the right of every Key Column category you'll see a
combo box appear containing the same Groupings you saw earlier in the Filter dialog box.

• Aggregate at least one Key Column by clicking <Grouped> and selecting a Grouping from the
column's corresponding combo box.

• When you're finished, click <OK>. Now you have a dataset that is both filtered and aggregated. It
should be starting to look like a usable piece of work.

Tip: if you don't like how you filtered or aggregated, just go back and change your selections - the
underlying dataset from which you produce your dataset remains unchanged and ready to be
reclaimed at any time.

Tip: all the commands and options we just covered are completely accessible from the Data Display
by right-clicking. Give it a try. Place your mouse pointer over any Key Column and right-click the
 FishStat Plus Help Manual 126

mouse. The Pop-up Menu will appear. In the middle of it are the aggregation options complete with a
secondary Pop-up containing a list of the available Group choices.

From here, you can go on to analysing your data using the Expression Builder
 FishStat Plus Help Manual 127

9.5 Analysing the Dataset

With FishStat Plus' powerful Expression Builder, your data is easy to analyse:
• By using the Edit Columns dialog box you can create your own Calculated Columns.

From the Toolbar click or (remember, you can always right-click the mouse to get the Pop-
up Menu. Toward the bottom of its list you'll see "New Calculated Column").

The Edit Columns dialog box will appear in the centre of the screen:
• In the middle of the box is a directory of your existing columns. Click the green sign to expand any
directory.

• On the left are command buttons that allow you to modify existing columns.

• On the right are command buttons for creating new Calculated columns. You can build your own

expression, or choose from several prefab options like Sum or average .

Since building your own function is more difficult than using the prefab options, let's try to do it the
hard way:

• Click . The Select Function dialog box will appear:

 FishStat Plus Help Manual 128

• On the left are the Function Types, and on the right are the functions found within each type (if you've
ever used the expression builders within Microsoft Excel™ or Access™ you'll find the terms quite
familiar).

• Click a Function Type from the menu on the left, and then click a function from the menu on the right.
For simplicity's sake, try a basic Arithmetical Operator (+,-,*,/). Click <OK>.

The Edit Expression dialog box will now appear:

• In the lower left you'll see the name or symbol of the expression you chose inside the Expression
box. It should be surrounded by a pair of zeros. Now you have to tell FishStat Plus what values you
want to add to the expression (thus changing the zeros).

• Towards the top of the dialog box is a table showing the Parameter names and their Values. Click
inside one of the two Value input boxes and enter one of the years found in your dataset, i.e. one of
the Time-series Columns. Press <Enter>. You'll see the value you entered appear in the Expression
box. Repeat the process for the second expression, entering a different Time-series Column year.

• You've now successfully built a simple expression that will take the values from the years you
selected and apply the chosen function to create a new column that will display in the Main window.
This kind of column is referred to as a Calculated column. Note that it is possible to build complex
and powerful expressions using multiple operators and expressions. For now, just click <OK>.
 FishStat Plus Help Manual 129

The Column Options dialog box will appear

• This box allows you to format the display of your new Calculated column. Click <OK> to accept the
default.

• FishStat Plus will return you to the Edit Columns dialog box. From here you can build a new
Calculated column, or edit an existing column.

Before returning to the Main window, let's add a special kind of Calculated column called a Rank
Column:
• This column simply ranks the values of any column you select.

• Click <Rank>. The Edit Rank Column dialog box will appear.

• Click the down <Arrow> on the Base Column combo box found in the middle of the dialog box. Scroll
down and find the Calculated column you created in the last operation. Click to select and then click
<OK>.

• The Column Options dialog box appears, allowing you to name and size your new Rank Column.
Click <OK> and you'll find yourself back at the Edit Columns dialog box. From here you could keep
building and editing columns, but let's get back to our data. Click <OK> and FishStat Plus will return
you to the Main window. Pull the Horizontal Scrollbar to the right to view the columns you created.

Tip: ranking can also be done directly from the Data Display. Just right-click the column you'd like to
rank by and select <Rank> from the Pop-up Menu.

By now, you should have a nicely streamlined Dataset. It's just that it needs to be sorted.
 FishStat Plus Help Manual 130

9.6 Sorting the Dataset

To sort your data you could click on another one of the Toolbar command buttons we just used, but let's not
forget to use the powerful, timesaving Pop-up Menu, always tailored to a particular aspect of the program.

• Using the Horizontal Scrollbar, scroll to the right until you find the Calculated (not Rank) column you
created during the last step.

• Place the mouse pointer anywhere within the column and click with the right mouse button. A Pop-up
Menu appears with a tailored set of commands. Click the top line <Sort by [name of column you
created]>. Your dataset is now sorted.

Tip: if you want to create a multi-level sort you must access the Sort menu from the Toolbar. Click

or (or press <F7> on your Keyboard, or from the Menubar click <Data> and select
<Sort>).

Give it a try if you want. Otherwise, let's move on to one of the simplest and most convenient features
of FishStat Plus, the Top/Other command.
 FishStat Plus Help Manual 131

9.7 Displaying Only the Significant Data

By now you're probably looking at your data and thinking how nice it would be to take some of those small,
insignificant numbers and lump them together, thus highlighting the important figures. No problem.

From the Toolbar click or (or press <F8> on your Keyboard, or from the Menubar click
<Data> and click <Top/Other>).

Tip: you can also right-click within any numeric column and select <Top/Other> from the Pop-up Menu.

The Top/Other Selection dialog box will appear in the centre of the screen

• At the top you'll see the "…by field" combo box.

• Click and select the Time-series or Calculated column to use in selecting the Top records. Then
just decide which selection criteria best suits your needs, configure if necessary and click <OK> to
exit and return to the Main Window.

• You'll see a much cleaner dataset, with the important records displayed as they were, and the others
lumped together in a Group record called "Other".

Grand Total
• Congratulations! You've now opened, filtered, aggregated, sorted, and refined your dataset Let's take

a look at the column totals. Hold down the <CTRL> key while pressing <F8> or click or

from the Toolbar. The Grand Total will now appear as the last record (row) of your dataset.
You'll probably need to use the Vertical Scrollbar in order to see it.

Tip: this feature is a "toggle" switch, i.e. if you run the command another time, the Grand Total row
will disappear. In fact, why don't you right-click the mouse again, select "Grand Total", and prove it to
yourself.
 FishStat Plus Help Manual 132

It's time to think about preparing a report.

 FishStat Plus Help Manual 133

9.8 Defining Report Tables

Report Type

• Welcome to the Report Wizard, a feature that allows you to easily create rich and easy-to-read tables
and charts.

• From the Toolbar click or , or from the Menubar click <Output>.

You're presented with a range of choices. Let's choose the most detailed of them all. Click <Tables
and Charts>.

• The important thing to pay attention to is the row of command buttons at the bottom. Each one
represents a single step in the process of report creation. At any time, if things aren't looking the way
you'd like them to, just back up and make a few changes.

• Towards the bottom left of the screen you'll see a box listing your Columns. The column "Year"
represents the Time-series Columns as a whole.

• Try clicking each entry. A red check mark will appear next to each column. Look to the right of the
window. Listed are the estimated number of tables (charts) your current selection is expected to
create. If your selection seems to create too many, don't worry, other Report Wizard screens allow
you to limit the final number of tables (charts) by excluding data.

Tip: if exporting to a file for use in another program, you may want to leave all your information in one
table, and not divide it up.
 FishStat Plus Help Manual 134

To advance to the next screen and choose which keys you want as Columns, click either or

.
 FishStat Plus Help Manual 135

9.9 Define Report Columns

Report Pages

• The second page of the Report Wizard is where you choose which Key Columns will remain columns
(point sets), and which will become rows (points). Note that the column you previously chose as the
Table key appears towards the top of the screen, but is not available within the column box.

• In the "Start a new column (point set) for each" window, try clicking an entry. A red check mark will
appear in the box next to it. Look to the right of the window. Listed are the estimated number of
Columns (point sets) your current selection is expected to create. If your selection seems to create
too many, don't worry, other Report Wizard screens allow you to limit the number of Columns (point
sets) by exclude data.

Tip: you can also force a limit to the number of Columns (point sets) by checking "Limit number of
Columns" and then typing a number in its input box.

• Notice that the column you select is moved to the top of the stack. If you select more than one
column, a set of blue arrows appear within the column window. By clicking these you can decide
which is at the top of the stack. This affects which key FishStat uses as your primary column key.

To advance to the next screen and choose your Report Rows and Chart layout, click either or

.
 FishStat Plus Help Manual 136

9.10 Defining Rows and Charts

Rows and Chart Direction

• The third Report Wizard screen serves two functions. It allows you to arbitrarily limit the number of
rows (points), and to alter the layout of your charts without affecting your tables.

• You'll find that for visual reasons you often will need to set up your charts using a different set of
parameters than those you use in creating tables. This Report Wizard screen gives you the flexibility
you need in order to be able to produce tables and charts at the same time.

• The top of the dialog box lists the table (chart) and column (point set) choices you've made in the
previous screens and then lists the leftover Key Columns that will make up the rows (points) together
with an estimate of how many rows (points) will be created.

• The "Limit number of rows (points) to" check box allows you to limit the displayed number of rows
(points), a handy feature for quickly shrinking bulky reports.

Tip: you can also limit the number of rows in the later Report Wizard screens by excluding data.
3.4.5
• The lower half of the dialog box allows you to modify the layout of your Charts without affecting your
tables. For now, just leave it at the default. Later you can go back and try each button to see the
difference they make.

To advance to the next screen and choose what data to output, click either or .
 FishStat Plus Help Manual 137

9.11 Choosing which Columns to Output

Select Dataset Columns

• Here you decide which columns to include from the dataset.

• The default is for all columns to be included. Try sending them all to the Exclude window by clicking
, and then selecting the columns you want to include by holding down the <CTRL> key and
clicking them one-by-one.

• You can also select a range by clicking on the first or last column you want to include and holding
down the mouse button while dragging up or down. The process is essentially identical to the one
you used in the Filter dialog box.

• Once you've completed your selection, send them over to the Include box by clicking .

If satisfied, to advance to the Source Records screen click either or .

 FishStat Plus Help Manual 138

9.12 Choosing which Records to Output

Select Source Records

• Here you decide which records (rows) to include from the dataset.

• The default is for all records to be included. Try sending them all to the Exclude window by clicking

, and then selecting the records you want to include by holding down the <CTRL> key and
clicking the records one-by-one.

• You can also select a range by simply clicking on the first or last record you want to include and
holding down the mouse button while dragging up or down. The process is essentially identical to the
one you used in the Select dataset Columns dialog box. Once you've completed your selection, send

them over to the Include box by clicking .

If satisfied, to advance to the Table Options screen click either or .

 FishStat Plus Help Manual 139

9.13 Selecting Table Options

Table Options
• Start by naming your table. Type it in the white input box at the top of the dialog box.

• Down at the bottom your current font and font size are listed. If you'd like to change them just click on
them and a standard Windows™ Font Selection dialog box opens. Make your selection, click <OK>
and you'll be returned to the Table Options dialog box.

• The other Table Options choices are self-explanatory and will normally be left at their default setting
(feel free to experiment).

To advance to the Table preview screen click either or .

 FishStat Plus Help Manual 140

9.14 Table Preview

Table Preview
• One of FishStat Plus' great capabilities. The ability to see beforehand what you'll be printing or
exporting.

• Note the combo box in the bottom middle of the dialog box. It contains the list of pages (Z-axis
values. The "subject" of each table). Click to view the list. Click any item on the list to switch to its
table.

If you don't like what you see

Often tables can get too crowded. If this is the case with your table:

• Go back to the Report Columns dialog box and set a value for Max. Columns or go back to
the Report Rows dialog box and set a value for Max. Rows.

• Go back to the Select Dataset Columns dialog box by clicking and exclude some Columns.

• Go back to the Select Source Records dialog box by clicking and exclude some rows.

You may also want to consider

• Going back to Report Tables and choosing a different Table key, or even adding a second Table key.
The more you stack the Report Table with keys, the simpler each table will be.
 FishStat Plus Help Manual 141

• Remember, you can back up to ANY of the Report Wizard dialog boxes, or even further back, to
change any of the Filtering or Aggregating you've done. Remember, the underlying dataset remains
the same. It's possible at any time to back up and rethink the choices you've made.

If you like what you see

To advance to the Chart Options screen click either or .

 FishStat Plus Help Manual 142

9.15 Selecting Chart Options

Chart Options
3.4.5
• This dialog box gives you an enormous number of choices for producing Charts .

• The first decision you'll want to make is which type of Chart to produce.

• In the upper left corner of the Chart Options dialog box you can choose between seven different
types.

• To the right, choose your colour scheme, from black-and-white patterns to greyscale to colour.

• Below these choices are a host of configurable formatting parameters. Be sure to fill in the first
parameter, Title, otherwise your chart will remain nameless. As to the rest of the parameters, the best
way to understand how they affect your chart is to play around with them.

For now, let's advance to the Chart preview screen by clicking either or .
 FishStat Plus Help Manual 143

9.16 Chart Preview

Chart Preview
• This is another of FishStat Plus' great capabilities. The ability to see beforehand what your chart will
look like before you print or export.

• Note the combo box(es) at the bottom of the dialog box. It(they) contain the list of pages (Z-axis
values. The "subject" of each chart). Depending on the choices you've made, you may find that you
have an enormous number of charts linked to your various key values.

• Click to view the list. Click any item on the list to switch to its chart.

If you don't like what you see

• Just as with the table you produced, if the chart is too crowded, or if you don't like what you see, you
can back up to any of the Report Wizard screens, or even further back, to change any of the filtering
or aggregating you've done. Just follow the instructions found in the Table Preview section of the
tutorial under the title "If you don't like what you see".

• As with the Tables you created, you may also want to consider going back to the first two Report
Wizard screens and rethinking your Table key, and your Column keys. Swapping their positions can
have a profound effect on how your chart is plotted.

If you like what you see

• Once you have a chart that makes sense, explore the visual possibilities. If unsatisfied, to go back to

the previous screen click either or . This backs you up to the previous Chart Options
dialog box. Try changing some parameters or the Chart Type, and then return to the Chart Preview.
 FishStat Plus Help Manual 144

By now you must want to see if the Report Wizard actually works. Let's create some hardcopy, or at

least export a file. Click or to go to the Output screen.

 FishStat Plus Help Manual 145

9.17 Outputting the Data

Destination
• The final dialog box of the Report Wizard. It's as simple as it looks. Choose your output from the first
combo box, whether to the printer or to any of the supported file types (currently *.html, *.rtf, *.csv,
and *.sylk).

Tip: for charts, *.rtf is the only supported file type.

If you choose to output to a file

• Name the file or browse your directory in the lower combo box.

Tip:==if you choose to output to a file, once FishStat is finished with the output, open an application that
can handle the file type and view the new file. It should look almost identical to what you saw in the
Report Wizard preview screens.

If you choose to output to a Printer

• The lower combo box will display the default printer. You may configure it or select a different default
printer by clicking <Setup> found at the right side of the dialog box.

If your tables and charts contain a lot of pages

• You may want to go back to the earlier Report Wizard and limit your records (rows) or your Columns
until you end up with an acceptable number of pages, otherwise you may find yourself sending a
hundred pages to your printer.

Once you've configured your output options

• Click <Go>. FishStat Plus will now prepare your report. Depending on the size of your dataset, this
operation may take several minutes. When the Progress window disappears, FishStat Plus opens a
second application that controls the actual output. This way, you can return to your data and continue
working while your report is produced in the background.
 FishStat Plus Help Manual 146

Before leaving the tutorial, please take a moment to read the conclusion.
 FishStat Plus Help Manual 147

9.18 Tutorial Conclusion

• By now you should have a solid understanding of the FishStat Plus environment and its central
functions. We've gone from opening the program, all the way through its filtration, aggregation,
formatting, and output.

• Remember that FishStat Plus is a powerful and flexible program. At any time, you're free to jump to
any part of it and adjust your options. The underlying dataset remains the same. All you're doing is
adjusting how you select, synthesise, and display the data within that dataset.

• Be sure and save your Groups when custom designing filtration and aggregation Groups. These can
come in very handy at a later date.

• By all means do not forget to use the Pop-up Menus. They can save you a lot of time searching for a
needed command, and even help you to optimise your data in ways that might not otherwise have
occurred to you.

• Spend some time playing with the program. Play is the best way to learn!

• If you have questions not covered during the course of this tutorial, please refer to the Help Contents.

If you'd like to run through the Tutorial a second time click here.
 FishStat Plus Help Manual 148

10 Glossary
10.1 Commands and Shortcuts

Cancel:: This command cancels the production of a report and returns you to the FishStat Plus Main Window.

Deselect All: deselects every element of a set or column. Within the Include/Exclude windows or within any
column , right-clicking the mouse will bring up a Pop-up Menu containing the command <Deselect all>. Click
it to deselect the entire column or set of records.

Five Ways to Access the Menu

1) Using the mouse
From the Menubar, click on a submenu (e.g. File, Output, Data, or Tools) in which the command
appears. The submenu will open. Click on the command name.
2) Using the Keyboard
Press <Alt> and then the underlined letter of the desired submenu name, e.g. <Alt+D> for Data
3.3
Menu . The submenu will open. Press the underlined letter of the desired command, e.g. "F" for
Filter). Press <Enter>.
3) Using the Keyboard
Press <ALT> or <F10>. The Menubar becomes active. Press the left or right <Arrow> until the
desired submenu name is highlighted. Press <Enter>. Press the down <Arrow> until the desired
command name is highlighted. Press <Enter>.
4) To access a command using a hot-key
Learn which function keys are assigned to the commands you use most frequently. They are listed:
a) In the submenus, next to the commands they access.
b) On most of the large-size Toolbar buttons.
10.1
c) In the Keyboard Reference .
Press a hot-key to access its associated command (e.g. <F4> to Filter the dataset).
5) Using the Pop-up Menus
In many of FishStat's screens and dialog boxes a right-click of the mouse calls a custom tailored
menu

Hot-key: a keyboard key assigned to a command, such that by pressing it the command is executed.

How to Find Text

When should you use it?
• To locate a record. This search method may be used in the Main Window and in many of the
program lists and grids.
Where do you find it?
• The Text Finder appears automatically when you begin typing text within an active window that
supports the Text Finder feature.
How does it work?
1) Type the first character of the text you're searching for.
The program locates the first row containing the character you typed, and highlights it. Alongside appears the

Text Finder .
2) Continue typing text.
 FishStat Plus Help Manual 149

Click the or arrows to find the previous or the next appearance of the typed text
3) To select all rows containing the text you typed

Click the Find All button.

Tip:
• The search is not case-sensitive, e.g. the Text Finder considers tuna and TUNA identical.
• The text search is only for the current column.
• The program looks for the text within any portion of a word. If you want to restrict The Text Finder to

only searching from the beginning of each word, toggle the Position switch to . In some lists
(in particular Load and Save dialogs) this switch does not appear, and the search is always
performed from the beginning of the word.

Invert Selection: invert a selection, so that everything selected is deselected, and everything not selected is
selected. In any Include/Exclude window, right-clicking the mouse brings up a Pop-up Menu containing the
command <Invert Selection>. Clicking this command will invert the current selection.

Keyboard Reference
F1 Help
F2 Edit current cell; Display drop-down menu
F4 Filter
F5 Aggregate
F6 Edit Columns
F7 Sort
F8 Top/Other selection
Ctrl+F8 Grand total on/off
Ctrl+R Report Wizard
Ctrl+PgDn Previous tab of Format or Group Manager; previous screen of Report Wizard
Ctrl+PgUp Next tab of Format or Group Manager; next screen of Report Wizard
Ctrl+O Open dataset
Ctrl+S Save dataset
Ctrl+T Display Format dialog
Ctrl+G Edit custom Groups
Ctrl+P Display Language and Font dialog
Ctrl+N Printer setup
Alt+F4 Exit program
Ctrl+ Move selected rows between Include and Exclude lists
Ctrl+Shift+ Move all rows between Include and Exclude lists
Shift+ Select rows
Shift+PgUp Select rows
Shift+PgDn Select rows

Select All: selects every element of a set or column. Within the Include/Exclude windows or within any
column , right-clicking the mouse will bring up a Pop-up Menu containing the command <select all>. Click it
to select the entire column or set of records.
• Select All may also be accessed by pressing <Ctrl+A>.
 FishStat Plus Help Manual 150

10.2 Concepts

Base (and system-defined reference) Datasets: created by the System Administrator and read-only. You can
modify and save them under a new name, but the program will not allow you to overwrite the original.

Calculated Columns Grid: displays all the Calculated Columns data for the current record. Similar to the
Time-series grid.

Chart Point: a point along the X-axis of a chart and is taken from whatever key or keys you've placed in the
Column (X-axis) area of the Report Type dialog box, e.g. if you placed Area and Year in the Column (X-axis)
area, then a hypothetical Chart point would be "Australia,1997". Together with the Chart they belong to, a
Chart Set and a Chart Point define a unique record or set of records in the dataset.

Chart Set: a Group of Objects within a key or keys who have in common a particular Chart Point. The Chart
Set is taken from whatever key or keys you've placed in the Row (Y-axis) area of the Report Type dialog box,
e.g. if you placed Species in the Row (Y-axis) area, then a hypothetical Chart Set for the Chart Point
"Australia,1997" would be "all the values for the Species caught by Australia in 1997". Together with the
chart they belong to, a Chart Set and a Chart Point define a unique record or set of records in the dataset.

Clipboard: an area where Windows stores copied data. Data remains on the Clipboard until the end of the
Windows session, or until overwritten by a subsequent Copy command. Clipboard data can be accessed by
any Windows application using the Paste command, normally found on the Edit menu.

Keys: within the Report Wizard, the keys are the columns you arrange on the X-, Y-, and Z-axes.

Notes: this window displays all of the available background information for a dataset Object. This information
may include names, codes, Groups, notes, etc. To open this window, Right-click any Object name and select
<Notes> from the Pop-up menu.

Object: any entity that appears in a Key Column. Each Object belongs to a particular type, e.g. countries,
areas, species, gears, commodities. Every Object has one or more names, possibly in several languages,
and may also have several codes. Objects can belong to Groups, e.g. continents, economic classes,
geographic Groups, etc. These Groups can be standard or custom-designed. Groups are also considered to
be Objects.

Reference Datasets: datasets that contain references to base datasets rather than actual data. 'System-
defined' reference datasets are created by the System Administrator and are read-only. You can save them
under a new name, but you cannot overwrite the original. 'User-defined' reference datasets are datasets you
save using the Save command.

Time-series Grid: designed to eliminate the need for constant scrolling, all of the Time-series data for the
current row are displayed here. The column width and height are adjustable.

ToolTip Window: resting the mouse pointer almost anywhere on the screen will bring up a small context-
sensitive informational window.
 FishStat Plus Help Manual 151

Years List: enter the years you wish the program to use when calculating the expression. Allowable
separators are commas (,) and double-dots (..). Use the comma to separate years, and use double-dots to
indicate a range between years, e.g. "1952,1958,1970..1973" would signify "1952 and 1958 and 1970 and
1971 and 1972 and 1973".
 FishStat Plus Help Manual 152

10.3 Screen Elements

Accelerator Button: a specialised part of the Vertical Scrollbar, it allows you to scroll through the records at

varying speeds. The further out along the button you click, the "deeper" it is pressed and the faster you
scroll.

Arrows: these arrows when clicked cause the program to move forward or backwards one dialog box within
the Report Wizard.

Data Display: a grid that displays the records of the current dataset. Some rows may be highlighted, e.g. a
current row is grey and highlighted with a border. Use the <Arrow> keys to change the current row. You can
also click on a row to make it current. There are several ways to select more than one row: click-drag, Shift-
click, and Ctrl-click.

Menubar: a standard feature of Windows applications, it is located directly below the blue Title bar
displaying FishStat Plus [Dataset name].

Clicking on any of the Menu titles opens a drop-down submenu of associated commands.
10.1
If you're an inexperienced Windows user, read Four Ways to Use the Menu

The Menubar is disabled when any dialog box, such as Filter or Edit Columns, or Report Wizard is displayed.
When a dialog or a wizard is displayed, all the commands you may need are within that dialog box, and the
Menubar is not needed. This is standard behaviour for most Windows applications. At certain moments (as
when no Dataset is open), some Menubar commands are disabled.

Pop-up Menus: available when you click the right mouse button anywhere within these program windows:
Main, Filter, Group Manager, Report source records, and Include/Exclude.

The commands displayed depend upon the context. The most common are: Filter, Sort, Total, Rank,
Aggregate, Format, Select All, Deselect All, Invert Selection, Copy, Save, Groups.

Scrollbar:when there is too much information to fit in the display window, the scrollbar is used to scroll
offscreen information onscreen so that it comes into view. The bar may be horizontal or vertical. Usually, the
end arrows scroll at a predetermined rate (often the typematic rate) and the scroll button acts both as
an anchor point that shows the relative position of the information currently in the display window, and as a
button that can be click-dragged to any point on the Scrollbar for rapid scrolling.

Splits: click-drag these to change the size of the various windows. There are four of them: one vertical -- for
resizing and hiding the Toolbar, and three horizontal -- for sizing the Status bar, Time-series grid, and

Calculated Columns grid. The mouse cursor changes to or as you move the mouse over
the Splits.
 FishStat Plus Help Manual 153

Statusbar:displays the total number of rows in the current dataset (post-filter/aggregation/etc.), current row
#, number of selected rows, default measurement unit, and measurement unit for the current record.

Toolbar
The Toolbar is located at the left edge of the FishStat Plus Main Window.
Click a Toolbar button to go to its help page:

Toolbar buttons are available in two sizes. You can also change the width of the Toolbar, or hide it
completely. When the Toolbar is hidden, its border remains visible giving you the option of revealing it
whenever necessary.
If the program window is not high enough, and some buttons do not fit on the Toolbar, scroll buttons

and are displayed, letting you browse through all the available Toolbar commands.
To resize, hide or reveal the Toolbar

Place the mouse over the vertical border of the Toolbar. Mouse cursor changes to . Click-drag the
mouse to reduce or increase the Toolbar width. When satisfied, release the mouse button.
 FishStat Plus Help Manual 154

11 Index

keyword Chapter Name Ch.# keyword Chapter Name Ch.#

3-d Chart Options 5.9 Calculated Column Calculated Column 4.3
Selecting chart options 9.15 Calculated Column 8.2
Accelerator button Accelerator button 10.3 Format Numbers 3.5.2
add Arithmetical Operators 4.4.1 Calculated Columns Grid Calculated Columns Grid 10.2
Aggregate Aggregate 3.3.3 Cancel Cancel 10.1
Aggregating the Dataset 9.4 change Aggregate Set 6.2.1
Data Menu 3.3 Filter Group 6.2.2
Group Manager 6.2.4 Format 6.1
Aggregating Aggregating the Dataset 9.4 change column Edit Columns 3.3.4
Aggregating the Dataset Aggregating the Dataset 9.4 chart Chart Direction 5.4
Aggregation Aggregating the Dataset 9.4 Chart preview 0.1
all select all 10.1 Chart Set 10.2
Analyse Analysing the Dataset 9.5 Report Wizard 5.5
Analysing Analysing the Dataset 9.5 Chart Preview (Tutorial) 9.16
Analysing the Dataset Analysing the Dataset 9.5 Destination 5.1
Analyse Analysing the Dataset 9.5 Report Type 5.2
Analyzing Analysing the Dataset 9.5 Selecting chart options 9.15
Analyzing the Dataset Analysing the Dataset 9.5 Tables and Charts 3.4.6
and Logical Operators 4.4.3 Chart Direction Chart Direction 5.4
application Clipboard 10.2 Chart Point 10.2
Arithmetical Operators Arithmetical Operators 4.4.1 Chart Options Chart preview 0.1
arrange Sort 3.3.5 Chart Options 5.9
Sorting the Dataset 9.6 Chart Preview (Tutorial) 9.16
average Statistical Functions 4.4.5 Selecting chart options 9.15
axes Chart Direction 5.4 Chart Point Chart Point 10.2
Chart Point 10.2 Chart preview Chart preview 0.1
Chart Set 10.2 Chart Set Chart Set 10.2
keys 10.2 chart style Chart Direction 5.4
axis Chart Direction 5.4 Charts Charts 3.4.5
Chart Point 10.2 Defining Report Tables 9.8
Chart Set 10.2 3.4 3.4
Output Menu
keys 10.2 Choosing a report style Defining Report Tables 9.8
Back up Undo 3.3.8 Report Type 5.2
bar Chart Point 10.2 choosing data Choosing column output 9.11
bar Chart Set 10.2 Choosing record output 9.12
bar Menu bar 10.3 Select Data Columns 5.5
bar Chart Options 5.9 Select Source Records 5.6
bar Selecting chart options 9.15 Choosing the data for Choosing column output 9.11
Base Dataset Base Dataset 10.2 output
Choosing record output 9.12
Reference Dataset 10.2
Select Data Columns 5.5
browser Main Window 1.3
Select Source Records 5.6
calculated Columns 8.1
Choosing column output Choosing column output 9.11
Rank Column 8.4
Choosing record output Choosing record output 9.12
 FishStat Plus Help Manual 155

keyword Chapter Name Ch.# keyword Chapter Name Ch.#

Clipboard Clipboard 10.2 Time-series Column 8.5
Copy 3.4.2 Data Display Data Display 10.3
Chart Preview (Tutorial) 9.16 Main Window 1.3
Table preview 5.8 Time-series Grid 10.2
Close Close 3.2.3 Data Menu Data Menu 3.3
Exit 3.2.7 dataset Base Dataset 10.2
File Menu 3.2 Close 3.2.3
column Key Column 8.3 Dataset 7.1
Rank Column 8.4 Dataset Family 7.2
Report Column 5.3 Open 3.2.2
Column Options Column Options 6.1.2 Reference Dataset 10.2
Columns Choosing column output 9.11 Save 3.2.4
Columns 8.1 Measurement Units 7.3
Data Menu 3.3 Dataset Notes 3.5.6
Edit Columns 3.3.4 Dataset Family Dataset Family 7.2
Select Data Columns 5.5 deselect deselect all 10.1
Columns Commands Columns Commands 8.1 Destination Destination 5.1
commands Four ways to use menu 10.1 output 51.1
Toolbar 10.3 deviation Statistical Functions 4.4.5
comparison Numeric & String 4.4.4 Display Format 6.1
Comparison Language and Font 3.5.5
concatenate String Functions 4.4.6
Splits 10.3
conclusion Tutorial conclusion 9.18
divide Arithmetical Operators 4.4.1
configure Printer setup 3.4.7
edit Edit Expression 4.2
Conversion Functions Conversion Functions 4.4.2
edit column Edit Columns 3.3.4
convert Conversion Functions 4.4.2
Edit Columns Edit Columns 3.3.4
copy Clipboard 10.2
Edit Expression Edit Expression 4.2
Copy 3.4.2
Edit Group Dialog Box Edit Group Dialog Box 6.2.3
Chart Preview (Tutorial) 9.16
Edit Groups Commands Edit Groups Commands 6.2.3
Table preview 5.8
equal Numeric & String 4.4.4
CSV Destination 5.1 Comparison
custom Aggregate Set 6.2.1 estimate Format Hilite 3.5.3
Filter Group 6.2.2 Special Values 10.2
Group Manager 6.2.4 Exclude Edit Group Dialog Box 6.2.3
custom group 3.5.4 Exit Exit 3.2.7
Aggregate Set Aggregate Set 6.2.1 File Menu 3.2
custom aggregation Edit Group Dialog Box 6.2.3 exploded Chart Options 5.9
Filter Group Filter Group 6.2.2 exponential Column Options 6.1.2
Custom Group Aggregate Set 6.2.1 export Charts 3.4.5
Filter Group 6.2.2 Copy 3.4.2
Edit Group Dialog Box 6.2.3 Report Wizard 5.5
custom group 3.5.4 Chart Preview (Tutorial) 9.16
Custom Group Commands Custom Group Commands 6.2.4 Table preview 5.8
custom groups Tools Menu 3.5 Save 3.2.4
customise Aggregate Set 6.2.1 Simple Report 3.4.3
Filter Group 6.2.2 Tables 3.4.4
custom group 3.5.4 Tables and Charts 3.4.6
customize Aggregate Set 6.2.1 expression Calculated Column 4.3
Filter Group 6.2.2 Edit Expression 4.2
custom group 3.5.4 Expression Builder 4.1
data Dataset 7.1 Expressions 4.4
 FishStat Plus Help Manual 156

keyword Chapter Name Ch.# keyword Chapter Name Ch.#

expression Years List 10.2 graph Charts 3.4.5
Expression Builder Expression Builder 4.1 Tables and Charts 3.4.6
Expressions Expressions 4.4 grayscale Chart Options 5.9
File File Menu 3.2 greater than Numeric & String 4.4.4
Outputting the data 9.17 Comparison
greyscale Chart Options 5.9
Report Wizard 5.5
group Aggregate 3.3.3
Destination 5.1
Group Manager 6.2.4
Report Type 5.2
Group Manager Group Manager 6.2.4
File Menu File Menu 3.2
hardcopy Report Type 5.2
filter Data Menu 3.3
header Selecting table options 9.13
Filter 3.3.2
headers Format Key Column 6.1.1
Filtering the Dataset 9.3
help ToolTip Window 10.2
Filter Commands Filter Commands 3.3.2
hint ToolTip Window 10.2
filter data Filter 3.3.2
Hot key Hot key 10.1
Filtering the Dataset Filtering the Dataset 9.3
hotkeys Keyboard Reference 10.1
fluctuation Statistical Functions 4.4.5
How to find text How to find text 10.1
font Language and Font 3.5.5
html Destination 5.1
Tools Menu 3.5
IIF Logical Operators 4.4.3
forecast Statistical Functions 4.4.5
include Edit Group Dialog Box 6.2.3
format Column Options 6.1.2
include/exclude Edit Group Dialog Box 6.2.3
Format Key Column 6.1.1
individualise Aggregate Set 6.2.1
Conversion Functions 4.4.2
Filter Group 6.2.2
Format 6.1
Custom Group 3.5.4
Format Hilite 3.5.3
individualize Aggregate Set 6.2.1
Format Numbers 3.5.2
Filter Group 6.2.2
Format Key Column 6.1.1
Custom Group 3.5.4
Chart Options 5.9
insignificant Format Hilite 3.5.3
Table Options 5.7
install Open 3.2.2
Selecting chart options 9.15
Opening a Dataset 2.3
Selecting table options 9.13
install Dataset File Menu 2.3.2
Tools Menu 3.5
Install Dataset 3.2.6
Format Hilite Format Hilite 3.5.3
Manage Datasets 3.2.5
format Key Column Format Key Column 6.1.1
Installation About FishStat Plus 1.1
Format Numbers Format Numbers 3.5.2
Installation 2.1
Format Key Column Format Key Column 6.1.1
instring String Functions 4.4.6
formula Calculated Column 4.3
invert selection invert selection 10.1
Edit Expression 4.2
keep Save 3.2.4
Expression Builder 4.1
key Columns 8.1
Expressions 4.4
Key Column Dataset 8.3
Years List 10.2
Key Column 8.3
formulas Expressions 4.4
Keyboard Reference Keyboard Reference 10.1
Four ways to use menu Four ways to use menu 10.1
keys Chart Direction 5.4
frame Splits 10.3
Chart Set 10.2
function Expression Builder 4.1
keys 10.2
Expressions 4.4
language Language and Font 3.5.5
Keyboard Reference 10.1
Tools Menu 3.5
Years List 10.2
Language and Font Language and Font 3.5.5
function key Hot key 10.1
layout Table Options 5.7
grand total Data Menu 3.3
Selecting chart options 9.15
Grand Total 3.3.7
Selecting table options 9.13
 FishStat Plus Help Manual 157

keyword Chapter Name Ch.# keyword Chapter Name Ch.#

less than Numeric & String 4.4.4 Expression Builder 4.1
Comparison operators Expressions 4.4
log Chart Options 5.9
opposite invert selection 10.1
Selecting chart options 9.15
or Logical Operators 4.4.3
Logical Operators Logical Operators 4.4.3
order Rank Column 8.4
main window Data Display 10.3
Sort 3.3.5
Main Window 1.3
Sorting the Dataset 9.6
Menu bar 10.3
other Top/Other 3.3.6
Time-series Grid 10.2
output Choosing column output 9.11
Toolbar 10.3
Choosing record output 9.12
What can I do? 9.2
Output Menu 3.4
What should I see? 9.1
Outputting the data 9.17
manage column Edit Columns 3.3.4
Report Wizard 5.5
manage Dataset File Menu 3.2
Destination 5.1
Manage Datasets Manage Datasets 3.2.5
Select Data Columns 5.5
Map Map 3.5.7
Select Source Records 5.6
Measurement Units Measurement Units 7.3
Simple Report 3.4.3
menu Four ways to use menu 10.1
Tables 3.4.4
Menu bar 10.3
Tables and Charts 3.4.6
Toolbar 10.3
output 51.1
Menu bar Menu bar 10.3
Output Menu Output Menu 3.4
metric ton Measurement Units 7.3
Outputting the data Outputting the data 9.17
minus Arithmetical Operators 4.4.1
paste Clipboard 10.2
mouse Pop-up Menus 10.3
Copy 3.4.2
multiply Arithmetical Operators 4.4.1
Chart Preview (Tutorial) 9.16
navigator Main Window 1.3
Table preview 5.8
negative invert selection 10.1
personalise Aggregate Set 6.2.1
negligible Format Hilite 3.5.3
Filter Group 6.2.2
Special Values 10.2
Custom Group 3.5.4
nor Logical Operators 4.4.3
personalize Aggregate Set 6.2.1
not Logical Operators 4.4.3
Filter Group 6.2.2
not equal Numeric & String 4.4.4
Comparison Custom Group 3.5.4
notation Column Options 6.1.2 pie Chart Options 5.9
Notes Notes 8.6 Selecting chart options 9.15
Dataset notes 3.5.6 plus Arithmetical Operators 4.4.1
numbers Format Numbers 3.5.2 Pop-up Menus Pop-up Menus 3.1
numeric Numeric Comparison 4.4.4 pop-up aggregate menu 3.1.1
Numeric Comparison Numeric Comparison 4.4.4 pop-up format menu 3.1.2
objects Format Key Column 6.1.1 preview Chart preview 0.1
Objects 10.2 Chart Preview (Tutorial) 9.16
open File Menu 3.2 Table preview 5.8
Open Open 3.2.2 Table Preview (Tutorial) 9.14
Opening a Dataset 2.3 primer What can I do? 9.2
Opening the Program 2.2 print Output Menu 3.4
Open Dataset Install Dataset 3.2.6 Outputting the data 9.17
Opening Opening a Dataset 2.3 Printer setup 3.4.7
Opening the Program 2.2 Report Wizard 5.5
Opening a Dataset Opening a Dataset 2.3 Destination 5.1
Opening the Program Opening the Program 2.2 Simple Report 3.4.3
operator Arithmetical Operators 4.4.1 Tables 3.4.4
 FishStat Plus Help Manual 158

keyword Chapter Name Ch.# keyword Chapter Name Ch.#

print Tables and Charts 3.4.6 resize Splits 10.3
Output 51.1 right-click Pop-up Menus 10.3
print preview Chart Preview (Tutorial) 9.16 round Conversion Functions 4.4.2
Table preview 5.8 rows Select Source Records 5.6
Table Preview (Tutorial) 9.14 RTF Destination 5.1
print screen Simple Report 3.4.3 save File Menu 3.2
Printer setup Printer setup 3.4.7 Save 3.2.4
properties Manage Datasets 3.2.5 scientific Column Options 6.1.2
Quit Exit 3.2.7 screen Main Window 1.3
rank Calculated Column 4.3 Time-series Grid 10.2
Columns 8.4 scroll Accelerator Button 10.3
Rank Column 8.4 Scrollbar Scrollbar 10.3
rank column Format Numbers 3.5.2 search How to find text 10.1
Rank Column 8.4 select deselect all 10.1
Records Choosing record output 9.12 select all 10.1
Select Source Records 5.6 select all select all 10.1
Redo Undo 3.3.8 Selecting chart options Selecting chart options 9.15
Reference Dataset Reference Dataset 10.2 Selecting table options Selecting table options 9.13
remove Dataset Manage Datasets 3.2.5 selection invert selection 10.1
repetition Special Values 10.2 select all 10.1
report Charts 3.4.5 shortcut Hot key 10.1
Report Columns 5.3 Keyboard Reference 10.1
Outputting the data 9.17 Pop-up Menus 10.3
Report Wizard 5.5 significant Top/Other 3.3.6
Destination 5.1 significant digits Column Options 6.1.2
Report Type 5.2 Simple Report Simple Report 3.4.3
Table Options 5.7 sort Data Menu 3.3
Simple Report 3.4.3 Sort 3.3.5
Tables 3.4.4 Sorting the Dataset 9.6
Tables and Charts 3.4.6 Sorting Sorting the Dataset 9.6
report style Defining Report Tables 9.8 Sorting the Dataset Sorting the Dataset 9.6
Report Type 5.2 source Select Source Records 5.6
report wizard Chart preview 0.1 Special Value Special Values 10.2
Charts 3.4.5 Special Values 10.2
Defining Report Tables 9.8 Splits Splits 10.3
Choosing column output 9.11 spreadsheet Tables 3.4.4
Choosing record output 9.12 Tables and Charts 3.4.6
Output Menu 3.4 Statistical Functions Statistical Functions 4.4.5
Outputting the data 9.17 statistics Statistical Functions 4.4.5
Report Wizard 5.5 Status Bar Status Bar 10.3
Report Wizard Arrows Report Wizard Arrows 10.3 store Save 3.2.4
Chart Options Chart Options 5.9 string Numeric & String 4.4.4
Chart Preview (Tutorial) Chart Preview (Tutorial) 9.16 Comparison
String Functions 4.4.6
Destination Destination 5.1
String Comparison Numeric & String 4.4.4
Report Type Report Type 5.2 Comparison
Select Data Columns Select Data Columns 5.5 String Functions String Functions 4.4.6
Select Source Records Select Source Records 5.6 style Defining Report Tables 9.8
Table Options Table Options 5.7 Report Type 5.2
Table preview Table preview 5.8 submenu Four ways to use menu 10.1
reports Output Menu 3.4 substring String Functions 4.4.6
 FishStat Plus Help Manual 159

keyword Chapter Name Ch.# keyword Chapter Name Ch.#

subtract Arithmetical Operators 4.4.1 top Top/Other 3.3.6
sylk Destination 5.1 top/other Data Menu 3.3
system-defined Reference Dataset 10.2 Top/Other 3.3.6
table Report Wizard 5.5 Displaying Significant Data 9.7
Destination 5.1 total Grand Total 3.3.7
Report Type 5.2 training Four ways to use menu 10.1
Table preview 5.8 tutorial Tutorial conclusion 9.18
Selecting table options 9.13 Aggregating the Dataset 9.4
Table Preview (Tutorial) 9.14 Analysing the Dataset 9.5
Tables and Charts 3.4.6 Chart preview 0.1
Table Options Table Options 5.7 Defining Report Tables 9.8
Table preview 5.8 Defining Report Columns 9.9
Selecting table options 9.13 Defining Rows and Charts 0.1
Table preview (Tutorial) 9.14 Choosing column output 9.11
Table preview Table preview 5.8 Choosing record output 9.12
Table preview (Tutorial) 9.14 Filtering the Dataset 9.3
tables Defining Report Tables 9.8 Opening a Dataset 2.3
tables Output Menu 3.4 Opening the Program 2.2
Tables 3.4.4 Outputting the data 9.17
tables and charts Defining Report Tables 9.8 Selecting chart options 9.15
Output Menu 3.4 Selecting table options 9.13
Report Wizard 5.5 Sorting the Dataset 9.6
Destination 5.1 What can I do? 9.2
Report Type 5.2 What should I see? 9.1
Tables and Charts 3.4.6 Tutorial conclusion Tutorial conclusion 9.18
time Time-series Column 8.5 type Report Type 5.2
time-series Columns 8.5 unknown value Format Hilite 3.5.3
Years List 10.2 Special Values 10.2
Time-series Column Dataset 10.2 What can I do? What can I do? 9.2
Format Numbers 3.5.2 What should I see? What should I see? 9.1
Time-series Column 8.5 window Splits 10.3
Time-series Grid Time-series Grid 10.2 windows Clipboard 10.2
Toolbar Toolbar 10.3 write Save 3.2.4
Toolbar 10.3 xor Logical Operators 4.4.3
tools Tools Menu 3.5 Years Time-series Column 8.5
Tools Menu Tools Menu 3.5 Years List Years List 10.2
ToolTip Window ToolTip Window 10.2