Indlela yokwehlukanisa izindleko kuspredishithi (isifanekiso samahhala) — nalapho iyeka khona ukusebenza

Omunye endlini uthi “asikufake nje kuspredishithi.” Kuwumuzwa onengqondo: wonke umuntu uyazi ukuthi ispredishithi sisebenza kanjani, akekho okumele afake into, futhi izindleko zilula — irenti, i-inthanethi, ukuthenga, into eyodwa lapho omunye ekhokhela omunye. Umbuzo ukuthi leli khasi kufanele libukeke kanjani ukuze lisakwazi ukukhuluma iqiniso ngenyanga yesithathu, nemigqa engamashumi amane, lapho umuntu ebuza ukuthi ubani okweleta ini.

Impendulo yincwadi encane yamabhuku enamakhasi amathathu namafomula amabili. Ungakwazi ukulanda isifanekiso noma usakhe ngesandla ngemizuzu emihlanu. Nempendulo eqotho kuthi “ingabe sizosebenza” yile: ispredishithi sisebenza kahle kubantu ababili noma abathathu abehlukanisa cishe ngokulinganayo, futhi siphuka ezindaweni ezintathu ezibikezelekayo — izabelo ezingalingani, imali yesibili, nomzuzu lapho kunomuntu oyedwa kuphela osasibuyekeza.

Umugqa owodwa ngendleko ngayinye: imodeli yebhuku lamabhuku

Iphutha amakhasi amaningi enziwe ekhaya alenzayo ukulandelela amabhalansi — ikholomu eyodwa ngomuntu ngamunye, ethayiphwe ngesandla, elungiswe ngemva kokuthenga ngakunye. Enyangeni eyodwa akekho osethemba lelo khasi, ngoba akekho okwazi ukubona ukuthi inombolo ifike kanjani lapho.

Imodeli ehlalayo yibhuku lamabhuku: indleko ngayinye ingumugqa owodwa obhala amaqiniso amathathu — ubani okhokhile, malini, nokubani okuhlukaniselwe yena. Amabhalansi awalokothi abhalwe; akhishwa emigqeni ngefomula, ngakho inombolo ngayinye ibuyela emigqeni eyenzile, futhi okufakiwe okuphikisanwayo kulungiswa ngokulungisa umugqa owodwa.

Yiyona ndlela nayo yonke i-app yokwehlukanisa izindleko egcina ngayo idatha yakho. Ispredishithi umqondo ofanayo kuphela ukuthi ususiwe ubulula.

Amakhasi amathathu

Isifanekiso sinamathebhu amathathu. Uma uzakhela sona, wenze ngale ndlela.

1. People (abantu). Ikholomu A, igama elilodwa ngomugqa, ngaphansi kwesihloko. Konke okunye kukhomba kuloluhlu, ngakho bhala igama ngalinye ngendlela eyodwa futhi uwagcine emafushane.

2. Expenses (izindleko). Amakholomu amahlanu: Date (usuku), Description (incazelo), Paid by (okhokhile), Amount (inani), Split among (abahlukaniselwe). “Okhokhile” yigama elivela ekhasini lePeople. “Abahlukaniselwe” ingaba yi-all noma uhlu lwamagama ahlukaniswe ngokhefana — Thandi kokuthile uThandi kuphela akwelekayo, Sipho, Thandi kokuthile abantu ababili abakwehlukanisayo. Umugqa owodwa ngendleko ngayinye, omdala ngaphezulu; akekho oguqula umugqa ngaphandle kokulungisa iphutha.

3. Balances (amabhalansi). Umugqa owodwa ngomuntu ngamunye onezinombolo ezintathu: Paid (akufakile), Owes (isabelo sakhe kukho konke) ne-Net (akukhokhile kususwe akwelekayo), nomugqa wokuhlola obonisa ukuthi izinombolo zihlanganisa ziye kuzero. Uma zingahlanganisi, igama elithile libhalwe ngendlela engalungile ndawana thile.

Amafomula

Amakholomu amabili asizayo ekhasini le-Expenses enza umsebenzi. Ekholomu F, inani labantu abasesabelweni:

=IF(E2="all", COUNTA(People!A2:A50), LEN(E2)-LEN(SUBSTITUTE(E2,",",""))+1)

