Tinene kuti mukuyendetsa ma projekiti angapo okhala ndi bajeti zosiyanasiyana ndipo mukufuna kuwona mtengo wanu pa iliyonse yaiwo. Ndiye kuti, kuchokera patsamba loyambira ili:
.. pezani chonga ichi:
Mwanjira ina, muyenera kufalitsa bajeti pamasiku a polojekiti iliyonse ndikupeza tchati chosavuta cha polojekiti ya Gantt. Kuchita izi ndi manja anu ndiatali komanso otopetsa, ma macros ndi ovuta, koma Kufufuza Mphamvu kwa Excel muzochitika zotere kumawonetsa mphamvu zake mu ulemerero wake wonse.
Kufunsa Mphamvu ndi chowonjezera chochokera ku Microsoft chomwe chimatha kulowetsa deta ku Excel kuchokera pafupifupi gwero lililonse ndikulisintha m'njira zosiyanasiyana. Mu Excel 2016, chowonjezera ichi chamangidwa kale mwachisawawa, ndipo cha Excel 2010-2013 chikhoza kutsitsidwa kuchokera patsamba la Microsoft ndikuyika pa PC yanu.
Choyamba, tiyeni tisinthe tebulo lathu loyambirira kukhala tebulo la “nzeru” posankha lamulo Pangani ngati tebulo tsamba Kunyumba (Kunyumba - Pangani Monga Table) kapena mwa kukanikiza njira yachidule ya kiyibodi Ctrl+T :
Kenako pitani ku tabu Deta (ngati muli ndi Excel 2016) kapena pa tabu Kufunsa Mphamvu (ngati muli ndi Excel 2010-2013 ndipo mudayika Power Query ngati chowonjezera) ndikudina batani la From Table / Range. :
Gome lathu lanzeru lakwezedwa mu Power Query query editor, pomwe gawo loyamba ndikukhazikitsa mawonekedwe a manambala pagawo lililonse pogwiritsa ntchito zotsikira pamutu wa tebulo:
Kuti muwerenge bajeti patsiku, muyenera kuwerengera nthawi ya polojekiti iliyonse. Kuti muchite izi, sankhani (gwirani pansi kiyi Ctrl) gawo loyamba chitsiriziro, Kenako Start ndikusankha gulu Onjezani gawo - Tsiku - Chotsani masiku (Onjezani Gawo - Tsiku - Chotsani masiku):
Zotsatira zake ndi 1 zochepa kuposa zofunikira, chifukwa tikuyenera kuyamba ntchito iliyonse tsiku loyamba m'mawa ndikumaliza tsiku lomaliza madzulo. Chifukwa chake, sankhani mzere wotsatira ndikuwonjezera gawo kwa iyo pogwiritsa ntchito lamulo Sinthani - Standard - Add (Sinthani - Wokhazikika - Onjezani):
Tsopano tiyeni tiwonjezere gawo lomwe timawerengera bajeti ya tsiku. Kuti muchite izi, dinani pa tabu Onjezani Column sindimasewera Mzati mwamakonda (Mndandanda Wamakonda) ndipo pazenera lomwe likuwoneka, lowetsani dzina la gawo latsopanolo ndi chilinganizo chowerengera, pogwiritsa ntchito mayina amipingo pamndandanda:
Tsopano mphindi yobisika kwambiri - timapanga gawo lina lowerengedwa ndi mndandanda wa masiku kuyambira koyambira mpaka kumapeto ndi sitepe ya tsiku limodzi. Kuti muchite izi, dinaninso batani Mzati mwamakonda (Mndandanda Wamakonda) ndikugwiritsa ntchito chilankhulo chomangidwira cha Power Query M, chomwe chimatchedwa List.Madeti:
Ntchitoyi ili ndi zifukwa zitatu:
- tsiku loyambira - kwa ife, latengedwa kuchokera pamzati Start
- chiwerengero cha masiku oti apangidwe - kwa ife, ichi ndi chiwerengero cha masiku a polojekiti iliyonse, yomwe tidawerengera kumayambiriro kwa gawoli. Kuchotsera
- sitepe ya nthawi - yokhazikitsidwa ndi mapangidwe #nthawi(1,0,0,0), kutanthauza m'chinenero cha M - tsiku limodzi, ziro maola, mphindi ziro, masekondi ziro.
Pambuyo pang'anani OK timapeza mndandanda (Mndandanda) wamadeti, womwe ungakulitsidwe kukhala mizere yatsopano pogwiritsa ntchito batani lomwe lili pamutu wa tebulo:
... ndipo timapeza:
Tsopano chomwe chatsala ndikugwetsa tebulo, kugwiritsa ntchito madeti opangidwa ngati mayina amizere yatsopano. Gululi ndilomwe likuchita izi. Tsatanetsatane wagawo (Pivot Column) tsamba Sintha (Sinthani):
Pambuyo pang'anani OK timapeza zotsatira pafupi kwambiri ndi zomwe tikufuna:
Null, pakadali pano, ndi analogue ya cell yopanda kanthu mu Excel.
Zimatsalira kuchotsa zipilala zosafunikira ndikutsitsa tebulo lotsatira pafupi ndi deta yoyambirira ndi lamulo Tsekani ndikutsegula - Tsekani ndikulowetsani… (Tsekani & Kwezani — Tsekani & Kwezani ku…) tsamba Kunyumba (Kunyumba):
Timapeza chifukwa:
Kukongola kokulirapo, mutha kusintha mawonekedwe amatebulo anzeru omwe atuluka pa tabu Constructor (Kapangidwe): khazikitsani mtundu umodzi, zimitsani mabatani osefera, yambitsani ziwopsezo, ndi zina zotero. Kuphatikiza apo, mutha kusankha tebulo lokhala ndi madeti ndikuwunikira nambala yake pogwiritsa ntchito masanjidwe okhazikika pa tabu. Kunyumba - Mapangidwe Okhazikika - Masikelo amitundu (Kunyumba - Mapangidwe Okhazikika - Masikelo amitundu):
Ndipo gawo labwino kwambiri ndilakuti m'tsogolomu mutha kusintha zakale kapena kuwonjezera mapulojekiti atsopano patebulo loyambirira, kenako ndikusintha tebulo loyenera ndi madeti ndi batani lakumanja la mbewa - ndipo Power Query ibwereza zonse zomwe tachita zokha. .
Voilà!
- Tchati cha Gantt mu Excel pogwiritsa ntchito mawonekedwe okhazikika
- Kalendala yofunika kwambiri ya polojekiti
- Kupanga Mizere Yobwerezedwa Ndi Mphamvu Yofunsa