基于Excel VBA实现林分空间结构参数的自动计算

Auto-Calculation of Spatial Structure Parameters for Forest Stand Based on Excel VBA

利用Excel VBA对林分空间结构计算进行二次开发,实现林分空间结构参数的自动计算,可避免数据量巨大、计算耗时长,且容易出错的问题,大大减少在林分空间结构分析上的时间和精力,达到数据处理自动化。林分空间结构主要参数以大小比数、角尺度和混交度为主要计算指标,计算过程的主体结构为二次遍历。通过林分内各株立木的坐标计算其相对位置,在遍历相邻木时对其是否为最近相邻木进行判断,并在寻找到最近相邻木之后计算中心木的相应指标,然后输出计算结果。经调试验证,基于Excel VBA开发的林分空间结构自动计算程序,能满足林分空间结构参数计算的需要,计算过程简单,计算结果可靠,可以作为林分空间结构进一步分析的依据。林分空间结构自动计算程序,可以减少人工计算时间,有较高的实用价值。

Further development of calculation of forest stand-level spatial structure was conducted with the Visual Basic for Applications（VBA） in Excel to realize the auto-calculation of spatial structure parameters for forest stand,which solve several problems on huge data size,time consuming and error-prone.The main calculated parameters for forest stand spatial structure include diameter ratios（neighborhood comparison）,angle scales（neighborhood pattern） and mixed degree（mingling degree）.The main structure is twice traversing.The relative position of each standing tree in the forest stand is calculated by the first traversing.Moreover,determine the closest neighbor tree by the second traversing and calculate the parameters of the central tree.Then output the results in Excel for users.Through debugging and testing,auto-calculation program of Excel VBA-Based forest stand spatial structure can fully meet the demand for the parameter calculation of forest stand spatial structure.The auto-calculation program,with simple procedure and reliable results,is very applicable due to its less time consuming,and it can provide a basis for further analysis of forest stand spatial structure.