::Forum - city revenue equation question

Year 7 Day 152 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? ____________ Reek Havoc and let loose the Hogs of War

Year 7 Day 152 13:12	city revenue equation question
Ranma	Best is to send an email directly to the simmaster@swcombine.com ____________ SWC Fanpage --\\-- SWC Twitter

Year 7 Day 152 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 152 15:27	city revenue equation question
Ranma	I was suggesting that Zao email veynom, not me silly. ____________ SWC Fanpage --\\-- SWC Twitter

Year 7 Day 152 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 152 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 152 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. ____________ Reek Havoc and let loose the Hogs of War

Year 7 Day 153 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 153 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. ____________ Reek Havoc and let loose the Hogs of War

Year 7 Day 153 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. ____________ Reek Havoc and let loose the Hogs of War

	Year	Day	Time
	14	171	19:47:26

Logged in as
Guest