Okuqukethwe
Ake sicabange ukuthi ubonise umqondo webhizinisi kanye ne-intuition futhi wathenga izingxenye ezimbalwa ze-cryptocurrency ethile (i-bitcoin efanayo, isibonelo) esikhathini esidlule. Ngendlela yetafula elihlakaniphile, "iphothifoliyo yakho yokutshala imali" ibukeka kanje:
Umsebenzi: ukuhlola ngokushesha inani lamanje lemali oyitshalile ngesilinganiso samanje se-cryptocurrency. Sizothatha isifundo ku-inthanethi kunoma iyiphi indawo efanelekile (i-exchange, exchanger) kanye nesilinganiso sokwethembeka.
Esinye sezixazululo - isicelo sewebhu sakudala - sengicabange ngokuningiliziwe ngisebenzisa isibonelo sokungenisa izinga lokushintshisana. Manje ake sizame, ukuze siguqule, sisebenzise enye indlela - isengezo Sombuzo Wamandla, esilungele ukungenisa idatha ku-Excel kusuka emazweni angaphandle, kuhlanganise ne-Inthanethi.
Ukukhetha isayithi ozongenisa
Iyiphi indawo esizoyithatha idatha - lokhu, ngokuvamile, akunandaba. Umbuzo wewebhu we-Excel wakudala unzima kakhulu esakhiweni nakumklamo wangaphakathi wekhasi lewebhu elingenisiwe futhi kwesinye isikhathi awusebenzi kuwo wonke amasayithi. I-Power Query i-omnivorous kakhulu kule ndaba. Ngakho ungathatha isilinganiso sokuthenga esimaphakathi ongakhetha kuso:
- kuma-exchangers www.bestchange.ru - izinketho eziningi, ubungozi obuncane, kodwa hhayi izinga lokushintshana elinenzuzo kakhulu
- kusukela ku-platform yokuhweba www.localbitcoins.net - ingozi encane, kodwa izinga elingcono kakhulu
- kusuka kuwebhusayithi yokushintshanisa - uma uhweba ngokuqondile ekuhwebeni, awusidingi neze lesi sihloko 🙂
Okokuqala, ake sivule isayithi esilidingayo kusiphequluli. Ake sithathe, ngokukhonkolo, isiteji sokuhweba localbitcoins.net. Khetha ithebhu ephezulu Ukudayiswa okusheshayo kanye nenketho Ukudlulisa ngebhange elithile (noma okunye okudingayo) bese ucindezela inkinobho Ukucinga:
Manje udinga ukukopisha ikheli lekhasi elivela ebhodini lokunamathisela, ngoba. iqukethe wonke amapharamitha wesicelo esiwadingayo:
https://localbitcoins.net/instant-bitcoins/?action=ukuthengisa&ikhodi_yezwe=RU&amount=¤cy=RUB&indawo_izwe=RUkanye nomhlinzeki_woku-inthanethi=I-SPECIFIC_BANK&find-offers=SeshaBese kuba Umbuzo Wamandla.
Ukungenisa isifundo ku-Excel usebenzisa i-Power Query
Uma une-Excel 2010-2013 kanye ne-Power Query efakwe njengesengezo esihlukile, khona-ke umyalo esiwudingayo ukuthebhu yegama elifanayo - Umbuzo Wamandla. Uma une-Excel 2016, bese kuthebhu Idatha (Usuku) cindezela inkinobho Kusuka ku-inthanethi (Kusuka ku-Intanethi). Ewindini elivelayo udinga ukunamathisela ikheli lekhasi lewebhu elikopishiwe esigabeni sangaphambilini bese uchofoza OK:
Ngemva kokuhlaziya ikhasi lewebhu, Umbuzo Wamandla uzoveza iwindi elinohlu lwamathebula angangeniswa. Udinga ukuthola ithebula elidingekayo ohlwini olungakwesokunxele (kukhona amaningana), ugxile ekubukeni kuqala kwesokudla, bese uchofoza inkinobho engezansi. Ukulungiswa (Hlela):
Ngemva kwalokho, iwindi elikhulu lomhleli wombuzo we-Power Query lizovuleka, lapho singakhetha khona imigqa edingekayo kuphela futhi silinganise izinga lokuthenga phezu kwayo:
Ngincoma ukuthi siqambe kabusha isicelo sethu ngokushesha kuphaneli engakwesokudla, ngisinike igama elihlakaniphile:
Ukuhlunga nokuhlanza idatha
Ngokuzayo, sizodinga kuphela amakholomu anezincazelo Indlela yokukhokha kanye nenani lokuthenga Inani / BTC - ukuze ukwazi ukuhlukanisa ngokuphepha ngazo zombili Ctrl futhi ngokuchofoza kwesokudla kuzo, khetha umyalo Susa amanye amakholomu (Susa amanye amakholomu) - wonke amakholomu azosuswa ngaphandle kwalawo akhethiwe.
Ake sithi sifuna ukukhetha kuphela labo abadayisi abasebenza ngokusebenzisa Sberbank. Isihlungi siyinto eyaziwayo, kodwa i-nuance ukuthi isihlungi ku-Power Query sibucayi, okungukuthi i-Sberbank, i-Sberbank ne-Sberbank ayifani kuye. Ngakho-ke, ngaphambi kokukhetha imigqa edingekayo, ake silethe indaba yazo zonke izincazelo ngendlela eyodwa. Ukuze wenze lokhu, udinga ukukhetha ikholomu Indlela yokukhokha nakuthebhu Uguquko khetha iqembu Ifomethi – ngofeleba abancane (Guqula — Ifomethi — Ikesi eliphansi):
Manje hlunga ngekholomu Indlela yokukhokha usebenzisa inketho Izihlungi Zombhalo - Iqukethe (Izihlungi zombhalo — Ziqukethe):
Efasiteleni lesihlungi, shintsha ngokushesha usuke phezulu uye kumodi Ukwengeza (Okuthuthukisiwe) bese wethula imithetho emithathu yokukhetha:
Njengoba ungase uqagele, ngokwenza lokhu sikhetha yonke imigqa lapho igama elithi “sber” likhona noma ngesiNgisi, kanye nalabo abasebenza kunoma yiliphi ibhange. Ungakhohlwa ukusetha isixhumanisi esinengqondo kwesokunxele Or (OR) esikhundleni И (Futhi) Uma kungenjalo, umthetho ngeke usebenze ngendlela efanele. Ngemva kokuchofoza OK Izinketho esizidingayo kuphela okufanele zihlale esikrinini:
Manje susa ikholomu Indlela yokukhokha chofoza kwesokudla kunhlokweni yekholomu Susa ikholomu (Susa ikholomu) futhi usebenze ngokuqhubekayo ngekholomu eyodwa esele yezifundo:
Inkinga ngayo ukuthi kukhona, ngaphezu kwenombolo, kukhona nokuqokwa kwemali. Lokhu kungahlanzwa kalula ngokufaka esikhundleni esilula ngokuchofoza kwesokudla isihloko sekholomu bese ukhetha umyalo. Ukushintsha amanani (Shintsha amanani):
Izinombolo ezitholwe ngemva kokususwa kwe-RUB, empeleni, nazo azizona izinombolo okwamanje, ngoba zisebenzisa ama-delimiters angajwayelekile. Lokhu kungelapheka ngokuchofoza inkinobho yefomethi kunhlokweni yethebula bese ukhetha inketho Kusetshenziswa indawo (Sebenzisa abantu bendawo):
Indawo efaneleke kakhulu ingaba IsiNgisi (US) kanye nohlobo lwedatha - Дinombolo yedesimali:
Ngemuva kokuchofoza OK sizothola amanani aphelele amanani amanani okuthenga:
Kusele ukubala isilinganiso sabo kuthebhu Uguquko – Izibalo – Isilinganiso (Guqula — Izibalo — Isilinganiso) bese ulayisha inombolo ewumphumela eshidini ngomyalo Ikhaya - Vala futhi Ulayishe - Vala futhi Ulayishe... (Ekhaya — Vala & Layisha — Vala & Layisha Ku…):
Manje singakwazi ukwengeza isixhumanisi senani elilandiwe kufomula etafuleni lethu lephothifoliyo futhi sibale umehluko wenani lakho konke utshalomali lwethu okwamanje:
Manje ungakwazi ukuvula leli fayela ngezikhathi ezithile, uchofoze kwesokudla ku-prompt bese ukhetha umyalo Buyekeza & Londoloza (Vuselela), bheka izinguquko ezizolayishwa ngokuzenzakalelayo etafuleni lethu.
PS
Njengoba ungase ucabange kalula, ngendlela efanayo ungakwazi ukungenisa izinga le-bitcoin kuphela, kodwa nanoma iyiphi enye imali, isitoko noma ukuphepha. Into esemqoka ukuthola isayithi elifanele futhi wakhe umbuzo, bese i-smart Power Query izokwenza konke.
- Ngenisa amanani okushintshanisa kusukela ku-inthanethi
- Umsebenzi wokuthola inani lokushintshanisa lanoma iyiphi idethi ethile
- Ukuhlanganisa amatafula avela kumafayela ahlukene kusetshenziswa Umbuzo Wamandla