| Tendo Ryu | Thursday, May 15, 2014 - 03:28 pm 
Is there any way to insert a table into the forum post? If so I cannot tell how... |
| Borg Queen | Thursday, May 15, 2014 - 04:34 pm
autey aka Josh did that on the KB Forum in the old thread for KB Statistics from Scarlett quite on top of actual threads, maybe ask him |
| Rooster | Thursday, May 15, 2014 - 06:12 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.
;-) |
