В kwachazwa ukuba olu papasho lwenziwe ngesiseko sedatha yeziphumo zexabiso le-cadastral ye-real estate kwi-Khanty-Mansi Autonomous Okrug.
Inxalenye ebonakalayo iboniswe ngendlela yamanyathelo. Konke ukucocwa kwenziwa kwi-Excel, ekubeni isixhobo esiqhelekileyo kunye nemisebenzi echaziweyo inokuphinda iphindwe ngobuninzi beengcali ezazi i-Excel. Kwaye iwufanelekele kakuhle umsebenzi wezandla.
Inqanaba le-zero liya kuba ngumsebenzi wokuqalisa kunye nokugcina ifayile, ekubeni i-100 MB ngobukhulu, ngoko kunye nenani lale misebenzi ibe ngamashumi kunye namakhulu, bathatha ixesha elibalulekileyo.
Ukuvula, ngokomndilili, yimizuzwana engama-30.
Ukugcina – 22 sec.
Inqanaba lokuqala liqala ngokumisela izikhombisi zeenkcukacha-manani zeseti yedatha.
Itheyibhile 1. Izalathi zeenkcukacha-manani zeseti yedatha
Iteknoloji 2.1.
Senza intsimi encedisayo, ndinayo phantsi kwenombolo - AY. Kungeno ngalunye, senza ifomula ethi “=LENGTH(F365502)+LENGTH(G365502)+…+LENGTH(AW365502)”
Ixesha elipheleleyo elichithwe kwinqanaba le-2.1 (kwifomula ye-Schumann) t21 = 1 iyure.
Inani leempazamo ezifunyenwe kwinqanaba le-2.1 (kwifomula ye-Schumann) n21 = 0 pcs.
Inqanaba lesibini.
Ukujonga amacandelo esethi yedatha.
2.2. Onke amaxabiso kwiirekhodi zenziwa kusetyenziswa iisimboli eziqhelekileyo. Ngoko ke, masilandele izibalo ngeesimboli.
Itheyibhile 2. Izalathi-manani zabalinganiswa kwidathasethi kunye nohlalutyo lokuqala lweziphumo.
Iteknoloji 2.2.1.
Senza indawo encedisayo - "alpha1". Kwirekhodi nganye, senza ifomula ethi “=CONCATENATE(Sheet1!B9;...Sheet1!AQ9)”
Senza iseli yeOmega-1 esisigxina. Siza kungena ngenye indlela iikhowudi zabalinganiswa ngokweWindows-1251 ukusuka ku-32 ukuya kuma-255 kule seli.
Senza indawo encedisayo - "alpha2". Ngefomula ethi “=FUMANA(UPHAWU(Omega,1);“alpha1”,N)”.
Senza indawo encedisayo - "alpha3". Ngefomula “=IF(ISNUMBER(“alpha2”,N),1)”
Yenza iseli esisigxina "i-Omega-2", kunye nefomula "=SUM("alpha3"N1: "alpha3"N365498)"
Uluhlu 3. Iziphumo zohlalutyo lokuqala lweziphumo
Uluhlu 4. Iimpazamo ezirekhodiweyo kweli nqanaba
Ixesha elipheleleyo elichithwe kwinqanaba le-2.2.1 (kwifomula ye-Schumann) t221 = 8 iyure.
Inani leempazamo ezilungisiweyo kwinqanaba le-2.2.1 (kwifomula ye-Schumann) n221 = 0 pcs.
Inqanaba 3.
Inyathelo lesithathu kukurekhoda imeko yedatha. Ngokunika irekhodi nganye inombolo eyodwa (ID) kunye nendawo nganye. Oku kuyimfuneko ukuthelekisa isethi yedatha eguquliweyo kunye neyokuqala. Oku kukwayimfuneko ukuthatha ithuba elipheleleyo lokukwazi ukwenza amaqela kunye nokucoca. Apha kwakhona sijika kwitheyibhile 2.2.2 kwaye ukhethe isimboli esingasetyenziswanga kwidathasethi. Sifumana oko kuboniswe kuMfanekiso 10.
Isazobe 10. Ukwabela izichongi.
Ixesha elipheleleyo elichithwe kwinqanaba le-3 (kwifomula ye-Schumann) t3 = 0,75 iyure.
Inani leempazamo ezifunyenwe kwinqanaba le-3 (kwifomula ye-Schumann) n3 = 0 pcs.
Ekubeni ifomula ye-Schumann ifuna ukuba isiteji sigqitywe ngokulungisa iimpazamo. Masibuyele kwisigaba sesi-2.
Inqanaba 2.2.2.
Kweli nyathelo siza kulungisa izithuba eziphindwe kabini neziphindwe kathathu.
Isazobe 11. Inani lezithuba eziphindwe kabini.
Ukulungiswa kweempazamo ezichongiweyo kwitheyibhuli 2.2.4.
Itheyibhile 5. Inqanaba lokulungiswa kweempazamo
Umzekelo wokuba kutheni inkalo efana nokusetyenziswa konobumba “e” okanye “e” ibalulekile iboniswe kuMfanekiso 12.
Isazobe 12. Ukungafani kwileta "e".
Ixesha elipheleleyo elichithwe kwinqanaba 2.2.2 t222 = iiyure ezi-4.
Inani leempazamo ezifunyenwe kwinqanaba le-2.2.2 (kwifomula ye-Schumann) n222 = 583 pcs.
Inqanaba lesine.
Ukukhangela ukungabikho kwentsimi kungena kakuhle kweli nqanaba. Kumabala angama-44, amabala ama-6:
7 - Injongo yesakhiwo
16 - Inani lemigangatho engaphantsi komhlaba
I-17 - Into yomzali
21 - Ibhunga lelali
38 — Iiparamitha zesakhiwo (inkcazelo)
40 – Ilifa lenkcubeko
Abanawo nawaphi na amangeno. Oko kukuthi, azifuneki.
Ummandla "22 - iSixeko" unongeniso omnye, uMfanekiso we-13.
Isazobe 13. Ukungena kuphela yi-Z_348653 kwindawo "yeSixeko".
Ummandla othi “34 - Igama lokwakha” uqulathe amangeniso angahambelaniyo ngokucacileyo nenjongo yentsimi, uMfanekiso 14.
Isazobe 14. Umzekelo wokungeniswa okungahambelaniyo.
Asiyibandakanyi le mimandla kuluhlu lwedatha. Kwaye sirekhoda utshintsho kwiirekhodi ezingama-214.
Ixesha elipheleleyo elichithwe kwinqanaba le-4 (kwifomula ye-Schumann) t4 = 2,5 iyure.
Inani leempazamo ezifunyenwe kwinqanaba le-4 (kwifomula ye-Schumann) n4 = 222 pcs.
Itheyibhile 6. Uhlalutyo lwezalathi zeseti yedatha emva kwesigaba se-4
Ngokubanzi, ukuhlalutya utshintsho kwizalathisi (Itheyibhile 6) sinokuthi:
1) Umlinganiselo wenani eliqhelekileyo leesimboli kwi-standard deviation lever isondele kwi-3, oko kukuthi, kukho iimpawu zokusabalalisa okuqhelekileyo (umgaqo we-sigma ezintandathu).
I-2) Ukuphambuka okuphawulekayo kobuncinci kunye nobuninzi bee-levers ukusuka kwi-lever ye-avareji kubonisa ukuba ukufundwa kwemisila kuyisikhokelo esithembisayo xa ukhangela iimpazamo.
Makhe sihlolisise iziphumo zokufumana iimpazamo ngokusebenzisa indlela kaSchumann.
Amanqanaba angasebenziyo
2.1. Ixesha elipheleleyo elichithwe kwinqanaba le-2.1 (kwifomula ye-Schumann) t21 = 1 iyure.
Inani leempazamo ezifunyenwe kwinqanaba le-2.1 (kwifomula ye-Schumann) n21 = 0 pcs.
3. Ixesha elipheleleyo elichithwe kwinqanaba le-3 (kwifomula ye-Schumann) t3 = 0,75 iyure.
Inani leempazamo ezifunyenwe kwinqanaba le-3 (kwifomula ye-Schumann) n3 = 0 pcs.
Amanqanaba asebenzayo
2.2. Ixesha elipheleleyo elichithwe kwinqanaba le-2.2.1 (kwifomula ye-Schumann) t221 = 8 iyure.
Inani leempazamo ezilungisiweyo kwinqanaba le-2.2.1 (kwifomula ye-Schumann) n221 = 0 pcs.
Ixesha elipheleleyo elichithwe kwinqanaba 2.2.2 t222 = iiyure ezi-4.
Inani leempazamo ezifunyenwe kwinqanaba le-2.2.2 (kwifomula ye-Schumann) n222 = 583 pcs.
Ixesha elipheleleyo elichithwe kwinqanaba 2.2 t22 = 8 + 4 = iiyure ezili-12.
Inani leempazamo ezifunyenwe kwinqanaba le-2.2.2 (kwifomula ye-Schumann) n222 = 583 pcs.
4. Ixesha elipheleleyo elichithwe kwinqanaba le-4 (kwifomula ye-Schumann) t4 = 2,5 iyure.
Inani leempazamo ezifunyenwe kwinqanaba le-4 (kwifomula ye-Schumann) n4 = 222 pcs.
Ekubeni kukho izigaba zero ezimele zifakwe kwinqanaba lokuqala lomzekelo we-Schumann, kwaye kwelinye icala, izigaba ze-2.2 kunye ne-4 zizimele ngokwemvelo, emva koko zinikwe ukuba imodeli ye-Schumann ithatha ukuba ngokunyusa ixesha lokutshekisha, ukuba nokwenzeka. yokufumanisa impazamo iyancipha, oko kukuthi, ukuhamba kunciphisa ukungaphumeleli, ngoko ngokuphonononga le flow siya kugqiba ukuba yeyiphi inqanaba ukubeka kuqala, ngokomgaqo, apho ingxinano ukungaphumeleli rhoqo, siya kubeka eso sigaba kuqala.
Umzobo 15.
Ukususela kwifomyula kuMzobo we-15 kulandela ukuba kulungele ukubeka isigaba sesine phambi kwesigaba 2.2 kwizibalo.
Sisebenzisa ifomula kaSchumann, simisela inani eliqikelelweyo leempazamo:
Umzobo 16.
Ukususela kwiziphumo kwi-Figure 16 kunokubonwa ukuba inani eliqikelelweyo leempazamo ngu-N2 = 3167, elingaphezu komlinganiselo omncinci we-1459.
Njengomphumo wokulungiswa, silungise iimpazamo ze-805, kwaye inani eliqikelelweyo li-3167 - 805 = 2362, elisekho ngaphezu kobuncinci obuncinane esamkelekileyo.
Sichaza iparameter C, lambda kunye nomsebenzi wokuthembeka:
Umzobo 17.
Ngokusisiseko, i-lambda sisalathiso sokwenyani sobunzulu apho iimpazamo zibonwa khona kwinqanaba ngalinye. Ukuba ujonga ngasentla, uqikelelo lwangaphambili kwesi salathisi kwaba 42,4 iimpazamo ngeyure, nto leyo enokuthelekiseka nesalathisi Schumann. Ukujika kwinxalenye yokuqala yale nto, kwagqitywa ukuba izinga apho umthuthukisi afumana iimpazamo akufanele abe ngaphantsi kwe-1 impazamo kwiirekhodi ze-250,4, xa ehlola irekhodi eli-1 ngomzuzu. Ke ngoko ixabiso elibalulekileyo lelambda yemodeli yeSchumann:
60 / 250,4 = 0,239617.
Oko kukuthi, imfuneko yokuphumeza iinkqubo zokubona impazamo kufuneka iqhutywe de i-lambda, ukusuka kwi-38,964 ekhoyo, iyancipha ukuya kwi-0,239617.
Okanye de isalathisi N (inani elinokubakho leempazamo) thabatha n (inani elilungisiweyo leempazamo) liyancipha ngaphantsi komda esamkelekileyo (kwinxalenye yokuqala) - 1459 pcs.
umthombo: www.habr.com
