How to Use

The online and excel interfaces differ in their operation and features. This section explains how to use both models in more detail.

How to Use (online interface)

Introductory notes
After opening the BEMEF web interface ( there are a series of introductory notes to take the user through the main components of the interface. These five notes cover the main areas to explore.

There are eight indicators on the graph display: landings, earnings, gross value added, profit, fishing jobs, wages, carbon and processing jobs. The impacts of rebuilding fish stocks beyond MSY are shown across these indicators, and the trade-offs between different scenarios and changing to the model assumptions are made visible by shifts in the graph results.

Level of comparison
The online interface makes it easy to switch analysis between the EU as a whole, particular countries, or particular fleets. A total of five units can viewed at one time.

Change model assumptions/change quota allocation
For the online interface three parameters have been prioritised for illustration. Price flexibility refers to the change in prices that would be expected from a change in quantity.

Job estimation methodologies refers to different methodologies that are used to forecast future employment. This includes an approach based on estimated days at sea and the corresponding employment required, the jobs that can be supported using labour shares of earnings and current national industry wage averages, and the jobs that can be supported using labour shares of earnings and twice the current level of national industry wage averages. These methodologies are explained in more detail in the documentation section.

Quota allocation can also be changed from allocation based on historic catch share to one that takes performance into account. This allocation occurs at national level – as the current legislation dictates. The four alternatives are: quota allocated by fuel minimisation (kilograms of catch/litre of fuel), effort minimisation (kilograms of catch/kilowatt of power/vessel), job maximisation (full time equivalent job/kilograms of catch), and profit maximisation ((net profit-subsidies)/kilograms of catch).

Using the data
Two important features to help users use the data displayed by the model are located to the right of the graph. “View data” brings up a google spreadsheet with the actual figures that can be referenced. There is also a link to download the full excel model here. “Save graph” brings up a jpeg of the graph that is currently displayed and the option to change the title or subtitle so that it can be easily shared or integrated into a report.

Guidance notes
Some of the terms and buttons on the model interface may not be known to a wider audience who are curious but not engaged with EU fisheries. As such, there is the option to turn on guidance notes that will explain some of these concepts if the cursor hovers over the area where the term is written.

Other notes for using the online interface
There is an aggregation issue when viewing an indicator that is an average rather than a sum. To be estimated properly a weighted average should be taken to reflect the difference in fleet sizes. For average profits this means calculating a weighted average based on the amount of earnings in each fleet. For average wages this means calculating a weighted average based on the number of jobs in each fleet.

When quota reallocation occurs these weighted averages create add a further level of complexity. As quota reallocation can change the modelled structure of the fleet itself (eg. from fuel-intensive to fuel-efficient fleets) the average wage for the fleets of a country may rise or fall despite there being no material changes for the fishers within that fleet (an inter-fleet change rather than an intra-fleet change). Because both of these changes may be of interest, when a change in quota allocation is selected the wage button contains two options: one for the fleet average (unweighted) and one for the fisher average (weighted).

How to Use (excel model)

Conditions of use
After opening BEMEF the first step is to read and approve the conditions of use. This is in place to ensure some control over the model’s external use while it is still in development. Although the model is largely open and editable, there are thousands of formulas used in the model make BEMEF sensitive to changes. For most users it is recommended that only the cells in yellow are changed. These parameters are meant to be adjusted for analysis.

Wherever possible, formulas have been left in rather than the values generated. This allows the user to trace back values to their origin. In some instances only the first row will have the formula and the rest of the rows have pasted values only. This allows the user to view the formula used but also limits the file size and calculation time.

Navigating tabs
There are over forty tabs with various functions that make up BEMEF. Some of these tabs are essential to using the tool but some will only be important for the advanced user. For most users the following tabs are likely all that is needed:

Table of Contents
-This tab provides a brief description for the 40+ tabs within BEMEF.

1 - Introduction
-This tab will be updated with important model details and works in progress.

2 - Dashboard
-This tab is the most important for the user. Here parameters can be changed and the effects viewed on one to four fleets in the four periods analysed. -To calculate the impacts across all fleets in the model the “Calculate All Fleets” button must be pressed. Depending on computer speed, this takes approximately 10-15 minutes.

3 – New Fleets Complete
-This tab stores the results when the “Calculate All Fleets” button is activated on the Dashboard tab. To compare the results of different scenarios across all fleets the results from each scenario should be copied from the sheet and stored elsewhere for comparison.

Port analysis
GBR separate file

40 – Map
View where in EU waters the fleets under analysis are catching their allocated quota.

Back to top