Close
Close
Advanced Search

Dungeon Master Excel Toolkit

Dungeon Master Excel Toolkit

ADD TO WISHLIST >
ZIP File
$
Suggested Price $2.95

Over 2 years of development, 4500+ downloads, and 20+ ratings with an average rating of 4.8 stars!!!

"This tool alone has single-handedly given me the ability to create intresting encounters for entire dungeon runs in a fraction of my average time" ~  Trym S.

"This tool is a DM's best friend! It has never been easier to capture ciritcal player stats, set up a sequence of encounters, balance them for your party, track initiative and HP, assign experience points, and so much more." ~Austin T.

"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." ~Baelin D.

Thanks to everyone who has taken time to provide feedback in the discussion area of this title, and taken time to leave your kind words in the review section. Working on this project has been awesome, and I don't plan on stopping development anytime soon!


Encounter Builder 2.10.2

  • 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
    • Includes basic reference information for all WotC creatures, and creatures from Matt Colville's Strongholds & Followers 5e supplement. There is not enough information to fully run an encounter, so the source books are still necessary.
  • 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 using the built in form
  • 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.2
  • 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.
Inn and Tavern Generator 1.2
  • Procedurally generated inns and taverns are now at your fingertips
  • this generator creates detailed exteriors, interiors, and basic atmosphere for your most frequented establishments.
  • Editable name gnerator is also included
  • Best when paired with the NPC generator to create patrons, bartenders, and waitstaff.
Character Builder 2.3.1
  • 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.

Excel 2010 or greater required for full functionality with limited support available going back to excel 2007. Mac users may experience bugs, but I think i've ironed out the kinks for y'all.

 
 More from this Title's Contributors
 
 Customers Who Bought this Title also Purchased
Reviews (9)
Discussions (23)
Customer avatar
Giuseppe C March 15, 2020 11:14 am UTC
PURCHASER
hey the product looks great, but i keep getting automation error when opening on my mac. any ideas?
Customer avatar
Lincoln S March 16, 2020 9:20 pm UTC
CREATOR
Hey Guiseppe,

Let's see if we can't crack this. There's some questions that i ask everyone that's having some trouble to start with so let's get that out of the way.

What version of excel are you on?
Which spreadsheet are you opening?
What is the version number on that sheet?
Have you tried re downloading the sheet and starting clean?
What is the specific error that you are getting?

If you can tell me all that we will be off to a good start.

Thanks for reaching out!
Customer avatar
Jennifer L February 25, 2020 5:00 pm UTC
PURCHASER
Hey! I am trying to use the NPC generator on a Mac (MacOS 10.15.3, excel version 16.34), and I am getting the message "runtime error 6: Overflow" for every option (No/Cancel/Yes) after it displays the result from "Generate NPC". Any chance you would help me debug this? I'd like to use your tool, particularly because we have all custom races so the online NPC generators are useless for me, but I've never used visual basic.
Customer avatar
Lincoln S March 05, 2020 3:20 pm UTC
CREATOR
Hey Jennifer!

Yeah, hopefully we can get to the bottom of this. Have you changed anything on the sheet, or does this happen on first open? Have you tried redownloading it and starting fresh?
Customer avatar
Jennifer L February 17, 2020 9:41 pm UTC
PURCHASER
Wow. This is amazing. Thank you so much. I downloaded it to check it out yesterday, and I'm back to buy you an expensive coffee or a cheap beer. :-)

One question- is there a way to auto-populate the "readied encounter" tab with monsters from a saved encounter, or do I have to type them in? (MacOS 10.15.3, excel 16.34) Thanks!!!
Customer avatar
Jennifer L February 19, 2020 5:10 am UTC
PURCHASER
I went back to look today and found the "Ready" button on the "Encounter Builder" tab. "Clear" and "Ready" buttons on the "Readied Encounter" tab would be awesome!
Customer avatar
Lincoln S February 24, 2020 4:43 pm UTC
CREATOR
I'm glad you were able to find it! And I certainly appreciate that you came back to purchase!

I will look into that for future revisions, thank you for the feedback!
Customer avatar
jamie B February 08, 2020 6:32 pm UTC
PURCHASER
I keep getting a run error 1004?

Great resource though, love it
Customer avatar
Lincoln S February 17, 2020 2:47 pm UTC
CREATOR
Thanks, glad you like it! Let's see if we can't get that fixed.

Which sheet are you getting that on?
Which version of the sheet are you using?
What do you do right before the error comes up?
What version of Excel are you using?
Have you tried re-downloading the sheet and starting fresh?
Customer avatar
Kevin W January 14, 2020 5:03 pm UTC
PURCHASER
Really love this tool set, I don't know how I would run my game without it. I do have a question though. What is the drop down menu under the picture on the Encounter Builder for?
Customer avatar
Lincoln S January 14, 2020 5:15 pm UTC
CREATOR
Thanks for saying that! I appreciate it. That dropdown is for looking up creature names that you don't quite remember.

