Π zidafotokozedwa kuti bukuli linapangidwa pamaziko a dataset ya cadastral valuation results of real estates ku Khanty-Mansi Autonomous Okrug.
Gawo lothandiza likuperekedwa mu mawonekedwe a masitepe. Kuyeretsa konse kunachitika mu Excel, popeza chida chodziwika bwino komanso ntchito zomwe zafotokozedwa zitha kubwerezedwa ndi akatswiri ambiri omwe amadziwa Excel. Ndipo ndizoyenera kwambiri kugwira ntchito ndi manja.
Gawo la zero lidzakhala ntchito yoyambitsa ndi kusunga fayilo, popeza ndi 100 MB kukula kwake, ndiye kuti chiwerengero cha ntchitozi ndi makumi ndi mazana, zimatenga nthawi yofunikira.
Kutsegula, pafupifupi, ndi masekondi 30.
Kusunga - 22 sec.
Gawo loyamba limayamba ndikuzindikira ziwerengero za dataset.
Table 1. Zizindikiro zowerengera za dataset
Technology 2.1.
Timapanga gawo lothandizira, ndili nalo pansi pa nambala - AY. Pakulowa kulikonse, timapanga njira yakuti β=LENGTH(F365502)+LENGTH(G365502)+β¦+LENGTH(AW365502)β
Nthawi yonse yogwiritsidwa ntchito pa siteji 2.1 (ya formula ya Schumann) t21 = ola limodzi.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 2.1 (kwa formula ya Schumann) n21 = 0 pcs.
Gawo lachiwiri.
Kuyang'ana zigawo za dataset.
2.2. Makhalidwe onse muzolemba amapangidwa pogwiritsa ntchito zizindikiro zokhazikika. Chifukwa chake, tiyeni tizitsata ziwerengero ndi zizindikiro.
Table 2. Zizindikiro zowerengera za zilembo mu dataset ndi kusanthula koyambirira kwa zotsatira.
Technology 2.2.1.
Timapanga gawo lothandizira - "alpha1". Pa mbiri iliyonse, timapanga njira yakuti β=CONCATENATE(Sheet1!B9;...Sheet1!AQ9)β
Timapanga cell ya Omega-1 yokhazikika. Tidzalowetsamo manambala malinga ndi Windows-1251 kuchokera ku 32 mpaka 255 kulowa mu cell iyi.
Timapanga gawo lothandizira - "alpha2". Ndi chilinganizo "=PEZANI(SYMBOL(Omega,1); "alpha1",N)".
Timapanga gawo lothandizira - "alpha3". Ndi chilinganizo "=IF(ISNUMBER("alpha2",N),1)"
Pangani selo lokhazikika "Omega-2", ndi formula "=SUM("alpha3"N1: "alpha3"N365498)"
Table 3. Zotsatira za kusanthula koyambirira kwa zotsatira
Table 4. Zolakwa zolembedwa panthawiyi
Nthawi yonse yogwiritsidwa ntchito pa siteji 2.2.1 (ya formula ya Schumann) t221 = ola limodzi.
Chiwerengero cha zolakwika zokonzedwa pa siteji 2.2.1 (kwa Schumann formula) n221 = 0 pcs.
Gawo 3.
Gawo lachitatu ndikulemba momwe dataset ilili. Mwa kupatsa cholembedwa chilichonse nambala yapadera (ID) ndi gawo lililonse. Izi ndi zofunika kufananitsa deta yosinthidwa ndi yoyamba. Izi ndizofunikanso kuti mugwiritse ntchito bwino luso lamagulu ndi kusefa. Apanso tikutembenukira ku tebulo 2.2.2 ndikusankha chizindikiro chomwe sichigwiritsidwa ntchito mu dataset. Timapeza zomwe zikuwonetsedwa mu Chithunzi 10.
Chithunzi 10. Kupereka zizindikiritso.
Nthawi yonse yogwiritsidwa ntchito pa siteji 3 (ya formula ya Schumann) t3 = ola limodzi.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 3 (kwa formula ya Schumann) n3 = 0 pcs.
Popeza formula ya Schumann imafuna kuti sitejiyo ikwaniritsidwe pokonza zolakwika. Tibwerere ku stage 2.
Gawo 2.2.2.
Mu sitepe iyi tikonzanso mipata iwiri ndi itatu.
Chithunzi 11. Chiwerengero cha mipata iwiri.
Kuwongolera zolakwika zomwe zadziwika mu tebulo 2.2.4.
Gulu 5. Gawo lokonzekera zolakwika
Chitsanzo cha chifukwa chake mawu oti "e" kapena "e" ali ofunikira akuwonetsedwa mu Chithunzi 12.
Chithunzi 12. Kusiyana mu chilembo "e".
Nthawi yonse yogwiritsidwa ntchito mu gawo 2.2.2 t222 = maola 4.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 2.2.2 (kwa formula ya Schumann) n222 = 583 pcs.
Gawo lachinayi.
Kuyang'ana kufutukuka kumunda kumagwirizana bwino ndi gawo ili. Mwa minda 44, minda 6:
7 - Cholinga cha kapangidwe
16 - Chiwerengero cha pansi pansi
17 - Chinthu cha makolo
21 - Council Village
38 - Zosintha zamapangidwe (mafotokozedwe)
40 - Cholowa cha chikhalidwe
Alibe zolembera. Ndiko kuti, iwo alibe ntchito.
Munda "22 - Mzinda" uli ndi cholowera chimodzi, Chithunzi 13.
Chithunzi 13. Cholowa chokha ndi Z_348653 m'munda wa "City".
Munda "34 - Dzina la Nyumba" uli ndi zolemba zomwe sizikugwirizana ndi cholinga chamunda, Chithunzi 14.
Chithunzi 14. Chitsanzo cha kulowa kosatsatira.
Sitikupatula magawowa ku dataset. Ndipo timalemba kusinthako mu zolemba 214.
Nthawi yonse yogwiritsidwa ntchito pa siteji 4 (ya formula ya Schumann) t4 = ola limodzi.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 4 (kwa formula ya Schumann) n4 = 222 pcs.
Table 6. Kusanthula kwa zizindikiro za deta pambuyo pa gawo la 4
Kawirikawiri, kusanthula kusintha kwa zizindikiro (Table 6) tinganene kuti:
1) ChiΕ΅erengero cha chiwerengero cha zizindikiro ku chiwongoladzanja chopotoka chiri pafupi ndi 3, ndiko kuti, pali zizindikiro za kugawa bwino (malamulo asanu ndi limodzi a sigma).
2) Kupatuka kwakukulu kwa ma levers ocheperako komanso okwera kwambiri kuchokera pa lever wamba kukuwonetsa kuti kuphunzira kwa michira ndi njira yodalirika pofufuza zolakwika.
Tiyeni tione zotsatira za kupeza zolakwika pogwiritsa ntchito njira ya Schumann.
Magawo opanda pake
2.1. Nthawi yonse yogwiritsidwa ntchito pa siteji 2.1 (ya formula ya Schumann) t21 = ola limodzi.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 2.1 (kwa formula ya Schumann) n21 = 0 pcs.
3. Nthawi yonse yogwiritsidwa ntchito pa siteji 3 (ya formula ya Schumann) t3 = ola limodzi.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 3 (kwa formula ya Schumann) n3 = 0 pcs.
Magawo ogwira mtima
2.2. Nthawi yonse yogwiritsidwa ntchito pa siteji 2.2.1 (ya formula ya Schumann) t221 = ola limodzi.
Chiwerengero cha zolakwika zokonzedwa pa siteji 2.2.1 (kwa Schumann formula) n221 = 0 pcs.
Nthawi yonse yogwiritsidwa ntchito mu gawo 2.2.2 t222 = maola 4.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 2.2.2 (kwa formula ya Schumann) n222 = 583 pcs.
Nthawi yonse yogwiritsidwa ntchito mu sitepe 2.2 t22 = 8 + 4 = maola 12.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 2.2.2 (kwa formula ya Schumann) n222 = 583 pcs.
4. Nthawi yonse yogwiritsidwa ntchito pa siteji 4 (ya formula ya Schumann) t4 = ola limodzi.
Chiwerengero cha zolakwika zomwe zapezeka pa siteji 4 (kwa formula ya Schumann) n4 = 222 pcs.
Popeza pali zigawo ziro zomwe ziyenera kuphatikizidwa mu gawo loyamba lachitsanzo la Schumann, ndipo mbali inayi, magawo 2.2 ndi 4 ali odziimira okha, ndiye kuti chitsanzo cha Schumann chikuganiza kuti poonjezera nthawi ya cheke, mwayiwo. kuzindikira kulakwitsa kumachepa, ndiko kuti, kutuluka kumachepetsa zolephera, ndiye poyang'ana kutuluka uku tidzadziwa kuti ndi gawo liti lomwe tiyikepo, molingana ndi lamulo, kumene kulephera kumakhala kochuluka, tidzayika gawolo poyamba.
Chithunzi 15.
Kuchokera pamapangidwe omwe ali mu Chithunzi 15, ndikwabwino kuyika gawo lachinayi musanafike gawo 2.2 powerengera.
Pogwiritsa ntchito chilinganizo cha Schumann, timazindikira kuchuluka koyambirira kwa zolakwika:
Chithunzi 16.
Kuchokera muzotsatira mu Chithunzi 16 zikhoza kuwoneka kuti chiwerengero choloseredwa cha zolakwika ndi N2 = 3167, chomwe chiri choposa chiwerengero chochepa cha 1459.
Chifukwa cha kuwongolera, tinakonza zolakwika za 805, ndipo chiwerengero choloseredwa ndi 3167 - 805 = 2362, chomwe chikadali choposa malire omwe tidavomereza.
Timatanthauzira magawo C, lambda ndi ntchito yodalirika:
Chithunzi 17.
Kwenikweni, lambda ndi chizindikiro chenicheni cha kukula komwe zolakwika zimazindikiridwa pagawo lililonse. Ngati muyang'ana pamwamba, chiwerengero cha m'mbuyo cha chizindikiro ichi chinali 42,4 zolakwika pa ola limodzi, zomwe ziri zofanana kwambiri ndi chizindikiro cha Schumann. Kutembenukira ku gawo loyamba la nkhaniyi, zinatsimikiziridwa kuti mlingo umene woyambitsa amapeza zolakwika uyenera kukhala wosachepera 1 cholakwika pa 250,4 zolemba, poyang'ana 1 mbiri pamphindi. Chifukwa chake mtengo wofunikira wa lambda wa mtundu wa Schumann:
60 / 250,4 = 0,239617.
Ndiko kuti, kufunikira kochita njira zodziwira zolakwika kuyenera kuchitika mpaka lambda, kuchokera ku 38,964 yomwe ilipo, itsika mpaka 0,239617.
Kapena mpaka chizindikiro N (chiwerengero cha zolakwika) kuchotsa n (chiwerengero cholondola cha zolakwika) chichepetse pansi pa malo omwe tinalandira (mu gawo loyamba) - 1459 pcs.
Source: www.habr.com