Daga cikin nau'i-nau'i iri-iri da za a iya gina ta amfani da shirin Microsoft Excel, dole ne a nuna alamar Gant. Alamar shinge ne a kwance, a kan gindin kwance, wanda aka samo lokaci. Tare da taimakon wannan, yana da matukar dacewa don ƙididdigewa, da kuma ƙayyade ido, lokaci na lokaci. Bari mu kwatanta yadda za'a gina gantt a cikin Microsoft Excel.
Yin ginshiƙi
Don nuna ka'idojin ƙirƙirar Gantt mafi kyawun misali. Don yin wannan, muna karɓar tebur na ma'aikata na kamfanin, wanda ranar da aka saki su a iznin, da kuma kwanakin kwanakin da suka cancanta. Domin hanyar da za a yi aiki, yana da mahimmanci cewa ginshiƙan da aka sanya sunayen ma'aikatan basu da damar. Idan an cancanta, sai a cire taken.
Da farko, mun gina ginshiƙi. Don yin wannan, zaɓi yankin na teburin, wanda aka ɗauka a matsayin tushen don gina. Jeka shafin "Saka". Danna kan maɓallin "Layin" a kan tef. A cikin jerin shafukan shafukan da ke bayyana, zaɓi kowane nau'in ma'auni wanda aka kafa. Alal misali, a cikin yanayinmu, wannan zai zama babban ma'auni na ma'auni tare da tarawa.
Bayan haka, Microsoft Excel ta haifar da wannan ginshiƙi.
Yanzu muna buƙatar yin jeri na farko na launin launi mai ganuwa don kawai kawai jere na nuna lokacin hutu yana bar a kan zane. Mu danna-dama a kan kowane ɓangare na ɓangare na wannan zane. A cikin mahallin mahallin, zaɓi abu "Tsarin jerin bayanai ...".
Jeka zuwa "Fill" section, sa'annan ka saita canji a kan "Ba a cika" abu ba. Bayan haka, danna kan maballin "Rufe".
Bayanan da ke cikin zane yana kasa kasa, wanda ba shi da matukar dacewa don bincike. Za mu yi kokarin gyara shi. Danna maɓallin linzamin maɓallin dama a kan axis inda sunayen ma'aikata suke. A cikin mahallin mahallin, je zuwa abu "Tsarin Hanya".
Ta hanyar tsoho, zamu sami zuwa sashen "Axis Parameters". Ya kawai muna bukatar. Saka alamar a gaban "Ƙa'idar tsari na Kategorien" darajar. Danna maballin "Rufe".
Ba a buƙatar labari a cikin Gantt ba. Saboda haka, don cire shi, zaɓi maɓallin linzamin kwamfuta tare da danna, kuma latsa maɓallin sharewa akan keyboard.
Kamar yadda kake gani, lokacin da sutura ya ɗauka ya wuce iyakokin kalandar. Domin ya ƙunshi kawai shekara-shekara, ko wani lokaci, danna kan axis inda aka samo kwanakin. A cikin menu da ya bayyana, zaɓa zaɓin "Tsarin Hanya".
A cikin shafin "Axis Parameters", a kusa da "Ƙananan darajar" da "Saitunan mafi girma", za mu sauya sauyawa daga yanayin "auto" zuwa yanayin "gyarawa". Mun saita a cikin windows masu dacewa da dabi'u na kwanakin da muke bukata. A nan, idan kuna so, za ku iya saita farashin babban rabo da matsakaici. Danna maballin "Rufe".
Domin a kammala ƙarshe da gyara Gantt ginshiƙi, kana buƙatar zo da sunan don shi. Je zuwa shafin "Layout". Danna maɓallin "Siffar Shafin". A cikin jerin da ya bayyana, zaɓar darajar "a saman ginshiƙi."
A cikin filin inda sunan ya bayyana, shigar da kowane suna wanda ya dace maka, wanda ya dace da ma'ana.
Hakika, yana yiwuwa a gudanar da ƙarin gyaran sakamakon da aka samo, daidaita shi don dace da bukatunku da dandanawa, kusan zuwa ƙarancin kariya, amma, a gaba ɗaya, shirin Gantt yana shirye.
Saboda haka, kamar yadda kake gani, gina Gantt ba shi da mahimmanci kamar yadda aka gani a farko. Ginin algorithm, wanda aka bayyana a sama, ba za a iya amfani dashi ba kawai don rikodin da kuma kula da hutu, amma kuma don warware matsalolin da yawa.
