spreadsheet with basic civ2civ3 (2.6.2) data tables

Various topics about the game, the website, or anything else Freeciv related that doesn't fit elsewhere.
Post Reply
wildlingofthewall
Posts: 7
Joined: Mon Aug 31, 2020 9:10 am

spreadsheet with basic civ2civ3 (2.6.2) data tables

Post 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
Ignatus
Elite
Posts: 644
Joined: Mon Nov 06, 2017 12:05 pm
Location: St.Petersburg, Russia
Contact:

Re: spreadsheet with basic civ2civ3 (2.6.2) data tables

Post by Ignatus »

Thanks, great job! I hope once it will be possible to export a ruleset into CSV automatically.
wildlingofthewall
Posts: 7
Joined: Mon Aug 31, 2020 9:10 am

Re: spreadsheet with basic civ2civ3 (2.6.2) data tables

Post 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.
wildlingofthewall
Posts: 7
Joined: Mon Aug 31, 2020 9:10 am

Re: spreadsheet with basic civ2civ3 (2.6.2) data tables

Post 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.
Post Reply