| A | B | C | D | E | F | G | H | I | J | K | L | M | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Info & rules | Links | Formulas | More links & resources | |||||||||
2 | Type | Description | Example | Website name | Web address | Description | Code for the cell | Galleries | International info | Countries | Cities | Languages | Companies |
3 | Purpose | OGF data compiled in one place | (Sharing) this spreadsheet | OGF Data | Population density | =Ax/Ay; A is row number; x and y are column letters | OGF:Highlights | List of country codes | List of countries by population statistics | List of cities with more than one million inhabitants | List of languages | OGF:International Business Listing | |
4 | Faster accessibility than OGF wiki | OGF wiki | Main Page | Total | =sum(Ax,Ay); A is row number; x and y are column letters | Gallery of country coats of arms | List of international organizations | List of countries by economic statistics | List of city names in various languages | List of language families | List of manufacturing companies | ||
5 | Formality | OGF wiki formality | Relation Area Calculator | Relation area calculator | Average | =average(Ax,Ay); A is row number; x and y are column letters | Gallery of country flags | List of Edetanea Convention Wetlands of International Importance | List of countries by geographic statistics | Sibling Cities of the World | List of language groups | List of breweries | |
6 | Adding data | Only add data for territories you own/coordinate | Köppen classification | Köppen climate classification | Gallery of city flags | List of international sporting events | List of country names in various languages | List of botanical gardens | List of languages by OGFL code | List of wineries | |||
7 | Country row should be in alphabetical order | Public Transport Viewer | Route relations | Gallery of first level political division flags | List of WAFO World Cup tournaments | List of highest mountains | List of colleges and universities | List of alphabets | List of food distributors | ||||
8 | Constructive changes only; no vandalism | OGF: Embassies | Collab:Embassies | Gallery of other flags | List of world's fairs and expositions | Lists of embassies | List of commercial airports | List of city names in various languages | List of supermarkets | ||||
9 | Adding categories | No permission needed; see row 4 | Timezone map | https://old.opengeofiction.wiki//images/e/e0/Timezonessketch.jpg | Gallery of other coats of arms | List of generic top level Domains | List of currencies | List of major ports | List of country names in various languages | List of restaurants | |||
10 | Adding images | Insert image in cell; not over | Gallery of license plates | Administrative level usage by country | List of monarchies | List of museums | List of media companies | ||||||
11 | Data uncertainty? | No approximate data; no discrepancies | (Population density makes sense with population and land area data) | Airplane tool | http://oilofvitriol.com/users/pax/ogf2/# | Gallery of logos | Highway tag usage by country | List of republics | List of notable railway stations | List of retailers | |||
12 | Guidelines, examples, units? | Provided at the top of the category; if none, follow OGF wiki | Currency (e.g. Allendean Pitaicá, ALP, Ᵽ) | Hydroelectric Power Calculator | https://www.omnicalculator.com/ecology/hydroelectric-power | Gallery of new images | Place tag usage by country | List of unincorporated areas | List of parks | Travel and tourism[edit] | |||
13 | Order of categories | Ordered from most to least available for a typical OGF country | Wind Turbine Calculator | https://www.omnicalculator.com/ecology/wind-turbine | List of natural monuments | List of countries by driving side | List of tallest buildings and structures | List of airlines | |||||
14 | Year of data | All data should be up-to-date | Gini Index | https://en.wikipedia.org/wiki/List_of_countries_by_income_equality#/media/File:GINI_index_World_Bank_up_to_2018.png | World map of natural resources | List of travelling tips by each country | List of theaters and other cultural venues | ||||||
15 | Numerical data | No separators; period as decimal!!! | 123456.789 | World map of agricultural production | List of transportation agencies | List of urban rapid transit systems | |||||||
16 | Cells yellow? | Cells you definitely can and should fill | List of cultural monuments | List of armed forces | Speed limits by country | ||||||||
17 | Remove colour once filled | List of commemorative days | |||||||||||
18 | Other users can fill cell | List of Broadcast Call Signs (= List of radio and television stations) | |||||||||||
19 | Data unavailable? | Leave cell blank | Television channels | ||||||||||
20 | How to calculate area? | See row 5 in Links category | List of treaties | ||||||||||
21 | Add new spreadsheets | No permission needed | List of wars and conflicts | ||||||||||
22 | New spreadsheet should not have redundant data/purpose | ||||||||||||
23 | Rules here do not apply to other spreadsheets | ||||||||||||