Ukusuka kwi-Excel ukuya kwiSoftware ye-Civil: Isikhokelo

Iikontraka ezininzi ze-civil zaseMzantsi Afrika ziqhuba incwadi yee-odolo ye-R100,000,000 kwifolda yee-spreadsheet eziqondwa yi-QS enye kuphela. Kuyasebenza de kungasebenzi. Ukuphinda kulinganiswe akuhambelani nesatifikethi. Iphepha loomatshini liphosa iiveki ezintathu zeeyure. Okanye injineli ehlala esizeni ibuza ngotshintsho lweenyanga ezisibhozo ezidlulileyo, kwaye akukho mntu ukwaziyo ukufumana inguqulelo oyingenisileyo.

Esi sikhokelo sicacisa apho i-Excel isilela khona kwisiza se-civil nendlela yokufudukela kwisoftware yolwakhiwo inyathelo ngenyathelo ngaphandle kokulahlekelwa yidatha yakho. Sikwagubungela oko ufanele ukugcine kwi-Excel emva koko. Sibhalelwe abaphathi beekhontrakthi, ii-QS nabalawuli kwiifemu ze-CIDB CE ibakala 5 ukuya ku-9.

Kutheni Iikontraka ze-Civil Zisasebenzisa i-Excel?

I-Excel iphumelele kwiisiza ze-civil kuba ibiguquguquka, ingabizi kwaye sele ifakiwe, kwaye uninzi lwezinye iindlela belungawuqondi umsebenzi we-civil. Iikhontrakthi ze-civil ziphinda zilinganiswe nge-chainage, zisebenza nge-GCC okanye i-NEC kwaye zenza okanye zilahlekelwe yimali ngoomatshini. Uninzi lwesoftware yezakhiwo aluzange luyilelwe nanye kwezi zinto, ngoko iqela lezorhwebo lazakhela ezalo ii-workbook.

Isoftware yezakhiwo idla ngokuyilwa ngokweekhontrakthi ze-JBCC nenkqubela ngomgangatho okanye ngeyunithi. Indlela okanye umbhobho omkhulu wamanzi usebenza nge-GCC (i-General Conditions of Contract ye-SAICE) okanye i-NEC endaweni yoko.

I-Excel sisixhobo esihle. Ingxaki kukuba ikhontrakthi ye-civil esaqhubekayo yirekhodi ekwabelwana ngayo nephicothwayo ehlala iminyaka. I-spreadsheet yifayile yomntu.

I-Excel Isilela Phi Kwisiza se-Civil?

I-Excel isilela kwiindawo ezintandathu ezifanayo phantse kuyo yonke ikhontrakthi ye-civil: ukuphinda kulinganiswe, oomatshini nedizili, izatifikethi zentlawulo, iisiza ezininzi ngaxeshanye, iinguqulelo zeefayile nomsebenzi offline. Nganye ibiza imali kunye nexesha. Ukuba uyaziqonda ezintathu nangaphezulu kwiikhontrakthi zakho, ii-spreadsheet zakho zithwele umngcipheko omkhulu kunofanelekileyo.

