+ Reply to Thread
Results 1 to 17 of 17

Thread: Complete Unit Spreadsheet For All Roster, Temple, and Non-Faction Buildable Units

  1. #1

    Complete Unit Spreadsheet For All Roster, Temple, and Non-Faction Buildable Units

    Attached are the unit stats for all Human, Monster, Undead and non-faction specific trainable units, compiled by myself through in-game checking, with Fillmore and 208 providing stats for Royal Guardsmen and Dwarven Overcomers. Stats are current as of version 1.1.2.26. File format is .ods, used with Open Office Calc, but I had to put it into a .rar archive for the forum to accept the attachment.

    EDIT: Found a typo. Cutthroats have 33 hit points, not 35. I'll add corrections after I've collected some more good monster/avatar stats.
    Attached Files
    Last edited by Pax Empyrean; 15-05-2012 at 13:45.

  2. #2
    Second Lieutenant PawelS's Avatar

    Join Date
    Jan 2005
    Location
    Poland, EU
    Posts
    130
    Good work! If you want to expand the sheet, the following things can be added:
    • Building(s) needed to produce the unit
    • Units that this unit can be upgraded to, and upgrade cost
    • Summons and non-buildable units

  3. #3
    Building cost are the update cost for a unit. Only advantage is you get alle the XP by updating.

  4. #4
    Second Lieutenant PawelS's Avatar

    Join Date
    Jan 2005
    Location
    Poland, EU
    Posts
    130
    Hmm, IIRC upgrading a Mage to a Magister costs 600 gold, and in the spreadsheet the Magister's cost is 500 gold.

  5. #5
    Quote Originally Posted by PawelS View Post
    Hmm, IIRC upgrading a Mage to a Magister costs 600 gold, and in the spreadsheet the Magister's cost is 500 gold.
    That's correct. For some reason, Magisters cost more to upgrade. They are only 500 gold to build, though.

    Most units cost the same to build and upgrade. I suspect that Magisters were originally priced at 600 gold and were later reduced to 500, and somebody forgot to change the upgrade cost.

  6. #6
    Avatar of Agrela
    Divine Healer

    HP: 1000
    Movement: 3 (Amphibious)


    Attack (Range: 2)
    -Spirit Magic: 50
    -Life Magic: 25
    -Elemental Magic: 25

    Sight Range: 5

    Upkeep: -30 Mana

    Resistance
    -Melee: 75
    -Missile: 75
    -Life Magic: 175
    -Death Magic: 75
    -Spirit Magic: 75
    -Elemental Magic: 75

    Perks
    -Power of Life
    --Damage: +50% Life Magic
    --Damage:+50% Elemental Magic

    -Unhindered
    --Passability: Dense
    --Passability: Poor
    --Passability: Hilly
    --Passability: Dense and Hilly

    -Avatar
    --Resistance: +75 Melee
    --Resistance: +75 Missile
    --Resistance: +75 Life Magic
    --Resistance: +75 Death Magic
    --Resistance: +75 Spirit Magic
    --Resistance: +75 Elemental Magic
    --Regeneration: +50
    --Avatar
    --Can see invisible units
    --Sight range: +2
    --Unit can walk on water
    --Immune to banes

    Abilities
    -Agrela's Divine Touch
    --Heals: 100 Life Magic
    --Range: 4
    --Area of effect: Target plus surrounding hexes
    --Cooldown: 3
    --Restores health to all friendly units in range (except undead and buildings).

    -Agrela's Call
    --Summons: Treewarden
    --Cooldown: 3
    -- Summons a Treewarden to the selected hex

    "Mysterious and unknown -- 'tis the very nature of Avatars of the Gods. But their power is immense!" (From "The Overall Description of Everything" by Master Alfus Bumblegate
    Warlock Techtrees! I didn't make them, but I love them.

  7. #7
    What other avatars do you need stats for? I have access to a few different ones in various saves.

  8. #8
    I've got Krypta in there already, and Satinel posted Agrela. Those are all I've got.

  9. #9
    Avatar of Lunord
    Divine Fighter

    HP: 1000
    Movement: 3 (Flying)

    Attack: 100
    - Melee: 50
    - Death Magic: 25
    - Spirit Magic: 25

    Sight Range: 5

    Upkeep: -30 Mana

    Resistance
    -Melee: 75
    -Missile: 75
    -Life Magic: 175
    -Death Magic: 75
    -Spirit Magic: 75
    -Elemental Magic: 75

    Perks
    -Invisibility
    --Can only be seen from the adjacent hex.

    -Hit and Run
    --Hit and run [This could use a better tooltip. :P It lets the unit move after attacking.]

    -Power of Night
    --Damage: +50% Death Magic
    --Damage: +50% Spirit Magic

    -Unhindered
    --Passability: Dense
    --Passability: Poor
    --Passability: Hilly
    --Passability: Dense and Hilly

    -Avatar
    --Resistance: +75 Melee
    --Resistance: +75 Missile
    --Resistance: +75 Life Magic
    --Resistance: +75 Death Magic
    --Resistance: +75 Spirit Magic
    --Resistance: +75 Elemental Magic
    --Regeneration: +50
    --Avatar
    --Can see invisible units
    --Sight range: +2
    --Unit can walk on water
    --Immune to banes
    Warlock Techtrees! I didn't make them, but I love them.

  10. #10
    Nice work. Spotted an error though.

    Wolves of Helia do not have their cleave ability.

  11. #11
    Second Lieutenant Dragoon.x's Avatar
    Crusader Kings IIEU3 CompleteDivine WindHeir to the ThroneLead and Gold
    Leviathan: WarshipsMagickaSword of the StarsWarlock: Master of the Arcane500k club
    Europa Universalis IV: Pre-orderEUIV: Call to arms eventWarlock 2: The Exiled

    Join Date
    Feb 2011
    Location
    ,Brazil
    Posts
    185
    Can anyone please save the file as XML spreadsheet?

  12. #12
    M.I.A 2Coats's Avatar
    Hoi 2 Beta

    Join Date
    Mar 2003
    Location
    Limbo
    Posts
    10,197
    Quote Originally Posted by Dragoon.x View Post
    Can anyone please save the file as XML spreadsheet?
    Cant you do a google search for "ods to xml converter"
    For God, King and Country - A MARCH OF THE EAGLES AAR
    "That there is one damn fine coat you're wearin'." x2 - Marv, Sin City.


  13. #13
    Second Lieutenant Carlo Curiosus's Avatar
    A Game of DwarvesHearts of Iron 2: ArmageddonCrusader Kings IIEU3 CompleteHearts of Iron III
    MagickaMajesty 2Sword of the Stars IIVictoria 2Mount & Blade: Warband
    Warlock: Master of the Arcane500k clubEuropa Universalis IV

    Join Date
    Feb 2009
    Location
    London, UK
    Posts
    111
    Avatar of Dauros
    Divine Fighter

    HP: 1000
    Movement: 3 (Amphibious)

    Attack: 125
    -Melee: 50
    -Life Magic: 25
    -Spirit Magic: 25
    -Elemental Magic: 25

    Sight Range: 5

    Upkeep: -30 Mana

    Resistance
    -Melee: 75
    -Missile: 75
    -Life Magic: 175
    -Death Magic: 75
    -Spirit Magic: 75
    -Elemental Magic: 75

    Perks
    -Power of Order
    --Damage: +50% Life Magic
    --Damage: +50% Spirit Magic
    --Damage: +50% Elemental Magic

    -Unhindered
    --Passability: Dense
    --Passability: Poor
    --Passability: Hilly
    --Passability: Dense and Hilly

    -Avatar
    --Resistance: +75 Melee
    --Resistance: +75 Missile
    --Resistance: +75 Life Magic
    --Resistance: +75 Death Magic
    --Resistance: +75 Spirit Magic
    --Resistance: +75 Elemental Magic
    --Regeneration: +50
    --Avatar
    --Can see invisible units
    --Sight range: +2
    --Unit can walk on water
    --Immune to banes

    Abilities
    -Dauros Total Immunity
    --Heals: 50 Life Magic
    --Blessing: Protection of Order
    --Cooldown: 4
    -- Increases the caster's resistance to all types of damage

  14. #14
    Second Lieutenant Dragoon.x's Avatar
    Crusader Kings IIEU3 CompleteDivine WindHeir to the ThroneLead and Gold
    Leviathan: WarshipsMagickaSword of the StarsWarlock: Master of the Arcane500k club
    Europa Universalis IV: Pre-orderEUIV: Call to arms eventWarlock 2: The Exiled

    Join Date
    Feb 2011
    Location
    ,Brazil
    Posts
    185
    Quote Originally Posted by 2Coats View Post
    Cant you do a google search for "ods to xml converter"
    No, smart ass I would generally prefer a n office open file format instead of a app limited one.

  15. #15
    M.I.A 2Coats's Avatar
    Hoi 2 Beta

    Join Date
    Mar 2003
    Location
    Limbo
    Posts
    10,197
    Quote Originally Posted by Dragoon.x View Post
    No, smart ass I would generally prefer a n office open file format instead of a app limited one.
    My we're touchy.... Ah I see you're from Brazil!

    Best I can do is a csv. Good enough?

    Warlock UnitsCSV.rar
    For God, King and Country - A MARCH OF THE EAGLES AAR
    "That there is one damn fine coat you're wearin'." x2 - Marv, Sin City.


  16. #16
    Avatar of Helia
    Divine magic caster

    HP: 1000
    Movement: 3 (Flying)

    Attack: 125
    - Elemental: 75
    - Missile: 25
    - Life Magic: 25

    Sight Range: 5

    Upkeep: -30 Mana

    Resistance
    -Melee: 75
    -Missile: 75
    -Life Magic: 175
    -Death Magic: 75
    -Spirit Magic: 75
    -Elemental Magic: 75

    Perks
    -Power of Sun
    --Damage: +50% Missile
    --Damage: +50% Elemental Magic
    --Damage: +50% Life Magic

    -Unhindered
    --Passability: Dense
    --Passability: Poor
    --Passability: Hilly
    --Passability: Dense and Hilly

    -Avatar
    --Resistance: +75 Melee
    --Resistance: +75 Missile
    --Resistance: +75 Life Magic
    --Resistance: +75 Death Magic
    --Resistance: +75 Spirit Magic
    --Resistance: +75 Elemental Magic
    --Regeneration: +50
    --Avatar
    --Can see invisible units
    --Sight range: +2
    --Unit can walk on water
    --Immune to banes

    Abilities
    -Sunburst of Helia
    --Damage: 125 Elemental Magic
    --Range: 3
    --Area of effect: target plus the surrounding hexes
    --Cooldown: 3
    --Inflicts elemental damage to all units in range.
    Warlock Techtrees! I didn't make them, but I love them.

  17. #17
    Avatar of Grum-Gog
    Divine archer

    HP: 1000
    Movement: 3 (Amphibious)

    Attack: 125 (Range 3)
    - Missile: 50
    - Death Magic: 25
    - Spirit Magic: 25
    - Elemental Magic: 25

    Sight Range: 5

    Upkeep: -30 Mana

    Resistance
    -Melee: 75
    -Missile: 75
    -Life Magic: 175
    -Death Magic: 75
    -Spirit Magic: 75
    -Elemental Magic: 75

    Perks
    -Power of Plague
    --Damage: +50% Death Magic
    --Damage: +50% Spirit Magic
    --Damage: +50% Elemental Magic

    -Unhindered
    --Passability: Dense
    --Passability: Poor
    --Passability: Hilly
    --Passability: Dense and Hilly

    -Avatar
    --Resistance: +75 Melee
    --Resistance: +75 Missile
    --Resistance: +75 Life Magic
    --Resistance: +75 Death Magic
    --Resistance: +75 Spirit Magic
    --Resistance: +75 Elemental Magic
    --Regeneration: +50
    --Avatar
    --Can see invisible units
    --Sight range: +2
    --Unit can walk on water
    --Immune to banes

    Abilities
    -Grum-Gog Summon
    --Summons: Champions of Grum-Gog

    --Cooldown: 3
    --Summons a unit of Champions of Grum-Gog to the selected hex.

    In addition to this his attacks are area of effect, I'm not sure of the shape but it can hit at least three targets at once. He also causes the Rat's Plague bane on anything he attacks. AND he dual wields gatling crossbows.
    Warlock Techtrees! I didn't make them, but I love them.

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts