Contents
A ce muna buƙatar da sauri kuma tare da ƙaramin ƙoƙari don ƙirƙirar kalanda na shekara-shekara wanda ke nuna kwanakin matakan aikin ta atomatik (ko hutun ma'aikata, ko horo, da sauransu).
Kayan aiki
Bari mu fara da komai:
Kamar yadda kake gani, komai yana da sauki a nan:
- Layukan watanni ne, ginshiƙai kwanaki ne.
- Cell A2 ya ƙunshi shekarar da ake gina kalanda. A cikin sel A4: A15 - ƙarin lambobi na watanni. Za mu buƙaci duka biyu kaɗan daga baya don samar da kwanan wata a cikin kalanda.
- A hannun dama na teburin sunayen matakai ne tare da kwanakin farawa da ƙarshen. Kuna iya ba da sel marasa komai a gaba don sabbin matakan da aka ƙara a nan gaba.
Cika kalanda tare da kwanan wata da ɓoye su
Yanzu bari mu cika kalandarmu da kwanan wata. Zaɓi cell na farko C4 kuma shigar da aikin a can DATE (DATE), wanda ke samar da kwanan wata daga shekara, wata, da lambar rana:
Bayan shigar da dabarar, dole ne a kwafi shi zuwa gabaɗayan kewayon daga Janairu 1 zuwa Disamba 31 (C4: AG15). Tun da sel ɗin suna kunkuntar, maimakon kwanakin da aka ƙirƙira, za mu ga alamun zanta (#). Koyaya, lokacin da kuke shawagi linzamin kwamfuta akan kowane irin wannan tantanin halitta, zaku iya ganin ainihin abinda ke cikin sa a cikin kayan aiki:
Don kiyaye grids daga hanya, zamu iya ɓoye su tare da tsarin al'ada mai wayo. Don yin wannan, zaɓi duk kwanakin, buɗe taga Tsarin Sel kuma a kan tab Number (lamba) zaɓi zaɓi Duk tsari (Na al'ada). Sai a filin Wani nau'in shigar da semicolon guda uku a jere (babu sarari!) kuma latsa OK. Abubuwan da ke cikin sel za a ɓoye kuma grids za su ɓace, kodayake kwanakin a cikin sel, a gaskiya, za su kasance - wannan kawai ganuwa ne.
Haskakawa mataki
Yanzu, ta amfani da tsari na yanayi, bari mu ƙara nuna alama ga sel masu ɓoye kwanan wata. Zaɓi duk kwanakin da ke cikin kewayon C4:AG15 kuma zaɓi akan shafin Gida - Tsarin Yanayi - Ƙirƙirar Doka (Gida - Tsarin Yanayi - Ƙirƙirar Doka). A cikin taga da yake buɗewa, zaɓi zaɓi Yi amfani da dabara don tantance waɗanne sel don tsarawa (Yi amfani da dabara don jinkirta waɗanne sel don tsarawa) kuma shigar da dabara:
Wannan dabarar tana bincika kowace tantanin halitta daga C4 zuwa ƙarshen shekara don ganin ko ta faɗi tsakanin farkon da ƙarshen kowane ci gaba. Fitowar zai zama 4 kawai lokacin da yanayin da aka bincika a cikin maƙallan (C4> = $ AJ $ 13: $ AJ $ 4) da (C4 <=$AK$13:$AK $1) suna samar da GASKIYA mai ma'ana, wanda Excel ke fassara a matsayin 0 (da kyau). , KARYA kamar 4 ne, tabbas). Har ila yau, kula da hankali ga gaskiyar cewa nassoshi na farko tantanin halitta CXNUMX sun kasance dangi (ba tare da $), kuma zuwa matakan matakan - cikakke (tare da $ biyu).
Bayan danna kan OK za mu ga abubuwan da suka faru a kalandar mu:
Haskaka mashigai
Idan kwanakin wasu matakai sun haɗu (masu karatu masu hankali dole ne sun riga sun lura da wannan lokacin don matakan 1st da 6th!), To, zai fi kyau a nuna wannan rikici a cikin ginshiƙi tare da launi daban-daban ta amfani da wata ka'idar tsara yanayin. A zahiri yana kama da na baya, sai dai muna neman sel waɗanda aka haɗa cikin matakai sama da ɗaya:
Bayan danna kan OK Irin wannan ƙa'idar za ta ba da haske a sarari yadda ranakun da ke cikin kalandar mu:
Cire karin kwanaki a cikin watanni
Tabbas, ba duk watanni suna da kwanaki 31 ba, don haka ƙarin kwanakin Fabrairu, Afrilu, Yuni, da sauransu. Zai yi kyau a gani alama a matsayin mara amfani. Aiki DATE, wanda ke samar da kalandarmu, a cikin irin waɗannan ƙwayoyin za su fassara kwanan wata ta atomatik zuwa wata na gaba, watau Fabrairu 30, 2016 zai zama Maris 1. Wato, lambar wata na irin waɗannan ƙarin ƙwayoyin ba zai zama daidai da lambar wata a shafi na A ba. Ana iya amfani da wannan lokacin ƙirƙirar ƙa'idar tsara tsari don zaɓar irin waɗannan sel:
Ƙara karshen mako
Zabi, za ka iya ƙara zuwa mu kalanda da karshen mako. Don yin wannan, zaka iya amfani da aikin DAY (RANAR MAKO), wanda zai lissafta adadin ranar mako (1-Mon, 2-Tue…7-Sun) na kowace rana kuma ya haskaka waɗanda ke faɗuwa a ranakun Asabar da Lahadi:
Don nuni daidai, kar a manta da daidaita daidaitaccen tsari na ƙa'idodi a cikin taga. Gida - Tsarin Yanayi - Sarrafa Dokoki (Gida - Tsarin Sharadi - Sarrafa Dokoki), saboda ka'idoji da cikawa suna aiki daidai a cikin jerin ma'ana waɗanda zaku ƙirƙira a cikin wannan maganganun:
- Koyarwar bidiyo akan yin amfani da tsari na yanayi a cikin Excel
- Yadda ake Ƙirƙirar Jadawalin Aiki (Gantt Chart) Ta Amfani da Tsarin Yanayi
- Yadda ake ƙirƙirar tsarin lokaci a cikin Excel