Apho isilela khona	Okwenzekayo kwi-Excel	Oko kukubizayo
Ukuphinda kulinganiswe nge-chainage	Ubungakanani bukwi-workbook enye, i-BOQ kwenye, isatifikethi kweyesithathu. Amakhonkco aqhawuka xa umntu efaka imiqolo	Ubungakanani obubangwe ngaphantsi, okanye amabango angaphezulu anqunyulwa yinjineli ize ingathembi
Oomatshini nedizili	Ukufundwa kweemitha zeeyure neziliphu zedizili kubhalwa ngeveki kusuka ephepheni, ukuba kuyenziwa	Ukusetyenziswa ongakwaziyo ukukungqina, amazinga okuqesha angaphakathi angakholelwayo, ilahleko yedizili engabonwayo
Izatifikethi ze-GCC ne-NEC	Imali egciniweyo, imali eqhubela phambili (advances), utshintsho nohlengahlengiso lwexabiso lekhontrakthi zikwiifomula ezakhiwe ngesandla	Iseli enye engalunganga idluliselwa nyanga nganye de uphicotho luyifumane
Iisiza ezininzi ngaxeshanye	Umphathi wesiza ngamnye usebenzisa itemplate eyahluke kancinci	Abalawuli babona kuphela ukuba yeyiphi ikhontrakthi elahlekelwa yimali ekupheleni kwenyanga, okanye kamva
Iinguqulelo	”Cert 14 FINAL v3 (Thabo edits).xlsx” kumtya we-imeyile	Akukho mntu unokungqina into eyangeniswa xa umthengi karhulumente ebuza kwiminyaka emibini kamva
Offline nokucinywa kombane	Iifayile zikwilaptop enye yesiza kwaye zihamba nge-memory stick okanye nge-WhatsApp	Iidayari ezilahlekileyo, imiyalelo yesiza engekhoyo, ukubhala kabini xa iofisi ibamba

Uvavanyo lophicotho. Khetha isatifikethi owasingenisa kumasipala kwiinyanga ezili-18 ezidlulileyo. Ungabonisa, ngaphantsi kwemizuzu elishumi, ubungakanani obulinganisiweyo, imiyalelo yesiza esayiniweyo nokuvunywa kotshintsho emva komgca ngamnye? Ukuba impendulo ixhomekeke kwilaptop yomntu omnye, iirekhodi zakho aziyi kumelana xa abaphicothi bomthengi befika.

Utshintsho ludinga isilumkiso salo. Phantsi kwe-GCC 2025, umyalelo womlomo asiyo-variation order. Ngumyalelo obhaliweyo kuphela, oqinisekiswe yikontraka, obalwayo. Isaziso sebango nebango elineenkcukacha nazo zinamaxesha ahlukeneyo (jonga isikhokelo sethu se-GCC 2015 xa ithelekiswa ne-GCC 2025 kwizatifikethi zentlawulo). Ukuba uphosa umhla wokugqibela usemngciphekweni we-time bar, okuthetha ukuba unokulahlekelwa lilungelo lokubanga. I-spreadsheet ayikulumkisi. Irekhoda nje, emva kwexesha, ukuba uphosile. Kwiikhontrakthi ze-NEC, umngcipheko ofanayo usebenza kwisaziso seeveki ezisibhozo see-compensation events ze-NEC.

Umlinganiselo yenye indawo ebuthathaka. Isikhokelo sethu sokuphinda kulinganiswe nge-chainage sibonisa indlela yokulandelela bonke ubungakanani ukuya kwiphepha elisayiniweyo, kwaye isikhokelo sethu senkqubo yesatifikethi sentlawulo se-GCC sichaza umjikelo wenyanga ondliwa bobo bungakanani.

Phambi Kokuba Ufuduke: Yazi Into Onayo

Qala ngoluhlu olunyanisekileyo lwee-spreadsheet zakho, kuba awunakufudusa into ongayenzanga imephu. Dwelisa yonke i-workbook esebenzayo nomnini wayo, injongo, ukuphindaphindwa, amangeniso nomngcipheko. Emva koko zahlule zibe ziirekhodi zekhontrakthi, idatha yokusebenza nohlalutyo. Ngamaqela amabini okuqala kuphela afuna ukufuduswa.

Ikontraka yebakala 7 eneekhontrakthi ezine ezisebenzayo ingaba neefayile ezisebenzayo ezingama-40 nangaphezulu ngokulula.

Yenza uluhlu lweeveki ezimbini. Kuyo yonke i-workbook esetyenziswayo, rekhoda:

Umnini: ngubani oyihlaziyayo nongubani othembele kuyo.
Injongo: umlinganiselo, isatifikethi, oomatshini, ingxelo yeendleko, ukuhamba kwemali, ithenda, i-HSE.
Ukuphindaphindwa: yonke imihla, ngeveki, ngenyanga okanye kanye ngekhontrakthi.
Amangeniso neziphumo: apho idatha ivela khona nalapho iya khona (umthengi, umlawuli, iphakheji yakho yokubala imali).
Umngcipheko: kwenzeka ntoni ukuba ayichanekanga okanye ilahleke iveki.

