Contents
Bari mu ɗauka cewa kun nuna ma'anar kasuwanci da hankali kuma kun sayi sassa da yawa na wasu cryptocurrency (misali bitcoin iri ɗaya) a baya. A cikin sigar tebur mai wayo, “takardar jari” naku tayi kama da haka:
Aiki: don kimanta ƙimar hannun jarin ku na yanzu akan ƙimar cryptocurrency na yanzu. Za mu dauki kwas a kan Intanet daga kowane shafin da ya dace (musanya, musayar) da matsakaici don aminci.
Ɗayan mafita - buƙatun gidan yanar gizo na yau da kullun - Na riga na yi la'akari dalla-dalla ta amfani da misalin shigo da kuɗin musanya. Yanzu bari mu gwada, don canji, don amfani da wata hanya - ƙarar Query Query, wanda ya dace don shigo da bayanai cikin Excel daga duniyar waje, gami da Intanet.
Zaɓi wurin da za a shigo da shi
Daga wane rukunin yanar gizon za mu ɗauki bayanan - wannan, gabaɗaya, ba shi da mahimmanci. Tambayar yanar gizo ta Excel ta al'ada tana da matuƙar buƙata akan tsari da ƙirar ciki na shafin yanar gizon da aka shigo da shi kuma wani lokacin baya aiki akan kowane rukunin yanar gizo. Tambayar Wutar Wuta ta fi kowa komai a wannan lamarin. Don haka kuna iya ɗaukar matsakaicin ƙimar siyayya don zaɓar daga:
- a cikin masu musanya www.bestchange.ru - babban zaɓi na zaɓuɓɓuka, ƙananan haɗari, amma ba ƙimar musayar riba mai yawa ba.
- daga dandalin ciniki www.localbitcoins.net - ɗan ƙaramin haɗari, amma mafi kyawun ƙimar
- daga gidan yanar gizon musayar - idan kun kasuwanci kai tsaye akan musayar, to da wuya ku buƙaci wannan labarin 🙂
Da farko, bari mu buɗe rukunin yanar gizon da muke buƙata a cikin burauzar. Bari mu ɗauki, don kankare, dandalin ciniki localbitcoins.net. Zaɓi shafin saman Siyar da sauri da zabin Canja wurin ta wani banki na musamman (ko duk wani abin da kuke buƙata) kuma danna maɓallin search:
Yanzu kuna buƙatar kwafi adireshin shafin da ya bayyana a allon allo, saboda. ya ƙunshi duk sigogin buƙatar da muke buƙata:
https://localbitcoins.net/instant-bitcoins/?action=sayar da&kasa_code=RU& adadin = ¤cy =Rub&wuri_kasa=RU& kan layi_mai bayarwa=SPECIFIC_BANK&find-offers=BincikeSa'an nan ya kai ga Power Query.
Ana shigo da kwas zuwa Excel ta amfani da Query Query
Idan kuna da Excel 2010-2013 da Query da aka shigar azaman ƙara-in daban, to umarnin da muke buƙata yana kan shafin sunan iri ɗaya - Tambayar .arfi. Idan kuna da Excel 2016, to akan shafin data (Kwanan wata) danna maɓallin Daga Intanet (Daga Intanet). A cikin taga da ya bayyana sannan kuna buƙatar liƙa adireshin gidan yanar gizon da aka kwafi daga sakin layi na baya sannan ku danna OK:
Bayan tantance shafin yanar gizon, Tambayar Wutar Lantarki zata nuna taga tare da jerin teburi waɗanda za'a iya shigo da su. Kuna buƙatar nemo teburin da ake buƙata a cikin jeri na hagu (akwai da yawa daga cikinsu), mai da hankali kan samfoti a dama, sannan danna maɓallin da ke ƙasa. gyara (Edit):
Bayan haka, babban taga na editan Query Query zai buɗe, inda zamu iya zaɓar layuka masu mahimmanci kawai da matsakaicin adadin siye akan su:
Ina ba da shawarar canza sunan buƙatarmu nan da nan a cikin kwamitin da ke hannun dama, tare da ba shi suna mai hankali:
Tace da tsaftace bayanan
A nan gaba, kawai za mu buƙaci ginshiƙai tare da kwatance Hanyar biyan da yawan sayayya Farashin / BTC – don haka za ka iya amince bambanta su duka da Ctrl kuma ta danna-dama akan su, zaɓi umarnin Share wasu ginshiƙai (Cire wasu ginshiƙai) – za a share duk ginshiƙai ban da waɗanda aka zaɓa.
Bari mu ce muna so mu zaɓi waɗanda 'yan kasuwa waɗanda ke aiki ta hanyar Sberbank. Tace wani abu ne da aka saba da shi, amma abin lura shine tace a cikin Power Query yana da mahimmanci, watau Sberbank, Sberbank da Sberbank ba iri ɗaya bane a gare shi. Saboda haka, kafin zabar layukan da suka dace, bari mu kawo batun duk bayanin zuwa nau'i ɗaya. Don yin wannan, kuna buƙatar zaɓar shafi Hanyar biyan kuma a kan tab Sake Kama zabi tawagar Tsarin - ƙananan haruffa (Canza - Tsarin - Karamin Harka):
Yanzu tace ta shafi Hanyar biyan ta amfani da zaɓi Tace Rubutu – Ya ƙunshi (Masu tace rubutu - Ya ƙunshi):
A cikin taga tace, nan da nan canza daga sama zuwa yanayin Ƙari (Advanced) kuma gabatar da dokoki guda uku don zaɓar:
Kamar yadda zaku iya tsammani, ta yin haka za mu zaɓi duk layin da kalmar "sber" ta kasance a cikin ko Ingilishi, da waɗanda ke aiki ta kowane banki. Kar a manta don saita hanyar haɗin kai mai ma'ana akan hagu Or (OR) maimakon И (Kuma) In ba haka ba, mulkin ba zai yi aiki daidai ba. Bayan danna kan OK Zaɓuɓɓukan da muke buƙata kawai yakamata su kasance akan allon:
Yanzu cire ginshiƙi Hanyar biyan danna dama akan rubutun shafi Share shafi (Cire shafi) kuma kuyi aiki tare da sauran rukunin kwasa-kwasan guda ɗaya:
Matsalar da ke tattare da ita ita ce, a can, ban da lambar, akwai kuma nadin kudin. Ana iya tsabtace wannan cikin sauƙi tare da sauƙi mai sauƙi ta danna-dama a kan jigon shafi kuma zaɓi umarnin Maye gurbin dabi'u (Maye gurbin dabi'u):
Lambobin da aka samu bayan cire RUB, a gaskiya ma, ba lambobi ba ne tukuna, saboda suna amfani da ma'auni marasa daidaituwa. Ana iya warkar da wannan ta danna maɓallin tsari a cikin taken tebur sannan zaɓi zaɓi Amfani da Yanki (Amfani na gida):
Mafi dacewa wurin zai kasance Turanci (US) da data type - Дlambar adadi:
Bayan danna kan OK za mu sami cikakkun ƙimar ƙimar siyayya:
Ya rage don ƙididdige matsakaicin su akan shafin Canji - Ƙididdiga - Matsakaici (Canza - ƙididdiga - Matsakaici) kuma loda sakamakon lambar zuwa takardar tare da umarnin Gida - Rufe kuma Loda - Rufe kuma Load a… (Gida - Rufe & Load - Kusa & Loda zuwa…):
Yanzu za mu iya ƙara hanyar haɗi zuwa ƙimar da aka zazzage a cikin dabarar zuwa teburin fayil ɗin mu kuma mu lissafta bambancin ƙimar ga duk jarin mu a halin yanzu:
Yanzu zaku iya buɗe wannan fayil lokaci-lokaci, danna-dama akan faɗakarwa kuma zaɓi umarnin Sabunta & Ajiye (Sake sabuntawa), lura da canje-canjen da za a loda su ta atomatik cikin teburin mu.
PS
Kamar yadda zaku iya tunanin cikin sauƙi, daidai wannan hanyar zaku iya shigo da ƙimar ba kawai bitcoin ba, har ma da kowane kuɗi, haja ko tsaro. Babban abu shine nemo wurin da ya dace da kuma gina tambaya, sannan mai wayo Power Query zai yi komai.
- Shigo da farashin musaya daga Intanet
- Aiki don samun kuɗin musaya na kowane kwanan wata
- Haɗa tebur daga fayiloli daban-daban ta amfani da Query Query