Ukubonakala kwe-geodata kumephu

Uma inkampani yakho inamagatsha ezweni lonke noma ithengisa hhayi kuphela ku-Moscow Ring Road, khona-ke ngokushesha noma kamuva uzobhekana nomsebenzi wokubonisa ngokubonakalayo idatha yezinombolo evela ku-Microsoft Excel (ukuthengisa, izinhlelo zokusebenza, amavolumu, amakhasimende) kumephu yendawo. ngokubhekiselwe kumadolobha athile nezifunda. Ake sibheke ngokushesha izindlela eziyinhloko zokubona ngeso lengqondo i-geodata ekhona ku-Excel.

Indlela 1: Iyashesha futhi Yamahhala - Ingxenye Yamamephu e-Bing

Kusukela enguqulweni ka-2013, i-Excel inesitolo sezinhlelo zokusebenza esakhelwe ngaphakathi, okusho ukuthi kube nokwenzeka ukuthenga, ukulanda nokufaka amamojula engeziwe kanye nezengezo ezinemisebenzi engekho. Enye yalezi zingxenye ikuvumela ukuthi ubonise ngeso lengqondo idatha yezinombolo kumephu - ibizwa nge-Bing Maps futhi, okuhle kakhulu, imahhala ngokuphelele. Ukuze uyifake, vula ithebhu Faka - Isitolo (Faka - Izinhlelo zokusebenza zehhovisi):

Ngemva kokufaka ingxenye, isiqukathi esiguqukayo esinemephu kufanele sivele eshidini. Ukuze ubone ngeso lengqondo ulwazi lwakho kumephu, udinga ukukhetha ububanzi obune-geodata bese ucindezela inkinobho Bonisa Izindawo:

Uma kudingeka, kuzilungiselelo (isithonjana segiya ekhoneni eliphezulu kwesokudla sengxenye), ungashintsha imibala nohlobo lwamashadi abonisiwe:

Kungenzeka futhi ukuhlunga amadolobha ngokushesha, ubonise kuphela lawo owadingayo (isithonjana sefaneli ekhoneni eliphezulu kwesokudla sengxenye).

Ungakwazi ukubopha kalula hhayi emadolobheni kuphela, kodwa nakwezinye izinto: izifunda (isibonelo, Isifunda saseTula), izifunda ezizimele (isibonelo, Yamalo-Nenets) namaRiphabhulikhi (Tatarstan) - khona-ke indingilizi yomdwebo izovezwa phakathi nendawo. Into esemqoka ukuthi igama elikuthebula lihambisana namagama-ncazo kumephu.

Inani phakathi pluses yale ndlela: ukuqaliswa kwamahhala okulula, ukubophezela okuzenzakalelayo kumephu, izinhlobo ezimbili zamashadi, ukuhlunga okulula.

В nebubi: udinga i-Excel 2013 enokufinyelela ku-inthanethi, awukwazi ukukhetha izifunda nezifunda.

Indlela yesi-2: Iyaguquguquka futhi Yinhle - Ukubuka Kwemephu Embikweni Wokubuka Amandla

Ezinye izinguqulo ze-Microsoft Excel 2013 ziza nesengezo esinamandla sokubonwayo sombiko esibizwa nge-Power View evumela (phakathi kwezinye izinto, futhi singenza okuningi!) Bonisa idatha kumephu. Ukuze uvule isengezo, vula ithebhu Unjiniyela (Unjiniyela) bese uchofoza inkinobho Izengezo ze-COM (Izengezo ze-COM). Ewindini elivulayo, khetha ibhokisi eliseduze kokuthi Ukubuka Amandla bese uchofoza okuthi KULUNGILE. Ngemuva kwakho konke lokhu kukhohlisa kuthebhu Faka (Faka) kufanele ube nenkinobho ukubuka kwamandla. 

Manje usungakwazi ukukhetha ububanzi ngedatha yomthombo, chofoza le nkinobho - ishidi elisha lizokwakhiwa encwadini yakho (njengesilayidi esivela ku-Power Point), lapho idatha ekhethiwe izovezwa ngendlela yetafula:

Ungakwazi kalula ukuguqula ithebula libe imephu yendawo usebenzisa inkinobho Ikhadi (imephu) ithebhu umakhi (Umklamo):

