txheem
Yog hais tias koj lub tuam txhab muaj ceg nyob ib ncig ntawm lub teb chaws los yog muag tsis tau tsuas yog nyob rau hauv lub Moscow Ring Road, ces sai los yog tom qab ntawd koj yuav tau ntsib nrog cov hauj lwm ntawm visually displaying cov ntaub ntawv los ntawm Microsoft Excel (muag, daim ntaub ntawv, ntim, cov neeg muas zaub) nyob rau hauv daim ntawv qhia thaj chaw. nrog rau kev siv rau tej nroog thiab cheeb tsam. Cia peb saib sai ntawm txoj hauv kev tseem ceeb kom pom cov geodata uas muaj nyob hauv Excel.
Txoj Kev 1: Ceev thiab Dawb - Bing Maps Cheebtsam
Pib los ntawm 2013 version, Excel muaj lub khw app built-in, piv txwv li nws tau dhau los ua kev yuav, rub tawm thiab nruab cov modules ntxiv thiab add-ons nrog cov haujlwm uas ploj lawm. Ib qho ntawm cov khoom no tsuas yog tso cai rau koj pom cov ntaub ntawv tus lej ntawm daim ntawv qhia - nws yog hu ua Bing Maps thiab, uas yog qhov zoo tshaj plaws, yog dawb kiag li. Txhawm rau nruab nws, qhib lub tab Ntxig - Khw (Insert - Office Apps):
Tom qab ntxig cov khoom, lub thawv ntim nrog ib daim ntawv qhia yuav tsum tshwm rau ntawm daim ntawv. Txhawm rau pom koj cov ntaub ntawv hauv daim ntawv qhia, koj yuav tsum xaiv qhov ntau nrog geodata thiab nias lub pob Qhia qhov chaw:
Yog tias tsim nyog, hauv qhov chaw (iav icon nyob rau sab xis sab xis ntawm cov khoom), koj tuaj yeem hloov xim thiab hom kab kos duab:
Nws kuj tseem tuaj yeem lim cov nroog sai sai, pom tsuas yog cov uas koj xav tau (funnel icon nyob rau sab xis sab xis ntawm cov khoom siv).
Koj tuaj yeem yooj yim khi tsis tau tsuas yog rau cov nroog, tab sis kuj rau lwm yam khoom: cheeb tsam (piv txwv li, Tula cheeb tsam), cov cheeb tsam autonomous (piv txwv li, Yamalo-Nenets) thiab republics (Qaib ntxhw) - tom qab ntawd lub voj voog ntawm daim duab yuav muab tso rau hauv nruab nrab ntawm thaj chaw. Qhov tseem ceeb tshaj plaws yog lub npe nyob rau hauv lub rooj sib tw nrog cov kab lus hauv daim ntawv qhia.
Tag nrho hauv qhov ntxiv ntawm txoj kev no: kev siv yooj yim pub dawb, tsis siv neeg khi rau hauv daim ntawv qhia, ob hom kab kos, yooj yim lim.
В qhov tsis zoo: koj xav tau Excel 2013 nrog kev siv Internet, koj tsis tuaj yeem xaiv cov cheeb tsam thiab cheeb tsam.
Txoj Kev 2: Yooj Yim thiab Zoo Nkauj - Daim Ntawv Qhia Saib hauv Daim Ntawv Qhia Txog Lub Zog
Qee cov qauv ntawm Microsoft Excel 2013 tuaj nrog cov ntawv ceeb toom muaj zog pom qhov ntxiv-hauv hu ua Power View uas tso cai (ntawm lwm yam, thiab nws tuaj yeem ua tau ntau heev!) pom cov ntaub ntawv ntawm daim ntawv qhia. Txhawm rau qhib lub add-on, qhib lub tab tsim tawm (Tus tsim tawm) thiab nyem rau ntawm lub pob COM ntxiv-ins (COM Ntxiv-ins). Nyob rau hauv lub qhov rais uas qhib, kos lub thawv nyob ib sab ntawm Power View thiab nyem OK. Tom qab tag nrho cov manipulations ntawm lub tab Insert (Ntxig) koj yuav tsum muaj khawm lub zog saib.
Tam sim no koj tuaj yeem xaiv qhov ntau yam nrog cov ntaub ntawv hauv qab no, nyem rau ntawm lub pob no - ib daim ntawv tshiab yuav raug tsim nyob rau hauv koj phau ntawv (ntau dua li swb los ntawm Power Point), qhov twg cov ntaub ntawv xaiv yuav tshwm nyob rau hauv daim ntawv ntawm lub rooj:
Koj tuaj yeem yooj yim tig lub rooj rau hauv daim ntawv qhia thaj chaw siv lub pob Daim Npav (daim ntawv qhia) tab constructor (Tsim):
Them tshwj xeeb rau lub vaj huam sib luag txoj cai Power View teb - ntawm nws, tsis zoo li yav dhau los Bing Maps, los ntawm kev rub cov npe ntawm txhua kab (thaj chaw) los ntawm lub rooj hauv paus nrog tus nas thiab xa lawv mus rau ntau qhov chaw, koj tuaj yeem hloov kho cov txiaj ntsig geo- sawv cev:
- Rau thaj tsam Qhov chaw (Qhov chaw) Nws yog ib qho tsim nyog yuav tsum pov ib kem los ntawm lub ntsiab lus uas muaj cov npe ntawm thaj chaw.
- Yog tias koj tsis muaj kab ke nrog lub npe, tab sis muaj kab nrog kev tswj hwm, ces lawv yuav tsum tau muab tso rau hauv cheeb tsam. Ntev (Longitude) и Latitude (Latitude), feem.
- Yog nyob hauv cheeb tsam xim (Xim) poob cov khoom, ces txhua npuas yuav, ntxiv rau qhov loj me (tso tawm tag nrho cov nyiaj tau los hauv lub nroog), cov ncauj lus kom ntxaws rau hauv cov khoom siv.
- Ntxiv ib daim teb rau ib cheeb tsam ntsug or Kab rov tav multipliers (Divides) yuav faib ib daim npav rau ob peb ntawm daim teb no (hauv peb qhov piv txwv, los ntawm peb lub hlis twg).
Kuj ntawm cov ntsiab lus tab uas tshwm nyob rau saum Layout (Layout) Koj tuaj yeem hloov kho daim ntawv qhia keeb kwm yav dhau (xim, b / w, qauv, satellite saib), cov ntawv sau, npe, lus dab neeg, thiab lwm yam.
Yog tias muaj ntau cov ntaub ntawv, ces ntawm lub tab lub zog saib koj tuaj yeem pab tshwj xeeb Lim cheeb tsam (Cov lim), qhov twg siv cov checkboxes li niaj zaus koj tuaj yeem xaiv lub nroog lossis cov khoom koj xav qhia rau hauv daim ntawv qhia:
Tag nrho cov hauv pluses: yooj yim ntawm kev siv thiab yooj ntawm customization, muaj peev xwm muab faib ib daim ntawv rau hauv ob peb pawg.
Hauv cov downsides: Power View tsis muaj nyob rau hauv tag nrho Excel 2013 configurations, tsis muaj lwm yam kab kos uas tsis yog npuas thiab ncuav qab zib kab kos.
Txoj Kev 3: Nqis thiab kev tshaj lij - Power Map add-on
Qhov no yog cais COM add-on rau qhov mob hnyav tshaj plaws thaum koj xav tau kev ua haujlwm nyuaj, kev ua haujlwm zoo, kev ua kom pom cov duab ntawm ntau cov ntaub ntawv ntawm ib qho (txawm tias daim ntawv qhia kev cai), thiab nrog cov yeeb yaj kiab ntawm cov txheej txheem ua haujlwm dhau sijhawm. . Nyob rau theem kev txhim kho, nws muaj lub npe ua haujlwm GeoFlow, thiab tom qab ntawd tau hloov npe hu ua Power Map. Hmoov tsis zoo, daim ntawv qhia tag nrho ntawm qhov ntxiv-hauv no tsuas yog muaj rau cov neeg yuav khoom ntawm ob qho tag nrho ntawm Microsoft Office 2013 Pro lossis Office 365 cov neeg lag luam koom nrog kev lag luam txawj ntse (BI) txoj kev npaj. Txawm li cas los xij, cov phooj ywg los ntawm Microsoft muab qhov saib ua ntej ntawm qhov txuas ntxiv mus rub tawm "ua si" dawb, uas peb ua tsaug rau lawv.
Txuas mus download tau Power Map Saib ua ntej los ntawm Microsoft Download Center (12 Mb)
Tom qab rub tawm thiab txhim kho lub add-on, koj yuav tsum txuas nws ntawm lub tab Tus tsim tawm - COM Add-Ins (Tus tsim tawm - COM Add-ins) zoo ib yam li Power View los ntawm kab lus dhau los. Tom qab ntawd, ntawm lub tab Insert khawm yuav tsum tshwm Daim Npav (daim ntawv qhia). Yog tias peb tam sim no xaiv lub rooj nrog cov ntaub ntawv qhov chaw:
... thiab nyem lub pob Daim Ntawv Qhia, tom qab ntawd peb yuav raug coj mus rau lub qhov rai cais ntawm Microsoft Power Map ntxiv-hauv:
Yog tsis nkag mus rau hauv cov ntsiab lus (uas yog txaus rau ib qho kev qhia cais rau ib nrab hnub), ces cov ntsiab cai ntawm kev ua haujlwm nrog daim ntawv qhia yog tib yam li hauv Power View tau piav qhia saum toj no:
- Qhov luaj li cas ntawm kab yog txiav txim los ntawm lub hauv paus kab lus (Nyiaj Khwv Nyiaj), uas peb yuav muab pov rau hauv lub tshav pob Qhov siab nyob rau hauv txoj cai vaj huam sib luag. Lub hauv paus ntsiab lus ntawm kev suav, xws li hauv cov lus pivot, tuaj yeem hloov pauv hauv daim ntawv teev npe ntawm cov teb:
- Txhawm rau nthuav dav txhua kab ntawm kev muag khoom rau tus kheej cov khoom, koj yuav tsum tau sau rau hauv daim teb khoom mus rau thaj chaw Qeb (Qeb).
- Koj tuaj yeem siv ntau hom kab kos (bar kab kos, npuas, daim ntawv qhia tshav kub, qhov chaw puv) siv cov nyees khawm ntawm lub vaj huam sib luag sab xis:
- Yog tias cov ntaub ntawv hauv paus muaj kab ke nrog cov hnub muag, ces nws tuaj yeem muab pov rau hauv cheeb tsam Lub sij hawm (Sijhawm) - tom qab ntawd lub sijhawm axis yuav tshwm sim hauv qab no, uas koj tuaj yeem txav mus rau yav dhau los- yav tom ntej thiab pom cov txheej txheem hauv dynamics.
Lub "wow lub sijhawm" ntawm Lub Hwj Chim Daim Ntawv Qhia Ntxiv tuaj yeem hu ua qhov yooj yim kawg ntawm kev tsim cov yeeb yaj kiab tshuaj xyuas raws li daim duab qhia. Nws yog txaus los ua ob peb daim ntawv luam ntawm qhov chaw tam sim no los ntawm qhov sib txawv saib cov ces kaum thiab cov nplai sib txawv - thiab cov add-in yuav cia li tsim 3D animation ntawm ya ncig koj daim ntawv qhia, tsom rau cov chaw xaiv. Cov yeeb yaj kiab uas tau tshwm sim tau yooj yim tau txais kev cawmdim hauv mp4 hom raws li cov ntaub ntawv sib cais rau kev ntxig, piv txwv li, ntawm Power Point swb.
Txoj Kev 4. Daim duab npuas nrog "File Refinement"
Txoj kev "ua liaj ua teb sib sau ua ke" feem ntau ntawm tag nrho cov npe, tab sis ua haujlwm hauv txhua qhov ntawm Excel. Tsim ib daim ntawv ua npuas (Bubble Chart), lov tes taw nws cov axes, kab sib chaws, lus dab neeg ... piv txwv li txhua yam tab sis cov npuas. Tom qab ntawd manually kho qhov chaw ntawm cov npuas los ntawm qhov muab cov duab rub tawm yav dhau los ntawm daim ntawv qhia xav tau hauv qab daim duab:
cons ntawm cov qauv no yog pom tseeb: ntev, dreary, ntau ntawm phau ntawv ua haujlwm. Ntxiv mus, cov zis ntawm kos npe rau npuas yog ib qho teeb meem cais thaum muaj ntau ntawm lawv.
pros nyob rau hauv qhov kev xaiv no yuav ua hauj lwm nyob rau hauv tej version ntawm Excel, tsis zoo li cov hauv qab no txoj kev, qhov twg Excel 2013 yuav tsum tau. Thiab tsis tas yuav muaj kev sib txuas hauv Is Taws Nem.
Txoj Kev 5: Thib peb apps thiab add-ons
Yav dhau los, muaj ob peb add-ons thiab plug-ins rau Excel uas tau tso cai, nrog ntau qib ntawm kev yooj yim thiab kev zoo nkauj, los siv cov ntaub ntawv ntawm daim ntawv qhia. Tam sim no feem coob ntawm lawv tau tso tseg los ntawm cov neeg tsim khoom, lossis nyob rau theem ntawm kev ntsiag to tuag - nws nyuaj rau kev sib tw nrog Power Map 🙂
Ntawm cov survivors tsim nyog hais txog:
- MapCite - tej zaum lub zog tshaj plaws ntawm txhua tus. Muaj peev xwm txuas nrog rau daim ntawv qhia los ntawm cov npe ntawm cov chaw nyob, cheeb tsam, cheeb tsam thiab kev tswj xyuas. Qhia cov ntaub ntawv raws li cov ntsiab lus lossis daim ntawv qhia tshav kub. Siv Bing Maps ua lub hauv paus. Yeej paub yuav muab pov daim ntawv qhia tsim rau hauv Power Point kev nthuav qhia. Ib tug dawb mus sib version muaj rau download, tag nrho version nqi $99/xyoo.
- Esri Maps - ib qho ntxiv los ntawm Esri uas tseem tso cai rau koj thauj khoom thiab txheeb xyuas geodata los ntawm Excel rau hauv daim ntawv qhia. Ntau qhov chaw, ntau hom kab kos, txhawb nqa. Muaj ib tug dawb demo version. Daim ntawv qhia tag nrho xav tau kev tso npe rau ArcGis daim ntawv qhia kev pabcuam.
- MapLand- ib qho ntawm thawj add-ins ntawm lub ncauj lus no, tsim rau Excel 97-2003. Nws los nrog ib txheej ntawm daim duab qhia chaw nyob rau hauv daim ntawv ntawm graphic primitives, uas cov ntaub ntawv los ntawm daim ntawv txuas. Yuav tsum tau yuav daim npav ntxiv. Ib tug demo rau txawv versions ntawm Excel yog muaj rau download, tus Pro version nqi $299.