Full Excel about Pharaoh 1.0.1 Unit Balance[docs.google.com]

• List of all units
  
• Infantry = extended details
  
• Infantry Duels + ELO ranking
  
• Missiles = extended details
  
• Missile Duels + ELO Ranking
  
• Chariots

I have simulated duels between each infantry, so I don't have to open Custom battle and right-click to charge with every infantry combination that exists.
This simulation is like autoresolve, it will calculate who wins and how efficiently.
100% mean that unit is equal
50% means that opponent is 2x stronger
200% means that unit is 2x stronger than opponent

Elo ranking is a system where each player has hidden magical number that means how strong the player is.
When player wins, his elo rank goes up, but when looses then elo goes down.
In this excel, units are players, and they all compete against each other.

Note = Elo version 1 started with units having their Elo equal to their multiplayer Cost (aka Combat Potential)
Note = Elo version 2 started with units having same starting Elo (1000)

You can give experience to unit, aka Rank them Up, and that will increase their Morale/Attack/Defence/Reload.
I have included 9 EXP versions of each infantry into calculation, so we all could see which units are worth more with it and which aren't.

Some units can switch weapon during combat, and when they do so, they will have different stats. Units that switched their weapon are calculated like a separate unit, so we can compare whether it is worth it or not.

You can subscribe to Youtube channel to see future reviews/guides/findings, and I need your help to grow Pharaoh community.
Please join Pharaoh Discord, it is friendly, and it is the first place where you can find awesome stuff like this, before it get's revealed to public. Also we got memes
Clone the excel, play with it, give comments, share your findings.

By Eruner

Additionaly here is another great excel about Weapons, Weapons vs Armour and Units Balance with those weapons.

Link to the Weapon Balance Excel[docs.google.com]

Quick video about Weapons:

In this list you can find all rosters:

Playlist of all rosters

↑ You can become an expert within 1 hour and something