Ngenisa amanani okushintshanisa kusukela ku-inthanethi

Ukungenisa isilinganiso sohlobo lwemali olunikeziwe ku-inthanethi ngokuzibuyekeza okuzenzakalelayo kuwumsebenzi ovame kakhulu kubasebenzisi abaningi be-Microsoft Excel. Cabanga ukuthi unohlu lwamanani okumele lubalwe kabusha njalo ekuseni ngokwezinga lokushintshisana. Noma isabelomali sephrojekthi. Noma izindleko zenkontileka, okumele zibalwe kusetshenziswa izinga lokushintshaniswa kwedola ngosuku lokuphela kwenkontileka.

Ezimweni ezinjalo, ungakwazi ukuxazulula inkinga ngezindlela ezahlukene - konke kuncike ekutheni iyiphi inguqulo ye-Excel oyifakile nokuthi yiziphi izengezo eziphezu kwayo.

Indlela yoku-1: Isicelo esilula sewebhu sezinga lokushintshisana kwamanje

Le ndlela ifanele labo abasenezinguqulo ezindala ze-Microsoft Office 2003-2007 kukhompyutha yabo. Ayisebenzisi noma yiziphi izengezo zenkampani yangaphandle noma amamakhro futhi isebenza kuphela emisebenzini eyakhelwe ngaphakathi.

