Itulo lokuhlakaza ngemicibisholo “laba-khona”

Ekuqeqeshweni kokubuka ngeso lengqondo muva nje, omunye wabafundi uzwakalise umsebenzi othokozisayo: kuyadingeka ukukhombisa ngokusobala izinguquko zezindleko kanye nenzuzo yemikhiqizo ethile eminyakeni emibili edlule. Yiqiniso, awukwazi ukucindezela futhi uhambe ngendlela evamile, udweba amagrafu ama-banal, amakholomu noma ngisho, uNkulunkulu angithethelele, "amakhekhe". Kodwa uma uzicindezela kancane, khona-ke isisombululo esihle esimweni esinjalo singase sibe ukusebenzisa uhlobo olukhethekile itulo lokuhlakaza ngemicibisholo (“ngaphambi-ngaphambi”):

Yiqiniso, lokhu akufanelekile kuphela izimpahla kanye nezindleko-inzuzo. Ohambweni, ungaqhamuka nezimo eziningi lapho lolu hlobo lweshadi luzoba “sesihloko”, isibonelo:

• Ushintsho emalini engenayo (X) kanye nesikhathi sokuphila (Y) emazweni ahlukene phakathi neminyaka emibili edlule.
• Shintsha inombolo yamakhasimende (X) kanye nesheke elimaphakathi (Y) lama-oda ezindawo zokudlela
  
• Isilinganiso senani lenkampani (X) kanye nenani labasebenzi abakuyo (Y)
  
• ...
  

Uma kwenzeka okufanayo ekusebenzeni kwakho, kunengqondo ukuthola ukuthi ungakha kanjani ubuhle obunjalo.

Sengike ngabhala mayelana namashadi ebhamuza (ngisho nawopopayi). Ishadi elihlakaziwe (Ishadi le-XY Scatter) - lena yisimo esikhethekile sebhamuza (Ishadi Lebhamuza), kodwa ngaphandle kwepharamitha yesithathu - ubukhulu bamabhamuza. Labo. iphuzu ngalinye kugrafu lichazwa ngamapharamitha amabili kuphela: X no-Y. Ngakho, ukwakhiwa kuqala ngokulungiswa kwedatha yokuqala ngendlela yamathebula amabili:

Ake sakhe lokho “okwakuyikho” kuqala. Ukuze wenze lokhu, khetha uhla A3:C8 bese ukhetha kuthebhu Faka (Faka) Umyalo Amashadi anconyiwe (Amashadi anconyiwe), bese uya kuthebhu Yonke imidwebo (Wonke amashadi) bese ukhetha uhlobo Point (Ishadi le-XY Scatter):

Ngemuva kokuchofoza OK sithola okungenalutho kumdwebo wethu.

Manje ake sengeze idatha kuyo kusukela kuthebula lesibili elithi “Yaba”. Indlela elula yokwenza lokhu iwukukopisha. Ukuze wenze lokhu, khetha uhla E3:F8, ulikopishe futhi, ngemva kokukhetha ishadi, unamathisele okukhethekile kulo usebenzisa. Ikhaya — Namathisela — Namathisela Okukhethekile (Ikhaya — Namathisela — Namathisela Okukhethekile):

Ewindini elivelayo, khetha izinketho zokufaka ezifanele:

Ngemva kokuchofoza okuthi KULUNGILE, isethi yesibili yamaphuzu (“yiba”) izovela kumdwebo wethu:

Manje ingxenye ejabulisayo. Ukuze ulingise imicibisholo, kuzodingeka ukuthi ulungise ithebula lesithathu lefomu elilandelayo kusukela kudatha yethebula lokuqala nelesibili:

Qaphela ukuthi isethwa kanjani:

• imigqa esuka kumathebula omthombo ayashintshana ngamapheya, ilungisa isiqalo nesiphetho somcibisholo ngamunye
  
• ipheya ngalinye lihlukaniswa komunye ngomugqa ongenalutho ukuze okuphumayo kube imicibisholo ehlukene, hhayi owodwa omkhulu.
• uma idatha ingase ishintshe esikhathini esizayo, khona-ke kunengqondo ukusebenzisa hhayi izinombolo, kodwa izixhumanisi zamatafula okuqala, okungukuthi kuseli H4 faka ifomula = B4, kuseli H5 faka ifomula = E4, njalonjalo.
  

Asikhethe ithebula elidaliwe, silikopishele ebhodini lokunamathisela bese silengeza kumdwebo wethu sisebenzisa Namathisela Okukhethekile, njengoba senzile ekuqaleni:

Ngemva kokuchofoza okuthi KULUNGILE, amaphuzu amasha okuqala nawokugcina omcibisholo ngamunye azovela kumdwebo (nginawo ngompunga), amboze lezi ezakhiwe kakade eziluhlaza okwesibhakabhaka nokuwolintshi. Chofoza kwesokudla kuzo bese ukhetha umyalo Shintsha uhlobo lweshadi lochungechunge (Shintsha Uhlobo Lweshadi Lochungechunge). Efasiteleni elivulayo, emigqeni yokuqala "ngaphambi" kanye "ngaphambi", shiya uhlobo Point, kanye nochungechunge "lwemicibisholo" esiyimisayo Khomba ngemigqa eqondile:

Ngemva kokuchofoza okuthi KULUNGILE, amaphuzu ethu “waba” futhi “waba” azoxhunywa ngemigqa eqondile. Okusele ukuchofoza kwesokudla kuzo bese ukhetha umyalo Ifomethi yochungechunge lwedatha (Uchungechunge Lwedatha Yefomethi), bese usetha amapharamitha womugqa: ukujiya, uhlobo lomcibisholo nosayizi bawo:

Ukuze kucace, kungaba kuhle ukwengeza amagama ezimpahla. Kwalokhu:

1. Chofoza kunoma yiliphi iphuzu bese ukhetha kumenyu yokuqukethwe Engeza amalebula edatha (Engeza Amalebula Edatha) - kuzongezwa amalebula amaphuzu ezinombolo
   
2. Chofoza kwesokudla kumalebula bese ukhetha umyalo Ifomethi Yesiginesha (Fometha Amalebula)
3. Ephanelini elivulayo, khetha ibhokisi Amanani asuka kumaseli (Amanani asuka kumaseli), cindezela inkinobho Khetha Ibanga bese ugqamisa amagama omkhiqizo (A4:A8).