Emva koko hlela uluhlu lube ngamaqela amathathu:

Iirekhodi zekhontrakthi: i-BOQ, umlinganiselo, izatifikethi, utshintsho, iidayari zesiza.
Idatha yokusebenza: oomatshini, ii-timesheet, iivenkile, idizili.
Uhlalutyo: iimodeli ze-what-if, amaxabiso eethenda, uqikelelo lokuhamba kwemali.

Ufudusa amaqela amabini okuqala. Iqela lesithathu lidla ngokulunga apho likhona.

Ufuduka Njani Ukusuka kwi-Excel ukuya kwiSoftware ye-Civil?

Ufuduko olulungileyo luhambisa ikhontrakthi enye ngexesha, luqhuba ngokunxuseneyo ixesha elifutshane elimiselweyo, kwaye lunomnini onegama onokuthi hayi. Coca idatha yakho yesalathiso, zama ikhontrakthi enye, ngenisa i-BOQ enamaxabiso, qhuba umjikelo omnye okanye emibini yesatifikethi ecaleni, emva koko fudusa isiza uze usasaze ikhontrakthi ngekhontrakthi. La manyathelo asixhenxe angezantsi abonisa indlela.

Inyathelo 1: Coca idatha yakho yesalathiso

Isoftware ilunge kuphela njengedatha yesalathiso oyilayishayo, ngoko yilungise phambi kokuba ungenise nantoni na. Vumelanani ngoluhlu olunye lweekhowudi zeendleko nerejista enye yoomatshini eneenombolo zeenqwelo namazinga okuqesha angaphakathi. Yongeza uluhlu olunye lwee-subcontractor nabathengisi, neeyunithi ezisemgangathweni zento nganye ye-BOQ. Nika iiveki ezimbini ukuya kwezine.

Ii-timesheet noluhlu lwabathengisi zikwaneenkcukacha zobuqu, njengeenombolo ze-ID neenombolo zefowuni. Phantsi kwe-POPIA (i-Protection of Personal Information Act), uhlala unoxanduva lwaloo datha xa umboneleli wesoftware eyigcinela wena. Amacandelo 19 ukuya ku-21 ajongana nokhuseleko nekhontrakthi ebhaliweyo naloo mboneleli. Fudusa kuphela into osayidingayo.

Inyathelo 2: Khetha ikhontrakthi yovavanyo efanelekileyo

Khetha uvavanyo olwaneleyo ukungqina isoftware, kodwa olungabalulekanga kangangokuba impazamo yenzakalise ishishini. Olona vavanyo lulungileyo yikhontrakthi esandula ukuwongwa okanye ekwikota yayo yokuqala. Inenjineli ehlala esizeni esebenzisanayo kwaye isebenzisa ifomu yekhontrakthi oyaziyo kakuhle, ihlala i-GCC 2015 okanye i-GCC 2025. Phepha ikhontrakthi ekwingxabano okanye esele iinyanga ezimbini ukuya ekugqityweni ngokwenyani (practical completion).

Inyathelo 3: Layisha i-BOQ nemeko yokuqala

Ngenisa i-BOQ enamaxabiso endaweni yokuyibhala kwakhona, emva koko layisha imeko yokuqala ngomhla ocacileyo wokunqumla. Emva koko layisha ubungakanani obulinganisiweyo ukuza kuthi ga ngoku, izatifikethi ezihlawulweyo, imali egciniweyo, utshintsho oluvunyiweyo namabango avulekileyo. Hambelanisa itotali yokuqala nesixa sokugqibela esiqinisekisiweyo, ukuya kutsho kwirandi, phambi kokuba uqhubeke.

Inyathelo 4: Qhuba ngokunxuseneyo, ngomhla wokugqibela