Excel data validation is very picky and doesn't autofill so I tried to replace all of those cells with combo boxes, but that was too laggy. Long story short, the dropdown below the picture is to help with looking up monsters because it autofills and is more userfriendly, but it's an imperfect solution.
Customer avatar
Kevin W January 14, 2020 5:40 pm UTC
PURCHASER
Ahh, yes that makes perfect sense. Thanks for the quick reply.
Customer avatar
Lincoln S January 16, 2020 1:45 pm UTC
CREATOR
No problem! Let me know if you need anything else.
Customer avatar
Anthony V December 05, 2019 5:27 am UTC
PURCHASER
hey guys. Having a brain fart. I cant alter any of the cells in the excel sheets. any help?
Customer avatar
Lincoln S December 10, 2019 10:06 pm UTC
CREATOR
When you first launched the sheet did you click "enable content"? That's the only thing I can think of right away that would prevent you from editing. None of the sheets should be protected either.

Did you try redownloading the sheet? Which sheets are giving you trouble? What version of the sheets? What version of excel are you using?

Thanks for dropping a line so I can help!
Customer avatar
Glen P October 28, 2019 5:55 pm UTC
PURCHASER
Hi!
First of all, want to say what a brilliant tool this is! Thank you for your hard work!
I come with a slight annoyance however, in that, when rolling the initiative, it automatically sorts PCs into order yet doesn't function for monsters? Any way I can resolve this?

Thanks in advance!
Customer avatar
Glen P October 28, 2019 6:05 pm UTC
PURCHASER
For further understanding of my issue, the roll button does not carry out its function, and manually entering numbers for initiative does not rectify the initiative order. Thanks
Customer avatar
Lincoln S October 29, 2019 4:01 pm UTC
CREATOR
Hey Glen!

What version of the spreadsheet are you using? Can you check to see what the "calculation options" on the formulas tab is set to? When you press f9 does the order update? When you say that the roll button doesn't work what happens when you press it?

Have you tried re downloading the sheet? Does the issue persist?

Let me know what you find!

Thanks for the nice review by the way!
Customer avatar
Glen P October 29, 2019 6:36 pm UTC
PURCHASER
Hi Lincoln!
Thank you for getting back to me. I re-downloaded the sheets and this time it works perfectly. I am wondering, however, that the time I attempted to use the function, I had loaded a saved encounter yet when I tried it without one it works perfectly. Also, I had added monsters to the library so maybe this has something to do with it?

Thanks
Customer avatar
Glen P October 29, 2019 7:52 pm UTC
PURCHASER
Lincoln,
Just to let you know and I don't understand Excel anywhere near enough, but the initiative for monsters works perfectly on non-saved encounters. I have added enemies to the library and it rolls and sorts for them, but not on any pre-redied encounter.
Hope this helps!

Thanks
Customer avatar
Gary J October 21, 2019 11:04 pm UTC
PURCHASER
If I want to add a custom race (or class) how would I go about getting it into the encounter builder?
Customer avatar
Lincoln S October 22, 2019 3:20 pm UTC
CREATOR
Unfortunately it's maybe not as easy as you were hoping. Admittedly, I have been meaning to add in an easy way to do this, but I keep putting it off. I'll make it a priority for the next version!

That being said, if you right click a tab (like the player manager tab for example) and click unhide you can unhide the "Character Lists" sheet. On that sheet there is a table for race and class. to add more races and classes you can enter it to the table here.

That's sort of a back end way to do it.
Customer avatar
Lincoln S November 18, 2019 8:48 pm UTC
CREATOR
Hey Gary! I added a button to unhide the sheet with all of the races and classes (as well as other stuff) for easy customization in version 2.10.

Let me know what you think!
Customer avatar
Jay R October 17, 2019 4:15 am UTC
PURCHASER
Hello! Love your work, easily worth what I donated, thank you! I second the request for a how-to video, especially on the Encounter Builder -- it looks really powerful, but a tad overwhelming in practice for a noob.

I am using Office365. When I loaded the NPC Generator and enabled macros I got Run-time error "1004" -- Method 'Width' of object '_Application' failed -- I clicked 'Find' but it wasn't obvious where the error was to this excel novice. However despite the error it seemed to run fine, so perhaps it's just a glitch.

I may assemble a list of questions about the Encounter Generator if I can't figure it out. Thanks for your work, this will improve my game!
Customer avatar
Lincoln S October 17, 2019 12:57 pm UTC
CREATOR
Hey Jay!

