Sortable Monster Manual index spreadsheet with built-in encounter calculator -- v1.2
Page 1 of 3 123 LastLast
Results 1 to 10 of 29
  1. #1

    Sortable Monster Manual index spreadsheet with built-in encounter calculator -- v1.2

    This spreadsheet will make finding the right monster for your encounter a snap! Sort by name, level, role, size, origin, type, keywords, and even Monster Manual entry and page number.

    Sorting instructions: On the Monsters tab, select columns A through AO and choose "Data -- Sort...". To sort by level and then by monster name, choose Level and Monster from the drop-down lists. The "default" sort order is MM Entry, Page, Monster.

    The spreadsheet contains many hidden columns which are aggregated into others for easier display. For example, the Elite, Solo, Basic Role, and Leader columns are aggregated into the Role column. These hidden columns are still usable for sorting, however. For example, if you want to sort by monster size, choose Size. The Size column will remain hidden, but the Size, Origin, Type, Keywords, Race column will show the sorted order.

    The Elite, Solo, Leader, and various keyword columns actually contain binary values (0 or 1) so to sort on these columns, you will want to select "Descending" in the sort dialog box to get the 1s to show up at the top of the list.

    New in v1.1 is a built-in encounter calculator. On the Encounter Calculator tab, enter party level and size, desired encounter level, and select monsters from the drop-down lists. (The sort order of the drop-downs will reflect the sort order on the Monsters tab.) Indicate how many of each monster you want, and adjust as needed to get the right mix.

    The blue "Custom" fields will allow you to enter custom monsters, NPCs, traps, hazards, and obstacles. Indicate the level, etc. of these custom entries just as you would the standard monsters.

    The Encounter Difficulty and the advice that occasionally pops up in the Notes column is based off of my interpretation of the "Step-by-Step Encounters" sidebar on DMG p. 56. My interpretation may well be wrong, as the text for that is a bit on the fuzzy side.

    The Estimated Encounter Level figures out by how much the budget for the next-lowest encounter level was exceeded, and adjusts it by a proportional fraction.

    v1.2 now available. Changes:
    Pseudodragons are now Small instead of Tiny, per WotC errata
    Monster type dropdowns fixed
    Automatic alphabetical sort of monster names in dropdowns fixed
    Notes column restored
    Various minor fixes and error-handling

    This spreadsheet was created in 2.4 and exported to Excel 97/2000/XP format. Both formats are available.
    Attached Files Attached Files
    Last edited by withak; Friday, 13th June, 2008 at 12:40 AM. Reason: v1.2

  2. #2
    Myrmidon (Lvl 10)

    Join Date
    Jul 2007
    Anaheim, CA
    Thank you withak, very useful file. Also thank you for the open document source files.

  3. #3
    Greater Elemental (Lvl 23)

    the Jester's Avatar

    Join Date
    Jan 2002
    Shingletown, CA 96088
    Oooh, cool, I was just thinking how useful something like this would be! Thanks!

  4. #4
    Would you mind if I tweaked this to build a monster encounter form? (based off of # of players & ave party level?) And I'll repost it here.

  5. #5
    Quote Originally Posted by Darkthorne
    Would you mind if I tweaked this to build a monster encounter form? (based off of # of players & ave party level?) And I'll repost it here.
    I put together a quick encounter calculator (here) and my next move was going to be to combine the two. You're welcome to do whatever you like with either sheet.

  6. #6
    Sweet, Thanks. I'll see what I can cobble together

  7. #7
    Novice (Lvl 1)

    Join Date
    Feb 2008
    Orlando, FL

    Very slick spreadsheet! Thanks for doing this!


  8. #8
    Myrmidon (Lvl 10)

    Roger's Avatar

    Join Date
    Mar 2004
    This is super-Elite. Thanks.


  9. #9
    Thanks Withak! Now I have a handy list of monsters I can use to munch on your Weezard.


  10. #10
    Minor Trickster (Lvl 4)

    Join Date
    Aug 2002
    Hi all...

    I've added a column from the other excel sheet that had the XP on it to this spreadsheet.

    I fixed all of the names in the other, so all the xp should be correct.

    I don't have Open Office.

    I've renamed the file version as 1.1

    Attached Files Attached Files
    Last edited by Aluvial; Wednesday, 11th June, 2008 at 08:22 PM.

Quick Reply Quick Reply

Similar Threads

  1. Need a program/spreadsheet/calculator/something to build custom 3.5 monsters from scratch
    By BoxCrayonTales in forum Character Builds & Optimization
    Replies: 5
    Last Post: Friday, 28th June, 2013, 06:39 PM
  2. 4e Searchable / Sortable Index
    By Siberys in forum *Dungeons & Dragons
    Replies: 7
    Last Post: Tuesday, 11th September, 2012, 05:11 PM
  3. Encounter calculator spreadsheet
    By withak in forum *Pathfinder & Starfinder
    Replies: 4
    Last Post: Thursday, 12th June, 2008, 05:10 PM
  4. New Black Company Spell Calculator Spreadsheet
    By Henry in forum *General Roleplaying Games Discussion
    Replies: 6
    Last Post: Friday, 8th April, 2005, 07:11 PM
  5. Encounter Calculator how to
    By TabulaRasa in forum *Varied Geek Talk & Media Lounge
    Replies: 2
    Last Post: Tuesday, 27th August, 2002, 01:24 PM

Posting Permissions

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