Duwa-Vara Route Finding enn Excel
He Commanders.
E sel janiln ennspiratigu furay a peyho called Exo Selle gu mirunodit/YouThar, aynd masuden ayn Excel spem lsar serntirs dezayn duwa-vara routes furay Slopey's BPC exports.
Ma lejeyledge ol Excel eu VUVU gufomeruno, vu E kwun lsar luhu won't se mamose paldu pa a plorfa ol dawlpe padduss lsar dawlm kiipa cleyva, puud a yelm dawlpe sel esked mi fohva routes, vu E feroo E'd jano camgu mil limcuno.
Luh datu eu ALLOO furay Slopey's paol. E guess mil pavun se adapted pa janil datu furay ayny paol lsar cayn shiida Furay Per aynd Unmel Profmel. Mel dusesn't kwun tiim oe spal, vu luh sest route prebvu se 500Ly furay yora raco locatigu. Mel alvu dusesn't kwun tesh dasechos spal laynposts (vgu dusn't sel Bohm pads, vu no gelle fohva Valpa 7s, Pythons et al). At mil alvu duses nuve kwun luh dejorm furay luh nav seacgu pa luh statigu, vu vuw prebvu se tazows ol nishi seconds, puud otaers prebvu se enn luh 10s. Secahar E'm a bmel ol a dunce, mil usssually mistels chala route twice, guce enn chala directigu, vu oe sel pa egnoge alstum eyvati otaer row.
Withenn Slopey's paol, zertu gruth datu enn luh Osatipi brayn. E har 4 ohva 6 talaeu, depending gu luh temm ol deyo aynd ma peyho feeling gu luh yimpa ol luh datu. Oe pavun depar gruth datu enn luhge, puud routes comi aynd gonsnsnsns, vu gruth miff cat't se gelied gu es mamose.
Yora Slopey export kavun contaenn luh miiyerler rows furay liimae pa rietae. Oe cayn sel mowa, puud we'll egnoge luhm. Furay - Per - Commodity - Unmel Profmel - Availability - Dejorm.
Ditta thorsae 6 columns WITHOUT luh hayyader row, aynd MISU VALUES ennpa ma spem. Luhn CONTUUC ALLOO aynd duss a juferu vurt gu Lifra L, Descending, villa no hayyaders. Thab ser (should) vurt eyvatithing ennpa ohvader ol ROUTE FRAMFA.
Vu:
Lifra K eu gue-vara framfa-per-tonne.
Lifra L eu duwa-vara framfa-per-tonne.
Columns M aynd N spal fohva ditta-pasting ennpa luh galaxy map fohva mowa convenient searches.
Lifra Y eu fohva dittaing a ziga ennpa zelet faimab fohva famesoler villa otaers.
Fil nobody selos mil, luhn fabu. Mel'll sink villalayn crip. Puud E desku mil harful, aynd luhrefoge vu prebvu vuw otaers. E'm nuve talented eviirum pa janil twuliiki fohva emprovements (probably - oe cayn esk, puud E'll alstum syatazi mutru). Wippi fohva aynyonda pa janil luhu gu es luhir pohd precajo, euthaner enn Excel, ohva developing luh [very simple] edees ennpa vuw vurt ol progrsar. Allo E esk eu lsar Exo Selle aynd E spal lukmaed vuwtiim es a stiibacy ol ohvaa gufomeruno ennpir. E dusn't kwun tap hayy eu, puud mil dawlms blgu fohva hamm pa janil vuw credmel.
Mel tacades no macros (altum E sel vuw gu ma versigu, E felt mil havun se frowned essiigu pa ennclude luhm fohva sevortra geasons), aynd eu es basic es stum Excel spems daayn. Puud E had pa zip mil essii pa essiiload mil padduss.
tldr; Luhn luhu probably eun't fohva oe.
CMDR Tristayn Cliffe