首页|基于Excel函数及图表工具的树干解析方法

基于Excel函数及图表工具的树干解析方法

扫码查看
根据树干解析计算原理,利用Excel函数和图表工具,建立树干解析木各龄阶树高、梢长、梢底直径和材积计算模板,通过解析木生长过程分析数据,可以直接利用其图表工具绘制胸径、树高、材积生长量曲线和树干纵断面图.该模板适合于任何区分方式的解析木计算,具有界面直观、易于理解、操作简单的特点.单纯利用Excel工作表即可完成树干解析的全部工作.
Trunk Analysis Method Based on Excel Function and Chart Tools
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.

trunk analysisexcel function, chart toolscalculation templatewood growth process analysisgrowth curvetrunk longitudinal profile

梁林峰

展开 >

山西省林业调查规划院,山西太原030012

树干解析 Excel函数 图表工具 计算模板 解析木生长过程 生长曲线 树干纵断面

2015

林业调查规划
云南省林业调查规划院 西南地区林业信息中心

林业调查规划

CSTPCD
影响因子:0.45
ISSN:1671-3168
年,卷(期):2015.40(6)
  • 13
  • 2