Goal -> Simulate MetaGame in Excel or similar -> Works under version control -> Then be able to export this to data that can be used and tweaked at runtime/semi-dynamically Issues -> using CSV files can be managed under version control, but no direct facility to simulate -> Excel is windows platform only, files don't work so great under version control -> LibreOffice works only across platforms, but is a bit harder to use. Similar version control issues. -> using sqlite3 is good for having a DB with schema. Scriptable and can export/import to text files. Can't simulate directly. -> Can hook up sqlite3 to an ODBC driver and access it in LibreOffice in Base and then import to Calc. Lots of software to install and setup/configure and fiddly. Changing values in the DB requires a re-import of data from Base to Calc. - Can change data in DB, then in Calc, in Data menu choose 'Refresh Range' and it updates - Perhaps can script this? ## http://sqlitebrowser.org brew cask install db-browser-for-sqlite wget http://www.ch-werner.de/sqliteodbc/sqliteodbc-0.9993.dmg wget http://www.odbcmanager.net/downloads/ODBC_Manager_Installer.dmg ## http://www.iodbc.org/dataspace/doc/iodbc/wiki/iodbcWiki/Downloads wget http://opldownload.s3.amazonaws.com/uda/components/7.0/universal-apple-macosx10.7-32/mxkozzzz.dmg #/usr/local/lib/libsqlite3odbc.dylib