Naka ngokukhethekile iphaneli efanele Izinkambu zokubuka amandla - kuwo, ngokungafani namamephu e-Bing akudala, ngokuhudula amagama amakholomu (izinkambu) kusuka kuthebula lomthombo ngegundane bese uwaphonsa ezindaweni ezihlukene, ungenza ngendlela oyifisayo ukumelwa kwe-geo okuwumphumela:

  • Ukuya endaweni Izindawo (Izindawo) kuyadingeka ukuphonsa ikholomu kusuka kuthebula lomthombo eliqukethe amagama ezindawo.
  • Uma ungenayo ikholomu enegama, kodwa kukhona amakholomu anezixhumanisi, kufanele abekwe endaweni. I-Longitude (Ubude) и Ububanzi (I-Latitude)Ngokulandelana.
  • Uma endaweni Color (Umbala) lahla izimpahla, khona-ke i-bubble ngayinye izoba, ngaphezu kobukhulu (ibonisa inzuzo ephelele edolobheni), ichazwe ngezingcezu ngezimpahla.
  • Ukwengeza inkambu endaweni mpo or Iziphindaphinda ezivundlile (Abahlukanisi) izohlukanisa ikhadi elilodwa libe amaningana ngale nsimu (esibonelweni sethu, ngamakota).

Futhi kuthebhu yomongo evela phezulu Isakhiwo (Isakhiwo) ungenza ngendlela oyifisayo ingemuva lemephu (umbala, b/w, uhlaka, ukubuka kwesathelayithi), amalebula, izihloko, inganekwane, njll.

Uma kunedatha eningi, bese kuthebhu ukubuka kwamandla ungakwazi ukunika amandla okukhethekile Indawo yokuhlunga (Izihlungi), lapho usebenzisa amabhokisi okuhlola avamile ungakhetha ukuthi imaphi amadolobha noma izimpahla ofuna ukuzibonisa kumephu:

Ubude kuma-pluses: ukusetshenziswa kalula nokuguquguquka kokwenza ngokwezifiso, ikhono lokuhlukanisa ikhadi elilodwa ngezigaba eziningana.

Ezimweni ezimbi kakhulu: I-Power View ayitholakali kukho konke ukulungiselelwa kwe-Excel 2013, azikho ezinye izinhlobo zamashadi ngaphandle kwamabhamuza namashadi ophayi.

Indlela yesi-3: Iyabiza futhi iphrofeshinali - Isengezo semephu yamandla

Lesi isengezo se-COM esihlukile sezimo ezinzima kakhulu lapho udinga ukuboniswa okuyinkimbinkimbi, okubukeka kochwepheshe, okugqwayizayo kwenani elikhulu ledatha kunoma iyiphi (ngisho nemephu yangokwezifiso), kanye nevidiyo yokuguquguquka kwenqubo ngokuhamba kwesikhathi. . Esigabeni sokuthuthuka, yayinegama elisebenzayo elithi GeoFlow, futhi kamuva yaqanjwa kabusha ngokuthi Imephu Yamandla. Ngeshwa, inguqulo ephelele yalesi sengezo itholakala kuphela kubathengi benguqulo egcwele ye-Microsoft Office 2013 Pro noma ababhalisile bebhizinisi be-Office 365 abanohlelo lweBusiness Intelligence (BI). Nokho, amaqabane avela kwa-Microsoft anikeza ukubuka kuqala kwalesi sengezo ukuze ulande “ukuze udlale” mahhala, esibabonga ngakho.

Isixhumanisi sokulanda ukubuka kuqala kwe-Power Map Esikhungweni Sokulanda se-Microsoft (12 Mb)

Ngemva kokulanda nokufaka isengezo, udinga ukusixhuma kuthebhu Unjiniyela - Izengezo ze-COM (Unjiniyela - Izengezo ze-COM) efana ne-Power View evela endimeni yangaphambilini. Ngemva kwalokho, kuthebhu Faka inkinobho kufanele ivele Ikhadi (imephu). Uma manje sikhetha ithebula elinedatha yomthombo:

… bese uchofoza inkinobho ye-Map, sizobe sesiyiswa efasiteleni elihlukile lesengezo se-Microsoft Power Map:

