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