3,543
edits
Centroid: Difference between revisions
→Spreadsheet
(→Recipe) |
Tags: Mobile edit Mobile web edit |
||
| Line 25: | Line 25: | ||
=== Spreadsheet === | === Spreadsheet === | ||
The recipe described above has been implemented in a Google spreadsheet. For each country (territory) a separate spreadsheet needs to be created (just copy an existing) one. Each spreadsheet has multiple worksheets. | The recipe described above has been implemented in a Google spreadsheet. For each country (territory) a separate spreadsheet needs to be created (just copy an existing) one. Each spreadsheet has multiple worksheets. | ||
* population worksheet: this worksheet lists the largest cities and their population (as columns), ordered by the population. The fraction is calculated from the data | * population worksheet: this worksheet lists the largest cities and their population (as columns), ordered by the population. The fraction is calculated from the data; | ||
* distance worksheet: this worksheet contains the distances between the cities noted on the population | * distance worksheet: this worksheet contains the distances between the cities noted on the population spreadsheet. The distances are taken from OpenStreetMap. Only the fields above the diagonal need to be filled. The fields below the diagonal are filled subsequently; | ||
* weighted sum: | |||
== Result == | == Result == | ||