Thumela uhlu lwezixhumanisi ezindawo ku-Google Earth, kusuka ku-Excel, ngomfanekiso nombhalo ocebile
Lesi yisibonelo sendlela i-Excel engakuthumela ngayo okuqukethwe ku-Google Earth. Icala yileli:
Sinohlu lwezixhumanisi ngefomethi yedesimali yendawo (lat / lon). Sifuna ukuthumela kuGoogle Earth, futhi sifuna ukuthi ikhombise ikhodi yephuzu lesithakazelo, umbhalo obhalwe ngokugqamile, umbhalo ochazayo, isithombe sephuzu kanye ne-hyperlink ukuvula ikhasi ku-Intanethi.
Ngaphansi kwalesi sibonelo salokho esikuthemba ukukubonisa uma siqhafaza iphuzu:
Ikhodi ithi: XL-3458
Ubude:
-103.377499
Latitude:
20.654443
Futhi yilokho esithemba ukukubona:
I-XL-3458 Isikwele esiphakathi Indlu kaMnu. Joaquín Gómez Padre, lapho kuqala khona iNational University futhi manje ibuyiselwe njengemyuziyamu evikelwe yiNational Institute of Anthropology |
Nakuba ithempulethi izolayishwa, umoya we-athikili ukuchaza ukuthi ungayenza kanjani wena wedwa.
Esikusebenzayo ukwakha amathegi we-html kumakholomu ahlukile ukuze akwazi ukuvumelana: Ikhodi yalokhu kuzoba:
Isikwele esiphakathi
Indlu kaMnu. Joaquín Gómez Padre, lapho kuqala khona iNational University futhi manje ibuyiselwe njengemyuziyamu evikelwe yiNational Institute of Anthropology
<img src=”http://upload.wikimedia.org/wikipedia/commons/thumb/3/3c/Casas_actiopan.jpg/800px-Casas_actiopan.jpg”ububanzi="144”ubude=”168">
<a href="http://commons.wikimedia.org/wiki/File:Casas_actiopan.jpg">Bheka ikhasi kwi-intanethi
Wonke amalebula lokho ukukhombisa ukuthi ulayini ohlukile, uvala ngo okulingana ne-Enter.
Ngemuva kwalokho, ilebula ekhombisa ukuthi lo mbhalo ubhalwe ngokugqamile, yebo ukuwuvala ngo
im ibulabula lesithombe, esingaphakathi sinezakhiwo ezifana nobubanzi (ububanzi), ukuphakama (ukuphakama) nesiqondiso lapho isithombe (src)
Ekugcineni kukhona ilebula le-hyperlink, evula nge-
Okumakwe ngombala obomvu kungokwokuqukethwe okungashintsha ngesithombe ngasinye, ngakho-ke sizoba nesithakazelo bese sisishiya emasethini.
Ngaphandle kokubuya okukhulu, ungabona ukuthi umsebenzi we-concatenate uzofingqwa kulokhu okufana nalokhu:
= QAPHELA(,CELDA,,CELDA,,CELDA,<img src=",CELDA,”ububanzi=",CELDA,”ubude=”,CELDA,"><a href=",CELDA,>>,CELDA,)
Okusho ukuthi, sizohlala kumakholomu ayi-8 ukugcina yonke idatha esifuna ukuyikhombisa. Noma esimweni salabo abanamalebula asebenzisa uphawu = nezingcaphuno eziphindwe kabili, kuyinkimbinkimbi kithina ngoba ku-Excel owokuqala ukhombisa umsebenzi bese owesibili usetshenziselwa ukuhlukanisa okuqukethwe kombhalo. Lokhu kuxazululwa ngokufaka lokho okuqukethwe kumaseli ahlukene sengathi kungumbhalo.
Okokugcina sinakho lokhu:
Futhi ukuthumela ku-Google Earth ngifake inkinobho edala ifayela. Lapho uveza indlela lapho ifayela likhona negama olilindele ukuba libe nencazelo ye-kml uma kuboniswa iphaneli lesokunxele.
Isifanekiso sinamagundane ngaphezulu kokunyakaziswa kweseli ukuphakamisa ukuthi idatha kufanele ifakwe kanjani. Ngokuvamile, kujwayele ukuba nenkinga lapho ama-macros enganikiwe amandla futhi lapho indlela okwakhiwa ngayo ifayili ingabhalwa.
Lapho sinawo, ungenza usesho ngekhodi ku-sidebar ye-Google Earth, futhi ukuchofoza iphuzu kuboniswa njengoba sasilindele.
Landa isibonelo kml
Kudinga umnikelo ongokomfanekiso wokulanda, ongakwenza ngawo I-paypal noma ikhadi lesikweletu.
Kuyinto engokomfanekiso uma umuntu ecabanga ukuthi isevisi iyinikeza futhi kulula kangakanani ukuthi itholakale.
Funda ukuthi ungenza kanjani lezi ezinye izifanekiso ku Inkambo yokukopela ye-Excel-CAD-GIS.
Izinkinga ezivamile
Kungenzeka ukuthi, uma usebenzisa uhlelo lokusebenza, esinye sezigameko ezilandelayo singavela:
Iphutha le-75 - Indlela yefayela.
Lokhu kwenzeka ngoba indlela echazwe ukuthi ifayela le-kml izosindiswa ayitholakali noma ayikho izimvume zalesi senzo.
Ngokufanelekile, kufanele ubeke indlela kudiski D, enemikhawulo embalwa kune-disk C. Isibonelo:
D: \
Amaphuzu aphuma eNorth Pole.
Lokhu kuvame ukukwenzeka, ngoba emafasiteleni ethu, njengoba kuboniswe emfundisweni yesifanekiso ukusebenza, ukumiswa kwesifunda kufanele kusungulwe iphaneli yesifunda:
- -Point, for separator decimals
- -Coma, for separator izinkulungwane
- -Coma, ngokuhlukanisa uhlu
Ngakho, idatha efana: Amamitha ayizinkulungwane eziyisikhombisa namakhulu ayisishiyagalombili namashumi ayisishiyagalombili namasentimitha ayishumi nambili kufanele abonakale njenge-1,780.12
Isithombe sibonisa ukuthi lokhu kulungiselelwa kwenziwa kanjani.
Lesi esinye isithombe esibonisa ukucushwa kwipaneli yokulawula.
Uma ushintsho lwenziwa, ifayela lenziwa futhi futhi, amaphuzu azovela lapho ahambisana khona ku-Google Earth.
Uma unombuzo, bhalela i-imeyili yokusekela editor@geofumadas.com. Ihlala ikhombisa inguqulo yamawindi oyisebenzisayo.
Sengivele ngiyilandile ithempulethi, ngizoyifunda futhi ngizobhala noma yimiphi imibuzo noma ukulungiswa. Ngiyabonga g '
Sawubona, uJoseph Luis.
Sesilungisile isixhumanisi.
Phendula ngokucaphuna
Angiboni isixhumanisi sokukhokha ngokudluliswa kwebhange. Ngivela e-El Salvador. Ngiyabonga
Ngangifuna ukuthenga ithempulethi kodwa anginayo ikhadi elifana nami
Hlola, uqinisekile ukuthi ubeka inkinobho yokubuyela emuva. Lesi yisibonelo:
D: obrasalc
Landa ifayela le-Excel, futhi nginenkinga yokulayisha izithombe kusuka ku-Disk D: / obras / alc yami, ngicela ungithumele incazelo njengoba ngingakwazi ukulayisha izithombe kusuka kulelo kheli.
Ingabe kuyadingeka ukuthi lezi zithombe zibe nosayizi othize? noma ungasebenzisa izithombe ze-4 mb
Yebo, Yebo ungathola imigwaqo yendawo kwikhompyutha noma kwinethiwekhi
kulinganiselwa ukuthi kungenzeka ukuthi ufunde izithombe ezigcinwe endaweni yePP noma usebenzisa izinkinobho zenethiwekhi. Ngiyabonga
Ingabe lolu hlelo lokusebenza lungakwazi ukufunda izithombe zasendaweni ezilondoloziwe ngaphandle kokusebenzisa i-URL?
Sawubona mina wangithakazelisa conprar plantillas.soy lwakho Peru, kodwa nalapho nginikeza isixhumanisi akhawunti tranferencia yasebhange ungangishiyi nada.como edlule depositarte imali
Siyazisola ngesigameko, kodwa sesiyilungisile futhi uhlelo lokukhokha selivele lunikeziwe.
Ukubingelela
Ngingathanda ukukhokhela izithombo eziningi ezilapha futhi angikwazi
Yebo.
I-macro ayinayo ikhi yokuvikela, ngakho ingashintshwa.
Ukulanda kuhlanganisa ukukwazi ukuguqula ifayela lomthombo noma i-macro eyinhloko yohlelo ngokuhamba phambili.
Akusikho ukwehluleka kwedatha, ukuthi isithombe se-Google sishiyiwe
Ngempela, i-datum enginakho ku-Google Earth yi-WGS84.
Uthole isizathu sokuhluleka ngedatha yami?
Bathumele eposini ukuze babone. Ngithumelele itafula ku-Excel nefayela le-kml elikhiqizayo. editor@geofumadas.com
Hlola ukuthi usebenzisa i-Datum efanele, i-Google Earth isebenzisa i-UTM WGS84.
Siyabonga ngesivinini kwisixazululo esisebenzile. Kodwa-ke, lapho ngisebenzisa ifayela elithi "kml" nge-Google Earth, cishe awekho amaphuzu okuxhumanisa avelayo futhi ambalwa kuphela abonakalayo, cishe njalo elokuqala nelokugcina ochungechungeni, kodwa kude kakhulu nalokho okuhambisanayo (1 Kms. pe ) . Ngibhorekile ngokwenza izivivinyo kanti lutho. Ngingakuthumela ifayela elinedatha elayishiwe kwenye i-imeyili? Ngakho uzobona ukuthi kwenzekani. Ngiyabonga,
Lona inkinga eyaziwa, njengoba kubhaliwe ngenhla.
Shintsha umzila, ufaka ifayela ngqo ku-C: futhi lokho kuvame ukuvunyelwa ukucushwa kwe-Windows. Sebenzisa omunye umzila futhi uqinisekise ukuthi ukhona.
Lolu hlelo lubonakala lukhulu kimi futhi luye lwandibiza kakhulu ukuze ngiluthole.
Ngithole ngokumelene nokukhokha kwe-$ 2 kodwa kuthiwa uma ngiyikhipha ayisebenzi futhi isixwayiso siphume sithi:
“Kuvele iphutha lesikhathi esingu-'75'.
Indlela noma iphutha lokufinyelela ifayela”
Ngingabonga uma ungakwazi ungitshele kanjani ukukulungisa noma uma uthumela kimi elinye ifayela Excel, ngokushesha ngangokunokwenzeka, ngoba nginomhlatshelo ukulungiselela umsebenzi lokumelela amaphuzu yendawo mina ngempela ngasekupheleni.
Ukulawula,
Kuxhomeke ekuhambeni.
Uma dengwane a amamitha ambalwa (10 15 meters) yingoba isithombe kugudlukela google, ungabona ekushintsheni isithombe eminyakeni eyedlule ubone ukuthi georeference pretty ezimbi. Nakuba ukuxhumanisa kulungile.
Uma ukufuduka kukhulu, kungenzeka ukuthi yizixhumanisi zenye i-Datum. I-Google isebenzisa i-WGS84.
Uma izixhumanisi ziwela kwenye indawo yeplanethi, kungenzeka ukuthi uyangena ngaphansi kwezinga nobude. Noma awusebenzisi isibonakaliso: Endaweni yasentshonalanga ubude abubi, eningizimu yaseningizimu i-latitude ayibi.
Umnikelo omuhle kakhulu kuphela owaziyo ukuthi lapho ngifaka izixhumanisi zami awungikhombisi ngqo ukuthi ukuphi ... ucabanga ukuthi kuzoba yini?