Spreadsheet: 88007d1287893895-auto-sorting-and-grouping-data-by-column-tropico-3
Sheet: Data

Background |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Respect | Statistics | Miscellaneous
Biblical Scholar | 1 | Intellectual Respect | 5 | 1 | Religious Respect | 10 | 2 | Crime | -0.15 | 2 | Education & Skill Rate | 0.1 | - | - | - |  |  |  |  |  |  | All Tropican Respect | Attend Church | Allow Uneducated Soldiers
Booze Baron | 1 | Religious Respect | -5 | 2 | Rum/Spiced Price | 1 | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  | Capitalist Respect | Attract./Enter. Quality | Annual Binge
Born into the People | 1 | Loyalist Respect | 25 | 3 | Free Palace Upgrades | - | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  | Communist Respect | Building Cost | Annual Bonus
Chief of Police | 1 | Militarist Respect | 10 | 2 | Crime | -0.4 | 2 | Liberty | -0.1 | - | - | - | - | - | - |  |  |  |  |  |  | Environmentalist Respect | Cost Bank/Mark./Souv. | Attract More Rich Tourists
Developer | 1 | Capitalist Respect | 20 | 1 | Environmentalist Respect | -10 | 2 | Building Cost | -0.2 | 2 | Pollution | 0.5 | - | - | - |  |  |  |  |  |  | Intellectual Respect | Crime | Attract More Spring Break-ers
Farmer | 1 | Communist Respect | 10 | 1 | Intellectual Respect | -10 | 2 | Farmer Production | 0.5 | - | - | - | - | - | - |  |  |  |  |  |  | Loyalist Respect | Edict Cost | [NAME] At Gambling
Fortunate Son | 1 | All Tropican Respect | 10 | 1 | Intellectual Respect | -10 | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  | Militarist Respect | Education & Skill Rate | Avatar is Better at Combat
Generalissimo | 1 | Militarist Respect | 20 | 1 | Nationalist Respect | 20 | 2 | Liberty | -0.2 | 2 | Soldier Experience | 0.15 | - | - | - |  |  |  |  |  |  | Nationalist Respect | Export Prices | Avatar More Likely To Flee
[NAME] | 1 | Capitalist Respect | 10 | 1 | US Relations | -30 | 1 | USSR Relations | 15 | 2 | Education & Skill Rate | 0.2 | - | - | - |  |  |  |  |  |  | Random Respect At Election | Factory Production | Avatar Moves Faster
Leftist Author | 1 | Communist Respect | 10 | 1 | Intellectual Respect | 15 | 2 | Education & Skill Rate | 0.2 | - | - | - | - | - | - |  |  |  |  |  |  | Religious Respect | Farmer Production | Avatar Moves Slower
Man of the People | 1 | Communist Respect | 20 | 1 | Religious Respect | 5 | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  | Smart Women Respect | Foreign Aid | Can Only Praise Yourself
Miner | 1 | Capitalist Respect | 10 | 1 | Communist Respect | 10 | 1 | Environmentalist Respect | -20 | 2 | Miner Production | 0.5 | - | - | - |  |  |  |  |  |  | [NAME] | Liberty | Cannot Build Colleges
Moscow U. | 1 | Communist Respect | 10 | 1 | US Relations | -15 | 1 | USSR Relations | 30 | 2 | Education & Skill Rate | 0.1 | - | - | - |  |  |  |  |  |  | [NAME] | Military Building Cost | First Diplomatic Ministry Free
Naturalist | 1 | Environmentalist Respect | 25 | 1 | Intellectual Respect | 15 | 2 | Building Cost | 0.1 | 2 | Pollution | -0.3 | - | - | - |  |  |  |  |  |  | US Relations | Miner Production | First Hotel is Free
Oil Tycoon | 1 | Capitalist Respect | 10 | 1 | Environmentalist Respect | -20 | 2 | Oil/Petrol Prices | 0.5 | - | - | - | - | - | - |  |  |  |  |  |  | USSR Relations | [NAME] | Free Palace Upgrades
Pop Singer | 1 | All Tropican Respect | 5 | 1 | US Relations | 10 | 2 | [NAME] | 30 | 2 | Tourism Rating | 0.1 | - | - | - |  |  |  |  |  |  | Women Respect | Oil/Petrol Prices | Lower Conseq. for Election Fraud
Professor | 1 | Intellectual Respect | 20 | 2 | Education & Skill Rate | 0.5 | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  |  | Overall Production | Maximum Salary
Secret Agent | 1 | Women Respect | 10 | 2 | Secret Agent Experience | 1 | 3 | Secret Police More Effective | - | - | - | - | - | - | - |  |  |  |  |  |  |  | Pollution | Min. Palace Guard Salary
Self-Made Man | 1 | Capitalist Respect | 10 | 1 | US Relations | 10 | 2 | Factory Production | 0.15 | - | - | - | - | - | - |  |  |  |  |  |  |  | Radio/TV Dogma | No Effect From Election Promises
Silver Spoon | 1 | Capitalist Respect | 25 | 1 | Communist Respect | -10 | 2 | Factory Production | 0.1 | 2 | Tourism Rating | 0.1 | 3 | Starting Money | 2000 |  |  |  |  |  |  |  | Religious Building Cost | No Elec. Speech Consequences
Travel Agent | 2 | Attract./Enter. Quality | 10 | 2 | Tourism Rating | 0.2 | - | - | - | - | - | - | - | - | - |  |  |  |  |  |  |  | Rum/Spiced Prices | Pay-Per-View Bonus
War Hero | 1 | All Tropican Respect | 5 | 1 | Nationalist Respect | 20 | 3 | Avatar is Better at Combat | - | - | - | - | - | - | - |  |  |  |  |  |  |  | Secret Agent Experience | Policemen Reduce Liberty
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Soldier Experience | Secret Police More Effective
Rise To Power |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Souvenir Shop Upkeep | Soldiers More Likely To Flee
Bought the Election | - | Fairly Low Democratic Exp. | - | 1 | Intellectual Respect | -5 | 3 | Lower Conseq. for Election Fraud | - | - | - | - | - | - | - | - | - | - | - | - | - |  | Sports Complex Cost | Starting Money
Capitalist Rebellion | - | Fairly Low Democratic Exp. | - | 1 | Capitalist Respect | 10 | 1 | US Relations | 25 | 2 | Factory Production | 0.1 | - | - | - | - | - | - | - | - | - |  | Sports Complex Quality | Swiss Banking Prohibited
Communist Rebellion | - | Low Democratic Exp. | - | 1 | Communist Respect | 10 | 1 | USSR Relations | 25 | 2 | Farmer Production | 0.1 | - | - | - | - | - | - | - | - | - |  | Tourism Rating
Elected as Capitalist | - | High Democratic Exp. | - | 1 | Capitalist Respect | 5 | 1 | US Relations | 15 | 2 | Factory Production | 0.2 | 2 | Liberty | 0.2 | - | - | - | - | - | -
Elected as Fascist | - | Moderate Democratic Exp. | - | 1 | Militarist Respect | 10 | 1 | Nationalist Respect | 10 | 2 | Crime | -0.1 | 2 | Liberty | -0.2 | - | - | - | - | - | -
Elected as Socialist | - | Fairly High Democratic Exp. | - | 1 | Communist Respect | 10 | 1 | USSR Relations | 15 | 2 | Liberty | 0.2 | - | - | - | - | - | - | - | - | -
Elected for Family Values | - | High Democratic Exp. | - | 1 | Religious Respect | 15 | 2 | Liberty | 0.2 | 2 | Tourism Rating | 0.1 | - | - | - | - | - | - | - | - | -
Heir Apparent | - | Fairly Low Democratic Exp. | - | 1 | All Tropican Respect | 10 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Hotel Corporate Buyout | - | Moderate Democratic Exp. | - | 1 | Capitalist Respect | 10 | 1 | Environmentalist Respect | 5 | 1 | US Relations | 15 | 2 | Liberty | 0.1 | 2 | Tourism Rating | 0.3 | 3 | First Hotel is Free | -
Installed by CIA | - | Fairly Low Democratic Exp. | - | 1 | Capitalist Respect | 10 | 1 | US Relations | 40 | 2 | Liberty | -0.3 | 3 | Annual Bonus | 2000 | - | - | - | - | - | -
Installed by KGB | - | Low Democratic Exp. | - | 1 | Communist Respect | 10 | 1 | USSR Relations | 40 | 2 | Liberty | -0.3 | 3 | Allow Uneducated Soldiers | - | - | - | - | - | - | -
Military Coup | - | Very Low Democratic Exp. | - | 1 | Militarist Respect | 20 | 2 | Crime | -0.2 | 2 | Liberty | -0.2 | 2 | Military Building Cost | -0.25 | - | - | - | - | - | -
Religious Appointment | - | Fairly Low Democratic Exp. | - | 1 | Religious Respect | 15 | 2 | Religious Building Cost | -0.25 | - | - | - | - | - | - | - | - | - | - | - | -
Velvet Revolution | - | High Democratic Exp. | - | 1 | Intellectual Respect | 20 | 1 | US Relations | 15 | 2 | Liberty | 0.2 | - | - | - | - | - | - | - | - | -
Qualities
Charismatic | 1 | All Tropican Respect | 5 | 2 | Radio/TV Dogma | 0.5 | - | - | - | - | - | - | - | - | -
Administrator | 2 | Building Cost | -0.1 | 2 | Education & Skill Rate | 0.1 | - | - | - | - | - | - | - | - | -
Athletic | 1 | Intellectual Respect | -5 | 1 | Militarist Respect | 5 | 2 | Sports Complex Cost | -0.2 | 2 | Sports Complex Quality | 90 | 3 | Avatar Moves Faster | -
Diplomatic | 1 | US Relations | 5 | 1 | USSR Relations | 5 | 3 | First Diplomatic Ministry Free | - | - | - | - | - | - | -
Empathy | 1 | All Tropican Respect | 10 | 1 | Intellectual Respect | -10 | - | - | - | - | - | - | - | - | -
Entrepreneurial | 2 | Export Prices | 0.1 | - | - | - | - | - | - | - | - | - | - | - | -
Financial Genius | 1 | Capitalist Respect | 10 | 2 | Cost Bank/Mark./Souv. | -0.25 | 2 | Factory Production | 0.2 | - | - | - | - | - | -
Green Thumb | 1 | Environmentalist Respect | 10 | 2 | Factory Production | -0.1 | 2 | Pollution | -0.5 | - | - | - | - | - | -
Hardworking | 2 | Overall Production | 0.1 | - | - | - | - | - | - | - | - | - | - | - | -
Incorruptible | 1 | Intellectual Respect | 10 | 1 | Religious Respect | 10 | 2 | Crime | -0.3 | 3 | Swiss Banking Prohibited | - | - | - | -
[NAME] | 1 | Nationalist Respect | 20 | 1 | [NAME] | 10 | - | - | - | - | - | - | - | - | -
Populist | 1 | Communist Respect | 5 | 1 | Nationalist Respect | 15 | 3 | No Elec. Speech Consequences | - | - | - | - | - | - | -
Scholarly | 1 | Intellectual Respect | 25 | 2 | Education & Skill Rate | 0.3 | - | - | - | - | - | - | - | - | -
Sociable | 1 | Communist Respect | 5 | 2 | Crime | 0.1 | 2 | Tourism Rating | 0.1 | 3 | Attract More Spring Break-ers | - | - | - | -
Well Travelled | 1 | Capitalist Respect | 10 | 1 | Intellectual Respect | 5 | 2 | Tourism Rating | 0.1 | 3 | Attract More Rich Tourists | - | - | - | -
Flaws
[NAME] | 1 | Capitalist Respect | -10 | 1 | Religious Respect | -10 | 2 | Factory Production | -0.1 | 2 | Souvenir Shop Upkeep | 1
Alcoholic | 1 | Religious Respect | 15 | 1 | USSR Relations | 10 | 2 | Overall Production | -0.05 | - | - | -
Cheapskate | 1 | Communist Respect | -10 | 2 | Building Cost | -0.05 | 3 | $25 Maximum Salary | - | - | - | -
Compulsive Gambler | 1 | Religious Respect | -10 | 3 | Annual Binge | $300-1500 | 3 | [NAME] At Gambling | - | - | - | -
Compulsive Liar | 1 | Intellectual Respect | -15 | 1 | Religious Respect | -15 | 3 | No Effect From Election Promises | - | - | - | -
Coward | 1 | Militarist Respect | -5 | 3 | Avatar More Likely To Flee | - | 3 | Soldiers More Likely To Flee | - | - | - | -
Flatulence | 1 | US Relations | -20 | 1 | USSR Relations | -10 | 3 | $20 Min. Palace Guard Salary | - | - | - | -
Great Schmoozola | 1 | Intellectual Respect | -20 | 1 | [NAME] | 10 | 1 | US Relations | -10 | 1 | USSR Relations | -10
Jingo | 1 | Nationalist Respect | 10 | 1 | US Relations | 15 | 1 | USSR Relations | 15 | - | - | -
Lazy | 2 | Overall Production | -0.1 | 3 | Avatar Moves Slower | - | - | - | - | - | - | -
Moronic | 2 | Education & Skill Rate | -0.3 | 3 | Cannot Build Colleges | - | - | - | - | - | - | -
Paranoid | 1 | All Tropican Respect | -10 | 1 | Militarist Respect | 10 | 3 | Policemen Reduce Liberty | - | - | - | -
Pompous | 1 | US Relations | -20 | 2 | Edict Cost | 0.3 | 3 | Can Only Praise Yourself | - | - | - | -
Religious Zealot | 1 | Intellectual Respect | -25 | 1 | Religious Respect | 5 | 2 | Attend Church | 0.5 | - | - | -
Short Tempered | 1 | Intellectual Respect | -15 | 1 | Militarist Respect | -10 | - | - | - | - | - | -
Shy | 1 | Loyalist Respect | -20 | 2 | Foreign Aid | -0.15 | - | - | - | - | - | -
Tourette's Syndrome | 1 | Random Respect At Election | -25 | 1 | US Relations | -15 | 1 | USSR Relations | -15 | 3 | Pay-Per-View Bonus | 1000
Ugly | 1 | All Tropican Respect | -5 | 2 | Tourism Rating | -0.1 | - | - | - | - | - | -
Womanizer | 1 | Religious Respect | -10 | 1 | Smart Women Respect | -10 | - | - | - | - | - | -