Hello !
This tool is really great !
But after trying it, I realized the algorithm seems not the most efficient possible.
1) the efficiency parameter is a good idea, but ineffective : it doesnt matter if the target is far for the straight line, as long as it is the nearest possible target from the destination. Assuming this concept, the optimal solution could even be a spiral going behind the destination, or an equilateral triangle. I would suggest removing entirely this parameter.
2) some given neutron star can be quite ineffective to use, or even with negative effect, due to lost jump range to get them, and wrong direction (low progress toward destination) Theses results should be entirely filtered. Parameters offered to users should be instead : cost of galaxy map use, and cost of neutron star scooping. Theses cost can either be with ly, percentage (percentage of range in ly then), or seconds (giving 60s for 1 standard jump). Then, as each neutron star add 1 scoop and 1 or 2 galaxy map use, you can determine wether a neutron star can be kept or not.
Exemple :
- with a range of 50ly, the neutron boost give +150ly. (150ly+50ly = 200ly)
- if this star need an underrange jump of 160ly to reach it, we lose 40ly compared to any standard star. (-40ly lost)
- if this star only give a progress of 90ly toward the destination (the current remaining distance is 10kly, and is 9,910ly for the neutron star), that's again 70ly lost due to wrong direction.
- so, the neutron will offer only a +40ly boost remaining once you took account for bad star position. (I made a simulation to colonia with 25%, and got a lot of stars with less than +40ly progress)
- then, we take account for what the user considered as neutron star and galaxy map use :
* the user say that he take only 10s in account for the neutron scooping, because he is quite good at it, and add no additionnal repair risk. It correspond to a 10/60*50ly cost. 8,33ly
* the user also say it cost him 20s each time he use galaxy map, considering the alt-tab on windows to copy past, etc. It correspond to a 16,6 ly cost. And we know he wont be able to reach a neutron start right after, so it's a second galaxy map used only to use the jump : 8,33 + 16,6 x2 = 41,66 ly cost.
- the total gain for this neutron star would be -1,66 ly, meaning using this star would be less effective rather than direct jump, so, we can ignore it.
The algorithm turns out to be the way of ordering potential neutron star using this calculation.
3) (sorry), the tool could ask for the fuel cargo, and offer some normal star to refuel before getting empty tank. (but it have to be done after
)
-> Are you interested for my help to get the algorithm with such constraints ?
Here is an example of my analysis :
View attachment 115492
(the file is excel 2016, as I'm using the NUMBERVALUE() function to parse english numbers)