Nice analysis here.

BUT

offensively and defensively archers are STILL the best units HANDS DOWN. just look at a scenario where you have 2 cities

City (A)
350,000 Archers
1 of All other units

City(B)
1M Pikemen
1 of All other units

Run a test attack these 2 cities repeatedly with 100k cavalry (Layering ALWAYS EXISTS) and see that Pikemen will ALWAYS have losses and eventually they will all die. Archers however take 0 yes ZERO damage

so i guess there u have it. Archers are hands down still the best infantry of this game.

now if only they come up with MOUNTED ARCHERS... i wonder.