摘要
根据实践经验,以经度97°~108°;纬度23°~34°为研究工区,用正轴切圆锥投影模型为例,介绍利用EXCEL软件中的公式对地图制图中的数据进行运算处理,求得正轴单纬圆锥投影平面直角坐标数据表,以及长度变形随纬度变化的关系数据袁。并介绍了如何利用求得的数据袁使用EXCEL软件中的图表向导进行绘图,绘得正轴单纬圆锥投影图,即大地坐标的经纬网展布图及长度变形随纬度变化的关系柱状图。实践表明,运用EXCEL软件进行数据处理、地图制图是可行的,也是高效的。
Based on the practical experience,the paper introduces the mapping application by EXCEL software.The research area's latitude is between 23 and 34 degree and longitude is between 97 and 108 degree.And the model is positive axis single latitude conic projection.Firstly,by using the function of EXCEL software and choosing the appropriate expression to calculate and get positive axis single latitude conic projection plane right-angle coordinates data table and length distortion data table about latitude.Then,using these data tables to graph through figure guide and get single latitude positive axis conic projection figure and histogram about length distortion with latitude.The practice shows that it is operational and efficient to process data and graph by using EXCEL software.
出处
《物探化探计算技术》
CAS
CSCD
2006年第1期71-74,5,共4页
Computing Techniques For Geophysical and Geochemical Exploration