View source for User blog comment:Morwo01/collecting Tip Offs/@comment-903860-20190804102834

Just as a reference and memo for this thread:<br />ED:H - Tip Off - semi-persistent - archives with side notes<br />- this one intended to accumulate TO-related data (and imports settlements map-related data from my earlier projects, also "reference" systems are in fact also imported but from another source). Hope that this one will be driven in future by to "data submission forms" - one for "I've received a TO" and the other "I've visited a TO location".<br />ED:H - TO and other locations Filter<br />- as title says, this one can import and combine the location data from the previous one and some others spreadsheets (in future I hope to connect here even "ED:HS locations list") - i.e. mix TO locations with POI's, for example, filter them by distance, etc. In fact only usable as "personal" copy (so yes, google account needed). Also use "scripts" that require some "nasty" authorizations from user (afaik you can view the source by going to the scrip editor window - some of them are useful, some useless and obsolete). POI data like Inara bases imported from ED:H Locations And Refs =)<br />And finally ED:H - TO cross distances - that supposed to work with the "result" you've obtained on above mentioned "filter" spreadsheet. Also usable only as a "personal" copy. Has some "custom" functions defined exactly to calculate cross-distances (once again check script editor - as far as I understand you must not have any problems to understand them and/or modify to suit your needs) Check the formula on "import" page - now it says =array_constrain(importrange("1pRYySDPIRZ-ESpDpPRuVYAkWsccS2OXUM-O15Vpd3Zc","Result!A7:J"),$C$1+1,10) but you can always redirect it to use your own copy of data of "filter" spreadsheet just changing the "key" in importrange (one of the most powerful google spreadsheet features and one of the reasons why I use them at all)=) .<br />About BTT page - for instance there is no way to see what particular systems are the closest as that will be evidently different for each system - this just show that "there are" (or not) some others in proximity. But you are right - well, will think how this can be made more handy.


july 2019<br />Tamaya_{body:1}{type:CS}{var:CS_AN_1LL}{coords:[54.71,180]}<br />Tsongoris_{body:8 a a}{type:CS}{coords:[-40.61,79.52]}<br />Pegasi Sector PX-T b3-6_{body:B 2 a}{type:CS}{coords:[-21.09,176.65]}<br />Carichilo_{body:B 4 a}{type:CS}{coords:[17.54,134.91]} 120k credits intel sold<br />Gletichua_{body:B 1}{type:CS}{coords:[-30.54,-59.82]}<br />Juracame_{body:1 a}{type:CS}{coords:[3.12,146.83]} gone<br />DT Virginis_{body:A 2 a}{type:CS}{coords:[-3.58,112.14]}<br />Medzistine_{body:1 c}{type:CS}{coords:[-70.76,153.84]}<br />Kao Wanga_{body:7 h}{type:CS}{coords:[-11.94,-31.31]}<br />LP 91-140_{body:A 2 A}{type:CS}{coords:[62.69,59.7]}<br />Liu Baja_{body:A 2}{type:CS}{coords:[7.76,49.14]}


Lyncis Sector TZ-P b5-1_{body:10 a}{type:CS}{coords:[57.53,168.22]}<br />Arietis Sector OS-T b3-0_{body:A 3}{type:CS}{coords:[4.85,-177.62]}<br />Aurgel_{body:B 1}{type:CS}{coords:[-26.97,-84.31]}<br />Agastariya_{body:B 1}{type:CS}{coords:[-26.31,41.57]}<br />Apadecavi_{body:6 a}{type:CS}{coords:[5.1,-25.61]}

quickest routes to all


Khontam <- 74.6889 -> Motie <- 66.8151 -> Athena <- 43.9198 -> Monoto <- 84.348 -> WISE 2056+1459 <- 59.9288 -> Brokutsu <- 82.7081 -> Pyemsito <- 141.852 -> Carichilo <- 81.437 -> Pyritapiyar <- 50.7957 -> Raidal <- 168.41 -> Lyncis Sector TZ-P b5-1 <- 144.653 -> Karas <- 228.153 -> Col 285 Sector IH-T b17-2