Faka imephu kwi-Excel-fumana i-coordinated geographical-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

Emva kokuba iProgram ifakiwe, yongezwa njengetye eyongezelelweyo ebizwa ngokuthi "Imephu", kunye neempawu zeMaphu.XL.

Ngaphambi kokufaka imephu kufuneka uqulunqe imephu yangemva, oku kwenziwa kwi "icon yomhlinzeki" icon. Kuyakwazi ukuqwalasela imvelaphi usebenzisa zombini iimephu, umfanekiso okanye hybrid 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.

Indlela yokufumana iinqununu ukusuka kwi-Excel

Oku kwenziwa nge-"Get coord" icon. Inkqubo ngokusisiseko:

  • Cinezela i- "Thola Coord,
  • Cofa kwimephu,
  • Cofa kwi-cell ye-Excel
  • Namathisela, usebenzisa i- "Ctrl + V", okanye iqhosha le mouse kwaye ukhetha Namathisela.

Indlela yokwenza uluhlu lweeNkonzo

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

I-MapXL ikhululekile, kwaye unokuyikhuphela kwikhonkco. Iyakulanda kwakhona i-Excel itafile esetyenziswe kumzekelo.

Thumela izilungiso kwimephu.

Oku kwenziwa nge icon «Iimpawu zamanqaku», ukhethe indawo yetafile yentshisekelo. Emva koko ifom ebonakalayo ibonisa ukuba yeyiphi insimu i-latitude, eyiyo Ubude, iinkcukacha kunye kunye nesimboli yemephu. Ukuze ususe kubo kufuneka uyenze "Susa amanqaku".

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

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:

Lo msebenzi uboniswe ngasentla ubonisa ukulungelelaniswa kweendawo eziza kuboniswa kwimephu kwi-Excel. Ukuba okufunayo kukubonisa kule migaqo yokulungelelanisa e-Universal Traverso Mercator (UTM), kuya kufuneka usebenzise itemplate efana nale. Umzekelo oboniswe kumfanekiso nakwividiyo uyakwenza oko:

unokufumana itemplate apha.

Iimpendulo ze-8 "Faka imephu kwi-Excel - fumana i-coordinated geographical-UTM idibanisa"

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

    Gracias

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

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

  4. 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.