Changes

Jump to navigation Jump to search
521 bytes added ,  13:19, 14 February 2021
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:
3,393

edits

Navigation menu