Ngaphandle kokungena emininingwaneni (okwanele ukuqeqeshwa okuhlukile ingxenye yosuku), izimiso ezijwayelekile zokusebenza nemephu ziyefana nokuku-Power View echazwe ngenhla:

  • Usayizi wamakholomu unqunywa ikholomu yethebula elingumthombo (Imali engenayo), esizoyiphonsa ensimini Ukuphakama iphaneli elingakwesokudla. Umgomo wokubala, njengakumathebula e-pivot, ungashintshwa ohlwini lokudonsela phansi lezinkambu:

  • Ukuze ucacise ikholomu ngayinye yokuthengiswa kwemikhiqizo ngayinye, udinga ukugcwalisa inkambu Product endaweni Isigaba (Isigaba).
  • Ungasebenzisa izinhlobo ezihlukene zamashadi (amashadi amabha, amabhamuza, imephu yokushisa, izindawo ezigcwele) usebenzisa izinkinobho ezikuphaneli engakwesokudla:

  • Uma idatha yomthombo inekholomu enezinsuku zokuthengisa, ingaphonswa endaweni Isikhathi (Isikhathi) - khona-ke i-eksisi yesikhathi izovela ngezansi, lapho ungangena khona esikhathini esidlule futhi ubone inqubo ku-dynamics.

"Isikhathi sokumangalisa" sesengezo se-Power Map singase sibizwe ngokuthi kulula kakhulu ukudala ukubuyekezwa kwevidiyo opopayi ngokusekelwe kumamephu enziwe. Kwanele ukwenza amakhophi amaningana esigcawu samanje ngama-engeli ahlukene okubuka nezikali ezihlukene - futhi isengezo sizodala ngokuzenzakalelayo ukugqwayiza kwe-3D okundiza kuzungeze imephu yakho, kugxile ezindaweni ezikhethiwe. Ividiyo ewumphumela bese igcinwa kalula ngefomethi ye-mp4 njengefayela elihlukile ukuze lifakwe, isibonelo, ku-slide se-Power Point.

Indlela 4. Ishadi Lebhamuza “elinokulungiswa kwefayela”

Indlela "yepulazi elihlangene" kunazo zonke ezisohlwini, kodwa esebenza kuzo zonke izinguqulo ze-Excel. Yakha ishadi lebhamuza (Ishadi Lebhamuza), khubaza izimbazo zalo, igridi, inganekwane ... okungukuthi yonke into ngaphandle kwamabhamuza. Bese ulungisa mathupha ukuma kwamabhamuza ngokubeka isithombe esilandiwe ngaphambilini semephu oyifunayo ngaphansi komdwebo:

bawo yale ndlela zisobala: eside, dreary, omningi umsebenzi wezandla. Ngaphezu kwalokho, ukuphuma kwamasiginesha amabhamuza kuyinkinga ehlukile uma eningi.

buhle ngokuthi le nketho izosebenza kunoma iyiphi inguqulo ye-Excel, ngokungafani nezindlela ezilandelayo, lapho i-Excel 2013 idingeka khona. Futhi alukho uxhumano lwe-inthanethi oludingekayo.

Indlela yesi-5: Izinhlelo zokusebenza zezinkampani zangaphandle nezengezo 

Ngaphambilini, bekunezengezo ezimbalwa nama-plug-in e-Excel ayevumela, ngamazinga ahlukahlukene wokulunga nobuhle, ukusebenzisa ukuboniswa kwedatha kumephu. Manje iningi labo lilahliwe onjiniyela, noma esigabeni sokufa buthule - kunzima ukuncintisana ne-Power Map 🙂

Kwabasindile okufanele sibalulwe:

  • ImephuCite – mhlawumbe enamandla kunazo zonke. Iyakwazi ukunamathiselwa kumephu ngamagama ezindawo zokuhlala, izifunda, izifunda kanye nezixhumanisi. Ibonisa idatha njengamaphoyinti noma imephu yokushisa. Isebenzisa i-Bing Maps njengesisekelo. Yazi ngokuzenzakalelayo indlela yokuphonsa imephu edaliwe kusethulo se-Power Point. Inguqulo yesilingo samahhala iyatholakala ukuze ilandwe, inguqulo egcwele ibiza u-$99/ngonyaka.
  • Esri Maps - isengezo esivela ku-Esri esikuvumela futhi ukuthi ulayishe futhi uhlaziye i-geodata kusuka ku-Excel uye kumamephu. Izilungiselelo eziningi, izinhlobo ezahlukene zamashadi, izisekelo. Kukhona inguqulo yedemo yamahhala. Inguqulo ephelele idinga ukubhalisa kusevisi yemephu ye-ArcGis.
  • ImephuLand– esinye sezengezo zokuqala kulesi sihloko, esakhelwe i-Excel 97-2003. Iza nesethi yamamephu ngendlela yama-primitives ayingcaca, lapho idatha evela eshidini inamathiselwe khona. Amakhadi engeziwe kufanele athengwe. Idemo yezinguqulo ezihlukene ze-Excel iyatholakala ukuze ilandwe, inguqulo ye-Pro ibiza u-$299.

shiya impendulo