Find in Library

<p>This paper and associated software implement the Thermodynamic Equation Of Seawater – 2010 (TEOS-10) in Excel for an efficient estimation of Absolute Salinity (<span class="inline-formula"><i>S</i>_A)</span>, Conservative Temperature (<span class="inline-formula">Θ)</span>, and derived thermodynamic properties of seawater – potential density (<span class="inline-formula"><i>σ</i>_Θ)</span>, in situ density (<span class="inline-formula"><math xmlns="http://www.w3.org/1998/Math/MathML" id="M4" display="inline" overflow="scroll" dspmath="mathml"><mrow><msub><mi mathvariant="italic">ρ</mi><mrow><msub><mi>S</mi><mi mathvariant="normal">A</mi></msub><mo>,</mo><mi mathvariant="normal">Θ</mi><mo>,</mo><mi>p</mi></mrow></msub></mrow></math><span><svg:svg xmlns:svg="http://www.w3.org/2000/svg" width="34pt" height="12pt" class="svg-formula" dspmath="mathimg" md5hash="e2e2768f92bdd6c9b304a3b96275d0a6"><svg:image xmlns:xlink="http://www.w3.org/1999/xlink" xlink:href="os-18-627-2022-ie00001.svg" width="34pt" height="12pt" src="os-18-627-2022-ie00001.png"/></svg:svg></span></span>), and sound speed (<span class="inline-formula"><i>c</i>)</span>. Vertical profile template plots for these parameters are included as is an <span class="inline-formula"><i>S</i>_A</span>–<span class="inline-formula">Θ</span> diagram template, which includes plotting of the density field (computation of user-selected <span class="inline-formula"><i>σ</i>_Θ</span> lines is included). Absolute Salinity can be directly measured with the aid of a densimeter (IOC, SCOR and IAPSO, 2010: p. 82), but in TEOS-10 its estimation relies on the interpolation of data from casts of seawater from the world ocean (IOC, SCOR and IAPSO, 2010), and the Excel workbook introduced here (TEOS-10 Excel, available at <a href="https://doi.org/10.5281/zenodo.4748829">https://doi.org/10.5281/zenodo.4748829</a>) includes a subset of the TEOS-10 look-up tables necessary for this estimation, namely the Absolute Salinity Anomaly [deltaSA_ref] and the Absolute Salinity Anomaly Ratio [SAAR_ref] look-up tables. As the user simply needs to paste new data into the spreadsheet to automatically compute the oceanographic parameters referred above, this tool may prove to be useful for all who are not comfortable using the full-featured TEOS-10 programming language environments (e.g. MATLAB, FORTRAN, C) but rather need a simpler way of computing fundamental properties of seawater (e.g. density, sound speed) while adhering to current standards. Returned values are the same (up to 15 decimal places; i.e. difference <span class="inline-formula">=</span> 0.000000000000000) as the ones obtained with the MATLAB version of the GSW (Gibbs Sea Water) toolbox (McDougall and Barker, 2011) available at the TEOS-10 website (<span class="uri">https://www.teos-10.org</span>, last access: 13 April 2022). This paper describes the Excel workbook, its use, and the included VBA (Visual Basic for Applications) functions. Quality control against the GSW toolbox is also addressed, namely issues detected with the interpolated values returned by the toolbox when there are missing values in the reference look-up table. In these situations, the GSW toolbox replaces missing values with a level pressure horizontal interpolation of neighbour points, while it is clear from the testing results that vertical interpolation, which was then implemented in TEOS-10 Excel, returns a more robust solution.</p>