Measurements and calculations with embedded VBA and COM codes in Excel

CHEN Yong-gang; SHI Yong-jun; TANG Meng-ping; XU Wen-bing

Volume 25 Issue 1

Jun. 2018

Turn off MathJax

Article Contents

Article Navigation > Journal of Zhejiang A&F University > 2008 > 25(1): 83-87

CHEN Yong-gang, SHI Yong-jun, TANG Meng-ping, XU Wen-bing. Measurements and calculations with embedded VBA and COM codes in Excel[J]. Journal of Zhejiang A&F University, 2008, 25(1): 83-87.

Citation:

CHEN Yong-gang, SHI Yong-jun, TANG Meng-ping, XU Wen-bing. Measurements and calculations with embedded VBA and COM codes in Excel[J]. Journal of Zhejiang A&F University, 2008, 25(1): 83-87.

Measurements and calculations with embedded VBA and COM codes in Excel

1.
School of Environmental Technology, Zhejiang Forestry College, Lin'an 311300, Zhejiang, China

Received Date: 2007-01-10
Rev Recd Date: 2007-07-02
Publish Date: 2008-02-10

Abstract

The aim is to simplify calculations of measurement adjustment and create points' files in computer assisted search service(CASS) automatically. In this study, visual basic for applications (VBA) and component object model(COM) codes were embedded into Microsoft Excel. Calculations of adjusted measurements were simplified and point files in CASS were automatically created. With this method, first COM modules with angle converts and CASS points using an active template library(ATL) template from VC were developed. Then, COM modules were used with VBA code in Excel so that measurement adjustments were calculated and point files were automatically created. This method was used for topographic measurements from 1:500 large-scale maps in the digital botanical garden of Zhejiang Forestry College with 25 points being rapidly calculated by adjustment of a closed traverse. Results revealed nearly 12 000 point files that were created automatically and accurately. With this method, complex calculating procedures were not necessary, unlike before when manually performed, and when creating the point files, mistakes were rarely made. This study showed that adjusted calculations of a closed traverse and automatic creation of point files, was relatively easy.
- engineering survey,
- survey adjustment,
- format transformation,
- visual basic for applications(VBA),
- component object model(COM module),
- Excel application

Relative Article

