В
Ingxenye engokoqobo yethulwa ngendlela yezinyathelo. Konke ukuhlanza kwenziwa ku-Excel, njengoba ithuluzi elivame kakhulu kanye nemisebenzi echazwe ingaphinda iphindwe ngochwepheshe abaningi abazi i-Excel. Futhi iwufanelekele kahle umsebenzi wezandla.
Isiteji se-zero sizoba umsebenzi wokwethula nokugcina ifayela, njengoba liyi-100 MB ngosayizi, bese kuthi inani lale misebenzi libe amashumi namakhulu, kuthatha isikhathi esibalulekile.
Ukuvula, ngokwesilinganiso, kuyimizuzwana engama-30.
Ukonga - 22 isekhondi.
Isigaba sokuqala siqala ngokunquma izinkomba zezibalo zedathasethi.
Ithebula 1. Izinkomba zezibalo zedathasethi
Ubuchwepheshe 2.1.
Sakha inkambu yokusiza, nginayo ngaphansi kwenombolo - AY. Ekungeneni ngakunye, sakha ifomula ethi “=LENGTH(F365502)+LENGTH(G365502)+…+LENGTH(AW365502)”
Isikhathi esiphelele esichithwe esiteji 2.1 (kufomula ye-Schumann) t21 = ihora elingu-1.
Inombolo yamaphutha atholwe esigabeni 2.1 (yefomula ye-Schumann) n21 = 0 ama-pcs.
Isigaba sesibili.
Ihlola izingxenye zedathasethi.
2.2. Wonke amanani kumarekhodi akhiwa kusetshenziswa izimpawu ezijwayelekile. Ngakho-ke, ake silandele izibalo ngezimpawu.
Ithebula 2. Izinkomba zezibalo zezinhlamvu kudathasethi enokuhlaziywa kokuqala kwemiphumela.
Ubuchwepheshe 2.2.1.
Sakha inkambu yokusiza - "alpha1". Kurekhodi ngalinye, sakha ifomula ethi “=CONCATENATE(Ishidi1!B9;...Ishidi1!AQ9)”
Sakha iseli ye-Omega-1 engashintshi. Sizoshintshana ngokufaka amakhodi wezinhlamvu ngokuya nge-Windows-1251 ukusuka ku-32 kuye ku-255 kule seli.
Sakha inkambu yokusiza - "alpha2". Ngefomula ethi “=THOLA(SYMBOL(Omega,1); “alpha1”,N)”.
Sakha inkambu yokusiza - "alpha3". Ngefomula ethi “=IF(ISNUMBER(“alpha2”,N),1)”
Dala iseli elingashintshi elithi “Omega-2”, elinefomula ethi “=SUM(“alpha3”N1: “alpha3”N365498)”
Ithebula 3. Imiphumela yokuhlaziywa kokuqala kwemiphumela
Ithebula 4. Amaphutha aqoshiwe kulesi sigaba
Isikhathi esiphelele esichithwe esiteji 2.2.1 (kufomula ye-Schumann) t221 = ihora elingu-8.
Inombolo yamaphutha alungisiwe esigabeni 2.2.1 (yefomula ye-Schumann) n221 = 0 ama-pcs.
Isigaba 3
Isinyathelo sesithathu ukurekhoda isimo sedathasethi. Ngokunikeza irekhodi ngalinye inombolo eyingqayizivele (ID) kanye nenkambu ngayinye. Lokhu kuyadingeka ukuze uqhathanise idathasethi eguquliwe neyokuqala. Lokhu kuyadingeka futhi ukuze usebenzise ngokugcwele amakhono okuqoqa nokuhlunga. Lapha futhi siphendukela kuthebula 2.2.2 bese sikhetha uphawu olungasetshenziswa kudathasethi. Sithola lokho okuboniswe kuMfanekiso 10.
Umfanekiso we-10. Inikeza izihlonzi.
Isikhathi esiphelele esichithwe esiteji 3 (kufomula ye-Schumann) t3 = ihora elingu-0,75.
Inombolo yamaphutha atholwe esigabeni 3 (yefomula ye-Schumann) n3 = 0 ama-pcs.
Njengoba ifomula ye-Schumann idinga ukuthi isiteji sigcwaliswe ngokulungisa amaphutha. Asibuyele esigabeni 2.
Isigaba 2.2.2
Kulesi sinyathelo sizophinda silungise izikhala eziphindwe kabili nezikathathu.
Umfanekiso we-11. Inombolo yezikhala ezikabili.
Ukulungiswa kwamaphutha akhonjwe kuthebula 2.2.4.
Ithebula 5. Isigaba sokulungisa amaphutha
Isibonelo sokuthi kungani isici esifana nokusetshenziswa kwezinhlamvu “e” noma “e” sibalulekile sivezwe kuMfanekiso 12.
Umfanekiso we-12. Umehluko kuhlamvu "e".
Isikhathi esiphelele esichithwe kusinyathelo 2.2.2 t222 = amahora angu-4.
Inombolo yamaphutha atholwe esigabeni 2.2.2 (yefomula ye-Schumann) n222 = 583 ama-pcs.
Isigaba sesine.
Ukuhlola ukuchithwa kwenkundla kufanelana kahle nalesi sigaba. Ezinkambuni ezingama-44, izinkambu eziyisi-6:
7 - Inhloso yesakhiwo
16 - Inani lephansi elingaphansi komhlaba
17 - Into yomzali
21 - UMkhandlu Wesigodi
38 - Amapharamitha wesakhiwo (incazelo)
40 – Amagugu Ezamasiko
Abanakho okufakiwe. Okusho ukuthi, abasasebenzi.
Inkundla "22 - Idolobha" inokufakwa okukodwa, Umfanekiso 13.
Umfanekiso we-13. Okungenayo kuphela yi-Z_348653 kunkambu ethi "Idolobha".
Inkambu ethi “34 - Igama lesakhiwo” iqukethe okufakiwe okungahambisani kahle nenjongo yenkundla, Umfanekiso 14.
Umfanekiso we-14. Isibonelo sokungeniswa okungathobeli.
Asizifaki lezi zindawo kudathasethi. Futhi siqopha ushintsho kumarekhodi angama-214.
Isikhathi esiphelele esichithwe esiteji 4 (kufomula ye-Schumann) t4 = ihora elingu-2,5.
Inombolo yamaphutha atholwe esigabeni 4 (yefomula ye-Schumann) n4 = 222 ama-pcs.
Ithebula 6. Ukuhlaziywa kwezinkomba zesethi yedatha ngemva kwesigaba sesi-4
Ngokuvamile, ukuhlaziya izinguquko ezinkomba (Ithebula 6) singasho ukuthi:
I-1) Isilinganiso senani elijwayelekile lezimpawu ku-lever ejwayelekile yokuchezuka iseduze no-3, okungukuthi, kunezibonakaliso zokusabalalisa okuvamile (umthetho oyisithupha we-sigma).
2) Ukuchezuka okubalulekile kwezinsimbi ezincane neziphezulu ukusuka ku-lever evamile kuphakamisa ukuthi ukufundwa kwemisila kuyisiqondiso esithembisayo lapho kuseshwa amaphutha.
Ake sihlole imiphumela yokuthola amaphutha sisebenzisa indlela kaSchumann.
Izigaba zokungenzi lutho
2.1. Isikhathi esiphelele esichithwe esiteji 2.1 (kufomula ye-Schumann) t21 = ihora elingu-1.
Inombolo yamaphutha atholwe esigabeni 2.1 (yefomula ye-Schumann) n21 = 0 ama-pcs.
3. Isikhathi esiphelele esichithwe esiteji 3 (kufomula ye-Schumann) t3 = ihora elingu-0,75.
Inombolo yamaphutha atholwe esigabeni 3 (yefomula ye-Schumann) n3 = 0 ama-pcs.
Izigaba ezisebenzayo
2.2. Isikhathi esiphelele esichithwe esiteji 2.2.1 (kufomula ye-Schumann) t221 = ihora elingu-8.
Inombolo yamaphutha alungisiwe esigabeni 2.2.1 (yefomula ye-Schumann) n221 = 0 ama-pcs.
Isikhathi esiphelele esichithwe kusinyathelo 2.2.2 t222 = amahora angu-4.
Inombolo yamaphutha atholwe esigabeni 2.2.2 (yefomula ye-Schumann) n222 = 583 ama-pcs.
Isikhathi esiphelele esichithwe esinyathelweni 2.2 t22 = 8 + 4 = amahora ayi-12.
Inombolo yamaphutha atholwe esigabeni 2.2.2 (yefomula ye-Schumann) n222 = 583 ama-pcs.
4. Isikhathi esiphelele esichithwe esiteji 4 (kufomula ye-Schumann) t4 = ihora elingu-2,5.
Inombolo yamaphutha atholwe esigabeni 4 (yefomula ye-Schumann) n4 = 222 ama-pcs.
Njengoba kunezigaba zero okufanele zifakwe esigabeni sokuqala semodeli ye-Schumann, futhi ngakolunye uhlangothi, izigaba 2.2 no-4 zizimele ngokwemvelo, bese zinikezwa ukuthi imodeli ye-Schumann ithatha ukuthi ngokwandisa isikhathi sesheke, amathuba wokubona iphutha liyancipha, okungukuthi, ukugeleza kunciphisa ukwehluleka, khona-ke ngokuhlola lokhu kugeleza sizonquma ukuthi yisiphi isigaba okufanele sibeke kuqala, ngokusho komthetho, lapho ukuminyana kokuhluleka kuvame kakhulu, sizobeka leso sigaba kuqala.
Umdwebo 15.
Kusukela kufomula ekuMfanekiso 15 kuyalandela ukuthi kungcono ukubeka isigaba sesine ngaphambi kwesigaba 2.2 ezibalo.
Sisebenzisa ifomula ka-Schumann, sinquma inani elilinganiselwe lamaphutha:
Umdwebo 16.
Kusukela emiphumeleni eku-Figure 16 kungabonakala ukuthi inani elibikezelwe lamaphutha ngu-N2 = 3167, elingaphezu kwesilinganiso esincane se-1459.
Njengomphumela wokulungisa, silungise amaphutha angu-805, futhi inombolo ebikezelwe ngu-3167 - 805 = 2362, esengaphezu komkhawulo omncane esiwamukele.
Sichaza ipharamitha C, i-lambda nomsebenzi wokwethembeka:
Umdwebo 17.
Empeleni, i-lambda iyinkomba yangempela yokuqina okutholwa ngakho amaphutha esigabeni ngasinye. Uma ubheka ngenhla, isilinganiso sangaphambilini sale nkomba sasingamaphutha angu-42,4 ngehora, okufana kakhulu nenkomba ye-Schumann. Ukuphendukela engxenyeni yokuqala yale nto, kunqunywe ukuthi izinga umthuthukisi athola ngalo amaphutha akufanele libe ngaphansi kwephutha elingu-1 ngamarekhodi angu-250,4, lapho ehlola irekhodi elingu-1 ngomzuzu. Ngakho-ke inani elibalulekile le-lambda lemodeli ye-Schumann:
60/250,4 = 0,239617.
Okusho ukuthi, isidingo sokwenza izinqubo zokutholwa kwephutha kufanele senziwe kuze kube yilapho i-lambda, kusukela ku-38,964 ekhona, yehla yaba ngu-0,239617.
Noma kuze kube yilapho inkomba engu-N (inani elingase libe khona lamaphutha) susa n (inani elilungisiwe lamaphutha) incipha ngaphansi komkhawulo esiwamukele (engxenyeni yokuqala) - 1459 pcs.
Source: www.habr.com