UK Loyal Citizen Percentages for 2300AD rpg by KevinC ( kevinc AT cnetech DOT com) Copyright © 2004 Kevin Clark. All Rights Reserved. http://www.geocities.com/pentapod2300/pop/ukloyal.txt Combines the Earth, OtherCol(ony), and Tirane populations from the other spreadsheets. Evaluates the formulas: LoyalTir(ane population) = lower of ( Earth - OtherCol) or Tirane Loy(al)Tir(ane)% = LoyTir(ane) / Tirane Year Earth OtherCol Tirane LoyalTir LoyTir% 2000 20,302,251 0 0 0 0.00% 2001 20,424,064 0 0 0 0.00% 2002 20,546,608 0 0 0 0.00% 2003 20,669,887 0 0 0 0.00% 2004 20,793,906 0 0 0 0.00% 2005 20,918,669 0 0 0 0.00% 2006 21,044,181 0 0 0 0.00% 2007 21,170,446 0 0 0 0.00% 2008 21,297,468 0 0 0 0.00% 2009 21,425,252 0 0 0 0.00% 2010 21,553,803 0 0 0 0.00% 2011 21,683,125 0 0 0 0.00% 2012 21,813,223 0 0 0 0.00% 2013 21,944,102 0 0 0 0.00% 2014 22,075,766 0 0 0 0.00% 2015 22,208,220 0 0 0 0.00% 2016 22,341,469 0 0 0 0.00% 2017 22,475,517 0 0 0 0.00% 2018 22,610,370 0 0 0 0.00% 2019 22,746,032 0 0 0 0.00% 2020 22,882,508 0 0 0 0.00% 2021 23,019,803 0 0 0 0.00% 2022 23,157,921 0 0 0 0.00% 2023 23,296,868 0 0 0 0.00% 2024 23,436,649 0 0 0 0.00% 2025 23,577,268 0 0 0 0.00% 2026 23,718,731 0 0 0 0.00% 2027 23,861,043 0 0 0 0.00% 2028 24,004,209 0 0 0 0.00% 2029 24,148,234 0 0 0 0.00% 2030 24,293,123 0 0 0 0.00% 2031 24,438,881 0 0 0 0.00% 2032 24,585,514 0 0 0 0.00% 2033 24,733,027 0 0 0 0.00% 2034 24,881,425 0 0 0 0.00% 2035 25,030,713 0 0 0 0.00% 2036 25,180,897 0 0 0 0.00% 2037 25,331,982 0 0 0 0.00% 2038 25,483,973 0 0 0 0.00% 2039 25,636,876 0 0 0 0.00% 2040 25,790,697 0 0 0 0.00% 2041 25,945,441 0 0 0 0.00% 2042 26,101,113 0 0 0 0.00% 2043 26,257,719 0 0 0 0.00% 2044 26,415,265 0 0 0 0.00% 2045 26,573,756 0 0 0 0.00% 2046 26,733,198 0 0 0 0.00% 2047 26,893,597 0 0 0 0.00% 2048 27,054,958 0 0 0 0.00% 2049 27,217,287 0 0 0 0.00% 2050 27,380,590 0 0 0 0.00% 2051 27,544,873 0 0 0 0.00% 2052 27,710,142 0 0 0 0.00% 2053 27,876,402 0 0 0 0.00% 2054 28,043,660 0 0 0 0.00% 2055 28,211,921 0 0 0 0.00% 2056 28,381,192 0 0 0 0.00% 2057 28,551,479 0 0 0 0.00% 2058 28,722,787 0 0 0 0.00% 2059 28,895,123 0 0 0 0.00% 2060 29,068,493 0 0 0 0.00% 2061 29,242,903 0 0 0 0.00% 2062 29,418,360 0 0 0 0.00% 2063 29,594,870 0 0 0 0.00% 2064 29,772,439 0 0 0 0.00% 2065 29,951,073 0 0 0 0.00% 2066 30,130,779 0 0 0 0.00% 2067 30,311,563 0 0 0 0.00% 2068 30,493,432 0 0 0 0.00% 2069 30,676,392 0 0 0 0.00% 2070 30,860,450 0 0 0 0.00% 2071 31,045,612 0 0 0 0.00% 2072 31,231,885 0 0 0 0.00% 2073 31,419,276 0 0 0 0.00% 2074 31,607,791 0 0 0 0.00% 2075 31,797,437 0 0 0 0.00% 2076 31,988,221 0 0 0 0.00% 2077 32,180,150 0 0 0 0.00% 2078 32,373,230 0 0 0 0.00% 2079 32,567,469 0 0 0 0.00% 2080 32,762,873 0 0 0 0.00% 2081 32,959,450 0 0 0 0.00% 2082 33,157,206 0 0 0 0.00% 2083 33,356,149 0 0 0 0.00% 2084 33,556,285 0 0 0 0.00% 2085 33,757,622 0 0 0 0.00% 2086 33,960,167 0 0 0 0.00% 2087 34,163,928 0 0 0 0.00% 2088 34,368,911 0 0 0 0.00% 2089 34,575,124 0 0 0 0.00% 2090 34,782,574 0 0 0 0.00% 2091 34,991,269 0 0 0 0.00% 2092 35,201,216 0 0 0 0.00% 2093 35,412,423 0 0 0 0.00% 2094 35,624,897 0 0 0 0.00% 2095 35,838,646 0 0 0 0.00% 2096 36,053,677 0 0 0 0.00% 2097 36,269,999 0 0 0 0.00% 2098 36,487,618 0 0 0 0.00% 2099 36,706,543 0 0 0 0.00% 2100 36,926,782 0 0 0 0.00% 2101 37,148,342 0 0 0 0.00% 2102 37,371,232 0 0 0 0.00% 2103 37,595,459 0 0 0 0.00% 2104 37,821,031 0 0 0 0.00% 2105 38,047,957 0 0 0 0.00% 2106 38,276,244 0 0 0 0.00% 2107 38,505,901 0 0 0 0.00% 2108 38,736,936 0 0 0 0.00% 2109 38,969,357 0 0 0 0.00% 2110 39,203,173 0 0 0 0.00% 2111 39,438,392 0 0 0 0.00% 2112 39,675,022 0 0 0 0.00% 2113 39,913,072 0 0 0 0.00% 2114 40,152,550 0 0 0 0.00% 2115 40,393,465 0 0 0 0.00% 2116 40,635,825 0 0 0 0.00% 2117 40,879,639 0 0 0 0.00% 2118 41,124,916 0 0 0 0.00% 2119 41,371,665 0 0 0 0.00% 2120 41,619,894 0 0 0 0.00% 2121 41,869,613 0 0 0 0.00% 2122 42,120,830 0 0 0 0.00% 2123 42,373,554 0 0 0 0.00% 2124 42,627,795 0 0 0 0.00% 2125 42,883,561 0 0 0 0.00% 2126 43,140,862 0 0 0 0.00% 2127 43,399,707 0 0 0 0.00% 2128 43,660,105 0 0 0 0.00% 2129 43,922,065 0 0 0 0.00% 2130 44,185,597 0 0 0 0.00% 2131 44,450,710 0 0 0 0.00% 2132 44,717,414 0 0 0 0.00% 2133 44,985,718 0 0 0 0.00% 2134 45,255,632 0 0 0 0.00% 2135 45,527,165 0 0 0 0.00% 2136 45,800,327 0 0 0 0.00% 2137 46,075,128 0 0 0 0.00% 2138 46,351,578 0 0 0 0.00% 2139 46,629,687 0 0 0 0.00% 2140 46,909,465 0 0 0 0.00% 2141 47,190,921 0 0 0 0.00% 2142 47,474,066 0 0 0 0.00% 2143 47,758,910 0 0 0 0.00% 2144 48,045,463 0 0 0 0.00% 2145 48,333,735 0 0 0 0.00% 2146 48,623,737 0 0 0 0.00% 2147 48,915,479 0 0 0 0.00% 2148 49,208,971 0 0 0 0.00% 2149 49,504,224 0 0 0 0.00% 2150 49,801,249 0 0 0 0.00% 2151 50,100,056 0 0 0 0.00% 2152 50,400,656 0 0 0 0.00% 2153 50,703,059 0 0 0 0.00% 2154 51,007,277 0 0 0 0.00% 2155 51,313,320 0 0 0 0.00% 2156 51,621,199 0 0 0 0.00% 2157 51,930,926 0 0 0 0.00% 2158 52,242,511 0 0 0 0.00% 2159 52,555,966 0 0 0 0.00% 2160 52,871,301 0 0 0 0.00% 2161 53,188,528 0 0 0 0.00% 2162 53,467,419 0 0 0 0.00% 2163 53,747,983 0 40,000 40,000 100.00% 2164 54,030,230 0 80,000 80,000 100.00% 2165 54,314,171 0 120,000 120,000 100.00% 2166 54,599,816 0 160,000 160,000 100.00% 2167 54,877,114 0 200,000 200,000 100.00% 2168 55,156,076 0 258,000 258,000 100.00% 2169 55,436,712 0 318,320 318,320 100.00% 2170 55,719,032 0 381,052 381,052 100.00% 2171 56,003,046 0 446,294 446,294 100.00% 2172 56,288,764 0 514,144 514,144 100.00% 2173 56,566,136 0 584,708 584,708 100.00% 2174 56,845,172 10,000 658,096 658,096 100.00% 2175 57,125,883 20,000 734,418 734,418 100.00% 2176 57,408,278 30,000 813,794 813,794 100.00% 2177 57,692,367 40,000 896,344 896,344 100.00% 2178 57,978,161 50,000 982,196 982,196 100.00% 2179 58,265,669 62,000 1,071,482 1,071,482 100.00% 2180 58,554,903 74,480 1,164,340 1,164,340 100.00% 2181 58,845,872 87,459 1,260,912 1,260,912 100.00% 2182 59,138,587 100,957 1,361,348 1,361,348 100.00% 2183 59,433,058 114,995 1,465,800 1,465,800 100.00% 2184 59,729,296 129,594 1,574,432 1,574,432 100.00% 2185 60,027,311 144,777 1,687,408 1,687,408 100.00% 2186 60,327,114 160,568 1,804,904 1,804,904 100.00% 2187 60,628,716 176,990 1,927,100 1,927,100 100.00% 2188 60,932,128 194,069 2,054,184 2,054,184 100.00% 2189 61,237,360 211,831 2,186,350 2,186,350 100.00% 2190 61,544,424 230,304 2,323,804 2,323,804 100.00% 2191 61,853,330 249,516 2,466,756 2,466,756 100.00% 2192 62,164,089 269,496 2,615,426 2,615,426 100.00% 2193 62,476,713 290,275 2,770,042 2,770,042 100.00% 2194 62,791,213 311,886 2,930,842 2,930,842 100.00% 2195 63,107,600 334,361 3,098,074 3,098,074 100.00% 2196 63,425,885 357,735 3,271,996 3,271,996 100.00% 2197 63,736,020 382,044 3,452,874 3,452,874 100.00% 2198 64,048,016 407,325 3,600,988 3,600,988 100.00% 2199 64,361,884 433,618 3,754,626 3,754,626 100.00% 2200 64,677,635 460,962 3,914,010 3,914,010 100.00% 2201 64,995,280 489,400 4,079,370 4,079,370 100.00% 2202 65,304,771 518,976 4,250,944 4,250,944 100.00% 2203 65,616,119 559,735 4,430,980 4,430,980 100.00% 2204 65,929,335 601,724 4,618,218 4,618,218 100.00% 2205 66,244,431 644,992 4,812,945 4,812,945 100.00% 2206 66,561,417 689,591 5,015,461 5,015,461 100.00% 2207 66,877,790 735,574 5,226,079 5,226,079 100.00% 2208 67,196,061 787,496 5,445,120 5,445,120 100.00% 2209 67,516,242 841,495 5,672,923 5,672,923 100.00% 2210 67,838,344 897,654 5,909,838 5,909,838 100.00% 2211 68,162,379 956,059 6,156,230 6,156,230 100.00% 2212 68,486,346 1,016,800 6,412,477 6,412,477 100.00% 2213 68,812,257 1,081,971 6,678,975 6,678,975 100.00% 2214 69,140,123 1,149,669 6,956,132 6,956,132 100.00% 2215 69,469,956 1,219,994 7,244,376 7,244,376 100.00% 2216 69,801,768 1,293,053 7,544,150 7,544,150 100.00% 2217 70,185,368 1,368,954 7,855,915 7,855,915 100.00% 2218 70,571,270 1,448,711 8,180,150 8,180,150 100.00% 2219 70,959,487 1,531,658 8,517,355 8,517,355 100.00% 2220 71,350,033 1,617,922 8,868,047 8,868,047 100.00% 2221 71,742,923 1,707,638 9,232,768 9,232,768 100.00% 2222 72,138,170 1,800,942 9,612,077 9,612,077 100.00% 2223 72,535,789 1,897,979 10,006,560 10,006,560 100.00% 2224 72,935,793 1,998,896 10,416,820 10,416,820 100.00% 2225 73,338,197 2,103,851 10,843,492 10,843,492 100.00% 2226 73,743,016 2,213,003 11,287,230 11,287,230 100.00% 2227 74,150,264 2,326,521 11,748,719 11,748,719 100.00% 2228 74,559,955 2,444,580 12,228,666 12,228,666 100.00% 2229 74,972,104 2,567,362 12,727,810 12,727,810 100.00% 2230 75,386,726 2,695,055 13,246,921 13,246,921 100.00% 2231 75,803,836 2,827,856 13,786,796 13,786,796 100.00% 2232 76,223,449 2,965,969 14,348,266 14,348,266 100.00% 2233 76,645,579 3,109,606 14,932,195 14,932,195 100.00% 2234 77,070,242 3,258,989 15,539,481 15,539,481 100.00% 2235 77,497,453 3,414,348 16,171,058 16,171,058 100.00% 2236 77,927,227 3,575,921 16,827,899 16,827,899 100.00% 2237 78,372,155 3,743,956 17,511,013 17,511,013 100.00% 2238 78,819,752 3,906,213 18,221,452 18,221,452 100.00% 2239 79,270,035 4,074,960 18,960,309 18,960,309 100.00% 2240 79,723,020 4,250,457 19,728,720 19,728,720 100.00% 2241 80,168,663 4,432,974 20,527,868 20,527,868 100.00% 2242 80,616,979 4,622,791 21,368,980 21,368,980 100.00% 2243 81,067,985 4,820,201 22,243,338 22,243,338 100.00% 2244 81,521,697 5,025,508 23,152,270 23,152,270 100.00% 2245 81,978,132 5,239,027 24,097,159 24,097,159 100.00% 2246 82,437,305 5,461,087 25,079,444 25,079,444 100.00% 2247 82,899,233 5,692,029 26,102,620 26,102,620 100.00% 2248 83,363,933 5,932,209 27,166,723 27,166,723 100.00% 2249 83,829,409 6,181,996 28,273,391 28,273,391 100.00% 2250 84,297,678 6,443,774 29,424,324 29,424,324 100.00% 2251 84,768,757 6,715,943 30,621,295 30,621,295 100.00% 2252 85,242,662 6,998,919 31,866,145 31,866,145 100.00% 2253 85,719,410 7,293,135 33,160,789 33,160,789 100.00% 2254 86,198,516 7,599,039 34,507,220 34,507,220 100.00% 2255 86,680,497 7,918,000 35,907,508 35,907,508 100.00% 2256 87,165,369 8,249,719 37,363,806 37,363,806 100.00% 2257 87,653,151 8,594,706 38,878,356 38,878,356 100.00% 2258 88,143,859 8,953,493 40,453,489 40,453,489 100.00% 2259 88,637,512 9,326,631 42,091,628 42,091,628 100.00% 2260 89,134,127 9,714,694 43,795,291 43,795,291 100.00% 2261 89,633,721 10,118,279 45,567,099 45,567,099 100.00% 2262 90,136,313 10,538,009 47,409,782 47,409,782 100.00% 2263 90,641,920 10,974,528 49,326,172 49,326,172 100.00% 2264 91,150,561 11,428,507 51,319,218 51,319,218 100.00% 2265 91,662,254 11,900,645 53,391,984 53,391,984 100.00% 2266 92,177,017 12,391,670 55,547,661 55,547,661 100.00% 2267 92,694,869 12,902,334 57,789,566 57,789,566 100.00% 2268 93,215,828 13,433,425 60,121,147 60,121,147 100.00% 2269 93,739,912 13,985,760 62,545,991 62,545,991 100.00% 2270 94,267,141 14,560,189 65,067,830 65,067,830 100.00% 2271 94,797,533 15,157,596 67,690,542 67,690,542 100.00% 2272 95,331,108 15,778,898 70,418,163 70,418,163 100.00% 2273 95,867,884 16,425,052 73,254,887 73,254,887 100.00% 2274 96,407,881 17,097,052 76,205,080 76,205,080 100.00% 2275 96,951,118 17,795,932 79,273,280 79,155,186 99.85% 2276 97,497,614 18,522,768 82,464,209 78,974,846 95.77% 2277 98,047,389 19,278,677 85,782,775 78,768,712 91.82% 2278 98,600,463 20,064,823 89,234,083 78,535,640 88.01% 2279 99,156,855 20,882,414 92,823,444 78,274,441 84.33% 2280 99,716,586 21,732,709 96,556,380 77,983,877 80.77% 2281 100,279,675 22,617,016 100,438,632 77,662,659 77.32% 2282 100,846,143 23,536,695 104,476,176 77,309,448 74.00% 2283 101,416,009 24,493,160 108,675,220 76,922,849 70.78% 2284 101,989,295 25,487,884 113,042,227 76,501,411 67.68% 2285 102,566,020 26,522,397 117,583,913 76,043,623 64.67% 2286 103,146,206 27,598,291 122,307,268 75,547,915 61.77% 2287 103,729,873 28,717,221 127,219,558 75,012,652 58.96% 2288 104,317,042 29,880,908 132,328,338 74,436,134 56.25% 2289 104,907,734 31,091,142 137,641,470 73,816,592 53.63% 2290 105,501,970 32,349,786 143,167,127 73,152,184 51.10% 2291 106,099,771 33,658,775 148,913,811 72,440,996 48.65% 2292 106,701,159 35,020,124 154,890,361 71,681,035 46.28% 2293 107,306,155 36,435,927 161,105,974 70,870,228 43.99% 2294 107,914,781 37,908,363 167,570,212 70,006,418 41.78% 2295 108,527,059 39,439,695 174,293,018 69,087,364 39.64% 2296 109,143,011 41,032,281 181,284,737 68,110,730 37.57% 2297 109,762,659 42,688,571 188,556,125 67,074,088 35.57% 2298 110,386,024 44,411,111 196,118,368 *65,974,913* 33.64% <--- More off Earth 2299 111,013,130 46,202,554 203,983,102 64,810,576 31.77% 2300 111,643,998 48,065,654 212,162,425 63,578,344 29.97% Year Earth OtherCol Tirane LoyalTir LoyTir% Last Update: 2004 Jul 04 First Online: 2004 Jul 04 Pentapod's World of 2300AD - http://www.geocities.com/TimesSquare/Arcade/2303/ Website maintained by: Kevin Clark (kevinc AT cnetech DOT com)