Data underlying the paper "Is bigger always better? Designing economically feasible ocean thermal energy conversion systems using spatio-temporal resource data"

The key datasets used and generated in the paper mentioned in the title (from now on "the paper").<br>+++ Temperature_Profile.xlsx +++<br><br>This file contains the processed surface and deep-sea water temperatures that were used as inputs for the off-design analyses of the OTEC system designs. Outliers are already removed in this data set. Outliers are data points that are 1.5 times the interquartile range away from the top or bottom of the box plot. The raw temperature data can be downloaded from the HYCOM database following the download instructions elaborated in the paper.<br><br>Column A: TimeShows the timestamp of the temperature data, from 01.01.1994 00:00 until 31.12.2012 21:00 in 3-hourly time steps.<br>Columns B-C, D-E, F-G, H-IThese pairs of columns show the surface seawater temperature at 20 m depth and deep-sea water temperature at 1,000 m depth for the four locations analysed in the paper, namely Jayapura, Tarakan, Ende, and Sabang.<br>Columns K - OShow the main statistics of the temperature files, including minimum, median, and maximum values of the surface and deep-sea water temperatures at each of the four locations.<br><br>+++ System_Designs_Ende_LC +++<br>This file contains the data for Table 4 in the paper, showing the system designs based on nine different configurations of seawater temperatures as design parameters. See sections 2.1 and 2.2 of the paper to learn more about the methods used to deduce the nine temperature configurations. The system designs are created using the temperature profiles from Ende and low-cost assumptions (LC). <br><br>Please note that we used the following sign convention:<br>Work and heat entering the system: positiveWork and heat leaving the system: negative<br><br>Rows 6 - 15: Energy balance and net thermal efficiency<br>Shows the energy balance and net thermal efficiency of the Rankine cycle on which the OTEC plant is based<br>Rows 6 - 14 show the heat flows to the evaporator and from the condenser, the work from the turbine and to the pumps, as well as the losses.<br><br>Row 15 shows the net efficiency and is calculated as follows:Row 15 = |Row 14|/Row 6<br><br>Rows 17 - 28 show the exergy analysis including exergy inflow from the warm surface seawater and the exergy destruction in the system components. <br><br>Row 28: Net Exergy EfficiencyRow 28 = |Row 27|/SUM(Row 17 to 19)<br>Rows 29 to 30 show the carnot efficiency and second law efficiency.<br><br> Rows 32 to 34 show the mass flows of working fluid (here ammonia or NH3), warm water (WW) and cold water (CW).<br>Rows 36 and to 37 show the temperature differences between heat exchanger inlet and outlet of the warm water (WW) and cold water (CW).<br>Rows 39 to 44 show the dimensions and properties of evaporator (evap) and condenser (cond), namely the heat exchanger area A, saturation temperature T and saturation temperature p of the working fluid.<br>Rows 46 to 49 show the inner diameter and the number of required seawater pipes. Note, that the number of outlet pipes is the same as the number of inlet pipes, so if for example the number of WW pipes is 6, there are 3 inlet pipes and 3 outlet pipes for the warm water.<br>+++ Net_Power_Profiles.xlsx +++<br>Shows the net power output of the turbine in [kW] for 30 years (1994 - 2023) in 3-hourly time steps at the location in Ende. The values are negative as in accordance to the sign convention described above. The file contains the data for Figure 4 in the paper. There are three sheets in the file containing the net power profiles for configuration 1, 2, and 9. Please note that the four-weeks downtime period mentioned in section 2.5 is not included here yet.<br><br>Column A: TimeShows the time of the year as the x-th 3-hour interval of the year.<br>Columns B - AEShow the annual net power profiles for the years 1994 until 2023.<br>Column AFShows the average net power output at the x-th 3-hour interval of the year.<br>Column AGShows the standard deviation of the net power output at the x-th 3-hour interval of the year<br>Row 1Shows the headers for each column<br>Rows 2 to 2929Shows the net power output in 3-hour time steps. Note that rows 474 to 481 represent the 29th February. For leap-years, these rows are filled with data, for non-leap-years, these rows are NaN.<br>Row 2930Shows the sum of values under each column. For the annual electricity production in [kWh], the values in this row must be multiplied by factor 3 because of the 3-hourly time interval.<br>

