割圆锥投影的正反算变换——Excel VBA实数计算与Mathcad复数变换

Forward and Inverse Transformation of Secant Conic Projection—Excel VBA Real Number Calculation and Mathcad Complex Number Transformation

摘要: 圆锥投影图广泛用于中小比例尺地图，如国际航空图、全国地图、中小比例尺分省地图、地质图、专用地图等。利用计算工具Excel VBA及Mathcad分别开发了适用于BJ54、XIAN80、WGS84、CGCS2000坐标系割圆锥投影的实数及复数正反算变换程序，为野外地质调查进行快捷的批量坐标转换提供了普适工具。

Abstract: Conic projection maps are widely used in small and medium-sized maps, such as international aerial maps, national maps, provincial maps at small and medium-sized scales, geological maps, and specialized maps. Real and complex forward and inverse transformation programs suitable for cutting cone projection in BJ54, XIAN80, WGS84, and CGCS2000 coordinate systems were developed using calculation tools Excel VBA and Mathcad, respectively, providing a universal tool for fast batch coordinate transformation in field geological surveys.