| Tom Morgan (Kebir Blue) | Thursday, January 5, 2012 - 01:49 am 
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 |
| Gothamloki (Kebir Blue) | Thursday, January 5, 2012 - 02:31 am
Tom, you can get that info from the My Downloads page. You'll need to do the compiling, but all the data's there. |
| Tom Morgan (Kebir Blue) | Thursday, January 5, 2012 - 02:54 am
Where do you find it? I remember seeing it somewhere but I've looked and its not there. |
| Tom Morgan (Kebir Blue) | Thursday, January 5, 2012 - 02:57 am
Found it. This may take a while. Do not get angry if my data is 10 game years old when i release it. |
| Psycho_Honey (Golden Rainbow) | Thursday, January 5, 2012 - 03:48 am
lol |
| Crafty | Friday, January 6, 2012 - 11:30 pm
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. |
| Blueserpent | Friday, January 6, 2012 - 11:39 pm
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 you might also wish to sort by Army or Production.
Sort Descending to get the largest value at the top.
When posting use \ table {[paste values]}, minus the spaces.
 |
| Crafty | Friday, January 6, 2012 - 11:42 pm
Thanks for that Kissie. ;) |
| Blueserpent (Little Upsilon) | Friday, January 6, 2012 - 11:50 pm
*sighs,
You should give ol Blue a lil more credit than u do CC
A lot smarter than u think |
| Crafty | Friday, January 6, 2012 - 11:57 pm
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 |
| Blueserpent | Saturday, January 7, 2012 - 12:04 am
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....
|
| Crafty | Saturday, January 7, 2012 - 12:12 am
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... |
| Blueserpent | Saturday, January 7, 2012 - 12:19 am
pfft...wild didnt write them, grrrr.
Cup for us, so no point loss |
| Christopher Michael (Golden Rainbow) | Monday, February 27, 2012 - 09:03 pm
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! |
