I'm gonna delete the missile line on these tanks soon it's an anoyance. Maybe I'll display secondary weapons for every vehicle later on the side of the units' tables.arkanjuca wrote:Fanstastic work out there.
I made a change to your sheet to get the cost per armor in a tank (factoring only the frontal armor).
To do so, you got to strip the "Armor " out of the armor values and use this formula right next to the armor values:
=D11 / VALUE(LEFT(B14;SEARCH(",";B14)-1))
On the tanks with missile, the D11 part should be adjusted to get the correct cost row.
I would like to see the HP of these tanks too, is it easy to obtain it?
What do you think about doing a combat simulator? I can create one with the right data and formulas
If you want to create a [armor/price] ratio I suggest you to make one for the front armor and one for the side because they prove usefull in very different situations. Best possible exemple : T64BV versus T72B
Side armor is realy easy to hit, the front side must be only 45° wide