Oolite Commerce Worksheet

  • user warning: Unknown column 'project_release_nodes.tid' in 'on clause' query: SELECT project_release_nodes.version AS project_release_nodes_version, node.nid AS nid, project_release_nodes.nid AS project_release_nodes_nid, node.uid AS node_uid, node.type AS node_type, node_revisions.format AS node_revisions_format, project_release_nodes.update_status AS project_release_nodes_update_status, term_data_project_release_nodes.weight AS term_data_project_release_nodes_weight, project_release_nodes.version_major AS project_release_nodes_version_major, project_release_nodes.version_minor AS project_release_nodes_version_minor, project_release_nodes.version_patch AS project_release_nodes_version_patch, project_release_nodes.version_extra_weight AS project_release_nodes_version_extra_weight, project_release_nodes.version_extra AS project_release_nodes_version_extra FROM node node LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid INNER JOIN project_release_supported_versions project_release_supported_versions_project_release_nodes ON project_release_nodes.pid = project_release_supported_versions_project_release_nodes.nid AND (project_release_supported_versions_project_release_nodes.major = 0 AND project_release_supported_versions_project_release_nodes.tid = 0) INNER JOIN term_data term_data_project_release_nodes ON project_release_nodes.tid = term_data_project_release_nodes.tid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (project_release_nodes.version_api_tid in ('887')) AND (project_release_supported_versions_project_release_nodes.supported <> 0) AND (project_release_nodes.rebuild = 0) AND (project_release_supported_versions_project_release_nodes.recommended_release = node.nid) AND (project_release_supported_versions_project_release_nodes.recommended <> 0) AND (project_release_nodes.pid = 10166 ) ORDER BY term_data_project_release_nodes_weight ASC, project_release_nodes_version_major DESC, project_release_nodes_version_minor DESC, project_release_nodes_version_patch DESC, project_release_nodes_version_extra_weight DESC, project_release_nodes_version_extra DESC in /home2/hyperlo1/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1153.
  • user warning: Unknown column 'project_release_nodes.tid' in 'on clause' query: SELECT project_release_nodes.version AS project_release_nodes_version, node.nid AS nid, project_release_nodes.nid AS project_release_nodes_nid, node.uid AS node_uid, node.type AS node_type, node_revisions.format AS node_revisions_format, term_data_project_release_nodes.weight AS term_data_project_release_nodes_weight, project_release_nodes.version_major AS project_release_nodes_version_major, project_release_nodes.version_minor AS project_release_nodes_version_minor, project_release_nodes.version_patch AS project_release_nodes_version_patch, project_release_nodes.version_extra_weight AS project_release_nodes_version_extra_weight, project_release_nodes.version_extra AS project_release_nodes_version_extra FROM node node LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid INNER JOIN project_release_supported_versions project_release_supported_versions_project_release_nodes ON project_release_nodes.pid = project_release_supported_versions_project_release_nodes.nid AND (project_release_supported_versions_project_release_nodes.major = 0 AND project_release_supported_versions_project_release_nodes.tid = 0) INNER JOIN term_data term_data_project_release_nodes ON project_release_nodes.tid = term_data_project_release_nodes.tid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (project_release_nodes.version_api_tid in ('887')) AND (project_release_supported_versions_project_release_nodes.supported <> 0) AND (project_release_nodes.rebuild = 0) AND (project_release_supported_versions_project_release_nodes.recommended_release = node.nid) AND (project_release_supported_versions_project_release_nodes.recommended = 0) AND (project_release_nodes.pid = 10166 ) ORDER BY term_data_project_release_nodes_weight ASC, project_release_nodes_version_major DESC, project_release_nodes_version_minor DESC, project_release_nodes_version_patch DESC, project_release_nodes_version_extra_weight DESC, project_release_nodes_version_extra DESC in /home2/hyperlo1/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1153.
  • user warning: Unknown column 'project_release_nodes.tid' in 'on clause' query: SELECT project_release_nodes.version AS project_release_nodes_version, node.nid AS nid, project_release_nodes.nid AS project_release_nodes_nid, node.uid AS node_uid, node.type AS node_type, node_revisions.format AS node_revisions_format, term_data_project_release_nodes.weight AS term_data_project_release_nodes_weight, project_release_nodes.version_major AS project_release_nodes_version_major, project_release_nodes.version_minor AS project_release_nodes_version_minor, project_release_nodes.version_patch AS project_release_nodes_version_patch, project_release_nodes.version_extra_weight AS project_release_nodes_version_extra_weight, project_release_nodes.version_extra AS project_release_nodes_version_extra FROM node node LEFT JOIN project_release_nodes project_release_nodes ON node.nid = project_release_nodes.nid INNER JOIN project_release_supported_versions project_release_supported_versions_project_release_nodes ON project_release_nodes.pid = project_release_supported_versions_project_release_nodes.nid AND (project_release_supported_versions_project_release_nodes.major = 0 AND project_release_supported_versions_project_release_nodes.tid = 0) INNER JOIN term_data term_data_project_release_nodes ON project_release_nodes.tid = term_data_project_release_nodes.tid LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid WHERE (node.status = 1 OR (node.uid = 0 AND 0 <> 0) OR 0 = 1) AND (project_release_nodes.version_api_tid in ('887')) AND (project_release_supported_versions_project_release_nodes.supported <> 0) AND (project_release_nodes.rebuild <> 0) AND (project_release_supported_versions_project_release_nodes.snapshot <> 0) AND (project_release_nodes.pid = 10166 ) ORDER BY term_data_project_release_nodes_weight ASC, project_release_nodes_version_major DESC, project_release_nodes_version_minor DESC, project_release_nodes_version_patch DESC, project_release_nodes_version_extra_weight DESC, project_release_nodes_version_extra DESC in /home2/hyperlo1/public_html/sites/all/modules/views/plugins/views_plugin_query_default.inc on line 1153.
Submitted by drink on Sat, 2008-03-22 10:51

Oolite is an advanced, extended, extensible clone of a classic game called Elite.

Early advancement in the game must be done through trading, although you could be trading either legal or illegal goods. Because there are hundreds of systems in the game spread across multiple galaxies, there's a lot of information to keep track of. There's seventeen different commodities and each planet values them differently - and each planet's value for each commodity changes over time! While some people have provided printable fill-in forms to record commerce information, they do not represent any reasonable method for keeping track of all this data.

Now, in the real world (postulating sufficient scientific advancement for us to be flying around in small spacecraft) you would have a computer that would keep track of all this for you. It would connect to the trading network and download the values, and keep track of them over time.

In order to provide myself this functionality I have developed an Excel spreadsheet which has a tab for each system and an index tab. Each system's tab allows you to make an entry for each visit you make and these are averaged; these averages are then displayed on the index tab, and then averaged to produce a galactic average.

The spreadsheet does not provide any functionality to make adding systems easier, but there is a tab with help information and if you have basic competency with spreadsheets you will be able to maintain it.

This spreadsheet has a bunch of data from my universe, which may or may not apply to yours.

Downloads