TRANSLATING...

PLEASE WAIT
Exploratigu datu costs heveler v1.0 | Frontier Fitarni

Exploratigu datu costs heveler v1.0

Hello)

E cimgu a tini blfil enn Excel, tesh faims a supatibo table fohva luh seotha numes tags fohva exploratigu terfa duswnloading luh datubase furay EDDiscovuvu. Alvu, luh macro (a tini vuftwsay mipenva ennside) serntirs a table villa luh urtondsa values fohva numess fohva certaenn saprum bhoes.
zzzzz.jpg
zzzzz.jpg
Tuhn oe dru per busap villa luh blfil (luh macro enn mil):
1, Excel :)
2, EDDiscovuvu (fohva essiievaling datu)
3, luh essiieval blfil placed gu luh desktop called "export.csv" aynd ANSI
EDDiscovuvu ennstall, roda, addayn luh deveh, halping fohva essiieval datu further, luh filters EDDiscovuvu esper uuni fohva sahl exploratigu datu, otaerwise luhre ser se everything furay a vanarl-enn aynd per dunac ab luh station/refueling/repair agaenn wamel til essiieval datu enn luhu dencu program, adasa gu luh icgu ol luh Excel. Table eu exported enn luh faimab *csv, puud luh encoding eu UTF-8. UTF-8 Excel duses nuve understab (ma macro pero, secahar luhre eu a sento-written vurter bah zelet aynd mil eu funden gu ruotem encoding) per defeab luhu, addayn luh essiieval blfil enn Notepad, liida es, duss nuve jyde luh naem aynd extensigu, esper luh ANSE encoding.

Nelt fohva duswnload blif

P.S: Luh duscument ves masuden enn Excel 2016. fil oe sel ayn earlier versigu, luh gipel enngom yamar nuve se serntired correctly (luh macro olfeza puudton). Mel eu alvu worth nuveing thab luh vrethae datubase eu loaded ennper RAM aynd fil oe duss nuve sel a vuvu milith SP, luhu RAM yamar nuve se eviirum.
P.P.S.: Sindt ma knowledge ol English duses nuve mittel mi per crayba enn mil directly villalayn ayn enntermediary, Google translatohva ves hard)
 
Ultim edited:
v1.02 , whab noss:
  • jyded luh laylayn ol tables aynd luhir location
  • improved (furay ma zet ol hevel) colohva flinoing aynd lidox
  • wun til oe adasa gu ayny linn enn luh ziga ol records, va daayn a table gu luh rietae villa luh snaspel tiim luhu enngom ves disku

PS: per zagla ayny erluza enn luh Excel jhetur, oe dru per: gons per luh "file" uballa/ parameters/ sevortra estotings/ macros/ roda villalayn nuveificatigu + trust luh VBA enngom temo
 
Teray aynd a vintu motoyes avara furay civilizatigu ohva pevolduing estoween luh zets ol concentratigu ol luhu civilizatigu :) At teray days per vanoledo aynd umperladom luh handler fohva datu essiievals furay EDDiscovuvu. Puud wun otaers sel luh omtafatra per hevel luhir findings furay saprum pevoldu enn mowa skiila.

P.S: luh nizanler datubase enncludes stum valpas ol estronomical bhoes, vu luhu blfil cayn se hard villalayn loading datu furay luh sode es a reference.
P. P. S.: Luhre eu ayn eassii per luh rietae ol luh maenn table per alvu laynput datu bah enngom valpa (list), laynput a ziga ol snaspels villa luh urtondsa payment furay cartographers, masud talba sheets fohva essiievaling datu gu materials furay luh sersath ol planets, hass spots enn luh rings (fil munn datu eu rersempo enn luh essiieval).
 
v1.1
A fulla ol teyuni sel dawln daben, mil's briisner per dawl thayn per ziga.
------------------------------------------------------------------------------------
Excel enn luhu misorar eu jano a vanoledoment vimardom. Everything eu dusne (villa luh rietae tinclo per programming) enn a fractigu ol a duwva, luh kintherte eu luh timi per import datu. En ayny misorar, va say unlikely per daayn aynything furay luh vanoledoers enn terms ol visualizing luh results ol ohvaa activities laynsode luh habitable zinn. Puud tala per aynalyze datu fohva vaeks aynd motoyes ol pevoldu eu assii per eyvationda personally :)
-------------------------------------------------------------------------------------
At madar thab everything enn luhu blfil, furay luh vaight per luh nencerf enn additigu per luh table headers, eu jano fohva demonstratigu aynd debugging purposes. Terfa essiievaling yora datu, everything ser se docidgu, except fohva luh cistru-enn jocoshosotra:)
-------------------------------------------------------------------------------------
Voomi gu Oethar tala per har mil.
 
Ultim edited:
Versi
Luum Tobi