Clarifications

[Walter]

IIRC, I asked Logi somewhere and he said every year (for N6). Could be wrong about that though...

... and I noticed that it is in the rules as well... so I could have gotten it from there...

The population of a nation can increase over time. By default a country's population will grow at one of three different rates per sim year depending on it's status. In addition, if the country is not at war with anyone, it grows a further 0.5% more than usual every sim year. These 'usual' rates are as follows:

[Logi]

Walter is correct, it was intended to be per year.

As to the spreadsheet, there are plenty of things wrong with it. I haven't compiled (and can't ATM) all the changes.

[Darman]

Okay.  Fair enough. I'm going to run with Walter's formula because it actually makes more sense, and when I add population (I won't for 1900-2, don't worry) my revenue won't decrease. 

[Guinness]

As to the spreadsheet, there are plenty of things wrong with it. I haven't compiled (and can't ATM) all the changes.

This makes me sad, as it means starting over for 1900...

I guess it's time for me to actually learn all the rules and crank out my own simplified-so-someone-as-dumb-as-me-can-understand-it version.

[snip]

I have one with most of the changes fixed. Let me get it out of Google Drive and I will post it here.

EDIT: Here you guys go. Let me know if you find any formula errors and I can work to correct them. Its in both .xslx and .ods to cover all sorts of office programs, pick which one you need.

[Kaiser Kirk]

Hi Snip,

Thanks for putting those together.
I believe there is a formula error in research.
The formula is =IF(C7>B7;C7-B7;0)

So for my Piedmont area with 1.1 pop and 3 IC, it gives 1.9 research.

However, "It is one half of all the IC in excess of regional Pop "  so it should be (3-1.1)/2= (1.9)/2 = 0.95, or 1.  I could always go move those 100,000 folks I guess.

So I'm thinking there is a  /2 is missing.
Edit : Looking at the old spreadsheet it was missing there as well, but there was a Trunc(c7-b7) command which eliminates rounding.

Edit : so looking at your sample further, I notice the research of 50cal guns- that's 1902tech. I also went and looked at the US sample sim, where the research bug is evident.

[Darman]

I have one with most of the changes fixed. Let me get it out of Google Drive and I will post it here.

EDIT: Here you guys go. Let me know if you find any formula errors and I can work to correct them. Its in both .xslx and .ods to cover all sorts of office programs, pick which one you need.

Can we get a rundown of what the changes are?  I noticed changes to the Research section, anything else? 

[snip]

Mostly just formula cleanup and such. Nothing major to the functionality.

[Darman]

Mostly just formula cleanup and such. Nothing major to the functionality.

Okay, I'll just continue going through line by line then. 

Question though: when we swap techs we still have to pay to digest them right?  For example if I traded my own 1900 tech with someone else then they can't use it until they've digested it? 

[snip]

Correct

[Darman]

Should we be specifying the type of armor plate and ammunition that our ships are equipped with?  So a ship build in 1900 can't have 1900 armor plate unless you've researched them.  So my battleships have compound armor, but anyone who chooses the 1900 armor tech can have Krupp Cemented on any ships laid down in 1900. 

[snip]

Adding that as a note would not be a bad idea.

[snip]

Thanks for putting those together.
I believe there is a formula error in research.
The formula is =IF(C7>B7;C7-B7;0)

How many people have made major plans around the numbers this error produced?

Edit : so looking at your sample further, I notice the research of 50cal guns- that's 1902tech. I also went and looked at the US sample sim, where the research bug is evident.

My Derp-up on that for the 7" and 10" guns. The 4"/50 falls under the period-appropriate historical guns clause.

[miketr]

It sounds like people need to half their research totals.  So math is to be...

IF IC > POP then (IC - POP) / 2 = Research Points?

Michael

[snip]

This is what should go in cell F6. Just dragging it down as far as you need to should update all the variables for different rows.

Code Select Expand

= IF(C6 > B6, (C6-B6)/2, 0)