manual fisat ii

8/9/2019 Manual fisat II

1/159

FishStat Plus Help ManualFisheries Data Analysis Software for Windows™

FAO Headquarters

FIDI, F-201

Viale delle Terme di Caracalla00100 Rome, Italy


2/159

FishStat Plus Help Manual 2

FishStat Plus Help Contents

1 Introduction1.1 About FishStat Plus1.2 Receiving Technical Support from the FAO1.3 An Overview of the Main Window

2 Installation2.1 Installation2.2 Opening the Program2.3 Opening a Dataset

3 Menus3.1 Pop-up Menus

3.1.1 Aggregate3.1.2 Format

3.2 File Menu3.2.1 Introduction3.2.2 Open Dataset3.2.3 Close Dataset3.2.4 Save Dataset

3.2.5 Manage Datasets3.2.6 Install Dataset3.2.7 Exit Program

3.3 Data Menu3.3.1 Introduction3.3.2 Filter 3.3.3 Aggregate3.3.4 Edit Columns3.3.5 Sort3.3.6 Top/Other

3.3.7 Grand Total3.3.8 Undo

3.4 Output Menu3.4.1 Introduction3.4.2 Copy3.4.3 Simple Report3.4.4 Tables3.4.5 Charts


3/159


3.4.6 Tables and Charts3.4.7 Printer Setup3.4.8 Report Wizard

3.5 Tools Menu3.5.1 Introduction3.5.2 Format Numbers3.5.3 Format Special Values (Hilite)3.5.4 Custom Group (Group Manager)3.5.5 Language and Font3.5.6 Dataset Notes3.5.7 Map

4 Building Expressions4.1 Expression Builder 4.2 Edit Expression4.3 Calculated Column

4.4 Expression Function List4.4.1 Ar ithmetical Operators4.4.2 Conversion Functions4.4.3 Logical Operators4.4.4 Numeric & String Comparison Operators4.4.5 Statistical Functions4.4.6 String Functions

5 Report Wizard5.1 Introduction

5.2 Report Tables and Charts5.3 Report Columns5.4 Report Rows & Chart Direction5.5 Select Data Columns5.6 Select Source Records5.7 Table Options5.8 Table Preview5.9 Chart Options5.10 Chart Preview

5.11 Output6 Customising

6.1 Formatting6.1.1 Format Key Column6.1.2 Numeric Column Options

6.2 Creating Groups6.2.1 Aggregate Set


4/159


6.2.2 Custom Filter 6.2.3 Edit Group6.2.4 Group Manager

7 Understanding Datasets7.1 Introduction

7.2 Dataset Family7.3 Measurement Units

8 Working with Columns8.1 Introduction8.2 Calculated Column8.3 Key Column8.4 Rank Column8.5 Time-series Column8.6 Notes

9 Tutorial9.1 Introduction9.2 Navigating the Main Window9.3 Filtering the Dataset9.4 Aggregating the Dataset9.5 Analysing the Dataset9.6 Sorting the Dataset9.7 Displaying Only the Significant Data

9.8 Defining Report Tables9.9 Defining Report Columns9.10 Defining Rows and Charts9.11 Choosing which Columns to Output9.12 Choosing which Records to Output9.13 Selecting Table Options9.14 Table Preview9.15 Selecting Chart Options9.16 Chart Preview

9.17 Outputting the Data9.18 Tutorial Conclusion

10 Glossary10.1 Commands and Shortcuts

CancelDeselect AllFive Ways to Access the MenuHot-keysHow to Find Text


5/159


Invert SelectionKeyboard ReferenceSelect Al l

10.2 ConceptsBase DatasetCalculated Columns GridChart Point

Chart SetClipboardKeysNotesObjectsReference DatasetTime-series GridToolTip WindowYears L ist

10.3 Screen Elements Accelerator Button Ar rowsData Display

Menubar Pop-up MenusScrollbar SplitsStatusbar Toolbar

11 Index


6/159


1 Introduction1.1 About FishStat Plus

Fisheries Data

Statist ical 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 laptopwill 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, enhancedexpression 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 organiseyour data.

• Its open-ended architecture ensures that as new datasets are produced they can be installed into thesystem 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-designedfiltering and aggregating options for use with other datasets.


7/159


1.2 Receiving Technical Support from the FAO

Support for FishStat Plus

is provided by:

Tony JarrettFisheries Data Officer FAO Headquarters, F-201Viale delle Terme di Caracalla00100 Rome, ITALYEmail: [email protected]

Phone: (39) 06 570 55964Fax: (39) 06 570 52476


8/159


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 allprogram 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 keys to change the current row. You can alsoclick 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 displayits Pop-up Menu.