Kwi-all ibala ikhasi lePeople; ngaphandle kwalokho ibala okhefana bese yengeza okukodwa. Ekholomu G, isabelo somuntu ngamunye: =D2/F2. Gcwalisa kokubili kwehlele phansi.

Ekhasini leBalances, ngegama lomuntu ku-A2:

• Paid: =SUMIF(Expenses!C:C, A2, Expenses!D:D) — wonke amanani lapho ebengumkhokhi.
• Owes: =SUMIF(Expenses!E:E, "all", Expenses!G:G) + SUMIF(Expenses!E:E, "*"&A2&"*", Expenses!G:G) — isabelo sakhe kumugqa ngamunye we-all, nesabelo sakhe kumugqa ngamunye omqambayo.
• Net: =B2-C2. Okuhle kusho ukuthi iqembu limkweleta; okubi kusho ukuthi ukweleta iqembu.

Isexwayiso: uphawu lokuthola luthola negama ngaphakathi kwelinye elide, ngakho “Sipho” luhambisana no-”Siphokazi” futhi. Gcina amagama ehlukene, noma wengeze izibongo. Wonke amafomula lapha yi-SUMIF, i-COUNTA, i-LEN ne-SUBSTITUTE elula, ngakho ifayela lenza into efanayo kuGoogle Sheets, Excel neLibreOffice.

Isibonelo esibaliwe: indlu yabantu abathathu

USipho, uNomsa noThandi behlukanisa indlu. Ngenyanga eyodwa, ikhasi le-Expenses linemigqa emine:

Umugqa wokugcina yiwo othakazelisayo. USipho ukhokhele isitolo samabhayisikili ngoba ikhadi likaThandi lenqatshwa; kuyimalimboleko, akuyona indleko ehlanganyelwe, ngakho isabelo nguThandi kuphela. Ayikho into ekhethekile edingekayo.

Izabelo: imigqa emithathu ye-all inikeza umuntu ngamunye u-R10 000 + R300 + R800 = R11 100, futhi uThandi uphatha nokulungiswa kwe-R1 200, ngakho isabelo sakhe yi-R12 300. Okukhokhiwe: uSipho R31 200 (irenti nokulungiswa), uNomsa R900, uThandi R2 400. Ikhasi leBalances lifundeka kanje:

Womabili amasamba yi-R34 500 futhi izinombolo ze-Net zihlanganisa ziye kuzero, ngakho ikhasi liyavumelana. Ukuze nikhokhe: uNomsa ukhokhela uSipho u-R10 200 futhi uThandi ukhokhela uSipho u-R9 900. USipho uthola u-R20 100, inombolo yakhe ngqo. Ukudlulisa okubili, wonke umuntu usezero.

Ukubhala inkokhelo yokubuyisela, nokukhokha ngesandla

Lapho uNomsa ekhokhela uSipho u-R10 200, ungasusi lutho. Yengeza umugqa: “UNomsa ukhokhile”, umkhokhi uNomsa, inani R10 200, kuSplit among Sipho. I-Paid kaNomsa ikhuphuka nge-R10 200, i-Owes kaSipho ikhuphuka nge-R10 200, futhi zombili izinombolo zehlela lapho kufanele — uNomsa usezero, uSipho use-+R9 900. Inkokhelo yokubuyisela iyindleko nje umuntu oyedwa kuphela ozuzayo kuyo ngumuntu okhokhelwayo.

Into ikhasi elingayenzi ukukutshela ukuthi ubani okufanele akhokhele ubani. Ngabantu abathathu ukufunda ekholomu ye-Net. Ngabayisithupha nokuxubana kokuhle nokubi kuyinselelo encane: okubi kukhokhela okuhle, ngezinkokhelo ezimbalwa kunazo zonke. Indlela ukwenziwa lula kwezikweletu okusebenza ngayo ichaza lokho kuvumelanisa; kuspredishithi ukwenza ephepheni.

Lapho ispredishithi siyeka khona ukusebenza

Izinto ezintathu zisusa indlu, uhambo noma iqembu labangane ziyekufinyelela lokho isifanekiso esingakuphatha.

