Advanced Search >

Dungeon Master Excel Toolkit

Dungeon Master Excel Toolkit

ZIP File
Suggested Price $2.45

All three files have been updated! Guildmaster's Guide to Ravnica info has been added to the files as well as bug fixes and new features. See individual update notes for more info.

Encounter Builder 2.7

  • Simplified UI
    • Plain grey color scheme allows the color to really pop and grab your attention for quick browsing of information
  • Character Management
    • Handles up to 10 players
    • Automatic calculations of carrying capacity and push/drag/lift limits, as well as other commonly used information, are present for easy PC management.
  • Powerful encounter manager
    • Automates creature health randomization according to MM health rolling rules
    • Pages for encounter building using the rules from the DMG and XGE
  • Initiative Tracker
    • Automatically sorting initiative order tracker
    • Automatically roll creature initiatives with a button push
    • Detects creature health and factors that when rolling initiatives
  • Includes basic monster information for all WoTC monsters
    • If you find a monster I missed or misnamed, or an error please let me know!
    • You are able to add homebrew monsters to the monster library manually
  • Quick Reference search windows
    • Using Excel's Userform interface allows for easy search
      • Status Effects
      • Magic Items
      • Mundane Items
      • Chance Encounters
        • Many encounters courtesy of Ivan Cannon
      • Spell Lookup
      • Light, Weather, and hazardous terrain look up
    • Allows for random choices of all items, and chance encounters
    • Hotkey Enabled
      • Ctrl + l to open window
NPC Generator 2.6
  • Random
    • Name generator using XGE (In Progress)
    • Race randomization based on demographic percentages
    • Sex
    • Occupation
    • Chooses history based on DMG rules
    • Appearance generator using a custom algorithm
      • Currently does not properly support races with scales or feathers
      • Generates in either prose, simplified prose, or list format
    • High and low abilities
    • Talent
    • Mannerism
    • Interactions with others
    • Useful Knowlege
    • Ideal
    • Bond
    • Flaw or Secret
    • Stat Block
  • Location storage
  • All options can be overridden by the user with the generator filling in the gaps
  • Can save NPCs for future reference
Character Builder 2.3
  • Includes basic race and class info
  • Gives race and class matchups based on modifiers
  • This is a good starting point, but this should not be used in place of the book info.
 More from this Title's Contributors
 Customers Who Bought this Title also Purchased
Reviews (3)
Discussions (7)
Customer avatar
Tyler B February 19, 2019 9:33 pm UTC
Would it be possible for you to publish a short 'How to' video on utilizing all the awesome features of the Toolkit? (Specifically the Encounter Builder) I love what you've done here, but I feel I could get more out of the toolkit if I properly knew how to use it but I'm not super Excel savvy.
Customer avatar
Lincoln S February 20, 2019 10:08 pm UTC
I'm glad you like it!

I never thought about that... Ummmmmm... maybe? It'll be awhile before I get around to it, but now that you've suggested it it's on my radar!

For now, do you have any specific questions that I could answer? I really try to make it as intuitive as possible.
Customer avatar
Cody L December 04, 2018 2:40 am UTC
So i have been using this alot since i purchased it, however I just moved to a Mac laptop and apparently rowsource does not work on macs so the encounter sheet is unusable on Macs.. any plans to make a compatible version? I've been trying desperately to alter the code to allow it to work on my mac but three days in and I have been unable to get it to work
Customer avatar
Lincoln S December 05, 2018 7:13 pm UTC
Oh jeez! I had no idea! Let me look into it. Which aspects aren't working? That should only effect a couple of user forms, which ones are failing?
Customer avatar
Werner S January 26, 2019 9:10 am UTC
VBA on OS X misses functionality that is available on Windows, but fortunately there is an easy work-around for the RowSource() problem. Simply explicitly set the List property of the control to the named range using the Range() function. For example

LstEncounters.RowSource = "SavedEncounters"

LstEncounters.List = Range("SavedEncounters").Value
Customer avatar
Lincoln S February 04, 2019 12:34 am UTC
Thanks! I'll fix this in the next version. I want it to be as universally compatible as possible.
Customer avatar
Sebastian W October 19, 2018 5:50 pm UTC
Hey! I'm in love with this tool, but! I am having a huge problem. When i hit the View/Load Button on the Encounter Builder it gives me an error code 80020005, and something with ColumnWidth.

In VBA, when i try to debug it shows that something is wrong with this string:

Public Sub PullLoadView()
End Sub

Where string number 2 ( EncounterBrowser.Show) is highlighted :)
Customer avatar
Lincoln S October 26, 2018 4:25 am UTC
I'm glad you like it!!! I worked hard to make it decent!

