Page 1 of 1

spreadsheet with basic civ2civ3 (2.6.2) data tables

Posted: Thu Sep 03, 2020 11:08 pm
by wildlingofthewall
I'm copying the base food, gov, combat etc. numbers out from the README to a Google Drive spreadsheet for quicker reference and perhaps some simple resource calculation later on.

For anyone interested here's a copy of the sheet:
https://docs.google.com/spreadsheets/d/ ... sp=sharing
and here's a live .ods copy:
https://docs.google.com/spreadsheets/d/ ... output=ods

Work in progress, most base numbers should be in place already though.

thanks to https://onlinecsvtools.com/convert-text-to-csv
https://brave.com/ installs all Chrome extensions, incl. Google Docs offline

Re: spreadsheet with basic civ2civ3 (2.6.2) data tables

Posted: Fri Sep 04, 2020 6:43 pm
by Ignatus
Thanks, great job! I hope once it will be possible to export a ruleset into CSV automatically.

Re: spreadsheet with basic civ2civ3 (2.6.2) data tables

Posted: Sat Sep 05, 2020 12:31 pm
by wildlingofthewall
Ignatus wrote:Thanks, great job! I hope once it will be possible to export a ruleset into CSV automatically.
thanks, I use it myself all the time and got into extended formulas for the first time now to string togethere a simple city ressource calculator.

The sheet will eventually be moved off Google docs to .ods LibreOffice and ethercalc.net (once I figure them out) to better align with Freeciv licensing and ethos.

Re: spreadsheet with basic civ2civ3 (2.6.2) data tables

Posted: Mon Sep 07, 2020 5:19 am
by wildlingofthewall
Image

- what I've got so far. Total spreadsheet noob despot (-1) but the Google AI is a good workmate and their support community top mark so it's been fun so far.

If the formulas can be fitted to suit gov types, wonders, city bonues, it might be a nice tracker tool for checking out city tiles, planning a bit ahead, stuff like that.