Tsvaga Purojekiti Yotanga kana Zuva Rokupedzisira muGoogle Spreadsheets

Google Spreadsheets ine maitiro akawanda akavakwa mumasikati ezuva ano anogona kushandiswa kwemazuva ekushanda kwebasa.

Zuva roga roga basa rinoita basa rakasiyana kuitira kuti zvigumisiro zvisiyana kubva kune rimwe basa kune rinotevera. Iyo yaunoshandisa, saka, inobva pane zvaunoda.

01 of 03

The WORKDAY.INTL Basa

Google Spreadsheets WORKDAY.INTL Basa

Muchiitiko cheBASA REDAY.INTL, rinowana zuva rokutanga kana kuguma kweprojekiti kana kuti kugoverwa kunopiwa nhamba yakatarwa yemazuva ekushanda.

Mazuva anotsanangurwa sezuva remavhiki ekupedzisira anobva abviswa zvachose kubva pachikamu. Mukuwedzera, mazuva chaiwo, akadai sezororo rezvemitemo, anogonawo kuregererwa.

Kuti basa reWITKDAY.INTL rakasiyana sei neBASA REDAYI ndeyekuti WORKDAY.INTL inokubvumira kutsanangura kuti ndeipi mazuva uye kuti vangani vanoonekwa semagumo emazuva ekupedzisira pane kubvisa kamwe chete mazuva maviri pavhiki - Mugovera neSvondo - kubva mumazuva ose.

Zvishandiso zvebasa reMUPDAY.INTL zvinosanganisira 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

Syntax neMashongedzo eMushandirapamwe

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Mutsara weBASA REDAYI ndeyokuti:

= WORKDAY.INTL (start_date, num_days, weekend, holidays)

start_date - (inoda) zuva rokutanga yenguva yakasarudzwa
- iyo chaiyo yakatanga zuva inogona kupindirwa nokuda kweiyo mhinduro kana kuti sero rinotarisa panzvimbo ye data iyi mubhuku rinoshanda rinogona kupinda panzvimbo

num_days - (inodikanwa) kureba kweprojekti
- nekuda kwenyaya iyi, pinda integer inoratidza nhamba yemazuva ebasa yakaitwa purojekiti
- pinda nhamba chaiyo yemazuva emabasa - akadai se 82 - kana sero rinotarisa panzvimbo ye data iyi mune pepa rekushanda
- kuwana zuva rinoitika mushure mokutanga-date nharo, shandisa integer yakaisvonaka ye-num_mazuva
- kuti uwane zuva rinoitika musati wavapo-date argument, shandisa integer yakaipa ye-num_mazuva

vhiki yevhiki - (kusarudza) inoratidza mazuva api evhiki anoonekwa semazuva ekupera kwevhiki uye kusabvisa mazuva ano kubva mumazuva ese ekushanda
- nekuda kwepikisano iyi, pinda mumavhiki ekupedzisira nhamba yekodhi kana sechiteteri chemafoni kune nzvimbo yedata iri mune pepa rekushanda
- kana nharo iyi isingabvumirwi, zvisizvo 1 (Mugovera neSvondo) zvinoshandiswa pamutemo wevhiki
- ona rondedzero yakakwana yenhamba nhamba pajiji 3 yeyikudzidzisa

mazororo - (optional) rimwe kana kuti mamwe mazuva anowanikwa asina kubviswa mazuva ose ekushanda
- Zuva rezororo rinogona kuiswa se serial date nhamba kana sero rinotaura nezvekugara kwemazuva ekukosha mune pepa rekushanda
- kana zvinyorwa zvinoshandiswa zviri kushandiswa, tsika dzezuva dzinofanira kuiswa mumasero anoshandisa DATE , DATEVALUE kana TO_DATE mabasa kuti arege kukanganisa zvikanganiso

Muenzaniso: Tsvaga Zuva Rokupedzisira rePurojekiti nebasa re WORKDAY.INTL

Sezvinoratidzwa mumufananidzo uri pamusoro, muenzaniso uyu uchashanda basa reW WORKDAY.INTL kuwana zuva rokuguma kweprojekti inotanga musi waJuly 9, 2012 uye inogumisa mazuva makumi mapfumbamwe gare gare.

Mazororo maviri (September 3 naOctober 8) anowanikwa munguva ino haazoverengi sechikamu chemazuva 82.

Kuti urege kuverenga zvinetso zvinogona kuitika kana mazuva akangoerekana apinda semashoko, DATE basa rinoshandiswa kuisa zuva raishandiswa semafungiro. Ona Chikamu Chekukanganisa Maitiro Chikamu pamagumo emudzidzisi uyu kune mamwe mashoko.