• Time-series gri d: displays all the Time-series data for the current record, since the screen is oftennot 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 tothe Time-series grid.

• Statusbar: contains information about the total number of dataset rows, the number currentlyselected, and the dataset unit.


9/159


2 Installation2.1 Installation

Select your installation:

1. Installing from the FAO Network

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

Tip: It may take a moment for the new program icon to appear.

• Next, try opening2.2

the program.

2. Installing f rom an installation d isk in to 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 menuand click . Type the following line in the input box: D\FishStat\Setup (where "D:" is the driveletter of your CD-ROM) and press .

Tip: If you're not sure what letter corresponds to your CD-ROM, open Microsoft Explorer andsearch 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.Next, try opening

2.2 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. Type the following line in the input box: D\FishStat\Setup (where "D:" is the drive letter of

your CD-ROM) and press .

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 theProgram Manager . Next, try opening

2.2 the program.

See AlsoOpening the Program

2.2

Opening a Dataset2.3


10/159


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 AlsoOpening a Dataset

2.3

Installation2.1


11/159


2.3 Opening a Dataset

•If no datasets are installed on the system1. FishStat Plus will automatically search the network (if you are installing from the CD-ROM, leave itin the CD-ROM drive. FishStat Plus will search for the datasets included on the CD-ROM) and locateany that are available. It will prompt you to install each dataset it finds.

2. Install any you require by selecting . If you select , you will not be asked in the future toinstall the dataset. If you select you will be prompted to install the dataset the next time youopen FishStat.

3. For every dataset you elect to install, the program will ask you whether you would like to ,, or it. Copying the dataset takes room on your hard-drive but may increaseprogram speed.

Tip: At the time of the production of these help instructions (Mar. 2000) the entire FishStat Pluspackage including ALL available datasets required 40mb of memory.

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

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

See AlsoOpening the Program2.2

Installation2.1


12/159


3 Menus3.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 thatis 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 Aggregating

3.1.1 and Formatting

3.1.2.

• Right-clicking on a Time-series8.5

, Calculated8.2

, or Rank Column8.4

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"


13/159


• Within the Filter 3.3.2

and Custom Groups6.2

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 dialogbox.

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

See Also:Four Ways to Use the Menu

10.1

Keyboard Reference

10.1

How to Find Text10.1


14/159


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 youdesire.

• Placing the mouse pointer over the Group command causes a secondary pop-up to appear that liststhe Group types available for selection. If you choose Handpicked FishStat will open the AggregateSet

6.2.1 dialog box.


15/159


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 availabledisplay types. Click the desired type and the program returns you to the Data Display.


16/159


3.2 File Menu3.2.1 Introduction

The six commands found in the File menu have to do w ith loading, saving, and managing Datasets

• Open3.2.2

• Save3.2.4• Close

3.2.3

• Manage Datasets3.2.5

• Install Dataset3.2.6

• Exit3.2.7

See also:Tools Menu

3.5

Data Menu3.3

Output Menu3.4

Four Ways to Use the Menu10.1

Keyboard

Reference

10.1


Pop-up Menus3.1


17/159


3.2.2 Open Dataset

When should you use it?• To select and load a Dataset

7.0 into the program.

Where do you find i t?• On the Menubar

10.3 click and select .

• From the Toolbar 10.3

click or

• On the Keyboard10.1

, press or press then and then .

How does it work?• The dialog box displays a list of all known datasets. Bold names are Base Datasets

10.2. These are

always loaded in their original form, unfiltered and without Calculated Columns8.2

. Under each basedataset 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-definedchild dataset.

To load a Dataset

• Double-click it

•

Highlight it using the Keyboard

10.1

arrows and then press

• Click it with the mouse pointer and click .

• Opening a Dataset7.0

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 lastsession. If not, the program will bring up the Open dataset dialog box.


18/159


See also:Menubar

10.3

Toolbar 10.3

Dataset7.0

Close3.2.3

Save3.2.4

Manage Dataset3.2.5

Install Dataset3.2.6

Exit3.2.7

Pop-up Menus3.1


19/159


20/159


3.2.4 Save Dataset

When should you use it?• To save changes to the current Dataset

7.0, and to delete or rename existing Reference Datasets

10.2.

Tip: FishStat Plus automatically saves the current dataset when you Exit

3.2.7

the program. You needonly 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 adataset to an independent file you must copy

3.4.2 it to the clipboard or export

3.4.3 it to an .RTF, .CSV,

.HTML, or .SYLK file. Please note that such a file cannot be opened from within FishStat Plus.




click or



How does it work?• The Save command will open the Save dataset dialog box:

• A list of all existing datasets will appear. Left-aligned bold names are Base Datasets10.2

. Under eachbase dataset there may be an indented list of its Reference Datasets

10.2.

• You may either type a new name in the dataset Name input box or select an existing user-definedreference dataset to overwrite (the program will not allow you to select a base or system dataset,

indicated by the key next to the Dataset7.0

name).


21/159


To switch between the input box and the list box

• Click the box with the mouse or use the key.

To select existing Datasets for overwriting

• Click them with the mouse or scroll the list with the Keyboard10.1

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 or press .

To close the dialog box without saving the Dataset

• Click or press .

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

See also:Menubar

10.3

Toolbar 10.3

Dataset7.0

Exit3.2.7

Close3.2.3

Open3.2.2

Manage Dataset3.2.5


Pop-up Menus3.1


22/159


3.2.5 Manage Datasets

When should you use it?• To install a Dataset

7.0, remove an installed dataset, or view properties information about an installed

dataset, e.g. date created, file size, Dataset Family7.2

, etc.





How does it work?• A list of all existing datasets will appear. Left-aligned bold names are Base Datasets

10.2. Under each

base dataset there may be an indented list of its Reference Datasets10.2.

To delete an installed Dataset

• Highlight it by clicking it with the mouse or scrolling the list with the Keyboard10.1

keys. Click.

To add a new Dataset

• Click . The program will take you to the Install Dataset3.2.6

dialog box.

To exit

• Click . The program will return you to the Main Window1.3

.

See also:Menubar

10.3

Dataset7.0

Open3.2.2

Toolbar 10.3

Close3.2.3

Save3.2.4


Pop-up Menus3.1


23/159


24/159


• Double click on the two dots (..) found in the upper left corner of the directory window or highlightthem by clicking them or scrolling to them with the Keyboard

10.1 and then pressing

.

To go to a sub-directory of the current directory

• Double-click it, or highlight it by clicking it or scrolling to it with the Keyboard10.1

and thenpressing .

To switch driv es

• Use this option if you have a Dataset7.0

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 theappropriate drive.

To install a Dataset from the Dataset window

• Double-click it, or highlight it by clicking it or scrolling to it with the Keyboard10.1

and thenpressing .

See also:Menubar

10.3

Dataset7.0

Save3.2.4

Close3.2.3

Open3.2.2

Toolbar 10.3

Manage Dataset3.2.5

Pop-up Menus3.1


25/159


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.




click or .


, press then and then .

How does it work?• Exit automatically saves your current session including all filtering, aggregating, etc. options and any

Calculated Columns8.2

before closing down the program and returning you to Windows .

See also:Menubar

10.3

Toolbar 10.3

Dataset7.0

Save3.2.4

Close3.2.3

Open3.2.2

Manage Dataset3.2.5


Pop-up Menus3.1


26/159


3.3 Data Menu3.3.1 Introduction

The six commands found in the Data Menu3.3

access all the ways in which a Dataset can betransformed

• Filter 3.3.2

• Grand Total3.3.7

• Aggregate3.3.3

• Edit Columns3.3.4

• Sort3.3.5

• Top/Other 3.3.6

Although you can use these commands in any order and in any combination, they are related to one another,and the program executes them in the order listed above, e.g. if you Aggregate

3.3.3 a Dataset

7.0, and then go

back and alter the filter, the program will filter the data and then re-aggregate it since filtering affectsaggregation.

See also:File Menu

3.2

Tools Menu3.5

Output Menu3.4


Keyboard Reference

10.1


Pop-up Menus3.1


27/159


3.3.2 Filter

When should you use it?• Use the Filter command to filter your Key Columns and create a subset of the current Dataset

7.0, i.e.

by restricting the number of records (rows).




click or



• To use a Pop-up Menu3.1

, 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 & ).

The Include and Exclude windows

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

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

Selecting Objects f rom 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 key and clicking them with the mouse.


28/159


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

10.1 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 theyellow 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 searchinganywhere within a name.

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

Moving selected Objects between lists

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

• Press or

• 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 bythe arrow.

• Press or

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 boxacross its top that allows you to choose different types of Groups, e.g. continents, economic Groupsof countries, etc).


29/159


• Click at the upper-right of the combo box to choose a type of Group. As you select different typesof 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 Groupname into one of the boxes.

Tip: You may also save and load your own Custom Filters6.2.2

based on your specificInclusion/Exclusion criteria

• Once you've set the filtration options for your Key Columns click to filter, or toabandon your changes. The program will return you to the Main Window

1.3.

See also:Grand Total

3.3.7

Aggregate3.3.3

Edit Columns3.3.4

Sort3.3.5

