Artillery Unit Base Damage Damage Cap Damage Cap Total
Arsonist 28 48 76
Culverin 40 80 120
Falconet 100 200 300
Falconet vs. Infantry 100 600 700
Flamethrower 5 20 25
Flaming Arrow 75 140 215
Flying Crow 190 380 570
Gattling Gun 360 720 1,080
Great Bombard 500 1,000 1,500
Grenadier[1] 16 36 52
Hand Mortar 20 50 70
Heavy Cannon 200 400 600
Horse Artillery 125 250 375
Light Cannon 70 140 210
Li'l Bombard 400 800 1,200
Mortar 500 1,000 1,500
Morutaru 385 750 1,135
Organ Gun 198 396 594
Rocket 300 600 900
Siege Elephant 40 200 240
Siege Elephant - Mansabdar 40 400 440
Udasi Temple Chakram   18 36 54
Infantry Unit Base Damage Damage Cap Damage Cap Total Seige Damage Damage Cap Damage Cap Total
Abus Gun 40 80 120 15 80 95
Dopplesoldner 20 40 60 60 80 140
Hatamoto Samuri 58 116 174 120 160 280
Incan Bolas Warrior 8 16 24 ---- ---- ----
Nootka War Chief 24 48 72 ---- ---- ----
Ronin 58 116 174 120 160 280
Skull Knight 20 68 88 72 96 168
Imperial Skull Knight 20 136 156 72 ---- #VALUE!
Imperial Skull Knight vs. Cav 20 408 428 73 ---- #VALUE!
Urumi 17 38 55 28 37 65
Urumi - Mansabdar 17 38 55 28 37 65
Cavalry Unit Melee Base Damage Melee Damage Cap Melee Damage Cap Total Seige Damage Seige Damage Cap Seige Damage Cap Total
Cuirassier (RG) 30 60 90 30 120 150
Flail Elephant[2] 14 28 42 140 130 270
Howdah 33 66 99 ---- ---- ----
Mahout[3] 28 56 84 100 130 230
Spahi 35 70 105 28 ---- ----
Sufi Mosque War Elephant 20 40 60 36 72 108
Tashunke Prowler 15 40 55 15 30 45
Yojimbo 35 116 151 ---- ---- ----
War ShipUnit Range Base Damage Damage Cap Damage Cap Total Boadside Damage Boadside Cap Damage Cap Total Long Range Damage Long Range Cap Dam Cap Total Seige Damage Dam Cap Damage Cap Total Building Seige Dam Building Dam Cap Building Dam Cap Total
Atakabune ---- ---- ---- ---- ---- ---- ---- ---- ---- 35 70 105 ---- ---- ----
Canoe 16 32 48 ---- ---- ---- ---- ---- ---- 40 ---- ---- ---- ---- ----
Caravel ---- ---- ---- 50 100 150 ---- ---- ---- 75 150 225 ---- ---- ----
Fire Junk ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- 500 1,500 2,000
Fluyt (Dutch) ---- ---- ---- ---- ---- ---- ---- ---- ---- 70 140 210 ---- ---- ----
Frigate ---- ---- ---- 40 80 120 ---- ---- ---- 90 180 270 ---- ---- ----
Fuchuan ---- ---- ---- 50 100 150 ---- ---- ---- 90 180 270 ---- ---- ----
Fune ---- ---- ---- 25 80 105 ---- ---- ---- 40 80 120 ---- ---- ----
Galleon ---- ---- ---- ---- ---- ---- ---- ---- ---- 50 96 146 ---- ---- ----
Galley (Ottoman) ---- ---- ---- 40 50 90 ---- ---- ---- 100 140 240 ---- ---- ----
Ironclad ---- ---- ---- ---- ---- ---- 200 400 600 115 230 345 ---- ---- ----
Marathan Catamaran 16 32 48 ---- ---- ---- ---- ---- ---- 40 ---- ---- ---- ---- ----
Monitor ---- ---- ---- ---- ---- ---- 200 400 600 80 160 240 ---- ---- ----
Privateer ---- ---- ---- 30 60 90 ---- ---- ---- 100 200 300 ---- ---- ----
Tekkousen ---- ---- ---- 35 80 115 ---- ---- ---- 90 180 270 ---- ---- ----
Tlaloc Canoe ---- ---- ---- ---- ---- ---- ---- ---- ---- 50 80 130 200 ---- ----
War Canoe 40 60 100 ---- ---- ---- ---- ---- ---- 100 ---- ---- ---- ---- ----
War Junk ---- ---- ---- 35 120 155 ---- ---- ---- 50 100 150 ---- ---- ----
Wokou Junk ---- ---- ---- 40 80 120 ---- ---- ---- 70 140 210 ---- ---- ----
Hero Unit Base Damage Damage Cap Damage Cap Total Seige Damage Damage Cap Damage Cap Total Swash Damage Swash Cap Dam Cap Total Eagle Eye Dam Eagle EyeCap Damage Cap Total Roundhouse Dam Roundhouse Dam Cap Damage Cap Total
Aztec War Chief ---- ---- ---- ---- ---- ---- 60 120 180 ---- ---- ---- ---- ---- ----
British Explorer ---- ---- ---- ---- ---- ---- 100 200 300 ---- ---- ---- ---- ---- ----
China Monk ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- 170 200 370
Indian Monk 4 40 44 ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
Iroquois War Chief ---- ---- ---- ---- ---- ---- ---- ---- ---- 75 150 225 ---- ---- ----
Japan Monk[4] ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ----
Sioux War Chief 6 50 56 15 60 75 50 100 150 ---- ---- ---- ---- ---- ----
Miscellaneous Notes:
1 The list above represents all of the units in AOE3 that have a damage cap included.  All of these units, with the exception of the Abus gun, have an area of effect damage.  The fact that the Abus gun has a damage cap seems to be a bug where it possibly had area damage in beta testing.  Damage capacity only applies to area damage.  Units that have two attack types (melee and ranged), the damage cap only applies to the method with area damage.  The damage cap in trample damage is excluded since the trample formation is useless.  
2 Added a damage cap estimate which decreases the “effectiveness” value of all units with an area of attack and makes the spreadsheet more accurate.  I assume the damage cap increases with all upgrades (HC shipment, veteran, guard, etc.) and increases with multipliers to different unit types (i.e. damage cap is increased for culverin versus artillery by a factor of 4).    
3 All melee cavalry (cossack, hussar, uhlan, etc.) have a damage cap on trample damage which is not included since this spreadsheet does not compare this unit formation.  The trample formation is currently useless.
4 The Dopplesoldner should not have a damage cap on siege damage to stay consistent with other hand heavy infantry units.  
5 Damage Capacity Formula (LINK to Discussion)
Damage Capacity = [Base Damage] + [Base Damage Capacity * Upgrades * Multipliers]
[1]
NOTE:
The damage capacity only applies to the ranged attack versus units.  There is no damage capacity versus buildings. 
[2]
NOTE:
Includes Mansabdar
[3]
NOTE:
Includes Mansabdar
[4]
NOTE:
NOTE:
Killing Blow at 25%