摘要
为了快速完成区分求积计算过程,本文在总结中央断面区分求积式和平均断面区分求积式的基础上,提出了区分求积的Excel VBA算法:第一,根据倒木全长和区分段长度,确定区分段段数,并建立区分段序号与区分段中央直径(或底端直径)的位置序号之间的数学关系式;第二,采用中央断面近似求积式(或平均断面近似求积式)计算每个区分段的材积并求和;第三,各区分段材积之和加上梢头材积就得到伐倒木材积。根据算法,最终编写了伐倒木区分求积Excel VBA程序代码。
In order to quickly complete the computing process of sectional measurement,the Excel VBA algorithm of sectional measurement was proposed on the basis of two kinds of formulas of sectional measurement in this paper:firstly,the number of sections was determined by the length of felled trees and sections,and then the mathematical relationships between the serial numbers of sections and location serial numbers of central diameter of sections were established.Moreover,the volume of each section was calculated with Huber's formula and Smalian's formula,and the sum of volume of all sections was calculated.Finally,the volume of felled trees was calculated with the volume of all sections and tip.And on this basis the Excel VBA codes of sectional measurement were edited,and the Excel VBA program run faster and efficiently.
作者
赵浩彦
张洁
姚树人
张民侠
陈戈萍
ZHAO Haoyan;ZHANG Jie;YAO Shuren;ZHANG Minxia;CHEN Geping(Nanjing Forest Police College,Nanjing 210023,China)
出处
《湖南林业科技》
2018年第6期97-104,共8页
Hunan Forestry Science & Technology
基金
江苏省教育信息化研究课题"江苏省林地面积和林木材积计算分析辅助工具的设计和开发"(20172036)
中央高校基本科研业务费专项资金项目"北亚热带丘陵山区生物防火林带主要生态因子的变化动态研究"(LGZD201812)
