I learned Python, at least what little I learned, because Golan2072 created a python script to generate traveller sectors, and I wanted to open it up and mess around. Aside from some minor HTML/CSS it's literally the only "coding" I know how to do. The formulae in mine, and for most of his, too, aren't too different from what you'd use for excel. 90% of the script is "if" statements.
But the reason I do it in Python and not Excel is that it can generate thousands of worlds at a time.
I packaged up the code along with a star list based on EDG's revised 2300 star maps for anyone who wants to give it a spin (you'll need to download and install python of course). Some parts aren't fully cooked, but it will make some neat worlds. Let me know if you have any suggestions.
FYI my XYZ axes in that star list are altered to match Traveller's POV, with coreward as +Y. Coreward is +X, which I believe is the default for EDG's downloadable excel files. I usually adjust my final results so that coreward is +Y, but I didn't in this case.
https://www.dropbox.com/sh/22f6scgj6838 ... -xzCa?dl=0