Yongeza
IiphotographyGoogle umhlaba / imephuUkuprinta kokuqala

Faka imephu kwi-Excel-fumana ulungelelwaniso lwejografi- ulungelelwaniso lwe-UTM

Imephu.XL yisicelo esikuvumela ukuba ufake imephu ngaphakathi kwe-Excel uze ufumane izilungiso ngqo kwimaphu. Unokubonisa kwakhona uludwe lwezakhono zokuhamba kunye neendlongo ezinde kwimaphu.

Indlela yokufaka imephu kwi-Excel

Nje ukuba iNkqubo ifakwe, yongezwa njengethebhu eyongezelelweyo ebizwa ngokuthi "Imephu", kunye nokusebenza kweMaphu.XL.

Phambi kokufaka imephu kufuneka uqwalasele imephu yangasemva, oku kwenziwa kwi-icon "yomniki-maphu". Kuyenzeka ukuba uqwalasele imvelaphi usebenzisa zombini iimephu, njengomfanekiso okanye umxube osuka kwiinkonzo:

  • Google Earth / Maps
  • Iimephu zeBing
  • Vula i-Street Street
  • ArcGIS
  • Yahoo
  • Ovi
  • Yandex

Imephu ibonakala ikhonjiswe ngakwesokudla, kodwa inokudityaniswa ukuze ithambile, okanye kwizantsi / phezulu kwetafile ye-Excel.

Le vidiyo ifingqa indlela yonke inkqubo echazwe ngayo kweli nqaku yenziwe, isebenze kwimigca yesalathiso esebenzisa iMaphu yeBing njengemvelaphi.

[ulp id='hIYBDKfRL58ddv8F']

Indlela yokufumana iinqununu ukusuka kwi-Excel

Oku kwenziwa ngophawu "Fumana ulungelelwano". Inkqubo ngokusisiseko:

  • Cinezela “Thola iNdibaniselwano,
  • Cofa kwimephu,
  • Cofa kwi-cell ye-Excel
  • Cola, usebenzisa "Ctrl + V", okanye iqhosha lemouse lasekunene kwaye ukhethe Cola.

Indlela yokwenza uluhlu lweeNkonzo

Ithempleyithi uboniswe kumzekelo video, wakhiwe yi egeomates, kwaye ikuvumela Ndahamba unamathela zilungelelanise ngokwelo njengomqwalaseli, ukuba uya zingqinelane itafile nobude.

IMapXL isimahla, kwaye ungayikhuphela kule khonkco. Itheyibhile ye-Excel esetyenziswe kumzekelo nayo iya kukhutshelwa.

Thumela izilungiso kwimephu.

Oku kwenziwa ngophawu lwe "Ad markers", emva kokukhetha indawo yetafile enomdla. Emva koko kuvela ifom ebonisa ukuba yeyiphi indawo yesibanzi, eyi-Latitude, inkcukacha yolungelelwaniso kunye nesimboli semephu. Ukuzisusa kufuneka wenze nje "Susa amaphawu".

Landa apha kwiMaphu.XL, kuquka i template ye-Excel.

[ulp id='hIYBDKfRL58ddv8F']

Le vidiyo ibonisa inkqubo echazwe kweli nqaku, usebenzisa umzekelo wokubonakalisa ityelelo kwi-volcano, usebenzisa i-Open Street Maps njengemvelaphi.

Bona i-UTM idibanisa kwimephu esuka kwi-Excel:

Ukusebenza okuboniswe apha ngasentla kubonisa ukuba ulungelelwaniso lwejografi luza kujongwa kwimephu ekwi-Excel. Ukuba ufuna ukubonisa kule mephu ilungelelanisa kwi-Universal Traverso Mercator (UTM), kuya kufuneka usebenzise itemplate enje ngale. Umzekelo oboniswe kumfanekiso nakwividiyo uyakwenza oko:

unokufumana itemplate apha.

Golgi Alvarez

Umbhali, umphandi, ingcali kwiiModeli zoLawulo loMhlaba. Uthathe inxaxheba ekucingeni nasekuphunyezweni kweemodeli ezifana ne: INkqubo yeSizwe yoLawulo lwePropati SINAP eHonduras, iModeli yoLawulo loMasipala abaManyeneyo eHonduras, iModeli eDityanisiweyo yoLawulo lweCadastre - iRegistry eNicaragua, iNkqubo yoLawulo lweTerritory SAT eColombia. . Umhleli weblogi yolwazi lwe-Geofumadas ukususela kwi-2007 kunye nomdali we-AulaGEO Academy equka izifundo ezingaphezu kwe-100 kwi-GIS - CAD - BIM - Digital Twins izihloko.

Amanqaku Afana

9 Comments

  1. Ngaba ikhona indlela yokuKhangela ngegama okanye idilesi?

  2. Sawubona, usebenza ngokufanelekileyo kwi-Excel Office 365? Andikwazi ukubona iTebhu ithebhu emva kokuyifaka.

    Gracias

  3. Sawubona, isiqhagamshelo sokukhuphela i-map.xl asisasebenza.

  4. Sawubona mnumzane kakuhle ekuseni.
    Ndalanda i template kodwa akukho nxu lumene nesofthiwe ngokwayo.
    Nceda uncede.
    Ngobuliso

  5. Ndingayilanda njani iprogram ye-map.xl nge template evelele

Shiya amazwana

Idilesi yakho ye email aziyi kupapashwa.

Le sayithi isebenzisa i-Akismet ukunciphisa ugaxekile. Funda indlela idatha yakho yokubhaliweyo isetyenziswe ngayo.

Buyela phezulu kwiqhosha