В an bayyana cewa an yi wannan ɗaba'ar ne bisa bayanan kididdigar sakamakon kimar kaddara na gidaje a cikin Khanty-Mansi Autonomous Okrug.
An gabatar da sashin aiki a cikin hanyar matakai. An yi duk tsaftacewa a cikin Excel, tun da kayan aiki na yau da kullum da ayyukan da aka kwatanta za a iya maimaita su ta hanyar yawancin ƙwararrun da suka san Excel. Kuma ya dace sosai don aikin hannu da hannu.
Matsayin sifili zai zama aikin ƙaddamarwa da adana fayil ɗin, tun da girman girman 100 MB ne, sannan tare da adadin waɗannan ayyukan sun kasance dubun da ɗaruruwa, suna ɗaukar lokaci mai mahimmanci.
Buɗewa, akan matsakaita, shine daƙiƙa 30.
Ajiye - 22 seconds.
Mataki na farko yana farawa tare da ƙayyade ma'aunin ƙididdiga na saitin bayanai.
Tebura 1. Alamun ƙididdiga na saitin bayanai
Fasaha 2.1.
Muna ƙirƙirar filin taimako, Ina da shi a ƙarƙashin lamba - AY. Ga kowane shigarwa, muna samar da dabarar "= TSORO(F365502)+LENGTH(G365502)+…+LENGTH(AW365502)"
Jimlar lokacin da aka kashe akan mataki 2.1 (na tsarin Schumann) t21 = 1 hour.
Yawan kurakurai da aka samu a mataki na 2.1 (na tsarin Schumann) n21 = 0 inji mai kwakwalwa.
Kashi na biyu.
Duba abubuwan da ke cikin bayanan.
2.2. Dukkan dabi'u a cikin bayanan an ƙirƙira su ta amfani da daidaitattun alamomi. Don haka, bari mu bi kididdiga ta alamomi.
Tebura 2. Alamun ƙididdiga na haruffa a cikin bayanan bayanai tare da bincike na farko na sakamakon.
Fasaha 2.2.1.
Muna ƙirƙirar filin taimako - "alpha1". Ga kowane rikodin, muna samar da dabara "= CONCATENATE(Sheet1! B9;... Sheet1! AQ9)"
Muna ƙirƙirar tantanin halitta Omega-1 kafaffen. Za mu shigar da lambobin haruffa bisa ga Windows-1251 daga 32 zuwa 255 a cikin wannan tantanin halitta.
Muna ƙirƙirar filin taimako - "alpha2". Tare da dabara "= NEMAN (alama (Omega,1); "alpha1", N)".
Muna ƙirƙirar filin taimako - "alpha3". Tare da dabara "=IF(ISNUMBER("alpha2",N),1)"
Ƙirƙiri kafaffen tantanin halitta "Omega-2", tare da dabara "= SUM("alpha3"N1:"alpha3"N365498)"
Tebura 3. Sakamakon bincike na farko na sakamako
Table 4. Kurakurai da aka rubuta a wannan mataki
Jimlar lokacin da aka kashe akan mataki 2.2.1 (na tsarin Schumann) t221 = 8 hour.
Adadin kurakurai da aka gyara a mataki na 2.2.1 (na tsarin Schumann) n221 = 0 pcs.
Mataki na 3.
Mataki na uku shine yin rikodin yanayin bayanan. Ta hanyar sanya kowane rikodin lamba ta musamman (ID) da kowane filin. Wannan wajibi ne don kwatanta saitin bayanan da aka canza da na asali. Wannan kuma ya zama dole don cin gajiyar damar haɗawa da kuma tacewa. Anan kuma mun juya zuwa tebur 2.2.2 kuma zaɓi alamar da ba a yi amfani da ita a cikin bayanan. Mun sami abin da aka nuna a hoto na 10.
Hoto 10. Sanya masu ganowa.
Jimlar lokacin da aka kashe akan mataki 3 (na tsarin Schumann) t3 = 0,75 hour.
Yawan kurakurai da aka samu a mataki na 3 (na tsarin Schumann) n3 = 0 inji mai kwakwalwa.
Tun da tsarin Schumann yana buƙatar kammala matakin ta hanyar gyara kurakurai. Mu koma mataki na 2.
Mataki na 2.2.2.
A wannan mataki kuma za mu gyara wurare biyu da sau uku.
Hoto 11. Yawan wurare biyu.
Gyara kurakurai da aka gano a cikin tebur 2.2.4.
Tebur 5. Kuskuren gyara matakin
Misalin dalilin da ya sa irin wannan fannin kamar amfani da haruffan “e” ko “e” ke da mahimmanci an gabatar da shi a cikin Hoto na 12.
Hoto na 12. Bambance-bambance a cikin harafin "e".
Jimlar lokacin da aka kashe a mataki 2.2.2 t222 = 4 hours.
Yawan kurakurai da aka samu a mataki na 2.2.2 (na tsarin Schumann) n222 = 583 inji mai kwakwalwa.
Mataki na hudu.
Neman sake fasalin filin ya dace da wannan matakin. Daga cikin filayen 44, filayen guda 6:
7 - Manufar tsarin
16 - Yawan benaye na karkashin kasa
17 - Abun iyaye
21 - Majalisar Ƙauye
38 - Ma'auni na tsari (bayani)
40 - Al'adun gargajiya
Ba su da wani shigarwa. Wato ba su da yawa.
Filin "22 - Birni" yana da shigarwa guda ɗaya, Hoto 13.
Hoto 13. Shigar da kawai Z_348653 a cikin filin "Birni".
Filin “34 – Sunan gini” ya ƙunshi abubuwan da ba su dace da manufar filin ba, Hoto na 14.
Hoto 14. Misalin shigarwar da ba ta dace ba.
Mun keɓe waɗannan filayen daga saitin bayanai. Kuma muna yin rikodin canjin a cikin rikodin 214.
Jimlar lokacin da aka kashe akan mataki 4 (na tsarin Schumann) t4 = 2,5 hour.
Yawan kurakurai da aka samu a mataki na 4 (na tsarin Schumann) n4 = 222 inji mai kwakwalwa.
Tebura 6. Binciken bayanan saitin bayanai bayan mataki na 4
Gabaɗaya, nazarin canje-canje a cikin alamomi (Table 6) zamu iya cewa:
1) Matsakaicin matsakaicin adadin alamomi zuwa madaidaicin madaidaicin lever yana kusa da 3, wato, akwai alamun rarraba na yau da kullun (ka'idar sigma shida).
2) Muhimmiyar ƙetare mafi ƙanƙanta da matsakaicin levers daga matsakaicin lever yana nuna cewa nazarin wutsiyoyi shine jagora mai ban sha'awa yayin neman kurakurai.
Bari mu bincika sakamakon gano kurakurai ta amfani da hanyar Schumann.
Matakan zaman banza
2.1. Jimlar lokacin da aka kashe akan mataki 2.1 (na tsarin Schumann) t21 = 1 hour.
Yawan kurakurai da aka samu a mataki na 2.1 (na tsarin Schumann) n21 = 0 inji mai kwakwalwa.
3. Jimlar lokacin da aka kashe akan mataki 3 (na tsarin Schumann) t3 = 0,75 hour.
Yawan kurakurai da aka samu a mataki na 3 (na tsarin Schumann) n3 = 0 inji mai kwakwalwa.
Ingantattun matakai
2.2. Jimlar lokacin da aka kashe akan mataki 2.2.1 (na tsarin Schumann) t221 = 8 hour.
Adadin kurakurai da aka gyara a mataki na 2.2.1 (na tsarin Schumann) n221 = 0 pcs.
Jimlar lokacin da aka kashe a mataki 2.2.2 t222 = 4 hours.
Yawan kurakurai da aka samu a mataki na 2.2.2 (na tsarin Schumann) n222 = 583 inji mai kwakwalwa.
Jimlar lokacin da aka kashe a mataki 2.2 t22 = 8 + 4 = 12 hours.
Yawan kurakurai da aka samu a mataki na 2.2.2 (na tsarin Schumann) n222 = 583 inji mai kwakwalwa.
4. Jimlar lokacin da aka kashe akan mataki 4 (na tsarin Schumann) t4 = 2,5 hour.
Yawan kurakurai da aka samu a mataki na 4 (na tsarin Schumann) n4 = 222 inji mai kwakwalwa.
Tun da akwai matakan sifili waɗanda dole ne a haɗa su a cikin matakin farko na samfurin Schumann, kuma a gefe guda, matakan 2.2 da 4 sun kasance masu zaman kansu masu zaman kansu, sa'an nan kuma an ba da samfurin Schumann ya ɗauka cewa ta hanyar ƙara tsawon lokacin rajistan, yiwuwar yiwuwar. na gano kuskure yana raguwa, wato magudanar ruwa yana rage gazawa, sannan ta hanyar nazarin wannan kwararar za mu tantance matakin da za mu sanya a farko, bisa ga ka'ida, inda yawan gazawar ya fi yawa, za mu sanya matakin farko.
Hoto 15.
Daga ma'auni a cikin Hoto 15 ya bi cewa yana da kyau a sanya mataki na hudu kafin mataki na 2.2 a cikin lissafin.
Yin amfani da dabarar Schumann, muna ƙayyade ƙididdigan adadin farkon kurakurai:
Hoto 16.
Daga sakamakon da ke cikin hoto na 16 za a iya ganin cewa adadin kurakurai da aka yi hasashe shine N2 = 3167, wanda ya zarce mafi ƙarancin ma'auni na 1459.
Sakamakon gyaran, mun gyara kurakurai 805, kuma lambar da aka annabta ita ce 3167 - 805 = 2362, wanda har yanzu ya fi ƙaramin iyakar da muka karɓa.
Mun ayyana siga C, lambda da aikin dogaro:
Hoto 17.
Mahimmanci, lambda shine ainihin ma'anar ƙarfin da ake gano kurakurai a kowane mataki. Idan ka duba a sama, ƙididdigar da ta gabata ta wannan alamar ita ce kurakurai 42,4 a kowace awa, wanda yayi daidai da alamar Schumann. Juya zuwa kashi na farko na wannan kayan, an ƙaddara cewa ƙimar da mai haɓakawa ke gano kurakurai bai kamata ya zama ƙasa da kuskuren 1 a cikin bayanan 250,4 ba, lokacin duba rikodin 1 a minti daya. Don haka mahimmancin darajar lambda don ƙirar Schumann:
60/250,4 = 0,239617.
Wato, buƙatar aiwatar da hanyoyin gano kuskure dole ne a aiwatar da su har sai lambda, daga 38,964 da ake da su, ya ragu zuwa 0,239617.
Ko har sai mai nuna alama N (lambar kurakurai mai yuwuwa) cire n (madaidaicin adadin kurakurai) ya ragu a ƙasa da madaidaicin da muka karɓa (a cikin ɓangaren farko) - 1459 pcs.
source: www.habr.com