Ok, I'm working on a spread sheet that will let my faction play with the #s and such to optimize a city for revenue. Here is the thing, I have a question on one equation, the crime rate equation. It is written here as: CR = CL x (Sum of (Facility [A] x surface [A]) ) / (Sum of (Facility [B] x surface [B] ) ) x eTL / 0.83. Now, I'm using Excel, just wondering how I would put this in. I get drastic differences in crime rates and income when I enter it in different ways. I have two extream ways of entering it in, just wondering which one is correct:
just straight with
CL x sum of A / sum of B x (eTL/0.83)
or grouped as
(CL x sum of A)/(sum of B x(eTL/0.83))
which is correct using excel?

The crime rate (IIRC) is actually calculated as (old crime rate) + (crime rate modifier of new facility). So the value is modified each time by construction, and NOT recalculated.

So good luck trying to calculate it in advance.

____________

"May the Grace of Ara go with you, and His Vengeance be wrought upon your enemies."

Ok, I'll e-mail simmaster@swcombine.com with this, and i'll post the reply here. There shouldn't be an old crime rate though, that is if you are building on planets with no population. At least that is what we are primarily doing anyways.

Ok guys, the official word from veynom when using excel is that the first one is correct:
CL x sum of A / sum of B x (eTL/0.83)

Where it is a X function, / function, X function, then x grouped function, where only grouping the division function at the end (eTL/0.83) is one variable.
This does make more sense, ... using the other equation, I could tweek the building of a city to turn out 1.3 billion a month, ... if there were not building restrictions.

wait, wait, I said that wrong, .... they are all state functions, group the last one togeather as a variable (eTL/0.83). That is just a better way of saying it.