Latest Diablo 3 News
DiabloWiki Updates
Results 1 to 7 of 7
  1. #1
    IncGamers Member
    Join Date
    Jan 2008
    Location
    Amazon Basin
    Posts
    1,041

    Monster Resistances.xls

    I've created a new Microsoft Excel worksheet listing monster resistances and immunities in Hell Acts 1-5, which allows you to filter the data and calculate hit points with varying number of players and different monster classes.

    Unfortunately it doesn't list resistances and immunities for the Diablo clone and the Pandemonium Event, since these are exclusively on-line and I'd be unable to verify them. The worksheet hasn't been protected since doing so doesn't allow the filter to be used. If anybody has any questions or comes across any errors, let me know. A more advanced Excel user could certainly do better, but it gets the job done and it should be reasonably easy to use. Below are a few notes on certain aspects of the worksheet.

    Class
    Monsters can be Normal, Minion, (Super) Unique, Champion (includes Fanatic and Ghostly), Berserker, Possessed and Boss. Clicking on the cell above the Class column will allow you to select different classes from a drop-down list, changing the class of all applicable monsters listed below. Hit points will be recalculated accordingly.

    Note that I haven't taken into account the random Unique or Champion monsters that can be spawned by Monster Shrines due to both the rarity of these shrines and my lack of understanding of their mechanics. It seems as though they'll transform the nearest normal monster into a Unique (without minions) or a Champion, but I don't know how the game selects shrines and in which areas they won't spawn.

    This should only be an issue with dependent monsters (e.g. Fallen) or monsters whose spawning is determined by location on the map (e.g. Fallen encampments) rather than Levels.txt. If need be, complete the final stage of the calculations using the following multipliers, and round down:

    Code:
    HELL   MINION   UNIQUE   CHAMPION   BERSERKER   POSSESSED
    _________________________________________________________
    HP      * 1.5    * 2.0      * 2.0       * 0.5       * 4.0
    Players
    Click on the number of players and select 1-8 from the drop-down list to automatically recalculate the hit-points listed in the Min and Max HP columns below.

    Filter
    Click on the arrows in the bottom right-hand corner of the column headings and select from the drop-down list to filter the data below. Some examples:

    • To list all monsters in Act 5, click on the Act arrow and select 5.
    • To list all monsters in level 85 areas, click on the Level arrow and select 85.
    • To list all Immune to Poison monsters, click on the PR % arrow and select (Custom...), then select is greater than or equal to, and input 100.

    Perform all three consecutively and you have a list of all Immune to Poison monsters in level 85 areas of Act 5.

    Monster
    Monsters in bold can spawn independently, while those that are dependent on others (spawn or minions) are not in bold. For example, Fallen will only spawn if a Fallen Shaman spawns, but Fallen can spawn independently. Dependent monsters will be listed below the monster upon which they depend.

    Super Unique and Boss monsters (with the exception of Putrid Defilers) and their minions are highlighted in gold. Their set modifiers (some of which are abbreviated) are listed below their names. When they have no set modifiers but acquire random ones in Nightmare and Hell, their names will be aligned with the top of the cell rather than centered.

    Curse
    The Curse column tells you whether or not the monster can be cursed, which will determine whether Amplify Damage, Decrepify or Lower Resist can be used to lower Resist % or break immunities. Selecting Possessed above the Class column will automatically change the entry in this column to No, where applicable.


    To the best of my knowledge, Conviction applies to every enemy, even if the aura isn't displayed beneath it when it's within range, with the sole exception of an Aura Enchanted (Super) Unique or Boss with higher level Conviction. In Acts 1-5 level 11 Conviction is the highest (Nihlathak and (Super) Unique monsters in level 85+ areas), while in the Pandemonium Event Mephisto has level 20.

    UPDATE 24 DECEMBER 2012 Since the attached file can no longer be viewed, download it using one of the following links:

    Those who do not have Microsoft Office can still access this spreadsheet by downloading OpenOffice for free.
    Last edited by onderduiker; 24-12-2012 at 09:53.

  2. #2
    IncGamers Member stephan's Avatar
    Join Date
    Nov 2006
    Posts
    6,163

    Re: Monster Resistances.xls

    bleh. wrong topic




  3. #3
    IncGamers Member
    Join Date
    Mar 2009
    Location
    Australia
    Posts
    268

    Re: Monster Resistances.xls

    Fantastically helpful. Thanks for the file



  4. #4
    IncGamers Member
    Join Date
    Jun 2008
    Posts
    206

    Re: Monster Resistances.xls

    thank you. This is extremely helpful!



  5. #5
    IncGamers Member
    Join Date
    Jul 2006
    Location
    Norway
    Posts
    1,162

    Re: Monster Resistances.xls

    Very nice; thank you!




  6. #6
    IncGamers Member
    Join Date
    May 2010
    Posts
    37

    Re: Monster Resistances.xls

    I can't see the Excel file. :-(

  7. #7
    IncGamers Member
    Join Date
    Jan 2008
    Location
    Amazon Basin
    Posts
    1,041

    Re: Monster Resistances.xls

    Since the attached file can no longer be viewed, it can be downloaded using one of the following links:

    Those who do not have Microsoft Office can still access this spreadsheet by downloading OpenOffice for free.

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
  •