| 基于Excel VBA实现林分空间结构参数的自动计算 |
| |
| 引用本文： | 谭绪泉,谷建才,孙荣喜,陈平,马旺,赵上.基于Excel VBA实现林分空间结构参数的自动计算[J].东北林业大学学报,2011,39(6):116-118. |
| |
| 作者姓名： | 谭绪泉 谷建才 孙荣喜 陈平 马旺 赵上 |
| |
| 作者单位： | 河北农业大学;中国林业科学研究院林业所; |
| |
| 基金项目： | 国家林业局公益性行业科研专项(200804022F) |
| |
| 摘 要： | 利用Excel VBA对林分空间结构计算进行二次开发,实现林分空间结构参数的自动计算,可避免数据量巨大、计算耗时长,且容易出错的问题,大大减少在林分空间结构分析上的时间和精力,达到数据处理自动化.林分空间结构主要参数以大小比数、角尺度和混交度为主要计算指标,计算过程的主体结构为二次遍历.通过林分内各株立木的坐标计算其相...
|
| 关 键 词： | 森林经理学 Excel VBA 林分空间结构 自动化计算 二次开发 |
Auto-Calculation of Spatial Structure Parameters for Forest Stand Based on Excel VBA |
| |
| Tan Xuquan,Gu Jiancai,Sun Rongxi,Chen Ping,Ma Wang,Zhao Shang.Auto-Calculation of Spatial Structure Parameters for Forest Stand Based on Excel VBA[J].Journal of Northeast Forestry University,2011,39(6):116-118. |
| |
| Authors: | Tan Xuquan Gu Jiancai Sun Rongxi Chen Ping Ma Wang Zhao Shang |
| |
| Institution: | Tan Xuquan,Gu Jiancai(School of Forestry,Agricultural University of Hebei,Baoding 071000,P.R.China),Sun Rongxi(Research Institute of Forestry,Chinese Academy of Forestry),Chen Ping,Ma Wang,Zhao Shang(Agricultural University of Hebei) |
| |
| Abstract: | 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... |
| |
| Keywords: | Forest management Excel VBA Spatial structure Auto-calculation Further development |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
