摘要
根据树干解析计算原理,利用Excel函数和图表工具,建立树干解析木各龄阶树高、梢长、梢底直径和材积计算模板,通过解析木生长过程分析数据,可以直接利用其图表工具绘制胸径、树高、材积生长量曲线和树干纵断面图。该模板适合于任何区分方式的解析木计算,具有界面直观、易于理解、操作简单的特点。单纯利用Excel工作表即可完成树干解析的全部工作。
According to the principles of trunk analytic calculation,Excel function and chart tools were used to set up a trunk analyzing template to calculate the tree height,trunk length,bottom diameter and timber volume of each age of wood. By interpreting wood growth process analysis data,c the chart tool can be used to directly draw breast height diameter,tree height,and timber volume growth curve and trunk longitudinal profile. This template is applicable for any distinguish method of the trunk analysis,and incorporates an intuitive interface,making it easy to understand and operate,thus allowing one to complete all the work of trunk analysis through simple use of Excel worksheets.
出处
《林业调查规划》
2015年第6期11-16,共6页
Forest Inventory and Planning
关键词
树干解析
EXCEL函数
图表工具
计算模板
解析木生长过程
生长曲线
树干纵断面
trunk analysis
excel function,chart tools
calculation template
wood growth process analysis
growth curve
trunk longitudinal profile
