Export rondedzero yenzvimbo dzinogadziriswa kuGoogle Earth, kubva kuExcel, ine mufananidzo uye akapfuma mavara

Uyu muenzaniso wekuti Excel inogona sei kutumira zvemukati kuGoogle Earth. Mhosva ndeiyi:

Isu tine runyorwa rweanoratidzira mune ekumusoro geographic fomati (lat / lon). Tinoda kutumira kuGoogle Earth, uye isu tinoda ipapo kuratidza kodhi yechinongedzo chekufarira, chinyorwa chakashinga, chinyorwa chinotsanangudza, mufananidzo wepfungwa uye hyperlink kuitira kuti ivhure peji paInternet.

Pasi pane muenzaniso wezvatinotarisira kuratidza patinenge tichinyora pacho:

Iyo kodhi ndeye: XL-3458

The Length:

-103.377499

Latitude:

20.654443

Uye izvi ndizvo zvatinotarisira kuona:

Kunyange zvazvo template icharehwa, mweya wenyaya yacho inotsanangura kuti ungazviita sei iwe pachako.

Izvo isu zvatinogadzira kugadzira ma html tag mumakoramu akapatsanurwa kuti tikwanise concatenate

Central square
Imba yaVaJoaquín Gómez Padre, uko National University yakanga iripo uye iyo yakadzorerwa zvakare semuziyamu inodzivirirwa neNational Institute of Anthropology

<img src=”http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpg” width="144urefu = "168">

<a href="http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg">Ona peji paInternet

Zvese zvinyorwa izvo kuratidza kuti tambo yakasarudzika, kuvhara ne iyo yakaenzana neIpinda.

Ipapo iyo iri chitaera chinoratidza kuti chinyorwa ichi chiri chakashinga, hongu kuchichivhara ne

im isimboti yemufananidzo, iyo inotakura zvinhu zvakadai sehupamhi (upamhi), urefu (kureba) uye kutungamira apo chifananidzo chacho (src)

Chekupedzisira pane chinyorwa cheiyo hyperlink, iyo inotanga ne

Chii chinoiswa mupepuru chakagadzikana chinogona kuchinja nemufananidzo wega wega, saka tichave tichida kuti tisiye mumasero.

Pasina kudzoka zvakanyanya, unogona kuona ipapo kuti basa re concatenate rakapfupikiswa pane chimwe chinhu chakadai:

= CONCATENATE(,CELDA,,CELDA,,CELDA,<img src=”,CELDA,”hupamhi =”,CELDA,urefu = ",CELDA,"><a href=",CELDA,>>,CELDA,)

Izvi zvinoreva kuti isu tichagara makoramu masere ekuchengetedza rese data ratiri kuda kuratidza. Kunyangwe muchiitiko cheavo vane mavara anoshandisa iyo = chiratidzo uye zvakapetwa kaviri, zvinonetsa kwatiri nekuti muExcel yekutanga inoratidza basa uye yechipiri inoshandiswa kupatsanura zvemukati zvinyorwa. Izvi zvinogadziriswa nekuisa izvo zvirimo mumaseru akapatsanurwa sekunge iwo aive mavara.

Pakupedzisira tine izvi:

Uye kutumira kuGoogle Earth ndakaisa bhobho inogadzira faira.  Ikoko iwe unotsanangura nzira iyo faira iri uye zita raunotarisira kuva nerondedzero ye kml kana yakaratidzwa mujeri reboshwe.

Iyo template ine zvimwe zvekusimudzira pamusoro pemasero kuratidza kuti data rinofanira kuiswa sei. Kazhinji, zvinowanzoita kuve nedambudziko kana macro asina kubvumidzwa uye kana nzira iyo faira iri kugadzirwa isinganyoreke.

Ikoko tinezvo, unogona kutsvaga nekodhesi mubato reGoogle Pasi, uye kubatanidza pane iyo inoratidzwa sezvataitarisira.

Dharirai muenzaniso kml

Inoda mupiro wekufananidzira wekuburitsa, waunogona kuita nawo Paypal kana kadhi rechikwereti.

Icho chinomiririra kana mumwe achifunga nezvekubatsira kwaanoita uye nyore nyore kwaanogona kuwana.

Dzidza maitiro ekugadzira izvi nemamwe matemplate mu Excel-CAD-GIS kubiridzira.

Zvinetso zvakajairika

Zvinogona kuitika kuti, kana uchishandisa shanduro, chimwe chezviitiko zvinotevera zvinogona kuoneka:

Mhosva 75 - Faira nzira.

Izvi zvinoitika nokuti nzira iyo yakatsanangurwa apo iyo kml file inoponeswa haigoneki kana pasina zvibvumirano zvechiito ichi.

Sezvineiwo, iwe unofanirwa kuisa nzira pane diski D, iyo ine zvirambidzo zvishoma pane dhisiki C inowanzove iri.

D: \

Iyo pfungwa dziri kubuda kuNorth Pole.

Izvi zvinowanzoitika, nokuti mumahwindo edu, sezvinoratidzwa mumirayiridzo ye template kuti ishande, sarudzo yezvemuganhu inofanira kusimbiswa munharaunda yedunhu:

• -Paint, nokuda kwekuparadzanisa
• -Coma, kune zviuru zveparadziri
• -Coma, nokuda kwekuparadzanisa mazita

Saka, data yakadai se: Chiuru chimwe nemazana manomwe nemakumi masere mamita ane masendimita gumi nemaviri anofanira kuonekwa sa 1,780.12

Mufananidzo wacho unoratidza kuti uku kugadzirisa kwaitwa sei.

Ichi chimwe chifananidzo chinoratidzira kusarudzwa mumutsetse wekutonga.

Kamwe kana shanduko ichiitwa, faira yacho inogadzirwa zvakare uye ipapo, pfungwa dzichaonekwa apo dzinofananidzwa neGoogle Earth.

Kana iwe uine mubvunzo, nyora kune rutsigiro email editor@geofumadas.com. Iyo inogara ichiratidza iyo vhezheni yemahwindo auri kushandisa.