Nzira Yokugadzira Gantt Chart muGoogle Sheets

Chimwe chinhu chakakurumbira chekuchengetedzwa kweprojekti, Gantt charts inopa nguva, kuverenga-nyore-kuverenga kupera kwekupedzwa, ikozvino uye mabasa anouya uyewo avo vavakagoverwa pamwe chete nemazuva ekutanga uye ekupedzisira. Ichi chinomiririra kuratidzira purogiramu inopa maonero epamusoro-soro ekufambira mberi kwakadini kuri kuitwa uye inoratidzawo zvimwe zvingave zvingaita.

MaSpredishiti eGoogle anopa kukwanisa kugadzira zvinyorwa zvakajeka zveGantt zviri mukati mepadheseti yako, kunyange kana iwe usina kumbove wakamboona maitiro avo akasiyana. Kuti uitange, tevera mirairo iri pasi apa.

01 of 03

Kuumba Purojekiti Yenyu Purogiramu

Usati wasvika muGantt chati yakasikwa, iwe kutanga unoda kutsanangura mabasa ako epurogiramu pamwe chete nemazuva anowirirana patafura iri nyore.

1. Tanga Google Sheets uye uzarure peperesheet itsva.
2. Sarudza nzvimbo yakakodzera pedyo nepamusoro pepasiparadzi rako risina chinhu uye faira mumazita anotevera mazita mumutsara mumwe chete, imwe neimwe muhomwe yavo, sezvinoratidzwa mune chinyorwa ichi chiri: Start Date , End Date , Task Name . Kuti uite zvinhu zvive nyore iwe pachako munguva yekudzidza iwe ungada kushandisa nzvimbo dzakafanana dzatakashandisa mumuenzaniso wedu (A1, B1, C1).
3. Pinda chimwe nechimwe chemabasa ako epurogiramu pamwe chete nemazuva anowirirana mumakoroni akakodzera, uchishandisa mitsara yakawanda sezvakakodzera. Dzinofanira kuve dzakarongwa maererano nekuitika (kumusoro kusvika pasi = kutanga kuguma) uye fomu yezuva inofanira kunge yakaita: MM / DD / YYYY.
4. Mamwe maitiro ekugadzirisa tafura yako (miganhu, shading, kuenzanirana, maitiro emhando, etc.) zvinongoratidzirwa munyaya iyi, sezvo chinangwa chikuru chedu ndechokuisa deta ichazoshandiswa neGantt chati gare gare muchidzidzo. Zvakakwana kwauri kana uchida kuita zvimwe zvinogadziriswa kuitira kuti tafura iwedzere kuoneka. Kana iwe uchidaro, zvakakosha kuti data pachayo inoramba iri mumiganhu yakarurama nemirasi.

02 of 03

Kugadzira Dhaurirano Yekuverenga

Kungoita mazuva ekutanga uye ekuguma hakukwanisi kupa Gantt chati, sezvo sarudzo yaro inotsigira zvakanyanya nguva yakatarwa iyo inopfuura pakati pezvinhu zviviri zvinokosha. Kuti uite izvi zvinotarisirwa iwe unoda kuumba imwe tafura inotara nguva iyi.

