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
Thanks for that Kissie. ;)
B
Blueserpent (Little Upsilon)
All worlds
*sighs,
You should give ol Blue a lil more credit than u do CC
A lot smarter than u think

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
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....
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...
pfft...wild didnt write them, grrrr.
Cup for us, so no point loss

C
Christopher Michael (Golden Rainbow)
All worlds
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!