At the beginning of this thread I published a spreadsheet about the effect certain events have upon happiness. In particular upon an Empires happiness, system happiness and a planets happiness.
Being a green grasshopper, I had no idea how to set up the columns to ensure the figures would line up properly.
Suicide Junkie was kind enough to edit my spreadsheet and line up the columns. He did a very credible job except for
Battle win
Facility constructed
Battle - stalemate
Battle - loss
Plagued - planet
Having learned how to edit, I have re-edited the spreadsheet to reflect the correct placing of the columns for the rows described above.
I think an explanation of the spreadsheet may be in order
1) I tried to arrange the factors in categories for a Peaceful Race in the following order:
-Positive effects on happiness
-Neutral effects on happiness
-Negative effects on happiness
2) I then added columns for Bloodthirsty races and Neutral races for comparison purposes only. So for these races, while the figures given should be accurate, they may be in the wrong Category. For example, a "Battle - win" for a neutral race is not positive effect but a negative one.
3) The Natural decrease - Own Empire is probably not strictly correct. Q did some extensive testing (see the end of this thread) and it would appear that there is a
-20 natural decrease for the planets which have a rioting/angry/unhappy population
0 (no change) if the population is indifferent
+20 natural increase for the planets which have a happy/jubilant population.
So, if you use the spreadsheet, you may wish to make these changes to it.
[Edit] Some of the cells have lines in them. These denote that one of the other races has an event which affects it's column. It was intended to act as a beacon or indicator.
Weeks ago, Suicide Junkie sent me an e-mail about the work he did on lining up the columns. I was very new and didn't realize he had actually corrected my posting.
My apologies to those who may have relied upon this spreadsheet to plan their strategy in their games.
[ August 25, 2002, 22:23: Message edited by: tbontob ]