Contents
Idan kamfanin ku yana da rassa a duk faɗin ƙasar ko kuma yana siyarwa ba kawai a cikin Hanyar Ring na Moscow ba, to nan ba da jimawa ba za ku fuskanci aikin nuna bayanan lambobi daga Microsoft Excel (tallace-tallace, aikace-aikacen, kundin, abokan ciniki) akan taswirar yanki. dangane da takamaiman garuruwa da yankuna. Bari mu yi sauri duba manyan hanyoyin da za a iya ganin geodata da ke cikin Excel.
Hanyar 1: Sauri da Kyauta - Bangaren Taswirorin Bing
An fara daga nau'in 2013, Excel yana da kantin sayar da kayan aiki, watau ya zama mai yiwuwa a saya, zazzagewa da shigar da ƙarin kayayyaki da ƙari tare da ayyukan da suka ɓace. Ɗaya daga cikin waɗannan abubuwan kawai yana ba ku damar nuna bayanan lamba akan taswira kawai - ana kiranta taswirar Bing kuma, wanda yake da kyau musamman, yana da cikakkiyar kyauta. Don shigar da shi, buɗe shafin Saka - Store (Saka - Aikace-aikacen Ofishi):
Bayan shigar da bangaren, akwati mai ƙarfi tare da taswira yakamata ya bayyana akan takardar. Don ganin bayananku akan taswira, kuna buƙatar zaɓar kewayo tare da geodata kuma danna maɓallin Nuna Wuraren:
Idan ya cancanta, a cikin saitunan (alamar gear a saman kusurwar dama na sashin), zaku iya canza launuka da nau'in sigogin da aka nuna:
Hakanan yana yiwuwa a hanzarta tace biranen, yana nuna waɗanda kuke buƙata kawai (alamar mazurari a kusurwar dama ta sama na ɓangaren).
Kuna iya ɗaure ba kawai ga birane ba, har ma da wasu abubuwa: yankuna (misali, Yankin Tula), yankuna masu cin gashin kansu (misali, Yamalo-Nenets) da kuma jumhuriya (Tatarstan) - sannan za a nuna da'irar zane a tsakiyar yankin. Babban abu shine sunan da ke cikin tebur ya dace da rubutun da ke kan taswira.
Jimlar ciki ƙari na wannan hanyar: sauƙin aiwatarwa kyauta, ɗaure ta atomatik zuwa taswira, nau'ikan sigogi biyu, tacewa mai dacewa.
В fursunoni: kuna buƙatar Excel 2013 tare da damar Intanet, ba za ku iya zaɓar yankuna da gundumomi ba.
Hanyar 2: Mai sassauƙa da Kyau - Duba taswira a cikin Rahoton Duban Wuta
Wasu nau'ikan Microsoft Excel 2013 sun zo tare da ƙara ƙarar gani na rahoto mai ƙarfi da ake kira Power View wanda ke ba da izini (a tsakanin wasu abubuwa, kuma yana iya yin abubuwa da yawa!) Nuna bayanai na gani akan taswira. Don kunna add-on, buɗe shafin developer (Mai haɓakawa) kuma danna maɓallin COM add-ins (COM Add-ins). A cikin taga da ke buɗewa, duba akwatin kusa da Power View kuma danna Ok. Bayan duk waɗannan magudin akan shafin Saka (Saka) ya kamata ku sami maɓalli kallon iko.
Yanzu za ku iya zaɓar kewayon tare da bayanan tushen, danna wannan maɓallin - za a ƙirƙiri sabon takarda a cikin littafinku (kamar nunin nuni daga Wutar Wuta), inda za a nuna bayanan da aka zaɓa a cikin hanyar tebur:
Kuna iya sauƙin juya tebur zuwa taswirar yanki ta amfani da maɓallin Katin (taswira) tab Constructor (Zane):
Kula da hankali na musamman ga madaidaicin panel Filayen Duban Wuta - akansa, ba kamar taswirar Bing na farko ba, ta hanyar jawo sunayen ginshiƙai (filaye) daga teburin tushe tare da linzamin kwamfuta da jefa su cikin yankuna daban-daban, zaku iya daidaita yanayin wakilcin da ya haifar:
- Zuwa yanki wurare ( Wurare) wajibi ne a jefa ginshiƙi daga teburin tushe mai ɗauke da sunayen yanki.
- Idan ba ku da ginshiƙi mai suna, amma akwai ginshiƙai tare da daidaitawa, to suna buƙatar sanya su a cikin yankin. longitude (Longitude) и Latitude (Latitude), bi da bi.
- Idan a yankin Launi (Launi) sauke kayan, sa'an nan kowane kumfa zai kasance, ban da girman (nuna yawan riba a cikin birni), dalla-dalla a cikin yanka ta kaya.
- Ƙara filin zuwa yanki tsaye or Masu haɓaka a kwance (Masu Raba) zai raba kati ɗaya zuwa da yawa ta wannan filin (a cikin misalinmu, ta kwata).
Hakanan akan shafin mahallin da ke bayyana a saman Layout (Layout) za ka iya keɓance bangon taswira (launi, b/w, shaci, kallon tauraron dan adam), lakabi, lakabi, almara, da sauransu.
Idan akwai bayanai da yawa, to akan shafin kallon iko za ka iya kunna musamman Wurin tace (Tace), inda amfani da akwatunan rajista na yau da kullun zaku iya zaɓar garuruwa ko kaya da kuke son nunawa akan taswira:
Jimlar a cikin pluses: sauƙin amfani da sassauƙar gyare-gyare, ikon raba kati ɗaya zuwa sassa da yawa.
A cikin kasa-kasa: Ba a samun Duban Wutar Lantarki a cikin duk saitunan Excel 2013, babu wasu nau'ikan ginshiƙi banda kumfa da ginshiƙi.
Hanyar 3: Tsada da ƙwararru - Ƙara taswirar Wuta
Wannan keɓantaccen ƙari ne na COM don mafi girman lokuta lokacin da kuke buƙatar hadaddun, kallon ƙwararru, hangen nesa mai ɗimbin bayanai akan kowane (har ma taswirar al'ada), kuma tare da bidiyo na tsarin aiki akan lokaci. . A matakin ci gaba, tana da sunan aiki GeoFlow, kuma daga baya aka sake masa suna Taswirar Wuta. Abin takaici, cikakken sigar wannan add-in yana samuwa ga masu siyan ko dai cikakken sigar Microsoft Office 2013 Pro ko masu biyan kuɗin kasuwanci na Office 365 tare da shirin Intelligence Business (BI). Koyaya, abokan aikin Microsoft suna ba da samfoti na wannan ƙari don zazzage "don kunna" kyauta, wanda muke gode musu.
Haɗin don saukar da Preview Taswirar Wuta daga Cibiyar Zazzagewar Microsoft (12 Mb)
Bayan zazzagewa da shigar da add-on, kuna buƙatar haɗa shi akan shafin Mai Haɓakawa - COM Ƙara-Ins (Mai haɓakawa - COM Add-ins) kama da Power View daga sakin layi na baya. Bayan haka, a kan shafin Saka maballin ya kamata ya bayyana Katin (taswira). Idan yanzu mun zaɓi tebur tare da bayanan tushen:
… kuma danna maɓallin Taswira, sannan za a kai mu zuwa wani taga daban na ƙarar Taswirar Wutar Microsoft:
Ba tare da shiga cikin cikakkun bayanai ba (wanda ya isa ga horo daban na rabin yini), to, ka'idodin aiki tare da taswira iri ɗaya ne kamar yadda yake a cikin Power View da aka bayyana a sama:
- An ƙaddara girman ginshiƙan ta hanyar ginshiƙin tebur na tushen (Revenue), wanda za mu jefa a cikin filin Height a cikin dama panel. Ƙa'idar kirgawa, kamar yadda yake a cikin allunan pivot, ana iya canza su a cikin jerin filayen da aka zazzage:
- Don dalla-dalla kowane ginshiƙi na tallace-tallace don samfuran mutum ɗaya, kuna buƙatar cika filin Samfur zuwa yankin category (Kashi).
- Kuna iya amfani da nau'ikan ginshiƙi daban-daban ( sigogin mashaya, kumfa, taswirar zafi, wuraren da aka cika) ta amfani da maɓallan da ke gefen dama:
- Idan bayanan tushen yana da ginshiƙi tare da kwanakin tallace-tallace, to ana iya jefa shi cikin yankin Time (Lokaci) - to lokaci axis zai bayyana a kasa, tare da abin da za ka iya matsawa zuwa baya-nan gaba da kuma ganin tsari a cikin kuzari.
“Lokacin wow” na ƙarar Taswirar Wuta ƙila ana iya kiransa mafi sauƙin ƙirƙira bita-da-kullin bidiyo mai rai dangane da taswirorin da aka yi. Ya isa a yi kwafi da yawa na yanayin halin yanzu daga kusurwoyi daban-daban na kallo da ma'auni daban-daban - kuma ƙarawa za ta haifar da motsin 3D ta atomatik na yawo a kusa da taswirar ku, yana mai da hankali kan wuraren da aka zaɓa. Sakamakon bidiyon ana ajiye shi cikin sauƙi a tsarin mp4 azaman fayil daban don sakawa, misali, akan nunin Wutar Wuta.
Hanyar 4. Taswirar Kumfa tare da "gyara fayil"
Hanyar da ta fi dacewa da "gona gama gari" na duk da aka jera, amma aiki a cikin duk nau'ikan Excel. Gina taswirar kumfa (Chat ɗin kumfa), kashe gatari, grid, almara… watau komai sai kumfa. Sannan da hannu daidaita matsayin kumfa ta hanyar sanya hoton da aka sauke a baya na taswirar da ake so a ƙarƙashin zane:
fursunoni na wannan hanya a bayyane yake: dogo, mai ban tsoro, mai yawa aikin hannu. Bugu da ƙari, fitowar sa hannu don kumfa matsala ce daban lokacin da yawancin su.
ribobi a cikin wannan zaɓin zai yi aiki a kowace sigar Excel, sabanin hanyoyin da ke gaba, inda ake buƙatar Excel 2013. Kuma ba a buƙatar haɗin Intanet.
Hanyar 5: Ka'idodin ɓangare na uku da ƙari
A baya can, akwai da yawa add-ons da plug-ins don Excel wanda ya ba da izini, tare da nau'i daban-daban na dacewa da kyau, don aiwatar da nunin bayanai akan taswira. Yanzu mafi yawansu ko dai masu haɓakawa ne suka yi watsi da su, ko kuma a cikin yanayin mutuwar shiru - yana da wahala a yi gogayya da Taswirar Wuta 🙂
Daga cikin wadanda suka tsira da abin ambatawa:
- MapCite – watakila mafi iko duka. Za a iya haɗawa da taswirar ta sunayen ƙauyuka, yankuna, gundumomi da masu daidaitawa. Nuna bayanai azaman maki ko taswirar zafi. Yana amfani da taswirorin Bing azaman tushe. Ta atomatik ya san yadda ake jefa taswirar da aka ƙirƙira cikin gabatarwar Point Point. Akwai nau'in gwaji na kyauta don saukewa, cikakken sigar farashin $ 99 / shekara.
- Esri Maps - ƙari daga Esri wanda kuma yana ba ku damar lodawa da nazarin geodata daga Excel akan taswirori. Saituna da yawa, nau'ikan sigogi daban-daban, suna goyan bayan . Akwai sigar demo kyauta. Cikakken sigar yana buƙatar biyan kuɗi zuwa sabis ɗin taswirar ArcGis.
- MapLand- ɗayan farkon add-ins akan wannan batu, wanda aka kirkira don Excel 97-2003. Ya zo tare da saitin taswira a cikin nau'i na primitives mai hoto, wanda aka haɗa bayanai daga takardar. Dole ne a sayi ƙarin katunan. Akwai demo don nau'ikan Excel daban-daban don saukewa, nau'in Pro yana kashe $ 299.