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

withak

Visitor
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:
:1: Pseudodragons are now Small instead of Tiny, per WotC errata
:2: Monster type dropdowns fixed
:3: Automatic alphabetical sort of monster names in dropdowns fixed
:4: Notes column restored
:5: 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.
 

Attachments

Last edited:

Darkthorne

Visitor
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
 

withak

Visitor
Darkthorne said:
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. :cool:
 

Aluvial

Explorer
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
 

Attachments

Last edited:

withak

Visitor
v1.1 has been uploaded. I have integrated the encounter calculator into the index. Feedback is much appreciated. :D
 
This is a great database, but I think that I came into this conversation a little late. I have been working on a modification of this database in another thread. That thread had an encounter calculator, and while there are some interesting ideas here that I might have to steal, the sorting function I wrote for the other thread works a little slicker than this one in my opinion. I like the idea of encounter notes from your file, but there were none that I could find. You should play with what we have done with this database in this thread.

http://www.enworld.org/showthread.php?p=4287910#post4287910

Then you might like to modify it again. Collaborative work is super fun, and we often get back something way better than we originally thought we would. I would like to see what becomes of my mod of someone elses mod of your file.
 

withak

Visitor
PrecociousApprentice said:
This is a great database, but I think that I came into this conversation a little late. I have been working on a modification of this database in another thread. That thread had an encounter calculator, and while there are some interesting ideas here that I might have to steal, the sorting function I wrote for the other thread works a little slicker than this one in my opinion. I like the idea of encounter notes from your file, but there were none that I could find. You should play with what we have done with this database in this thread.

http://www.enworld.org/showthread.php?p=4287910#post4287910

Then you might like to modify it again. Collaborative work is super fun, and we often get back something way better than we originally thought we would. I would like to see what becomes of my mod of someone elses mod of your file.
Unfortunately, your mod removes quite a bit of functionality from the original spreadsheet, namely the ability to sort on the hidden columns. For example, I can't sort on Size, or Origin, or the presence of various keywords.

Text should show up in the "Notes" fields when monsters are selected that are either far too easy or far too hard for the calculated encounter level. I might have messed up some of the logic there.
 
I agree that the database that I modified had less functionality, I just like the way I went about the sorting problem for the encounter calculator better. That is why I posted back here so that maybe what I wrote would get integrated with the original without me having to do it. I am lazy after all. :)
 

withak

Visitor
PrecociousApprentice said:
I agree that the database that I modified had less functionality, I just like the way I went about the sorting problem for the encounter calculator better. That is why I posted back here so that maybe what I wrote would get integrated with the original without me having to do it. I am lazy after all. :)
Okay, now I get what you're saying. ;) If I have time, I'll work your sorting mechanism back into mine to see how I like it.
 

withak

Visitor
It figures this would happen. The spreadsheet gets featured on the main page, and then I find all sorts of problems...

I inadvertently deleted the formulae that are supposed to be in the "Notes" column on the Encounter Calculator. These are supposed to tell you when you have a monster that's way too easy or way too hard for the encounter level you have selected.

In the ODS version, the monster drop-downs will not reflect the sorted order on the Monsters tab, as advertised; this is because the "sort choices in ascending order" option is checked in the Data -- Validity dialog box. (Not sure of the exact wording, but that's the gist of it.) A quick fix is to select all of the monster name dropdown cells and uncheck that box. (The XLS version will not have this problem, because Excel does not have this particular feature.)

Also, Wizards has released errata (already! amazing) for the core books. The only change needed to the database is that Pseudodragon should be Small, not Tiny.

All of these changes will show up in the next version.
 

withak

Visitor
Yay, yet more problems... :( Thanks, Malefax, for pointing out the latest one: monsters besides the first one always show up as Standard.

I'll upload a new, fixed version as soon as I can.
 

Advertisement

Top