Qhuba i-spreadsheet nesoftware ecaleni umjikelo omnye okanye emibini yesatifikethi, emva koko uvale i-Excel. Vumelanani ngomgaqo kwangaphambili. Ukuba isatifikethi sesibini siyahambelana ngaphakathi komda wokunyamezela ovunyelwene ngawo, i-Excel iba yeyokufunda kuphela kuloo khontrakthi.

Inyathelo 5: Fudusa isiza, hayi iofisi kuphela

Utshintsho luzinza kuphela xa iqela lesiza libhala idatha emthonjeni, okuthetha ukusebenza offline. Iidayari zemihla ngemihla, iiyure zoomatshini, ukukhutshwa kwedizili, abasebenzi nobungakanani nge-chainage kufuneka kufakwe esizeni. Idatha emva koko ihambelana xa isignali ibuya. Qeqesha oofolomani nababhali boomatshini kuqala.

Inyathelo 6: Sasaza ikhontrakthi ngekhontrakthi

Xa uvavanyo luqhube imijikelo emibini ecocekileyo, sasaza kwiikhontrakthi ezintsha kuqala nakwezikhoyo kwikhefu lendalo. Musa ukufudusa ikhontrakthi esembindini webango. Ngale ndlela ifemu yebakala 7 eqhelekileyo ingafudusa ipotifoliyo yayo yonke kwiinyanga ezintathu ukuya kwezintandathu, sonke isatifikethi sikumjikelo waso oqhelekileyo.

Inyathelo 7: Misela ulawulo uze utshixe iifayile ezindala

Gqiba ukuba ngubani omnini werekhodi nganye kwinkqubo entsha, emva koko ugcine ii-workbook ezindala njengezokufunda kuphela. Biza umnini wenkqubo ngegama, ihlala i-QS ephezulu okanye umphathi weekhontrakthi. Misela iindima zabasebenzisi uze nivumelane ngokuba ngubani ovuma utshintsho nezatifikethi. Gcina iifayile ze-Excel kwindawo enye, nenqaku elithi idatha ekhoyo ngoku iphi.

Musa ukucima iifayile ezindala. Iirekhodi zokubala imali ziwela phantsi kwecandelo 24 le-Companies Act (ngokubanzi iminyaka esixhenxe) necandelo 29 le-Tax Administration Act (ngokubanzi iminyaka emihlanu emva kokungeniswa kwe-return). Buza umphicothi wakho ukuba zeziphi ii-workbook ezibalwayo.

Usaqinisekisa ikhontrakthi ye-civil ukusuka kwii-workbook ezintlanu ezidityanisiweyo? ISakha igcina i-BOQ yakho, umlinganiselo nenkqubela, izatifikethi zentlawulo, iirekhodi zoomatshini nedayari yesiza esebenza offline kwisoftware enye ye-cloud eyakhelwe iikontraka ze-civil zaseMzantsi Afrika: bona idemo yemveliso.

Loluphi Uhlobo LweSoftware Olufanele Lutshintshe i-Excel?

Uhlobo lwesixhobo olukhethayo lugqiba ukuba ingakanani into yomsebenzi wakho we-civil ephuma kwi-Excel, kwaye uninzi lokhetho lugubungela inxalenye yawo kuphela. Ii-app zesiza ziphatha iifoto nee-snag, iisuite zedesktop ziphatha uqikelelo, kwaye yisoftware ekhethekileyo ye-civil kuphela ephatha ukuphinda kulinganiswe, oomatshini nezatifikethi ze-GCC okanye ze-NEC kwirekhodi enye. Vavanya ukhetho ngalunye kwikhontrakthi yakho phambi kokuba ukhethe.

Buza bonke abathengisi imibuzo efanayo, uyivavanye kwi-BOQ yakho, uze uthelekise iimpendulo ngokubhaliweyo.

