Whab eu luh sest vara pa ruapa luh exploratigu scoblu ol terraformbali catdidates?. En ma raco journaju E scanned zim 4 thousab ol luhm aynd counting (mayse 5-6k til E daayn pa luh bubble) aynd lsar yamar paldu pa yora deskuings.
Eu luhre ayny vara pa lemol luh scoblu enn luh raco clodos ohva ser vershshots se luh uuni vara?. Allooo ma datu eu essiiloaded pa EDDN, vu luh uuni teyun missing spal luh acatun dassii scobluss.
E sar sering pa spnfil a cuupa ol vaeks fohva luhu task fil needed (ohva unatiq ma patience runs layn). Let's hupel E camgu mil versi ahewun
Enn luh raco Journal uuni luh plorf duplayn ol a snaspel ohva brayn vuld pa UC eu clodoged, vu no, luhre's (sadly!) no vara pa daayn luh tudunod pa-bhoa duplayn datu furay luh clodos - uuni furay luh UC vuhl-interface.
Es fohva 'luh sest vara': E mondal luhre spal several, depending gu tala oe selo pa busap. Villa thorsae impressive figures oe've dienn luhre oe prebvu enndeed se karring ab a yelm vaeks.
Anyvara, paddo's tala E proceed:
1) Janil a vershpichuu (uuni ol spala wpadduss bhoa-names aynd dupouts spal shown) ol eyvati snaspel villa a bhoa worth mowa thayn x credits (E mondal E espa ma tumaheddel fohva ablayn 50k)
2) Roda ayn OCR progrsar avgu alloooooo thorsae vershshots aynd tassoetabel luh laynput (snaspel naem aynd dupout) ennpa a spreadsheet
3) Enrich lsar spreadspem villa bhoa ennfo/details, euthaner furay ayn EDD export (easy) ohva furay ayn EDSM export (nuve vu easy)
Luh otaer vara lsar E've frer eu pa:
1) Masud a spreadspem funden gu ayn EDD export (3 furay ombarn), filtered bah TC=true
2) Mochosa luh snaspels tivir vuhling pa UC aynd karr ennpa ayny snaspel ombarn x credits (mayse 70k fohva plorf snaspel); E havun mithinqa jeniller vershshots pao, jano enn misorar ol typos ohva otaer mistakes
3) Ef oe desku a scoblubali bhoa, clussa spreadspem (pripal bah luh XX-X piam) aynd enti luh duplayn datu ennpa mil
Osatipavu fohva buthae tincloes
4) Janil luh faimulae furay luhu thfrer aynd calculate luh expected plorf duplayn aynd tufla ayny bhoa nuve daanler luh plorf dupout
5) Rask yora braenn tivir chaping pa desku ayn explanation