Yeah... that error will come up if you have excel in full screen mode when you open it. I'm working on a fix for the next release!

Thanks for the kind words! I actually just got the software i need for the how to video downloaded and I'm working on a script. Feel free to hit me up with any questions though!
Customer avatar
Lincoln S November 18, 2019 8:48 pm UTC
CREATOR
Hey Jay, in the most recent versions this should be fixed!
Customer avatar
Harry S August 03, 2019 9:33 pm UTC
PURCHASER
Hi there! I purchased this thing hoping it would help but I am completely Excel illiterate. I am trying to use the encounter builder sheet and everything seemed to be working until I got to character race. The drop down menu won't display anything and when I try to type the race it tells me "A user has restricted values that can be entered into this cell." Any clue what I am doing wrong? Thanks in advance.
Customer avatar
Lincoln S August 04, 2019 1:47 am UTC
CREATOR
Huh, so I am not sure what the problem is but maybe I can help troubleshoot with you. What version of excel are you using? Did you enable macros when prompted when you first opened the sheet? Which version of the sheet are you using? Have you tried re-downloading the sheet?
Customer avatar
Harry S August 04, 2019 10:22 pm UTC
PURCHASER
Sorry if I'm not much help. I don't know how to enable macros, so that may well be the problem. I'll do a Google search to see how to do that and let you know if that fixes it.
Version is Excel 2002 10.2614.2625 if that helps. Thanks for replying!
Customer avatar
Harry S August 04, 2019 10:45 pm UTC
PURCHASER
I found out how to enable macros but nothing has changed. I can input player name, character name, level, and everything until I get to Race. There is an arrow for a drop down but nothing happens when I click it, and no matter what race I type into the box, it throws that error.
I re-downloaded everything and unzipped the files. Opened up the Encounter Builder 2.8 sheet and it prompted me to enable macros, which I did. Then a Visual Basic window popped up and gave me: "Compile error: Method or data member not found." The script looks like it has something to do with the window sizing??? This only happens with the 2.8 version. 2.7 doesn't bring up the VB error.

Do you know if this will work in OpenOffice or Google Docs? Thanks.

Edit: On the "Trusted Sources" tab, the "Tryst access to Visual Basic Project" box is unchecked. I'll try that and see it anything changes.
Nevermind. It didn't help. =(
Customer avatar
Harry S August 05, 2019 10:54 am UTC
PURCHASER
I can indeed open it in OpenOffice but the same thing occurs. I can enable macros, but when I try to input Race it gives me "Error 502" which is "Invalid argument A function argument has an invalid value, e.g. a negative number for the root function." Any ideas what is causing this? Thanks.
Customer avatar
Lincoln S August 08, 2019 3:50 am UTC
CREATOR
Well I think we may have gotten to the bottom of it here. According to the compatibility report i just ran on the sheet you need to be using at least Excel 2010 for it to work properly (2007 works also but some of the conditional formatting will break.)

Excel 2003 and earlier cannot handle the table references that are critical to the function of this sheet (including the race cells.) I have never used OpenOffice, but it looks like that program only supports limited Macro usage and unfortunately these sheets use macros extensively so I can't support Open Office... I can however, confirm that this definitely will not work on google docs. I wish I could make this tool excel independent, and while I am working on teaching myself C# my skills are far too limited to fully replicate this tool at this time.

Sorry I wasn't able to help! I hope you can work something out, just remember that if you do decide to upgrade excel version 2010 appears to be the minimum compatible version.
Customer avatar
Harry S September 03, 2019 10:24 pm UTC
PURCHASER
Thanks for the info. Work has been busy so my campaign and everything associated with it have been on hold. I'll see about getting Excel upgraded. Thanks again!
Customer avatar
Lincoln S September 04, 2019 4:48 pm UTC
CREATOR
No problem! Glad I could answer your questions!
Customer avatar
Trym S July 08, 2019 9:42 pm UTC
PURCHASER
Hi, thanks a bunch for a great tool! I read through the discussions and I am aware that there are some errors on Mac, but perhaps you know a fix to my problem. In the player Manager sheet, when i try to look up items I get the following error: Run-time error (380) - could not set rowsource properly. invalid property value. Im using the the latest excel version for mac. I also have the same problem when i click view/load on build encounter sheet although a different error message: Run-time error -2147352571 (80020005):
Could not set columnWidths property. Could not complete the operation due to error 80020005.

Hope you can help, when you have the time :)
Thanks again for a great product.
Customer avatar
Lincoln S July 19, 2019 1:18 pm UTC
CREATOR
Hey Trym!

