Okuqukethwe
Ngezinye izikhathi kungase kube nzima ukufanisa ngokushesha nangempumelelo imigqa yesikhathi yamaphrojekthi. Ukuvezwa okunemifanekiso kweminqamulajuqu yephrojekthi kanye nezinyathelo ezibalulekile kuzosiza ukukhomba noma yiziphi izingqinamba ngesikhathi sokuhlela.
Yiqiniso, kufanelekile ukucabangela ukusetshenziswa kwezinhlelo zokuphatha iphrojekthi. Isistimu enjalo izobonisa izikhathi zokuqala nezokugcina zemisebenzi yephrojekthi ngokumelene nesizinda esijwayelekile. Kodwa izinhlelo ezinjalo zibiza kakhulu! Esinye isisombululo ukuzama ukusebenzisa ishadi lebha yomugqa wesikhathi we-Excel lapho uhlela ukubona zonke izingxabano kuphrojekthi. Ukusebenzisana neqembu kanye nochwepheshe bezinkampani zangaphandle kuzoba lula kakhulu uma izenzo zawo wonke umuntu zingabonakala eshidini elifanayo!
Ngeshwa, ukwenza umugqa wesikhathi ku-Microsoft Excel akuwona umsebenzi olula. Ngeke ngincome ukwakha ishadi le-Gantt eliyinkimbinkimbi ku-Excel, kodwa umugqa wesikhathi olula ungadalwa ngokulandela imiyalelo yethu yesinyathelo nesinyathelo:
Isinyathelo 1: Lungiselela idatha
Okokuqala, sidinga ithebula ledatha, kukholamu yesokunxele lapho (ikholomu А) iqukethe wonke amagama omsebenzi, futhi amakholomu amabili kwesokudla abekelwe idethi yokuqala nobude besikhathi somsebenzi (amakholomu В и С).
Isinyathelo sesi-2: Dala ishadi
Gqamisa ithebula ledatha elilungisiwe, bese kuthebhu Faka (Faka) esigabeni Imidwebo (Amashadi) chofoza I-Ruled Stacked (Ibha Estakiwe).
Isinyathelo sesi-3: Ukuhlela Idatha Kushadi Ngokufanelekile
Lesi sinyathelo sihlala sinzima kakhulu, njengoba ishadi lihlelwa kuqala ngedatha efanele ezindaweni ezingalungile, uma leyo datha ike yavela eshadini!
Chofoza inkinobho Khetha idatha (Khetha Idatha) ithebhu umakhi (Umklamo). Hlola ukuthi yini endaweni Izinto zelejendi (imigqa) (Okufakiwe Kwenganekwane (Uchungechunge)) kubhalwe izici ezimbili - ubude besikhathi (Ubude besikhathi) kanye nedethi yokuqala (Usuku Lokuqala). Kufanele kube lezi zici ezimbili kuphela.
Ake ngiqagele. Ingabe lonke ulwazi selusukile noma luye eceleni? Asilungise.
Ukuze ulungise idatha yakho, chofoza Engeza (Engeza) noma Guqula (Hlela) endaweni Izinto zelejendi (imigqa) (Okufakiwe Kwenganekwane (Uchungechunge)). Ukwengeza Usuku Lokuqala, cacisa iseli B1 ensimini Igama lomugqa (Igama Lochungechunge), nasensimini Amanani (Amanani Wochungechunge) - ububanzi B2:B13. Ngendlela efanayo, ungangeza noma uguqule ubude besikhathi semisebenzi (Ubude besikhathi) – ensimini Igama lomugqa (Igama Lochungechunge) cacisa iseli C1, nasensimini Amanani (Amanani Wochungechunge) - ububanzi C2:C13.
Ukuze ulungise izigaba, chofoza inkinobho Guqula (Hlela) endaweni Amalebula e-eksisi avundlile (izigaba) (Okuvundlile (Isigaba) Amalebula e-eksisi). Ububanzi bedatha kufanele bucaciswe lapha:
=Лист3!$A$2:$A$13
=Sheet3!$A$2:$A$13
Kuleli qophelo, ishadi kufanele libukeke njengeshadi elistakiwe elinezihloko zomsebenzi ku-eksisi eqondile namadethi e-eksisi evundlile.
Isinyathelo sesi-4: Guqula umphumela ube Ishadi le-Gantt
Okusele ukuthi kwenziwe ukushintsha umbala wokugcwalisa wezingxenye ezingakwesokunxele zawo wonke amabha wegrafu awumphumela ube mhlophe noma obala.
★ Funda kabanzi mayelana nokudala ishadi le-Gantt esihlokweni: → Ungalakha kanjani ishadi le-Gantt ku-Excel - imiyalelo yesinyathelo ngesinyathelo
Isinyathelo sesi-5: Ukuthuthukisa Ukubukeka Kweshadi
Isinyathelo sokugcina siwukwenza umdwebo ube muhle kakhulu ukuze uthunyelwe kumphathi. Hlola i-eksisi evundlile: amabha wobude bephrojekthi kuphela okufanele abonakale, okungukuthi sidinga ukususa isikhala esingenalutho esivele esinyathelweni sangaphambilini. Chofoza kwesokudla ku-eksisi evundlile yeshadi. Iphaneli izovela Imingcele ye-eksisi (Izinketho ze-eksisi), lapho ungashintsha khona inani elincane le-eksisi. Enza ngendlela oyifisayo imibala yamabha eshadi le-Gantt, setha okuthile okuthakaselekayo. Okokugcina, ungasikhohlwa isihloko.
Umugqa wesikhathi ku-Excel (ishadi le-Gantt) ungasetshenziselwa izinjongo ezihlukahlukene. Abaphathi bazokwazisa ngokuqinisekile ukuthi ungakha isimiso esinjalo ngaphandle kwezindleko ezengeziwe zokuthenga isofthiwe ebizayo yokuphatha iphrojekthi!