1. Izabelo ezingalingani. Isifanekiso sehlukanisa umugqa ngamunye ngokulinganayo phakathi kwabantu abaqanjiwe. Ngomzuzu umugqa uba yi-”USipho ukhokha amaphesenti angama-40 ngoba igumbi lakhe likhulu”, noma ibhili lendawo yokudlela lapho uThandi athatha ukudla okukodwa kuphela, ifomula ayisahambisani. Ungakwenza ngendlela yokuzungeza — umugqa owodwa ngesabelo ngasinye — kodwa yonke indlela yokuzungeza iyinto eyodwa eyengeziwe okumele umngane wasendlini ayikhumbule ngenyanga yesithathu. Zinhlanu izindlela zokwehlukanisa indleko, futhi ispredishithi senza eyodwa yazo.

2. Imali yesibili. Impelasonto yaphesheya yengeza umugqa ngemali ehlukile, futhi ikholomu ye-Amount ihlanganisa ama-euro namarandi buthule. Ungengeza ikholomu yezinga nekholomu yenani eliguqulwe, futhi manje umugqa ngamunye udinga izinga elithayiphwe ngesandla. Kuphila uhambo olulodwa, hhayi iqembu elinamalungu ahlala emazweni ahlukene. Ukwehlukanisa amabhili phakathi kwezimali ichaza ukuthi iqembu elinjalo lidingani.

3. Umnikazi oyedwa. Yilokhu okubulala amakhasi amaningi. Ispredishithi esihlanganyelwe ngokwezobuchwepheshe singahlelwa yiwo wonke umuntu, kodwa empeleni umuntu oyedwa unaso futhi abanye baphonsa amaslip engxoxweni yeqembu ukuze lowo muntu awathayiphe. Lapho umnikazi ematasa amasonto amabili, ibhuku lamabhuku lingelona iqiniso amasonto amabili, futhi akekho ongahlola ibhalansi yakhe esitolo. Inkinga akuyona isofthiwe; ukubuyekeza ispredishithi kungumsebenzi obhorayo futhi ukubhala indleko ngaleso sikhathi akunjalo.

Nini lapho ispredishithi kuyithuluzi elifanele

Yiba nobulungiswa kolunye uhlangothi. Abantu ababili abehlukanisa irenti namabhili ambalwa, noma abangane basendlini abathathu abehlukanisa cishe konke ngokulinganayo, isifanekiso siyabanela. Simahhala, sibonakala kuwo wonke umuntu, futhi sisazovuleka eminyakeni eyishumi. Uma izindleko zakho zibukeka njengesibonelo esibaliwe ngenhla, cishe awusoze wadinga okunye. Injongo yokulandelela ukuthi ubani okukweleta imali irekhodi elihlanganyelwe zombili izinhlangothi ezilethembayo, futhi ikhasi elakhiwe kahle lingelinye lawo. Ngerenti, amabhili nokuthenga, ukwehlukanisa irenti namabhili nabangane basendlini ichaza imikhuba egcina imigqa ilula.

Dlulela phambili lapho uzithola wengeza amakholomu asizayo, uguqula izimali, noma ukhumbuza umuntu oyedwa ukuthi asibuyekeze.

Lapho iDonget ingena khona

IDonget igcina ibhuku lamabhuku elifanayo nesifanekiso esiligcinayo — indleko ngayinye ineOkhokhile, inani nabantu eyehlukaniswe phakathi kwabo, futhi ithebhu ye-Bhalansi ikhipha inombolo ngayinye kuleyo migqa. Umehluko yizindawo ezintathu zokuhluleka ngenhla. Umugqa ungahlukaniswa Ngokulinganayo, nge-Nani, nge-Phesenti, nge-Ziphindaphindi (izabelo) noma into ngayinye nge-Zinto Namanani, ngakho izimo ezingalingani zicindezelo elilodwa esikhundleni sendlela yokuzungeza. Iqembu ngalinye linesethingi le-Mali, futhi indleko ingafakwa ngemali ehlukile. Futhi njengoba wonke umuntu engeza izindleko esuka kufoni yakhe futhi iqembu livumelaniswa ngesikhathi sangempela, akekho umnikazi okumele alindwe — i-Bhalansi yomuntu ngamunye ibonisa izinombolo ezifanayo kuwo wonke umuntu, futhi i-Khokha izikweletu isikisela ukudlulisa okumbalwa okuhlanza iqembu, ingxenye obuyenza ephepheni.