Into oyidingayo	Excel	Isuite yoqikelelo yedesktop	I-app yeprojekthi okanye yesiza eqhelekileyo	Isoftware ye-cloud ekhethekileyo ye-civil
Ukuphinda kulinganiswe nge-chainage	Ngesandla, kuyaphuka	Inxenye, eofisini kuphela	Ayakhelwanga oko	Yakhelwe ngaphakathi
Izatifikethi ze-GCC ne-NEC	Iifomula ezakhiwe ngesandla	Zidla ngokuba sezitemplate ze-Excel	Akukho fomu zekhontrakthi zasekhaya	Zakhelwe ngaphakathi
Oomatshini, idizili namazinga okuqesha	Ngesandla	Kulinganiselwe	Kunqabile	Kwakhelwe ngaphakathi
Ukuqokelela esizeni offline	Iifayile zasekhaya kuphela	Ibotshelelwe kwidesktop	Idla ngokwenjenjalo	Ewe
Abasebenzisi bangaphandle (injineli, umthengi)	Izihlomelo ze-imeyile	Izihlalo ezongezelelweyo	Idla ngokwenjenjalo	Iportal yomthengi neyenjineli
Ixesha lokuqalisa	Sele ifakiwe	Iiveki, nokufakwa	Iintsuku	Iintsuku

Ii-app zesiza zomelele kwiifoto nee-snag kodwa azenzi isatifikethi se-GCC. Iisuite zedesktop zibeka amaxabiso kakuhle kodwa zishiya ukuphinda kulinganiswe noomatshini kwii-spreadsheet. Isoftware yolwakhiwo lwe-civil eyakhelwe iikhontrakthi zaseMzantsi Afrika iphatha intambo yonke kwirekhodi enye ye-cloud, ukusuka kubungakanani obulinganisiweyo ngeendleko zoomatshini ukuya kwisatifikethi sentlawulo. Isikhokelo sethu sesoftware yobunjineli boluntu eMzantsi Afrika sigubungela yonke imigaqo yokukhetha.

Uluhlu Lokujonga Ufuduko

Sebenzisa olu luhlu lokujonga ukuze ufuduko luhlale endleleni lungamisi phakathi. Phawula into nganye phambi kokuba uye kwisigaba esilandelayo.

Uluhlu lugqityiwe: yonke i-workbook esebenzayo idweliswe nomnini, injongo nomngcipheko.
Idatha yesalathiso icociwe, kwaye kufuduswe kuphela iinkcukacha zobuqu ozidingayo.
Ikhontrakthi yovavanyo ikhethiwe kwaye injineli ehlala esizeni yaziswe.
I-BOQ enamaxabiso ingenisiwe, ayibhalwanga kwakhona, kwaye ijongwe umgca ngomgca.
Ukuqhuba ngokunxuseneyo kulinganiselwe kumjikelo omnye okanye emibini yesatifikethi, nomhla wokuphela obhaliweyo.
Iqela lesiza liqeqeshiwe ekuqokeleleni offline nasekuhambelaniseni.
Isatifikethi sokuqala esivela kwisoftware sijongwe ngokuchasene namagama asemthethweni e-GCC okanye e-NEC.
Iindima nokuvunywa kumiselwe utshintsho, amabango nezatifikethi.
Ii-workbook ezindala zigcinwe njengezokufunda kuphela, nesalathiso esiya kwirekhodi esebenzayo.
Ukukhutshwa kwedatha kuvavanyiwe, ukuze wazi ukuba ungazikhupha iirekhodi zakho.

Yintoni Ofanele Uyigcine kwi-Excel?

I-Excel isesona sixhobo silungileyo sohlalutyo lwexesha elinye, ngoko yigcinele ukucinga uze uyikhuphe ekugcineni iirekhodi. Gcina iimodeli ze-what-if zeethenda, iimeko zokuhamba kwemali nee-pivot kwidatha ekhutshiweyo. Fudusa nantoni na eya kusayinwa, iqinisekiswe, iphicothwe okanye kuthenjelwe kuyo ngomnye umntu kwinkqubo ekwabelwana ngayo enomkhondo wophicotho.

Ukwahlulwa okusempilweni kubonakala ngoluhlu:

Gcina kwi-Excel: iimodeli ze-what-if zeethenda, iimeko zokuqala zokuhamba kwemali, uphononongo lwemveliso lwexesha elinye, ii-pivot kwidatha ekhutshiweyo namanqaku obuqu.
Fudusela kwisoftware: i-BOQ nokuphinda kulinganiswe, izatifikethi, utshintsho namabango, iidayari zesiza, iiyure zoomatshini nedizili, ii-timesheet zabasebenzi, iivenkile nokuthenga, iirejista ze-HSE ne-EMP (inkqubo yolawulo lokusingqongileyo).

Umgaqo olula: ukuba umntu ongengombhali uya kusayina, aqinisekise, aphicothe okanye athembele kwirekhodi, ifanele kwinkqubo ekwabelwana ngayo enomkhondo wophicotho. Khupha kwisoftware, hlalutya kwi-Excel, kwaye ungaze uncamathisele isiphumo emva njengeyona ngundoqo.

Imibuzo Ebuzwa Rhoqo

Yintoni isoftware yolwakhiwo lwe-civil?

Yisoftware eqhuba irekhodi yezorhwebo neyesiza yekhontrakthi ye-civil. Oko kuquka i-BOQ, ukuphinda kulinganiswe, izatifikethi zentlawulo, utshintsho, oomatshini, abasebenzi needayari zesiza. Ngokungafaniyo ne-spreadsheet, igcina irekhodi enye ekwabelwana ngayo enomkhondo wophicotho. I-QS, isiza nomlawuli bonke basebenza ngamanani afanayo.

Singafuduka embindini wekhontrakthi esaqhubekayo?

Ewe, kodwa khetha umhla wokunqumla ocacileyo, ngokuqhelekileyo kwangoko emva kokuhlawulwa kwesatifikethi. Layisha imeko yokuqala, uyihambelanise nesixa sokugqibela esiqinisekisiweyo, uze uqhube umjikelo omnye ngokunxuseneyo. Phepha ukutshintsha ikhontrakthi esembindini webango okanye wengxabano.

Kuthatha ixesha elingakanani ukufuduka ukusuka kwi-Excel ukuya kwisoftware ye-civil?

Kwifemu ye-CIDB CE ibakala 6 okanye 7, cwangcisa iiveki ezimbini ukuya kwezine zedatha yesalathiso nomjikelo omnye okanye emibini yesatifikethi wovavanyo. Ukufudusa ipotifoliyo yonke emva koko kuthatha iinyanga ezintathu ukuya kwezintandathu, ikhontrakthi ngekhontrakthi. Ukucocwa kwedatha kudla ngokuthatha ixesha elide kunokusetwa kwesoftware.

Ingaba i-Excel isamkelekile kwizatifikethi ze-GCC?

I-GCC ayisichazi isixhobo. Umngcipheko ukubungqina. Imali egciniweyo, utshintsho namabango asasazeke kwii-workbook ezininzi kunzima ukuwangqina phantsi kophicotho. Nokuba usebenzisa siphi isixhobo, jonga ingqiqo yesatifikethi sakho ngokuchasene namagama asemthethweni apapashwe yi-SAICE.

Isiphelo

Ukushiya i-Excel kuthetha ukuguqula iifayile zobuqu zibe yirekhodi yekhontrakthi ekwabelwana ngayo. Loo rekhodi kufuneka isinde kuphicotho, kutshintsho lwabasebenzi nakwingxabano. Qala ngoluhlu uze ucoce idatha yakho yesalathiso. Zama ikhontrakthi enye enesiphelo esiqinileyo sokuqhuba ngokunxuseneyo, uze wenze isiza sibhale idatha emthonjeni. Gcina i-Excel yokucinga nokwenza iimodeli. Fudusa yonke into esayinwayo, eqinisekiswayo okanye ephicothwayo kwinkqubo enye. Iifemu ezenza oku zikhawuleza zibone ukuba zeziphi iikhontrakthi ezenza imali.

Izikhokelo ezinxulumeneyo: