Simcountry
Forum General Request for Empire/Federation Stats (Kebir Blue)

Request for Empire/Federation Stats (Kebir Blue)

T
Tom Morgan (Kebir Blue)

All worlds
05 Jan 2012 01:49Link
Can someone please post the Empire/Federation stats for the 5 worlds? Last one we had was October...

If someone could tell me how to find them or get them off the GMs I would happily do it myself.

Cheers,
T
G
Gothamloki (Kebir Blue)

All worlds
05 Jan 2012 02:31Link
Tom, you can get that info from the My Downloads page. You'll need to do the compiling, but all the data's there.
T
Tom Morgan (Kebir Blue)

All worlds
05 Jan 2012 02:54Link
Where do you find it? I remember seeing it somewhere but I've looked and its not there.
T
Tom Morgan (Kebir Blue)

All worlds
05 Jan 2012 02:57Link
Found it. This may take a while. Do not get angry if my data is 10 game years old when i release it.
P
Psycho_Honey (Golden Rainbow)

All worlds
05 Jan 2012 03:48Link
lol
C
Crafty

All worlds
06 Jan 2012 23:30Link
It shouldnt be that hard T. The data is in a format that will plug immediately into an Excel speadsheet or similar, so I believe. Then it just depends on your spreadsheet skills. lol.
B
Blueserpent

All worlds
06 Jan 2012 23:39Link
Download "country history sheets" from My Downloads.

Open in MS Excel.

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 the column beginnings selected. Sort by Population, or
C
Crafty

All worlds
06 Jan 2012 23:42Link
Thanks for that Kissie. ;)
B
Blueserpent (Little Upsilon)

All worlds
06 Jan 2012 23:50Link
*sighs,

You should give ol Blue a lil more credit than u do CC :)

A lot smarter than u think :)
C
Crafty

All worlds
06 Jan 2012 23:57Link
Lol, tell me you use spreadsheets... heheh.

The only spreadsheet you know is the one you put down on the floor before the plasterer starts, lmao!

You're a hairy arsed northern grunt with too many tats!!! How about Sunderland? Good place to spend new years day :)

Thanks Kissie. :-D
B
Blueserpent

All worlds
07 Jan 2012 00:04Link
where do think the ASQ excel sheets came from u cockney spurs supporting geriatric :)


sunderland i can accept even if it was offside, but we cant defend with 2 defenders or that happens, so no complaints.

Liverpool match was more like it and im ready to see man u go down on sunday....:)
C
Crafty

All worlds
07 Jan 2012 00:12Link
To be honest, I thought they were Wilds (the original) creation.

6 points behind you son, and a game in hand on yous and Utd.
Have a nice weekend...
B
Blueserpent

All worlds
07 Jan 2012 00:19Link
pfft...wild didnt write them, grrrr.


Cup for us, so no point loss :)
C
Christopher Michael (Golden Rainbow)

All worlds
27 Feb 2012 21:03Link
Well, I have give it my best shot; I'm just not familiar enough with Excel......even with Blue's good instructions. The one thing that I do not see on the excel sheets from W3C is the presidents names....just country names.

Hope TM has more luck!