Page 1 of 2 12 LastLast
Results 1 to 30 of 32

Thread: All Units - All Stats (Spreadsheet:TW)

  1. #1
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default All Units - All Stats (Spreadsheet:TW)

    All Units - All stats


    To see the unit tables you need to open the Html comment links below the images. Some of the tables are very large, you may need to scroll down. Sometimes additional info is noted at the bottom of tables.

    Additional info from the unit file:
    Mental stats:
    Discipline may be normal, low, disciplined or impetuous.
    Impetuous units may charge without orders
    Training determines how tidy the unit's formation is.
    Discipline the response to morale SHOCKS

    Weapon attributes:
    ap = armour piercing. Only counts half of target's armour
    bp = body piercing. Missile can pass through men and hit those behind
    spear = Used for long spears. Gives bonuses fighting cavalry, and penalties against infantry
    long_pike = Use very long pikes. Phalanx capable units only
    short_pike = Use shorter than normal spears.
    thrown = The missile type if thrown rather than fired
    spear & light_spear = The unit when braced has various protecting mechanisms versus cavalry charges from the front
    spear_bonus_x = attack bonus against cavalry. x = 2, 4, 6, 8, 10 or 12

    *Disclaimer*
    The mechanics of the battle engine have not been fully disclosed by CA. The performance of any given unit is not determined by the stats given here alone, but by a combination of these stats and the units' animations. This means that a unit may perform better or worse than the stats indicate. Keep that in mind when you compare stats.




    Open https://forums.totalwar.org/mizu/Ras/Infantry.html    Warning: this will open off-site content.
    Close https://forums.totalwar.org/mizu/Ras/Infantry.html.




    Open https://forums.totalwar.org/mizu/Ras/Miss.Infantry.html    Warning: this will open off-site content.
    Close https://forums.totalwar.org/mizu/Ras/Miss.Infantry.html.




    Open https://forums.totalwar.org/mizu/Ras/Cavalry.html    Warning: this will open off-site content.
    Close https://forums.totalwar.org/mizu/Ras/Cavalry.html.




    Open https://forums.totalwar.org/mizu/Ras/Miss.Cavalry.html    Warning: this will open off-site content.
    Close https://forums.totalwar.org/mizu/Ras/Miss.Cavalry.html.
    Last edited by therother; 04-27-2019 at 21:05.

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  2. #2
    Guardian of the Fleet Senior Member Shahed's Avatar
    Join Date
    Oct 2002
    Location
    Leading the formation!
    Posts
    7,918

    Default Re: All Units - All Stats (Spreadsheet:TW)

    EXCELLENT work ! Thanks.

    BTW Is there a downloadable excel version forseen ?
    Also how did you get the Mongol Horse Archers in that color ?
    If you remember me from M:TW days add me on Steam, do mention your org name.

    http://www.steamcommunity.com/id/__shak

  3. #3
    Typing from the Saddle Senior Member Doug-Thompson's Avatar
    Join Date
    Apr 2003
    Location
    Fayetteville, AR
    Posts
    2,455

    Default Re: All Units - All Stats (Spreadsheet:TW)

    I got a "timed out" error every time I tried a regular reply to this thread, or I would have complimented the work much earlier.

    Anyway, an excellent and very helpful thread.
    "In war, then, let your great object be victory, not lengthy campaigns."

  4. #4
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Attempt # 32:
    Sinan, yes others have asked me and I'll upload an xls file soon.
    Doug, imagine trying to edit this beast. It took me four hours to post and edit it.

    R'as

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  5. #5
    Typing from the Saddle Senior Member Doug-Thompson's Avatar
    Join Date
    Apr 2003
    Location
    Fayetteville, AR
    Posts
    2,455

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Well, your work is appreciated. I'm making changes to my missile cavalry guide now based on what this shows.

    Cuman Horse Archers have the letter "no" in their attributes category, the column next to ammo. What does that mean, or is it just a typo?
    "In war, then, let your great object be victory, not lengthy campaigns."

  6. #6
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Cuman Horse Archers have the letter "no" in their attributes category, the column next to ammo. What does that mean, or is it just a typo?
    It means no special attribute for the projectile. I forgot to edit it out.
    Thanks.

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  7. #7
    Join the ICLADOLLABOJADALLA! Member IrishArmenian's Avatar
    Join Date
    May 2006
    Location
    Writing the book, every day...
    Posts
    1,986

    Default Re: All Units - All Stats (Spreadsheet:TW)

    You forgot the dismounted Dvor. I can't recall their exact stats, though they are a little different than Dvor calvary. They would be missile infantry.

    "Half of your brain is that of a ten year old and the other half is that of a ten year old that chainsmokes and drinks his liver dead!" --Hagop Beegan

  8. #8
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    You forgot the dismounted Dvor.
    I can see them.

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  9. #9
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Thanks to Tosa
    for the idea on how to fix the problem that this page took ages to load if it loaded at all. It's a bit different now but should work. I'm working on further improvements.


    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  10. #10
    Senior Member Senior Member katank's Avatar
    Join Date
    Feb 2004
    Location
    Cambridge, MA, USA
    Posts
    3,739

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Quote Originally Posted by Sinan
    Also how did you get the Mongol Horse Archers in that color ?
    I believe those are Kazaks. Waaaay worse units than Mongol horse archers. These guys just melt in melee like butter over flame.

  11. #11
    Typing from the Saddle Senior Member Doug-Thompson's Avatar
    Join Date
    Apr 2003
    Location
    Fayetteville, AR
    Posts
    2,455

    Default Re: All Units - All Stats (Spreadsheet:TW)

    I've waited for this since the game came out. Thanks, R'as al Ghul.
    "In war, then, let your great object be victory, not lengthy campaigns."

  12. #12
    Pelekyphoros Barbaros Member Rurik the Chieftain's Avatar
    Join Date
    Dec 2004
    Location
    The biggest tent in the camp.
    Posts
    77

    Default Re: All Units - All Stats (Spreadsheet:TW)

    I have also waited on this from day one. I knew someone would come through

    It's a shame that the new importance of attack animations makes it harder to make a unit-to-unit comparison of melee attacks. But very satisfying all the same!

  13. #13
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    I've cleaned up the tables a bit and uploaded the excel file.
    Download here


    R'as

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  14. #14

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Thanks a billion for the excel files!
    - Soulitaire

  15. #15
    Member Member Philbert's Avatar
    Join Date
    Jan 2007
    Location
    The Netherlands
    Posts
    144

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Hello!

    I seem to be missing artillery?

    Thanks,
    Philbert
    Hebban olla uogala nestas bigunnan hinase hic enda thu

  16. #16
    Man behind the screen Member Empirate's Avatar
    Join Date
    Mar 2005
    Location
    Heidelberg, Germany
    Posts
    246

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Awesome work, R'as! Thanks a lot for this fantastic piece of referencable material from me too!
    People know what they do,
    And they know why they do what they do,
    But they do not know what what they are doing does
    -Catherine Bell

  17. #17

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Brilliant guide. I shall refer to it often.

    Do hand gunners really cost 1250 florins? I never noticed - and I have about 5 of them!
    Last edited by Lorenzo_H; 01-26-2007 at 10:08.
    I support Israel

  18. #18
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    I've added a column for mount speeds.

    I'll upload an updated excel file some time.
    Artillery I might add, too.

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  19. #19
    Senior Member Senior Member Carl's Avatar
    Join Date
    Dec 2006
    Posts
    1,461

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Random point, Both types of Carrico Standered and the Great Cross have Lock_Morale and thus cannot rout at all.

    Wagon Forts are not normally avalibile, unless you mod them in BTW.
    Find my ProblemFixer Purehere.

    This ProblemFixer fixes the following: 2-Hander bug, Pike Bug, Shield Bug, Chasing Routers, Cav not Charging, Formation Keeping Improved, Trait Bugs, and Ancillary Bugs.

    BETA Testers needed for the current version of RebuildProblemFixer. Thread here

  20. #20
    Join the ICLADOLLABOJADALLA! Member IrishArmenian's Avatar
    Join Date
    May 2006
    Location
    Writing the book, every day...
    Posts
    1,986

    Default Re: All Units - All Stats (Spreadsheet:TW)

    I suggest someone putting spoiler tags around the areas that contain the charts. It would be a little easier to navigate the pages, however, this is still the best unit cross chart I have ever seen.
    To the author: May we copy it? I would like to copy it and print it so that I can have a reference guide for when I am playing. With RTW I printed one out and taped it to the wall.

    "Half of your brain is that of a ten year old and the other half is that of a ten year old that chainsmokes and drinks his liver dead!" --Hagop Beegan

  21. #21

    Default Re: All Units - All Stats (Spreadsheet:TW)

    R'as,

    If you're still updating this, please add voulge militia; thanks.

  22. #22
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Quote Originally Posted by Miracle
    R'as,

    If you're still updating this, please add voulge militia; thanks.
    I'm waiting for the 1.2 update patch before I'll update my table.
    Are voulge militia different from Voulgier?

    R'as

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  23. #23

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Amazing job, R'as al Ghul. Congratulation.

    Where did you find this data? Is it in a game file?

    There are two other attributes witch may be interesting;
    Availability (both Era and Fraction) and Bonus (Province where the unit may get bonus if trained there and Bonus against other units ex. Pike vs. Cav.)

  24. #24
    Member Member Boyar Karhunkynsi's Avatar
    Join Date
    Feb 2007
    Location
    A metal gig near you!
    Posts
    31

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Good work R'as.

    I'm downloading excel now so I can print around 15 HUGE copies to go all around my room, so I can see it from any direction. On the matter, why don't I paint it on my wall? It's not like I really use my wall for much

    Again, R'as shows his awesomeness.

    -Max
    "Our ancestors took this land. They took it and made it and held it. We do not give up what out ancestors gave us. They came across the sea and they fought here and they built here and they're buried here. This is our land mixed with our blood, strengthened with our bone. Ours."


    M2TW is too easy; even on VH/VH.
    New Zealand Heathen Pride!
    Blacklodge Brutal

  25. #25

    Default Re: All Units - All Stats (Spreadsheet:TW)

    What is the elephant rocketeer??

  26. #26

    Default Re: All Units - All Stats (Spreadsheet:TW)

    A unit only available in the campaign by pressing ` or ' and typing vindaloo in when a battalion is selected. The unit offers limited benefits.

  27. #27

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Very nice Spreadsheet, Thank you for making open to everyone. Only one complaint. Arty, where is it?
    "To foresee a victory which the ordinary man can foresee is not the acme of skill;...To Triumph in battle and be universally acclaimed `EXPERT` is not the acme of skill, for to lift an autumn down requires no great strength; to distinguish between the sun and moon is no test of vision; to hear the thunderclap is no indication of acute hearing...."
    -Sun Tzu, The Art of War

  28. #28
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Ah well, okay. I'll add artillery if you all want it.
    But I won't post an update until 1.2 is out officially.

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

  29. #29
    Member Member Tugrul Cagri's Avatar
    Join Date
    May 2007
    Location
    Ankara(Ancyra)
    Posts
    13

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Quote Originally Posted by R'as al Ghul
    Ah well, okay. I'll add artillery if you all want it.
    But I won't post an update until 1.2 is out officially.
    I insist on guides for 1.2,thanks for your contributions.
    Even though you know a thousand things, ask the man who knows one.

  30. #30
    Clan Takiyama Senior Member R'as al Ghul's Avatar
    Join Date
    Jan 2003
    Location
    ignores routers who aren't elite
    Posts
    2,554

    Default Re: All Units - All Stats (Spreadsheet:TW)

    Contrary to my expectations and to my great disappointment the stats don't seem to have changed at all in the 1.2 update.
    All tables are still accurate.
    I don't have much time atm. So artillery still has to wait, I'm afraid.
    I'll see to it that I update this as soon as time permits.
    Thanks for all the appreciation expressed here.



    R'as

    Singleplayer: Download beta_8
    Multiplayer: Download beta_5.All.in.1
    I'll build a mountain of corpses - Ogami Itto, Lone Wolf & Cub
    Sometimes standing up for your friends means killing a whole lot of people - Sin City, by Frank Miller

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Single Sign On provided by vBSSO