1. Tsvaga pasi mitsara yakawanda kubva patafura yekutanga yatakagadzira pamusoro.
2. Tora mazita anotevera mazita mumutsara mumwechete, mumwe nomumwe ari muhomwe yake, sezvinoratidzwa mune chinyorwa chinyorwa ichi: Zita remabasa , Start Day , Total Duration .
3. Nyora mhando yemabasa kubva patafura yako yekutanga kupinda muTamende yeNoramita yekona, kuve kuti inorongedzwa zvakarongeka.
4. Tora fomu iyi inotevera muTangira Day column yako yekutanga basa, uchishandisa 'A' netsamba yekoromusi ine Chekutanga Rokutanga mufurafura yako yekutanga uye '2' nemutsara wemutsara: = int (A2) -in ($ A $ 2 ) . Hit Enter or Return key wakati wapedza. Sero rinofanira kuratidza nhamba zero.
5. Sarudza uye kopikesa sero mawakangopinda maitiro aya, kana kushandisa shanduro yebhokisi kana Hora -> Kopa kubva kumashiripiti eGoogle Sheets.
6. Kana kambani iyo yakakopiwa kubhodhibhodhi, sarudza ose masara aripo muNotangira Day column uye unyore uchishandisa nzira shoma yebhobhodhi kana Hora -> Nyora kubva kumashiripiti eGoogle Sheets. Kana ikakopihwa zvakanaka, Zuva Rinokosha kune rimwe nerimwe basa rinofanira kuratidza huwandu hwemazuva kubva pakutanga kweprojekti iyo yakagadzirirwa kutanga. Iwe unogona kuvimbisa kuti Start Day fomu mumutsetse wega wega wakarurama nekusarudza iyo inofanana nesero uye kuve nechokwadi kuti yakafanana neyomumiriri iyo inenge yakatorwa mudanho rechina nemumwe unoshamisa, asi iyo yekutanga (int (xx)) inoenderana nesero yakakodzera nzvimbo munzvimbo yako yekutanga tafura.
7. Izvo ndeye Total Durin column, iyo inofanira kuve nedzimwe shandura iyo inenge yakaoma kunzwisisa kupfuura yakapfuura. Nyora zvinotevera mu Total Duration chikamu chebasa rako rekutanga, uchishandura zvinyorwa zvemasero edzimba neaya anowirirana nefurafura yepasereti yako chaiyo (yakafanana nezvatakaita mudanho 4): = (int (B2) -in ($ A $ 2)) - (int (A2) -int ($ A $ 2)) . Hit Enter or Return key wakati wapedza. Kana uine mimwe nyaya inotarisa nzvimbo dzemazana dzinofanana nespredishiti yako, inotevera chigadzirwa chemafuta chinofanira kubatsira: (zuva rekuguma kwemabasa - zuva rekutanga remushandi) - (zuva rekutanga remabasa - zuva rekutanga remushandi).
8. Sarudza uye kopikesa sero mawakangopinda maitiro aya, kana kushandisa shanduro yebhokisi kana Hora -> Kopa kubva kumashiripiti eGoogle Sheets.
9. Kana imwe shanduro yakanyoreswa kubhodhibhodhi, sarudza ose masere masara mu Total Durin column uye paste nekushandisa nzira shoma yebhobhodhi kana Hora -> Nyora kubva kumashizha eGoogle Sheets. Kana ikakopihwa zvakanaka, iyo Yakawandisa Nguva yakakosha yega yega yega inofanira kuratidzira mazuva ose ezuva pakati pezuva rakatangira uye yekupedzisira.

03 of 03

Kugadzira Gantt Chart

Iye zvino kuti mabasa ako ari munzvimbo, pamwe chete nemazuva avo akafanana uye nguva, ndiyo nguva yekuumba Gantt chati.

1. Sarudza masero ose mukati mefurafura yekuverenga, kusanganisira musoro.
2. Sarudza mukana wokuisa muGoogle Sheets menyu, iyo iri kumusoro kwekona zvakananga pasi pechihloko chebasa. Apo mhando inodonha ichioneka, sarudza Chati .
3. Ichati chitsva chichaonekwa, chinonzi Start Day uye Total Duration . Sarudza chati ichi uye uchikudze kuitira kuti chiratidziro chayo chigare pasi kana kuti kurutivi-ne-kurutivi mahwendefa awakasika, kusiyana nekuaputira.
4. Mukuwedzera kune chati yako itsva, Chati Edhari yehupiritsi ichaonekwawo kuruoko rworudyi rwekrini chako. Sarudza Chati rudzi , runowanikwa kumusoro kweDATA DATA .
5. Tora pasi kusvika kuChikamu cheBarari uye sarudza sarudzo yepakati, Dhairiro yebhasi chati . Iwe uchacherechedza kuti urongwa hwechati yako hwakashanduka.
6. Sarudza Bhuku reCUSTOMIZE muChart Editor .
7. Sarudza Mutsara weChikamu kuitira kuti uwe uye unoratidza zvirongwa zviripo.
8. MuApply kudonha-pasi, sarudza Start Day .
9. Dzvanya kana tapota Ratidza mararudzo uye sarudza Hapana .
10. Iko Gantt yako chati ikozvino yakasikwa, uye iwe unogona kutarisa munhu wekutanga Start Day uye Total Durin mifananidzo kuburikidza nekukwira pamusoro pezvikamu zvavo mukati memufananidzo. Iwe unogonawo kuita chero humwe huri kugadzirisa hwaunoda kuburikidza neChart Editor - uyewo kuburikidza nematafura atakasika - kusanganisira mazuva, mazita emabasa, musoro, ruvara rwekamu nezvimwe. Kushanda-kwese kwese mukati mechati pachako pachako kuchazarura MUTEI yemenyu, ine zvigadziro zvinogadziriswa.