Clarifications

[The Rock Doctor]

Me am pleased.

[Walter]

I got nothing at O34... actually I have nothing in column O... now I have to go and convert your xlsx file again into something I can work with so I know where to put the formula and know where they are referring to... :(

[snip]

I got nothing at O34... actually I have nothing in column O... now I have to go and convert your xlsx file again into something I can work with so I know where to put the formula and know where they are referring to... :(

What format do you want/need?

Me am pleased.

Glad the changes make things better.

[Walter]

I'm pretty sure that it will not matter once I get my computer 'upgraded'... in the mean time I will just convert it...

One error that I noticed in your spreadsheet with population increase is at I14 you have "B14 * (1 + H14/100)" while at I15 you have... *drumroll*... "B14 * (1 + H15/100)".

[Guinness]

Then put this into the new O34. (This should be the column headed with Cost)

Code Select Expand

= IF(M34="n", IF(K34-L34>0, EXP(0.321888*(K34-L34)), 0.05*(K34-L34) + 1), 0.5)

Oh, well, that makes *perfect* sense.  ;)

I may have to spring for wifi on the flight home today just so I can digest the rules for real. Are the rules themselves up to date?

[Walter]

Another thing I noticed: The US is paying $2.37 on the upkeep of 7 units that do not exist.

In the mean time, I noticed an error in my own report caused by inserting lines at the top of the Army tab resulting in the upkeep formula to skip a bunch of units at the top of the list...

[snip]

Another thing I noticed: The US is paying $2.37 on the upkeep of 7 units that do not exist.

Which would those be?

I may have to spring for wifi on the flight home today just so I can digest the rules for real. Are the rules themselves up to date?

The tech section has not, but I'm poking Logi about it now. AFAIK, the rest are up to date.

[Walter]

These...

You might want to correct the formulas in H27-33 as they are referrring to the units on lines 20-26. Saves you $2.37 if you do, :)

[snip]

ah, I see what you mean. Well, there is an additional $2.37 to play with.

Also, Clippy. That explains your compatibility issues.

[Logi]

I've put the modifications into the research rule post - the rules are now up to date.

[Darman]

when i plug the formula in it gives me a result of 0.50 as the cost even when I have no tech listed

[snip]

when i plug the formula in it gives me a result of 0.50 as the cost even when I have no tech listed

just remove the formula from cells that are not going to calculate costs. Making it self-zero tends to make for a very complicated formula.

[Darman]

ok

[Logi]

I'll push out a version where you don't have to do that later today.

[Logi]

Example Sim Report attached.

Changelog
- A few cells in Budget[Exp. Pop] had the wrong formula
- Unfilled research cells back to being zero cost
- Added automatic gun/mount research cost calculation
- Fixed incorrect formula in unfilled Army Upkeep cells
- Added additional base case for Fortresses, Fortified Lines, and Siege Artillery - it no longer responds to Tech 0 with an error