Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Surveying and Mapping of Geology and Mineral Resources》 2017-01
Add to Favorite Get Latest Update

Application of Excel VBA in Data Calculation of Curve Lofting

CHEN Yue;School of Traffic and Transportation Engineering,Changsha University of Science and Technology;  
Based on the method of deflection angle in the curve lofting data calculation is complicated,and the traditional hand calculation method is error prone by man-made factors,in order to improve the efficiency and accuracy of the loft data calculation,this paper presents a calculation method based on Excel VBA programming. This paper has achieved automatic calculation of the whole pile mileage coordinates,curve point spacing and deflection angle value in the circular curve and easement curve,and can provide data for the curve lofting. In the end,the experiments of circular curve and easement curve are performed. The results show that we can fast and exact to get the data with this program,and it has a certain practical value in production practice.
【CateGory Index】: P208;;P209
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【Citations】
Chinese Journal Full-text Database 5 Hits
1 WU Qi;Construction &Installation Engineering Co.Ltd of CR11BG;;Application of the road survey and lofting by Excel spreadsheets[J];黑龙江工程学院学报;2015-06
2 LIU Ke;LIAO Zhong-ping;YU Ze-bin;Engineering Research Center of Catastrophic Prophylaxis and Treatment of Road & Traffic Safety,Ministry of Education;School of Traffic and Transportation Engineering,Changsha University of Science and Technology;;Application of Excel VBA in Approximate Adjustment of Traverse[J];地矿测绘;2015-02
3 ZENG Zhen-hua1,WANG Yan2 (1.School of Architectural and Surveying & Mapping Engineering,Jiangxi University of Science and Technology,Ganzhou 341000,China; 2.Jiangxi Environmental Engineering Vocational College,Ganzhou 341000,China);Program Development of Circular Curve Field Computing and Layout for High-grade Highways[J];实验室研究与探索;2012-12
4 SHI Lei(Harbin Institute of Geotechnical Investigation and Surveying,Harbin 150010,China);Methods for Setting out the Circular Curve and Composite Curve[J];测绘与空间地理信息;2010-01
5 ZHAO Jian-jun;The Element Factors Calculation and the Main Points Measurement of the Circular Curve with the Transition Curve[J];科技情报开发与经济;2005-12
【Co-citations】
Chinese Journal Full-text Database 3 Hits
1 Ge Qiao-qiao;ZHU Jin-xiu;School of Surveying and mapping, Anhui University Of Science And Technology;;The application of single traverse intelligent adjustment program based on Excel in Mine Surveying[J];世界有色金属;2017-06
2 CHEN Yue;School of Traffic and Transportation Engineering,Changsha University of Science and Technology;;Application of Excel VBA in Data Calculation of Curve Lofting[J];地矿测绘;2017-01
3 JI Jiao;ZHANG Yong-bin;WANG Jin-hua;GUO Li-na;YANG Shao-qiang;LIU Jia-li;College of Mining Engineering,North China University of Science and Technology;;Program Design of Traverse Adjustment Based on AutoCAD VBA[J];华北理工大学学报(自然科学版);2016-04
【Secondary Citations】
Chinese Journal Full-text Database 10 Hits
1 WEI Hui;ZHU Hong-tao;YIN Hua;CAI Jun;ZHANG Miao-miao;Nanchang University;Jiangxi University of Technology;Jiangxi Everbright Railway Equipment Development Co. Ltd;;150 m/300 m Check for the Irregularities of HSR and Its Rapid Survey[J];铁道工程学报;2015-01
2 CHEN Jian-feng;LI Fang;LI Hong-tao;Shenyang Urban Planning Design and Research Institute;;Polar Setting- Out Application in Middle Pile Curve Layout[J];测绘与空间地理信息;2014-10
3 Zhang Shuaishuai;Yu Shengwen;Wang Mingcui;Liu Shangguo;Jinan Geotechnical Investigation and Surveying Institute;College of Geomatics,Shandong University of Science and Technology;;The Coordinate Calculation of Arbitrary Easement Curve Based on VB and Matlab[J];山东科技大学学报(自然科学版);2014-04
4 FU Zhongliang;ZHOU Fan;YU Zhiqiang;School of Remote Sensing and Information Engineering,Wuhan University;Geographic Information Center of Zhejiang Province;;A Space Resection Synthesized the Multiple Features[J];测绘学报;2014-08
5 FENG Shou-Liang;College of Surveying and Mapping Engineering,Heilongjiang Institute of Technology;;A simple algorithm of point coordinates of midpile(edge pile)in the road circular curve segment[J];黑龙江工程学院学报;2014-02
6 LIU Xing;;Coordinate Calculation of the Road Pile Based on Visual Basic[J];地理空间信息;2013-06
7 Zeng Zhenhua1 Cao Wenbo2(1.Jiangxi University of Science and Technology;2.First Team of Water and Electricity of Peoples Armed Police);Development and Application of Calculation Procedures of Leica SPRINTER Serial Digital Levels[J];金属矿山;2011-03
8 WANG Guo-dong1,MA Jun-hai2(1.Tianjin Binhai Rapid Transit Development Co.,LTD,Tianjin 300457,China;2.Heilongjian Institute of Technology,Mapping and Surveying Institute,Harbin 150050,China);Calculation of Railway Cubic Parabola Transition Curve[J];交通科技与经济;2011-01
9 ZHANG Shi-liang(Ningde Institute of Teachers,Ningde 352100,China);Design and Implementation of Campus Geographic Information System Based on ArcEngine[J];江西理工大学学报;2010-03
10 Lin ZiPeng(Land Surveying Team of Land and Source Bureau,Jieyang 522031,China);The Application of Excel in Surveying and Mapping[J];城市勘测;2009-01
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved