Instructions for contributing data
How to Enter Data for New Stocks:
Use a single Excel template file for each stock. Name the Excel file as: YOURLASTNAME-STOCKID-YEAROFASSESSMENT.xls e.g. MINTO-CODNEAR-2007.xls
The spreadsheet template file has three worksheets in which data are entered: (1) meta, (2) biometrics, (3) timeseries. The template is flexible in that different information can be added for different stocks depending on data availability.
(1) The 'meta' worksheet contains information about the stock, the person entering the data, and the stock assessment document. Instructions are included in the 'meta' worksheet of the template. Entries for assessorid, stockid, TSN, and areaid are found in the corresponding Database tables.
What to do if your stock, area, assessor etc. is not listed in the Database tables? (i) If the stock is not listed in the Database table 'stock', first check if it was included in the original Myers SR database (see stock list from RAM or the online version of the original database). If the stock was included in the Myers SR database, use the same stockid. If not, a new stockid will have to be created. Stockid's are a combination of a species code and an area code. If the same species or same area are already used in the database, use the same codes for these (e.g. use COD as the species code for all cod stocks and NEAR as the area code for all stocks in Northeast Arctic). Otherwise create a new code. (ii) If the area is not listed in the Database table 'area', check if this area was included in the original Myers SR database (to see if there is already a code for this area). Otherwise create a new area code. Let Dan Ricard know of any new codes you have used when you submit the completed assessment.
(2) The 'biometrics' worksheet is where data about the stock that are single numbers (not time series) are entered. This includes life history information, biological reference points, as well as details about the time series data such as the age (SSB-AGE) and sex (SSB-SEX) of spawners, the ages used to compute the fishing mortality (F-AGE) etc.
Detailed descriptions of what to enter are included on the biometrics worksheet as well as in the Database table, biometrics.
Priority entries on this page are the time series and fisheries reference points.
**If there are time-series and/or age-specific values for a given biometric (e.g. age-specific mortality rate, or a time-series of age-at maturity), please fill in: AVAILABLE as the value for the biometric (to denote that it exists if future users wish to obtain it), and a note in the notes field about this (e.g indicating the Table or Figure the data are in).
Note: If you would like to enter additional types of biometrics data for your stock, or if the units for the variables are not listed in the time-series Database table, please let Dan Ricard know when you submit the completed assessment.
(3) The 'timeseries' worksheet is where time series data for the stock from its assessment is entered.
-The main variables, which should be entered for are: YEAR, SSB (spawner stock biomass), R (recruits), F (fishing mortality), and TB (total biomass). The units for each of these should also be entered. Detailed descriptions of what to enter (i.e. abbreviations for the units etc.) are found in the Database table, time-series. For stocks for which SSB and R are not estimated, a CPUE time series can still be entered (CPUEraw or CPUE).
-Only include columns for which you have data (i.e. if there is no SSB time series for your stock, remove this column). In the event that more than one model was used in the assessment, use “SSB-1”, “SSB-2”, etc. to store the time series. You should also put a note in the 'meta' worksheet under “assesscomments” that describes what models correspond to the different numbers.
Note: If you would like to enter additional types of time series data for your stock, or if the units for your stock are not listed in the time-series Database table, please email Dan Ricard with this information so that he can add it to the table.
**Please note that this database is a work in progress. Contact Dan Ricard If you find errors, or have new additions to add to the Database tables.
How to Submit a New Assessment
When a spreadsheet is complete with information from a stock, please either: 1) send the Excel file along with the PDF of the stock assessment to Dan Ricard or 2) submit them on the RAMlegacy assessment spreadsheet submissions page of this website after obtaining a login name from Dan Ricard. This is the preferred method.
Note: Please send your spreadsheets as they are ready, don't wait to send them all at once if you are filling many of them.