本论文（即标题所指的论文，以下简称「本论文」）中所使用与生成的核心数据集。

+++ Temperature_Profile.xlsx +++

本文件包含经预处理的表层与深层海水温度数据，用作海洋热能转换（Ocean Thermal Energy Conversion, OTEC）系统设计的非设计工况分析输入参数。本数据集已完成异常值剔除：异常值指与箱线图上下四分位数间距的1.5倍偏差的数据点。原始温度数据可按照本论文中详述的下载流程，从HYCOM数据库获取。

A列：时间 展示温度数据的时间戳，时间范围为1994年1月1日00:00至2012年12月31日21:00，时间步长为3小时。
B-C、D-E、F-G、H-I列 这些列组分别展示本论文分析的四个研究区域（查亚普拉、打拉根、恩德、沙璜）的20米表层海水温度与1000米深层海水温度。
K-O列 展示温度数据集的核心统计量，包括四个研究区域各自的表层与深层海水温度的最小值、中位数与最大值。

+++ System_Designs_Ende_LC +++

本文件包含本论文中表4的相关数据，展示以海水温度为设计参数的九种不同配置下的系统设计方案。如需了解推导九种温度配置所用的方法，可参阅本论文第2.1与2.2节。本系统设计方案基于恩德区域的温度剖面与低成本假设（LC）生成。

请注意本研究采用如下符号约定：输入系统的功与热量取正值；离开系统的功与热量取负值。

第6-15行：能量平衡与净热效率 展示本论文基于的朗肯循环（Rankine Cycle）的能量平衡与净热效率。其中第6-14行展示流向蒸发器、来自冷凝器的热流，涡轮机输出功与泵的输入功，以及各项损耗。
第15行展示净热效率，计算公式为：第15行 = |第14行| / 第6行

第17-28行：火用分析 展示火用分析相关数据，包括来自表层温海水的火用流入量与系统各组件的火用损耗量。
第28行：净火用效率 计算公式为：第28行 = |第27行| / SUM(第17行至第19行)
第29-30行展示卡诺效率与第二定律效率。

第32-34行展示工质（此处为氨或NH3）、温海水（WW）与冷海水（CW）的质量流量。
第36-37行展示温海水与冷海水换热器的进出口温差。
第39-44行展示蒸发器（evap）与冷凝器（cond）的尺寸与特性参数，包括换热器面积A、工质的饱和温度T与饱和压强p。
第46-49行展示海水管道的内径与所需数量。请注意，出口管道数量与入口管道数量一致：例如若温海水管道总数为6，则温海水的入口与出口管道各为3根。

+++ Net_Power_Profiles.xlsx +++

本文件展示恩德区域1994年至2023年共30年间，涡轮机净功率输出（单位：千瓦[kW]）的3小时间步数据。按照前文所述的符号约定，该数值为负值。本文件包含本论文中图4的相关数据，文件内包含三个工作表，分别对应配置1、2与9的净功率剖面。请注意，本数据集未包含本论文第2.5节提及的四周停机时段数据。

A列：时间 以每年第x个3小时间隔展示年度时间轴。
B-AE列 展示1994年至2023年各年度的净功率剖面数据。
AF列 展示每年第x个3小时间隔的平均净功率输出。
AG列 展示每年第x个3小时间隔的净功率输出标准差。
第1行：各列的列标题。
第2-2929行：以3小时间步展示净功率输出数据。请注意，第474-481行对应2月29日：闰年时该行填充有效数据，平年时该行填充为非数值（NaN）。
第2930行：各列数值的求和结果。由于时间步长为3小时，若需计算年度发电量（单位：千瓦时[kWh]），需将该行数值乘以3。