2018 active members
165 are online

Year

20

Day

238

Time

20:25:11        Message CentreRPG CentreQuestion Centre
Archives » city revenue equation question
Year 7 Day 153 11:01 city revenue equation question
Zao Nephalem 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?

____________ Fights like Hurricane, Killing, Ecstasy, Insane.
Year 7 Day 153 13:12 city revenue equation question
Ranma Best is to send an email directly to the simmaster@swcombine.com

____________ Year 7 Day 153 15:17 city revenue equation question
Arc Davaire Hey Ramma, when you get a reply, could you post the explanation here as well? I'm working on a similar spreadsheet, and was wondering the same thing.

____________ Year 7 Day 153 15:27 city revenue equation question
Ranma I was suggesting that Zao email veynom, not me silly.

____________ Year 7 Day 153 15:36 city revenue equation question
Arc Davaire Meh, my bad. I knew that, but something was lost between my brain and my fingers. Ah well, it's time to sleep.

____________ Year 7 Day 153 15:46 city revenue equation question
Hal Breden 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."

Only fools and children dream of heroes.
Year 7 Day 153 18:59 city revenue equation question
Zao Nephalem 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.

____________ Fights like Hurricane, Killing, Ecstasy, Insane.
Year 7 Day 154 6:06 city revenue equation question
Imazushi Shinoto Um, Rand Axim has something somewhat like that, just for building. Maybe he can help you out.

Year 7 Day 154 11:20 city revenue equation question
Zao Nephalem 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.

____________ Fights like Hurricane, Killing, Ecstasy, Insane.
Year 7 Day 154 12:33 city revenue equation question
Zao Nephalem 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.

____________ Fights like Hurricane, Killing, Ecstasy, Insane.