Thanks for all the info. Have you saved any other encounters? Hopefully I can have this fixed by the next release!
Customer avatar
Louis R January 27, 2019 1:51 pm UTC
Hey there ! Had the same problem but the solution is quite easy. Just change your Excel language settings to English (if it's not the case already). Apparently it messes up with the column width if you don't use the same parameters as those used for the creation of the document. It fixed it for me ! Hope it works for you ^^
Customer avatar
Lincoln S February 04, 2019 12:33 am UTC
Thanks for investigating this, and thanks for posting it here!
Customer avatar
Jared D October 11, 2018 5:31 am UTC
This looks like it took a lot of work. Great job!

I do have some issues though with the Encounter Builder 2.5.1 sheet.

1. In the Encounter Builder tab it is very difficult to find the monster you want to select. You have to click the arrow to scroll through them manually. Scrolling causes it to jump down, and you cannot type in the monster name and have it auto-complete. In addition, whenever you select a monster, it shows N/A for CR level.

2. In the Readied Encounter tab it accurately pulls out the CR level like it should on the Encounter Builder tab. However, B2, the Difficulty cell, gives an invalid name error and doesn't show the difficulty rating. That same Invalid Name Error pops up in H15 on the Encounter Builder tab.

3. In the Player Manager tab you have an Invalid Name error on the cells that are supposed to show Exp Until Level Up.
Customer avatar
Lincoln S October 17, 2018 9:33 pm UTC
Oh jeez! I will get right on fixing those bugs. Thanks for letting me know!

Unfortunately, there's not a ton that I can do for the drop-down thing due to excel limitations, though I will take another look and see if I can't find a better solution.
Customer avatar
Lincoln S October 17, 2018 9:47 pm UTC
Jared, What monster are you selecting that is causing the error? Also, you may want to try redownloading the file because I am not seeing the player-manager tab but at all. I will be publishing a 2.5.2 version with more bug fixes soon, but I want to make sure that the bugs that you are seeing have been addressed first.
Customer avatar
Ezra H October 04, 2018 3:54 am UTC
Does this have to be used through Excel? I'm using a different program that can run the file and some of the cells appear to be calling on things that don't exist and it's causing errors. For example despite putting in a character's Dex the Initiative modifier cell doesn't update.
EDIT: It seems to be an issue with trying to call upon formulas that were not downloaded with the file
Customer avatar
Lincoln S October 04, 2018 8:21 pm UTC
I built it using Excel 2016 and haven't tested it with any other programs. It relies very heavily on custom VBA formulas so if the program can't run vba the whole sheet will fall apart. What is the program you are using? I can always look into it.

Also, make sure your sheet is set to automatically calculate rather than manually calculate.
Customer avatar
Cody L October 03, 2018 9:28 pm UTC
The award EXP button keeps throwing a runtime error 9 subscript out of range.
Debugger is identifying this line "If CDbl(splitit(1)) >= 5 Then"
Customer avatar
Lincoln S October 04, 2018 8:27 pm UTC
Fixed! It was an error with my custom rounding function that would break if the exp value was already a whole number. Try it in version 2.5.1.

Thanks for reporting the bug! I appreciate it.
Customer avatar
Paul H September 08, 2017 4:00 am UTC
The "Active" Cell on the Player's tab doesn't work. Drop down list doesn't pull up and when your right click to force the list, the choices don't make any sense. I would think it would be "Yes/No" but it pulls up a bunch of random seeming stuff, including the players name. Concentration and Shield cells also doesn't seem to work properly. This is great looking product but there are a couple of initial bugs.
Customer avatar
Lincoln S September 27, 2017 11:27 pm UTC
Thanks for the feedback! I will fix this in the next rev!
Customer avatar
Lincoln S September 29, 2017 5:18 am UTC
Updated! The issues are hopefully fixed!
Narrow Results
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!
 Recent History

Product Information
Silver seller
Community Content
Rules Edition(s)
Original electronic
Scanned image
These products were created by scanning an original printed edition. Most older books are in scanned image format because original digital layout files never existed or were no longer available from the publisher.

For PDF download editions, each page has been run through Optical Character Recognition (OCR) software to attempt to decipher the printed text. The result of this OCR process is placed invisibly behind the picture of each scanned page, to allow for text searching. However, any text in a given book set on a graphical background or in handwritten fonts would most likely not be picked up by the OCR software, and is therefore not searchable. Also, a few larger books may be resampled to fit into the system, and may not have this searchable text background.

For printed books, we have performed high-resolution scans of an original hardcopy of the book. We essentially digitally re-master the book. Unfortunately, the resulting quality of these books is not as high. It's the problem of making a copy of a copy. The text is fine for reading, but illustration work starts to run dark, pixellating and/or losing shades of grey. Moiré patterns may develop in photos. We mark clearly which print titles come from scanned image books so that you can make an informed purchase decision about the quality of what you will receive.
Original electronic format
These ebooks were created from the original electronic layout files, and therefore are fully text searchable. Also, their file size tends to be smaller than scanned image books. Most newer books are in the original electronic format. Both download and print editions of such books should be high quality.
File Last Updated:
February 15, 2019
This title was added to our catalog on September 07, 2017.