Simcountry
Forum Little Upsilon LU Federation Stats: 19 Feb 2011 (Little Upsilon)

LU Federation Stats: 19 Feb 2011 (Little Upsilon)

S
Scarlet (Little Upsilon)

All worlds
20 Feb 2011 05:56Link
RankFederation Population Army Production % in Army Ppc Nominal Value
1IDC Complex 1,940,293,149 56,353,575 14,707,460,413,105 2.90% 7,580 2,277.81
2IA Complex 1,938,364,395 55,115,344 14,399,048,922,892 2.84% 7,428 3,580.96
3VS Complex 892,367,148 31,016,358 8,733,338,256,696 3.48% 9,787 1,381.22
4Free Nations Central 839,983,107 53,095,503 4,039,662,755,321 6.32% 4,809 954.24
5The New Federation 821,734,156 22,825,568 6,138,106,366,7
T
The Walking Glitch (Little Upsilon)

All worlds
20 Feb 2011 06:09Link
How does one get these stats (besides from you?)?
S
Scarlet (Little Upsilon)

All worlds
20 Feb 2011 08:01Link
Download "country history sheets" from My Downloads (On the side menu).

Open in MS Excel (I'm basing this of Excel 2003).

Data >> PivotTable and PivotChart Report...

Use the default settings for PivotTable.

Use President Name for "Row Fields".
Use vCmainTotalPopulation for "Data Items".
Copy these columns.
Paste them off to the side.

Use Employed Army for Data Items.
Remove vCmainTotalPopulation from "Data Items".
Copy this column.
Paste it next to Population off to the side.

Repeat for Total Production Value.

Use Army/Population to find % in Army.
Use Production/Population to find Ppc.

Make it neat with Comma Style values for all columns except % in Army. Use Percent Style for % in Army. Move decimals where appropriate.

Use "Data >> Filter >> AutoFilter" with one of
L
Lou Cyphre (Little Upsilon)

All worlds
20 Feb 2011 10:33Link
looks like Hellscorne Alliance is inactive. his indexes are very low in all of his countries.
T
The Walking Glitch (Little Upsilon)

All worlds
20 Feb 2011 17:35Link
Oh, okay, thanks (I know the Open Office bit thats a little different since I'm on linux)
O
opensesame11 The Conqueror (Little Upsilon)

All worlds
20 Feb 2011 23:55Link
Ty Scarlet

Btw, what does the 'army' column represent?
B
Border C

All worlds
21 Feb 2011 08:01Link
My, has LU fallen.
S
Scarlet (Little Upsilon)

All worlds
21 Feb 2011 08:23Link
Army is the number of Soldiers and Officers in the army.