Chenesa data semutambo weDombo, Pepa, Chigero. Uyu mutambo une kana usina magumo? Chikamu 2. Inoshanda

В chikamu chekutanga zvakatsanangurwa kuti chinyorwa ichi chakaitwa pahwaro hwe dataset ye cadastral valuation mhedzisiro yezvivakwa muKhanty-Mansi Autonomous Okrug.

Chikamu chinoshanda chinoratidzwa nenzira yematanho. Kucheneswa kwese kwakaitwa muExcel, sezvo chishandiso chakajairika uye mashandiro akatsanangurwa anogona kudzokororwa nenyanzvi dzakawanda dzinoziva Excel. Uye yakanyatsokodzera basa remaoko-ku-ruoko.

Zero nhanho ichava basa rekutanga uye kuchengetedza faira, sezvo iri 100 MB muhukuru, uye nehuwandu hwemabasa aya ari makumi nemazana, zvinotora nguva yakakosha.
Kuvhura, paavhareji, masekonzi makumi matatu.
Kuchengetedza - 22 sec.

Danho rekutanga rinotanga nekuona nhamba dzezviratidzi zve dataset.

Tafura 1. Statistical zviratidzo zve dataset

Technology 2.1.

Isu tinogadzira munda unobatsira, ini ndinayo pasi penhamba - AY. Pachinyorwa chega chega, tinoumba fomula "=LENGTH(F365502)+LENGTH(G365502)+…+LENGTH(AW365502)”

Yese nguva yakashandiswa pachikuva 2.1 (yeSchumann formula) t21 = 1 awa.
Nhamba yezvikanganiso zvakawanikwa padanho 2.1 (yeSchumann formula) n21 = 0 pcs.

Chikamu chechipiri.
Kuongorora zvikamu zve dataset.
2.2. Ese makoshero mumarekodhi anogadzirwa uchishandisa akajairwa zviratidzo. Naizvozvo, ngatiteverei nhamba nezviratidzo.

Tafura 2. Statistical zviratidzo zvemavara ari mudhata nekuongorora kwekutanga kwemhedzisiro.





Technology 2.2.1.

Isu tinogadzira munda wekubatsira - "alpha1". Parekodhi rega rega, tinogadzira fomula "=CONCATENATE(Sheet1!B9;...Sheet1!AQ9)"
Isu tinogadzira yakagadziriswa Omega-1 cell. Tichachinjanisa kuisa macode ehunhu zvinoenderana neWindows-1251 kubva pa32 kusvika 255 muchitokisi ichi.
Isu tinogadzira munda wekubatsira - "alpha2". Neformula "=TSVAGA(SYMBOL(Omega,1); "alpha1",N)".
Isu tinogadzira munda wekubatsira - "alpha3". Neformula "=IF(ISNUMBER("alpha2",N),1)"
Gadzira sero yakagadziriswa "Omega-2", ine fomula "= SUM("alpha3"N1: "alpha3"N365498)"

Tafura 3. Migumisiro yekuongorora kwekutanga kwemigumisiro

Tafura 4. Mhosho dzakanyorwa panguva ino

Yese nguva yakashandiswa pachikuva 2.2.1 (yeSchumann formula) t221 = 8 awa.
Nhamba yezvikanganiso zvakagadziriswa pachikamu 2.2.1 (yeSchumann formula) n221 = 0 pcs.

Stage 3.
Nhanho yechitatu ndeyekunyora mamiriro e dataset. Nekupa rekodhi imwe neimwe nhamba yakasarudzika (ID) uye imwe neimwe ndima. Izvi zvinodikanwa kuenzanisa iyo dataset yakashandurwa neiyo yekutanga. Izvi zvinodikanwawo kutora mukana wakazara wemapoka uye kugona kusefa. Pano zvakare tinotendeukira kutafura 2.2.2 uye sarudza chiratidzo chisina kushandiswa mudheta. Isu tinowana izvo zvinoratidzwa muFigure 10.

