华东交通大学学报2015，Vol.32Issue(5)：93-98,6.
二维表查找和双线性插值算法的设计与应用
Design and Application of Two-dimensional Table Lookup and Bilinear Interpolation Algorithm
摘要
Abstract
Two-dimensional table lookup and bilinear interpolation calculation is widely applied in geotechnical engineering, but the workload is big and error-prone in derived formula calculation. It is rather complex to deduce the bilinear interpolation formula by using basic principle of linear interpolation and the basic bearing capacity in actual engineering projects. This paper uses characteristic of linear fitting data for TREND function and finds out that the coefficient is 1 when the function's parameters are two groups' data with linear fitting line just through the two points formed by the two groups of data. Accordingly, TREND function can be used for linear interpolation calculation and algorithm of bilinear interpolation is then designed. Automatic look-up table method is carried out through the application of MATCH function to obtain dual index interpolation interval, the INDEX function to determine reasonable interpolation region, and the TREND function to achieve automatic search and bilinear interpolation of two-dimensional table. Special treatment for lookup interpolation interval on the boundaries of two-dimensional table is needed, and extension of linear interpolation can be achieved by special treatment. The calculation form designed in this paper is convenient and reliable, which can be used as a tool for bearing capacity interpolation, greatly facilitating the practical engineering application.关键词
Excel函数法/二维表查找/双线性插值/外延插值Key words
Excel function method/two-dimensional table lookup/bilinear interpolation/epitaxial interpolation分类
信息技术与安全科学引用本文复制引用
莫林利,赵秀绍,郑伟,王旭..二维表查找和双线性插值算法的设计与应用[J].华东交通大学学报,2015,32(5):93-98,6.基金项目
国家自然科学基金项目(51208198) （51208198）
江西省教育厅基金项目(JXJG-13-5-15) （JXJG-13-5-15）
华东交通大学校立科研基金(12RJ02) （12RJ02）
