Probably not (I guess it's a coincidence), but I wonder if my journey gives you ideas for spreadsheets
Probably not (I guess it's a coincidence), but I wonder if my journey gives you ideas for spreadsheets
Yeah, that's a really tough call. There's no "flag" to specifically mark them as such in the journals. So we would have to make assumptions based on orbital parameters, etc. Since that one has a high eccentricity, that does make it a good candidate. However those can also occur due to interactions with another body, which may have been ejected.
But looking at the composition could certainly be valid too. We just have no way to verify any meaning behind it.
So really the best I can do is make spreadsheet reports based on certain features, such as the inclination or eccentricity, and leave it to the viewer to decide what the meaning of those values are.
EDIT: For Helium, how are you determining the boxel content? Average percentage of the gas giants, or something along those lines?
But I hear that there is something more behind the "XX-X" for the first time. Albeit I have suspected it since I had some long term plans to analyse it.'m assuming boxels in this case refer to specific sets of "XX-X m" patterns (letter codes plus mass code)
The Sector Naming article on the DISC wiki is the best explanation.What is a boxel?
Your latter two examples are imported catalogue systems, not procedurally generated, so yeah. Your first example might be off, as the "sector" named systems are all overrides of the procedurally generated names, in a certain distance of a point. So while procedurally generated sectors (for example, Synuefe, Wregoe) are boxes, override sectors (NGC 6067 Sector) are spheres. (There are times when some of them overlap though, and they take parts out of another.) They still have their original names in the game, but most of the time, that'll turn out different than the new one, so you can't assume that Happy Hippo Sector ZU-F c4-20 would be Blu Aec ZU-F c4-20.Also, is my assumption correct that this "works" just for names like "NGC 6067 Sector ZU-Y d31" but not "V1292 Scorpii" or "CD-23 13397"?
I may play with scripting something up to look at the boxels, but I suspect I'll have to have a cutoff based on mass code or something. That is, analyze D-mass and above, or something similar. I'm just not sure yet. I want to avoid making lots of spreadsheets that have tens of millions of rows, but I'm not sure how the existing data will break down yet. Clearly there's an upper limit based on the number of star systems.
"Boxel","Systems","Age Avg","Age Min","Age Max","Hydrogen Avg","Hydrogen Min","Hydrogen Max","Helium Avg","Helium Min","Helium Max","Total Stars","Avg Stars","Min Stars","Max Stars","Total Planets","Avg Planets","Min Planets","Max Planets","Total Gas Giants","Avg Gas Giants","Min Gas Giants","Max Gas Giants","Total Terrestrial Bodies","Avg Terrestrial Bodies","Min Terrestrial Bodies","Max Terrestrial Bodies","Avg X","Avg Y","Avg Z","Min X","Min Y","Min Z","Max X","Max Y","Max Z"
"Oephail LG-Y e","192","206.84","2","1726","76.09","76.0689","76.13","23.89","23.86","23.93","334","1.74","1","7","36","0.19","0","5","7","0.04","0","1","29","0.15","0","5","7534.04","51.78","17092.64","7455.22","-23.44","17016.00","7612.81","133.81","17174.30"
Some initial tests, using Oephail and Scaulua:
Oephail has 3002 systems in 2062 boxels. Limiting to d-mass or higher returns 548 boxels. Limiting instead to boxels of 10+ systems returns 11 boxels.
Scaulua has 5999 systems in 2335 boxels. Limiting to d-mass or higher returns 1684 boxels. Limiting instead to boxels of 10+ systems returns 67 boxels.
I may have to just use the system count as a threshold for it to have interesting results, unless we want to tighten the mass codes to e+ or something like that.
OK, here's a test run across the whole galaxy, limited only by mass code, e+. The mass code limitation allows the initial lookup of system IDs to be filtered by name, making the script run in a pretty short time. This results in a spreadsheet of 376,367 boxels:
Looking at it now.. something odd is happening with the helium / hydrogen average, at least in some of the boxels... How is the average being calculated? An example of a problem boxel is Wepooe EA-A e, where the average is lower than both the maximum and the minimum.
A request: Would it be difficult to add a column for the system with largest number of bodies in a given boxel? (Not the name of the system. Just the number of bodies in the one that has the most, both stars and planets) I have a hypothesis I want to test.
Another useful field would be one that just shows the boxel letter. (To filter out the H's, E's, whatever)