Mufananidzo 10. Kugovera zviziviso.

Yese nguva yakashandiswa pachikuva 3 (yeSchumann formula) t3 = 0,75 awa.
Nhamba yezvikanganiso zvakawanikwa padanho 3 (yeSchumann formula) n3 = 0 pcs.

Sezvo Schumann formula inoda kuti danho ripedzwe nekugadzirisa zvikanganiso. Ngatidzokere pastage 2.

Stage 2.2.2.
Munhanho iyi tichagadzirisawo nzvimbo mbiri uye katatu.

Mufananidzo 11. Nhamba yenzvimbo mbiri.

Kugadziriswa kwezvikanganiso zvakaonekwa mutafura 2.2.4.

Tafura 5. Chikanganiso chekugadzirisa danho


Muenzaniso wekuti sei chimiro chakadai sekushandiswa kwemavara “e” kana “e” chichikosha unoratidzwa muMufananidzo 12.

Mufananidzo 12. Kusiyana mutsamba "e".

Nguva yose yakashandiswa munhanho 2.2.2 t222 = maawa mana.
Nhamba yezvikanganiso zvakawanikwa padanho 2.2.2 (yeSchumann formula) n222 = 583 pcs.

Danho rechina.
Kuongorora kusadiwa kwemunda kunokodzera muchikamu ichi. Pakati pe44 minda, 6 minda:
7 - Chinangwa chechimiro
16 - Nhamba yepasi pevhu
17 - Chiro chevabereki
21 - Village Council
38 - Zvimiro zvimiro (tsanangudzo)
40 – Nhaka yetsika

Havana kana vapinda. Kureva kuti havana basa.
Munda "22 - Guta" ine imwe chete yekupinda, Mufananidzo 13.

Mufananidzo 13. Iyo chete yekupinda ndeye Z_348653 mundima ye "Guta".

Munda "34 - Zita rekuvaka" rine zvinyorwa zvisingaenderane nechinangwa chemunda, Mufananidzo 14.

Mufananidzo 14. Muenzaniso wekupinda kusingaenderane.

Isu tinobvisa minda iyi kubva kune dataset. Uye isu tinonyora shanduko mu214 zvinyorwa.

Yese nguva yakashandiswa pachikuva 4 (yeSchumann formula) t4 = 2,5 awa.
Nhamba yezvikanganiso zvakawanikwa padanho 4 (yeSchumann formula) n4 = 222 pcs.

Tafura 6. Kuongororwa kwezviratidzo zvakagadziriswa mushure mechikamu chechina

Kazhinji, kuongorora kuchinja zviratidzo (Table 6) tinogona kutaura kuti:
1) Chiyero cheavhareji yenhamba yezviratidzo kune yakajairwa kutsauswa lever iri padyo ne3, ndiko kuti, pane zviratidzo zvekugovera kwakajairika (matanhatu sigma mutemo).
2) Kutsauka kwakakosha kwehushoma uye huwandu hwemarevhisi kubva paavhareji lever inoratidza kuti kudzidza kwemiswe igwara rinovimbisa kana uchitsvaga zvikanganiso.

Ngationgororei mhedzisiro yekutsvaga zvikanganiso tichishandisa nzira yaSchumann.

Zvitanho zvisina basa

2.1. Yese nguva yakashandiswa pachikuva 2.1 (yeSchumann formula) t21 = 1 awa.
Nhamba yezvikanganiso zvakawanikwa padanho 2.1 (yeSchumann formula) n21 = 0 pcs.

3. Yese nguva yakashandiswa pachikuva 3 (yeSchumann formula) t3 = 0,75 awa.
Nhamba yezvikanganiso zvakawanikwa padanho 3 (yeSchumann formula) n3 = 0 pcs.

