I've been using Excel more often lately, so I've modified the Sample Excel sheet that P3D posted in Rules->Useful Tools.

I've Modified the Research no. so its divided by 3 rather than 2.
I've Modified the Navy Sheet so that it takes into account ships built to DD tech, Mercantile standards, MTB tech, and Submarine tech.
I've Modified the Army Sheet so the upkeep is based on the new upkeep rates.

I've Added the Armour Sheet for computing the upkeep cost for heavy armor, light armor, etc.
I've Added the Aircraft Sheet for computing the upkeep for airships and aircrafts, including different upkeep based on Type level and year design, and single/multi-engine aircraft, etc.

Cool - thank you for doing that.

No problem ;)

Ah, note:

The excel sheet I posted has a minor lack in it that I have noticed so far:

The Navy Sheet -> Cost

cell function should be replaced with this:

Quote=IF(L12="W",(D12/1000),IF(L12="D",(D12/1000*1.5),IF(OR(L12="S",L12="T"),(D12/500),IF(L12="M",(D12/4000)))))

Another problem spotted, I missed it while sweeping over P3D's old spreadsheet;

For Navy Sheet -> Upkeep

cell function should be replaced with this:

Quote=IF(H12="M",F12/20,IF(H12="A",F12/40,IF(H12="R",F12/200,0)))

The original function does not count for the added upkeep cost of multiple ships of the same class.

Quote from: Logi on February 25, 2010, 02:44:45 PM
No problem ;)

Ah, note:

The excel sheet I posted has a minor lack in it that I have noticed so far:

The Navy Sheet -> Cost

cell function should be replaced with this:

Quote=IF(L12="W",(D12/1000),IF(L12="D",(D12/1000*1.5),IF(OR(L12="S",L12="T"),(D12/500),IF(L12="M",(D12/4000)))))

Gives ERROR=503

Strange, this is no divisor by zero as the IF statement takes care of that
It should, if neither W,M,T,S,or D are placed at the corresponding L row come out as FALSE:

Hmm.... if you could give me the excel file you are working on; I could try to figure it out.

I suppose that I can made ctrl c - ctrl v to transfer:

The list of the ships in the Navy, (cost...status...upkeep...affectation...)
but just the list of the airfields & complet board after...


Jef