Top/Other 3.3.6

Dataset7.0

Data Menu3.3

Custom Filter 6.2.2

Grand Total3.3.7


Pop-up Menus3.1


30/159


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"




click or



• To use the Aggregate Pop-up Menu3.1.1

, 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 standardGroups (identical to those found in the Filter

3.3.2 dialog box) or choose Handpicked, an option which

allows you to create your own Aggregate Sets6.2.1

.

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

• Once you've set the aggregation options for your Key Columns click to aggregate, or to abandon your changes. The program will return you to the Main Window

1.3.


31/159


See also:Filter

3.3.2

Grand Total3.3.7

Edit Columns3.3.4

Sort3.3.5

Top/Other 3.3.6

Aggregate Sets6.2.1

Dataset7.0

Data Menu3.3

Custom Filter 6.2.2

Pop-up Menus3.1


32/159


3.3.4 Edit Columns

When should you use it?• Use this command to create, edit, and remove Calculated

8.2 & Rank Columns

8.4, Hide/Reveal Time-

series Columns8.5

, and modify column headers, widths and output formats.




click or



Tip: Calculated Columns can also be edited by right-clicking them and selecting from thePop-up Menu

3.1.

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 individualColumns. On the left are commands to delete, hide and modify Columns. On the right are commandsfor 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


33/159


• 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 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 key and clicking the last Object in the range or by using the Keyboard

10.1 arrows.

Deleting, hid ing, and revealing ColumnsTo Delete a Calculated or Rank Column or Columns

• Select the column or Columns you wish to delete. Click or press it on your Keyboard10.1

.Tip: you can also delete by right-clicking the column and selecting from the Pop-upMenu

3.1.

To Hide a Time-series Column or Columns

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

To Reveal a hidden Time-series Column or Columns

