01 ye 01
BASA REBASA
Tsvaga Purojekiti Yekutanga kana Kuguma muExpcel
Excel ine zviverengero zvakavakwa mumabasa emazuva ano anogona kushandiswa pakuverenga zuva zuva.
Zuva roga roga basa rinoita basa rakasiyana kuitira kuti zvigumisiro zvisiyana kubva kune rimwe basa kune rinotevera. Iyo yaunoshandisa, saka, inobva pane zvaunoda.
Excel WORKDAY Basa
Munyaya yeBASA ROMUSORO, rinowana zuva rokutanga kana kuguma kweprojekiti kana basa rakapiwa nhamba yakatarwa yemazuva ekushanda.
Nhamba yemazuva ekushanda zvinowanzoisa kunze kwemavhiki ekupedzisira uye chero mazuva anozivikanwa sezororo.
Zvishandiso zvebasa reBASA rinobatanidza kuverenga:
- zuva rokupedzisira kweprojekti ine nhamba yakatarwa yemazuva ekushanda mushure mekunge musi wekutanga watanga
- musi wekutanga weprojekiti ine nhamba yakatarwa yemasazuva asati apera zuva rokupedzisira rakapiwa
- zuva rakakodzera rekurasikirwa
- iyo inotarisirwa zuva rekutakura kwezvinhu kana zvinhu
Dhiyabhorosi Basa reStain neArguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara weBASA REDAYI ndeyokuti:
= BASA (Start_date, Mazuva, Mazororo)
Start_date - (inoda) zuva rokutanga yenguva yakasarudzwa. Iyo chaiyo yekutanga zuva inogona kupindirwa nekuda kweiyo mhinduro kana kuti sero rinotarisa kunzvimbo yedata iyi mune pepa rekushandisa rinogona kupinda panzvimbo.
Mazuva - (anodiwa) kureba kweprojekti. Ichi ndicho chikwata chinoratidza nhamba yemazuva emabasa ayo akaitwa purojekiti. Nokuda kwechikonzero ichi, pinda nhamba yemazuva ekushanda kana sero rinotarisa panzvimbo ye data iyi mune pepa rekushanda.
Cherechedza: Kuti uwane zuva rinoitika mushure mokunge mutambo weKutanga_date ushandise integer yakaisvonaka yeMazuva . Kuti uwane zuva rinoitika musati mutevedzeri weKutanga_date ushandisa integer yakaipa yeMazuva . Muchiitiko ichi chepiri, Start-date argument inogona kuonekwa sezuva rokupedzisira reprojekti.
Mazororo - (zvichida) imwe kana mamwe mamwe mazuva mamwe asingaverengwi sechikamu chemazuva ose ekushanda. Shandisai zvinyorwa zveseti kune nzvimbo yedhidhi mune pepa rekushandira kwepikicha iyi.
Muenzaniso: Tsvaga Zuva Rokupedzisira rePurojekiti
Sezvakaratidzwa mumufananidzo uri pamusoro, muenzaniso uyu uchashanda BASA REBASA kuti uwane zuva rokuguma kweprojekti inotanga July 9, 2012 uye inopedza mazuva 82 gare gare. Mazororo maviri (September 3 naOctober 8) anowanikwa munguva ino haazoverengi sechikamu chemazuva 82.
Cherechedza: Kuti urege kuverenga zvinetso zvinogona kuitika kana mazuva akangoerekana apinda sekutumira DATE basa richashandiswa kuisa mazuva akashandiswa mubasa racho. Ona Chikamu Chekukanganisa Maitiro Chikamu pamagumo emudzidzisi uyu kune mamwe mashoko.
Kupinda Data
D1: Zuva Rokutanga : D2: Nhamba Yemazuva: D3: Zororo 1: D4: Zororo 2: D5: Zuva Rokupedzisira: E1: = DATE (2012,7,9) E2: 82 E3: = DATE (2012,9,3) ) E4: = DATE (2012,10,8)- Isa data inotevera inese yakakodzera:
Cherechedza: Kana mazuva ari mumasero E1, E3, uye E4 asingaoneki sezvakaratidzwa mumufananidzo uri pamusoro, chengetedza kuona kuti aya masero akaumbwa kuti aratidze dheshoni achishandisa fomati yezuva shoma.
Kupinda Basa reMUSORO
- Dzvanya pane cell E5 kuti iite iyo inoshandiswa seki - iyi ndiyo iyo migumisiro yeBASA REDAYI icharatidzwa
- Dzvanya paMafomu eTom
- Sarudza Zuva uye Nguva Mabasa> WORKDAY kubva kubhoni kuitira kuti uise basa rebhokisi rebhokisi
- Dzvanya paIndaneti_date mubhokisi rebhokisi
- Dzvanya pane cell E1 mune pepa rekushanda kuti uise iyi rekero mubhokisi rebhokisi
- Dzvanya pamatare emisi mubhokisi rebhokisi
- Dzvanya pachitokisi E2 mune pepa rekushanda kuti uise iyi rekero mubhokisi rebhokisi
- Dzvanya paZvizororo mutsara mubhokisi rebhokisi
- Dragodza masero E3 neE4 mubasa rekushandisa kuti uise izvi zvinyorwa zvinyorwa mubhokisi rebhokisi
- Dzvanya OK mubhokisi rebhokisi kuti upedze basa
- Musi we11/2/2012 - zuva rekuguma kweprojekti - inofanira kuonekwa muchitokisi E5 chebasa rekushanda
- Kuti Excel inotarisa sei zuva iri ndeyokuti:
- Zuva rakapera mazuva 82 kubva musi waJuly 9, 2012, musi waOctober 31 (zuva rokutanga harina kuverengwa seimwe remazuva 82 neBASA REDAYI)
- Wedzera kusvikira zuva rino maawa maviri ezuva rezororo akarondedzerwa (September 3 neOctober 8) ayo asina kuverengwa sechikamu chemazuva 82 nharo
- Nokudaro, zuva rekupedzisira reprojekiti ndeChishanu musi wa2, 2012
- Paunenge uchinge uri pa cell E5 zvakakwana basa = WORKDAY (E1, E2, E3: E4) inowanikwa mubhairi yepamusoro pane pepa rekushanda
MHURI Dhiyabhorosi Basa Rakanganisa Maitiro
Kana nhoroondo yezvikonzero zvakasiyana-siyana zvebasa iri isina kupinda nenzira yakarurama iyo inotevera kukanganisa maonero inowanikwa muchitokisi umo BASA REBASA rino riri:
- #VALUE! : inowanikwa mundima yeseri kana imwe yeZVANZANO dzeMASHURE haisi zuva rakakodzera (kana zuva racho rakatorwa seiri rugwaro)
- #NUM !: inowanikwa mumhinduro yesero kana zuva risingabatsiri rinoguma nekuwedzera Start_date uye Mazuva arguments
- Kana Mazuva akakavhiringidza haana kupinda sewe integer - yakadai semasikati 82.75 - nhamba ichaendeswa kune imwechete - panzvimbo yekukomberedza kana pasi - kusvika kune chikamu chikuru chehamba: 82 mazuva.