Fanye maapụ na Excel - nweta nhazi ọnọdụ ala - nhazi UTM

Map.XL bụ ngwa na-enye gị ohere itinye map n'ime Excel ma nweta nhazi kpọmkwem site na map. I nwekwara ike igosi ndepụta nke latitudes na longitudes na map.

Otu esi tinye map na Excel

Ozugbo etinyere mmemme ahụ, a na-agbakwunye ya dị ka taabụ mgbakwunye a na-akpọ “Map”, yana ọrụ nke Map.XL.

Tupu ịtinye maapụ, ị ga-ahazi maapụ azụ, a na-eme nke a na akara ngosi “onye na-eweta maapụ”. Ọ ga-ekwe omume ịhazi ndabere site na iji maapụ abụọ ahụ, dị ka onyonyo ma ọ bụ ngwakọ sitere na ọrụ:

• Google Earth / Maps
• Maapụ Bing
• Mepee Street Maps
• ArcGIS
• Yahoo
• Ovi
• Yandex

Ihe ngosi ahụ gosipụtara na aka ochie, mana enwere ike ịdọrọ ya ka ọ na-ese n'elu, ma ọ bụ na ala / elu nke tebụl Excel.

Vidio a na-achikota otu esi akọwa usoro dum akọwapụtara n'isiokwu a, na-arụ ọrụ na oghere nke ibé site n'iji Maapụ Bing dịka ndabere.

[ulp id='hIYBDKfRL58ddv8F']

Esi nweta Excel

A na-eji akara ngosi "Nweta nkwado" mee nke a. N'ezie, usoro a bụ:

• Pịa "Nwee obi ụtọ,
• Pịa na map,
• Pịa na Excel cell
• Tapawa, iji “Ctrl + V” ma ọ bụ bọtịnụ òké aka nri wee họrọ Tapawa.

Otu esi eme ndepụta nke ndi nhazi

Ihe oyiyi nke egosiri na vidiyo ihe atụ, nke Geofumadas wuru, ọ na-enye gị ohere igbunye nhazi dị ka njirimara, nke mere na emesịa ha ga-eme ka okpokoro latitude na ogologoitude dị.

MapXL bụ n'efu, ịnwere ike ibudata ya na njikọ a. Ọzọkwa budata okpokoro Excel eji mee ihe atụ.

Zipu nhazi na map.

A na-eme nke a na akara ngosi “Ad markers”, ebe ahọpụtara mpaghara nke tebụl na-amasị. Mgbe ahụ, otu ụdị na-egosi nke na-egosi mpaghara bụ latitude, nke bụ Longitude, nkọwa nke nhazi na akara ngosi nke map ahụ. Iji wepụ ha, naanị ị ga-eme "Wepụ akara".

Download ebe a Map.XL, gụnyere ụdị Excel.

[ulp id='hIYBDKfRL58ddv8F']

Vidio a na-egosi usoro a kọwara na isiokwu a, jiri ihe atụ nke njem na ugwu mgbawa, na-eji Open Street Maps dị ka ndabere.

Hụ nchịkọta UTM na map si Excel:

ị nwere ike inweta template ebe a.