CartographyGoogle pasi / mamapukuororwa

Isa mepu muExcel - tora geographic coordinates - UTM zvinongedzo

Mepu.XL inoshandiswa iyo inokubvumira kuti uise mapeji mukati meExcel uye uwane hurumende zvakananga kubva pamepu. Iwe unogonawo kuratidza urongwa hwemaitiro uye urefu hwemapupi pamepu.

Nzira yekuisa sei imepu muExcel

Kana Chirongwa chaiswa, chinowedzerwa seimwe tebhu inonzi "Mepu", ine mashandiro eMepu.XL.

Usati waisa mepu unofanirwa kugadzirisa mepu yekumashure, izvi zvinoitwa mu "Mepu inopa" icon. Zvinogoneka kugadzirisa kumashure uchishandisa ese mepu, semufananidzo kana hybrid kubva kumasevhisi:

  • Google Earth / Maps
  • Bing Maps
  • Vhura Maps Maps
  • ArcGIS
  • Yahoo
  • Ovi
  • Yandex

Mepu inooneka yakatungirwa kurudyi, asi inogona kukweverwa kuitira kuti iite, kana pasi / kumusoro kwetafura ye Excel.

Iyi vhidhiyo inopfupikisa kuti iyo nzira yose yakatsanangurwa sei munyaya ino yaitwa, yakashanda pamiromo yebindu uchishandisa Bing Maps semamiriro ezvinhu.

[ulp id='hIYBDKfRL58ddv8F']

Mawaniro ekuwana zvikwangwani kubva kune Excel

Izvi zvinoitwa ne "Get coord" icon. Nzira yacho ndeye:

  • Dzvanya "Get Coord,
  • Dzvanya pamapu,
  • Dzvanya paIndel cell
  • Namira, uchishandisa "Ctrl + V", kana bhatani rekurudyi rembeva uye kusarudza Namira.

Nzira yekuita urongwa hweCorodates

Chiratidziro chinoratidzwa mumuenzaniso wevhidhiyo, chakavakwa neGeofumadas, uye inokubvumira kubatanidza nhaurirano maererano nechiratidzo, kuitira kuti mushure mokunge vaenzane nehupamhi nechetende.

MapXL ndeye mahara, uye iwe unogona kuitora kubva pane iyi link. Iwe zvakare uchatora pasi tafura yeExcel yakashandiswa mumuenzaniso

Tumira nhaurirano kumapu.

Izvi zvinoitwa ne "Ad marker" icon, wasarudza nzvimbo yetafura inofarira. Zvino panobva paonekwa fomu rinoratidza kuti ndeupi munda uri latitude, inova Lengitude, ruzivo rwekurongeka uye chiratidzo chemepu. Kuti uzvibvise iwe unongofanira kuita "Bvisa Makoni".

Tora pano Mepu.XL, kusanganisira Excel template.

[ulp id='hIYBDKfRL58ddv8F']

Iyi vhidhiyo inoratidza nzira yakatsanangurwa munyaya ino, uchishandisa sechiratidzo kuratidzwa kwechikepe pane gomo, uchishandisa Open Street Maps semushure.

Ona UTM inogadzirisa pamapu kubva kune Excel:

Aya mashandiro akaratidzirwa pamusoro anoratidza nzvimbo dzinoonekwa kuti dzionekwe kubva mumepu muExcel. Kana iwe uchida kuratidza pane ino mepu mapuratifomu ari muUniversal Traverso Mercator (UTM), uchafanirwa kushandisa template yakaita seiyi. Muenzaniso unoratidzwa mumufananidzo nevhidhiyo unoita izvozvo:

iwe unogona kuwana template pano.

Golgi Alvarez

Munyori, muongorori, nyanzvi muLand Management Models. Akatora chikamu mukugadzirisa uye kushandiswa kwemhando dzakadai se: National System of Property Administration SINAP muHonduras, Model of Management ye Joint Municipalities muHonduras, Integrated Model yeCadastre Management - Registry muNicaragua, System of Administration yeTerritory SAT muColombia. . Mupepeti weiyo Geofumadas ruzivo blog kubvira 2007 uye mugadziri weAulaGEO Academy iyo inosanganisira anopfuura zana makosi paGIS - CAD - BIM - Digital Twins misoro.

Related Articles

9 Comments

  1. Pane nzira yekutsvaga neZita kana Kero ??

  2. Shamwari, inoshanda here nenzira yakakodzera kune Excel Office 365? Handikwanisi kuona Mapeti tab kana ndaiisa.

    gracias

  3. Sawa, chibvumirano chekutsvaga map.xl hachisati chagadzirirwa.

  4. Sawa sir akanaka mangwanani.
    Ndakatora template asi hapana chibvumirano che software chaiyo.
    Ndokumbirawo iwe unogona kubatsira.
    pezvinhu

  5. Ndingakwanisa sei kuunganidza purogiramu map.xl nekunakisisa template

Leave mhinduro

Your kero e havazobvumirwi ichibudiswa. Raida minda anozivikanwa ne *

Kudzoka kumusoro