基于云计算的Excel数据处理效率优化研究

Excel Data Processing Efficiency Optimization Based on Cloud Computing

为了提高Excel软件的数据处理效率,需建立一个能满足高精确度、高效率、易使用的计算环境。论文建立圆柱螺线优化插值模型,在Excel中通过五组测斜数据计算井眼曲率,再根据云计算可弹性增加计算节点的特点,将Symphony DE并行软件搭建在本地私有云环境下,通过增加计算节点数目对比运算效率与计算精度。结果表明:随着计算节点数的增加,运算效率大大提高,计算结果更加精确。

In order to improve the data processing efficiency of Excel software, computing environment that meets the high accuracy, high efficiency, easy to use is needed to build. In this paper, the model of a cylindrical spiral optimization in- terpolation is established. Through five groups of inclinometer data calculating wellbore curvature in Excel, according to the characteristics that cloud computing can increase the compute nodes flexibility, the Symphony DE parallel software builds a private cloud environment in local. By increasing the number of computing nodes, computational efficiency and accuracy are compared. The results show that with the increase of computing nodes, the operation efficiency is greatly improved and the results are more accurate.