Abantu bajoyina nge-Silinki sesimemo. Ngendlu esesibonelweni, noma yiliphi ithuluzi liyawenza umsebenzi; ngohambo lwabantu abayisithupha nendlu ehlanganyelwe, ispredishithi yilapho izingxabano ziqala khona. Ukuze ukhethe ngamabomu, ama-app okwehlukanisa izindleko aqhathaniswa ibeka ukuthi i-app ngayinye yamahhala yenzani nokuthi ngayinye, kuhlanganise neDonget, ayanele kuphi.

Imibuzo evame ukubuzwa

Ingabe isifanekiso siyasebenza kuGoogle Sheets nakuExcel?

Yebo. Sisebenzisa i-SUMIF, i-COUNTA, i-LEN ne-SUBSTITUTE kuphela, ezenza into efanayo kuGoogle Sheets, Excel neLibreOffice Calc. Vula i-.xlsx ngqo kuExcel, noma uyilayishe kuGoogle Drive bese uyivula ngeSheets.

Ngiyifaka kanjani indleko eyehlukaniswa ngabantu abathile kuphela?

Bhala amagama, ehlukaniswe ngokhefana, ekholomu ethi Split among esikhundleni se-all — isibonelo Sipho, Thandi. Isabelo yinani elihlukaniswe ngenani lamagama afakiwe, futhi izinombolo ze-Owes zalabo bantu kuphela eziguqukayo.

Ingabe ispredishithi singayehlukanisa indleko ngokungalingani?

Hhayi ngqo: umugqa ngamunye wehlukaniswa ngokulinganayo phakathi kwabantu abaqanjiwe. Indlela yokuzungeza umugqa owodwa ngesabelo ngasinye nomkhokhi ofanayo — R800 kuSipho, R1 200 kuThandi. Kulungile kwesinye isikhathi; uma iningi lezindleko zenu lingalingani, dlulela kuthuluzi elinezabelo zamaphesenti nezento ngayinye.

Ngiyibhala kanjani inkokhelo yokubuyisela?

Njengomugqa: umkhokhi ngumuntu obuyiselayo, inani, nomuntu okhokhelwayo njengegama elilodwa kuphela kuSplit among. Zombili izinombolo ziyanyakaza futhi umlando uhlala uphelele. Ungalokothi ususe noma uguqule umugqa omdala ukukhombisa inkokhelo.

Sikuthola kanjani ukuthi ubani okhokhela ubani?

Funda ikholomu ethi Net. Izinombolo ezimbi zikhokhela izinombolo ezinhle kuze kube yilapho wonke umuntu esezero; ngabantu abathathu kusobala, ngabayisithupha kuthatha imizuzu embalwa ephepheni. Ispredishithi ngeke sisikisele ukudlulisa imali.

Ingabe ispredishithi sanele endlini ehlanganyelwe?

Kubantu ababili noma abathathu abehlukanisa cishe ngokulinganayo ngemali eyodwa, yebo, inqobo nje uma othile eqhubeka esibuyekeza. Siyeka ukwanela lapho izabelo zingalingani, imali yesibili ivela, noma kunomuntu oyedwa kuphela osabhala izindleko.

Isiphetho

Ispredishithi esibhala ukuthi ubani okhokhile, malini nokuthi kubani — futhi esikhipha amabhalansi esikhundleni sokuwathayipha — kuyindlela enhle ngempela kubantu ababili noma abathathu ukwehlukanisa izindleko ngokulinganayo, futhi isifanekiso sikunika lokho ngokulanda okukodwa. Bheka izimpawu ezintathu zokuthi sesikhulile kunomsebenzi: izabelo ezingalingani, imali yesibili, nomuntu oyedwa owenza konke ukuthayipha.

Landa iDonget mahhala bese ugcina ibhuku lamabhuku elifanayo kufoni kawo wonke umuntu, nezabelo ezingalingani, izimali nokukhokha okukhishelwe wena.