本文讨论了一个电子表格工具的开发和使用，以进行一般的桌面混合 储罐的评估。配电系统的物理和运行特性 储罐被用作电子表格的输入，以评估混合条件。为了这个 通过分析，从竣工设计中获得了储罐所需的物理特性 从监控和数据中获取图纸和操作特性 采集（SCADA）数据。使用 电子表格工具用于帮助选择需要进行额外计算的储罐 流体动力学（CFD）建模和水质测量（温度剖面）。这些 然后使用其他更详细的评估来验证电子表格的结果 混合评估工具。一般和详细的混合评估可作为试验的基础 建议改进或改变操作，以改善内部混合和水质 储罐。包括3个参考文献、表格和图表。

This paper discusses a spreadsheet tool that was developed and utilized to conduct a general desktop mixing evaluation of storage tanks. Physical and operational characteristics of distribution system storage tanks were used as inputs to the spreadsheet to evaluate the mixing conditions. For this analysis, the required physical characteristics of the tanks was obtained from as-built design drawings and the operational characteristics were obtained from supervisory control and data acquisition (SCADA) data. The results from the general evaluation performed with the spreadsheet tool were used to help select the tanks that would undergo additional computational fluid dynamics (CFD) modeling and water quality measurements (temperature profiles). These additional more detailed evaluations were then used to verify the results of the spreadsheet mixing evaluation tool. The general and detailed mixing evaluations can be used as the basis for recommendation improvements or operation changes to improve mixing and water quality within storage tanks. Includes 3 references, tables, figures.