I have finally finished working on v3 of my Colonization construction spreadsheet. Lots of changes and improvements so it's a new spreadsheet:
Use this link to 'make a copy' of the spreadsheet.
(Note: If the spreadsheet is unavailable that means I'm updating it to a new version and it'll be available again shortly, try again a bit later.)
Current version is v3.2.1, see notes post here.
A small error got in with 3.2, in case you want to manually fix it: Copy/paste the following formula in cell K2 on every Colony tab:
April 3~21 note: Frontier changed things for Colony-type stations, then reverted the change:
FDev had changed the economy to be determined by the body type it is orbiting, HMC, Rocky, Ice, etc. instead of these stations getting a "Colony" economy with basically no markets. However this was reverted a week later, note this process may take up to two weeks for all stations to get reverted...
Please read before starting with Colonization:
I've made a few help/documentation screenshots on some of the changes and features. And I've added a short clip that shows the OCR snapshot tool in action. Details about that tool can be found on the settings page.
Call for help: report observed population & score changes!
It's clear that FDev is not going to give us more details so we're going to have to figure things out ourselves. Every construction adds a bit of population and/or score but with 109 layouts we don't have all the data yet. Use this google form to report observed population & score changes, you can also report layout-specific bugs and economy influence changes.
The spreadsheet takes layouts data from an external sheet, so as we get more reports I can update that and the updated data will show up for everyone without requiring people to make another new copy. (The Changelog/ReadMe tab takes from and external sheet so I can update info there as well.)
Note: From early reports it's clear that population numbers are also variable but please do keep submitting your observations on those. A future update will likely show population as min-max range instead. Observed score increases do seem to be fixed so far which will be useful for estimating the weekly credit rewards.
Special thanks to CMDR Mechan for suggesting some of the changes, and many CMDRs on the Canonn discord for figuring out how a lot of the colonization aspects work. Also a big thank you to all the CMDRs reporting data using the submission form!
Use this link to 'make a copy' of the spreadsheet.
(Note: If the spreadsheet is unavailable that means I'm updating it to a new version and it'll be available again shortly, try again a bit later.)
Current version is v3.2.1, see notes post here.
A small error got in with 3.2, in case you want to manually fix it: Copy/paste the following formula in cell K2 on every Colony tab:
=COUNTIF($D5:D,"<>")April 3~21 note: Frontier changed things for Colony-type stations, then reverted the change:
FDev had changed the economy to be determined by the body type it is orbiting, HMC, Rocky, Ice, etc. instead of these stations getting a "Colony" economy with basically no markets. However this was reverted a week later, note this process may take up to two weeks for all stations to get reverted...
Please read before starting with Colonization:
- Your first primary station (when you claim a system) won't cost any construction points, but it will require more commodities: Roughly +16% for an Outpost, +33% for a Tier 2 Station, and +20% for a Tier 3 Station.
- On Colony tabs this is added automatically (only for the first primary station), but note these cargo amounts are really only meant as a "close enough" indication how much work it will be.
- On the "Cargo Hauling" tab you can add a % offset manually at the bottom for every construction, after the primary station I suggest adding at least 3.5% (or alternatively use the OCR snapshot method for exact amounts).
- The spreadsheet uses numbers as shown in the in-game build menu but all commodity amounts get a small % of RNG applied for every construction, so these numbers will always be a little off.
- Required amounts can even go up or down by a few while you're delivering cargo... Yes this happens, you're not crazy, send complaints to FDev.
I've made a few help/documentation screenshots on some of the changes and features. And I've added a short clip that shows the OCR snapshot tool in action. Details about that tool can be found on the settings page.
Call for help: report observed population & score changes!
It's clear that FDev is not going to give us more details so we're going to have to figure things out ourselves. Every construction adds a bit of population and/or score but with 109 layouts we don't have all the data yet. Use this google form to report observed population & score changes, you can also report layout-specific bugs and economy influence changes.
The spreadsheet takes layouts data from an external sheet, so as we get more reports I can update that and the updated data will show up for everyone without requiring people to make another new copy. (The Changelog/ReadMe tab takes from and external sheet so I can update info there as well.)
Note: From early reports it's clear that population numbers are also variable but please do keep submitting your observations on those. A future update will likely show population as min-max range instead. Observed score increases do seem to be fixed so far which will be useful for estimating the weekly credit rewards.
Special thanks to CMDR Mechan for suggesting some of the changes, and many CMDRs on the Canonn discord for figuring out how a lot of the colonization aspects work. Also a big thank you to all the CMDRs reporting data using the submission form!
Last edited:
o7
