Tso daim ntawv qhia hauv Excel - tau txais thaj tsam me - UTM khiav haujlwm

Map.XL yog ib daim ntawv thov uas tso cai rau koj nkag mus rau hauv daim ntawv qhia hauv Excel thiab nkag ncaj qha los ntawm daim qhia kev. Koj tuaj yeem tso saib cov npe ntawm latitudes thiab longitudes rau hauv daim qhia kev.

Yuav ua li cas rau hauv daim ntawv qhia hauv Excel

Thaum qhov kev zov me nyuam tiav lawm, nws ntxiv rau ib qho tab hu ua "Map", nrog cov nta ntawm Map.XL.

Ua ntej tso rau hauv daim ntawv qhia koj yuav tsum teeb tsa cov ntawv qhia keeb kwm yav dhau los, qhov no tau ua hauv "Map map" icon. Nws yog qhov tsim nyog los tsim tom qab siv ob daim duab qhia chaw, duab lossis hybrid los ntawm kev pabcuam:

  • Google Lub Ntiaj Teb / Maps
  • Bing Maps
  • Qhib Txoj Kev Maps
  • ArcGIS
  • Yahoo
  • Ovi
  • Yandex

Daim ntawv qhia no tau pom zoo rau sab xis, tab sis nws muaj peev xwm yuav luag ua kom nws yog floating, los yog hauv qab / saum lub rooj Excel.

Daim duab no qhia txog tias txoj kev txheej txheem piav qhia nyob rau hauv tsab xov xwm no yog ua tiav, ua haujlwm rau lub voj voog siv Bing Maps raws li keeb kwm yav dhau.

Yuav ua li cas thiaj nrhiav tau haujlwm los ntawm Excel

Qhov no ua tiav nrog lub "Get coord" icon. Cov txheej txheem no tsuas yog:

  • Xovxwm «Tau Coord,
  • Nyem ntawm daim ntawv qhia,
  • Nias rau ntawm Excel ntawm tes
  • Muab tshuaj txhuam, siv "Ctrl + V", los yog txoj cai nas khawm thiab xaiv Paste.

Yuav ua li cas thiaj ua tau ib daim ntawv teev cov Coordinates

Cov template muaj nyob rau hauv qhov piv txwv video, yog ua los ntawm Geofumadas, thiab nws tso cai rau koj mus paste lub coordinates raws li ib tug identifier, yog li ntawd tom qab lawv yuav haum rau ib lub latitude thiab longitude rooj.

MapXL yog dawb, thiab koj tuaj yeem rub tawm nws los ntawm qhov txuas no. Kuj tseem rub tawm Excel lub rooj uas siv hauv qhov piv txwv.

Xa cov khab rau daim pheem thib.

Qhov no tau ua nrog "ad npiv npav" icon, tau xaiv thaj chaw ntawm lub rooj uas koj nyiam. Tom qab ntawd ib daim ntawv tshwm los qhia tias daim teb twg yog lub ntev ntev, uas yog Lub Ntev Ntev, nthuav dav ntawm qhov ua kom sib haum thiab cov duab cim hauv daim ntawv qhia. Txhawm rau tshem tawm lawv koj tsuas yog yuav tsum ua "Tshem Tawm Cov Cim".

Download ntawm no Map.XL, nrog rau cov Excel template.

Cov yees duab no qhia txog cov txheej txheem tau piav qhia nyob rau hauv tsab xov xwm no, siv piv txwv qhia txog kev ncig ntawm lub roob hluav taws, siv Open Maps Maps raws li keeb kwm yav dhau los.

Saib UTM ua haujlwm hauv daim ntawv qhia los ntawm Excel:

Cov haujlwm no tau qhia saum toj no qhia tau hais tias thaj chaw ib ncig yuav tsum tau saib ntawm daim duab qhia hauv Excel. Yog tias koj xav ua kom pom cov kev koom tes uas muaj nyob hauv Universal Traverso Mercator (UTM) ntawm daim duab qhia chaw no, koj yuav tsum tau siv tus qauv zoo li no. Piv txwv li hauv daim duab thiab video ua li ntawd:

koj tuaj yeem tau txais daim qauv ntawm no.

9 Replies rau "Ntxig daim ntawv qhia hauv Excel - tau txais kev tswj hwm thaj chaw - UTM coordinates"

  1. Puas muaj ib txoj hauv kev los Tshawb Npe lossis Chaw Nyob ??

  2. Nyob zoo, nws puas ua haujlwm rau Excel Office 365? Kuv tuaj yeem tsis pom daim ntawv qhia tom qab kev txhim kho nws.

    Tsaug

  3. Nyob zoo, qhov txuas mus download map.xl tseem tsis yog tshuab txais.

  4. Nyob zoo sawv ntxov.
    Kuv downloaded template, tiam sis tsis muaj qhov txuas rau qhov software nws tus kheej.
    Thov tuaj yeem pab koj.
    regards

Sau ntawv cia

Koj email chaw nyob yuav tsis tsum luam tawm.

Qhov Web site no siv Akismet los txo cov kev pabcuam. Kawm li cas koj cov ntaub ntawv tawm tswv yim tiav.