Ntxiv
CartografiaGoogle ntiaj teb / Mapsthawj tswv yim

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 Pabcuam raug teeb tsa, nws tau ntxiv los ua ib qho ntxiv hu ua "Daim Ntawv Qhia", nrog rau kev ua haujlwm ntawm Map.XL.

Ua ntej tso daim duab qhia chaw koj yuav tsum teeb tsa daim ntawv qhia keeb kwm yav dhau, qhov no ua tiav hauv "Pib pab cuam" icon. Nws tuaj yeem teeb tsa keeb kwm yav dhau los siv ob daim duab qhia chaw, ua duab lossis hybrid los ntawm cov 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.

[ulp id='hIYBDKfRL58ddv8F']

Yuav ua li cas thiaj nrhiav tau haujlwm los ntawm Excel

Qhov no yog ua tiav nrog "Get coord" icon. Cov txheej txheem yog qhov yooj yim:

  • Nyem "Get Coord,
  • Nyem ntawm daim ntawv qhia,
  • Nias rau ntawm Excel ntawm tes
  • Muab tshuaj txhuam, siv "Ctrl + V", lossis tus nas khawm sab xis 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 yog ua tiav nrog "Ad markers" icon, muaj thaj tsam ntawm lub rooj txaus siab xaiv. Tom qab ntawd ib daim ntawv zoo nkaus li qhia tias thaj chaw twg yog qhov latitude, uas yog Longitude, nthuav dav ntawm kev tswj xyuas thiab cov cim ntawm 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.

[ulp id='hIYBDKfRL58ddv8F']

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.

Golgi Alvarez

Tus kws sau ntawv, kws tshawb fawb, tus kws tshaj lij hauv Kev Tswj Xyuas Cov Qauv. Nws tau koom nrog hauv kev xav thiab kev siv cov qauv xws li: National System of Property Administration SINAP hauv Honduras, Qauv ntawm Kev Tswj Xyuas Kev Sib Koom Tes Hauv Honduras, Kev Sib Koom Ua Qauv ntawm Cadastre Management - Registry hauv Nicaragua, Kev Tswj Xyuas Kev Tswj Xyuas Thaj Chaw SAT hauv Colombia . Editor ntawm Geofumadas kev paub blog txij li xyoo 2007 thiab tus tsim ntawm AulaAGEO Academy uas suav nrog ntau dua 100 cov kev kawm ntawm GIS - CAD - BIM - Digital Twins cov ncauj lus.

lwm yam khoom

9 Comments

  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 pab tau.
    regards

Deja un comentario

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.

Rov qab mus rau sab saum toj