Some issues when I see the XLS

[DreJaDe]

I have seen the XLS
@Stratego (dev)
This is some of what I noticed and suggested some based from it.

There is no calculation for PRICE of ships.

Uboats
Calvi class sub have 2 number of attacks? Then why does it only have 1 in game?

"There is no calculation for submerged subs like their speed"

If it's the numbers on the right side of the "/" on the "Y" cells then surcouf is whong. It even only has 1 there.

Littorio
Have 381mm gun IRL
Not 220mm

So wrong attack damage as expected

Range calculation based on the spreadsheet
Yamato have 10
Dunkerque have 10.3
Richelieu have 9.8
Sovetzky Soyuz have 9.8
Iowa have 9.8

Compared to others, the next highest is just 9.

I think, it's fair that this ships to have 7 range in game.

[Stratego (dev)]

- cost is set manually
- attack count: also set manually
maybe xls is not up to date in above 2 columns (as we use xls for the vaues the XLS provides by equations)

submerged speed also set manually, if u have ideaa how to calculate tell me.

[Stratego (dev)]

I think, it's fair that this ships to have 7 range in game.

which ships?

[DreJaDe]

I think, it's fair that this ships to have 7 range in game.

which ships?

I literally mentioned them already but here

Range calculation for battleships
Yamato have 10
Dunkerque have 10.3
Richelieu have 9.8
Sovetzky Soyuz have 9.8
Iowa have 9.8

Currently, only Yamato have 7 attack range.
But I believe that this ships should all have 7 range and not just Yamato

[Stratego (dev)]

ok, just was not clear what you write.
also idk what ranges are in game already, all should be like the ones in xls.

if u think they are too big, we can change the equation in xls - you can suggest that is u can.

[DreJaDe]

ok, just was not clear what you write.
also idk what ranges are in game already, all should be like the ones in xls.

if u think they are too big, we can change the equation in xls - you can suggest that is u can.

From what I remember, the ships were adjusted in range because people complain about their big range compared to other artillery.

The result is the current range.

But now that I look at it, there was another calculation but on there, Yamato only have 6 range also with all others. (You might have created another range calculation.)

But in game, Yamato have 7 range which from what I remember, it's because Banzai suggested for its max range to be recognized.

But from the XLX itself, it seems that most of the ships I mentioned have the same range as Yamato, or at least close to it so much more than others. So with that logic and justification (and evidence of the earlier range calculation), I want the Ships I mentioned to be the same range as Yamato.