Population Projections

[mmartin798]

Originally Posted by Desert Mariner

Dragoon500ly’s thread on population increase/decrease got me looking at my old population projection spreadsheet and I realized that it was long overdue for an update. For those interested the result is attached.

.
.
.


Any comments and/or feedback are appreciated.

There is a problem with your base population calculation. You are using the percent change over the decade as the growth rate. They are not the same thing. The error is most obvious in the spreadsheet for Florida which shows a base population over 70 million in 1988, when the 1990 census data shows a population of only 9 million.

Since you have the census data, you could just do interpolation to get a much closer estimate for the base populations.

[Desert Mariner]

Originally Posted by mmartin798

There is a problem with your base population calculation. You are using the percent change over the decade as the growth rate.

Thanks for pointing out the error. The issue was actually in the growth rate table. Something was off when I copied from the original. It's now been fixed (constants replaced with the original formulas) and the calculations appear to be functioning as intended.

Corrected file is attached. If you see anything else, please be sure to let me know.

[Desert Mariner]

I'm in the process of updating this generator with US 2020 census figures. If anyone is interested, I can post it when I'm finished.