Cartografia-Google Earth / Amamephukokuqala

Faka imephu ku-Excel - thola izixhumanisi ezindawo - izixhumanisi ze-UTM

Imephu.XL uhlelo lokusebenza elikuvumela ukuba ufake ibalazwe ngaphakathi kwe-Excel bese uthola izixhumanisi ngqo kusuka ebalazweni. Ungabonisa futhi uhlu lwamaphuzu angama-latitudes nama-longitudes ebalazweni.

Indlela yokufaka imephu ku-Excel

Uma Uhlelo selufakiwe, lwengezwa njengethebhu eyengeziwe ebizwa ngokuthi “Imephu”, nokusebenza kwe-Map.XL.

Ngaphambi kokufaka imephu kufanele ulungiselele imephu engemuva, lokhu kwenziwa kusithonjana "somhlinzeki wemephu". Kungenzeka ukuthi ulungiselele ingemuva usebenzisa womabili amamephu, njengesithombe noma inhlanganisela evela kumasevisi:

  • I-Google Earth / Amamephu
  • Amamephu we-Bing
  • Vula i-Maps Street
  • ArcGIS
  • Yahoo
  • Ovi
  • Yandex

Imephu ibonakala ibambeke ngakwesokudla, kodwa ingahudulwa ukuze ifinyelele, noma phansi / phezulu kwetafula le-Excel.

Le vidiyo ifingqa ukuthi yonke inqubo echazwe kulesi sihloko yenziwe kanjani, isebenza emaceleni kwesakhiwo usebenzisa i-Bing Maps njengemuva.

[ulp id='hIYBDKfRL58ddv8F']

Indlela yokuthola izixhumanisi kusuka ku-Excel

Lokhu kwenziwa ngesithonjana esithi "Thola ukuhambisana". Inqubo ngokuyisisekelo:

  • Cindezela okuthi “Thola Ukuxhumana,
  • Chofoza kumephu,
  • Chofoza kuseli le-Excel
  • Namathisela, usebenzisa "Ctrl + V", noma inkinobho yegundane kwesokudla bese ukhetha Namathisela.

Indlela yokwenza uhlu lwabaxhumanisi

Isifanekiso esiboniswe kuvidiyo yesibonelo, sakhiwa yi-Geofumadas, futhi ikuvumela ukuba unamathisele izixhumanisi ngokusho kwesihlonzi, ukuze kamuva zivumelane netafula lebala lebala.

IMapXL imahhala, futhi ungayilanda kulesi sixhumanisi. Ithebula le-Excel elisetshenziswe kulesi sibonelo lizolandwa futhi.

Thumela izixhumanisi kumephu.

Lokhu kwenziwa ngesithonjana "somaka besikhangiso", ngemva kokukhetha indawo yethebula onentshisekelo kuyo. Bese kuvela ifomu elikhombisa ukuthi iyiphi inkambu eyi-latitude, okuyi-Longitude, imininingwane ye-coordinate kanye ne-symbogy yemephu. Ukuze uzisuse kuzomele wenze "Susa Omaka".

Layisha lapha Imephu.XL, kufaka phakathi ithempulethi ye-Excel.

[ulp id='hIYBDKfRL58ddv8F']

Le vidiyo ibonisa inqubo echazwe kulesi sihloko, isebenzisa njengesibonelo ukubonakaliswa kohambo ku-volcano, usebenzisa i-Open Street Maps njengemuva.

Bona i-UTM iqondisa kumephu kusuka ku-Excel:

Lokhu kusebenza okuboniswe ngenhla kukhombisa ukuxhumanisa kwendawo ukuthi kubukwe kumephu ku-Excel. Uma ufuna ukukhombisa kule mephu yokuxhumanisa ese-Universal Traverso Mercator (UTM), kuzofanele usebenzise ithempulethi enjengale. Isibonelo esiboniswe esithombeni nakuvidiyo senza lokho:

ungathola isifanekiso lapha.

Golgi Alvarez

Umbhali, umcwaningi, uchwepheshe wamamodeli wokuphathwa komhlaba. Ubambe iqhaza ekucabangeni nasekusetshenzisweni kwamamodeli afana nalawa: Isistimu Kazwelonke Yokulawulwa Kwezakhiwo i-SINAP e-Honduras, Imodeli Yokuphatha Yomasipala Abahlangene e-Honduras, Imodeli Edidiyelwe Yokuphathwa Kwe-Cadastre - Registry e-Nicaragua, Uhlelo Lokuphatha lwe-Territory SAT e-Colombia. . Umhleli webhulogi yolwazi lwe-Geofumadas kusukela ngo-2007 futhi umdali we-AulaGEO Academy ehlanganisa izifundo ezingaphezu kwe-100 ngezihloko ze-GIS - CAD - BIM - Digital Twins.

Izihloko ezihlobene Nalesi

9 Amazwana

  1. Sawubona, ingasebenza kahle ku-Excel Office 365? Angikwazi ukubona ithebhu yeMephu ngemva kokuyifaka.

    Gracias

  2. Sawubona, isixhumanisi sokulanda i-map.xl asisasebenzi.

  3. Sawubona mnumzane ekuseni.
    Ngilande ithempulethi kodwa ayikho isixhumanisi se-software ngokwayo.
    Ngicela usize.
    Mayelana

  4. Ngingayilanda kanjani i-map.xl yohlelo nge-template evelele

Deja un comentario

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

Buyela emuva kunkinobho phezulu