Kupinda Data

A1: Zuva Rokutanga: A2: Nhamba Yemazuva: A3: Zororo 1: A4: Zororo 2: A5: Zuva Rokupedzisira: B1: = DATE (2012,7,9) B2: 82 B3: = DATE (2012,9,3) ) B4: = DATE (2012,10,8)

1. Isa data inotevera inese yakakodzera:

Kana mazuva ari mumasero b1, B3, uye B4 asingaoneki sezvakaratidzwa mumufananidzo uri pamusoro, chengetedza kuona kuti aya masero akaumbwa kuti aratidze dhidhiyo achishandisa fomu yezuva shoma.

02 of 03

Kupinda basa reWORK.DAY.INTL

Kupinda basa reWORK.DAY.INTL

Google spreadsheets haishandisi dialog boxes kuti iite nharo dzebasa sezvazvinogona kuwanikwa mu Excel. Pane kudaro, ine bhaji- yebhokisi yebhokisi iyo inotasva sezvo zita rebasa racho richiiswa muchitokisi.

1. Dzvanya pane sero B6 kuti riite sero rinoshandiswa - iyi ndiyo iyo migumisiro yebasa re WORKDAY.INTL icharatidzwa
2. Tora mufananidzo wakaenzana (=) uchitevedzwa nezita rebasa workday, intl
3. Sezvaunonyora, bhokisi -self- bhokisi rinowanikwa nemazita uye syntax yemabasa anotanga netsamba W
4. Apo zita rokuti WORKDAY.INTL rinowanikwa mubhokisi, chengetedza zita nezine mouse pointer kuti uise zita rebasa uye uzarure bhatikiti rose muchitsi B6

Kupinda Maitiro Akashanda

Sezvakaratidzwa mumufananidzo uri pamusoro apa, nharo dzeBASA REDAY.INTL dzakapinda mushure mekuvhara mazamu akazaruka muchitokisi B6.

1. Dzvanya pane sero B1 mune pepa rekushanda kuti uite iyi seferensi sesekutanga sekutangira- date argument
2. Mushure mokunge sero rinotarisa, shandisai comma ( , ) kuita separadzanisa pakati pemakakatanwa
3. Dzvanya pachitokisi B2 kuti upinde iyi seferensi yesero se- num_days argument
4. Mushure mokunge sero rinotarisa, tora imwe kamera
5. Dzvanya pachitokisi B3 kuti uende muchitarisiko chesekero sekupikisa kwevhiki
6. Simbisai masero B4 uye B5 mubasa rekushandisa kuti uise izvi zvinyorwa sezvesita rezororo
7. Dhinda pikicha inopinda mubhobhoyo kuti uise bhivha rekuvhara " ) " mushure mokupikisana kokupedzisira uye kupedza basa
8. Musi we11/29/2012 - zuva rokupedzisira reprojekti - rinofanira kuonekwa muchitokisi B6 chebasa rekushanda
9. Paunenge uchinyora pa cell b5 basa rakakwana
   = WORKDAY.INTL (B1, B2, B3, B4: B5) inowanikwa mubhairi yepamusoro pane pepa rekushanda

The Math mushure meKushanda

Kuti Excel inotarisa sei zuva iri ndeyokuti:

• Zuva riri mazuva makumi matanhatu nemasere mushure meAugust 5, 2012, ndiNovember 27 (zuva rokutanga harina kuverengwa seimwe remazuva 82 neBASA REDAY.INTL)
• Wedzera kusvikira zuva rino mazuva maviri ezuva rezororo akarondedzerwa (August 19 naNovember 15) izvo zvisina kuverengwa senhengo ye 82 Days argument
• Zuva rokuguma kweprojekti, saka, China, November 29, 2012

WORKDAY.INTL Kushanda Maitiro 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 asina kupinda sewe integer - sezuva 83.25 - nhamba ichaendeswa kune chikamu chakawanda chehamba: 83 mazuva

03 of 03

Table of Weekend Nhamba Nhamba uye Mazuva Anopera Mavhiki

Table of Weekend Nhamba Nhamba uye Mazuva Anopera Mavhiki

Kune nzvimbo ine Mazuva maviri eSvondo

Nhamba yeWhite Weekend 1 kana kubva musi weMugovera, Svondo 2 Svondo, Muvhuro 3 Muvhuro, Chipiri Chishanu, Chishanu Chitatu, Chishanu 6 China, Chishanu Ichishanu, Mugovera

Kwekugara neRimwe zuva Weekend

Nhamba Yevhiki Weekend zuva 11 Svondo 12 Muvhuro 13 Chipiri 14 Chitatu Chitatu 16 China 16 Chishanu 17 Mugovera