• Click , and then click the column you wish to Reveal (click to reveal all hidden

Columns.Tip: you can also reveal by right-clicking the column and selecting 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 theFormat Key Column dialog box.Tip: you can also add a second column by right-clicking the Key Column you wish to add a displayformat to and click from the Pop-up Menu

3.1.

Formatting ColumnsTo Format or Reformat a Key Column or Columns

• Select the Key Column or Columns you wish to format. Click . The program will take you tothe Format Key Column dialog box.Tip: you can also Format a Key Column via the Format

6.1 Pop-up Menu

3.1.2.

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


34/159


• Select the Time-series or Calculated Columns8.2

or Columns you wish to format. Click . Theprogram displays the Column Options

6.1.2 dialog box.

Tip: you can also Format by right-clicking the column and selecting from the Pop-upMenu

3.1.

Working with ExpressionsTo Edit the expression i n an existing Calculated column

• Select the column you wish to edit. Click or press . The program will open the EditExpression

4.2 dialog box.

To create a new Sum or Average Calculated column

• Click on Sum (or press then ) or Average (or then ). The program willdisplay the Edit Expression dialog box with the expression already completed.

• If you wish to apply the expression to only a selected portion of the Time-series Columns8.5

, edit thenumbers in the Years List

10.2. Click or press .

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

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

1.3

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

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

3.1.

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

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

To create a Calculated column w ith a user-defined expression

• Click (or press then )The program will display the Expression Builder

4.1 dialog box.


35/159


See alsoExpressions, functions and operators

4.4

Expression Builder 4.1

Dataset7.0

Data Menu3.3

Format6.1

Column Options6.1.2

Pop-up Menus3.1


36/159


3.3.5 Sort

When should you use it?• To select sort criteria and sort the current Dataset

7.0.




click or

• From the Keyboard10.1

type or press then and then .

• From the Data Display10.3

, put the mouse pointer in any Time-series or Calculated column and right-click. Choose from the Pop-up Menu

3.1.

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 aresecond and subsequent sort Columns taken into account:

• The Columns window lists all Columns that can be used as sort criteria ( Rank Columns8.4

cannot beused as they depend on other Columns). The first item in the list is always "None". Click it to clear thesort criteria field.

To make a column the primary sort k ey

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


37/159


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

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 SortCriteria box, or press then .

To delete any sort key other than the primary sor t key

• Drag to the Sort Criteria box containing the key you wish to delete, or

• Click in the Columns window and click the button next to the Sort Criteria boxcontaining the key you wish to delete, or press then .

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:Filter

3.3.2

Grand Total3.3.7

Aggregate3.3.3

Edit Columns3.3.4

Top/Other 3.3.6

Expressions, functions and operators4.4


Dataset7.0

Data Menu3.3

Format6.1

Column Options6.1.2

Aggregate Sets6.2.1

Custom Filter 6.2.2

Pop-up Menus3.1


38/159


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.




click or




, right-click any Time-series Column8.5

.

How does it work?• FishStat Plus can be configured to display only the top (or most significant) records of the Dataset

7.0.

The program will display the Top/Other selection dialog box:

• First click at the right of the "...by field" combo box. Select a Time-series8.5

or CalculatedColumn

8.2 by clicking it.

• Next, specify either a number of top records to select (e.g. top 50 records), or a percentage of thetotal (e.g. records comprising 80% of the total column value, with inclusion priority given to thoserecords 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:Filter

3.3.2

Grand Total3.3.7

Aggregate3.3.3

Edit Columns3.3.4

Sort3.3.5

Expressions, functions and operators4.4


Dataset7.0


39/159


40/159


3.3.7 Grand Total

When should you use it?• To add a Grand Total line to the bottom of the Main Window

1.3 Data Display.




click or




, right-click any Time-series Column8.5

.

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 inthe Data Menu

3.3.

• The values displayed in the Grand Total row are only affected by the choices you make whenFiltering

3.3.2.

Tip: Formulas in the Calculated Columns8.2

are evaluated AFTER the Grand Total has beencalculated, e.g. for the column "Forecast" the Grand Total row contains the forecast of sum, not thesum of all forecasts.

See Also:Filter

3.3.2

Aggregate3.3.3

ColumnsSort

3.3.5

Top/Other 3.3.6

Pop-up Menus3.1


41/159


3.3.8 Undo

When should you use it?• The Undo Command reverses the last action.





How does it work?• Select the command and the program will automatically go back one step.

Tip: to undo all of your changes since you last saved the file, use the Close3.2.3

command and thenre-Open

3.2.2 the Dataset

7.0.

See also:Exit

3.2.7

Pop-up Menus3.1


42/159


3.4 Output Menu3.4.1 Introduction

The six commands found in the Output Menu3.4

access all the ways in which a Dataset can beoutputted

• copy3.4.2

• Simple Report3.4.3

• Tables3.4.4

• Charts3.4.5

• Tables and Charts3.4.6

• Printer Setup3.4.7

These commands range from the simple copy3.4.2

command, which sends row data to the Clipboard10.2

, to thesophisticated Tables and Charts

3.4.6 option that allows you to create combination text and graphic reports.

Tip: Tables, Charts, and Tables and Charts all use the Report Wizard5.0

to navigate you through reportcreation.

See also:File Menu

3.2

Data Menu3.3

Tools Menu3.5

Report Wizard5.0


Keyboard Reference

10.1

Pop-up Menus3.1


43/159


3.4.2 Copy

When should you use it?• To export a row or rows to the Clipboard

10.2 for use by another application.






to copy, right-click any column and select .

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 key and clicking with the mouse.

• Select a range of rows by clicking the first row with the mouse and then holding down the keyand clicking the last Object in the range, or hold down the key and then press theKeyboard

10.1 up or down .

2. Copy the selected rows to the Windows cl ipboard

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

3. Paste into another appl ication• 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 ToolsMenu

3.5, 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:Report Wizard

5.0

Tables3.4.4

Charts3.4.5

Tables and Charts3.4.6

Pop-up Menus3.1


44/159


3.4.3 Simple Report

When should you use it?• To print a report that has the same layout as does the data in the Main Window

1.3, without the

addition of any other supporting material.

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




click or . The program will display a drop-down menu with four commands. Select .



How does it work?• Following the selection of "Simple Report" the program opens the Destination

5.11 dialog box.


5.0

Tables3.4.4

Charts3.4.5


copy3.4.2

Pop-up Menus3.1


45/159


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-

series Columns

8.5

to a few years.

Tip: This option does not support Charts3.4.5

.







How does it work?• Following the selection of "Tables" the program opens the Report Type dialog box.


5.0

Charts3.4.5


Simple Report3.4.3

copy3.4.2

Pop-up Menus3.1


46/159


3.4.5 Charts

When should you use it?• To print Charts

3.4.5 using the data in your Dataset

7.0. 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

the Time-series Columns

8.5

to a few years. You may also choose from a multitude of styles, e.g. pie,bar, 3-d.

Tip: This option does not support Tables3.4.4

.







How does it work?• Following the selection of "Charts" the program opens the Report Type dialog box.


5.0

Tables3.4.4


Simple Report3.4.3

copy3.4.2

Pop-up Menus3.1


47/159


3.4.6 Tables and Charts

When should you use it?• To print tables and charts using the data in your Dataset

7.0. The Tables and charts option gives you

all the versatility found in the Tables3.4.4

option and in the Charts3.4.5

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 theChart Direction

5.4 option







How does it work?• Following the selection of "Tables and Charts

3.4.5" the program opens the Report Type dialog box. Be

sure and experiment with the very important Chart Direction5.4

command.


5.0

Charts3.4.5Tables

3.4.4

Simple Report3.4.3

copy3.4.2

Pop-up Menus3.1


48/159


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 toFishStat Plus. This allows you to use a printer other than the default Windows printer, and/or usethe printer with different settings. This behaviour is by design.





• Or from any of the Report Wizard's eight screens, click from the Toolbar. The program willdisplay the Destination

5.11 dialog box. If printer output is selected, the Printer 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 byaltering the configurations found in the printer driver software. See the instructions below: "To changeprinter settings".


49/159


To select printer

• In the Select Printer combo box, click and click on one of the listed printers to select it. There maybe 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 or press . The Printer Options dialog boxwill display. Change the settings as desired and press to return to the Printer Setup dialog box.Otherwise click 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 filethat 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. FishStatPlus will not allow you set margins to less than 3mm or more than 75 mm.


5.0

Charts3.4.5

Tables3.4.4

Simple Report3.4.3

copy3.4.2

Pop-up Menus3.1


50/159


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

you to format your tables and Charts3.4.5

.


10.3 click and select either , , or .

• From the Toolbar click or . The program will display a drop-down menu with four commands. Select either , , or .


, press (for Tables), (for Charts), or (for Tablesand Charts), or press then and then either (for Tables), (for Charts), or (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 aspecialised 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.

• To learn more about the Report Wizard's screens, continue to Report Tables3.4.4

, the first step in theReport Wizard.

See also:Report Tables

3.4.4

Report Columns5.3

Report Rows and Chart Direction5.4

Selecting Columns5.5

Selecting Source Records5.6

Table Options5.7

Table Preview5.8

Chart Options5.9

Chart Preview5.10

Outputting to a File or Printer 5.11

Pop-up Menus3.1


51/159


52/159


3.5.2 Format Numbers

When should you use it?• To change the numerical display format for Calculated

8.2, Rank

8.4, and Time-series Columns

8.5.

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 mustselect from the menu.




, press , or press then and then .

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 Time-series (a display format change to a Time-series Columns

8.5 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 .


53/159


To display values as percentages (useful fo r some values)

• Click .

When the numbers are formatted/reformatted

• Click or press . The program will return you to your previous screen. Otherwise click

to abandon your changes.

See also:Edit Columns

3.3.4

Format Highlight3.5.3

Pop-up Menus3.1


54/159


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 fromthe menu.




, press , or press then and then .

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 changethe 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.


55/159


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. thesum 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 and the program will return you to your previousscreen. Otherwise click to abandon your changes.


56/159


See also:Edit Columns

3.3.4

Column Options6.1.2

Pop-up Menus3.1


57/159


3.5.4 Custom Group (Group Manager)

When should you use it:• To create, delete, rename, edit, or copy Custom Groups for use within the Aggregation

3.3.3 and

Filter 3.3.2

commands of the Data Menu3.3

.

Where do you find i t:• From within the Aggregate Set

6.2.1 dialog box click . The program will display the Group

Manager dialog box.

• On the Menubar 10.3

click and select



How does it work?• If you've done any Filtering

3.3.2 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 & ).

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

10.1 .

Once an existing Group is selected you may

• This will remove the Group from the list.

• Takes you to the Edit Group6.2.3

dialog box where you can change the Group's makeup.

• Allows you to rename the Group.

• Creates a copy of the Group and also allows you to rename it.


58/159


To create a new Custom Group

• Select the desired Tab (Key Column) and click . The program will bring up the Edit Groupdialog box.

To exit

• Click . The program will return you to the Main Window1.3

.

See also:Edit Group

6.2.3

Aggregate Set6.2.1

Aggregation3.3.3

Filter 3.3.2

Custom Filter 6.2.2


Pop-up Menus3.1


59/159


3.5.5 Language and Font

When should you use it?• To change the language and/or the font of the program.





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 byclicking 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 to return to the Options dialog box.Otherwise click 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 to save changes and exit

• Click to abandon changes and exit.

See AlsoEdit Columns

3.3.4

Format Highlight3.5.3

Column Options6.1.2

Pop-up Menus3.1


60/159


61/159


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.



How does it work?• The program displays the map:

When finished

• Click to exit and return to the Main Window

See AlsoNotes

10.2

Dataset Notes3.5.6

Formatting6.1


62/159


63/159


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 i t?• In the Expression Builder

4.1 dialog box, once the function

4.4 has been selected the Edit Expression

dialog box will be displayed.

• From the Edit Columns3.3.4

dialog box, if or are clicked, the Edit Expressiondialog box will be displayed.

• From the Edit Columns dialog box, if an existing Calculated Column8.2

is selected and isclicked, the Edit Expression dialog box will be displayed.

• To edit an existing Calculated column simply right-click it and select from the Pop-up Menu3.1.

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 follow ing

• Number


64/159


Tip: for any number that is the number of a year in the dataset range, FishStat will automaticallyinterpret as a year and not a numeric constant. To force the program to recognise a constant as aconstant 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 asubexpression 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 follow ing inpu t 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.(Statistical Functions

4.4.5)

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

4.4.2)

• Expression 1: first string or string expression against which to apply a function or operator.( Arithmetical

4.4.1 & Logical Operators

4.4.3)

• Expression 2: second string or string expression against which to apply a function or operator.( Arithmetical

4.4.1 & Logical Operators

4.4.3)

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

4.4.3)

• Forecast Year : sets year for which forecast is calculated(Statistical Functions

4.4.5)

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

4.4.2)

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

