一种基于Excel的潮位曲线快速插值算法研究

Study on Quick Interpolation of Excel-based Tide Curve

主要完成对潮时或者潮高进行查询的一种改进方法,避免了利用麻烦的潮汐表、诺模图等进行查询,提高了查询效率。通过在Excel电子表格中利用3次贝赛尔样条技术,提供了一种求任意时刻对应潮高和任何潮高对应潮时的插值查询方法。根据快速插值的方法,利用VBA技术对Excel进行了二次开发。使用该程序能直观地显示出潮位曲线,并且方便地对潮高和潮时的数据进行查询。

The main purpose of this article is to make an improved methods of inquiring time of tide or height of tide.Through this method can avoid using tide table and nomograph to inquiry,thereby improve the efficiency of inquiring.Through using Thethirdpower Bazier in excel,the article provide a method of interpolation of height of tide at any time and time of tide at any height of tide.On the basis of quick interpolation,I make a repeatedly development in excel with the technology of VBA.You can get a visualized tide curve and inquiry the data of time of tide and height of tide expediently through this program.