Changes

Jump to navigation Jump to search
170 bytes added ,  13:22, 14 February 2021
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 spreasheet.
+
* 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 ==
3,393

edits

Navigation menu