Additional Terraformable Data
Heh all!
Have some more data on Terraformable Candidates based on a 68 day, 60000 LY journey that I completed on 20 Sept. Included visiting over 3200 systems, mostly in Sirius Reach. Took me over 35 hours to sell 65 screens of Carto data. Managed to capture over 95% of what EDD said I had scanned. Took screenshots of all "anomalies" over 6.69% variance.
Tally as follows:
High Metal Content - 1384
Water Worlds - 305
Rocky Bodies - 49
Earthlike Worlds - 42
Ammonia Worlds - 56
After selling the data, crunched on it for a couple of weeks. I could see patterns, but decided needed more data to fill in some holes. Went back to my previous trip into the deep, my 3rd expedition. More, but not quite enough. Hit the forum for the first time in over 3 weeks, and much to my delight, noticed that Iain666 had posted a treasure trove of new data! On the same day I got back, 20 Sep. Quite a coincidence, lol.
This boosted the tally to
High Metal Content - 1849
Water Worlds - 448
Rocky Bodies - 65
Earthlike Worlds - 42
Ammonia Worlds - 56
My focus was on how much the Terraformable Bonus was reduced. Hence, all the following are couched in terms of what I call "Bonus Reduction %". This is simply, based on MattGs formula, what the max should be minus what you don't get, as a percentage. Meaning, if you get no bonus, it's a 100% Bonus Red%.
Here is the
Combined Dataset
Edited to add all scans from LPGs expedition:
Combined Dataset with all LPG scans
Added the notes column for those things that aren't in the journal, but might have some bearing. BI is binary. BI-Orb is binary, but the partner is so much more massive(usual gas giant). ISMOON is just that, it is a moon. HM.XXX is the body has a moon, and the number is the mass of the moon.
None really seemed to matter, other than an interesting note. One of the attributes of a planet is "tidal locked". Did notice that a large percentage of those TCs that are tidal locked are actually in a binary relationship with another planet.
Just in case your are interested, anomalies screenshots can be found
here.
BTW, ended up using free apps for this whole exercise (power apps not on my game machine). Primarily Open Office, which can highly recommend. Tried excel after I was done, but the spreadsheets are best viewed in Open Office Calc.
So what's the lowdown? Atmospherics play a significant role; contents and attributes. Much to my surprise, none of the orbital mechanics properties in the journal seem to have any affect. The only one not currently, but will be in the future, is axial tilt. Will be in future EDD version, but I did take some samplings by hand and they didn't seem to be relevant.
HMCB- Low Surface Pressure is good. Medium can be good and bad. High is bad.
Water Worlds - Continue to puzzle. Closest correlation with Bonus Red% is Surface Temperature, but not nearly as clean cut across the board. The various Ammonia atmospheres (Ammonia, Ammonia Rich, and Thick Ammonia) are somewhat predictable, mostly bad above certain temperatures. Nitrogen, which is unfortunately the largest group of planets, is all over the place.
Rocky Bodies - Almost all have full bonus. There are two in the dataset that do not, and they are at the exact top of the list wrt Surface Gravity. From my thumbnail look, RBTs are from .4 to .8 Gs.
Earthlike Worlds - Some get a reduced bonus, but no apparent correlation to any factors.
Bottom line, there are definite patterns, but no overall magical formula I could discern. There are some cases where formulas would closely fit the data (see WWW Ammonia Rich). There are many others where there is a definite pattern for individual planet data points, but the in-betweens are at zero. Almost like one or more attributes exempt them from any bonus reduction. There are a few cases where the in-between points are not zero, but running on a parallel but reduced-value curve.
What to do with the data? Good question, lol.
The following are posts of some charts worked up based on staring at this all for quite a few hours. Have no doubt I missed a number of things, so please shout out if something stands out.