First of all, I saw your review and I appreciate the 5 stars even with the glitches, but unfortunately I don't have great news for you... As you know you're not the first person to have this bug. This is because the Mac version of Excel does not have the rowsource property in VBA and I didn't know this when I was coding the forms. There's nothing to fix on your end (unless you wanted to get in there and fix my code,) I have to do some re-coding on my end to fix this.

It's on my agenda, but I don't know when I'll be able to get in and fix everything. Hang tight, I'm traveling for work for the next three weeks and I might have some time in the hotel room to work on it! Ever since I graduated and started a full time job I haven't had as much time to work on the encounter manager now that I have so many other projects.
Customer avatar
Lincoln S July 27, 2019 2:37 am UTC
CREATOR
Hey Trym!

Great news! I've hopefully fixed all compatibility issues with the release of 2.8! Let me know if you still have problems.

Thanks again!
Customer avatar
Trym S August 30, 2019 3:39 pm UTC
PURCHASER
Thats great ill test it out and confirm
Customer avatar
Lincoln S November 18, 2019 8:50 pm UTC
CREATOR
Trym,

I fixed even more mac issues in the newest rev (2.10) so give that a look!
Customer avatar
Chas M July 07, 2019 11:48 pm UTC
PURCHASER
Just found this tool - just what I was hoping for. I use Excel 2016 for Mac. When I click "view/load" on the encounter builder, I get an error: "Run-time error '380'. Could not set the RowSource property. Invalid property value." When I debug, it goes to the "loadem" macro and highlights in yellow "EncounterBrowser.Show" under "Public Sub BrowseEncounters()" at bottom of code. I know very little about macros/VBA. I saw the tip about changing the list value with range(), but I did not see this text in the macros that I scanned. Can you help?
Customer avatar
Lincoln S July 19, 2019 1:11 pm UTC
CREATOR
Yeah, hey chase.

First of all, I'm glad to hear it's what you're looking for, but unfortunately I don't have great news for you. So you're not the first person to have this bug. This is because the Mac version of Excel does not have the rowsource attribute in VBA and I didn't know this when I was coding the forms. There's nothing to fix on your end, I have to do some re-coding to fix this.

It's on my agenda, but I don't know when I'll be able to get in and fix everything. Hang tight, I'm traveling for work for the next three weeks and I might have some time in the hotel room to work on it!
Customer avatar
Lincoln S July 27, 2019 2:37 am UTC
CREATOR
Hey Chas!

Great news! I've hopefully fixed all compatibility issues with the release of 2.8! Let me know if you still have problems.

Thanks again!

(p.s. sorry for calling you chase in my last comment!)
Customer avatar
Chas M August 21, 2019 1:21 pm UTC
PURCHASER
It works beautifully on my Mac - thank you! Great product, quick response. I purchased it for $5 based on the excellent customer support and attention to us Mac users. I have an Office 365 subscription, so the most recent version of Excel.
Customer avatar
Lincoln S August 27, 2019 9:13 pm UTC
CREATOR
Hey I appreciate it! You're helping fund my next DnD book purchase! Let me know if anything else goes wrong with it!
Customer avatar
Michael F May 20, 2019 12:56 am UTC
PURCHASER
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
Lincoln S May 23, 2019 1:59 pm UTC
CREATOR
Unfortunately short of creating a standalone app (which is well outside my wheelhouse) there is no way that i know of to run this outside of desktop excel....

Sorry about that! It would be pretty convenient to run off of a tablet though so i can see the appeal.

Also, thanks for the compliment! I appreciate it!
Customer avatar
Baelin D April 16, 2019 12:07 am UTC
PURCHASER
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
CREATOR
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
Lincoln S November 18, 2019 8:52 pm UTC
CREATOR
Hey Baelin,

It's been awhile since you posted. I wanted to check in and see if you got it working?
Customer avatar
Rob. G March 30, 2019 2:00 pm UTC
PURCHASER
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
CREATOR
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
PURCHASER
Is there a way to add homebrew creations to the encounter builder?
Customer avatar
Lincoln S April 03, 2019 7:14 pm UTC
CREATOR
Yes! You can just add more rows to the Creature library! Let me know if it's not working!
Customer avatar
Lincoln S November 05, 2019 8:55 pm UTC
CREATOR
Hey Ronald, I was checking on someone else's issue and I wanted to make sure that you saw that there's a form in the more recent versions of the sheet that allows for easy adding of creatures.
See 16 more
Narrow Results
 Follow Your Favorites!
NotificationsSign in to get custom notifications of new products!
 Recent History











Product Information
Electrum seller
Community Content
Author(s)
Rules Edition(s)
Format
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:
November 21, 2019
This title was added to our catalog on September 07, 2017.