01 ngo 01
UMSEBENZI WOMSEBENZI
Fumana iQela lokuQala okanye iNkqubo yokuPhela kwi-Excel
I-Excel inemisebenzi emininzi eyakhiwe kwimisebenzi yamhla engasetyenziselwa ukubalwa kwemini yomsebenzi.
Umsebenzi ngamnye womsebenzi wenza umsebenzi ohlukeneyo ukwenzela ukuba iziphumo zihluke kumsebenzi omnye ukuya olandelayo. Yiyiphi na oyisebenzisayo, ngoko, kuxhomekeke kwiziphumo ozifunayo.
Umsebenzi we-Excel WORKDAY
Kwimeko yomsebenzi we-WORKDAY, ufumana umhla wokuqalisa okanye wokuphela kweprojekthi okanye isabelo esinikezwe inombolo ehleliweyo yeentsuku zomsebenzi.
Inani leentsuku zomsebenzi ngokuzenzekelayo alibandakanyi ngeeveki kunye nayiphi na imihla echongwa njengeeholide.
Ukusetyenziswa komsebenzi we-WORKDAY kubandakanya ukubala:
- Umhla wokuphela kweprojekthi eneenombolo zomsebenzi wentsuku emva komhla wokuqalisa owenziwe
- Umhla wokuqala weprojekthi eneenombolo zomsebenzi weentsuku phambi komhla wokuphela
- umhla ofunekayo we-invoyisi
- Umhla wokulindeleka wokuhanjiswa kwempahla okanye izinto
IMISEBENZI YOMSEBENZI Wama-syntax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .
I-syntax yomsebenzi we-WORKDAY ngu:
= WORKDAY (Qala_ukuqala, iintsuku, iiholide)
I-Start_date - (efunekayo) umhla wokuqala wexesha elikhethiweyo. Umhla wokuqala wokuqalisa ungangeniswa kule ngxabano okanye isalathisi yesisele kwindawo yendawo kule fom yokusebenzela ingeniswa endaweni yoko.
Iintsuku - (ezifunekayo) ubude beprojekthi. Le nani libonisa inani leentsuku zomsebenzi ezenziwa kwiprojekthi. Ngenxa yale ngxabano, faka inani leentsuku zomsebenzi okanye iselferensi yeseli kwindawo yolu datha kwiphepha lokusebenzela.
Qaphela: Ukufumana umhla owenzeka emva kokuba i- Start_date argument isebenzise inani elihle leentsuku . Ukufumana umhla owenzeka ngaphambi kokuba i- Start_date argument isebenzise inani elibi leentsuku . Kwimeko yesibili i- Start_date argument ingaqatshelwa njengomhla wokuphela kweprojekthi.
Amaholide - (ukhetho) enye okanye eminye imihla eyongezelelweyo engabalwa njengenxalenye yenani leentsuku zokusebenza. Sebenzisa izikhokelo zeseli kwindawo yendawo kwiphepha lokusebenzela le ngxabano.
Umzekelo: Fumana umhla wokuphela weProjekthi
Njengoko kuboniswe kumfanekiso ongentla, lo mzekelo uya kusebenzisa umsebenzi we-WORKDAY ukufumana umhla wokuphela kwiprojekthi eqala ngoJulayi 9, 2012 kwaye iphetha iintsuku ezingama-82 emva koko. Iholide ezimbini (Septemba 3 no-Oktobha 8) ezenzeka ngeli xesha aziyi kubalwa njengenxalenye yeentsuku ezingama-82.
Qaphela: Ukukhusela iingxaki zokubala ezinokuthi zenzeke ukuba iintsuku zingena ngengozi njengombhalo we-DATE umsebenzi uya kusetyenziswa ukufaka imihla esetyenziswe kumsebenzi. Bona iCandelo leMilinganiselo yeZiphumo ekupheleni kwesi sihloko ngolwazi olungakumbi.
Ukungena kwiDatha
I-D1: Usuku lokuqala: I- D2: Inani leentsuku: D3: Iholide 1: D4: Iholide 2: D5: Umhla Wokuphela: E1: = UMHLA (2012,7,9) E2: 82 E3: = UMHLA (2012,9,3 ) E4: = UMHLA (2012,10,8)- Faka idatha elandelayo kwiseli efanelekileyo:
Qaphela: Ukuba imihla ngemili e-E1, E3, ne-E4 ayibonakali njengokuba iboniswe kumfanekiso ongentla, khangela ukuba ezi festile zifomathiweyo ukubonisa idatha ngokusebenzisa ifomati yamfutshane.
Ukufaka umsebenzi we-WORKDAY
- Cofa kwifowuni E5 ukwenzela ukuba yenze i- cell esebenzayo- yilapho iziphumo zomsebenzi we-WORKDAY ziya kuboniswa
- Cofa kwiThebhu yefomula
- Khetha usuku kunye nemisebenzi yexesha> WORKDAY kwi- Ribbon ukukhupha ibhokisi yencoko yencoko yomsebenzi
- Cofa kwi- Start_date line kwibhokisi yencoko
- Cofa kwiseli E1 kwiphepha lokusebenzela ukufaka le fom yeefayile kwibhokisi yencoko
- Cofa kwiiNtsuku elandelayo kwibhokisi yencoko
- Cofa kwiseli E2 kwiphepha lokusebenzela ukuze ufake le fom yeefayile kwibhokisi yencoko
- Cofa kwiiHholide kwi-bhokisi yencoko
- Hudula ukhethe iiseli E3 kunye ne-E4 kwiphepha lokusebenzela ukuze ufake ezi ngqamaniso zeselenki kwibhokisi yencoko
- Cofa Kulungile kwibhokisi yencoko ukugqiba umsebenzi
- Umhla we-11/2/2012-umhla wokuphela kweprojekthi-kufuneka uvele kwiseli ye-E5 yephepha lokusebenzela
- Indlela i-Excel ebala ngayo lo mhla:
- Umhla oneminyaka engama-82 emva koJulayi 9, 2012 ngo-Oktobha 31 (umhla wokuqala awubalwa nje ngeentsuku ezingama-82 ngomsebenzi we-WORKDAY)
- Yongeza kulo mhla umhla weeholide ezimbini zichazwe ngokucacileyo (Septemba 3 no-Oktobha 8) ezingabalwa njengenxalenye yeengxabano ezingama- 82 kwiintsuku
- Ngoko ke, umhla wokuphela kweprojekthi nguLwesihlanu ngoNovemba 2, 2012
- Xa ucofa kwi-cell E5 umsebenzi opheleleyo = WORKDAY (E1, E2, E3: E4) ibonakala kwifom yefomula ngaphezu kwephepha lokusebenzela
UMSEBENZI UMSEBENZI WEMIGAQO Iimpazamo
Ukuba idatha yeengxabano ezahlukahlukeneyo zalo msebenzi ayifakwanga ngokuchanekileyo, ixabiso lesiphumo elilandelayo livela kwiseli apho umsebenzi we-WORKDAY ukhona:
- #VALUE! : ibonakala kwisicatshulwa sentsuku Ukuba enye ingxoxo ye-WORKDAY ayilona usuku oluvumelekileyo (ukuba umhla ungeniswa njengombhalo ngomzekelo)
- #NUM !: ibonakala kwisicatshulwa sentsholongwane ukuba umhla wokungafanelekanga uvela ekungeniseni i- Start_date kunye neentsuku zokubambisana
- Ukuba intshukumo yeentsuku ayifakwanga njenge-integer - njengemihla engama-82.75 - inombolo iya kutsalwa - kunokugqitywa okanye iphantsi-kwinxalenye enkulu yenani: iintsuku ezingama-82.