4.4.6)

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

4.4.5)

• Number of Symbols: length of substring returned by function. If sub string is found to be longer thansource string, then function returns all of it(Substring)


65/159


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

4.4.5)

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

4.4.3)

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

4.4.3)

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

4.4.5)

• Skip Negligible Values: if set to Yes FishStat Plus ignores negligible values, marking them as


66/159


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

4.4.5)

• Years List: a list of years from which to calculate an average, draw an analytical shape, calculate atotal/fluctuation/linking ratio/average/exponential growth/sum/slope, produce a count, find aminimum/maximum, or make a forecast

(Statistical Functions4.4.5)

These parameters can be fine-tuned with multiple passes.

• Simply click or press . The program will return you to the Edit Columns3.3.4

dialog box.From there click or press again to view the results of your calculations, or click to abandon your changes.

• If your new column is unsatisfactory, you may return to the Edit Columns dialog box, select your Calculated Column

8.2, and press to be returned to the Edit Expression dialog box.

See also:Expression Builder

4.1

Edit Columns3.3.4

Calculated Column8.2


67/159


4.3 Calculated Column

These are Columns defined by the user.

• You can add new Columns to a Dataset7.0

and configure them with formulas containing arithmetical

operators such as +, -, /, *, Statistical Functions4.4.5

