Okuqukethwe
Izinqubo eziningi zebhizinisi (ngisho nawo wonke amabhizinisi) kule mpilo zibandakanya ukugcwaliseka kwama-oda ngenani elilinganiselwe labadlali ngesikhathi esinqunyiwe. Ukuhlela ezimweni ezinjalo kwenzeka, njengoba besho, "kusuka ekhalendeni" futhi ngokuvamile kunesidingo sokudlulisa imicimbi ehleliwe kuyo (ama-oda, imihlangano, ukulethwa) ku-Microsoft Excel - ukuze kuhlaziywe okwengeziwe ngamafomula, amatafula e-pivot, ukushadi, njll.
Vele, ngingathanda ukusebenzisa ukudluliswa okunjalo hhayi ngokukopisha oyisiphukuphuku (okungenzima nje), kodwa ngokubuyekezwa okuzenzakalelayo kwedatha ukuze ngokuzayo zonke izinguquko ezenziwe ekhalendeni kanye nama-oda amasha empukaneni aboniswe I-Excel. Ungakwazi ukufaka ukungenisa okunjalo emizuzwini embalwa usebenzisa isengezo se-Power Query esakhelwe ku-Microsoft Excel, kusukela kunguqulo ka-2016 (ye-Excel 2010-2013, ingalandwa kuwebhusayithi ye-Microsoft futhi ifakwe ngokuhlukana nesixhumanisi) .
Ake sithi sisebenzisa i-Google Khalenda yamahhala ukuhlela, lapho mina, ukuze kube lula, ngidale ikhalenda elihlukile (inkinobho enophawu lokuhlanganisa ekhoneni elingezansi kwesokudla eduze Amanye amakhalenda) ngesihloko Work. Lapha sifaka wonke ama-oda adinga ukugcwaliswa futhi alethwe kumakhasimende emakhelini awo:
Ngokuchofoza kabili noma yiliphi i-oda, ungabuka noma uhlele imininingwane yalo:
Qaphela ukuthi:
- Igama lomcimbi lithi umphathiogcwalisa lo myalelo (u-Elena) kanye Inombolo Ye-oda
- Kubonisiwe ikheli ukulethwa
- Inothi liqukethe (ngemigqa ehlukene, kodwa nganoma iyiphi indlela) imingcele ye-oda: uhlobo lokukhokha, inani, igama lekhasimende, njll. ngefomethi Ipharamitha=Inani.
Ukuze kucace, ama-oda omphathi ngamunye agqanyiswe ngombala wawo, nakuba lokhu akudingekile.
Isinyathelo 1. Thola isixhumanisi se-Google Khalenda
Okokuqala sidinga ukuthola isixhumanisi sewebhu sekhalenda lethu loku-oda. Ukuze wenze lokhu, chofoza inkinobho enamachashazi amathathu Izinketho Zekhalenda Ziyasebenza eduze kwegama lekhalenda bese ukhetha umyalo Amasethingi nokwabelana:
Ewindini elivulayo, ungakwazi, uma uthanda, wenze ikhalenda libe sesidlangalaleni noma uvule ukufinyelela kulo kubasebenzisi ngabanye. Futhi sidinga isixhumanisi sokufinyelela okuyimfihlo kukhalenda ngefomethi ye-iCal:
Isinyathelo 2. Layisha idatha esuka ekhalendeni ibe Umbuzo Wamandla
Manje vula i-Excel nakuthebhu Idatha (uma une-Excel 2010-2013, bese kuthebhu Umbuzo Wamandla) khetha umyalo Kusuka ku-inthanethi (Idatha - Kusuka ku-inthanethi). Bese unamathisela indlela ekopishiwe ekhalendeni bese uchofoza okuthi KULUNGILE.
Umbuzo we-iCal Power awuboni ifomethi, kodwa kulula ukukusiza. Empeleni, i-iCal iyifayela lombhalo elingenalutho elinekholoni njenge-delimiter, futhi ngaphakathi libukeka kanjena:
Ngakho ungamane uchofoze kwesokudla kusithonjana sefayela elilandiwe bese ukhetha ifomethi esondele kakhulu ngencazelo CSV - futhi idatha yethu mayelana nawo wonke ama-oda izolayishwa kumhleli wombuzo we-Power Query futhi ihlukaniswe ngamakholomu amabili ngekholoni:
Uma ubhekisisa, ungabona ngokucacile ukuthi:
- Ulwazi mayelana nomcimbi ngamunye (ukuhleleka) luqoqwe lwaba ibhulokhi eqala ngegama elithi QALA futhi ligcine ngokuthi END.
- Izikhathi zedethi zokuqala nezokugcina zigcinwe ochungechungeni olunelebulwe ngokuthi DTSTART kanye ne-DTEND.
- Ikheli lokuthumela lithi LOCATION.
- Inothi le-oda – DESCRIPTION inkambu.
- Igama lomcimbi (igama lomphathi nenombolo ye-oda) — Inkambu YOKUFAKAZA.
Kusele ukukhipha lolu lwazi oluwusizo futhi luguqule lube itafula elilungele.
Isinyathelo 3. Guqulela Ukubuka Okuvamile
Ukuze wenze lokhu, yenza uchungechunge lwezenzo ezilandelayo:
- Masisuse imigqa engu-7 ephezulu esingayidingi ngaphambi komyalo wokuqala othi BEGIN Ikhaya - Susa Imigqa - Susa Imigqa Ephezulu (Ikhaya - Susa imigqa - Susa imigqa ephezulu).
- Hlunga ngekholomu Column1 imigqa equkethe izinkambu esizidingayo: DTSTART, DTEND, DESCRIPTION, LOCATION and SUMMARY.
- Kuthebhu ethuthukisiwe Yengeza ikholomu khetha Ikholomu yenkomba (Engeza ikholomu — Ikholomu yenkomba)ukwengeza ikholomu yenombolo yomugqa kudatha yethu.
- Khona lapho kuthebhu. Yengeza ikholomu khetha iqembu Ikholomu enemibandela (Engeza ikholomu — Ikholomu enemibandela) futhi ekuqaleni kwebhulokhi ngayinye (i-oda) sibonisa inani lenkomba:
- Gcwalisa amaseli angenalutho kukholamu ewumphumela Blockngokuchofoza kwesokudla esihlokweni sayo bese ukhetha umyalo Gcwalisa - Phansi (Gcwalisa - Phansi).
- Susa ikholomu engadingekile Index.
- Khetha ikholomu Column1 futhi wenze ukuguqulwa kwedatha evela kukholomu Column2 usebenzisa umyalo Guqula – Ikholomu Ye-Pivot (Guqula — Ikholomu ye-Pivot). Qiniseka ukuthi ukhetha kuzinketho Ungahlanganisi (Ungahlanganisi)ukuze kungabikho umsebenzi wezibalo osetshenziswa kudatha:
- Ethebulani elingumphumela elinezinhlangothi ezimbili (esiphambanweni), sula ama-backslash kukholamu yekheli (chofoza kwesokudla kunhlokweni yekholomu - Ukushintsha amanani) bese ususa ikholomu engadingekile Block.
- Ukuguqula okuqukethwe kwamakholomu DTSTART и DTEND ngesikhathi esigcwele, uzigqamise, khetha kuthebhu Guqula – Usuku – Qalisa Ukuhlaziya (Guqula — Idethi — Hlaziya). Bese silungisa ikhodi kubha yefomula ngokushintsha umsebenzi Idethi.Kusuka on IdethiIsikhathi.Kusukaukuze ungalahlekelwa amanani esikhathi:
- Bese, ngokuchofoza kwesokudla kunhlokweni, sihlukanisa ikholomu INCAZELO ngemingcele ye-oda ngesihlukanisi - uphawu n, kodwa ngesikhathi esifanayo, kumapharamitha, sizokhetha ukuhlukaniswa kube imigqa, hhayi kumakholomu:
- Nakulokhu, sihlukanisa ikholomu ewumphumela ibe izingxenye ezimbili ezihlukene - ipharamitha nenani, kodwa ngophawu olulinganayo.
- Ukukhetha ikholomu INCAZELO.1 senze i-convolution, njengoba senza ngaphambili, ngomyalo Guqula – Ikholomu Ye-Pivot (Guqula — Ikholomu ye-Pivot). Ikholomu yenani kuleli cala izoba ikholomu enamanani epharamitha− INCAZELO.2 Qiniseka ukuthi ukhetha umsebenzi kumapharamitha Ungahlanganisi (Ungahlanganisi):
- Kusele ukusetha amafomethi awo wonke amakholomu futhi uwaqambe kabusha ngendlela ofisa ngayo. Futhi ungalayisha imiphumela uyibuyisele ku-Excel ngomyalo Ikhaya - Vala futhi Ulayishe - Vala futhi Ulayishe... (Ekhaya — Vala&Layisha — Vala&Layisha ku…)
Futhi nalu uhlu lwethu lwama-oda alayishwe ku-Excel esuka ku-Google Khalenda:
Ngokuzayo, lapho sishintsha noma sengeza ama-oda amasha ekhalendeni, kuyokwanela kuphela ukubuyekeza isicelo sethu ngomyalo. Idatha - Vuselela Konke (Idatha — Vuselela Konke).
- Ikhalenda lemboni ku-Excel livuselelwe kusukela ku-inthanethi nge-Power Query
- Ukuguqula ikholomu ibe ithebula
- Dala i-database ku-Excel