Version 2.0.0

Readme sheet

• Defined table object Version.

Metadata sheet

• Removed Stock_Information table object definition.

• Added Countries.

• Added Assessment Type.

• Added Reporting Year.

• Defined table object From_TimeSeries.

• Renamed table object Advice_Table -> For_Advice.

• Formatted GSA cells as text in Metadata, to make them easier to type directly.

• Changed label Assessment Year -> Reference Year.

• Quantitative Status is only calculated if Validation Status is Quantitative.

• Rearranged B reference point section to a flat layout.

• Rearranged VPA-Type Model and Forecast Included to a horizontal layout.

• Stock Status Text is calculated automatically, instead of requiring user input.

• B0.33 and B0.66 are calculated automatically, instead of requiring user input.

TimeSeries sheet

• Renamed sheet Summary -> TimeSeries.

• Rearranged unit cells, so they are close to the corresponding columns.

• Renamed table object Summary_Table -> TS_Table.

• Changed label Fishing Pressure Type -> Exploitation Unit.

• Removed Effort_lower, Effort, and Effort_upper columns.

Vocabularies sheet

• Added Countries.

• Added Assessment Type.

• Extended Year range from 2021 to 2025.

• Changed Exploitation Unit options to F, HR, and Effort.

• Removed Stock Status.

Advice sheet

• Added intermediate calculations to shorten formulas.

• B0.33 and B0.66 are not exported as Reference Points, but do form the basis of the Stock Status.

• Formatted Fc and Quantitative Status to 0.00 format, with trailing zeroes.

• Quantitative Status with respect to F is reported as F/Fref or E/Eref, rather than F/Ftarget.

• Quantitative Status with respect to B is based on Bmsy, Bpa, and Blim - not on B0.33 or B0.66.

• Added GSA_Countries table object, containing comma-separated GSA Names and Countries.