Zvitanho zvinobudirira
2.2. Yese nguva yakashandiswa pachikuva 2.2.1 (yeSchumann formula) t221 = 8 awa.
Nhamba yezvikanganiso zvakagadziriswa pachikamu 2.2.1 (yeSchumann formula) n221 = 0 pcs.
Nguva yose yakashandiswa munhanho 2.2.2 t222 = maawa mana.
Nhamba yezvikanganiso zvakawanikwa padanho 2.2.2 (yeSchumann formula) n222 = 583 pcs.

Nguva yose inoshandiswa munhanho 2.2 t22 = 8 + 4 = maawa gumi nemaviri.
Nhamba yezvikanganiso zvakawanikwa padanho 2.2.2 (yeSchumann formula) n222 = 583 pcs.

4. Yese nguva yakashandiswa pachikuva 4 (yeSchumann formula) t4 = 2,5 awa.
Nhamba yezvikanganiso zvakawanikwa padanho 4 (yeSchumann formula) n4 = 222 pcs.

Sezvo paine zero nhanho dzinofanirwa kuverengerwa muchikamu chekutanga cheiyo Schumann modhi, uye kune rumwe rutivi, nhanho 2.2 uye 4 dzakazvimiririra zvakasununguka, zvichibva zvapihwa kuti iyo Schumann modhi inofunga kuti nekuwedzera nguva yecheki, mukana. yekuona kukanganisa kunoderera, ndiko kuti, kuyerera kunoderedza kukundikana, zvino nekuongorora kuyerera uku tichaona kuti ndeipi nhanho yekuisa pakutanga, maererano nemutemo, apo kukundikana kwehuwandu kunowedzera kakawanda, tichaisa iyo nhanho yekutanga.

Mufananidzo 15.

Kubva paformula iri muFigure 15 zvinotevera kuti zviri nani kuisa nhanho yechina pamberi pechikamu 2.2 mukuverenga.

Tichishandisa fomula yaSchumann, tinoona iyo inofungidzirwa nhamba yekutanga yezvikanganiso:

Mufananidzo 16.

Kubva pane zvakabuda muMufananidzo 16 zvinogona kuonekwa kuti nhamba yakafanotaurwa yezvikanganiso iN2 = 3167, iyo inopfuura chiyero chiduku che1459.

Somugumisiro wekururamisa, takagadzirisa zvikanganiso zve805, uye nhamba yakafanotaurwa ndeye 3167 - 805 = 2362, iyo ichiri kupfuura zvishoma zvishoma zvatakagamuchira.

Isu tinotsanangura parameter C, lambda uye kuvimbika basa:

Mufananidzo 17.

Chaizvoizvo, lambda chiratidzo chaicho chekusimba uko zvikanganiso zvinoonekwa padanho rega rega. Kana iwe ukatarisa kumusoro, fungidziro yapfuura yechiratidzo ichi yaive 42,4 zvikanganiso paawa, iyo inofananidzwa nechiratidzo cheSchumann. Kutendeukira kuchikamu chekutanga chechinhu ichi, zvakatemwa kuti chiyero icho mugadziri anowana zvikanganiso hachifanirwe kunge chakaderera pane 1 kukanganisa pamarekodhi 250,4, kana uchitarisa 1 rekodhi paminiti. Saka kukosha kwakakosha kwe lambda yeiyo Schumann modhi:
60 / 250,4 = 0,239617.

Kureva kuti, kudiwa kwekuita zvikanganiso zvekuona maitiro kunofanirwa kuitwa kusvika lambda, kubva kune iripo 38,964, yadzikira kusvika 0,239617.

Kana kusvika chiratidzo N (chinokwanisika nhamba yezvikanganiso) kubvisa n (yakagadziriswa nhamba yezvikanganiso) inoderera pazasi pechikumbaridzo chatakagamuchira (muchikamu chekutanga) - 1459 pcs.

Chikamu 1. Theoretical.

Source: www.habr.com