such as sum, average, exponential growth or forecast, and many other expressions functions, and operators

4.4.

• A Calculated column may contain numerical data or text, depending on the formula.

• When you define a Calculated column, you use the Expression Builder 4.1

and its built-in formulas.This way, you can't make a mistake in spelling or syntax.

• Expressions in Calculated Columns8.2

are always evaluated after filtering and aggregation have beenfinished. These expressions may include constants as well as key and Time-series Columns

8.5 values

as parameters.

To create a new Calculated co lumn• Use Edit Columns

3.3.4 or right-click any column and select from the Pop-

up Menu3.1

.

To edit an existing Calculated column

• Right-click it and select from the Pop-up Menu3.1

, or access it via Edit Columns3.3.4

.

See also:Rank Column

8.4

Time-series Column8.5


Edit Columns3.3.4

Column Options6.1.2

Format6.1

Edit Expression4.2

Pop-up Menus3.1


68/159


4.4 Expression Function List4.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 yearsMaximum selects greatest value among selected yearsRound truncates decimal part of a number, or converts a real number into an integer


69/159


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 stringRound truncates decimal portion of a number, or converts a real number into an integer


70/159


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 argumentIIF (strings) Returns one of two string expressions depending on value of first argumentNOR ReturnsTRUE (-1) if both operands are zero. Otherwise, returns ØNOT Returns TRUE (-1) if operand is zeroOR ReturnsTRUE (-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 Ø


71/159


72/159


4.4.5 Statistical Functions

`

Analyt ical 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 wentdown a lot, and then up a little, etc.

Average Average value for selected years AverageX Average of squares, logarithms, or inverse valuesCoefficient 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 aspecified range of years.

Exponential growth this is average increase or decrease per year expressed as apercentage

Fluctuation the average change for the period selectedForecast for any year. Select a function: linear, exponential, or 'better fit' (and

possibly 'weight' method)Slope average increase or decrease per year in absolute numbersStandard Deviation gives an indication of the amount of scatter from the measure of

central tendencySum Sum of values for selected years

SumX Sum of squares, logarithms, or inverse valuesTrend value change relative to average value. Lies between -1 (rapiddecline to 0) and +1 (rapid growth from 0)


73/159


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.


74/159


75/159


76/159


Tip: if exporting to a file for use in another program, you may want to leave all your information in onetable, 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:Report Columns

5.3




Table Options5.7

Table Preview5.8

Chart Options5.9

Chart Preview5.10


Pop-up Menus3.1


77/159


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 i t?• 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 Wizardscreens 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 bluearrows appear within the column window. By clicking these you can decide which is at the top of thestack. This affects which key FishStat uses as your primary column key.


78/159


79/159


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 i t?• 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 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 andthen lists the leftover Key Columns that will make up the rows together with an estimate of how manyrows will be created.

• If the number of rows seems too high, click the "Limit number of rows to" check box and enter anumber 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


80/159


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

• If the number of Points seems too high, click the "Limit number of points to" check box and enter anumber 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.


3.4.4

Report Columns5.3



Table Options5.7

Table Preview5.8

Chart Options5.9

Chart Preview5.10


Pop-up Menus3.1


81/159


5.5 Select Data Columns

When should you use it?• This dialog box is the fourth step towards outputting any report (other than a Simple Report

3.4.3).

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

Where do you find i t?• 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 Excludewindow by clicking , and then selecting the Columns you want to include by holding down the 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 holdingdown the mouse button while dragging up or down. The process is essentially identical to the oneexplained in detail for the Filter

3.3.2 dialog box.

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

• Use the Scrollbar 10.3

in the middle of the dialog box if some Columns you need to include/exclude areoutside of the Include/Exclude window.


82/159


83/159


5.6 Select Source Records

When should you use it?• This dialog box is the fifth step towards outputting any report (other than a Simple Report

3.4.3).

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

Where do you find i t?• 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 downthe 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 downthe mouse button while dragging up or down. The process is essentially identical to the one used inthe Select Data Columns

5.5 dialog box.

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

• Use the Scrollbar 10.3

in the middle of the dialog box if parts of a record you need to see are outside of the Include/Exclude window.


84/159


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

See also:Report Tables3.4.4

Report Columns5.3



Table Options5.7

Table Preview5.8

Chart Options5.9

Chart Preview5.10


Pop-up Menus3.1


85/159


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

Report3.4.3

).

• 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 thecommand buttons in the Report Wizard Toolbar.

Where do you find i t?

• 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 youwant to repeat the header on every page regardless of whether or not the page represents thebeginning of a new chart. To change this option, toggle the "Repeat" / "Do not Repeat" buttons foundin 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.


86/159


To change the Font and the Font s ize

• Down at the bottom of the dialog box your Table's font and font size are listed. If you'd like to changethem just click the Font box and a standard Windows™ Font Selection dialog box opens. Make your selections, click and you'll be returned to the Table Options dialog box. Otherwise click 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 atable. Below are two examples, the first merged, the second not merged:

To advance to the Table preview screen click either or .


3.4.4

Report Columns5.3




Table Preview5.8

Chart Options5.9

Chart Preview5.10


Pop-up Menus3.1


87/159


88/159


• Click the copy icon .

If you don't like what you seeOften tables can get too crowded, and/or too numerous. If this is the case with your table:

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

5.4 dialog box and set a value for Max. Rows.

• Go back to the Select Dataset Columns5.5

dialog box by clicking and exclude some Columns.

• Go back to the Select Source Records5.6

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 work ing in Tables and Charts mode any changes you make to the axes will affectyour 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 anyof the Filtering

3.3.2 or Aggregating

3.3.3 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.


3.4.4

Report Columns5.3




Table Options5.7

Chart Options5.9

Chart Preview5.10


Pop-up Menus3.1


89/159


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


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 thecommand buttons in the Report Wizard Toolbar.

Where do you find i t?• 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


90/159


91/159


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

Advance to the Chart preview screen by cl icking either or .


3.4.4

Report Columns5.3




Table Options5.7

Table Preview5.8

Chart Preview5.10


Pop-up Menus3.1


92/159


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

Report3.4.3

) unless you selected Tables and Charts3.4.6

, 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 thecommand buttons in the Report Wizard Toolbar.

Where do you find i t?• 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 choicesyou'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


93/159


94/159


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 i t?• The Destination dialog box always appears as the last step when preparing a report. It appears

automatically when Simple Report3.4.3

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 anyof 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-


95/159


Click 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, andyou've named a new file or selected an existing file to overwrite, click . The program will returnyou to the Destination dialog box. Otherwise click to abandon your changes.

• Click . The program will begin outputting the file. This may take several minutes for a largeDataset

7.0. You may want to go back to earlier stages of the Report Wizard and limit your records

5.6 or

your Columns5.5

until you end up with an acceptable number of pages. You may even want to go

back even further to the Data Menu3.3 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 p

manual fisat ii

Documents