A few weeks ago, while i was trading common stuff with my hauler, i stumpled upon some rare goods. Out of curiosity, i packed some of these exquisite dainties into the belly of my trusty spacecamper and began my 150 LY ride.
And boy, what a ride it was.
Nearly ran myself into a neutron star. Witnessed a NPC incinerating himself by slingshotting his pants into a red giant, shia-laBeoufing "NO NO NO NO!!!" all over my comms. Got stuck between two Anacondas within a Starport Entrance, when all of a sudden all hell broke loose. But eventually i made it to the destination of my trip, which instantly payed off in form of a shiny new cobra. Needless to say, i got hooked on rares at this very moment.
Long story short, trading rare commodities can provide you with some good stories to tell.
For those of you, who do not know about rares, check out lavewiki.com/rare and this marvelous spreadsheet as well:
https://docs.google.com/spreadsheet...qBrZvFFzcA-uXB4pTfW4/htmlview?pli=1&sle=true#
Furthermore, you can plot your own route at http://eliteraretrader.co.uk/
Sure, i could get me a type-6, hopping from rare-system to rare-system and sell particular items as soon as i hit 150 lY on them. But i want to be able to compete with pirates or to get into capitalship-combats whenever i feel like. So i was thinking about doing Cluster-Routes with my Cobra, using said spreadsheet as database for a different approach.
I know a bit about Excel and Python, but apparently not enough to do this one by myself. Which is why i came here to politely ask for any help or hint from you fabulous commanders.
Given that my english may not adequate enough, especially in terms of pinpointing technical issues, the following image may help to clarify my intention. (Sorry for it beeing written in german)

What i want to do, is to setup a three-step script to find the best™ clusterroute.
Step 1: the script/formula should lay spherical coordinates with the diameter of X (with X beeing a variable for your desired jumprage) onto the vektor space, sourced by the spreadsheet above and printed out as lists of clusters . This Cluster-lists shall be sorted first by the number of systems within the sphere and second by the incidence of reapperance of systemdots in other spheres (the lesser the overlap the better, ofcourse).
Step 2: The Clusters should be grided as a function of their distance to each other, with an optimal distance d=150+2*x and tolerance of -20/+50
Step 3: Now we route our way by choosing our startcluster and sorting the neighbourhood first for distance deviation and second for times of iteration.
First of all, thank you for reading this thread thus far. I would be glad for any suggestion how to implement this plan.
PS: Yes, i am aware that i could do way more credits per hour by simply doing mass-trading of common commodities with a bulky freighter on short-range-return-trips.
But sometimes it's not all about teh moneyz, but for the journey beeing its own reward.
And boy, what a ride it was.
Nearly ran myself into a neutron star. Witnessed a NPC incinerating himself by slingshotting his pants into a red giant, shia-laBeoufing "NO NO NO NO!!!" all over my comms. Got stuck between two Anacondas within a Starport Entrance, when all of a sudden all hell broke loose. But eventually i made it to the destination of my trip, which instantly payed off in form of a shiny new cobra. Needless to say, i got hooked on rares at this very moment.
Long story short, trading rare commodities can provide you with some good stories to tell.
For those of you, who do not know about rares, check out lavewiki.com/rare and this marvelous spreadsheet as well:
https://docs.google.com/spreadsheet...qBrZvFFzcA-uXB4pTfW4/htmlview?pli=1&sle=true#
Furthermore, you can plot your own route at http://eliteraretrader.co.uk/
Sure, i could get me a type-6, hopping from rare-system to rare-system and sell particular items as soon as i hit 150 lY on them. But i want to be able to compete with pirates or to get into capitalship-combats whenever i feel like. So i was thinking about doing Cluster-Routes with my Cobra, using said spreadsheet as database for a different approach.
I know a bit about Excel and Python, but apparently not enough to do this one by myself. Which is why i came here to politely ask for any help or hint from you fabulous commanders.
Given that my english may not adequate enough, especially in terms of pinpointing technical issues, the following image may help to clarify my intention. (Sorry for it beeing written in german)

What i want to do, is to setup a three-step script to find the best™ clusterroute.
Step 1: the script/formula should lay spherical coordinates with the diameter of X (with X beeing a variable for your desired jumprage) onto the vektor space, sourced by the spreadsheet above and printed out as lists of clusters . This Cluster-lists shall be sorted first by the number of systems within the sphere and second by the incidence of reapperance of systemdots in other spheres (the lesser the overlap the better, ofcourse).
Step 2: The Clusters should be grided as a function of their distance to each other, with an optimal distance d=150+2*x and tolerance of -20/+50
Step 3: Now we route our way by choosing our startcluster and sorting the neighbourhood first for distance deviation and second for times of iteration.
First of all, thank you for reading this thread thus far. I would be glad for any suggestion how to implement this plan.
PS: Yes, i am aware that i could do way more credits per hour by simply doing mass-trading of common commodities with a bulky freighter on short-range-return-trips.
But sometimes it's not all about teh moneyz, but for the journey beeing its own reward.