Chofoza inkinobho Kusuka ku-inthanethi (Iwebhu) ithebhu Idatha (Usuku). Efasiteleni elivelayo, kulayini Ikheli (Ikheli) faka i-URL yesayithi lapho kuzothathwa khona ulwazi (isibonelo, http://www.finmarket.ru/currency/rates/) bese ucindezela ukhiye Faka.

Lapho ikhasi lilayisha, imicibisholo emnyama nephuzi izovela kumathebula i-Excel engawangenisa. Ukuchofoza umcibisholo onjalo kuphawula ithebula lokungenisa.

Uma wonke amathebula adingekayo amakiwe, chofoza inkinobho Ngenisa (Ngenisa) phansi kwefasitela. Ngemva kwesikhathi esidingekayo ukuze kulayishwe idatha, okuqukethwe kwamathebula amakiwe kuzovela kumaseli eshidi:

Ukuze wenze ngokwezifiso okwengeziwe, ungachofoza kwesokudla kunoma yiliphi kulawa maseli bese ukhetha umyalo kumenyu yokuqukethwe. Range izakhiwo (Izici zebanga ledatha).Kuleli bhokisi lengxoxo, uma uthanda, kungenzeka ukuthi ulungiselele imvamisa yokuvuselela neminye imingcele:

Izilinganiso zesitoko, njengoba zishintsha njalo emizuzwini embalwa, ungabuyekeza kaningi (ibhokisi lokuhlola Vuselela njalo ngemizuzu engu-N.), kodwa amanani okushintshanisa, ezimweni eziningi, kwanele ukuvuselela kanye ngosuku (ibhokisi lokuhlola Isibuyekezo kufayela sivuliwe).

Qaphela ukuthi lonke uhla olungenisiwe lwedatha luphathwa yi-Excel njengeyunithi eyodwa futhi inikezwe igama layo, elingabonakala kokuthi Umphathi Wegama kuthebhu. formula (Amafomula — Umphathi Wegama).

Indlela 2: Umbuzo wewebhu weParametric ukuze uthole inani lokushintshisana lebanga ledethi elinikeziwe

Le ndlela iwukhetho lokuqala oluthuthukisiwe kancane futhi inika umsebenzisi ithuba lokuthola isilinganiso sokushintshisana sohlobo lwemali olufunayo hhayi nje kuphela ngosuku lwamanje, kodwa nanoma iyiphi enye idethi noma idethi yesikhawu senzuzo. Ukuze senze lokhu, isicelo sethu sewebhu kufanele siguqulwe sibe ipharamitha, okungukuthi sengeze amapharamitha amabili acacisayo kuso (ikhodi yohlobo lwemali esiyidingayo kanye nedethi yamanje). Ukuze senze lokhu, senza lokhu okulandelayo:

1. Sakha isicelo sewebhu (bona indlela 1) ekhasini lewebhusayithi yeBhange Elikhulu Lezwe Lethu elinengobo yomlando yezifundo: http://cbr.ru/currency_base/dynamics.aspx

2. Efomini elingakwesokunxele, khetha uhlobo lwemali olufunayo bese usetha izinsuku zokuqala nezokugcina:

3. Chofoza inkinobho Ukuze uthole idatha futhi ngemva kwemizuzwana embalwa sibona ithebula elinamanani esifundo esiwadingayo ngesikhathi esimisiwe sosuku. Skrolela ithebula eliwumphumela uye phansi bese ulimaka ukuze lingeniswe ngokuchofoza umcibisholo omnyama nophuzi ekhoneni elingezansi kwesokunxele lekhasi lewebhu (ungabuzi nje ukuthi kungani lo mcibisholo ukhona futhi ungekho eduze kwetafula – lokhu umbuzo wabaklami besayithi).

Manje sifuna inkinobho ene-floppy disk ekhoneni eliphezulu kwesokudla sefasitela Londoloza Isicelo (Gcina Umbuzo) futhi ulondoloze ifayela nemingcele yesicelo sethu kunoma iyiphi ifolda efanelekile ngaphansi kwanoma yiliphi igama elikahle - isibonelo, ku Amadokhumenti ami ngaphansi kwegama cbr. iqy.  Ngemuva kwalokho, iwindi Lombuzo Wewebhu kanye nawo wonke ama-Excel angavalwa okwamanje.

4. Vula ifolda lapho ugcine khona isicelo bese ubheka ifayela lesicelo cbr. iqy, bese uchofoza kuso kwesokudla - Vula Nge-Notepad (noma uyikhethe ohlwini - ngokuvamile iyifayela I-Notepad.exe kusuka kufolda C: IWindows). Ngemva kokuvula ifayela lesicelo ku-Notepad, kufanele ubone okuthile okufana nalokhu:

Into ebaluleke kakhulu lapha umugqa onekheli kanye nemingcele yemibuzo ekuwo, esizoyishintsha - ikhodi yemali esiyidingayo (egqanyiswe ngokubomvu) kanye nedethi yokuphela, esizoyibeka esikhundleni sanamuhla (eqokonyiswe ku- blue). Hlela kahle ulayini ukuze uthole okulandelayo:

http://cbr.ru/currency_base/dynamics.aspx?VAL_NM_RQ=[“Ikhodi yemali”]&date_req1=01.01.2000&r1=1&date_req2=[«Idethi»]&rt=1&mode=1

Shiya konke okunye njengoba kunjalo, londoloza futhi uvale ifayela.

5. Dala ibhuku elisha ku-Excel, vula ishidi lapho sifuna ukungenisa khona inqolobane yamazinga eBhange Elikhulu. Kunoma iyiphi iseli efanelekile, faka ifomula ezosinika idethi yamanje ngefomethi yombhalo esikhundleni sombuzo:

=UMBHALO(NAMHLANJE();”DD.MM.YYYY”)

noma ngenguqulo yesiNgisi

=UMBHALO(NAMUHLA(),»dd.mm.yyyy»)

Endaweni ethile eduzane sifaka ikhodi yohlobo lwemali esiyidingayo etafuleni:

Ikhodi edingekayo ingabhekwa ochungechungeni lwemibuzo ngqo kuwebhusayithi yeBhange Elikhulu.

6. Silayisha idatha eshidini, sisebenzisa amaseli adaliwe kanye nefayela le-cbr.iqy njengesisekelo, okungukuthi hamba kuthebhu Idatha - Ukuxhumana - Thola Abanye (Idatha - Ukuxhumana Okukhona). Ewindini lokukhetha umthombo wedatha elivulayo, thola futhi uvule ifayela cbr. iqy. Ngaphambi kokungenisa, i-Excel izocacisa izinto ezintathu nathi.

Okokuqala, ungangenisa kuphi ithebula ledatha:

Okwesibili, ungayithola kuphi ikhodi yemali (ungahlola ibhokisi Sebenzisa leli nani elizenzakalelayo (Sebenzisa leli nani/referensi ukuze uthole ukuvuselela okuzayo), ukuze ngokuhamba kwesikhathi isikhathi ngasinye leli seli lingacaciswanga phakathi nokubuyekezwa kanye nebhokisi lokuhlola Buyekeza ngokuzenzakalelayo lapho inani leseli lishintsha (Vuselela ngokuzenzakalelayo lapho inani leseli lishintsha):

Okwesithathu, kuliphi iseli okufanele kuthathwe ngalo idethi yokuphela (ungaphinda uhlole womabili amabhokisi lapha ukuze kusasa ungadingi ukusetha le mingcele ngokwenza uma ubuyekeza):

Chofoza OK, linda imizuzwana embalwa bese uthola ingobo yomlando ephelele yezinga lokushintshanisa lemali oyifunayo eshidini:

Njengendlela yokuqala, ngokuchofoza kwesokudla kudatha engenisiwe bese ukhetha umyalo Range izakhiwo (Izici zebanga ledatha), ungalungisa izinga lokuvuselela Lapho uvula ifayela (Qalisa kabusha kufayela livuliwe). Khona-ke, uma ukwazi ukufinyelela ku-inthanethi, idatha izobuyekezwa ngokuzenzakalelayo nsuku zonke, okungukuthi Ithebula lizobuyekezwa ngokuzenzakalelayo nedatha entsha.

Kulula kakhulu ukukhipha inani ledethi oyifunayo etafuleni lethu usebenzisa umsebenzi VPR (VLOOKUP) – uma ungayazi, ngikweluleka ngokuqinile ukuthi wenze lokhu. Ngefomula enjalo, ngokwesibonelo, ungakhetha izinga lokushintshaniswa kwedola langoJanuwari 10, 2000 etafuleni lethu:

noma ngesiNgisi =VLOOKUP(E5,cbr,3,1)

lapho

• E5 – iseli eliqukethe usuku olunikeziwe
  
• cbr - igama lebanga ledatha (elikhiqizwa ngokuzenzakalelayo ngesikhathi sokungenisa futhi ngokuvamile lifana negama lefayela lombuzo)
• 3 - inombolo ye-serial yekholomu etafuleni lethu, lapho sithola khona idatha
• 1 – i-agumenti ehlanganisa ukusesha okulinganiselwe komsebenzi we-VLOOKUP ukuze ukwazi ukuthola izifundo zalezo zinsuku eziphakathi nendawo ezingekho kukholomu A (idethi yangaphambili eseduze kanye nesifundo sayo). Ungafunda kabanzi mayelana nokusesha cishe usebenzisa umsebenzi we-VLOOKUP lapha.

• Imakhro ukuze uthole inani ledola ledethi eshiwo kuseli yamanje
• Umsebenzi wokwengeza we-PLEX ukuze uthole izinga lokushintshisana ngedola, i-euro, i-hryvnia, i-pound sterling, njll. nganoma yiluphi usuku olunikeziwe.
• Faka noma yiliphi izinga lohlobo lwemali nganoma iyiphi idethi kusengezo se-PLEX