Created with Wolfram Mathematica 9.0
readFromCapTab
The Excel file CapTab contains the yearly capelin acoustic estimate in September, and in addition tables and figures for presentation of the data. This Excel file is considered the primary and authoritative source of these data. The routine readFromCapTab reads the data and makes the list stockdataFromCapTab, which is later transformed to stockdata and used in the Bifrost model. The routine checks that the sheets contain the correct data by checking that the cell A2 starts with the letter combination "Length". No other sheets should do this. The reading of data in one sheet will continue until a string is encountered in column 1. The year is taken as the number in column D3 (year class of the one year old capelin) + 1. It is tested whether the years follow each other consecutively and whether the change in length from column to column is 0.5 cm.