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




+ Log in or register to post
Page 1 of 3 1 2 3 LastLast
Results 1 to 10 of 28
  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 OpenOffice.org 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
    Law's Game Style: Butt-Kicker, Storyteller 92%; Tactician 83%; Power Gamer 50%; Specialist 42%; Casual Gamer, Method Actor 17%

    Sortable 4E Monster Manual index spreadsheet with encounter calculator

 

  • #2
    Thank you withak, very useful file. Also thank you for the open document source files.

  • #3
    Registered User
    The Grand Druid (Lvl 20)

    the Jester's Avatar

    Join Date
    Jan 2002
    Location
    Shingletown, CA 96088
    Posts
    20,672

    Ignore the Jester
    Oooh, cool, I was just thinking how useful something like this would be! Thanks!
    the Jester

    The Monster Project

    Buy my first self-published weird sci-fi novel from Amazon here!

  • #4
    Withak,
    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.
    Thanks

  • #5
    Quote Originally Posted by Darkthorne
    Withak,
    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.
    Thanks
    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.
    Law's Game Style: Butt-Kicker, Storyteller 92%; Tactician 83%; Power Gamer 50%; Specialist 42%; Casual Gamer, Method Actor 17%

    Sortable 4E Monster Manual index spreadsheet with encounter calculator

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

  • #7
    Registered User
    Novice (Lvl 1)



    Join Date
    Feb 2008
    Location
    Orlando, FL
    Posts
    33

    Ignore Dizlag
    withak,

    Very slick spreadsheet! Thanks for doing this!

    Dizlag

  • #8

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

    EvilBlackKitty

  • #10
    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

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

  • + Log in or register to post
    Page 1 of 3 1 2 3 LastLast

    Similar Threads

    1. Replies: 5
      Last Post: Friday, 28th June, 2013, 06:39 PM
    2. 4e Searchable / Sortable Index
      By Siberys in forum House Rules, Homebrews, & Conversion Library
      Replies: 7
      Last Post: Tuesday, 11th September, 2012, 05:11 PM
    3. Encounter calculator spreadsheet
      By withak in forum D&D and Pathfinder
      Replies: 4
      Last Post: Thursday, 12th June, 2008, 05:10 PM
    4. New Black Company Spell Calculator Spreadsheet
      By Henry in forum RPGs & Tabletop Gaming Discussion
      Replies: 6
      Last Post: Friday, 8th April, 2005, 07:11 PM
    5. Encounter Calculator how to
      By TabulaRasa in forum Miscellaneous 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
    •