Release V3 of the Colonization construction spreadsheet is now available!

[DaftMav]

Not sure what's going wrong with the links, but there's also a link on the changelog tab in the spreadsheet to make a new copy, could use that instead.

Is there a way to get our current systems' data across to a new copy?

Migrating colony from the old version: You can simply copy & paste the structures over.

So you could select cells starting on row 5, from column A to E to include body/slot/name, construction and the notes. You could probably also copy both columns with the checkboxes, as well as the layout variant. But you'd have to those one by one as the new sheet adds some new columns in between.

If you wanted to copy just the constructions, it's possible to click & drag to select in the grey background behind the dropdown button.

Best to use ctrl+shift+v to paste values only into the new spreadsheet.

 

[Ecole40160]

I'm using a translator (I am French).
@DaftMav
Hello, I noticed a small bug in the sheets linked to the current build total (it's not binding), see image.

So I've created the replacement formula for you, if needed:

Before : =SI($K$5=VRAI,SOMME(E2:F2)+1,SOMME(E2:F2))

After : =SI($K$5=VRAI,SIERREUR(GAUCHE(E2,TROUVE("/", E2)-2)+GAUCHE(F2,TROUVE("/", F2)-2)+1,SOMME(E2:F2)+1),SIERREUR(GAUCHE(E2,TROUVE("/", E2)-2)+GAUCHE(F2,TROUVE("/", F2)-2),SOMME(E2:F2)))
Otherwise, I'm really happy to have these spreadsheets for the forecast.

Have a nice day. EC

PS: Perhaps add a form to report bugs on the Google Sheet (other than installations)?

 

[DaftMav]

Hello, I noticed a small bug in the sheets linked to the current build total (it's not binding), see image.
View attachment 425818
PS: Perhaps add a form to report bugs on the Google Sheet (other than installations)?

Ahhh, there's always something tiny that breaks...
Thanks for reporting, and it's best to let me know of spreadsheet bugs either here on the forums or reddit as it gives me a notification. Or if you mean other in-game bugs related to colonization you can use the form for that.

I've fixed it but people may want to manually fix this as it's just one cell per colony tab to replace so it's less work than migrating entire systems over.

The fix: Copy/paste the following formula in cell K2 on every Colony tab: =COUNTIF($D5:D,"<>")

 

[CMDR Ecaep]

Ahhh, there's always something tiny that breaks...
Thanks for reporting, and it's best to let me know of spreadsheet bugs either here on the forums or reddit as it gives me a notification. Or if you mean other in-game bugs related to colonization you can use the form for that.

I've fixed it but people may want to manually fix this as it's just one cell per colony tab to replace so it's less work than migrating entire systems over.

The fix: Copy/paste the following formula in cell K2 on every Colony tab: =COUNTIF($D5:D,"<>")

Thank you for the fix!

I do have a question. How does a bug that is reported in cell I2 get fixed by changing the formula in cell K2?

 

[Ecole40160]

Thank you for the fix!

I do have a question. How does a bug that is reported in cell I2 get fixed by changing the formula in cell K2?

I think you have the wrong version of the sheet file (3.1 =/= 3.2). I think that's the misunderstanding.

PS : I'm using a translator

 

[Oskar Schwarz]

The spreadsheet claims that the T2 L Minerva layout for the military settlement turns into the T1 M Enyo layout when built. Do we know if the security and system points provided are affected?

No, I think I got that report from the issue tracker and it didn't have any other info. But as we can't actually see our total stats in-game there's no way of confirming with 100% certainty anyway.
Although we could see it perhaps through the score and population increase as the Tier 2 Large settlements give more than the Tier 1 settlements. But no one has reported stats on those yet so... feel free to test it out and please report your findings.

There's still a warning about that in the latest version of the doc, so I thought this might still be helpful.

Just checked the military layout T2 Minerva. The stats provided are as expected, and the settlement has a large pad.

So, apparently, this bug is already fixed, or it occurs randomly.

Fly safe, o7