Clarifications

[snip]

Today we learned the Logi is the Excel wizard, Snip is just a pretender.

[Walter]

Shall we now call him Tim?

[Kaiser Kirk]

just for general knowledge - I had previously migrated Italian data into snip's prior sheet. This time I migrated Logi's formulas to that. I was paying for some soldiers that didn't exist apparently.  While scrutinizing things, I discovered I was also paying for aviation assets...I hadn't even thought to check that tab as * I * didn't have any.  It may just fall on somebody else to be the first to practice aerial bombardment and bomb the Turks in 1911.

[snip]

Yes, do check your Air tabs. I am building a few Airships and a place to park them.

[Logi]

Just so everyone knows, I've spotted another error. Snip changed the ship construction formula so it no longer quarters BP cost on mercantile-standard ships.

Replace the [Occ. BP] cell which has:
= (H28/1000) * IF(E28 = "rc", 0.1, IF(E28 = "c", 1, 0)) + IF(E28 = "o", 0, G28)
with this formula:
=(H28/1000) * IF(E28 = "rc", 0.1, IF(E28 = "c", 1, 0))  * LOOKUP(I28, 'Navy Maint.'!$N$11:$N$22, 'Navy Maint.'!$P$11:$P$22) + IF(E28 = "o", 0, G28)

I've also extended the table for ship maintenance to include tenders. You can extend the table by inserting the following cells in-between the Ship Type table on Naval Maint. and then doing an automatic reordering of the cells in that table. You must do it like that of the formulas will break.
t   / 1.00  / 0.25
tf  / 1.25  / 0.25

Alternatively, wait for me go over the rest of the sheet and push out the new version.


Also, the ships should have their last refit date as their complete date by default. The cell is highlighted when the difference between the current year and the year in the last refit cell is more than 10. If you input "N/A" - looking at you Snip - it won't work as intended.

[Darman]

I'm going to redo my sim report.  just let me know when you have the final version ready.... I can make all my final changes on that report. 

[Logi]

Here is the corrected spreadsheet.

Changelog
- Fixed Mercantile-standard Ship Construction Error
- Added Tenders to Ship Type Table
- Fixed Incorrect Formula for Fortress Summation

I've changed back Snip's modification for Coastal Defenses - simply because I don't have standard battery sizes like he does. I'm sure you guys can change it if need be.

[Guinness]

[bitchmode]
If I wanted to debug Excel all day, I'd go into software and systems architecture.
[/bitchmod]

Oh wait... too late.

I'm diving into transcribing my data into Logi's latest spreadsheet. I already see issues: the formulas for computing revenue per region on the budget tab seem to be inconsistent. Should the last constant in that formula be '0' or '0.5'?

[Darman]

0.5 I think

(that's what I have on my spreadsheet.)

[Darman]

Here is my spreadsheet.  Please take a look and tell me if anything is amiss. 

[snip]

Ya, the .5 is correct as far as I can tell.

[Logi]

I didn't touch that section, but it seems 0.5 is the correct one.

Edit: I'll be doing a more comprehensive check of the whole sheet - hopefully with some behind the scenes testing before releasing an "official" version.

[Kaiser Kirk]

Preamble
Having finally gotten around to estimating gun performance,
I've decided in the early 1900s it's time to start researching some new guns.
Pretty happy with the historic 12" and 240mm, but need a bit more range vs. MTBs, and more punch at the cruiser level.

The chart doesn't really go down far enough, so I scaled based on energy/cross section.
I think I can get the shell weights & MV I want with the ME available in /45 tech.

Question #1
I was wondering what this meant : When a gun is first researched, the player can pick ONE free mount (outside of the single-deck provision). There is no need to research single deck mounts (+/- hoists) and casemates for guns of 8.27"/210mm and smaller.

So, I'm considering a 180mm and a 90mm,
I don't need to research single deck mounts (& hoists), nor casements because of their size.
So...I can choose a twin 180mm turret and a twin 90mm Mount and Hoist as the "Free" ?


Question #2
Is Naval Propulsion a "tree" that needs to be researched in sequence, or a collection of techs that can be researched as they come up ?

[snip]

Remember for the smaller guns, there are enough historical examples that a 90mm L50 could be justified.

So...I can choose a twin 180mm turret and 90mm Mount and Hoist as the "Free" ?

Yes

Question #2
Is Naval Propulsion a "tree" that needs to be researched in sequence, or a collection of techs that can be researched as they come up ?

Tree. Drive shafts and Misc Propultion are not.

[Kaiser Kirk]

Tree. Drive shafts and Misc Propultion are not.

doh, I meant misc propulsion, it's just not bolded.

TY