[1]	YIN Ping, XU Aijun, YE Junhua, XIA Fang, WANG Zehua. Measuring method of tree attributes based on consumer-grade binocular camera . Journal of Zhejiang A&F University, 2023, 40(2): 436-445. doi: 10.11833/j.issn.2095-0756.20220352
[2]	GU Wenjun, XU Aijun, YIN Jianxin. Measuring method of multiple trees attributes based on structure from motion . Journal of Zhejiang A&F University, 2022, 39(4): 792-799. doi: 10.11833/j.issn.2095-0756.20210547
[3]	SONG Bohua, GAO Ge, GAO Shan, SUN Linlin, LI Bingxue. Overview of the methods for sap flow measurement of standing tree based on thermal technology . Journal of Zhejiang A&F University, 2022, 39(2): 456-464. doi: 10.11833/j.issn.2095-0756.20210286
[4]	PEI Jianchuan, ZHANG Shuting, YANG Jinyan, ZHANG Jin. Nitrogen removal in landscape water bodies using a vertical ecological module in Yuhuang Shannan Fund Town . Journal of Zhejiang A&F University, 2018, 35(6): 987-996. doi: 10.11833/j.issn.2095-0756.2018.06.001
[5]	GUAN Fangli, XU Aijun. Tree DBH measurement method based on smartphone and machine vision technology . Journal of Zhejiang A&F University, 2018, 35(5): 892-899. doi: 10.11833/j.issn.2095-0756.2018.05.014
[6]	QIU Wenxin, ZHANG Yong, YU Jiajun, ZHANG Chao, ZHENG Chaochao, YU Shuquan. Feasibility verification with field application of a water conservation module using the InVEST Model . Journal of Zhejiang A&F University, 2018, 35(5): 810-817. doi: 10.11833/j.issn.2095-0756.2018.05.004
[7]	HUANG Xingzhao, WANG Zefu, XU Xiaoniu. Comparison of fitting approaches with biomass expansion factor equations . Journal of Zhejiang A&F University, 2017, 34(5): 775-781. doi: 10.11833/j.issn.2095-0756.2017.05.002
[8]	MO Qin, CHEN Zhibo, XIE Shiqin, CHEN Mingjian, XIA Chaozong. Developing a system for monitoring high resolution forestry ecological projects . Journal of Zhejiang A&F University, 2017, 34(4): 737-742. doi: 10.11833/j.issn.2095-0756.2017.04.021
[9]	GAO Shan, WANG Lihai, YANG Donghui, XU Wenhao. Probe-wood contact and gauge pressure with Sylvatest-Duo for precision ultrasonic measurements of wood . Journal of Zhejiang A&F University, 2016, 33(5): 875-880. doi: 10.11833/j.issn.2095-0756.2016.05.021
[10]	XU Jie, QI Dawei. Feature point extraction based nondestructive measuring methods of tree growth status . Journal of Zhejiang A&F University, 2016, 33(3): 403-408. doi: 10.11833/j.issn.2095-0756.2016.03.005
[11]	SU Yingzhang, XU Wenbing, ZHANG Guoli, MA Cancan, LIANG Dan, FANG Yapan. Range precision in forestry with Reflectorless Total Station . Journal of Zhejiang A&F University, 2015, 32(3): 376-383. doi: 10.11833/j.issn.2095-0756.2015.03.007
[12]	BAI Jiangli. Research on classification and coding of forestry ecological engineering information . Journal of Zhejiang A&F University, 2014, 31(4): 619-624. doi: 10.11833/j.issn.2095-0756.2014.04.019
[13]	SHEN Yuqi, LUO Lingping, RUAN Lehua, WENG Jiali, YU Fangbo, SHAN Shengdao. Application of a solar collector system and heat recovery coil project . Journal of Zhejiang A&F University, 2014, 31(5): 791-797. doi: 10.11833/j.issn.2095-0756.2014.05.021
[14]	YU Le, Lü Jianxiong, LI Xianjun, XU Kang, WU Yiqiang, JIANG Jiali. Comparison of X-ray scanning and slice methods for moisture distribution measurements when drying Cunninghamia lanceolata plantation wood . Journal of Zhejiang A&F University, 2013, 30(4): 543-547. doi: 10.11833/j.issn.2095-0756.2013.04.013
[15]	CHEN Jian-zhen, HE Chao, YUE Cai-rong. Atmospheric correction of an advance land imager （ALI） image based on the FLAASH module . Journal of Zhejiang A&F University, 2011, 28(4): 590-596. doi: 10.11833/j.issn.2095-0756.2011.04.011
[16]	HU Yun, FANG Lu-ming. A method of avoiding crack for compressing polygon data by topological data conversion . Journal of Zhejiang A&F University, 2011, 28(4): 597-600. doi: 10.11833/j.issn.2095-0756.2011.04.012
[17]	XU Wen-bing, GAO Fei. Application of single point positioning with Trimble 5800 in forest measurement . Journal of Zhejiang A&F University, 2010, 27(2): 310-315. doi: 10.11833/j.issn.2095-0756.2010.02.025
[18]	XU Wen-bing, GAO Fei, DU Hua-qiang. Application and precision analysis of several surveying methods in forest resources survey . Journal of Zhejiang A&F University, 2009, 26(1): 132-136.
[19]	ZHANG Lǜ-qin, ZHANG Ming-kui. Changes of organic C, N and P pools in red soil in transformation between agricultural land and forestry land . Journal of Zhejiang A&F University, 2006, 23(1): 75-79.
[20]	JIANG Wen-Wei, GUAN Yu, WANG Zu-liang, PAN Jun-hui. Application of remnant GM (1 , 1) to prediction of content of sulfur dioxide in atmosphere . Journal of Zhejiang A&F University, 2002, 19(2): 178-181.

References
Proportional views

通讯作者: 陈斌, bchen63@163.com

1.
沈阳化工大学材料科学与工程学院沈阳 110142

Get Citation

PDF

XML

Article views(971) PDF downloads(115) Cited by()

Proportional views

Measurements and calculations with embedded VBA and COM codes in Excel

1. School of Environmental Technology, Zhejiang Forestry College, Lin'an 311300, Zhejiang, China

Received Date: 2007-01-10

Rev Recd Date: 2007-07-02

Publish Date: 2008-02-10

Key words:

Abstract: The aim is to simplify calculations of measurement adjustment and create points' files in computer assisted search service(CASS) automatically. In this study, visual basic for applications (VBA) and component object model(COM) codes were embedded into Microsoft Excel. Calculations of adjusted measurements were simplified and point files in CASS were automatically created. With this method, first COM modules with angle converts and CASS points using an active template library(ATL) template from VC were developed. Then, COM modules were used with VBA code in Excel so that measurement adjustments were calculated and point files were automatically created. This method was used for topographic measurements from 1:500 large-scale maps in the digital botanical garden of Zhejiang Forestry College with 25 points being rapidly calculated by adjustment of a closed traverse. Results revealed nearly 12 000 point files that were created automatically and accurately. With this method, complex calculating procedures were not necessary, unlike before when manually performed, and when creating the point files, mistakes were rarely made. This study showed that adjusted calculations of a closed traverse and automatic creation of point files, was relatively easy.

Measurements and calculations with embedded VBA and COM codes in Excel

Abstract

References

Proportional views

通讯作者: 陈斌, bchen63@163.com

Related

Proportional views