用Excel实现二元材积的自动化处理

Automatic Processing of Two Variables Volume for Wood by Excel

二元材积表,是根据每种树木的材积与胸径、树高两个因子的函数关系编制的,也叫标准材积表。在林业调查规划设计工作中,树木的材积,一般通过二元材积表去获取,对二元材积表具有严重的依赖性。既然树种的材积与胸径、树高两个因子存在函数关系,即可通过各树种的材积参数,按统一的公式计算出材积。结合计算机的应用,设计一个Excel工作薄文档,建立各树种的材积参数表,可以实现材积的自动化生成,完全摆脱对物理数表的依赖。

The Two variables volume table is based on the functional relationship between the volume of each tree and the diameter of the breast and the height of the tree, which is also called the standard volume table. In the forest survey planning and design work, the volume of trees is generally obtained through the Two variables volume table, which has a serious dependence on the Two variables volume table. Since there is a functional relationship between the volume of tree species and the two factors of DBH and tree height, the volume can be calculated according to the volume parameter of each tree species. With the application of computer, the design of a Excel workbook document, a volume parameter table of each species, can realize the automatic generation of volume, completely get rid of dependence on the physical table.