Ake sithi uqhuba amaphrojekthi amaningana anezabelomali ezihlukene futhi ufuna ukubona ngeso lengqondo izindleko zakho ngayinye yazo. Okusho ukuthi, kusuka kuleli thebula lomthombo:
.. thola okuthile okufana nalokhu:
Ngamanye amazwi, udinga ukusabalalisa isabelomali phakathi nezinsuku zephrojekthi ngayinye futhi uthole inguqulo eyenziwe lula yeshadi lephrojekthi ye-Gantt. Ukwenza lokhu ngezandla zakho kude futhi kuyisicefe, ama-macros anzima, kodwa Umbuzo Wamandla we-Excel esimweni esinjalo ubonisa amandla ayo kuyo yonke inkazimulo yayo.
Umbuzo Wamandla iyisengezo esivela ku-Microsoft esingangenisa idatha ku-Excel kusuka cishe kunoma yimuphi umthombo bese siyiguqula ngenqwaba yezindlela ezahlukene. Ku-Excel 2016, lesi sengezo sesivele sakhelwe ngaphakathi ngokuzenzakalelayo, futhi ku-Excel 2010-2013 singalandwa kuwebhusayithi ye-Microsoft bese sifakwa ku-PC yakho.
Okokuqala, ake siguqule ithebula lethu langempela libe ithebula “elihlakaniphile” ngokukhetha umyalo Fometha njengetafula ithebhu Ikhaya (Ekhaya — Fometha Njengethebula) noma ngokucindezela isinqamuleli sekhibhodi Ctrl+T :
Bese uye kuthebhu Idatha (uma une-Excel 2016) noma kuthebhu Umbuzo Wamandla (uma une-Excel 2010-2013 futhi ufake Umbuzo Wamandla njengesengezo esihlukile) bese uchofoza inkinobho ethi From Table/Range. :
Ithebula lethu elihlakaniphile lilayishwa kusihleli sombuzo Wombuzo Wamandla, lapho isinyathelo sokuqala siwukusetha amafomethi ezinombolo kukholomu ngayinye usebenzisa okwehliswayo kunhlokweni yethebula:
Ukuze ubale isabelomali ngosuku, udinga ukubala ubude bephrojekthi ngayinye. Ukuze wenze lokhu, khetha (bamba ukhiye Ctrl) ikholomu kuqala Qeda, bese Qala bese ukhetha iqembu Engeza ikholomu – Usuku – Susa izinsuku (Engeza Ikholomu — Usuku — Susa izinsuku):
Izinombolo eziwumphumela zingaphansi ngo-1 kunesidingo, ngoba kufanele siqale iphrojekthi ngayinye ngosuku lokuqala ekuseni futhi siqede ngosuku lokugcina kusihlwa. Ngakho-ke, khetha ikholomu ewumphumela bese wengeza iyunithi kuyo usebenzisa umyalo Guqula – Okujwayelekile – Engeza (Guqula — Okujwayelekile — Engeza):
Manje ake sengeze ikholomu lapho sibala khona isabelomali ngosuku. Ukuze wenze lokhu, kuthebhu Faka Ikholomu Angidlali Ikholomu yangokwezifiso (Ikholomu yangokwezifiso) futhi efasiteleni elivelayo, faka igama lensimu entsha kanye nefomula yokubala, usebenzisa amagama amakholomu ohlwini:
Manje umzuzu ocake kakhulu - sakha enye ikholomu ebaliwe enohlu lwamadethi ukusuka ekuqaleni kuya ekugcineni ngesinyathelo sosuku olungu-1. Ukuze wenze lokhu, cindezela futhi inkinobho Ikholomu yangokwezifiso (Ikholomu yangokwezifiso) futhi usebenzise ulimi lwe-Power Query olwakhelwe ngaphakathi M, olubizwa Uhlu.Izinsuku:
Lo msebenzi unezimpikiswano ezintathu:
- idethi yokuqala - kithi, ithathwe kukholamu Qala
- inani lezinsuku okufanele zenziwe - kithi, leli inani lezinsuku zephrojekthi ngayinye, esizibale ekuqaleni kukholamu Ukuzikhipha
- Isinyathelo sesikhathi - simiswe ngokuklama #isikhathi(1,0,0,0), okusho ngolimi luka-M – usuku olulodwa, amahora ayiziro, imizuzu eyiziro, imizuzwana eyiziro.
Ngemuva kokuchofoza OK sithola uhlu (Uhlu) lwamadethi, olunganwetshwa lube imigqa emisha kusetshenziswa inkinobho enhlokweni yethebula:
... futhi sithola:
Manje osekusele ukugoqa ithebula, kusetshenziswa amadethi akhiqiziwe njengamagama amakholomu amasha. Ithimba libhekene nalokhu. Ikholomu yemininingwane (Ikholomu Ye-Pivot) ithebhu Convert (Guqula):
Ngemuva kokuchofoza OK sithola umphumela oseduze kakhulu nalowo esiwufunayo:
I-Null, kulokhu, i-analogue yeseli elingenalutho ku-Excel.
Kusele ukuthi kukhishwe amakholomu angadingekile futhi kwehlise ithebula elingumphumela eduze kwedatha yoqobo ngomyalo Vala futhi ulayishe - Vala futhi ulayishe... (Vala & Layisha — Vala & Layisha ku...) ithebhu Ikhaya (Ikhaya):
Sithola njengomphumela:
Ukuze uthole ubuhle obuningi, ungenza ngendlela oyifisayo ukubukeka kwamathebula ahlakaniphile okuba umphumela kuthebhu umakhi (Umklamo): setha isitayela sombala owodwa, khubaza izinkinobho zokuhlunga, nika amandla amanani, njll. Ngaphezu kwalokho, ungakhetha ithebula elinamadethi futhi unike amandla ukugqanyiswa kwenombolo kwalo usebenzisa ukufometha okunemibandela kuthebhu. Ikhaya - Ukufometha Okunemibandela - Izikali Zombala (Ikhaya — Ukufometha Okunemibandela — Izikali Zombala):
Futhi ingxenye engcono kakhulu ukuthi esikhathini esizayo ungakwazi ukuhlela amadala ngokuphephile noma wengeze amaphrojekthi amasha etafuleni lokuqala, bese ubuyekeza ithebula elingakwesokudla elinezinsuku ngenkinobho yegundane elingakwesokudla - futhi Umbuzo Wamandla uzophinda zonke izenzo esizenze ngokuzenzakalelayo. .
Njalo!
- Ishadi le-Gantt ku-Excel lisebenzisa ukufometha okunemibandela
- Ikhalenda lengqophamlando yephrojekthi
- Ikhiqiza Imigqa Eyimpinda ngombuzo wamandla