3,543
edits
(→Result) |
(→Recipe) |
||
Line 22: | Line 22: | ||
# minimum weighted distance sum - find the weighted distance sum that is the lowest. The corresponding city is the centroid city; | # minimum weighted distance sum - find the weighted distance sum that is the lowest. The corresponding city is the centroid city; | ||
# add cities - more cities can be added to see whether the found centroid city is correct. For this recommence on step 1; | # add cities - more cities can be added to see whether the found centroid city is correct. For this recommence on step 1; | ||
=== 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. | |||
* 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. | |||
== Result == | == Result == | ||
This recipe has been applied on the following countries: | This recipe has been applied on the following countries: |
edits