摘要
在森林样地调查计算工作中,以贵州省现有地方标准中已有的二元立木材积模型为例,在EXCEL中输入树种名称、胸径和备注,通过IF、CODE、SMALL、INDEX、MATCH、COUNTIF、SQRT、AVERAGEIF等函数搭配,生成各树种按胸径由小到大的排序表和对应样木编号,并计算出各树种各径阶平均胸径和对应株数,参考生成和计算结果,人为主观选择需要测量树高的样木,测量树高并输入,完成外业数据采集。结合树种分类统计思路,采用AVERAGEIFS、IF等函数和二元立木材积模型分树种按径阶计算平均树高和蓄积等,并进一步结合SUMIF、SUM、LARGE、CONCATENATE、SQRT、AVERAGE等函数计算优势树种、树种组成和样地指标、小班指标,完成数据计算过程。最后在数据展示工作表中展示出简洁、明了并包含必要信息的调查计算成果。实践证明此方法计算精度高,提高了工作效率,具有较高的可操作性和实用性。
Here the systematic investigation and calculation were implemented on the forest sample plots using EXCEL software.A case study was also taken as the current binary standing volume model in the local standards database of Guizhou Province,China.Firstly,the tree species name,DBH,tree height and remarks were input into EXCEL platform.A combination was then constructed with the IF,CODE,SMALL,INDEX,MATCH,COUNTIF,SQRT,and AVERAGEIF functions.The table list and sample number of each tree species were also ranked in the ascending order by DBH.The average DBH was then calculated to correspond the number of trees of each tree species.Secondly,the field data collection was realized to select the sample trees that need to measure the height of the tree.The average tree height and storage of tree species were then calculated using the AVERAGEIFS and IF functions,as well as the binary standing volume model,according to the diameter level combined with the classification and statistics of tree species.Furthermore,the dominant tree species,tree species composition,sample plot index,and Sub-Compartment index were calculated to combine with the function of SUMIF,SUM,LARGE,CONCATENATE,SQRT,and AVERAGE.Finally,the concise,clear and necessary information was achieved in the data display module.The new method with the high accuracy of calculation,operability and practicability can be expected to greatly promote the efficiency in the investigation and calculation of the forest sample plots.
作者
舒德远
何光辉
张洁
杨林
桂加英
张耀荣
陈松
SHU Deyuan;HE Guanghui;ZHANG Jie;YANG Lin;GUI Jiaying;ZHANG Yaorong;CHEN Song(Guizhou Academy of Forestry,Guiyang 550005,Guizhou,P.R.China)
出处
《贵州林业科技》
2023年第4期61-66,72,共7页
Guizhou Forestry Science and Technology
基金
黔林科合J字[2022]08号。
关键词
EXCEL
森林样地
调查
计算
EXCEL
forest sample plots
investigation
calculation
