Design and development of trees´ spatial distribution charting tool

Author

Haoyan, Zhao ; Xingang, Kang ; Hua, Yang ; Yan, Liu ; Chuanxiang, Huang ; Yuanchang, Lu ; Ning Jinkui

Author_Institution

Key Lab. for Silviculture & Conservation of Minist. of Educ., Beijing Forestry Univ., Beijing, China

Volume

5

fYear

2010

fDate

22-24 Oct. 2010

Abstract

The paper was to generate trees´ spatial distribution map through using VBA programming language in Excel. Scatter diagram of “chart type” in Excel was served as basic framework. Graphics was generated through invoking the object of ChartObject and Chart. Trees´ spatial distribution map of circular plot was imported through polar coordinates. Graphical information was added to trees´spatial distribution map through the idea of “numerous points composing of a circle”. The tool operates very quickly and easily and is practicable. It not only could analyze trees´spatial distribution and competition among trees, but also provide reference for decision-making of forest management practice.

Keywords

Visual BASIC; charts; decision making; forestry; spreadsheet programs; ChartObject; Excel; VBA programming language; chart type; decision making; forest management practice; scatter diagram; tree spatial distribution charting tool; tree spatial distribution map; Breast; Distributed Bragg reflectors; Mercury (metals); Char; ChartObject; Excel; numerous points composing of a circle; polar coordinates; scatter diagram;

fLanguage

English

Publisher

ieee

Conference_Titel

Computer Application and System Modeling (ICCASM), 2010 International Conference on

Conference_Location

Taiyuan

Print_ISBN

978-1-4244-7235-2

Electronic_ISBN

978-1-4244-7237-6

Type

conf

DOI

10.1109/ICCASM.2010.5619239

Filename

5619239