+ 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 CompleteDivine WindHeir to the ThroneLead and GoldLeviathan: Warships
    MagickaSword of the StarsWarlock: Master of the Arcane

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

  12. #12
    Monolith Moderator 2Coats's Avatar
    HoI AnthologyHearts of Iron 2: ArmageddonCities in MotionCrusader Kings IIDeus Vult
    Elven Legacy CollectionDivine WindFor the MotherlandGalactic AssaultHearts of Iron III
    HOI3: Their Finest HourImpireEuropa Universalis III: In NomineKing Arthur IILegio
    The Kings CrusadeMagickaMajesty 2March of the EaglesEU3 Napoleon's Ambition
    Naval War: Arctic CirclePenumbra - Black PlaguePirates of Black CoveEuropa Universalis: RomeSemper Fi
    SengokuSword of the StarsSword of the Stars IISupreme Ruler: Cold WarSupreme Ruler 2020
    Rome: Vae VictisMount & Blade: WarbandWarlock: Master of the Arcane

    Join Date
    Mar 2003
    Location
    The Moon
    Posts
    10,092
    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"
    DarkDays: Rise of The Old Gods - A CK2: THE OLD GODS Gameplay AAR
    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: ArmageddonCrusader Kings IIEU3 CompleteDivine WindFor the Motherland
    Hearts of Iron IIIHOI3: Their Finest HourHeir to the ThroneMagickaMajesty 2
    Semper FiMount & Blade: WarbandWarlock: Master of the ArcaneMount & Blade: With Fire and Sword

    Join Date
    Feb 2009
    Location
    London, UK
    Posts
    97
    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 CompleteDivine WindHeir to the ThroneLead and GoldLeviathan: Warships
    MagickaSword of the StarsWarlock: Master of the Arcane

    Join Date
    Feb 2011
    Location
    ,Brazil
    Posts
    94
    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
    HoI AnthologyHearts of Iron 2: ArmageddonCities in MotionCrusader Kings IIDeus Vult
    Elven Legacy CollectionDivine WindFor the MotherlandGalactic AssaultHearts of Iron III
    HOI3: Their Finest HourImpireEuropa Universalis III: In NomineKing Arthur IILegio
    The Kings CrusadeMagickaMajesty 2March of the EaglesEU3 Napoleon's Ambition
    Naval War: Arctic CirclePenumbra - Black PlaguePirates of Black CoveEuropa Universalis: RomeSemper Fi
    SengokuSword of the StarsSword of the Stars IISupreme Ruler: Cold WarSupreme Ruler 2020
    Rome: Vae VictisMount & Blade: WarbandWarlock: Master of the Arcane

    Join Date
    Mar 2003
    Location
    The Moon
    Posts
    10,092
    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
    DarkDays: Rise of The Old Gods - A CK2: THE OLD GODS Gameplay AAR
    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