用VBA实现水利工程数据插值计算

An Interpolating Method for Hydraulic Project Data Processing Using VBA

提出了一种基于AutoCAD的水利工程数据的插值方法。采用VBA开发技术,直接利用了AutoCAD绘制拟合曲线时采用的数学插值算法对离散数据进行插值计算,而不需要构建繁琐的插值函数。以线性插值和NURBS曲线插值为例对这种方法进行了详细阐述,并给出了插值程序。这种算法简单直观、易于实现,能够方便地实现计算数据与AutoCAD图形数据的交互。

Through VBA programming, the interpolating algorithm is applied to create fit curve in AutoCAD from scattered data and interpolate its value at certain point without constructing complex interpolation equation. Application of this method with linear interpolation and NURBS interpolation is discussed in detail, some pieces of program are given too. The simple but efficient method realized the easy linking of computing data and graphics.