Rome 2 Total War Units Spreadsheet

[ararax]

https://docs.google.com/spreadsheet/...rive_web#gid=0

TWC is blocked at work so I posted it here last.

Going to add Weapon based damage to the table and a few other things.

This is more of a quick reference material until someone can come up with a better list.

Update
Added full faction costs and Ranged Damage/Effective Range. Armour, and Weapons, unit special (Magic) skills

Tables
Name class attribute_group Charge Melee Attack AP Damage Damage Total Damage Armour Value Shield Armour Defence Shield Defense Total Armour + Defense HP Bonus Morale Unit Size MP Recruit Cost Campaign Recruit*Cost Upkeep Cost Recruitment Region Ranged AP Damage Ranged Damage Total Ranged Damage Effective Range Ammo reload Dismounted Charge Dismounted Melee Attack Dismounted Defence Hiding num_mounts rank_depth mount primary_melee_weapon primary_missile_weapon Armour shield spacing Weight spot_dist_scrub spot_dist_tree spotting_and_hiding strengths_weaknesses_text training_level visibility_spotting_range_max visibility_spotting_range_min category Skill 1 Skill 2 Skill 3 UID

[mbrasher1]

Did you include recruitment cost and maintenance. I didn't see it. Looks good.

[oighear_dubh]

Nice. Downloaded.

[Mixxer5]

Is this spreadsheet complete? Devs told about 800 units, here are only 404.

Plus- plenty of them have exactly same stats... No one said it'll be /unique/ units...

[ararax]

Did you include recruitment cost and maintenance. I didn't see it. Looks good.

Not yet, im still working on cross referencing the Damage tables.

BTW Bloodsworn are broken because they use clubs.... That jumps out in the sheet.



<melee_weapons record_uuid="{e023c0e7-e704-4566-a8e7-65879b2e72bd}" record_timestamp="1373620887558">
<ap_damage>10</ap_damage>
<armour_penetrating>0</armour_penetrating>
<armour_piercing>0</armour_piercing>
<audio_material>club</audio_material>
<bonus_v_cavalry>0</bonus_v_cavalry>
<bonus_v_elephants>0</bonus_v_elephants>
<bonus_v_infantry>0</bonus_v_infantry>
<damage>5</damage>
<first_strike>0</first_strike>
<key>rome_club</key>
<melee_weapon_type>axe</melee_weapon_type>
<shield_piercing>0</shield_piercing>
<weapon_length>1</weapon_length>
</melee_weapons>

@Mixxer5

404 Land units 118 Siege Units a couple of Chariots 2 dogs and about 200 Naval Units for 700 total.

Havent added Naval Units Yet.

[ararax]

Updated with Armour and 75% of recruitment/upkeep

[Sir_Pee_Alot]

Nice one

[Xelathur]

Thanks! +rep

[Mixxer5]

@Mixxer5

404 Land units 118 Siege Units a couple of Chariots 2 dogs and about 200 Naval Units for 700 total.

Havent added Naval Units Yet.

Ah- that's how it works. Thanks. Great work by the way

[ararax]

Got some nice updates.

Finished Recruitment and added Ranged Damage etc...

My last major add on my plate is total unit size.

If anyone has suggestions on what they want to add just say the word

[rrgg]

Does anyone have any decent tech/building trees that show when different units are unlocked? The in-game encyclopedia is just a pain to use.

[AlyssaFaden]

Nice man, nice - thank you for doing this. Sure beats my scribbles on the back of an envelope.

[temporaryname1]

dem thracians

[AlyssaFaden]

bump for a kickass spreadsheet

[ararax]

Some more fun updates, Unit Size, MP Recruit Cost, SP Recruit Cost, Unit Weight, and added Auxil Recruitment Area.

Also added a page that calculates how much of each major stat you get per coin in comparison to the average unit. But it is per unit not per soldier, so it is weighted to be overly generous to smaller sized units. Not to mention Ranged Damage is not in yet.

Enjoy.

[Ishan]

Thread Stuck. Good work, +5rep.

[ararax]

Thank you!

Added a new table I am working on, Skill effects.
https://docs.google.com/spreadsheet/...eEwxeGc#gid=12
Not 100% done yet.

[ararax]

Updated by adding the skills to each unit. Located on the far right end of the main spreadsheet.

[AlyssaFaden]

Thread Stuck. Good work, +5rep.

Perfect! It truly deserves it

[Roach]

The damage numbers for melee units do not match what I see in melee_weapons. I'm guessing they haven't been updated for Patch 3 yet? No biggie, since I've been working off the game data, but it'll be changed for everyone soon enough. I've been running damage vs armour calculations in an Excel spreadsheet, and the Patch 3 damage adjustments made armour more valuable (and technically, ranged units as well).