Excel 软件在林木采伐作业设计角规样地中的应用

摘要

Using by the Excel software formula function to establish the design work of forest harvesting in the point sam-ple plot.The operating procedures are:1.Fill in the codes of species name form,high and yield rate;2.Fill in the in-vestigation data of tree diameter,basal area,average high;3.Fill in the subcompartment area,and other data can be generated automatically summary and calculation.The Excel software could solve the tedious,error prone in the sample survey investigation and calculation wor.%利用 Excel 软件的函数功能，建立林木采伐作业设计角规样地表，操作规程为：①填写树种名和形高、出材率代码；②录入树种、径阶、断面积、平均高等调查数据；③填写采伐小班面积，其它数据可自动生成并进行汇总计算。通过 Excel 软件解决了角规样地调查内业查表、计算等工作繁琐、容易出错等问题。