Zamkatimu
Tiyerekeze kuti tikufunika mwachangu komanso mosavutikira kupanga kalendala yapachaka yomwe imangowonetsa masiku a magawo a polojekiti (kapena tchuthi cha ogwira ntchito, kapena maphunziro, ndi zina zotero)
Ntchito
Tiyeni tiyambe ndi blank:
Monga mukuonera, zonse ndi zophweka apa:
- Mizere ndi miyezi, mizati ndi masiku.
- Cell A2 ili ndi chaka chomwe kalendala imamangidwira. M'maselo A4: A15 - manambala othandizira a miyezi. Tidzafunika zonse mtsogolo pang'ono kuti tipange masiku mu kalendala.
- Kumanja kwa tebulo pali mayina a magawo omwe ali ndi masiku oyambira ndi omaliza. Mutha kupereka ma cell opanda kanthu pasadakhale magawo atsopano omwe awonjezeredwa mtsogolo.
Kudzaza kalendala ndi masiku ndikubisala
Tsopano tiyeni tidzaze kalendala yathu ndi madeti. Sankhani selo loyamba la C4 ndikulowetsa ntchitoyo pamenepo DATE (TSIKU), yomwe imapanga deti kuyambira chaka, mwezi, ndi nambala ya tsiku:
Mukalowetsa fomuyi, iyenera kukopera kumitundu yonse kuyambira pa Januware 1 mpaka Disembala 31 (C4:AG15). Popeza ma cell ndi opapatiza, m'malo mwa masiku omwe adapangidwa, tiwona ma hash marks (#). Komabe, mukamayendetsa mbewa yanu pa selo iliyonse yotereyi, mutha kuwona zomwe zili m'munsimu:
Kuti tisunge ma gridi panjira, titha kuwabisa ndi mawonekedwe anzeru. Kuti muchite izi, sankhani masiku onse, tsegulani zenera Mtundu wa Cell ndi pa tabu Number (nambala) sankhani njira Mitundu yonse (Mwambo). Ndiye m'munda Mtundu lowetsani ma semicolons atatu motsatana (palibe mipata!) ndikusindikiza OK. Zomwe zili m'maselo zidzabisika ndipo ma grids adzasowa, ngakhale kuti masiku omwe ali m'maselo, ndithudi, adzakhalapo - izi ndizowonekera.
Kuwonetsa pasiteji
Tsopano, pogwiritsa ntchito masanjidwe okhazikika, tiyeni tiwonjeze zowunikira pamaselo omwe ali ndi masiku obisika. Sankhani madeti onse mugulu la C4:AG15 ndikusankha pa tabu Kunyumba - Mapangidwe Okhazikika - Pangani Lamulo (Kunyumba - Mapangidwe Okhazikika - Pangani Lamulo). Pazenera lomwe limatsegulidwa, sankhani njira Gwiritsani ntchito fomula kuti mudziwe kuti ndi maselo ati omwe angasanjidwe (Gwiritsani ntchito fomula kuti muyike ma cell omwe angapangidwe) ndipo lowetsani fomula:
Njirayi imayang'ana tsiku lililonse kuyambira C4 mpaka kumapeto kwa chaka kuti awone ngati ili pakati pa chiyambi ndi mapeto a chochitika chilichonse. Kutulutsa kudzakhala 4 kokha pamene zonse zomwe zatsimikiziridwa m'mabulaketi (C4>=$AJ$13:$AJ$4) ndi (C4<=$AK$13:$AK$1) zitulutsa TRUE yomveka, yomwe Excel imatanthauzira ngati 0 ( bwino , ZABODZA zili ngati 4, ndithudi). Komanso, tcherani khutu ku mfundo yakuti zolembera za selo yoyamba ya CXNUMX ndizogwirizana (popanda $), komanso pamagulu a magawo - mtheradi (ndi $ awiri).
Pambuyo pang'anani OK tiwona zochitika zazikulu mu kalendala yathu:
Kuunikira mphambano
Ngati madeti a magawo ena aphatikizana (owerenga mwachidwi ayenera kuti adazindikira kale mphindi ino pa gawo la 1 ndi 6!), ndiye kuti zingakhale bwino kuwunikira mkanganowu patchati chathu ndi mtundu wina pogwiritsa ntchito lamulo lina lokhazikika. Zili zofanana ndi zam'mbuyomu, kupatula kuti tikuyang'ana ma cell omwe akuphatikizidwa mu magawo angapo:
Pambuyo pang'anani OK lamulo loterolo lidzawunikira momveka bwino kuphatikizika kwa masiku mu kalendala yathu:
Kuchotsa masiku owonjezera m'miyezi
Inde, si miyezi yonse yomwe ili ndi masiku 31, kotero masiku owonjezera a February, April, June, ndi zina zotero. Ntchito DATE, yomwe imapanga kalendala yathu, m’maselo oterowo idzamasulira detilo kukhala mwezi wotsatira, mwachitsanzo, February 30, 2016 idzakhala March 1. Izi zikutanthauza kuti, nambala ya mwezi ya maselo owonjezera oterowo sidzafanana ndi nambala ya mwezi yomwe ili m’gawo A. Izi zitha kugwiritsidwa ntchito popanga lamulo lokhazikika kuti musankhe ma cell:
Powonjezera sabata
Mukasankha, mutha kuwonjezera pa kalendala yathu komanso kumapeto kwa sabata. Kuti muchite izi, mutha kugwiritsa ntchito TSIKU (WEEKTDAY), yomwe idzawerengere nambala ya tsiku la sabata (1-Mon, 2-Tue…7-Sun) pa deti lililonse ndikuwunikira zomwe zikuchitika Loweruka ndi Lamlungu:
Kuti muwonetse bwino, musaiwale kukonza ndondomeko yoyenera ya malamulo pawindo. Kunyumba - Mapangidwe Okhazikika - Sinthani Malamulo (Kunyumba - Mapangidwe Ovomerezeka - Sinthani Malamulo), chifukwa malamulo ndi zodzaza zimagwira ntchito ndendende motsatira ndondomeko yomwe mungapangire muzokambiranazi:
- Maphunziro amakanema ogwiritsira ntchito masanjidwe okhazikika mu Excel
- Momwe Mungapangire Ndandanda ya Ntchito (Tchati ya Gantt) Pogwiritsa Ntchito Mapangidwe Okhazikika
- Momwe mungapangire kalendala ya polojekiti mu Excel