USU  ››  Mapulogalamu opangira mabizinesi  ››  Pulogalamu yachipatala  ››  Malangizo a pulogalamu yachipatala  ›› 

Makhalidwe abwino

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa taphunzira phatikizani tchati chonse kuti muwone zofunikira kwambiri.

Mtengo wapakati

Mutha kusanja zomwe zili zofunika. Kuti tichite izi, tiyeni tilowe mu module "Odwala" pa kolamu "Ndalama zonse zomwe zagwiritsidwa ntchito" pezani mtengo wapakati. Kuti mudziwe bwino kuchuluka kwa ndalama zomwe wodwala wamba amagwiritsa ntchito kuchipatala chanu. Kuti tichite izi, timapita ku lamulo lomwe tikudziwa kale "Conditional Formating" .

Chonde werengani chifukwa chake simungathe kuwerenga malangizowo mofanana ndikugwira ntchito pawindo lomwe likuwonekera.

Ngati mukadali ndi malamulo okonza kuchokera ku zitsanzo zam'mbuyomu, chotsani onse.

Kenako onjezani lamulo latsopano pogwiritsa ntchito batani la ' Chatsopano '.

Pazenera lomwe likuwoneka, sankhani lamulo lakuti ' Mangani zikhalidwe zomwe zili pamwamba kapena pansi pa avareji '. Kenako, pamndandanda wotsikira m'munsimu, sankhani ' Greater than or equal to the average of the osankhidwa range '. Mukakanikiza batani la ' Format ', sinthani kukula kwa font pang'ono ndikupanga font kukhala yolimba mtima.

Zotsatira zake, tidzawunikira makasitomala omwe awononga ndalama zambiri kuchipatala chanu. Kuchuluka kwake kudzakhala kofanana kapena kukulirapo kuposa kuchuluka kwa chipatala.

Kuphatikiza apo, kusankha kwazinthu kumangosintha pakapita nthawi. Kupatula apo, dzulo mtengo wapakati unali wofanana ndi ndalama imodzi, ndipo lero zitha kukhala zosiyana.

Pali lipoti lapadera lomwe limasanthula mphamvu zogulira avareji .

Kusankhidwa Pamwamba 3 Opambana ndi Opambana 3 Oyipitsitsa

Mutha kukhazikitsa mawonekedwe omwe angawonetse ' Top 10 ' kapena ' Top 3 ' mwamakasitomala abwino kwambiri.

Tidzawawonetsa odwala otere mumtundu wobiriwira.

Tiyeni tiwonjezere chikhalidwe chachiwiri kuti tiwonetse odwala ' Top 3 ' odwala kwambiri. Ndalama zawo zomwe zagwiritsidwa ntchito zidzawonetsedwa mu font yofiira.

Onetsetsani kuti zolemba zonse ziwiri zidzagwiritsidwa ntchito pagawo la ' Total Spent '.

Chifukwa chake, mu seti yofananira, tipeza masanjidwe a ' Top 3 Best Patients ' ndi ' Top 3 Worst Patients '.

Gawo lina la makasitomala abwino kwambiri

Pakakhala odwala ambiri, ndizotheka kupanga anu ' Top 3 ' mlingo, pomwe ' 3 ' sadzakhala chiwerengero cha anthu omwe angapezeke pamndandanda wamba, koma chiwerengero cha makasitomala onse. Ndiye mutha kutulutsa mosavuta 3 peresenti ya odwala abwino kwambiri kapena oyipa kwambiri. Kuti muchite izi, ingoyang'anani bokosi la ' % la mndandanda womwe wasankhidwa '.

Zapadera kapena zobwereza

Pulogalamuyi idzakuwonetsani patebulo lililonse zamtengo wapatali kapena zobwereza .

Onani pansipa mitu ina yothandiza:

• Pezani zobwereza muzambiri
• Gwiritsani ntchito ma chart kuti muwonekere
• Onetsani Mfundo Zofunika Kwambiri
• Kugula mphamvu kusanthula
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera