Or maybe I can enable EDISON to access existing spreadsheets.
This would be great as a bonus, dunno how stable google API access is but don't want to depend on it to work probably. And a default sheet with the main stuff is fine (feel free to copy from my list) but I'm sure people will also want to have their own personal waypoints lists too. With import or linking a sheet means anyone can use their own sheet with favourite spots, and be able to switch between different sheets. Like if you head out to Colonia you could make your own separate list for that region, especially with a long list it starts getting a bit inconvenient to find the specific waypoint you want.
There's another idea I had about this issue though, maybe if Edison can grab your current location from the game logs/live json stuff (it probably gives the galactic x,y,z right?). Then you could use it to sort your waypoints by current distance to them and then it wouldn't matter if half of the list is clutter that's 22 kly away. But that would mean having the galactic x,y,z numbers for all the waypoints and then calculate the distance to sol, although the formula itself is fairly simple. Being able to sort like that would definitely give another advantage over any static spreadsheet of locations.
I was just thinking about this after I started adding the galactic x,y,z to my spreadsheet to calculate 'distance to sol'. On my spreadsheet I temporarily have two columns of it until I've added all the x,y,z numbers, just copy/pasting those from EDDB. But now I'm wondering if the EDDB or EDSM API isn't able to give x,y,z for any known system instead, the less manual input the better probably. Important to keep it easy to use.
In case this might be interesting to do, the distance formula between two x,y,z sets is like this:
Code:
SQRT( (waypointX - currentX)^2 + (waypointY - currentY)^2 + (waypointZ - currentZ)^2 )
Distance to Sol is a bit easier, as Sol is at 0,0,0 so you can just omit those and do this: (pretty much the formula I use on my spreadsheet now)
Code:
SQRT( waypointX^2 + waypointY^2 + waypointZ^2 )
I'd be happy with just an import function and/or the googledocs API thing so I can link to my spreadsheets. There's a lot of interesting stuff possible with all this, but I get programming it all takes a ton of time too so hehe.