### Properties XLS - for unit differentiation

Posted:

**Sat Sep 02, 2017 10:05 pm**I realized that we should not make "i think" things on unit types that have very exact data on internet.

So we need to compare the real values of tanks, and i figured out this XLS form to do that (i made it for myself a year ago when i started to build this game)

My great request if someone could fill up

thanks!

(here is he xlsx attached, i enabled posting XLS on forum.)

please fill up both for TANKS - thanks!

latest xls

<please email to Stratego for the latest XLS>

(i do not update it always as almost daily changes with new units - so please ask for an update if you want the current)

and image:

Formulas (i was not sure if everyone can read XLS and decode how formulas are giving the values):

hp calc= (<weight> * 3 / 2.4) + 5

armor calc = <max armor> / 15

speed calc=( <speed>-10)/20+<op.range>/100

power calc = <gun dia> / 3.5

(tell me if anyone need the other formulas in xls (anti tank, AA and so on - they might differ)

So we need to compare the real values of tanks, and i figured out this XLS form to do that (i made it for myself a year ago when i started to build this game)

My great request if someone could fill up

**all TANKS**we have in game already (first only tanks, later we will continue with other units types that has information on intenet - mostly all war machines has info on internet)thanks!

(here is he xlsx attached, i enabled posting XLS on forum.)

IMPORTANT:

In the XLS

- the "blue" columns means the real value (speed, armor etc.), - fill these with real WIKIPEDIA based information

- the yellow columns are the current in-game values: in-game speed, in-game armor and so on. - fill these with in-game current values (get latest version)IMPORTANT:

In the XLS

- the "blue" columns means the real value (speed, armor etc.), - fill these with real WIKIPEDIA based information

- the yellow columns are the current in-game values: in-game speed, in-game armor and so on. - fill these with in-game current values (get latest version)

please fill up both for TANKS - thanks!

latest xls

<please email to Stratego for the latest XLS>

(i do not update it always as almost daily changes with new units - so please ask for an update if you want the current)

and image:

Formulas (i was not sure if everyone can read XLS and decode how formulas are giving the values):

**TANKS:**hp calc= (<weight> * 3 / 2.4) + 5

armor calc = <max armor> / 15

speed calc=( <speed>-10)/20+<op.range>/100

power calc = <gun dia> / 3.5

(tell me if anyone need the other formulas in xls (anti tank, AA and so on - they might differ)