Advanced Search

Dungeon Master Excel Toolkit

Dungeon Master Excel Toolkit

ZIP File
Suggested Price $2.45

COMPLETE RE-CODE OF THE NPC GENERATOR! Holy crud folks, if you liked the old one this update (in my humble opinion) will blow your socks off. I redid it from the ground up with two things in mind: make the descriptions organic and ready to read to the player, as well as make it run quickly and efficiently.

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 3.0
  • Random
    • Name generator using XGE and other sources
    • Race randomization based on demographic percentages
    • Gender
    • Weighted Occupation
    • Appearance generator using a custom algorithm
      • Supports all races with unique descriptions
    • Talents
    • Mannerisms
    • Interactions with others
    • Ideal
    • Flaws or Secrets
  • Location storage
  • Can save NPCs for future reference
  • The descriptions are generated ready to read to players and only has the information that you need!
  • Everything is customizable if you dive into the data sheets, or you can use as it is!
  • In version 3.0 I finally gave the generator the attention it needed.
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 (5)
Discussions (11)
Customer avatar
Michael F May 20, 2019 12:56 am UTC
This is just amazing work. I know very little about excel capabilities and coding. I have attempted to use this on excel with my tablet but it appears Microsoft do not allow the use of VBA functions in excel on Android or IOS devices.
Is there any alternative program that would allow the spreadsheet to function as intended in its current state on android devices?
Customer avatar
Baelin D April 16, 2019 12:07 am UTC
First off, I want to say that this is AMAZING. I essentially work in Excel full-time for my job and this spreadsheet is a work of art.

I'm encountering an odd bug when I attempt to edit data in the sheet. The excel program on my laptop crashes (2018 laptop, i7 8th gen processor, Win 10) every time I attempt to save the file after editing it. I have no clue what's causing this issue, and have tried clearing out some of the formatting and deleting unnecessary images or macros to try and trim down the sheet (even though it physically pains me to alter any aspect of this glorious project).

Any suggestions regarding fixing this crashing issue?
Customer avatar
Lincoln S April 18, 2019 2:31 pm UTC
Yeah, so which sheet are you trying to alter? What version of Excel are you using? Is it when you alter specific data, or any data? Does it save successfully when you don't change anything? Which version of the sheet are you using? Have you tried re-downloading?

I can try my best to help!
Customer avatar
Rob. G March 30, 2019 2:00 pm UTC
Very good work. As a suggestion, I could recommend some things for the Initiavite Tracker sheet (Encounter Builder).

Maybe you could implement a little square of rounds counter on that sheet, with 2 buttons (to add or subtract 1 each time you click), you have space under the Players cell. Maybe another little square of time counter below to add hours and minutes with buttons (this would make it easy to control the DM a record of how many hours have passed and what time of the day they are ... the DM according to the event that is being completed can be adding or substracting minutes or hours, and so you can control better when controlling the duration of the spells of the players)

Next to the "Order" cell, you could put another cell with the name maybe "Monster Tracker hp" ..... with 4 squares "Name", "Total hp", "Current hp" and "Injuries" for example. In the box of Injuries you could put a function of autosum (each time you...See more
Customer avatar
Lincoln S April 03, 2019 7:37 pm UTC
Thanks a million for the feedback! I wish I could get feedback from all of my users!

To address some of the comments:

Concerning passive perception: YES! That's actually a bug! I'll fix it in the next rev.

As for STR, DEX Proficiency bonus, Height, etc: I leave those in because I play with a lot of newbies so I don't want to be constantly asking them what their carry capacity, AC, etc. But also because i like to reference stuff like height, weight, or the type of armor they're wearing for when i'm describing a short hallway, or if the players need you lift another PC, or what have you.

If you want to get rid of stuff just go to view>Show headers>highlight the rows you want hidden>right click>hide. With that said, I think in the next rev I'll make a menu to select what information you want shown on the player handler. Good feedback!

It might be a bit though, because I am working on a 3.0 version of the NPC generator right now and I recently...See more
Customer avatar
Ronald P March 28, 2019 3:02 pm UTC
Is there a way to add homebrew creations to the encounter builder?
Customer avatar
Lincoln S April 03, 2019 7:14 pm UTC
Yes! You can just add more rows to the Creature library! Let me know if it's not working!
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:
April 18, 2019
This title was added to our catalog on September 07, 2017.