Quote:
Originally posted by kq76
Looks good. I'd be interested in the full file once it gets hosted. A couple of suggestions though:
-set it to manual calculation (tools | options | calculation tab | manual), that way it only recalculates when you press F9, otherwise you'll have to wait and lose what you had all the time when it recalculates on its own
-scroll each sheet to the top
-say where you got the population figures and how you turned them into the #s in the A columns as it'll help others tweak it for themselves if they want to maybe add more countries/cities.
|
I am not sure what happened on the manual calculation, I went to an older version when I had to reduce the file size. The full version on Joe's site is set to calculate manually.
I do not remember where I got the population figures from. It has been a while since I created this and I have lost the web site I used. I remember thinking that the figures seemed to be prior to the last census based on the number it had for my hometown. I think the US list has most cities with a population greater than 15k. I wanted more variety of Canadian cities so I got some of that data from an atlas.
The #'s (in the hidden A column) determine the frequency each city will appear. The difference between the 1st number and the number directly below it represent the population of the city (in thousands.) For example:
1 Aberdeen SD
25.8 Abilene TX
149.7 Addison IL
The figures I had showed Aberdeen SD with a population of 24,800 and Abilene TX with 123,900. Abiline will be approximately 5 times more likely to be generated than Aberdeen SD.