Okuqukethwe
Ake sithi sidinga ukwenza ngokushesha nangomzamo omncane ukudala ikhalenda lonyaka elibonisa ngokuzenzakalelayo izinsuku zezigaba zephrojekthi (noma amaholide ezisebenzi, noma ukuqeqeshwa, njll.)
I-workpiece
Ake siqale ngokungenalutho:
Njengoba ubona, yonke into ilula lapha:
- Imigqa yizinyanga, amakholomu ayizinsuku.
- Iseli A2 liqukethe unyaka ikhalenda okwakhiwa ngawo. Kumaseli A4:A15 – izinombolo ezisizayo zezinyanga. Sizodinga kokubili kamuva ukuze sakhe izinsuku ekhalendeni.
- Ngakwesokudla setafula kunamagama ezigaba ezinezinsuku zokuqala nezokugcina. Ungahlinzeka ngamaseli angenalutho kusengaphambili ngezigaba ezintsha ezingezwe esikhathini esizayo.
Ukugcwalisa ikhalenda ngezinsuku futhi uzifihle
Manje ake sigcwalise ikhalenda lethu ngezinsuku. Khetha iseli C4 yokuqala bese ufaka umsebenzi lapho DATE (DATE), ekhiqiza idethi esuka onyakeni, inyanga, nenombolo yosuku:
Ngemva kokufaka ifomula, kufanele ikopishelwe kulo lonke ibanga kusukela ngoJanuwari 1 kuya kuDisemba 31 (C4:AG15). Njengoba amaseli emancane, esikhundleni sezinsuku ezidaliwe, sizobona ama-hash marks (#). Kodwa-ke, uma uhambisa igundane lakho phezu kwanoma iyiphi iseli enjalo, ungabona okuqukethwe kwayo kwangempela kuthulithiphu:
Ukuze sigcine amagridi endleleni, singawafihla ngefomethi yangokwezifiso ehlakaniphile. Ukuze wenze lokhu, khetha zonke izinsuku, vula iwindi Ifomethi Yeseli nakuthebhu Inombolo (inombolo) khetha inketho Wonke amafomethi (Ngokwezifiso). Khona ensimini Uhlobo faka amasemikholoni amathathu ngokulandelana (akukho zikhala!) bese ucindezela OK. Okuqukethwe kwamaseli kuzofihlwa futhi amagridi azonyamalala, nakuba izinsuku ezisele, empeleni, zizohlala - lokhu kubonakala kuphela.
Ukugqamisa kwesiteji
Manje, sisebenzisa ukufometha okunemibandela, ake sengeze ukugqamisa okuyingqopha-mlando kumaseli anezinsuku ezifihliwe. Khetha zonke izinsuku kububanzi C4:AG15 bese ukhetha kuthebhu Ikhaya - Ukufometha Okunemibandela - Dala Umthetho (Ikhaya - Ukufometha okunemibandela - Dala Umthetho). Ewindini elivulayo, khetha inketho Sebenzisa ifomula ukuze unqume ukuthi yimaphi amaseli ozofometha (Sebenzisa ifomula ukuhlehlisa ukuthi yimaphi amaseli ozofometha) bese ufaka ifomula:
Le fomula ihlola wonke amaseli edethi ukusuka ku-C4 kuye ekupheleni konyaka ukuze ibone ukuthi aweli yini phakathi kokuqala nokuphela kwengqophamlando ngayinye. Okukhiphayo kuzoba ngu-4 kuphela uma zombili izimo ezithikhiwe kubakaki (C4>=$AJ$13:$AJ$4) kanye (C4<=$AK$13:$AK$1) zikhiqiza i-TRUE enengqondo, i-Excel eyihumusha ngokuthi 0 ( kahle , AMANGA kufana no-4, kunjalo). Futhi, qaphela ngokukhethekile iqiniso lokuthi izinkomba zeseli yokuqala ye-CXNUMX zihlobene (ngaphandle kwe-$), kanye nobubanzi bezigaba - ngokuphelele (ngama-$ amabili).
Ngemuva kokuchofoza OK sizobona ingqophamlando ekhalendeni lethu:
Igqamisa izimpambanomgwaqo
Uma amadethi ezinye izigaba egqagqene (abafundi abalalelisisayo kumele ngabe sebesibonile lesi sikhathi sesigaba sokuqala nesesi-1!), khona-ke kungaba ngcono ukugqamisa lokhu kungqubuzana eshadini lethu ngombala ohlukile kusetshenziswa omunye umthetho wokufometha onemibandela. Ifana nokukodwa-kuya-kokukodwa njengangaphambili, ngaphandle kokuthi sifuna amaseli afakwe esigabeni esingaphezu kwesisodwa:
Ngemuva kokuchofoza OK umthetho onjalo uzogqamisa ngokucacile ukugqagqana kwezinsuku ekhalendeni lethu:
Ukususa izinsuku ezengeziwe ezinyangeni
Yiqiniso, akuzona zonke izinyanga ezinezinsuku ezingu-31, ngakho-ke izinsuku ezengeziwe zikaFebhuwari, Ephreli, Juni, njll. Kungaba kuhle ukumaka ngokubonakalayo njengokungabalulekile. Umsebenzi DATE, okwakha ikhalenda lethu, kulawo maseli azohumusha ngokuzenzakalelayo usuku lube enyangeni elandelayo, okungukuthi u-February 30, 2016 uzoba u-March 1. Okusho ukuthi, inombolo yenyanga yamaseli anjalo ngeke ilingane nenombolo yenyanga ekukholomu A. . Lokhu kungasetshenziswa uma udala umthetho wokufometha onemibandela ukuze ukhethe amaseli anjalo:
Yengeza impelasonto
Uma uthanda, ungakwazi ukwengeza ekhalendeni lethu nangezimpelaviki. Ukuze wenze lokhu, ungasebenzisa umsebenzi DAY (USUKU LWEVIKI), ezobala inombolo yosuku lweviki (1-Mon, 2-Tue…7-Sun) ngosuku ngalunye futhi igqamise lezo eziba ngeMigqibelo namaSonto:
Ukuze uthole isibonisi esifanele, ungakhohlwa ukulungisa kahle ukuhleleka okufanele kwemithetho efasiteleni. Ikhaya - Ukufometha Okunemibandela - Phatha Imithetho (Ikhaya - Ukufometha okunemibandela - Phatha Imithetho), ngoba imithetho nokugcwalisa kusebenza ngqo ngokulandelana okunengqondo ozokwakha kule ngxoxo:
- Isifundo sevidiyo sokusebenzisa ukufometha okunemibandela ku-Excel
- Ulwakha kanjani Isheduli Yephrojekthi (Ishadi le-Gantt) Usebenzisa Ukufometha Okunemibandela
- Ungawakha kanjani umugqa wesikhathi wephrojekthi ku-Excel