Zamkatimu
Tiyerekeze kuti mudawonetsa bizinesi ndi intuition ndikugula magawo angapo a cryptocurrency (mwachitsanzo, bitcoin yomweyi) m'mbuyomu. Mu mawonekedwe a tebulo lanzeru, "mbiri yanu yoyika ndalama" imawoneka motere:
Ntchito: kuwunika mwachangu kuchuluka kwa ndalama zomwe mwagulitsa pamlingo wapano wa cryptocurrency. Tidzatenga maphunzirowa pa intaneti kuchokera patsamba lililonse labwino (kusinthanitsa, kusinthanitsa) komanso pafupifupi kudalirika.
Imodzi mwazothetsera - pempho lachidziwitso la intaneti - ndaganizira kale mwatsatanetsatane pogwiritsa ntchito chitsanzo cha kuitanitsa mtengo wosinthanitsa. Tsopano tiyeni tiyese, kuti tisinthe, kuti tigwiritse ntchito njira ina - Power Query add-in, yomwe ili yabwino kuitanitsa deta ku Excel kuchokera kunja, kuphatikizapo kuchokera pa intaneti.
Kusankha malo oti mulowe nawo
Kuchokera patsamba lomwe tidzatengere deta - izi, mokulira, zilibe kanthu. Funso lachikale la Excel lapaintaneti ndilofunika kwambiri pamapangidwe ndi kapangidwe kake ka tsamba lomwe latumizidwa kunja ndipo nthawi zina siligwira ntchito patsamba lililonse. Power Query ndi omnivorous kwambiri pankhaniyi. Chifukwa chake mutha kutenga mtengo wapakati wogula kuti musankhe:
- mu exchangers www.bestchange.ru - zosankha zambiri, zoopsa zochepa, koma osati mtengo wopindulitsa kwambiri
- kuchokera ku nsanja yamalonda www.localbitcoins.net - chiopsezo chowonjezereka, koma mlingo wabwino kwambiri
- kuchokera patsamba losinthira - ngati mumagulitsa mwachindunji pakusinthana, ndiye kuti simukufunika nkhaniyi 🙂
Choyamba, tiyeni titsegule tsamba lomwe tikufuna mu msakatuli. Tiyeni titenge, kwa konkriti, nsanja yamalonda localbitcoins.net. Sankhani pamwamba tabu Kugulitsa mwachangu ndi njira Kusamutsa kudzera kubanki inayake (kapena china chilichonse chomwe mukufuna) ndikudina batani Search:
Tsopano muyenera kukopera adilesi ya tsamba lomwe likuwonekera pa clipboard, chifukwa. ili ndi magawo onse opempha omwe tikufuna:
https://localbitcoins.net/instant-bitcoins/?action=kugulitsa&kodi_dziko=RU& kuchuluka=¤cy=pakani&malo_dziko=RU& pa intaneti_provider=SPECIFIC_BANK&find-offers=SakaniNdiye zili ku Power Query.
Kulowetsa maphunziro ku Excel pogwiritsa ntchito Power Query
Ngati muli ndi Excel 2010-2013 ndi Power Query yoyikidwa ngati chowonjezera chosiyana, ndiye kuti lamulo lomwe tikufuna lili pa tabu la dzina lomwelo - Kufunsa Mphamvu. Ngati muli ndi Excel 2016, ndiye pa tabu Deta (Tsiku) kanikizani batani Kuchokera pa intaneti (Kuchokera pa intaneti). Pazenera lomwe likuwoneka ndiye kuti muyenera kumata adilesi yomwe mwakopera patsamba lapitalo ndikudina OK:
Pambuyo posanthula tsamba lawebusayiti, Power Query iwonetsa zenera lomwe lili ndi mndandanda wamatebulo omwe angatumizidwe kunja. Muyenera kupeza tebulo lofunikira pamndandanda womwe uli kumanzere (pali zingapo), mukuyang'ana zowonera kumanja, kenako dinani batani pansipa. kudzudzulidwa (Sinthani):
Pambuyo pake, zenera lalikulu la Power Query query editor lidzatsegulidwa, momwe tingasankhire mizere yofunikira ndikuwerengera mtengo wogula pa iwo:
Ndikupangira kusinthanso pempho lathu pagawo lakumanja, ndikulipatsa dzina lanzeru:
Kusefa ndi kuyeretsa deta
M'tsogolomu, tidzangofunika mizati yokhala ndi mafotokozedwe Njira yolipirira ndi mtengo wogula Mtengo / BTC - kotero mutha kusiyanitsa bwinobwino onse awiri Ctrl ndipo mwa kuwonekera kumanja pa iwo, sankhani lamulo Chotsani zigawo zina (Chotsani zigawo zina) - mizati yonse idzachotsedwa kupatula osankhidwa.
Tiyerekeze kuti tikufuna kusankha okhawo amalonda omwe amagwira ntchito kudzera ku Sberbank. Fyuluta ndi chinthu chodziwika bwino, koma nuance ndikuti fyuluta mu Power Query ndizovuta, mwachitsanzo, Sberbank, Sberbank ndi Sberbank sizili zofanana kwa iye. Choncho, tisanasankhe mizere yofunikira, tiyeni tibweretse nkhani ya mafotokozedwe onse ku mawonekedwe amodzi. Kuti muchite izi, muyenera kusankha ndime Njira yolipirira ndi pa tabu Transformation sankhani gulu Format - zilembo zazing'ono (Sinthani — Format — Zochepa):
Sefa ndi gawo Njira yolipirira pogwiritsa ntchito njira Zosefera Zolemba - Muli (Zosefera zolemba - Muli):
Pazenera la fyuluta, nthawi yomweyo sinthani kuchokera pamwamba kupita ku mode Kuwonjezera apo (Zapamwamba) ndikuwonetsa malamulo atatu osankha:
Monga momwe mungaganizire, pochita izi timasankha mizere yonse yomwe liwu loti "sber" likupezeka kapena mu Chingerezi, kuphatikiza omwe amagwira ntchito ku banki iliyonse. Musaiwale kukhazikitsa ulalo womveka kumanzere Or (KAPENA) m'malo mwake И (Ndi) Apo ayi, lamuloli silingagwire ntchito bwino. Pambuyo kuwonekera pa OK Zosankha zokha zomwe tikufuna ziyenera kukhala pazenera:
Tsopano chotsani ndime Njira yolipirira dinani kumanja pa mutu wa mzati Chotsani ndime (Chotsani gawo) ndikugwiranso ntchito ndi gawo limodzi lotsala la maphunziro:
Vuto ndiloti pali, kuwonjezera pa chiwerengero, palinso dzina la ndalama. Izi zitha kutsukidwa mosavuta ndi choloweza m'malo mwa kudina kumanja pamutu wagawo ndikusankha lamulo. Kusintha makhalidwe (Sinthani makonda):
Manambala omwe adapezedwa pambuyo pa kuchotsedwa kwa RUB, kwenikweni, nawonso si manambala pano, chifukwa amagwiritsa ntchito ma delimiters osagwirizana. Izi zitha kuchiritsidwa podina batani la mtundu pamutu wa tebulo ndikusankha njirayo Kugwiritsa Ntchito Malo (Gwiritsani ntchito anthu akumaloko):
Malo oyenera kwambiri angakhale Chingerezi (US) ndi mtundu wa data - Дnambala ya decimal:
Pambuyo pang'anani OK tipeza ziwerengero zonse zamitengo yogulira:
Zimakhala kuwerengera pafupifupi kwa iwo pa tabu Kusintha – Ziwerengero – Avereji (Sinthani — Statistics — Average) ndikuyika nambala yomwe ikubwera papepala ndi lamulo Kunyumba - Tsekani ndikunyamula - Tsekani ndikulowetsani… (Kunyumba - Tsekani & Kwezani - Tsekani & Kwezani Ku…):
Tsopano titha kuwonjezera ulalo wazomwe zatsitsidwa mu fomula ku tebulo lathu la mbiri ndikuwerengera kusiyana kwa mtengo wandalama zathu zonse pakadali pano:
Tsopano mutha kutsegula fayiloyi nthawi ndi nthawi, dinani pomwepa ndikusankha lamulo Sinthani & Sungani (Bwezeretsani), onani zosintha zomwe zidzalowetsedwa patebulo lathu.
PS
Monga momwe mungaganizire mosavuta, chimodzimodzi momwe mungathere kuitanitsa mtengo wa bitcoin, komanso ndalama zina, katundu kapena chitetezo. Chinthu chachikulu ndikupeza malo oyenera ndikumanga funso, ndiyeno Smart Power Query idzachita zonse.
- Lowetsani mitengo yosinthira kuchokera pa intaneti
- Ntchito kuti mupeze mtengo wosinthira watsiku lililonse
- Kusonkhanitsa matebulo kuchokera kumafayilo osiyanasiyana pogwiritsa ntchito Power Query