+ 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
    136
    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
    136
    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
    Sergeant Dragoon.x's Avatar
    EU3 CompleteHeir to the ThroneLead and GoldDivine WindMagicka
    Sword of the StarsWarlock: Master of the ArcaneLeviathan: Warships

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

  12. #12
    Monolith Moderator 2Coats's Avatar
    Hoi2 Beta MemberEU3 Collectors Edition OwnerHoI AnthologyGalactic AssaulterNapoleonic Marshal
    Deus Vult!Europa Universalis: RomePenumbra -  Black PlagueHearts of Iron 2: ArmageddonEuropa Universalis III: In Nomine
    Rome: Vae VictisSupreme Ruler 2020Hearts of Iron IIIMajesty 2Victoria 2 Beta
    Mount & Blade: WarbandLegioSemper FiElven Legacy CollectionLionheart
    Divine WindMagickaCities in MotionSword of the StarsCrusader Kings II
    Pirates of Black CovePride of NationsFor the MotherlandSupreme Ruler: Cold WarSengoku
    Sword of the Stars IIKing Arthur IICrusader Kings II Holy KnightNaval War: Arctic CircleWarlock: Master of the Arcane
    HOI3: Their Finest HourMarch of the EaglesImpire

    Join Date
    Mar 2003
    Location
    The Moon
    Posts
    10,026
    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.

    If you see me writing in this my moderator colour then don't reply to that post, PM me instead. | Forum Rules

  13. #13
    Sergeant Carlo Curiosus's Avatar
    Hearts of Iron 2: ArmageddonEU3 CompleteHearts of Iron IIIMajesty 2Heir to the Throne
    Mount & Blade: WarbandSemper FiDivine WindMagickaCrusader Kings II
    Mount & Blade: With Fire and SwordFor the MotherlandWarlock: Master of the Arcane

    Join Date
    Feb 2009
    Location
    London, UK
    Posts
    87
    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
    Sergeant Dragoon.x's Avatar
    EU3 CompleteHeir to the ThroneLead and GoldDivine WindMagicka
    Sword of the StarsWarlock: Master of the ArcaneLeviathan: Warships

    Join Date
    Feb 2011
    Location
    ,Brazil
    Posts
    93
    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
    Monolith Moderator 2Coats's Avatar
    Hoi2 Beta MemberEU3 Collectors Edition OwnerHoI AnthologyGalactic AssaulterNapoleonic Marshal
    Deus Vult!Europa Universalis: RomePenumbra -  Black PlagueHearts of Iron 2: ArmageddonEuropa Universalis III: In Nomine
    Rome: Vae VictisSupreme Ruler 2020Hearts of Iron IIIMajesty 2Victoria 2 Beta
    Mount & Blade: WarbandLegioSemper FiElven Legacy CollectionLionheart
    Divine WindMagickaCities in MotionSword of the StarsCrusader Kings II
    Pirates of Black CovePride of NationsFor the MotherlandSupreme Ruler: Cold WarSengoku
    Sword of the Stars IIKing Arthur IICrusader Kings II Holy KnightNaval War: Arctic CircleWarlock: Master of the Arcane
    HOI3: Their Finest HourMarch of the EaglesImpire

    Join Date
    Mar 2003
    Location
    The Moon
    Posts
    10,026
    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.

    If you see me writing in this my moderator colour then don't reply to that post, PM me instead. | Forum Rules

  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