Map Projection Transformation by Excel function.

2014/09/02 at 3:34 PM
filed under 未分類

There are many way to transform coordination projection, but noting on Excel even many source data comes by CSV files or Excel files. We made projection transform functions in Excel. Please install the add-in and try the functions.

投影変換する方法はたくさんありますけど、元データがCSVファイルで来るのにExcelでそのまま変換できないってイマイチと思いアドインで作ってみたら、あれ簡単にできたので公開します。

Screen shot

projectionTransformExcel

Download

ProjTransform-AddIn.zip
Extract the zip and double click “ProjTransform-AddIn.xll”.

Usage

PjTransformX([source_x], [source_y], [source_srid|source_projection_name|source_proj4text], [source_srid|source_projection_name|source_proj4text])

PjTransformY([source_x], [source_y],  [source_srid|source_projection_name|source_proj4text],  [source_srid|source_projection_name|source_proj4text]) 

[source_srid]: ESPG code by number. (4326, 3785, 2540.....)
[source_source_projection_name]: ESPG code by number. ("EPSG:4326", "EPSG:3785", "ESRI:24891"....)
[source_proj4text]: proj4test style projection description.("+proj=aeqd +lat_0=35.6894874 +lon_0=139.6917058 +x_0=0 +y_0=0 +datum=WGS84 +units=m +no_defs"....)

Examples

WGS84 to Web Mercator

PjTransformX(139.76721, 35.68156, 4326, 3785)
PjTransformX(139.76721, 35.68156, "EPSG:4326", "EPSG:3785")
PjTransformX(139.76721, 35.68156, "EPSG:4326", "+proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m +nadgrids=@null +wktext  +no_defs")
PjTransformY(139.76721, 35.68156, "+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs", 3785)
PjTransformY(139.76721, 35.68156, 4326, "EPSG:3785")
PjTransformY(139.76721, 35.68156, "EPSG:4326", "+proj=merc +a=6378137  +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m  +nadgrids=@null +wktext  +no_defs")

Source Code

comming soon.

Licence

MIT.

Supported Projections and Quality

The functions use Proj4Net (http://proj4net.codeplex.com/). Supported projections and the calculation quality depend on the library.
この関数はProj4Netを使っています。対応する投影法および計算精度はこのライブラリに依存します。

The Proj4net pages below show you supported projection name lists:

* EPSG http://proj4net.codeplex.com/SourceControl/latest#trunk/Proj4Net/Resources/epsg
* ESRI http://proj4net.codeplex.com/SourceControl/latest#trunk/Proj4Net/Resources/esri

Supported Excel Versions

We checked the functions on these environments:

* Excel 2013(32bit) on Windows 8(64bit)
* Excel 2010(32bit) on Windows 7(64bit)

no comments

RSS / trackback

respond